{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Summary","Reference","Indicator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":30,"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":"Data","index":0,"n_rows":114,"n_cols":11,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,1,1,11],[5,7,6,8],[11,2,11,10]]}
[]
[null,{"$f":"CONCATENATE(\"Data collection tool for QUM Indicator \", Indicator_number, \":\n\", Indicator_name)","v":"Data collection tool for QUM Indicator 8.3:\nPercentage of older patients that are appropriately assessed for risk of medication-related impairment of cognitive and/or physical function"}]
[null,"©Copyright NSW Therapeutic Advisory Group Inc 2020"]
[null,{"$f":"CONCATENATE(\"This form should be used in conjunction with the methodology in QUM Indicator \", Indicator_number)","v":"This form should be used in conjunction with the methodology in QUM Indicator 8.3"}]
[null,{"$f":"IF(local_hrms=\"Yes\",local_sed_list,\"\")","v":""}]
[null,"Date of audit:",null,null,"Is a DBI calculator in use? "]
[null,"Hospital name:",null,null,"Local list of anticholinergic and sedative medicines in use:"]
[null,"Number of adult beds in the hospital:",null,null,"Which risk assessment tool for MEDICATION-RELATED impairment of cognitive and physical function is in use?"]
[]
[]
[]
[null,null,"Indicator 8.3"]
[null,"Question",1,2,"2a",3,"3a",4,5,6,7]
[null,"Patient Audit Number","What was the documented category for MEDICATION-RELATED impairment of cognitive and/or physical function risk?","Is documentation present detailing the rationale for risk categorisation?\n(See Table 1 in Indicator 8.3 specifications for rationale when using NSW TAG tool)","Detail reason(s) for categorisation ","Did a trained/credentialed health care professional conduct the risk assessment for MEDICATION-RELATED impairment of cognitive and/or physical function?","Who conducted the assessment? ","Was the risk assessment completed by the end of the next calendar day after admission? ","Age of Patient (Years)","Ward/Team","Comments"]
[null,null,"High, Moderate, Low, none given","Yes, No","Optional Question\nFree text","Yes, No","Optional Question\nDoctor, Pharmacist, Nurse, Other or Free text","Yes, No","50-120","Free text","Free text"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]

{"sheet":"Summary","index":1,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,0,23,0],[0,0,0,7],[11,2,12,2],[11,3,12,3],[11,1,12,1],[11,0,12,0],[18,0,20,0],[13,0,14,0]]}
[{"$f":"CONCATENATE(\"Collated data for QUM Indicator \", Indicator_number, \":\n\", Indicator_name)","v":"Collated data for QUM Indicator 8.3:\nPercentage of older patients that are appropriately assessed for risk of medication-related impairment of cognitive and/or physical function"}]
["©Copyright NSW Therapeutic Advisory Group Inc 2020"]
[]
[]
["Audit date:",{"$f":"IF(ISBLANK(audit_date), \"\", audit_date)","v":""}]
["Hospital name:",{"$f":"IF(ISBLANK(Hospital_name), \"\", Hospital_name)","v":""}]
["Number of adult beds in the hospital:",{"$f":"IF(ISBLANK(Adult_bed_number), \"\", Adult_bed_number)","v":""}]
["Local list of anticholinergic and sedative medicines in use: ",{"$f":"IF(ISBLANK(local_hrms), \"\", local_hrms)","v":""},null,null,null,"Breakdown of Risk Categories","Absolute number","Percentage of total audits"]
["Which risk assessment tool for MEDICATION-RELATED impairment of cognitive and physical function is in use?",{"$f":"IF(ISBLANK(local_impair), \"\", local_impair)","v":""},null,null,null,"High risk",{"$f":"COUNTIF(Data!$C$16:$C$114, F9)","v":0},{"$f":"IF(Total_Audits>0, G9/Total_Audits, \"\")","v":""}]
["Is a DBI calculator in use? ",{"$f":"IF(ISBLANK(local_polytool), \"\", local_polytool)","v":""},null,null,null,"Moderate risk",{"$f":"COUNTIF(Data!$C$16:$C$114, F10)","v":0},{"$f":"IF(Total_Audits>0, G10/Total_Audits, \"\")","v":""}]
[null,null,null,null,null,"Low risk",{"$f":"COUNTIF(Data!$C$16:$C$114, F11)","v":0},{"$f":"IF(Total_Audits>0, G11/Total_Audits, \"\")","v":""}]
["Total Number of Patients Audited","Criteria","Indicator 8.3: - Percentage of older patients that had a risk assessment for medication-related cognitive and/or physical impairment before the end of the next calendar day following hospital admission"," Percentage of older patients that had a risk assessment for medication-related cognitive and/or physical impairment \nat any time during admission",null,"None Given",{"$f":"COUNTIF(Data!$C$16:$C$114, F12)","v":0},{"$f":"IF(Total_Audits>0, G12/Total_Audits, \"\")","v":""}]
[]
[{"$f":"COUNTA(Data!C16:C114)","v":0},"Number of patients",{"$f":"COUNTIFS(Data!$D$16:$D$114, \"Yes\",Data!$F$16:$F$114, \"Yes\",Data!$H$16:$H$114, \"Yes\",Data!$C$16:$C$114, \"<>None Given\",Data!$C$16:$C$114, \"<>\")","v":0},{"$f":"COUNTIFS(Data!$D$16:$D$114, \"Yes\",Data!$F$16:$F$114, \"Yes\",Data!$C$16:$C$114, \"<>None Given\",Data!$C$16:$C$114, \"<>\")","v":0}]
[null,"Percentage ",{"$f":"IF(Total_Audits>0, C14/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, D14/Total_Audits, \"\")","v":""}]
[]
[]
["Summary of each data point"]
["Indicator 8.3","Data point","Documentation present detailing the rationale for risk categorisation","Appropriate health care professional conducted the risk assessment ","Risk assessment completed by the end of the next calendar day after admission"]
[null,"Absolute number",{"$f":"COUNTIF(Data!D16:D114, \"Yes\")","v":0},{"$f":"COUNTIF(Data!F16:F114, \"Yes\")","v":0},{"$f":"COUNTIF(Data!H16:H114, \"Yes\")","v":0}]
[null,"Percentage of total audits",{"$f":"IF(Total_Audits>0, C20/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, D20/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, E20/Total_Audits, \"\")","v":""}]
[]
["Age data (years)","Average age","Youngest age","Oldest age"]
[null,{"$f":"IF(Total_Audits>0, ROUND(AVERAGE(pt_age),0), \"\")","v":""},{"$f":"IF(Total_Audits>0, MIN(pt_age), \"\")","v":""},{"$f":"IF(Total_Audits>0, MAX(pt_age), \"\")","v":""}]

