{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Menu","WEPS inc","WEPS Munic inc","Nightsave Large inc","Nightsave Large Munic inc","Nightsave Small inc","Nightsave Small Munic inc","Megaflex inc","Megaflex Munic inc ","Megaflex Gen inc","Miniflex inc","Miniflex Munic inc ","Businessrate inc","Businessrate Munic inc","Public Lighting inc","Public Lighting Munic inc","Homepower inc","Homepower Munic inc","Homelight inc","Nightsave Rural inc","Nightsave Rural Munic inc ","Ruraflex inc","Ruraflex Munic inc","Ruraflex Gen inc","Landrate inc","Landrate Munic inc","TOuS Original","TUoS","DUoS","Loss Factors","Reconciliaton"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":6,"defined_names":527,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,5,1,10],[7,32,7,35],[8,32,8,35],[12,35,12,36],[3,32,3,38],[6,32,6,35],[5,7,5,9],[3,5,3,10]]}
[]
[null,null,null,null,null,"This file contains the excel tables of the rates contained in the published Schedule of Standard Prices for Eskom tariffs."]
[]
[null,null,null,null,null,"\n2018/19 SCHEDULE OF STANDARD PRICES FOR ESKOM TARIFFS \n\n1 April 2018 to 31 March 2019 for Non-Local Authority supplies, and\n1 July 2018 to 30 June 2019 for Local Authority supplies. "]
[]
[null,null,null,null,null,null,null,"Click on the arrow to select the tariff"]
[null,null,null,null,null,null,null,"Non-local authority",null,"Local Authority"]
[null,null,null,null,null,"ê","WEPS","u",null,"u"]
[null,null,null,null,null,"ê","Megaflex","u",null,"u"]
[null,null,null,null,null,"ê","Nightsave large Urban","u",null,"u"]
[null,null,null,null,null,"ê","Miniflex","u",null,"u"]
[null,null,null,null,null,"ê","Nightsave small ","u",null,"u"]
[null,null,null,null,null,"ê","Businessrate","u",null,"u"]
[null,null,null,null,null,"ê","Public lighting","u",null,"u"]
[null,null,null,null,null,"ê","Ruraflex","u",null,"u"]
[null,null,null,null,null,"ê","Nightsave rural","u",null,"u"]
[null,null,null,null,null,"ê","Landrate tariffs","u",null,"u"]
[null,null,null,null,null,"ê","Homepower tariffs","u",null,"u"]
[null,null,null,null,null,"ê","Homelight tariffs","u",null,"n/a"]
[null,null,null,null,null,"ê","Transmission use of system charges","u",null,"u"]
[null,null,null,null,null,"ê","Distribution use of system charges","u",null,"u"]
[null,null,null,null,null,"ê","Megaflex Gen","u",null,"n/a"]
[null,null,null,null,null,"ê","Ruraflex Gen","u",null,"n/a"]
[null,null,null,null,null,"ê","Muniflex Urban","n/a",null,"u"]
[null,null,null,null,null,"ê","Muniflex Rural","n/a",null,"u"]

