{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSTRUCTIONS","OVERVIEW","Template DO NOT USE","Ventilators"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":5,"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":"INSTRUCTIONS","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[22,0,22,3],[20,0,20,3],[17,0,17,3],[3,0,3,3],[6,0,6,3],[10,0,10,3],[12,0,12,3],[16,0,16,3],[13,0,13,3],[7,0,7,3],[21,0,21,3],[15,0,15,3],[14,0,14,3],[18,0,18,3],[19,0,19,3],[39,0,39,3],[29,0,29,3],[28,0,28,3],[23,0,23,3],[25,0,25,3],[24,0,24,3],[32,0,32,3],[34,0,34,3],[35,0,35,3],[37,0,37,3],[38,0,38,3],[31,0,31,3],[26,0,26,3],[27,0,27,3],[33,0,33,3]]}
["DOUBLE CLICK BELOW TO OPEN INSTRUCTIONS"]

{"sheet":"OVERVIEW","index":1,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,0,16,4],[0,3,0,5],[2,0,2,5],[3,0,3,5]]}
["Institute of Healthcare Engineering and Estate Management"]
[]
["HOW TO USE THE ASSESSMENT TOOL:"]
["The IHEEM assessment tool is designed to allow for analysis of a hospitals current piped oxygen capability based on a series of guideline assumptions.  The tool allows the user to create a custom care plan and assess the resultant capability of the hospital to deliver the levels required."]
["GET STARTED:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Example Organisation"]
[]
["HOSPITAL","FLOW CAPACITY (l/m)","EXISTING SITE MEDICAL GAS FLOW RATE (l/m)","COVID PLANNED FLOW (l/m)","RESULT"]

