{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Form","Lookups","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Form","index":0,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[[74,5,74,6],[76,5,76,6],[78,5,78,6],[57,2,59,3],[1,1,1,3],[2,1,2,3],[17,2,17,3],[52,1,52,3],[11,2,11,3],[47,2,51,3],[43,2,43,3],[7,2,9,3],[5,2,5,3],[88,2,94,3],[14,2,14,3],[86,2,86,3],[81,1,81,3],[84,2,84,3],[82,2,82,3],[64,2,66,3],[55,2,55,3],[31,2,31,3],[61,2,61,3],[40,3,40,5],[69,2,69,3],[71,2,71,3],[76,2,76,3],[78,2,78,3],[74,2,74,3]]}
[]
[null,"Adverse events Part A submission form"]
[null,"To be uploaded to the Health Quality & Safety Commission website within 15 working days from the date the event is notified to the provider"]
[null,null,"Mandatory fields"]
[]
[null,"Provider",null,null,{"$f":"IF(AND(Data!A2<>\"Other\",Data!B2<>0),\"! ... Please make sure the 'Other' provider is specified\",\"\")","v":""}]
[]
[null,"        If Other, please specify",null,null,{"$f":"IF(AND(Data!A2<>\"Other\",Data!B2<>0),\"! ... Please make sure the 'Other' provider is specified\",\"\")","v":""}]
[]
[]
[]
[null,"Internal reference code"]
[]
[null,null,"Date"]
[null,"Event date",null,null,{"$f":"IF(OR(AND($C$15>$C$18,$C$15<>0,$C$18<>0),AND($C$15>$C$87,$C$15<>0,$C$87<>0)),\"! ... Please make sure the dates are in the correct order\",\"\")","v":""}]
[]
[null,null,"Date"]
[null,"Internal notification date",null,null,{"$f":"IF(OR(AND($C$15>$C$18,$C$15<>0,$C$18<>0),AND($C$18>$C$87,$C$18<>0,$C$87<>0)),\"! ... Please make sure the dates are in the correct order\",\"\")","v":""}]
[]
[null,"Type of organisation"]
[null,"(Please select all that apply)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(AND(Data!O2<>0,NOT(Data!N2)),\"! ... Please select 'Other'\",\"\")","v":""}]
[]
[null,"Provisional event code (WHO code)"]
[]
[null,"Provisional SAC rating"]
[]
[null,"Near miss?"]
[]
[]
[null,"On Always Report and Review list?",null,null,null,null,{"$f":"IF(AND(Data!W2=\"No\",Data!X2<>\"\"),\"! ... If the event is not on the Always Report and Review list, please select the blank category\",\"\")","v":""}]
[]
[null,"        If Yes, what was the Always Report and Review category?",null,null,null,null,{"$f":"IF(AND(Data!W2=\"No\",Data!X2<>\"\"),\"! ... If the event is not on the Always Report and Review list, please select the blank category\",\"\")","v":""}]
[]
[]
[null,"Other providers involved in the event (if any)"]
[]
[null,"Alert required?"]
[]
[null,"Description of event"]
[]
[]
[]
[]
[]
[null,"Did the patient die?",null,null,{"$f":"IF(AND(Data!AE2<>0,AND(Data!AD2=\"No\",Data!AE2=\"Death\")),\"! ... Please make sure these two answers match\",\"\")","v":""}]
[]
[null,"Patient outcome",null,null,{"$f":"IF(AND(Data!AE2<>0,AND(Data!AD2=\"No\",Data!AE2=\"Death\")),\"! ... Please make sure these two answers match\",\"\")","v":""}]
[]
[null,"        If Other, please specify",null,null,{"$f":"IF(AND(Data!AE2<>\"Other\",Data!AF2<>0),\"! ... Please make sure 'Other' is specified if there is a description of the patient outcome\",\"\")","v":""}]
[]
[]
[]
[null,"Clinical area",null,null,{"$f":"IF(AND(Data!AG2<>\"Other\",Data!AH2<>0),\"! ... Please make sure these two answers match\",\"\")","v":""}]
[null,"(Please select the area of care in which this event occurred. If the area is not provided, select \"Other\" and specify.)"]
[]
[null,"If Other, please specify",null,null,{"$f":"IF(AND(Data!AG2<>\"Other\",Data!AH2<>0),\"! ... Please make sure the 'Other' clinical area is specified\",\"\")","v":""}]
[]
[]
[]
[]
[null,"Age (years)"]
[]
[null,"Gender"]
[]
[null,null,"Level 1","Or",null,"Level 2"]
[null,"Ethnicity 1"]
[]
[null,"Ethnicity 2"]
[]
[null,"Ethnicity 3"]
[]
[]
[null,"This adverse event brief: part A has been approved for transmission to the Health Quality & Safety Commission by the organisation’s chief executive (or equivalent) or senior delegate who endorses the accuracy and content of the document on their behalf."]
[null,"Name"]
[]
[null,"Position"]
[]
[null,"Date sent",null,null,{"$f":"IF(OR(AND($C$15>$C$87,$C$15<>0,$C$87<>0),AND($C$18>$C$87,$C$18<>0,$C$87<>0)),\"! ... Please make sure the dates are in the correct order\",\"\")","v":""}]
[]
[null,"Any other information"]

