{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Inputs","Monthly Average Bill","FAQ","Tariff Comparison","Rates Table","Workings High","Workings Low","Rates SPU - New","Rates SPU - Current","Mapping","Lists","Notes on updates"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":142,"comments":1,"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":"Inputs","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,6,7,7],[8,6,8,7],[9,6,9,7],[20,10,29,14],[22,3,22,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 6.12    13 March 2023"]
[]
[null,"Tariff Input Sheet"]
[]
[null,"Please enter the required information below:"]
[]
[null,null,null,"Customer Name",null,null,"Customer Name",null,"Enter the customer name as it is displayed on the rates bill."]
[null,null,null,"Account number ",null,null,"Account Number",null,"Enter the account number as it is displayed on the rates bill."]
[null,null,null,"Point of delivery ID",null,null,"Point of delivery",null,"Enter the Point of Delivery ID as it is displayed on the rates bill."]
[null,null,null,"Number of PODs",null,null,null,1]
[]
[null,null,null,"Select your tariff classification",null,null,null,null,"Select either Non-Local Authority (Eskom), Local Authority (Municipality)"]
[]
[null,null,null,"Customer Category",null,null,"Small Power User"]
[]
[null,null,null,"Select  supply size",null,null,null,null,"Select the appropriate customer supply size (kVA)"]
[]
[null,null,null,"Select tariff",null,null,null,null,"Drop box selection driven by the supply voltage inputs"]
[]
[null,null,null,"Select supply voltage",null,null,{"$f":"Selected_Supply_Voltage","v":"< 500V"},null,null,null,"Calculations are based on the average number of days per month:\nAve days per month  = Total number of days in year (365) / months (12)\n                                     = 30.416667"]
[]
[null,null,null,"Enter average monthly consumption for SPU tariffs excluding Homeflex",null,null,null,null,"kWh / month"]
[]
[null,null,null,"For Homeflex tariff enter average monthly consumption below:"]
[null,null,null,null,null,null,"Peak energy","Standard energy","Off-peak energy","Total energy"]
[null,null,null,null,null,null,"kWh / month","kWh / month","kWh / month","kWh / month"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(G28:I28)","v":0}]

{"sheet":"Monthly Average Bill","index":1,"n_rows":74,"n_cols":18,"rows_kept":74,"cut":false,"hidden":false,"merged":[[9,13,9,14],[9,5,9,6]]}
[]
[]
[]
[null,"Monthly Average Bill",null,null,null,null,null,null,{"$f":"D10","v":"Landrate 4"},null,{"$f":"B4","v":"Monthly Average Bill"},null,null,null,null,null,null,{"$f":"I4","v":"Landrate 4"}]
[]
[null,"High Demand",null,null,null,null,null,null,null,null,"Low Demand"]
[]
[null,"Customer Name",null,{"$f":"Customer_Name","v":"Customer Name"},null,null,null,null,null,null,{"$f":"B8","v":"Customer Name"},null,{"$f":"D8","v":"Customer Name"}]
[null,{"$f":"Inputs!D10","v":"Point of delivery ID"},null,{"$f":"Delivery_ID","v":"Point of delivery"},null,null,null,null,null,null,{"$f":"B9","v":"Point of delivery ID"},null,{"$f":"D9","v":"Point of delivery"}]
[null,null,"Tariff",{"$f":"Selected_Base_Tariff","v":"Landrate 4"},null,"Ave Monthly Consumption for SPU tariffs excluding Homeflex",null,{"$f":"IF(Selected_Customer_Category_ID=1,SPU_Annual_Total_Energy,0)","v":0},"kWh",null,null,{"$f":"C10","v":"Tariff"},{"$f":"D10","v":"Landrate 4"},{"$f":"F10","v":"Ave Monthly Consumption for SPU tariffs excluding Homeflex"},null,{"$f":"H10","v":0},"kWh"]
[null,null,null,null,null,"Ave Homeflex Monthly Peak",null,{"$f":"IF(Selected_Customer_Category_ID=1,Homeflex_Peak_Energy,0)","v":0},"kWh",null,null,null,null,"Ave Homeflex Monthly Peak",null,0,"kWh"]
[null,null,null,null,null,"Ave Homeflex Monthly Standard",null,{"$f":"IF(Selected_Customer_Category_ID=1,Homeflex_Standard_Energy,0)","v":0},"kWh",null,null,null,null,"Ave Homeflex Monthly Standard",null,0,"kWh"]
[null,null,null,null,null,"Ave Homeflex Monthly Off-peak",null,{"$f":"IF(Selected_Customer_Category_ID=1,Homeflex_OffPeak_Energy,0)","v":0},"kWh",null,null,null,null,"Ave Homeflex Monthly Off-peak",null,0,"kWh"]
[null,null,null,null,null,"Ave Homeflex Total Monthly Consumption",null,{"$f":"IF(Selected_Customer_Category_ID=1,Homeflex_Total_Energy,0)","v":0},"kWh",null,null,null,null,"Ave Homeflex Total Monthly Consumption",null,0,"kWh"]
[null,null,"Tariff Category",{"$f":"INDEX(Full_Tariff_Type,MATCH(D10,Full_Tariff_List,0))","v":"Rural"},null,"Days",null,{"$f":"ESKOM_Total_days","v":30.416666666666668},"days",null,null,{"$f":"C15","v":"Tariff Category"},{"$f":"D15","v":"Rural"},"Days",null,30.416666666666668,"days"]
[null,null,"Supply voltage",{"$f":"Selected_Supply_Voltage","v":"< 500V"},null,null,null,null,null,null,null,{"$f":"C16","v":"Supply voltage"},"< 500V"]
[null,null,"Tariff Classification",{"$f":"Selected_Tariff_Category","v":"Non-Local Authority"},null,null,null,null,null,null,null,"Tariff Classification","Non-Local Authority"]
[null,null,"No of PODS",{"$f":"PODs","v":1},null,null,null,null,null,null,null,"No of PODS",1]
[null,null,"Size of supply",{"$f":"Selected_Supply_Size","v":"5kVA, 16kVA, 20A or 60A"},null,null,null,null,null,null,null,"Size of supply","5kVA, 16kVA, 20A or 60A"]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,"Network charges",null,"Units",{"$f":"Current_Period &\" Rates\"","v":"2022/2023 Rates"},{"$f":"New_Period &\" Rates\"","v":"2023/2024 Rates"},{"$f":"Current_Period&\" Charges\"","v":"2022/2023 Charges"},{"$f":"New_Period&\" Charges\"","v":"2023/2024 Charges"},"% Change",null,"Network charges",null,"Units",{"$f":"Current_Period &\" Rates\"","v":"2022/2023 Rates"},{"$f":"New_Period &\" Rates\"","v":"2023/2024 Rates"},{"$f":"Current_Period&\" Charges\"","v":"2022/2023 Charges"},{"$f":"New_Period&\" Charges\"","v":"2023/2024 Charges"},"% Change"]
[]
[null,null,"Network demand charge","c/kWh",{"$f":"'Rates Table'!E10","v":38.94},{"$f":"'Rates Table'!AE10","v":46.2},{"$f":"IFERROR(E24*SPU_Total_Energy,0)/100","v":0},{"$f":"IFERROR(F24*SPU_Total_Energy,0)/100","v":0},{"$f":"IFERROR(H24/G24-1,0)","v":0},null,null,"Network demand charge","c/kWh",{"$f":"E24","v":38.94},{"$f":"F24","v":46.2},0,0,{"$f":"I24","v":0}]
[null,null,"Network demand charge, Ancillary service charge and retail","c/kWh",{"$f":"'Rates Table'!E11","v":0},{"$f":"'Rates Table'!AE11","v":0},{"$f":"IFERROR(E25*Homeflex_Total_Monthly_Energy,0)/100","v":0},{"$f":"IFERROR(F25*Homeflex_Total_Monthly_Energy,0)/100","v":0},0,null,null,"Network demand charge, Ancillary service charge and retail","c/kWh",{"$f":"E25","v":0},0,0,0,{"$f":"I25","v":0}]
[null,null,"Network capacity charge",{"$f":"IF(Table_1=1,\"R/kVA\",\"R/day\")","v":"R/day"},{"$f":"'Rates Table'!E12","v":33.15},{"$f":"'Rates Table'!AE12","v":39.33},{"$f":"IFERROR(E26*PODs*SPU_Days,0)","v":1008.3125},{"$f":"IFERROR(F26*PODs*SPU_Days,0)","v":1196.2874999999999},0.18642533936651584,null,null,"Network capacity charge",{"$f":"IF(Table_1=1,\"R/kVA\",\"R/day\")","v":"R/day"},33.15,39.33,1008.3125,1196.2874999999999,0.18642533936651584]
[]
[null,"Total network charges",null,null,null,null,{"$f":"SUM(G24:G26)","v":1008.3125},{"$f":"SUM(H24:H26)","v":1196.2874999999999},0.18642533936651584,null,"Total network charges",null,null,null,null,{"$f":"SUM(P24:P26)","v":1008.3125},{"$f":"SUM(Q24:Q26)","v":1196.2874999999999},{"$f":"IFERROR(Q28/P28-1,0)","v":0.18642533936651584}]
[]
[null,"Energy charges",null,"Units",{"$f":"E22","v":"2022/2023 Rates"},{"$f":"F22","v":"2023/2024 Rates"},{"$f":"G22","v":"2022/2023 Charges"},{"$f":"H22","v":"2023/2024 Charges"},"% Change",null,"Energy charges",null,"Units",{"$f":"N22","v":"2022/2023 Rates"},{"$f":"O22","v":"2023/2024 Rates"},{"$f":"P22","v":"2022/2023 Charges"},{"$f":"Q22","v":"2023/2024 Charges"},"% Change"]
[]
[null,null,"Energy","c/kWh",{"$f":"'Rates Table'!E18","v":336.63},{"$f":"'Rates Table'!AE18","v":399.41},{"$f":"IFERROR(E32*(SPU_Total_Energy),0)/100","v":0},{"$f":"IFERROR(F32*(SPU_Total_Energy),0)/100","v":0},{"$f":"IFERROR(H32/G32-1,0)","v":0},null,null,"Energy","c/kWh",{"$f":"E32","v":336.63},{"$f":"F32","v":399.41},0,0,0]
[null,null,"Peak","c/kWh",{"$f":"'Rates Table'!E19","v":0},{"$f":"'Rates Table'!AE19","v":0},{"$f":"IFERROR(E33*(Ave_Monthly_Peak),0)/100","v":0},{"$f":"IFERROR(F33*(Ave_Monthly_Peak),0)/100","v":0},0,null,null,"Peak","c/kWh",{"$f":"IFERROR('Rates SPU - Current'!$L$29*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),1,0),0)","v":0},{"$f":"IFERROR('Rates SPU - New'!$L$29*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),1,0),0)","v":0},{"$f":"IFERROR(N33*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),(Ave_Monthly_Peak),0),0)/100","v":0},0,{"$f":"IFERROR(Q33/P33-1,0)","v":0}]
[null,null,"Standard","c/kWh",{"$f":"'Rates Table'!E20","v":0},{"$f":"'Rates Table'!AE20","v":0},{"$f":"IFERROR(E34*(Ave_Monthly_Standard),0)/100","v":0},{"$f":"IFERROR(F34*(Ave_Monthly_Standard),0)/100","v":0},0,null,null,"Standard","c/kWh",{"$f":"IFERROR('Rates SPU - Current'!$M$29*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),1,0),0)","v":0},{"$f":"IFERROR('Rates SPU - New'!$M$29*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),1,0),0)","v":0},{"$f":"IFERROR(N34*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),(Ave_Monthly_Standard),0),0)/100","v":0},{"$f":"IFERROR(O34*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),(Ave_Monthly_Standard),0),0)/100","v":0},0]
[null,null,"Off-Peak","c/kWh",{"$f":"'Rates Table'!E21","v":0},{"$f":"'Rates Table'!AE21","v":0},{"$f":"IFERROR(E35*(Ave_Monthly_OffPeak),0)/100","v":0},{"$f":"IFERROR(F35*(Ave_Monthly_OffPeak),0)/100","v":0},0,null,null,"Off-Peak","c/kWh",{"$f":"IFERROR('Rates SPU - Current'!$N$29*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),1,0),0)","v":0},{"$f":"IFERROR('Rates SPU - New'!$N$29*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),1,0),0)","v":0},{"$f":"IFERROR(N35*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),(Ave_Monthly_OffPeak),0),0)/100","v":0},{"$f":"IFERROR(O35*IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),(Ave_Monthly_OffPeak),0),0)/100","v":0},0]
[null,null,"Energy - Block 1","c/kWh",{"$f":"'Rates Table'!E22","v":0},{"$f":"'Rates Table'!AE22","v":0},{"$f":"IFERROR(E36*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR(F36*(SPU_Block_1),0)/100","v":0},0,null,null,"Energy - Block 1","c/kWh",{"$f":"E36","v":0},{"$f":"F36","v":0},{"$f":"G36","v":0},{"$f":"H36","v":0},{"$f":"I36","v":0}]
[null,null,"Energy - Block 2","c/kWh",{"$f":"'Rates Table'!E23","v":0},{"$f":"'Rates Table'!AE23","v":0},{"$f":"IFERROR(E37*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR(F37*(SPU_Block_2),0)/100","v":0},0,null,null,"Energy - Block 2","c/kWh",0,0,0,0,0]
[]
[null,"Total energy charges",null,null,null,null,{"$f":"SUM(G32:G37)","v":0},{"$f":"SUM(H32:H37)","v":0},{"$f":"IFERROR(H39/G39-1,0)","v":0},null,"Total energy charges",null,null,null,null,{"$f":"SUM(P32:P37)","v":0},{"$f":"SUM(Q32:Q37)","v":0},{"$f":"IFERROR(Q39/P39-1,0)","v":0}]
[]
[null,"Other charges",null,"Units",{"$f":"E22","v":"2022/2023 Rates"},{"$f":"F22","v":"2023/2024 Rates"},{"$f":"G22","v":"2022/2023 Charges"},{"$f":"H22","v":"2023/2024 Charges"},"% Change",null,"Other charges",null,"Units",{"$f":"N22","v":"2022/2023 Rates"},{"$f":"O22","v":"2023/2024 Rates"},{"$f":"P22","v":"2022/2023 Charges"},{"$f":"Q22","v":"2023/2024 Charges"},"% Change"]
[]
[null,null,"Ancillary service charge ","c/kWh",{"$f":"'Rates Table'!E29","v":0.6},{"$f":"'Rates Table'!AE29","v":0.71},{"$f":"IFERROR(SPU_Total_Energy*E43,0)/100","v":0},{"$f":"IFERROR(SPU_Total_Energy*F43,0)/100","v":0},{"$f":"IFERROR(H43/G43-1,0)","v":0},null,null,"Ancillary service charge ","c/kWh",{"$f":"E43","v":0.6},{"$f":"F43","v":0.71},{"$f":"G43","v":0},{"$f":"H43","v":0},{"$f":"I43","v":0}]
[null,null,"Service charge",{"$f":"IF(Table_1=1,\"R/day\",\"R/day\")","v":"R/day"},{"$f":"'Rates Table'!E30","v":0},{"$f":"'Rates Table'!AE30","v":0},{"$f":"IFERROR(IF(Table_1=1,E44*PODs*SPU_Days,E44*PODs*SPU_Days),0)","v":0},{"$f":"IFERROR(IF(Table_1=1,F44*PODs*SPU_Days,F44*PODs*SPU_Days),0)","v":0},0,null,null,"Service charge",{"$f":"IF(Table_1=1,\"R/day\",\"R/day\")","v":"R/day"},{"$f":"E44","v":0},0,0,0,0]
[]
[null,"Total other charges",null,null,null,null,{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$f":"IFERROR(H46/G46-1,0)","v":0},null,"Total other charges",null,null,null,null,{"$f":"SUM(P43:P44)","v":0},{"$f":"SUM(Q43:Q44)","v":0},{"$f":"IFERROR(Q46/P46-1,0)","v":0}]
[]
[null,"Total excl VAT",null,null,null,null,{"$f":"G46+G39+G28","v":1008.3125},{"$f":"H46+H39+H28","v":1196.2874999999999},{"$f":"IFERROR(H48/G48-1,0)","v":0.18642533936651584},null,"Total excl VAT",null,null,null,null,{"$f":"P46+P39+P28","v":1008.3125},{"$f":"Q46+Q39+Q28","v":1196.2874999999999},{"$f":"IFERROR(Q48/P48-1,0)","v":0.18642533936651584}]
[null,"VAT",null,{"$f":"VAT","v":0.15},null,null,{"$f":"G48*$D49","v":151.24687499999999},{"$f":"H48*$D49","v":179.44312499999998},null,null,"VAT",null,{"$f":"VAT","v":0.15},null,null,{"$f":"P48*$D49","v":151.24687499999999},{"$f":"Q48*$D49","v":179.44312499999998}]
[]
[null,"Total account",null,null,null,null,{"$f":"SUM(G48:G49)","v":1159.559375},{"$f":"SUM(H48:H49)","v":1375.7306249999999},{"$f":"IFERROR(H51/G51-1,0)","v":0.18642533936651562},null,"Total account",null,null,null,null,{"$f":"SUM(P48:P49)","v":1159.559375},{"$f":"SUM(Q48:Q49)","v":1375.7306249999999},{"$f":"IFERROR(Q51/P51-1,0)","v":0.18642533936651562}]
[]
[null,"Average price",null,"c/kWh",null,null,{"$f":"IFERROR(IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),G48/Homeflex_Total_Monthly_Energy*100,G48/SPU_Total_Energy*100),0)","v":0},{"$f":"IFERROR(IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),H48/Homeflex_Total_Monthly_Energy*100,H48/SPU_Total_Energy*100),0)","v":0},{"$f":"IFERROR(H53/G53-1,0)","v":0},null,"Average price",null,"c/kWh",null,null,{"$f":"IFERROR(IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),P48/Homeflex_Total_Monthly_Energy*100,P48/SPU_Total_Energy*100),0)","v":0},{"$f":"IFERROR(IF(OR($D$10=\"Homeflex 1\",$D$10=\"Homeflex 2\", $D$10=\"Homeflex 3\",$D$10=\"Homeflex 4\"),Q48/Homeflex_Total_Monthly_Energy*100,Q48/SPU_Total_Energy*100),0)","v":0},{"$f":"IFERROR(Q53/P53-1,0)","v":0}]
[]
[]
[null,"Summary High demand",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,null,null,null,"Summary Low demand",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change"]
[]
[null,null,"Total Network Charges",{"$f":"G28","v":1008.3125},{"$f":"H28","v":1196.2874999999999},{"$f":"I28","v":0.18642533936651584},null,null,null,null,null,"Total Network Charges",{"$f":"P28","v":1008.3125},{"$f":"Q28","v":1196.2874999999999},{"$f":"R28","v":0.18642533936651584}]
[null,null,"Total Energy Charges",{"$f":"G39","v":0},{"$f":"H39","v":0},{"$f":"I39","v":0},null,null,null,null,null,"Total Energy Charges",{"$f":"P39","v":0},{"$f":"Q39","v":0},{"$f":"R39","v":0}]
[null,null,"Other Charges",{"$f":"G46","v":0},{"$f":"H46","v":0},{"$f":"I46","v":0},null,null,null,null,null,"Other Charges",{"$f":"P46","v":0},{"$f":"Q46","v":0},{"$f":"R46","v":0}]
[]
[]
[null,null,"VAT",{"$f":"G49","v":151.24687499999999},{"$f":"H49","v":179.44312499999998},{"$f":"I49","v":0},null,null,null,null,null,"VAT",{"$f":"P49","v":151.24687499999999},{"$f":"Q49","v":179.44312499999998},{"$f":"R49","v":0}]
[]
[null,null,"Total Charges",{"$f":"G51","v":1159.559375},{"$f":"H51","v":1375.7306249999999},{"$f":"IFERROR(E65/D65-1,0)","v":0.18642533936651562},null,null,null,null,null,"Total Charges",{"$f":"P51","v":1159.559375},{"$f":"Q51","v":1375.7306249999999},{"$f":"IFERROR(N65/M65-1,0)","v":0.18642533936651562}]
[]
[]
[]
[]
[]
[]
[null,"Blocks"]
[null,null,"Block 1",{"$f":"IF(SPU_Total_Energy > SPU_Block_1_Upper, SPU_Block_1_Upper, SPU_Total_Energy)","v":0},{"$f":"IF(D10 = Lists!B21,  Block1_max_HL20A,  Block1_max_HL60A)","v":600}]
[null,null,"Block 2",{"$f":"SPU_Total_Energy - D73","v":0}]

{"sheet":"FAQ","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Frequently Asked Questions"]

{"sheet":"Tariff Comparison","index":3,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Please select tariffs from the dropdown boxes to set up the Comparison Report.\n"]
[]
[null,"Comparison against other tariffs High Demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Monthly Average Bill'!I4","v":"Landrate 4"}]
[]
[null,null,null,null,null,null,null,4,null,{"$f":"MATCH(H8,Full_Tariff_List,0)","v":5},null,5,null,{"$f":"MATCH(L8,Full_Tariff_List,0)","v":6},null,2,null,{"$f":"MATCH(P8,Full_Tariff_List,0)","v":4}]
[]
[null,null,null,{"$f":"'Monthly Average Bill'!I4","v":"Landrate 4"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Tariff_List,Dropdown_Compare_1),$D$8)","v":"Homelight 20A"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Tariff_List,Dropdown_Compare_2),$D$8)","v":"Homelight 60A"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Tariff_List,Dropdown_Compare_3),$D$8)","v":"Businessrate 4"}]
[null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Selected_Compare_Tariff_ID),\"\")","v":"Rural"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Dropdown_Compare_1),\"\")","v":"Residential Urban"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Dropdown_Compare_2),\"\")","v":"Residential Urban"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Dropdown_Compare_3),\"\")","v":"Commercial Urban"}]
[null,"Comparison Tariffs",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change"]
[]
[null,null,"Network Charges",{"$f":"'Monthly Average Bill'!D58","v":1008.3125},{"$f":"'Monthly Average Bill'!E58","v":1196.2874999999999},{"$f":"IFERROR(E12/D12-1,0)","v":0.18642533936651584},null,{"$f":"IFERROR(SUMIFS(SPU_Network_Costs_Current,'Workings High'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Network_Costs_New,'Workings High'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(I12/H12-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Network_Costs_Current,'Workings High'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Network_Costs_New,'Workings High'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(M12/L12-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Network_Costs_Current,'Workings High'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Network_Costs_New,'Workings High'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(Q12/P12-1,0)","v":0}]
[null,null,"Energy Charges",{"$f":"'Monthly Average Bill'!D59","v":0},{"$f":"'Monthly Average Bill'!E59","v":0},{"$f":"IFERROR(E13/D13-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Energy_Charges_Current,'Workings High'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Energy_Charges_New,'Workings High'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(I13/H13-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Energy_Charges_Current,'Workings High'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Energy_Charges_New,'Workings High'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(M13/L13-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Energy_Charges_Current,'Workings High'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Energy_Charges_New,'Workings High'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(Q13/P13-1,0)","v":0}]
[null,null,"Other",{"$f":"'Monthly Average Bill'!D60","v":0},{"$f":"'Monthly Average Bill'!E60","v":0},{"$f":"IFERROR(E14/D14-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Other_Charges_Current,'Workings High'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Other_Charges_NEw,'Workings High'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(I14/H14-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Other_Charges_Current,'Workings High'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Other_Charges_NEw,'Workings High'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(M14/L14-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS(SPU_Other_Charges_Current,'Workings High'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS(SPU_Other_Charges_NEw,'Workings High'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(Q14/P14-1,0)","v":0}]
[]
[null,null,"Total",{"$f":"'Monthly Average Bill'!G48","v":1008.3125},{"$f":"'Monthly Average Bill'!H48","v":1196.2874999999999},{"$f":"IFERROR(E16/D16-1,0)","v":0.18642533936651584},null,{"$f":"SUM(H12:H14)","v":0},{"$f":"SUM(I12:I14)","v":0},{"$f":"IFERROR(I16/H16-1,0)","v":0},null,{"$f":"SUM(L12:L14)","v":0},{"$f":"SUM(M12:M14)","v":0},{"$f":"IFERROR(M16/L16-1,0)","v":0},null,{"$f":"SUM(P12:P14)","v":0},{"$f":"SUM(Q12:Q14)","v":0},{"$f":"IFERROR(Q16/P16-1,0)","v":0}]
[]
[null,null,"Average price c/kWh",{"$f":"'Monthly Average Bill'!G53","v":0},{"$f":"'Monthly Average Bill'!H53","v":0},{"$f":"IFERROR(E18/D18-1,0)","v":0},null,{"$f":"IFERROR(H16/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(I16/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(I18/H18-1,0)","v":0},null,{"$f":"IFERROR(L16/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(M16/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(M18/L18-1,0)","v":0},null,{"$f":"IFERROR(P16/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(Q16/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(Q18/P18-1,0)","v":0}]
[]
[]
[null,"Total Comparison",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change"]
[]
[null,null,{"$f":"D8","v":"Landrate 4"},{"$f":"D16","v":1008.3125},{"$f":"E16","v":1196.2874999999999},{"$f":"IFERROR(E23/D23-1,0)","v":0.18642533936651584}]
[null,null,{"$f":"H8","v":"Homelight 20A"},{"$f":"H16","v":0},{"$f":"I16","v":0},{"$f":"IFERROR(E24/D24-1,0)","v":0}]
[null,null,{"$f":"L8","v":"Homelight 60A"},{"$f":"L16","v":0},{"$f":"M16","v":0},{"$f":"IFERROR(E25/D25-1,0)","v":0}]
[null,null,{"$f":"P8","v":"Businessrate 4"},{"$f":"P16","v":0},{"$f":"Q16","v":0},{"$f":"IFERROR(E26/D26-1,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Comparison against other tariffs Low Demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Monthly Average Bill'!I4","v":"Landrate 4"}]
[]
[null,null,null,null,null,null,null,3,null,{"$f":"MATCH(H39,Full_Tariff_List,0)","v":5},null,5,null,{"$f":"MATCH(L39,Full_Tariff_List,0)","v":6},null,7,null,{"$f":"MATCH(P39,Full_Tariff_List,0)","v":4}]
[]
[null,null,null,{"$f":"'Monthly Average Bill'!I4","v":"Landrate 4"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Tariff_List,Dropdown_Compare_1),$D$8)","v":"Homelight 20A"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Tariff_List,Dropdown_Compare_2),$D$8)","v":"Homelight 60A"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Tariff_List,Dropdown_Compare_3),$D$8)","v":"Businessrate 4"}]
[null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Selected_Compare_Tariff_ID),\"\")","v":"Rural"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Dropdown_Compare_1),\"\")","v":"Residential Urban"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Dropdown_Compare_2),\"\")","v":"Residential Urban"},null,null,null,{"$f":"IFERROR(INDEX(Compare_Long_Type,Dropdown_Compare_3),\"\")","v":"Commercial Urban"}]
[null,"Comparison Tariffs",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change"]
[]
[null,null,"Network Charges",{"$f":"'Monthly Average Bill'!M58","v":1008.3125},{"$f":"'Monthly Average Bill'!N58","v":1196.2874999999999},{"$f":"IFERROR(E43/D43-1,0)","v":0.18642533936651584},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Network_Costs_Current_Low,'Workings Low'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Network_Costs_New_Low,'Workings Low'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(I43/H43-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Network_Costs_Current_Low,'Workings Low'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Network_Costs_New_Low,'Workings Low'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(M43/L43-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Network_Costs_Current_Low,'Workings Low'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Network_Costs_New_Low,'Workings Low'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(Q43/P43-1,0)","v":0}]
[null,null,"Energy Charges",{"$f":"'Monthly Average Bill'!M59","v":0},{"$f":"'Monthly Average Bill'!N59","v":0},{"$f":"IFERROR(E44/D44-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Energy_Charges_Current_Low,'Workings Low'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Energy_Charges_New_Low,'Workings Low'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(I44/H44-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Energy_Charges_Current_Low,'Workings Low'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Energy_Charges_New_Low,'Workings Low'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(M44/L44-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Energy_Charges_Current_Low,'Workings Low'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Energy_Charges_New_Low,'Workings Low'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(Q44/P44-1,0)","v":0}]
[null,null,"Other",{"$f":"'Monthly Average Bill'!M60","v":0},{"$f":"'Monthly Average Bill'!N60","v":0},{"$f":"IFERROR(E45/D45-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Other_Charges_Current_Low,'Workings Low'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Other_Charges_NEw_Low,'Workings Low'!$F$7:$AC$7,J$6),\"\")","v":0},{"$f":"IFERROR(I45/H45-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Other_Charges_Current_Low,'Workings Low'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Other_Charges_NEw_Low,'Workings Low'!$F$7:$AC$7,N$6),\"\")","v":0},{"$f":"IFERROR(M45/L45-1,0)","v":0},null,{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Other_Charges_Current_Low,'Workings Low'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Workings Low'!SPU_Other_Charges_NEw_Low,'Workings Low'!$F$7:$AC$7,R$6),\"\")","v":0},{"$f":"IFERROR(Q45/P45-1,0)","v":0}]
[]
[null,null,"Total",{"$f":"'Monthly Average Bill'!P48","v":1008.3125},{"$f":"'Monthly Average Bill'!Q48","v":1196.2874999999999},{"$f":"IFERROR(E47/D47-1,0)","v":0.18642533936651584},null,{"$f":"SUM(H43:H45)","v":0},{"$f":"SUM(I43:I45)","v":0},{"$f":"IFERROR(I47/H47-1,0)","v":0},null,{"$f":"SUM(L43:L45)","v":0},{"$f":"SUM(M43:M45)","v":0},{"$f":"IFERROR(M47/L47-1,0)","v":0},null,{"$f":"SUM(P43:P45)","v":0},{"$f":"SUM(Q43:Q45)","v":0},{"$f":"IFERROR(Q47/P47-1,0)","v":0}]
[]
[null,null,"Average price c/kWh",{"$f":"'Monthly Average Bill'!P53","v":0},{"$f":"'Monthly Average Bill'!Q53","v":0},{"$f":"IFERROR(E49/D49-1,0)","v":0},null,{"$f":"IFERROR(H47/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(I47/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(I49/H49-1,0)","v":0},null,{"$f":"IFERROR(L47/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(M47/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(M49/L49-1,0)","v":0},null,{"$f":"IFERROR(P47/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(Q47/(SPU_Annual_Total_Energy)*100,0)","v":0},{"$f":"IFERROR(Q49/P49-1,0)","v":0}]
[]
[]
[null,"Total Comparison",null,{"$f":"Current_Period","v":"2022/2023"},{"$f":"New_Period","v":"2023/2024"},"% Change"]
[]
[null,null,{"$f":"D39","v":"Landrate 4"},{"$f":"D47","v":1008.3125},{"$f":"E47","v":1196.2874999999999},{"$f":"IFERROR(E54/D54-1,0)","v":0.18642533936651584}]
[null,null,{"$f":"H39","v":"Homelight 20A"},{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"IFERROR(E55/D55-1,0)","v":0}]
[null,null,{"$f":"L39","v":"Homelight 60A"},{"$f":"L47","v":0},{"$f":"M47","v":0},{"$f":"IFERROR(E56/D56-1,0)","v":0}]
[null,null,{"$f":"P39","v":"Businessrate 4"},{"$f":"P47","v":0},{"$f":"Q47","v":0},{"$f":"IFERROR(E57/D57-1,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Descriptions"]
[null,null,"Rates Comparison"]
[null,null,"Average Price"]

{"sheet":"Rates Table","index":4,"n_rows":50,"n_cols":55,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Rates by Tariff"]
[]
[null,"Tariffs",null,null,{"$f":"Selected_Base_Tariff","v":"Landrate 4"},{"$f":"INDEX(Full_Tariff_List,F$7,)","v":"Businessrate 1"},"Businessrate 2","Businessrate 3","Businessrate 4","Homelight 20A","Homelight 60A","Homepower 1","Homepower 2","Homepower 3","Homepower 4","Homepower Bulk","Landrate 1","Landrate 2","Landrate 3","Landrate 4","Landrate Dx","Landlight 20A","Landlight 60A","Public Lighting All Night","Public Lighting 24 Hours","Homeflex 1","Homeflex 2","Homeflex 3","Homeflex 4",null,{"$f":"E6","v":"Landrate 4"},"Businessrate 1","Businessrate 2","Businessrate 3","Businessrate 4","Homelight 20A","Homelight 60A","Homepower 1","Homepower 2","Homepower 3","Homepower 4","Homepower Bulk","Landrate 1","Landrate 2","Landrate 3","Landrate 4","Landrate Dx","Landlight 20A","Landlight 60A","Public Lighting All Night","Public Lighting 24 Hours",{"$f":"Z6","v":"Homeflex 1"},{"$f":"AA6","v":"Homeflex 2"},{"$f":"AB6","v":"Homeflex 3"},{"$f":"AC6","v":"Homeflex 4"}]
[null,null,null,null,null,1,{"$f":"F7+1","v":2},{"$f":"G7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,{"$f":"T7+1","v":16},{"$f":"U7+1","v":17},{"$f":"V7+1","v":18},{"$f":"W7+1","v":19},{"$f":"X7+1","v":20},{"$f":"Y7+8","v":28},{"$f":"Z7+1","v":29},{"$f":"AA7+1","v":30},{"$f":"AB7+1","v":31}]
[null,"Network charges",null,"Units",{"$f":"Current_Period&\" Rates\"","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"New_Period&\" Rates\"","v":"2023/2024 Rates"},{"$f":"AE8","v":"2023/2024 Rates"},{"$f":"AF8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates",{"$f":"AT8","v":"2023/2024 Rates"},{"$f":"AU8","v":"2023/2024 Rates"},{"$f":"AV8","v":"2023/2024 Rates"},{"$f":"AW8","v":"2023/2024 Rates"},{"$f":"AX8","v":"2023/2024 Rates"},{"$f":"AY8","v":"2023/2024 Rates"},{"$f":"AZ8","v":"2023/2024 Rates"},{"$f":"BA8","v":"2023/2024 Rates"},{"$f":"BB8","v":"2023/2024 Rates"}]
[]
[null,null,"Distribution network demand charge","c/kWh",{"$f":"SUMIFS(F10:AC10,$F$7:$AC$7,Selected_Tariff_ID)","v":38.94},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":22.11},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":22.11},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":22.11},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":22.11},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":38.94},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":38.94},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":38.94},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":38.94},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge '[c/kWh']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":0},"n/a","n/a","n/a","n/a",null,{"$f":"SUMIFS(AF10:BC10,$F$7:$AC$7,Selected_Tariff_ID)","v":46.2},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":26.23},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":26.23},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":26.23},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":26.23},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":46.2},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":46.2},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":46.2},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":46.2},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network demand charge '[c/kWh']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":0},"n/a","n/a","n/a","n/a"]
[null,null,"Network demand charge, Ancillary service charge and retail","c/kWh",{"$f":"SUMIFS(F11:AC11,$F$7:$AC$7,Selected_Tariff_ID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_Current[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,{"$f":"SUMIFS(AF11:BC11,$F$7:$AC$7,Selected_Tariff_ID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_New[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":112.11},{"$f":"INDEX(Rates_AllOther_New[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":112.11},{"$f":"INDEX(Rates_AllOther_New[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":112.11},{"$f":"INDEX(Rates_AllOther_New[Network demand charge, Ancillary service charge and retail '[c/kWh']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":112.11}]
[null,null,"Network capacity charge",{"$f":"IF(Table_1=1,\"R/kVA\",\"R/day\")","v":"R/day"},{"$f":"SUMIFS(F12:AC12,$F$7:$AC$7,Selected_Tariff_ID)","v":33.15},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":31.75},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":53.5},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":92.43},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":7.86},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":14.73},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":30.42},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":4.8},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":49.88},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":41.63},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":63.99},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":102.3},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":33.15},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Network capacity charge '[R/POD/day']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,{"$f":"SUMIFS(AF12:BC12,$F$7:$AC$7,Selected_Tariff_ID)","v":39.33},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":37.67},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":63.48},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":109.67},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":9.33},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":17.48},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":36.090000000000003},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":5.7},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":59.18},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":49.39},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":75.92},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":121.38},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":39.33},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":9.33},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":17.48},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":36.090000000000003},{"$f":"INDEX(Rates_AllOther_New[Network capacity charge '[R/POD/day']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":5.7}]
[]
[null,"Total network charges"]
[]
[null,"Energy charges - High",null,"Units",{"$f":"E$8","v":"2022/2023 Rates"},{"$f":"F$8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"AE$8","v":"2023/2024 Rates"},{"$f":"AF$8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Energy","c/kWh",{"$f":"SUMIFS(F18:AC18,$F$7:$AC$7,Selected_Tariff_ID)","v":336.63},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":156.62},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":156.62},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":156.62},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":421.49},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":241.01},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":155.85},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":155.85},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":155.85},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":336.63},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":448.16},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":577.73},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":124.64},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":166.89},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge '[c/kWh']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,{"$f":"SUMIFS(AF18:BC18,$F$7:$AC$7,Selected_Tariff_ID)","v":399.41},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":185.83},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":185.83},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":185.83},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":500.1},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":285.95999999999998},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":184.92},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":184.92},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":184.92},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":399.41},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":531.74},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":685.48},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":147.88999999999999},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":198.01},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge '[c/kWh']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":0}]
[null,null,"Peak consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_Current[High - Peak],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High - Peak],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High - Peak],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High - Peak],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_New[High - Peak],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":542.79},{"$f":"INDEX(Rates_AllOther_New[High - Peak],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":542.79},{"$f":"INDEX(Rates_AllOther_New[High - Peak],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":542.79},{"$f":"INDEX(Rates_AllOther_New[High - Peak],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":542.79}]
[null,null,"Standard consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_Current[High - Standard],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High - Standard],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High - Standard],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High - Standard],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_New[High - Standard],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":165.14},{"$f":"INDEX(Rates_AllOther_New[High - Standard],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":165.14},{"$f":"INDEX(Rates_AllOther_New[High - Standard],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":165.14},{"$f":"INDEX(Rates_AllOther_New[High - Standard],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":165.14}]
[null,null,"Off-Peak consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_Current[High-Off Peak],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High-Off Peak],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High-Off Peak],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[High-Off Peak],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Rates_AllOther_New[High-Off Peak],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":90.17},{"$f":"INDEX(Rates_AllOther_New[High-Off Peak],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":90.17},{"$f":"INDEX(Rates_AllOther_New[High-Off Peak],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":90.17},{"$f":"INDEX(Rates_AllOther_New[High-Off Peak],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":90.17}]
[null,null,"Energy - Block 1","c/kWh",0,{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":153.44},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":173.67},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":183.56},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":183.56},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":183.56},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":183.56},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 1 '[c/kWh']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,0,{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":168.78},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":206.06},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":217.79},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":217.79},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":217.79},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":217.79},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 1 '[c/kWh']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":0}]
[null,null,"Energy - Block 2","c/kWh",0,{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":173.86},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":295.19},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":289.85000000000002},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":282.62},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":282.62},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":295.19},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Energy charge Block 2 '[c/kWh']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,0,{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":191.25},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":350.24},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":343.91},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":335.33},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":335.33},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":350.24},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Energy charge Block 2 '[c/kWh']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":0}]
[]
[null,"Total energy charges"]
[]
[null,"Other charges",null,"Units",{"$f":"E$8","v":"2022/2023 Rates"},{"$f":"F$8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"AE$8","v":"2023/2024 Rates"},{"$f":"AF$8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Ancillary service charge ","c/kWh",{"$f":"SUMIFS(F29:AC29,$F$7:$AC$7,Selected_Tariff_ID)","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":0.6},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Ancillary service charge '[c/kWh']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,{"$f":"SUMIFS(AF29:BC29,$F$7:$AC$7,Selected_Tariff_ID)","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":0.71},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Ancillary service charge '[c/kWh']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":0}]
[null,null,"Service charge",{"$f":"IF(Table_1=1,\"R/day\",\"R/day\")","v":"R/day"},{"$f":"SUMIFS(F30:AC30,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(F$37,Rates_AllOther_Current[Code],0))","v":27.44},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(G$37,Rates_AllOther_Current[Code],0))","v":27.44},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(H$37,Rates_AllOther_Current[Code],0))","v":27.44},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(I$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(J$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(K$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(L$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(M$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(N$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(O$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(P$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(Q$37,Rates_AllOther_Current[Code],0))","v":34.57},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(R$37,Rates_AllOther_Current[Code],0))","v":34.57},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(S$37,Rates_AllOther_Current[Code],0))","v":34.57},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(T$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(U$37,Rates_AllOther_Current[Code],0))","v":74.14},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(V$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(W$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(X$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(Y$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(Z$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(AA$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(AB$37,Rates_AllOther_Current[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_Current[Service and administration charge '[R/POD/day']],MATCH(AC$37,Rates_AllOther_Current[Code],0))","v":0},null,{"$f":"SUMIFS(AF30:BC30,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AF$37,Rates_AllOther_New[Code],0))","v":32.56},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AG$37,Rates_AllOther_New[Code],0))","v":32.56},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AH$37,Rates_AllOther_New[Code],0))","v":32.56},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AI$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AJ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AK$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AL$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AM$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AN$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AO$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AP$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AQ$37,Rates_AllOther_New[Code],0))","v":41.02},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AR$37,Rates_AllOther_New[Code],0))","v":41.02},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AS$37,Rates_AllOther_New[Code],0))","v":41.02},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AT$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AU$37,Rates_AllOther_New[Code],0))","v":87.97},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AV$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AW$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AX$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AY$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(AZ$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(BA$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(BB$37,Rates_AllOther_New[Code],0))","v":0},{"$f":"INDEX(Rates_AllOther_New[Service and administration charge '[R/POD/day']],MATCH(BC$37,Rates_AllOther_New[Code],0))","v":0}]
[]
[null,"Total other charges"]
[]
[null,"Lookup values"]
[null,null,"Rates LPU Energy Table",null,{"$f":"SUMIFS(F35:AC35,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"F6&\"_\"&$D48&\"_\"&$D47&\"_\"&$D46","v":"Businessrate 1_Non-Local Authority_Not Applicable_< 500V"},"Businessrate 2_Non-Local Authority_Not Applicable_< 500V","Businessrate 3_Non-Local Authority_Not Applicable_< 500V","Businessrate 4_Non-Local Authority_Not Applicable_< 500V","Homelight 20A_Non-Local Authority_Not Applicable_< 500V","Homelight 60A_Non-Local Authority_Not Applicable_< 500V","Homepower 1_Non-Local Authority_Not Applicable_< 500V","Homepower 2_Non-Local Authority_Not Applicable_< 500V","Homepower 3_Non-Local Authority_Not Applicable_< 500V","Homepower 4_Non-Local Authority_Not Applicable_< 500V","Homepower Bulk_Non-Local Authority_Not Applicable_< 500V","Landrate 1_Non-Local Authority_Not Applicable_< 500V","Landrate 2_Non-Local Authority_Not Applicable_< 500V","Landrate 3_Non-Local Authority_Not Applicable_< 500V","Landrate 4_Non-Local Authority_Not Applicable_< 500V","Landrate Dx_Non-Local Authority_Not Applicable_< 500V","Landlight 20A_Non-Local Authority_Not Applicable_< 500V","Landlight 60A_Non-Local Authority_Not Applicable_< 500V","Public Lighting All Night_Non-Local Authority_Not Applicable_< 500V","Public Lighting 24 Hours_Non-Local Authority_Not Applicable_< 500V","Homeflex 1_Non-Local Authority_Not Applicable_< 500V","Homeflex 2_Non-Local Authority_Not Applicable_< 500V","Homeflex 3_Non-Local Authority_Not Applicable_< 500V","Homeflex 4_Non-Local Authority_Not Applicable_< 500V",null,{"$f":"SUMIFS(AF35:BC35,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"F35","v":"Businessrate 1_Non-Local Authority_Not Applicable_< 500V"},"Businessrate 2_Non-Local Authority_Not Applicable_< 500V","Businessrate 3_Non-Local Authority_Not Applicable_< 500V","Businessrate 4_Non-Local Authority_Not Applicable_< 500V","Homelight 20A_Non-Local Authority_Not Applicable_< 500V","Homelight 60A_Non-Local Authority_Not Applicable_< 500V","Homepower 1_Non-Local Authority_Not Applicable_< 500V","Homepower 2_Non-Local Authority_Not Applicable_< 500V","Homepower 3_Non-Local Authority_Not Applicable_< 500V","Homepower 4_Non-Local Authority_Not Applicable_< 500V","Homepower Bulk_Non-Local Authority_Not Applicable_< 500V","Landrate 1_Non-Local Authority_Not Applicable_< 500V","Landrate 2_Non-Local Authority_Not Applicable_< 500V","Landrate 3_Non-Local Authority_Not Applicable_< 500V","Landrate 4_Non-Local Authority_Not Applicable_< 500V",{"$f":"U35","v":"Landrate Dx_Non-Local Authority_Not Applicable_< 500V"},"Landlight 20A_Non-Local Authority_Not Applicable_< 500V","Landlight 60A_Non-Local Authority_Not Applicable_< 500V","Public Lighting All Night_Non-Local Authority_Not Applicable_< 500V","Public Lighting 24 Hours_Non-Local Authority_Not Applicable_< 500V",{"$f":"Z35","v":"Homeflex 1_Non-Local Authority_Not Applicable_< 500V"},{"$f":"AA35","v":"Homeflex 2_Non-Local Authority_Not Applicable_< 500V"},{"$f":"AB35","v":"Homeflex 3_Non-Local Authority_Not Applicable_< 500V"},{"$f":"AC35","v":"Homeflex 4_Non-Local Authority_Not Applicable_< 500V"}]
[null,null,"Rates LPU by Voltage",null,0,{"$f":"F6&\"_\"&$D48&\"_\"&$D46","v":"Businessrate 1_Non-Local Authority_< 500V"},"Businessrate 2_Non-Local Authority_< 500V","Businessrate 3_Non-Local Authority_< 500V","Businessrate 4_Non-Local Authority_< 500V","Homelight 20A_Non-Local Authority_< 500V","Homelight 60A_Non-Local Authority_< 500V","Homepower 1_Non-Local Authority_< 500V","Homepower 2_Non-Local Authority_< 500V","Homepower 3_Non-Local Authority_< 500V","Homepower 4_Non-Local Authority_< 500V","Homepower Bulk_Non-Local Authority_< 500V","Landrate 1_Non-Local Authority_< 500V","Landrate 2_Non-Local Authority_< 500V","Landrate 3_Non-Local Authority_< 500V","Landrate 4_Non-Local Authority_< 500V","Landrate Dx_Non-Local Authority_< 500V","Landlight 20A_Non-Local Authority_< 500V","Landlight 60A_Non-Local Authority_< 500V","Public Lighting All Night_Non-Local Authority_< 500V","Public Lighting 24 Hours_Non-Local Authority_< 500V","Homeflex 1_Non-Local Authority_< 500V","Homeflex 2_Non-Local Authority_< 500V","Homeflex 3_Non-Local Authority_< 500V","Homeflex 4_Non-Local Authority_< 500V",null,0,"Businessrate 1_Non-Local Authority_< 500V","Businessrate 2_Non-Local Authority_< 500V","Businessrate 3_Non-Local Authority_< 500V","Businessrate 4_Non-Local Authority_< 500V","Homelight 20A_Non-Local Authority_< 500V","Homelight 60A_Non-Local Authority_< 500V","Homepower 1_Non-Local Authority_< 500V","Homepower 2_Non-Local Authority_< 500V","Homepower 3_Non-Local Authority_< 500V","Homepower 4_Non-Local Authority_< 500V","Homepower Bulk_Non-Local Authority_< 500V","Landrate 1_Non-Local Authority_< 500V","Landrate 2_Non-Local Authority_< 500V","Landrate 3_Non-Local Authority_< 500V","Landrate 4_Non-Local Authority_< 500V","Landrate Dx_Non-Local Authority_< 500V","Landlight 20A_Non-Local Authority_< 500V","Landlight 60A_Non-Local Authority_< 500V","Public Lighting All Night_Non-Local Authority_< 500V","Public Lighting 24 Hours_Non-Local Authority_< 500V","Homeflex 1_Non-Local Authority_< 500V","Homeflex 2_Non-Local Authority_< 500V","Homeflex 3_Non-Local Authority_< 500V","Homeflex 4_Non-Local Authority_< 500V"]
[null,null,"Rates SPU",null,0,{"$f":"F6&\"_\"&$D48","v":"Businessrate 1_Non-Local Authority"},"Businessrate 2_Non-Local Authority","Businessrate 3_Non-Local Authority","Businessrate 4_Non-Local Authority","Homelight 20A_Non-Local Authority","Homelight 60A_Non-Local Authority","Homepower 1_Non-Local Authority","Homepower 2_Non-Local Authority","Homepower 3_Non-Local Authority","Homepower 4_Non-Local Authority","Homepower Bulk_Non-Local Authority","Landrate 1_Non-Local Authority","Landrate 2_Non-Local Authority","Landrate 3_Non-Local Authority","Landrate 4_Non-Local Authority","Landrate Dx_Non-Local Authority","Landlight 20A_Non-Local Authority","Landlight 60A_Non-Local Authority","Public Lighting All Night_Non-Local Authority","Public Lighting 24 Hours_Non-Local Authority","Homeflex 1_Non-Local Authority","Homeflex 2_Non-Local Authority","Homeflex 3_Non-Local Authority","Homeflex 4_Non-Local Authority",null,0,"Businessrate 1_Non-Local Authority","Businessrate 2_Non-Local Authority","Businessrate 3_Non-Local Authority","Businessrate 4_Non-Local Authority","Homelight 20A_Non-Local Authority","Homelight 60A_Non-Local Authority","Homepower 1_Non-Local Authority","Homepower 2_Non-Local Authority","Homepower 3_Non-Local Authority","Homepower 4_Non-Local Authority","Homepower Bulk_Non-Local Authority","Landrate 1_Non-Local Authority","Landrate 2_Non-Local Authority","Landrate 3_Non-Local Authority","Landrate 4_Non-Local Authority","Landrate Dx_Non-Local Authority","Landlight 20A_Non-Local Authority","Landlight 60A_Non-Local Authority","Public Lighting All Night_Non-Local Authority","Public Lighting 24 Hours_Non-Local Authority","Homeflex 1_Non-Local Authority","Homeflex 2_Non-Local Authority","Homeflex 3_Non-Local Authority","Homeflex 4_Non-Local Authority"]
[null,null,"Admin & Service Charges",null,0,{"$f":"$D45&\"_\"&$D48&\"_\"&$D50","v":"Rural_Non-Local Authority_≤100kVA"},"Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA",{"$f":"$D45&\"_\"&$D48&\"_\"&$D50","v":"Rural_Non-Local Authority_≤100kVA"},"Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA",null,0,"Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA","Rural_Non-Local Authority_≤100kVA"]
[null,null,null,null,0,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]
[null,"Check tables",null,null,0,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]
[null,null,"Table 1: 1 = LPU, 0 = SPU",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"F41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U41","v":0},0,0,0,0,{"$f":"Z41","v":0},{"$f":"AA41","v":0},{"$f":"AB41","v":0},{"$f":"AC41","v":0}]
[]
[null,"Assumptions"]
[null,null,"Tariff:",{"$f":"Selected_Base_Tariff","v":"Landrate 4"}]
[null,null,"Type",{"$f":"INDEX(Full_Tariff_Type,MATCH(D44,Full_Tariff_List,0))","v":"Rural"}]
[null,null,"Supply voltage",{"$f":"Selected_Supply_Voltage","v":"< 500V"}]
[null,null,"Transmission zone",{"$f":"Selected_Transmission","v":"Not Applicable"}]
[null,null,"Tariff Category",{"$f":"Selected_Tariff_Category","v":"Non-Local Authority"}]
[null,null,"No of PODS",{"$f":"PODs","v":1}]
[null,null,"Size of supply",{"$f":"IF(Selected_Customer_Category_ID=1,Lists!N21,Selected_Supply_Size)","v":"≤100kVA"}]

{"sheet":"Workings High","index":5,"n_rows":43,"n_cols":55,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Calculations by Tariff"]
[]
[null,"Tariffs",null,null,{"$f":"Selected_Base_Tariff","v":"Landrate 4"},{"$f":"INDEX(Full_Tariff_List,F$7,)","v":"Businessrate 1"},"Businessrate 2","Businessrate 3","Businessrate 4","Homelight 20A","Homelight 60A","Homepower 1","Homepower 2","Homepower 3","Homepower 4","Homepower Bulk","Landrate 1","Landrate 2","Landrate 3","Landrate 4","Landrate Dx","Landlight 20A","Landlight 60A","Public Lighting All Night","Public Lighting 24 Hours","Homeflex 1","Homeflex 2","Homeflex 3","Homeflex 4",null,{"$f":"E6","v":"Landrate 4"},"Businessrate 1","Businessrate 2","Businessrate 3","Businessrate 4","Homelight 20A","Homelight 60A","Homepower 1","Homepower 2","Homepower 3","Homepower 4","Homepower Bulk","Landrate 1","Landrate 2","Landrate 3","Landrate 4","Landrate Dx","Landlight 20A","Landlight 60A","Public Lighting All Night","Public Lighting 24 Hours","Homeflex 1","Homeflex 2","Homeflex 3","Homeflex 4"]
[null,null,null,null,null,1,{"$f":"F7+1","v":2},{"$f":"G7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,{"$f":"T7+1","v":16},{"$f":"U7+1","v":17},{"$f":"V7+1","v":18},{"$f":"W7+1","v":19},{"$f":"X7+1","v":20},{"$f":"Y7+8","v":28},{"$f":"Z7+1","v":29},{"$f":"AA7+1","v":30},{"$f":"AB7+1","v":31},null,{"$f":"E7","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,28,29,30,31]
[null,"Network charges",null,"Units",{"$f":"Current_Period&\" Rates\"","v":"2022/2023 Rates"},{"$f":"E8","v":"2022/2023 Rates"},{"$f":"F8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",{"$f":"T8","v":"2022/2023 Rates"},{"$f":"U8","v":"2022/2023 Rates"},{"$f":"V8","v":"2022/2023 Rates"},{"$f":"W8","v":"2022/2023 Rates"},{"$f":"X8","v":"2022/2023 Rates"},{"$f":"Y8","v":"2022/2023 Rates"},{"$f":"Z8","v":"2022/2023 Rates"},{"$f":"AA8","v":"2022/2023 Rates"},{"$f":"AB8","v":"2022/2023 Rates"},null,{"$f":"New_Period&\" Rates\"","v":"2023/2024 Rates"},{"$f":"AE8","v":"2023/2024 Rates"},{"$f":"AF8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates",{"$f":"AT8","v":"2023/2024 Rates"},{"$f":"AU8","v":"2023/2024 Rates"},{"$f":"AV8","v":"2023/2024 Rates"},{"$f":"AW8","v":"2023/2024 Rates"},{"$f":"AX8","v":"2023/2024 Rates"},{"$f":"AY8","v":"2023/2024 Rates"},{"$f":"AZ8","v":"2023/2024 Rates"},{"$f":"BA8","v":"2023/2024 Rates"},{"$f":"BB8","v":"2023/2024 Rates"}]
[]
[null,null,"Distribution network demand charge","c/kWh",{"$f":"SUMIFS(F10:AC10,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!F10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!G10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!H10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!I10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!J10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!K10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!L10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!M10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!N10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!O10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!P10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!R10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!S10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!T10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!U10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!V10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!W10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!X10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC10*SPU_Annual_Total_Energy,0)/100","v":0},null,{"$f":"SUMIFS(AF10:BC10,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!AF10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC10*SPU_Annual_Total_Energy,0)/100","v":0}]
[null,null,"Network demand charge, Ancillary service charge and retail","c/kWh",{"$f":"SUMIFS(F11:AC11,$F$7:$AC$7,Selected_Tariff_ID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC11*SPU_Annual_Total_Energy,0)/100","v":0},null,{"$f":"SUMIFS(AF11:BC11,$F$7:$AC$7,Selected_Tariff_ID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!AZ11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC11*SPU_Annual_Total_Energy,0)/100","v":0}]
[null,null,"Network capacity charge",{"$f":"IF(Table_1=1,\"R/kVA\",\"R/day\")","v":"R/day"},{"$f":"SUMIFS(F12:AC12,$F$7:$AC$7,Selected_Tariff_ID)","v":1008.3125},{"$f":"IFERROR('Rates Table'!F12*PODs*ESKOM_Total_days,0)","v":965.72916666666674},{"$f":"IFERROR('Rates Table'!G12*PODs*ESKOM_Total_days,0)","v":1627.2916666666667},{"$f":"IFERROR('Rates Table'!H12*PODs*ESKOM_Total_days,0)","v":2811.4125000000004},{"$f":"IFERROR('Rates Table'!I12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!J12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!K12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!L12*PODs*ESKOM_Total_days,0)","v":239.07500000000002},{"$f":"IFERROR('Rates Table'!M12*PODs*ESKOM_Total_days,0)","v":448.03750000000002},{"$f":"IFERROR('Rates Table'!N12*PODs*ESKOM_Total_days,0)","v":925.27500000000009},{"$f":"IFERROR('Rates Table'!O12*PODs*ESKOM_Total_days,0)","v":146},{"$f":"IFERROR('Rates Table'!P12*PODs*ESKOM_Total_days,0)","v":1517.1833333333334},{"$f":"IFERROR('Rates Table'!Q12*PODs*ESKOM_Total_days,0)","v":1266.2458333333334},{"$f":"IFERROR('Rates Table'!R12*PODs*ESKOM_Total_days,0)","v":1946.3625000000002},{"$f":"IFERROR('Rates Table'!S12*PODs*ESKOM_Total_days,0)","v":3111.625},{"$f":"IFERROR('Rates Table'!T12*PODs*ESKOM_Total_days,0)","v":1008.3125},{"$f":"IFERROR('Rates Table'!U12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!V12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!W12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!X12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Y12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Z12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AA12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AB12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AC12*PODs*ESKOM_Total_days,0)","v":0},null,{"$f":"SUMIFS(AF12:BC12,$F$7:$AC$7,Selected_Tariff_ID)","v":1196.2874999999999},{"$f":"IFERROR('Rates Table'!AF12*PODs*ESKOM_Total_days,0)","v":1145.7958333333333},{"$f":"IFERROR('Rates Table'!AG12*PODs*ESKOM_Total_days,0)","v":1930.85},{"$f":"IFERROR('Rates Table'!AH12*PODs*ESKOM_Total_days,0)","v":3335.7958333333336},{"$f":"IFERROR('Rates Table'!AI12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AJ12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AK12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AL12*PODs*ESKOM_Total_days,0)","v":283.78750000000002},{"$f":"IFERROR('Rates Table'!AM12*PODs*ESKOM_Total_days,0)","v":531.68333333333339},{"$f":"IFERROR('Rates Table'!AN12*PODs*ESKOM_Total_days,0)","v":1097.7375000000002},{"$f":"IFERROR('Rates Table'!AO12*PODs*ESKOM_Total_days,0)","v":173.375},{"$f":"IFERROR('Rates Table'!AP12*PODs*ESKOM_Total_days,0)","v":1800.0583333333334},{"$f":"IFERROR('Rates Table'!AQ12*PODs*ESKOM_Total_days,0)","v":1502.2791666666667},{"$f":"IFERROR('Rates Table'!AR12*PODs*ESKOM_Total_days,0)","v":2309.2333333333336},{"$f":"IFERROR('Rates Table'!AS12*PODs*ESKOM_Total_days,0)","v":3691.9749999999999},{"$f":"IFERROR('Rates Table'!AT12*PODs*ESKOM_Total_days,0)","v":1196.2874999999999},{"$f":"IFERROR('Rates Table'!AU12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AV12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AW12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AX12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AY12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AZ12*PODs*ESKOM_Total_days,0)","v":283.78750000000002},{"$f":"IFERROR('Rates Table'!BA12*PODs*ESKOM_Total_days,0)","v":531.68333333333339},{"$f":"IFERROR('Rates Table'!BB12*PODs*ESKOM_Total_days,0)","v":1097.7375000000002},{"$f":"IFERROR('Rates Table'!BC12*PODs*ESKOM_Total_days,0)","v":173.375}]
[]
[null,"Total network charges",null,null,{"$f":"SUM(E10:E12)","v":1008.3125},965.72916666666674,1627.2916666666667,2811.4125000000004,0,0,0,239.07500000000002,448.03750000000002,925.27500000000009,146,1517.1833333333334,1266.2458333333334,1946.3625000000002,3111.625,1008.3125,{"$f":"SUM(U10:U12)","v":0},0,0,0,0,0,{"$f":"SUM(AA10:AA12)","v":0},0,0,null,{"$f":"SUM(AE10:AE12)","v":1196.2874999999999},{"$f":"SUM(AF10:AF12)","v":1145.7958333333333},1930.85,3335.7958333333336,0,0,0,283.78750000000002,531.68333333333339,1097.7375000000002,173.375,1800.0583333333334,1502.2791666666667,2309.2333333333336,3691.9749999999999,1196.2874999999999,{"$f":"SUM(AU10:AU12)","v":0},0,0,0,0,283.78750000000002,{"$f":"SUM(BA10:BA12)","v":531.68333333333339},1097.7375000000002,173.375]
[]
[null,"Energy charges",null,"Units",{"$f":"E$8","v":"2022/2023 Rates"},{"$f":"F$8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"AE$8","v":"2023/2024 Rates"},{"$f":"AF$8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Energy","c/kWh",{"$f":"SUMIFS(F18:AC18,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!F18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!G18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!H18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!I18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!J18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!K18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!L18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!M18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!N18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!O18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!P18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!R18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!S18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!T18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!U18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!V18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!W18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!X18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC18*(SPU_Annual_Total_Energy),0)/100","v":0},null,{"$f":"SUMIFS(AF18:BC18,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!AF18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC18*(SPU_Annual_Total_Energy),0)/100","v":0}]
[null,null,"Peak consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC19*(Homeflex_Peak_Energy),0)/100","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!AZ19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC19*(Homeflex_Peak_Energy),0)/100","v":0}]
[null,null,"Standard consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC20*(Homeflex_Standard_Energy),0)/100","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!AZ20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC20*(Homeflex_Standard_Energy),0)/100","v":0}]
[null,null,"Off-Peak consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC21*(Homeflex_OffPeak_Energy),0)/100","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!AZ21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC21*(Homeflex_OffPeak_Energy),0)/100","v":0}]
[null,null,"Energy - Block 1","c/kWh",0,{"$f":"IFERROR('Rates Table'!F22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!G22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!H22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!I22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!J22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!K22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!L22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!M22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!N22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!O22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!P22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!R22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!S22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!T22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!U22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!V22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!W22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!X22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC22*(SPU_Block_1),0)/100","v":0},null,0,{"$f":"IFERROR('Rates Table'!AF22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC22*(SPU_Block_1),0)/100","v":0}]
[null,null,"Energy - Block 2","c/kWh",0,{"$f":"IFERROR('Rates Table'!F23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!G23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!H23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!I23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!J23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!K23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!L23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!M23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!N23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!O23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!P23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!R23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!S23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!T23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!U23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!V23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!W23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!X23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC23*(SPU_Block_2),0)/100","v":0},null,0,{"$f":"IFERROR('Rates Table'!AF23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC23*(SPU_Block_2),0)/100","v":0}]
[]
[null,"Total energy charges",null,null,{"$f":"SUM(E18:E23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U18:U23)","v":0},0,0,0,0,0,{"$f":"SUM(AA18:AA23)","v":0},0,0,null,{"$f":"SUM(AE18:AE23)","v":0},{"$f":"SUM(AF18:AF23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AU18:AU23)","v":0},0,0,0,0,0,{"$f":"SUM(BA18:BA23)","v":0},0,0]
[]
[null,"Other charges",null,"Units",{"$f":"E$8","v":"2022/2023 Rates"},{"$f":"F$8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"AE$8","v":"2023/2024 Rates"},{"$f":"AF$8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Ancillary service charge ","c/kWh",{"$f":"SUMIFS(F29:AC29,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!F29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!G29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!H29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!I29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!J29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!K29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!L29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!M29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!N29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!O29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!P29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!Q29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!R29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!S29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!T29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!U29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!V29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!W29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!X29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!Y29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!Z29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AA29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AB29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AC29,0)/100","v":0},null,{"$f":"SUMIFS(AF29:BC29,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AF29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AG29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AH29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AI29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AJ29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AK29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AL29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AM29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AN29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AO29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AP29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AQ29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AR29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AS29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AT29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AU29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AV29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AW29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AX29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AY29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AZ29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!BA29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!BB29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!BC29,0)/100","v":0}]
[null,null,"Service charge",{"$f":"IF(Table_1=1,\"R/day\",\"R/day\")","v":"R/day"},{"$f":"SUMIFS(F30:AC30,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!F30*PODs*ESKOM_Total_days,0)","v":834.63333333333344},{"$f":"IFERROR('Rates Table'!G30*PODs*ESKOM_Total_days,0)","v":834.63333333333344},{"$f":"IFERROR('Rates Table'!H30*PODs*ESKOM_Total_days,0)","v":834.63333333333344},{"$f":"IFERROR('Rates Table'!I30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!J30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!K30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!L30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!M30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!N30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!O30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!P30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Q30*PODs*ESKOM_Total_days,0)","v":1051.5041666666666},{"$f":"IFERROR('Rates Table'!R30*PODs*ESKOM_Total_days,0)","v":1051.5041666666666},{"$f":"IFERROR('Rates Table'!S30*PODs*ESKOM_Total_days,0)","v":1051.5041666666666},{"$f":"IFERROR('Rates Table'!T30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!U30*PODs*ESKOM_Total_days,0)","v":2255.0916666666667},{"$f":"IFERROR('Rates Table'!V30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!W30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!X30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Y30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Z30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AA30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AB30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AC30*PODs*ESKOM_Total_days,0)","v":0},null,{"$f":"SUMIFS(AF30:BC30,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!AF30*PODs*ESKOM_Total_days,0)","v":990.36666666666679},{"$f":"IFERROR('Rates Table'!AG30*PODs*ESKOM_Total_days,0)","v":990.36666666666679},{"$f":"IFERROR('Rates Table'!AH30*PODs*ESKOM_Total_days,0)","v":990.36666666666679},{"$f":"IFERROR('Rates Table'!AI30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AJ30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AK30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AL30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AM30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AN30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AO30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AP30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AQ30*PODs*ESKOM_Total_days,0)","v":1247.6916666666668},{"$f":"IFERROR('Rates Table'!AR30*PODs*ESKOM_Total_days,0)","v":1247.6916666666668},{"$f":"IFERROR('Rates Table'!AS30*PODs*ESKOM_Total_days,0)","v":1247.6916666666668},{"$f":"IFERROR('Rates Table'!AT30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AU30*PODs*ESKOM_Total_days,0)","v":2675.7541666666666},{"$f":"IFERROR('Rates Table'!AV30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AW30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AX30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AY30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AZ30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!BA30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!BB30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!BC30*PODs*ESKOM_Total_days,0)","v":0}]
[]
[null,"Total other charges",null,null,{"$f":"SUM(E28:E30)","v":0},834.63333333333344,834.63333333333344,834.63333333333344,0,0,0,0,0,0,0,0,1051.5041666666666,1051.5041666666666,1051.5041666666666,0,{"$f":"SUM(U28:U30)","v":2255.0916666666667},0,0,0,0,0,{"$f":"SUM(AA28:AA30)","v":0},0,0,null,{"$f":"SUM(AE28:AE30)","v":0},{"$f":"SUM(AF28:AF30)","v":990.36666666666679},990.36666666666679,990.36666666666679,0,0,0,0,0,0,0,0,1247.6916666666668,1247.6916666666668,1247.6916666666668,0,{"$f":"SUM(AU28:AU30)","v":2675.7541666666666},0,0,0,0,0,{"$f":"SUM(BA28:BA30)","v":0},0,0]
[]
[null,"Total excl VAT",null,null,{"$f":"E32+E25+E14","v":1008.3125},1800.3625000000002,2461.9250000000002,3646.0458333333336,0,0,0,239.07500000000002,448.03750000000002,925.27500000000009,146,1517.1833333333334,2317.75,2997.8666666666668,4163.1291666666666,1008.3125,{"$f":"U32+U25+U14","v":2255.0916666666667},0,0,0,0,0,{"$f":"AA32+AA25+AA14","v":0},0,0,null,{"$f":"AE32+AE25+AE14","v":1196.2874999999999},{"$f":"AF32+AF25+AF14","v":2136.1625000000004},2921.2166666666667,4326.1625000000004,0,0,0,283.78750000000002,531.68333333333339,1097.7375000000002,173.375,1800.0583333333334,2749.9708333333338,3556.9250000000002,4939.666666666667,1196.2874999999999,{"$f":"AU32+AU25+AU14","v":2675.7541666666666},0,0,0,0,283.78750000000002,{"$f":"BA32+BA25+BA14","v":531.68333333333339},1097.7375000000002,173.375]
[null,"VAT",null,{"$f":"'Monthly Average Bill'!D49","v":0.15},{"$f":"E34*$D35","v":151.24687499999999},{"$f":"F34*$D35","v":270.05437499999999},369.28874999999999,546.90687500000001,0,0,0,35.861249999999998,67.205624999999998,138.79125000000002,21.9,227.57750000000001,347.66249999999997,449.68,624.46937500000001,151.24687499999999,{"$f":"U34*$D35","v":338.26375000000002},0,0,0,0,0,{"$f":"AA34*$D35","v":0},0,0,null,{"$f":"AE34*$D35","v":179.44312499999998},{"$f":"AF34*$D35","v":320.42437500000005},{"$f":"AG34*$D35","v":438.1825},{"$f":"AH34*$D35","v":648.92437500000005},{"$f":"AI34*$D35","v":0},{"$f":"AJ34*$D35","v":0},{"$f":"AK34*$D35","v":0},{"$f":"AL34*$D35","v":42.568125000000002},{"$f":"AM34*$D35","v":79.752500000000012},{"$f":"AN34*$D35","v":164.66062500000001},{"$f":"AO34*$D35","v":26.006249999999998},{"$f":"AP34*$D35","v":270.00875000000002},{"$f":"AQ34*$D35","v":412.49562500000008},{"$f":"AR34*$D35","v":533.53875000000005},{"$f":"AS34*$D35","v":740.95},{"$f":"AT34*$D35","v":179.44312499999998},{"$f":"AU34*$D35","v":401.36312499999997},0,0,0,0,42.568125000000002,{"$f":"BA34*$D35","v":79.752500000000012},164.66062500000001,26.006249999999998]
[]
[null,"Total account",null,null,{"$f":"SUM(E34:E35)","v":1159.559375},{"$f":"SUM(F34:F35)","v":2070.4168750000003},2831.2137500000003,4192.9527083333332,0,0,0,274.93625000000003,515.24312499999996,1064.0662500000001,167.9,1744.7608333333335,2665.4124999999999,3447.5466666666666,4787.5985416666663,1159.559375,{"$f":"SUM(U34:U35)","v":2593.3554166666668},0,0,0,0,0,{"$f":"SUM(AA34:AA35)","v":0},0,0,null,{"$f":"SUM(AE34:AE35)","v":1375.7306249999999},{"$f":"SUM(AF34:AF35)","v":2456.5868750000004},3359.3991666666666,4975.0868750000009,0,0,0,326.35562500000003,611.43583333333345,1262.3981250000002,199.38124999999999,2070.0670833333334,3162.4664583333338,4090.4637500000003,5680.6166666666668,1375.7306249999999,{"$f":"SUM(AU34:AU35)","v":3077.1172916666665},0,0,0,0,326.35562500000003,{"$f":"SUM(BA34:BA35)","v":611.43583333333345},1262.3981250000002,199.38124999999999]
[]
[null,"Average price c/kWh",null,null,{"$f":"SUMIFS(F39:AC39,$F$7:$AC$7,Selected_Tariff_ID)","v":{"$error":"#DIV/0!"}},{"$f":"F34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"H34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"U34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AA34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUMIFS(AF39:BC39,$F$7:$AC$7,Selected_Tariff_ID)","v":{"$error":"#DIV/0!"}},{"$f":"AF34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AU34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"BA34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Check tables"]
[null,null,"Table 1: 1 = LPU, 0 = SPU",null,{"$f":"SUMIFS(F42:AC42,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"'Rates Table'!F41","v":0},{"$f":"'Rates Table'!G41","v":0},{"$f":"'Rates Table'!H41","v":0},{"$f":"'Rates Table'!I41","v":0},{"$f":"'Rates Table'!J41","v":0},{"$f":"'Rates Table'!K41","v":0},{"$f":"'Rates Table'!L41","v":0},{"$f":"'Rates Table'!M41","v":0},{"$f":"'Rates Table'!N41","v":0},{"$f":"'Rates Table'!O41","v":0},{"$f":"'Rates Table'!P41","v":0},{"$f":"'Rates Table'!Q41","v":0},{"$f":"'Rates Table'!R41","v":0},{"$f":"'Rates Table'!S41","v":0},{"$f":"'Rates Table'!T41","v":0},{"$f":"'Rates Table'!U41","v":0},{"$f":"'Rates Table'!V41","v":0},{"$f":"'Rates Table'!W41","v":0},{"$f":"'Rates Table'!X41","v":0},{"$f":"'Rates Table'!Y41","v":0},{"$f":"'Rates Table'!Z41","v":0},{"$f":"'Rates Table'!AA41","v":0},{"$f":"'Rates Table'!AB41","v":0},{"$f":"'Rates Table'!AC41","v":0},null,{"$f":"SUMIFS(AF42:BC42,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"F42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U42","v":0},0,0,0,0,{"$f":"Z42","v":0},{"$f":"AA42","v":0},{"$f":"AB42","v":0},{"$f":"AC42","v":0}]
[null,null,"Tariff Type",null,{"$f":"Selected_Tariff_Type","v":"Rural"},{"$f":"INDEX(Full_Tariff_Type,F$7,)","v":"Urban"},"Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Urban","Urban","Urban","Urban","Urban","Urban",null,{"$f":"Selected_Tariff_Type","v":"Rural"},"Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Urban","Urban","Urban","Urban","Urban","Urban"]

{"sheet":"Workings Low","index":6,"n_rows":43,"n_cols":55,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Calculations by Tariff"]
[]
[null,"Tariffs",null,null,{"$f":"Selected_Base_Tariff","v":"Landrate 4"},{"$f":"INDEX(Full_Tariff_List,F$7,)","v":"Businessrate 1"},"Businessrate 2","Businessrate 3","Businessrate 4","Homelight 20A","Homelight 60A","Homepower 1","Homepower 2","Homepower 3","Homepower 4","Homepower Bulk","Landrate 1","Landrate 2","Landrate 3","Landrate 4","Landrate Dx","Landlight 20A","Landlight 60A","Public Lighting All Night","Public Lighting 24 Hours","Homeflex 1","Homeflex 2","Homeflex 3","Homeflex 4",null,{"$f":"E6","v":"Landrate 4"},"Businessrate 1","Businessrate 2","Businessrate 3","Businessrate 4","Homelight 20A","Homelight 60A","Homepower 1","Homepower 2","Homepower 3","Homepower 4","Homepower Bulk","Landrate 1","Landrate 2","Landrate 3","Landrate 4",{"$f":"U6","v":"Landrate Dx"},"Landlight 20A","Landlight 60A","Public Lighting All Night","Public Lighting 24 Hours","Homeflex 1","Homeflex 2","Homeflex 3","Homeflex 4"]
[null,null,null,null,null,1,{"$f":"F7+1","v":2},{"$f":"G7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,{"$f":"Y7+8","v":28},{"$f":"Z7+1","v":29},30,31,null,{"$f":"E7","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,28,29,30,31]
[null,"Network charges",null,"Units",{"$f":"Current_Period&\" Rates\"","v":"2022/2023 Rates"},{"$f":"E8","v":"2022/2023 Rates"},{"$f":"F8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"New_Period&\" Rates\"","v":"2023/2024 Rates"},{"$f":"AE8","v":"2023/2024 Rates"},{"$f":"AF8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Distribution network demand charge","c/kWh",{"$f":"SUMIFS(F10:AC10,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!F10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!G10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!H10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!I10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!J10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!K10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!L10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!M10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!N10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!O10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!P10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!R10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!S10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!T10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!U10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!V10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!W10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!X10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC10*SPU_Annual_Total_Energy,0)/100","v":0},null,{"$f":"SUMIFS(AF10:BC10,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!AF10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB10*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC10*SPU_Annual_Total_Energy,0)/100","v":0}]
[null,null,"Network demand charge, Ancillary service charge and retail","c/kWh",{"$f":"SUMIFS(F11:AC11,$F$7:$AC$7,Selected_Tariff_ID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC11*SPU_Annual_Total_Energy,0)/100","v":0},null,{"$f":"SUMIFS(AF11:BC11,$F$7:$AC$7,Selected_Tariff_ID)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!AZ11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB11*SPU_Annual_Total_Energy,0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC11*SPU_Annual_Total_Energy,0)/100","v":0}]
[null,null,"Network capacity charge",{"$f":"IF(Table_1=1,\"R/kVA\",\"R/day\")","v":"R/day"},{"$f":"SUMIFS(F12:AC12,$F$7:$AC$7,Selected_Tariff_ID)","v":1008.3125},{"$f":"IFERROR('Rates Table'!F12*PODs*ESKOM_Total_days,0)","v":965.72916666666674},{"$f":"IFERROR('Rates Table'!G12*PODs*ESKOM_Total_days,0)","v":1627.2916666666667},{"$f":"IFERROR('Rates Table'!H12*PODs*ESKOM_Total_days,0)","v":2811.4125000000004},{"$f":"IFERROR('Rates Table'!I12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!J12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!K12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!L12*PODs*ESKOM_Total_days,0)","v":239.07500000000002},{"$f":"IFERROR('Rates Table'!M12*PODs*ESKOM_Total_days,0)","v":448.03750000000002},{"$f":"IFERROR('Rates Table'!N12*PODs*ESKOM_Total_days,0)","v":925.27500000000009},{"$f":"IFERROR('Rates Table'!O12*PODs*ESKOM_Total_days,0)","v":146},{"$f":"IFERROR('Rates Table'!P12*PODs*ESKOM_Total_days,0)","v":1517.1833333333334},{"$f":"IFERROR('Rates Table'!Q12*PODs*ESKOM_Total_days,0)","v":1266.2458333333334},{"$f":"IFERROR('Rates Table'!R12*PODs*ESKOM_Total_days,0)","v":1946.3625000000002},{"$f":"IFERROR('Rates Table'!S12*PODs*ESKOM_Total_days,0)","v":3111.625},{"$f":"IFERROR('Rates Table'!T12*PODs*ESKOM_Total_days,0)","v":1008.3125},{"$f":"IFERROR('Rates Table'!U12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!V12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!W12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!X12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Y12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Z12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AA12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AB12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AC12*PODs*ESKOM_Total_days,0)","v":0},null,{"$f":"SUMIFS(AF12:BC12,$F$7:$AC$7,Selected_Tariff_ID)","v":1196.2874999999999},{"$f":"IFERROR('Rates Table'!AF12*PODs*ESKOM_Total_days,0)","v":1145.7958333333333},{"$f":"IFERROR('Rates Table'!AG12*PODs*ESKOM_Total_days,0)","v":1930.85},{"$f":"IFERROR('Rates Table'!AH12*PODs*ESKOM_Total_days,0)","v":3335.7958333333336},{"$f":"IFERROR('Rates Table'!AI12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AJ12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AK12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AL12*PODs*ESKOM_Total_days,0)","v":283.78750000000002},{"$f":"IFERROR('Rates Table'!AM12*PODs*ESKOM_Total_days,0)","v":531.68333333333339},{"$f":"IFERROR('Rates Table'!AN12*PODs*ESKOM_Total_days,0)","v":1097.7375000000002},{"$f":"IFERROR('Rates Table'!AO12*PODs*ESKOM_Total_days,0)","v":173.375},{"$f":"IFERROR('Rates Table'!AP12*PODs*ESKOM_Total_days,0)","v":1800.0583333333334},{"$f":"IFERROR('Rates Table'!AQ12*PODs*ESKOM_Total_days,0)","v":1502.2791666666667},{"$f":"IFERROR('Rates Table'!AR12*PODs*ESKOM_Total_days,0)","v":2309.2333333333336},{"$f":"IFERROR('Rates Table'!AS12*PODs*ESKOM_Total_days,0)","v":3691.9749999999999},{"$f":"IFERROR('Rates Table'!AT12*PODs*ESKOM_Total_days,0)","v":1196.2874999999999},{"$f":"IFERROR('Rates Table'!AU12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AV12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AW12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AX12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AY12*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AZ12*PODs*ESKOM_Total_days,0)","v":283.78750000000002},{"$f":"IFERROR('Rates Table'!BA12*PODs*ESKOM_Total_days,0)","v":531.68333333333339},{"$f":"IFERROR('Rates Table'!BB12*PODs*ESKOM_Total_days,0)","v":1097.7375000000002},{"$f":"IFERROR('Rates Table'!BC12*PODs*ESKOM_Total_days,0)","v":173.375}]
[]
[null,"Total network charges",null,null,{"$f":"SUM(E10:E12)","v":1008.3125},965.72916666666674,1627.2916666666667,2811.4125000000004,0,0,0,239.07500000000002,448.03750000000002,925.27500000000009,146,1517.1833333333334,1266.2458333333334,1946.3625000000002,3111.625,1008.3125,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AE10:AE12)","v":1196.2874999999999},1145.7958333333333,1930.85,3335.7958333333336,0,0,0,283.78750000000002,531.68333333333339,1097.7375000000002,173.375,1800.0583333333334,1502.2791666666667,2309.2333333333336,3691.9749999999999,1196.2874999999999,0,0,0,0,0,283.78750000000002,531.68333333333339,1097.7375000000002,173.375]
[]
[null,"Energy charges",null,"Units",{"$f":"E$8","v":"2022/2023 Rates"},{"$f":"F$8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"AE$8","v":"2023/2024 Rates"},{"$f":"AF$8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Energy","c/kWh",{"$f":"SUMIFS(F18:AC18,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!F18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!G18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!H18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!I18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!J18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!K18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!L18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!M18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!N18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!O18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!P18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!R18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!S18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!T18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!U18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!V18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!W18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!X18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC18*(SPU_Annual_Total_Energy),0)/100","v":0},null,{"$f":"SUMIFS(AF18:BC18,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!AF18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB18*(SPU_Annual_Total_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC18*(SPU_Annual_Total_Energy),0)/100","v":0}]
[null,null,"Peak consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB19*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC19*(Homeflex_Peak_Energy),0)/100","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates SPU - New'!$L$29*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$L$29*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$L$29*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$L$29*(Homeflex_Peak_Energy),0)/100","v":0}]
[null,null,"Standard consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB20*(Homeflex_Standard_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC20*(Homeflex_Standard_Energy),0)/100","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates SPU - New'!$M$30*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$M$30*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$M$30*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$M$30*(Homeflex_Peak_Energy),0)/100","v":0}]
[null,null,"Off-Peak consumption","c/kWh",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates Table'!Z21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB21*(Homeflex_OffPeak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC21*(Homeflex_OffPeak_Energy),0)/100","v":0},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Rates SPU - New'!$N$30*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$N$30*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$N$30*(Homeflex_Peak_Energy),0)/100","v":0},{"$f":"IFERROR('Rates SPU - New'!$N$30*(Homeflex_Peak_Energy),0)/100","v":0}]
[null,null,"Energy - Block 1","c/kWh",0,{"$f":"IFERROR('Rates Table'!F22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!G22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!H22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!I22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!J22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!K22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!L22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!M22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!N22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!O22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!P22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!R22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!S22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!T22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!U22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!V22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!W22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!X22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC22*(SPU_Block_1),0)/100","v":0},null,0,{"$f":"IFERROR('Rates Table'!AF22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB22*(SPU_Block_1),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC22*(SPU_Block_1),0)/100","v":0}]
[null,null,"Energy - Block 2","c/kWh",0,{"$f":"IFERROR('Rates Table'!F23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!G23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!H23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!I23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!J23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!K23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!L23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!M23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!N23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!O23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!P23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Q23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!R23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!S23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!T23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!U23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!V23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!W23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!X23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Y23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!Z23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AA23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AB23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AC23*(SPU_Block_2),0)/100","v":0},null,0,{"$f":"IFERROR('Rates Table'!AF23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AG23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AH23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AI23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AJ23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AK23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AL23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AM23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AN23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AO23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AP23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AQ23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AR23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AS23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AT23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AU23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AV23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AW23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AX23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AY23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!AZ23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BA23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BB23*(SPU_Block_2),0)/100","v":0},{"$f":"IFERROR('Rates Table'!BC23*(SPU_Block_2),0)/100","v":0}]
[]
[null,"Total energy charges",null,null,{"$f":"SUM(E18:E23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AE18:AE23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Other charges",null,"Units",{"$f":"E$8","v":"2022/2023 Rates"},{"$f":"F$8","v":"2022/2023 Rates"},"2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates","2022/2023 Rates",null,{"$f":"AE$8","v":"2023/2024 Rates"},{"$f":"AF$8","v":"2023/2024 Rates"},"2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates","2023/2024 Rates"]
[]
[null,null,"Ancillary service charge ","c/kWh",{"$f":"SUMIFS(F29:AC29,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!F29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!G29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!H29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!I29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!J29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!K29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!L29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!M29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!N29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!O29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!P29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!Q29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!R29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!S29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!T29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!U29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!V29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!W29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!X29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!Y29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!Z29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AA29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AB29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AC29,0)/100","v":0},null,{"$f":"SUMIFS(AF29:BC29,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AF29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AG29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AH29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AI29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AJ29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AK29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AL29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AM29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AN29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AO29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AP29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AQ29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AR29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AS29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AT29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AU29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AV29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AW29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AX29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AY29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!AZ29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!BA29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!BB29,0)/100","v":0},{"$f":"IFERROR(SPU_Annual_Total_Energy*'Rates Table'!BC29,0)/100","v":0}]
[null,null,"Service charge",{"$f":"IF(Table_1=1,\"R/day\",\"R/day\")","v":"R/day"},{"$f":"SUMIFS(F30:AC30,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!F30*PODs*ESKOM_Total_days,0)","v":834.63333333333344},{"$f":"IFERROR('Rates Table'!G30*PODs*ESKOM_Total_days,0)","v":834.63333333333344},{"$f":"IFERROR('Rates Table'!H30*PODs*ESKOM_Total_days,0)","v":834.63333333333344},{"$f":"IFERROR('Rates Table'!I30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!J30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!K30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!L30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!M30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!N30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!O30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!P30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Q30*PODs*ESKOM_Total_days,0)","v":1051.5041666666666},{"$f":"IFERROR('Rates Table'!R30*PODs*ESKOM_Total_days,0)","v":1051.5041666666666},{"$f":"IFERROR('Rates Table'!S30*PODs*ESKOM_Total_days,0)","v":1051.5041666666666},{"$f":"IFERROR('Rates Table'!T30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!U30*PODs*ESKOM_Total_days,0)","v":2255.0916666666667},{"$f":"IFERROR('Rates Table'!V30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!W30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!X30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Y30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!Z30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AA30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AB30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AC30*PODs*ESKOM_Total_days,0)","v":0},null,{"$f":"SUMIFS(AF30:BC30,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"IFERROR('Rates Table'!AF30*PODs*ESKOM_Total_days,0)","v":990.36666666666679},{"$f":"IFERROR('Rates Table'!AG30*PODs*ESKOM_Total_days,0)","v":990.36666666666679},{"$f":"IFERROR('Rates Table'!AH30*PODs*ESKOM_Total_days,0)","v":990.36666666666679},{"$f":"IFERROR('Rates Table'!AI30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AJ30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AK30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AL30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AM30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AN30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AO30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AP30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AQ30*PODs*ESKOM_Total_days,0)","v":1247.6916666666668},{"$f":"IFERROR('Rates Table'!AR30*PODs*ESKOM_Total_days,0)","v":1247.6916666666668},{"$f":"IFERROR('Rates Table'!AS30*PODs*ESKOM_Total_days,0)","v":1247.6916666666668},{"$f":"IFERROR('Rates Table'!AT30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AU30*PODs*ESKOM_Total_days,0)","v":2675.7541666666666},{"$f":"IFERROR('Rates Table'!AV30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AW30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AX30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AY30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!AZ30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!BA30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!BB30*PODs*ESKOM_Total_days,0)","v":0},{"$f":"IFERROR('Rates Table'!BC30*PODs*ESKOM_Total_days,0)","v":0}]
[]
[null,"Total other charges",null,null,{"$f":"SUM(E28:E30)","v":0},834.63333333333344,834.63333333333344,834.63333333333344,0,0,0,0,0,0,0,0,1051.5041666666666,1051.5041666666666,1051.5041666666666,0,2255.0916666666667,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AE28:AE30)","v":0},990.36666666666679,990.36666666666679,990.36666666666679,0,0,0,0,0,0,0,0,1247.6916666666668,1247.6916666666668,1247.6916666666668,0,2675.7541666666666,0,0,0,0,0,0,0,0]
[]
[null,"Total excl VAT",null,null,{"$f":"E32+E25+E14","v":1008.3125},1800.3625000000002,2461.9250000000002,3646.0458333333336,0,0,0,239.07500000000002,448.03750000000002,925.27500000000009,146,1517.1833333333334,2317.75,2997.8666666666668,4163.1291666666666,1008.3125,2255.0916666666667,0,0,0,0,0,0,0,0,null,{"$f":"AE32+AE25+AE14","v":1196.2874999999999},2136.1625000000004,2921.2166666666667,4326.1625000000004,0,0,0,283.78750000000002,531.68333333333339,1097.7375000000002,173.375,1800.0583333333334,2749.9708333333338,3556.9250000000002,4939.666666666667,1196.2874999999999,2675.7541666666666,0,0,0,0,283.78750000000002,531.68333333333339,1097.7375000000002,173.375]
[null,"VAT",null,{"$f":"'Monthly Average Bill'!D49","v":0.15},{"$f":"E34*$D35","v":151.24687499999999},{"$f":"F34*$D35","v":270.05437499999999},369.28874999999999,546.90687500000001,0,0,0,35.861249999999998,67.205624999999998,138.79125000000002,21.9,227.57750000000001,347.66249999999997,449.68,624.46937500000001,151.24687499999999,338.26375000000002,0,0,0,0,0,0,0,0,null,{"$f":"AE34*$D35","v":179.44312499999998},{"$f":"AF34*$D35","v":320.42437500000005},438.1825,648.92437500000005,0,0,0,42.568125000000002,79.752500000000012,164.66062500000001,26.006249999999998,270.00875000000002,412.49562500000008,533.53875000000005,740.95,179.44312499999998,401.36312499999997,0,0,0,0,42.568125000000002,79.752500000000012,164.66062500000001,26.006249999999998]
[]
[null,"Total account",null,null,{"$f":"SUM(E34:E35)","v":1159.559375},{"$f":"SUM(F34:F35)","v":2070.4168750000003},2831.2137500000003,4192.9527083333332,0,0,0,274.93625000000003,515.24312499999996,1064.0662500000001,167.9,1744.7608333333335,2665.4124999999999,3447.5466666666666,4787.5985416666663,1159.559375,2593.3554166666668,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AE34:AE35)","v":1375.7306249999999},{"$f":"SUM(AF34:AF35)","v":2456.5868750000004},3359.3991666666666,4975.0868750000009,0,0,0,326.35562500000003,611.43583333333345,1262.3981250000002,199.38124999999999,2070.0670833333334,3162.4664583333338,4090.4637500000003,5680.6166666666668,1375.7306249999999,3077.1172916666665,0,0,0,0,326.35562500000003,611.43583333333345,1262.3981250000002,199.38124999999999]
[]
[null,"Average price c/kWh",null,null,{"$f":"SUMIFS(F39:AC39,$F$7:$AC$7,Selected_Tariff_ID)","v":{"$error":"#DIV/0!"}},{"$f":"F34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"H34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUMIFS(AF39:BC39,$F$7:$AC$7,Selected_Tariff_ID)","v":{"$error":"#DIV/0!"}},{"$f":"AF34/SPU_Annual_Total_Energy*100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Check tables"]
[null,null,"Table 1: 1 = LPU, 0 = SPU",null,{"$f":"SUMIFS(F42:AC42,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"'Rates Table'!F41","v":0},{"$f":"'Rates Table'!G41","v":0},{"$f":"'Rates Table'!H41","v":0},{"$f":"'Rates Table'!I41","v":0},{"$f":"'Rates Table'!J41","v":0},{"$f":"'Rates Table'!K41","v":0},{"$f":"'Rates Table'!L41","v":0},{"$f":"'Rates Table'!M41","v":0},{"$f":"'Rates Table'!N41","v":0},{"$f":"'Rates Table'!O41","v":0},{"$f":"'Rates Table'!P41","v":0},{"$f":"'Rates Table'!Q41","v":0},{"$f":"'Rates Table'!R41","v":0},{"$f":"'Rates Table'!S41","v":0},{"$f":"'Rates Table'!T41","v":0},{"$f":"'Rates Table'!U41","v":0},{"$f":"'Rates Table'!V41","v":0},{"$f":"'Rates Table'!W41","v":0},{"$f":"'Rates Table'!X41","v":0},{"$f":"'Rates Table'!Y41","v":0},{"$f":"'Rates Table'!Z41","v":0},{"$f":"'Rates Table'!AA41","v":0},{"$f":"'Rates Table'!AB41","v":0},{"$f":"'Rates Table'!AC41","v":0},null,{"$f":"SUMIFS(AF42:BC42,$F$7:$AC$7,Selected_Tariff_ID)","v":0},{"$f":"F42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V42","v":0},0,0,0,0,0,0,0]
[null,null,"Tariff Type",null,{"$f":"Selected_Tariff_Type","v":"Rural"},{"$f":"INDEX(Full_Tariff_Type,F$7,)","v":"Urban"},"Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Urban","Urban","Urban","Urban","Urban","Urban",null,{"$f":"Selected_Tariff_Type","v":"Rural"},"Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Urban","Rural","Rural","Rural","Rural","Rural","Rural","Rural","Urban","Urban","Urban","Urban","Urban","Urban"]

{"sheet":"Rates SPU - New","index":7,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,{"$f":"\"Small Power User | Tariff Inputs | \"&New_Period","v":"Small Power User | Tariff Inputs | 2023/2024"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dx NAC"]
[null,null,"Rates - All Other",null,null,null,null,null,"kWhHP","kWhHS","kWhHO","kWhLP","kWhLS","kWhLO","kWhRBlock1","kWhRBlock4","kWhHP","Reliab","DxNDC Energy","DxNDC Energy","NAC POD","SerS"]
[null,null,"Tariff","Tariff Category","Type","Column1","Code","Matrix Code","High - Peak","High - Standard","High-Off Peak","Low - Peak","Low - Standard","Low-Off Peak","Energy charge Block 1 [c/kWh]","Energy charge Block 2 [c/kWh]","Energy charge [c/kWh]","Ancillary service charge [c/kWh]","Network demand charge [c/kWh]","Network demand charge, Ancillary service charge and retail [c/kWh]","Network capacity charge [R/POD/day]","Service and administration charge [R/POD/day]","Environmental levy charge [c/kWh]",null,null,"check"]
[null,null,"Businessrate 1","Non-Local Authority",null,null,{"$f":"C8&\"_\"&D8","v":"Businessrate 1_Non-Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C8,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E8,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F8,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D8,Matrix_Model_Category,0),2)","v":"B101N"},0,0,0,0,0,0,0,0,185.83,0.71,26.23,null,37.67,32.56,"n/a"]
[null,null,"Businessrate 2","Non-Local Authority",null,null,{"$f":"C9&\"_\"&D9","v":"Businessrate 2_Non-Local Authority"},"B201N",0,0,0,0,0,0,0,0,185.83,0.71,26.23,null,63.48,32.56,"n/a"]
[null,null,"Businessrate 3","Non-Local Authority",null,null,"Businessrate 3_Non-Local Authority","B301N",0,0,0,0,0,0,0,0,185.83,0.71,26.23,null,109.67,32.56,"n/a"]
[null,null,"Businessrate 4","Non-Local Authority",null,null,{"$f":"C11&\"_\"&D11","v":"Businessrate 4_Non-Local Authority"},"B401N",0,0,0,0,0,0,0,0,500.1,0.71,26.23,null,0,0,"n/a"]
[null,null,"Homepower Bulk","Non-Local Authority",null,null,{"$f":"C12&\"_\"&D12","v":"Homepower Bulk_Non-Local Authority"},"HB01N",0,0,0,0,0,0,0,0,285.95999999999998,0,0,null,59.18,0,"n/a"]
[null,null,"Homepower 1","Non-Local Authority",null,null,{"$f":"C13&\"_\"&D13","v":"Homepower 1_Non-Local Authority"},"H101N",0,0,0,0,0,0,217.79,343.91,0,0,0,null,9.33,0,"n/a"]
[null,null,"Homepower 2","Non-Local Authority",null,null,"Homepower 2_Non-Local Authority","H201N",0,0,0,0,0,0,217.79,335.33,0,0,0,null,17.48,0,"n/a"]
[null,null,"Homepower 3","Non-Local Authority",null,null,"Homepower 3_Non-Local Authority","H301N",0,0,0,0,0,0,217.79,335.33,0,0,0,null,36.090000000000003,0,"n/a"]
[null,null,"Homepower 4","Non-Local Authority",null,null,"Homepower 4_Non-Local Authority","H401N",0,0,0,0,0,0,217.79,350.24,0,0,0,null,5.7,0,"n/a"]
[null,null,"Homelight 20A","Non-Local Authority",null,null,"Homelight 20A_Non-Local Authority","HL2001N",0,0,0,0,0,0,168.78,191.25,0,0,0,null,0,0,"n/a"]
[null,null,"Homelight 60A","Non-Local Authority",null,null,"Homelight 60A_Non-Local Authority","HL6001N",0,0,0,0,0,0,206.06,350.24,0,0,0,null,0,0,"n/a"]
[null,null,"Landrate 1","Non-Local Authority",null,null,"Landrate 1_Non-Local Authority","L101N",0,0,0,0,0,0,0,0,184.92,0.71,46.2,null,49.39,41.02,"n/a"]
[null,null,"Landrate 2","Non-Local Authority",null,null,"Landrate 2_Non-Local Authority","L201N",0,0,0,0,0,0,0,0,184.92,0.71,46.2,null,75.92,41.02,"n/a"]
[null,null,"Landrate 3","Non-Local Authority",null,null,"Landrate 3_Non-Local Authority","L301N",0,0,0,0,0,0,0,0,184.92,0.71,46.2,null,121.38,41.02,"n/a"]
[null,null,"Landrate 4","Non-Local Authority",null,null,"Landrate 4_Non-Local Authority","L401N",0,0,0,0,0,0,0,0,399.41,0.71,46.2,null,39.33,0,"n/a"]
[null,null,"Landrate Dx","Non-Local Authority",null,null,"Landrate Dx_Non-Local Authority","Ld01N",0,0,0,0,0,0,0,0,0,0,0,null,0,87.97,"n/a"]
[null,null,"Landlight 20A","Non-Local Authority",null,null,{"$f":"C24&\"_\"&D24","v":"Landlight 20A_Non-Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C24,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E24,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F24,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D24,Matrix_Model_Category,0),2)","v":"Lt2001N"},0,0,0,0,0,0,0,0,531.74,0,0,null,0,0,"n/a"]
[null,null,"Landlight 60A","Non-Local Authority",null,null,{"$f":"C25&\"_\"&D25","v":"Landlight 60A_Non-Local Authority"},"Lt6001N",0,0,0,0,0,0,0,0,685.48,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting All Night","Non-Local Authority",null,null,{"$f":"C26&\"_\"&D26","v":"Public Lighting All Night_Non-Local Authority"},"Pa01N",0,0,0,0,0,0,0,0,147.88999999999999,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting 24 Hours","Non-Local Authority",null,null,"Public Lighting 24 Hours_Non-Local Authority","Pu01N",0,0,0,0,0,0,0,0,198.01,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting Urban Fixed","Non-Local Authority",null,null,"Public Lighting Urban Fixed_Non-Local Authority","Pt01N",0,0,0,0,0,0,0,0,0,0,0,null,0,9.7200000000000006,"n/a"]
[null,null,"Homeflex 1","Non-Local Authority",null,null,{"$f":"C29&\"_\"&D29","v":"Homeflex 1_Non-Local Authority"},"HF101N",542.79,165.14,90.17,177.74,122.64,78.19,0,0,0,0,112.11,112.11,9.33,0,"n/a"]
[null,null,"Homeflex 2","Non-Local Authority",null,null,"Homeflex 2_Non-Local Authority","HF201N",542.79,165.14,90.17,177.74,122.64,78.19,0,0,0,0,112.11,112.11,17.48,0,"n/a"]
[null,null,"Homeflex 3","Non-Local Authority",null,null,"Homeflex 3_Non-Local Authority","HF301N",542.79,165.14,90.17,177.74,122.64,78.19,0,0,0,0,112.11,112.11,36.090000000000003,0,"n/a"]
[null,null,"Homeflex 4","Non-Local Authority",null,null,"Homeflex 4_Non-Local Authority","HF401N",542.79,165.14,90.17,177.74,122.64,78.19,0,0,0,0,112.11,112.11,5.7,0,"n/a"]
[null,null,{"$f":"C8","v":"Businessrate 1"},"Local Authority",null,null,"Businessrate 1_Local Authority","B101Y",0,0,0,0,0,0,0,0,192.58,0.73,26.7,null,38.270000000000003,32.770000000000003,"n/a"]
[null,null,{"$f":"C9","v":"Businessrate 2"},"Local Authority",null,null,{"$f":"C34&\"_\"&D34","v":"Businessrate 2_Local Authority"},"B201Y",0,0,0,0,0,0,0,0,192.58,0.73,26.7,null,64.55,32.770000000000003,"n/a"]
[null,null,{"$f":"C10","v":"Businessrate 3"},"Local Authority",null,null,"Businessrate 3_Local Authority","B301Y",0,0,0,0,0,0,0,0,192.58,0.73,26.7,null,111.54,32.770000000000003,"n/a"]
[null,null,{"$f":"C11","v":"Businessrate 4"},"Local Authority",null,null,{"$f":"C36&\"_\"&D36","v":"Businessrate 4_Local Authority"},"B401Y",0,0,0,0,0,0,0,0,518.25,0.73,26.7,null,0,0,"n/a"]
[null,null,"Homepower Bulk","Local Authority",null,null,{"$f":"C37&\"_\"&D37","v":"Homepower Bulk_Local Authority"},"HB01Y",0,0,0,0,0,0,0,0,0,0,0,null,0,0,"n/a"]
[null,null,{"$f":"C13","v":"Homepower 1"},"Local Authority",null,null,{"$f":"C38&\"_\"&D38","v":"Homepower 1_Local Authority"},"H101Y",0,0,0,0,0,0,220.47,348.11,0,0,0,null,9.43,0,"n/a"]
[null,null,"Homepower 2","Local Authority",null,null,"Homepower 2_Local Authority","H201Y",0,0,0,0,0,0,220.47,339.38,0,0,0,null,17.690000000000001,0,"n/a"]
[null,null,"Homepower 3","Local Authority",null,null,"Homepower 3_Local Authority","H301Y",0,0,0,0,0,0,220.47,339.38,0,0,0,null,36.549999999999997,0,"n/a"]
[null,null,"Homepower 4","Local Authority",null,null,"Homepower 4_Local Authority","H401Y",0,0,0,0,0,0,220.47,354.52,0,0,0,null,5.78,0,"n/a"]
[null,null,"Homelight 20A","Local Authority",null,null,"Homelight 20A_Local Authority","HL2001Y",0,0,0,0,0,0,0,0,0,0,0,null,0,0,"n/a"]
[null,null,"Homelight 60A","Local Authority",null,null,"Homelight 60A_Local Authority","HL6001Y",0,0,0,0,0,0,0,0,0,0,0,null,0,0,"n/a"]
[null,null,"Landrate 1","Local Authority",null,null,"Landrate 1_Local Authority","L101Y",0,0,0,0,0,0,0,0,191.63,0.73,47.24,null,50.45,41.29,"n/a"]
[null,null,"Landrate 2","Local Authority",null,null,"Landrate 2_Local Authority","L201Y",0,0,0,0,0,0,0,0,191.63,0.73,47.24,null,77.540000000000006,41.29,"n/a"]
[null,null,"Landrate 3","Local Authority",null,null,"Landrate 3_Local Authority","L301Y",0,0,0,0,0,0,0,0,191.63,0.73,47.24,null,124,41.29,"n/a"]
[null,null,"Landrate 4","Local Authority",null,null,"Landrate 4_Local Authority","L401Y",0,0,0,0,0,0,0,0,413.9,0.73,47.24,null,40.18,0,"n/a"]
[null,null,"Landrate Dx","Local Authority",null,null,{"$f":"C48&\"_\"&D48","v":"Landrate Dx_Local Authority"},"Ld01Y",0,0,0,0,0,0,0,0,0,0,0,null,0,89.35,"n/a"]
[null,null,"Public Lighting All Night","Local Authority",null,null,{"$f":"C49&\"_\"&D49","v":"Public Lighting All Night_Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C49,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E49,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F49,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D49,Matrix_Model_Category,0),2)","v":"Pa01Y"},0,0,0,0,0,0,0,0,155.46,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting 24 Hours","Local Authority",null,null,{"$f":"C50&\"_\"&D50","v":"Public Lighting 24 Hours_Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C50,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E50,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F50,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D50,Matrix_Model_Category,0),2)","v":"Pu01Y"},0,0,0,0,0,0,0,0,208.16,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting Urban Fixed","Local Authority",null,null,{"$f":"C51&\"_\"&D51","v":"Public Lighting Urban Fixed_Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C51,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E51,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F51,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D51,Matrix_Model_Category,0),2)","v":"Pt01Y"},0,0,0,0,0,0,0,0,0,0,0,null,0,10.220000000000001,"n/a"]

{"sheet":"Rates SPU - Current","index":8,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,{"$f":"\"Small Power User | Tariff Inputs | \"&Current_Period","v":"Small Power User | Tariff Inputs | 2022/2023"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dx NAC"]
[null,null,"Rates - All Other",null,null,null,null,null,"kWhHP","kWhHS","kWhHO","kWhLP","kWhLS","kWhLO","kWhRBlock1","kWhRBlock4","kWhHP","Reliab","DxNDC Energy","DxNDC Energy","NAC POD","SerS"]
[null,null,"Tariff","Tariff Category","Type","Column1","Code","Matrix Code","High - Peak","High - Standard","High-Off Peak","Low - Peak","Low - Standard","Low-Off Peak","Energy charge Block 1 [c/kWh]","Energy charge Block 2 [c/kWh]","Energy charge [c/kWh]","Ancillary service charge [c/kWh]","Network demand charge [c/kWh]","Network demand charge, Ancillary service charge and retail [c/kWh]","Network capacity charge [R/POD/day]","Service and administration charge [R/POD/day]","Environmental levy charge [c/kWh]"]
[null,null,"Businessrate 1","Non-Local Authority",null,null,{"$f":"C8&\"_\"&D8","v":"Businessrate 1_Non-Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C8,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E8,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F8,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D8,Matrix_Model_Category,0),2)","v":"B101N"},0,0,0,0,0,0,0,0,156.62,0.6,22.11,null,31.75,27.44,"n/a"]
[null,null,"Businessrate 2","Non-Local Authority",null,null,{"$f":"C9&\"_\"&D9","v":"Businessrate 2_Non-Local Authority"},"B201N",0,0,0,0,0,0,0,0,156.62,0.6,22.11,null,53.5,27.44,"n/a"]
[null,null,"Businessrate 3","Non-Local Authority",null,null,"Businessrate 3_Non-Local Authority","B301N",0,0,0,0,0,0,0,0,156.62,0.6,22.11,null,92.43,27.44,"n/a"]
[null,null,"Businessrate 4","Non-Local Authority",null,null,{"$f":"C11&\"_\"&D11","v":"Businessrate 4_Non-Local Authority"},"B401N",0,0,0,0,0,0,0,0,421.49,0.6,22.11,null,0,0,"n/a"]
[null,null,"Homepower Bulk","Non-Local Authority",null,null,{"$f":"C12&\"_\"&D12","v":"Homepower Bulk_Non-Local Authority"},"HB01N",0,0,0,0,0,0,0,0,241.01,0,0,null,49.88,0,"n/a"]
[null,null,"Homepower 1","Non-Local Authority",null,null,{"$f":"C13&\"_\"&D13","v":"Homepower 1_Non-Local Authority"},"H101N",0,0,0,0,0,0,183.56,289.85000000000002,0,0,0,null,7.86,0,"n/a"]
[null,null,"Homepower 2","Non-Local Authority",null,null,"Homepower 2_Non-Local Authority","H201N",0,0,0,0,0,0,183.56,282.62,0,0,0,null,14.73,0,"n/a"]
[null,null,"Homepower 3","Non-Local Authority",null,null,"Homepower 3_Non-Local Authority","H301N",0,0,0,0,0,0,183.56,282.62,0,0,0,null,30.42,0,"n/a"]
[null,null,"Homepower 4","Non-Local Authority",null,null,"Homepower 4_Non-Local Authority","H401N",0,0,0,0,0,0,183.56,295.19,0,0,0,null,4.8,0,"n/a"]
[null,null,"Homelight 20A","Non-Local Authority",null,null,"Homelight 20A_Non-Local Authority","HL2001N",0,0,0,0,0,0,153.44,173.86,0,0,0,null,0,0,"n/a"]
[null,null,"Homelight 60A","Non-Local Authority",null,null,"Homelight 60A_Non-Local Authority","HL6001N",0,0,0,0,0,0,173.67,295.19,0,0,0,null,0,0,"n/a"]
[null,null,"Landrate 1","Non-Local Authority",null,null,"Landrate 1_Non-Local Authority","L101N",0,0,0,0,0,0,0,0,155.85,0.6,38.94,null,41.63,34.57,"n/a"]
[null,null,"Landrate 2","Non-Local Authority",null,null,"Landrate 2_Non-Local Authority","L201N",0,0,0,0,0,0,0,0,155.85,0.6,38.94,null,63.99,34.57,"n/a"]
[null,null,"Landrate 3","Non-Local Authority",null,null,"Landrate 3_Non-Local Authority","L301N",0,0,0,0,0,0,0,0,155.85,0.6,38.94,null,102.3,34.57,"n/a"]
[null,null,"Landrate 4","Non-Local Authority",null,null,"Landrate 4_Non-Local Authority","L401N",0,0,0,0,0,0,0,0,336.63,0.6,38.94,null,33.15,0,"n/a"]
[null,null,"Landrate Dx","Non-Local Authority",null,null,"Landrate Dx_Non-Local Authority","Ld01N",0,0,0,0,0,0,0,0,0,0,0,null,0,74.14,"n/a"]
[null,null,"Landlight 20A","Non-Local Authority",null,null,{"$f":"C24&\"_\"&D24","v":"Landlight 20A_Non-Local Authority"},"Lt2001N",0,0,0,0,0,0,0,0,448.16,0,0,null,0,0,"n/a"]
[null,null,"Landlight 60A","Non-Local Authority",null,null,{"$f":"C25&\"_\"&D25","v":"Landlight 60A_Non-Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C25,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E25,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F25,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D25,Matrix_Model_Category,0),2)","v":"Lt6001N"},0,0,0,0,0,0,0,0,577.73,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting All Night","Non-Local Authority",null,null,{"$f":"C26&\"_\"&D26","v":"Public Lighting All Night_Non-Local Authority"},"Pa01N",0,0,0,0,0,0,0,0,124.64,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting 24 Hours","Non-Local Authority",null,null,"Public Lighting 24 Hours_Non-Local Authority","Pu01N",0,0,0,0,0,0,0,0,166.89,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting Urban Fixed","Non-Local Authority",null,null,"Public Lighting Urban Fixed_Non-Local Authority","Pt01N",0,0,0,0,0,0,0,0,0,0,0,null,0,8.1999999999999993,"n/a"]
[null,null,"Homeflex 1","Non-Local Authority",null,null,{"$f":"C29&\"_\"&D29","v":"Homeflex 1_Non-Local Authority"},"HF101N",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Homeflex 2","Non-Local Authority",null,null,"Homeflex 2_Non-Local Authority","HF201N",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Homeflex 3","Non-Local Authority",null,null,"Homeflex 3_Non-Local Authority","HF301N",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Homeflex 4","Non-Local Authority",null,null,"Homeflex 4_Non-Local Authority","HF401N",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C8","v":"Businessrate 1"},"Local Authority",null,null,"Businessrate 1_Local Authority","B101Y",0,0,0,0,0,0,0,0,162.53,0.62,22.53,null,32.299999999999997,27.66,"n/a"]
[null,null,"Businessrate 2","Local Authority",null,null,{"$f":"C34&\"_\"&D34","v":"Businessrate 2_Local Authority"},"B201Y",0,0,0,0,0,0,0,0,162.53,0.62,22.53,null,54.48,27.66,"n/a"]
[null,null,"Businessrate 3","Local Authority",null,null,"Businessrate 3_Local Authority","B301Y",0,0,0,0,0,0,0,0,162.53,0.62,22.53,null,94.14,27.66,"n/a"]
[null,null,"Businessrate 4","Local Authority",null,null,{"$f":"C36&\"_\"&D36","v":"Businessrate 4_Local Authority"},"B401Y",0,0,0,0,0,0,0,0,437.39,0.62,22.53,null,0,0,"n/a"]
[null,null,"Homepower Bulk","Local Authority",null,null,{"$f":"C37&\"_\"&D37","v":"Homepower Bulk_Local Authority"},"HB01Y",0,0,0,0,0,0,0,0,0,0,0,null,0,0,"n/a"]
[null,null,"Homepower 1","Local Authority",null,null,{"$f":"C38&\"_\"&D38","v":"Homepower 1_Local Authority"},"H101Y",0,0,0,0,0,0,186.07,293.79000000000002,0,0,0,null,7.96,0,"n/a"]
[null,null,"Homepower 2","Local Authority",null,null,"Homepower 2_Local Authority","H201Y",0,0,0,0,0,0,186.07,286.43,0,0,0,null,14.93,0,"n/a"]
[null,null,"Homepower 3","Local Authority",null,null,"Homepower 3_Local Authority","H301Y",0,0,0,0,0,0,186.07,286.43,0,0,0,null,30.85,0,"n/a"]
[null,null,"Homepower 4","Local Authority",null,null,"Homepower 4_Local Authority","H401Y",0,0,0,0,0,0,186.07,299.2,0,0,0,null,4.88,0,"n/a"]
[null,null,"Homelight 20A","Local Authority",null,null,"Homelight 20A_Local Authority","HL2001Y",0,0,0,0,0,0,0,0,0,0,0,null,0,0,"n/a"]
[null,null,"Homelight 60A","Local Authority",null,null,"Homelight 60A_Local Authority","HL6001Y",0,0,0,0,0,0,0,0,0,0,0,null,0,0,"n/a"]
[null,null,"Landrate 1","Local Authority",null,null,"Landrate 1_Local Authority","L101Y",0,0,0,0,0,0,0,0,161.72999999999999,0.62,39.869999999999997,null,42.58,34.85,"n/a"]
[null,null,"Landrate 2","Local Authority",null,null,"Landrate 2_Local Authority","L201Y",0,0,0,0,0,0,0,0,161.72999999999999,0.62,39.869999999999997,null,65.44,34.85,"n/a"]
[null,null,"Landrate 3","Local Authority",null,null,"Landrate 3_Local Authority","L301Y",0,0,0,0,0,0,0,0,161.72999999999999,0.62,39.869999999999997,null,104.65,34.85,"n/a"]
[null,null,"Landrate 4","Local Authority",null,null,"Landrate 4_Local Authority","L401Y",0,0,0,0,0,0,0,0,349.32,0.62,39.869999999999997,null,33.909999999999997,0,"n/a"]
[null,null,"Landrate Dx","Local Authority",null,null,{"$f":"C48&\"_\"&D48","v":"Landrate Dx_Local Authority"},"Ld01Y",0,0,0,0,0,0,0,0,0,0,0,null,0,75.41,"n/a"]
[null,null,"Public Lighting All Night","Local Authority",null,null,{"$f":"C49&\"_\"&D49","v":"Public Lighting All Night_Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C49,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E49,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F49,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D49,Matrix_Model_Category,0),2)","v":"Pa01Y"},0,0,0,0,0,0,0,0,131.19999999999999,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting 24 Hours","Local Authority",null,null,{"$f":"C50&\"_\"&D50","v":"Public Lighting 24 Hours_Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C50,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E50,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F50,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D50,Matrix_Model_Category,0),2)","v":"Pu01Y"},0,0,0,0,0,0,0,0,175.68,0,0,null,0,0,"n/a"]
[null,null,"Public Lighting Urban Fixed","Local Authority",null,null,{"$f":"C51&\"_\"&D51","v":"Public Lighting Urban Fixed_Local Authority"},{"$f":"INDEX(Matrix_Tariff_Map,MATCH(C51,Matrix_Model_Tariffs,0),2)&IFERROR(INDEX(Matrix_Transmission_Map,MATCH(E51,Matrix_Model_Transmission,0),2),0)&IFERROR(INDEX(Matrix_Voltage_Map,MATCH(F51,Matrix_Model_Voltage,0),2),1)&INDEX(Matrix_Category_Map,MATCH(D51,Matrix_Model_Category,0),2)","v":"Pt01Y"},0,0,0,0,0,0,0,0,0,0,0,null,0,8.6300000000000008,"n/a"]

{"sheet":"Mapping","index":9,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Mapping"]
[]
[]
[null,"Model Tariffs","Matrix Code",null,"Model Transmission Zone","Matrix Code"]
[null,{"$f":"Lists!B17","v":"Businessrate 1"},"B1",null,"Not Applicable",0]
[null,{"$f":"Lists!B18","v":"Businessrate 2"},"B2",null,{"$f":"Lists!C88","v":"[0 - 300km]"},0]
[null,{"$f":"Lists!B19","v":"Businessrate 3"},"B3",null,{"$f":"Lists!C89","v":"[301 - 600km]"},1]
[null,{"$f":"Lists!B20","v":"Businessrate 4"},"B4",null,{"$f":"Lists!C90","v":"[601 - 900km]"},2]
[null,{"$f":"Lists!B21","v":"Homelight 20A"},"HL20",null,{"$f":"Lists!C91","v":"[> 900km]"},3]
[null,{"$f":"Lists!B22","v":"Homelight 60A"},"HL60"]
[null,{"$f":"Lists!B23","v":"Homepower 1"},"H1"]
[null,{"$f":"Lists!B24","v":"Homepower 2"},"H2",null,"Model Voltage","Matrix Code"]
[null,{"$f":"Lists!B25","v":"Homepower 3"},"H3",null,{"$f":"Lists!C71","v":"< 500V"},1]
[null,{"$f":"Lists!B26","v":"Homepower 4"},"H4",null,{"$f":"Lists!C72","v":"≥ 500V & < 66kV"},2]
[null,{"$f":"Lists!B27","v":"Homepower Bulk"},"HB",null,{"$f":"Lists!C73","v":"≥ 66kV & ≤ 132kV"},3]
[null,{"$f":"Lists!B28","v":"Landrate 1"},"L1",null,{"$f":"Lists!C74","v":"> 132kV"},4]
[null,{"$f":"Lists!B29","v":"Landrate 2"},"L2"]
[null,{"$f":"Lists!B30","v":"Landrate 3"},"L3",null,"Model Category","Matrix Code"]
[null,{"$f":"Lists!B31","v":"Landrate 4"},"L4",null,{"$f":"Lists!K32","v":"Non-Local Authority"},"N"]
[null,{"$f":"Lists!B32","v":"Landrate Dx"},"Ld",null,{"$f":"Lists!K33","v":"Local Authority"},"Y"]
[null,"Landlight 20A","Lt20"]
[null,"Landlight 60A","Lt60"]
[null,"Public Lighting All Night","Pa"]
[null,"Public Lighting 24 Hours","Pu"]
[null,"Public Lighting Urban Fixed","Pt"]
[null,{"$f":"Lists!B38","v":"Megaflex"},"Me"]
[null,{"$f":"Lists!B39","v":"Miniflex"},"Mi"]
[null,{"$f":"Lists!B40","v":"Nightsave Large"},"NL"]
[null,{"$f":"Lists!B41","v":"Nightsave Rural"},"NR"]
[null,{"$f":"Lists!B42","v":"Nightsave Small"},"NS"]
[null,{"$f":"Lists!B43","v":"Ruraflex"},"Ru"]
[null,"Homeflex 1","HF1"]
[null,"Homeflex 2","HF2"]
[null,"Homeflex 3","HF3"]
[null,"Homeflex 4","HF4"]

{"sheet":"Lists","index":10,"n_rows":109,"n_cols":15,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Model Lists"]
[]
[null,"Selections","Dropbox ID","Description","ID",null,null,null,null,"Description","Dates","Units",null,"Customer Category","Tariff Category ID"]
[null,"Selected Tariff Category",1,{"$f":"INDEX(Tariff_Category_List,Dropdown_Category)","v":"Non-Local Authority"},{"$f":"MATCH(D7,Tariff_Category_List,0)","v":1},{"$f":"Selected_Tariff_Category_ID","v":1},null,null,null,"ESKOM Financial Year End","2024-03-31","dd-mmm-yy",null,"Small Power User",1]
[null,"Selected Customer Category",1,{"$f":"INDEX(Customer_Category_List,Dropdown_Customer)","v":"Small Power User"},{"$f":"MATCH(D8,Customer_Category_List,0)","v":1},null,null,null,null,"Municipality Financial Year End",{"$f":"EOMONTH(ESKOM_Period,3)","v":"2024-06-30"},"dd-mmm-yy",null,"Large Power User",2]
[null,"Selected Supply Size",1,{"$f":"INDEX(Capacity_List,Dropdown_Supply)","v":"5kVA, 16kVA, 20A or 60A"},{"$f":"MATCH(D9,Capacity_List,0)","v":1},null,null,null,null,"Current Period",{"$f":"YEAR(Period)-2&\"/\"&YEAR(Period)-1","v":"2022/2023"}]
[null,"Selected Base Tariff",8,{"$f":"INDEX(Supply_Tariff_List,MIN(Dropdown_Tariff,Supply_Tariff_List_Count),0)","v":"Landrate 4"},{"$f":"MATCH(D10,Full_Tariff_List,0)","v":15},null,null,null,null,"New Period",{"$f":"YEAR(Period)-1&\"/\"&YEAR(Period)","v":"2023/2024"},null,null,"SPU Capacity","Capacity ID"]
[null,"Selected Tariff Type",null,{"$f":"'Monthly Average Bill'!D15","v":"Rural"},{"$f":"IF(Selected_Tariff_Type=\"Rural\",2,1)","v":2},null,null,null,null,"Total Days",30.416666666666668,null,null,"5kVA, 16kVA, 20A or 60A",1]
[null,"Selected Supply Voltage",1,{"$f":"INDEX(Voltage_List,MIN(Dropdown_Voltage,Voltage_List_Count))","v":"< 500V"},{"$f":"MATCH(D12,Voltage_List,0)","v":1},null,null,null,null,null,null,null,null,"25kVA",2]
[null,"Selected transmission zone",1,{"$f":"INDEX(Transmission_List,MIN(Dropdown_Zone,Transmission_List_Count))","v":"Not Applicable"},{"$f":"MATCH(D13,Transmission_List,0)","v":1},null,null,null,null,"VAT",0.15,null,null,"32kVA",3]
[null,"Time of Use Toggle",null,null,{"$f":"IF(Selected_Customer_Category_ID=1,0,1)","v":0},null,null,null,null,null,null,null,null,"50kVA",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,">50kVA",5]
[null,"Tariffs","Base Tariff","Tariff Variant","Type","Base Tariff ID","Tariff ID",null,"Base Tariffs","Type","Long Type","Base Tariff ID"]
[null,{"$f":"IF(D17=\"\",C17,C17&\" \"&D17)","v":"Businessrate 1"},"Businessrate",1,{"$f":"INDEX(Base_Tariff_Type,F17)","v":"Urban"},{"$f":"MATCH(C17,Base_Tariff_List,0)","v":1},1,null,"Businessrate","Urban","Commercial Urban",1]
[null,{"$f":"IF(D18=\"\",C18,C18&\" \"&D18)","v":"Businessrate 2"},"Businessrate",2,"Urban",1,2,null,"Homelight","Urban","Residential Urban",2]
[null,"Businessrate 3","Businessrate",3,"Urban",1,3,null,"Homepower","Urban","Residential Urban",3]
[null,"Businessrate 4","Businessrate",4,"Urban",1,4,null,"Landrate","Rural","Rural",4,null,"LPU Capacity","Capacity ID"]
[null,"Homelight 20A","Homelight","20A","Urban",2,5,null,"Megaflex","Urban","Commercial Urban",5,null,"≤100kVA",1]
[null,"Homelight 60A","Homelight","60A","Urban",2,6,null,"Miniflex","Urban","Commercial Urban",6,null,">100kVA & ≤500kVA",2]
[null,"Homepower 1","Homepower",1,"Urban",3,7,null,"Nightsave Large","Urban","Commercial Urban",7,null,">500kVA & ≤1MVA",3]
[null,"Homepower 2","Homepower",2,"Urban",3,8,null,"Nightsave Rural","Rural","Rural",8,null,">1MVA & ≤5MVA",4]
[null,"Homepower 3","Homepower",3,"Urban",3,9,null,"Nightsave Small","Urban","Commercial Urban",9,null,">5MVA",5]
[null,"Homepower 4","Homepower",4,"Urban",3,10,null,"Ruraflex","Rural","Rural",10,null,"Key customer",6]
[null,"Homepower Bulk","Homepower","Bulk","Urban",3,11,null,"Public Lighting","Urban","Commercial Urban",11]
[null,"Landrate 1","Landrate",1,"Rural",4,12,null,"Homeflex","Urban","Residential Urban",12,null,"Capacity","Capacity ID"]
[null,"Landrate 2","Landrate",2,"Rural",4,13,null,null,null,null,null,null,{"$f":"IFERROR(IF(Selected_Customer_Category_ID=1,INDEX(Capacity_SPU_List,O29,0),INDEX(Capacity_LPU_List,O29,0)),\"\")","v":"5kVA, 16kVA, 20A or 60A"},1]
[null,"Landrate 3","Landrate",3,"Rural",4,14,null,null,null,null,null,null,"25kVA",2]
[null,"Landrate 4","Landrate",4,"Rural",4,15,null,null,null,"Tariff Category","Tariff Category ID",null,"32kVA",3]
[null,"Landrate Dx","Landrate","Dx","Rural",4,16,null,null,null,"Non-Local Authority",1,null,"50kVA",4]
[null,"Landlight 20A","Landrate","Dx",{"$f":"INDEX(Base_Tariff_Type,F33)","v":"Rural"},{"$f":"MATCH(C33,Base_Tariff_List,0)","v":4},17,null,null,null,"Local Authority",2,null,">50kVA",5]
[null,"Landlight 60A","Landrate","Dx","Rural",4,18,null,null,null,null,null,null,"",6]
[null,"Public Lighting All Night","Public Lighting","All Night",{"$f":"INDEX(Base_Tariff_Type,F35)","v":"Urban"},11,19]
[null,"Public Lighting 24 Hours","Public Lighting","24 Hours",{"$f":"INDEX(Base_Tariff_Type,F36)","v":"Urban"},11,20,null,null,null,"Tariffs","Block 1 kWh",null,"Capacity List Count",{"$f":"IF(Selected_Customer_Category_ID=1,COUNTA(Capacity_SPU_List),COUNTA(Capacity_LPU_List))","v":5}]
[null,"Public Lighting Urban Fixed","Public Lighting","Urban Fixed",{"$f":"INDEX(Base_Tariff_Type,F37)","v":"Urban"},11,21,null,null,null,"Homelight 20A",350]
[null,{"$f":"IF(D38=\"\",C38,C38&\" \"&D38)","v":"Megaflex"},"Megaflex",null,{"$f":"INDEX(Base_Tariff_Type,F38)","v":"Urban"},{"$f":"MATCH(C38,Base_Tariff_List,0)","v":5},22,null,null,null,"Homelight 60A",600]
[null,"Miniflex","Miniflex",null,"Urban",6,23,null,null,null,"Homepower",600]
[null,"Nightsave Large","Nightsave Large",null,"Urban",7,24]
[null,"Nightsave Rural","Nightsave Rural",null,"Rural",8,25]
[null,"Nightsave Small","Nightsave Small",null,"Urban",9,26]
[null,"Ruraflex","Ruraflex",null,"Rural",10,27]
[null,"Homeflex 1","Homeflex",null,"Urban",{"$f":"MATCH(C44,Base_Tariff_List,0)","v":12},28]
[null,"Homeflex 2","Homeflex",null,"Urban",{"$f":"MATCH(C45,Base_Tariff_List,0)","v":12},29]
[null,"Homeflex 3","Homeflex",null,"Urban",12,30]
[null,"Homeflex 4","Homeflex",null,"Urban",12,31]
[]
[]
[null,"Selection Tables","LPU Selections",null,null,null,null,null,null,"SPU Selections"]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,INDEX(J51:O51,0,Selected_Supply_Size_ID),INDEX(C51:H51,Selected_Supply_Size_ID))","v":"5kVA, 16kVA, 20A or 60A"},{"$f":"$N21","v":"≤100kVA"},{"$f":"$N22","v":">100kVA & ≤500kVA"},{"$f":"$N23","v":">500kVA & ≤1MVA"},{"$f":"$N24","v":">1MVA & ≤5MVA"},{"$f":"$N25","v":">5MVA"},{"$f":"$N26","v":"Key customer"},null,{"$f":"$N11","v":"5kVA, 16kVA, 20A or 60A"},{"$f":"$N12","v":"25kVA"},{"$f":"$N13","v":"32kVA"},{"$f":"$N14","v":"50kVA"},{"$f":"$N15","v":">50kVA"}]
[null,{"$f":"INDEX(J52:N52,0,Selected_Supply_Size_ID)","v":"Businessrate 1"},"Ruraflex","Ruraflex","Ruraflex","Ruraflex","Ruraflex",{"$f":"F52","v":"Ruraflex"},null,"Businessrate 1","Businessrate 1","Businessrate 1","Businessrate 2","Businessrate 2"]
[null,"Businessrate 4","Miniflex","Miniflex","Miniflex","Miniflex","Nightsave Large","Nightsave Large",null,"Businessrate 4","Businessrate 4","Businessrate 4","Homepower 2","Businessrate 3"]
[null,"Homepower 4","Nightsave Small","Nightsave Small","Nightsave Small","Nightsave Large","Megaflex","Megaflex",null,"Homepower 4","Homepower 1","Homepower 1","Landrate 2","Homepower 2"]
[null,"Homelight 20A","Nightsave Rural","Nightsave Rural","Nightsave Rural","Megaflex","Nightsave Rural","Nightsave Rural",null,"Homelight 20A","Landrate 1","Landrate 1","Homepower Bulk","Homepower 3"]
[null,"Homelight 60A","Homepower Bulk","Homepower Bulk","Homepower Bulk","Nightsave Rural",null,null,null,"Homelight 60A","Homeflex 1","Homeflex 1","Homeflex 2","Landrate 2"]
[null,"Homeflex 4",null,null,null,null,null,null,null,"Homeflex 4",null,null,null,"Landrate 3"]
[null,"Landrate 1",null,null,null,null,null,null,null,"Landrate 1",null,null,null,"Homepower Bulk"]
[null,"Landrate 4",null,null,null,null,null,null,null,"Landrate 4",null,null,null,"Homeflex 2"]
[null,"Landrate Dx",null,null,null,null,null,null,null,"Landrate Dx",null,null,null,"Homeflex 3"]
[null,"Landlight 20A",null,null,null,null,null,null,null,"Landlight 20A"]
[null,"Landlight 60A",null,null,null,null,null,null,null,"Landlight 60A"]
[null,"Public Lighting All Night",null,null,null,null,null,null,null,"Public Lighting All Night"]
[null,"Public Lighting 24 Hours",null,null,null,null,null,null,null,"Public Lighting 24 Hours"]
[null,"Public Lighting Urban Fixed",null,null,null,null,null,null,null,"Public Lighting Urban Fixed"]
[]
[null,{"$f":"INDEX(J67:N67,0,Selected_Supply_Size_ID)","v":13},{"$f":"COUNTA(C52:C64)","v":5},5,5,5,4,4,null,{"$f":"COUNTA(J52:J64)","v":13},{"$f":"COUNTA(K52:K64)","v":5},{"$f":"COUNTA(L52:L64)","v":5},{"$f":"COUNTA(M52:M64)","v":5},{"$f":"COUNTA(N52:N64)","v":9}]
[]
[]
[null,"LPU Voltage","Urban","Rural",null,null,null,null,null,"Compare Tables","SPU","ID","Base Tariff ID","Long Type"]
[null,{"$f":"INDEX($C71:$D71,Selected_Tariff_Type_ID)","v":"< 500V"},"< 500V","< 500V",null,null,null,null,null,{"$f":"(IF(Selected_Customer_Category_ID=1,K71,B52))","v":"Businessrate 1"},{"$f":"B52","v":"Businessrate 1"},1,{"$f":"IFERROR(INDEX($F$17:$F$47,MATCH(J71,Full_Tariff_List,0),0),0)","v":1},{"$f":"IFERROR(INDEX($K$17:$K$28,MATCH(M71,$L$17:$L$28,0),0),0)","v":"Commercial Urban"}]
[null,{"$f":"INDEX($C72:$D72,Selected_Tariff_Type_ID)","v":"≥ 500V & < 66kV"},"≥ 500V & < 66kV","≥ 500V & < 66kV",null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K72,B53)","v":"Businessrate 4"},{"$f":"B53","v":"Businessrate 4"},2,{"$f":"IFERROR(INDEX($F$17:$F$47,MATCH(J72,Full_Tariff_List,0),0),0)","v":1},{"$f":"IFERROR(INDEX($K$17:$K$28,MATCH(M72,$L$17:$L$28,0),0),0)","v":"Commercial Urban"}]
[null,{"$f":"INDEX($C73:$D73,Selected_Tariff_Type_ID)","v":0},"≥ 66kV & ≤ 132kV",null,null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K73,B54)","v":"Homepower 4"},{"$f":"B54","v":"Homepower 4"},3,3,"Residential Urban"]
[null,{"$f":"INDEX($C74:$D74,Selected_Tariff_Type_ID)","v":0},"> 132kV",null,null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K74,B55)","v":"Homelight 20A"},{"$f":"B55","v":"Homelight 20A"},4,2,"Residential Urban"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K75,B56)","v":"Homelight 60A"},{"$f":"B56","v":"Homelight 60A"},5,2,"Residential Urban"]
[null,{"$f":"INDEX($C76:$D76,Selected_Tariff_Type_ID)","v":2},{"$f":"COUNTA(C71:C74)","v":4},{"$f":"COUNTA(D71:D74)","v":2},null,null,null,null,null,{"$f":"IFERROR((IF(Selected_Customer_Category_ID=1,K76,B58)),\"\")","v":"Landrate 1"},{"$f":"B58","v":"Landrate 1"},6,4,"Rural"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K77,B59)","v":"Landrate 4"},"Landrate 4",7,4,"Rural"]
[null,"Voltage","LPU","SPU","Voltage ID",null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K78,B61)","v":"Landrate Dx"},"Landrate Dx",8,4,"Rural"]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D79,C79)","v":"< 500V"},{"$f":"B71","v":"< 500V"},"< 500V",1,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K79,B62)","v":"Landlight 20A"},"Landlight 20A",9,4,"Rural"]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D80,C80)","v":"≥ 500V & < 66kV"},{"$f":"B72","v":"≥ 500V & < 66kV"},"≥ 500V & < 66kV",2,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K80,B63)","v":"Landlight 60A"},"Landlight 60A",10,4,"Rural"]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D81,C81)","v":0},0,null,3,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K81,B64)","v":"Public Lighting All Night"},"Public Lighting All Night",11,11,"Commercial Urban"]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D82,C82)","v":0},0,null,4,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K82,B65)","v":"Public Lighting 24 Hours"},"Public Lighting 24 Hours",12,11,"Commercial Urban"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K83,B57)","v":"Homeflex 4"},{"$f":"B57","v":"Homeflex 4"},13,12,"Residential Urban"]
[]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D85,C85)","v":2},{"$f":"B76","v":2},{"$f":"COUNTA(D79:D82)","v":2},null,null,null,null,null,{"$f":"IF(Selected_Customer_Category_ID=1,K85,B67)","v":13},{"$f":"Supply_Tariff_List_Count","v":13}]
[]
[null,"Transmission zone","LPU","SPU","Transmission Zone ID",null,null,null,null,"Selected Tariff in Compare",{"$f":"MATCH(Selected_Base_Tariff,Compare_Tariff_List,0)","v":7}]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D88,C88)","v":"Not Applicable"},"[0 - 300km]","Not Applicable",0]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D89,C89)","v":0},"[301 - 600km]",null,1]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D90,C90)","v":0},"[601 - 900km]",null,2]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D91,C91)","v":0},"[> 900km]",null,3]
[]
[null,{"$f":"IF(Selected_Customer_Category_ID=1,D93,C93)","v":1},{"$f":"COUNTA(C88:C91)","v":4},{"$f":"COUNTA(D88:D91)","v":1},null,null,null,null,null,"Compare_Tariff_List"]
[]
[]
[null,"Months","Month ID","Season"]
[]
[null,{"$f":"DATE(YEAR(Period)-1,2,)","v":"2023-01-31"},1,"Low Demand"]
[null,{"$f":"EOMONTH(B98,1)","v":"2023-02-28"},2,"Low Demand"]
[null,{"$f":"EOMONTH(B99,1)","v":"2023-03-31"},3,"High Demand"]
[null,"2023-04-30",4,"Low Demand"]
[null,"2023-05-31",5,"Low Demand"]
[null,"2023-06-30",6,"High Demand"]
[null,"2023-07-31",7,"High Demand"]
[null,"2023-08-31",8,"High Demand"]
[null,"2023-09-30",9,"Low Demand"]
[null,"2023-10-31",10,"Low Demand"]
[null,"2023-11-30",11,"Low Demand"]
[null,"2023-12-31",12,"Low Demand"]

