We recommend downloading and saving the PPE Burn Rate Calculator spreadsheet to your computer before opening the spreadsheet. When asked to Disable Macros or Enable Macros, click Enable Macros.Double-click and open PPE Burn Rate Calculator file.Click Tools and then click Macro, choose Security.Department of Health and Human Services.īefore loading and starting the PPE Burn Rate Calculator, you may need to change Excel’s security level. Use of trade names and commercial sources is for identification only and does not imply endorsement by the U.S. They are extremely easy to set up, use programs to generate spreadsheets and do lots more. They help users to focus completely on the data of equipment inventory template and see if anything is amiss in the records. * MS Windows and Office is a copyrighted product produced by Microsoft Corporation, based in Redmond, WA. These templates allow the use to better make use of CMS like Magneto or online solutions such as Prestashop. 486 Pentium processor and at least 128MB RAM.Microsoft Excel (MS Office 2000 or newer).Windows* operating system (MS Windows 2000 or newer).Using the calculator can help your facility make order projections for future needs. This information can then be used to estimate how long the remaining supply of PPE will last, based on the average consumption rate. The tool will calculate the average consumption rate, also referred to as a “burn rate,” for each type of PPE entered in the spreadsheet. If your facility does not treat COVID-19 patients, leave “patients” row blank.
To use the calculator, enter the number of full boxes of each type of PPE in stock (gowns, gloves, surgical masks, respirators, and face shields, for example) and the total number of patients at your facility, if applicable. Non-healthcare facilities such as correctional facilities may also find this tool useful. The Personal Protective Equipment (PPE) Burn Rate Calculator (Version 2) excel icon is a spreadsheet-based model that will help healthcare facilities plan and optimize the use of PPE for response to COVID-19.