{"sheet":"WEPS inc","index":1,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,21,5,22],[11,7,14,7],[1,6,1,16],[1,17,1,22],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[7,7,10,7],[29,7,29,8],[29,16,29,17],[15,7,18,7],[19,7,22,7],[24,7,24,14],[25,7,26,8],[25,9,26,10],[25,11,26,12],[25,13,26,14],[26,18,26,19],[27,7,27,8],[27,16,27,17],[28,7,28,8],[28,16,28,17],[26,16,26,17],[30,7,30,8],[30,16,30,17],[31,7,31,8],[31,16,31,17],[33,7,33,8],[33,9,34,10],[33,11,34,12],[33,16,33,19],[50,7,50,18],[35,7,35,8],[35,16,35,17],[35,18,35,19],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[43,9,44,10],[45,9,45,10],[43,7,45,8],[51,7,51,12],[51,13,51,18],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[52,17,52,18],[56,7,56,18],[57,7,57,12],[57,13,57,18],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[58,15,58,16],[58,17,58,18]]}
[null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,"WEPS",null,null,null,null,null,null,null,null,null,null,"Non-local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"We01N"},null,null,"≤ 300km","< 500V",292.89,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":336.82},89.11,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":102.48},48.66,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":55.96},95.91,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":110.3},66.180000000000007,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":76.11},42.19,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":48.52},8.3800000000000008,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":9.64}]
["WEPS","We",0,2,"We02N",null,null,null,"≥ 500V & < 66kV",288.29000000000002,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":331.53},87.34,100.44,47.43,54.54,94.03,108.13,64.73,74.44,41.06,47.22,7.66,8.81]
["WEPS","We",0,3,"We03N",null,null,null,"≥ 66kV & ≤ 132kV",279.16000000000003,321.02999999999997,84.56,97.24,45.93,52.82,91.08,104.74,62.67,72.069999999999993,39.770000000000003,45.74,7.46,8.58]
["WEPS","We",0,4,"We04N",null,null,null,"> 132kV*",263.11,302.58,79.7,91.66,43.29,49.78,85.85,98.73,59.07,67.930000000000007,37.479999999999997,43.1,9.42,10.83]
["WEPS","We",1,1,"We11N",null,null,"> 300km and \n≤ 600km","< 500V",295.27999999999997,339.57,89.47,102.89,48.57,55.86,96.33,110.78,66.319999999999993,76.27,42.07,48.38,8.44,9.7100000000000009]
["WEPS","We",1,2,"We12N",null,null,null,"≥ 500V & < 66kV",291.17,334.85,88.2,101.43,47.9,55.09,94.99,109.24,65.37,75.180000000000007,41.47,47.69,7.73,8.89]
["WEPS","We",1,3,"We13N",null,null,null,"≥ 66kV & ≤ 132kV",281.91000000000003,324.2,85.39,98.2,46.36,53.31,91.96,105.75,63.29,72.78,40.15,46.17,7.51,8.64]
["WEPS","We",1,4,"We14N",null,null,null,"> 132kV*",265.74,305.60000000000002,80.510000000000005,92.59,43.69,50.24,86.67,99.67,59.65,68.599999999999994,37.83,43.5,9.51,10.94]
["WEPS","We",2,1,"We21N",null,null,"> 600km and \n≤ 900km","< 500V",298.22000000000003,342.95,90.34,103.89,49.04,56.4,97.29,111.88,66.959999999999994,77,42.46,48.83,8.5399999999999991,9.82]
["WEPS","We",2,2,"We22N",null,null,null,"≥ 500V & < 66kV",294.10000000000002,338.22,89.1,102.47,48.38,55.64,95.93,110.32,66.03,75.930000000000007,41.89,48.17,7.8,8.9700000000000006]
["WEPS","We",2,3,"We23N",null,null,null,"≥ 66kV & ≤ 132kV",284.77999999999997,327.5,86.27,99.21,46.84,53.87,92.89,106.82,63.94,73.53,40.56,46.64,7.56,8.69]
["WEPS","We",2,4,"We24N",null,null,null,"> 132kV*",268.42,308.68,81.3,93.5,44.17,50.8,87.56,100.69,60.25,69.290000000000006,38.24,43.98,9.65,11.1]
["WEPS","We",3,1,"We31N",null,null,"> 900km","< 500V",301.22000000000003,346.4,91.28,104.97,49.55,56.98,98.27,113.01,67.62,77.760000000000005,42.92,49.36,8.59,9.8800000000000008]
["WEPS","We",3,2,"We32N",null,null,null,"≥ 500V & < 66kV",297.02,341.57,89.97,103.47,48.84,56.17,96.87,111.4,66.66,76.66,42.3,48.65,7.89,9.07]
["WEPS","We",3,3,"We33N",null,null,null,"≥ 66kV & ≤ 132kV",287.64,330.79,87.13,100.2,47.31,54.41,93.82,107.89,64.58,74.27,40.97,47.12,7.63,8.77]
["WEPS","We",3,4,"We34N",null,null,null,"> 132kV*",271.02999999999997,311.68,82.14,94.46,44.63,51.32,88.47,101.74,60.91,70.05,38.659999999999997,44.46,9.7200000000000006,11.18]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,"Voltage",null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,"Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,"< 500V",null,16.649999999999999,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":19.149999999999999},31.57,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":36.31},0,{"$f":"ROUND(N29 * (1 + VAT), 2)","v":0},null,"< 500V",null,0.39,{"$f":"ROUND(S29 * (1 + VAT), 2)","v":0.45}]
["WEPS","We",0,2,"We02N",null,null,"≥ 500V & < 66kV",null,15.27,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":17.559999999999999},28.96,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":33.299999999999997},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",null,0.38,{"$f":"ROUND(S30 * (1 + VAT), 2)","v":0.44}]
["WEPS","We",0,3,"We03N",null,null,"≥ 66kV & ≤ 132kV",null,5.45,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":6.27},10.1,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":11.62},13.45,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":15.47},null,"≥ 66kV & ≤ 132kV",null,0.36,{"$f":"ROUND(S31 * (1 + VAT), 2)","v":0.41}]
["WEPS","We",0,4,"We04N",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":0},13.45,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":15.47},null,"> 132kV / Transmission connected",null,0.34,{"$f":"ROUND(S32 * (1 + VAT), 2)","v":0.39}]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,null,null,"Reactive energy charge  [c/kVArh]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,null,null,"High season",null,"Low season"]
["WEPS","We",0,1,"We01N",null,null,"≤ 100 kVA",null,13.6,{"$f":"ROUND(J37 * (1 + VAT), 2)","v":15.64},2.99,{"$f":"ROUND(L37 * (1 + VAT), 2)","v":3.44},null,null,null,null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,"> 100 kVA & ≤ 500 kVA",null,62.12,{"$f":"ROUND(J38 * (1 + VAT), 2)","v":71.44},17.420000000000002,{"$f":"ROUND(L38 * (1 + VAT), 2)","v":20.03},null,null,null,13.47,{"$f":"ROUND(Q38 * (1 + VAT), 2)","v":15.49},0,{"$f":"ROUND(S38 * (1 + VAT), 2)","v":0}]
["WEPS","We",0,1,"We01N",null,null,"> 500 kVA & ≤ 1 MVA",null,191.16,{"$f":"ROUND(J39 * (1 + VAT), 2)","v":219.83},34.6,{"$f":"ROUND(L39 * (1 + VAT), 2)","v":39.79}]
["WEPS","We",0,1,"We01N",null,null,"> 1 MVA",null,191.16,{"$f":"ROUND(J40 * (1 + VAT), 2)","v":219.83},86.15,{"$f":"ROUND(L40 * (1 + VAT), 2)","v":99.07}]
["WEPS","We",0,1,"We01N",null,null,"Key customers",null,3745.97,{"$f":"ROUND(J41 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(L41 * (1 + VAT), 2)","v":137.59}]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,7.45,{"$f":"ROUND(H48 * (1 + VAT), 2)","v":8.57},3.31,{"$f":"ROUND(J48 * (1 + VAT), 2)","v":3.81}]
[]
[]
[null,null,null,null,null,null,null,"Active energy charge excluding losses   [c/kWh]"]
[null,null,null,null,null,null,null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,"Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,{"$f":"ROUND(J11/'Loss Factors'!$T$6, 2)","v":260.32},{"$f":"ROUND(H55 * (1 + VAT), 2)","v":299.37},{"$f":"ROUND(L11/'Loss Factors'!$T$6, 2)","v":78.86},{"$f":"ROUND(J55 * (1 + VAT), 2)","v":90.69},{"$f":"ROUND(N11/'Loss Factors'!$T$6, 2)","v":42.83},{"$f":"ROUND(L55 * (1 + VAT), 2)","v":49.25},{"$f":"ROUND(P11/'Loss Factors'!$T$6, 2)","v":84.94},{"$f":"ROUND(N55 * (1 + VAT), 2)","v":97.68},{"$f":"ROUND(R11/'Loss Factors'!$T$6, 2)","v":58.44},{"$f":"ROUND(P55 * (1 + VAT), 2)","v":67.209999999999994},{"$f":"ROUND(T11/'Loss Factors'!$T$6, 2)","v":37.08},{"$f":"ROUND(R55 * (1 + VAT), 2)","v":42.64}]
[]
[null,null,null,null,null,null,null,"Active energy charge excluding losses and enviromental levy   [c/kWh]"]
[null,null,null,null,null,null,null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,"Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,256.83,295.35000000000002,75.37,86.68,39.339999999999996,45.24,81.45,93.67,54.949999999999996,63.19,33.589999999999996,38.630000000000003]

{"sheet":"WEPS Munic inc","index":2,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,20,5,21],[11,6,14,6],[1,5,1,15],[1,16,1,21],[3,8,3,19],[4,6,6,6],[4,8,4,13],[4,14,4,19],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[7,6,10,6],[29,6,29,7],[15,6,18,6],[19,6,22,6],[24,6,24,13],[25,6,26,7],[25,8,26,9],[25,10,26,11],[25,12,26,13],[26,17,26,18],[27,6,27,7],[28,6,28,7],[28,15,28,16],[26,15,27,16],[43,6,45,7],[38,6,38,7],[30,6,30,7],[30,15,30,16],[31,6,31,7],[31,15,31,16],[33,6,33,7],[33,8,34,9],[33,10,34,11],[33,15,33,18],[35,6,35,7],[35,15,35,16],[35,17,35,18],[36,6,36,7],[37,6,37,7],[52,6,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,13],[52,14,52,15],[29,15,29,16],[56,6,56,17],[57,6,57,11],[57,12,57,17],[58,6,58,7],[58,8,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,15],[58,16,58,17],[52,16,52,17],[39,6,39,7],[40,6,40,7],[50,6,50,17],[51,6,51,11],[51,12,51,17]]}
[null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,"WEPS",null,null,null,null,null,null,null,null,null,null,"Local authority"]
[]
[null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,null,null,"≤ 300km","< 500V",300.18,{"$f":"ROUND(I8 * (1 + VAT), 2)","v":345.21},91.34,{"$f":"ROUND(K8 * (1 + VAT), 2)","v":105.04},49.84,{"$f":"ROUND(M8 * (1 + VAT), 2)","v":57.32},98.28,{"$f":"ROUND(O8 * (1 + VAT), 2)","v":113.02},67.83,{"$f":"ROUND(Q8 * (1 + VAT), 2)","v":78},43.23,{"$f":"ROUND(S8 * (1 + VAT), 2)","v":49.71},8.36,{"$f":"ROUND(U8 * (1 + VAT), 2)","v":9.61}]
["WEPS","We",0,2,null,null,null,"≥ 500V & < 66kV",295.45,339.77,89.52,102.95,48.61,55.9,96.38,110.84,66.33,76.28,42.09,48.4,7.63,8.77]
["WEPS","We",0,3,null,null,null,"≥ 66kV & ≤ 132kV",286.13,329.05,86.67,99.67,47.07,54.13,93.34,107.34,64.25,73.89,40.75,46.86,7.43,8.5399999999999991]
["WEPS","We",0,4,null,null,null,"> 132kV*",269.66000000000003,310.11,81.69,93.94,44.36,51.01,87.96,101.15,60.54,69.62,38.409999999999997,44.17,9.4,10.81]
["WEPS","We",1,1,null,null,"> 300km and \n≤ 600km","< 500V",302.63,348.02,91.68,105.43,49.78,57.25,98.72,113.53,67.97,78.17,43.11,49.58,8.4,9.66]
["WEPS","We",1,2,null,null,null,"≥ 500V & < 66kV",298.39999999999998,343.16,90.4,103.96,49.09,56.45,97.35,111.95,67,77.05,42.5,48.88,7.71,8.8699999999999992]
["WEPS","We",1,3,null,null,null,"≥ 66kV & ≤ 132kV",288.93,332.27,87.52,100.65,47.52,54.65,94.25,108.39,64.86,74.59,41.14,47.31,7.48,8.6]
["WEPS","We",1,4,null,null,null,"> 132kV*",272.35000000000002,313.2,82.52,94.9,44.8,51.52,88.83,102.15,61.15,70.319999999999993,38.79,44.61,9.49,10.91]
["WEPS","We",2,1,null,null,"> 600km and \n≤ 900km","< 500V",305.64999999999998,351.5,92.6,106.49,50.27,57.81,99.7,114.66,68.63,78.92,43.54,50.07,8.51,9.7899999999999991]
["WEPS","We",2,2,null,null,null,"≥ 500V & < 66kV",301.41000000000003,346.62,91.3,105,49.58,57.02,98.34,113.09,67.64,77.790000000000006,42.93,49.37,7.77,8.94]
["WEPS","We",2,3,null,null,null,"≥ 66kV & ≤ 132kV",291.87,335.65,88.4,101.66,48,55.2,95.18,109.46,65.510000000000005,75.34,41.55,47.78,7.54,8.67]
["WEPS","We",2,4,null,null,null,"> 132kV*",275.08,316.33999999999997,83.34,95.84,45.25,52.04,89.74,103.2,61.76,71.02,39.18,45.06,9.6199999999999992,11.06]
["WEPS","We",3,1,null,null,"> 900km","< 500V",308.72000000000003,355.03,93.53,107.56,50.79,58.41,100.71,115.82,69.31,79.709999999999994,43.98,50.58,8.5500000000000007,9.83]
["WEPS","We",3,2,null,null,null,"≥ 500V & < 66kV",304.42,350.08,92.21,106.04,50.08,57.59,99.29,114.18,68.34,78.59,43.34,49.84,7.85,9.0299999999999994]
["WEPS","We",3,3,null,null,null,"≥ 66kV & ≤ 132kV",294.81,339.03,89.31,102.71,48.5,55.78,96.16,110.58,66.17,76.099999999999994,41.98,48.28,7.6,8.74]
["WEPS","We",3,4,null,null,null,"> 132kV*",277.79000000000002,319.45999999999998,84.19,96.82,45.75,52.61,90.66,104.26,62.41,71.77,39.61,45.55,9.69,11.14]
[null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,"Voltage",null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,"Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl"]
["WEPS","We",0,1,null,null,"< 500V",null,16.68,{"$f":"ROUND(I29 * (1 + VAT), 2)","v":19.18},31.61,{"$f":"ROUND(K29 * (1 + VAT), 2)","v":36.35},0,{"$f":"ROUND(M29 * (1 + VAT), 2)","v":0},null,"< 500V",null,0.39,{"$f":"ROUND(R29 * (1 + VAT), 2)","v":0.45}]
["WEPS","We",0,2,null,null,"≥ 500V & < 66kV",null,15.29,{"$f":"ROUND(I30 * (1 + VAT), 2)","v":17.579999999999998},28.99,{"$f":"ROUND(K30 * (1 + VAT), 2)","v":33.340000000000003},0,{"$f":"ROUND(M30 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",null,0.38,{"$f":"ROUND(R30 * (1 + VAT), 2)","v":0.44}]
["WEPS","We",0,3,null,null,"≥ 66kV & ≤ 132kV",null,5.47,{"$f":"ROUND(I31 * (1 + VAT), 2)","v":6.29},10.11,{"$f":"ROUND(K31 * (1 + VAT), 2)","v":11.63},13.39,{"$f":"ROUND(M31 * (1 + VAT), 2)","v":15.4},null,"≥ 66kV & ≤ 132kV",null,0.35,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":0.4}]
["WEPS","We",0,4,null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(I32 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(K32 * (1 + VAT), 2)","v":0},13.39,{"$f":"ROUND(M32 * (1 + VAT), 2)","v":15.4},null,"> 132kV / Transmission Connected",null,0.33,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":0.38}]
[]
[null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,null,null,"Reactive energy charge  [c/kVArh]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,null,null,"VAT incl",null,"VAT incl",null,null,null,"High season",null,"Low season"]
["WEPS","We",0,1,null,null,"≤ 100 kVA",null,13.54,{"$f":"ROUND(I37 * (1 + VAT), 2)","v":15.57},2.97,{"$f":"ROUND(K37 * (1 + VAT), 2)","v":3.42},null,null,null,null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,null,null,"> 100 kVA & ≤ 500 kVA",null,61.89,{"$f":"ROUND(I38 * (1 + VAT), 2)","v":71.17},17.34,{"$f":"ROUND(K38 * (1 + VAT), 2)","v":19.940000000000001},null,null,null,13.4,{"$f":"ROUND(P38 * (1 + VAT), 2)","v":15.41},0,{"$f":"ROUND(R38 * (1 + VAT), 2)","v":0}]
["WEPS","We",0,1,null,null,"> 500 kVA & ≤ 1 MVA",null,190.47,{"$f":"ROUND(I39 * (1 + VAT), 2)","v":219.04},34.479999999999997,{"$f":"ROUND(K39 * (1 + VAT), 2)","v":39.65}]
["WEPS","We",0,1,null,null,"> 1 MVA",null,190.47,{"$f":"ROUND(I40 * (1 + VAT), 2)","v":219.04},85.86,{"$f":"ROUND(K40 * (1 + VAT), 2)","v":98.74}]
["WEPS","We",0,1,null,null,"Key customers",null,3732.51,{"$f":"ROUND(I41 * (1 + VAT), 2)","v":4292.3900000000003},119.2,{"$f":"ROUND(K41 * (1 + VAT), 2)","v":137.08000000000001}]
[]
[]
[null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,"VAT incl"]
["WEPS","We",0,1,null,null,7.42,{"$f":"ROUND(G48 * (1 + VAT), 2)","v":8.5299999999999994}]
[]
[]
[null,null,null,null,null,null,"Active energy charge excluding losses   [c/kWh]"]
[null,null,null,null,null,null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,"Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,null,null,{"$f":"ROUND(I11/'Loss Factors'!$T$6, 2)","v":266.81},{"$f":"ROUND(G55 * (1 + VAT), 2)","v":306.83},{"$f":"ROUND(K11/'Loss Factors'!$T$6, 2)","v":80.83},{"$f":"ROUND(I55 * (1 + VAT), 2)","v":92.95},{"$f":"ROUND(M11/'Loss Factors'!$T$6, 2)","v":43.89},{"$f":"ROUND(K55 * (1 + VAT), 2)","v":50.47},{"$f":"ROUND(O11/'Loss Factors'!$T$6, 2)","v":87.03},{"$f":"ROUND(M55 * (1 + VAT), 2)","v":100.08},{"$f":"ROUND(Q11/'Loss Factors'!$T$6, 2)","v":59.9},{"$f":"ROUND(O55 * (1 + VAT), 2)","v":68.89},{"$f":"ROUND(S11/'Loss Factors'!$T$6, 2)","v":38},{"$f":"ROUND(Q55 * (1 + VAT), 2)","v":43.7}]
[]
[null,null,null,null,null,null,"Active energy charge excluding losses and enviromental levy   [c/kWh]"]
[null,null,null,null,null,null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,"Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,null,null,263.32,302.82,77.34,88.94,40.4,46.46,83.54,96.07,56.41,64.87,34.51,39.69]

{"sheet":"Nightsave Large inc","index":3,"n_rows":47,"n_cols":33,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,16,1,18],[3,9,3,12],[3,13,3,16],[4,7,6,7],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[3,17,5,18],[7,7,10,7],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,25,14],[42,7,44,8],[26,7,27,8],[44,9,44,10],[27,17,27,18],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[26,9,27,10],[26,11,27,12],[26,13,27,14],[35,7,36,7],[35,8,36,9],[35,10,36,11],[42,9,43,10]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,null,"Nightsave Urban Large tariff",null,null,null,null,null,null,null,null,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,"Energy demand charge [R/kVA/m]",null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl","","VAT incl",null,"VAT incl",null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL01N"},null,null,"≤ 300km","< 500V",72.34,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":83.19},56.23,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":64.66},220.11,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":253.13},30.76,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":35.369999999999997},8.3800000000000008,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":9.64}]
["Nightsave Large","NL",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL02N"},null,null,null,"≥ 500V & < 66kV",68.5,78.78,53.47,61.49,213.04,245,29.78,34.25,7.66,8.81]
["Nightsave Large","NL",0,3,"NL03N",null,null,null,"≥ 66kV & ≤ 132kV",68,78.2,52.83,60.75,205.28,236.07,28.7,33.01,7.46,8.58]
["Nightsave Large","NL",0,4,"NL04N",null,null,null,"> 132kV*",63.61,73.150000000000006,49.46,56.88,198.02,227.72,27.68,31.83,9.42,10.83]
["Nightsave Large","NL",1,1,"NL11N",null,null,"> 300km and \n≤ 600km","< 500V",73.31,84.31,56.85,65.38,222.38,255.74,31.06,35.72,8.44,9.7100000000000009]
["Nightsave Large","NL",1,2,"NL12N",null,null,null,"≥ 500V & < 66kV",69.94,80.430000000000007,54.56,62.74,215.2,247.48,30.04,34.549999999999997,7.73,8.89]
["Nightsave Large","NL",1,3,"NL13N",null,null,null,"≥ 66kV & ≤ 132kV",69.42,79.83,53.9,61.99,207.31,238.41,28.96,33.299999999999997,7.51,8.64]
["Nightsave Large","NL",1,4,"NL14N",null,null,null,"> 132kV*",64.95,74.69,50.47,58.04,200.04,230.05,27.93,32.119999999999997,9.51,10.94]
["Nightsave Large","NL",2,1,"NL21N",null,null,"> 600km and \n≤ 900km","< 500V",73.989999999999995,85.09,57.4,66.010000000000005,224.66,258.36,31.38,36.090000000000003,8.5399999999999991,9.82]
["Nightsave Large","NL",2,2,"NL22N",null,null,null,"≥ 500V & < 66kV",70.63,81.22,55.12,63.39,217.36,249.96,30.38,34.94,7.8,8.9700000000000006]
["Nightsave Large","NL",2,3,"NL23N",null,null,null,"≥ 66kV & ≤ 132kV",70.099999999999994,80.62,54.44,62.61,209.4,240.81,29.25,33.64,7.56,8.69]
["Nightsave Large","NL",2,4,"NL24N",null,null,null,"> 132kV*",65.58,75.42,50.98,58.63,202.04,232.35,28.21,32.44,9.65,11.1]
["Nightsave Large","NL",3,1,"NL31N",null,null,"> 900km","< 500V",74.78,86,57.99,66.69,226.83,260.85000000000002,31.68,36.43,8.59,9.8800000000000008]
["Nightsave Large","NL",3,2,"NL32N",null,null,null,"≥ 500V & < 66kV",71.319999999999993,82.02,55.66,64.010000000000005,219.54,252.47,30.64,35.24,7.89,9.07]
["Nightsave Large","NL",3,3,"NL33N",null,null,null,"≥ 66kV & ≤ 132kV",70.83,81.45,54.97,63.22,211.54,243.27,29.55,33.979999999999997,7.63,8.77]
["Nightsave Large","NL",3,4,"NL34N",null,null,null,"> 132kV*",66.28,76.22,51.54,59.27,204.08,234.69,28.5,32.78,9.7200000000000006,11.18]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,"Voltage",null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage","Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL01N"},null,null,"< 500V",null,16.649999999999999,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":19.149999999999999},31.57,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":36.31},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"< 500V",0.39,{"$f":"ROUND(R30 * (1 + VAT), 2)","v":0.45}]
["Nightsave Large","NL",0,2,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL02N"},null,null,"≥ 500V & < 66kV",null,15.27,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":17.559999999999999},28.96,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":33.299999999999997},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",0.38,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":0.44}]
["Nightsave Large","NL",0,3,"NL03N",null,null,"≥ 66kV & ≤ 132kV",null,5.45,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":6.27},10.1,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":11.62},13.45,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":15.47},null,"≥ 66kV & ≤ 132kV",0.36,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":0.41}]
["Nightsave Large","NL",0,4,"NL04N",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":0},13.45,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.47},null,"> 132kV*",0.34,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":0.39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Customer categories","Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B39&C39&D39&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL01N"},null,null,">1  MVA",191.16,{"$f":"ROUND(I39 * (1 + VAT), 2)","v":219.83},86.15,{"$f":"ROUND(K39 * (1 + VAT), 2)","v":99.07}]
["Nightsave Large","NL",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL01N"},null,null,"Key customers",3745.97,{"$f":"ROUND(I40 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(K40 * (1 + VAT), 2)","v":137.59}]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B47&C47&D47&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NL01N"},null,null,7.45,{"$f":"ROUND(H47 * (1 + VAT), 2)","v":8.57},3.31,{"$f":"ROUND(J47 * (1 + VAT), 2)","v":3.81}]

{"sheet":"Nightsave Large Munic inc","index":4,"n_rows":48,"n_cols":33,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,16,2,18],[4,9,4,12],[4,13,4,16],[5,7,7,7],[5,9,6,10],[5,11,6,12],[5,13,6,14],[5,15,6,16],[4,17,6,18],[8,7,11,7],[12,7,15,7],[16,7,19,7],[20,7,23,7],[26,7,26,14],[36,7,37,7],[36,8,37,9],[36,10,37,11],[43,7,45,8],[28,17,28,18],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[27,7,28,8],[33,7,33,8],[27,9,28,10],[27,11,28,12],[27,13,28,14]]}
[null,null,null,null,null,null,null,"Back to menu"]
[]
["Municiple",null,null,null,null,null,null,"Nightsave Urban Large tariff",null,null,null,null,null,null,null,null,"Local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,"Energy demand charge [R/kVA/m]",null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl","","VAT incl",null,"VAT incl",null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B9&C9&D9&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL01Y"},null,null,"≤ 300km","< 500V",74.14,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":85.26},57.65,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":66.3},221.36,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":254.56},30.93,{"$f":"ROUND(P9 * (1 + VAT), 2)","v":35.57},8.36,{"$f":"ROUND(R9 * (1 + VAT), 2)","v":9.61}]
["Nightsave Large","NL",0,2,{"$f":"B10&C10&D10&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL02Y"},null,null,null,"≥ 500V & < 66kV",70.209999999999994,80.739999999999995,54.8,63.02,214.25,246.39,29.96,34.450000000000003,7.63,8.77]
["Nightsave Large","NL",0,3,"NL03Y",null,null,null,"≥ 66kV & ≤ 132kV",69.69,80.14,54.12,62.24,206.45,237.42,28.85,33.18,7.43,8.5399999999999991]
["Nightsave Large","NL",0,4,"NL04Y",null,null,null,"> 132kV*",65.2,74.98,50.7,58.31,199.15,229.02,27.82,31.99,9.4,10.81]
["Nightsave Large","NL",1,1,"NL11Y",null,null,"> 300km and \n≤ 600km","< 500V",75.11,86.38,58.27,67.010000000000005,223.65,257.2,31.23,35.909999999999997,8.4,9.66]
["Nightsave Large","NL",1,2,"NL12Y",null,null,null,"≥ 500V & < 66kV",71.67,82.42,55.9,64.290000000000006,216.41,248.87,30.22,34.75,7.71,8.8699999999999992]
["Nightsave Large","NL",1,3,"NL13Y",null,null,null,"≥ 66kV & ≤ 132kV",71.14,81.81,55.25,63.54,208.5,239.78,29.14,33.51,7.48,8.6]
["Nightsave Large","NL",1,4,"NL14Y",null,null,null,"> 132kV*",66.540000000000006,76.52,51.73,59.49,201.18,231.36,28.1,32.32,9.49,10.91]
["Nightsave Large","NL",2,1,"NL21Y",null,null,"> 600km and \n≤ 900km","< 500V",75.83,87.2,58.83,67.650000000000006,225.92,259.81,31.56,36.29,8.51,9.7899999999999991]
["Nightsave Large","NL",2,2,"NL22Y",null,null,null,"≥ 500V & < 66kV",72.39,83.25,56.48,64.95,218.61,251.4,30.55,35.130000000000003,7.77,8.94]
["Nightsave Large","NL",2,3,"NL23Y",null,null,null,"≥ 66kV & ≤ 132kV",71.849999999999994,82.63,55.81,64.180000000000007,210.6,242.19,29.41,33.82,7.54,8.67]
["Nightsave Large","NL",2,4,"NL24Y",null,null,null,"> 132kV*",67.209999999999994,77.290000000000006,52.25,60.09,203.21,233.69,28.39,32.65,9.6199999999999992,11.06]
["Nightsave Large","NL",3,1,"NL31Y",null,null,"> 900km","< 500V",76.64,88.14,59.42,68.33,228.14,262.36,31.87,36.65,8.5500000000000007,9.83]
["Nightsave Large","NL",3,2,"NL32Y",null,null,null,"≥ 500V & < 66kV",73.11,84.08,57.03,65.58,220.79,253.91,30.82,35.44,7.85,9.0299999999999994]
["Nightsave Large","NL",3,3,"NL33Y",null,null,null,"≥ 66kV & ≤ 132kV",72.569999999999993,83.46,56.34,64.790000000000006,212.73,244.64,29.73,34.19,7.6,8.74]
["Nightsave Large","NL",3,4,"NL34Y",null,null,null,"> 132kV*",67.94,78.13,52.83,60.75,205.25,236.04,28.65,32.950000000000003,9.69,11.14]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,"Voltage",null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage","Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B31&C31&D31&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL01Y"},null,null,"< 500V",null,16.68,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":19.18},31.61,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":36.35},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"< 500V",0.39,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":0.45}]
["Nightsave Large","NL",0,2,{"$f":"B32&C32&D32&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL02Y"},null,null,"≥ 500V & < 66kV",null,15.29,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":17.579999999999998},28.99,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":33.340000000000003},0,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",0.38,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":0.44}]
["Nightsave Large","NL",0,3,"NL03Y",null,null,"≥ 66kV & ≤ 132kV",null,5.47,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":6.29},10.11,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":11.63},13.39,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.4},null,"≥ 66kV & ≤ 132kV",0.35,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":0.4}]
["Nightsave Large","NL",0,4,"NL04Y",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J34 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L34 * (1 + VAT), 2)","v":0},13.39,{"$f":"ROUND(N34 * (1 + VAT), 2)","v":15.4},null,"> 132kV*",0.33,{"$f":"ROUND(R34 * (1 + VAT), 2)","v":0.38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Customer categories","Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B40&C40&D40&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL01Y"},null,null,">1  MVA",190.47,{"$f":"ROUND(I40 * (1 + VAT), 2)","v":219.04},85.86,{"$f":"ROUND(K40 * (1 + VAT), 2)","v":98.74}]
["Nightsave Large","NL",0,1,{"$f":"B41&C41&D41&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL01Y"},null,null,"Key customers",3732.51,{"$f":"ROUND(I41 * (1 + VAT), 2)","v":4292.3900000000003},119.2,{"$f":"ROUND(K41 * (1 + VAT), 2)","v":137.08000000000001}]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl"]
["Nightsave Large","NL",0,1,{"$f":"B48&C48&D48&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"NL01Y"},null,null,7.42,{"$f":"ROUND(H48 * (1 + VAT), 2)","v":8.5299999999999994}]

{"sheet":"Nightsave Small inc","index":5,"n_rows":48,"n_cols":33,"rows_kept":48,"cut":false,"hidden":false,"merged":[[27,7,28,8],[1,6,1,16],[1,17,1,18],[3,9,3,12],[3,13,3,16],[3,17,5,18],[4,7,6,7],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[7,7,10,7],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,25,14],[25,19,25,20],[26,9,27,10],[26,11,27,12],[26,13,27,14],[27,17,27,18],[35,10,36,11],[43,7,45,8],[43,9,44,10],[45,9,45,10],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[35,7,36,7],[35,8,36,9]]}
[null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,"Nightsave Urban Small tariff  ",null,null,null,null,null,null,null,null,null,null,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,"Energy demand charge [R/kVA/m]",null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl","","VAT incl",null,"VAT incl",null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,"≤ 300km","< 500V",72.34,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":83.19},56.23,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":64.66},154.58000000000001,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":177.77},19.920000000000002,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":22.91},8.3800000000000008,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":9.64}]
["Nightsave Small","NS",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS02N"},null,null,null,"≥ 500V & < 66kV",68.5,78.78,53.47,61.49,149.61000000000001,172.05,19.25,22.14,7.66,8.81]
["Nightsave Small","NS",0,3,"NS03N",null,null,null,"≥ 66kV & ≤ 132kV",68,78.2,52.83,60.75,144.1,165.72,18.53,21.31,7.46,8.58]
["Nightsave Small","NS",0,4,"NS04N",null,null,null,"> 132kV*",63.61,73.150000000000006,49.46,56.88,139.06,159.91999999999999,17.89,20.57,9.42,10.83]
["Nightsave Small","NS",1,1,"NS11N",null,null,"> 300km and \n≤ 600km","< 500V",73.31,84.31,56.85,65.38,156.16,179.58,20.079999999999998,23.09,8.44,9.7100000000000009]
["Nightsave Small","NS",1,2,"NS12N",null,null,null,"≥ 500V & < 66kV",69.94,80.430000000000007,54.56,62.74,151.11000000000001,173.78,19.440000000000001,22.36,7.73,8.89]
["Nightsave Small","NS",1,3,"NS13N",null,null,null,"≥ 66kV & ≤ 132kV",69.42,79.83,53.9,61.99,145.59,167.43,18.73,21.54,7.51,8.64]
["Nightsave Small","NS",1,4,"NS14N",null,null,null,"> 132kV*",64.95,74.69,50.47,58.04,140.44999999999999,161.52000000000001,18.07,20.78,9.51,10.94]
["Nightsave Small","NS",2,1,"NS21N",null,null,"> 600km and \n≤ 900km","< 500V",73.989999999999995,85.09,57.4,66.010000000000005,157.69999999999999,181.36,20.27,23.31,8.5399999999999991,9.82]
["Nightsave Small","NS",2,2,"NS22N",null,null,null,"≥ 500V & < 66kV",70.63,81.22,55.12,63.39,152.66,175.56,19.64,22.59,7.8,8.9700000000000006]
["Nightsave Small","NS",2,3,"NS23N",null,null,null,"≥ 66kV & ≤ 132kV",70.099999999999994,80.62,54.44,62.61,147.05000000000001,169.11,18.920000000000002,21.76,7.56,8.69]
["Nightsave Small","NS",2,4,"NS24N",null,null,null,"> 132kV*",65.58,75.42,50.98,58.63,141.84,163.12,18.25,20.99,9.65,11.1]
["Nightsave Small","NS",3,1,"NS31N",null,null,"> 900km","< 500V",74.78,86,57.99,66.69,159.31,183.21,20.49,23.56,8.59,9.8800000000000008]
["Nightsave Small","NS",3,2,"NS32N",null,null,null,"≥ 500V & < 66kV",71.319999999999993,82.02,55.66,64.010000000000005,154.15,177.27,19.84,22.82,7.89,9.07]
["Nightsave Small","NS",3,3,"NS33N",null,null,null,"≥ 66kV & ≤ 132kV",70.83,81.45,54.97,63.22,148.55000000000001,170.83,19.12,21.99,7.63,8.77]
["Nightsave Small","NS",3,4,"NS34N",null,null,null,"> 132kV*",66.28,76.22,51.54,59.27,143.32,164.82,18.46,21.23,9.7200000000000006,11.18]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,null,null,null,"Voltage","Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,"< 500V",null,16.649999999999999,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":19.149999999999999},31.57,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":36.31},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"< 500V",0.39,{"$f":"ROUND(R30 * (1 + VAT), 2)","v":0.45}]
["Nightsave Small","NS",0,2,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS02N"},null,null,"≥ 500V & < 66kV",null,15.27,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":17.559999999999999},28.96,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":33.299999999999997},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",0.38,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":0.44}]
["Nightsave Small","NS",0,3,"NS03N",null,null,"≥ 66kV & ≤ 132kV",null,5.45,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":6.27},10.1,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":11.62},13.45,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":15.47},null,"≥ 66kV & ≤ 132kV",0.36,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":0.41}]
["Nightsave Small","NS",0,4,"NS04N",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":0},13.45,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.47},null,"> 132kV*",0.34,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":0.39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Customer categories","Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B39&C39&D39&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,"≤ 100 kVA",13.6,{"$f":"ROUND(I39 * (1 + VAT), 2)","v":15.64},2.99,{"$f":"ROUND(K39 * (1 + VAT), 2)","v":3.44}]
["Nightsave Small","NS",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,"> 100 kVA & ≤ 500 kVA",62.12,{"$f":"ROUND(I40 * (1 + VAT), 2)","v":71.44},17.420000000000002,{"$f":"ROUND(K40 * (1 + VAT), 2)","v":20.03}]
["Nightsave Small","NS",0,1,{"$f":"B41&C41&D41&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,"> 500 kVA & ≤ 1 MVA",191.16,{"$f":"ROUND(I41 * (1 + VAT), 2)","v":219.83},34.6,{"$f":"ROUND(K41 * (1 + VAT), 2)","v":39.79}]
["Nightsave Small","NS",0,1,{"$f":"B42&C42&D42&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,"Key customers",3745.97,{"$f":"ROUND(I42 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(K42 * (1 + VAT), 2)","v":137.59}]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B48&C48&D48&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01N"},null,null,7.45,{"$f":"ROUND(H48 * (1 + VAT), 2)","v":8.57},3.31,{"$f":"ROUND(J48 * (1 + VAT), 2)","v":3.81}]

{"sheet":"Nightsave Small Munic inc","index":6,"n_rows":48,"n_cols":33,"rows_kept":48,"cut":false,"hidden":false,"merged":[[27,7,28,8],[1,6,1,16],[1,17,1,18],[3,9,3,12],[3,13,3,16],[3,17,5,18],[4,7,6,7],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[7,7,10,7],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,25,14],[25,19,25,20],[26,9,27,10],[26,11,27,12],[26,13,27,14],[27,17,27,18],[35,10,36,11],[43,7,45,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[35,7,36,7],[35,8,36,9]]}
[null,null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,null,"Nightsave Urban Small tariff  ",null,null,null,null,null,null,null,null,null,null,"Local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,"Energy demand charge [R/kVA/m]",null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl","","VAT incl",null,"VAT incl",null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,"≤ 300km","< 500V",74.14,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":85.26},57.65,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":66.3},155.44999999999999,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":178.77},20.05,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":23.06},8.36,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":9.61}]
["Nightsave Small","NS",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS02Y"},null,null,null,"≥ 500V & < 66kV",70.209999999999994,80.739999999999995,54.8,63.02,150.44999999999999,173.02,19.36,22.26,7.63,8.77]
["Nightsave Small","NS",0,3,"NS03Y",null,null,null,"≥ 66kV & ≤ 132kV",69.69,80.14,54.12,62.24,144.94,166.68,18.63,21.42,7.43,8.5399999999999991]
["Nightsave Small","NS",0,4,"NS04Y",null,null,null,"> 132kV*",65.2,74.98,50.7,58.31,139.85,160.83000000000001,17.989999999999998,20.69,9.4,10.81]
["Nightsave Small","NS",1,1,"NS11Y",null,null,"> 300km and \n≤ 600km","< 500V",75.11,86.38,58.27,67.010000000000005,157.05000000000001,180.61,20.21,23.24,8.4,9.66]
["Nightsave Small","NS",1,2,"NS12Y",null,null,null,"≥ 500V & < 66kV",71.67,82.42,55.9,64.290000000000006,152,174.8,19.54,22.47,7.71,8.8699999999999992]
["Nightsave Small","NS",1,3,"NS13Y",null,null,null,"≥ 66kV & ≤ 132kV",71.14,81.81,55.25,63.54,146.43,168.39,18.82,21.64,7.48,8.6]
["Nightsave Small","NS",1,4,"NS14Y",null,null,null,"> 132kV*",66.540000000000006,76.52,51.73,59.49,141.25,162.44,18.170000000000002,20.9,9.49,10.91]
["Nightsave Small","NS",2,1,"NS21Y",null,null,"> 600km and \n≤ 900km","< 500V",75.83,87.2,58.83,67.650000000000006,158.62,182.41,20.39,23.45,8.51,9.7899999999999991]
["Nightsave Small","NS",2,2,"NS22Y",null,null,null,"≥ 500V & < 66kV",72.39,83.25,56.48,64.95,153.51,176.54,19.75,22.71,7.77,8.94]
["Nightsave Small","NS",2,3,"NS23Y",null,null,null,"≥ 66kV & ≤ 132kV",71.849999999999994,82.63,55.81,64.180000000000007,147.9,170.09,19.02,21.87,7.54,8.67]
["Nightsave Small","NS",2,4,"NS24Y",null,null,null,"> 132kV*",67.209999999999994,77.290000000000006,52.25,60.09,142.65,164.05,18.34,21.09,9.6199999999999992,11.06]
["Nightsave Small","NS",3,1,"NS31Y",null,null,"> 900km","< 500V",76.64,88.14,59.42,68.33,160.22,184.25,20.59,23.68,8.5500000000000007,9.83]
["Nightsave Small","NS",3,2,"NS32Y",null,null,null,"≥ 500V & < 66kV",73.11,84.08,57.03,65.58,155.03,178.28,19.940000000000001,22.93,7.85,9.0299999999999994]
["Nightsave Small","NS",3,3,"NS33Y",null,null,null,"≥ 66kV & ≤ 132kV",72.569999999999993,83.46,56.34,64.790000000000006,149.38999999999999,171.8,19.22,22.1,7.6,8.74]
["Nightsave Small","NS",3,4,"NS34Y",null,null,null,"> 132kV*",67.94,78.13,52.83,60.75,144.15,165.77,18.559999999999999,21.34,9.69,11.14]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,null,null,null,"Voltage","Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,"< 500V",null,16.68,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":19.18},31.61,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":36.35},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"< 500V",0.39,{"$f":"ROUND(R30 * (1 + VAT), 2)","v":0.45}]
["Nightsave Small","NS",0,2,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS02Y"},null,null,"≥ 500V & < 66kV",null,15.29,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":17.579999999999998},28.99,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":33.340000000000003},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",0.38,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":0.44}]
["Nightsave Small","NS",0,3,"NS03Y",null,null,"≥ 66kV & ≤ 132kV",null,5.47,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":6.29},10.11,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":11.63},13.39,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":15.4},null,"≥ 66kV & ≤ 132kV",0.35,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":0.4}]
["Nightsave Small","NS",0,4,"NS04Y",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":0},13.39,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.4},null,"> 132kV*",0.33,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":0.38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Customer categories","Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B39&C39&D39&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,"≤ 100 kVA",13.54,{"$f":"ROUND(I39 * (1 + VAT), 2)","v":15.57},2.97,{"$f":"ROUND(K39 * (1 + VAT), 2)","v":3.42}]
["Nightsave Small","NS",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,"> 100 kVA & ≤ 500 kVA",61.89,{"$f":"ROUND(I40 * (1 + VAT), 2)","v":71.17},17.34,{"$f":"ROUND(K40 * (1 + VAT), 2)","v":19.940000000000001}]
["Nightsave Small","NS",0,1,{"$f":"B41&C41&D41&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,"> 500 kVA & ≤ 1 MVA",190.47,{"$f":"ROUND(I41 * (1 + VAT), 2)","v":219.04},34.479999999999997,{"$f":"ROUND(K41 * (1 + VAT), 2)","v":39.65}]
["Nightsave Small","NS",0,1,{"$f":"B42&C42&D42&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,"Key customers",3732.51,{"$f":"ROUND(I42 * (1 + VAT), 2)","v":4292.3900000000003},119.2,{"$f":"ROUND(K42 * (1 + VAT), 2)","v":137.08000000000001}]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl"]
["Nightsave Small","NS",0,1,{"$f":"B48&C48&D48&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NS01Y"},null,null,7.42,{"$f":"ROUND(H48 * (1 + VAT), 2)","v":8.5299999999999994}]

{"sheet":"Megaflex inc","index":7,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":false,"merged":[[11,7,14,7],[7,7,10,7],[30,7,30,8],[30,16,30,17],[15,7,18,7],[19,7,22,7],[25,7,25,14],[26,9,27,10],[26,11,27,12],[26,13,27,14],[29,7,29,8],[29,16,29,17],[37,7,37,8],[39,7,39,8],[1,6,1,16],[1,17,1,22],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[3,21,5,22],[27,18,27,19],[41,7,43,8],[27,7,28,8],[27,16,28,17],[31,7,31,8],[31,16,31,17],[38,7,38,8],[41,9,42,10],[43,9,43,10],[32,7,32,8],[32,16,32,17],[35,7,35,8],[35,9,36,10],[35,11,36,12],[35,16,35,19],[36,16,36,17],[36,18,36,19]]}
[null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,"Megaflex tariff",null,null,null,null,null,null,null,null,null,null,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:T23,V8:V23,#REF!,#REF!,#REF!,#REF!,H26:J26,L26)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,"≤ 300km","< 500V",292.89,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":336.82},89.11,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":102.48},48.66,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":55.96},95.91,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":110.3},66.180000000000007,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":76.11},42.19,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":48.52},8.3800000000000008,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":9.64}]
["Megaflex","Me",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me02N"},null,null,null,"≥ 500V & < 66kV",288.29000000000002,331.53,87.34,100.44,47.43,54.54,94.03,108.13,64.73,74.44,41.06,47.22,7.66,8.81]
["Megaflex","Me",0,3,"Me03N",null,null,null,"≥ 66kV & ≤ 132kV",279.16000000000003,321.02999999999997,84.56,97.24,45.93,52.82,91.08,104.74,62.67,72.069999999999993,39.770000000000003,45.74,7.46,8.58]
["Megaflex","Me",0,4,"Me04N",null,null,null,"> 132kV*",263.11,302.58,79.7,91.66,43.29,49.78,85.85,98.73,59.07,67.930000000000007,37.479999999999997,43.1,9.42,10.83]
["Megaflex","Me",1,1,"Me11N",null,null,"> 300km and \n≤ 600km","< 500V",295.27999999999997,339.57,89.47,102.89,48.57,55.86,96.33,110.78,66.319999999999993,76.27,42.07,48.38,8.44,9.7100000000000009]
["Megaflex","Me",1,2,"Me12N",null,null,null,"≥ 500V & < 66kV",291.17,334.85,88.2,101.43,47.9,55.09,94.99,109.24,65.37,75.180000000000007,41.47,47.69,7.73,8.89]
["Megaflex","Me",1,3,"Me13N",null,null,null,"≥ 66kV & ≤ 132kV",281.91000000000003,324.2,85.39,98.2,46.36,53.31,91.96,105.75,63.29,72.78,40.15,46.17,7.51,8.64]
["Megaflex","Me",1,4,"Me14N",null,null,null,"> 132kV*",265.74,305.60000000000002,80.510000000000005,92.59,43.69,50.24,86.67,99.67,59.65,68.599999999999994,37.83,43.5,9.51,10.94]
["Megaflex","Me",2,1,"Me21N",null,null,"> 600km and \n≤ 900km","< 500V",298.22000000000003,342.95,90.34,103.89,49.04,56.4,97.29,111.88,66.959999999999994,77,42.46,48.83,8.5399999999999991,9.82]
["Megaflex","Me",2,2,"Me22N",null,null,null,"≥ 500V & < 66kV",294.10000000000002,338.22,89.1,102.47,48.38,55.64,95.93,110.32,66.03,75.930000000000007,41.89,48.17,7.8,8.9700000000000006]
["Megaflex","Me",2,3,"Me23N",null,null,null,"≥ 66kV & ≤ 132kV",284.77999999999997,327.5,86.27,99.21,46.84,53.87,92.89,106.82,63.94,73.53,40.56,46.64,7.56,8.69]
["Megaflex","Me",2,4,"Me24N",null,null,null,"> 132kV*",268.42,308.68,81.3,93.5,44.17,50.8,87.56,100.69,60.25,69.290000000000006,38.24,43.98,9.65,11.1]
["Megaflex","Me",3,1,"Me31N",null,null,"> 900km","< 500V",301.22000000000003,346.4,91.28,104.97,49.55,56.98,98.27,113.01,67.62,77.760000000000005,42.92,49.36,8.59,9.8800000000000008]
["Megaflex","Me",3,2,"Me32N",null,null,null,"≥ 500V & < 66kV",297.02,341.57,89.97,103.47,48.84,56.17,96.87,111.4,66.66,76.66,42.3,48.65,7.89,9.07]
["Megaflex","Me",3,3,"Me33N",null,null,null,"≥ 66kV & ≤ 132kV",287.64,330.79,87.13,100.2,47.31,54.41,93.82,107.89,64.58,74.27,40.97,47.12,7.63,8.77]
["Megaflex","Me",3,4,"Me34N",null,null,null,"> 132kV*",271.02999999999997,311.68,82.14,94.46,44.63,51.32,88.47,101.74,60.91,70.05,38.659999999999997,44.46,9.7200000000000006,11.18]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,null,null,null,"Voltage",null,"Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,"< 500V",null,16.649999999999999,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":19.149999999999999},31.57,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":36.31},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"< 500V",null,0.39,{"$f":"ROUND(S30 * (1 + VAT), 2)","v":0.45}]
["Megaflex","Me",0,2,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me02N"},null,null,"≥ 500V & < 66kV",null,15.27,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":17.559999999999999},28.96,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":33.299999999999997},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",null,0.38,{"$f":"ROUND(S31 * (1 + VAT), 2)","v":0.44}]
["Megaflex","Me",0,3,"Me03N",null,null,"≥ 66kV & ≤ 132kV",null,5.45,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":6.27},10.1,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":11.62},13.45,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":15.47},null,"≥ 66kV & ≤ 132kV",null,0.36,{"$f":"ROUND(S32 * (1 + VAT), 2)","v":0.41}]
["Megaflex","Me",0,4,"Me04N",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":0},13.45,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.47},null,"> 132kV / Transmission connected",null,0.34,{"$f":"ROUND(S33 * (1 + VAT), 2)","v":0.39}]
[]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,null,null,"Reactive energy charge  [c/kVArh]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High season",null,"Low season"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl",null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B39&C39&D39&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,"> 1 MVA",null,191.16,{"$f":"ROUND(J39 * (1 + VAT), 2)","v":219.83},86.15,{"$f":"ROUND(L39 * (1 + VAT), 2)","v":99.07},null,null,null,13.47,{"$f":"ROUND(Q39 * (1 + VAT), 2)","v":15.49},0,{"$f":"ROUND(S39 * (1 + VAT), 2)","v":0}]
["Megaflex","Me",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,"Key customers",null,3745.97,{"$f":"ROUND(J40 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(L40 * (1 + VAT), 2)","v":137.59}]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B46&C46&D46&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,7.45,{"$f":"ROUND(H46 * (1 + VAT), 2)","v":8.57},3.31,{"$f":"ROUND(J46 * (1 + VAT), 2)","v":3.81}]

{"sheet":"Megaflex Munic inc ","index":8,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,16,35,19],[36,16,36,17],[36,18,36,19],[11,7,14,7],[7,7,10,7],[30,7,30,8],[30,16,30,17],[15,7,18,7],[19,7,22,7],[25,7,25,14],[26,9,27,10],[26,11,27,12],[26,13,27,14],[1,17,1,22],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[3,21,5,22],[1,6,1,16],[41,7,43,8],[27,18,27,19],[29,7,29,8],[29,16,29,17],[27,7,28,8],[27,16,28,17],[39,7,39,8],[38,7,38,8],[37,7,37,8],[31,7,31,8],[31,16,31,17],[32,7,32,8],[32,16,32,17],[35,7,35,8],[35,9,36,10],[35,11,36,12]]}
[null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Municiple",null,null,null,null,null,"Megaflex tariff",null,null,null,null,null,null,null,null,null,null,"Local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:T23,V8:V23,#REF!,#REF!,#REF!,#REF!,H26:J26,L26)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01Y"},null,null,"≤ 300km","< 500V",300.18,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":345.21},91.34,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":105.04},49.84,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":57.32},98.28,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":113.02},67.83,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":78},43.23,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":49.71},8.36,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":9.61}]
["Megaflex","Me",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me02Y"},null,null,null,"≥ 500V & < 66kV",295.45,339.77,89.52,102.95,48.61,55.9,96.38,110.84,66.33,76.28,42.09,48.4,7.63,8.77]
["Megaflex","Me",0,3,"Me03Y",null,null,null,"≥ 66kV & ≤ 132kV",286.13,329.05,86.67,99.67,47.07,54.13,93.34,107.34,64.25,73.89,40.75,46.86,7.43,8.5399999999999991]
["Megaflex","Me",0,4,"Me04Y",null,null,null,"> 132kV*",269.66000000000003,310.11,81.69,93.94,44.36,51.01,87.96,101.15,60.54,69.62,38.409999999999997,44.17,9.4,10.81]
["Megaflex","Me",1,1,"Me11Y",null,null,"> 300km and \n≤ 600km","< 500V",302.63,348.02,91.68,105.43,49.78,57.25,98.72,113.53,67.97,78.17,43.11,49.58,8.4,9.66]
["Megaflex","Me",1,2,"Me12Y",null,null,null,"≥ 500V & < 66kV",298.39999999999998,343.16,90.4,103.96,49.09,56.45,97.35,111.95,67,77.05,42.5,48.88,7.71,8.8699999999999992]
["Megaflex","Me",1,3,"Me13Y",null,null,null,"≥ 66kV & ≤ 132kV",288.93,332.27,87.52,100.65,47.52,54.65,94.25,108.39,64.86,74.59,41.14,47.31,7.48,8.6]
["Megaflex","Me",1,4,"Me14Y",null,null,null,"> 132kV*",272.35000000000002,313.2,82.52,94.9,44.8,51.52,88.83,102.15,61.15,70.319999999999993,38.79,44.61,9.49,10.91]
["Megaflex","Me",2,1,"Me21Y",null,null,"> 600km and \n≤ 900km","< 500V",305.64999999999998,351.5,92.6,106.49,50.27,57.81,99.7,114.66,68.63,78.92,43.54,50.07,8.51,9.7899999999999991]
["Megaflex","Me",2,2,"Me22Y",null,null,null,"≥ 500V & < 66kV",301.41000000000003,346.62,91.3,105,49.58,57.02,98.34,113.09,67.64,77.790000000000006,42.93,49.37,7.77,8.94]
["Megaflex","Me",2,3,"Me23Y",null,null,null,"≥ 66kV & ≤ 132kV",291.87,335.65,88.4,101.66,48,55.2,95.18,109.46,65.510000000000005,75.34,41.55,47.78,7.54,8.67]
["Megaflex","Me",2,4,"Me24Y",null,null,null,"> 132kV*",275.08,316.33999999999997,83.34,95.84,45.25,52.04,89.74,103.2,61.76,71.02,39.18,45.06,9.6199999999999992,11.06]
["Megaflex","Me",3,1,"Me31Y",null,null,"> 900km","< 500V",308.72000000000003,355.03,93.53,107.56,50.79,58.41,100.71,115.82,69.31,79.709999999999994,43.98,50.58,8.5500000000000007,9.83]
["Megaflex","Me",3,2,"Me32Y",null,null,null,"≥ 500V & < 66kV",304.42,350.08,92.21,106.04,50.08,57.59,99.29,114.18,68.34,78.59,43.34,49.84,7.85,9.0299999999999994]
["Megaflex","Me",3,3,"Me33Y",null,null,null,"≥ 66kV & ≤ 132kV",294.81,339.03,89.31,102.71,48.5,55.78,96.16,110.58,66.17,76.099999999999994,41.98,48.28,7.6,8.74]
["Megaflex","Me",3,4,"Me34Y",null,null,null,"> 132kV*",277.79000000000002,319.45999999999998,84.19,96.82,45.75,52.61,90.66,104.26,62.41,71.77,39.61,45.55,9.69,11.14]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Distribution network charges"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,null,null,null,"Voltage",null,"Ancillary service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01Y"},null,null,"< 500V",null,16.68,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":19.18},31.61,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":36.35},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"< 500V",null,0.39,{"$f":"ROUND(S30 * (1 + VAT), 2)","v":0.45}]
["Megaflex","Me",0,2,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me02Y"},null,null,"≥ 500V & < 66kV",null,15.29,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":17.579999999999998},28.99,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":33.340000000000003},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",null,0.38,{"$f":"ROUND(S31 * (1 + VAT), 2)","v":0.44}]
["Megaflex","Me",0,3,"Me03Y",null,null,"≥ 66kV & ≤ 132kV",null,5.47,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":6.29},10.11,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":11.63},13.39,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":15.4},null,"≥ 66kV & ≤ 132kV",null,0.35,{"$f":"ROUND(S32 * (1 + VAT), 2)","v":0.4}]
["Megaflex","Me",0,4,"Me04Y",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":0},13.39,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.4},null,"> 132kV / Transmission connected",null,0.33,{"$f":"ROUND(S33 * (1 + VAT), 2)","v":0.38}]
[]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,null,null,"Reactive energy charge  [c/kVArh]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High season",null,"Low season"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl",null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B39&C39&D39&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01Y"},null,null,"> 1 MVA",null,190.47,{"$f":"ROUND(J39 * (1 + VAT), 2)","v":219.04},85.86,{"$f":"ROUND(L39 * (1 + VAT), 2)","v":98.74},null,null,null,13.4,{"$f":"ROUND(Q39 * (1 + VAT), 2)","v":15.41},0,{"$f":"ROUND(S39 * (1 + VAT), 2)","v":0}]
["Megaflex","Me",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01Y"},null,null,"Key customers",null,3732.51,{"$f":"ROUND(J40 * (1 + VAT), 2)","v":4292.3900000000003},119.2,{"$f":"ROUND(L40 * (1 + VAT), 2)","v":137.08000000000001}]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]"]
[]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl"]
["Megaflex","Me",0,1,{"$f":"B46&C46&D46&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01Y"},null,null,7.42,{"$f":"ROUND(H46 * (1 + VAT), 2)","v":8.5299999999999994}]

{"sheet":"Megaflex Gen inc","index":9,"n_rows":64,"n_cols":25,"rows_kept":64,"cut":false,"hidden":false,"merged":[[58,12,58,13],[56,7,56,10],[56,12,56,14],[57,7,57,9],[57,10,57,11],[57,12,57,14],[58,10,58,11],[39,7,39,8],[38,7,38,8],[46,9,47,10],[48,9,48,10],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[46,7,48,8],[45,7,45,10],[32,7,32,8],[33,7,33,8],[36,7,36,8],[36,9,37,10],[36,11,37,12],[37,7,37,8],[31,7,31,8],[15,7,18,7],[19,7,22,7],[26,7,26,14],[27,9,28,10],[27,11,28,12],[27,13,28,14],[23,7,23,8],[30,7,30,8],[28,7,29,8],[11,7,14,7],[1,6,1,16],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[7,7,10,7],[1,17,1,24],[3,21,5,22],[26,16,26,19],[26,20,26,23],[28,16,28,17],[28,20,28,21],[32,20,32,21],[28,22,29,23],[28,18,28,19],[33,20,33,21],[30,20,30,21],[31,20,31,21],[46,16,46,19],[47,16,47,17],[47,18,47,19],[34,20,35,23],[30,16,30,17],[31,16,31,17],[32,16,32,17],[33,16,33,17],[34,16,34,17],[35,16,35,17],[39,16,39,17],[37,16,38,19],[39,18,39,19],[44,16,44,17],[43,16,43,17],[41,16,41,17],[40,16,40,17],[42,16,42,17],[53,7,53,14],[54,7,54,11],[54,12,54,14],[55,7,55,11],[55,12,55,14]]}
[null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Non-municipal",null,null,null,null,null,"Megaflex Gen tariff",null,null,null,null,null,null,null,null,null,null,{"$f":"Menu!$H$7","v":"Non-local authority"}]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge for loads [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Transmission network charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Genflex urban loads","GU",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"≤ 300km","< 500V",292.89,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":336.82},89.11,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":102.48},48.66,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":55.96},95.91,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":110.3},66.180000000000007,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":76.11},42.19,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":48.52},8.3800000000000008,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":9.64}]
["Genflex urban loads","GU",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU02N"},null,null,null,"≥ 500V & < 66kV",288.29000000000002,331.53,87.34,100.44,47.43,54.54,94.03,108.13,64.73,74.44,41.06,47.22,7.66,8.81]
["Genflex urban loads","GU",0,3,"GU03N",null,null,null,"≥ 66kV & ≤ 132kV",279.16000000000003,321.02999999999997,84.56,97.24,45.93,52.82,91.08,104.74,62.67,72.069999999999993,39.770000000000003,45.74,7.46,8.58]
["Genflex urban loads","GU",0,4,"GU04N",null,null,null,"> 132kV*",263.11,302.58,79.7,91.66,43.29,49.78,85.85,98.73,59.07,67.930000000000007,37.479999999999997,43.1,9.42,10.83]
["Genflex urban loads","GU",1,1,"GU11N",null,null,"> 300km and \n≤ 600km","< 500V",295.27999999999997,339.57,89.47,102.89,48.57,55.86,96.33,110.78,66.319999999999993,76.27,42.07,48.38,8.44,9.7100000000000009]
["Genflex urban loads","GU",1,2,"GU12N",null,null,null,"≥ 500V & < 66kV",291.17,334.85,88.2,101.43,47.9,55.09,94.99,109.24,65.37,75.180000000000007,41.47,47.69,7.73,8.89]
["Genflex urban loads","GU",1,3,"GU13N",null,null,null,"≥ 66kV & ≤ 132kV",281.91000000000003,324.2,85.39,98.2,46.36,53.31,91.96,105.75,63.29,72.78,40.15,46.17,7.51,8.64]
["Genflex urban loads","GU",1,4,"GU14N",null,null,null,"> 132kV*",265.74,305.60000000000002,80.510000000000005,92.59,43.69,50.24,86.67,99.67,59.65,68.599999999999994,37.83,43.5,9.51,10.94]
["Genflex urban loads","GU",2,1,"GU21N",null,null,"> 600km and \n≤ 900km","< 500V",298.22000000000003,342.95,90.34,103.89,49.04,56.4,97.29,111.88,66.959999999999994,77,42.46,48.83,8.5399999999999991,9.82]
["Genflex urban loads","GU",2,2,"GU22N",null,null,null,"≥ 500V & < 66kV",294.10000000000002,338.22,89.1,102.47,48.38,55.64,95.93,110.32,66.03,75.930000000000007,41.89,48.17,7.8,8.9700000000000006]
["Genflex urban loads","GU",2,3,"GU23N",null,null,null,"≥ 66kV & ≤ 132kV",284.77999999999997,327.5,86.27,99.21,46.84,53.87,92.89,106.82,63.94,73.53,40.56,46.64,7.56,8.69]
["Genflex urban loads","GU",2,4,"GU24N",null,null,null,"> 132kV*",268.42,308.68,81.3,93.5,44.17,50.8,87.56,100.69,60.25,69.290000000000006,38.24,43.98,9.65,11.1]
["Genflex urban loads","GU",3,1,"GU31N",null,null,"> 900km","< 500V",301.22000000000003,346.4,91.28,104.97,49.55,56.98,98.27,113.01,67.62,77.760000000000005,42.92,49.36,8.59,9.8800000000000008]
["Genflex urban loads","GU",3,2,"GU32N",null,null,null,"≥ 500V & < 66kV",297.02,341.57,89.97,103.47,48.84,56.17,96.87,111.4,66.66,76.66,42.3,48.65,7.89,9.07]
["Genflex urban loads","GU",3,3,"GU33N",null,null,null,"≥ 66kV & ≤ 132kV",287.64,330.79,87.13,100.2,47.31,54.41,93.82,107.89,64.58,74.27,40.97,47.12,7.63,8.77]
["Genflex urban loads","GU",3,4,"GU34N",null,null,null,"> 132kV*",271.02999999999997,311.68,82.14,94.46,44.63,51.32,88.47,101.74,60.91,70.05,38.659999999999997,44.46,9.7200000000000006,11.18]
["Gen-purchase","NLPurchADJ",0,4,"NLPurchADJ04N",null,null,"WEPS energy rate excluding losses",null,260.32452755515982,299.37,78.85623825071734,{"$f":"ROUND(L24 * (1 + VAT), 2)","v":90.68},42.831700801424759,{"$f":"ROUND(N24 * (1 + VAT), 2)","v":49.26},84.941129909963394,{"$f":"ROUND(P24 * (1 + VAT), 2)","v":97.68},58.444642327100034,{"$f":"ROUND(R24 * (1 + VAT), 2)","v":67.209999999999994},37.083209656673588,{"$f":"ROUND(T24 * (1 + VAT), 2)","v":42.65}]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,"GenTUOSCape4N",null,null,null,"* 132 kV or Transmission connected"]
["TUoS network charges for Transmission connected generators","GenTUOS","Karoo",4,"GenTUOSKaroo4N"]
["TUoS network charges for Transmission connected generators","GenTUOS","Kwazulu-Natal",4,"GenTUOSKwazulu-Natal4N",null,null,"Distribution network charges for loads",null,null,null,null,null,null,null,null,"Transmission network charges for generators ",null,null,null,"Distribution network charges for generators*"]
["TUoS network charges for Transmission connected generators","GenTUOS","Vaal",4,"GenTUOSVaal4N",null,null,null,null,"Network capacity charge \n[R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
["TUoS network charges for Transmission connected generators","GenTUOS","Waterburg",4,"GenTUOSWaterburg4N",null,null,"Voltage",null,null,null,null,null,null,null,null,"TUoS [ > 132kV]",null,"Network charge\n[R/kW]",null,"Voltage ",null,"Network capacity charge    [R/kW/m]"]
["TUoS network charges for Transmission connected generators","GenTUOS","Mpumalanga",4,"GenTUOSMpumalanga4N",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl"]
["Genflex urban loads","GU",0,1,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"< 500V",null,16.649999999999999,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":19.149999999999999},31.57,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":36.31},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"Cape",null,0,{"$f":"ROUND(S31 * (1 + VAT), 2)","v":0},null,null,null,"VAT incl"]
["Genflex urban loads","GU",0,2,{"$f":"B32&C32&D32&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU02N"},null,null,"≥ 500V & < 66kV",null,15.27,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":17.559999999999999},28.96,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":33.299999999999997},0,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":0},null,"Karoo",null,0,0,"< 500V"]
["Genflex urban loads","GU",0,3,"GU03N",null,null,"≥ 66kV & ≤ 132kV",null,5.45,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":6.27},10.1,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":11.62},13.45,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":15.47},null,"Kwazulu-Natal",null,1.98,2.2799999999999998,"≥ 500V & < 66kV"]
["Genflex urban loads","GU",0,4,"GU04N",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J34 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L34 * (1 + VAT), 2)","v":0},13.45,{"$f":"ROUND(N34 * (1 + VAT), 2)","v":15.47},null,"Vaal",null,6.59,7.58,"≥ 66kV & ≤ 132kV",null,13.47,{"$f":"ROUND(W34 * (1 + VAT), 2)","v":15.49}]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,null,null,null,null,null,null,null,null,null,"Waterberg",null,8.44,9.7100000000000009,"* The Distribution network charge will be rebated by the Losses charge, but not beyond extintion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mpumalanga",null,7.83,9]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[null,null,null,null,null,null,null,"[kVA or MVA = loads]",null,null,null,null,null,null,null,null,"Ancillary service charge for loads and generators"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"[kW or MW = generators]",null,null,"VAT incl",null,"VAT incl"]
["Genflex urban loads","GU",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"≤ 100 KVA/ kW ",null,13.6,{"$f":"ROUND(J40 * (1 + VAT), 2)","v":15.64},2.99,{"$f":"ROUND(L40 * (1 + VAT), 2)","v":3.44},null,null,null,"Voltage",null,"Ancillary service charge [c/kWh]"]
["Genflex urban loads","GU",0,1,{"$f":"B41&C41&D41&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"> 100 kVA/ kW & ≤ 500 kVA/ kW",null,62.12,{"$f":"ROUND(J41 * (1 + VAT), 2)","v":71.44},17.420000000000002,{"$f":"ROUND(L41 * (1 + VAT), 2)","v":20.03},null,null,null,null,null,null,"VAT incl"]
["Genflex urban loads","GU",0,1,"GU01N",null,null,"> 500 kVA/ kW & ≤ 1 MVA/MW",null,191.16,{"$f":"ROUND(J42 * (1 + VAT), 2)","v":219.83},34.6,{"$f":"ROUND(L42 * (1 + VAT), 2)","v":39.79},null,null,null,"< 500V",null,0.39,{"$f":"ROUND(S42 * (1 + VAT), 2)","v":0.45}]
["Genflex urban loads","GU",0,1,"GU01N",null,null,"> 1 MVA/MW",null,191.16,{"$f":"ROUND(J43 * (1 + VAT), 2)","v":219.83},86.15,{"$f":"ROUND(L43 * (1 + VAT), 2)","v":99.07},null,null,null,"≥ 500V & < 66kV",null,0.38,{"$f":"ROUND(S43 * (1 + VAT), 2)","v":0.44}]
["Genflex urban loads","GU",0,1,{"$f":"B44&C44&D44&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"Key customers or Transmission connected generators",null,3745.97,{"$f":"ROUND(J44 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(L44 * (1 + VAT), 2)","v":137.59},null,null,null,"≥ 66kV & ≤ 132kV",null,0.36,{"$f":"ROUND(S44 * (1 + VAT), 2)","v":0.41}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 132kV / Transmission connected",null,0.34,{"$f":"ROUND(S45 * (1 + VAT), 2)","v":0.39},null,null,null,null,{"$f":"'Loss Factors'!R10","v":0}]
[null,null,null,null,null,null,null,"Applicable to loads"]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs",null,null,null,null,null,null,"Reactive energy charge  [c/kVArh] (loads)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High season",null,"Low season"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl",null,null,null,null,null,13.47,{"$f":"ROUND(Q50 * (1 + VAT), 2)","v":15.49},0,{"$f":"ROUND(S50 * (1 + VAT), 2)","v":0}]
["Genflex urban loads","GU",0,1,{"$f":"B51&C51&D51&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,7.45,{"$f":"ROUND(H51 * (1 + VAT), 2)","v":8.57},3.31,{"$f":"ROUND(J51 * (1 + VAT), 2)","v":3.81}]
[]
[]
[null,null,null,null,null,null,null,"Losses charge for generators"]
[null,null,null,null,null,null,null,"Distribution connected generators",null,null,null,null,"Transmission connected generators"]
[null,null,null,null,null,null,null,"Formula",null,null,null,null,"Formula"]
[null,null,null,null,null,null,null,"Distribution = - ((Energy produced x WEPS rate excluding losses) x (Distribution loss factor x Transmission loss factor-1)) in each TOU period",null,null,null,null,"Transmission = (Energy produced x WEPS rate excluding losses) x (Transmission loss factor-1/Transmission loss factor) in each TOU period"]
[null,null,null,null,null,null,null,"Transmission loss factors for Distribution connected",null,null,"Distribution loss factors",null,"Generator loss factor"]
[null,null,null,null,null,null,null,{"$f":"'Loss Factors'!R5","v":"Distance from\nJohannesburg"},null,{"$f":"'Loss Factors'!S5","v":"Zone"},{"$f":"'Loss Factors'!N5","v":"Voltage"},null,{"$f":"TUoS!I38","v":"Cape"},null,{"$f":"TUoS!J38","v":0.97099999999999997}]
[null,null,null,null,null,null,null,{"$f":"'Loss Factors'!R6","v":"≤ 300km"},null,{"$f":"'Loss Factors'!T6","v":1.0106999999999999},{"$f":"'Loss Factors'!N6","v":"< 500V"},{"$f":"'Loss Factors'!O6","v":1.1111},{"$f":"TUoS!I39","v":"Karoo"},null,{"$f":"TUoS!J39","v":0.995}]
[null,null,null,null,null,null,null,{"$f":"'Loss Factors'!R7","v":"> 300km & ≤ 600km"},null,{"$f":"'Loss Factors'!T7","v":1.0207999999999999},{"$f":"'Loss Factors'!N7","v":"≥ 500V & < 66kV"},{"$f":"'Loss Factors'!O7","v":1.0956999999999999},{"$f":"TUoS!I40","v":"Kwazulu-Natal"},null,{"$f":"TUoS!J40","v":1.004}]
[null,null,null,null,null,null,null,{"$f":"'Loss Factors'!R8","v":"> 600km & ≤ 900km"},null,{"$f":"'Loss Factors'!T8","v":1.0309999999999999},{"$f":"'Loss Factors'!N8","v":"≥ 66kV & ≤ 132kV"},{"$f":"'Loss Factors'!O8","v":1.0610999999999999},{"$f":"TUoS!I41","v":"Vaal"},null,{"$f":"TUoS!J41","v":1.02}]
[null,null,null,null,null,null,null,{"$f":"'Loss Factors'!R9","v":"> 900km"},null,{"$f":"'Loss Factors'!T9","v":1.0412999999999999},{"$f":"'Loss Factors'!N9","v":"> 132kV/Transmission connected"},{"$f":"'Loss Factors'!O9","v":1},{"$f":"TUoS!I42","v":"Waterberg"},null,{"$f":"TUoS!J42","v":1.0229999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TUoS!I43","v":"Mpumalanga"},null,{"$f":"TUoS!J43","v":1.0209999999999999}]

{"sheet":"Miniflex inc","index":10,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,17,5,18],[5,19,5,20],[7,7,10,7],[1,6,1,16],[1,17,1,18],[1,19,1,22],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[3,21,5,22],[25,9,26,10],[25,11,26,12],[5,11,5,12],[5,13,5,14],[5,15,5,16],[11,7,14,7],[15,7,18,7],[19,7,22,7],[27,7,27,8],[25,7,25,8],[35,7,37,8],[27,15,27,16],[27,17,27,18],[27,20,27,22],[28,7,28,8],[37,9,37,10],[37,14,37,15],[37,16,37,17],[30,7,30,8],[31,7,31,8],[32,7,32,8],[35,9,36,10],[35,14,36,17],[29,7,29,8]]}
[null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Non-municipal",null,null,null,null,null,"Miniflex tariff",null,null,null,null,null,null,null,null,null,null,null,null,"Non-local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Network capacity charge [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"≤ 300km","< 500V",292.89,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":336.82},89.11,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":102.48},48.66,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":55.96},95.91,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":110.3},66.180000000000007,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":76.11},42.19,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":48.52},25,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":28.75}]
["Miniflex","Mi",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi02N"},null,null,null,"≥ 500V & < 66kV",288.29000000000002,331.53,87.34,100.44,47.43,54.54,94.03,108.13,64.73,74.44,41.06,47.22,22.91,26.35]
["Miniflex","Mi",0,3,"Mi03N",null,null,null,"≥ 66kV & ≤ 132kV",279.16000000000003,321.02999999999997,84.56,97.24,45.93,52.82,91.08,104.74,62.67,72.069999999999993,39.770000000000003,45.74,12.87,14.8]
["Miniflex","Mi",0,4,"Mi04N",null,null,null,"> 132kV*",263.11,302.58,79.7,91.66,43.29,49.78,85.85,98.73,59.07,67.930000000000007,37.479999999999997,43.1,9.3800000000000008,10.79]
["Miniflex","Mi",1,1,"Mi11N",null,null,"> 300km and \n≤ 600km","< 500V",295.27999999999997,339.57,89.47,102.89,48.57,55.86,96.33,110.78,66.319999999999993,76.27,42.07,48.38,25.06,28.82]
["Miniflex","Mi",1,2,"Mi12N",null,null,null,"≥ 500V & < 66kV",291.17,334.85,88.2,101.43,47.9,55.09,94.99,109.24,65.37,75.180000000000007,41.47,47.69,22.98,26.43]
["Miniflex","Mi",1,3,"Mi13N",null,null,null,"≥ 66kV & ≤ 132kV",281.91000000000003,324.2,85.39,98.2,46.36,53.31,91.96,105.75,63.29,72.78,40.15,46.17,12.92,14.86]
["Miniflex","Mi",1,4,"Mi14N",null,null,null,"> 132kV*",265.74,305.60000000000002,80.510000000000005,92.59,43.69,50.24,86.67,99.67,59.65,68.599999999999994,37.83,43.5,9.48,10.9]
["Miniflex","Mi",2,1,"Mi21N",null,null,"> 600km and \n≤ 900km","< 500V",298.22000000000003,342.95,90.34,103.89,49.04,56.4,97.29,111.88,66.959999999999994,77,42.46,48.83,25.18,28.96]
["Miniflex","Mi",2,2,"Mi22N",null,null,null,"≥ 500V & < 66kV",294.10000000000002,338.22,89.1,102.47,48.38,55.64,95.93,110.32,66.03,75.930000000000007,41.89,48.17,23.05,26.51]
["Miniflex","Mi",2,3,"Mi23N",null,null,null,"≥ 66kV & ≤ 132kV",284.77999999999997,327.5,86.27,99.21,46.84,53.87,92.89,106.82,63.94,73.53,40.56,46.64,13,14.95]
["Miniflex","Mi",2,4,"Mi24N",null,null,null,"> 132kV*",268.42,308.68,81.3,93.5,44.17,50.8,87.56,100.69,60.25,69.290000000000006,38.24,43.98,9.6199999999999992,11.06]
["Miniflex","Mi",3,1,"Mi31N",null,null,"> 900km","< 500V",301.22000000000003,346.4,91.28,104.97,49.55,56.98,98.27,113.01,67.62,77.760000000000005,42.92,49.36,25.2,28.98]
["Miniflex","Mi",3,2,"Mi32N",null,null,null,"≥ 500V & < 66kV",297.02,341.57,89.97,103.47,48.84,56.17,96.87,111.4,66.66,76.66,42.3,48.65,23.13,26.6]
["Miniflex","Mi",3,3,"Mi33N",null,null,null,"≥ 66kV & ≤ 132kV",287.64,330.79,87.13,100.2,47.31,54.41,93.82,107.89,64.58,74.27,40.97,47.12,13.05,15.01]
["Miniflex","Mi",3,4,"Mi34N",null,null,null,"> 132kV*",271.02999999999997,311.68,82.14,94.46,44.63,51.32,88.47,101.74,60.91,70.05,38.659999999999997,44.46,9.68,11.13]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]        \n     [Peak & Standard]",null,null,"Urban low voltage subsidy charge [R/kVA/m]"]
["Miniflex","Mi",0,1,{"$f":"B29&C29&D29&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"≤ 100 kVA",null,13.6,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":15.64},2.99,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":3.44},null,"Voltage",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"> 100 kVA & ≤ 500 kVA",null,62.12,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":71.44},17.420000000000002,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":20.03},null,"< 500V",0.39,{"$f":"ROUND(P30 * (1 + VAT), 2)","v":0.45},15.47,{"$f":"ROUND(R30 * (1 + VAT), 2)","v":17.79},null,"< 500V",0,{"$f":"ROUND(V30 * (1 + VAT), 2)","v":0}]
["Miniflex","Mi",0,1,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"> 500 kVA & ≤ 1 MVA",null,191.16,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":219.83},34.6,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":39.79},null,"≥ 500V & < 66kV",0.38,{"$f":"ROUND(P31 * (1 + VAT), 2)","v":0.44},6.48,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":7.45},null,"≥ 500V & < 66kV",0,{"$f":"ROUND(V31 * (1 + VAT), 2)","v":0}]
["Miniflex","Mi",0,1,{"$f":"B32&C32&D32&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"> 1 MVA",null,191.16,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":219.83},86.15,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":99.07},null,"≥ 66kV & ≤ 132kV",0.36,{"$f":"ROUND(P32 * (1 + VAT), 2)","v":0.41},2.2599999999999998,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":2.6},null,"≥ 66kV & ≤ 132kV",13.45,{"$f":"ROUND(V32 * (1 + VAT), 2)","v":15.47}]
["Miniflex","Mi",0,1,{"$f":"B33&C33&D33&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"Key customers",null,3745.97,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":137.59},null,"> 132kV*",0.34,{"$f":"ROUND(P33 * (1 + VAT), 2)","v":0.39},0,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":0},null,"> 132kV*",13.45,{"$f":"ROUND(V33 * (1 + VAT), 2)","v":15.47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected",null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs",null,null,null,null,"Reactive energy charge  [c/kVArh]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High season",null,"Low season"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl",null,null,null,null,"VAT incl",null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,7.45,{"$f":"ROUND(H40 * (1 + VAT), 2)","v":8.57},3.31,{"$f":"ROUND(J40 * (1 + VAT), 2)","v":3.81},null,null,null,5.87,{"$f":"ROUND(O40 * (1 + VAT), 2)","v":6.75},0,{"$f":"ROUND(Q40 * (1 + VAT), 2)","v":0}]
[]
["Miniflex","Mi",0,1,{"$f":"B42&C42&D42&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"}]
["Miniflex","Mi",1,2,{"$f":"B43&C43&D43&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi12N"}]
["Miniflex","Mi",2,3,"Mi23N"]
["Miniflex","Mi",3,4,"Mi34N"]

{"sheet":"Miniflex Munic inc ","index":11,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,21,5,22],[7,7,10,7],[1,6,1,16],[1,17,1,18],[1,19,1,22],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[27,17,27,18],[27,20,27,22],[28,7,28,8],[29,7,29,8],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,9,26,10],[25,11,26,12],[25,7,25,8],[37,11,37,12],[37,13,37,14],[27,7,27,8],[27,15,27,16],[30,7,30,8],[31,7,31,8],[32,7,32,8],[35,11,36,14],[35,7,37,8]]}
[null,null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,null,"Miniflex tariff",null,null,null,null,null,null,null,null,null,null,null,null,"Local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Network capacity charge [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,"≤ 300km","< 500V",300.18,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":345.21},91.34,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":105.04},49.84,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":57.32},98.28,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":113.02},67.83,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":78},43.23,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":49.71},25.03,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":28.78}]
["Miniflex","Mi",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi02Y"},null,null,null,"≥ 500V & < 66kV",295.45,339.77,89.52,102.95,48.61,55.9,96.38,110.84,66.33,76.28,42.09,48.4,22.93,26.37]
["Miniflex","Mi",0,3,"Mi03Y",null,null,null,"≥ 66kV & ≤ 132kV",286.13,329.05,86.67,99.67,47.07,54.13,93.34,107.34,64.25,73.89,40.75,46.86,12.88,14.81]
["Miniflex","Mi",0,4,"Mi04Y",null,null,null,"> 132kV*",269.66000000000003,310.11,81.69,93.94,44.36,51.01,87.96,101.15,60.54,69.62,38.409999999999997,44.17,9.4,10.81]
["Miniflex","Mi",1,1,"Mi11Y",null,null,"> 300km and \n≤ 600km","< 500V",302.63,348.02,91.68,105.43,49.78,57.25,98.72,113.53,67.97,78.17,43.11,49.58,25.08,28.84]
["Miniflex","Mi",1,2,"Mi12Y",null,null,null,"≥ 500V & < 66kV",298.39999999999998,343.16,90.4,103.96,49.09,56.45,97.35,111.95,67,77.05,42.5,48.88,23.01,26.46]
["Miniflex","Mi",1,3,"Mi13Y",null,null,null,"≥ 66kV & ≤ 132kV",288.93,332.27,87.52,100.65,47.52,54.65,94.25,108.39,64.86,74.59,41.14,47.31,12.95,14.89]
["Miniflex","Mi",1,4,"Mi14Y",null,null,null,"> 132kV*",272.35000000000002,313.2,82.52,94.9,44.8,51.52,88.83,102.15,61.15,70.319999999999993,38.79,44.61,9.49,10.91]
["Miniflex","Mi",2,1,"Mi21Y",null,null,"> 600km and \n≤ 900km","< 500V",305.64999999999998,351.5,92.6,106.49,50.27,57.81,99.7,114.66,68.63,78.92,43.54,50.07,25.21,28.99]
["Miniflex","Mi",2,2,"Mi22Y",null,null,null,"≥ 500V & < 66kV",301.41000000000003,346.62,91.3,105,49.58,57.02,98.34,113.09,67.64,77.790000000000006,42.93,49.37,23.07,26.53]
["Miniflex","Mi",2,3,"Mi23Y",null,null,null,"≥ 66kV & ≤ 132kV",291.87,335.65,88.4,101.66,48,55.2,95.18,109.46,65.510000000000005,75.34,41.55,47.78,13.01,14.96]
["Miniflex","Mi",2,4,"Mi24Y",null,null,null,"> 132kV*",275.08,316.33999999999997,83.34,95.84,45.25,52.04,89.74,103.2,61.76,71.02,39.18,45.06,9.6199999999999992,11.06]
["Miniflex","Mi",3,1,"Mi31Y",null,null,"> 900km","< 500V",308.72000000000003,355.03,93.53,107.56,50.79,58.41,100.71,115.82,69.31,79.709999999999994,43.98,50.58,25.23,29.01]
["Miniflex","Mi",3,2,"Mi32Y",null,null,null,"≥ 500V & < 66kV",304.42,350.08,92.21,106.04,50.08,57.59,99.29,114.18,68.34,78.59,43.34,49.84,23.17,26.65]
["Miniflex","Mi",3,3,"Mi33Y",null,null,null,"≥ 66kV & ≤ 132kV",294.81,339.03,89.31,102.71,48.5,55.78,96.16,110.58,66.17,76.099999999999994,41.98,48.28,13.05,15.01]
["Miniflex","Mi",3,4,"Mi34Y",null,null,null,"> 132kV*",277.79000000000002,319.45999999999998,84.19,96.82,45.75,52.61,90.66,104.26,62.41,71.77,39.61,45.55,9.69,11.14]
[null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]        \n     [Peak & Standard]",null,null,"Urban low voltage subsidy charge [R/kVA/m]"]
["Miniflex","Mi",0,1,{"$f":"B29&C29&D29&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,"≤ 100 kVA",null,13.54,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":15.57},2.97,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":3.42},null,"Voltage",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,"> 100 kVA & ≤ 500 kVA",null,61.89,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":71.17},17.34,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":19.940000000000001},null,"< 500V",0.39,{"$f":"ROUND(P30 * (1 + VAT), 2)","v":0.45},15.48,{"$f":"ROUND(R30 * (1 + VAT), 2)","v":17.8},null,"< 500V",0,{"$f":"ROUND(V30 * (1 + VAT), 2)","v":0}]
["Miniflex","Mi",0,1,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,"> 500 kVA & ≤ 1 MVA",null,190.47,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":219.04},34.479999999999997,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":39.65},null,"≥ 500V & < 66kV",0.38,{"$f":"ROUND(P31 * (1 + VAT), 2)","v":0.44},6.5,{"$f":"ROUND(R31 * (1 + VAT), 2)","v":7.48},null,"≥ 500V & < 66kV",0,{"$f":"ROUND(V31 * (1 + VAT), 2)","v":0}]
["Miniflex","Mi",0,1,{"$f":"B32&C32&D32&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,"> 1 MVA",null,190.47,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":219.04},85.86,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":98.74},null,"≥ 66kV & ≤ 132kV",0.35,{"$f":"ROUND(P32 * (1 + VAT), 2)","v":0.4},2.25,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":2.59},null,"≥ 66kV & ≤ 132kV",13.39,{"$f":"ROUND(V32 * (1 + VAT), 2)","v":15.4}]
["Miniflex","Mi",0,1,{"$f":"B33&C33&D33&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,"Key customers",null,3732.51,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":4292.3900000000003},119.2,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":137.08000000000001},null,"> 132kV*",0.33,{"$f":"ROUND(P33 * (1 + VAT), 2)","v":0.38},0,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":0},null,"> 132kV*",13.39,{"$f":"ROUND(V33 * (1 + VAT), 2)","v":15.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected",null,null,null,null,null,"* 132 kV or Transmission connected"]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,null,null,"Reactive energy charge  [c/kVArh]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"High season",null,"Low season"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,null,null,"VAT incl",null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B40&C40&D40&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"},null,null,7.42,{"$f":"ROUND(H40 * (1 + VAT), 2)","v":8.5299999999999994},null,null,5.87,{"$f":"ROUND(L40 * (1 + VAT), 2)","v":6.75},0,{"$f":"ROUND(N40 * (1 + VAT), 2)","v":0}]
[]
["Miniflex","Mi",0,1,{"$f":"B42&C42&D42&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01Y"}]
["Miniflex","Mi",1,2,{"$f":"B43&C43&D43&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi12Y"}]
["Miniflex","Mi",2,3,"Mi23Y"]
["Miniflex","Mi",3,4,"Mi34Y"]

{"sheet":"Businessrate inc","index":12,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,15,1,18],[3,9,4,10],[3,11,4,12],[3,13,4,14],[3,15,4,16],[3,17,3,18],[8,7,8,8],[9,7,9,8],[10,7,10,8],[3,25,4,26],[3,27,4,28],[4,17,4,18],[5,25,5,26],[5,27,5,28],[7,7,7,8]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,null,"Businessrate tariffs",null,null,null,null,null,null,null,"Non-local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge [c/kWh]",null,"Ancillary service charge \n[c/kWh]",null,"Network demand charge \n [c/kWh]",null,"Network capacity charge\n [R/POD/day]",null,"Service and administration charge  \n[R/POD/day]",null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] payable by non-local authority tariffs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All seasons",null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Businessrate 1","B1",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"B101N"},null,null,"Businessrate 1",null,100.28,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":115.32},0.39,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":0.45},14.16,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":16.28},20.329999999999998,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":23.38},17.559999999999999,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":20.190000000000001},null,null,null,null,null,null,0,{"$f":"ROUND(Z8 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(AB8 * (1 + VAT), 2)","v":0}]
["Businessrate 2","B2",0,1,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"B201N"},null,null,"Businessrate 2",null,100.28,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":115.32},0.39,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":0.45},14.16,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":16.28},34.25,{"$f":"ROUND(P9 * (1 + VAT), 2)","v":39.39},17.559999999999999,{"$f":"ROUND(R9 * (1 + VAT), 2)","v":20.190000000000001},null,null,null,null,null,null,{"$f":"Z8","v":0},{"$f":"ROUND(Z9 * (1 + VAT), 2)","v":0},{"$f":"AB8","v":0},{"$f":"ROUND(AB9 * (1 + VAT), 2)","v":0}]
["Businessrate 3","B3",0,1,"B301N",null,null,"Businessrate 3",null,100.28,{"$f":"ROUND(J10 * (1 + VAT), 2)","v":115.32},0.39,{"$f":"ROUND(L10 * (1 + VAT), 2)","v":0.45},14.16,{"$f":"ROUND(N10 * (1 + VAT), 2)","v":16.28},59.18,{"$f":"ROUND(P10 * (1 + VAT), 2)","v":68.06},17.559999999999999,{"$f":"ROUND(R10 * (1 + VAT), 2)","v":20.190000000000001},null,null,null,null,null,null,{"$f":"Z8","v":0},{"$f":"ROUND(Z10 * (1 + VAT), 2)","v":0},{"$f":"AB8","v":0},{"$f":"ROUND(AB10 * (1 + VAT), 2)","v":0}]
["Businessrate 4","B4",0,1,"B401N",null,null,"Businessrate 4",null,269.86,{"$f":"ROUND(J11 * (1 + VAT), 2)","v":310.33999999999997},0.39,{"$f":"ROUND(L11 * (1 + VAT), 2)","v":0.45},14.16,{"$f":"ROUND(N11 * (1 + VAT), 2)","v":16.28},null,null,null,null,null,null,null,null,null,null,{"$f":"Z9","v":0},{"$f":"ROUND(Z11 * (1 + VAT), 2)","v":0},{"$f":"AB9","v":0},{"$f":"ROUND(AB11 * (1 + VAT), 2)","v":0}]

