{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","OASIS Calculation","Ranges"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[10,1,12,1]]}
["INSTRUCTIONS"]
[]
["To calculate heart rate, respiratory rate, mean arterial pressure, and temperature:","Following the methodology precisely, determine the physiological variable furthest from the reference point, whether higher or lower/above or below.  Assign OASIS points to that single, most deviant value."]
[]
["To calculate GCS:","Take the lowest measurement."]
[]
["To calculate urine output:","The volume of urine excreted over a 24 hour period should be used."]
[]
["Mecahnical ventilation:","Patient is placed on a ventilator at any time during day 1."]
[]
["Pre-ICU LOS:","This corresponds to the square root of the number of days the patient was in the hospital before being admitted to the ICU. It is transformed into hours."]
[]
[]
[null,"Example: patient admitted to hospital on JAN/1/2013 at 06:00"]
[null,"Patient admitted to ICU on JAN/2/2013 at 09:00"]
[null,"(JAN/2/2013 06:00 - JAN/1/2013 09:00) = 1.125 days"]
[null,"Square root of 1.125 days = 1.0607 days"]
[null,"Pre-ICU LOS = 24*1.0607 = 25.46"]
[]
["Enter values in the OASIS Calculation Worksheet, Column B. "]
["Push the  grey button to calculate OASIS."]

{"sheet":"OASIS Calculation","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[8,0,9,0]]}
["Variable","Value"]
["Pulse (beats/min)",93]
["Select heart rate furthest from 75"]
[null,null,null,null,null,null," "]
["Respiratory Rate (breaths/min)",14,null,null,null," "]
["Select respiratory rate furthest from 19",null,null,null,null,20," "]
[null,null,null,null,null," "]
["Temperature (degrees Centigrade)",36.200000000000003,null,null,null," "]
["Select core temperature furthest from 38. Add 1 degree Centigrade to axillary temps prior to selecting worst value"]
[]
[]
["Mean Blood Pressure (MAP)",31.33]
["Select MAP furthest from 90"]
[]
["Urine Ouput (cc/day)",808.7]
[" "]
["Glasgow Coma Score",15]
[" "]
["Square root of pre-ICU length of stay (hours.)",4.41]
[" "]
["Age (years)",73]
[" "]
["Ventilated (y/n)","n"]
[]
["Elective Surgery (y/n)","y"]

{"sheet":"Ranges","index":2,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["Variable","Low Range","High Range","Weights"]
["Pulse (beats/min)",1,32,4,{"$f":"IF(AND('OASIS Calculation'!B2 >= Ranges!B2,'OASIS Calculation'!B2 <= Ranges!C2), 1,0)","v":0},{"$f":"D2*E2","v":0}]
["Select heart rate furthest from 75",33,88,0,{"$f":"IF(AND('OASIS Calculation'!B$2 >= Ranges!B3,'OASIS Calculation'!B$2<= Ranges!C3), 1,0)","v":0},{"$f":"D3*E3","v":0}]
[null,89,106,1,{"$f":"IF(AND('OASIS Calculation'!B$2 >= Ranges!B4,'OASIS Calculation'!B$2<= Ranges!C4), 1,0)","v":1},1]
[null,107,125,3,{"$f":"IF(AND('OASIS Calculation'!B$2 >= Ranges!B5,'OASIS Calculation'!B$2<= Ranges!C5), 1,0)","v":0},0]
[null,126,200,6,{"$f":"IF(AND('OASIS Calculation'!B$2 >= Ranges!B6,'OASIS Calculation'!B$2<= Ranges!C6), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Respiratory Rate (breaths/min)",1,5,10,{"$f":"IF(AND('OASIS Calculation'!B$5 >= Ranges!B8,'OASIS Calculation'!B$5<= Ranges!C8), 1,0)","v":0},0]
["Select respiratory rate furthest from 19",6,12,1,{"$f":"IF(AND('OASIS Calculation'!B$5 >= Ranges!B9,'OASIS Calculation'!B$5<= Ranges!C9), 1,0)","v":0},0]
[null,12,22,0,{"$f":"IF(AND('OASIS Calculation'!B$5 >= Ranges!B10,'OASIS Calculation'!B$5<= Ranges!C10), 1,0)","v":1},0]
[null,23,30,1,{"$f":"IF(AND('OASIS Calculation'!B$5 >= Ranges!B11,'OASIS Calculation'!B$5<= Ranges!C11), 1,0)","v":0},0]
[null,31,44,6,{"$f":"IF(AND('OASIS Calculation'!B$5 >= Ranges!B12,'OASIS Calculation'!B$5<= Ranges!C12), 1,0)","v":0},0]
[null,45,100,9,{"$f":"IF(AND('OASIS Calculation'!B$5 >= Ranges!B13,'OASIS Calculation'!B$5<= Ranges!C13), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Temperature (degrees Centigrade)",25,33.21,3,{"$f":"IF(AND('OASIS Calculation'!B$8>= Ranges!B15,'OASIS Calculation'!B$8<= Ranges!C15), 1,0)","v":0},0]
["Select core temperature furthest from 38.",33.22,35.93,4,{"$f":"IF(AND('OASIS Calculation'!B$8>= Ranges!B16,'OASIS Calculation'!B$8<= Ranges!C16), 1,0)","v":0},0]
["Add 1 degree Centigrade to axillary temps",35.94,36.39,2,{"$f":"IF(AND('OASIS Calculation'!B$8>= Ranges!B17,'OASIS Calculation'!B$8<= Ranges!C17), 1,0)","v":1},2]
["prior to selecting worst value",36.4,36.880000000000003,0,{"$f":"IF(AND('OASIS Calculation'!B$8>= Ranges!B18,'OASIS Calculation'!B$8<= Ranges!C18), 1,0)","v":0},0]
[null,36.89,39.880000000000003,2,{"$f":"IF(AND('OASIS Calculation'!B$8>= Ranges!B19,'OASIS Calculation'!B$8<= Ranges!C19), 1,0)","v":0},0]
[null,39.89,45,6,{"$f":"IF(AND('OASIS Calculation'!B$8>= Ranges!B20,'OASIS Calculation'!B$8<= Ranges!C20), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Mean Blood Pressure (MAP)",5,20.65,4,{"$f":"IF(AND('OASIS Calculation'!B$12>= Ranges!B22,'OASIS Calculation'!B$12<= Ranges!C22), 1,0)","v":0},0]
["Select MAP furthest from 90",20.66,50.99,3,{"$f":"IF(AND('OASIS Calculation'!B$12>= Ranges!B23,'OASIS Calculation'!B$12<= Ranges!C23), 1,0)","v":1},3]
[null,51,61.32,2,{"$f":"IF(AND('OASIS Calculation'!B$12>= Ranges!B24,'OASIS Calculation'!B$12<= Ranges!C24), 1,0)","v":0},0]
[null,61.33,143.44,0,{"$f":"IF(AND('OASIS Calculation'!B$12>= Ranges!B25,'OASIS Calculation'!B$12<= Ranges!C25), 1,0)","v":0},0]
[null,143.44999999999999,240,3,{"$f":"IF(AND('OASIS Calculation'!B$12>= Ranges!B26,'OASIS Calculation'!B$12<= Ranges!C26), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Urine Ouput (cc/day)",1,670,10,{"$f":"IF(AND('OASIS Calculation'!B$15>= Ranges!B28,'OASIS Calculation'!B$15<= Ranges!C28), 1,0)","v":0},0]
[" ",671,1426,5,{"$f":"IF(AND('OASIS Calculation'!B$15>= Ranges!B29,'OASIS Calculation'!B$15<= Ranges!C29), 1,0)","v":1},5]
[null,1427,2543,1,{"$f":"IF(AND('OASIS Calculation'!B$15>= Ranges!B30,'OASIS Calculation'!B$15<= Ranges!C30), 1,0)","v":0},0]
[null,2544,6896,0,{"$f":"IF(AND('OASIS Calculation'!B$15>= Ranges!B31,'OASIS Calculation'!B$15<= Ranges!C31), 1,0)","v":0},0]
[null,6897,12000,8,{"$f":"IF(AND('OASIS Calculation'!B$15>= Ranges!B32,'OASIS Calculation'!B$15<= Ranges!C32), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Glasgow Coma Score",3,7,10,{"$f":"IF(AND('OASIS Calculation'!B$17>= Ranges!B34,'OASIS Calculation'!B$17<= Ranges!C34), 1,0)","v":0},0]
[" ",8,13,4,{"$f":"IF(AND('OASIS Calculation'!B$17>= Ranges!B35,'OASIS Calculation'!B$17<= Ranges!C35), 1,0)","v":0},0]
[null,14,14,3,{"$f":"IF(AND('OASIS Calculation'!B$17>= Ranges!B36,'OASIS Calculation'!B$17<= Ranges!C36), 1,0)","v":0},0]
[null,15,15,0,{"$f":"IF(AND('OASIS Calculation'!B$17>= Ranges!B37,'OASIS Calculation'!B$17<= Ranges!C37), 1,0)","v":1},0]
[null,"Low Range","High Range","Weights"]
["Pre-ICU length of stay (hrs.)",0,0.16,5,{"$f":"IF(AND('OASIS Calculation'!B$19>= Ranges!B39,'OASIS Calculation'!B$19<= Ranges!C39), 1,0)","v":0},0]
[" ",0.17,4.9400000000000004,3,{"$f":"IF(AND('OASIS Calculation'!B$19>= Ranges!B40,'OASIS Calculation'!B$19<= Ranges!C40), 1,0)","v":1},3]
[null,4.95,24,0,{"$f":"IF(AND('OASIS Calculation'!B$19>= Ranges!B41,'OASIS Calculation'!B$19<= Ranges!C41), 1,0)","v":0},0]
[null,24.01,311.8,2,{"$f":"IF(AND('OASIS Calculation'!B$19>= Ranges!B42,'OASIS Calculation'!B$19<= Ranges!C42), 1,0)","v":0},0]
[null,311.81,960,1,{"$f":"IF(AND('OASIS Calculation'!B$19>= Ranges!B43,'OASIS Calculation'!B$19<= Ranges!C43), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Age (years)",18,24,0,{"$f":"IF(AND('OASIS Calculation'!B$21>= Ranges!B45,'OASIS Calculation'!B$21<= Ranges!C45), 1,0)","v":0},{"$f":"D45*E45","v":0}]
[" ",25,53,3,{"$f":"IF(AND('OASIS Calculation'!B$21>= Ranges!B46,'OASIS Calculation'!B$21<= Ranges!C46), 1,0)","v":0},0]
[null,54,77,6,{"$f":"IF(AND('OASIS Calculation'!B$21>= Ranges!B47,'OASIS Calculation'!B$21<= Ranges!C47), 1,0)","v":1},6]
[null,78,89,9,{"$f":"IF(AND('OASIS Calculation'!B$21>= Ranges!B48,'OASIS Calculation'!B$21<= Ranges!C48), 1,0)","v":0},0]
[null,90,100,7,{"$f":"IF(AND('OASIS Calculation'!B$21>= Ranges!B49,'OASIS Calculation'!B$21<= Ranges!C49), 1,0)","v":0},0]
[null,"Low Range","High Range","Weights"]
["Ventilated","N","N",0,{"$f":"VLOOKUP(UPPER('OASIS Calculation'!B23),vent,3,FALSE)","v":0},{"$f":"E51","v":0}]
[null,"Y","Y",9]
[null,"Low Range","High Range","Weights"]
["Elective Surgery","N","N",6,{"$f":"VLOOKUP(UPPER('OASIS Calculation'!B25),elect,3,FALSE)","v":0},{"$f":"E54","v":0}]
[null,"Y","Y",0]