{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["template","rawdata","saveddata","Output table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"template","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[21,1,21,3],[23,1,23,3],[31,1,31,3],[32,1,32,3],[1,1,1,3],[7,1,7,3],[13,1,13,3]]}
[]
[null,"  Data collection tool: Preventing ill health by risky behaviours  alcohol and tobacco"]
[]
[null,null,null,"Enter data here "]
[]
[null,"Unique Identifier",null,null,1,1]
[]
[null,"TOBACCO"]
[]
[null,"Did the patient receive a tobacco screen?"]
[]
[null,"Is the patient a current smoker?"]
[]
[null,"If no above then end tobacco questions "]
[]
[null,"Was the patient given brief advice?",null,null,null,null," "]
[]
[null,"Was the patient offered a referral to a specialist service and offered medication?"]
[]
[null,"Did the patient accept the offer and was the referral made?"]
[]
[]
[]
[null,"ALCOHOL "]
[]
[null,"Did the patient receive an alcohol screen?"]
[]
[null,"Did the patient screen positive for drinking above low risk levels, but not dependent levels?"]
[]
[null,"Did the patient screen positive for potentially dependent drinking?"]
[]
[null,"If no to both alcohol questions above then end alcohol questions "]
[]
[null,"Was the patient given brief advice? "]
[]
[null,"Was the patient offered a referral to specialist services?"]
[]
[null,"Did the patient accept the offer and was the referral made?"]

{"sheet":"rawdata","index":1,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":true,"merged":[[4,2,4,3]]}
[]
[null," For all questions: (Yes=1, No=2)"]
[null,"Unique Identifier","Did the patient receive a tobacco screen?","Is the patient a current smoker?","Was the patient given brief advice?","Was the patient offered a referral to a specialist service and offered medication?","Did the patient accept the offer and was the referral made?","Did the patient receive an alcohol screen?","Did the patient screen positive for increasing risk drinking?","Did the patient screen positive for potentially dependent drinking?","Was the patient given brief advice? ","Was the patient offered a referral to specialist services?","Did the patient accept the offer and was the referral made?"]
[null,{"$f":"template!D6","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"saveddata","index":2,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Unique Identifier","Did the patient receive a tobacco screen?","Is the patient a current smoker?","Was the patient given brief advice?","Was the patient offered a referral to a specialist service and offered medication?","Did the patient accept the offer and was the referral made?","Did the patient receive an alcohol screen?","Did the patient screen positive for increasing risk drinking?","Did the patient screen positive for potentially dependent drinking?","Was the patient given brief advice? ","Was the patient offered a referral to specialist services?","Did the patient accept the offer and was the referral made?"]

{"sheet":"Output table","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,1,1,3],[12,4,12,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5]]}
[]
[null,"SUMMARY"]
[null,null,"Number","Percentage"]
[null,"Number of unique admissions sampled ",{"$f":"COUNTA(saveddata!B4:B1048576)","v":0}]
[null,"9a. Percentage of unique adult patients who are screened for smoking status AND whose results are recorded.",{"$f":"COUNTIF(saveddata!C4:C1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C5/C4),0,C5/C4)","v":0}]
[null,"Number of screened patients who smoke",{"$f":"COUNTIFS(saveddata!D4:D1048576,\"YES\",saveddata!C4:C1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C6/C5),0,C6/C5)","v":0}]
[null,"9b. Percentage of unique patients who smoke AND are given very brief advice",{"$f":"COUNTIFS(saveddata!E4:E1048576,\"YES\",saveddata!C4:C1048576,\"YES\",saveddata!D4:D1048576,\"YES\")","v":0},0]
[null,"9c. Percentage of unique patients who are smokers AND are referred to stop smoking services AND offered stop smoking medication.",{"$f":"COUNTIFS(saveddata!F4:F1048576,\"YES\",saveddata!G4:G1048576,\"YES\",saveddata!C4:C1048576,\"YES\",saveddata!D4:D1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C8/C6),0,C8/C6)","v":0}]
[null,"9d. Percentage of unique adult patients who are screened for drinking risk levels AND whose results are recorded in local data systems.",{"$f":"COUNTIF(saveddata!H4:H1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C9/C4),0,C9/C4)","v":0}]
[null,"Number of screened patients drinking above low risk levels (but not dependent levels)",{"$f":"COUNTIFS(saveddata!I4:I1048576,\"YES\",saveddata!J4:J1048576,\"NO\",saveddata!H4:H1048576,\"YES\")","v":0},0]
[null,"Number of patients drinking above low risk levels (but not dependent levels), given brief advice",{"$f":"COUNTIFS(saveddata!K4:K1048576,\"YES\",saveddata!J4:J1048576,\"NO\",saveddata!I4:I1048576,\"YES\",saveddata!H4:H1048576,\"YES\")","v":0},0]
[null,"Number of screened patients drinking at possible dependent levels",{"$f":"COUNTIFS(saveddata!J4:J1048576,\"YES\",saveddata!I4:I1048576,\"NO\",saveddata!H4:H1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C12/C9),0,C12/C9)","v":0}]
[null,"Number of patients that are drinking at possible dependent levels that are offered a referral to a specialist alcohol service",{"$f":"COUNTIFS(saveddata!J4:J1048576,\"YES\",saveddata!I4:I1048576,\"NO\",saveddata!L4:L1048576,\"YES\",saveddata!H4:H1048576,\"YES\")","v":0},0]
[null,"Did the patient accept the offer and was the referral made?",{"$f":"COUNTIFS(saveddata!J4:J1048576,\"YES\",saveddata!I4:I1048576,\"NO\",saveddata!L4:L1048576,\"YES\",saveddata!M4:M1048576,\"YES\",saveddata!H4:H1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C14/C13),0,C14/C13)","v":0}]
[null,"9e. Percentage of unique patients who drink alcohol above low-risk levels AND are given brief advice OR offered a specialist referral if the patient is potentially alcohol dependent.",{"$f":"SUM(COUNTIFS(saveddata!K4:K1048576,\"YES\",saveddata!J4:J1048576,\"NO\",saveddata!I4:I1048576,\"YES\",saveddata!H4:H1048576,\"YES\"),COUNTIFS(saveddata!J4:J1048576,\"YES\",saveddata!I4:I1048576,\"NO\",saveddata!L4:L1048576,\"YES\",saveddata!H4:H1048576,\"YES\"))","v":0},{"$f":"IF(ISERROR(C15/SUM(C10,C12)),0,(C15/SUM(C10,C12)))","v":0}]