{"sheet":"Businessrate Munic inc","index":13,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,15,1,18],[3,9,4,10],[3,11,4,12],[3,13,4,14],[3,15,4,16],[3,17,3,18],[8,7,8,8],[9,7,9,8],[10,7,10,8],[3,25,4,26],[3,27,4,28],[4,17,4,18],[5,25,5,26],[5,27,5,28],[7,7,7,8]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,null,null,"Businessrate tariffs",null,null,null,null,null,null,null,"Local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge [c/kWh]",null,"Ancillary service charge \n[c/kWh]",null,"Network demand charge \n [c/kWh]",null,"Network capacity charge\n [R/POD/day]",null,"Service and administration charge  \n[R/POD/day]",null,null,null,null,null,null,null,"Electrification and rural network subsidy charge  [c/kWh]",null,"Affordability subsidy charge [c/kWh] payable by non-local authority tariffs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All seasons",null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Businessrate 1","B1",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"B101Y"},null,null,"Businessrate 1",null,102.78,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":118.2},0.39,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":0.45},14.24,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":16.38},20.43,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":23.49},17.489999999999998,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":20.11},null,null,null,null,null,null,0,{"$f":"ROUND(Z8 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(AB8 * (1 + VAT), 2)","v":0}]
["Businessrate 2","B2",0,1,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"B201Y"},null,null,"Businessrate 2",null,102.78,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":118.2},0.39,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":0.45},14.24,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":16.38},34.450000000000003,{"$f":"ROUND(P9 * (1 + VAT), 2)","v":39.619999999999997},17.489999999999998,{"$f":"ROUND(R9 * (1 + VAT), 2)","v":20.11},null,null,null,null,null,null,{"$f":"Z8","v":0},{"$f":"ROUND(Z9 * (1 + VAT), 2)","v":0},{"$f":"AB8","v":0},{"$f":"ROUND(AB9 * (1 + VAT), 2)","v":0}]
["Businessrate 3","B3",0,1,"B301Y",null,null,"Businessrate 3",null,102.78,{"$f":"ROUND(J10 * (1 + VAT), 2)","v":118.2},0.39,{"$f":"ROUND(L10 * (1 + VAT), 2)","v":0.45},14.24,{"$f":"ROUND(N10 * (1 + VAT), 2)","v":16.38},59.53,{"$f":"ROUND(P10 * (1 + VAT), 2)","v":68.459999999999994},17.489999999999998,{"$f":"ROUND(R10 * (1 + VAT), 2)","v":20.11},null,null,null,null,null,null,{"$f":"Z8","v":0},{"$f":"ROUND(Z10 * (1 + VAT), 2)","v":0},{"$f":"AB8","v":0},{"$f":"ROUND(AB10 * (1 + VAT), 2)","v":0}]
["Businessrate 4","B4",0,1,"B401Y",null,null,"Businessrate 4",null,276.57,{"$f":"ROUND(J11 * (1 + VAT), 2)","v":318.06},0.39,{"$f":"ROUND(L11 * (1 + VAT), 2)","v":0.45},14.24,{"$f":"ROUND(N11 * (1 + VAT), 2)","v":16.38},null,null,null,null,null,null,null,null,null,null,{"$f":"Z9","v":0},{"$f":"ROUND(Z11 * (1 + VAT), 2)","v":0},{"$f":"AB9","v":0},{"$f":"ROUND(AB11 * (1 + VAT), 2)","v":0}]

