• No results found

Excel Worksheet Samples

N/A
N/A
Protected

Academic year: 2021

Share "Excel Worksheet Samples"

Copied!
20
0
0

Loading.... (view fulltext now)

Full text

(1)

Date: 2/16/2011 CLIENT PROJECT NAME Page 1 of 1

Room

Length

Room

Width

Room Height Paint Coats

Wall

Paint Area

Ceiling

Paint Area

Coverage

Per Gallon

Gallons

Required

Coverage

Per Gallon

Gallons

Required

Reference Drawing #

(LF) (LF) (LF) (EA) (SF) (SF) Walls (SF) Walls (EA) Ceiling(SF) Ceiling (EA)

Living Room

12

12

8

1

384

144

150

2.56

150

0.96

A-101

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

Room Length

12

Feet

0

0

150

0

150

0

Room Width

12

Feet

0

0

150

0

150

0

Room Height

8

Feet

0

0

150

0

150

0

0

0

150

0

150

0

Results

0

0

150

0

150

0

Floor Area (net)

144

Square Feet

0

0

150

0

150

0

Floor Base (net)

48

Linear Feet

0

0

150

0

150

0

Wall Area (net)

384

Square Feet

0

0

150

0

150

0

Ceiling Area (net)

144

Square Feet

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

0

0

150

0

150

0

Total

384

144

4500

2.56

4500

0.96

Checked by: __________

Project: ___________________

Clear Values from previous calculations for each

Take-off by: _______________

NOTE: REMOVE SAMPLE MEASUREMENTS

BEFORE STARTING PROJECT TAKE-OFFS.

Room Finish Calculator

Enter Area Measurements in Colored Areas to obtain Net Footages

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

Description

Date: ___________________

Page: ____ of _____

(2)

Date: 2/16/2011 CLIENT PROJECT NAME

Page 1 of 1

Room Length

Room Width

Floor Area Floor Base Reference Drawing #

(LF)

(LF)

(SF)

(LF)

Living Room

12

20

240

64

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Room Length

20

Feet

0

0

Room Width

12

Feet

0

0

Room Height

8

Feet

0

0

0

0

Results

0

0

Floor Area (net)

240

Square Feet

0

0

Floor Base (net)

64

Linear Feet

0

0

Wall Area (net)

512

Square Feet

0

0

Ceiling Area (net)

240

Square Feet

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

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

0

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.

After takeoff is complete, Sort on Flooring Type to

group like areas together.

Description

Flooring Type

NOTE: REMOVE SAMPLE MEASUREMENTS

BEFORE STARTING PROJECT TAKE-OFFS.

Room Finish Calculator

Enter Area Measurements in Colored Areas to obtain Net Footages

Flooring Quantity Take-off Worksheet

Date: ___________________

Page: ____ of _____

Checked by: __________

Project: ___________________

Clear Values from previous calculations for each new

(3)

Page 1 of 1

Company Name

PROJECT ESTIMATING

4:29 AM on 2/16/2011 Excel Estimating Worksheets Samples 2-16-11

Clear Valu

es

Type Flooring Width Length Square Feet Square FeetPer Area Width Gross Length Length Adj Square Yds Required

Wood 1 Living Room 16 16 256

Wood 1 LR Closet 4 7 28

Wood 1 LR Ext 4 7 28 312 12 30 2 42.7

Wood 1 Family Room 12 20 240

Wood 1 Family Room Ext 8 10 80 320 12 30 0 40.0

Carpet 1 Hall 4 32 128

Carpet 1 Hall Closet 1 3 2 6

Carpet 1 Hall Closet 2 3 3 9 143 12 37 -2 46.7

Carpet 1 Master Bedroom 12 14 168

Carpet 1 MB Closet 3 6 18 186 12 20 0 26.7 Carpet 1 Bedroom 2 11 11 121 Carpet 1 BR 2 Closet 4 5 20 141 12 16 0 21.3 Carpet 1 Bedroom 3 12 12 144 Carpet 1 BR 3 Closet 3 8 24 168 12 20 0 26.7 Carpet 1 Bedroom 4 11 11 121 Carpet 1 BD 4 Closet 3 8 24 145 12 19 0 25.3

Vinyl1 Laundry Room 8 12 96 96 12 12 0 16.0

Vinyl 2 StairTreads 4 1 4 Vinyl 2 Stair Riser 4 1 4

Vinyl 2 Number of Stairs 8 64 12 6 0 8.0

10% Add for Waste: 24.5 TOTAL GROSS SQUARE FOOTAGE: 1575 TOTAL GROSS SQUARE YARDS: 277.9

Room Length 12 Feet

Room Width 12 Feet

