Track ten pool service KPIs on one screen in Google Sheets – month picker, red/amber/green traffic lights, MTD and YTD against target and prior year, a KPI trend page and written formulas for every metric.
Blog
Fencing Contractor KPI Scorecard in Google Sheets
Ten fencing KPIs on one Google Sheets page – month picker, MTD/YTD switch, direction-aware traffic lights, 12-month sparklines and a KPI trend page. A tab-by-tab walkthrough of what the scorecard does, what it does not do, and how it differs from the Excel edition.
Paving Contractor KPI Scorecard in Google Sheets
Track ten paving contractor 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.
Electrical Supplies Distributor Management System Web App
A complete Google Apps Script trading system for electrical wholesalers: 24 screens, 18 reports, 6 roles and 41 permissions, multi-warehouse stock, price-list slab discounts and an ageing receivables book – with a free live demo you can sign into as every role.
Welding Shop KPI Dashboard in Google Sheets
The Welding Shop KPI Dashboard in Google Sheets tracks 15 fabrication KPIs across 5 groups with MTD and YTD achievement, editable traffic lights, a month picker, a KPI Trend page and a KPI Analysis page – all plain worksheet formulas, no add-ons.
Masonry Contractor KPI Dashboard in Google Sheets
A formula-driven Google Sheets scorecard for masonry firms: 15 KPIs in 5 groups, MTD and YTD side by side, a month dropdown, traffic lights, and dedicated KPI Trend and KPI Analysis pages.
Intermittent Fasting Tracker in Google Sheets
A one-page Google Sheets fasting log: type Fast Start and Fast End and it returns fasting hours across midnight, the eating window, % of your own target and a Yes/Close/Short verdict, plus four live charts. A personal record – not medical advice, and it sends no reminders.
Debt Collection Agency Management System Web App
A Google Apps Script web app for collection agencies – 38 screens, 8 server-enforced roles, 36 tables and 28 reports, from creditor placement through activity, promises, plans and settlements to a client remittance statement that must reconcile. Live demo with every login published.
Meditation & Mindfulness Tracker in Google Sheets
A four-tab Google Sheets meditation log: 16 columns with seven that calculate themselves, a Total Minutes Meditated card, an honest streak counter, Mood Lift, Calm Index and four live charts. 985 pre-built rows, $6.99 once, no subscription.
Call Center Operations Dashboard in Google Sheets
A six-page Google Sheets dashboard for contact centres: calls, handle time, first call resolution, CSAT, wait and abandonment by queue, team, channel and shift, plus a Call ID lookup. Offline analysis – paste your own export.