{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Menu","WEPS inc","WEPS Munic inc","Megaflex inc","Megaflex Munic inc ","Genflex Urban inc","Nightsave Large inc","Nightsave Large Munic inc","Miniflex inc","Miniflex Munic inc ","Nightsave Small inc","Nightsave Small Munic inc","Ruraflex inc","Ruraflex Munic inc","Genflex Rural inc","Nightsave Rural inc","Nightsave Rural Munic inc ","Businessrate inc","Businessrate Munic inc","Homepower inc","Homepower Munic inc","Public Lighting inc","Homelight inc","Public Lighting Munic inc","Landrate inc","Landrate Munic inc","Homeflex REDESIGN inc","TOuS Original","TOuS","DUoS","Loss Factors","Excess NAC","Excess NAC Munic","Env levy"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":7,"defined_names":382,"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":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,3,1,9],[1,28,1,34],[2,3,2,9],[2,28,2,34],[3,3,3,6],[3,28,3,31],[4,3,4,6],[4,28,4,31],[5,3,5,6],[5,28,5,31],[9,31,9,32]]}
[]
[null,"Tariffs rates:","Restructured rates in 2013/14 rand value"]
[]
[null,"Non-local authority","Local authority"]
[null,"WEPS","Megaflex tariff"]
[null,"Megaflex tariff","Nightsave large tariff"]
[null,"Nightsave large tariff","Miniflex tariff"]
[null,"Miniflex tariff","Nightsave small tariff"]
[null,"Nightsave small tariff","Businessrate tariff"]
[null,"Businessrate tariff","Public lighting tariff"]
[null,"Transflex 1 tariff","Ruraflex tariff"]
[null,"Transflex 2 tariff","Nightsave rural tariff"]
[null,"Public lighting tariff","Landrate tariff"]
[null,"Ruraflex tariff","Homepower tariff"]
[null,"Nightsave rural tariff","Homelight tariff"]
[null,"Landrate tariff"]
[null,"Homepower tariff"]
[null,"Homelight tariff"]

