Secure Checkout

Construction Estimating Using Excel, 3rd edition

  • Steven J. Peterson

$16.99per month

Minimum 4-month term, pay monthly or pay $67.96 upfront

Includes:

  • Instant access to eTextbook
  • Search, highlights, notes, and more
  • Expert video lessons and practice questions
  • Videos, study help in multiple subjects. List in FAQs.
  • Practice problems and study guides
  • Q&A with experts and AI tutor
14-day refund guarantee

$10.99per month

Minimum 4-month term, pay monthly or pay $43.96 upfront

Includes:

  • Instant access to eTextbook
  • Search, highlights, notes, and more
14-day refund guarantee

$16.99per month

Minimum 4-month term, pay monthly or pay $67.96 upfront

Includes:

  • Instant access to eTextbook
  • Search, highlights, notes, and more
  • Expert video lessons and practice questions
  • Videos, study help in multiple subjects. List in FAQs.
  • Practice problems and study guides
  • Q&A with experts and AI tutor
14-day refund guarantee

$10.99per month

Minimum 4-month term, pay monthly or pay $43.96 upfront

Includes:

  • Instant access to eTextbook
  • Search, highlights, notes, and more
14-day refund guarantee

$10.99per month

Minimum 4-month term, pay monthly or pay $43.96 upfront

Includes:

  • Instant access to eTextbook
  • Search, highlights, notes, and more
14-day refund guarantee

$10.99per month

Minimum 4-month term, pay monthly or pay $43.96 upfront

Includes:

  • Instant access to eTextbook
  • Search, highlights, notes, and more
14-day refund guarantee

Looking for your MyLab or Mastering eTextbook? Find it hereOpens in an new tab

Learn more, spend less

  • Study simpler and faster

    Use flashcards and other study tools in your eTextbook

  • Listen on the go

    Learn how you like with full eTextbook audio

  • Find it fast

    Quickly navigate your eTextbook with search

  • Stay organized

    Access all your eTextbooks in one place

  • Easily continue access

    Keep learning with auto-renew

Overview

PART I: INTRODUCTION TO ESTIMATING
1. THE ART OF ESTIMATING
The Estimator
Types of Estimates
Bid Package
Estimating Tools
Computerized Estimating Conclusion
Problems
References

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

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
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

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

6. MASONRY
Block and Structural Brick Walls
Brick Veneer
Conclusion
Problems

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

8. WOODS, PLASTICS, AND COMPOSITES
Floor Systems
Walls
Roof Systems
Finish Carpentry
Cabinetry and Countertops
Sample Takeoff for the Residential Garage
Conclusion
Problems
Reference

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

10. OPENINGS
Doors
Windows
Commercial Storefront
Glazing
Hardware
Sample Takeoff for the Residential Garage
Conclusion
Problems
Reference

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

12. FIRE SUPPRESSION
Conclusion
Problems

13. PLUMBING
Water Supply
Drain-Waste-and-Vent System
Fixtures and Equipment
Conclusion
Problems

14. HEATING, VENTILATION, AND AIR-CONDITIONING (HVAC)
Residential HVAC Systems
Commercial HVAC Systems
Conclusion
Problems

15. ELECTRICAL
Residential Wiring
Commercial Wiring
Sample Takeoff for the Residential Garage
Conclusion
Problems

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

17. EXTERIOR IMPROVEMENTS
Asphalt and Base
Site Concrete
Landscaping
Sample Takeoff for the Residential Garage
Conclusion
Problems

18. UTILITIES
Excavation
Bedding
Utility Lines
Backfill
Conclusion
Problems

PART III: PUTTING COSTS TO THE ESTIMATE
19. MATERIAL PRICING
Shipping Costs
Sales Tax
Storage Costs
Escalation
Conclusion
Problems

20. LABOR PRODUCTIVITY AND HOURS
Factors Affecting Labor Productivity
Historical Data
Field Observations
National Standards
Labor Hours
Conclusion
Problems
Reference

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

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

23. CREW RATES
Conclusion
Problems

24. SUBCONTRACT PRICING
Request for Quote
Writing a Scope of Work
Historical
Bid Selection
Conclusion
Problems

25. MARKUPS
Building Permits
Payment and Performance Bonds
Profit and Overhead
Conclusion
Problems
Reference

26. PRICING EXTENSIONS
Detail Worksheet
Material Costs
Labor Costs
Equipment Costs
Total Cost
Summary Worksheet
Sample Estimate. The Residential Garage
Conclusion
Problems

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
28. SUBMITTING THE BID
Bid Submission with Standardized Documents
Writing a Proposal
Writing a Business Letter
Letter Formats
Writing E-mails
Conclusion
Problems

