A formula-driven carbon footprint KPI dashboard in Google Sheets: 14 emissions KPIs, 12 months, MTD and YTD with traffic lights and prior-year comparison, all driven by one month dropdown. No add-ons, no scripts.
Blog
Architecture Firm Project Management System Web App
A working Google Apps Script web app that runs the commercial side of an architecture practice: 20 modules, 6 roles, a seven-stage fee schedule, timesheets, invoicing and a margin that is computed rather than typed. Includes a live demo you can sign into as any role.
Water Intake Tracker in Google Sheets
A full walkthrough of the Water Intake Tracker in Google Sheets – the one-page drink log, its four charts, the seven formula columns, and how to set it up in about five minutes. A logging and charting tool, not medical advice.
Calorie & Macro Tracker in Google Sheets
A one-page Calorie & Macro Tracker in Google Sheets: log food, servings, calories, protein, carbs, fat and fiber in a 16-column table while a Total Calories Logged card and four live charts redraw underneath. Logging tool only – not medical or nutritional advice.
Investor Relations Dashboard in Google Sheets
A six-page Investor Relations Dashboard in Google Sheets built on native pivot tables and 15 slicers. Track your shareholder register, share price, capital flows and IR meetings in one file – a reporting tool only, with demo data you replace with your own.
Diversity & Inclusion Dashboard in Google Sheets
A six-tab Google Sheets workbook that charts workforce representation, pay and inclusion-survey scores from 500 sample employee records using native pivot tables and 16 slicers. A reporting tool only – it charts what you enter and gives no HR or legal advice.
Solar Energy KPI Scorecard in Google Sheets
Review the Solar Energy KPI Scorecard in Google Sheets, a practical template for tracking solar production, availability, performance ratio, downtime, maintenance cost, revenue, and ROI.
Alarm Monitoring Service Management System Web App
A complete alarm monitoring and central station management system built on Google Apps Script and Google Sheets – live alarm monitor with SLA countdowns, keyholder calls, authority dispatch, a false alarm register with fines, contracts and recurring revenue, a one-pass monthly billing run, and the whole service side. Seeded with 60 customers, 85 sites, 85 panels and six months of history, with nine logins across seven roles and a live demo you can sign into now.
Environmental, Social, and Governance (ESG) Dashboard in Google Sheets
A six-page ESG tracking and reporting dashboard built on native Google Sheets pivot tables and slicers – Environment, Social and Governance each get their own page, plus a record lookup and a built-in user guide.
Innovation & Transformation Dashboard in Google Sheets
A six-tab Google Sheets dashboard that tracks 500 innovation initiatives, $61,049,000 of investment and $170,179,285 of projected benefit across a five-stage pipeline – built entirely on native pivot tables and slicers.