{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary","Zero Inch-Min System Study","Footage & Cost Per Foot","Footage","Per Ft Cost_CTX","Per Ft Cost_STX","Per Ft Cost_PA&G","Per Ft Cost WTX","Per Ft Cost_Permian","Per Ft Cost_NTX & Borger ","Per Ft Cost_RGV"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Zero-Inch Study"]
[null,"Customer Portion","Footage"]
["WNSA",{"$f":"'Zero Inch-Min System Study'!O65","v":0.67300000000000004},{"$f":"'Zero Inch-Min System Study'!B57","v":23240664.479999997}]
["Fort Bliss",{"$f":"'Zero Inch-Min System Study'!O101","v":0.5595},{"$f":"'Zero Inch-Min System Study'!B91","v":734279.04000000015}]
["CGSA",{"$f":"'Zero Inch-Min System Study'!O29","v":0.64470000000000005},{"$f":"'Zero Inch-Min System Study'!B26","v":22323528.479999997}]
["RGVSA",{"$f":"'Zero Inch-Min System Study'!O137","v":0.56059999999999999},{"$f":"'Zero Inch-Min System Study'!B126","v":12421727.999999998}]
["TGS",{"$f":"(B5*C5+B3*C3+B4*C4+B6*C6)/C7","v":0.63704476220748574},{"$f":"SUM(C3:C6)","v":58720199.999999993}]

