{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","T=0 to T=15","T=15 to T=30","T=30 to T=45","T=45 to T=60","T=60 to T=75","Hotwash"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":59,"comments":5,"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":"Start","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,15],[0,0,0,16],[5,1,5,15],[6,1,6,15],[7,1,7,15],[2,1,2,15],[3,1,3,15],[1,6,1,9]]}
["EMERGENCY DEPARTMENT: EXERCISE CONTROLLER EVALUATION"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2014-12-05"}]
[null,"You are the leader of the four-person exercise team.  Your specific responsibilities include (1) assembling the team before the start of the exercise and making sure that everybody understands their roles, (2) starting the exercise clock and keeping time, (3) providing the ED with scenario updates and a list of patient arrivals at 15-minute intervals, (4) tracking the flow of patients and beds, and (5) directing the “hotwash” debriefing immediately after the exercise."]
[null,"A note regarding patient and bed tracking: You will be asked to record inpatient beds as they are identified (to admit ED patients).   Usually these beds will be assigned by the command center.   These might be beds that were already empty or beds that are “created” by staffing closed beds or using overflow space.  ED staff must communicate with the command center to let them know how many beds they need based on new arrivals at each time interval (plus existing patients at the start of the exercise).  Keep in mind that all red patients need ICU beds and all yellow patients need “floor beds.”   Beds should be recorded at a level of detail such that a transporter would know where to take the patient."]
[]
[null,"1.  The four members of the evaluation team should meet 30 minutes prior to the exercise start .\n2.  Check that the four laptops are functioning and that the Excel tools are running.\n3.  If a yellow ribbon that says \"Security Warning  Macros have been disabled\" appears at the top of the screen, click \"Enable Content.\""]
[null,"4.  Ensure that you have four \"patient arrivals\" sheets (one for each 15-minute interval) ready.\n          - These should have been printed from the Arrival List Generator Tool prior to the exercise.\n5.  The command center evaluators (2) should be escorted to position in or near the command center.\n6.  The two ED evaluators should approach the ED and ask to speak to the RN or MD in charge."]
[null,"7.  Inform the RN or MD in charge:\n         - That the drill will be taking place.\n         - That at least two ED clinical personnel (MD/RN) will need to participate for 75 minutes.\n         - That participants will need to be free of clinical responsibilities.\n         - Ask if he/she would like to check in with hospital leadership before proceeding."]
[null,"8.  Wait for the participants to assemble, confirm that the ED is ready, and press the start button."]

{"sheet":"T=0 to T=15","index":1,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[41,1,41,8],[3,1,3,8],[2,1,2,8],[47,1,47,3],[47,5,47,7],[37,1,37,8],[24,1,24,3],[23,1,23,3],[33,4,33,8],[32,1,32,8],[30,1,30,3],[29,1,29,3],[28,1,28,3],[35,1,35,8],[8,1,8,8],[39,1,39,8],[10,1,10,8],[19,1,19,8],[22,1,22,3],[21,1,21,3],[33,1,33,3],[26,1,26,8],[0,0,0,9],[38,1,38,8],[16,1,16,3],[15,1,15,3],[14,1,14,3],[12,1,12,8],[27,1,27,8],[36,1,36,8],[13,1,13,8],[20,1,20,8],[17,1,17,8],[18,1,18,8],[9,1,9,8],[7,1,7,8],[5,1,5,8],[4,1,4,8]]}
["T=0 to T=15 Time Interval"]
[null,"07:18:40",null,null,"00:06:14",null,"08:33:40"]
[null,"For the next 75 minutes, we will be running a mass casualty exercise.    We will need at least two ED staff to participate.  Since the drill must not interfere with patient care, participants must be relieved of all clinical duties."]
[null,"There will be no \"mock patients\" and no physical movement of any patients.  At regular intervals we will provide scenario updates and lists of arriving patients.  We will ask you questions, but as much as possible you should respond as you would to an actual incident.  "]
[null,"We will read a brief description of the scenario, and you should activate the hospital’s mass casualty protocol as you would in a real situation.  But be sure to always indicate to others that this is a drill.   The exercise will proceed in \"real time.\"    For the purposes of this drill, you should assume that other hospitals in your area are overwhelmed and that no outside assistance is available."]
[null,"An important part of this exercise is to test your ED’s ability to handle a large influx of patients and to coordinate their admission to inpatient units.  You will therefore need to tell the hospital command center when you need beds, and they should tell you where you can send your patients.  Use whatever communication system you would normally use (e.g., telephone, online tracking system) in a real mass casualty event.\n\nAre there any questions?"]
[]
[null,"You have received the following notification from EMS:"]
[null,"[Customize as appropriate]  A bombing has occurred at a nearby building.  Preliminary reports indicate two or three explosions.  Many casualties are expected.  \n"]
[null,"You should now work in real time to implement your hospital's mass casualty plan.    \n\nWhen you are ready, I need to collect some information about the ED, but that should not interfere with your activities. \nLet me know when you are ready for questions. "]
[null,"[Wait for the hospital staff to be ready]"]
[]
[null,"To start, I will ask about the number of beds.\nWe are not talking about patients yet, just places to treat them."]
[]
[null,"How many regular treatment beds are there in the main part of the ED? "]
[null,"How many overflow beds (ex. stretchers in hallways) are currently set up? "]
[null,"How many dedicated low-acuity beds does the ED have?"]
[]
[null,"Now I will ask you about patients.   We are counting the number of actual registered patients.  This includes patients whether they are in the waiting room or in beds.  Please categorize them as \"red,\" \"yellow,\" or \"green.\"   \n          - Red corresponds to ESI triage level 1 or 2 or \"emergent.\""]
[null,"          - Yellow corresponds to ESI level 3.\n          - Green corresponds to ESI level 4 or 5 or \"non-urgent.\"\nIf you don't use the ESI triage system, just categorize them as best you can."]
[]
[null,"How many red patients are registered? "]
[null,"How many yellow patients are registered?  ",null,null,null,{"$f":"E23+E25","v":0}]
[null,"How many green patients are registered?  "]
[null,"How many patients are not yet triaged?"]
[]
[null,"Now I will ask you about the staff in the ED."]
[]
[null,"How many nurses are currently working in the ED?"]
[null,"How many physician assistants and nurse practitioners are working?"]
[null,"How many physicians are working?"]
[]
[null,"You will receive a large number of \"walking wounded,\" patients with minor injuries."]
[null,"What is the department's plan for caring for patients with minor injuries?"]
[]
[null,"For the purposes of the exercise, we will now make several simplifying assumptions:\n\n          - Green patients will go to auxiliary sites; they will not occupy beds in the department.\n          - Red patients require inpatient ICU beds.\n          - Yellow patients require floor beds.\n          - Red and yellow patients leave the department as soon as you identify free inpatient beds.  You do not need to say which patients are going to which beds, but the inpatient destination should be specific enough to serve as instructions to patient transporters."]
[]
[null,"Your ED's \"immediate bed availability\" (IBA) is the difference between the number of beds in your department and the number of patients remaining."]
[null,{"$f":"\"Based upon the given information, the ED's immediate bed availability is \"&T0IBA&\" beds.\"","v":"Based upon the given information, the ED's immediate bed availability is 0 beds."}]
[null,"Your IBA will decrease as new patients arrive.  It will increase when you find inpatient beds or when you create new ED beds."]
[]
[null,"As the ED finds inpatient beds, input the information in the tables below.  ED patients will \"automatically go to those beds.\" \nThe time stamp will fill automatically every 10 seconds. "]
[]
[]
[]
[]
[]
[null,"ICU Beds Available for ED Admissions",null,null,null,"Floor Beds Available for ED Admissions"]
[null,"ICU Destination","Number of Patients","Time Stamp",null,"Floor Destination","Number of Patients","Time Stamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C50:C63)","v":0},null,null,"Total",{"$f":"SUM(G50:G63)","v":0}]

