{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Title Page","Inputs","Exit Fee Calculation excl PV","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":8,"defined_names":160,"comments":3,"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",7.7460000000000001E-2]
[null,"Forecast Inflation",2.52E-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":417478434.43649107},{"$f":"'PTRM output'!D16*1000000","v":420700484.25594598},{"$f":"'PTRM output'!E16*1000000","v":423596815.18136072},{"$f":"'PTRM output'!F16*1000000","v":426852091.20663297},{"$f":"'PTRM output'!G16*1000000","v":429148379.16653275},{"$f":"'PTRM output'!H16*1000000","v":428255520.71027029}]
[null,"Other",{"$f":"('PTRM output'!C15-'PTRM output'!C16)*1000000","v":18456199.552207123},{"$f":"('PTRM output'!D15-'PTRM output'!D16)*1000000","v":19624186.716916882},{"$f":"('PTRM output'!E15-'PTRM output'!E16)*1000000","v":20252389.721644305},{"$f":"('PTRM output'!F15-'PTRM output'!F16)*1000000","v":20350477.529323883},{"$f":"('PTRM output'!G15-'PTRM output'!G16)*1000000","v":20827469.453320704},{"$f":"('PTRM output'!H15-'PTRM output'!H16)*1000000","v":21398286.848357201}]
[null,null,{"$f":"SUM(C5:C6)","v":435934633.98869818},440324670.97286284,443849204.903005,447202568.73595685,449975848.61985344,449653807.55862749]
[]
[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":361679582.59274417}]
[null,"Load Control",{"$f":"C40*C5","v":55798851.843746923}]
[null,"Solar PV"]
[]
[null,null,{"$f":"SUM(C45:C48)","v":417478434.43649107}]
[]
["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":252.36792854922058},{"$f":"C54*(1+CPI)","v":258.72760034866093},265.24753587744715,271.93177378155877,278.78445448085404,285.80982273377151]
[null,"Load Control",{"$f":"C46/C28","v":75.71037856476616},77.618280104598256,79.574260763234122,81.579532134467613,83.635336344256189,85.742946820131436]
[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":"Price Path Calc","index":3,"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 (incl Tax)",{"$f":"'PTRM output'!D39","v":55054868.677511781},{"$f":"'PTRM output'!E39","v":58484188.498340972},{"$f":"'PTRM output'!F39","v":62232441.191821344},{"$f":"'PTRM output'!G39","v":66112547.454841264},{"$f":"'PTRM output'!H39","v":70263489.456771895}]
[null,"O&M (incl Tax)",{"$f":"'PTRM output'!D40","v":17064910.329783008},{"$f":"'PTRM output'!E40","v":17166369.751131736},{"$f":"'PTRM output'!F40","v":17648700.278801244},{"$f":"'PTRM output'!G40","v":18434065.009352125},{"$f":"'PTRM output'!H40","v":18834197.550924573}]
[null,null,{"$f":"SUM(C5:C6)","v":72119779.007294789},{"$f":"SUM(D5:D6)","v":75650558.249472708},79881141.470622584,84546612.464193389,89097687.007696465]
[]
["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":39.16768895116666},{"$f":"D23/D27*D7/D12","v":40.288499877416669},41.744169314723223,43.397060083849972,44.962732198141957]
[null,"Load Control",{"$f":"C24/C27*C7/C13","v":11.750306685349999},12.086549963224998,12.523250794416967,13.01911802515499,13.488819659442585]
[null,"Solar PV",{"$f":"C25/C27*C7/C14","v":27.417382265816666},28.201949914191665,29.220918520306252,30.377942058694973,31.47391253869937]
[]
[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":2.8615702285815461E-2},{"$f":"(E39-D39)/D39","v":3.6131140194736205E-2},3.9595727888727505E-2,3.6077838251412864E-2]
[null,"Load Control",null,{"$f":"(D40-C40)/C40","v":2.8615702285815156E-2},{"$f":"(E40-D40)/D40","v":3.6131140194736414E-2},3.959572788872736E-2,3.6077838251412871E-2]
[null,"Solar PV",null,{"$f":"(D41-C41)/C41","v":2.8615702285815198E-2},{"$f":"(E41-D41)/D41","v":3.6131140194736178E-2},3.9595727888727388E-2,3.6077838251413107E-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":54562235.751911104},56704734.056968004,59361962.020647645,62351507.222552955,65269970.344503976,null,{"$f":"NPV(WACC,C49:G49)","v":238153453.81335467}]
[null,"Load Control",8695367.9508392233,8983993.0204149578,9350009.3221212402,9763479.2570765819,10160736.673687976,null,{"$f":"NPV(WACC,C50:G50)","v":37525365.984139174}]
[null,"Solar PV",8862175.3045444526,9961831.1720897499,11169170.127853699,12431625.984563861,13666979.989504505,null,{"$f":"NPV(WACC,C51:G51)","v":44371099.156180181}]
[null,null,{"$f":"SUM(C49:C51)","v":72119779.007294774},{"$f":"SUM(D49:D51)","v":75650558.249472708},79881141.470622569,84546612.464193389,89097687.00769645,null,{"$f":"SUM(I49:I51)","v":320049918.95367402}]
[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":4.8957155592792345E-2},{"$f":"E52/D52-1","v":5.5922696660065219E-2},{"$f":"F52/E52-1","v":5.8405161815152651E-2},{"$f":"G52/F52-1","v":5.3829176721072125E-2}]
[]
["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.52E-2},{"$f":"CPI","v":2.52E-2},{"$f":"CPI","v":2.52E-2},{"$f":"CPI","v":2.52E-2}]
[null,"X",null,-8.3523362501288223E-3,{"$f":"$D$59","v":-8.3523362501288223E-3},{"$f":"$E$59","v":-8.3523362501288223E-3},{"$f":"$F$59","v":-8.3523362501288223E-3}]
[]
[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":39.16768895116666},{"$f":"C62*(1+D$58)*(1-D$59)","v":40.490100392044823},{"$f":"D62*(1+E$58)*(1-E$59)","v":41.857160165918728},43.270375726200889,44.7313054221747]
[null,"Load Control",{"$f":"C40","v":11.750306685349999},{"$f":"C63*(1+D$58)*(1-D$59)","v":12.147030117613447},{"$f":"D63*(1+E$58)*(1-E$59)","v":12.557148049775618},12.981112717860267,13.419391626652409]
[null,"Solar PV",{"$f":"C41","v":27.417382265816666},{"$f":"C64*(1+D$58)*(1-D$59)","v":28.343070274431376},{"$f":"D64*(1+E$58)*(1-E$59)","v":29.300012116143108},30.289263008340622,31.311913795522287]
[]
[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":10.73087368525114},11.093178189601321,11.467715113950335,11.85489745923312,12.255152170458821]
[null,"Load Control",{"$f":"C63/365*100","v":3.2192621055753419},3.3279534568803961,3.4403145341851009,3.5564692377699361,3.6765456511376464]
[null,"Solar PV",7.5116115796757992,7.7652247327209256,8.027400579765235,8.298428221463185,8.5786065193211751]
[]
[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":3.3762815123631995E-2},3.3762815123631995E-2,3.3762815123631773E-2,3.3762815123631995E-2]
[null,"Load Control",null,{"$f":"D63/C63-1","v":3.3762815123631995E-2},3.3762815123631773E-2,3.3762815123631773E-2,3.3762815123631773E-2]
[null,"Solar PV",null,{"$f":"D64/C64-1","v":3.3762815123631773E-2},3.3762815123631773E-2,3.3762815123631995E-2,3.3762815123631773E-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":54562235.751911104},56988480.12849015,59522639.756663397,62169491.1913822,64934020.590878211,null,{"$f":"NPV(WACC,C77:G77)","v":238159921.2678377}]
[null,"Load Control",8695367.9508392233,9028948.2215726636,9375317.4197390731,9734977.7849558219,10108438.550000086,null,{"$f":"NPV(WACC,C78:G78)","v":37527160.135761}]
[null,"Solar PV",8862175.3045444526,10011679.399177944,11199402.231177613,12395335.67942925,13596634.951257234,null,{"$f":"NPV(WACC,C79:G79)","v":44362837.550075203}]
[null,null,{"$f":"SUM(C77:C79)","v":72119779.007294774},{"$f":"SUM(D77:D79)","v":76029107.749240756},{"$f":"SUM(E77:E79)","v":80097359.407580078},{"$f":"SUM(F77:F79)","v":84299804.655767277},{"$f":"SUM(G77:G79)","v":88639094.092135519},null,{"$f":"SUM(I77:I79)","v":320049918.95367396}]
[null,"De-escalated to 14/15",{"$f":"C80/(1+CPI)","v":70347033.756627768},{"$f":"D80/(1+CPI)^2","v":72337367.314833552},{"$f":"E80/(1+CPI)^3","v":74334839.194595948},{"$f":"F80/(1+CPI)^4","v":76311884.454593912},{"$f":"G80/(1+CPI)^5","v":78267654.871151075}]
[null,null,{"$f":"C80-C52","v":0},{"$f":"D80-D52","v":378549.49976804852},{"$f":"E80-E52","v":216217.93695750833},{"$f":"F80-F52","v":-246807.80842611194},{"$f":"G80-G52","v":-458592.91556093097},null,{"$f":"I80-I52","v":0}]
[]
["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":39.16768895116666},{"$f":"D62","v":40.490100392044823},41.857160165918728,43.270375726200889,44.7313054221747]
[{"$f":"'NTCs per NMI'!B16","v":1.0157455085230349E-3},"Primary x 2",{"$f":"C62*2","v":78.33537790233332},{"$f":"D62*2","v":80.980200784089647},83.714320331837456,86.540751452401778,89.462610844349399]
[{"$f":"'NTCs per NMI'!B8","v":0.39241126213281852},"Primary + Load Control",{"$f":"C62+C63","v":50.917995636516657},{"$f":"D62+D63","v":52.63713050965827},54.414308215694348,56.251488444061152,58.150697048827112]
[{"$f":"'NTCs per NMI'!B9","v":5.9636903676373891E-3},"Primary + Load Control x 2",{"$f":"C62+C63*2","v":62.668302321866662},{"$f":"D62+D63*2","v":64.784160627271717},66.971456265469968,69.232601161921423,71.570088675479525]
[{"$f":"'NTCs per NMI'!B12","v":0.11819485021386601},"Primary + Load Control + Solar PV",{"$f":"C62+C63+C64","v":78.33537790233332},{"$f":"D62+D63+D64","v":80.980200784089647},83.714320331837456,86.540751452401778,89.462610844349399]
[{"$f":"'NTCs per NMI'!B10","v":6.1540518291774711E-2},"Primary + Solar PV",{"$f":"C62+C64","v":66.585071216983323},{"$f":"D62+D64","v":68.833170666476207},71.157172282061836,73.559638734541508,76.043219217696986]
[]
[]
["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 (incl Tax)",{"$f":"C5/C$7*C$80","v":55054868.677511774},{"$f":"D5/D$7*D$80","v":58776838.821255699},62400888.585018307,65919552.224503592,69901837.661201909]
[null,"O&M (incl Tax)",{"$f":"C6/C$7*C$80","v":17064910.329783004},{"$f":"D6/D$7*D$80","v":17252268.927985061},17696470.822561774,18380252.431263682,18737256.430933621]
[null,null,{"$f":"SUM(C98:C99)","v":72119779.007294774},{"$f":"SUM(D98:D99)","v":76029107.749240756},80097359.407580078,84299804.655767277,88639094.092135534]
[null,null,{"$f":"C100-C80","v":0},{"$f":"D100-D80","v":0},0,0,0]
[null,"ROA & Depn (incl 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$98*C30","v":41651773.83265502},{"$f":"D$98*D30","v":44056846.257202707},46371885.905020624,48614407.092588238,51207736.411595754]
[null,"Load Control",{"$f":"C$98*C31","v":6637878.6405831361},6980129.7168338709,7303962.8532742187,7612418.3101042891,7971634.1617376022]
[null,"Solar PV",{"$f":"C$98*C32","v":6765216.2042736141},7739862.8472191244,8725039.8267234638,9692726.8218110688,10722467.087868553]
[]
[null,null,{"$f":"SUM(C103:C106)","v":55054868.677511767},{"$f":"SUM(D103:D106)","v":58776838.821255699},62400888.585018307,65919552.224503592,69901837.661201909]
[null,null,{"$f":"C98-C107","v":0},{"$f":"D98-D107","v":0},0,0,0]
[null,"O&M (incl 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":12910461.91925608},{"$f":"D$99*D30","v":12931633.871287448},13150753.851642773,13555084.09879397,13726284.179282455]
[null,"Load Control",{"$f":"C$99*C31","v":2057489.3102560865},2048818.504738793,2071354.5664648542,2122559.4748515328,2136804.3882624842]
[null,"Solar PV",{"$f":"C$99*C32","v":2096959.1002708366},2271816.5519588208,2474362.4044541465,2702608.8576181796,2874167.8633886809]
[]
[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":39.167688951166653},{"$f":"C127*(1+D$58)*(1-D$59)","v":40.490100392044816},{"$f":"D127*(1+E$58)*(1-E$59)","v":41.857160165918721},{"$f":"E127*(1+F$58)*(1-F$59)","v":43.270375726200882},{"$f":"F127*(1+G$58)*(1-G$59)","v":44.731305422174692}]
[null,"Meter Provision & Installation",{"$f":"$C118*C$103/C$12+$C121*C$110/C$12","v":24.190780784333278},25.314247555783727,26.364341899379564,27.352538083501333,28.508147381487497]
[null,"Meter Maintenance",6.8129224953392269,7.0822881439900431,7.3464715747834237,7.6070873611944121,7.8936964947060213]
[null,"Meter Reading",{"$f":"$C123*C$110/C$12","v":7.0094840108822662},6.9490215422110477,6.9943394293727197,7.1354940540928364,7.1515592842935725]
[null,"Meter Data Service",1.1545016606118816,1.1445431500600003,1.1520072623830111,1.1752562274123086,1.1779022616875943]
[null,"Load Control",{"$f":"SUM(C133:C136)","v":11.750306685349996},{"$f":"C132*(1+D$58)*(1-D$59)","v":12.147030117613443},{"$f":"D132*(1+E$58)*(1-E$59)","v":12.557148049775614},{"$f":"E132*(1+F$58)*(1-F$59)","v":12.981112717860263},{"$f":"F132*(1+G$58)*(1-G$59)","v":13.419391626652406}]
[null,"Meter Provision & Installation",{"$f":"$C118*C$104/C$13+$C121*C$111/C$13","v":7.2572342352999835},7.594274266735118,7.9093025698138693,8.2057614250503992,8.5524442144462505]
[null,"Meter Maintenance",2.0438767486017682,2.1246864431970134,2.203941472435027,2.2821262083583229,2.3681089484118063]
[null,"Meter Reading",{"$f":"$C123*C$111/C$13","v":2.1028452032646801},2.0847064626633141,2.0983018288118158,2.1406482162278513,2.1454677852880719]
[null,"Meter Data Service",0.34635049818356456,0.34336294501800008,0.34560217871490329,0.35257686822369255,0.35337067850627829]
[null,"Solar PV",{"$f":"SUM(C138:C141)","v":27.417382265816656},{"$f":"SUM(D138:D141)","v":28.343070274431376},29.300012116143098,30.289263008340615,31.31191379552228]
[null,"Meter Provision & Installation",{"$f":"$C118*C$105/C$14+$C121*C$112/C$14","v":16.933546549033295},17.71997328904861,18.455039329565693,19.146776658450928,19.95570316704125]
[null,"Meter Maintenance",4.7690457467374587,4.9576017007930311,5.1425301023483954,5.3249611528360861,5.525587546294215]
[null,"Meter Reading",{"$f":"$C123*C$112/C$14","v":4.9066388076175862},4.8643150795477332,4.896037600560903,4.9948458378649843,5.0060914990055005]
[null,"Meter Data Service",0.8081511624283173,0.80118020504200016,0.80640508366810759,0.82267935918861568,0.82453158318131592]

{"sheet":"PTRM output","index":4,"n_rows":46,"n_cols":11,"rows_kept":46,"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",257.37545483009677,242.50771640881393,226.72720026226315,209.99734400169794,192.28032214434575,173.53700567204817]
[null,"Metering - electronic",160.10297960639431,178.19276784713207,196.86961491909756,216.85474720493505,236.86805702218706,254.71851503822211]
[null,"Office Equipment & Furniture",-0.38628425769333047,-0.23380461024586491,-6.7859309002699708E-2,5.5208723777595711E-2,5.6656342611775941E-2,5.6624669549659196E-2]
[null,"Motor Vehicles",3.3415745975445708,3.7100908110434312,3.9402259581581376,3.9078456942055926,4.071523751990977,4.1048603463772455]
[null,"Plant & Equipment",1.009066586814102,1.0838717146467403,1.1155059327681962,1.1066019232574738,1.0565882853652313,0.96024223403924946]
[null,"Buildings",8.3452288197978461,9.013419200687407,9.6952116025285306,9.9578479418985726,10.304618220699144,10.650458412027525]
[null,"Land",5.1286364809251355,5.2533474106859668,4.8621949732431613,4.7394485846259826,4.8588826889585572,5.1557039130790896]
[null,"IT Systems",1.0179773248187047,0.79726219009913846,0.70711056394901817,0.58352466155869165,0.47920016369496976,0.47039727328446973]
[null,"Total",{"$f":"SUM(C7:C14)","v":435.93463398869818},{"$f":"SUM(D7:D14)","v":440.32467097286286},443.84920490300505,447.20256873595685,449.97584861985348,449.65380755862748]
[null,"Meters only",{"$f":"SUM(C7:C8)","v":417.47843443649106},{"$f":"SUM(D7:D8)","v":420.70048425594598},423.59681518136074,426.85209120663296,429.14837916653278,428.25552071027028]
[]
[]
[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,33767496.74876456,34107549.013557956,34380559.41178678,34640310.974287234,34855129.234093852,null,{"$f":"NPV(WACC,D21:H21)","v":137910884.54970565},{"$f":"J21/$J$25","v":0.4309042945568366}]
[null,"Return of capital",null,20010041.998371847,22726639.819320202,25762033.67512162,28915393.141933173,32349083.986366075,null,{"$f":"NPV(WACC,D22:H22)","v":102475378.27270952},{"$f":"J22/$J$25","v":0.32018560919411576}]
[null,"O&M",null,16668986.749416582,16654932.760877024,17035284.820473474,17708961.496152658,17981184.02788249,null,{"$f":"NPV(WACC,D23:H23)","v":68958385.986226767},0.21546134494165647]
[null,"Benchmark Tax liability",null,1673253.5107418031,2161436.6557175256,2703263.5632407027,3281946.8518203194,3912289.7593540624,null,{"$f":"NPV(WACC,D24:H24)","v":10705270.145032104},3.3448751307391049E-2]
[null,"Total unsmoothed revenue - before adjustments",71375217.951696068,{"$f":"SUM(D21:D24)","v":72119779.007294789},{"$f":"SUM(E21:E24)","v":75650558.249472708},{"$f":"SUM(F21:F24)","v":79881141.470622584},{"$f":"SUM(G21:G24)","v":84546612.464193389},{"$f":"SUM(H21:H24)","v":89097687.00769648},null,{"$f":"NPV(WACC,D25:H25)","v":320049918.95367408}]
[null,"NPV",{"$f":"NPV(WACC,D25:H25)","v":320049918.95367408},{"$f":"AVERAGE(E26:H26)","v":5.427854769727064E-2},{"$f":"E25/D25-1","v":4.8957155592792123E-2},{"$f":"F25/E25-1","v":5.5922696660065441E-2},{"$f":"G25/F25-1","v":5.8405161815152651E-2},{"$f":"H25/G25-1","v":5.3829176721072347E-2}]
[]
[null,"Total smoothed revenue after adjustments",{"$f":"C25","v":71375217.951696068},{"$f":"C28*(1-D31)*(1+CPI)","v":75990799.067658678},{"$f":"D28*(1-E31)*(1+CPI)","v":77905767.204163671},{"$f":"E28*(1-F31)*(1+CPI)","v":79868992.53770858},{"$f":"F28*(1-G31)*(1+CPI)","v":81881691.149658829},{"$f":"G28*(1-H31)*(1+CPI)","v":83945109.766630217},{"$f":"H28/H25-1","v":-5.7830650986721688E-2}]
[null,"NPV",{"$f":"NPV(WACC,D28:H28)","v":320049918.95367366}]
[null,null,{"$f":"C26-C29","v":0}]
[null,"Adjusted revenue X factors",null,-3.8496330602652E-2,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":58009931.823917031},{"$f":"E21+E22+D$34/D$36*(E$28-E$21-E$22-E$23)","v":60205772.154723242},{"$f":"F21+F22+$D$34/$D$36*(F$28-F$21-F$22-F$23)","v":62196938.85180296},{"$f":"G21+G22+$D$34/$D$36*(G$28-G$21-G$22-G$23)","v":64026729.684982933},{"$f":"H21+H22+$D$34/$D$36*(H$28-H$21-H$22-H$23)","v":66257401.328244887}]
[null,"O&M (incl Tax & Smoothing)",null,{"$f":"(D23)/(D$21+D$22+D$23)*D$28","v":17980867.24374165},{"$f":"E23+D$35/D$36*(E$28-E$21-E$22-E$23)","v":17699995.049440432},{"$f":"F23+$D$35/$D$36*(F$28-F$21-F$22-F$23)","v":17672053.68590562},{"$f":"G23+$D$35/$D$36*(G$28-G$21-G$22-G$23)","v":17854961.464675892},{"$f":"H23+$D$35/$D$36*(H$28-H$21-H$22-H$23)","v":17687708.438385326}]
[null,null,null,{"$f":"SUM(D34:D35)","v":75990799.067658678},{"$f":"SUM(E34:E35)","v":77905767.204163671},79868992.53770858,81881691.149658829,83945109.766630217]
[]
[null,"Not Smoothed"]
[null,"ROA & Depn (incl Tax & Smoothing)",null,{"$f":"(D21+D22)/(D$21+D$22+D$23)*D$25","v":55054868.677511781},{"$f":"E21+E22+D$39/D$41*(E$25-E$21-E$22-E$23)","v":58484188.498340972},{"$f":"F21+F22+E$39/E$41*(F$25-F$21-F$22-F$23)","v":62232441.191821344},{"$f":"G21+G22+F$39/F$41*(G$25-G$21-G$22-G$23)","v":66112547.454841264},{"$f":"H21+H22+G$39/G$41*(H$25-H$21-H$22-H$23)","v":70263489.456771895}]
[null,"O&M (incl Tax & Smoothing)",null,{"$f":"(D23)/(D$21+D$22+D$23)*D$25","v":17064910.329783008},{"$f":"E23+D$40/D$41*(E$25-E$21-E$22-E$23)","v":17166369.751131736},{"$f":"F23+E$40/E$41*(F$25-F$21-F$22-F$23)","v":17648700.278801244},{"$f":"G23+F$40/F$41*(G$25-G$21-G$22-G$23)","v":18434065.009352125},{"$f":"H23+G$40/G$41*(H$25-H$21-H$22-H$23)","v":18834197.550924573}]
[null,null,null,{"$f":"SUM(D39:D40)","v":72119779.007294789},{"$f":"SUM(E39:E40)","v":75650558.249472708},{"$f":"SUM(F39:F40)","v":79881141.470622584},84546612.464193389,89097687.007696465]
[]
[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]

{"sheet":"Demand Forecast","index":5,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Forecast of NTCs for 2015 -2020"]
[]
["Actual Average NTC's"]
["Financial Year","Primary","Growth","% Growth","% of Total","CL","Growth","% Growth","% of Total","FiT","Growth","% Growth","% of Total","Total","Growth","%"]
["2012 Avg",{"$f":"AVERAGE('PIVOT NMI''s'!H7:H18)","v":1336804.25},null,null,{"$f":"IF($N5=0,0,B5/$N5)","v":0.61334648349478227},{"$f":"AVERAGE('PIVOT NMI''s'!K7:K18)","v":726987.41666666663},null,null,{"$f":"IF($N5=0,0,F5/$N5)","v":0.33355308045845605},{"$f":"AVERAGE('PIVOT NMI''s'!B7:B18)","v":115733.75},null,null,{"$f":"IF($N5=0,0,J5/$N5)","v":5.3100436046761713E-2},{"$f":"J5+F5+B5","v":2179525.4166666665}]
["2013 Avg",{"$f":"AVERAGE('PIVOT NMI''s'!H20:H31)","v":1350042.1666666667},{"$f":"B6-B5","v":13237.916666666744},{"$f":"C6/B5","v":9.9026590218176998E-3},{"$f":"IF($N6=0,0,B6/$N6)","v":0.59310893379404983},{"$f":"AVERAGE('PIVOT NMI''s'!K20:K31)","v":730678.83333333337},{"$f":"F6-F5","v":3691.4166666667443},{"$f":"G6/F5","v":5.077689904995024E-3},{"$f":"IF($N6=0,0,F6/$N6)","v":0.32100637630766365},{"$f":"AVERAGE('PIVOT NMI''s'!B20:B31)","v":195491.83333333334},{"$f":"J6-J5","v":79758.083333333343},{"$f":"K6/J5","v":0.68915146474847089},{"$f":"IF($N6=0,0,J6/$N6)","v":8.5884689898286459E-2},{"$f":"J6+F6+B6","v":2276212.8333333335},{"$f":"N6-N5","v":96687.416666666977},{"$f":"N6/N5-1","v":4.436168347811198E-2}]
["2014 Avg",{"$f":"AVERAGE('PIVOT NMI''s'!H33:H44)","v":1364633.3333333333},{"$f":"B7-B6","v":14591.166666666511},{"$f":"C7/B6","v":1.0807934023789018E-2},{"$f":"IF($N7=0,0,B7/$N7)","v":0.58234633839017846},{"$f":"AVERAGE('PIVOT NMI''s'!K33:K44)","v":733470.83333333337},{"$f":"F7-F6","v":2792},{"$f":"G7/F6","v":3.8211042562475575E-3},{"$f":"IF($N7=0,0,F7/$N7)","v":0.31300279985416812},{"$f":"AVERAGE('PIVOT NMI''s'!B33:B44)","v":245232.16666666666},{"$f":"J7-J6","v":49740.333333333314},{"$f":"K7/J6","v":0.25443688611033188},{"$f":"IF($N7=0,0,J7/$N7)","v":0.10465086175565352},{"$f":"J7+F7+B7","v":2343336.333333333},{"$f":"N7-N6","v":67123.499999999534},{"$f":"N7/N6-1","v":2.9489114118429027E-2}]
[]
[]
["Average growth",null,null,{"$f":"AVERAGE(D5:D8)","v":1.035529652280336E-2},{"$f":"AVERAGE(E5:E8)","v":0.59626725189300345},null,null,{"$f":"AVERAGE(H5:H8)","v":4.4493970806212908E-3},{"$f":"AVERAGE(I5:I8)","v":0.32252075220676263},null,null,{"$f":"AVERAGE(L5:L8)","v":0.47179417542940139},{"$f":"AVERAGE(M5:M8)","v":8.1211995900233896E-2},null,null,{"$f":"AVERAGE(P5:P8)","v":3.6925398798270503E-2}]
["Applicable growth"]
[]
["Forecast NTCs"]
["FY Average","Primary","Growth","% Growth",null,"CL","Growth","% Growth",null,"FiT","Growth","% Growth",null,"Total",null,"check"]
[2015,{"$f":"B7*(1+D10)","v":1378764.5161449015},{"$f":"B15-B7","v":14131.182811568258},{"$f":"D10","v":1.035529652280336E-2},{"$f":"B15/N15","v":0.56742433745481413},{"$f":"F7*(1+H10)","v":736734.33631788753},{"$f":"F15-F7","v":3263.5029845541576},{"$f":"G15/F15","v":4.4296876413616963E-3},{"$f":"F15/N15","v":0.30319970362615239},{"$f":"J7+K15","v":288232.16666666663},43000,{"$f":"K15/J7","v":0.1753440447249647},{"$f":"J15/N15","v":0.11862065224980779},{"$f":"N7*(1+$P$10)","v":2429864.9619601434},{"$f":"N15-N7","v":86528.628626810387},{"$f":"N15/N7-1","v":3.6925398798270503E-2}]
[{"$f":"A15+1","v":2016},{"$f":"B15*(1+$D$10)","v":1393042.0315447014},{"$f":"B16-B15","v":14277.515399799915},null,0.55288469680444885,{"$f":"F15*(1+$H$10)","v":740012.3599230937},{"$f":"F16-F15","v":3278.0236052061664},null,0.2937036356282372,{"$f":"J15+K16","v":323232.16666666663},35000,{"$f":"K16/J15","v":0.12142988898416961},0.12828767145437736,{"$f":"N15*(1+$P$10)","v":2519588.694706466},{"$f":"N16-N15","v":89723.732746322639},{"$f":"N16/N15-1","v":3.6925398798270503E-2}]
[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":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of NMI No","Column Labels"]
[null,"Photovoltaic","SAC - Non Demand",null,null,null,null,"SAC - Non Demand Total","CL",null,"CL Total","Grand Total"]
["Row Labels",null,7600,8400,8500,8800,8900,null,9000,9100]
["1112"]
["JUL",83543,null,1216105,98961,15162,null,1330228,214689,511181,725870,2139641]
["AUG",91647,null,1217679,99002,15111,null,1331792,214449,511537,725986,2149425]
["SEP",98076,null,1218940,99110,15041,null,1333091,214234,511922,726156,2157323]
["OCT",106435,null,1219720,99166,15043,null,1333929,214132,512119,726251,2166615]
["NOV",110735,null,1221304,99162,15023,null,1335489,214052,512451,726503,2172727]
["DEC",113788,null,1222025,99119,15008,null,1336152,213957,512703,726660,2176600]
["JAN",117616,null,1222681,99136,14990,null,1336807,213911,512959,726870,2181293]
["FEB",121452,null,1223975,99252,14926,null,1338153,213784,513257,727041,2186646]
["MAR",126377,null,1225179,99303,14923,null,1339405,213725,513739,727464,2193246]
["APR",131241,null,1226357,99302,14918,null,1340577,213671,514062,727733,2199551]
["MAY",139584,null,1228204,99322,14912,null,1342438,213679,514792,728471,2210493]
["JUN",148311,null,1229433,99320,14837,null,1343590,213524,515320,728844,2220745]
["1213"]
["JUL",157849,null,1230924,98438,14268,1,1343631,213302,515838,729140,2230620]
["AUG",167385,null,1232077,98364,14231,2,1344674,213229,516314,729543,2241602]
["SEP",175458,null,1232973,98327,14188,3,1345491,213202,516612,729814,2250763]
["OCT",184155,null,1234598,98717,14486,5,1347806,213270,516871,730141,2262102]
["NOV",192007,null,1235911,98755,14512,9,1349187,213363,517103,730466,2271660]
["DEC",197320,null,1237019,98800,14530,11,1350360,213452,517439,730891,2278571]
["JAN",202555,null,1237334,98795,14529,17,1350675,213491,517516,731007,2284237]
["FEB",206666,null,1238302,98816,14551,20,1351689,213481,517574,731055,2289410]
["MAR",209574,null,1239110,98832,14542,21,1352505,213522,517689,731211,2293290]
["APR",212687,null,1240086,98821,14550,25,1353482,213539,517844,731383,2297552]
["MAY",218035,null,1241451,98830,14551,95,1354927,213573,518060,731633,2304595]
["JUN",222211,null,1242547,98884,14552,96,1356079,213508,518354,731862,2310152]
["1314"]
["JUL",228856,null,1243991,98903,14524,100,1357518,213473,518744,732217,2318591]
["AUG",233821,null,1245430,98922,14426,105,1358883,213521,518984,732505,2325209]
["SEP",236565,null,1246737,98978,14417,116,1360248,213612,519177,732789,2329602]
["OCT",239135,1,1248082,99050,14420,130,1361683,213743,519323,733066,2333884]
["NOV",241389,1,1249149,99080,14411,138,1362779,213933,519347,733280,2337448]
["DEC",243867,1,1250422,99124,14405,141,1364093,214139,519427,733566,2341526]
["JAN",245970,1,1250784,99106,14439,144,1364474,214266,519414,733680,2344124]
["FEB",248326,null,1252178,99111,14474,154,1365917,214453,519485,733938,2348181]
["MAR",251568,null,1253626,99145,14505,160,1367436,214576,519429,734005,2353009]
["APR",254310,null,1255163,99169,14511,162,1369005,214662,519442,734104,2357419]
["MAY",257976,null,1257135,99137,14516,169,1370957,214712,519514,734226,2363159]
["JUN",261003,null,1258812,99137,14483,175,1372607,214761,519513,734274,2367884]
["Grand Total",6677493,4,44525443,3563396,526915,1999,48617757,7698590,18595055,26293645,81588895]

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

{"sheet":"NTCs per NMI","index":8,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"SUM(E2:J2)","v":1379583},"Primary",{"$f":"SUMIF(E$31:E$60,\"SAC\",$C$31:$C$60)","v":1376204},{"$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":9,"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":10,"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":27.417382265816666},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":39.16768895116666},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":39.16768895116666},null,1252233,1253743,1255282]
[8500,"8500 - Business Flat",{"$f":"'Price Path Calc'!$C$62","v":39.16768895116666},null,99165,99195,99209]
[8800,"8800 - Business - TOU",{"$f":"'Price Path Calc'!$C$62","v":39.16768895116666},null,14476,14508,14510]
[8900,"8900 - Residential TOU",{"$f":"'Price Path Calc'!$C$62","v":39.16768895116666},null,154,160,163]
[9000,"9000 - Controlled Load 1 (super economy)",{"$f":"'Price Path Calc'!$C$63","v":11.750306685349999},null,214458,214578,214673]
[9100,"9100 - Controlled Load 2 (economy)",{"$f":"'Price Path Calc'!$C$63","v":11.750306685349999},null,519500,519431,519469,null,null,1]
[9700,"9700 - Solar PV (gross)",{"$f":"'Price Path Calc'!$C$64","v":27.417382265816666},null,496,495,491]
[9800,"9800 - Solar PV (net)",{"$f":"'Price Path Calc'!$C$64","v":27.417382265816666},null,549,587,623]
[9900,"9900 - Solar PV (net with FIT)",{"$f":"'Price Path Calc'!$C$64","v":27.417382265816666},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":78.33537790233332},{"$f":"C26*K26","v":46296.208340278994}]
["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":117.50306685349997},{"$f":"C27*K27","v":2820.0736044839996}]
["MAR2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",129.25337353884998,1163.2803618496498]
["MAR2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,156.67075580466664,156.67075580466664]
["MAR2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,156.67075580466664,470.01226741399989]
["MAR2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",129.25337353884998,1551.0404824661998]
["MAR2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,156.67075580466664,313.34151160933328]
["MAR2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",144.92044911931663,434.76134735794989]
["MAR2014","Res / Bus",242,3,726,8400,8500,9000,"","",90.085684587683318,21800.735670219365]
["MAR2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",101.83599127303331,916.52392145729982]
["MAR2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,129.25337353884998,646.26686769424987]
["MAR2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",117.50306685349999,5522.6441421144991]
["MAR2014","Res / Bus",711,3,2133,8400,8500,9100,"","",90.085684587683318,64050.921741842838]
["MAR2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",117.50306685349999,117.50306685349999]
["MAR2014","Res / Bus",113,4,452,8400,8500,9100,9900,"",117.50306685349999,13277.846554445499]
["MAR2014","Res / Bus",4,3,12,8400,8500,9800,"","",105.75276016814999,423.01104067259996]
["MAR2014","Res / Bus",111,3,333,8400,8500,9900,"","",105.75276016814999,11738.556378664649]
["MAR2014","Res / Bus",253,2,506,8400,8800,"","","",78.33537790233332,19818.85060929033]
["MAR2014","Res / Bus",87,3,261,8400,8800,9000,"","",90.085684587683318,7837.4545591284486]
["MAR2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",101.83599127303331,611.01594763819992]
["MAR2014","Res / Bus",4,5,20,8400,8800,9000,9100,9900,129.25337353884998,517.01349415539994]
["MAR2014","Res / Bus",1,4,4,8400,8800,9000,9800,"",117.50306685349999,117.50306685349999]
["MAR2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",117.50306685349999,3877.6012061654997]
["MAR2014","Res / Bus",250,3,750,8400,8800,9100,"","",90.085684587683318,22521.421146920831]
["MAR2014","Res / Bus",3,4,12,8400,8800,9100,9800,"",117.50306685349999,352.50920056049995]
["MAR2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",117.50306685349999,7872.7054791844994]
["MAR2014","Res / Bus",2,3,6,8400,8800,9800,"","",105.75276016814999,211.50552033629998]
["MAR2014","Res / Bus",41,3,123,8400,8800,9900,"","",105.75276016814999,4335.8631668941498]
["MAR2014","Res",143645,2,287290,8400,9000,"","","",50.917995636516657,7314115.4832074353]
["MAR2014","Res",8208,3,24624,8400,9000,9100,"","",62.668302321866655,514381.42545788153]
["MAR2014","Res",7,4,28,8400,9000,9100,9700,"",90.085684587683318,630.59979211378322]
["MAR2014","Res",7,4,28,8400,9000,9100,9800,"",90.085684587683318,630.59979211378322]
["MAR2014","Res",5579,4,22316,8400,9000,9100,9900,"",90.085684587683318,502588.03431468521]
["MAR2014","Res",60,3,180,8400,9000,9700,"","",78.33537790233332,4700.1226741399996]
["MAR2014","Res",1,4,4,8400,9000,9700,9900,"",105.75276016814999,105.75276016814999]
["MAR2014","Res",38,3,114,8400,9000,9800,"","",78.33537790233332,2976.744360288666]
["MAR2014","Res",44996,3,134988,8400,9000,9900,"","",78.33537790233332,3524778.6640933901]
["MAR2014","Res",394489,2,788978,8400,9100,"","","",50.917995636516657,20086589.180653818]
["MAR2014","Res",170,3,510,8400,9100,9700,"","",78.33537790233332,13317.014243396665]
["MAR2014","Res",81,3,243,8400,9100,9800,"","",78.33537790233332,6345.1656100889986]
["MAR2014","Res",85505,3,256515,8400,9100,9900,"","",78.33537790233332,6698066.4875390101]
["MAR2014","Res",244,2,488,8400,9700,"","","",66.585071216983323,16246.757376943931]
["MAR2014","Res",2,3,6,8400,9700,9900,"","",94.002453482799993,188.00490696559999]
["MAR2014","Res",126,2,252,8400,9800,"","","",66.585071216983323,8389.7189733398991]
["MAR2014","Res",63362,2,126724,8400,9900,"","","",66.585071216983323,4218963.2824504972]
["MAR2014","Bus",90812,1,90812,8500,"","","","",39.16768895116666,3556896.1690333467]
["MAR2014","Bus",554,2,1108,8500,8800,"","","",78.33537790233332,43397.799357892662]
["MAR2014","Bus",6,3,18,8500,8800,9000,"","",90.085684587683318,540.51410752609991]
["MAR2014","Bus",30,3,90,8500,8800,9100,"","",90.085684587683318,2702.5705376304995]
["MAR2014","Bus",1,4,4,8500,8800,9100,9800,"",117.50306685349999,117.50306685349999]
["MAR2014","Bus",1,4,4,8500,8800,9100,9900,"",117.50306685349999,117.50306685349999]
["MAR2014","Bus",2,3,6,8500,8800,9800,"","",105.75276016814999,211.50552033629998]
["MAR2014","Bus",14,3,42,8500,8800,9900,"","",105.75276016814999,1480.5386423540999]
["MAR2014","Bus",482,2,964,8500,9000,"","","",50.917995636516657,24542.473896801028]
["MAR2014","Bus",9,3,27,8500,9000,9100,"","",62.668302321866655,564.01472089679987]
["MAR2014","Bus",3,4,12,8500,9000,9100,9900,"",90.085684587683318,270.25705376304995]
["MAR2014","Bus",5,3,15,8500,9000,9800,"","",78.33537790233332,391.67688951166662]
["MAR2014","Bus",91,3,273,8500,9000,9900,"","",78.33537790233332,7128.5193891123317]
["MAR2014","Bus",2436,2,4872,8500,9100,"","","",50.917995636516657,124036.23737055458]
["MAR2014","Bus",1,3,3,8500,9100,9700,"","",78.33537790233332,78.33537790233332]
["MAR2014","Bus",18,3,54,8500,9100,9800,"","",78.33537790233332,1410.0368022419998]
["MAR2014","Bus",201,3,603,8500,9100,9900,"","",78.33537790233332,15745.410958368997]
["MAR2014","Bus",5,2,10,8500,9700,"","","",66.585071216983323,332.92535608491664]
["MAR2014","Bus",230,2,460,8500,9800,"","","",66.585071216983323,15314.566379906164]
["MAR2014","Bus",1878,2,3756,8500,9900,"","","",66.585071216983323,125046.76374549468]
["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,"","","",39.16768895116666,39.16768895116666]
["MAR2014","Bus",11936,1,11936,8800,"","","","",39.16768895116666,467505.53532112524]
["MAR2014","Bus",100,2,200,8800,9000,"","","",50.917995636516657,5091.7995636516662]
["MAR2014","Bus",4,3,12,8800,9000,9100,"","",62.668302321866655,250.67320928746662]
["MAR2014","Bus",3,4,12,8800,9000,9100,9900,"",90.085684587683318,270.25705376304995]
["MAR2014","Bus",26,3,78,8800,9000,9900,"","",78.33537790233332,2036.7198254606662]
["MAR2014","Bus",488,2,976,8800,9100,"","","",50.917995636516657,24847.981870620129]
["MAR2014","Bus",10,3,30,8800,9100,9800,"","",78.33537790233332,783.35377902333323]
["MAR2014","Bus",63,3,189,8800,9100,9900,"","",78.33537790233332,4935.1288078469988]
["MAR2014","Bus",1,2,2,8800,9700,"","","",66.585071216983323,66.585071216983323]
["MAR2014","Bus",57,2,114,8800,9800,"","","",66.585071216983323,3795.3490593680494]
["MAR2014","Bus",328,2,656,8800,9900,"","","",66.585071216983323,21839.90335917053]
["MAR2014","Res",109,1,109,8900,"","","","",39.16768895116666,4269.2780956771658]
["MAR2014","Res",10,2,20,8900,9000,"","","",50.917995636516657,509.17995636516656]
["MAR2014","Res",13,2,26,8900,9100,"","","",50.917995636516657,661.93394327471651]
["MAR2014","Res",9,3,27,8900,9100,9900,"","",78.33537790233332,705.0184011209999]
["MAR2014","Res",9,2,18,8900,9900,"","","",66.585071216983323,599.26564095284994]
["MAR2014","CL",15,1,15,9000,"","","","",11.750306685349999,176.25460028024997]
["MAR2014","CL",110,1,110,9100,"","","","",11.750306685349999,1292.5337353885]
["APR2014","Res",18223,2,36446,7500,8400,"","","",66.585071216983323,1213379.7527870871]
["APR2014","Res / Bus",21,3,63,7500,8400,8500,"","",105.75276016814999,2220.8079635311497]
["APR2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,156.67075580466667,313.34151160933334]
["APR2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",117.50306685349999,705.0184011209999]
["APR2014","Res / Bus",23,4,92,7500,8400,8500,9100,"",117.50306685349999,2702.5705376304995]
["APR2014","Res / Bus",12,3,36,7500,8400,8800,"","",105.75276016814999,1269.0331220178]
["APR2014","Res / Bus",6,4,24,7500,8400,8800,9000,"",117.50306685349999,705.0184011209999]
["APR2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",117.50306685349999,940.0245348279999]
["APR2014","Res",10617,3,31851,7500,8400,9000,"","",78.33537790233332,831686.70718907285]
["APR2014","Res",972,4,3888,7500,8400,9000,9100,"",90.085684587683318,87563.285419228181]
["APR2014","Res",2,5,10,7500,8400,9000,9100,9700,117.50306685349999,235.00613370699998]
["APR2014","Res",21112,3,63336,7500,8400,9100,"","",78.33537790233332,1653816.4982740611]
["APR2014","Res",1,3,3,7500,8400,9700,"","",94.002453482799993,94.002453482799993]
["APR2014","Bus",421,2,842,7500,8500,"","","",66.585071216983323,28032.314982349981]
["APR2014","Bus",3,3,9,7500,8500,8800,"","",105.75276016814999,317.25828050445]
["APR2014","Bus",1,4,4,7500,8500,8800,9100,"",117.50306685349999,117.50306685349999]
["APR2014","Bus",28,3,84,7500,8500,9000,"","",78.33537790233332,2193.3905812653329]
["APR2014","Bus",2,4,8,7500,8500,9000,9100,"",90.085684587683318,180.17136917536664]
["APR2014","Bus",60,3,180,7500,8500,9100,"","",78.33537790233332,4700.1226741399996]
["APR2014","Bus",44,2,88,7500,8800,"","","",66.585071216983323,2929.7431335472661]
["APR2014","Bus",5,3,15,7500,8800,9000,"","",78.33537790233332,391.67688951166662]
["APR2014","Bus",5,3,15,7500,8800,9100,"","",78.33537790233332,391.67688951166662]
["APR2014","Res",8,2,16,7500,8900,"","","",66.585071216983323,532.68056973586658]
["APR2014","Res",1,4,4,7500,8900,9000,9100,"",90.085684587683318,90.085684587683318]
["APR2014","Res",2,3,6,7500,8900,9100,"","",78.33537790233332,156.67075580466664]
["APR2014","Res / Bus",2,2,4,8300,8400,"","","",39.16768895116666,78.33537790233332]
["APR2014","Bus",8,2,16,8300,8500,"","","",39.16768895116666,313.34151160933328]
["APR2014","Bus",1,2,2,8300,9000,"","","",11.750306685349999,11.750306685349999]
["APR2014","Bus",1,2,2,8300,9800,"","","",27.417382265816666,27.417382265816666]
["APR2014","Bus",2,2,4,8300,9900,"","","",27.417382265816666,54.834764531633333]
["APR2014","Res",457408,1,457408,8400,"","","","",39.16768895116666,17915614.267775241]
["APR2014","Res / Bus",586,2,1172,8400,8500,"","","",78.33537790233332,45904.531450767325]
["APR2014","Res / Bus",24,3,{"$f":"C144*D144","v":72},8400,8500,8800,"","",117.50306685349997,2820.0736044839996]
["APR2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",129.25337353884998,1163.2803618496498]
["APR2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,156.67075580466664,156.67075580466664]
["APR2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,156.67075580466664,470.01226741399989]
["APR2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",129.25337353884998,1551.0404824661998]
["APR2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,156.67075580466664,313.34151160933328]
["APR2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",144.92044911931663,434.76134735794989]
["APR2014","Res / Bus",241,3,723,8400,8500,9000,"","",90.085684587683318,21710.64998563168]
["APR2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",101.83599127303331,916.52392145729982]
["APR2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,129.25337353884998,646.26686769424987]
["APR2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",117.50306685349999,5522.6441421144991]
["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":90.085684587683318},{"$f":"C155*K155","v":63420.321949729056}]
["APR2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",117.50306685349999,117.50306685349999]
["APR2014","Res / Bus",111,4,444,8400,8500,9100,9900,"",117.50306685349999,13042.840420738499]
["APR2014","Res / Bus",4,3,12,8400,8500,9800,"","",105.75276016814999,423.01104067259996]
["APR2014","Res / Bus",111,3,333,8400,8500,9900,"","",105.75276016814999,11738.556378664649]
["APR2014","Res / Bus",249,2,498,8400,8800,"","","",78.33537790233332,19505.509097680995]
["APR2014","Res / Bus",85,3,255,8400,8800,9000,"","",90.085684587683318,7657.283189953082]
["APR2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",101.83599127303331,611.01594763819992]
["APR2014","Res / Bus",3,5,15,8400,8800,9000,9100,9900,129.25337353884998,387.76012061654995]
["APR2014","Res / Bus",1,4,4,8400,8800,9000,9800,"",117.50306685349999,117.50306685349999]
["APR2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",117.50306685349999,3877.6012061654997]
["APR2014","Res / Bus",250,3,750,8400,8800,9100,"","",90.085684587683318,22521.421146920831]
["APR2014","Res / Bus",3,4,12,8400,8800,9100,9800,"",117.50306685349999,352.50920056049995]
["APR2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",117.50306685349999,7872.7054791844994]
["APR2014","Res / Bus",3,3,9,8400,8800,9800,"","",105.75276016814999,317.25828050445]
["APR2014","Res / Bus",41,3,123,8400,8800,9900,"","",105.75276016814999,4335.8631668941498]
["APR2014","Res",143114,2,286228,8400,9000,"","","",50.917995636516657,7287078.0275244452]
["APR2014","Res",8195,3,24585,8400,9000,9100,"","",62.668302321866655,513566.73752769723]
["APR2014","Res",7,4,28,8400,9000,9100,9700,"",90.085684587683318,630.59979211378322]
["APR2014","Res",8,4,32,8400,9000,9100,9800,"",90.085684587683318,720.68547670146654]
["APR2014","Res",5570,4,22280,8400,9000,9100,9900,"",90.085684587683318,501777.26315339608]
["APR2014","Res",58,3,174,8400,9000,9700,"","",78.33537790233332,4543.4519183353323]
["APR2014","Res",1,4,4,8400,9000,9700,9900,"",105.75276016814999,105.75276016814999]
["APR2014","Res",37,3,111,8400,9000,9800,"","",78.33537790233332,2898.4089823863328]
["APR2014","Res",44847,3,134541,8400,9000,9900,"","",78.33537790233332,3513106.6927859425]
["APR2014","Res",393452,2,786904,8400,9100,"","","",50.917995636516657,20033787.219178751]
["APR2014","Res",169,3,507,8400,9100,9700,"","",78.33537790233332,13238.67886549433]
["APR2014","Res",91,3,273,8400,9100,9800,"","",78.33537790233332,7128.5193891123317]
["APR2014","Res",85222,3,255666,8400,9100,9900,"","",78.33537790233332,6675897.5755926501]
["APR2014","Res",243,2,486,8400,9700,"","","",66.585071216983323,16180.172305726948]
["APR2014","Res",2,3,6,8400,9700,9900,"","",94.002453482799993,188.00490696559999]
["APR2014","Res",133,2,266,8400,9800,"","","",66.585071216983323,8855.8144718587828]
["APR2014","Res",63104,2,126208,8400,9900,"","","",66.585071216983323,4201784.3340765154]
["APR2014","Bus",90796,1,90796,8500,"","","","",39.16768895116666,3556269.4860101282]
["APR2014","Bus",552,2,1104,8500,8800,"","","",78.33537790233332,43241.128602087992]
["APR2014","Bus",6,3,18,8500,8800,9000,"","",90.085684587683318,540.51410752609991]
["APR2014","Bus",30,3,90,8500,8800,9100,"","",90.085684587683318,2702.5705376304995]
["APR2014","Bus",1,4,4,8500,8800,9100,9800,"",117.50306685349999,117.50306685349999]
["APR2014","Bus",1,4,4,8500,8800,9100,9900,"",117.50306685349999,117.50306685349999]
["APR2014","Bus",2,3,6,8500,8800,9800,"","",105.75276016814999,211.50552033629998]
["APR2014","Bus",14,3,42,8500,8800,9900,"","",105.75276016814999,1480.5386423540999]
["APR2014","Bus",481,2,962,8500,9000,"","","",50.917995636516657,24491.555901164513]
["APR2014","Bus",9,3,27,8500,9000,9100,"","",62.668302321866655,564.01472089679987]
["APR2014","Bus",4,4,16,8500,9000,9100,9900,"",90.085684587683318,360.34273835073327]
["APR2014","Bus",5,3,15,8500,9000,9800,"","",78.33537790233332,391.67688951166662]
["APR2014","Bus",90,3,270,8500,9000,9900,"","",78.33537790233332,7050.184011209999]
["APR2014","Bus",2428,2,4856,8500,9100,"","","",50.917995636516657,123628.89340546244]
["APR2014","Bus",1,3,3,8500,9100,9700,"","",78.33537790233332,78.33537790233332]
["APR2014","Bus",18,3,54,8500,9100,9800,"","",78.33537790233332,1410.0368022419998]
["APR2014","Bus",200,3,600,8500,9100,9900,"","",78.33537790233332,15667.075580466664]
["APR2014","Bus",5,2,10,8500,9700,"","","",66.585071216983323,332.92535608491664]
["APR2014","Bus",242,2,484,8500,9800,"","","",66.585071216983323,16113.587234509963]
["APR2014","Bus",1876,2,3752,8500,9900,"","","",66.585071216983323,124913.59360306071]
["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,"","","",39.16768895116666,39.16768895116666]
["APR2014","Bus",11940,1,11940,8800,"","","","",39.16768895116666,467662.20607692993]
["APR2014","Bus",100,2,200,8800,9000,"","","",50.917995636516657,5091.7995636516662]
["APR2014","Bus",4,3,12,8800,9000,9100,"","",62.668302321866655,250.67320928746662]
["APR2014","Bus",3,4,12,8800,9000,9100,9900,"",90.085684587683318,270.25705376304995]
["APR2014","Bus",26,3,78,8800,9000,9900,"","",78.33537790233332,2036.7198254606662]
["APR2014","Bus",487,2,974,8800,9100,"","","",50.917995636516657,24797.063874983611]
["APR2014","Bus",10,3,30,8800,9100,9800,"","",78.33537790233332,783.35377902333323]
["APR2014","Bus",63,3,189,8800,9100,9900,"","",78.33537790233332,4935.1288078469988]
["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":66.585071216983323},{"$f":"C219*K219","v":66.585071216983323}]
["APR2014","Bus",63,2,126,8800,9800,"","","",66.585071216983323,4194.8594866699495]
["APR2014","Bus",325,2,650,8800,9900,"","","",66.585071216983323,21640.148145519579]
["APR2014","Res",110,1,110,8900,"","","","",39.16768895116666,4308.4457846283331]
["APR2014","Res",10,2,20,8900,9000,"","","",50.917995636516657,509.17995636516656]
["APR2014","Res",14,2,28,8900,9100,"","","",50.917995636516657,712.85193891123322]
["APR2014","Res",9,3,27,8900,9100,9900,"","",78.33537790233332,705.0184011209999]
["APR2014","Res",9,2,18,8900,9900,"","","",66.585071216983323,599.26564095284994]
["APR2014","CL",15,1,15,9000,"","","","",11.750306685349999,176.25460028024997]
["APR2014","CL",110,1,110,9100,"","","","",11.750306685349999,1292.5337353885]
["FEB2014","Res",15503,2,31006,7500,8400,"","","",66.585071216983323,1032268.3590768925]
["FEB2014","Res / Bus",18,3,54,7500,8400,8500,"","",105.75276016814999,1903.5496830266998]
["FEB2014","Res / Bus",2,5,10,7500,8400,8500,8800,9100,156.67075580466667,313.34151160933334]
["FEB2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",117.50306685349999,705.0184011209999]
["FEB2014","Res / Bus",18,4,72,7500,8400,8500,9100,"",117.50306685349999,2115.0552033629997]
["FEB2014","Res / Bus",10,3,30,7500,8400,8800,"","",105.75276016814999,1057.5276016814998]
["FEB2014","Res / Bus",5,4,20,7500,8400,8800,9000,"",117.50306685349999,587.51533426749995]
["FEB2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",117.50306685349999,940.0245348279999]
["FEB2014","Res",9006,3,27018,7500,8400,9000,"","",78.33537790233332,705488.41338841384]
["FEB2014","Res",839,4,3356,7500,8400,9000,9100,"",90.085684587683318,75581.88936906631]
["FEB2014","Res",2,5,10,7500,8400,9000,9100,9700,117.50306685349999,235.00613370699998]
["FEB2014","Res",18150,3,54450,7500,8400,9100,"","",78.33537790233332,1421787.1089273498]
["FEB2014","Res",1,3,3,7500,8400,9700,"","",94.002453482799993,94.002453482799993]
["FEB2014","Bus",361,2,722,7500,8500,"","","",66.585071216983323,24037.210709330979]
["FEB2014","Bus",3,3,9,7500,8500,8800,"","",105.75276016814999,317.25828050445]
["FEB2014","Bus",1,4,4,7500,8500,8800,9100,"",117.50306685349999,117.50306685349999]
["FEB2014","Bus",24,3,72,7500,8500,9000,"","",78.33537790233332,1880.0490696559996]
["FEB2014","Bus",2,4,8,7500,8500,9000,9100,"",90.085684587683318,180.17136917536664]
["FEB2014","Bus",46,3,138,7500,8500,9100,"","",78.33537790233332,3603.4273835073327]
["FEB2014","Bus",41,2,82,7500,8800,"","","",66.585071216983323,2729.9879198963163]
["FEB2014","Bus",5,3,15,7500,8800,9000,"","",78.33537790233332,391.67688951166662]
["FEB2014","Bus",4,3,12,7500,8800,9100,"","",78.33537790233332,313.34151160933328]
["FEB2014","Res",7,2,14,7500,8900,"","","",66.585071216983323,466.09549851888323]
["FEB2014","Res",1,4,4,7500,8900,9000,9100,"",90.085684587683318,90.085684587683318]
["FEB2014","Res",2,3,6,7500,8900,9100,"","",78.33537790233332,156.67075580466664]
["FEB2014","Res / Bus",2,2,4,8300,8400,"","","",39.16768895116666,78.33537790233332]
["FEB2014","Bus",8,2,16,8300,8500,"","","",39.16768895116666,313.34151160933328]
["FEB2014","Bus",1,2,2,8300,9000,"","","",11.750306685349999,11.750306685349999]
["FEB2014","Bus",1,2,2,8300,9800,"","","",27.417382265816666,27.417382265816666]
["FEB2014","Bus",2,2,4,8300,9900,"","","",27.417382265816666,54.834764531633333]
["FEB2014","Res",456638,1,456638,8400,"","","","",39.16768895116666,17885455.147282843]
["FEB2014","Res / Bus",591,2,1182,8400,8500,"","","",78.33537790233332,46296.208340278994]
["FEB2014","Res / Bus",24,3,{"$f":"C261*D261","v":72},8400,8500,8800,"","",117.50306685349997,2820.0736044839996]
["FEB2014","Res / Bus",9,4,36,8400,8500,8800,9000,"",129.25337353884998,1163.2803618496498]
["FEB2014","Res / Bus",1,5,5,8400,8500,8800,9000,9800,156.67075580466664,156.67075580466664]
["FEB2014","Res / Bus",3,5,15,8400,8500,8800,9000,9900,156.67075580466664,470.01226741399989]
["FEB2014","Res / Bus",12,4,48,8400,8500,8800,9100,"",129.25337353884998,1551.0404824661998]
["FEB2014","Res / Bus",2,5,10,8400,8500,8800,9100,9900,156.67075580466664,313.34151160933328]
["FEB2014","Res / Bus",3,4,12,8400,8500,8800,9900,"",144.92044911931663,434.76134735794989]
["FEB2014","Res / Bus",240,3,720,8400,8500,9000,"","",90.085684587683318,21620.564301043996]
["FEB2014","Res / Bus",9,4,36,8400,8500,9000,9100,"",101.83599127303331,916.52392145729982]
["FEB2014","Res / Bus",5,5,25,8400,8500,9000,9100,9900,129.25337353884998,646.26686769424987]
["FEB2014","Res / Bus",47,4,188,8400,8500,9000,9900,"",117.50306685349999,5522.6441421144991]
["FEB2014","Res / Bus",718,3,2154,8400,8500,9100,"","",90.085684587683318,64681.52153395662]
["FEB2014","Res / Bus",1,4,4,8400,8500,9100,9700,"",117.50306685349999,117.50306685349999]
["FEB2014","Res / Bus",113,4,452,8400,8500,9100,9900,"",117.50306685349999,13277.846554445499]
["FEB2014","Res / Bus",4,3,12,8400,8500,9800,"","",105.75276016814999,423.01104067259996]
["FEB2014","Res / Bus",112,3,336,8400,8500,9900,"","",105.75276016814999,11844.309138832799]
["FEB2014","Res / Bus",255,2,510,8400,8800,"","","",78.33537790233332,19975.521365094995]
["FEB2014","Res / Bus",88,3,264,8400,8800,9000,"","",90.085684587683318,7927.540243716132]
["FEB2014","Res / Bus",6,4,24,8400,8800,9000,9100,"",101.83599127303331,611.01594763819992]
["FEB2014","Res / Bus",4,5,20,8400,8800,9000,9100,9900,129.25337353884998,517.01349415539994]
["FEB2014","Res / Bus",33,4,132,8400,8800,9000,9900,"",117.50306685349999,3877.6012061654997]
["FEB2014","Res / Bus",252,3,756,8400,8800,9100,"","",90.085684587683318,22701.592516096196]
["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":117.50306685349999},{"$f":"C283*K283","v":235.00613370699998}]
["FEB2014","Res / Bus",67,4,268,8400,8800,9100,9900,"",117.50306685349999,7872.7054791844994]
["FEB2014","Res / Bus",1,3,3,8400,8800,9800,"","",105.75276016814999,105.75276016814999]
["FEB2014","Res / Bus",41,3,123,8400,8800,9900,"","",105.75276016814999,4335.8631668941498]
["FEB2014","Res",144269,2,288538,8400,9000,"","","",50.917995636516657,7345888.312484622]
["FEB2014","Res",8237,3,24711,8400,9000,9100,"","",62.668302321866655,516198.80622521561]
["FEB2014","Res",7,4,28,8400,9000,9100,9700,"",90.085684587683318,630.59979211378322]
["FEB2014","Res",7,4,28,8400,9000,9100,9800,"",90.085684587683318,630.59979211378322]
["FEB2014","Res",5575,4,22300,8400,9000,9100,9900,"",90.085684587683318,502227.69157633447]
["FEB2014","Res",59,3,177,8400,9000,9700,"","",78.33537790233332,4621.7872962376659]
["FEB2014","Res",1,4,4,8400,9000,9700,9900,"",105.75276016814999,105.75276016814999]
["FEB2014","Res",34,3,102,8400,9000,9800,"","",78.33537790233332,2663.4028486793327]
["FEB2014","Res",45178,3,135534,8400,9000,9900,"","",78.33537790233332,3539035.7028716146]
["FEB2014","Res",395972,2,791944,8400,9100,"","","",50.917995636516657,20162100.568182774]
["FEB2014","Res",171,3,513,8400,9100,9700,"","",78.33537790233332,13395.349621298998]
["FEB2014","Res",77,3,231,8400,9100,9800,"","",78.33537790233332,6031.8240984796657]
["FEB2014","Res",85782,3,257346,8400,9100,9900,"","",78.33537790233332,6719765.3872179566]
["FEB2014","Res",245,2,490,8400,9700,"","","",66.585071216983323,16313.342448160915]
["FEB2014","Res",2,3,6,8400,9700,9900,"","",94.002453482799993,188.00490696559999]
["FEB2014","Res",117,2,234,8400,9800,"","","",66.585071216983323,7790.4533323870492]
["FEB2014","Res",63649,2,127298,8400,9900,"","","",66.585071216983323,4238073.1978897713]
["FEB2014","Bus",90817,1,90817,8500,"","","","",39.16768895116666,3557092.0074781026]
["FEB2014","Bus",557,2,1114,8500,8800,"","","",78.33537790233332,43632.805491599662]
["FEB2014","Bus",6,3,18,8500,8800,9000,"","",90.085684587683318,540.51410752609991]
["FEB2014","Bus",30,3,90,8500,8800,9100,"","",90.085684587683318,2702.5705376304995]
["FEB2014","Bus",1,4,4,8500,8800,9100,9800,"",117.50306685349999,117.50306685349999]
["FEB2014","Bus",1,4,4,8500,8800,9100,9900,"",117.50306685349999,117.50306685349999]
["FEB2014","Bus",2,3,6,8500,8800,9800,"","",105.75276016814999,211.50552033629998]
["FEB2014","Bus",14,3,42,8500,8800,9900,"","",105.75276016814999,1480.5386423540999]
["FEB2014","Bus",481,2,962,8500,9000,"","","",50.917995636516657,24491.555901164513]
["FEB2014","Bus",9,3,27,8500,9000,9100,"","",62.668302321866655,564.01472089679987]
["FEB2014","Bus",3,4,12,8500,9000,9100,9900,"",90.085684587683318,270.25705376304995]
["FEB2014","Bus",5,3,15,8500,9000,9800,"","",78.33537790233332,391.67688951166662]
["FEB2014","Bus",90,3,270,8500,9000,9900,"","",78.33537790233332,7050.184011209999]
["FEB2014","Bus",2443,2,4886,8500,9100,"","","",50.917995636516657,124392.6633400102]
["FEB2014","Bus",1,3,3,8500,9100,9700,"","",78.33537790233332,78.33537790233332]
["FEB2014","Bus",18,3,54,8500,9100,9800,"","",78.33537790233332,1410.0368022419998]
["FEB2014","Bus",200,3,600,8500,9100,9900,"","",78.33537790233332,15667.075580466664]
["FEB2014","Bus",5,2,10,8500,9700,"","","",66.585071216983323,332.92535608491664]
["FEB2014","Bus",221,2,442,8500,9800,"","","",66.585071216983323,14715.300738953314]
["FEB2014","Bus",1878,2,3756,8500,9900,"","","",66.585071216983323,125046.76374549468]
["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,"","","",39.16768895116666,39.16768895116666]
["FEB2014","Bus",11908,1,11908,8800,"","","","",39.16768895116666,466408.84003049257]
["FEB2014","Bus",101,2,202,8800,9000,"","","",50.917995636516657,5142.7175592881822]
["FEB2014","Bus",4,3,12,8800,9000,9100,"","",62.668302321866655,250.67320928746662]
["FEB2014","Bus",3,4,12,8800,9000,9100,9900,"",90.085684587683318,270.25705376304995]
["FEB2014","Bus",26,3,78,8800,9000,9900,"","",78.33537790233332,2036.7198254606662]
["FEB2014","Bus",490,2,980,8800,9100,"","","",50.917995636516657,24949.817861893163]
["FEB2014","Bus",7,3,21,8800,9100,9800,"","",78.33537790233332,548.34764531633323]
["FEB2014","Bus",65,3,195,8800,9100,9900,"","",78.33537790233332,5091.7995636516662]
["FEB2014","Bus",1,2,2,8800,9700,"","","",66.585071216983323,66.585071216983323]
["FEB2014","Bus",51,2,102,8800,9800,"","","",66.585071216983323,3395.8386320661493]
["FEB2014","Bus",326,2,652,8800,9900,"","","",66.585071216983323,21706.733216736564]
["FEB2014","Res",105,1,105,8900,"","","","",39.16768895116666,4112.6073398724993]
["FEB2014","Res",10,2,20,8900,9000,"","","",50.917995636516657,509.17995636516656]
["FEB2014","Res",12,2,24,8900,9100,"","","",50.917995636516657,611.01594763819992]
["FEB2014","Res",9,3,27,8900,9100,9900,"","",78.33537790233332,705.0184011209999]
["FEB2014","Res",8,2,16,8900,9900,"","","",66.585071216983323,532.68056973586658]
["FEB2014","CL",17,1,17,9000,"","","","",11.750306685349999,199.75521365095]
["FEB2014","CL",110,1,110,9100,"","","","",11.750306685349999,1292.5337353885]
["MAR2014","Res",16954,2,33908,7500,8400,"","","",66.585071216983323,1128883.2974127352]
["MAR2014","Res / Bus",20,3,60,7500,8400,8500,"","",105.75276016814999,2115.0552033629997]
["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":156.67075580466667},{"$f":"C347*K347","v":313.34151160933334}]
["MAR2014","Res / Bus",6,4,24,7500,8400,8500,9000,"",117.50306685349999,705.0184011209999]
["MAR2014","Res / Bus",19,4,76,7500,8400,8500,9100,"",117.50306685349999,2232.5582702164997]
["MAR2014","Res / Bus",10,3,30,7500,8400,8800,"","",105.75276016814999,1057.5276016814998]
["MAR2014","Res / Bus",5,4,20,7500,8400,8800,9000,"",117.50306685349999,587.51533426749995]
["MAR2014","Res / Bus",8,4,32,7500,8400,8800,9100,"",117.50306685349999,940.0245348279999]
["MAR2014","Res",9874,3,29622,7500,8400,9000,"","",78.33537790233332,773483.52140763926]
["MAR2014","Res",913,4,3652,7500,8400,9000,9100,"",90.085684587683318,82248.23002855487]
["MAR2014","Res",2,5,10,7500,8400,9000,9100,9700,117.50306685349999,235.00613370699998]
["MAR2014","Res",19797,3,59391,7500,8400,9100,"","",78.33537790233332,1550805.4763324927]
["MAR2014","Res",1,3,3,7500,8400,9700,"","",94.002453482799993,94.002453482799993]
["MAR2014","Bus",390,2,780,7500,8500,"","","",66.585071216983323,25968.177774623495]
["MAR2014","Bus",3,3,9,7500,8500,8800,"","",105.75276016814999,317.25828050445]
["MAR2014","Bus",1,4,4,7500,8500,8800,9100,"",117.50306685349999,117.50306685349999]
["MAR2014","Bus",27,3,81,7500,8500,9000,"","",78.33537790233332,2115.0552033629997]
["MAR2014","Bus",2,4,8,7500,8500,9000,9100,"",90.085684587683318,180.17136917536664]
["MAR2014","Bus",50,3,150,7500,8500,9100,"","",78.33537790233332,3916.768895116666]
["MAR2014","Bus",43,2,86,7500,8800,"","","",66.585071216983323,2863.158062330283]
["MAR2014","Bus",5,3,15,7500,8800,9000,"","",78.33537790233332,391.67688951166662]
["MAR2014","Bus",5,3,15,7500,8800,9100,"","",78.33537790233332,391.67688951166662]
["MAR2014","Res",7,2,14,7500,8900,"","","",66.585071216983323,466.09549851888323]
["MAR2014","Res",1,4,4,7500,8900,9000,9100,"",90.085684587683318,90.085684587683318]
["MAR2014","Res",2,3,6,7500,8900,9100,"","",78.33537790233332,156.67075580466664]
["MAR2014","Res / Bus",2,2,4,8300,8400,"","","",39.16768895116666,78.33537790233332]
["MAR2014","Bus",8,2,16,8300,8500,"","","",39.16768895116666,313.34151160933328]
["MAR2014","Bus",1,2,2,8300,9000,"","","",11.750306685349999,11.750306685349999]
["MAR2014","Bus",1,2,2,8300,9800,"","","",27.417382265816666,27.417382265816666]
["MAR2014","Bus",2,2,4,8300,9900,"","","",27.417382265816666,54.834764531633333]
["MAR2014","Res",456975,1,456975,8400,"","","","",39.16768895116666,17898654.658459384]

{"sheet":"Relationships","index":11,"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"]