Turning decades of spreadsheet logic into a tool that grows with the business

Industry

Construction
‍

Engagement length

6 months

Services

Strategic Workshops
Product Discovery
Platform Integrations
Development
Product UX/UI

Tech stack

React Native
TypeScript
Microsoft Teams

The client

JE Dunn Construction is the 8th largest domestic general building contractor in the U.S. with offices in 26 locations and hundreds of project sites across the country.

‍

They are a well-known leader in the commercial construction industry providing general contracting, construction management, and design-build services for clients big and small. One of their most impressive differentiators is their aptitude for innovation with the application of virtual design and other emerging technologies in the construction space.

‍

Crema has partnered with JE Dunn's technology groups since 2022. This engagement sat inside their estimating organization, the group responsible for pricing every General Conditions line item on every active project.

The business landscape

General conditions (GC) estimating at JE Dunn ran on a single Excel spreadsheet that was fragile, hard to learn, and nearly impossible to scale.

‍

This work sets the baseline for every project's indirect costs: staffing, equipment, insurance, logistics. Get it wrong and the margin is gone before the first shovel hits the ground. For JE Dunn, this process ran entirely on a complex, multi-tab Excel spreadsheet. It worked when the portfolio was smaller and a handful of experienced estimators could carry the institutional knowledge required to use it, though it stopped working effectively as the business grew.
‍

Because the spreadsheet had no guided workflow, new staff needed extensive one-on-one coaching before they could contribute independently. Formulas were routinely broken by estimators who didn't know what not to touch, corrupting data with no easy way to catch it. Teams across offices worked from copied files, with no single source of truth and no visibility into what others were doing. The support burden fell almost entirely on one person whose actual job was managing precon and estimating, not troubleshooting a tool.
‍

Meanwhile, the portfolio was accelerating: 327 active GC projects in 2023, 291 in 2024, 453 in 2025. Growth was outpacing the tool's ability to absorb it. JE Dunn needed a replacement that could scale with the business, guide estimators through a consistent process, and centralize the data the spreadsheet had always kept fragmented.

‍

453

Active GC projects managed in 2025

871

Project managers and estimators across JE Dunn's estimating org

3+

Hours of support calls weekly addressing the GC process

The challenge

How might we take the complexity of a multi-tab Excel model and rebuild it as an experience that makes every estimator more confident in the numbers they're producing?

‍

The spreadsheet's accuracy was there, what it lacked was uniformity. Every estimator built the model a little differently, with no standard process to follow and no safety net for the formulas underneath. Closing that gap meant designing for standardization first, so every estimate followed the same logic regardless of who built it.

Engagement priorities
01

Replace the knowledge-dependent spreadsheet with a guided web application any estimator can use

02

Preserve JE Dunn's existing estimating logic while redesigning the experience around how estimators actually work

03

Integrate natively into Microsoft Teams and JE Dunn's existing systems

04

Focus MVP on what estimators need to produce an accurate estimate, leaving room for enhancements driven by real-world use

“The Crema team asked a lot of questions that allowed us to really think through our process and determine what we ultimately want to accomplish.”

Jason Hickam
National Pre-Constructions Director, JE Dunn
The result

A single guided workflow now replaces the spreadsheet that the organization outgrew.

‍

After 24 weeks of workshopping, user research, prototyping, designing, developing, and testing, the new and improved tool was ready to be rolled out to JE Dunn’s 871 project managers and estimators.
‍

  • What used to require weeks of coaching to learn can now be picked up independently.
  • The support burden that came with the old spreadsheet no longer falls on one person.
  • Estimators work from a single centralized system rather than copied files passed between teams, with multiple estimators collaborating on the same estimate in one place. No emailed spreadsheets, no competing copies.
  • JE Dunn can see its estimating data in aggregate for the first time.
  • With 453 projects running through the system in 2025 and a portfolio that keeps growing, JE Dunn now has infrastructure that scales with them.
  • Every estimate produced in the app generates real usage data, a foundation for future enhancements grounded in how estimators actually use the tool in practice.