Companion files · The Private Markets Career Guides
The Practitioner's Guide to Construction Estimating, from Conceptual Budgets and Quantity Takeoff to Bid Leveling, Prevailing Wage, Bonds and Bid Day.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook carries the Elsmoor County Library and Learning Center, the fictional project of the case, from its January conceptual number to the GMP: historical cost per square foot, the schematic design and design development estimates, the concrete takeoff, crew hours and the sealed self-perform number, bid leveling, general conditions, and the markups that turn cost into price. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 2, 5 to 9 and 11 to 15, and Appendix A
One sheet follows each step of the book, with its inputs on the sheet: Conceptual, Design estimates, Takeoff, Labor, Leveling, General conditions, Markups. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 14 exercises of Appendix A run on it.
Download the workbook37 KBAppendix B
Plan and specification review; Addenda and the bid form; Scope sheet; Public work: prevailing wage and bonds; Bid leveling; The sealed self-perform number; Bid day, hour by hour; Post-bid review.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The journey of the number | $16,767,000 in January, $17,861,413 at schematic design, $16,578,288 at design development, $15,820,745 on bid day |
| Leveling | The lowest HVAC base bid is $86,000 under the carried bid on its face and $68,000 over it once its missing scope is priced |
| Self-perform or buy | The sealed concrete number of $714,000 beats the best leveled subcontract bid of $749,720; with 20 percent more hours it does not |
The files are provided as they are, without warranty of any kind. The model is illustrative: Talhurst Builders, Elsmoor County and every bidder are fictional, and the prices, quantities, productivity, wage rates, insurance and bond rates, fee and contingency are the book’s assumptions, not market prices or wage determinations. Wage rules, bond thresholds and contract forms change: check the current texts and the bid documents.