Ambulance Duty Calendar in Google Sheets

The Ambulance Duty Calendar in Google Sheets is a formula-driven spreadsheet of five working tabs that turns one duty list into three linked calendar views – a full-year planner, a month grid and a date-range day list – all reading from a single Events table. It ships with exactly 100 sample ambulance-service duties, IDs 1 to 100, running from Thursday 01-Jan-2026 to Monday 28-Dec-2026, across 27 named locations and 15 duty types, with eight or nine entries in every one of the twelve months. Every one of the 100 sample rows was re-checked: the weekday printed against each date is correct in all 100.

Read this first. This is a duty-roster spreadsheet. It is not a dispatch or CAD system, not an emergency call-taking or 911/112 tool, not a patient care record or ePCR, and not a clinical-governance, compliance or accreditation reporting system. It measures no response time, tracks no vehicle location, sends no alerts and connects to nothing. It contains only what you type into your own copy.

Also available as the Ambulance Duty Calendar in Excel – a different build, not a port of this one. That edition is a macro-enabled workbook with a pop-up entry form, Add/Update/Delete buttons, a This Month sheet and five one-click colour themes. This Google Sheets edition has none of those, and needs no macros in return: it runs on plain worksheet formulas in any browser.

Key Features of the Ambulance Duty Calendar in Google Sheets

• Five working tabs: Home, Annual View, Monthly View, Daily View and Events, plus one hidden helper tab that holds the month and year drop-down lists.
• One master table drives every view. The Events sheet holds 7 columns – ID, Date, Day, Event Name, Time, Location and Description – and all three calendar views read from it, so a duty entered once appears everywhere.
• No macros, no Apps Script, no add-ons. The Annual View is built with DATE, EOMONTH and TEXT; the Monthly View places duties with VLOOKUP and counts extras with COUNTIF; the Daily View is a single FILTER formula. Nothing has to be enabled, authorised or trusted before the file works.
• Exactly 100 sample duties across a full year, sorted by date from a Night Shift Crew Roster on Thursday 01-Jan-2026 to an Oxygen and Fuel Refill on Monday 28-Dec-2026.
• 15 duty types already written in – Night Shift Crew Roster, Day Shift Crew Roster, On-Call Duty Roster, Standby Duty Cover, Dispatch Shift Handover, ER Handover Duty, Inter-Hospital Transfer Duty, Emergency Response Drill, Paramedic Training Session, Daily Vehicle Roadworthiness Check, Vehicle Maintenance Check, Oxygen & Fuel Refill, Equipment & Supply Restock, Deep Clean & Decontamination and Radio & Comms Check.
• 27 named locations, not just station names: Ambulance Bays 1-3, Dispatch Control Room, Comms Centre, Hospital ER Handover, Base Hospital Ramp, Referral Hospital Bay, Emergency Department Triage, Standby Posts North and South, Fleet Workshop, Vehicle Service Bay, Wash Bay, Decontamination Bay, Fuel Point, Oxygen Store, Medical Store, Supply Room, Crew Rest Room, Station Crew Room, Training Room A, Training Ground, Drill Yard, Lecture Hall, Simulation Suite and Base Station.
• Round-the-clock sample times – 14 distinct start times from 06:00 through to 23:00 – so night cover, small-hours comms checks and 06:30 workshop slots sit in the grid beside daytime training.
• Click-through navigation. The Home tab carries four in-sheet links to the views, and every view carries a “Back” link home. No buttons to enable, and it works the same on the Google Sheets mobile app.
• Month and year drop-downs on the Monthly View (January to December; years 2021 to 2039) and a year cell on the Annual View, all fed from the hidden list tab.
• No crew name, employee ID, licence number, phone number or pay column anywhere in the file. The roster is built around the duty, the time and the location – not the person.
• Works in the browser on Google Sheets, and downloads to .xlsx if a colleague needs an Excel copy of the data.

What is Inside the Ambulance Duty Calendar in Google Sheets

Tab 1: Home – Navigation

A branded landing tab with four links – Annual View, Monthly View, Daily View and Events – so anyone at the station can move around the file without knowing Google Sheets. The footer carries the NextGenTemplates link.

Tab 2: Annual View

All twelve months of the chosen year on one screen in a three-across, four-down grid, with every day that carries a duty shaded amber so a year of coverage reads at a glance. Change the year in one cell and all twelve month blocks rebuild themselves from formulas. This is the tab to print for the crew-room noticeboard.

Tab 3: Monthly View

The working grid. Pick a month and a year from the two drop-downs and the month redraws Sunday to Saturday, printing the duty name inside the day cell. Where a date carries more than one duty the cell shows the first duty and a “1 more” note underneath, so you can see at a glance which days are double-booked and open the Daily View for the detail.

Tab 4: Daily View

Type a start date and an end date and a single FILTER formula returns every duty in that window with all seven columns – ID, Date, Day, Event Name, Time, Location and Description. Set both boxes to the same date for a one-day handover sheet, or to a Monday and a Sunday for the week ahead.

Tab 5: Events – the master table

The 100 sample duties in one sortable, filterable table. Add a row here and it appears in all three views. This is also where you delete the samples and type your own roster.

Google Sheets vs. Excel vs. Paid Shift-Scheduling SaaS – Where This Fits

Who This Template Is For – and Who It Is Not For

