Paper MothAnalytics
Sample · invented data
Staffing snapshot
Pine Ridge Community Hospital
Try it with your own file
Load this week's numbersPick one spreadsheet with all your weeks, or several at once. It's read right here on your computer. Nothing is uploaded.
What your file needs
A shifts sheet: Week of Unit Day Shift Needed Filled
A staff sheet: Week of Staff ID Role Unit Hours (2 weeks) Shifts in a row
Common nicknames work too, like Times for Shift or Staffed for Filled. Add new weeks as new rows at the bottom.
This week in one line
Where are we short?
When is it hardest?
Who's wearing out?
Do this week
See the detail behind this
Shifts filled vs needed, by unit
Mon–Sun.
Percent of shifts filled, by day and shift
80–87%Under 80%
Staff over 72 hours in two weeks
High risk = over 90 hours, or 5+ shifts in a row.
8 weeks in one line
Where the gaps land, week by week
Shifts short by unit. 3–78 or more
Who keeps covering the gaps
High riskWatchOK