Room Height 8 Feet

Results

Floor Area (net) 144 Square Feet Floor Base (net) 48 Linear Feet Wall Area (net) 384 Square Feet Ceiling Area (net) 144 Square Feet 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.

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

Room Finish Calculator

Enter Area Measurements in Colored Areas to obtain Net Footages

(4)

Date: 2/16/2011

CLIENT

PROJECT NAME

Page 1 of 1

Description

Thickness (IN) Length (LF) Height (LF) Wall Area (SF) Mortar (CF)

Lath Type

Reference Drawing #

West Ext Wall

2 40

10

400

66.67

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

0

0.00

Checked by: __________

Project: ___________________

Clear Values from previous calculations for eac

Take-off by: _______________

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

Date: ___________________

Page: ____ of _____

(5)

Date: 2/16/2011 CLIENT PROJECT NAME Page 1 of 1 Description Bd Size / Thickness Length (LF) Width /

Height (LF)Layers (EA) Wall Area (SF)

Net Board SF Reference Drawing # LR Wall 1 5/8" - 4'x8' 14.00 9.00 1 126 126 LR Wall 2 5/8" - 4'x8' 14.00 9.00 1 126 126 LR Wall 3 5/8" - 4'x8' 12.00 9.00 1 108 108 LR Wall 4 5/8" - 4'x8' 12.00 9.00 1 108 108 LR Ceiling 5/8" - 4'x8' 14.00 12.00 1 168 168 0 0 0 0 0 0 0 0

0 0 Room Length 20 Feet

0 0 Room Width 12 Feet

0 0 Room Height 8 Feet

0 0

0 0 Results

0 0 Floor Area (net) 240 Square Feet

0 0 Floor Base (net) 64 Linear Feet

0 0 Wall Area (net) 512 Square Feet

0 0 Ceiling Area (net) 240 Square Feet

0 0 0 0 0 0 0 0 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 636 Date: ___________________ Page: ____ of _____ Checked by: __________ Project: ___________________

Clear Values from previous calculations for each new me

Take-off by: _______________

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.

After takeoff is complete, Sort on Board Type to group like areas together.

NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.

Room Finish Calculator

Enter Area Measurements in Colored Areas to obtain Net Footages

(6)

Slabs

Slab Length

Feet

Slab Width

Feet

Slab Thickness

Inches

Type Total:

Net Amount Required:

0

Cubic Yards

Walls

Wall Length

Feet

Wall Height

Feet

Wall Thickness

Inches

Type Total:

Net Amount Required:

0

Cubic Yards

Continuous Footings

Units

Footing Length

Feet

Footing Width

Inches

Footing Depth

Inches

Type Total:

Net Amount Required:

0

Cubic Yards

Spread Footing

Footing Quantity

EA

Footing Length

Feet

Footing Width

Feet

Footing Depth

Feet

Type Total:

Net Amount Required:

0

Cubic Yards

Beams

Beam Length

Feet

Beam Width

Inches

Beam Height

Inches

Type Total:

Net Amount Required:

0

Cubic Yards

Square Columns

Column Quantity

EA

Column Height

Feet

Column Size

Inches

Type Total:

Net Amount Required:

0

Cubic Yards

Round Columns

Column Quantity

EA

Column Height

Feet

Column Diameter

Inches

Type Total:

Net Amount Required:

0

Cubic Yards

Concrete Calculator

Clear Values from previous calculations for each new measurement.

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.

(7)

Project: Date:

measurement. Page:

Take-off by: Checked by:

Footing Footing Footing Excavation Excavation Concrete Rebar No. Rebar Rebar Backfill

Length Width Depth Depth Volume Volume Size Hoz Weight Weight Volume

