Spreadsheet: 330716d1404835241-how-to-expand-rows-unit-quote
Sheet: Final Price Builder

 | TB CAPS | JOB# |  |  | DWG# |  | DATE: |  |  |  |  | TB DAP | JOB# | 0 |  | DWG# | 0 | DATE: | 1900-01-01 00:00:00 |  |  |  | CAP | cost per lbs |  |  |  |  | Tubesheet | cost per lbs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ft | weight |  | ft | weight |  | ft | weight | total weight | #N/A
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Sheet |  |  |  |  | Plate |  |  |  |  | 12 | 0 | 0 | 0.25 | 0 | 0 | 1/4x4 | 0 | 0
 |  | Gauge |  | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  | 10 | 0 | 0 | 3x3x1/4 | 0 | 0 | 1/4x3 | 0 | 0
 | [NAME] | 12 | 0 | 0 |  | [NAME] | 0.25 | 0 | 0 |  |  | [NAME]. | 12 | 0 | 0 |  | [NAME] | 0.25 | 0 | 0 |  | 1/4x6 | 0 | 0 | 2x2x1/4 | 0 | 0 | tubesheet | #N/A | #N/A
 | Doors | 12 | 0 | 0 |  | Outlet Flange | 0.25 | 0 | 0 |  |  | Timer Mount | 10 | 0 | 0 |  | Backing Plates | 0.25 | 0 | 0 |  | 1/4x5 | 0 | 0 | 1/2x1/2x1/8 | 0 | 0 |  |  |  | cost per lbs | #N/A
 | Mullion | 12 | 0 | 0 |  | Manifold Mount | 0.25 | 0 | 0 |  |  | Inspection Door | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x3 | 0 | 0 | 0.375 | 0 | 0
 | Door Brackets | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  | 1/4x1 | 0 | 0 | 3-1/2x11ga | 0 | 0
 | (BLANK) | 10 | 0 | 0 |  | (BLANK) | 0.25 | 0 | 0 |  |  | (BLANK) | 10 | 0 | 0 |  |  |  | [NAME] cost | 0 |  | 3/8x1 | 0 | 0 | 12 | 0 | 0
 | (BLANK) | 12 | 0 | 0 |  |  |  | [NAME] cost | 0 |  |  |  |  | sheet metal cost | 0 |  |  |  |  |  |  | 3/8x1 | 0 | 0
 |  |  | sheet metal cost | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Bag Grate Mat |  | Sq. ft. | raw price |  | 1/4x2 | 0 | 0 |  | total weight | 0
 |  |  |  |  |  | Hand Rail Mt. | Size | Linear ft. | raw price |  |  | Flat Bar |  |  |  |  | Galv. Mesh | 4x4x1/4 | 0 | 0 |  | 3/8x6 | 0 | 0
 |  |  |  |  |  | 5” | 3x3x1/4 | 0 | 0 |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  |  |  |  | cost per lbs | #N/A
 | Flat Bar | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Lifting Lugs | 1/4x6 | 0 | 0 |  |  | Paint |  |  |  |  | Dap | cost per lbs
 | Lifting Lugs | 1/4x6 | 0 | 0 |  | [NAME]. Angle | Size | Linear ft. | raw price |  |  | (BLANK) | 1/4x5 | 0 | 0 |  |  |  | [NAME] | raw price |  |  | ft | weight |  | ft | weight
 | Mullion Stiffener | 1/4x5 | 0 | 0 |  | 2”x # of blow tube | 2x2x1/4 | 0 | 0 |  |  | (BLANK) | 1/4x4 | 0 | 0 |  |  | Primer | 0 | 0 |  | 12 | 0 | 0 | 0.25 | 0 | 0
 | [NAME] | 1/4x3 | 0 | 0 |  |  |  |  |  |  |  | Housing Stiffener | 1/4x3 | 0 | 0 |  |  | Paint | 0 | 0 |  | 10 | 0 | 0 | 4x4x1/4 | 0 | 0
 | Handle 3” | 1/4x1 | 0 | 0 |  | Perimeter of Doors | Size | Linear ft. | raw price |  |  | Housing Flange | 1/4x2 | 0 | 0 |  |  | Safety Yellow | 0 | 0 |  | 1/4x6 | 0 | 0
 | Hold Dn Strap 4 ½ | 3/8x1 | 0 | 0 |  |  | 1/2x1/2x1/8 | 0 | 0 |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  | Paint Cost | 0 |  | 1/4x3 | 0 | 0 | total weight | 0
 | Hold Dn Strap 8 | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 0 | 0
 | Mullion Stiff Tube | 6x2x1/4 | 0 | 0 |  | Round Rod | Size | Linear ft. | raw price |  |  |  |  | flat bar cost | 0 |  |  |  | tubes | raw price |  | 0.375 | 0 | 0
 | (BLANK) | 3/8x1 | 0 | 0 |  | 8” lg. 2 per door | 0.375 | 0 | 0 |  |  |  |  |  |  |  |  | Silicone | 0 | 0 |  |  |  |  |  | cost per lbs | #N/A
 | (BLANK) | 3/8x1 | 0 | 0 |  |  |  |  |  |  |  |  | Size | Linear ft. | raw price |  |  |  |  |  |  |  | Hopper | cost per lbs
 |  |  | flat bar cost | 0 |  | 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 |  |  |  |  |  |  |  |  | 0 | 38 | 0 |  | 12 | 0 | 0 | 0.25 | 0 | 0
 |  | Paint |  |  |  | sheet | 12 | 0 | 0 |  |  | Inspection Door |  |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 4x4x1/4 | 0 | 0
 |  |  | [NAME] | raw price |  |  |  |  |  |  |  |  | Size | Number | raw price |  |  |  |  |  |  | 1/4x4 | 0 | 0
 |  | Primer | 0 | 0 |  | CAP Fittings |  |  | 0 |  |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  |  |  |  |  | 1/4x2 | 0 | 0
 |  | Paint | 0 | 0 |  |  |  |  |  |  |  | Nylon Nuts | 0.375 | 0 | 0 |  |  |  |  |  |  | 3/8x3 | 0 | 0 |  | total weight | 0
 |  |  | Paint Cost | 0 |  |  | Hours | Shop Rate | Total Labor |  |  | [NAME] | 0.375 | 0 | 0 |  |  |  |  |  |  | 0.375 | 0 | 0
 |  |  |  |  |  |  | 0 | 38 | 0 |  |  |  |  | mounting material | 0 |  |  |  |  |  |  | 3-1/2x11ga | 0 | 0
 |  |  | tubes | raw price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0 | 0 |  | cost per lbs | #N/A
 |  | Silicone | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handrail | cost per lbs
 |  |  |  |  |  |  |  | total raw cost of cap | 0 |  |  |  |  |  |  |  |  |  | total raw cost of dap | 0 |  |  | ft | weight
 |  |  |  |  |  |  |  | 0.3 | 0 |  |  |  |  |  |  |  |  |  | 0.3 | 0 |  | 10 | 0 | 0 |  | total weight | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4x4 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-1/2x1-1/2x11ga | 0 | 0 |  | cost per lbs | #N/A
 | TB Hopper | JOB# | 0 |  | DWG# | 0 | DATE: | 1900-01-01 00:00:00 |  |  |  | Handrail/Tubesheet | JOB# | 0 |  | DWG# | 0 | DATE: | 1900-01-01 00:00:00
 | Sheet |  |  |  |  | Plate |  |  |  |  |  | Handrail |  |  |  |  | Tubesheet
 |  | Gauge | Sq. ft. | raw price |  |  | Gauge | Sq. ft. | raw price |  |  |  |  |  |  |  | Tubesheet Stiffeners |  | Linear ft. | raw price
 | Hopper | 12 | 0 | 0 |  | [NAME] | 0.25 | 0 | 0 |  |  | [NAME] | Gauge | Linear ft. | raw price |  |  | 1/4x4 | 0 | 0
 | Inspection Door | 10 | 0 | 0 |  | Inlet Flange | 0.25 | 0 | 0 |  |  | 6”x2” | 10 | 0 | 0 |  |  | 1/4x3 | 0 | 0
 | (BLANK) | 12 | 0 | 0 |  | Support Lugs | 0.25 | 0 | 0
 | (BLANK) | 12 | 0 | 0 |  | Foot pads | 0.25 | 0 | 0 |  |  | Flat Bar |  |  |  |  | Tubesheet | Purchased |  | 0
 |  |  | sheet metal cost | 0 |  | Baffle Plates | 0.25 | 0 | 0 |  |  | Kick Plate | 1/4x4 | 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 | 38 | 0
 |  | Size | Linear ft. | raw price |  |  |  | [NAME] cost | 0 |  |  | [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 |  |  |  | [NAME] | 0
 | [NAME] | 1/4x3 | 0 | 0 |  |  | Size | Number | raw price |  |  | [NAME], 5/16" USS, zinc | 0 | 0.9 | 0 |  |  |  | 0.3 | 0
 | Hopper Flange | 1/4x2 | 0 | 0 |  | Bolts | 3/8x1 1/4 | 0 | 0 |  |  | Bolt, 5/8-11 x 3" lg Gr 8, zinc/yellow | 0 | 0.25 | 0
 | Foot pads | 3/8x5 | 0 | 0 |  | Nylon Nuts | 0.375 | 0 | 0 |  |  | Nylock Nut, 5/8-11, zinc | 0 | 0.18 | 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 | 0 |  |  |  |  |  |  |  |  | Paint
 |  |  |  |  |  |  | Paint |  |  |  |  |  |  | [NAME] | raw price
 |  | Size | Linear ft. |  |  |  |  | [NAME] | raw price |  |  |  | Primer | 0 | 0
 | Round Rod | 0.375 | 0 | 0 |  |  | Primer | 0 | 0 |  |  |  | Safety Yellow | 0 | 0
 |  |  |  |  |  |  | Paint | 0 | 0 |  |  |  |  | Paint Cost | 0
 | Inlet Stub | Size | Linear ft. | raw price |  |  |  | Paint Cost | 0
 | round rod | 8x11ga | 0 | 0 |  |  |  |  |  |  |  |  | Hours | Shop Rate | Total Labor
 | sheet | 12 | 0 | 0 |  |  |  | tubes | raw price |  |  |  | 0 | 38 | 0
 |  |  |  |  |  |  | Silicone | 0 | 0 |  |  |  |  |  |  |  | raw | 0.3 | labor | total
 | Bag Grate Mat |  | Sq. ft. | raw price |  |  |  |  |  |  |  |  |  |  |  | CAP | 0 | 0 | 0 | 0
 | Galv. Mesh | 4x4x1/4 | 0 | 0 |  |  | Hours | Shop Rate | Total Labor |  |  |  |  |  |  | DAP | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 38 | 0 |  |  |  |  |  |  | Hopper | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tubesheet | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | total raw cost of cap | 0 |  |  |  | handrail cost- | 0
 |  |  |  |  |  |  |  | 0.3 | 0 |  |  |  | 0.3 | 0 |  | total w/ [NAME] | 0 | 0 | 0 | 0
120TB-BVWT-64:S6 |  |  | JOB:13-148 |  |  |  |  |  |  |  |  | BUILD SHEET | JOB# | 0 |  | DWG# | 0 | DATE: | 1900-01-01 00:00:00
Sheet/Plate | Gauge |  | Material Cost |  | Round Tube | Size | Linear ft. | Material Cost
 | 12 | 576 | 1033.2 |  |  | 5x11ga | 0 | 0 |  |  |  | Sheet |  |  |  |  | Angle | Linear ft.
 | 12 | 36 | 64.575 |  |  | 5x11ga | 0 | 0 |  |  |  | Gauge | Sq. ft |  |  |  | 1 1/2x1 1/2x 11ga | 0
 | 12 | 24 | 43.05 |  |  | 5x11ga | 0 | 0 |  |  |  | 16 | 0 |  |  |  | 1/2x1/2x1/8 | 10
 | 10 | 24 | 55.34999999999999 |  |  | 5x11ga | 0 | 0 |  |  |  | 14 | 0 |  |  |  | 2x2x1/4 | 2.1
 | 10 | 0 | 0 |  |  |  | Rtube Cost | 0 |  |  |  | 12 | 91.82 |  |  |  | 3x3x1/4 | 0
 | 12 | 5 | 8.96875 |  |  |  |  |  |  |  |  | 10 | 5.38
 | 0.25 | 1.5 | 6.27915 |  | Square Tube | Size | Linear ft. | Material Cost |  |  |  | 0.1875 | 0 |  |  |  | Tube | Linear ft.
 | 0.5 | 2.5 | 25.525 |  |  | 1-1/2x1-1/2x11 | 40 | #N/A |  |  |  | 0.25 | 8.6 |  |  |  | 3 1/2x 11ga | 0
 | 0.375 | 1.25 | 8.043 |  |  | 5x11ga | 0 | 0 |  |  |  | 0.3125 | 0 |  |  |  | 5x11ga | 0
 | 0.25 | 0 | 0 |  |  | 5x11ga | 0 | 0 |  |  |  | 0.375 | 0 |  |  |  | 8x11ga | 0
 | 0.25 | 0 | 0 |  |  | 5x11ga | 1 | 0
 |  | Sheet Cost | 1244.9909 |  |  |  | Sq. Tube Cost | #N/A |  |  |  | Flat Bar |  |  |  |  | Round Rod | Linear ft.
 |  |  |  |  |  |  |  |  |  |  |  | Size | Linear ft. |  |  |  | 0.375 | 1.5
Flat Bar | Size | Linear ft. | Material Cost |  | Channel | Size | Linear ft. | Material Cost |  |  |  | 1/4x6 | 3
 | 1/4x6 | 15 | 37.48499999999999 |  |  | C3x4.1 | 30 | 59.04 |  |  |  | 1/4x5 | 2.5 |  |  |  | Grate Galv. | Sq ft.
 | 1/4x5 | 0 | 0 |  |  | C3x4.1 | 0 | 0 |  |  |  | 1/4x4 | 1 |  |  |  | 4x4x1/4 | 8.2
 | 1/4x4 | 20 | 33.32 |  |  | C3x4.1 | 0 | 0 |  |  |  | 1/4x3 | 14
 | 1/4x3 | 200 | 249.9 |  |  |  | Channel Cost | 59.04 |  |  |  | 1/4x1 | 2 |  |  |  |  | Size | Number
 | 1/4x2 | 80 | 66.64 |  |  |  |  |  |  |  |  | 3/8x1 | 3 |  |  |  | Bolts | 3/8x1 1/4 | 8
 | 1/4x1-1/2 | 47 | 29.36325 |  | Paint | [NAME] | Cost Gallon | Material Cost |  |  |  | 3/8x3 | 0 |  |  |  | Nylon Nuts | 0.375 | 8
 | 3/8x1 | 0 | 0 |  | PC1 | 0.4 | 42.5 | 17 |  |  |  |  |  |  |  |  | [NAME] | 0.375 | 8
 | 3/8x1 | 0 | 0 |  | PC2 | 4.75 | 52 | 247 |  |  |  | Paint | Gallons
 | 1/4x4 | 10 | 16.66 |  | TC1 | 4.5 | 92 | 414 |  |  |  | Primer | 0.8300000000000001
 | 1/4x3 | 22 | 27.489 |  | TC2 | 0.4 | 55 | 22 |  |  |  | Paint | 0.8300000000000001 |  |  |  | Hours | Shop Rate | Total Labor
 | 1/4x2 | 2 | 1.666 |  | [NAME] | 0 |  | 0 |  |  |  | [NAME] | 0 |  |  |  | 41.92 | 38 | 1592.96
 |  | Flat Bar Cost | 462.52325 |  |  |  | Paint Cost | 700
 |  |  |  |  |  |  |  |  |  |  |  |  | tubes |  |  |  |  | Length | [NAME]
Angle | Size | Linear ft. | Material Cost |  |  |  | tubes | Material Cost |  |  |  | Silicone | 1 |  |  |  |  | 29 | 29
 | 2-1/2x2-1/2x1/4 | 36 | 70.848 |  |  | Silicone | 7.5 | 0 |  |  |  |  |  |  |  |  | w/ stiff | 33 | 33
 | 2x2x1/4 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.75 | 2.75 | 7.5625
 | 1-1/2x2-1/2x1/4 | 20 | #N/A |  | CAP Fittings | (from CAP Sheet) |  | 382 |  |  |  |  |  |  |  |  |  |  | 6x6 circle area
 | 3x3x1/4 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | bags | 9 | 28.274
 | 2x2x1/4 | 0 | 0 |  | Tube Sheet |  |  | 275 |  |  |  |  |  |  |  |  |  |  | 0.1963472222222222 | 1.767125
 | 1/2x1/2x1/8 | 0 | 0
 |  | Angle Cost | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | surface area of tubesheet w/ hole | 5.795375
 |  |  |  |  | [NAME]. |  |  | Cost
Bag Grate Mat |  | Sq. ft. | Material Cost |  | Blue Styrofoam | 4x8 |  | 18
Galv. Mesh | 4x4x1/4 | 48 | 24 |  | Sandblasting |  |  | 420
 | 3/16x1-1/4 | 18 | #N/A |  | Galv. |  |  | 182
 |  | Mesh Cost | #N/A
 |  |  |  |  |  | Hours | Shop Rate | Total Labor
Round Rod | Size | Linear ft. | Material Cost |  |  | 168 | 37 | 6216
 | 0.75 | 18 | 27.036
 | 0.375 | 0 | 0 |  |  |  | Total Material Cost CAP | #N/A
 | 0.375 | 0 | 0 |  |  |  | (Less Handrail Hardwe)
 | 0.375 | 0 | 0 |  |  |  |  | 0.3
 |  | Rrod Cost | 27.036 |  |  |  |  | #N/A
 |  |  |  |  |  |  | total- | #N/A