Data & tools
Make the informationeasier to trust.
Consistent inputs, traceable calculations, and useful outputs help an estimate remain understandable as the project changes.
Explore the estimating fundamentalsA clear path through the data
A model should explain its own logic.
I use structured information and repeatable workflows to make changes easier to follow, review, and communicate.
Consistent inputs
Align units, classifications, revisions, and scope boundaries before combining data. Keep the source connected to the quantity or assumption it supports.
Repeatable calculations
Separate inputs from logic and outputs. Use templates, queries, and automation where they reduce repetitive work and make the process easier to inspect.
Useful comparisons
Explain changes in terms of scope, quantity, and basis. Surface exceptions and unresolved assumptions so reviewers can focus on the decisions that matter.
Useful tools.
Visible reasoning.
Automation supports judgment when the result can still be traced, challenged, and explained.
Conceptual system imagery
A practical approach
Keep the model connected to the work.
The right level of detail depends on the decision. A concise summary and a reviewable calculation should tell the same story.
- 01
Structure
Sources, units, and identifiers
- 02
Transform
Repeatable data preparation
- 03
Check
Exceptions and reconciliation
- 04
Communicate
Clear, decision-ready outputs
Spreadsheets, Power Query, databases, dashboards, and focused automation.
Electrical estimating & systems
The thinking behind the number.
A clear scope. Visible assumptions. An estimate that can be explained.
Explore estimating 101