(LF) (LF) (LF) (LF) (CY) (SFCA) (CY) (#) Bars Per LF (Ton) (CY)

Section 1A 20 2 2 4 11.9 88 3.0 4 6 0.00034 0.04 11.6 Section 2A 15 2 2 4 8.9 68 2.2 4 6 0.00034 0.03 8.7 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 0.0 0 0.0 0.00 0.0 Total 20.7 156.0 5.2 0.1 20.2

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.

Backfill Volume is based on adding 30% for Compaction

Horizontal Rebar Size & Rebar Weights must be entered manually from the Chart Below:

Vertical Rebar, Cross Ties, Wire & other Concrete Accessories must be calculated manually NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.

SFCA = Square Foot of Contact Area

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 Formwork Description

(8)

Project: Date:

measurement. Page:

Take-off by: Checked by:

Pad Pad Pad Excavation Excavation Concrete Rebar No. Rebar Rebar Backfill

Length Width Depth Depth Volume Volume Size Hoz Weight Weight Volume

(LF) (LF) (IN) (LF) (CY) (SFCA) (CY) (#) Bars Per LF (Ton) (CY)

Pad 1 20 12 4 4 11.9 248.00 3.0 4 6 0.00034 0.04 11.6 Pad 2 15 20 4 4 14.8 760.00 3.7 4 6 0.00034 0.03 14.4 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 0.0 0.00 0.0 0.00 0.0 Total 26.7 1008.00 6.7 0.1 26.0

Backfill Volume is based on adding 30% for Compaction

Horizontal Rebar Size & Rebar Weights must be entered manually from the Chart Below:

Vertical Rebar, Cross Ties, Wire & other Concrete Accessories must be calculated manually NOTE: REMOVE SAMPLE MEASUREMENTS BEFORE STARTING PROJECT TAKE-OFFS.

SFCA = Square Foot of Contact Area

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

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.

Formwork Description

(9)

Description RUN (LF) SPAN (LF)

Slope

(__ in 12)

Area (SF)

Waste

%

In SQ

Comments

Sample 1

10

20

4

210.82

10%

2.3

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

Total

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

0.00

0%

0.0

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 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 roof’s 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 roof’s 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

Roofing Quantity Take-off Worksheet

Date: ___________________

Page: ____ of _____

Checked by: __________

Project: ___________________

Clear Values from previous calculation

(10)

Shape

No. of Shapes Shape Length Shape Unit Weight Shape Weight

Designation

(EA)

(LF)

(LB/LF)

(LB)

Total

Reference

Structural Steel Quantity Take-off Worksheet

Take-off by: _______________

Checked by: __________

Project: ___________________

Date: ___________________

(11)

Deck Length Deck Width Overhang

Lap Deck Area

(LF)

(LF)

(LF)

(LF)

(SF)

Total

Take-off by: _______________

Project: ___________________

Clear Values from previous calculations for ea

Reference Gauge

Pitch

Steel Decking Quantity Take-off Worksheet

Page: ____ of _____

Checked by: __________

Date: ___________________

(12)

Length Width Height Count

Total

Date: ______________

Page ___ of ________

Takeoff by _________

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

Item Description

Details

Extension

Project: __________________

Clear Values from previous calculat

Section: ___________________

(13)

System

Item

Capacities/Dimensions Quantity

Total

Section: ______________

Date: ______________

Page ___ of ________

Takeoff by _________

HVAC Equipment Quantity Take-off Worksheet

Project: _______________

(14)

1/8" 1/4" 3/8" 1/2" 3/4" 1"

1-1/4" 1-1/2" 2"

2-1/2" 3"

4"

5"

6"

8"

10"

12"

15"

Total

Takeoff by _________

Misc.

System

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

Pipe Diameter

Project: __________________

Clear Values from previous calculations for each new measuremen

Section: ___________________

Date: ______________

Page ___ of ________

(15)

Gauge

Size

Lining

Insulation

Length

Total

Lbs/Ft

Total Lbs

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.

Date: ______________

Page ___ of ________

Takeoff by _________

HVAC Ductwork Quantity Take-off Worksheet

Project: __________________

Clear Values from previous calculations for each n

Section: ___________________

(16)

Items

Quantity

Total

Takeoff by _________

The Author of these Worksheet Templates makes no guarantees to th

based on the formulas or formats provided in these Worksheets and

their use.

Dimension/Description

HVAC Accessories Quantity Take-off Worksheet

Project: __________________

Clear Values from previous calculatio

Section: ___________________

Date: ______________

Page ___ of ________

(17)

Basement

1st

2nd

3rd

4th

5th

Roof

Total

Date: ______________

Page ___ of ________

Takeoff by _________

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

Fixture Type

Floor Level

Total

Project: __________________

Clear Values from previous calculations

Section: ___________________

(18)

Items

Quantity

Total

Take-off by:

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

Material Description Etc.

Project:

Clear Values from previous calculations for each new

Section:

Date:

(19)

Project:

Date:

ew measurement.

Page:

Take-off by::

Checked by:

QTY

Length

Dim

X

Dim

Extension

(EA)

(LF)

(IN)

(IN)

(BF)

LR N. Frame

2

34

8

2

X

4

181.33

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

X

0.00

Total

of

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

(20)

Project:

Date:

w measurement.

Page:

Take-off by::

Checked by:

QTY

Thickness

Length

Width

Extension

Sheets

(EA)

(IN)

(LF)

(LF)

(SF)

(EA)

LR Floor

CDX

1

5/8

20

30

600

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

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

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.

Description

Grade

Plywood Quantity Take-off Worksheet

References

Related documents