Ask any hospital at 2am who is on call and you will usually get three answers: the laminated sheet on the mess wall, the WhatsApp message from last Thursday, and whatever switchboard has written down. The Doctor On-Call Calendar in Google Sheets replaces the first two with one shared file that anybody can open in a browser. It ships with 100 sample on-call duties, IDs 1 to 100, running from 02-Jan-2026 to 30-Dec-2026 with every one of the twelve months populated (8, 8, 8, 9, 8, 9, 8, 9, 8, 9, 8, 8). Those duties sit across 19 duty types and 31 named locations, at 10 distinct start times between 8:00 AM and 10:00 PM. It costs $4.99 once.
Before anything else, the honest framing. This is a scheduling spreadsheet. It is not a clinical system, not a patient record, not an EHR or EMR, and not an e-rostering or paging platform. It holds no patient data. It sends no bleep, page, SMS or email. It checks no working-time regulation, rest period or safe-staffing rule, and it is not a substitute for your hospital’s official rota or switchboard record. What it does is answer one question quickly and for everybody at once: what cover is booked, where, and when.
Key Features of the Doctor On-Call Calendar in Google Sheets
- One table, three views. Every duty lives on the Events sheet in seven columns – ID, Date, Day, Event Name, Time, Location, Description. The Annual, Monthly and Daily pages are formula-driven reads of that one table, so a duty is typed once and appears in three places.
- The whole on-call picture, not just the nights. The sample includes General Medicine First On-Call and General Medicine Second On-Call, Emergency Department Senior Cover, Anaesthesia On-Call, Obstetrics On-Call, Paediatrics On-Call, Surgical Registrar On-Call, ICU Intensivist Cover, Cardiology Consultant Cover, Stroke Thrombolysis Call, Psychiatry Crisis Cover, Gynaecology Emergency Cover, Radiology Reporting Cover and Night Shift Twilight Cover – and, just as importantly, the parts of a rota that usually live nowhere: Home / Telephone Standby, Shift Handover Round, Weekend Consultant Ward Round, Public Holiday Cover and the On-Call Rota Review Meeting itself.
- 31 locations already modelled, from Emergency Department – Majors and Emergency Department – Resus through the Medical Admissions Unit, Hyperacute Stroke Unit, Coronary Care Unit, Labour Ward, Neonatal Unit, Children’s Ward D2, Cardiac Catheterisation Lab, Interventional Radiology Suite, the Psychiatric Liaison Room and the Handover Room on Level 2 – plus the two that actually matter overnight, Doctors’ Mess – Bleep 101 and Off-Site Standby – Switchboard.
- A 36-year horizon. A hidden List helper sheet feeds the dropdowns with all twelve month names and the years 2021 to 2056.
- Room for roughly 900 more duties. Every view formula reads down to row 999, so years of rota can accumulate without touching a formula.
- Browser-native. No install, no licence, no macros to enable. It opens on a phone in the corridor as readily as on the rota-holder’s desktop.
- No name field anywhere – not for the doctor and not for a patient. That is a design choice, and it gets its own section below.
Calendar Pages Explained
Home
A plain menu with four buttons – Annual View, Monthly View, Daily View and Events – and a “Back” link on every other sheet returning to it. It exists so that a colleague you have shared the file with does not have to understand spreadsheet tabs to find next week’s cover.
Annual View
Twelve months of one year on a single screen, three across and four down, with every date that carries a duty shaded. One Year cell drives the whole grid. In practice nobody reads this page for what is covered – they read it for what is not. The unshaded weekday in the middle of March is the point of the page.
Monthly View
One month as a seven-column week grid with the duty name printed under the date, driven by Month and Year dropdowns. The October 2026 sample shows Radiology Reporting Cover on Friday the 2nd, Psychiatry Crisis Cover on Saturday the 3rd, General Medicine First On-Call on Sunday the 4th, Home / Telephone Standby on the 5th, 11th and 18th, the Weekend Consultant Ward Round on the 15th and the Shift Handover Round on the 26th. This is the page to print.
Daily View
Type a Start Date and an End Date and a live FILTER returns every duty in that window with its ID, day, name, time, location and description. Set it to 01-Oct-26 and 31-Oct-26 in the sample and nine duties come back, IDs 76 to 84. This is the handover list, and it is the only view that shows every duty on a date that carries more than one.
Events
The master table and the only sheet anyone types into. Seven columns, one duty per row, 100 sample rows to overwrite or build on. Because every other page reads from here, there is exactly one version of the truth in the file.
List (hidden)
The helper feeding the Month and Year dropdowns – twelve months, years 2021 to 2056. Unhide it only if you want to trim the year list.
Doctor On-Call Calendar vs. Excel vs. Paid Rota Software – Feature Comparison
| This Google Sheets calendar | An Excel duty calendar | Paid medical e-rostering software | |
|---|---|---|---|
| Cost | $4.99 once | $4.99 to $9.99 once | Typically four to five figures a year |
| Platform | Any browser, any OS | Windows desktop Excel | Vendor web app |
| Setup time | Under 5 minutes | Under 5 minutes | Weeks, with implementation fees |
| Real-time team access | Yes, built in | Only via a shared drive | Yes |
| Mobile access | Yes, the Sheets app | Limited | Yes |
| Share with a link | Yes | No | Account-based |
| Bleeps, pages, SMS or email alerts | No | No | Yes |
| Working-time and rest-period checking | No | No | Yes |
| Safe-staffing and credentialing checks | No | No | Yes |
| Swap requests and approvals | No | No | Yes |
| Hours worked / on-call intensity | No – no end-time field | No | Yes |
| Patient or clinical data | None – by design | None | Yes, and regulated accordingly |
| Year-1 cost at 20 doctors | $4.99 | $4.99 to $9.99 | Thousands |
The Missing Name Column Is the Point
Count the columns on the Events sheet: seven, and not one of them is a person. There is no doctor name, grade, staff number, GMC number, bleep holder or phone number – and equally no patient name, hospital number, diagnosis or clinical note. All 100 sample rows and all 19 duty descriptions were checked, and they contain no identifier of any kind. The word “patient” does not appear in the data at all.
That is deliberate. A rota gets forwarded, screenshotted, printed and pinned to a wall in a corridor that is not badge-controlled. Keeping the file to what duty, when, where means the copy on the mess noticeboard is neither a personal-data incident nor a clinical record, and the file can be shared with switchboard, the ED and the ward clerks without an information-governance conversation.
You can of course add a name column – it is an ordinary spreadsheet. Just be clear-eyed that the moment you do, the file becomes personal data, and where it is stored and who it is shared with stops being a matter of convenience.
Who Should Use This Template
It suits the registrar or consultant who has inherited the departmental rota; a small private hospital, day-surgery unit or standalone clinic with no e-rostering budget; a department whose on-call currently lives on a whiteboard or in a group chat; a medical staffing office that wants one visible year-at-a-glance page of committed cover; and anyone who has to publish a rota to people with no login to the official system.
It does not suit anyone who needs alerting, compliance checking, swap workflow, hours calculation or a system of record. If the rota has to be auditable, enforce rest rules or feed payroll, that is what e-rostering software is for.
Real-World Use Cases
A district general medical take. First on-call, second on-call, twilight cover and the handover round go in as four duty types. The Annual View makes next quarter’s uncovered weekends obvious in a glance rather than a spreadsheet audit.
A small private hospital. Anaesthesia, surgical registrar and ICU intensivist cover share one grid, theatre and ward locations spelled out, and switchboard holds a view-only link.
A non-resident standby rota. Home / Telephone Standby entries record the switchboard as the location, so anybody can see who is contactable off-site tonight without ringing round to find out.
Obstetrics and paediatrics. Labour Ward, Neonatal Unit and the Paediatric Assessment Unit each get their own duty type and location, and the Daily View prints as the handover sheet.
Crisis and liaison psychiatry. Psychiatry Crisis Cover blocks are published to the emergency department so referrers know when the duty psychiatrist is available.
Rota governance. The monthly rota review meeting is itself a calendar entry – the small trick that stops it being the meeting everybody forgets.
Advantages of the Doctor On-Call Calendar in Google Sheets
- One source of truth. Three views, one table. Nobody is reconciling a printed grid against a chat message.
- Everyone sees the same file at the same time. Share view-only with the department and edit with the rota-holder, and the version-control problem disappears.
- It costs $4.99 once. No per-user licence, no renewal, no procurement process.
- It is already populated. A hundred realistic duties across a full year means you can see how it behaves before deciding whether it fits, instead of staring at an empty grid.
- It does not expire. The year list runs to 2056 and every view is formula-driven.
- It carries no personal or clinical data, which makes it the rare healthcare-adjacent file that is safe to pin to a wall.
Opportunities for Improvement
Two limitations are worth knowing before you buy, and both are visible in the screenshots above.
Monthly View shows only the first duty on a date. It uses a VLOOKUP, so a date with two duties prints the first and adds a small “1 more…” note beneath it. In the sample this happens exactly twice – 05-May-2026 and 11-Oct-2026 – and you can see the note under the 11th in the October grid. The Daily View uses FILTER and lists all of them, so switch to Daily whenever a date is busy.
There is no end time or duration field. A duty carries a start time and nothing else, so the file cannot calculate shift length, hours worked, rest gaps or on-call intensity. If your rota conversation is about hours, those numbers have to come from elsewhere.
Add to those the things it never claims: no clash warning, no gap alert, no notifications, no compliance checking. Every entry in the file is typed by a human and the file believes whatever it is told.
Best Practices
- Keep duty names consistent. “General Medicine First On-Call” spelled the same way every time is what makes the Monthly grid scannable; a new wording each week turns it into noise.
- Use Location for how to reach the duty, not merely where it sits. “Doctors’ Mess – Bleep 101” and “Off-Site Standby – Switchboard” in the sample do exactly that.
- One editor. Share view-only with everybody and edit-access with the rota-holder alone. This is the difference between a rota and an argument.
- Check the Annual View after typing each month and look for unshaded weekdays before the month starts, not during it.
- Put standby and handover in too. A rota that only records night shifts hides half the commitment.
- Keep it beside the official rota, not instead of it. Where a formal system or switchboard record exists, that stays the authority.
- Leave names out unless you have a reason to add them – and if you add them, revisit who the file is shared with.
Explore Relevant Templates
The nursing twin of this file is the Nurse Duty Roster Calendar in Google Sheets, built on the same engine for ward shifts – the two run side by side well. The same engine tuned for other parts of the hospital gives the Operation Theatre Booking Calendar in Google Sheets for theatre lists, the Medical Appointment Calendar in Google Sheets for outpatient clinics, the Radiology Slot Booking Calendar in Google Sheets for scanner slots and the Patient Follow-Up Visit Calendar in Google Sheets for reviews.
If you need the doctor recorded against the duty, the Doctor Duty Roster Data Entry System in Excel is the form-driven Windows workbook that does exactly that, and the Healthcare Staff Duty Calendar in Excel is the desktop equivalent of this grid. Outside healthcare, the Employee Shift Schedule in Google Sheets covers general rostering. And when a spreadsheet genuinely is not enough any more – multiple users, permissions, an audit trail – the Hospital Management System Web App is the step up.
There is no Excel edition of this particular on-call calendar. This Google Sheets build is the one, and the Excel choices above are different products rather than a desktop twin of it.
Frequently Asked Questions
Is this a clinical system, a patient record or an EHR?
No. It is a scheduling spreadsheet with seven columns and no patient field of any kind. It holds no patient names, identifiers, diagnoses or clinical notes, and there is nowhere in it for them to go.
Will it bleep, page, text or email whoever is on call?
No. It sends nothing – no alerts, no notifications, no reminders – and it does not talk to your paging system or switchboard. It is a calendar people read.
Does it check working-time rules, rest periods or safe staffing?
No. There is no rule engine in it. It enforces no working-time regulation, no minimum rest period, no cap on consecutive nights, no safe-staffing ratio, no contract term and no credentialing requirement.
Can it replace our official rota or e-rostering system?
No. Where a formal rota or e-rostering system exists, that remains the authority on who is on call. Use this alongside it for visibility, never instead of it and never instead of your paging system.
Is it HIPAA or GDPR compliant?
No. It carries no certification, no access control beyond Google’s own sharing, no encryption you manage and no audit trail. As shipped it holds no personal data at all, which is the safest state for it; add names and your organisation’s information-governance rules apply from that moment.
Will it warn me about a clash or an uncovered night?
No. Two duties can sit on the same date and time without complaint, and no date is flagged for having no cover. The Annual View makes gaps visible; a person still has to look.
What happens when two duties fall on the same date?
Monthly View prints the first and adds a “1 more…” note; Daily View lists all of them. In the sample this happens on 05-May-2026 and 11-Oct-2026.
Does it work after 2026?
Yes. The sample year is 2026 but the Year dropdown runs 2021 to 2056 and every view is formula-driven, so it rolls forward without a rebuild.
Do I need a paid Google account?
No. A free personal Google account is enough, and the template itself is a one-time purchase.
Can several people use it at once?
Yes – that is the main reason to choose the Google Sheets edition. Share view-only with the department and edit-access with the rota-holder.
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.
Conclusion
An on-call rota does not need to be clever. It needs to be current, visible to everyone who acts on it, and honest about what is already covered and what is not. The Doctor On-Call Calendar in Google Sheets does those three things for $4.99 – one payment, no subscription, no per-user licence – and it does them without putting a single patient detail, or a single doctor’s name, into a spreadsheet that ends up on a noticeboard.
Open the PDF, click the copy link, and the calendar is in your own Google Drive in about two minutes. If the file does not open or copy correctly, get in touch for a replacement or a refund.
Last updated: 26 August 2026.
