Construction Estimating Using Excel

Cover
Title Page
Copyright Page
Preface
Brief Contents
Contents
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 Text
		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 Reference Books
		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
		Reference
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
	A
	B
	C
	D
	E
	F
	G
	H
	I
	J
	K
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
	X
Appendix G INDEX OF DRAWING SETS
INDEX
	A
	B
	C
	D
	E
	F
	G
	H
	I
	J
	K
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
	X
	Z