Spreadsheet: john_hodge__16252__MIDWAY SUMMARY
Sheet: MATL - Meter Sta

[NAME]
[NAME] of Materials
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Total: |  | 258260.8804706171
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Contractor Supplied |  |  | 3485.339093609598
Pipe |  |  |  | Size (O.D.) | qty | unit |  |  | wall |  | f p b | Gr |  | Amount | Unit |  | Total | 7727.719154785271
 |  | Bare,  0.154 wall, Gr. B |  | 2 | 80 | ft |  |  | std |  | b | b |  | 2.00937390813773 | ft |  | 160.7499126510184
 |  | Bare,  0.375 wall, Gr. B |  | 12 | 240 | ft |  |  | std |  | b | b |  | 24.78422079371073 | ft |  | 5948.212990490574
 |  | Bare,  0.237 wall, Gr. B |  | 4 | 30 | ft |  |  | std |  | b | b |  | 6.151305890855832 | ft |  | 184.539176725675
 |  | Bare,  0.365 wall, Gr. B |  | 10 | 20 | ft |  |  | std |  | b | b |  | 23.07825728591551 | ft |  | 461.5651457183102
 |  | Bare,  0.365 wall, Gr. B |  | 10 | 40 | ft |  |  | std |  | b | b |  | 23.07825728591551 | ft |  | 923.1302914366204
 |  | Bare,  0.179 wall, Gr. B |  | 1 | 40 | ft |  |  | xs |  | b | b |  | 1.238040944076929 | ft |  | 49.52163776307714
Valves - Ball |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  | W/F |  |  |  | Amount | Unit |  | Total | 62140
 |  | Valves - Ball |  | 4 | 3 | ea. |  | 600 |  | F |  |  |  | 3200 | ea. |  | 9600
 |  | Valves - Ball |  | 12 | 2 | ea. |  | 600 |  | F |  |  |  | 10230 | ea. |  | 20460
 |  | Valves - Ball |  | 2 | 1 | ea. |  | 600 |  | F |  |  |  | 1390 | ea. |  | 1390
 |  | Valves - Ball |  | 12 | 3 | ea. |  | 600 |  | F |  |  |  | 10230 | ea. |  | 30690
Valves - Control |  |  |  | Size (O.D.) | qty | unit |  | Type |  |  |  |  |  | Amount | Unit |  | Total | 0
Valve Actuators |  |  |  | Size (O.D.) | qty | unit |  | Type |  |  |  |  |  | Amount | Unit |  | Total | 21700
 |  | Valve Actuators |  | 12 | 2 | ea. |  |  |  |  |  |  |  | 9700 | ea. |  | 19400
 |  | Valve Actuators |  | 4 | 1 | ea. |  |  |  |  |  |  |  | 2300 | ea. |  | 2300
Gas Filtering |  |  |  |  | qty | unit |  | (MM/d) |  |  |  |  |  | Amount | Unit |  | Total | 38000
 |  | Coalescing Filter by Peerless |  |  | 1 | ea. |  | 125 |  |  |  |  |  | 38000 | ea. |  | 38000
Elbow |  |  |  | Size (O.D.) | qty | unit |  | Deg |  |  | Gr |  |  | Amount | Unit |  | Total | 967.6000000000058
 |  | Elbow |  | 4 | 2 | ea. |  | 90 |  |  | b |  |  | 7.8 | ea. |  | 15.6
 |  | Elbow |  | 12 | 10 | ea. |  | 90 |  |  | b |  |  | 94 | ea. |  | 940
 |  | Elbow |  | 1 | 4 | ea. |  | 90 |  |  | b |  |  | 3 | ea. |  | 12
Reducers |  |  |  | Run     x | qty | unit |  | Branch |  |  | Gr |  |  | Amount | Unit |  | Total | 360
 |  | reducer |  | 12 x 10 | 2 | ea. |  |  |  |  | 42 |  |  | 110 | ea. |  | 220
 |  | reducer |  | 16 x 12 | 1 | ea. |  |  |  |  | 42 |  |  | 140 | ea. |  | 140
