Spreadsheet: 330716d1404835241-how-to-expand-rows-unit-quote
Sheet: 120TB-BHT-144 S6 DWG 032

 | TB CAPS | JOB# | 120tb-bht-121:s6 |  | DWG# | 32 | DATE: | 2014-02-27 00:00:00 |  |  |  | TB DAP | JOB# | 120tb-bht-121:s6 |  | DWG# | 32 | DATE: | 2014-02-27 00:00:00 |  |  |  | CAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 196 | 857.5 | 0.25 | 3.4 | 34.714
 |  | Gauge |  | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  | 10 | 1 | 5.625 | 3x3x1/4 | 3 | 14.7
 | [NAME] | 12 | 90 | 161.4375 |  | [NAME] | 0.25 | 2.78 | 11.637358 |  |  | [NAME]. | 12 | 432 | 774.9 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 3 | 15.3 | 2x2x1/4 | 12 | 38.28
 | Doors | 12 | 90 | 161.4375 |  | Outlet Flange | 0.25 | 0 | 0 |  |  | Timer Mount | 10 | 1.75 | 4.0359375 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 26 | 110.5 | 1/2x1/2x1/8 | 90 | 34.2
 | Mullion | 12 | 16 | 28.7 |  | Manifold Mount | 0.25 | 0.62 | 2.595382 |  |  | Inspection Door | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 27 | 68.85 | 0.375 | 6 | 2.253
 | Door Brackets | 10 | 1 | 2.30625 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x1 | 7.5 | 6.375 | 5x11ga | 0 | 0
 | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  |  |  | [NAME] cost | 0 |  | 3/8x1 | 9 | 11.475 | 12 | 4.5 | 19.6875
 | (BLANK) | 12 | 0 | 0 |  |  |  | [NAME] cost | 14.23274 |  |  |  |  | sheet metal cost | 778.9359375 |  |  |  |  |  |  | 3/8x1 | 4 | 5.1
 |  |  | sheet metal cost | 353.88125 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 9 | 15.3 | total weight | 1239.8595
 |  |  |  |  |  | Hand Rail Mt. | Size | Linear ft. | raw price |  |  | Flat Bar |  |  |  |  | Galv. Mesh | 4x4x1/4 | 0 | 0 |  | 3/8x6 | 0 | 0
 |  |  |  |  |  | 5” | 3x3x1/4 | 3 | 7.055999999999999 |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  |  |  | cost per lbs | 3.851569911348828
 | 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 | 26 | 54.145 |  | 2”x # of blow tube | 2x2x1/4 | 12 | 18.3744 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 3.25 | 169.65 |  | 12 | 432 | 1890 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 27 | 33.73649999999999 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 176 | 219.912 |  |  | Paint | 3.25 | 152.6525 |  | 10 | 1.75 | 9.84375 | 4x4x1/4 | 0 | 0
 | Handle 3” | 1/4x1 | 7.5 | 3.12375 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 76 | 63.308 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 0 | 0
 | Hold Dn Strap 4 ½ | 3/8x1 | 9 | 5.622749999999999 |  |  | 1/2x1/2x1/8 | 90 | 29.07 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 322.3025 |  | 1/4x3 | 176 | 448.8 | total weight | 2477.84375
 | Hold Dn Strap 8 | 3/8x1 | 4 | 2.499 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 76 | 129.2
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 283.22 |  |  |  | tubes | raw price |  | 0.375 | 0 | 0
 | Outlet Flange | 1/4x2 | 9 | 7.497 |  | 8” lg. 2 per door | 0.375 | 6 | 2.253 |  |  |  |  |  |  |  |  | Silicone | 5 | 0 |  |  |  |  | cost per lbs | 1.284583004376285
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper 144 bag 60 deg
 |  |  | flat bar cost | 114.121 |  | Outlet Stub | Size | Linear ft. | raw price |  |  | Round Rod | 0.375 | 0 | 0 |  |  | Hours | Shop Rate | Total Labor |  |  | ft | weight |  | ft | weight
 |  |  |  |  |  | round tube | 5x11ga | 0 | 0 |  |  |  |  |  |  |  |  | 36.4 | 38 | 1383.2 |  | 12 | 190 | 831.25 | 0.25 | 34.6 | 353.266
 |  | Paint |  |  |  | sheet | 12 | 4.5 | 8.071875 |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 3.33 | 18.73125 | 4x4x1/4 | 1 | 1
 |  |  | [NAME] | raw price |  |  |  |  |  |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x3 | 38 | 96.89999999999999
 |  | Primer | 1.48 | 77.256 |  | CAP Fittings |  |  | 527.93 |  |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 38 | 64.6 |  |  | Hours
 |  | Paint | 1.4 | 65.758 |  |  |  |  |  |  |  | Nylon Nuts | 0.375 | 0 | 0 |  |  |  |  |  |  | 3/8x6 | 2.5 | 19.125 | total weight | 1461.68258 | 52
 |  |  | Paint Cost | 143.014 |  |  | Hours | Shop Rate | Total Labor |  |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  |  |  | 0.375 | 0.66 | 0.24783
 |  |  |  |  |  |  | 84 | 38 | 3192 |  |  |  |  | mounting material | 0 |  |  |  |  |  |  | 8x11ga | 0 | 0 |  |  | Sell Price
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 17.5 | 76.5625 | cost per lbs | 2.035882519206051 | 2975.81401325
 |  | Silicone | 2.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight
 |  |  |  |  |  |  |  | total raw cost of cap | 1218.004265 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 1384.4584375 |  | 10 | 0.33 | 1.85625 | total weight | 199.95625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 34.5 | 117.3
 | TB Hopper | JOB# | 120tb-bht-121:s6 |  | DWG# | 32 | DATE: | 2014-02-27 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 120tb-bht-121:s6 |  | DWG# | 32 | DATE: | 2014-02-27 00:00:00 |  |  | 1-1/2x1-1/2x11ga | 101 | 80.80000000000001 | cost per lbs | 5.655770506048198
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Handrail |  |  |  |  | Tubesheet |  |  |  |  |  | ft | weight | total weight | 560.5315766666668
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price |  | 1/4x4 | 27 | 91.8
 | Hopper | 12 | 190 | 340.8125 |  | [NAME] | 0.25 | 1 | 4.1861 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 27 | 44.982 |  | 1/4x3 | 30 | 76.5
 | Inspection Door | 10 | 3.33 | 7.6798125 |  | Inlet Flange | 0.25 | 4.6 | 19.25606 |  |  | 6”x2” | 10 | 0.33 | 0.7610625 |  |  | 1/4x3 | 30 | 37.48499999999999 |  | tubesheet | 51.20516666666667 | 392.2315766666667
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 5 | 20.9305 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per lbs | 1.922830300496957
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 542
 |  |  | sheet metal cost | 348.4923125 |  | Baffle Plates | 0.25 | 24 | 100.4664 |  |  | Kick Plate | 1/4x4 | 34.5 | 57.477
 |  |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | Flat Bar |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  | Hand Rail | Size | Linear ft. | raw price |  |  | 7 | 38 | 266
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 144.83906 |  |  | [NAME] | 1-1/2x1-1/2x11ga | 101 | 125.24
 | (BLANK) | 1/4x6 | 0 | 0
 | (BLANK) | 1/4x5 | 0 | 0 |  | Inspection Door |  |  |  |  |  | Item | Qty | Price | Ext Price |  |  |  | [NAME] | 624.467
 | [NAME] | 1/4x3 | 38 | 47.48099999999999 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 32 | 0.9 | 28.8
 | Foot pads | 3/8x5 | 2.5 | 7.809375000000001 |  | Bolts | 3/8x1 1/4 | 8 | 1.28 |  |  | Bolt, 5/8-11 x 3" lg Gr 8, zinc/yellow | 32 | 0.25 | 8
 | Hopper Flange | 1/4x2 | 38 | 31.654 |  | Nylon Nuts | 0.375 | 8 | 1.2 |  |  | Nylock Nut, 5/8-11, zinc | 64 | 0.18 | 11.52
 | (BLANK) | 3/8x1 | 0 | 0 |  | [NAME] | 0.375 | 8 | 0.48 |  |  |  |  | Fitting Cost | 48.31999999999999
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | mounting material | 2.96
 |  |  | flat bar cost | 86.944375 |  |  |  |  |  |  |  |  | Paint
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0.62 | 32.364
 | Round Rod | 0.375 | 0.66 | 0.24783 |  |  | Primer | 1.55 | 80.91000000000001 |  |  |  | Safety Yellow | 0.62 | 34.3046
 |  |  |  |  |  |  | Paint | 1.55 | 72.8035 |  |  |  |  | Paint Cost | 66.6686
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 153.7135
 | round rod | 8x11ga | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | sheet | 12 | 17.5 | 31.390625 |  |  |  | tubes | raw price |  |  |  | 19.55 | 38 | 742.9
 |  |  |  |  |  |  | Silicone | 2.55 | 0 |  |  |  |  |  |  |  |  | 0.3 | Labor | total
 | Bag Grate Mat |  | Sq. ft. | raw price |  |  |  |  |  |  |  |  |  |  |  | CAP | 1218.004265 | 1583.4055445 | 3192 | 4775.4055445
 | Galv. Mesh | 4x4x1/4 | 1 | 0.5 |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 1384.4584375 | 1799.79596875 | 1383.2 | 3182.99596875
 |  |  |  |  |  |  | 52 | 38 | 1976 |  |  |  |  |  |  | Hopper | 769.0877025 | 999.81401325 | 1976 | 2975.81401325
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 298.4666625 | 388.00666125 | 742.9 | 1130.90666125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 624.467 | 811.8071 | 266 | 1077.8071
 |  |  |  |  |  |  |  | total raw cost of cap | 769.0877025 |  |  |  |  | handrail cost- | 298.4666625 |  | total w/ [NAME] | 5582.829287750001 | 7560.099999999999 | 13142.92928775
 | Support Structure | JOB# | 120tb-bht-121:s6 |  | DWG# | 32 | DATE: | 2014-02-27 00:00:00 |  |  |  |  |  |  |  |  | 32 | 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 | 101
 |  | 2x2x1/4 | 0 | 0 |  |  | 2x2x1/4 | 0 | 0 |  |  | 16 | 0 |  |  | 1/2x1/2x1/8 | 90
 |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 14 | 0 |  |  | 2x2x1/4 | 12
 |  | 3x3x1/4 | 90 | 211.68 |  |  | 3x3x1/4 | 90 | 441.0000000000001 |  |  | 12 | 818 |  |  | 3x3x1/4 | 3
 |  | 4x4x1/4 | 0 | 0 |  |  | 4x4x1/4 | 0 | 0 |  |  | 10 | 6.41
 |  | 5x5x3/8 | 0 | 0 |  |  | 5x5x3/8 | 0 | 0 |  |  | 0.1875 | 0 |  |  | Tube | Linear ft.
 |  | 6x6x3/8 | 40 | 286.08 |  |  | 6x6x3/8 | 80 | 596 |  |  | 0.25 | 38 |  |  | 3 1/2x 11ga | 0
 |  |  | Angle cost | 497.76 |  |  |  |  |  |  |  | 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 | 6.66
 |  | 3/8x4 | 0 | 0 |  |  | 3/8x4 | 0 | 0 |  |  | 1/4x6 | 3
 |  | 3/8x5 | 0 | 0 |  |  | 3/8x5 | 0 | 0 |  |  | 1/4x5 | 26 |  |  | Grate Galv. | Sq ft.
 |  | 3/8x6 | 2 | 7.497 |  |  | 3/8x6 | 2 | 15.3 |  |  | 1/4x4 | 61.5 |  |  | 4x4x1/4 | 1
 |  | 1/2x7 | 2.5 | 12.495 |  |  | 1/2x7 | 2.916666666666667 | 25.5 |  |  | 1/4x3 | 214
 |  |  | flat bar cost | 19.992 |  |  |  |  |  |  |  | 1/4x1 | 7.5 |  |  |  | Size | Number
 |  |  |  |  |  | Total | Angle | Flat Bar |  |  |  | 3/8x1 | 13 |  |  | Bolts | 3/8x1 1/4 | 8
 | Paint |  |  |  |  | Sq ft. 2 side | 170 | 4.916666666666667 | total weight |  |  | 3/8x3 | 0 |  |  | Nylon Nuts | 0.375 | 8
 |  | sq ft. to cover | [NAME] | raw price |  | Wt. | 1037 | 40.8 | 1077.8 |  |  |  |  |  |  | [NAME] | 0.375 | 8
 | Primer | 174.9166666666667 | 1.028921568627451 | 53.70970588235294 |  |  |  |  |  |  |  | Paint | Gallons
 | Paint | 174.9166666666667 | 1.028921568627451 | 48.32844607843137 |  |  | Hours | Shop Rate | Total Labor |  |  | Primer | 6.28
 |  |  | Paint Cost | 102.0381519607843 |  |  | 20 | 38 | 760 |  |  | Paint | 6.2 |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.62 |  |  | 198.95 | 38 | 7560.099999999999
 |  |  |  |  |  |  |  | total raw cost of cap | 619.7901519607842
 |  |  |  |  |  |  |  |  | 805.7271975490195 |  |  |  | tubes
 |  |  |  |  |  |  |  |  |  |  |  | Silicone | 10.05
 |  |  |  |  |  |  |  | cost per lbs | 1.452706622331619
 |  |  |  |  |  |  |  |  |  |  |  | Length | [NAME]
 |  |  |  |  |  |  |  | total | 1565.727197549019 |  |  | 101 | 105
 |  |  |  |  |  |  |  |  |  |  | w/ stiff | 105 | 109
 |  |  |  |  |  |  |  |  |  |  |  | 8.75 | 9.083333333333334 | 79.47916666666667
 |  |  |  |  |  |  |  |  |  |  |  |  | 6in circle area
 |  |  |  |  |  |  |  |  |  |  | bags | 144 | 28.274
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.1963472222222222 | 28.274
 |  |  |  |  |  |  |  |  |  |  |  |  | surface area of tubesheet w/ hole | 51.20516666666667