{"sheet":"T=15 to T=30","index":2,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,1,8,8],[0,0,0,9],[2,1,2,8],[3,1,3,8],[5,1,5,8],[7,1,7,8],[24,1,24,3],[24,5,24,7],[12,1,12,3],[18,1,18,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[14,1,14,4],[14,5,14,8],[15,1,15,8],[17,1,17,8]]}
["T=15 to T=30 Time Interval"]
[]
[null,{"$f":"\"At the start of the interval, the ED has \"&T14Red&\" red patients, \"&T14Yellow&\" yellow patients, and the immediate bed availability is \"&T14IBA&\".\"","v":"At the start of the interval, the ED has 0 red patients, 0 yellow patients, and the immediate bed availability is 0."}]
[null,"[Customize as appropriate]  EMS reports that first responders have arrived on the scene.  Many are dead, many have severe injuries.  Many of the walking wounded appear to be deaf.  Victims are heading to your hospital on foot and by private vehicles.   Based on the size and number of explosions, a terrorist attack is suspected."]
[]
[null,"Give the ED a list of patient arrivals for this time interval."]
[]
[null,"You have been given a list of patients who will arrive during this time interval.  Please count the number that you would consider \"red,\" \"yellow,\" and \"green,\""]
[]
[null,"How many are red? "]
[null,"How many are yellow? "]
[null,"How many are green?  "]
[null,"Have any new treatment spaces been added to the ED? How many?"]
[]
[null,{"$f":"\"So far a total of \"&(T0green+T15green)&\" green patients have been identified.  \nWhere would these patients go? Does the original plan need to be modified?\"","v":"So far a total of 0 green patients have been identified.  \nWhere would these patients go? Does the original plan need to be modified?"}]
[null,"Consider whether the previous plan for the walking wounded can accommodate the number of patients received so far.  If not, ask for the ED staff for clarification."]
[]
[null,"If at any time during this time interval the command center identifies free inpatient beds, list them below:"]
[]
[]
[]
[]
[]
[]
[null,"ICU Beds Available for ED Admissions",null,null,null,"Floor Beds Available for ED Admissions"]
[null,"ICU Destination","Number of Patients","Time Stamp",null,"Floor Destination","Number of Patients","Time Stamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C27:C40)","v":0},null,null,"Total",{"$f":"SUM(G27:G40)","v":0}]

