{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inputs","DAV","GD17 Pi's Calc - 40 yrs"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":8,"defined_names":53,"comments":1,"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":"Inputs","index":0,"n_rows":104,"n_cols":44,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,2,0],[80,5,81,5],[80,6,81,6],[31,4,31,8],[60,42,60,43],[67,4,67,43],[80,22,81,22],[80,23,81,23],[80,24,81,24],[80,25,81,25],[80,26,81,26],[80,27,81,27],[80,28,81,28],[80,29,81,29],[80,30,81,30],[80,31,81,31],[80,32,81,32],[80,33,81,33],[77,30,78,30],[77,31,78,31],[77,32,78,32],[77,33,78,33],[80,34,81,34],[80,35,81,35],[80,36,81,36],[80,37,81,37],[80,38,81,38],[77,34,78,34],[77,35,78,35],[77,36,78,36],[77,37,78,37],[77,38,78,38],[80,39,81,39],[80,40,81,40],[80,41,81,41],[80,42,81,42],[80,43,81,43],[77,39,78,39],[77,40,78,40],[77,41,78,41],[77,42,78,42],[77,43,78,43],[85,8,87,8],[85,9,87,9],[85,10,87,10],[85,11,87,11],[85,12,87,12],[85,4,87,4],[88,4,89,4],[85,5,87,5],[85,6,87,6],[85,7,87,7],[85,40,87,40],[85,41,87,41],[85,42,87,42],[85,18,87,18],[85,19,87,19],[85,13,87,13],[85,14,87,14],[85,15,87,15],[85,16,87,16],[85,17,87,17],[85,25,87,25],[85,30,87,30],[85,31,87,31],[85,32,87,32],[85,33,87,33],[85,34,87,34],[85,39,87,39],[88,25,89,25],[88,26,89,26],[88,27,89,27],[88,28,89,28],[88,29,89,29],[85,20,87,20],[85,21,87,21],[85,22,87,22],[85,23,87,23],[85,24,87,24],[88,20,89,20],[88,21,89,21],[88,22,89,22],[88,23,89,23],[88,24,89,24],[85,29,87,29],[88,30,89,30],[88,31,89,31],[88,32,89,32],[88,33,89,33],[88,34,89,34],[85,35,87,35],[85,36,87,36],[85,37,87,37],[85,38,87,38],[88,35,89,35],[88,36,89,36],[88,37,89,37],[88,38,89,38],[88,39,89,39],[80,7,81,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[80,11,81,11],[80,4,81,4],[77,4,78,4],[77,5,78,5],[77,6,78,6],[77,7,78,7],[77,8,78,8],[77,9,78,9],[77,10,78,10],[77,11,78,11],[80,17,81,17],[80,18,81,18],[80,19,81,19],[80,20,81,20],[80,21,81,21],[80,12,81,12],[80,13,81,13],[80,14,81,14],[80,15,81,15],[80,16,81,16],[88,40,89,40],[88,41,89,41],[88,42,89,42],[88,43,89,43],[85,43,87,43],[88,5,89,5],[88,6,89,6],[88,7,89,7],[88,8,89,8],[88,9,89,9],[88,10,89,10],[88,11,89,11],[88,12,89,12],[88,13,89,13],[88,14,89,14],[88,15,89,15],[88,16,89,16],[88,17,89,17],[88,18,89,18],[88,19,89,19],[85,26,87,26],[85,27,87,27],[85,28,87,28],[77,12,78,12],[77,13,78,13],[77,14,78,14],[77,15,78,15],[77,16,78,16],[77,17,78,17],[77,18,78,18],[77,19,78,19],[77,20,78,20],[77,21,78,21],[77,22,78,22],[77,23,78,23],[77,24,78,24],[77,25,78,25],[77,26,78,26],[77,27,78,27],[77,28,78,28],[77,29,78,29]]}
["Inputs","RPI Av 2014",null,256]
[null,"RPI Dec",null,257.5]
[null,"£2014","Source",2017,{"$f":"D3+1","v":2018},{"$f":"E3+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,{"$f":"W3+1","v":2037},{"$f":"X3+1","v":2038},{"$f":"Y3+1","v":2039},{"$f":"Z3+1","v":2040},{"$f":"AA3+1","v":2041},{"$f":"AB3+1","v":2042},{"$f":"AC3+1","v":2043},{"$f":"AD3+1","v":2044},{"$f":"AE3+1","v":2045},{"$f":"AF3+1","v":2046},{"$f":"AG3+1","v":2047},{"$f":"AH3+1","v":2048},{"$f":"AI3+1","v":2049},{"$f":"AJ3+1","v":2050},{"$f":"AK3+1","v":2051},{"$f":"AL3+1","v":2052},{"$f":"AM3+1","v":2053},{"$f":"AN3+1","v":2054},{"$f":"AO3+1","v":2055},{"$f":"AP3+1","v":2056},{"$f":"AQ3+1","v":2057}]
[null,null,null,null,"GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward","GD17 onward"]
[]
["Capex - Subtotals in £2014 Av - GD17 Submission"]
[]
["7 Bar Mains",null,null,"Mains",{"$f":"E20/$D$2*$D$1","v":0},{"$f":"F20/$D$2*$D$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LP, 2Bar or 4Bar Mains",null,null,"Mains",{"$f":"E21/$D$2*$D$1","v":9121256.1332151648},7696483.4730573576,4610084.965380067,4610084.965380067,4610084.965380067,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,161827.79029126215,0,0]
["Pressure Reduction",null,null,"Meters/PRS/Tele",760543.68932038837,824170.87378640776,802299.02912621363,751596.11650485441,700893.20388349518,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,131231.06796116504,120295.14563106796,0,0]
["Domestic Services",null,null,"Services",451084.66923432681,731244.36238802818,1006168.7646207324,1281093.166853436,1416110.1737775197,{"$f":"J23/$D$2*$D$1","v":837198.62351961201},684484.08124808257,698456.20127196726,712428.32129585196,726400.44131973654,740372.56134362053,754344.68136750453,768316.8013913898,782288.92141527392,796261.04143915826,810233.1614630426,824205.28148692648,838177.40151081118,852149.52153469564,866121.64155857975,880093.76158246445,894065.88160634832,908038.0016302329,922010.12165411771,935982.24167800113,949954.36170188501,963926.48172577051,977898.60174965463,991870.72177353944,609158.4607405545,244512.10041797571,244512.10041797589,244512.10041797571,244512.10041797589,244512.10041797571,244512.10041797571,244512.10041797589,244512.10041797589,0,0]
["Domestic Meters",null,null,"Meters/PRS/Tele",95742.650230221436,159618.698454222,220585.99512539798,281553.29179657402,311929.95121164696,69114.170889731511,56506.960754185529,57660.416414400184,58813.87207461481,59967.32773482945,61120.78339504404,62274.239055258629,63427.694715473306,64581.15037568791,65734.606035902543,66888.061696117147,68041.517356331737,69194.973016546384,70348.428676760988,71501.884336975592,72655.339997190269,73808.795657404829,74962.251317619448,76115.70697783411,77269.162638048656,78422.618298263245,79576.073958477922,80729.529618692541,81882.985278907217,50288.522665687626,20185.474053755759,20185.47405375577,20185.474053755759,20185.474053755777,20185.474053755759,20185.474053755755,20185.474053755774,20185.474053755777,0,0]
["I&C Services",null,null,"Services",327752.7977805445,334079.21910493821,99749.654891955244,60250.447072565672,90732.087641216,106880.95994902372,63631.450043277662,67405.51015605437,70849.237156411706,28821.676042985368,28819.828402532261,28819.82840253225,28819.828402532257,28819.828402532272,28819.828402532239,28819.828402532268,28819.828402532246,28819.828402532254,28819.828402532254,28819.828402532254,28819.828402532239,28819.828402532235,28819.828402532268,28819.828402532261,28819.828402532261,28819.828402532254,28819.828402532279,28819.828402532203,28819.828402532268,13869.542418717998,0,0,0,0,0,0,0,0,0,0]
["I&C Meters",null,null,"Meters/PRS/Tele",672517.85326771834,542657.12048107723,78724.213744226596,45836.109971058751,97450.815490866327,295228.54262306791,15886.673000388348,16743.765101359222,15929.661166601962,6490.2055391180265,6490.1105865949303,6490.1105865949239,6490.1105865949312,6490.1105865949357,6490.1105865949212,6490.1105865949303,6490.1105865949339,6490.110586594923,6490.1105865949312,6490.1105865949312,6490.1105865949221,6490.1105865949303,6490.1105865949266,6490.1105865949348,6490.1105865949321,6490.1105865949312,6490.1105865949294,6490.1105865949139,6490.1105865949321,3123.3657197986627,0,0,0,0,0,0,0,{"$f":"AP26/$D$2*$D$1","v":0},0,0]
["Other Capex",null,null,"Other",467552.43495145632,467552.43495145632,467552.43495145632,467552.43495145632,467552.43495145632,472233.00970873784,504185.78640776698,472233.00970873784,484452.41165048542,502227.26213592233,522238.01165048545,541337.10291262134,560437.18834951462,569953.42912621354,552318.75728155335,511586.42330097087,512389.71650485438,513193.00970873784,526215.70485436893,570966.64992570481,629851.29679458623,692615.46276352566,785380.61352796946,804656.89007230732,1495044.3131487623,1223777.1754744654,1270205.0229506206,1251660.3651496596,1256271.3669650606,1266436.7948196717,871366.44363794487,861840.46126174578,884267.25558457535,897110.72908535786,850850.74675376248,845397.9122685981,849528.39860548137,853658.88494236465,0,0]
["TMA",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Capex - Subtotals in DEC £2014  - GD17 Submission"]
[]
["7 Bar Mains",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AP20/SUM($AP$20:$AP$28)*$AQ$29","v":0},{"$f":"AP20/SUM($AP$20:$AP$28)*$AR$29","v":0}]
["LP, 2Bar or 4Bar Mains",null,null,"Mains",9174700.993370723,7741580.0559073035,4637097.1819740906,4637097.1819740906,4637097.1819740906,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,162776,{"$f":"AP21/SUM($AP$20:$AP$28)*$AQ$29","v":0},{"$f":"AP21/SUM($AP$20:$AP$28)*$AR$29","v":0}]
["Pressure Reduction",null,null,"Meters/PRS/Tele",765000,829000,807000,756000,705000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,132000,121000,0,0]
["Domestic Services",null,null,"Services",453727.74346812168,735528.99732389557,1012064.2847259321,1288599.5721279678,1424407.6943269973,842104.08420429728,688494.73016164557,702548.71807629522,716602.70599094487,730656.69390559441,744710.68182024336,758764.6697348922,772818.65764954244,786872.64556419151,800926.63347884081,814980.62139349012,829034.60930813896,843088.59722278861,857142.58513743803,871196.5730520871,885250.56096673675,899304.54888138548,913358.53679603501,927412.52471068478,941466.51262533315,955520.50053998199,969574.48845463246,983628.47636928153,997682.4642839313,612727.74859645613,245944.7885063623,245944.78850636247,245944.7885063623,245944.78850636247,245944.7885063623,245944.7885063623,245944.78850636247,245944.78850636247,0,0]
["Domestic Meters",null,null,"Meters/PRS/Tele",96303.64232141414,160553.9642654772,221878.49119058586,283203.01811569458,313757.66576952772,69519.136734788539,56838.056227354587,57998.270416828309,59158.484606302009,60318.698795775716,61478.912985249379,62639.127174723035,63799.341364196785,64959.555553670456,66119.769743144163,67279.983932617833,68440.198122091489,69600.412311565204,70760.626501038889,71920.840690512559,73081.054879986303,74241.26906945993,75401.483258933629,76561.697448407358,77721.91163788097,78882.125827354626,80042.340016828384,81202.554206302069,82362.768395775813,50583.181978181892,20303.748315789486,20303.748315789497,20303.748315789486,20303.748315789504,20303.748315789486,20303.748315789482,20303.7483157895,20303.748315789504,0,0]
["I&C Services",null,null,"Services",329673.22433003987,336036.71452938119,100334.1255260878,60603.477035881486,91263.720967238754,107507.21557372503,64004.290570874989,67800.464317125006,71264.369405375051,28990.553051049734,28988.694584578348,28988.694584578338,28988.694584578345,28988.694584578359,28988.694584578327,28988.694584578356,28988.694584578334,28988.694584578341,28988.694584578341,28988.694584578341,28988.694584578327,28988.694584578323,28988.694584578356,28988.694584578348,28988.694584578348,28988.694584578341,28988.694584578367,28988.69458457829,28988.694584578356,13950.809268827674,0,0,0,0,0,0,0,0,0,0]
["I&C Meters",null,null,"Meters/PRS/Tele",676458.38756420882,545836.75204639602,79185.488434134168,46104.680927920424,98021.816362883124,296958.39736499998,15979.758974999999,16841.873099999997,16022.999025000019,6528.2340871987963,6528.13857831326,6528.1385783132537,6528.138578313261,6528.1385783132655,6528.1385783132509,6528.13857831326,6528.1385783132637,6528.1385783132528,6528.138578313261,6528.138578313261,6528.1385783132519,6528.13857831326,6528.1385783132564,6528.1385783132646,6528.1385783132619,6528.138578313261,6528.1385783132591,6528.1385783132437,6528.1385783132619,3141.6666908131078,0,0,0,0,0,0,0,0,0,0]
["Other Capex",null,null,"Other",470292,470292,470292,470292,470292,475000,507140,475000,487291,505170,525298,544509,563721,573293,555555,514584,515392,516200,529299,574312.15764011326,633541.83173674205,696673.75649065571,789982.45306035993,809371.67653757473,1503804.3384211184,1230947.7448620112,1277647.6305069719,1258994.3126017083,1263632.3320058715,1273857.3229143182,876472.10639363597,866890.30771445134,889448.50903526624,902367.23726359243,855836.20034802286,850351.41566079692,854506.10406606039,858660.79247132386,0,0]
["TMA","exclude",null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.1]
[null,"include"]
["Capex - Subtotals in Av £2014 - UR Draft Det","exclude"]
[]
["7 Bar Mains",null,null,"Mains",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["LP, 2Bar or 4Bar Mains",null,null,"Mains",7155040.3265250875,6021885.2417754643,3424903.307846976,3432337.301334362,3400900.6701644226,2020649.6756074554,1474792.3029553224,1482611.291612145,1145411.7869239082,1145871.7274331332,1145411.7869239082,306266.9274268428,305806.98691761796,306266.9274268428,305806.98691761796,306266.9274268428,305806.98691761796,305806.98691761796,306266.9274268428,305806.98691761796,306266.9274268428,305806.98691761796,306266.9274268428,305806.98691761796,306266.9274268428,305806.98691761796,306266.9274268428,305806.98691761796,{"$f":"AF34","v":305806.98691761796},{"$f":"AG34","v":305806.98691761796},305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796,305806.98691761796]
["Pressure Reduction",null,null,"Meters/PRS/Tele",86023.095512580461,92471.818436729765,89474.266729406401,83313.648638195111,77224.165082928288,228344.41490497024,27080.830094397279,27080.830094397279,27080.830094397279,27080.830094397279,27080.830094397279,15208.368785784751,15208.368785784751,15208.368785784751,15208.368785784751,15208.368785784751,15208.368785784751,15208.368785784751,15208.368785784751,133722.76517749255,101231.46429836522,107680.18722251451,104682.63551519116,98522.017423979865,92432.533868713042,243552.78369075499,42289.198880182033,42289.198880182033,{"$f":"AF35","v":42289.198880182033},42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033,42289.198880182033]
["Domestic Services",null,null,"Services",1683464.0859222081,1218307.8835097987,862579.6047592361,875627.1025685796,863813.41345539852,787809.96732160239,797058.44199569826,803405.70964526548,802343.28466661018,801941.46502181888,919482.85454234865,919081.03489755723,919482.85454234865,919081.03489755723,919482.85454234865,919813.15720928065,918750.73223062523,919482.85454234865,918348.91258583392,919482.85454234865,725068.6222908654,724738.31962393352,725068.6222908654,724738.31962393352,725068.6222908654,724738.31962393352,724336.4999791421,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352,724738.31962393352]
["Domestic Meters",null,null,"Meters/PRS/Tele",438273.66189075849,352824.88646701089,257885.1822826417,267084.34855789423,261485.06621574736,242444.4631370407,247781.29094194411,251212.10881652488,250830.90683046033,250830.90683046033,281327.06571562268,281327.06571562268,281327.06571562268,281327.06571562268,281327.06571562268,281517.66670865496,281136.4647225904,281327.06571562268,281136.4647225904,281327.06571562268,669091.46445283107,583452.08803605114,488702.98484471423,497711.55012693454,492302.86877781991,473071.66470608098,478408.49251098436,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516,481839.31038556516]
["I&C Services",null,null,"Services",246396.79476792956,331905.47715757077,224408.20498232529,190593.07835969562,210575.69493907702,241894.1808975641,191167.07887144911,169622.30969631262,139300.04196834276,123568.94066586214,107153.87843718674,102024.17149072565,99060.340810548165,95070.56874107843,92106.738060900941,90966.803183909578,89142.907380723438,83329.239508067549,82189.304631076186,81049.369754084852,76375.63675842034,71701.903762755814,68738.073082578296,64064.340086913769,62924.405209922414,61784.470332931072,60644.535455939724,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569,58820.639652753569]
["I&C Meters",null,null,"Meters/PRS/Tele",500632.39864965231,474757.30437487579,224467.45962768752,183269.45515364213,203587.0285972913,236673.00835047179,184573.79860941504,163073.46759707385,133211.33985411032,119234.80791492488,102124.40761086566,96509.672402302516,95094.266908989099,90894.937193739388,89479.531700425956,89288.930707393694,87766.673685615664,82342.539470084797,82151.938477052536,295427.26467588049,586352.14225826424,557316.80245926732,298490.64120037691,251602.54525481857,273946.47878137644,296290.4123079342,244000.60157384523,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283,221275.46606122283]
["Other Capex",null,null,"Other",383397.957589105,380321.63479103107,378025.22180375061,375742.67474500474,373473.9098911882,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951,74722.235351915951]
["TMA",null,null,"Mains",908490.1207215226,757209.86024428345,451189.11175885366,449855.74822626373,447528.97785588988,305035.38238266221,246301.78238224698,245563.93109537233,208705.51135588615,207138.21331208144,217204.85199034438,132737.21338151259,132435.01822705151,132041.85310654787,131739.65795208677,131704.6887820033,131370.06265289668,130861.90809680342,130680.51446437532,130633.92112140513,110771.11864761286,110224.72103043072,110007.36228002865,109460.96466284653,109425.99549276306,109232.97768744826,109124.79628619245,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305,108936.5946194305]
[]
["Capex - Subtotals in Av £2014 - UR Final Det"]
[]
["7 Bar Mains",null,null,"Mains"]
["LP, 2Bar or 4Bar Mains",null,null,"Mains"]
["Pressure Reduction",null,null,"Meters/PRS/Tele"]
["Domestic Services",null,null,"Services"]
["Domestic Meters",null,null,"Meters/PRS/Tele"]
["I&C Services",null,null,"Services"]
["I&C Meters",null,null,"Meters/PRS/Tele"]
["Other Capex",null,null,"Other"]
["TMA",null,null,"Mains"]
[]
["Capex"]
["Total Capex - Av £2014 - SGN GD17 Submission",null,null,null,{"$f":"SUM(E8:E16)","v":11896450.227999819},{"$f":"SUM(F8:F16)","v":10755806.182223488},7285165.0578400502,7497966.5325300125,7694753.6323362673,2073714.1649426003,1617753.8097061282,1605557.7609049459,1635532.3615963929,1616965.7710250188,1652100.1536307044,1686324.820576939,1720550.4816979324,1745192.2981587299,1742683.2019981686,1717076.4437016849,1733005.312589667,1748934.1814776501,1777082.45230738,1836958.9730628147,1910969.1956157954,1988858.9372688332,2096749.6637173763,2131151.5159458136,2836664.5147063667,2580522.952716168,2642076.3758764234,2638657.2937595611,2658393.8712590616,2235935.5446168575,1429122.8763621035,1419596.8939859048,1442023.688308734,1454867.1618095166,1408607.1794779212,1403154.3449927568,1407284.8313296402,1400479.3953364263,0,0]
["Total Capex - DEC £2014",null,null,null,{"$f":"SUM(E20:E28)","v":11966155.991054507},{"$f":"SUM(F20:F28)","v":10818828.484072454},7327851.5718508307,7541899.9301815545,7739840.0794007368,2085864.8338778107,1627232.8359348751,1614965.3259102486,1645115.559027622,1626440.1798396187,1661780.4279683842,1696205.6300725066,1730631.8321766306,1755418.0342807535,1752894.2363848763,1727137.4384889994,1743159.640593122,1759181.8426972453,1787495.0448013684,1847722.4045456043,1922166.2807463564,2000512.4076043926,2109035.3062782199,2143638.7318595583,2853285.5958472239,2595643.2043922395,2657557.2921413239,2654118.1763401832,2673970.3978484701,2249036.7294485969,1437496.6432157878,1427914.8445366034,1450473.0458574181,1463391.7740857443,1416860.7371701747,1411375.9524829488,1415530.6408882122,1408685.329293476,0,0]
["Total Capex - Av £2014 - UR Draft Det",null,null,null,{"$f":"SUM(E33:E41)","v":11401718.441578843},{"$f":"SUM(F33:F41)","v":9629684.1067567654},5912932.3597908774,5857823.3575836373,{"$f":"SUM(I33:I41)","v":5838588.9262019433},4137573.3279536832,3243477.7612023894,3217291.8839090075,2781605.9370456315,2750389.126624594,2874507.9106665896,1927876.689452264,1923137.1372598785,1914612.9912190891,1909873.4390267036,1909488.7781557855,1903904.43172777,1893081.1983882454,1890704.6664454723,2222172.4632563684,2649879.611485118,2535643.2444044873,2176679.4819925134,2126628.9594489606,2137090.0672002193,2289199.8506186171,2039793.2874650448,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216]
["Total Capex - Av £2014 - UR Final Det",null,null,null,{"$f":"SUM(E45:E53)","v":0},{"$f":"SUM(F45:F53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Opex"]
["Total Opex - Av £2014 - SGN GD17 Submission",null,null,null,{"$f":"E63/$D$2*$D$1","v":2554994.6681015985},{"$f":"F63/$D$2*$D$1","v":2801997.7950360379},2330810.6075845533,2486761.4823829066,2795679.4248029618,2890493.2013394102,2895463.0802769209,2895463.0802769209,2895463.0802769209,{"$f":"N63/$D$2*$D$1","v":1801870.8479154143},1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,1780735.3057985057,{"$f":"AQ63/$D$2*$D$1","v":1780735.3057985057},1780735.3057985057]
["Total Opex - DEC £2014",null,null,null,2569965.3399850065,2818415.7508663274,2344467.7009883691,2501332.3504437441,2812060.3589326665,2907429.6849410082,2912428.6842629183,2912428.6842629183,2912428.6842629183,1812428.6849149186,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,1791169.3017309187,{"$f":"AP63","v":1791169.3017309187},{"$f":"AP63","v":1791169.3017309187}]
["Total Opex - Av £2014 - UR Draft Det - Using Bid Opex to 2026 and continue trend from 2027 onwards",null,null,null,2129200.6083845776,1580319.7567613241,1387190.5868976691,1431612.0754367288,1494512.3060298713,1518705.9095927866,1544593.0654051057,1572292.3221242873,1601930.5268138114,1633643.4058316019,1667576.1863806385,1703884.2615681072,1742733.9020186991,1784303.0173008319,1828781.9706527144,1876374.4507392282,1927298.4044317985,1981787.0348828479,2040089.8694654717,2102473.9024688788,2169224.8177825245,2240648.2971681254,2317071.4201107183,2398844.1616592924,2486340.9951162678,2579962.6069152304,2680137.7315401207,2787325.1148887533,2902015.6150717903,3024734.4502676395,3156043.6039271988,3296544.3983429275,3446880.2483677561,3607739.6078943238,3779859.1225877502,3964027.0033097169,4161086.635682221,4371940.4423208013,4597554.0154240821,4838960.5386445923]
["Total Opex - Av £2014 - UR Final Det"]
[]
["Volumes (Therms)"]
["Submission","Categories for modelling purposes"]
["Domestic","P1",null,null,193129.36776132154,469967.55382599519,874426.81243931525,1403599.7124914133,1998914.1699186317,2486887.6762186475,2741882.1972408276,3002121.9780524811,3267607.0186536084,3538337.31904421,3814312.8792242846,4095533.699193832,4381999.7789528547,4673711.1185013512,4970667.7178393202,5272869.5769667635,5580316.6958836811,5893009.0745900711,6210946.7130859364,6534129.6113712741,6862557.7694460861,7196231.1873103715,7535149.8649641294,7879313.8024073634,8228722.999640069,8583377.4566622507,8943277.1734739058,9308422.1500750314,9678812.3864656333,10013117.684907874,10104909.731223665,10196701.777539454,10288493.823855244,10380285.870171033,10472077.916486822,10563869.962802611,10655662.009118401,10747454.05543419,10839246.101749981,10873668.119118402]
["Small I&C (Tarriff)","P2",null,null,5560.5437888172646,14054.624297926006,26730.861107623314,44489.219373598651,64712.512422281405,90043.527289377816,115022.48251751684,142240.35276723659,172171.66377928818,192015.2602476688,204694.76567054418,217374.27109341952,230053.77651629495,242733.28193917029,255412.78736204567,268092.29278492107,280771.79820779641,293451.30363067181,306130.80905354716,318810.3144764225,331489.8198992979,344169.32532217324,356848.83074504859,369528.33616792399,382207.84159079939,394887.34701367479,407566.85243655014,420246.35785942548,432925.86328230088,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772,443782.68980063772]
["Medium I&C (Tarriff)","P3",null,null,38297.931027131373,117303.91269274062,187178.51932706276,240284.77477685962,300430.55252031574,377501.32591068186,453552.5108941521,536325.39385284891,627178.03633548482,688117.23275576346,727847.13414429466,767608.95913561154,807403.23836747627,847230.51129797217,887091.32635211642,926986.24107090908,966915.82226286014,1004725.1735364315,1042534.5248100028,1080343.8760835738,1118153.2273571449,1155962.5786307163,1193771.9299042874,1231581.2811778588,1269390.63245143,1307199.9837250011,1345009.3349985722,1382818.6862721434,1420628.0375457145,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1453002.2945737094,1452998.9287386574]
["Large I&C (Tarriff)","P4",null,null,208000,786000,1384000,1548000,1548000,1638794.8476272258,1707375.9031638349,1773581.2933786572,1820152.5983973157,1850407.3822263214,1881165.0645185353,1912434.0045095002,1944222.7003829244,1976539.7915802915,2009394.0611488642,2042794.4381287275,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755,2076749.9999794755]
["Contract I&C (Contract)","P5",null,null,6683200,9945836.8000000007,11620236.800000001,11620236.800000001,11785836.800000001,15417925.066870585,15674203.573629141,15934741.970920404,16199611.067130068,16468882.847628877,16742630.494336609,17020928.405611232,17303852.216468729,17591478.819138907,17883886.383962978,18181154.380638484,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321,18483363.599817321]
["Super Contract I&C (Contract)","P6",null,null,10560000,10560000,10560000,10560000,10560000,10735529.522917811,10913976.717560599,11095390.081800135,11279818.919645341,11467313.354641993,11657924.343495149,11851703.68991803,12048704.058711076,12248978.990075039,12452582.914161986,12659571.165868172,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804,12869999.999872804]
["Total Volume (Therms) - SGN GD17 Submission",null,null,null,{"$f":"SUM(E69:E74)","v":17688187.842577271},{"$f":"SUM(F69:F74)","v":21893162.890816662},24652572.992874004,25416610.506641872,26257894.034861229,30746681.966834329,31606013.38500607,32484401.070771761,33366539.303941108,34205073.396544829,35028574.681389421,35865583.029461622,36716235.769399352,37580672.512532733,38459035.19082731,39351468.095457979,40258117.91602394,40621299.151426777,40989725.646619081,41363397.401600868,41742314.416372128,42126476.690932862,42515884.225283064,42910537.019422747,43310435.073351897,43715578.387070529,44125966.960578628,44541600.793876201,44962479.886963248,45340016.268951818,45431808.315267608,45523600.361583397,45615392.407899186,45707184.454214975,45798976.500530764,45890768.546846554,45982560.593162343,46074352.639478132,46166144.685793929,46200563.337327294]
["GD17 DD - using Bid Volumes"]
["Domestic","P1",null,null,895511.89743589726,1622047.3600207774,2155910.3174451231,2713072.7660401613,3261142.7302759048,3744677.9326044568,4238718.8403019812,4739018.3106679833,5239317.7810339853,5739617.2513999883,6300473.5217659902,6861329.792131993,7422186.0624979958,7983042.3328639977,8543898.6032299995,9104754.8735960014,9665611.1439620052,10226467.414328009,10787323.684694009,11348179.955060013,11808108.225426015,12268036.495792016,12727964.766158018,13187893.036524022,13647821.306890026,14107749.577256028,14567677.847622031,15027606.117988031,15487534.388354037,15947462.658720035,16100015.993188603,16252569.327657171,16405122.662125736,16557675.996594302,16710229.331062868,16862782.665531434,17015336,17015336,17015336,{"$f":"AQ77","v":17015336}]
["Small I&C (Tarriff)","P2",null,null,2058.3993326874997,39324.696581062497,125797.58487737497,204435.79983999991,272559.28414112492,351721.6212384458,451281.75693528325,551932.64200943639,660840.01833851647,779471.86356695683,871992.1933491776,924404.73761649895,976848.94298725657,1029325.6025985616,1081835.2559084978,1134378.4513420828,1186955.7464403159,1239567.7080117087,1290059.4396647213,1340551.1713177341,1391042.9029707469,1441534.6346237597,1492026.366276772,1542518.0979297848,1593009.8295827974,1643501.5612358106,1693993.2928888234,1744485.0245418369,1794976.7561948502,1845468.4878478632,1891985.2801061159,1896885.6078541481,1896885.6078541481,1896885.6078541481,1896885.6078541481,1896885.6078541481,1896885.6078541481,1896885.6078541481,1896885.6078541481,{"$f":"AQ78","v":1896885.6078541481}]
["Medium I&C (Tarriff)","P3"]
["Large I&C (Tarriff)","P4",null,null,953200,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400,1906400]
["Contract I&C (Contract)","P5",null,null,23022387.334470216,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,30696500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500,16836500]
["Super Contract I&C (Contract)","P6"]
["Total Volume (Therms) - UR Draft Det",null,null,null,{"$f":"SUM(E77:E82)","v":24873157.6312388},{"$f":"SUM(F77:F82)","v":34264272.056601837},34884607.902322501,35520408.565880165,36136602.01441703,36699299.553842902,37292900.597237267,37893850.952677421,38503057.799372502,39121989.114966944,39775365.715115167,40388634.529748492,41001935.005485252,41615267.935462557,42228633.859138496,42842033.324938089,43455466.890402317,44068935.122339718,30820283.124358729,31431631.126377746,31942051.128396761,32452471.130415775,32962891.132434793,33473311.134453807,33983731.136472821,34494151.138491839,35004571.140510857,35514991.142529868,36025411.144548886,36535831.146567896,36734901.273294717,36892354.935511321,37044908.269979879,37197461.604448453,37350014.938917011,37502568.273385584,37655121.607854143,37655121.607854143,37655121.607854143,37655121.607854143]
["GD17 FD"]
["Domestic","P1"]
["Small I&C (Tarriff)","P2"]
["Medium I&C (Tarriff)","P3"]
["Large I&C (Tarriff)","P4"]
["Contract I&C (Contract)","P5"]
["Super Contract I&C (Contract)","P6"]
["Total Volume (Therms) - UR Final Det",null,null,null,{"$f":"SUM(E85:E90)","v":0},{"$f":"SUM(F85:F90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Opening Asset Value (£2014)","Capex","PI's model V7",6828297.8813500181]
[null,"Opex","PI's model V7",1389157.8669656203]
[null,"Revenue",null,960907.80834855046]
[null,"Total OAV",null,{"$f":"D94+D95-D96","v":7256547.9399670875}]
[]
[]
["INPUTS BASIS"]
["SELECT BASIS OF MODELLING INPUTS","UR Draft Det"]
[null,"FE GD17 Submission"]
[null,"UR Draft Det"]
[null,"UR Final Det"]

{"sheet":"DAV","index":1,"n_rows":34,"n_cols":44,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,2,1]]}
["Condition 2.3.17 Calculation of DAV"]
[]
[]
[]
[]
[null,null,null,"Av £2014",2018,{"$f":"E6+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,{"$f":"AF6+1","v":2046},{"$f":"AG6+1","v":2047},{"$f":"AH6+1","v":2048},{"$f":"AI6+1","v":2049},{"$f":"AJ6+1","v":2050},{"$f":"AK6+1","v":2051},{"$f":"AL6+1","v":2052},{"$f":"AM6+1","v":2053},{"$f":"AN6+1","v":2054},{"$f":"AO6+1","v":2055},{"$f":"AP6+1","v":2056},{"$f":"AQ6+1","v":2057}]
[]
["Annual Capex "]
["Mains",null,null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!E8:E9,Inputs!E16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!E33:E34,Inputs!E41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!E45:E46,Inputs!E53),0)))","v":8063530.4472466102},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!F8:F9,Inputs!F16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!F33:F34,Inputs!F41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!F45:F46,Inputs!F53),0)))","v":6779095.1020197477},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!G8:G9,Inputs!G16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!G33:G34,Inputs!G41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!G45:G46,Inputs!G53),0)))","v":3876092.4196058298},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!H8:H9,Inputs!H16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!H33:H34,Inputs!H41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!H45:H46,Inputs!H53),0)))","v":3882193.0495606256},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!I8:I9,Inputs!I16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!I33:I34,Inputs!I41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!I45:I46,Inputs!I53),0)))","v":3848429.6480203127},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!J8:J9,Inputs!J16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!J33:J34,Inputs!J41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!J45:J46,Inputs!J53),0)))","v":2325685.0579901175},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!K8:K9,Inputs!K16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!K33:K34,Inputs!K41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!K45:K46,Inputs!K53),0)))","v":1721094.0853375695},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!L8:L9,Inputs!L16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!L33:L34,Inputs!L41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!L45:L46,Inputs!L53),0)))","v":1728175.2227075174},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!M8:M9,Inputs!M16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!M33:M34,Inputs!M41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!M45:M46,Inputs!M53),0)))","v":1354117.2982797944},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!N8:N9,Inputs!N16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!N33:N34,Inputs!N41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!N45:N46,Inputs!N53),0)))","v":1353009.9407452147},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!O8:O9,Inputs!O16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!O33:O34,Inputs!O41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!O45:O46,Inputs!O53),0)))","v":1362616.6389142526},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!P8:P9,Inputs!P16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!P33:P34,Inputs!P41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!P45:P46,Inputs!P53),0)))","v":439004.14080835541},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Q8:Q9,Inputs!Q16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Q33:Q34,Inputs!Q41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Q45:Q46,Inputs!Q53),0)))","v":438242.00514466944},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!R8:R9,Inputs!R16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!R33:R34,Inputs!R41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!R45:R46,Inputs!R53),0)))","v":438308.7805333907},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!S8:S9,Inputs!S16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!S33:S34,Inputs!S41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!S45:S46,Inputs!S53),0)))","v":437546.64486970473},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!T8:T9,Inputs!T16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!T33:T34,Inputs!T41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!T45:T46,Inputs!T53),0)))","v":437971.6162088461},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!U8:U9,Inputs!U16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!U33:U34,Inputs!U41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!U45:U46,Inputs!U53),0)))","v":437177.04957051465},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!V8:V9,Inputs!V16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!V33:V34,Inputs!V41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!V45:V46,Inputs!V53),0)))","v":436668.89501442137},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!W8:W9,Inputs!W16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!W33:W34,Inputs!W41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!W45:W46,Inputs!W53),0)))","v":436947.44189121813},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!X8:X9,Inputs!X16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!X33:X34,Inputs!X41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!X45:X46,Inputs!X53),0)))","v":436440.90803902311},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Y8:Y9,Inputs!Y16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Y33:Y34,Inputs!Y41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Y45:Y46,Inputs!Y53),0)))","v":417038.04607445566},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Z8:Z9,Inputs!Z16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Z33:Z34,Inputs!Z41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Z45:Z46,Inputs!Z53),0)))","v":416031.70794804872},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AA8:AA9,Inputs!AA16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AA33:AA34,Inputs!AA41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AA45:AA46,Inputs!AA53),0)))","v":416274.28970687144},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AB8:AB9,Inputs!AB16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AB33:AB34,Inputs!AB41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AB45:AB46,Inputs!AB53),0)))","v":415267.95158046449},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AC8:AC9,Inputs!AC16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AC33:AC34,Inputs!AC41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AC45:AC46,Inputs!AC53),0)))","v":415692.92291960586},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AD8:AD9,Inputs!AD16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AD33:AD34,Inputs!AD41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AD45:AD46,Inputs!AD53),0)))","v":415039.96460506623},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AE8:AE9,Inputs!AE16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AE33:AE34,Inputs!AE41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AE45:AE46,Inputs!AE53),0)))","v":415391.72371303523},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AF8:AF9,Inputs!AF16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AF33:AF34,Inputs!AF41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AF45:AF46,Inputs!AF53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AG8:AG9,Inputs!AG16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AG33:AG34,Inputs!AG41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AG45:AG46,Inputs!AG53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AH8:AH9,Inputs!AH16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AH33:AH34,Inputs!AH41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AH45:AH46,Inputs!AH53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AI8:AI9,Inputs!AI16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AI33:AI34,Inputs!AI41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AI45:AI46,Inputs!AI53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AJ8:AJ9,Inputs!AJ16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AJ33:AJ34,Inputs!AJ41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AJ45:AJ46,Inputs!AJ53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AK8:AK9,Inputs!AK16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AK33:AK34,Inputs!AK41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AK45:AK46,Inputs!AK53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AL8:AL9,Inputs!AL16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AL33:AL34,Inputs!AL41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AL45:AL46,Inputs!AL53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AM8:AM9,Inputs!AM16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AM33:AM34,Inputs!AM41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AM45:AM46,Inputs!AM53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AN8:AN9,Inputs!AN16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AN33:AN34,Inputs!AN41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AN45:AN46,Inputs!AN53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AO8:AO9,Inputs!AO16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AO33:AO34,Inputs!AO41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AO45:AO46,Inputs!AO53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AP8:AP9,Inputs!AP16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AP33:AP34,Inputs!AP41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AP45:AP46,Inputs!AP53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AQ8:AQ9,Inputs!AQ16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AQ33:AQ34,Inputs!AQ41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AQ45:AQ46,Inputs!AQ53),0)))","v":414743.58153704845},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AR8:AR9,Inputs!AR16),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AR33:AR34,Inputs!AR41),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AR45:AR46,Inputs!AR53),0)))","v":414743.58153704845}]
["Services",null,null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!E11,Inputs!E13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!E36,Inputs!E38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!E48,Inputs!E50),0)))","v":1929860.8806901376},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!F11,Inputs!F13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!F36,Inputs!F38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!F48,Inputs!F50),0)))","v":1550213.3606673693},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!G11,Inputs!G13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!G36,Inputs!G38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!G48,Inputs!G50),0)))","v":1086987.8097415613},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!H11,Inputs!H13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!H36,Inputs!H38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!H48,Inputs!H50),0)))","v":1066220.1809282752},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!I11,Inputs!I13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!I36,Inputs!I38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!I48,Inputs!I50),0)))","v":1074389.1083944757},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!J11,Inputs!J13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!J36,Inputs!J38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!J48,Inputs!J50),0)))","v":1029704.1482191666},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!K11,Inputs!K13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!K36,Inputs!K38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!K48,Inputs!K50),0)))","v":988225.52086714737},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!L11,Inputs!L13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!L36,Inputs!L38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!L48,Inputs!L50),0)))","v":973028.01934157813},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!M11,Inputs!M13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!M36,Inputs!M38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!M48,Inputs!M50),0)))","v":941643.32663495291},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!N11,Inputs!N13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!N36,Inputs!N38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!N48,Inputs!N50),0)))","v":925510.40568768105},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!O11,Inputs!O13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!O36,Inputs!O38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!O48,Inputs!O50),0)))","v":1026636.7329795354},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!P11,Inputs!P13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!P36,Inputs!P38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!P48,Inputs!P50),0)))","v":1021105.2063882828},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Q11,Inputs!Q13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Q36,Inputs!Q38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Q48,Inputs!Q50),0)))","v":1018543.1953528968},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!R11,Inputs!R13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!R36,Inputs!R38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!R48,Inputs!R50),0)))","v":1014151.6036386357},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!S11,Inputs!S13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!S36,Inputs!S38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!S48,Inputs!S50),0)))","v":1011589.5926032496},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!T11,Inputs!T13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!T36,Inputs!T38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!T48,Inputs!T50),0)))","v":1010779.9603931903},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!U11,Inputs!U13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!U36,Inputs!U38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!U48,Inputs!U50),0)))","v":1007893.6396113486},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!V11,Inputs!V13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!V36,Inputs!V38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!V48,Inputs!V50),0)))","v":1002812.0940504163},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!W11,Inputs!W13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!W36,Inputs!W38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!W48,Inputs!W50),0)))","v":1000538.2172169101},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!X11,Inputs!X13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!X36,Inputs!X38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!X48,Inputs!X50),0)))","v":1000532.2242964335},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Y11,Inputs!Y13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Y36,Inputs!Y38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Y48,Inputs!Y50),0)))","v":801444.25904928579},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Z11,Inputs!Z13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Z36,Inputs!Z38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Z48,Inputs!Z50),0)))","v":796440.22338668932},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AA11,Inputs!AA13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AA36,Inputs!AA38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AA48,Inputs!AA50),0)))","v":793806.69537344365},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AB11,Inputs!AB13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AB36,Inputs!AB38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AB48,Inputs!AB50),0)))","v":788802.65971084731},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AC11,Inputs!AC13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AC36,Inputs!AC38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AC48,Inputs!AC50),0)))","v":787993.02750078787},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AD11,Inputs!AD13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AD36,Inputs!AD38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AD48,Inputs!AD50),0)))","v":786522.78995686455},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AE11,Inputs!AE13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AE36,Inputs!AE38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AE48,Inputs!AE50),0)))","v":784981.03543508181},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AF11,Inputs!AF13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AF36,Inputs!AF38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AF48,Inputs!AF50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AG11,Inputs!AG13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AG36,Inputs!AG38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AG48,Inputs!AG50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AH11,Inputs!AH13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AH36,Inputs!AH38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AH48,Inputs!AH50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AI11,Inputs!AI13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AI36,Inputs!AI38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AI48,Inputs!AI50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AJ11,Inputs!AJ13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AJ36,Inputs!AJ38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AJ48,Inputs!AJ50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AK11,Inputs!AK13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AK36,Inputs!AK38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AK48,Inputs!AK50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AL11,Inputs!AL13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AL36,Inputs!AL38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AL48,Inputs!AL50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AM11,Inputs!AM13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AM36,Inputs!AM38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AM48,Inputs!AM50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AN11,Inputs!AN13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AN36,Inputs!AN38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AN48,Inputs!AN50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AO11,Inputs!AO13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AO36,Inputs!AO38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AO48,Inputs!AO50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AP11,Inputs!AP13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AP36,Inputs!AP38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AP48,Inputs!AP50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AQ11,Inputs!AQ13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AQ36,Inputs!AQ38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AQ48,Inputs!AQ50),0)))","v":783558.95927668712},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AR11,Inputs!AR13),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AR36,Inputs!AR38),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AR48,Inputs!AR50),0)))","v":783558.95927668712}]
["Meters, PRS, Telemetry",null,null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!E10,Inputs!E12,Inputs!E14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!E35,Inputs!E37,Inputs!E39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!E47,Inputs!E49,Inputs!E51),0)))","v":1024929.1560529913},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!F10,Inputs!F12,Inputs!F14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!F35,Inputs!F37,Inputs!F39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!F47,Inputs!F49,Inputs!F51),0)))","v":920054.0092786164},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!G10,Inputs!G12,Inputs!G14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!G35,Inputs!G37,Inputs!G39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!G47,Inputs!G49,Inputs!G51),0)))","v":571826.90863973554},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!H10,Inputs!H12,Inputs!H14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!H35,Inputs!H37,Inputs!H39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!H47,Inputs!H49,Inputs!H51),0)))","v":533667.45234973147},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!I10,Inputs!I12,Inputs!I14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!I35,Inputs!I37,Inputs!I39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!I47,Inputs!I49,Inputs!I51),0)))","v":542296.25989596697},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!J10,Inputs!J12,Inputs!J14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!J35,Inputs!J37,Inputs!J39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!J47,Inputs!J49,Inputs!J51),0)))","v":707461.88639248279},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!K10,Inputs!K12,Inputs!K14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!K35,Inputs!K37,Inputs!K39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!K47,Inputs!K49,Inputs!K51),0)))","v":459435.91964575648},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!L10,Inputs!L12,Inputs!L14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!L35,Inputs!L37,Inputs!L39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!L47,Inputs!L49,Inputs!L51),0)))","v":441366.40650799603},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!M10,Inputs!M12,Inputs!M14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!M35,Inputs!M37,Inputs!M39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!M47,Inputs!M49,Inputs!M51),0)))","v":411123.07677896792},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!N10,Inputs!N12,Inputs!N14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!N35,Inputs!N37,Inputs!N39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!N47,Inputs!N49,Inputs!N51),0)))","v":397146.54483978247},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!O10,Inputs!O12,Inputs!O14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!O35,Inputs!O37,Inputs!O39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!O47,Inputs!O49,Inputs!O51),0)))","v":410532.30342088564},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!P10,Inputs!P12,Inputs!P14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!P35,Inputs!P37,Inputs!P39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!P47,Inputs!P49,Inputs!P51),0)))","v":393045.10690370994},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Q10,Inputs!Q12,Inputs!Q14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Q35,Inputs!Q37,Inputs!Q39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Q47,Inputs!Q49,Inputs!Q51),0)))","v":391629.70141039655},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!R10,Inputs!R12,Inputs!R14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!R35,Inputs!R37,Inputs!R39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!R47,Inputs!R49,Inputs!R51),0)))","v":387430.37169514684},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!S10,Inputs!S12,Inputs!S14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!S35,Inputs!S37,Inputs!S39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!S47,Inputs!S49,Inputs!S51),0)))","v":386014.96620183339},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!T10,Inputs!T12,Inputs!T14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!T35,Inputs!T37,Inputs!T39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!T47,Inputs!T49,Inputs!T51),0)))","v":386014.96620183339},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!U10,Inputs!U12,Inputs!U14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!U35,Inputs!U37,Inputs!U39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!U47,Inputs!U49,Inputs!U51),0)))","v":384111.50719399081},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!V10,Inputs!V12,Inputs!V14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!V35,Inputs!V37,Inputs!V39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!V47,Inputs!V49,Inputs!V51),0)))","v":378877.97397149226},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!W10,Inputs!W12,Inputs!W14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!W35,Inputs!W37,Inputs!W39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!W47,Inputs!W49,Inputs!W51),0)))","v":378496.77198542771},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!X10,Inputs!X12,Inputs!X14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!X35,Inputs!X37,Inputs!X39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!X47,Inputs!X49,Inputs!X51),0)))","v":710477.09556899569},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Y10,Inputs!Y12,Inputs!Y14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Y35,Inputs!Y37,Inputs!Y39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Y47,Inputs!Y49,Inputs!Y51),0)))","v":1356675.0710094604},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Z10,Inputs!Z12,Inputs!Z14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Z35,Inputs!Z37,Inputs!Z39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!Z47,Inputs!Z49,Inputs!Z51),0)))","v":1248449.077717833},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AA10,Inputs!AA12,Inputs!AA14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AA35,Inputs!AA37,Inputs!AA39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AA47,Inputs!AA49,Inputs!AA51),0)))","v":891876.26156028232},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AB10,Inputs!AB12,Inputs!AB14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AB35,Inputs!AB37,Inputs!AB39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AB47,Inputs!AB49,Inputs!AB51),0)))","v":847836.11280573299},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AC10,Inputs!AC12,Inputs!AC14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AC35,Inputs!AC37,Inputs!AC39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AC47,Inputs!AC49,Inputs!AC51),0)))","v":858681.88142790948},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AD10,Inputs!AD12,Inputs!AD14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AD35,Inputs!AD37,Inputs!AD39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AD47,Inputs!AD49,Inputs!AD51),0)))","v":1012914.8607047701},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AE10,Inputs!AE12,Inputs!AE14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AE35,Inputs!AE37,Inputs!AE39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AE47,Inputs!AE49,Inputs!AE51),0)))","v":764698.29296501167},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AF10,Inputs!AF12,Inputs!AF14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AF35,Inputs!AF37,Inputs!AF39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AF47,Inputs!AF49,Inputs!AF51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AG10,Inputs!AG12,Inputs!AG14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AG35,Inputs!AG37,Inputs!AG39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AG47,Inputs!AG49,Inputs!AG51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AH10,Inputs!AH12,Inputs!AH14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AH35,Inputs!AH37,Inputs!AH39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AH47,Inputs!AH49,Inputs!AH51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AI10,Inputs!AI12,Inputs!AI14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AI35,Inputs!AI37,Inputs!AI39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AI47,Inputs!AI49,Inputs!AI51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AJ10,Inputs!AJ12,Inputs!AJ14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AJ35,Inputs!AJ37,Inputs!AJ39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AJ47,Inputs!AJ49,Inputs!AJ51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AK10,Inputs!AK12,Inputs!AK14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AK35,Inputs!AK37,Inputs!AK39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AK47,Inputs!AK49,Inputs!AK51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AL10,Inputs!AL12,Inputs!AL14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AL35,Inputs!AL37,Inputs!AL39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AL47,Inputs!AL49,Inputs!AL51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AM10,Inputs!AM12,Inputs!AM14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AM35,Inputs!AM37,Inputs!AM39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AM47,Inputs!AM49,Inputs!AM51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AN10,Inputs!AN12,Inputs!AN14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AN35,Inputs!AN37,Inputs!AN39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AN47,Inputs!AN49,Inputs!AN51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AO10,Inputs!AO12,Inputs!AO14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AO35,Inputs!AO37,Inputs!AO39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AO47,Inputs!AO49,Inputs!AO51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AP10,Inputs!AP12,Inputs!AP14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AP35,Inputs!AP37,Inputs!AP39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AP47,Inputs!AP49,Inputs!AP51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AQ10,Inputs!AQ12,Inputs!AQ14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AQ35,Inputs!AQ37,Inputs!AQ39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AQ47,Inputs!AQ49,Inputs!AQ51),0)))","v":745403.97532696999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AR10,Inputs!AR12,Inputs!AR14),IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AR35,Inputs!AR37,Inputs!AR39),IF(Inputs!$B$101=Inputs!$B$104,SUM(Inputs!AR47,Inputs!AR49,Inputs!AR51),0)))","v":745403.97532696999}]
["Other Capex",null,null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!E15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!E40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!E52,0)))","v":383397.957589105},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!F15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!F40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!F52,0)))","v":380321.63479103107},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!G15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!G40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!G52,0)))","v":378025.22180375061},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!H15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!H40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!H52,0)))","v":375742.67474500474},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!I15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!I40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!I52,0)))","v":373473.9098911882},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!J15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!J40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!J52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!K15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!K40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!K52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!L15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!L40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!L52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!M15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!M40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!M52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!N15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!N40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!N52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!O15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!O40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!O52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!P15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!P40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!P52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Q15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Q40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Q52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!R15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!R40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!R52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!S15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!S40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!S52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!T15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!T40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!T52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!U15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!U40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!U52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!V15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!V40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!V52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!W15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!W40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!W52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!X15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!X40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!X52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Y15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Y40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Y52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Z15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Z40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Z52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AA15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AA40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AA52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AB15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AB40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AB52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AC15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AC40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AC52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AD15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AD40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AD52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AE15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AE40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AE52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AF15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AF40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AF52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AG15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AG40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AG52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AH15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AH40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AH52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AI15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AI40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AI52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AJ15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AJ40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AJ52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AK15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AK40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AK52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AL15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AL40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AL52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AM15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AM40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AM52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AN15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AN40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AN52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AO15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AO40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AO52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AP15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AP40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AP52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AQ15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AQ40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AQ52,0)))","v":74722.235351915951},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AR15,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AR40,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AR52,0)))","v":74722.235351915951}]
["Total capex",null,null,null,{"$f":"SUM(E9:E12)","v":11401718.441578845},{"$f":"SUM(F9:F12)","v":9629684.1067567654},5912932.3597908774,5857823.3575836373,5838588.9262019433,4137573.3279536827,3243477.7612023894,3217291.8839090075,2781605.937045631,2750389.1266245944,2874507.9106665892,1927876.689452264,1923137.1372598787,1914612.9912190894,1909873.4390267036,1909488.7781557858,1903904.43172777,1893081.1983882459,1890704.6664454718,2222172.4632563679,2649879.6114851176,2535643.2444044868,2176679.4819925134,2126628.9594489606,2137090.0672002193,2289199.8506186171,2039793.2874650448,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216]
[]
[]
[]
["Opening DAV (Capex Only)",null,"Capex",{"$f":"Inputs!D94","v":6828297.8813500181}]
[null,null,null,{"$f":"SUM(D16:D17)","v":6828297.8813500181}]
[]
["Basis of Depreciation",null,"FE"]
[]
["Depreciation",null,"Useful Life"]
["Opening DAV",null,{"$f":"IF($C$20=$B$20,35,40)","v":40},null,{"$f":"IF($C$20=$B$20,$D$18/$C$23,$D$18/$C$23)","v":170707.44703375045},{"$f":"IF($C$20=$B$20,$D$18/$C$23,$D$18/$C$23)","v":170707.44703375045},170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,170707.44703375045,{"$f":"IF($C$20=$B$20,0,$D$18/$C$23)","v":170707.44703375045},{"$f":"IF($C$20=$B$20,0,$D$18/$C$23)","v":170707.44703375045},170707.44703375045,170707.44703375045,170707.44703375045]
["Mains",null,{"$f":"IF($C$20=$B$20,35,40)","v":40},null,{"$f":"IF($C$20=$B$20,SUM($E$9:E9)/$C$24,SUM($E$9:E9)/$C$24)","v":201588.26118116526},{"$f":"IF($C$20=$B$20,SUM($E$9:F9)/$C$24,SUM($E$9:F9)/$C$24)","v":371065.63873165892},{"$f":"IF($C$20=$B$20,SUM($E$9:G9)/$C$24,SUM($E$9:G9)/$C$24)","v":467967.94922180462},{"$f":"IF($C$20=$B$20,SUM($E$9:H9)/$C$24,SUM($E$9:H9)/$C$24)","v":565022.7754608203},{"$f":"IF($C$20=$B$20,SUM($E$9:I9)/$C$24,SUM($E$9:I9)/$C$24)","v":661233.51666132803},{"$f":"IF($C$20=$B$20,SUM($E$9:J9)/$C$24,SUM($E$9:J9)/$C$24)","v":719375.6431110811},{"$f":"IF($C$20=$B$20,SUM($E$9:K9)/$C$24,SUM($E$9:K9)/$C$24)","v":762402.99524452025},{"$f":"IF($C$20=$B$20,SUM($E$9:L9)/$C$24,SUM($E$9:L9)/$C$24)","v":805607.37581220816},{"$f":"IF($C$20=$B$20,SUM($E$9:M9)/$C$24,SUM($E$9:M9)/$C$24)","v":839460.30826920306},{"$f":"IF($C$20=$B$20,SUM($E$9:N9)/$C$24,SUM($E$9:N9)/$C$24)","v":873285.55678783334},{"$f":"IF($C$20=$B$20,SUM($E$9:O9)/$C$24,SUM($E$9:O9)/$C$24)","v":907350.97276068968},{"$f":"IF($C$20=$B$20,SUM($E$9:P9)/$C$24,SUM($E$9:P9)/$C$24)","v":918326.07628089865},{"$f":"IF($C$20=$B$20,SUM($E$9:Q9)/$C$24,SUM($E$9:Q9)/$C$24)","v":929282.12640951539},{"$f":"IF($C$20=$B$20,SUM($E$9:R9)/$C$24,SUM($E$9:R9)/$C$24)","v":940239.84592285007},{"$f":"IF($C$20=$B$20,SUM($E$9:S9)/$C$24,SUM($E$9:S9)/$C$24)","v":951178.51204459276},{"$f":"IF($C$20=$B$20,SUM($E$9:T9)/$C$24,SUM($E$9:T9)/$C$24)","v":962127.80244981381},{"$f":"IF($C$20=$B$20,SUM($E$9:U9)/$C$24,SUM($E$9:U9)/$C$24)","v":973057.22868907673},{"$f":"IF($C$20=$B$20,SUM($E$9:V9)/$C$24,SUM($E$9:V9)/$C$24)","v":983973.95106443728},{"$f":"IF($C$20=$B$20,SUM($E$9:W9)/$C$24,SUM($E$9:W9)/$C$24)","v":994897.6371117176},{"$f":"IF($C$20=$B$20,SUM($E$9:X9)/$C$24,SUM($E$9:X9)/$C$24)","v":1005808.6598126933},{"$f":"IF($C$20=$B$20,SUM($E$9:Y9)/$C$24,SUM($E$9:Y9)/$C$24)","v":1016234.6109645547},{"$f":"IF($C$20=$B$20,SUM($E$9:Z9)/$C$24,SUM($E$9:Z9)/$C$24)","v":1026635.403663256},{"$f":"IF($C$20=$B$20,SUM($E$9:AA9)/$C$24,SUM($E$9:AA9)/$C$24)","v":1037042.2609059277},{"$f":"IF($C$20=$B$20,SUM($E$9:AB9)/$C$24,SUM($E$9:AB9)/$C$24)","v":1047423.9596954394},{"$f":"IF($C$20=$B$20,SUM($E$9:AC9)/$C$24,SUM($E$9:AC9)/$C$24)","v":1057816.2827684297},{"$f":"IF($C$20=$B$20,SUM($E$9:AD9)/$C$24,SUM($E$9:AD9)/$C$24)","v":1068192.2818835562},{"$f":"IF($C$20=$B$20,SUM($E$9:AE9)/$C$24,SUM($E$9:AE9)/$C$24)","v":1078577.0749763821},{"$f":"IF($C$20=$B$20,SUM($E$9:AF9)/$C$24,SUM($E$9:AF9)/$C$24)","v":1088945.6645148082},{"$f":"IF($C$20=$B$20,SUM($E$9:AG9)/$C$24,SUM($E$9:AG9)/$C$24)","v":1099314.2540532344},{"$f":"IF($C$20=$B$20,SUM($E$9:AH9)/$C$24,SUM($E$9:AH9)/$C$24)","v":1109682.8435916605},{"$f":"IF($C$20=$B$20,SUM($E$9:AI9)/$C$24,SUM($E$9:AI9)/$C$24)","v":1120051.4331300866},{"$f":"IF($C$20=$B$20,SUM($E$9:AJ9)/$C$24,SUM($E$9:AJ9)/$C$24)","v":1130420.0226685128},{"$f":"IF($C$20=$B$20,SUM($E$9:AK9)/$C$24,SUM($E$9:AK9)/$C$24)","v":1140788.6122069389},{"$f":"IF($C$20=$B$20,SUM($E$9:AL9)/$C$24,SUM($E$9:AL9)/$C$24)","v":1151157.201745365},{"$f":"IF($C$20=$B$20,SUM(E9:AM9)/$C$24,SUM($E$9:AM9)/$C$24)","v":1161525.7912837912},{"$f":"IF($C$20=$B$20,SUM(F9:AN9)/$C$24,SUM($E$9:AN9)/$C$24)","v":1171894.3808222173},{"$f":"IF($C$20=$B$20,SUM(G9:AO9)/$C$24,SUM($E$9:AO9)/$C$24)","v":1182262.9703606435},{"$f":"IF($C$20=$B$20,SUM(H9:AP9)/$C$24,SUM($E$9:AP9)/$C$24)","v":1192631.5598990696},{"$f":"IF($C$20=$B$20,SUM(I9:AQ9)/$C$24,SUM($E$9:AQ9)/$C$24)","v":1203000.1494374957},{"$f":"IF($C$20=$B$20,SUM(J9:AR9)/$C$24,SUM($E$9:AR9)/$C$24)","v":1213368.7389759219}]
["Services",null,40,null,{"$f":"IF($C$20=$B$20,SUM($E$10:E10)/$C$25,SUM($E$10:E10)/$C$25)","v":48246.522017253439},{"$f":"IF($C$20=$B$20,SUM($E$10:F10)/$C$25,SUM($E$10:F10)/$C$25)","v":87001.856033937685},{"$f":"IF($C$20=$B$20,SUM($E$10:G10)/$C$25,SUM($E$10:G10)/$C$25)","v":114176.55127747671},{"$f":"IF($C$20=$B$20,SUM($E$10:H10)/$C$25,SUM($E$10:H10)/$C$25)","v":140832.05580068359},{"$f":"IF($C$20=$B$20,SUM($E$10:I10)/$C$25,SUM($E$10:I10)/$C$25)","v":167691.78351054547},{"$f":"IF($C$20=$B$20,SUM($E$10:J10)/$C$25,SUM($E$10:J10)/$C$25)","v":193434.38721602462},{"$f":"IF($C$20=$B$20,SUM($E$10:K10)/$C$25,SUM($E$10:K10)/$C$25)","v":218140.02523770332},{"$f":"IF($C$20=$B$20,SUM($E$10:L10)/$C$25,SUM($E$10:L10)/$C$25)","v":242465.72572124278},{"$f":"IF($C$20=$B$20,SUM($E$10:M10)/$C$25,SUM($E$10:M10)/$C$25)","v":266006.80888711661},{"$f":"IF($C$20=$B$20,SUM($E$10:N10)/$C$25,SUM($E$10:N10)/$C$25)","v":289144.56902930862},{"$f":"IF($C$20=$B$20,SUM($E$10:O10)/$C$25,SUM($E$10:O10)/$C$25)","v":314810.48735379701},{"$f":"IF($C$20=$B$20,SUM($E$10:P10)/$C$25,SUM($E$10:P10)/$C$25)","v":340338.11751350411},{"$f":"IF($C$20=$B$20,SUM($E$10:Q10)/$C$25,SUM($E$10:Q10)/$C$25)","v":365801.69739732653},{"$f":"IF($C$20=$B$20,SUM($E$10:R10)/$C$25,SUM($E$10:R10)/$C$25)","v":391155.48748829245},{"$f":"IF($C$20=$B$20,SUM($E$10:S10)/$C$25,SUM($E$10:S10)/$C$25)","v":416445.22730337369},{"$f":"IF($C$20=$B$20,SUM($E$10:T10)/$C$25,SUM($E$10:T10)/$C$25)","v":441714.7263132034},{"$f":"IF($C$20=$B$20,SUM($E$10:U10)/$C$25,SUM($E$10:U10)/$C$25)","v":466912.0673034871},{"$f":"IF($C$20=$B$20,SUM($E$10:V10)/$C$25,SUM($E$10:V10)/$C$25)","v":491982.36965474748},{"$f":"IF($C$20=$B$20,SUM($E$10:W10)/$C$25,SUM($E$10:W10)/$C$25)","v":516995.82508517022},{"$f":"IF($C$20=$B$20,SUM($E$10:X10)/$C$25,SUM($E$10:X10)/$C$25)","v":542009.13069258095},{"$f":"IF($C$20=$B$20,SUM($E$10:Y10)/$C$25,SUM($E$10:Y10)/$C$25)","v":562045.23716881312},{"$f":"IF($C$20=$B$20,SUM($E$10:Z10)/$C$25,SUM($E$10:Z10)/$C$25)","v":581956.24275348033},{"$f":"IF($C$20=$B$20,SUM($E$10:AA10)/$C$25,SUM($E$10:AA10)/$C$25)","v":601801.41013781645},{"$f":"IF($C$20=$B$20,SUM($E$10:AB10)/$C$25,SUM($E$10:AB10)/$C$25)","v":621521.4766305876},{"$f":"IF($C$20=$B$20,SUM($E$10:AC10)/$C$25,SUM($E$10:AC10)/$C$25)","v":641221.30231810734},{"$f":"IF($C$20=$B$20,SUM($E$10:AD10)/$C$25,SUM($E$10:AD10)/$C$25)","v":660884.37206702889},{"$f":"IF($C$20=$B$20,SUM($E$10:AE10)/$C$25,SUM($E$10:AE10)/$C$25)","v":680508.89795290597},{"$f":"IF($C$20=$B$20,SUM($E$10:AF10)/$C$25,SUM($E$10:AF10)/$C$25)","v":700097.87193482311},{"$f":"IF($C$20=$B$20,SUM($E$10:AG10)/$C$25,SUM($E$10:AG10)/$C$25)","v":719686.84591674036},{"$f":"IF($C$20=$B$20,SUM($E$10:AH10)/$C$25,SUM($E$10:AH10)/$C$25)","v":739275.8198986575},{"$f":"IF($C$20=$B$20,SUM($E$10:AI10)/$C$25,SUM($E$10:AI10)/$C$25)","v":758864.79388057464},{"$f":"IF($C$20=$B$20,SUM($E$10:AJ10)/$C$25,SUM($E$10:AJ10)/$C$25)","v":778453.76786249189},{"$f":"IF($C$20=$B$20,SUM($E$10:AK10)/$C$25,SUM($E$10:AK10)/$C$25)","v":798042.74184440903},{"$f":"IF($C$20=$B$20,SUM($E$10:AL10)/$C$25,SUM($E$10:AL10)/$C$25)","v":817631.71582632628},{"$f":"IF($C$20=$B$20,SUM(E10:AM10)/$C$25,SUM($E$10:AM10)/$C$25)","v":837220.68980824342},{"$f":"IF($C$20=$B$20,SUM(F10:AN10)/$C$25,SUM($E$10:AN10)/$C$25)","v":856809.66379016056},{"$f":"IF($C$20=$B$20,SUM(G10:AO10)/$C$25,SUM($E$10:AO10)/$C$25)","v":876398.63777207769},{"$f":"IF($C$20=$B$20,SUM(H10:AP10)/$C$25,SUM($E$10:AP10)/$C$25)","v":895987.61175399483},{"$f":"IF($C$20=$B$20,SUM(I10:AQ10)/$C$25,SUM($E$10:AQ10)/$C$25)","v":915576.58573591185},{"$f":"IF($C$20=$B$20,SUM(J10:AR10)/$C$25,SUM($E$10:AR10)/$C$25)","v":935165.55971782899}]
["Meters, PRS, Telemetry",null,{"$f":"IF($C$20=$B$20,35,15)","v":15},null,{"$f":"IF($C$20=$B$20,SUM($E$11:E11)/$C$26,SUM($E$11:E11)/$C$26)","v":68328.610403532759},{"$f":"IF($C$20=$B$20,SUM($E$11:F11)/$C$26,SUM($E$11:F11)/$C$26)","v":129665.54435544051},{"$f":"IF($C$20=$B$20,SUM($E$11:G11)/$C$26,SUM($E$11:G11)/$C$26)","v":167787.33826475622},{"$f":"IF($C$20=$B$20,SUM($E$11:H11)/$C$26,SUM($E$11:H11)/$C$26)","v":203365.16842140499},{"$f":"IF($C$20=$B$20,SUM($E$11:I11)/$C$26,SUM($E$11:I11)/$C$26)","v":239518.25241446946},{"$f":"IF($C$20=$B$20,SUM($E$11:J11)/$C$26,SUM($E$11:J11)/$C$26)","v":286682.37817396835},{"$f":"IF($C$20=$B$20,SUM($E$11:K11)/$C$26,SUM($E$11:K11)/$C$26)","v":317311.43948368542},{"$f":"IF($C$20=$B$20,SUM($E$11:L11)/$C$26,SUM($E$11:L11)/$C$26)","v":346735.86658421846},{"$f":"IF($C$20=$B$20,SUM($E$11:M11)/$C$26,SUM($E$11:M11)/$C$26)","v":374144.07170281635},{"$f":"IF($C$20=$B$20,SUM($E$11:N11)/$C$26,SUM($E$11:N11)/$C$26)","v":400620.5080254685},{"$f":"IF($C$20=$B$20,SUM($E$11:O11)/$C$26,SUM($E$11:O11)/$C$26)","v":427989.32825352752},{"$f":"IF($C$20=$B$20,SUM($E$11:P11)/$C$26,SUM($E$11:P11)/$C$26)","v":454192.33538044157},{"$f":"IF($C$20=$B$20,SUM($E$11:Q11)/$C$26,SUM($E$11:Q11)/$C$26)","v":480300.98214113468},{"$f":"IF($C$20=$B$20,SUM($E$11:R11)/$C$26,SUM($E$11:R11)/$C$26)","v":506129.67358747782},{"$f":"IF($C$20=$B$20,SUM($E$11:S11)/$C$26,SUM(E11:S11)/$C$26)","v":531864.00466760003},{"$f":"IF($C$20=$B$20,SUM($E$11:T11)/$C$26,SUM(F11:T11)/$C$26)","v":489269.7253441895},{"$f":"IF($C$20=$B$20,SUM($E$11:U11)/$C$26,SUM(G11:U11)/$C$26)","v":453540.22520521452},{"$f":"IF($C$20=$B$20,SUM($E$11:V11)/$C$26,SUM(H11:V11)/$C$26)","v":440676.96289399825},{"$f":"IF($C$20=$B$20,SUM($E$11:W11)/$C$26,SUM(I11:W11)/$C$26)","v":430332.25086971128},{"$f":"IF($C$20=$B$20,SUM($E$11:X11)/$C$26,SUM(J11:X11)/$C$26)","v":441544.30658124655},{"$f":"IF($C$20=$B$20,SUM($E$11:Y11)/$C$26,SUM(K11:Y11)/$C$26)","v":484825.18555571174},{"$f":"IF($C$20=$B$20,SUM($E$11:Z11)/$C$26,SUM(L11:Z11)/$C$26)","v":537426.06276051688},{"$f":"IF($C$20=$B$20,SUM($E$11:AA11)/$C$26,SUM(M11:AA11)/$C$26)","v":567460.05309733585},{"$f":"IF($C$20=$B$20,SUM($E$11:AB11)/$C$26,SUM(N11:AB11)/$C$26)","v":596574.25549912034},{"$f":"IF($C$20=$B$20,SUM($E$11:AC11)/$C$26,SUM(O11:AC11)/$C$26)","v":627343.2779383288},{"$f":"IF($C$20=$B$20,SUM($E$11:AD11)/$C$26,SUM(P11:AD11)/$C$26)","v":667502.11509058776},{"$f":"IF($C$20=$B$20,SUM($E$11:AE11)/$C$26,SUM(Q11:AE11)/$C$26)","v":692278.99416134122},{"$f":"IF($C$20=$B$20,SUM($E$11:AF11)/$C$26,SUM(R11:AF11)/$C$26)","v":715863.94575577928},{"$f":"IF($C$20=$B$20,SUM($E$11:AG11)/$C$26,SUM(S11:AG11)/$C$26)","v":739728.85266456753},{"$f":"IF($C$20=$B$20,SUM($E$11:AH11)/$C$26,SUM(T11:AH11)/$C$26)","v":763688.11993957672},{"$f":"IF($C$20=$B$20,SUM($E$11:AI11)/$C$26,SUM(U11:AI11)/$C$26)","v":787647.38721458591},{"$f":"IF($C$20=$B$20,SUM($E$11:AJ11)/$C$26,SUM(V11:AJ11)/$C$26)","v":811733.55175678455},{"$f":"IF($C$20=$B$20,SUM($E$11:AK11)/$C$26,SUM(W11:AK11)/$C$26)","v":836168.61851381627},{"$f":"IF($C$20=$B$20,SUM($E$11:AL11)/$C$26,SUM(X11:AL11)/$C$26)","v":860629.09873658582},{"$f":"IF($C$20=$B$20,SUM(E11:AM11)/$C$26,SUM(Y11:AM11)/$C$26)","v":862957.55738711741},{"$f":"IF($C$20=$B$20,SUM(F11:AN11)/$C$26,SUM(Z11:AN11)/$C$26)","v":822206.15100828477},788669.81084889383,778904.99176667305,772076.18260142219,{"$f":"IF($C$20=$B$20,SUM(J11:AR11)/$C$26,SUM(AD11:AR11)/$C$26)","v":764524.32219469291}]
["Other Capex",null,{"$f":"IF($C$20=$B$20,35,5)","v":5},null,{"$f":"IF($C$20=$B$20,SUM($E$12:E12)/$C$27,SUM($E$12:E12)/$C$27)","v":76679.591517820998},{"$f":"IF($C$20=$B$20,SUM($E$12:F12)/$C$27,SUM($E$12:F12)/$C$27)","v":152743.9184760272},{"$f":"IF($C$20=$B$20,SUM($E$12:G12)/$C$27,SUM($E$12:G12)/$C$27)","v":228348.96283677733},{"$f":"IF($C$20=$B$20,SUM($E$12:H12)/$C$27,SUM($E$12:H12)/$C$27)","v":303497.49778577825},{"$f":"IF($C$20=$B$20,SUM($E$12:I12)/$C$27,SUM(E12:I12)/$C$27)","v":378192.27976401587},{"$f":"IF($C$20=$B$20,SUM($E$12:J12)/$C$27,SUM(F12:J12)/$C$27)","v":316457.13531657809},{"$f":"IF($C$20=$B$20,SUM($E$12:K12)/$C$27,SUM(G12:K12)/$C$27)","v":255337.2554287551},{"$f":"IF($C$20=$B$20,SUM($E$12:L12)/$C$27,SUM(H12:L12)/$C$27)","v":194676.65813838816},{"$f":"IF($C$20=$B$20,SUM($E$12:M12)/$C$27,SUM(I12:M12)/$C$27)","v":134472.57025977041},{"$f":"IF($C$20=$B$20,SUM($E$12:N12)/$C$27,SUM(J12:N12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:O12)/$C$27,SUM(K12:O12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:P12)/$C$27,SUM(L12:P12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:Q12)/$C$27,SUM(M12:Q12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:R12)/$C$27,SUM(N12:R12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:S12)/$C$27,SUM(O12:S12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:T12)/$C$27,SUM(P12:T12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:U12)/$C$27,SUM(Q12:U12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:V12)/$C$27,SUM(R12:V12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:W12)/$C$27,SUM(S12:W12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:X12)/$C$27,SUM(T12:X12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:Y12)/$C$27,SUM(U12:Y12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:Z12)/$C$27,SUM(V12:Z12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AA12)/$C$27,SUM(W12:AA12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AB12)/$C$27,SUM(X12:AB12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AC12)/$C$27,SUM(Y12:AC12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AD12)/$C$27,SUM(Z12:AD12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AE12)/$C$27,SUM(AA12:AE12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AF12)/$C$27,SUM(AB12:AF12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AG12)/$C$27,SUM(AC12:AG12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AH12)/$C$27,SUM(AD12:AH12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AI12)/$C$27,SUM(AE12:AI12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AJ12)/$C$27,SUM(AF12:AJ12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AK12)/$C$27,SUM(AG12:AK12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM($E$12:AL12)/$C$27,SUM(AH12:AL12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM(E12:AM12)/$C$27,SUM(AI12:AM12)/$C$27)","v":74722.235351915951},{"$f":"IF($C$20=$B$20,SUM(F12:AN12)/$C$27,SUM(AJ12:AN12)/$C$27)","v":74722.235351915951},74722.235351915951,74722.235351915951,74722.235351915951,{"$f":"IF($C$20=$B$20,SUM(J12:AR12)/$C$27,SUM(AN12:AR12)/$C$27)","v":74722.235351915951}]
["Total depreciation",null,null,null,{"$f":"SUM(E23:E27)","v":565550.43215352285},{"$f":"SUM(F23:F27)","v":911184.4046308148},1148988.2486345654,1383424.9445024375,1617343.2793841094,1686656.9908514027,1723899.1624284147,1760193.0732898081,1784791.2061526568,1808480.3162282768,1895580.4707536804,1958286.2115605106,2020814.4883336429,2082954.6893842865,2144917.4264012328,2138541.9364928729,2138939.2035834449,2162062.9659988494,2187655.3954522656,2234791.7794721872,2308534.7160747461,2391447.3915629196,2451733.4065267467,2510949.3742108135,2571810.545410532,2642008.451426839,2696794.6494762958,2750337.1645910768,2804159.6350202085,2858076.4658155609,2911993.2966109137,2966037.0246734559,3020429.6549508306,3074847.6986939437,3107133.720864818,3096339.8780063288,3092761.1013672813,3112953.8458054038,3136082.6001604958,3158488.3032741104]
[]
["DAV"]
["Opening balance",null,null,null,{"$f":"D34","v":6828297.8813500181},{"$f":"E34","v":17664465.890775338},26382965.592901289,31146909.7040576,35621308.117138803,39842553.763956636,42293470.101058915,43813048.699832886,45270147.510452084,46266962.241345063,47208871.051741377,48187798.491654292,48157388.969546042,48059711.618472278,47891369.920307077,47656325.932932548,47427272.774595462,47192238.002739787,{"$f":"V34","v":46923256.235129185},{"$f":"W34","v":46626305.506122388},{"$f":"X34","v":46613686.189906567},{"$f":"Y34","v":46955031.085316941},{"$f":"Z34","v":47099226.938158512},{"$f":"AA34","v":46824173.013624281},{"$f":"AB34","v":46439852.598862432},{"$f":"AC34","v":46005132.120652124},{"$f":"AD34","v":45652323.519843899},{"$f":"AE34","v":44995322.157832645},{"$f":"AF34","v":44263413.74473419},43477682.861206599,42638035.146883659,41744470.601765364,40796862.328584529,39794861.425126322,38738442.477924995,37649737.508552797,36571826.382039085,35497494.032164425,34402968.937851638,33285315.089183763]
["Capex",null,null,null,{"$f":"E13","v":11401718.441578845},{"$f":"F13","v":9629684.1067567654},5912932.3597908774,5857823.3575836373,5838588.9262019433,4137573.3279536827,3243477.7612023894,3217291.8839090075,2781605.937045631,2750389.1266245944,2874507.9106665892,1927876.689452264,1923137.1372598787,1914612.9912190894,1909873.4390267036,1909488.7781557858,1903904.43172777,1893081.1983882459,1890704.6664454718,2222172.4632563679,2649879.6114851176,2535643.2444044868,2176679.4819925134,2126628.9594489606,2137090.0672002193,2289199.8506186171,2039793.2874650448,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216,2018428.7514926216]
["Depreciation",null,null,null,{"$f":"-E28","v":-565550.43215352285},{"$f":"-F28","v":-911184.4046308148},-1148988.2486345654,-1383424.9445024375,-1617343.2793841094,-1686656.9908514027,-1723899.1624284147,-1760193.0732898081,-1784791.2061526568,-1808480.3162282768,-1895580.4707536804,-1958286.2115605106,-2020814.4883336429,-2082954.6893842865,-2144917.4264012328,-2138541.9364928729,-2138939.2035834449,-2162062.9659988494,-2187655.3954522656,-2234791.7794721872,-2308534.7160747461,-2391447.3915629196,-2451733.4065267467,-2510949.3742108135,-2571810.545410532,-2642008.451426839,-2696794.6494762958,-2750337.1645910768,-2804159.6350202085,-2858076.4658155609,-2911993.2966109137,-2966037.0246734559,-3020429.6549508306,-3074847.6986939437,-3107133.720864818,-3096339.8780063288,-3092761.1013672813,-3112953.8458054038,-3136082.6001604958,-3158488.3032741104]
["Closing balance",null,null,{"$f":"D18","v":6828297.8813500181},{"$f":"SUM(E31:E33)","v":17664465.890775338},{"$f":"SUM(F31:F33)","v":26382965.592901289},31146909.7040576,35621308.117138803,39842553.763956636,42293470.101058915,43813048.699832886,45270147.510452084,46266962.241345063,47208871.051741377,48187798.491654292,48157388.969546042,48059711.618472278,47891369.920307077,47656325.932932548,47427272.774595462,47192238.002739787,46923256.235129185,46626305.506122388,46613686.189906567,46955031.085316941,47099226.938158512,46824173.013624281,46439852.598862432,46005132.120652124,45652323.519843899,44995322.157832645,44263413.74473419,43477682.861206599,42638035.146883659,41744470.601765364,40796862.328584529,39794861.425126322,38738442.477924995,37649737.508552797,36571826.382039085,35497494.032164425,34402968.937851638,33285315.089183763,32145255.537402272]

