A formula-driven Google Sheets scorecard for masonry firms: 15 KPIs in 5 groups, MTD and YTD side by side, a month dropdown, traffic lights, and dedicated KPI Trend and KPI Analysis pages.
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!
Intermittent Fasting Tracker in Google Sheets
A one-page Google Sheets fasting log: type Fast Start and Fast End and it returns fasting hours across midnight, the eating window, % of your own target and a Yes/Close/Short verdict, plus four live charts. A personal record – not medical advice, and it sends no reminders.
Debt Collection Agency Management System Web App
A Google Apps Script web app for collection agencies – 38 screens, 8 server-enforced roles, 36 tables and 28 reports, from creditor placement through activity, promises, plans and settlements to a client remittance statement that must reconcile. Live demo with every login published.
Meditation & Mindfulness Tracker in Google Sheets
A four-tab Google Sheets meditation log: 16 columns with seven that calculate themselves, a Total Minutes Meditated card, an honest streak counter, Mood Lift, Calm Index and four live charts. 985 pre-built rows, $6.99 once, no subscription.
Call Center Operations Dashboard in Google Sheets
A six-page Google Sheets dashboard for contact centres: calls, handle time, first call resolution, CSAT, wait and abandonment by queue, team, channel and shift, plus a Call ID lookup. Offline analysis – paste your own export.
Payroll Management Dashboard in Google Sheets
The Payroll Management Dashboard in Google Sheets turns a 500-row pay register into six tabs, 16 KPI cards, 21 charts and 15 slicers – a pivot-and-slicer reporting layer over the payroll system you already run. Reporting only: it does not calculate pay or file any statutory tax.
Medical Equipment Calibration Calendar in Google Sheets
A shared Google Sheets calendar for medical equipment calibration and preventive maintenance: six tabs, Annual, Monthly and Daily views over one 100-row table, and a clear account of what a spreadsheet can and cannot do in a regulated department.
Dialysis Session Calendar in Google Sheets
The Dialysis Session Calendar in Google Sheets is a ready-to-copy scheduling workbook with six tabs, three linked calendar views and 100 sample entries loaded across 2026, covering 20 session and unit-task labels in 25 named chairs, bays and rooms. It is a scheduling spreadsheet only – not a patient record, not an EHR/EMR and not a dialysis management system – and it stores no patient identifiers at all.
Concrete Contractor KPI Scorecard in Google Sheets
Track ten concrete contractor KPIs on one screen in Google Sheets – month picker, red/amber/green traffic lights, MTD and YTD against target and prior year, plus a KPI trend page and written formulas for every metric.
Insulation Contractor KPI Scorecard in Google Sheets
Track ten insulation KPIs – board feet per crew day, foam yield variance, blower door first-pass rate, callback rate, gross margin and more – on one page in Google Sheets, with MTD/YTD traffic lights scored against your own targets.