29. PROJECT BUYOUT
Subcontracts
Purchase Orders
Contracts for Materials
Conclusion
Problems

30. THE ESTIMATE AS THE BASIS OF THE SCHEDULE
Estimating Durations
Sample Durations. The Residential Garage
Conclusion
Problems

31. ETHICS
Work Ethic
Bidding Practices
Loyalty to Employer
Ethical Dilemmas
Conclusion
Problems
Reference

PART V: ADVANCED ESTIMATING
32. CONVERTING EXISTING FORMS
Creating the Layout
Adding Formulas
Automating with Macros
Testing the Worksheets
Adding Error Protection
Conclusion
Problems

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

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

Published by Pearson (August 1st 2021) - Copyright © 2018

ISBN-13: 9780137402847

Subject: Construction Management & Civil Technology

Category: Construction Estimation

Your questions answered

Pearson+ is your 1-stop shop with eTextbooks, study tools and exam prep features designed to help students get better grades in college. eTextbooks come with built-in tools that simplify studying, like flashcards, audiobook and search. Pearson+ also features Channels, which includes practice problems, study guides, Q&A with experts, video lessons that help you understand tricky topics and more—all in one place. Channels can be purchased separately or added on to your eTextbook at the time of purchase as part of the Study & Exam Prep Pack.

A Pearson eTextbook is an easy-to-use digital version of your book for class that includes upgraded study tools to help you learn how you learn best. Use enhanced search to find what you need within your eTextbook, highlight and make notes to mark important info, generate flashcards to test your knowledge, and use audio to listen to the text. Every feature is designed to help you learn more efficiently and get results. Plus, you can learn on the go with the Pearson+ app. Find this and more in your eTextbook, available in Pearson+.

The Study & Exam Prep Pack includes practice problems, study guides, Q&A with experts, Channels video lessons that help you understand tricky topics and more. It can be added on to your eTextbook or your MyLab and Mastering learning platform at the time of purchase.

Your eTextbook subscription gives you access for 4 months. You can make a one‑time payment for the initial 4‑month term or pay monthly. If you opt for monthly payments, we will charge your payment method each month until your 4‑month term ends. You can turn on auto‑renew in My account at any time to continue your subscription before your 4‑month term ends.

When you purchase an eTextbook subscription, it will last 4 months. You can renew your subscription by selecting Extend subscription on the Manage subscription page in My account before your initial term ends.

If you extend your subscription, we'll automatically charge you every month. If you made a one‑time payment for your initial 4‑month term, you'll now pay monthly. To make sure your learning is uninterrupted, please check your card details.

To avoid the next payment charge, select Cancel subscription on the Manage subscription page in My account before the renewal date. You can subscribe again in the future by purchasing another eTextbook subscription.

Channels is a video platform with thousands of explanations, solutions and practice problems to help you do homework and prep for exams. Videos are personalized to your course, and tutors walk you through solutions. Plus, interactive AI‑powered summaries and a social community help you better understand lessons from class.

Channels is an additional tool to help you with your studies. This means you can use Channels even if your course uses a non‑Pearson textbook.

When you choose a Channels subscription, you're signing up for a 1‑month, 3‑month or 12‑month term and you make an upfront payment for your subscription. By default, these subscriptions auto‑renew at the frequency you select during checkout.

When you purchase a Channels subscription it will last 1 month, 3 months or 12 months, depending on the plan you chose. Your subscription will automatically renew at the end of your term unless you cancel it.

We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details.

A Study & Exam Prep subscription includes video lessons, practice problems and other study tools. Get unlimited access to the full range of subjects:

  • General Chemistry
  • Physics
  • General Biology
  • Financial Accounting
  • Psychology
  • Microeconomics
  • Anatomy & Physiology
  • College Algebra
  • Organic Chemistry
  • Genetics
  • GOB Chemistry
  • Intro to Chemistry
  • Microbiology
  • Cell Biolog
  • Analytical Chemistry
  • Trigonometry
  • Precalculus
  • Biochemistry
  • Macroeconomics

    • Yes, the Study & Exam Prep Pack's feature is Channels, which can be purchased separately at any time. Simply go to Channels on the Pearson+ site and choose monthly, quarterly, or annual access, separate from your eTextbook subscription. Still deciding? Watch the first six videos free and buy it if you love it (we know you'll love it!).

    Currently, they are the exact same offering. 'Study & Exam Prep Pack' is what we call 'Channels' when it is bundled with an eTextbook or bundled with MyLab & Mastering courseware. When purchased on its own, you will see it called Channels, still the same study & exam prep help you need.