Nine Excel templates covering the full project controls cycle: programme, earned value, cost forecasting, changes and reporting. Built by the quantity surveyors and planners behind Gather. Direct download, no form to fill in.
Project controls is the set of disciplines that keep a construction project's cost, time and scope aligned to a baseline throughout delivery, covering programme monitoring, cost and earned value reporting, change management and progress reporting so deviations are caught while they are still recoverable.
Plot planned vs actual progress as a classic S curve from your programme data.
PlanningView templateWork out CPI, SPI, EAC and ETC from your cost and progress data.
Earned valueView templateTurn daily diary entries into a weekly progress report against programme.
Site diaryView templateForecast the cost to finish from actuals to date and remaining scope.
Earned valueView templateA short interval programme with constraints and predecessor tracking built in.
PlanningView templateTrack every request for information with response deadlines and programme impact.
RegistersView templateLog and value instructed changes (NEC4) and variations (JCT) as they happen.
CommercialView templateTrack every NEC4 compensation event from notification to implementation, with the 8 week time bar calculated automatically.
NEC4View templateA single page rollup of programme, cost and risk status for the weekly project meeting.
ReportingView template| Template | Core fields | Best for |
|---|---|---|
| S Curve | Planned vs actual value, cumulative % complete, variance | Programme reporting, board packs |
| EVM Calculator | PV, EV, AC, CPI, SPI, EAC, ETC | Monthly cost and schedule performance review |
| Progress Report | Weekly activities, % complete by area, programme variance | Client-facing weekly reporting |
| Cost to Complete | Actuals to date, remaining scope, forecast final cost | Monthly CVR and forecasting |
| Lookahead Planner | 2/4/6 week activities, constraints, predecessors | Site delivery planning meetings |
| RFI / TQ Register | Reference, description, date raised, response due, programme impact | Design query tracking |
| Variation Tracker | Reference, description, value, status, approval date | Instructed change and variation control |
| CE Log | Clause 60.1 trigger, notification date, 8 week time bar, quotation status | NEC4 commercial management |
| Project Dashboard | Programme status, cost status, top risks, key actions | Weekly project team meeting |
Most of these templates fail the same way once a project gets busy: the S curve is only as current as the last time someone updated it by hand, the CE log only shows events someone remembered to notify, and none of them talk to each other, so the dashboard is a manual roll up built from five other spreadsheets the night before the meeting.
That is not a template problem. It is a records problem. Every one of these trackers is downstream of the same site data: diaries, allocations, instructions and correspondence. If that data is captured consistently, the templates populate themselves. If it is not, no amount of formula work fixes the gap.
Gather's AI QS reads your site diaries and correspondence as they land, keeping progress, cost and commercial position aligned to programme without a manual roll up.
See how Gather automates project controls A 30 minute call. No commitment. Bring one of your live projects.Start with the S curve and progress report if you need client-facing reporting, or the EVM calculator and cost to complete forecast if your priority is cost control. The lookahead planner and RFI register sit underneath both.
The commercial mechanics differ. NEC4 projects track instructed changes through compensation events, so the CE log is the primary register. JCT projects track variations directly, so the variation tracker does the equivalent job. Both are included in this pack.
They work well for a single project or a small portfolio kept up to date by one person. They struggle once several people update different sheets, which is when most teams start looking at software that reads the same underlying records automatically.
Gather reads your site records as they come in and keeps programme, cost and commercial position aligned automatically.
Book a demo