A walkthrough of the Locksmith Business KPI Scorecard in Google Sheets: 10 trade KPIs across 5 groups, MTD/YTD toggles, direction-aware traffic lights, a per-KPI trend page, and the two build defects we found when we opened the workbook.
Blog
Optical Store Appointment Calendar in Google Sheets
A formula-driven optical store appointment calendar in Google Sheets: 6 tabs, Annual, Monthly and Daily views, 100 verified sample bookings, 18 appointment types and 18 rooms – and no customer or prescription column, by design.
Fertility & Ovulation Tracker in Google Sheets
A one-page Fertility & Ovulation Tracker in Google Sheets: 14 columns, 5 of them calculated, a Fertile Days Logged card and a BBT curve. A personal record-keeping template – not a medical device, not contraception and not medical advice.
Period & Cycle Tracker in Google Sheets
A Google Sheets period and cycle log: one cycle per row across 16 columns, seven of them calculated, with an average cycle length card and four charts. A personal record-keeping template – not a medical device and not medical advice.
Physiotherapy & Rehabilitation Dashboard in Google Sheets
A six-page Google Sheets reporting dashboard for physiotherapy and rehabilitation clinics – sessions, revenue, recovery rate and satisfaction by clinician, treatment line, condition and clinic site. Not an EHR, no live link to a practice system.
Dental Services Dashboard in Google Sheets
The Dental Services Dashboard in Google Sheets reports 16 KPI cards across 4 pages with 18 charts and 15 slicers – revenue, chair utilisation, insurance mix and lab costs from one appointment log.
Fantasy Sports League Management System Web App: Run Every Money League From One Console
A Google Apps Script console for commissioners running paid fantasy leagues: eight leagues, per-league scoring rules, drafts, trades, waivers, entry fees, prize pool and payouts – with a live demo you can sign in to.
Lab Sample Collection Calendar in Google Sheets
A shared Google Sheets calendar for pathology labs and collection networks: three linked views, 100 sample rounds across 2026, 15 round types in 24 collection points, formula-driven with no macros. A scheduling calendar only – not a LIMS.
Ambulance Duty Calendar in Google Sheets
A formula-driven Google Sheets duty roster for ambulance stations: five tabs, three linked calendar views and 100 verified sample duties for 2026. No macros, no Apps Script.
Pest Control Business KPI Scorecard in Google Sheets
Track ten pest-control KPIs on one screen in Google Sheets – month picker, MTD/YTD against target or prior year, red/amber/green traffic lights, a KPI trend page and a written formula for every metric.