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 09-07 | Tue 09-08 | Wed 09-09 | Thu 09-10 | Fri 09-11 | Sat 09-12 | Sun 09-13 | 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 |