{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["INI-VAL","Yearly Costs","Financial State","BUSINESS AS USUAL","KPI","Financial Manager","RESULTS","WATER MANAGER","Yearly Decision","BENCH-MARKING","Commercial Manager","Operational Manager","Water Balance","EQ","Bench1","Calculations","Bench2","Bench3","Bench4"],"not_rendered":{"charts":33,"images":6,"macros":1,"external_links":0,"defined_names":4,"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":"row_number_cap","date_system":"1900"}

{"sheet":"INI-VAL","index":0,"n_rows":89,"n_cols":8,"rows_kept":89,"cut":false,"hidden":true,"merged":[[40,2,40,3],[25,5,25,7],[0,2,1,7],[4,2,4,3],[16,2,16,3],[4,5,4,7]]}
[null,null,"Initial Values"]
[]
[]
[]
[null,null,"Malawi ",null,"Source","Initial Indicators (2017)"]
[null,null,"Population (2012 est.)",14.8,"Malawi data sheet - PRB and MoEPD","Indicators","Unit","Value"]
[null,null,"Life expectancy (2008)",41.1,"2008 Census Main Report by Malawi NSO","Customer Satisfaction","Scale 1-10",7.5]
[null,null,"Population growth rate Lilonwge (2008 est.)",4.4000000000000004,"2008 Census Main Report by Malawi NSO","Working Ratio","Ratio",1.1000000000000001]
[null,null,"Population growth rate (2012 est.)",1.7999999999999999E-2,"Malawi data sheet - PRB and MoEPD","O&M In-efficiency Factor","Ratio",{"$f":"1.3","v":1.3}]
[null,null,"Urban population (2012)",2.2999999999999998,"Malawi data sheet - PRB and MoEPD","Full recovery ratio","Ratio",0.73]
[null,null,"GDP per capita (PPP) (2015 est.)",1100,"CIA World Factbook 2015","Cash ratio","Ratio",0.2]
[null,null,"Inflation Annual Rate (2015 est.)",0.03,"CIA World Factbook 2015","Commercial water losses","Percentage of water produced",0.15]
[null,null,"Mortality rate of children under five","112/1000","2010 Malawi Demographic and Health Survey","Loan","Number",{"$f":"'Yearly Decision'!E81","v":15000000}]
[null,null,"Literacy rate",64,"2008 Census Main Report by Malawi NSO","Affordability of tariffs","% of GDP",0.05]
[null,null,"Drought factor (year 5-7)",0.75,null,"Awareness to pay","%",0.7]
[null,null,null,null,null,"Collection efficiency","Percentage of bills collected",0.75]
[null,null,"Staff of Macondo Utility (2008)",null,null,"Physical water losses","Percentage of water produced ",0.3]
[null,null,"Departments","Number of Staff",null,"Physical water Inefficiency Factor",null,1.4]
[null,null,"Directors",19,null,"Continuity","Hours of service per day",17]
[null,null,"Managers",65,null,"Water quality","Percentage of samples adhering to set standards",0.7]
[null,null,"Operational Staff",null,null,"Coverage","Percentage of the total population ",{"$f":"(H29*H54+H49*H55)/H28","v":0.78584107932664637}]
[null,null,"Workers (Operations)",130,null,"Meter Error","Percentage error by meters ",0.1]
[null,null,"Bill Collectors",26,null,"Illegal Connections","Percentage of illegal connections based on inhouse cxns",0.05]
[null,null,"Costumer Sevices Employees",91,null,"Own Consumption","Percentage necessary for production",0.01]
[null,null,"Total Employees",{"$f":"SUM(D19:D24)","v":331}]
[null,null,null,null,null,"Initial Lilongwe Facts (2012)"]
[null,null,60000,null,null,"Item","Unit","Value"]
[null,null,30000,null,null,"Population","Number of Inhabitants",1077116]
[null,null,6000,null,null,"Connections In-house","Number of total legal in-house connections",50639]
[null,null,6000,null,null,"Household consumption","m3 per connection/month",20.52]
[null,null,6000,null,null,"Water Kiosk Consumption","m3 per Water Kiosk/month",296.10000000000002]
[null,null,null,null,null,"Un-metered consumption","m3 per connection/month",30.78]
[null,null,null,null,null,"Unitary Consumption","m3 per connection/month",14.8]
[null,null,null,null,null,"Total Billed Consumption","m3 billed by the utility/month",{"$f":"H31*H49+H30*H48+H32*H50","v":1572572.1600000001}]
[null,null,null,null,null,"GDP","US$ per capita",3004]
[null,null,null,null,null,"Subsidy on connections","% of connection cost",0.4]
[null,null,null,null,null,"Inhouse Tariff ","US$ per m3",0.61]
[null,null,null,null,null,"Waterkiosk Tariff","US$ per m3",1.04]
[null,null,null,null,null,"Un-metered connection Tariff","US$ per connection / year",150.21]
[null,null,null,null,null,"Min. Tariff (2009)","US$ per month",2.67]
[null,null,"Specifications on Meters",null,null,"Produced Volume","m3/year",34936340]
[null,"Type","Cost","Error margin",null,"Resource Volume ","m3/year",{"$f":"H41","v":34936340}]
[null,"A",200,0.02,null,"Treatment Capacity","m3/year",{"$f":"H41","v":34936340}]
[null,"B",150,0.05,null,"Total Water Demand from consumers","m3/year",{"$f":"(H30*H48+H31*H49+H32*H50)/(H17+H12)*12","v":41935257.600000009}]
[null,"C",100,0.08,null,"Assets value","US$",68750000]
[null,null,null,null,null,"Network Size","km",1051]
[null,null,null,null,null,"Number Of Meters Total","No.",{"$f":"H48+H49","v":17337}]
[null,null,null,null,null,"Number Of Meters Inhouse","No.",16711]
[null,null,null,null,null,"Number of Water Kiosks","No. ",626]
[null,null,null,null,null,"Number of Un-metered connections","No.",{"$f":"H29-H48","v":33928}]
[null,null,null,null,null,"% to In-house connections","% of water consumed",{"$f":"(H30*H48+H32*H50)/H34","v":0.88213030554985783}]
[null,null,null,null,null,"% to Waterkiosk","% of water consumed",{"$f":"(H31*H49)/H34","v":0.11786969445014212}]
[null,null,null,null,null,"Consumer Awareness","Unit (1-10)",7]
[null,null,null,null,null,"People served In-house","No of people served",8]
[null,null,null,null,null,"People served Waterkiosk","No of people served",705]
[null,null,null,null,null,"Consumption pp for metered","l/c/d",{"$f":"H30*1000/(30*H54)","v":85.5}]
[null,null,null,null,null,"Consumption pp for Waterkiosk","l/c/d",{"$f":"H31*1000/(30*H55)","v":14}]
[null,null,null,null,null,"Consumption pp for un-metered","l/c/d",{"$f":"H32*1000/(30*H54)","v":128.25}]
[null,null,null,null,null,"Grant Value for Game","USD",65000000]
[null,"B","C","D","E"]
[61,"Staff 'Golden' Ratios"]
[62,"Ratio","Optimal","Initial values","Minimum"]
[63,"Director to Manager",{"$f":"1/5","v":0.2},{"$f":"D19/D20","v":0.29230769230769232},{"$f":"C63/2","v":0.1}]
[64,"Management to Workers",{"$f":"1/8","v":0.125},{"$f":"(D19+D20)/SUM(D22:D24)","v":0.34008097165991902},{"$f":"C64/2","v":6.25E-2}]
[65,"Workers to Network Size (km)",0.16800000000000001,{"$f":"D22/H46","v":0.12369172216936251},5.2999999999999999E-2]
[66,"Workers to Treatment Capacity (m3)",5.3000000000000001E-6,{"$f":"D22/H43","v":3.7210537795315708E-6},1.3E-6]
[67,"Bill Collectors to # of Connections",6.8499999999999995E-4,{"$f":"D23/H29","v":5.1343825904934931E-4},1.7100000000000001E-4]
[68,"Customer Service to # of Connections",2.7650000000000001E-3,{"$f":"D24/H29","v":1.7970339066727225E-3},6.9099999999999999E-4]
[69,"Process 'Golden' Ratios"]
[70,"Trainees / Staff / 4 years",1,0,0]
[71,"SOP's /  3 years",5,0,0]
[72,"Office packages / year",2,0,0]
[73,"Awareness Campaigns / year",1,0,0]
[74,"Leakage Trainees / Op. Staff / 4 years",1,0,0]
[null,"Maintenance to Network",1,0,0.1,"5 years"]
[null,"Maintenance to Resources",1,0,0.1,"5 years"]
[null,"Maintenance to Treatment",1,0,0.1,"5 years"]
[]
[null,"Based on World Bank recs.","Min Staff/1000 cxns","Max staff/1000 cxns",null,"Initial","In game min","In game max"]
[null,"Staff distribution",{"$f":"SUM(C81:C85)","v":5},{"$f":"SUM(D81:D85)","v":8},{"$f":"ROUND(C80*($F$89/1000),0)","v":256},{"$f":"ROUND(D80*($F$89/1000),0)","v":410},{"$f":"C80*$H$29/1000","v":253.19499999999999},405.11200000000002]
[null,"Director",0.16666666666666666,{"$f":"1/6","v":0.16666666666666666},{"$f":"ROUND(C81*($F$89/1000),0)","v":9},{"$f":"ROUND(D81*($F$89/1000),0)","v":9},8.4398333333333326,8.4398333333333326]
[null,"Manager",0.83333333333333337,{"$f":"5/6","v":0.83333333333333337},43,{"$f":"ROUND(D82*($F$89/1000),0)","v":43},42.19916666666667,42.19916666666667]
[null,"Worker",{"$f":"16/7","v":2.2857142857142856},4,117,{"$f":"ROUND(D83*($F$89/1000),0)","v":205},115.7462857142857,202.55600000000001]
[null,"Bill Collector",{"$f":"8/7","v":1.1428571428571428},2,59,{"$f":"ROUND(D84*($F$89/1000),0)","v":103},57.873142857142852,101.27800000000001]
[null,"Costumer Service",{"$f":"4/7","v":0.5714285714285714},1,29,{"$f":"ROUND(D85*($F$89/1000),0)","v":51},28.936571428571426,50.639000000000003]
[]
[]
[]
[null,null,null,null,null,51265,"Total CXNS initial"]

{"sheet":"Yearly Costs","index":1,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[null,null,null,"Unitary Cost","Actual Value","Turn 1","Turn 2","Turn 3","Turn 4","Turn 5","Turn 6","Turn 7","Turn 8","Turn 9","Turn 10","Utilisation US$"]
[null,1,"Financial "]
[null,1.1000000000000001,"Subsidy (for connection fee)",150,{"$f":"$D$6*'Yearly Decision'!E6*Calculations!D10","v":3038340},{"$f":"$D$6*(1-'Yearly Decision'!F6)*(Calculations!E10-Calculations!D10)","v":0},{"$f":"$D$6*('Yearly Decision'!G6)*(Calculations!F10-Calculations!E10)","v":0},{"$f":"$D$6*('Yearly Decision'!H6)*(Calculations!G10-Calculations!F10)","v":0},{"$f":"$D$6*('Yearly Decision'!I6)*(Calculations!H10-Calculations!G10)","v":0},{"$f":"$D$6*('Yearly Decision'!J6)*(Calculations!I10-Calculations!H10)","v":0},{"$f":"$D$6*('Yearly Decision'!K6)*(Calculations!J10-Calculations!I10)","v":0},{"$f":"$D$6*('Yearly Decision'!L6)*(Calculations!K10-Calculations!J10)","v":0},{"$f":"$D$6*('Yearly Decision'!M6)*(Calculations!L10-Calculations!K10)","v":0},{"$f":"$D$6*('Yearly Decision'!N6)*(Calculations!M10-Calculations!L10)","v":0},{"$f":"$D$6*('Yearly Decision'!O6)*(Calculations!N10-Calculations!M10)","v":0},{"$f":"SUM(F6:O6)","v":0}]
[null,1.2,"In-house Tariff",{"$f":"'INI-VAL'!H37","v":0.61},{"$f":"'Yearly Decision'!E7","v":0.61},{"$f":"'Yearly Decision'!F7","v":0},{"$f":"'Yearly Decision'!G7","v":0},{"$f":"'Yearly Decision'!H7","v":0},{"$f":"'Yearly Decision'!I7","v":0},{"$f":"'Yearly Decision'!J7","v":0},{"$f":"'Yearly Decision'!K7","v":0},{"$f":"'Yearly Decision'!L7","v":0},{"$f":"'Yearly Decision'!M7","v":0},{"$f":"'Yearly Decision'!N7","v":0},{"$f":"'Yearly Decision'!O7","v":0},{"$f":"SUM(F7:O7)","v":0}]
[null,1.3,"StandPipe Tariff",{"$f":"'INI-VAL'!H38","v":1.04},{"$f":"'Yearly Decision'!E8","v":1.04},{"$f":"'Yearly Decision'!F8","v":0},{"$f":"'Yearly Decision'!G8","v":0},{"$f":"'Yearly Decision'!H8","v":0},{"$f":"'Yearly Decision'!I8","v":0},{"$f":"'Yearly Decision'!J8","v":0},{"$f":"'Yearly Decision'!K8","v":0},{"$f":"'Yearly Decision'!L8","v":0},{"$f":"'Yearly Decision'!M8","v":0},{"$f":"'Yearly Decision'!N8","v":0},{"$f":"'Yearly Decision'!O8","v":0}]
[null,1.4,"Un-metered Connection Tariff",{"$f":"'INI-VAL'!H39","v":150.21},{"$f":"'Yearly Decision'!E9","v":150.21},{"$f":"'Yearly Decision'!F9","v":0},{"$f":"'Yearly Decision'!G9","v":0},{"$f":"'Yearly Decision'!H9","v":0},{"$f":"'Yearly Decision'!I9","v":0},{"$f":"'Yearly Decision'!J9","v":0},{"$f":"'Yearly Decision'!K9","v":0},{"$f":"'Yearly Decision'!L9","v":0},{"$f":"'Yearly Decision'!M9","v":0},{"$f":"'Yearly Decision'!N9","v":0},{"$f":"'Yearly Decision'!O9","v":0}]
[null,2,"Infraestructure"]
[null,2.1,"Additional Water Kiosk",10000,{"$f":"D11*'Yearly Decision'!E11","v":6260000},{"$f":"$D$11*'Yearly Decision'!F11","v":0},{"$f":"$D$11*'Yearly Decision'!G11","v":0},{"$f":"$D$11*'Yearly Decision'!H11","v":0},{"$f":"$D$11*'Yearly Decision'!I11","v":0},{"$f":"$D$11*'Yearly Decision'!J11","v":0},{"$f":"$D$11*'Yearly Decision'!K11","v":0},{"$f":"$D$11*'Yearly Decision'!L11","v":0},{"$f":"$D$11*'Yearly Decision'!M11","v":0},{"$f":"$D$11*'Yearly Decision'!N11","v":0},{"$f":"$D$11*'Yearly Decision'!O11","v":0},{"$f":"SUM(F11:O11)","v":0}]
[null,2.2000000000000002,"Additional Network",22700,{"$f":"D12*'Yearly Decision'!E12","v":23857700},{"$f":"$D$12*'Yearly Decision'!F12","v":0},{"$f":"$D$12*'Yearly Decision'!G12","v":0},{"$f":"$D$12*'Yearly Decision'!H12","v":0},{"$f":"$D$12*'Yearly Decision'!I12","v":0},{"$f":"$D$12*'Yearly Decision'!J12","v":0},{"$f":"$D$12*'Yearly Decision'!K12","v":0},{"$f":"$D$12*'Yearly Decision'!L12","v":0},{"$f":"$D$12*'Yearly Decision'!M12","v":0},{"$f":"$D$12*'Yearly Decision'!N12","v":0},{"$f":"$D$12*'Yearly Decision'!O12","v":0},{"$f":"SUM(F12:O12)","v":0}]
[null,2.2999999999999998,"Additional Water Treatment Capacity",0.33,{"$f":"D13*'Yearly Decision'!E13","v":11528992.200000001},{"$f":"$D$13*'Yearly Decision'!F13","v":0},{"$f":"$D$13*'Yearly Decision'!G13","v":0},{"$f":"$D$13*'Yearly Decision'!H13","v":0},{"$f":"$D$13*'Yearly Decision'!I13","v":0},{"$f":"$D$13*'Yearly Decision'!J13","v":0},{"$f":"$D$13*'Yearly Decision'!K13","v":0},{"$f":"$D$13*'Yearly Decision'!L13","v":0},{"$f":"$D$13*'Yearly Decision'!M13","v":0},{"$f":"$D$13*'Yearly Decision'!N13","v":0},{"$f":"$D$13*'Yearly Decision'!O13","v":0},{"$f":"SUM(F13:O13)","v":0}]
[null,2.4,"Additional Water Resources Abstracted",0.11,{"$f":"D14*'Yearly Decision'!E14","v":3842997.4},{"$f":"$D$14*'Yearly Decision'!F14","v":0},{"$f":"$D$14*'Yearly Decision'!G14","v":0},{"$f":"$D$14*'Yearly Decision'!H14","v":0},{"$f":"$D$14*'Yearly Decision'!I14","v":0},{"$f":"$D$14*'Yearly Decision'!J14","v":0},{"$f":"$D$14*'Yearly Decision'!K14","v":0},{"$f":"$D$14*'Yearly Decision'!L14","v":0},{"$f":"$D$14*'Yearly Decision'!M14","v":0},{"$f":"$D$14*'Yearly Decision'!N14","v":0},{"$f":"$D$14*'Yearly Decision'!O14","v":0},{"$f":"SUM(F14:O14)","v":0}]
[null,2.5,"Additional Number of Meters","Varies by meter",{"$f":"D15*'Yearly Decision'!E17","v":{"$error":"#VALUE!"}},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!F17+'INI-VAL'!$C$44*'Yearly Decision'!F16+'INI-VAL'!$C$43*'Yearly Decision'!F15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!G17+'INI-VAL'!$C$44*'Yearly Decision'!G16+'INI-VAL'!$C$43*'Yearly Decision'!G15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!H17+'INI-VAL'!$C$44*'Yearly Decision'!H16+'INI-VAL'!$C$43*'Yearly Decision'!H15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!I17+'INI-VAL'!$C$44*'Yearly Decision'!I16+'INI-VAL'!$C$43*'Yearly Decision'!I15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!J17+'INI-VAL'!$C$44*'Yearly Decision'!J16+'INI-VAL'!$C$43*'Yearly Decision'!J15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!K17+'INI-VAL'!$C$44*'Yearly Decision'!K16+'INI-VAL'!$C$43*'Yearly Decision'!K15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!L17+'INI-VAL'!$C$44*'Yearly Decision'!L16+'INI-VAL'!$C$43*'Yearly Decision'!L15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!M17+'INI-VAL'!$C$44*'Yearly Decision'!M16+'INI-VAL'!$C$43*'Yearly Decision'!M15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!N17+'INI-VAL'!$C$44*'Yearly Decision'!N16+'INI-VAL'!$C$43*'Yearly Decision'!N15","v":0},{"$f":"'INI-VAL'!$C$45*'Yearly Decision'!O17+'INI-VAL'!$C$44*'Yearly Decision'!O16+'INI-VAL'!$C$43*'Yearly Decision'!O15","v":0},{"$f":"SUM(F15:O15)","v":0}]
[null,3,"Staff"]
[null,3.1,"Additional Director",{"$f":"'INI-VAL'!C27","v":60000},{"$f":"D17*'Yearly Decision'!E19","v":1140000},{"$f":"$D$17*'Yearly Decision'!F19","v":0},{"$f":"$D$17*'Yearly Decision'!G19","v":0},{"$f":"$D$17*'Yearly Decision'!H19","v":0},{"$f":"$D$17*'Yearly Decision'!I19","v":0},{"$f":"$D$17*'Yearly Decision'!J19","v":0},{"$f":"$D$17*'Yearly Decision'!K19","v":0},{"$f":"$D$17*'Yearly Decision'!L19","v":0},{"$f":"$D$17*'Yearly Decision'!M19","v":0},{"$f":"$D$17*'Yearly Decision'!N19","v":0},{"$f":"$D$17*'Yearly Decision'!O19","v":0},{"$f":"SUM(F17:O17)","v":0}]
[null,3.2,"Additional Manager",{"$f":"'INI-VAL'!C28","v":30000},{"$f":"D18*'Yearly Decision'!E20","v":1950000},{"$f":"$D$18*'Yearly Decision'!F20","v":0},{"$f":"$D$18*'Yearly Decision'!G20","v":0},{"$f":"$D$18*'Yearly Decision'!H20","v":0},{"$f":"$D$18*'Yearly Decision'!I20","v":0},{"$f":"$D$18*'Yearly Decision'!J20","v":0},{"$f":"$D$18*'Yearly Decision'!K20","v":0},{"$f":"$D$18*'Yearly Decision'!L20","v":0},{"$f":"$D$18*'Yearly Decision'!M20","v":0},{"$f":"$D$18*'Yearly Decision'!N20","v":0},{"$f":"$D$18*'Yearly Decision'!O20","v":0},{"$f":"SUM(F18:O18)","v":0}]
[null,3.3,"Additional Workers",{"$f":"'INI-VAL'!C29","v":6000},{"$f":"D19*'Yearly Decision'!E21","v":780000},{"$f":"$D$19*'Yearly Decision'!F21","v":0},{"$f":"$D$19*'Yearly Decision'!G21","v":0},{"$f":"$D$19*'Yearly Decision'!H21","v":0},{"$f":"$D$19*'Yearly Decision'!I21","v":0},{"$f":"$D$19*'Yearly Decision'!J21","v":0},{"$f":"$D$19*'Yearly Decision'!K21","v":0},{"$f":"$D$19*'Yearly Decision'!L21","v":0},{"$f":"$D$19*'Yearly Decision'!M21","v":0},{"$f":"$D$19*'Yearly Decision'!N21","v":0},{"$f":"$D$19*'Yearly Decision'!O21","v":0},{"$f":"SUM(F19:O19)","v":0}]
[null,3.4,"Additional Bill Collectors",{"$f":"'INI-VAL'!C30","v":6000},{"$f":"D20*'Yearly Decision'!E22","v":156000},{"$f":"$D$20*'Yearly Decision'!F22","v":0},{"$f":"$D$20*'Yearly Decision'!G22","v":0},{"$f":"$D$20*'Yearly Decision'!H22","v":0},{"$f":"$D$20*'Yearly Decision'!I22","v":0},{"$f":"$D$20*'Yearly Decision'!J22","v":0},{"$f":"$D$20*'Yearly Decision'!K22","v":0},{"$f":"$D$20*'Yearly Decision'!L22","v":0},{"$f":"$D$20*'Yearly Decision'!M22","v":0},{"$f":"$D$20*'Yearly Decision'!N22","v":0},{"$f":"$D$20*'Yearly Decision'!O22","v":0},{"$f":"SUM(F20:O20)","v":0}]
[null,3.5,"Additional Costumer Sevices Employees",{"$f":"'INI-VAL'!C31","v":6000},{"$f":"D21*'Yearly Decision'!E23","v":546000},{"$f":"$D$21*'Yearly Decision'!F23","v":0},{"$f":"$D$21*'Yearly Decision'!G23","v":0},{"$f":"$D$21*'Yearly Decision'!H23","v":0},{"$f":"$D$21*'Yearly Decision'!I23","v":0},{"$f":"$D$21*'Yearly Decision'!J23","v":0},{"$f":"$D$21*'Yearly Decision'!K23","v":0},{"$f":"$D$21*'Yearly Decision'!L23","v":0},{"$f":"$D$21*'Yearly Decision'!M23","v":0},{"$f":"$D$21*'Yearly Decision'!N23","v":0},{"$f":"$D$21*'Yearly Decision'!O23","v":0},{"$f":"SUM(F21:O21)","v":0}]
[null,4,"Maintenance"]
[null,4.0999999999999996,"Rehabilitated Network",20000,{"$f":"D23*'Yearly Decision'!E25*'Yearly Decision'!E12","v":0},{"$f":"'Yearly Decision'!F25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!G25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!H25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!I25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!J25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!K25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!L25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!M25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!N25*'Yearly Costs'!$D$23","v":0},{"$f":"'Yearly Decision'!O25*'Yearly Costs'!$D$23","v":0},{"$f":"SUM(F23:O23)","v":0}]
[null,4.2,"Treatment Maintenance",1.2E-2,{"$f":"D24*'Yearly Decision'!E26*'Yearly Decision'!E13","v":0},{"$f":"$D$24*'Yearly Decision'!F26","v":0},{"$f":"$D$24*'Yearly Decision'!G26","v":0},{"$f":"$D$24*'Yearly Decision'!H26","v":0},{"$f":"$D$24*'Yearly Decision'!I26","v":0},{"$f":"$D$24*'Yearly Decision'!J26","v":0},{"$f":"$D$24*'Yearly Decision'!K26","v":0},{"$f":"$D$24*'Yearly Decision'!L26","v":0},{"$f":"$D$24*'Yearly Decision'!M26","v":0},{"$f":"$D$24*'Yearly Decision'!N26","v":0},{"$f":"$D$24*'Yearly Decision'!O26","v":0},{"$f":"SUM(F24:O24)","v":0}]
[null,4.3,"Resources Maintenance",3.8E-3,{"$f":"D25*'Yearly Decision'!E27*'Yearly Decision'!E14","v":0},{"$f":"$D$25*'Yearly Decision'!F27","v":0},{"$f":"$D$25*'Yearly Decision'!G27","v":0},{"$f":"$D$25*'Yearly Decision'!H27","v":0},{"$f":"$D$25*'Yearly Decision'!I27","v":0},{"$f":"$D$25*'Yearly Decision'!J27","v":0},{"$f":"$D$25*'Yearly Decision'!K27","v":0},{"$f":"$D$25*'Yearly Decision'!L27","v":0},{"$f":"$D$25*'Yearly Decision'!M27","v":0},{"$f":"$D$25*'Yearly Decision'!N27","v":0},{"$f":"$D$25*'Yearly Decision'!O27","v":0},{"$f":"$D$25*'Yearly Decision'!P27","v":0}]
[null,4.4000000000000004,"Meter Calibration Program",10,{"$f":"D26*'Yearly Decision'!E28","v":0},{"$f":"'Yearly Decision'!F28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!G28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!H28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!I28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!J28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!K28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!L28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!M28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!N28*'Yearly Costs'!$D26","v":0},{"$f":"'Yearly Decision'!O28*'Yearly Costs'!$D26","v":0},{"$f":"SUM(F26:O26)","v":0}]
[null,5,"Capacity Development"]
[null,5.0999999999999996,"Additional Leakage Trainees",750,{"$f":"$D28*'Yearly Decision'!E30","v":0},{"$f":"$D28*'Yearly Decision'!F30","v":0},{"$f":"$D28*'Yearly Decision'!G30","v":0},{"$f":"$D28*'Yearly Decision'!H30","v":0},{"$f":"$D28*'Yearly Decision'!I30","v":0},{"$f":"$D28*'Yearly Decision'!J30","v":0},{"$f":"$D28*'Yearly Decision'!K30","v":0},{"$f":"$D28*'Yearly Decision'!L30","v":0},{"$f":"$D28*'Yearly Decision'!M30","v":0},{"$f":"$D28*'Yearly Decision'!N30","v":0},{"$f":"$D28*'Yearly Decision'!O30","v":0},{"$f":"SUM(F28:O28)","v":0}]
[null,5.2,"Additional Staff training",1000,{"$f":"$D29*'Yearly Decision'!E31","v":0},{"$f":"$D29*'Yearly Decision'!F31","v":0},{"$f":"$D29*'Yearly Decision'!G31","v":0},{"$f":"$D29*'Yearly Decision'!H31","v":0},{"$f":"$D29*'Yearly Decision'!I31","v":0},{"$f":"$D29*'Yearly Decision'!J31","v":0},{"$f":"$D29*'Yearly Decision'!K31","v":0},{"$f":"$D29*'Yearly Decision'!L31","v":0},{"$f":"$D29*'Yearly Decision'!M31","v":0},{"$f":"$D29*'Yearly Decision'!N31","v":0},{"$f":"$D29*'Yearly Decision'!O31","v":0},0]
[null,5.3,"Additional Office technology",5000,{"$f":"$D30*'Yearly Decision'!E32","v":0},{"$f":"$D30*'Yearly Decision'!F32","v":0},{"$f":"$D30*'Yearly Decision'!G32","v":0},{"$f":"$D30*'Yearly Decision'!H32","v":0},{"$f":"$D30*'Yearly Decision'!I32","v":0},{"$f":"$D30*'Yearly Decision'!J32","v":0},{"$f":"$D30*'Yearly Decision'!K32","v":0},{"$f":"$D30*'Yearly Decision'!L32","v":0},{"$f":"$D30*'Yearly Decision'!M32","v":0},{"$f":"$D30*'Yearly Decision'!N32","v":0},{"$f":"$D30*'Yearly Decision'!O32","v":0},0]
[null,5.4,"SOPs",10000,{"$f":"$D31*'Yearly Decision'!E33","v":0},{"$f":"$D31*'Yearly Decision'!F33","v":0},{"$f":"$D31*'Yearly Decision'!G33","v":0},{"$f":"$D31*'Yearly Decision'!H33","v":0},{"$f":"$D31*'Yearly Decision'!I33","v":0},{"$f":"$D31*'Yearly Decision'!J33","v":0},{"$f":"$D31*'Yearly Decision'!K33","v":0},{"$f":"$D31*'Yearly Decision'!L33","v":0},{"$f":"$D31*'Yearly Decision'!M33","v":0},{"$f":"$D31*'Yearly Decision'!N33","v":0},{"$f":"$D31*'Yearly Decision'!O33","v":0},0]
[null,5.5,"Awareness Campaigns",5000,{"$f":"$D32*'Yearly Decision'!E34","v":0},{"$f":"$D32*'Yearly Decision'!F34","v":0},{"$f":"$D32*'Yearly Decision'!G34","v":0},{"$f":"$D32*'Yearly Decision'!H34","v":0},{"$f":"$D32*'Yearly Decision'!I34","v":0},{"$f":"$D32*'Yearly Decision'!J34","v":0},{"$f":"$D32*'Yearly Decision'!K34","v":0},{"$f":"$D32*'Yearly Decision'!L34","v":0},{"$f":"$D32*'Yearly Decision'!M34","v":0},{"$f":"$D32*'Yearly Decision'!N34","v":0},{"$f":"$D32*'Yearly Decision'!O34","v":0},0]
[]
[]
[]
[null,null,"Total",null,null,{"$f":"F11+F12+F13+F14+F15+F17+F18+F19+F20+F21+F23+F24+F25+F26+F28+F29+F30+F31+F32","v":0},{"$f":"G11+G12+G13+G14+G15+G17+G18+G19+G20+G21+G23+G24+G25+G26+G28+G29+G30+G31+G32","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Financial State","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,{"$f":"YEAR(TODAY())","v":2018},{"$f":"E3+1","v":2019},{"$f":"F3+1","v":2020},{"$f":"G3+1","v":2021},{"$f":"H3+1","v":2022},{"$f":"I3+1","v":2023},{"$f":"J3+1","v":2024},{"$f":"K3+1","v":2025},{"$f":"L3+1","v":2026},{"$f":"M3+1","v":2027}]
[null,null,null,"Initial Value","Turn 1","Turn 2","Turn 3","Turn 4","Turn 5","Turn 6","Turn 7","Turn 8","Turn 9","Turn 10","Total US$"]
[null,null,"Total Income",{"$f":"SUM(D6:D8)","v":8310699.3931939173},{"$f":"SUM(E6:E8)","v":7522107.5128564816},7350209.6123767011,7130856.1690544784,6896953.9945706809,5919527.40916951,5724512.9308145419,5527775.4013182037,5904342.9432617556,5654597.0973369759,10790288.838286454,{"$f":"SUM(E5:N5)","v":68421171.909045786}]
[null,null,"In-house Connection",{"$f":"Calculations!D117*Calculations!D13/Calculations!D10*Calculations!D4*Calculations!D81","v":2378986.1622876395},{"$f":"Calculations!E117*Calculations!E13/Calculations!E10*Calculations!E4*Calculations!E81","v":1973278.021181429},{"$f":"Calculations!F117*Calculations!F13/Calculations!F10*Calculations!F4*Calculations!F81","v":1879666.0679995869},{"$f":"Calculations!G117*Calculations!G13/Calculations!G10*Calculations!G4*Calculations!G81","v":1769648.6775613152},{"$f":"Calculations!H117*Calculations!H13/Calculations!H10*Calculations!H4*Calculations!H81","v":1655368.6645626891},{"$f":"Calculations!I117*Calculations!I13/Calculations!I10*Calculations!I4*Calculations!I81","v":1153306.800604471},{"$f":"Calculations!J117*Calculations!J13/Calculations!J10*Calculations!J4*Calculations!J81","v":1065895.1479839261},{"$f":"Calculations!K117*Calculations!K13/Calculations!K10*Calculations!K4*Calculations!K81","v":979123.37972146284},{"$f":"Calculations!L117*Calculations!L13/Calculations!L10*Calculations!L4*Calculations!L81","v":1191778.4275042978},{"$f":"Calculations!M117*Calculations!M13/Calculations!M10*Calculations!M4*Calculations!M81","v":1078746.6964140013},{"$f":"Calculations!N117*Calculations!N13/Calculations!N10*Calculations!N4*Calculations!N81","v":3636564.6552014146},{"$f":"SUM(E6:N6)","v":16383376.538734592}]
[null,null,"Standpipe Connection",{"$f":"Calculations!D120*Calculations!D82*Calculations!D5","v":2312628.4723056322},{"$f":"Calculations!E120*Calculations!E82*Calculations!E5","v":1905440.9750677419},{"$f":"Calculations!F120*Calculations!F82*Calculations!F5","v":1803182.964513283},{"$f":"Calculations!G120*Calculations!G82*Calculations!G5","v":1700924.9539588238},{"$f":"Calculations!H120*Calculations!H82*Calculations!H5","v":1598666.9434043649},{"$f":"Calculations!I120*Calculations!I82*Calculations!I5","v":1142791.2997653843},{"$f":"Calculations!J120*Calculations!J82*Calculations!J5","v":1064912.3875853824},{"$f":"Calculations!K120*Calculations!K82*Calculations!K5","v":987033.47540538083},{"$f":"Calculations!L120*Calculations!L82*Calculations!L5","v":1190423.4800910316},{"$f":"Calculations!M120*Calculations!M82*Calculations!M5","v":1088165.4695365727},{"$f":"Calculations!N120*Calculations!N82*Calculations!N5","v":3580171.6823602314},{"$f":"SUM(E7:N7)","v":16061713.631688196}]
[null,null,"Non-metered Connection",{"$f":"Calculations!D6*Calculations!D14*Calculations!D83","v":3619084.7586006462},{"$f":"Calculations!E6*Calculations!E14*Calculations!E83","v":3643388.5166073106},{"$f":"Calculations!F6*Calculations!F14*Calculations!F83","v":3667360.5798638309},{"$f":"Calculations!G6*Calculations!G14*Calculations!G83","v":3660282.5375343394},{"$f":"Calculations!H6*Calculations!H14*Calculations!H83","v":3642918.3866036269},{"$f":"Calculations!I6*Calculations!I14*Calculations!I83","v":3623429.3087996547},{"$f":"Calculations!J6*Calculations!J14*Calculations!J83","v":3593705.395245234},{"$f":"Calculations!K6*Calculations!K14*Calculations!K83","v":3561618.5461913594},{"$f":"Calculations!L6*Calculations!L14*Calculations!L83","v":3522141.0356664262},{"$f":"Calculations!M6*Calculations!M14*Calculations!M83","v":3487684.9313864019},{"$f":"Calculations!N6*Calculations!N14*Calculations!N83","v":3573552.5007248069},35976081.738622993]
[]
[null,null,"Costs",{"$f":"D11+D19+D25","v":11447000},{"$f":"E11+E19+E25","v":14015435.360873464},{"$f":"F11+F19+F25","v":14543683.093399335},15095126.598051973,15670682.198199708,16268968.808383247,16893163.801199421,17544283.221657015,18225928.466072258,18936797.370252922,19678029.873064958,166872098.7911543]
[null,null,"Staff Cost",{"$f":"SUM(D12:D17)","v":4572000},{"$f":"SUM(E12:E17)","v":4572000},4572000,4572000,4572000,4572000,4572000,4572000,4572000,4572000,4572000,{"$f":"SUM(E11:N11)","v":45720000}]
[null,null,"Director",{"$f":"Calculations!D31","v":1140000},{"$f":"Calculations!E31","v":1140000},{"$f":"Calculations!F31","v":1140000},{"$f":"Calculations!G31","v":1140000},{"$f":"Calculations!H31","v":1140000},{"$f":"Calculations!I31","v":1140000},{"$f":"Calculations!J31","v":1140000},{"$f":"Calculations!K31","v":1140000},{"$f":"Calculations!L31","v":1140000},{"$f":"Calculations!M31","v":1140000},{"$f":"Calculations!N31","v":1140000}]
[null,null,"Manager",{"$f":"Calculations!D32","v":1950000},{"$f":"Calculations!E32","v":1950000},{"$f":"Calculations!F32","v":1950000},{"$f":"Calculations!G32","v":1950000},{"$f":"Calculations!H32","v":1950000},{"$f":"Calculations!I32","v":1950000},{"$f":"Calculations!J32","v":1950000},{"$f":"Calculations!K32","v":1950000},{"$f":"Calculations!L32","v":1950000},{"$f":"Calculations!M32","v":1950000},{"$f":"Calculations!N32","v":1950000}]
[null,null,"Workers",{"$f":"Calculations!D33","v":780000},{"$f":"Calculations!E33","v":780000},{"$f":"Calculations!F33","v":780000},{"$f":"Calculations!G33","v":780000},{"$f":"Calculations!H33","v":780000},{"$f":"Calculations!I33","v":780000},{"$f":"Calculations!J33","v":780000},{"$f":"Calculations!K33","v":780000},{"$f":"Calculations!L33","v":780000},{"$f":"Calculations!M33","v":780000},{"$f":"Calculations!N33","v":780000}]
[null,null,"Bill Collectors",{"$f":"Calculations!D34","v":156000},{"$f":"Calculations!E34","v":156000},{"$f":"Calculations!F34","v":156000},{"$f":"Calculations!G34","v":156000},{"$f":"Calculations!H34","v":156000},{"$f":"Calculations!I34","v":156000},{"$f":"Calculations!J34","v":156000},{"$f":"Calculations!K34","v":156000},{"$f":"Calculations!L34","v":156000},{"$f":"Calculations!M34","v":156000},{"$f":"Calculations!N34","v":156000}]
[null,null,"Costumer Sevices Employees",{"$f":"Calculations!D35","v":546000},{"$f":"Calculations!E35","v":546000},{"$f":"Calculations!F35","v":546000},{"$f":"Calculations!G35","v":546000},{"$f":"Calculations!H35","v":546000},{"$f":"Calculations!I35","v":546000},{"$f":"Calculations!J35","v":546000},{"$f":"Calculations!K35","v":546000},{"$f":"Calculations!L35","v":546000},{"$f":"Calculations!M35","v":546000},{"$f":"Calculations!N35","v":546000}]
[null,null,"Fired Pesonel",{"$f":"Calculations!D36","v":0},{"$f":"Calculations!E36","v":0},{"$f":"Calculations!F36","v":0},{"$f":"Calculations!G36","v":0},{"$f":"Calculations!H36","v":0},{"$f":"Calculations!I36","v":0},{"$f":"Calculations!J36","v":0},{"$f":"Calculations!K36","v":0},{"$f":"Calculations!L36","v":0},{"$f":"Calculations!M36","v":0},{"$f":"Calculations!N36","v":0}]
[]
[null,null,"O&M cost",{"$f":"Calculations!D42","v":6875000},{"$f":"Calculations!E42","v":9443435.3608734645},{"$f":"Calculations!F42","v":9971683.0933993347},{"$f":"Calculations!G42","v":10523126.598051973},{"$f":"Calculations!H42","v":11098682.198199708},{"$f":"Calculations!I42","v":11696968.808383247},{"$f":"Calculations!J42","v":12321163.801199419},{"$f":"Calculations!K42","v":12972283.221657015},{"$f":"Calculations!L42","v":13653928.466072258},{"$f":"Calculations!M42","v":14364797.37025292},{"$f":"Calculations!N42","v":15106029.873064958},{"$f":"SUM(E19:N19)","v":121152098.7911543}]
[null,null,"O&MDistribution",{"$f":"Calculations!D43","v":0},{"$f":"Calculations!E43","v":0},{"$f":"Calculations!F43","v":0},{"$f":"Calculations!G43","v":0},{"$f":"Calculations!H43","v":0},{"$f":"Calculations!I43","v":0},{"$f":"Calculations!J43","v":0},{"$f":"Calculations!K43","v":0},{"$f":"Calculations!L43","v":0},{"$f":"Calculations!M43","v":0},{"$f":"Calculations!N43","v":0}]
[null,null,"O&MResources",{"$f":"Calculations!D44","v":0},{"$f":"Calculations!E44","v":0},{"$f":"Calculations!F44","v":0},{"$f":"Calculations!G44","v":0},{"$f":"Calculations!H44","v":0},{"$f":"Calculations!I44","v":0},{"$f":"Calculations!J44","v":0},{"$f":"Calculations!K44","v":0},{"$f":"Calculations!L44","v":0},{"$f":"Calculations!M44","v":0},{"$f":"Calculations!N44","v":0}]
[null,null,"O&MProduction",{"$f":"Calculations!D45","v":0},{"$f":"Calculations!E45","v":0},{"$f":"Calculations!F45","v":0},{"$f":"Calculations!G45","v":0},{"$f":"Calculations!H45","v":0},{"$f":"Calculations!I45","v":0},{"$f":"Calculations!J45","v":0},{"$f":"Calculations!K45","v":0},{"$f":"Calculations!L45","v":0},{"$f":"Calculations!M45","v":0},{"$f":"Calculations!N45","v":0}]
[null,null,"O&Mmeters",{"$f":"Calculations!D46","v":0},{"$f":"Calculations!E46","v":0},{"$f":"Calculations!F46","v":0},{"$f":"Calculations!G46","v":0},{"$f":"Calculations!H46","v":0},{"$f":"Calculations!I46","v":0},{"$f":"Calculations!J46","v":0},{"$f":"Calculations!K46","v":0},{"$f":"Calculations!L46","v":0},{"$f":"Calculations!M46","v":0},{"$f":"Calculations!N46","v":0}]
[null,null,"O&Mfixed",{"$f":"$D$19*0.7","v":4812500},{"$f":"E19-SUM(E20:E23)","v":9443435.3608734645},{"$f":"F19-SUM(F20:F23)","v":9971683.0933993347},10523126.598051973,11098682.198199708,11696968.808383247,12321163.801199419,12972283.221657015,13653928.466072258,14364797.37025292,15106029.873064958]
[null,null,"Infraestructure Investment",{"$f":"Calculations!D37","v":0},{"$f":"Calculations!E37","v":0},{"$f":"Calculations!F37","v":0},{"$f":"Calculations!G37","v":0},{"$f":"Calculations!H37","v":0},{"$f":"Calculations!I37","v":0},{"$f":"Calculations!J37","v":0},{"$f":"Calculations!K37","v":0},{"$f":"Calculations!L37","v":0},{"$f":"Calculations!M37","v":0},{"$f":"Calculations!N37","v":0},0]
[]
[null,null,"Budget",{"$f":"Calculations!D8","v":15000000},{"$f":"Calculations!E8","v":8506672.1519830171},{"$f":"Calculations!F8","v":1313198.6709603835},{"$f":"Calculations!G8","v":-6651071.7580371108},{"$f":"Calculations!H8","v":-15424799.961666137},{"$f":"Calculations!I8","v":-25774241.360879876},{"$f":"Calculations!J8","v":-36942892.231264755},{"$f":"Calculations!K8","v":-48959400.051603571},{"$f":"Calculations!L8","v":-61280985.574414074},{"$f":"Calculations!M8","v":-74563185.847330019},{"$f":"Calculations!N8","v":-83450926.882108524}]

{"sheet":"BUSINESS AS USUAL","index":3,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[[1,1,1,10],[16,0,16,10]]}
[]
[null,"Business as Usual"]
[null,"Turn1","Turn2","Turn3","Turn4","Turn5","Turn6","Turn7","Turn8","Turn9","Turn10"]
["Full Recovery Cost Ratio",0.70561474487496434,0.68552769474046515,0.65548018311649769,0.62608812461823116,0.59705918009880721,0.56893362153135529,0.54171305906453915,0.5153964583937436,0.4893693481378098,0.47526037614170336]
["Collection Efficiency",0.80634067913445184,0.8061860170679831,0.80762952968207757,0.80884672347039144,0.80937940305012857,0.80991182599220801,0.81044422555590301,0.8109768362720059,0.81046179957466302,0.82975581332412129]
["Physical Losses",0.39996556955299839,0.40853626032913398,0.41710695110526969,0.42567764188140544,0.43424833265754104,0.44281902343367674,0.4513897142098125,0.4599604049859482,0.46853109576208379,0.47710178653821955]
["Coverage",0.65476180429553987,0.64318400371389728,0.63181296264627562,0.6206433136814149,0.60967004298320748,0.59888846005403318,0.58829863059401588,0.57789595995709686,0.56767613208168399,0.55763909352921304]
["Afordability",4.8698054190193768E-2,4.727966426232405E-2,4.5902586662450527E-2,4.4565618118884008E-2,4.3267590406683501E-2,4.2007369326877188E-2,4.0783853715414743E-2,3.9595974480985188E-2,3.8442693670859403E-2,3.7323003563941165E-2]
["Willingness to pay ",0.33569478168917755,0.30762030405621865,0.27760247447076064,0.24564129293280362,0.21173675944234732,0.17588887399939201,0.13809763660393734,9.8363047255983632E-2,8.7317819133610405E-2,7.5857384454138324E-2]
["Asset Depreciation",98000,96040,94119.2,92236.815999999992,90392.07968000001,88584.238086400001,86812.553324672001,85076.302258178563,83374.776213014979,81707.28068875469]
["Asset Value",4900000,4802000,4705960,4611840.8,4519603.9840000002,4429211.9043199997,4340627.6662336001,4253815.1129089277,4168738.8106507491,4085364.0344377342]
["Service Affordability",4.8698054190193768E-2,4.727966426232405E-2,4.5902586662450527E-2,4.4565618118884008E-2,4.3267590406683501E-2,4.2007369326877188E-2,4.0783853715414743E-2,3.9595974480985188E-2,3.8442693670859403E-2,3.7323003563941165E-2]
["Commercial Water Losses",0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369,0.10005173305742369]
["Continuity",0.67166532097726528,0.66223956890676061,0.65285877483092958,0.6324026721228575,0.61226974367768616,0.59245998949541523,0.57297340957604515,0.55381000391957558,0.53496977252600664,0.33485082933935467]
["Water Quality",0.67999999999999994,0.65999999999999992,0.6399999999999999,0.61999999999999988,0.59999999999999987,0.57999999999999985,0.55999999999999983,0.53999999999999981,0.48999999999999982,0.43999999999999984]
[]
["Initial Values"]
[null,"Turn1","Turn2","Turn3","Turn4","Turn5","Turn6","Turn7","Turn8","Turn9","Turn10"]
["Full Recovery Cost Ratio",{"$f":"Calculations!D25","v":0.72601549691569134},{"$f":"B19","v":0.72601549691569134},{"$f":"C19","v":0.72601549691569134},0.72601549691569134,0.72601549691569134,0.72601549691569134,0.72601549691569134,0.72601549691569134,0.72601549691569134,0.72601549691569134]
["Collection Efficiency",{"$f":"Calculations!D80","v":0.72249820843523249},{"$f":"B20","v":0.72249820843523249},0.72249820843523249,0.72249820843523249,0.72249820843523249,0.72249820843523249,0.72249820843523249,0.72249820843523249,0.72249820843523249,0.72249820843523249]
["Physical Losses",{"$f":"Calculations!D91","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Coverage",{"$f":"Calculations!D99","v":0.78584107932664637},0.78584107932664637,0.78584107932664637,0.78584107932664637,0.78584107932664637,0.78584107932664637,0.78584107932664637,0.78584107932664637,0.78584107932664637,0.78584107932664637]
["Afordability",{"$f":"Calculations!D84","v":5.0002130492676419E-2},5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2]
["Willingness to pay ",{"$f":"Calculations!D86","v":0.75},0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
["Asset Depreciation",{"$f":"Calculations!D79","v":1375000},1375000,1375000,1375000,1375000,1375000,1375000,1375000,1375000,1375000]
["Asset Value",{"$f":"Calculations!D78","v":68750000},68750000,68750000,68750000,68750000,68750000,68750000,68750000,68750000,68750000]
["Service Affordability",{"$f":"Calculations!D84","v":5.0002130492676419E-2},5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2,5.0002130492676419E-2]
["Commercial Water Losses",{"$f":"Calculations!D95","v":5589848.895487668},5589848.895487668,5589848.895487668,5589848.895487668,5589848.895487668,5589848.895487668,5589848.895487668,5589848.895487668,5589848.895487668,5589848.895487668]
["Continuity",{"$f":"Calculations!D89","v":0.71793776721910652},0.71793776721910652,0.71793776721910652,0.71793776721910652,0.71793776721910652,0.71793776721910652,0.71793776721910652,0.71793776721910652,0.71793776721910652,0.71793776721910652]
["Water Quality",{"$f":"Calculations!D88","v":0.7},0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7]

{"sheet":"KPI","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,1,1,29]]}
[null,"KEY PERFORMANCE INDICATORS"]

{"sheet":"Financial Manager","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,12]],"read":"row_number_cap"}
["FINANCIAL MANAGER PERFORMANCE INDICATORS"]

{"sheet":"RESULTS","index":6,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[1,"Decisions ","TURN 1","TURN 2","TURN 3","TURN 4","TURN 5","TURN 6","TURN 7","TURN 8","TURN 9","TURN 10","Current Turn",2]
[2,"Financial Decisions"]
[3,"Subsidy on connection fee",0.8,0,0,0,0,0,0,0,0,0]
[4,"In-house Tariff",1.2,0,0,0,0,0,0,0,0,0]
[5,"Water Kiosk Tariff",1.8,0,0,0,0,0,0,0,0,0]
[6,"Un-metered Connection Tariff",200,0,0,0,0,0,0,0,0,0]
[7,"Infrastructural Decisions"]
[8,"Additional Water Kiosks",0,0,0,0,0,0,0,0,0,0]
[9,"Additional Distribution Network",0,0,0,0,0,0,0,0,0,0]
[10,"Additional Water Treatment Capacity",0,0,0,0,0,0,0,0,0,0]
[11,"Additional Water Resources Abstracted",0,0,0,0,0,0,0,0,0,0]
[12,"Additional Number of Meters Type A",0,0,0,0,0,0,0,0,0,0]
[13,"Additional Number of Meters Type B",0,0,0,0,0,0,0,0,0,0]
[14,"Additional Number of Meters Type C",0,0,0,0,0,0,0,0,0,0]
[15,"Human Resources Decisions"]
[16,"Additional Director",0,0,0,0,0,0,0,0,0,0]
[17,"Additional Manager",0,0,0,0,0,0,0,0,0,0]
[18,"Additional Operational Staff",0,0,0,0,0,0,0,0,0,0]
[19,"Additional Bill Collectors",0,0,0,0,0,0,0,0,0,0]
[20,"Additional Costumer Services Employees",0,0,0,0,0,0,0,0,0,0]
[21,"Maintenance Decisions"]
[22,"Rehabilitated Network",0,0,0,0,0,0,0,0,0,0]
[23,"Treatment Maintenance",0,0,0,0,0,0,0,0,0,0]
[24,"Resources Maintenance",0,0,0,0,0,0,0,0,0,0]
[25,"Additional Meter Calibration Program",0,0,0,0,0,0,0,0,0,0]
[26,"Capacity Development Decisions"]
[27,"Additional Leakage Trainees",0,0,0,0,0,0,0,0,0,0]
[28,"Additional Staff Trainings",0,0,0,0,0,0,0,0,0,0]
[29,"Additional Office Technology",0,0,0,0,0,0,0,0,0,0]
[30,"Standard Operating Procedures",0,0,0,0,0,0,0,0,0,0]
[31,"Awareness Campaigns",0,0,0,0,0,0,0,0,0,0]
[32,"KPIS"]
[33,"Full Recovery Cost Ratio",0.7188139308305399,0.70112692660702014,0.66463922972478828,0.62090795214332306,0.49965483178268394,0.46297632719948584,0.42753015556082791,0.44620943548441444,0.40732599177705603,0.8448280362380457]
[34,"Collection Efficiency",0.58082759026545394,0.62030547268093994,0.63684006561262019,0.64185819640120567,0.64224671363715247,0.63852062276350674,0.63327771189772308,0.62605802410135691,0.61956034448545605,0.63654090996581547]
[35,"Physical Losses",0.39104981157591606,0.41492706872855828,0.43880432588120055,0.46268158303384277,0.48649746243170611,0.51031334182956956,0.53412922122743289,0.55800647838007522,0.58188373553271744,0]
[36,"Coverage",0.77194611237168309,0.75829681941444549,0.74488904220857799,0.73171811232318484,0.71878017236620984,0.70607087385281686,0.69358604047083505,0.68132220175924374,0.66927542511587601,0.65744140292773712]
[37,"Affordability",9.5499851330911545E-2,9.2718302263020913E-2,9.0017769187398927E-2,8.739589241495041E-2,8.4850380985388746E-2,8.2379010665425967E-2,7.9979622005267925E-2,7.7650118451716432E-2,7.5388464516229547E-2,7.3192683996339353E-2]
[38,"Customer Satisfaction",0.52738402208277568,0.67158026750464239,0.72400335499128698,0.73036059390555241,0.71351880781739974,0.68489916008273999,0.65021223237952874,0.61229876774585046,0.57259276504217094,0.62679974272353156]
[39,"Asset Depreciation",1347500,1320550,1294139,1268256.22,1242891.0956000001,1218033.2736879999,1193672.6082142401,1169799.1560499552,1146403.1729289561,1123475.109470377]
[40,"Asset Value",67375000,66027500,64706950,63412811,62144554.780000001,60901663.6844,59683630.410711996,58489957.802497759,57320158.646447808,56173755.473518848]
[41,"Commercial Water Losses",0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867,0.17570034953296867]
[42,"Continuity",15.886082649933085,15.34659077559056,14.785586548675887,14.203069969189066,13.600621303754822,12.976770740884817,12.331518280579045,11.663118186730335,10.973205740309481,21.660403224293525]
[43,"Water Quality",0.64999999999999991,0.59999999999999987,0.54999999999999982,0.49999999999999983,0.44999999999999984,0.39999999999999986,0.34999999999999987,0.29999999999999988,0.24999999999999989,0.1999999999999999]
[44,"Utility Efficiency"]

{"sheet":"WATER MANAGER","index":7,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:O11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:O12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:O13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E14:O14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:O15)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:O17)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:O18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:O19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:O20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:O21)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:O23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:O24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:O25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:O26)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:O27)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:O29)","v":0}]
[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,0]
[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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Yearly Decision","index":8,"n_rows":95,"n_cols":16,"rows_kept":95,"cut":false,"hidden":true,"merged":[[14,1,16,1]]}
[1]
[]
[null,null,null,null,null,{"$f":"YEAR(TODAY())","v":2018},{"$f":"F3+1","v":2019},{"$f":"G3+1","v":2020},2021,2022,2023,2024,2025,2026,2027]
[null,null,null,"Unit","Initial Value","Turn 1","Turn 2","Turn 3","Turn 4","Turn 5","Turn 6","Turn 7","Turn 8","Turn 9","Turn 10","Actual Value"]
[null,1,"Financial Decisions"]
[null,1.1000000000000001,"Subsidy on connection fee","%",{"$f":"'INI-VAL'!H36","v":0.4},0,0,0,0,0,0,0,0,0,0,0.4]
[null,1.2,"In-house Tariff","US$/m3",{"$f":"'INI-VAL'!H37","v":0.61},0,0,0,0,0,0,0,0,0,0,0.61]
[null,1.3,"Water Kiosk Tariff","US$/m3",{"$f":"'INI-VAL'!H38","v":1.04},0,0,0,0,0,0,0,0,0,0,1.04]
[null,1.4,"Un-metered Connection Tariff","US$/Connection",{"$f":"'INI-VAL'!H39","v":150.21},0,0,0,0,0,0,0,0,0,0,150.21]
[null,2,"Infrastructural Decisions"]
[null,2.1,"Additional Water Kiosks","No. Of Kiosks ",{"$f":"'INI-VAL'!H49","v":626},0,0,0,0,0,0,0,0,0,0,626]
[null,2.2000000000000002,"Additional Distribution Network","km network",{"$f":"'INI-VAL'!H46","v":1051},0,0,0,0,0,0,0,0,0,0,1051]
[null,2.2999999999999998,"Additional Water Treatment Capacity","m3",{"$f":"'INI-VAL'!H43","v":34936340},0,0,0,0,0,0,0,0,0,0,34936340]
[null,2.4,"Additional Water Resources Abstracted","m3",{"$f":"'INI-VAL'!H42","v":34936340},0,0,0,0,0,0,0,0,0,0,34936340]
[null,2.5,"Additional Number of Meters Type A","No. A Meters",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Additional Number of Meters Type B","No. B Meters",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Additional Number of Meters Type C","No. C Meters",{"$f":"'INI-VAL'!H48","v":16711},0,0,0,0,0,0,0,0,0,0,16711]
[null,3,"Human Resources Decisions"]
[null,3.1,"Additional Director","No. Directors",{"$f":"'INI-VAL'!D19","v":19},0,0,0,0,0,0,0,0,0,0,19]
[null,3.2,"Additional Manager","No. Managers",{"$f":"'INI-VAL'!D20","v":65},0,0,0,0,0,0,0,0,0,0,65]
[null,3.3,"Additional Operational Staff","No. Employees",{"$f":"'INI-VAL'!D22","v":130},0,0,0,0,0,0,0,0,0,0,130]
[null,3.4,"Additional Bill Collectors","No. Bill Collectors",{"$f":"'INI-VAL'!D23","v":26},0,0,0,0,0,0,0,0,0,0,26]
[null,3.5,"Additional Costumer Services Employees","No. Employees",{"$f":"'INI-VAL'!D24","v":91},0,0,0,0,0,0,0,0,0,0,91]
[null,4,"Maintenance Decisions"]
[null,4.0999999999999996,"Rehabilitated Network","Km",0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.2,"Treatment Maintenance","m3",0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.3,"Resources Maintenance","m3",0,0,0,0,0,0,0,0,0,0,0,0]
[null,4.4000000000000004,"Additional Meter Calibration Program","No. meters",0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,"Capacity Development Decisions"]
[null,5.0999999999999996,"Additional Leakage Trainees","No. Trainees",0,0,0,0,0,0,0,0,0,0,0,0]
[null,5.2,"Additional Staff Trainings","No. Trainees",0,0,0,0,0,0,0,0,0,0,0,0]
[null,5.3,"Additional Office Technology","Package",0,0,0,0,0,0,0,0,0,0,0,0]
[null,5.4,"Standard Operating Procedures","Procedure",0,0,0,0,0,0,0,0,0,0,0,0]
[null,5.5,"Awareness Campaigns","Procedure",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"New Network ","km",0,{"$f":"F91","v":0},{"$f":"G91","v":0},0,0,0,0,0,0,0,0]
[null,null,"Old Network ","km",{"$f":"E12","v":1051},{"$f":"F92","v":1051},1051,1051,1051,1051,1051,1051,1051,1051,0]
[]
[null,"A","Water distribution - In-house connections","%",{"$f":"Calculations!D107","v":0.88213030554985783},{"$f":"Calculations!E107","v":0.88213030554985783},{"$f":"Calculations!F107","v":0.88213030554985783},{"$f":"Calculations!G107","v":0.88213030554985783},{"$f":"Calculations!H107","v":0.88213030554985783},0.88,0.88,0.88,{"$f":"Calculations!L107","v":0.88213030554985783},{"$f":"Calculations!M107","v":0.88213030554985783},{"$f":"Calculations!N107","v":0.88213030554985783}]
[null,"B","Water distribution - Water Kiosk","%",{"$f":"Calculations!D110","v":0.11786969445014217},{"$f":"Calculations!E110","v":0.11786969445014217},{"$f":"Calculations!F110","v":0.11786969445014217},{"$f":"Calculations!G110","v":0.11786969445014217},{"$f":"Calculations!H110","v":0.11786969445014217},{"$f":"1-J39","v":0.12},{"$f":"1-K39","v":0.12},0.12,{"$f":"Calculations!L110","v":0.11786969445014217},{"$f":"Calculations!M110","v":0.11786969445014217},{"$f":"Calculations!N110","v":0.11786969445014217}]
[null,null,"Liters per capita per day In-house","lcd",{"$f":"Calculations!D118","v":112.54731572382711},{"$f":"Calculations!E118","v":92.730963741989484},{"$f":"Calculations!F118","v":87.754433902897333},{"$f":"Calculations!G118","v":82.777904063805138},{"$f":"Calculations!H118","v":77.801374224712958},{"$f":"Calculations!I118","v":54.496302868497722},{"$f":"Calculations!J118","v":50.782490218627331},{"$f":"Calculations!K118","v":47.068677568756932},{"$f":"Calculations!L118","v":57.933632169324937},{"$f":"Calculations!M118","v":52.957102330232772},{"$f":"Calculations!N118","v":174.23408796761137}]
[null,null,"Liters per capita per day WK","lcd",{"$f":"Calculations!D121","v":32.867519091661038},{"$f":"Calculations!E121","v":27.08049233850112},{"$f":"Calculations!F121","v":25.627181893515054},{"$f":"Calculations!G121","v":24.173871448528978},{"$f":"Calculations!H121","v":22.720561003542908},{"$f":"Calculations!I121","v":16.24156898205781},{"$f":"Calculations!J121","v":15.134738955718968},{"$f":"Calculations!K121","v":14.027908929380127},{"$f":"Calculations!L121","v":16.918526658130112},{"$f":"Calculations!M121","v":15.465216213144041},{"$f":"Calculations!N121","v":50.882086132963565}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Initial Financial Loan","USD",15000000]
[null,null,null,null,"Bankruptcy",{"$f":"Calculations!D8","v":15000000},{"$f":"Calculations!E8","v":8506672.1519830171},{"$f":"Calculations!F8","v":1313198.6709603835},{"$f":"Calculations!G8","v":-6651071.7580371108},{"$f":"Calculations!H8","v":-15424799.961666137},{"$f":"Calculations!I8","v":-25774241.360879876},{"$f":"Calculations!J8","v":-36942892.231264755},{"$f":"Calculations!K8","v":-48959400.051603571},{"$f":"Calculations!L8","v":-61280985.574414074},{"$f":"Calculations!M8","v":-74563185.847330019}]
[null,null,null,null,"Kiosk to Network",{"$f":"Calculations!E12","v":0},{"$f":"Calculations!F12","v":0},{"$f":"Calculations!G12","v":0},{"$f":"Calculations!H12","v":0},{"$f":"Calculations!I12","v":0},{"$f":"Calculations!J12","v":0},{"$f":"Calculations!K12","v":0},{"$f":"Calculations!L12","v":0},{"$f":"Calculations!M12","v":0},{"$f":"Calculations!N12","v":0}]
[null,null,null,null,"Meters",{"$f":"Calculations!E14","v":33928},{"$f":"Calculations!F14","v":33928},{"$f":"Calculations!G14","v":33928},{"$f":"Calculations!H14","v":33928},{"$f":"Calculations!I14","v":33928},{"$f":"Calculations!J14","v":33928},{"$f":"Calculations!K14","v":33928},{"$f":"Calculations!L14","v":33928},{"$f":"Calculations!M14","v":33928},{"$f":"Calculations!N14","v":33928}]
[]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9]
[null,null,null,"New bought pipes",null,{"$f":"F12","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Rehab pipes",null,{"$f":"F25","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Actual size ",null,{"$f":"E37+F87","v":1051},{"$f":"F89+G87","v":1051},{"$f":"G89+H87","v":1051},1051,1051,1051,1051,1051,1051]
[]
[null,null,null,"New Net",null,{"$f":"SUM($F$87:F88)","v":0},{"$f":"SUM($F$87:G88)","v":0},{"$f":"SUM($F$87:H88)","v":0},{"$f":"SUM($F$87:I88)","v":0},{"$f":"SUM($F$87:J88)","v":0},{"$f":"SUM($F$87:K88)-SUM(F91:F91)","v":0},{"$f":"SUM($F$87:L88)-SUM(G91:G91)","v":0},{"$f":"SUM($F$87:M88)-SUM(H91:H91)","v":0},{"$f":"SUM($F$87:N88)-SUM(I91:I91)","v":0}]
[null,null,null,"Old Net",null,{"$f":"F89-F91","v":1051},{"$f":"G89-G91","v":1051},1051,1051,1051,{"$f":"K89-K91","v":1051},1051,1051,{"$f":"N89-N91","v":1051}]
[]
[]
[null,null,null,null,null,{"$f":"F91+F92","v":1051},{"$f":"G91+G92","v":1051},1051,1051,1051,1051,1051,1051,1051]

{"sheet":"BENCH-MARKING","index":9,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,30,1,30],[0,0,1,8],[0,9,1,17]],"read":"row_number_cap"}
["MANAGER PERFORMANCE INDICATORS BENCHMARKING",null,null,null,null,null,null,null,null,"MANAGER PERFORMANCE INDICATORS BENCHMARKING"]

{"sheet":"Commercial Manager","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,13]],"read":"row_number_cap"}
["COMMERCIAL MANAGER PERFORMANCE INDICATORS"]

{"sheet":"Operational Manager","index":11,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,13]],"read":"row_number_cap"}
["OPERATIONAL MANAGER PERFORMANCE INDICATORS"]

{"sheet":"Water Balance","index":12,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[[0,0,1,13]],"read":"row_number_cap"}
["WATER BALANCE"]

{"sheet":"EQ","index":13,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":true,"merged":[[2,4,2,7],[2,11,2,14],[23,4,23,7]]}
[]
[]
[null,null,null,null,"Continuity",null,null,null,null,null,null,"Quality"]
["New cxns",50639]
["Ratio 1",{"$f":"H6/H7","v":1.3102746894685915},{"$f":"$B$4*B5","v":66351},null,"hours","Ph loss","Ileg Con","No Connections",null,null,null,"Samples","Ph loss","Dist Man","Resources Man",null,null,null,0.05,0.8]
["Ratio 2",{"$f":"H8/H7","v":0.64665573964730738},{"$f":"$B$4*B6","v":32746},null,3,0.7,0.01,66351,null,null,null,0.2,0.6,0.2,0.2,null,null,null,0.15,0.3]
[null,null,null,null,16,0.37,0.05,50639,null,null,null,0.7,0.4,0.7,0.5,null,null,null,0.25,0.05]
[null,null,null,null,23,0.05,0.1,32746,null,null,null,0.9,0.15,0.9,0.7]
[]
[null,null,null,null,"Hours","Ph loss","Ille Con","No Connections"]
[null,{"$f":"ROUND(B19*3/7,0)","v":21702},null,null,{"$f":"(-37.705*F11+25.787)*0.5+(188.52*G11+1.2787)*0.25+(-0.0005*H11+36.579)*0.25","v":17.288600000000002},0.15,0.01,21702,null,null,null,"Samples","Ph loss","Dist Man","Resources Man"]
[null,{"$f":"ROUND(B11+($B$19-$B$11)/8,0)","v":25319},null,null,{"$f":"(-37.705*F12+25.787)*0.5+(188.52*G12+1.2787)*0.25+(-0.0005*H12+36.579)*0.25","v":15.94098},0.2,1.0999999999999999E-2,25319,null,null,null,{"$f":"(0.793+1.27*M12+-3.77*M12^2)/3+N12+0.556*LN(O12)/3+1.0929/3","v":0.66557584022888006},0.15,0.3,{"$f":"0.2","v":0.2}]
[null,{"$f":"ROUND(B12+($B$19-$B$11)/8,0)","v":28936},null,null,14.593360000000001,0.25,1.2E-2,28936,null,null,null,{"$f":"(0.793+1.27*M13+-3.77*M13^2)/3+N13+0.556*LN(O13)/3+1.0929/3","v":0.75610677840578033},0.2,0.35,{"$f":"0.25","v":0.25}]
[null,32553,null,null,13.24574,0.3,1.2999999999999999E-2,32553,null,null,null,0.83278870693159313,0.25,0.4,0.3]
[null,36170,null,null,11.89812,0.35,1.4E-2,36170,null,null,null,0.89796629959291163,0.3,0.45,0.35]
[null,39787,null,null,10.5505,0.4,1.4999999999999999E-2,39787,null,null,null,0.9530391176926567,0.35,0.5,0.4]
[null,43404,null,null,9.2028800000000004,0.45,1.6E-2,43404,null,null,null,0.9989099069676397,0.4,0.55000000000000004,0.45]
[null,47021,null,null,7.8552600000000004,0.5,1.7000000000000001E-2,47021,null,null,null,1.0361950558695567,0.45,0.6,0.5]
[null,50639,null,null,6.5075149999999979,0.55000000000000004,1.7999999999999999E-2,50639,null,null,null,1.0653342091932916,0.5,0.65,0.55000000000000004]
[null,{"$f":"ROUND(50639*11/7,0)","v":79576},null,null,1.9948949999999996,0.6,1.9E-2,79576,null,null,null,1.0866519843953697,0.55000000000000004,0.7,0.6]
[null,null,null,null,null,null,null,null,null,null,null,1.1003948995508652,0.6,0.75,0.65]
[]
[]
[null,null,null,null,"Collection Efficiency Gain"]
[]
[null,null,null,"Eff","No Connections","SOPS/7732 con","No Con/ bill col",null,null,null,null,"% Il. Conn","tariff","Sub"]
[null,null,null,1,7732,{"$f":"25/7732","v":3.2333160889808587E-3},400,null,null,null,null,0.1,1.1299999999999999,0]
[null,null,null,0.8,{"$f":"E27/$D$28","v":9665},{"$f":"20/7732","v":2.5866528711846869E-3},{"$f":"E28/8","v":1208.125},null,null,null,null,0.05,0.61,0.4]
[null,null,null,0.5,{"$f":"E28/$D$28","v":12081.25},{"$f":"15/7732","v":1.9399896533885152E-3},1510.15625,null,null,null,null,0.01,0.22600000000000001,1]
[null,null,null,0.2,15101.5625,{"$f":"10/7732","v":1.2933264355923435E-3},1887.6953125]
[null,null,null,null,null,null,null,null,null,null,null,"% Il. Conn","tariff","Sub","Customer Disc"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(0.2246*M32-0.0118)*0.4+(-0.09*N32+0.0983)*0.4+IF(O32=\"Yes\",0,1)*0.2*0.1","v":7.9520000000000007E-2},0.5,0,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(0.2246*M33-0.0118)*0.4+(-0.09*N33+0.0983)*0.4+IF(O33=\"Yes\",0,1)*0.2*0.1","v":3.8168000000000007E-2},0.2,0.4,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,7.5840000000000013E-3,0.1,1,"Yes"]
[null,null,null,"Eff %","SOPS/7732","No Con/ bill col",null,null,null,null,null,9.9520000000000011E-2,0.5,0,"No"]
[null,null,null,{"$f":"0.6*(1.00590067021-3.16861445688*EXP(-93431.7085275*F36^-1.47672030952))+(0.8823*LN(E36)+6.0483)*0.4","v":0.9726948542143663},3.0000000000000001E-3,400,null,null,null,null,null,5.8168000000000011E-2,0.2,0.4,"No"]
[null,null,null,{"$f":"0.6*(1.00590067021-3.16861445688*EXP(-93431.7085275*F37^-1.47672030952))+(0.8823*LN(E37)+6.0483)*0.4","v":0.90716485607482089},2.5000000000000001E-3,600,null,null,null,null,null,2.7584000000000004E-2,0.1,1,"No"]
[null,null,null,0.77044402549369739,2E-3,1000]
[null,null,null,0.44563248043637416,1.5E-3,1500]
[null,null,null,3.853480481787723E-2,1E-3,2000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M27*$L$43","v":2.5529629629629627}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.61/0.27","v":2.2592592592592591},{"$f":"M28*$L$43","v":1.3781481481481479}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5105925925925926]
[]
[]
[]
[null,null,null,null,null,null,"Unit cost","Differences","Change"]
[null,null,null,"Workers","Original",40,1200,{"$f":"F49/F52","v":0.44444444444444442}]
[null,null,null,"Workers","Added",1,{"$f":"F50*G49","v":1200},{"$f":"F50/F53","v":1}]
[null,null,null,"Workers","Total",{"$f":"F49+F50","v":41},{"$f":"F51*G49","v":49200},0.45054945054945056]
[null,null,null,"Network","Original",90,22700,{"$error":"#DIV/0!"}]
[null,null,null,"Network","Added",1,{"$f":"F53*G52","v":22700},{"$error":"#DIV/0!"}]
[null,null,null,"Network","Total",{"$f":"F52+F53","v":91},{"$f":"F54*G52","v":2065700},{"$error":"#DIV/0!"}]

{"sheet":"Bench1","index":14,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[44,"Utility Efficiency"]

{"sheet":"Calculations","index":15,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":true,"merged":[]}
[2,null,null,null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,"Initial Value",{"$f":"YEAR(TODAY())","v":2018},{"$f":"E2+1","v":2019},{"$f":"F2+1","v":2020},2021,2022,2023,2024,2025,2026,2027]
[null,"Subsidy","US$/m3",{"$f":"'Yearly Decision'!E6","v":0.4},{"$f":"IF('Yearly Decision'!F6=0,D3,'Yearly Decision'!F6)","v":0.4},{"$f":"IF('Yearly Decision'!G6=0,E3,'Yearly Decision'!G6)","v":0.4},{"$f":"IF('Yearly Decision'!H6=0,F3,'Yearly Decision'!H6)","v":0.4},{"$f":"IF('Yearly Decision'!I6=0,G3,'Yearly Decision'!I6)","v":0.4},{"$f":"IF('Yearly Decision'!J6=0,H3,'Yearly Decision'!J6)","v":0.4},{"$f":"IF('Yearly Decision'!K6=0,I3,'Yearly Decision'!K6)","v":0.4},{"$f":"IF('Yearly Decision'!L6=0,J3,'Yearly Decision'!L6)","v":0.4},{"$f":"IF('Yearly Decision'!M6=0,K3,'Yearly Decision'!M6)","v":0.4},{"$f":"IF('Yearly Decision'!N6=0,L3,'Yearly Decision'!N6)","v":0.4},{"$f":"IF('Yearly Decision'!O6=0,M3,'Yearly Decision'!O6)","v":0.4}]
[null,"Tariff In-house","US$/m3",{"$f":"'Yearly Decision'!E7","v":0.61},{"$f":"IF('Yearly Decision'!F7=0,D4,'Yearly Decision'!F7)","v":0.61},{"$f":"IF('Yearly Decision'!G7=0,E4,'Yearly Decision'!G7)","v":0.61},{"$f":"IF('Yearly Decision'!H7=0,F4,'Yearly Decision'!H7)","v":0.61},{"$f":"IF('Yearly Decision'!I7=0,G4,'Yearly Decision'!I7)","v":0.61},{"$f":"IF('Yearly Decision'!J7=0,H4,'Yearly Decision'!J7)","v":0.61},{"$f":"IF('Yearly Decision'!K7=0,I4,'Yearly Decision'!K7)","v":0.61},{"$f":"IF('Yearly Decision'!L7=0,J4,'Yearly Decision'!L7)","v":0.61},{"$f":"IF('Yearly Decision'!M7=0,K4,'Yearly Decision'!M7)","v":0.61},{"$f":"IF('Yearly Decision'!N7=0,L4,'Yearly Decision'!N7)","v":0.61},{"$f":"IF('Yearly Decision'!O7=0,M4,'Yearly Decision'!O7)","v":0.61}]
[null,"Tariff Standpipe","US$/m3",{"$f":"'Yearly Decision'!E8","v":1.04},{"$f":"IF('Yearly Decision'!F8=0,D5,'Yearly Decision'!F8)","v":1.04},{"$f":"IF('Yearly Decision'!G8=0,E5,'Yearly Decision'!G8)","v":1.04},{"$f":"IF('Yearly Decision'!H8=0,F5,'Yearly Decision'!H8)","v":1.04},{"$f":"IF('Yearly Decision'!I8=0,G5,'Yearly Decision'!I8)","v":1.04},{"$f":"IF('Yearly Decision'!J8=0,H5,'Yearly Decision'!J8)","v":1.04},{"$f":"IF('Yearly Decision'!K8=0,I5,'Yearly Decision'!K8)","v":1.04},{"$f":"IF('Yearly Decision'!L8=0,J5,'Yearly Decision'!L8)","v":1.04},{"$f":"IF('Yearly Decision'!M8=0,K5,'Yearly Decision'!M8)","v":1.04},{"$f":"IF('Yearly Decision'!N8=0,L5,'Yearly Decision'!N8)","v":1.04},{"$f":"IF('Yearly Decision'!O8=0,M5,'Yearly Decision'!O8)","v":1.04}]
[null,"Un-metered trariff","US$/Connection",{"$f":"'Yearly Decision'!E9","v":150.21},{"$f":"IF('Yearly Decision'!F9=0,D6,'Yearly Decision'!F9)","v":150.21},{"$f":"IF('Yearly Decision'!G9=0,E6,'Yearly Decision'!G9)","v":150.21},{"$f":"IF('Yearly Decision'!H9=0,F6,'Yearly Decision'!H9)","v":150.21},{"$f":"IF('Yearly Decision'!I9=0,G6,'Yearly Decision'!I9)","v":150.21},{"$f":"IF('Yearly Decision'!J9=0,H6,'Yearly Decision'!J9)","v":150.21},{"$f":"IF('Yearly Decision'!K9=0,I6,'Yearly Decision'!K9)","v":150.21},{"$f":"IF('Yearly Decision'!L9=0,J6,'Yearly Decision'!L9)","v":150.21},{"$f":"IF('Yearly Decision'!M9=0,K6,'Yearly Decision'!M9)","v":150.21},{"$f":"IF('Yearly Decision'!N9=0,L6,'Yearly Decision'!N9)","v":150.21},{"$f":"IF('Yearly Decision'!O9=0,M6,'Yearly Decision'!O9)","v":150.21}]
[null,"SUB-INDICATOR","UNIT","Initial Value","Turn 1","Turn 2","Turn 3","Turn 4","Turn 5","Turn 6","Turn 7","Turn 8","Turn 9","Turn 10"]
[null,"Financial Reserves","US$",{"$f":"'INI-VAL'!H13","v":15000000},{"$f":"D8+(E26-E29)","v":8506672.1519830171},{"$f":"E8+(F26-F29)","v":1313198.6709603835},-6651071.7580371108,-15424799.961666137,-25774241.360879876,-36942892.231264755,-48959400.051603571,-61280985.574414074,-74563185.847330019,-83450926.882108524]
[null,"Infraestructure",null,{"$f":"D8/$D$8","v":1},{"$f":"E8/$D$8","v":0.56711147679886775},{"$f":"F8/$D$8","v":8.7546578064025563E-2},-0.44340478386914073,-1.0283199974444091,-1.7182827573919917,-2.4628594820843168,-3.2639600034402378,-4.0853990382942715,-4.970879056488668,-5.5633951254739014]
[null,"In-house Connections","No.",{"$f":"'INI-VAL'!H29","v":50639},{"$f":"D10+ROUND(((E20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-D10)*0.7+(E20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-D10)*E100*0.3),0)","v":50639},{"$f":"E10+ROUND(((F20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-E10)*0.7+(F20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-E10)*F100*0.3),0)","v":50639},{"$f":"F10+ROUND(((G20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-F10)*0.7+(G20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-F10)*G100*0.3),0)","v":50639},{"$f":"G10+ROUND(((H20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-G10)*0.7+(H20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-G10)*H100*0.3),0)","v":50639},{"$f":"H10+ROUND(((I20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-H10)*0.7+(I20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-H10)*I100*0.3),0)","v":50639},{"$f":"I10+ROUND(((J20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-I10)*0.7+(J20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-I10)*J100*0.3),0)","v":50639},{"$f":"J10+ROUND(((K20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-J10)*0.7+(K20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-J10)*K100*0.3),0)","v":50639},{"$f":"K10+ROUND(((L20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-K10)*0.7+(L20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-K10)*L100*0.3),0)","v":50639},{"$f":"L10+ROUND(((M20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-L10)*0.7+(M20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-L10)*M100*0.3),0)","v":50639},{"$f":"M10+ROUND(((N20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-M10)*0.7+(N20*'INI-VAL'!$H$29/'INI-VAL'!$H$46-M10)*N100*0.3),0)","v":50639}]
[null,"Water Kiosk","No.",{"$f":"'INI-VAL'!H49","v":626},{"$f":"D11+'Yearly Decision'!F11","v":626},{"$f":"E11+'Yearly Decision'!G11","v":626},{"$f":"F11+'Yearly Decision'!H11","v":626},{"$f":"G11+'Yearly Decision'!I11","v":626},{"$f":"H11+'Yearly Decision'!J11","v":626},{"$f":"I11+'Yearly Decision'!K11","v":626},{"$f":"J11+'Yearly Decision'!L11","v":626},{"$f":"K11+'Yearly Decision'!M11","v":626},{"$f":"L11+'Yearly Decision'!N11","v":626},{"$f":"M11+'Yearly Decision'!O11","v":626}]
[null,"Water Kiosk Connection Availability","No.",{"$f":"(D20-$D$20)*0.72222222222222","v":0},{"$f":"ROUND((E20-$D$20)-(E11-$D$11),0)","v":0},{"$f":"ROUND((F20-$D$20)-(F11-$D$11),0)","v":0},0,0,0,0,0,0,0,0]
[null,"No. Meters (Total)","No.",{"$f":"SUM('Yearly Decision'!E15:E17)","v":16711},{"$f":"D13+SUM('Yearly Decision'!F15:F17)","v":16711},{"$f":"E13+SUM('Yearly Decision'!G15:G17)","v":16711},{"$f":"F13+SUM('Yearly Decision'!H15:H17)","v":16711},{"$f":"G13+SUM('Yearly Decision'!I15:I17)","v":16711},{"$f":"H13+SUM('Yearly Decision'!J15:J17)","v":16711},{"$f":"I13+SUM('Yearly Decision'!K15:K17)","v":16711},{"$f":"J13+SUM('Yearly Decision'!L15:L17)","v":16711},{"$f":"K13+SUM('Yearly Decision'!M15:M17)","v":16711},{"$f":"L13+SUM('Yearly Decision'!N15:N17)","v":16711},{"$f":"M13+SUM('Yearly Decision'!O15:O17)","v":16711}]
[null,"Un-metered in-house connections","No.",{"$f":"D10-D13","v":33928},{"$f":"E10-E13","v":33928},33928,33928,33928,33928,33928,33928,33928,33928,33928]
[null,"Demography"]
[null,"GDP per capita","U$D/year",{"$f":"'INI-VAL'!H35","v":3004},{"$f":"D16*(1+'INI-VAL'!$D$12)","v":3094.12},{"$f":"E16*(1+'INI-VAL'!$D$12)","v":3186.9436000000001},{"$f":"F16*(1+'INI-VAL'!$D$12)","v":3282.5519080000004},{"$f":"G16*(1+'INI-VAL'!$D$12)","v":3381.0284652400005},{"$f":"H16*(1+'INI-VAL'!$D$12)","v":3482.4593191972008},{"$f":"I16*(1+'INI-VAL'!$D$12)","v":3586.9330987731169},{"$f":"J16*(1+'INI-VAL'!$D$12)","v":3694.5410917363106},{"$f":"K16*(1+'INI-VAL'!$D$12)","v":3805.3773244884001},{"$f":"L16*(1+'INI-VAL'!$D$12)","v":3919.538644223052},{"$f":"M16*(1+'INI-VAL'!$D$12)","v":4037.1248035497438}]
[null,"Population","Inhab.",{"$f":"'INI-VAL'!H28","v":1077116},{"$f":"ROUND(D17*1.018,0)","v":1096504},{"$f":"ROUND(E17*1.018,0)","v":1116241},{"$f":"ROUND(F17*1.018,0)","v":1136333},1156787,1177609,1198806,1220385,1242352,1264714,1287479]
[null,"Population Served","Inhab.",{"$f":"D10*'INI-VAL'!$H$54+Calculations!D11*'INI-VAL'!$H$55","v":846442},{"$f":"E10*'INI-VAL'!$H$54+Calculations!E11*'INI-VAL'!$H$55","v":846442},{"$f":"F10*'INI-VAL'!$H$54+Calculations!F11*'INI-VAL'!$H$55","v":846442},{"$f":"G10*'INI-VAL'!$H$54+Calculations!G11*'INI-VAL'!$H$55","v":846442},{"$f":"H10*'INI-VAL'!$H$54+Calculations!H11*'INI-VAL'!$H$55","v":846442},{"$f":"I10*'INI-VAL'!$H$54+Calculations!I11*'INI-VAL'!$H$55","v":846442},{"$f":"J10*'INI-VAL'!$H$54+Calculations!J11*'INI-VAL'!$H$55","v":846442},{"$f":"K10*'INI-VAL'!$H$54+Calculations!K11*'INI-VAL'!$H$55","v":846442},{"$f":"L10*'INI-VAL'!$H$54+Calculations!L11*'INI-VAL'!$H$55","v":846442},{"$f":"M10*'INI-VAL'!$H$54+Calculations!M11*'INI-VAL'!$H$55","v":846442},{"$f":"N10*'INI-VAL'!$H$54+Calculations!N11*'INI-VAL'!$H$55","v":846442}]
[null,"Illegal Connections","No.",{"$f":"ROUND(D10*'INI-VAL'!$H$23,0)","v":2532},{"$f":"IF(E4=0,D19,IF(ROUND(((0.0994*E4-0.0118)*0.5+(-0.0882*E3+0.0945)*0.5)*E10,0)<0,0,ROUND(((0.0994*E4-0.0118)*0.5+(-0.0882*E3+0.0945)*0.5)*E10,0)))","v":2736},2736,{"$f":"IF(G4=0,F19,IF(ROUND(((0.0994*G4-0.0118)*0.5+(-0.0882*G3+0.0945)*0.5)*G10,0)<0,0,ROUND(((0.0994*G4-0.0118)*0.5+(-0.0882*G3+0.0945)*0.5)*G10,0)))","v":2736},{"$f":"IF(H4=0,G19,IF(ROUND(((0.0994*H4-0.0118)*0.5+(-0.0882*H3+0.0945)*0.5)*H10,0)<0,0,ROUND(((0.0994*H4-0.0118)*0.5+(-0.0882*H3+0.0945)*0.5)*H10,0)))","v":2736},2736,2736,2736,2736,2736,2736]
[null,"Network Size","km",{"$f":"'INI-VAL'!H46","v":1051},{"$f":"D20+'Yearly Decision'!F12","v":1051},{"$f":"E20+'Yearly Decision'!G12","v":1051},{"$f":"F20+'Yearly Decision'!H12","v":1051},{"$f":"G20+'Yearly Decision'!I12","v":1051},{"$f":"H20+'Yearly Decision'!J12","v":1051},{"$f":"I20+'Yearly Decision'!K12","v":1051},{"$f":"J20+'Yearly Decision'!L12","v":1051},{"$f":"K20+'Yearly Decision'!M12","v":1051},{"$f":"L20+'Yearly Decision'!N12","v":1051},{"$f":"M20+'Yearly Decision'!O12","v":1051}]
[null,"Vol. Treated (Produced)","m3",{"$f":"'INI-VAL'!H41","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:F13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:F14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:F14),$D$21+SUM('Yearly Decision'!$F$13:F13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:G13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:G14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:G14),$D$21+SUM('Yearly Decision'!$F$13:G13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:H13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:H14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:H14),$D$21+SUM('Yearly Decision'!$F$13:H13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:I13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:I14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:I14),$D$21+SUM('Yearly Decision'!$F$13:I13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:J13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:J14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:J14),$D$21+SUM('Yearly Decision'!$F$13:J13))*'INI-VAL'!$D$15","v":26202255},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:K13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:K14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:K14),$D$21+SUM('Yearly Decision'!$F$13:K13))*'INI-VAL'!$D$15","v":26202255},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:L13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:L14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:L14),$D$21+SUM('Yearly Decision'!$F$13:L13))*'INI-VAL'!$D$15","v":26202255},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:M13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:M14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:M14),$D$21+SUM('Yearly Decision'!$F$13:M13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:N13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:N14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:N14),$D$21+SUM('Yearly Decision'!$F$13:N13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:O13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:O14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:O14),$D$21+SUM('Yearly Decision'!$F$13:O13))","v":34936340}]
[null,"Vol. Resource Available","m3",{"$f":"'INI-VAL'!H42","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:F13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:F14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:F14),$D$21+SUM('Yearly Decision'!$F$13:F13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:G13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:G14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:G14),$D$21+SUM('Yearly Decision'!$F$13:G13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:H13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:H14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:H14),$D$21+SUM('Yearly Decision'!$F$13:H13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:I13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:I14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:I14),$D$21+SUM('Yearly Decision'!$F$13:I13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:J13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:J14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:J14),$D$21+SUM('Yearly Decision'!$F$13:J13))*'INI-VAL'!$D$15","v":26202255},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:K13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:K14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:K14),$D$21+SUM('Yearly Decision'!$F$13:K13))*'INI-VAL'!$D$15","v":26202255},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:L13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:L14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:L14),$D$21+SUM('Yearly Decision'!$F$13:L13))*'INI-VAL'!$D$15","v":26202255},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:M13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:M14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:M14),$D$21+SUM('Yearly Decision'!$F$13:M13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:N13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:N14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:N14),$D$21+SUM('Yearly Decision'!$F$13:N13))","v":34936340},{"$f":"IF(($D$21+SUM('Yearly Decision'!$F$13:O13))>=(Calculations!$D$22+SUM('Yearly Decision'!$F$14:O14)),Calculations!$D$22+SUM('Yearly Decision'!$F$14:O14),$D$21+SUM('Yearly Decision'!$F$13:O13))","v":34936340}]
[null,"Vol. Lost","m3",{"$f":"D22*(D91+D94)","v":16070750.895487666},19392439.659323648,20226623.633475788,21060807.607627932,21894991.581780072,17045273.431367114,17669303.176399179,18293332.921431243,25225294.536060467,26059478.510212608,5730590.485171509]
[null,"Vol. Supplied","m3",{"$f":"D21-D23","v":18865589.104512334},{"$f":"E21-E23","v":15543900.340676352},{"$f":"F21-F23","v":14709716.366524212},13875532.392372068,13041348.418219928,9156981.5686328858,8532951.8236008212,7908922.0785687566,9711045.4639395326,8876861.4897873923,29205749.514828492]
[null,"Full Cost Recovery Ratio","-",{"$f":"IFERROR(IF(D26/D29<0,0,D26/D29),0)","v":0.72601549691569134},{"$f":"IFERROR(IF(E26/E29<0,0,E26/E29),0)","v":0.5367016663539228},0.50538846076153854,0.47239459190588806,0.44011829908483646,0.36385387905588912,0.33886564992687157,0.31507559080524911,0.32395293080694065,0.29860366495865676,0.54834192792115155]
[null,"Total Income","US$",{"$f":"((D117*(D13/D10)*D4*D81)+(D14*D6*D83))+(D120*D5*D82)","v":8310699.3931939183},7522107.5128564816,7350209.6123767011,7130856.1690544784,6896953.9945706818,5919527.40916951,5724512.9308145419,5527775.4013182037,5904342.9432617556,5654597.0973369759,10790288.838286452]
[null,"Water consumed by customers","m3",{"$f":"D24","v":18865589.104512334},{"$f":"E24","v":15543900.340676352},14709716.366524212,13875532.392372068,13041348.418219928,9156981.5686328858,8532951.8236008212,7908922.0785687566,9711045.4639395326,8876861.4897873923,29205749.514828492]
[null,"Collection Efficiency Average","Dim.",{"$f":"D80","v":0.72249820843523249},{"$f":"E80","v":0.72726708769213411},{"$f":"F80","v":0.73197088186165349},0.73058202960121998,0.72717483886287904,0.72335069533536289,0.71751827407998536,0.71122219802333597,0.70347592763153677,0.69671495671791961,0.71356387654942066]
[null,"Total Cost","US$",{"$f":"D30+D37+D42+D48","v":11447000},{"$f":"E30+E37+E42+E48","v":14015435.360873464},14543683.093399335,15095126.598051973,15670682.198199708,16268968.808383247,16893163.801199421,17544283.221657015,18225928.466072258,18936797.370252922,19678029.873064958]
[null,"Staff Cost","US$/year",{"$f":"SUM(D31:D36)","v":4572000},{"$f":"SUM(E31:E36)","v":4572000},4572000,4572000,4572000,4572000,4572000,4572000,4572000,4572000,4572000]
[null,"Director","US$/year",{"$f":"'Yearly Decision'!E19*'Yearly Costs'!$D$17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:F19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:G19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:H19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:I19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:J19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:K19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:L19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:M19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:N19))*'Yearly Costs'!$D17","v":1140000},{"$f":"('Yearly Decision'!$E19+SUM('Yearly Decision'!$F19:O19))*'Yearly Costs'!$D17","v":1140000}]
[null,"Manager","US$/year",{"$f":"'Yearly Decision'!E20*'Yearly Costs'!$D$18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:F20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:G20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:H20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:I20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:J20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:K20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:L20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:M20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:N20))*'Yearly Costs'!$D18","v":1950000},{"$f":"('Yearly Decision'!$E20+SUM('Yearly Decision'!$F20:O20))*'Yearly Costs'!$D18","v":1950000}]
[null,"Workers","US$/year",{"$f":"'Yearly Decision'!E21*'Yearly Costs'!$D$19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:F21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:G21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:H21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:I21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:J21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:K21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:L21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:M21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:N21))*'Yearly Costs'!$D19","v":780000},{"$f":"('Yearly Decision'!$E21+SUM('Yearly Decision'!$F21:O21))*'Yearly Costs'!$D19","v":780000}]
[null,"Bill Collectors","US$/year",{"$f":"'Yearly Decision'!E22*'Yearly Costs'!$D$20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:F22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:G22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:H22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:I22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:J22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:K22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:L22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:M22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:N22))*'Yearly Costs'!$D20","v":156000},{"$f":"('Yearly Decision'!$E22+SUM('Yearly Decision'!$F22:O22))*'Yearly Costs'!$D20","v":156000}]
[null,"Costumer Sevices Employees","US$/year",{"$f":"'Yearly Decision'!E23*'Yearly Costs'!$D$21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:F23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:G23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:H23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:I23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:J23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:K23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:L23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:M23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:N23))*'Yearly Costs'!$D21","v":546000},{"$f":"('Yearly Decision'!$E23+SUM('Yearly Decision'!$F23:O23))*'Yearly Costs'!$D21","v":546000}]
[null,"Fired Staff","US$/year",0,{"$f":"IF('Yearly Decision'!F19<=0,ABS('Yearly Decision'!F19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!F20<=0,ABS('Yearly Decision'!F20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!F21<=0,ABS('Yearly Decision'!F21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!F22<=0,ABS('Yearly Decision'!F22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!F23<=0,ABS('Yearly Decision'!F23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!G19<=0,ABS('Yearly Decision'!G19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!G20<=0,ABS('Yearly Decision'!G20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!G21<=0,ABS('Yearly Decision'!G21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!G22<=0,ABS('Yearly Decision'!G22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!G23<=0,ABS('Yearly Decision'!G23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!H19<=0,ABS('Yearly Decision'!H19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!H20<=0,ABS('Yearly Decision'!H20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!H21<=0,ABS('Yearly Decision'!H21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!H22<=0,ABS('Yearly Decision'!H22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!H23<=0,ABS('Yearly Decision'!H23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!I19<=0,ABS('Yearly Decision'!I19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!I20<=0,ABS('Yearly Decision'!I20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!I21<=0,ABS('Yearly Decision'!I21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!I22<=0,ABS('Yearly Decision'!I22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!I23<=0,ABS('Yearly Decision'!I23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!J19<=0,ABS('Yearly Decision'!J19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!J20<=0,ABS('Yearly Decision'!J20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!J21<=0,ABS('Yearly Decision'!J21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!J22<=0,ABS('Yearly Decision'!J22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!J23<=0,ABS('Yearly Decision'!J23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!K19<=0,ABS('Yearly Decision'!K19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!K20<=0,ABS('Yearly Decision'!K20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!K21<=0,ABS('Yearly Decision'!K21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!K22<=0,ABS('Yearly Decision'!K22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!K23<=0,ABS('Yearly Decision'!K23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!L19<=0,ABS('Yearly Decision'!L19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!L20<=0,ABS('Yearly Decision'!L20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!L21<=0,ABS('Yearly Decision'!L21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!L22<=0,ABS('Yearly Decision'!L22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!L23<=0,ABS('Yearly Decision'!L23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!M19<=0,ABS('Yearly Decision'!M19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!M20<=0,ABS('Yearly Decision'!M20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!M21<=0,ABS('Yearly Decision'!M21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!M22<=0,ABS('Yearly Decision'!M22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!M23<=0,ABS('Yearly Decision'!M23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!N19<=0,ABS('Yearly Decision'!N19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!N20<=0,ABS('Yearly Decision'!N20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!N21<=0,ABS('Yearly Decision'!N21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!N22<=0,ABS('Yearly Decision'!N22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!N23<=0,ABS('Yearly Decision'!N23)*'Yearly Costs'!$D$21*0.5,0)","v":0},{"$f":"IF('Yearly Decision'!O19<=0,ABS('Yearly Decision'!O19)*'Yearly Costs'!$D$17*0.5,0)+IF('Yearly Decision'!O20<=0,ABS('Yearly Decision'!O20)*'Yearly Costs'!$D$18*0.5,0)+IF('Yearly Decision'!O21<=0,ABS('Yearly Decision'!O21)*'Yearly Costs'!$D$19*0.5,0)+IF('Yearly Decision'!O22<=0,ABS('Yearly Decision'!O22)*'Yearly Costs'!$D$20*0.5,0)+IF('Yearly Decision'!O23<=0,ABS('Yearly Decision'!O23)*'Yearly Costs'!$D$21*0.5,0)","v":0}]
[null,"Total Infraestructure Investment","US$/year",0,{"$f":"SUM(E38:E41)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Inv. Distribution","US$/year",0,{"$f":"'Yearly Costs'!F12","v":0},{"$f":"'Yearly Costs'!G12","v":0},{"$f":"'Yearly Costs'!H12","v":0},{"$f":"'Yearly Costs'!I12","v":0},{"$f":"'Yearly Costs'!J12","v":0},{"$f":"'Yearly Costs'!K12","v":0},{"$f":"'Yearly Costs'!L12","v":0},{"$f":"'Yearly Costs'!M12","v":0},{"$f":"'Yearly Costs'!N12","v":0},{"$f":"'Yearly Costs'!O12","v":0}]
[null,"Inv. Production","US$/year",0,{"$f":"'Yearly Costs'!F13","v":0},{"$f":"'Yearly Costs'!G13","v":0},{"$f":"'Yearly Costs'!H13","v":0},{"$f":"'Yearly Costs'!I13","v":0},{"$f":"'Yearly Costs'!J13","v":0},{"$f":"'Yearly Costs'!K13","v":0},{"$f":"'Yearly Costs'!L13","v":0},{"$f":"'Yearly Costs'!M13","v":0},{"$f":"'Yearly Costs'!N13","v":0},{"$f":"'Yearly Costs'!O13","v":0}]
[null,"Inv. Resources","US$/year",0,{"$f":"'Yearly Costs'!F14","v":0},{"$f":"'Yearly Costs'!G14","v":0},{"$f":"'Yearly Costs'!H14","v":0},{"$f":"'Yearly Costs'!I14","v":0},{"$f":"'Yearly Costs'!J14","v":0},{"$f":"'Yearly Costs'!K14","v":0},{"$f":"'Yearly Costs'!L14","v":0},{"$f":"'Yearly Costs'!M14","v":0},{"$f":"'Yearly Costs'!N14","v":0},{"$f":"'Yearly Costs'!O14","v":0}]
[null,"Inv. Kiosks + Meters","US$/year",0,{"$f":"('Yearly Costs'!F11+'Yearly Costs'!F15)","v":0},{"$f":"('Yearly Costs'!G11+'Yearly Costs'!G15)","v":0},{"$f":"('Yearly Costs'!H11+'Yearly Costs'!H15)","v":0},{"$f":"('Yearly Costs'!I11+'Yearly Costs'!I15)","v":0},{"$f":"('Yearly Costs'!J11+'Yearly Costs'!J15)","v":0},{"$f":"('Yearly Costs'!K11+'Yearly Costs'!K15)","v":0},{"$f":"('Yearly Costs'!L11+'Yearly Costs'!L15)","v":0},{"$f":"('Yearly Costs'!M11+'Yearly Costs'!M15)","v":0},{"$f":"('Yearly Costs'!N11+'Yearly Costs'!N15)","v":0},{"$f":"('Yearly Costs'!O11+'Yearly Costs'!O15)","v":0}]
[null,"Total Operation & Maintenance","US$/year",{"$f":"D78*0.1","v":6875000},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^E1)*E47+IF(SUM(E43:E46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^E1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^E1*E47),SUM(E43:E46))","v":9443435.3608734645},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^F1)*F47+IF(SUM(F43:F46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^F1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^F1*F47),SUM(F43:F46))","v":9971683.0933993347},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^G1)*G47+IF(SUM(G43:G46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^G1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^G1*G47),SUM(G43:G46))","v":10523126.598051973},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^H1)*H47+IF(SUM(H43:H46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^H1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^H1*H47),SUM(H43:H46))","v":11098682.198199708},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^I1)*I47+IF(SUM(I43:I46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^I1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^I1*I47),SUM(I43:I46))","v":11696968.808383247},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^J1)*J47+IF(SUM(J43:J46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^J1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^J1*J47),SUM(J43:J46))","v":12321163.801199419},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^K1)*K47+IF(SUM(K43:K46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^K1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^K1*K47),SUM(K43:K46))","v":12972283.221657015},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^L1)*L47+IF(SUM(L43:L46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^L1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^L1*L47),SUM(L43:L46))","v":13653928.466072258},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^M1)*M47+IF(SUM(M43:M46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^M1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^M1*M47),SUM(M43:M46))","v":14364797.37025292},{"$f":"(0.7*$D$42*(1+'INI-VAL'!$D$12)^N1)*N47+IF(SUM(N43:N46)<=(0.3*$D$42*(1+'INI-VAL'!$D$12)^N1),(0.3*$D$42*(1+'INI-VAL'!$D$12)^N1*N47),SUM(N43:N46))","v":15106029.873064958}]
[null,"Inv. O&Mdistribution (Network)","US$/year",0,{"$f":"('Yearly Costs'!F23)*$E$47","v":0},{"$f":"('Yearly Costs'!G23)*$F$47","v":0},{"$f":"('Yearly Costs'!H23)*F47*G47","v":0},{"$f":"('Yearly Costs'!I23)*G47*H47","v":0},{"$f":"('Yearly Costs'!J23)*H47*I47","v":0},{"$f":"('Yearly Costs'!K23)*I47*J47","v":0},{"$f":"('Yearly Costs'!L23)*J47*K47","v":0},{"$f":"('Yearly Costs'!M23)*K47*L47","v":0},{"$f":"('Yearly Costs'!N23)*L47*M47","v":0},{"$f":"('Yearly Costs'!O23)*M47*N47","v":0}]
[null,"Inv. O&MProduction (Treatment)","US$/year",0,{"$f":"('Yearly Costs'!F24)*$E$47","v":0},{"$f":"('Yearly Costs'!G24)*$F$47","v":0},{"$f":"('Yearly Costs'!H24)*F47*G47","v":0},{"$f":"('Yearly Costs'!I24)*G47*H47","v":0},{"$f":"('Yearly Costs'!J24)*H47*I47","v":0},{"$f":"('Yearly Costs'!K24)*I47*J47","v":0},{"$f":"('Yearly Costs'!L24)*J47*K47","v":0},{"$f":"('Yearly Costs'!M24)*K47*L47","v":0},{"$f":"('Yearly Costs'!N24)*L47*M47","v":0},{"$f":"('Yearly Costs'!O24)*M47*N47","v":0}]
[null,"Inv. O&MResources","US$/year",0,{"$f":"('Yearly Costs'!F25)*$E$47","v":0},{"$f":"('Yearly Costs'!G25)*$F$47","v":0},{"$f":"('Yearly Costs'!H25)*F47*G47","v":0},{"$f":"('Yearly Costs'!I25)*G47*H47","v":0},{"$f":"('Yearly Costs'!J25)*H47*I47","v":0},{"$f":"('Yearly Costs'!K25)*I47*J47","v":0},{"$f":"('Yearly Costs'!L25)*J47*K47","v":0},{"$f":"('Yearly Costs'!M25)*K47*L47","v":0},{"$f":"('Yearly Costs'!N25)*L47*M47","v":0},{"$f":"('Yearly Costs'!O25)*M47*N47","v":0}]
[null,"Inv. Meter Calibration Program","US$/year",0,{"$f":"('Yearly Costs'!F26)*$E$47","v":0},{"$f":"('Yearly Costs'!G26)*$F$47","v":0},{"$f":"('Yearly Costs'!H26)*F47*G47","v":0},{"$f":"('Yearly Costs'!I26)*G47*H47","v":0},{"$f":"('Yearly Costs'!J26)*H47*I47","v":0},{"$f":"('Yearly Costs'!K26)*I47*J47","v":0},{"$f":"('Yearly Costs'!L26)*J47*K47","v":0},{"$f":"('Yearly Costs'!M26)*K47*L47","v":0},{"$f":"('Yearly Costs'!N26)*L47*M47","v":0},{"$f":"('Yearly Costs'!O26)*M47*N47","v":0}]
[null,"O&M In-Efficiency","%",{"$f":"'INI-VAL'!H9","v":1.3},{"$f":"IF(D47+0.1-(0.1*E54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!E58/E20)<'INI-VAL'!$E$65,0,IF((Calculations!E58/E20)>'INI-VAL'!$C$65,1,(Calculations!E58/E20)/'INI-VAL'!$C$65))+0.2*(Calculations!E62/Calculations!E58)/'INI-VAL'!$C$74)*(1/4)<1,1,D47+0.1-(0.1*E54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!E58/E20)<'INI-VAL'!$E$65,0,IF((Calculations!E58/E20)>'INI-VAL'!$C$65,1,(Calculations!E58/E20)/'INI-VAL'!$C$65))+0.2*(Calculations!E62/Calculations!E58)/'INI-VAL'!$C$74)*(1/4))","v":1.3335831048011952},{"$f":"IF(E47+0.1-(0.1*F54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!F58/F20)<'INI-VAL'!$E$65,0,IF((Calculations!F58/F20)>'INI-VAL'!$C$65,1,(Calculations!F58/F20)/'INI-VAL'!$C$65))+0.2*(Calculations!F62/Calculations!F58)/'INI-VAL'!$C$74)*(1/4)<1,1,E47+0.1-(0.1*F54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!F58/F20)<'INI-VAL'!$E$65,0,IF((Calculations!F58/F20)>'INI-VAL'!$C$65,1,(Calculations!F58/F20)/'INI-VAL'!$C$65))+0.2*(Calculations!F62/Calculations!F58)/'INI-VAL'!$C$74)*(1/4))","v":1.3671662096023904},{"$f":"IF(F47+0.1-(0.1*G54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!G58/G20)<'INI-VAL'!$E$65,0,IF((Calculations!G58/G20)>'INI-VAL'!$C$65,1,(Calculations!G58/G20)/'INI-VAL'!$C$65))+0.2*(Calculations!G62/Calculations!G58)/'INI-VAL'!$C$74)*(1/4)<1,1,F47+0.1-(0.1*G54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!G58/G20)<'INI-VAL'!$E$65,0,IF((Calculations!G58/G20)>'INI-VAL'!$C$65,1,(Calculations!G58/G20)/'INI-VAL'!$C$65))+0.2*(Calculations!G62/Calculations!G58)/'INI-VAL'!$C$74)*(1/4))","v":1.4007493144035856},{"$f":"IF(G47+0.1-(0.1*H54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!H58/H20)<'INI-VAL'!$E$65,0,IF((Calculations!H58/H20)>'INI-VAL'!$C$65,1,(Calculations!H58/H20)/'INI-VAL'!$C$65))+0.2*(Calculations!H62/Calculations!H58)/'INI-VAL'!$C$74)*(1/4)<1,1,G47+0.1-(0.1*H54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!H58/H20)<'INI-VAL'!$E$65,0,IF((Calculations!H58/H20)>'INI-VAL'!$C$65,1,(Calculations!H58/H20)/'INI-VAL'!$C$65))+0.2*(Calculations!H62/Calculations!H58)/'INI-VAL'!$C$74)*(1/4))","v":1.4343324192047808},{"$f":"IF(H47+0.1-(0.1*I54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!I58/I20)<'INI-VAL'!$E$65,0,IF((Calculations!I58/I20)>'INI-VAL'!$C$65,1,(Calculations!I58/I20)/'INI-VAL'!$C$65))+0.2*(Calculations!I62/Calculations!I58)/'INI-VAL'!$C$74)*(1/4)<1,1,H47+0.1-(0.1*I54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!I58/I20)<'INI-VAL'!$E$65,0,IF((Calculations!I58/I20)>'INI-VAL'!$C$65,1,(Calculations!I58/I20)/'INI-VAL'!$C$65))+0.2*(Calculations!I62/Calculations!I58)/'INI-VAL'!$C$74)*(1/4))","v":1.4676229883314846},{"$f":"IF(I47+0.1-(0.1*J54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!J58/J20)<'INI-VAL'!$E$65,0,IF((Calculations!J58/J20)>'INI-VAL'!$C$65,1,(Calculations!J58/J20)/'INI-VAL'!$C$65))+0.2*(Calculations!J62/Calculations!J58)/'INI-VAL'!$C$74)*(1/4)<1,1,I47+0.1-(0.1*J54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!J58/J20)<'INI-VAL'!$E$65,0,IF((Calculations!J58/J20)>'INI-VAL'!$C$65,1,(Calculations!J58/J20)/'INI-VAL'!$C$65))+0.2*(Calculations!J62/Calculations!J58)/'INI-VAL'!$C$74)*(1/4))","v":1.5009135574581884},{"$f":"IF(J47+0.1-(0.1*K54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!K58/K20)<'INI-VAL'!$E$65,0,IF((Calculations!K58/K20)>'INI-VAL'!$C$65,1,(Calculations!K58/K20)/'INI-VAL'!$C$65))+0.2*(Calculations!K62/Calculations!K58)/'INI-VAL'!$C$74)*(1/4)<1,1,J47+0.1-(0.1*K54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!K58/K20)<'INI-VAL'!$E$65,0,IF((Calculations!K58/K20)>'INI-VAL'!$C$65,1,(Calculations!K58/K20)/'INI-VAL'!$C$65))+0.2*(Calculations!K62/Calculations!K58)/'INI-VAL'!$C$74)*(1/4))","v":1.5342041265848922},{"$f":"IF(K47+0.1-(0.1*L54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!L58/L20)<'INI-VAL'!$E$65,0,IF((Calculations!L58/L20)>'INI-VAL'!$C$65,1,(Calculations!L58/L20)/'INI-VAL'!$C$65))+0.2*(Calculations!L62/Calculations!L58)/'INI-VAL'!$C$74)*(1/4)<1,1,K47+0.1-(0.1*L54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!L58/L20)<'INI-VAL'!$E$65,0,IF((Calculations!L58/L20)>'INI-VAL'!$C$65,1,(Calculations!L58/L20)/'INI-VAL'!$C$65))+0.2*(Calculations!L62/Calculations!L58)/'INI-VAL'!$C$74)*(1/4))","v":1.5677872313860874},{"$f":"IF(L47+0.1-(0.1*M54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!M58/M20)<'INI-VAL'!$E$65,0,IF((Calculations!M58/M20)>'INI-VAL'!$C$65,1,(Calculations!M58/M20)/'INI-VAL'!$C$65))+0.2*(Calculations!M62/Calculations!M58)/'INI-VAL'!$C$74)*(1/4)<1,1,L47+0.1-(0.1*M54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!M58/M20)<'INI-VAL'!$E$65,0,IF((Calculations!M58/M20)>'INI-VAL'!$C$65,1,(Calculations!M58/M20)/'INI-VAL'!$C$65))+0.2*(Calculations!M62/Calculations!M58)/'INI-VAL'!$C$74)*(1/4))","v":1.6013703361872826},{"$f":"IF(M47+0.1-(0.1*N54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!N58/N20)<'INI-VAL'!$E$65,0,IF((Calculations!N58/N20)>'INI-VAL'!$C$65,1,(Calculations!N58/N20)/'INI-VAL'!$C$65))+0.2*(Calculations!N62/Calculations!N58)/'INI-VAL'!$C$74)*(1/4)<1,1,M47+0.1-(0.1*N54+0.4*(SUM($E$65:$G$65)/'INI-VAL'!$C$71)+0.3*IF((Calculations!N58/N20)<'INI-VAL'!$E$65,0,IF((Calculations!N58/N20)>'INI-VAL'!$C$65,1,(Calculations!N58/N20)/'INI-VAL'!$C$65))+0.2*(Calculations!N62/Calculations!N58)/'INI-VAL'!$C$74)*(1/4))","v":1.6349534409884778}]
[null,"Total Capacity Development Investment","US$/year",0,{"$f":"SUM(E49:E53)","v":0},{"$f":"SUM(F49:F53)","v":0},0,0,0,0,0,0,0,0]
[null,"Additional Leakage Trainees","US$/year",0,{"$f":"E62*'Yearly Costs'!$D$28","v":0},{"$f":"F62*'Yearly Costs'!$D$28","v":0},{"$f":"G62*'Yearly Costs'!$D$28","v":0},{"$f":"H62*'Yearly Costs'!$D$28","v":0},{"$f":"I62*'Yearly Costs'!$D$28","v":0},{"$f":"J62*'Yearly Costs'!$D$28","v":0},{"$f":"K62*'Yearly Costs'!$D$28","v":0},{"$f":"L62*'Yearly Costs'!$D$28","v":0},{"$f":"M62*'Yearly Costs'!$D$28","v":0},{"$f":"N62*'Yearly Costs'!$D$28","v":0}]
[null,"Additional Staff training","US$/year",0,{"$f":"E63*'Yearly Costs'!$D$28","v":0},{"$f":"F63*'Yearly Costs'!$D$28","v":0},{"$f":"G63*'Yearly Costs'!$D$28","v":0},{"$f":"H63*'Yearly Costs'!$D$28","v":0},{"$f":"I63*'Yearly Costs'!$D$28","v":0},{"$f":"J63*'Yearly Costs'!$D$28","v":0},{"$f":"K63*'Yearly Costs'!$D$28","v":0},{"$f":"L63*'Yearly Costs'!$D$28","v":0},{"$f":"M63*'Yearly Costs'!$D$28","v":0},{"$f":"N63*'Yearly Costs'!$D$28","v":0}]
[null,"Additional Office technology","US$/year",0,{"$f":"E64*'Yearly Costs'!$D$28","v":0},{"$f":"F64*'Yearly Costs'!$D$28","v":0},{"$f":"G64*'Yearly Costs'!$D$28","v":0},{"$f":"H64*'Yearly Costs'!$D$28","v":0},{"$f":"I64*'Yearly Costs'!$D$28","v":0},{"$f":"J64*'Yearly Costs'!$D$28","v":0},{"$f":"K64*'Yearly Costs'!$D$28","v":0},{"$f":"L64*'Yearly Costs'!$D$28","v":0},{"$f":"M64*'Yearly Costs'!$D$28","v":0},{"$f":"N64*'Yearly Costs'!$D$28","v":0}]
[null,"SOPs","US$/year",0,{"$f":"E65*'Yearly Costs'!$D$28","v":0},{"$f":"F65*'Yearly Costs'!$D$28","v":0},{"$f":"G65*'Yearly Costs'!$D$28","v":0},{"$f":"H65*'Yearly Costs'!$D$28","v":0},{"$f":"I65*'Yearly Costs'!$D$28","v":0},{"$f":"J65*'Yearly Costs'!$D$28","v":0},{"$f":"K65*'Yearly Costs'!$D$28","v":0},{"$f":"L65*'Yearly Costs'!$D$28","v":0},{"$f":"M65*'Yearly Costs'!$D$28","v":0},{"$f":"N65*'Yearly Costs'!$D$28","v":0}]
[null,"Awareness Campaigns","US$/year",0,{"$f":"E66*'Yearly Costs'!$D$28","v":0},{"$f":"F66*'Yearly Costs'!$D$28","v":0},{"$f":"G66*'Yearly Costs'!$D$28","v":0},{"$f":"H66*'Yearly Costs'!$D$28","v":0},{"$f":"I66*'Yearly Costs'!$D$28","v":0},{"$f":"J66*'Yearly Costs'!$D$28","v":0},{"$f":"K66*'Yearly Costs'!$D$28","v":0},{"$f":"L66*'Yearly Costs'!$D$28","v":0},{"$f":"M66*'Yearly Costs'!$D$28","v":0},{"$f":"N66*'Yearly Costs'!$D$28","v":0}]
[null,"Utility Efficiency","Ratio",{"$f":"IF((0.5*D55+0.5*D61)<0,0,IF((0.5*D55+0.5*D61)>1,1,(0.5*D55+0.5*D61)))","v":0.44789505492786447},{"$f":"IF((0.5*E55+0.5*E61)<0,0,IF((0.5*E55+0.5*E61)>1,1,(0.5*E55+0.5*E61)))","v":0.44789505492786447},0.44789505492786447,0.44789505492786447,0.44789505492786447,0.4595964819075235,0.4595964819075235,0.4595964819075235,0.44789505492786447,0.44789505492786447,0.44789505492786447]
[null,"Staff efficiency","Ratio",{"$f":"IF((0.15*((D56/D57/'INI-VAL'!$C$63)*0.25+(D57/SUM(D58:D60)/'INI-VAL'!$C$64)*0.75)+0.25*(D58/Calculations!D20/'INI-VAL'!$C$65)+0.1*(Calculations!D58/Calculations!D21/'INI-VAL'!$C$66)+0.25*(Calculations!D59/Calculations!D10/'INI-VAL'!$C$67)+0.25*(Calculations!D60/Calculations!D10/'INI-VAL'!$C$68))>1,1,(0.15*((D56/D57/'INI-VAL'!$C$63)*0.25+(D57/SUM(D58:D60)/'INI-VAL'!$C$64)*0.75)+0.25*(D58/Calculations!D20/'INI-VAL'!$C$65)+0.1*(Calculations!D58/Calculations!D21/'INI-VAL'!$C$66)+0.25*(Calculations!D59/Calculations!D10/'INI-VAL'!$C$67)+0.25*(Calculations!D60/Calculations!D10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((E56/E57/'INI-VAL'!$C$63)*0.25+(E57/SUM(E58:E60)/'INI-VAL'!$C$64)*0.75)+0.25*(E58/Calculations!E20/'INI-VAL'!$C$65)+0.1*(Calculations!E58/Calculations!E21/'INI-VAL'!$C$66)+0.25*(Calculations!E59/Calculations!E10/'INI-VAL'!$C$67)+0.25*(Calculations!E60/Calculations!E10/'INI-VAL'!$C$68))>1,1,(0.15*((E56/E57/'INI-VAL'!$C$63)*0.25+(E57/SUM(E58:E60)/'INI-VAL'!$C$64)*0.75)+0.25*(E58/Calculations!E20/'INI-VAL'!$C$65)+0.1*(Calculations!E58/Calculations!E21/'INI-VAL'!$C$66)+0.25*(Calculations!E59/Calculations!E10/'INI-VAL'!$C$67)+0.25*(Calculations!E60/Calculations!E10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((F56/F57/'INI-VAL'!$C$63)*0.25+(F57/SUM(F58:F60)/'INI-VAL'!$C$64)*0.75)+0.25*(F58/Calculations!F20/'INI-VAL'!$C$65)+0.1*(Calculations!F58/Calculations!F21/'INI-VAL'!$C$66)+0.25*(Calculations!F59/Calculations!F10/'INI-VAL'!$C$67)+0.25*(Calculations!F60/Calculations!F10/'INI-VAL'!$C$68))>1,1,(0.15*((F56/F57/'INI-VAL'!$C$63)*0.25+(F57/SUM(F58:F60)/'INI-VAL'!$C$64)*0.75)+0.25*(F58/Calculations!F20/'INI-VAL'!$C$65)+0.1*(Calculations!F58/Calculations!F21/'INI-VAL'!$C$66)+0.25*(Calculations!F59/Calculations!F10/'INI-VAL'!$C$67)+0.25*(Calculations!F60/Calculations!F10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((G56/G57/'INI-VAL'!$C$63)*0.25+(G57/SUM(G58:G60)/'INI-VAL'!$C$64)*0.75)+0.25*(G58/Calculations!G20/'INI-VAL'!$C$65)+0.1*(Calculations!G58/Calculations!G21/'INI-VAL'!$C$66)+0.25*(Calculations!G59/Calculations!G10/'INI-VAL'!$C$67)+0.25*(Calculations!G60/Calculations!G10/'INI-VAL'!$C$68))>1,1,(0.15*((G56/G57/'INI-VAL'!$C$63)*0.25+(G57/SUM(G58:G60)/'INI-VAL'!$C$64)*0.75)+0.25*(G58/Calculations!G20/'INI-VAL'!$C$65)+0.1*(Calculations!G58/Calculations!G21/'INI-VAL'!$C$66)+0.25*(Calculations!G59/Calculations!G10/'INI-VAL'!$C$67)+0.25*(Calculations!G60/Calculations!G10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((H56/H57/'INI-VAL'!$C$63)*0.25+(H57/SUM(H58:H60)/'INI-VAL'!$C$64)*0.75)+0.25*(H58/Calculations!H20/'INI-VAL'!$C$65)+0.1*(Calculations!H58/Calculations!H21/'INI-VAL'!$C$66)+0.25*(Calculations!H59/Calculations!H10/'INI-VAL'!$C$67)+0.25*(Calculations!H60/Calculations!H10/'INI-VAL'!$C$68))>1,1,(0.15*((H56/H57/'INI-VAL'!$C$63)*0.25+(H57/SUM(H58:H60)/'INI-VAL'!$C$64)*0.75)+0.25*(H58/Calculations!H20/'INI-VAL'!$C$65)+0.1*(Calculations!H58/Calculations!H21/'INI-VAL'!$C$66)+0.25*(Calculations!H59/Calculations!H10/'INI-VAL'!$C$67)+0.25*(Calculations!H60/Calculations!H10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((I56/I57/'INI-VAL'!$C$63)*0.25+(I57/SUM(I58:I60)/'INI-VAL'!$C$64)*0.75)+0.25*(I58/Calculations!I20/'INI-VAL'!$C$65)+0.1*(Calculations!I58/Calculations!I21/'INI-VAL'!$C$66)+0.25*(Calculations!I59/Calculations!I10/'INI-VAL'!$C$67)+0.25*(Calculations!I60/Calculations!I10/'INI-VAL'!$C$68))>1,1,(0.15*((I56/I57/'INI-VAL'!$C$63)*0.25+(I57/SUM(I58:I60)/'INI-VAL'!$C$64)*0.75)+0.25*(I58/Calculations!I20/'INI-VAL'!$C$65)+0.1*(Calculations!I58/Calculations!I21/'INI-VAL'!$C$66)+0.25*(Calculations!I59/Calculations!I10/'INI-VAL'!$C$67)+0.25*(Calculations!I60/Calculations!I10/'INI-VAL'!$C$68)))","v":0.919192963815047},{"$f":"IF((0.15*((J56/J57/'INI-VAL'!$C$63)*0.25+(J57/SUM(J58:J60)/'INI-VAL'!$C$64)*0.75)+0.25*(J58/Calculations!J20/'INI-VAL'!$C$65)+0.1*(Calculations!J58/Calculations!J21/'INI-VAL'!$C$66)+0.25*(Calculations!J59/Calculations!J10/'INI-VAL'!$C$67)+0.25*(Calculations!J60/Calculations!J10/'INI-VAL'!$C$68))>1,1,(0.15*((J56/J57/'INI-VAL'!$C$63)*0.25+(J57/SUM(J58:J60)/'INI-VAL'!$C$64)*0.75)+0.25*(J58/Calculations!J20/'INI-VAL'!$C$65)+0.1*(Calculations!J58/Calculations!J21/'INI-VAL'!$C$66)+0.25*(Calculations!J59/Calculations!J10/'INI-VAL'!$C$67)+0.25*(Calculations!J60/Calculations!J10/'INI-VAL'!$C$68)))","v":0.919192963815047},{"$f":"IF((0.15*((K56/K57/'INI-VAL'!$C$63)*0.25+(K57/SUM(K58:K60)/'INI-VAL'!$C$64)*0.75)+0.25*(K58/Calculations!K20/'INI-VAL'!$C$65)+0.1*(Calculations!K58/Calculations!K21/'INI-VAL'!$C$66)+0.25*(Calculations!K59/Calculations!K10/'INI-VAL'!$C$67)+0.25*(Calculations!K60/Calculations!K10/'INI-VAL'!$C$68))>1,1,(0.15*((K56/K57/'INI-VAL'!$C$63)*0.25+(K57/SUM(K58:K60)/'INI-VAL'!$C$64)*0.75)+0.25*(K58/Calculations!K20/'INI-VAL'!$C$65)+0.1*(Calculations!K58/Calculations!K21/'INI-VAL'!$C$66)+0.25*(Calculations!K59/Calculations!K10/'INI-VAL'!$C$67)+0.25*(Calculations!K60/Calculations!K10/'INI-VAL'!$C$68)))","v":0.919192963815047},{"$f":"IF((0.15*((L56/L57/'INI-VAL'!$C$63)*0.25+(L57/SUM(L58:L60)/'INI-VAL'!$C$64)*0.75)+0.25*(L58/Calculations!L20/'INI-VAL'!$C$65)+0.1*(Calculations!L58/Calculations!L21/'INI-VAL'!$C$66)+0.25*(Calculations!L59/Calculations!L10/'INI-VAL'!$C$67)+0.25*(Calculations!L60/Calculations!L10/'INI-VAL'!$C$68))>1,1,(0.15*((L56/L57/'INI-VAL'!$C$63)*0.25+(L57/SUM(L58:L60)/'INI-VAL'!$C$64)*0.75)+0.25*(L58/Calculations!L20/'INI-VAL'!$C$65)+0.1*(Calculations!L58/Calculations!L21/'INI-VAL'!$C$66)+0.25*(Calculations!L59/Calculations!L10/'INI-VAL'!$C$67)+0.25*(Calculations!L60/Calculations!L10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((M56/M57/'INI-VAL'!$C$63)*0.25+(M57/SUM(M58:M60)/'INI-VAL'!$C$64)*0.75)+0.25*(M58/Calculations!M20/'INI-VAL'!$C$65)+0.1*(Calculations!M58/Calculations!M21/'INI-VAL'!$C$66)+0.25*(Calculations!M59/Calculations!M10/'INI-VAL'!$C$67)+0.25*(Calculations!M60/Calculations!M10/'INI-VAL'!$C$68))>1,1,(0.15*((M56/M57/'INI-VAL'!$C$63)*0.25+(M57/SUM(M58:M60)/'INI-VAL'!$C$64)*0.75)+0.25*(M58/Calculations!M20/'INI-VAL'!$C$65)+0.1*(Calculations!M58/Calculations!M21/'INI-VAL'!$C$66)+0.25*(Calculations!M59/Calculations!M10/'INI-VAL'!$C$67)+0.25*(Calculations!M60/Calculations!M10/'INI-VAL'!$C$68)))","v":0.89579010985572893},{"$f":"IF((0.15*((N56/N57/'INI-VAL'!$C$63)*0.25+(N57/SUM(N58:N60)/'INI-VAL'!$C$64)*0.75)+0.25*(N58/Calculations!N20/'INI-VAL'!$C$65)+0.1*(Calculations!N58/Calculations!N21/'INI-VAL'!$C$66)+0.25*(Calculations!N59/Calculations!N10/'INI-VAL'!$C$67)+0.25*(Calculations!N60/Calculations!N10/'INI-VAL'!$C$68))>1,1,(0.15*((N56/N57/'INI-VAL'!$C$63)*0.25+(N57/SUM(N58:N60)/'INI-VAL'!$C$64)*0.75)+0.25*(N58/Calculations!N20/'INI-VAL'!$C$65)+0.1*(Calculations!N58/Calculations!N21/'INI-VAL'!$C$66)+0.25*(Calculations!N59/Calculations!N10/'INI-VAL'!$C$67)+0.25*(Calculations!N60/Calculations!N10/'INI-VAL'!$C$68)))","v":0.89579010985572893}]
[null,"Directors","Unit",{"$f":"'Yearly Decision'!E19","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:F19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:G19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:H19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:I19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:J19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:K19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:L19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:M19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:N19)","v":19},{"$f":"$D56+SUM('Yearly Decision'!$F19:O19)","v":19}]
[null,"Managers","Unit",{"$f":"'Yearly Decision'!E20","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:F20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:G20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:H20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:I20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:J20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:K20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:L20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:M20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:N20)","v":65},{"$f":"$D57+SUM('Yearly Decision'!$F20:O20)","v":65}]
[null,"Workers (Operations)","Unit",{"$f":"'Yearly Decision'!E21","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:F21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:G21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:H21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:I21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:J21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:K21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:L21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:M21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:N21)","v":130},{"$f":"$D58+SUM('Yearly Decision'!$F21:O21)","v":130}]
[null,"Bill Collectors","Unit",{"$f":"'Yearly Decision'!E22","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:F22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:G22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:H22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:I22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:J22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:K22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:L22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:M22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:N22)","v":26},{"$f":"$D59+SUM('Yearly Decision'!$F22:O22)","v":26}]
[null,"Customer Service","Unit",{"$f":"'Yearly Decision'!E23","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:F23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:G23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:H23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:I23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:J23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:K23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:L23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:M23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:N23)","v":91},{"$f":"$D60+SUM('Yearly Decision'!$F23:O23)","v":91}]
[null,"Process efficiency","Ratio",{"$f":"IF(0.3*(SUM($D$65:$F$65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM($D$65:$F$65)/'INI-VAL'!$C$71))+IF(0.3*(SUM($D$62:$G$63)/(SUM(D56:D60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM($D$62:$G$63)/(SUM(D56:D60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM($D$62:$G$62)/D58)>0.1,0.1,0.1*(SUM($D$62:$G$62)/D58))+IF(0.2*(D64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(D64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!D66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!D66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM($D$65:$F$65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM($D$65:$F$65)/'INI-VAL'!$C$71))+IF(0.3*(SUM($D$62:$G$63)/(SUM(E56:E60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM($D$62:$G$63)/(SUM(E56:E60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM($D$62:$G$62)/E58)>0.1,0.1,0.1*(SUM($D$62:$G$62)/E58))+IF(0.2*(E64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(E64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!E66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!E66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(D65:F65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(D65:F65)/'INI-VAL'!$C$71))+IF(0.3*(SUM($D$62:$G$63)/(SUM(F56:F60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM($D$62:$G$63)/(SUM(F56:F60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM($D$62:$G$62)/F58)>0.1,0.1,0.1*(SUM($D$62:$G$62)/F58))+IF(0.2*(F64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(F64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!F66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!F66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(E65:G65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(E65:G65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(D62:G63)/(SUM(G56:G60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(D62:G63)/(SUM(G56:G60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(D62:G62)/G58)>0.1,0.1,0.1*(SUM(D62:G62)/G58))+IF(0.2*(G64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(G64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!G66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!G66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(F65:H65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(F65:H65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(E62:H63)/(SUM(H56:H60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(E62:H63)/(SUM(H56:H60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(E62:H62)/H58)>0.1,0.1,0.1*(SUM(E62:H62)/H58))+IF(0.2*(H64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(H64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!H66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!H66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(G65:I65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(G65:I65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(F62:I63)/(SUM(I56:I60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(F62:I63)/(SUM(I56:I60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(F62:I62)/I58)>0.1,0.1,0.1*(SUM(F62:I62)/I58))+IF(0.2*(I64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(I64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!I66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!I66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(H65:J65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(H65:J65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(G62:J63)/(SUM(J56:J60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(G62:J63)/(SUM(J56:J60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(G62:J62)/J58)>0.1,0.1,0.1*(SUM(G62:J62)/J58))+IF(0.2*(J64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(J64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!J66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!J66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(I65:K65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(I65:K65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(H62:K63)/(SUM(K56:K60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(H62:K63)/(SUM(K56:K60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(H62:K62)/K58)>0.1,0.1,0.1*(SUM(H62:K62)/K58))+IF(0.2*(K64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(K64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!K66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!K66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(J65:L65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(J65:L65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(I62:L63)/(SUM(L56:L60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(I62:L63)/(SUM(L56:L60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(I62:L62)/L58)>0.1,0.1,0.1*(SUM(I62:L62)/L58))+IF(0.2*(L64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(L64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!L66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!L66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(K65:M65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(K65:M65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(J62:M63)/(SUM(M56:M60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(J62:M63)/(SUM(M56:M60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(J62:M62)/M58)>0.1,0.1,0.1*(SUM(J62:M62)/M58))+IF(0.2*(M64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(M64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!M66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!M66/'INI-VAL'!$C$73))","v":0},{"$f":"IF(0.3*(SUM(L65:N65)/'INI-VAL'!$C$71)>0.3,0.3,0.3*(SUM(L65:N65)/'INI-VAL'!$C$71))+IF(0.3*(SUM(K62:N63)/(SUM(N56:N60)/'INI-VAL'!$C$70))>0.3,0.3,0.3*(SUM(K62:N63)/(SUM(N56:N60)/'INI-VAL'!$C$70)))+IF(0.1*(SUM(K62:N62)/N58)>0.1,0.1,0.1*(SUM(K62:N62)/N58))+IF(0.2*(N64/'INI-VAL'!$C$72)>0.2,0.2,0.2*(N64/'INI-VAL'!$C$72))+IF(0.1*(Calculations!N66/'INI-VAL'!$C$73)>0.1,0.1,0.1*(Calculations!N66/'INI-VAL'!$C$73))","v":0}]
[null,"Leakage Trainees","Unit",{"$f":"'Yearly Decision'!E30","v":0},{"$f":"'Yearly Decision'!F30","v":0},{"$f":"'Yearly Decision'!G30","v":0},{"$f":"'Yearly Decision'!H30","v":0},{"$f":"'Yearly Decision'!I30","v":0},{"$f":"'Yearly Decision'!J30","v":0},{"$f":"'Yearly Decision'!K30","v":0},{"$f":"'Yearly Decision'!L30","v":0},{"$f":"'Yearly Decision'!M30","v":0},{"$f":"'Yearly Decision'!N30","v":0},{"$f":"'Yearly Decision'!O30","v":0}]
[null,"Staff Trainings","Unit",{"$f":"'Yearly Decision'!E31","v":0},{"$f":"'Yearly Decision'!F31","v":0},{"$f":"'Yearly Decision'!G31","v":0},{"$f":"'Yearly Decision'!H31","v":0},{"$f":"'Yearly Decision'!I31","v":0},{"$f":"'Yearly Decision'!J31","v":0},{"$f":"'Yearly Decision'!K31","v":0},{"$f":"'Yearly Decision'!L31","v":0},{"$f":"'Yearly Decision'!M31","v":0},{"$f":"'Yearly Decision'!N31","v":0},{"$f":"'Yearly Decision'!O31","v":0}]
[null,"Office","Unit",{"$f":"'Yearly Decision'!E32","v":0},{"$f":"'Yearly Decision'!F32","v":0},{"$f":"'Yearly Decision'!G32","v":0},{"$f":"'Yearly Decision'!H32","v":0},{"$f":"'Yearly Decision'!I32","v":0},{"$f":"'Yearly Decision'!J32","v":0},{"$f":"'Yearly Decision'!K32","v":0},{"$f":"'Yearly Decision'!L32","v":0},{"$f":"'Yearly Decision'!M32","v":0},{"$f":"'Yearly Decision'!N32","v":0},{"$f":"'Yearly Decision'!O32","v":0}]
[null,"SOP's","Unit",{"$f":"'Yearly Decision'!E33","v":0},{"$f":"'Yearly Decision'!F33","v":0},{"$f":"'Yearly Decision'!G33","v":0},{"$f":"'Yearly Decision'!H33","v":0},{"$f":"'Yearly Decision'!I33","v":0},{"$f":"'Yearly Decision'!J33","v":0},{"$f":"'Yearly Decision'!K33","v":0},{"$f":"'Yearly Decision'!L33","v":0},{"$f":"'Yearly Decision'!M33","v":0},{"$f":"'Yearly Decision'!N33","v":0},{"$f":"'Yearly Decision'!O33","v":0}]
[null,"Awareness Campaigns","Unit",{"$f":"'Yearly Decision'!E34","v":0},{"$f":"'Yearly Decision'!F34","v":0},{"$f":"'Yearly Decision'!G34","v":0},{"$f":"'Yearly Decision'!H34","v":0},{"$f":"'Yearly Decision'!I34","v":0},{"$f":"'Yearly Decision'!J34","v":0},{"$f":"'Yearly Decision'!K34","v":0},{"$f":"'Yearly Decision'!L34","v":0},{"$f":"'Yearly Decision'!M34","v":0},{"$f":"'Yearly Decision'!N34","v":0},{"$f":"'Yearly Decision'!O34","v":0}]
[null,"Ratios "]
[null,"Director to Manager","Ratio",{"$f":"D56/D57","v":0.29230769230769232},0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232,0.29230769230769232]
[null,"Management to Workers","Ratio",{"$f":"SUM(D56:D57)/SUM(D58:D60)","v":0.34008097165991902},0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902,0.34008097165991902]
[null,"Workers to Network Size (km)","Ratio",{"$f":"D58/D20","v":0.12369172216936251},0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251,0.12369172216936251]
[null,"Workers to Treatment Capacity (m3)","Ratio",{"$f":"D58/D21","v":3.7210537795315708E-6},3.7210537795315708E-6,3.7210537795315708E-6,3.7210537795315708E-6,3.7210537795315708E-6,4.9614050393754277E-6,4.9614050393754277E-6,4.9614050393754277E-6,3.7210537795315708E-6,3.7210537795315708E-6,3.7210537795315708E-6]
[null,"Bill Collectors to # of Connections","Ratio",{"$f":"D59/D10","v":5.1343825904934931E-4},5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4,5.1343825904934931E-4]
[null,"Costumer Service to # of Connections","Ratio",{"$f":"D60/D10","v":1.7970339066727225E-3},1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3,1.7970339066727225E-3]
[null,"Maintence to Network","Ratio",{"$f":"D38/D20","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance to Treatment (Production)","Ratio",{"$f":"D39/D20","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance to Resource","Ratio",{"$f":"D40/D20","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Asset Value","US$",{"$f":"'INI-VAL'!H45","v":68750000},{"$f":"D78+SUM(E38:E41)-D79","v":67375000},66027500,64706950,63412811,62144554.780000001,60901663.6844,59683630.410711996,58489957.802497759,57320158.646447808,56173755.473518848]
[null,"Depreciation","US$/year",{"$f":"0.02*D78","v":1375000},{"$f":"0.02*E78","v":1347500},1320550,1294139,1268256.22,1242891.0956000001,1218033.2736879999,1193672.6082142401,1169799.1560499552,1146403.1729289561,1123475.109470377]
[null,"Collection Efficiency","%",{"$f":"IFERROR((D81*D13+D82*D11+D83*D14)/D10,0)","v":0.72249820843523249},{"$f":"(E81*E13+E82*E11+E83*E14)/E10","v":0.72726708769213411},0.73197088186165349,0.73058202960121998,0.72717483886287904,0.72335069533536289,{"$f":"(J81*J13+J82*J11+J83*J14)/J10","v":0.71751827407998536},{"$f":"(K81*K13+K82*K11+K83*K14)/K10","v":0.71122219802333597},0.70347592763153677,0.69671495671791961,0.71356387654942066]
[null,"In-house  Col. Eff.","%",{"$f":"IF(IF(D84<=0.025,1,(-0.464*(LN(Calculations!D84))-0.5884))*0.3+D86*0.3+IF(D72<'INI-VAL'!$E$67,0,IF(D72>'INI-VAL'!$C$67,1,(D72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.3+D54*0.1>1,1,IF(D84<=0.025,1,(-0.464*(LN(Calculations!D84))-0.5884))*0.3+D86*0.3+IF(D72<'INI-VAL'!$E$67,0,IF(D72>'INI-VAL'!$C$67,1,(D72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.3+D54*0.1)","v":0.71013619496735192},{"$f":"IF(IF(E84<=0.025,1,(-0.464*(LN(Calculations!E84))-0.5884))*0.25+E86*0.25+IF(E72<'INI-VAL'!$E$67,0,IF(E72>'INI-VAL'!$C$67,1,(E72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+E54*0.1>1,1,IF(E84<=0.025,1,(-0.464*(LN(Calculations!E84))-0.5884))*0.25+E86*0.25+IF(E72<'INI-VAL'!$E$67,0,IF(E72>'INI-VAL'!$C$67,1,(E72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+E54*0.1)","v":0.71490507422425364},{"$f":"IF(IF(F84<=0.025,1,(-0.464*(LN(Calculations!F84))-0.5884))*0.25+F86*0.25+IF(F72<'INI-VAL'!$E$67,0,IF(F72>'INI-VAL'!$C$67,1,(F72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+F54*0.1>1,1,IF(F84<=0.025,1,(-0.464*(LN(Calculations!F84))-0.5884))*0.25+F86*0.25+IF(F72<'INI-VAL'!$E$67,0,IF(F72>'INI-VAL'!$C$67,1,(F72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+F54*0.1)","v":0.71960886839377303},{"$f":"IF(IF(G84<=0.025,1,(-0.464*(LN(Calculations!G84))-0.5884))*0.25+G86*0.25+IF(G72<'INI-VAL'!$E$67,0,IF(G72>'INI-VAL'!$C$67,1,(G72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+G54*0.1>1,1,IF(G84<=0.025,1,(-0.464*(LN(Calculations!G84))-0.5884))*0.25+G86*0.25+IF(G72<'INI-VAL'!$E$67,0,IF(G72>'INI-VAL'!$C$67,1,(G72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+G54*0.1)","v":0.71822001613333952},{"$f":"IF(IF(H84<=0.025,1,(-0.464*(LN(Calculations!H84))-0.5884))*0.25+H86*0.25+IF(H72<'INI-VAL'!$E$67,0,IF(H72>'INI-VAL'!$C$67,1,(H72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+H54*0.1>1,1,IF(H84<=0.025,1,(-0.464*(LN(Calculations!H84))-0.5884))*0.25+H86*0.25+IF(H72<'INI-VAL'!$E$67,0,IF(H72>'INI-VAL'!$C$67,1,(H72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+H54*0.1)","v":0.71481282539499857},{"$f":"IF(IF(I84<=0.025,1,(-0.464*(LN(Calculations!I84))-0.5884))*0.25+I86*0.25+IF(I72<'INI-VAL'!$E$67,0,IF(I72>'INI-VAL'!$C$67,1,(I72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+I54*0.1>1,1,IF(I84<=0.025,1,(-0.464*(LN(Calculations!I84))-0.5884))*0.25+I86*0.25+IF(I72<'INI-VAL'!$E$67,0,IF(I72>'INI-VAL'!$C$67,1,(I72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+I54*0.1)","v":0.71098868186748232},{"$f":"IF(IF(J84<=0.025,1,(-0.464*(LN(Calculations!J84))-0.5884))*0.25+J86*0.25+IF(J72<'INI-VAL'!$E$67,0,IF(J72>'INI-VAL'!$C$67,1,(J72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+J54*0.1>1,1,IF(J84<=0.025,1,(-0.464*(LN(Calculations!J84))-0.5884))*0.25+J86*0.25+IF(J72<'INI-VAL'!$E$67,0,IF(J72>'INI-VAL'!$C$67,1,(J72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+J54*0.1)","v":0.7051562606121049},{"$f":"IF(IF(K84<=0.025,1,(-0.464*(LN(Calculations!K84))-0.5884))*0.25+K86*0.25+IF(K72<'INI-VAL'!$E$67,0,IF(K72>'INI-VAL'!$C$67,1,(K72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+K54*0.1>1,1,IF(K84<=0.025,1,(-0.464*(LN(Calculations!K84))-0.5884))*0.25+K86*0.25+IF(K72<'INI-VAL'!$E$67,0,IF(K72>'INI-VAL'!$C$67,1,(K72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+K54*0.1)","v":0.69886018455545551},{"$f":"IF(IF(L84<=0.025,1,(-0.464*(LN(Calculations!L84))-0.5884))*0.25+L86*0.25+IF(L72<'INI-VAL'!$E$67,0,IF(L72>'INI-VAL'!$C$67,1,(L72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+L54*0.1>1,1,IF(L84<=0.025,1,(-0.464*(LN(Calculations!L84))-0.5884))*0.25+L86*0.25+IF(L72<'INI-VAL'!$E$67,0,IF(L72>'INI-VAL'!$C$67,1,(L72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+L54*0.1)","v":0.69111391416365631},{"$f":"IF(IF(M84<=0.025,1,(-0.464*(LN(Calculations!M84))-0.5884))*0.25+M86*0.25+IF(M72<'INI-VAL'!$E$67,0,IF(M72>'INI-VAL'!$C$67,1,(M72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+M54*0.1>1,1,IF(M84<=0.025,1,(-0.464*(LN(Calculations!M84))-0.5884))*0.25+M86*0.25+IF(M72<'INI-VAL'!$E$67,0,IF(M72>'INI-VAL'!$C$67,1,(M72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+M54*0.1)","v":0.68435294325003904},{"$f":"IF(IF(N84<=0.025,1,(-0.464*(LN(Calculations!N84))-0.5884))*0.25+N86*0.25+IF(N72<'INI-VAL'!$E$67,0,IF(N72>'INI-VAL'!$C$67,1,(N72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+N54*0.1>1,1,IF(N84<=0.025,1,(-0.464*(LN(Calculations!N84))-0.5884))*0.25+N86*0.25+IF(N72<'INI-VAL'!$E$67,0,IF(N72>'INI-VAL'!$C$67,1,(N72-'INI-VAL'!$E$67)/('INI-VAL'!$C$67-'INI-VAL'!$E$67)))*0.4+N54*0.1)","v":0.7012018630815402}]
[null,"StandPipe Col. Eff.","%",1,1,1,1,1,1,1,1,1,1,1]
[null,"Un-metered  Col. Eff.","%",{"$f":"D81","v":0.71013619496735192},{"$f":"E81","v":0.71490507422425364},{"$f":"F81","v":0.71960886839377303},0.71822001613333952,0.71481282539499857,0.71098868186748232,0.7051562606121049,0.69886018455545551,0.69111391416365631,0.68435294325003904,0.7012018630815402]
[null,"Affordability","%",{"$f":"IF(((D4*'INI-VAL'!$H$30*12)/D16)>1,1,((D4*'INI-VAL'!$H$30*12)/D16))","v":5.0002130492676419E-2},{"$f":"IF(E4=0,D84,IF(((E4*'INI-VAL'!$H$30*12)/E16)>1,1,((E4*'INI-VAL'!$H$30*12)/E16)))","v":4.8545757759880022E-2},{"$f":"IF(F4=0,E84,IF(((F4*'INI-VAL'!$H$30*12)/F16)>1,1,((F4*'INI-VAL'!$H$30*12)/F16)))","v":4.7131803650368953E-2},{"$f":"IF(G4=0,F84,IF(((G4*'INI-VAL'!$H$30*12)/G16)>1,1,((G4*'INI-VAL'!$H$30*12)/G16)))","v":4.5759032670261116E-2},{"$f":"IF(H4=0,G84,IF(((H4*'INI-VAL'!$H$30*12)/H16)>1,1,((H4*'INI-VAL'!$H$30*12)/H16)))","v":4.4426245310933123E-2},{"$f":"IF(I4=0,H84,IF(((I4*'INI-VAL'!$H$30*12)/I16)>1,1,((I4*'INI-VAL'!$H$30*12)/I16)))","v":4.3132277000905939E-2},{"$f":"IF(J4=0,I84,IF(((J4*'INI-VAL'!$H$30*12)/J16)>1,1,((J4*'INI-VAL'!$H$30*12)/J16)))","v":4.1875997088258191E-2},{"$f":"IF(K4=0,J84,IF(((K4*'INI-VAL'!$H$30*12)/K16)>1,1,((K4*'INI-VAL'!$H$30*12)/K16)))","v":4.0656307852677855E-2},{"$f":"IF(L4=0,K84,IF(((L4*'INI-VAL'!$H$30*12)/L16)>1,1,((L4*'INI-VAL'!$H$30*12)/L16)))","v":3.9472143546289175E-2},{"$f":"IF(M4=0,L84,IF(((M4*'INI-VAL'!$H$30*12)/M16)>1,1,((M4*'INI-VAL'!$H$30*12)/M16)))","v":3.8322469462416679E-2},{"$f":"IF(N4=0,M84,IF(((N4*'INI-VAL'!$H$30*12)/N16)>1,1,((N4*'INI-VAL'!$H$30*12)/N16)))","v":3.7206281031472499E-2}]
[null,"Customer Satisfaction out of 10","Unit",{"$f":"D86*10","v":7.5},{"$f":"E86*10","v":7.9919131611504337},8.042912085530439,7.8502051527123342,7.5767646807779325,7.2398403893578775,6.8693906967420162,6.4803948120752715,6.0801968619211735,5.6726051829757198,{"$f":"N86*10","v":6.2094091338349964}]
[null,"Customer Satisfaction","%",{"$f":"'INI-VAL'!H7/10","v":0.75},{"$f":"IF(E4=0,D86,IF(IF(E4>D4,IF((D86/2-(E4-D4)/D4)<=0.1,0.1,(D86/2-(E4-D4)/D4)),IF(E4<(D4*0.8),0.5,D86/2+(D4-E4)/(D4*0.25)))>0.4,0.4,IF(E4>D4,IF((D86/2-(E4-D4)/D4)<=0.1,0.1,(D86/2-(E4-D4)/D4)),IF(E4<(D4*0.8),0.4,D86/2+(D4-E4)/(D4*0.25))))+0.2*E88+0.2*E89+0.1*E87+IF((E73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((E73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(E73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.79919131611504335},{"$f":"IF(F4=0,E86,IF(IF(F4>E4,IF((E86/2-(F4-E4)/E4)<=0.1,0.1,(E86/2-(F4-E4)/E4)),IF(F4<(E4*0.8),0.5,E86/2+(E4-F4)/(E4*0.25)))>0.4,0.4,IF(F4>E4,IF((E86/2-(F4-E4)/E4)<=0.1,0.1,(E86/2-(F4-E4)/E4)),IF(F4<(E4*0.8),0.4,E86/2+(E4-F4)/(E4*0.25))))+0.2*F88+0.2*F89+0.1*F87+IF((F73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((F73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(F73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.80429120855304392},{"$f":"IF(G4=0,F86,IF(IF(G4>F4,IF((F86/2-(G4-F4)/F4)<=0.1,0.1,(F86/2-(G4-F4)/F4)),IF(G4<(F4*0.8),0.5,F86/2+(F4-G4)/(F4*0.25)))>0.4,0.4,IF(G4>F4,IF((F86/2-(G4-F4)/F4)<=0.1,0.1,(F86/2-(G4-F4)/F4)),IF(G4<(F4*0.8),0.4,F86/2+(F4-G4)/(F4*0.25))))+0.2*G88+0.2*G89+0.1*G87+IF((G73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((G73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(G73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.7850205152712334},{"$f":"IF(H4=0,G86,IF(IF(H4>G4,IF((G86/2-(H4-G4)/G4)<=0.1,0.1,(G86/2-(H4-G4)/G4)),IF(H4<(G4*0.8),0.5,G86/2+(G4-H4)/(G4*0.25)))>0.4,0.4,IF(H4>G4,IF((G86/2-(H4-G4)/G4)<=0.1,0.1,(G86/2-(H4-G4)/G4)),IF(H4<(G4*0.8),0.4,G86/2+(G4-H4)/(G4*0.25))))+0.2*H88+0.2*H89+0.1*H87+IF((H73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((H73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(H73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.75767646807779321},{"$f":"IF(I4=0,H86,IF(IF(I4>H4,IF((H86/2-(I4-H4)/H4)<=0.1,0.1,(H86/2-(I4-H4)/H4)),IF(I4<(H4*0.8),0.5,H86/2+(H4-I4)/(H4*0.25)))>0.4,0.4,IF(I4>H4,IF((H86/2-(I4-H4)/H4)<=0.1,0.1,(H86/2-(I4-H4)/H4)),IF(I4<(H4*0.8),0.4,H86/2+(H4-I4)/(H4*0.25))))+0.2*I88+0.2*I89+0.1*I87+IF((I73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((I73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(I73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.72398403893578778},{"$f":"IF(J4=0,I86,IF(IF(J4>I4,IF((I86/2-(J4-I4)/I4)<=0.1,0.1,(I86/2-(J4-I4)/I4)),IF(J4<(I4*0.8),0.5,I86/2+(I4-J4)/(I4*0.25)))>0.4,0.4,IF(J4>I4,IF((I86/2-(J4-I4)/I4)<=0.1,0.1,(I86/2-(J4-I4)/I4)),IF(J4<(I4*0.8),0.4,I86/2+(I4-J4)/(I4*0.25))))+0.2*J88+0.2*J89+0.1*J87+IF((J73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((J73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(J73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.6869390696742016},{"$f":"IF(K4=0,J86,IF(IF(K4>J4,IF((J86/2-(K4-J4)/J4)<=0.1,0.1,(J86/2-(K4-J4)/J4)),IF(K4<(J4*0.8),0.5,J86/2+(J4-K4)/(J4*0.25)))>0.4,0.4,IF(K4>J4,IF((J86/2-(K4-J4)/J4)<=0.1,0.1,(J86/2-(K4-J4)/J4)),IF(K4<(J4*0.8),0.4,J86/2+(J4-K4)/(J4*0.25))))+0.2*K88+0.2*K89+0.1*K87+IF((K73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((K73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(K73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.64803948120752719},{"$f":"IF(L4=0,K86,IF(IF(L4>K4,IF((K86/2-(L4-K4)/K4)<=0.1,0.1,(K86/2-(L4-K4)/K4)),IF(L4<(K4*0.8),0.5,K86/2+(K4-L4)/(K4*0.25)))>0.4,0.4,IF(L4>K4,IF((K86/2-(L4-K4)/K4)<=0.1,0.1,(K86/2-(L4-K4)/K4)),IF(L4<(K4*0.8),0.4,K86/2+(K4-L4)/(K4*0.25))))+0.2*L88+0.2*L89+0.1*L87+IF((L73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((L73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(L73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.60801968619211733},{"$f":"IF(M4=0,L86,IF(IF(M4>L4,IF((L86/2-(M4-L4)/L4)<=0.1,0.1,(L86/2-(M4-L4)/L4)),IF(M4<(L4*0.8),0.5,L86/2+(L4-M4)/(L4*0.25)))>0.4,0.4,IF(M4>L4,IF((L86/2-(M4-L4)/L4)<=0.1,0.1,(L86/2-(M4-L4)/L4)),IF(M4<(L4*0.8),0.4,L86/2+(L4-M4)/(L4*0.25))))+0.2*M88+0.2*M89+0.1*M87+IF((M73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((M73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(M73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.56726051829757196},{"$f":"IF(N4=0,M86,IF(IF(N4>M4,IF((M86/2-(N4-M4)/M4)<=0.1,0.1,(M86/2-(N4-M4)/M4)),IF(N4<(M4*0.8),0.5,M86/2+(M4-N4)/(M4*0.25)))>0.4,0.4,IF(N4>M4,IF((M86/2-(N4-M4)/M4)<=0.1,0.1,(M86/2-(N4-M4)/M4)),IF(N4<(M4*0.8),0.4,M86/2+(M4-N4)/(M4*0.25))))+0.2*N88+0.2*N89+0.1*N87+IF((N73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)>1,1,IF((N73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)<0,0,(N73-'INI-VAL'!$E$68)/('INI-VAL'!$D$68-'INI-VAL'!$E$68)))*0.1)","v":0.62094091338349966}]
[null,"Awareness","%",{"$f":"D101/10","v":0.7},{"$f":"E101/10","v":0.65},0.6,0.55000000000000004,0.5,0.45,0.4,0.35,0.3,0.25,0.2]
[null,"Water Quality","%",{"$f":"'INI-VAL'!H20","v":0.7},{"$f":"IF(SUM('Yearly Decision'!F25:F27)=0,D88-0.05,IF(((IF(E91<0.05,1,(0.7-E91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/E20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/E22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/E22)/4)*0.8+IF((E58/E21)>'INI-VAL'!$C$66,1,((E58/E21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!E54*0.1)>0.95,0.95,IF((IF(E91<0.05,1,(0.7-E91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/E20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/E22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/E22)/4)*0.8+IF((E58/E21)>'INI-VAL'!$C$66,1,((E58/E21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!E54*0.1<D88-0.05,D88-0.05,(IF(E91<0.05,1,(0.7-E91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/E20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/E22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/E22)/4)*0.8+IF((E58/E21)>'INI-VAL'!$C$66,1,((E58/E21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!E54*0.1)))","v":0.64999999999999991},{"$f":"IF(SUM('Yearly Decision'!G25:G27)=0,E88-0.05,IF(((IF(F91<0.05,1,(0.7-F91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/F20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/F22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/F22)/4)*0.8+IF((F58/F21)>'INI-VAL'!$C$66,1,((F58/F21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!F54*0.1)>0.95,0.95,IF((IF(F91<0.05,1,(0.7-F91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/F20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/F22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/F22)/4)*0.8+IF((F58/F21)>'INI-VAL'!$C$66,1,((F58/F21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!F54*0.1<E88-0.05,E88-0.05,(IF(F91<0.05,1,(0.7-F91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/F20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/F22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/F22)/4)*0.8+IF((F58/F21)>'INI-VAL'!$C$66,1,((F58/F21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!F54*0.1)))","v":0.59999999999999987},{"$f":"IF(SUM('Yearly Decision'!H25:H27)=0,F88-0.05,IF(((IF(G91<0.05,1,(0.7-G91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/G20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/G22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/G22)/4)*0.8+IF((G58/G21)>'INI-VAL'!$C$66,1,((G58/G21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!G54*0.1)>0.95,0.95,IF((IF(G91<0.05,1,(0.7-G91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/G20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/G22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/G22)/4)*0.8+IF((G58/G21)>'INI-VAL'!$C$66,1,((G58/G21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!G54*0.1<F88-0.05,F88-0.05,(IF(G91<0.05,1,(0.7-G91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/G20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/G22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/G22)/4)*0.8+IF((G58/G21)>'INI-VAL'!$C$66,1,((G58/G21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!G54*0.1)))","v":0.54999999999999982},{"$f":"IF(SUM('Yearly Decision'!I25:I27)=0,G88-0.05,IF(((IF(H91<0.05,1,(0.7-H91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/H20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/H22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/H22)/4)*0.8+IF((H58/H21)>'INI-VAL'!$C$66,1,((H58/H21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!H54*0.1)>0.95,0.95,IF((IF(H91<0.05,1,(0.7-H91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/H20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/H22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/H22)/4)*0.8+IF((H58/H21)>'INI-VAL'!$C$66,1,((H58/H21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!H54*0.1<G88-0.05,G88-0.05,(IF(H91<0.05,1,(0.7-H91)/(0.7-0.05))/4+(SUM('Yearly Decision'!$F$88:$J$88)/H20)/4+(SUM('Yearly Decision'!$F$27:$J$27)/H22)/4+(SUM('Yearly Decision'!$F$26:$J$26)/H22)/4)*0.8+IF((H58/H21)>'INI-VAL'!$C$66,1,((H58/H21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!H54*0.1)))","v":0.49999999999999983},{"$f":"IF(SUM('Yearly Decision'!J25:J27)=0,H88-0.05,IF(((IF(I91<0.05,1,(0.7-I91)/(0.7-0.05))/4+(SUM('Yearly Decision'!F88:J88)/I20)/4+(SUM('Yearly Decision'!F27:J27)/I22)/4+(SUM('Yearly Decision'!F26:J26)/I22)/4)*0.8+IF((I58/I21)>'INI-VAL'!$C$66,1,((I58/I21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!I54*0.1)>0.95,0.95,IF((IF(I91<0.05,1,(0.7-I91)/(0.7-0.05))/4+(SUM('Yearly Decision'!F88:J88)/I20)/4+(SUM('Yearly Decision'!F27:J27)/I22)/4+(SUM('Yearly Decision'!F26:J26)/I22)/4)*0.8+IF((I58/I21)>'INI-VAL'!$C$66,1,((I58/I21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!I54*0.1<H88-0.05,H88-0.05,(IF(I91<0.05,1,(0.7-I91)/(0.7-0.05))/4+(SUM('Yearly Decision'!F88:J88)/I20)/4+(SUM('Yearly Decision'!F27:J27)/I22)/4+(SUM('Yearly Decision'!F26:J26)/I22)/4)*0.8+IF((I58/I21)>'INI-VAL'!$C$66,1,((I58/I21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!I54*0.1)))","v":0.44999999999999984},{"$f":"IF(SUM('Yearly Decision'!K25:K27)=0,I88-0.05,IF(((IF(J91<0.05,1,(0.7-J91)/(0.7-0.05))/4+(SUM('Yearly Decision'!G88:K88)/J20)/4+(SUM('Yearly Decision'!G27:K27)/J22)/4+(SUM('Yearly Decision'!G26:K26)/J22)/4)*0.8+IF((J58/J21)>'INI-VAL'!$C$66,1,((J58/J21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!J54*0.1)>0.95,0.95,IF((IF(J91<0.05,1,(0.7-J91)/(0.7-0.05))/4+(SUM('Yearly Decision'!G88:K88)/J20)/4+(SUM('Yearly Decision'!G27:K27)/J22)/4+(SUM('Yearly Decision'!G26:K26)/J22)/4)*0.8+IF((J58/J21)>'INI-VAL'!$C$66,1,((J58/J21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!J54*0.1<I88-0.05,I88-0.05,(IF(J91<0.05,1,(0.7-J91)/(0.7-0.05))/4+(SUM('Yearly Decision'!G88:K88)/J20)/4+(SUM('Yearly Decision'!G27:K27)/J22)/4+(SUM('Yearly Decision'!G26:K26)/J22)/4)*0.8+IF((J58/J21)>'INI-VAL'!$C$66,1,((J58/J21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!J54*0.1)))","v":0.39999999999999986},{"$f":"IF(SUM('Yearly Decision'!L25:L27)=0,J88-0.05,IF(((IF(K91<0.05,1,(0.7-K91)/(0.7-0.05))/4+(SUM('Yearly Decision'!H88:L88)/K20)/4+(SUM('Yearly Decision'!H27:L27)/K22)/4+(SUM('Yearly Decision'!H26:L26)/K22)/4)*0.8+IF((K58/K21)>'INI-VAL'!$C$66,1,((K58/K21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!K54*0.1)>0.95,0.95,IF((IF(K91<0.05,1,(0.7-K91)/(0.7-0.05))/4+(SUM('Yearly Decision'!H88:L88)/K20)/4+(SUM('Yearly Decision'!H27:L27)/K22)/4+(SUM('Yearly Decision'!H26:L26)/K22)/4)*0.8+IF((K58/K21)>'INI-VAL'!$C$66,1,((K58/K21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!K54*0.1<J88-0.05,J88-0.05,(IF(K91<0.05,1,(0.7-K91)/(0.7-0.05))/4+(SUM('Yearly Decision'!H88:L88)/K20)/4+(SUM('Yearly Decision'!H27:L27)/K22)/4+(SUM('Yearly Decision'!H26:L26)/K22)/4)*0.8+IF((K58/K21)>'INI-VAL'!$C$66,1,((K58/K21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!K54*0.1)))","v":0.34999999999999987},{"$f":"IF(SUM('Yearly Decision'!M25:M27)=0,K88-0.05,IF(((IF(L91<0.05,1,(0.7-L91)/(0.7-0.05))/4+(SUM('Yearly Decision'!I88:M88)/L20)/4+(SUM('Yearly Decision'!I27:M27)/L22)/4+(SUM('Yearly Decision'!I26:M26)/L22)/4)*0.8+IF((L58/L21)>'INI-VAL'!$C$66,1,((L58/L21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!L54*0.1)>0.95,0.95,IF((IF(L91<0.05,1,(0.7-L91)/(0.7-0.05))/4+(SUM('Yearly Decision'!I88:M88)/L20)/4+(SUM('Yearly Decision'!I27:M27)/L22)/4+(SUM('Yearly Decision'!I26:M26)/L22)/4)*0.8+IF((L58/L21)>'INI-VAL'!$C$66,1,((L58/L21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!L54*0.1<K88-0.05,K88-0.05,(IF(L91<0.05,1,(0.7-L91)/(0.7-0.05))/4+(SUM('Yearly Decision'!I88:M88)/L20)/4+(SUM('Yearly Decision'!I27:M27)/L22)/4+(SUM('Yearly Decision'!I26:M26)/L22)/4)*0.8+IF((L58/L21)>'INI-VAL'!$C$66,1,((L58/L21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!L54*0.1)))","v":0.29999999999999988},{"$f":"IF(SUM('Yearly Decision'!N25:N27)=0,L88-0.05,IF(((IF(M91<0.05,1,(0.7-M91)/(0.7-0.05))/4+(SUM('Yearly Decision'!J88:N88)/M20)/4+(SUM('Yearly Decision'!J27:N27)/M22)/4+(SUM('Yearly Decision'!J26:N26)/M22)/4)*0.8+IF((M58/M21)>'INI-VAL'!$C$66,1,((M58/M21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!M54*0.1)>0.95,0.95,IF((IF(M91<0.05,1,(0.7-M91)/(0.7-0.05))/4+(SUM('Yearly Decision'!J88:N88)/M20)/4+(SUM('Yearly Decision'!J27:N27)/M22)/4+(SUM('Yearly Decision'!J26:N26)/M22)/4)*0.8+IF((M58/M21)>'INI-VAL'!$C$66,1,((M58/M21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!M54*0.1<L88-0.05,L88-0.05,(IF(M91<0.05,1,(0.7-M91)/(0.7-0.05))/4+(SUM('Yearly Decision'!J88:N88)/M20)/4+(SUM('Yearly Decision'!J27:N27)/M22)/4+(SUM('Yearly Decision'!J26:N26)/M22)/4)*0.8+IF((M58/M21)>'INI-VAL'!$C$66,1,((M58/M21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!M54*0.1)))","v":0.24999999999999989},{"$f":"IF(SUM('Yearly Decision'!O25:O27)=0,M88-0.05,IF(((IF(N91<0.05,1,(0.7-N91)/(0.7-0.05))/4+(SUM('Yearly Decision'!K88:O88)/N20)/4+(SUM('Yearly Decision'!K27:O27)/N22)/4+(SUM('Yearly Decision'!K26:O26)/N22)/4)*0.8+IF((N58/N21)>'INI-VAL'!$C$66,1,((N58/N21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!N54*0.1)>0.95,0.95,IF((IF(N91<0.05,1,(0.7-N91)/(0.7-0.05))/4+(SUM('Yearly Decision'!K88:O88)/N20)/4+(SUM('Yearly Decision'!K27:O27)/N22)/4+(SUM('Yearly Decision'!K26:O26)/N22)/4)*0.8+IF((N58/N21)>'INI-VAL'!$C$66,1,((N58/N21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!N54*0.1<M88-0.05,M88-0.05,(IF(N91<0.05,1,(0.7-N91)/(0.7-0.05))/4+(SUM('Yearly Decision'!K88:O88)/N20)/4+(SUM('Yearly Decision'!K27:O27)/N22)/4+(SUM('Yearly Decision'!K26:O26)/N22)/4)*0.8+IF((N58/N21)>'INI-VAL'!$C$66,1,((N58/N21)-'INI-VAL'!$E$66)/('INI-VAL'!$C$66-'INI-VAL'!$E$66))*0.1+Calculations!N54*0.1)))","v":0.1999999999999999}]
[null,"Continuity","%",{"$f":"((-26.952*D91^2-10.555*D91+23.599)*0.7+(218.85*D19/D10+2.3279)*0.15+(-0.0006*D10+43.471)*0.15)/24*D24/D27+0.028","v":0.71793776721910652},0.64595658057521665,0.6234777524776115,0.60010257635616659,0.57583105221088238,0.55072902448445571,0.52473525103153873,0.49784973185213172,0.46999972794176881,0.44125337600756653,0.88655327117356819]
[null,"Continuity","Hours",{"$f":"D89*24","v":17.230506413258556},{"$f":"E89*24","v":15.502957933805199},{"$f":"F89*24","v":14.963466059462675},14.402461832547999,13.819945253061178,13.217496587626936,12.593646024756929,11.948393564451161,11.279993470602452,10.590081024181597,21.277278508165637]
[null,"Physical Losses","%",{"$f":"'INI-VAL'!$H$17","v":0.3},{"$f":"IF(IF((E92/E21)>1,1,(E92/E21))<0,0,(E92/E21))","v":0.39104981157591606},0.41492706872855828,0.43880432588120055,0.46268158303384277,0.48649746243170611,0.51031334182956956,0.53412922122743289,0.55800647838007522,0.58188373553271744,0]
[null,"Physical Loss Volumen","m3",{"$f":"D91*D21","v":10480902},{"$f":"('Yearly Decision'!F36*0.2+'Yearly Decision'!F37)*8718*E93","v":13661849.17415214},{"$f":"('Yearly Decision'!G36*0.2+'Yearly Decision'!G37)*8718*F93","v":14496033.14830428},{"$f":"('Yearly Decision'!H36*0.2+'Yearly Decision'!H37)*8718*G93","v":15330217.122456422},{"$f":"('Yearly Decision'!I36*0.2+'Yearly Decision'!I37)*8718*H93","v":16164401.096608562},{"$f":"('Yearly Decision'!J36*0.2+'Yearly Decision'!J37)*8718*I93*'INI-VAL'!$D$15","v":12747330.567488484},{"$f":"('Yearly Decision'!K36*0.2+'Yearly Decision'!K37)*8718*J93*'INI-VAL'!$D$15","v":13371360.312520549},{"$f":"('Yearly Decision'!L36*0.2+'Yearly Decision'!L37)*8718*K93*'INI-VAL'!$D$15","v":13995390.05755261},{"$f":"('Yearly Decision'!M36*0.2+'Yearly Decision'!M37)*8718*L93","v":19494704.050888956},{"$f":"('Yearly Decision'!N36*0.2+'Yearly Decision'!N37)*8718*M93","v":20328888.025041096},{"$f":"('Yearly Decision'!O36*0.2+'Yearly Decision'!O37)*8718*N93","v":0}]
[null,"Physical Losses In-efficiency","%",{"$f":"'INI-VAL'!H18","v":1.4},{"$f":"IF((D93+0.1-0.2*(E54*0.1+IF((SUM($E$62:$G$62)/Calculations!E58)>'INI-VAL'!$C$74,1,(SUM($E$62:$G$62)/Calculations!E58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/E20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7))<1,1,(D93+0.1-0.2*(E54*0.1+IF((SUM($E$62:$G$62)/Calculations!E58)>'INI-VAL'!$C$74,1,(SUM($E$62:$G$62)/Calculations!E58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/E20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7)))","v":1.4910420989014428},{"$f":"IF((E93+0.1-0.2*(F54*0.1+IF((SUM($E$62:$G$62)/Calculations!F58)>'INI-VAL'!$C$74,1,(SUM($E$62:$G$62)/Calculations!F58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/F20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7))<1,1,(E93+0.1-0.2*(F54*0.1+IF((SUM($E$62:$G$62)/Calculations!F58)>'INI-VAL'!$C$74,1,(SUM($E$62:$G$62)/Calculations!F58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/F20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7)))","v":1.5820841978028857},{"$f":"IF((F93+0.1-0.2*(G54*0.1+IF((SUM($E$62:$G$62)/Calculations!G58)>'INI-VAL'!$C$74,1,(SUM($E$62:$G$62)/Calculations!G58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/G20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7))<1,1,(F93+0.1-0.2*(G54*0.1+IF((SUM($E$62:$G$62)/Calculations!G58)>'INI-VAL'!$C$74,1,(SUM($E$62:$G$62)/Calculations!G58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/G20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7)))","v":1.6731262967043286},{"$f":"IF((G93+0.1-0.2*(H54*0.1+IF((SUM(E62:G62)/Calculations!H58)>'INI-VAL'!$C$74,1,(SUM(E62:G62)/Calculations!H58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/H20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7))<1,1,(G93+0.1-0.2*(H54*0.1+IF((SUM(E62:G62)/Calculations!H58)>'INI-VAL'!$C$74,1,(SUM(E62:G62)/Calculations!H58))*0.2+IF((SUM('Yearly Decision'!$F$25:$J$25)/H20)>1,1,(SUM('Yearly Decision'!$F$25:$J$25)))*0.7)))","v":1.7641683956057714},{"$f":"IF((H93+0.1-0.2*(I54*0.1+IF((SUM(F62:H62)/Calculations!I58)>'INI-VAL'!$C$74,1,(SUM(F62:H62)/Calculations!I58))*0.2+IF((SUM('Yearly Decision'!F25:J25)/I20)>1,1,(SUM('Yearly Decision'!F25:J25)))*0.7))<1,1,(H93+0.1-0.2*(I54*0.1+IF((SUM(F62:H62)/Calculations!I58)>'INI-VAL'!$C$74,1,(SUM(F62:H62)/Calculations!I58))*0.2+IF((SUM('Yearly Decision'!F25:J25)/I20)>1,1,(SUM('Yearly Decision'!F25:J25)))*0.7)))","v":1.8549764659676211},{"$f":"IF((I93+0.1-0.2*(J54*0.1+IF((SUM(G62:I62)/Calculations!J58)>'INI-VAL'!$C$74,1,(SUM(G62:I62)/Calculations!J58))*0.2+IF((SUM('Yearly Decision'!G25:K25)/J20)>1,1,(SUM('Yearly Decision'!G25:K25)))*0.7))<1,1,(I93+0.1-0.2*(J54*0.1+IF((SUM(G62:I62)/Calculations!J58)>'INI-VAL'!$C$74,1,(SUM(G62:I62)/Calculations!J58))*0.2+IF((SUM('Yearly Decision'!G25:K25)/J20)>1,1,(SUM('Yearly Decision'!G25:K25)))*0.7)))","v":1.9457845363294708},{"$f":"IF((J93+0.1-0.2*(K54*0.1+IF((SUM(H62:J62)/Calculations!K58)>'INI-VAL'!$C$74,1,(SUM(H62:J62)/Calculations!K58))*0.2+IF((SUM('Yearly Decision'!H25:L25)/K20)>1,1,(SUM('Yearly Decision'!H25:L25)))*0.7))<1,1,(J93+0.1-0.2*(K54*0.1+IF((SUM(H62:J62)/Calculations!K58)>'INI-VAL'!$C$74,1,(SUM(H62:J62)/Calculations!K58))*0.2+IF((SUM('Yearly Decision'!H25:L25)/K20)>1,1,(SUM('Yearly Decision'!H25:L25)))*0.7)))","v":2.0365926066913205},{"$f":"IF((K93+0.1-0.2*(L54*0.1+IF((SUM(I62:K62)/Calculations!L58)>'INI-VAL'!$C$74,1,(SUM(I62:K62)/Calculations!L58))*0.2+IF((SUM('Yearly Decision'!I25:M25)/L20)>1,1,(SUM('Yearly Decision'!I25:M25)))*0.7))<1,1,(K93+0.1-0.2*(L54*0.1+IF((SUM(I62:K62)/Calculations!L58)>'INI-VAL'!$C$74,1,(SUM(I62:K62)/Calculations!L58))*0.2+IF((SUM('Yearly Decision'!I25:M25)/L20)>1,1,(SUM('Yearly Decision'!I25:M25)))*0.7)))","v":2.1276347055927634},{"$f":"IF((L93+0.1-0.2*(M54*0.1+IF((SUM(J62:L62)/Calculations!M58)>'INI-VAL'!$C$74,1,(SUM(J62:L62)/Calculations!M58))*0.2+IF((SUM('Yearly Decision'!J25:N25)/M20)>1,1,(SUM('Yearly Decision'!J25:N25)))*0.7))<1,1,(L93+0.1-0.2*(M54*0.1+IF((SUM(J62:L62)/Calculations!M58)>'INI-VAL'!$C$74,1,(SUM(J62:L62)/Calculations!M58))*0.2+IF((SUM('Yearly Decision'!J25:N25)/M20)>1,1,(SUM('Yearly Decision'!J25:N25)))*0.7)))","v":2.2186768044942062},{"$f":"IF((M93+0.1-0.2*(N54*0.1+IF((SUM(K62:M62)/Calculations!N58)>'INI-VAL'!$C$74,1,(SUM(K62:M62)/Calculations!N58))*0.2+IF((SUM('Yearly Decision'!K25:O25)/N20)>1,1,(SUM('Yearly Decision'!K25:O25)))*0.7))<1,1,(M93+0.1-0.2*(N54*0.1+IF((SUM(K62:M62)/Calculations!N58)>'INI-VAL'!$C$74,1,(SUM(K62:M62)/Calculations!N58))*0.2+IF((SUM('Yearly Decision'!K25:O25)/N20)>1,1,(SUM('Yearly Decision'!K25:O25)))*0.7)))","v":2.3097189033956491}]
[null,"Comercial Losses","%",{"$f":"IF(IF((D96+D97+D98)>1,1,(D96+D97+D98))<0,0,IF((D96+D97+D98)>1,1,(D96+D97+D98)))","v":0.16000098738126742},{"$f":"IF(IF((E96+E97+E98)>1,1,(E96+E97+E98))<0,0,IF((E96+E97+E98)>1,1,(E96+E97+E98)))","v":0.16402950295227001},0.16402950295227001,0.16402950295227001,0.16402950295227001,0.16402950295227001,0.16402950295227001,0.16402950295227001,0.16402950295227001,0.16402950295227001,0.16402950295227001]
[null,"Comercial Loss Volumen","m3",{"$f":"D21*D94","v":5589848.895487668},5730590.485171509,5730590.485171509,5730590.485171509,5730590.485171509,4297942.863878632,4297942.863878632,4297942.863878632,5730590.485171509,5730590.485171509,5730590.485171509]
[null,"Illegal Connections","%",{"$f":"D19/D10","v":5.0000987381267403E-2},5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2,5.4029502952269992E-2]
[null,"Meter Errors ","%",{"$f":"(D126*'INI-VAL'!$D$43+Calculations!D127*'INI-VAL'!$D$44+Calculations!D128*'INI-VAL'!$D$45)/Calculations!D13+IF(IF(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!D126:D128)<=0.2,-(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!D126:D128)-0.2),-SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!D126:D128))/10<-0.01,-0.01,IF(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!D126:D128)<=0.2,-(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!D126:D128)-0.2),-SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!D126:D128))/10)","v":0.1},{"$f":"(E126*'INI-VAL'!$D$43+Calculations!E127*'INI-VAL'!$D$44+Calculations!E128*'INI-VAL'!$D$45)/Calculations!E13+IF(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!E126:E128)<=0.2,-(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!E126:E128)-0.2),-SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!E126:E128))/10","v":0.1},{"$f":"(F126*'INI-VAL'!$D$43+Calculations!F127*'INI-VAL'!$D$44+Calculations!F128*'INI-VAL'!$D$45)/Calculations!F13+IF(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!F126:F128)<=0.2,-(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!F126:F128)-0.2),-SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!F126:F128))/10","v":0.1},{"$f":"(G126*'INI-VAL'!$D$43+Calculations!G127*'INI-VAL'!$D$44+Calculations!G128*'INI-VAL'!$D$45)/Calculations!G13+IF(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!G126:G128)<=0.2,-(SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!G126:G128)-0.2),-SUM('Yearly Decision'!$F$28:$I$28)/SUM(Calculations!G126:G128))/10","v":0.1},{"$f":"(H126*'INI-VAL'!$D$43+Calculations!H127*'INI-VAL'!$D$44+Calculations!H128*'INI-VAL'!$D$45)/Calculations!H13+IF(SUM('Yearly Decision'!F28:I28)/SUM(Calculations!H126:H128)<=0.2,-(SUM('Yearly Decision'!F28:I28)/SUM(Calculations!H126:H128)-0.2),-SUM('Yearly Decision'!F28:I28)/SUM(Calculations!H126:H128))/10","v":0.1},{"$f":"(I126*'INI-VAL'!$D$43+Calculations!I127*'INI-VAL'!$D$44+Calculations!I128*'INI-VAL'!$D$45)/Calculations!I13+IF(SUM('Yearly Decision'!G28:J28)/SUM(Calculations!I126:I128)<=0.2,-(SUM('Yearly Decision'!G28:J28)/SUM(Calculations!I126:I128)-0.2),-SUM('Yearly Decision'!G28:J28)/SUM(Calculations!I126:I128))/10","v":0.1},{"$f":"(J126*'INI-VAL'!$D$43+Calculations!J127*'INI-VAL'!$D$44+Calculations!J128*'INI-VAL'!$D$45)/Calculations!J13+IF(SUM('Yearly Decision'!H28:K28)/SUM(Calculations!J126:J128)<=0.2,-(SUM('Yearly Decision'!H28:K28)/SUM(Calculations!J126:J128)-0.2),-SUM('Yearly Decision'!H28:K28)/SUM(Calculations!J126:J128))/10","v":0.1},{"$f":"(K126*'INI-VAL'!$D$43+Calculations!K127*'INI-VAL'!$D$44+Calculations!K128*'INI-VAL'!$D$45)/Calculations!K13+IF(SUM('Yearly Decision'!I28:L28)/SUM(Calculations!K126:K128)<=0.2,-(SUM('Yearly Decision'!I28:L28)/SUM(Calculations!K126:K128)-0.2),-SUM('Yearly Decision'!I28:L28)/SUM(Calculations!K126:K128))/10","v":0.1},{"$f":"(L126*'INI-VAL'!$D$43+Calculations!L127*'INI-VAL'!$D$44+Calculations!L128*'INI-VAL'!$D$45)/Calculations!L13+IF(SUM('Yearly Decision'!J28:M28)/SUM(Calculations!L126:L128)<=0.2,-(SUM('Yearly Decision'!J28:M28)/SUM(Calculations!L126:L128)-0.2),-SUM('Yearly Decision'!J28:M28)/SUM(Calculations!L126:L128))/10","v":0.1},{"$f":"(M126*'INI-VAL'!$D$43+Calculations!M127*'INI-VAL'!$D$44+Calculations!M128*'INI-VAL'!$D$45)/Calculations!M13+IF(SUM('Yearly Decision'!K28:N28)/SUM(Calculations!M126:M128)<=0.2,-(SUM('Yearly Decision'!K28:N28)/SUM(Calculations!M126:M128)-0.2),-SUM('Yearly Decision'!K28:N28)/SUM(Calculations!M126:M128))/10","v":0.1},{"$f":"(N126*'INI-VAL'!$D$43+Calculations!N127*'INI-VAL'!$D$44+Calculations!N128*'INI-VAL'!$D$45)/Calculations!N13+IF(SUM('Yearly Decision'!L28:O28)/SUM(Calculations!N126:N128)<=0.2,-(SUM('Yearly Decision'!L28:O28)/SUM(Calculations!N126:N128)-0.2),-SUM('Yearly Decision'!L28:O28)/SUM(Calculations!N126:N128))/10","v":0.1}]
[null,"Own Use","%",{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01},{"$f":"'INI-VAL'!$H$24","v":0.01}]
[null,"Coverage","%",{"$f":"IF((D18/D17)>1,1,D18/D17)","v":0.78584107932664637},0.77194611237168309,0.75829681941444549,0.74488904220857799,0.73171811232318484,0.71878017236620984,0.70607087385281686,0.69358604047083505,0.68132220175924374,0.66927542511587601,0.65744140292773712]
[null,"Willingness to Connect","%",{"$f":"IF(0.7+(0.03*(D101+2*D102)/3)<0.2,0.2,IF(0.7+(0.03*(D101+2*D102)/3)>0.99,0.99,0.7+(0.03*(D101+2*D102)/3)))","v":0.85},{"$f":"IF(0.7+(0.03*(E101+2*E102)/3)<0.2,0.2,IF(0.7+(0.03*(E101+2*E102)/3)>0.99,0.99,0.7+(0.03*(E101+2*E102)/3)))","v":0.84499999999999997},0.84,0.83499999999999996,0.83,0.82499999999999996,0.82,0.81499999999999995,0.80999999999999994,0.80499999999999994,0.79999999999999993]
[null,"Awareness (1-10)","Unit",{"$f":"'INI-VAL'!H53","v":7},{"$f":"IF(IF('Yearly Decision'!F34>0,Calculations!D101+'Yearly Decision'!F34,Calculations!D101-0.5)>=10,10,IF('Yearly Decision'!F34>0,Calculations!D101+'Yearly Decision'!F34,Calculations!D101-0.5))","v":6.5},{"$f":"IF(IF('Yearly Decision'!G34>0,Calculations!E101+'Yearly Decision'!G34,Calculations!E101-0.5)>=10,10,IF('Yearly Decision'!G34>0,Calculations!E101+'Yearly Decision'!G34,Calculations!E101-0.5))","v":6},{"$f":"IF(IF('Yearly Decision'!H34>0,Calculations!F101+'Yearly Decision'!H34,Calculations!F101-0.5)>=10,10,IF('Yearly Decision'!H34>0,Calculations!F101+'Yearly Decision'!H34,Calculations!F101-0.5))","v":5.5},{"$f":"IF(IF('Yearly Decision'!I34>0,Calculations!G101+'Yearly Decision'!I34,Calculations!G101-0.5)>=10,10,IF('Yearly Decision'!I34>0,Calculations!G101+'Yearly Decision'!I34,Calculations!G101-0.5))","v":5},{"$f":"IF(IF('Yearly Decision'!J34>0,Calculations!H101+'Yearly Decision'!J34,Calculations!H101-0.5)>=10,10,IF('Yearly Decision'!J34>0,Calculations!H101+'Yearly Decision'!J34,Calculations!H101-0.5))","v":4.5},{"$f":"IF(IF('Yearly Decision'!K34>0,Calculations!I101+'Yearly Decision'!K34,Calculations!I101-0.5)>=10,10,IF('Yearly Decision'!K34>0,Calculations!I101+'Yearly Decision'!K34,Calculations!I101-0.5))","v":4},{"$f":"IF(IF('Yearly Decision'!L34>0,Calculations!J101+'Yearly Decision'!L34,Calculations!J101-0.5)>=10,10,IF('Yearly Decision'!L34>0,Calculations!J101+'Yearly Decision'!L34,Calculations!J101-0.5))","v":3.5},{"$f":"IF(IF('Yearly Decision'!M34>0,Calculations!K101+'Yearly Decision'!M34,Calculations!K101-0.5)>=10,10,IF('Yearly Decision'!M34>0,Calculations!K101+'Yearly Decision'!M34,Calculations!K101-0.5))","v":3},{"$f":"IF(IF('Yearly Decision'!N34>0,Calculations!L101+'Yearly Decision'!N34,Calculations!L101-0.5)>=10,10,IF('Yearly Decision'!N34>0,Calculations!L101+'Yearly Decision'!N34,Calculations!L101-0.5))","v":2.5},{"$f":"IF(IF('Yearly Decision'!O34>0,Calculations!M101+'Yearly Decision'!O34,Calculations!M101-0.5)>=10,10,IF('Yearly Decision'!O34>0,Calculations!M101+'Yearly Decision'!O34,Calculations!M101-0.5))","v":2}]
[null,"Subsidy impact","Unit",{"$f":"D3*10","v":4},4,4,4,4,4,4,4,4,4,4]
[]
[null,"Total Demand","m3",{"$f":"D105+D112+D113","v":34941616.815487668},{"$f":"E105+E112+E113","v":38263305.579323649},39097489.55347579,39931673.527627937,40765857.501780078,35916139.351367116,36540169.096399181,37164198.841431245,44096160.456060469,44930344.430212609,24601456.40517151]
[null,"Demand Consumers","m3",{"$f":"('INI-VAL'!$H$30*Calculations!D13*12)+('INI-VAL'!$H$31*Calculations!D11*12)+('INI-VAL'!$H$32*Calculations!D14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!E13*12)+('INI-VAL'!$H$31*Calculations!E11*12)+('INI-VAL'!$H$32*Calculations!E14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!F13*12)+('INI-VAL'!$H$31*Calculations!F11*12)+('INI-VAL'!$H$32*Calculations!F14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!G13*12)+('INI-VAL'!$H$31*Calculations!G11*12)+('INI-VAL'!$H$32*Calculations!G14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!H13*12)+('INI-VAL'!$H$31*Calculations!H11*12)+('INI-VAL'!$H$32*Calculations!H14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!I13*12)+('INI-VAL'!$H$31*Calculations!I11*12)+('INI-VAL'!$H$32*Calculations!I14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!J13*12)+('INI-VAL'!$H$31*Calculations!J11*12)+('INI-VAL'!$H$32*Calculations!J14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!K13*12)+('INI-VAL'!$H$31*Calculations!K11*12)+('INI-VAL'!$H$32*Calculations!K14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!L13*12)+('INI-VAL'!$H$31*Calculations!L11*12)+('INI-VAL'!$H$32*Calculations!L14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!M13*12)+('INI-VAL'!$H$31*Calculations!M11*12)+('INI-VAL'!$H$32*Calculations!M14*12)","v":18870865.920000002},{"$f":"('INI-VAL'!$H$30*Calculations!N13*12)+('INI-VAL'!$H$31*Calculations!N11*12)+('INI-VAL'!$H$32*Calculations!N14*12)","v":18870865.920000002}]
[null,"In-house connections Demand","m3",{"$f":"(D13*'INI-VAL'!$H$30+D14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(E13*'INI-VAL'!$H$30+E14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(F13*'INI-VAL'!$H$30+F14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(G13*'INI-VAL'!$H$30+G14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(H13*'INI-VAL'!$H$30+H14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(I13*'INI-VAL'!$H$30+I14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(J13*'INI-VAL'!$H$30+J14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(K13*'INI-VAL'!$H$30+K14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(L13*'INI-VAL'!$H$30+L14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(M13*'INI-VAL'!$H$30+M14*'INI-VAL'!$H$32)*12","v":16646562.720000001},{"$f":"(N13*'INI-VAL'!$H$30+N14*'INI-VAL'!$H$32)*12","v":16646562.720000001}]
[null,"In-house connections Demand","%",{"$f":"D106/(D106+D109)","v":0.88213030554985783},0.88213030554985783,0.88213030554985783,0.88213030554985783,0.88213030554985783,{"$f":"I106/(I106+I109)","v":0.88213030554985783},0.88213030554985783,0.88213030554985783,0.88213030554985783,0.88213030554985783,0.88213030554985783]
[null,"Liters per capita per day In-house","lcd",{"$f":"D106/(D10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"E106/(E10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"F106/(F10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"G106/(G10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"H106/(H10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"I106/(I10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"J106/(J10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"K106/(K10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"L106/(L10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"M106/(M10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059},{"$f":"N106/(N10*'INI-VAL'!$H$54)*(1000/365)","v":112.57879586555059}]
[null,"Water Kiosks Demand","m3",{"$f":"(D11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(E11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(F11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(G11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(H11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(I11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(J11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(K11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(L11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(M11*'INI-VAL'!$H$31*12)","v":2224303.2000000002},{"$f":"(N11*'INI-VAL'!$H$31*12)","v":2224303.2000000002}]
[null,"Water Kiosks Demand","%",{"$f":"1-D107","v":0.11786969445014217},0.11786969445014217,0.11786969445014217,{"$f":"1-G107","v":0.11786969445014217},{"$f":"1-H107","v":0.11786969445014217},0.11786969445014217,0.11786969445014217,0.11786969445014217,0.11786969445014217,0.11786969445014217,0.11786969445014217]
[null,"Liters per capita per day PSP","lcd",{"$f":"D109/(D11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"E109/(E11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"F109/(F11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"G109/(G11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"H109/(H11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"I109/(I11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"J109/(J11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"K109/(K11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"L109/(L11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"M109/(M11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712},{"$f":"N109/(N11*'INI-VAL'!$H$31)*(1000/365)","v":32.87671232876712}]
[null,"Demand NRW Physical","m3",{"$f":"D92","v":10480902},{"$f":"E92","v":13661849.17415214},14496033.14830428,15330217.122456422,16164401.096608562,12747330.567488484,13371360.312520549,13995390.05755261,19494704.050888956,20328888.025041096,0]
[null,"Demand NRW Commercial","m3",{"$f":"D95","v":5589848.895487668},{"$f":"E95","v":5730590.485171509},5730590.485171509,5730590.485171509,5730590.485171509,4297942.863878632,4297942.863878632,4297942.863878632,5730590.485171509,5730590.485171509,5730590.485171509]
[]
[null,"Total Supplied (after NRW)","m3",{"$f":"D24","v":18865589.104512334},15543900.340676352,14709716.366524212,13875532.392372068,13041348.418219928,9156981.5686328858,8532951.8236008212,7908922.0785687566,9711045.4639395326,8876861.4897873923,29205749.514828492]
[null,"Supplied to In-house Connections","%",{"$f":"D107","v":0.88213030554985783},{"$f":"E107","v":0.88213030554985783},0.88213030554985783,0.88213030554985783,0.88213030554985783,{"$f":"'Yearly Decision'!J39","v":0.88},{"$f":"'Yearly Decision'!K39","v":0.88},{"$f":"'Yearly Decision'!L39","v":0.88},{"$f":"L107","v":0.88213030554985783},{"$f":"M107","v":0.88213030554985783},0.88213030554985783]
[null,"Supplied to In-house Connections","m3",{"$f":"D115*D116","v":16641907.881141534},13711745.55695737,12975886.592953747,12240027.628950123,11504168.6649465,{"$f":"I115*I116","v":8058143.7803969393},{"$f":"J115*J116","v":7508997.6047687223},6959851.4291405054,{"$f":"L115*L116","v":8566407.5023135412},{"$f":"M115*M116","v":7830548.5383099187},{"$f":"N115*N116","v":25763276.74332827}]
[null,"Liters per capita per day In-house","lcd",{"$f":"D117/(D10*'INI-VAL'!$H$54)*(1000/365)","v":112.54731572382711},{"$f":"E117/(E10*'INI-VAL'!$H$54)*(1000/365)","v":92.730963741989484},{"$f":"F117/(F10*'INI-VAL'!$H$54)*(1000/365)","v":87.754433902897333},{"$f":"G117/(G10*'INI-VAL'!$H$54)*(1000/365)","v":82.777904063805138},{"$f":"H117/(H10*'INI-VAL'!$H$54)*(1000/365)","v":77.801374224712958},{"$f":"I117/(I10*'INI-VAL'!$H$54)*(1000/365)","v":54.496302868497722},{"$f":"J117/(J10*'INI-VAL'!$H$54)*(1000/365)","v":50.782490218627331},{"$f":"K117/(K10*'INI-VAL'!$H$54)*(1000/365)","v":47.068677568756932},{"$f":"L117/(L10*'INI-VAL'!$H$54)*(1000/365)","v":57.933632169324937},{"$f":"M117/(M10*'INI-VAL'!$H$54)*(1000/365)","v":52.957102330232772},{"$f":"N117/(N10*'INI-VAL'!$H$54)*(1000/365)","v":174.23408796761137}]
[null,"Supplied to Water Kiosks","%",{"$f":"1-D116","v":0.11786969445014217},0.11786969445014217,0.11786969445014217,0.11786969445014217,0.11786969445014217,{"$f":"1-I116","v":0.12},{"$f":"1-J116","v":0.12},0.12,{"$f":"1-L116","v":0.11786969445014217},0.11786969445014217,0.11786969445014217]
[null,"Supplied to Water Kiosks","m3",{"$f":"D119*D115","v":2223681.2233708003},1832154.7837189825,1733829.7735704645,1635504.763421946,1537179.7532734277,{"$f":"I119*I115","v":1098837.7882359463},{"$f":"J119*J115","v":1023954.2188320985},949070.64942825073,{"$f":"L119*L115","v":1144637.9616259919},{"$f":"M119*M115","v":1046312.9514774737},{"$f":"N119*N115","v":3442472.7715002224}]
[null,"Liters per capita per day Water Kiosks","lcd",{"$f":"D120/(D11*'INI-VAL'!$H$31)*(1000/365)","v":32.867519091661038},{"$f":"E120/(E11*'INI-VAL'!$H$31)*(1000/365)","v":27.08049233850112},{"$f":"F120/(F11*'INI-VAL'!$H$31)*(1000/365)","v":25.627181893515054},{"$f":"G120/(G11*'INI-VAL'!$H$31)*(1000/365)","v":24.173871448528978},{"$f":"H120/(H11*'INI-VAL'!$H$31)*(1000/365)","v":22.720561003542908},{"$f":"I120/(I11*'INI-VAL'!$H$31)*(1000/365)","v":16.24156898205781},{"$f":"J120/(J11*'INI-VAL'!$H$31)*(1000/365)","v":15.134738955718968},{"$f":"K120/(K11*'INI-VAL'!$H$31)*(1000/365)","v":14.027908929380127},{"$f":"L120/(L11*'INI-VAL'!$H$31)*(1000/365)","v":16.918526658130112},{"$f":"M120/(M11*'INI-VAL'!$H$31)*(1000/365)","v":15.465216213144041},{"$f":"N120/(N11*'INI-VAL'!$H$31)*(1000/365)","v":50.882086132963565}]
[]
[null,"Consumer Demand Deficit","m3",{"$f":"D105-D115","v":5276.8154876679182},{"$f":"E105-E115","v":3326965.5793236494},4161149.5534757897,4995333.5276279338,5829517.5017800741,9713884.351367116,10337914.096399181,10961943.841431245,9159820.4560604692,9994004.4302126095,-10334883.59482849]
[]
[null,"Meters",null,{"$f":"D13","v":16711},16711,16711,16711,16711,16711,16711,16711,16711,16711,16711]
[null,"A","unit",{"$f":"'Yearly Decision'!E15","v":0},{"$f":"D126+'Yearly Decision'!F15","v":0},{"$f":"E126+'Yearly Decision'!G15","v":0},{"$f":"F126+'Yearly Decision'!H15","v":0},{"$f":"G126+'Yearly Decision'!I15","v":0},{"$f":"H126+'Yearly Decision'!J15","v":0},{"$f":"I126+'Yearly Decision'!K15","v":0},{"$f":"J126+'Yearly Decision'!L15","v":0},{"$f":"K126+'Yearly Decision'!M15","v":0},{"$f":"L126+'Yearly Decision'!N15","v":0},{"$f":"M126+'Yearly Decision'!O15","v":0}]
[null,"B","unit",{"$f":"'Yearly Decision'!E16","v":0},{"$f":"D127+'Yearly Decision'!F16","v":0},{"$f":"E127+'Yearly Decision'!G16","v":0},{"$f":"F127+'Yearly Decision'!H16","v":0},{"$f":"G127+'Yearly Decision'!I16","v":0},{"$f":"H127+'Yearly Decision'!J16","v":0},{"$f":"I127+'Yearly Decision'!K16","v":0},{"$f":"J127+'Yearly Decision'!L16","v":0},{"$f":"K127+'Yearly Decision'!M16","v":0},{"$f":"L127+'Yearly Decision'!N16","v":0},{"$f":"M127+'Yearly Decision'!O16","v":0}]
[null,"C","unit",{"$f":"'Yearly Decision'!E17","v":16711},{"$f":"IF(IF(E125>E10, D128-(E125-E10), D128+'Yearly Decision'!F17)<0,0,IF(E125>E10, D128-(E125-E10), D128+'Yearly Decision'!F17))","v":16711},{"$f":"IF(IF(F125>F10, E128-(F125-F10), E128+'Yearly Decision'!G17)<0,0,IF(F125>F10, E128-(F125-F10), E128+'Yearly Decision'!G17))","v":16711},{"$f":"IF(IF(G125>G10, F128-(G125-G10), F128+'Yearly Decision'!H17)<0,0,IF(G125>G10, F128-(G125-G10), F128+'Yearly Decision'!H17))","v":16711},{"$f":"IF(IF(H125>H10, G128-(H125-H10), G128+'Yearly Decision'!I17)<0,0,IF(H125>H10, G128-(H125-H10), G128+'Yearly Decision'!I17))","v":16711},{"$f":"IF(IF(I125>I10, H128-(I125-I10), H128+'Yearly Decision'!J17)<0,0,IF(I125>I10, H128-(I125-I10), H128+'Yearly Decision'!J17))","v":16711},{"$f":"IF(IF(J125>J10, I128-(J125-J10), I128+'Yearly Decision'!K17)<0,0,IF(J125>J10, I128-(J125-J10), I128+'Yearly Decision'!K17))","v":16711},{"$f":"IF(IF(K125>K10, J128-(K125-K10), J128+'Yearly Decision'!L17)<0,0,IF(K125>K10, J128-(K125-K10), J128+'Yearly Decision'!L17))","v":16711},{"$f":"IF(IF(L125>L10, K128-(L125-L10), K128+'Yearly Decision'!M17)<0,0,IF(L125>L10, K128-(L125-L10), K128+'Yearly Decision'!M17))","v":16711},{"$f":"IF(IF(M125>M10, L128-(M125-M10), L128+'Yearly Decision'!N17)<0,0,IF(M125>M10, L128-(M125-M10), L128+'Yearly Decision'!N17))","v":16711},{"$f":"IF(IF(N125>N10, M128-(N125-N10), M128+'Yearly Decision'!O17)<0,0,IF(N125>N10, M128-(N125-N10), M128+'Yearly Decision'!O17))","v":16711}]
[]
[]
[]
[null,"SOP","Unit",1,2,{"$f":"E132*2","v":4},8,16,32,20]
[null,"Investment in SOP","Value",{"$f":"D132*'Yearly Costs'!$D$31","v":10000},{"$f":"E132*'Yearly Costs'!$D$31","v":20000},{"$f":"F132*'Yearly Costs'!$D$31","v":40000},{"$f":"G132*'Yearly Costs'!$D$31","v":80000},{"$f":"H132*'Yearly Costs'!$D$31","v":160000},{"$f":"I132*'Yearly Costs'!$D$31","v":320000},{"$f":"J132*'Yearly Costs'!$D$31","v":200000},{"$f":"K132*'Yearly Costs'!$D$31","v":0},{"$f":"L132*'Yearly Costs'!$D$31","v":0},{"$f":"M132*'Yearly Costs'!$D$31","v":0},{"$f":"N132*'Yearly Costs'!$D$31","v":0}]
[null,"Trainees Total","Unit",{"$f":"D136+D138","v":2},{"$f":"E136+E138","v":8},16,32,64,128,55,0,0,0,0]
[null,"Trainees Investment Total","Value",{"$f":"D137+D139","v":1750},{"$f":"E137+E139","v":7000},14000,28000,56000,112000,48750,0,0,0,0]
[null,"Trainees Leakage","Unit",1,4,{"$f":"E136*2","v":8},16,32,64,25]
[null,"Investment Trainees L","Value",{"$f":"Calculations!D136*'Yearly Costs'!$D$28","v":750},{"$f":"Calculations!E136*'Yearly Costs'!$D$28","v":3000},{"$f":"Calculations!F136*'Yearly Costs'!$D$28","v":6000},{"$f":"Calculations!G136*'Yearly Costs'!$D$28","v":12000},{"$f":"Calculations!H136*'Yearly Costs'!$D$28","v":24000},{"$f":"Calculations!I136*'Yearly Costs'!$D$28","v":48000},{"$f":"Calculations!J136*'Yearly Costs'!$D$28","v":18750},{"$f":"Calculations!K136*'Yearly Costs'!$D$28","v":0},{"$f":"Calculations!L136*'Yearly Costs'!$D$28","v":0},{"$f":"Calculations!M136*'Yearly Costs'!$D$28","v":0},{"$f":"Calculations!N136*'Yearly Costs'!$D$28","v":0}]
[null,"Trainees Costumer Management","Unit",1,4,{"$f":"E138*2","v":8},16,32,64,30]
[null,"Investment Trainees CM","Value",{"$f":"D138*'Yearly Costs'!$D$29","v":1000},{"$f":"E138*'Yearly Costs'!$D$29","v":4000},{"$f":"F138*'Yearly Costs'!$D$29","v":8000},{"$f":"G138*'Yearly Costs'!$D$29","v":16000},{"$f":"H138*'Yearly Costs'!$D$29","v":32000},{"$f":"I138*'Yearly Costs'!$D$29","v":64000},{"$f":"J138*'Yearly Costs'!$D$29","v":30000},{"$f":"K138*'Yearly Costs'!$D$29","v":0},{"$f":"L138*'Yearly Costs'!$D$29","v":0},{"$f":"M138*'Yearly Costs'!$D$29","v":0},{"$f":"N138*'Yearly Costs'!$D$29","v":0}]
[null,"H&S ","Unit",1,2,{"$f":"E140*2","v":4},8,16,32,10]
[null,"H&S investment","Value",{"$f":"D140*'Yearly Costs'!$D$30","v":5000},{"$f":"E140*'Yearly Costs'!$D$30","v":10000},{"$f":"F140*'Yearly Costs'!$D$30","v":20000},{"$f":"G140*'Yearly Costs'!$D$30","v":40000},{"$f":"H140*'Yearly Costs'!$D$30","v":80000},{"$f":"I140*'Yearly Costs'!$D$30","v":160000},{"$f":"J140*'Yearly Costs'!$D$30","v":50000},{"$f":"K140*'Yearly Costs'!$D$30","v":0},{"$f":"L140*'Yearly Costs'!$D$30","v":0},{"$f":"M140*'Yearly Costs'!$D$30","v":0},{"$f":"N140*'Yearly Costs'!$D$30","v":0}]
[null,"Bill Collectors","Unit",1,2,{"$f":"E142*2","v":4},8,16,32,8,8,8,8,8]
[null,"Network Rehab","Value",{"$f":"D144*'Yearly Costs'!$D$23","v":20000},{"$f":"E144*'Yearly Costs'!$D$23","v":40000},{"$f":"F144*'Yearly Costs'!$D$23","v":80000},{"$f":"G144*'Yearly Costs'!$D$23","v":160000},{"$f":"H144*'Yearly Costs'!$D$23","v":320000},{"$f":"I144*'Yearly Costs'!$D$23","v":640000},{"$f":"J144*'Yearly Costs'!$D$23","v":1280000},{"$f":"K144*'Yearly Costs'!$D$23","v":0},{"$f":"L144*'Yearly Costs'!$D$23","v":0},{"$f":"M144*'Yearly Costs'!$D$23","v":0},{"$f":"N144*'Yearly Costs'!$D$23","v":0}]
[null,"Network Rehab","Unit",1,{"$f":"D144*2","v":2},{"$f":"E144*2","v":4},8,16,32,64]

{"sheet":"Bench2","index":16,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[44,"Utility Efficiency"]

{"sheet":"Bench3","index":17,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[44,"Utility Efficiency"]

{"sheet":"Bench4","index":18,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[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,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[44,"Utility Efficiency"]