{"sheet":"T=30 to T=45","index":3,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,1,8,8],[0,0,0,9],[2,1,2,8],[3,1,3,8],[5,1,5,8],[7,1,7,8],[24,5,24,7],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[18,1,18,3],[24,1,24,3],[14,1,14,4],[14,5,14,8],[15,1,15,8],[17,1,17,8]]}
["T=30 to T=45 Time Interval"]
[]
[null,{"$f":"\"At the start of the interval, the ED has \"&T29Red&\" red patients, \"&T29yellow&\" yellow patients, and the immediate bed availability is \"&T29IBA&\".\"","v":"At the start of the interval, the ED has 0 red patients, 0 yellow patients, and the immediate bed availability is 0."}]
[null,"[Customize as appropriate]  HazMat reports initial survey negative for chemical agents or radiation. Further assessment in progress.  "]
[]
[null,"Give the ED a list of patient arrivals for this time interval."]
[]
[null,"You have been given a list of patients who will arrive during this time interval.  Please count the number that you would consider \"red,\" \"yellow,\" and \"green.\""]
[]
[null,"How many are red? "]
[null,"How many are yellow? "]
[null,"How many are green?  "]
[null,"Have any new treatment spaces been added to the ED? How many?"]
[]
[null,{"$f":"\"So far a total of \"&(T0green+T15green+T30green)&\" green patients have been identified.  \nWhere would these patients go?  Does the original plan need to be modified?\"","v":"So far a total of 0 green patients have been identified.  \nWhere would these patients go?  Does the original plan need to be modified?"}]
[null,"Consider whether the previous plan for the walking wounded can accommodate the number of patients received so far.  If not, ask for the ED staff for clarification."]
[]
[null,"If at any time during this time interval the command center identifies free inpatient beds, list them below:"]
[]
[]
[]
[]
[]
[]
[null,"ICU Beds Available for ED Admissions",null,null,null,"Floor Beds Available for ED Admissions"]
[null,"ICU Destination","Number of Patients","Time Stamp",null,"Floor Destination","Number of Patients","Time Stamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C27:C40)","v":0},null,null,"Total",{"$f":"SUM(G27:G40)","v":0}]

