Operation Theatre Booking Calendar in Excel

The Operation Theatre Booking Calendar in Excel is a 7-worksheet, macro-driven calendar workbook that ships with 100 pre-filled sample theatre bookings dated across the whole of 2026 – from 1 January to 30 December, with every one of the twelve months populated – spread across eight operating theatres: OT-1 General Surgery, OT-2 Orthopaedics, OT-3 Cardiac, OT-4 Neurosurgery, OT-5 Obstetrics & Gynae, OT-6 Ophthalmology, OT-7 ENT and OT-8 Day Care Surgery. Every record carries the same seven fields (ID, Date, Day, Event Name, Time, Location, Description), and the Annual, Monthly, Daily and This Month views all rebuild from that one Events sheet. Setup takes under 10 minutes. Operation Theatre Booking Calendar in Excel

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

⚠️ Please read this before you buy. This workbook is a scheduling calendar and nothing more. It is not a patient record, not an EHR or EMR, and not a theatre-management, perioperative or surgical information system. It is not HIPAA, GDPR or any other health-data-protection compliant or certified. It has no access control, no encryption and no audit trail; it does not secure anything you type into it. It takes no online bookings, sends no reminders, confirmations, SMS or email notifications, connects to no clinical, Operation Theatre Booking Calendar in Excel anaesthetic, consent, sterile-services, implant, insurance or billing system, and holds no consultant lists, staffing rotas, kit requirements or case notes. It makes no clinical or safety recommendation of any kind – it does not check theatre capacity, staffing levels, equipment availability or case suitability, and nothing in it should inform a clinical, consent or patient-safety decision. The workbook holds only what the owner types into their own copy of the file, and a spreadsheet that gets emailed around a hospital is not an appropriate place to store patient-identifiable information. Notably, the Events sheet has no patient name and no patient ID column at all – all 100 shipped sample records are written purely as procedure types, theatres, dates and times, and that is how it is meant to be used. Operation Theatre Booking Calendar in Excel

🔑 Key Features of the Operation Theatre Booking Calendar in Excel

• 📅 Four linked views from one bookings list. Annual View, Monthly View, Daily View and This Month all read the same Events sheet, so a case typed once appears everywhere. There is no second copy of the theatre list to keep in step.
• 🏥 Eight theatres already set up. The sample data runs OT-1 General Surgery (22 bookings), OT-2 Orthopaedics (13), OT-3 Cardiac (12), OT-4 Neurosurgery (12), OT-5 Obstetrics & Gynae (12), OT-6 Ophthalmology (12), OT-7 ENT (11) and OT-8 Day Care Surgery (6). Rename them to your own theatre numbers and every view follows.
• 🖱️ VBA record management. Add New Record, Update Record and Delete Record buttons sit above the Events table, an Add New Event button repeats on the Monthly and Daily views, and Monthly View adds a Show Events control while Daily View adds a refresh button. Operation Theatre Booking Calendar in Excel
• 📝 A six-field pop-up entry form with a date picker on Date and a clock picker on Time. It captures Event Name, Location and Description, fills Day automatically from the date you choose, and has Submit and Reset buttons. There is deliberately no patient field.
• 🗂️ 42 ready-written booking types across the 100 sample rows – elective lists such as Laparoscopic Cholecystectomy, Total Knee Replacement, Coronary Artery Bypass Graft and Cataract Surgery List, emergency slots such as Emergency Appendectomy and Emergency Evacuation – Haematoma, plus the non-surgical entries a real theatre diary carries: OT Deep Cleaning & Fumigation, Anaesthesia Machine Servicing, Instrument Sterilization Audit, OT Air Quality / HEPA Check and Surgical Team Briefing.
• 📊 A This Month summary that recalculates itself – Events This Month, Active Days, Locations Used and Next 7 Days, plus a weekday spread table and a Top 5 Locations ranking, over the month and year you pick.
• 🎨 Five colour themes and 31 selectable years on the Setting sheet – Default, Blue, Red, Black and Orange, any year from 2021 to 2051, a start month, a week-start day, two highlight-weekday rules and a highlight-events switch.
• 🖨️ Print areas already defined on the Home, Annual, Monthly, Daily, This Month and Events sheets, so a theatre list prints to a clean page without you fixing margins first.
• 🔒 Scheduling only, on purpose. No patient identifiers, no clinical fields, no claim of compliance – the design point of this calendar is that it is safe to pin on a theatre corridor wall. Operation Theatre Booking Calendar in Excel

