Why spreadsheets became the default
Spreadsheets did not take over Division 08 estimating by accident. They are flexible enough to model almost any opening, cheap enough that every shop already owns them, and universal enough that a new estimator already knows the basics. You can build a hardware set, drop in list prices, apply a multiplier and a margin, and have a working estimate in an afternoon without buying or learning anything new.
For a small shop pricing straightforward jobs, that is a reasonable answer, and pretending otherwise does not help anyone. The problems come from scale and time, not from the tool being useless.
The typical workflow
The common setup is a master workbook: tabs of hardware sets, a sheet of pricing pulled from manufacturer books, and formulas that carry list price through multiplier and margin to a sell price. One experienced person owns this file, knows where the quirks are, and updates it when they can.
To bid a job, an estimator copies the master, builds the openings, counts the quantities and lets the formulas produce a number. It is fast when the file is current and the person who understands it is at their desk. Both of those conditions are where the trouble starts.
Where it breaks down
The failure modes are consistent across shops, and none of them are about the estimator being careless. They are structural limits of running a pricing operation out of a workbook.
- Stale price-book data: manufacturer prices and multipliers change, the sheet lags, and bids go out on old numbers
- Version-control chaos: copies of copies, and nobody sure which workbook is the current master
- Formula and transcription errors: a dragged formula or mistyped cell that quietly misprices every bid built from it
- No link to ordering: the estimate is retyped into a purchase order, a second chance to introduce errors
- Knowledge locked in one file: when the person who owns the workbook is out, so is the ability to price confidently
Be fair: spreadsheets still work for simple jobs
It is worth repeating that spreadsheets are not the enemy. For a small distributor, or for a simple job with a handful of openings and stable products, a well-kept workbook is perfectly adequate and nobody should feel they have to replace it on principle.
The honest test is not whether Excel can price a bid, it clearly can. It is whether the cost of the stale data, the version confusion, the retyping and the single point of failure has grown larger than the cost of doing something about it. For a lot of growing shops, it has, and that is the signal to look further.
When a spreadsheet stops being enough
Purpose-built CPQ software, meaning configure, price, quote, is the category that exists to address exactly these limits. Instead of a workbook someone has to keep current, it maintains manufacturer catalogs centrally, so lines are priced from current data. Instead of retyping an estimate into an order, it carries one job from takeoff through to the purchase order, so the pricing and the ordering are the same record.
eMullion is built for Division 08 specifically, maintaining price books and carrying a job from estimate through to the order and beyond. Whether that trade is worth making depends on your volume and your pain, which is exactly what the eMullion-versus-Excel comparison lays out.
