{"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":20,"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":8,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,1,1,8],[5,4,6,4],[5,5,6,5],[11,2,11,7],[7,4,8,4],[7,5,8,5]]}
[]
[null,{"$f":"CONCATENATE(\"Data collection tool for QUM Indicator \", Indicator_number, \":\n\", Indicator_name)","v":"Data collection tool for QUM Indicator 8.5:\nPercentage of older patients at high risk of medication-related harms with a recommendation for a post-discharge medication review, when hospital-based medication review is not performed"}]
[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.5"}]
[]
[null,"Date of audit:",null,null,"Describe PDMR service available at your organisation if applicable (e.g. APAC, HITH, HARP, telehealth or other):"]
[null,"Hospital name:"]
[null,"Number of adult beds in the hospital:",null,null,"Who was the audited high risk population? E.g. all, inappropriate polypharmacy, falls risk, cognitive/physical impairment or other specified criteria (please describe):"]
[null,null," "]
[]
[]
[null,null,"Indicator 8.5"]
[null,"Question",1,"1a",2,3,4,5]
[null,"Patient Audit Number","Is there documentation recommending or arranging a post-discharge medication review (PDMR)?","If answer to Q1 is 'Yes', has the PDMR recommendation/arrangement been documented in the discharge communication, e.g. summary/letter?","Is there a documented rationale for the PDMR recommendation provided to the primary care clinician(s) responsible for ongoing care?","Age of Patient (Years)","Ward/Team","Comments"]
[null,"(HIGH Risk Patients Only)"," Yes, No"," Yes, No","Optional Question\nYes, 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":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,1,19,1],[0,1,0,8],[10,3,10,4],[11,3,11,4],[12,3,12,4],[11,1,12,1],[14,1,16,1]]}
[null,{"$f":"CONCATENATE(\"Collated data for QUM Indicator \", Indicator_number, \":\n\", Indicator_name)","v":"Collated data for QUM Indicator 8.5:\nPercentage of older patients at high risk of medication-related harms with a recommendation for a post-discharge medication review, when hospital-based medication review is not performed"}]
[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,"Who was the audited high risk population? E.g. all, inappropriate polypharmacy, falls risk, cognitive/physical impairment or other specified criteria (please describe).",{"$f":"IF(ISBLANK(rat_desc), \"\", rat_desc)","v":""}]
[null,"Describe PDMR service available at your organisation if applicable",{"$f":"IF(ISBLANK(PDMR_serv), \"\", PDMR_serv)","v":""}]
[]
[null,"Total Number of Patients Audited","Criteria","Indicator 8.5: Percentage of older patients at high risk of medication-related harms with a recommendation for a post-discharge medication review, when hospital-based medication review is not performed."]
[null,{"$f":"COUNTA(Data!$C$16:$C$114)","v":0},"Number of patients",{"$f":"COUNTIFS(Data!$C$16:$C$114, \"Yes\",Data!$D$16:$D$114, \"Yes\")","v":0}]
[null,null,"Percentage ",{"$f":"IF(Total_Audits>0, D12/Total_Audits, \"\")","v":""}]
[null,"Summary of each data point"]
[null,"Indicator 8.5","Data point","Older patients at high risk of medication-related harms with a recommendation/arrangement for a post-discharge medication review (PDMR) that is not in the discharge documentation, e.g.  summary/letter","Older patients at high risk of medication-related harms with a recommendation/arrangement for a post-discharge medication review (PDMR) that have a documented rationale for the PDMR provided to the primary care clinician(s) responsible for ongoing care"]
[null,null,"Absolute number",{"$f":"COUNTIFS(Data!$C$16:$C$114, \"Yes\",Data!$D$16:$D$114, \"No\")","v":0},{"$f":"COUNTIFS(Data!$D$16:$D$114, \"Yes\",Data!$E$16:$E$114, \"Yes\")","v":0}]
[null,null,"Percentage of total audits",{"$f":"IF(Total_Audits>0, D16/Total_Audits, \"\")","v":""},{"$f":"IF(Total_Audits>0, E16/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":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":true,"merged":[[32,6,36,6],[26,6,30,6],[20,6,23,6],[7,6,8,6],[11,6,12,6],[14,6,18,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.5,null,"Hospital name:",{"$f":"IF(ISBLANK(Hospital_name), \"\", Hospital_name)","v":""},null,null,"No"]
["Indicator name:","Percentage of older patients at high risk of medication-related harms with a recommendation for a post-discharge medication review, when hospital-based medication review is not performed",null,"Number of adult beds:",{"$f":"IF(ISBLANK(Adult_bed_number), \"\", Adult_bed_number)","v":""},null,"[N/A]","N/A"]
["Local guideline affected:"]
[null,null,null,null,null,null,"Risk categories","High risk"]
[null,null,null,null,null,null,null,"Minimal risk"]
[]
[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,"PDMR","APAC"]
[null,null,null,null,null,null,null,"HITH"]
[null,null,null,null,null,null,null,"HARP"]
[null,null,null,null,null,null,null,"Telehealth"]
[null,null,null,null,null,null,null,"Other"]

{"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."]