{"sheet":"T=45 to T=60","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,1,8,8],[14,1,14,4],[14,5,14,8],[15,1,15,8],[17,1,17,8],[0,0,0,9],[2,1,2,8],[3,1,3,8],[5,1,5,8],[7,1,7,8],[24,5,24,7],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[18,1,18,3],[24,1,24,3]]}
["T=45 to T=60 Time Interval"]
[]
[null,{"$f":"\"At the start of the interval, the ED has \"&T44red&\" red patients, \"&T44yellow&\" yellow patients, and the immediate bed availability is \"&T44IBA&\".\"","v":"At the start of the interval, the ED has 0 red patients, 0 yellow patients, and the immediate bed availability is 0."}]
[null,"[Customize as appropriate]  HazMat assesment is complete.  There is no evidence of radiation or chemical agents."]
[]
[null,"Give the ED a list of patient arrivals for this time interval."]
[]
[null,"You have been given a list of patients who will arrive during this time interval.  Please count the number that you would consider \"red,\" \"yellow,\" and \"green.\""]
[]
[null,"How many are red? "]
[null,"How many are yellow? "]
[null,"How many are green?  "]
[null,"Have any new treatment spaces been added to the ED? How many?"]
[]
[null,{"$f":"\"So far a total of \"&(T0green+T15green+T30green+T45green)&\" green patients have been identified.  \nWhere would these patients go?  Does the original plan need to be modified?\"","v":"So far a total of 0 green patients have been identified.  \nWhere would these patients go?  Does the original plan need to be modified?"}]
[null,"Consider whether the previous plan for the walking wounded can accommodate the number of patients received so far.  If not, ask for the ED staff for clarification."]
[]
[null,"If at any time during this time interval the command center identifies free inpatient beds, list them below:"]
[]
[]
[]
[]
[]
[]
[null,"ICU Beds Available for ED Admissions",null,null,null,"Floor Beds Available for ED Admissions"]
[null,"ICU Destination","Number of Patients","Time Stamp",null,"Floor Destination","Number of Patients","Time Stamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C27:C40)","v":0},null,null,"Total",{"$f":"SUM(G27:G40)","v":0}]

{"sheet":"T=60 to T=75","index":5,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,1,8,8],[14,1,14,4],[14,5,14,8],[15,1,15,8],[17,1,17,8],[0,0,0,9],[2,1,2,8],[3,1,3,8],[5,1,5,8],[7,1,7,8],[24,5,24,7],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[18,1,18,3],[24,1,24,3]]}
["T=60 to T=75 Time Interval"]
[]
[null,{"$f":"\"At the start of the interval, the ED has \"&T59red&\" red patients, \"&T59yellow&\" yellow patients, and the immediate bed availability is \"&T59IBA&\".\"","v":"At the start of the interval, the ED has 0 red patients, 0 yellow patients, and the immediate bed availability is 0."}]
[null,"[Customize as appropriate]  There is no further information from EMS."]
[]
[null,"Give the ED a list of patient arrivals for this time interval."]
[]
[null,"You have been given a list of patients who will arrive during this time interval.   Please count the number that you would consider “red,” “yellow,” and “green.”"]
[]
[null,"How many are red? "]
[null,"How many are yellow? "]
[null,"How many are green?  "]
[null,"Have any new treatment spaces been added to the ED? How many?"]
[]
[null,{"$f":"\"So far a total of \"&(T0green+T15green+T30green+T45green+T60green)&\" green patients have been identified.  \nWhere would these patients go?  Does the original plan need to be modified?\"","v":"So far a total of 0 green patients have been identified.  \nWhere would these patients go?  Does the original plan need to be modified?"}]
[null,"Consider whether the previous plan for the walking wounded can accommodate the number of patients received so far.  If not, ask for the ED staff for clarification."]
[]
[null,"If at any time during this time interval the command center identifies free inpatient beds, list them below:"]
[]
[]
[]
[]
[]
[]
[null,"ICU Beds Available for ED Admissions",null,null,null,"Floor Beds Available for ED Admissions"]
[null,"ICU Destination","Number of Patients","Time Stamp",null,"Floor Destination","Number of Patients","Time Stamp"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C27:C40)","v":0},null,null,"Total",{"$f":"SUM(G27:G40)","v":0}]

