{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Summary","Reference","Indicator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":23,"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":113,"n_cols":11,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,1,1,11],[10,2,10,10]]}
[]
[null,{"$f":"CONCATENATE(\"Data collection tool for QUM Indicator \", Indicator_number, \":\n\", Indicator_name)","v":"Data collection tool for QUM Indicator 8.1:\nPercentage of older patients that are appropriately assessed for risk of inappropriate polypharmacy"}]
[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.1"}]
[null,{"$f":"IF(local_hrms=\"Yes\",\"As lists of HRMs 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\",\"\")","v":""}]
[null,"Date of audit:",null,null,"Which risk assessment tool for inappropriate polypharmacy is in use?"]
[null,"Hospital name:",null,null,"Local list of high risk medicines (HRMs) in use? "]
[null,"Number of adult beds in the hospital:"]
[]
[]
[null,null,"Indicator 8.1"]
[null,"Question",1,2,"2a",3,"3a",4,5,6,7]
[null,"Patient Audit Number","What was the documented category for inappropriate polypharmacy risk?","Is documentation present detailing the rationale for risk categorisation?\n(See Table 2 in Indicator 8.1 specifications for rationale when using NSW TAG tool)","Detail reason(s) for categorisation ","Did a trained/credentialed health care professional conduct the assessment for inappropriate polypharmacy risk? ","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":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,1,21,1],[0,1,0,8],[11,1,12,1],[7,6,8,6],[7,7,8,7],[7,8,8,8],[16,1,18,1]]}
[null,{"$f":"CONCATENATE(\"Collated data for QUM Indicator \", Indicator_number, \":\n\", Indicator_name)","v":"Collated data for QUM Indicator 8.1:\nPercentage of older patients that are appropriately assessed for risk of inappropriate polypharmacy"}]
[null,"©Copyright NSW Therapeutic Advisory Group Inc 2020"]
[]
[]
[null,"Audit date:",{"$f":"IF(ISBLANK(Audit_date), \"\", Audit_date)","v":""}]
[null,"Hospital name:",{"$f":"IF(ISBLANK(Hospital_name), \"\", Hospital_name)","v":""}]
[null,"Number of adult beds in the hospital:",{"$f":"IF(ISBLANK(Adult_bed_number), \"\", Adult_bed_number)","v":""}]
[null,"Local list of high risk medicines (HRMs) in use?:",{"$f":"IF(ISBLANK(local_hrms), \"\", local_hrms)","v":""},null,null,null,"Breakdown of Risk Categories","Absolute number","Percentage of total audits"]
[null,"Which risk assessment tool for inappropriate polypharmacy is in use?",{"$f":"IF(ISBLANK(local_polytool81), \"\", local_polytool81)","v":""}]
[null,null,null,null,null,null,"High risk",{"$f":"COUNTIF(Data!$C$15:$C$113, G10)","v":0},{"$f":"IF(Total_Audits>0, H10/Total_Audits, \"\")","v":""}]
[null,"Total Number of Patients Audited","Criteria","Indicator 8.1: Percentage of older patients that are appropriately assessed for risk of inappropriate polypharmacy by the end of the next calendar day after admission"," Percentage of older patients that are appropriately assessed for risk of inappropriate polypharmacy at any time during admission",null,"Moderate risk",{"$f":"COUNTIF(Data!$C$15:$C$113, G11)","v":0},{"$f":"IF(Total_Audits>0, H11/Total_Audits, \"\")","v":""}]
[null,{"$f":"COUNTA(Data!C15:C113)","v":0},"Number of patients",{"$f":"COUNTIFS(Data!$D$15:$D$113, \"Yes\",Data!$F$15:$F$113, \"Yes\",Data!$H$15:$H$113, \"Yes\",Data!$C$15:$C$113, \"<>None Given\",Data!$C$15:$C$113, \"<>\")","v":0},{"$f":"COUNTIFS(Data!$D$15:$D$113, \"Yes\",Data!$F$15:$F$113, \"Yes\",Data!$C$15:$C$113, \"<>None Given\",Data!$C$15:$C$113, \"<>\")","v":0},null,"Low risk",{"$f":"COUNTIF(Data!$C$15:$C$113, G12)","v":0},{"$f":"IF(Total_Audits>0, H12/Total_Audits, \"\")","v":""}]
[null,null,"Percentage ",{"$f":"IF(Total_Audits>0, D12/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, E12/Total_Audits, \"\")","v":""},null,"None Given",{"$f":"COUNTIF(Data!$C$15:$C$113, G13)","v":0},{"$f":"IF(Total_Audits>0, H13/Total_Audits, \"\")","v":""}]
[]
[]
[null,"Summary of each data point"]
[null,"Indicator 8.1","Data point","Documentation present detailing the rationale for risk categorisation","Appropriate health care professional(s) conducted risk assessment ","Risk assessment completed by the end of the next calendar day after admission"]
[null,null,"Absolute number",{"$f":"COUNTIF(Data!D15:D113, \"Yes\")","v":0},{"$f":"COUNTIF(Data!F15:F113, \"Yes\")","v":0},{"$f":"COUNTIF(Data!H15:H113, \"Yes\")","v":0}]
[null,null,"Percentage of total audits",{"$f":"IF(Total_Audits>0, D18/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, E18/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, F18/Total_Audits, \"\")","v":""}]
[]
[null,"Age data (years)","Average age","Youngest age","Oldest age"]
[null,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":[[39,6,41,6],[34,6,37,6],[28,6,32,6],[22,6,25,6],[7,6,8,6],[11,6,14,6],[16,6,20,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.1,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 inappropriate polypharmacy",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"]
[null,null,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,"Risk Assessment Tool","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."]