Production-grade project controls, pay-app workbooks, and Power Query automation for electrical/mechanical subs and small GCs. Built by a PM who ran $100M+ in project controls and productized the kit on the way out.
What you get
Templates · Productized, instant
The full bundle. Production Tracker, Pay App Workbook (G702/G703), T&M Cost Sheet + Aggregator, Commodity Progress Curves, Timesheet Aggregator, and BOM Takeoff Register. Everything below in one download, priced for the kit not the parts.
SOV → G703 schedule of values → G702 application for payment, wired together. Drop in your line items and the pay-app numbers populate. Stops the monthly billing scramble.
11-tab progress-curve workbook with a styled dashboard. Track installed quantities against plan, by commodity and area. The version actually used in project meetings, not a textbook example.
Daily cost sheet on the field side, weekly aggregator on the office side. Built for T&M and unit-rate work. Power Query rolls daily sheets into a clean billing register.
Front-page summary + install log architecture. Track planned vs installed quantities at a granularity that survives an actual project. Built around the structure I ran on a $100M+ job.
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.
Custom · Project-by-project, billed up front
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 architecture, formulas that survive the next PM, Power Query where it earns its keep, dashboard if you want one.
Retainer · Recurring, monthly
15–20 hrs/month. I act as your project controls department: monthly reporting, pay-app prep, cost-to-complete forecasts, owner-meeting decks. Cheaper than hiring; more senior than a coordinator.
8–12 hrs/month. Monthly reporting + pay-app prep support + ad-hoc Excel questions. For shops that have a PM running the books but want a power user on call.
2–4 hrs/month. Keep your workbooks working: minor updates, fixes, small add-ons. The retainer that prevents your custom build from rotting after delivery.
Why this exists
The construction industry runs on workbooks. Subs in the $5M–$50M range can't afford Procore plus Primavera plus a custom ERP, but they're managing $20M backlogs on spreadsheets held together with VLOOKUP and prayer. They're underbilling. They're missing change orders. They're reconciling manually every month and losing margin to it.
I'm a construction PM who built production-grade project controls systems from scratch on a $100M+ project. Takeoff registers, commodity curves, G702/G703 pay-app pipelines, T&M billing engines, Power Query timesheet aggregators, dark-themed dashboards that actually get used in meetings. Not theory. Production.
Built Dirty / Builds is that kit, productized. The templates are stripped versions of what shipped on a real job. The custom builds are the same systems, adapted to your company. The retainer is me on retainer.
How it works