Spreadsheet: 330716d1404835241-how-to-expand-rows-unit-quote
Sheet: 96TB-BHT-64 S6 DWG 022

 | TB CAPS | JOB# | 96TB-BHT-64:S6 |  | DWG# | 22 | DATE: | 2014-02-27 00:00:00 |  |  |  | TB DAP | JOB# | 96TB-BHT-64:S6 |  | DWG# | 22 | DATE: | 2014-02-27 00:00:00 |  |  |  | CAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 99.75 | 436.40625 | 0.25 | 5.399999999999999 | 55.134
 |  | Gauge |  | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  | 10 | 0.66 | 3.7125 | 3x3x1/4 | 1.8 | 8.82
 | [NAME] | 12 | 60 | 107.625 |  | [NAME] | 0.25 | 2.78 | 11.637358 |  |  | [NAME]. | 12 | 216 | 387.45 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 3 | 15.3 | 2x2x1/4 | 6.5 | 20.735
 | Doors | 12 | 36 | 64.575 |  | Outlet Flange | 0.25 | 2 | 8.3722 |  |  | Timer Mount | 10 | 1.75 | 4.0359375 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 6 | 25.5 | 1/2x1/2x1/8 | 36 | 13.68
 | Mullion | 12 | 3.75 | 6.7265625 |  | Manifold Mount | 0.25 | 0.62 | 2.595382 |  |  | Inspection Door | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 12 | 30.6 | 0.375 | 3 | 1.1265
 | Door Brackets | 10 | 0.66 | 1.522125 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x1 | 5 | 4.25 | 5x11ga | 2.5 | 15.635
 | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  |  |  | [NAME] cost | 0 |  | 3/8x1 | 6 | 7.649999999999999 | 12 | 0 | 0
 | (BLANK) | 12 | 0 | 0 |  |  |  | [NAME] cost | 22.60494 |  |  |  |  | sheet metal cost | 391.4859375 |  |  |  |  |  |  | 3/8x1 | 2.7 | 3.4425
 |  |  | sheet metal cost | 180.4486875 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 0 | 0 | total weight | 641.9917499999999
 |  |  |  |  |  | Hand Rail Mt. | Size | Linear ft. | raw price |  |  | Flat Bar |  |  |  |  | Galv. Mesh | 4x4x1/4 | 0 | 0 |  | 3/8x6 | 0 | 0
 |  |  |  |  |  | 5” | 3x3x1/4 | 1.8 | 4.2336 |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  |  |  | cost per lbs | 4.076414215213825
 | Flat Bar | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Lifting Lugs | 1/4x6 | 0 | 0 |  |  | Paint |  |  |  |  | Dap
 | Lifting Lugs | 1/4x6 | 3 | 7.496999999999999 |  | [NAME]. Angle | Size | Linear ft. | raw price |  |  | (BLANK) | 1/4x5 | 0 | 0 |  |  |  | [NAME] | raw price |  |  | ft | weight |  | ft | weight
 | Mullion Stiffener | 1/4x5 | 6 | 12.495 |  | 2”x # of blow tube | 2x2x1/4 | 6.5 | 9.9528 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 1.75 | 91.35000000000001 |  | 12 | 216 | 945 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 12 | 14.994 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 72 | 89.96399999999998 |  |  | Paint | 1.75 | 82.19749999999999 |  | 10 | 1.75 | 9.84375 | 4x4x1/4 | 0 | 0
 | Handle 3” | 1/4x1 | 5 | 2.0825 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 42 | 34.986 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 0 | 0
 | Hold Dn Strap 4 ½ | 3/8x1 | 6 | 3.748499999999999 |  |  | 1/2x1/2x1/8 | 36 | 11.628 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 173.5475 |  | 1/4x3 | 72 | 183.6 | total weight | 1209.84375
 | Hold Dn Strap 8 | 3/8x1 | 2.7 | 1.686825 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 42 | 71.39999999999999
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 124.95 |  |  |  | tubes | raw price |  | 0.375 | 0 | 0
 | (BLANK) | 3/8x1 | 0 | 0 |  | 8” lg. 2 per door | 0.375 | 3 | 1.1265 |  |  |  |  |  |  |  |  | Silicone | 2 | 9.78 |  |  |  |  | cost per lbs | 1.359673485729046
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper 64 bag 60 deg
 |  |  | flat bar cost | 42.503825 |  | Outlet Stub | Size | Linear ft. | raw price |  |  | Round Rod | 0.375 | 0 | 0 |  |  | Hours | Shop Rate | Total Labor |  |  | ft | weight |  | ft | weight
 |  |  |  |  |  |  | 12 | 2.5 | 4.484375 |  |  |  |  |  |  |  |  | 19.35 | 38 | 735.3000000000001 |  | 12 | 80 | 350 | 0.25 | 17.5 | 178.675
 |  | Paint |  |  |  |  |  |  |  |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 3.33 | 18.73125 | 4x4x1/4 | 1 | 1
 |  |  | [NAME] | raw price |  | CAP Fittings |  |  | 346.68 |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x3 | 14 | 35.7
 |  | Primer | 1 | 52.2 |  |  |  |  |  |  |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 24 | 40.8 |  |  | Hours
 |  | Paint | 0.75 | 35.2275 |  |  | Hours | Shop Rate | Total Labor |  |  | Nylon Nuts | 0.375 | 0 | 0 |  |  |  |  |  |  | 3/8x6 | 2 | 15.3 | total weight | 668.89158 | 25.5
 |  |  | Paint Cost | 87.42750000000001 |  |  | 44.375 | 38 | 1686.25 |  |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  |  |  | 0.375 | 0.66 | 0.24783
 |  |  |  |  |  |  |  |  |  |  |  |  |  | mounting material | 0 |  |  |  |  |  |  | 8x11ga | 0 | 0 |  |  | Sell Price
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 6.5 | 28.4375 | cost per lbs | 2.165844721427051 | 1448.71529775
 |  | Silicone | 1 | 4.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight
 |  |  |  |  |  |  |  | total raw cost of cap | 715.9802275000001 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 699.7634374999999 |  | 10 | 0.33 | 1.85625 | total weight | 130.35625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 22.5 | 76.5
 | TB Hopper | JOB# | 96TB-BHT-64:S6 |  | DWG# | 22 | DATE: | 2014-02-27 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 96TB-BHT-64:S6 |  | DWG# | 22 | DATE: | 2014-02-27 00:00:00 |  |  | 1-1/2x1-1/2x11ga | 65 | 52 | cost per lbs | 344.4168798760881
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Handrail |  |  |  |  | Tubesheet |  |  |  |  |  | ft | weight | total weight | 263.7159322222222
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price |  | 1/4x4 | 18 | 61.2
 | Hopper | 12 | 80 | 143.5 |  | [NAME] | 0.25 | 1 | 4.1861 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 18 | 29.988 |  | 1/4x3 | 6 | 15.3
 | Inspection Door | 10 | 3.33 | 7.6798125 |  | Inlet Flange | 0.25 | 2 | 8.3722 |  |  | 6”x2” | 10 | 0.33 | 0.7610625 |  |  | 1/4x3 | 6 | 7.496999999999999 |  | tubesheet | 24.44072222222222 | 187.2159322222222
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 4 | 16.7444 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per lbs | 2.101998522914001
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 272
 |  |  | sheet metal cost | 151.1798125 |  | Baffle Plates | 0.25 | 10.5 | 43.95405 |  |  | Kick Plate | 1/4x4 | 22.5 | 37.485
 |  |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | Flat Bar |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  | Hand Rail | Size | Linear ft. | raw price |  |  | 4 | 38 | 152
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 73.25675 |  |  | [NAME] | 1-1/2x1-1/2x11ga | 65 | 80.6
 | (BLANK) | 1/4x6 | 0 | 0
 | (BLANK) | 1/4x5 | 0 | 0 |  | Inspection Door |  |  |  |  |  | Item | Qty | Price | Ext Price |  |  |  | [NAME] | 309.485
 | [NAME] | 1/4x3 | 14 | 17.493 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 26 | 0.9 | 23.4
 | Foot pads | 3/8x6 | 2 | 7.497 |  | Bolts | 3/8x1 1/4 | 8 | 1.28 |  |  | Bolt, 5/8-11 x 3" lg Gr 8, zinc/yellow | 26 | 0.25 | 6.5
 | Hopper Flange | 1/4x2 | 24 | 19.992 |  | Nylon Nuts | 0.375 | 8 | 1.2 |  |  | Nylock Nut, 5/8-11, zinc | 52 | 0.18 | 9.36
 | (BLANK) | 3/8x1 | 0 | 0 |  | [NAME] | 0.375 | 8 | 0.48 |  |  |  |  | Fitting Cost | 39.26000000000001
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | mounting material | 2.96
 |  |  | flat bar cost | 44.982 |  |  |  |  |  |  |  |  | Paint
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0.4 | 20.88
 | Round Rod | 0.375 | 0.66 | 0.24783 |  |  | Primer | 0.8 | 41.76000000000001 |  |  |  | Safety Yellow | 0.4 | 22.132
 |  |  |  |  |  |  | Paint | 0.8 | 37.576 |  |  |  |  | Paint Cost | 43.012
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 79.33600000000001
 |  | 12 | 6.5 | 11.659375 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  | tubes | raw price |  |  |  | 12.75 | 38 | 484.5
 | Bag Grate Mat |  | Sq. ft. | raw price |  |  | Silicone | 1 | 4.89 |  |  |  |  |  |  |  |  | 0.3 | Labor | total
 | Galv. Mesh | 4x4x1/4 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  | CAP | 715.9802275000001 | 930.7742957500001 | 1686.25 | 2617.02429575
 |  |  |  |  |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 699.7634374999999 | 909.6924687499999 | 735.3000000000001 | 1644.99246875
 |  |  |  |  |  |  | 25.5 | 38 | 969 |  |  |  |  |  |  | Hopper | 369.0117675 | 479.71529775 | 969 | 1448.71529775
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 201.1180625 | 261.45348125 | 484.5 | 745.9534812500001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 309.485 | 402.3305 | 152 | 554.3305
 |  |  |  |  |  |  |  | total raw cost of cap | 369.0117675 |  |  |  |  | handrail cost- | 201.1180625 |  | total w/ [NAME] | 2983.9660435 | 4027.05 | 7011.0160435
 | Support Structure | JOB# | 96TB-BHT-64:S6 |  | DWG# | 22 | DATE: | 2014-02-27 00:00:00 |  |  |  |  |  |  |  |  | 22 | DATE: | 2014-02-27 00:00:00
 | Angle |  |  |  |  |  | Total Sq ft both side |  |  |  |  |  |  |  |  |  | Linear ft.
 |  | Size | [NAME] | raw price |  |  | Size | Sq. Ft. | Wt. |  |  | Gauge | Sq. ft |  |  | 1 1/2x1 1/2x 11ga | 65
 |  | 2x2x1/4 | 0 | 0 |  |  | 2x2x1/4 | 0 | 0 |  |  | 16 | 0 |  |  | 1/2x1/2x1/8 | 36
 |  | 2-1/2x2-1/2x1/4 | 66 | 129.888 |  |  | 2-1/2x2-1/2x1/4 | 55 | 270.6 |  |  | 14 | 0 |  |  | 2x2x1/4 | 6.5
 |  | 3x3x1/4 | 0 | 0 |  |  | 3x3x1/4 | 0 | 0 |  |  | 12 | 395.75 |  |  | 3x3x1/4 | 1.8
 |  | 4x4x1/4 | 0 | 0 |  |  | 4x4x1/4 | 0 | 0 |  |  | 10 | 6.07
 |  | 5x5x3/8 | 32 | 248.832 |  |  | 5x5x3/8 | 53.33333333333334 | 393.6 |  |  | 0.1875 | 0 |  |  | Tube | Linear ft.
 |  | 6x6x3/8 | 0 | 0 |  |  | 6x6x3/8 | 0 | 0 |  |  | 0.25 | 22.9 |  |  | 3 1/2x 11ga | 0
 |  |  | Angle cost | 378.72 |  |  |  |  |  |  |  | 0.3125 | 0 |  |  | 5x11ga | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0.375 | 0 |  |  | 8x11ga | 0
 | Flat Bar |  |  |  |  |  | Total Sq ft both side
 |  | Size | Linear ft. | raw price |  |  | Size | Sq. Ft. | Wt. |  |  | Flat Bar |  |  |  | Round Rod | Linear ft.
 |  | 1/4x4 | 0 | 0 |  |  | 1/4x4 | 0 | 0 |  |  | Size | Linear ft. |  |  | 0.375 | 3.66
 |  | 3/8x4 | 0 | 0 |  |  | 3/8x4 | 0 | 0 |  |  | 1/4x6 | 3
 |  | 3/8x5 | 1.75 | 5.4665625 |  |  | 3/8x5 | 1.458333333333333 | 11.15625 |  |  | 1/4x5 | 6 |  |  | Grate Galv. | Sq ft.
 |  | 3/8x6 | 2 | 7.497 |  |  | 3/8x6 | 2 | 15.3 |  |  | 1/4x4 | 40.5 |  |  | 4x4x1/4 | 1
 |  | 1/2x7 | 0 | 0 |  |  | 1/2x7 | 0 | 0 |  |  | 1/4x3 | 86
 |  |  | flat bar cost | 12.9635625 |  |  |  |  |  |  |  | 1/4x1 | 5 |  |  |  | Size | Number
 |  |  |  |  |  | Total | Angle | Flat Bar |  |  |  | 3/8x1 | 8.7 |  |  | Bolts | 3/8x1 1/4 | 8
 | Paint |  |  |  |  | Sq ft. 2 side | 108.3333333333333 | 3.458333333333333 | total weight |  |  | 3/8x3 | 0 |  |  | Nylon Nuts | 0.375 | 8
 |  | sq ft. to cover | [NAME] | raw price |  | Wt. | 664.2 | 26.45625 | 690.65625 |  |  |  |  |  |  | [NAME] | 0.375 | 8
 | Primer | 111.7916666666667 | 0.6575980392156863 | 34.32661764705882 |  |  |  |  |  |  |  | Paint | Gallons
 | Paint | 111.7916666666667 | 0.6575980392156863 | 30.88737990196078 |  |  | Hours | Shop Rate | Total Labor |  |  | Primer | 3.55
 |  |  | Paint Cost | 65.21399754901961 |  |  | 13 | 38 | 494 |  |  | Paint | 3.3 |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.4 |  |  | 105.975 | 38 | 4027.05
 |  |  |  |  |  |  |  | total raw cost of cap | 456.8975600490196
 |  |  |  |  |  |  |  |  | 593.9668280637255 |  |  |  | tubes
 |  |  |  |  |  |  |  |  |  |  |  | Silicone | 4
 |  |  |  |  |  |  |  | cost per lbs | 1.575265304648623
 |  |  |  |  |  |  |  |  |  |  |  | Length | [NAME]
 |  |  |  |  |  |  |  | total | 1087.966828063726 |  |  | 69 | 69
 |  |  |  |  |  |  |  |  |  |  | w/ stiff | 73 | 73
 |  |  |  |  |  |  |  |  |  |  |  | 6.083333333333333 | 6.083333333333333 | 37.00694444444444
 |  |  |  |  |  |  |  |  |  |  |  |  | 6x6 circle area
 |  |  |  |  |  |  |  |  |  |  | bags | 64 | 28.274
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.1963472222222222 | 12.56622222222222
 |  |  |  |  |  |  |  |  |  |  |  |  | surface area of tubesheet w/ hole | 24.44072222222222