{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["EGX Only -> OUTPUT","PTRM output","Price Path Calc - Split","Upfront charges","INPUTS","Demand Forecast","PIVOT NMI's","NMIs Per NTC","NMI profile assessment","NMI impact analysis","Meter Relationships"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":571,"comments":4,"pivot_tables":2},"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":"EGX Only -> OUTPUT","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"X-Factors"]
[]
[null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20"]
[null,null,null,null,"Non-capital",{"$f":"'Price Path Calc - Split'!D137","v":-4.2210957044038613E-2},{"$f":"'Price Path Calc - Split'!E137","v":-4.2210957044038613E-2},{"$f":"'Price Path Calc - Split'!F137","v":-4.2210957044038613E-2},{"$f":"'Price Path Calc - Split'!G137","v":-4.2210957044038613E-2}]
[null,null,null,null,"Capital",{"$f":"'Price Path Calc - Split'!D62","v":-7.4406117322287774E-2},{"$f":"'Price Path Calc - Split'!E62","v":-7.4406117322287774E-2},{"$f":"'Price Path Calc - Split'!F62","v":-7.4406117322287774E-2},{"$f":"'Price Path Calc - Split'!G62","v":-7.4406117322287774E-2}]
[]
[]
[null,null,null,null,"Table 11.3 Annual Metering Charges"]
[]
[null,null,"Tariff Class","Costs","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,null,"Primary","Non-capital",{"$f":"'Price Path Calc - Split'!C140","v":10.81},{"$f":"'Price Path Calc - Split'!D140","v":11.547957956787208},{"$f":"'Price Path Calc - Split'!E140","v":12.336293521898703},{"$f":"'Price Path Calc - Split'!F140","v":13.178445784780074},{"$f":"'Price Path Calc - Split'!G140","v":14.078088608551331}]
[null,null,null,"Capital",{"$f":"'Price Path Calc - Split'!C65","v":24.48},{"$f":"'Price Path Calc - Split'!D65","v":26.958998295850847},{"$f":"'Price Path Calc - Split'!E65","v":29.689035503091862},{"$f":"'Price Path Calc - Split'!F65","v":32.695533395968496},{"$f":"'Price Path Calc - Split'!G65","v":36.006488116987292}]
[null,null,"Load control","Non-capital",{"$f":"'Price Path Calc - Split'!C141","v":3.24},{"$f":"'Price Path Calc - Split'!D141","v":3.4611825883432519},{"$f":"'Price Path Calc - Split'!E141","v":3.697464478348917},{"$f":"'Price Path Calc - Split'!F141","v":3.9498764424317701},{"$f":"'Price Path Calc - Split'!G141","v":4.2195196199543297}]
[null,null,null,"Capital",{"$f":"'Price Path Calc - Split'!C66","v":7.34},{"$f":"'Price Path Calc - Split'!D66","v":8.0832944236742321},{"$f":"'Price Path Calc - Split'!E66","v":8.9018595013355508},{"$f":"'Price Path Calc - Split'!F66","v":9.8033176113729059},{"$f":"'Price Path Calc - Split'!G66","v":10.796063022005177}]
[null,null,"Solar PV","Non-capital",{"$f":"'Price Path Calc - Split'!C142","v":7.56},{"$f":"'Price Path Calc - Split'!D142","v":8.0760927061342542},{"$f":"'Price Path Calc - Split'!E142","v":8.6274171161474733},{"$f":"'Price Path Calc - Split'!F142","v":9.2163783656741316},{"$f":"'Price Path Calc - Split'!G142","v":9.8455457798934383}]
[null,null,null,"Capital",{"$f":"'Price Path Calc - Split'!C67","v":17.14},{"$f":"'Price Path Calc - Split'!D67","v":18.875703872176615},{"$f":"'Price Path Calc - Split'!E67","v":20.787176001756311},{"$f":"'Price Path Calc - Split'!F67","v":22.892215784595585},{"$f":"'Price Path Calc - Split'!G67","v":25.210425094982114}]
[]
[null,null,"Tariff Class","Costs","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,null,"Primary","Total",{"$f":"E13+E14","v":35.29},{"$f":"F13+F14","v":38.506956252638055},{"$f":"G13+G14","v":42.025329024990569},{"$f":"H13+H14","v":45.87397918074857},{"$f":"I13+I14","v":50.084576725538625}]
[null,null,"Load control","Total",{"$f":"E15+E16","v":10.58},{"$f":"F15+F16","v":11.544477012017484},{"$f":"G15+G16","v":12.599323979684467},{"$f":"H15+H16","v":13.753194053804677},{"$f":"I15+I16","v":15.015582641959506}]
[null,null,"Solar PV","Total",{"$f":"E17+E18","v":24.7},{"$f":"F17+F18","v":26.951796578310869},{"$f":"G17+G18","v":29.414593117903785},{"$f":"H17+H18","v":32.108594150269717},{"$f":"I17+I18","v":35.055970874875555}]
[]
[]
[null,null,null,null,"Table 11.3 Metering Charges cents per day"]
[]
[null,null,"Tariff Class","Costs","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,null,"Primary","Non-capital",{"$f":"E13/'Price Path Calc - Split'!$C$3*100","v":2.9616438356164383},{"$f":"F13/'Price Path Calc - Split'!$C$3*100","v":3.1638240977499197},{"$f":"G13/'Price Path Calc - Split'!$C$3*100","v":3.3798064443558089},{"$f":"H13/'Price Path Calc - Split'!$C$3*100","v":3.6105330917205682},{"$f":"I13/'Price Path Calc - Split'!$C$3*100","v":3.8570105776852963}]
[null,null,null,"Capital",{"$f":"E14/'Price Path Calc - Split'!$C$3*100","v":6.7068493150684931},{"$f":"F14/'Price Path Calc - Split'!$C$3*100","v":7.3860269303700949},{"$f":"G14/'Price Path Calc - Split'!$C$3*100","v":8.1339823296142093},{"$f":"H14/'Price Path Calc - Split'!$C$3*100","v":8.9576803824571236},{"$f":"I14/'Price Path Calc - Split'!$C$3*100","v":9.8647912649280247}]
[null,null,"Load control","Non-capital",{"$f":"E15/'Price Path Calc - Split'!$C$3*100","v":0.88767123287671235},{"$f":"F15/'Price Path Calc - Split'!$C$3*100","v":0.94826920228582245},{"$f":"G15/'Price Path Calc - Split'!$C$3*100","v":1.0130039666709361},{"$f":"H15/'Price Path Calc - Split'!$C$3*100","v":1.0821579294333616},{"$f":"I15/'Price Path Calc - Split'!$C$3*100","v":1.1560327725902273}]
[null,null,null,"Capital",{"$f":"E16/'Price Path Calc - Split'!$C$3*100","v":2.010958904109589},{"$f":"F16/'Price Path Calc - Split'!$C$3*100","v":2.2146012119655429},{"$f":"G16/'Price Path Calc - Split'!$C$3*100","v":2.4388656168042604},{"$f":"H16/'Price Path Calc - Split'!$C$3*100","v":2.6858404414720294},{"$f":"I16/'Price Path Calc - Split'!$C$3*100","v":2.9578254854808703}]
[null,null,"Solar PV","Non-capital",{"$f":"E17/'Price Path Calc - Split'!$C$3*100","v":2.0712328767123287},{"$f":"F17/'Price Path Calc - Split'!$C$3*100","v":2.2126281386669189},{"$f":"G17/'Price Path Calc - Split'!$C$3*100","v":2.3636759222321846},{"$f":"H17/'Price Path Calc - Split'!$C$3*100","v":2.5250351686778445},{"$f":"I17/'Price Path Calc - Split'!$C$3*100","v":2.6974098027105309}]
[null,null,null,"Capital",{"$f":"E18/'Price Path Calc - Split'!$C$3*100","v":4.6958904109589046},{"$f":"F18/'Price Path Calc - Split'!$C$3*100","v":5.171425718404552},{"$f":"G18/'Price Path Calc - Split'!$C$3*100","v":5.6951167128099476},{"$f":"H18/'Price Path Calc - Split'!$C$3*100","v":6.2718399409850925},{"$f":"I18/'Price Path Calc - Split'!$C$3*100","v":6.9069657794471553}]
[]
[null,null,"Tariff Class","Costs","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,null,"Primary","Total",{"$f":"E21/'Price Path Calc - Split'!$C$3*100","v":9.668493150684931},{"$f":"F21/'Price Path Calc - Split'!$C$3*100","v":10.549851028120015},{"$f":"G21/'Price Path Calc - Split'!$C$3*100","v":11.513788773970019},{"$f":"H21/'Price Path Calc - Split'!$C$3*100","v":12.568213474177689},{"$f":"I21/'Price Path Calc - Split'!$C$3*100","v":13.721801842613321}]
[null,null,"Load control","Total",{"$f":"E22/'Price Path Calc - Split'!$C$3*100","v":2.8986301369863012},{"$f":"F22/'Price Path Calc - Split'!$C$3*100","v":3.1628704142513655},{"$f":"G22/'Price Path Calc - Split'!$C$3*100","v":3.4518695834751965},{"$f":"H22/'Price Path Calc - Split'!$C$3*100","v":3.7679983709053908},{"$f":"I22/'Price Path Calc - Split'!$C$3*100","v":4.1138582580710983}]
[null,null,"Solar PV","Total",{"$f":"E23/'Price Path Calc - Split'!$C$3*100","v":6.7671232876712324},{"$f":"F23/'Price Path Calc - Split'!$C$3*100","v":7.3840538570714713},{"$f":"G23/'Price Path Calc - Split'!$C$3*100","v":8.0587926350421313},{"$f":"H23/'Price Path Calc - Split'!$C$3*100","v":8.7968751096629347},{"$f":"I23/'Price Path Calc - Split'!$C$3*100","v":9.6043755821576866}]
[]
[]
[]
[null,null,null,null,"2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,{"$f":"'NMI profile assessment'!B7","v":0.41461598207986605},"Primary",null,{"$f":"E21","v":35.29},{"$f":"F21","v":38.506956252638055},{"$f":"G21","v":42.025329024990569},{"$f":"H21","v":45.87397918074857},{"$f":"I21","v":50.084576725538625}]
[null,{"$f":"'NMI profile assessment'!B16","v":1.0157455085230349E-3},"Primary x 2",null,{"$f":"E21*2","v":70.58},{"$f":"F21*2","v":77.01391250527611},{"$f":"G21*2","v":84.050658049981138},{"$f":"H21*2","v":91.74795836149714},{"$f":"I21*2","v":100.16915345107725}]
[null,{"$f":"'NMI profile assessment'!B8","v":0.39241126213281852},"Primary + Load Control",null,{"$f":"E21+E22","v":45.87},{"$f":"F21+F22","v":50.051433264655543},{"$f":"G21+G22","v":54.624653004675039},{"$f":"H21+H22","v":59.627173234553247},{"$f":"I21+I22","v":65.100159367498136}]
[null,{"$f":"'NMI profile assessment'!B9","v":5.9636903676373891E-3},"Primary + Load Control x 2",null,{"$f":"E21+E22*2","v":56.45},{"$f":"F21+F22*2","v":61.595910276673024},{"$f":"G21+G22*2","v":67.223976984359496},{"$f":"H21+H22*2","v":73.380367288357917},{"$f":"I21+I22*2","v":80.115742009457634}]
[null,{"$f":"'NMI profile assessment'!B12","v":0.11819485021386601},"Primary + Load Control + Solar PV",null,{"$f":"E21+E22+E23","v":70.569999999999993},{"$f":"F21+F22+F23","v":77.003229842966419},{"$f":"G21+G22+G23","v":84.039246122578817},{"$f":"H21+H22+H23","v":91.735767384822964},{"$f":"I21+I22+I23","v":100.15613024237369}]
[null,{"$f":"'NMI profile assessment'!B10","v":6.1540518291774711E-2},"Primary + Solar PV",null,{"$f":"E21+E23","v":59.989999999999995},{"$f":"F21+F23","v":65.458752830948924},{"$f":"G21+G23","v":71.439922142894346},{"$f":"H21+H23","v":77.982573331018287},{"$f":"I21+I23","v":85.14054760041418}]

{"sheet":"PTRM output","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ALTERNATIVE CONTROL SERVICES: METERING - (NOMINAL)"]
[]
["PTRM calculation to calculate return of, return on, operating and maintence & tax"]
["As at 15/7/2014"]
[null,"MAB",{"$f":"'Demand Forecast'!$A$15-1&\"/\"&RIGHT('Demand Forecast'!$A$15,2)","v":"2014/15"},{"$f":"'Demand Forecast'!$A$16-1&\"/\"&RIGHT('Demand Forecast'!$A$16,2)","v":"2015/16"},{"$f":"'Demand Forecast'!$A$17-1&\"/\"&RIGHT('Demand Forecast'!$A$17,2)","v":"2016/17"},{"$f":"'Demand Forecast'!$A$18-1&\"/\"&RIGHT('Demand Forecast'!$A$18,2)","v":"2017/18"},{"$f":"'Demand Forecast'!$A$19-1&\"/\"&RIGHT('Demand Forecast'!$A$19,2)","v":"2018/19"},{"$f":"'Demand Forecast'!$A$20-1&\"/\"&RIGHT('Demand Forecast'!$A$20,2)","v":"2019/20"}]
[null,"Metering - disc",262.96236450346998,251.82451850451488,239.96542872779739,227.35599413817869,213.96610942612418,199.76463298213056]
[null,"Metering - electronic",163.57837272843588,165.45867642794153,166.87756512776483,167.90956163024549,168.37812111294539,167.81726530251672]
[null,"Meters Only",{"$f":"SUM(C7:C8)","v":426.54073723190584},417.28319493245641,406.84299385556221,395.26555576842418,382.3442305390696,367.58189828464731]
[null,"Office Equipment & Furniture",-0.12443696437657673,-7.7637442145592858E-2,-2.7648673506603254E-2,9.8192048311703962E-3,9.9305872143539906E-3,9.8124079991602792E-3]
[null,"Motor Vehicles",4.016483621693939,3.4520877210753613,2.8668212069196586,2.1861542048670155,1.4822178096497236,0.77696915708620851]
[null,"Plant & Equipment",1.1890989252946325,1.0244948804164449,0.83977287808823531,0.63545192019587249,0.41223560609698717,0.17093750560296456]
[null,"Buildings",9.8429266820763583,9.9106957508405422,9.7190710277790373,9.4216815153996389,9.4122976432474328,9.3954206956978883]
[null,"Land",6.0343913507006164,6.0229583162581921,5.6509410584095372,5.5474316420795144,5.6861174331315016,5.8571461140809555]
[null,"IT Systems",1.2636277250696657,0.91531819187396501,0.57330510900182119,0.20624103359014773,8.2351730807004697E-2,7.9835904299899632E-2]
[null,"Other",{"$f":"SUM(C10:C15)","v":22.222091340458636},21.247917418318913,19.622262606691688,18.006779520963356,17.085150810147006,16.290121784767074]
[null,"Total",{"$f":"C9+C16","v":448.76282857236447},438.53111235077535,426.46525646225388,413.27233528938751,399.42938134921661,383.87202006941436]
[]
[]
[null,null,{"$f":"'Demand Forecast'!$A$15-1&\"/\"&RIGHT('Demand Forecast'!$A$15,2)","v":"2014/15"},{"$f":"'Demand Forecast'!$A$16-1&\"/\"&RIGHT('Demand Forecast'!$A$16,2)","v":"2015/16"},{"$f":"'Demand Forecast'!$A$17-1&\"/\"&RIGHT('Demand Forecast'!$A$17,2)","v":"2016/17"},{"$f":"'Demand Forecast'!$A$18-1&\"/\"&RIGHT('Demand Forecast'!$A$18,2)","v":"2017/18"},{"$f":"'Demand Forecast'!$A$19-1&\"/\"&RIGHT('Demand Forecast'!$A$19,2)","v":"2018/19"},{"$f":"'Demand Forecast'!$A$20-1&\"/\"&RIGHT('Demand Forecast'!$A$20,2)","v":"2019/20"}]
[null,"ARR"]
[null,"Return on capital",null,33298201.88006945,32539008.536427531,31643722.029499244,30664807.278472558,29637660.096111871,null,128477719.8279461,{"$f":"J22/$J$26","v":0.40998759776448113}]
[null,"Return of capital",null,19051523.533493999,20678519.028846998,22422977.349535801,23981943.776743941,25751768.213715222,null,89761732.370433345,{"$f":"J23/$J$26","v":0.28644030322934905}]
[null,"O&M",null,16679793.501182612,16653714.332818601,17021215.773591667,17681082.206698932,17939573.563097376,null,69513813.271081775,{"$f":"J24/$J$26","v":0.22182679886151227}]
[null,"Benchmark Tax liability",null,5825646.8718435951,6074932.7065652106,6348216.6960412292,6615787.3397906525,6920376.6791810598,null,25616506.027262479,{"$f":"J25/$J$26","v":8.1745300144657709E-2}]
[null,"Total unsmoothed revenue - before adjustments",71375217.951696068,{"$f":"SUM(D22:D25)","v":74855165.786589652},{"$f":"SUM(E22:E25)","v":75946174.60465835},{"$f":"SUM(F22:F25)","v":77436131.848667935},{"$f":"SUM(G22:G25)","v":78943620.601706088},{"$f":"SUM(H22:H25)","v":80249378.552105516},null,313369771.49672365]
[null,"NPV",313369771.49672365,{"$f":"AVERAGE(E27:H27)","v":1.7550355557687469E-2},{"$f":"E26/D26-1","v":1.4574930221638027E-2},{"$f":"F26/E26-1","v":1.9618595034781361E-2},{"$f":"G26/F26-1","v":1.9467511057812192E-2},{"$f":"H26/G26-1","v":1.6540385916518296E-2}]
[]
[null,"Total smoothed revenue after adjustments",{"$f":"C26","v":71375217.951696068},73780340.334460393,75624848.842821896,77515470.063892439,79453356.815489739,81439690.735876977,{"$f":"H29/H26-1","v":1.4832665439254322E-2}]
[null,"NPV",313369771.49672353]
[null,null,{"$f":"C27-C30","v":0}]
[null,"Adjusted revenue X factors",null,-8.4847640985382267E-3,0,0,0,0]
[]
[null,"Not Smoothed"]
[null,"ROA & Depn",null,{"$f":"D22+D23","v":52349725.413563445},{"$f":"E22+E23","v":53217527.565274529},{"$f":"F22+F23","v":54066699.379035041},{"$f":"G22+G23","v":54646751.055216499},{"$f":"H22+H23","v":55389428.309827089}]
[null,"O&M and Tax",null,{"$f":"D24+D25","v":22505440.373026207},{"$f":"E24+E25","v":22728647.039383814},{"$f":"F24+F25","v":23369432.469632898},{"$f":"G24+G25","v":24296869.546489585},{"$f":"H24+H25","v":24859950.242278434}]
[null,null,null,{"$f":"SUM(D35:D36)","v":74855165.786589652},{"$f":"SUM(E35:E36)","v":75946174.604658335},{"$f":"SUM(F35:F36)","v":77436131.848667935},{"$f":"SUM(G35:G36)","v":78943620.601706088},{"$f":"SUM(H35:H36)","v":80249378.552105516}]

{"sheet":"Price Path Calc - Split","index":2,"n_rows":175,"n_cols":10,"rows_kept":175,"cut":false,"hidden":false,"merged":[]}
["Price Path Calculation"]
[]
[null,"Days in Year",365,null,null,null,null,null,null,"press button to recalculate prices"]
[]
["PTRM Output"]
[]
[null,null,"2015-16","2016-17","2017-18","2018-19","2019-20",null,"NPV"]
[null,"ROA & Depn",{"$f":"'PTRM output'!D35","v":52349725.413563445},{"$f":"'PTRM output'!E35","v":53217527.565274529},{"$f":"'PTRM output'!F35","v":54066699.379035041},{"$f":"'PTRM output'!G35","v":54646751.055216499},{"$f":"'PTRM output'!H35","v":55389428.309827089},null,218239452.19837943,{"$f":"I8/I10","v":0.69642790099383012}]
[null,"O&M and Tax",{"$f":"'PTRM output'!D36","v":22505440.373026207},{"$f":"'PTRM output'!E36","v":22728647.039383814},{"$f":"'PTRM output'!F36","v":23369432.469632898},{"$f":"'PTRM output'!G36","v":24296869.546489585},{"$f":"'PTRM output'!H36","v":24859950.242278434},null,95130319.298344254,{"$f":"I9/I10","v":0.30357209900616999}]
[null,null,{"$f":"SUM(C8:C9)","v":74855165.786589652},{"$f":"SUM(D8:D9)","v":75946174.604658335},{"$f":"SUM(E8:E9)","v":77436131.848667935},{"$f":"SUM(F8:F9)","v":78943620.601706088},{"$f":"SUM(G8:G9)","v":80249378.552105516},null,{"$f":"SUM(I8:I9)","v":313369771.49672365}]
[]
["Forecast NTCs ROA & Depn"]
["* assume meters paid for upfront do not require any replacement in this determination"]
[null,"NTCs (avg for year)","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"ROUND('Demand Forecast'!$B$38,0)","v":1387351},{"$f":"ROUND('Demand Forecast'!$B$38,0)","v":1387351},{"$f":"ROUND('Demand Forecast'!$B$38,0)","v":1387351},{"$f":"ROUND('Demand Forecast'!$B$38,0)","v":1387351},{"$f":"ROUND('Demand Forecast'!$B$38,0)","v":1387351}]
[null,"Load Control",{"$f":"ROUND('Demand Forecast'!$F$38,0)","v":737004},{"$f":"ROUND('Demand Forecast'!$F$38,0)","v":737004},{"$f":"ROUND('Demand Forecast'!$F$38,0)","v":737004},{"$f":"ROUND('Demand Forecast'!$F$38,0)","v":737004},{"$f":"ROUND('Demand Forecast'!$F$38,0)","v":737004}]
[null,"Solar PV",{"$f":"ROUND('Demand Forecast'!$J$38,0)","v":304003},{"$f":"ROUND('Demand Forecast'!$J$38,0)","v":304003},{"$f":"ROUND('Demand Forecast'!$J$38,0)","v":304003},{"$f":"ROUND('Demand Forecast'!$J$38,0)","v":304003},{"$f":"ROUND('Demand Forecast'!$J$38,0)","v":304003}]
[]
[null,null,{"$f":"SUM(C15:C18)","v":2428358},{"$f":"SUM(D15:D18)","v":2428358},{"$f":"SUM(E15:E18)","v":2428358},{"$f":"SUM(F15:F18)","v":2428358},{"$f":"SUM(G15:G18)","v":2428358}]
[null,"Relationships"]
[null,"Primary",{"$f":"'Meter Relationships'!$H$32","v":1}]
[null,"Load Control",{"$f":"'Meter Relationships'!$H$33","v":0.3}]
[null,"Solar PV",{"$f":"'Meter Relationships'!$H$34","v":0.7}]
[]
[null,"% weighting","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C15*$C$21","v":1387351},{"$f":"D15*$C$21","v":1387351},{"$f":"E15*$C$21","v":1387351},{"$f":"F15*$C$21","v":1387351},{"$f":"G15*$C$21","v":1387351}]
[null,"Load Control",{"$f":"C16*$C$22","v":221101.19999999998},{"$f":"D16*$C$22","v":221101.19999999998},{"$f":"E16*$C$22","v":221101.19999999998},{"$f":"F16*$C$22","v":221101.19999999998},{"$f":"G16*$C$22","v":221101.19999999998}]
[null,"Solar PV",{"$f":"C17*$C$23","v":212802.09999999998},{"$f":"D17*$C$23","v":212802.09999999998},{"$f":"E17*$C$23","v":212802.09999999998},{"$f":"F17*$C$23","v":212802.09999999998},{"$f":"G17*$C$23","v":212802.09999999998}]
[]
[null,null,{"$f":"SUM(C26:C29)","v":1821254.2999999998},{"$f":"SUM(D26:D29)","v":1821254.2999999998},{"$f":"SUM(E26:E29)","v":1821254.2999999998},{"$f":"SUM(F26:F29)","v":1821254.2999999998},{"$f":"SUM(G26:G29)","v":1821254.2999999998}]
[]
[null,"% weighting","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C26/C$30","v":0.76175578555943568},0.76175578555943568,0.76175578555943568,0.76175578555943568,0.76175578555943568]
[null,"Load Control",0.12140050952796652,0.12140050952796652,0.12140050952796652,0.12140050952796652,0.12140050952796652]
[null,"Solar PV",0.11684370491259788,0.11684370491259788,0.11684370491259788,0.11684370491259788,0.11684370491259788]
[]
[null,null,{"$f":"SUM(C33:C36)","v":1},{"$f":"SUM(D33:D36)","v":1},{"$f":"SUM(E33:E36)","v":1},{"$f":"SUM(F33:F36)","v":1},{"$f":"SUM(G33:G36)","v":1}]
[]
["Calculated $ per NTC (pre smoothing) ROA & Depn"]
[]
[null,"$ per NTC per annum ROA & Depn","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C$8/C15*C33","v":28.743775876638122},29.220261863087728,29.686518449968819,30.005008666399032,30.412792057554562]
[null,"Load Control",8.6231327629914354,8.7660785589263188,8.9059555349906461,9.0015025999197089,9.1238376172663678]
[null,"Solar PV",20.120643113646686,20.454183304161408,20.780562914978173,21.003506066479321,21.28895444028819]
[]
[null,"Tariff Increase","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",null,{"$f":"(D42-C42)/C42","v":1.6577014394162353E-2},1.5956619042832257E-2,1.0728446212612297E-2,1.3590510694042353E-2]
[null,"Load Control",null,1.657701439416252E-2,1.5956619042832257E-2,1.0728446212612175E-2,1.3590510694042355E-2]
[null,"Solar PV",null,1.6577014394162193E-2,1.5956619042832347E-2,1.0728446212612262E-2,1.359051069404227E-2]
[]
[null,"Total Revenue","2015-16","2016-17","2017-18","2018-19","2019-20",null,"NPV"]
[null,"Primary",{"$f":"C42*C15","v":39877706.206229776},40538759.516016625,41185621.058082692,41627478.778337367,42193217.473840378,null,166245165.34943745]
[null,"Load Control",6355283.3388557397,6460634.962242933,6563724.8531102464,6634143.4221512247,6724304.8192757824,null,26494380.695987564]
[null,"Solar PV",6116735.8684779331,6218133.0870149806,6317353.4678421095,6385128.8547279127,6471906.0167109305,null,25499906.152954459]
[null,null,{"$f":"SUM(C52:C54)","v":52349725.413563453},{"$f":"SUM(D52:D54)","v":53217527.565274537},{"$f":"SUM(E52:E54)","v":54066699.379035048},{"$f":"SUM(F52:F54)","v":54646751.055216506},{"$f":"SUM(G52:G54)","v":55389428.309827089},null,{"$f":"SUM(I52:I54)","v":218239452.19837946}]
[null,"Check",{"$f":"C55-C8","v":0},{"$f":"D55-D8","v":0},{"$f":"E55-E8","v":0},{"$f":"F55-F8","v":0},{"$f":"G55-G8","v":0}]
[null,null,null,{"$f":"D55/C55-1","v":1.657701439416237E-2},{"$f":"E55/D55-1","v":1.5956619042832187E-2},{"$f":"F55/E55-1","v":1.0728446212612264E-2},{"$f":"G55/F55-1","v":1.3590510694042157E-2}]
[]
["Smoothed $ per NTC - what % year on year for each year across all categories gives you the same NPV as above ROA & Depn"]
[]
[null,"CPI",null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,"X - ROA & Depn",null,-7.4406117322287774E-2,{"$f":"$D$62","v":-7.4406117322287774E-2},{"$f":"$D$62","v":-7.4406117322287774E-2},{"$f":"$D$62","v":-7.4406117322287774E-2}]
[]
[null,"$ per NTC per annum (smoothed) ROA & Depn","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",24.48,{"$f":"C65*(1+D$61)*(1-D$62)","v":26.958998295850847},29.689035503091862,32.695533395968496,36.006488116987292]
[null,"Load Control",7.34,8.0832944236742321,8.9018595013355508,9.8033176113729059,10.796063022005177]
[null,"Solar PV",17.14,18.875703872176615,20.787176001756311,22.892215784595585,25.210425094982114]
[]
[null,"cents per NTC per day (smoothed)","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C65/$C$3*100","v":6.7068493150684931},7.3860269303700949,8.1339823296142093,8.9576803824571236,9.8647912649280247]
[null,"Load Control",2.010958904109589,2.2146012119655429,2.4388656168042604,2.6858404414720294,2.9578254854808703]
[null,"Solar PV",4.6958904109589046,5.171425718404552,5.6951167128099476,6.2718399409850925,6.9069657794471553]
[]
[null,"Increase (based on annualised)","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",null,{"$f":"D65/C65-1","v":0.10126627025534507},0.10126627025534485,0.10126627025534507,0.10126627025534485]
[null,"Load Control",null,0.10126627025534507,0.10126627025534507,0.10126627025534485,0.10126627025534485]
[null,"Solar PV",null,0.10126627025534507,0.10126627025534485,0.10126627025534485,0.10126627025534485]
[]
[null,"ROA & Depn Revenue","2015-16","2016-17","2017-18","2018-19","2019-20",null,"NPV"]
[null,"Primary",{"$f":"C65*C15","v":33962352.480000004},37401593.244746968,41189113.094250001,45360180.952430293,49953637.295590438,null,166251623.86607805]
[null,"Load Control",5409609.3600000003,5957420.323425604,6560706.0599223059,7225084.2928522769,7956741.6314699035,null,26480978.93427008]
[null,"Solar PV",5210611.42,5738270.6042533079,6319363.866061924,6959302.2751644114,7664044.8601498473,null,25506849.398028824]
[null,null,{"$f":"SUM(C80:C82)","v":44582573.260000005},{"$f":"SUM(D80:D82)","v":49097284.172425881},{"$f":"SUM(E80:E82)","v":54069183.020234235},{"$f":"SUM(F80:F82)","v":59544567.520446979},{"$f":"SUM(G80:G82)","v":65574423.787210189},null,{"$f":"SUM(I80:I82)","v":218239452.19837695}]
[]
[null,null,{"$f":"C83-C55","v":-7767152.1535634473},{"$f":"D83-D55","v":-4120243.3928486556},{"$f":"E83-E55","v":2483.6411991864443},{"$f":"F83-F55","v":4897816.4652304724},{"$f":"G83-G55","v":10184995.477383099},null,{"$f":"I83-I55","v":-2.5033950805664063E-6}]
[]
["Forecast NTCs O&M and Tax"]
[]
[null,"NTCs (avg for year)","2015-16","2016-17","2017-18","2018-19","2019-20",null,"Assume P of C"]
[null,"Primary",{"$f":"ROUND('Demand Forecast'!$B$16,0)","v":1393042},{"$f":"ROUND('Demand Forecast'!$B$17,0)","v":1407467},{"$f":"IF($I$91=\"YES\",ROUND('Demand Forecast'!$B$40,0),ROUND('Demand Forecast'!$B$18,0))","v":1422042},{"$f":"IF($I$91=\"YES\",E90,ROUND('Demand Forecast'!$B$19,0))","v":1436768},{"$f":"IF($I$91=\"YES\",F90,ROUND('Demand Forecast'!$B$20,0))","v":1451646},null,"2017-18"]
[null,"Load Control",{"$f":"ROUND('Demand Forecast'!$F$16,0)","v":740012},{"$f":"ROUND('Demand Forecast'!$F$17,0)","v":743305},{"$f":"IF($I$91=\"YES\",ROUND('Demand Forecast'!$F$40,0),ROUND('Demand Forecast'!$F$18,0))","v":746612},{"$f":"IF($I$91=\"YES\",E91,ROUND('Demand Forecast'!$F$19,0))","v":749934},{"$f":"IF($I$91=\"YES\",F91,ROUND('Demand Forecast'!$F$20,0))","v":753271},null,"NO"]
[null,"Solar PV",{"$f":"ROUND('Demand Forecast'!$J$16,0)","v":323232},{"$f":"ROUND('Demand Forecast'!$J$17,0)","v":353232},{"$f":"IF($I$91=\"YES\",ROUND('Demand Forecast'!$J$40,0),ROUND('Demand Forecast'!$J$18,0))","v":382232},{"$f":"IF($I$91=\"YES\",E92,ROUND('Demand Forecast'!$J$19,0))","v":409232},{"$f":"IF($I$91=\"YES\",F92,ROUND('Demand Forecast'!$J$20,0))","v":434232}]
[]
[null,null,{"$f":"SUM(C90:C93)","v":2456286},{"$f":"SUM(D90:D93)","v":2504004},{"$f":"SUM(E90:E93)","v":2550886},{"$f":"SUM(F90:F93)","v":2595934},{"$f":"SUM(G90:G93)","v":2639149}]
[null,"Relationships"]
[null,"Primary",{"$f":"'Meter Relationships'!$H$32","v":1}]
[null,"Load Control",{"$f":"'Meter Relationships'!$H$33","v":0.3}]
[null,"Solar PV",{"$f":"'Meter Relationships'!$H$34","v":0.7}]
[]
[null,"% weighting","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C90*$C$96","v":1393042},{"$f":"D90*$C$96","v":1407467},{"$f":"E90*$C$96","v":1422042},{"$f":"F90*$C$96","v":1436768},{"$f":"G90*$C$96","v":1451646}]
[null,"Load Control",{"$f":"C91*$C$97","v":222003.6},{"$f":"D91*$C$97","v":222991.5},{"$f":"E91*$C$97","v":223983.6},{"$f":"F91*$C$97","v":224980.19999999998},{"$f":"G91*$C$97","v":225981.3}]
[null,"Solar PV",{"$f":"C92*$C$98","v":226262.39999999999},{"$f":"D92*$C$98","v":247262.4},{"$f":"E92*$C$98","v":267562.39999999997},{"$f":"F92*$C$98","v":286462.39999999997},{"$f":"G92*$C$98","v":303962.39999999997}]
[]
[null,null,{"$f":"SUM(C101:C104)","v":1841308},{"$f":"SUM(D101:D104)","v":1877720.9},{"$f":"SUM(E101:E104)","v":1913588},{"$f":"SUM(F101:F104)","v":1948210.5999999999},{"$f":"SUM(G101:G104)","v":1981589.7}]
[]
[null,"% weighting","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C101/C$105","v":0.75655023494168272},0.74956134322198797,0.74312861493696658,0.73748084524332236,0.73256638344456471]
[null,"Load Control",0.12056842201304725,0.11875646694884208,0.11704901995622882,0.1154804311197157,0.11404040907156511]
[null,"Solar PV",0.12288134304526999,0.13168218982917004,0.13982236510680457,0.14703872363696202,0.15339320748387014]
[]
[null,null,{"$f":"SUM(C108:C111)","v":1},{"$f":"SUM(D108:D111)","v":1.0000000000000002},{"$f":"SUM(E108:E111)","v":1},{"$f":"SUM(F108:F111)","v":1},{"$f":"SUM(G108:G111)","v":1}]
[]
["Calculated $ per NTC (pre smoothing) O&M and Tax"]
[]
[null,"O&M and Tax $ per NTC per annum","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C$9/C90*C108","v":12.222528970181092},12.10437985718954,12.212363617263954,12.471377348264909,12.545457943326227]
[null,"Load Control",3.6667586910543282,3.6313139571568618,3.6637090851791863,3.7414132044794721,3.7636373829978682]
[null,"Solar PV",8.5557702791267651,8.4730659000326796,8.5486545320847664,8.7299641437854341,8.7818205603283577]
[]
[null,"Tariff Increase","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",null,{"$f":"D117/C117-1","v":-9.6665030027579535E-3},8.9210485252801952E-3,2.1209140107391056E-2,5.9400492016725703E-3]
[null,"Load Control",null,-9.6665030027581755E-3,8.9210485252804173E-3,2.1209140107390834E-2,5.9400492016727924E-3]
[null,"Solar PV",null,-9.6665030027578425E-3,8.9210485252799732E-3,2.1209140107390834E-2,5.9400492016725703E-3]
[]
[null,"Total Revenue","2015-16","2016-17","2017-18","2018-19","2019-20",null,"NPV"]
[null,"Primary",{"$f":"C117*C90","v":17026496.20167901},17036515.204458989,17366493.983021267,17918475.889911875,18211563.841597743,null,70815322.387642682]
[null,"Load Control",2713445.4324844955,2699173.8209244814,2735369.1675038026,2805812.9700881084,2835038.8951281873,null,11161361.180163039]
[null,"Solar PV",2765498.7388627026,2992958.0140003436,3267569.3191078245,3572580.6864896007,3813347.5055525033,null,13153635.73053853]
[null,null,{"$f":"SUM(C127:C129)","v":22505440.373026207},{"$f":"SUM(D127:D129)","v":22728647.039383817},{"$f":"SUM(E127:E129)","v":23369432.469632894},{"$f":"SUM(F127:F129)","v":24296869.546489585},{"$f":"SUM(G127:G129)","v":24859950.242278434},null,{"$f":"SUM(I127:I129)","v":95130319.298344254}]
[null,"Check",{"$f":"C130-C9","v":0},{"$f":"D130-D9","v":0},{"$f":"E130-E9","v":0},{"$f":"F130-F9","v":0},{"$f":"G130-G9","v":0}]
[null,null,null,{"$f":"D130/C130-1","v":9.9178981907475094E-3},{"$f":"E130/D130-1","v":2.8192854116601662E-2},{"$f":"F130/E130-1","v":3.9685904998413513E-2},{"$f":"G130/F130-1","v":2.3175030623243442E-2}]
[]
["Smoothed $ per NTC - what % year on year for each year across all categories gives you the same NPV as above"]
[]
[null,"CPI",null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,"X - O&M",null,-4.2210957044038613E-2,{"$f":"$D$137","v":-4.2210957044038613E-2},{"$f":"$D$137","v":-4.2210957044038613E-2},{"$f":"$D$137","v":-4.2210957044038613E-2}]
[]
[null,"$ per NTC per annum (smoothed) O&M & Tax","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",10.81,{"$f":"C140*(1+D$136)*(1-D$137)","v":11.547957956787208},12.336293521898703,13.178445784780074,14.078088608551331]
[null,"Load Control",3.24,3.4611825883432519,3.697464478348917,3.9498764424317701,4.2195196199543297]
[null,"Solar PV",7.56,8.0760927061342542,8.6274171161474733,9.2163783656741316,9.8455457798934383]
[]
[null,"cents per NTC per day (smoothed)","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C140/$C$3*100","v":2.9616438356164383},3.1638240977499197,3.3798064443558089,3.6105330917205682,3.8570105776852963]
[null,"Load Control",0.88767123287671235,0.94826920228582245,1.0130039666709361,1.0821579294333616,1.1560327725902273]
[null,"Solar PV",2.0712328767123287,2.2126281386669189,2.3636759222321846,2.5250351686778445,2.6974098027105309]
[]
[null,"Increase","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",null,{"$f":"D145/C145-1","v":6.8266230970139397E-2},6.8266230970139397E-2,6.8266230970139397E-2,6.8266230970139397E-2]
[null,"Load Control",null,6.8266230970139397E-2,6.8266230970139175E-2,6.8266230970139397E-2,6.8266230970139397E-2]
[null,"Solar PV",null,6.8266230970139397E-2,6.8266230970139397E-2,6.8266230970139619E-2,6.8266230970139397E-2]
[]
[null,"O&M and Tax Revenue","2015-16","2016-17","2017-18","2018-19","2019-20",null,"NPV"]
[null,"Primary",{"$f":"C140*C90","v":15058784.020000001},16253369.741565421,17542727.512467876,18934369.193306897,20436401.016249105,null,70765495.353269547]
[null,"Load Control",2397638.8800000004,2572714.3238284807,2760571.3491090415,2962146.6399786272,3178441.763642618,null,11135612.518783296]
[null,"Solar PV",2443633.92,2852734.3787732148,3297674.8991392809,3771636.9513415564,4275251.0350946877,null,13229211.426291373]
[null,null,{"$f":"SUM(C155:C157)","v":19900056.82},{"$f":"SUM(D155:D157)","v":21678818.444167119},{"$f":"SUM(E155:E157)","v":23600973.7607162},{"$f":"SUM(F155:F157)","v":25668152.78462708},{"$f":"SUM(G155:G157)","v":27890093.814986408},null,{"$f":"SUM(I155:I157)","v":95130319.298344225}]
[]
[null,null,{"$f":"C158-C130","v":-2605383.5530262068},{"$f":"D158-D130","v":-1049828.5952166989},{"$f":"E158-E130","v":231541.29108330607},{"$f":"F158-F130","v":1371283.2381374948},{"$f":"G158-G130","v":3030143.5727079734},null,{"$f":"I158-I130","v":0}]
[]
["Examples of annual charges for NTC combinations - Legacy ROA, Depn, O&M and Tax"]
[]
[null,null,"2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Primary",{"$f":"C65+C140","v":35.29},38.506956252638055,42.025329024990569,45.87397918074857,50.084576725538625]
[null,"Load Control",10.58,11.544477012017484,12.599323979684467,13.753194053804677,15.015582641959506]
[null,"Solar PV",24.7,26.951796578310869,29.414593117903785,32.108594150269717,35.055970874875555]
[]
[null,null,"2015-16","2016-17","2017-18","2018-19","2019-20"]
[{"$f":"'NMI profile assessment'!B7","v":0.41461598207986605},"Primary",{"$f":"C65+C140","v":35.29},{"$f":"D65+D140","v":38.506956252638055},{"$f":"E65+E140","v":42.025329024990569},{"$f":"F65+F140","v":45.87397918074857},{"$f":"G65+G140","v":50.084576725538625}]
[{"$f":"'NMI profile assessment'!B16","v":1.0157455085230349E-3},"Primary x 2",{"$f":"C170*2","v":70.58},{"$f":"D170*2","v":77.01391250527611},{"$f":"E170*2","v":84.050658049981138},{"$f":"F170*2","v":91.74795836149714},{"$f":"G170*2","v":100.16915345107725}]
[{"$f":"'NMI profile assessment'!B8","v":0.39241126213281852},"Primary + Load Control",{"$f":"C65+C66+C140+C141","v":45.870000000000005},{"$f":"D65+D66+D140+D141","v":50.051433264655536},{"$f":"E65+E66+E140+E141","v":54.624653004675032},{"$f":"F65+F66+F140+F141","v":59.627173234553247},{"$f":"G65+G66+G140+G141","v":65.100159367498136}]
[{"$f":"'NMI profile assessment'!B9","v":5.9636903676373891E-3},"Primary + Load Control x 2",{"$f":"C65+C66*2+C140+C141*2","v":56.45},{"$f":"D65+D66*2+D140+D141*2","v":61.595910276673024},{"$f":"E65+E66*2+E140+E141*2","v":67.223976984359496},{"$f":"F65+F66*2+F140+F141*2","v":73.380367288357917},{"$f":"G65+G66*2+G140+G141*2","v":80.11574200945762}]
[{"$f":"'NMI profile assessment'!B12","v":0.11819485021386601},"Primary + Load Control + Solar PV",{"$f":"C65+C66+C67+C140+C141+C142","v":70.570000000000007},{"$f":"D65+D66+D67+D140+D141+D142","v":77.003229842966391},{"$f":"E65+E66+E67+E140+E141+E142","v":84.039246122578817},{"$f":"F65+F66+F67+F140+F141+F142","v":91.735767384822978},{"$f":"G65+G66+G67+G140+G141+G142","v":100.15613024237368}]
[{"$f":"'NMI profile assessment'!B10","v":6.1540518291774711E-2},"Primary + Solar PV",{"$f":"C65+C67+C140+C142","v":59.990000000000009},{"$f":"D65+D67+D140+D142","v":65.458752830948924},{"$f":"E65+E67+E140+E142","v":71.439922142894346},{"$f":"F65+F67+F140+F142","v":77.982573331018287},{"$f":"G65+G67+G140+G142","v":85.14054760041418}]

