{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Results","Proforma"],"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":"Results","index":0,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,0,4,1],[50,0,69,1],[0,0,0,1],[14,0,14,1],[24,0,24,1],[3,0,3,1]],"flags":["formulas_cached_only"]}
["Anaemia Quick Audit"]
[]
["Notes to the Author"]
["This is a Quick Audit developed by the London TP Group for the London RTC. All notes in green are instructions and should be removed before final report is distributed."]
["This tool allows a quick review process to determine if your hospital should focus on the correction of anaemia prior to surgery and associated services."]
[]
["There are instructions throughout this document."]
[]
["Audit Lead Name [add name of person conducting audit]",null,"\n"]
["Date of Report [add date report was generated]"]
["Audit Date Range [add dates range over which data was collected]"]
["Audit Area [add clinical area/ward(s) where data was collected]"]
[]
["Introduction"]
["Iron Deficiency Anaemia is a common type of anaemia. In this preliminary audit highlights how many patients going to theatre are anaemic. Further investigation into the cause of this anaemia would be needed to understand how many patients could be optimised using IV or oral iron supplementation."]
[]
["This is an indication audit to show if;"]
["a more detailed audit is required"]
["a need exists to tackle the issue of inappropriate transfusion of red cells for anaemia"]
["a needs exist to better manage anaemic patients"]
[]
["Standards set are;"]
["1)   All patients should have a FBC available 4 weeks before surgery"]
["2)   All patients anaemia status must be identified before surgery"]
["3)   No patient should be transfused above the hospitals upper threshold limit [This can be set for your local upper threshold – instruction below. Currently set at 90g/L]"]
[]
["Results"]
["1)    Click on tab called ‘proforma’ (at the bottom of the spread sheet)"]
["2)    Add in your 10 cases (You can print and complete by hand and transcribe the data)"]
["3)    Add your hospitals upper threshold for post transfusion Hb in cell L14"]
["4)    Click on tab called ‘results’ (at the bottom of the spread sheet)"]
[]
["Audit KPI","Outcome"]
["Number of people who had a FBC more than 4 weeks before surgery",1]
[]
["Number of people who were anaemic before surgery",0.2]
["Number of people who were unknown to be anaemic before surgery",0.2]
[]
["Number of patients who attended a pre-assessment clinic more than 3 weeks before surgery",0.5]
["Number of patients who did not attend a pre-assessment clinic",0.2]
[]
["Number of patients who received a transfusion pre, intra or post operatively",0.9]
[]
["Number of patients transfused above your hospitals threshold limit ",0.5]
[]
["Total number of RBC units transfused to these 10 patients (units)",20]
["Total cost of RBC transfused in these cases",2400]
[]
[]
["Conclusions"]
["Use the results from the table above to draw conclusions about your audit. Points for consideration (not exhaustive)\n• Is a further audit required?\n• Should a working group be formed to look at the results and develop an action plan?\n• Are there changes needed to the surgical pathway?\n• Is the hospital performing well in this field and no changes are required?\n• Who should this report be sent to?\n "]

{"sheet":"Proforma","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"1.For what date was the surgery scheduled?","2. Were results of FBC available 4 weeks before scheduled date of surgery? ","3. Was the Hb less than 120 (for females) or 130g/L for males? ","4. Did the patient attend a pre operative assessment clinic?","4a. If Q4 yes; what was the date of the pre operative assessment clinic appointment?","Date between pre-op clinic and surgery","5) Did the patient receive any transfusions?","5a. If Q5 yes; Pre-Operativly –how many","5a. If Q5 yes; Intra operatively – how many","5a. If Q5 yes; Post operatively – how many","6. What was the post transfusion (and after medical intervention) Hb?"]
[null,"(dd/mm/yyyy)","yes/no","yes/no","yes/no","dd/mm/yyyy",null,"yes/no","number","number","number","g/L"]
[1,"2015-05-01","Yes","no","Yes","2015-03-27",5,"Yes",0,0,2,98]
[2,"2015-05-11","Yes","no","Yes","2015-02-18",11.714285714285714,"Yes",0,0,2,90]
[3,"2015-05-09","Yes","no","yes","n/a",{"$error":"#VALUE!"},"Yes",0,0,2,105]
[4,"2015-05-30","Yes","n/a","yes","n/a",{"$error":"#VALUE!"},"Yes",0,1,0,98]
[5,"2015-05-30","Yes","no","Yes","2015-05-16",2,"Yes",0,0,3,86]
[6,"2015-06-01","Yes","No","no","2015-04-30",4.571428571428571,"No","n/a","n/a","n/a","n/a"]
[7,"2015-05-29","Yes","Yes","Yes","2015-05-16",1.8571428571428572,"Yes",2,1,0,99]
[8,"2015-06-01","Yes","No","Yes","2014-12-08",25,"Yes",0,0,3,84]
[9,"2015-05-13","Yes","Yes","No","n/a",{"$error":"#VALUE!"},"Yes",0,0,2,96]
[10,"2015-05-06","Yes","n/a","Yes","2015-04-07",4,"Yes",0,0,2,90]
[]
[{"$nulls":10},"Trust upper threshold limit for trasnfusion",">90"]