{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","HCC Hospital Aggregation","Data - By File Name","Data - By Item","Data - By Priority List","Data - By Priority Score"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":27,"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":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["ASPR TRACIE Health Care Coalition Surge Estimator Tool: Aggregator"]
["Introduction","This tool was developed by the HHS Assistant Secretary for Preparedness and Response’s Technical Resources, Assistance Center, and Information Exchange (ASPR TRACIE) as a companion to the HCC Surge Estimator Hospital Data Collection tool and is intended to summarize the results from multiple HCC Hospital Data Collection workbook files to present an aggregate estimate at the coalition level, based on hospital members' responses. 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-hcc-aggregator.pdf\n\nFor additional questions or to discuss this tool 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","Note: The tool currently works only in Windows versions of Excel 2003 and later.  It will not work on a Mac.\n1. Place the HCC Hospital Data Collection workbook files in a single empty folder (not a zip file).\n2. Note that you may need to click an \"Enable Content\" button at the top of the excel window of this Aggregator tool to allow it to work.\n4. Click the “Aggregate” button on the tool located below these instructions at Line 15.\n5. Select the folder where the HCC Hospital Data workbooks are located. When you open the folder, it may show as empty but simply click “Ok” and the program will run.\n6. A pop up box will appear to notify you that the program is running. Click “Ok” to proceed.\n7. Wait for the program to run. You will see a prompt when it is complete. Click “Ok” to proceed.\n8. View the aggregated results on the \"HCC Hospital Aggregation” tab."]
[]
["Key Points"]
["Interpreting Results","The data is presented to allow awardees and other users to view the results by coalition.\n• HCCs will NOT submit individual hospital metrics to ASPR. Information will be aggregated at the coalition-level.\n• HPP recipients or other users can view data from multiple coalitions for trends and common issues.\n• HCCs should use this data to identify gaps and resources for their preparedness and response plan development."]
["Tips for Success","• Use this tool on a PC/Windows environment. We are working to allow the tool to be used on Apple iOS as well.\n• HCCs should ensure all Hospital Data Collection workbooks are complete. Any incomplete data may not allow the aggregator to display results properly. \n• Clearly name your files how you would like them to display/read on the data tabs. The entire file name will show up so you may consider creating shorter file names. "]

{"sheet":"HCC Hospital Aggregation","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[21,0,21,2],[2,1,2,2],[19,0,19,2],[13,0,13,2],[20,1,20,2]]}
["HCC Hospital Aggregation"]
[]
["TOTALS"]
["Variable","Number","Description"]
["Floor Beds",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A5,'Data - By Item'!C:C)","v":0},"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 ",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A6,'Data - By Item'!C:C)","v":0},"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 coaltion level. "]
["ICU Beds",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A7,'Data - By Item'!C:C)","v":0},"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",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A8,'Data - By Item'!C:C)","v":0},"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",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A9,'Data - By Item'!C:C)","v":0},"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",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A10,'Data - By Item'!C:C)","v":0},"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 counted in the inpatient beds 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)",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A11,'Data - By Item'!C:C)","v":0},"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",{"$f":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A12,'Data - By Item'!C:C)","v":0},"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":"SUMIF('Data - By Item'!B:B,'HCC Hospital Aggregation'!A13,'Data - By Item'!C:C)","v":0},"Total Initial Surge Capacity Estimate"]
["Additional Bed Data"]
["Burns",null,"Burn ICU beds approved by the American Burn Association or self/state-designated. (These beds are NOT to be included in other ICU bed counts.)"]
["Neonatal ICU (NICU)",null,"NICU beds are NOT included in the ICU beds above. NICU beds may be entered here if desired by coaltions for planning."]
["Pediatric ICU",null,"Pediatric ICU Beds SHOULD be included in the ICU Beds above but may be separately entered here if desired by the coalition for pediatric planning and use."]
["Pediatrics (Inpatient)"]
["Psychiatric",null,"Ward beds on a closed/locked psychiatric unit or ward beds where a patient will be attended by a sitter"]
[]
["Comments/Additional Notes from Coalition"]

{"sheet":"Data - By File Name","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["File Name","Variable","Number","Description"]

{"sheet":"Data - By Item","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["File Name","Variable","Number","Description"]

{"sheet":"Data - By Priority List","index":4,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["File Name","Variable","Number","Description"]

{"sheet":"Data - By Priority Score","index":5,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["File Name","Variable","Number","Description"]