Productivity Calculator
All prices include VAT where applicable
🔒 You'll be taken to Gumroad.com to complete your purchase securely. Your Excel file will be delivered instantly to your email after payment.
| Compatibility | Windows & Mac |
| Version | 1.0 |
| File Size | 1.2 MB |
| Last Updated | June 2026 |
| Delivery | Instant digital download via email |
| Licence | Single user, lifetime access |
Description
The Productivity Calculator is an Excel-based daily output estimator covering nine core civil engineering activities: steel fixing, pipe laying, muck shift (bulk earthworks), formwork erection, concrete pouring, kerb laying, piling, road base construction and asphalt surfacing. For each activity, you enter the shift duration, gang size and a set of site-specific adjustment factors to produce a calculated daily output figure in the appropriate unit — kg/day for steel, m/day for pipes and kerbs, m³/day for earthworks and concrete, m²/day for road base and asphalt, or piles/day for piling.
Adjustment factors include site constraints (congested vs open), ground conditions (good, moderate, poor), equipment type and capacity, access restrictions, and regional productivity modifiers. Each factor applies a multiplier to the base output rate, so the final figure reflects realistic site conditions rather than textbook norms.
The calculator is designed for site agents, planners and quantity surveyors who need quick, defensible productivity estimates for programme planning, resource levelling and earned value reporting. Output figures can be used to validate subcontractor programmes, check tender allowances and support delay analysis.
Key Features
You Might Also Like
Project ManagementGantt Chart Project Planner
VBA-enabled Gantt chart with a 4-level WBS hierarchy (Phase, Sub-Phase, Task, Sub-Task), 5 switchable timescale views (daily, weekly, fortnightly, monthly, quarterly), dependency management (FS/SS/FF/SF with lag support), automatic critical path calculation with float values, baseline capture and comparison, a working days calendar with pre-loaded UK bank holidays and custom non-working days, resource loading histograms by owner, a dashboard with programme KPIs, phase progress, upcoming milestones, overdue task tracking and an S-curve, plus one-click A3 landscape PDF export.
Cost & Carbon CalculatorsCarbon Calculator for Construction
BS EN 15978 compliant whole-life carbon assessment tool covering modules A1–A5 (embodied) and B1–B7 (operational) with a pre-loaded ICE Database v3.0 and BEIS/DESNZ emission factor library, material inputs by construction phase with auto-populated carbon factors, a transport emissions schedule (Module A4) with default UK distances and overrides, a plant and equipment hours log (Module A5), an operational carbon sheet (B1–B7), a side-by-side design option comparison, industry benchmarks by asset type, and a dashboard showing total tCO₂e by lifecycle module and construction phase.
Daily OperationsDaily Diary Template
365-day macro-enabled site diary (.xlsm) with a dedicated sheet per day, weather AM/PM and temperature logging, visitor records, a 12-row workforce and activity log per date (subcontractor, trade, headcount, hours, delays, variations), consolidated All Diary Data view with hyperlinks, a filterable QS Search Dashboard with live KPIs (total hours, headcount, delay counts), and a Charts Dashboard for graphical workforce analysis.
Plant & EquipmentNEWFuel Usage Calculator
Plant fuel usage calculator with a 575+ item equipment database covering excavators, dumpers, telehandlers, generators, MEWPs and more — searchable by keyword, type and size range — with fuel consumption rates at 100%, 75%, 50% and 25% duty cycles plus idle, and a calculator that outputs litres per hour and total litres for any model at a selected duty and shift duration.