{"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":2,"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":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[20,1,20,3],[22,1,22,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 AND offered stop smoking medication",null,null,null,null," "]
[]
[null,"Was the patient referred to a stop smoking service?"]
[]
[]
[]
[]
[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,"If the patient is screened as drinking above low risk levels (but not dependent levels), were they given brief advice?"]
[]
[null,"Did the patient screen positive for potentially dependent drinking?"]
[]
[null,"If the patient is screened as positive for potentially dependent drinking, were they offered a referral to a specialist alcohol service?"]

{"sheet":"rawdata","index":1,"n_rows":4,"n_cols":11,"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 AND offered stop smoking medication","Was the patient referred to a stop smoking service?","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?","If the patient is screen as positive for potentially dependent drinking, were they offered a referral to a specialist alcohol service?","Number of patients drinking above low risk levels (but not dependent levels), given brief advice "]
[null,{"$f":"template!D6","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"saveddata","index":2,"n_rows":3,"n_cols":11,"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 AND offered stop smoking medication","Was the patient referred to a stop smoking service?","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?","If the patient is screen as positive for potentially dependent drinking, were they offered a referral to a specialist alcohol service?","Number of patients drinking above low risk levels (but not dependent levels), given brief advice "]

{"sheet":"Output table","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"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],[11,4,11,5]]}
[]
[null,"SUMMARY"]
[null,null,"Number","Percentage"]
["CCG3a denom","Number of unique admissions sampled ",{"$f":"COUNTA(saveddata!B4:B1048576)","v":0}]
[null,"Number of unique admitted patients with a tobacco screen ",{"$f":"COUNTIF(saveddata!C4:C1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C5/C4),0,C5/C4)","v":0}]
["CCG3b denom","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}]
["CCG3b num","Number of patients who smoke, given brief advice AND offered stop smoking medication ",{"$f":"COUNTIFS(saveddata!E4:E1048576,\"YES\",saveddata!C4:C1048576,\"YES\",saveddata!D4:D1048576,\"YES\")","v":0},0]
[null,"Number of patients that smoke that are referred to a stop smoking service ",{"$f":"COUNTIFS(saveddata!F4:F1048576,\"YES\",saveddata!C4:C1048576,\"YES\",saveddata!D4:D1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C8/C6),0,C8/C6)","v":0}]
[null,"Number of unique admitted patients screened for alcohol consumption ",{"$f":"COUNTIF(saveddata!G4:G1048576,\"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!G4:G1048576,\"YES\",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!H4:H1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C11/C10),0,C11/C10)","v":0}]
[null,"Number of screened patients drinking at possible dependent levels",{"$f":"COUNTIFS(saveddata!I4:I1048576,\"YES\",saveddata!G4:G1048576,\"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!I4:I1048576,\"YES\",saveddata!J4:J1048576,\"YES\")","v":0},0]
["CCG3a num","Number of unique admitted patients with a tobacco AND alcohol screen ",{"$f":"COUNTIFS(saveddata!C4:C1048576,\"YES\",saveddata!G4:G1048576,\"YES\")","v":0},{"$f":"IF(ISERROR(C14/C4),0,C14/C4)","v":0}]
["CCG3c num","Number of patients who are given brief advice on alcohol, OR offered a specialist referral if the patient is potentially alcohol dependent. ",{"$f":"C13+C11","v":0},{"$f":"IF(ISERROR(C15/(C10+C12)),0,C15/(C10+C12))","v":0}]
["CCG3c denom","Number of patients who have been recorded as drinking above low risk levels ",{"$f":"C10+C12","v":0},{"$f":"IF(ISERROR(C16/C9),0,(C16/C9))","v":0}]