The Dental Services Dashboard in Google Sheets reports 16 KPI cards across 4 pages with 18 charts and 15 slicers – revenue, chair utilisation, insurance mix and lab costs from one appointment log.
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!
Fantasy Sports League Management System Web App: Run Every Money League From One Console
A Google Apps Script console for commissioners running paid fantasy leagues: eight leagues, per-league scoring rules, drafts, trades, waivers, entry fees, prize pool and payouts – with a live demo you can sign in to.
Lab Sample Collection Calendar in Google Sheets
A shared Google Sheets calendar for pathology labs and collection networks: three linked views, 100 sample rounds across 2026, 15 round types in 24 collection points, formula-driven with no macros. A scheduling calendar only – not a LIMS.
Ambulance Duty Calendar in Google Sheets
A formula-driven Google Sheets duty roster for ambulance stations: five tabs, three linked calendar views and 100 verified sample duties for 2026. No macros, no Apps Script.
Pest Control Business KPI Scorecard in Google Sheets
Track ten pest-control KPIs on one screen in Google Sheets – month picker, MTD/YTD against target or prior year, red/amber/green traffic lights, a KPI trend page and a written formula for every metric.
Septic Tank Service KPI Scorecard in Google Sheets
A month-picker scorecard that puts ten septic-service KPIs – pumping throughput, inspections, fleet, disposal cost, emergency response and revenue per job – on one Google Sheets screen with targets, arrows and traffic lights. Full walkthrough of all four pages, the December sample numbers, the known June/July month-label issue and its thirty-second fix.
Drywall Contractor KPI Dashboard in Google Sheets
Track 14 drywall contractor KPIs in Google Sheets with MTD and YTD achievement, prior-year comparison, traffic-light status and a single month dropdown.
Carpentry Workshop KPI Dashboard in Google Sheets
Track 15 carpentry KPIs in Google Sheets across Production, Materials, Quality, Delivery, Commercial and Safety – MTD and YTD, traffic lights, a month picker, a KPI Trend page and a KPI Analysis page, all worksheet formulas.
Supplement & Vitamin Tracker in Google Sheets
A Google Sheets supplement tracker with a 16-column log, a live Active Monthly Cost card, 4 charts and automatic Low Stock and Reorder flags at 14 and 7 days of supply.
Meal Prep & Batch Cooking Tracker in Google Sheets
A four-tab Google Sheets tracker for batch cooking: a 16-column log with four automatic columns, cost per serving, a Days Left countdown on every Use-By Date, one KPI card and four live charts.