{"sheet":"Notes on updates","index":11,"n_rows":86,"n_cols":6,"rows_kept":86,"cut":false,"hidden":true,"merged":[[74,1,86,1],[67,1,73,1],[59,1,65,1],[51,1,57,1],[2,1,16,1],[18,1,26,1],[28,1,33,1],[35,1,41,1],[43,1,49,1]]}
[]
[null,null,"Notes on updates",null,"Sheet","Status"]
[null,"2015/16","]","Need to add SPU tariffs"]
[null,null,null,"Public Lighting All Night",null,"Done"]
[null,null,null,"Public Lighting 24 Hours"]
[null,null,null,"Public Lighting Urban Fixed"]
[null,null,null,"Landlight"]
[]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2015/16 rates",null,"2014-12-05"]
[null,null,null,"Update the Current with 2014/15 rates",null,"2014-12-05"]
[]
[null,null,"]","SPU"]
[null,null,null,"Activate the Tx zone. This is needed for LPU tariff conversions",null,"2014-12-05"]
[]
[null,null,"]","Tariff component name changes"]
[null,null,null,"Change the Distribution network access charge NAC) to Distribution network capacity charge (NCC)",null,"2015-10-14"]
[]
[null,"2016/17","]","Need to add SPU tariffs"]
[null,null,null,"Landlight 20A","Mapping\nLists","2016-02-22"]
[null,null,null,"Landlight 60A","Mapping\nLists","2016-02-22"]
[]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2016/17 rates","Rates SPU - New","2016-03-02"]
[null,null,null,"Update the Current with 2015/16 rates","Rates SPU - Current","2016-03-02"]
[null,null,null,"Tested & validated by RPM's & super-users",null,"2016-02-15"]
[null,null,null,"Tested & validated by PI team",null,"2016-02-16"]
[]
[null,"2017/18"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2017/18 rates","Rates SPU - New","2017-03-10"]
[null,null,null,"Update the Current with 2016/17 rates","Rates SPU - Current","2017-03-10"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[]
[null,"2018/19"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2018/19 rates","Rates SPU - New","2018-02-22"]
[null,null,null,"Update the Current with 2017/18 rates","Rates SPU - Current","2018-02-22"]
[null,null,null,"Update VAT rate to 15%","Rates SPU - Current","2018-02-22"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[]
[null,"2019/20"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2019/20 rates","Rates SPU - New","2019-03-11"]
[null,null,null,"Update the Current with 2018/19 rates","Rates SPU - Current","2019-03-11"]
[null,null,null,"Update Eskom financial year  [Range K7]","Lists","2019-03-11"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[]
[null,"2020/21"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2020/21 rates","Rates SPU - New","2020-03-10"]
[null,null,null,"Update the Current with 2019/20 rates","Rates SPU - Current","2020-03-10"]
[null,null,null,"Update Eskom financial year  [Range K7]","Lists","2020-03-10"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[]
[null,"2021/22"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2021/22 rates","Rates SPU - New","2021-03-09"]
[null,null,null,"Update the Current with 2020/21 rates","Rates SPU - Current","2021-03-09"]
[null,null,null,"Update Eskom financial year  [Range K7]","Lists","2021-03-09"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[]
[null,"2022/23","V6.11"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2022/23 rates","Rates SPU - New","2023-03-13"]
[null,null,null,"Update the Current with 2021/22 rates","Rates SPU - Current","2023-03-13"]
[null,null,null,"Update Eskom financial year  [Range K7]","Lists","2023-03-13"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[null,"2023/24","V6.12"]
[null,null,"]","Rates"]
[null,null,null,"Update the New with 2022/23 rates","Rates SPU - New","2023-03-13"]
[null,null,null,"Update the Current with 2021/22 rates","Rates SPU - Current","2023-03-13"]
[null,null,null,"Update Eskom financial year  [Range K7]","Lists","2023-03-13"]
[null,null,null,"Tested & validated by RPM's & super-users"]
[null,null,null,"Tested & validated by PI team"]
[null,null,null,"Add Homeflex tariff","Rates SPU - New","2023-03-13"]
[null,null,null,null,"Workings","2023-03-13"]
[null,null,null,null,"Rates Table","2023-03-13"]
[null,null,null,null,"  Monthly Average Bill","2023-03-13"]
[null,null,null,null,"  Tariff Comparison","2023-03-13"]