{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Start","Arrival list T=15","Arrival list T=30","Arrival list T=45","Arrival list T=60","Arrival list T=75","Advanced","Red","Yellow","Green","tempspace"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":16,"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":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,0,0,2]]}
["Arrival List Generator"]
[null,{"$f":"TODAY()","v":"2014-12-05"}]
["INTRODUCTION:  How to use this workbook"]
[]
["This workbook is meant for use prior to the start of the exercise.  It generates the lists of arriving patients to be handed to the players in the emergency department at 15-minute intervals.   On the next tab (\"Start\"), the user should enter the total number of mass casualty patients to arrive at the hospital, and then press the \"Generate List\" button.   The spreadsheet then picks randomly from a bank of patient descriptions to create four lists (e.g., \"Arrival list T=15\"), which can then be printed.   The patient descriptions on the arrival list sheets are scrambled in a random order.  It is up to the ED players to determine which patients are red, yellow, or green.   "]
[]
["Default assumptions","The rate at which patients arrive and the distribution of red, yellow, and green patients is based upon published accounts of terrorist bombing incidents.   At default, the sheet assumes that 8% of patients arrive during the T=15 interval, 22% at T=30, 34% at T=45, and 36% at T=60.    The acuity also is assumed to change over time:  The proportion of arrivals that are green drops from 90% at the T=15 interval to 52% at the T=60 interval, while the proportion that are red increases from 0% at the T=15 interval to 23% at the T=60 interval.    These proportions can be changed by the user if desired (see \"Advanced customization\" below)."]
[]
["Choosing the total number of patients","The default number of patients is 250, which should be appropriate for a medium to large hospital.  As a rough rule of thumb, consider half the number of licensed inpatient beds as a starting point (e.g., for a 500-bed hospital, 250 mass casualty arrivals might be reasonable).   Provide enough to stress the hospital, but not to overwhelm it.   Keep in mind that most of the patients will be \"walking wounded.\""]
[]
["Advanced customization","This worksheet contains several hidden tabs with additional information that can be changed as desired.  The \"Advanced\" tab contains a table showing the proportion of total patients arriving at each interval and the proportion of each interval's arrivals that are red, yellow, and green.   All of those proportions can be changed.  The three colored tabs (red, yellow, green) contain the master list of patient descriptions for the corresponding triage category.    The spreadsheet takes random picks off of these lists to create the \"arrival list\" tabs.  The master list descriptions can be changed.\n\nTo unhide a tab, hold your mouse over the other tabs, right-click, and choose the \"unhide\" option."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Start","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,10],[5,0,5,6],[13,0,13,4],[8,0,8,1],[24,0,24,5],[11,0,11,6]]}
["Arrival List Generator"]
["Instructions:  "]
[]
["1.  If a yellow ribbon that says \"Security Warning  Macros have been disabled\" appears at the top of the screen, click \"Enable Content\""]
[]
["2.  Enter the total number of mass casualty patients for the exercise into cell C5, and press \"Generate List.\"  "]
[]
[]
["Total # of Arrivals:",null,250]
[]
[]
["Based on the total you entered, the numbers of red, yellow, and green patients that will arrive at each interval are as follows:"]
[]
["Number of patients arriving at each time interval"]
["Arrival Time","Red Patients","Yellow Patients","Green Patients","Total "]
[15,{"$f":"ROUND(E16*Advanced!C7,0)","v":0},{"$f":"ROUND(E16*Advanced!D7,0)","v":2},{"$f":"E16-(B16+C16)","v":18},{"$f":"ROUND($C$9*Advanced!B7,0)","v":20}]
[30,{"$f":"ROUND(E17*Advanced!C8,0)","v":5},{"$f":"ROUND(E17*Advanced!D8,0)","v":10},{"$f":"E17-(B17+C17)","v":40},{"$f":"ROUND($C$9*Advanced!B8,0)","v":55}]
[45,{"$f":"ROUND(E18*Advanced!C9,0)","v":9},{"$f":"ROUND(E18*Advanced!D9,0)","v":10},{"$f":"E18-(B18+C18)","v":66},{"$f":"ROUND($C$9*Advanced!B9,0)","v":85}]
[60,{"$f":"ROUND(E19*Advanced!C10,0)","v":21},{"$f":"ROUND(E19*Advanced!D10,0)","v":23},{"$f":"E19-(B19+C19)","v":46},{"$f":"ROUND($C$9*Advanced!B10,0)","v":90}]
["Total",{"$f":"SUM(B16:B19)","v":35},{"$f":"SUM(C16:C19)","v":45},{"$f":"SUM(D16:D19)","v":170},{"$f":"SUM(E16:E19)","v":250}]
[]
["3.  Print out the lists of arriving patients for each time interval on the next four tabs (\"Arrival list T=XX\")"]

