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

 | TB CAPS | JOB# | 36TB-BHT-09:S6 |  | DWG# | 1 | DATE: | 2014-02-27 00:00:00 |  |  |  | TB DAP | JOB# | 36TB-BHT-09:S6 |  | DWG# | 1 | DATE: | 2014-02-27 00:00:00 |  |  |  | CAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 35.82 | 156.7125 | 0.25 | 1.24 | 12.6604
 |  | 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 | 28 | 50.225 |  | [NAME] | 0.25 | 0 | 0 |  |  | [NAME]. | 12 | 40 | 71.75 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 3 | 15.3 | 2x2x1/4 | 2.1 | 6.699
 | Doors | 12 | 6.25 | 11.2109375 |  | Outlet Flange | 0.25 | 0.62 | 2.595382 |  |  | Timer Mount | 10 | 1.75 | 4.0359375 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 2.5 | 10.625 | 1/2x1/2x1/8 | 10 | 3.8
 | Mullion | 12 | 1.57 | 2.8161875 |  | Manifold Mount | 0.25 | 0.62 | 2.595382 |  |  | Inspection Door | 10 | 3.3 | 7.610624999999999 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 2.5 | 6.375 | 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 | 1.7 | 3-1/2x11ga | 0.5 | 2.166
 | (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.190764 |  |  |  |  | sheet metal cost | 83.3965625 |  |  |  |  |  |  | 3/8x1 | 0 | 0
 |  |  | sheet metal cost | 65.0131875 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 0 | 0 | total weight | 222.2824
 |  |  |  |  |  | Hand Rail Mt. | Size | Linear ft. | raw price |  |  | Flat Bar |  |  |  |  | Galv. Mesh | 4x4x1/4 | 7.2 | 3.6 |  | 3/8x6 | 0 | 0
 |  |  |  |  |  | 5” | 3x3x1/4 | 0 | 0 |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  |  |  | cost per lbs | 5.25591246967821 |  | 1.538583351628379
 | 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 | 2.5 | 5.20625 |  | 2”x # of blow tube | 2x2x1/4 | 2.1 | 3.21552 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 0.375 | 19.575 |  | 12 | 40 | 175 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 2.5 | 3.123749999999999 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 14 | 17.493 |  |  | Paint | 0.375 | 17.61375 |  | 10 | 5.05 | 28.40625 | 4x4x1/4 | 7.2 | 7.2
 | Handle 3” | 1/4x1 | 2 | 0.833 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 22 | 18.326 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 0 | 0
 | Hold Dn Strap 4 ½ | 3/8x1 | 3 | 1.87425 |  |  | 1/2x1/2x1/8 | 10 | 3.23 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 37.18875 |  | 1/4x3 | 14 | 35.7 | total weight | 283.9691
 | Hold Dn Strap 8 | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 22 | 37.4
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 35.819 |  |  |  | tubes | raw price |  | 0.375 | 0.7 | 0.26285
 | (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.962797400315739
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper 9 bag 60 deg
 |  |  | flat bar cost | 18.53425 |  | Outlet Stub | Size | Linear ft. | raw price |  |  | Round Rod | 0.375 | 0.7 | 0.26285 |  |  | Hours | Shop Rate | Total Labor |  |  | ft | weight |  | ft | weight
 |  |  |  |  |  |  | 3-1/2x11ga | 0.5 | 0.75 |  |  |  |  |  |  |  |  | 9 | 38 | 342 |  | 12 | 16 | 70 | 0.25 | 7.36 | 75.14560000000002
 |  | Paint |  |  |  |  |  |  |  |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 4x4x1/4 | 1 | 1
 |  |  | [NAME] | raw price |  | CAP Fittings |  |  | 124.43 |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x4 | 1 | 3.4
 |  | Primer | 0.275 | 14.355 |  |  |  |  |  |  |  | Bolts | 3/8x1 1/4 | 8 | 1.28 |  |  |  |  |  |  | 1/4x2 | 11 | 18.7 |  |  | Hours
 |  | Paint | 0.275 | 12.91675 |  |  | Hours | Shop Rate | Total Labor |  |  | Nylon Nuts | 0.375 | 8 | 1.2 |  |  |  |  |  |  | 3/8x3 | 0 | 0 | total weight | 170.4116 | 10.42
 |  |  | Paint Cost | 27.27175 |  |  | 22.17 | 38 | 842.46 |  |  | [NAME] | 0.375 | 8 | 0.48 |  |  |  |  |  |  | 0.375 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | mounting material | 2.96 |  |  |  |  |  |  | 3-1/2x11ga | 0.5 | 2.166 |  |  | Sell Price
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0 | 0 | cost per lbs | 3.005846343793497 | 512.2310848
 |  | Silicone | 0.5 | 2.445 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight
 |  |  |  |  |  |  |  | total raw cost of cap | 250.6437215 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 165.6721625 |  | 10 | 0 | 0 | total weight | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 0 | 0
 | TB Hopper | JOB# | 36TB-BHT-09:S6 |  | DWG# | 1 | DATE: | 2014-02-27 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 36TB-BHT-09:S6 |  | DWG# | 1 | 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 | 44.3925725
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price |  | 1/4x4 | Linear ft. | 0
 | Hopper | 12 | 16 | 28.7 |  | [NAME] | 0.25 | 1 | 4.1861 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 0 | 0 |  | 1/4x3 | 0 | 0
 | Inspection Door | 10 |  | 0 |  | Inlet Flange | 0.25 | 0.66 | 2.762826 |  |  | 6”x2” | 10 | 0 | 0 |  |  | 1/4x3 | 0 | 0 |  | tubesheet | 5.795375 | 44.3925725
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 2.5 | 10.46525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per lbs | 2.53736140206788
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 77
 |  |  | sheet metal cost | 28.7 |  | Baffle Plates | 0.25 | 3.2 | 13.39552 |  |  | 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.33 | 38 | 12.54
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 30.809696 |  |  | [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 |  |  |  | Tubesheet cost | 77 |  |  |  |  |  |  |  |  |  |  |  | 12 | 175
 | [NAME] | 1/4x3 | 0 | 0 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 0 | 0.9 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 9.84375
 | Foot pads | 1/4x4 | 1 | 1.666 |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  | Bolt, 5/8-11 x 3" lg Gr 8, zinc/yellow | 0 | 1.3 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x3 | 35.7
 | Hopper Flange | 1/4x2 | 11 | 9.163 |  | Nylon Nuts | 0.375 | 0 | 0 |  |  | Nylock Nut, 5/8-11, zinc | 0 | 0.25 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x2 | 37.4
 | (BLANK) | 3/8x1 | 0 | 0 |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  | Fitting Cost | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.375 | 0.26285
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | mounting material | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mesh | 7.2
 |  |  | flat bar cost | 10.829 |  |  |  |  |  |  |  |  | Paint |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 265.4066
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0 | 0
 | Round Rod | 0.375 | 0 | 0 |  |  | Primer | 0.18 | 9.396 |  |  |  | Safety Yellow | 0 | 0
 |  |  |  |  |  |  | Paint | 0.18 | 8.4546 |  |  |  |  | Paint Cost | 0
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 17.8506
 |  | 3-1/2x11ga | 0.5 | 0.75 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.288588904722038
 |  |  |  |  |  |  |  | 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 | 250.6437215 | 325.83683795 | 842.46 | 1168.29683795
 |  |  |  |  |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 165.6721625 | 215.37381125 | 342 | 557.37381125
 |  |  |  |  |  |  | 10.42 | 38 | 395.96 |  |  |  |  |  |  | Hopper | 89.439296 | 116.2710848 | 395.96 | 512.2310848
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 77 | 100.1 | 12.54 | 112.64
 |  |  |  |  |  |  |  | total raw cost of cap | 89.439296 |  |  |  |  | handrail cost- | 0 |  | total w/ [NAME] | 757.5817340000001 | 1592.96 | 2350.541734
 | Support Structure | JOB# | 36TB-BHT-09:S6 |  | DWG# | 1 | DATE: | 2014-02-27 00:00:00 |  |  |  | BUILD SHEET | JOB# | 36TB-BHT-09:S6 |  | DWG# | 1 | DATE: | 2014-02-27 00:00:00
 | Angle |  |  |  |  |  | Total Sq ft both side
 |  | Size | [NAME] | raw price |  | Angle | Size | Sq. Ft. | Wt.
 |  | 2x2x1/4 | 32.5 | 49.764 |  |  | 2x2x1/4 | 21.66666666666666 | 103.675
 |  | 2-1/2x2-1/2x1/4 | 0 | 0 |  |  | 2-1/2x2-1/2x1/4 | 0 | 0
 |  | 3x3x1/4 | 20 | 47.04 |  |  | 3x3x1/4 | 20 | 98
 |  | 4x4x1/4 | 0 | 0 |  |  | 4x4x1/4 | 0 | 0
 |  | 5x5x3/8 | 0 | 0 |  |  | 5x5x3/8 | 0 | 0
 |  | 6x6x3/8 | 0 | 0 |  |  | 6x6x3/8 | 0 | 0
 |  |  | Angle cost | 96.804
 | Flat Bar |  |  |  |  |  | Total Sq ft both side
 |  | Size | Linear ft. | raw price |  | Flat Bar | Size | Sq. Ft. | Wt.
 |  | 1/4x4 | 1.33 | 2.21578 |  |  | 1/4x4 | 0.8866666666666667 | 4.522
 |  | 3/8x4 | 1.33 | 3.32367 |  |  | 3/8x4 | 0.8866666666666667 | 6.782999999999999
 |  | 3/8x5 | 0 | 0 |  |  | 3/8x5 | 0 | 0
 |  | 3/8x6 | 0 | 0 |  |  | 3/8x6 | 0 | 0
 |  | 1/2x7 | 0 | 0 |  |  | 1/2x7 | 0 | 0
 |  |  | flat bar cost | 5.53945
 |  |  |  |  |  | Total | Angle | Flat Bar
 | Paint |  |  |  |  | Sq ft. 2 side | 41.66666666666666 | 1.773333333333333 | total weight
 |  | sq ft. to cover | [NAME] | raw price |  | Wt. | 201.675 | 11.305 | 212.98
 | Primer | 43.44 | 0.2555294117647059 | 13.33863529411765
 | Paint | 43.44 | 0.2555294117647059 | 12.00221647058824 |  |  | Hours | Shop Rate | Total Labor
 |  |  | Paint Cost | 25.34085176470588 |  |  | 8 | 38 | 304
 |  |  |  |  |  |  |  | total raw cost of cap | 127.6843017647059
 |  |  |  |  |  |  |  |  | 165.9895922941176
 |  |  |  |  |  |  |  | cost per lbs | 2.206731112283395
 |  |  |  |  |  |  |  | total | 469.9895922941176