Muutke küpsiste eelistusi

Construction Estimating Using Excel 2nd edition [Multiple-component retail product]

  • Formaat: Multiple-component retail product, 432 pages, kõrgus x laius x paksus: 296x209x24 mm, kaal: 1218 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 21-Apr-2011
  • Kirjastus: Pearson
  • ISBN-10: 0138007195
  • ISBN-13: 9780138007195
Teised raamatud teemal:
  • Multiple-component retail product
  • Hind: 195,21 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Multiple-component retail product, 432 pages, kõrgus x laius x paksus: 296x209x24 mm, kaal: 1218 g, Contains 1 Paperback / softback and 1 CD-ROM
  • Ilmumisaeg: 21-Apr-2011
  • Kirjastus: Pearson
  • ISBN-10: 0138007195
  • ISBN-13: 9780138007195
Teised raamatud teemal:

Construction Estimating with Excel, Second Edition, introduces readers to the fundamental principles of estimating. Using drawing sets, real-world exercises, and examples, the text offers students critical estimating experience. 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.

PART I INTRODUCTION TO ESTIMATING
1(54)
Chapter 1 The Art Of Estimating
2(8)
The Estimator
2(1)
Types of Estimates
3(1)
Bid Package
4(3)
Estimating Tools
7(1)
Computerized Estimating
8(1)
Conclusion
9(1)
Problems
9(1)
References
9(1)
Chapter 2 Overview Of The Estimating And Bidding Process
10(8)
Planning the Bid
10(1)
Pre-Bid-Day Activities
10(4)
Bid-Day Activities
14(2)
Post-Bid Activities
16(1)
Conclusion
17(1)
Problems
17(1)
Chapter 3 Introduction To Excel
18(37)
Conventions Used in This Book
18(1)
Workbook Management
18(4)
Working with Worksheets
22(4)
Entering Data
26(4)
Formatting Worksheets
30(9)
Writing Formulas
39(2)
Basic Functions
41(5)
Printing
46(3)
Testing Spreadsheets
49(4)
Conclusion
53(1)
Problems
53(2)
PART II THE QUANTITY TAKEOFF
55(172)
Chapter 4 Fundamentals Of The Quantity Takeoff
56(10)
Performing a Quantity Takeoff
56(1)
Work Packages
57(1)
Communication with the Field
58(2)
Counted Items
60(1)
Linear Components
61(1)
Sheet and Roll Goods
61(2)
Volumetric Goods
63(1)
Quantity-From-Quantity Goods
64(1)
Waste
64(1)
Conclusion
65(1)
Problems
65(1)
Reference
65(1)
Chapter 5 Concrete
66(23)
Forms
66(1)
Reinforcing
67(1)
Concrete
67(1)
Spread Footings
68(1)
Columns
69(2)
Continuous Footings
71(5)
Foundation Walls
76(2)
Beams
78(1)
Slab on Grade
78(2)
Raised Slabs
80(1)
Stairs
81(1)
Sample Takeoff for the Residential Garage
82(3)
Conclusion
85(1)
Problems
85(4)
Chapter 6 Masonry
89(8)
Block and Structural Brick Walls
90(3)
Brick Veneer
93(1)
Conclusion
94(1)
Problems
94(3)
Chapter 7 Metals
97(11)
Types of Structural Steel
97(1)
Common Shapes for Structural Steel
97(1)
Beams, Girders, and Columns
98(2)
Joists and Joist Girders
100(2)
Metal Deck
102(1)
Steel Trusses
102(1)
Stairs and Handrail
102(1)
Miscellaneous Steel
103(1)
Conclusion
104(1)
Problems
104(4)
Chapter 8 Woods, Plastics, And Composites
108(26)
Floor Systems
108(5)
Walls
113(6)
Roof Systems
119(5)
Finish Carpentry
124(1)
Cabinetry and Countertops
124(1)
Sample Takeoff for the Residential Garage
125(2)
Conclusion
127(1)
Problems
127(6)
Reference
133(1)
Chapter 9 Thermal And Moisture Protection
134(19)
Waterproofing and Dampproofing
134(1)
Building Paper and Vapor Barriers
135(3)
Insulation
138(2)
Exterior Insulation Finish System
140(1)
Shingle Roofs
141(2)
Siding, Soffit, and Fascia
143(3)
Membrane Roofing
146(1)
Sample Takeoff for the Residential Garage
146(3)
Conclusion
149(1)
Problems
149(3)
References
152(1)
Chapter 10 Openings
153(9)
Doors
153(1)
Windows
153(2)
Commercial Storefront
155(1)
Glazing
156(1)
Hardware
157(1)
Sample Takeoff for the Residential Garage
157(1)
Conclusion
158(1)
Problems
158(3)
Reference
161(1)
Chapter 11 Finishes
162(10)
Metal Stud Partitions
162(1)
Gypsum Board
162(2)
Tile
164(1)
Suspended Acoustical Ceilings
165(1)
Wood and Laminate Floors
166(1)
Sheet Vinyl
167(1)
Vinyl Composition Tile
168(1)
Rubber Base
168(1)
Carpet and Pad
168(1)
Paint
168(1)
Sample Takeoff for the Residential Garage
169(1)
Conclusion
170(1)
Problems
170(2)
Chapter 12 Fire Suppression
172(4)
Conclusion 174(1)
Problems 174(204)
Chapter 13 Plumbing
176(5)
Water Supply
176(1)
Drain-Waste-and-Vent System
176(3)
Fixtures and Equipment
179(1)
Conclusion
179(1)
Problems
179(2)
Chapter 14 Heating, Ventilation, And Air-Conditioning (Hvac)
181(8)
Residential HVAC Systems
181(3)
Commercial HVAC Systems
184(2)
Conclusion
186(1)
Problems
186(3)
Chapter 15 Electrical
189(11)
Residential Wiring
189(1)
Commercial Wiring
190(3)
Sample Takeoff for the Residential Garage
193(3)
Conclusion
196(1)
Problems
196(4)
Chapter 16 Earthwork
200(14)
Characteristics of Soils
200(1)
Swell and Shrinkage
200(2)
Geometric Method
202(1)
Average-Width-Length-Depth Method
203(1)
Average-End Method
203(1)
Modified-Average-End Method
204(1)
Cross-Sectional Method
204(5)
Comparison of Methods
209(1)
Backfill
210(1)
Soils Report
210(1)
Sample Takeoff for the Residential Garage
210(2)
Conclusion
212(1)
Problems
212(2)
Chapter 17 Exterior Improvements
214(6)
Asphalt and Base
214(1)
Site Concrete
215(1)
Landscaping
215(1)
Sample Takeoff for the Residential Garage
216(1)
Conclusion
217(1)
Problems
217(3)
Chapter 18 Utilities
220(7)
Excavation
220(3)
Bedding
223(1)
Utility Lines
224(1)
Backfill
225(1)
Conclusion
225(1)
Problems
225(2)
PART III PUTTING COSTS TO THE ESTIMATE
227(54)
Chapter 19 Material Pricing
228(5)
Shipping Costs
229(1)
Sales Tax
230(1)
Storage Costs
230(1)
Escalation
230(1)
Conclusion
231(1)
Problems
231(2)
Chapter 20 Labor Productivity And Hours
233(7)
Factors Affecting Labor Productivity
233(2)
Historical Data
235(1)
Field Observations
235(3)
National Standards
238(1)
Labor Hours
238(1)
Conclusion
238(1)
Problems
238(1)
Reference
239(1)
Chapter 21 Labor Rates
240(8)
Billable Hours
240(1)
Wages
240(1)
Cash Equivalents and Allowances
241(1)
Payroll Taxes
242(1)
Unemployment Insurance
242(2)
Workers' Compensation Insurance
244(1)
General Liability Insurance
244(1)
Insurance Benefits
244(1)
Retirement Contributions
245(1)
Union Payments
245(1)
Other Benefits
245(1)
Annual Costs and Burden Markup
245(2)
Conclusion
247(1)
Problems
247(1)
References
247(1)
Chapter 22 Equipment Costs
248(6)
Depreciation and Interest
248(1)
Taxes and Licensing
249(1)
Insurance
249(1)
Storage
249(1)
Hourly Ownership Cost
249(1)
Tires and Other Wear Items
250(1)
Fuel
250(1)
Lubricants and Filters
250(1)
Repair Reserve
251(1)
Leased Equipment
251(1)
Rented Equipment
251(1)
Conclusion
252(1)
Problems
252(2)
Chapter 23 Crew Rates
254(3)
Conclusion
256(1)
Problems
256(1)
Chapter 24 Subcontract Pricing
257(4)
Request for Quote
257(1)
Writing a Scope of Work
258(1)
Historical
259(1)
Bid Selection
259(1)
Conclusion
259(1)
Problems
260(1)
Chapter 25 Markups
261(6)
Building Permits
261(2)
Payment and Performance Bonds
263(1)
Profit and Overhead
263(2)
Conclusion
265(1)
Problems
265(1)
Reference
266(1)
Chapter 26 Pricing Extensions
267(10)
Detail Worksheet
267(1)
Material Costs
267(1)
Labor Costs
268(1)
Equipment Costs
268(1)
Total Cost
269(1)
Summary Worksheet
269(3)
Sample Estimate: The Residential Garage
272(4)
Conclusion
276(1)
Problems
276(1)
Chapter 27 Avoiding Errors In Estimates
277(4)
List Cost Codes
277(1)
Spend More Time on Large Costs
277(1)
Prepare Detailed Estimates
277(1)
Mark Items Counted during the Quantity Takeoff
278(1)
Double-Check All Takeoffs
278(1)
Include Units in Calculations
278(1)
Automate with Spreadsheets
278(1)
Use Well-Tested and Checked Formulas
278(1)
Double-Check All Calculations
279(1)
Perform Calculations in Two Ways
279(1)
Drop the Pennies
279(1)
Have Someone Review the Estimate
279(1)
Review Each Cost Code as a Percentage of the Total Cost
279(1)
Check Unit Costs for Each Cost Code
279(1)
Compare Costs to Those for Another Project
279(1)
Allow Plenty of Time
279(1)
Conclusion
280(1)
Problems
280(1)
PART IV FINALIZING THE BID
281(16)
Chapter 28 Submitting The Bid
282(7)
Bid Submission with Standardized Documents
282(1)
Writing a Proposal
282(3)
Writing a Business Letter
285(1)
Letter Formats
286(1)
Writing E-mails
286(2)
Conclusion
288(1)
Problems
288(1)
Chapter 29 Project Buyout
289(4)
Subcontracts
289(2)
Purchase Orders
291(1)
Contracts for Materials
292(1)
Conclusion
292(1)
Problems
292(1)
Chapter 30 The Estimate As The Basis Of The Schedule
293(2)
Estimating Durations
293(1)
Sample Durations: The Residential Garage
294(1)
Conclusion
294(1)
Problems
294(1)
Chapter 31 Ethics
295(2)
Work Ethic
295(1)
Bidding Practices
296(1)
Loyalty to Employer
296(1)
Ethical Dilemmas
296(1)
Conclusion
296(1)
Problems
296(1)
Reference
296(1)
PART V ADVANCED ESTIMATING WITH EXCEL
297(44)
Chapter 32 Converting Existing Forms
298(17)
Creating the Layout
298(1)
Adding Formulas
298(3)
Automating with Macros
301(5)
Testing the Worksheets
306(1)
Adding Error Protection
307(7)
Conclusion
314(1)
Problems
314(1)
Chapter 33 Creating New Forms
315(23)
Planning New Forms
315(4)
Setting Up the Spreadsheet
319(1)
Series
320(3)
Naming Cells
323(2)
Adding Dropdown Boxes
325(3)
Referencing Worksheets in a Formula
328(1)
Concatenate
329(3)
LOOKUP and VLOOKUP
332(5)
Conclusion
337(40)
Problems
377
Chapter 34 Proposals And Beyond
338(3)
And Beyond...
340(1)
APPENDIX A REVIEW OF ESTIMATING MATH
341(13)
Lengths
341(1)
Scaling
342(2)
Pythagorean Theorem
344(1)
Areas
344(6)
Volumes
350(2)
Conversion Factors
352(2)
APPENDIX B SAMPLE JOB COST CODES
354(5)
APPENDIX C SAMPLE LABOR PRODUCTIVITY RATES
359(5)
APPENDIX D MODEL SCOPES OF WORK
364(6)
Footings and Foundations
364(1)
Framing
364(1)
Finish Carpentry
365(1)
Drywall
365(1)
Floor Coverings
366(1)
Painting and Staining
366(1)
Fire Sprinklers
367(1)
Plumbing
367(1)
HVAC
367(1)
Electrical
368(1)
Earthwork and Utilities---Roads and Parking Lots
368(1)
Landscaping
369(1)
APPENDIX E GLOSSARY
370(7)
APPENDIX F INDEX OF DRAWING SETS
377(1)
Index 378