{"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],[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,7,43,8],[43,9,44,10],[45,9,45,10],[45,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]]}
[]
["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,"We01N",null,null,"≤ 300km","< 500V",220.91,251.84,67.209999999999994,76.62,36.69,41.83,72.34,82.47,49.92,56.91,31.82,36.270000000000003,6.32,7.2]
["WEPS","We",0,2,"We02N",null,null,null,"≥ 500V & < 66kV",217.44,247.88,65.87,75.09,35.770000000000003,40.78,70.930000000000007,80.86,48.82,55.65,30.97,35.31,5.78,6.59]
["WEPS","We",0,3,"We03N",null,null,null,"≥ 66kV & ≤ 132kV",210.56,240.04,63.78,72.709999999999994,34.64,39.49,68.69,78.31,47.27,53.89,29.99,34.19,5.63,6.42]
["WEPS","We",0,4,"We04N",null,null,null,"> 132kV*",198.45,226.23,60.11,68.53,32.65,37.22,64.739999999999995,73.8,44.55,50.79,28.27,32.229999999999997,7.11,8.11]
["WEPS","We",1,1,"We11N",null,null,"> 300km and \n≤ 600km","< 500V",222.71,253.89,67.48,76.930000000000007,36.64,41.77,72.650000000000006,82.82,50.01,57.01,31.73,36.17,6.37,7.26]
["WEPS","We",1,2,"We12N",null,null,null,"≥ 500V & < 66kV",219.61,250.36,66.53,75.84,36.130000000000003,41.19,71.650000000000006,81.680000000000007,49.3,56.2,31.28,35.659999999999997,5.83,6.65]
["WEPS","We",1,3,"We13N",null,null,null,"≥ 66kV & ≤ 132kV",212.63,242.4,64.41,73.430000000000007,34.97,39.869999999999997,69.36,79.069999999999993,47.73,54.41,30.28,34.520000000000003,5.67,6.46]
["WEPS","We",1,4,"We14N",null,null,null,"> 132kV*",200.43,228.49,60.72,69.22,32.96,37.57,65.37,74.52,44.99,51.29,28.54,32.54,7.18,8.19]
["WEPS","We",2,1,"We21N",null,null,"> 600km and \n≤ 900km","< 500V",224.93,256.42,68.13,77.67,36.99,42.17,73.38,83.65,50.5,57.57,32.03,36.51,6.45,7.35]
["WEPS","We",2,2,"We22N",null,null,null,"≥ 500V & < 66kV",221.81,252.86,67.2,76.61,36.49,41.6,72.36,82.49,49.8,56.77,31.59,36.01,5.88,6.7]
["WEPS","We",2,3,"We23N",null,null,null,"≥ 66kV & ≤ 132kV",214.79,244.86,65.069999999999993,74.180000000000007,35.33,40.28,70.06,79.87,48.22,54.97,30.59,34.869999999999997,5.71,6.51]
["WEPS","We",2,4,"We24N",null,null,null,"> 132kV*",202.45,230.79,61.32,69.900000000000006,33.31,37.97,66.040000000000006,75.290000000000006,45.45,51.81,28.84,32.880000000000003,7.28,8.3000000000000007]
["WEPS","We",3,1,"We31N",null,null,"> 900km","< 500V",227.19,259,68.84,78.48,37.380000000000003,42.61,74.12,84.5,51.01,58.15,32.369999999999997,36.9,6.47,7.38]
["WEPS","We",3,2,"We32N",null,null,null,"≥ 500V & < 66kV",224.02,255.38,67.86,77.36,36.840000000000003,42,73.069999999999993,83.3,50.28,57.32,31.9,36.369999999999997,5.95,6.78]
["WEPS","We",3,3,"We33N",null,null,null,"≥ 66kV & ≤ 132kV",216.95,247.32,65.72,74.92,35.68,40.68,70.760000000000005,80.67,48.71,55.53,30.9,35.229999999999997,5.75,6.56]
["WEPS","We",3,4,"We34N",null,null,null,"> 132kV*",204.43,233.05,61.96,70.63,33.659999999999997,38.369999999999997,66.72,76.06,45.93,52.36,29.16,33.24,7.33,8.36]
[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 access charge [R/kVA/m]",null,"Network demand charge [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,null,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,"< 500V",null,12.56,14.32,23.81,27.14,0,0,null,"< 500V",null,0.28999999999999998,0.33]
["WEPS","We",0,2,"We02N",null,null,"≥ 500V & < 66kV",null,11.52,13.13,21.85,24.91,0,0,null,"≥ 500V & < 66kV",null,0.28000000000000003,0.32]
["WEPS","We",0,3,"We03N",null,null,"≥ 66kV & ≤ 132kV",null,4.1100000000000003,4.6900000000000004,7.61,8.68,10.14,11.56,null,"≥ 66kV & ≤ 132kV",null,0.27,0.31]
["WEPS","We",0,4,"We04N",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.14,11.56,null,"> 132kV / Transmission connected",null,0.25,0.28999999999999998]
[]
[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,10.25,11.69,2.25,2.57,null,null,null,null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,"> 100 kVA & ≤ 500 kVA",null,46.85,53.41,13.13,14.97,null,null,null,10.15,11.57,0,0]
["WEPS","We",0,1,"We01N",null,null,"> 500 kVA & ≤ 1 MVA",null,144.18,164.37,26.1,29.75]
["WEPS","We",0,1,"We01N",null,null,"> 1 MVA",null,144.18,164.37,64.98,74.08]
["WEPS","We",0,1,"We01N",null,null,"Key customers",null,2825.34,3220.89,90.23,102.86]
[]
[]
[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,null,"All seasons",null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,5.62,6.41,2.2400000000000002,2.5499999999999998]
[]
[]
[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,196.35,223.84,59.47,67.8,32.299999999999997,36.82,64.05,73.02,44.08,50.25,27.97,31.89]
[]
[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,192.85999999999999,219.86,55.98,63.82,28.809999999999995,32.840000000000003,60.559999999999995,69.040000000000006,40.589999999999996,46.27,24.479999999999997,27.91]

{"sheet":"WEPS Munic inc","index":2,"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],[38,7,38,8],[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],[35,7,35,8],[35,16,35,17],[35,18,35,19],[36,7,36,8],[37,7,37,8],[52,17,52,18],[39,7,39,8],[40,7,40,8],[43,7,43,8],[50,7,50,18],[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],[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]]}
[]
["Municiple",null,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,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,"We01Y",null,null,"≤ 300km","< 500V",226.3,257.98,68.86,78.5,37.58,42.84,74.099999999999994,84.47,51.13,58.29,32.590000000000003,37.15,6.3,7.18]
["WEPS","We",0,2,"We02Y",null,null,null,"≥ 500V & < 66kV",222.73,253.91,67.48,76.930000000000007,36.64,41.77,72.66,82.83,50.01,57.01,31.73,36.17,5.75,6.56]
["WEPS","We",0,3,"We03Y",null,null,null,"≥ 66kV & ≤ 132kV",215.7,245.9,65.34,74.489999999999995,35.479999999999997,40.450000000000003,70.36,80.209999999999994,48.43,55.21,30.72,35.020000000000003,5.6,6.38]
["WEPS","We",0,4,"We04Y",null,null,null,"> 132kV*",203.29,231.75,61.58,70.2,33.44,38.119999999999997,66.319999999999993,75.599999999999994,45.64,52.03,28.96,33.01,7.08,8.07]
["WEPS","We",1,1,"We11Y",null,null,"> 300km and \n≤ 600km","< 500V",228.14,260.08,69.12,78.8,37.53,42.78,74.430000000000007,84.85,51.23,58.4,32.5,37.049999999999997,6.34,7.23]
["WEPS","We",1,2,"We12Y",null,null,null,"≥ 500V & < 66kV",224.96,256.45,68.150000000000006,77.69,37.01,42.19,73.39,83.66,50.51,57.58,32.04,36.53,5.81,6.62]
["WEPS","We",1,3,"We13Y",null,null,null,"≥ 66kV & ≤ 132kV",217.81,248.3,65.98,75.22,35.82,40.83,71.05,81,48.9,55.75,31.01,35.35,5.64,6.43]
["WEPS","We",1,4,"We14Y",null,null,null,"> 132kV*",205.31,234.05,62.2,70.91,33.770000000000003,38.5,66.959999999999994,76.33,46.1,52.55,29.24,33.33,7.15,8.15]
["WEPS","We",2,1,"We21Y",null,null,"> 600km and \n≤ 900km","< 500V",230.42,262.68,69.8,79.569999999999993,37.9,43.21,75.16,85.68,51.73,58.97,32.82,37.409999999999997,6.42,7.32]
["WEPS","We",2,2,"We22Y",null,null,null,"≥ 500V & < 66kV",227.22,259.02999999999997,68.83,78.47,37.380000000000003,42.61,74.13,84.51,51,58.14,32.36,36.89,5.86,6.68]
["WEPS","We",2,3,"We23Y",null,null,null,"≥ 66kV & ≤ 132kV",220.03,250.83,66.650000000000006,75.98,36.19,41.26,71.760000000000005,81.81,49.39,56.3,31.33,35.72,5.69,6.49]
["WEPS","We",2,4,"We24Y",null,null,null,"> 132kV*",207.38,236.41,62.83,71.63,34.11,38.89,67.66,77.13,46.56,53.08,29.54,33.68,7.25,8.27]
["WEPS","We",3,1,"We31Y",null,null,"> 900km","< 500V",232.73,265.31,70.510000000000005,80.38,38.29,43.65,75.92,86.55,52.25,59.57,33.15,37.79,6.45,7.35]
["WEPS","We",3,2,"We32Y",null,null,null,"≥ 500V & < 66kV",229.49,261.62,69.510000000000005,79.239999999999995,37.75,43.04,74.849999999999994,85.33,51.51,58.72,32.68,37.26,5.92,6.75]
["WEPS","We",3,3,"We33Y",null,null,null,"≥ 66kV & ≤ 132kV",222.24,253.35,67.319999999999993,76.739999999999995,36.56,41.68,72.489999999999995,82.64,49.89,56.87,31.65,36.08,5.73,6.53]
["WEPS","We",3,4,"We34Y",null,null,null,"> 132kV*",209.42,238.74,63.47,72.36,34.49,39.32,68.349999999999994,77.92,47.05,53.64,29.87,34.049999999999997,7.3,8.32]
[null,null,null,null,null,null,null,null,{"$f":"'WEPS inc'!I24","v":"* >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 access charge [R/kVA/m]",null,"Network demand charge [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,null,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,null,"VAT incl"]
["WEPS","We",0,1,"We01Y",null,null,"< 500V",null,12.57,14.33,23.83,27.17,0,0,null,"< 500V",null,0.28999999999999998,0.33]
["WEPS","We",0,2,"We02Y",null,null,"≥ 500V & < 66kV",null,11.53,13.14,21.86,24.92,0,0,null,"≥ 500V & < 66kV",null,0.28000000000000003,0.32]
["WEPS","We",0,3,"We03Y",null,null,"≥ 66kV & ≤ 132kV",null,4.12,4.7,7.62,8.69,10.09,11.5,null,"≥ 66kV & ≤ 132kV",null,0.27,0.31]
["WEPS","We",0,4,"We04Y",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.09,11.5,null,"> 132kV / Transmission connected",null,0.25,0.28999999999999998]
[]
[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,"We01Y",null,null,"≤ 100 kVA",null,10.210000000000001,11.69,2.2400000000000002,2.57,null,null,null,null,"VAT incl",null,"VAT incl"]
["WEPS","We",0,1,"We01Y",null,null,"> 100 kVA & ≤ 500 kVA",null,46.66,53.41,13.08,14.97,null,null,null,10.1,11.51,0,0]
["WEPS","We",0,1,"We01Y",null,null,"> 500 kVA & ≤ 1 MVA",null,143.59,164.37,26,29.75]
["WEPS","We",0,1,"We01Y",null,null,"> 1 MVA",null,143.59,164.37,64.72,74.08]
["WEPS","We",0,1,"We01Y",null,null,"Key customers",null,2813.83,3207.77,89.86,102.44]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge [c/kWh]"]
[]
[null,null,null,null,null,null,null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl"]
["WEPS","We",0,1,"We01Y",null,null,5.59,6.37]
[]
[]
[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,"We01Y",null,null,201.14,229.3,60.93,69.459999999999994,33.090000000000003,37.72,65.62,74.81,45.16,51.48,28.65,32.659999999999997]
[]
[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,"We01Y",null,null,197.64999999999998,225.32,57.44,65.48,29.6,33.74,62.13,70.83,41.669999999999995,47.5,25.159999999999997,28.68]

{"sheet":"Megaflex inc","index":3,"n_rows":46,"n_cols":33,"rows_kept":46,"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],[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],[27,18,27,19],[28,7,28,8],[28,16,28,17],[29,7,29,8],[29,16,29,17],[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],[35,16,35,19],[36,7,36,8],[36,16,36,17],[36,18,36,19],[38,7,38,8],[41,7,42,8],[41,9,42,10],[43,7,43,8],[43,9,43,10]]}
[]
["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,{"$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,"Me01N",null,null,"≤ 300km","< 500V",220.91,251.84,67.209999999999994,76.62,36.69,41.83,72.34,82.47,49.92,56.91,31.82,36.270000000000003,6.32,7.2]
["Megaflex","Me",0,2,"Me02N",null,null,null,"≥ 500V & < 66kV",217.44,247.88,65.87,75.09,35.770000000000003,40.78,70.930000000000007,80.86,48.82,55.65,30.97,35.31,5.78,6.59]
["Megaflex","Me",0,3,"Me03N",null,null,null,"≥ 66kV & ≤ 132kV",210.56,240.04,63.78,72.709999999999994,34.64,39.49,68.69,78.31,47.27,53.89,29.99,34.19,5.63,6.42]
["Megaflex","Me",0,4,"Me04N",null,null,null,"> 132kV*",198.45,226.23,60.11,68.53,32.65,37.22,64.739999999999995,73.8,44.55,50.79,28.27,32.229999999999997,7.11,8.11]
["Megaflex","Me",1,1,"Me11N",null,null,"> 300km and \n≤ 600km","< 500V",222.71,253.89,67.48,76.930000000000007,36.64,41.77,72.650000000000006,82.82,50.01,57.01,31.73,36.17,6.37,7.26]
["Megaflex","Me",1,2,"Me12N",null,null,null,"≥ 500V & < 66kV",219.61,250.36,66.53,75.84,36.130000000000003,41.19,71.650000000000006,81.680000000000007,49.3,56.2,31.28,35.659999999999997,5.83,6.65]
["Megaflex","Me",1,3,"Me13N",null,null,null,"≥ 66kV & ≤ 132kV",212.63,242.4,64.41,73.430000000000007,34.97,39.869999999999997,69.36,79.069999999999993,47.73,54.41,30.28,34.520000000000003,5.67,6.46]
["Megaflex","Me",1,4,"Me14N",null,null,null,"> 132kV*",200.43,228.49,60.72,69.22,32.96,37.57,65.37,74.52,44.99,51.29,28.54,32.54,7.18,8.19]
["Megaflex","Me",2,1,"Me21N",null,null,"> 600km and \n≤ 900km","< 500V",224.93,256.42,68.13,77.67,36.99,42.17,73.38,83.65,50.5,57.57,32.03,36.51,6.45,7.35]
["Megaflex","Me",2,2,"Me22N",null,null,null,"≥ 500V & < 66kV",221.81,252.86,67.2,76.61,36.49,41.6,72.36,82.49,49.8,56.77,31.59,36.01,5.88,6.7]
["Megaflex","Me",2,3,"Me23N",null,null,null,"≥ 66kV & ≤ 132kV",214.79,244.86,65.069999999999993,74.180000000000007,35.33,40.28,70.06,79.87,48.22,54.97,30.59,34.869999999999997,5.71,6.51]
["Megaflex","Me",2,4,"Me24N",null,null,null,"> 132kV*",202.45,230.79,61.32,69.900000000000006,33.31,37.97,66.040000000000006,75.290000000000006,45.45,51.81,28.84,32.880000000000003,7.28,8.3000000000000007]
["Megaflex","Me",3,1,"Me31N",null,null,"> 900km","< 500V",227.19,259,68.84,78.48,37.380000000000003,42.61,74.12,84.5,51.01,58.15,32.369999999999997,36.9,6.47,7.38]
["Megaflex","Me",3,2,"Me32N",null,null,null,"≥ 500V & < 66kV",224.02,255.38,67.86,77.36,36.840000000000003,42,73.069999999999993,83.3,50.28,57.32,31.9,36.369999999999997,5.95,6.78]
["Megaflex","Me",3,3,"Me33N",null,null,null,"≥ 66kV & ≤ 132kV",216.95,247.32,65.72,74.92,35.68,40.68,70.760000000000005,80.67,48.71,55.53,30.9,35.229999999999997,5.75,6.56]
["Megaflex","Me",3,4,"Me34N",null,null,null,"> 132kV*",204.43,233.05,61.96,70.63,33.659999999999997,38.369999999999997,66.72,76.06,45.93,52.36,29.16,33.24,7.33,8.36]
[null,null,null,null,null,null,null,null,{"$f":"'WEPS Munic inc'!I24","v":"* >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 access charge [R/kVA/m]",null,"Network demand charge [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,null,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,null,"VAT incl"]
["Megaflex","Me",0,1,"Me01N",null,null,"< 500V",null,12.56,14.32,23.81,27.14,0,0,null,"< 500V",null,0.28999999999999998,0.33]
["Megaflex","Me",0,2,"Me02N",null,null,"≥ 500V & < 66kV",null,11.52,13.13,21.85,24.91,0,0,null,"≥ 500V & < 66kV",null,0.28000000000000003,0.32]
["Megaflex","Me",0,3,"Me03N",null,null,"≥ 66kV & ≤ 132kV",null,4.1100000000000003,4.6900000000000004,7.61,8.68,10.14,11.56,null,"≥ 66kV & ≤ 132kV",null,0.27,0.31]
["Megaflex","Me",0,4,"Me04N",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.14,11.56,null,"> 132kV / Transmission connected",null,0.25,0.28999999999999998]
[]
[]
[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,"Me01N",null,null,"> 1 MVA",null,144.18,164.37,64.98,74.08,null,null,null,10.15,11.57,0,0]
["Megaflex","Me",0,1,"Me01N",null,null,"Key customers",null,2825.34,3220.89,90.23,102.86]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge\n [c/kWh]",null,"Affordability subsidy charge [c/kWh] \nOnly payable by non-local authority tariffs"]
[]
[null,null,null,null,null,null,null,"All seasons",null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Megaflex","Me",0,1,"Me01N",null,null,5.62,6.41,2.2400000000000002,2.5499999999999998]

{"sheet":"Megaflex Munic inc ","index":4,"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],[39,7,39,8],[38,7,38,8],[37,7,37,8],[43,7,43,8],[41,7,42,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],[28,7,28,8],[28,16,28,17],[29,7,29,8],[29,16,29,17],[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],[35,16,35,19],[36,16,36,17],[36,18,36,19]]}
[null,null,null,null,null,null,null,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,{"$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,"Me01Y",null,null,"≤ 300km","< 500V",226.3,257.98,68.86,78.5,37.58,42.84,74.099999999999994,84.47,51.13,58.29,32.590000000000003,37.15,6.3,7.18]
["Megaflex","Me",0,2,"Me02Y",null,null,null,"≥ 500V & < 66kV",222.73,253.91,67.48,76.930000000000007,36.64,41.77,72.66,82.83,50.01,57.01,31.73,36.17,5.75,6.56]
["Megaflex","Me",0,3,"Me03Y",null,null,null,"≥ 66kV & ≤ 132kV",215.7,245.9,65.34,74.489999999999995,35.479999999999997,40.450000000000003,70.36,80.209999999999994,48.43,55.21,30.72,35.020000000000003,5.6,6.38]
["Megaflex","Me",0,4,"Me04Y",null,null,null,"> 132kV*",203.29,231.75,61.58,70.2,33.44,38.119999999999997,66.319999999999993,75.599999999999994,45.64,52.03,28.96,33.01,7.08,8.07]
["Megaflex","Me",1,1,"Me11Y",null,null,"> 300km and \n≤ 600km","< 500V",228.14,260.08,69.12,78.8,37.53,42.78,74.430000000000007,84.85,51.23,58.4,32.5,37.049999999999997,6.34,7.23]
["Megaflex","Me",1,2,"Me12Y",null,null,null,"≥ 500V & < 66kV",224.96,256.45,68.150000000000006,77.69,37.01,42.19,73.39,83.66,50.51,57.58,32.04,36.53,5.81,6.62]
["Megaflex","Me",1,3,"Me13Y",null,null,null,"≥ 66kV & ≤ 132kV",217.81,248.3,65.98,75.22,35.82,40.83,71.05,81,48.9,55.75,31.01,35.35,5.64,6.43]
["Megaflex","Me",1,4,"Me14Y",null,null,null,"> 132kV*",205.31,234.05,62.2,70.91,33.770000000000003,38.5,66.959999999999994,76.33,46.1,52.55,29.24,33.33,7.15,8.15]
["Megaflex","Me",2,1,"Me21Y",null,null,"> 600km and \n≤ 900km","< 500V",230.42,262.68,69.8,79.569999999999993,37.9,43.21,75.16,85.68,51.73,58.97,32.82,37.409999999999997,6.42,7.32]
["Megaflex","Me",2,2,"Me22Y",null,null,null,"≥ 500V & < 66kV",227.22,259.02999999999997,68.83,78.47,37.380000000000003,42.61,74.13,84.51,51,58.14,32.36,36.89,5.86,6.68]
["Megaflex","Me",2,3,"Me23Y",null,null,null,"≥ 66kV & ≤ 132kV",220.03,250.83,66.650000000000006,75.98,36.19,41.26,71.760000000000005,81.81,49.39,56.3,31.33,35.72,5.69,6.49]
["Megaflex","Me",2,4,"Me24Y",null,null,null,"> 132kV*",207.38,236.41,62.83,71.63,34.11,38.89,67.66,77.13,46.56,53.08,29.54,33.68,7.25,8.27]
["Megaflex","Me",3,1,"Me31Y",null,null,"> 900km","< 500V",232.73,265.31,70.510000000000005,80.38,38.29,43.65,75.92,86.55,52.25,59.57,33.15,37.79,6.45,7.35]
["Megaflex","Me",3,2,"Me32Y",null,null,null,"≥ 500V & < 66kV",229.49,261.62,69.510000000000005,79.239999999999995,37.75,43.04,74.849999999999994,85.33,51.51,58.72,32.68,37.26,5.92,6.75]
["Megaflex","Me",3,3,"Me33Y",null,null,null,"≥ 66kV & ≤ 132kV",222.24,253.35,67.319999999999993,76.739999999999995,36.56,41.68,72.489999999999995,82.64,49.89,56.87,31.65,36.08,5.73,6.53]
["Megaflex","Me",3,4,"Me34Y",null,null,null,"> 132kV*",209.42,238.74,63.47,72.36,34.49,39.32,68.349999999999994,77.92,47.05,53.64,29.87,34.049999999999997,7.3,8.32]
[null,null,null,null,null,null,null,null,{"$f":"'Megaflex inc'!I24","v":"* >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 access charge [R/kVA/m]",null,"Network demand charge [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,null,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,null,"VAT incl"]
["Megaflex","Me",0,1,"Me01Y",null,null,"< 500V",null,12.57,14.33,23.83,27.17,0,0,null,"< 500V",null,0.28999999999999998,0.33]
["Megaflex","Me",0,2,"Me02Y",null,null,"≥ 500V & < 66kV",null,11.53,13.14,21.86,24.92,0,0,null,"≥ 500V & < 66kV",null,0.28000000000000003,0.32]
["Megaflex","Me",0,3,"Me03Y",null,null,"≥ 66kV & ≤ 132kV",null,4.12,4.7,7.62,8.69,10.09,11.5,null,"≥ 66kV & ≤ 132kV",null,0.27,0.31]
["Megaflex","Me",0,4,"Me04Y",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.09,11.5,null,"> 132kV / Transmission connected",null,0.25,0.28999999999999998]
[]
[]
[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,"Me01Y",null,null,"> 1 MVA",null,143.59,163.69,64.72,73.78,null,null,null,10.1,11.51,0,0]
["Megaflex","Me",0,1,"Me01Y",null,null,"Key customers",null,2813.83,3207.77,89.86,102.44]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge\n [c/kWh]"]
[]
[null,null,null,null,null,null,null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl"]
["Megaflex","Me",0,1,"Me01Y",null,null,5.59,6.37]

{"sheet":"Genflex Urban inc","index":5,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":true,"merged":[[38,7,38,8],[41,7,42,8],[41,9,42,10],[43,7,43,8],[43,9,43,10],[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],[35,16,35,19],[36,7,36,8],[36,16,36,17],[36,18,36,19],[27,18,27,19],[28,7,28,8],[28,16,28,17],[29,7,29,8],[29,16,29,17],[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],[11,7,14,7],[1,6,1,16],[1,17,1,22],[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],[5,19,5,20],[7,7,10,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Non-municipal",null,null,null,null,null,"Genflex Urban tariff",null,null,null,null,null,null,null,null,null,null,{"$f":"Menu!$B$4","v":"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"]
["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",220.91,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":251.84},67.209999999999994,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":76.62},36.68,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":41.82},72.34,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":82.47},49.92,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":56.91},31.82,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":36.270000000000003},5.85,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":6.67}]
["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",217.43,247.87,65.87,75.09,35.770000000000003,40.78,70.930000000000007,80.86,48.82,55.65,30.97,35.31,5.35,6.1]
["Genflex urban loads","GU",0,3,"GU03N",null,null,null,"≥ 66kV & ≤ 132kV",210.56,240.04,63.79,72.72,34.630000000000003,39.479999999999997,68.69,78.31,47.28,53.9,29.99,34.19,5.21,5.94]
["Genflex urban loads","GU",0,4,"GU04N",null,null,null,"> 132kV*",198.45,226.23,60.11,68.53,32.65,37.22,64.739999999999995,73.8,44.55,50.79,28.27,32.229999999999997,6.58,7.5]
["Genflex urban loads","GU",1,1,"GU11N",null,null,"> 300km and \n≤ 600km","< 500V",222.71,253.89,67.47,76.92,36.64,41.77,72.66,82.83,50.01,57.01,31.73,36.17,5.9,6.73]
["Genflex urban loads","GU",1,2,"GU12N",null,null,null,"≥ 500V & < 66kV",219.61,250.36,66.53,75.84,36.130000000000003,41.19,71.650000000000006,81.680000000000007,49.31,56.21,31.28,35.659999999999997,5.4,6.16]
["Genflex urban loads","GU",1,3,"GU13N",null,null,null,"≥ 66kV & ≤ 132kV",212.63,242.4,64.41,73.430000000000007,34.97,39.869999999999997,69.36,79.069999999999993,47.73,54.41,30.28,34.520000000000003,5.25,5.99]
["Genflex urban loads","GU",1,4,"GU14N",null,null,null,"> 132kV*",200.42,228.48,60.71,69.209999999999994,32.97,37.590000000000003,65.38,74.53,45,51.3,28.54,32.54,6.65,7.58]
["Genflex urban loads","GU",2,1,"GU21N",null,null,"> 600km and \n≤ 900km","< 500V",224.93,256.42,68.13,77.67,36.99,42.17,73.37,83.64,50.5,57.57,32.04,36.53,5.97,6.81]
["Genflex urban loads","GU",2,2,"GU22N",null,null,null,"≥ 500V & < 66kV",221.81,252.86,67.2,76.61,36.49,41.6,72.36,82.49,49.79,56.76,31.59,36.01,5.44,6.2]
["Genflex urban loads","GU",2,3,"GU23N",null,null,null,"≥ 66kV & ≤ 132kV",214.79,244.86,65.069999999999993,74.180000000000007,35.32,40.26,70.06,79.87,48.22,54.97,30.58,34.86,5.29,6.03]
["Genflex urban loads","GU",2,4,"GU24N",null,null,null,"> 132kV*",202.44,230.78,61.33,69.92,33.31,37.97,66.040000000000006,75.290000000000006,45.45,51.81,28.84,32.880000000000003,6.74,7.68]
["Genflex urban loads","GU",3,1,"GU31N",null,null,"> 900km","< 500V",227.19,259,68.83,78.47,37.380000000000003,42.61,74.12,84.5,51.01,58.15,32.36,36.89,5.99,6.83]
["Genflex urban loads","GU",3,2,"GU32N",null,null,null,"≥ 500V & < 66kV",224.02,255.38,67.86,77.36,36.840000000000003,42,73.069999999999993,83.3,50.28,57.32,31.9,36.369999999999997,5.51,6.28]
["Genflex urban loads","GU",3,3,"GU33N",null,null,null,"≥ 66kV & ≤ 132kV",216.95,247.32,65.72,74.92,35.69,40.69,70.760000000000005,80.67,48.71,55.53,30.9,35.229999999999997,5.32,6.06]
["Genflex urban loads","GU",3,4,"GU34N",null,null,null,"> 132kV*",204.44,233.06,61.96,70.63,33.67,38.380000000000003,66.72,76.06,45.93,52.36,29.16,33.24,6.79,7.74]
[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 access charge [R/kVA/m]",null,"Network demand charge [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,null,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,null,"VAT incl"]
["Genflex urban loads","GU",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"< 500V",null,12.56,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":14.32},23.81,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":27.14},0,{"$f":"ROUND(N30 * (1 + VAT), 2)","v":0},null,"< 500V",null,0.28999999999999998,{"$f":"ROUND(S30 * (1 + VAT), 2)","v":0.33}]
["Genflex urban loads","GU",0,2,{"$f":"B31&C31&D31&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU02N"},null,null,"≥ 500V & < 66kV",null,11.53,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":13.14},21.85,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":24.91},0,{"$f":"ROUND(N31 * (1 + VAT), 2)","v":0},null,"≥ 500V & < 66kV",null,0.28999999999999998,{"$f":"ROUND(S31 * (1 + VAT), 2)","v":0.33}]
["Genflex urban loads","GU",0,3,"GU03N",null,null,"≥ 66kV & ≤ 132kV",null,4.1100000000000003,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":4.6900000000000004},7.62,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":8.69},9.39,{"$f":"ROUND(N32 * (1 + VAT), 2)","v":10.7},null,"≥ 66kV & ≤ 132kV",null,0.28000000000000003,{"$f":"ROUND(S32 * (1 + VAT), 2)","v":0.32}]
["Genflex urban loads","GU",0,4,"GU04N",null,null,"> 132kV / Transmission connected",null,0,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":0},0,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":0},9.39,{"$f":"ROUND(N33 * (1 + VAT), 2)","v":10.7},null,"> 132kV / Transmission connected",null,0.24,{"$f":"ROUND(S33 * (1 + VAT), 2)","v":0.27}]
[]
[]
[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"]
["Genflex urban loads","GU",0,1,{"$f":"B39&C39&D39&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,"> 1 MVA",null,0,{"$f":"ROUND(J39 * (1 + VAT), 2)","v":0},11.9,{"$f":"ROUND(L39 * (1 + VAT), 2)","v":13.57},null,null,null,10.15,{"$f":"ROUND(Q39 * (1 + VAT), 2)","v":11.57},0,{"$f":"ROUND(S39 * (1 + VAT), 2)","v":0}]
["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,"Key customers",null,0,{"$f":"ROUND(J40 * (1 + VAT), 2)","v":0},11.9,{"$f":"ROUND(L40 * (1 + VAT), 2)","v":13.57}]
[]
[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,"All seasons",null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Genflex urban loads","GU",0,1,{"$f":"B46&C46&D46&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GU01N"},null,null,5.62,{"$f":"ROUND(H46 * (1 + VAT), 2)","v":6.41},2.2400000000000002,{"$f":"ROUND(J46 * (1 + VAT), 2)","v":2.5499999999999998}]

{"sheet":"Nightsave Large inc","index":6,"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],[44,7,44,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,7,43,8],[42,9,43,10]]}
[]
["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,"NL01N",null,null,"≤ 300km","< 500V",54.56,62.2,42.42,48.36,166.01,189.25,23.2,26.45,6.32,7.2]
["Nightsave Large","NL",0,2,"NL02N",null,null,null,"≥ 500V & < 66kV",51.67,58.9,40.33,45.98,160.68,183.18,22.46,25.6,5.78,6.59]
["Nightsave Large","NL",0,3,"NL03N",null,null,null,"≥ 66kV & ≤ 132kV",51.29,58.47,39.840000000000003,45.42,154.83000000000001,176.51,21.64,24.67,5.63,6.42]
["Nightsave Large","NL",0,4,"NL04N",null,null,null,"> 132kV*",47.98,54.7,37.31,42.53,149.36000000000001,170.27,20.87,23.79,7.11,8.11]
["Nightsave Large","NL",1,1,"NL11N",null,null,"> 300km and \n≤ 600km","< 500V",55.29,63.03,42.88,48.88,167.73,191.21,23.43,26.71,6.37,7.26]
["Nightsave Large","NL",1,2,"NL12N",null,null,null,"≥ 500V & < 66kV",52.75,60.14,41.15,46.91,162.31,185.03,22.66,25.83,5.83,6.65]
["Nightsave Large","NL",1,3,"NL13N",null,null,null,"≥ 66kV & ≤ 132kV",52.36,59.69,40.65,46.34,156.37,178.26,21.85,24.91,5.67,6.46]
["Nightsave Large","NL",1,4,"NL14N",null,null,null,"> 132kV*",48.98,55.84,38.07,43.4,150.88,172,21.07,24.02,7.18,8.19]
["Nightsave Large","NL",2,1,"NL21N",null,null,"> 600km and \n≤ 900km","< 500V",55.81,63.62,43.3,49.36,169.44,193.16,23.67,26.98,6.45,7.35]
["Nightsave Large","NL",2,2,"NL22N",null,null,null,"≥ 500V & < 66kV",53.28,60.74,41.57,47.39,163.94,186.89,22.91,26.12,5.88,6.7]
["Nightsave Large","NL",2,3,"NL23N",null,null,null,"≥ 66kV & ≤ 132kV",52.88,60.28,41.06,46.81,157.94,180.05,22.06,25.15,5.71,6.51]
["Nightsave Large","NL",2,4,"NL24N",null,null,null,"> 132kV*",49.46,56.38,38.46,43.84,152.38999999999999,173.72,21.28,24.26,7.28,8.3000000000000007]
["Nightsave Large","NL",3,1,"NL31N",null,null,"> 900km","< 500V",56.4,64.3,43.74,49.86,171.09,195.04,23.9,27.25,6.47,7.38]
["Nightsave Large","NL",3,2,"NL32N",null,null,null,"≥ 500V & < 66kV",53.79,61.32,41.97,47.85,165.59,188.77,23.11,26.35,5.95,6.78]
["Nightsave Large","NL",3,3,"NL33N",null,null,null,"≥ 66kV & ≤ 132kV",53.42,60.9,41.47,47.28,159.55000000000001,181.89,22.29,25.41,5.75,6.56]
["Nightsave Large","NL",3,4,"NL34N",null,null,null,"> 132kV*",49.99,56.99,38.880000000000003,44.32,153.93,175.48,21.49,24.5,7.33,8.36]
[null,null,null,null,null,null,null,null,{"$f":"'Megaflex inc'!I24","v":"* >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 access charge [R/kVA/m]",null,"Network demand charge [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,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,"VAT incl"]
["Nightsave Large","NL",0,1,"NL01N",null,null,"< 500V",null,12.56,14.32,23.81,27.14,0,0,null,"< 500V",0.28999999999999998,0.33]
["Nightsave Large","NL",0,2,"NL02N",null,null,"≥ 500V & < 66kV",null,11.52,13.13,21.85,24.91,0,0,null,"≥ 500V & < 66kV",0.28000000000000003,0.32]
["Nightsave Large","NL",0,3,"NL03N",null,null,"≥ 66kV & ≤ 132kV",null,4.1100000000000003,4.6900000000000004,7.61,8.68,10.14,11.56,null,"≥ 66kV & ≤ 132kV",0.27,0.31]
["Nightsave Large","NL",0,4,"NL04N",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.14,11.56,null,"> 132kV*",0.25,0.28999999999999998]
[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,"NL01N",null,null,">1  MVA",144.18,164.37,64.98,74.08]
["Nightsave Large","NL",0,1,"NL01N",null,null,"Key customers",2825.34,3220.89,90.23,102.86]
[]
[]
[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,null,"All seasons",null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Large","NL",0,1,"NL01N",null,null,5.62,6.41,2.2400000000000002,2.5499999999999998]

{"sheet":"Nightsave Large Munic inc","index":7,"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],[3,17,3,18],[4,7,6,7],[4,9,5,10],[4,11,5,12],[4,13,5,14],[4,15,5,16],[4,17,5,18],[32,7,32,8],[7,7,10,7],[11,7,14,7],[15,7,18,7],[19,7,22,7],[25,7,25,14],[26,9,27,10],[26,11,27,12],[26,13,27,14],[27,17,27,18],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[35,7,36,7],[35,8,36,9],[35,10,36,11],[42,7,43,8],[44,7,44,8]]}
[]
["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,"NL01Y",null,null,"≤ 300km","< 500V",55.89,63.71,43.46,49.54,166.88,190.24,23.32,26.58,6.3,7.18,null,null,{"$f":"(N8-'[7]Nightsave Large Munic inc'!$I$8)/'[7]Nightsave Large Munic inc'!$I$8","v":8.0619050702583614E-2}]
["Nightsave Large","NL",0,2,"NL02Y",null,null,null,"≥ 500V & < 66kV",52.93,60.34,41.31,47.09,161.52000000000001,184.13,22.58,25.74,5.75,6.56]
["Nightsave Large","NL",0,3,"NL03Y",null,null,null,"≥ 66kV & ≤ 132kV",52.54,59.9,40.799999999999997,46.51,155.63999999999999,177.43,21.75,24.8,5.6,6.38]
["Nightsave Large","NL",0,4,"NL04Y",null,null,null,"> 132kV*",49.15,56.03,38.22,43.57,150.13999999999999,171.16,20.97,23.91,7.08,8.07]
["Nightsave Large","NL",1,1,"NL11Y",null,null,"> 300km and \n≤ 600km","< 500V",56.63,64.56,43.93,50.08,168.61,192.22,23.55,26.85,6.34,7.23]
["Nightsave Large","NL",1,2,"NL12Y",null,null,null,"≥ 500V & < 66kV",54.03,61.59,42.15,48.05,163.15,185.99,22.78,25.97,5.81,6.62]
["Nightsave Large","NL",1,3,"NL13Y",null,null,null,"≥ 66kV & ≤ 132kV",53.63,61.14,41.65,47.48,157.19,179.2,21.97,25.05,5.64,6.43]
["Nightsave Large","NL",1,4,"NL14Y",null,null,null,"> 132kV*",50.17,57.19,39,44.46,151.66,172.89,21.18,24.15,7.15,8.15]
["Nightsave Large","NL",2,1,"NL21Y",null,null,"> 600km and \n≤ 900km","< 500V",57.17,65.17,44.35,50.56,170.32,194.16,23.79,27.12,6.42,7.32]
["Nightsave Large","NL",2,2,"NL22Y",null,null,null,"≥ 500V & < 66kV",54.57,62.21,42.59,48.55,164.8,187.87,23.03,26.25,5.86,6.68]
["Nightsave Large","NL",2,3,"NL23Y",null,null,null,"≥ 66kV & ≤ 132kV",54.17,61.75,42.07,47.96,158.76,180.99,22.17,25.27,5.69,6.49]
["Nightsave Large","NL",2,4,"NL24Y",null,null,null,"> 132kV*",50.67,57.76,39.39,44.9,153.19,174.64,21.4,24.4,7.25,8.27]
["Nightsave Large","NL",3,1,"NL31Y",null,null,"> 900km","< 500V",57.77,65.86,44.8,51.07,171.99,196.07,24.03,27.39,6.45,7.35]
["Nightsave Large","NL",3,2,"NL32Y",null,null,null,"≥ 500V & < 66kV",55.11,62.83,43,49.02,166.44,189.74,23.23,26.48,5.92,6.75]
["Nightsave Large","NL",3,3,"NL33Y",null,null,null,"≥ 66kV & ≤ 132kV",54.71,62.37,42.48,48.43,160.37,182.82,22.41,25.55,5.73,6.53]
["Nightsave Large","NL",3,4,"NL34Y",null,null,null,"> 132kV*",51.22,58.39,39.83,45.41,154.74,176.4,21.6,24.62,7.3,8.32]
[null,null,null,null,null,null,null,null,{"$f":"'Nightsave Large inc'!I24","v":"* >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 access charge [R/kVA/m]",null,"Network demand charge [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,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,"VAT incl"]
["Nightsave Large","NL",0,1,"NL01Y",null,null,"< 500V",null,12.57,14.33,23.83,27.17,0,0,null,"< 500V",0.28999999999999998,0.33]
["Nightsave Large","NL",0,2,"NL02Y",null,null,"≥ 500V & < 66kV",null,11.53,13.14,21.86,24.92,0,0,null,"≥ 500V & < 66kV",0.28000000000000003,0.32]
["Nightsave Large","NL",0,3,"NL03Y",null,null,"≥ 66kV & ≤ 132kV",null,4.12,4.7,7.62,8.69,10.09,11.5,null,"≥ 66kV & ≤ 132kV",0.27,0.31]
["Nightsave Large","NL",0,4,"NL04Y",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.09,11.5,null,"> 132kV*",0.25,0.28999999999999998]
[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,"NL01Y",null,null,">1  MVA",143.59,163.69,64.72,73.78]
["Nightsave Large","NL",0,1,"NL01Y",null,null,"Key customers",2813.83,3207.77,89.86,102.44]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge [c/kWh]"]
[]
[null,null,null,null,null,null,null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl"]
["Nightsave Large","NL",0,1,"NL01Y",null,null,5.59,6.37]

{"sheet":"Miniflex inc","index":8,"n_rows":45,"n_cols":33,"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],[25,7,26,8],[27,7,27,8],[27,15,27,16],[27,17,27,18],[27,20,27,22],[28,7,28,8],[37,7,37,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,7,36,8],[35,9,36,10],[35,14,36,17],[29,7,29,8]]}
[null,null,null,null,null,null,null,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,null,null,{"$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 access 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",null,null,null,null,null,null,null,null,null,"nac test"]
["Miniflex","Mi",0,1,"Mi01N",null,null,"≤ 300km","< 500V",220.91,251.84,67.209999999999994,76.62,36.69,41.83,72.34,82.47,49.92,56.91,31.82,36.270000000000003,18.86,21.5,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",0,2,"Mi02N",null,null,null,"≥ 500V & < 66kV",217.44,247.88,65.87,75.09,35.770000000000003,40.78,70.930000000000007,80.86,48.82,55.65,30.97,35.31,17.28,19.7,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",0,3,"Mi03N",null,null,null,"≥ 66kV & ≤ 132kV",210.56,240.04,63.78,72.709999999999994,34.64,39.49,68.69,78.31,47.27,53.89,29.99,34.19,9.7100000000000009,11.07,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",0,4,"Mi04N",null,null,null,"> 132kV*",198.45,226.23,60.11,68.53,32.65,37.22,64.739999999999995,73.8,44.55,50.79,28.27,32.229999999999997,7.07,8.06,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",1,1,"Mi11N",null,null,"> 300km and \n≤ 600km","< 500V",222.71,253.89,67.48,76.930000000000007,36.64,41.77,72.650000000000006,82.82,50.01,57.01,31.73,36.17,18.899999999999999,21.55,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",1,2,"Mi12N",null,null,null,"≥ 500V & < 66kV",219.61,250.36,66.53,75.84,36.130000000000003,41.19,71.650000000000006,81.680000000000007,49.3,56.2,31.28,35.659999999999997,17.329999999999998,19.760000000000002,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",1,3,"Mi13N",null,null,null,"≥ 66kV & ≤ 132kV",212.63,242.4,64.41,73.430000000000007,34.97,39.869999999999997,69.36,79.069999999999993,47.73,54.41,30.28,34.520000000000003,9.75,11.12,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",1,4,"Mi14N",null,null,null,"> 132kV*",200.43,228.49,60.72,69.22,32.96,37.57,65.37,74.52,44.99,51.29,28.54,32.54,7.15,8.15,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",2,1,"Mi21N",null,null,"> 600km and \n≤ 900km","< 500V",224.93,256.42,68.13,77.67,36.99,42.17,73.38,83.65,50.5,57.57,32.03,36.51,18.989999999999998,21.65,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",2,2,"Mi22N",null,null,null,"≥ 500V & < 66kV",221.81,252.86,67.2,76.61,36.49,41.6,72.36,82.49,49.8,56.77,31.59,36.01,17.38,19.809999999999999,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",2,3,"Mi23N",null,null,null,"≥ 66kV & ≤ 132kV",214.79,244.86,65.069999999999993,74.180000000000007,35.33,40.28,70.06,79.87,48.22,54.97,30.59,34.869999999999997,9.8000000000000007,11.17,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",2,4,"Mi24N",null,null,null,"> 132kV*",202.45,230.79,61.32,69.900000000000006,33.31,37.97,66.040000000000006,75.290000000000006,45.45,51.81,28.84,32.880000000000003,7.25,8.27,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",3,1,"Mi31N",null,null,"> 900km","< 500V",227.19,259,68.84,78.48,37.380000000000003,42.61,74.12,84.5,51.01,58.15,32.369999999999997,36.9,19.010000000000002,21.67,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",3,2,"Mi32N",null,null,null,"≥ 500V & < 66kV",224.02,255.38,67.86,77.36,36.840000000000003,42,73.069999999999993,83.3,50.28,57.32,31.9,36.369999999999997,17.45,19.89,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",3,3,"Mi33N",null,null,null,"≥ 66kV & ≤ 132kV",216.95,247.32,65.72,74.92,35.68,40.68,70.760000000000005,80.67,48.71,55.53,30.9,35.229999999999997,9.84,11.22,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Miniflex","Mi",3,4,"Mi34N",null,null,null,"> 132kV*",204.43,233.05,61.96,70.63,33.659999999999997,38.369999999999997,66.72,76.06,45.93,52.36,29.16,33.24,7.3,8.32,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,{"$f":"'Nightsave Large Munic inc'!I24","v":"* >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,"Reliability 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,"Mi01N",null,null,"≤ 100 kVA",null,10.25,11.69,2.25,2.57,null,"Voltage",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 100 kVA & ≤ 500 kVA",null,46.85,53.41,13.13,14.97,null,"< 500V",0.28999999999999998,0.33,11.66,13.29,null,"< 500V",0,0]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 500 kVA & ≤ 1 MVA",null,144.18,164.37,26.1,29.75,null,"≥ 500V & < 66kV",0.28000000000000003,0.32,4.8899999999999997,5.57,null,"≥ 500V & < 66kV",0,0]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 1 MVA",null,144.18,164.37,64.98,74.08,null,"≥ 66kV & ≤ 132kV",0.27,0.31,1.7,1.94,null,"≥ 66kV & ≤ 132kV",10.14,11.56]
["Miniflex","Mi",0,1,"Mi01N",null,null,"Key customers",null,2825.34,3220.89,90.23,102.86,null,"> 132kV*",0.25,0.28999999999999998,0,0,null,"> 132kV*",10.14,11.56]
[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,"All seasons",null,"All seasons",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,"Mi01N",null,null,5.62,6.41,2.2400000000000002,2.5499999999999998,null,null,null,4.43,5.05,0,0]
[]
["Miniflex","Mi",0,1,"Mi01N"]
["Miniflex","Mi",1,2,"Mi12N"]
["Miniflex","Mi",2,3,"Mi23N"]
["Miniflex","Mi",3,4,"Mi34N"]

{"sheet":"Miniflex Munic inc ","index":9,"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,7,26,8],[25,9,26,10],[25,11,26,12],[37,7,37,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,7,36,8],[35,11,36,14]]}
[]
["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 access 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"]
["Miniflex","Mi",0,1,"Mi01Y",null,null,"≤ 300km","< 500V",226.3,257.98,68.86,78.5,37.58,42.84,74.099999999999994,84.47,51.13,58.29,32.590000000000003,37.15,18.87,21.51]
["Miniflex","Mi",0,2,"Mi02Y",null,null,null,"≥ 500V & < 66kV",222.73,253.91,67.48,76.930000000000007,36.64,41.77,72.66,82.83,50.01,57.01,31.73,36.17,17.29,19.71]
["Miniflex","Mi",0,3,"Mi03Y",null,null,null,"≥ 66kV & ≤ 132kV",215.7,245.9,65.34,74.489999999999995,35.479999999999997,40.450000000000003,70.36,80.209999999999994,48.43,55.21,30.72,35.020000000000003,9.7100000000000009,11.07]
["Miniflex","Mi",0,4,"Mi04Y",null,null,null,"> 132kV*",203.29,231.75,61.58,70.2,33.44,38.119999999999997,66.319999999999993,75.599999999999994,45.64,52.03,28.96,33.01,7.08,8.07]
["Miniflex","Mi",1,1,"Mi11Y",null,null,"> 300km and \n≤ 600km","< 500V",228.14,260.08,69.12,78.8,37.53,42.78,74.430000000000007,84.85,51.23,58.4,32.5,37.049999999999997,18.91,21.56]
["Miniflex","Mi",1,2,"Mi12Y",null,null,null,"≥ 500V & < 66kV",224.96,256.45,68.150000000000006,77.69,37.01,42.19,73.39,83.66,50.51,57.58,32.04,36.53,17.34,19.77]
["Miniflex","Mi",1,3,"Mi13Y",null,null,null,"≥ 66kV & ≤ 132kV",217.81,248.3,65.98,75.22,35.82,40.83,71.05,81,48.9,55.75,31.01,35.35,9.76,11.13]
["Miniflex","Mi",1,4,"Mi14Y",null,null,null,"> 132kV*",205.31,234.05,62.2,70.91,33.770000000000003,38.5,66.959999999999994,76.33,46.1,52.55,29.24,33.33,7.15,8.15]
["Miniflex","Mi",2,1,"Mi21Y",null,null,"> 600km and \n≤ 900km","< 500V",230.42,262.68,69.8,79.569999999999993,37.9,43.21,75.16,85.68,51.73,58.97,32.82,37.409999999999997,19,21.66]
["Miniflex","Mi",2,2,"Mi22Y",null,null,null,"≥ 500V & < 66kV",227.22,259.02999999999997,68.83,78.47,37.380000000000003,42.61,74.13,84.51,51,58.14,32.36,36.89,17.39,19.82]
["Miniflex","Mi",2,3,"Mi23Y",null,null,null,"≥ 66kV & ≤ 132kV",220.03,250.83,66.650000000000006,75.98,36.19,41.26,71.760000000000005,81.81,49.39,56.3,31.33,35.72,9.8000000000000007,11.17]
["Miniflex","Mi",2,4,"Mi24Y",null,null,null,"> 132kV*",207.38,236.41,62.83,71.63,34.11,38.89,67.66,77.13,46.56,53.08,29.54,33.68,7.25,8.27]
["Miniflex","Mi",3,1,"Mi31Y",null,null,"> 900km","< 500V",232.73,265.31,70.510000000000005,80.38,38.29,43.65,75.92,86.55,52.25,59.57,33.15,37.79,19.02,21.68]
["Miniflex","Mi",3,2,"Mi32Y",null,null,null,"≥ 500V & < 66kV",229.49,261.62,69.510000000000005,79.239999999999995,37.75,43.04,74.849999999999994,85.33,51.51,58.72,32.68,37.26,17.46,19.899999999999999]
["Miniflex","Mi",3,3,"Mi33Y",null,null,null,"≥ 66kV & ≤ 132kV",222.24,253.35,67.319999999999993,76.739999999999995,36.56,41.68,72.489999999999995,82.64,49.89,56.87,31.65,36.08,9.84,11.22]
["Miniflex","Mi",3,4,"Mi34Y",null,null,null,"> 132kV*",209.42,238.74,63.47,72.36,34.49,39.32,68.349999999999994,77.92,47.05,53.64,29.87,34.049999999999997,7.3,8.32]
[null,null,null,null,null,null,null,null,{"$f":"'Miniflex inc'!I24","v":"* >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,"Reliability 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,"Mi01Y",null,null,"≤ 100 kVA",null,10.210000000000001,11.64,2.2400000000000002,2.5499999999999998,null,"Voltage",null,"VAT incl",null,"VAT incl",null,null,null,"VAT incl"]
["Miniflex","Mi",0,1,"Mi01Y",null,null,"> 100 kVA & ≤ 500 kVA",null,46.66,53.19,13.08,14.91,null,"< 500V",0.28999999999999998,0.33,11.67,13.3,null,"< 500V",0,0]
["Miniflex","Mi",0,1,"Mi01Y",null,null,"> 500 kVA & ≤ 1 MVA",null,143.59,163.69,26,29.64,null,"≥ 500V & < 66kV",0.28000000000000003,0.32,4.9000000000000004,5.59,null,"≥ 500V & < 66kV",0,0]
["Miniflex","Mi",0,1,"Mi01Y",null,null,"> 1 MVA",null,143.59,163.69,64.72,73.78,null,"≥ 66kV & ≤ 132kV",0.27,0.31,1.7,1.94,null,"≥ 66kV & ≤ 132kV",10.09,11.5]
["Miniflex","Mi",0,1,"Mi01Y",null,null,"Key customers",null,2813.83,3207.77,89.86,102.44,null,"> 132kV*",0.25,0.28999999999999998,0,0,null,"> 132kV*",10.09,11.5]
[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,"All seasons",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,"Mi01Y",null,null,5.59,6.37,null,null,4.42,5.04,0,0]
[]
["Miniflex","Mi",0,1,"Mi01Y"]
["Miniflex","Mi",1,2,"Mi12Y"]
["Miniflex","Mi",2,3,"Mi23Y"]
["Miniflex","Mi",3,4,"Mi34Y"]

{"sheet":"Nightsave Small inc","index":10,"n_rows":48,"n_cols":33,"rows_kept":48,"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],[28,7,28,8],[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]]}
[]
["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,{"$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,"NS01N",null,null,"≤ 300km","< 500V",54.56,62.2,42.42,48.36,116.59,132.91,15.02,17.12,6.32,7.2]
["Nightsave Small","NS",0,2,"NS02N",null,null,null,"≥ 500V & < 66kV",51.67,58.9,40.33,45.98,112.84,128.63999999999999,14.52,16.55,5.78,6.59]
["Nightsave Small","NS",0,3,"NS03N",null,null,null,"≥ 66kV & ≤ 132kV",51.29,58.47,39.840000000000003,45.42,108.69,123.91,13.98,15.94,5.63,6.42]
["Nightsave Small","NS",0,4,"NS04N",null,null,null,"> 132kV*",47.98,54.7,37.31,42.53,104.89,119.57,13.49,15.38,7.11,8.11]
["Nightsave Small","NS",1,1,"NS11N",null,null,"> 300km and \n≤ 600km","< 500V",55.29,63.03,42.88,48.88,117.78,134.27000000000001,15.15,17.27,6.37,7.26]
["Nightsave Small","NS",1,2,"NS12N",null,null,null,"≥ 500V & < 66kV",52.75,60.14,41.15,46.91,113.98,129.94,14.66,16.71,5.83,6.65]
["Nightsave Small","NS",1,3,"NS13N",null,null,null,"≥ 66kV & ≤ 132kV",52.36,59.69,40.65,46.34,109.81,125.18,14.13,16.11,5.67,6.46]
["Nightsave Small","NS",1,4,"NS14N",null,null,null,"> 132kV*",48.98,55.84,38.07,43.4,105.94,120.77,13.63,15.54,7.18,8.19]
["Nightsave Small","NS",2,1,"NS21N",null,null,"> 600km and \n≤ 900km","< 500V",55.81,63.62,43.3,49.36,118.94,135.59,15.29,17.43,6.45,7.35]
["Nightsave Small","NS",2,2,"NS22N",null,null,null,"≥ 500V & < 66kV",53.28,60.74,41.57,47.39,115.14,131.26,14.81,16.88,5.88,6.7]
["Nightsave Small","NS",2,3,"NS23N",null,null,null,"≥ 66kV & ≤ 132kV",52.88,60.28,41.06,46.81,110.91,126.44,14.27,16.27,5.71,6.51]
["Nightsave Small","NS",2,4,"NS24N",null,null,null,"> 132kV*",49.46,56.38,38.46,43.84,106.98,121.96,13.76,15.69,7.28,8.3000000000000007]
["Nightsave Small","NS",3,1,"NS31N",null,null,"> 900km","< 500V",56.4,64.3,43.74,49.86,120.15,136.97,15.45,17.61,6.47,7.38]
["Nightsave Small","NS",3,2,"NS32N",null,null,null,"≥ 500V & < 66kV",53.79,61.32,41.97,47.85,116.27,132.55000000000001,14.96,17.05,5.95,6.78]
["Nightsave Small","NS",3,3,"NS33N",null,null,null,"≥ 66kV & ≤ 132kV",53.42,60.9,41.47,47.28,112.04,127.73,14.42,16.440000000000001,5.75,6.56]
["Nightsave Small","NS",3,4,"NS34N",null,null,null,"> 132kV*",49.99,56.99,38.880000000000003,44.32,108.1,123.23,13.92,15.87,7.33,8.36]
[null,null,null,null,null,null,null,null,{"$f":"'Miniflex Munic inc '!I24","v":"* >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 access 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,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,"VAT incl"]
["Nightsave Small","NS",0,1,"NS01N",null,null,"< 500V",null,12.56,14.32,23.81,27.14,0,0,null,"< 500V",0.28999999999999998,0.33]
["Nightsave Small","NS",0,2,"NS02N",null,null,"≥ 500V & < 66kV",null,11.52,13.13,21.85,24.91,0,0,null,"≥ 500V & < 66kV",0.28000000000000003,0.32]
["Nightsave Small","NS",0,3,"NS03N",null,null,"≥ 66kV & ≤ 132kV",null,4.1100000000000003,4.6900000000000004,7.61,8.68,10.14,11.56,null,"≥ 66kV & ≤ 132kV",0.27,0.31]
["Nightsave Small","NS",0,4,"NS04N",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.14,11.56,null,"> 132kV*",0.25,0.28999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I24","v":"* >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,"NS01N",null,null,"≤ 100 kVA",10.25,11.69,2.25,2.57]
["Nightsave Small","NS",0,1,"NS01N",null,null,"> 100 kVA & ≤ 500 kVA",46.85,53.41,13.13,14.97]
["Nightsave Small","NS",0,1,"NS01N",null,null,"> 500 kVA & ≤ 1 MVA",144.18,164.37,26.1,29.75]
["Nightsave Small","NS",0,1,"NS01N",null,null,"Key customers",{"$f":"'Miniflex inc'!J33","v":2825.34},{"$f":"'Miniflex inc'!K33","v":3220.89},{"$f":"'Miniflex inc'!L33","v":90.23},{"$f":"'Miniflex inc'!M33","v":102.86}]
[]
[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,null,null,null,"All seasons"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,"VAT incl",null,"VAT incl"]
["Nightsave Small","NS",0,1,"NS01N",null,null,5.62,6.41,2.2400000000000002,2.5499999999999998]

{"sheet":"Nightsave Small Munic inc","index":11,"n_rows":48,"n_cols":33,"rows_kept":48,"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],[28,7,28,8],[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]]}
[]
["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,{"$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,"NS01Y",null,null,"≤ 300km","< 500V",55.89,63.71,43.46,49.54,117.19,133.6,15.11,17.23,6.3,7.18]
["Nightsave Small","NS",0,2,"NS02Y",null,null,null,"≥ 500V & < 66kV",52.93,60.34,41.31,47.09,113.43,129.31,14.59,16.63,5.75,6.56]
["Nightsave Small","NS",0,3,"NS03Y",null,null,null,"≥ 66kV & ≤ 132kV",52.54,59.9,40.799999999999997,46.51,109.26,124.56,14.05,16.02,5.6,6.38]
["Nightsave Small","NS",0,4,"NS04Y",null,null,null,"> 132kV*",49.15,56.03,38.22,43.57,105.43,120.19,13.56,15.46,7.08,8.07]
["Nightsave Small","NS",1,1,"NS11Y",null,null,"> 300km and \n≤ 600km","< 500V",56.63,64.56,43.93,50.08,118.4,134.97999999999999,15.23,17.36,6.34,7.23]
["Nightsave Small","NS",1,2,"NS12Y",null,null,null,"≥ 500V & < 66kV",54.03,61.59,42.15,48.05,114.58,130.62,14.73,16.79,5.81,6.62]
["Nightsave Small","NS",1,3,"NS13Y",null,null,null,"≥ 66kV & ≤ 132kV",53.63,61.14,41.65,47.48,110.39,125.84,14.2,16.190000000000001,5.64,6.43]
["Nightsave Small","NS",1,4,"NS14Y",null,null,null,"> 132kV*",50.17,57.19,39,44.46,106.49,121.4,13.7,15.62,7.15,8.15]
["Nightsave Small","NS",2,1,"NS21Y",null,null,"> 600km and \n≤ 900km","< 500V",57.17,65.17,44.35,50.56,119.57,136.31,15.37,17.52,6.42,7.32]
["Nightsave Small","NS",2,2,"NS22Y",null,null,null,"≥ 500V & < 66kV",54.57,62.21,42.59,48.55,115.73,131.93,14.88,16.96,5.86,6.68]
["Nightsave Small","NS",2,3,"NS23Y",null,null,null,"≥ 66kV & ≤ 132kV",54.17,61.75,42.07,47.96,111.49,127.1,14.34,16.350000000000001,5.69,6.49]
["Nightsave Small","NS",2,4,"NS24Y",null,null,null,"> 132kV*",50.67,57.76,39.39,44.9,107.54,122.6,13.83,15.77,7.25,8.27]
["Nightsave Small","NS",3,1,"NS31Y",null,null,"> 900km","< 500V",57.77,65.86,44.8,51.07,120.78,137.69,15.53,17.7,6.45,7.35]
["Nightsave Small","NS",3,2,"NS32Y",null,null,null,"≥ 500V & < 66kV",55.11,62.83,43,49.02,116.88,133.24,15.03,17.13,5.92,6.75]
["Nightsave Small","NS",3,3,"NS33Y",null,null,null,"≥ 66kV & ≤ 132kV",54.71,62.37,42.48,48.43,112.62,128.38999999999999,14.49,16.52,5.73,6.53]
["Nightsave Small","NS",3,4,"NS34Y",null,null,null,"> 132kV*",51.22,58.39,39.83,45.41,108.67,123.88,13.99,15.95,7.3,8.32]
[null,null,null,null,null,null,null,null,{"$f":"'Nightsave Small inc'!I24","v":"* >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 access 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,null,"Reliability service charge [c/kWh]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage",null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"Voltage",null,"VAT incl"]
["Nightsave Small","NS",0,1,"NS01Y",null,null,"< 500V",null,12.57,14.33,23.83,27.17,0,0,null,"< 500V",0.28999999999999998,0.33]
["Nightsave Small","NS",0,2,"NS02Y",null,null,"≥ 500V & < 66kV",null,11.53,13.14,21.86,24.92,0,0,null,"≥ 500V & < 66kV",0.28000000000000003,0.32]
["Nightsave Small","NS",0,3,"NS03Y",null,null,"≥ 66kV & ≤ 132kV",null,4.12,4.7,7.62,8.69,10.09,11.5,null,"≥ 66kV & ≤ 132kV",0.27,0.31]
["Nightsave Small","NS",0,4,"NS04Y",null,null,"> 132kV / Transmission connected",null,0,0,0,0,10.09,11.5,null,"> 132kV*",0.25,0.28999999999999998]
[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,"NS01Y",null,null,"≤ 100 kVA",10.210000000000001,11.64,2.2400000000000002,2.5499999999999998]
["Nightsave Small","NS",0,1,"NS01Y",null,null,"> 100 kVA & ≤ 500 kVA",46.66,53.19,13.08,14.91]
["Nightsave Small","NS",0,1,"NS01Y",null,null,"> 500 kVA & ≤ 1 MVA",143.59,163.69,26,29.64]
["Nightsave Small","NS",0,1,"NS01Y",null,null,"Key customers",{"$f":"'Miniflex Munic inc '!J33","v":2813.83},{"$f":"'Miniflex Munic inc '!K33","v":3207.77},{"$f":"'Miniflex Munic inc '!L33","v":89.86},{"$f":"'Miniflex Munic inc '!M33","v":102.44}]
[]
[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,"NS01Y",null,null,5.59,6.37]

{"sheet":"Ruraflex inc","index":12,"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]]}
[]
["Non-municipal",null,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,{"$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 access 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,"Ru01N",null,null,"≤ 300km","< 500V",228.74,260.76,69.3,79,37.630000000000003,42.9,74.62,85.07,51.35,58.54,32.58,37.14,13.2,15.05]
["Ruraflex","Ru",0,2,"Ru02N",null,null,null,"≥ 500V & ≤ 22kV",226.48,258.19,68.61,78.22,37.25,42.47,73.88,84.22,50.84,57.96,32.25,36.770000000000003,12.1,13.79]
["Ruraflex","Ru",null,null,"RuN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,"RuN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",1,1,"Ru11N",null,null,"> 300km and \n≤ 600km","< 500V",231.03,263.37,69.989999999999995,79.790000000000006,38.01,43.33,75.36,85.91,51.87,59.13,32.909999999999997,37.520000000000003,13.25,15.11]
["Ruraflex","Ru",1,2,"Ru12N",null,null,null,"≥ 500V & ≤ 22kV",228.73,260.75,69.290000000000006,78.989999999999995,37.630000000000003,42.9,74.62,85.07,51.34,58.53,32.58,37.14,12.18,13.89]
["Ruraflex","Ru",null,null,"RuN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,"RuN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",2,1,"Ru21N",null,null,"> 600km and \n≤ 900km","< 500V",233.34,266.01,70.69,80.59,38.380000000000003,43.75,76.12,86.78,52.38,59.71,33.24,37.89,13.32,15.18]
["Ruraflex","Ru",2,2,"Ru22N",null,null,null,"≥ 500V & ≤ 22kV",231.02,263.36,69.98,79.78,38.01,43.33,75.36,85.91,51.87,59.13,32.909999999999997,37.520000000000003,12.23,13.94]
["Ruraflex","Ru",null,null,"RuN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",null,null,"RuN",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Ruraflex","Ru",3,1,"Ru31N",null,null,"> 900km","< 500V",235.67,268.66000000000003,71.400000000000006,81.400000000000006,38.76,44.19,76.87,87.63,52.91,60.32,33.57,38.270000000000003,13.37,15.24]
["Ruraflex","Ru",3,2,"Ru32N",null,null,null,"≥ 500V & ≤ 22kV",233.33,266,70.69,80.59,38.380000000000003,43.75,76.12,86.78,52.38,59.71,33.24,37.89,12.24,13.95]
[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,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]        \n     [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.28999999999999998,0.33,18.8,21.43]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"≤ 100 kVA",null,12.99,14.81,3.69,4.21,null,"≥ 500V & < 22kV",null,0.28999999999999998,0.33,16.48,18.79]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 100 kVA & ≤ 500 kVA",null,44.32,50.52,20.54,23.42]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 500 kVA & ≤ 1 MVA",null,136.33000000000001,155.41999999999999,31.53,35.94,null,"Reactive energy charge  [c/kVArh]"]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 1 MVA",null,136.33000000000001,155.41999999999999,58.51,66.7,null,"High season",null,"Low season"]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"Key customers",null,2671.9,3045.97,58.51,66.7,null,null,"VAT incl",null,"VAT incl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.35,7.24,0,0]

{"sheet":"Ruraflex Munic inc","index":13,"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]]}
[]
["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,{"$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 access 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,"Ru01Y",null,null,"≤ 300km","< 500V",234.32,267.12,70.98,80.92,38.549999999999997,43.95,76.44,87.14,52.61,59.98,33.369999999999997,38.04,13.32,15.18]
["Ruraflex","Ru",0,2,"Ru02Y",null,null,null,"≥ 500V & ≤ 22kV",231.99,264.47000000000003,70.28,80.12,38.159999999999997,43.5,75.69,86.29,52.07,59.36,33.03,37.65,12.22,13.93]
["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",236.66,269.79000000000002,71.7,81.739999999999995,38.92,44.37,77.2,88.01,53.13,60.57,33.71,38.43,13.38,15.25]
["Ruraflex","Ru",1,2,"Ru12Y",null,null,null,"≥ 500V & ≤ 22kV",234.31,267.11,70.97,80.91,38.549999999999997,43.95,76.44,87.14,52.6,59.96,33.369999999999997,38.04,12.3,14.02]
["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",239.03,272.49,72.400000000000006,82.54,39.32,44.82,77.97,88.89,53.65,61.16,34.049999999999997,38.82,13.45,15.33]
["Ruraflex","Ru",2,2,"Ru22Y",null,null,null,"≥ 500V & ≤ 22kV",236.65,269.77999999999997,71.69,81.73,38.92,44.37,77.2,88.01,53.13,60.57,33.71,38.43,12.35,14.08]
["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",241.42,275.22000000000003,73.14,83.38,39.700000000000003,45.26,78.739999999999995,89.76,54.2,61.79,34.380000000000003,39.19,13.5,15.39]
["Ruraflex","Ru",3,2,"Ru32Y",null,null,null,"≥ 500V & ≤ 22kV",239.02,272.48,72.400000000000006,82.54,39.32,44.82,77.97,88.89,53.65,61.16,34.049999999999997,38.82,12.36,14.09]
[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,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]        \n     [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.28999999999999998,0.33,19,21.66]
["Ruraflex","Ru",0,1,"Ru01Y",null,null,"≤ 100 kVA",null,12.95,14.76,3.68,4.2,null,"≥ 500V & < 22kV",null,0.28999999999999998,0.33,16.64,18.97]
["Ruraflex","Ru",0,1,"Ru01Y",null,null,"> 100 kVA & ≤ 500 kVA",null,44.14,50.32,20.46,23.32]
["Ruraflex","Ru",0,1,"Ru01Y",null,null,"> 500 kVA & ≤ 1 MVA",null,135.78,154.79,31.4,35.799999999999997,null,"Reactive energy charge  [c/kVArh]"]
["Ruraflex","Ru",0,1,"Ru01Y",null,null,"> 1 MVA",null,135.78,154.79,58.28,66.44,null,"High season",null,"Low season"]
["Ruraflex","Ru",0,1,"Ru01Y",null,null,"Key customers",null,2661,3033.54,58.28,66.44,null,null,"VAT incl",null,"VAT incl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.32,7.2,0,0]

{"sheet":"Genflex Rural inc","index":14,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":true,"merged":[[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],[25,16,25,17],[25,18,25,19],[26,14,26,15],[27,7,27,8],[27,14,27,15],[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],[7,7,10,7],[1,6,1,16],[1,17,1,18],[1,19,1,22],[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],[5,19,5,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
["Non-municipal",null,null,null,null,null,"Genflex Rural 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 [c/kWh]",null,null,null,null,null,null,null,null,null,null,null,"Network access 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",228.74,{"$f":"ROUND(J8 * (1 + VAT), 2)","v":260.76},69.3,{"$f":"ROUND(L8 * (1 + VAT), 2)","v":79},37.630000000000003,{"$f":"ROUND(N8 * (1 + VAT), 2)","v":42.9},74.62,{"$f":"ROUND(P8 * (1 + VAT), 2)","v":85.07},51.36,{"$f":"ROUND(R8 * (1 + VAT), 2)","v":58.55},32.58,{"$f":"ROUND(T8 * (1 + VAT), 2)","v":37.14},13.19,{"$f":"ROUND(V8 * (1 + VAT), 2)","v":15.04}]
["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",226.47,258.18,68.61,78.22,37.25,42.47,73.88,84.22,50.84,57.96,32.25,36.770000000000003,10.08,11.49]
["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",231.03,263.37,69.989999999999995,79.790000000000006,38,43.32,75.37,85.92,51.87,59.13,32.909999999999997,37.520000000000003,13.95,15.9]
["Genflex rural","GR",1,2,"GR12N",null,null,null,"≥ 500V & ≤ 22kV",228.73,260.75,69.290000000000006,78.989999999999995,37.630000000000003,42.9,74.62,85.07,51.35,58.54,32.58,37.14,10.16,11.58]
["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",233.34,266.01,70.680000000000007,80.58,38.39,43.76,76.11,86.77,52.38,59.71,33.24,37.89,14.03,15.99]
["Genflex rural","GR",2,2,"GR22N",null,null,null,"≥ 500V & ≤ 22kV",231.02,263.36,69.98,79.78,38,43.32,75.37,85.92,51.87,59.13,32.909999999999997,37.520000000000003,10.24,11.67]
["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",235.67,268.66000000000003,71.400000000000006,81.400000000000006,38.76,44.19,76.87,87.63,52.91,60.32,33.57,38.270000000000003,14.11,16.09]
["Genflex rural","GR",3,2,"GR32N",null,null,null,"≥ 500V & ≤ 22kV",233.33,266,70.680000000000007,80.58,38.39,43.76,76.11,86.77,52.38,59.71,33.24,37.89,10.32,11.76]
[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,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]        \n     [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.28999999999999998,{"$f":"ROUND(Q28 * (1 + VAT), 2)","v":0.33},18.809999999999999,{"$f":"ROUND(S28 * (1 + VAT), 2)","v":21.44}]
["Genflex rural","GR",0,1,{"$f":"B29&C29&D29&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"≤ 100 kVA",null,12.99,{"$f":"ROUND(J29 * (1 + VAT), 2)","v":14.81},3.7,{"$f":"ROUND(L29 * (1 + VAT), 2)","v":4.22},null,"≥ 500V & < 22kV",null,0.28999999999999998,{"$f":"ROUND(Q29 * (1 + VAT), 2)","v":0.33},16.48,{"$f":"ROUND(S29 * (1 + VAT), 2)","v":18.79}]
["Genflex rural","GR",0,1,{"$f":"B30&C30&D30&IF($A$2=\"Non-municipal\",\"N\",IF($A$2=\"Municiple\",\"Y\",\"error\"))","v":"GR01N"},null,null,"> 100 kVA & ≤ 500 kVA",null,44.32,{"$f":"ROUND(J30 * (1 + VAT), 2)","v":50.52},20.54,{"$f":"ROUND(L30 * (1 + VAT), 2)","v":23.42}]
["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,"> 500 kVA & ≤ 1 MVA",null,136.33000000000001,{"$f":"ROUND(J31 * (1 + VAT), 2)","v":155.41999999999999},31.53,{"$f":"ROUND(L31 * (1 + VAT), 2)","v":35.94},null,"Reactive energy charge  [c/kVArh]"]
["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,"> 1 MVA",null,136.33000000000001,{"$f":"ROUND(J32 * (1 + VAT), 2)","v":155.41999999999999},58.52,{"$f":"ROUND(L32 * (1 + VAT), 2)","v":66.709999999999994},null,"High season",null,"Low season"]
["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,"Key customers",null,2671.9,{"$f":"ROUND(J33 * (1 + VAT), 2)","v":3045.97},58.52,{"$f":"ROUND(L33 * (1 + VAT), 2)","v":66.709999999999994},null,null,"VAT incl",null,"VAT incl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.35,{"$f":"ROUND(O34 * (1 + VAT), 2)","v":7.24},0,{"$f":"ROUND(Q34 * (1 + VAT), 2)","v":0}]

{"sheet":"Nightsave Rural inc","index":15,"n_rows":34,"n_cols":33,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,6,1,15],[1,16,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,null,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,"Non-local authority",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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 access 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,"NR01N",null,null,"≤ 300km","< 500V",55.79,63.6,43.35,49.42,186.94,213.11,98.94,112.79,9.4499999999999993,10.77]
["Nightsave Rural","NR",0,2,"NR02N",null,null,null,"≥ 500V & ≤ 22kV",55.13,62.85,42.87,48.87,181.14,206.5,95.42,108.78,8.68,9.9]
["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",56.34,64.23,43.78,49.91,189.19,215.68,100.31,114.35,9.48,10.81]
["Nightsave Rural","NR",1,2,"NR12N",null,null,null,"≥ 500V & ≤ 22kV",55.7,63.5,43.3,49.36,183.36,209.03,96.75,110.3,8.7200000000000006,9.94]
["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",56.91,64.88,44.22,50.41,191.46,218.26,101.66,115.89,9.57,10.91]
["Nightsave Rural","NR",2,2,"NR22N",null,null,null,"≥ 500V & ≤ 22kV",56.24,64.11,43.73,49.85,185.55,211.53,98.09,111.82,8.7799999999999994,10.01]
["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",57.47,65.52,44.66,50.91,193.78,220.91,103.06,117.49,9.58,10.92]
["Nightsave Rural","NR",3,2,"NR32N",null,null,null,"≥ 500V & ≤ 22kV",56.79,64.739999999999995,44.15,50.33,187.82,214.11,99.46,113.38,8.7899999999999991,10.02]
[]
[]
[]
[]
[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,"NR01N",null,null,"≤ 100 kVA",null,12.99,14.81,3.69,4.21]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"> 100 kVA & ≤ 500 kVA",null,44.32,50.52,20.54,23.42,null,null,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]         \n       [All time of use periods]"]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"> 500 kVA & ≤ 1 MVA",null,136.33000000000001,155.41999999999999,31.53,35.94,null,"Voltage",null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"> 1 MVA",null,136.33000000000001,155.41999999999999,58.51,66.7,null,"< 500V",0.28999999999999998,0.33,18.8,21.43]
["Nightsave Rural","NR",0,1,"NR01N",null,null,"Key customers",null,2671.9,3045.97,58.51,66.7,null,"≥ 500V & ≤ 22kV",0.28999999999999998,0.33,16.48,18.79]
["Nightsave Rural","NR",0,2,"NR02N"]

{"sheet":"Nightsave Rural Munic inc ","index":16,"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,null,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,{"$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 access 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,"NR01Y",null,null,"≤ 300km","< 500V",57.15,65.150000000000006,44.41,50.63,187.04,213.23,98.99,112.85,9.5500000000000007,10.89]
["Nightsave Rural","NR",0,2,"NR02Y",null,null,null,"≥ 500V & ≤ 22kV",56.48,64.39,43.92,50.07,181.24,206.61,95.47,108.84,8.77,10]
["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",57.73,65.81,44.86,51.14,189.3,215.8,100.37,114.42,9.57,10.91]
["Nightsave Rural","NR",1,2,"NR12Y",null,null,null,"≥ 500V & ≤ 22kV",57.04,65.03,44.35,50.56,183.46,209.14,96.8,110.35,8.81,10.039999999999999]
["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",58.29,66.45,45.29,51.63,191.57,218.39,101.72,115.96,9.66,11.01]
["Nightsave Rural","NR",2,2,"NR22Y",null,null,null,"≥ 500V & ≤ 22kV",57.61,65.680000000000007,44.79,51.06,185.66,211.65,98.14,111.88,8.86,10.1]
["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",58.87,67.11,45.74,52.14,193.89,221.03,103.12,117.56,9.67,11.02]
["Nightsave Rural","NR",3,2,"NR32Y",null,null,null,"≥ 500V & ≤ 22kV",58.18,66.33,45.22,51.55,187.93,214.24,99.51,113.44,8.8699999999999992,10.11]
[]
[]
[]
[]
[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,"NR01Y",null,null,"≤ 100 kVA",null,12.95,14.76,3.68,4.2]
["Nightsave Rural","NR",0,1,"NR01Y",null,null,"> 100 kVA & ≤ 500 kVA",null,44.14,50.32,20.46,23.32,null,null,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]         \n       [All time of use periods]"]
["Nightsave Rural","NR",0,1,"NR01Y",null,null,"> 500 kVA & ≤ 1 MVA",null,135.78,154.79,31.4,35.799999999999997,null,"Voltage",null,"VAT incl",null,"VAT incl"]
["Nightsave Rural","NR",0,1,"NR01Y",null,null,"> 1 MVA",null,135.78,154.79,58.28,66.44,null,"< 500V",0.28999999999999998,0.33,19,21.66]
["Nightsave Rural","NR",0,1,"NR01Y",null,null,"Key customers",null,2661,3033.54,58.28,66.44,null,"≥ 500V & ≤ 22kV",0.28999999999999998,0.33,16.64,18.97]

{"sheet":"Businessrate inc","index":17,"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]]}
[]
["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,"Reliability service charge [c/kWh]",null,"Network demand charge \n [c/kWh]",null,"Network access 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,"B101N",null,null,"Businessrate 1",null,75.64,86.23,0.28999999999999998,0.33,10.68,12.18,15.33,17.48,13.25,15.11,null,null,null,null,null,null,0,0,0,0]
["Businessrate 2","B2",0,1,"B201N",null,null,"Businessrate 2",null,75.64,86.23,0.28999999999999998,0.33,10.68,12.18,25.83,29.45,13.25,15.11,null,null,null,null,null,null,0,0,0,0]
["Businessrate 3","B3",0,1,"B301N",null,null,"Businessrate 3",null,75.64,86.23,0.28999999999999998,0.33,10.68,12.18,44.64,50.89,13.25,15.11,null,null,null,null,null,null,0,0,0,0]
["Businessrate 4","B4",0,1,"B401N",null,null,"Businessrate 4",null,203.54,232.04,0.28999999999999998,0.33,10.68,12.18,null,null,null,null,null,null,null,null,null,null,0,0,0,0]

{"sheet":"Businessrate Munic inc","index":18,"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]]}
[]
["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,"Reliability service charge [c/kWh]",null,"Network demand charge       [c/kWh]",null,"Network access charge [R/POD/day]",null,"Service and administration charge  [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,"B101Y",null,null,"Businessrate 1",null,77.48,88.33,0.28999999999999998,0.33,10.74,12.24,15.41,17.57,13.19,15.04,null,null,null,null,null,null,0,0,0,0]
["Businessrate 2","B2",0,1,"B201Y",null,null,"Businessrate 2",null,77.48,88.33,0.28999999999999998,0.33,10.74,12.24,25.97,29.61,13.19,15.04,null,null,null,null,null,null,0,0,0,0]
["Businessrate 3","B3",0,1,"B301Y",null,null,"Businessrate 3",null,77.48,88.33,0.28999999999999998,0.33,10.74,12.24,44.88,51.16,13.19,15.04,null,null,null,null,null,null,0,0,0,0]
["Businessrate 4","B4",0,1,"B401Y",null,null,"Businessrate 4",null,208.5,237.69,0.28999999999999998,0.33,10.74,12.24,null,null,null,null,null,null,null,null,null,null,0,0,0,0]

{"sheet":"Homepower inc","index":19,"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]]}
[]
["Non-municipal",null,null,null,null,null,null,"Homepower",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 access 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,"H101N",null,null,"Homepower 1",null,88.65,101.06,139.97,159.57,3.8,4.33]
["Homepower 2","H2",0,1,"H201N",null,null,"Homepower 2",null,88.65,101.06,136.47,155.58000000000001,7.12,8.1199999999999992]
["Homepower 3","H3",0,1,"H301N",null,null,"Homepower 3",null,88.65,101.06,136.47,155.58000000000001,14.69,16.75]
["Homepower 4","H4",0,1,"H401N",null,null,"Homepower 4",null,88.65,101.06,142.55000000000001,162.51,2.3199999999999998,2.64]
[]
[null,null,null,null,null,null,null,null,null,"Energy charge  \n[c/kWh]",null,"Network access charge [R/kVA]"]
[null,null,null,null,null,null,null,null,null,null,"VAT incl",null,"VAT incl"]
["Homepower Bulk < 500V","HB",0,1,"HB01N",null,null,"Homepower Bulk*\n",null,116.38,132.66999999999999,24.08,27.45]
[null,null,null,null,null,null,null,"* The network access charge is based on the NMD or on the maximum demand if measured."]

{"sheet":"Homepower Munic inc","index":20,"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]]}
[]
["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 access 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,"H101Y",null,null,"Homepower 1",null,88.7,101.12,140.05000000000001,159.66,3.8,4.33]
["Homepower 2","H2",0,1,"H201Y",null,null,"Homepower 2",null,88.7,101.12,136.54,155.66,7.12,8.1199999999999992]
["Homepower 3","H3",0,1,"H301Y",null,null,"Homepower 3",null,88.7,101.12,136.54,155.66,14.7,16.760000000000002]
["Homepower 4","H4",0,1,"H401Y",null,null,"Homepower 4",null,88.7,101.12,142.63,162.6,2.3199999999999998,2.64]

{"sheet":"Public Lighting inc","index":21,"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]]}
[]
["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,"Pu01N",null,null,"Public Lighting","Energy charge [c/kWh]",null,62.23,70.94,83.33,95]
["Public lighting All Night","Pa",0,1,"Pa01N",null,null,null,"Energy charge [R/100W/month]",null,19.48,22.21,56.13,63.99]
[]
["Public lighting Urban fixed","Pt",0,1,"Pt01N",null,null,"Public Lighting - Urban Fixed","Fixed charge [R/POD/day]",null,4.09,4.66]
[]
[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,"Plu01N",null,null,null,null,"Per lumanaire",33,37.619999999999997]
["Public Lighting - Maintenance charge - per high-mast lumanaire","Plhm",0,1,"Plhm01N",null,null,null,null,"Per high-mast lumanaire",768.26,875.82]

{"sheet":"Homelight inc","index":22,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,7,1,11],[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]]}
[]
["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,"HL1601N",null,null,"Block 1   [> 0 - 600 kWh]",null,83.87,95.61]
["Homelight 2 60A","HL26",0,1,"HL2601N",null,null,"Block 2   [>600 kWh]",null,142.55000000000001,162.51]
[]
[]
[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,"HL1201N",null,null,"Block 1   [> 0 - 350 kWh]",null,77.319999999999993,88.14]
["Homelight 2 20A","HL22",0,1,"HL2201N",null,null,"Block 2   [>350 kWh]",null,84.57,96.41]

{"sheet":"Public Lighting Munic inc","index":23,"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]]}
[]
["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,{"$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,"Pu01Y",null,null,"Public Lighting","Energy charge [c/kWh]",null,63.76,72.69,85.37,97.32]
["Public lighting All Night","Pa",0,1,"Pa01Y",null,null,null,"Energy charge [R/100W/month]",null,19.48,22.21,56.13,63.99]
[]
["Public lighting Urban fixed","Pt",0,1,"Pt01Y",null,null,"Public Lighting - Urban Fixed","Fixed charge [R/POD/day]",null,4.1924337617164253,4.78]
[]
[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,"Plu01Y",null,null,null,null,"Per lumanaire",33.64,38.35]
["Public Lighting - Maintenance charge - per high-mast lumanaire","Plhm",0,1,"Plhm01Y",null,null,null,null,"Per high-mast lumanaire",785.73,895.73]

{"sheet":"Landrate inc","index":24,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,17,3,18],[10,7,10,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]]}
[]
["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,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]",null,"Network  access 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,"L101N",null,null,"Landrate 1",null,75.27,85.81,0.28999999999999998,0.33,18.8,21.43,20.100000000000001,22.91,16.690000000000001,19.03]
["Landrate 2","L2",0,1,"L201N",null,null,"Landrate 2",null,75.27,85.81,0.28999999999999998,0.33,18.8,21.43,30.9,35.229999999999997,16.690000000000001,19.03]
["Landrate 3","L3",0,1,"L301N",null,null,"Landrate 3",null,75.27,85.81,0.28999999999999998,0.33,18.8,21.43,49.4,56.32,16.690000000000001,19.03]
["Landrate 4","L4",0,1,"L401N",null,null,"Landrate 4",null,162.56,185.32,0.28999999999999998,0.33,18.8,21.43,16.010000000000002,18.25,0,0]
["Landlight","Lt",0,1,"Lt01N",null,null,"Landlight",null,277.95999999999998,316.87]
["Landrate Dx","Ld",0,1,"Ld01N",null,null,"Landrate Dx",null,null,null,null,null,null,null,null,null,35.802243175623914,40.81]

{"sheet":"Landrate Munic inc","index":25,"n_rows":10,"n_cols":19,"rows_kept":10,"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]]}
[]
["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,"Reliability service charge [c/kWh]",null,"Network demand charge [c/kWh]",null,"Network access 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,"L101Y",null,null,"Landrate 1",null,77.099999999999994,87.89,0.28999999999999998,0.33,19,21.66,20.29,23.13,16.62,18.95]
["Landrate 2","L2",0,1,"L201Y",null,null,"Landrate 2",null,77.099999999999994,87.89,0.28999999999999998,0.33,19,21.66,31.2,35.57,16.62,18.95]
["Landrate 3","L3",0,1,"L301Y",null,null,"Landrate 3",null,77.099999999999994,87.89,0.28999999999999998,0.33,19,21.66,49.89,56.87,16.62,18.95]
["Landrate 4","L4",0,1,"L401Y",null,null,"Landrate 4",null,166.52,189.83,0.28999999999999998,0.33,19,21.66,16.170000000000002,18.43]
["Landrate Dx","Ld",0,1,"Ld01Y",null,null,"Landrate Dx",null,null,null,null,null,null,null,null,null,35.958982828511978,40.99]

{"sheet":"Homeflex REDESIGN inc","index":26,"n_rows":14,"n_cols":30,"rows_kept":14,"cut":false,"hidden":true,"merged":[[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,7,3,8],[5,3,6,3],[7,3,8,3],[9,3,10,3],[11,3,12,3],[1,1,1,8],[3,5,3,6]]}
[]
[null,"Homeflex",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,null,null,{"$f":"SUM(F6,J6:J16,L6:N16)","v":1059.4399999999996},"check value"]
[]
[null,null,null,null,null,"Peak energy charge [c/kWh]",null,"Off peak energy charge [c/kWh]",null,"Service & administration charge  [c/kWh]",null,"Network demand charge [c/kWh]",null,"Network access charge [R/POD/day]"]
[null,null,null,null,null,null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl",null,"VAT incl"]
[null,null,null,"Homeflex 1","High Demand",210.70000000000002,{"$f":"ROUND(F6 * (1 + VAT), 2)","v":240.2},48.1,{"$f":"ROUND(H6 * (1 + VAT), 2)","v":54.83},25.74,29.34,34.04,38.81,4.05,4.62]
[null,null,null,null,"Low Demand",69.2,{"$f":"ROUND(F7 * (1 + VAT), 2)","v":78.89},38.160000000000004,43.5,25.74,29.34,34.04,38.81,{"$f":"N6","v":4.05},4.62]
[null,null,null,"Homeflex 2","High Demand",210.70000000000002,240.2,48.1,54.83,25.74,29.34,34.04,38.81,7.53,8.58]
[null,null,null,null,"Low Demand",69.2,78.89,38.160000000000004,43.5,25.74,29.34,34.04,38.81,{"$f":"N8","v":7.53},8.58]
[null,null,null,"Homeflex 3","High Demand",210.70000000000002,240.2,48.1,54.83,25.74,29.34,34.04,38.81,16.010000000000002,18.25]
[null,null,null,null,"Low Demand",69.2,78.89,38.160000000000004,43.5,25.74,29.34,34.04,38.81,{"$f":"N10","v":16.010000000000002},18.25]
[null,null,null,"Homeflex 4","High Demand",210.70000000000002,240.2,48.1,54.83,25.74,29.34,34.04,38.81,2.42,2.76]
[null,null,null,null,"Low Demand",69.2,78.89,38.160000000000004,43.5,25.74,29.34,34.04,38.81,{"$f":"N12","v":2.42},2.76]
[null,null,null,null,null,"The network access charge is a R/kVA charge and is based on the Notified Maximum Demand (NMD)."]

{"sheet":"TOuS Original","index":27,"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":12.96}]
[null,null,null,"≥ 500V & < 66kV",11.194005362854275,12.76]
[null,null,null,"≥ 66kV & ≤ 132kV",10.836206104680851,12.35]
[null,null,"> 300km & ≤ 600km","< 500V",11.466614321462599,13.07]
[null,null,null,"≥ 500V & < 66kV",11.313271782245415,12.9]
[null,null,null,"≥ 66kV & ≤ 132kV",10.955472524071991,12.49]
[null,null,"> 600km & ≤ 900km","< 500V",11.585880740853739,13.21]
[null,null,null,"≥ 500V & < 66kV",11.432538201636557,13.03]
[null,null,null,"≥ 66kV & ≤ 132kV",11.057700883550114,12.61]
[null,null,"> 900km","< 500V",11.705147160244881,13.34]
[null,null,null,"≥ 500V & < 66kV",11.551804621027699,13.17]
[null,null,null,"≥ 66kV & ≤ 132kV",11.176967302941254,12.74]
[]
[]
[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.42}]
[null,null,null,"≥ 500V & < 66kV",11.671071040418839,13.31]
[null,null,"> 300km & ≤ 600km","< 500V",11.892565819288103,13.56]
[null,null,null,"≥ 500V & < 66kV",11.790337459809981,13.44]
[null,null,"> 600km & ≤ 900km","< 500V",12.011832238679244,13.69]
[null,null,null,"≥ 500V & < 66kV",11.909603879201123,13.58]
[null,null,"> 900km","< 500V",12.131098658070385,13.83]
[null,null,null,"≥ 500V & < 66kV",12.028870298592263,13.71]
[]
[]
[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.07},19.673247251813724,{"$f":"ROUND(F60 * (1 + VAT), 2)","v":22.43}]
[null,"≥ 500V & ≤ 22kV",null,2.2975559127207621,{"$f":"ROUND(D61 * (1 + VAT), 2)","v":2.62},17.238867254434076,{"$f":"ROUND(F61 * (1 + VAT), 2)","v":19.649999999999999}]
[]
[]
[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.72}]
[]
[]
[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.06},0.91,{"$f":"ROUND(F78 * (1 + VAT), 2)","v":1.04},3.59,{"$f":" ROUND(H78 * (1 + VAT), 2)","v":4.09}]
[]
[]
[]
[]
[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.82},2.08,{"$f":"ROUND(F87 * (1 + VAT), 2)","v":2.37}]
[null,"> 100 kVA & ≤ 500 kVA",null,43.38,{"$f":"ROUND(D88 * (1 + VAT), 2)","v":49.45},12.16,{"$f":"ROUND(F88 * (1 + VAT), 2)","v":13.86}]
[null,"> 500 kVA & ≤ 1 MVA",null,133.5,{"$f":"ROUND(D89 * (1 + VAT), 2)","v":152.19},24.17,{"$f":"ROUND(F89 * (1 + VAT), 2)","v":27.55}]
[null,"> 1 MVA",null,133.5,{"$f":"ROUND(D90 * (1 + VAT), 2)","v":152.19},60.17,{"$f":"ROUND(F90 * (1 + VAT), 2)","v":68.59}]
[null,"Key customers",null,2616.06,{"$f":"ROUND(D91 * (1 + VAT), 2)","v":2982.31},83.55,{"$f":"ROUND(F91 * (1 + VAT), 2)","v":95.25}]
[]
[]
[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'!O5","v":1.1111},{"$f":"'Loss Factors'!P5","v":1.1527000000000001},null,"0 to 300 km",0,{"$f":"'Loss Factors'!T5","v":1.0106999999999999}]
[null,"≥ 500V & < 66kV",{"$f":"'Loss Factors'!O6","v":1.0956999999999999},{"$f":"'Loss Factors'!P6","v":1.1412},null,"301 to 600 km",1,{"$f":"'Loss Factors'!T6","v":1.0207999999999999}]
[null,"≥ 66kV & ≤ 132kV",{"$f":"'Loss Factors'!O7","v":1.0610999999999999},null,null,"601 to 900 km",2,{"$f":"'Loss Factors'!T7","v":1.0309999999999999}]
[null,"> 132kV",{"$f":"'Loss Factors'!O8","v":1},null,null,"> 900 km",3,{"$f":"'Loss Factors'!T8","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":"TOuS","index":28,"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]]}
[]
["Non-municipal"]
[null,null,null,null,null,null,null,"TUoS\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,"Me01N",null,null,null,null,5.62,6.41]
[]
[]
[]
[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,"Mi01N",null,null,"≤ 100 kVA/kW",null,10.25,11.69,2.25,2.57]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 100 kVA/kW & ≤ 500 kVA/kW",null,46.85,53.41,13.13,14.97]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,144.18,164.37,26.1,29.75]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 1 MVA/MW",null,144.18,164.37,64.98,74.08]
["Miniflex","Mi",0,1,"Mi01N",null,null,"Key customers or Transmission connected generators",null,2825.34,3220.89,90.23,102.86]
[]
[]
[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,"TxLoss04N",null,null,"≤ 300km",0,1.0106999999999999]
["Transmission loss factor","TxLoss",1,4,"TxLoss14N",null,null,"> 300km & ≤ 600km",1,1.0207999999999999]
["Transmission loss factor","TxLoss",2,4,"TxLoss24N",null,null,"> 600km & ≤ 900km",2,1.0309999999999999]
["Transmission loss factor","TxLoss",3,4,"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,"GenTUOSCape4N",null,null,null,"Cape",0.97099999999999997]
["TUoS network charges for Transmission connected generators","GenTUOS","Karoo",4,"GenTUOSKaroo4N",null,null,null,"Karoo",0.995]
["TUoS network charges for Transmission connected generators","GenTUOS","Kwazulu-Natal",4,"GenTUOSKwazulu-Natal4N",null,null,null,"Kwazulu-Natal",1.004]
["TUoS network charges for Transmission connected generators","GenTUOS","Vaal",4,"GenTUOSVaal4N",null,null,null,"Vaal",1.02]
["TUoS network charges for Transmission connected generators","GenTUOS","Waterburg",4,"GenTUOSWaterburg4N",null,null,null,"Waterberg",1.0229999999999999]
["TUoS network charges for Transmission connected generators","GenTUOS","Mpumalanga",4,"GenTUOSMpumalanga4N",null,null,null,"Mpumalanga",1.0209999999999999]
[]
[]
[null,null,null,null,null,null,null,"TUoS  [ > 132kV]",null,"Network access charge\n[R/kVA]"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,null,"VAT incl"]
["WEPS","We",0,1,"We01N",null,null,null,"≤ 300km",7.11,8.11]
["WEPS","We",0,2,"We02N",null,null,null,"> 300km & ≤ 600km",7.18,8.19]
["WEPS","We",0,3,"We03N",null,null,null,"> 600km & ≤ 900km",7.28,8.3000000000000007]
["WEPS","We",0,4,"We04N",null,null,null,"> 900km",7.33,8.36]
[]
[]
[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,"GenTUOSCape4N",null,null,null,"Cape",0,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.49,1.7]
["TUoS network charges for Transmission connected generators","GenTUOS","Vaal",4,"GenTUOSVaal4N",null,null,null,"Vaal",4.97,5.67]
["TUoS network charges for Transmission connected generators","GenTUOS","Waterburg",4,"GenTUOSWaterburg4N",null,null,null,"Waterberg",6.37,7.26]
["TUoS network charges for Transmission connected generators","GenTUOS","Mpumalanga",4,"GenTUOSMpumalanga4N",null,null,null,"Mpumalanga",5.9,6.73]
[]
[]
[null,null,null,null,null,null,null,"Transmission connected reliability service charge",null,"Reliability 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,"GenTUOSCape4N",null,null,"Generators",null,0.25,0.28999999999999998]
["TUoS network charges for Transmission connected generators","GenTUOS","Cape",4,"GenTUOSCape4N",null,null,"Loads",null,0.25,0.28999999999999998]

{"sheet":"DUoS","index":29,"n_rows":125,"n_cols":21,"rows_kept":125,"cut":false,"hidden":false,"merged":[[108,7,108,8],[103,7,103,8],[104,7,104,8],[105,7,105,8],[106,7,106,8],[107,7,107,8],[98,7,98,12],[99,7,101,8],[99,9,101,10],[99,11,101,12],[102,7,102,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],[59,11,60,12],[58,7,58,12],[59,9,60,10],[49,11,50,12],[51,7,51,8],[62,7,62,8],[63,7,63,8],[55,7,55,8],[54,7,54,8],[49,9,50,10],[61,7,61,8],[6,7,7,8],[14,7,15,8],[14,9,14,10],[31,8,33,8],[22,7,33,7],[75,17,75,20],[110,7,110,9],[110,11,110,13],[76,13,77,14],[79,17,82,18],[76,19,77,20],[78,17,78,18],[75,7,75,14],[79,7,82,8],[96,7,96,8],[86,7,88,8],[92,7,92,8],[93,7,93,8],[85,7,85,12],[78,7,78,8],[90,7,90,8],[3,7,3,13],[86,9,88,10],[86,11,88,12],[94,7,94,8],[95,7,95,8],[91,7,91,8],[89,7,89,8],[76,11,77,12],[76,9,77,10],[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]]}
[]
["Non-Municipal"]
[]
[null,null,null,null,null,null,null,"DUoS"]
[]
[]
[null,null,null,null,null,null,null,"Reliability 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,"NEGenDUoSU01N",null,null,"< 500V",null,0.28999999999999998,0.33]
["Gen-DUoS urban","NEGenDUoSU",0,2,"NEGenDUoSU02N",null,null,"≥ 500V & < 66kV",null,0.28000000000000003,0.32]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,"≥ 66kV & ≤ 132kV",null,0.27,0.31]
[]
[]
[]
[null,null,null,null,null,null,null,"Reliability 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,"NEGenDUoSR01N",null,null,"< 500V",null,0.28999999999999998,0.33]
["Gen-DUoS rural","NEGenDUoSR",0,2,"NEGenDUoSR02N",null,null,"≥ 500V & ≤ 22kV",null,0.28999999999999998,0.33]
[]
[]
[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",6.32,7.2]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",5.78,6.59]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",5.63,6.42]
[null,null,null,null,null,null,null,null,"> 300km & ≤ 600km","< 500V",6.37,7.26]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",5.83,6.65]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",5.67,6.46]
[null,null,null,null,null,null,null,null,"> 600km & ≤ 900km","< 500V",6.45,7.35]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",5.88,6.7]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",5.71,6.51]
[null,null,null,null,null,null,null,null,"> 900km","< 500V",6.47,7.38]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",5.95,6.78]
[null,null,null,null,null,null,null,null,null,"≥ 66kV & ≤ 132kV",5.75,6.56]
[]
[]
[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",13.2,15.05]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",12.1,13.79]
[null,null,null,null,null,null,null,null,"> 300km & ≤ 600km","< 500V",13.25,15.11]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",12.18,13.89]
[null,null,null,null,null,null,null,null,"> 600km & ≤ 900km","< 500V",13.32,15.18]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",12.23,13.94]
[null,null,null,null,null,null,null,null,"> 900km","< 500V",13.37,15.24]
[null,null,null,null,null,null,null,null,null,"≥ 500V & < 66kV",12.24,13.95]
[]
[]
[null,null,null,null,null,null,null,"Distribution network charges urban"]
[null,null,null,null,null,null,null,null,null,"Network access 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,"NEGenDUoSU01N",null,null,"< 500V",null,12.56,14.32,23.81,27.14,0,0]
["Gen-DUoS urban","NEGenDUoSU",0,2,"NEGenDUoSU02N",null,null,"≥ 500V & < 66kV",null,11.52,13.13,21.85,24.91,0,0]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,"≥ 66kV & ≤ 132kV",null,4.1100000000000003,4.6900000000000004,7.61,8.68,10.14,11.56]
["Gen-DUoS urban","NEGenDUoSU",0,4,"NEGenDUoSU04N",null,null,"> 132kV",null,0,0,0,0,10.14,11.56]
[]
[]
[null,null,null,null,null,null,null,"Distribution network charges rural"]
[null,null,null,null,null,null,null,null,null,"Network access 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,"NEGenDUoSR01N",null,null,"< 500V",null,13.2,15.05,18.8,21.43]
["Gen-DUoS rural","NEGenDUoSR",0,2,"NEGenDUoSR02N",null,null,"≥ 500V & ≤ 22kV",null,12.1,13.79,16.48,18.79]
[]
[]
[null,null,null,null,null,null,null,"Distribution network charges for Generators"]
[null,null,null,null,null,null,null,null,null,"Network access charge    [R/kW/m]"]
[]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,"Voltage ",null,null,"VAT incl"]
["Gen-DUoS urban","NEGenDUoSU",0,1,"NEGenDUoSU01N",null,null,"< 500V"]
["Gen-DUoS urban","NEGenDUoSU",0,2,"NEGenDUoSU02N",null,null,"≥ 500V & < 66kV"]
["Gen-DUoS urban","NEGenDUoSU",0,3,"NEGenDUoSU03N",null,null,"≥ 66kV & ≤ 132kV",null,10.15,11.57]
[]
[]
[null,null,null,null,null,null,null,"Electrification and rural network subsidy charge [c/kWh]",null,null,null,null,null,null,null,null,null,"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,null,null,"Total 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,"Tariff",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,"Me01N",null,null,null,null,3.73,4.25,1.89,2.15,5.62,6.41,null,null,null,null,5.62,6.41]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Service and administration charges (urban )"]
[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,"Mi01N",null,null,"≤ 100 kVA/kW",null,10.25,11.69,2.25,2.57]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 100 kVA/kW & ≤ 500 kVA/kW",null,46.85,53.41,13.13,14.97]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,144.18,164.37,26.1,29.75]
["Miniflex","Mi",0,1,"Mi01N",null,null,"> 1 MVA/MW",null,144.18,164.37,64.98,74.08]
["Miniflex","Mi",0,1,"Mi01N",null,null,"Key customers or Transmission connected generators",null,2825.34,3220.89,90.23,102.86]
[]
[]
[null,null,null,null,null,null,null,"Service and administration charges (rural)"]
[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,"Ru01N",null,null,"≤ 100 kVA/kW",null,12.99,14.81,3.69,4.21]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 100 kVA/kW & ≤ 500 kVA/kW",null,44.32,50.52,20.54,23.42]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 500 kVA/kW & ≤ 1 MVA/MW",null,136.33000000000001,155.41999999999999,31.53,35.94]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"> 1 MVA/MW",null,136.33000000000001,155.41999999999999,58.51,66.7]
["Ruraflex","Ru",0,1,"Ru01N",null,null,"Key customers or Transmission connected generators",null,2671.9,3045.97,58.51,66.7]
[]
[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","Urban\nloss factor","Rural\nloss factor",null,"Distance from\nJohannesburg","Zone","Loss\nfactor"]
["Distribution loss factor - Urban","DxLossUrb",0,1,"DxLossUrb01N",null,null,"< 500V",1.1111,1.1527000000000001,null,"≤ 300km",0,1.0106999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,2,"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,"DxLossRur01N"]
["Distribution loss factor - Rural","DxLossRur",0,2,"DxLossRur02N"]
[]
[]
["Transmission loss factor","TxLoss",0,4,"TxLoss04N"]
["Transmission loss factor","TxLoss",1,4,"TxLoss14N"]
["Transmission loss factor","TxLoss",2,4,"TxLoss24N"]
["Transmission loss factor","TxLoss",3,4,"TxLoss34N"]

{"sheet":"Loss Factors","index":30,"n_rows":18,"n_cols":38,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,13,2,15],[2,17,2,19],[10,13,11,14],[10,15,11,15]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001]
["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,"DxLossUrb01N",null,"Transmission loss factor","TxLoss",0,4,"TxLoss04N",null,null,"< 500V",1.1111,1.1527000000000001,null,"≤ 300km",0,1.0106999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,2,"DxLossUrb02N",null,"Transmission loss factor","TxLoss",1,4,"TxLoss14N",null,null,"≥ 500V & < 66kV",1.0956999999999999,1.1412,null,"> 300km & ≤ 600km",1,1.0207999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,3,"DxLossUrb03N",null,"Transmission loss factor","TxLoss",2,4,"TxLoss24N",null,null,"≥ 66kV & ≤ 132kV",1.0610999999999999,null,null,"> 600km & ≤ 900km",2,1.0309999999999999]
["Distribution loss factor - Urban","DxLossUrb",0,4,"DxLossUrb04N",null,"Transmission loss factor","TxLoss",3,4,"TxLoss34N",null,null,"> 132kV/Transmission connected",1,null,null,"> 900km",3,1.0412999999999999]
[]
["Distribution loss factor - Rural","DxLossRur",0,1,"DxLossRur01N",null,null,null,null,null,null,null,null,null,null,"2012/13"]
["Distribution loss factor - Rural","DxLossRur",0,2,"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,"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":"Excess NAC","index":31,"n_rows":47,"n_cols":34,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,32,5,33],[38,18,41,18],[38,24,41,24],[38,30,41,30],[42,18,45,18],[42,24,45,24],[42,30,45,30],[30,18,33,18],[30,24,33,24],[30,30,33,30],[34,18,37,18],[34,24,37,24],[34,30,37,30],[26,32,26,33],[27,18,29,18],[27,20,28,21],[27,24,29,24],[27,26,28,27],[27,30,29,30],[27,32,28,33],[19,18,22,18],[19,24,22,24],[19,30,22,30],[26,20,26,21],[26,26,26,27],[7,30,10,30],[11,18,14,18],[11,24,14,24],[11,30,14,30],[15,18,18,18],[15,24,18,24],[15,30,18,30],[1,18,1,21],[24,18,24,21],[1,23,1,27],[1,29,1,33],[24,23,24,27],[24,29,24,33],[3,20,3,21],[3,26,3,27],[3,32,3,33],[4,18,6,18],[4,20,5,21],[4,24,6,24],[4,26,5,27],[4,30,6,30],[7,18,10,18],[7,24,10,24]]}
[]
["Non-municipal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban - Excess NAC\nMegaflex\n[non local authorities]",null,null,null,null,"Urban - Excess NAC\nNightsave Urban Large\n[non local authorities]",null,null,null,null,null,"Urban - Excess NAC\nMiniflex\n[non local authorities]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl"]
["Excess NAC Megaflex","ExNACMe",0,1,"ExNACMe01N",null,"Excess NAC Nightsave Large","ExNACNL",0,1,"ExNACNL01N",null,"Excess NAC Miniflex","ExNACMi",0,1,"ExNACMi01N",null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",0,2,"ExNACMe02N",null,"Excess NAC Nightsave Large","ExNACNL",0,2,"ExNACNL02N",null,"Excess NAC Miniflex","ExNACMi",0,2,"ExNACMi02N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",0,3,"ExNACMe03N",null,"Excess NAC Nightsave Large","ExNACNL",0,3,"ExNACNL03N",null,"Excess NAC Miniflex","ExNACMi",0,3,"ExNACMi03N",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",0,4,"ExNACMe04N",null,"Excess NAC Nightsave Large","ExNACNL",0,4,"ExNACNL04N",null,"Excess NAC Miniflex","ExNACMi",0,4,"ExNACMi04N",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
["Excess NAC Megaflex","ExNACMe",1,1,"ExNACMe11N",null,"Excess NAC Nightsave Large","ExNACNL",1,1,"ExNACNL11N",null,"Excess NAC Miniflex","ExNACMi",1,1,"ExNACMi11N",null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",1,2,"ExNACMe12N",null,"Excess NAC Nightsave Large","ExNACNL",1,2,"ExNACNL12N",null,"Excess NAC Miniflex","ExNACMi",1,2,"ExNACMi12N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",1,3,"ExNACMe13N",null,"Excess NAC Nightsave Large","ExNACNL",1,3,"ExNACNL13N",null,"Excess NAC Miniflex","ExNACMi",1,3,"ExNACMi13N",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",1,4,"ExNACMe14N",null,"Excess NAC Nightsave Large","ExNACNL",1,4,"ExNACNL14N",null,"Excess NAC Miniflex","ExNACMi",1,4,"ExNACMi14N",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
["Excess NAC Megaflex","ExNACMe",2,1,"ExNACMe21N",null,"Excess NAC Nightsave Large","ExNACNL",2,1,"ExNACNL21N",null,"Excess NAC Miniflex","ExNACMi",2,1,"ExNACMi21N",null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",2,2,"ExNACMe22N",null,"Excess NAC Nightsave Large","ExNACNL",2,2,"ExNACNL22N",null,"Excess NAC Miniflex","ExNACMi",2,2,"ExNACMi22N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",2,3,"ExNACMe23N",null,"Excess NAC Nightsave Large","ExNACNL",2,3,"ExNACNL23N",null,"Excess NAC Miniflex","ExNACMi",2,3,"ExNACMi23N",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",2,4,"ExNACMe24N",null,"Excess NAC Nightsave Large","ExNACNL",2,4,"ExNACNL24N",null,"Excess NAC Miniflex","ExNACMi",2,4,"ExNACMi24N",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
["Excess NAC Megaflex","ExNACMe",3,1,"ExNACMe31N",null,"Excess NAC Nightsave Large","ExNACNL",3,1,"ExNACNL31N",null,"Excess NAC Miniflex","ExNACMi",3,1,"ExNACMi31N",null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",3,2,"ExNACMe32N",null,"Excess NAC Nightsave Large","ExNACNL",3,2,"ExNACNL32N",null,"Excess NAC Miniflex","ExNACMi",3,2,"ExNACMi32N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",3,3,"ExNACMe33N",null,"Excess NAC Nightsave Large","ExNACNL",3,3,"ExNACNL33N",null,"Excess NAC Miniflex","ExNACMi",3,3,"ExNACMi33N",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",3,4,"ExNACMe34N",null,"Excess NAC Nightsave Large","ExNACNL",3,4,"ExNACNL34N",null,"Excess NAC Miniflex","ExNACMi",3,4,"ExNACMi34N",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
[null,null,null,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,"* 132 kV or Transmission connected",null,null,null,null,null,"* 132 kV or Transmission connected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban - Excess NAC\nNightsave Urban Small\n[non local authorities]",null,null,null,null,"Rural - Excess NAC\nNightsave Rural\n[non local authorities]",null,null,null,null,null,"Rural - Excess NAC\nRuraflex\n[non local authorities]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl"]
["Excess NAC Nightsave Small","ExNACNS",0,1,"ExNACNS01N",null,"Excess NAC Nightsave Rural","ExNACNR",0,1,"ExNACNR01N",null,"Excess NAC Ruraflex","ExNACRu",0,1,"ExNACRu01N",null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",0,2,"ExNACNS02N",null,"Excess NAC Nightsave Rural","ExNACNR",0,2,"ExNACNR02N",null,"Excess NAC Ruraflex","ExNACRu",0,2,"ExNACRu02N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",0,3,"ExNACNS03N",null,"Excess NAC Nightsave Rural","ExNACNR",0,3,"ExNACNR03N",null,"Excess NAC Ruraflex","ExNACRu",0,3,"ExNACRu03N",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",0,4,"ExNACNS04N",null,"Excess NAC Nightsave Rural","ExNACNR",0,4,"ExNACNR04N",null,"Excess NAC Ruraflex","ExNACRu",0,4,"ExNACRu04N",null,null,"> 132kV*",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,1,"ExNACNS11N",null,"Excess NAC Nightsave Rural","ExNACNR",1,1,"ExNACNR11N",null,"Excess NAC Ruraflex","ExNACRu",1,1,"ExNACRu11N",null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,2,"ExNACNS12N",null,"Excess NAC Nightsave Rural","ExNACNR",1,2,"ExNACNR12N",null,"Excess NAC Ruraflex","ExNACRu",1,2,"ExNACRu12N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,3,"ExNACNS13N",null,"Excess NAC Nightsave Rural","ExNACNR",1,3,"ExNACNR13N",null,"Excess NAC Ruraflex","ExNACRu",1,3,"ExNACRu13N",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,4,"ExNACNS14N",null,"Excess NAC Nightsave Rural","ExNACNR",1,4,"ExNACNR14N",null,"Excess NAC Ruraflex","ExNACRu",1,4,"ExNACRu14N",null,null,"> 132kV*",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,1,"ExNACNS21N",null,"Excess NAC Nightsave Rural","ExNACNR",2,1,"ExNACNR21N",null,"Excess NAC Ruraflex","ExNACRu",2,1,"ExNACRu21N",null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,2,"ExNACNS22N",null,"Excess NAC Nightsave Rural","ExNACNR",2,2,"ExNACNR22N",null,"Excess NAC Ruraflex","ExNACRu",2,2,"ExNACRu22N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,3,"ExNACNS23N",null,"Excess NAC Nightsave Rural","ExNACNR",2,3,"ExNACNR23N",null,"Excess NAC Ruraflex","ExNACRu",2,3,"ExNACRu23N",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,4,"ExNACNS24N",null,"Excess NAC Nightsave Rural","ExNACNR",2,4,"ExNACNR24N",null,"Excess NAC Ruraflex","ExNACRu",2,4,"ExNACRu24N",null,null,"> 132kV*",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,1,"ExNACNS31N",null,"Excess NAC Nightsave Rural","ExNACNR",3,1,"ExNACNR31N",null,"Excess NAC Ruraflex","ExNACRu",3,1,"ExNACRu31N",null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,2,"ExNACNS32N",null,"Excess NAC Nightsave Rural","ExNACNR",3,2,"ExNACNR32N",null,"Excess NAC Ruraflex","ExNACRu",3,2,"ExNACRu32N",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,3,"ExNACNS33N",null,"Excess NAC Nightsave Rural","ExNACNR",3,3,"ExNACNR33N",null,"Excess NAC Ruraflex","ExNACRu",3,3,"ExNACRu33N",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,4,"ExNACNS34N",null,"Excess NAC Nightsave Rural","ExNACNR",3,4,"ExNACNR34N",null,"Excess NAC Ruraflex","ExNACRu",3,4,"ExNACRu34N",null,null,"> 132kV*",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]

{"sheet":"Excess NAC Munic","index":32,"n_rows":47,"n_cols":34,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,32,5,33],[1,18,1,21],[1,23,1,27],[1,29,1,33],[3,20,3,21],[3,26,3,27],[3,32,3,33],[4,18,6,18],[4,20,5,21],[4,24,6,24],[4,26,5,27],[4,30,6,30],[7,18,10,18],[7,24,10,24],[7,30,10,30],[11,18,14,18],[11,24,14,24],[11,30,14,30],[15,18,18,18],[15,24,18,24],[15,30,18,30],[19,18,22,18],[19,24,22,24],[19,30,22,30],[27,32,28,33],[24,18,24,21],[24,23,24,27],[24,29,24,33],[26,20,26,21],[26,26,26,27],[26,32,26,33],[27,18,29,18],[27,20,28,21],[27,24,29,24],[27,26,28,27],[27,30,29,30],[30,18,33,18],[30,24,33,24],[30,30,33,30],[34,18,37,18],[34,24,37,24],[34,30,37,30],[38,18,41,18],[38,24,41,24],[38,30,41,30],[42,18,45,18],[42,24,45,24],[42,30,45,30]]}
[]
["Municiple",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban - Excess NAC\nMegaflex\n[non local authorities]",null,null,null,null,"Urban - Excess NAC\nNightsave Urban Large\n[non local authorities]",null,null,null,null,null,"Urban - Excess NAC\nMiniflex\n[non local authorities]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl"]
["Excess NAC Megaflex","ExNACMe",0,1,"ExNACMe01Y",null,"Excess NAC Nightsave Large","ExNACNL",0,1,"ExNACNL01Y",null,"Excess NAC Miniflex","ExNACMi",0,1,"ExNACMi01Y",null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",0,2,"ExNACMe02Y",null,"Excess NAC Nightsave Large","ExNACNL",0,2,"ExNACNL02Y",null,"Excess NAC Miniflex","ExNACMi",0,2,"ExNACMi02Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",0,3,"ExNACMe03Y",null,"Excess NAC Nightsave Large","ExNACNL",0,3,"ExNACNL03Y",null,"Excess NAC Miniflex","ExNACMi",0,3,"ExNACMi03Y",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",0,4,"ExNACMe04Y",null,"Excess NAC Nightsave Large","ExNACNL",0,4,"ExNACNL04Y",null,"Excess NAC Miniflex","ExNACMi",0,4,"ExNACMi04Y",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
["Excess NAC Megaflex","ExNACMe",1,1,"ExNACMe11Y",null,"Excess NAC Nightsave Large","ExNACNL",1,1,"ExNACNL11Y",null,"Excess NAC Miniflex","ExNACMi",1,1,"ExNACMi11Y",null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",1,2,"ExNACMe12Y",null,"Excess NAC Nightsave Large","ExNACNL",1,2,"ExNACNL12Y",null,"Excess NAC Miniflex","ExNACMi",1,2,"ExNACMi12Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",1,3,"ExNACMe13Y",null,"Excess NAC Nightsave Large","ExNACNL",1,3,"ExNACNL13Y",null,"Excess NAC Miniflex","ExNACMi",1,3,"ExNACMi13Y",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",1,4,"ExNACMe14Y",null,"Excess NAC Nightsave Large","ExNACNL",1,4,"ExNACNL14Y",null,"Excess NAC Miniflex","ExNACMi",1,4,"ExNACMi14Y",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
["Excess NAC Megaflex","ExNACMe",2,1,"ExNACMe21Y",null,"Excess NAC Nightsave Large","ExNACNL",2,1,"ExNACNL21Y",null,"Excess NAC Miniflex","ExNACMi",2,1,"ExNACMi21Y",null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",2,2,"ExNACMe22Y",null,"Excess NAC Nightsave Large","ExNACNL",2,2,"ExNACNL22Y",null,"Excess NAC Miniflex","ExNACMi",2,2,"ExNACMi22Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",2,3,"ExNACMe23Y",null,"Excess NAC Nightsave Large","ExNACNL",2,3,"ExNACNL23Y",null,"Excess NAC Miniflex","ExNACMi",2,3,"ExNACMi23Y",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",2,4,"ExNACMe24Y",null,"Excess NAC Nightsave Large","ExNACNL",2,4,"ExNACNL24Y",null,"Excess NAC Miniflex","ExNACMi",2,4,"ExNACMi24Y",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
["Excess NAC Megaflex","ExNACMe",3,1,"ExNACMe31Y",null,"Excess NAC Nightsave Large","ExNACNL",3,1,"ExNACNL31Y",null,"Excess NAC Miniflex","ExNACMi",3,1,"ExNACMi31Y",null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0]
["Excess NAC Megaflex","ExNACMe",3,2,"ExNACMe32Y",null,"Excess NAC Nightsave Large","ExNACNL",3,2,"ExNACNL32Y",null,"Excess NAC Miniflex","ExNACMi",3,2,"ExNACMi32Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & < 66kV",0,0]
["Excess NAC Megaflex","ExNACMe",3,3,"ExNACMe33Y",null,"Excess NAC Nightsave Large","ExNACNL",3,3,"ExNACNL33Y",null,"Excess NAC Miniflex","ExNACMi",3,3,"ExNACMi33Y",null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0,null,null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Megaflex","ExNACMe",3,4,"ExNACMe34Y",null,"Excess NAC Nightsave Large","ExNACNL",3,4,"ExNACNL34Y",null,"Excess NAC Miniflex","ExNACMi",3,4,"ExNACMi34Y",null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0,null,null,null,"> 132kV*",0,0]
[null,null,null,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,"* 132 kV or Transmission connected",null,null,null,null,null,"* 132 kV or Transmission connected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban - Excess NAC\nNightsave Urban Small\n[non local authorities]",null,null,null,null,"Rural - Excess NAC\nNightsave Rural\n[non local authorities]",null,null,null,null,null,"Rural - Excess NAC\nRuraflex\n[non local authorities]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]",null,null,null,null,null,"Excess network charge [R/kVA/m]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone",null,null,null,null,null,"Transmission zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage",null,null,null,null,null,"Voltage"]
["Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,"Tariff","Tariff nameBillcode","Tx zone","Voltage","Billcode",null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl",null,null,null,null,null,"VAT incl"]
["Excess NAC Nightsave Small","ExNACNS",0,1,"ExNACNS01Y",null,"Excess NAC Nightsave Rural","ExNACNR",0,1,"ExNACNR01Y",null,"Excess NAC Ruraflex","ExNACRu",0,1,"ExNACRu01Y",null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0,null,null,"≤ 300km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",0,2,"ExNACNS02Y",null,"Excess NAC Nightsave Rural","ExNACNR",0,2,"ExNACNR02Y",null,"Excess NAC Ruraflex","ExNACRu",0,2,"ExNACRu02Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",0,3,"ExNACNS03Y",null,"Excess NAC Nightsave Rural","ExNACNR",0,3,"ExNACNR03Y",null,"Excess NAC Ruraflex","ExNACRu",0,3,"ExNACRu03Y",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",0,4,"ExNACNS04Y",null,"Excess NAC Nightsave Rural","ExNACNR",0,4,"ExNACNR04Y",null,"Excess NAC Ruraflex","ExNACRu",0,4,"ExNACRu04Y",null,null,"> 132kV*",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,1,"ExNACNS11Y",null,"Excess NAC Nightsave Rural","ExNACNR",1,1,"ExNACNR11Y",null,"Excess NAC Ruraflex","ExNACRu",1,1,"ExNACRu11Y",null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0,null,null,"> 300km and \n≤ 600km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,2,"ExNACNS12Y",null,"Excess NAC Nightsave Rural","ExNACNR",1,2,"ExNACNR12Y",null,"Excess NAC Ruraflex","ExNACRu",1,2,"ExNACRu12Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,3,"ExNACNS13Y",null,"Excess NAC Nightsave Rural","ExNACNR",1,3,"ExNACNR13Y",null,"Excess NAC Ruraflex","ExNACRu",1,3,"ExNACRu13Y",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",1,4,"ExNACNS14Y",null,"Excess NAC Nightsave Rural","ExNACNR",1,4,"ExNACNR14Y",null,"Excess NAC Ruraflex","ExNACRu",1,4,"ExNACRu14Y",null,null,"> 132kV*",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,1,"ExNACNS21Y",null,"Excess NAC Nightsave Rural","ExNACNR",2,1,"ExNACNR21Y",null,"Excess NAC Ruraflex","ExNACRu",2,1,"ExNACRu21Y",null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0,null,null,"> 600km and \n≤ 900km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,2,"ExNACNS22Y",null,"Excess NAC Nightsave Rural","ExNACNR",2,2,"ExNACNR22Y",null,"Excess NAC Ruraflex","ExNACRu",2,2,"ExNACRu22Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,3,"ExNACNS23Y",null,"Excess NAC Nightsave Rural","ExNACNR",2,3,"ExNACNR23Y",null,"Excess NAC Ruraflex","ExNACRu",2,3,"ExNACRu23Y",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",2,4,"ExNACNS24Y",null,"Excess NAC Nightsave Rural","ExNACNR",2,4,"ExNACNR24Y",null,"Excess NAC Ruraflex","ExNACRu",2,4,"ExNACRu24Y",null,null,"> 132kV*",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,1,"ExNACNS31Y",null,"Excess NAC Nightsave Rural","ExNACNR",3,1,"ExNACNR31Y",null,"Excess NAC Ruraflex","ExNACRu",3,1,"ExNACRu31Y",null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0,null,null,"> 900km","< 500V",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,2,"ExNACNS32Y",null,"Excess NAC Nightsave Rural","ExNACNR",3,2,"ExNACNR32Y",null,"Excess NAC Ruraflex","ExNACRu",3,2,"ExNACRu32Y",null,null,"≥ 500V & < 66kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0,null,null,null,"≥ 500V & ≤ 22kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,3,"ExNACNS33Y",null,"Excess NAC Nightsave Rural","ExNACNR",3,3,"ExNACNR33Y",null,"Excess NAC Ruraflex","ExNACRu",3,3,"ExNACRu33Y",null,null,"≥ 66kV & ≤ 132kV",0,0]
["Excess NAC Nightsave Small","ExNACNS",3,4,"ExNACNS34Y",null,"Excess NAC Nightsave Rural","ExNACNR",3,4,"ExNACNR34Y",null,"Excess NAC Ruraflex","ExNACRu",3,4,"ExNACRu34Y",null,null,"> 132kV*",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* 132 kV or Transmission connected"]

{"sheet":"Env levy","index":33,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Urban"]
[null,"Ave c/kWh","Column Labels"]
[null,"Row Labels",0,1,2,3,"Grand Total"]
[null,1,4.2441734963618041,3.9229221124432589,3.9527382105199051,3.9951826601450668,4.2303256421082995]
[null,2,3.8186059651047737,3.8567920247728718,3.895359945114679,3.9343135444971589,3.8300318858177489]
[null,3,3.6978495999019296,3.7348280958939521,3.7721763768754322,3.8098981406339028,3.7495844042255713]
[null,4,3.4850235973906436,3.5198738333649109,3.5550725710602902,3.6325745024653484,3.4978362022439597]
[null,"Grand Total",3.7686931970332931,3.6664747565850311,3.7989660387480506,3.8482092095507561,3.7606121708915037]
[]
[null,"Rural pivot(excluding landrate)"]
[null,"Ave c/kWh","Column Labels"]
[null,"Row Labels",0,1,2,3,"Grand Total"]
[null,1,0,0,0,0,0]
[null,2,0,0,0,0,0]
[null,"Grand Total",0,0,0,0,0]
[]
[null,"Landrate"]
[null,"Ave c/kWh","Column Labels"]
[null,"Row Labels",0,"Grand Total"]
[null,1,0,0]
[null,"Grand Total",0,0]