The Excavation Contractor KPI Dashboard in Google Sheets tracks 13 KPIs across 8 KPI groups, from Cubic Yards Moved and Equipment Utilization Rate to Bid Win Rate and Revenue per Job. Every KPI shows Month-to-Date and Year-to-Date Actual, Target, Achievement %, traffic-light Status and a Prior Year comparison. Pick a month from one dropdown and seven header cards, 26 status cells, a 12-month trend view and a group roll-up all recalculate from plain worksheet formulas.
This listing is the KPI Dashboard family: a month-picker scorecard with traffic lights plus KPI Trend and KPI Analysis pages. It is a different product from our analytical Google Sheets dashboards and from the Excavation Contractor KPI Scorecard in Google Sheets, which uses a separate layout.
🌍 Join teams in 40+ countries using NextGenTemplates to replace paid reporting tools with one-time-purchase spreadsheet templates.
✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access
🔑 Key Features of the Excavation Contractor KPI Dashboard in Google Sheets
📅 One month picker drives everything. The Select Month dropdown on the KPI Dashboard sheet sets the reporting month. The MTD block, the YTD block, the seven header cards and the KPI Analysis page all follow it, so the monthly review of an earthmoving business starts with a single click.
🚦 Traffic-light status on MTD and YTD. Each KPI reads On Target at 100% achievement or more, At Risk between 95% and 99%, and Missed below 95%. The vs PY column compares every KPI with the same month last year using an up or down arrow.
🔄 Upper-the-better and lower-the-better logic. Seven KPIs are UTB and six are LTB. For LTB metrics such as Machine Downtime Rate, Fuel Cost per Operating Hour and Rework Rate, achievement is Target ÷ Actual, so beating a cost target scores above 100%.
📊 Seven header cards. Total KPIs Tracked, On Target (YTD), At Risk (YTD), Missed (YTD), Improving vs PY (MTD), Avg Achievement (MTD) and Avg Achievement (YTD). The September 2025 sample reads 13, 6, 3, 4, 10 of 13, 98.7% and 98.1%.
🧩 An editable KPI master list. Add, rename or delete KPIs on the KPI Definition sheet and every other sheet follows. The workbook is wired for 22 KPI rows, with 13 filled in, so a new KPI needs no formula work.
⚡ No add-ons, no Apps Script. Every number is a worksheet formula, so there is nothing to authorise, no refresh button and no query to run. Make a copy and it simply opens.
📦 What’s Inside the Template
The sample KPIs are grouped as Production (Cubic Yards Moved, Cubic Yards per Labor Hour), Equipment (Equipment Utilization Rate, Machine Downtime Rate), Cost Efficiency (Fuel Cost per Operating Hour), Safety & Compliance (Total Recordable Incident Rate, Utility Strike Rate), Project Delivery (Project On-Time Completion, Budget Cost Variance), Business Development (Bid Win Rate), Quality (Rework Rate, Grade Accuracy) and Financial (Revenue per Job).
Home Page
The start screen summarises coverage (13 KPIs, MTD + YTD, formula-driven) and links to the three dashboard pages, the three input sheets and the reference sheets, with a three-step getting-started strip.
KPI Dashboard
The scorecard itself: the month dropdown, seven header cards and one row per KPI with MTD and YTD Actual, Target, Ach %, Status, Prior Yr and vs PY. A legend at the foot explains UTB, LTB and the status thresholds.
KPI Trend
Choose any KPI from a dropdown to see its group, unit, type, owner, priority, frequency, formula and definition, a 12-month MTD and YTD table, and two charts: MTD Actual, Target and PY by Month and YTD Actual, Target and PY by Month.
KPI Analysis
Performance by KPI Group (KPI count, On Target, At Risk, Missed, average MTD and YTD achievement), an Average YTD Achievement by KPI Group chart, and the Top 5 and Bottom 5 KPIs ranked on YTD achievement.
KPI Input – Actual
One of three input sheets (Actual, Target and Prior Year). Each holds an MTD and a YTD column for every month of the reporting year; cell E3 sets the first month and the whole workbook re-bases.
KPI Definition
The master list: KPI number, group, name, unit, formula, definition, UTB/LTB type, owner, priority and frequency. A Read Me sheet and a Get More Templates sheet complete the workbook.
📊 Google Sheets KPI Dashboard vs. Excel Dashboard vs. Construction Management Software: Where This Fits
| Feature | Excavation Contractor KPI Dashboard in Google Sheets | Excel KPI Dashboard | Construction management software (e.g. Procore, HCSS) |
|---|---|---|---|
| Cost | ✅ $8.99 one-time | One-time file price plus an Excel licence | Subscription, usually quote-based |
| Platform | ✅ Browser, free Google account | Microsoft Excel desktop | Vendor web and mobile apps |
| Setup time | ✅ Minutes: copy, set the month, type numbers | Minutes | Weeks of onboarding |
| Real-time team collaboration | ✅ Built into Google Sheets | Needs OneDrive or SharePoint | ✅ Yes |
| Mobile access | ✅ Google Sheets app | Excel mobile app | ✅ Yes |
| Customizable KPIs | ✅ Edit one master list, 22 rows | ✅ Yes | Limited to vendor reports |
| Share with a link | ✅ Yes | Via cloud storage | User seats required |
| Job costing, dispatch, field logs | No, management KPIs only | No | ✅ Yes |
| MTD and YTD traffic lights with prior year | ✅ Built in | Depends on the template | Custom report setup |
For excavation contractors who want a monthly management scorecard without buying seats in a full operations platform, this Google Sheets template sits in the sweet spot.
👥 Who This Template Is For, and Who It’s Not For
✅ This template is built for:
- Owners and general managers of small and mid-sized excavation and earthmoving companies running a monthly management review
- Operations, equipment and project controls leads who already collect production, machine-hour and cost figures
- Estimating managers who want bid win rate beside delivery and quality results
❌ This template is NOT for:
- Teams that need job costing, dispatch, telematics feeds or daily field logs, which this template does not provide
- Anyone looking for utility-locate, safety-compliance or incident-reporting software; the figures are typed in and the sample data is fictional
⚙️ How to Use the Template
- Open the PDF in your download and click the link to make your own copy of the sheet in Google Drive.
- On KPI Definition, rename, add or delete KPIs and set each one to UTB or LTB.
- Set cell E3 on KPI Input – Actual to the first month of your reporting year.
- Replace the sample MTD and YTD numbers on the Actual, Target and PY input sheets (the yellow cells).
- Pick a month on KPI Dashboard, then open KPI Trend and KPI Analysis for the detail.
💼 Real-World Use Cases
Dana owns a 40-person site-prep and excavation firm. Each month she types in yards moved, machine hours and job revenue, then opens the KPI Dashboard in the management meeting to see which KPIs slipped from On Target to At Risk, without building a report from scratch.
Luis manages a fleet of excavators and dozers. He uses KPI Trend on Equipment Utilization Rate and Machine Downtime Rate to show twelve months of results against target and last year when he argues for replacing an ageing machine.
Priya runs estimating and project controls. She watches Bid Win Rate and Budget Cost Variance in the Bottom 5 list on KPI Analysis and brings those two KPIs to the quarterly pricing review.
❓ Frequently Asked Questions
What KPIs does the Excavation Contractor KPI Dashboard in Google Sheets track?
It ships with 13 sample KPIs in 8 groups, including Cubic Yards Moved, Cubic Yards per Labor Hour, Equipment Utilization Rate, Machine Downtime Rate, Fuel Cost per Operating Hour, Utility Strike Rate, Project On-Time Completion, Bid Win Rate, Grade Accuracy and Revenue per Job. You can rename or replace any of them.
How long does setup take?
Making the copy takes a minute. Setting the reporting month and renaming KPIs takes a few more. The time that remains is typing your own monthly MTD and YTD figures into the three input sheets, after which every page recalculates automatically.
Is this the same as the Excavation Contractor KPI Scorecard in Google Sheets?
No. This is the KPI Dashboard family, with a month-picker scorecard, KPI Trend and KPI Analysis pages. The KPI Scorecard is a separately built product with its own layout. An Excel edition of this dashboard is in preparation.
How does this compare to Procore or HCSS?
Those platforms run field operations, costing and scheduling on a subscription. The Excavation Contractor KPI Dashboard in Google Sheets does none of that; it is a one-time $8.99 management scorecard for the numbers you already collect.
Can I change the On Target, At Risk and Missed thresholds?
Yes. The thresholds (100% and 95%) live in the Status formulas on the KPI Dashboard sheet, and the Read Me sheet explains where to edit them to match your own targets.
Does the template include real company data or compliance guidance?
No. All figures are fictional sample data, and the KPI definitions are editable examples. The template makes no safety, permitting, licensing or regulatory claim; you define how each KPI is measured.
👤 About the Author
Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience and founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.
🔗 Explore Related Templates
🏗️ Excavation Contractor KPI Scorecard in Google Sheets – the same trade in our separate KPI Scorecard format.
🛣️ Paving Contractor KPI Dashboard in Google Sheets – a month-picker scorecard for paving crews.
🏠 Roofing Contractor KPI Dashboard in Google Sheets and Electrical Contractor KPI Dashboard in Google Sheets for other trades.
🚜 Heavy Machinery Dashboard in Google Sheets – an analytical dashboard for equipment data.
🧱 Demolition Contractor Management System Web App – a job-management app for a neighbouring trade.
📂 Browse every Google Sheets KPI Dashboard. New to dropdowns in Sheets? Google’s guide to creating an in-cell dropdown list explains the control that drives this scorecard.
📖 Click here to read the Detailed Blog Post
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
Watch the step-by-step video Demo:
📅 Last updated: September 2026
