Construction Estimating Using Excel, 3rd edition

Published by Pearson (August 1, 2021) © 2018

  • Steven J. Peterson Weber State University

eTextbook on Pearson+

ISBN-13: 9780137402847 (2021 update)

eTextbook rental includes

  • Instant access to eTextbook
  • Search, highlight, and notes
  • Create flashcards
Products list

Details

  • A print text

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

Testing Spreadsheets

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

Spread Footings

Columns

Continuous Footings

Foundation Walls

Beams

Slab on Grade

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

Carpet and Pad

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

Profit and Overhead

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

Automate with Spreadsheets

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

Writing a Business Letter

Letter Formats

Writing E-mails

Conclusion

Problems

 

Chapter 29 PROJECT BUYOUT

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

 

PART V ADVANCED ESTIMATING

Chapter 32 CONVERTING EXISTING FORMS

Creating the Layout

Adding Formulas

Automating with Macros

Testing the Worksheets

Adding Error Protection

Conclusion

Problems

 

Chapter 33 CREATING NEW FORMS

Planning New Forms

Setting Up the Spreadsheet

Series

Naming Cells

Adding Dropdown Boxes

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

 

Need help? Get in touch