Private Protecting Tools (PPE) Burn Price Calculator

The private protecting gear (PPE) burn charge calculator excel icon[XLS – 39 KB] is a spreadsheet-based mannequin that gives info for healthcare amenities to plan and optimize the usage of PPE for response to coronavirus illness 2019 (COVID-19). Equally, non-healthcare amenities (e.g., correctional amenities) might discover this device helpful for planning and optimizing PPE use as a part of the response to COVID-19. This device may also be used for planning PPE use exterior the context of COVID-19, the place PPE shortages may additionally happen resulting from provide chain points associated to the COVID-19 response (e.g. manufacturing amenities).

To make use of the calculator, you enter the variety of full bins of every kind of PPE that you’ve got in inventory (e.g., robes, gloves, surgical masks, respirators, and face shields). This device then calculates the typical consumption charge, additionally known as a “burn charge,” for every kind of PPE entered within the spreadsheet. This info can then be used to estimate the remaining provide of PPE primarily based on the typical consumption charge. The spreadsheet is open-ended and may also be used to calculate the usage of different varieties of PPE as properly.

System Necessities

  • Home windows* working system (MS Home windows 2000 or newer)
  • Microsoft Excel (MS Workplace 2000 or newer)
  • 486 Pentium processor and at the least 128MB RAM
  • 2 MB of exhausting drive space for storing

* MS Home windows and Workplace is a copyrighted product produced by Microsoft Company, primarily based in Redmond, WA. Use of commerce names and business sources is for identification solely and doesn’t suggest endorsement by the U.S. Division of Well being and Human Companies.

Directions for Downloading

Earlier than loading and beginning the PPE Burn Price Calculator, you could want to alter Excel’s safety stage. You will need to first do the next steps:

  1. Open a clean Excel spreadsheet.
  2. Click on Instruments after which click on Macro, select Safety.
  3. Set Safety Degree to Medium.
  4. Click on OK.
  5. Double-click and open PPE burn charge calculator file.
  6. When requested to Disable Macros or Allow Macros, click on Allow Macros.

Downloading the Information

We advocate downloading and saving the PPE burn charge calculator spreadsheet to your laptop earlier than opening the spreadsheet. Taking this step will open the spreadsheet in Excel reasonably than your internet browser.



Loading ....

Leave a Reply