{"sheet":"Upfront charges","index":3,"n_rows":72,"n_cols":24,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Average labour hours to install",null,null,null,null,null,null,null,"Table 11.5 & 11.6"]
[null,"Meter type","Hours/meter","Minutes"]
[null,"Single Phase - One Element",1.25,{"$f":"C4*60","v":75},null,null,null,null,null,null,"2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Single Phase - Two Element",1.25,{"$f":"C5*60","v":75},null,null,null,null,null,"Single Phase - One Element",{"$f":"H41","v":323.94705024492146},{"$f":"H48","v":330.14151423458412},{"$f":"H55","v":346.31456035471962},{"$f":"H62","v":361.0344068485166},{"$f":"H69","v":367.83092681109753}]
[null,"Multi Phase",1.65,{"$f":"C6*60","v":99},null,null,null,null,null,"Single Phase - Two Element",{"$f":"H42","v":406.42180541188918},{"$f":"H49","v":412.61121442580321},{"$f":"H56","v":431.53859411477794},{"$f":"H63","v":449.63504779794687},{"$f":"H70","v":457.0248459006645}]
[null,"Weighted average install time",1.2732135733570884,null,null,null,null,null,null,"Multi Phase",599.2237827804156,607.3899568406124,634.46960188567493,660.92585192713773,671.13175291291361]
[null,null,null,null,null,null,null,null,null,"Current Transformer (CT)",1610.6318514125492,1626.938936268265,1694.8635659798422,1764.6513440813014,1788.0281736665584]
[null,"CPI",2.5000000000000001E-2]
[null,"Labour Escalation",3.5000000000000003E-2]
[]
[null,"Material costs ($/meter)"]
[null,"Year","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Single Phase - One Element",86.477937499999996,{"$f":"C14*(1+$C$9)","v":88.639885937499983},90.855883085937478,93.127280163085914,95.455462167163049,97.841848721342117]
[null,"Single Phase - Two Element",137.34731249999999,140.78099531249998,144.30052019531246,147.90803320019526,151.60573403020013,155.39587738095511]
[null,"Multi Phase",220,225.49999999999997,231.13749999999996,236.91593749999993,242.83883593749991,248.90980683593739]
[null,"Current Transformer (CT)",474.23,486.08574999999996,498.2378937499999,510.69384109374982,523.46118712109353,536.54771679912085]
[null,null,null,"* please not CTs are supplied only - installed by customer"]
[null,"Labour rate ($/hour) - including labour oncosts"]
[null,"Year","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Labour",71.069999999999993,73.38,{"$f":"D21*(1+C$10)","v":75.948299999999989},{"$f":"E21*(1+C$10)","v":78.606490499999978},{"$f":"F21*(1+C$10)","v":81.357717667499969},{"$f":"G21*(1+C$10)","v":84.205237785862465}]
[null,"Labour OT",101.42,104.72,{"$f":"D22*(1+C$10)","v":108.3852},{"$f":"E22*(1+C$10)","v":112.17868199999999},{"$f":"F22*(1+C$10)","v":116.10493586999999},{"$f":"G22*(1+C$10)","v":120.16860862544998}]
[]
[null,"Oncosts & Overhead Rates"]
[null,"Year","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"General Overhead",0.441,0.43309999999999998,0.40489999999999998,0.41770000000000002,0.43149999999999999,0.41520000000000001]
[null,"Fleet Oncost",0.126,0.11210000000000001,0.1118,0.1116,0.1115,0.1109]
[null,"Material Oncost",4.5999999999999999E-2,5.0900000000000001E-2,4.9299999999999997E-2,4.9500000000000002E-2,5.3699999999999998E-2,4.9799999999999997E-2]
[null,"Corporate Support Overhead",null,7.5715862114390908E-2,6.8924970609191019E-2,6.7853354162277252E-2,6.9548520726403884E-2,6.4065450163485249E-2]
[null,"Capital Allowance",0.27,0.33369488665994801,0.36986850526720699,0.40627784674297102,0.40835810804225697,0.41782987767636198]
[]
[null,"Installation Costs - internal",null,null,null,null,null,"2014-15",null,"Installation Costs - internal (OT)",null,null,null,null,null,"2014-15",null,"Installation Costs - internal (Incremental OT cost)",null,null,null,null,null,"2014-15"]
[null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total"]
[null,"Single Phase - One Element",{"$f":"$C$4*C21","v":88.837499999999991},{"$f":"$C$14","v":86.477937499999996},{"$f":"C34*$C$27+D34*$C$28","v":15.171510124999999},{"$f":"SUM(C34:E34)*$C$26","v":84.004743902624995},{"$f":"C34*$C$30","v":23.986124999999998},{"$f":"SUM(C34:G34)","v":298.47781652762501},null,"Single Phase - One Element",{"$f":"$C$4*C22","v":126.77500000000001},{"$f":"$C$14","v":86.477937499999996},{"$f":"K34*$C$27+L34*$C$28","v":19.951635124999999},{"$f":"SUM(K34:M34)*$C$26","v":102.843216527625},{"$f":"K34*$C$30","v":34.22925},{"$f":"SUM(K34:O34)","v":370.27703915262498},null,"Single Phase - One Element",{"$f":"K34-C34","v":37.937500000000014},{"$f":"L34-D34","v":0},4.780125,18.838472625000009,10.243125000000003,{"$f":"SUM(S34:W34)","v":71.799222625000027}]
[null,"Single Phase - Two Element",{"$f":"$C$5*C21","v":88.837499999999991},{"$f":"$C$15","v":137.34731249999999},{"$f":"C35*$C$27+D35*$C$28","v":17.511501374999998},{"$f":"SUM(C35:E35)*$C$26","v":107.47007441887499},{"$f":"C35*$C$30","v":23.986124999999998},{"$f":"SUM(C35:G35)","v":375.15251329387496},null,"Single Phase - Two Element",{"$f":"$C$5*C22","v":126.77500000000001},{"$f":"$C$15","v":137.34731249999999},{"$f":"K35*$C$27+L35*$C$28","v":22.291626375},{"$f":"SUM(K35:M35)*$C$26","v":126.30854704387502},{"$f":"K35*$C$30","v":34.22925},{"$f":"SUM(K35:O35)","v":446.95173591887504},null,"Single Phase - Two Element",{"$f":"K35-C35","v":37.937500000000014},0,4.7801250000000017,18.838472625000037,10.243125000000003,{"$f":"SUM(S35:W35)","v":71.799222625000056}]
[null,"Multi Phase (DC)",{"$f":"$C$6*C21","v":117.26549999999999},{"$f":"$C$16","v":220},{"$f":"C36*$C$27+D36*$C$28","v":24.895452999999996},{"$f":"SUM(C36:E36)*$C$26","v":159.71298027299997},{"$f":"C36*$C$30","v":31.661684999999999},{"$f":"SUM(C36:G36)","v":553.53561827299995},null,"Multi Phase (DC)",{"$f":"$C$6*C22","v":167.34299999999999},{"$f":"$C$16","v":220},{"$f":"K36*$C$27+L36*$C$28","v":31.205217999999995},{"$f":"SUM(K36:M36)*$C$26","v":184.57976413799997},{"$f":"K36*$C$30","v":45.182609999999997},{"$f":"SUM(K36:O36)","v":648.31059213799983},null,"Multi Phase (DC)",50.077500000000001,0,6.3097649999999987,24.866783865000002,13.520924999999998,{"$f":"SUM(S36:W36)","v":94.774973864999993}]
[null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*C21*2","v":234.53099999999998},{"$f":"C16+$C$17","v":694.23},{"$f":"C37*$C$27+D37*$C$28","v":61.485485999999995},{"$f":"SUM(C37:E37)*$C$26","v":436.69870032599999},{"$f":"C37*$C$30","v":63.323369999999997},{"$f":"SUM(C37:G37)","v":1490.2685563260002},null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*C22*2","v":334.68599999999998},{"$f":"$C$16+$C$17","v":694.23},{"$f":"K37*$C$27+L37*$C$28","v":74.105015999999992},{"$f":"SUM(K37:M37)*$C$26","v":486.43226805599994},{"$f":"K37*$C$30","v":90.365219999999994},{"$f":"SUM(K37:O37)","v":1679.8185040559997},null,"Multi Phase (CT) - 2 man crew",100.155,0,12.619529999999997,49.733567729999947,27.041849999999997,{"$f":"SUM(S37:W37)","v":189.54994772999993}]
[]
[null,"Installation Costs - internal",null,null,null,null,null,"2015-16",null,"Installation Costs - internal (OT)",null,null,null,null,null,"2015-16",null,"Installation Costs - internal (Incremental OT cost)",null,null,null,null,null,"2015-16"]
[null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total"]
[null,"Single Phase - One Element",{"$f":"$C$4*$D$21","v":91.724999999999994},{"$f":"$D$14","v":88.639885937499983},{"$f":"C41*$D$27+D41*$D$28","v":14.794142694218749},{"$f":"SUM(C41:E41)*$D$26+SUM(C41:D41)*$D$29","v":98.179858134318977},{"$f":"C41*$D$30","v":30.608163478883728},{"$f":"SUM(C41:G41)","v":323.94705024492146},null,"Single Phase - One Element",{"$f":"$C$4*$D$22","v":130.9},{"$f":"$D$14","v":88.639885937499983},{"$f":"K41*$D$27+L41*$D$28","v":19.185660194218752},{"$f":"SUM(K41:M41)*$D$26+SUM(K41:L41)*$D$29","v":120.01468576190025},{"$f":"K41*$D$30","v":43.680660663787194},{"$f":"SUM(K41:O41)","v":402.42089255740621},null,"Single Phase - One Element",{"$f":"K41-C41","v":39.175000000000011},{"$f":"L41-D41","v":0},4.3915175000000026,21.834827627581276,13.072497184903465,{"$f":"SUM(S41:W41)","v":78.473842312484763}]
[null,"Single Phase - Two Element",{"$f":"$C$5*$D$21","v":91.724999999999994},{"$f":"$D$15","v":140.78099531249998},{"$f":"C42*$D$27+D42*$D$28","v":17.448125161406249},{"$f":"SUM(C42:E42)*$D$26+SUM(C42:D42)*$D$29","v":125.85952145909926},{"$f":"C42*$D$30","v":30.608163478883728},{"$f":"SUM(C42:G42)","v":406.42180541188918},null,"Single Phase - Two Element",{"$f":"$C$5*$D$22","v":130.9},{"$f":"$D$15","v":140.78099531249998},{"$f":"K42*$D$27+L42*$D$28","v":21.839642661406252},{"$f":"SUM(K42:M42)*$D$26+SUM(K42:L42)*$D$29","v":147.69434908668052},{"$f":"K42*$D$30","v":43.680660663787194},{"$f":"SUM(K42:O42)","v":484.89564772437393},null,"Single Phase - Two Element",{"$f":"K42-C42","v":39.175000000000011},0,4.3915175000000026,21.834827627581262,13.072497184903465,{"$f":"SUM(S42:W42)","v":78.473842312484749}]
[null,"Multi Phase (DC)",{"$f":"$C$6*$D$21","v":121.07699999999998},{"$f":"$D$16","v":225.49999999999997},{"$f":"C43*$D$27+D43*$D$28","v":25.050681699999998},{"$f":"SUM(C43:E43)*$D$26+SUM(C43:D43)*$D$29","v":187.1933252882892},{"$f":"C43*$D$30","v":40.402775792126519},{"$f":"SUM(C43:G43)","v":599.2237827804156},null,"Multi Phase (DC)",{"$f":"$C$6*$D$22","v":172.78799999999998},{"$f":"$D$16","v":225.49999999999997},{"$f":"K43*$D$27+L43*$D$28","v":30.847484799999997},{"$f":"SUM(K43:M43)*$D$26+SUM(K43:L43)*$D$29","v":216.0152977566965},{"$f":"K43*$D$30","v":57.658472076199089},{"$f":"SUM(K43:O43)","v":702.80925463289555},null,"Multi Phase (DC)",51.710999999999999,0,5.7968030999999982,28.821972468407296,17.25569628407257,{"$f":"SUM(S43:W43)","v":103.58547185247986}]
[null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$D$21*2","v":242.15399999999997},{"$f":"$D$17+$D$16","v":711.58574999999996},{"$f":"C44*$D$27+D44*$D$28","v":63.365178074999996},{"$f":"SUM(C44:E44)*$D$26+SUM(C44:D44)*$D$29","v":512.72137175329613},{"$f":"C44*$D$30","v":80.805551584253038},{"$f":"SUM(C44:G44)","v":1610.6318514125492},null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$D$22*2","v":345.57599999999996},{"$f":"$D$17+$D$16","v":711.58574999999996},{"$f":"K44*$D$27+L44*$D$28","v":74.958784274999999},{"$f":"SUM(K44:M44)*$D$26+SUM(K44:L44)*$D$29","v":570.3653166901106},{"$f":"K44*$D$30","v":115.31694415239818},{"$f":"SUM(K44:O44)","v":1817.8027951175088},null,"Multi Phase (CT) - 2 man crew",103.422,0,11.593606200000004,57.643944936814478,34.511392568145141,{"$f":"SUM(S44:W44)","v":207.17094370495963}]
[]
[null,"Installation Costs - internal",null,null,null,null,null,"2016-17",null,"Installation Costs - internal (OT)",null,null,null,null,null,"2016-17",null,"Installation Costs - internal (Incremental OT cost)",null,null,null,null,null,"2016-17"]
[null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total"]
[null,"Single Phase - One Element",{"$f":"$C$4*$E$21","v":94.935374999999993},{"$f":"$E$14","v":90.855883085937478},{"$f":"C48*$E$27+D48*$E$28","v":15.092969961136717},{"$f":"SUM(C48:E48)*$E$26+SUM(C48:D48)*$E$29","v":94.143680939278198},{"$f":"C48*$E$30","v":35.113605248231771},{"$f":"SUM(C48:G48)","v":330.14151423458412},null,"Single Phase - One Element",{"$f":"$C$4*$E$22","v":135.48149999999998},{"$f":"$E$14","v":90.855883085937478},{"$f":"K48*$E$27+L48*$E$28","v":19.626026736136716},{"$f":"SUM(K48:M48)*$E$26+SUM(K48:L48)*$E$29","v":115.19088211391727},{"$f":"K48*$E$30","v":50.1103398963591},{"$f":"SUM(K48:O48)","v":411.26463183235052},null,"Single Phase - One Element",{"$f":"K48-C48","v":40.546124999999989},{"$f":"L48-D48","v":0},4.5330567749999986,21.047201174639071,14.99673464812733,{"$f":"SUM(S48:W48)","v":81.123117597766395}]
[null,"Single Phase - Two Element",{"$f":"$C$5*$E$21","v":94.935374999999993},{"$f":"$E$15","v":144.30052019531246},{"$f":"C49*$E$27+D49*$E$28","v":17.727790570628905},{"$f":"SUM(C49:E49)*$E$26+SUM(C49:D49)*$E$29","v":120.53392341163007},{"$f":"C49*$E$30","v":35.113605248231771},{"$f":"SUM(C49:G49)","v":412.61121442580321},null,"Single Phase - Two Element",{"$f":"$C$5*$E$22","v":135.48149999999998},{"$f":"$E$15","v":144.30052019531246},{"$f":"K49*$E$27+L49*$E$28","v":22.260847345628903},{"$f":"SUM(K49:M49)*$E$26+SUM(K49:L49)*$E$29","v":141.58112458626914},{"$f":"K49*$E$30","v":50.1103398963591},{"$f":"SUM(K49:O49)","v":493.73433202356961},null,"Single Phase - Two Element",{"$f":"K49-C49","v":40.546124999999989},0,4.5330567749999986,21.047201174639071,14.99673464812733,{"$f":"SUM(S49:W49)","v":81.123117597766395}]
[null,"Multi Phase (DC)",{"$f":"$C$6*$E$21","v":125.31469499999997},{"$f":"$E$16","v":231.13749999999996},{"$f":"C50*$E$27+D50*$E$28","v":25.405261650999996},179.18254126194651,46.349958927665931,{"$f":"SUM(C50:G50)","v":607.3899568406124},null,"Multi Phase (DC)",{"$f":"$C$6*$E$22","v":178.83557999999999},{"$f":"$E$16","v":231.13749999999996},{"$f":"K50*$E$27+L50*$E$28","v":31.388896593999995},206.96484681247011,66.145648663194009,{"$f":"SUM(K50:O50)","v":714.47247206966415},null,"Multi Phase (DC)",53.520885000000021,0,5.9836349429999984,27.782305550523603,19.795689735528079,{"$f":"SUM(S50:W50)","v":107.08251522905169}]
[null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$E$21*2","v":250.62938999999994},{"$f":"$E$17+$E$16","v":729.37539374999983},63.978572713874982,490.25566194905821,92.699917855331861,{"$f":"SUM(C51:G51)","v":1626.938936268265},null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$E$22*2","v":357.67115999999999},{"$f":"$E$17+$E$16","v":729.37539374999983},75.945842599874993,545.82027305010547,132.29129732638802,{"$f":"SUM(K51:O51)","v":1841.1039667263685},null,"Multi Phase (CT) - 2 man crew",107.04177000000004,0,11.967269886000011,55.564611101047262,39.591379471056158,{"$f":"SUM(S51:W51)","v":214.16503045810344}]
[]
[null,"Installation Costs - internal",null,null,null,null,null,"2017-18",null,"Installation Costs - internal (OT)",null,null,null,null,null,"2017-18",null,"Installation Costs - internal (Incremental OT cost)",null,null,null,null,null,"2017-18"]
[null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total"]
[null,"Single Phase - One Element",{"$f":"$C$4*$F$21","v":98.258113124999966},{"$f":"$F$14","v":93.127280163085914},{"$f":"C55*$F$27+D55*$F$28","v":15.57540579282275},{"$f":"SUM(C55:E55)*$F$26+SUM(C55:D55)*$F$29","v":99.433666648358738},{"$f":"C55*$F$30","v":39.920094625452244},{"$f":"SUM(C55:G55)","v":346.31456035471962},null,"Single Phase - One Element",{"$f":"$C$4*$F$22","v":140.2233525},{"$f":"$F$14","v":93.127280163085914},{"$f":"K55*$F$27+L55*$F$28","v":20.258726507072751},{"$f":"SUM(K55:M55)*$F$26+SUM(K55:L55)*$F$29","v":121.7662524474551},{"$f":"K55*$F$30","v":56.9696417167806},{"$f":"SUM(K55:O55)","v":432.34525333439433},null,"Single Phase - One Element",{"$f":"K55-C55","v":41.965239375000039},{"$f":"L55-D55","v":0},4.6833207142500015,22.332585799096364,17.049547091328357,{"$f":"SUM(S55:W55)","v":86.030692979674768}]
[null,"Single Phase - Two Element",{"$f":"$C$5*$F$21","v":98.258113124999966},{"$f":"$F$15","v":147.90803320019526},{"$f":"C56*$F$27+D56*$F$28","v":18.287053068159665},{"$f":"SUM(C56:E56)*$F$26+SUM(C56:D56)*$F$29","v":127.16530009597078},{"$f":"C56*$F$30","v":39.920094625452244},{"$f":"SUM(C56:G56)","v":431.53859411477794},null,"Single Phase - Two Element",{"$f":"$C$5*$F$22","v":140.2233525},{"$f":"$F$15","v":147.90803320019526},{"$f":"K56*$F$27+L56*$F$28","v":22.970373782409666},{"$f":"SUM(K56:M56)*$F$26+SUM(K56:L56)*$F$29","v":149.49788589506716},{"$f":"K56*$F$30","v":56.9696417167806},{"$f":"SUM(K56:O56)","v":517.56928709445276},null,"Single Phase - Two Element",{"$f":"K56-C56","v":41.965239375000039},0,4.6833207142500015,22.332585799096378,17.049547091328357,{"$f":"SUM(S56:W56)","v":86.030692979674768}]
[null,"Multi Phase (DC)",{"$f":"$C$6*$F$21","v":129.70070932499996},{"$f":"$F$16","v":236.91593749999993},26.201938066919993,188.95649208815814,52.694524905596964,{"$f":"SUM(C57:G57)","v":634.46960188567493},null,"Multi Phase (DC)",{"$f":"$C$6*$F$22","v":185.09482529999997},{"$f":"$F$16","v":236.91593749999993},32.383921409729993,218.43550534296534,75.19992706615038,{"$f":"SUM(K57:O57)","v":748.03011661884568},null,"Multi Phase (DC)",55.394115975000005,0,6.1819833428099997,29.479013254807199,22.505402160553416,{"$f":"SUM(S57:W57)","v":113.56051473317062}]
[null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$F$21*2","v":259.40141864999993},{"$f":"$F$17+$F$16","v":747.60977859374975},65.955882361730602,516.50743656316808,105.38904981119393,{"$f":"SUM(C58:G58)","v":1694.8635659798422},null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$F$22*2","v":370.18965059999994},{"$f":"$F$17+$F$16","v":747.60977859374975},78.319849047350601,575.46546307278243,150.39985413230076,{"$f":"SUM(K58:O58)","v":1921.9845954461834},null,"Multi Phase (CT) - 2 man crew",110.78823195000001,0,12.363966685619999,58.958026509614342,45.010804321106832,{"$f":"SUM(S58:W58)","v":227.12102946634118}]
[]
[null,"Installation Costs - internal",null,null,null,null,null,"2018-19",null,"Installation Costs - internal (OT)",null,null,null,null,null,"2018-19",null,"Installation Costs - internal (Incremental OT cost)",null,null,null,null,null,"2018-19"]
[null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total"]
[null,"Single Phase - One Element",{"$f":"$C$4*$G$21","v":101.69714708437496},{"$f":"$G$14","v":95.455462167163049},{"$f":"C62*$G$27+D62*$G$28","v":16.465190218284462},{"$f":"SUM(C62:E62)*$G$26+SUM(C62:D62)*$G$29","v":105.8877528020236},{"$f":"C62*$G$30","v":41.52885457667049},{"$f":"SUM(C62:G62)","v":361.0344068485166},null,"Single Phase - One Element",{"$f":"$C$4*$G$22","v":145.13116983749998},{"$f":"$G$14","v":95.455462167163049},{"$f":"K62*$G$27+L62*$G$28","v":21.308083755257904},{"$f":"SUM(K62:M62)*$G$26+SUM(K62:L62)*$G$29","v":129.7400142128779},{"$f":"K62*$G$30","v":59.265489932800961},{"$f":"SUM(K62:O62)","v":450.90021990559978},null,"Single Phase - One Element",{"$f":"K62-C62","v":43.434022753125021},{"$f":"L62-D62","v":0},4.8428935369734418,23.852261410854297,17.736635356130471,{"$f":"SUM(S62:W62)","v":89.865813057083244}]
[null,"Single Phase - Two Element",{"$f":"$C$5*$G$21","v":101.69714708437496},{"$f":"$G$15","v":151.60573403020013},{"$f":"C63*$G$27+D63*$G$28","v":19.480459817329553},{"$f":"SUM(C63:E63)*$G$26+SUM(C63:D63)*$G$29","v":135.3228522893717},{"$f":"C63*$G$30","v":41.52885457667049},{"$f":"SUM(C63:G63)","v":449.63504779794687},null,"Single Phase - Two Element",{"$f":"$C$5*$G$22","v":145.13116983749998},{"$f":"$G$15","v":151.60573403020013},{"$f":"K63*$G$27+L63*$G$28","v":24.323353354302995},{"$f":"SUM(K63:M63)*$G$26+SUM(K63:L63)*$G$29","v":159.17511370022601},{"$f":"K63*$G$30","v":59.265489932800961},{"$f":"SUM(K63:O63)","v":539.50086085503006},null,"Single Phase - Two Element",{"$f":"K63-C63","v":43.434022753125021},0,4.8428935369734418,23.852261410854311,17.736635356130471,{"$f":"SUM(S63:W63)","v":89.865813057083244}]
[null,"Multi Phase (DC)",{"$f":"$C$6*$G$21","v":134.24023415137495},{"$f":"$G$16","v":242.83883593749991},28.008231597722052,201.02046219933575,54.818088041205044,{"$f":"SUM(C64:G64)","v":660.92585192713773},null,"Multi Phase (DC)",{"$f":"$C$6*$G$22","v":191.57314418549998},{"$f":"$G$16","v":242.83883593749991},34.400851066526997,232.50544726166351,78.230446711297276,{"$f":"SUM(K64:O64)","v":779.54872516248781},null,"Multi Phase (DC)",57.332910034125035,0,6.3926194688049449,31.484985062327752,23.412358670092232,{"$f":"SUM(S64:W64)","v":118.62287323534997}]
[null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$G$21*2","v":268.4804683027499},{"$f":"$G$17+$G$16","v":766.30002305859341},71.085883454003081,549.14879318354474,109.63617608241009,{"$f":"SUM(C65:G65)","v":1764.6513440813014},null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$G$22*2","v":383.14628837099997},{"$f":"$G$17+$G$16","v":766.30002305859341},83.871122391612971,612.11876330820007,156.46089342259455,{"$f":"SUM(K65:O65)","v":2001.8970905520011},null,"Multi Phase (CT) - 2 man crew",114.66582006825007,0,12.78523893760989,62.969970124655333,46.824717340184463,{"$f":"SUM(S65:W65)","v":237.24574647069977}]
[]
[null,"Installation Costs - internal",null,null,null,null,null,"2019-20",null,"Installation Costs - internal (OT)",null,null,null,null,null,"2019-20",null,"Installation Costs - internal (Incremental OT cost)",null,null,null,null,null,"2019-20"]
[null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total",null,"Year","Labour","Materials","Oncosts","Overheads","Allowance","Total"]
[null,"Single Phase - One Element",{"$f":"$C$4*$H$21","v":105.25654723232807},{"$f":"$H$14","v":97.841848721342117},{"$f":"C69*$H$27+D69*$H$28","v":16.545475154388022},{"$f":"SUM(C69:E69)*$H$26+SUM(C69:D69)*$H$29","v":104.20772544831942},{"$f":"C69*$H$30","v":43.979330254719855},{"$f":"SUM(C69:G69)","v":367.83092681109753},null,"Single Phase - One Element",{"$f":"$C$4*$H$22","v":150.21076078181247},{"$f":"$H$14","v":97.841848721342117},{"$f":"K69*$H$27+L69*$H$28","v":21.530897437025843},{"$f":"SUM(K69:M69)*$H$26+SUM(K69:L69)*$H$29","v":127.82267417360974},{"$f":"K69*$H$30","v":62.762543803137973},{"$f":"SUM(K69:O69)","v":460.16872491692817},null,"Single Phase - One Element",{"$f":"K69-C69","v":44.954213549484393},{"$f":"L69-D69","v":0},4.9854222826378205,23.614948725290319,18.783213548418118,{"$f":"SUM(S69:W69)","v":92.337798105830657}]
[null,"Single Phase - Two Element",{"$f":"$C$5*$H$21","v":105.25654723232807},{"$f":"$H$15","v":155.39587738095511},{"$f":"C70*$H$27+D70*$H$28","v":19.411665781636749},{"$f":"SUM(C70:E70)*$H$26+SUM(C70:D70)*$H$29","v":132.98142525102466},{"$f":"C70*$H$30","v":43.979330254719855},{"$f":"SUM(C70:G70)","v":457.0248459006645},null,"Single Phase - Two Element",{"$f":"$C$5*$H$22","v":150.21076078181247},{"$f":"$H$15","v":155.39587738095511},{"$f":"K70*$H$27+L70*$H$28","v":24.39708806427457},{"$f":"SUM(K70:M70)*$H$26+SUM(K70:L70)*$H$29","v":156.59637397631494},{"$f":"K70*$H$30","v":62.762543803137973},{"$f":"SUM(K70:O70)","v":549.36264400649509},null,"Single Phase - Two Element",{"$f":"K70-C70","v":44.954213549484393},0,4.9854222826378205,23.614948725290276,18.783213548418118,{"$f":"SUM(S70:W70)","v":92.337798105830601}]
[null,"Multi Phase (DC)",{"$f":"$C$6*$H$21","v":138.93864234667305},{"$f":"$H$16","v":248.90980683593739},27.804003816675724,197.4265839773972,58.052715936230207,{"$f":"SUM(C71:G71)","v":671.13175291291361},null,"Multi Phase (DC)",{"$f":"$C$6*$H$22","v":198.27820423199245},{"$f":"$H$16","v":248.90980683593739},34.384761229757643,228.5983162947804,82.846557820142124,{"$f":"SUM(K71:O71)","v":793.01764641261002},null,"Multi Phase (DC)",59.339561885319398,0,6.5807574130819191,31.171732317383203,24.793841883911917,{"$f":"SUM(S71:W71)","v":121.88589349969644}]
[null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$H$21*2","v":277.8772846933461},{"$f":"$H$17+$H$16","v":785.45752363505824},69.932375549517985,538.65555791617578,116.10543187246041,{"$f":"SUM(C72:G72)","v":1788.0281736665584},null,"Multi Phase (CT) - 2 man crew",{"$f":"$C$6*$H$22*2","v":396.55640846398489},{"$f":"$H$17+$H$16","v":785.45752363505824},83.093890375681823,600.9990225509423,165.69311564028425,{"$f":"SUM(K72:O72)","v":2031.7999606659516},null,"Multi Phase (CT) - 2 man crew",118.6791237706388,0,13.161514826163838,62.343464634766519,49.587683767823833,{"$f":"SUM(S72:W72)","v":243.77178699939299}]

{"sheet":"INPUTS","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Demand Forecast","index":5,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Forecast of NTCs for 2015 -2020"]
[]
["Actual Average NTC's"]
["Financial Year","Primary","Growth","% Growth","% of Total","CL","Growth","% Growth","% of Total","FiT","Growth","% Growth","% of Total","Total","Growth","%"]
["2012 Avg",{"$f":"AVERAGE('PIVOT NMI''s'!H7:H18)","v":1336804.25},null,null,{"$f":"IF($N5=0,0,B5/$N5)","v":0.61334648349478227},{"$f":"AVERAGE('PIVOT NMI''s'!K7:K18)","v":726987.41666666663},null,null,{"$f":"IF($N5=0,0,F5/$N5)","v":0.33355308045845605},{"$f":"AVERAGE('PIVOT NMI''s'!B7:B18)","v":115733.75},null,null,{"$f":"IF($N5=0,0,J5/$N5)","v":5.3100436046761713E-2},{"$f":"J5+F5+B5","v":2179525.4166666665}]
["2013 Avg",{"$f":"AVERAGE('PIVOT NMI''s'!H20:H31)","v":1350042.1666666667},{"$f":"B6-B5","v":13237.916666666744},{"$f":"C6/B5","v":9.9026590218176998E-3},{"$f":"IF($N6=0,0,B6/$N6)","v":0.59310893379404983},{"$f":"AVERAGE('PIVOT NMI''s'!K20:K31)","v":730678.83333333337},{"$f":"F6-F5","v":3691.4166666667443},{"$f":"G6/F5","v":5.077689904995024E-3},{"$f":"IF($N6=0,0,F6/$N6)","v":0.32100637630766365},{"$f":"AVERAGE('PIVOT NMI''s'!B20:B31)","v":195491.83333333334},{"$f":"J6-J5","v":79758.083333333343},{"$f":"K6/J5","v":0.68915146474847089},{"$f":"IF($N6=0,0,J6/$N6)","v":8.5884689898286459E-2},{"$f":"J6+F6+B6","v":2276212.8333333335},{"$f":"N6-N5","v":96687.416666666977},{"$f":"N6/N5-1","v":4.436168347811198E-2}]
["2014 Avg",{"$f":"AVERAGE('PIVOT NMI''s'!H33:H44)","v":1364633.3333333333},{"$f":"B7-B6","v":14591.166666666511},{"$f":"C7/B6","v":1.0807934023789018E-2},{"$f":"IF($N7=0,0,B7/$N7)","v":0.58234633839017846},{"$f":"AVERAGE('PIVOT NMI''s'!K33:K44)","v":733470.83333333337},{"$f":"F7-F6","v":2792},{"$f":"G7/F6","v":3.8211042562475575E-3},{"$f":"IF($N7=0,0,F7/$N7)","v":0.31300279985416812},{"$f":"AVERAGE('PIVOT NMI''s'!B33:B44)","v":245232.16666666666},{"$f":"J7-J6","v":49740.333333333314},{"$f":"K7/J6","v":0.25443688611033188},{"$f":"IF($N7=0,0,J7/$N7)","v":0.10465086175565352},{"$f":"J7+F7+B7","v":2343336.333333333},{"$f":"N7-N6","v":67123.499999999534},{"$f":"N7/N6-1","v":2.9489114118429027E-2}]
[]
[]
["Average growth",null,null,{"$f":"AVERAGE(D5:D8)","v":1.035529652280336E-2},{"$f":"AVERAGE(E5:E8)","v":0.59626725189300345},null,null,{"$f":"AVERAGE(H5:H8)","v":4.4493970806212908E-3},{"$f":"AVERAGE(I5:I8)","v":0.32252075220676263},null,null,{"$f":"AVERAGE(L5:L8)","v":0.47179417542940139},{"$f":"AVERAGE(M5:M8)","v":8.1211995900233896E-2},null,null,{"$f":"AVERAGE(P5:P8)","v":3.6925398798270503E-2}]
["Applicable growth"]
[]
["Forecast NTCs"]
["FY Average","Primary","Growth","% Growth",null,"CL","Growth","% Growth",null,"FiT","Growth","% Growth",null,"Total",null,"check"]
[2015,{"$f":"B7*(1+D10)","v":1378764.5161449015},{"$f":"B15-B7","v":14131.182811568258},{"$f":"D10","v":1.035529652280336E-2},{"$f":"B15/N15","v":0.56742433745481413},{"$f":"F7*(1+H10)","v":736734.33631788753},{"$f":"F15-F7","v":3263.5029845541576},{"$f":"G15/F15","v":4.4296876413616963E-3},{"$f":"F15/N15","v":0.30319970362615239},{"$f":"J7+K15","v":288232.16666666663},43000,{"$f":"K15/J7","v":0.1753440447249647},{"$f":"J15/N15","v":0.11862065224980779},{"$f":"N7*(1+$P$10)","v":2429864.9619601434},{"$f":"N15-N7","v":86528.628626810387},{"$f":"N15/N7-1","v":3.6925398798270503E-2}]
[{"$f":"A15+1","v":2016},{"$f":"B15*(1+$D$10)","v":1393042.0315447014},{"$f":"B16-B15","v":14277.515399799915},null,0.55288469680444885,{"$f":"F15*(1+$H$10)","v":740012.3599230937},{"$f":"F16-F15","v":3278.0236052061664},null,0.2937036356282372,{"$f":"J15+K16","v":323232.16666666663},35000,{"$f":"K16/J15","v":0.12142988898416961},0.12828767145437736,{"$f":"N15*(1+$P$10)","v":2519588.694706466},{"$f":"N16-N15","v":89723.732746322639},{"$f":"N16/N15-1","v":3.6925398798270503E-2}]
[{"$f":"A16+1","v":2017},{"$f":"B16*(1+$D$10)","v":1407467.3948500752},{"$f":"B17-B16","v":14425.363305373816},null,0.53871761886647973,{"$f":"F16*(1+$H$10)","v":743304.96875695908},{"$f":"F17-F16","v":3292.608833865379},null,0.28450497988482809,{"$f":"J16+K17","v":353232.16666666663},30000,{"$f":"K17/J16","v":9.2812544956076479E-2},0.13520198935335498,{"$f":"N16*(1+$P$10)","v":2612625.5120661161},{"$f":"N17-N16","v":93036.817359650042},{"$f":"N17/N16-1","v":3.6925398798270503E-2}]
[{"$f":"A17+1","v":2018},{"$f":"B17*(1+$D$10)","v":1422042.1370699252},{"$f":"B18-B17","v":14574.742219849955},null,0.52491355712060361,{"$f":"F17*(1+$H$10)","v":746612.22771495755},{"$f":"F18-F17","v":3307.2589579984779},null,0.27559442158803305,{"$f":"J17+K18","v":382232.16666666663},29000,{"$f":"K18/J17","v":8.2098978339552889E-2},0.14109205418084564,{"$f":"N17*(1+$P$10)","v":2709097.7510096929},{"$f":"N18-N17","v":96472.238943576813},{"$f":"N18/N17-1","v":3.6925398798270503E-2}]
[{"$f":"A18+1","v":2019},{"$f":"B18*(1+$D$10)","v":1436767.8050672051},{"$f":"B19-B18","v":14725.667997279903},null,0.51146320966587122,{"$f":"F18*(1+$H$10)","v":749934.20198130852},{"$f":"F19-F18","v":3321.9742663509678},null,0.26696293766523571,{"$f":"J18+K19","v":409232.16666666663},27000,{"$f":"K19/J18","v":7.0637697071544228E-2},0.14567920907168549,{"$f":"N18*(1+$P$10)","v":2809132.2658492234},{"$f":"N19-N18","v":100034.51483953046},{"$f":"N19/N18-1","v":3.6925398798270503E-2}]
[{"$f":"A19+1","v":2020},{"$f":"B19*(1+$D$10)","v":1451645.9617230932},{"$f":"B20-B19","v":14878.156655888073},null,0.4983575129525778,{"$f":"F19*(1+$H$10)","v":753270.9570302621},{"$f":"F20-F19","v":3336.7550489535788},null,0.25860178764208769,{"$f":"J19+K20","v":434232.16666666663},25000,{"$f":"K20/J19","v":6.1090016954516047E-2},0.1490741326260713,{"$f":"N19*(1+$P$10)","v":2912860.5950427949},{"$f":"N20-N19","v":103728.32919357158},{"$f":"N20/N19-1","v":3.6925398798270503E-2}]
[]
["* no churn incorporated on the basis that as customers churn"]
[null,"The exit fee will recover return of assets"]
[null,"the rest of the opex costs will disappear as the meter is removed"]
[null,"thus as meters move revenue will decrease but costs will decrease on a proportional basis."]
[]
["Actual Average NTC's"]
["EndFinancial Year","Primary","Growth","% Growth","%","CL","Growth","% Growth","%","FiT","Growth","% Growth","%","Total","Growth","% Growth"]
["2012 Closing",{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"SAC - Non Demand\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1112\")","v":1343590},null,null,{"$f":"IF($N29=0,0,B29/$N29)","v":0.60501768550644042},{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"CL\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1112\")","v":728844},null,null,{"$f":"IF($N29=0,0,F29/$N29)","v":0.32819796960029179},{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"Photovoltaic\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1112\")","v":148311},null,null,{"$f":"IF($N29=0,0,J29/$N29)","v":6.6784344893267802E-2},{"$f":"J29+F29+B29","v":2220745}]
["2013 Closing",{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"SAC - Non Demand\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1213\")","v":1356079},{"$f":"B30-B29","v":12489},{"$f":"C30/B29","v":9.2952463177010843E-3},{"$f":"IF($N30=0,0,B30/$N30)","v":0.58700856047567429},{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"CL\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1213\")","v":731862},{"$f":"F30-F29","v":3018},{"$f":"G30/F29","v":4.1408037934043502E-3},{"$f":"IF($N30=0,0,F30/$N30)","v":0.31680253074256587},{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"Photovoltaic\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1213\")","v":222211},{"$f":"J30-J29","v":73900},{"$f":"K30/J29","v":0.49827726871236794},{"$f":"IF($N30=0,0,J30/$N30)","v":9.6188908781759813E-2},{"$f":"J30+F30+B30","v":2310152},{"$f":"N30-N29","v":89407},{"$f":"O30/N29","v":4.0259912777018521E-2}]
["2014 Closing",{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"SAC - Non Demand\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1314\")","v":1372607},{"$f":"B31-B30","v":16528},{"$f":"C31/B30","v":1.2188080487936175E-2},{"$f":"IF($N31=0,0,B31/$N31)","v":0.57967662267239439},{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"CL\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1314\")","v":734274},{"$f":"F31-F30","v":2412},{"$f":"G31/F30","v":3.295703288324848E-3},{"$f":"IF($N31=0,0,F31/$N31)","v":0.31009711624387004},{"$f":"GETPIVOTDATA(\"NMI No\",'PIVOT NMI''s'!$A$3,\"Group\",\"Photovoltaic\",\"MONTH\",\"JUN\",\"FIN YEAR\",\"1314\")","v":261003},{"$f":"J31-J30","v":38792},{"$f":"K31/J30","v":0.17457281592720433},{"$f":"IF($N31=0,0,J31/$N31)","v":0.11022626108373552},{"$f":"J31+F31+B31","v":2367884},{"$f":"N31-N30","v":57732},{"$f":"O31/N30","v":2.4990563391499781E-2}]
[]
[]
["Average growth",null,null,{"$f":"AVERAGE(D29:D32)","v":1.0741663402818629E-2},{"$f":"AVERAGE(E29:E32)","v":0.59056762288483633},null,null,{"$f":"AVERAGE(H29:H32)","v":3.7182535408645991E-3},{"$f":"AVERAGE(I29:I32)","v":0.31836587219557588},null,null,{"$f":"AVERAGE(L29:L32)","v":0.33642504231978615},{"$f":"AVERAGE(M29:M32)","v":9.1066504919587718E-2},null,null,{"$f":"AVERAGE(P29:P32)","v":3.2625238084259149E-2}]
[]
["Forecast NTCs"]
["End Financial Year","Primary","Growth","% Growth","%","CL","Growth","% Growth","%","FiT","Growth","% Growth","%","Total",null,"check"]
[2015,{"$f":"B31*(1+D34)","v":1387351.0823783525},{"$f":"B38-B31","v":14744.082378352527},{"$f":"C38/B31","v":1.0741663402818525E-2},{"$f":"B38/N38","v":0.57131234826029309},{"$f":"F31*(1+H34)","v":737004.21690046485},{"$f":"F38-F31","v":2730.2169004648458},{"$f":"G38/F31","v":3.7182535408646442E-3},{"$f":"F38/N38","v":0.30349895940782012},{"$f":"J31+K38","v":304003},43000,{"$f":"K38/J31","v":0.16474906418700169},{"$f":"J38/N38","v":0.12518869233188692},{"$f":"B38+F38+J38","v":2428358.2992788171},null,{"$f":"N38/N31-1","v":2.5539384226092698E-2}]
[{"$f":"A38+1","v":2016},{"$f":"B38*(1+$D$34)","v":1402253.5407267967},{"$f":"B39-B38","v":14902.458348444197},null,0.56519665627622817,{"$f":"F38*(1+$H$34)","v":739744.58543958713},{"$f":"F39-F38","v":2740.3685391222825},null,0.29816374431987158,{"$f":"J38+K39","v":339003},35000,null,0.13663959940390022,2481001.1261663837,null,{"$f":"N39/N38-1","v":2.1678360604034719E-2}]
[{"$f":"A39+1","v":2017},{"$f":"B39*(1+$D$34)","v":1417316.0762666946},{"$f":"B40-B39","v":15062.535539897857},null,0.56046666665526246,{"$f":"F39*(1+$H$34)","v":742495.14336373331},{"$f":"F40-F39","v":2750.5579241461819},null,0.29361395455623662,{"$f":"J39+K40","v":369003},30000,null,0.14591937878850103,2528814.2196304277,null,{"$f":"N40/N39-1","v":1.9271693575538373E-2}]
[{"$f":"A40+1","v":2018},{"$f":"B40*(1+$D$34)","v":1432540.4084933549},{"$f":"B41-B40","v":15224.332226660335},null,0.55615372979028466,{"$f":"F40*(1+$H$34)","v":745255.92855962028},{"$f":"F41-F40","v":2760.7851958869724},null,0.28932996365015096,{"$f":"J40+K41","v":398003},29000,null,0.1545163065595643,2575799.3370529753,null,{"$f":"N41/N40-1","v":1.8579900831708462E-2}]
[{"$f":"A41+1","v":2019},{"$f":"B41*(1+$D$34)","v":1447928.2753723268},{"$f":"B42-B41","v":15387.866878971923},null,0.55244232636157931,{"$f":"F41*(1+$H$34)","v":748026.97905483749},{"$f":"F42-F41","v":2771.050495217205},null,0.28540209589043075,{"$f":"J41+K42","v":425003},27000,null,0.16215557774798992,2620958.2544271643,null,{"$f":"N42/N41-1","v":1.7532001318804724E-2}]
[{"$f":"A42+1","v":2020},{"$f":"B42*(1+$D$34)","v":1463481.4335377999},{"$f":"B43-B42","v":15553.158165473025},null,0.54929452645306565,{"$f":"F42*(1+$H$34)","v":750808.33301837044},{"$f":"F43-F42","v":2781.3539635329507},null,0.28180399032830594,{"$f":"J42+K43","v":450003},25000,null,0.16890148321862838,2664292.7665561703,null,{"$f":"N43/N42-1","v":1.6533842939240984E-2}]
[]
["Forecast NTCs"]
["Average","Primary","Growth","% Growth","%","CL","Growth","% Growth","%","FiT","Growth","% Growth","%","Total",null,"check"]
[2015,{"$f":"(B38-B31)/2+B31","v":1379979.0411891763},null,null,{"$f":"B47/N47","v":0.52626932072887811},{"$f":"(F38-F31)/2+F31","v":735639.10845023242},null,null,{"$f":"F47/N47","v":0.28054360417828195},{"$f":"(J38-J31)/2+J31","v":282503},null,null,{"$f":"J47/N47","v":0.10773544921794886},{"$f":"N40*(1+$P$10)","v":2622191.6931770183},null,{"$f":"N47/N40-1","v":3.6925398798270503E-2}]
[{"$f":"A47+1","v":2016},{"$f":"(B39-B38)/2+B38","v":1394802.3115525746},{"$f":"B48-B47","v":14823.270363398362},{"$f":"C48/B47","v":1.0741663402818517E-2},0.51298032553531936,{"$f":"(F39-F38)/2+F38","v":738374.40117002605},{"$f":"F48-F47","v":2735.2927197936224},{"$f":"G48/F47","v":3.7182535408646928E-3},0.27155930094317837,{"$f":"(J39-J38)/2+J38","v":321503},{"$f":"J48-J47","v":39000},{"$f":"K48/J47","v":0.13805163131010997},0.11824235752592187,{"$f":"N47*(1+$P$10)","v":2719017.1671730918},null,{"$f":"N48/N47-1","v":3.6925398798270503E-2}]
[{"$f":"A48+1","v":2017},{"$f":"(B40-B39)/2+B39","v":1409784.8084967458},{"$f":"B49-B48","v":14982.496944171144},null,0.5000268950161556,{"$f":"(F40-F39)/2+F39","v":741119.86440166016},{"$f":"F49-F48","v":2745.4632316341158},null,0.26286271663453797,{"$f":"(J40-J39)/2+J39","v":354003},{"$f":"J49-J48","v":32500},null,0.12555889370460097,{"$f":"N48*(1+$P$10)","v":2819417.960410302},null,{"$f":"N49/N48-1","v":3.6925398798270503E-2}]
[{"$f":"A49+1","v":2018},{"$f":"(B41-B40)/2+B40","v":1424928.2423800249},{"$f":"B50-B49","v":15143.433883279096},null,0.48740055572030472,{"$f":"(F41-F40)/2+F40","v":743875.53596167685},{"$f":"F50-F49","v":2755.6715600166935},null,0.25444463716213267,{"$f":"(J41-J40)/2+J40","v":383503},{"$f":"J50-J49","v":29500},null,0.13117823744457235,{"$f":"N49*(1+$P$10)","v":2923526.0929774591},null,{"$f":"N50/N49-1","v":3.6925398798270503E-2}]
[{"$f":"A50+1","v":2019},{"$f":"(B42-B41)/2+B41","v":1440234.3419328409},{"$f":"B51-B50","v":15306.099552816013},null,0.47509304816251224,{"$f":"(F42-F41)/2+F41","v":746641.45380722894},{"$f":"F51-F50","v":2765.9178455520887},null,0.24629614351350262,{"$f":"(J42-J41)/2+J41","v":411503},{"$f":"J51-J50","v":28000},null,0.13574333627932245,{"$f":"N50*(1+$P$10)","v":3031478.4598578014},null,{"$f":"N51/N50-1","v":3.6925398798270503E-2}]
[{"$f":"A51+1","v":2020},{"$f":"(B43-B42)/2+B42","v":1455704.8544550634},{"$f":"B52-B51","v":15470.512522222474},null,0.4630963214204315,{"$f":"(F43-F42)/2+F42","v":749417.65603660396},{"$f":"F52-F51","v":2776.2022293750197},null,0.23840860230420205,{"$f":"(J43-J42)/2+J42","v":437503},{"$f":"J52-J51","v":26000},null,0.13918070637076202,{"$f":"N51*(1+$P$10)","v":3143417.0109364176},null,{"$f":"N52/N51-1","v":3.6925398798270503E-2}]

{"sheet":"PIVOT NMI's","index":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of NMI No","Column Labels"]
[null,"Photovoltaic","SAC - Non Demand",null,null,null,null,"SAC - Non Demand Total","CL",null,"CL Total","Grand Total"]
["Row Labels",null,7600,8400,8500,8800,8900,null,9000,9100]
["1112"]
["JUL",83543,null,1216105,98961,15162,null,1330228,214689,511181,725870,2139641]
["AUG",91647,null,1217679,99002,15111,null,1331792,214449,511537,725986,2149425]
["SEP",98076,null,1218940,99110,15041,null,1333091,214234,511922,726156,2157323]
["OCT",106435,null,1219720,99166,15043,null,1333929,214132,512119,726251,2166615]
["NOV",110735,null,1221304,99162,15023,null,1335489,214052,512451,726503,2172727]
["DEC",113788,null,1222025,99119,15008,null,1336152,213957,512703,726660,2176600]
["JAN",117616,null,1222681,99136,14990,null,1336807,213911,512959,726870,2181293]
["FEB",121452,null,1223975,99252,14926,null,1338153,213784,513257,727041,2186646]
["MAR",126377,null,1225179,99303,14923,null,1339405,213725,513739,727464,2193246]
["APR",131241,null,1226357,99302,14918,null,1340577,213671,514062,727733,2199551]
["MAY",139584,null,1228204,99322,14912,null,1342438,213679,514792,728471,2210493]
["JUN",148311,null,1229433,99320,14837,null,1343590,213524,515320,728844,2220745]
["1213"]
["JUL",157849,null,1230924,98438,14268,1,1343631,213302,515838,729140,2230620]
["AUG",167385,null,1232077,98364,14231,2,1344674,213229,516314,729543,2241602]
["SEP",175458,null,1232973,98327,14188,3,1345491,213202,516612,729814,2250763]
["OCT",184155,null,1234598,98717,14486,5,1347806,213270,516871,730141,2262102]
["NOV",192007,null,1235911,98755,14512,9,1349187,213363,517103,730466,2271660]
["DEC",197320,null,1237019,98800,14530,11,1350360,213452,517439,730891,2278571]
["JAN",202555,null,1237334,98795,14529,17,1350675,213491,517516,731007,2284237]
["FEB",206666,null,1238302,98816,14551,20,1351689,213481,517574,731055,2289410]
["MAR",209574,null,1239110,98832,14542,21,1352505,213522,517689,731211,2293290]
["APR",212687,null,1240086,98821,14550,25,1353482,213539,517844,731383,2297552]
["MAY",218035,null,1241451,98830,14551,95,1354927,213573,518060,731633,2304595]
["JUN",222211,null,1242547,98884,14552,96,1356079,213508,518354,731862,2310152]
["1314"]
["JUL",228856,null,1243991,98903,14524,100,1357518,213473,518744,732217,2318591]
["AUG",233821,null,1245430,98922,14426,105,1358883,213521,518984,732505,2325209]
["SEP",236565,null,1246737,98978,14417,116,1360248,213612,519177,732789,2329602]
["OCT",239135,1,1248082,99050,14420,130,1361683,213743,519323,733066,2333884]
["NOV",241389,1,1249149,99080,14411,138,1362779,213933,519347,733280,2337448]
["DEC",243867,1,1250422,99124,14405,141,1364093,214139,519427,733566,2341526]
["JAN",245970,1,1250784,99106,14439,144,1364474,214266,519414,733680,2344124]
["FEB",248326,null,1252178,99111,14474,154,1365917,214453,519485,733938,2348181]
["MAR",251568,null,1253626,99145,14505,160,1367436,214576,519429,734005,2353009]
["APR",254310,null,1255163,99169,14511,162,1369005,214662,519442,734104,2357419]
["MAY",257976,null,1257135,99137,14516,169,1370957,214712,519514,734226,2363159]
["JUN",261003,null,1258812,99137,14483,175,1372607,214761,519513,734274,2367884]
["Grand Total",6677493,4,44525443,3563396,526915,1999,48617757,7698590,18595055,26293645,81588895]

{"sheet":"NMIs Per NTC","index":7,"n_rows":497,"n_cols":9,"rows_kept":497,"cut":false,"hidden":false,"merged":[]}
["NTC","NTC Desc","Group","Category","Date","MONTH","YEAR","FIN YEAR","NMI No"]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2012-08-31","AUG","2012","1213",10]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2012-09-30","SEP","2012","1213",193]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2012-10-31","OCT","2012","1213",844]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2012-11-30","NOV","2012","1213",2031]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2012-12-31","DEC","2012","1213",4515]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-01-31","JAN","2013","1213",7027]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-02-28","FEB","2013","1213",9322]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-03-31","MAR","2013","1213",11301]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-04-30","APR","2013","1213",13462]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-05-31","MAY","2013","1213",16823]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-06-30","JUN","2013","1213",19027]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-07-31","JUL","2013","1314",21589]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-08-31","AUG","2013","1314",25871]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-09-30","SEP","2013","1314",28990]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-10-31","OCT","2013","1314",32198]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-11-30","NOV","2013","1314",35164]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2013-12-31","DEC","2013","1314",38377]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2014-01-31","JAN","2014","1314",41099]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2014-02-28","FEB","2014","1314",44030]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2014-03-31","MAR","2014","1314",47974]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2014-04-30","APR","2014","1314",51363]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2014-05-31","MAY","2014","1314",55737]
[7500,"7500 - Solar PV 2 (net with FIT)","Photovoltaic","FIXED","2014-06-30","JUN","2014","1314",59308]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314",1]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314",1]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314",1]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314",1]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314"]
[7600,"7600 - Residential - PeakSmart","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314"]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2011-07-31","JUL","2011","1112",5231]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2011-08-31","AUG","2011","1112",5356]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2011-09-30","SEP","2011","1112",5398]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2011-10-31","OCT","2011","1112",5529]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2011-11-30","NOV","2011","1112",5554]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2011-12-31","DEC","2011","1112",5799]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-01-31","JAN","2012","1112",6343]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-02-29","FEB","2012","1112",6363]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-03-31","MAR","2012","1112",6372]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-04-30","APR","2012","1112",6401]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-05-31","MAY","2012","1112",6441]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-06-30","JUN","2012","1112",6596]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-07-31","JUL","2012","1213",9149]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-08-31","AUG","2012","1213",9264]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-09-30","SEP","2012","1213",9289]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-10-31","OCT","2012","1213",8629]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-11-30","NOV","2012","1213",8598]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2012-12-31","DEC","2012","1213",8587]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-01-31","JAN","2013","1213",8592]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-02-28","FEB","2013","1213",8581]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-03-31","MAR","2013","1213",8583]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-04-30","APR","2013","1213",8580]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-05-31","MAY","2013","1213",8583]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-06-30","JUN","2013","1213",8579]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-07-31","JUL","2013","1314",8590]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-08-31","AUG","2013","1314",8787]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-09-30","SEP","2013","1314",8783]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-10-31","OCT","2013","1314",8784]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-11-30","NOV","2013","1314",8804]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2013-12-31","DEC","2013","1314",8820]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2014-01-31","JAN","2014","1314",8830]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2014-02-28","FEB","2014","1314",8847]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2014-03-31","MAR","2014","1314",8854]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2014-04-30","APR","2014","1314",8869]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2014-05-31","MAY","2014","1314",8915]
[8300,"8300 - Demand Small","SAC - Demand","FIXED","2014-06-30","JUN","2014","1314",8962]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2011-07-31","JUL","2011","1112",1216105]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2011-08-31","AUG","2011","1112",1217679]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2011-09-30","SEP","2011","1112",1218940]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2011-10-31","OCT","2011","1112",1219720]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2011-11-30","NOV","2011","1112",1221304]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2011-12-31","DEC","2011","1112",1222025]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-01-31","JAN","2012","1112",1222681]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-02-29","FEB","2012","1112",1223975]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-03-31","MAR","2012","1112",1225179]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-04-30","APR","2012","1112",1226357]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-05-31","MAY","2012","1112",1228204]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-06-30","JUN","2012","1112",1229433]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-07-31","JUL","2012","1213",1230924]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-08-31","AUG","2012","1213",1232077]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-09-30","SEP","2012","1213",1232973]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-10-31","OCT","2012","1213",1234598]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-11-30","NOV","2012","1213",1235911]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2012-12-31","DEC","2012","1213",1237019]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-01-31","JAN","2013","1213",1237334]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-02-28","FEB","2013","1213",1238302]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-03-31","MAR","2013","1213",1239110]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-04-30","APR","2013","1213",1240086]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-05-31","MAY","2013","1213",1241451]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-06-30","JUN","2013","1213",1242547]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314",1243991]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314",1245430]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314",1246737]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314",1248082]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314",1249149]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314",1250422]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314",1250784]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314",1252178]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314",1253626]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314",1255163]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314",1257135]
[8400,"8400 - Residential Flat","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314",1258812]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-07-31","JUL","2011","1112",78182]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-08-31","AUG","2011","1112",79434]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-09-30","SEP","2011","1112",80167]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-10-31","OCT","2011","1112",80799]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-11-30","NOV","2011","1112",80854]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-12-31","DEC","2011","1112",80846]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-01-31","JAN","2012","1112",80885]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-02-29","FEB","2012","1112",81007]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-03-31","MAR","2012","1112",81070]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-04-30","APR","2012","1112",81095]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-05-31","MAY","2012","1112",81142]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-06-30","JUN","2012","1112",81218]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-07-31","JUL","2012","1213",81457]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-08-31","AUG","2012","1213",81523]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-09-30","SEP","2012","1213",81579]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-10-31","OCT","2012","1213",82076]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-11-30","NOV","2012","1213",98608]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-12-31","DEC","2012","1213",98800]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-01-31","JAN","2013","1213",98795]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-02-28","FEB","2013","1213",98816]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-03-31","MAR","2013","1213",98832]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-04-30","APR","2013","1213",98821]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-05-31","MAY","2013","1213",98830]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-06-30","JUN","2013","1213",98884]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314",98903]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314",98922]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314",98978]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314",99050]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314",99080]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314",99124]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314",99106]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314",99111]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314",99145]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314",99169]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314",99137]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314",99137]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-07-31","JUL","2011","1112",20779]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-08-31","AUG","2011","1112",19568]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-09-30","SEP","2011","1112",18943]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-10-31","OCT","2011","1112",18367]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-11-30","NOV","2011","1112",18308]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2011-12-31","DEC","2011","1112",18273]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-01-31","JAN","2012","1112",18251]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-02-29","FEB","2012","1112",18245]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-03-31","MAR","2012","1112",18233]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-04-30","APR","2012","1112",18207]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-05-31","MAY","2012","1112",18180]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-06-30","JUN","2012","1112",18102]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-07-31","JUL","2012","1213",16981]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-08-31","AUG","2012","1213",16841]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-09-30","SEP","2012","1213",16748]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-10-31","OCT","2012","1213",16641]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-11-30","NOV","2012","1213",147]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2012-12-31","DEC","2012","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-01-31","JAN","2013","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-02-28","FEB","2013","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-03-31","MAR","2013","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-04-30","APR","2013","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-05-31","MAY","2013","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-06-30","JUN","2013","1213"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314"]
[8500,"8500 - Business Flat","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-07-31","JUL","2011","1112",6666]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-08-31","AUG","2011","1112",6623]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-09-30","SEP","2011","1112",6617]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-10-31","OCT","2011","1112",6626]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-11-30","NOV","2011","1112",6618]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-12-31","DEC","2011","1112",6620]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-01-31","JAN","2012","1112",6621]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-02-29","FEB","2012","1112",6596]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-03-31","MAR","2012","1112",6604]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-04-30","APR","2012","1112",6612]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-05-31","MAY","2012","1112",6622]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-06-30","JUN","2012","1112",6621]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-07-31","JUL","2012","1213",6573]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-08-31","AUG","2012","1213",6534]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-09-30","SEP","2012","1213",6477]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-10-31","OCT","2012","1213",6417]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-11-30","NOV","2012","1213",60]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-12-31","DEC","2012","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-01-31","JAN","2013","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-02-28","FEB","2013","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-03-31","MAR","2013","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-04-30","APR","2013","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-05-31","MAY","2013","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-06-30","JUN","2013","1213"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314"]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-07-31","JUL","2011","1112",8496]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-08-31","AUG","2011","1112",8488]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-09-30","SEP","2011","1112",8424]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-10-31","OCT","2011","1112",8417]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-11-30","NOV","2011","1112",8405]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2011-12-31","DEC","2011","1112",8388]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-01-31","JAN","2012","1112",8369]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-02-29","FEB","2012","1112",8330]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-03-31","MAR","2012","1112",8319]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-04-30","APR","2012","1112",8306]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-05-31","MAY","2012","1112",8290]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-06-30","JUN","2012","1112",8216]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-07-31","JUL","2012","1213",7695]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-08-31","AUG","2012","1213",7697]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-09-30","SEP","2012","1213",7711]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-10-31","OCT","2012","1213",8069]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-11-30","NOV","2012","1213",14452]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2012-12-31","DEC","2012","1213",14530]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-01-31","JAN","2013","1213",14529]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-02-28","FEB","2013","1213",14551]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-03-31","MAR","2013","1213",14542]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-04-30","APR","2013","1213",14550]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-05-31","MAY","2013","1213",14551]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-06-30","JUN","2013","1213",14552]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314",14524]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314",14426]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314",14417]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314",14420]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314",14411]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314",14405]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314",14439]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314",14474]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314",14505]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314",14511]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314",14516]
[8800,"8800 - Business - TOU","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314",14483]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2012-07-31","JUL","2012","1213",1]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2012-08-31","AUG","2012","1213",2]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2012-09-30","SEP","2012","1213",3]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2012-10-31","OCT","2012","1213",5]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2012-11-30","NOV","2012","1213",9]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2012-12-31","DEC","2012","1213",11]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-01-31","JAN","2013","1213",17]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-02-28","FEB","2013","1213",20]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-03-31","MAR","2013","1213",21]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-04-30","APR","2013","1213",25]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-05-31","MAY","2013","1213",95]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-06-30","JUN","2013","1213",96]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-07-31","JUL","2013","1314",100]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-08-31","AUG","2013","1314",105]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-09-30","SEP","2013","1314",116]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-10-31","OCT","2013","1314",130]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-11-30","NOV","2013","1314",138]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2013-12-31","DEC","2013","1314",141]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2014-01-31","JAN","2014","1314",144]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2014-02-28","FEB","2014","1314",154]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2014-03-31","MAR","2014","1314",160]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2014-04-30","APR","2014","1314",162]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2014-05-31","MAY","2014","1314",169]
[8900,"8900 - Residential TOU","SAC - Non Demand","FIXED","2014-06-30","JUN","2014","1314",175]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2011-07-31","JUL","2011","1112",214689]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2011-08-31","AUG","2011","1112",214449]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2011-09-30","SEP","2011","1112",214234]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2011-10-31","OCT","2011","1112",214132]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2011-11-30","NOV","2011","1112",214052]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2011-12-31","DEC","2011","1112",213957]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-01-31","JAN","2012","1112",213911]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-02-29","FEB","2012","1112",213784]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-03-31","MAR","2012","1112",213725]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-04-30","APR","2012","1112",213671]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-05-31","MAY","2012","1112",213679]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-06-30","JUN","2012","1112",213524]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-07-31","JUL","2012","1213",213302]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-08-31","AUG","2012","1213",213229]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-09-30","SEP","2012","1213",213202]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-10-31","OCT","2012","1213",213270]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-11-30","NOV","2012","1213",213363]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2012-12-31","DEC","2012","1213",213452]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-01-31","JAN","2013","1213",213491]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-02-28","FEB","2013","1213",213481]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-03-31","MAR","2013","1213",213522]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-04-30","APR","2013","1213",213539]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-05-31","MAY","2013","1213",213573]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-06-30","JUN","2013","1213",213508]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-07-31","JUL","2013","1314",213473]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-08-31","AUG","2013","1314",213521]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-09-30","SEP","2013","1314",213612]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-10-31","OCT","2013","1314",213743]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-11-30","NOV","2013","1314",213933]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2013-12-31","DEC","2013","1314",214139]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2014-01-31","JAN","2014","1314",214266]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2014-02-28","FEB","2014","1314",214453]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2014-03-31","MAR","2014","1314",214576]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2014-04-30","APR","2014","1314",214662]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2014-05-31","MAY","2014","1314",214712]
[9000,"9000 - Controlled Load 1 (super economy)","CL","FIXED","2014-06-30","JUN","2014","1314",214761]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2011-07-31","JUL","2011","1112",511181]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2011-08-31","AUG","2011","1112",511537]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2011-09-30","SEP","2011","1112",511922]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2011-10-31","OCT","2011","1112",512119]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2011-11-30","NOV","2011","1112",512451]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2011-12-31","DEC","2011","1112",512703]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-01-31","JAN","2012","1112",512959]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-02-29","FEB","2012","1112",513257]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-03-31","MAR","2012","1112",513739]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-04-30","APR","2012","1112",514062]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-05-31","MAY","2012","1112",514792]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-06-30","JUN","2012","1112",515320]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-07-31","JUL","2012","1213",515838]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-08-31","AUG","2012","1213",516314]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-09-30","SEP","2012","1213",516612]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-10-31","OCT","2012","1213",516871]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-11-30","NOV","2012","1213",517103]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2012-12-31","DEC","2012","1213",517439]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-01-31","JAN","2013","1213",517516]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-02-28","FEB","2013","1213",517574]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-03-31","MAR","2013","1213",517689]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-04-30","APR","2013","1213",517844]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-05-31","MAY","2013","1213",518060]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-06-30","JUN","2013","1213",518354]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-07-31","JUL","2013","1314",518744]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-08-31","AUG","2013","1314",518984]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-09-30","SEP","2013","1314",519177]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-10-31","OCT","2013","1314",519323]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-11-30","NOV","2013","1314",519347]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2013-12-31","DEC","2013","1314",519427]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2014-01-31","JAN","2014","1314",519414]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2014-02-28","FEB","2014","1314",519485]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2014-03-31","MAR","2014","1314",519429]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2014-04-30","APR","2014","1314",519442]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2014-05-31","MAY","2014","1314",519514]
[9100,"9100 - Controlled Load 2 (economy)","CL","FIXED","2014-06-30","JUN","2014","1314",519513]
[9300,"9300 - Streetlights - Rate 2","Streetlights","FIXED","2011-09-30","SEP","2011","1112"]
[9300,"9300 - Streetlights - Rate 2","Streetlights","FIXED","2011-10-31","OCT","2011","1112"]
[9300,"9300 - Streetlights - Rate 2","Streetlights","FIXED","2011-11-30","NOV","2011","1112"]
[9300,"9300 - Streetlights - Rate 2","Streetlights","FIXED","2011-12-31","DEC","2011","1112"]
[9300,"9300 - Streetlights - Rate 2","Streetlights","FIXED","2012-01-31","JAN","2012","1112"]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2011-07-31","JUL","2011","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2011-08-31","AUG","2011","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2011-09-30","SEP","2011","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2011-10-31","OCT","2011","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2011-11-30","NOV","2011","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2011-12-31","DEC","2011","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2012-01-31","JAN","2012","1112",55]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2012-02-29","FEB","2012","1112",57]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2012-03-31","MAR","2012","1112",57]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2012-04-30","APR","2012","1112",57]
[9400,"9400 - Streetlights - Rate 3","Streetlights","FIXED","2012-05-31","MAY","2012","1112",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-06-30","JUN","2012","1112",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-07-31","JUL","2012","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-08-31","AUG","2012","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-09-30","SEP","2012","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-10-31","OCT","2012","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-11-30","NOV","2012","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2012-12-31","DEC","2012","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-01-31","JAN","2013","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-02-28","FEB","2013","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-03-31","MAR","2013","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-04-30","APR","2013","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-05-31","MAY","2013","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-06-30","JUN","2013","1213",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-07-31","JUL","2013","1314",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-08-31","AUG","2013","1314",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-09-30","SEP","2013","1314",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-10-31","OCT","2013","1314",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-11-30","NOV","2013","1314",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2013-12-31","DEC","2013","1314",57]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2014-01-31","JAN","2014","1314",58]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2014-02-28","FEB","2014","1314",58]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2014-03-31","MAR","2014","1314",58]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2014-04-30","APR","2014","1314",58]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2014-05-31","MAY","2014","1314",58]
[9600,"9600 - Unmetered Supply","UMS & WML","FIXED","2014-06-30","JUN","2014","1314",58]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2011-07-31","JUL","2011","1112",669]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2011-08-31","AUG","2011","1112",664]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2011-09-30","SEP","2011","1112",655]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2011-10-31","OCT","2011","1112",641]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2011-11-30","NOV","2011","1112",629]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2011-12-31","DEC","2011","1112",621]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-01-31","JAN","2012","1112",608]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-02-29","FEB","2012","1112",599]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-03-31","MAR","2012","1112",589]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-04-30","APR","2012","1112",583]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-05-31","MAY","2012","1112",572]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-06-30","JUN","2012","1112",570]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-07-31","JUL","2012","1213",563]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-08-31","AUG","2012","1213",550]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-09-30","SEP","2012","1213",546]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-10-31","OCT","2012","1213",537]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-11-30","NOV","2012","1213",531]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2012-12-31","DEC","2012","1213",524]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-01-31","JAN","2013","1213",521]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-02-28","FEB","2013","1213",520]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-03-31","MAR","2013","1213",515]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-04-30","APR","2013","1213",514]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-05-31","MAY","2013","1213",510]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-06-30","JUN","2013","1213",508]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-07-31","JUL","2013","1314",500]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-08-31","AUG","2013","1314",497]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-09-30","SEP","2013","1314",495]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-10-31","OCT","2013","1314",493]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-11-30","NOV","2013","1314",494]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2013-12-31","DEC","2013","1314",493]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2014-01-31","JAN","2014","1314",491]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2014-02-28","FEB","2014","1314",490]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2014-03-31","MAR","2014","1314",489]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2014-04-30","APR","2014","1314",485]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2014-05-31","MAY","2014","1314",482]
[9700,"9700 - Solar PV (gross)","Photovoltaic","FIXED","2014-06-30","JUN","2014","1314",481]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2011-07-31","JUL","2011","1112",180]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2011-08-31","AUG","2011","1112",184]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2011-09-30","SEP","2011","1112",184]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2011-10-31","OCT","2011","1112",195]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2011-11-30","NOV","2011","1112",211]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2011-12-31","DEC","2011","1112",214]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-01-31","JAN","2012","1112",226]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-02-29","FEB","2012","1112",240]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-03-31","MAR","2012","1112",251]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-04-30","APR","2012","1112",267]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-05-31","MAY","2012","1112",292]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-06-30","JUN","2012","1112",304]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-07-31","JUL","2012","1213",178]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-08-31","AUG","2012","1213",160]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-09-30","SEP","2012","1213",172]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-10-31","OCT","2012","1213",185]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-11-30","NOV","2012","1213",199]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2012-12-31","DEC","2012","1213",215]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-01-31","JAN","2013","1213",222]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-02-28","FEB","2013","1213",237]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-03-31","MAR","2013","1213",248]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-04-30","APR","2013","1213",273]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-05-31","MAY","2013","1213",292]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-06-30","JUN","2013","1213",313]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-07-31","JUL","2013","1314",335]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-08-31","AUG","2013","1314",375]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-09-30","SEP","2013","1314",399]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-10-31","OCT","2013","1314",444]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-11-30","NOV","2013","1314",461]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2013-12-31","DEC","2013","1314",486]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2014-01-31","JAN","2014","1314",514]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2014-02-28","FEB","2014","1314",549]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2014-03-31","MAR","2014","1314",585]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2014-04-30","APR","2014","1314",620]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2014-05-31","MAY","2014","1314",672]
[9800,"9800 - Solar PV (net)","Photovoltaic","FIXED","2014-06-30","JUN","2014","1314",728]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2011-07-31","JUL","2011","1112",82694]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2011-08-31","AUG","2011","1112",90799]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2011-09-30","SEP","2011","1112",97237]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2011-10-31","OCT","2011","1112",105599]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2011-11-30","NOV","2011","1112",109895]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2011-12-31","DEC","2011","1112",112953]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-01-31","JAN","2012","1112",116782]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-02-29","FEB","2012","1112",120613]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-03-31","MAR","2012","1112",125537]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-04-30","APR","2012","1112",130391]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-05-31","MAY","2012","1112",138720]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-06-30","JUN","2012","1112",147437]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-07-31","JUL","2012","1213",157108]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-08-31","AUG","2012","1213",166665]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-09-30","SEP","2012","1213",174547]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-10-31","OCT","2012","1213",182589]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-11-30","NOV","2012","1213",189246]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2012-12-31","DEC","2012","1213",192066]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-01-31","JAN","2013","1213",194785]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-02-28","FEB","2013","1213",196587]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-03-31","MAR","2013","1213",197510]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-04-30","APR","2013","1213",198438]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-05-31","MAY","2013","1213",200410]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-06-30","JUN","2013","1213",202363]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-07-31","JUL","2013","1314",206432]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-08-31","AUG","2013","1314",207078]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-09-30","SEP","2013","1314",206681]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-10-31","OCT","2013","1314",206000]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-11-30","NOV","2013","1314",205270]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2013-12-31","DEC","2013","1314",204511]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2014-01-31","JAN","2014","1314",203866]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2014-02-28","FEB","2014","1314",203257]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2014-03-31","MAR","2014","1314",202520]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2014-04-30","APR","2014","1314",201842]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2014-05-31","MAY","2014","1314",201085]
[9900,"9900 - Solar PV (net with FIT)","Photovoltaic","FIXED","2014-06-30","JUN","2014","1314",200486]

