{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Instructions","Summary Instructions","Data Capture Demand","Data Capture Costs","Primary Baseline Tariff","Strategic Decisions","Revised Primary Baseline 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":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,"SOLID WASTE"]
[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":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Summary Instructions","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,2,2,7],[11,5,12,7],[7,2,7,7],[18,2,18,7],[33,2,33,7],[15,3,17,4]]}
[]
[]
[null,null,"SOLID WASTE - SUMMARY INSTRUCTIONS"]
[]
[null,null,null,"Capture  anticipated and current Consumer information on this screen."]
[]
[]
[null,null,"Any cell with this background colour is a DATA INPUT cell."]
[]
[null,null,"Data Required"]
[null,null,"Consumer  - ","EG Per Residence"]
[null,null,"No of Collection Points - ","The number of collection points (current as well anticipated).",null,"Municipal specific DATA INPUT"]
[null,null,"Current Actual Tariff - ","Tariff charged in the last financial year for each Consumer group."]
[]
[]
[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 and then displayed on this screen."]
[]
[]
[null,null,null,"TOTAL RING FENCED COSTS"]
[null,null,"Primary Baseline","TOTAL NUMBER OF COLLECTION POINTS"]
[]
[]
[]
[]
[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."]
[]
[]
[null,null,"% CHANGE","Use the %Change column to increase or decrease the Revised Tariff.  As you enter the % change the Tariff and Tevenue 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":3,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,5,4,6],[6,5,6,6],[6,2,6,3],[2,2,2,6],[4,2,4,3]]}
[]
[]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: DEMAND PER MONTH\"","v":"SOLID WASTE - DATA CAPTURE: DEMAND PER MONTH"}]
[]
[null,null,"FUTURE DEMAND",null,null,"HISTORICAL DEMAND"]
[]
[null,null,{"$f":"\"Financial Year:\"&\" \"&Menu!$J$5&\"\\\"&Menu!$J$5+1","v":"Financial Year: 2011\\2012"},null,null,{"$f":"SUM(Menu!$J$5-1)&\"\\\"&SUM(Menu!$J$5)","v":"2010\\2011"}]
[null,null,"CONSUMER","NO OF COLLECTION POINTS",null,"NO OF COLLECTION POINTS","CURRENT ACTUAL TARIFF per Month"]
[null,null,"DOMESTIC"]
[null,null,"Residential",10000,null,10000,80,null,null,null,null,null,{"$f":"F10*G10","v":800000}]
[null,null,"Other",0,null,0,0,null,null,null,null,null,{"$f":"F11*G11","v":0}]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Total No of Collection Points",{"$f":"SUM(D10:D15)","v":10000},null,{"$f":"SUM(F10:F15)","v":10000},null,null,null,null,null,null,{"$f":"SUM(M10:M15)","v":800000}]
[]
[null,null,"INDUSTRIAL"]
[null,null,"Big Factory",1000,null,1000,300,null,null,null,null,null,{"$f":"F19*G19","v":300000}]
[null,null,"Small Factory",200,null,200,200,null,null,null,null,null,40000]
[null,null,"Type 3",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 4",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 5",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 6",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 7",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 8",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 9",0,null,0,0,null,null,null,null,null,0]
[null,null,"Total No of Collection Points",{"$f":"SUM(D19:D27)","v":1200},null,{"$f":"SUM(F19:F27)","v":1200},null,null,null,null,null,null,{"$f":"SUM(M19:M27)","v":340000}]
[]
[null,null,"COMMERCIAL"]
[null,null,"Type 1",0,null,0,0,null,null,null,null,null,{"$f":"F31*G31","v":0}]
[null,null,"Type 2",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 3",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 4",0,null,0,0,null,null,null,null,null,0]
[null,null,"Type 5",0,null,0,0,null,null,null,null,null,0]
[null,null,"Total No of Collection Points",{"$f":"SUM(D31:D35)","v":0},null,{"$f":"SUM(F31:F35)","v":0},null,null,null,null,null,null,{"$f":"SUM(M31:M35)","v":0}]
[]
[null,null,"INSTITUTIONAL"]
[null,null,"Prison",2,null,2,1250,null,null,null,null,null,{"$f":"F39*G39","v":2500}]
[null,null,"Municipal",20,null,20,1250,null,null,null,null,null,25000]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Other",0,null,0,0,null,null,null,null,null,0]
[null,null,"Total No of Collection Points",{"$f":"SUM(D39:D48)","v":22},null,{"$f":"SUM(F39:F48)","v":22},null,null,null,null,null,null,{"$f":"SUM(M39:M48)","v":27500}]
[]
[null,null,"TOTAL NO OF COLLECTION POINTS",{"$f":"SUM(D16+D28+D36+D49)","v":11222},null,{"$f":"SUM(F16+F28+F36+F49)","v":11222}]