📦 What’s Inside the Operation Theatre Booking Calendar in Excel

Seven worksheets, one .xlsm file, and a PDF user manual in the same download.

Sheet 1: Home Menu

A branded landing page with five large navigation buttons – Annual View, Monthly View, Daily View, This Month and Events. It is the sheet you leave open so anyone in the department can find the right view without hunting through tabs.

Sheet 2: Annual View

All twelve months of the selected year on one page in a three-across, four-down grid, with every date that carries a booking shaded. It answers the planning question – which weeks are already heavy, and where is there room for an extra list – in one glance, and prints on a single sheet.

Sheet 3: Monthly View

Pick a month and a year from the two grey selectors and the seven-column grid rebuilds, printing the booking name inside each date cell. Add New Event and Show Events buttons sit in the top-right corner. Where a date carries more than one case the cell shows the first booking and a “N more…” counter beneath it, so you always know a day is busier than it looks – open Daily View or This Month to read the rest.

Sheet 4: Daily View

Set a Start Date and an End Date and the table lists every booking in that window with its ID, Date, Day, Event Name, Time, Location and Description. Shipped set to 01-Jan-26 through 31-Jan-26, it returns January’s eight cases. Narrow it to a single date and you have tomorrow’s theatre run sheet; widen it to a week and you have the list for the Monday scheduling meeting.

Sheet 5: This Month Summary

Choose a month and year and four cards recalculate – Events This Month, Active Days, Locations Used and Next 7 Days. For the shipped August 2026 they read 9, 9, 8 and 2. Beneath them, an Events by Day of Week table splits the month across Sunday to Saturday (August 2026 runs 2, 2, 1, 1, 1, 0, 2 – Friday is the empty day), a Top 5 Locations table ranks the busiest theatres, and a full month table lists every booking with time, theatre and description.

Sheet 6: Events Database

The single source of truth – a seven-column table (ID, Date, Day, Event Name, Time, Location, Description) holding the 100 sample bookings on rows 5 to 104, with a filter already applied. Green Add New Record, purple Update Record and red Delete Record buttons sit above it. Delete the samples and type your own, or keep them as a worked example while you learn the file.

The entry form

Clicking Add New Record opens a pop-up form headed “Enter Data:” with Date (calendar picker), Day (filled automatically and shaded yellow), Event Name, Time (clock picker), Location and Description, plus Submit and Reset. Six fields, no patient field, no free-text clinical note field – the form itself keeps the file inside its intended scope.

Sheet 7: Setting

The control panel behind every view: Year (any year from 2021 to 2051), Start with Month, Week start with Day, two Highlight Day of Week rules, a Highlight Event switch and a Colour Theme selector offering Default, Blue, Red, Black and Orange. The file ships on the Black theme, January start, Sunday week-start and the year 2026.

📊 Operation Theatre Booking Calendar in Excel vs. a Google Sheets Calendar vs. Paid Theatre-Management Software

The honest summary: buy this if you want a visible, printable theatre diary that a scheduling co-ordinator owns and edits, and you want it working this afternoon. Buy the paid software if you need double-booking prevention, utilisation reporting, integration with the anaesthetic and consent record, and an audit trail – this calendar has none of those, and no spreadsheet does.

👥 Who This Template Is For – and Who It’s Not For

It is a good fit for:

• A theatre scheduling co-ordinator in a small or mid-sized hospital who currently keeps the list on a printed grid or a whiteboard.
• A day-surgery or single-speciality unit running two to eight theatres and wanting one visible diary for elective lists, emergency slots, deep cleans and servicing windows.
• A private surgical centre or clinic that wants a session planner it fully owns, with no subscription and no vendor account.
• A theatre manager who needs a month-on-a-page and a printable day sheet more than they need reporting.
• Anyone who has to hand a schedule to a team that lives in Excel and will not sign in to another platform.

It is the wrong tool if you need:

• Any storage of patient-identifiable data – it has no security of any kind and no patient field, and you should not add one.
• Double-booking prevention, capacity checks or staffing validation. Nothing here stops you scheduling two cases in one theatre at the same hour.
• Theatre utilisation, turnaround-time or on-the-day-cancellation reporting – the Events sheet stores a start time only, with no duration or end time.
• Several people editing at once, or live access from phones. Excel gives you one editor at a time; the Medical Appointment Calendar in Google Sheets is the shared-browser alternative.
• Automatic reminders, confirmations or list distribution – the workbook sends nothing.
• Mac, Excel for the web, Google Sheets or a mobile app. The macros need Excel for Windows on the desktop.

⚙️ How to Use the Operation Theatre Booking Calendar in Excel

1. Unzip and open in Excel for Windows. The download contains the .xlsm workbook and a PDF user manual. Keep the file saved as .xlsm – saving it as .xlsx silently strips every button.
2. Enable macros when the yellow security bar appears. Without them the Add, Update and Delete buttons and the pop-up form do nothing.
3. Open the Setting sheet and set your Year, Start with Month, Week start with Day and Colour Theme. Everything downstream redraws from those cells.
4. Rename the theatres. On the Events sheet, replace OT-1 General Surgery through OT-8 Day Care Surgery with your own theatre numbers and specialities. The Location column is plain text, so the summary tables pick up whatever you type.
5. Clear the sample bookings once you have looked at them – select rows 5 to 104 on Events and delete the rows, or overwrite them one at a time.
6. Add your own list with the green Add New Record button. Pick the date, pick the time, type the procedure name in Event Name, choose the theatre in Location, and add the list note in Description. Day fills itself in.
7. Use Monthly View for planning and Daily View for the run sheet. Where Monthly View shows “N more…” under a booking, that date carries additional cases – check Daily View or This Month for the full list.
8. Read This Month before the weekly meeting. Set the month and year, then look at Events This Month, Active Days, Locations Used and the Top 5 Locations ranking to see where the load is sitting.
9. Print from the defined print areas. Annual, Monthly, Daily, This Month and Events all have theirs set, so Ctrl+P produces the page you expect.
10. Keep patient details out. Book by procedure type, theatre, date and time, and keep names, hospital numbers and clinical notes in your governed clinical system.

💼 Real-World Use Cases

Meera, theatre scheduling co-ordinator at a 120-bed private hospital. She used to keep six theatre lists on a laminated wall grid and rewrite it every Friday. She now types the week into the Events sheet, prints Daily View for each day and pins Monthly View by the theatre reception. When a surgeon asks whether the third week of March is free, she opens Annual View and answers in seconds instead of walking to the board.

Dr Adeyemi, clinical lead of a four-theatre day-surgery unit. He wanted the unit’s non-surgical time visible, not just the operating lists. Deep cleans, HEPA checks, anaesthesia machine servicing and the Monday team briefing all sit in the same calendar as the cases, so when a slot looks empty he can see it is actually blocked for fumigation – which is exactly the mistake the old spreadsheet kept causing.

Sunita, practice manager at an independent surgical centre. She needed a session planner she owned outright, with no per-user licence and no vendor login for a team of five. She set the Setting sheet to her financial year, renamed the eight theatres down to her three, and prints the This Month summary for the monthly partners’ meeting to show how the load splits by weekday and by theatre.

❓ Frequently Asked Questions