{"sheet":"Zero Inch-Min System Study","index":1,"n_rows":145,"n_cols":16,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
["CGSA"]
["Size","Footage","Composition","Size","Plastic","Cost/Ft","LN(Cost/Ft)","Configured Cost",null,"SUMMARY OUTPUT"]
[1,{"$f":"'Footage & Cost Per Foot'!S5","v":259195.2},"S",{"$f":"A3","v":1},0,{"$f":"'Footage & Cost Per Foot'!P5","v":37.702741850759665},{"$f":"LN(F3)","v":3.6297328199462635},{"$f":"EXP($K$18+$K$19*D3+$K$20*E3)*B3","v":10080383.274645213}]
[2,{"$f":"'Footage & Cost Per Foot'!S6","v":6482572.8000000007},"S",{"$f":"A4","v":2},0,{"$f":"'Footage & Cost Per Foot'!P6","v":45.255147660640525},{"$f":"LN(F4)","v":3.8123164241318492},{"$f":"EXP($K$18+$K$19*D4+$K$20*E4)*B4","v":282916654.30388808},null,"Regression Statistics"]
[3,{"$f":"'Footage & Cost Per Foot'!S7","v":129143.51999999999},"S",3,0,{"$f":"'Footage & Cost Per Foot'!P7","v":51.356625469725365},3.9387939537520587,6324770.2035618629,null,"Multiple R",0.98646003498476198]
[4,{"$f":"'Footage & Cost Per Foot'!S8","v":2485824},"S",4,0,{"$f":"'Footage & Cost Per Foot'!P8","v":50.702632006218721},3.9259778225873343,136616617.56922597,null,"R Square",0.97310340062213774]
[6,{"$f":"'Footage & Cost Per Foot'!S9","v":1955764.7999999998},"S",6,0,{"$f":"'Footage & Cost Per Foot'!P9","v":63.582425307761717},4.1523371005204872,135354225.54061964,null,"Adjusted R Square",0.97041374068435149]
[8,{"$f":"'Footage & Cost Per Foot'!S10","v":388655.51999999996},"S",8,0,{"$f":"'Footage & Cost Per Foot'!P10","v":84.107817303693253},4.4320995151405773,33872096.202899218,null,"Standard Error",0.11854116341374768]
[10,{"$f":"'Footage & Cost Per Foot'!S11","v":149988.96000000002},"S",10,0,{"$f":"'Footage & Cost Per Foot'!P11","v":125.80716939825376},4.8347503330896142,16461089.213235972,null,"Observations",23]
[12,{"$f":"'Footage & Cost Per Foot'!S12","v":292897.44},"S",12,0,{"$f":"'Footage & Cost Per Foot'!P12","v":129.67653721249999},4.865043174514609,40479663.315914065]
[14,{"$f":"'Footage & Cost Per Foot'!S13","v":21637.439999999999},"S",14,0,{"$f":"'Footage & Cost Per Foot'!P13","v":207.7390604330858},5.3362827749873087,3765730.4783886936,null,"ANOVA"]
[16,{"$f":"'Footage & Cost Per Foot'!S14","v":47023.68},"S",16,0,{"$f":"'Footage & Cost Per Foot'!P14","v":191.07470376458338},5.252664470765759,10305807.143536463,null,null,"df","SS","MS","F","Significance F"]
[20,{"$f":"'Footage & Cost Per Foot'!S15","v":21426.239999999998},"S",20,0,{"$f":"'Footage & Cost Per Foot'!P15","v":300.86086058750004},5.7066479006907018,7446555.7440392394,null,"Regression",2,10.167869935717809,5.0839349678589043,361.79421307180843,1.9814072259666519E-16]
[1,{"$f":"'Footage & Cost Per Foot'!T5","v":58.08},"W",1,0,{"$f":"'Footage & Cost Per Foot'!Q5","v":41.877448723958338},3.7347474654255679,2258.7943781034292,null,"Residual",20,0.2810401484696966,1.4052007423484831E-2]
[2,{"$f":"'Footage & Cost Per Foot'!T6","v":3447.84},"W",2,0,{"$f":"'Footage & Cost Per Foot'!Q6","v":49.681523223958344},3.9056330978628897,150472.8735749975,null,"Total",22,10.448910084187505]
[3,{"$f":"'Footage & Cost Per Foot'!T7","v":2402.4},"W",3,0,{"$f":"'Footage & Cost Per Foot'!Q7","v":55.55877254375001},4.0174414251969974,117656.91330882898]
[4,{"$f":"'Footage & Cost Per Foot'!T8","v":88202.4},"W",4,0,{"$f":"'Footage & Cost Per Foot'!Q8","v":51.559184362499998},3.9427303587546283,4847452.4139632955,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[6,{"$f":"'Footage & Cost Per Foot'!T9","v":2481.6},"W",6,0,{"$f":"'Footage & Cost Per Foot'!Q9","v":63.493667088541677},4.1509401700360824,171746.13537456124,null,"Intercept",3.5454953588809874,4.5076311510963335E-2,78.655401030731227,2.1298431507349965E-26,3.4514678207315486,3.6395228970304263]
[1,{"$f":"'Footage & Cost Per Foot'!U5","v":204341.28},"P",1,1,{"$f":"'Footage & Cost Per Foot'!R5","v":22.482670885958616},3.1127448296209081,4998014.5084039522,null,"Size",0.11526975951166903,4.852147421641151E-3,23.756442147151645,3.9472557302536792E-16,0.10514835734938027,0.12539116167395778]
[2,{"$f":"'Footage & Cost Per Foot'!U6","v":6163771.6800000006},"P",2,1,{"$f":"'Footage & Cost Per Foot'!R6","v":24.021210021246663},3.1789371909553314,169179978.94459638,null,"Plastic",-0.46376064137339079,5.4469079085826363E-2,-8.514200150926877,4.3942294646314744E-8,-0.57738114935265816,-0.35014013339412342]
[3,{"$f":"'Footage & Cost Per Foot'!U7","v":191310.24000000002},"P",3,1,{"$f":"'Footage & Cost Per Foot'!R7","v":30.137096251737397},3.4057568465444654,5892528.0762691153]
[4,{"$f":"'Footage & Cost Per Foot'!U8","v":2084322.2400000002},"P",4,1,{"$f":"'Footage & Cost Per Foot'!R8","v":31.914652500547767},3.4630652303688674,72042591.534622416]
[6,{"$f":"'Footage & Cost Per Foot'!U9","v":1266107.04},"P",6,1,{"$f":"'Footage & Cost Per Foot'!R9","v":43.458596598588827},3.7718086825118813,55108289.224414058]
[8,{"$f":"'Footage & Cost Per Foot'!U10","v":80815.679999999993},"P",8,1,{"$f":"'Footage & Cost Per Foot'!R10","v":56.360526630780157},4.0317690310389915,4429596.6078051617,null,"Zero-Inch Study:"]
[12,{"$f":"'Footage & Cost Per Foot'!U12","v":2138.4},"P",12,1,{"$f":"'Footage & Cost Per Foot'!R12","v":116.48617004895836},4.7577725539328162,185866.69393553786,null,null,"Zero-Inch ",null,"Zero-Inch ","Configured ","Customer"]
[null,{"$f":"SUM(B3:B25)","v":22323528.479999997},null,null,null,null,null,{"$f":"SUM(H3:H25)","v":1000750045.7106009},null,null,"Cost/Ft","Footage","Total Cost","Cost","Portion"]
["CK",{"$f":"'Footage & Cost Per Foot'!V16","v":22323528.48},null,null,null,null,null,null,null,"Plastic",{"$f":"EXP(K18+K19*0+K20*1)","v":21.796179834889774},{"$f":"SUM(B19:B25)","v":9992806.5600000005},{"$f":"K27*L27","v":217805008.83702627}]
[null,{"$f":"B27-B26","v":0},null,null,null,null,null,null,null,"Steel/Wrought Iron",{"$f":"EXP(K18+K19*0+K20*0)","v":34.656848668681874},{"$f":"SUM(B3:B18)","v":12330721.92},{"$f":"K28*L28","v":427343963.55703843}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M28+M27","v":645148972.39406466},{"$f":"H26","v":1000750045.7106009},{"$f":"ROUND(M29/N29,4)","v":0.64470000000000005}]
[]
[null,null,null,null,null,null,null,null,null,"Minimum System Study:"]
[null,null,null,null,null,null,null,null,null,null,"Two-Inch ","Two-Inch","Configured","Customer "]
[null,null,null,null,null,null,null,null,null," ","Cost/Ft","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"F20","v":24.021210021246663},{"$f":"K34*L27","v":240039305.07945141}]
[null,null,null,null,null,null,null,null,null,"Steel/Wrought Iron",{"$f":"(F15*B15+F4*B4)/(B4+B15)","v":45.257500634146055},{"$f":"K35*L28","v":558057655.11387861}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L34:L35)","v":798096960.19333005},{"$f":"N29","v":1000750045.7106009},{"$f":"L36/M36","v":0.79749879963945114}]
[null,null,null,null,null,null,null,null,null,null,null,null,"w/Actual Cost",{"$f":"L36/SUMPRODUCT(F3:F25,B3:B25)","v":0.8318601699208158}]
[]
["WNSA"]
["Size","Footage","Composition","Size","Plastic","Cost/Ft","LN(Cost/Ft)","Configured Cost",null,"SUMMARY OUTPUT"]
[1,{"$f":"'Footage & Cost Per Foot'!P23","v":210883.20000000001},"S",1,0,{"$f":"'Footage & Cost Per Foot'!N23","v":41.409453466036545},{"$f":"LN(F41)","v":3.7235091993548655},{"$f":"EXP($K$56+$K$57*D41+$K$58*E41)*B41","v":9239780.6648577787}]
[2,{"$f":"'Footage & Cost Per Foot'!P24","v":6424630.0799999991},"S",2,0,{"$f":"'Footage & Cost Per Foot'!N24","v":43.371904795360663},{"$f":"LN(F42)","v":3.7698118765360671},319213534.56528735,null,"Regression Statistics"]
[3,{"$f":"'Footage & Cost Per Foot'!P25","v":224822.39999999999},"S",3,0,{"$f":"'Footage & Cost Per Foot'!N25","v":64.461024046594645},4.1660607628046122,12667363.737650389,null,"Multiple R",0.98232896063447339]
[4,{"$f":"'Footage & Cost Per Foot'!P26","v":2474076},"S",4,0,{"$f":"'Footage & Cost Per Foot'!N26","v":58.927002646800354},4.0762994346137909,158078639.46439639,null,"R Square",0.96497018690120473]
[6,{"$f":"'Footage & Cost Per Foot'!P27","v":841859.03999999992},"S",6,0,{"$f":"'Footage & Cost Per Foot'!N27","v":85.886146904292644},4.4530225459532824,69171392.008017972,null,"Adjusted R Square",0.95958098488600541]
[8,{"$f":"'Footage & Cost Per Foot'!P28","v":97273.44},"S",8,0,{"$f":"'Footage & Cost Per Foot'!N28","v":121.74695989823604},4.8019447916159201,10277994.788062682,null,"Standard Error",0.13538540188746701]
[10,{"$f":"'Footage & Cost Per Foot'!P29","v":14657.279999999999},"S",10,0,{"$f":"'Footage & Cost Per Foot'!N29","v":142.09812370312801},4.956517830956261,1991565.0009260944,null,"Observations",16]
[12,{"$f":"'Footage & Cost Per Foot'!P30","v":9921.1200000000008},"S",12,0,{"$f":"'Footage & Cost Per Foot'!N30","v":210.66325896458332},5.3502609295468897,1733519.7206060262]
[16,{"$f":"'Footage & Cost Per Foot'!P32","v":122295.36},"S",16,0,{"$f":"'Footage & Cost Per Foot'!N32","v":218.58191169791669},5.3871608261976398,{"$f":"EXP($K$56+$K$57*D49+$K$58*E49)*B49","v":35337191.432031661},null,"ANOVA"]
[1,{"$f":"'Footage & Cost Per Foot'!Q23","v":98572.319999999992},"P",1,1,{"$f":"'Footage & Cost Per Foot'!O23","v":27.854780947095062},3.3270046193993177,2583821.8935867758,null,null,"df","SS","MS","F","Significance F"]
[2,{"$f":"'Footage & Cost Per Foot'!Q24","v":9237703.1999999993},"P",2,1,{"$f":"'Footage & Cost Per Foot'!O24","v":24.881702155874986},3.2141326801560055,274590236.77252895,null,"Regression",2,6.5639173656281535,3.2819586828140768,179.05622839516454,3.4581659553608798E-10]
[3,{"$f":"'Footage & Cost Per Foot'!Q25","v":174139.68},"P",3,1,{"$f":"'Footage & Cost Per Foot'!O25","v":36.922299745345214},3.6088156976553085,5869921.8654291229,null,"Residual",13,0.23827969157500242,1.8329207044230956E-2]
[4,{"$f":"'Footage & Cost Per Foot'!Q26","v":2371084.3200000003},"P",4,1,{"$f":"'Footage & Cost Per Foot'!O26","v":35.492603264146148},3.5693243160152224,90634818.257830977,null,"Total",15,6.8021970572031556]
[6,{"$f":"'Footage & Cost Per Foot'!Q27","v":876078.72},"P",6,1,{"$f":"'Footage & Cost Per Foot'!O27","v":48.83925779025823},3.8885344523673724,43064378.493506871]
[8,{"$f":"'Footage & Cost Per Foot'!Q28","v":55973.279999999999},"P",8,1,{"$f":"'Footage & Cost Per Foot'!O28","v":66.021546481786515},4.189981150594603,3538203.3731130986,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[10,{"$f":"'Footage & Cost Per Foot'!Q29","v":6695.04},"P",10,1,{"$f":"'Footage & Cost Per Foot'!O29","v":86.587710183333343},4.4611578907554303,544229.64399869065,null,"Intercept",3.6542167899867302,7.2700404198594679E-2,50.264050527209683,2.801475094691844E-16,3.4971571154439101,3.8112764645295503]
[null,{"$f":"SUM(B41:B56)","v":23240664.479999997},null,null,null,null,null,{"$f":"SUM(H41:H56)","v":1038536591.6818311},null,"Size",0.12575221109191545,8.2739009415607953E-3,15.198660460176292,1.1735551601198059E-9,0.10787753483108953,0.14362688735274137]
["CK",{"$f":"'Footage & Cost Per Foot'!R34","v":23240664.479999993},null,null,null,null,null,null,null,"Plastic",-0.51373455715556793,7.026826066426585E-2,-7.3110470118242441,5.9080113328840492E-6,-0.66553990503880522,-0.36192920927233063]
[null,{"$f":"B58-B57","v":0}]
[null,null,null,null,null,null,null,null,null,"Zero-Inch Study:"]
[null,null,null,null,null,null,null,null,null,null,"Zero-Inch ",null,"Zero-Inch ","Configured ","Customer"]
[null,null,null,null,null,null,null,null,null,null,"Cost/Ft","Footage","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"EXP(K56+K57*0+K58*1)","v":23.115010988664967},{"$f":"SUM(B50:B56)","v":12820246.559999999},{"$f":"K63*L63","v":296340140.11179423}]
[null,null,null,null,null,null,null,null,null,"Steel",{"$f":"EXP(K56+K57*0+K58*0)","v":38.637248182015355},{"$f":"SUM(B41:B49)","v":10420417.919999996},{"$f":"K64*L64","v":402616273.33536011}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M64+M63","v":698956413.44715428},{"$f":"H57","v":1038536591.6818311},{"$f":"ROUND(M65/N65,4)","v":0.67300000000000004}]
[]
[null,null,null,null,null,null,null,null,null,"Minimum System Study:"]
[null,null,null,null,null,null,null,null,null,null,"Two-Inch ","Two-Inch","Configured","Customer "]
[null,null,null,null,null,null,null,null,null," ","Cost/Ft","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"F51","v":24.881702155874986},{"$f":"K70*L63","v":318989556.47080082}]
[null,null,null,null,null,null,null,null,null,"Steel",{"$f":"F42","v":43.371904795360663},{"$f":"K71*L64","v":451953373.95411003}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L70:L71)","v":770942930.42491078},{"$f":"N65","v":1038536591.6818311},{"$f":"L72/M72","v":0.74233583736941544}]
[null,null,null,null,null,null,null,null,null,null,null,null,"w/Actual Cost",{"$f":"L72/SUMPRODUCT(F41:F56,B41:B56)","v":0.82634298817142282}]
[]
["Fort Bliss"]
["Size","Footage","Composition","Size","Plastic","Cost/Ft","LN(Cost/Ft)","Configured Cost",null,"SUMMARY OUTPUT"]
[1,{"$f":"'Footage & Cost Per Foot'!B42","v":8606.4},"S",1,0,{"$f":"'Footage & Cost Per Foot'!D42","v":35.094026733333337},{"$f":"LN(F77)","v":3.558030937452298},{"$f":"EXP($K$92+$K$93*D77+$K$94*E77)*B77","v":324467.80580762809}]
[2,{"$f":"'Footage & Cost Per Foot'!B43","v":86222.399999999994},"S",2,0,{"$f":"'Footage & Cost Per Foot'!D43","v":40.865790165625008},{"$f":"LN(F78)","v":3.7102932867807881},3676620.947243494,null,"Regression Statistics"]
[3,{"$f":"'Footage & Cost Per Foot'!B44","v":14625.6},"S",3,0,{"$f":"'Footage & Cost Per Foot'!D44","v":53.636248383333339},3.9822251153137751,705376.69444877119,null,"Multiple R",0.98962146025370457]
[4,{"$f":"'Footage & Cost Per Foot'!B45","v":73180.800000000003},"S",4,0,{"$f":"'Footage & Cost Per Foot'!D45","v":53.083459772916669},3.9718653876887049,3991932.900617715,null,"R Square",0.97935063459467453]
[6,{"$f":"'Footage & Cost Per Foot'!B46","v":24921.599999999999},"S",6,0,{"$f":"'Footage & Cost Per Foot'!D46","v":77.653561494791674},4.3522574145414881,1739079.0808666826,null,"Adjusted R Square",0.97559620452097906]
[8,{"$f":"'Footage & Cost Per Foot'!B47","v":26452.799999999999},"S",8,0,{"$f":"'Footage & Cost Per Foot'!D47","v":102.14259591458335},4.6263698361558205,2361415.3841497949,null,"Standard Error",0.10275562939682381]
[12,{"$f":"'Footage & Cost Per Foot'!B49","v":12091.2},"S",12,0,{"$f":"'Footage & Cost Per Foot'!D49","v":210.66325896458332},5.3502609295468897,1766382.7084650164,null,"Observations",14]
[16,{"$f":"'Footage & Cost Per Foot'!B51","v":10866.24},"S",16,0,{"$f":"'Footage & Cost Per Foot'!D51","v":218.58191169791669},5.3871608261976398,2597821.7745922478]
[1,{"$f":"'Footage & Cost Per Foot'!C42","v":6071.9999999999991},"P",1,1,{"$f":"'Footage & Cost Per Foot'!E42","v":23.252665505208338},3.1464197708473902,142882.54150880946,null,"ANOVA"]
[2,{"$f":"'Footage & Cost Per Foot'!C43","v":143457.60000000001},"P",2,1,{"$f":"'Footage & Cost Per Foot'!E43","v":23.854229581250006},3.1719615425442202,3818120.491284545,null,null,"df","SS","MS","F","Significance F"]
[3,{"$f":"'Footage & Cost Per Foot'!C44","v":14303.52},"P",3,1,{"$f":"'Footage & Cost Per Foot'!E44","v":28.552168959375006},3.351732903772445,430573.86081097333,null,"Regression",2,5.5085263623082872,2.7542631811541436,260.85201092337456,5.3949435178655969E-10]
[4,{"$f":"'Footage & Cost Per Foot'!C45","v":227784.48000000004},"P",4,1,{"$f":"'Footage & Cost Per Foot'!E45","v":32.454206209375002},3.4798300559942135,7755459.4049501875,null,"Residual",11,0.11614591310011142,1.0558719372737403E-2]
[6,{"$f":"'Footage & Cost Per Foot'!C46","v":84342.720000000001},"P",6,1,{"$f":"'Footage & Cost Per Foot'!E46","v":46.546838603125011},3.8404590874130564,3673570.0971479048,null,"Total",13,5.6246722754083986]
[8,{"$f":"'Footage & Cost Per Foot'!C47","v":1351.68},"P",8,1,{"$f":"'Footage & Cost Per Foot'!E47","v":65.112139668750004},4.1761110090763465,75313.34663805092]
["Total",{"$f":"SUM(B77:B90)","v":734279.04000000015},null,null,null,null,null,{"$f":"SUM(H77:H90)","v":33059017.038531817},null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
["CK",{"$f":"'Footage & Cost Per Foot'!B54+'Footage & Cost Per Foot'!C54","v":734279.04},null,null,null,null,null,null,null,"Intercept",3.5065410302156872,5.7391286832823102E-2,61.098839627520491,2.7938077007884842E-15,3.380223659578081,3.6328584008532934]
[null,{"$f":"B92-B91","v":0},null,null,null,null,null,null,null,"Size",0.12313917678299499,6.8352027932243363E-3,18.015438679458281,1.6347465278695331E-9,0.10809499686889132,0.13818335669709866]
[null,null,null,null,null,null,null,null,null,"Plastic",-0.4713453424063897,5.8065708179339481E-2,-8.1174475811198388,5.6854020465527922E-6,-0.5991471044193275,-0.34354358039345184]
[]
[null,null,null,null,null,null,null,null,null,"Zero-Inch Study:"]
[null,null,null,null,null,null,null,null,null,null,"Zero-Inch ",null,"Zero-Inch ","Configured ","Customer"]
[null,null,null,null,null,null,null,null,null,null,"Cost/Ft","Footage","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"EXP(K92+K93*0+K94*1)","v":20.805048795571462},{"$f":"SUM(B85:B90)","v":477312.00000000006},{"$f":"K99*L99","v":9930499.4507118072}]
[null,null,null,null,null,null,null,null,null,"Steel",{"$f":"EXP(K92+K93*0+K94*0)","v":33.332771101265145},{"$f":"SUM(B77:B84)","v":256967.04000000001},{"$f":"K100*L100","v":8565423.5248896442}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M100+M99","v":18495922.97560145},{"$f":"H91","v":33059017.038531817},{"$f":"ROUND(M101/N101,4)","v":0.5595}]
[]
[null,null,null,null,null,null,null,null,null,"Minimum System Study:"]
[null,null,null,null,null,null,null,null,null,null,"Two-Inch ","Two-Inch ","Configured","Customer"]
[null,null,null,null,null,null,null,null,null," ","Cost/Ft","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"F86","v":23.854229581250006},{"$f":"K106*L99","v":11385910.029885605}]
[null,null,null,null,null,null,null,null,null,"Steel",{"$f":"F78","v":40.865790165625008},{"$f":"K107*L100","v":10501161.136121769}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L106:L107)","v":21887071.166007373},{"$f":"N101","v":33059017.038531817},{"$f":"L108/M108","v":0.66206055493110938}]
[null,null,null,null,null,null,null,null,null,null,null,null,"w/Actual Cost",{"$f":"L108/SUMPRODUCT(F77:F90,B77:B90)","v":0.65466655747599045}]
[]
["RGVSA"]
["Size","Footage","Composition","Size","Plastic","Cost/Ft","LN(Cost/Ft)","Configured Cost",null,"SUMMARY OUTPUT"]
[1,{"$f":"'Footage & Cost Per Foot'!C60","v":137037.12},"P",1,1,{"$f":"'Footage & Cost Per Foot'!E60","v":15.475697602916668},{"$f":"LN(F113)","v":2.7392708969030282},{"$f":"EXP($K$128+$K$129*D113+$K$130*E113)*B113","v":2018043.1211354581}]
[2,{"$f":"'Footage & Cost Per Foot'!C61","v":3900895.68},"P",2,1,{"$f":"'Footage & Cost Per Foot'!E61","v":15.651289279166667},{"$f":"LN(F114)","v":2.750553295648325},{"$f":"EXP($K$128+$K$129*D114+$K$130*E114)*B114","v":67441301.056188911},null,"Regression Statistics"]
[3,{"$f":"'Footage & Cost Per Foot'!C62","v":279.83999999999997},"P",3,1,{"$f":"'Footage & Cost Per Foot'!E62","v":21.236211008333335},3.0557077910222827,5679.9011868244288,null,"Multiple R",0.99606984151985944]
[4,{"$f":"'Footage & Cost Per Foot'!C63","v":432326.39999999997},"P",4,1,{"$f":"'Footage & Cost Per Foot'!E63","v":23.561174869791667},3.1596002246789268,10301776.638007423,null,"R Square",0.99215512918539794]
[6,{"$f":"'Footage & Cost Per Foot'!C64","v":83793.599999999991},"P",6,1,{"$f":"'Footage & Cost Per Foot'!E64","v":33.369522925000005},3.5076429961372626,2752009.8958365172,null,"Adjusted R Square",0.9905861550224776]
[1,{"$f":"'Footage & Cost Per Foot'!B60","v":108704.64},"S",1,0,{"$f":"'Footage & Cost Per Foot'!D60","v":30.157018807838469},3.4064176923602281,3406231.7921010018,null,"Standard Error",7.6331584657978971E-2]
[2,{"$f":"'Footage & Cost Per Foot'!B61","v":4532241.12},"S",2,0,{"$f":"'Footage & Cost Per Foot'!D61","v":38.325442083293481},3.6461139598066388,166727987.2247614,null,"Observations",13]
[3,{"$f":"'Footage & Cost Per Foot'!B62","v":305812.32},"S",3,0,{"$f":"'Footage & Cost Per Foot'!D62","v":47.349732153505059},3.8575611628791302,13207476.986840708]
[4,{"$f":"'Footage & Cost Per Foot'!B63","v":1929475.6800000002},"S",4,0,{"$f":"'Footage & Cost Per Foot'!D63","v":48.468465536458332},3.8809133913503482,97830343.545210317,null,"ANOVA"]
[6,{"$f":"'Footage & Cost Per Foot'!B64","v":413682.72000000003},"S",6,0,{"$f":"'Footage & Cost Per Foot'!D64","v":68.757723111006811},4.2305890663975454,28909489.262887493,null,null,"df","SS","MS","F","Significance F"]
[8,{"$f":"'Footage & Cost Per Foot'!B65","v":197229.12},"S",8,0,{"$f":"'Footage & Cost Per Foot'!D65","v":94.832500819020808},4.5521121861499445,18996904.741164301,null,"Regression",2,7.3688945660948519,3.684447283047426,632.35912523801846,2.9711801242780908E-11]
[10,{"$f":"'Footage & Cost Per Foot'!B66","v":94063.200000000012},"S",10,0,{"$f":"'Footage & Cost Per Foot'!D66","v":116.61082964984486},4.7588421482470471,12487351.205201324,null,"Residual",10,5.8265108163982116E-2,5.8265108163982112E-3]
[12,{"$f":"'Footage & Cost Per Foot'!B67","v":286186.56},"S",12,0,{"$f":"'Footage & Cost Per Foot'!D67","v":204.63296130807115},5.321217941754588,52364695.286722258,null,"Total",12,7.4271596742588342]
["Total",{"$f":"SUM(B113:B125)","v":12421727.999999998},null,null,null,null,null,{"$f":"SUM(H113:H125)","v":476449290.65724391}]
["CK",{"$f":"'Footage & Cost Per Foot'!B71+'Footage & Cost Per Foot'!C71","v":12421728},null,null,null,null,null,null,null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[null,{"$f":"B127-B126","v":0},null,null,null,null,null,null,null,"Intercept",3.2843077470992283,4.7729496040208062E-2,68.810861617572428,1.0240734602891938E-14,3.1779598025863156,3.3906556916121411]
[null,null,null,null,null,null,null,null,null,"Size",0.16041968635112275,6.8465016032073587E-3,23.430898822249812,4.5423103964977434E-10,0.14516473012883011,0.17567464257341539]
[null,null,null,null,null,null,null,null,null,"Plastic",-0.7550957025448557,4.6887290379244696E-2,-16.104485809210018,1.7632288239551017E-8,-0.85956709590321312,-0.65062430918649827]
[]
[null,null,null,null,null,null,null,null,null,"Zero-Inch Study:"]
[null,null,null,null,null,null,null,null,null,null,"Zero-Inch ",null,"Zero-Inch ","Configured ","Customer"]
[null,null,null,null,null,null,null,null,null,null,"Cost/Ft","Footage","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"EXP(K128+K129*0+K130*1)","v":12.54361842919419},{"$f":"SUM(B113:B117)","v":4554332.6399999997},{"$f":"K135*L135","v":57127810.835784622}]
[null,null,null,null,null,null,null,null,null,"Steel",{"$f":"EXP(K128+K129*0+K130*0)","v":26.690501341202317},{"$f":"SUM(B118:B125)","v":7867395.3599999994},{"$f":"K136*L136","v":209984726.40784886}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M136+M135","v":267112537.24363348},{"$f":"H126","v":476449290.65724391},{"$f":"ROUND(M137/N137,4)","v":0.56059999999999999}]
[]
[null,null,null,null,null,null,null,null,null,"Minimum System Study:"]
[null,null,null,null,null,null,null,null,null,null,"Two-Inch ","Two-Inch","Configured","Customer"]
[null,null,null,null,null,null,null,null,null," ","Cost/Ft","Total Cost","Cost","Portion"]
[null,null,null,null,null,null,null,null,null,"Plastic",{"$f":"F114","v":15.651289279166667},{"$f":"K142*L135","v":71281177.622190818}]
[null,null,null,null,null,null,null,null,null,"Steel",{"$f":"F119","v":38.325442083293481},{"$f":"K143*L136","v":301521405.21605182}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L142:L143)","v":372802582.83824265},{"$f":"N137","v":476449290.65724391},{"$f":"L144/M144","v":0.78246014874736303}]
[null,null,null,null,null,null,null,null,null,null,null,null,"w/Actual Cost",{"$f":"L144/SUMPRODUCT(F113:F125,B113:B125)","v":0.78021582378688326}]

{"sheet":"Footage & Cost Per Foot","index":2,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[2,15,2,17],[2,8,2,10],[57,23,57,25],[57,1,57,2],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,11,20,12],[20,1,20,2],[20,13,20,14],[38,1,38,4],[20,15,20,17],[20,9,20,10],[2,18,2,21],[1,18,1,21],[1,1,1,7],[57,3,57,4],[56,1,56,4],[2,1,2,3],[2,13,2,14],[39,1,39,2],[39,3,39,4],[1,8,1,17],[2,4,2,5],[2,6,2,7],[19,15,19,17],[19,7,19,14],[19,1,19,6],[2,11,2,12]]}
["CGSA"]
[null,"Mains Footage",null,null,null,null,null,null,"Cost per Foot",null,null,null,null,null,null,null,null,null,"Mains Footage"]
[null,"Austin",null,null,"STX",null,"Galveston & Port Arthur",null,"Austin",null,null,"STX",null,"Galv&Port Arthur",null,"CGSA",null,null,"CGSA"]
["Size","Steel","Wrought Iron","Plastic","Steel","Plastic","Steel","Plastic","Steel","Wrought Iron","Plastic","Steel","Plastic","Steel","Plastic","Steel","Wrought Iron","Plastic","Steel","Wrought Iron","Plastic","Total"]
[1,{"$f":"+Footage!L5*5280","v":142982.39999999999},{"$f":"+Footage!L8*5280","v":58.08},{"$f":"Footage!L10*5280","v":123874.07999999999},{"$f":"+Footage!L20*5280","v":19694.400000000001},{"$f":"+Footage!L25*5280","v":32788.800000000003},{"$f":"(+Footage!L35+Footage!L50)*5280","v":96518.400000000009},{"$f":"+(Footage!L40+Footage!L55)*5280","v":47678.399999999994},{"$f":"'Per Ft Cost_CTX'!K6","v":41.877448723958338},{"$f":"'Per Ft Cost_CTX'!K26","v":41.877448723958338},{"$f":"'Per Ft Cost_CTX'!K18","v":25.405343421874999},{"$f":"'Per Ft Cost_STX'!K12","v":26.452629233333337},{"$f":"'Per Ft Cost_STX'!K6","v":18.831237171874999},{"$f":"'Per Ft Cost_PA&G'!K14","v":33.81389381666667},{"$f":"'Per Ft Cost_PA&G'!K6","v":17.400343421875},{"$f":"+(B5*I5+E5*L5+G5*N5)/(B5+E5+G5)","v":37.702741850759665},{"$f":"J5","v":41.877448723958338},{"$f":"+(D5*K5+F5*M5+H5*O5)/(D5+F5+H5)","v":22.482670885958616},{"$f":"+B5+E5+G5","v":259195.2},{"$f":"C5","v":58.08},{"$f":"+D5+F5+H5","v":204341.28},{"$f":"SUM(S5:U5)","v":463594.56}]
[2,{"$f":"+Footage!M5*5280","v":4152720},{"$f":"+Footage!M8*5280","v":3447.84},{"$f":"+Footage!M10*5280","v":4548667.2},{"$f":"+Footage!M20*5280","v":682070.4},{"$f":"+Footage!M25*5280","v":481884.48000000004},{"$f":"(Footage!M35+Footage!M50)*5280","v":1647782.4},{"$f":"+(Footage!M40+Footage!M55)*5280","v":1133220},{"$f":"'Per Ft Cost_CTX'!K7","v":49.681523223958344},{"$f":"'Per Ft Cost_CTX'!K27","v":49.681523223958344},{"$f":"'Per Ft Cost_CTX'!K19","v":26.006907497916668},{"$f":"'Per Ft Cost_STX'!K13","v":32.159358711458339},{"$f":"'Per Ft Cost_STX'!K7","v":19.432801247916668},{"$f":"'Per Ft Cost_PA&G'!K15","v":39.520623294791669},{"$f":"'Per Ft Cost_PA&G'!K7","v":18.001907497916665},{"$f":"+(B6*I6+E6*L6+G6*N6)/(B6+E6+G6)","v":45.255147660640525},49.681523223958344,{"$f":"+(D6*K6+F6*M6+H6*O6)/(D6+F6+H6)","v":24.021210021246663},{"$f":"+B6+E6+G6","v":6482572.8000000007},3447.84,{"$f":"+D6+F6+H6","v":6163771.6800000006},{"$f":"SUM(S6:U6)","v":12649792.32}]
[3,{"$f":"+Footage!N5*5280","v":3326.4},{"$f":"+Footage!N8*5280","v":2402.4},{"$f":"+Footage!N10*5280","v":184377.60000000001},{"$f":"+Footage!N20*5280","v":28781.279999999999},{"$f":"+Footage!N25*5280","v":6800.64},{"$f":"(+Footage!N35+Footage!N50)*5280","v":97035.839999999997},{"$f":"(Footage!N40+Footage!N55)*5280","v":132},{"$f":"'Per Ft Cost_CTX'!K8","v":55.55877254375001},{"$f":"'Per Ft Cost_CTX'!K28","v":55.55877254375001},{"$f":"'Per Ft Cost_CTX'!K20","v":30.440014792708336},{"$f":"'Per Ft Cost_STX'!K14","v":42.796144216666676},{"$f":"'Per Ft Cost_STX'!K8","v":22.06745187604167},{"$f":"'Per Ft Cost_PA&G'!K16","v":53.751653800000007},{"$f":"'Per Ft Cost_PA&G'!K8","v":22.768556459375002},51.356625469725365,55.55877254375001,30.137096251737397,129143.51999999999,2402.4,191310.24000000002,322856.16000000003]
[4,{"$f":"+Footage!O5*5280","v":1629777.6},{"$f":"+Footage!O8*5280","v":88202.4},{"$f":"+Footage!O10*5280","v":1599026.8800000001},{"$f":"+Footage!O20*5280","v":312312},{"$f":"+Footage!O25*5280","v":117965.75999999999},{"$f":"(+Footage!O35+Footage!O50)*5280","v":543734.4},{"$f":"+(Footage!O40+Footage!O55)*5280","v":367329.6},{"$f":"'Per Ft Cost_CTX'!K9","v":51.559184362499998},{"$f":"'Per Ft Cost_CTX'!K29","v":51.559184362499998},{"$f":"'Per Ft Cost_CTX'!K21","v":33.74048796666667},{"$f":"'Per Ft Cost_STX'!K15","v":42.113287697916668},{"$f":"'Per Ft Cost_STX'!K9","v":25.36792505},{"$f":"'Per Ft Cost_PA&G'!K17","v":53.068797281250006},{"$f":"'Per Ft Cost_PA&G'!K9","v":26.069029633333336},50.702632006218721,51.559184362499998,31.914652500547767,2485824,88202.4,2084322.2400000002,4658348.6400000006]
[6,{"$f":"+Footage!P5*5280","v":1322640},{"$f":"+Footage!P8*5280","v":2481.6},{"$f":"+Footage!P10*5280","v":1201173.6000000001},{"$f":"+Footage!P20*5280","v":460178.4},{"$f":"+Footage!P25*5280","v":10744.800000000001},{"$f":"+(Footage!P35+Footage!P50)*5280","v":172946.39999999997},{"$f":"+(Footage!P40+Footage!P55)*5280","v":54188.639999999999},{"$f":"'Per Ft Cost_CTX'!K10","v":63.493667088541677},{"$f":"'Per Ft Cost_CTX'!K30","v":63.493667088541677},{"$f":"'Per Ft Cost_CTX'!K22","v":43.891560090625006},{"$f":"'Per Ft Cost_STX'!K16","v":58.944232134375007},{"$f":"'Per Ft Cost_STX'!K10","v":35.599714257291673},{"$f":"'Per Ft Cost_PA&G'!K18","v":76.602595051041675},{"$f":"'Per Ft Cost_PA&G'!K10","v":35.419601757291666},63.582425307761717,63.493667088541677,43.458596598588827,1955764.7999999998,2481.6,1266107.04,3224353.44]
[8,{"$f":"+Footage!Q5*5280","v":320802.24},{"$f":"+Footage!Q8*5280","v":0},{"$f":"+Footage!Q10*5280","v":62451.839999999997},{"$f":"+Footage!Q20*5280","v":5264.16},0,{"$f":"+(Footage!Q35+Footage!Q50)*5280","v":62589.119999999995},{"$f":"+(Footage!Q40+Footage!Q55)*5280","v":18363.84},{"$f":"'Per Ft Cost_CTX'!K11","v":78.855123668750011},0,{"$f":"'Per Ft Cost_CTX'!K23","v":58.209828418750014},{"$f":"'Per Ft Cost_STX'!K17","v":77.467183414583346},0,{"$f":"'Per Ft Cost_PA&G'!K19","v":111.58916299791669},{"$f":"'Per Ft Cost_PA&G'!K11","v":50.071411752083336},84.107817303693253,0,56.360526630780157,388655.51999999996,0,80815.679999999993,469471.19999999995]
[10,{"$f":"+Footage!R5*5280","v":83915.040000000008},0,0,0,0,{"$f":"(Footage!R35+Footage!R50)*5280","v":66073.919999999998},0,{"$f":"'Per Ft Cost_CTX'!K12","v":113.13442318229168},0,0,0,0,{"$f":"'Per Ft Cost_PA&G'!K20","v":141.90177988333335},0,125.80716939825376,0,0,149988.96000000002,0,0,149988.96000000002]
[12,{"$f":"+Footage!S5*5280","v":292897.44},0,{"$f":"+Footage!S10*5280","v":2138.4},0,0,0,0,{"$f":"'Per Ft Cost_CTX'!K13","v":129.67653721249999},0,{"$f":"'Per Ft Cost_CTX'!K24","v":116.48617004895836},0,0,{"$f":"'Per Ft Cost_PA&G'!K21","v":172.69074596770835},0,129.67653721249999,0,116.48617004895836,292897.44,0,2138.4,295035.84000000003]
[14,{"$f":"+Footage!T5*5280","v":913.43999999999994},0,0,0,0,{"$f":"Footage!S35*5280","v":20724},0,{"$f":"'Per Ft Cost_CTX'!K14","v":205.88618682604167},0,0,0,0,{"$f":"'Per Ft Cost_PA&G'!K22","v":207.82072849270835},0,207.7390604330858,0,0,21637.439999999999,0,0,21637.439999999999]
[16,{"$f":"+Footage!U5*5280","v":47023.68},0,0,0,0,0,0,{"$f":"'Per Ft Cost_CTX'!K15","v":191.07470376458335},0,0,0,0,0,0,191.07470376458338,0,0,47023.68,0,0,47023.68]
[20,{"$f":"+Footage!V5*5280","v":21426.239999999998},0,0,0,0,0,0,{"$f":"'Per Ft Cost_CTX'!K16","v":300.86086058750004},0,0,0,0,0,0,300.86086058750004,0,0,21426.239999999998,0,0,21426.239999999998]
[null,{"$f":"SUM(B5:B15)","v":8018424.4800000014},96592.320000000007,7721709.5999999996,1508300.64,650184.4800000001,2707404.48,1620912.48,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S5:S15)","v":12234129.6},{"$f":"SUM(T5:T15)","v":96592.320000000007},{"$f":"SUM(U5:U15)","v":9992806.5600000005},{"$f":"SUM(V5:V15)","v":22323528.48}]
["ck",{"$f":"Footage!W5*5280","v":8018424.4800000004},{"$f":"Footage!W8*5280","v":96592.319999999978},{"$f":"Footage!W10*5280","v":7721709.5999999996},{"$f":"Footage!R20*5280","v":1508300.6400000001},{"$f":"Footage!R25*5280","v":650184.48},{"$f":"(Footage!T35+Footage!S50)*5280","v":2707404.4800000004},{"$f":"(Footage!T40+Footage!S55)*5280","v":1620912.48},null,null,null,null,null,null,null,null,null,null,{"$f":"B16+E16+G16+I16","v":12234129.600000001},{"$f":"C16","v":96592.320000000007},{"$f":"D16+F16+H16+J16","v":9992806.5600000005},{"$f":"SUM(B16:J16)","v":22323528.480000004}]
[null,{"$f":"B17-B16","v":0},{"$f":"C17-C16","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"S17-S16","v":0},{"$f":"T17-T16","v":0},0,0]
["WNSA"]
[null,"Mains Footage",null,null,null,null,null,"Cost per Foot",null,null,null,null,null,null,null,"Mains Footage"]
[null,"WTX & Dell City",null,"Permian",null,"Borger & NTX",null,"El Paso & Dell City",null,"Permian",null,"Borger & NTX",null,"West North ",null,"West North "]
["Size","Steel","Plastic","Steel","Plastic","Steel","Plastic","Steel","Plastic","Steel","Plastic","Steel","Plastic","Steel","Plastic","Steel","Plastic","Total"]
[1,{"$f":"Footage!L65*5280","v":76824},{"$f":"(Footage!L69+Footage!L70+Footage!L71)*5280","v":27561.599999999999},{"$f":"Footage!L97*5280","v":61353.599999999999},{"$f":"Footage!L102*5280","v":17846.399999999998},{"$f":"(Footage!L113+Footage!L129)*5280","v":72705.599999999991},{"$f":"(Footage!L118+Footage!L133+Footage!L134)*5280","v":53164.319999999992},{"$f":"'Per Ft Cost WTX'!K14","v":35.094026733333337},{"$f":"'Per Ft Cost WTX'!K6","v":23.252665505208338},{"$f":"'Per Ft Cost_Permian'!K12","v":31.108870899999996},{"$f":"'Per Ft Cost_Permian'!K6","v":25.208553838541665},{"$f":"'Per Ft Cost_NTX & Borger '!K13","v":56.774902150000003},{"$f":"'Per Ft Cost_NTX & Borger '!K6","v":31.128918421874999},{"$f":"(B23*H23+D23*J23+F23*L23)/(B23+D23+F23)","v":41.409453466036545},{"$f":"(C23*I23+E23*K23+G23*M23)/(C23+E23+G23)","v":27.854780947095062},{"$f":"B23+D23+F23","v":210883.20000000001},{"$f":"C23+E23+G23","v":98572.319999999992},{"$f":"SUM(P23:Q23)","v":309455.52}]
[2,{"$f":"Footage!M65*5280","v":4713350.3999999994},{"$f":"(Footage!M69+Footage!M70+Footage!M71)*5280","v":7775005.919999999},{"$f":"Footage!M97*5280","v":813912},{"$f":"(Footage!M102+Footage!M103)*5280","v":342730.07999999996},{"$f":"(Footage!M113+Footage!M129)*5280","v":897367.67999999993},{"$f":"(Footage!M118+Footage!M133+Footage!M134+Footage!M135)*5280","v":1119967.2},{"$f":"'Per Ft Cost WTX'!K15","v":40.865790165625008},{"$f":"'Per Ft Cost WTX'!K7","v":23.854229581250006},{"$f":"'Per Ft Cost_Permian'!K13","v":36.815600378124998},{"$f":"'Per Ft Cost_Permian'!K7","v":25.810117914583333},{"$f":"'Per Ft Cost_NTX & Borger '!K14","v":62.481631628125008},{"$f":"'Per Ft Cost_NTX & Borger '!K7","v":31.730482497916668},{"$f":"(B24*H24+D24*J24+F24*L24)/(B24+D24+F24)","v":43.371904795360663},{"$f":"(C24*I24+E24*K24+G24*M24)/(C24+E24+G24)","v":24.881702155874986},{"$f":"B24+D24+F24","v":6424630.0799999991},{"$f":"C24+E24+G24","v":9237703.1999999993},{"$f":"SUM(P24:Q24)","v":15662333.279999997}]
[3,{"$f":"Footage!N65*5280","v":43929.599999999999},{"$f":"(Footage!N69+Footage!N70+Footage!N71)*5280","v":633.6},{"$f":"Footage!N97*5280","v":90816},{"$f":"Footage!N102*5280","v":26289.119999999999},{"$f":"(Footage!N113+Footage!N129)*5280","v":90076.799999999988},{"$f":"(Footage!N118+Footage!N133+Footage!N134)*5280","v":147216.95999999999},{"$f":"'Per Ft Cost WTX'!K16","v":53.636248383333339},{"$f":"'Per Ft Cost WTX'!K8","v":28.552168959375006},{"$f":"'Per Ft Cost_Permian'!K14","v":52.821072550000004},{"$f":"'Per Ft Cost_Permian'!K8","v":34.499216876041665},{"$f":"'Per Ft Cost_NTX & Borger '!K15","v":81.47563713333335},{"$f":"'Per Ft Cost_NTX & Borger '!K8","v":37.391023126041674},64.461024046594645,36.922299745345214,224822.39999999999,174139.68,398962.07999999996]
[4,{"$f":"Footage!O65*5280","v":1731681.6},{"$f":"(Footage!O69+Footage!O70+Footage!O71)*5280","v":1466768.1600000001},{"$f":"Footage!O97*5280","v":213364.8},{"$f":"Footage!O102*5280","v":84659.51999999999},{"$f":"(Footage!O113+Footage!O129)*5280","v":529029.6},{"$f":"(Footage!O118+Footage!O133+Footage!O134)*5280","v":819656.64},{"$f":"'Per Ft Cost WTX'!K17","v":53.083459772916669},{"$f":"'Per Ft Cost WTX'!K9","v":32.454206209375002},{"$f":"'Per Ft Cost_Permian'!K15","v":52.13821603125001},{"$f":"'Per Ft Cost_Permian'!K9","v":37.799690050000002},{"$f":"'Per Ft Cost_NTX & Borger '!K16","v":80.792780614583336},{"$f":"'Per Ft Cost_NTX & Borger '!K9","v":40.691496300000004},58.927002646800354,35.492603264146148,2474076,2371084.3200000003,4845160.32]
[6,{"$f":"Footage!P65*5280","v":443905.43999999994},{"$f":"(Footage!P69+Footage!P70+Footage!P71)*5280","v":689684.16},{"$f":"Footage!P97*5280","v":211147.2},{"$f":"Footage!P102*5280","v":58344.000000000007},{"$f":"(Footage!P113+Footage!P129)*5280","v":186806.40000000002},{"$f":"(Footage!P118+Footage!P134)*5280","v":128050.56},{"$f":"'Per Ft Cost WTX'!K18","v":77.653561494791674},{"$f":"'Per Ft Cost WTX'!K10","v":46.546838603125011},{"$f":"'Per Ft Cost_Permian'!K16","v":67.426863801041677},{"$f":"'Per Ft Cost_Permian'!K10","v":46.85674550729167},{"$f":"'Per Ft Cost_NTX & Borger '!K17","v":126.31364505104166},{"$f":"'Per Ft Cost_NTX & Borger '!K10","v":62.089593423958327},85.886146904292644,48.83925779025823,841859.03999999992,876078.72,1717937.7599999998]
[8,{"$f":"Footage!Q65*5280","v":71876.639999999999},{"$f":"(Footage!Q69+Footage!Q70+Footage!Q71)*5280","v":54389.279999999999},0,0,{"$f":"(Footage!Q113+Footage!Q129)*5280","v":25396.800000000003},{"$f":"Footage!Q134*5280","v":1584},{"$f":"'Per Ft Cost WTX'!K19","v":102.14259591458335},{"$f":"'Per Ft Cost WTX'!K11","v":65.112139668750004},{"$f":"'Per Ft Cost_Permian'!K17","v":0},0,{"$f":"'Per Ft Cost_NTX & Borger '!K18","v":177.23016299791666},{"$f":"'Per Ft Cost_NTX & Borger '!K11","v":97.247545085416661},121.74695989823604,66.021546481786515,97273.44,55973.279999999999,153246.72]
[10,{"$f":"Footage!R65*5280","v":12951.839999999998},{"$f":"(Footage!R69+Footage!R70+Footage!R71)*5280","v":6695.04},0,0,{"$f":"Footage!R129*5280","v":1705.44},0,{"$f":"'Per Ft Cost WTX'!K20","v":129.97766530000001},{"$f":"'Per Ft Cost WTX'!K12","v":86.587710183333343},0,0,{"$f":"'Per Ft Cost_NTX & Borger '!K19","v":234.14606321666665},0,142.09812370312801,86.587710183333343,14657.279999999999,6695.04,21352.32]
[12,{"$f":"Footage!S65*5280","v":9921.1200000000008},0,0,0,0,0,{"$f":"'Per Ft Cost WTX'!K21","v":210.66325896458332},0,0,0,0,0,210.66325896458332,0,9921.1200000000008,0,9921.1200000000008]
[14,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0]
[16,{"$f":"Footage!U65*5280","v":122295.36},0,0,0,0,0,{"$f":"'Per Ft Cost WTX'!K22","v":218.58191169791669},0,0,0,0,0,218.58191169791669,0,122295.36,0,122295.36]
[20,0,0,0,0,0,0,0,0,{"$f":"'Per Ft Cost_Permian'!K18","v":0},0,0,0,null,0,0,0,0]
[null,{"$f":"SUM(B23:B33)","v":7226735.9999999991},{"$f":"SUM(C23:C33)","v":10020737.759999996},1390593.5999999999,529869.12,{"$f":"SUM(F23:F33)","v":1803088.3199999996},{"$f":"SUM(G23:G33)","v":2269639.6800000002},null,null,null,null,null,null,null,null,{"$f":"SUM(P23:P33)","v":10420417.919999996},{"$f":"SUM(Q23:Q33)","v":12820246.559999999},23240664.479999993]
["ck",{"$f":"Footage!W65*5280","v":7226736},{"$f":"(Footage!W69+Footage!W70+Footage!W71)*5280","v":10020737.759999998},{"$f":"(Footage!W97*5280)","v":1390593.6},{"$f":"(Footage!W102+Footage!W103)*5280","v":529869.11999999988},{"$f":"(Footage!W113+Footage!W129)*5280","v":1803088.3199999998},{"$f":"(Footage!W118+Footage!W133+Footage!W134+Footage!W135)*5280","v":2269639.6800000002},null,null,null,null,null,null,null,null,{"$f":"B34+D34+F34+H34","v":10420417.92},{"$f":"C34+E34+G34+I34","v":12820246.559999995},{"$f":"SUM(B34:E34)+SUM(F34:I34)","v":23240664.479999997}]
[null,{"$f":"B35-B34","v":0},{"$f":"C35-C34","v":0},0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"P35-P34","v":0},{"$f":"Q35-Q34","v":0},{"$f":"R35-R34","v":0}]
[]
[]
[null,"Fort Bliss"]
[null,"Mains Footage",null,"Cost per Foot"]
["Size","Steel","Plastic","Steel","Plastic"]
[1,{"$f":"Footage!L81*5280","v":8606.4},{"$f":"Footage!L86*5280","v":6071.9999999999991},{"$f":"H23","v":35.094026733333337},23.252665505208338]
[2,{"$f":"Footage!M81*5280","v":86222.399999999994},{"$f":"Footage!M86*5280","v":143457.60000000001},40.865790165625008,23.854229581250006]
[3,{"$f":"Footage!N81*5280","v":14625.6},{"$f":"Footage!N86*5280","v":14303.52},53.636248383333339,28.552168959375006]
[4,{"$f":"Footage!O81*5280","v":73180.800000000003},{"$f":"(Footage!O85+Footage!O86)*5280","v":227784.48000000004},53.083459772916669,32.454206209375002]
[6,{"$f":"Footage!P81*5280","v":24921.599999999999},{"$f":"Footage!P86*5280","v":84342.720000000001},77.653561494791674,46.546838603125011]
[8,{"$f":"Footage!Q81*5280","v":26452.799999999999},{"$f":"Footage!Q86*5280","v":1351.68},102.14259591458335,65.112139668750004]
[10,0,0,0,{"$f":"'Per Ft Cost WTX'!K28","v":0}]
[12,{"$f":"Footage!S81*5280","v":12091.2},0,{"$f":"H30","v":210.66325896458332},0]
[14,0,0,0,0]
[16,{"$f":"Footage!U81*5280","v":10866.24},0,{"$f":"H32","v":218.58191169791669},0]
[20,0,0,0,0]
[null,{"$f":"SUM(B42:B52)","v":256967.04000000001},{"$f":"SUM(C42:C52)","v":477312.00000000006}]
["ck",{"$f":"Footage!W81*5280","v":256967.03999999995},{"$f":"(Footage!W85+Footage!W86)*5280","v":477312.00000000006}]
[]
[]
[null,"RGV"]
[null,"Mains Footage",null,"Cost per Foot"]
["Size","Steel","Plastic","Steel","Plastic"]
[1,{"$f":"Footage!L145*5280","v":108704.64},{"$f":"Footage!L150*5280","v":137037.12},{"$f":"'Per Ft Cost_RGV'!K12","v":30.157018807838469},{"$f":"'Per Ft Cost_RGV'!K6","v":15.475697602916668}]
[2,{"$f":"Footage!M145*5280","v":4532241.12},{"$f":"Footage!M150*5280","v":3900895.68},{"$f":"'Per Ft Cost_RGV'!K13","v":38.325442083293481},{"$f":"'Per Ft Cost_RGV'!K7","v":15.651289279166667}]
[3,{"$f":"Footage!N145*5280","v":305812.32},{"$f":"Footage!N150*5280","v":279.83999999999997},{"$f":"'Per Ft Cost_RGV'!K14","v":47.349732153505059},{"$f":"'Per Ft Cost_RGV'!K8","v":21.236211008333335}]
[4,{"$f":"Footage!O145*5280","v":1929475.6800000002},{"$f":"Footage!O150*5280","v":432326.39999999997},{"$f":"'Per Ft Cost_RGV'!K15","v":48.468465536458332},{"$f":"'Per Ft Cost_RGV'!K9","v":23.561174869791667}]
[6,{"$f":"Footage!P145*5280","v":413682.72000000003},{"$f":"Footage!P150*5280","v":83793.599999999991},{"$f":"'Per Ft Cost_RGV'!K16","v":68.757723111006811},{"$f":"'Per Ft Cost_RGV'!K10","v":33.369522925000005}]
[8,{"$f":"Footage!Q145*5280","v":197229.12},{"$f":"(Footage!Q87+Footage!Q88+Footage!Q89)*5280","v":0},{"$f":"'Per Ft Cost_RGV'!K17","v":94.832500819020808},0]
[10,{"$f":"Footage!R145*5280","v":94063.200000000012},{"$f":"(Footage!R87+Footage!R88+Footage!R89)*5280","v":0},{"$f":"'Per Ft Cost_RGV'!K18","v":116.61082964984486},0]
[12,{"$f":"Footage!S145*5280","v":286186.56},0,{"$f":"'Per Ft Cost_RGV'!K19","v":204.63296130807115},0]
[14,0,0,0,0]
[16,{"$f":"Footage!U83*5280","v":0},0,0,0]
[20,0,0,0,0]
[null,{"$f":"SUM(B60:B70)","v":7867395.3599999994},{"$f":"SUM(C60:C70)","v":4554332.6399999997}]
["ck",{"$f":"(Footage!W145-Footage!V145)*5280","v":7867395.3600000003},{"$f":"Footage!W150*5280","v":4554332.6399999997}]
[null,{"$f":"B72-B71","v":0},{"$f":"C72-C71","v":0}]

{"sheet":"Footage","index":3,"n_rows":154,"n_cols":23,"rows_kept":154,"cut":false,"hidden":false,"merged":[[142,21,143,21],[142,22,143,22],[142,12,143,12],[142,13,143,13],[142,14,143,14],[142,15,143,15],[142,16,143,16],[142,17,143,17],[142,18,143,18],[142,19,143,19],[142,20,143,20],[32,9,33,9],[32,10,33,10],[32,11,33,11],[142,9,143,9],[142,10,143,10],[142,11,143,11],[2,10,3,10],[2,11,3,11],[110,10,111,10],[110,11,111,11],[17,12,18,12],[17,13,18,13],[17,14,18,14],[17,16,18,16],[17,15,18,15],[2,9,3,9],[17,9,18,9],[17,10,18,10],[17,11,18,11],[2,22,3,22],[2,19,3,19],[2,20,3,20],[2,21,3,21],[47,9,48,9],[47,10,48,10],[47,11,48,11],[47,12,48,12],[47,13,48,13],[32,19,33,19],[32,14,33,14],[32,15,33,15],[32,16,33,16],[32,17,33,17],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[17,19,18,19],[17,18,18,18],[17,17,18,17],[62,12,63,12],[62,13,63,13],[32,12,33,12],[32,13,33,13],[47,18,48,18],[47,14,48,14],[47,15,48,15],[47,16,48,16],[47,17,48,17],[32,18,33,18],[62,22,63,22],[62,19,63,19],[62,20,63,20],[62,21,63,21],[78,9,79,9],[78,10,79,10],[78,11,79,11],[78,12,79,12],[78,13,79,13],[78,14,79,14],[78,15,79,15],[78,16,79,16],[78,17,79,17],[78,18,79,18],[78,19,79,19],[78,20,79,20],[62,14,63,14],[62,15,63,15],[62,16,63,16],[62,17,63,17],[62,18,63,18],[62,9,63,9],[62,10,63,10],[62,11,63,11],[110,12,111,12],[110,13,111,13],[78,21,79,21],[78,22,79,22],[94,9,95,9],[94,10,95,10],[94,11,95,11],[94,12,95,12],[94,13,95,13],[94,14,95,14],[94,15,95,15],[94,16,95,16],[94,17,95,17],[94,18,95,18],[94,19,95,19],[94,20,95,20],[94,21,95,21],[94,22,95,22],[126,21,127,21],[126,22,127,22],[110,19,111,19],[110,20,111,20],[110,21,111,21],[110,22,111,22],[126,9,127,9],[126,10,127,10],[126,11,127,11],[126,12,127,12],[126,13,127,13],[126,14,127,14],[126,15,127,15],[126,16,127,16],[126,17,127,17],[126,18,127,18],[126,19,127,19],[126,20,127,20],[110,14,111,14],[110,15,111,15],[110,16,111,16],[110,17,111,17],[110,18,111,18],[110,9,111,9]]}
["CTX"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,813.58,309.25,311.31,71.37,13.13,{"$f":"SUM(B5:G5)","v":1518.6399999999999},null,"Steel",null,27.08,786.5,0.63,308.67,250.5,60.758000000000003,15.893000000000001,55.472999999999999,0.17299999999999999,8.9060000000000006,4.0579999999999998,{"$f":"SUM(K5:V5)","v":1518.6410000000001}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B6:G6)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,0.66,17.16,0.47,null,null,18.29,null,"Cast / Wrought Iron",null,1.0999999999999999E-2,0.65300000000000002,0.45500000000000002,16.704999999999998,0.47,null,null,null,null,null,null,18.293999999999997]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,884.95,337.77,239.32,0.41,null,1462.45,null,"Plastic 2. PE",null,23.460999999999999,861.49,34.92,302.846,227.495,11.827999999999999,null,0.40500000000000003,null,null,null,1462.4449999999999]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B5:B13)","v":0},1699.19,664.18000000000006,551.1,71.78,13.13,2999.38,null,"System Totals",null,{"$f":"SUM(L5:L13)","v":50.551999999999992},{"$f":"SUM(M5:M13)","v":1648.643},36.005000000000003,628.221,478.46500000000003,72.585999999999999,15.893000000000001,55.878,0.17299999999999999,8.9060000000000006,4.0579999999999998,2999.38]
[]
["STX"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,132.91,64.599999999999994,88.15,null,null,{"$f":"SUM(B20:G20)","v":285.65999999999997},null,"Steel",null,3.73,129.18,5.4509999999999996,59.15,87.155000000000001,0.997,{"$f":"SUM(K20:Q20)","v":285.66300000000001}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B21:G21)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,{"$f":"SUM(K21:Q21)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,97.47,23.63,2.04,null,null,123.14,null,"Plastic 2. PE",null,6.21,91.266000000000005,1.288,22.341999999999999,2.0350000000000001,null,123.14099999999999]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B20:B28)","v":0},230.38,88.22999999999999,90.190000000000012,0,0,408.79999999999995,null,"System Totals",{"$f":"SUM(K20:K28)","v":0},{"$f":"SUM(L20:L28)","v":9.94},220.44600000000003,6.7389999999999999,81.49199999999999,89.19,0.997,408.80399999999997]
[]
["Galveston"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","14\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,92.77,34.28,17.62,null,3.93,{"$f":"SUM(B35:G35)","v":148.6},null,"Steel",null,9.0399999999999991,83.73,3.17,31.11,12.73,4.8959999999999999,null,3.9249999999999998,{"$f":"SUM(K35:S35)","v":148.601}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B36:G36)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,0]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,96.75,11.09,3.46,null,null,111.3,null,"Plastic 2. PE",null,8,88.747,null,11.093,1.6910000000000001,1.7669999999999999,null,null,111.298]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B35:B43)","v":0},189.51999999999998,45.370000000000005,21.080000000000002,0,3.93,259.89999999999998,null,"System Totals",{"$f":"SUM(K35:K43)","v":0},{"$f":"SUM(L35:L43)","v":17.04},172.477,3.17,42.203000000000003,14.421000000000001,6.6630000000000003,0,3.9249999999999998,259.899]
[]
["Port Arthur"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,237.6,87.08,26.98,12.51,null,{"$f":"SUM(C50:G50)","v":364.17},null,"Steel",null,9.24,228.35,15.208,71.87,20.024999999999999,6.9580000000000002,12.513999999999999,{"$f":"SUM(K50:R50)","v":364.16500000000002}]
["Ductile Iron",null,null,null,null,null,null,0,null,"Ductile Iron",null,null,null,null,null,null,null,null,{"$f":"SUM(K51:R51)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,{"$f":"SUM(C53:G53)","v":0},null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,126.91,58.5,10.28,null,null,195.69,null,"Plastic 2. PE",null,1.03,125.878,2.5000000000000001E-2,58.476999999999997,8.5719999999999992,1.7110000000000001,null,195.69300000000001]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B50:B58)","v":0},364.51,145.57999999999998,37.26,12.51,0,559.86,null,"System Totals",{"$f":"SUM(K50:K58)","v":0},{"$f":"SUM(L50:L58)","v":10.27},354.22800000000001,15.233000000000001,130.34700000000001,28.596999999999998,8.6690000000000005,12.513999999999999,559.85800000000006]
[]
["WTX/Dell City"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,907.23,336.29,97.686000000000007,4.3319999999999999,23.161999999999999,{"$f":"SUM(B65:G65)","v":1368.7},null,"Steel",null,14.55,892.68,8.32,327.97,84.072999999999993,13.613,2.4529999999999998,1.879,null,23.161999999999999,null,{"$f":"SUM(K65:V65)","v":1368.7}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B66:G66)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K66:V66)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,41.31,null,null,null,null,41.31,null,"Plastic 1. PVC",null,0.02,41.292000000000002,null,null,null,null,null,null,null,null,null,41.312000000000005]
["Plastic 2. PE",null,1434,277.92,140.91999999999999,1.27,null,1854.1100000000001,null,"Plastic 2. PE",null,4.21,1429.7909999999999,0.12,277.79700000000003,130.62200000000001,10.301,1.268,null,null,null,null,1854.1089999999999]
["Plastic 3. ABS",null,2.4500000000000002,null,null,null,null,2.4500000000000002,null,"Plastic 3. ABS",null,0.99,1.456,null,null,null,null,null,null,null,null,null,2.4459999999999997]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B65:B73)","v":0},2384.9899999999998,614.21,238.60599999999999,5.6020000000000003,23.161999999999999,3266.5699999999997,null,"System Totals",{"$f":"SUM(K65:K73)","v":0},{"$f":"SUM(L65:L73)","v":19.77},2365.2190000000001,8.44,605.76700000000005,214.69499999999999,23.914000000000001,3.7210000000000001,1.879,{"$f":"SUM(T65:T73)","v":0},23.161999999999999,0,3266.567]
[]
[]
["Fort Bliss"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,17.96,16.63,9.73,2.29,2.06,{"$f":"SUM(B81:G81)","v":48.670000000000009},null,"Steel",null,1.63,16.329999999999998,2.77,13.86,4.72,5.01,null,2.29,null,2.0579999999999998,null,{"$f":"SUM(K81:V81)","v":48.667999999999992}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B82:G82)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K82:V82)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,0.14000000000000001,null,null,null,0.14000000000000001,null,"Plastic 1. PVC",null,null,null,null,0.13600000000000001,null,null,null,null,null,null,null,0.13600000000000001]
["Plastic 2. PE",null,28.32,45.713999999999999,16.23,null,null,90.263999999999996,null,"Plastic 2. PE",null,1.1499999999999999,27.17,2.7090000000000001,43.005000000000003,15.974,0.25600000000000001,null,null,null,null,null,90.26400000000001]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B81:B89)","v":0},46.28,62.483999999999995,25.96,2.29,2.06,139.07400000000001,null,"System Totals",{"$f":"SUM(K81:K89)","v":0},{"$f":"SUM(L81:L89)","v":2.78},43.5,5.4790000000000001,57.001000000000005,20.693999999999999,5.266,0,2.29,0,2.0579999999999998,0,139.06800000000001]
[]
[]
["Permian"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,165.77,57.61,39.99,null,null,{"$f":"SUM(B97:G97)","v":263.37},null,"Steel",null,11.62,154.15,17.2,40.409999999999997,39.99,null,null,null,null,null,null,{"$f":"SUM(K97:V97)","v":263.37}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B98:G98)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K98:V98)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,67.97,21.01,11.05,null,null,100.03,null,"Plastic 2. PE",null,3.38,64.590999999999994,4.9790000000000001,16.033999999999999,11.05,null,null,null,null,null,null,100.03399999999998]
["Plastic 3. ABS",null,0.32,null,null,null,null,0.32,null,"Plastic 3. ABS",null,null,0.32,null,null,null,null,null,null,null,null,null,0.32]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B97:B105)","v":0},234.06,78.62,51.040000000000006,0,0,363.71999999999997,null,"System Totals",{"$f":"SUM(K97:K105)","v":0},{"$f":"SUM(L97:L105)","v":15},219.06099999999998,22.178999999999998,56.443999999999996,51.040000000000006,0,0,0,0,0,0,363.72399999999999]
[]
[]
["Borger-SK"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,59.23,12.6,6.23,null,null,{"$f":"SUM(B113:G113)","v":78.06},null,"Steel",null,0.76,58.466000000000001,0.97,11.631,5.19,1.044,null,null,null,null,null,{"$f":"SUM(K113:V113)","v":78.060999999999993}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B114:G114)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K114:V114)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,32.29,14.35,2.67,null,null,49.31,null,"Plastic 2. PE",null,1.68,30.613,2.4239999999999999,11.925000000000001,2.665,null,null,null,null,null,null,49.306999999999995]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B113:B121)","v":0},91.52,26.95,8.9,0,0,127.37,null,"System Totals",{"$f":"SUM(K113:K121)","v":0},{"$f":"SUM(L113:L121)","v":2.44},89.079000000000008,3.3940000000000001,23.556000000000001,7.8550000000000004,1.044,0,0,0,0,0,127.36799999999999]
[]
[]
["NTX"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,124.5,104.65,33.96,0.32,null,{"$f":"SUM(B129:G129)","v":263.43},null,"Steel",null,13.01,111.49,16.09,88.563999999999993,30.19,3.766,0.32300000000000001,null,null,null,null,{"$f":"SUM(K129:V129)","v":263.43299999999999}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B130:G130)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K130:V130)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,38.369999999999997,18.78,null,null,null,57.15,null,"Plastic 1. PVC",null,1.0549999999999999,37.31,0.128,18.652000000000001,null,null,null,null,null,null,null,57.145000000000003]
["Plastic 2. PE",null,151.46,149.99,21.89,null,null,323.34000000000003,null,"Plastic 2. PE",null,7.3339999999999996,144.13,25.33,124.661,21.587,0.3,null,null,null,null,null,323.34199999999998]
["Plastic 3. ABS",null,0.06,null,null,null,null,0.06,null,"Plastic 3. ABS",null,null,6.2E-2,null,null,null,null,null,null,null,null,null,6.2E-2]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B129:B137)","v":0},314.39000000000004,273.42,55.85,0.32,0,643.98,null,"System Totals",{"$f":"SUM(K129:K137)","v":0},{"$f":"SUM(L129:L137)","v":21.399000000000001},292.99200000000002,41.548000000000002,231.87700000000001,51.777000000000001,4.0659999999999998,0.32300000000000001,0,0,0,0,643.98199999999997]
[]
[]
["RGV"]
["Miles of Mains in System at End of Year - 2023 DOT Report filed March 2024",null,null,null,null,null,null,null,null,"MILES OF MAINS FOR RATES BY PIPE SIZE"]
[null,null,null,"Over 2\"","Over 4\"","Over 8\"","Over 12\"",null,null,"Material","Unknown","1\"","2\"","3\"","4\"","6\"","8\"","10\"","12\"","14\"","16\"","20\"","TOTAL"]
["Material","Unknown","2\" or less","thru 4\"","thru 8\"","thru 12\"",null,"TOTAL"]
["Steel",null,878.97,423.34,115.71,72.010000000000005,0.01,{"$f":"SUM(B145:G145)","v":1490.04},null,"Steel",null,20.588000000000001,858.37900000000002,57.918999999999997,{"$f":"365.42+0.011","v":365.43100000000004},78.349000000000004,37.353999999999999,17.815000000000001,54.201999999999998,null,null,null,{"$f":"SUM(K145:V145)","v":1490.037}]
["Ductile Iron",null,null,null,null,null,null,{"$f":"SUM(B146:G146)","v":0},null,"Ductile Iron",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K146:V146)","v":0}]
["Copper",null,null,null,null,null,null,0,null,"Copper",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Cast / Wrought Iron",null,null,null,null,null,null,0,null,"Cast / Wrought Iron",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 1. PVC",null,null,null,null,null,null,0,null,"Plastic 1. PVC",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Plastic 2. PE",null,764.76,81.93,15.87,null,null,862.56000000000006,null,"Plastic 2. PE",null,25.954000000000001,738.80600000000004,5.2999999999999999E-2,81.88,15.87,null,null,null,null,null,null,862.56299999999999]
["Plastic 3. ABS",null,null,null,null,null,null,0,null,"Plastic 3. ABS",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Plastic",null,null,null,null,null,null,0,null,"Other Plastic",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,0,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["System Totals",{"$f":"SUM(B145:B153)","v":0},1643.73,505.27,131.57999999999998,72.010000000000005,0.01,2352.6,null,"System Totals",{"$f":"SUM(K145:K153)","v":0},{"$f":"SUM(L145:L153)","v":46.542000000000002},1597.1849999999999,57.971999999999994,447.31100000000004,94.219000000000008,37.353999999999999,17.815000000000001,54.201999999999998,0,0,0,2352.6]

{"sheet":"Per Ft Cost_CTX","index":4,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["CTX Service Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
[]
["Steel",1,null,4.75,null,null,{"$f":"D6*(1+$G$4)","v":5.7884687500000007},null,{"$f":"+I78","v":25.6},null,{"$f":"(I6+G6)*(1+$K$4)","v":41.877448723958338}]
[null,2,null,9.5500000000000007,null,null,11.637868750000001,null,25.6,null,49.681523223958344]
[null,3,null,10.58,null,null,12.893052500000001,null,28.75,null,55.55877254375001]
[null,4,null,8.1199999999999992,null,null,9.8952349999999996,null,28.75,null,51.559184362499998]
[null,6,null,13.45,null,null,16.390506250000001,null,31.2,null,63.493667088541677]
[null,8,null,19.78,null,null,24.104402500000003,null,35,null,78.855123668750011]
[null,10,null,29.95,null,null,36.49781875,null,48.3,null,113.13442318229168]
[null,12,null,36.76,null,null,44.796655000000001,null,52.4,null,129.67653721249999]
[null,14,null,61.97,null,null,75.518191250000001,null,78.8,null,205.88618682604167]
[null,16,null,52.86,null,null,64.416517499999998,null,78.8,null,191.07470376458335]
[null,20,null,72.36,null,null,88.179704999999998,null,137.32499999999999,null,300.86086058750004]
["Plastic"]
[null,1,null,0.65,null,null,{"$f":"D18*(1+$G$4)","v":0.79210625000000012},null,{"$f":"+D66","v":18.25},null,{"$f":"(I18+G18)*(1+$K$4)","v":25.405343421874999}]
[null,2,null,1.02,null,null,1.2429975000000002,null,{"$f":"+D67","v":18.25},null,26.006907497916668]
[null,3,null,1.49,null,null,1.8157512500000001,null,{"$f":"+D68","v":21},null,30.440014792708336]
[null,4,null,3.52,null,null,4.2895600000000007,null,{"$f":"+D69","v":21},null,33.74048796666667]
[null,6,null,7.63,null,null,9.2981087500000008,null,{"$f":"+D70","v":23.6},null,43.891560090625006]
[null,8,null,14.18,null,null,17.280102500000002,null,{"$f":"+D71","v":26.35},null,58.209828418750014]
[null,12,null,20.03,null,null,24.409058750000003,null,62.90100000000001,null,116.48617004895836]
["Wrought Iron"]
[null,1,null,4.75,null,null,{"$f":"D26*(1+$G$4)","v":5.7884687500000007},null,{"$f":"N66","v":25.6},null,{"$f":"(I26+G26)*(1+$K$4)","v":41.877448723958338}]
[null,2,null,9.5500000000000007,null,null,11.637868750000001,null,{"$f":"N67","v":25.6},null,49.681523223958344]
[null,3,null,10.58,null,null,12.893052500000001,null,{"$f":"N68","v":28.75},null,55.55877254375001]
[null,4,null,8.1199999999999992,null,null,9.8952349999999996,null,{"$f":"N69","v":28.75},null,51.559184362499998]
[null,6,null,13.45,null,null,16.390506250000001,null,{"$f":"N70","v":31.2},null,63.493667088541677]
[]
[]
["2024 Data"]
["No Soil Upcharge Cost - 10%",null,null,null,null,"No Soil Upcharge Cost - 10%",null,null,null,null,"No Soil Upcharge Cost - 10%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,15.5,null,"Steel","1\"",null,21,null,"Wrought Iron","1\"",null,{"$f":"I36","v":21}]
["Plastic","2\"",null,{"$f":"D36","v":15.5},null,"Steel","2\"",null,{"$f":"I36","v":21},null,"Wrought Iron","2\"",null,21]
["Plastic","3\"",null,16.5,null,"Steel","3\"",null,24,null,"Wrought Iron","3\"",null,24]
["Plastic","4\"",null,{"$f":"D38","v":16.5},null,"Steel","4\"",null,{"$f":"I38","v":24},null,"Wrought Iron","4\"",null,24]
["Plastic","6\"",null,20,null,"Steel","6\"",null,29,null,"Wrought Iron","6\"",null,29]
["Plastic","8\"",null,23.5,null,"Steel","8\"",null,32]
["Plastic","12\"",null,55.61,null,"Steel","10\"",null,37]
[null,null,null,null,null,"Steel","12\"",null,41]
["Mix Soil Cost - 80%",null,null,null,null,"Steel","14\"",null,70,null,"Mix Soil Cost - 80%"]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","16\"",null,70,null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,18,null,"Steel","20\"",null,115.51,null,"Wrought Iron","1\"",null,{"$f":"I50","v":26}]
["Plastic","2\"",null,{"$f":"D46","v":18},null,null,null,null,null,null,"Wrought Iron","2\"",null,26]
["Plastic","3\"",null,21,null,"Mix Soil Cost - 80%",null,null,null,null,"Wrought Iron","3\"",null,29]
["Plastic","4\"",null,{"$f":"D48","v":21},null,"Type","Size",null,"Labor Rate/Ft",null,"Wrought Iron","4\"",null,29]
["Plastic","6\"",null,23.5,null,"Steel","1\"",null,26,null,"Wrought Iron","6\"",null,31]
["Plastic","8\"",null,26,null,"Steel","2\"",null,{"$f":"I50","v":26}]
["Plastic","12\"",null,64.260000000000005,null,"Steel","3\"",null,29]
[null,null,null,null,null,"Steel","4\"",null,{"$f":"I52","v":29}]
["Rock Soil Cost - 10%",null,null,null,null,"Steel","6\"",null,31,null,"Rock Soil Cost - 10%"]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","8\"",null,35,null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,23,null,"Steel","10\"",null,49,null,"Wrought Iron","1\"",null,{"$f":"I64","v":27}]
["Plastic","2\"",null,{"$f":"D56","v":23},null,"Steel","12\"",null,53,null,"Wrought Iron","2\"",null,27]
["Plastic","3\"",null,25.5,null,"Steel","14\"",null,80,null,"Wrought Iron","3\"",null,31.5]
["Plastic","4\"",null,{"$f":"D58","v":25.5},null,"Steel","16\"",null,80,null,"Wrought Iron","4\"",null,31.5]
["Plastic","6\"",null,28,null,"Steel","20\"",null,133.62,null,"Wrought Iron","6\"",null,35]
["Plastic","8\"",null,32]
["Plastic","12\"",null,59.32,null,"Rock Soil Cost - 10%"]
[null,null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
["AVERAGE (Weighted)",null,null,null,null,"Steel","1\"",null,27,null,"AVERAGE (Weighted)"]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","2\"",null,{"$f":"I64","v":27},null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,{"$f":"+(D36*1+D46*8+D56*1)/10","v":18.25},null,"Steel","3\"",null,31.5,null,"Wrought Iron","1\"",null,{"$f":"+(N36*1+N46*8+N56*1)/10","v":25.6}]
["Plastic","2\"",null,{"$f":"+(D37*1+D47*8+D57*1)/10","v":18.25},null,"Steel","4\"",null,{"$f":"I66","v":31.5},null,"Wrought Iron","2\"",null,{"$f":"+(N37*1+N47*8+N57*1)/10","v":25.6}]
["Plastic","3\"",null,{"$f":"+(D38*1+D48*8+D58*1)/10","v":21},null,"Steel","6\"",null,35,null,"Wrought Iron","3\"",null,28.75]
["Plastic","4\"",null,{"$f":"+(D39*1+D49*8+D59*1)/10","v":21},null,"Steel","8\"",null,38,null,"Wrought Iron","4\"",null,28.75]
["Plastic","6\"",null,{"$f":"+(D40*1+D50*8+D60*1)/10","v":23.6},null,"Steel","10\"",null,54,null,"Wrought Iron","6\"",null,31.2]
["Plastic","8\"",null,{"$f":"+(D41*1+D51*8+D61*1)/10","v":26.35},null,"Steel","12\"",null,59]
["Plastic","12\"",null,62.90100000000001,null,"Steel","14\"",null,78]
[null,null,null,null,null,"Steel","16\"",null,78]
[null,null,null,null,null,"Steel","20\"",null,188.78]
[]
[null,null,null,null,null,"AVERAGE (Weighted)"]
[null,null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
[null,null,null,null,null,"Steel","1\"",null,{"$f":"+(I36*1+I50*8+I64*1)/10","v":25.6}]
[null,null,null,null,null,"Steel","2\"",null,{"$f":"+(I37*1+I51*8+I65*1)/10","v":25.6}]
[null,null,null,null,null,"Steel","3\"",null,28.75]
[null,null,null,null,null,"Steel","4\"",null,28.75]
[null,null,null,null,null,"Steel","6\"",null,31.2]
[null,null,null,null,null,"Steel","8\"",null,35]
[null,null,null,null,null,"Steel","10\"",null,48.3]
[null,null,null,null,null,"Steel","12\"",null,52.4]
[null,null,null,null,null,"Steel","14\"",null,78.8]
[null,null,null,null,null,"Steel","16\"",null,78.8]
[null,null,null,null,null,"Steel","20\"",null,137.32499999999999]

{"sheet":"Per Ft Cost_STX","index":5,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["STX Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
["Plastic"]
[null,1,null,0.65,null,null,{"$f":"D6*(1+$G$4)","v":0.79210625000000012},null,{"$f":"+D49","v":13.3225},null,{"$f":"(I6+G6)*(1+$K$4)","v":18.831237171874999}]
[null,2,null,1.02,null,null,1.2429975000000002,null,{"$f":"+D50","v":13.3225},null,19.432801247916668]
[null,3,null,1.49,null,null,1.8157512500000001,null,{"$f":"+D51","v":14.724500000000001},null,22.06745187604167]
[null,4,null,3.52,null,null,4.2895600000000007,null,{"$f":"+D52","v":14.724500000000001},null,25.36792505]
[null,6,null,7.63,null,null,9.2981087500000008,null,{"$f":"+D53","v":17.385000000000002},null,35.599714257291673]
["Steel"]
[null,1,null,3.36,null,null,{"$f":"D12*(1+$G$4)","v":4.0945799999999997},null,{"$f":"+I59","v":15.732500000000002},null,{"$f":"(I12+G12)*(1+$K$4)","v":26.452629233333337}]
[null,2,null,6.87,null,null,8.3719537500000012,null,15.732500000000002,null,32.159358711458339]
[null,3,null,11.52,null,null,14.03856,null,18.038500000000003,null,42.796144216666676]
[null,4,null,11.1,null,null,13.526737500000001,null,18.038500000000003,null,42.113287697916668]
[null,6,null,19.010000000000002,null,null,23.166061250000002,null,21.014500000000002,null,58.944232134375007]
[null,8,null,28.22,null,null,34.389597500000001,null,23.674500000000002,null,77.467183414583346]
[]
["2024 Data"]
["No Soil Adder Cost - 75%",null,null,null,null,"No Soil Adder Cost - 75%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,12.93,null,"Steel","1\"",null,15.17]
["Plastic","2\"",null,12.93,null,"Steel","2\"",null,15.17]
["Plastic","3\"",null,14.05,null,"Steel","3\"",null,17.420000000000002]
["Plastic","4\"",null,14.05,null,"Steel","4\"",null,17.420000000000002]
["Plastic","6\"",null,16.850000000000001,null,"Steel","6\"",null,20.79]
[null,null,null,null,null,"Steel","8\"",null,23.59]
[]
["Mix Soil Cost -20%"]
["Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,14.05]
["Plastic","2\"",null,14.05]
["Plastic","3\"",null,16.3,null,"Mix Soil Cost - 20%"]
["Plastic","4\"",null,16.3,null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","6\"",null,18.54,null,"Steel","1\"",null,17.420000000000002]
[null,null,null,null,null,"Steel","2\"",null,17.420000000000002]
[null,null,null,null,null,"Steel","3\"",null,19.670000000000002]
["Rock Soil Cost - 5%",null,null,null,null,"Steel","4\"",null,19.670000000000002]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","6\"",null,21.35]
["Plastic","1\"",null,16.3,null,"Steel","8\"",null,23.59]
["Plastic","2\"",null,16.3]
["Plastic","3\"",null,18.54]
["Plastic","4\"",null,18.54]
["Plastic","6\"",null,20.79]
[]
[null,null,null,null,null,"Rock Soil Cost - 5%"]
["AVERAGE (Weighted)",null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","1\"",null,17.420000000000002]
["Plastic","1\"",null,{"$f":"+(D22*7.5+D31*2+D40*0.5)/10","v":13.3225},null,"Steel","2\"",null,17.420000000000002]
["Plastic","2\"",null,13.3225,null,"Steel","3\"",null,20.79]
["Plastic","3\"",null,14.724500000000001,null,"Steel","4\"",null,20.79]
["Plastic","4\"",null,14.724500000000001,null,"Steel","6\"",null,23.04]
["Plastic","6\"",null,17.385000000000002,null,"Steel","8\"",null,25.28]
[]
[]
[]
[null,null,null,null,null,"AVERAGE (Weighted)"]
[null,null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
[null,null,null,null,null,"Steel","1\"",null,{"$f":"+(I22*7.5+I35*2+I48*0.5)/10","v":15.732500000000002}]
[null,null,null,null,null,"Steel","2\"",null,15.732500000000002]
[null,null,null,null,null,"Steel","3\"",null,18.038500000000003]
[null,null,null,null,null,"Steel","4\"",null,18.038500000000003]
[null,null,null,null,null,"Steel","6\"",null,21.014500000000002]
[null,null,null,null,null,"Steel","8\"",null,23.674500000000002]

{"sheet":"Per Ft Cost_PA&G","index":6,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["Port Arthur and Galveston Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
["Plastic"]
[null,1,null,0.65,null,null,{"$f":"D6*(1+$G$4)","v":0.79210625000000012},null,{"$f":"+D27","v":12.25},null,{"$f":"(I6+G6)*(1+$K$4)","v":17.400343421875}]
[null,2,null,1.02,null,null,1.2429975000000002,null,12.25,null,18.001907497916665]
[null,3,null,1.49,null,null,1.8157512500000001,null,15.25,null,22.768556459375002]
[null,4,null,3.52,null,null,4.2895600000000007,null,15.25,null,26.069029633333336]
[null,6,null,7.63,null,null,9.2981087500000008,null,17.25,null,35.419601757291666]
[null,8,null,14.18,null,null,17.280102500000002,null,20.25,null,50.071411752083336]
[]
["Steel"]
[null,1,null,3.36,null,null,4.0945799999999997,null,{"$f":"+I27","v":21.25},null,33.81389381666667]
[null,2,null,6.87,null,null,8.3719537500000012,null,21.25,null,39.520623294791669]
[null,3,null,11.52,null,null,14.03856,null,26.25,null,53.751653800000007]
[null,4,null,11.1,null,null,13.526737500000001,null,26.25,null,53.068797281250006]
[null,6,null,19.010000000000002,null,null,23.166061250000002,null,34.25,null,76.602595051041675]
[null,8,null,28.22,null,null,34.389597500000001,null,49.25,null,111.58916299791669]
[null,10,null,41.12,null,null,50.109859999999998,null,56.25,null,141.90177988333335]
[null,12,null,50.21,null,null,61.187161250000003,null,{"$f":"+I34","v":68.25},null,172.69074596770835]
[null,14,null,61.97,null,null,75.518191250000001,null,{"$f":"+I35","v":80.25},null,207.82072849270835]
[]
["2024 Data"]
["No Soil Addeder Cost - 100%",null,null,null,null,"No Soil Addeder Cost - 100%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,12.25,null,"Steel","1\"",null,21.25]
["Plastic","2\"",null,12.25,null,"Steel","2\"",null,21.25]
["Plastic","3\"",null,15.25,null,"Steel","3\"",null,26.25]
["Plastic","4\"",null,15.25,null,"Steel","4\"",null,26.25]
["Plastic","6\"",null,17.25,null,"Steel","6\"",null,34.25]
["Plastic","8\"",null,20.25,null,"Steel","8\"",null,49.25]
[null,null,null,null,null,"Steel","10\"",null,56.25]
[null,null,null,null,null,"Steel","12\"",null,68.25]
[null,null,null,null,null,"Steel","14\"",null,{"$f":"I34-I33+I34","v":80.25}]

{"sheet":"Per Ft Cost WTX","index":7,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["WTX Service Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
["Plastic"]
[null,1,null,0.65,null,null,{"$f":"D6*(1+$G$4)","v":0.79210625000000012},null,{"$f":"+D54","v":16.636500000000002},null,{"$f":"(I6+G6)*(1+$K$4)","v":23.252665505208338}]
[null,2,null,1.02,null,null,{"$f":"D7*(1+$G$4)","v":1.2429975000000002},null,{"$f":"+D55","v":16.636500000000002},null,23.854229581250006]
[null,3,null,1.49,null,null,1.8157512500000001,null,19.585000000000001,null,28.552168959375006]
[null,4,null,3.89,null,null,4.7404512500000004,null,19.585000000000001,null,32.454206209375002]
[null,6,null,7.91,null,null,9.6393237500000009,null,25.249000000000002,null,46.546838603125011]
[null,8,null,14.18,null,null,17.280102500000002,null,31.523500000000002,null,65.112139668750004]
[null,10,null,22.24,null,null,27.102219999999999,null,37.798000000000002,null,86.587710183333343]
["Steel"]
[null,1,null,3.36,null,null,4.0945799999999997,null,{"$f":"+I66","v":22.209500000000002},null,35.094026733333337]
[null,2,null,6.91,null,null,8.4206987500000015,null,22.209500000000002,null,40.865790165625008]
[null,3,null,11.52,null,null,14.03856,null,26.163499999999999,null,53.636248383333339]
[null,4,null,11.18,null,null,13.6242275,null,26.163499999999999,null,53.083459772916669]
[null,6,null,20.149999999999999,null,null,24.555293750000001,null,33.648499999999999,null,77.653561494791674]
[null,8,null,28.22,null,null,34.389597500000001,null,42.169500000000006,null,102.14259591458335]
[null,10,null,41.12,null,null,50.109859999999998,null,47.3125,null,129.97766530000001]
[null,12,null,66.94,null,null,81.574757500000004,null,76.323999999999998,null,210.66325896458332]
[null,16,null,40.700000000000003,null,null,49.598037500000004,null,114.23600000000002,null,218.58191169791669]
[]
["2024 Data"]
["No Soil Adder Cost - 15%",null,null,null,null,"No Soil Adder Cost - 15%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,11.44,null,"Steel","1\"",null,14.72]
["Plastic","2\"",null,11.44,null,"Steel","2\"",null,14.72]
["Plastic","3\"",null,13.16,null,"Steel","3\"",null,17.05]
["Plastic","4\"",null,13.16,null,"Steel","4\"",null,17.05]
["Plastic","6\"",null,17.48,null,"Steel","6\"",null,22.26]
["Plastic","8\"",null,21.4,null,"Steel","8\"",null,28.19]
["Plastic","10\"",null,{"$f":"+D32-D31+D32","v":25.319999999999997},null,"Steel","10\"",null,31.91]
["Mix Soil Cost -70%",null,null,null,null,"Steel","12\"",null,67.5]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","16\"",null,92.3]
["Plastic","1\"",null,15.39]
["Plastic","2\"",null,15.39]
["Plastic","3\"",null,17.38,null,"Mix Soil Cost - 70%"]
["Plastic","4\"",null,17.38,null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","6\"",null,22.75,null,"Steel","1\"",null,20.63]
["Plastic","8\"",null,28.3,null,"Steel","2\"",null,20.63]
["Plastic","10\"",null,{"$f":"+D41-D40+D41","v":33.85},null,"Steel","3\"",null,23.3]
["Rock Soil Cost - 15%",null,null,null,null,"Steel","4\"",null,23.3]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","6\"",null,30.47]
["Plastic","1\"",null,27.65,null,"Steel","8\"",null,37.92]
["Plastic","2\"",null,27.65,null,"Steel","10\"",null,43.15]
["Plastic","3\"",null,36.299999999999997,null,"Steel","12\"",null,75.400000000000006]
["Plastic","4\"",null,36.299999999999997,null,"Steel","16\"",null,112.43]
["Plastic","6\"",null,44.68]
["Plastic","8\"",null,56.69]
["Plastic","10\"",null,{"$f":"+D50-D49+D50","v":68.699999999999989},null,"Rock Soil Cost - 15%"]
["AVERAGE (Weighted)",null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
["Type","Size",null,"Labor Rate/Ft ELP",null,"Steel","1\"",null,37.07]
["Plastic","1\"",null,{"$f":"+(D27*1.5+D36*7+D45*1.5)/10","v":16.636500000000002},null,"Steel","2\"",null,37.07]
["Plastic","2\"",null,{"$f":"+(D28*1.5+D37*7+D46*1.5)/10","v":16.636500000000002},null,"Steel","3\"",null,48.64]
["Plastic","3\"",null,19.585000000000001,null,"Steel","4\"",null,48.64]
["Plastic","4\"",null,19.585000000000001,null,"Steel","6\"",null,59.87]
["Plastic","6\"",null,25.249000000000002,null,"Steel","8\"",null,75.98]
["Plastic","8\"",null,31.523500000000002,null,"Steel","10\"",null,82.14]
["Plastic","10\"",null,37.798000000000002,null,"Steel","12\"",null,89.46]
[null,null,null,null,null,"Steel","16\"",null,144.6]
[]
[]
[null,null,null,null,null,"AVERAGE (Weighted)"]
[null,null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
[null,null,null,null,null,"Steel","1\"",null,{"$f":"+(I27*1.5+I40*7+I53*1.5)/10","v":22.209500000000002}]
[null,null,null,null,null,"Steel","2\"",null,{"$f":"+(I28*1.5+I41*7+I54*1.5)/10","v":22.209500000000002}]
[null,null,null,null,null,"Steel","3\"",null,26.163499999999999]
[null,null,null,null,null,"Steel","4\"",null,26.163499999999999]
[null,null,null,null,null,"Steel","6\"",null,33.648499999999999]
[null,null,null,null,null,"Steel","8\"",null,42.169500000000006]
[null,null,null,null,null,"Steel","10\"",null,47.3125]
[null,null,null,null,null,"Steel","12\"",null,76.323999999999998]
[null,null,null,null,null,"Steel","16\"",null,114.23600000000002]

{"sheet":"Per Ft Cost_Permian","index":8,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["Permian Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
["Plastic"]
[null,1,null,0.65,null,null,{"$f":"D6*(1+$G$4)","v":0.79210625000000012},null,{"$f":"+D48","v":18.102499999999999},null,{"$f":"(I6+G6)*(1+$K$4)","v":25.208553838541665}]
[null,2,null,1.02,null,null,1.2429975000000002,null,{"$f":"+D49","v":18.102499999999999},null,25.810117914583333]
[null,3,null,1.49,null,null,1.8157512500000001,null,{"$f":"+D50","v":24.042499999999997},null,34.499216876041665]
[null,4,null,3.52,null,null,4.2895600000000007,null,{"$f":"+D51","v":24.042499999999997},null,37.799690050000002]
[null,6,null,7.63,null,null,9.2981087500000008,null,{"$f":"+D52","v":25.822500000000002},null,46.85674550729167]
["Steel"]
[null,1,null,3.36,null,null,4.0945799999999997,null,{"$f":"+I57","v":19.222499999999997},null,31.108870899999996]
[null,2,null,6.87,null,null,8.3719537500000012,null,{"$f":"+I58","v":19.222499999999997},null,36.815600378124998]
[null,3,null,11.52,null,null,14.03856,null,{"$f":"+I59","v":25.552500000000002},null,52.821072550000004]
[null,4,null,11.1,null,null,13.526737500000001,null,{"$f":"+I60","v":25.552500000000002},null,52.13821603125001]
[null,6,null,19.010000000000002,null,null,23.166061250000002,null,{"$f":"+I61","v":27.372500000000002},null,67.426863801041677]
[]
["2024 Data"]
["No Soil Addeder Cost - 50%",null,null,null,null,"No Soil Addeder Cost - 50%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,8.9,null,"Steel","1\"",null,10.02]
["Plastic","2\"",null,8.9,null,"Steel","2\"",null,10.02]
["Plastic","3\"",null,14.84,null,"Steel","3\"",null,16.350000000000001]
["Plastic","4\"",null,14.84,null,"Steel","4\"",null,16.350000000000001]
["Plastic","6\"",null,16.62,null,"Steel","6\"",null,18.170000000000002]
[]
[]
["Mix Soil Cost -25%"]
["Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,20.51]
["Plastic","2\"",null,20.51]
["Plastic","3\"",null,26.45,null,"Mix Soil Cost - 25%"]
["Plastic","4\"",null,26.45,null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","6\"",null,28.23,null,"Steel","1\"",null,21.63]
[null,null,null,null,null,"Steel","2\"",null,21.63]
[null,null,null,null,null,"Steel","3\"",null,27.96]
["Rock Soil Cost - 25%",null,null,null,null,"Steel","4\"",null,27.96]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","6\"",null,29.78]
["Plastic","1\"",null,34.1]
["Plastic","2\"",null,34.1]
["Plastic","3\"",null,40.04]
["Plastic","4\"",null,40.04]
["Plastic","6\"",null,41.82]
[]
[null,null,null,null,null,"Rock Soil Cost - 25%"]
["AVERAGE (Weighted)",null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","1\"",null,35.22]
["Plastic","1\"",null,{"$f":"+(D21*5+D30*2.5+D39*2.5)/10","v":18.102499999999999},null,"Steel","2\"",null,35.22]
["Plastic","2\"",null,{"$f":"+(D22*5+D31*2.5+D40*2.5)/10","v":18.102499999999999},null,"Steel","3\"",null,41.55]
["Plastic","3\"",null,{"$f":"+(D23*5+D32*2.5+D41*2.5)/10","v":24.042499999999997},null,"Steel","4\"",null,41.55]
["Plastic","4\"",null,24.042499999999997,null,"Steel","6\"",null,43.37]
["Plastic","6\"",null,25.822500000000002]
[]
[]
[null,null,null,null,null,"AVERAGE (Weighted)"]
[null,null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
[null,null,null,null,null,"Steel","1\"",null,{"$f":"+(I21*5+I34*2.5+I47*2.5)/10","v":19.222499999999997}]
[null,null,null,null,null,"Steel","2\"",null,{"$f":"+(I22*5+I35*2.5+I48*2.5)/10","v":19.222499999999997}]
[null,null,null,null,null,"Steel","3\"",null,{"$f":"+(I23*5+I36*2.5+I49*2.5)/10","v":25.552500000000002}]
[null,null,null,null,null,"Steel","4\"",null,{"$f":"+(I24*5+I37*2.5+I50*2.5)/10","v":25.552500000000002}]
[null,null,null,null,null,"Steel","6\"",null,27.372500000000002]

{"sheet":"Per Ft Cost_NTX & Borger ","index":9,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["NTX & Borger Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
["Plastic"]
[null,1,null,0.65,null,null,{"$f":"D6*(1+$G$4)","v":0.79210625000000012},null,{"$f":"+D55","v":22.54},null,{"$f":"(I6+G6)*(1+$K$4)","v":31.128918421874999}]
[null,2,null,1.02,null,null,1.2429975000000002,null,{"$f":"+D56","v":22.54},null,31.730482497916668]
[null,3,null,1.49,null,null,1.8157512500000001,null,26.21,null,37.391023126041674]
[null,4,null,3.52,null,null,4.2895600000000007,null,26.21,null,40.691496300000004]
[null,6,null,7.63,null,null,9.2981087500000008,null,37.239999999999995,null,62.089593423958327]
[null,8,null,14.18,null,null,17.280102500000002,null,55.61,null,97.247545085416661]
["Steel"]
[null,1,null,3.36,null,null,4.0945799999999997,null,{"$f":"+I65","v":38.46},null,56.774902150000003]
[null,2,null,6.87,null,null,8.3719537500000012,null,38.46,null,62.481631628125008]
[null,3,null,11.52,null,null,14.03856,null,47.03,null,81.47563713333335]
[null,4,null,11.1,null,null,13.526737500000001,null,47.03,null,80.792780614583336]
[null,6,null,19.010000000000002,null,null,23.166061250000002,null,71.509999999999991,null,126.31364505104166]
[null,8,null,28.22,null,null,34.389597500000001,null,98.45,null,177.23016299791666]
[null,10,null,41.12,null,null,50.109859999999998,null,125.38999999999999,null,234.14606321666665]
[]
[]
[]
[]
[]
["2024 Data"]
["No Soil Addeder Cost - 50%",null,null,null,null,"No Soil Addeder Cost - 50%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,9.7899999999999991,null,"Steel","1\"",null,25.71]
["Plastic","2\"",null,9.7899999999999991,null,"Steel","2\"",null,25.71]
["Plastic","3\"",null,13.46,null,"Steel","3\"",null,34.28]
["Plastic","4\"",null,13.46,null,"Steel","4\"",null,34.28]
["Plastic","6\"",null,24.49,null,"Steel","6\"",null,58.76]
["Plastic","8\"",null,42.86,null,"Steel","8\"",null,85.7]
[null,null,null,null,null,"Steel","10\"",null,112.64]
["Mix Soil Cost -25%"]
["Type","Size",null,"Labor Rate/Ft"]
["Plastic","1\"",null,27.79]
["Plastic","2\"",null,27.79]
["Plastic","3\"",null,31.46,null,"Mix Soil Cost - 25%"]
["Plastic","4\"",null,31.46,null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","6\"",null,42.489999999999995,null,"Steel","1\"",null,43.71]
["Plastic","8\"",null,60.86,null,"Steel","2\"",null,43.71]
[null,null,null,null,null,"Steel","3\"",null,52.28]
["Rock Soil Cost - 25%",null,null,null,null,"Steel","4\"",null,52.28]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","6\"",null,76.759999999999991]
["Plastic","1\"",null,42.79,null,"Steel","8\"",null,103.7]
["Plastic","2\"",null,42.79,null,"Steel","10\"",null,130.63999999999999]
["Plastic","3\"",null,46.46]
["Plastic","4\"",null,46.46]
["Plastic","6\"",null,57.489999999999995]
["Plastic","8\"",null,75.86]
[null,null,null,null,null,"Rock Soil Cost - 25%"]
["AVERAGE (Weighted)",null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
["Type","Size",null,"Labor Rate/Ft",null,"Steel","1\"",null,58.71]
["Plastic","1\"",null,{"$f":"+(D28*5+D37*2.5+D46*2.5)/10","v":22.54},null,"Steel","2\"",null,58.71]
["Plastic","2\"",null,{"$f":"+(D29*5+D38*2.5+D47*2.5)/10","v":22.54},null,"Steel","3\"",null,67.28]
["Plastic","3\"",null,{"$f":"+(D30*5+D39*2.5+D48*2.5)/10","v":26.21},null,"Steel","4\"",null,67.28]
["Plastic","4\"",null,26.21,null,"Steel","6\"",null,91.759999999999991]
["Plastic","6\"",null,37.239999999999995,null,"Steel","8\"",null,118.7]
["Plastic","8\"",null,55.61,null,"Steel","10\"",null,145.63999999999999]
[]
[]
[null,null,null,null,null,"AVERAGE (Weighted)"]
[null,null,null,null,null,"Type","Size",null,"Labor Rate/Ft"]
[null,null,null,null,null,"Steel","1\"",null,{"$f":"+(I28*5+I41*2.5+I54*2.5)/10","v":38.46}]
[null,null,null,null,null,"Steel","2\"",null,{"$f":"+(I29*5+I42*2.5+I55*2.5)/10","v":38.46}]
[null,null,null,null,null,"Steel","3\"",null,{"$f":"+(I30*5+I43*2.5+I56*2.5)/10","v":47.03}]
[null,null,null,null,null,"Steel","4\"",null,{"$f":"+(I31*5+I44*2.5+I57*2.5)/10","v":47.03}]
[null,null,null,null,null,"Steel","6\"",null,71.509999999999991]
[null,null,null,null,null,"Steel","8\"",null,98.45]
[null,null,null,null,null,"Steel","10\"",null,125.38999999999999]

{"sheet":"Per Ft Cost_RGV","index":10,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Cost of Installed New Mains By Size and Composition"]
["RGVSA Main"]
[null,"Size",null,"Cost of Material",null,null,"Stores Load",null,"Contract Labor",null,"Total Cost/Ft"]
[null,null,null,null,null,null,0.21862499999999999,null,null,null,0.33416666666666667,"COH"]
["Plastic"]
[null,1.25,null,0.81200000000000006,null,null,{"$f":"D6*(1+$G$4)","v":0.98952350000000011},null,{"$f":"D25","v":10.61},null,{"$f":"(I6+G6)*(1+$K$4)","v":15.475697602916668}]
[null,2,null,0.92,null,null,1.1211350000000002,null,{"$f":"D26","v":10.61},null,15.651289279166667]
[null,3,null,2.3199999999999998,null,null,2.82721,null,{"$f":"D27","v":13.09},null,21.236211008333335]
[null,4,null,3.75,null,null,4.5698437500000004,null,{"$f":"D28","v":13.09},null,23.561174869791667]
[null,6,null,7.92,null,null,9.65151,null,{"$f":"D29","v":15.36},null,33.369522925000005]
["Steel"]
[null,1,null,5.0004200084999999,null,null,{"$f":"D12*(1+$G$4)","v":6.093636832858313},null,{"$f":"I25","v":16.510000000000002},null,{"$f":"(I12+G12)*(1+$K$4)","v":30.157018807838469}]
[null,2,null,10.024517577299999,null,null,12.216127732637212,null,16.510000000000002,null,38.325442083293481]
[null,3,null,12.6619081272,null,null,15.430117791509101,null,20.059999999999999,null,47.349732153505059]
[null,4,null,13.35,null,null,16.268643749999999,null,20.059999999999999,null,48.468465536458332]
[null,6,null,21.3815425433,null,null,26.056082281828964,null,25.48,null,68.757723111006811]
[null,8,null,27.6458719008,null,null,33.689950645112404,null,37.39,null,94.832500819020808]
[null,10,null,34.984917470900001,null,null,42.633495052975519,null,44.77,null,116.61082964984486]
[null,12,null,81.812583193400002,null,null,99.698859194057079,null,53.68,null,204.63296130807115]
[]
[]
["2024 Data"]
["Dirt (No Adders) - 100%",null,null,null,null,"Dirt (No Adders) - 100%"]
["Type","Size",null,"Labor Rate/Ft",null,"Type","Size",null,"Labor Rate/Ft"]
["Plastic","1.25\"",null,10.61,null,"Steel","1\"",null,16.510000000000002]
["Plastic","2\"",null,10.61,null,"Steel","2\"",null,16.510000000000002]
["Plastic","3\"",null,13.09,null,"Steel","3\"",null,20.059999999999999]
["Plastic","4\"",null,13.09,null,"Steel","4\"",null,20.059999999999999]
["Plastic","6\"",null,15.36,null,"Steel","6\"",null,25.48]
["Plastic","8\"",null,16.11,null,"Steel","8\"",null,37.39]
[null,null,null,null,null,"Steel","10\"",null,44.77]
[null,null,null,null,null,"Steel","12\"",null,53.68]
[null,null,null,null,null,"Steel","16\"",null,68]