{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Instructions","Audit Tool","Answer sheet","Summary","Recommendations"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":1,"defined_names":35,"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":"Introduction","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Subarachnoid Haemorrhage: Managing the flow - secondary/acute care"]
[null,"Audit Toolkit"]
[]
[null,"Thank you for downloading the toolkit for 'Subarachnoid Haemorrhage: Managing the Flow (secondary/acute care)'. We hope you find this useful and if you have any feedback please do contact us at info@ncepod.org.uk (see below for link). Please can you advise your local audit department if you plan to undertake this audit, it is important that they are made aware of it for the benefit of demonstrating Trust activity and also so that they are in a position to support you and endorse the activity for your benefit."]
[]
[null,"info@ncepod.org.uk"]
[]
[null,"Please complete as many questions which are applicable to the care of the patient"]
[]
[null,"For information on the recommendation to which each question assesses please click on the         button"]
[]
[null,"This toolkit can be used in conjunction with the Self Assessment Checklist. This can be found by clicking on the report image or at:"]
[null,"http://www.ncepod.org.uk/2013sah.htm"]

{"sheet":"Instructions","index":1,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Instructions for completion"]
[]
["Before you begin, in order to fill this tool in properly you MAY need to enable macros. To do this please click on the options button above this spreadsheet in the top left of the workbook. In the dialogue box which opens click on enable macros, ok. The spreadsheet should now be functional. "]
[]
["This data collection tool is made up of questions which can be used to assess how well your Trust is meeting recommendations made in \"Subarachnoid Haemorrhage: Managing the Flow (secondary/acute care)\""]
[]
["Amending the tool to include more or less patients"]
["This tool has been set up to be completed on 10 patients."]
["If the audit is undertaken on less than 10 patients, please delete out the extra rows."]
["If the audit is undertaken on more than 10 patients, please add in additional rows by copying row 9 (before populated with patient data), and inserting the copied cells above row 10."]
["Following these steps will ensure the formulas work correctly."]
[]
["For information on the recommendation to which each question assesses please click on the         button. This will take you to the recommendations page. Please click on the Audit tool tab to return to the questionnaire."]
[]
["For date fields please insert using the dd/mm/yyyy format; please insert times using the 24 hour clock (hh:mm)"]
[]
["Where a question answer is highlighted in red, this indicates this is an area of care where the recommendation (or the question assessing a recommendation) is not being met. The more answers are highlighted in red, the more likely it is a recommendation is not being met. "]
[]
["Summary data is given at the bottom of the tool (audit tool tab)."]
[]
["As the questionnaire is completed a summary of responses is collated on the summary tab."]
["Each question that relates to a recommendation will become highlighted with the following "]
["Green - Recommendation sub criteria was met in 100% of the sample"]
["Amber - Recommendation sub criteria was met in between 50-90% of the sample"]
["Red - Recommendation sub criteria was met in less than 50% of the sample"]
["Blue - Recommendation sub criteria were not answered/not applicable for any of the sample"]
[]
["The sub criteria can be changed for the tool as a whole where necessary (not for individual questions). Where this is required please amend the % criteria values in the RAG system table on the summary sheet."]
[]
["As the questionnaire is completed the radar chart will be populated based on the answers given in the recommendation sub criteria. The percentage is worked out based on the number of cases completed; therefore if data is completed for only 1 patient and the subcriteria questions are all met then a Trust will be meeting 100% of recommendations. This must be considered when analysing the results. "]
[]
["Each number point on the chart relates to a recommendation; the higher the percentage, the more likely a recommenation is being met. The total percentage for each recommendation is also displayed below the sub criteria questions."]
[]
["In order for the formulas to work, an answer must be given for each recommendation subcategory; therefore please ensure NA's are input where prompted and appropriate"]
[]
["NCEPOD does not ask for any of this data back; it is for each Trust to make a judgement as to whether they are meeting recommendations."]

{"sheet":"Audit Tool","index":2,"n_rows":30,"n_cols":74,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,3,5,5],[4,3,4,5],[3,3,3,5],[5,53,5,55],[4,53,4,55],[3,53,3,55],[3,6,3,8],[3,11,3,15],[5,11,5,15],[3,42,3,43],[5,48,5,50],[4,48,4,50],[3,48,3,50],[5,16,5,18],[5,20,5,22],[4,20,4,22],[5,42,5,43],[4,42,4,43],[3,20,3,22],[5,27,5,32],[4,27,4,32],[5,61,5,63],[3,61,3,63],[4,61,4,63],[2,68,2,73],[5,0,6,0],[2,1,2,15],[2,23,2,39],[3,16,3,18],[4,6,4,8],[2,40,2,41],[4,11,4,15],[4,16,4,18],[5,6,5,8],[5,57,5,59],[4,57,4,59],[3,57,3,59]]}
["Managing the Flow?"]
[]
[null,"PATIENT DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATIENTS PRESENTING TO ACUTE/SECONDARY CARE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATIENTS THAT DIED IN SECONDARY/ACUTE CARE"]
["Recommendation"]
["Question number",1,2,3,null,null,4,null,null,5,6,7,null,null,null,null,8,null,null,9,"10a",null,null,"10b","11a","11b",12,13,null,null,null,null,null,14,15,"16a","16b",17,18,19,20,"21a","21b",null,"21c","21d","21e","21f",22,null,null,"23a","23b","23c",null,null,"24a","24b",null,null,"24c","24d",null,null,"25a","25b","25c","25d",26,"27a","27b","28a","28b","28c"]
[null,"Age (years)","Gender","SAH details:",null,null,"When was the patient's first arrival in hospital?",null,null,"Did the patient attend the ED?","What was the mode of this presentation to hospital?","Please indicate all the appropriate points on the pathway that apply to this patient's care:",null,null,null,null,"When was the patient admitted to the ward?",null,null,"What was the grade of the clinician the patient was admitted under?","Patient's initial assessment",null,null,"What was the grade of the clinician that carried out the initial assessment?","Is there evidence that the patient underwent a neurological examination during the first 24 hours of arrival to acute/secondary care prior to transfer?","If YES to 11a, was this part of the initial assessment?","What was the grade of the clinician that carried out the neurological examination?","Did the neurological examination include:",null,null,null,null,null,"What was the patient's GCS?","Did the patient have a motor deficit?","Was the neurological examination satisfactory?","If NO to 16a, why was this?","Was the neurological examination adequately documented?","If the patient did not have a full neurological examination as part of the initial assessment, why was this?","Did the patient have a history of: (please select all that apply)","What was the patient's functional status on arrival to the secondary care hospital?","Did the patient undergo a CT scan in acute/secondary care (prior to transfer if patient was transferred)?","If YES to 21a, when was the CT scan performed?",null,"If YES to 21a, was this more than 1 hour after arrival to hospital?","If YES to 21a , were the results of the CT scan recorded in the case notes?","Did the CT scan confirm the diagnosis of SAH?","If NO to 21e, was a lumbar puncture performed?","What was the date/time that diagnosis of SAH was confirmed?",null,null,"Was the patient referred to a neurosurgical/ neurosciences unit?","If NO to 23a, why was this?","If YES to 23a, when was the patient referred to the neurosurgical/ neurosciences unit?",null,null,"Was the patient accepted for transfer?","If YES to 24a, when was the patient accepted for transfer?",null,null,"If NO to 24a, why was this?","If YES to 24a, when was the patient transferred?",null,null,"Was the transfer within 24 hours of arrival to hospital?","Did this patient go on to have a procedure in the NSC?","If YES to 25b, was this within 48 hours of onset of SAH?","If NO to 25b, why was this?","Was the death discussed at a mortality and morbidity meeting?","Was brain stem death testing performed?","If YES to 27a, was brain stem death diagnosed?","Was the patient suitable for organ donation?","If YES to 28a, did organ donation occur?","If NO to 28b, why not?"]
[null,null,null,"dd/mm/yyyy","hh:mm","Day","dd/mm/yyyy","hh:mm","Day",null,null,"Admitted to ward in secondary/ acute care","ED or ED/admissions unit complex only","Transfer to NSC within same hospital","Transfer to NSC in different hospital","Direct admission to neurosurgery (did not attend ED)","dd/mm/yyyy","hh:mm","Day",null,"dd/mm/yyyy","hh:mm","Day",null,null,null,null,"Past medical history","Assessment of consciousness level (using GCS)","Assessment of pupil responses","Fundoscopy","Assessment of motor functions","Assessment of sensory functions",null,null,null,null,null,null,"(answers may be multiple) please select all that apply",null,null,"dd/mm/yyyy","hh:mm",null,null,null,null,"dd/mm/yyyy","hh:mm","Day",null,null,"dd/mm/yyyy","hh:mm","Day",null,"dd/mm/yyyy","hh:mm","Day",null," dd/mm/yyyy","hh:mm","Day"]
["Patient 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"No\",\"NA\", IF(Y8=\"Yes but incomplete\",\"\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},{"$f":"IF(Y8=\"Yes\",\"\", IF(Y8=\"Yes but incomplete\",\"\", IF(Y8=\"No\",\"NA\")))","v":false},null,null,null,{"$f":"IF(AJ8=\"Yes\",\"NA\", IF(AJ8=\"NA - not performed\",\"NA\", IF(AJ8=\"Unable to answer\",\"NA\", IF(AJ8=\"No\",\"\"))))","v":false},null,{"$f":"IF(Y8=\"Yes\",\"NA\", IF(Y8=\"Yes but incomplete\",\"NA\", IF(Y8=\"No\",\"\")))","v":false},null,null,null,{"$f":"IF(AP8=\"No\",\"NA\", IF(AP8=\"Unable to answer\",\"NA\", IF(AP8=\"Yes\",\"\")))","v":false},{"$f":"IF(AP8=\"No\",\"NA\", IF(AP8=\"Unable to answer\",\"NA\", IF(AP8=\"Yes\",\"\")))","v":false},{"$f":"IF(AP8=\"No\",\"NA\", IF(AP8=\"Unable to answer\",\"NA\", IF(AP8=\"Yes\",\"\")))","v":false},{"$f":"IF(AP8=\"No\",\"NA\", IF(AP8=\"Unable to answer\",\"NA\", IF(AP8=\"Yes\",\"\")))","v":false},{"$f":"IF(AP8=\"Yes\",\"\",IF(AP8=\"No\",\"NA\",IF(AP8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(AU8=\"Yes\",\"NA\", IF(AU8=\"Unable to answer\",\"NA\", IF(AU8=\"No\",\"\", IF(AP8=\"No\",\"NA\"))))","v":false},null,null,null,null,{"$f":"IF(AZ8=\"Yes\",\"NA\", IF(AZ8=\"No\",\"\", IF(AZ8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(AZ8=\"Yes\",\"\",IF(AZ8=\"No\",\"NA\",IF(AZ8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(AZ8=\"Yes\",\"\",IF(AZ8=\"No\",\"NA\",IF(AZ8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(AZ8=\"Yes\",\"\",IF(AZ8=\"No\",\"NA\",IF(AZ8=\"Unable to answer\",\"NA\")))","v":false},null,{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"NA\",IF(BE8=\"No\",\"\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BE8=\"Yes\",\"\",IF(BE8=\"No\",\"NA\",IF(BE8=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(BM8=\"Yes\",\"\",IF(BM8=\"No\",\"\",IF(BM8=\"Unable to answer\",\"\",IF(BM8=\"NA\",\"NA\",IF(BM8=\"FALSE\",\"NA\")))))","v":false},{"$f":"IF(BN8=\"Yes\",\"\",IF(BN8=\"No\",\"NA\",IF(BN8=\"Unable to answer\",\"NA\",IF(BN8=\"NA\",\"NA\"))))","v":false},{"$f":"IF(BO8=\"Yes\",\"NA\",IF(BO8=\"No\",\"\",IF(BO8=\"Unable to answer\",\"NA\",IF(BO8=\"NA\",\"NA\"))))","v":false},null,null,{"$f":"IF(BR8=\"Yes\",\"\",IF(BR8=\"No\",\"NA\",IF(BR8=\"Unable to answer\",\"NA\",IF(BR8=\"NA\",\"NA\"))))","v":false},null,{"$f":"IF(BT8=\"Yes\",\"\",IF(BT8=\"No\",\"NA\",IF(BT8=\"Unable to answer\",\"NA\",IF(BT8=\"NA\",\"NA\"))))","v":false},{"$f":"IF(BU8=\"Yes\",\"NA\",IF(BU8=\"No\",\"\",IF(BU8=\"Unable to answer\",\"NA\",IF(BU8=\"Not applicable\",\"NA\",IF(BU8=\"NA\",\"NA\")))))","v":false}]
["Patient 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,{"$f":"IF(AZ13=\"Yes\",\"\",IF(AZ13=\"No\",\"NA\",IF(AZ13=\"Unable to answer\",\"NA\")))","v":false},null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,{"$f":"IF(AZ14=\"Yes\",\"\",IF(AZ14=\"No\",\"NA\",IF(AZ14=\"Unable to answer\",\"NA\")))","v":false},{"$f":"IF(AZ14=\"Yes\",\"\",IF(AZ14=\"No\",\"NA\",IF(AZ14=\"Unable to answer\",\"NA\")))","v":false},false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,{"$f":"IF(BT14=\"Yes\",\"\",IF(BT14=\"No\",\"NA\",IF(BT14=\"Unable to answer\",\"NA\",IF(BT14=\"NA\",\"NA\"))))","v":false},false]
["Patient 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,false,null,null,false,null,false,false]
["Patient 10                                                                                           Add new patient (above this row before populating with data)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,false,false,false,false,false,null,null,null,false,null,false,null,null,null,false,false,false,false,false,false,null,null,null,null,false,false,false,false,null,false,false,false,false,false,false,false,false,false,false,{"$f":"IF(BO17=\"Yes\",\"NA\",IF(BO17=\"No\",\"\",IF(BO17=\"Unable to answer\",\"NA\",IF(BO17=\"NA\",\"NA\"))))","v":false},null,null,false,null,false,false]
[]
["Yes n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Y8:Y17,\"Yes\")","v":0},null,null,{"$f":"COUNTIF(AB8:AB17, \"Yes\")","v":0},0,0,0,0,0,null,null,{"$f":"COUNTIF(AJ8:AJ17,\"Yes\")","v":0},null,{"$f":"COUNTIF(AL8:AL17,\"Yes\")","v":0},{"$f":"COUNTIF(AM8:AM17,\"Yes\")","v":0},null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0]
["Yes %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Y19/Y23),\"%\",Y19/Y23*100)","v":"%"},null,null,{"$f":"IF(ISERROR(AB19/AB23),\"%\",AB19/AB23*100)","v":"%"},"%","%","%","%","%",null,null,"%",null,"%",{"$f":"IF(ISERROR(AM19/AM23),\"%\",AM19/AM23*100)","v":"%"},null,null,"%",null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%","%","%",null,null,null,null,null,null,"%"]
["No n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Y8:Y17, \"No\")","v":0},null,null,{"$f":"COUNTIF(AB8:AB17, \"No\")","v":0},0,0,0,0,0,null,null,0,null,0,{"$f":"COUNTIF(AM8:AM17, \"No\")","v":0},null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,{"$f":"COUNTIF(BV8:BV17, \"Not considered by medical staff\")","v":0}]
["No %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Y21/Y23),\"%\",Y21/Y23*100)","v":"%"},null,null,{"$f":"IF(ISERROR(AB21/AB23),\"%\",AB21/AB23*100)","v":"%"},"%","%","%","%","%",null,null,"%",null,"%",{"$f":"IF(ISERROR(AM21/AM23),\"%\",AM21/AM23*100)","v":"%"},null,null,"%",null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%","%","%",null,null,null,null,null,null,"%"]
["Sub total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y19+Y21)","v":0},null,null,{"$f":"SUM(AB19+AB21)","v":0},0,0,0,0,0,null,null,0,null,0,{"$f":"SUM(AM19+AM21)","v":0},null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0]
["No data/Not answered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y28+Y29","v":10},null,null,{"$f":"AB28+AB29","v":10},10,10,10,10,10,null,null,10,null,10,{"$f":"AM28+AM29","v":10},null,null,10,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,null,null,null,null,null,null,10]
["Not applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Y8:Y17,\"NA\")","v":0},null,null,{"$f":"COUNTIF(AB8:AB17,\"NA - not possible to examine\")","v":0},{"$f":"COUNTIF(AC8:AC17,\"NA - not possible to examine\")","v":0},0,0,0,{"$f":"COUNTIF(AG8:AG17,\"NA - not possible to examine\")","v":0},null,null,{"$f":"COUNTIF(AJ8:AJ17,\"NA - not performed\")","v":0},null,{"$f":"COUNTIF(AL8:AL17,\"NA\")","v":0},{"$f":"COUNTIF(AM8:AM17,\"NA\")","v":0},null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,0]
["Number of cases included in audit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y19+Y21+Y24+Y25","v":10},null,null,{"$f":"AB19+AB21+AB24+AB25","v":10},10,10,10,10,10,null,null,10,null,10,{"$f":"AM19+AM21+AM24+AM25","v":10},null,null,10,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,null,null,null,null,null,null,10]
[]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Y8:Y17,\"False\")","v":0},10,null,10,10,10,10,10,10,null,null,0,10,0,{"$f":"COUNTIF(AM8:AM17,\"False\")","v":10},null,null,0,10,10,10,null,null,null,0,0,0,null,null,10,10,10,null,10,10,10,null,10,10,10,10,10,10,null,null,null,null,null,null,10]
["No data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Y8:Y17,\"\")","v":10},0,null,0,0,0,0,0,0,null,null,10,0,10,{"$f":"COUNTIF(AM8:AM17,\"\")","v":0},null,null,10,0,0,0,null,null,null,10,10,10,null,null,0,0,0,null,0,0,0,null,0,0,0,0,0,0,null,null,null,null,null,null,0]
["Summary data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y24=Y26,\"No data\", IF(Y25=Y26,\"NA\", IF(Y24+Y25=Y26,\"NA\",Y20)))","v":"No data"},"No data",null,"No data","No data","No data","No data","No data","No data",null,null,"No data","No data","No data","No data",null,null,"No data","No data","No data",{"$f":"IF(AS24=AS26,\"No data\", IF(AS25=AS26,\"NA\", IF(AS24+AS25=AS26,\"NA\",AS22)))","v":"No data"},null,null,null,"No data","No data","No data",null,null,{"$f":"IF(BB24=BB26,\"No data\", IF(BB25=BB26,\"NA\", IF(BB24+BB25=BB26,\"NA\",BB20)))","v":"No data"},"No data","No data",null,"No data","No data","No data",null,"No data","No data","No data",{"$f":"IF(BM24=BM26,\"No data\", IF(BM25=BM26,\"NA\", IF(BM24+BM25=BM26,\"NA\",BM20)))","v":"No data"},{"$f":"IF(BN24=BN26,\"No data\", IF(BN25=BN26,\"NA\", IF(BN24+BN25=BN26,\"NA\",BN20)))","v":"No data"},"No data",null,null,null,null,null,null,"No data"]

