{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Title Page","Inputs","Exit Fee Calculation excl PV","AER Smooth Charges","AER Upfront capital charges","Price Path Calc","PTRM output","Demand Forecast","PIVOT NMI's","NMIs Per NTC","NTCs per NMI","Summary by NTC","DATA by NTC","Relationships"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":10,"defined_names":148,"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":"Title Page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Inputs","index":1,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"2014/15","2015/16","2016/17","2017/18","2018/19","2019/20"]
[]
[null,"WACC",{"$f":"[9]WACC!$F$28","v":5.845999999999997E-2}]
[null,"Forecast Inflation",{"$f":"[9]Input!$G$187","v":2.5499999999999998E-2}]
[]
[null,"Last Updated","2014-10-09"]

{"sheet":"Exit Fee Calculation excl PV","index":2,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
["PTRM Output - MAB (closing balance)"]
[]
[null,null,"2014/15",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Metering Assets",{"$f":"'PTRM output'!C16*1000000","v":426540737.23190582},{"$f":"'PTRM output'!D16*1000000","v":406444693.18514729},{"$f":"'PTRM output'!E16*1000000","v":385192053.27184117},{"$f":"'PTRM output'!F16*1000000","v":362866127.28182679},{"$f":"'PTRM output'!G16*1000000","v":339335726.47388589},{"$f":"'PTRM output'!H16*1000000","v":314499807.71643049}]
[null,"Other",{"$f":"('PTRM output'!C15-'PTRM output'!C16)*1000000","v":22222091.340458691},{"$f":"('PTRM output'!D15-'PTRM output'!D16)*1000000","v":21258197.943960909},{"$f":"('PTRM output'!E15-'PTRM output'!E16)*1000000","v":19645715.215300698},{"$f":"('PTRM output'!F15-'PTRM output'!F16)*1000000","v":18041172.030756854},{"$f":"('PTRM output'!G15-'PTRM output'!G16)*1000000","v":17126457.567507315},{"$f":"('PTRM output'!H15-'PTRM output'!H16)*1000000","v":16337312.935315197}]
[null,null,{"$f":"SUM(C5:C6)","v":448762828.57236451},427702891.12910819,404837768.48714185,380907299.31258363,356462184.04139322,330837120.65174568]
[]
[null,"Meters (closing balance)","2014/15"]
[null,"Single Phase",{"$f":"2054856","v":2054856}]
[null,"Multi Phase",115292]
[]
[null,null,{"$f":"SUM(C10:C12)","v":2170148}]
[null,"Relationships"]
[null,"Primary",{"$f":"Relationships!H17","v":1}]
[null,"Load Control",{"$f":"Relationships!H18","v":0.3}]
[null,"Solar PV",{"$f":"Relationships!H19","v":0.7}]
[]
[null,"NTCs (closing for year)","2014/15"]
[null,"Primary",{"$f":"ROUND('Demand Forecast'!$B$38,0)","v":1387351}]
[null,"Load Control",{"$f":"ROUND('Demand Forecast'!$F$38,0)","v":737004}]
[null,"Solar PV",{"$f":"ROUND('Demand Forecast'!$J$38,0)","v":304003},"* assuming that Solar PV is used in conjunction with another tariff"]
[]
[null,null,{"$f":"SUM(C20:C23)","v":2428358}]
[]
[null,"Meters Associated Per Category","2014/15"]
[null,"Primary",{"$f":"C13-C28","v":1433144}]
[null,"Load Control",{"$f":"C21","v":737004}]
[null,"Solar PV"]
[]
[null,null,{"$f":"SUM(C27:C30)","v":2170148}]
[]
[null,"Rebalanced meters (taking into account relationships)","2014/15"]
[null,"Primary",{"$f":"C27","v":1433144}]
[null,"Load Control",{"$f":"C28*C16","v":221101.19999999998}]
[null,"Solar PV"]
[]
[null,null,{"$f":"SUM(C34:C37)","v":1654245.2}]
[null,"Primary",{"$f":"C34/C38","v":0.8663431515473039}]
[null,"Load Control",{"$f":"C35/C38","v":0.13365684845269613}]
[null,"Solar PV"]
[]
[null,null,{"$f":"SUM(C39:C42)","v":1}]
[null,"Relative share of MAB (Metering Assets)"]
[null,"Primary",{"$f":"C39*C5","v":369530646.55679971}]
[null,"Load Control",{"$f":"C40*C5","v":57010090.675106116}]
[null,"Solar PV"]
[]
[null,null,{"$f":"SUM(C45:C48)","v":426540737.23190582}]
[]
["Calculated Exit Fee $ per NTC (based on Metering Assets only ie excl Non system)"]
[]
[null,"$ per tariff removal (Metering Asset Value / NTCs)","2014/15",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C45/C27","v":257.84613866910775},{"$f":"C54*(1+CPI)","v":264.42121520517003},271.16395619290188,278.07863707582089,285.16964232125434,292.44146820044637]
[null,"Load Control",{"$f":"C46/C28","v":77.353841600732309},79.326364561550989,81.349186857870549,83.423591122746259,85.550892696376295,87.732440460133901]
[null,"Solar PV"]
[]
[null,"Administration Costs"]
[null,"15 minutes @ administration labour rate",null,{"$f":"15/60*D63","v":15.892800888249999},{"$f":"15/60*E63","v":16.449112490542298},17.024897224161236,17.620836726595773,18.237636495373529]
[null,"Oncosts & overheads",null,{"$f":"D59*(1+D68)*(1+D66)+D59*(1+D71)+D59*(1+D67)-3*D59","v":15.074229200133807},{"$f":"E59*(1+E68)*(1+E66)+E59*(1+E71)+E59*(1+E67)-3*E59","v":15.744434931818041},{"$f":"F59*(1+F68)*(1+F66)+F59*(1+F71)+F59*(1+F67)-3*F59","v":17.040518139617603},{"$f":"G59*(1+G68)*(1+G66)+G59*(1+G71)+G59*(1+G67)-3*G59","v":18.758863299795038},{"$f":"H59*(1+H68)*(1+H66)+H59*(1+H71)+H59*(1+H67)-3*H59","v":19.522300319656772}]
[null,null,null,{"$f":"SUM(D59:D60)","v":30.967030088383808},{"$f":"SUM(E59:E60)","v":32.193547422360339},34.06541536377884,36.379700026390807,37.759936815030301]
[]
[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+D69)*(1+D66)+(1+D67)-2","v":0.58176065211439099}]
[null,"Labour",null,{"$f":"(1+D68)*(1+D66)+(1+D67)+(1+D71)-3","v":0.94849418338076674}]
[null,"Contractors",null,{"$f":"(1+D66)+(1+D67)-2","v":0.50881586211439078}]

{"sheet":"AER Smooth Charges","index":3,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Annual charges ($Nominal)",null,null,null,null,null,"Volumes and Revenue($m Nominal)"]
[]
[null,{"$f":"'Price Path Calc'!C4","v":"2015/16"},{"$f":"'Price Path Calc'!D4","v":"2016/17"},{"$f":"'Price Path Calc'!E4","v":"2017/18"},{"$f":"'Price Path Calc'!F4","v":"2018/19"},{"$f":"'Price Path Calc'!G4","v":"2019/20"},null,{"$f":"B3","v":"2015/16"},{"$f":"C3","v":"2016/17"},{"$f":"D3","v":"2017/18"},{"$f":"E3","v":"2018/19"},{"$f":"F3","v":"2019/20"},null,null,{"$f":"I3","v":"2016/17"},{"$f":"J3","v":"2017/18"},"2018/19","2019/20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast inflation",{"$f":"CPI","v":2.5499999999999998E-2},{"$f":"CPI","v":2.5499999999999998E-2},{"$f":"CPI","v":2.5499999999999998E-2},{"$f":"CPI","v":2.5499999999999998E-2}]
[{"$f":"'Price Path Calc'!B12","v":"Primary"},null,null,null,null,null,null,{"$f":"'Price Path Calc'!C12","v":1393042},{"$f":"'Price Path Calc'!D12","v":1407467},{"$f":"'Price Path Calc'!E12","v":1422042},{"$f":"'Price Path Calc'!F12","v":1436768},{"$f":"'Price Path Calc'!G12","v":1451646},null,"X factor",{"$f":"'Price Path Calc'!D59","v":3.9403433165753843E-2},{"$f":"'Price Path Calc'!E59","v":3.9403433165753843E-2},{"$f":"'Price Path Calc'!F59","v":3.9403433165753843E-2},{"$f":"'Price Path Calc'!G59","v":3.9403433165753843E-2}]
["non-capital",{"$f":"'Price Path Calc'!C110/'Price Path Calc'!C$12","v":10.806149532876026},{"$f":"B6*(1-O$5)*(1+O$4)","v":10.645049070598649},{"$f":"C6*(1-P$5)*(1+P$4)","v":10.486350329569625},10.330017504398496,10.176015323489468,null,{"$f":"B6*H5/10^6","v":15.053420157576683},{"$f":"C6*I5/10^6","v":14.982555280248269},{"$f":"D6*J5/10^6","v":14.912030595361847},{"$f":"E6*K5/10^6","v":14.841838589759618},{"$f":"F6*L5/10^6","v":14.771971940282192},null,{"$f":"Inputs!B5","v":"WACC"},{"$f":"WACC","v":5.845999999999997E-2},{"$f":"WACC","v":5.845999999999997E-2},{"$f":"WACC","v":5.845999999999997E-2},{"$f":"WACC","v":5.845999999999997E-2}]
["capital",{"$f":"'Price Path Calc'!C103/'Price Path Calc'!C$12","v":24.480740441622874},{"$f":"B7*(1-O$5)*(1+O$4)","v":24.115776159938694},23.756252846317668,23.402089385607031,23.053205871936605,null,{"$f":"B7*H5/10^6","v":34.102699626279211},{"$f":"C7*I5/10^6","v":33.942159124500428},{"$f":"D7*J5/10^6","v":33.782389310083268},{"$f":"E7*K5/10^6","v":33.623373162379849},{"$f":"F7*L5/10^6","v":33.465094091173285}]
[]
[{"$f":"'Price Path Calc'!B13","v":"Load Control"},null,null,null,null,null,null,{"$f":"'Price Path Calc'!C13","v":740012},{"$f":"'Price Path Calc'!D13","v":743305},{"$f":"'Price Path Calc'!E13","v":746612},{"$f":"'Price Path Calc'!F13","v":749934},{"$f":"'Price Path Calc'!G13","v":753271}]
["non-capital",{"$f":"'Price Path Calc'!C111/'Price Path Calc'!C$13","v":3.2418448598628076},{"$f":"B10*(1-O$5)*(1+O$4)","v":3.1935147211795947},{"$f":"C10*(1-P$5)*(1+P$4)","v":3.1459050988708874},{"$f":"D10*(1-Q$5)*(1+Q$4)","v":3.0990052513195487},{"$f":"E10*(1-R$5)*(1+R$4)","v":3.05280459704684},null,{"$f":"B10*H9/10^6","v":2.3990040984367962},{"$f":"C10*I9/10^6","v":2.3737554598263988},{"$f":"D10*J9/10^6","v":2.3487704976781911},{"$f":"E10*K9/10^6","v":2.3240494041430746},{"$f":"F10*L9/10^6","v":2.29958917162207}]
["capital",{"$f":"'Price Path Calc'!C104/'Price Path Calc'!C$13","v":7.3442221324868644},{"$f":"B11*(1-O$5)*(1+O$4)","v":7.2347328479816113},7.1268758538953039,7.0206268156821121,6.9159617615809852,null,{"$f":"B11*H9/10^6","v":5.4348125087058694},{"$f":"C11*I9/10^6","v":5.377613099568971},{"$f":"D11*J9/10^6","v":5.3210110350284809},{"$f":"E11*K9/10^6","v":5.2650067503917484},{"$f":"F11*L9/10^6","v":5.2095934321078703}]
[]
[{"$f":"'Price Path Calc'!B14","v":"Solar PV"},null,null,null,null,null,null,{"$f":"'Price Path Calc'!C14","v":323232},{"$f":"'Price Path Calc'!D14","v":353232},{"$f":"'Price Path Calc'!E14","v":382232},{"$f":"'Price Path Calc'!F14","v":409232},{"$f":"'Price Path Calc'!G14","v":434232}]
["non-capital",{"$f":"'Price Path Calc'!C112/'Price Path Calc'!C$14","v":7.5643046730132175},{"$f":"B14*(1-O$5)*(1+O$4)","v":7.4515343494190533},{"$f":"C14*(1-P$5)*(1+P$4)","v":7.3404452306987364},{"$f":"D14*(1-Q$5)*(1+Q$4)","v":7.231012253078946},{"$f":"E14*(1-R$5)*(1+R$4)","v":7.1232107264426254},null,{"$f":"B14*H13/10^6","v":2.4450253280674086},{"$f":"C14*I13/10^6","v":2.6321203813139911},{"$f":"D14*J13/10^6","v":2.8057530614204391},{"$f":"E14*K13/10^6","v":2.9591616063520032},{"$f":"F14*L13/10^6","v":3.0931260401646341}]
["capital",{"$f":"'Price Path Calc'!C105/'Price Path Calc'!C$14","v":17.136518309136015},{"$f":"B15*(1-O$5)*(1+O$4)","v":16.881043311957093},16.629376992422376,16.381462569924928,16.137244110355631,null,{"$f":"B15*H13/10^6","v":5.5390710860986525},{"$f":"C15*I13/10^6","v":5.9629246911692277},{"$f":"D15*J13/10^6","v":6.3562800265675898},{"$f":"E15*K13/10^6","v":6.7038186904155186},{"$f":"F15*L13/10^6","v":7.0073077845279466}]
[]
["Total"]
["Customers",null,null,null,null,null,null,{"$f":"SUM(H5,H9,H13)","v":2456286},{"$f":"SUM(I5,I9,I13)","v":2504004},2550886,2595934,2639149]
[{"$f":"A14","v":"non-capital"},null,null,null,null,null,null,{"$f":"SUM(H6,H10,H14)","v":19.897449584080888},19.988431121388661,20.066554154460476,20.125049600254698,20.164687152068897]
[{"$f":"A15","v":"capital"},null,null,null,null,null,"NPV",{"$f":"SUM(H7,H11,H15)","v":45.07658322108373},45.282696915238624,45.45968037167934,45.592198603187114,45.681995307809103]
[null,null,null,null,null,"Total Smoothed Revenue",{"$f":"NPV($O$6,H21:L21)","v":276.82453802479063},{"$f":"SUM(H19:H20)","v":64.974032805164626},{"$f":"SUM(I19:I20)","v":65.271128036627289},{"$f":"SUM(J19:J20)","v":65.526234526139817},{"$f":"SUM(K19:K20)","v":65.717248203441812},{"$f":"SUM(L19:L20)","v":65.846682459877997}]
[]
[null,null,null,null,null,"Total Unsmoothed Revenue",{"$f":"NPV($O$6,H23:L23)","v":276.82453802409071},{"$f":"'PTRM output'!D25/10^6","v":64.97403280516464},{"$f":"'PTRM output'!E25/10^6","v":65.029218173941118},{"$f":"'PTRM output'!F25/10^6","v":65.459287978931414},{"$f":"'PTRM output'!G25/10^6","v":65.875419368913512},{"$f":"'PTRM output'!H25/10^6","v":66.04113191797336}]
[]
[null,null,null,null,null,"Difference in NPVs",{"$f":"G21-G23","v":6.9991301643312909E-10},null,null,null,null,{"$f":"L21/L23-1","v":-2.9443689477776092E-3},"Difference between final year revenue and requirement"]

{"sheet":"AER Upfront capital charges","index":4,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
["Upfront capital charge ($2014-15)"]
[]
["Labour"]
[]
[null,"Labour hrs","Labour rate"]
["DC 1 Element Single Phase",1.25,"C-I-C"]
["DC 2 Element Single Phase",1.25,"C-I-C"]
["DC Polyphase",1.65,"C-I-C"]
["CT Polyphase",1.65,"C-I-C"]
[]
[]
["Oncosts & overhead rates"]
[]
["General overheads","C-I-C"]
["Fleet oncosts","C-I-C"]
["Material oncosts","C-I-C"]
["Capital allowance","C-I-C"]
[]
["Proposed"]
[]
[null,"Hardware","Labour","Oncosts","Overheads","Allowance","Total"]
[{"$f":"[10]Relationships!B4","v":"DC 1 Element Single Phase"},null,null,null,null,null,297.84440030500002]
[{"$f":"[10]Relationships!B5","v":"DC 2 Element Single Phase"},null,null,null,null,null,388.25493912500002]
[{"$f":"[10]Relationships!B6","v":"DC Polyphase"},null,null,null,null,null,606.15593727300006]
[{"$f":"[10]Relationships!B7","v":"CT Polyphase"},null,null,null,null,null,1639.2692903259999]
[]
["Approved"]
[]
[null,"Hardware","Labour","Oncosts","Overheads","Allowance","Total"]
["DC 1 Element Single Phase",null,null,null,null,null,297.84440030500002]
["DC 2 Element Single Phase",null,null,null,null,null,388.25493912500002]
["DC Polyphase",null,null,null,null,null,581.2739332729999]
["CT Polyphase",null,null,null,null,null,1639.2692903259999]

{"sheet":"Price Path Calc","index":5,"n_rows":141,"n_cols":9,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
[]
["PTRM Output - pre smoothed"]
[]
[null,null,{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"ROA & Depn",{"$f":"'PTRM output'!D39","v":45076583.221083745},{"$f":"'PTRM output'!E39","v":45014758.138670787},{"$f":"'PTRM output'!F39","v":44917352.735633031},{"$f":"'PTRM output'!G39","v":44521127.855806813},{"$f":"'PTRM output'!H39","v":44253477.401494592}]
[null,"O&M (incl DRC and Tax)",{"$f":"'PTRM output'!D40","v":19897449.584080894},{"$f":"'PTRM output'!E40","v":20014460.035270326},{"$f":"'PTRM output'!F40","v":20541935.243298393},{"$f":"'PTRM output'!G40","v":21354291.5131067},{"$f":"'PTRM output'!H40","v":21787654.516478766}]
[null,null,{"$f":"SUM(C5:C6)","v":64974032.805164635},{"$f":"SUM(D5:D6)","v":65029218.173941113},65459287.978931427,65875419.368913516,66041131.917973354]
[]
["Forecast NTCs"]
[]
[null,"NTCs (avg for year)",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"ROUND('Demand Forecast'!$B$16,0)","v":1393042},{"$f":"ROUND('Demand Forecast'!$B$17,0)","v":1407467},{"$f":"ROUND('Demand Forecast'!$B$18,0)","v":1422042},{"$f":"ROUND('Demand Forecast'!$B$19,0)","v":1436768},{"$f":"ROUND('Demand Forecast'!$B$20,0)","v":1451646}]
[null,"Load Control",{"$f":"ROUND('Demand Forecast'!$F$16,0)","v":740012},{"$f":"ROUND('Demand Forecast'!$F$17,0)","v":743305},{"$f":"ROUND('Demand Forecast'!$F$18,0)","v":746612},{"$f":"ROUND('Demand Forecast'!$F$19,0)","v":749934},{"$f":"ROUND('Demand Forecast'!$F$20,0)","v":753271}]
[null,"Solar PV",{"$f":"ROUND('Demand Forecast'!$J$16,0)","v":323232},{"$f":"ROUND('Demand Forecast'!$J$17,0)","v":353232},{"$f":"ROUND('Demand Forecast'!$J$18,0)","v":382232},{"$f":"ROUND('Demand Forecast'!$J$19,0)","v":409232},{"$f":"ROUND('Demand Forecast'!$J$20,0)","v":434232}]
[]
[null,null,{"$f":"SUM(C12:C15)","v":2456286},{"$f":"SUM(D12:D15)","v":2504004},2550886,2595934,2639149]
[null,"Relationships"]
[null,"Primary",{"$f":"Relationships!H17","v":1}]
[null,"Load Control",{"$f":"Relationships!H18","v":0.3}]
[null,"Solar PV",{"$f":"Relationships!H19","v":0.7}]
[]
[null,"% weighting",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C12*$C$18","v":1393042},{"$f":"D12*$C$18","v":1407467},{"$f":"E12*$C$18","v":1422042},{"$f":"F12*$C$18","v":1436768},{"$f":"G12*$C$18","v":1451646}]
[null,"Load Control",{"$f":"C13*$C$19","v":222003.6},{"$f":"D13*$C$19","v":222991.5},{"$f":"E13*$C$19","v":223983.6},{"$f":"F13*$C$19","v":224980.19999999998},{"$f":"G13*$C$19","v":225981.3}]
[null,"Solar PV",{"$f":"C14*$C$20","v":226262.39999999999},{"$f":"D14*$C$20","v":247262.4},{"$f":"E14*$C$20","v":267562.39999999997},{"$f":"F14*$C$20","v":286462.39999999997},{"$f":"G14*$C$20","v":303962.39999999997}]
[]
[null,null,{"$f":"SUM(C23:C26)","v":1841308},{"$f":"SUM(D23:D26)","v":1877720.9},1913588,1948210.5999999999,1981589.7]
[]
[null,"% weighting",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C23/C$27","v":0.75655023494168272},{"$f":"D23/D$27","v":0.74956134322198797},0.74312861493696658,0.73748084524332236,0.73256638344456471]
[null,"Load Control",{"$f":"C24/C$27","v":0.12056842201304725},0.11875646694884208,0.11704901995622882,0.1154804311197157,0.11404040907156511]
[null,"Solar PV",{"$f":"C25/C$27","v":0.12288134304526999},0.13168218982917004,0.13982236510680457,0.14703872363696202,0.15339320748387014]
[]
[null,null,{"$f":"SUM(C30:C33)","v":1},{"$f":"SUM(D30:D33)","v":1.0000000000000002},1,1,1]
[]
["Calculated $ per NTC"]
[]
[null,"$ per NTC per annum",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C23/C27*C7/C12","v":35.286889974498905},{"$f":"D23/D27*D7/D12","v":34.631993590709421},34.207618347800796,33.813294809561924,33.327349207544508]
[null,"Load Control",{"$f":"C24/C27*C7/C13","v":10.586066992349673},10.389598077212824,10.262285504340239,10.143988442868576,9.9982047622633505]
[null,"Solar PV",{"$f":"C25/C27*C7/C14","v":24.700822982149234},24.242395513496593,23.945332843460552,23.669306366693341,23.329144445281152]
[]
[null,"Tariff Increase",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",null,{"$f":"(D39-C39)/C39","v":-1.8559198168576613E-2},{"$f":"(E39-D39)/D39","v":-1.2253849660634889E-2},-1.1527360198820247E-2,-1.4371435991502309E-2]
[null,"Load Control",null,{"$f":"(D40-C40)/C40","v":-1.8559198168576981E-2},{"$f":"(E40-D40)/D40","v":-1.2253849660634652E-2},-1.1527360198820421E-2,-1.4371435991502346E-2]
[null,"Solar PV",null,{"$f":"(D41-C41)/C41","v":-1.8559198168576672E-2},{"$f":"(E41-D41)/D41","v":-1.2253849660635065E-2},-1.1527360198820251E-2,-1.4371435991502222E-2]
[]
[null,"Total Revenue",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"},null,"NPV"]
[null,"Primary",{"$f":"C12*C39","v":49156119.7838559},48743388.123135015,48644670.010543339,48581859.956944667,48379513.167735152,null,{"$f":"NPV(WACC,C49:G49)","v":206092047.48908213}]
[null,"Load Control",7833816.6071426664,7722640.1987826778,7661945.5049664751,7607321.8289142027,7531357.6994748767,null,{"$f":"NPV(WACC,C50:G50)","v":32485305.4054267}]
[null,"Solar PV",7984096.4141660612,8563189.8520234283,9152672.463421613,9686237.5830546487,10130261.050763326,null,{"$f":"NPV(WACC,C51:G51)","v":38247185.129581891}]
[null,null,{"$f":"SUM(C49:C51)","v":64974032.805164628},{"$f":"SUM(D49:D51)","v":65029218.173941121},65459287.978931427,65875419.368913516,66041131.917973354,null,{"$f":"SUM(I49:I51)","v":276824538.02409071}]
[null,"Check",{"$f":"C52-C7","v":0},{"$f":"D52-D7","v":0},{"$f":"E52-E7","v":0},{"$f":"F52-F7","v":0},{"$f":"G52-G7","v":0}]
[null,null,null,{"$f":"D52/C52-1","v":8.4934498281752369E-4},{"$f":"E52/D52-1","v":6.6134857079158671E-3},{"$f":"F52/E52-1","v":6.3571022971717905E-3},{"$f":"G52/F52-1","v":2.5155445027502665E-3}]
[]
["Smoothed $ per NTC - what % year on year for each year across all categories gives you the same NPV as above"]
[]
[null,"CPI",null,{"$f":"CPI","v":2.5499999999999998E-2},{"$f":"CPI","v":2.5499999999999998E-2},{"$f":"CPI","v":2.5499999999999998E-2},{"$f":"CPI","v":2.5499999999999998E-2}]
[null,"X",null,3.9403433165753843E-2,{"$f":"$D$59","v":3.9403433165753843E-2},{"$f":"$E$59","v":3.9403433165753843E-2},{"$f":"$F$59","v":3.9403433165753843E-2}]
[]
[null,"$ per NTC per annum (smoothed)",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C39","v":35.286889974498905},{"$f":"C62*(1+D$58)*(1-D$59)","v":34.76082523053735},{"$f":"D62*(1+E$58)*(1-E$59)","v":34.242603175887304},33.732106890005539,33.229221195426092]
[null,"Load Control",{"$f":"C40","v":10.586066992349673},{"$f":"C63*(1+D$58)*(1-D$59)","v":10.428247569161206},{"$f":"D63*(1+E$58)*(1-E$59)","v":10.27278095276619},10.11963206700166,9.9687663586278248]
[null,"Solar PV",{"$f":"C41","v":24.700822982149234},{"$f":"C64*(1+D$58)*(1-D$59)","v":24.332577661376146},{"$f":"D64*(1+E$58)*(1-E$59)","v":23.969822223121113},23.612474823003875,23.26045483679826]
[]
[null,"cents per NTC per day (smoothed)",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C62/365*100","v":9.6676410889038102},9.5235137617910546,9.3815351166814533,9.2416731205494624,9.1038962179249552]
[null,"Load Control",{"$f":"C63/365*100","v":2.9002923266711433},2.8570541285373166,2.8144605350044358,2.7725019361648386,2.7311688653774859]
[null,"Solar PV",6.7673487622326665,6.666459633253738,6.5670745816770166,6.4691711843846225,6.3727273525474679]
[]
[null,"Increase",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",null,{"$f":"D62/C62-1","v":-1.4908220711480458E-2},-1.4908220711480347E-2,-1.4908220711480347E-2,-1.4908220711480236E-2]
[null,"Load Control",null,{"$f":"D63/C63-1","v":-1.4908220711480458E-2},-1.4908220711480569E-2,-1.4908220711480347E-2,-1.4908220711480458E-2]
[null,"Solar PV",null,{"$f":"D64/C64-1","v":-1.4908220711480347E-2},-1.4908220711480347E-2,-1.4908220711480458E-2,-1.4908220711480347E-2]
[]
[null,"Total Revenue",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"},null,"NPV"]
[null,"Primary",{"$f":"C62*C12","v":49156119.7838559},48924714.404748715,48694419.905445136,48465211.752139479,48237066.031455502,null,{"$f":"NPV(WACC,C77:G77)","v":206095694.12886983}]
[null,"Load Control",7833816.6071426664,7751368.5593953701,7669781.5327066714,7589056.1545348233,7509182.60372994,null,{"$f":"NPV(WACC,C78:G78)","v":32486312.109055713}]
[null,"Solar PV",7984096.4141660612,8595045.0724832192,9162033.0879880302,9662980.2967675216,10100433.824692583,null,{"$f":"NPV(WACC,C79:G79)","v":38242531.786865152}]
[null,null,{"$f":"SUM(C77:C79)","v":64974032.805164628},{"$f":"SUM(D77:D79)","v":65271128.036627308},{"$f":"SUM(E77:E79)","v":65526234.52613984},{"$f":"SUM(F77:F79)","v":65717248.203441828},{"$f":"SUM(G77:G79)","v":65846682.459878027},null,{"$f":"SUM(I77:I79)","v":276824538.0247907}]
[null,"De-escalated to 14/15",{"$f":"C80/(1+CPI)","v":63358393.764178082},{"$f":"D80/(1+CPI)^2","v":62065432.910444602},{"$f":"E80/(1+CPI)^3","v":60758664.282020167},{"$f":"F80/(1+CPI)^4","v":59420555.972531326},{"$f":"G80/(1+CPI)^5","v":58057131.640486337}]
[null,null,{"$f":"C80-C52","v":0},{"$f":"D80-D52","v":241909.86268618703},{"$f":"E80-E52","v":66946.547208413482},{"$f":"F80-F52","v":-158171.16547168791},{"$f":"G80-G52","v":-194449.45809532702},null,{"$f":"I80-I52","v":6.999969482421875E-4}]
[]
["Examples of annual charges for NTC combinations"]
[]
[null,null,{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[{"$f":"'NTCs per NMI'!B7","v":0.41461598207986605},"Primary",{"$f":"C62","v":35.286889974498905},{"$f":"D62","v":34.76082523053735},34.242603175887304,33.732106890005539,33.229221195426092]
[{"$f":"'NTCs per NMI'!B16","v":1.0157455085230349E-3},"Primary x 2",{"$f":"C62*2","v":70.57377994899781},{"$f":"D62*2","v":69.521650461074699},68.485206351774607,67.464213780011079,66.458442390852184]
[{"$f":"'NTCs per NMI'!B8","v":0.39241126213281852},"Primary + Load Control",{"$f":"C62+C63","v":45.872956966848577},{"$f":"D62+D63","v":45.189072799698558},44.515384128653494,43.8517389570072,43.197987554053917]
[{"$f":"'NTCs per NMI'!B9","v":5.9636903676373891E-3},"Primary + Load Control x 2",{"$f":"C62+C63*2","v":56.459023959198248},{"$f":"D62+D63*2","v":55.617320368859765},54.788165081419685,53.97137102400886,53.166753912681742]
[{"$f":"'NTCs per NMI'!B12","v":0.11819485021386601},"Primary + Load Control + Solar PV",{"$f":"C62+C63+C64","v":70.57377994899781},{"$f":"D62+D63+D64","v":69.521650461074699},68.485206351774607,67.464213780011079,66.458442390852184]
[{"$f":"'NTCs per NMI'!B10","v":6.1540518291774711E-2},"Primary + Solar PV",{"$f":"C62+C64","v":59.987712956648139},{"$f":"D62+D64","v":59.093402891913499},58.212425399008417,57.344581713009418,56.489676032224352]
[]
[]
["Price Breakdown"]
[]
[null,"PTRM output with smoothing applied",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"ROA & Depn",{"$f":"C5/C$7*C$80","v":45076583.221083738},{"$f":"D5/D$7*D$80","v":45182213.849595234},44963290.627233081,44414229.732826665,44123178.836802475]
[null,"O&M (incl DRC and Tax)",{"$f":"C6/C$7*C$80","v":19897449.58408089},{"$f":"D6/D$7*D$80","v":20088914.187032074},20562943.898906749,21303018.47061516,21723503.623075552]
[null,null,{"$f":"SUM(C98:C99)","v":64974032.805164628},{"$f":"SUM(D98:D99)","v":65271128.036627308},65526234.526139826,65717248.203441828,65846682.459878027]
[null,null,{"$f":"C100-C80","v":0},{"$f":"D100-D80","v":0},0,0,0]
[null,"ROA & Depn",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C$98*C30","v":34102699.626279213},{"$f":"D$98*D30","v":33866840.902845711},33413507.886824012,32754643.684196107,32323157.546554144]
[null,"Load Control",{"$f":"C$98*C31","v":5434812.5087058693},5365680.0857049711,5262909.1019247212,5128974.3973969193,5031825.3640867788]
[null,"Solar PV",{"$f":"C$98*C32","v":5539071.0860986523},5949692.861044555,6286873.6384843476,6530611.6512336414,6768195.92616155]
[]
[null,null,{"$f":"SUM(C103:C106)","v":45076583.22108373},{"$f":"SUM(D103:D106)","v":45182213.849595234},44963290.627233073,44414229.732826672,44123178.836802475]
[null,null,{"$f":"C98-C107","v":0},{"$f":"D98-D107","v":0},0,0,0]
[null,"O&M (incl DRC and Tax)",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"C$99*C30","v":15053420.157576684},{"$f":"D$99*D30","v":15057873.501903012},15280912.018621119,15710568.067943376,15913908.484901356]
[null,"Load Control",{"$f":"C$99*C31","v":2399004.0984367961},2385688.4736903994,2406872.4307819498,2460081.7571379053,2477357.2396431626]
[null,"Solar PV",{"$f":"C$99*C32","v":2445025.3280674084},2645352.2114386647,2875159.4495036788,3132368.6455338798,3332237.8985310327]
[]
[null,null,17345579.970383264,17806423.989629809,18230227.356348861,18745966.711704317,19274579.992490675]
[]
[]
[null,"CAPEX"]
[null,"Meter Provision & Installation",0.80236123343015897]
[null,"Meter Maintenance",0.19763876656984081]
[null,"OPEX"]
[null,"Meter Provision & Installation",2.1610769637138552E-2]
[null,"Meter Maintenance",9.7493178856993656E-2]
[null,"Meter Reading",0.75632503984412813]
[null,"Meter Data Services",0.12457101166173982]
[]
[null,"$ per NTC per annum (smoothed)",{"$f":"YEAR_1","v":"2015/16"},{"$f":"YEAR_2","v":"2016/17"},{"$f":"YEAR_3","v":"2017/18"},{"$f":"YEAR_4","v":"2018/19"},{"$f":"YEAR_5","v":"2019/20"}]
[null,"Primary",{"$f":"SUM(C128:C131)","v":35.286889974498898},{"$f":"C127*(1+D$58)*(1-D$59)","v":34.760825230537343},{"$f":"D127*(1+E$58)*(1-E$59)","v":34.242603175887297},{"$f":"E127*(1+F$58)*(1-F$59)","v":33.732106890005532},{"$f":"F127*(1+G$58)*(1-G$59)","v":33.229221195426085}]
[null,"Meter Provision & Installation",{"$f":"$C118*C$103/C$12+$C121*C$110/C$12","v":19.87592630424356},19.537831064362461,19.085185719395252,18.528094845098071,18.10273328876616]
[null,"Meter Maintenance",5.8918692147628651,5.7986728059574233,5.6915261110803748,5.5717141527178509,5.4695197833190177]
[null,"Meter Reading",{"$f":"$C123*C$110/C$12","v":8.1729614760140663},8.0915906208064818,8.127282029179332,8.2701563648140564,8.2913378805292925]
[null,"Meter Data Service",1.3461329794784038,1.3327307394109869,1.3386093162323418,1.3621415273755622,1.3656302428116132]
[null,"Load Control",{"$f":"SUM(C133:C136)","v":10.58606699234967},{"$f":"C132*(1+D$58)*(1-D$59)","v":10.428247569161202},{"$f":"D132*(1+E$58)*(1-E$59)","v":10.272780952766187},{"$f":"E132*(1+F$58)*(1-F$59)","v":10.119632067001657},{"$f":"F132*(1+G$58)*(1-G$59)","v":9.9687663586278212}]
[null,"Meter Provision & Installation",{"$f":"$C118*C$104/C$13+$C121*C$111/C$13","v":5.9627778912730687},5.8613493193087391,5.725555715818575,5.5584284535294213,5.4308199866298486]
[null,"Meter Maintenance",1.7675607644288602,1.7396018417872265,1.7074578333241126,1.6715142458153553,1.6408559349957055]
[null,"Meter Reading",{"$f":"$C123*C$111/C$13","v":2.4518884428042198},2.4274771862419446,2.4381846087537995,2.4810469094442165,2.4874013641587878]
[null,"Meter Data Service",0.40383989384352115,0.39981922182329599,0.4015827948697025,0.40864245821266865,0.40968907284348394]
[null,"Solar PV",{"$f":"SUM(C138:C141)","v":24.700822982149234},{"$f":"SUM(D138:D141)","v":24.332577661376146},23.969822223121103,23.612474823003872,23.26045483679826]
[null,"Meter Provision & Installation",{"$f":"$C118*C$105/C$14+$C121*C$112/C$14","v":13.913148412970495},13.676481745053723,13.359630003576671,12.969666391568644,12.671913302136314]
[null,"Meter Maintenance",4.1243084503340066,4.0590709641701954,3.9840682777562613,3.9001999069024951,3.8286638483233131]
[null,"Meter Reading",{"$f":"$C123*C$112/C$14","v":5.7210730332098469},5.6641134345645376,5.6890974204255302,5.7891094553698377,5.8039365163705048]
[null,"Meter Data Service",0.94229308563488268,0.93291151758769064,0.93702652136263898,0.95349906916289318,0.95594116996812928]

{"sheet":"PTRM output","index":6,"n_rows":119,"n_cols":11,"rows_kept":119,"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",{"$f":"C60","v":262.96236450346998},{"$f":"D60","v":247.03816409904712},230.4664635379919,213.23315346983756,195.32404424459875,176.72487655723086]
[null,"Metering - electronic",{"$f":"C67","v":163.57837272843588},{"$f":"D67","v":159.40652908610016},154.72558973384929,149.63297381198922,144.01168222928709,137.77493115919964]
[null,"Office Equipment & Furniture",{"$f":"C74","v":-0.12443696437657673},{"$f":"D74","v":-7.7702413624714861E-2},-2.7737101169282588E-2,9.7588910402822467E-3,9.8744036986191906E-3,9.7616525568842965E-3]
[null,"Motor Vehicles",{"$f":"C81","v":4.016483621693939},{"$f":"D81","v":3.4538446387361526},2.8696934940967793,2.1899181615824537,1.4860929535799845,0.78001723641465925]
[null,"Plant & Equipment",{"$f":"C88","v":1.1890989252946325},{"$f":"D88","v":1.0246301678623069},0.83992957894029308,0.63548016814068753,0.41194935772148267,0.17011518668203054]
[null,"Buildings",{"$f":"C95","v":9.8429266820763583},{"$f":"D95","v":9.914633534503853},9.7286673479010268,9.4373332805158388,9.432016725083141,9.4191629411020568]
[null,"Land",{"$f":"C102","v":6.0343913507006164},{"$f":"D102","v":6.0271296312467069},5.6616934348897656,5.5627872370935112,5.7046383116393962,5.8788329716736243]
[null,"IT Systems",{"$f":"C109","v":1.2636277250696657},{"$f":"D109","v":0.91566238523662624},0.57346846064210699,0.20589429238407383,8.1885815784688454E-2,7.9422946885919596E-2]
[null,"Total",{"$f":"SUM(C7:C14)","v":448.76282857236453},{"$f":"SUM(D7:D14)","v":427.7028911291082},404.83776848714189,380.90729931258363,356.46218404139319,330.83712065174569]
[null,"Meters only",{"$f":"SUM(C7:C8)","v":426.54073723190584},{"$f":"SUM(D7:D8)","v":406.44469318514729},385.19205327184119,362.86612728182678,339.33572647388587,314.4998077164305]
[]
[]
[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,{"$f":"'[9]X factor'!E11*10^6","v":26234674.958340414},{"$f":"'[9]X factor'!F11*10^6","v":25003511.015407652},{"$f":"'[9]X factor'!G11*10^6","v":23666815.945758305},{"$f":"'[9]X factor'!H11*10^6","v":22267840.717813633},{"$f":"'[9]X factor'!I11*10^6","v":20838779.279059842},null,{"$f":"NPV(WACC,D21:H21)","v":100488164.91841646},{"$f":"J21/$J$25","v":0.36300309804787406}]
[null,"Return of capital",null,{"$f":"'[9]X factor'!E12*10^6","v":18841908.262743331},{"$f":"'[9]X factor'!F12*10^6","v":20011247.123263139},{"$f":"'[9]X factor'!G12*10^6","v":21250536.789874729},{"$f":"'[9]X factor'!H12*10^6","v":22253287.137993183},{"$f":"'[9]X factor'!I12*10^6","v":23414698.122434746},null,{"$f":"NPV(WACC,D22:H22)","v":88937376.557571456},{"$f":"J22/$J$25","v":0.32127707027847235}]
[null,"O&M",null,{"$f":"'[9]X factor'!E13*10^6","v":16681408.699021371},{"$f":"'[9]X factor'!F13*10^6","v":16657031.08018682},{"$f":"'[9]X factor'!G13*10^6","v":17026839.77989313},{"$f":"'[9]X factor'!H13*10^6","v":17690008.537501603},{"$f":"'[9]X factor'!I13*10^6","v":17951569.804943115},null,{"$f":"NPV(WACC,D23:H23)","v":72592693.833626285},0.2622335951566146]
[null,"Benchmark Tax liability",null,{"$f":"'[9]X factor'!E$15*10^6","v":3216040.8850595234},{"$f":"'[9]X factor'!F$15*10^6","v":3357428.9550835057},{"$f":"'[9]X factor'!G$15*10^6","v":3515095.4634052617},{"$f":"'[9]X factor'!H$15*10^6","v":3664282.9756050967},{"$f":"'[9]X factor'!I$15*10^6","v":3836084.7115356522},null,{"$f":"NPV(WACC,D24:H24)","v":14806302.714476552},5.3486236517038918E-2]
[null,"Total unsmoothed revenue - before adjustments",71375217.951696068,{"$f":"SUM(D21:D24)","v":64974032.805164635},{"$f":"SUM(E21:E24)","v":65029218.173941113},{"$f":"SUM(F21:F24)","v":65459287.97893142},{"$f":"SUM(G21:G24)","v":65875419.368913516},{"$f":"SUM(H21:H24)","v":66041131.917973362},null,{"$f":"NPV(WACC,D25:H25)","v":276824538.02409077}]
[null,"NPV",{"$f":"NPV(WACC,D25:H25)","v":276824538.02409077},{"$f":"AVERAGE(E26:H26)","v":4.0838693726638065E-3},{"$f":"E25/D25-1","v":8.4934498281730164E-4},{"$f":"F25/E25-1","v":6.6134857079158671E-3},{"$f":"G25/F25-1","v":6.3571022971717905E-3},{"$f":"H25/G25-1","v":2.5155445027502665E-3}]
[]
[null,"Total smoothed revenue after adjustments",{"$f":"C25","v":71375217.951696068},{"$f":"C28*(1-D31)*(1+CPI)","v":62366600.589758024},{"$f":"D28*(1-E31)*(1+CPI)","v":63956948.904796861},{"$f":"E28*(1-F31)*(1+CPI)","v":65587851.101869188},{"$f":"F28*(1-G31)*(1+CPI)","v":67260341.304966852},{"$f":"G28*(1-H31)*(1+CPI)","v":68975480.008243516},{"$f":"H28/H25-1","v":4.4432128963427964E-2}]
[null,"NPV",{"$f":"NPV(WACC,D28:H28)","v":276824538.02409071}]
[null,null,{"$f":"C26-C29","v":0}]
[null,"Adjusted revenue X factors",null,0.14794238823393788,0,0,0,0]
[]
[null,"Smoothed"]
[null,"ROA & Depn (incl Tax & Smoothing)",null,{"$f":"(D21+D22)/(D$21+D$22+D$23)*D$28","v":45520801.021788359},{"$f":"E21+E22+D$34/D$36*(E$28-E$21-E$22-E$23)","v":46682674.914364599},{"$f":"F21+F22+$D$34/$D$36*(F$28-F$21-F$22-F$23)","v":47576825.208588205},{"$f":"G21+G22+$D$34/$D$36*(G$28-G$21-G$22-G$23)","v":48206495.503367603},{"$f":"H21+H22+$D$34/$D$36*(H$28-H$21-H$22-H$23)","v":49195153.258251227}]
[null,"O&M (incl Tax & Smoothing)",null,{"$f":"(D23)/(D$21+D$22+D$23)*D$28","v":16845799.567969669},{"$f":"E23+D$35/D$36*(E$28-E$21-E$22-E$23)","v":17274273.990432259},{"$f":"F23+$D$35/$D$36*(F$28-F$21-F$22-F$23)","v":18011025.893280979},{"$f":"G23+$D$35/$D$36*(G$28-G$21-G$22-G$23)","v":19053845.801599246},{"$f":"H23+$D$35/$D$36*(H$28-H$21-H$22-H$23)","v":19780326.749992292}]
[null,null,null,{"$f":"SUM(D34:D35)","v":62366600.589758024},{"$f":"SUM(E34:E35)","v":63956948.904796854},65587851.101869181,67260341.304966852,68975480.008243516]
[]
[null,"Not Smoothed"]
[null,"ROA & Depn",null,{"$f":"SUM(D21:D22)","v":45076583.221083745},{"$f":"SUM(E21:E22)","v":45014758.138670787},44917352.735633031,44521127.855806813,44253477.401494592]
[null,"O&M (including DRC and Tax)",null,{"$f":"SUM(D23:D24)","v":19897449.584080894},{"$f":"SUM(E23:E24)","v":20014460.035270326},20541935.243298393,21354291.5131067,21787654.516478766]
[null,null,null,{"$f":"SUM(D39:D40)","v":64974032.805164635},{"$f":"SUM(E39:E40)","v":65029218.173941113},{"$f":"SUM(F39:F40)","v":65459287.978931427},65875419.368913516,66041131.917973354]
[]
[null,"Capital ",null,28198528.373914801,29212425.8323805,30011356.5682639,28453853.836382002,30203025.336761501]
[null,"OPEX",null,17587134.066959631,17413324.029038697,17092078.000442453,17416425.951933566,17635843.442622762]
[null,"Multi-Use Assets",null,1487015.3988256708,1644100.9797240079,1846530.4108146087,1646718.9034457582,1805360.1458424954]
[null,"Debt Raising Costs",null,474976.09206355794,486580.51868635393,497142.64241493802,506322.38070908299,511219.47981110116]
[]
[]
[]
[]
[null,null,{"$f":"C6","v":"2014/15"},{"$f":"D6","v":"2015/16"},"2016/17","2017/18","2018/19","2019/20"]
[null,"CPI index",null,{"$f":"1+CPI","v":1.0255000000000001},{"$f":"D52*(1+CPI)","v":1.0516502500000002},{"$f":"E52*(1+CPI)","v":1.0784673313750004},{"$f":"F52*(1+CPI)","v":1.105968248325063},{"$f":"G52*(1+CPI)","v":1.1341704386573521}]
[]
[null,"Metering RAB"]
[null,{"$f":"B$7","v":"Metering - disc"}]
[null,"Opening Balance",null,{"$f":"C60","v":262.96236450346998},{"$f":"D60","v":247.03816409904712},{"$f":"E60","v":230.4664635379919},213.23315346983756,195.32404424459875]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$42","v":-4.9091956340065641},{"$f":"[9]Assets!H$42","v":-5.034380122673733},{"$f":"[9]Assets!I$42","v":-5.1627568158019139},{"$f":"[9]Assets!J$42","v":-5.294407114604863},{"$f":"[9]Assets!K$42","v":-5.4294144960272872}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$88*D$52","v":17.72054506525479},{"$f":"[9]Assets!H$88*E$52","v":17.836793622907205},{"$f":"[9]Assets!I$88*F$52","v":17.947448072571213},{"$f":"[9]Assets!J$88*G$52","v":18.05214752411479},{"$f":"[9]Assets!K$88*H$52","v":18.150516319577896}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D56*CPI","v":6.7055402948384843},{"$f":"E56*CPI","v":6.2994731845257013},{"$f":"F56*CPI","v":5.8768948202187934},{"$f":"G56*CPI","v":5.4374454134808579},{"$f":"H56*CPI","v":4.9807631282372675}]
[null,"Closing Balance",{"$f":"[9]Input!J$7","v":262.96236450346998},{"$f":"D56+D57-D58+D59","v":247.03816409904712},{"$f":"E56+E57-E58+E59","v":230.4664635379919},213.23315346983756,195.32404424459875,176.72487655723086]
[]
[null,{"$f":"B$8","v":"Metering - electronic"}]
[null,"Opening Balance",null,{"$f":"C67","v":163.57837272843588},{"$f":"D67","v":159.40652908610016},{"$f":"E67","v":154.72558973384929},149.63297381198922,144.01168222928709]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$43","v":2.680150403819427},{"$f":"[9]Assets!H$43","v":2.7417623411019223},{"$f":"[9]Assets!I$43","v":2.9298278657471593},{"$f":"[9]Assets!J$43","v":3.0364991073092309},{"$f":"[9]Assets!K$43","v":3.0900503814024023}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$101*D$52","v":11.023242550730266},{"$f":"[9]Assets!H$101*E$52","v":11.487568185048346},{"$f":"[9]Assets!I$101*F$52","v":11.967946325820416},{"$f":"[9]Assets!J$101*G$52","v":12.473431522217084},{"$f":"[9]Assets!K$101*H$52","v":12.99909934833666}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D63*CPI","v":4.1712485045751144},{"$f":"E63*CPI","v":4.0648664916955539},{"$f":"F63*CPI","v":3.9455025382131566},{"$f":"G63*CPI","v":3.8156408322057249},{"$f":"H63*CPI","v":3.6722978968468207}]
[null,"Closing Balance",{"$f":"[9]Input!J$8","v":163.57837272843588},{"$f":"D63+D64-D65+D66","v":159.40652908610016},{"$f":"E63+E64-E65+E66","v":154.72558973384929},{"$f":"F63+F64-F65+F66","v":149.63297381198922},{"$f":"G63+G64-G65+G66","v":144.01168222928709},{"$f":"H63+H64-H65+H66","v":137.77493115919964}]
[]
[null,{"$f":"B$9","v":"Office Equipment & Furniture"}]
[null,"Opening Balance",null,{"$f":"C74","v":-0.12443696437657673},{"$f":"D74","v":-7.7702413624714861E-2},{"$f":"E74","v":-2.7737101169282588E-2},9.7588910402822467E-3,9.8744036986191906E-3]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$44","v":3.5407726163998736E-3},{"$f":"[9]Assets!H$44","v":4.9161699855602477E-3},{"$f":"[9]Assets!I$44","v":2.7778244749532767E-3},{"$f":"[9]Assets!J$44","v":1.5577120779577411E-3},{"$f":"[9]Assets!K$44","v":1.5978293286183947E-3}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$114*D$52","v":-4.6366920727064685E-2},{"$f":"[9]Assets!H$114*E$52","v":-4.7030554017302259E-2},{"$f":"[9]Assets!I$114*F$52","v":-3.5425463814428265E-2},{"$f":"[9]Assets!J$114*G$52","v":1.6910511411479955E-3},{"$f":"[9]Assets!K$114*H$52","v":1.9623777646680784E-3}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D70*CPI","v":-3.1731425916027064E-3},{"$f":"E70*CPI","v":-1.9814115474302289E-3},{"$f":"F70*CPI","v":-7.0729607981670592E-4},{"$f":"G70*CPI","v":2.4885172152719728E-4},{"$f":"H70*CPI","v":2.5179729431478934E-4}]
[null,"Closing Balance",{"$f":"[9]Input!J$9","v":-0.12443696437657673},{"$f":"D70+D71-D72+D73","v":-7.7702413624714861E-2},{"$f":"E70+E71-E72+E73","v":-2.7737101169282588E-2},{"$f":"F70+F71-F72+F73","v":9.7588910402822467E-3},{"$f":"G70+G71-G72+G73","v":9.8744036986191906E-3},{"$f":"H70+H71-H72+H73","v":9.7616525568842965E-3}]
[]
[null,{"$f":"B$10","v":"Motor Vehicles"}]
[null,"Opening Balance",null,{"$f":"C81","v":4.016483621693939},{"$f":"D81","v":3.4538446387361526},{"$f":"E81","v":2.8696934940967793},2.1899181615824537,1.4860929535799845]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$45","v":-9.5344286912066537E-3},{"$f":"[9]Assets!H$45","v":-1.0673980203867611E-3},{"$f":"[9]Assets!I$45","v":-6.4802588089906729E-2},{"$f":"[9]Assets!J$45","v":-6.1337892047540372E-2},{"$f":"[9]Assets!K$45","v":-3.4807052675196605E-2}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$127*D$52","v":0.6555248866197757},{"$f":"[9]Assets!H$127*E$52","v":0.67115678490675834},{"$f":"[9]Assets!I$127*F$52","v":0.68814992852388679},{"$f":"[9]Assets!J$127*G$52","v":0.69833022907528153},{"$f":"[9]Assets!K$127*H$52","v":0.70916403480641821}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D77*CPI","v":0.10242033235319543},{"$f":"E77*CPI","v":8.8073038287771882E-2},{"$f":"F77*CPI","v":7.3177184099467871E-2},{"$f":"G77*CPI","v":5.5842913120352562E-2},{"$f":"H77*CPI","v":3.7895370316289603E-2}]
[null,"Closing Balance",{"$f":"[9]Input!J$10","v":4.016483621693939},{"$f":"D77+D78-D79+D80","v":3.4538446387361526},{"$f":"E77+E78-E79+E80","v":2.8696934940967793},{"$f":"F77+F78-F79+F80","v":2.1899181615824537},{"$f":"G77+G78-G79+G80","v":1.4860929535799845},{"$f":"H77+H78-H79+H80","v":0.78001723641465925}]
[]
[null,{"$f":"B$11","v":"Plant & Equipment"}]
[null,"Opening Balance",null,{"$f":"C88","v":1.1890989252946325},{"$f":"D88","v":1.0246301678623069},{"$f":"E88","v":0.83992957894029308},0.63548016814068753,0.41194935772148267]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$46","v":4.7620402820741932E-2},{"$f":"[9]Assets!H$46","v":4.4988081271616756E-2},{"$f":"[9]Assets!I$46","v":4.3297196437363662E-2},{"$f":"[9]Assets!J$46","v":4.2861195425236712E-2},{"$f":"[9]Assets!K$46","v":4.3966181668362497E-2}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$140*D$52","v":0.2424111828480805},{"$f":"[9]Assets!H$140*E$52","v":0.25581673947411943},{"$f":"[9]Assets!I$140*F$52","v":0.26916481149994664},{"$f":"[9]Assets!J$140*G$52","v":0.28259675013202912},{"$f":"[9]Assets!K$140*H$52","v":0.29630506132971246}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D84*CPI","v":3.0322022595013126E-2},{"$f":"E84*CPI","v":2.6128069280488823E-2},{"$f":"F84*CPI","v":2.1418204262977473E-2},{"$f":"G84*CPI","v":1.620474428758753E-2},{"$f":"H84*CPI","v":1.0504708621897807E-2}]
[null,"Closing Balance",{"$f":"[9]Input!J$11","v":1.1890989252946325},{"$f":"D84+D85-D86+D87","v":1.0246301678623069},{"$f":"E84+E85-E86+E87","v":0.83992957894029308},{"$f":"F84+F85-F86+F87","v":0.63548016814068753},{"$f":"G84+G85-G86+G87","v":0.41194935772148267},{"$f":"H84+H85-H86+H87","v":0.17011518668203054}]
[]
[null,{"$f":"B$12","v":"Buildings"}]
[null,"Opening Balance",null,{"$f":"C95","v":9.8429266820763583},{"$f":"D95","v":9.914633534503853},{"$f":"E95","v":9.7286673479010268},9.4373332805158388,9.432016725083141]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$47","v":0.11716125960721679},{"$f":"[9]Assets!H$47","v":-0.13177713190872256},{"$f":"[9]Assets!I$47","v":-0.22795249980151028},{"$f":"[9]Assets!J$47","v":6.7592194571996791E-2},{"$f":"[9]Assets!K$47","v":6.9919232166260559E-2}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$153*D$52","v":0.29644903757266999},{"$f":"[9]Assets!H$153*E$52","v":0.30701220982395311},{"$f":"[9]Assets!I$153*F$52","v":0.31146258495515405},{"$f":"[9]Assets!J$153*G$52","v":0.31356074865784928},{"$f":"[9]Assets!K$153*H$52","v":0.32328944263696402}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D91*CPI","v":0.25099463039294712},{"$f":"E91*CPI","v":0.25282315512984821},{"$f":"F91*CPI","v":0.24808101737147617},{"$f":"G91*CPI","v":0.24065199865315387},{"$f":"H91*CPI","v":0.24051642648962007}]
[null,"Closing Balance",{"$f":"[9]Input!J$12","v":9.8429266820763583},{"$f":"D91+D92-D93+D94","v":9.914633534503853},{"$f":"E91+E92-E93+E94","v":9.7286673479010268},{"$f":"F91+F92-F93+F94","v":9.4373332805158388},{"$f":"G91+G92-G93+G94","v":9.432016725083141},{"$f":"H91+H92-H93+H94","v":9.4191629411020568}]
[]
[null,{"$f":"B$13","v":"Land"}]
[null,"Opening Balance",null,{"$f":"C102","v":6.0343913507006164},{"$f":"D102","v":6.0271296312467069},{"$f":"E102","v":5.6616934348897656},5.5627872370935112,5.7046383116393962]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$48","v":-0.16113869889677523},{"$f":"[9]Assets!H$48","v":-0.51912800195373243},{"$f":"[9]Assets!I$48","v":-0.24327938038594343},{"$f":"[9]Assets!J$48","v":0},{"$f":"[9]Assets!K$48","v":2.8726383087423975E-2}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$166*D$52","v":0},{"$f":"[9]Assets!H$166*E$52","v":0},{"$f":"[9]Assets!I$166*F$52","v":0},{"$f":"[9]Assets!J$166*G$52","v":0},{"$f":"[9]Assets!K$166*H$52","v":0}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D98*CPI","v":0.15387697944286571},{"$f":"E98*CPI","v":0.15369180559679102},{"$f":"F98*CPI","v":0.14437318258968901},{"$f":"G98*CPI","v":0.14185107454588453},{"$f":"H98*CPI","v":0.14546827694680459}]
[null,"Closing Balance",{"$f":"[9]Input!J$13","v":6.0343913507006164},{"$f":"D98+D99-D100+D101","v":6.0271296312467069},{"$f":"E98+E99-E100+E101","v":5.6616934348897656},{"$f":"F98+F99-F100+F101","v":5.5627872370935112},{"$f":"G98+G99-G100+G101","v":5.7046383116393962},{"$f":"H98+H99-H100+H101","v":5.8788329716736243}]
[]
[null,{"$f":"B$14","v":"IT Systems"}]
[null,"Opening Balance",null,{"$f":"C109","v":1.2636277250696657},{"$f":"D109","v":0.91566238523662624},{"$f":"E109","v":0.57346846064210699},0.20589429238407383,8.1885815784688454E-2]
[null,"Nominal capex",null,{"$f":"[9]Assets!G$49","v":1.3366742217794903E-2},{"$f":"[9]Assets!H$49","v":4.0810543494263669E-2},{"$f":"[9]Assets!I$49","v":4.2956012736256266E-2},{"$f":"[9]Assets!J$49","v":1.5406664070709978E-2},{"$f":"[9]Assets!K$49","v":1.9596273836675091E-2}]
[null,"Nominal SL Depn",null,{"$f":"[9]Assets!G$179*D$52","v":0.39355458904011081},{"$f":"[9]Assets!H$179*E$52","v":0.4063538589123169},{"$f":"[9]Assets!I$179*F$52","v":0.42515362674066315},{"$f":"[9]Assets!J$179*G$52","v":0.14466544512588925},{"$f":"[9]Assets!K$179*H$52","v":2.4147231037953503E-2}]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D105*CPI","v":3.2222506989276471E-2},{"$f":"E105*CPI","v":2.3349390823533968E-2},{"$f":"F105*CPI","v":1.4623445746373727E-2},{"$f":"G105*CPI","v":5.2503044557938826E-3},{"$f":"H105*CPI","v":2.0880883025095553E-3}]
[null,"Closing Balance",{"$f":"[9]Input!J$14","v":1.2636277250696657},{"$f":"D105+D106-D107+D108","v":0.91566238523662624},{"$f":"E105+E106-E107+E108","v":0.57346846064210699},{"$f":"F105+F106-F107+F108","v":0.20589429238407383},{"$f":"G105+G106-G107+G108","v":8.1885815784688454E-2},{"$f":"H105+H106-H107+H108","v":7.9422946885919596E-2}]
[]
[]
[null,"Total "]
[null,"Opening Balance",null,{"$f":"C117","v":448.76282857236453},{"$f":"D117","v":427.7028911291082},{"$f":"E117","v":404.83776848714189},380.90729931258363,356.46218404139319]
[null,"Nominal capex",null,{"$f":"SUM(D57,D64,D71,D78,D85,D92,D99,D106)","v":-2.2180291805129655},-2.8538755187032119,-2.6799323846835419,-2.1918281331972711,-2.2103652672127412]
[null,"Nominal SL Depn",null,{"$f":"SUM(D58,D65,D72,D79,D86,D93,D100,D107)","v":30.285360391338632},30.917670847055401,31.573899886296854,31.96642327046407,32.504483815490268]
[null,"Inflation on Opening Opening Balance",null,{"$f":"D113*CPI","v":11.443452128595295},{"$f":"E113*CPI","v":10.906423723792258},{"$f":"F113*CPI","v":10.323363096422117},{"$f":"G113*CPI","v":9.7131361324708827},{"$f":"H113*CPI","v":9.089785693055525}]
[null,"Closing Balance",{"$f":"SUM(C60,C67,C74,C81,C88,C95,C102,C109)","v":448.76282857236453},{"$f":"D113+D114-D115+D116","v":427.7028911291082},{"$f":"E113+E114-E115+E116","v":404.83776848714189},{"$f":"F113+F114-F115+F116","v":380.90729931258363},{"$f":"G113+G114-G115+G116","v":356.46218404139319},{"$f":"H113+H114-H115+H116","v":330.83712065174569}]
[null,"Check",{"$f":"C117-C119","v":0},{"$f":"D117-D119","v":0},0,0,0,0]
[null,"Nominal Residual RAB (end period) - PTRM",{"$f":"[9]Assets!F$474","v":448.76282857236453},{"$f":"[9]Assets!G$474","v":427.70289112910825},{"$f":"[9]Assets!H$474","v":404.83776848714194},{"$f":"[9]Assets!I$474","v":380.90729931258375},{"$f":"[9]Assets!J$474","v":356.4621840413933},{"$f":"[9]Assets!K$474","v":330.83712065174586}]

{"sheet":"Demand Forecast","index":7,"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}]
[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,2612625.5120661161,{"$f":"N17-N16","v":93036.817359650042},3.6925398798270503E-2]
[2018,1422042.1370699252,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,8.2098978339552889E-2,0.14109205418084564,2709097.7510096929,96472.238943576813,3.6925398798270503E-2]
[2019,1436767.8050672051,14725.667997279903,null,0.51146320966587122,{"$f":"F18*(1+$H$10)","v":749934.20198130852},3321.9742663509678,null,0.26696293766523571,409232.16666666663,27000,7.0637697071544228E-2,0.14567920907168549,2809132.2658492234,100034.51483953046,3.6925398798270503E-2]
[2020,1451645.9617230932,14878.156655888073,null,0.4983575129525778,{"$f":"F19*(1+$H$10)","v":753270.9570302621},3336.7550489535788,null,0.25860178764208769,434232.16666666663,25000,6.1090016954516047E-2,0.1490741326260713,2912860.5950427949,103728.32919357158,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,{"$f":"J39/N39","v":0.13663959940390022},{"$f":"B39+F39+J39","v":2481001.1261663837},null,{"$f":"N39/N38-1","v":2.1678360604034719E-2}]
[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,1.9271693575538373E-2]
[2018,{"$f":"B40*(1+$D$34)","v":1432540.4084933549},15224.332226660335,null,0.55615372979028466,745255.92855962028,{"$f":"F41-F40","v":2760.7851958869724},null,0.28932996365015096,398003,29000,null,0.1545163065595643,2575799.3370529753,null,1.8579900831708462E-2]
[2019,1447928.2753723268,15387.866878971923,null,0.55244232636157931,748026.97905483749,2771.050495217205,null,0.28540209589043075,425003,27000,null,0.16215557774798992,2620958.2544271643,null,1.7532001318804724E-2]
[2020,1463481.4335377999,15553.158165473025,null,0.54929452645306565,750808.33301837044,2781.3539635329507,null,0.28180399032830594,450003,25000,null,0.16890148321862838,2664292.7665561703,null,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}]
[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,2819417.960410302,null,3.6925398798270503E-2]
[2018,1424928.2423800249,15143.433883279096,null,0.48740055572030472,{"$f":"(F41-F40)/2+F40","v":743875.53596167685},2755.6715600166935,null,0.25444463716213267,{"$f":"(J41-J40)/2+J40","v":383503},29500,null,0.13117823744457235,2923526.0929774591,null,3.6925398798270503E-2]
[2019,1440234.3419328409,15306.099552816013,null,0.47509304816251224,{"$f":"(F42-F41)/2+F41","v":746641.45380722894},2765.9178455520887,null,0.24629614351350262,{"$f":"(J42-J41)/2+J41","v":411503},28000,null,0.13574333627932245,3031478.4598578014,null,3.6925398798270503E-2]
[2020,1455704.8544550634,15470.512522222474,null,0.4630963214204315,{"$f":"(F43-F42)/2+F42","v":749417.65603660396},2776.2022293750197,null,0.23840860230420205,{"$f":"(J43-J42)/2+J42","v":437503},26000,null,0.13918070637076202,3143417.0109364176,null,3.6925398798270503E-2]

{"sheet":"PIVOT NMI's","index":8,"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":9,"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":"NTCs per NMI","index":10,"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},{"$f":"SUMIF(F$31:F$60,\"SAC\",$C$31:$C$60)","v":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},{"$f":"SUMIF(F$31:F$60,\"CL\",$C$31:$C$60)","v":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},{"$f":"SUMIF(F$31:F$60,\"FIT\",$C$31:$C$60)","v":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,{"$f":"C8/$C$27","v":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":"Summary by NTC","index":11,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Date"]
[null,"Classification","Values","FEB2014","MAR2014","APR2014"]
[null,"Bus","NMI's",110269,110339,110370]
[null,null,"_MSC",4484191.2049522186,4488456.5662790006,4491112.1355898902,null,{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"FEB2014\",\"Classification\",\"Bus\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"FEB2014\",\"Classification\",\"Bus\")","v":40.665927912216659},{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"MAR2014\",\"Classification\",\"Bus\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"MAR2014\",\"Classification\",\"Bus\")","v":40.678785980288026},{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"APR2014\",\"Classification\",\"Bus\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"APR2014\",\"Classification\",\"Bus\")","v":40.69142099836813}]
[null,"Res","NMI's",1249675,1251196,1252751]
[null,null,"_MSC",64203754.064130299,64354874.758410573,64491491.657472245,null,{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"FEB2014\",\"Classification\",\"Res\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"FEB2014\",\"Classification\",\"Res\")","v":51.376361105191592},{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"MAR2014\",\"Classification\",\"Res\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"MAR2014\",\"Classification\",\"Res\")","v":51.434687098112981},{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"APR2014\",\"Classification\",\"Res\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"APR2014\",\"Classification\",\"Res\")","v":51.479896370046596}]
[null,"Res / Bus","NMI's",2712,2707,2694]
[null,null,"_MSC",248115.55919895539,247802.21768734613,246842.60930804253,null,{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"FEB2014\",\"Classification\",\"Res / Bus\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"FEB2014\",\"Classification\",\"Res / Bus\")","v":91.48803805271217},{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"MAR2014\",\"Classification\",\"Res / Bus\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"MAR2014\",\"Classification\",\"Res / Bus\")","v":91.541269925137101},{"$f":"GETPIVOTDATA(\"_MSC\",$B$3,\"Date\",\"APR2014\",\"Classification\",\"Res / Bus\")/GETPIVOTDATA(\"NMI's\",$B$3,\"Date\",\"APR2014\",\"Classification\",\"Res / Bus\")","v":91.626803752057356}]
[null,"CL","NMI's",127,125,125]
[null,null,"_MSC",1492.28894903945,1468.7883356687498,1468.7883356687498]
[null,"Total NMI's",null,1362783,1364367,1365940]
[null,"Total _MSC",null,68937553.11723052,69092602.330712587,69230915.190705851]

{"sheet":"DATA by NTC","index":12,"n_rows":375,"n_cols":12,"rows_kept":375,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Please note that this information does contain a minimal number of inactive but not decommissioned NMI's"]
[]
[null,"FEB2014",null,{"$f":"SUMIF($A$26:$A$375,B4,$C$26:$C$375)","v":1362783}]
[null,"MAR2014",null,{"$f":"SUMIF($A$26:$A$375,B5,$C$26:$C$375)","v":1364367}]
[null,"APR2014",null,{"$f":"SUMIF($A$26:$A$375,B6,$C$26:$C$375)","v":1365940}]
[]
["NTC","NTC Desc","MSC",null,{"$f":"B4","v":"FEB2014"},{"$f":"B5","v":"MAR2014"},{"$f":"B6","v":"APR2014"}]
[7500,"7500 - Solar PV 2 (net with FIT)",{"$f":"'Price Path Calc'!$C$64","v":24.700822982149234},null,{"$f":"SUMIFS($C$26:$C$375,$A$26:$A$375,E$8,$F$26:$F$375,$A9)+SUMIFS($C$26:$C$375,$A$26:$A$375,E$8,$G$26:$G$375,$A9)+SUMIFS($C$26:$C$375,$A$26:$A$375,E$8,$H$26:$H$375,$A9)+SUMIFS($C$26:$C$375,$A$26:$A$375,E$8,$I$26:$I$375,$A9)+SUMIFS($C$26:$C$375,$A$26:$A$375,E$8,$J$26:$J$375,$A9)+SUMIFS($C$26:$C$375,$A$26:$A$375,E$8,$K$26:$K$375,$A9)","v":44065},48147,51585]
[7600,"7600 - Residential - PeakSmart",{"$f":"'Price Path Calc'!$C$62","v":35.286889974498905},null,0,0,0]
[8300,"8300 - Demand Small",null,null,14,14,14,"is a subset of 8300 as is only those that have 8300 in combination with SACND categories"]
[8400,"8400 - Residential Flat",{"$f":"'Price Path Calc'!$C$62","v":35.286889974498905},null,1252233,1253743,1255282]
[8500,"8500 - Business Flat",{"$f":"'Price Path Calc'!$C$62","v":35.286889974498905},null,99165,99195,99209]
[8800,"8800 - Business - TOU",{"$f":"'Price Path Calc'!$C$62","v":35.286889974498905},null,14476,14508,14510]
[8900,"8900 - Residential TOU",{"$f":"'Price Path Calc'!$C$62","v":35.286889974498905},null,154,160,163]
[9000,"9000 - Controlled Load 1 (super economy)",{"$f":"'Price Path Calc'!$C$63","v":10.586066992349673},null,214458,214578,214673]
[9100,"9100 - Controlled Load 2 (economy)",{"$f":"'Price Path Calc'!$C$63","v":10.586066992349673},null,519500,519431,519469,null,null,1]
[9700,"9700 - Solar PV (gross)",{"$f":"'Price Path Calc'!$C$64","v":24.700822982149234},null,496,495,491]
[9800,"9800 - Solar PV (net)",{"$f":"'Price Path Calc'!$C$64","v":24.700822982149234},null,549,587,623]
[9900,"9900 - Solar PV (net with FIT)",{"$f":"'Price Path Calc'!$C$64","v":24.700822982149234},null,203242,202502,201794]
[null,null,null,null,{"$f":"SUM(E9:E20)","v":2348352},{"$f":"SUM(F9:F20)","v":2353360},{"$f":"SUM(G9:G20)","v":2357813}]
[]
[]
[]
["Date","Classification","NMIs","NTC Count","Total Tariffs","NTC1","NTC2","NTC3","NTC4","NTC5","MSC","Tot MSC"]
["MAR2014","Res / Bus",591,2,{"$f":"C26*D26","v":1182},8400,8500,"","","",{"$f":"IF(ISERROR(VLOOKUP(F26,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F26,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G26,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G26,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H26,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H26,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I26,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I26,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J26,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J26,$A$9:$C$20,3,FALSE))","v":70.57377994899781},{"$f":"C26*K26","v":41709.103949857708}]
["MAR2014","Res / Bus",24,3,{"$f":"C27*D27","v":72},8400,8500,8800,"","",{"$f":"IF(ISERROR(VLOOKUP(F27,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F27,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G27,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G27,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H27,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H27,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I27,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I27,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J27,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J27,$A$9:$C$20,3,FALSE))","v":105.86066992349672},{"$f":"C27*K27","v":2540.6560781639209}]
["MAR2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",116.44673691584639,1048.0206322426175]
["MAR2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,141.14755989799562,141.14755989799562]
["MAR2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,141.14755989799562,423.44267969398686]
["MAR2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",116.44673691584639,1397.3608429901567]
["MAR2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,141.14755989799562,282.29511979599124]
["MAR2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",130.56149290564593,391.6844787169378]
["MAR2014","Res / Bus",242,3,726,8400,8500,9000,"","",81.159846941347482,19640.68295980609]
["MAR2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",91.745913933697153,825.71322540327435]
["MAR2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,116.44673691584639,582.23368457923198]
["MAR2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",105.86066992349672,4975.4514864043458]
["MAR2014","Res / Bus",711,3,2133,8400,8500,9100,"","",81.159846941347482,57704.651175298059]
["MAR2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",105.86066992349672,105.86066992349672]
["MAR2014","Res / Bus",113,4,452,8400,8500,9100,9900,"",105.86066992349672,11962.255701355129]
["MAR2014","Res / Bus",4,3,12,8400,8500,9800,"","",95.274602931147044,381.09841172458817]
["MAR2014","Res / Bus",111,3,333,8400,8500,9900,"","",95.274602931147044,10575.480925357322]
["MAR2014","Res / Bus",253,2,506,8400,8800,"","","",70.57377994899781,17855.166327096445]
["MAR2014","Res / Bus",87,3,261,8400,8800,9000,"","",81.159846941347482,7060.9066838972312]
["MAR2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",91.745913933697153,550.47548360218298]
["MAR2014","Res / Bus",4,5,20,8400,8800,9000,9100,9900,116.44673691584639,465.78694766338555]
["MAR2014","Res / Bus",1,4,4,8400,8800,9000,9800,"",105.86066992349672,105.86066992349672]
["MAR2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",105.86066992349672,3493.4021074753914]
["MAR2014","Res / Bus",250,3,750,8400,8800,9100,"","",81.159846941347482,20289.96173533687]
["MAR2014","Res / Bus",3,4,12,8400,8800,9100,9800,"",105.86066992349672,317.58200977049012]
["MAR2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",105.86066992349672,7092.6648848742798]
["MAR2014","Res / Bus",2,3,6,8400,8800,9800,"","",95.274602931147044,190.54920586229409]
["MAR2014","Res / Bus",41,3,123,8400,8800,9900,"","",95.274602931147044,3906.2587201770289]
["MAR2014","Res",143645,2,287290,8400,9000,"","","",45.872956966848577,6589420.9035029635]
["MAR2014","Res",8208,3,24624,8400,9000,9100,"","",56.459023959198248,463415.66865709925]
["MAR2014","Res",7,4,28,8400,9000,9100,9700,"",81.159846941347482,568.11892858943236]
["MAR2014","Res",7,4,28,8400,9000,9100,9800,"",81.159846941347482,568.11892858943236]
["MAR2014","Res",5579,4,22316,8400,9000,9100,9900,"",81.159846941347482,452790.78608577762]
["MAR2014","Res",60,3,180,8400,9000,9700,"","",70.57377994899781,4234.4267969398688]
["MAR2014","Res",1,4,4,8400,9000,9700,9900,"",95.274602931147044,95.274602931147044]
["MAR2014","Res",38,3,114,8400,9000,9800,"","",70.57377994899781,2681.8036380619169]
["MAR2014","Res",44996,3,134988,8400,9000,9900,"","",70.57377994899781,3175537.8025851054]
["MAR2014","Res",394489,2,788978,8400,9100,"","","",45.872956966848577,18096376.920895129]
["MAR2014","Res",170,3,510,8400,9100,9700,"","",70.57377994899781,11997.542591329628]
["MAR2014","Res",81,3,243,8400,9100,9800,"","",70.57377994899781,5716.4761758688228]
["MAR2014","Res",85505,3,256515,8400,9100,9900,"","",70.57377994899781,6034411.0545390574]
["MAR2014","Res",244,2,488,8400,9700,"","","",59.987712956648139,14637.001961422146]
["MAR2014","Res",2,3,6,8400,9700,9900,"","",84.688535938797372,169.37707187759474]
["MAR2014","Res",126,2,252,8400,9800,"","","",59.987712956648139,7558.4518325376657]
["MAR2014","Res",63362,2,126724,8400,9900,"","","",59.987712956648139,3800941.4683591393]
["MAR2014","Bus",90812,1,90812,8500,"","","","",35.286889974498905,3204473.0523641948]
["MAR2014","Bus",554,2,1108,8500,8800,"","","",70.57377994899781,39097.874091744787]
["MAR2014","Bus",6,3,18,8500,8800,9000,"","",81.159846941347482,486.95908164808486]
["MAR2014","Bus",30,3,90,8500,8800,9100,"","",81.159846941347482,2434.7954082404244]
["MAR2014","Bus",1,4,4,8500,8800,9100,9800,"",105.86066992349672,105.86066992349672]
["MAR2014","Bus",1,4,4,8500,8800,9100,9900,"",105.86066992349672,105.86066992349672]
["MAR2014","Bus",2,3,6,8500,8800,9800,"","",95.274602931147044,190.54920586229409]
["MAR2014","Bus",14,3,42,8500,8800,9900,"","",95.274602931147044,1333.8444410360587]
["MAR2014","Bus",482,2,964,8500,9000,"","","",45.872956966848577,22110.765258021012]
["MAR2014","Bus",9,3,27,8500,9000,9100,"","",56.459023959198248,508.13121563278423]
["MAR2014","Bus",3,4,12,8500,9000,9100,9900,"",81.159846941347482,243.47954082404243]
["MAR2014","Bus",5,3,15,8500,9000,9800,"","",70.57377994899781,352.86889974498905]
["MAR2014","Bus",91,3,273,8500,9000,9900,"","",70.57377994899781,6422.2139753588008]
["MAR2014","Bus",2436,2,4872,8500,9100,"","","",45.872956966848577,111746.52317124313]
["MAR2014","Bus",1,3,3,8500,9100,9700,"","",70.57377994899781,70.57377994899781]
["MAR2014","Bus",18,3,54,8500,9100,9800,"","",70.57377994899781,1270.3280390819605]
["MAR2014","Bus",201,3,603,8500,9100,9900,"","",70.57377994899781,14185.32976974856]
["MAR2014","Bus",5,2,10,8500,9700,"","","",59.987712956648139,299.93856478324068]
["MAR2014","Bus",230,2,460,8500,9800,"","","",59.987712956648139,13797.173980029072]
["MAR2014","Bus",1878,2,3756,8500,9900,"","","",59.987712956648139,112656.9249325852]
["MAR2014","Bus",4,1,{"$f":"C91*D91","v":4},8600,"","","","",{"$f":"IF(ISERROR(VLOOKUP(F91,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F91,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G91,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G91,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H91,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H91,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I91,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I91,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J91,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J91,$A$9:$C$20,3,FALSE))","v":0},{"$f":"C91*K91","v":0}]
["MAR2014","Bus",1,1,1,8700,"","","","",0,0]
["MAR2014","Bus",1,2,2,8700,8800,"","","",35.286889974498905,35.286889974498905]
["MAR2014","Bus",11936,1,11936,8800,"","","","",35.286889974498905,421184.31873561896]
["MAR2014","Bus",100,2,200,8800,9000,"","","",45.872956966848577,4587.2956966848578]
["MAR2014","Bus",4,3,12,8800,9000,9100,"","",56.459023959198248,225.83609583679299]
["MAR2014","Bus",3,4,12,8800,9000,9100,9900,"",81.159846941347482,243.47954082404243]
["MAR2014","Bus",26,3,78,8800,9000,9900,"","",70.57377994899781,1834.918278673943]
["MAR2014","Bus",488,2,976,8800,9100,"","","",45.872956966848577,22386.002999822107]
["MAR2014","Bus",10,3,30,8800,9100,9800,"","",70.57377994899781,705.7377994899781]
["MAR2014","Bus",63,3,189,8800,9100,9900,"","",70.57377994899781,4446.1481367868619]
["MAR2014","Bus",1,2,2,8800,9700,"","","",59.987712956648139,59.987712956648139]
["MAR2014","Bus",57,2,114,8800,9800,"","","",59.987712956648139,3419.2996385289439]
["MAR2014","Bus",328,2,656,8800,9900,"","","",59.987712956648139,19675.969849780591]
["MAR2014","Res",109,1,109,8900,"","","","",35.286889974498905,3846.2710072203809]
["MAR2014","Res",10,2,20,8900,9000,"","","",45.872956966848577,458.72956966848574]
["MAR2014","Res",13,2,26,8900,9100,"","","",45.872956966848577,596.34844056903148]
["MAR2014","Res",9,3,27,8900,9100,9900,"","",70.57377994899781,635.16401954098023]
["MAR2014","Res",9,2,18,8900,9900,"","","",59.987712956648139,539.88941660983323]
["MAR2014","CL",15,1,15,9000,"","","","",10.586066992349673,158.79100488524509]
["MAR2014","CL",110,1,110,9100,"","","","",10.586066992349673,1164.467369158464]
["APR2014","Res",18223,2,36446,7500,8400,"","","",59.987712956648139,1093156.0932089991]
["APR2014","Res / Bus",21,3,63,7500,8400,8500,"","",95.274602931147044,2000.7666615540879]
["APR2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,141.14755989799562,282.29511979599124]
["APR2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",105.86066992349672,635.16401954098023]
["APR2014","Res / Bus",23,4,92,7500,8400,8500,9100,"",105.86066992349672,2434.7954082404244]
["APR2014","Res / Bus",12,3,36,7500,8400,8800,"","",95.274602931147044,1143.2952351737645]
["APR2014","Res / Bus",6,4,24,7500,8400,8800,9000,"",105.86066992349672,635.16401954098023]
["APR2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",105.86066992349672,846.88535938797372]
["APR2014","Res",10617,3,31851,7500,8400,9000,"","",70.57377994899781,749281.82171850977]
["APR2014","Res",972,4,3888,7500,8400,9000,9100,"",81.159846941347482,78887.371226989751]
["APR2014","Res",2,5,10,7500,8400,9000,9100,9700,105.86066992349672,211.72133984699343]
["APR2014","Res",21112,3,63336,7500,8400,9100,"","",70.57377994899781,1489953.6422832417]
["APR2014","Res",1,3,3,7500,8400,9700,"","",84.688535938797372,84.688535938797372]
["APR2014","Bus",421,2,842,7500,8500,"","","",59.987712956648139,25254.827154748866]
["APR2014","Bus",3,3,9,7500,8500,8800,"","",95.274602931147044,285.82380879344112]
["APR2014","Bus",1,4,4,7500,8500,8800,9100,"",105.86066992349672,105.86066992349672]
["APR2014","Bus",28,3,84,7500,8500,9000,"","",70.57377994899781,1976.0658385719387]
["APR2014","Bus",2,4,8,7500,8500,9000,9100,"",81.159846941347482,162.31969388269496]
["APR2014","Bus",60,3,180,7500,8500,9100,"","",70.57377994899781,4234.4267969398688]
["APR2014","Bus",44,2,88,7500,8800,"","","",59.987712956648139,2639.4593700925179]
["APR2014","Bus",5,3,15,7500,8800,9000,"","",70.57377994899781,352.86889974498905]
["APR2014","Bus",5,3,15,7500,8800,9100,"","",70.57377994899781,352.86889974498905]
["APR2014","Res",8,2,16,7500,8900,"","","",59.987712956648139,479.90170365318511]
["APR2014","Res",1,4,4,7500,8900,9000,9100,"",81.159846941347482,81.159846941347482]
["APR2014","Res",2,3,6,7500,8900,9100,"","",70.57377994899781,141.14755989799562]
["APR2014","Res / Bus",2,2,4,8300,8400,"","","",35.286889974498905,70.57377994899781]
["APR2014","Bus",8,2,16,8300,8500,"","","",35.286889974498905,282.29511979599124]
["APR2014","Bus",1,2,2,8300,9000,"","","",10.586066992349673,10.586066992349673]
["APR2014","Bus",1,2,2,8300,9800,"","","",24.700822982149234,24.700822982149234]
["APR2014","Bus",2,2,4,8300,9900,"","","",24.700822982149234,49.401645964298467]
["APR2014","Res",457408,1,457408,8400,"","","","",35.286889974498905,16140505.769455595]
["APR2014","Res / Bus",586,2,1172,8400,8500,"","","",70.57377994899781,41356.235050112715]
["APR2014","Res / Bus",24,3,{"$f":"C144*D144","v":72},8400,8500,8800,"","",105.86066992349672,2540.6560781639209]
["APR2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",116.44673691584639,1048.0206322426175]
["APR2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,141.14755989799562,141.14755989799562]
["APR2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,141.14755989799562,423.44267969398686]
["APR2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",116.44673691584639,1397.3608429901567]
["APR2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,141.14755989799562,282.29511979599124]
["APR2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",130.56149290564593,391.6844787169378]
["APR2014","Res / Bus",241,3,723,8400,8500,9000,"","",81.159846941347482,19559.523112864743]
["APR2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",91.745913933697153,825.71322540327435]
["APR2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,116.44673691584639,582.23368457923198]
["APR2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",105.86066992349672,4975.4514864043458]
["APR2014","Res / Bus",704,3,2112,8400,8500,9100,"","",{"$f":"IF(ISERROR(VLOOKUP(F155,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F155,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G155,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G155,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H155,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H155,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I155,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I155,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J155,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J155,$A$9:$C$20,3,FALSE))","v":81.159846941347482},{"$f":"C155*K155","v":57136.53224670863}]
["APR2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",105.86066992349672,105.86066992349672]
["APR2014","Res / Bus",111,4,444,8400,8500,9100,9900,"",105.86066992349672,11750.534361508135]
["APR2014","Res / Bus",4,3,12,8400,8500,9800,"","",95.274602931147044,381.09841172458817]
["APR2014","Res / Bus",111,3,333,8400,8500,9900,"","",95.274602931147044,10575.480925357322]
["APR2014","Res / Bus",249,2,498,8400,8800,"","","",70.57377994899781,17572.871207300454]
["APR2014","Res / Bus",85,3,255,8400,8800,9000,"","",81.159846941347482,6898.5869900145362]
["APR2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",91.745913933697153,550.47548360218298]
["APR2014","Res / Bus",3,5,15,8400,8800,9000,9100,9900,116.44673691584639,349.34021074753917]
["APR2014","Res / Bus",1,4,4,8400,8800,9000,9800,"",105.86066992349672,105.86066992349672]
["APR2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",105.86066992349672,3493.4021074753914]
["APR2014","Res / Bus",250,3,750,8400,8800,9100,"","",81.159846941347482,20289.96173533687]
["APR2014","Res / Bus",3,4,12,8400,8800,9100,9800,"",105.86066992349672,317.58200977049012]
["APR2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",105.86066992349672,7092.6648848742798]
["APR2014","Res / Bus",3,3,9,8400,8800,9800,"","",95.274602931147044,285.82380879344112]
["APR2014","Res / Bus",41,3,123,8400,8800,9900,"","",95.274602931147044,3906.2587201770289]
["APR2014","Res",143114,2,286228,8400,9000,"","","",45.872956966848577,6565062.3633535672]
["APR2014","Res",8195,3,24585,8400,9000,9100,"","",56.459023959198248,462681.70134562964]
["APR2014","Res",7,4,28,8400,9000,9100,9700,"",81.159846941347482,568.11892858943236]
["APR2014","Res",8,4,32,8400,9000,9100,9800,"",81.159846941347482,649.27877553077985]
["APR2014","Res",5570,4,22280,8400,9000,9100,9900,"",81.159846941347482,452060.34746330546]
["APR2014","Res",58,3,174,8400,9000,9700,"","",70.57377994899781,4093.2792370418729]
["APR2014","Res",1,4,4,8400,9000,9700,9900,"",95.274602931147044,95.274602931147044]
["APR2014","Res",37,3,111,8400,9000,9800,"","",70.57377994899781,2611.2298581129189]
["APR2014","Res",44847,3,134541,8400,9000,9900,"","",70.57377994899781,3165022.3093727049]
["APR2014","Res",393452,2,786904,8400,9100,"","","",45.872956966848577,18048806.664520506]
["APR2014","Res",169,3,507,8400,9100,9700,"","",70.57377994899781,11926.96881138063]
["APR2014","Res",91,3,273,8400,9100,9800,"","",70.57377994899781,6422.2139753588008]
["APR2014","Res",85222,3,255666,8400,9100,9900,"","",70.57377994899781,6014438.6748134913]
["APR2014","Res",243,2,486,8400,9700,"","","",59.987712956648139,14577.014248465497]
["APR2014","Res",2,3,6,8400,9700,9900,"","",84.688535938797372,169.37707187759474]
["APR2014","Res",133,2,266,8400,9800,"","","",59.987712956648139,7978.3658232342023]
["APR2014","Res",63104,2,126208,8400,9900,"","","",59.987712956648139,3785464.6384163243]
["APR2014","Bus",90796,1,90796,8500,"","","","",35.286889974498905,3203908.4621246024]
["APR2014","Bus",552,2,1104,8500,8800,"","","",70.57377994899781,38956.726531846791]
["APR2014","Bus",6,3,18,8500,8800,9000,"","",81.159846941347482,486.95908164808486]
["APR2014","Bus",30,3,90,8500,8800,9100,"","",81.159846941347482,2434.7954082404244]
["APR2014","Bus",1,4,4,8500,8800,9100,9800,"",105.86066992349672,105.86066992349672]
["APR2014","Bus",1,4,4,8500,8800,9100,9900,"",105.86066992349672,105.86066992349672]
["APR2014","Bus",2,3,6,8500,8800,9800,"","",95.274602931147044,190.54920586229409]
["APR2014","Bus",14,3,42,8500,8800,9900,"","",95.274602931147044,1333.8444410360587]
["APR2014","Bus",481,2,962,8500,9000,"","","",45.872956966848577,22064.892301054166]
["APR2014","Bus",9,3,27,8500,9000,9100,"","",56.459023959198248,508.13121563278423]
["APR2014","Bus",4,4,16,8500,9000,9100,9900,"",81.159846941347482,324.63938776538993]
["APR2014","Bus",5,3,15,8500,9000,9800,"","",70.57377994899781,352.86889974498905]
["APR2014","Bus",90,3,270,8500,9000,9900,"","",70.57377994899781,6351.6401954098028]
["APR2014","Bus",2428,2,4856,8500,9100,"","","",45.872956966848577,111379.53951550834]
["APR2014","Bus",1,3,3,8500,9100,9700,"","",70.57377994899781,70.57377994899781]
["APR2014","Bus",18,3,54,8500,9100,9800,"","",70.57377994899781,1270.3280390819605]
["APR2014","Bus",200,3,600,8500,9100,9900,"","",70.57377994899781,14114.755989799562]
["APR2014","Bus",5,2,10,8500,9700,"","","",59.987712956648139,299.93856478324068]
["APR2014","Bus",242,2,484,8500,9800,"","","",59.987712956648139,14517.02653550885]
["APR2014","Bus",1876,2,3752,8500,9900,"","","",59.987712956648139,112536.94950667191]
["APR2014","Bus",4,1,{"$f":"C208*D208","v":4},8600,"","","","",0,0]
["APR2014","Bus",1,1,1,8700,"","","","",0,0]
["APR2014","Bus",1,2,2,8700,8800,"","","",35.286889974498905,35.286889974498905]
["APR2014","Bus",11940,1,11940,8800,"","","","",35.286889974498905,421325.46629551693]
["APR2014","Bus",100,2,200,8800,9000,"","","",45.872956966848577,4587.2956966848578]
["APR2014","Bus",4,3,12,8800,9000,9100,"","",56.459023959198248,225.83609583679299]
["APR2014","Bus",3,4,12,8800,9000,9100,9900,"",81.159846941347482,243.47954082404243]
["APR2014","Bus",26,3,78,8800,9000,9900,"","",70.57377994899781,1834.918278673943]
["APR2014","Bus",487,2,974,8800,9100,"","","",45.872956966848577,22340.130042855257]
["APR2014","Bus",10,3,30,8800,9100,9800,"","",70.57377994899781,705.7377994899781]
["APR2014","Bus",63,3,189,8800,9100,9900,"","",70.57377994899781,4446.1481367868619]
["APR2014","Bus",1,2,2,8800,9700,"","","",{"$f":"IF(ISERROR(VLOOKUP(F219,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F219,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G219,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G219,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H219,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H219,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I219,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I219,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J219,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J219,$A$9:$C$20,3,FALSE))","v":59.987712956648139},{"$f":"C219*K219","v":59.987712956648139}]
["APR2014","Bus",63,2,126,8800,9800,"","","",59.987712956648139,3779.2259162688329]
["APR2014","Bus",325,2,650,8800,9900,"","","",59.987712956648139,19496.006710910646]
["APR2014","Res",110,1,110,8900,"","","","",35.286889974498905,3881.5578971948794]
["APR2014","Res",10,2,20,8900,9000,"","","",45.872956966848577,458.72956966848574]
["APR2014","Res",14,2,28,8900,9100,"","","",45.872956966848577,642.2213975358801]
["APR2014","Res",9,3,27,8900,9100,9900,"","",70.57377994899781,635.16401954098023]
["APR2014","Res",9,2,18,8900,9900,"","","",59.987712956648139,539.88941660983323]
["APR2014","CL",15,1,15,9000,"","","","",10.586066992349673,158.79100488524509]
["APR2014","CL",110,1,110,9100,"","","","",10.586066992349673,1164.467369158464]
["FEB2014","Res",15503,2,31006,7500,8400,"","","",59.987712956648139,929989.51396691613]
["FEB2014","Res / Bus",18,3,54,7500,8400,8500,"","",95.274602931147044,1714.9428527606467]
["FEB2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,141.14755989799562,282.29511979599124]
["FEB2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",105.86066992349672,635.16401954098023]
["FEB2014","Res / Bus",18,4,72,7500,8400,8500,9100,"",105.86066992349672,1905.4920586229409]
["FEB2014","Res / Bus",10,3,30,7500,8400,8800,"","",95.274602931147044,952.74602931147047]
["FEB2014","Res / Bus",5,4,20,7500,8400,8800,9000,"",105.86066992349672,529.3033496174836]
["FEB2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",105.86066992349672,846.88535938797372]
["FEB2014","Res",9006,3,27018,7500,8400,9000,"","",70.57377994899781,635587.46222067426]
["FEB2014","Res",839,4,3356,7500,8400,9000,9100,"",81.159846941347482,68093.111583790538]
["FEB2014","Res",2,5,10,7500,8400,9000,9100,9700,105.86066992349672,211.72133984699343]
["FEB2014","Res",18150,3,54450,7500,8400,9100,"","",70.57377994899781,1280914.1060743101]
["FEB2014","Res",1,3,3,7500,8400,9700,"","",84.688535938797372,84.688535938797372]
["FEB2014","Bus",361,2,722,7500,8500,"","","",59.987712956648139,21655.56437734998]
["FEB2014","Bus",3,3,9,7500,8500,8800,"","",95.274602931147044,285.82380879344112]
["FEB2014","Bus",1,4,4,7500,8500,8800,9100,"",105.86066992349672,105.86066992349672]
["FEB2014","Bus",24,3,72,7500,8500,9000,"","",70.57377994899781,1693.7707187759474]
["FEB2014","Bus",2,4,8,7500,8500,9000,9100,"",81.159846941347482,162.31969388269496]
["FEB2014","Bus",46,3,138,7500,8500,9100,"","",70.57377994899781,3246.3938776538994]
["FEB2014","Bus",41,2,82,7500,8800,"","","",59.987712956648139,2459.4962312225739]
["FEB2014","Bus",5,3,15,7500,8800,9000,"","",70.57377994899781,352.86889974498905]
["FEB2014","Bus",4,3,12,7500,8800,9100,"","",70.57377994899781,282.29511979599124]
["FEB2014","Res",7,2,14,7500,8900,"","","",59.987712956648139,419.91399069653698]
["FEB2014","Res",1,4,4,7500,8900,9000,9100,"",81.159846941347482,81.159846941347482]
["FEB2014","Res",2,3,6,7500,8900,9100,"","",70.57377994899781,141.14755989799562]
["FEB2014","Res / Bus",2,2,4,8300,8400,"","","",35.286889974498905,70.57377994899781]
["FEB2014","Bus",8,2,16,8300,8500,"","","",35.286889974498905,282.29511979599124]
["FEB2014","Bus",1,2,2,8300,9000,"","","",10.586066992349673,10.586066992349673]
["FEB2014","Bus",1,2,2,8300,9800,"","","",24.700822982149234,24.700822982149234]
["FEB2014","Bus",2,2,4,8300,9900,"","","",24.700822982149234,49.401645964298467]
["FEB2014","Res",456638,1,456638,8400,"","","","",35.286889974498905,16113334.86417523]
["FEB2014","Res / Bus",591,2,1182,8400,8500,"","","",70.57377994899781,41709.103949857708]
["FEB2014","Res / Bus",24,3,{"$f":"C261*D261","v":72},8400,8500,8800,"","",105.86066992349672,2540.6560781639209]
["FEB2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",116.44673691584639,1048.0206322426175]
["FEB2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,141.14755989799562,141.14755989799562]
["FEB2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,141.14755989799562,423.44267969398686]
["FEB2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",116.44673691584639,1397.3608429901567]
["FEB2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,141.14755989799562,282.29511979599124]
["FEB2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",130.56149290564593,391.6844787169378]
["FEB2014","Res / Bus",240,3,720,8400,8500,9000,"","",81.159846941347482,19478.363265923395]
["FEB2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",91.745913933697153,825.71322540327435]
["FEB2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,116.44673691584639,582.23368457923198]
["FEB2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",105.86066992349672,4975.4514864043458]
["FEB2014","Res / Bus",718,3,2154,8400,8500,9100,"","",81.159846941347482,58272.770103887495]
["FEB2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",105.86066992349672,105.86066992349672]
["FEB2014","Res / Bus",113,4,452,8400,8500,9100,9900,"",105.86066992349672,11962.255701355129]
["FEB2014","Res / Bus",4,3,12,8400,8500,9800,"","",95.274602931147044,381.09841172458817]
["FEB2014","Res / Bus",112,3,336,8400,8500,9900,"","",95.274602931147044,10670.75552828847]
["FEB2014","Res / Bus",255,2,510,8400,8800,"","","",70.57377994899781,17996.313886994441]
["FEB2014","Res / Bus",88,3,264,8400,8800,9000,"","",81.159846941347482,7142.0665308385787]
["FEB2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",91.745913933697153,550.47548360218298]
["FEB2014","Res / Bus",4,5,20,8400,8800,9000,9100,9900,116.44673691584639,465.78694766338555]
["FEB2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",105.86066992349672,3493.4021074753914]
["FEB2014","Res / Bus",252,3,756,8400,8800,9100,"","",81.159846941347482,20452.281429219565]
["FEB2014","Res / Bus",2,4,8,8400,8800,9100,9800,"",{"$f":"IF(ISERROR(VLOOKUP(F283,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F283,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G283,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G283,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H283,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H283,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I283,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I283,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J283,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J283,$A$9:$C$20,3,FALSE))","v":105.86066992349672},{"$f":"C283*K283","v":211.72133984699343}]
["FEB2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",105.86066992349672,7092.6648848742798]
["FEB2014","Res / Bus",1,3,3,8400,8800,9800,"","",95.274602931147044,95.274602931147044]
["FEB2014","Res / Bus",41,3,123,8400,8800,9900,"","",95.274602931147044,3906.2587201770289]
["FEB2014","Res",144269,2,288538,8400,9000,"","","",45.872956966848577,6618045.6286502769]
["FEB2014","Res",8237,3,24711,8400,9000,9100,"","",56.459023959198248,465052.98035191599]
["FEB2014","Res",7,4,28,8400,9000,9100,9700,"",81.159846941347482,568.11892858943236]
["FEB2014","Res",7,4,28,8400,9000,9100,9800,"",81.159846941347482,568.11892858943236]
["FEB2014","Res",5575,4,22300,8400,9000,9100,9900,"",81.159846941347482,452466.14669801219]
["FEB2014","Res",59,3,177,8400,9000,9700,"","",70.57377994899781,4163.8530169908709]
["FEB2014","Res",1,4,4,8400,9000,9700,9900,"",95.274602931147044,95.274602931147044]
["FEB2014","Res",34,3,102,8400,9000,9800,"","",70.57377994899781,2399.5085182659254]
["FEB2014","Res",45178,3,135534,8400,9000,9900,"","",70.57377994899781,3188382.2305358229]
["FEB2014","Res",395972,2,791944,8400,9100,"","","",45.872956966848577,18164406.516076963]
["FEB2014","Res",171,3,513,8400,9100,9700,"","",70.57377994899781,12068.116371278626]
["FEB2014","Res",77,3,231,8400,9100,9800,"","",70.57377994899781,5434.1810560728318]
["FEB2014","Res",85782,3,257346,8400,9100,9900,"","",70.57377994899781,6053959.9915849306]
["FEB2014","Res",245,2,490,8400,9700,"","","",59.987712956648139,14696.989674378794]
["FEB2014","Res",2,3,6,8400,9700,9900,"","",84.688535938797372,169.37707187759474]
["FEB2014","Res",117,2,234,8400,9800,"","","",59.987712956648139,7018.5624159278323]
["FEB2014","Res",63649,2,127298,8400,9900,"","","",59.987712956648139,3818157.9419776974]
["FEB2014","Bus",90817,1,90817,8500,"","","","",35.286889974498905,3204649.4868140672]
["FEB2014","Bus",557,2,1114,8500,8800,"","","",70.57377994899781,39309.595431591777]
["FEB2014","Bus",6,3,18,8500,8800,9000,"","",81.159846941347482,486.95908164808486]
["FEB2014","Bus",30,3,90,8500,8800,9100,"","",81.159846941347482,2434.7954082404244]
["FEB2014","Bus",1,4,4,8500,8800,9100,9800,"",105.86066992349672,105.86066992349672]
["FEB2014","Bus",1,4,4,8500,8800,9100,9900,"",105.86066992349672,105.86066992349672]
["FEB2014","Bus",2,3,6,8500,8800,9800,"","",95.274602931147044,190.54920586229409]
["FEB2014","Bus",14,3,42,8500,8800,9900,"","",95.274602931147044,1333.8444410360587]
["FEB2014","Bus",481,2,962,8500,9000,"","","",45.872956966848577,22064.892301054166]
["FEB2014","Bus",9,3,27,8500,9000,9100,"","",56.459023959198248,508.13121563278423]
["FEB2014","Bus",3,4,12,8500,9000,9100,9900,"",81.159846941347482,243.47954082404243]
["FEB2014","Bus",5,3,15,8500,9000,9800,"","",70.57377994899781,352.86889974498905]
["FEB2014","Bus",90,3,270,8500,9000,9900,"","",70.57377994899781,6351.6401954098028]
["FEB2014","Bus",2443,2,4886,8500,9100,"","","",45.872956966848577,112067.63387001108]
["FEB2014","Bus",1,3,3,8500,9100,9700,"","",70.57377994899781,70.57377994899781]
["FEB2014","Bus",18,3,54,8500,9100,9800,"","",70.57377994899781,1270.3280390819605]
["FEB2014","Bus",200,3,600,8500,9100,9900,"","",70.57377994899781,14114.755989799562]
["FEB2014","Bus",5,2,10,8500,9700,"","","",59.987712956648139,299.93856478324068]
["FEB2014","Bus",221,2,442,8500,9800,"","","",59.987712956648139,13257.284563419238]
["FEB2014","Bus",1878,2,3756,8500,9900,"","","",59.987712956648139,112656.9249325852]
["FEB2014","Bus",4,1,4,8600,"","","","",0,0]
["FEB2014","Bus",1,1,{"$f":"C325*D325","v":1},8700,"","","","",0,0]
["FEB2014","Bus",1,2,2,8700,8800,"","","",35.286889974498905,35.286889974498905]
["FEB2014","Bus",11908,1,11908,8800,"","","","",35.286889974498905,420196.28581633297]
["FEB2014","Bus",101,2,202,8800,9000,"","","",45.872956966848577,4633.1686536517063]
["FEB2014","Bus",4,3,12,8800,9000,9100,"","",56.459023959198248,225.83609583679299]
["FEB2014","Bus",3,4,12,8800,9000,9100,9900,"",81.159846941347482,243.47954082404243]
["FEB2014","Bus",26,3,78,8800,9000,9900,"","",70.57377994899781,1834.918278673943]
["FEB2014","Bus",490,2,980,8800,9100,"","","",45.872956966848577,22477.748913755804]
["FEB2014","Bus",7,3,21,8800,9100,9800,"","",70.57377994899781,494.01645964298467]
["FEB2014","Bus",65,3,195,8800,9100,9900,"","",70.57377994899781,4587.2956966848578]
["FEB2014","Bus",1,2,2,8800,9700,"","","",59.987712956648139,59.987712956648139]
["FEB2014","Bus",51,2,102,8800,9800,"","","",59.987712956648139,3059.3733607890549]
["FEB2014","Bus",326,2,652,8800,9900,"","","",59.987712956648139,19555.994423867294]
["FEB2014","Res",105,1,105,8900,"","","","",35.286889974498905,3705.1234473223849]
["FEB2014","Res",10,2,20,8900,9000,"","","",45.872956966848577,458.72956966848574]
["FEB2014","Res",12,2,24,8900,9100,"","","",45.872956966848577,550.47548360218298]
["FEB2014","Res",9,3,27,8900,9100,9900,"","",70.57377994899781,635.16401954098023]
["FEB2014","Res",8,2,16,8900,9900,"","","",59.987712956648139,479.90170365318511]
["FEB2014","CL",17,1,17,9000,"","","","",10.586066992349673,179.96313886994446]
["FEB2014","CL",110,1,110,9100,"","","","",10.586066992349673,1164.467369158464]
["MAR2014","Res",16954,2,33908,7500,8400,"","","",59.987712956648139,1017031.6854670126]
["MAR2014","Res / Bus",20,3,60,7500,8400,8500,"","",95.274602931147044,1905.4920586229409]
["MAR2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,{"$f":"IF(ISERROR(VLOOKUP(F347,$A$9:$C$20,3,FALSE)),0,VLOOKUP(F347,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(G347,$A$9:$C$20,3,FALSE)),0,VLOOKUP(G347,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(H347,$A$9:$C$20,3,FALSE)),0,VLOOKUP(H347,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(I347,$A$9:$C$20,3,FALSE)),0,VLOOKUP(I347,$A$9:$C$20,3,FALSE))+IF(ISERROR(VLOOKUP(J347,$A$9:$C$20,3,FALSE)),0,VLOOKUP(J347,$A$9:$C$20,3,FALSE))","v":141.14755989799562},{"$f":"C347*K347","v":282.29511979599124}]
["MAR2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",105.86066992349672,635.16401954098023]
["MAR2014","Res / Bus",19,4,76,7500,8400,8500,9100,"",105.86066992349672,2011.3527285464377]
["MAR2014","Res / Bus",10,3,30,7500,8400,8800,"","",95.274602931147044,952.74602931147047]
["MAR2014","Res / Bus",5,4,20,7500,8400,8800,9000,"",105.86066992349672,529.3033496174836]
["MAR2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",105.86066992349672,846.88535938797372]
["MAR2014","Res",9874,3,29622,7500,8400,9000,"","",70.57377994899781,696845.50321640435]
["MAR2014","Res",913,4,3652,7500,8400,9000,9100,"",81.159846941347482,74098.940257450246]
["MAR2014","Res",2,5,10,7500,8400,9000,9100,9700,105.86066992349672,211.72133984699343]
["MAR2014","Res",19797,3,59391,7500,8400,9100,"","",70.57377994899781,1397149.1216503095]
["MAR2014","Res",1,3,3,7500,8400,9700,"","",84.688535938797372,84.688535938797372]
["MAR2014","Bus",390,2,780,7500,8500,"","","",59.987712956648139,23395.208053092774]
["MAR2014","Bus",3,3,9,7500,8500,8800,"","",95.274602931147044,285.82380879344112]
["MAR2014","Bus",1,4,4,7500,8500,8800,9100,"",105.86066992349672,105.86066992349672]
["MAR2014","Bus",27,3,81,7500,8500,9000,"","",70.57377994899781,1905.4920586229409]
["MAR2014","Bus",2,4,8,7500,8500,9000,9100,"",81.159846941347482,162.31969388269496]
["MAR2014","Bus",50,3,150,7500,8500,9100,"","",70.57377994899781,3528.6889974498904]
["MAR2014","Bus",43,2,86,7500,8800,"","","",59.987712956648139,2579.4716571358699]
["MAR2014","Bus",5,3,15,7500,8800,9000,"","",70.57377994899781,352.86889974498905]
["MAR2014","Bus",5,3,15,7500,8800,9100,"","",70.57377994899781,352.86889974498905]
["MAR2014","Res",7,2,14,7500,8900,"","","",59.987712956648139,419.91399069653698]
["MAR2014","Res",1,4,4,7500,8900,9000,9100,"",81.159846941347482,81.159846941347482]
["MAR2014","Res",2,3,6,7500,8900,9100,"","",70.57377994899781,141.14755989799562]
["MAR2014","Res / Bus",2,2,4,8300,8400,"","","",35.286889974498905,70.57377994899781]
["MAR2014","Bus",8,2,16,8300,8500,"","","",35.286889974498905,282.29511979599124]
["MAR2014","Bus",1,2,2,8300,9000,"","","",10.586066992349673,10.586066992349673]
["MAR2014","Bus",1,2,2,8300,9800,"","","",24.700822982149234,24.700822982149234]
["MAR2014","Bus",2,2,4,8300,9900,"","","",24.700822982149234,49.401645964298467]
["MAR2014","Res",456975,1,456975,8400,"","","","",35.286889974498905,16125226.546096638]

{"sheet":"Relationships","index":13,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,8,18,10],[3,2,4,2],[5,2,6,2],[16,8,16,10],[17,8,17,10],[15,8,15,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,"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*C17","v":81.087019999999995},{"$f":"(D4*SS+D5*SD)*C4+(D6*MP+D7*H7)*C6","v":73.257500000000007},{"$f":"D17+E17","v":154.34451999999999},{"$f":"D17*(1+'Exit Fee Calculation excl PV'!$D$74)+E17*(1+'Exit Fee Calculation excl PV'!$D$73)","v":273.87341778994988},1,"Weighted based on meter population"]
[null,"Controlled Load",null,null,{"$f":"SS","v":50},{"$f":"D18+E18","v":50},{"$f":"D18*(1+'Exit Fee Calculation excl PV'!$D$74)+E18*(1+'Exit Fee Calculation excl PV'!$D$73)","v":79.088032605719548},{"$f":"ROUND(G18/G17,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*C19","v":66.485063522617907},{"$f":"C10*(F12*SS+F13*MP)","v":39.127767083734362},{"$f":"D19+E19","v":105.61283060635228},{"$f":"D19*(1+'Exit Fee Calculation excl PV'!$D$74)+E19*(1+'Exit Fee Calculation excl PV'!$D$73)","v":191.43652193366944},{"$f":"ROUND(G19/G17,1)","v":0.7},"Based on 75% meter replacement vs meter reprogram"]