{"sheet":"Template DO NOT USE","index":2,"n_rows":105,"n_cols":47,"rows_kept":105,"cut":false,"hidden":true,"merged":[[0,4,0,15],[31,10,31,13],[32,12,32,13],[32,10,32,11],[3,1,3,2],[4,1,4,2],[6,11,6,16],[31,1,31,2],[32,4,32,6],[31,4,31,6],[6,1,6,6],[1,42,6,42],[2,1,2,5],[7,10,7,15],[33,4,35,6],[33,12,33,13],[33,10,33,11]]}
[null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"Template DO NOT USE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(K34) + SUM(Q33:Q37)","v":0},null,null,{"$f":"_xlfn.CONCAT(K34:N34)","v":""},{"$f":"K34*M34","v":0},{"$f":"D$4/100*B34*C34","v":100}]
[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,{"$f":"_xlfn.CONCAT(K35:N35)","v":""},{"$f":"$D$4/100*K35*M35","v":0},{"$f":"D$4/100*B35*C35","v":350},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ2","v":0}]
[null,"HOSPITAL SUMMARY TABLE",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,{"$f":"_xlfn.CONCAT(K36:N36)","v":""},{"$f":"$D$4/100*K36*M36","v":0},{"$f":"D$4/100*B36*C36","v":840}]
[null,"No. of Beds ",null,100,"RESULT EXISTING FLOW (Left Graph)",{"$f":"AF9","v":1290},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity",{"$f":"$D$5","v":4500},{"$f":"$D$5","v":4500},4500,4500]
[null,"Max Evap Flow",null,4500,"RESULT COVID 19 (Right Graph)",{"$f":"AG18","v":0}]
[]
[null,"EXISTING SITE O2 MEDICAL GAS FLOW RATE",null,null,null,null,null,null,null,null,null,"COVID19 PLANNED O2 MEDICAL GAS FLOW RATE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warning Level",{"$f":"AE4*0.85","v":3825},{"$f":"AF4*0.85","v":3825},3825,3825,null,null,null,{"$f":"_xlfn.CONCAT(B34,\"% @\",C34,\"l/m\")","v":"50% @2l/m"}]
[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,{"$f":"_xlfn.CONCAT(B35,\"% @\",C35,\"l/m\")","v":"35% @10l/m"}]
[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,{"$f":"IF(Q33<>\"\",IF(P33<>\"\",VLOOKUP(P33,Table1[],2,FALSE)*'Template DO NOT USE'!Q33,\"\"),\"\")","v":""},{"$f":"SUM(AE1:AE3) +AE8","v":0},{"$f":"SUM(AF1:AF3)+ AF8","v":1290},null,null,null,null,null,"12% @70l/m"]
[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,{"$f":"IF(Q34<>\"\",IF(P34<>\"\",VLOOKUP(P34,Table1[],2,FALSE)*'Template DO NOT USE'!Q34,\"\"),\"\")","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,{"$f":"IF(Q35<>\"\",IF(P35<>\"\",VLOOKUP(P35,Table1[],2,FALSE)*'Template DO NOT USE'!Q35,\"\"),\"\")","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,{"$f":"IF(Q36<>\"\",IF(P36<>\"\",VLOOKUP(P36,Table1[],2,FALSE)*'Template DO NOT USE'!Q36,\"\"),\"\")","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,{"$f":"IF(Q37<>\"\",IF(P37<>\"\",VLOOKUP(P37,Table1[],2,FALSE)*'Template DO NOT USE'!Q37,\"\"),\"\")","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,{"$f":"IF(V14<>\"\",IF(U14<>\"\",VLOOKUP(U14,Table1[],2,FALSE)*'Template DO NOT USE'!V14,\"\"),\"\")","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,{"$f":"IF(V15<>\"\",IF(U15<>\"\",VLOOKUP(U15,Table1[],2,FALSE)*'Template DO NOT USE'!V15,\"\"),\"\")","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,{"$f":"IF(V16<>\"\",IF(U16<>\"\",VLOOKUP(U16,Table1[],2,FALSE)*'Template DO NOT USE'!V16,\"\"),\"\")","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,{"$f":"IF(V17<>\"\",IF(U17<>\"\",VLOOKUP(U17,Table1[],2,FALSE)*'Template DO NOT USE'!V17,\"\"),\"\")","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,{"$f":"IF(V18<>\"\",IF(U18<>\"\",VLOOKUP(U18,Table1[],2,FALSE)*'Template DO NOT USE'!V18,\"\"),\"\")","v":""},null,null,{"$f":"AE1+AE2+AE3+AD37+AE8","v":0},null,null,null,null,{"$f":"_xlfn.CONCAT(\"NORMAL USAGE \",K34,\" BEDS @ \",M34,\"l/m\")","v":"NORMAL USAGE  BEDS @ l/m"}]
[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,{"$f":"IF(V19<>\"\",IF(U19<>\"\",VLOOKUP(U19,Table1[],2,FALSE)*'Template DO NOT USE'!V19,\"\"),\"\")","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,{"$f":"IF(V20<>\"\",IF(U20<>\"\",VLOOKUP(U20,Table1[],2,FALSE)*'Template DO NOT USE'!V20,\"\"),\"\")","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,{"$f":"IF(V21<>\"\",IF(U21<>\"\",VLOOKUP(U21,Table1[],2,FALSE)*'Template DO NOT USE'!V21,\"\"),\"\")","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,{"$f":"IF(V22<>\"\",IF(U22<>\"\",VLOOKUP(U22,Table1[],2,FALSE)*'Template DO NOT USE'!V22,\"\"),\"\")","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,{"$f":"IF(V23<>\"\",IF(U23<>\"\",VLOOKUP(U23,Table1[],2,FALSE)*'Template DO NOT USE'!V23,\"\"),\"\")","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,{"$f":"IF(V24<>\"\",IF(U24<>\"\",VLOOKUP(U24,Table1[],2,FALSE)*'Template DO NOT USE'!V24,\"\"),\"\")","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,{"$f":"IF(V25<>\"\",IF(U25<>\"\",VLOOKUP(U25,Table1[],2,FALSE)*'Template DO NOT USE'!V25,\"\"),\"\")","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,{"$f":"IF(V26<>\"\",IF(U26<>\"\",VLOOKUP(U26,Table1[],2,FALSE)*'Template DO NOT USE'!V26,\"\"),\"\")","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,{"$f":"IF(V27<>\"\",IF(U27<>\"\",VLOOKUP(U27,Table1[],2,FALSE)*'Template DO NOT USE'!V27,\"\"),\"\")","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,{"$f":"IF(V28<>\"\",IF(U28<>\"\",VLOOKUP(U28,Table1[],2,FALSE)*'Template DO NOT USE'!V28,\"\"),\"\")","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,{"$f":"IF(V29<>\"\",IF(U29<>\"\",VLOOKUP(U29,Table1[],2,FALSE)*'Template DO NOT USE'!V29,\"\"),\"\")","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,{"$f":"IF(V30<>\"\",IF(U30<>\"\",VLOOKUP(U30,Table1[],2,FALSE)*'Template DO NOT USE'!V30,\"\"),\"\")","v":""}]
[]
[null,"BASE MODEL ADJUSTMENT",null,null,"Analysis Chart (Left) Calculated using current best practice as follows:",null,null,null,null,null,"PLANNED NON COVID 19\nCARE BED FLOW RATES",null,null,null,null,null,"QTY","@ l/m",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V32<>\"\",IF(U32<>\"\",VLOOKUP(U32,Table1[],2,FALSE)*'Template DO NOT USE'!V32,\"\"),\"\")","v":""}]
[null,"Bed%","Flow Rate (l/m)",null,"50% @ 2 l/m 35% @ 10 l/m 12% @ 70 l/m",null,null,null,null,null,"Beds",null,"Flow Rate(l/m)",null,null,"O type patient (facemask)",null,{"$f":"VLOOKUP(P33,Table1[],2,FALSE)","v":10},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V33<>\"\",IF(U33<>\"\",VLOOKUP(U33,Table1[],2,FALSE)*'Template DO NOT USE'!V33,\"\"),\"\")","v":""}]
[null,50,2,null,"Analysis Chart (Right) Calculated using National Guidance Medical Gas Flow Rates set out by the NHSE National Director for Critical Care England",null,null,null,null,null,null,null,null,null,null,"O+ type patient (Non Invasive Ventilator)",null,{"$f":"VLOOKUP(P34,Table1[],2,FALSE)","v":15},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V34<>\"\",IF(U34<>\"\",VLOOKUP(U34,Table1[],2,FALSE)*'Template DO NOT USE'!V34,\"\"),\"\")","v":""}]
[null,35,10,null,null,null,null,null,null,null,null,null,null,null,null,"O+ type Venturi / whispalite",null,{"$f":"VLOOKUP(P35,Table1[],2,FALSE)","v":"40"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V35<>\"\",IF(U35<>\"\",VLOOKUP(U35,Table1[],2,FALSE)*'Template DO NOT USE'!V35,\"\"),\"\")","v":""}]
[null,12,70,null,null,null,null,null,null,null,null,null,null,null,null,"High flow o2 driven CPAP NIV",null,{"$f":"VLOOKUP(P36,Table1[],2,FALSE)","v":"70"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V type patient (intubated through a ventilator)",null,{"$f":"VLOOKUP(P37,Table1[],2,FALSE)","v":20},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD9:AD35)","v":0}]
[]
["Ver 1.13 23/04/2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"PASS",{"$f":"AA103","v":0}]
[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,"FAIL"]
[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,"WARNING"]

{"sheet":"Ventilators","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Ventilators"," l/min "]
["O type patient (facemask)",10]
["O+ type patient (Non Invasive Ventilator)",15]
["O+ type Venturi / whispalite","40"]
["High flow O2 driven CPAP NIV","70"]
["V type patient (intubated through a ventilator)",20]
[null,123]