Tees |  |  |  | O.D. | qty | unit |  |  |  |  | Gr |  |  | Amount | Unit |  | Total | 375
 |  | Tee |  | 12 | 1 | ea. |  |  |  |  | b |  |  | 125 | ea. |  | 125
 |  | Tee |  | 12 | 2 | ea. |  |  |  |  | b |  |  | 125 | ea. |  | 250
Meters |  |  |  | OD | qty | unit |  | ANSI |  | Style |  |  |  | Amount | Unit |  | Total | 2300
 |  | Roots Rotary |  | 1 | 1 | ea. |  |  |  | M |  |  |  | 2300 | ea |  | 2300
Tees (Reducing) |  |  |  | Run     x | qty | unit |  | Branch |  |  | Gr |  |  | Amount | Unit |  | Total | 1174.222222222219
 |  | tee reducing |  | 16 | 2 | ea. |  | 4 |  |  | 42 |  |  | 476 | ea. |  | 952
 |  | tee reducing |  | 12 | 2 | ea. |  | 4 |  |  | b |  |  | 111.1111111111111 | ea. |  | 222.2222222222222
Bolt-up & Gaskets |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  |  |  |  |  | Amount | Unit |  | Total | 902
 |  | Bolt-up & Gaskets |  | 4 | 4 | sets |  | 600 |  |  |  |  |  | 24 | ea. |  | 96
 |  | Bolt-up & Gaskets |  | 12 | 5 | sets |  | 600 |  |  |  |  |  | 112 | ea. |  | 560
 |  | Bolt-up & Gaskets |  | 10 | 3 | sets |  | 600 |  |  |  |  |  | 82 | ea. |  | 246
Flanges |  |  |  | Size (O.D.) | qty | unit |  | ANSI | wall |  |  |  |  | Amount | Unit |  | Total | 6110
 |  | Flange |  | 4 | 6 | ea. |  | 600 | std |  |  |  |  | 65 | ea. |  | 390
 |  | Flange |  | 12 | 6 | ea. |  | 600 | std |  |  |  |  | 350 | ea. |  | 2100
 |  | Flange |  | 12 | 5 | ea. |  | 600 | std |  |  |  |  | 350 | ea. |  | 1750
 |  | Flange |  | 10 | 6 | ea. |  | 600 | std |  |  |  |  | 240 | ea. |  | 1440
 |  | Flange - Blind |  | 12 | 1 | ea. |  | 600 | std |  |  |  |  | 430 | ea. |  | 430
Transmitters |  |  |  |  | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 4604
 |  | Pressure 3051CG |  |  | 2 | ea. |  |  |  |  |  |  |  | 1280 | ea. |  | 2560
 |  | Temperature 3144 w/sensor |  |  | 2 | ea. |  |  |  |  |  |  |  | 1022 | ea. |  | 2044
[NAME] |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  |  |  |  |  | Amount | Unit |  | Total | 4870
 |  | Strainer T - type |  | 4 | 1 | ea. |  | 600 |  |  |  |  |  | 655 | ea |  | 655
 |  | Gallagher Flow Conditioners |  | 10 | 1 | ea. |  |  |  |  |  |  |  | 4215 | ea |  | 4215
Meters |  |  |  | OD/Model | qty | unit |  | ANSI |  |  |  |  |  | Amount | Unit |  | Total | 43160
 |  | Q sonic |  | 10 | 1 | ea. |  | 600 |  |  |  |  |  | 29060 | ea |  | 29060
 |  | Ultrasonic [NAME] (3) |  | 10 | 1 | ea. |  | 600 |  |  |  |  |  | 5600 | ea |  | 5600
 |  | Q Sonic Calibration |  | 10 | 1 | ea. |  | 600 |  |  |  |  |  | 8500 | ea |  | 8500
RTU / PLC |  |  |  |  | qty | unit |  | Hrs |  |  |  |  |  | Amount | Unit |  | Total | 3500
 |  | Bristal 3335 |  |  | 1 | ea. |  |  |  |  |  |  |  | 3500 | ea |  | 3500
 |  | Bristal 3330 |  |  |  | ea. |  |  |  |  |  |  |  | 6000 | ea
