Construction Estimating Using Excel by Steven Peterson (2017, Trade Paperback)

Informazioni su questo prodotto

Product Identifiers

PublisherPearson Education

ISBN-100134405501

ISBN-139780134405506

eBay Product ID (ePID)235430260

Product Key Features

Number of Pages480 Pages

LanguageEnglish

Publication NameConstruction Estimating Using Excel

Publication Year2017

SubjectConstruction / General, Desktop Applications / Spreadsheets, Construction / Estimating

TypeTextbook

Subject AreaComputers, Technology & Engineering

AuthorSteven Peterson

FormatTrade Paperback

Dimensions

Item Height0.7 in

Item Weight49.6 Oz

Item Length10.8 in

Item Width8.5 in

Additional Product Features

Edition Number3

Intended AudienceCollege Audience

LCCN2016-042595

Dewey Edition23

IllustratedYes

Dewey Decimal692/.50285554

Table Of ContentPART 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 T

SynopsisFor 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/., 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/ .

LC Classification NumberTH437.P357 2018