{"sheet":"Arrival list T=15","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Arrival List T=15","Red/yellow/green"]
["1.   Superficial chest wound, no respiratory distress, ambulatory"]
["2.   Coughing, able to speak in full sentences"]
["3.   Sprained ankle, walking with severe limp"]
["4.   C/o thumb deformity"]
["5.   Multiple bruises, ambulatory"]
["6.   C/o second-degree forearm burn"]
["7.   Coughing, deaf"]
["8.   Left lower extremity injury, foot cool but pulse is palpable, BP 120/70"]
["9.   Coughing"]
["10.   Chest wound, walking around, no respiratory distress"]
["11.   Coughing and gagging"]
["12.   Coughing, complaining of burning eyes"]
["13.   C/o head injury, no headache, ambulatory, GCS 15"]
["14.   Walking around, c/o facial lacerations"]
["15.   Multiple extremity fractures, can't walk"]
["16.   Pointing to ears, walking"]
["17.   4cm leg laceration, no active bleeding"]
["18.   Burning eyes"]
["19.   Scalp laceration, no active bleeding"]
["20.   C/o ear pain & deafness"]

{"sheet":"Arrival list T=30","index":3,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Arrival List T=30","Red/yellow/green"]
["1.   Scalp laceration, no active bleeding"]
["2.   Debris in eyes"]
["3.   Respiratory rate 50, trachea deviated to left"]
["4.   Gasping respirations, radial pulse not palpable"]
["5.   Walking around, appears stunned"]
["6.   Coughing and gagging"]
["7.   Scattered second-degree burns, <15% body surface"]
["8.   C/o second-degree forearm burn"]
["9.   Sobbing, walking around"]
["10.   Chest wound, no respiratory distress, no active bleeding, ambulatory"]
["11.   Scattered second-degree burns, <15% body surface"]
["12.   Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]
["13.   C/o head injury, calm, GCS 15"]
["14.   Scalp laceration, EBL 500cc, dazed, various superficial shrapnel wounds"]
["15.   Scalp contusion, c/o neck pain, on backboard"]
["16.   Multiple small lacerations"]
["17.   First-degree facial burns, emotional distress"]
["18.   Coughing, deaf"]
["19.   Covered in soot, agitated, ambulatory"]
["20.   Head injury, left pupil fixed, dilated, GCS 8"]
["21.   74-year-old, shortness of breath, O2 sat 99%, RR 12, BP 124/83, HR 105"]
["22.   C/o head injury, calm, GCS 15"]
["23.   Superficial chest wound, no respiratory distress, ambulatory"]
["24.   C/o debris in eyes, PERRL, vision grossly intact"]
["25.   Crushed ankle, severe pain"]
["26.   Proximal arm amputation, BP 74/p"]
["27.   Sprained ankle"]
["28.   Burn on right forearm and dorsum of left wrist"]
["29.   Covered in soot, agitated, ambulatory"]
["30.   Multiple abrasions, ambulatory"]
["31.   First-degree facial burns, emotional distress"]
["32.   Back pain, unable to move legs, vitals stable"]
["33.   Crushed ankle, severe pain"]
["34.   C/o debris in eyes, PERRL, vision grossly intact"]
["35.   Appears to be deaf"]
["36.   Covered in soot, agitated, ambulatory"]
["37.   Covered in soot, agitated, ambulatory"]
["38.   Open femur fracture, bleeding controlled, normal distal perfusion"]
["39.   C/o ear pain & deafness"]
["40.   Scalp laceration, no active bleeding"]
["41.   Pointing to ears, walking"]
["42.   Scalp contusion, c/o neck pain, on backboard"]
["43.   24 weeks pregnant, abdominal cramping, currently pain-free"]
["44.   Multiple abrasions, ambulatory"]
["45.   Covered in soot, agitated, ambulatory"]
["46.   Scattered second-degree burns, <15% body surface"]
["47.   Pointing to ears, walking"]
["48.   Complaining of deafness"]
["49.   Scattered second-degree burns, <15% body surface"]
["50.   Debris in eyes"]
["51.   Multiple bruises, ambulatory"]
["52.   Appears to be deaf"]
["53.   Covered in soot, ambulatory"]
["54.   Can't walk due to groin pain, radial pulses intact"]
["55.   Intubated by EMS for respiratory distress"]

{"sheet":"Arrival list T=45","index":4,"n_rows":86,"n_cols":2,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Arrival List T=45","Red/yellow/green"]
["1.   Leg laceration, no active bleeding, ambulatory"]
["2.   Walking around, c/o facial lacerations, no active bleeding"]
["3.   Moaning, not responding to questions, head trauma"]
["4.   Coughing, deaf"]
["5.   Extensive lower extremity deformities, moaning"]
["6.   C/o debris in eyes, PERRL, vision grossly intact"]
["7.   Multiple small lacerations"]
["8.   Obvious head trauma, GCS 15, c/o posterior neck pain"]
["9.   C/o ear pain & deafness"]
["10.   Intubated in field"]
["11.   Severe burns over >50% of body, lethargic, moaning"]
["12.   Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]
["13.   Leg laceration, no active bleeding, ambulatory"]
["14.   C/o head injury, calm, GCS 15"]
["15.   Leg laceration, no active bleeding, ambulatory"]
["16.   Wrist deformity, neurovascularly intact"]
["17.   Coughing, able to speak in full sentences"]
["18.   Proximal arm amputation, BP 74/p"]
["19.   C/o debris in eyes, PERRL, vision grossly intact"]
["20.   Scalp contusion, c/o neck pain, on backboard"]
["21.   Scattered second-degree burns, <15% body surface"]
["22.   Coughing, deaf"]
["23.   Burn on right forearm and dorsum of left wrist"]
["24.   First-degree facial burns, emotional distress"]
["25.   Multiple lacerations, ambulatory, calm"]
["26.   Multiple contusions and abrasions, ambulatory"]
["27.   Multiple contusions and abrasions, ambulatory"]
["28.   Multiple bruises, ambulatory"]
["29.   Scalp laceration with pressure dressing, GCS 15"]
["30.   Sprained ankle"]
["31.   Abdominal pain, LUQ bruise, hypotension"]
["32.   Multiple superficial lacerations, ambulatory, calm"]
["33.   74-year-old, shortness of breath, chest pain, O2 sat 99%, RR 12, BP 124/83, HR 105"]
["34.   C/o thumb deformity"]
["35.   Debris in eyes"]
["36.   Coughing, deaf"]
["37.   Coughing, able to speak in full sentences"]
["38.   Multiple abrasions, appears upset, ambulatory"]
["39.   C/o thumb deformity"]
["40.   Multiple small lacerations"]
["41.   C/o thumb deformity"]
["42.   Crushing chest pain, ST elevations in anterior precordial leads"]
["43.   Knee dislocation, distal perfusion intact"]
["44.   Pointing to ears, walking"]
["45.   Scalp laceration with pressure dressing, GCS 15"]
["46.   Multiple bruises, ambulatory"]
["47.   Pointing to ears, walking"]
["48.   Coughing and gagging"]
["49.   Open fracture left knee"]
["50.   Burn on right forearm and dorsum of left wrist"]
["51.   Arm wound, no active bleeding"]
["52.   Back pain, unable to move legs, vitals stable"]
["53.   Chest wound, walking around, no respiratory distress"]
["54.   Multiple contusions and abrasions, ambulatory"]
["55.   Burn on right forearm and dorsum of left wrist"]
["56.   Walking around, appears stunned"]
["57.   Burn on right forearm and dorsum of left wrist"]
["58.   Pointing to ears, walking"]
["59.   Scattered second-degree burns, <15% body surface"]
["60.   Scalp laceration with pressure dressing, GCS 15"]
["61.   Walking, c/o facial lacerations, no active bleeding"]
["62.   Incoherent, obvious head trauma"]
["63.   C/o second-degree forearm burn"]
["64.   Left lower extremity injury, foot cool and pale, BP 120/70"]
["65.   Left lower extremity injury, foot cool and pale, BP 120/70"]
["66.   Multiple extremity fractures, can't walk"]
["67.   C/o second-degree forearm burn"]
["68.   C/o thumb deformity"]
["69.   Burning eyes"]
["70.   Severe burns over >50% of body, lethargic, moaning"]
["71.   Coughing, able to speak in full sentences, ambulatory"]
["72.   C/o ear pain & deafness"]
["73.   Covered in soot, agitated, ambulatory"]
["74.   Coughing"]
["75.   Chest wound, no respiratory distress, no active bleeding, ambulatory"]
["76.   Femur deformity, in severe pain, strong radial pulse"]
["77.   Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]
["78.   Complaining of deafness"]
["79.   C/o thumb deformity"]
["80.   Multiple contusions and abrasions, ambulatory"]
["81.   First-degree facial burns, emotional distress"]
["82.   Eye pain, tearing"]
["83.   Superficial chest wound, no respiratory distress, ambulatory"]
["84.   Arm wound, no other injuries"]
["85.   Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]

{"sheet":"Arrival list T=60","index":5,"n_rows":91,"n_cols":2,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Arrival List T=60","Red/yellow/green"]
["1.   Respiratory rate 50, trachea deviated to left"]
["2.   Found apneic, now breathing after repositioning of airway, unconscious"]
["3.   Pointing to ears, walking"]
["4.   Eye pain, tearing, debris in eyes"]
["5.   Severe burns over >50% of body, lethargic, moaning"]
["6.   Mangled foot, severe pain, bleeding controlled"]
["7.   Head contusion, focal seizures"]
["8.   Hip pain, ambulatory"]
["9.   Scalp laceration with pressure dressing, GCS 15"]
["10.   C/o crushing chest pain, hx previous MI"]
["11.   Open abdominal wound with active bleeding, cap refill > 2 seconds"]
["12.   Sobbing, walking around"]
["13.   Second- and third-degree burns, >75% of body, severe pain"]
["14.   Sucking chest wound, dyspneic-appearing"]
["15.   C/o groin pain, can’t bear weight "]
["16.   Hip deformity, BP 146/77, HR 102"]
["17.   Short of breath, coughing, respiratory rate 28, O2 sat 98%"]
["18.   Scalp laceration with pressure dressing, GCS 15"]
["19.   Severe burns over >50% of body, lethargic, moaning"]
["20.   Covered in soot, ambulatory"]
["21.   C/o head injury, calm, GCS 15"]
["22.   Walking around, c/o facial lacerations, no active bleeding"]
["23.   C/o second-degree forearm burn"]
["24.   Impaled through abdomen, hypotensive"]
["25.   Second degree facial burns, no respiratory distress"]
["26.   C/o thumb deformity"]
["27.   C/o head injury, no headache, ambulatory, GCS 15"]
["28.   Debris in eyes"]
["29.   Arm laceration, no active bleeding"]
["30.   Severe hip pain, can't walk, obvious leg deformity"]
["31.   Covered in soot, agitated, ambulatory"]
["32.   Crush injury to both legs"]
["33.   Femur deformity, in severe pain, vitals stable"]
["34.   Debris in eyes"]
["35.   Appears to be deaf"]
["36.   Diaphoretic, pale, multiple open fractures"]
["37.   Chest wound, walking around, no respiratory distress"]
["38.   C/o ear pain & deafness"]
["39.   Scalp laceration with pressure dressing, GCS 15"]
["40.   C/o thumb deformity"]
["41.   Superficial chest wound, no respiratory distress, ambulatory"]
["42.   C/o scalp pain, neck pain, immobilized, GCS 15"]
["43.   Abdominal pain, LUQ bruise, hypotension"]
["44.   Crush injury to left foot, severe pain"]
["45.   Arm laceration, no active bleeding"]
["46.   Lethargic, moaning"]
["47.   Arm wound, no active bleeding"]
["48.   Scalp laceration with pressure dressing, GCS 15"]
["49.   Crush injury to leg"]
["50.   Bilateral ankle fractures, no other apparent injuries"]
["51.   Crush injury to left foot, severe pain"]
["52.   Wrist deformity, neurovascularly intact"]
["53.   Open leg fracture, bleeding controlled"]
["54.   Short of breath, coughing, respiratory rate 28, O2 sat 98%"]
["55.   Back pain, unable to move legs, vitals stable"]
["56.   Walking around, appears stunned"]
["57.   Chest pain, shortness of breath, hypotension"]
["58.   Sprained ankle, walking with severe limp"]
["59.   Covered in soot, ambulatory"]
["60.   Multiple abrasions, ambulatory"]
["61.   Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]
["62.   Scattered second-degree burns, <15% body surface"]
["63.   Walking around, appears stunned"]
["64.   C/o second-degree forearm burn"]
["65.   Walking around, appears stunned"]
["66.   Head contusion, focal seizures"]
["67.   Arm wound, no other injuries"]
["68.   Proximal arm amputation, BP 74/p"]
["69.   C/o head injury, calm, GCS 15"]
["70.   Dazed, can't walk due to groin pain, radial pulses intact"]
["71.   Femur deformity, in severe pain"]
["72.   Abdominal pain, BP 148/110, HR 100"]
["73.   Walking, c/o facial lacerations, no active bleeding"]
["74.   Second degree facial burns, no respiratory distress"]
["75.   Lethargic, not following commands"]
["76.   Posterior neck pain, immobilized, neurologically intact"]
["77.   Scalp laceration, EBL 500cc, dazed, various superficial shrapnel wounds"]
["78.   Sobbing, walking around"]
["79.   Chest pain, shortness of breath, hypotension"]
["80.   Debris in eyes"]
["81.   Diaphoretic, BP 70/p"]
["82.   Leg laceration, no active bleeding, ambulatory"]
["83.   Left lower extremity injury, foot cool but pulse is palpable, BP 120/70"]
["84.   C/o second-degree forearm burn"]
["85.   74-year-old, shortness of breath, chest pain, O2 sat 99%, RR 12, BP 124/83, HR 105"]
["86.   64-year-old man, crushing chest pain, ashen-appearing"]
["87.   Scalp laceration with pressure dressing, GCS 15"]
["88.   Coughing, able to speak in full sentences"]
["89.   Lethargic, not following commands"]
["90.   Second-degree burns covering ~25% of body"]

{"sheet":"Arrival list T=75","index":6,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Arrival List T=75"]
["1) ","Multiple brusises; ambulatory"]
["2) ","Covered in soot, agitated, ambulatory"]
["3) ","Lethargic, obvious head trauma; follows commands"]
["4) ","Facial burns; emotional distress"]
["5) ","Multiple contusions and abrasions; ambulatory"]
["6) ","Agonal respirations"]
["7) ","Lethargic, obvious head trauma; follows commands"]
["8) ","Moaning incoherently; amputation of LLE"]
["9) ","Multiple contusions and abrasions; ambulatory"]
["10) ","Covered in soot, agitated, ambulatory"]
["11) ","Incoherent, obvious head trauma"]
["12) ","Covered in soot, agitated, ambulatory"]
["13) ","C/o ear pain & deafness"]
["14) ","Mangled foot; severe pain"]
["15) ","Crush injury; BP 84/60; HR 128"]
["16) ","Sobbing, walking around"]
["17) ","Scattered 2nd degree burns, <15% body surface"]
["18) ","Multiple brusises; ambulatory"]
["19) ","Coughing, gagging; ambulatory"]
["20) ","C/o debris in eyes.  PERRL.  Vision grossly intact"]
["21) ","Sprained ankle"]
["22) ","C/o ear pain & deafness"]
["23) ","Debris in eyes"]
["24) ","Multiple extremity fractures"]
["25) ","Walking around, appears stunned"]
["26) ","Covered in soot, agitated, ambulatory"]
["27) ","C/o 2nd degree forearm burn"]
["28) ","C/o debris in eyes.  PERRL.  Vision grossly intact"]
["29) ","70 year old woman with chest pain, now resolved"]
["30) ","Elderly man with cough, fever, SOB; BP 110/70; HR 80; RR 18; O2 sat 92%"]
["31) ","Lethargic; not following commands"]
["32) ","Upset"]
["33) ","Nasal deformity, arm laceration"]
["34) ","Proximal arm amputation; BP 74/p"]
["35) ","Blood in ears, dazed; GCS 14; strong radial pulse"]
["36) ","Diaphoretic, lethargic, subcutaneous crepitus in chest"]
["37) ","Femur deformity, in severe pain"]
["38) ","On backboard; scalp laceration; c/o neck pain"]
["39) ","Mangled foot; severe pain"]
["40) ","Neck injury; immobilized; neurologically intact"]
["41) ","Femur deformity, in severe pain"]
["42) ","Open femur fracture"]
["43) ","Debris in eyes"]
["44) ","Arm laceration"]
["45) ","Walking aroud, c/o facial lacerations, RR 20, BP 148/80, HR 110"]
["46) ","Arm wound, no other injuries"]
["47) ","Burn on right forearm and dorsum of left wrist"]
["48) ","Left lower extremity injury; foot cool and pale; BP 120/70"]
["49) ","Leg deformity; bleeding controlled with pressure dressing"]
["50) ","Chest pain, shortnesss of breath, hypotension"]
["51) ","Burn on right forearm and dorsum of left wrist"]
["52) ","Severe burns over >50% of body; lethargic, moaning"]
["53) ","Open leg fracture"]
["54) ","Neck injury; immobilized; neurologically intact"]
["55) ","Multiple extremity fractures"]
["56) ","Left lower extremity injury; foot cool and pale; BP 120/70"]
["57) ","Hip pain; ambulatory"]
["58) ","Burn on right forearm and dorsum of left wrist"]
["59) ","2nd and 3rd degree burns, >80% of body; alert"]
["60) ","Coughing, gagging; ambulatory"]

{"sheet":"Advanced","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[[4,0,4,4],[2,0,2,6]]}
["Advanced customization"]
[]
["INSTRUCTIONS:\nThe purple, red, and yellow proportions in columns B-D can be changed. \n\nChange the purple numbers in column B to modify the proportion of all patients who arrive during each interval.  Change the red and yellow numbers in columns C and D to  change the proportion of arriving patients at each interval that are red or yellow.  Note that the proportion of green patients at each interval is figured automatically so that the totals add up to 100%.  The green numbers should not be changed manually."]
[]
["Patient Arrival Percentages"]
["Arrival Time"," % Total Arrivals","Red Patients","Yellow Patients","Green Patients"]
[15,0.08,0,0.1,{"$f":"1-(C7+D7)","v":0.9}]
[30,0.22,0.09,0.19,{"$f":"1-(C8+D8)","v":0.72}]
[45,0.34,0.11,0.12,{"$f":"1-(C9+D9)","v":0.77}]
[60,0.36,0.23,0.25,{"$f":"1-(C10+D10)","v":0.52}]
["Total",{"$f":"SUM(B7:B10)","v":1},{"$f":"SUMPRODUCT($B$7:$B$10,C7:C10)","v":0.14000000000000001},{"$f":"SUMPRODUCT($B$7:$B$10,D7:D10)","v":0.18060000000000001},{"$f":"SUMPRODUCT($B$7:$B$10,E7:E10)","v":0.6794}]

{"sheet":"Red","index":8,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["Found apneic, now breathing after repositioning of airway, unconscious"]
["Gasping respirations, radial pulse not palpable"]
["Incoherent, obvious head trauma"]
["C/o severe ongoing chest pain, pale, diaphoretic"]
["C/o abdominal pain, BP 70/p, HR 124"]
["Head contusion, obtunded"]
["C/o crushing chest pain, hx previous MI, diaphoretic"]
["Head injury, depressed skull fracture"]
["Moaning, not responding to questions, head trauma"]
["Diaphoretic, respiratory rate 6"]
["Respiratory rate 50, trachea deviated to left"]
["Respiratory rate 50, trachea deviated to right"]
["Respiratory rate 50, sucking chest wound"]
["Respiratory rate 50, obvious chest wall deformity"]
["Respiratory rate 50, complaining of chest pain"]
["Obtunded, respiratory rate 6"]
["Respiratory rate 6, GCS 10, faint carotid pulse"]
["Diaphoretic, BP 70/p"]
["Lethargic, not following commands"]
["Diaphoretic, proximal arm amputation, BP 60/p"]
["Severe respiratory distress, chest wall deformity"]
["Diaphoretic, pale, multiple open fractures"]
["Lethargic, complaining of abdominal pain"]
["64-year-old man, crushing chest pain, ashen-appearing"]
["Proximal thigh amputation, massive blood loss, BP 70/p"]
["Proximal arm amputation, BP 74/p"]
["Severe burns over >50% of body, lethargic, moaning"]
["Abdominal pain, LUQ bruise, hypotension"]
["Chest pain, shortness of breath, hypotension"]
["Moaning incoherently, GCS 13"]
["Second- and third-degree burns, >80% of body, alert"]
["Found apneic, now breathing after repositioning of airway, unconscious"]
["Gasping respirations, radial pulse not palpable"]
["Incoherent, clammy"]
["C/o severe ongoing chest pain, pale, diaphoretic"]
["C/o abdominal pain, BP 70/p, HR 124"]
["Head contusion, focal seizures"]
["Head injury, seizing"]
["C/o crushing chest pain, hx previous MI"]
["Head injury, depressed skull fracture"]
["Lethargic, moaning"]
["Diaphoretic, respiratory rate 6"]
["Respiratory distress, trachea deviated to left"]
["Extensive lower extremity deformities, moaning"]
["Sucking chest wound, dyspneic-appearing"]
["Obvious chest wall deformity, respiratory rate 58"]
["Complaining of chest pain, dyspneic, O2 sat in 80s"]
["Obtunded, respiratory rate 5"]
["Lethargic, agonal respirations, faint carotid pulse"]
["Diaphoretic, BP 70/p"]
["Lethargic, not following commands"]
["Diaphoretic, proximal arm amputation, BP 60/p"]
["Lethargic, chest wall deformity"]
["Diaphoretic, pale, multiple open fractures"]
["Lethargic, complaining of abdominal pain"]
["64-year-old man, crushing chest pain, ashen-appearing"]
["Proximal thigh amputation, BP 70/p"]
["Proximal arm amputation, BP 74/p"]
["Severe burns over >50% of body, lethargic, moaning"]
["Abdominal pain, LUQ bruise, hypotension"]
["Chest pain, shortness of breath, hypotension"]
["Moaning incoherently, GCS 12"]
["Second- and third- degree burns, >80% of body, alert"]
["Impaled through abdomen, hypotensive"]
["Impaled through chest, visibly dyspneic"]
["Neck injury, gurgling"]
["Intubated in field"]
["Intubated by EMS for respiratory distress"]
["Penetrating injury to chest"]
["Penetrating injury to abdomen"]
["Diaphoretic, lethargic, subcutaneous crepitus in chest"]
["Alcohol on breath, uncooperative, head injury"]
["Alcohol on breath, incoherent, BP 230/110"]
["Crushing chest pain, ST elevations in II, III"]
["Crushing chest pain, ST elevations in anterior precordial leads"]
["Chest pain, hypotensive, vomited blood"]
["Open abdominal wound with active bleeding, cap refill > 2 seconds"]
["Impaled in chest, obvious respiratory distress"]
["Crush injury to pelvis, hypotensive"]
["Crush injury, BP 84/60, HR 128"]
["38 weeks pregnant, severe vaginal bleeding, cap refill > 2 seconds"]
["Crush injury to pelvis, hypotensive"]
["64-year-old man, crushing chest pain, ashen-appearing"]
["Proximal thigh amputation, BP 70/p"]
["Proximal arm amputation, BP 74/p"]
["Severe burns over >50% of body, lethargic, moaning"]
["Abdominal pain, LUQ bruise, hypotension"]
["Chest pain, shortness of breath, hypotension"]
["Moaning incoherently, amputation of LLE"]
["Second- and third-degree burns, >75% of body, severe pain"]
["Found apneic, now breathing after repositioning of airway, unconscious"]
["Gasping respirations, clammy, BP 90/p"]
["Incoherent, diaphoretic"]
["C/o severe ongoing chest pain, pale, diaphoretic"]
["C/o abdominal pain, BP 70/p, HR 124"]
["Head contusion, severe headache, GCS 13"]
["Head injury, brain matter visible, but moaning"]
["C/o crushing chest pain, hx CABG"]
["Head injury, incoherent"]
["Head injury, left pupil fixed, dilated, GCS 8"]

{"sheet":"Yellow","index":9,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["C/o groin pain, can’t bear weight "]
["Second-degree burns covering ~25% of body"]
["Scalp hematoma, leg deformity, GCS 15"]
["Femur deformity, in severe pain, strong radial pulse"]
["74-year-old, shortness of breath, O2 sat 99%, RR 12, BP 124/83, HR 105"]
["Open leg fracture, bleeding controlled, BP 130/77"]
["Severe hip pain, can't walk, obvious leg deformity, cap refill <1 sec"]
["Bilateral ankle fractures, no other apparent injuries"]
["Open femur fracture, bleeding controlled, stable vitals"]
["Crushed ankle, severe pain"]
["Crush injury to leg"]
["Hip deformity, normal distal perfusion"]
["Extensive second degree burns, severe pain"]
["55-year-old man, coughing, wheezing,  O2 sat 98%, RR 24"]
["Mangled foot, bleeding controlled"]
["Leg deformity, bleeding controlled with pressure dressing"]
["Coughing, severe wheezing, O2 sat 98%, RR 30"]
["Abdominal pain, BP 148/110, HR 100"]
["Elderly man with cough, fever, SOB, BP 110/70, HR 80, RR 18, O2 sat 92%"]
["Left lower extremity injury, foot cool but pulse faintly palpable, BP 120/70"]
["Obvious head trauma, GCS 15, c/o posterior neck pain"]
["Second-degree burn on back and left arm, severe pain"]
["Short of breath, respiratory rate 28, O2 sat 98%"]
["Knee dislocation, distal perfusion intact"]
["Multiple extremity fractures, can't walk"]
["Crush injury to left foot, severe pain"]
["Open fracture of upper extremity, strong radial pulse"]
["Back pain, unable to move legs, vitals stable"]
["Scalp laceration, EBL 500cc, dazed, neck immobilized, GCS 15"]
["Scalp contusion, c/o neck pain, on backboard"]
["Second-degree burns covering ~25% of body"]
["Open fracture left knee"]
["Femur deformity, in severe pain"]
["74-year-old, shortness of breath, chest pain, O2 sat 99%, RR 12, BP 124/83, HR 105"]
["Open leg fracture, bleeding controlled"]
["Severe hip pain, can't walk, obvious leg deformity"]
["Groin pain on weight bearing, burns on both arms, can’t walk  "]
["Open femur fracture, bleeding controlled, normal distal perfusion"]
["Crushed ankle, severe pain"]
["Crush injury to leg"]
["Hip deformity, BP 146/77, HR 102"]
["Extensive second-degree burns, severe pain"]
["70-year-old woman with chest pain, now resolved"]
["Mangled foot, severe pain, bleeding controlled"]
["Leg deformity, bleeding controlled with pressure dressing"]
["Coughing, severe wheezing, O2 sat 98%, RR 30"]
["Bilateral lower extremity deformities"]
["Left lower extremity injury, foot cool and pale, BP 120/70"]
["Lethargic, obvious head trauma, follows commands"]
["Neck injury, immobilized, neurologically intact"]
["Short of breath, respiratory rate 28, O2 sat 98%"]
["Dazed, can't walk due to groin pain, radial pulses intact"]
["Multiple extremity fractures, can't walk"]
["Blood in ears, dazed, GCS 14, strong radial pulse"]
["Open fracture of upper extremity, BP 146/82 HR 102"]
["Back pain, unable to move legs, vitals stable"]
["On backboard, scalp laceration, c/o neck pain"]
["Neck pain, posterior neck tenderness "]
["19 weeks pregnant, vaginal bleeding, vitals stable"]
["Femur deformity, immobilized, extremities well-perfused"]
["Extricated from the scene, can't move legs, BP 165/103 HR 85"]
["Dialysis patient, SOB, BP 180/100, RR 16, O2 sat 98%"]
["Crushed leg, open wound, bleeding controlled"]
["Crush injury to leg, extreme pain"]
["Hip deformity, distal perfusion normal"]
["15-foot fall, can’t stand due to knee pain, no other complaints"]
["Mangled foot, bleeding controlled, severe pain"]
["Leg deformity, open wound, bleeding controlled with pressure dressing"]
["Coughing, severe wheezing, O2 sat 98%, RR 30"]
["Crush injury to both legs"]
["Left lower extremity injury, foot cool but pulse is palpable, BP 120/70"]
["Open tibia fracture"]
["Neck injury, immobilized, neurologically intact"]
["Short of breath, coughing, respiratory rate 28, O2 sat 98%"]
["Appears intoxicated, head contusion, GCS 15"]
["Ankle deformity, severe pain"]
["Blood in ears, dazed, GCS 14, no headache, strong radial pulse"]
["Open fracture of upper extremity, strong radial pulse"]
["Back pain, unable to move legs, vitals stable"]
["Scalp laceration, EBL 500cc, dazed, various superficial shrapnel wounds"]
["C/o scalp pain, neck pain, immobilized, GCS 15"]
["Second-degree burns covering ~20% of body"]
["Confused, with repetitive questioning, but follows commands"]
["Femur deformity, in severe pain, vitals stable"]
["74-year-old, shortness of breath, O2 sat 99%, RR 12, BP 124/83, HR 105, EKG normal"]
["Open leg fracture, bleeding controlled"]
["Severe hip pain, can't walk, obvious leg deformity"]
["32 weeks pregnant, open ankle fracture"]
["Leg deformity, bleeding controlled with pressure dressing"]
["Coughing, severe wheezing, O2 sat 98%, RR 30"]
["Left lower extremity injury, foot cool, faint dorsalis pedis pulse"]
["Lethargic, obvious head trauma, follows commands"]
["Posterior neck pain, immobilized, neurologically intact"]
["Short of breath, respiratory rate 28, O2 sat 98%"]
["Can't walk due to groin pain, radial pulses intact"]
["Multiple extremity fractures"]
["Open fracture of upper extremity, BP 146/82 HR 102"]
["24 weeks pregnant, abdominal cramping, currently pain-free"]
["Crush injury to both legs, stable vitals"]
["Multiple extremity fractures, can't walk"]

{"sheet":"Green","index":10,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["Coughing, complaining of burning eyes"]
["Complaining of deafness"]
["C/o debris in eyes, PERRL, vision grossly intact"]
["Arm laceration, no active bleeding"]
["4cm leg laceration, no active bleeding"]
["Scalp laceration, no active bleeding"]
["Wrist deformity, neurovascularly intact"]
["Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]
["Leg laceration, ambulatory, no active bleeding"]
["C/o head injury, calm, GCS 15"]
["C/o second-degree forearm burn"]
["Coughing, able to speak in full sentences, ambulatory"]
["C/o ear pain & deafness"]
["Second-degree burn on right forearm and dorsum of left wrist"]
["C/o thumb deformity"]
["Scattered second-degree burns, <15% body surface"]
["Hip pain, ambulatory"]
["Arm wound, no active bleeding"]
["Chest wound, no respiratory distress, no active bleeding, ambulatory"]
["Walking around, c/o facial lacerations, no active bleeding"]
["Walking around, appears stunned"]
["Multiple contusions and abrasions, ambulatory"]
["Scalp laceration with pressure dressing, GCS 15"]
["Covered in soot, ambulatory"]
["Second degree facial burns, no respiratory distress"]
["Multiple abrasions, ambulatory"]
["Sobbing, walking around"]
["Sprained ankle"]
["Coughing and gagging"]
["Coughing, deaf"]
["Covered in soot, ambulatory"]
["Eye pain, tearing"]
["Debris in eyes"]
["Multiple bruises, ambulatory"]
["Multiple small lacerations"]
["Coughing"]
["Burning eyes"]
["Debris in eyes"]
["Can't see due to debris in eyes"]
["Appears to be deaf"]
["Pointing to ears, walking"]
["Complaining of deafness"]
["C/o debris in eyes, PERRL, vision grossly intact"]
["Arm laceration, no active bleeding"]
["Thigh laceration, no hematoma, no active bleeding"]
["Scalp laceration, no active bleeding"]
["Wrist deformity, neurovascularly intact"]
["Nasal deformity, arm laceration, no respiratory distress, no active bleeding"]
["Leg laceration, no active bleeding, ambulatory"]
["C/o head injury, calm, GCS 15"]
["C/o second-degree forearm burn"]
["Coughing, able to speak in full sentences, ambulatory"]
["C/o ear pain & deafness"]
["Burn on right forearm and dorsum of left wrist"]
["C/o thumb deformity"]
["Scattered second-degree burns, <15% body surface"]
["Hip pain, ambulatory"]
["Superficial chest wound, no respiratory distress, ambulatory"]
["Walking, c/o facial lacerations, no active bleeding"]
["Walking around, appears stunned"]
["Multiple contusions and abrasions, ambulatory"]
["Scalp laceration with pressure dressing, GCS 15"]
["Covered in soot, agitated, ambulatory"]
["Facial burns, no respiratory distress, emotional distress"]
["Multiple abrasions, ambulatory"]
["Sobbing, walking around"]
["Sprained ankle"]
["Coughing, deaf"]
["Covered in soot, ambulatory"]
["Eye pain, tearing"]
["Multiple bruises, ambulatory"]
["Multiple superficial lacerations, ambulatory, calm"]
["Hand, wrist injury"]
["Nasal deformity, no respiratory distress, arm laceration, no active bleeding"]
["Leg laceration, no active bleeding, ambulatory"]
["C/o head injury, no headache, ambulatory, GCS 15"]
["C/o second-degree forearm burn"]
["Coughing, able to speak in full sentences, ambulatory"]
["C/o ear pain & deafness"]
["Burn on right forearm and dorsum of left wrist"]
["C/o thumb deformity"]
["Upset"]
["Scattered second-degree burns, <15% body surface"]
["Hip pain, ambulatory"]
["Arm wound, no other injuries"]
["Chest wound, walking around, no respiratory distress"]
["Walking around, c/o facial lacerations"]
["Walking around, appears stunned"]
["Multiple contusions and abrasions, ambulatory"]
["Scalp laceration with pressure dressing, GCS 15"]
["Covered in soot, agitated, ambulatory"]
["First-degree facial burns, emotional distress"]
["Multiple abrasions, appears upset, ambulatory"]
["Sobbing, walking around"]
["Sprained ankle, walking with severe limp"]
["Coughing, able to speak in full sentences"]
["Covered in soot, ambulatory"]
["Eye pain, tearing, debris in eyes"]
["Multiple bruises, ambulatory"]
["Multiple lacerations, ambulatory, calm"]

{"sheet":"tempspace","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}