It fits a single ambulance station, a private patient-transport operator, a hospital transport desk, a first-aid or event-medical provider, or an EMS training officer who needs next quarter of drills and training slots visible on one page. It fits anyone currently keeping the duty board in a notebook, a WhatsApp group or a blank spreadsheet.

It does not fit a service that needs live dispatch, call-taking or vehicle tracking; a service that needs statutory, clinical-governance or accreditation returns; a service that needs automatic shift reminders or swap requests; or a service that needs a signed audit trail of who changed what. This file provides none of those, and no spreadsheet should be asked to. It also does not do payroll, and it holds no personal data as shipped – see the FAQ before you add any.

How to Use the Ambulance Duty Calendar in Google Sheets

1. Open the PDF you receive after purchase and click its Make a copy link. The template lands in your own Google Drive – the master file stays read-only.
2. Open the Events tab and clear rows 4 to 103, keeping the header row.
3. Type your own duties: date, day, duty name, start time, location and a one-line description.
4. Open the Monthly View, pick the month and year, and check the grid fills as expected.
5. Use the Daily View date boxes to print a handover sheet for a shift, a day or a week.
6. Share the file with Share > specific people so only named colleagues can open or edit it.

Real-World Use Cases

Priya, station officer at a two-vehicle base. She types the crew rosters, standby cover and vehicle checks into the Events sheet on the first of the month, prints the Monthly View for the crew room, and mails the Daily View range for the coming week to the two on-call medics.

Daniel, fleet supervisor for a private patient-transport firm. He uses the Location column for bays and workshops, so the Daily View doubles as the workshop morning list: roadworthiness checks, oxygen refills and deep cleans, each with the bay written next to it.

Aisha, EMS training officer. She blocks out the drills and continuing-education sessions for the year in January, then shows the Annual View to the clinical lead – twelve months of shaded training days on a single screen, with no software to buy.

Frequently Asked Questions

Do I need macros, Apps Script or an add-on?

No. Every view is built from ordinary worksheet formulas – DATE, EOMONTH, TEXT, VLOOKUP, COUNTIF and FILTER. Nothing needs to be enabled or authorised, and there is no script to review.

The Day column does not change when I edit a date. Is that a bug?

It is a known limitation, and worth knowing before you start. In the Events sheet the Day column is typed text, not a formula, so editing a date leaves the old weekday in place. All 100 sample rows are correct as shipped – we re-checked every one – but if you plan to move dates around, put =TEXT(B4,"dddd") in cell C4 and fill it down column C. The Day column then follows the date automatically for good.

Why does a day cell say “1 more” in the Monthly View?

The month grid has room for one duty name per day, so it prints the first duty on that date and tells you how many others exist. Open the Daily View and set both date boxes to that date to see them all. Two dates in the sample year carry a second duty.

A long duty name looks cut off in the month grid.

Names longer than about thirty characters are clipped by the width of the day cell – “Daily Vehicle Roadworthiness Check” is the one you will see. Widen the column, shorten the duty name, or read the full name in the Daily View or Events tab.

Can I use a year other than 2026?

Yes. The Annual View year cell and the Monthly View drop-down cover 2021 to 2039, and every grid is drawn from formulas, so changing the year redraws the calendar. Your own duty rows drive which days are shaded.

Is it safe to put crew names in it?

As shipped the file holds no personal data at all – no crew names, no patient details, no addresses or contact numbers. If you add them, the safest pattern is to keep internal codes in the sheet and hold the code-to-name key separately, and to share the file with named people rather than “anyone with the link”. Google sharing controls are the only access control here; the file itself has no permissions, no encryption and no audit trail.

What is the difference between this and the Excel edition?

They are two separate builds, not one file converted. The Excel edition is a macro-enabled workbook with seven sheets, a pop-up entry form, Add/Update/Delete buttons, a This Month sheet, a Setting sheet with five colour themes, 27 duty types across 7 stations, and named public-holiday standby entries. This Google Sheets edition has five tabs, no macros, no form and no theme switcher, but runs in any browser, supports several editors at once, and uses 15 duty types across 27 specific locations instead. Buy the one that matches how your station actually works – or both.

About the Author

Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Explore Related Templates

• Ambulance Duty Calendar in Excel – the macro-driven edition, with a pop-up entry form and five colour themes.
• Doctor On-Call Calendar in Google Sheets – the same three-view layout for on-call medical rotas.
• Home Nursing Visit Calendar in Google Sheets – for community and home-visit scheduling.
• Dialysis Session Calendar in Google Sheets – recurring treatment slots by chair and shift.
• Medical Equipment Calibration Calendar in Google Sheets – service and calibration due dates.
• Blood Donation Camp Calendar in Google Sheets – camp and drive planning across a year.
• Browse more Google Sheets templates and the full Google Sheets Calendar category.

Get the Ambulance Duty Calendar in Google Sheets for 4.99 (regular 8.99). You receive a PDF containing the Make a copy link – the template lands in your own Google Drive in seconds, with all 100 sample duties in place so you can see how it behaves before you clear a single row.

Read the full walkthrough on the blog: Ambulance Duty Calendar in Google Sheets. More Google Sheets tutorials on YouTube: @PKAnExcelExpert.

Watch the step-by-step video Demo:

Last updated: 03 September 2026.