{"sheet":"Public Lighting inc","index":14,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,8,8,9],[8,12,8,13],[10,7,11,9],[10,10,10,11],[1,7,1,13],[3,10,3,11],[3,12,3,13],[5,7,6,7],[5,8,5,9],[6,8,6,9]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,null,"Public Lighting tariffs                                                    Non-local authority"]
[]
[null,null,null,null,null,null,null,null,null,null,"All Night ",null,"24 Hours "]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"","VAT incl","","VAT incl"]
["Public lighting 24 hours","Pu",0,1,{"$f":"B6&C6&D6&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Pu01N"},null,null,"Public Lighting","Energy charge [c/kWh]",null,79.8,{"$f":"ROUND(K6 * (1 + VAT), 2)","v":91.77},106.85,{"$f":"ROUND(M6 * (1 + VAT), 2)","v":122.88}]
["Public lighting All Night","Pa",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Pa01N"},null,null,null,"Energy charge [R/100W/month]",null,24.97,{"$f":"ROUND(K7 * (1 + VAT), 2)","v":28.72},71.97,{"$f":"ROUND(M7 * (1 + VAT), 2)","v":82.77}]
[]
["Public lighting Urban fixed","Pt",0,1,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Pt01N"},null,null,"Public Lighting - Urban Fixed","Fixed charge [R/POD/day]",null,5.25,{"$f":"ROUND(K9 * (1 + VAT), 2)","v":6.04}]
[]
[null,null,null,null,null,null,null,"Maintenance charges",null,null,"R/month"]
[null,null,null,null,null,null,null,null,null,null,"","VAT incl"]
["Public Lighting - Maintenance charge - per lumanaire","Plu",0,1,{"$f":"B13&C13&D13&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Plu01N"},null,null,null,null,"Per lumanaire",42.32,{"$f":"ROUND(K13 * (1 + VAT), 2)","v":48.67}]
["Public Lighting - Maintenance charge - per high-mast lumanaire","Plhm",0,1,{"$f":"B14&C14&D14&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Plhm01N"},null,null,null,null,"Per high-mast lumanaire",985.07,{"$f":"ROUND(K14 * (1 + VAT), 2)","v":1132.83}]

{"sheet":"Public Lighting Munic inc","index":15,"n_rows":14,"n_cols":29,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,8,8,9],[8,12,8,13],[10,7,11,9],[10,10,10,11],[1,7,1,13],[3,10,3,11],[3,12,3,13],[5,7,6,7],[5,8,5,9],[6,8,6,9]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Municipal",null,null,null,null,null,null,"Public Lighting tariffs                                           Local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,null,"All Night ",null,"24 Hours "]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"","VAT incl","","VAT incl"]
["Public lighting 24 hours","Pu",0,1,{"$f":"B6&C6&D6&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municipal\",\"Y\",\"error\"))","v":"Pu01Y"},null,null,"Public Lighting","Energy charge [c/kWh]",null,82.96,{"$f":"ROUND(K6 * (1 + VAT), 2)","v":95.4},111.09,{"$f":"ROUND(M6 * (1 + VAT), 2)","v":127.75}]
["Public lighting All Night","Pa",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municipal\",\"Y\",\"error\"))","v":"Pa01Y"},null,null,null,"Energy charge [R/100W/month]",null,25.34,{"$f":"ROUND(K7 * (1 + VAT), 2)","v":29.14},73.03,{"$f":"ROUND(M7 * (1 + VAT), 2)","v":83.98}]
[]
["Public lighting Urban fixed","Pt",0,1,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municipal\",\"Y\",\"error\"))","v":"Pt01Y"},null,null,"Public Lighting - Urban Fixed ","Fixed charge [R/POD/day]",null,5.4548981316184859,{"$f":"ROUND(K9 * (1 + VAT), 2)","v":6.27}]
[]
[null,null,null,null,null,null,null,"Maintenance charges",null,null,"R/month"]
[null,null,null,null,null,null,null,null,null,null,"","VAT incl"]
["Public Lighting - Maintenance charge - per lumanaire","Plu",0,1,{"$f":"B13&C13&D13&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municipal\",\"Y\",\"error\"))","v":"Plu01Y"},null,null,null,null,"Per lumanaire",43.775827999999997,{"$f":"ROUND(K13 * (1 + VAT), 2)","v":50.34}]
["Public Lighting - Maintenance charge - per high-mast lumanaire","Plhm",0,1,{"$f":"B14&C14&D14&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municipal\",\"Y\",\"error\"))","v":"Plhm01Y"},null,null,null,null,"Per high-mast lumanaire",1022.35,{"$f":"ROUND(K14 * (1 + VAT), 2)","v":1175.7}]

