{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Menu","Summary Instructions","Data Capture Demand","Data Capture Users","Data Capture Costs","Primary Baseline Tariff","Adj Primary Baseline Tariff","Strategic Decisions","Revised Primary Baseline Tariff","Test Afford of Variable Tariff","Test Afford of Fixed Tariff","Summary of Tariff Comparison"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,3,3,5],[4,3,4,5]]}
[]
[]
[null,null,null,"ELECTRICITY"]
[null,null,null,"SubMenu",null,null,null,null,null,{"$f":"[1]Menu!$I$4","v":"SA RANDS"}]
[null,null,null,null,null,null,null,null,null,{"$f":"[1]Menu!$I$5","v":2011}]

{"sheet":"Summary Instructions","index":1,"n_rows":86,"n_cols":6,"rows_kept":86,"cut":false,"hidden":false,"merged":[[67,2,67,7],[2,2,2,7],[46,2,46,7],[52,2,53,2],[56,2,57,2],[7,2,7,7],[22,2,22,7],[37,2,37,7],[14,5,14,7],[28,5,28,7],[43,5,43,7],[47,3,47,7],[33,3,34,4]]}
[]
[]
[null,null,"ELECTRICITY - SUMMARY INSTRUCTIONS"]
[]
[null,null,null,"Capture  anticipated and current Consumption Level Data for Tariff Consumer Groups on this screen."]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,"Data Required"]
[null,null,"Consumer Group Name - ","EG:  Industrial, Domestic"]
[null,null,"Consumption Types - ","EG:  Domestic Consumption Type 1"]
[null,null,null,"        Domestic Consumption Type 2"]
[null,null,"Consumption Levels - ","EG:  Consumption 7KL to 15KL"]
[null,null,null,"        Consumption 16KL to 30KL",null,"Municipal specific DATA INPUT"]
[null,null,"Units of  Demand - ","Estimated Demand for the upcoming year for each Consumption Level."]
[null,null,"Units of Demand (Historical)","Actual Demand for the last year."]
[null,null,"Current Actual Tariff - ","Tariff charged in the last financial year for each consumption level."]
[]
[]
[null,null,null,"Capture the anticipated and current Number of Users for Tariff Consumer Groups on this workscreen."]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,"Data Required"]
[null,null,"Consumer Group Name - ","EG:  Industrial, Domestic"]
[null,null,"Consumption Types - ","EG:  Availablility Fee for Vacant Stands"]
[null,null,null,"        Basic Fees"]
[null,null,"No. of Stands - ","Anticipated number of Stands for the upcoming year.",null,"Municipal specific DATA INPUT"]
[null,null,"No. of Stands - ","Actual number of Stands for the last year."]
[null,null,"Current Actual Tariff - ","Tariff charged for the last financial year for each consumption type"]
[]
[]
[null,null,null,"Capture the costs for the budget vote on this screen as well as the % allocated to Variable Costs. AT THE BOTTOM OF THE PAGE: the Revenue (from previous years units of demand * tariff) is proportioned and allocated per consumer group as a % of the total revenue. The variable costs and subsidy is also proportioned according to this %."]
[]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,"Data Required"]
[null,null,"Costs","EG:  Bulk Purchases:"]
[null,null,null,"Employee Related Costs:"]
[null,null,"Cost Detail","Bulk Purchases"]
[null,null,null,"Basic Salaries",null,"Municipal specific DATA INPUT"]
[null,null,null,"Social Contributions"]
[null,null,"Share of Varible Costs","Enter the % of the cost assigned to Variable Costs."]
[null,null,"A summary of Fixed and Variable costs is displayed at the top of this screen."]
[null,null,"REVENUE (Bottom Tables)","Type in the Revenue per Consumer Group, this is used to obtain a percentage per group from the Total Revenue. The Variable Cost and Subsidy Amount will then get proportioned out per consumer group. These calculations are used to work out the Tariffs."]
[]
[null,null,null,"The Primary baseline is calculated and then displayed on this screen."]
[]
[]
[null,null,"Tariff per Consumer Group","       Total Variable Costs per Consumer Group         "]
[null,null,null,"Total Units of Demand per Consumer Group"]
[]
[]
[null,null,"Fixed Tariff for Electricity Supply","  Total Fixed Facility Costs  "]
[null,null,null,"Total Number of Users"]
[]
[null,null,null,"The Primary Baseline is adjusted here to remove Free Basic Services from the Tariff calculation."]
[]
[]
[]
[null,null,null,"Input data for strategic decisions on this screen.  "]
[null,null,null,"Input data can be in the form of a number or a % change."]
[]
[]
[null,null,"Any cell with this background colour is an optional DATA INPUT cell."]
[]
[]
[]
[null,null,null,"The revised tariff takes into account input from Strategic Decisions and revises the Tariff accordingly."]
[]
[]
[]
[]
[null,null,null,"This screen compares the Current Actual Tariff and Revenue to the Revised Tariff and Revenue, for either Fixed or Variable Tariff. To see the Summary of both Tariff Comparisons, click this button"]
[]
[]
[null,null,"% CHANGE","Use the %Change column to increase or decrease the Revised Tariff.  As you enter the % change the Tariff and Rrevenue will change to reflect your input."]
[]
[null,null,"Current Actual - Revised","This column displays the difference betweenTariffs together with a colour indicator."]
[null,null,"TARIFF"]
[]
[null,null,"PROFIT\\LOSS","This column displays the difference between Revenues together with a colour indicator."]
[null,null,"REVENUE"]

{"sheet":"Data Capture Demand","index":2,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":false,"merged":[[130,2,130,3],[4,6,4,7],[6,6,6,7],[6,2,6,4],[2,2,2,7],[4,2,4,4]]}
[]
[]
[null,null,"ELECTRICITY - DATA CAPTURE: DEMAND PER YEAR"]
[]
[null,null,"FUTURE DEMAND",null,null,null,"HISTORICAL DEMAND"]
[]
[null,null,{"$f":"\"Financial Year: \"&Menu!J5&\"\\\"&Menu!J5+1","v":"Financial Year: 2011\\2012"},null,null,null,{"$f":"Menu!J5-1&\"\\\"&Menu!J5","v":"2010\\2011"}]
[null,null,"CONSUMER","CONSUMPTION LEVEL","UNITS OF DEMAND",null,"UNITS OF DEMAND","CURRENT ACTUAL TARIFF  PER UNIT"]
[null,1,"DOMESTIC - LOW INCOME (KwH)"]
[null,null,"Domestic Low Income Pre-paid",null,2750000,null,2500000,{"$f":"H15","v":0.78},null,null,null,null,null,{"$f":"G10*H10","v":1950000}]
[null,null,"Domestic Low Income Metered",null,0,null,0,{"$f":"H24","v":0.72},null,null,null,null,null,{"$f":"G11*H11","v":0}]
[null,null,"Consumption Total",null,{"$f":"SUM(E6:E11)","v":2750000},null,{"$f":"SUM(G10:G11)","v":2500000},null,null,null,null,null,null,{"$f":"SUM(N10:N11)","v":1950000}]
[]
[null,2,"DOMESTIC - PRE-PAID (KwH)"]
[null,null,"Domestic Pre-Paid Type 1",null,1650000,null,1500000,0.78,null,null,null,null,null,{"$f":"G15*H15","v":1170000}]
[null,null,"Domestic Pre-Paid Type 2",null,1500000,null,1500000,0.85,null,null,null,null,null,1275000]
[null,null,"Domestic Pre-Paid Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Pre-Paid Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Pre-Paid Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Pre-Paid Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E15:E20)","v":3150000},null,{"$f":"SUM(G15:G20)","v":3000000},null,null,null,null,null,null,{"$f":"SUM(N15:N20)","v":2445000}]
[]
[null,3,"DOMESTIC - METERED SINGLE PHASE (KwH)"]
[null,null,"Domestic Metered Single Phase Type 1",null,1400000,null,1500000,0.72,null,null,null,null,null,{"$f":"G24*H24","v":1080000}]
[null,null,"Domestic Metered Single Phase Type 2",null,1350000,null,1500000,0.9,null,null,null,null,null,1350000]
[null,null,"Domestic Metered Single Phase Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Metered Single Phase Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Metered Single Phase Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Metered Single Phase Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E24:E29)","v":2750000},null,{"$f":"SUM(G24:G29)","v":3000000},null,null,null,null,null,null,{"$f":"SUM(N24:N29)","v":2430000}]
[]
[null,4,"DOMESTIC - METERED THREE PHASE (KwH)"]
[null,null,"Domestic Metered Three Phase Type 1",null,3300000,null,3000000,0.75,null,null,null,null,null,{"$f":"G33*H33","v":2250000}]
[null,null,"Domestic Metered Three Phase Type 2",null,5250000,null,5000000,0.9,null,null,null,null,null,4500000]
[null,null,"Domestic Metered Three Phase Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Metered Three Phase Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Metered Three Phase Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Domestic Metered Three Phase Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E33:E38)","v":8550000},null,{"$f":"SUM(G33:G38)","v":8000000},null,null,null,null,null,null,{"$f":"SUM(N33:N38)","v":6750000}]
[]
[null,5,"INDUSTRIAL - METERED (KwH)"]
[null,null,"Industrial Metered (KwH) Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G42*H42","v":0}]
[null,null,"Industrial Metered (KwH) Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KwH) Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KwH) Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KwH) Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KwH) Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E42:E47)","v":0},null,{"$f":"SUM(G42:G47)","v":0},null,null,null,null,null,null,{"$f":"SUM(N42:N47)","v":0}]
[]
[null,6,"INDUSTRIAL - METERED (KvA)"]
[null,null,"Industrial Metered (KvA) Type 1",null,100000,null,100000,6,null,null,null,null,null,{"$f":"G51*H51","v":600000}]
[null,null,"Industrial Metered (KvA) Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KvA) Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KvA) Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KvA) Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Industrial Metered (KvA) Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E51:E56)","v":100000},null,{"$f":"SUM(G51:G56)","v":100000},null,null,null,null,null,null,{"$f":"SUM(N51:N56)","v":600000}]
[]
[null,7,"COMMERCIAL - METERED (KwH)"]
[null,null,"Commercial Metered (KwH) Type 1",null,1650000,null,1500000,0.75,null,null,null,null,null,{"$f":"G60*H60","v":1125000}]
[null,null,"Commercial Metered (KwH) Type 2",null,2100000,null,2000000,0.92,null,null,null,null,null,1840000]
[null,null,"Commercial Metered (KwH) Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KwH) Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KwH) Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KwH) Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E60:E65)","v":3750000},null,{"$f":"SUM(G60:G65)","v":3500000},null,null,null,null,null,null,{"$f":"SUM(N60:N65)","v":2965000}]
[]
[null,8,"COMMERCIAL - METERED (KvA)"]
[null,null,"Commercial Metered (KvA) Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G69*H69","v":0}]
[null,null,"Commercial Metered (KvA) Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KvA) Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KvA) Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KvA) Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Commercial Metered (KvA) Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E69:E74)","v":0},null,{"$f":"SUM(G69:G74)","v":0},null,null,null,null,null,null,{"$f":"SUM(N69:N74)","v":0}]
[]
[null,9,"INSTITUTIONAL - METERED (KwH)"]
[null,null,"Institutional Metered (KwH) Type 1",null,380000,null,400000,0.6,null,null,null,null,null,{"$f":"G78*H78","v":240000}]
[null,null,"Institutional Metered (KwH) Type 2",null,420000,null,400000,0.6,null,null,null,null,null,240000]
[null,null,"Institutional Metered (KwH) Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Institutional Metered (KwH) Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Institutional Metered (KwH) Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Institutional Metered (KwH) Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E78:E83)","v":800000},null,{"$f":"SUM(G78:G83)","v":800000},null,null,null,null,null,null,{"$f":"SUM(N78:N83)","v":480000}]
[]
[null,10,"TIME OF USE"]
[null,null,"Time of Use Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G87*H87","v":0}]
[null,null,"Time of Use Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Time of Use Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Time of Use Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Time of Use Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Time of Use Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E87:E92)","v":0},null,{"$f":"SUM(G87:G92)","v":0},null,null,null,null,null,null,{"$f":"SUM(N87:N92)","v":0}]
[]
[null,11,"TYPE V"]
[null,null,"Type V Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G96*H96","v":0}]
[null,null,"Type V Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type V Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type V Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type V Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type V Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E96:E101)","v":0},null,{"$f":"SUM(G96:G101)","v":0},null,null,null,null,null,null,{"$f":"SUM(N96:N101)","v":0}]
[]
[null,12,"TYPE X"]
[null,null,"Type X Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G105*H105","v":0}]
[null,null,"Type X Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type X Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type X Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type X Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type X Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E105:E110)","v":0},null,{"$f":"SUM(G105:G110)","v":0},null,null,null,null,null,null,{"$f":"SUM(N105:N110)","v":0}]
[]
[null,13,"TYPE Y"]
[null,null,"Type Y Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G114*H114","v":0}]
[null,null,"Type Y Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Y Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Y Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Y Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Y Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E114:E119)","v":0},null,{"$f":"SUM(G114:G119)","v":0},null,null,null,null,null,null,{"$f":"SUM(N114:N119)","v":0}]
[]
[null,14,"TYPE Z"]
[null,null,"Type Z Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G123*H123","v":0}]
[null,null,"Type Z Type 2",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Z Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Z Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Z Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type Z Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E123:E128)","v":0},null,{"$f":"SUM(G123:G128)","v":0},null,null,null,null,null,null,{"$f":"SUM(N123:N128)","v":0}]
[]
[null,null,"TOTAL ELECTRICITY DEMAND",null,{"$f":"SUM(E12+E21+E30+E39+E48+E57+E66+E75+E84+E93+E102+E111+E120+E129)","v":21850000},null,{"$f":"SUM(G12+G21+G30+G39+G48+G57+G66+G75+G84+G93+G102+G111+G120+G129)","v":20900000}]

