Date: 2/16/2011
CLIENT PROJECT NAME
Page 1 of 1
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use. Paint Quantity Take-off Worksheet Project: ___________________ Take-off by: _______________ Room Length Description
(LF)
Date: ___________________ Checked by: __________ Room Width
(LF)
Clear Values from previous calculations for each Page: ____ of _____
Room Height
(LF)
Paint Coats
(EA)
Wall Ceiling Coverage Paint Area Paint Area Per Gallon
(SF) (SF) Walls (SF)
Gallons Required
Walls (EA)
Coverage Per Gallon
Ceiling(SF)
Gallons Required
Ceiling (EA)
Reference Drawing #
NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.
Living Room
12
12
384 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
144 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 144
150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 4500
2.56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.56
150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 4500
0.96 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.96
A-101
Room Finish Calculator
Enter Area Measurements in Colored Areas to obtain Net Footages
Room Length Room Width Room Height Results Floor Area (net) Floor Base (net) Wall Area (net) Ceiling Area (net)
12 12 8
Feet Feet Feet
144 48 384 144
Square Feet Linear Feet Square Feet Square Feet
Total
384
Date: 2/16/2011
CLIENT PROJECT NAME
Page 1 of 1
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Flooring Quantity Take-off Worksheet Project: ___________________ Take-off by: _______________ Description Living Room Flooring Type Room Length (LF) 12 20 Date: ___________________ Checked by: __________ Room Width (LF) Floor Area Floor Base Reference Drawing # (SF) 240 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 (LF) 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 After takeoff is complete, Sort on Flooring Type to group like areas together. Results Floor Area (net) Floor Base (net) Wall Area (net) Ceiling Area (net) 240 64 512 240 Square Feet Linear Feet Square Feet Square Feet
Enter Area Measurements in Colored Areas to obtain Net Footages Clear Values from previous calculations for each new Page: ____ of _____
NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.
Room Finish Calculator
Room Length Room Width Room Height
20 12 8
Feet Feet Feet
Page 1 of 1
Company Name
PROJECT ESTIMATING
4:29 AM on 2/16/2011 Excel Estimating Worksheets Samples 2-16-11
Clear Valu Type Flooring es Wood 1 Wood 1 Wood 1 Wood 1 Wood 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Carpet 1 Vinyl1 Vinyl 2 Vinyl 2 Vinyl 2
Width Living Room LR Closet LR Ext Family Room Family Room Ext Hall Hall Closet 1 Hall Closet 2 Master Bedroom MB Closet Bedroom 2 BR 2 Closet Bedroom 3 BR 3 Closet Bedroom 4 BD 4 Closet Laundry Room StairTreads Stair Riser Number of Stairs 16 4 4 12 8 4 3 3 12 3 11 4 12 3 11 3 8 4 4 8
Length 16 7 7 20 10 32 2 3 14 6 11 5 12 8 11 8 12 1 1
Square Feet 256 28 28 240 80 128 6 9 168 18 121 20 144 24 121 24 96 4 4
Square Feet Per Area
Width
Gross Length
Length Adj
Square Yds Required
Notes: EACH AREA MUST BE CONSIDERED AND MANUALLY ADJUSTED TO ENSURE ACCURACY. Sample measurements are included to demostrate how the table works. Remove all numbers before starting. Round up inches to the nearest foot.
312
12
30
42.7
320
12
30
40.0 An area's square footage is determined by multiplying its length times width. Lengths of Standard 12' wide Sheets may be reduced by adjusting for areas that can be cut from the same 12' wide section. Lengths must also be adjusted to account for widths greater than 12' wide. The total requirement can be further reduced by combining areas if the same type and color is used in all areas. Using the Living Room as an example: A) Since the main area is 16' wide, a 4' wide piece will need to be seamed to a 12' wide section for 16' B) Both the 4' LR Ext and the LR Closet can be cut from the excess from the 8' that is left in this section This results in a net reduction of 2' in length (+ 16' & - 14' = 2' Add) Irregularly shaped areas are measured by dividing the area into individual sections and calculating the square footage in each one
143
12
37
-2
46.7
186
12
20
26.7
141
12
16
21.3
168
12
20
26.7
145 96
12 12
19 12
0 0
25.3 16.0
64
12
8.0
10% Add for Waste: TOTAL GROSS SQUARE FOOTAGE: 1575 TOTAL GROSS SQUARE YARDS:
24.5 277.9
Room Finish Calculator
Enter Area Measurements in Colored Areas to obtain Net Footages
Room Length Room Width Room Height Results Floor Area (net) Floor Base (net) Wall Area (net) Ceiling Area (net)
12 12 8
Feet Feet Feet
144 48 384 144
Square Feet Linear Feet Square Feet Square Feet
Date: 2/16/2011
CLIENT PROJECT NAME
Page 1 of 1
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use. Stucco Quantity Take-off Worksheet Project: ___________________ Take-off by: _______________ Description West Ext Wall 2 40 Date: ___________________ Checked by: __________ Lath Type Reference Drawing # 10 400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Clear Values from previous calculations for eac Page: ____ of _____
Thickness (IN) Length (LF) Height (LF) Wall Area (SF) Mortar (CF)
Date: 2/16/2011
CLIENT PROJECT NAME
Page 1 of 1
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Drywall Quantity Take-off Worksheet Project: ___________________ Date: ___________________
Clear Values from previous calculations for each new me Page: ____ of _____
Take-off by: _______________ Checked by: __________ Bd Size / Width / Description Length (LF) Layers (EA) Wall Area (SF) Thickness Height (LF) LR Wall 1 LR Wall 2 LR Wall 3 LR Wall 4 LR Ceiling 5/8" - 4'x8' 5/8" - 4'x8' 5/8" - 4'x8' 5/8" - 4'x8' 5/8" - 4'x8' 14.00 9.00 14.00 9.00 12.00 9.00 12.00 9.00 14.00 12.00 1 1 1 1 1 126 126 108 108 168 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 636
Net Board SF 126 126 108 108 168 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 636
Reference Drawing #
NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.
Room Finish Calculator
Enter Area Measurements in Colored Areas to obtain Net Footages
Room Length Room Width Room Height Results Floor Area (net) Floor Base (net) Wall Area (net) Ceiling Area (net)
20 12 8
Feet Feet Feet
240 64 512 240
Square Feet Linear Feet Square Feet Square Feet
After takeoff is complete, Sort on Board Type to group like areas together.
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Concrete Calculator
Clear Values from previous calculations for each new measurement.
Slabs
Slab Length Slab Width Slab Thickness Type Total: Net Amount Required: Feet Feet Inches
Cubic Yards
Walls
Wall Length Wall Height Wall Thickness Type Total: Net Amount Required: Feet Feet Inches
Cubic Yards Units Feet Inches Inches
Continuous Footings
Footing Length Footing Width Footing Depth Type Total: Net Amount Required:
Cubic Yards
Spread Footing
Footing Quantity Footing Length Footing Width Footing Depth Type Total: Net Amount Required: EA Feet Feet Feet
Cubic Yards
Beams
Beam Length Beam Width Beam Height Type Total: Net Amount Required: Feet Inches Inches
Cubic Yards
Square Columns
Column Quantity Column Height Column Size Type Total: Net Amount Required: EA Feet Inches
Cubic Yards
Round Columns
Column Quantity Column Height Column Diameter Type Total: Net Amount Required: EA Feet Inches
Cubic Yards
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Concrete Continuous Footing Quantity Take-off Worksheet
Project:
measurement.
NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.
Date: Page: Checked by: Footing Width (LF) 2 2 Footing Excavation Excavation Concrete Formwork Depth Depth Volume Volume (LF) (LF) (CY) (SFCA) (CY) 2 2 4 4 11.9 8.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 88 68 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 156.0 3.0 2.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5.2 Rebar Size (#) 4 4 No. Hoz Bars 6 6 Rebar Weight Per LF 0.00034 0.00034 Rebar Weight (Ton) 0.04 0.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.1 Backfill Volume (CY) 11.6 8.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 20.2 Vertical Rebar, Cross Ties, Wire & other Concrete Accessories must be calculated manually Horizontal Rebar Size & Rebar Weights must be entered manually from the Chart Below: Rebar Weights: Size Weight in Tons per LF #3 .00019 tn lnft #4 .00034 tn lnft #5 .00052 tn lnft #6 .00075 tn lnft #7 .00102 tn lnft #8 .00134 tn lnft #9 .00170 tn lnft #10 .00210 tn lnft SFCA = Square Foot of Contact Area
Take-off by: Footing Description Length (LF) Section 1A Section 2A 20 15
Backfill Volume is based on adding 30% for Compaction
Total
20.7
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Concrete Pad Quantity Take-off Worksheet
Project:
measurement.
NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.
Date: Page: Checked by: Pad Width (LF) 12 20 Pad Depth (IN) 4 4 Excavation Excavation Concrete Formwork Depth Volume Volume (LF) (CY) (SFCA) (CY) 4 4 11.9 14.8 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 248.00 760.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1008.00 3.0 3.7 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 6.7 Rebar Size (#) 4 4 No. Hoz Bars 6 6 Rebar Weight Per LF 0.00034 0.00034 Rebar Weight (Ton) 0.04 0.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.1 Backfill Volume (CY) 11.6 14.4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 26.0 Vertical Rebar, Cross Ties, Wire & other Concrete Accessories must be calculated manually Horizontal Rebar Size & Rebar Weights must be entered manually from the Chart Below: Rebar Weights: Size Weight in Tons per LF #3 .00019 tn lnft #4 .00034 tn lnft #5 .00052 tn lnft #6 .00075 tn lnft #7 .00102 tn lnft #8 .00134 tn lnft #9 .00170 tn lnft #10 .00210 tn lnft SFCA = Square Foot of Contact Area
Take-off by: Pad Description Length (LF) Pad 1 Pad 2 20 15
Backfill Volume is based on adding 30% for Compaction
Total
26.7
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use. Roofing Quantity Take-off Worksheet Project: ___________________ Take-off by: _______________ Date: ___________________ Page: ____ of _____ Clear Values from previous calculation Checked by: __________ Slope Description RUN (LF) SPAN (LF) Area (SF) (__ in 12) Sample 1 10 20 4 210.82 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Waste % 10% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
In SQ 2.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Comments
GENERAL NOTES ON MEASURING ROOFS: Flat Roofs If the roof is flat or has no more than a 3 in 12 pitch, calculate its total square footage by simply multiplying the length by the width. A Square is equal to 100 Square Feet. Steeper Roofs Measure the structure at ground level and add the roofs overhang. As an example, if the roof overhang is 12 inches, add 2 feet to the overall length and 2 feet to the overall width. The total nominal square footage is multiplied by a factor associated with the roofs pitch. Pitch Multiply by: 4 in 12 1.06 5 in 12 1.08 6 in 12 1.12 7 in 12 1.16 8 in 12 1.20 9 in 12 1.25 10 in 12 1.30 11 in 12 1.36 12 in 12 1.42
Structural Steel Quantity Take-off Worksheet Project: ___________________ Take-off by: _______________ Shape Reference Designation (EA) (LF) Date: ___________________ ____ of _____ Checked by: __________ (LB/LF) (LB)
Clear Values from previous calculations for each new m Page:
No. of Shapes Shape Length Shape Unit Weight Shape Weight
Total
Steel Decking Quantity Take-off Worksheet Project: ___________________ Take-off by: _______________ Reference Gauge (LF) (LF) Date: ___________________ ____ of _____ Lap Deck Area (LF) (SF) Checked by: __________ Pitch (LF)
Clear Values from previous calculations for ea Page:
Deck Length Deck Width Overhang
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use. General Quantity Take-off Worksheet Project: __________________ Section: ___________________ Item Description Date: ______________ of ________ Takeoff by _________ Extension
Clear Values from previous calculat Page ___
Details Length Width Height Count
Total
HVAC Equipment Quantity Take-off Worksheet Project: _______________ Date: ______________
Clear Values from previousPage ___
of ________
Section: ______________ Takeoff by _________ System Item Capacities/Dimensions Quantity
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility HVAC Piping Quantity Take-off Worksheet Project: __________________ Section: ___________________ System 1/8" 1/4" 3/8" 1/2" 3/4" 1" 1-1/4" 1-1/2" 2" Date: ______________ ___ of ________ Takeoff by _________ Pipe Diameter 2-1/2" 3" 4" 5" 6" 8" 10" 12" 15" Misc.
Clear Values from previous calculations for each new measuremenPage
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use. HVAC Ductwork Quantity Take-off Worksheet Project: __________________ Section: ___________________ Gauge Size Lining Insulation Date: ______________ of ________ Total Lbs/Ft Total Lbs Takeoff by _________ Length
Clear Values from previous calculations for each nPage ___
Total
The Author of these Worksheet Templates makes no guarantees to th based on the formulas or formats provided in these Worksheets and their use. HVAC Accessories Quantity Take-off Worksheet Project: __________________ Section: ___________________ Items Date: ______________ of ________ Quantity Takeoff by _________
Clear Values from previous calculatio Page ___
Dimension/Description
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use. Plumbing Fixture Quantity Take-off Worksheet Project: __________________
Clear Values from previous calculations
Date: ______________ Page ___ of ________ Takeoff by _________ Floor Level 3rd 4th 5th Roof
Section: ___________________ Fixture Type Basement 1st 2nd
Total
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimate formulas or formats provided in these Worksheets and takes no responsibility for thei
Plumbing Valves/Fittings Quantity Take-off Worksheet
Project:
Clear Values from previous calculations for each new
Date: Page: Take-off by: of
Section:
Items
Material Description Etc.
Quantity
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Dimensional Lumber Quantity Take-off Worksheet
Project:
ew measurement.
Date: Page: Checked by: Grade 2 QTY (EA) 34 Length (LF) 8 Dim (IN) 2 X X X X X X X X X X X X X X X X X X X X X X X X X Dim (IN) 4 Extension (BF) 181.33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 of
Take-off by:: Description LR N. Frame
Total
The Author of these Worksheet Templates makes no guarantees to the accuracy of any estimates based on the formulas or formats provided in these Worksheets and takes no responsibility for their use.
Plywood Quantity Take-off Worksheet
Project:
w measurement.
Date: Page: Checked by: Grade CDX QTY (EA) 1 Thickness (IN) 5/8 Length (LF) 20 Width (LF) 30 Extension (SF) 600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sheets (EA) 18.75 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 of
Take-off by:: Description LR Floor
Total
