A tab-by-tab look at a Google Sheets scorecard for excavation firms: 10 KPIs in 6 groups, traffic lights, a month picker with MTD/YTD and Target/PY switches, a KPI Trend page, and the honest limits of the current build.
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!
Interior Fit-Out KPI Dashboard in Google Sheets
A month-picker KPI dashboard for interior fit-out contractors in Google Sheets: 14 KPIs in 4 groups, MTD and YTD traffic lights, a KPI Trend page and a KPI Analysis page.
Bathroom Remodeling KPI Dashboard in Google Sheets
A month-picker Google Sheets KPI dashboard for bathroom remodelers: 13 KPIs in four groups with MTD and YTD traffic lights, prior-year arrows, a twelve-month KPI Trend page and a KPI Analysis page.
Event Planning Management System Web App
An event planning management system built in Google Apps Script: 28 screens, 6 roles, vendor clash detection, staged payments, profit per event and 20 reports, deployed in your own Google account in about 15 minutes.
Podcast Episode Planning Tracker in Google Sheets
A one-page podcast episode planning tracker in Google Sheets: a 16-column episode log with 5 automatic columns, a Total Downloads card and 4 live charts that show what is in production and how each episode performed against its target.
YouTube Video Ideas & Upload Tracker in Google Sheets
A one-page YouTube video ideas upload tracker in Google Sheets: 16 columns, 4 automatic, a six-stage pipeline, Readiness flags, four live charts and a Total Estimated Views card.
Tax Advisory Dashboard in Google Sheets
A six-page Google Sheets dashboard for tax advisory practices: 500 sample engagements, 4 KPI cards, 18 chart panels and 15 filter chips covering advisory fees, filing status, notices, refunds and hours – with a clear note that it is not tax software and gives no tax advice.
Accounting Firms Dashboard in Google Sheets
A six-page Google Sheets dashboard for accounting and CPA practices: 500 sample engagements, 16 KPI cards, 17 chart panels and 15 slicers covering fees, realization, write-offs, WIP and client mix – with an honest note on what it is not.
Free One Page Sales Dashboard in Google Sheets – Step by Step
Build a free one page sales dashboard in Google Sheets: 4 KPI cards ($90,991 revenue, $32,796 profit, 120 orders, 36.0% margin), a monthly revenue vs profit combo chart and a region slicer – step by step with a video and free template.
Parent-Teacher Meeting Calendar in Google Sheets
A four-view Google Sheets calendar for planning school parent meetings: 100 demo records across 2026, with Annual, Monthly, Daily and Events sheets driven by one editable list. Planning only – it sends no invitations or reminders.