Construction Estimating Using Excel, 3rd edition

Teaches basic estimating principles, step-by-step, in a way that can apply to a variety of building materials.

• Moves beyond many books to not only talk about takeoff (and the costs of a limited number of building materials), but also the principles behind these calculations.

• Gives readers a strong foundation so they can transfer basic estimating principles to any building material.

• Includes a running case study that shows students the complete process of creating an estimate for a residential garage.

Shows how to use Microsoft Excel as an estimating tool to improve one’s quality and accuracy.

• Provides an introduction to the basic operation of Excel and discusses how it can be used to improve the estimating process.

• Includes Excel Quick Tips that demonstrate how to set up Excel worksheets for different types of estimating problems, 44 sample spreadsheets, 12 homework problems that require the reader to modify the sample spreadsheet, and a final complex spreadsheet that the student prepares for a bid.

UPDATED: Bases thediscussion of Excel (including the figures) on Excel 2016 to keep students current with the latest software.

Offers unparalleled support to instructors with a robust Instructor Resource Center featuring over 1,100 files. Resources include:

• An instructor’s manual with learning outcomes, instructional hints, activities, resources, and solutions to the problems for each chapter.

• PDFs of the drawing sets for use with On-Screen Takeoff or other such software

• A bid day simulation

• Solutions to the exercise from Chapter 2, 32, and 33

• JPG copies of select figures in the book–many of which include their original format (e.g., AutoCAD drawings) that can be edited to create additional problems

• Customizable PowerPoint lectures

• Electronic copies of the Quick Tips from the book

• A test bank of over 290 questions

UPDATED: Makes it easier for instructors to measure outcomes with updated content that aligns to ACCE and ABET student learning outcomes

• Lists the common outcomes found in the accreditation standards that cover estimating and what problems/material from the chapters can be used to measure proficiency of each of the outcomes (See the updated Instructor’s Manual and chapters 2, 5-19, 21-26, 28 and 29).

Divides the discussion of quantity takeoff is into five groups–counted items, linear components, sheet and roll goods, volumetric goods, and quantity-from-quantity goods.

• Allows students to learn to estimate materials that are not covered by the book by determining which group they best fit into and using the estimating principals for that group.

Includes two drawing sets as a means for additional practice in preparing a complete estimate from beginning to end.

• Offers a variety of projects (a residence and a retail building) where readers can practice estimating skills in a realistic environment.

Provides quick and convenient references for students.

• Includes fundamental mathematical concepts necessary in estimating for those students who may need a review of estimating math (Appendix A).

NEW: Includes sample equipment costs that students can reference for use in their estimates (Appendix D).

Offers example problems and exercises designed to help beginning estimators apply the information and techniques presented in the book.

• Gives the reader a variety of opportunities to practice principles learned in the text.

• Provides detailed solutions to problems in the accompanying Instructor’s Manual.

UPDATED: Expands the problem sets for estimating labor and equipment costs (Chapters 21 and 22).

UPDATED: Expands the coverage of estimating to design-build and construction manager general contractor projects, which make up about 50% of commercial construction market

• Discusses the role estimating plays in the different project delivery methods and the role estimating plays in the design process in a new chapter. This chapter also covers the project-comparison, square-foot, and assembly estimating methods (Chapter 34).

NEW: Gives students experience using data from RSMeans, one of the largest publisher of construction cost data.

• Uses data from RSMeans (along with six sample pages from their books) throughout this edition (Figures 20-1, 34-1, 34-2, 34-3, 34-4, and 34-5).

UPDATED: Refreshes content to reflect current practices and realities.

• Reflects current costs with updated material and equipment costs and labor rates (Chapters 19, 21-23, and 26).

• Gives the student a better understanding of the laws governing employee compensation and overtime with a new discussion of the Fair Labor Standards Act (Chapter 21).

• Covers the pay rates for employees on projects funded by the federal government with a new discussion of the Davis-Bacon Act (Chapter 21).

Shows how to use Microsoft Excel as an estimating tool to improve one’s quality and accuracy.

• Bases thediscussion of Excel (including the figures) on Excel 2016 to keep students current with the latest software.

Makes it easier for instructors to measure outcomes with updated content that aligns to ACCE and ABET student learning outcomes

• Lists the common outcomes found in the accreditation standards that cover estimating and what problems/material from the chapters can be used to measure proficiency of each of the outcomes (See the updated Instructor’s Manual and chapters 2, 5-19, 21-26, 28 and 29).

Provides quick and convenient references for students.

• Includes sample equipment costs that students can reference for use in their estimates (Appendix D).

Offers example problems and exercises designed to help beginning estimators apply the information and techniques presented in the book.

• Expands the problem sets for estimating labor and equipment costs (Chapters 21 and 22).

Expands the coverage of estimating to design-build and construction manager general contractor projects, which make up about 50% of commercial construction market

• Discusses the role estimating plays in the different project delivery methods and the role estimating plays in the design process in a new chapter. This chapter also covers the project-comparison, square-foot, and assembly estimating methods (Chapter 34).

Gives students experience using data from RSMeans, one of the largest publisher of construction cost data.

• Uses data from RSMeans (along with six sample pages from their books) throughout this edition (Figures 20-1, 34-1, 34-2, 34-3, 34-4, and 34-5).

Refreshes content to reflect current practices and realities.

Reflects current costs with updated material and equipment costs and labor rates (Chapters 19, 21-23, and 26).