A six-tab Google Sheets retail dashboard with 16 KPI cards, 19 pivot-backed charts and 15 slicers covering sell-through, size curve, channel mix and returns.
Blog
Furniture Retail Dashboard in Google Sheets
A 6-page Furniture Retail Dashboard in Google Sheets with 18 pivot-backed charts, 15 slicers and an Order ID lookup covering order value, units, margin and lead time.
How to Summarize Data in Google Sheets: 5 Ways + a Bonus (Free Practice File)
Summarize data in Google Sheets step by step: SUMIFS and COUNTIFS with one or more conditions, SPARKLINE charts inside a cell, a pivot table in a few clicks, QUERY for a sorted summary table, plus the status bar for instant totals. Free practice file included.
IT Asset Management System Web App
IT Asset Management System Web App built on Google Apps Script: asset register, check-out and check-in, licence seats, contracts, tickets and depreciation across 25 screens and 7 roles, with a live demo.
Music Class Calendar in Google Sheets
A ready-to-use music class calendar in Google Sheets with annual, monthly and daily views, one Events register and 100 sample lessons for music schools and teachers.
Student Counselling Calendar in Google Sheets
A five-tab Google Sheets calendar for scheduling counselling sessions, workshops and parent meetings, with annual, monthly and daily views and 100 sample events. Scheduling only – no student identifiers, no case notes.
Transmission Repair KPI Scorecard in Google Sheets
A 10-KPI traffic-light scorecard for transmission repair shops in Google Sheets: repair quality, warranty, rework, bay and labor efficiency and order value KPIs, a KPI Trend page, setup steps and the known issues to fix first.
Oil Change Service KPI Scorecard in Google Sheets
The Oil Change Service KPI Scorecard in Google Sheets tracks 10 quick lube KPIs on one page with a month picker, MTD/YTD, Target/PY, traffic lights and a KPI Trend page.
Appliance Repair Business KPI Dashboard in Google Sheets
A 14-KPI Google Sheets scorecard for appliance repair businesses with a month picker, MTD and YTD traffic lights, prior-year comparison, KPI Trend charts and KPI Analysis.
Investment Portfolio Tracking System Web App
Investment Portfolio Tracking System Web App: a role-based Google Apps Script system with FIFO holdings, XIRR, time-weighted returns, rebalancing, client statements and 19 reports, with a live demo.