Prometheus Real Estate Group: From Excel to Excellence in Precon

Company: PROMETHEUS REAL ESTATE GROUP

How Prometheus turned years of Excel-based estimating knowledge into a centralized, standardized preconstruction system with Zebel

‍

BEFORE
Historical knowledge across Excel files
WITH ZEBEL
Centralized project archive
THE SHIFT
From individual files to organizational intelligence

‍

The spreadsheets worked. The knowledge was fragmented.

Prometheus had already built sophisticated Excel templates that reflected years of estimating experience, historical pricing, assumptions, formulas, and project knowledge. The company was not trying to replace a broken process, it wanted to make an established one easier to scale.

As the portfolio grew, valuable information remained distributed across individual estimates. Comparing projects could mean opening multiple files, locating historical pricing, and relying on experienced team members who knew where the right information lived1.

The challenge wasn't creating estimates in Excel. It was making years of estimating knowledge easier to find, compare, and reuse.

‍

From spreadsheets to a reusable knowledge system

Prometheus preserved the estimating logic that already worked while reducing the friction around finding and comparing historical information.

Without Zebel: Excel to multiple files to find pricing to interpret to compare
With Zebel: project history to standardized to compare projects to apply judgment

‍

How Prometheus transformed its estimating knowledge

1. Preserve what already works

Prometheus's Excel templates already reflected how its estimators worked. Zebel was tailored around those requirements rather than forcing the team into a generic estimating process.6

2. Centralize project history

Historical estimates and pricing moved toward a central project archive, making previous projects easier to access as reference points for future decisions.5 7

3. Standardize for comparison

A standardized database gives historical costs the context needed to compare projects more consistently instead of interpreting different files and formats each time.1 4

4. Make knowledge easier to access

Senior and junior team members can access historical information more conveniently, allowing experienced estimators to spend more time interpreting information instead of locating it.8 9

‍

What actually changed?

Same estimating expertise. Better access to the knowledge behind it.

BEFORE
WITH ZEBEL
BEFORE: Historical information across Excel templates and previous estimates
WITH ZEBEL: Centralized archive of historical projects
BEFORE: Multiple estimates could be needed for comparison
WITH ZEBEL: Relevant projects are easier to compare
BEFORE: Historical pricing was less centralized
WITH ZEBEL: Historical pricing is more accessible
BEFORE: File structures could vary
WITH ZEBEL: Historical information is more standardized
BEFORE: Access could depend on who knew where information lived
WITH ZEBEL: Knowledge is easier to access across experience levels
BEFORE: Excel contained valuable estimating logic
WITH ZEBEL: That logic became part of a system tailored to Prometheus's workflow

‍

From “Who knows?” to “What do we know?”

Person-dependent knowledge: who worked on a similar project, who remembers what we paid, which estimate to open, who can explain this number

Shifted to:

Organizational knowledge: which projects are comparable, what does our project history show, how does pricing compare, what does the data tell us

Centralizing historical information does not replace senior expertise. It changes where that expertise adds the most value, from finding information to interpreting it8 9.

‍

Every project strengthens the knowledge base

Each completed project can add another layer of reusable estimating knowledge. Instead of allowing experience to remain trapped in individual files, a centralized system makes project history available for future decisions7 5.

Current project to capture knowledge to historical database to benchmark to future estimate

The next project adds new knowledge to the cycle.

‍

Why standardization matters

FIND

Locate relevant historical projects. Less searching.

COMPARE

Put costs and project context on a comparable basis. More meaningful comparisons.

APPLY

Use historical evidence in conceptual estimating. Better information for judgment.

Cost analysis and benchmarking guidance emphasizes putting construction cost information on a comparable basis so historical project data can meaningfully inform cost planning and design development4.

A historical price without context is just a number. A historical price connected to a relevant project provides evidence.

‍

Why this matters before design is complete

Conceptual estimating happens while project variables are still evolving. Leadership may be evaluating feasibility, preliminary budgets, alternative concepts, historical comparisons, or whether an opportunity should continue into development3.

Faster access to relevant historical information allows the estimating team to spend less time searching for context and more time evaluating the decision itself.

The value isn't simply finding historical information faster. It's getting organizational knowledge into the decision sooner.

‍

A practical preconstruction knowledge check

  • Can we quickly find relevant past projects?
  • Is historical pricing available from a central source?
  • Is project data structured consistently enough to compare?
  • Can junior team members access historical information without relying on tribal knowledge?
  • Does each completed project strengthen our historical database?
  • Does our technology fit the way our estimators actually work?

