A 10-KPI traffic-light scorecard for windshield repair and auto glass shops in Google Sheets: service mix, install quality, claims and revenue KPIs, a KPI Trend page, setup steps and the known issues to fix first.
Author: PK
Meet PK, the founder of NeotechNavigators.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your data analysis skills to the next level!
Generator Service KPI Scorecard in Google Sheets
Generator Service KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Junk Removal Services KPI Scorecard in Google Sheets
Junk Removal Services KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Moving Company KPI Dashboard in Google Sheets
A Google Sheets KPI dashboard for moving companies: 12 KPIs in six groups, MTD and YTD against target and prior year, traffic lights, a KPI Trend page and group analysis.
SaaS MRR & Churn Tracker in Google Sheets
A one-page SaaS MRR and Churn Tracker in Google Sheets: live Total Active MRR, Active Customers and Churn Rate cards, four charts, and a 16-column account log with automatic LTV, ARPU per seat, Health Score and Risk.
Domain & Website Portfolio Tracker in Google Sheets
The Domain and Website Portfolio Tracker in Google Sheets keeps every domain cost, revenue, visitor count, renewal date and ROI on one shareable page.
Commission & Custom Order Tracker in Google Sheets
A one-page Google Sheets tracker for commissioned and custom orders: 16 columns per job, a Total Order Value KPI card, four live charts, and automatic commission, profit, margin and due-date columns.
Footwear & Accessories Dashboard in Google Sheets
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.
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.