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

 | TB CAPS | JOB# | 120TB-BHT-100:S6 |  | DWG# | 28 | DATE: | 2014-02-27 00:00:00 |  |  |  | TB DAP | JOB# | 120TB-BHT-100:S6 |  | DWG# | 28 | DATE: | 2014-02-27 00:00:00 |  |  |  | CAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 152.75 | 668.28125 | 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 | 1.8 | 8.82
 | [NAME] | 12 | 80 | 143.5 |  | [NAME] | 0.25 | 2.78 | 11.637358 |  |  | [NAME]. | 12 | 330 | 591.9375 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 3 | 15.3 | 2x2x1/4 | 8 | 25.52
 | Doors | 12 | 64 | 114.8 |  | (BLANK) | 0.25 | 0 | 0 |  |  | Timer Mount | 10 | 1.75 | 4.0359375 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 15 | 63.75 | 1/2x1/2x1/8 | 64 | 24.32
 | Mullion | 12 | 8.75 | 15.6953125 |  | Manifold Mount | 0.25 | 0.62 | 2.595382 |  |  | Inspection Door | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 21 | 53.55 | 0.375 | 4.5 | 1.68975
 | Door Brackets | 10 | 1 | 2.30625 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x1 | 7 | 5.95 | 5x11ga | 0 | 0
 | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  |  |  | [NAME] cost | 0 |  | 3/8x1 | 7.5 | 9.5625 | 12 | 3.25 | 14.21875
 | (BLANK) | 12 | 0 | 0 |  |  |  | [NAME] cost | 14.23274 |  |  |  |  | sheet metal cost | 595.9734375 |  |  |  |  |  |  | 3/8x1 | 5.5 | 7.012499999999999
 |  |  | sheet metal cost | 276.3015625 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 7.5 | 12.75 | total weight | 951.06375
 |  |  |  |  |  | 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 | 3.683393197354015
 | 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 | 15 | 31.2375 |  | 2”x # of blow tube | 2x2x1/4 | 8 | 12.2496 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 2.7 | 140.94 |  | 12 | 330 | 1443.75 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 21 | 26.2395 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 132 | 164.934 |  |  | Paint | 2.7 | 126.819 |  | 10 | 1.75 | 9.84375 | 4x4x1/4 | 0 | 0
 | Handle 3” | 1/4x1 | 7 | 2.9155 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 64 | 53.312 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 0 | 0
 | Hold Dn Strap 4 ½ | 3/8x1 | 7.5 | 4.685624999999999 |  |  | 1/2x1/2x1/8 | 64 | 20.672 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 267.759 |  | 1/4x3 | 132 | 336.6 | total weight | 1898.99375
 | Hold Dn Strap 8 | 3/8x1 | 5.5 | 3.436125 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 64 | 108.8
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 218.246 |  |  |  | tubes | raw price |  | 0.375 | 0 | 0
 | Outlet Flange | 1/4x4 | 7.5 | 12.495 |  | 8” lg. 2 per door | 0.375 | 4.5 | 1.68975 |  |  |  |  |  |  |  |  | Silicone | 4 | 19.56 |  |  |  |  | cost per lbs | 1.275359631252078
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper 100 bag 60 deg
 |  |  | flat bar cost | 88.50625 |  | 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 |  |  |  |  |  |  |  |  | 26.05 | 38 | 989.9 |  | 12 | 130 | 568.75 | 0.25 | 25.5 | 260.355
 |  | Paint |  |  |  | sheet | 12 | 3.25 | 5.829687499999999 |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 3.33 | 18.73125 | 4x4x1/4 | 1 | 1
 |  |  | [NAME] | raw price |  |  |  |  |  |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x3 | 32 | 81.6
 |  | Primer | 1 | 52.2 |  | CAP Fittings |  |  | 433.79 |  |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 32 | 54.4 |  |  | Hours
 |  | Paint | 1 | 46.97 |  |  |  |  |  |  |  | Nylon Nuts | 0.375 | 0 | 0 |  |  |  |  |  |  | 3/8x6 | 2 | 15.3 | total weight | 1061.63408 | 35.5
 |  |  | Paint Cost | 99.17 |  |  | Hours | Shop Rate | Total Labor |  |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  |  |  | 0.375 | 0.66 | 0.24783
 |  |  |  |  |  |  | 59.125 | 38 | 2246.75 |  |  |  |  | mounting material | 0 |  |  |  |  |  |  | 8x11ga | 0 | 0 |  |  | Sell Price
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 14 | 61.25 | cost per lbs | 1.951306424008167 | 2071.57340025
 |  | Silicone | 2 | 9.78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight
 |  |  |  |  |  |  |  | total raw cost of cap | 966.4551899999999 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 1101.5384375 |  | 10 | 0.33 | 1.85625 | total weight | 157.15625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 28.5 | 96.89999999999999
 | TB Hopper | JOB# | 120TB-BHT-100:S6 |  | DWG# | 28 | DATE: | 2014-02-27 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 120TB-BHT-100:S6 |  | DWG# | 28 | DATE: | 2014-02-27 00:00:00 |  |  | 1-1/2x1-1/2x11ga | 73 | 58.40000000000001 | cost per lbs | 5.416158639888645
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Handrail |  |  |  |  | Tubesheet |  |  |  |  |  | ft | weight | total weight | 399.4198333333334
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price |  | 1/4x4 | 23 | 78.2
 | Hopper | 12 | 130 | 233.1875 |  | [NAME] | 0.25 | 1 | 4.1861 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 23 | 38.318 |  | 1/4x3 | 16 | 40.8
 | Inspection Door | 10 | 3.33 | 7.6798125 |  | Inlet Flange | 0.25 | 4 | 16.7444 |  |  | 6”x2” | 10 | 0.33 | 0.7610625 |  |  | 1/4x3 | 16 | 19.992 |  | tubesheet | 36.60833333333333 | 280.4198333333334
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 4 | 16.7444 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per lbs | 1.854196858026162
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 336
 |  |  | sheet metal cost | 240.8673125 |  | Baffle Plates | 0.25 | 16.5 | 69.07065 |  |  | Kick Plate | 1/4x4 | 28.5 | 47.48099999999999
 |  |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | Flat Bar |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  | Hand Rail | Size | Linear ft. | raw price |  |  | 6 | 38 | 228
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 106.74555 |  |  | [NAME] | 1-1/2x1-1/2x11ga | 73 | 90.52
 | (BLANK) | 1/4x6 | 0 | 0
 | (BLANK) | 1/4x5 | 0 | 0 |  | Inspection Door |  |  |  |  |  | Item | Qty | Price | Ext Price |  |  |  | [NAME] | 394.31
 | [NAME] | 1/4x3 | 32 | 39.98399999999999 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 26 | 0.9 | 23.4
 | Foot pads | 3/8x5 | 2 | 6.2475 |  | 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 | 32 | 26.656 |  | 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 | 72.88749999999999 |  |  |  |  |  |  |  |  | Paint
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0.5 | 26.1
 | Round Rod | 0.375 | 0.66 | 0.24783 |  |  | Primer | 1 | 52.2 |  |  |  | Safety Yellow | 0.5 | 27.665
 |  |  |  |  |  |  | Paint | 1 | 46.97 |  |  |  |  | Paint Cost | 53.765
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 99.17
 | round tube | 8x11ga | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | sheet | 12 | 14 | 25.1125 |  |  |  | tubes | raw price |  |  |  | 14.47 | 38 | 549.86
 |  |  |  |  |  |  | Silicone | 1.5 | 7.334999999999999 |  |  |  |  |  |  |  |  | 0.3 | Labor | total
 | Bag Grate Mat |  | Sq. ft. | raw price |  |  |  |  |  |  |  |  |  |  |  | CAP | 966.4551899999999 | 1256.391747 | 2246.75 | 3503.141747
 | Galv. Mesh | 4x4x1/4 | 1 | 0.5 |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 1101.5384375 | 1431.99996875 | 989.9 | 2421.89996875
 |  |  |  |  |  |  | 35.5 | 38 | 1349 |  |  |  |  |  |  | Hopper | 555.8256925 | 722.57340025 | 1349 | 2071.57340025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 231.7870625 | 301.32318125 | 549.86 | 851.18318125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 394.31 | 512.6030000000001 | 228 | 740.6030000000001
 |  |  |  |  |  |  |  | total raw cost of cap | 555.8256925 |  |  |  |  | handrail cost- | 231.7870625 |  | total w/ [NAME] | 4224.89129725 | 5363.509999999999 | 9588.401297249999
 | Support Structure | JOB# | 120TB-BHT-100:S6 |  | DWG# | 28 | DATE: | 2014-02-27 00:00:00 |  |  |  |  |  |  |  |  | 28 | 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 | 73
 |  | 2x2x1/4 | 0 | 0 |  |  | 2x2x1/4 | 0 | 0 |  |  | 16 | 0 |  |  | 1/2x1/2x1/8 | 64
 |  | 2-1/2x2-1/2x1/4 | 80 | 157.44 |  |  | 2-1/2x2-1/2x1/4 | 66.66666666666667 | 328 |  |  | 14 | 0 |  |  | 2x2x1/4 | 8
 |  | 3x3x1/4 | 0 | 0 |  |  | 3x3x1/4 | 0 | 0 |  |  | 12 | 612.75 |  |  | 3x3x1/4 | 1.8
 |  | 4x4x1/4 | 0 | 0 |  |  | 4x4x1/4 | 0 | 0 |  |  | 10 | 6.41
 |  | 5x5x3/8 | 40 | 311.04 |  |  | 5x5x3/8 | 66.66666666666667 | 492 |  |  | 0.1875 | 0 |  |  | Tube | Linear ft.
 |  | 6x6x3/8 | 0 | 0 |  |  | 6x6x3/8 | 0 | 0 |  |  | 0.25 | 28.9 |  |  | 3 1/2x 11ga | 0
 |  |  | Angle cost | 468.48 |  |  |  |  |  |  |  | 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 | 5.16
 |  | 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 | 15 |  |  | Grate Galv. | Sq ft.
 |  | 3/8x6 | 2 | 7.497 |  |  | 3/8x6 | 2 | 15.3 |  |  | 1/4x4 | 51.5 |  |  | 4x4x1/4 | 1
 |  | 1/2x7 | 0 | 0 |  |  | 1/2x7 | 0 | 0 |  |  | 1/4x3 | 164
 |  |  | flat bar cost | 12.9635625 |  |  |  |  |  |  |  | 1/4x1 | 7 |  |  |  | Size | Number
 |  |  |  |  |  | Total | Angle | Flat Bar |  |  |  | 3/8x1 | 13 |  |  | Bolts | 3/8x1 1/4 | 8
 | Paint |  |  |  |  | Sq ft. 2 side | 133.3333333333333 | 3.458333333333333 | total weight |  |  | 3/8x3 | 0 |  |  | Nylon Nuts | 0.375 | 8
 |  | sq ft. to cover | [NAME] | raw price |  | Wt. | 820 | 26.45625 | 846.45625 |  |  |  |  |  |  | [NAME] | 0.375 | 8
 | Primer | 136.7916666666667 | 0.8046568627450982 | 42.00308823529413 |  |  |  |  |  |  |  | Paint | Gallons
 | Paint | 136.7916666666667 | 0.8046568627450982 | 37.79473284313726 |  |  | Hours | Shop Rate | Total Labor |  |  | Primer | 4.7
 |  |  | Paint Cost | 79.79782107843138 |  |  | 15 | 38 | 570 |  |  | Paint | 4.7 |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.5 |  |  | 141.145 | 38 | 5363.509999999999
 |  |  |  |  |  |  |  | total raw cost of cap | 561.2413835784314
 |  |  |  |  |  |  |  |  | 729.6137986519608 |  |  |  | tubes
 |  |  |  |  |  |  |  |  |  |  |  | Silicone | 7.5
 |  |  |  |  |  |  |  | cost per lbs | 1.535358500397346
 |  |  |  |  |  |  |  |  |  |  |  | Length | [NAME]
 |  |  |  |  |  |  |  | total | 1299.613798651961 |  |  | 85 | 87
 |  |  |  |  |  |  |  |  |  |  | w/ stiff | 89 | 91
 |  |  |  |  |  |  |  |  |  |  |  | 7.416666666666667 | 7.583333333333333 | 56.24305555555556
 |  |  |  |  |  |  |  |  |  |  |  |  | 6x6 circle area
 |  |  |  |  |  |  |  |  |  |  | bags | 100 | 28.274
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.1963472222222222 | 19.63472222222222
 |  |  |  |  |  |  |  |  |  |  |  |  | surface area of tubesheet w/ hole | 36.60833333333333