[NAME] |  |  |  | Nom. (O.D.) | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 1370
 |  | [NAME] (Adj.) |  | 12 | 4 |  |  |  |  |  |  |  |  | 140 | ea. |  | 560
 |  | [NAME] (Adj.) |  | 10 | 4 |  |  |  |  |  |  |  |  | 120 | ea. |  | 480
 |  | [NAME] (Adj.) |  | 4 | 6 |  |  |  |  |  |  |  |  | 55 | ea. |  | 330
Fences |  |  |  | length | qty | unit |  | width |  |  |  |  |  | Amount | Unit |  | Total | 2450
 |  | 8' fence w/ poles |  | 200 | 550 | ft |  | 75 |  |  |  |  |  | 10.5 | ft |  | 2100
 |  | gate ( 16' drive) |  |  | 1 | ea. |  |  |  |  |  |  |  | 350 | ea |  | 350
Rock/Dirt/Conc. |  |  |  | OD | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 3735.339093609597
 |  | concrete |  |  | 5 | yds |  |  |  |  |  |  |  | 120 | yds |  | 600
 |  | concrete (sonotubes) |  |  | 11.72861257340189 | yds |  |  |  |  |  |  |  | 140 | yds |  | 1642.005760276265
 |  | concrete |  |  | 12.44444444444444 | yds |  |  |  |  |  |  |  | 120 | yds |  | 1493.333333333333
Tanks |  |  |  |  | qty | unit |  | Gallons |  |  |  |  |  | Amount | Unit |  | Total | 3500
 |  | [NAME],dbl wall,horz |  | 4' dia. x 5.8' | 1 | ea. |  | 500 |  |  |  |  |  | 7 | gal |  | 3500
Structural Iron |  |  |  | Width(in) | ft | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 2880
 |  | I Beam |  | 6 | 288 | ft |  |  |  |  |  |  |  | 10 | ft |  | 2880
Buildings |  |  |  | length | qty | unit |  | width | eave |  | Ins |  |  | Amount | Unit |  | Total | 15140
 |  | Building w/ ac, hvac |  | 10 | 80 | sq.ft. |  | 8 | 8 |  |  |  |  | 189.25 | sq ft |  | 15140
[NAME] |  |  |  |  | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 525
 |  | Single Gang PushButton Ex Proof |  |  | 3 | ea. |  |  |  |  |  |  |  | 175 | ea. |  | 525
Control Switches |  |  |  |  | qty | unit |  |  |  |  |  |  |  | Amount | Unit |  | Total | 1330
 |  | Level Switch DPDT |  |  | 1 | ea. |  |  |  |  |  |  |  | 1330 | ea. |  | 1330
[NAME] |  |  |  | Size (O.D.) | qty | unit |  | ANSI |  |  |  |  |  | Amount | Unit |  | Total | 80
 |  | Pressure Gauges |  |  | 1 | ea. |  |  |  |  |  |  |  | 80 | ea |  | 80
Chromatographs |  |  |  | OD | qty | unit |  | ANSI |  | Style |  |  |  | Amount | Unit |  | Total | 29360
 |  | Insertion Probe |  | 12 | 1 | ea. |  | 600 |  |  |  |  |  | 2000 | ea |  | 2000
 |  | Chromatograph - Danalyzer |  |  | 1 | ea. |  |  |  |  |  |  |  | 19500 | ea |  | 19500
 |  | Regulator for Cal Gas |  |  | 1 | ea. |  |  |  |  |  |  |  | 325 | ea |  | 325
 |  | Regulator for Carrier Gas |  |  | 1 | ea. |  |  |  |  |  |  |  | 385 | ea |  | 385
 |  | Mannifold for Carrier Gas |  |  | 1 | ea. |  |  |  |  |  |  |  | 550 | ea |  | 550
 |  | Heater for Cal Gas |  |  | 1 | ea. |  |  |  |  |  |  |  | 3500 | ea |  | 3500
 |  | Cyl of Cal Gas |  |  | 1 | ea. |  |  |  |  |  |  |  | 1100 | ea |  | 1100
 |  | Heat Traced SS Tubing |  | 0.125 | 100 | ea. |  |  |  |  |  |  |  | 20 | ea |  | 2000