A 13-KPI Google Sheets scorecard for lawn care businesses with a month picker, MTD and YTD traffic lights, prior-year comparison, KPI Trend charts and KPI Analysis.
Blog
Private Equity Dashboard in Google Sheets
A six-page Private Equity Dashboard in Google Sheets with 500 sample deals, 16 charts, 15 slicers, IRR and MOIC views, a value creation bridge and a Deal ID search page.
School Inspection Calendar in Google Sheets
Plan a year of internal school inspections, walk-throughs and follow-up reviews in Google Sheets with Annual, Monthly and Daily views driven by one Events list.
Moving Company KPI Scorecard in Google Sheets
A walkthrough of the Moving Company KPI Scorecard in Google Sheets: 10 KPIs in 4 groups, a month picker with MTD/YTD and Target or PY comparison, traffic lights, a KPI Trend page, and the known limits of the current build.
Tree Care Services KPI Dashboard in Google Sheets
Track 13 tree care KPIs in Google Sheets with a month picker, MTD and YTD traffic lights, a KPI Trend page, a group roll-up and prior-year comparison.
Venture Capital Dashboard in Google Sheets
A six-page Venture Capital Dashboard in Google Sheets with 16 KPI cards, 18 chart panels and 15 slicers covering capital deployed, deal flow, portfolio composition, MOIC and IRR from a 1,000-row deal log.
Digital Product Sales Tracker in Google Sheets
A one-page digital product sales tracker in Google Sheets: 16 columns per product, a Total Net Revenue card, 4 charts and automatic net revenue after refunds and platform fees.
XLOOKUP in Google Sheets: 5 Real Use Cases (Step by Step, with Free Practice File)
A step-by-step XLOOKUP tutorial for Google Sheets: left lookups, killing #N/A without IFERROR, returning four columns from one formula, slab lookups with match_mode -1, latest-record lookups with search_mode -1, and a bonus two-way lookup. Free practice file included.
Advertising Agency Campaign Management System Web App
A module-by-module walkthrough of the Advertising Agency Campaign Management System web app – 32 modules, 7 role logins and 31 reports running on Google Apps Script, with a live demo and an honest list of what it does not do.
Sponsorship & Brand Deal Tracker in Google Sheets
Track every sponsorship in one Google Sheet: brand deal log, 5-stage pipeline, automatic balance due and payment status, deliverable progress, a Total Deal Value card and 4 live charts.