# Construction Estimating Using Excel, 3rd edition

• Steven J. Peterson

3rd edition

Unfortunately, this item is not available in your country.

## Overview

For beginning to intermediate courses in construction estimating in two- and four-year construction management programs.

A step-by-step, hands-on introduction to commercial and residential estimating

Construction Estimating with Excel, 3/e, introduces readers to the fundamental principles of estimating using drawing sets, real-world exercises, and examples. The book moves step-by-step through the estimating process, discussing the art of estimating, the quantity takeoff, how to put costs to the estimate, and how to finalize the bid. As students progress through the text they are shown how Microsoft Excel can be used to improve the estimating process. Because it introduces spreadsheets as a way of increasing estimating productivity and accuracy, the book can help both beginning and experienced estimators improve their skills.

The Third Edition gives students a broader understanding of construction estimating with a new chapter discussing the role that estimating plays in different project delivery methods and in the design process and how to use data from RSMeans. To bring the book up to date, the material and equipment costs and labor rates have been updated to reflect current costs, and the discussion of Excel (including the figures) is based on Excel 2016. Additionally, content throughout the book has been updated to align to ACCE and ABET student learning outcomes. Student resources are available on the companion website www.pearsonhighered.com/careersresources/.

PART I INTRODUCTION TO ESTIMATING

Chapter 1 THE ART OF ESTIMATING

The Estimator

Types of Estimates

Bid Package

Estimating Tools

Computerized Estimating Conclusion

Problems

References

Chapter 2 OVERVIEW OF THE ESTIMATING AND BIDDING PROCESS

Planning the Bid

Pre—Bid-Day Activities

Bid-Day Activities

Post-Bid Activities

Information Flow

Conclusion

Problems

Chapter 3 INTRODUCTION TO EXCEL

Conventions Used in This Book

Workbook Management

Working with Worksheets

Entering Data

Formatting Worksheets

Writing Formulas

Basic Functions

Printing

Conclusion

Problems

PART II THE QUANTITY TAKEOFF

Chapter 4 FUNDAMENTALS OF THE QUANTITY TAKEOFF

Performing a Quantity Takeoff

Work Packages

Communication with the Field

Counted Items

Linear Components

Sheet and Roll Goods

Volumetric Goods

Quantity-From-Quantity Goods

Waste

Building Information Modeling (BIM)

Conclusion

Problems

Reference

Chapter 5 CONCRETE

Forms

Reinforcing

Concrete

Columns

Continuous Footings

Foundation Walls

Beams

Raised Slabs

Stairs

Sample Takeoff for the Residential Garage

Conclusion

Problems

Chapter 6 MASONRY

Block and Structural Brick Walls

Brick Veneer

Conclusion

Problems

Chapter 7 METALS

Types of Structural Steel

Common Shapes for Structural Steel

Beams, Girders, and Columns

Joists and Joist Girders

Metal Deck

Steel Trusses

Stairs and Handrail

Miscellaneous Steel

Conclusion

Problems

Chapter 8 WOODS, PLASTICS, AND COMPOSITES

Floor Systems

Walls

Roof Systems

Finish Carpentry

Cabinetry and Countertops

Sample Takeoff for the Residential Garage

Conclusion

Problems

Reference

Chapter 9 THERMAL AND MOISTURE PROTECTION

Waterproofing and Dampproofing

Building Paper and Vapor Barriers

Insulation

Exterior Insulation Finish System

Shingle Roofs

Siding, Soffit, and Fascia

Membrane Roofing

Sample Takeoff for the Residential Garage

Conclusion

Problems

References

Chapter 10 OPENINGS

Doors

Windows

Commercial Storefront

Glazing

Hardware

Sample Takeoff for the Residential Garage

Conclusion

Problems

Reference

Chapter 11 FINISHES

Metal Stud Partitions

Gypsum Board

Tile

Suspended Acoustical Ceilings

Wood and Laminate Floors

Sheet Vinyl

Vinyl Composition Tile

Rubber Base

Paint

Sample Takeoff for the Residential Garage

Conclusion

Problems

Chapter 12 FIRE SUPPRESSION

Conclusion

Problems

Chapter 13 PLUMBING

Water Supply

Drain-Waste-and-Vent System

Fixtures and Equipment

Conclusion

Problems

Chapter 14 HEATING, VENTILATION, AND AIR-CONDITIONING (HVAC)

Residential HVAC Systems

Commercial HVAC Systems

Conclusion

Problems

Chapter 15 ELECTRICAL

Residential Wiring

Commercial Wiring

Sample Takeoff for the Residential Garage

Conclusion

Problems

Chapter 16 EARTHWORK

Characteristics of Soils

Swell and Shrinkage

Geometric Method

Average-Width-Length-Depth Method

Average-End Method

