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

 | TB CAPS | JOB# | 58TH-BHT-25:S6 |  | DWG# | 9 | DATE: | 2014-02-27 00:00:00 |  |  |  | TB DAP | JOB# | 58TH-BHT-25:S6 |  | DWG# | 9 | DATE: | 2014-02-27 00:00:00 |  |  |  | CAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 63.5 | 277.8125 | 0.25 | 1.62 | 16.5402
 |  | Gauge |  | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  | 10 | 0.5 | 2.8125 | 3x3x1/4 | 2.25 | 11.025
 | [NAME] | 12 | 45 | 80.71875 |  | [NAME] | 0.25 | 0 | 0 |  |  | [NAME]. | 12 | 96 | 172.2 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 3 | 15.3 | 2x2x1/4 | 4 | 12.76
 | Doors | 12 | 16 | 28.7 |  | Outlet Flange | 0.25 | 1 | 4.1861 |  |  | Timer Mount | 10 | 1.75 | 4.0359375 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 5 | 21.25 | 1/2x1/2x1/8 | 24 | 9.120000000000001
 | Mullion | 12 | 2.5 | 4.484375 |  | Manifold Mount | 0.25 | 0.62 | 2.595382 |  |  | Inspection Door | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 4 | 10.2 | 0.375 | 3 | 1.1265
 | Door Brackets | 10 | 0.5 | 1.153125 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x1 | 3.75 | 3.1875 | 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 | 6.781482 |  |  |  |  | sheet metal cost | 176.2359375 |  |  |  |  |  |  | 3/8x1 | 2 | 2.55
 |  |  | sheet metal cost | 115.05625 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 0 | 0 | total weight | 390.6362
 |  |  |  |  |  | Hand Rail Mt. | Size | Linear ft. | raw price |  |  | Flat Bar |  |  |  |  | Galv. Mesh | 4x4x1/4 | 0 | 0 |  | 3/8x6 | 0 | 0
 |  |  |  |  |  | 5” | 3x3x1/4 | 2.25 | 5.292 |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  |  |  | cost per lbs | 4.362545519590862
 | Flat Bar | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Lifting Lugs | 1/4x6 | 3 | 7.496999999999999 |  |  | 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 | 5 | 10.4125 |  | 2”x # of blow tube | 2x2x1/4 | 4 | 6.1248 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 0.85 | 44.37 |  | 12 | 96 | 420 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 4 | 4.997999999999999 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 47 | 58.72649999999999 |  |  | Paint | 0.85 | 39.92449999999999 |  | 10 | 1.75 | 9.84375 | 4x4x1/4 | 0 | 0
 | Handle 3” | 1/4x1 | 3.75 | 1.561875 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 32 | 26.656 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 3 | 15.3
 | Hold Dn Strap 4 ½ | 3/8x1 | 3 | 1.87425 |  |  | 1/2x1/2x1/8 | 24 | 7.752000000000001 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 84.2945 |  | 1/4x3 | 47 | 119.85 | total weight | 619.39375
 | Hold Dn Strap 8 | 3/8x1 | 2 | 1.2495 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 32 | 54.4
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 92.87949999999998 |  |  |  | tubes | raw price |  | 0.375 | 0 | 0
 | (BLANK) | 3/8x1 | 0 | 0 |  | 8” lg. 2 per door | 0.375 | 3 | 1.1265 |  |  |  |  |  |  |  |  | Silicone | 1.5 | 7.334999999999999 |  |  |  |  | cost per lbs | 1.524019928760986
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper 25 bag 60 deg
 |  |  | flat bar cost | 27.593125 |  | Outlet Stub | Size | Linear ft. | raw price |  |  | Round Rod | 0.375 | 0 | 0 |  |  | Hours | Shop Rate | Total Labor |  |  | ft | weight |  | ft | weight
 |  |  |  |  |  |  | 8x11ga | 0.5 | 4.225 |  |  |  |  |  |  |  |  | 12.5 | 38 | 475 |  | 12 | 38 | 166.25 | 0.25 | 9.5 | 96.995
 |  | Paint |  |  |  |  |  |  |  |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 3.33 | 18.73125 | 4x4x1/4 | 1 | 1
 |  |  | [NAME] | raw price |  | CAP Fittings |  |  | 182.06 |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x3 | 0 | 0
 |  | Primer | 0.67 | 34.974 |  |  |  |  |  |  |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 16 | 27.2 |  |  | Hours
 |  | Paint | 0.5 | 23.485 |  |  | Hours | Shop Rate | Total Labor |  |  | Nylon Nuts | 0.375 | 0 | 0 |  |  |  |  |  |  | 3/8x6 | 1.5 | 11.475 | total weight | 334.9645 | 16
 |  |  | Paint Cost | 58.459 |  |  | 30.5 | 38 | 1159 |  |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  |  |  | 0.375 | 1.5 | 0.56325
 |  |  |  |  |  |  |  |  |  |  |  |  |  | mounting material | 0 |  |  |  |  |  |  | 8x11ga | 1 | 12.75 |  |  | Sell Price
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0 | 0 | cost per lbs | 2.591642035947093 | 868.10807875
 |  | Silicone | 1 | 4.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight
 |  |  |  |  |  |  |  | total raw cost of cap | 419.360157 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 360.7449374999999 |  | 10 | 0.33 | 1.85625 | total weight | 92.85625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 15 | 51
 | TB Hopper | JOB# | 58TH-BHT-25:S6 |  | DWG# | 9 | DATE: | 2014-02-27 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 58TH-BHT-25:S6 |  | DWG# | 9 | DATE: | 2014-02-27 00:00:00 |  |  | 1-1/2x1-1/2x11ga | 50 | 40 | cost per lbs | 6.449159332301272
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Handrail |  |  |  |  | Tubesheet |  |  |  |  |  | ft | weight | total weight | 103.7193680555555
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price |  | 1/4x4 | 4 | 13.6
 | Hopper | 12 | 38 | 68.1625 |  | [NAME] | 0.25 | 1 | 4.1861 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 4 | 6.664 |  | 1/4x3 | 0 | 0
 | Inspection Door | 10 | 3.33 | 7.6798125 |  | Inlet Flange | 0.25 | 1 | 4.1861 |  |  | 6”x2” | 10 | 0.33 | 0.7610625 |  |  | 1/4x3 | 0 | 0 |  | tubesheet | 11.76493055555555 | 90.11936805555553
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 3 | 12.5583 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per lbs | 1.925032939778941
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 125
 |  |  | sheet metal cost | 75.84231249999999 |  | Baffle Plates | 0.25 | 4.5 | 18.83745 |  |  | Kick Plate | 1/4x4 | 15 | 24.99
 |  |  |  |  |  | (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.75 | 38 | 28.5
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 39.76795 |  |  | [NAME] | 1-1/2x1-1/2x11ga | 50 | 62
 | (BLANK) | 1/4x6 | 0 | 0
 | (BLANK) | 1/4x5 | 0 | 0 |  | Inspection Door |  |  |  |  |  | Item | Qty | Price | Ext Price |  |  |  | [NAME] | 131.664
 | [NAME] | 1/4x3 | 0 | 0 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 26 | 0.9 | 23.4
 | Foot pads | 3/8x5 | 1.5 | 4.685625 |  | 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 | 16 | 13.328 |  | 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 | 18.013625 |  |  |  |  |  |  |  |  | Paint
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0.33 | 17.226
 | Round Rod | 0.375 | 1.5 | 0.56325 |  |  | Primer | 0.5 | 26.1 |  |  |  | Safety Yellow | 0.33 | 18.2589
 |  |  |  |  |  |  | Paint | 0.5 | 23.485 |  |  |  |  | Paint Cost | 35.4849
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 49.585
 |  | 8x11ga | 1 | 8.45 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  | tubes | raw price |  |  |  | 10.2 | 38 | 387.6
 | Bag Grate Mat |  | Sq. ft. | raw price |  |  | Silicone | 0.9 | 4.401 |  |  |  |  |  |  |  |  | 0.3 | Labor | total
 | Galv. Mesh | 4x4x1/4 | 1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  | CAP | 419.360157 | 545.1682041 | 1159 | 1704.1682041
 |  |  |  |  |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 360.7449374999999 | 468.96841875 | 475 | 943.96841875
 |  |  |  |  |  |  | 16 | 38 | 608 |  |  |  |  |  |  | Hopper | 200.0831375 | 260.1080787500001 | 608 | 868.10807875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 162.4959625 | 211.24475125 | 387.6 | 598.84475125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 131.664 | 171.1632 | 28.5 | 199.6632
 |  |  |  |  |  |  |  | total raw cost of cap | 200.0831375 |  |  |  |  | handrail cost- | 162.4959625 |  | total w/ [NAME] | 1656.65265285 | 2658.1 | 4314.75265285
 | Support Structure | JOB# | 58TH-BHT-25:S6 |  | DWG# | 9 | DATE: | 2014-02-27 00:00:00 |  |  |  | BUILD SHEET | JOB# | 58TH-BHT-25:S6 |  | DWG# | 9 | 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 | 50
 |  | 2x2x1/4 | 44 | 67.3728 |  |  | 2x2x1/4 | 29.33333333333333 | 140.36 |  |  | 16 | 0 |  |  | 1/2x1/2x1/8 | 24
 |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 14 | 0 |  |  | 2x2x1/4 | 4
 |  | 3x3x1/4 | 0 | 0 |  |  | 3x3x1/4 | 0 | 0 |  |  | 12 | 197.5 |  |  | 3x3x1/4 | 2.25
 |  | 4x4x1/4 | 26.7 | 84.5856 |  |  | 4x4x1/4 | 35.59999999999999 | 176.22 |  |  | 10 | 5.91
 |  | 5x5x3/8 | 0 | 0 |  |  | 5x5x3/8 | 0 | 0 |  |  | 0.1875 | 0 |  |  | Tube | Linear ft.
 |  | 6x6x3/8 | 0 | 0 |  |  | 6x6x3/8 | 0 | 0 |  |  | 0.25 | 11.12 |  |  | 3 1/2x 11ga | 0
 |  |  | Angle cost | 151.9584 |  |  |  |  |  |  |  | 0.3125 | 0 |  |  | 5x11ga | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0.375 | 0 |  |  | 8x11ga | 1.5
 | 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 | 4.5
 |  | 3/8x4 | 0 | 0 |  |  | 3/8x4 | 0 | 0 |  |  | 1/4x6 | 6
 |  | 3/8x5 | 1.75 | 5.4665625 |  |  | 3/8x5 | 1.458333333333333 | 11.15625 |  |  | 1/4x5 | 5 |  |  | Grate Galv. | Sq ft.
 |  | 3/8x6 | 0 | 0 |  |  | 3/8x6 | 0 | 0 |  |  | 1/4x4 | 19 |  |  | 4x4x1/4 | 1
 |  | 1/2x7 | 0 | 0 |  |  | 1/2x7 | 0 | 0 |  |  | 1/4x3 | 47
 |  |  | flat bar cost | 7.682342500000001 |  |  |  |  |  |  |  | 1/4x1 | 3.75 |  |  |  | Size | Number
 |  |  |  |  |  | Total | Angle | Flat Bar |  |  |  | 3/8x1 | 5 |  |  | Bolts | 3/8x1 1/4 | 8
 | Paint |  |  |  |  | Sq ft. 2 side | 64.93333333333332 | 2.345 | total weight |  |  | 3/8x3 | 0 |  |  | Nylon Nuts | 0.375 | 8
 |  | sq ft. to cover | [NAME] | raw price |  | Wt. | 316.58 | 15.67825 | 332.25825 |  |  |  |  |  |  | [NAME] | 0.375 | 8
 | Primer | 67.27833333333332 | 0.3957549019607842 | 20.65840588235294 |  |  |  |  |  |  |  | Paint | Gallons
 | Paint | 67.27833333333332 | 0.3957549019607842 | 18.58860774509803 |  |  | Hours | Shop Rate | Total Labor |  |  | Primer | 2.02
 |  |  | Paint Cost | 39.24701362745097 |  |  | 10 | 38 | 380 |  |  | Paint | 1.85 |  |  | Hours | Shop Rate | Total Labor
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.33 |  |  | 69.95 | 38 | 2658.1
 |  |  |  |  |  |  |  | total raw cost of cap | 198.887756127451
 |  |  |  |  |  |  |  |  | 258.5540829656862 |  |  |  | tubes
 |  |  |  |  |  |  |  |  |  |  |  | Silicone | 3.4
 |  |  |  |  |  |  |  | cost per lbs | 1.921860730217192
 |  |  |  |  |  |  |  |  |  |  |  | Length | [NAME]
 |  |  |  |  |  |  |  | total | 638.5540829656862 |  |  | 45 | 45
 |  |  |  |  |  |  |  |  |  |  | w/ stiff | 49 | 49
 |  |  |  |  |  |  |  |  |  |  |  | 4.083333333333333 | 4.083333333333333 | 16.67361111111111
 |  |  |  |  |  |  |  |  |  |  |  |  | 6x6 circle area
 |  |  |  |  |  |  |  |  |  |  | bags | 25 | 28.274
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.1963472222222222 | 4.908680555555556
 |  |  |  |  |  |  |  |  |  |  |  |  | surface area of tubesheet w/ hole | 11.76493055555555