{"sheet":"Homepower inc","index":16,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,9,11,10],[11,11,11,12],[13,7,13,8],[4,13,4,14],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[4,9,4,12]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,null,"Homepower tariffs",null,null,null,null,null,null,"Non-local authority"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge\n[c/kWh]",null,null,null,"Network capacity charge \n[R/POD/day]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"Block 1   \n[>0 - 600 kWh]","VAT incl","Block 2   \n[>600 kWh]","VAT incl",null,"VAT incl"]
["Homepower 1","H1",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"H101N"},null,null,"Homepower 1",null,117.53,{"$f":"ROUND(J7 * (1 + VAT), 2)","v":135.16},185.58,{"$f":"ROUND(L7 * (1 + VAT), 2)","v":213.42},5.03,{"$f":"ROUND(N7 * (1 + VAT), 2)","v":5.78}]
["Homepower 2","H2",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"H201N"},null,null,"Homepower 2",null,117.53,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":135.16},180.94,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":208.08},9.43,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":10.84}]
["Homepower 3","H3",0,1,"H301N",null,null,"Homepower 3",null,117.53,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":135.16},180.94,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":208.08},19.48,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":22.4}]
["Homepower 4","H4",0,1,"H401N",null,null,"Homepower 4",null,117.53,{"$f":"ROUND(J10 * (1 + VAT), 2)","v":135.16},189,{"$f":"ROUND(L10 * (1 + VAT), 2)","v":217.35},3.07,{"$f":"ROUND(N10 * (1 + VAT), 2)","v":3.53}]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge  \n[c/kWh]",null,"Network capacity charge [R/kVA]"]
[null,null,null,null,null,null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Homepower Bulk < 500V","HB",0,1,{"$f":"B14&C14&D14&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"HB01N"},null,null,"Homepower Bulk  \n",null,154.31,{"$f":"ROUND(J14 * (1 + VAT), 2)","v":177.46},31.93,{"$f":"ROUND(L14 * (1 + VAT), 2)","v":36.72}]
[null,null,null,null,null,null,null,"* The Network capacity charge is based on the NMD or on the maximum demand if measured."]

{"sheet":"Homepower Munic inc","index":17,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,7,7,8],[8,7,8,8],[1,13,1,14],[3,9,3,10],[3,11,3,12],[3,13,3,14],[5,7,5,8],[6,7,6,8]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,null,null,"Homepower tariffs",null,null,null,null,null,"Local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge\n[c/kWh]",null,"Energy charge\n[c/kWh]",null,"Network capacity charge [R/POD/day]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"Block 1   \n[>0 - 600 kWh]","VAT incl","Block 2   \n[>600 kWh]","VAT incl",null,"VAT incl"]
["Homepower 1","H1",0,1,{"$f":"B6&C6&D6&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"H101Y"},null,null,"Homepower 1",null,117.65,{"$f":"ROUND(J6 * (1 + VAT), 2)","v":135.30000000000001},185.77,{"$f":"ROUND(L6 * (1 + VAT), 2)","v":213.64},5.03,{"$f":"ROUND(N6 * (1 + VAT), 2)","v":5.78}]
["Homepower 2","H2",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"H201Y"},null,null,"Homepower 2",null,117.65,{"$f":"ROUND(J7 * (1 + VAT), 2)","v":135.30000000000001},181.11,{"$f":"ROUND(L7 * (1 + VAT), 2)","v":208.28},9.44,{"$f":"ROUND(N7 * (1 + VAT), 2)","v":10.86}]
["Homepower 3","H3",0,1,"H301Y",null,null,"Homepower 3",null,117.65,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":135.30000000000001},181.11,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":208.28},19.5,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":22.43}]
["Homepower 4","H4",0,1,"H401Y",null,null,"Homepower 4",null,117.65,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":135.30000000000001},189.19,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":217.57},3.08,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":3.54}]

{"sheet":"Homelight inc","index":18,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,7,1,10],[11,7,11,8],[12,7,12,8],[3,7,4,8],[3,9,3,10],[5,7,5,8],[6,7,6,8],[9,7,10,8],[9,9,9,10]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,null,"Homelight tariffs  \nNon-local authority"]
[]
[null,null,null,null,null,null,null,"Homelight 60A",null,"Energy charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["Homelight 1 60A","HL16",0,1,{"$f":"B6&C6&D6&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"HL1601N"},null,null,"Block 1   [> 0 - 600 kWh]",null,111.19,{"$f":"ROUND(J6 * (1 + VAT), 2)","v":127.87}]
["Homelight 2 60A","HL26",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"HL2601N"},null,null,"Block 2   [>600 kWh]",null,189,{"$f":"ROUND(J7 * (1 + VAT), 2)","v":217.35}]
[]
[]
[null,null,null,null,null,null,null,"Homelight 20A",null,"Energy charge [c/kWh]"]
[null,null,null,null,null,null,null,null,null,null,"VAT incl"]
["Homelight 1 20A","HL12",0,1,{"$f":"B12&C12&D12&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"HL1201N"},null,null,"Block 1   [> 0 - 350 kWh]",null,98.24,{"$f":"ROUND(J12 * (1 + VAT), 2)","v":112.98}]
["Homelight 2 20A","HL22",0,1,{"$f":"B13&C13&D13&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"HL2201N"},null,null,"Block 2   [>350 kWh]",null,111.32,{"$f":"ROUND(J13 * (1 + VAT), 2)","v":128.02000000000001}]

{"sheet":"Nightsave Rural inc","index":19,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,6,1,16],[1,17,1,18],[3,9,3,12],[3,13,3,16],[3,17,5,18],[4,7,6,7],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[29,15,29,16],[29,17,29,18],[30,7,30,8],[7,7,10,7],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,26,8],[25,9,26,10],[25,11,26,12],[31,7,31,8],[32,7,32,8],[27,7,27,8],[28,7,28,8],[29,7,29,8]]}
[null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Non-municipal",null,null,null,null,null,"Nightsave Rural tariff",null,null,null,null,null,null,null,null,null,null,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,"Energy demand charges [R/kVA/m]",null,null,null,"Network capacity charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl","","VAT incl",null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01N"},null,null,"≤ 300km","< 500V",73.97,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":85.07},57.48,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":66.099999999999994},247.85,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":285.02999999999997},131.18,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":150.86000000000001},12.53,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":14.41}]
["Nightsave Rural","NR",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR02N"},null,null,null,"≥ 500V & ≤ 22kV",73.099999999999994,84.07,56.83,65.349999999999994,240.17,276.2,126.52,145.5,11.51,13.24]
["Nightsave Rural","NR",null,null,"NRN",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",null,null,"NRN",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",1,1,"NR11N",null,null,"> 300km and \n≤ 600km","< 500V",74.7,85.91,58.06,66.77,250.84,288.47000000000003,133,152.94999999999999,12.56,14.44]
["Nightsave Rural","NR",1,2,"NR12N",null,null,null,"≥ 500V & ≤ 22kV",73.849999999999994,84.93,57.4,66.010000000000005,243.1,279.57,128.28,147.52000000000001,11.56,13.29]
["Nightsave Rural","NR",null,null,"NRN",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",null,null,"NRN",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",2,1,"NR21N",null,null,"> 600km and \n≤ 900km","< 500V",75.45,86.77,58.62,67.41,253.85,291.93,134.79,155.01,12.68,14.58]
["Nightsave Rural","NR",2,2,"NR22N",null,null,null,"≥ 500V & ≤ 22kV",74.58,85.77,57.98,66.680000000000007,246.02,282.92,130.05000000000001,149.56,11.64,13.39]
["Nightsave Rural","NR",null,null,"NRN",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",null,null,"NRN",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",3,1,"NR31N",null,null,"> 900km","< 500V",76.2,87.63,59.21,68.09,256.93,{"$f":"ROUND(N20 * (1 + VAT), 2)","v":295.47000000000003},136.65,{"$f":"ROUND(P20 * (1 + VAT), 2)","v":157.15},12.71,14.62]
["Nightsave Rural","NR",3,2,"NR32N",null,null,null,"≥ 500V & ≤ 22kV",75.3,86.6,58.54,67.319999999999993,249.02,286.37,131.87,151.65,11.66,13.41]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  \n[R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,{"$f":"B29&C29&D29&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01N"},null,null,"≤ 100 kVA",null,17.23,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":19.809999999999999},4.8899999999999997,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":5.62}]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"> 100 kVA & ≤ 500 kVA",null,58.75,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":67.56},27.24,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":31.33},null,null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]  in all time-of-use periods"]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"> 500 kVA & ≤ 1 MVA",null,180.75,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":207.86},41.81,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":48.08},null,"Voltage",null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"> 1 MVA",null,180.75,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":207.86},77.58,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":89.22},null,"< 500V",0.39,{"$f":"ROUND(P32 * (1 + VAT), 2)","v":0.45},24.93,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":28.67}]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"Key customers",null,3542.53,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":4073.91},77.58,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":89.22},null,"≥ 500V & ≤ 22kV",0.39,{"$f":"ROUND(P33 * (1 + VAT), 2)","v":0.45},21.86,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":25.14}]
["Nightsave Rural","NR",0,2,"NR02N"]

