A Construction Company in Denver

This Denver-based construction company had been growing steadily for seven years, picking up larger residential and light commercial projects across the metro area. The operations director joined two years ago to help the founder get the back office under control. What he inherited was a mess hidden behind good revenue numbers.

The company ran on five separate spreadsheets: one for project timelines, one for crew scheduling, one for material orders, one for subcontractor payments, and one for client billing. Each spreadsheet had its own logic, its own formulas, and its own person who understood how it worked. When that person was out sick or on a job site, nobody else could update it.

New hires were the biggest pain point. Bringing a new crew member or project manager up to speed took nearly two weeks. They had to learn five different systems, understand which spreadsheet was the "real" one for any given question, and figure out the unwritten rules — like how the founder's billing spreadsheet used a color-coding system that only made sense to him.

The operations director had tried off-the-shelf construction management software twice. Both times, the team abandoned it within a month. The tools were built for large general contractors running multi-million-dollar commercial jobs, not a 28-person operation doing kitchens, additions, and small commercial buildouts. The software was overkill, and the crew resisted it.

We spent three days embedded with the team — two days at the office and one day visiting active job sites. We sat in on the Monday morning scheduling meeting, watched a project manager try to reconcile material orders against the budget spreadsheet, and timed how long it took a new hire to find the answer to a basic question like "What's the delivery date for the lumber on the Oak Street project?"

The answer to that last question took 22 minutes. The new hire checked three spreadsheets, texted the project manager, waited for a reply, and then discovered the information was in an email thread, not a spreadsheet at all.

We mapped every piece of information the team needed on a daily basis and where it currently lived. The picture was clear: the same data was being entered in multiple places, nothing was connected, and the "system" was really just institutional knowledge held by four or five key people.

We built a single operational dashboard over six weeks, replacing all five spreadsheets:

• A unified project tracker that combined timelines, crew assignments, and material orders into one view. Each project had a single page with everything anyone needed to know — schedule, budget status, crew assignments, material deliveries, and client contact info. Updates in one place reflected everywhere.

• A crew scheduling tool with a visual calendar that showed who was assigned where, who was available, and who was out. Project managers could drag and drop assignments. When a crew member was moved, the affected project timelines updated automatically and flagged potential conflicts.

• A materials and budget tracker that connected purchase orders to project budgets in real time. When a project manager ordered materials, the cost was immediately reflected in the project budget. No more end-of-month surprises where a project was 15% over budget and nobody knew until the billing spreadsheet was reconciled.

• A simple onboarding checklist built into the dashboard itself. New hires got a guided walkthrough of the system, with tooltips and a "start here" view that showed them exactly what they needed for their first week.

The dashboard was web-based — accessible from any phone, tablet, or laptop. No app to install. The whole team was trained in a two-hour session on a Friday afternoon.

Within 90 days, the transformation was measurable:

• Onboarding time dropped from two weeks to three days — new hires had one system to learn instead of five, with built-in guidance
• 5 spreadsheets fully retired — all operational data lived in one place with one source of truth
• Monday scheduling meetings went from 90 minutes to 30 — the visual calendar made crew assignments obvious instead of requiring cross-referencing three documents
• Budget overruns caught 3x faster — real-time cost tracking flagged issues in days instead of weeks
• $3,200/month saved in avoided overtime and rework caused by scheduling conflicts and miscommunication

The operations director's favorite moment was watching a new project manager, hired on a Tuesday, confidently run his first client update meeting that Friday — with all the information he needed on a single screen. That would have been unthinkable three months earlier.