Track 13 concrete KPIs on one page – MTD and YTD achievement, traffic lights, twelve-month trends and vs prior year. Formula-driven Google Sheets, no add-ons, no subscription.
Google Sheets
Insulation Contractor KPI Dashboard in Google Sheets
A formula-driven Google Sheets KPI dashboard for insulation contractors: 14 trade KPIs, a month picker, MTD and YTD traffic lights, a twelve-month trend page and a KPI group roll-up.
Locksmith Business KPI Scorecard in Google Sheets
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.
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.