AD: A montage of video clips of health care workers wearing masks, gowns and gloves float over a graphic background of the Covid-19 virus. The video title using the personal protective equipment (PPE) burn rate calculator fades in. 

>> COVID-19 has created an unprecedented demand for personal protective equipment, or PPE. Healthcare facilities and other workplaces that use PPE need to carefully monitor their inventory and plan for future needs. The CDC has created tools to help you accomplish that task.

AD: The title fades out and is replaced by a computer screen displaying an excel spread sheet and a smart phone and tablet displaying the NIOSH PPE Tracker app.

>> Any healthcare facility or workplace that uses PPE can use these tools. This includes healthcare systems like hospitals and long term care facilities, as well as quarantine stations, correctional facilities, fire departments, and more. With the Excel calculator, you can track the number of boxes of different types of PPE you have in stock each day, calculate your average consumption rate or burn rate of each type. And estimate and visualize how long your remaining PPE supply will last, based on your facility's burn rate.

AD: A computer screen shows the cdc personal protective equipment (PPE) burn rate calculator web page along with the web address: www.cdcd.gov/corona virus/2019-ncov/hcp/ppe-strategy/burn-calculator.html.

>>This video shows you how to set up the calculator and use it. So, download the calculator now and let's get started.

AD: After clicking on the dowload link the burn rate calculator excel spread sheet opens and the narrator begins describing the navigation and usage of the spread sheet.

>> The spreadsheet has three different worksheets; the calculator, the graphs, and the instructions. To move between them, click the buttons at the top, or click the tabs the bottom. The instructions worksheet explains how to use the calculator. You can open this tab anytime you have questions on how to use the calculator. The graphs worksheet shows graphs of your PPE usage over time. These graphs will update automatically using the information you enter on the calculator worksheet. The calculator worksheet is where you'll add your inventory data. There are six different boxes on this worksheet. Boxes A through D are on the left side. They'll show your daily PPE inventory data, how much is being used, and how much is left. Boxes one and two are the pink boxes on the right side. They'll show your current burn rate, both overall and by patient. To use the calculator, you'll only need to enter data into box A. All the other boxes will automatically update based on what you enter in box A. Let's take a closer look at box A. This is where you'll enter your daily PPE inventory totals. We're going to show you how a healthcare facility might set up this section and track inventory over a few days. Before you start tracking, you'll want to set up the inventory to track. The left column of box A contains different types of PPE that you may want to track. Type of PPE refers to the PPE types you have in stock. Gowns, gloves, respirators, surgical masks, and face shields have been filled in already. Use the next column to fill in the size or brand if applicable. You only need to fill this column in if you have multiple sizes or brands. Otherwise, leave these cells blank. Examples of sizes have been added for you. But you can change these cells according to your inventory. For example, at our healthcare facility, we only have one size of gown. So, we're going to delete the other sizes. You can also fill in specific brands of items you want to track. Our healthcare facility uses three different kinds of respirators. We'll add those now. You can add additional types or brands of PPE in the other cells at the bottom. Make sure that each box of PPE has the same number of individual units. For example, a box of gloves may have 100 individual gloves. If you have another brand or type of gloves that has a different number of individual gloves in each box, add a new type of PPE category in a cell that says other. Our glove boxes all have the same number of gloves, so we can delete this. The top of box A is where you'll enter the dates you're tracking inventory. You can enter the first day and drag the bottom corner of that cell to the right to auto populate future days. Now that our healthcare facility has added the dates and the PPE types to track, we can begin using the sheet to track inventory and calculate our facility's burn rate. Example data have been preentered into the sheet, so we can start by deleting the values in those yellow cells. At the start of each day, we enter the total number of suspected and confirmed COVID-19 patients at our facility in the suspected and confirmed COVID-19 patients row of box A. If you are at a facility that doesn't treat COVID-19 patients, like an airport screening station or a correctional facility, you can leave these cells blank. In this example, our healthcare facility has 20 cases on day one. Each day, we have to enter how many full boxes of PPE are remaining from the day before. We'll do this for each type and size of PPE, entering in the data into box A. We'll start with our day one inventory totals. Each day, continue to enter the number of full boxes of each type of PPE into the yellow cells of box A. On day two, our inventory is less than day one. Our inventory is also lower on day three as we've used some supplies the previous day. We don't have to enter data for all 14 days to calculate the burn rate. However, we need to enter inventory data for at least two consecutive days before the calculator will provide any information on burn rate. The total number of boxes of PPE used per day will be calculated in box B. You will only see data here if you have entered values for at least day one and day two in box A. In this example, we see that from day one to day two, two boxes of gowns were used, two boxes of small gloves, eight boxes of medium gloves, and so on. The average rate of PPE consumption or the burn rate will be calculated in box one. We see the burn rate for each individual type of PPE, such as small gloves. And by the total type of PPE, such as the sum of all glove sizes. This is the average number of boxes of each type of PPE used per day. The burn rate for each patient will be calculated in box two for each individual type of PPE. And by the total type of PPE. This value tells you the number of boxes of PPE per day that you are using per patient who is being treated for COVID-19. The number of days of PPE supply remaining will be calculated in box C based on the average daily consumption rate. The number of boxes of PPE used per patient per day will be calculated in box D. Our burn rate calculations will be updated as we enter in data for more days. At our healthcare facility, we keep entering our inventory data every morning for the next three days. We'd like to see our PPE usage over time, so we go to the graphs worksheet. The top graph shows the total number of boxes of each type of PPE used per day. The bottom shows the number of days of PPE supply remaining based on our calculated PPE burn rate and current inventory. This version of the calculator does not accommodate resupply. If you receive a resupply of PPE, do not add it into the calculator, as it will disrupt the calculations. Instead, start a new spreadsheet and begin tracking again. You can save a copy of your existing spreadsheet and delete the current inventory to keep from having to reenter your PPE types.

Those are the basics of how to use the PPE burn rate calculator. The calculator was designed so that you can easily modify it to better fit your needs. Most cells in the worksheet are protected to make it easier to use. But you can unlock the worksheet for editing by selecting file, info, protect, and then unprotect. This will allow you to modify the tool. In addition to this spreadsheet based calculator, you can also download a mobile app to track your PPE inventory. It's available for free for both Apple and Android devices. The NIOSH PPE Tracker App has more features that include counting PPE inventory by box or by individual unit, resupplying or adding stock when calculating inventory totals, using a rolling average or a selected range of dates when calculating the burn rate, calculating with missing data, and exporting the data into an HTML or CSV format. For more information on PPE and strategies to conserve PPE, visit the CDC COVID-19 webpage.

AD: This video was produced by the national institute for occupational safety and health. Delivering on the nation’s promise: safety and health at work for all people through research and prevention. W W W dot C D C dot gov / nigh aush