{"sheet":"Data Capture Users","index":3,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,5,6,6],[4,5,4,6],[2,2,2,6],[4,2,4,3],[6,2,6,3]]}
[]
[]
[null,null,"ELECTRICITY - DATA CAPTURE: USERS PER YEAR"]
[]
[null,null,"FUTURE NUMBER OF STANDS",null,null,"HISTORICAL NUMBER OF STANDS"]
[]
[null,null,{"$f":"\"Financial Year: \"&Menu!J5&\"\\\"&Menu!J5+1","v":"Financial Year: 2011\\2012"},null,null,{"$f":"Menu!J5-1&\"\\\"&Menu!J5","v":"2010\\2011"}]
[null,null,"CONSUMER","NO OF STANDS",null,"NO OF STANDS","CURRENT ACTUAL TARIFF PER STAND"]
[null,null,"DOMESTIC - LOW INCOME (KwH)"]
[null,null,"Domestic Low Income Pre-paid",2200,null,2000,{"$f":"G16","v":0},null,null,null,null,{"$f":"F10*G10","v":0}]
[null,null,"Domestic Low Income Metered",0,null,0,{"$f":"G22","v":600},null,null,null,null,{"$f":"F11*G11","v":0}]
[null,null,"Stand Total",{"$f":"SUM(D10:D11)","v":2200},null,{"$f":"SUM(F10:F11)","v":2000},null,null,null,null,null,{"$f":"SUM(L10:L11)","v":0}]
[]
[null,null,"DOMESTIC - PRE-PAID (KwH)"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0,null,null,null,null,{"$f":"F15*G15","v":0}]
[null,null,"Basic Fees for Occupied Stands",0,null,0,0,null,null,null,null,{"$f":"F16*G16","v":0}]
[null,null,null,0,null,0,0,null,null,null,null,0]
[null,null,"Stand Total",{"$f":"SUM(D15:D17)","v":0},null,{"$f":"SUM(F15:F17)","v":0},null,null,null,null,null,{"$f":"SUM(L15:L17)","v":0}]
[]
[null,null,"DOMESTIC - METERED SINGLE & THREE PHASE (KwH)"]
[null,null,"Availablility Fees for Vacant Stands",900,null,1000,600]
[null,null,"Basic Fees for Occupied Stands",10100,null,10000,600]
[null,null,null,0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D21:D23)","v":11000},null,{"$f":"SUM(F21:F23)","v":11000}]
[]
[null,null,"INDUSTRIAL"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0]
[null,null,"Basic Fees for Occupied Stands",0,null,0,0]
[null,null,null,0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D27:D29)","v":0},null,{"$f":"SUM(F27:F29)","v":0}]
[]
[null,null,"COMMERCIAL"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0]
[null,null,"Basic Fees for Occupied Stands",0,null,0,0]
[null,null,null,0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D33:D35)","v":0},null,{"$f":"SUM(F33:F35)","v":0}]
[]
[null,null,"INSTITUTIONAL"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0]
[null,null,"Basic Fees for Occupied Stands",0,null,0,0]
[null,null,null,0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D39:D41)","v":0},null,{"$f":"SUM(F39:F41)","v":0}]
[]
[null,null,"TOTAL NUMBER OF STANDS",{"$f":"SUM(D12+D18+D24+D30+D36+D42)","v":13200},null,{"$f":"SUM(F12+F18+F24+F30+F36+F42)","v":13000}]

