Spreadsheet: 330716d1404835241-how-to-expand-rows-unit-quote
Sheet: 58TB-BHT-16 S6 DWG 05

 | TB CAPS | JOB# | 58TB-BHT-16:S6 |  | DWG# | 5 | DATE: | 2014-02-27 00:00:00 |  |  |  | TB DAP | JOB# | 58TB-BHT-16:S6 |  | DWG# | 5 | DATE: | 2014-02-27 00:00:00 |  |  |  | CAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 45.875 | 200.703125 | 0.25 | 1.37 | 13.9877
 |  | Gauge |  | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  | 10 | 0.33 | 1.85625 | 3x3x1/4 | 0 | 0
 | [NAME] | 12 | 35 | 62.78125 |  | [NAME] | 0.25 | 0 | 0 |  |  | [NAME]. | 12 | 80 | 143.5 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 3 | 15.3 | 2x2x1/4 | 3 | 9.57
 | Doors | 12 | 9 | 16.14375 |  | Outlet Flange | 0.25 | 0.75 | 3.139575 |  |  | Timer Mount | 10 | 1.75 | 4.0359375 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 3.33 | 14.1525 | 1/2x1/2x1/8 | 13.33 | 5.0654
 | Mullion | 12 | 1.875 | 3.36328125 |  | Manifold Mount | 0.25 | 0.62 | 2.595382 |  |  | Inspection Door | 10 | 3.3 | 7.610624999999999 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 3.33 | 8.4915 | 0.375 | 1.5 | 0.56325
 | Door Brackets | 10 | 0.33 | 0.7610625 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x1 | 2.5 | 2.125 | 5x11ga | 0.5 | 3.127
 | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  |  |  | [NAME] cost | 0 |  | 3/8x1 | 3 | 3.825 | 12 | 0 | 0
 | (BLANK) | 12 | 0 | 0 |  |  |  | [NAME] cost | 5.734957 |  |  |  |  | sheet metal cost | 155.1465625 |  |  |  |  |  |  | 3/8x1 | 0 | 0
 |  |  | sheet metal cost | 83.04934374999999 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 0 | 0 | total weight | 278.766725
 |  |  |  |  |  | Hand Rail Mt. | Size | Linear ft. | raw price |  |  | Flat Bar |  |  |  |  | Galv. Mesh | 4x4x1/4 | 12 | 6 |  | 3/8x6 | 0 | 0
 |  |  |  |  |  | 5” | 3x3x1/4 | 0 | 0 |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  |  |  | cost per lbs | 4.984322648174742
 | 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 | 3.33 | 6.934725 |  | 2”x # of blow tube | 2x2x1/4 | 3 | 4.593599999999999 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 0.66 | 34.45200000000001 |  | 12 | 80 | 350 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 3.33 | 4.160835 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 13.33 | 16.655835 |  |  | Paint | 0.66 | 31.0002 |  | 10 | 5.05 | 28.40625 | 4x4x1/4 | 12 | 12
 | Handle 3” | 1/4x1 | 2.5 | 1.04125 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 26.66 | 22.20778 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 0 | 0
 | Hold Dn Strap 4 ½ | 3/8x1 | 3 | 1.87425 |  |  | 1/2x1/2x1/8 | 13.33 | 4.30559 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 65.4522 |  | 1/4x3 | 13.33 | 33.99149999999999 | total weight | 470.283
 | Hold Dn Strap 8 | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 26.66 | 45.322
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 38.863615 |  |  |  | tubes | raw price |  | 0.375 | 1.5 | 0.56325
 | (BLANK) | 3/8x1 | 0 | 0 |  | 8” lg. 2 per door | 0.375 | 1.5 | 0.56325 |  |  |  |  |  |  |  |  | Silicone | 0.5 | 2.445 |  |  |  |  | cost per lbs | 1.61893969322727
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper 16 bag 60 deg
 |  |  | flat bar cost | 21.50806 |  | Outlet Stub | Size | Linear ft. | raw price |  |  | Round Rod | 0.375 | 1.5 | 0.56325 |  |  | Hours | Shop Rate | Total Labor |  |  | ft | weight |  | ft | weight
 |  |  |  |  |  |  | 5x11ga | 0.5 | 0 |  |  |  |  |  |  |  |  | 10.75 | 38 | 408.5 |  | 12 | 25 | 109.375 | 0.25 | 8.399999999999999 | 85.764
 |  | Paint |  |  |  |  |  |  |  |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 4x4x1/4 | 1 | 1
 |  |  | [NAME] | raw price |  | CAP Fittings |  |  | 144.34 |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x3 | 0 | 0
 |  | Primer | 0.36 | 18.792 |  |  |  |  |  |  |  | Bolts | 3/8x1 1/4 | 8 | 1.28 |  |  |  |  |  |  | 1/4x2 | 13.33 | 22.661 |  |  | Hours
 |  | Paint | 0.36 | 16.9092 |  |  | Hours | Shop Rate | Total Labor |  |  | Nylon Nuts | 0.375 | 8 | 1.2 |  |  |  |  |  |  | 3/8x3 | 1 | 3.825 | total weight | 228.879 | 12.54
 |  |  | Paint Cost | 35.7012 |  |  | 26.225 | 38 | 996.5500000000001 |  |  | [NAME] | 0.375 | 8 | 0.48 |  |  |  |  |  |  | 0.375 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | mounting material | 2.96 |  |  |  |  |  |  | 5x11ga | 1 | 6.254 |  |  | Sell Price
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0 | 0 | cost per lbs | 2.750903427483288 | 629.6240255789473
 |  | Silicone | 0.5 | 2.445 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight
 |  |  |  |  |  |  |  | total raw cost of cap | 302.24100075 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 271.4306275 |  | 10 | 0 | 0 | total weight | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 0 | 0
 | TB Hopper | JOB# | 58TB-BHT-16:S6 |  | DWG# | 5 | DATE: | 2014-02-27 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 58TB-BHT-16:S6 |  | DWG# | 5 | DATE: | 2014-02-27 00:00:00 |  |  | 1-1/2x1-1/2x11ga | 0 | 0 | cost per lbs | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Handrail |  |  |  |  | Tubesheet |  |  |  |  |  | ft | weight | total weight | 65.35554555555555
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price |  | 1/4x4 | 0 | 0
 | Hopper | 12 | 25 | 44.84375 |  | [NAME] | 0.25 | 1 | 4.1861 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 0 | 0 |  | 1/4x3 | 0 | 0
 | Inspection Door | 10 | 0 | 0 |  | Inlet Flange | 0.25 | 0.8 | 3.34888 |  |  | 6”x2” | 10 | 0 | 0 |  |  | 1/4x3 | 0 | 0 |  | tubesheet | 8.532055555555555 | 65.35554555555555
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 2.5 | 10.46525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per lbs | 2.426725974847565
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 103
 |  |  | sheet metal cost | 44.84375 |  | Baffle Plates | 0.25 | 4.1 | 17.16301 |  |  | Kick Plate | 3/16x4 | 0 | 0
 |  |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | Flat Bar |  |  |  |  | (BLANK) | 0.25 | 0 | 0 |  |  | Hand Rail | Size | Linear ft. | raw price |  |  | 0.65 | 38 | 24.7
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 35.16323999999999 |  |  | [NAME] | 1-1/2x1-1/2x11ga | 0 | 0
 | (BLANK) | 1/4x6 | 0 | 0
 | (BLANK) | 1/4x5 | 0 | 0 |  | Inspection Door |  |  |  |  |  | Item | Qty | Price | Ext Price |  |  |  | handrail cost- | 103
 | [NAME] | 1/4x3 | 0 | 0 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 0 | 0.9 | 0
 | Foot pads | 3/8x3 | 1 | 1.368947368421053 |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  | Bolt, 5/8-11 x 3" lg Gr 8, zinc/yellow | 0 | 1.3 | 0
 | Hopper Flange | 1/4x2 | 13.33 | 11.10389 |  | Nylon Nuts | 0.375 | 0 | 0 |  |  | Nylock Nut, 5/8-11, zinc | 0 | 0.25 | 0
 | (BLANK) | 3/8x1 | 0 | 0 |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  | Fitting Cost | 0
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | mounting material | 0
 |  |  | flat bar cost | 12.47283736842105 |  |  |  |  |  |  |  |  | Paint
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0 | 0
 | Round Rod | 0.375 | 0 | 0 |  |  | Primer | 0.25 | 13.05 |  |  |  | Safety Yellow | 0 | 0
 |  |  |  |  |  |  | Paint | 0.25 | 11.7425 |  |  |  |  | Paint Cost | 0
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 24.7925
 |  | 5x11ga | 1 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  | tubes | raw price |  |  |  | 0 | 38 | 0
 | Bag Grate Mat |  | Sq. ft. | raw price |  |  | Silicone | 0 | 0 |  |  |  |  |  |  |  |  | 0.3 | Labor | total
 | Galv. Mesh | 4x4x1/4 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  | CAP | 302.24100075 | 392.913300975 | 996.5500000000001 | 1389.463300975
 |  |  |  |  |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 271.4306275 | 352.8598157500001 | 408.5 | 761.35981575
 |  |  |  |  |  |  | 12.54 | 38 | 476.52 |  |  |  |  |  |  | Hopper | 117.772327368421 | 153.1040255789474 | 476.52 | 629.6240255789473
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 103 | 133.9 | 24.7 | 158.6
 |  |  |  |  |  |  |  | total raw cost of cap | 117.772327368421 |  |  |  |  | handrail cost- | 0 |  | total w/ [NAME] | 1032.777142303948 | 1906.27 | 2939.047142303948
 | Support Structure | JOB# | 58TB-BHT-16:S6 |  | DWG# | 5 | DATE: | 2014-02-27 00:00:00 |  |  |  |  |  |  |  |  | 5 | DATE: | 2014-02-27 00:00:00
 | Angle |  |  |  |  |  | Total Sq ft both side |  |  |  |  | Sheet |  |  |  | Angle | Linear ft.
 |  | Size | [NAME] | raw price |  |  | Size | Sq. Ft. | Wt. |  |  | Gauge | Sq. ft |  |  | 1 1/2x1 1/2x 11ga | 0
 |  | 2x2x1/4 | 40 | 61.248 |  |  | 2x2x1/4 | 26.66666666666666 | 127.6 |  |  | 16 | 0 |  |  | 1/2x1/2x1/8 | 13.33
 |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 14 | 0 |  |  | 2x2x1/4 | 3
 |  | 3x3x1/4 | 23 | 54.096 |  |  | 3x3x1/4 | 23 | 112.7 |  |  | 12 | 150.875 |  |  | 3x3x1/4 | 0
 |  | 4x4x1/4 | 0 | 0 |  |  | 4x4x1/4 | 0 | 0 |  |  | 10 | 5.38
 |  | 5x5x3/8 | 0 | 0 |  |  | 5x5x3/8 | 0 | 0 |  |  | 0.1875 | 0 |  |  | Tube | Linear ft.
 |  | 6x6x3/8 | 0 | 0 |  |  | 6x6x3/8 | 0 | 0 |  |  | 0.25 | 9.769999999999998 |  |  | 3 1/2x 11ga | 0
 |  |  | Angle cost | 115.344 |  |  |  |  |  |  |  | 0.3125 | 0 |  |  | 5x11ga | 1.5
 |  |  |  |  |  |  |  |  |  |  |  | 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 | 1.33 | 2.21578 |  |  | 1/4x4 | 0.8866666666666667 | 4.522 |  |  | Size | Linear ft. |  |  | 0.375 | 1.5
 |  | 3/8x4 | 1.33 | 3.32367 |  |  | 3/8x4 | 0.8866666666666667 | 6.782999999999999 |  |  | 1/4x6 | 3
 |  | 3/8x5 | 0 | 0 |  |  | 3/8x5 | 0 | 0 |  |  | 1/4x5 | 3.33 |  |  | Grate Galv. | Sq ft.
 |  | 3/8x6 | 0 | 0 |  |  | 3/8x6 | 0 | 0 |  |  | 1/4x4 | 0 |  |  | 4x4x1/4 | 13
 |  | 1/2x7 | 0 | 0 |  |  | 1/2x7 | 0 | 0 |  |  | 1/4x3 | 13.33
 |  |  | flat bar cost | 5.53945 |  |  |  |  |  |  |  | 1/4x1 | 2.5 |  |  |  | Size | Number
 |  |  |  |  |  | Total | Angle | Flat Bar |  |  |  | 3/8x1 | 3 |  |  | Bolts | 3/8x1 1/4 | 8
 | Paint |  |  |  |  | Sq ft. 2 side | 49.66666666666666 | 1.773333333333333 | total weight |  |  | 3/8x3 | 1 |  |  | Nylon Nuts | 0.375 | 8
 |  | sq ft. to cover | [NAME] | raw price |  | Wt. | 240.3 | 11.305 | 251.605 |  |  |  |  |  |  | [NAME] | 0.375 | 8
 | Primer | 51.44 | 0.3025882352941177 | 15.79510588235294 |  |  |  |  |  |  |  | Paint | Gallons
 | Paint | 51.44 | 0.3025882352941177 | 14.21256941176471 |  |  | Hours | Shop Rate | Total Labor |  |  | Primer | 1.27
 |  |  | Paint Cost | 30.00767529411765 |  |  | 8.5 | 38 | 323 |  |  | Paint | 1.27 |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 |  |  | 50.165 | 38 | 1906.27
 |  |  |  |  |  |  |  | total raw cost of cap | 150.8911252941176
 |  |  |  |  |  |  |  |  | 196.1584628823529 |  |  |  | tubes
 |  |  |  |  |  |  |  |  |  |  |  | Silicone | 1
 |  |  |  |  |  |  |  | cost per lbs | 2.063386907582731
 |  |  |  |  |  |  |  |  |  |  |  | Length | [NAME]
 |  |  |  |  |  |  |  | total | 519.158462882353 |  |  | 37 | 37
 |  |  |  |  |  |  |  |  |  |  | w/ stiff | 41 | 41
 |  |  |  |  |  |  |  |  |  |  |  | 3.416666666666667 | 3.416666666666667 | 11.67361111111111
 |  |  |  |  |  |  |  |  |  |  |  |  | 6x6 circle area
 |  |  |  |  |  |  |  |  |  |  | bags | 16 | 28.274
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.1963472222222222 | 3.141555555555556
 |  |  |  |  |  |  |  |  |  |  |  |  | surface area of tubesheet w/ hole | 8.532055555555555