{"sheet":"Nightsave Rural Munic inc ","index":20,"n_rows":33,"n_cols":33,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,6,1,16],[1,17,1,18],[3,9,3,12],[3,13,3,16],[3,17,5,18],[4,7,6,7],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[29,15,29,16],[29,17,29,18],[30,7,30,8],[7,7,10,7],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,26,8],[25,9,26,10],[25,11,26,12],[31,7,31,8],[32,7,32,8],[27,7,27,8],[28,7,28,8],[29,7,29,8]]}
[null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Municiple",null,null,null,null,null,"Nightsave Rural tariff",null,null,null,null,null,null,null,null,null,null,"Local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,"Energy demand charges [R/kVA/m]",null,null,null,"Network capacity charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]",null,"High demand season \n[Jun - Aug]",null,"Low demand season \n[Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl","","VAT incl",null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01Y"},null,null,"≤ 300km","< 500V",75.81,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":87.18},58.91,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":67.75},248.09,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":285.3},131.32,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":151.02000000000001},12.67,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":14.57}]
["Nightsave Rural","NR",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR02Y"},null,null,null,"≥ 500V & ≤ 22kV",74.92,86.16,58.25,66.989999999999995,240.41,276.47000000000003,126.63,145.62,11.63,13.37]
["Nightsave Rural","NR",null,null,"NRY",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",null,null,"NRY",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",1,1,"NR11Y",null,null,"> 300km and \n≤ 600km","< 500V",76.569999999999993,88.06,59.51,68.44,251.11,288.77999999999997,133.13,153.1,12.7,14.61]
["Nightsave Rural","NR",1,2,"NR12Y",null,null,null,"≥ 500V & ≤ 22kV",75.66,87.01,58.83,67.650000000000006,243.35,279.85000000000002,128.4,147.66,11.68,13.43]
["Nightsave Rural","NR",null,null,"NRY",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",null,null,"NRY",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",2,1,"NR21Y",null,null,"> 600km and \n≤ 900km","< 500V",77.31,88.91,60.08,69.09,254.11,292.23,134.91999999999999,155.16,12.82,14.74]
["Nightsave Rural","NR",2,2,"NR22Y",null,null,null,"≥ 500V & ≤ 22kV",76.41,87.87,59.41,68.319999999999993,246.28,283.22000000000003,130.18,149.71,11.75,13.51]
["Nightsave Rural","NR",null,null,"NRY",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",null,null,"NRY",null,null,null,null,0,null,0,null,0,0,0,0,0]
["Nightsave Rural","NR",3,1,"NR31Y",null,null,"> 900km","< 500V",78.09,89.8,60.67,69.77,257.19,295.77,136.78,157.30000000000001,12.84,14.77]
["Nightsave Rural","NR",3,2,"NR32Y",null,null,null,"≥ 500V & ≤ 22kV",77.16,88.73,59.98,68.98,249.28,286.67,132,151.80000000000001,11.76,13.52]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  \n[R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,{"$f":"B29&C29&D29&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01Y"},null,null,"≤ 100 kVA",null,17.170000000000002,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":19.75},4.87,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":5.6}]
["Nightsave Rural","NR",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01Y"},null,null,"> 100 kVA & ≤ 500 kVA",null,58.55,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":67.33},27.14,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":31.21},null,null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]  in all time-of-use periods"]
["Nightsave Rural","NR",0,1,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01Y"},null,null,"> 500 kVA & ≤ 1 MVA",null,180.12,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":207.14},41.65,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":47.9},null,"Voltage",null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,{"$f":"B32&C32&D32&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01Y"},null,null,"> 1 MVA",null,180.12,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":207.14},77.3,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":88.9},null,"< 500V",0.39,{"$f":"ROUND(P32 * (1 + VAT), 2)","v":0.45},25.21,{"$f":"ROUND(R32 * (1 + VAT), 2)","v":28.99}]
["Nightsave Rural","NR",0,1,{"$f":"B33&C33&D33&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NR01Y"},null,null,"Key customers",null,3529.79,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":4059.26},77.3,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":88.9},null,"≥ 500V & ≤ 22kV",0.39,{"$f":"ROUND(P33 * (1 + VAT), 2)","v":0.45},22.06,{"$f":"ROUND(R33 * (1 + VAT), 2)","v":25.37}]