{"sheet":"Hotwash","index":6,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":false,"merged":[[79,1,79,13],[83,3,83,4],[82,3,82,4],[57,1,57,13],[58,1,58,13],[32,1,32,13],[33,1,33,13],[54,1,54,13],[55,1,55,13],[77,1,77,13],[0,0,0,14],[5,1,5,13],[7,1,7,13],[8,1,8,13],[30,1,30,13],[29,1,29,13],[2,1,2,13],[3,1,3,13]]}
["EMERGENCY DEPARTMENT HOTWASH"]
[]
[null,"Hotwash Instructions:\n1.  Direct ED players and evaluators to the command center for the hotwash.  \n2.  If possible, offer hospital players a 10-15 minute break and use this time to review the material on this tab and plan the discussion.\n3.  If a projector is available, hook the laptop up to the projector so everyone can see the graphs during the hotwash.  If not, consider printing the graphs.\n"]
[null,"4.  Each member of the evaluation team should debrief their portion of the exercise using the \"Hotwash\" tab on their respective spreadsheets.  \n          a. The suggested order is:  (1) ED Exercise Controller (you), (2) ED Qualitative Evaluator, (3) CC Incident Commander Evaluator, (4) CC Bed Control Evaluator. \n5. Begin the hotwash by discussion the material on this tab."]
[null,"Chart 1: Patient Arrivals vs. Time"]
[null,"The first graph shows the arrival of patients into the ED over time.  These are injects from the scenario, provided by the exercise\ncontroller at the ED, and were sorted into triage category by hospital ED staff. Notice that there are not that many patients (either red or yellow) at first, but that number increases, dramatically so, over time."]
[]
[null,"Discussion Questions:\n1. What actions did the hospital take after being informed of the mass casualty incident, but before the large influx of patients?\n2.  What was the biggest challange accomodating the influx of patients?\n3. “Green” patients, the walking wounded, are also shown in this graph.  The exercise made the simplifying assumption that these patients would be cared for at some alternate location—somewhere other than the ED.  "]
[null,"          a. What was this hospital’s plan for taking care of the green patients?  \n          b. How much space is there?  Who would set up this space?  \n          c. Who staffs this space?  What supplies would be needed?"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Patient Arrivals"]
[null,null,null,null,null,null,null,null,null,null,"Time","Red","Yellow","Green"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,null,null,null,null,null,null,null,null,null,15,{"$f":"T15red","v":0},{"$f":"T15yellow","v":0},{"$f":"T15green","v":0}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"L18+T30red","v":0},{"$f":"M18+T30yellow","v":0},{"$f":"N18+T30green","v":0}]
[null,null,null,null,null,null,null,null,null,null,45,{"$f":"L19+T45red","v":0},{"$f":"M19+T45yellow","v":0},{"$f":"N19+T45green","v":0}]
[null,null,null,null,null,null,null,null,null,null,60,{"$f":"L20+T60red","v":0},{"$f":"M20+T60yellow","v":0},{"$f":"N20+T60green","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Chart 2: Patient Transfers Out of the ED vs. Time"]
[null,"This graph shows the transfer of patients out of the ED.  Yellow patients require inpatient beds, while red patients require ICU beds. \nWere there times when there were no transfers out of the ED?  If so, why was there no movement?"]
[null,"Were there times when the number of transfers increased quickly?  What happened to cause this?\nWas there a leveling off of transfers?  If so, was it because there no more space could be made or found?"]
[]
[null,"Discussion Questions:\n          1. How long did it take before the hospital was able to move patients out of the ED?\n          2. Where did the beds come from?  Were they freed up by discharge or transfer?  Were new beds set up and staffed?\n          3. How long would it really take to get beds ready?  Is there staff and equipment?"]
[null,"          4. Does the have the resources needed to move patients out as quickly as was done in the exercise?  Gurneys?  Which staff would move these patients?\n          5. Did the hospital make as much inpatient space as it possibly could have?"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Patient Transfers"]
[null,null,null,null,null,null,null,null,null,null,"Time","Red","Yellow"]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,15,{"$f":"MIN(T15EDtoICU,T0red)","v":0},{"$f":"MIN(T15EDtoFloor, T0yellow+T0nottriaged)","v":0}]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"MIN(T15EDtoICU+T30EDtoICU,T0red+T15red)","v":0},{"$f":"MIN(T15EDtoFloor+T30EDtoFloor, T0yellow+T0nottriaged+T15yellow)","v":0}]
[null,null,null,null,null,null,null,null,null,null,45,{"$f":"MIN(T15EDtoICU+T30EDtoICU+T45EDtoICU, T0red+T15red+T30red)","v":0},{"$f":"MIN(T15EDtoFloor+T30EDtoFloor+T45EDtoFloor, T0yellow+T0nottriaged+T15yellow+T30yellow)","v":0}]
[null,null,null,null,null,null,null,null,null,null,60,{"$f":"MIN(T15EDtoICU+T30EDtoICU+T45EDtoICU+T60EDtoICU,T0red+T15red+T30red+T45red)","v":0},{"$f":"MIN(T15EDtoFloor+T30EDtoFloor+T45EDtoFloor+T60EDtoFloor, T0yellow+T0nottriaged+T15yellow+T30yellow+T45yellow)","v":0}]
[null,null,null,null,null,null,null,null,null,null,75,{"$f":"MIN(T15EDtoICU+T30EDtoICU+T45EDtoICU+T60EDtoICU+T75EDtoICU, T0red+T15red+T30red+T45red+T60red)","v":0},{"$f":"MIN(T15EDtoFloor+T30EDtoFloor+T45EDtoFloor+T60EDtoFloor+T75EDtoFloor, T0yellow+T0nottriaged+T15yellow+T30yellow+T45yellow+T60yellow)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Chart 3: ED Immediate Bed Availability vs. Time"]
[null,"This chart shows the number of beds available in the ED over the course of the exercise.  At 15-minute intervals, the number of available ED beds goes down, corresponding to patient arrivals provided by the exercise controller.  "]
[null,"The number of ED beds available may increase after that; as inpatient space is found, patients are transferred out of the ED.  Available beds may also increase as a result of additional beds being set up and staffed in the ED.  Does the chart go negative?  Negative numbers would indicate all the ED beds were full."]
[]
[null,"Discussion Questions:\n          1. Was the hospital able to keep the number of available ED beds above zero?\n                    a. What would happen to arriving patients if all ED beds were full?\n          2. Was the ED able to send patients upstairs as quickly as it should have been able to?\n"]
[null,"          4. Did the hospital create additional spaces in the ED?  Where?  \n                    a. How much space is available?\n                    b. What equipment and staffing would be required?  \n                              i. Where would these come from?\n                              ii. Is a shortage of staff or equipment likely to be a problem?\n                              iii. How would the ED handle the arrival of personnel volunteering to help?\n     "]
[null," "]
[]
[null,null,null,null,null,null,null,null,null,null,"Emergency Department Status"]
[null,null,null,null,null,null,null,null,null,null,"Time","Red Patients","Yellow Patients","Beds","IBA"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"T0red","v":0},{"$f":"T0yellow+T0nottriaged","v":0},{"$f":"T0reg_beds+T0overflowbeds","v":0},{"$f":"N64-L64-M64","v":0}]
[null,null,null,null,null,null,null,null,null,null,14,{"$f":"MAX(T0red-T15EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged-T15EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,15,{"$f":"MAX(T0red+T15red-T15EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow-T15EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,29,{"$f":"MAX(T0red+T15red-T15EDtoICU-T30EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow-T15EDtoFloor-T30EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,30,{"$f":"MAX(T0red+T15red+T30red-T15EDtoICU-T30EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow+T30yellow-T15EDtoFloor-T30EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,44,{"$f":"MAX(T0red+T15red+T30red-T15EDtoICU-T30EDtoICU-T45EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow+T30yellow-T15EDtoFloor-T30EDtoFloor-T45EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds+T30newbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,45,{"$f":"MAX(T0red+T15red+T30red+T45red-T15EDtoICU-T30EDtoICU-T45EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow+T30yellow+T45yellow-T15EDtoFloor-T30EDtoFloor-T45EDtoFloor,)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds+T30newbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,59,{"$f":"MAX(T0red+T15red+T30red+T45red-T15EDtoICU-T30EDtoICU-T45EDtoICU-T60EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow+T30yellow+T45yellow-T15EDtoFloor-T30EDtoFloor-T45EDtoFloor-T60EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds+T30newbeds+T45newbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,60,{"$f":"MAX(T0red+T15red+T30red+T45red+T60red-T15EDtoICU-T30EDtoICU-T45EDtoICU-T60EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow+T30yellow+T45yellow+T60yellow-T15EDtoFloor-T30EDtoFloor-T45EDtoFloor-T60EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds+T30newbeds+T45newbeds","v":0},0]
[null,null,null,null,null,null,null,null,null,null,75,{"$f":"MAX(T0red+T15red+T30red+T45red+T60red-T15EDtoICU-T30EDtoICU-T45EDtoICU-T60EDtoICU-T75EDtoICU,0)","v":0},{"$f":"MAX(T0yellow+T0nottriaged+T15yellow+T30yellow+T45yellow+T60yellow-T15EDtoFloor-T30EDtoFloor-T45EDtoFloor-T60EDtoFloor-T75EDtoFloor,0)","v":0},{"$f":"T0reg_beds+T0overflowbeds+T15newbeds+T30newbeds+T45newbeds+T60newbeds","v":0},0]
[]
[]
[]
[null,"Triage Assessment"]
[null,"In this table we compare the number of red, yellow, and green patients given in the scenario injects (top line) against the numbers resulting from ED triage decisions during the exercise (bottom line)."]
[]
[null,"          1.  How different are the results?  What may be the cause?\n          2.  If a mistake in triage is to happen, is it better to over-triage or under-triage?"]
[]
[null,null,null,null,null,"Red","Yellow","Green"]
[null,null,null,"Scenario inject",null,{"$f":"SUM(J87:J90)","v":0},{"$f":"SUM(K87:K90)","v":0},{"$f":"SUM(L87:L90)","v":0}]
[null,null,null,"ED exercise results",null,{"$f":"T15red+T30red+T45red+T60red","v":0},{"$f":"T15yellow+T30yellow+T45yellow+T60yellow","v":0},{"$f":"T15green+T30green+T45green+T60green","v":0}]
[]
[null,null,"Time","Red %","Yellow %","Green %","Total Patients",null,"Time","Red Given","Yellow Given","Green Given"]
[null,null,15,0,0.1,0.9,{"$f":"T15red+T15yellow+T15green","v":0},null,15,{"$f":"ROUND(D87*$G87,0)","v":0},0,0]
[null,null,30,0.09,0.19,0.72,{"$f":"T30red+T30yellow+T30green","v":0},null,30,0,0,0]
[null,null,45,0.11,0.12,0.77,{"$f":"T45red+T45yellow+T45green","v":0},null,45,0,0,0]
[null,null,60,0.23,0.25,0.52,{"$f":"T60red+T60yellow+T60green","v":0},null,60,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G87:G90)","v":0}]