{"sheet":"NMI profile assessment","index":8,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"SUM(E2:J2)","v":1379583},"Primary",{"$f":"SUMIF(E$31:E$60,\"SAC\",$C$31:$C$60)","v":1376204},3323,56,0,0,0]
[null,null,{"$f":"SUM(E3:J3)","v":734143},"CL",{"$f":"SUMIF(E$31:E$60,\"CL\",$C$31:$C$60)","v":125},717541,16425,52,0,0]
[null,null,{"$f":"SUM(E4:J4)","v":254496},"FIT",{"$f":"SUMIF(E$31:E$60,\"FIT\",$C$31:$C$60)","v":0},84706,162890,6882,18,0]
[null,"NTC's",{"$f":"SUM(C2:C4)","v":2368222}]
[]
[null,{"$f":"C7/$C$27","v":0.41461598207986605},{"$f":"C40","v":570648},"Primary Only"]
[null,0.39241126213281852,{"$f":"C41","v":540087},"Primary + CL"]
[null,5.9636903676373891E-3,{"$f":"C42","v":8208},"Primary + 2xCL"]
[null,6.1540518291774711E-2,{"$f":"C32+C46","v":84700},"Primary + FiT"]
[null,2.1797113916803322E-6,{"$f":"C36+C47","v":3},"Primary + 2xFiT"]
[null,0.11819485021386601,{"$f":"C33+C44","v":162675},"Primary + CL + FiT"]
[null,4.7713882363882472E-3,{"$f":"C34+C43","v":6567},"Primary + 2xCL + FiT"]
[null,7.2657046389344407E-7,{"$f":"C45","v":1},"Primary + CL + 2xFiT"]
[null,1.4531409277868881E-6,{"$f":"C35","v":2},"Primary + 2xCL + 2xFiT"]
[null,1.0157455085230349E-3,{"$f":"C48","v":1398},"2x Primary"]
[null,9.5616673048377237E-4,{"$f":"C49","v":1316},"2x Primary + CL"]
[null,1.0898556958401661E-5,{"$f":"C50","v":15},"2x Primary + CLx2"]
[null,1.533063678815167E-4,{"$f":"C37+C53","v":211},"2x Primary + FiT"]
[null,2.2451027334307423E-4,{"$f":"C38+C52","v":309},"2x Primary + CL + FiT"]
[null,5.8125637111475525E-6,{"$f":"C51","v":8},"2x Primary + 2xCL + FiT"]
[null,1.7437691133442658E-5,{"$f":"C54","v":24},"3x Primary"]
[null,1.5257979741762325E-5,{"$f":"C55","v":21},"3x Primary + CL"]
[null,2.1797113916803322E-6,{"$f":"C57","v":3},"3x Primary + FiT"]
[null,5.8125637111475525E-6,{"$f":"C39+C56","v":8},"3x Primary + CL + FiT"]
[null,9.0821307986680515E-5,{"$f":"C31","v":125},"CL Only"]
[null,"NMI's",{"$f":"SUM(C7:C26)","v":1376329}]
[]
[]
[null,"Date","NMIs","Tariffs","NTC1","NTC2","NTC3","NTC4","NTC5","NTC6"]
[null,"APR2014",125,{"$f":"9-COUNTBLANK(E31:J31)","v":4},"CL","","","","",""]
[null,"APR2014",18696,2,"SAC","FIT","",""]
[null,"APR2014",31829,3,"SAC","CL","FIT",""]
[null,"APR2014",975,4,"SAC","CL","CL","FIT"]
[null,"APR2014",2,5,"SAC","CL","CL","FIT","FIT"]
[null,"APR2014",1,3,"SAC","FIT","FIT",""]
[null,"APR2014",36,3,"SAC","SAC","FIT",""]
[null,"APR2014",44,4,"SAC","SAC","CL","FIT"]
[null,"APR2014",2,5,"SAC","SAC","SAC","CL","FIT"]
[null,"APR2014",570648,1,"SAC","","","","",""]
[null,"APR2014",540087,2,"SAC","CL","","","",""]
[null,"APR2014",8208,3,"SAC","CL","CL","","",""]
[null,"APR2014",5592,4,"SAC","CL","CL","FIT","",""]
[null,"APR2014",130846,3,"SAC","CL","FIT","","",""]
[null,"APR2014",1,4,"SAC","CL","FIT","FIT","",""]
[null,"APR2014",66004,2,"SAC","FIT","","","",""]
[null,"APR2014",2,3,"SAC","FIT","FIT","","",""]
[null,"APR2014",1398,2,"SAC","SAC","","","",""]
[null,"APR2014",1316,3,"SAC","SAC","CL","","",""]
[null,"APR2014",15,4,"SAC","SAC","CL","CL","",""]
[null,"APR2014",8,5,"SAC","SAC","CL","CL","FIT",""]
[null,"APR2014",265,4,"SAC","SAC","CL","FIT","",""]
[null,"APR2014",175,3,"SAC","SAC","FIT","","",""]
[null,"APR2014",24,3,"SAC","SAC","SAC","","",""]
[null,"APR2014",21,4,"SAC","SAC","SAC","CL","",""]
[null,"APR2014",6,5,"SAC","SAC","SAC","CL","FIT",""]
[null,"APR2014",3,4,"SAC","SAC","SAC","FIT","",""]
[null,"APR2014",1,{"$f":"9-COUNTBLANK(E58:J58)","v":5},"SACD","CL","","","",""]
[null,"APR2014",3,{"$f":"9-COUNTBLANK(E59:J59)","v":5},"SACD","FIT","","","",""]
[null,"APR2014",10,{"$f":"9-COUNTBLANK(E60:J60)","v":5},"SACD","SAC","","","",""]

