Healthcare Staff


COVID-19Surge is a spreadsheet-based instrument that hospital directors and public well being officers can use to estimate the surge in demand for hospital-based companies in the course of the COVID-19 pandemic. A consumer of COVID-19Surge can produce estimates of the variety of COVID-19 sufferers that should be hospitalized, the quantity requiring ICU care, and the quantity requiring ventilator help. The consumer can then evaluate these estimates with hospital capability, utilizing both current capability or estimates of expanded capability.

With COVID-19Surge, customers outline the inhabitants within the hospital “catchment space” or native jurisdiction. The consumer additionally enters the variety of instances so far, and the out there hospital sources (non-ICU beds, ICU beds, and mechanical ventilators). Customers can assess as much as three group mitigation methods concurrently and evaluate the impacts on hospital sources versus a “no intervention” situation.


Can COVID-19Surge be used to precisely estimate the influence of COVID-19?

The numbers generated by means of COVID-19Surge are estimates. They DO NOT mirror what is going to truly happen in the course of the pandemic. Slightly, they’re estimates for a given set of eventualities. COVID-19Surge needs to be used to plan and put together a response to a surge in demand for hospital-based sources as a result of COVID-19 pandemic.

Can customers change the enter variables?

Sure. Whenever you obtain and open the COVID-19Surge, all inputs are pre-populated with numbers and estimates primarily based on revealed sources. Customers can change the values within the instrument that finest illustrate the state of affairs of their jurisdiction. Additional, we encourage customers to alter enter values and discover the influence of assorted eventualities. Explanations are offered within the accompanying handbook.

System Necessities

COVID-19Surge makes use of the Home windows* working system (Microsoft Home windows 2010 or greater) and Excel (Microsoft Workplace 2013 or greater). The total performance of COVID-19Surge is supported within the desktop model of Microsoft Workplace® for Home windows. Some performance will not be out there in Microsoft Workplace for Macs or within the browser model of Workplace 365.

*Microsoft Home windows and Workplace are copyrighted merchandise produced by Microsoft Company, WA. Using commerce names and industrial sources is for identification solely and doesn’t indicate endorsement by the U.S. Division of Well being and Human Providers.

Obtain the Information

We advocate downloading and saving the COVID-19Surge spreadsheet to your laptop, then open the spreadsheet out of your laptop. This can enable the spreadsheet to open in Excel as a substitute of your internet browser.

Load, Begin, and Navigation

Open the COVID-19Surge spreadsheet and click on the field on the prime of the doc that claims, “Allow Macros,” or “Allow Content material” (relying on model of Excel getting used). After enabling macros, click on the “Begin” button on the duvet web page to begin navigating the instrument. If you happen to encounter any points, contact with a topic line [COVID-19Surge tool inquiry].

Supply hyperlink