The Health Checkup Package Calendar in Excel is a macro-enabled workbook of 7 sheets that turns one table of bookings into four synchronised calendar views. It ships with exactly 100 sample bookings, IDs 1 to 100, running from 2 January to 20 December 2026, covering 31 named checkup packages and awareness camps across 8 venues at 6 fixed start times between 08:00 and 11:00. Every one of the 100 stored weekday values was checked against its date, and all 100 agree.
Most diagnostic centres, corporate CSR teams and community health programmes plan their screening year in a shared document that nobody trusts by March. Somebody edits the January grid, somebody else edits the master list, and the two drift apart. This calendar solves that narrow problem: there is exactly one place a booking lives, and everything else is a view of it. It also solves a quieter problem, which is that a scheduling file circulated by email should not contain patient information — and this one cannot, because no field for it exists.
Key Features of the Health Checkup Package Calendar in Excel
- One table, four views. Annual View, Monthly View, Daily View and This Month all read the Events sheet. A camp entered once appears in all four.
- 100 sample bookings across all twelve months. The 2026 distribution is 9 / 8 / 8 / 9 / 8 / 8 / 8 / 9 / 8 / 8 / 9 / 8 from January to December — no empty month to mislead you about how the views behave.
- 31 package and camp types. Routine packages such as Basic Preventive Health Package, Executive Full Body Checkup, Diabetes Care Screening Package and Thyroid Function Screening Package sit alongside eleven single-date awareness drives including World Cancer Day Screening Camp, No Tobacco Day Lung Health Screening and World Diabetes Day Sugar Screening.
- 8 venues, with a real spread. Metro Diagnostic Centre carries 28 of the 100 bookings, Community Wellness Centre 17, Corporate Health Camp 14, City Health Clinic and Senior Care Centre 10 each, and Cardiac Care Centre, Women’s Health Clinic and Rural Screening Drive 7 each.
- Form-driven entry. Add New Record, Update Record and Delete Record buttons open a VBA form with six inputs. The Day field derives itself from the date, so a typo cannot put a Tuesday camp on a Friday row.
- A Setting sheet that re-skins everything. Year 2021 to 2051, any starting month, any week-start day, two highlightable days of the week, event highlighting on or off, and 5 colour themes — Default, Blue, Red, Black, Orange. The file ships on Red.
- No patient data field anywhere. Seven columns: ID, Date, Day, Event Name, Time, Location, Description. That is the whole schema.
Sheets Explanation
Home
A launcher with five buttons — Annual View, Monthly View, Daily View, This Month and Events — and a house icon on every other sheet to get back. It exists so the workbook can be handed to front-desk staff without training.
Annual View
Twelve month grids in a 3-across, 4-down layout for the selected year, built from 197 formulas. Booking dates are shaded, and the two chosen weekdays are shaded separately. In the shipped 2026 file, 1 January correctly falls on a Thursday and every month grid starts on the right weekday.
Monthly View
One month in a Sunday-to-Saturday grid with the package name written inside each date cell. January 2026 ships with nine bookings — Basic Preventive on the 2nd, Executive Full Body on the 5th, Senior Citizen Wellness on the 8th, Diabetes Care on the 11th, Heart Health Cardiac on the 14th, Women’s Wellness on the 17th, Corporate Health Camp Registration on the 20th, Thyroid Function on the 23rd and Full Body Master on the 26th. Month and Year selectors sit above the grid with Add New Event and Show Events buttons.
Daily View
Set a Start Date and an End Date and the sheet lists every booking in that window with its ID, Date, Day, Event Name, Time, Location and Description. It ships set to 2 January to 1 February 2026 and returns nine rows. A refresh button and an Add New Event button sit beside the date pickers.
This Month
Four summary tiles — Events This Month, Active Days, Locations Used, Next 7 Days — over an Events by Day of Week table, a Top 5 Locations table and the full month listing. September 2026 reads 8 events, 8 active days, 7 locations used and 3 in the next seven days, and the day-of-week rows sum to the same 8.
Events
The single source of truth: 100 rows under ID, Date, Day, Event Name, Time, Location and Description, with Add New Record, Update Record and Delete Record buttons above them. Nothing else in the workbook stores a booking, so there is nothing to reconcile.
The entry form and the Setting sheet
The VBA form carries Date, Day, Event Name, Time, Location and Description boxes with Submit and Reset. The Day box fills itself — pick 1 September 2026 and it writes Tuesday. The Setting sheet behind it holds the year list (2021-2051), the starting month, the week-start day, two highlight-day pickers, the event-highlight switch and the 5 colour themes.
Health Checkup Package Calendar in Excel vs. the Google Sheets Edition vs. Paid Clinic SaaS — Feature Comparison
| Feature | Health Checkup Package Calendar in Excel | Google Sheets Edition | Athenahealth / Kareo |
|---|---|---|---|
| Cost | $4.99 one-time ✅ | $4.99 one-time | $140-$700 / provider / month |
| Platform | Excel for Windows desktop | Any browser | Cloud only |
| Setup time | Under 10 minutes ✅ | Under 10 minutes ✅ | Weeks, with onboarding |
| Works fully offline | Yes ✅ | No | No |
| Real-time team collaboration | No — one editor at a time | Yes ✅ | Yes ✅ |
| Mobile access | Read-only; macros do not run | Yes ✅ | Yes ✅ |
| Stores patient records | No — no patient field exists ✅ | No — no patient field exists | Yes, and that is what you pay for |
| Customisable fields and colours | Yes — 5 themes ✅ | Yes ✅ | Vendor options only |
| Year-1 cost for a 5-person front desk | $4.99 total ✅ | $4.99 total ✅ | $8,400+ |
For a clinic, diagnostic lab or CSR team that needs to publish and track a screening-camp schedule without buying a practice-management system, the Health Checkup Package Calendar in Excel sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Diagnostic centres and polyclinics publishing a rolling calendar of packages and camps
- Corporate HR and CSR teams planning employee health camps across a financial year
- Community health programmes and NGOs running screening drives and awareness-day events
- Front-desk staff who want a printable month grid without learning new software
- Excel users on Windows who want something working today rather than a trial signup
Not a fit if:
- You need an EHR, EMR or practice-management system — this stores no patient data at all
- Several people must edit the same calendar at once; an .xlsm file is single-editor
- You work on a Mac, in Excel Online, or on mobile only — the macros need Excel for Windows desktop
- You need automatic reminders, SMS or email notifications; the workbook sends nothing
- You need a HIPAA, GDPR or NABH compliance certificate from your scheduling tool
Real-World Use Cases
Priya manages a three-branch diagnostic chain. The year’s package calendar lives in this workbook. She switches Monthly View month by month to print the grid for each branch noticeboard, and reads the Top 5 Locations table on This Month to see which centre is carrying the load — without paying per provider for a practice-management suite.
Rahul runs CSR at a 900-person manufacturing firm. He plans twelve on-site camps a year, tags them all to the Corporate Health Camp location, and uses Daily View to pull the next quarter into a leadership slide. Because the file holds no employee names, he forwards it to plant managers without a data-protection conversation.
Dr. Anita coordinates a community screening NGO. She schedules awareness-day drives beside routine rural van visits and uses the Annual View shading to spot the empty weeks where another camp would fit.
Advantages of the Health Checkup Package Calendar in Excel
The cost case is straightforward: $4.99 once against $140 or more per provider per month for a cloud practice suite, which is roughly $8,400 in year one for a five-person front desk. But the more useful advantage is the single-table design. Because Annual, Monthly, Daily and This Month are all derived from the Events sheet, there is no version of this workbook where the month grid and the master list disagree.
The privacy position is the second advantage, and it is structural rather than promised. A scheduling file that gets emailed around a hospital is a real exposure risk when it holds names and diagnoses. This one holds neither, because the columns for them were never created. None of the 100 sample rows names a person; the descriptions describe what a package contains, not who attended it.
Third, it works offline. A rural screening drive with no connectivity can still open the file on a laptop, and Excel’s own print and page-setup tools handle the noticeboard copy.
Opportunities for Improvement
Being straight about what this file does not do is more useful than a longer feature list:
- No duration or end-time field. Each booking has a start time only, so room or slot utilisation cannot be calculated from the data.
- Monthly View shows one booking per date. If a date carries several, the cell prints the first plus an “N more…” counter. All 100 sample dates are distinct, so that counter never fires until you double-book a date yourself — worth knowing before you assume the grid shows everything.
- Nothing prevents a double booking. The workbook will happily accept two camps at the same venue at the same time.
- The location panel is a labelled Top 5. On This Month, September shows 7 in Locations Used but only 5 rows in the table. The label is honest, but the two numbers can look contradictory at a glance.
- Macros are genuinely load-bearing. The Daily View and This Month sheets contain zero formulas — they are written by VBA. Open the file with macros disabled and those two sheets simply do not populate.
- No reminders, capacities, costs or attendee counts. This is a calendar, not a booking engine.
Best Practices
Set the Setting sheet before you enter anything — changing the year afterwards is fine, but starting from your own year avoids confusion. Use the Add New Record form rather than typing into the Events grid, so the Day column stays derived rather than guessed. Keep event names short: Monthly View has one line per date cell and long names get clipped. If you need to record who attended a camp, keep that in your own validated system and reference this calendar by the booking ID — do not add a name column here. And if two people need to edit at once, move to the browser edition rather than emailing copies around.
Explore Relevant Templates
Also available as: Health Checkup Package Calendar in Google Sheets — the same calendar for teams that need link sharing and simultaneous editing instead of macros.
Related calendars on the same four-view engine: Blood Donation Camp Calendar in Excel for donor drives, Lab Sample Collection Calendar in Excel for collection rounds, Dental Clinic Appointment Calendar in Excel, Patient Follow-Up Visit Calendar in Excel and Home Nursing Visit Calendar in Excel. For equipment rather than people, see Medical Equipment Calibration Calendar in Excel.
We have written up several of these calendars in detail on this blog. The closest read is our walkthrough of the Lab Sample Collection Calendar in Excel, which uses the same Annual / Monthly / Daily / This Month engine for collection rounds. For the visit-based variant see the Home Nursing Visit Calendar in Excel, for shift-shaped scheduling the Ambulance Duty Calendar in Excel, and for an appointment-desk example outside healthcare the Optical Store Appointment Calendar in Excel. Equipment schedules follow the same pattern in the Medical Equipment Calibration Calendar in Excel.
Frequently Asked Questions
Does the Health Checkup Package Calendar in Excel store patient data?
No. The Events sheet has exactly seven columns — ID, Date, Day, Event Name, Time, Location, Description — and the entry form has six inputs. There is no patient name, patient ID, MRN, date of birth, diagnosis, phone, email or address field anywhere, and none of the 100 sample rows names a person.
Is this an EHR, EMR or practice-management system?
No. The Health Checkup Package Calendar in Excel is a scheduling calendar only. It holds no clinical records, does not book individual patients, does not bill, integrates with no health information system, and makes no clinical, diagnostic or screening-interval recommendation.
Is it HIPAA or GDPR compliant?
No, and no such claim is made. An unencrypted local workbook is not appropriate storage for protected health information. Because the Health Checkup Package Calendar in Excel stores no personal data by design the question largely does not arise, but compliance for anything you add remains your responsibility.
Do I need to enable macros, and does it work on a Mac?
Yes to macros, no to Mac. The Daily View and This Month sheets contain no formulas and are written entirely by VBA, and the Add, Update and Delete buttons are macros. The Health Checkup Package Calendar in Excel requires Excel for Windows desktop.
How long does setup take?
Under 10 minutes. Open the file, enable macros, set your year and colour theme on the Setting sheet, then replace the 100 sample bookings using the Add New Record form. All four views refresh from that one Events table.
How does this compare to Athenahealth or Kareo?
It does far less, for $4.99 once instead of $140 or more per provider per month. Those are patient record and billing platforms. The Health Checkup Package Calendar in Excel answers only “what camp is running, where and when” — which is all many diagnostic centres and CSR teams need.
What is included in the download?
A single ZIP containing the macro-enabled .xlsm workbook and an Excel Calendar user manual PDF. There is no separate data file to wire up — the 100 sample bookings are already inside the workbook’s Events sheet.
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
If your screening calendar currently lives in three files that disagree with each other, the fix is not a bigger system — it is one table with four honest views over it. The Health Checkup Package Calendar in Excel gives you that for the price of a coffee, works offline, prints cleanly, and cannot leak patient information because it was never built to hold any.
👉 Click here to Purchase the Health Checkup Package Calendar in Excel
Instant download · One-time payment · No subscription
🎥 For step-by-step Excel and VBA tutorials, visit Youtube.com/@PK-AnExcelExpert
Last updated: September 2026