{"sheet":"Answer sheet","index":3,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["Answer1",null,"AnswerC",null,"Answer3",null,"Answer4",null,"Answer5",null,"Answer6",null,"Answer7"]
["Male",null,"GP referral following telephone consultation",null,"Yes",null,"Ischaemic rest pain",null,"Yes",null,"Immediate",null,"Consultant"]
["Female",null,"GP referral following clinical review in person",null,"No",null,"Neuropathy",null,"No",null,"Urgent",null,"Staff grade/Associate specialist"]
[null,null,"Self referral to ED",null,"NA",null,"Diabetic foot sepsis",null,null,null,"Expedited",null,"Trainee with CCT"]
[null,null,"ED via ambulance/999 call",null,null,null,"Other",null,null,null,"Elective",null,"Senior specialist trainee"]
[null,null,"ED via outpatient clinic",null,null,null,null,null,null,null,null,null,"Junior specialist trainee"]
[null,null,"Other",null,null,null,null,null,null,null,null,null,"Basic grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
["Answer8",null,null,"Answer10",null,"Answer11",null,"Answer12",null,"Answer13",null,"Answer14"]
["07:00 - 21:59",null,null,"Yes",null,"Yes",null,"Yes",null,"Best motor reponse (1-6)",null,"Yes"]
["22:00 - 06:59",null,null,"No",null,"No",null,"No",null,"Best eye response (1-4)",null,"No"]
[null,null,null,"Yes but incomplete",null,"Unable to answer",null,"Present but incomplete",null,"Best verbal response (1-5)",null,"NA - not possible to examine"]
[null,null,null,null,null,null,null,"NA - not possible to examine",null,"Unable to answer",null,"Unable to answer"]
[null,null,null,null,null,null,null,null,null,"NA - not possible to examine"]
[]
["Answer15",null,"Answer16",null,"Answer17",null,"Answer18"]
["Yes",null,"Delayed",null,"Yes",null,"Patient arrived in coma therefore unable to carry out full neurological examination"]
["No",null,"Incomplete",null,"No",null,"Patient died before neurological examination possible"]
["NA - not performed",null,null,null,"NA - not performed",null,"Already performed prior to arrival, partial neurological examination performed"]
["Unable to answer",null,null,null,null,null,"Already performed prior to arrival, no neurological examination performed"]
[null,null,null,null,null,null,"Performed but not fulled documented"]
["Answer19",null,null,"Answer20",null,null,"Unable to answer"]
["No symptoms",null,null,"Patient died before referral possible"]
["Slight disability",null,null,"Decision taken to manage conservatively",null,null,null,"Answer21"]
["Moderate disability",null,null,null,null,null,null,"Delayed presentation to acute/secondary care"]
["Severe disability",null,null,null,null,null,null,"Delayed initial assessment in acute/secondary care"]
["No disability despite symptoms",null,null,null,null,null,null,"Delayed CT scan in acute/secondary care"]
["Unable to answer",null,null,null,null,null,null,"Delayed referral to NSC"]
[null,null,null,"Answer23",null,null,null,"Clinical reasons for delay: resuscitation etc."]
["Answer22",null,null,"Patient died",null,null,null,"Delayed acceptance by NSC"]
["Yes",null,null,"Decision taken to manage conservatively",null,null,null,"Procedure was delayed following admission to NSC"]
["No",null,null,null,null,null,null,"Other reason"]
["Unable to answer",null,null,null,null,null,null,"Unable to answer"]
["NA"]
[]
[]
["Answer24"]
["Not considered by medical staff"]
["Refused by next of kin"]
[]
[]
["Answer25"]
["Diabetes"]
["Ischaemic stroke"]
["Hypertension"]
["Cancer"]
["Arthritis"]
["Angina or other cardiac issues"]
["Renal impairment"]
["COPD/Asthma"]
["Smoking"]
["Hypercholesterolaemia"]
["Hyperthyroidism"]
["Depression/anxiety"]
["Migrane"]

{"sheet":"Summary","index":4,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,16,6,16],[0,0,0,7],[2,9,2,12],[17,9,17,12],[32,9,32,12],[2,15,6,15]]}
["RADAR CHART"]
[]
[null,null,null,null,null,null,null,null,null,"Recommendation - Sub criteria question number (reference only)",null,null,null,null,null,"RAG system (NCEPOD recommends these are set at the following limits, however these can be adapted by your Trust where appropriate by amending the thresholds as required)","%"]
[null,null,null,null,null,null,null,null,null,2,3,4,5]
[null,null,null,null,null,null,null,null,null,"11a","21a","25a","28c"]
[null,null,null,null,null,null,null,null,null,"13. i","21c","25b"]
[null,null,null,null,null,null,null,null,null,"13. ii",null,"25c"]
[null,null,null,null,null,null,null,null,null,"13. iii",null,null,null,null,null,"Green",100]
[null,null,null,null,null,null,null,null,null,"13. iv",null,null,null,null,null,"Amber",50]
[null,null,null,null,null,null,null,null,null,"13. v"]
[null,null,null,null,null,null,null,null,null,"13. vi"]
[null,null,null,null,null,null,null,null,null,"16a"]
[null,null,null,null,null,null,null,null,null,17]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Recommendation - Sub criteria questions (score)"]
[null,null,null,null,null,null,null,null,null,2,3,4,5]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!Y30","v":"No data"},{"$f":"'Audit Tool'!AP30","v":"No data"},{"$f":"'Audit Tool'!BM30","v":"No data"},{"$f":"'Audit Tool'!BV30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AB30","v":"No data"},{"$f":"'Audit Tool'!AS30","v":"No data"},{"$f":"'Audit Tool'!BN30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AC30","v":"No data"},null,{"$f":"'Audit Tool'!BO30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AD30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AE30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AF30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AG30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AJ30","v":"No data"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Audit Tool'!AL30","v":"No data"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Average % of recommendation"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J20=\"No data\", \"No data\",IF(J20=\"NA\",\"NA\",IF(J20=\"%\",\"%\",SUM(J20:J28)/COUNT(J20:J28))))","v":"No data"},{"$f":"IF(K20=\"No data\", \"No data\",IF(K20=\"NA\",\"NA\",IF(K20=\"%\",\"%\",SUM(K20:K21)/COUNT(K20:K21))))","v":"No data"},{"$f":"IF(L20=\"No data\", \"No data\",IF(L20=\"NA\",\"NA\",IF(L20=\"%\",\"%\",SUM(L20:L22)/COUNT(L20:L22))))","v":"No data"},{"$f":"IF(M20=\"No data\", \"No data\",IF(M20=\"NA\",\"NA\",IF(M20=\"%\",\"%\",SUM(M20)/COUNT(M20))))","v":"No data"}]

{"sheet":"Recommendations","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["RECOMMENDATIONS"]
[1,"All patients presenting with acute severe headache in a secondary care hospital should have a thorough neurological examination performed and documented"]
[2,"A CT - scan should be performed immediately in this group of patients as defined by the \"National Clinical Guideline for Stroke\""]
[3,"The nationally-agreed standard (\"National Clinical Guideline for Stroke\") of securing ruptured aneurysms within 48 hours should be met consistently and comprehensively by healthcare professionals who treat this group of patients.  This will require providers to assess the service they deliver and move towards a seven-day-service"]
[4,"Organ donation rates following fatal aneurysmal subarachnoid haemorrhage should be audited and policies adopted to increase the frequency with which this occurs."]