{"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 Comparisons"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":12,"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,"WATER"]
[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":85,"n_cols":6,"rows_kept":85,"cut":false,"hidden":false,"merged":[[67,2,67,7],[2,2,2,7],[47,2,47,7],[52,2,53,2],[56,2,57,2],[7,2,7,7],[22,2,22,7],[38,2,38,7],[14,5,14,7],[28,5,28,7],[44,5,44,7]]}
[]
[]
[null,null,"WATER - 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,"KL Water Demand - ","Estimated Demand in KL for the upcoming year for each Consumption Level."]
[null,null,"KL Water Consumption - ","Actual Water Consumption in KL  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"]
[]
[]
[]
[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,null,"The Primary baseline is calculated and then displayed on this screen."]
[]
[]
[null,null,"Tariff per KL Water Consuption","       Total Variable Costs         "]
[null,null,null,"Total Kl Water Demand"]
[]
[]
[null,null,"Fixed Tariff for Water Supply","  Total Fixed Facility Costs  "]
[null,null,null,"Total Number of Users"]
[]
[null,null,null,"The Adjusted Primary Baseline ONLY applies to South Africa.  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":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[4,6,4,7],[6,6,6,7],[6,2,6,4],[2,2,2,7],[4,2,4,4]]}
[]
[]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: DEMAND PER YEAR\"","v":"WATER - DATA CAPTURE: DEMAND PER YEAR"}]
[]
[null,null,"FUTURE DEMAND",null,null,null,"HISTORICAL DEMAND"]
[]
[null,null,{"$f":"\"Financial Year:\"&\" \"&Menu!$J$5&\"\\\"&Menu!$J$5+1","v":"Financial Year: 2011\\2012"},null,null,null,{"$f":"Menu!$J$5-1&\"\\\"&Menu!$J$5","v":"2010\\2011"}]
[null,null,"CONSUMER","CONSUMPTION LEVEL","KL WATER DEMAND",null,"KL WATER CONSUMPTION","CURRENT ACTUAL TARIFF per KL"]
[null,null,"DOMESTIC (LOW INCOME)"]
[null,null,"Domestic (Free Basic Water) Consumption","Consumption 0KL to 6KL",490000,null,450000,{"$f":"H14","v":5}]
[null,null,"Consumption Total",null,{"$f":"SUM(E6:E10)","v":490000},null,{"$f":"SUM(G10)","v":450000}]
[]
[null,null,"DOMESTIC"]
[null,null,"Consumption 7KL to 15KL","Consumption 7KL to 15KL",450000,null,400000,5]
[null,null,"Consumption 16KL to 30KL","Consumption 16KL to 30KL",350000,null,350000,8]
[null,null,"Domestic Consumption Type 3","Consumption 31KL to 40KL",175000,null,200000,15]
[null,null,"Domestic Consumption Type 4","Consumption above 40KL",0,null,0,0]
[null,null,"Domestic Consumption Type 5",null,0,null,0,0]
[null,null,"Domestic Consumption Type 6",null,0,null,0,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E14:E19)","v":975000},null,{"$f":"SUM(G14:G19)","v":950000}]
[]
[null,null,"INDUSTRIAL"]
[null,null,"Industrial Consumption Type 1","Consumption 0KL to 1,000KL",250000,null,250000,7]
[null,null,"Industrial Consumption Type 2","Consumption 1,001KL to 5,000KL",120000,null,150000,10]
[null,null,"Industrial Consumption Type 3","Consumption 5,001KL to 100,000KL",0,null,0,0]
[null,null,"Industrial Consumption Type 4","Consumption 100,001KL to 150,000KL",0,null,0,0]
[null,null,"Industrial Consumption Type 5","Consumption 150,001KL to 300,000KL",0,null,0,0]
[null,null,"Industrial Consumption Type 6","Consumption 300,001KL to 600,000KL",0,null,0,0]
[null,null,"Industrial Consumption Type 7","Consumption above 600,000KL",0,null,0,0]
[null,null,"Industrial Consumption Type 8",null,0,null,0,0]
[null,null,"Industrial Consumption Type 9",null,0,null,0,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E23:E31)","v":370000},null,{"$f":"SUM(G23:G31)","v":400000}]
[]
[null,null,"COMMERCIAL"]
[null,null,"Commercial Consumption Type 1","Consumption 0KL to 30KL",150000,null,150000,8]
[null,null,"Commercial Consumption Type 2","Consumption 31KL to 40KL",120000,null,125000,15]
[null,null,"Commercial Consumption Type 3","Consumption above 40KL",0,null,0,0]
[null,null,"Commercial Consumption Type 4",null,0,null,0,0]
[null,null,"Commercial Consumption Type 5",null,0,null,0,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E35:E39)","v":270000},null,{"$f":"SUM(G35:G39)","v":275000}]
[]
[null,null,"INSTITUTIONAL"]
[null,null,"Municipal Purposes",null,17000,null,16000,5]
[null,null,"Sports Clubs and Schools Type 1"," Consumption 1KL to 500KL",0,null,0,0]
[null,null,"Sports Clubs and Schools Type 2"," Consumption above 501KL",0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Other",null,0,null,0,0]
[null,null,"Consumption Total",null,{"$f":"SUM(E43:E52)","v":17000},null,{"$f":"SUM(G43:G52)","v":16000}]
[]
[null,null,"TOTAL KL WATER DEMAND",null,{"$f":"SUM(E11+E20+E32+E40+E53)","v":2122000},null,{"$f":"SUM(G11+G20+G32+G40+G53)","v":2091000}]

{"sheet":"Data Capture Users","index":3,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,2,6,3],[6,5,6,6],[4,5,4,6],[2,2,2,6]]}
[]
[]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: USERS PER YEAR\"","v":"WATER - DATA CAPTURE: USERS PER YEAR"}]
[]
[null,null,"FUTURE NUMBER OF USERS",null,null,"HISTORICAL USERS"]
[]
[null,null,{"$f":"\"Financial Year:\"&\" \"&Menu!$J$5&\"\\\"&Menu!$J$5+1","v":"Financial Year: 2011\\2012"},null,null,{"$f":"Menu!$J$5-1&\"\\\"&Menu!$J$5","v":"2010\\2011"}]
[null,null,"CONSUMER","NO OF STANDS",null,"NO OF STANDS","CURRENT ACTUAL TARIFF per Stand per Year"]
[null,null,"DOMESTIC (LOW INCOME)"]
[null,null,"Domestic (Free Basic Water) Consumers",2200,null,2000,{"$f":"G15","v":480}]
[null,null,"Stand Total",{"$f":"SUM(D10)","v":2200},null,{"$f":"SUM(F10)","v":2000}]
[]
[null,null,"DOMESTIC"]
[null,null,"Availablility Fees for Vacant Stands",900,null,1000,480]
[null,null,"Basic Fees from Number of Domestic Consumers",10100,null,10000,480]
[null,null,null,0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D14:D16)","v":11000},null,{"$f":"SUM(F14:F16)","v":11000}]
[]
[null,null,"INDUSTRIAL"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0]
[null,null,"Basic Fees",0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D20:D21)","v":0},null,{"$f":"SUM(F20:F21)","v":0}]
[]
[null,null,"COMMERCIAL"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0]
[null,null,"Basic Fees",0,null,0,0]
[null,null,null,0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D25:D27)","v":0},null,{"$f":"SUM(F25:F27)","v":0}]
[]
[null,null,"INSTITUTIONAL"]
[null,null,"Availablility Fees for Vacant Stands",0,null,0,0]
[null,null,"Basic Fees",0,null,0,0]
[null,null,"Stand Total",{"$f":"SUM(D31:D32)","v":0},null,{"$f":"SUM(F31:F32)","v":0}]
[]
[null,null,"TOTAL NUMBER OF STANDS",{"$f":"SUM(D11+D17+D22+D28+D33)","v":13200},null,{"$f":"SUM(F11+F17+F22+F28+F33)","v":13000}]

