Field-tested project controls workbooks, AIA-format pay-app templates, and Power Query automation for electrical/mechanical subs and small GCs. Built by a working construction PM and productized for the next shop. Productivity tools, not licensed engineering or accounting work.
What you get
Templates · Productized, instant
The full bundle. Production Tracker, AIA-format Pay App Workbook (G702/G703 layout), Automated Daily Cost Builder, Commodity Progress Curves, Timesheet Aggregator, and BOM Takeoff Register. Everything below in one download, priced for the kit not the parts.
SOV → G703-format continuation schedule → G702-format certificate page, wired together. Drop in your line items and the pay-app math populates. Modeled after the AIA G702/G703 layout for familiarity — not an AIA-published or AIA-licensed form. Use alongside your contract's required AIA originals if your contract mandates the certified copies.
16-tab earned-value workbook with styled dashboard. Weekly planned vs actual S-curves per commodity, summary rollup, stage-weighted progress framework. Consultant equivalent: $2,000–$5,000 per build.
T&M daily cost sheet with VBA automation, 600+ row labor rate schedule, craft mapping, and timesheet auto-population. Not a static template — a tool. Auto-pulls labor, equipment, and materials by date and crew.
Front-page summary + install log architecture. Track planned vs installed quantities at a granularity that holds up across the life of a project. Built around the structure I use on industrial-scale jobs.
Power Query workbook that pulls weekly crew timesheets from a folder, normalizes them, and outputs a labor register. Parameterized so it adapts to your company's timesheet format.
6-layer takeoff register structure. Material, labor, equipment, sub, indirect, and contingency. Built to roll up into bid pricing without losing the audit trail.
Consulting + Custom · Project-by-project, billed up front
7-tab analysis of your buyer/contractor agreement at closeout: turnover framework, response timeframes, requirements, defenses & leverage, loopholes & risks, applicable laws, action plan. NDA required. Project-management work product — NOT legal advice.
Tony does the takeoff for you. Upload your PDFs + list of components — get a populated BOM Register workbook back. Pairs naturally with any BOM template.
Multi-tab register, Power Query pipelines, custom dashboard. Built around your contracts, your billing method, your reporting cadence. The kit your company would build internally if it had a controls department.
SOV → G703 → G702 pipeline configured for your company. Line-item structure, retention math, change-order tracking, GC-specific formatting. Drop-in replacement for the monthly billing scramble.
Connect your timesheet folder, your accounting export, your daily logs — whatever data sources you have — into auto-refreshing reports. No SaaS subscription, no IT ticket, no API keys.
Single-purpose dashboard. 3–5 tabs, styled, plug-and-play with the data shape you already have. The thing you'd build if you had a free weekend and the skill to do it.
You have a workbook held together with VLOOKUP and prayer. I rebuild it: clean structure, documented formulas, Power Query where it earns its keep, dashboard if you want one. Outcomes depend on the source workbook — scoping call before commit.
Retainer · Recurring, monthly
15–20 hrs/month. Embedded as your project-controls operator: monthly reporting, pay-app prep, cost-to-complete tracking, owner-meeting decks. Not engineering or accounting work — I won't sign or seal anything. Productivity support.
8–12 hrs/month. Monthly reporting + pay-app prep + ad-hoc Excel and Power Query questions. For shops with a PM running the books who want a workbook power user on call.
2–4 hrs/month. Keep your workbooks working: minor updates, formula fixes, small add-ons. Stops your custom build from drifting out of sync as contracts and reporting needs change.
Why this exists
The construction industry runs on workbooks. Subs in the $5M–$50M range can't always justify Procore plus Primavera plus a custom ERP, and a lot of them are managing real backlogs on spreadsheets held together with VLOOKUP and prayer. The pain shows up the same way every time: missed change orders, manual monthly reconciliation, and margin leaking out of the gap between the bid and the bill.
I'm a working construction PM. I build project-controls systems out of Excel, Power Query, and VBA because that's what the people doing the actual work already have on their laptops. Takeoff registers, commodity curves, AIA-format pay-app pipelines, T&M billing engines, timesheet aggregators, dashboards that get used in meetings. These are productivity tools — not licensed engineering, accounting, or estimating work product. You verify the numbers against your contract.
Built Dirty / Builds is that kit, productized. The templates are generalized versions of what runs on real jobs. The custom builds are the same patterns adapted to your contracts and reporting cadence. The retainer is workbook help on a monthly engagement.
How it works