{"sheet":"Ruraflex inc","index":21,"n_rows":34,"n_cols":32,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,20,5,21],[7,6,10,6],[1,5,1,15],[1,16,1,17],[1,18,1,21],[3,8,3,19],[4,6,6,6],[4,8,4,13],[4,14,4,19],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[28,6,28,7],[28,13,28,14],[11,6,14,6],[15,6,18,6],[19,6,22,6],[25,6,26,7],[25,8,26,9],[25,10,26,11],[25,15,25,16],[25,17,25,18],[26,13,26,14],[27,6,27,7],[27,13,27,14],[32,6,32,7],[29,6,29,7],[30,6,30,7],[30,13,30,16],[31,6,31,7],[31,13,31,14],[31,15,31,16]]}
[null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,"Ruraflex tariff",null,null,null,null,null,null,null,null,null,null,null,null,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Network capacity charges [R/kVA/m]"]
[null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Ruraflex","Ru",0,1,null,null,"≤ 300km","< 500V",303.27,{"$f":"ROUND(I8 * (1 + VAT), 2)","v":348.76},91.88,{"$f":"ROUND(K8 * (1 + VAT), 2)","v":105.66},49.9,{"$f":"ROUND(M8 * (1 + VAT), 2)","v":57.39},98.93,{"$f":"ROUND(O8 * (1 + VAT), 2)","v":113.77},68.08,{"$f":"ROUND(Q8 * (1 + VAT), 2)","v":78.290000000000006},43.19,{"$f":"ROUND(S8 * (1 + VAT), 2)","v":49.67},17.510000000000002,{"$f":"ROUND(U8 * (1 + VAT), 2)","v":20.14}]
["Ruraflex","Ru",0,2,null,null,null,"≥ 500V & ≤ 22kV",300.27,345.31,90.97,104.62,49.39,56.8,97.96,112.65,67.41,77.52,42.75,49.16,16.05,18.46]
["Ruraflex","Ru",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",1,1,null,null,"> 300km and \n≤ 600km","< 500V",306.31,352.26,92.79,106.71,50.39,57.95,99.91,114.9,68.77,79.09,43.64,50.19,17.559999999999999,20.190000000000001]
["Ruraflex","Ru",1,2,null,null,null,"≥ 500V & ≤ 22kV",303.26,348.75,91.87,105.65,49.9,57.39,98.93,113.77,68.069999999999993,78.28,43.19,49.67,16.149999999999999,18.57]
["Ruraflex","Ru",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",2,1,null,null,"> 600km and \n≤ 900km","< 500V",309.38,355.79,93.73,107.79,50.89,58.52,100.92,116.06,69.45,79.87,44.07,50.68,17.66,20.309999999999999]
["Ruraflex","Ru",2,2,null,null,null,"≥ 500V & ≤ 22kV",306.3,352.25,92.78,106.7,50.39,57.95,99.91,114.9,68.77,79.09,43.64,50.19,16.22,18.649999999999999]
["Ruraflex","Ru",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",3,1,null,null,"> 900km","< 500V",312.45999999999998,359.33,94.66,108.86,51.39,59.1,101.9,117.19,70.14,80.66,44.51,51.19,17.73,20.39]
["Ruraflex","Ru",3,2,null,null,null,"≥ 500V & ≤ 22kV",309.37,355.78,93.73,107.79,50.89,58.52,100.92,116.06,69.45,79.87,44.07,50.68,16.23,18.66]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,null,null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]  in all time-of-use periods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,null,"VAT incl",null,"VAT incl"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"< 500V",null,0.39,{"$f":"ROUND(P28 * (1 + VAT), 2)","v":0.45},24.93,{"$f":"ROUND(R28 * (1 + VAT), 2)","v":28.67}]
["Ruraflex","Ru",0,1,null,null,"≤ 100 kVA",null,17.23,{"$f":"ROUND(I29 * (1 + VAT), 2)","v":19.809999999999999},4.8899999999999997,{"$f":"ROUND(K29 * (1 + VAT), 2)","v":5.62},null,"≥ 500V & < 22kV",null,0.39,{"$f":"ROUND(P29 * (1 + VAT), 2)","v":0.45},21.86,{"$f":"ROUND(R29 * (1 + VAT), 2)","v":25.14}]
["Ruraflex","Ru",0,1,null,null,"> 100 kVA & ≤ 500 kVA",null,58.75,{"$f":"ROUND(I30 * (1 + VAT), 2)","v":67.56},27.24,{"$f":"ROUND(K30 * (1 + VAT), 2)","v":31.33}]
["Ruraflex","Ru",0,1,null,null,"> 500 kVA & ≤ 1 MVA",null,180.75,{"$f":"ROUND(I31 * (1 + VAT), 2)","v":207.86},41.81,{"$f":"ROUND(K31 * (1 + VAT), 2)","v":48.08},null,"Reactive energy charge  [c/kVArh]"]
["Ruraflex","Ru",0,1,null,null,"> 1 MVA",null,180.75,{"$f":"ROUND(I32 * (1 + VAT), 2)","v":207.86},77.58,{"$f":"ROUND(K32 * (1 + VAT), 2)","v":89.22},null,"High season",null,"Low season"]
["Ruraflex","Ru",0,1,null,null,"Key customers",null,3542.53,{"$f":"ROUND(I33 * (1 + VAT), 2)","v":4073.91},77.58,{"$f":"ROUND(K33 * (1 + VAT), 2)","v":89.22},null,null,"VAT incl",null,"VAT incl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8.42,{"$f":"ROUND(N34 * (1 + VAT), 2)","v":9.68},0,{"$f":"ROUND(P34 * (1 + VAT), 2)","v":0}]

{"sheet":"Ruraflex Munic inc","index":22,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,21,5,22],[7,7,10,7],[1,6,1,16],[1,17,1,18],[1,19,1,22],[3,9,3,20],[4,7,6,7],[4,9,4,14],[4,15,4,20],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[28,7,28,8],[28,14,28,15],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,26,8],[25,9,26,10],[25,11,26,12],[25,16,25,17],[25,18,25,19],[26,14,26,15],[27,7,27,8],[27,14,27,15],[32,7,32,8],[29,7,29,8],[30,7,30,8],[30,14,30,17],[31,7,31,8],[31,14,31,15],[31,16,31,17]]}
[null,null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,null,"Ruraflex tariff",null,null,null,null,null,null,null,null,null,null,null,null,"Local authority",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Network capacity charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Ruraflex","Ru",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01Y"},null,null,"≤ 300km","< 500V",310.83,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":357.45},94.15,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":108.27},51.14,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":58.81},101.4,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":116.61},69.78,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":80.25},44.27,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":50.91},17.68,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":20.329999999999998}]
["Ruraflex","Ru",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru02Y"},null,null,null,"≥ 500V & ≤ 22kV",307.74,353.9,93.23,107.21,50.62,58.21,100.41,115.47,69.069999999999993,79.430000000000007,43.82,50.39,16.22,18.649999999999999]
["Ruraflex","Ru",null,null,"RuY",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,"RuY",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",1,1,"Ru11Y",null,null,"> 300km and \n≤ 600km","< 500V",313.92,361.01,95.11,109.38,51.62,59.36,102.39,117.75,70.48,81.05,44.72,51.43,17.75,20.41]
["Ruraflex","Ru",1,2,"Ru12Y",null,null,null,"≥ 500V & ≤ 22kV",310.82,357.44,94.14,108.26,51.14,58.81,101.4,116.61,69.77,80.239999999999995,44.27,50.91,16.309999999999999,18.760000000000002]
["Ruraflex","Ru",null,null,"RuY",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,"RuY",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",2,1,"Ru21Y",null,null,"> 600km and \n≤ 900km","< 500V",317.07,364.63,96.04,110.45,52.16,59.98,103.42,118.93,71.16,81.83,45.17,51.95,17.850000000000001,20.53]
["Ruraflex","Ru",2,2,"Ru22Y",null,null,null,"≥ 500V & ≤ 22kV",313.91000000000003,361,95.1,109.37,51.62,59.36,102.39,117.75,70.48,81.05,44.72,51.43,16.39,18.850000000000001]
["Ruraflex","Ru",null,null,"RuY",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,"RuY",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",3,1,"Ru31Y",null,null,"> 900km","< 500V",320.24,368.28,97.03,111.58,52.65,60.55,104.44,120.11,71.900000000000006,82.69,45.61,52.45,17.899999999999999,20.59]
["Ruraflex","Ru",3,2,"Ru32Y",null,null,null,"≥ 500V & ≤ 22kV",317.06,364.62,96.04,110.45,52.16,59.98,103.42,118.93,71.16,81.83,45.17,51.95,16.399999999999999,18.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,null,null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]  in all time-of-use periods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,null,"VAT incl",null,"VAT incl"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"< 500V",null,0.39,{"$f":"ROUND(Q28 * (1 + VAT), 2)","v":0.45},25.21,{"$f":"ROUND(S28 * (1 + VAT), 2)","v":28.99}]
["Ruraflex","Ru",0,1,{"$f":"B29&C29&D29&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01Y"},null,null,"≤ 100 kVA",null,17.170000000000002,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":19.75},4.87,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":5.6},null,"≥ 500V & < 22kV",null,0.39,{"$f":"ROUND(Q29 * (1 + VAT), 2)","v":0.45},22.06,{"$f":"ROUND(S29 * (1 + VAT), 2)","v":25.37}]
["Ruraflex","Ru",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01Y"},null,null,"> 100 kVA & ≤ 500 kVA",null,58.55,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":67.33},27.14,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":31.21}]
["Ruraflex","Ru",0,1,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01Y"},null,null,"> 500 kVA & ≤ 1 MVA",null,180.12,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":207.14},41.65,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":47.9},null,"Reactive energy charge  [c/kVArh]"]
["Ruraflex","Ru",0,1,{"$f":"B32&C32&D32&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01Y"},null,null,"> 1 MVA",null,180.12,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":207.14},77.3,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":88.9},null,"High season",null,"Low season"]
["Ruraflex","Ru",0,1,{"$f":"B33&C33&D33&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01Y"},null,null,"Key customers",null,3529.79,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":4059.26},77.3,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":88.9},null,null,"VAT incl",null,"VAT incl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3800000000000008,{"$f":"ROUND(O34 * (1 + VAT), 2)","v":9.64},0,{"$f":"ROUND(Q34 * (1 + VAT), 2)","v":0}]

{"sheet":"Ruraflex Gen inc","index":23,"n_rows":36,"n_cols":33,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,18,32,19],[29,7,29,8],[29,14,29,15],[34,7,34,8],[31,7,31,8],[32,7,32,8],[32,14,32,17],[33,7,33,8],[33,14,33,15],[33,16,33,17],[5,19,5,20],[30,7,30,8],[30,14,30,15],[11,7,14,7],[15,7,18,7],[19,7,22,7],[27,9,28,10],[27,11,28,12],[27,16,27,17],[25,16,26,17],[23,7,23,8],[27,7,27,8],[28,7,28,8],[1,19,1,23],[27,14,28,15],[7,7,10,7],[1,6,1,16],[1,17,1,18],[3,9,3,20],[3,21,3,22],[4,7,6,7],[4,9,4,14],[4,15,4,20],[4,21,5,22],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18]]}
[null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Non-municipal",null,null,null,null,null,"Ruraflex Gen tariff",null,null,null,null,null,null,null,null,null,null,null,null,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}},"check value"]
[]
[null,null,null,null,null,null,null,null,null,"Active energy charge for loads [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Network capacity charges [R/kVA/m]"]
[null,null,null,null,null,null,null,"Transmission zone",null,"High demand season [Jun - Aug]",null,null,null,null,null,"Low demand season [Sep - May]"]
[null,null,null,null,null,null,null,null,"Voltage","Peak",null,"Standard",null,"Off Peak",null,"Peak",null,"Standard",null,"Off Peak"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"","VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Genflex rural","GR",0,1,{"$f":"B8&C8&D8&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"≤ 300km","< 500V",303.27,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":348.76},91.88,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":105.66},49.9,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":57.39},98.93,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":113.77},68.08,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":78.290000000000006},43.19,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":49.67},17.510000000000002,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":20.14}]
["Genflex rural","GR",0,2,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR02N"},null,null,null,"≥ 500V & ≤ 22kV",300.27,345.31,90.97,104.62,49.39,56.8,97.96,112.65,67.41,77.52,42.75,49.16,16.05,18.46]
["Genflex rural","GR",null,null,"GRN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Genflex rural","GR",null,null,"GRN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Genflex rural","GR",1,1,"GR11N",null,null,"> 300km and \n≤ 600km","< 500V",306.31,352.26,92.79,106.71,50.39,57.95,99.91,114.9,68.77,79.09,43.64,50.19,17.559999999999999,20.190000000000001]
["Genflex rural","GR",1,2,"GR12N",null,null,null,"≥ 500V & ≤ 22kV",303.26,348.75,91.87,105.65,49.9,57.39,98.93,113.77,68.069999999999993,78.28,43.19,49.67,16.149999999999999,18.57]
["Genflex rural","GR",null,null,"GRN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Genflex rural","GR",null,null,"GRN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Genflex rural","GR",2,1,"GR21N",null,null,"> 600km and \n≤ 900km","< 500V",309.38,355.79,93.73,107.79,50.89,58.52,100.92,116.06,69.45,79.87,44.07,50.68,17.66,20.309999999999999]
["Genflex rural","GR",2,2,"GR22N",null,null,null,"≥ 500V & ≤ 22kV",306.3,352.25,92.78,106.7,50.39,57.95,99.91,114.9,68.77,79.09,43.64,50.19,16.22,18.649999999999999]
["Genflex rural","GR",null,null,"GRN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Genflex rural","GR",null,null,"GRN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Genflex rural","GR",3,1,"GR31N",null,null,"> 900km","< 500V",312.45999999999998,359.33,94.66,108.86,51.39,59.1,101.9,117.19,70.14,80.66,44.51,51.19,17.73,20.39]
["Genflex rural","GR",3,2,"GR32N",null,null,null,"≥ 500V & ≤ 22kV",309.37,355.78,93.73,107.79,50.89,58.52,100.92,116.06,69.45,79.87,44.07,50.68,16.23,18.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Gen-purchase","NLPurchADJ",0,4,{"$f":"B24&C24&D24&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NLPurchADJ04N"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ancillary service charge for loads and generators"]
[]
[null,null,null,null,null,null,null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]",null,null,"Voltage",null,"Ancillary service charge [c/kWh]"]
[null,null,null,null,null,null,null,"[kVA or MVA = loads]",null,null,null,null,null,null,null,null,null,"VAT incl"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"[kW or MW = generators]",null,null,"VAT incl",null,"VAT incl",null,"< 500V",null,0.39,{"$f":"ROUND(Q30 * (1 + VAT), 2)","v":0.45}]
["Genflex rural","GR",0,1,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"≤ 100 kVA/kW",null,17.23,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":19.809999999999999},4.8899999999999997,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":5.62},null,"≥ 500V & < 22kV",null,0.39,{"$f":"ROUND(Q31 * (1 + VAT), 2)","v":0.45}]
["Genflex rural","GR",0,1,{"$f":"B32&C32&D32&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"> 100 KVA/kW & ≤ 500 kVA/kW",null,58.75,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":67.56},27.24,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":31.33}]
["Genflex rural","GR",0,1,{"$f":"B33&C33&D33&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,180.75,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":207.86},41.81,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":48.08},null,"Reactive energy charge  [c/kVArh]",null,null,null,"Network demand charge [c/kWh] for loads  in all time-of-use periods\n"]
["Genflex rural","GR",0,1,{"$f":"B34&C34&D34&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"> 1 MVA/MW",null,180.75,{"$f":"ROUND(J34 * (1 + VAT), 2)","v":207.86},77.58,{"$f":"ROUND(L34 * (1 + VAT), 2)","v":89.22},null,"High season",null,"Low season",null,null,"VAT incl"]
["Genflex rural","GR",0,1,{"$f":"B35&C35&D35&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"Key customers",null,3542.53,{"$f":"ROUND(J35 * (1 + VAT), 2)","v":4073.91},77.58,{"$f":"ROUND(L35 * (1 + VAT), 2)","v":89.22},null,null,"VAT incl",null,"VAT incl",24.93,{"$f":"ROUND(S35 * (1 + VAT), 2)","v":28.67}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.42,{"$f":"ROUND(O36 * (1 + VAT), 2)","v":9.68},0,{"$f":"ROUND(Q36 * (1 + VAT), 2)","v":0},21.86,{"$f":"ROUND(S36 * (1 + VAT), 2)","v":25.14}]

{"sheet":"Landrate inc","index":24,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,17,3,18],[11,7,11,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal",null,null,null,null,null,null,"Landrate tariffs",null,null,null,null,null,null,null,null,null,"Non-local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge [c/kWh]",null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]",null,"Network capacity charge \n[R/POD/day]",null,"Service charge  \n[R/POD/day]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Landrate 1","L1",0,1,{"$f":"B6&C6&D6&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"L101N"},null,null,"Landrate 1",null,99.79,{"$f":"ROUND(J6 * (1 + VAT), 2)","v":114.76},0.39,{"$f":"ROUND(L6 * (1 + VAT), 2)","v":0.45},24.93,{"$f":"ROUND(N6 * (1 + VAT), 2)","v":28.67},26.65,{"$f":"ROUND(P6 * (1 + VAT), 2)","v":30.65},22.13,{"$f":"ROUND(R6 * (1 + VAT), 2)","v":25.45}]
["Landrate 2","L2",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"L201N"},null,null,"Landrate 2",null,99.79,114.76,0.39,{"$f":"ROUND(L7 * (1 + VAT), 2)","v":0.45},24.93,{"$f":"ROUND(N7 * (1 + VAT), 2)","v":28.67},40.97,{"$f":"ROUND(P7 * (1 + VAT), 2)","v":47.12},22.13,{"$f":"ROUND(R7 * (1 + VAT), 2)","v":25.45}]
["Landrate 3","L3",0,1,"L301N",null,null,"Landrate 3",null,99.79,114.76,0.39,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":0.45},24.93,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":28.67},65.5,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":75.33},22.13,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":25.45}]
["Landrate 4","L4",0,1,"L401N",null,null,"Landrate 4",null,215.53,247.86,0.39,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":0.45},24.93,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":28.67},21.22,{"$f":"ROUND(P9 * (1 + VAT), 2)","v":24.4},0,{"$f":"ROUND(R9 * (1 + VAT), 2)","v":0}]
["Landlight","Lt",0,1,{"$f":"B10&C10&D10&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Lt01N"},null,null,"Landlight 20A",null,286.93,329.97]
[null,"Lt60",0,1,{"$f":"B11&C11&D11&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Lt6001N"},null,null,"Landlight 60A",null,369.89,425.37]
["Landrate Dx","Ld",0,1,"Ld01N",null,null,"Landrate Dx*",null,null,null,null,null,null,null,null,null,47.463200000000001,{"$f":"ROUND(R12 * (1 + VAT), 2)","v":54.58}]
[null,null,null,null,null,null,null,"*R/day fixed charge inclusive of the following charges; energy, anciallary service, network demand, betwork capacity and service charge."]

{"sheet":"Landrate Munic inc","index":25,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Municiple",null,null,null,null,null,null,"Landrate tariffs",null,null,null,null,null,null,null,null,null,null,"Local authority"]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge [c/kWh]",null,"Ancillary service charge [c/kWh]",null,"Network demand charge [c/kWh]",null,"Network capacity charge [R/POD/day]",null,"Service charge  [R/POD/day]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Landrate 1","L1",0,1,{"$f":"B6&C6&D6&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"L101Y"},null,null,"Landrate 1",null,102.27,{"$f":"ROUND(J6 * (1 + VAT), 2)","v":117.61},0.39,{"$f":"ROUND(L6 * (1 + VAT), 2)","v":0.45},25.21,{"$f":"ROUND(N6 * (1 + VAT), 2)","v":28.99},26.92,{"$f":"ROUND(P6 * (1 + VAT), 2)","v":30.96},22.04,{"$f":"ROUND(R6 * (1 + VAT), 2)","v":25.35}]
["Landrate 2","L2",0,1,{"$f":"B7&C7&D7&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"L201Y"},null,null,"Landrate 2",null,102.27,{"$f":"ROUND(J7 * (1 + VAT), 2)","v":117.61},0.39,{"$f":"ROUND(L7 * (1 + VAT), 2)","v":0.45},25.21,{"$f":"ROUND(N7 * (1 + VAT), 2)","v":28.99},41.38,{"$f":"ROUND(P7 * (1 + VAT), 2)","v":47.59},22.04,{"$f":"ROUND(R7 * (1 + VAT), 2)","v":25.35}]
["Landrate 3","L3",0,1,"L301Y",null,null,"Landrate 3",null,102.27,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":117.61},0.39,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":0.45},25.21,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":28.99},66.17,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":76.099999999999994},22.04,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":25.35}]
["Landrate 4","L4",0,1,"L401Y",null,null,"Landrate 4",null,220.89,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":254.02},0.39,{"$f":"ROUND(L9 * (1 + VAT), 2)","v":0.45},25.21,{"$f":"ROUND(N9 * (1 + VAT), 2)","v":28.99},21.44,{"$f":"ROUND(P9 * (1 + VAT), 2)","v":24.66}]
["Landrate Dx","Ld",0,1,{"$f":"B10&C10&D10&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ld01Y"},null,null,"Landrate Dx*",null,null,null,null,null,null,null,null,null,47.683900000000001,{"$f":"ROUND(R10 * (1 + VAT), 2)","v":54.84}]
[null,null,null,null,null,null,null,"*R/day fixed charge inclusive of the following charges; energy, anciallary service, network demand, betwork capacity and service charge."]

{"sheet":"TOuS Original","index":26,"n_rows":109,"n_cols":14,"rows_kept":109,"cut":false,"hidden":true,"merged":[[103,12,103,13],[89,1,89,2],[90,1,90,2],[91,1,91,2],[93,1,93,3],[93,5,93,7],[103,10,104,11],[88,1,88,2],[73,3,74,4],[73,5,74,6],[73,7,74,8],[75,1,75,2],[76,1,79,2],[82,1,82,6],[83,1,85,2],[83,3,84,4],[83,5,84,6],[86,1,86,2],[87,1,87,2],[72,1,72,8],[56,3,57,4],[56,5,57,6],[58,1,58,2],[59,1,59,2],[60,1,60,2],[63,1,63,4],[64,3,65,4],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[55,1,55,6],[35,1,42,1],[41,2,42,2],[45,1,45,8],[46,3,47,4],[46,5,47,6],[46,7,47,8],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[3,1,4,2],[3,3,3,4],[11,1,12,2],[11,3,11,4],[19,1,30,1],[28,2,30,2]]}
[]
[]
[]
[null,"Reliability service charge urban",null,"Charge\n[c/kWh]"]
[null,null,null,null,"VAT incl"]
[null,"< 500V",null,0.27,{"$f":"ROUND(D6 * (1 + VAT), 2)","v":0.31}]
[null,"≥ 500V & < 66kV",null,0.26,{"$f":"ROUND(D7 * (1 + VAT), 2)","v":0.3}]
[null,"≥ 66kV & ≤ 132kV",null,0.25,{"$f":"ROUND(D8 * (1 + VAT), 2)","v":0.28999999999999998}]
[null,"> 132kV",null,0.23,{"$f":"ROUND(D9 * (1 + VAT), 2)","v":0.26}]
[]
[]
[null,"Reliability service charge rural",null,"Charge                                           [c/kWh]"]
[null,null,null,null,"VAT incl"]
[null,"< 500V",null,0.27,{"$f":"ROUND(D14 * (1 + VAT), 2)","v":0.31}]
[null,"≥ 500V & ≤ 22kV",null,0.27,{"$f":"ROUND(D15 * (1 + VAT), 2)","v":0.31}]
[]
[]
[null,null,"Transmission zone","Voltage","R/kVA"]
[null,null,null,null,null,"VAT incl"]
[null,"ETUoS\nurban","≤ 300km","< 500V",11.364385961984476,{"$f":"ROUND(E20 * (1 + VAT), 2)","v":13.07}]
[null,null,null,"≥ 500V & < 66kV",11.194005362854275,12.87]
[null,null,null,"≥ 66kV & ≤ 132kV",10.836206104680851,12.46]
[null,null,"> 300km & ≤ 600km","< 500V",11.466614321462599,13.19]
[null,null,null,"≥ 500V & < 66kV",11.313271782245415,13.01]
[null,null,null,"≥ 66kV & ≤ 132kV",10.955472524071991,12.6]
[null,null,"> 600km & ≤ 900km","< 500V",11.585880740853739,13.32]
[null,null,null,"≥ 500V & < 66kV",11.432538201636557,13.15]
[null,null,null,"≥ 66kV & ≤ 132kV",11.057700883550114,12.72]
[null,null,"> 900km","< 500V",11.705147160244881,13.46]
[null,null,null,"≥ 500V & < 66kV",11.551804621027699,13.28]
[null,null,null,"≥ 66kV & ≤ 132kV",11.176967302941254,12.85]
[]
[]
[null,null,"Transmission zone","Voltage","R/kVA"]
[null,null,null,null,null,"VAT incl"]
[null,"ETUoS\nrural","≤ 300km","< 500V",11.773299399896962,{"$f":"ROUND(E36 * (1 + VAT), 2)","v":13.54}]
[null,null,null,"≥ 500V & < 66kV",11.671071040418839,13.42]
[null,null,"> 300km & ≤ 600km","< 500V",11.892565819288103,13.68]
[null,null,null,"≥ 500V & < 66kV",11.790337459809981,13.56]
[null,null,"> 600km & ≤ 900km","< 500V",12.011832238679244,13.81]
[null,null,null,"≥ 500V & < 66kV",11.909603879201123,13.7]
[null,null,"> 900km","< 500V",12.131098658070385,13.95]
[null,null,null,"≥ 500V & < 66kV",12.028870298592263,13.83]
[]
[]
[null,"Distribution network charges urban"]
[null,null,null,"Network access charge    [R/kVA/m]",null,"Network demand charge [R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[]
[null,"Voltage ",null,null,"VAT incl",null,"VAT incl",null,"VAT incl"]
[null,"< 500V",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(D50 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(F50 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(H50 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[null,"≥ 500V & < 66kV",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(D51 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(F51 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(H51 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[null,"≥ 66kV & ≤ 132kV",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(D52 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(F52 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(H52 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[null,"> 132kV",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(D53 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(F53 * (1 + VAT), 2)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(H53 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Distribution network charges rural"]
[null,null,null,"Network access charge [R/kVA/m]",null,"Network demand charge [c/kWh]"]
[]
[null,"Voltage",null,null,"VAT incl",null,"VAT incl"]
[null,"< 500V",null,6.2016647953894406,{"$f":"ROUND(D60 * (1 + VAT), 2)","v":7.13},19.673247251813724,{"$f":"ROUND(F60 * (1 + VAT), 2)","v":22.62}]
[null,"≥ 500V & ≤ 22kV",null,2.2975559127207621,{"$f":"ROUND(D61 * (1 + VAT), 2)","v":2.64},17.238867254434076,{"$f":"ROUND(F61 * (1 + VAT), 2)","v":19.82}]
[]
[]
[null,"Distribution network charges for Generators"]
[null,null,null,"Network access charge    [R/MW/m]"]
[]
[null,"Voltage ",null,null,"VAT incl"]
[null,"< 500V"]
[null,"≥ 500V & < 66kV"]
[null,"≥ 66kV & ≤ 132kV",null,9.4,{"$f":"ROUND(D70 * (1 + VAT), 2)","v":10.81}]
[]
[]
[null,"Electrification and rural network subsidy charge [c/kWh]"]
[null,null,null,"Rural network subsidy charge            [c/kWh]",null,"Electrification networks subsidy charge  [c/kWh]",null,"Total electrification and rural network subsidy charge [c/kWh]"]
[]
[null,"Tariff",null,null,"VAT incl",null,"VAT incl",null,"VAT incl"]
[null,"Megaflex, Miniflex, Nightsave Urban Large, Nightsave Urban Small, Businessrate \n"]
[null,null,null,2.68,{"$f":"ROUND(D78 * (1 + VAT), 2)","v":3.08},0.91,{"$f":"ROUND(F78 * (1 + VAT), 2)","v":1.05},3.59,{"$f":" ROUND(H78 * (1 + VAT), 2)","v":4.13}]
[]
[]
[]
[]
[null,"Service and admin charges"]
[null,"Customer categories",null,"Service charge  [R/account/day]",null,"Administration charge  [R/POD/day]"]
[]
[null,null,null,null,"VAT incl",null,"VAT incl"]
[null,"≤ 100 kVA",null,9.49,{"$f":"ROUND(D87 * (1 + VAT), 2)","v":10.91},2.08,{"$f":"ROUND(F87 * (1 + VAT), 2)","v":2.39}]
[null,"> 100 kVA & ≤ 500 kVA",null,43.38,{"$f":"ROUND(D88 * (1 + VAT), 2)","v":49.89},12.16,{"$f":"ROUND(F88 * (1 + VAT), 2)","v":13.98}]
[null,"> 500 kVA & ≤ 1 MVA",null,133.5,{"$f":"ROUND(D89 * (1 + VAT), 2)","v":153.53},24.17,{"$f":"ROUND(F89 * (1 + VAT), 2)","v":27.8}]
[null,"> 1 MVA",null,133.5,{"$f":"ROUND(D90 * (1 + VAT), 2)","v":153.53},60.17,{"$f":"ROUND(F90 * (1 + VAT), 2)","v":69.2}]
[null,"Key customers",null,2616.06,{"$f":"ROUND(D91 * (1 + VAT), 2)","v":3008.47},83.55,{"$f":"ROUND(F91 * (1 + VAT), 2)","v":96.08}]
[]
[]
[null,"Distribution loss factors",null,null,null,"Transmission loss factors for loads"]
[null,"Voltage","Urban\nloss factor","Rural\nloss factor",null,"Distance from\nJohannesburg","Zone","Loss\nfactor"]
[null,"< 500V",{"$f":"'Loss Factors'!O6","v":1.1111},{"$f":"'Loss Factors'!P6","v":1.1527000000000001},null,"0 to 300 km",0,{"$f":"'Loss Factors'!T6","v":1.0106999999999999}]
[null,"≥ 500V & < 66kV",{"$f":"'Loss Factors'!O7","v":1.0956999999999999},{"$f":"'Loss Factors'!P7","v":1.1412},null,"301 to 600 km",1,{"$f":"'Loss Factors'!T7","v":1.0207999999999999}]
[null,"≥ 66kV & ≤ 132kV",{"$f":"'Loss Factors'!O8","v":1.0610999999999999},null,null,"601 to 900 km",2,{"$f":"'Loss Factors'!T8","v":1.0309999999999999}]
[null,"> 132kV",{"$f":"'Loss Factors'!O9","v":1},null,null,"> 900 km",3,{"$f":"'Loss Factors'!T9","v":1.0412999999999999}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TUoS  [ > 132kV]",null,"Charge\nR/kVA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VAT incl"]
[null,null,null,null,null,null,null,null,null,null,null,"≤ 300km",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(M106 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"> 300km & ≤ 600km",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(M107 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"> 600km & ≤ 900km",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(M108 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"> 900km",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(M109 * (1 + VAT), 2)","v":{"$error":"#REF!"}}]

{"sheet":"TUoS","index":27,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,7,2,13],[53,7,54,8],[53,9,53,10],[66,7,66,8],[15,9,17,10],[15,11,17,12],[45,9,45,10],[45,7,46,8],[5,7,5,10],[27,7,27,9],[24,7,24,8],[25,7,25,8],[22,7,22,8],[6,9,7,10],[8,7,8,8],[9,7,11,8],[14,7,14,12],[15,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[23,7,23,8],[35,7,36,8],[35,9,36,9],[67,7,67,8],[63,9,63,10],[63,7,65,8]]}
[null,null,null,null,null,null,null,"Back to menu"]
["Non-municipal"]
[null,null,null,null,null,null,null," TUoS (Transmission use of system) charges\n(> 132 KV or direct Transmission connected) network charge for loads"]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge\n [c/kWh]"]
[null,null,null,null,null,null,null,null,null,"Electrification and rural network subsidy charge [c/kWh]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Tariff",null,null,"VAT incl"]
[null,null,null,null,null,null,null,"Megaflex, Miniflex, Nightsave Urban Large, Nightsave Urban Small, Businessrate \n"]
["Megaflex","Me",0,1,{"$f":"B11&C11&D11&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,null,null,{"$f":"'Megaflex inc'!H46","v":7.45},{"$f":"ROUND(J11 * (1 + 0.15), 2)","v":8.57}]
[]
[]
[]
[null,null,null,null,null,null,null,"Service and admin charges"]
[null,null,null,null,null,null,null,"Utilised capacity/maximum export capacity",null,"Service charge\n[R/account/day]",null,"Administration charge\n[R/POD/day]"]
[]
[]
[null,null,null,null,null,null,null,"[kVA/MVA = loads]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"[kW/MW = generators]",null,null,"VAT incl",null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B21&C21&D21&IF($B$28=\"Non-municipal\",\"N\",IF($B$28=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"≤ 100 kVA/kW",null,13.6,{"$f":"ROUND(J21 * (1 + 0.15), 2)","v":15.64},2.99,{"$f":"ROUND(L21 * (1 + 0.15), 2)","v":3.44}]
["Miniflex","Mi",0,1,{"$f":"B22&C22&D22&IF($B$28=\"Non-municipal\",\"N\",IF($B$28=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"> 100 kVA/kW & ≤ 500 kVA/kW",null,62.12,{"$f":"ROUND(J22 * (1 + 0.15), 2)","v":71.44},17.420000000000002,{"$f":"ROUND(L22 * (1 + 0.15), 2)","v":20.03}]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,191.16,{"$f":"ROUND(J23 * (1 + 0.15), 2)","v":219.83},34.6,{"$f":"ROUND(L23 * (1 + 0.15), 2)","v":39.79}]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 1 MVA/MW",null,191.16,{"$f":"ROUND(J24 * (1 + 0.15), 2)","v":219.83},86.15,{"$f":"ROUND(L24 * (1 + 0.15), 2)","v":99.07}]
["Miniflex","Mi",0,1,"Mi01N",null,null,"Key customers or Transmission connected generators",null,3745.97,{"$f":"ROUND(J25 * (1 + 0.15), 2)","v":4307.87},119.64,{"$f":"ROUND(L25 * (1 + 0.15), 2)","v":137.59}]
[]
[]
[null,"Non-municipal",null,null,null,null,null,"Transmission loss factors for loads"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Distance from\nJohannesburg","Zone","Loss\nfactor"]
["Transmission loss factor","TxLoss",0,4,{"$f":"B30&C30&D30&IF($B$28=\"Non-municipal\",\"N\",IF($B$28=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss04N"},null,null,"≤ 300km",0,1.0106999999999999]
["Transmission loss factor","TxLoss",1,4,{"$f":"B31&C31&D31&IF($B$28=\"Non-municipal\",\"N\",IF($B$28=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss14N"},null,null,"> 300km & ≤ 600km",1,1.0207999999999999]
["Transmission loss factor","TxLoss",2,4,{"$f":"B32&C32&D32&IF($B$28=\"Non-municipal\",\"N\",IF($B$28=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss24N"},null,null,"> 600km & ≤ 900km",2,1.0309999999999999]
["Transmission loss factor","TxLoss",3,4,{"$f":"B33&C33&D33&IF($B$28=\"Non-municipal\",\"N\",IF($B$28=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss34N"},null,null,"> 900km",3,1.0412999999999999]
[]
[]
[null,null,null,null,null,null,null,"Loss factors for Transmission connected generators",null,"Loss factor"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode"]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,{"$f":"B38&C38&D38&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GenTUOSCape4N"},null,null,null,"Cape",{"$f":"'Loss Factors'!P14","v":0.97099999999999997}]
["TUoS network charges for Transmission connected generators","GenTUOS","Karoo",4,"GenTUOSKaroo4N",null,null,null,"Karoo",{"$f":"'Loss Factors'!P15","v":0.995}]
["TUoS network charges for Transmission connected generators","GenTUOS","Kwazulu-Natal",4,"GenTUOSKwazulu-Natal4N",null,null,null,"Kwazulu-Natal",{"$f":"'Loss Factors'!P16","v":1.004}]
["TUoS network charges for Transmission connected generators","GenTUOS","Vaal",4,"GenTUOSVaal4N",null,null,null,"Vaal",{"$f":"'Loss Factors'!P17","v":1.02}]
["TUoS network charges for Transmission connected generators","GenTUOS","Waterburg",4,"GenTUOSWaterburg4N",null,null,null,"Waterberg",{"$f":"'Loss Factors'!P18","v":1.0229999999999999}]
["TUoS network charges for Transmission connected generators","GenTUOS","Mpumalanga",4,"GenTUOSMpumalanga4N",null,null,null,"Mpumalanga",{"$f":"'Loss Factors'!P19","v":1.0209999999999999}]
[]
[]
[null,null,null,null,null,null,null,"TUoS network charge for Transmission connected loads",null,"Network capacity charge\n[R/kVA]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["WEPS","We",0,1,{"$f":"B48&C48&D48&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"We01N"},null,null,null,"≤ 300km",{"$f":"'WEPS inc'!V11","v":9.42},{"$f":"ROUND(J48 * (1 + 0.15), 2)","v":10.83}]
["WEPS","We",0,2,"We02N",null,null,null,"> 300km & ≤ 600km",{"$f":"'WEPS inc'!V15","v":9.51},{"$f":"ROUND(J49 * (1 + 0.15), 2)","v":10.94}]
["WEPS","We",0,3,"We03N",null,null,null,"> 600km & ≤ 900km",{"$f":"'WEPS inc'!V19","v":9.65},{"$f":"ROUND(J50 * (1 + 0.15), 2)","v":11.1}]
["WEPS","We",0,4,"We04N",null,null,null,"> 900km",{"$f":"'WEPS inc'!V23","v":9.7200000000000006},{"$f":"ROUND(J51 * (1 + 0.15), 2)","v":11.18}]
[]
[]
[null,null,null,null,null,null,null,"TUoS network charges for Transmission connected generators",null,"Network charge\n[R/kW]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,{"$f":"B56&C56&D56&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GenTUOSCape4N"},null,null,null,"Cape",0,{"$f":"ROUND(J56 * (1 + 0.15), 2)","v":0}]
["TUoS network charges for Transmission connected generators","GenTUOS","Karoo",4,"GenTUOSKaroo4N",null,null,null,"Karoo",0,0]
["TUoS network charges for Transmission connected generators","GenTUOS","Kwazulu-Natal",4,"GenTUOSKwazulu-Natal4N",null,null,null,"Kwazulu-Natal",1.98,2.2799999999999998]
["TUoS network charges for Transmission connected generators","GenTUOS","Vaal",4,"GenTUOSVaal4N",null,null,null,"Vaal",6.59,7.58]
["TUoS network charges for Transmission connected generators","GenTUOS","Waterburg",4,"GenTUOSWaterburg4N",null,null,null,"Waterberg",8.44,9.7100000000000009]
["TUoS network charges for Transmission connected generators","GenTUOS","Mpumalanga",4,"GenTUOSMpumalanga4N",null,null,null,"Mpumalanga",7.83,9]
[]
[]
[null,null,null,null,null,null,null,"TUoS ancillary service charge for Transmission connected loads and generators",null,"Ancillary service charge\n[c/kWh]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,{"$f":"B67&C67&D67&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GenTUOSCape4N"},null,null,"Generators",null,0.34,{"$f":"ROUND(J67 * (1 + 0.15), 2)","v":0.39}]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,{"$f":"B68&C68&D68&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GenTUOSCape4N"},null,null,"Loads",null,0.34,{"$f":"ROUND(J68 * (1 + 0.15), 2)","v":0.39}]

{"sheet":"DUoS","index":28,"n_rows":127,"n_cols":21,"rows_kept":127,"cut":false,"hidden":false,"merged":[[100,11,102,12],[103,7,103,8],[109,7,109,8],[104,7,104,8],[105,7,105,8],[106,7,106,8],[107,7,107,8],[108,7,108,8],[66,7,66,10],[69,7,69,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[67,9,68,10],[49,9,50,10],[61,7,61,8],[59,11,60,12],[58,7,58,12],[59,9,60,10],[49,11,50,12],[51,7,51,8],[31,8,33,8],[22,7,33,7],[62,7,62,8],[63,7,63,8],[55,7,55,8],[54,7,54,8],[112,7,112,9],[112,11,112,13],[77,13,78,14],[80,17,83,18],[77,19,78,20],[80,7,83,8],[97,7,97,8],[87,7,89,8],[93,7,93,8],[94,7,94,8],[86,7,86,12],[79,7,79,8],[91,7,91,8],[99,7,99,12],[100,7,102,8],[100,9,102,10],[95,7,95,8],[96,7,96,8],[92,7,92,8],[90,7,90,8],[77,11,78,12],[77,9,78,10],[77,17,79,18],[75,17,76,20],[75,7,76,14],[3,7,3,13],[87,9,89,10],[87,11,89,12],[48,7,48,14],[38,7,45,7],[44,8,45,8],[52,7,52,8],[53,7,53,8],[49,13,50,14],[6,9,6,10],[6,7,7,8],[14,7,15,8],[14,9,14,10]]}
[]
["Non-Municipal",null,null,null,null,null,null,"Back to menu"]
[]
[null,null,null,null,null,null,null,"DUoS (Distribution use of system) charges"]
[]
[]
[null,null,null,null,null,null,null,"DuoS ancillary service charge Urbanp",null,"Charge\n[c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["Gen-DUoS urban","NEGenDUoSU",0,1,{"$f":"B9&C9&D9&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU01N"},null,null,"< 500V",null,0.39,{"$f":"ROUND(J9 * (1 + VAT), 2)","v":0.45}]
["Gen-DUoS urban","NEGenDUoSU",0,2,{"$f":"B10&C10&D10&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU02N"},null,null,"≥ 500V & < 66kV",null,0.38,{"$f":"ROUND(J10 * (1 + VAT), 2)","v":0.44}]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,"≥ 66kV & ≤ 132kV",null,0.36,{"$f":"ROUND(J11 * (1 + VAT), 2)","v":0.41}]
[]
[]
[]
[null,null,null,null,null,null,null,"DUoS ancillary service charge Ruralp",null,"Charge                                           [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["Gen-DUoS rural","NEGenDUoSR",0,1,{"$f":"B17&C17&D17&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSR01N"},null,null,"< 500V",null,0.39,{"$f":"ROUND(J17 * (1 + VAT), 2)","v":0.45}]
["Gen-DUoS rural","NEGenDUoSR",0,2,{"$f":"B18&C18&D18&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSR02N"},null,null,"≥ 500V & ≤ 22kV",null,0.39,{"$f":"ROUND(J18 * (1 + VAT), 2)","v":0.45}]
[]
[]
[null,null,null,null,null,null,null,null,"Transmission zone","Voltage","[R/kVA]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,null,"VAT incl"]
[null,null,null,null,null,null,null,"ETUoS\nurban","≤ 300km","< 500V",{"$f":"'Megaflex inc'!V8","v":8.3800000000000008},{"$f":"ROUND(K23 * (1 + VAT), 2)","v":9.64}]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Megaflex inc'!V9","v":7.66},8.81]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",{"$f":"'Megaflex inc'!V10","v":7.46},8.58]
[null,null,null,null,null,null,null,null,"> 300km & ≤ 600km","< 500V",{"$f":"'Megaflex inc'!V12","v":8.44},9.7100000000000009]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Megaflex inc'!V13","v":7.73},8.89]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",{"$f":"'Megaflex inc'!V14","v":7.51},8.64]
[null,null,null,null,null,null,null,null,"> 600km & ≤ 900km","< 500V",{"$f":"'Megaflex inc'!V16","v":8.5399999999999991},9.82]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Megaflex inc'!V17","v":7.8},8.9700000000000006]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",{"$f":"'Megaflex inc'!V18","v":7.56},8.69]
[null,null,null,null,null,null,null,null,"> 900km","< 500V",{"$f":"'Megaflex inc'!V20","v":8.59},9.8800000000000008]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Megaflex inc'!V21","v":7.89},9.07]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",{"$f":"'Megaflex inc'!V22","v":7.63},8.77]
[]
[]
[null,null,null,null,null,null,null,null,"Transmission zone","Voltage","[R/kVA]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,null,"VAT incl"]
[null,null,null,null,null,null,null,"ETUoS\nrural","≤ 300km","< 500V",{"$f":"'Ruraflex inc'!U8","v":17.510000000000002},{"$f":"ROUND(K39 * (1 + VAT), 2)","v":20.14}]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Ruraflex inc'!U9","v":16.05},18.46]
[null,null,null,null,null,null,null,null,"> 300km & ≤ 600km","< 500V",{"$f":"'Ruraflex inc'!U12","v":17.559999999999999},20.190000000000001]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Ruraflex inc'!U13","v":16.149999999999999},18.57]
[null,null,null,null,null,null,null,null,"> 600km & ≤ 900km","< 500V",{"$f":"'Ruraflex inc'!U16","v":17.66},20.309999999999999]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Ruraflex inc'!U17","v":16.22},18.649999999999999]
[null,null,null,null,null,null,null,null,"> 900km","< 500V",{"$f":"'Ruraflex inc'!U20","v":17.73},20.39]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",{"$f":"'Ruraflex inc'!U21","v":16.23},18.66]
[]
[]
[null,null,null,null,null,null,null,"DUoS network charges for urbanp loads"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge    [R/kVA/m]",null,"Network demand charge \n[R/kVA/m]",null,"Urban low voltage subsidy charge [R/kVA/m]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage ",null,null,"VAT incl",null,"VAT incl",null,"VAT incl"]
["Gen-DUoS urban","NEGenDUoSU",0,1,{"$f":"B53&C53&D53&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU01N"},null,null,"< 500V",null,{"$f":"'Megaflex inc'!J30","v":16.649999999999999},{"$f":"ROUND(J53 * (1 + VAT), 2)","v":19.149999999999999},{"$f":"'Megaflex inc'!L30","v":31.57},{"$f":"ROUND(L53 * (1 + VAT), 2)","v":36.31},{"$f":"'Megaflex inc'!N30","v":0},{"$f":"ROUND(N53 * (1 + VAT), 2)","v":0}]
["Gen-DUoS urban","NEGenDUoSU",0,2,{"$f":"B54&C54&D54&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU02N"},null,null,"≥ 500V & < 66kV",null,{"$f":"'Megaflex inc'!J31","v":15.27},{"$f":"ROUND(J54 * (1 + VAT), 2)","v":17.559999999999999},{"$f":"'Megaflex inc'!L31","v":28.96},{"$f":"ROUND(L54 * (1 + VAT), 2)","v":33.299999999999997},{"$f":"'Megaflex inc'!N31","v":0},{"$f":"ROUND(N54 * (1 + VAT), 2)","v":0}]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,"≥ 66kV & ≤ 132kV",null,{"$f":"'Megaflex inc'!J32","v":5.45},{"$f":"ROUND(J55 * (1 + VAT), 2)","v":6.27},{"$f":"'Megaflex inc'!L32","v":10.1},{"$f":"ROUND(L55 * (1 + VAT), 2)","v":11.62},{"$f":"'Megaflex inc'!N32","v":13.45},{"$f":"ROUND(N55 * (1 + VAT), 2)","v":15.47}]
["Gen-DUoS urban","NEGenDUoSU",0,4,{"$f":"B56&C56&D56&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU04N"},null,null,"> 132kV",null,{"$f":"'Megaflex inc'!J33","v":0},{"$f":"ROUND(J56 * (1 + VAT), 2)","v":0},{"$f":"'Megaflex inc'!L33","v":0},{"$f":"ROUND(L56 * (1 + VAT), 2)","v":0},{"$f":"'Megaflex inc'!N33","v":13.45},{"$f":"ROUND(N56 * (1 + VAT), 2)","v":15.47}]
[]
[]
[null,null,null,null,null,null,null,"DUoS network charges ruralp loads"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge [R/kVA/m]",null,"Network demand charge [c/kWh]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl"]
["Gen-DUoS rural","NEGenDUoSR",0,1,{"$f":"B63&C63&D63&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSR01N"},null,null,"< 500V",null,{"$f":"'Ruraflex inc'!U8","v":17.510000000000002},{"$f":"ROUND(J63 * (1 + VAT), 2)","v":20.14},{"$f":"'Ruraflex inc'!R28","v":24.93},{"$f":"ROUND(L63 * (1 + VAT), 2)","v":28.67}]
["Gen-DUoS rural","NEGenDUoSR",0,2,{"$f":"B64&C64&D64&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSR02N"},null,null,"≥ 500V & ≤ 22kV",null,{"$f":"'Ruraflex inc'!U9","v":16.05},{"$f":"ROUND(J64 * (1 + VAT), 2)","v":18.46},{"$f":"'Ruraflex inc'!R29","v":21.86},{"$f":"ROUND(L64 * (1 + VAT), 2)","v":25.14}]
[]
[]
[null,null,null,null,null,null,null,"DUoS network charges for generators"]
[null,null,null,null,null,null,null,null,null,"Network capacity charge    [R/kW/m]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage ",null,null,"VAT incl"]
["Gen-DUoS urban","NEGenDUoSU",0,1,{"$f":"B71&C71&D71&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU01N"},null,null,"< 500V"]
["Gen-DUoS urban","NEGenDUoSU",0,2,{"$f":"B72&C72&D72&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"NEGenDUoSU02N"},null,null,"≥ 500V & < 66kV"]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,"≥ 66kV & ≤ 132kV",null,13.47,{"$f":"ROUND(J73 * (1 + VAT), 2)","v":15.49}]
[]
[]
[null,null,null,null,null,null,null,"DUoS electrification and rural network subsidy charge [c/kWh]",null,null,null,null,null,null,null,null,null,"DUoS electrification and rural network subsidy charge [c/kWh]"]
[]
[null,null,null,null,null,null,null,null,null,"Rural network subsidy charge            [c/kWh]",null,"Electrification networks subsidy charge [c/kWh]",null,"Total electrification and rural network subsidy charge [c/kWh]",null,null,null,"Tariff",null,"Electrification and rural network subsidy charge [c/kWh]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Tariff",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,null,null,null,null,"VAT incl"]
[null,null,null,null,null,null,null,"Megaflex, Miniflex, Nightsave Urban Large, Nightsave Urban Small, Businessrate \n",null,null,null,null,null,null,null,null,null,"Megaflex, Miniflex, Nightsave Urban Large, Nightsave Urban Small, Businessrate \n"]
["Megaflex","Me",0,1,{"$f":"B82&C82&D82&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Me01N"},null,null,null,null,4.9400000000000004,{"$f":"ROUND(J82 * (1 + VAT), 2)","v":5.68},2.5099999999999998,{"$f":"ROUND(L82 * (1 + VAT), 2)","v":2.89},{"$f":"SUM(J82, L82)","v":7.45},{"$f":" ROUND(N82 * (1 + VAT), 2)","v":8.57},null,null,null,null,7.45,{"$f":" ROUND(T82 * (1 + VAT), 2)","v":8.57}]
[0.66370106761565839]
[0.33629893238434161]
[]
[]
[null,null,null,null,null,null,null,"DUoS service and administration charges (urbanp )"]
[null,null,null,null,null,null,null,"Customer categories \nutilised capacity / maximum export capacity",null,"Service charge\n[R/account/day]",null,"Administration charge\n[R/POD/day]"]
[]
[]
[null,null,null,null,null,null,null,"[kVA or MVA = loads]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"[kW or MW = generators]",null,null,"VAT incl",null,"VAT incl"]
["Miniflex","Mi",0,1,{"$f":"B93&C93&D93&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"≤ 100 kVA/kW",null,13.6,{"$f":"ROUND(J93 * (1 + VAT), 2)","v":15.64},2.99,{"$f":"ROUND(L93 * (1 + VAT), 2)","v":3.44}]
["Miniflex","Mi",0,1,{"$f":"B94&C94&D94&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Mi01N"},null,null,"> 100 kVA/kW & ≤ 500 kVA/kW",null,62.12,{"$f":"ROUND(J94 * (1 + VAT), 2)","v":71.44},17.420000000000002,{"$f":"ROUND(L94 * (1 + VAT), 2)","v":20.03}]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,191.16,{"$f":"ROUND(J95 * (1 + VAT), 2)","v":219.83},34.6,{"$f":"ROUND(L95 * (1 + VAT), 2)","v":39.79}]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 1 MVA/MW",null,191.16,{"$f":"ROUND(J96 * (1 + VAT), 2)","v":219.83},86.15,{"$f":"ROUND(L96 * (1 + VAT), 2)","v":99.07}]
["Miniflex","Mi",0,1,"Mi01N",null,null,"Key customers or Transmission connected",null,3745.97,{"$f":"ROUND(J97 * (1 + VAT), 2)","v":4307.87},119.64,{"$f":"ROUND(L97 * (1 + VAT), 2)","v":137.59}]
[]
[]
[null,null,null,null,null,null,null,"DUoS service and administration charges (ruralp)"]
[null,null,null,null,null,null,null,"Customer categories \nutilised capacity / maximum export capacity",null,"Service charge\n[R/account/day]",null,"Administration charge\n[R/POD/day]"]
[]
[]
[null,null,null,null,null,null,null,"[kVA or MVA = loads]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"[kW or MW = generators]",null,null,"VAT incl",null,"VAT incl"]
["Ruraflex","Ru",0,1,{"$f":"B106&C106&D106&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01N"},null,null,"≤ 100 kVA/kW",null,17.23,{"$f":"ROUND(J106 * (1 + VAT), 2)","v":19.809999999999999},4.8899999999999997,{"$f":"ROUND(L106 * (1 + VAT), 2)","v":5.62}]
["Ruraflex","Ru",0,1,{"$f":"B107&C107&D107&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"Ru01N"},null,null,"> 100 kVA/kW & ≤ 500 kVA/kW",null,58.75,{"$f":"ROUND(J107 * (1 + VAT), 2)","v":67.56},27.24,{"$f":"ROUND(L107 * (1 + VAT), 2)","v":31.33}]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,180.75,{"$f":"ROUND(J108 * (1 + VAT), 2)","v":207.86},41.81,{"$f":"ROUND(L108 * (1 + VAT), 2)","v":48.08}]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 1 MVA/MW",null,180.75,{"$f":"ROUND(J109 * (1 + VAT), 2)","v":207.86},77.58,{"$f":"ROUND(L109 * (1 + VAT), 2)","v":89.22}]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"Key customers",null,3542.53,{"$f":"ROUND(J110 * (1 + VAT), 2)","v":4073.91},77.58,{"$f":"ROUND(L110 * (1 + VAT), 2)","v":89.22}]
[]
[]
[null,null,null,null,null,null,null,"Distribution loss factors",null,null,null,"Transmission loss factors for loads"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage","Urbanp\nloss factor","Ruralp\nloss factor",null,"Distance from\nJohannesburg","Zone","Loss\nfactor"]
["Distribution loss factor - Urban","DxLossUrb",0,1,{"$f":"B115&C115&D115&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"DxLossUrb01N"},null,null,"< 500V",1.1111,1.1527000000000001,null,"≤ 300km",0,1.0106999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,2,{"$f":"B116&C116&D116&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"DxLossUrb02N"},null,null,"≥ 500V & < 66kV",1.0956999999999999,1.1412,null,"> 300km & ≤ 600km",1,1.0207999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,3,"DxLossUrb03N",null,null,"≥ 66kV & ≤ 132kV",1.0610999999999999,null,null,"> 600km & ≤ 900km",2,1.0309999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,4,"DxLossUrb04N",null,null,"> 132kV",1,null,null,"> 900km",3,1.0412999999999999]
[]
["Distribution loss factor - Rural","DxLossRur",0,1,{"$f":"B120&C120&D120&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"DxLossRur01N"}]
["Distribution loss factor - Rural","DxLossRur",0,2,{"$f":"B121&C121&D121&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"DxLossRur02N"}]
[]
[]
["Transmission loss factor","TxLoss",0,4,{"$f":"B124&C124&D124&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss04N"}]
["Transmission loss factor","TxLoss",1,4,{"$f":"B125&C125&D125&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss14N"}]
["Transmission loss factor","TxLoss",2,4,"TxLoss24N"]
["Transmission loss factor","TxLoss",3,4,"TxLoss34N"]

{"sheet":"Loss Factors","index":29,"n_rows":19,"n_cols":38,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,13,1,19],[3,13,3,15],[3,17,3,19],[11,13,12,14],[11,15,12,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Loss factors"]
["Non-municipal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Distribution loss factors",null,null,null,"Transmission loss factors for loads"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage","Urban\nloss factor","Rural\nloss factor",null,"Distance from\nJohannesburg","Zone","Loss\nfactor"]
["Distribution loss factor - Urban","DxLossUrb",0,1,{"$f":"B6&C6&D6&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"DxLossUrb01N"},null,"Transmission loss factor","TxLoss",0,4,{"$f":"H6&I6&J6&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss04N"},null,null,"< 500V",1.1111,1.1527000000000001,null,"≤ 300km",0,1.0106999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,2,{"$f":"B7&C7&D7&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"DxLossUrb02N"},null,"Transmission loss factor","TxLoss",1,4,{"$f":"H7&I7&J7&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss14N"},null,null,"≥ 500V & < 66kV",1.0956999999999999,1.1412,null,"> 300km & ≤ 600km",1,1.0207999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,3,{"$f":"B8&C8&D8&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"DxLossUrb03N"},null,"Transmission loss factor","TxLoss",2,4,{"$f":"H8&I8&J8&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss24N"},null,null,"≥ 66kV & ≤ 132kV",1.0610999999999999,null,null,"> 600km & ≤ 900km",2,1.0309999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,4,{"$f":"B9&C9&D9&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"DxLossUrb04N"},null,"Transmission loss factor","TxLoss",3,4,{"$f":"H9&I9&J9&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"TxLoss34N"},null,null,"> 132kV/Transmission connected",1,null,null,"> 900km",3,1.0412999999999999]
[]
["Distribution loss factor - Rural","DxLossRur",0,1,{"$f":"B11&C11&D11&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"DxLossRur01N"},null,null,null,null,null,null,null,null,null,null,"2012/13"]
["Distribution loss factor - Rural","DxLossRur",0,2,{"$f":"B12&C12&D12&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"DxLossRur02N"},null,null,null,null,null,null,null,null,"Loss factors for Transmission connected generators",null,"Loss factor"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode"]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,{"$f":"B14&C14&D14&IF($A$3=\"Non-municipal\",\"N\",IF($A$3=\"Municiple\",\"Y\",\"error\"))","v":"GenTUOSCape4N"},null,null,null,null,null,null,null,null,null,"Cape",0.97099999999999997]
["TUoS network charges for Transmission connected generators","GenTUOS","Karoo",4,"GenTUOSKaroo4N",null,null,null,null,null,null,null,null,null,"Karoo",0.995]
["TUoS network charges for Transmission connected generators","GenTUOS","Kwazulu-Natal",4,"GenTUOSKwazulu-Natal4N",null,null,null,null,null,null,null,null,null,"Kwazulu-Natal",1.004]
["TUoS network charges for Transmission connected generators","GenTUOS","Vaal",4,"GenTUOSVaal4N",null,null,null,null,null,null,null,null,null,"Vaal",1.02]
["TUoS network charges for Transmission connected generators","GenTUOS","Waterburg",4,"GenTUOSWaterburg4N",null,null,null,null,null,null,null,null,null,"Waterburg",1.0229999999999999]
["TUoS network charges for Transmission connected generators","GenTUOS","Mpumalanga",4,"GenTUOSMpumalanga4N",null,null,null,null,null,null,null,null,null,"Mpumalanga",1.0209999999999999]

{"sheet":"Reconciliaton","index":30,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,9],[3,2,3,4],[20,2,20,4],[22,2,25,2],[26,2,29,2],[5,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[3,6,3,8],[5,6,8,6],[9,6,11,6],[12,6,14,6],[15,6,17,6]]}
[]
[null,"Generator reconciliations"]
[]
[null,null,"Wheeling",null,null,null,"Energy add back"]
[null,null,"Tariff name","Tariff rate","Source",null,"Tariff name","Tariff rate","Source"]
[null,null,"Gen-wheeling non Munic urban","Energy:                         ","WEPS energy rate excluding losses ",null,"Gen-purchase- urban","Energy:                         ","WEPS energy rate excluding losses "]
[null,null,null,"Affordability subsidy:     ","same as WEPS",null,null,"Affordability subsidy:     ","same as WEPS"]
[null,null,null,"Admin charge:               ","same as WEPS",null,null,"Admin charge:               ","same as WEPS"]
[null,null,null,"Other components:        ","not applicable",null,null,"Other components:        ","not applicable"]
[null,null,"Gen-wheeling non Munic rural","Energy:                         ","WEPS energy rate excluding losses ",null,"Gen-purchase-rural","Energy:                         ","WEPS energy rate excluding losses "]
[null,null,null,"Admin charge:               ","same as Ruraflex",null,null,"Admin charge:               ","same as Ruraflex"]
[null,null,null,"Other components:        ","not applicable",null,null,"Other components:        ","not applicable"]
[null,null,"Gen-wheeling Munic urban","Energy (Local):                         ","WEPS energy rate excluding losses (Local)",null,"Gen-purchase Munic urban","Energy:                         ","WEPS energy rate excluding losses(Local)"]
[null,null,null,"Admin charge:               ","same as WEPS (local)",null,null,"Admin charge:               ","same as WEPS (Local)"]
[null,null,null,"Other components:        ","not applicable",null,null,"Other components:        ","not applicable"]
[null,null,"Gen-wheeling Munic rural","Energy (Local):                         ","WEPS energy rate excluding losses (Local)",null,"Gen-purchase Munic rural","Energy:                         ","WEPS energy rate excluding losses(Local) "]
[null,null,null,"Admin charge:               ","same as same as Ruraflex (local)",null,null,"Admin charge:               ","same as Ruraflex (Local)"]
[null,null,null,"Other components:        ","not applicable",null,null,"Other components:        ","not applicable"]
[]
[]
[null,null,"Offset"]
[null,null,"Tariff name","Tariff rate","Source"]
[null,null,"Gen-offset urban","Energy:                         ","WEPS energy rate including losses (per Tx and voltage zone)"]
[null,null,null,"Affordability subsidy:     ","same as WEPS"]
[null,null,null,"Admin charge:               ","same as WEPS"]
[null,null,null,"Other components:        ","not applicable"]
[null,null,"Gen-offset rural","Energy:                         ","Ruraflex energy rate  (per Tx and voltage zone)"]
[null,null,null,"Affordability subsidy:     ","same as WEPS"]
[null,null,null,"Admin charge:               ","same as WEPS"]
[null,null,null,"Other components:        ","not applicable"]