
Company Magazine
Docs + Word7 pages
FeaturedFree
The nurse shift schedule suits charge nurses and ward managers who build the roster for one unit. The Roster tab holds one row per shift with the date, nurse, unit, shift type, hours and status, from Confirmed through Requested to Swap pending. The Nurses tab lists each nurse's contracted hours for the fortnight, works out the hours already booked and shows what is still to book, while the dashboard charts hours by nurse and by unit.
The file opens with a sample fortnight for six nurses, so every total and chart shows real figures. Replace the names, add each shift as you book it and mark a trade as Swap pending until the charge nurse agrees. Any shift over 12 hours turns red, and a nurse booked above contract is highlighted on the Nurses tab, so you can rebalance before the roster goes out.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Roster tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Set the status of the shift to Swap pending, then change it to Confirmed once both nurses and the charge nurse agree. The dashboard counts the swaps still waiting, so nothing stays open for long.
Yes. Type the real hours in the Hours column. The red highlight only flags rows over 12 hours, so change that rule if your unit works longer shifts. Check your unit's own rules on rest breaks as well.
No. It adds up hours and counts shifts, but it does not check rest periods or staffing ratios. Check your hospital's policy and any local rules before you publish a roster.

Docs + Word7 pages
FeaturedFree
Docs + Word21 pages
FeaturedFree
Slides + PowerPoint16 slides
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel4 tabs
Free