Unlocking the Power
for Home Builders
By: Jay P. Christofferson
Published by: National Association of Home
Create your own Customized Estimating Program!
Most builders estimate with Excel because it's
easy to learn, quick to use, and can be customized to your style of
Here you'll find step-by-step how to create your own
customized automated spreadsheet estimating program for use with
You'll learn how to use the magic of Excel in
creating detail sheets, cost breakdown summaries, and linking.
You'll put this all to use in estimating concrete, rebar, permit
fees, and roofing. You can even create your own macros.
Includes a CD-ROM that
illustrates examples in the book and provides you with templates you
can use to set up your own estimating system.
Estimating with Microsoft® Excel:
Unlocking the Power for Home Builders gives you step-by-step
instructions on how to create a powerful estimating program that
will help you save time, increase productivity, and improve the
accuracy of your estimates.
Author Jay Christofferson, one of the
countries leading experts in computerized estimating for home
builders, teaches you how to build a fully customized estimating
program without buying expensive specialized software or hiring a
consultant. Christofferson's innovative instructional text is
complemented with a CD-ROM that illustrates examples in the book and
provides you with templates you can use to set up your estimating
From programming basic formulas to
sophisticated applications like automating Excel to integrate with
other software packages, Estimating with Microsoft® Excel
will help you set up an accurate, efficient estimating system. With
easy-to-understand examples and screen shots, you will create
estimating operations powerful and reliable enough for your most
important management decisions.
List of Figures, vii
List of Tables, xii
About the Author, xv
Chapter 1, The Basics of Spreadsheets and Beyond, 5
Chapter 2, Improving Estimating by Using Spreadsheets, 23
Chapter 3, Creating a Cost Breakdown Summary Sheet, 35
Chapter 4, Eliminating Steps by Using Detail Sheets, 47
Chapter 5, Saving Time with Hyperlinks, 73
Chapter 6, Letting Formulas and Functions Do the Work, 79
Chapter 7, Calculating Profit Margin, 99
Chapter 8, Making Spreadsheets User Friendly with Form Controls,
Chapter 9, Automating Spreadsheets, 121
8-1/2 x 11 in.
& Related Products
* * * * * * *
Specialty Electrical Tools