Aggregate Import Tracker
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 Aggregate Import Tracker is an Excel-based delivery log for construction sites receiving bulk aggregate materials. Each delivery is recorded with date, supplier, material type, tonnage, weighbridge ticket reference and whether the material is recycled or virgin — enabling automatic CO₂e emissions calculations that distinguish between lower-carbon recycled aggregates and higher-carbon virgin materials.
Supplier performance summaries aggregate delivery data by supplier, showing total tonnage delivered, number of loads, average load size and reliability metrics. Monthly breakdowns present tonnage and carbon data side by side so project teams can report on both material usage and environmental impact in a single view.
The live dashboard surfaces programme-to-date KPIs including total tonnage received, recycled material share as a percentage, carbon intensity per tonne, cumulative CO₂e, and top supplier analysis by volume. The tracker is designed for site engineers, materials managers and environmental coordinators who need accurate delivery records for cost reporting, carbon reduction plans and SWMP compliance.
Key Features
You Might Also Like
Inspection & TestingExcavation Inspection Register
VBA-powered excavation inspection and compliance management system with an excavation register (5 types: trench, pit, shaft, bulk dig, confined space), a 75-question type-specific inspection form (15 questions per excavation type) with auto-populated details, automatic depth-band risk escalation (Standard/Enhanced/High/Critical) with mandatory controls and reference standards (HSG185, BS 6031, BS 5975, CDM 2015, CS Regs 1997), RAG inspection outcomes (Pass/Conditional Pass/Fail), a timestamped inspection register with locked rows, a dashboard with excavation and inspection KPIs plus depth band breakdowns, and one-click PDF export in A4 and A3 formats.
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.
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.
Concrete & MaterialsConcrete Pour Register
Full concrete pour register and cube test record with BS EN 13670 compliant formwork strike analysis — featuring dynamic strike planning by mix, pour type and temperature band, UKAS-method strength gain curves with confidence envelopes, a programme dashboard with RAG status and pass rates, and configurable concrete mixes (OPC, PFA and GGBS blends).