If several answers are no, the organization may not have a shortage of estimating knowledge. It may have a problem making that knowledge reusable.

‍

From Excel to excellence in Precon

Prometheus did not need to abandon Excel's estimating logic. It needed a way to make that accumulated knowledge more centralized, standardized, comparable, and accessible. Prometheus's existing Excel templates provided the foundation. Zebel helped turn that foundation into an estimating environment built around the company's actual workflow.

The result: the knowledge behind Prometheus's estimates became easier for the organization to find, compare, and put to work.

Sources

1. Kiziltas, S., & Akinci, B. (2009). Contextual information requirements of cost estimators from past construction projects. Journal of Construction Engineering and Management, 135(9), 841–852. https://doi.org/10.1061/(ASCE)CO.1943-7862.0000053

2. Kartam, N. A. (1996). Making effective use of construction lessons learned in project life cycle. Journal of Construction Engineering and Management, 122(1), 14–21. https://doi.org/10.1061/(ASCE)0733-9364(1996)122:1(14)

3. AACE International. (2020). Skills and knowledge of cost engineering (6th ed.). https://web.aacei.org/docs/default-source/toc/toc_SK6.pdf

4. Royal Institution of Chartered Surveyors. (2024). Cost analysis and benchmarking (2nd ed.). https://www.rics.org/profession-standards/rics-standards-and-guidance/sector-standards/construction-standards/black-book/cost-analysis-and-benchmarking-2nd-edition

5. Carrillo, P., & Chinowsky, P. (2006). Exploiting knowledge management: The engineering and construction perspective. Journal of Management in Engineering, 22(1), 2–10. https://doi.org/10.1061/(ASCE)0742-597X(2006)22:1(2)

6. Oti, A. H., Tah, J. H. M., & Abanda, F. H. (2018). Integration of lessons learned knowledge in building information modeling. Journal of Construction Engineering and Management, 144(9), 04018081. https://doi.org/10.1061/(ASCE)CO.1943-7862.0001537

7. Tan, H. C., Carrillo, P. M., & Anumba, C. J. (2012). Case study of knowledge management implementation in a medium-sized construction sector firm. Journal of Management in Engineering, 28(3), 338–347. https://doi.org/10.1061/(ASCE)ME.1943-5479.0000109

8. Caldas, C. H., Gibson, G. E., Jr., Weerasooriya, R., & Yohe, A. M. (2009). Identification of effective management practices and technologies for lessons learned programs in the construction industry. Journal of Construction Engineering and Management, 135(6), 531–539. https://doi.org/10.1061/(ASCE)CO.1943-7862.0000011

9. Tan, H. C., Carrillo, P. M., Anumba, C. J., Bouchlaghem, N., Kamara, J. M., & Udeaja, C. E. (2007). Development of a methodology for live capture and reuse of project knowledge in construction. Journal of Management in Engineering, 23(1), 18–26. https://doi.org/10.1061/(ASCE)0742-597X(2007)23:1(18)

10. Banerjee, S., Alsharef, A., Jaselskis, E. J., & Piratla, K. R. (2022). Review of current practices for implementing organization-wide knowledge repositories. In Construction Research Congress 2022. American Society of Civil Engineers. https://doi.org/10.1061/9780784483978.106

"Zebel has built the estimating tool that we’ve always wanted our Excel templates to be. Their team’s real world estimating experience is what makes their product so uniquely positioned to improve our existing estimating workflow. Most con-tech products don’t end up fitting into our workflow – there are few great products like Zebel that do."

Dan Emerson

SVP of Construction

Latest from our blog

Understanding ITBs in Construction

If you’ve ever asked, “What is an ITB in construction?”—you’re not alone. An Invitation to Bid (ITB) is a foundational document used throughout the construction industry to initiate...

Construction Work Breakdown Structure (WBS): The Complete 2025 Guide

Managing a construction project—whether it’s a residential build, commercial complex, or public infrastructure—requires meticulous planning.

Contractor’s Guide to Construction Bid Types

Understanding the various bid types is crucial for success when securing contracts in the construction industry. Navigating these bidding processes effectively can make all the difference...

Top Tips for Mitigating Cost Overruns in Construction Projects

Construction projects are known for their complexity, and even the best-planned ventures can experience cost overruns. These overruns aren’t just financial nuisances

Fast track your Precon operation upgrade

We’ve crafted a solution born from our firsthand experiences as precon professionals. Elevating it to new heights, we’re proud to unveil Zebel—an amalgamation of years of expertise and dedicated R&D, now accessible to all.