{"sheet":"Reference","index":2,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":true,"merged":[[7,6,8,6],[11,6,14,6],[16,6,20,6],[13,1,14,1],[13,0,14,0],[34,6,37,6],[28,6,32,6],[22,6,25,6],[39,6,41,6]]}
["Reference sheet"]
[]
["The reference sheet should only be edited by an authorised IT consulant or executive members of NSW TAG. Inadvertent changes can have impact across the entire workbook."]
[]
["This sheet contains the common variable areas within each tool to allow for rapid development and alteration."]
["It contains information regarding formula derivation and effects."]
[]
["Common variables",null,null,"Derived information",null,null,"YesNo List","Yes"]
["Indicator number:",8.3000000000000007,null,"Hospital name:",{"$f":"IF(ISBLANK(Hospital_name), \"\", Hospital_name)","v":""},null,null,"No"]
["Indicator name:","Percentage of older patients that are appropriately assessed for risk of medication-related impairment of cognitive and/or physical function",null,"Number of adult beds:",{"$f":"IF(ISBLANK(Adult_bed_number), \"\", Adult_bed_number)","v":""},null,"[N/A]","N/A"]
["Local guideline affected:",{"$f":"IF(local_hrms=\"Yes\",\"has own local High Risk Meds List in use\",\"\")","v":""}]
[null,null,null,null,null,null,"Risk categories","High risk"]
[null,null,null,null,null,null,null,"Moderate risk"]
["Local sedatives list in use advice"," As lists of anticholinergic and sedative medicines may vary between and within health service organisations or change over time, it is recommended that prior to auditing, the auditor identifies and records the list of medicines against which they will audit.",null,null,null,null,null,"Low risk"]
[null,null,null,null,null,null,null,"None Given"]
[]
[null,null,null,null,null,null,"Patient categories","Medical"]
[null,null,null,null,null,null,null,"Surgical"]
[null,null,null,null,null,null,null,"Oncology"]
[null,null,null,null,null,null,null,"Obstetrics"]
[null,null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,null,null,"Documentation location","NIMC"]
[null,null,null,null,null,null,null,"Medical notes"]
[null,null,null,null,null,null,null,"Nursing notes"]
[null,null,null,null,null,null,null,"Other"]
[]
[]
[null,null,null,null,null,null,"recommendation location","Discharge summary"]
[null,null,null,null,null,null,null,"Discharge letter"]
[null,null,null,null,null,null,null,"Phone call"]
[null,null,null,null,null,null,null,"Telehealth"]
[null,null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,null,null,"Health Practitioner","Doctor"]
[null,null,null,null,null,null,null,"Pharmacist"]
[null,null,null,null,null,null,null,"Nurse"]
[null,null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,null,null,"Local risk assessment tool in use","NSW TAG"]
[null,null,null,null,null,null,null,"Modified-NSW TAG"]
[null,null,null,null,null,null,null,"Local"]

{"sheet":"Indicator","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Below is the embedded PDF of the indicator. "]
[null,"Double-click this icon to open a full copy of the indicator for your reference."]
[null,"Click outside the full copy to re-enter the audit tool (Excel) again."]