{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","HCC Hospital Collection Form","Optional Coalition-Level Data","HPP Buildup","Data Validation","Resources","Sheet5"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":20,"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":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,0,4,8],[5,1,5,8],[8,0,8,8],[9,1,9,8],[12,1,12,8],[6,1,6,8],[10,1,10,8],[11,1,11,8]]}
[]
[]
[]
["ASPR TRACIE Health Care Coalition Surge Estimator Tool: Hospital Data Collection Form"]
[]
["Introduction","When a mass casualty or hospital evacuation event occurs within a Healthcare Coalition’s (HCC's) jurisdiction, it is helpful for the coalition and its members to understand the HCC’s capacity to accommodate the incident from both the conventional (usual) and contingency or crisis (surge) capacity perspectives. The aggregate of this data can provide critical information about the capacities of the HCC’s acute care hospitals and allow prediction about whether a given incident will overwhelm the local beds available and how much support may be required from outside the HCC. This tool concentrates on key measures that represent conventional and contingency capacity, with the understanding that crisis care may be required when these are insufficient. The information is submitted by each hospital to their coalition for aggregation for use in local, state, and federal planning. Individual hospital data is not submitted to ASPR. Visit https://asprtracie.hhs.gov/hcc-resources for a list of select HCC resources. For a 508 compliant version of this tool, copy and paste this link into your browser: https://files.asprtracie.hhs.gov/documents/aspr-tracie-healthcare-coalition-surge-estimator-tool-hospital-data-collection-form.pdf.\n\nFor additional questions or to discuss this tool or surge capacity further please contact your HPP Field Project Officer (https://www.phe.gov/Preparedness/planning/hpp/Pages/about-hpp.aspx) or email your questions to the Hospital Preparedness Program at HPP@hhs.gov."]
["Instructions","1. Each hospital should collect the following information: average daily occupancy, number of surge discharge patients, and number of floor, ICU, monitored/ stepdown, closed/ inactive floor, pre-induction, post-anesthesia, and procedural beds. \n2.  Enter the bed information in the “HCC Hospital Collection Form” tab. \n3.  Save the HCC Hospital Collection Form with your hospital and coalition name and email the completed file to your HCC readiness and response coordinator who will aggregate the results and provide the data summary."]
[]
["Key Points"]
["Purpose","The Healthcare Coalition (HCC) Surge Estimator Tool is designed to help coalitions plan for potential incidents, understand their thresholds, determine potential resource needs based on initial incident information, anticipate mutual aid requests, and allow rapid prediction about whether a given incident will outstrip the local beds available and how much support may be required from outside the coalition."]
["Interpreting the Results","• \tMedical Surge Events will impact the entire community and involve many diverse medical and public health entities. While many HCCs include non-hospital health care partners who support surge planning (e.g., home care, long term care (LTC), etc.), this tool should only be used to collect data from acute care hospitals to provide an estimate of inpatient surge capacity.  \n•\t The surge capacity outputs from this calculator can help the region determine thresholds at which mass casualty events may be expected to overwhelm their resources. This can also assist emergency management's ability to anticipate events that will overwhelm local resources. Further, they may be used as benchmarks for monitoring increases and decreases in capacity over time."]
["Tips and Notes","•  Operating room (OR)/suite numbers are a key resource but are not part of the surge capacity calculation (though they may contribute in certain situations like mass critical care). This data can be used as an additional planning resource to support HCC surge planning for mass trauma events or as overflow in select cases for ICU care. \n•  The formula used to generate the initial surge capacity estimate from the provided variables can be viewed by a hover feature embedded on line 13 of the hospital data collection form.\n• HCCs will NOT submit individual hospital metrics to ASPR. Information will be aggregated at the HCC level for sharing back to HCC members, with the state, and with ASPR for planning and understanding of regional capacity.\n•  If a member hospital is unable to complete the information or does not submit complete information, the HCC must make every effort to obtain the data prior to submission. Incomplete data will significantly skew your regional results and can lead to faulty planning assumptions. HCCs submitting the aggregate information must note any missing data elements and the reason they were not submitted.\n•  An optional coalition-level bed data form is located in the tab to the right of the hospital data collection form.  Completion of the optional coalition-level bed data form is  voluntary and independent of the Hospital Data Collection form/surge prediction tab. Coalitions may wish to use the information on this optional form to gain a better understanding of bed distribution both for surge and evacuation planning purposes."]
["Caveats","•  Assessing a hospital’s surge capacity requires the integration of space (as noted in bed capacity numbers), staff, supplies, and systems, as each of these variables must be in place to ensure that operational surge can be accomplished. As hospitals and HCCs assess their surge capacity it is important to consider each of these four elements (staff, space, supplies, systems) internally to gain a full understanding of what factors and plans may need addressing.\n•  Important considerations for surge discharge (e.g., transportation, LTC, social services, discharge planning, home health, prescriptions) must always be addressed although those metrics are not captured within this tool.\n•  Crisis care locations/alternate care sites (e.g., cot-based care in conference rooms or tents), outpatient surge capacity and ED surge capacity are not calculated in this tool. Availability of appropriate staff and other factors may influence surge capacity but are not metrics in this tool, as the starting point for patient care is appropriate inpatient space and this is the least flexible/adjustable variable of space, staff, and supplies.\n•  Estimated surge capacity numbers may differ from actual capacity based on a range of variables including how aggressively other spaces are used in the facility and the status of the facility at the time of the incident (e.g., whether the facility is above or below average census at the time of the incident)."]

