Estimating With Microsoft Excel / Edition 3

by Jay P. Christofferson

Overview

Creating estimates for your new residential construction project just got a little easier. In Estimating with Microsoft® Excel, Third Edition, Jay Christofferson, a recognized expert in computerized estimating, details step-by-step how you can save money and time by using Microsoft® Excel 2007 to develop estimates that are reliable enough for your most important management decisions. The book and CD includes formulas for calculating concrete, rebar, labor, permits, taxes, and more, and demonstrates how to apply them in your everyday construction project management. You’ll learn essential skills for programming basic formulas to automating Excel to integrate with other software packages— Estimating with Microsoft® Excel will show you how to eliminate time-consuming steps and repetitive work by— • setting up an accurate, efficient estimating system • creating databases • writing formulas • adapting shortcuts Boost your profit margin with the power of Microsoft® Excel 2007! “Jay Christofferson is a master in the industry. I can’t imagine how we could run our business without Excel and the teaching and training that he has provided us.” —Chad Magleby Vice President, Magleby Companies 2007 NAHB Custom Home Builders of the Year “This book teaches essential skills for a successful career in construction and beyond. What you learn from Estimating with Microsoft Excel® will build your confidence and increase your versatility in today’s world of work.” —Matthew Edwards Professor of Construction Management Southern Utah University “Learn how to budget and estimate using Excel with this great resource written especially for builders.” —Skip Howes, CGP Scott Homes Ltd. Woodland Park, Colorado “Most builders wear many hats in their companies. They need quick solutions for understanding and managing costs. Jay’s step-by-step approach teaches builders how to rapidly deploy Excel® to create estimates that will improve their bottom line.” —J. Bradley Simons President Cottage Homes Corporation

Product Details

ISBN-13:	9780867186475
Publisher:	National Association of Home Builders
Publication date:	01/01/2010
Edition description:	Third edition
Pages:	176
Product dimensions:	7.00(w) x 9.90(h) x 0.50(d)

About the Author

Jay P. Christofferson, author of Estimating with Microsoft Excel, is a licensed general contractor and a nationally recognized authority on construction estimating. He is the chairperson of one of the oldest and largest Construction Management programs in the nation at Brigham Young University, where he teaches estimating courses to students and professionals.

Table of Contents

List of Figures vii

List of Tables xii

Foreword xiii

About the Author XV

Acknowledgments xvii

Introduction 1

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 109

Chapter 9 Automating Spreadsheets 121

Notes 145

Resources 147

Index 149