The workbook is in final testing. Join the list and you will get one email when it is ready.
Tell me when it's readyBuilt by a practicing civil infrastructure PM for design-bid-build consulting work. Scope, schedule, staffing, fee, earned value and invoicing, tied together so a change in one place updates the rest.
The problem
Most design PMs keep the scope in a Word file, the schedule in one spreadsheet, the fee in another and the monthly status in their head. Each copy drifts. When the Owner asks for a schedule change or a fee breakdown, you rebuild it by hand.
What the workbook does
- Scope of Services, your way. Start from an EJCDC-style phase list or build your own phases, tasks and sub-tasks. Unused rows hide themselves. Room for about 300 rows.
- Schedule with a Gantt chart. Durations, predecessors and lags; parent rows roll up dates; progress shades the bars.
- Staffing by utilization. Enter each person's share of the week on each task; hours follow. Staff_Loading shows who is over their available hours, month by month.
- Fee build-up. Labor at cost and at billing rates, subconsultants and expenses with markup, rate escalation for multi-year jobs, totals by task and phase.
- Drawings and specifications lists. Sheet and section counts by milestone, and design hours per sheet.
- Monthly earned value. Enter the status date, % complete and actual cost on one tab. Get SPI, CPI, EAC, VAC, ETC and TCPI by task and for the project.
- Invoice. Earned to date, billed to date and this period's amount by task.
- Dashboard. Planned, earned and actual cost on an S-curve, with a month-by-month status history.
- Built-in checks. Ten checks flag a fee that does not match the contract, missing predecessors, duplicate WBS numbers, overloaded staff and more.
See it on a worked example
The package includes a complete example: the Tanner Run Pump Station Replacement for the (fictional) Ashby Glen Sewer District. Nine staff, about 85 weeks, a $291,178 fee and seven months of status history. Open it first and see every tab filled in.
Who it is for
- Project managers and project engineers on civil infrastructure design contracts: water, wastewater, stormwater, roads, public works.
- Small and mid-size consulting firms without a project controls department.
- Engineers stepping into their first PM role who want a structure to work from.
Not a replacement for your firm's accounting system. It is the PM's planning and tracking tool.
Requirements
- Microsoft 365 Excel for Windows (desktop app). Uses current Excel functions that older versions and Excel for the web do not fully support.
- Mac: not yet tested.
- Two editions in the package: macro-free, and a macro edition that adds Insert row, Move row and automatic row hiding.
What you get
- Blank workbook (macro-free and macro editions)
- Example workbook (Tanner Run)
- Quick Start guide (PDF)
- Walkthrough video
- Free updates to version 1.x
- Email support for installation and defects
Price
- Single user: $49, one-time
- Team license: about $199
- 14-day refund
FAQ
Does it follow EJCDC? Phase names and terms are consistent with EJCDC and PMI usage. It is not an EJCDC document and does not replace your agreement.
Can I change the phases and tasks? Yes. Any row can be a phase, task or sub-task.
Will it work in Google Sheets or LibreOffice? No. It needs Microsoft 365 Excel on the desktop.
Do I need to enable macros? No. The macro-free edition does everything except the row commands.
Can my whole team use it? Each person needs a license; the team license covers a group (see License).
Is my data sent anywhere? No. Everything stays in your Excel file.
What if I find a bug? Email support@leroyfiles.com. Fixes go out as free 1.x updates.
The workbook is in final testing. Join the list and you will get one email when it is ready.
Tell me when it's ready