Is the Operation Theatre Booking Calendar in Excel a patient record system, and is it HIPAA or GDPR compliant?

No. It is a scheduling calendar and nothing else. It is not a patient record, not an EHR or EMR, and not a theatre-management or surgical information system. It is not HIPAA, GDPR or any other health-data-protection compliant or certified, and it has no access control, no encryption and no audit trail. The Events sheet has no patient name or patient ID column at all, and none should be added – book by procedure type, theatre, date and time, and keep identifiable and clinical data in your governed clinical system.

Does it make any clinical or safety recommendation?

No. It holds no clinical data and produces no clinical output. It does not check theatre capacity, staffing levels, equipment or implant availability, anaesthetic cover, case suitability or patient fitness, and it will happily accept a booking that is clinically impossible. Nothing it displays should inform a clinical, consent or patient-safety decision. Operation Theatre Booking Calendar in Excel

Will it stop me double-booking a theatre?

No – and this is the limitation to understand before you buy. Nothing in the workbook validates that a theatre and time are free. If two records share a date, Monthly View shows the first one and an “N more…” counter, which is your signal to open Daily View or This Month and read the full day. Clash detection is exactly what paid theatre-management software gives you and a spreadsheet does not. Operation Theatre Booking Calendar in Excel

Can it report theatre utilisation or turnaround time?

No. The Events sheet records a start Time but has no duration or end-time field, so there is no basis for a utilisation percentage. The This Month summary counts bookings, active days, theatres used and the weekday spread – counts, not minutes.

Will it send reminders or list confirmations to surgeons or patients?

No. It takes no online bookings and sends nothing at all – no email, no SMS, no notifications. It is a file on a computer that you open, read and print.

Do I need macros, and does it work on Mac?

Yes to macros, and no to Mac. The Add New Record, Update Record and Delete Record buttons, the Add New Event buttons and the pop-up entry form are all VBA, so you need Excel for Windows on the desktop with macros enabled and the file kept as .xlsm. It will not run in Excel for the web, Excel for Mac, Google Sheets or a phone app. If you need a browser-based schedule, take the Google Sheets alternative instead. You can still read and hand-edit the Events sheet anywhere – only the buttons need Windows.

Can I use it for a year other than 2026?

Yes. The Setting sheet’s Year list runs from 2021 to 2051, and every view rebuilds from it. You can also change the start month, so a calendar running April-to-March works as well as January-to-December.

Can several people use it at the same time?

Not really. A macro-enabled workbook on a shared drive gives one editor at a time and read-only for everyone else. The practical pattern is one owner who edits and prints, and a shared read-only copy or a printed Daily View for the theatre team.

How long does setup take?

Under 10 minutes to get the sample file working the way you want, and about half an hour if you are typing a real month in. Set the Setting sheet, rename the eight theatres, clear rows 5 to 104 on Events, and start adding your own list.

👤 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

• Radiology Slot Booking Calendar in Excel – the same calendar engine built around imaging-room slots rather than theatre lists.
• Patient Follow-Up Visit Calendar in Excel – the outpatient review side of the pathway, after the surgery is done.
• Healthcare Staff Duty Calendar in Excel – who is on duty, alongside what is scheduled in theatre.
• Doctor Duty Roster Data Entry System in Excel – a searchable roster with a form and summary cards rather than a calendar grid.
• Dental Clinic Appointment Calendar in Excel and Physiotherapy Session Calendar in Excel – the same engine for chairside and rehab caseloads.
• Healthcare Administrator Toolkit – nine premium Excel templates for healthcare administration in one discounted bundle.
• Calendar & Planner Pack – twelve premium Excel and Google Sheets calendar templates at a bundle price.

Prefer a browser? The Medical Appointment Calendar in Google Sheets is the shared, multi-editor alternative. Browse the whole Calendar Templates range, or our wider MS Excel Templates library. Operation Theatre Booking Calendar in Excel

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

📅 Last updated: August 2026

Watch the demo video: