A weekly nursing rota with a coverage row that checks the nurses on the floor against the census in the beds.
| Nurse | Role | Licence expires | Mon 07-20 | Tue 07-21 | Wed 07-22 | Thu 07-23 | Fri 07-24 | Sat 07-25 | Sun 07-26 | Shifts |
|---|---|---|---|---|---|---|---|---|---|---|
| Ana Reyes (example, overwrite) | RN | 2027-03-31 | D | D | N | N | ||||
| Bola Adeyemi (example, overwrite) | RN | 2026-09-14 | D | D | D | |||||
| Cara Whitfield (example, overwrite) | LPN | 2027-01-06 | N | N | N | |||||
| Patients per nurse (day): edit this | 5 | The ratio your unit is held to. | ||||||||
| Day-shift census: enter each day | Patients on the unit | |||||||||
| RNs and LPNs scheduled (day) | Counted from the grid | |||||||||
| Nurses required (day) | Census ÷ ratio, rounded up | |||||||||
| Over / under (day) | Negative means short | |||||||||
| Night-shift nurses scheduled | Counted from the grid |