{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ask & Acquire","Appraise","Appraise (print version)","Apply","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":36,"comments":0,"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":[[5,0,5,7],[0,0,0,7],[1,0,1,7],[2,1,2,4],[2,6,2,7],[4,0,4,7],[6,0,6,1],[6,2,6,7],[7,0,7,1],[7,2,7,7],[8,0,8,1],[8,2,8,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],[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]]}
["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":81,"n_cols":18,"rows_kept":81,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,4],[4,5,4,7],[24,7,24,10],[6,1,6,2],[6,3,6,6],[7,1,7,6],[13,1,13,6],[18,1,19,6],[4,8,4,9],[4,10,4,11],[5,11,5,21],[5,7,5,10],[9,7,9,10],[4,12,4,21],[7,7,7,10],[8,1,11,6],[11,8,11,9],[20,7,21,10],[18,7,19,8],[18,9,19,10],[6,11,6,21],[18,11,20,21],[21,11,29,21],[7,11,17,21],[14,8,14,9],[27,7,27,10],[10,8,10,9],[28,8,28,9],[80,17,80,20],[32,11,40,21],[43,11,49,21],[50,11,51,21],[33,7,33,10],[41,11,42,21],[52,11,61,21],[64,0,79,21],[62,0,63,21],[50,1,52,6],[29,1,34,6],[30,11,31,21],[41,0,49,0],[50,0,61,0],[35,0,40,0],[27,0,34,0],[37,1,40,6],[35,1,36,6],[35,7,61,10],[27,1,28,6],[5,0,26,0],[5,1,5,6],[13,8,13,9],[8,8,8,9],[12,1,12,6],[14,1,14,6],[15,1,17,6],[20,1,26,6],[12,8,12,9],[41,1,42,6],[43,1,49,6],[53,1,61,6]]}
["    ",null,null,null,null,null,null,null,null,null,"GATE Appraise - Systematic Reviews"]
["Notes for use:  Enter study numbers in yellow areas.  Help notes appear in movable boxes.  "]
["Enter study descriptions in orange areas.  The form calculates results and displays them in the green areas"]
["  Use the overflow tab to provide more detail if allocated space is insufficient"]
[null,"Assessed by:",null,null,null,"Assessed when:",null,null,null,null,"Publication details:"]
["FIND","META-ANALYSIS METHODS",null,null,null,null,null,"  STUDY NUMBERS - \nhang on GATE frame   ",null,null,null,"META-ANALYSIS ERRORS (FAITH)"]
[null,"Study types included:",null,null,null,null,null,null,null,null,null,"FIND were most relevant studies likely to have been found?"]
[null,"List study sources:"]
[null,null,null,null,null,null,null,null,"Study Sources"]
[]
[null,null,null,null,null,null,null,null,"Articles"]
[null,null,null,null,null,null,null,null,"screened"]
[null,"Describe eligibility criteria to screen studies using PECOT:"]
[]
[null,"Describe search strategy:"]
[]
[]
[]
[null,"Describe how studies screened? By whom? How many included/excluded?",null,null,null,null,null,"Included",null,"Excluded",null,"APPRAISE was assessment of the quality/validity of studies done well?"]
[]
[null,null,null,null,null,null,null,"Number of articles screened"]
[]
[]
[]
[null,null,null,null,null,null,null,"Number of articles appraised"]
[]
[]
["APPRAISE","Describe how the quality of studies meeting intial screening criteria was appraised ",null,null,null,null,null," Number of studies in final analyses"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"INCLUDE were reasons to include/exclude studies well justified?"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(cgall=\"\",\"\",IF(cgall>0,(1-cgfollow/cgall),0))","v":""}]
["INCLUDE","What reasons were given for including/excluding appaised studies in final analyses? How many were included/excluded?",null,null,null,null,null," "]
[]
[]
[]
[]
[]
["TOTAL","How were the study results summarised? Was a meta-analysis done? Were sensistivity analyses done?",null,null,null,null,null,null,null,null,null,"TOTAL were studies results pooled using standard meta-analyses methods?"]
[]
[]
[]
[]
[]
[]
[]
[]
["HETEROGENEITY","If meta-analysis done, how similar were studies? Were tests of heterogeneity done? What were the main Results?  ",null,null,null,null,null,null,null,null,null,"HETEROGENEITY were studies results similar enough to be pooled?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summary what were the main findings? Based in the FAITH criteria, are the findings valid? "]
[]
["1. Study design: was a valid, systematic, reproducible review methodology followed?  Was there likely to be important publication bias? Were the right studies included?\n\n\n2. Study analyses: were studies summarised (and/or combined) appropriately?\n\n\n3. Study numbers: random error sufficiently low (95% CI narrow) for results to be meaningful?\n \n\n4. Study effect estimates reported in paper: (e.g. OR, RR) sufficiently large to be real and meaningful?\n\n\n5. Generalisability: who are the findings likely to be applicable in practice?\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":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,0,2,2],[22,0,22,2],[34,0,34,2]]}
[null,"GATE Appraise Systematic reviews - print version"]
[null,"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 "]
["META-ANALYSIS METHODS"]
["Study types included"]
[null,{"$f":"IF(Appraise!D7<>\"\",Appraise!D7,\"\")","v":""}]
["List study sources:"]
[null,{"$f":"IF(Appraise!B9<>\"\",Appraise!B9,\"\")","v":""}]
["Describe eligibility criteria to screen studies using PECOT:"]
[null,{"$f":"IF(Appraise!B14<>\"\",Appraise!B14,\"\")","v":""}]
["Describe search strategy:"]
[null,{"$f":"IF(Appraise!B16<>\"\",Appraise!B16,\"\")","v":""}]
["Describe how studies screened? By whom? How many included/excluded?"]
[null,{"$f":"IF(Appraise!B21<>\"\",Appraise!B21,\"\")","v":""}]
["Describe how the quality of studies meeting intial screening criteria was appraised "]
[null,{"$f":"IF(Appraise!B30<>\"\",Appraise!B30,\"\")","v":""}]
["What reasons were given for including/excluding appaised studies in final analyses? How many were included/excluded?"]
[null,{"$f":"IF(Appraise!B38<>\"\",Appraise!B38,\"\")","v":""}]
["How were the study results summarised? Was a meta-analysis done? Were sensistivity analyses done?"]
[null,{"$f":"IF(Appraise!B44<>\"\",Appraise!B44,\"\")","v":""}]
["If meta-analysis done, how similar were studies? Were tests of heterogeneity done? What were the main Results?  "]
[null,{"$f":"IF(Appraise!B54<>\"\",Appraise!B54,\"\")","v":""}]
[]
["META-ANALYSIS ERRORS (FAITH)"]
["FIND were most relevant studies likely to have been found?"]
[null,{"$f":"IF(Appraise!L8<>\"\",Appraise!L8,\"\")","v":""}]
["APPRAISE was assessment of the quality/validity of studies done well?"]
[null,{"$f":"IF(Appraise!L22<>\"\",Appraise!L22,\"\")","v":""}]
["INCLUDE were reasons to include/exclude studies well justified?"]
[null,{"$f":"IF(Appraise!L33<>\"\",Appraise!L33,\"\")","v":""}]
["TOTAL were studies results pooled using standard meta-analyses methods?"]
[null,{"$f":"IF(Appraise!L44<>\"\",Appraise!L44,\"\")","v":""}]
["HETEROGENEITY were studies results similar enough to be pooled?"]
[null,{"$f":"IF(Appraise!L53<>\"\",Appraise!L53,\"\")","v":""}]
[]
["Summary - What were the main findings? Based in the FAITH criteria, are the findings valid? "]
[]
[null,{"$f":"Appraise!A65","v":"1. Study design: was a valid, systematic, reproducible review methodology followed?  Was there likely to be important publication bias? Were the right studies included?\r\r\r2. Study analyses: were studies summarised (and/or combined) appropriately?\r\r\r3. Study numbers: random error sufficiently low (95% CI narrow) for results to be meaningful?\r \r\r4. Study effect estimates reported in paper: (e.g. OR, RR) sufficiently large to be real and meaningful?\r\r\r5. Generalisability: who are the findings likely to be applicable in practice?\r"}]

{"sheet":"Apply","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[3,0,3,3],[4,0,4,3],[5,0,5,1],[5,2,5,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],[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]]}
["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"]