WWTW Long Lead Item 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 WwTW Long Lead Item Tracker is an Excel-based procurement management tool designed for wastewater treatment works projects with significant MEICA (Mechanical, Electrical, Instrumentation, Control and Automation) and ICA equipment packages. The full item register tracks each piece of equipment from initial enquiry through purchase order, manufacture, factory acceptance testing, delivery and installation, giving the project team complete visibility of procurement status at every stage.
A linked supplier register stores contact details, QA certification status and performance history for each vendor, and an issues and risks log captures procurement problems, mitigation actions and responsible owners against specific items or suppliers. Issues are cross-referenced to the item register so the impact of any delay or quality concern is immediately visible.
The dashboard surfaces critical procurement KPIs including items due in 2-week, 4-week and 8-week lookahead windows, late delivery counts, total purchase order value, factory acceptance test pass rates and average lead times by equipment category. The tracker is designed for project managers, procurement leads and commissioning engineers on AMP-framework and capital delivery wastewater projects.
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.
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.
Wastewater & UtilitiesPump Maintenance Tracker
Pump maintenance planner with a pump register recording area, asset tag, duty status, manufacturer, model, commission date, criticality, pump type and runtime hours β linked to a configurable task library with calendar-based and runtime-based maintenance triggers, a printable weekly maintenance schedule (filterable by area and week), and a dashboard showing total pumps, tasks due this week, due-now and due-soon counts.
Daily OperationsNEWAllocation Sheet
VBA-enabled daily labour and plant record with hours allocated against up to 10 numbered site operations, materials delivered, weather conditions and client sign-off blocks β plus one-click PDF email distribution to your team and a Create New Day macro that archives the current sheet and generates tomorrow's blank with all header info carried forward.