{"sheet":"GD17 Pi's Calc - 40 yrs","index":2,"n_rows":64,"n_cols":43,"rows_kept":64,"cut":false,"hidden":false,"merged":[[40,0,40,42],[46,0,46,42],[48,0,48,42],[1,0,1,2],[1,3,1,4],[24,0,24,42],[32,0,32,42],[36,0,36,42]]}
[{"$f":"242.7/193.4","v":1.2549120992761116}]
["SGN P Tariff Model - Calculation of Pi tariffs, Allowed Revenues, PA and TRV",null,null,"Return"]
[null,null,null,"GD17",6.2E-2]
[null,"Av £2014",null,"Post GD17",5.5E-2]
[null,"£'000"]
["Real Return pa",null,null,{"$f":"E3","v":6.2E-2},{"$f":"D6","v":6.2E-2},{"$f":"E6","v":6.2E-2},{"$f":"F6","v":6.2E-2},{"$f":"G6","v":6.2E-2},{"$f":"E4","v":5.5E-2},{"$f":"I6","v":5.5E-2},{"$f":"J6","v":5.5E-2},5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2]
["Discount Factor (Mid Yr)",0.5,1,{"$f":"D8*(1+D6*$B$7)","v":0.97080979284369107},{"$f":"E8*(1+E6*$B$7)","v":0.91413351491872963},0.86076602158072468,0.81051414461461835,0.7631959930457799,0.72095272418030543,0.68336751107137961,{"$f":"K8*(1+K6*$B$7)","v":0.64774171665533609},0.6139731911424986,0.58196511008767648,0.55162569676557016,{"$f":"O8*(1+O6*$B$7)","v":0.52286795901949779},0.49560943982890787,0.46977198088048139,0.44528149846491133,0.422067771056788,0.40006423796851948,0.37920780850096636,{"$f":"V8*(1+V6*$B$7)","v":0.35943868104357002},{"$f":"W8*(1+W6*$B$7)","v":0.34070017160527966},0.32293855128462529,{"$f":"Y8*(1+Y6*$B$7)","v":0.30610289221291498},0.29014492152882937,0.27501888296571508,0.26068140565470627,0.24709137976749407,0.23420983864217451,0.22199984705419387,{"$f":"AF8*(1+AF6*$B$7)","v":0.21042639531203211},{"$f":"AG8*(1+AG6*$B$7)","v":0.1994562988739641},0.18905810319807023,0.17920199355267322,0.16985970952860022,0.16100446400815185,0.15261086635843779,0.14465484962885097,0.13711360154393459,{"$f":"AO8*(1+AO6*$B$7)","v":0.12996549909377686},0.12319004653438566,0.11676781662027079]
["Discount Factor (Yr End)",null,1,{"$f":"C8/(1+D6)","v":0.94161958568738224},{"$f":"D8/(1+E6)","v":0.88664744415007735},{"$f":"E8/(1+F6)","v":0.83488459901137224},0.78614369021786457,0.74024829587369545,0.70165715248691518,0.66507786965584381,0.63040556365482825,0.59754081863016895,0.56638940154518391,0.5368619919859563,0.50887392605303916,0.48234495360477647,0.45719900815618625,0.4333639887736363,0.41077155333993964,0.3893569225970992,0.36905869440483341,0.34981866768230657,0.33158167552825268,0.31429542704099783,0.29791035738483207,0.28237948567282661,0.26765828025860344,0.25370453105080898,0.24047822848417913,0.22794144880016981,0.21605824530821785,0.20479454531584632,{"$f":"AF8/(1+AG6)","v":0.19411805243208183},{"$f":"AG8/(1+AH6)","v":0.18399815396405861},{"$f":"AH8/(1+AI6)","v":0.1744058331412878},{"$f":"AI8/(1+AJ6)","v":0.16531358591591261},{"$f":"AJ8/(1+AK6)","v":0.1566953421003911},{"$f":"AK8/(1+AL6)","v":0.14852639061648445},{"$f":"AL8/(1+AM6)","v":0.14078330864121749},{"$f":"AM8/(1+AN6)","v":0.13344389444665167},{"$f":"AN8/(1+AO6)","v":0.12648710374090205},{"$f":"AO8/(1+AP6)","v":0.11989298932786925},{"$f":"AP8/(1+AQ6)","v":0.11364264391267229}]
[]
[]
[]
[null,null,2017,{"$f":"C12+1","v":2018},{"$f":"D12+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057]
[]
["Capex",null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!E56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!E58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!E59/1000,0)))","v":11401.718441578843},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!F56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!F58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!F59/1000,0)))","v":9629.6841067567657},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!G56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!G58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!G59/1000,0)))","v":5912.9323597908779},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!H56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!H58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!H59/1000,0)))","v":5857.8233575836375},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!I56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!I58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!I59/1000,0)))","v":5838.5889262019437},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!J56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!J58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!J59/1000,0)))","v":4137.5733279536835},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!K56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!K58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!K59/1000,0)))","v":3243.4777612023895},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!L56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!L58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!L59/1000,0)))","v":3217.2918839090075},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!M56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!M58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!M59/1000,0)))","v":2781.6059370456314},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!N56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!N58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!N59/1000,0)))","v":2750.3891266245942},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!O56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!O58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!O59/1000,0)))","v":2874.5079106665899},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!P56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!P58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!P59/1000,0)))","v":1927.8766894522639},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Q56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Q58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Q59/1000,0)))","v":1923.1371372598785},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!R56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!R58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!R59/1000,0)))","v":1914.6129912190891},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!S56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!S58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!S59/1000,0)))","v":1909.8734390267036},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!T56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!T58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!T59/1000,0)))","v":1909.4887781557854},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!U56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!U58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!U59/1000,0)))","v":1903.9044317277701},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!V56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!V58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!V59/1000,0)))","v":1893.0811983882454},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!W56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!W58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!W59/1000,0)))","v":1890.7046664454722},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!X56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!X58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!X59/1000,0)))","v":2222.1724632563682},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Y56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Y58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Y59/1000,0)))","v":2649.8796114851179},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Z56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Z58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Z59/1000,0)))","v":2535.6432444044872},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AA56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AA58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AA59/1000,0)))","v":2176.6794819925135},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AB56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AB58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AB59/1000,0)))","v":2126.6289594489608},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AC56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AC58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AC59/1000,0)))","v":2137.0900672002194},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AD56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AD58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AD59/1000,0)))","v":2289.1998506186173},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AE56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AE58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AE59/1000,0)))","v":2039.7932874650448},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AF56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AF58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AF59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AG56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AG58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AG59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AH56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AH58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AH59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AI56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AI58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AI59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AJ56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AJ58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AJ59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AK56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AK58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AK59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AL56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AL58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AL59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AM56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AM58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AM59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AN56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AN58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AN59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AO56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AO58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AO59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AP56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AP58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AP59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AQ56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AQ58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AQ59/1000,0)))","v":2018.4287514926216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AR56/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AR58/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AR59/1000,0)))","v":2018.4287514926216}]
["Opex",null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!E62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!E64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!E65/1000,0)))","v":2129.2006083845777},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!F62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!F64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!F65/1000,0)))","v":1580.319756761324},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!G62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!G64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!G65/1000,0)))","v":1387.1905868976692},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!H62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!H64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!H65/1000,0)))","v":1431.6120754367287},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!I62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!I64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!I65/1000,0)))","v":1494.5123060298713},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!J62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!J64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!J65/1000,0)))","v":1518.7059095927866},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!K62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!K64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!K65/1000,0)))","v":1544.5930654051058},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!L62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!L64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!L65/1000,0)))","v":1572.2923221242872},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!M62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!M64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!M65/1000,0)))","v":1601.9305268138114},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!N62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!N64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!N65/1000,0)))","v":1633.643405831602},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!O62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!O64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!O65/1000,0)))","v":1667.5761863806385},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!P62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!P64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!P65/1000,0)))","v":1703.8842615681071},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Q62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Q64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Q65/1000,0)))","v":1742.7339020186992},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!R62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!R64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!R65/1000,0)))","v":1784.3030173008319},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!S62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!S64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!S65/1000,0)))","v":1828.7819706527143},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!T62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!T64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!T65/1000,0)))","v":1876.3744507392282},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!U62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!U64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!U65/1000,0)))","v":1927.2984044317984},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!V62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!V64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!V65/1000,0)))","v":1981.7870348828478},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!W62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!W64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!W65/1000,0)))","v":2040.0898694654718},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!X62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!X64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!X65/1000,0)))","v":2102.4739024688788},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Y62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Y64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Y65/1000,0)))","v":2169.2248177825245},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Z62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Z64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Z65/1000,0)))","v":2240.6482971681253},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AA62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AA64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AA65/1000,0)))","v":2317.0714201107185},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AB62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AB64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AB65/1000,0)))","v":2398.8441616592922},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AC62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AC64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AC65/1000,0)))","v":2486.340995116268},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AD62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AD64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AD65/1000,0)))","v":2579.9626069152305},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AE62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AE64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AE65/1000,0)))","v":2680.1377315401205},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AF62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AF64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AF65/1000,0)))","v":2787.3251148887534},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AG62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AG64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AG65/1000,0)))","v":2902.0156150717903},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AH62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AH64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AH65/1000,0)))","v":3024.7344502676397},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AI62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AI64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AI65/1000,0)))","v":3156.043603927199},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AJ62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AJ64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AJ65/1000,0)))","v":3296.5443983429273},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AK62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AK64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AK65/1000,0)))","v":3446.8802483677559},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AL62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AL64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AL65/1000,0)))","v":3607.7396078943239},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AM62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AM64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AM65/1000,0)))","v":3779.8591225877503},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AN62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AN64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AN65/1000,0)))","v":3964.0270033097167},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AO62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AO64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AO65/1000,0)))","v":4161.0866356822207},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AP62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AP64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AP65/1000,0)))","v":4371.9404423208016},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AQ62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AQ64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AQ65/1000,0)))","v":4597.5540154240816},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AR62/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AR64/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AR65/1000,0)))","v":4838.9605386445919}]
["Volumes (therms '000)",null,null,{"$f":"SUM(D17:D19)","v":24873.157631238799},34264.27205660184,34884.607902322503,35520.408565880163,36136.602014417032,36699.299553842902,37292.900597237269,37893.850952677421,38503.057799372502,39121.989114966949,39775.365715115171,40388.634529748495,41001.935005485255,41615.267935462558,42228.633859138499,42842.033324938086,43455.46689040232,44068.935122339717,30820.283124358732,31431.63112637775,31942.051128396764,32452.471130415775,32962.891132434794,33473.311134453805,33983.731136472823,34494.151138491841,35004.57114051086,35514.991142529871,36025.411144548889,36535.8311465679,36734.901273294716,36892.354935511321,37044.908269979889,37197.46160444845,37350.014938917011,37502.568273385579,37655.121607854147,37655.121607854147,37655.121607854147,37655.121607854147]
["V Domestic (P1)",null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!E69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!E77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!E85/1000,0)))","v":895.51189743589725},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!F69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!F77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!F85/1000,0)))","v":1622.0473600207774},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!G69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!G77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!G85/1000,0)))","v":2155.9103174451229},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!H69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!H77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!H85/1000,0)))","v":2713.0727660401612},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!I69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!I77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!I85/1000,0)))","v":3261.1427302759048},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!J69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!J77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!J85/1000,0)))","v":3744.6779326044566},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!K69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!K77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!K85/1000,0)))","v":4238.7188403019809},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!L69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!L77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!L85/1000,0)))","v":4739.0183106679833},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!M69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!M77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!M85/1000,0)))","v":5239.3177810339857},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!N69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!N77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!N85/1000,0)))","v":5739.6172513999882},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!O69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!O77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!O85/1000,0)))","v":6300.47352176599},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!P69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!P77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!P85/1000,0)))","v":6861.3297921319927},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Q69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Q77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Q85/1000,0)))","v":7422.1860624979954},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!R69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!R77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!R85/1000,0)))","v":7983.0423328639972},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!S69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!S77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!S85/1000,0)))","v":8543.8986032299999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!T69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!T77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!T85/1000,0)))","v":9104.7548735960008},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!U69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!U77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!U85/1000,0)))","v":9665.6111439620054},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!V69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!V77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!V85/1000,0)))","v":10226.467414328008},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!W69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!W77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!W85/1000,0)))","v":10787.323684694009},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!X69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!X77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!X85/1000,0)))","v":11348.179955060014},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Y69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Y77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Y85/1000,0)))","v":11808.108225426015},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!Z69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Z77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Z85/1000,0)))","v":12268.036495792016},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AA69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AA77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AA85/1000,0)))","v":12727.964766158018},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AB69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AB77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AB85/1000,0)))","v":13187.893036524021},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AC69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AC77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AC85/1000,0)))","v":13647.821306890026},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AD69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AD77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AD85/1000,0)))","v":14107.749577256027},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AE69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AE77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AE85/1000,0)))","v":14567.677847622032},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AF69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AF77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AF85/1000,0)))","v":15027.606117988031},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AG69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AG77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AG85/1000,0)))","v":15487.534388354037},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AH69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AH77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AH85/1000,0)))","v":15947.462658720035},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AI69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AI77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AI85/1000,0)))","v":16100.015993188603},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AJ69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AJ77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AJ85/1000,0)))","v":16252.569327657171},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AK69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AK77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AK85/1000,0)))","v":16405.122662125737},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AL69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AL77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AL85/1000,0)))","v":16557.675996594302},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AM69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AM77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AM85/1000,0)))","v":16710.229331062867},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AN69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AN77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AN85/1000,0)))","v":16862.782665531435},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AO69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AO77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AO85/1000,0)))","v":17015.335999999999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AP69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AP77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AP85/1000,0)))","v":17015.335999999999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AQ69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AQ77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AQ85/1000,0)))","v":17015.335999999999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,Inputs!AR69/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AR77/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AR85/1000,0)))","v":17015.335999999999}]
["V Tarriff (P2 + P3 + P4)",null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!E70:E72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!E78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!E86/1000,0)))","v":2.0583993326874999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!F70:F72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!F78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!F86/1000,0)))","v":39.324696581062497},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!G70:G72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!G78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!G86/1000,0)))","v":125.79758487737497},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!H70:H72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!H78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!H86/1000,0)))","v":204.4357998399999},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!I70:I72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!I78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!I86/1000,0)))","v":272.55928414112492},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!J70:J72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!J78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!J86/1000,0)))","v":351.72162123844578},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!K70:K72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!K78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!K86/1000,0)))","v":451.28175693528323},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!L70:L72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!L78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!L86/1000,0)))","v":551.93264200943634},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!M70:M72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!M78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!M86/1000,0)))","v":660.84001833851642},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!N70:N72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!N78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!N86/1000,0)))","v":779.47186356695681},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!O70:O72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!O78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!O86/1000,0)))","v":871.99219334917757},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!P70:P72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!P78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!P86/1000,0)))","v":924.40473761649901},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Q70:Q72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Q78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Q86/1000,0)))","v":976.84894298725658},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!R70:R72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!R78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!R86/1000,0)))","v":1029.3256025985615},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!S70:S72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!S78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!S86/1000,0)))","v":1081.8352559084979},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!T70:T72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!T78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!T86/1000,0)))","v":1134.3784513420828},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!U70:U72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!U78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!U86/1000,0)))","v":1186.9557464403158},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!V70:V72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!V78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!V86/1000,0)))","v":1239.5677080117086},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!W70:W72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!W78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!W86/1000,0)))","v":1290.0594396647214},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!X70:X72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!X78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!X86/1000,0)))","v":1340.5511713177341},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Y70:Y72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Y78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Y86/1000,0)))","v":1391.0429029707468},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Z70:Z72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!Z78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Z86/1000,0)))","v":1441.5346346237598},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AA70:AA72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AA78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AA86/1000,0)))","v":1492.026366276772},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AB70:AB72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AB78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AB86/1000,0)))","v":1542.5180979297847},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AC70:AC72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AC78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AC86/1000,0)))","v":1593.0098295827975},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AD70:AD72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AD78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AD86/1000,0)))","v":1643.5015612358106},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AE70:AE72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AE78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AE86/1000,0)))","v":1693.9932928888234},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AF70:AF72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AF78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AF86/1000,0)))","v":1744.485024541837},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AG70:AG72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AG78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AG86/1000,0)))","v":1794.9767561948502},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AH70:AH72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AH78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AH86/1000,0)))","v":1845.4684878478633},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AI70:AI72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AI78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AI86/1000,0)))","v":1891.9852801061159},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AJ70:AJ72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AJ78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AJ86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AK70:AK72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AK78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AK86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AL70:AL72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AL78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AL86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AM70:AM72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AM78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AM86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AN70:AN72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AN78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AN86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AO70:AO72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AO78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AO86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AP70:AP72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AP78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AP86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AQ70:AQ72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AQ78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AQ86/1000,0)))","v":1896.8856078541482},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AR70:AR72)/1000,IF(Inputs!$B$101=Inputs!$B$103,Inputs!AR78/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AR86/1000,0)))","v":1896.8856078541482}]
["V Contract (P5 + P6)",null,null,{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!E73:E74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!E80:E82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!E89/1000,0)))","v":23975.587334470216},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!F73:F74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!F80:F82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!F89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!G73:G74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!G80:G82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!G89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!H73:H74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!H80:H82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!H89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!I73:I74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!I80:I82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!I89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!J73:J74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!J80:J82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!J89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!K73:K74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!K80:K82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!K89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!L73:L74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!L80:L82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!L89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!M73:M74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!M80:M82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!M89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!N73:N74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!N80:N82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!N89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!O73:O74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!O80:O82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!O89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!P73:P74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!P80:P82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!P89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Q73:Q74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Q80:Q82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Q89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!R73:R74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!R80:R82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!R89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!S73:S74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!S80:S82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!S89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!T73:T74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!T80:T82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!T89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!U73:U74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!U80:U82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!U89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!V73:V74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!V80:V82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!V89/1000,0)))","v":32602.9},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!W73:W74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!W80:W82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!W89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!X73:X74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!X80:X82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!X89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Y73:Y74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Y80:Y82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Y89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!Z73:Z74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!Z80:Z82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!Z89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AA73:AA74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AA80:AA82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AA89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AB73:AB74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AB80:AB82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AB89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AC73:AC74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AC80:AC82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AC89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AD73:AD74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AD80:AD82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AD89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AE73:AE74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AE80:AE82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AE89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AF73:AF74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AF80:AF82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AF89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AG73:AG74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AG80:AG82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AG89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AH73:AH74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AH80:AH82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AH89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AI73:AI74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AI80:AI82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AI89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AJ73:AJ74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AJ80:AJ82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AJ89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AK73:AK74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AK80:AK82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AK89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AL73:AL74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AL80:AL82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AL89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AM73:AM74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AM80:AM82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AM89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AN73:AN74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AN80:AN82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AN89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AO73:AO74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AO80:AO82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AO89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AP73:AP74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AP80:AP82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AP89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AQ73:AQ74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AQ80:AQ82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AQ89/1000,0)))","v":18742.900000000001},{"$f":"IF(Inputs!$B$101=Inputs!$B$102,SUM(Inputs!AR73:AR74)/1000,IF(Inputs!$B$101=Inputs!$B$103,SUM(Inputs!AR80:AR82)/1000,IF(Inputs!$B$101=Inputs!$B$104,Inputs!AR89/1000,0)))","v":18742.900000000001}]
["£/therm",null,null,{"$f":"D21/Inputs!D1*Inputs!D2","v":0.32261534391522456}]
["P Domestic (P1)",null,null,0.32073603123222327,{"$f":"D21","v":0.32073603123222327},{"$f":"E21","v":0.32073603123222327},0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327,0.32073603123222327]
["P Tariff (P2 + P3 + P4)",null,0.97980071266166846,{"$f":"$D$21*C22","v":0.31425739197760749},{"$f":"D22","v":0.31425739197760749},0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749,0.31425739197760749]
["P Contract (P5 + P6)",null,0.38336025715001437,{"$f":"$D$21*C23","v":0.12295744741046015},0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015,0.12295744741046015]
[]
["Conditions 4.6 and 4.6.6 Establishing Best Available Revenue Per Unit and Calculating Cashflow"]
[]
["Allowed Revenue",null,null,{"$f":"SUMPRODUCT(D21:D23,D17:D19)","v":3235.8468179237825},4541.3764714901363,4739.7803020290885,4943.1950148870174,5140.3891085624755,5320.3536199174614,5510.0978485077558,5702.1921997041718,5896.8812143092473,6094.6262151490027,6303.58822694017,6499.9460706574282,6696.3138641104779,6892.6918565485221,7089.08021750025,7285.4791193122755,7481.8887371959827,7678.309249275133,6169.8732423207621,6365.6274564753712,6529.0104244697714,6692.3933924641733,6855.7763604585743,7019.1593284529763,7182.5422964473782,7345.9252644417793,7509.3082324361812,7672.6912004305823,7836.0741684249851,7999.4571364193853,8063.0047332863187,8113.474048552941,8162.4033996016315,8211.3327506503192,8260.2621016990088,8309.1914527477002,8358.1208037963897,8358.1208037963897,8358.1208037963897,8358.1208037963897]
["Capex",null,null,{"$f":"-D14","v":-11401.718441578843},-9629.6841067567657,-5912.9323597908779,-5857.8233575836375,-5838.5889262019437,-4137.5733279536835,-3243.4777612023895,-3217.2918839090075,-2781.6059370456314,-2750.3891266245942,-2874.5079106665899,-1927.8766894522639,-1923.1371372598785,-1914.6129912190891,-1909.8734390267036,-1909.4887781557854,-1903.9044317277701,-1893.0811983882454,-1890.7046664454722,{"$f":"-W14","v":-2222.1724632563682},-2649.8796114851179,-2535.6432444044872,-2176.6794819925135,-2126.6289594489608,-2137.0900672002194,-2289.1998506186173,-2039.7932874650448,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216,-2018.4287514926216]
["Opex",null,null,{"$f":"-D15","v":-2129.2006083845777},-1580.319756761324,-1387.1905868976692,-1431.6120754367287,-1494.5123060298713,-1518.7059095927866,-1544.5930654051058,-1572.2923221242872,-1601.9305268138114,-1633.643405831602,-1667.5761863806385,-1703.8842615681071,-1742.7339020186992,-1784.3030173008319,-1828.7819706527143,-1876.3744507392282,-1927.2984044317984,-1981.7870348828478,-2040.0898694654718,{"$f":"-W15","v":-2102.4739024688788},-2169.2248177825245,-2240.6482971681253,-2317.0714201107185,-2398.8441616592922,-2486.340995116268,-2579.9626069152305,-2680.1377315401205,-2787.3251148887534,-2902.0156150717903,-3024.7344502676397,-3156.043603927199,-3296.5443983429273,-3446.8802483677559,-3607.7396078943239,-3779.8591225877503,-3964.0270033097167,-4161.0866356822207,-4371.9404423208016,-4597.5540154240816,-4838.9605386445919]
[]
["Cashflows",null,null,{"$f":"SUM(D27:D30)","v":-10295.072232039638},-6668.6273920279536,-2560.3426446594585,-2346.2404181333486,-2192.7121236693392,-335.92561762900868,722.02702190026048,912.60799367087702,{"$f":"SUM(L27:L30)","v":1513.3447504498045},1710.5936826928066,1761.5041298929416,2868.1851196370571,3030.4428248319,3193.7758480286011,3350.424807820832,3499.6158904172617,3650.6859010364142,{"$f":"SUM(U27:U30)","v":3803.4410160040402},2239.0787064098186,2040.9810907501242,1709.9059952021289,1916.1018508915604,2362.0254583553424,2493.6862073447232,2559.1112341308913,2476.7628069079315,2789.3772134310157,2866.937334049207,2915.629801860573,2956.2939346591238,2888.5323778664979,2798.5008987173919,2697.0943997412537,2585.1643912633735,2461.9742276186366,2326.7356979453616,2178.6054166215472,1967.7516099829663,1742.1380368796863,{"$f":"SUM(AQ27:AQ30)","v":1500.731513659176}]
[]
[]
[]
["Discounted Cashflow",null,{"$f":"SUM(D35:AQ35)","v":3603.4761114481962},{"$f":"D31*D7","v":-9994.5569408972369},-6096.015797557834,-2203.8559521269931,-1901.6610455635955,-1673.4691066873422,-242.18648915158545,493.40980888226147,591.13426845375602,929.15310573241459,995.50584086360311,971.69094300762333,1499.6820995947221,1501.9160708484712,1500.3464066166352,1491.8821789204726,1477.0750784233301,1460.508873060551,1442.2945324415809,804.81149698468812,695.36260786169817,552.19456492347092,586.52431833242622,685.32969126360808,685.81079521095637,667.1127137399908,611.98673931569226,653.29958706983655,636.45964967288228,613.52546926985474,589.65144659065754,546.10045238565158,501.49694000910426,458.12767131126373,416.22300718831963,375.72401982902585,336.57360251236588,298.71643501610447,255.73982008401916,214.61406583253182,175.23714218321606]
[]
[]
[]
["Closing DAV",null,null,{"$f":"DAV!E34/1000","v":17664.465890775336},{"$f":"DAV!F34/1000","v":26382.965592901288},{"$f":"DAV!G34/1000","v":31146.909704057602},{"$f":"DAV!H34/1000","v":35621.308117138804},{"$f":"DAV!I34/1000","v":39842.553763956639},{"$f":"DAV!J34/1000","v":42293.470101058912},{"$f":"DAV!K34/1000","v":43813.048699832885},{"$f":"DAV!L34/1000","v":45270.147510452087},{"$f":"DAV!M34/1000","v":46266.962241345063},{"$f":"DAV!N34/1000","v":47208.871051741378},{"$f":"DAV!O34/1000","v":48187.798491654292},{"$f":"DAV!P34/1000","v":48157.388969546046},{"$f":"DAV!Q34/1000","v":48059.711618472276},{"$f":"DAV!R34/1000","v":47891.369920307079},{"$f":"DAV!S34/1000","v":47656.325932932545},{"$f":"DAV!T34/1000","v":47427.272774595462},{"$f":"DAV!U34/1000","v":47192.238002739788},{"$f":"DAV!V34/1000","v":46923.256235129185},{"$f":"DAV!W34/1000","v":46626.305506122386},{"$f":"DAV!X34/1000","v":46613.68618990657},{"$f":"DAV!Y34/1000","v":46955.031085316943},{"$f":"DAV!Z34/1000","v":47099.226938158514},{"$f":"DAV!AA34/1000","v":46824.173013624284},{"$f":"DAV!AB34/1000","v":46439.852598862431},{"$f":"DAV!AC34/1000","v":46005.132120652124},{"$f":"DAV!AD34/1000","v":45652.3235198439},{"$f":"DAV!AE34/1000","v":44995.322157832648},{"$f":"DAV!AF34/1000","v":44263.413744734193},{"$f":"DAV!AG34/1000","v":43477.682861206602},{"$f":"DAV!AH34/1000","v":42638.03514688366},{"$f":"DAV!AI34/1000","v":41744.470601765366},{"$f":"DAV!AJ34/1000","v":40796.862328584531},{"$f":"DAV!AK34/1000","v":39794.861425126321},{"$f":"DAV!AL34/1000","v":38738.442477924997},{"$f":"DAV!AM34/1000","v":37649.737508552796},{"$f":"DAV!AN34/1000","v":36571.826382039086},{"$f":"DAV!AO34/1000","v":35497.494032164424},{"$f":"DAV!AP34/1000","v":34402.968937851634},{"$f":"DAV!AQ34/1000","v":33285.315089183765},{"$f":"DAV!AR34/1000","v":32145.25553740227}]
[]
[]
[]
["TRV",null,{"$f":"-C59","v":-7256.5479399670876}]
["Discounted DAV2045",null,{"$f":"AQ39*AQ8","v":3653.0718285188632}]
["Backsolve to 0 by running Macro Ctrl + q",null,{"$f":"SUM(C35:C44)","v":-2.8194335754960775E-11}]
[]
[]
[]
["Condition 4.6.8 Calculating TRV"]
[]
[null,"Total Regulatory Value (TRV)",null,null,null,null,null,{"$f":"H61+H63","v":39346.401667055936},null,null,null,null,{"$f":"M61+M63","v":46538.812654524627},null,null,null,null,{"$f":"R61+R63","v":44751.232339154434},null,null,null,null,{"$f":"W61+W63","v":40754.724876551365},null,null,null,null,{"$f":"AB61+AB63","v":40742.464606275898},null,null,null,null,{"$f":"AG61+AG63","v":37253.747883137723},null,null,null,null,{"$f":"AL61+AL63","v":33219.36844804413},null,null,null,null,{"$f":"AQ61+AQ63","v":32145.255537402452}]
[]
[]
[]
["Condition 4.6.9 Calculating Profile Adjustment"]
[]
[null,"Adjusted Cashflows",null,{"$f":"D31*(1+$H$6*$B$7)*(1+$H$6)^($H$12-D12)","v":-13501.627760048978},{"$f":"E31*(1+$H$6*$B$7)*(1+$H$6)^($H$12-E12)","v":-8235.0960232375382},{"$f":"F31*(1+$H$6*$B$7)*(1+$H$6)^($H$12-F12)","v":-2977.1847695047245},{"$f":"G31*(1+$H$6*$B$7)*(1+$H$6)^($H$12-G12)","v":-2568.950251103402},{"$f":"H31*(1+$H$6*$B$7)*(1+$H$6)^($H$12-H12)","v":-2260.6861995030886},{"$f":"I31*(1+$M$6*$B$7)*(1+$M$6)^($M$12-I12)","v":-427.59714163236316},{"$f":"J31*(1+$M$6*$B$7)*(1+$M$6)^($M$12-J12)","v":871.14943806535803},{"$f":"K31*(1+$M$6*$B$7)*(1+$M$6)^($M$12-K12)","v":1043.688788739805},{"$f":"L31*(1+$M$6*$B$7)*(1+$M$6)^($M$12-L12)","v":1640.4846262969688},{"$f":"M31*(1+$M$6*$B$7)*(1+$M$6)^($M$12-M12)","v":1757.635008966859},{"$f":"N31*(1+$R$6*$B$7)*(1+$R$6)^($R$12-N12)","v":2242.2050935920684},{"$f":"O31*(1+$R$6*$B$7)*(1+$R$6)^($R$12-O12)","v":3460.560033699679},{"$f":"P31*(1+$R$6*$B$7)*(1+$R$6)^($R$12-P12)","v":3465.7149872990103},{"$f":"Q31*(1+$R$6*$B$7)*(1+$R$6)^($R$12-Q12)","v":3462.0929414611041},{"$f":"R31*(1+$R$6*$B$7)*(1+$R$6)^($R$12-R12)","v":3442.5614900359051},{"$f":"S31*(1+$W$6*$B$7)*(1+$W$6)^($W$12-S12)","v":4454.6342196689784},{"$f":"T31*(1+$W$6*$B$7)*(1+$W$6)^($W$12-T12)","v":4404.6730590095804},{"$f":"U31*(1+$W$6*$B$7)*(1+$W$6)^($W$12-U12)","v":4349.741372600939},{"$f":"V31*(1+$W$6*$B$7)*(1+$W$6)^($W$12-V12)","v":2427.1893062320737},{"$f":"W31*(1+$W$6*$B$7)*(1+$W$6)^($W$12-W12)","v":2097.1080707457527},{"$f":"X31*(1+$AB$6*$B$7)*(1+$AB$6)^($AB$12-X12)","v":2176.5262237783363},{"$f":"Y31*(1+$AB$6*$B$7)*(1+$AB$6)^($AB$12-Y12)","v":2311.840139011802},{"$f":"Z31*(1+$AB$6*$B$7)*(1+$AB$6)^($AB$12-Z12)","v":2701.2907038950684},{"$f":"AA31*(1+$AB$6*$B$7)*(1+$AB$6)^($AB$12-AA12)","v":2703.1870198392717},{"$f":"AB31*(1+$AB$6*$B$7)*(1+$AB$6)^($AB$12-AB12)","v":2629.4867930694909},{"$f":"AC31*(1+$AG$6*$B$7)*(1+$AG$6)^($AG$12-AC12)","v":3152.6523764698018},{"$f":"AD31*(1+$AG$6*$B$7)*(1+$AG$6)^($AG$12-AD12)","v":3365.475693191459},{"$f":"AE31*(1+$AG$6*$B$7)*(1+$AG$6)^($AG$12-AE12)","v":3278.724681701447},{"$f":"AF31*(1+$AG$6*$B$7)*(1+$AG$6)^($AG$12-AF12)","v":3160.5791505893844},{"$f":"AG31*(1+$AG$6*$B$7)*(1+$AG$6)^($AG$12-AG12)","v":3037.59201786225},{"$f":"AH31*(1+$AL$6*$B$7)*(1+$AL$6)^($AL$12-AH12)","v":3676.790704459775},{"$f":"AI31*(1+$AL$6*$B$7)*(1+$AL$6)^($AL$12-AI12)","v":3376.4837206879834},{"$f":"AJ31*(1+$AL$6*$B$7)*(1+$AL$6)^($AL$12-AJ12)","v":3084.4866653644895},{"$f":"AK31*(1+$AL$6*$B$7)*(1+$AL$6)^($AL$12-AK12)","v":2802.3505146843877},{"$f":"AL31*(1+$AL$6*$B$7)*(1+$AL$6)^($AL$12-AL12)","v":2529.6785188781491},{"$f":"AM31*(1+$AQ$6*$B$7)*(1+$AQ$6)^($AQ$12-AM12)","v":2961.6840204017344},{"$f":"AN31*(1+$AQ$6*$B$7)*(1+$AQ$6)^($AQ$12-AN12)","v":2628.5593570460269},{"$f":"AO31*(1+$AQ$6*$B$7)*(1+$AQ$6)^($AQ$12-AO12)","v":2250.3860459330767},{"$f":"AP31*(1+$AQ$6*$B$7)*(1+$AQ$6)^($AQ$12-AP12)","v":1888.4994087030409},{"$f":"AQ31*(1+$AQ$6*$B$7)*(1+$AQ$6)^($AQ$12-AQ12)","v":1542.0016302848035}]
[]
[null,"Closing TRV (Incl Return)",{"$f":"Inputs!D97/1000","v":7256.5479399670876},null,null,null,null,{"$f":"-$C$59*(1+H6)^(H12-C12)","v":-9802.8566636582054},null,null,null,null,{"$f":"-H51*(1+M6)^(M12-H12)","v":-51424.173374961254},null,null,null,null,{"$f":"-M51*(1+R6)^(R12-M12)","v":-60824.366885242198},null,null,null,null,{"$f":"-R51*(1+W6)^(W12-R12)","v":-58488.070904808694},null,null,null,null,{"$f":"-W51*(1+AB6)^(AB12-W12)","v":-53264.795485869872},null,null,null,null,{"$f":"-AB51*(1+AG6)^(AG12-AB12)","v":-53248.771802952069},null,null,null,null,{"$f":"-AG51*(1+AL6)^(AL12-AG12)","v":-48689.158572118911},null,null,null,null,{"$f":"-AL51*(1+AQ6)^(AQ12-AL12)","v":-43416.385999771133}]
[]
[null,"DAV",null,null,null,null,null,{"$f":"H39","v":39842.553763956639},null,null,null,null,{"$f":"M39","v":47208.871051741378},null,null,null,null,{"$f":"R39","v":47656.325932932545},null,null,null,null,{"$f":"W39","v":46613.68618990657},null,null,null,null,{"$f":"AB39","v":46005.132120652124},null,null,null,null,{"$f":"AG39","v":42638.03514688366},null,null,null,null,{"$f":"AL39","v":37649.737508552796},null,null,null,null,{"$f":"AQ39","v":32145.25553740227}]
[]
[null,"Calculated PA",null,null,null,null,null,{"$f":"-SUM(D57:H62)","v":-496.15209690070333},null,null,null,null,{"$f":"-SUM(I57:M62)","v":-670.05839721675147},null,null,null,null,{"$f":"-SUM(N57:R62)","v":-2905.0935937781105},null,null,null,null,{"$f":"-SUM(S57:W62)","v":-5858.9613133552048},null,null,null,null,{"$f":"-SUM(X57:AB62)","v":-5262.6675143762259},null,null,null,null,{"$f":"-SUM(AC57:AG62)","v":-5384.2872637459368},null,null,null,null,{"$f":"-SUM(AH57:AL62)","v":-4430.3690605086667},null,null,null,null,{"$f":"-SUM(AM57:AQ62)","v":1.8189894035458565E-10}]
[null,"Check",null,null,null,null,null,{"$f":"SUM(D57:H63)","v":0},null,null,null,null,{"$f":"SUM(I57:M63)","v":0},null,null,null,null,{"$f":"SUM(N57:R63)","v":0},null,null,null,null,{"$f":"SUM(S57:W63)","v":0},null,null,null,null,{"$f":"SUM(X57:AB63)","v":0},null,null,null,null,{"$f":"SUM(AC57:AG63)","v":0},null,null,null,null,{"$f":"SUM(AH57:AL63)","v":0},null,null,null,null,{"$f":"SUM(AM57:AQ63)","v":0}]