{"sheet":"HCC Hospital Collection Form","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[13,0,13,2]]}
["HCC Hospital Collection Form"]
[]
["Hospital Name: "]
["Variable","Number","Description"]
["Floor Beds",null,"Total number of inpatient floor and observation beds that are in daily/routine operational use at the hospital. This should include units that are sometimes closed due to low census."]
["Average Daily Occupancy ",null,"This value is the average inpatient census of the hospital and should be entered as a raw number. This may vary significantly in certain regions or during influenza and other high capacity seasons. Submission of accurate data for average census significantly affects the value of the prediction of surge capacity at the coalition level. "]
["ICU Beds",null,"Total number of inpatient critical care (including mechanical ventilation) ICU beds. This should include adult, pediatric, and specialty ICU beds (e.g., burn, neuro) but not neonatal/NICU. \n(Coalitions may wish to independently collect NICU data for evacuation planning but not overall surge capacity assessment)."]
["Monitored / Stepdown Beds",null,"Total number of beds equipped with cardiac and other monitoring necessary for step-down or intermediate level care. These beds do NOT provide usual critical care services such as mechanical ventilation."]
["Closed/Inactive Floor Beds",null,"Total number of beds in units that are operationally closed (units/areas that are considered 'shuttered' and not routinely used for patient care) that could be re-opened or beds that can be added to rooms designed as semi-private use but currently used as private rooms.  Facility should be able to open these beds within 8 hours AND have necessary equipment available (e.g. have beds/equipment available, meet other life safety codes including appropriate headers for electrical, oxygen, curtains, etc.)."]
["Pre-induction, Post Anesthesia and Procedural Beds",null,"Each bay/cart location within the surgical/procedural care areas.  Pre-induction/ post-anesthesia/recovery and appropriate procedural beds (e.g., interventional, GI) should be counted toward this total. Selected ‘swing’,  same day surgery, or other beds that could increase ICU/inpatient surge may also be counted in this total if they can predictably be made available within hours – these should not be included in the inpatient bed counts above.  Procedural beds should include beds that allow full monitoring and care of patients undergoing minor procedures or sedation, such as endoscopy or interventional radiology, that are suitable for overflow critical care."]
[" Surge Discharge (# of Patients)",null,"Total number of inpatients that could be discharged early based on a spot survey of charge nurses, discharge management, and/or clinicians. Number can reflect actual time of survey completion or be based on prior exercise or other experiences. This number has been shown to vary substantially between facilities based on their elective admission volumes and may range from less than 15% to 40% or more and contributes significantly to initial surge capacity."]
["Operating Room Beds",null,"Total number of operating rooms/suites that are in daily use within the hospital. This should also include obstetrics operating rooms. (Operating rooms are not included in the surge calculation)."]
["TOTAL Initial Surge Capacity Estimate",{"$f":"IF(ISNUMBER(B5),(((B5-B6)/B5)*(B6+B8+B7)+B9+B10+B11),(0.2*(B6+B8+B7)+B9+B10+B11))","v":0},"Total Initial Surge Capacity Estimate"]

{"sheet":"Optional Coalition-Level Data","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[15,0,15,2],[2,0,2,2],[13,0,13,2],[14,1,14,2]]}
["Optional Coalition-Level Bed Data"]
[]
["This form allows coalitions to capture additional granular information on bed availability from each hospital. Capturing this information is completely voluntary and independent of the Hospital Data Collection Form/surge prediction tab. This data will NOT be included in the coalition aggregate data, but can help HCCs gain a better understanding of bed distribution both for surge and evacuation planning purposes."]
["Variable","Number","Description"]
["Burn ICU",null,"Total number of burn ICU beds. Indicate in comments below if Burn Center is accredited by the American Burn Association (ABA)."]
["Burn Floor Beds",null,"Total number of burn inpatient floor and observation beds that are in daily/routine operational use at the hospital. This should include units that are sometimes closed due to low census. Indicate in comments below if Burn Center is ABA accredited."]
["Neonatal ICU (NICU)",null,"Total number of inpatient critical care (including mechanical ventilation) Level 3 or 4 NICU beds."]
["Nursery Beds",null,"Total number of Level 1 or 2 nursery beds."]
["Level of Nursery/NICU Care",null,"Level 1 through 4"]
["Pediatric ICU",null,"Total number of pediatric inpatient critical care (including mechanical ventilation) ICU beds."]
["Pediatrics Floor Beds (Inpatient)",null,"Total number of pediatric inpatient floor and observation beds that are in daily/routine operational use at the hospital. This should include units that are sometimes closed due to low census."]
["Pediatric Psychiatric",null,"Total number of beds designated for pediatric inpatient psychiatric care."]
["Adult Psychiatric",null,"Total number of beds designated for adult inpatient psychiatric care."]
[]
["Comments/Additional Notes "]

{"sheet":"HPP Buildup","index":3,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Rank",{"$f":"A1","v":{"$error":"#REF!"}},"Item Number","Item","Notes","Priority Score"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,1,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H1)))*(COUNTIF(H$1:H1,$A$2:$A$31)=0),),0)),0)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I1)))*(COUNTIF(I$1:I1,$B$2:$B$90)=0),),0)),0)","v":0},{"$f":"IF(ISNA(VLOOKUP($I2,HPP_List,2,FALSE)),\"\",VLOOKUP($I2,HPP_List,2,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($I2,HPP_List,3,FALSE)),\"\",VLOOKUP($I2,HPP_List,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($I2,HPP_List,4,FALSE)),\"\",VLOOKUP($I2,HPP_List,4,FALSE))","v":""}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},2,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,2,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H2)))*(COUNTIF(H$1:H2,$A$2:$A$31)=0),),0)),H2)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I2)))*(COUNTIF(I$1:I2,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},3,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,3,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H3)))*(COUNTIF(H$1:H3,$A$2:$A$31)=0),),0)),H3)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I3)))*(COUNTIF(I$1:I3,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},4,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,4,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H4)))*(COUNTIF(H$1:H4,$A$2:$A$31)=0),),0)),H4)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I4)))*(COUNTIF(I$1:I4,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},5,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,5,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H5)))*(COUNTIF(H$1:H5,$A$2:$A$31)=0),),0)),H5)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I5)))*(COUNTIF(I$1:I5,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},6,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,6,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H6)))*(COUNTIF(H$1:H6,$A$2:$A$31)=0),),0)),H6)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I6)))*(COUNTIF(I$1:I6,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},7,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,7,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H7)))*(COUNTIF(H$1:H7,$A$2:$A$31)=0),),0)),H7)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I7)))*(COUNTIF(I$1:I7,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},8,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,8,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H8)))*(COUNTIF(H$1:H8,$A$2:$A$31)=0),),0)),H8)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I8)))*(COUNTIF(I$1:I8,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},9,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,9,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H9)))*(COUNTIF(H$1:H9,$A$2:$A$31)=0),),0)),H9)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I9)))*(COUNTIF(I$1:I9,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},10,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,10,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H10)))*(COUNTIF(H$1:H10,$A$2:$A$31)=0),),0)),H10)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I10)))*(COUNTIF(I$1:I10,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},11,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,11,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H11)))*(COUNTIF(H$1:H11,$A$2:$A$31)=0),),0)),H11)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I11)))*(COUNTIF(I$1:I11,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},12,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,12,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H12)))*(COUNTIF(H$1:H12,$A$2:$A$31)=0),),0)),H12)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I12)))*(COUNTIF(I$1:I12,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},13,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,13,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H13)))*(COUNTIF(H$1:H13,$A$2:$A$31)=0),),0)),H13)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I13)))*(COUNTIF(I$1:I13,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},14,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,14,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H14)))*(COUNTIF(H$1:H14,$A$2:$A$31)=0),),0)),H14)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I14)))*(COUNTIF(I$1:I14,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},15,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,15,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H15)))*(COUNTIF(H$1:H15,$A$2:$A$31)=0),),0)),H15)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I15)))*(COUNTIF(I$1:I15,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},16,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,16,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H16)))*(COUNTIF(H$1:H16,$A$2:$A$31)=0),),0)),H16)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I16)))*(COUNTIF(I$1:I16,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},17,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,17,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H17)))*(COUNTIF(H$1:H17,$A$2:$A$31)=0),),0)),H17)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I17)))*(COUNTIF(I$1:I17,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},18,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,18,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H18)))*(COUNTIF(H$1:H18,$A$2:$A$31)=0),),0)),H18)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I18)))*(COUNTIF(I$1:I18,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},19,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,19,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H19)))*(COUNTIF(H$1:H19,$A$2:$A$31)=0),),0)),H19)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I19)))*(COUNTIF(I$1:I19,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},20,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,20,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H20)))*(COUNTIF(H$1:H20,$A$2:$A$31)=0),),0)),H20)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I20)))*(COUNTIF(I$1:I20,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},21,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,21,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H21)))*(COUNTIF(H$1:H21,$A$2:$A$31)=0),),0)),H21)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I21)))*(COUNTIF(I$1:I21,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},22,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,22,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H22)))*(COUNTIF(H$1:H22,$A$2:$A$31)=0),),0)),H22)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I22)))*(COUNTIF(I$1:I22,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},23,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,23,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H23)))*(COUNTIF(H$1:H23,$A$2:$A$31)=0),),0)),H23)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I23)))*(COUNTIF(I$1:I23,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},24,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,24,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H24)))*(COUNTIF(H$1:H24,$A$2:$A$31)=0),),0)),H24)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I24)))*(COUNTIF(I$1:I24,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},25,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,25,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H25)))*(COUNTIF(H$1:H25,$A$2:$A$31)=0),),0)),H25)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I25)))*(COUNTIF(I$1:I25,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},26,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,26,{"$f":"IFERROR(INDEX($A$2:$A$31,MATCH(1,INDEX(($A$2:$A$31=LARGE($A$2:$A$31,ROWS(H$1:H26)))*(COUNTIF(H$1:H26,$A$2:$A$31)=0),),0)),H26)","v":0},{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I26)))*(COUNTIF(I$1:I26,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},27,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,27,null,{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I27)))*(COUNTIF(I$1:I27,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},28,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,28,null,{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I28)))*(COUNTIF(I$1:I28,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},29,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,29,null,{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I29)))*(COUNTIF(I$1:I29,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]
[{"$f":"#REF!","v":{"$error":"#REF!"}},30,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,30,null,{"$f":"IFERROR(INDEX($B$2:$B$90,MATCH(1,INDEX(($A$2:$A$90=LARGE($A$2:$A$90,ROWS(I$1:I30)))*(COUNTIF(I$1:I30,$B$2:$B$90)=0),),0)),0)","v":0},"","",""]

{"sheet":"Data Validation","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Challenges Column",null,"Scores"]
["Lack of personnel to complete",null,1]
["Lack of trained providers / instructors",null,2]
["Lack of subject matter experts",null,3]
["Lack of plans",null,4]
["Legal barrier",null,5]
["Administrative barrier"]
["Lack of equipment / supplies"]
["Lack of IT function"]
["Requires testing via exercise, other"]
["Inability to sustain/rotate adequate stock"]
["Lack of commitment (see notes)"]
["Lower priority area"]

{"sheet":"Resources","index":5,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,0,10,7],[11,0,13,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[5,0,5,7],[8,0,8,7],[3,0,3,7],[4,0,4,7],[7,0,7,7]]}
["Resources"]
["ASPR TRACIE Select HCC Resources"]
["ASPR TRACIE Select Resources\nASPR TRACIE is pleased to serve as a platform for developing and sharing resources that support the National Hospital Preparedness Program (NHPP) and its efforts to foster coalition development and operational readiness through the Health Care Preparedness and Response Capabilities. These resources are from a variety of sources including NHPP, external entities, or were developed by ASPR TRACIE at the request of NHPP or in response to stakeholder requests and needs. If you are unable to find what you are looking for, or if you would like to submit a resource for possible inclusion, contact the ASPR TRACIE Assistance Center.\n"]
["Additional Information:"]
["2017-2022 Health Care Preparedness and Response Capabilities "]
["2017-2022 Health Care Preparedness and Response Capabilities\nThis guidance document describes the four capabilities that healthcare coalitions and individual healthcare facilities need to prepare for, respond to, and recover from emergencies. The capabilities are: foundation for healthcare and medical readiness; healthcare and medical response coordination; continuity of healthcare service delivery; and medical surge.\n"]
[]
["HCC Surge Pilot Summary of Results "]
["The Health Care Coalition Surge Pilot -Summary of Results\nThis summary document provides an overview of the HCC Surge pilot conduced in during fall of 2018.  The HCC Surge Pilot demonstrated the value of collecting coalition-level surge capacity data. This critical aggregate baseline data can assist coalitions and their members to identify resources needed to meet surge needs and demands, while providing NHPP with a snapshot of the aggregate surge capacity within health care coalitions across the US.\n"]
[]
["Surge Discharge Template"]
["Surge Discharge Template\nSurge discharge is an important contributor to the ability of a healthcare facility to accommodate mass casualty patients and is difficult to perform when it is improvised or when only performed during disasters. This template provides a structure that hospitals can modify to help categorize patients for this surge discharge process."]

{"sheet":"Sheet5","index":6,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Not Met"]
["Working "]
["Complete"]
[]
[]
[1]
[2]
[3]
[4]
[5]