Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHealth & FitnessClinic & Practice ManagementNurse Shift Schedule

SpreadsheetClinic & Practice ManagementFree

Nurse Shift Schedule

A two-week unit roster with day, evening and night shifts, hours per nurse and a staffing check for every shift.

Shown with sample data

Colour

Nurse Shift Schedule

A two-week unit roster with day, evening and night shifts, hours per nurse and a staffing check for every shift.

Shifts rostered
53
Hours rostered
636
Over contract
2
Nurses above contracted hours
Under contract
0
Days short
0
Fix before publishing
Hours rostered per nurse
  • Hugo Silva84
  • Amara Nwosu72
  • Ben Carter72
  • Chloe Martin72
  • Dev Sharma72
  • Elena Rossi72
  • Farah Khan72
  • Grace Lee72

How to use it

  1. 1List each nurse with their role and contracted hours for the two weeks.
  2. 2Set shift lengths on the Settings sheet (12 hours by default).
  3. 3Choose a code for every day: D, E, N, or Off / AL / TR.
  4. 4Open the Coverage sheet and fix any shift marked Short before publishing.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Plan who is on, for which shift, without double-booking anyone or leaving a shift short. Assign D, E or N (or leave, off and training codes) for each nurse across the fortnight; the roster totals hours per nurse against their contracted hours and a coverage sheet counts staff on each shift against the minimum you set.

Who it’s for

  • Hospital units and wards
  • Care homes and hospices
  • Clinics with extended hours

What’s included

  • Roster sheet: Who works which shift across the fortnight.
  • Coverage sheet: Staff on each shift against your minimum.
  • Settings sheet: Shift length used for hours.

How to use it

  1. 1List each nurse with their role and contracted hours for the two weeks.
  2. 2Set shift lengths on the Settings sheet (12 hours by default).
  3. 3Choose a code for every day: D, E, N, or Off / AL / TR.
  4. 4Open the Coverage sheet and fix any shift marked Short before publishing.

Tips

  • Avoid more than three consecutive nights where you can.
  • Publish the roster at least two weeks ahead so swaps happen early.

Questions

What do the codes mean?

D day, E evening, N night, Off rest day, AL annual leave, TR training. Only D, E and N count as worked hours.

How do I change the minimum staffing?

Edit the Minimum column on the Coverage sheet for each shift.

Related searchesnurse schedulenursing roster12 hour shift schedulestaffinghospital rotaunit schedule

Details

Format
Spreadsheet
Category
Clinic & Practice Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetClinic & Practice ManagementFree

Nurse Shift Schedule

A two-week unit roster with day, evening and night shifts, hours per nurse and a staffing check for every shift.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Clinic & Practice Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More clinic & practice management templates

View all
Patient Appointment Schedule2 sheets

Appointments

10

No-show rate

10%

Average wait (min)

11.5

ABCD
1DateTimeProviderVisit type
2Nov 1208:30Dr PatelAnnual check
3Nov 1208:30NP RiveraFollow-up
4Nov 1209:00Dr PatelNew patient
5Nov 1209:15Dr OkaforProcedure
Schedule
SpreadsheetClinic & Practice Management

Patient Appointment Schedule

A day sheet for the front desk: every appointment by provider and room, with arrival status, wait time and the day’s no-show rate.

10 min setupPreview

New Patient Intake Form

Please complete this form before your first visit. Your answers help us prepare for your appointment.

Full name *

Date of birth *

Phone *

Send my details
FormClinic & Practice Management

New Patient Intake Form

Registration details, emergency contact, insurance and a short health history, collected before the first visit.

10 min setupPreview
Medical Supplies Inventory2 sheets

Items to reorder

4

Expiring within 60 days

2

Expired

1

ABCD
1ItemCategoryUnitStorage area
2Nitrile gloves, mediumPPEBox of 100Store cupboard
3Surgical masksPPEBox of 50Store cupboard
4Gauze swabs 10 x 10 cmWound carePack of 100Treatment room 1
5Adhesive dressings, assortedWound careBoxTreatment room 1
Supplies
SpreadsheetClinic & Practice Management

Medical Supplies Inventory

Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