{"sheet":"Data Capture Costs","index":4,"n_rows":64,"n_cols":49,"rows_kept":64,"cut":false,"hidden":false,"merged":[[38,2,38,3],[37,2,37,3],[2,2,2,4],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[32,2,32,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,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,0.01]
[null,null,{"$f":"Menu!D3&\" - DATA CAPTURE: COSTS BY BUDGET VOTE\"","v":"SOLID WASTE - 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,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,0.08]
[null,null,"COSTS BY BUDGET VOTE",{"$f":"Menu!$J$4","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,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,0.1]
[null,null,"Bulk Purchases:",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,0.11]
[null,null,"Employee Related Costs:","Basic Salaries",6000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12]
[null,null,"Employee Related Costs:","Social Contributions",2000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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",500000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:",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,0.15]
[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,0.16]
[null,null,"Other Cost:",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,0.17]
[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,0.18]
[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,0.19]
[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,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,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,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,0.23]
[null,null,"Contracted Services","Management of Landfill site",2500000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Contracted Services","Refuse Collection",3000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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:","General Expenses",750000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,0.28999999999999998]
[null,null,"Overhead Costs Re-Allocated (+)","Portion of council, finance and HR",750000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,0.32]
[null,null,"TOTAL RING FENCED COSTS PER ANNUM",null,{"$f":"SUM(E7:E26)-E27-E28","v":15500000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.34]
[null,null,"TOTAL RING FENCED COSTS PER MONTH",null,{"$f":"E29/12","v":1291666.6666666667},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.39]
[null,null,"PRIOR YEAR - REVENUE PER CONSUMER GROUP",null,"REVENUE",null,"% of Revenue per Consumer Group","Cost Allocated by Revenue","Subsidy Amt",{"$f":"E31*'Strategic Decisions'!J18%","v":0},"Revenue plus Subsidy %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,{"$f":"'Data Capture Demand'!C9","v":"DOMESTIC"},null,{"$f":"'Data Capture Demand'!M16","v":800000},null,{"$f":"IF(E35=0,0,E35/$E$39)","v":0.68522483940042822},{"$f":"$E$31*G35","v":885082.0842255532},{"$f":"G35*'Strategic Decisions'!$J$16","v":0},{"$f":"G35*$J$34","v":0},{"$f":"SUM(H35+I35+J35)","v":885082.0842255532},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"'Data Capture Demand'!C18","v":"INDUSTRIAL"},null,{"$f":"'Data Capture Demand'!M28","v":340000},null,{"$f":"IF(E36=0,0,E36/$E$39)","v":0.29122055674518199},{"$f":"$E$31*G36","v":376159.88579586009},{"$f":"G36*'Strategic Decisions'!$J$16","v":0},{"$f":"G36*$J$34","v":0},{"$f":"SUM(H36+I36+J36)","v":376159.88579586009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"'Data Capture Demand'!C30","v":"COMMERCIAL"},null,{"$f":"'Data Capture Demand'!M36","v":0},null,0,0,{"$f":"G37*'Strategic Decisions'!$J$16","v":0},0,{"$f":"SUM(H37+I37+J37)","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,0.43]
[null,null,{"$f":"'Data Capture Demand'!C38","v":"INSTITUTIONAL"},null,{"$f":"'Data Capture Demand'!M49","v":27500},null,2.3554603854389723E-2,30424.696645253392,{"$f":"G38*'Strategic Decisions'!$J$16","v":0},0,{"$f":"SUM(H38+I38+J38)","v":30424.696645253392},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"TOTAL REVENUE",null,{"$f":"SUM(E35:E38)","v":1167500},null,{"$f":"SUM(G35:G38)","v":0.99999999999999989},{"$f":"SUM(H35:H38)","v":1291666.6666666665},{"$f":"SUM(I35:I38)","v":0},{"$f":"SUM(J35:J38)","v":0},{"$f":"SUM(K35:K38)","v":1291666.6666666665},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,1]

{"sheet":"Primary Baseline Tariff","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"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. "]
[]
[null,null,"CONSUMER GROUP","TARIFF"]
[null,null,{"$f":"'Data Capture Costs'!C35","v":"DOMESTIC"},{"$f":"IF('Data Capture Demand'!D16=0,0,'Data Capture Costs'!H35/'Data Capture Demand'!D16)","v":88.508208422555327}]
[null,null,{"$f":"'Data Capture Costs'!C36","v":"INDUSTRIAL"},{"$f":"IF('Data Capture Demand'!D28=0,0,'Data Capture Costs'!H36/'Data Capture Demand'!D28)","v":313.46657149655005}]
[null,null,{"$f":"'Data Capture Costs'!C37","v":"COMMERCIAL"},{"$f":"IF('Data Capture Demand'!D36=0,0,'Data Capture Costs'!H37/'Data Capture Demand'!D36)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!C38","v":"INSTITUTIONAL"},{"$f":"IF('Data Capture Demand'!D49=0,0,'Data Capture Costs'!H38/'Data Capture Demand'!D49)","v":1382.940756602427}]

{"sheet":"Strategic Decisions","index":6,"n_rows":23,"n_cols":56,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,2,2,5],[2,9,3,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,"CHANGES TO VARIABLE 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,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,"FINANCIAL DECISIONS","MONTHLY AMOUNT ","%","% AMT",null,null,null,{"$f":"D8+F8","v":0}]
[null,1,"Do you wish to achieve a Surplus on this service?","YES",null,null,null,null,null,{"$f":"D12+F12","v":0}]
[null,null,null,"NO",null,null,null,null,null,{"$f":"D18+F18","v":0}]
[null,null,"Enter Size of the Surplus",null,0,{"$f":"E8%*'Data Capture Costs'!E31","v":0},null,null,null,{"$f":"J5-J6+J7","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,{"$f":"-(E12%)*'Data Capture Costs'!E31","v":0}]
[]
[null,null,"AFFORDABILITY DECISIONS","MONTHLY 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,null,null,null,null,null,"SUBSIDY AMOUNT"]
[null,3,"Do you plan to subsidise the delivery of this service (excluding Free Basic Services)?","YES",null,null,null,null,null,{"$f":"D8-D12+D18","v":0}]
[null,null,null,"NO",null,null,null,null,null,"SUBSIDY %"]
[null,null,"Enter Size of Subsidy",0,0,{"$f":"E18%*'Data Capture Costs'!E31","v":0},null,null,null,{"$f":"E8-E12+E18","v":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 Primary Baseline Tariff","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"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,"CONSUMER GROUPS","TARIFF"]
[null,null,{"$f":"'Data Capture Costs'!C35:D35","v":"DOMESTIC"},{"$f":"IF('Data Capture Demand'!D16=0,0,'Data Capture Costs'!K35/'Data Capture Demand'!D16)","v":88.508208422555327}]
[null,null,{"$f":"'Data Capture Costs'!C36:D36","v":"INDUSTRIAL"},{"$f":"IF('Data Capture Demand'!D28=0,0,'Data Capture Costs'!K36/'Data Capture Demand'!D28)","v":313.46657149655005}]
[null,null,{"$f":"'Data Capture Costs'!C37:D37","v":"COMMERCIAL"},{"$f":"IF('Data Capture Demand'!D36=0,0,'Data Capture Costs'!K37/'Data Capture Demand'!D36)","v":0}]
[null,null,{"$f":"'Data Capture Costs'!C38:D38","v":"INSTITUTIONAL"},{"$f":"IF('Data Capture Demand'!D49=0,0,'Data Capture Costs'!K38/'Data Capture Demand'!D49)","v":1382.940756602427}]

{"sheet":"Test Revised Primary Baseline","index":8,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,2,2,14],[4,4,4,5],[4,9,4,11],[4,2,5,2],[4,3,5,3],[4,6,4,7],[45,12,45,13],[46,12,46,13],[44,4,44,5],[43,4,43,6],[44,10,44,11],[43,10,43,13],[44,12,44,13]]}
[]
[]
[null,null,"CURRENT & REVISED TARIFF COMPARISON MONTHLY"]
[]
[null,null,{"$f":"'Data Capture Demand'!C8","v":"CONSUMER"},{"$f":"'Data Capture Demand'!D8&\" (\"&Menu!J5&\")\"","v":"NO OF COLLECTION POINTS (2011)"},"CURRENT ACTUAL",null,"REVISED TARIFF",null,null,"AFFORDABILITY ADJUSTMENT  TO REVISED PRIMARY BASELINE",null,null,null,"Current Actual MINUS Revised","PROFIT\\LOSS"]
[null,null,null,null,"TARIFF","REVENUE","TARIFF","REVENUE",null,"% CHANGE","TARIFF","REVENUE",null,"Change","REVENUE"]
[null,null,{"$f":"IF('Data Capture Demand'!C10=\"\",\"\",'Data Capture Demand'!C10)","v":"Residential"},{"$f":"'Data Capture Demand'!D10","v":10000},{"$f":"'Data Capture Demand'!G10","v":80},{"$f":"SUM(E7*'Data Capture Demand'!F10)","v":800000},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":88.508208422555327},{"$f":"SUM(D7*G7)","v":885082.08422555332},0,0,{"$f":"SUM(G7*J7%)+G7","v":88.508208422555327},{"$f":"D7*K7","v":885082.08422555332},null,{"$f":"K7-E7","v":8.5082084225553274},{"$f":"L7-F7","v":85082.084225553321}]
[null,null,{"$f":"IF('Data Capture Demand'!C11=\"\",\"\",'Data Capture Demand'!C11)","v":"Other"},{"$f":"'Data Capture Demand'!D11","v":0},{"$f":"'Data Capture Demand'!G11","v":0},{"$f":"SUM(E8*'Data Capture Demand'!F11)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":88.508208422555327},0,0,0,88.508208422555327,0,null,{"$f":"K8-E8","v":88.508208422555327},{"$f":"L8-F8","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C12=\"\",\"\",'Data Capture Demand'!C12)","v":"Other"},{"$f":"'Data Capture Demand'!D12","v":0},{"$f":"'Data Capture Demand'!G12","v":0},{"$f":"SUM(E9*'Data Capture Demand'!F12)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":88.508208422555327},0,0,0,88.508208422555327,0,null,{"$f":"K9-E9","v":88.508208422555327},0]
[null,null,{"$f":"IF('Data Capture Demand'!C13=\"\",\"\",'Data Capture Demand'!C13)","v":"Other"},{"$f":"'Data Capture Demand'!D13","v":0},{"$f":"'Data Capture Demand'!G13","v":0},{"$f":"SUM(E10*'Data Capture Demand'!F13)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":88.508208422555327},0,0,0,88.508208422555327,0,null,{"$f":"K10-E10","v":88.508208422555327},0]
[null,null,{"$f":"IF('Data Capture Demand'!C14=\"\",\"\",'Data Capture Demand'!C14)","v":"Other"},{"$f":"'Data Capture Demand'!D14","v":0},{"$f":"'Data Capture Demand'!G14","v":0},{"$f":"SUM(E11*'Data Capture Demand'!F14)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":88.508208422555327},0,0,0,88.508208422555327,0,null,{"$f":"K11-E11","v":88.508208422555327},0]
[null,null,{"$f":"IF('Data Capture Demand'!C15=\"\",\"\",'Data Capture Demand'!C15)","v":"Other"},{"$f":"'Data Capture Demand'!D15","v":0},{"$f":"'Data Capture Demand'!G15","v":0},{"$f":"SUM(E12*'Data Capture Demand'!F15)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$8","v":88.508208422555327},0,0,0,88.508208422555327,0,null,{"$f":"K12-E12","v":88.508208422555327},0]
[null,null,{"$f":"'Data Capture Demand'!C9&\" TOTAL\"","v":"DOMESTIC TOTAL"},{"$f":"SUM(D7:D12)","v":10000},null,{"$f":"SUM(F7:F12)","v":800000},null,{"$f":"SUM(H7:H12)","v":885082.08422555332},null,null,null,{"$f":"SUM(L7:L12)","v":885082.08422555332},null,null,{"$f":"SUM(O7:O12)","v":85082.084225553321}]
[null,null,{"$f":"IF('Data Capture Demand'!C19=\"\",\"\",'Data Capture Demand'!C19)","v":"Big Factory"},{"$f":"'Data Capture Demand'!D19","v":1000},{"$f":"'Data Capture Demand'!G19","v":300},{"$f":"SUM(E14*'Data Capture Demand'!F19)","v":300000},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},{"$f":"SUM(D14*G14)","v":313466.57149655005},0,0,{"$f":"SUM(G14*J14%)+G14","v":313.46657149655005},{"$f":"D14*K14","v":313466.57149655005},null,{"$f":"K14-E14","v":13.466571496550046},{"$f":"L14-F14","v":13466.571496550052}]
[null,null,{"$f":"IF('Data Capture Demand'!C20=\"\",\"\",'Data Capture Demand'!C20)","v":"Small Factory"},{"$f":"'Data Capture Demand'!D20","v":200},{"$f":"'Data Capture Demand'!G20","v":200},{"$f":"SUM(E15*'Data Capture Demand'!F20)","v":40000},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},62693.314299310012,0,0,313.46657149655005,62693.314299310012,null,113.46657149655005,22693.314299310012]
[null,null,{"$f":"IF('Data Capture Demand'!C21=\"\",\"\",'Data Capture Demand'!C21)","v":"Type 3"},{"$f":"'Data Capture Demand'!D21","v":0},{"$f":"'Data Capture Demand'!G21","v":0},{"$f":"SUM(E16*'Data Capture Demand'!F21)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"IF('Data Capture Demand'!C22=\"\",\"\",'Data Capture Demand'!C22)","v":"Type 4"},{"$f":"'Data Capture Demand'!D22","v":0},{"$f":"'Data Capture Demand'!G22","v":0},{"$f":"SUM(E17*'Data Capture Demand'!F22)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"IF('Data Capture Demand'!C23=\"\",\"\",'Data Capture Demand'!C23)","v":"Type 5"},{"$f":"'Data Capture Demand'!D23","v":0},{"$f":"'Data Capture Demand'!G23","v":0},{"$f":"SUM(E18*'Data Capture Demand'!F23)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"IF('Data Capture Demand'!C24=\"\",\"\",'Data Capture Demand'!C24)","v":"Type 6"},{"$f":"'Data Capture Demand'!D24","v":0},{"$f":"'Data Capture Demand'!G24","v":0},{"$f":"SUM(E19*'Data Capture Demand'!F24)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"IF('Data Capture Demand'!C25=\"\",\"\",'Data Capture Demand'!C25)","v":"Type 7"},{"$f":"'Data Capture Demand'!D25","v":0},{"$f":"'Data Capture Demand'!G25","v":0},{"$f":"SUM(E20*'Data Capture Demand'!F25)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"IF('Data Capture Demand'!C26=\"\",\"\",'Data Capture Demand'!C26)","v":"Type 8"},{"$f":"'Data Capture Demand'!D26","v":0},{"$f":"'Data Capture Demand'!G26","v":0},{"$f":"SUM(E21*'Data Capture Demand'!F26)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"IF('Data Capture Demand'!C27=\"\",\"\",'Data Capture Demand'!C27)","v":"Type 9"},{"$f":"'Data Capture Demand'!D27","v":0},{"$f":"'Data Capture Demand'!G27","v":0},{"$f":"SUM(E22*'Data Capture Demand'!F27)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$9","v":313.46657149655005},0,0,0,313.46657149655005,0,null,313.46657149655005,0]
[null,null,{"$f":"'Data Capture Demand'!C18&\" TOTAL\"","v":"INDUSTRIAL TOTAL"},{"$f":"SUM(D14:D22)","v":1200},null,{"$f":"SUM(F14:F22)","v":340000},null,{"$f":"SUM(H14:H22)","v":376159.88579586009},null,null,null,{"$f":"SUM(L14:L22)","v":376159.88579586009},null,null,{"$f":"SUM(O14:O22)","v":36159.885795860064}]
[null,null,{"$f":"IF('Data Capture Demand'!C31=\"\",\"\",'Data Capture Demand'!C31)","v":"Type 1"},{"$f":"'Data Capture Demand'!D31","v":0},{"$f":"'Data Capture Demand'!G31","v":0},{"$f":"SUM(E24*'Data Capture Demand'!F31)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":0},{"$f":"SUM(D24*G24)","v":0},0,0,{"$f":"SUM(G24*J24%)+G24","v":0},{"$f":"D24*K24","v":0},null,{"$f":"K24-E24","v":0},{"$f":"L24-F24","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C32=\"\",\"\",'Data Capture Demand'!C32)","v":"Type 2"},{"$f":"'Data Capture Demand'!D32","v":0},{"$f":"'Data Capture Demand'!G32","v":0},{"$f":"SUM(E25*'Data Capture Demand'!F32)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":0},{"$f":"SUM(D25*G25)","v":0},0,0,{"$f":"SUM(G25*J25%)+G25","v":0},{"$f":"D25*K25","v":0},null,{"$f":"K25-E25","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C33=\"\",\"\",'Data Capture Demand'!C33)","v":"Type 3"},{"$f":"'Data Capture Demand'!D33","v":0},{"$f":"'Data Capture Demand'!G33","v":0},{"$f":"SUM(E26*'Data Capture Demand'!F33)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":0},{"$f":"SUM(D26*G26)","v":0},0,0,{"$f":"SUM(G26*J26%)+G26","v":0},{"$f":"D26*K26","v":0},null,{"$f":"K26-E26","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C34=\"\",\"\",'Data Capture Demand'!C34)","v":"Type 4"},{"$f":"'Data Capture Demand'!D34","v":0},{"$f":"'Data Capture Demand'!G34","v":0},{"$f":"SUM(E27*'Data Capture Demand'!F34)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":0},{"$f":"SUM(D27*G27)","v":0},0,0,{"$f":"SUM(G27*J27%)+G27","v":0},{"$f":"D27*K27","v":0},null,{"$f":"K27-E27","v":0},0]
[null,null,{"$f":"IF('Data Capture Demand'!C35=\"\",\"\",'Data Capture Demand'!C35)","v":"Type 5"},{"$f":"'Data Capture Demand'!D35","v":0},{"$f":"'Data Capture Demand'!G35","v":0},{"$f":"SUM(E28*'Data Capture Demand'!F35)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$10","v":0},{"$f":"SUM(D28*G28)","v":0},0,0,{"$f":"SUM(G28*J28%)+G28","v":0},{"$f":"D28*K28","v":0},null,{"$f":"K28-E28","v":0},0]
[null,null,{"$f":"'Data Capture Demand'!C30&\" TOTAL\"","v":"COMMERCIAL TOTAL"},{"$f":"SUM(D24:D28)","v":0},null,{"$f":"SUM(F24:F28)","v":0},null,{"$f":"SUM(H24:H28)","v":0},null,null,null,{"$f":"SUM(L24:L28)","v":0},null,null,{"$f":"SUM(O24:O28)","v":0}]
[null,null,{"$f":"IF('Data Capture Demand'!C39=\"\",\"\",'Data Capture Demand'!C39)","v":"Prison"},{"$f":"'Data Capture Demand'!D39","v":2},{"$f":"'Data Capture Demand'!G39","v":1250},{"$f":"SUM(E30*'Data Capture Demand'!F39)","v":2500},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},{"$f":"SUM(D30*G30)","v":2765.8815132048539},0,0,{"$f":"SUM(G30*J30%)+G30","v":1382.940756602427},{"$f":"D30*K30","v":2765.8815132048539},null,{"$f":"K30-E30","v":132.94075660242697},{"$f":"L30-F30","v":265.88151320485395}]
[null,null,{"$f":"IF('Data Capture Demand'!C40=\"\",\"\",'Data Capture Demand'!C40)","v":"Municipal"},{"$f":"'Data Capture Demand'!D40","v":20},{"$f":"'Data Capture Demand'!G40","v":1250},{"$f":"SUM(E31*'Data Capture Demand'!F40)","v":25000},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},27658.815132048541,0,0,{"$f":"SUM(G31*J31%)+G31","v":1382.940756602427},27658.815132048541,null,132.94075660242697,2658.8151320485413]
[null,null,{"$f":"IF('Data Capture Demand'!C41=\"\",\"\",'Data Capture Demand'!C41)","v":"Other"},{"$f":"'Data Capture Demand'!D41","v":0},{"$f":"'Data Capture Demand'!G41","v":0},{"$f":"SUM(E32*'Data Capture Demand'!F41)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,{"$f":"SUM(G32*J32%)+G32","v":1382.940756602427},0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C42=\"\",\"\",'Data Capture Demand'!C42)","v":"Other"},{"$f":"'Data Capture Demand'!D42","v":0},{"$f":"'Data Capture Demand'!G42","v":0},{"$f":"SUM(E33*'Data Capture Demand'!F42)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,{"$f":"SUM(G33*J33%)+G33","v":1382.940756602427},0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C43=\"\",\"\",'Data Capture Demand'!C43)","v":"Other"},{"$f":"'Data Capture Demand'!D43","v":0},{"$f":"'Data Capture Demand'!G43","v":0},{"$f":"SUM(E34*'Data Capture Demand'!F43)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,{"$f":"SUM(G34*J34%)+G34","v":1382.940756602427},0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C44=\"\",\"\",'Data Capture Demand'!C44)","v":"Other"},{"$f":"'Data Capture Demand'!D44","v":0},{"$f":"'Data Capture Demand'!G44","v":0},{"$f":"SUM(E35*'Data Capture Demand'!F44)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,{"$f":"SUM(G35*J35%)+G35","v":1382.940756602427},0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C45=\"\",\"\",'Data Capture Demand'!C45)","v":"Other"},{"$f":"'Data Capture Demand'!D45","v":0},{"$f":"'Data Capture Demand'!G45","v":0},{"$f":"SUM(E36*'Data Capture Demand'!F45)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,1382.940756602427,0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C46=\"\",\"\",'Data Capture Demand'!C46)","v":"Other"},{"$f":"'Data Capture Demand'!D46","v":0},{"$f":"'Data Capture Demand'!G46","v":0},{"$f":"SUM(E37*'Data Capture Demand'!F46)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,1382.940756602427,0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C47=\"\",\"\",'Data Capture Demand'!C47)","v":"Other"},{"$f":"'Data Capture Demand'!D47","v":0},{"$f":"'Data Capture Demand'!G47","v":0},{"$f":"SUM(E38*'Data Capture Demand'!F47)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,1382.940756602427,0,null,1382.940756602427,0]
[null,null,{"$f":"IF('Data Capture Demand'!C48=\"\",\"\",'Data Capture Demand'!C48)","v":"Other"},{"$f":"'Data Capture Demand'!D48","v":0},{"$f":"'Data Capture Demand'!G48","v":0},{"$f":"SUM(E39*'Data Capture Demand'!F48)","v":0},{"$f":"'Revised Primary Baseline Tariff'!$D$11","v":1382.940756602427},0,0,0,1382.940756602427,0,null,1382.940756602427,0]
[null,null,{"$f":"'Data Capture Demand'!C38&\" TOTAL\"","v":"INSTITUTIONAL TOTAL"},{"$f":"SUM(D30:D39)","v":22},null,{"$f":"SUM(F30:F39)","v":27500},null,{"$f":"SUM(H30:H39)","v":30424.696645253396},null,null,null,{"$f":"SUM(L30:L39)","v":30424.696645253396},null,null,{"$f":"SUM(O30:O39)","v":2924.6966452533952}]
[]
[null,null,"SUBTOTAL",null,null,{"$f":"SUM(F40+F29+F23+F13)","v":1167500},null,{"$f":"SUM(H40+H29+H23+H13)","v":1291666.6666666667},null,null,null,{"$f":"SUM(L40+L29+L23+L13)","v":1291666.6666666667},null,null,{"$f":"SUM(O40+O29+O23+O13)","v":124166.66666666677}]
[]
[null,null,"FULL COST",{"$f":"'Data Capture Costs'!E31","v":1291666.6666666667},"CURRENT ACTUAL",null,null,null,null,null,"ANTICIPATED"]
[null,null,null,null,"MONTHLY",null,"ANNUAL",null,null,null,"MONTHLY",null,"ANNUAL"]
[null,null,null,null,"Current Revenue",{"$f":"F42","v":1167500},{"$f":"F46*12","v":14010000},null,null,null,"Revised Revenue",{"$f":"L42+'Strategic Decisions'!J20","v":1291666.6666666667},{"$f":"L46*12","v":15500000}]
[null,null,null,null,"PROFIT\\LOSS",{"$f":"F46-D44","v":-124166.66666666674},{"$f":"F47*12","v":-1490000.0000000009},null,null,null,"PROFIT\\LOSS",{"$f":"L46-D44","v":0},{"$f":"L47*12","v":0}]