{"sheet":"Lookups","index":1,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
[null,"Provider","Type of organisation",null,"Age",null,"Sex",null,"Ethnicity",null,"Ethnicity 2",null,"Patient Outcome",null,"WHO codes",null,"Clinical Area",null,"ARR category","Macro to enable control boxes"]
[1,null,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,"Sub HideControlGroups()"]
[2,"Acurity / Royston Hospital","Aged Care",2,"Not stated",2,"Female",2,"European",2,"European not further defined",2,"Fracture",2,"01 Clinical Administration",2,"Aged Residential Care",2,"Child/infant abduction or discharge to wrong family/whānau","    Form.GroupBoxes.Visible = False"]
[3,"Ascot Hospitals and Clinics","Ambulance Service",3,"Under 12 months",3,"Male",3,"Māori",3,"NZ European",3,"Head injury",3,"02 Clinical Process/Procedure",3,"Ambulance",3,"Retained foreign object post-procedure","End Sub"]
[4,"Auckland DHB","DHB",4,1,4,"Gender diverse",4,"Pacific Peoples",4,"Other European",4,"Hypoxic Ischemic Encephalopathy (HIE)",4,"03 Documentation",4,"Cancer",4,"Wrong blood component"]
[5,"Avonlea Rest Home","Disability Services Provider",5,2,null,null,5,"Asian",5,"NZ Maori",5,"Neonatal Encephalopathy (NE)",5,"04 Healthcare Associated Infection",5,"Cardiothoracics",5,"Wrong consumer/patient"]
[6,"Bay of Plenty DHB","Mental Health",6,3,null,null,6,"Middle Eastern/Latin American/African",6,"Pacific Island not further defined",6,"Other",6,"05 Medication/IV Fluids",6,"Community Mental Health",6,"Wrong implant/prosthesis"]
[7,"Boulcott Hospital","NGO",7,4,null,null,7,"Other Ethnicity",7,"Samoan",7,"Paralysis",7,"06 Blood/Blood Products",7,"Dental",7,"Wrong site"]
[8,"Canopy Cancer Care","PHO",8,5,null,null,8,"Residual Categories",8,"Cook Island Maori",8,"Pressure injury",8,"07 Nutrition",8,"Disability"]
[9,"Canterbury DHB","Private Medical/Surgical",9,6,null,null,null,null,9,"Tongan",9,"Progression of disease",9,"08 Oxygen/Gas/Vapour",9,"Emergency Department"]
[10,"Capital and Coast DHB","Other (please specify)",10,7,null,null,null,null,10,"Niuean",10,"Transferred to higher level care",10,"09 Medical Device/Equipment",10,"General Practice"]
[11,"Central PHO",null,11,8,null,null,null,null,11,"Tokelauan",null,null,11,"10 Behaviour",11,"Gynaecology"]
[12,"Counties Manukau DHB",null,12,9,null,null,null,null,12,"Fijian",null,null,12,"11 Patient Accidents",12,"Hospice"]
[13,"Diaverum NZ",null,13,10,null,null,null,null,13,"Other Pacific Island",null,null,13,"12 Falls",13,"ICU",null,null,null,"Yes/No"]
[14,"Forte Health",null,14,11,null,null,null,null,14,"Asian not further defined",null,null,14,"13 Infrastructure/Building/Fixtures",14,"Inpatient Mental Health",null,null,0]
[15,"Hauora Tairāwhiti",null,15,12,null,null,null,null,15,"Southeast Asian",null,null,15,"14 Resources/Organisational Management",15,"Laboratory",null,null,1,"Yes"]
[16,"Hawke's Bay DHB",null,16,13,null,null,null,null,16,"Chinese",null,null,null,null,16,"Maternity",null,null,2,"No"]
[17,"Hospice West Auckland",null,17,14,null,null,null,null,17,"Indian",null,null,null,null,17,"Medical"]
[18,"Hutt Valley DHB",null,18,15,null,null,null,null,18,"Other Asian",null,null,null,null,18,"Neonatal"]
[19,"Lady Joy",null,19,16,null,null,null,null,19,"Middle Eastern",null,null,null,null,19,"Ophthalmology"]
[20,"Lakes DHB",null,20,17,null,null,null,null,20,"Latin American / Hispanic",null,null,null,null,20,"Orthopaedic"]
[21,"Mary Potter Hospice",null,21,18,null,null,null,null,21,"African",null,null,null,null,21,"Other"]
[22,"Mercy Ascot",null,22,19,null,null,null,null,22,"Other",null,null,null,null,22,"Outpatient"]
[23,"MidCentral DHB",null,23,20,null,null,null,null,23,"Not stated",null,null,null,null,23,"PACU"]
[24,"Nelson Bays Primary Health",null,24,21,null,null,null,null,null,null,null,null,null,null,24,"Paediatrics"]
[25,"Nelson Marlborough DHB",null,25,22,null,null,null,null,null,null,null,null,null,null,25,"Perioperative"]
[26,"New Zealand Defence Force",null,26,23,null,null,null,null,null,null,null,null,null,null,26,"Radiology"]
[27,"Northland DHB",null,27,24,null,null,null,null,null,null,null,null,null,null,27,"Rehabilitation"]
[28,"Nurse Maude Hospice",null,28,25,null,null,null,null,null,null,null,null,null,null,28,"Surgical"]
[29,"Other",null,29,26,null,null,null,null,null,null,null,null,null,null,29,"Urology"]
[30,"Palms Aged Care",null,30,27,null,null,null,null,null,null,null,null,null,null,30,"Women's Health"]
[31,"South Canterbury DHB",null,31,28]
[32,"Southern DHB",null,32,29]
[33,"St George's",null,33,30]
[34,"St John Ambulance",null,34,31]
[35,"Taranaki DHB",null,35,32]
[36,"Te Oranganui Trust",null,36,33]
[37,"The Salvation Army Homecare",null,37,34]
[38,"Totara Hospice",null,38,35]
[39,"Waikato DHB",null,39,36]
[40,"Wairarapa DHB",null,40,37]
[41,"Waitemata DHB",null,41,38]
[42,"Wellington Free Ambulance",null,42,39]
[43,"West Coast DHB",null,43,40]
[44,"Whanganui DHB",null,44,41]
[null,null,null,45,42]
[null,null,null,46,43]
[null,null,null,47,44]
[null,null,null,48,45]
[null,null,null,49,46]
[null,null,null,50,47]
[null,null,null,51,48]
[null,null,null,52,49]
[null,null,null,53,50]
[null,null,null,54,51]
[null,null,null,55,52]
[null,null,null,56,53]
[null,null,null,57,54]
[null,null,null,58,55]
[null,null,null,59,56]
[null,null,null,60,57]
[null,null,null,61,58]
[null,null,null,62,59]
[null,null,null,63,60]
[null,null,null,64,61]
[null,null,null,65,62]
[null,null,null,66,63]
[null,null,null,67,64]
[null,null,null,68,65]
[null,null,null,69,66]
[null,null,null,70,67]
[null,null,null,71,68]
[null,null,null,72,69]
[null,null,null,73,70]
[null,null,null,74,71]
[null,null,null,75,72]
[null,null,null,76,73]
[null,null,null,77,74]
[null,null,null,78,75]
[null,null,null,79,76]
[null,null,null,80,77]
[null,null,null,81,78]
[null,null,null,82,79]
[null,null,null,83,80]
[null,null,null,84,81]
[null,null,null,85,82]
[null,null,null,86,83]
[null,null,null,87,84]
[null,null,null,88,85]
[null,null,null,89,86]
[null,null,null,90,87]
[null,null,null,91,88]
[null,null,null,92,89]
[null,null,null,93,90]
[null,null,null,94,91]
[null,null,null,95,92]
[null,null,null,96,93]
[null,null,null,97,94]
[null,null,null,98,95]
[null,null,null,99,96]
[null,null,null,100,97]
[null,null,null,101,98]
[null,null,null,102,99]
[null,null,null,103,100]
[null,null,null,104,101]
[null,null,null,105,102]
[null,null,null,106,103]
[null,null,null,107,104]
[null,null,null,108,105]
[null,null,null,109,106]
[null,null,null,110,107]
[null,null,null,111,108]
[null,null,null,112,109]
[null,null,null,113,110]

{"sheet":"Data","index":2,"n_rows":15,"n_cols":43,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Provider","Other provider","Internal reference code","Event date","Internal notifcation date","Type of organisation 1 Ref","Type of organisation 2 Ref","Type of organisation 3 Ref","Type of organisation 4 Ref","Type of organisation 5 Ref","Type of organisation 6 Ref","Type of organisation 7 Ref","Type of organisation 8 Ref","Type of organisation 9 Ref","Type of organisation 9 Ref Listed","Type of organisation","WHO code","Provisional SAC rating ref","Provisional SAC rating","Near miss?","Near miss?","On ARR list Ref?","On ARR list?","ARR category","Any other providers?","Alert required ref","Alert required?","Description of event","Did the patient die ref","Did the patient die?","Patient Outcome","Other patient outcome","Clinical Area","Other clinical area","Age","Gender","Ethnicity 1","Ethnicity 2","Ethnicity 3","Name","Position","Date sent","Other info"]
[{"$f":"IF(Form!C6=0,\"\",Form!C6)","v":""},{"$f":"Form!C8","v":0},{"$f":"IF(Form!C12=0,\"\",Form!C12)","v":""},{"$f":"IF(Form!C15=0,\"\",Form!C15)","v":""},{"$f":"IF(Form!C18=0,\"\",Form!C18)","v":""},false,false,false,false,false,false,false,false,false,{"$f":"Form!D30","v":0},{"$f":"CONCATENATE(IF(F2,Lookups!$C$3,\"\"),\",\",IF(G2,Lookups!$C$4,\"\"),\",\",IF(H2,Lookups!$C$5,\"\"),\",\",IF(I2,Lookups!$C$6,\"\"),\",\",IF(J2,Lookups!$C$7,\"\"),\",\",IF(K2,Lookups!$C$8,\"\"),\",\",IF(L2,Lookups!$C$9,\"\"),\",\",IF(M2,Lookups!$C$10,\"\"),\",\",IF(N2,O2,IF(O2=0,\"\",\"Missing 'Other' in form\")))","v":",,,,,,,,"},{"$f":"IF(Form!C32=0,\"\",Form!C32)","v":""},0,{"$f":"IF(R2=0,\"\",R2)","v":""},0,{"$f":"IF(VLOOKUP(T2,Lookups!$T$14:$U$17,2,FALSE)=0,\"\",VLOOKUP(T2,Lookups!$T$14:$U$17,2,FALSE))","v":""},0,{"$f":"IF(VLOOKUP(V2,Lookups!T14:U17,2,FALSE)=0,\"\",VLOOKUP(V2,Lookups!T14:U17,2,FALSE))","v":""},{"$f":"IF(Form!D41=0,\"\",Form!D41)","v":""},{"$f":"IF(Form!$C$44=0,\"\",Form!C44)","v":""},0,{"$f":"IF(VLOOKUP(Z2,Lookups!$T$14:$U$17,2,FALSE)=0,\"\",VLOOKUP(Z2,Lookups!$T$14:$U$17,2,FALSE))","v":""},{"$f":"IF(Form!$C$48=0,\"\",Form!$C$48)","v":""},0,{"$f":"IF(AC2=0,\"\",IF(AC2=1,\"Yes\",\"No\"))","v":""},{"$f":"IF(Form!C56=0,\"\",Form!C56)","v":""},{"$f":"Form!C58","v":0},{"$f":"IF(Form!C62=0,\"\",Form!C62)","v":""},{"$f":"Form!C65","v":0},{"$f":"IF(Form!C70=0,\"\",Form!C70)","v":""},{"$f":"IF(Form!C72=0,\"\",Form!C72)","v":""},{"$f":"IF(Form!C75=0,IF(Form!F75=0,\"\",Form!F75),Form!C75)","v":""},{"$f":"IF(Form!F77=0,IF(Form!F77=0,\"\",Form!F77),Form!F77)","v":""},{"$f":"IF(Form!F79=0,IF(Form!F79=0,\"\",Form!F79),Form!F79)","v":""},{"$f":"IF(Form!C83=0,\"\",Form!C83)","v":""},{"$f":"IF(Form!C85=0,\"\",Form!C85)","v":""},{"$f":"IF(Form!C87=0,\"\",Form!C87)","v":""},{"$f":"IF(Form!C89=0,\"\",Form!C89)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Actual values"]
["Reference values"]