{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ask & Acquire","Appraise","Appraise (print version)","Apply","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":36,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ask & Acquire","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[24,0,24,7],[25,0,25,7],[26,0,26,7],[18,1,18,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[22,0,22,7],[23,0,23,7],[17,1,17,2],[9,0,9,1],[9,2,9,7],[10,0,10,1],[10,2,10,7],[11,0,11,1],[11,2,11,7],[12,0,12,7],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[6,0,6,1],[6,2,6,7],[7,0,7,1],[7,2,7,7],[8,0,8,1],[8,2,8,7],[5,0,5,7],[0,0,0,7],[1,0,1,7],[2,1,2,4],[2,6,2,7],[4,0,4,7]]}
["GATE  Ask & Acquire - for all study types"]
["Notes for use:  Enter text in yellow areas, replacing current text.  Help notes appear in movable boxes"]
["Assessed by:",null,null,null,null,"Date:"]
["Problem"]
["Describe the problem that led you to seek an answer from the literature (Replace the text in yellow areas on this sheet with your responses; you can increase the size of the yellow areas on this page by clicking on the line under the numbers on the left of the sheet and dragging down)  "]
["Step 1: Ask a focused 5-part question using PECOT framework \nnote : question doesn’t need to be grammatically correct sentence; main aim is to identify key terms for search (Step 2)\n"]
["State if question is your question or the study authors' question "]
["Population / patient / client",null,"Specify relevant patient/client/population group (be specific about: medical condition, age group, sex, etc.)"]
["Exposure (intervention/ target disorder/risk or prognostic factor) ",null,"Specify:  intervention(s) you want to find out about for RCTs & other intervention studies; OR Target disease/condition to be diagnosed for diagnostic test accuracy studies; OR risk/intervention factor for case-control studies: OR  risk/prognostic factor for cohort studies. Be reasonably specific\n"]
["Comparison\n(Control) \n",null,"Specify alternative intervention (e.g. nothing or usual care); OR typical health status of those without target disease/condition (e.g. disease free or other comorbidities) for diagnostic test accuracy studies; OR comparison factor you want to compare it with for case-control studies and cohort studies?"]
["Outcomes",null,"Specify: the relevant health/disease-related outcomes you would like to prevent/reduce for RCTs; the relevant test for diagnostic test accuracy studies; the relevant health/disease related outcome/s for case-control studies and cohort studies"]
["Time",null,"If appropriate, specify a relevant time period over which outcomes likely to occu. Time is not usually considered explicitly in a diagnostic test accuracy question.   "]
["Step 2: Acquire (search for) the best evidence using the PECOT framework "]
["PECOT item","Primary Search term",null,null,"Synonym 1",null,"Synonym 2"]
["Population / Participants / patients / clients","Enter key search terms Use MESH terms (from PubMed) if available, then text words.",null,"OR","Include relevant synonym \n\n","OR","Include relevant synonym \n\n","AND"]
["Exposure (Interventions)","As above",null,"OR","As above\n\n","OR","As above\n\n","AND"]
["Comparison (Control)","As above",null,"OR","As above\n\n","OR","As above\n\n","AND"]
["Outcomes","As above",null,"OR","As above\n\n","OR","As above\n\n","AND"]
["Time","Entry generally not required for search"]
["Limits & Filters: "]
["PubMed has Limits (e.g. age, English language, years) & PubMed Clinical Queries has Filters (e.g. study type) to help focus your search. List if used."]
["Databases searched and number of publications by database and whether a review or individual paper: "]
["List databases searched and number of reviews/individual papers per database: e.g. Cochrane, standard PubMed, Clinical Queries in PubMed, Google scholar etc"]
["Evidence Selected"]
["Enter full citation of publication you have selected/or been given to evaluate"]
["Justification for selection"]
["State main objectives of the study.\n\nExplain why you chose this publication for evaluation."]
[null,null,null,null,null,"Please contribute your comments and suggestions on this form to: ","rt.jackson@auckland.ac.nz"]

{"sheet":"Appraise","index":1,"n_rows":94,"n_cols":20,"rows_kept":94,"cut":false,"hidden":false,"merged":[[77,0,79,21],[69,0,70,21],[71,0,71,21],[56,0,67,0],[35,1,36,6],[73,11,73,12],[73,18,73,19],[58,9,58,11],[37,1,38,6],[43,11,44,21],[45,11,47,21],[57,12,57,14],[39,1,51,6],[63,1,63,4],[41,11,42,21],[18,8,19,8],[14,8,14,9],[13,11,15,21],[93,17,93,20],[58,12,58,14],[58,15,58,17],[59,18,59,20],[68,0,68,21],[75,0,75,21],[80,0,82,21],[61,5,61,6],[58,5,58,8],[57,1,58,4],[83,0,85,21],[66,2,66,3],[73,4,73,6],[20,1,26,6],[18,0,34,0],[22,11,25,21],[27,7,27,10],[27,1,28,6],[33,11,34,21],[20,7,21,8],[16,11,18,21],[19,11,21,21],[26,11,27,21],[28,11,29,21],[8,0,17,0],[10,7,10,10],[8,11,10,21],[20,9,21,10],[18,9,19,9],[7,11,7,21],[11,11,12,21],[62,23,64,24],[56,18,58,21],[61,20,61,21],[64,20,64,21],[56,5,56,11],[56,12,56,17],[57,5,57,8],[57,9,57,11],[57,15,57,17],[30,7,30,10],[38,11,40,21],[35,7,35,10],[35,11,37,21],[18,1,19,6],[30,11,32,21],[29,1,34,6],[8,7,8,10],[5,12,5,21],[6,1,6,6],[5,1,5,2],[5,3,5,4],[5,5,5,7],[5,8,5,9],[5,10,5,11],[16,1,17,6],[10,1,12,6],[13,1,15,6],[8,1,9,6],[6,7,6,10],[6,11,6,21],[31,8,31,9],[53,9,53,12],[2,1,2,18],[6,0,7,0],[89,0,92,21],[48,11,51,21],[46,7,46,10],[52,0,54,0],[64,5,64,6],[67,5,67,6],[65,18,67,20],[35,0,51,0],[86,0,88,21],[7,1,7,2],[7,3,7,6],[33,7,33,10]]}
["    ",null,null,null,null,null,null,null,null,null,"GATE Appraise -Prognostic Cohort Studies"]
[null,"Notes for use:  Enter study numbers in yellow areas.  Help notes appear in movable boxes.  "]
[null,"Enter study descriptions in orange areas. Don't overwrite headings in orange areas as headings & all text is replicated on overflow sheet  "]
[null,"The form calculates results and displays them in the green areas"]
[null,"Use the button at right to create more Appraise sheets and associated Overflow sheets"]
[null,"Assessed by:",null,null,null,"Assessed when:",null,null,null,null,"Publication details:"]
[null,"STUDY DESIGN (PECOT)",null,null,null,null,null,"  STUDY NUMBERS - \nhang on GATE frame   ",null,null,null,"STUDY ERRORS (RAMBOMAN)"]
[null,"Study type:",null,null,null,null,null,null,null,null,null,"Recruitment appropriate to study goals / able to define who findings applicable to?"]
["Population","Describe Setting:  (double click here in the brackets, to right of bolded heading to add text -write over these instructions, but not the bolded headings)  ",null,null,null,null,null,"Study Setting",null,null,null,"Setting & eligible population appropriate to goals & sufficiently well described ?"]
[]
[null,"Describe Eligibility criteria:",null,null,null,null,null,"Eligible population"]
[null,null,null,null,null,null,null,null,null,null,null,"Participants likely to be reasonably similar to all Eligibles? "]
[null,null,null,null,null,null,null,null,"Participant"]
[null,"Describe Recruitment (sampling) process:",null,null,null,null,null,null,"sample",null,null,"Participants at a common point in course of disease/condition ?"]
[]
[]
[null,"% of invited eligibles who participated:",null,null,null,null,null,null,null,null,null,"Risk/prognostic profiles sufficiently described to define who findings applicable to?"]
[]
["Exposure & Comparison","EG=Exposure (Prognostic factor) Grp",null,null,null,null,null,null,"(EG)","(CG)"]
[null,null,null,null,null,null,null,null,null,null,null," Allocation to EG & CG done well?"]
[null,"Describe Exposure: how defined & measured:",null,null,null,null,null,"EG allocated ",null," CG allocated"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Prognostic factors sufficiently well defined and  measured to allocate participants to correct groups? "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Prognostic factors measured prior to outcomes occurring ?"]
[null,"CG =  Comparison Group",null,null,null,null,null,"denominator numbers used in analyses"]
[null,null,null,null,null,null,null,null,null,null,null,"Prognostic factors meaningful in usual practice ?"]
[null,"Describe Comparison: how defined & measured:"]
[null,null,null,null,null,null,null,"denominator: people or person-years?",null,null,null,"Maintenance in allocated groups during study sufficient? Errors low enough for results to be valid? "]
[]
[]
[null,null,null,null,null,null,null,"Percentage lost to follow-up",null,null,null,"Completeness of follow-up high enough and similar in EG & CG ? "]
[]
["Outcomes & Time","O = Outcomes: list outcomes relevant to prognostic factor",null,null,null,null,null,"Categorical outcomes",null,null,null,"Changes in prognostic factors In EG & CG during follow-up sufficiently low ?"]
[null,null,null,null,null,null,null,"a",null,null,"b"]
[null,"T = Time when outcomes counted (at what point in time or over what time period)",null,null,null,null,null,"+  "]
[null,null,null,null,null,null,null,null,null,null,null,"EG & CG treated similarly during follow-up ?"]
[null,"Describe Outcomes & Time: how defined & how / by whom / when identified: "]
[null,null,null,null,null,null,null,"-  "]
[null,null,null,null,null,null,null,null,null,null,null,"Participants/Investigators blind to EG/CG status ?"]
[null,null,null,null,null,null,null,"c",null,null,"d"]
[null,null,null,null,null,null,null,null,null,null,null,"Blind and Objective Outcome measures?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Outcomes measured accurately enough ?"]
[null,null,null,null,null,null,null,"Numerical outcomes"]
[null,null,null,null,null,null,null,null,null,null,"mean"]
[null,null,null,null,null,null,null,null,null,null,"std dev","Follow-up time similar in EG & CG and sufficient to be meaningful ?"]
[null,null,null,null,null,null,null,"or",null,null,"std error"]
[]
[]
[]
[null,null,null,null,null,"Report results per (e.g. per 100):",null,null,1000,"persons(or person-years)"]
[]
[null,"Calculated Results (unadjusted) with",null,null,null,null,null,95,"% confidence intervals",null,null,null,null,null,null,"Z-score:",{"$f":"NORMSINV(1-((100-ci)/100)/2)","v":1.9599639845400536}]
["Calculated in GATE frame",null,null,{"$f":"TINV((100-ci)/100,egfollow+cgfollow-2)","v":{"$error":"#NUM!"}},null,{"$f":"\"Occurrence per \" & per & \" \" & \"persons (or p-y)\"","v":"Occurrence per 1000 persons (or p-y)"},null,null,null,null,null,null,{"$f":"\"Effect estimates\"","v":"Effect estimates"}]
[null,"Outcome: ",null,null,null,"in exposure group",null,null,null,"in comparison group",null,null,"Relative effect",null,null,"Absolute effect"]
[null,null,null,null,null,"(EGO)",null,null,null,"(CGO)",null,null," (EGO/CGO)",null,null," (EGO-CGO)"]
[null,"Categorical outcome:"]
[null,"Intention to follow-up analyses",null,null,null,null,null,{"$f":"IF(aa=\"\",\"\",IF(egall=0,\"\",per*aa/egall))","v":""},null,null,{"$f":"IF(bb=\"\",\"\",IF(cgall=0,\"\",per*bb/cgall))","v":""},null,null,{"$f":"IF(ittego=\"\",\"\",IF(ittcgo=0,\"\",IF(ittcgo=\"\",\"\",ittego/ittcgo)))","v":""},null,null,{"$f":"IF(ittego=\"\",\"\",IF(ittcgo=\"\",\"\",ittego-ittcgo))","v":""}]
[null,null,null,{"$f":"ci & \"% CIs\"","v":"95% CIs"},null,{"$f":"IF(aa=\"\",\"\",IF(egall=0,\"\",per*(2*aa+zscore^2-zscore*SQRT(zscore^2+4*aa*(1-aa/egall)))/(2*(egall+zscore^2))))","v":""},null,{"$f":"IF(F62<>I62,\"to\",\"\")","v":""},{"$f":"IF(aa=\"\",\"\",IF(egall=0,\"\",per*(2*aa+zscore^2+zscore*SQRT(zscore^2+4*aa*(1-aa/egall)))/(2*(egall+zscore^2))))","v":""},{"$f":"IF(bb=\"\",\"\",IF(cgall=0,\"\",per*(2*bb+zscore^2-zscore*SQRT(zscore^2+4*bb*(1-bb/cgall)))/(2*(cgall+zscore^2))))","v":""},{"$f":"IF(J62<>L62,\"to\",\"\")","v":""},{"$f":"IF(bb=\"\",\"\",IF(cgall=0,\"\",per*(2*bb+zscore^2+zscore*SQRT(zscore^2+4*bb*(1-bb/cgall)))/(2*(cgall+zscore^2))))","v":""},{"$f":"IF(ittego=\"\",\"\",IF(ittcgo=0,\"\",IF(ittcgo=\"\",\"\",EXP(LN(ittego/ittcgo) - zscore*SQRT(1/aa+1/bb-1/egall-1/cgall)))))","v":""},{"$f":"IF(M62<>O62,\"to\",\"\")","v":""},{"$f":"IF(ittego=\"\",\"\",IF(ittcgo=0,\"\",IF(ittcgo=\"\",\"\",EXP(LN(ittego/ittcgo) + zscore*SQRT(1/aa+1/bb-1/egall-1/cgall)))))","v":""},{"$f":"IF(ittego=\"\",\"\",IF(ittcgo=\"\",\"\",ittego-ittcgo - per*zscore*SQRT(aa*(egall-aa)/egall^3+bb*(cgall-bb)/cgall^3)))","v":""},{"$f":"IF(P62<>R62,\"to\",\"\")","v":""},{"$f":"IF(ittego=\"\",\"\",IF(ittcgo=\"\",\"\",ittego-ittcgo + per*zscore*SQRT(aa*(egall-aa)/egall^3+bb*(cgall-bb)/cgall^3)))","v":""},null,{"$f":"IF(S62=U62,\"\",IF(U62<=T61,IF(T61<=S62,\"to\",\"to ∞ to\"),\"to ∞ to\"))","v":""}]
[null,"Categorical outcome:"]
[null,"From numbers used in analyses",null,null,null,null,null,{"$f":"IF(aa=\"\",\"\",IF(egfollow=0,\"\",per*aa/egfollow))","v":""},null,null,{"$f":"IF(bb=\"\",\"\",IF(cgfollow=0,\"\",per*bb/cgfollow))","v":""},null,null,{"$f":"IF(otego=\"\",\"\",IF(otcgo=0,\"\",IF(otcgo=\"\",\"\",otego/otcgo)))","v":""},null,null,{"$f":"IF(otego=\"\",\"\",IF(otcgo=\"\",\"\",otego-otcgo))","v":""}]
[null,null,null,{"$f":"ci & \"% CIs\"","v":"95% CIs"},null,{"$f":"IF(aa=\"\",\"\",IF(egfollow=0,\"\",per*(2*aa+zscore^2-zscore*SQRT(zscore^2+4*aa*(1-aa/egfollow)))/(2*(egfollow+zscore^2))))","v":""},null,{"$f":"IF(F65<>I65,\"to\",\"\")","v":""},{"$f":"IF(aa=\"\",\"\",IF(egfollow=0,\"\",per*(2*aa+zscore^2+zscore*SQRT(zscore^2+4*aa*(1-aa/egfollow)))/(2*(egfollow+zscore^2))))","v":""},{"$f":"IF(bb=\"\",\"\",IF(cgfollow=0,\"\",per*(2*bb+zscore^2-zscore*SQRT(zscore^2+4*bb*(1-bb/cgfollow)))/(2*(cgfollow+zscore^2))))","v":""},{"$f":"IF(J65<>L65,\"to\",\"\")","v":""},{"$f":"IF(bb=\"\",\"\",IF(cgfollow=0,\"\",per*(2*bb+zscore^2+zscore*SQRT(zscore^2+4*bb*(1-bb/cgfollow)))/(2*(cgfollow+zscore^2))))","v":""},{"$f":"IF(otego=\"\",\"\",IF(otcgo=0,\"\",IF(otcgo=\"\",\"\",EXP(LN(otego/otcgo) - zscore*SQRT(1/aa+1/bb-1/egfollow-1/cgfollow)))))","v":""},{"$f":"IF(M65<>O65,\"to\",\"\")","v":""},{"$f":"IF(otego=\"\",\"\",IF(otcgo=0,\"\",IF(otcgo=\"\",\"\",EXP(LN(otego/otcgo) + zscore*SQRT(1/aa+1/bb-1/egfollow-1/cgfollow)))))","v":""},{"$f":"IF(otego=\"\",\"\",IF(otcgo=\"\",\"\",otego-otcgo - per*zscore*SQRT(aa*(egfollow-aa)/egfollow^3+bb*(cgfollow-bb)/cgfollow^3)))","v":""},{"$f":"IF(P65<>R65,\"to\",\"\")","v":""},{"$f":"IF(otego=\"\",\"\",IF(otcgo=\"\",\"\",otego-otcgo + per*zscore*SQRT(aa*(egfollow-aa)/egfollow^3+bb*(cgfollow-bb)/cgfollow^3)))","v":""},null,{"$f":"IF(S85=U65,\"\",IF(U65<=T64,IF(T64<=S65,\"to\",\"to ∞ to\"),\"to ∞ to\"))","v":""}]
[null,"Numerical outcome:"]
[null,null,"Analysis of means",null,null,null,null,{"$f":"IF(emean=\"\",\"\",emean)","v":""},null,null,{"$f":"IF(cmean=\"\",\"\",cmean)","v":""},null,null,{"$f":"IF(cmean<>0,IF(emean/cmean>0,emean/cmean,\"N/A\"),\"\")","v":""},null,null,{"$f":"IF(emean=\"\",\"\",IF(cmean=\"\",\"\",emean-cmean))","v":""}]
[null,null,null,{"$f":"ci & \"% CIs\"","v":"95% CIs"},null,{"$f":"IF(AND(ese=\"\",esdev=\"\"),\"\",IF(emean=\"\",\"\",emean - zscore*IF(ese>0,ese,esdev/SQRT(egfollow))))","v":""},null,{"$f":"IF(F68<>I68,\"to\",\"\")","v":""},{"$f":"IF(AND(ese=\"\",esdev=\"\"),\"\",IF(emean=\"\",\"\",emean + zscore*IF(ese>0,ese,esdev/SQRT(egfollow))))","v":""},{"$f":"IF(AND(cse=\"\",csdev=\"\"),\"\",IF(cmean=\"\",\"\",cmean-zscore*IF(cse>0,cse,csdev/SQRT(cgfollow))))","v":""},{"$f":"IF(J68<>L68,\"to\",\"\")","v":""},{"$f":"IF(AND(cse=\"\",csdev=\"\"),\"\",IF(cmean=\"\",\"\",cmean + zscore*IF(cse>0,cse,csdev/SQRT(cgfollow))))","v":""},{"$f":"IF(OR(AND(ese=\"\",esdev=\"\"),AND(cse=\"\",csdev=\"\")),\"\",IF(cmean=\"\",\"\",IF(rm=\"N/A\",\"N/A\",MAX(0,rm-(TINV((100-ci)/100,egfollow+cgfollow-2)*rm*SQRT(IF(ese>0,ese,IF(esdev>0,esdev/SQRT(egfollow),))^2/meg^2+IF(cse>0,cse,IF(csdev>0,csdev/SQRT(cgfollow),))^2/mcg^2))))))","v":""},{"$f":"IF(M68<>O68,\"to\",\"\")","v":""},{"$f":"IF(OR(AND(ese=\"\",esdev=\"\"),AND(cse=\"\",csdev=\"\")),\"\",IF(cmean=\"\",\"\",IF(rm=\"N/A\",\"N/A\",rm +(TINV((100-ci)/100,egfollow+cgfollow-2)*rm*SQRT(IF(ese>0,ese,IF(esdev>0,esdev/SQRT(egfollow),))^2/meg^2 + IF(cse>0,cse,IF(csdev>0,csdev/SQRT(cgfollow),))^2/mcg^2)))))","v":""},{"$f":"IF(OR(AND(ese=\"\",esdev=\"\"),AND(cse=\"\",csdev=\"\")),\"\",IF(cmean=\"\",\"\",md -(TINV((100-ci)/100,egfollow+cgfollow-2)*SQRT(IF(ese>0,ese,IF(esdev>0,esdev/SQRT(egfollow),))^2 + IF(cse>0,cse,IF(csdev>0,csdev/SQRT(cgfollow),))^2))))","v":""},{"$f":"IF(P68<>R68,\"to\",\"\")","v":""},{"$f":"IF(OR(AND(ese=\"\",esdev=\"\"),AND(cse=\"\",csdev=\"\")),\"\",IF(cmean=\"\",\"\",md +(TINV((100-ci)/100,egfollow+cgfollow-2)*SQRT(IF(ese>0,ese,IF(esdev>0,esdev/SQRT(egfollow),))^2 + IF(cse>0,cse,IF(csdev>0,csdev/SQRT(cgfollow),))^2))))","v":""}]
["Reported Results (write in main results reported in paper and if different from results calculated above, comment on why)"]
[]
[]
["Analysis"]
[]
[null,null,null,"Intention to follow-up analyses? ",null,null,null,null,null,null,"Adjusted if EG & CG different? ",null,null,null,null,null,null,"95% CIs or p-values given? "]
[]
["Summary"]
[]
["1. Study design (AMBOM): non-random error/bias sufficiently low for study to be valid? - consider amount & direction of bias:\n\n"]
[]
[]
["2. Study analyses (AN): analytical error sufficiently low for results to be valid? - were ITF analyses done? were adjusted analyses done if EG & CG diiferent at baseline?"]
[]
[]
["3. Study numbers reported in paper: random error sufficiently low (95% CI narrow) for results to be meaningful? if no statistically significant effects, was study power sufficiently high?\n\n"]
[]
[]
["4. Study effect estimates reported in paper: (e.g. RD, RR) sufficiently large to be real and meaningful?\n\n"]
[]
[]
["5. Generalisability (R):  if 1-4 ok, who are findings likely to be applicable in practice?\n\n\n"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please contribute your comments and suggestions on this form to: ","rt.jackson@auckland.ac.nz"]

{"sheet":"Appraise (print version)","index":2,"n_rows":83,"n_cols":3,"rows_kept":83,"cut":false,"hidden":false,"merged":[[70,0,70,2],[25,0,25,2],[60,0,60,2],[2,0,2,2],[1,0,1,2]]}
[null,"GATE Appraise - Prognostic Cohort Studies - print version"]
["This sheet replicates the text from GATE Appraise.  If macros on, text boxes atomatically expand with additional text. Otherwise can be done manually. But only enter text on main appraise sheet "]
["STUDY QUESTION & DESIGN - describe with PECOT"]
["P - Participants"]
[null,{"$f":"Appraise!B9","v":"Describe Setting:  (double click here in the brackets, to right of bolded heading to add text -write over these instructions, but not the bolded headings)  "}]
[]
[null,{"$f":"Appraise!B11","v":"Describe Eligibility criteria:"}]
[]
[null,{"$f":"Appraise!B14","v":"Describe Recruitment (sampling) process:"}]
[]
[null,{"$f":"Appraise!B17","v":"% of invited eligibles who participated:"}]
[]
["EG - Exposed Group [Prognostic factor]"]
[]
[null,{"$f":"Appraise!B21","v":"Describe Exposure: how defined & measured:"}]
[]
["CG = Comparison Group"]
[]
[null,{"$f":"Appraise!B30","v":"Describe Comparison: how defined & measured:"}]
[]
["O=Outcomes"]
["T - Time when outcomes counted (at what point in time or over what time period)"]
[]
[null,{"$f":"Appraise!B40","v":"Describe Outcomes & Time: how defined & how / by whom / when identified: "}]
[]
["STUDY ERRORS - assess using RAMBOMAN"]
["Recruitment appropriate to study goals / able to define who finidings applicable to?"]
[]
[null,{"$f":"Appraise!L9","v":"Setting & eligible population appropriate to goals & sufficiently well described ?"}]
[]
[null,{"$f":"Appraise!L12","v":"Participants likely to be reasonably similar to all Eligibles? "}]
[]
[null,{"$f":"Appraise!L14","v":"Participants at a common point in course of disease/condition ?"}]
[]
[null,{"$f":"Appraise!L17","v":"Risk/prognostic profiles sufficiently described to define who findings applicable to?"}]
[]
["Allocation to EG & CG done well?"]
[]
[null,{"$f":"Appraise!L23","v":"Prognostic factors sufficiently well defined and  measured to allocate participants to correct groups? "}]
[]
[null,{"$f":"Appraise!L27","v":"Prognostic factors measured prior to outcomes occurring ?"}]
[]
[null,{"$f":"Appraise!L29","v":"Prognostic factors meaningful in usual practice ?"}]
[]
["Maintenance in allocated groups & on allocated interventions/exposures during study sufficient?"]
[]
[null,{"$f":"Appraise!L34","v":"Completeness of follow-up high enough and similar in EG & CG ? "}]
[]
[null,{"$f":"Appraise!L36","v":"Changes in prognostic factors In EG & CG during follow-up sufficiently low ?"}]
[]
[null,{"$f":"Appraise!L39","v":"EG & CG treated similarly during follow-up ?"}]
[]
[null,{"$f":"Appraise!L42","v":"Participants/Investigators blind to EG/CG status ?"}]
[]
["Blind and Objective measures?"]
[]
[null,{"$f":"Appraise!L46","v":"Outcomes measured accurately enough ?"}]
[]
[null,{"$f":"Appraise!L49","v":"Follow-up time similar in EG & CG and sufficient to be meaningful ?"}]
[]
["Analysis"]
["Reported results"]
[null,{"$f":"IF(ISBLANK(Appraise!A70),\"\",Appraise!A70)","v":""}]
["Intention to follow-up analyses? "]
[null,{"$f":"IF(ISBLANK(Appraise!E74),\"\",Appraise!E74)","v":""}]
["Adjusted if EG & CG different? "]
[null,{"$f":"IF(ISBLANK(Appraise!L74),\"\",Appraise!L74)","v":""}]
["95% Cis or p-values given? "]
[null,{"$f":"IF(ISBLANK(Appraise!S74),\"\",Appraise!S74)","v":""}]
[]
["Summary"]
[]
[null,{"$f":"Appraise!A78","v":"1. Study design (AMBOM): non-random error/bias sufficiently low for study to be valid? - consider amount & direction of bias:\r\r"}]
[]
[null,{"$f":"Appraise!A81","v":"2. Study analyses (AN): analytical error sufficiently low for results to be valid? - were ITF analyses done? were adjusted analyses done if EG & CG diiferent at baseline?"}]
[]
[null,{"$f":"Appraise!A84","v":"3. Study numbers reported in paper: random error sufficiently low (95% CI narrow) for results to be meaningful? if no statistically significant effects, was study power sufficiently high?\r\r"}]
[]
[null,{"$f":"Appraise!A87","v":"4. Study effect estimates reported in paper: (e.g. RD, RR) sufficiently large to be real and meaningful?\r\r"}]
[]
[null,{"$f":"Appraise!A90","v":"5. Generalisability (R):  if 1-4 ok, who are findings likely to be applicable in practice?\r\r\r"}]
[]
["Please contribute your comments and suggestions on this form to: ",null,"rt.jackson@auckland.ac.nz"]

{"sheet":"Apply","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,3],[9,0,9,1],[9,2,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3],[6,0,6,1],[6,2,6,3],[7,0,7,1],[7,2,7,3],[8,0,8,1],[8,2,8,3],[0,0,0,3],[1,0,1,3],[3,0,3,3],[4,0,4,3],[5,0,5,1],[5,2,5,3]]}
["GATE Apply - for all study types"]
["Notes for use:  Enter text in yellow areas"]
["Assessed by:",null,"Date:"]
["Step 4: Apply. Consider/weigh up all factors & make (shared) decision(s) to act"]
["The X-Factor"]
[]
["Epidemiological evidence: are the results of this study consistent with other epidemiological evidence relevant to the decision(s) (e.g. ideally from systematic reviews)?  ",null,"What Case circumstances (e.g. disease process/ co-morbidities /social situation) specifically related to the problem may impact on the decision(s)? "]
[" (Replace this text; you can increase the size of the yellow areas on this sheet by clicking on the line under the numbers on the left of the sheet and dragging down)"]
["System features: are there any system constraints or enablers that may impact on the decision(s)?  ",null,"What Values & Preferences may need to be considered in making the decision(s)?  "]
[]
["Decision(s): taking into account all the factors above what is the best decision(s) for this problem?     "]
[]
["Step 5: What are the implications of this decision(s) for practice?\n"]
["What are the wider considerations of this decision(s) for usual practice? Should it change usual practice in any way? "]
[]
[null,null,"Please contribute your comments and suggestions on this form to: ","rt.jackson@auckland.ac.nz"]

{"sheet":"Instructions","index":4,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,0,9,2],[11,0,13,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2]]}
["To make extra copies of sheet,"]
["  unprotect workbook (Menu: Tools: Protection: Unprotect), then"]
["  copy sheet (Menu: Edit: Move or Copy sheet: Create a copy)"]
[]
[]
[]
[]
["To go to a new line within a text box, use the combination keys Alt-Enter."]
[]
[]
[]
["Pop-up boxes can be moved by clicking and dragging them"]