{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Nov 2018","Supporting information","Audit guidence 2018"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Nov 2018","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,10],[6,0,6,10]],"flags":["formulas_cached_only"]}
["KPI","Key Performance Indicator (KPI) Score card","RBH","FH (HWPH)","SUH","OUH","Hampshire","Bucks","QA","MKH","Regional Average"]
["Usage / Wastage"]
[1,"Percentage of Red Blood cell wastage"]
[2,"Percentage of Platelet wastage"]
[3,"Percentage of ORhD negative stock"]
[4,"Percentage of A neg Platelet stock"]
["Appropriate use / Nice Quality Standards"]
[5,"Percentage of crossmatched blood transfused"]
[6,"Mandatory training compliance"]
[7,"Percentage of pre transfusoin HB's with HB <80g/L"]
[8,"Percentage of pre transfusoin HB's with HB <70g/L"]
[9,"Percentage of post transfusion Hb's with Hb ≤90g/L "]
[10,"Percentage transfused with one unit "]
[11,"Percentage with documentation of clinical assessment in clinical/medical notes after each unit - ie transfusion has occurred, paitient feeling better, symptoms "]
[12,"Percentage who had Hb checked after each unit received"]
[13,"Percentage with documentation of clinical assessment AND had Hb checked after each unit received"]
[14,"Percentage of orthopaedic patients undergoing moderate blood loss surgery that received TXA perioperatively"]
[15,"Percentage of patients that it is documented  that they received verbal information about transfusion"]
[16,"Percentage of patients that it is documented  that they received written information about transfusion"]
[17,"Percentage of patients that it is documented  that they received verbal AND written information about transfusion"]
[]
[]
[]
[]
[]
["manual"]
["electronic"]

{"sheet":"Supporting information","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Rationale","Key performance Indicators (KPI's) are an easy way to show compliance against defined audit standards.  They allow hospitals/trusts to benchmark them seleves against other organisiations in the region, measure their compliance against their targets and monitor trends.  The KPI's are an easy visual tool which can be utilised at meetings as evidence of improvements or for change.  However trusts need to understand their own data, it is a snap shot of practice at the time of the audit."]
["Start date","Started in August 2016. Completed every 6 months.  3 cycles completed to date.  KPI's were chosen by both TP's and Blood Bank managers on what they felt at the time was most useful and also easily accessable"]
["Findings"]
["Actions"]
["Future","The KPI's are constantly evolving and next year we intend to use this format to illustrate compliance against the NICE queality Standards"]

{"sheet":"Audit guidence 2018","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Key performance indicator","Explanation of audit criteria","Suggested source of information"]
[1,"Red Blood cell wastage (%)","As percentage of issues for month audited","Available from NHSBT"]
[2,"Platelet wastage (%)","As percentage of issues for month audited","Available from NHSBT"]
[3,"Percentage of ORhD negative stock (%)","As percentage of issues for month audited","Available from NHSBT"]
[4,"Percentage of A neg Platelet stock","As percentage of issues for month audited","Available from NHSBT"]
[5,"Percentage of crossmatched blood transfused","Units transfused/units crossmatched for month of audit, reported as a percentage","Available from LIMS, Suggested audit period 1 month"]
[6,"Mandatory training compliance","Percentage of staff whoare compliant with mandatory training for transfusion","Available from L&D"]
[7,"Percentage of pre transfusoin HB's with HB <80g/L","Select 20 random patients. Exclude MH or daycase haematology patients. Record highest Hb recorded within 48 hours of transfusion. % with a pre transfusion Hb of <80g/L.","Audit x 20 cases"]
[8,"Percentage of pre transfusoin HB's with HB <70g/L","Select 20 random patients. Exclude MH or daycase haematology patients. Record highest Hb recorded within 48 hours of transfusion. % with a pre transfusion Hb of <70g/L.","Audit x 20 cases"]
[9,"Percentage of post transfusion Hb's with Hb ≤90g/L ","Select 20 random patients. Exclude MH or daycase haematology patients. Record highest Hb recorded within 48 hours of transfusion. % with a post transfusion Hb of ≤90g/L.","Audit x 20 cases"]
[10,"Percentage transfused with one unit ","Use same 20 patients in Q13. % transfused with one unit ","Audit x 20 cases"]
[11,"Percentage with documentation of clinical assessment in clinical/medical notes after transfusion episode (each unit) - ie transfusion has occurred, paitient feeling better, symptoms ","Use 10 of patients from Q13. % transfused that were clinically assessed after each unit","Audit x 10 cases"]
[12,"Percentage who had Hb checked after transfusion episode (each unit)","Use same 10 patients as Q15. % transfused that had Hb checked after each unit","Audit x 10 cases"]
[13,"Percentage with documentation of clinical assessment AND had Hb checked after transfusion episode (each unit)","Use same 10 patients in Q15. % transfused that were clinically assessed AND had Hb checked after each unit","Audit x 10 cases"]
[14,"Percentage of patients undergoing moderate blood loss surgery that received TXA perioperatively a different speciality will be selected each audit period. ","Select 10 elective patients that had moderate blood loss surgery.  Includes heart surgery / THR / RTHR / Spinal / RTKR / ?myomectomy / colorectal ","Audit x 10 cases"]
[15,"Percentage of patients that it is documented  that they received verbal information about transfusion","Use 10 of patients from Q13. Percentage of patients that it is documented  that they received verbal information about transfusion. Can include risks/benefits/ consent","Audit x 10 cases"]
[16,"Percentage of patients that it is documented  that they received written information about transfusion","Use same patients as Q15. Percentage of patients that it is documented  that they received written information about transfusion","Audit x 10 cases"]
[17,"Percentage of patients that it is documented  that they received verbal AND written information about transfusion","Use same patients as Q15. Percentage of patients that it is documented  that they received verbal and written information about transfusion","Audit x 10 cases"]