Nurse Pandemic Role Allocation Tool (N-PRAT)

This tool can be used in conjunction with the Nursing Skills Survey to transform the output from that survey into a list of assignments of Faculty to COVID-19 unit roles. If you have questions about the tool or would like help customizing it to your local needs, please contact us at


1. Export the responses of the Nursing Skills Survey as a .csv file.
If you didn’t use our Google Forms version of the survey, make sure that the names and order of the columns in your .csv file spreadsheet match the format in this example file:

2. Download our Nurse Pandemic Role Allocation Tool (N-PRAT) file. (Follow the link below, click to download “Source code (zip),” open the .zip file, and find the tool Microsoft Excel file inside.)

3. Paste your survey results into the “Input” sheet of the N-PRAT tool. (You can also manually fill in the survey information, if you’d like.)

4. Look in the “Assignment” sheet of the N-PRAT for a list of COVID-19 unit roles your staff can fill.

Note: .csv files can be viewed in any spreadsheet software.

This tool was created by Daniel Kendrick MD MA, Laura Mazer MD MHPE, Tanvi Gupta MS, Hoda Bandeh-Ahmadi PhD, Kyla Terhune MD MBA, and Brian C George MD MA. We are also extremely grateful to University of Michigan ICU nurses Alex Gill and Noel Baldwin for their helpful feedback.