{"sheet":"NMI impact analysis","index":9,"n_rows":389,"n_cols":12,"rows_kept":389,"cut":false,"hidden":false,"merged":[[8,4,8,6]]}
[]
[null,"Please note that this information does contain a minimal number of inactive but not decommissioned NMI's"]
[]
[null,null,null,"NMI"]
[null,"FEB2014",null,{"$f":"SUMIF($A$40:$A$389,B5,$C$40:$C$389)","v":1362783}]
[null,"MAR2014",null,{"$f":"SUMIF($A$40:$A$389,B6,$C$40:$C$389)","v":1364367}]
[null,"APR2014",null,{"$f":"SUMIF($A$40:$A$389,B7,$C$40:$C$389)","v":1365940}]
[]
[null,null,null,null,"NTC's"]
["NTC","NTC Desc","MSC",null,{"$f":"B5","v":"FEB2014"},{"$f":"B6","v":"MAR2014"},{"$f":"B7","v":"APR2014"}]
[7500,"7500 - Solar PV 2 (net with FIT)",{"$f":"'EGX Only -> OUTPUT'!$E$23","v":24.7},null,{"$f":"SUMIFS($C$40:$C$389,$A$40:$A$389,E$10,$F$40:$F$389,$A11)+SUMIFS($C$40:$C$389,$A$40:$A$389,E$10,$G$40:$G$389,$A11)+SUMIFS($C$40:$C$389,$A$40:$A$389,E$10,$H$40:$H$389,$A11)+SUMIFS($C$40:$C$389,$A$40:$A$389,E$10,$I$40:$I$389,$A11)+SUMIFS($C$40:$C$389,$A$40:$A$389,E$10,$J$40:$J$389,$A11)+SUMIFS($C$40:$C$389,$A$40:$A$389,E$10,$K$40:$K$389,$A11)","v":44065},48147,51585]
[7600,"7600 - Residential - PeakSmart",{"$f":"'EGX Only -> OUTPUT'!$E$21","v":35.29},null,0,0,0]
[8300,"8300 - Demand Small",null,null,14,14,14]
[8400,"8400 - Residential Flat",{"$f":"'EGX Only -> OUTPUT'!$E$21","v":35.29},null,1252233,1253743,1255282]
[8500,"8500 - Business Flat",{"$f":"'EGX Only -> OUTPUT'!$E$21","v":35.29},null,99165,99195,99209]
[8800,"8800 - Business - TOU",{"$f":"'EGX Only -> OUTPUT'!$E$21","v":35.29},null,14476,14508,14510]
[8900,"8900 - Residential TOU",{"$f":"'EGX Only -> OUTPUT'!$E$21","v":35.29},null,154,160,163]
[9000,"9000 - Controlled Load 1 (super economy)",{"$f":"'EGX Only -> OUTPUT'!$E$22","v":10.58},null,214458,214578,214673]
[9100,"9100 - Controlled Load 2 (economy)",{"$f":"'EGX Only -> OUTPUT'!$E$22","v":10.58},null,519500,519431,519469,null,null,1]
[9700,"9700 - Solar PV (gross)",{"$f":"'EGX Only -> OUTPUT'!$E$23","v":24.7},null,496,495,491]
[9800,"9800 - Solar PV (net)",{"$f":"'EGX Only -> OUTPUT'!$E$23","v":24.7},null,549,587,623]
[9900,"9900 - Solar PV (net with FIT)",{"$f":"'EGX Only -> OUTPUT'!$E$23","v":24.7},null,203242,202502,201794]
[null,null,null,null,{"$f":"SUM(E11:E22)","v":2348352},{"$f":"SUM(F11:F22)","v":2353360},{"$f":"SUM(G11:G22)","v":2357813}]
[]
[null,null,null,"Date",null,null,null,"Average Rates applicable"]
[null,"Classification","Values","FEB2014","MAR2014","APR2014",null,"FEB","MAR","APR"]
[null,"Bus","NMI's",110269,110339,110370]
[null,null,"_MSC",4040207.3899999997,4044050.28,4046442.77,null,{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"FEB2014\",\"Classification\",\"Bus\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"FEB2014\",\"Classification\",\"Bus\")","v":36.639557717944299},{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"MAR2014\",\"Classification\",\"Bus\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"MAR2014\",\"Classification\",\"Bus\")","v":36.651141300899951},{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"APR2014\",\"Classification\",\"Bus\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"APR2014\",\"Classification\",\"Bus\")","v":36.662523964845519}]
[null,"Res","NMI's",1249675,1251196,1252751]
[null,null,"_MSC",57841608.790000007,57977757.860000014,58100840.289999992,null,{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"FEB2014\",\"Classification\",\"Res\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"FEB2014\",\"Classification\",\"Res\")","v":46.285321215516042},{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"MAR2014\",\"Classification\",\"Res\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"MAR2014\",\"Classification\",\"Res\")","v":46.337870213779468},{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"APR2014\",\"Classification\",\"Res\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"APR2014\",\"Classification\",\"Res\")","v":46.378602204268837}]
[null,"Res / Bus","NMI's",2712,2707,2694]
[null,null,"_MSC",223538.31999999998,223256.0199999999,222391.45999999996,null,{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"FEB2014\",\"Classification\",\"Res / Bus\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"FEB2014\",\"Classification\",\"Res / Bus\")","v":82.425634218289076},{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"MAR2014\",\"Classification\",\"Res / Bus\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"MAR2014\",\"Classification\",\"Res / Bus\")","v":82.473594384927935},{"$f":"GETPIVOTDATA(\"_MSC\",$B$25,\"Date\",\"APR2014\",\"Classification\",\"Res / Bus\")/GETPIVOTDATA(\"NMI's\",$B$25,\"Date\",\"APR2014\",\"Classification\",\"Res / Bus\")","v":82.550653303637702}]
[null,"CL","NMI's",127,125,125]
[null,null,"_MSC",1343.6599999999999,1322.5,1322.5]
[null,"Total NMI's",null,1362783,1364367,1365940]
[null,"Total _MSC",null,62106698.160000004,62246386.660000019,62370997.019999996]
[]
[]
["Date","Classification","NMIs","NTC Count","Total Tariffs","NTC1","NTC2","NTC3","NTC4","NTC5","MSC","Tot MSC"]
["MAR2014","Res / Bus",591,2,{"$f":"C40*D40","v":1182},8400,8500,"","","",{"$f":"IF(ISERROR(VLOOKUP(F40,$A$11:$C$22,3,FALSE)),0,VLOOKUP(F40,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(G40,$A$11:$C$22,3,FALSE)),0,VLOOKUP(G40,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(H40,$A$11:$C$22,3,FALSE)),0,VLOOKUP(H40,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(I40,$A$11:$C$22,3,FALSE)),0,VLOOKUP(I40,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(J40,$A$11:$C$22,3,FALSE)),0,VLOOKUP(J40,$A$11:$C$22,3,FALSE))","v":70.58},{"$f":"C40*K40","v":41712.78}]
["MAR2014","Res / Bus",24,3,72,8400,8500,8800,"","",105.87,2540.88]
["MAR2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",116.45,1048.05]
["MAR2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,141.15,141.15]
["MAR2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,141.15,423.45000000000005]
["MAR2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",116.45,1397.4]
["MAR2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,141.15,282.3]
["MAR2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",130.57,391.71]
["MAR2014","Res / Bus",242,3,726,8400,8500,9000,"","",81.16,19640.719999999998]
["MAR2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",91.74,825.66]
["MAR2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,116.44,582.20000000000005]
["MAR2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",105.86,4975.42]
["MAR2014","Res / Bus",711,3,2133,8400,8500,9100,"","",81.16,57704.759999999995]
["MAR2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",105.86,105.86]
["MAR2014","Res / Bus",113,4,452,8400,8500,9100,9900,"",105.86,11962.18]
["MAR2014","Res / Bus",4,3,12,8400,8500,9800,"","",95.28,381.12]
["MAR2014","Res / Bus",111,3,333,8400,8500,9900,"","",95.28,10576.08]
["MAR2014","Res / Bus",253,2,506,8400,8800,"","","",70.58,17856.739999999998]
["MAR2014","Res / Bus",87,3,261,8400,8800,9000,"","",81.16,7060.92]
["MAR2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",91.74,550.43999999999994]
["MAR2014","Res / Bus",4,5,20,8400,8800,9000,9100,9900,116.44,465.76]
["MAR2014","Res / Bus",1,4,4,8400,8800,9000,9800,"",105.86,105.86]
["MAR2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",105.86,3493.38]
["MAR2014","Res / Bus",250,3,750,8400,8800,9100,"","",81.16,20290]
["MAR2014","Res / Bus",3,4,12,8400,8800,9100,9800,"",105.86,317.58]
["MAR2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",105.86,7092.62]
["MAR2014","Res / Bus",2,3,6,8400,8800,9800,"","",95.28,190.56]
["MAR2014","Res / Bus",41,3,123,8400,8800,9900,"","",95.28,3906.48]
["MAR2014","Res",143645,2,287290,8400,9000,"","","",45.87,6588996.1499999994]
["MAR2014","Res",8208,3,24624,8400,9000,9100,"","",56.449999999999996,463341.6]
["MAR2014","Res",7,4,28,8400,9000,9100,9700,"",81.149999999999991,568.04999999999995]
["MAR2014","Res",7,4,28,8400,9000,9100,9800,"",81.149999999999991,568.04999999999995]
["MAR2014","Res",5579,4,22316,8400,9000,9100,9900,"",81.149999999999991,452735.85]
["MAR2014","Res",60,3,180,8400,9000,9700,"","",70.569999999999993,4234.2]
["MAR2014","Res",1,4,4,8400,9000,9700,9900,"",95.27,95.27]
["MAR2014","Res",38,3,114,8400,9000,9800,"","",70.569999999999993,2681.66]
["MAR2014","Res",44996,3,134988,8400,9000,9900,"","",70.569999999999993,3175367.7199999997]
["MAR2014","Res",394489,2,788978,8400,9100,"","","",45.87,18095210.43]
["MAR2014","Res",170,3,510,8400,9100,9700,"","",70.569999999999993,11996.9]
["MAR2014","Res",81,3,243,8400,9100,9800,"","",70.569999999999993,5716.1699999999992]
["MAR2014","Res",85505,3,256515,8400,9100,9900,"","",70.569999999999993,6034087.8499999996]
["MAR2014","Res",244,2,488,8400,9700,"","","",59.989999999999995,14637.56]
["MAR2014","Res",2,3,6,8400,9700,9900,"","",84.69,169.38]
["MAR2014","Res",126,2,252,8400,9800,"","","",59.989999999999995,7558.74]
["MAR2014","Res",63362,2,126724,8400,9900,"","","",59.989999999999995,3801086.38]
["MAR2014","Bus",90812,1,90812,8500,"","","","",35.29,3204755.48]
["MAR2014","Bus",554,2,1108,8500,8800,"","","",70.58,39101.32]
["MAR2014","Bus",6,3,18,8500,8800,9000,"","",81.16,486.96]
["MAR2014","Bus",30,3,90,8500,8800,9100,"","",81.16,2434.7999999999997]
["MAR2014","Bus",1,4,4,8500,8800,9100,9800,"",105.86,105.86]
["MAR2014","Bus",1,4,4,8500,8800,9100,9900,"",105.86,105.86]
["MAR2014","Bus",2,3,6,8500,8800,9800,"","",95.28,190.56]
["MAR2014","Bus",14,3,42,8500,8800,9900,"","",95.28,1333.92]
["MAR2014","Bus",482,2,964,8500,9000,"","","",45.87,22109.34]
["MAR2014","Bus",9,3,27,8500,9000,9100,"","",56.449999999999996,508.04999999999995]
["MAR2014","Bus",3,4,12,8500,9000,9100,9900,"",81.149999999999991,243.45]
["MAR2014","Bus",5,3,15,8500,9000,9800,"","",70.569999999999993,352.84999999999997]
["MAR2014","Bus",91,3,273,8500,9000,9900,"","",70.569999999999993,6421.869999999999]
["MAR2014","Bus",2436,2,4872,8500,9100,"","","",45.87,111739.31999999999]
["MAR2014","Bus",1,3,3,8500,9100,9700,"","",70.569999999999993,70.569999999999993]
["MAR2014","Bus",18,3,54,8500,9100,9800,"","",70.569999999999993,1270.2599999999998]
["MAR2014","Bus",201,3,603,8500,9100,9900,"","",70.569999999999993,14184.569999999998]
["MAR2014","Bus",5,2,10,8500,9700,"","","",59.989999999999995,299.95]
["MAR2014","Bus",230,2,460,8500,9800,"","","",59.989999999999995,13797.699999999999]
["MAR2014","Bus",1878,2,{"$f":"C104*D104","v":3756},8500,9900,"","","",{"$f":"IF(ISERROR(VLOOKUP(F104,$A$11:$C$22,3,FALSE)),0,VLOOKUP(F104,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(G104,$A$11:$C$22,3,FALSE)),0,VLOOKUP(G104,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(H104,$A$11:$C$22,3,FALSE)),0,VLOOKUP(H104,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(I104,$A$11:$C$22,3,FALSE)),0,VLOOKUP(I104,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(J104,$A$11:$C$22,3,FALSE)),0,VLOOKUP(J104,$A$11:$C$22,3,FALSE))","v":59.989999999999995},{"$f":"C104*K104","v":112661.21999999999}]
["MAR2014","Bus",4,1,4,8600,"","","","",0,0]
["MAR2014","Bus",1,1,1,8700,"","","","",0,0]
["MAR2014","Bus",1,2,2,8700,8800,"","","",35.29,35.29]
["MAR2014","Bus",11936,1,11936,8800,"","","","",35.29,421221.44]
["MAR2014","Bus",100,2,200,8800,9000,"","","",45.87,4587]
["MAR2014","Bus",4,3,12,8800,9000,9100,"","",56.449999999999996,225.79999999999998]
["MAR2014","Bus",3,4,12,8800,9000,9100,9900,"",81.149999999999991,243.45]
["MAR2014","Bus",26,3,78,8800,9000,9900,"","",70.569999999999993,1834.8199999999997]
["MAR2014","Bus",488,2,976,8800,9100,"","","",45.87,22384.559999999998]
["MAR2014","Bus",10,3,30,8800,9100,9800,"","",70.569999999999993,705.69999999999993]
["MAR2014","Bus",63,3,189,8800,9100,9900,"","",70.569999999999993,4445.91]
["MAR2014","Bus",1,2,2,8800,9700,"","","",59.989999999999995,59.989999999999995]
["MAR2014","Bus",57,2,114,8800,9800,"","","",59.989999999999995,3419.43]
["MAR2014","Bus",328,2,656,8800,9900,"","","",59.989999999999995,19676.719999999998]
["MAR2014","Res",109,1,109,8900,"","","","",35.29,3846.61]
["MAR2014","Res",10,2,20,8900,9000,"","","",45.87,458.7]
["MAR2014","Res",13,2,26,8900,9100,"","","",45.87,596.30999999999995]
["MAR2014","Res",9,3,27,8900,9100,9900,"","",70.569999999999993,635.12999999999988]
["MAR2014","Res",9,2,18,8900,9900,"","","",59.989999999999995,539.91]
["MAR2014","CL",15,1,15,9000,"","","","",10.58,158.69999999999999]
["MAR2014","CL",110,1,110,9100,"","","","",10.58,1163.8]
["APR2014","Res",18223,2,36446,7500,8400,"","","",59.989999999999995,1093197.77]
["APR2014","Res / Bus",21,3,63,7500,8400,8500,"","",95.28,2000.88]
["APR2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,141.15,282.3]
["APR2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",105.86,635.16]
["APR2014","Res / Bus",23,4,92,7500,8400,8500,9100,"",105.86,2434.7800000000002]
["APR2014","Res / Bus",12,3,36,7500,8400,8800,"","",95.28,1143.3600000000001]
["APR2014","Res / Bus",6,4,24,7500,8400,8800,9000,"",105.86,635.16]
["APR2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",105.86,846.88]
["APR2014","Res",10617,3,31851,7500,8400,9000,"","",70.569999999999993,749241.69]
["APR2014","Res",972,4,3888,7500,8400,9000,9100,"",81.149999999999991,78877.799999999988]
["APR2014","Res",2,5,10,7500,8400,9000,9100,9700,105.85,211.7]
["APR2014","Res",21112,3,63336,7500,8400,9100,"","",70.569999999999993,1489873.8399999999]
["APR2014","Res",1,3,3,7500,8400,9700,"","",84.69,84.69]
["APR2014","Bus",421,2,842,7500,8500,"","","",59.989999999999995,25255.789999999997]
["APR2014","Bus",3,3,9,7500,8500,8800,"","",95.28,285.84000000000003]
["APR2014","Bus",1,4,4,7500,8500,8800,9100,"",105.86,105.86]
["APR2014","Bus",28,3,84,7500,8500,9000,"","",70.569999999999993,1975.9599999999998]
["APR2014","Bus",2,4,8,7500,8500,9000,9100,"",81.149999999999991,162.29999999999998]
["APR2014","Bus",60,3,180,7500,8500,9100,"","",70.569999999999993,4234.2]
["APR2014","Bus",44,2,88,7500,8800,"","","",59.989999999999995,2639.56]
["APR2014","Bus",5,3,15,7500,8800,9000,"","",70.569999999999993,352.84999999999997]
["APR2014","Bus",5,3,15,7500,8800,9100,"","",70.569999999999993,352.84999999999997]
["APR2014","Res",8,2,16,7500,8900,"","","",59.989999999999995,479.91999999999996]
["APR2014","Res",1,4,4,7500,8900,9000,9100,"",81.149999999999991,81.149999999999991]
["APR2014","Res",2,3,6,7500,8900,9100,"","",70.569999999999993,141.13999999999999]
["APR2014","Res / Bus",2,2,4,8300,8400,"","","",35.29,70.58]
["APR2014","Bus",8,2,16,8300,8500,"","","",35.29,282.32]
["APR2014","Bus",1,2,2,8300,9000,"","","",10.58,10.58]
["APR2014","Bus",1,2,2,8300,9800,"","","",24.7,24.7]
["APR2014","Bus",2,2,4,8300,9900,"","","",24.7,49.4]
["APR2014","Res",457408,1,457408,8400,"","","","",35.29,16141928.32]
["APR2014","Res / Bus",586,2,1172,8400,8500,"","","",70.58,41359.879999999997]
["APR2014","Res / Bus",24,3,72,8400,8500,8800,"","",105.87,2540.88]
["APR2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",116.45,1048.05]
["APR2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,141.15,141.15]
["APR2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,141.15,423.45000000000005]
["APR2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",116.45,1397.4]
["APR2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,141.15,282.3]
["APR2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",130.57,391.71]
["APR2014","Res / Bus",241,3,723,8400,8500,9000,"","",81.16,19559.559999999998]
["APR2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",91.74,825.66]
["APR2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,116.44,582.20000000000005]
["APR2014","Res / Bus",47,4,{"$f":"C168*D168","v":188},8400,8500,9000,9900,"",{"$f":"IF(ISERROR(VLOOKUP(F168,$A$11:$C$22,3,FALSE)),0,VLOOKUP(F168,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(G168,$A$11:$C$22,3,FALSE)),0,VLOOKUP(G168,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(H168,$A$11:$C$22,3,FALSE)),0,VLOOKUP(H168,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(I168,$A$11:$C$22,3,FALSE)),0,VLOOKUP(I168,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(J168,$A$11:$C$22,3,FALSE)),0,VLOOKUP(J168,$A$11:$C$22,3,FALSE))","v":105.86},{"$f":"C168*K168","v":4975.42}]
["APR2014","Res / Bus",704,3,2112,8400,8500,9100,"","",81.16,57136.639999999999]
["APR2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",105.86,105.86]
["APR2014","Res / Bus",111,4,444,8400,8500,9100,9900,"",105.86,11750.46]
["APR2014","Res / Bus",4,3,12,8400,8500,9800,"","",95.28,381.12]
["APR2014","Res / Bus",111,3,333,8400,8500,9900,"","",95.28,10576.08]
["APR2014","Res / Bus",249,2,498,8400,8800,"","","",70.58,17574.419999999998]
["APR2014","Res / Bus",85,3,255,8400,8800,9000,"","",81.16,6898.5999999999995]
["APR2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",91.74,550.43999999999994]
["APR2014","Res / Bus",3,5,15,8400,8800,9000,9100,9900,116.44,349.32]
["APR2014","Res / Bus",1,4,4,8400,8800,9000,9800,"",105.86,105.86]
["APR2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",105.86,3493.38]
["APR2014","Res / Bus",250,3,750,8400,8800,9100,"","",81.16,20290]
["APR2014","Res / Bus",3,4,12,8400,8800,9100,9800,"",105.86,317.58]
["APR2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",105.86,7092.62]
["APR2014","Res / Bus",3,3,9,8400,8800,9800,"","",95.28,285.84000000000003]
["APR2014","Res / Bus",41,3,123,8400,8800,9900,"","",95.28,3906.48]
["APR2014","Res",143114,2,286228,8400,9000,"","","",45.87,6564639.1799999997]
["APR2014","Res",8195,3,24585,8400,9000,9100,"","",56.449999999999996,462607.74999999994]
["APR2014","Res",7,4,28,8400,9000,9100,9700,"",81.149999999999991,568.04999999999995]
["APR2014","Res",8,4,32,8400,9000,9100,9800,"",81.149999999999991,649.19999999999993]
["APR2014","Res",5570,4,22280,8400,9000,9100,9900,"",81.149999999999991,452005.49999999994]
["APR2014","Res",58,3,174,8400,9000,9700,"","",70.569999999999993,4093.0599999999995]
["APR2014","Res",1,4,4,8400,9000,9700,9900,"",95.27,95.27]
["APR2014","Res",37,3,111,8400,9000,9800,"","",70.569999999999993,2611.0899999999997]
["APR2014","Res",44847,3,134541,8400,9000,9900,"","",70.569999999999993,3164852.7899999996]
["APR2014","Res",393452,2,786904,8400,9100,"","","",45.87,18047643.239999998]
["APR2014","Res",169,3,507,8400,9100,9700,"","",70.569999999999993,11926.329999999998]
["APR2014","Res",91,3,273,8400,9100,9800,"","",70.569999999999993,6421.869999999999]
["APR2014","Res",85222,3,255666,8400,9100,9900,"","",70.569999999999993,6014116.5399999991]
["APR2014","Res",243,2,486,8400,9700,"","","",59.989999999999995,14577.569999999998]
["APR2014","Res",2,3,6,8400,9700,9900,"","",84.69,169.38]
["APR2014","Res",133,2,266,8400,9800,"","","",59.989999999999995,7978.6699999999992]
["APR2014","Res",63104,2,126208,8400,9900,"","","",59.989999999999995,3785608.9599999995]
["APR2014","Bus",90796,1,90796,8500,"","","","",35.29,3204190.84]
["APR2014","Bus",552,2,1104,8500,8800,"","","",70.58,38960.159999999996]
["APR2014","Bus",6,3,18,8500,8800,9000,"","",81.16,486.96]
["APR2014","Bus",30,3,90,8500,8800,9100,"","",81.16,2434.7999999999997]
["APR2014","Bus",1,4,4,8500,8800,9100,9800,"",105.86,105.86]
["APR2014","Bus",1,4,4,8500,8800,9100,9900,"",105.86,105.86]
["APR2014","Bus",2,3,6,8500,8800,9800,"","",95.28,190.56]
["APR2014","Bus",14,3,42,8500,8800,9900,"","",95.28,1333.92]
["APR2014","Bus",481,2,962,8500,9000,"","","",45.87,22063.469999999998]
["APR2014","Bus",9,3,27,8500,9000,9100,"","",56.449999999999996,508.04999999999995]
["APR2014","Bus",4,4,16,8500,9000,9100,9900,"",81.149999999999991,324.59999999999997]
["APR2014","Bus",5,3,15,8500,9000,9800,"","",70.569999999999993,352.84999999999997]
["APR2014","Bus",90,3,270,8500,9000,9900,"","",70.569999999999993,6351.2999999999993]
["APR2014","Bus",2428,2,4856,8500,9100,"","","",45.87,111372.36]
["APR2014","Bus",1,3,3,8500,9100,9700,"","",70.569999999999993,70.569999999999993]
["APR2014","Bus",18,3,54,8500,9100,9800,"","",70.569999999999993,1270.2599999999998]
["APR2014","Bus",200,3,600,8500,9100,9900,"","",70.569999999999993,14113.999999999998]
["APR2014","Bus",5,2,10,8500,9700,"","","",59.989999999999995,299.95]
["APR2014","Bus",242,2,484,8500,9800,"","","",59.989999999999995,14517.579999999998]
["APR2014","Bus",1876,2,3752,8500,9900,"","","",59.989999999999995,112541.23999999999]
["APR2014","Bus",4,1,4,8600,"","","","",0,0]
["APR2014","Bus",1,1,1,8700,"","","","",0,0]
["APR2014","Bus",1,2,2,8700,8800,"","","",35.29,35.29]
["APR2014","Bus",11940,1,11940,8800,"","","","",35.29,421362.6]
["APR2014","Bus",100,2,200,8800,9000,"","","",45.87,4587]
["APR2014","Bus",4,3,12,8800,9000,9100,"","",56.449999999999996,225.79999999999998]
["APR2014","Bus",3,4,12,8800,9000,9100,9900,"",81.149999999999991,243.45]
["APR2014","Bus",26,3,78,8800,9000,9900,"","",70.569999999999993,1834.8199999999997]
["APR2014","Bus",487,2,974,8800,9100,"","","",45.87,22338.69]
["APR2014","Bus",10,3,30,8800,9100,9800,"","",70.569999999999993,705.69999999999993]
["APR2014","Bus",63,3,{"$f":"C232*D232","v":189},8800,9100,9900,"","",{"$f":"IF(ISERROR(VLOOKUP(F232,$A$11:$C$22,3,FALSE)),0,VLOOKUP(F232,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(G232,$A$11:$C$22,3,FALSE)),0,VLOOKUP(G232,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(H232,$A$11:$C$22,3,FALSE)),0,VLOOKUP(H232,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(I232,$A$11:$C$22,3,FALSE)),0,VLOOKUP(I232,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(J232,$A$11:$C$22,3,FALSE)),0,VLOOKUP(J232,$A$11:$C$22,3,FALSE))","v":70.569999999999993},{"$f":"C232*K232","v":4445.91}]
["APR2014","Bus",1,2,2,8800,9700,"","","",59.989999999999995,59.989999999999995]
["APR2014","Bus",63,2,126,8800,9800,"","","",59.989999999999995,3779.37]
["APR2014","Bus",325,2,650,8800,9900,"","","",59.989999999999995,19496.75]
["APR2014","Res",110,1,110,8900,"","","","",35.29,3881.9]
["APR2014","Res",10,2,20,8900,9000,"","","",45.87,458.7]
["APR2014","Res",14,2,28,8900,9100,"","","",45.87,642.17999999999995]
["APR2014","Res",9,3,27,8900,9100,9900,"","",70.569999999999993,635.12999999999988]
["APR2014","Res",9,2,18,8900,9900,"","","",59.989999999999995,539.91]
["APR2014","CL",15,1,15,9000,"","","","",10.58,158.69999999999999]
["APR2014","CL",110,1,110,9100,"","","","",10.58,1163.8]
["FEB2014","Res",15503,2,31006,7500,8400,"","","",59.989999999999995,930024.97]
["FEB2014","Res / Bus",18,3,54,7500,8400,8500,"","",95.28,1715.04]
["FEB2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,141.15,282.3]
["FEB2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",105.86,635.16]
["FEB2014","Res / Bus",18,4,72,7500,8400,8500,9100,"",105.86,1905.48]
["FEB2014","Res / Bus",10,3,30,7500,8400,8800,"","",95.28,952.8]
["FEB2014","Res / Bus",5,4,20,7500,8400,8800,9000,"",105.86,529.29999999999995]
["FEB2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",105.86,846.88]
["FEB2014","Res",9006,3,27018,7500,8400,9000,"","",70.569999999999993,635553.41999999993]
["FEB2014","Res",839,4,3356,7500,8400,9000,9100,"",81.149999999999991,68084.849999999991]
["FEB2014","Res",2,5,10,7500,8400,9000,9100,9700,105.85,211.7]
["FEB2014","Res",18150,3,54450,7500,8400,9100,"","",70.569999999999993,1280845.4999999998]
["FEB2014","Res",1,3,3,7500,8400,9700,"","",84.69,84.69]
["FEB2014","Bus",361,2,722,7500,8500,"","","",59.989999999999995,21656.39]
["FEB2014","Bus",3,3,9,7500,8500,8800,"","",95.28,285.84000000000003]
["FEB2014","Bus",1,4,4,7500,8500,8800,9100,"",105.86,105.86]
["FEB2014","Bus",24,3,72,7500,8500,9000,"","",70.569999999999993,1693.6799999999998]
["FEB2014","Bus",2,4,8,7500,8500,9000,9100,"",81.149999999999991,162.29999999999998]
["FEB2014","Bus",46,3,138,7500,8500,9100,"","",70.569999999999993,3246.22]
["FEB2014","Bus",41,2,82,7500,8800,"","","",59.989999999999995,2459.5899999999997]
["FEB2014","Bus",5,3,15,7500,8800,9000,"","",70.569999999999993,352.84999999999997]
["FEB2014","Bus",4,3,12,7500,8800,9100,"","",70.569999999999993,282.27999999999997]
["FEB2014","Res",7,2,14,7500,8900,"","","",59.989999999999995,419.92999999999995]
["FEB2014","Res",1,4,4,7500,8900,9000,9100,"",81.149999999999991,81.149999999999991]
["FEB2014","Res",2,3,6,7500,8900,9100,"","",70.569999999999993,141.13999999999999]
["FEB2014","Res / Bus",2,2,4,8300,8400,"","","",35.29,70.58]
["FEB2014","Bus",8,2,16,8300,8500,"","","",35.29,282.32]
["FEB2014","Bus",1,2,2,8300,9000,"","","",10.58,10.58]
["FEB2014","Bus",1,2,2,8300,9800,"","","",24.7,24.7]
["FEB2014","Bus",2,2,4,8300,9900,"","","",24.7,49.4]
["FEB2014","Res",456638,1,456638,8400,"","","","",35.29,16114755.02]
["FEB2014","Res / Bus",591,2,1182,8400,8500,"","","",70.58,41712.78]
["FEB2014","Res / Bus",24,3,72,8400,8500,8800,"","",105.87,2540.88]
["FEB2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",116.45,1048.05]
["FEB2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,141.15,141.15]
["FEB2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,141.15,423.45000000000005]
["FEB2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",116.45,1397.4]
["FEB2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,141.15,282.3]
["FEB2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",130.57,391.71]
["FEB2014","Res / Bus",240,3,720,8400,8500,9000,"","",81.16,19478.399999999998]
["FEB2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",91.74,825.66]
["FEB2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,116.44,582.20000000000005]
["FEB2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",105.86,4975.42]
["FEB2014","Res / Bus",718,3,2154,8400,8500,9100,"","",81.16,58272.88]
["FEB2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",105.86,105.86]
["FEB2014","Res / Bus",113,4,452,8400,8500,9100,9900,"",105.86,11962.18]
["FEB2014","Res / Bus",4,3,12,8400,8500,9800,"","",95.28,381.12]
["FEB2014","Res / Bus",112,3,336,8400,8500,9900,"","",95.28,10671.36]
["FEB2014","Res / Bus",255,2,510,8400,8800,"","","",70.58,17997.899999999998]
["FEB2014","Res / Bus",88,3,264,8400,8800,9000,"","",81.16,7142.08]
["FEB2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",91.74,550.43999999999994]
["FEB2014","Res / Bus",4,5,20,8400,8800,9000,9100,9900,116.44,465.76]
["FEB2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",105.86,3493.38]
["FEB2014","Res / Bus",252,3,{"$f":"C296*D296","v":756},8400,8800,9100,"","",{"$f":"IF(ISERROR(VLOOKUP(F296,$A$11:$C$22,3,FALSE)),0,VLOOKUP(F296,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(G296,$A$11:$C$22,3,FALSE)),0,VLOOKUP(G296,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(H296,$A$11:$C$22,3,FALSE)),0,VLOOKUP(H296,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(I296,$A$11:$C$22,3,FALSE)),0,VLOOKUP(I296,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(J296,$A$11:$C$22,3,FALSE)),0,VLOOKUP(J296,$A$11:$C$22,3,FALSE))","v":81.16},{"$f":"C296*K296","v":20452.32}]
["FEB2014","Res / Bus",2,4,8,8400,8800,9100,9800,"",105.86,211.72]
["FEB2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",105.86,7092.62]
["FEB2014","Res / Bus",1,3,3,8400,8800,9800,"","",95.28,95.28]
["FEB2014","Res / Bus",41,3,123,8400,8800,9900,"","",95.28,3906.48]
["FEB2014","Res",144269,2,288538,8400,9000,"","","",45.87,6617619.0299999993]
["FEB2014","Res",8237,3,24711,8400,9000,9100,"","",56.449999999999996,464978.64999999997]
["FEB2014","Res",7,4,28,8400,9000,9100,9700,"",81.149999999999991,568.04999999999995]
["FEB2014","Res",7,4,28,8400,9000,9100,9800,"",81.149999999999991,568.04999999999995]
["FEB2014","Res",5575,4,22300,8400,9000,9100,9900,"",81.149999999999991,452411.24999999994]
["FEB2014","Res",59,3,177,8400,9000,9700,"","",70.569999999999993,4163.6299999999992]
["FEB2014","Res",1,4,4,8400,9000,9700,9900,"",95.27,95.27]
["FEB2014","Res",34,3,102,8400,9000,9800,"","",70.569999999999993,2399.3799999999997]
["FEB2014","Res",45178,3,135534,8400,9000,9900,"","",70.569999999999993,3188211.4599999995]
["FEB2014","Res",395972,2,791944,8400,9100,"","","",45.87,18163235.640000001]
["FEB2014","Res",171,3,513,8400,9100,9700,"","",70.569999999999993,12067.47]
["FEB2014","Res",77,3,231,8400,9100,9800,"","",70.569999999999993,5433.8899999999994]
["FEB2014","Res",85782,3,257346,8400,9100,9900,"","",70.569999999999993,6053635.7399999993]
["FEB2014","Res",245,2,490,8400,9700,"","","",59.989999999999995,14697.55]
["FEB2014","Res",2,3,6,8400,9700,9900,"","",84.69,169.38]
["FEB2014","Res",117,2,234,8400,9800,"","","",59.989999999999995,7018.829999999999]
["FEB2014","Res",63649,2,127298,8400,9900,"","","",59.989999999999995,3818303.51]
["FEB2014","Bus",90817,1,90817,8500,"","","","",35.29,3204931.9299999997]
["FEB2014","Bus",557,2,1114,8500,8800,"","","",70.58,39313.06]
["FEB2014","Bus",6,3,18,8500,8800,9000,"","",81.16,486.96]
["FEB2014","Bus",30,3,90,8500,8800,9100,"","",81.16,2434.7999999999997]
["FEB2014","Bus",1,4,4,8500,8800,9100,9800,"",105.86,105.86]
["FEB2014","Bus",1,4,4,8500,8800,9100,9900,"",105.86,105.86]
["FEB2014","Bus",2,3,6,8500,8800,9800,"","",95.28,190.56]
["FEB2014","Bus",14,3,42,8500,8800,9900,"","",95.28,1333.92]
["FEB2014","Bus",481,2,962,8500,9000,"","","",45.87,22063.469999999998]
["FEB2014","Bus",9,3,27,8500,9000,9100,"","",56.449999999999996,508.04999999999995]
["FEB2014","Bus",3,4,12,8500,9000,9100,9900,"",81.149999999999991,243.45]
["FEB2014","Bus",5,3,15,8500,9000,9800,"","",70.569999999999993,352.84999999999997]
["FEB2014","Bus",90,3,270,8500,9000,9900,"","",70.569999999999993,6351.2999999999993]
["FEB2014","Bus",2443,2,4886,8500,9100,"","","",45.87,112060.40999999999]
["FEB2014","Bus",1,3,3,8500,9100,9700,"","",70.569999999999993,70.569999999999993]
["FEB2014","Bus",18,3,54,8500,9100,9800,"","",70.569999999999993,1270.2599999999998]
["FEB2014","Bus",200,3,600,8500,9100,9900,"","",70.569999999999993,14113.999999999998]
["FEB2014","Bus",5,2,10,8500,9700,"","","",59.989999999999995,299.95]
["FEB2014","Bus",221,2,442,8500,9800,"","","",59.989999999999995,13257.789999999999]
["FEB2014","Bus",1878,2,3756,8500,9900,"","","",59.989999999999995,112661.21999999999]
["FEB2014","Bus",4,1,4,8600,"","","","",0,0]
["FEB2014","Bus",1,1,1,8700,"","","","",0,0]
["FEB2014","Bus",1,2,2,8700,8800,"","","",35.29,35.29]
["FEB2014","Bus",11908,1,11908,8800,"","","","",35.29,420233.32]
["FEB2014","Bus",101,2,202,8800,9000,"","","",45.87,4632.87]
["FEB2014","Bus",4,3,12,8800,9000,9100,"","",56.449999999999996,225.79999999999998]
["FEB2014","Bus",3,4,12,8800,9000,9100,9900,"",81.149999999999991,243.45]
["FEB2014","Bus",26,3,78,8800,9000,9900,"","",70.569999999999993,1834.8199999999997]
["FEB2014","Bus",490,2,980,8800,9100,"","","",45.87,22476.3]
["FEB2014","Bus",7,3,21,8800,9100,9800,"","",70.569999999999993,493.98999999999995]
["FEB2014","Bus",65,3,195,8800,9100,9900,"","",70.569999999999993,4587.0499999999993]
["FEB2014","Bus",1,2,2,8800,9700,"","","",59.989999999999995,59.989999999999995]
["FEB2014","Bus",51,2,102,8800,9800,"","","",59.989999999999995,3059.49]
["FEB2014","Bus",326,2,652,8800,9900,"","","",59.989999999999995,19556.739999999998]
["FEB2014","Res",105,1,105,8900,"","","","",35.29,3705.45]
["FEB2014","Res",10,2,20,8900,9000,"","","",45.87,458.7]
["FEB2014","Res",12,2,24,8900,9100,"","","",45.87,550.43999999999994]
["FEB2014","Res",9,3,27,8900,9100,9900,"","",70.569999999999993,635.12999999999988]
["FEB2014","Res",8,2,16,8900,9900,"","","",59.989999999999995,479.91999999999996]
["FEB2014","CL",17,1,17,9000,"","","","",10.58,179.86]
["FEB2014","CL",110,1,110,9100,"","","","",10.58,1163.8]
["MAR2014","Res",16954,2,33908,7500,8400,"","","",59.989999999999995,1017070.46]
["MAR2014","Res / Bus",20,3,{"$f":"C360*D360","v":60},7500,8400,8500,"","",{"$f":"IF(ISERROR(VLOOKUP(F360,$A$11:$C$22,3,FALSE)),0,VLOOKUP(F360,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(G360,$A$11:$C$22,3,FALSE)),0,VLOOKUP(G360,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(H360,$A$11:$C$22,3,FALSE)),0,VLOOKUP(H360,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(I360,$A$11:$C$22,3,FALSE)),0,VLOOKUP(I360,$A$11:$C$22,3,FALSE))+IF(ISERROR(VLOOKUP(J360,$A$11:$C$22,3,FALSE)),0,VLOOKUP(J360,$A$11:$C$22,3,FALSE))","v":95.28},{"$f":"C360*K360","v":1905.6}]
["MAR2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,141.15,282.3]
["MAR2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",105.86,635.16]
["MAR2014","Res / Bus",19,4,76,7500,8400,8500,9100,"",105.86,2011.34]
["MAR2014","Res / Bus",10,3,30,7500,8400,8800,"","",95.28,952.8]
["MAR2014","Res / Bus",5,4,20,7500,8400,8800,9000,"",105.86,529.29999999999995]
["MAR2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",105.86,846.88]
["MAR2014","Res",9874,3,29622,7500,8400,9000,"","",70.569999999999993,696808.17999999993]
["MAR2014","Res",913,4,3652,7500,8400,9000,9100,"",81.149999999999991,74089.95]
["MAR2014","Res",2,5,10,7500,8400,9000,9100,9700,105.85,211.7]
["MAR2014","Res",19797,3,59391,7500,8400,9100,"","",70.569999999999993,1397074.2899999998]
["MAR2014","Res",1,3,3,7500,8400,9700,"","",84.69,84.69]
["MAR2014","Bus",390,2,780,7500,8500,"","","",59.989999999999995,23396.1]
["MAR2014","Bus",3,3,9,7500,8500,8800,"","",95.28,285.84000000000003]
["MAR2014","Bus",1,4,4,7500,8500,8800,9100,"",105.86,105.86]
["MAR2014","Bus",27,3,81,7500,8500,9000,"","",70.569999999999993,1905.3899999999999]
["MAR2014","Bus",2,4,8,7500,8500,9000,9100,"",81.149999999999991,162.29999999999998]
["MAR2014","Bus",50,3,150,7500,8500,9100,"","",70.569999999999993,3528.4999999999995]
["MAR2014","Bus",43,2,86,7500,8800,"","","",59.989999999999995,2579.5699999999997]
["MAR2014","Bus",5,3,15,7500,8800,9000,"","",70.569999999999993,352.84999999999997]
["MAR2014","Bus",5,3,15,7500,8800,9100,"","",70.569999999999993,352.84999999999997]
["MAR2014","Res",7,2,14,7500,8900,"","","",59.989999999999995,419.92999999999995]
["MAR2014","Res",1,4,4,7500,8900,9000,9100,"",81.149999999999991,81.149999999999991]
["MAR2014","Res",2,3,6,7500,8900,9100,"","",70.569999999999993,141.13999999999999]
["MAR2014","Res / Bus",2,2,4,8300,8400,"","","",35.29,70.58]
["MAR2014","Bus",8,2,16,8300,8500,"","","",35.29,282.32]
["MAR2014","Bus",1,2,2,8300,9000,"","","",10.58,10.58]
["MAR2014","Bus",1,2,2,8300,9800,"","","",24.7,24.7]
["MAR2014","Bus",2,2,4,8300,9900,"","","",24.7,49.4]
["MAR2014","Res",456975,1,456975,8400,"","","","",35.29,16126647.75]

{"sheet":"Meter Relationships","index":10,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,8,33,10],[3,2,4,2],[5,2,6,2],[30,8,30,10],[31,8,31,10],[32,8,32,10]]}
[]
[null,"Based on 12/13 $ not including oncosts and overheads"]
[null,null,null,null,null,"Labour Hrs","Labour Rate","Material Costs","Total"]
[null,"DC 1 Element Single Phase",0.93,0.79,null,1.1499999999999999,67.55,50,{"$f":"F4*labour+SS","v":127.68249999999999}]
[null,"DC 2 Element Single Phase",null,0.21,null,1.1499999999999999,67.55,125,{"$f":"F5*labour+SD","v":202.6825}]
[null,"DC Polyphase",7.0000000000000007E-2,0.84,null,1.87,67.55,173,{"$f":"F6*labour+MP","v":299.31849999999997}]
[null,"CT Polyphase",null,0.16,null,1.87,67.55,173,{"$f":"F7*labour+MP","v":299.31849999999997}]
[]
[null,"Solar",null,"Labour Hrs",null,"PV (Vol)"]
[null,"Meters Replaced",0.75,0.98,"Single",52054]
[null,"Meters Reprogrammed",0.25,1.22,"Multi",935]
[null,null,null,null,null,{"$f":"F10/(F10+F11)","v":0.98235482836060317}]
[null,null,null,null,null,{"$f":"F11/(F10+F11)","v":1.7645171639396856E-2}]
[]
[null,"Administration standard labour rate",null,63.571203552999997,65.796449962169191,68.099588896644946,70.48334690638309,72.950545981494116]
[]
[null,"Oncosts & Overheads",null,"2015-16","2016-17","2017-18","2018-19","2019-20"]
[null,"Overhead Rate",null,0.43309999999999998,0.40489999999999998,0.41770000000000002,0.43149999999999999,0.41520000000000001]
[null,"Corporate Overhead Rate",null,7.5715862114390908E-2,6.8924970609191019E-2,6.7853354162277252E-2,6.9548520726403884E-2,6.4065450163485249E-2]
[null,"Fleet Oncosts",null,0.11210000000000001,0.1118,0.1116,0.1115,0.1109]
[null,"Material Oncosts",null,5.0900000000000001E-2,4.9299999999999997E-2,4.9500000000000002E-2,5.3699999999999998E-2,4.9799999999999997E-2]
[]
[null,"Capital Allowance",null,0.27902781126637533,0.32626735653373734,0.35714885945044811,0.40392336854330546,0.43422912806894159]
[]
[null,"Materials",null,{"$f":"(1+D21)*(1+D18)+(1+D19)-2","v":0.58176065211439099}]
[null,"Labour",null,{"$f":"(1+D20)*(1+D18)+(1+D19)+(1+D23)-3","v":0.94849418338076674}]
[null,"Contractors",null,{"$f":"(1+D18)+(1+D19)-2","v":0.50881586211439078}]
[]
[]
[]
[null,"TYPE","Lab - Hrs","Lab - $","Materials","Total","Incl OC & OH",null,"Notes"]
[null,"Primary",{"$f":"(D4*F4+D5*F5)*C4+(D6*F6+D7*F7)*C6","v":1.2003999999999999},{"$f":"labour*C32","v":81.087019999999995},{"$f":"(D4*SS+D5*SD)*C4+(D6*MP+D7*H7)*C6","v":73.257500000000007},{"$f":"D32+E32","v":154.34451999999999},{"$f":"D32*(1+$D$26)+E32*(1+$D$25)","v":273.87341778994988},1,"Weighted based on meter population"]
[null,"Controlled Load",null,null,{"$f":"SS","v":50},{"$f":"D33+E33","v":50},{"$f":"D33*(1+$D$26)+E33*(1+$D$25)","v":79.088032605719548},{"$f":"ROUND(G33/G32,1)","v":0.3},"Cost of Single Phase single element meter only\nLabour and relate are costed to SCS"]
[null,"Solar",{"$f":"D10*F12+D11*F13","v":0.98423484119345528},{"$f":"labour*C34","v":66.485063522617907},{"$f":"C10*(F12*SS+F13*MP)","v":39.127767083734362},{"$f":"D34+E34","v":105.61283060635228},{"$f":"D34*(1+$D$26)+E34*(1+$D$25)","v":191.43652193366944},{"$f":"ROUND(G34/G32,1)","v":0.7},"Based on 75% meter replacement vs meter reprogram"]