Modified-Average-End Method

Cross-Sectional Method

Comparison of Methods

Backfill

Soils Report

Sample Takeoff for the Residential Garage

Conclusion

Problems

Chapter 17 EXTERIOR IMPROVEMENTS

Asphalt and Base

Site Concrete

Landscaping

Sample Takeoff for the Residential Garage

Conclusion

Problems

Chapter 18 UTILITIES

Excavation

Bedding

Utility Lines

Backfill

Conclusion

Problems

PART III PUTTING COSTS TO THE ESTIMATE

Chapter 19 MATERIAL PRICING

Shipping Costs

Sales Tax

Storage Costs

Escalation

Conclusion

Problems

Chapter 20 LABOR PRODUCTIVITY AND HOURS

Factors Affecting Labor Productivity

Historical Data

Field Observations

National Standards

Labor Hours

Conclusion

Problems

Reference

Chapter 21 LABOR RATES

Billable Hours

Wages

Fair Labor Standards Act

Davis-Bacon Act

Labor Contracts

State and Local Employment Laws

Cash Equivalents and Allowances

Payroll Taxes

Unemployment Insurance

Workers’ Compensation Insurance

General Liability Insurance

Insurance Benefits

Retirement Contributions

Union Payments

Other Benefits

Annual Costs and Burden Markup

Conclusion

Problems

References

Chapter 22 EQUIPMENT COSTS

Depreciation and Interest

Taxes and Licensing

Insurance

Storage

Hourly Ownership Cost

Tires and Other Wear Items

Fuel

Lubricants and Filters

Repair Reserve

Leased Equipment

Rented Equipment

Conclusion

Problems

Chapter 23 CREW RATES

Conclusion

Problems

Chapter 24 SUBCONTRACT PRICING

Request for Quote

Writing a Scope of Work

Historical

Bid Selection

Conclusion

Problems

Chapter 25 MARKUPS

Building Permits

Payment and Performance Bonds

Conclusion

Problems

Reference

Chapter 26 PRICING EXTENSIONS

Detail Worksheet

Material Costs

Labor Costs

Equipment Costs

Total Cost

Summary Worksheet

Sample Estimate: The Residential Garage

Conclusion

Problems

Chapter 27 AVOIDING ERRORS IN ESTIMATES

List Cost Codes

Spend More Time on Large Costs

Prepare Detailed Estimates

Mark Items Counted during the Quantity Takeoff

Double-Check All Takeoffs

Include Units in Calculations

Use Well-Tested and Checked Formulas

Double-Check All Calculations

Perform Calculations in Two Ways

Drop the Pennies

Have Someone Review the Estimate

Review Each Cost Code as a Percentage of the Total Cost

Check Unit Costs for Each Cost Code

Compare Costs to Those for Another Project

Allow Plenty of Time

Conclusion

Problems

PART IV FINALIZING THE BID

Chapter 28 SUBMITTING THE BID

Bid Submission with Standardized Documents

Writing a Proposal

Letter Formats

Writing E-mails

Conclusion

Problems

Subcontracts

Purchase Orders

Contracts for Materials

Conclusion

Problems

Chapter 30 THE ESTIMATE AS THE BASIS OF THE SCHEDULE

Estimating Durations

Sample Durations: The Residential Garage

Conclusion

Problems

Chapter 31 ETHICS

Work Ethic

Bidding Practices

Loyalty to Employer

Ethical Dilemmas

Conclusion

Problems

Reference

Chapter 32 CONVERTING EXISTING FORMS

Creating the Layout

Automating with Macros

Testing the Worksheets

Conclusion

Problems

Chapter 33 CREATING NEW FORMS

Planning New Forms

Series

Naming Cells

Referencing Worksheets in a Formula

Concatenate

LOOKUP and VLOOKUP

Proposals

Conclusion

Problems

Chapter 34 Other Estimating methods

Design Process

Delivery Methods

Project Comparison Method

Square-Foot Estimating

Assembly Estimating

And Beyond

Conclusion

Problems

References

Appendix A REVIEW OF ESTIMATING MATH

Lengths

Scaling

Pythagorean Theorem

Areas

Volumes

Conversion Factors

Appendix B SAMPLE JOB COST CODES

Appendix C SAMPLE LABOR PRODUCTIVITY RATES

Appendix D SAMPLE EQUIPMENT COSTS

Appendix E MODEL SCOPES OF WORK

Footings and Foundations

Framing

Finish Carpentry

Drywall

Floor Coverings

Painting and Staining

Fire Sprinklers

Plumbing

HVAC

Electrical

Earthwork and Utilities–Roads and Parking Lots

Landscaping

Appendix F GLOSSARY

Appendix G INDEX OF DRAWING SETS

## For teachers

All the material you need to teach your courses.

Discover teaching material