{"sheet":"Data Capture Costs","index":4,"n_rows":99,"n_cols":53,"rows_kept":99,"cut":false,"hidden":false,"merged":[[39,2,39,4],[51,2,51,3],[9,5,10,5],[9,6,10,6],[2,2,2,6],[9,3,9,4],[40,2,40,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[68,2,68,3],[62,2,62,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[63,2,63,3],[58,1,58,5],[59,2,59,3],[60,2,60,3],[61,2,61,3],[55,2,55,3],[74,2,74,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: COSTS BY BUDGET VOTE\"","v":"ELECTRICITY - DATA CAPTURE: COSTS BY BUDGET VOTE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03]
[null,null,"SUMMARY",{"$f":"Menu!J4","v":"SA RANDS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04]
[null,null,"TOTAL VARIABLE COSTS",{"$f":"SUMPRODUCT($E$12:$E$33,$F$12:$F$33)","v":20945000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05]
[null,null,"TOTAL FIXED FACILITY COSTS",{"$f":"SUMPRODUCT($E$12:$E$33,$G$12:$G$33)","v":8105000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06]
[null,null,"TOTAL RING FENCED COSTS",{"$f":"SUM(D6:D7)","v":29050000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08]
[null,null,"COSTS BY BUDGET VOTE",{"$f":"Menu!J4","v":"SA RANDS"},null,"Share of Variable Costs","Share of Fixed Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09]
[null,null,"Costs","Detail",{"$f":"\"Year\"&\" \"&Menu!$J$5&\"\\\"&Menu!$J$5+1","v":"Year 2011\\2012"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,"Bulk Purchases:","Bulk Purchases",13000000,0.9,{"$f":"IF(F12=\"\",\"\",1-F12)","v":9.9999999999999978E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11]
[null,null,"Employee Related Costs:","Basic Salaries",6000000,0.8,{"$f":"IF(F13=\"\",\"\",1-F13)","v":0.19999999999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12]
[null,null,"Employee Related Costs:","Social Contributions",2000000,0.9,{"$f":"IF(F14=\"\",\"\",1-F14)","v":9.9999999999999978E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.13]
[null,null,"Repairs and Maintenance","Repairs and Maintenance",2000000,0.2,0.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001]
[null,null,"Other Costs:","General Costs",350000,0.5,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[null,null,"Other Costs:","Collection Commission",0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16]
[null,null,"Other Cost:","Contracted Services",0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17]
[null,null,"Other Costs:","Contributions to Provisions",0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18]
[null,null,"Other Costs:","Debt Impairment",0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19]
[null,null,"Other Costs:","Motor Vehicle Costs",5000000,0.4,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,"Depreciation:",null,0,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21]
[null,null,"External Interest:",null,0,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22]
[null,null,"Reserves\\Provisions for Capital Improvements:",null,0,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23]
[null,null,"Other Costs:",null,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24]
[null,null,"Other Costs:",null,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,"Other Costs:",null,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.26]
[null,null,"Other Costs:",null,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27]
[null,null,"Other Costs:",null,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003]
[null,null,"Other Costs:",null,0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998]
[null,null,"Overhead Costs Re-Allocated (+)",null,700000,0.1,0.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,"Overhead Costs Re-Allocated (-)","Less",0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31]
[null,null,"Less Sundry Income ","Less Sundry Income Generated from Indirect Services",0,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32]
[null,null,"TOTAL COSTS BY BUDGET VOTE",null,{"$f":"SUM(E12:E31)-E32-E33","v":29050000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34]
[null,null,"TOTAL RING FENCED COSTS",null,{"$f":"E34","v":29050000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.36]
[null,null,"COST APPORTIONMENT FOR MULTIPLE PRIMARY BASELINES",null,null,null,null,null,null,null,null,"Subsidy %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38]
[null,null,"PRIOR YEAR - REVENUE PER CONSUMER GROUP",null,"REVENUE",null,null,null,"% of Revenue per Consumer Group","Variable Cost allocated by Revenue","Subsidy Amt",{"$f":"$D$6*'Strategic Decisions'!$J$13%","v":0},"Revenue plus Subsidy %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39]
[null,1,{"$f":"'Data Capture Demand'!C9","v":"DOMESTIC - LOW INCOME (KwH)"},null,{"$f":"'Data Capture Demand'!N12","v":1950000},null,null,null,{"$f":"IF(E42=0,0,E42/$E$56)","v":0.11066969353007945},{"$f":"$D$6*(I42)","v":2317976.7309875139},{"$f":"I42*'Strategic Decisions'!$J$11","v":0},{"$f":"I42*$L$41","v":0},{"$f":"J42+K42+L42","v":2317976.7309875139},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,2,{"$f":"'Data Capture Demand'!C14","v":"DOMESTIC - PRE-PAID (KwH)"},null,{"$f":"'Data Capture Demand'!N21","v":2445000},null,null,null,{"$f":"IF(E43=0,0,E43/$E$56)","v":0.1387627695800227},{"$f":"$D$6*(I43)","v":2906386.2088535754},{"$f":"I43*'Strategic Decisions'!$J$11","v":0},{"$f":"I43*$L$41","v":0},2906386.2088535754,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41]
[null,3,{"$f":"'Data Capture Demand'!C23","v":"DOMESTIC - METERED SINGLE PHASE (KwH)"},"",{"$f":"'Data Capture Demand'!N30","v":2430000},null,null,null,0.13791146424517595,2888555.6186152101,{"$f":"I44*'Strategic Decisions'!$J$11","v":0},0,2888555.6186152101,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42]
[null,4,{"$f":"'Data Capture Demand'!C32","v":"DOMESTIC - METERED THREE PHASE (KwH)"},"",{"$f":"'Data Capture Demand'!N39","v":6750000},null,null,null,0.38308740068104424,8023765.6072644712,{"$f":"I45*'Strategic Decisions'!$J$11","v":0},0,8023765.6072644712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43]
[null,5,{"$f":"'Data Capture Demand'!C41","v":"INDUSTRIAL - METERED (KwH)"},"",{"$f":"'Data Capture Demand'!N48","v":0},null,null,null,0,0,{"$f":"I46*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44]
[null,6,{"$f":"'Data Capture Demand'!C50","v":"INDUSTRIAL - METERED (KvA)"},null,{"$f":"'Data Capture Demand'!N57","v":600000},null,null,null,3.4052213393870601E-2,713223.60953461973,{"$f":"I47*'Strategic Decisions'!$J$11","v":0},0,713223.60953461973,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45]
[null,7,{"$f":"'Data Capture Demand'!C59","v":"COMMERCIAL - METERED (KwH)"},null,{"$f":"'Data Capture Demand'!N66","v":2965000},null,null,null,0.16827468785471056,3524513.3371169125,{"$f":"I48*'Strategic Decisions'!$J$11","v":0},0,3524513.3371169125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46]
[null,8,{"$f":"'Data Capture Demand'!C68","v":"COMMERCIAL - METERED (KvA)"},null,{"$f":"'Data Capture Demand'!N75","v":0},null,null,null,0,0,{"$f":"I49*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.47]
[null,9,{"$f":"'Data Capture Demand'!C77","v":"INSTITUTIONAL - METERED (KwH)"},null,{"$f":"'Data Capture Demand'!N84","v":480000},null,null,null,2.7241770715096481E-2,570578.8876276958,{"$f":"I50*'Strategic Decisions'!$J$11","v":0},0,570578.8876276958,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48]
[null,10,{"$f":"'Data Capture Demand'!C86","v":"TIME OF USE"},null,{"$f":"'Data Capture Demand'!N93","v":0},null,null,null,0,0,{"$f":"I51*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,11,{"$f":"'Data Capture Demand'!C95","v":"TYPE V"},null,{"$f":"'Data Capture Demand'!N102","v":0},null,null,null,0,0,{"$f":"I52*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,12,{"$f":"'Data Capture Demand'!C104","v":"TYPE X"},null,{"$f":"'Data Capture Demand'!N111","v":0},null,null,null,0,0,{"$f":"I53*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52]
[null,13,{"$f":"'Data Capture Demand'!C113","v":"TYPE Y"},null,{"$f":"'Data Capture Demand'!N120","v":0},null,null,null,0,0,{"$f":"I54*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53]
[null,14,{"$f":"'Data Capture Demand'!C122","v":"TYPE Z"},null,{"$f":"'Data Capture Demand'!N129","v":0},null,null,null,0,0,{"$f":"I55*'Strategic Decisions'!$J$11","v":0},{"$f":"I55*$L$41","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54]
[null,null,"TOTAL REVENUE",null,{"$f":"SUM(E42:E55)","v":17620000},null,null,null,{"$f":"SUM(I42:I55)","v":1},{"$f":"SUM(J42:J55)","v":20945000},{"$f":"SUM(K42:K55)","v":0},{"$f":"SUM(L42:L55)","v":0},{"$f":"SUM(M42:M55)","v":20945000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56999999999999995]
[null,null,null,null,null,null,null,null,null,null,null,"Subsidy %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999996]
[null,null,"PRIOR YEAR - REVENUE PER CONSUMER GROUP (EXCLUDING DOMESTIC LOW INCOME)",null,"REVENUE",null,null,null,"% of Revenue per Consumer Group","Variable Cost allocated by Revenue","Subsidy Amt",{"$f":"$D$6*'Strategic Decisions'!$J$13%","v":0},"Cost plus Subsidy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.59]
[null,1,{"$f":"C42","v":"DOMESTIC - LOW INCOME (KwH)"},null,0,null,null,null,{"$f":"IF(E61=0,0,E61/$E$75)","v":0},{"$f":"$D$6*(I61)","v":0},{"$f":"I61*'Strategic Decisions'!$J$11","v":0},{"$f":"I61*$L$60","v":0},{"$f":"J61+K61+L61","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,2,{"$f":"C43","v":"DOMESTIC - PRE-PAID (KwH)"},null,{"$f":"E43","v":2445000},null,null,null,{"$f":"IF(E62=0,0,E62/$E$75)","v":0.15603063178047225},{"$f":"$D$6*(I62)","v":3268061.5826419913},{"$f":"I62*'Strategic Decisions'!$J$11","v":0},{"$f":"I62*$L$60","v":0},3268061.5826419913,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61]
[null,3,"DOMESTIC - METERED SINGLE PHASE (KwH)",null,2430000,null,null,null,0.15507338864071474,3248012.1250797701,{"$f":"I63*'Strategic Decisions'!$J$11","v":0},0,3248012.1250797701,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62]
[null,4,"DOMESTIC - METERED THREE PHASE (KwH)",null,6750000,null,null,null,0.43075941289087427,9022255.902999362,{"$f":"I64*'Strategic Decisions'!$J$11","v":0},0,9022255.902999362,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63]
[null,5,"INDUSTRIAL - METERED (KwH)",null,0,null,null,null,0,0,{"$f":"I65*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64]
[null,6,"INDUSTRIAL - METERED (KvA)",null,600000,null,null,null,3.8289725590299938E-2,801978.30248883215,{"$f":"I66*'Strategic Decisions'!$J$11","v":0},0,801978.30248883215,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,7,"COMMERCIAL - METERED (KwH)",null,2965000,null,null,null,0.18921506062539886,3963109.444798979,{"$f":"I67*'Strategic Decisions'!$J$11","v":0},0,3963109.444798979,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66]
[null,8,"COMMERCIAL - METERED (KvA)",null,0,null,null,null,0,0,{"$f":"I68*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67]
[null,9,"INSTITUTIONAL - METERED (KwH)",null,480000,null,null,null,3.0631780472239949E-2,641582.6419910657,{"$f":"I69*'Strategic Decisions'!$J$11","v":0},0,641582.6419910657,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.68]
[null,10,"TIME OF USE",null,0,null,null,null,0,0,{"$f":"I70*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69]
[null,11,"TYPE V",null,0,null,null,null,0,0,{"$f":"I71*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71]
[null,12,"TYPE X",null,0,null,null,null,0,0,{"$f":"I72*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72]
[null,13,"TYPE Y",null,0,null,null,null,0,0,{"$f":"I73*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73]
[null,14,"TYPE Z",null,0,null,null,null,0,0,{"$f":"I74*'Strategic Decisions'!$J$11","v":0},0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74]
[null,null,"TOTAL REVENUE",null,{"$f":"SUM(E61:E74)","v":15670000},null,null,null,1,{"$f":"SUM(J60:J74)","v":20944999.999999996},{"$f":"SUM(K61:K74)","v":0},{"$f":"SUM(L61:L74)","v":0},{"$f":"SUM(M60:M74)","v":20944999.999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Primary Baseline Tariff","index":5,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,2,4,3],[2,2,2,3]]}
[]
[]
[null,null,"PRIMARY BASELINE TARIFF"]
[]
[null,null,"Below is a basic tariff calculated per baseline unit. Note: Electricity has a fixed and a variable component."]
[]
[null,null,"VARIABLE COSTS PER CONSUMER GROUP","TARIFF"]
[null,1,{"$f":"IF('Data Capture Costs'!C42=\"\",\"\",'Data Capture Costs'!C42)","v":"DOMESTIC - LOW INCOME (KwH)"},{"$f":"IF('Data Capture Demand'!E12=0,0,'Data Capture Costs'!J42/'Data Capture Demand'!E12)","v":0.8429006294500051}]
[null,2,{"$f":"IF('Data Capture Costs'!C43=\"\",\"\",'Data Capture Costs'!C43)","v":"DOMESTIC - PRE-PAID (KwH)"},{"$f":"IF('Data Capture Demand'!E21=0,0,'Data Capture Costs'!J43/'Data Capture Demand'!E21)","v":0.92266228852494458}]
[null,3,{"$f":"IF('Data Capture Costs'!C44=\"\",\"\",'Data Capture Costs'!C44)","v":"DOMESTIC - METERED SINGLE PHASE (KwH)"},{"$f":"IF('Data Capture Demand'!E30=0,0,'Data Capture Costs'!J44/'Data Capture Demand'!E30)","v":1.0503838613146219}]
[null,4,{"$f":"IF('Data Capture Costs'!C45=\"\",\"\",'Data Capture Costs'!C45)","v":"DOMESTIC - METERED THREE PHASE (KwH)"},{"$f":"IF('Data Capture Demand'!E39=0,0,'Data Capture Costs'!J45/'Data Capture Demand'!E39)","v":0.93845211780871007}]
[null,5,{"$f":"IF('Data Capture Costs'!C46=\"\",\"\",'Data Capture Costs'!C46)","v":"INDUSTRIAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E48=0,0,'Data Capture Costs'!J46/'Data Capture Demand'!E48)","v":0}]
[null,6,{"$f":"IF('Data Capture Costs'!C47=\"\",\"\",'Data Capture Costs'!C47)","v":"INDUSTRIAL - METERED (KvA)"},{"$f":"IF('Data Capture Demand'!E57=0,0,'Data Capture Costs'!J47/'Data Capture Demand'!E57)","v":7.1322360953461974}]
[null,7,{"$f":"IF('Data Capture Costs'!C48=\"\",\"\",'Data Capture Costs'!C48)","v":"COMMERCIAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E66=0,0,'Data Capture Costs'!J48/'Data Capture Demand'!E66)","v":0.93987022323117664}]
[null,8,{"$f":"IF('Data Capture Costs'!C49=\"\",\"\",'Data Capture Costs'!C49)","v":"COMMERCIAL - METERED (KvA)"},{"$f":"IF('Data Capture Demand'!E75=0,0,'Data Capture Costs'!J49/'Data Capture Demand'!E75)","v":0}]
[null,9,{"$f":"IF('Data Capture Costs'!C50=\"\",\"\",'Data Capture Costs'!C50)","v":"INSTITUTIONAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E84=0,0,'Data Capture Costs'!J50/'Data Capture Demand'!E84)","v":0.71322360953461972}]
[null,10,{"$f":"IF('Data Capture Costs'!C51=\"\",\"\",'Data Capture Costs'!C51)","v":"TIME OF USE"},{"$f":"IF('Data Capture Demand'!E93=0,0,'Data Capture Costs'!J51/'Data Capture Demand'!E93)","v":0}]
[null,11,{"$f":"IF('Data Capture Costs'!C52=\"\",\"\",'Data Capture Costs'!C52)","v":"TYPE V"},{"$f":"IF('Data Capture Demand'!E102=0,0,'Data Capture Costs'!J52/'Data Capture Demand'!E102)","v":0}]
[null,12,{"$f":"IF('Data Capture Costs'!C53=\"\",\"\",'Data Capture Costs'!C53)","v":"TYPE X"},{"$f":"IF('Data Capture Demand'!E111=0,0,'Data Capture Costs'!J53/'Data Capture Demand'!E111)","v":0}]
[null,13,{"$f":"IF('Data Capture Costs'!C54=\"\",\"\",'Data Capture Costs'!C54)","v":"TYPE Y"},{"$f":"IF('Data Capture Demand'!E120=0,0,'Data Capture Costs'!J54/'Data Capture Demand'!E120)","v":0}]
[null,14,{"$f":"IF('Data Capture Costs'!C55=\"\",\"\",'Data Capture Costs'!C55)","v":"TYPE Z"},{"$f":"IF('Data Capture Demand'!E129=0,0,'Data Capture Costs'!J55/'Data Capture Demand'!E129)","v":0}]
[]
[null,null,"FIXED FACILITY COSTS PER YEAR","TARIFF"]
[null,null,{"$f":"'Data Capture Costs'!C7","v":"TOTAL FIXED FACILITY COSTS"},{"$f":"'Data Capture Costs'!$D$7","v":8105000}]
[null,null,{"$f":"'Data Capture Users'!$C$44","v":"TOTAL NUMBER OF STANDS"},{"$f":"'Data Capture Users'!$D$44","v":13200}]
[null,null,"FIXED TARIFF FOR ELECTRICITY SUPPLY",{"$f":"IF(D24=0,0,D24/D25)","v":614.0151515151515}]

{"sheet":"Adj Primary Baseline Tariff","index":6,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,9,21,10],[2,2,2,3],[4,2,4,3],[5,7,5,8],[5,9,5,10],[21,7,21,8]]}
[]
[]
[null,null,"ADJUSTED PRIMARY BASELINE TARIFF"]
[]
[null,null,"Adjusted Primary Baseline Tariff after costing Free Basic Electricity."]
[null,null,null,null,null,null,null,"COST TO FREE BASIC ELECTRICITY",null,{"$f":"Menu!$J$4","v":"SA RANDS"}]
[null,null,"VARIABLE COSTS PER CONSUMER GROUP","TARIFF",null,null,null,"CONSUMER","ELECTRICITY DEMAND","REVENUE","FREE BASIC ELECTR. COST"]
[null,1,{"$f":"IF('Data Capture Costs'!C42=\"\",\"\",'Data Capture Costs'!C42)","v":"DOMESTIC - LOW INCOME (KwH)"},{"$f":"IF('Data Capture Demand'!E12=0,0,'Data Capture Costs'!J61/'Data Capture Demand'!E12)","v":0},null,null,null,"OTHER CONSUMPTION",null,{"$f":"'Data Capture Costs'!E75","v":15670000}]
[null,2,{"$f":"IF('Data Capture Costs'!C43=\"\",\"\",'Data Capture Costs'!C43)","v":"DOMESTIC - PRE-PAID (KwH)"},{"$f":"IF('Data Capture Demand'!E21=0,0,'Data Capture Costs'!J62/'Data Capture Demand'!E21)","v":1.037479867505394},null,null,null,"Domestic (Free Basic Electricity) Consumption",{"$f":"'Data Capture Demand'!E12","v":2750000},{"$f":"'Data Capture Costs'!E42","v":1950000},{"$f":"I9*'Primary Baseline Tariff'!D9","v":2537321.2934435974}]
[null,3,{"$f":"IF('Data Capture Costs'!C44=\"\",\"\",'Data Capture Costs'!C44)","v":"DOMESTIC - METERED SINGLE PHASE (KwH)"},{"$f":"IF('Data Capture Demand'!E30=0,0,'Data Capture Costs'!J63/'Data Capture Demand'!E30)","v":1.1810953182108255}]
[null,4,{"$f":"IF('Data Capture Costs'!C45=\"\",\"\",'Data Capture Costs'!C45)","v":"DOMESTIC - METERED THREE PHASE (KwH)"},{"$f":"IF('Data Capture Demand'!E39=0,0,'Data Capture Costs'!J64/'Data Capture Demand'!E39)","v":1.0552346085379372},null,null,null,null,null,"`"]
[null,5,{"$f":"IF('Data Capture Costs'!C46=\"\",\"\",'Data Capture Costs'!C46)","v":"INDUSTRIAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E48=0,0,'Data Capture Costs'!J65/'Data Capture Demand'!E48)","v":0}]
[null,6,{"$f":"IF('Data Capture Costs'!C47=\"\",\"\",'Data Capture Costs'!C47)","v":"INDUSTRIAL - METERED (KvA)"},{"$f":"IF('Data Capture Demand'!E57=0,0,'Data Capture Costs'!J66/'Data Capture Demand'!E57)","v":8.0197830248883211}]
[null,7,{"$f":"IF('Data Capture Costs'!C48=\"\",\"\",'Data Capture Costs'!C48)","v":"COMMERCIAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E66=0,0,'Data Capture Costs'!J67/'Data Capture Demand'!E66)","v":1.0568291852797278}]
[null,8,{"$f":"IF('Data Capture Costs'!C49=\"\",\"\",'Data Capture Costs'!C49)","v":"COMMERCIAL - METERED (KvA)"},{"$f":"IF('Data Capture Demand'!E75=0,0,'Data Capture Costs'!J68/'Data Capture Demand'!E75)","v":0}]
[null,9,{"$f":"IF('Data Capture Costs'!C50=\"\",\"\",'Data Capture Costs'!C50)","v":"INSTITUTIONAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E84=0,0,'Data Capture Costs'!J69/'Data Capture Demand'!E84)","v":0.80197830248883217}]
[null,10,{"$f":"IF('Data Capture Costs'!C51=\"\",\"\",'Data Capture Costs'!C51)","v":"TIME OF USE"},{"$f":"IF('Data Capture Demand'!E93=0,0,'Data Capture Costs'!J70/'Data Capture Demand'!E93)","v":0}]
[null,11,{"$f":"IF('Data Capture Costs'!C52=\"\",\"\",'Data Capture Costs'!C52)","v":"TYPE V"},{"$f":"IF('Data Capture Demand'!E102=0,0,'Data Capture Costs'!J71/'Data Capture Demand'!E102)","v":0}]
[null,12,{"$f":"IF('Data Capture Costs'!C53=\"\",\"\",'Data Capture Costs'!C53)","v":"TYPE X"},{"$f":"IF('Data Capture Demand'!E111=0,0,'Data Capture Costs'!J72/'Data Capture Demand'!E111)","v":0}]
[null,13,{"$f":"IF('Data Capture Costs'!C54=\"\",\"\",'Data Capture Costs'!C54)","v":"TYPE Y"},{"$f":"IF('Data Capture Demand'!E120=0,0,'Data Capture Costs'!J73/'Data Capture Demand'!E120)","v":0}]
[null,14,{"$f":"IF('Data Capture Costs'!C55=\"\",\"\",'Data Capture Costs'!C55)","v":"TYPE Z"},{"$f":"IF('Data Capture Demand'!E129=0,0,'Data Capture Costs'!J74/'Data Capture Demand'!E129)","v":0}]
[null,null,null,null,null,null,null,"FIXED AVAILABILITY FEES",null,{"$f":"Menu!$J$4","v":"SA RANDS"}]
[null,null,"FIXED FACILITY COSTS PER YEAR","TARIFF",null,null,null,"CONSUMER","NO OF STANDS","REVENUE","FREE BASIC ELECTR. COST"]
[null,null,{"$f":"'Primary Baseline Tariff'!$C$24","v":"TOTAL FIXED FACILITY COSTS"},{"$f":"'Data Capture Costs'!$D$7","v":8105000},null,null,null,"OTHER CONSUMERS",null,{"$f":"'Primary Baseline Tariff'!D24-'Data Capture Users'!L12","v":8105000}]
[null,null,{"$f":"'Data Capture Users'!$C$44","v":"TOTAL NUMBER OF STANDS"},{"$f":"'Data Capture Users'!$D$44-'Data Capture Users'!D12","v":11000},null,null,null,"Domestic (Free Basic Electricity) Consumers",{"$f":"'Data Capture Users'!D12","v":2200},{"$f":"'Data Capture Users'!L12","v":0},{"$f":"J25","v":0}]
[null,null,{"$f":"'Primary Baseline Tariff'!C26","v":"FIXED TARIFF FOR ELECTRICITY SUPPLY"},{"$f":"IF(D24=0,0,D24/D25)","v":736.81818181818187}]

{"sheet":"Strategic Decisions","index":7,"n_rows":27,"n_cols":56,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,2,2,5],[3,2,3,5],[15,2,15,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[null,null,"STRATEGIC DECISIONS",null,null,null,null,null,null,"Changes to Variable Costs"]
[null,null,null,null,null,null,null,null,null,{"$f":"$D$8+$F$8","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,"FINANCIAL DECISIONS","AMOUNT","%","% AMT",null,null,null,{"$f":"$D$13+$F$13","v":0}]
[null,1,"Do you wish to achieve a Surplus on this service?","YES",null,null,null,null,null,{"$f":"$D$19+$F$19","v":0}]
[null,null,null,"NO",null,null,null,null,null,"TOTAL SUBSIDY"]
[null,null,"Enter Size of the Surplus",0,0,{"$f":"E8%*'Data Capture Costs'!$D$6","v":0},null,null,null,{"$f":"SUM(J4-J5+J6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Subsidy Amt"]
[null,2,"Are you willing to make a Deficit on this service?","YES",null,null,null,null,null,{"$f":"$D$8-$D$13+$D$19","v":0}]
[null,null,null,"NO",null,null,null,null,null,"Subsidy %"]
[null,null,"Enter Size of the Deficit",0,0,{"$f":"E13%*'Data Capture Costs'!$D$6","v":0},null,null,null,{"$f":"$E$8-$E$13+$E$19","v":0}]
[]
[null,null,"AFFORDABILITY DECISIONS","AMOUNT","%","% AMT"]
[null,null,"Most of these decisions are contained in the municipality's  Tariff policy and therefore already form part of the information used to populate the model. However the decisions can at this point be re-visited  and altered as necessary before the tariff  is finalised."]
[null,3,"Do you plan to subsidise the delivery of this service (excluding Free Basic Services)?","YES"]
[null,null,null,"NO"]
[null,null,"Enter Size of Subsidy",0,0,{"$f":"E19%*'Data Capture Costs'!$D$6","v":0}]
[]
[]
[null,4,"Do you wish to limit the Size of the Tariff levied on certain type of consumers?","CHANGE VARIABLE TARIFF"]
[null,null,null,"CHANGE FIXED TARIFF"]
[]
[]
[null,5,"Do you wish to Escalate the Tariff levied on certain type of consumers?","CHANGE VARIABLE TARIFF"]
[null,null,null,"CHANGE FIXED TARIFF"]

{"sheet":"Revised Primary Baseline Tariff","index":8,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,2,2,3],[4,2,4,3]]}
[]
[]
[null,null,"REVISED PRIMARY BASELINE TARIFF"]
[]
[null,null,"After Strategic Decisions this is the revised tariff."]
[]
[null,null,"VARIABLE COSTS PER CONSUMER GROUP","TARIFF"]
[null,1,{"$f":"IF('Data Capture Costs'!C42=\"\",\"\",'Data Capture Costs'!C42)","v":"DOMESTIC - LOW INCOME (KwH)"},0]
[null,2,{"$f":"IF('Data Capture Costs'!C43=\"\",\"\",'Data Capture Costs'!C43)","v":"DOMESTIC - PRE-PAID (KwH)"},{"$f":"IF('Data Capture Demand'!E21=0,0,'Data Capture Costs'!M62/'Data Capture Demand'!E21)","v":1.037479867505394}]
[null,3,{"$f":"IF('Data Capture Costs'!C44=\"\",\"\",'Data Capture Costs'!C44)","v":"DOMESTIC - METERED SINGLE PHASE (KwH)"},{"$f":"IF('Data Capture Demand'!E30=0,0,'Data Capture Costs'!M63/'Data Capture Demand'!E30)","v":1.1810953182108255}]
[null,4,{"$f":"IF('Data Capture Costs'!C45=\"\",\"\",'Data Capture Costs'!C45)","v":"DOMESTIC - METERED THREE PHASE (KwH)"},{"$f":"IF('Data Capture Demand'!E39=0,0,'Data Capture Costs'!M64/'Data Capture Demand'!E39)","v":1.0552346085379372}]
[null,5,{"$f":"IF('Data Capture Costs'!C46=\"\",\"\",'Data Capture Costs'!C46)","v":"INDUSTRIAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E48=0,0,'Data Capture Costs'!M65/'Data Capture Demand'!E48)","v":0}]
[null,6,{"$f":"IF('Data Capture Costs'!C47=\"\",\"\",'Data Capture Costs'!C47)","v":"INDUSTRIAL - METERED (KvA)"},{"$f":"IF('Data Capture Demand'!E57=0,0,'Data Capture Costs'!M66/'Data Capture Demand'!E57)","v":8.0197830248883211}]
[null,7,{"$f":"IF('Data Capture Costs'!C48=\"\",\"\",'Data Capture Costs'!C48)","v":"COMMERCIAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E66=0,0,'Data Capture Costs'!M67/'Data Capture Demand'!E66)","v":1.0568291852797278}]
[null,8,{"$f":"IF('Data Capture Costs'!C49=\"\",\"\",'Data Capture Costs'!C49)","v":"COMMERCIAL - METERED (KvA)"},{"$f":"IF('Data Capture Demand'!E75=0,0,'Data Capture Costs'!M68/'Data Capture Demand'!E75)","v":0}]
[null,9,{"$f":"IF('Data Capture Costs'!C50=\"\",\"\",'Data Capture Costs'!C50)","v":"INSTITUTIONAL - METERED (KwH)"},{"$f":"IF('Data Capture Demand'!E84=0,0,'Data Capture Costs'!M69/'Data Capture Demand'!E84)","v":0.80197830248883217}]
[null,10,{"$f":"IF('Data Capture Costs'!C51=\"\",\"\",'Data Capture Costs'!C51)","v":"TIME OF USE"},{"$f":"IF('Data Capture Demand'!E93=0,0,'Data Capture Costs'!M70/'Data Capture Demand'!E93)","v":0}]
[null,11,{"$f":"IF('Data Capture Costs'!C52=\"\",\"\",'Data Capture Costs'!C52)","v":"TYPE V"},{"$f":"IF('Data Capture Demand'!E102=0,0,'Data Capture Costs'!M71/'Data Capture Demand'!E102)","v":0}]
[null,12,{"$f":"IF('Data Capture Costs'!C53=\"\",\"\",'Data Capture Costs'!C53)","v":"TYPE X"},{"$f":"IF('Data Capture Demand'!E111=0,0,'Data Capture Costs'!M72/'Data Capture Demand'!E111)","v":0}]
[null,13,{"$f":"IF('Data Capture Costs'!C54=\"\",\"\",'Data Capture Costs'!C54)","v":"TYPE Y"},{"$f":"IF('Data Capture Demand'!E120=0,0,'Data Capture Costs'!M73/'Data Capture Demand'!E120)","v":0}]
[null,14,{"$f":"IF('Data Capture Costs'!C55=\"\",\"\",'Data Capture Costs'!C55)","v":"TYPE Z"},{"$f":"IF('Data Capture Demand'!E129=0,0,'Data Capture Costs'!M74/'Data Capture Demand'!E129)","v":0}]
[]
[null,null,"FIXED FACILITY COSTS PER YEAR","TARIFF"]
[null,null,{"$f":"'Primary Baseline Tariff'!$C$24","v":"TOTAL FIXED FACILITY COSTS"},{"$f":"'Data Capture Costs'!$D$7","v":8105000}]
[null,null,{"$f":"'Data Capture Users'!$C$44","v":"TOTAL NUMBER OF STANDS"},{"$f":"'Data Capture Users'!D44-'Data Capture Users'!D12","v":11000}]
[null,null,{"$f":"'Primary Baseline Tariff'!C26","v":"FIXED TARIFF FOR ELECTRICITY SUPPLY"},{"$f":"IF(D24=0,0,D24/D25)","v":736.81818181818187}]

{"sheet":"Test Afford of Variable Tariff","index":9,"n_rows":106,"n_cols":16,"rows_kept":106,"cut":false,"hidden":false,"merged":[[103,5,103,6],[2,2,2,15],[4,5,4,6],[4,10,4,12],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,7,4,8],[103,11,103,12]]}
[]
[]
[null,null,"CURRENT & REVISED TARIFF COMPARISON - VARIABLE CONSUMPTION"]
[]
[null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!D8","v":"CONSUMPTION LEVEL"},{"$f":"'Data Capture Demand'!E8&\" (\"&Menu!J4&\")\"","v":"UNITS OF DEMAND (SA RANDS)"},"CURRENT ACTUAL",null,"REVISED TARIFF",null,null,"AFFORDABILITY ADJUSTMENT TO REVISED PRIMARY BASELINE",null,null,null,"Current Actual - Revised","PROFIT\\LOSS"]
[null,null,null,null,null,"TARIFF (Historical)","REVENUE","TARIFF","REVENUE",null,"% CHANGE","TARIFF","REVENUE",null,"TARIFF","REVENUE"]
[null,null,{"$f":"IF('Data Capture Demand'!C10=\"\",\"\",'Data Capture Demand'!C10)","v":"Domestic Low Income Pre-paid"},{"$f":"IF('Data Capture Demand'!D10=\"\",\"\",'Data Capture Demand'!D10)","v":""},{"$f":"'Data Capture Demand'!E10","v":2750000},{"$f":"'Data Capture Demand'!H10","v":0.78},{"$f":"SUM('Data Capture Demand'!G10*F7)","v":1950000},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":0},{"$f":"SUM(E7*H7)","v":0},null,0,{"$f":"SUM(H7*K7%)+H7","v":0},{"$f":"E7*L7","v":0},null,{"$f":"L7-F7","v":-0.78},{"$f":"M7-G7","v":-1950000}]
[null,null,{"$f":"IF('Data Capture Demand'!C11=\"\",\"\",'Data Capture Demand'!C11)","v":"Domestic Low Income Metered"},{"$f":"IF('Data Capture Demand'!D11=\"\",\"\",'Data Capture Demand'!D11)","v":""},{"$f":"'Data Capture Demand'!E11","v":0},{"$f":"'Data Capture Demand'!H11","v":0.72},{"$f":"SUM('Data Capture Demand'!G11*F8)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":0},{"$f":"SUM(E8*H8)","v":0},null,0,{"$f":"SUM(H8*K8%)+H8","v":0},{"$f":"E8*L8","v":0},null,{"$f":"L8-F8","v":-0.72},{"$f":"M8-G8","v":0}]
[null,null,{"$f":"'Data Capture Demand'!C9&\" TOTAL\"","v":"DOMESTIC - LOW INCOME (KwH) TOTAL"},null,{"$f":"SUM(E7:E8)","v":2750000},null,{"$f":"SUM(G7:G8)","v":1950000},null,{"$f":"SUM(I7:I8)","v":0},null,null,null,{"$f":"SUM(M7:M8)","v":0},null,null,{"$f":"SUM(P7:P8)","v":-1950000}]
[null,null,{"$f":"IF('Data Capture Demand'!C15=\"\",\"\",'Data Capture Demand'!C15)","v":"Domestic Pre-Paid Type 1"},{"$f":"IF('Data Capture Demand'!D15=\"\",\"\",'Data Capture Demand'!D15)","v":""},{"$f":"'Data Capture Demand'!E15","v":1650000},{"$f":"'Data Capture Demand'!H15","v":0.78},{"$f":"SUM('Data Capture Demand'!G15*F10)","v":1170000},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":1.037479867505394},{"$f":"SUM(E10*H10)","v":1711841.7813839002},null,0,{"$f":"SUM(H10*K10%)+H10","v":1.037479867505394},1711841.7813839002,null,{"$f":"L10-F10","v":0.25747986750539398},{"$f":"M10-G10","v":541841.7813839002}]
[null,null,{"$f":"IF('Data Capture Demand'!C16=\"\",\"\",'Data Capture Demand'!C16)","v":"Domestic Pre-Paid Type 2"},{"$f":"IF('Data Capture Demand'!D16=\"\",\"\",'Data Capture Demand'!D16)","v":""},{"$f":"'Data Capture Demand'!E16","v":1500000},{"$f":"'Data Capture Demand'!H16","v":0.85},{"$f":"SUM('Data Capture Demand'!G16*F11)","v":1275000},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":1.037479867505394},1556219.8012580911,null,0,1.037479867505394,1556219.8012580911,null,{"$f":"L11-F11","v":0.18747986750539403},{"$f":"M11-G11","v":281219.80125809112}]
[null,null,{"$f":"IF('Data Capture Demand'!C17=\"\",\"\",'Data Capture Demand'!C17)","v":"Domestic Pre-Paid Type 3"},{"$f":"IF('Data Capture Demand'!D17=\"\",\"\",'Data Capture Demand'!D17)","v":""},{"$f":"'Data Capture Demand'!E17","v":0},{"$f":"'Data Capture Demand'!H17","v":0},{"$f":"SUM('Data Capture Demand'!G17*F12)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":1.037479867505394},0,null,0,1.037479867505394,0,null,{"$f":"L12-F12","v":1.037479867505394},0]
[null,null,{"$f":"IF('Data Capture Demand'!C18=\"\",\"\",'Data Capture Demand'!C18)","v":"Domestic Pre-Paid Type 4"},{"$f":"IF('Data Capture Demand'!D18=\"\",\"\",'Data Capture Demand'!D18)","v":""},{"$f":"'Data Capture Demand'!E18","v":0},{"$f":"'Data Capture Demand'!H18","v":0},{"$f":"SUM('Data Capture Demand'!G18*F13)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":1.037479867505394},0,null,0,1.037479867505394,0,null,{"$f":"L13-F13","v":1.037479867505394},0]
[null,null,{"$f":"IF('Data Capture Demand'!C19=\"\",\"\",'Data Capture Demand'!C19)","v":"Domestic Pre-Paid Type 5"},{"$f":"IF('Data Capture Demand'!D19=\"\",\"\",'Data Capture Demand'!D19)","v":""},{"$f":"'Data Capture Demand'!E19","v":0},{"$f":"'Data Capture Demand'!H19","v":0},{"$f":"SUM('Data Capture Demand'!G19*F14)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":1.037479867505394},0,null,0,1.037479867505394,0,null,{"$f":"L14-F14","v":1.037479867505394},0]
[null,null,{"$f":"IF('Data Capture Demand'!C20=\"\",\"\",'Data Capture Demand'!C20)","v":"Domestic Pre-Paid Type 6"},{"$f":"IF('Data Capture Demand'!D20=\"\",\"\",'Data Capture Demand'!D20)","v":""},{"$f":"'Data Capture Demand'!E20","v":0},{"$f":"'Data Capture Demand'!H20","v":0},{"$f":"SUM('Data Capture Demand'!G20*F15)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":1.037479867505394},0,null,0,1.037479867505394,0,null,{"$f":"L15-F15","v":1.037479867505394},0]
[null,null,{"$f":"'Data Capture Demand'!C14&\" TOTAL\"","v":"DOMESTIC - PRE-PAID (KwH) TOTAL"},null,{"$f":"SUM(E10:E15)","v":3150000},null,{"$f":"SUM(G10:G15)","v":2445000},null,{"$f":"SUM(I10:I15)","v":3268061.5826419913},null,null,null,{"$f":"SUM(M10:M15)","v":3268061.5826419913},null,null,{"$f":"SUM(P10:P15)","v":823061.58264199132}]
[null,null,{"$f":"IF('Data Capture Demand'!C24=\"\",\"\",'Data Capture Demand'!C24)","v":"Domestic Metered Single Phase Type 1"},{"$f":"IF('Data Capture Demand'!D24=\"\",\"\",'Data Capture Demand'!D24)","v":""},{"$f":"'Data Capture Demand'!E24","v":1400000},{"$f":"'Data Capture Demand'!H24","v":0.72},{"$f":"SUM('Data Capture Demand'!G24*F17)","v":1080000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":1.1810953182108255},{"$f":"SUM(E17*H17)","v":1653533.4454951556},null,0,{"$f":"SUM(H17*K17%)+H17","v":1.1810953182108255},{"$f":"E17*L17","v":1653533.4454951556},null,{"$f":"L17-F17","v":0.4610953182108255},{"$f":"M17-G17","v":573533.44549515564}]
[null,null,{"$f":"IF('Data Capture Demand'!C25=\"\",\"\",'Data Capture Demand'!C25)","v":"Domestic Metered Single Phase Type 2"},{"$f":"IF('Data Capture Demand'!D25=\"\",\"\",'Data Capture Demand'!D25)","v":""},{"$f":"'Data Capture Demand'!E25","v":1350000},{"$f":"'Data Capture Demand'!H25","v":0.9},{"$f":"SUM('Data Capture Demand'!G25*F18)","v":1350000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":1.1810953182108255},1594478.6795846145,null,0,1.1810953182108255,1594478.6795846145,null,0.28109531821082545,244478.67958461447]
[null,null,{"$f":"IF('Data Capture Demand'!C26=\"\",\"\",'Data Capture Demand'!C26)","v":"Domestic Metered Single Phase Type 3"},{"$f":"IF('Data Capture Demand'!D26=\"\",\"\",'Data Capture Demand'!D26)","v":""},{"$f":"'Data Capture Demand'!E26","v":0},{"$f":"'Data Capture Demand'!H26","v":0},{"$f":"SUM('Data Capture Demand'!G26*F19)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":1.1810953182108255},0,null,0,1.1810953182108255,0,null,1.1810953182108255,0]
[null,null,{"$f":"IF('Data Capture Demand'!C27=\"\",\"\",'Data Capture Demand'!C27)","v":"Domestic Metered Single Phase Type 4"},{"$f":"IF('Data Capture Demand'!D27=\"\",\"\",'Data Capture Demand'!D27)","v":""},{"$f":"'Data Capture Demand'!E27","v":0},{"$f":"'Data Capture Demand'!H27","v":0},{"$f":"SUM('Data Capture Demand'!G27*F20)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":1.1810953182108255},0,null,0,1.1810953182108255,0,null,1.1810953182108255,0]
[null,null,{"$f":"IF('Data Capture Demand'!C28=\"\",\"\",'Data Capture Demand'!C28)","v":"Domestic Metered Single Phase Type 5"},{"$f":"IF('Data Capture Demand'!D28=\"\",\"\",'Data Capture Demand'!D28)","v":""},{"$f":"'Data Capture Demand'!E28","v":0},{"$f":"'Data Capture Demand'!H28","v":0},{"$f":"SUM('Data Capture Demand'!G28*F21)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":1.1810953182108255},0,null,0,1.1810953182108255,0,null,1.1810953182108255,0]
[null,null,{"$f":"IF('Data Capture Demand'!C29=\"\",\"\",'Data Capture Demand'!C29)","v":"Domestic Metered Single Phase Type 6"},{"$f":"IF('Data Capture Demand'!D29=\"\",\"\",'Data Capture Demand'!D29)","v":""},{"$f":"'Data Capture Demand'!E29","v":0},{"$f":"'Data Capture Demand'!H29","v":0},{"$f":"SUM('Data Capture Demand'!G29*F22)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":1.1810953182108255},0,null,0,1.1810953182108255,0,null,1.1810953182108255,0]
[null,null,{"$f":"'Data Capture Demand'!C23&\" TOTAL\"","v":"DOMESTIC - METERED SINGLE PHASE (KwH) TOTAL"},null,{"$f":"SUM(E17:E22)","v":2750000},null,{"$f":"SUM(G17:G22)","v":2430000},null,{"$f":"SUM(I17:I22)","v":3248012.1250797701},null,null,null,{"$f":"SUM(M17:M22)","v":3248012.1250797701},null,null,{"$f":"SUM(P17:P22)","v":818012.12507977011}]
[null,null,{"$f":"IF('Data Capture Demand'!C33=\"\",\"\",'Data Capture Demand'!C33)","v":"Domestic Metered Three Phase Type 1"},{"$f":"IF('Data Capture Demand'!D33=\"\",\"\",'Data Capture Demand'!D33)","v":""},{"$f":"'Data Capture Demand'!E33","v":3300000},{"$f":"'Data Capture Demand'!H33","v":0.75},{"$f":"SUM('Data Capture Demand'!G33*F24)","v":2250000},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1.0552346085379372},{"$f":"SUM(E24*H24)","v":3482274.2081751926},null,0,{"$f":"SUM(H24*K24%)+H24","v":1.0552346085379372},{"$f":"E24*L24","v":3482274.2081751926},null,{"$f":"L24-F24","v":0.30523460853793716},{"$f":"M24-G24","v":1232274.2081751926}]
[null,null,{"$f":"IF('Data Capture Demand'!C34=\"\",\"\",'Data Capture Demand'!C34)","v":"Domestic Metered Three Phase Type 2"},{"$f":"IF('Data Capture Demand'!D34=\"\",\"\",'Data Capture Demand'!D34)","v":""},{"$f":"'Data Capture Demand'!E34","v":5250000},{"$f":"'Data Capture Demand'!H34","v":0.9},{"$f":"SUM('Data Capture Demand'!G34*F25)","v":4500000},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1.0552346085379372},5539981.6948241703,null,0,{"$f":"SUM(H25*K25%)+H25","v":1.0552346085379372},5539981.6948241703,null,0.15523460853793714,1039981.6948241703]
[null,null,{"$f":"IF('Data Capture Demand'!C35=\"\",\"\",'Data Capture Demand'!C35)","v":"Domestic Metered Three Phase Type 3"},{"$f":"IF('Data Capture Demand'!D35=\"\",\"\",'Data Capture Demand'!D35)","v":""},{"$f":"'Data Capture Demand'!E35","v":0},{"$f":"'Data Capture Demand'!H35","v":0},{"$f":"SUM('Data Capture Demand'!G35*F26)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1.0552346085379372},0,null,0,{"$f":"SUM(H26*K26%)+H26","v":1.0552346085379372},0,null,1.0552346085379372,0]
[null,null,{"$f":"IF('Data Capture Demand'!C36=\"\",\"\",'Data Capture Demand'!C36)","v":"Domestic Metered Three Phase Type 4"},{"$f":"IF('Data Capture Demand'!D36=\"\",\"\",'Data Capture Demand'!D36)","v":""},{"$f":"'Data Capture Demand'!E36","v":0},{"$f":"'Data Capture Demand'!H36","v":0},{"$f":"SUM('Data Capture Demand'!G36*F27)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1.0552346085379372},0,null,0,{"$f":"SUM(H27*K27%)+H27","v":1.0552346085379372},0,null,1.0552346085379372,0]
[null,null,{"$f":"IF('Data Capture Demand'!C37=\"\",\"\",'Data Capture Demand'!C37)","v":"Domestic Metered Three Phase Type 5"},{"$f":"IF('Data Capture Demand'!D37=\"\",\"\",'Data Capture Demand'!D37)","v":""},{"$f":"'Data Capture Demand'!E37","v":0},{"$f":"'Data Capture Demand'!H37","v":0},{"$f":"SUM('Data Capture Demand'!G37*F28)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1.0552346085379372},0,null,0,{"$f":"SUM(H28*K28%)+H28","v":1.0552346085379372},0,null,1.0552346085379372,0]
[null,null,{"$f":"IF('Data Capture Demand'!C38=\"\",\"\",'Data Capture Demand'!C38)","v":"Domestic Metered Three Phase Type 6"},{"$f":"IF('Data Capture Demand'!D38=\"\",\"\",'Data Capture Demand'!D38)","v":""},{"$f":"'Data Capture Demand'!E38","v":0},{"$f":"'Data Capture Demand'!H38","v":0},{"$f":"SUM('Data Capture Demand'!G38*F29)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1.0552346085379372},0,null,0,{"$f":"SUM(H29*K29%)+H29","v":1.0552346085379372},0,null,1.0552346085379372,0]
[null,null,{"$f":"'Data Capture Demand'!C32&\" TOTAL\"","v":"DOMESTIC - METERED THREE PHASE (KwH) TOTAL"},null,{"$f":"SUM(E24:E29)","v":8550000},null,{"$f":"SUM(G24:G29)","v":6750000},null,{"$f":"SUM(I24:I29)","v":9022255.9029993638},null,null,null,{"$f":"SUM(M24:M29)","v":9022255.9029993638},null,null,{"$f":"SUM(P24:P29)","v":2272255.9029993629}]
[null,null,{"$f":"IF('Data Capture Demand'!C42=\"\",\"\",'Data Capture Demand'!C42)","v":"Industrial Metered (KwH) Type 1"},{"$f":"IF('Data Capture Demand'!D42=\"\",\"\",'Data Capture Demand'!D42)","v":""},{"$f":"'Data Capture Demand'!E42","v":0},{"$f":"'Data Capture Demand'!H42","v":0},{"$f":"SUM('Data Capture Demand'!G42*F31)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$12","v":0},{"$f":"SUM(E31*H31)","v":0},null,0,{"$f":"SUM(H31*K31%)+H31","v":0},{"$f":"E31*L31","v":0},null,{"$f":"L31-F31","v":0},{"$f":"M31-G31","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C43=\"\",\"\",'Data Capture Demand'!C43)","v":"Industrial Metered (KwH) Type 2"},{"$f":"IF('Data Capture Demand'!D43=\"\",\"\",'Data Capture Demand'!D43)","v":""},{"$f":"'Data Capture Demand'!E43","v":0},{"$f":"'Data Capture Demand'!H43","v":0},{"$f":"SUM('Data Capture Demand'!G43*F32)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$12","v":0},0,null,0,0,0,null,0,0]
[null,null,{"$f":"IF('Data Capture Demand'!C44=\"\",\"\",'Data Capture Demand'!C44)","v":"Industrial Metered (KwH) Type 3"},{"$f":"IF('Data Capture Demand'!D44=\"\",\"\",'Data Capture Demand'!D44)","v":""},{"$f":"'Data Capture Demand'!E44","v":0},{"$f":"'Data Capture Demand'!H44","v":0},{"$f":"SUM('Data Capture Demand'!G44*F33)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$12","v":0},0,null,0,0,0,null,0,0]
[null,null,{"$f":"IF('Data Capture Demand'!C45=\"\",\"\",'Data Capture Demand'!C45)","v":"Industrial Metered (KwH) Type 4"},{"$f":"IF('Data Capture Demand'!D45=\"\",\"\",'Data Capture Demand'!D45)","v":""},{"$f":"'Data Capture Demand'!E45","v":0},{"$f":"'Data Capture Demand'!H45","v":0},{"$f":"SUM('Data Capture Demand'!G45*F34)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$12","v":0},0,null,0,0,0,null,0,0]
[null,null,{"$f":"IF('Data Capture Demand'!C46=\"\",\"\",'Data Capture Demand'!C46)","v":"Industrial Metered (KwH) Type 5"},{"$f":"IF('Data Capture Demand'!D46=\"\",\"\",'Data Capture Demand'!D46)","v":""},{"$f":"'Data Capture Demand'!E46","v":0},{"$f":"'Data Capture Demand'!H46","v":0},{"$f":"SUM('Data Capture Demand'!G46*F35)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$12","v":0},0,null,0,0,0,null,0,0]
[null,null,{"$f":"IF('Data Capture Demand'!C47=\"\",\"\",'Data Capture Demand'!C47)","v":"Industrial Metered (KwH) Type 6"},{"$f":"IF('Data Capture Demand'!D47=\"\",\"\",'Data Capture Demand'!D47)","v":""},{"$f":"'Data Capture Demand'!E47","v":0},{"$f":"'Data Capture Demand'!H47","v":0},{"$f":"SUM('Data Capture Demand'!G47*F36)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$12","v":0},0,null,0,0,0,null,0,0]
[null,null,{"$f":"'Data Capture Demand'!C41&\" TOTAL\"","v":"INDUSTRIAL - METERED (KwH) TOTAL"},null,{"$f":"SUM(E31:E36)","v":0},null,{"$f":"SUM(G31:G36)","v":0},null,{"$f":"SUM(I31:I36)","v":0},null,null,null,{"$f":"SUM(M31:M36)","v":0},null,null,{"$f":"SUM(P31:P36)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C51=\"\",\"\",'Data Capture Demand'!C51)","v":"Industrial Metered (KvA) Type 1"},{"$f":"IF('Data Capture Demand'!D51=\"\",\"\",'Data Capture Demand'!D51)","v":""},{"$f":"'Data Capture Demand'!E51","v":100000},{"$f":"'Data Capture Demand'!H51","v":6},{"$f":"SUM('Data Capture Demand'!G51*F38)","v":600000},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":8.0197830248883211},{"$f":"SUM(E38*H38)","v":801978.30248883215},null,0,{"$f":"SUM(H38*K38%)+H38","v":8.0197830248883211},{"$f":"E38*L38","v":801978.30248883215},null,{"$f":"L38-F38","v":2.0197830248883211},{"$f":"M38-G38","v":201978.30248883215}]
[null,null,{"$f":"IF('Data Capture Demand'!C52=\"\",\"\",'Data Capture Demand'!C52)","v":"Industrial Metered (KvA) Type 2"},{"$f":"IF('Data Capture Demand'!D52=\"\",\"\",'Data Capture Demand'!D52)","v":""},{"$f":"'Data Capture Demand'!E52","v":0},{"$f":"'Data Capture Demand'!H52","v":0},{"$f":"SUM('Data Capture Demand'!G52*F39)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":8.0197830248883211},0,null,0,8.0197830248883211,0,null,{"$f":"L39-F39","v":8.0197830248883211},{"$f":"M39-G39","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C53=\"\",\"\",'Data Capture Demand'!C53)","v":"Industrial Metered (KvA) Type 3"},{"$f":"IF('Data Capture Demand'!D53=\"\",\"\",'Data Capture Demand'!D53)","v":""},{"$f":"'Data Capture Demand'!E53","v":0},{"$f":"'Data Capture Demand'!H53","v":0},{"$f":"SUM('Data Capture Demand'!G53*F40)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":8.0197830248883211},0,null,0,8.0197830248883211,0,null,{"$f":"L40-F40","v":8.0197830248883211},0]
[null,null,{"$f":"IF('Data Capture Demand'!C54=\"\",\"\",'Data Capture Demand'!C54)","v":"Industrial Metered (KvA) Type 4"},{"$f":"IF('Data Capture Demand'!D54=\"\",\"\",'Data Capture Demand'!D54)","v":""},{"$f":"'Data Capture Demand'!E54","v":0},{"$f":"'Data Capture Demand'!H54","v":0},{"$f":"SUM('Data Capture Demand'!G54*F41)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":8.0197830248883211},0,null,0,8.0197830248883211,0,null,{"$f":"L41-F41","v":8.0197830248883211},0]
[null,null,{"$f":"IF('Data Capture Demand'!C55=\"\",\"\",'Data Capture Demand'!C55)","v":"Industrial Metered (KvA) Type 5"},{"$f":"IF('Data Capture Demand'!D55=\"\",\"\",'Data Capture Demand'!D55)","v":""},{"$f":"'Data Capture Demand'!E55","v":0},{"$f":"'Data Capture Demand'!H55","v":0},{"$f":"SUM('Data Capture Demand'!G55*F42)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":8.0197830248883211},0,null,0,8.0197830248883211,0,null,{"$f":"L42-F42","v":8.0197830248883211},0]
[null,null,{"$f":"IF('Data Capture Demand'!C56=\"\",\"\",'Data Capture Demand'!C56)","v":"Industrial Metered (KvA) Type 6"},{"$f":"IF('Data Capture Demand'!D56=\"\",\"\",'Data Capture Demand'!D56)","v":""},{"$f":"'Data Capture Demand'!E56","v":0},{"$f":"'Data Capture Demand'!H56","v":0},{"$f":"SUM('Data Capture Demand'!G56*F43)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":8.0197830248883211},0,null,0,8.0197830248883211,0,null,{"$f":"L43-F43","v":8.0197830248883211},0]
[null,null,{"$f":"'Data Capture Demand'!C50&\" TOTAL\"","v":"INDUSTRIAL - METERED (KvA) TOTAL"},null,{"$f":"SUM(E38:E43)","v":100000},null,{"$f":"SUM(G38:G43)","v":600000},null,{"$f":"SUM(I38:I43)","v":801978.30248883215},null,null,null,{"$f":"SUM(M38:M43)","v":801978.30248883215},null,null,{"$f":"SUM(P38:P43)","v":201978.30248883215}]
[null,null,{"$f":"IF('Data Capture Demand'!C60=\"\",\"\",'Data Capture Demand'!C60)","v":"Commercial Metered (KwH) Type 1"},{"$f":"IF('Data Capture Demand'!D60=\"\",\"\",'Data Capture Demand'!D60)","v":""},{"$f":"'Data Capture Demand'!E60","v":1650000},{"$f":"'Data Capture Demand'!H60","v":0.75},{"$f":"SUM('Data Capture Demand'!G60*F45)","v":1125000},{"$f":"'Revised Primary Baseline Tariff'!$D$14","v":1.0568291852797278},{"$f":"SUM(E45*H45)","v":1743768.155711551},null,0,{"$f":"SUM(H45*K45%)+H45","v":1.0568291852797278},{"$f":"E45*L45","v":1743768.155711551},null,{"$f":"L45-F45","v":0.3068291852797278},{"$f":"M45-G45","v":618768.15571155096}]
[null,null,{"$f":"IF('Data Capture Demand'!C61=\"\",\"\",'Data Capture Demand'!C61)","v":"Commercial Metered (KwH) Type 2"},{"$f":"IF('Data Capture Demand'!D61=\"\",\"\",'Data Capture Demand'!D61)","v":""},{"$f":"'Data Capture Demand'!E61","v":2100000},{"$f":"'Data Capture Demand'!H61","v":0.92},{"$f":"SUM('Data Capture Demand'!G61*F46)","v":1840000},{"$f":"'Revised Primary Baseline Tariff'!$D$14","v":1.0568291852797278},2219341.2890874282,null,0,1.0568291852797278,2219341.2890874282,null,{"$f":"L46-F46","v":0.13682918527972776},{"$f":"M46-G46","v":379341.28908742825}]
[null,null,{"$f":"IF('Data Capture Demand'!C62=\"\",\"\",'Data Capture Demand'!C62)","v":"Commercial Metered (KwH) Type 3"},{"$f":"IF('Data Capture Demand'!D62=\"\",\"\",'Data Capture Demand'!D62)","v":""},{"$f":"'Data Capture Demand'!E62","v":0},{"$f":"'Data Capture Demand'!H62","v":0},{"$f":"SUM('Data Capture Demand'!G62*F47)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$14","v":1.0568291852797278},0,null,0,1.0568291852797278,0,null,{"$f":"L47-F47","v":1.0568291852797278},0]
[null,null,{"$f":"IF('Data Capture Demand'!C63=\"\",\"\",'Data Capture Demand'!C63)","v":"Commercial Metered (KwH) Type 4"},{"$f":"IF('Data Capture Demand'!D63=\"\",\"\",'Data Capture Demand'!D63)","v":""},{"$f":"'Data Capture Demand'!E63","v":0},{"$f":"'Data Capture Demand'!H63","v":0},{"$f":"SUM('Data Capture Demand'!G63*F48)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$14","v":1.0568291852797278},0,null,0,1.0568291852797278,0,null,{"$f":"L48-F48","v":1.0568291852797278},0]
[null,null,{"$f":"IF('Data Capture Demand'!C64=\"\",\"\",'Data Capture Demand'!C64)","v":"Commercial Metered (KwH) Type 5"},{"$f":"IF('Data Capture Demand'!D64=\"\",\"\",'Data Capture Demand'!D64)","v":""},{"$f":"'Data Capture Demand'!E64","v":0},{"$f":"'Data Capture Demand'!H64","v":0},{"$f":"SUM('Data Capture Demand'!G64*F49)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$14","v":1.0568291852797278},0,null,0,1.0568291852797278,0,null,{"$f":"L49-F49","v":1.0568291852797278},0]
[null,null,{"$f":"IF('Data Capture Demand'!C65=\"\",\"\",'Data Capture Demand'!C65)","v":"Commercial Metered (KwH) Type 6"},{"$f":"IF('Data Capture Demand'!D65=\"\",\"\",'Data Capture Demand'!D65)","v":""},{"$f":"'Data Capture Demand'!E65","v":0},{"$f":"'Data Capture Demand'!H65","v":0},{"$f":"SUM('Data Capture Demand'!G65*F50)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$14","v":1.0568291852797278},0,null,0,1.0568291852797278,0,null,{"$f":"L50-F50","v":1.0568291852797278},0]
[null,null,{"$f":"'Data Capture Demand'!C59&\" TOTAL\"","v":"COMMERCIAL - METERED (KwH) TOTAL"},null,{"$f":"SUM(E45:E50)","v":3750000},null,{"$f":"SUM(G45:G50)","v":2965000},null,{"$f":"SUM(I45:I50)","v":3963109.444798979},null,null,null,{"$f":"SUM(M45:M50)","v":3963109.444798979},null,null,{"$f":"SUM(P45:P50)","v":998109.44479897921}]
[null,null,{"$f":"IF('Data Capture Demand'!C69=\"\",\"\",'Data Capture Demand'!C69)","v":"Commercial Metered (KvA) Type 1"},{"$f":"IF('Data Capture Demand'!D69=\"\",\"\",'Data Capture Demand'!D69)","v":""},{"$f":"'Data Capture Demand'!E69","v":0},{"$f":"'Data Capture Demand'!H69","v":0},{"$f":"SUM('Data Capture Demand'!G69*F52)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$15","v":0},{"$f":"SUM(E52*H52)","v":0},null,0,{"$f":"SUM(H52*K52%)+H52","v":0},{"$f":"E52*L52","v":0},null,{"$f":"L52-F52","v":0},{"$f":"M52-G52","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C70=\"\",\"\",'Data Capture Demand'!C70)","v":"Commercial Metered (KvA) Type 2"},{"$f":"IF('Data Capture Demand'!D70=\"\",\"\",'Data Capture Demand'!D70)","v":""},{"$f":"'Data Capture Demand'!E70","v":0},{"$f":"'Data Capture Demand'!H70","v":0},{"$f":"SUM('Data Capture Demand'!G70*F53)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$15","v":0},0,null,0,0,0,null,{"$f":"L53-F53","v":0},{"$f":"M53-G53","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C71=\"\",\"\",'Data Capture Demand'!C71)","v":"Commercial Metered (KvA) Type 3"},{"$f":"IF('Data Capture Demand'!D71=\"\",\"\",'Data Capture Demand'!D71)","v":""},{"$f":"'Data Capture Demand'!E71","v":0},{"$f":"'Data Capture Demand'!H71","v":0},{"$f":"SUM('Data Capture Demand'!G71*F54)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$15","v":0},0,null,0,0,0,null,{"$f":"L54-F54","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C72=\"\",\"\",'Data Capture Demand'!C72)","v":"Commercial Metered (KvA) Type 4"},{"$f":"IF('Data Capture Demand'!D72=\"\",\"\",'Data Capture Demand'!D72)","v":""},{"$f":"'Data Capture Demand'!E72","v":0},{"$f":"'Data Capture Demand'!H72","v":0},{"$f":"SUM('Data Capture Demand'!G72*F55)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$15","v":0},0,null,0,0,0,null,{"$f":"L55-F55","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C73=\"\",\"\",'Data Capture Demand'!C73)","v":"Commercial Metered (KvA) Type 5"},{"$f":"IF('Data Capture Demand'!D73=\"\",\"\",'Data Capture Demand'!D73)","v":""},{"$f":"'Data Capture Demand'!E73","v":0},{"$f":"'Data Capture Demand'!H73","v":0},{"$f":"SUM('Data Capture Demand'!G73*F56)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$15","v":0},0,null,0,0,0,null,{"$f":"L56-F56","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C74=\"\",\"\",'Data Capture Demand'!C74)","v":"Commercial Metered (KvA) Type 6"},{"$f":"IF('Data Capture Demand'!D74=\"\",\"\",'Data Capture Demand'!D74)","v":""},{"$f":"'Data Capture Demand'!E74","v":0},{"$f":"'Data Capture Demand'!H74","v":0},{"$f":"SUM('Data Capture Demand'!G74*F57)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$15","v":0},0,null,0,0,0,null,{"$f":"L57-F57","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C68&\" TOTAL\"","v":"COMMERCIAL - METERED (KvA) TOTAL"},null,{"$f":"SUM(E52:E57)","v":0},null,{"$f":"SUM(G52:G57)","v":0},null,{"$f":"SUM(I52:I57)","v":0},null,null,null,{"$f":"SUM(M52:M57)","v":0},null,null,{"$f":"SUM(P52:P57)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C78=\"\",\"\",'Data Capture Demand'!C78)","v":"Institutional Metered (KwH) Type 1"},{"$f":"IF('Data Capture Demand'!D78=\"\",\"\",'Data Capture Demand'!D78)","v":""},{"$f":"'Data Capture Demand'!E78","v":380000},{"$f":"'Data Capture Demand'!H78","v":0.6},{"$f":"SUM('Data Capture Demand'!G78*F59)","v":240000},{"$f":"'Revised Primary Baseline Tariff'!$D$16","v":0.80197830248883217},{"$f":"SUM(E59*H59)","v":304751.75494575623},null,0,{"$f":"SUM(H59*K59%)+H59","v":0.80197830248883217},{"$f":"E59*L59","v":304751.75494575623},null,{"$f":"L59-F59","v":0.2019783024888322},{"$f":"M59-G59","v":64751.754945756227}]
[null,null,{"$f":"IF('Data Capture Demand'!C79=\"\",\"\",'Data Capture Demand'!C79)","v":"Institutional Metered (KwH) Type 2"},{"$f":"IF('Data Capture Demand'!D79=\"\",\"\",'Data Capture Demand'!D79)","v":""},{"$f":"'Data Capture Demand'!E79","v":420000},{"$f":"'Data Capture Demand'!H79","v":0.6},{"$f":"SUM('Data Capture Demand'!G79*F60)","v":240000},{"$f":"'Revised Primary Baseline Tariff'!$D$16","v":0.80197830248883217},336830.88704530953,null,0,0.80197830248883217,336830.88704530953,null,{"$f":"L60-F60","v":0.2019783024888322},{"$f":"M60-G60","v":96830.88704530953}]
[null,null,{"$f":"IF('Data Capture Demand'!C80=\"\",\"\",'Data Capture Demand'!C80)","v":"Institutional Metered (KwH) Type 3"},{"$f":"IF('Data Capture Demand'!D80=\"\",\"\",'Data Capture Demand'!D80)","v":""},{"$f":"'Data Capture Demand'!E80","v":0},{"$f":"'Data Capture Demand'!H80","v":0},{"$f":"SUM('Data Capture Demand'!G80*F61)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$16","v":0.80197830248883217},0,null,0,0.80197830248883217,0,null,{"$f":"L61-F61","v":0.80197830248883217},0]
[null,null,{"$f":"IF('Data Capture Demand'!C81=\"\",\"\",'Data Capture Demand'!C81)","v":"Institutional Metered (KwH) Type 4"},{"$f":"IF('Data Capture Demand'!D81=\"\",\"\",'Data Capture Demand'!D81)","v":""},{"$f":"'Data Capture Demand'!E81","v":0},{"$f":"'Data Capture Demand'!H81","v":0},{"$f":"SUM('Data Capture Demand'!G81*F62)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$16","v":0.80197830248883217},0,null,0,0.80197830248883217,0,null,{"$f":"L62-F62","v":0.80197830248883217},0]
[null,null,{"$f":"IF('Data Capture Demand'!C82=\"\",\"\",'Data Capture Demand'!C82)","v":"Institutional Metered (KwH) Type 5"},{"$f":"IF('Data Capture Demand'!D82=\"\",\"\",'Data Capture Demand'!D82)","v":""},{"$f":"'Data Capture Demand'!E82","v":0},{"$f":"'Data Capture Demand'!H82","v":0},{"$f":"SUM('Data Capture Demand'!G82*F63)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$16","v":0.80197830248883217},0,null,0,0.80197830248883217,0,null,{"$f":"L63-F63","v":0.80197830248883217},0]
[null,null,{"$f":"IF('Data Capture Demand'!C83=\"\",\"\",'Data Capture Demand'!C83)","v":"Institutional Metered (KwH) Type 6"},{"$f":"IF('Data Capture Demand'!D83=\"\",\"\",'Data Capture Demand'!D83)","v":""},{"$f":"'Data Capture Demand'!E83","v":0},{"$f":"'Data Capture Demand'!H83","v":0},{"$f":"SUM('Data Capture Demand'!G83*F64)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$16","v":0.80197830248883217},0,null,0,0.80197830248883217,0,null,{"$f":"L64-F64","v":0.80197830248883217},0]
[null,null,{"$f":"'Data Capture Demand'!C77&\" TOTAL\"","v":"INSTITUTIONAL - METERED (KwH) TOTAL"},null,{"$f":"SUM(E59:E64)","v":800000},null,{"$f":"SUM(G59:G64)","v":480000},null,{"$f":"SUM(I59:I64)","v":641582.64199106582},null,null,null,{"$f":"SUM(M59:M64)","v":641582.64199106582},null,null,{"$f":"SUM(P59:P64)","v":161582.64199106576}]
[null,null,{"$f":"IF('Data Capture Demand'!C87=\"\",\"\",'Data Capture Demand'!C87)","v":"Time of Use Type 1"},{"$f":"IF('Data Capture Demand'!D87=\"\",\"\",'Data Capture Demand'!D87)","v":""},{"$f":"'Data Capture Demand'!E87","v":0},{"$f":"'Data Capture Demand'!H87","v":0},{"$f":"SUM('Data Capture Demand'!G87*F66)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$17","v":0},{"$f":"SUM(E66*H66)","v":0},null,0,{"$f":"SUM(H66*K66%)+H66","v":0},{"$f":"E66*L66","v":0},null,{"$f":"L66-F66","v":0},{"$f":"M66-G66","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C88=\"\",\"\",'Data Capture Demand'!C88)","v":"Time of Use Type 2"},{"$f":"IF('Data Capture Demand'!D88=\"\",\"\",'Data Capture Demand'!D88)","v":""},{"$f":"'Data Capture Demand'!E88","v":0},{"$f":"'Data Capture Demand'!H88","v":0},{"$f":"SUM('Data Capture Demand'!G88*F67)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$17","v":0},0,null,0,0,0,null,{"$f":"L67-F67","v":0},{"$f":"M67-G67","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C89=\"\",\"\",'Data Capture Demand'!C89)","v":"Time of Use Type 3"},{"$f":"IF('Data Capture Demand'!D89=\"\",\"\",'Data Capture Demand'!D89)","v":""},{"$f":"'Data Capture Demand'!E89","v":0},{"$f":"'Data Capture Demand'!H89","v":0},{"$f":"SUM('Data Capture Demand'!G89*F68)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$17","v":0},0,null,0,0,0,null,{"$f":"L68-F68","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C90=\"\",\"\",'Data Capture Demand'!C90)","v":"Time of Use Type 4"},{"$f":"IF('Data Capture Demand'!D90=\"\",\"\",'Data Capture Demand'!D90)","v":""},{"$f":"'Data Capture Demand'!E90","v":0},{"$f":"'Data Capture Demand'!H90","v":0},{"$f":"SUM('Data Capture Demand'!G90*F69)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$17","v":0},0,null,0,0,0,null,{"$f":"L69-F69","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C91=\"\",\"\",'Data Capture Demand'!C91)","v":"Time of Use Type 5"},{"$f":"IF('Data Capture Demand'!D91=\"\",\"\",'Data Capture Demand'!D91)","v":""},{"$f":"'Data Capture Demand'!E91","v":0},{"$f":"'Data Capture Demand'!H91","v":0},{"$f":"SUM('Data Capture Demand'!G91*F70)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$17","v":0},0,null,0,0,0,null,{"$f":"L70-F70","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C92=\"\",\"\",'Data Capture Demand'!C92)","v":"Time of Use Type 6"},{"$f":"IF('Data Capture Demand'!D92=\"\",\"\",'Data Capture Demand'!D92)","v":""},{"$f":"'Data Capture Demand'!E92","v":0},{"$f":"'Data Capture Demand'!H92","v":0},{"$f":"SUM('Data Capture Demand'!G92*F71)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$17","v":0},0,null,0,0,0,null,{"$f":"L71-F71","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C86&\" TOTAL\"","v":"TIME OF USE TOTAL"},null,{"$f":"SUM(E66:E71)","v":0},null,{"$f":"SUM(G66:G71)","v":0},null,{"$f":"SUM(I66:I71)","v":0},null,null,null,{"$f":"SUM(M66:M71)","v":0},null,null,{"$f":"SUM(P66:P71)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C96=\"\",\"\",'Data Capture Demand'!C96)","v":"Type V Type 1"},{"$f":"IF('Data Capture Demand'!D96=\"\",\"\",'Data Capture Demand'!D96)","v":""},{"$f":"'Data Capture Demand'!E96","v":0},{"$f":"'Data Capture Demand'!H96","v":0},{"$f":"SUM('Data Capture Demand'!G96*F73)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$18","v":0},{"$f":"SUM(E73*H73)","v":0},null,0,{"$f":"SUM(H73*K73%)+H73","v":0},{"$f":"E73*L73","v":0},null,{"$f":"L73-F73","v":0},{"$f":"M73-G73","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C97=\"\",\"\",'Data Capture Demand'!C97)","v":"Type V Type 2"},{"$f":"IF('Data Capture Demand'!D97=\"\",\"\",'Data Capture Demand'!D97)","v":""},{"$f":"'Data Capture Demand'!E97","v":0},{"$f":"'Data Capture Demand'!H97","v":0},{"$f":"SUM('Data Capture Demand'!G97*F74)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$18","v":0},0,null,0,0,0,null,{"$f":"L74-F74","v":0},{"$f":"M74-G74","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C98=\"\",\"\",'Data Capture Demand'!C98)","v":"Type V Type 3"},{"$f":"IF('Data Capture Demand'!D98=\"\",\"\",'Data Capture Demand'!D98)","v":""},{"$f":"'Data Capture Demand'!E98","v":0},{"$f":"'Data Capture Demand'!H98","v":0},{"$f":"SUM('Data Capture Demand'!G98*F75)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$18","v":0},0,null,0,0,0,null,{"$f":"L75-F75","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C99=\"\",\"\",'Data Capture Demand'!C99)","v":"Type V Type 4"},{"$f":"IF('Data Capture Demand'!D99=\"\",\"\",'Data Capture Demand'!D99)","v":""},{"$f":"'Data Capture Demand'!E99","v":0},{"$f":"'Data Capture Demand'!H99","v":0},{"$f":"SUM('Data Capture Demand'!G99*F76)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$18","v":0},0,null,0,0,0,null,{"$f":"L76-F76","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C100=\"\",\"\",'Data Capture Demand'!C100)","v":"Type V Type 5"},{"$f":"IF('Data Capture Demand'!D100=\"\",\"\",'Data Capture Demand'!D100)","v":""},{"$f":"'Data Capture Demand'!E100","v":0},{"$f":"'Data Capture Demand'!H100","v":0},{"$f":"SUM('Data Capture Demand'!G100*F77)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$18","v":0},0,null,0,0,0,null,{"$f":"L77-F77","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C101=\"\",\"\",'Data Capture Demand'!C101)","v":"Type V Type 6"},{"$f":"IF('Data Capture Demand'!D101=\"\",\"\",'Data Capture Demand'!D101)","v":""},{"$f":"'Data Capture Demand'!E101","v":0},{"$f":"'Data Capture Demand'!H101","v":0},{"$f":"SUM('Data Capture Demand'!G101*F78)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$18","v":0},0,null,0,0,0,null,{"$f":"L78-F78","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C95&\" TOTAL\"","v":"TYPE V TOTAL"},null,{"$f":"SUM(E73:E78)","v":0},null,{"$f":"SUM(G73:G78)","v":0},null,{"$f":"SUM(I73:I78)","v":0},null,null,null,{"$f":"SUM(M73:M78)","v":0},null,null,{"$f":"SUM(P73:P78)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C105=\"\",\"\",'Data Capture Demand'!C105)","v":"Type X Type 1"},{"$f":"IF('Data Capture Demand'!D105=\"\",\"\",'Data Capture Demand'!D85)","v":""},{"$f":"'Data Capture Demand'!E105","v":0},{"$f":"'Data Capture Demand'!H105","v":0},{"$f":"SUM('Data Capture Demand'!G105*F80)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$19","v":0},{"$f":"SUM(E80*H80)","v":0},null,0,{"$f":"SUM(H80*K80%)+H80","v":0},{"$f":"E80*L80","v":0},null,{"$f":"L80-F80","v":0},{"$f":"M80-G80","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C106=\"\",\"\",'Data Capture Demand'!C106)","v":"Type X Type 2"},{"$f":"IF('Data Capture Demand'!D106=\"\",\"\",'Data Capture Demand'!D86)","v":""},{"$f":"'Data Capture Demand'!E106","v":0},{"$f":"'Data Capture Demand'!H106","v":0},{"$f":"SUM('Data Capture Demand'!G106*F81)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$19","v":0},0,null,0,0,0,null,{"$f":"L81-F81","v":0},{"$f":"M81-G81","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C107=\"\",\"\",'Data Capture Demand'!C107)","v":"Type X Type 3"},{"$f":"IF('Data Capture Demand'!D107=\"\",\"\",'Data Capture Demand'!D87)","v":""},{"$f":"'Data Capture Demand'!E107","v":0},{"$f":"'Data Capture Demand'!H107","v":0},{"$f":"SUM('Data Capture Demand'!G107*F82)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$19","v":0},0,null,0,0,0,null,{"$f":"L82-F82","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C108=\"\",\"\",'Data Capture Demand'!C108)","v":"Type X Type 4"},{"$f":"IF('Data Capture Demand'!D108=\"\",\"\",'Data Capture Demand'!D88)","v":""},{"$f":"'Data Capture Demand'!E108","v":0},{"$f":"'Data Capture Demand'!H108","v":0},{"$f":"SUM('Data Capture Demand'!G108*F83)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$19","v":0},0,null,0,0,0,null,{"$f":"L83-F83","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C109=\"\",\"\",'Data Capture Demand'!C109)","v":"Type X Type 5"},{"$f":"IF('Data Capture Demand'!D109=\"\",\"\",'Data Capture Demand'!D89)","v":""},{"$f":"'Data Capture Demand'!E109","v":0},{"$f":"'Data Capture Demand'!H109","v":0},{"$f":"SUM('Data Capture Demand'!G109*F84)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$19","v":0},0,null,0,0,0,null,{"$f":"L84-F84","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C110=\"\",\"\",'Data Capture Demand'!C110)","v":"Type X Type 6"},{"$f":"IF('Data Capture Demand'!D110=\"\",\"\",'Data Capture Demand'!D90)","v":""},{"$f":"'Data Capture Demand'!E110","v":0},{"$f":"'Data Capture Demand'!H110","v":0},{"$f":"SUM('Data Capture Demand'!G110*F85)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$19","v":0},0,null,0,0,0,null,{"$f":"L85-F85","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C104&\" TOTAL\"","v":"TYPE X TOTAL"},null,{"$f":"SUM(E80:E85)","v":0},null,{"$f":"SUM(G80:G85)","v":0},null,{"$f":"SUM(I80:I85)","v":0},null,null,null,{"$f":"SUM(M80:M85)","v":0},null,null,{"$f":"SUM(P80:P85)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C114=\"\",\"\",'Data Capture Demand'!C114)","v":"Type Y Type 1"},{"$f":"IF('Data Capture Demand'!D114=\"\",\"\",'Data Capture Demand'!D114)","v":""},{"$f":"'Data Capture Demand'!E114","v":0},{"$f":"'Data Capture Demand'!H114","v":0},{"$f":"SUM('Data Capture Demand'!G114*F87)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$20","v":0},{"$f":"SUM(E87*H87)","v":0},null,0,{"$f":"SUM(H87*K87%)+H87","v":0},{"$f":"E87*L87","v":0},null,{"$f":"L87-F87","v":0},{"$f":"M87-G87","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C115=\"\",\"\",'Data Capture Demand'!C115)","v":"Type Y Type 2"},{"$f":"IF('Data Capture Demand'!D115=\"\",\"\",'Data Capture Demand'!D115)","v":""},{"$f":"'Data Capture Demand'!E115","v":0},{"$f":"'Data Capture Demand'!H115","v":0},{"$f":"SUM('Data Capture Demand'!G115*F88)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$20","v":0},0,null,0,0,0,null,{"$f":"L88-F88","v":0},{"$f":"M88-G88","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C116=\"\",\"\",'Data Capture Demand'!C116)","v":"Type Y Type 3"},{"$f":"IF('Data Capture Demand'!D116=\"\",\"\",'Data Capture Demand'!D116)","v":""},{"$f":"'Data Capture Demand'!E116","v":0},{"$f":"'Data Capture Demand'!H116","v":0},{"$f":"SUM('Data Capture Demand'!G116*F89)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$20","v":0},0,null,0,0,0,null,{"$f":"L89-F89","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C117=\"\",\"\",'Data Capture Demand'!C117)","v":"Type Y Type 4"},{"$f":"IF('Data Capture Demand'!D117=\"\",\"\",'Data Capture Demand'!D117)","v":""},{"$f":"'Data Capture Demand'!E117","v":0},{"$f":"'Data Capture Demand'!H117","v":0},{"$f":"SUM('Data Capture Demand'!G117*F90)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$20","v":0},0,null,0,0,0,null,{"$f":"L90-F90","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C118=\"\",\"\",'Data Capture Demand'!C118)","v":"Type Y Type 5"},{"$f":"IF('Data Capture Demand'!D118=\"\",\"\",'Data Capture Demand'!D118)","v":""},{"$f":"'Data Capture Demand'!E118","v":0},{"$f":"'Data Capture Demand'!H118","v":0},{"$f":"SUM('Data Capture Demand'!G118*F91)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$20","v":0},0,null,0,0,0,null,{"$f":"L91-F91","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C119=\"\",\"\",'Data Capture Demand'!C119)","v":"Type Y Type 6"},{"$f":"IF('Data Capture Demand'!D119=\"\",\"\",'Data Capture Demand'!D119)","v":""},{"$f":"'Data Capture Demand'!E119","v":0},{"$f":"'Data Capture Demand'!H119","v":0},{"$f":"SUM('Data Capture Demand'!G119*F92)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$20","v":0},0,null,0,0,0,null,{"$f":"L92-F92","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C113&\" TOTAL\"","v":"TYPE Y TOTAL"},null,{"$f":"SUM(E87:E92)","v":0},null,{"$f":"SUM(G87:G92)","v":0},null,{"$f":"SUM(I87:I92)","v":0},null,null,null,{"$f":"SUM(M87:M92)","v":0},null,null,{"$f":"SUM(P87:P92)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C123=\"\",\"\",'Data Capture Demand'!C123)","v":"Type Z Type 1"},{"$f":"IF('Data Capture Demand'!D123=\"\",\"\",'Data Capture Demand'!D123)","v":""},{"$f":"'Data Capture Demand'!E123","v":0},{"$f":"'Data Capture Demand'!H123","v":0},{"$f":"SUM('Data Capture Demand'!G123*F94)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$21","v":0},{"$f":"SUM(E94*H94)","v":0},null,0,{"$f":"SUM(H94*K94%)+H94","v":0},{"$f":"E94*L94","v":0},null,{"$f":"L94-F94","v":0},{"$f":"M94-G94","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C124=\"\",\"\",'Data Capture Demand'!C124)","v":"Type Z Type 2"},{"$f":"IF('Data Capture Demand'!D124=\"\",\"\",'Data Capture Demand'!D124)","v":""},{"$f":"'Data Capture Demand'!E124","v":0},{"$f":"'Data Capture Demand'!H124","v":0},{"$f":"SUM('Data Capture Demand'!G124*F95)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$21","v":0},0,null,0,0,0,null,{"$f":"L95-F95","v":0},{"$f":"M95-G95","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C125=\"\",\"\",'Data Capture Demand'!C125)","v":"Type Z Type 3"},{"$f":"IF('Data Capture Demand'!D125=\"\",\"\",'Data Capture Demand'!D125)","v":""},{"$f":"'Data Capture Demand'!E125","v":0},{"$f":"'Data Capture Demand'!H125","v":0},{"$f":"SUM('Data Capture Demand'!G125*F96)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$21","v":0},0,null,0,0,0,null,{"$f":"L96-F96","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C126=\"\",\"\",'Data Capture Demand'!C126)","v":"Type Z Type 4"},{"$f":"IF('Data Capture Demand'!D126=\"\",\"\",'Data Capture Demand'!D126)","v":""},{"$f":"'Data Capture Demand'!E126","v":0},{"$f":"'Data Capture Demand'!H126","v":0},{"$f":"SUM('Data Capture Demand'!G126*F97)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$21","v":0},0,null,0,0,0,null,{"$f":"L97-F97","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C127=\"\",\"\",'Data Capture Demand'!C127)","v":"Type Z Type 5"},{"$f":"IF('Data Capture Demand'!D127=\"\",\"\",'Data Capture Demand'!D127)","v":""},{"$f":"'Data Capture Demand'!E127","v":0},{"$f":"'Data Capture Demand'!H127","v":0},{"$f":"SUM('Data Capture Demand'!G127*F98)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$21","v":0},0,null,0,0,0,null,{"$f":"L98-F98","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C128=\"\",\"\",'Data Capture Demand'!C128)","v":"Type Z Type 6"},{"$f":"IF('Data Capture Demand'!D128=\"\",\"\",'Data Capture Demand'!D128)","v":""},{"$f":"'Data Capture Demand'!E128","v":0},{"$f":"'Data Capture Demand'!H128","v":0},{"$f":"SUM('Data Capture Demand'!G128*F99)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$21","v":0},0,null,0,0,0,null,{"$f":"L99-F99","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C122&\" TOTAL\"","v":"TYPE Z TOTAL"},null,{"$f":"SUM(E94:E99)","v":0},null,{"$f":"SUM(G94:G99)","v":0},null,{"$f":"SUM(I94:I99)","v":0},null,null,null,{"$f":"SUM(M94:M99)","v":0},null,null,{"$f":"SUM(P94:P99)","v":0}]
[]
[null,null,"TOTAL VARIABLE CONSUMPTION",null,{"$f":"SUM(E16+E23+E30+E37+E44+E51+E58+E65+E72+E79+E86+E93+E100)","v":19100000},null,{"$f":"SUM(G16+G23+G30+G37+G44+G51+G58+G65+G72+G79+G86+G93+G100)","v":15670000},null,{"$f":"SUM(I16+I23+I30+I37+I44+I51+I58+I65+I72+I79+I86+I93+I100)","v":20945000},null,null,null,{"$f":"SUM(M16+M23+M30+M37+M44+M51+M58+M65+M72+M79+M86+M93+M100)","v":20945000},null,null,{"$f":"SUM(P16+P23+P30+P37+P44+P51+P58+P65+P72+P79+P86+P93+P100)","v":5275000.0000000019}]
[]
[null,null,"FULL VARIABLE COST",null,{"$f":"SUM('Data Capture Costs'!D6)","v":20945000},"CURRENT ACTUAL (PER YEAR)",null,null,null,null,null,"ANTICIPATED (PER YEAR)"]
[null,null,null,null,null,"Current Revenue",{"$f":"G102","v":15670000},null,null,null,null,"Revised Revenue",{"$f":"M102","v":20945000}]
[null,null,null,null,null,"PROFIT\\LOSS",{"$f":"G105-E104","v":-5275000},null,null,null,null,"PROFIT\\LOSS",{"$f":"M105-E104","v":0}]

{"sheet":"Test Afford of Fixed Tariff","index":10,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,6,32,7],[2,2,2,15],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,4,8],[4,10,4,12],[32,11,32,12]]}
[]
[]
[null,null,"CURRENT & REVISED TARIFF COMPARISON - FIXED FACILITY PER YEAR"]
[]
[null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!D8","v":"CONSUMPTION LEVEL"},{"$f":"'Data Capture Demand'!E8&\" (\"&Menu!J4&\")\"","v":"UNITS OF DEMAND (SA RANDS)"},"CURRENT ACTUAL",null,"REVISED TARIFF",null,null,"AFFORDABILITY ADJUSTMENT  TO REVISED PRIMARY BASELINE",null,null,null,"Current Actual - Revised","PROFIT\\LOSS"]
[null,null,null,null,null,"TARIFF","REVENUE","TARIFF","REVENUE",null,"% CHANGE","TARIFF","REVENUE",null,"TARIFF","REVENUE"]
[null,null,{"$f":"IF('Data Capture Users'!C10=\"\",\"\",'Data Capture Users'!C10)","v":"Domestic Low Income Pre-paid"},null,{"$f":"'Data Capture Users'!D10","v":2200},{"$f":"'Data Capture Users'!G10","v":0},{"$f":"'Data Capture Users'!F10*F7","v":0},0,{"$f":"SUM(E7*H7)","v":0},null,0,{"$f":"SUM(H7*K7%)+H7","v":0},{"$f":"E7*L7","v":0},null,{"$f":"L7-F7","v":0},{"$f":"M7-G7","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C11=\"\",\"\",'Data Capture Users'!C11)","v":"Domestic Low Income Metered"},null,{"$f":"'Data Capture Users'!D11","v":0},{"$f":"'Data Capture Users'!G11","v":600},{"$f":"'Data Capture Users'!F11*F8","v":0},0,{"$f":"SUM(E8*H8)","v":0},null,0,{"$f":"SUM(H8*K8%)+H8","v":0},{"$f":"E8*L8","v":0},null,{"$f":"L8-F8","v":-600},{"$f":"M8-G8","v":0}]
[null,null,{"$f":"'Data Capture Users'!C9&\" TOTAL\"","v":"DOMESTIC - LOW INCOME (KwH) TOTAL"},null,{"$f":"SUM(E7:E8)","v":2200},null,{"$f":"SUM(G7:G8)","v":0},null,{"$f":"SUM(I7:I8)","v":0},null,null,null,{"$f":"SUM(M7:M8)","v":0},null,null,{"$f":"SUM(P7:P8)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C15=\"\",\"\",'Data Capture Users'!C15)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D15","v":0},{"$f":"'Data Capture Users'!G15","v":0},{"$f":"'Data Capture Users'!F15*F10","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E10*H10)","v":0},null,0,{"$f":"SUM(H10*K10%)+H10","v":736.81818181818187},{"$f":"E10*L10","v":0},null,{"$f":"L10-F10","v":736.81818181818187},0]
[null,null,{"$f":"IF('Data Capture Users'!C16=\"\",\"\",'Data Capture Users'!C16)","v":"Basic Fees for Occupied Stands"},null,{"$f":"'Data Capture Users'!D16","v":0},{"$f":"'Data Capture Users'!G16","v":0},{"$f":"'Data Capture Users'!F16*F11","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E11*H11)","v":0},null,0,{"$f":"SUM(H11*K11%)+H11","v":736.81818181818187},{"$f":"E11*L11","v":0},null,{"$f":"L11-F11","v":736.81818181818187},0]
[null,null,{"$f":"IF('Data Capture Users'!C17=\"\",\"\",'Data Capture Users'!C17)","v":""},null,{"$f":"'Data Capture Users'!D17","v":0},{"$f":"'Data Capture Users'!G17","v":0},{"$f":"'Data Capture Users'!F17*F12","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E12*H12)","v":0},null,0,{"$f":"SUM(H12*K12%)+H12","v":736.81818181818187},{"$f":"E12*L12","v":0},null,{"$f":"L12-F12","v":736.81818181818187},0]
[null,null,{"$f":"'Data Capture Users'!C14&\" TOTAL\"","v":"DOMESTIC - PRE-PAID (KwH) TOTAL"},null,{"$f":"SUM(E10:E12)","v":0},null,{"$f":"SUM(G10:G12)","v":0},null,{"$f":"SUM(I10:I12)","v":0},null,null,null,{"$f":"SUM(M10:M12)","v":0},null,null,{"$f":"SUM(P10:P12)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C21=\"\",\"\",'Data Capture Users'!C21)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D21","v":900},{"$f":"'Data Capture Users'!G21","v":600},{"$f":"'Data Capture Users'!F21*F14","v":600000},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E14*H14)","v":663136.36363636365},null,0,{"$f":"SUM(H14*K14%)+H14","v":736.81818181818187},{"$f":"E14*L14","v":663136.36363636365},null,{"$f":"L14-F14","v":136.81818181818187},{"$f":"M14-G14","v":63136.363636363647}]
[null,null,{"$f":"IF('Data Capture Users'!C22=\"\",\"\",'Data Capture Users'!C22)","v":"Basic Fees for Occupied Stands"},null,{"$f":"'Data Capture Users'!D22","v":10100},{"$f":"'Data Capture Users'!G22","v":600},{"$f":"'Data Capture Users'!F22*F15","v":6000000},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E15*H15)","v":7441863.6363636367},null,0,{"$f":"SUM(H15*K15%)+H15","v":736.81818181818187},{"$f":"E15*L15","v":7441863.6363636367},null,{"$f":"L15-F15","v":136.81818181818187},1441863.6363636367]
[null,null,{"$f":"IF('Data Capture Users'!C23=\"\",\"\",'Data Capture Users'!C23)","v":""},null,{"$f":"'Data Capture Users'!D23","v":0},{"$f":"'Data Capture Users'!G23","v":0},{"$f":"'Data Capture Users'!F23*F16","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E16*H16)","v":0},null,0,{"$f":"SUM(H16*K16%)+H16","v":736.81818181818187},{"$f":"E16*L16","v":0},null,{"$f":"L16-F16","v":736.81818181818187},0]
[null,null,{"$f":"'Data Capture Users'!C20&\" TOTAL\"","v":"DOMESTIC - METERED SINGLE & THREE PHASE (KwH) TOTAL"},null,{"$f":"SUM(E14:E16)","v":11000},null,{"$f":"SUM(G14:G16)","v":6600000},null,{"$f":"SUM(I14:I16)","v":8105000},null,null,null,{"$f":"SUM(M14:M16)","v":8105000},null,null,{"$f":"SUM(P14:P16)","v":1505000.0000000005}]
[null,null,{"$f":"IF('Data Capture Users'!C27=\"\",\"\",'Data Capture Users'!C27)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D27","v":0},{"$f":"'Data Capture Users'!G27","v":0},{"$f":"'Data Capture Users'!F27*F18","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E18*H18)","v":0},null,0,{"$f":"SUM(H18*K18%)+H18","v":736.81818181818187},{"$f":"E18*L18","v":0},null,{"$f":"L18-F18","v":736.81818181818187},{"$f":"M18-G18","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C28=\"\",\"\",'Data Capture Users'!C28)","v":"Basic Fees for Occupied Stands"},null,{"$f":"'Data Capture Users'!D28","v":0},{"$f":"'Data Capture Users'!G28","v":0},{"$f":"'Data Capture Users'!F28*F19","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E19*H19)","v":0},null,0,{"$f":"SUM(H19*K19%)+H19","v":736.81818181818187},{"$f":"E19*L19","v":0},null,{"$f":"L19-F19","v":736.81818181818187},0]
[null,null,{"$f":"IF('Data Capture Users'!C29=\"\",\"\",'Data Capture Users'!C29)","v":""},null,{"$f":"'Data Capture Users'!D29","v":0},{"$f":"'Data Capture Users'!G29","v":0},{"$f":"'Data Capture Users'!F29*F20","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E20*H20)","v":0},null,0,{"$f":"SUM(H20*K20%)+H20","v":736.81818181818187},{"$f":"E20*L20","v":0},null,{"$f":"L20-F20","v":736.81818181818187},0]
[null,null,{"$f":"'Data Capture Users'!C26&\" TOTAL\"","v":"INDUSTRIAL TOTAL"},null,{"$f":"SUM(E18:E20)","v":0},null,{"$f":"SUM(G18:G20)","v":0},null,{"$f":"SUM(I18:I20)","v":0},null,null,null,{"$f":"SUM(M18:M20)","v":0},null,null,{"$f":"SUM(P18:P20)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C33=\"\",\"\",'Data Capture Users'!C33)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D33","v":0},{"$f":"'Data Capture Users'!G33","v":0},{"$f":"'Data Capture Users'!F33*F22","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E22*H22)","v":0},null,0,{"$f":"SUM(H22*K22%)+H22","v":736.81818181818187},{"$f":"E22*L22","v":0},null,{"$f":"L22-F22","v":736.81818181818187},{"$f":"M22-G22","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C34=\"\",\"\",'Data Capture Users'!C34)","v":"Basic Fees for Occupied Stands"},null,{"$f":"'Data Capture Users'!D34","v":0},{"$f":"'Data Capture Users'!G34","v":0},{"$f":"'Data Capture Users'!F34*F23","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E23*H23)","v":0},null,0,{"$f":"SUM(H23*K23%)+H23","v":736.81818181818187},{"$f":"E23*L23","v":0},null,{"$f":"L23-F23","v":736.81818181818187},0]
[null,null,{"$f":"IF('Data Capture Users'!C35=\"\",\"\",'Data Capture Users'!C35)","v":""},null,{"$f":"'Data Capture Users'!D35","v":0},{"$f":"'Data Capture Users'!G35","v":0},{"$f":"'Data Capture Users'!F35*F24","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E24*H24)","v":0},null,0,{"$f":"SUM(H24*K24%)+H24","v":736.81818181818187},{"$f":"E24*L24","v":0},null,{"$f":"L24-F24","v":736.81818181818187},0]
[null,null,{"$f":"'Data Capture Users'!C32&\" TOTAL\"","v":"COMMERCIAL TOTAL"},null,{"$f":"SUM(E22:E24)","v":0},null,{"$f":"SUM(G22:G24)","v":0},null,{"$f":"SUM(I22:I24)","v":0},null,null,null,{"$f":"SUM(M22:M24)","v":0},null,null,{"$f":"SUM(P22:P24)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C39=\"\",\"\",'Data Capture Users'!C39)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D39","v":0},{"$f":"'Data Capture Users'!G39","v":0},{"$f":"'Data Capture Users'!F39*F26","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E26*H26)","v":0},null,0,{"$f":"SUM(H26*K26%)+H26","v":736.81818181818187},{"$f":"E26*L26","v":0},null,{"$f":"L26-F26","v":736.81818181818187},{"$f":"M26-G26","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C40=\"\",\"\",'Data Capture Users'!C40)","v":"Basic Fees for Occupied Stands"},null,{"$f":"'Data Capture Users'!D40","v":0},{"$f":"'Data Capture Users'!G40","v":0},{"$f":"'Data Capture Users'!F40*F27","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E27*H27)","v":0},null,0,{"$f":"SUM(H27*K27%)+H27","v":736.81818181818187},{"$f":"E27*L27","v":0},null,{"$f":"L27-F27","v":736.81818181818187},0]
[null,null,{"$f":"IF('Data Capture Users'!C41=\"\",\"\",'Data Capture Users'!C41)","v":""},null,{"$f":"'Data Capture Users'!D41","v":0},{"$f":"'Data Capture Users'!G41","v":0},{"$f":"'Data Capture Users'!F41*F28","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$26","v":736.81818181818187},{"$f":"SUM(E28*H28)","v":0},null,0,{"$f":"SUM(H28*K28%)+H28","v":736.81818181818187},{"$f":"E28*L28","v":0},null,{"$f":"L28-F28","v":736.81818181818187},0]
[null,null,{"$f":"'Data Capture Users'!C38&\" TOTAL\"","v":"INSTITUTIONAL TOTAL"},null,{"$f":"SUM(E26:E28)","v":0},null,{"$f":"SUM(G26:G28)","v":0},null,{"$f":"SUM(I26:I28)","v":0},null,null,null,{"$f":"SUM(M26:M28)","v":0},null,null,{"$f":"SUM(P26:P28)","v":0}]
[]
[null,null,"TOTAL FIXED CONSUMPTION",null,{"$f":"SUM(E13+E17+E21+E25+E29)","v":11000},null,{"$f":"SUM(G13+G17+G21+G25+G29)","v":6600000},null,{"$f":"SUM(I13+I17+I21+I25+I29)","v":8105000},null,null,null,{"$f":"SUM(M13+M17+M21+M25+M29)","v":8105000},null,null,{"$f":"SUM(P13+P17+P21+P25+P29)","v":1505000.0000000005}]
[]
[null,null,"FULL FIXED COST",{"$f":"SUM('Data Capture Costs'!D7)","v":8105000},{"$f":"SUM('Data Capture Costs'!D7)","v":8105000},null,"CURRENT ACTUAL (PER YEAR)",null,null,null,null,"ANTICIPATED (PER YEAR)"]
[null,null,null,null,null,null,"Current Revenue",{"$f":"G31","v":6600000},null,null,null,"Revised Revenue",{"$f":"M31","v":8105000}]
[null,null,null,null,null,null,"PROFIT\\LOSS",{"$f":"H34-E33","v":-1505000},null,null,null,"PROFIT\\LOSS",{"$f":"M34-E33","v":0}]

{"sheet":"Summary of Tariff Comparison","index":11,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,5,11,6],[11,11,11,12],[2,2,2,15],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,4,8],[4,10,4,12]]}
[]
[]
[null,null,"SUMMARY: VARIABLE & FIXED PROFIT AND LOSS PER YEAR"]
[]
[null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!D8","v":"CONSUMPTION LEVEL"},{"$f":"'Data Capture Demand'!E8&\" (\"&Menu!J4&\")\"","v":"UNITS OF DEMAND (SA RANDS)"},"CURRENT ACTUAL",null,"REVISED TARIFF",null,null,"AFFORDABILITY ADJUSTMENT  TO REVISED PRIMARY BASELINE",null,null,null,"Current Actual - Revised","PROFIT\\LOSS"]
[null,null,null,null,null,"TARIFF","REVENUE","TARIFF","REVENUE",null,"% CHANGE","TARIFF","REVENUE",null,"TARIFF","REVENUE"]
[]
[null,null,"TOTAL VARIABLE CONSUMPTION",null,{"$f":"'Test Afford of Variable Tariff'!E102","v":19100000},null,{"$f":"'Test Afford of Variable Tariff'!G102","v":15670000},null,{"$f":"'Test Afford of Variable Tariff'!I102","v":20945000},null,null,null,{"$f":"'Test Afford of Variable Tariff'!M102","v":20945000},null,null,{"$f":"'Test Afford of Variable Tariff'!P102","v":5275000.0000000019}]
[]
[null,null,"TOTAL FIXED CONSUMPTION",null,{"$f":"'Test Afford of Fixed Tariff'!E31","v":11000},null,{"$f":"'Test Afford of Fixed Tariff'!G31","v":6600000},null,{"$f":"'Test Afford of Fixed Tariff'!I31","v":8105000},null,null,null,{"$f":"'Test Afford of Fixed Tariff'!M31","v":8105000},null,null,{"$f":"'Test Afford of Fixed Tariff'!P31","v":1505000.0000000005}]
[]
[null,null,"FULL COST",null,{"$f":"SUM('Data Capture Costs'!D8)","v":29050000},"CURRENT ACTUAL (PER YEAR)",null,null,null,null,null,"ANTICIPATED (PER YEAR)"]
[null,null,null,null,null,"Current Revenue",{"$f":"G8+G10","v":22270000},null,null,null,null,"Revised Revenue",{"$f":"M8+M10","v":29050000}]
[null,null,null,null,null,"PROFIT\\LOSS",{"$f":"G13-E12","v":-6780000},null,null,null,null,"PROFIT\\LOSS",{"$f":"M13-E12","v":0}]