{"sheet":"Data Capture Costs","index":4,"n_rows":101,"n_cols":53,"rows_kept":101,"cut":false,"hidden":false,"merged":[[9,5,10,5],[9,6,10,6],[2,2,2,6],[9,3,9,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"WATER - 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":13970000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":3479999.9999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":17450000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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",8500000,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",5500000,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",1500000,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",750000,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",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.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",500000,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.2]
[null,null,"Depreciation:",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.21]
[null,null,"External Interest:",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.22]
[null,null,"Reserves\\Provisions for Capital Improvements:",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.23]
[null,null,"Other Costs:",null,250000,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.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,450000,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":17450000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":17450000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":13,"n_cols":4,"rows_kept":13,"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. This is a tariff that is the same for all consumers. Note: Water has a fixed and a variable component."]
[]
[null,null,"DETAIL","AMT"]
[null,null,{"$f":"'Data Capture Costs'!C6","v":"TOTAL VARIABLE COSTS"},{"$f":"'Data Capture Costs'!$D$6","v":13970000}]
[null,null,{"$f":"'Data Capture Demand'!C55","v":"TOTAL KL WATER DEMAND"},{"$f":"'Data Capture Demand'!E55","v":2122000}]
[null,null,"Tariff per KL Water Consumption ",{"$f":"IF(D8=0,0,D8/D9)","v":6.5834118755890669}]
[null,null,{"$f":"'Data Capture Costs'!C7","v":"TOTAL FIXED FACILITY COSTS"},{"$f":"'Data Capture Costs'!$D$7","v":3479999.9999999995}]
[null,null,{"$f":"'Data Capture Users'!C35","v":"TOTAL NUMBER OF STANDS"},{"$f":"'Data Capture Users'!D35","v":13200}]
[null,null,"Fixed Tariff for Water Supply ",{"$f":"IF(D11=0,0,D11/D12)","v":263.63636363636363}]

{"sheet":"Adj Primary Baseline Tariff","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,9,2,10],[8,9,8,10],[2,2,2,3],[4,2,4,3],[2,7,2,8],[8,7,8,8]]}
[]
[]
[null,null,"ADJUSTED PRIMARY BASELINE TARIFF",null,null,null,null,"COST TO FREE BASIC WATER",null,{"$f":"Menu!$J$4","v":"SA RANDS"}]
[null,null,null,null,null,null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!E8","v":"KL WATER DEMAND"},"REVENUE","FREE BASIC WATER COST"]
[null,null,"Adjusted Primary Baseline Tariff after costing Free Basic Water.",null,null,null,null,{"$f":"C9","v":"OTHER CONSUMPTION"},{"$f":"SUM('Data Capture Demand'!$E$20+'Data Capture Demand'!$E$32+'Data Capture Demand'!$E$40+'Data Capture Demand'!$E$53)","v":1632000},{"$f":"'Data Capture Costs'!D6","v":13970000},0]
[null,null,null,null,null,null,null,{"$f":"'Data Capture Demand'!C10","v":"Domestic (Free Basic Water) Consumption"},{"$f":"'Data Capture Demand'!E11","v":490000},0,{"$f":"I6*'Primary Baseline Tariff'!D10","v":3225871.8190386426}]
[null,null,"DETAIL","AMT",null,null,null,{"$f":"'Data Capture Demand'!C55","v":"TOTAL KL WATER DEMAND"},{"$f":"'Data Capture Demand'!E55","v":2122000},{"$f":"SUM(J5:J6)","v":13970000},{"$f":"SUM(K5:K6)","v":3225871.8190386426}]
[null,null,{"$f":"'Primary Baseline Tariff'!C8","v":"TOTAL VARIABLE COSTS"},{"$f":"'Data Capture Costs'!$D$6","v":13970000}]
[null,null,"OTHER CONSUMPTION",{"$f":"SUM('Data Capture Demand'!$E$20+'Data Capture Demand'!$E$32+'Data Capture Demand'!$E$40+'Data Capture Demand'!$E$53)","v":1632000},null,null,null,"FIXED AVAILABILITY FEES",null,{"$f":"Menu!$J$4","v":"SA RANDS"}]
[null,null,{"$f":"'Primary Baseline Tariff'!C10","v":"Tariff per KL Water Consumption "},{"$f":"IF(D8=0,0,D8/D9)","v":8.5600490196078436},null,null,null,{"$f":"'Data Capture Users'!C8","v":"CONSUMER"},{"$f":"'Data Capture Users'!D8","v":"NO OF STANDS"},"REVENUE","FREE BASIC WATER COST"]
[null,null,{"$f":"'Primary Baseline Tariff'!C11","v":"TOTAL FIXED FACILITY COSTS"},{"$f":"'Data Capture Costs'!$D$7","v":3479999.9999999995},null,null,null,{"$f":"C12","v":"OTHER CONSUMERS"},{"$f":"'Data Capture Users'!$D$17+'Data Capture Users'!$D$22+'Data Capture Users'!$D$28+'Data Capture Users'!$D$33","v":11000},{"$f":"I11*D13","v":3479999.9999999995},0]
[null,null,"OTHER CONSUMERS",{"$f":"'Data Capture Users'!$D$17+'Data Capture Users'!$D$22+'Data Capture Users'!$D$28+'Data Capture Users'!$D$33","v":11000},null,null,null,{"$f":"'Data Capture Users'!C10","v":"Domestic (Free Basic Water) Consumers"},{"$f":"'Data Capture Users'!D11","v":2200},0,{"$f":"I12*'Primary Baseline Tariff'!D13","v":580000}]
[null,null,{"$f":"'Primary Baseline Tariff'!C13","v":"Fixed Tariff for Water Supply "},{"$f":"IF(D11=0,0,D11/D12)","v":316.36363636363632},null,null,null,{"$f":"'Data Capture Users'!C35","v":"TOTAL NUMBER OF STANDS"},{"$f":"'Data Capture Users'!D35","v":13200},{"$f":"SUM(J11:J12)","v":3479999.9999999995},{"$f":"SUM(K11:K12)","v":580000}]

{"sheet":"Strategic Decisions","index":7,"n_rows":24,"n_cols":56,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,9,6,9],[2,2,2,5],[12,9,14,9],[14,2,14,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"REVISED PRIMARY BASELINE TARIFF"]
[null,1,"Do you wish to achieve a Surplus on this service?","YES"]
[null,null,null,"NO"]
[null,null,"Enter Size of the Surplus",0,10,{"$f":"E8%*'Data Capture Costs'!D6","v":1397000},null,null,null,{"$f":"'Revised Primary Baseline Tariff'!D10","v":9.4160539215686274}]
[]
[null,2,"Are you willing to make a Deficit on this service?","YES"]
[null,null,null,"NO"]
[null,null,"Enter Size of the Deficit",0,0,{"$f":"-(E12%)*'Data Capture Costs'!D6","v":0}]
[null,null,null,null,null,null,null,null,null,"CHANGES TO VARIABLE COSTS"]
[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,null,1,{"$f":"D8+F8","v":1397000}]
[null,null,null,"NO",null,null,null,null,2,{"$f":"D12+F12","v":0}]
[null,null,"Enter Size of Subsidy",0,0,{"$f":"E18%*'Data Capture Costs'!D6","v":0},null,null,3,{"$f":"D18+F18","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,null,null,{"$f":"J16-J17+J18","v":1397000}]
[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":13,"n_cols":4,"rows_kept":13,"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,"DETAIL","AMT"]
[null,null,{"$f":"'Adj Primary Baseline Tariff'!C8","v":"TOTAL VARIABLE COSTS"},{"$f":"'Adj Primary Baseline Tariff'!D8+'Strategic Decisions'!J20","v":15367000}]
[null,null,{"$f":"'Adj Primary Baseline Tariff'!C9","v":"OTHER CONSUMPTION"},{"$f":"'Adj Primary Baseline Tariff'!$D$9","v":1632000}]
[null,null,{"$f":"'Primary Baseline Tariff'!C10","v":"Tariff per KL Water Consumption "},{"$f":"IF(D$8=0,0,D8/D$9)","v":9.4160539215686274}]
[null,null,{"$f":"'Adj Primary Baseline Tariff'!C11","v":"TOTAL FIXED FACILITY COSTS"},{"$f":"'Adj Primary Baseline Tariff'!D11","v":3479999.9999999995}]
[null,null,{"$f":"'Adj Primary Baseline Tariff'!C12","v":"OTHER CONSUMERS"},{"$f":"'Adj Primary Baseline Tariff'!D12","v":11000}]
[null,null,{"$f":"'Primary Baseline Tariff'!C13","v":"Fixed Tariff for Water Supply "},{"$f":"IF(D11=0,0,D11/D12)","v":316.36363636363632}]

{"sheet":"Test Afford of Variable Tariff","index":9,"n_rows":60,"n_cols":16,"rows_kept":60,"cut":false,"hidden":false,"merged":[[45,5,45,6],[45,11,45,12],[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]]}
[]
[]
[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":"KL WATER 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 Demand'!C10=\"\",\"\",'Data Capture Demand'!C10)","v":"Domestic (Free Basic Water) Consumption"},{"$f":"IF('Data Capture Demand'!D10=\"\",\"\",'Data Capture Demand'!D10)","v":"Consumption 0KL to 6KL"},{"$f":"'Data Capture Demand'!E10","v":490000},0,{"$f":"SUM('Data Capture Demand'!G10*F7)","v":0},0,{"$f":"SUM(E7*H7)","v":0},0,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":"'Data Capture Demand'!C9&\" TOTAL\"","v":"DOMESTIC (LOW INCOME) TOTAL"},null,{"$f":"SUM(E7)","v":490000},null,{"$f":"SUM(G7)","v":0},null,{"$f":"SUM(I7)","v":0},null,0,null,{"$f":"SUM(M7)","v":0},null,null,{"$f":"SUM(P7)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C14=\"\",\"\",'Data Capture Demand'!C14)","v":"Consumption 7KL to 15KL"},{"$f":"IF('Data Capture Demand'!D14=\"\",\"\",'Data Capture Demand'!D14)","v":"Consumption 7KL to 15KL"},{"$f":"'Data Capture Demand'!E14","v":450000},{"$f":"'Data Capture Demand'!H14","v":5},{"$f":"SUM('Data Capture Demand'!G14*F9)","v":2000000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},{"$f":"SUM(E9*H9)","v":4237224.2647058824},0,0,{"$f":"SUM(H9*K9%)+H9","v":9.4160539215686274},{"$f":"E9*L9","v":4237224.2647058824},null,{"$f":"L9-F9","v":4.4160539215686274},{"$f":"M9-G9","v":2237224.2647058824}]
[null,null,{"$f":"IF('Data Capture Demand'!C15=\"\",\"\",'Data Capture Demand'!C15)","v":"Consumption 16KL to 30KL"},{"$f":"IF('Data Capture Demand'!D15=\"\",\"\",'Data Capture Demand'!D15)","v":"Consumption 16KL to 30KL"},{"$f":"'Data Capture Demand'!E15","v":350000},{"$f":"'Data Capture Demand'!H15","v":8},{"$f":"SUM('Data Capture Demand'!G15*F10)","v":2800000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},3295618.8725490198,0,0,9.4160539215686274,3295618.8725490198,null,{"$f":"L10-F10","v":1.4160539215686274},{"$f":"M10-G10","v":495618.87254901975}]
[null,null,{"$f":"IF('Data Capture Demand'!C16=\"\",\"\",'Data Capture Demand'!C16)","v":"Domestic Consumption Type 3"},{"$f":"IF('Data Capture Demand'!D16=\"\",\"\",'Data Capture Demand'!D16)","v":"Consumption 31KL to 40KL"},{"$f":"'Data Capture Demand'!E16","v":175000},{"$f":"'Data Capture Demand'!H16","v":15},{"$f":"SUM('Data Capture Demand'!G16*F11)","v":3000000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},1647809.4362745099,0,0,9.4160539215686274,1647809.4362745099,null,{"$f":"L11-F11","v":-5.5839460784313726},-1352190.5637254901]
[null,null,{"$f":"IF('Data Capture Demand'!C17=\"\",\"\",'Data Capture Demand'!C17)","v":"Domestic Consumption Type 4"},{"$f":"IF('Data Capture Demand'!D17=\"\",\"\",'Data Capture Demand'!D17)","v":"Consumption above 40KL"},{"$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$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,{"$f":"L12-F12","v":9.4160539215686274},0]
[null,null,{"$f":"IF('Data Capture Demand'!C18=\"\",\"\",'Data Capture Demand'!C18)","v":"Domestic Consumption Type 5"},{"$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$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,{"$f":"L13-F13","v":9.4160539215686274},0]
[null,null,{"$f":"IF('Data Capture Demand'!C19=\"\",\"\",'Data Capture Demand'!C19)","v":"Domestic Consumption Type 6"},{"$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$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,{"$f":"L14-F14","v":9.4160539215686274},0]
[null,null,{"$f":"'Data Capture Demand'!C13&\" TOTAL\"","v":"DOMESTIC TOTAL"},null,{"$f":"SUM(E9:E14)","v":975000},null,{"$f":"SUM(G9:G14)","v":7800000},null,{"$f":"SUM(I9:I14)","v":9180652.5735294111},null,null,null,{"$f":"SUM(M9:M14)","v":9180652.5735294111},null,null,{"$f":"SUM(P9:P14)","v":1380652.573529412}]
[null,null,{"$f":"IF('Data Capture Demand'!C23=\"\",\"\",'Data Capture Demand'!C23)","v":"Industrial Consumption Type 1"},{"$f":"IF('Data Capture Demand'!D23=\"\",\"\",'Data Capture Demand'!D23)","v":"Consumption 0KL to 1,000KL"},{"$f":"'Data Capture Demand'!E23","v":250000},{"$f":"'Data Capture Demand'!H23","v":7},{"$f":"SUM('Data Capture Demand'!G23*F16)","v":1750000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},{"$f":"SUM(E16*H16)","v":2354013.4803921566},0,0,{"$f":"SUM(H16*K16%)+H16","v":9.4160539215686274},{"$f":"E16*L16","v":2354013.4803921566},null,{"$f":"L16-F16","v":2.4160539215686274},{"$f":"M16-G16","v":604013.48039215663}]
[null,null,{"$f":"IF('Data Capture Demand'!C24=\"\",\"\",'Data Capture Demand'!C24)","v":"Industrial Consumption Type 2"},{"$f":"IF('Data Capture Demand'!D24=\"\",\"\",'Data Capture Demand'!D24)","v":"Consumption 1,001KL to 5,000KL"},{"$f":"'Data Capture Demand'!E24","v":120000},{"$f":"'Data Capture Demand'!H24","v":10},{"$f":"SUM('Data Capture Demand'!G24*F17)","v":1500000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},1129926.4705882352,0,0,9.4160539215686274,1129926.4705882352,null,-0.58394607843137258,-370073.52941176482]
[null,null,{"$f":"IF('Data Capture Demand'!C25=\"\",\"\",'Data Capture Demand'!C25)","v":"Industrial Consumption Type 3"},{"$f":"IF('Data Capture Demand'!D25=\"\",\"\",'Data Capture Demand'!D25)","v":"Consumption 5,001KL to 100,000KL"},{"$f":"'Data Capture Demand'!E25","v":0},{"$f":"'Data Capture Demand'!H25","v":0},{"$f":"SUM('Data Capture Demand'!G25*F18)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C26=\"\",\"\",'Data Capture Demand'!C26)","v":"Industrial Consumption Type 4"},{"$f":"IF('Data Capture Demand'!D26=\"\",\"\",'Data Capture Demand'!D26)","v":"Consumption 100,001KL to 150,000KL"},{"$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":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C27=\"\",\"\",'Data Capture Demand'!C27)","v":"Industrial Consumption Type 5"},{"$f":"IF('Data Capture Demand'!D27=\"\",\"\",'Data Capture Demand'!D27)","v":"Consumption 150,001KL to 300,000KL"},{"$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":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C28=\"\",\"\",'Data Capture Demand'!C28)","v":"Industrial Consumption Type 6"},{"$f":"IF('Data Capture Demand'!D28=\"\",\"\",'Data Capture Demand'!D28)","v":"Consumption 300,001KL to 600,000KL"},{"$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":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C29=\"\",\"\",'Data Capture Demand'!C29)","v":"Industrial Consumption Type 7"},{"$f":"IF('Data Capture Demand'!D29=\"\",\"\",'Data Capture Demand'!D29)","v":"Consumption above 600,000KL"},{"$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":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C30=\"\",\"\",'Data Capture Demand'!C30)","v":"Industrial Consumption Type 8"},{"$f":"IF('Data Capture Demand'!D30=\"\",\"\",'Data Capture Demand'!D30)","v":""},{"$f":"'Data Capture Demand'!E30","v":0},{"$f":"'Data Capture Demand'!H30","v":0},{"$f":"SUM('Data Capture Demand'!G30*F23)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C31=\"\",\"\",'Data Capture Demand'!C31)","v":"Industrial Consumption Type 9"},{"$f":"IF('Data Capture Demand'!D31=\"\",\"\",'Data Capture Demand'!D31)","v":""},{"$f":"'Data Capture Demand'!E31","v":0},{"$f":"'Data Capture Demand'!H31","v":0},{"$f":"SUM('Data Capture Demand'!G31*F24)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"'Data Capture Demand'!C22&\" TOTAL\"","v":"INDUSTRIAL TOTAL"},null,{"$f":"SUM(E16:E24)","v":370000},null,{"$f":"SUM(G16:G24)","v":3250000},null,{"$f":"SUM(I16:I24)","v":3483939.9509803918},null,null,null,{"$f":"SUM(M16:M24)","v":3483939.9509803918},null,null,{"$f":"SUM(P16:P24)","v":233939.95098039182}]
[null,null,{"$f":"IF('Data Capture Demand'!C35=\"\",\"\",'Data Capture Demand'!C35)","v":"Commercial Consumption Type 1"},{"$f":"IF('Data Capture Demand'!D35=\"\",\"\",'Data Capture Demand'!D35)","v":"Consumption 0KL to 30KL"},{"$f":"'Data Capture Demand'!E35","v":150000},{"$f":"'Data Capture Demand'!H35","v":8},{"$f":"SUM('Data Capture Demand'!G35*F26)","v":1200000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},{"$f":"SUM(E26*H26)","v":1412408.0882352942},0,0,{"$f":"SUM(H26*K26%)+H26","v":9.4160539215686274},{"$f":"E26*L26","v":1412408.0882352942},null,{"$f":"L26-F26","v":1.4160539215686274},{"$f":"M26-G26","v":212408.08823529421}]
[null,null,{"$f":"IF('Data Capture Demand'!C36=\"\",\"\",'Data Capture Demand'!C36)","v":"Commercial Consumption Type 2"},{"$f":"IF('Data Capture Demand'!D36=\"\",\"\",'Data Capture Demand'!D36)","v":"Consumption 31KL to 40KL"},{"$f":"'Data Capture Demand'!E36","v":120000},{"$f":"'Data Capture Demand'!H36","v":15},{"$f":"SUM('Data Capture Demand'!G36*F27)","v":1875000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},{"$f":"SUM(E27*H27)","v":1129926.4705882352},0,0,{"$f":"SUM(H27*K27%)+H27","v":9.4160539215686274},{"$f":"E27*L27","v":1129926.4705882352},null,{"$f":"L27-F27","v":-5.5839460784313726},-745073.52941176482]
[null,null,{"$f":"IF('Data Capture Demand'!C37=\"\",\"\",'Data Capture Demand'!C37)","v":"Commercial Consumption Type 3"},{"$f":"IF('Data Capture Demand'!D37=\"\",\"\",'Data Capture Demand'!D37)","v":"Consumption above 40KL"},{"$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$10","v":9.4160539215686274},{"$f":"SUM(E28*H28)","v":0},0,0,{"$f":"SUM(H28*K28%)+H28","v":9.4160539215686274},{"$f":"E28*L28","v":0},null,{"$f":"L28-F28","v":9.4160539215686274},0]
[null,null,{"$f":"IF('Data Capture Demand'!C38=\"\",\"\",'Data Capture Demand'!C38)","v":"Commercial Consumption Type 4"},{"$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$10","v":9.4160539215686274},{"$f":"SUM(E29*H29)","v":0},0,0,{"$f":"SUM(H29*K29%)+H29","v":9.4160539215686274},{"$f":"E29*L29","v":0},null,{"$f":"L29-F29","v":9.4160539215686274},0]
[null,null,{"$f":"IF('Data Capture Demand'!C39=\"\",\"\",'Data Capture Demand'!C39)","v":"Commercial Consumption Type 5"},{"$f":"IF('Data Capture Demand'!D39=\"\",\"\",'Data Capture Demand'!D39)","v":""},{"$f":"'Data Capture Demand'!E39","v":0},{"$f":"'Data Capture Demand'!H39","v":0},{"$f":"SUM('Data Capture Demand'!G39*F30)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},{"$f":"SUM(E30*H30)","v":0},0,0,{"$f":"SUM(H30*K30%)+H30","v":9.4160539215686274},{"$f":"E30*L30","v":0},null,{"$f":"L30-F30","v":9.4160539215686274},0]
[null,null,{"$f":"'Data Capture Demand'!C34&\" TOTAL\"","v":"COMMERCIAL TOTAL"},null,{"$f":"SUM(E26:E30)","v":270000},null,{"$f":"SUM(G26:G30)","v":3075000},null,{"$f":"SUM(I26:I30)","v":2542334.5588235296},null,null,null,{"$f":"SUM(M26:M30)","v":2542334.5588235296},null,null,{"$f":"SUM(P26:P30)","v":-532665.4411764706}]
[null,null,{"$f":"IF('Data Capture Demand'!C43=\"\",\"\",'Data Capture Demand'!C43)","v":"Municipal Purposes"},{"$f":"IF('Data Capture Demand'!D43=\"\",\"\",'Data Capture Demand'!D43)","v":""},{"$f":"'Data Capture Demand'!E43","v":17000},{"$f":"'Data Capture Demand'!H43","v":5},{"$f":"SUM('Data Capture Demand'!G43*F32)","v":80000},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},{"$f":"SUM(E32*H32)","v":160072.91666666666},0,0,{"$f":"SUM(H32*K32%)+H32","v":9.4160539215686274},{"$f":"E32*L32","v":160072.91666666666},null,{"$f":"L32-F32","v":4.4160539215686274},{"$f":"M32-G32","v":80072.916666666657}]
[null,null,{"$f":"IF('Data Capture Demand'!C44=\"\",\"\",'Data Capture Demand'!C44)","v":"Sports Clubs and Schools Type 1"},{"$f":"IF('Data Capture Demand'!D44=\"\",\"\",'Data Capture Demand'!D44)","v":" Consumption 1KL to 500KL"},{"$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$10","v":9.4160539215686274},0,0,0,{"$f":"SUM(H33*K33%)+H33","v":9.4160539215686274},0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C45=\"\",\"\",'Data Capture Demand'!C45)","v":"Sports Clubs and Schools Type 2"},{"$f":"IF('Data Capture Demand'!D45=\"\",\"\",'Data Capture Demand'!D45)","v":" Consumption above 501KL"},{"$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$10","v":9.4160539215686274},0,0,0,{"$f":"SUM(H34*K34%)+H34","v":9.4160539215686274},0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C46=\"\",\"\",'Data Capture Demand'!C46)","v":"Other"},{"$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$10","v":9.4160539215686274},0,0,0,{"$f":"SUM(H35*K35%)+H35","v":9.4160539215686274},0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C47=\"\",\"\",'Data Capture Demand'!C47)","v":"Other"},{"$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$10","v":9.4160539215686274},0,null,0,{"$f":"SUM(H36*K36%)+H36","v":9.4160539215686274},0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C48=\"\",\"\",'Data Capture Demand'!C48)","v":"Other"},{"$f":"IF('Data Capture Demand'!D48=\"\",\"\",'Data Capture Demand'!D48)","v":""},{"$f":"'Data Capture Demand'!E48","v":0},{"$f":"'Data Capture Demand'!H48","v":0},{"$f":"SUM('Data Capture Demand'!G48*F37)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,{"$f":"SUM(H37*K37%)+H37","v":9.4160539215686274},0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C49=\"\",\"\",'Data Capture Demand'!C49)","v":"Other"},{"$f":"IF('Data Capture Demand'!D49=\"\",\"\",'Data Capture Demand'!D49)","v":""},{"$f":"'Data Capture Demand'!E49","v":0},{"$f":"'Data Capture Demand'!H49","v":0},{"$f":"SUM('Data Capture Demand'!G49*F38)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C50=\"\",\"\",'Data Capture Demand'!C50)","v":"Other"},{"$f":"IF('Data Capture Demand'!D50=\"\",\"\",'Data Capture Demand'!D50)","v":""},{"$f":"'Data Capture Demand'!E50","v":0},{"$f":"'Data Capture Demand'!H50","v":0},{"$f":"SUM('Data Capture Demand'!G50*F39)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C51=\"\",\"\",'Data Capture Demand'!C51)","v":"Other"},{"$f":"IF('Data Capture Demand'!D51=\"\",\"\",'Data Capture Demand'!D51)","v":""},{"$f":"'Data Capture Demand'!E51","v":0},{"$f":"'Data Capture Demand'!H51","v":0},{"$f":"SUM('Data Capture Demand'!G51*F40)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"IF('Data Capture Demand'!C52=\"\",\"\",'Data Capture Demand'!C52)","v":"Other"},{"$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*F41)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":9.4160539215686274},0,0,0,9.4160539215686274,0,null,9.4160539215686274,0]
[null,null,{"$f":"'Data Capture Demand'!C42&\" TOTAL\"","v":"INSTITUTIONAL TOTAL"},null,{"$f":"SUM(E32:E41)","v":17000},null,{"$f":"SUM(G32:G41)","v":80000},null,{"$f":"SUM(I32:I41)","v":160072.91666666666},null,null,null,{"$f":"SUM(M32:M41)","v":160072.91666666666},null,null,{"$f":"SUM(P32:P41)","v":80072.916666666657}]
[]
[null,null,"TOTAL VARIABLE CONSUMPTION",null,{"$f":"SUM(E42+E31+E25+E15)","v":1632000},null,{"$f":"SUM(G42+G31+G25+G15)","v":14205000},null,{"$f":"SUM(I42+I31+I25+I15)","v":15367000},null,null,null,{"$f":"SUM(M42+M31+M25+M15)","v":15367000},null,null,{"$f":"SUM(P42+P31+P25+P15)","v":1162000}]
[]
[null,null,"FULL VARIABLE COST",{"$f":"SUM('Data Capture Costs'!D6)","v":13970000},{"$f":"SUM('Data Capture Costs'!D6)","v":13970000},"CURRENT ACTUAL (PER YEAR)",null,null,null,0,null,"ANTICIPATED (PER YEAR)"]
[null,null,null,null,null,"Current Revenue",{"$f":"G44","v":14205000},null,null,null,null,"Revised Revenue",{"$f":"M44","v":15367000}]
[null,null,null,null,null,"PROFIT\\LOSS",{"$f":"G47-E46","v":235000},null,null,0,null,"PROFIT\\LOSS",{"$f":"M47-E46","v":1397000}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]

{"sheet":"Test Afford of Fixed Tariff","index":10,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,5,25,6],[25,11,25,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,"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":"KL WATER 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 (Free Basic Water) Consumers"},null,{"$f":"'Data Capture Users'!D10","v":2200},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":"'Data Capture Users'!C9&\" TOTAL\"","v":"DOMESTIC (LOW INCOME) TOTAL"},null,{"$f":"SUM(E7)","v":2200},null,{"$f":"SUM(G7)","v":0},null,{"$f":"SUM(I7)","v":0},null,null,null,{"$f":"SUM(M7)","v":0},null,null,{"$f":"SUM(P7)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C14=\"\",\"\",'Data Capture Users'!C14)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D14","v":900},{"$f":"'Data Capture Users'!G14","v":480},{"$f":"'Data Capture Users'!F14*F9","v":480000},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E9*H9)","v":284727.27272727271},null,50,{"$f":"SUM(H9*K9%)+H9","v":474.5454545454545},{"$f":"E9*L9","v":427090.90909090906},null,{"$f":"L9-F9","v":-5.4545454545454959},{"$f":"M9-G9","v":-52909.090909090941}]
[null,null,{"$f":"IF('Data Capture Users'!C15=\"\",\"\",'Data Capture Users'!C15)","v":"Basic Fees from Number of Domestic Consumers"},null,{"$f":"'Data Capture Users'!D15","v":10100},{"$f":"'Data Capture Users'!G15","v":480},{"$f":"'Data Capture Users'!F15*F10","v":4800000},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E10*H10)","v":3195272.7272727266},null,50,{"$f":"SUM(H10*K10%)+H10","v":474.5454545454545},{"$f":"E10*L10","v":4792909.0909090908},null,{"$f":"L10-F10","v":-5.4545454545454959},-7090.9090909091756]
[null,null,{"$f":"IF('Data Capture Users'!C16=\"\",\"\",'Data Capture Users'!C16)","v":""},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$13","v":316.36363636363632},{"$f":"SUM(E11*H11)","v":0},null,0,{"$f":"SUM(H11*K11%)+H11","v":316.36363636363632},{"$f":"E11*L11","v":0},null,{"$f":"L11-F11","v":316.36363636363632},0]
[null,null,{"$f":"'Data Capture Users'!C13&\" TOTAL\"","v":"DOMESTIC TOTAL"},null,{"$f":"SUM(E9:E11)","v":11000},null,{"$f":"SUM(G9:G11)","v":5280000},null,{"$f":"SUM(I9:I11)","v":3479999.9999999991},null,null,null,{"$f":"SUM(M9:M11)","v":5220000},null,null,{"$f":"SUM(P9:P11)","v":-60000.000000000116}]
[null,null,{"$f":"IF('Data Capture Users'!C20=\"\",\"\",'Data Capture Users'!C20)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D20","v":0},{"$f":"'Data Capture Users'!G20","v":0},{"$f":"'Data Capture Users'!F20*F13","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E13*H13)","v":0},null,0,{"$f":"SUM(H13*K13%)+H13","v":316.36363636363632},{"$f":"E13*L13","v":0},null,{"$f":"L13-F13","v":316.36363636363632},{"$f":"M13-G13","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C21=\"\",\"\",'Data Capture Users'!C21)","v":"Basic Fees"},null,{"$f":"'Data Capture Users'!D21","v":0},{"$f":"'Data Capture Users'!G21","v":0},{"$f":"'Data Capture Users'!F21*F14","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E14*H14)","v":0},null,0,{"$f":"SUM(H14*K14%)+H14","v":316.36363636363632},{"$f":"E14*L14","v":0},null,{"$f":"L14-F14","v":316.36363636363632},0]
[null,null,{"$f":"'Data Capture Users'!C19&\" TOTAL\"","v":"INDUSTRIAL TOTAL"},null,{"$f":"SUM(E13:E14)","v":0},null,{"$f":"SUM(G13:G14)","v":0},null,{"$f":"SUM(I13:I14)","v":0},null,null,null,{"$f":"SUM(M13:M14)","v":0},null,null,{"$f":"SUM(P13:P14)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C25=\"\",\"\",'Data Capture Users'!C25)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D25","v":0},{"$f":"'Data Capture Users'!G25","v":0},{"$f":"'Data Capture Users'!F25*F16","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E16*H16)","v":0},null,0,{"$f":"SUM(H16*K16%)+H16","v":316.36363636363632},{"$f":"E16*L16","v":0},null,{"$f":"L16-F16","v":316.36363636363632},{"$f":"M16-G16","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C26=\"\",\"\",'Data Capture Users'!C26)","v":"Basic Fees"},null,{"$f":"'Data Capture Users'!D26","v":0},{"$f":"'Data Capture Users'!G26","v":0},{"$f":"'Data Capture Users'!F26*F17","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E17*H17)","v":0},null,0,{"$f":"SUM(H17*K17%)+H17","v":316.36363636363632},{"$f":"E17*L17","v":0},null,{"$f":"L17-F17","v":316.36363636363632},0]
[null,null,{"$f":"IF('Data Capture Users'!C27=\"\",\"\",'Data Capture Users'!C27)","v":""},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$13","v":316.36363636363632},{"$f":"SUM(E18*H18)","v":0},null,0,{"$f":"SUM(H18*K18%)+H18","v":316.36363636363632},{"$f":"E18*L18","v":0},null,{"$f":"L18-F18","v":316.36363636363632},0]
[null,null,{"$f":"'Data Capture Users'!C24&\" TOTAL\"","v":"COMMERCIAL TOTAL"},null,{"$f":"SUM(E16:E18)","v":0},null,{"$f":"SUM(G16:G18)","v":0},null,{"$f":"SUM(I16:I18)","v":0},null,null,null,{"$f":"SUM(M16:M18)","v":0},null,null,{"$f":"SUM(P16:P18)","v":0}]
[null,null,{"$f":"IF('Data Capture Users'!C31=\"\",\"\",'Data Capture Users'!C31)","v":"Availablility Fees for Vacant Stands"},null,{"$f":"'Data Capture Users'!D31","v":0},{"$f":"'Data Capture Users'!G31","v":0},{"$f":"'Data Capture Users'!F31*F20","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E20*H20)","v":0},null,0,{"$f":"SUM(H20*K20%)+H20","v":316.36363636363632},{"$f":"E20*L20","v":0},null,{"$f":"L20-F20","v":316.36363636363632},{"$f":"M20-G20","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C82=\"\",\"\",'Data Capture Demand'!C82)","v":""},null,{"$f":"'Data Capture Users'!D32","v":0},{"$f":"'Data Capture Users'!G32","v":0},{"$f":"'Data Capture Users'!F32*F21","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$13","v":316.36363636363632},{"$f":"SUM(E21*H21)","v":0},null,0,{"$f":"SUM(H21*K21%)+H21","v":316.36363636363632},{"$f":"E21*L21","v":0},null,{"$f":"L21-F21","v":316.36363636363632},0]
[null,null,{"$f":"'Data Capture Users'!C30&\" TOTAL\"","v":"INSTITUTIONAL TOTAL"},null,{"$f":"SUM(E20:E21)","v":0},null,{"$f":"SUM(G20:G21)","v":0},null,{"$f":"SUM(I20:I21)","v":0},null,null,null,{"$f":"SUM(M20:M21)","v":0},null,null,{"$f":"SUM(P20:P21)","v":0}]
[]
[null,null,"TOTAL FIXED CONSUMPTION",null,{"$f":"SUM(E12+E15+E19+E22)","v":11000},null,{"$f":"SUM(G12+G15+G19+G22)","v":5280000},null,{"$f":"SUM(I12+I15+I19+I22)","v":3479999.9999999991},null,null,null,{"$f":"SUM(M12+M15+M19+M22)","v":5220000},null,null,{"$f":"SUM(P12+P15+P19+P22)","v":-60000.000000000116}]
[]
[null,null,"FULL FIXED COST",null,{"$f":"SUM('Data Capture Costs'!D7)","v":3479999.9999999995},"CURRENT ACTUAL (PER YEAR) ",null,null,null,null,null,"ANTICIPATED (PER YEAR)"]
[null,null,null,null,null,"Current Revenue",{"$f":"G24","v":5280000},null,null,null,null,"Revised Revenue",{"$f":"M24","v":5220000}]
[null,null,null,null,null,"PROFIT\\LOSS",{"$f":"G27-E26","v":1800000.0000000005},null,null,null,null,"PROFIT\\LOSS",{"$f":"M27-E26","v":1740000.0000000005}]

{"sheet":"Summary of Tariff Comparisons","index":11,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,5,12,6],[12,11,12,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":"KL WATER 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'!E44","v":1632000},null,{"$f":"'Test Afford of Variable Tariff'!G44","v":14205000},null,{"$f":"'Test Afford of Variable Tariff'!I44","v":15367000},null,null,null,{"$f":"'Test Afford of Variable Tariff'!M44","v":15367000},null,null,{"$f":"'Test Afford of Variable Tariff'!P44","v":1162000}]
[]
[]
[null,null,"TOTAL FIXED CONSUMPTION",null,{"$f":"'Test Afford of Fixed Tariff'!E24","v":11000},null,{"$f":"'Test Afford of Fixed Tariff'!G24","v":5280000},null,{"$f":"'Test Afford of Fixed Tariff'!I24","v":3479999.9999999991},null,null,null,{"$f":"'Test Afford of Fixed Tariff'!M24","v":5220000},null,null,{"$f":"'Test Afford of Fixed Tariff'!P24","v":-60000.000000000116}]
[]
[null,null,"FULL COST",null,{"$f":"SUM('Data Capture Costs'!D8)","v":17450000},"CURRENT ACTUAL (PER YEAR) ",null,null,null,null,null,"ANTICIPATED (PER YEAR)"]
[null,null,null,null,null,"Current Revenue",{"$f":"G8+G11","v":19485000},null,null,null,null,"Revised Revenue",{"$f":"M8+M11","v":20587000}]
[null,null,null,null,null,"PROFIT\\LOSS",{"$f":"G14-E13","v":2035000},null,null,null,null,"PROFIT\\LOSS",{"$f":"M14-E13","v":3137000}]