{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Menu","Summary Instructions","Data Capture Demand","Data Capture Costs","Primary Baseline Tariff","Strategic Decisions","Revised Tariff","Test Revised Primary Baseline"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"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":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,3,5,5],[6,3,6,5],[7,3,7,5],[1,1,1,7],[2,1,2,7]]}
[]
[null,"Enter the Name of this Service (use Capital letters):-"]
[]
[]
[]
[null,null,null,"NON-TRADING SERVICES 3"]
[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":2010}]

{"sheet":"Summary Instructions","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,7],[23,3,23,5],[26,3,26,5],[7,2,7,7],[13,2,13,7],[9,3,11,4]]}
[]
[]
[null,null,"NON TRADING - SUMMARY INSTRUCTIONS"]
[]
[null,null,null,"Capture anticipated and current number of activities for each Activity Type.  Also capture the Current Tariff on this workscreen."]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,null,"Capture the costs for the budget vote on this screen. 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 costs and subsidy is also proportioned according to this %."]
[]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,null,"The Primary Baseline is calculated by allocating costs as a % of Revenue generated by the activity.  This allocated cost is then divided by the number of activities for each Activity Type."]
[]
[]
[null,null,null,"This screen compares the Current Actual Tariff and Revenue to the Revised Tariff and Revenue."]
[]
[]
[null,null,"% CHANGE","Use the %Change column to increase or decrease the Revised Tariff.  As you enter the % ,change the Tariff and Revenue will change to reflect your input."]
[]
[null,null,"Current Actual - Revised","This column displays the difference between Tariffs 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":15,"n_cols":14,"rows_kept":15,"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!B3&\" - DATA CAPTURE: DEMAND\"","v":" - DATA CAPTURE: DEMAND"}]
[]
[null,null,"FUTURE DEMAND",null,null,null,"HISTORICAL DEMAND"]
[]
[null,null,{"$f":"\"Financial Year:\"&\" \"&Menu!$J$8&\"\\\"&Menu!$J$8+1","v":"Financial Year: 2010\\2011"},null,null,null,{"$f":"SUM(Menu!$J$8-1)&\"\\\"&SUM(Menu!$J$8)","v":"2009\\2010"}]
[null,null,"CONSUMER","ACTIVITY TYPE","NO OF ACTIVITIES",null,"NO OF ACTIVITIES","CURRENT ACTUAL TARIFF per Activity"]
[null,null,"Type 1",null,0,null,0,0,null,null,null,null,null,{"$f":"G9*H9","v":0}]
[null,null,"Type 2",null,0,null,0,0,null,null,null,null,null,{"$f":"G10*H10","v":0}]
[null,null,"Type 3",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 4",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 5",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 6",null,0,null,0,0,null,null,null,null,null,0]
[null,null,"TOTAL NO OF ACTIVITIES",null,{"$f":"SUM(E9:E14)","v":0},null,{"$f":"SUM(G9:G14)","v":0}]

{"sheet":"Data Capture Costs","index":3,"n_rows":105,"n_cols":52,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,2,2,4],[31,2,31,4],[4,3,4,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,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,0.01]
[null,null,{"$f":"Menu!B3&\" - DATA CAPTURE: COSTS BY BUDGET VOTE\"","v":" - 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,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,0.08]
[null,null,"COSTS BY BUDGET VOTE",{"$f":"Menu!$J$7","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,0.09]
[null,null,"Costs","Detail",{"$f":"\"Year\"&\" \"&Menu!$J$8&\"\\\"&Menu!$J$8+1","v":"Year 2010\\2011"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Employee Related Costs:","Basic Salaries",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,0.12]
[null,null,"Employee Related Costs:","Social Contributions",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,0.13]
[null,null,"Repairs and Maintenance","Repairs and Maintenance",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,0.14000000000000001]
[null,null,"Other Costs:","General Costs",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,0.15]
[null,null,"Other Costs:","Collection Commission",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,0.16]
[null,null,"Other Cost:","Contracted Services",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,0.17]
[null,null,"Other Costs:","Contributions to Provisions",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,0.18]
[null,null,"Other Costs:","Debt Impairment",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,0.19]
[null,null,"Other Costs:","Motor Vehicle Costs",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,0.2]
[null,null,"Depreciation:",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,0.21]
[null,null,"External Interest:",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,0.22]
[null,null,"Reserves\\Provisions for Capital Improvements:",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,0.23]
[null,null,"Other Costs:",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,0.24]
[null,null,"Other Costs:",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,0.25]
[null,null,"Other Costs:",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,0.26]
[null,null,"Other Costs:",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,0.27]
[null,null,"Other Costs:",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,0.28000000000000003]
[null,null,"Other Costs:",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,0.28999999999999998]
[null,null,"Overhead Costs Re-Allocated (+)",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,0.3]
[null,null,"Overhead Costs Re-Allocated (-)","Less",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,0.31]
[null,null,"Less Sundry Income ","Less Sundry Income Generated from Indirect Services",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,0.32]
[null,null,"TOTAL COSTS BY BUDGET VOTE",null,{"$f":"SUM(E7:E25)-E26-E27","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,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,0.34]
[null,null,"TOTAL RING FENCED COSTS",null,{"$f":"SUM(E7:E27)","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,null,0.35]
[]
[null,null,"COST APPORTIONMENT FOR MULTIPLE PRIMARY BASELINES",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,null,0.36]
[null,null,"PRIOR YEAR - REVENUE PER TYPE","ACTIVITY TYPE","REVENUE",null,"% of Revenue per Consumer Group"," Cost Allocated by Revenue","Subsidy Amt",{"$f":"E30*'Strategic Decisions'!I8%","v":0},"Revenue plus Subsidy %"]
[null,null,{"$f":"'Data Capture Demand'!C9","v":"Type 1"},{"$f":"IF('Data Capture Demand'!D9=\"\",\"\",'Data Capture Demand'!D9)","v":""},{"$f":"'Data Capture Demand'!N9","v":0},null,{"$f":"IF(E34=0,0,E34/$E$40)","v":0},{"$f":"$E$30*(G34)","v":0},{"$f":"G34*'Strategic Decisions'!$I$6","v":0},{"$f":"G34*$J$33","v":0},{"$f":"H34+I34+J34","v":0}]
[null,null,{"$f":"'Data Capture Demand'!C10","v":"Type 2"},{"$f":"IF('Data Capture Demand'!D10=\"\",\"\",'Data Capture Demand'!D10)","v":""},{"$f":"'Data Capture Demand'!N10","v":0},null,{"$f":"IF(E35=0,0,E35/$E$40)","v":0},{"$f":"$E$30*(G35)","v":0},{"$f":"G35*'Strategic Decisions'!$I$6","v":0},{"$f":"G35*$J$33","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C11","v":"Type 3"},{"$f":"IF('Data Capture Demand'!D11=\"\",\"\",'Data Capture Demand'!D11)","v":""},{"$f":"'Data Capture Demand'!N11","v":0},null,0,0,{"$f":"G36*'Strategic Decisions'!$I$6","v":0},0,0]
[null,null,{"$f":"'Data Capture Demand'!C12","v":"Type 4"},{"$f":"IF('Data Capture Demand'!D12=\"\",\"\",'Data Capture Demand'!D12)","v":""},{"$f":"'Data Capture Demand'!N12","v":0},null,0,0,{"$f":"G37*'Strategic Decisions'!$I$6","v":0},0,0]
[null,null,{"$f":"'Data Capture Demand'!C13","v":"Type 5"},{"$f":"IF('Data Capture Demand'!D13=\"\",\"\",'Data Capture Demand'!D13)","v":""},{"$f":"'Data Capture Demand'!N13","v":0},null,0,0,{"$f":"G38*'Strategic Decisions'!$I$6","v":0},0,0]
[null,null,{"$f":"'Data Capture Demand'!C14","v":"Type 6"},{"$f":"IF('Data Capture Demand'!D14=\"\",\"\",'Data Capture Demand'!D14)","v":""},{"$f":"'Data Capture Demand'!N14","v":0},null,0,0,{"$f":"G39*'Strategic Decisions'!$I$6","v":0},0,0]
[null,null,{"$f":"'Data Capture Demand'!C15","v":"TOTAL NO OF ACTIVITIES"},null,{"$f":"SUM(E34:E39)","v":0},null,{"$f":"SUM(G34:G39)","v":0},{"$f":"SUM(H34:H39)","v":0},{"$f":"SUM(I34:I39)","v":0},{"$f":"SUM(J34:J39)","v":0},{"$f":"SUM(K34:K39)","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,1]

{"sheet":"Primary Baseline Tariff","index":4,"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 the basic tariff calculated per baseline unit."]
[]
[null,null,"ACTIVITY TYPE","TARIFF"]
[null,null,{"$f":"IF('Data Capture Costs'!D34=\"\",\"\",'Data Capture Costs'!D34)","v":""},{"$f":"IF('Data Capture Demand'!E9=0,0,'Data Capture Costs'!H34/'Data Capture Demand'!E9)","v":0}]
[null,null,{"$f":"IF('Data Capture Costs'!D35=\"\",\"\",'Data Capture Costs'!D35)","v":""},{"$f":"IF('Data Capture Demand'!E10=0,0,'Data Capture Costs'!H35/'Data Capture Demand'!E10)","v":0}]
[null,null,{"$f":"IF('Data Capture Costs'!D36=\"\",\"\",'Data Capture Costs'!D36)","v":""},{"$f":"IF('Data Capture Demand'!E11=0,0,'Data Capture Costs'!H36/'Data Capture Demand'!E11)","v":0}]
[null,null,{"$f":"IF('Data Capture Costs'!D37=\"\",\"\",'Data Capture Costs'!D37)","v":""},{"$f":"IF('Data Capture Demand'!E12=0,0,'Data Capture Costs'!H37/'Data Capture Demand'!E12)","v":0}]
[null,null,{"$f":"IF('Data Capture Costs'!D38=\"\",\"\",'Data Capture Costs'!D38)","v":""},{"$f":"IF('Data Capture Demand'!E13=0,0,'Data Capture Costs'!H38/'Data Capture Demand'!E13)","v":0}]
[null,null,{"$f":"IF('Data Capture Costs'!D39=\"\",\"\",'Data Capture Costs'!D39)","v":""},{"$f":"IF('Data Capture Demand'!E14=0,0,'Data Capture Costs'!H39/'Data Capture Demand'!E14)","v":0}]

{"sheet":"Strategic Decisions","index":5,"n_rows":23,"n_cols":55,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,2,2,4],[14,2,14,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,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,"No"]
[null,null,"FINANCIAL DECISIONS","AMOUNT","%",null,null,null,"Total Subsidy Amt"]
[null,1,"Do you wish to achieve a Surplus on this service?","YES",null,null,null,null,{"$f":"D8-D12+D18","v":0}]
[null,null,null,"NO",null,null,null,null,"Total Subsidy % "]
[null,null,"Enter Size of the Surplus",0,0,null,null,null,{"$f":"E8-E12+E18","v":0}]
[]
[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]
[]
[null,null,"AFFORDABILITY DECISIONS","AMOUNT","%"]
[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]
[]
[null,4,"Do you wish to limit the Size of the Tariff levied on certain type of consumers?","CHANGE TARIFF"]
[]
[]
[null,5,"Do you wish to Escalate the Tariff levied on certain type of consumers?","CHANGE TARIFF"]

{"sheet":"Revised Tariff","index":6,"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,"Below is the basic tariff calculated per baseline unit."]
[]
[null,null,"ACTIVITY TYPE","TARIFF"]
[null,null,{"$f":"'Data Capture Costs'!D34","v":""},{"$f":"IF('Data Capture Demand'!E9=0,0,'Data Capture Costs'!K34/'Data Capture Demand'!E9)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!D35","v":""},{"$f":"IF('Data Capture Demand'!E10=0,0,'Data Capture Costs'!K35/'Data Capture Demand'!E10)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!D36","v":""},{"$f":"IF('Data Capture Demand'!E11=0,0,'Data Capture Costs'!K36/'Data Capture Demand'!E11)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!D37","v":""},{"$f":"IF('Data Capture Demand'!E12=0,0,'Data Capture Costs'!K37/'Data Capture Demand'!E12)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!D38","v":""},{"$f":"IF('Data Capture Demand'!E13=0,0,'Data Capture Costs'!K38/'Data Capture Demand'!E13)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!D39","v":""},{"$f":"IF('Data Capture Demand'!E14=0,0,'Data Capture Costs'!K39/'Data Capture Demand'!E14)","v":0}]

{"sheet":"Test Revised Primary Baseline","index":7,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,5,14,6],[14,11,14,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"]
[]
[null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!D8","v":"ACTIVITY TYPE"},{"$f":"'Data Capture Demand'!E8&\" (\"&Menu!J8&\")\"","v":"NO OF ACTIVITIES (2010)"},"CURRENT ACTUAL",null,"REVISED PRIMARY BASELINE",null,null,"AFFORDABILITY ADJUSTMENT TO REVISED PRIMARY BASELINE",null,null,null,"Current Actual - Revised Primary","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'!C9=\"\",\"\",'Data Capture Demand'!C9)","v":"Type 1"},{"$f":"IF('Data Capture Demand'!D9=\"\",\"\",'Data Capture Demand'!D9)","v":""},{"$f":"'Data Capture Demand'!E9","v":0},{"$f":"'Data Capture Demand'!H9","v":0},{"$f":"SUM('Data Capture Demand'!G9*F7)","v":0},{"$f":"'Revised Tariff'!D8","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},{"$f":"M7-G7","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C10=\"\",\"\",'Data Capture Demand'!C10)","v":"Type 2"},{"$f":"IF('Data Capture Demand'!D10=\"\",\"\",'Data Capture Demand'!D10)","v":""},{"$f":"'Data Capture Demand'!E10","v":0},{"$f":"'Data Capture Demand'!H10","v":0},{"$f":"SUM('Data Capture Demand'!G10*F8)","v":0},{"$f":"'Revised Tariff'!D9","v":0},0,null,0,0,0,null,{"$f":"L8-F8","v":0},{"$f":"M8-G8","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C11=\"\",\"\",'Data Capture Demand'!C11)","v":"Type 3"},{"$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},{"$f":"SUM('Data Capture Demand'!G11*F9)","v":0},{"$f":"'Revised Tariff'!D10","v":0},0,null,0,0,0,null,{"$f":"L9-F9","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C12=\"\",\"\",'Data Capture Demand'!C12)","v":"Type 4"},{"$f":"IF('Data Capture Demand'!D12=\"\",\"\",'Data Capture Demand'!D12)","v":""},{"$f":"'Data Capture Demand'!E12","v":0},{"$f":"'Data Capture Demand'!H12","v":0},{"$f":"SUM('Data Capture Demand'!G12*F10)","v":0},{"$f":"'Revised Tariff'!D11","v":0},0,null,0,0,0,null,{"$f":"L10-F10","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C13=\"\",\"\",'Data Capture Demand'!C13)","v":"Type 5"},{"$f":"IF('Data Capture Demand'!D13=\"\",\"\",'Data Capture Demand'!D13)","v":""},{"$f":"'Data Capture Demand'!E13","v":0},{"$f":"'Data Capture Demand'!H13","v":0},{"$f":"SUM('Data Capture Demand'!G13*F11)","v":0},{"$f":"'Revised Tariff'!D12","v":0},0,null,0,0,0,null,{"$f":"L11-F11","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C14=\"\",\"\",'Data Capture Demand'!C14)","v":"Type 6"},{"$f":"IF('Data Capture Demand'!D14=\"\",\"\",'Data Capture Demand'!D14)","v":""},{"$f":"'Data Capture Demand'!E14","v":0},{"$f":"'Data Capture Demand'!H14","v":0},{"$f":"SUM('Data Capture Demand'!G14*F12)","v":0},{"$f":"'Revised Tariff'!D13","v":0},0,null,0,0,0,null,{"$f":"L12-F12","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C15=\"\",\"\",'Data Capture Demand'!C15)","v":"TOTAL NO OF ACTIVITIES"},null,{"$f":"SUM(E7:E12)","v":0},null,{"$f":"SUM(G7:G12)","v":0},null,{"$f":"SUM(I7:I12)","v":0},null,null,null,{"$f":"SUM(M7:M12)","v":0},null,null,{"$f":"SUM(P7:P12)","v":0}]
[]
[null,null,"FULL COST",{"$f":"'Data Capture Costs'!E30","v":0},null,"CURRENT ACTUAL",null,null,null,null,null,"ANTICIPATED"]
[null,null,null,null,null,"Current Revenue",{"$f":"G13","v":0},null,null,null,null,"Revised Revenue",{"$f":"M13","v":0}]
[null,null,null,null,null,"PROFIT\\LOSS",{"$f":"G16-D15","v":0},null,null,null,null,"PROFIT\\LOSS",{"$f":"M16-D15","v":0}]