{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["User's Guide","Activity Description","ERR & Sensitivity Analysis","ERR","Assumptions","Costs","Savings","Health","Commercial","Beneficiaries","Poverty Scorecard","Sensitivity"],"not_rendered":{"charts":2,"images":13,"macros":1,"external_links":0,"defined_names":36,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User's Guide","index":0,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[50,1,50,3],[23,1,23,3],[26,1,26,3],[12,1,16,1],[1,2,4,3],[5,2,6,3]]}
[]
[null,null,"Tanzania: Water Sector Project"]
[]
[]
[]
[null,null,"Morogoro Water Supply Activity"]
[]
[]
[null,"ERR Version","Original ERR","Closeout ERR"]
[null,"Date of ERR","2007-08-24","2016-02-08"]
[null,"Amount of MCC funds","$5.6 million","$17.4 million"]
[null,"Project Description","Tanzania faces a serious shortage of access to potable water, resulting in a high incidence of water-related diseases, decreased workforce productivity, and constrained business growth. The Water Sector Project includes investments in bulk water supply for two urban areas, Dar es Salaam and Morogoro, which investments will increase the quantity and reliability of potable water for domestic and commercial use. By increasing the volume of water supply, the Water Sector Project is expected to reduce the incidence of water-related disease, increase time available for productive activities including education, promote greater investments in physical capital, and, ultimately, lead to an increase in income.","Tanzania faces a serious shortage of water infrastructure, resulting in a high incidence of water-related diseases, decreased workforce productivity, and constrained business growth.  The Morogoro Water Supply Activity rehabilitated a water intake and water treatment plant, expanded the capacity of the Morogoro municipal water system, improved the existing distribution network and provided technical support to MORUWASA.  This is expected to lead to a decrease in household water treatment expenditures, improved health outcomes and additional water available for enterprises."]
[null,"Benefit streams included in ERR","Increased income due to fewer sick days","Reduced household expenditures on water treatment"]
[null,null,"Increased income due to less downtime caring for sick children","Diarrheal disease treatment cost savings"]
[null,null,"Increased education (human capital)","Reduced opportunity cost from fewer sick days"]
[null,null,"Increased household investment (physical capital)","Lifetime income gains due to decreased child stunting"]
[null,null,"Increased business investment and economic activity","Increased water available to enterprises"]
[null,"Costs included in ERR (not borne by MCC)","Operations and maintenance","Increased water production and delivery costs"]
[null,"ERR estimations and time horizon","5.6% over 20 years","4.2% over 20 years"]
[]
[null,"Table of Contents"]
[]
[null,"Activity Description"]
[null,"One should read this sheet first, as it offers a summary of the project, a list of components, and states the economic rationale for the project."]
[]
[null,"ERR & Sensitivity Analysis"]
[null,"A brief summary of the project's key parameters and ERR calculations."]
[]
[null,"ERR"]
[null,"This sheet enumerates the project's investment benefits and costs over 20 years"]
[]
[null,"Assumptions"]
[null,"Shows the assumed consumer profile and other assumptions used in the model."]
[]
[null,"Costs"]
[null,"Lists the costs of the project, along with MORUWASA operation and maintenance cost estimates."]
[]
[null,"Savings"]
[null,"Estimates the household cost savings from reduced water treatment over 20 years"]
[]
[null,"Health"]
[null,"Estimates the benefits over 20 years from reduced diarrheal disease and improved health outcomes"]
[]
[null,"Commercial"]
[null,"Estimates the benefits to businesses of additional water available for productive purposes."]
[]
[null,"Beneficiaries"]
[null,"Estimates the number of project beneficiaries."]
[]
[null,"Poverty Scorecard"]
[null,"This worksheet shows the cost effectiveness of the project broken out into different poverty categories."]
[]
[null,"Sensitivity"]
[null,"Displays the inputs and results of sensitivity analyses using summary parameters and a Monte Carlo simulation."]

{"sheet":"Activity Description","index":1,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tanzania: Water Sector Project"]
[]
[null,"Morogoro Water Supply Activity"]
[]
[null,"Activity Design History"]
[]
[null,"Original Project"]
[]
[null,"Tanzania faces a serious shortage of access to potable water, resulting in a high incidence of water-related diseases, decreased workforce productivity, and constrained business growth. The Morogoro Water Activity includes investments in bulk water supply for the Morogoro municipal water system, which will increase the quantity and reliability of potable water for domestic and commercial use."]
[]
[null,"Project Changes at Closeout"]
[null,"Although the costs of the Morogoro Water Activity increased substantially from 2007 to 2014, the overall scope of the project did not change significantly."]
[]
[null,"Activity Components"]
[]
[null,"     3.   Morogoro Water Supply Activity.  MCC Funding will be used to improve water supply in Morogoro and to help Morogoro \n             Water and Sewarage Authority (MORUWASA) move towards achieving financial sustainability. Specifically, MCC \n             Funding will support:"]
[null,"             a.   Revised master plan, feasibility studies, final design and an additional environmental assessment, together with any \n                     resulting resettlement action plans and environmental management plans."]
[null,"             b.   Rehabilitation of Mambogo water intake and water treatment plant, including a water treatment plant with \n                     approximate capacity of 6,000,000 liters per day, and associated works."]
[null,"             c.   Improvements of water transfer in the existing distribution network, including rehabilitation of Mafiga water treatment \n                     plant facilities, about 1.9 km of pressure main, and associated works."]
[null,"             d.   Capacity building and technical support for MORUWASA."]
[null,"             e.   Project coordination and construction supervision of all improvements and upgrades under the Morogoro Water \n                     Supply Activity."]
[]
[null,"Economic Rationale"]
[]
[null,"Original Project ERR"]
[]
[null,"In modeling the impact of MCC’s energy investments on economic growth and incomes, the original ERR included the following benefits related to growth in income:"]
[null,"     For the analysis of the Water Sector Project, benefits accrue through increases in one of two intermediate results: (1) average liters of water consumption per capita per day; and (2) increases in the fraction of households served by the water system. The specific benefit streams included in the model are:"]
[null,"     1.   Increased income due to fewer sick days.  Reductions in morbidity associated with water-related disease decrease the number of days workers lose to illness. The existing prevalence rates of four key water-related illnesses (diarrhea, cholera, typhoid, and dysentery) are used to estimate the current number of days being lost to illness. The greater the increase in liters consumed, the lower the base level of liter consumption from which the individual begins, and the larger the increase in the fraction of households connected to the water system, the larger the drop in the prevalence of water-related disease."]
[null,"     2.   Increased income due to less downtime caring for sick children.  A similar exercise is used to determine the extra income that can be earned with the reduction in time needed to care for sick children. There are separate estimates of the amount of time needed to care for each bout of child water-related illness, and the prevalence of such illness among children. The methodology is, however, the same."]
[null,"     3.   Increased education (human capital).  Given the link between improved water supply and reductions in mortality (as well as morbidity), this analysis examines the implications of mortality reductions on the accumulation of both human and physical capital. Empirical evidence on mortality reductions associated with improved water supply suggests that reductions in overall human mortality of 4% due to the project are possible. This reduction is likely to lead to both increased schooling and increased investment by individuals in the affected area."]
[null,"     4.   Increased household investment (physical capital).  Empirical evidence also suggests that reduced mortality leads to greater rates of investment in physical capital, as individuals expect to enjoy a longer time span of returns from this capital. Our estimates suggest that GDP growth will be 0.15 percentage points higher due specifically to these effects."]
[null,"     5.   Increased business investment and economic activity.  Water is a key input into production for many industries, and increasing the supply of water to commercial industries should lead to increased investment and economic activity resulting in new jobs and added income for local households. As a result of water projects, the growth rate of local GDP is increased, if only during a transition period."]
[]
[null,"Closeout ERR"]
[null,"As described above, the original ERR model in 2007 used a methodology that relied on macroeconomic data and projected impacts to estimate project benefits.  However, in the intervening years, MCC's standard practice for analyzing water, sanitation and hygience (WASH) interventions has coalesced around a microeconomic approach that estimates the benefits for individuals and households and aggregates them to estimate the overall project benefits."]
[null,"For the Morogoro Water Project, the individual and household benefits included in this cost-benefit analysis model are:"]
[null,"1.   Reduced household expenditures on water treatment.  Prior to the project, households in Morogoro did not trust the quality of the municipal water supply, so many of them treated water with boiling, bleach or filters to make it safer for consumption.  With the expanded treatment capacity in the water system post-project, households will be able to forgo these treatment expenses, resulting in increased income for the household."]
[null,"2.   Improved health outcomes, resulting in:"]
[null,"a.   Treatment cost savings.  The improved quality of the water is expected to result in a reduced incidence of diarrheal disease, so households will spend less each year on treating illnesses."]
[null,"b.   Reduced opportunity cost from fewer sick days.  The reduced incidence of diarrheal disease will also result in fewer people needing to miss work to care for themselves or family members, resulting in increased income over the course of a year or more. "]
[null,"c.   Lifetime income gains due to decreased child stunting.  Several health studies, such as Teshome et al (2009), have shown that diarrheal disease increases the risks of stunting in children under five years of age.  According to Alderman et al (2006), childhood stunting is correlated with reduced educational attainment, resulting in lower lifetime incomes.  This model estimates the reduction in stunting resulting from a lower incidence of diarrheal disease and projects the subsequent increase in lifetime earnings using results from a Mincer regression to estimate returns to the additional years of education."]
[null,"3.   Increased water available to enterprises.  Water is a key input into production for many industries, and increasing the supply of water to commercial industries should lead to increased investment and output in those industries.  In many economic models, the increased volume of water supplied to commercial enterprises would be valued at those firms' willingness-to-pay for an additional cubic meter of water.  However, because we do not have much data on Morogoro businesses' willingness-to-pay for water, this model estimates the value of the additional water at MORUWASA's current commercial tariff.  Existing businesses have shown a willingness-to-pay at least at this current level, although it is possible that they could experience additional consumer surplus if they would be willing to pay much higher than MORUWASA's current tariff levels."]
[]
[null,"Last updated:  11/13/2014"]

{"sheet":"ERR & Sensitivity Analysis","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,1,20,6],[58,2,58,6],[5,1,5,6],[7,1,8,1],[7,2,8,2],[7,3,7,6]]}
[]
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,"Last updated:  2/8/2016"]
[]
[null,"ERR and sensitivity analysis"]
[]
[null,"Change the \"User Input\" cells in the table below to see the effect on the compact's Economic Rate of Return (ERR) and net benefits (see chart below).  To reset all values to the default MCC estimates, click the \"Reset Parameters\" button at right.  Be sure to reset all summary parameters to their original values (\"MCC Estimate\" values) before changing specific parameters."]
[]
[null,"Parameter type","Description of key parameters","Parameter values"]
[null,null,null,"User Input","MCC Estimate","Plausible range","Values used in ERR computation",null,"All summary parameters set to initial values?"]
[null,"Summary","Actual costs as a percentage of estimated costs",1,1,"80 - 120%",{"$f":"D10","v":1},null,{"$f":"IF(D10=E10,IF(D11=E11,\"Y\",\"N\"),\"N\")","v":"Y"}]
[null,"Summary","Actual benefits as a percentage of estimated benefits",1,1,"80 - 120%",{"$f":"D11","v":1}]
[null,null,null,null,null,null,null,null,"All specific parameters set to initial values?"]
[null,"Specific","Volume of water treated by households (liters/person/day)",3,3,"0-6",{"$f":"IF($I$10=\"Y\",D13,E13)","v":3},null,{"$f":"IF(D13=E13,IF(D14=E14,IF(D15=E15,IF(D19=E19,\"Y\",\"N\"),\"N\"),\"N\"), \"N\")","v":"Y"}]
[null,"Specific","Cost of energy used to boil water (USD/kWh)",0.2155,0.2155,"0.16 - 0.24",{"$f":"IF($I$10=\"Y\",D14,E14)","v":0.2155}]
[null,"Specific","Value of commercial water (Tsh/m3)",1050,1050,"500 - 1,500",{"$f":"D15","v":1050},null,"   More Info"]
[null,"Specific","Proportion of NRW that is technical loss (%)",0.8,0.8,"60-90%",{"$f":"D16","v":0.8},null,"Activity Description"]
[null,"Specific","Anticipated reduction in cases of disease (% of counterfactual)",0.17,0.17,"0-35%",{"$f":"D17","v":0.17},null,"User's Guide"]
[null,"Specific","Phase-in period of health benefits (years)",3,3,"1 - 5",{"$f":"IF($I$10=\"Y\",D18,E18)","v":3}]
[null,"Specific","Total cost per unit of water delivered (US$/m3)",0.81,0.81,"0.40 - 1.00",{"$f":"IF($I$10=\"Y\",D19,E19)","v":0.81}]
[]
[null,{"$f":"IF(I10=\"N\",IF(I13=\"N\",\"Reminder: Please reset all summary parameters to original values before changing specific parameters.  Specific parameters will only be used in ERR computation when all summary parameters are set to initial values\",0),0)","v":0}]
[null,null,"User Generated Economic rate of return (ERR): ",{"$f":"ERR!F45","v":3.1687743201184615E-2}]
[]
[null,null,"MCC Estimated ERRs:",null,"Original","Closeout*"]
[null,null,null,"ERR",5.6000000000000001E-2,{"$f":"Sensitivity!E71","v":4.1880497978161922E-2}]
[null,null,null,"Date","2007-08-24","2016-02-08"]
[]
[null,null,"User Generated Present Value (PV) of Benefits:",{"$f":"ERR!F39*10^6","v":24781662.706024595},"2014 US$, 10% discount rate"]
[null,null,"Present Value (PV) of Benefits*:",{"$f":"Sensitivity!E186*10^6","v":8657771.5380930025},"2014 US$, 10% discount rate"]
[]
[]
[null,null,"Present Value (PV) of MCC Costs:",{"$f":"ERR!F42*10^6","v":12742732.108258206},"2014 US$, 10% discount rate"]
[]
[null,null,"* The Closeout estimates are expected values based on a 10,000-trial Monte Carlo simulation, while the User Generated numbers above show the base case scenario."]

{"sheet":"ERR","index":3,"n_rows":53,"n_cols":30,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,2,49,10]]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Cost-Benefit Summary"]
[]
[null,null,null,null,{"$f":"IF('ERR & Sensitivity Analysis'!$I$10=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",IF('ERR & Sensitivity Analysis'!$I$13=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",\"\"))","v":""}]
[null,null,null,null,"All figures in millions of US$",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[null,null,null,null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,"Costs"]
[]
[null,null,null,null,"Disbursement rate",{"$f":"SUM(G9:K9)","v":1},0,0,0.39,0.32,{"$f":"1-SUM(G9:J9)","v":0.29000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present Value","% of Costs"]
[]
[null,null,"Investment costs",null,null,{"$f":"SUM(F12:F17)","v":18.405188111114938},0,9.5616999999999994E-2,7.1407327333348247,5.8590627555567814,5.3097756222233317,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"NPV(0.1,G11:Z11)","v":12.742732108258206},{"$f":"AC11/AC$21","v":0.42713102593381475}]
[null,null,null,"Capital costs",null,{"$f":"'ERR & Sensitivity Analysis'!G10*capex/10^6","v":13.647885352006998},{"$f":"$F12*G$9","v":0},0,5.3226752872827294,4.3673233126422399,3.9578867520820298,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4394815888138499,{"$f":"AC12/AC$21","v":0.31640745650616459}]
[null,null,null,"Supervision",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_spvs/10^6","v":2.8612471400000001},0,0,1.1158863846,0.91559908480000007,0.82976167060000017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9789651658456011,6.6334080822990305E-2]
[null,null,null,"Feasibility studies",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_feas/10^6","v":9.5616999999999994E-2},0,{"$f":"F14","v":9.5616999999999994E-2},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.9022314049586748E-2,2.6487947627643997E-3]
[null,null,null,"Technical assistance",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_TA/10^6","v":0.79387905000000003},{"$f":"$F15*G$9","v":0},0,0.30961282950000002,0.25404129600000003,0.23022492450000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54908188946048131,1.8404994217444202E-2]
[null,null,null,"Administrative costs",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_admin/10^6","v":0.5668332497960028},0,0,0.2210649674204411,0.1813866399347209,0.16438164244084083,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39204696459367988,1.3141249519999976E-2]
[null,null,null,"M&E costs",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_ME/10^6","v":0.43972631931193684},0,0,0.17149326453165536,0.1407124221798198,0.1275206326004617,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30413418549500859,1.0194450104451327E-2]
[]
[null,null,"Increased water production and delivery costs",null,null,null,{"$f":"Commercial!G32/10^6","v":0},{"$f":"Commercial!H32/10^6","v":0},{"$f":"Commercial!I32/10^6","v":0},{"$f":"Commercial!J32/10^6","v":0},{"$f":"Commercial!K32/10^6","v":0},{"$f":"Commercial!L32/10^6","v":3.6187559999999999},{"$f":"Commercial!M32/10^6","v":3.6187559999999999},{"$f":"Commercial!N32/10^6","v":3.6187559999999999},{"$f":"Commercial!O32/10^6","v":3.6187559999999999},{"$f":"Commercial!P32/10^6","v":3.6187559999999999},{"$f":"Commercial!Q32/10^6","v":3.6187559999999999},{"$f":"Commercial!R32/10^6","v":3.6187559999999999},{"$f":"Commercial!S32/10^6","v":3.6187559999999999},{"$f":"Commercial!T32/10^6","v":3.6187559999999999},{"$f":"Commercial!U32/10^6","v":3.6187559999999999},{"$f":"Commercial!V32/10^6","v":3.6187559999999999},{"$f":"Commercial!W32/10^6","v":3.6187559999999999},{"$f":"Commercial!X32/10^6","v":3.6187559999999999},{"$f":"Commercial!Y32/10^6","v":3.6187559999999999},{"$f":"Commercial!Z32/10^6","v":3.6187559999999999},null,null,{"$f":"NPV(0.1,G19:Z19)","v":17.090577425741163},0.57286897406618531]
[]
[null,null,"Total costs",null,null,null,{"$f":"G11+G19","v":0},9.5616999999999994E-2,7.1407327333348247,5.8590627555567814,{"$f":"K11+K19","v":5.3097756222233317},3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,3.6187559999999999,null,null,{"$f":"NPV(0.1,G21:Z21)","v":29.833309533999365},1]
[]
[null,null,"Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present Value","% of Benefits"]
[]
[null,null,"Reduced household expenditures on water treatment",null,null,null,{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!G52/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!H52/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!I52/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!J52/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!K52/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!L52/10^6","v":2.3481407065591289},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!M52/10^6","v":2.4260289067251191},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!N52/10^6","v":2.5065006708607442},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!O52/10^6","v":2.5896416961931945},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!P52/10^6","v":2.6755405225402997},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!Q52/10^6","v":2.7642886265997069},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!R52/10^6","v":2.8559805193656511},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!S52/10^6","v":2.9507138467770595},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!T52/10^6","v":3.0485894937041591},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!U52/10^6","v":3.1497116913843461},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!V52/10^6","v":3.2541881284217138},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!W52/10^6","v":3.3621300654684565},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!X52/10^6","v":3.4736524537102738},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!Y52/10^6","v":3.5888740572819495},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!Z52/10^6","v":3.7079175797434814},null,null,{"$f":"NPV(0.1,G25:Z25)","v":13.296011003744029},{"$f":"AC25/$AC$34","v":0.53652618718402934}]
[]
[null,null,"Improved health outcomes",null,null,null,{"$f":"SUM(G28:G30)","v":0},{"$f":"SUM(H28:H30)","v":0},0,0,0,0.26918252811388316,0.55622271064545603,0.86200905944447526,0.89060203684968853,0.92014344785654301,0.95066475215823198,0.9821984529709723,1.014778131647823,1.0484384834406582,1.0832153544483651,1.1191457797906272,1.1562680230479281,1.1946216170097914,1.2342474057746484,1.2751875882461672,null,null,{"$f":"NPV(0.1,G27:Z27)","v":4.1260145908972259},{"$f":"AC27/$AC$34","v":0.16649466340667138}]
[null,null,null,"Treatment cost savings",null,null,{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!G43/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!H43/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!I43/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!J43/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!K43/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!L43/10^6","v":4.9123532518169485E-4},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!M43/10^6","v":1.0150593578709796E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!N43/10^6","v":1.5730935569734502E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!O43/10^6","v":1.6252733200954445E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!P43/10^6","v":1.6791838942473423E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Q43/10^6","v":1.734882690705881E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!R43/10^6","v":1.7924290250889753E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!S43/10^6","v":1.8518841805230113E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!T43/10^6","v":1.9133114729054069E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!U43/10^6","v":1.9767763183319476E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!V43/10^6","v":2.0423463027607102E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!W43/10^6","v":2.1100912539867385E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!X43/10^6","v":2.1800833160041202E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Y43/10^6","v":2.2523970258346892E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Z43/10^6","v":2.3271093929051311E-3},null,null,7.5296273256127482E-3,3.0383866550577512E-4]
[null,null,null,"Reduced opportunity cost from fewer sick days",null,null,{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!G48/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!H48/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!I48/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!J48/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!K48/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!L48/10^6","v":2.9302117209376154E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!M48/10^6","v":6.0548146181889752E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!N48/10^6","v":9.383480671041106E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!O48/10^6","v":9.694732215174794E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!P48/10^6","v":1.00163080224601E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Q48/10^6","v":1.0348550550345397E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!R48/10^6","v":1.0691813615647087E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!S48/10^6","v":1.1046462771341539E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!T48/10^6","v":1.1412875695855437E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!U48/10^6","v":1.1791442595268788E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!V48/10^6","v":1.2182566618859303E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!W48/10^6","v":1.258666428843027E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!X48/10^6","v":1.3004165941879278E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Y48/10^6","v":1.3435516191480376E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Z48/10^6","v":1.3881174397367402E-2},null,null,4.4914119797149897E-2,1.8123933139575401E-3]
[null,null,null,"Lifetime income gains due to decreased child stunting",null,null,{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!G53/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!H53/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!I53/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!J53/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!K53/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!L53/10^6","v":0.26576108106776386},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!M53/10^6","v":0.54915283666939607},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!N53/10^6","v":0.85105248521646071},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!O53/10^6","v":0.87928203131441829},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!P53/10^6","v":0.90844795593983552},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Q53/10^6","v":0.93858131891718066},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!R53/10^6","v":0.96971421033023619},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!S53/10^6","v":1.0018797846959584},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!T53/10^6","v":1.0351122962718973},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!U53/10^6","v":1.0694471355347643},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!V53/10^6","v":1.1049208668690071},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!W53/10^6","v":1.141571267505511},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!X53/10^6","v":1.1794373677519081},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Y53/10^6","v":1.2185594925573333},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Z53/10^6","v":1.2589793044558946},null,null,4.073570843774462,0.16437843142720801]
[]
[null,null,"Increased water available to enterprises",null,null,null,{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!G28/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!H28/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!I28/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!J28/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!K28/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!L28/10^6","v":2.3601005231209964},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!M28/10^6","v":2.2264218325760057},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!N28/10^6","v":2.0883089986349175},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!O28/10^6","v":1.9456149400570582},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!P28/10^6","v":1.7981876968936383},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!Q28/10^6","v":1.6458702686602373},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!R28/10^6","v":1.4885004471414274},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!S28/10^6","v":1.3259106436495169},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!T28/10^6","v":1.1579277105534251},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!U28/10^6","v":0.98437275688765125},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!V28/10^6","v":0.80506095784495257},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!W28/10^6","v":0.61980135794988445},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!X28/10^6","v":0.42839666770354601},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!Y28/10^6","v":0.23064305348302949},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!Z28/10^6","v":2.6329920471781874E-2},null,null,7.3596371113833383,0.29697914940929931]
[]
[null,null,"Total benefits",null,null,null,{"$f":"SUM(G25,G27,G32)","v":0},{"$f":"SUM(H25,H27,H32)","v":0},0,0,0,4.9774237577940088,5.2086734499465805,5.4568187289401369,5.425858673099941,5.3938716672904814,5.3608236474181759,5.3266794194780509,5.2914026220743997,5.2549556876982422,5.2172998027203619,5.1783948660572943,5.1381994464662695,5.0966707384236107,5.0537645165396272,5.0094350884614309,null,null,24.781662706024594,1]
[null,null,null,"Net local benefits",null,null,{"$f":"G34-G19","v":0},{"$f":"H34-H19","v":0},0,0,0,1.3586677577940089,1.5899174499465807,1.838062728940137,1.8071026730999411,1.7751156672904815,1.742067647418176,1.707923419478051,1.6726466220743998,1.6361996876982423,1.598543802720362,1.5596388660572944,1.5194434464662696,1.4779147384236109,1.4350085165396274,1.3906790884614311,null,null,7.6910852802834331]
[]
[null,null,"Net benefits",null,null,null,{"$f":"G34-G21","v":0},-9.5616999999999994E-2,-7.1407327333348247,-5.8590627555567814,-5.3097756222233317,1.3586677577940089,1.5899174499465807,1.838062728940137,1.8071026730999411,1.7751156672904815,1.742067647418176,1.707923419478051,1.6726466220743998,1.6361996876982423,1.598543802720362,1.5596388660572944,1.5194434464662696,1.4779147384236109,1.4350085165396274,1.3906790884614311]
[]
[null,null,"Present value of benefits",null,null,{"$f":"NPV(0.1,G34:Z34)","v":24.781662706024594}]
[null,null,null,"Present value of local benefits",null,{"$f":"AC35","v":7.6910852802834331}]
[null,null,"Present value of costs",null,null,{"$f":"NPV(0.1,G21:Z21)","v":29.833309533999365}]
[null,null,null,"Present value of investment costs",null,{"$f":"NPV(0.1,G11:K11)","v":12.742732108258206}]
[null,null,"Total Net Present Value",null,null,{"$f":"NPV(0.1,G37:Z37)","v":-5.0516468279747739}]
[]
[null,null,null,null,"ERR (20 years):",{"$f":"IRR(G37:Z37)","v":3.1687743201184615E-2}]
[]
[]
[]
[null,null,"Note",null,null," "]
[null,null,"To simplify review, the calculations on this worksheet use formula names that reference calculations elsewhere in this workbook.  To see a list of these formula names, click on Formulas --> Name Manager, or use the drop down menu in the upper left corner of the formula bar."]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"Assumptions","index":4,"n_rows":105,"n_cols":14,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Consumer Profile & Assumptions"]
[]
[null,{"$f":"IF('ERR & Sensitivity Analysis'!$I$10=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",IF('ERR & Sensitivity Analysis'!$I$13=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",\"\"))","v":""}]
[]
[null,"Without Project",null,null,null,null,null,null,null,null,null,"Household Treatment Costs"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A74","v":8},"Volume treated (liters/capita/day)",{"$f":"'ERR & Sensitivity Analysis'!G13","v":3}]
[{"$f":"A67","v":1},"Primary drinking water source","% of HH","Liters / capita / day (lpcpd)","Cost of water (Tsh/liter)","% of water treated","Treatment cost (Tsh/liter)","Total cost (Tsh/liter)",null,null,null,"Cost of boiling water","Column1"]
[null,"Own tap",0.52,103.5,{"$f":"M28/1000","v":0.75},{"$f":"M7/Table4[[#This Row],[Liters / capita / day (lpcpd)]]","v":2.8985507246376812E-2},{"$f":"SUMPRODUCT(C16:G16,C$21:G$21)","v":15.967041789124641},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":1.2128128054818736},null,null,{"$f":"A76","v":9},"Average annual temperature in Morogoro (Co)",23.9]
[null,"Other piped",0.39,5.5,{"$f":"M28/1000","v":0.75},{"$f":"M7/Table4[[#This Row],[Liters / capita / day (lpcpd)]]","v":0.54545454545454541},{"$f":"SUMPRODUCT(C17:G17,C$21:G$21)","v":7.9743240900587482},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":5.0996313218502261},null,null,{"$f":"A78","v":10},"Energy required to boil 1 liter water in Morogoro (kcal)",{"$f":"100-M9","v":76.099999999999994}]
[null,"Vendors",0.04,12,{"$f":"1200/1000","v":1.2},0.11,{"$f":"SUMPRODUCT(C18:G18,C$21:G$21)","v":15.181911915113211},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":2.8700103106624533},null,null,{"$f":"A80","v":11},"Energy required to boil 1 liter water in Morogoro (kWh)",{"$f":"M10*0.001163","v":8.8504299999999994E-2}]
[{"$f":"A68","v":2},"Non‐Tap",0.05,6.5,0,{"$f":"IF(D12>M$7,$M$7/D12,1)","v":0.46153846153846156},{"$f":"SUMPRODUCT(C19:G19,C$21:G$21)","v":5.5101342668787492},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":2.5431388924055769},null,null,{"$f":"A82","v":12},"Cost of energy (Tsh/kWh)",{"$f":"'ERR & Sensitivity Analysis'!G14*Tsh_USD","v":348.03249999999997}]
[{"$f":"A69","v":3},"Total",{"$f":"SUM(C9:C12)","v":1},{"$f":"SUMPRODUCT(C9:C12,D9:D12)","v":56.77},null,null,null,null,null,null,null,"Treatment cost (Tsh/liter)",{"$f":"M11*M12","v":30.802372789749995}]
[]
[{"$f":"A70","v":4},"Primary drinking water source","Boil","Disinfect","Filter","Let settle","None","Total","% Treating",null,null,"Cost of disinfecting water","Column1"]
[null,"Own tap",0.51,0.04,0.05,0.16,0.24,1,{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.76000000000000012},null,{"$f":"A83","v":13},"Price of bleach (Tsh/liter)",10000]
[null,"Other piped",0.25,0.03,0.06,0.18,0.48,1,{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.52},null,{"$f":"A84","v":14},"Dose (mL/liter)",{"$f":"0.75/3.785","v":0.19815059445178335}]
[null,"Vendors",0.48,0.02,0.1,0.08,0.32,1,{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.67999999999999994},null,null,"Treatment cost (Tsh/liter)",{"$f":"M16/1000*M17","v":1.9815059445178336}]
[null,"Non‐Tap",0.17,0.03,0.06,0.28000000000000003,0.46,1,{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.54}]
[null,"Total",0.39,0.04,0.06,0.16,0.35,1,{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.65},null,null,"Cost of filtering water","Column1"]
[null,"Treatment cost (Tsh/liter)",{"$f":"M13","v":30.802372789749995},{"$f":"M18","v":1.9815059445178336},{"$f":"M23","v":3.5714285714285716},0,0,null,null,null,{"$f":"A86","v":15},"Price of filter (Tsh)",25000]
[null,null,null,null,null,null,null,null,null,null,null,"Capacity of filter (liters)",7000]
[null,"Clean without project?",null,null,null,null,null,null,null,null,null,"Treatment cost (Tsh/liter)",{"$f":"M21/M22","v":3.5714285714285716}]
[3,"Primary drinking water source","Boil","Disinfect","Filter","Let settle","None","Clean %","Unclean %"]
[null,"Own tap","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C16:G16)","v":0.55000000000000004},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C16:G16)","v":0.45}]
[null,"Other piped","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C17:G17)","v":0.28000000000000003},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C17:G17)","v":0.72},null,null,"MORUWASA Service"]
[null,"Vendors","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C18:G18)","v":0.5},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C18:G18)","v":0.5},null,null,"Column1","w/o Project","w/Project"]
[null,"Non‐Tap","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C19:G19)","v":0.2},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C19:G19)","v":0.8},null,{"$f":"A88","v":16},"MORUWASA domestic tariff (Tsh/m3)",750,"-"]
[null,"Total",null,null,null,null,null,{"$f":"SUMPRODUCT(C9:C12,Table6[Clean %])","v":0.42520000000000008},{"$f":"SUMPRODUCT(C9:C12,Table6[Unclean %])","v":0.57480000000000009},null,{"$f":"K28","v":16},"MORUWASA commercial tariff (Tsh/m3)",{"$f":"'ERR & Sensitivity Analysis'!G15","v":1050},"-"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A90","v":17},"Production capacity (m3/day)",18000,33000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A90","v":17},"Non-revenue water (NRW) (% of production)",0,0.23]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A91","v":18},"Proportion of NRW that is technical loss (%)",0,{"$f":"'ERR & Sensitivity Analysis'!G16","v":0.8}]
[null,"Column1","MORUWASA","Other","Total",null,null,null,null,null,{"$f":"A92","v":19},"Total cost per unit delivered (US$/m3)",0,{"$f":"'ERR & Sensitivity Analysis'!G19","v":0.81}]
[null,"Avg cost (Tsh/liter) of clean water, without project",{"$f":"(C9/SUM(C9:C10)*H9)+(C10/SUM(C9:C10)*H10)","v":2.878592169639739},{"$f":"(C11/SUM(C11:C12)*H11)+(C12/SUM(C11:C12)*H12)","v":2.6884150782975222},{"$f":"SUMPRODUCT(C9:C12,H9:H12)","v":2.8614762314189393}]
[null,"Avg volume of water, without project",{"$f":"(C9/SUM(C9:C10)*D9)+(C10/SUM(C9:C10)*D10)","v":61.499999999999993},{"$f":"(C12/SUM(C12:C13)*H12)+(C13/SUM(C12:C13)*H13)","v":0.12110185201931317},{"$f":"SUMPRODUCT(C10:C13,H10:H13)","v":2.2308135725683651},null,null,null,null,null,null,"Health","w/o Project","w/Project"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A93","v":20},"Prevalence of diarrheal disease, age < 5",0.13,{"$f":"M36*(1-$N$39)","v":0.1079}]
[null,"With Project",null,null,null,null,null,null,null,null,{"$f":"K36","v":20},"Prevalence of diarrheal disease, age 5-18",0.05,{"$f":"M37*(1-$N$39)","v":4.1500000000000002E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A94","v":21},"Prevalence of diarrheal disease, age> 18",0.05,{"$f":"M38*(1-$N$39)","v":4.1500000000000002E-2}]
[{"$f":"A72","v":6},"Primary drinking water source","% of HH","Liters / capita / day (lpcpd)","Cost of water (Tsh/liter)","% of water treated","Treatment cost (Tsh/liter)","Total cost (Tsh/liter)",null,null,22,"Anticipated % reduction in cases of disease","-",{"$f":"'ERR & Sensitivity Analysis'!G17","v":0.17}]
["%","Own tap",0.52,{"$f":"D9","v":103.5},{"$f":"E9","v":0.75},0,{"$f":"SUMPRODUCT(C48:G48,C$21:G$21)","v":0},{"$f":"Table7[[#This Row],[Cost of water (Tsh/liter)]]+(Table7[[#This Row],[% of water treated]]*Table7[[#This Row],[Treatment cost (Tsh/liter)]])","v":0.75},null,null,23,"Diarrheal treatment costs (Tsh)",748,"-"]
[null,"Other piped",0.39,{"$f":"D10","v":5.5},{"$f":"E10","v":0.75},0,{"$f":"SUMPRODUCT(C49:G49,C$21:G$21)","v":0},{"$f":"Table7[[#This Row],[Cost of water (Tsh/liter)]]+(Table7[[#This Row],[% of water treated]]*Table7[[#This Row],[Treatment cost (Tsh/liter)]])","v":0.75},null,null,24,"Average work days missed per case of disease",0.33800000000000002,"-"]
[null,"Vendors",0.04,12,{"$f":"E11","v":1.2},0.11,{"$f":"SUMPRODUCT(C50:G50,C$21:G$21)","v":15.181911915113211},{"$f":"Table7[[#This Row],[Cost of water (Tsh/liter)]]+(Table7[[#This Row],[% of water treated]]*Table7[[#This Row],[Treatment cost (Tsh/liter)]])","v":2.8700103106624533},null,null,25,"Average daily wage (Tsh)",15517.22,"-"]
[null,"Non‐Tap",0.05,6.5,{"$f":"E12","v":0},0.11,{"$f":"SUMPRODUCT(C51:G51,C$21:G$21)","v":5.5101342668787492},{"$f":"Table7[[#This Row],[Cost of water (Tsh/liter)]]+(Table7[[#This Row],[% of water treated]]*Table7[[#This Row],[Treatment cost (Tsh/liter)]])","v":0.60611476935666242},null,null,26,"Probability of employment",0.85070775439141089,"-"]
[null,"Total",{"$f":"SUM(C40:C43)","v":1},{"$f":"SUMPRODUCT(C40:C43,D40:D43)","v":56.77}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A100","v":27},"Percentage of stunted children in Tanzania, low height for age",0.42499999999999999,"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Odds of stunting for children, age <5",{"$f":"M45/(1-M45)","v":0.73913043478260876},"-"]
[{"$f":"A73","v":7},"Primary drinking water source","Boil","Disinfect","Filter","Let settle","None","Total",null,null,{"$f":"A101","v":28},"Odds ratio of stunting for children age<5 with diarrhea",2.2890000000000001,"-"]
[null,"Own tap",0,0,0,0,1,1,null,null,null,"Odds of stunting for children age<5 with diarrhea",{"$f":"M46*M47","v":1.6918695652173916},"-"]
[null,"Other piped",0,0,0,0,1,1,null,null,null,"Probability of stunting for children age<5 with diarrhea",{"$f":"M48/(1+M48)","v":0.62851097507793197},"-"]
[null,"Vendors",0.48,0.02,0.1,0.08,0.32,1,null,null,{"$f":"A102","v":29},"Return to an additional year of schooling, Tanzania",0.16600000000000001,"-"]
[null,"Non‐Tap",0.17,0.03,0.06,0.28000000000000003,0.46,1,null,null,{"$f":"A103","v":30},"Fewer years of schooling due to stunting",0.85,"-"]
[null,"Total",0.39,0.04,0.06,0.16,0.35,1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A104","v":31},"Phase-in period of health benefits (years)","-",{"$f":"'ERR & Sensitivity Analysis'!G18","v":3}]
[null,"Clean with project?",null,null,null,null,null,null,null,null,{"$f":"Assumptions!A105","v":32},"US-Tanzania Exchange rate",1615,"-"]
[null,"Primary drinking water source","Boil","Disinfect","Filter","Let settle","None","Clean %","Unclean %"]
[null,"Own tap","yes","yes","yes","yes","yes",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C48:G48)","v":1},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C48:G48)","v":0}]
[null,"Other piped","yes","yes","yes","yes","yes",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C49:G49)","v":1},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C49:G49)","v":0}]
[null,"Vendors","yes","yes","no","no","no",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C50:G50)","v":0.5},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C50:G50)","v":0.5}]
[null,"Non‐Tap","yes","yes","no","no","no",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C51:G51)","v":0.2},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C51:G51)","v":0.8}]
[null,"Total",null,null,null,null,null,{"$f":"SUMPRODUCT(C40:C43,Table9[Clean %])","v":0.94000000000000006},{"$f":"SUMPRODUCT(C40:C43,Table9[Unclean %])","v":6.0000000000000012E-2}]
[]
[null,"Column1","MORUWASA","Other","Total"]
[null,"Avg cost (Tsh/liter) of clean water, with project",{"$f":"(C40/SUM(C40:C41)*H40)+(C41/SUM(C40:C41)*H41)","v":0.75},{"$f":"(C42/SUM(C42:C43)*H42)+(C43/SUM(C42:C43)*H43)","v":1.6122905654925694},{"$f":"SUMPRODUCT(C40:C43,H40:H43)","v":0.82760615089433132}]
[]
[]
[null,"Notes"]
[1,"Impact Evaluation Baseline Report (2014), Table 36.  Bottled water, which represents <1% of responses, is combined with water from vendors in this analysis."]
[2,"According to the Impact Evaluation Baseline Report (2014), \"non-tap\" includes boreholes, unprotected and protected wells/springs and surface water.  For the purposes of this analysis, surface water is assumed.\\"]
[3,"Per capita consumption estimates from Impact Evaluation Baseline Report (2014). Table 85, p. 217."]
[4,"Impact Evaluation Baseline Report (2014), Table 82. "]
[5,"For the purposes of this analysis \"Non-tap\" is assumed to be gathering water from surface sources."]
[6,"Impact Evaluation Baseline Report (2014), Table 82."]
[7,"Assumes that additional capacity of water treatment plant will lead to cleaner water, eliminating the need for people using piped connections to treat water."]
[8,"Assumption based on medical recommendation that adults should consume about 3 liters of fluid per day (see below)."]
[null,"http://bit.ly/1dHvzTS"]
[9,"Weatherbase (2014).  Climate summary for Morogoro, Tanzania. Accessed 11/3/14."]
[null,"http://www.weatherbase.com/weather/weather-summary.php3?s=166836&cityname=Morogoro%2C+Morogoro%2C+Tanzania&units=metric"]
[10,"MedicineNet.com (2014).  By definition, a kilocalorie is the amount of energy required to raise the temperature of a liter of water one degree centigrade (Celsius) at sea level.  Because Morogoro lies at an elevation of 579 meters, it is likely that slightly less energy would be required to boil water there, so this should be treated as a high estimate. Accessed 11/3/14."]
[null,"http://www.medicinenet.com/script/main/art.asp?articlekey=8568"]
[11,"UnitJuggler.com (2014).  Conversion rate for kcal to kWh."]
[null,"http://www.unitjuggler.com/convert-energy-from-kWh-to-kcal.html"]
[12,"Long-run marginal cost of electricity from the Tanzania Energy ERR models. (Estimate from Mott MacDonald Inc., based on Tanesco PSMP 2012.)  Because many people will use less energy efficient fuels, such as wood, to boil their water, this estimate should be treated as the minimum cost required to boil water.  The actual cost to consumers likely would be higher."]
[13,"Assumption"]
[14,"Centers for Disease Control:"]
[null,"http://www.cdc.gov/healthywater/pdf/emergency/09_202278-B_Make_Water_Safe_Flyer_508.pdf"]
[15,"Based info for siphon water filter found at address below.  This represents the upper end of the potential filtering cost, as it is more likely that people filter the water through a simple cloth or by skimming the containers as described in the Evaluation Baseline Report, p. 148."]
[null,"http://www.connectinternational.nl/english/smartmodules/smart-tec/water-treatment/siphonwaterfilter"]
[16,"In addition to the variable tariff, MORUWASA also charges domestic customers a flat 1500/month service charge and commercial customers a 2000/month service charge.  MORUWASA Tariff Rates found at:"]
[null,"http://moruwasa.co.tz/home/index.php?option=com_content&task=view&id=33&Itemid=48"]
[17,"EWURA (2013). Water Utilities Performance Review Report 2012/13. Appendix 1: Utility Profiles, p. 67."]
[18,"Assumption. MCC assumed 80% in a similar model in Zambia."]
[19,"Shkaratan (2012). Tanzania's Infrastructure: A Continental Perspective.  World Bank Working Paper WPS5962.  Table 7b."]
[20,"Impact Evaluation Baseline Report (2014), Table 87."]
[21,"The baseline report did not report data on adult diarrhea prevalence, so it is assumed to be equal to that of older children."]
[22,"Cairncross et al (2010). Water, sanitation and hygiene for the prevention of diarrhoea. The International Journal of Epidemiology, Volume 39, Issue suppl 2, Pages i193-i205."]
[23,"Impact Evaluation Baseline Report (2014), Table 89."]
[24,"Impact Evaluation Baseline Report (2014), Table 68."]
[25,"Author's estimates using 2011 National Panel Survey data and updated to 2014 prices."]
[26,"Impact Evaluation Baseline Report (2014), Table 29.  Weighted average of males and females employed in paid or home labor."]
[27,"World Development Indicators (2014).  Based on 2010 Demographic and Health Survey.  National Bureau of Statistics (NBS) and ICF MacroTanzania. Dar es Salaam, Tanzania: NBS and ICF Macro, 2011 (and additional analysis)."]
[28,"Teshome et al (2009). Magnitude and determinants of stunting in children under-five years of age in food surplus region of Ethiopia: The case of West Gojam Zone. Ethiop J Health Dev 2009, 23(2):98-106."]
[29,"Montenegro and Patrinos (2014).  Comparable estimates of returns to schooling around the world.  World Bank Policy Research Working Paper 7020 (WPS7020).  The most recent returns to education listed in this paper is 2011."]
[30,"Alderman et al (2006).  Long term consequences of early childhood malnutrition. Oxf. Econ. Pap. (2006) 58 (3): 450-474. doi: 10.1093/oep/gpl008."]
[31,"Assumption"]
[32,"Calculated using data from IMF World Economic Outlook Database, April 2014."]

{"sheet":"Costs","index":5,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Costs"]
[null,{"$f":"IF('ERR & Sensitivity Analysis'!$I$10=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",IF('ERR & Sensitivity Analysis'!$I$13=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",\"\"))","v":""}]
[]
[{"$f":"A27","v":1},"Investment costs (US$)","MCA-T","GoT","Total"]
[null,"Capital costs",10365042.322999999,3282843.0290069999,{"$f":"SUM(C6:D6)","v":13647885.352006998}]
[null,"Supervision",2085839.54,775407.6,2861247.14]
[null,"Feasibility studies",95617,0,95617]
[null,"Technical assistance",793879.05,0,793879.05]
[null,"Administrative costs",566833.24979600275,0,566833.24979600275]
[null,"Monitoring and evaluation (M&E) costs",439726.31931193685,0,439726.31931193685]
[null,"Total w/o Administrative, M&E",{"$f":"SUM(C6:C9)","v":13340377.912999999},{"$f":"SUM(D6:D9)","v":4058250.629007},{"$f":"SUM(E6:E9)","v":17398628.542006999}]
[null,"Total",{"$f":"SUM(C6:C11)","v":14346937.482107939},{"$f":"SUM(D6:D11)","v":4058250.629007},{"$f":"SUM(E6:E11)","v":18405188.111114938}]
[]
[]
[null,"MORUWASA operation and maintenance costs","2012-13"]
[{"$f":"A28","v":2},"Water production (m3)",8572500]
[{"$f":"A29","v":3},"Total O&M costs (Tsh)",5454326443]
[null,"O&M costs/m3",{"$f":"C18/C17","v":636.25855269757949}]
[]
[{"$f":"A29","v":3},"Total costs, including depreciation & amortization",8037638554]
[]
[{"$f":"A30","v":4},"Total cost per unit delivered (US$/m3)",{"$f":"Assumptions!N33","v":0.81}]
[]
[]
[null,"Notes"]
[1,"MCA-T costs from Q20 MCA-T Detailed Financial Plan, GoT costs from Q22 GoT Detailed Financial Plan"]
[2,"EWURA (2013). Water Utilities Performance Review Report 2012/13. Table A2.2, p. 109."]
[3,"EWURA (2013). Water Utilities Performance Review Report 2012/13. Table A2.15, p. 123.  Comparison of these numbers with other cost per unit estimates for Tanzania, specifically Shkaratan (2012), suggest that these estimates include only a portion of the true depreciation and amortization costs."]
[4,"Shkaratan (2012). Tanzania's Infrastructure: A Continental Perspective.  World Bank Working Paper WPS5962.  Table 7b."]

{"sheet":"Savings","index":6,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"User Cost Savings Benefits"]
[null,null,null,null,{"$f":"IF('ERR & Sensitivity Analysis'!$I$10=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",IF('ERR & Sensitivity Analysis'!$I$13=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",\"\"))","v":""}]
[]
[null,null,null,null,"All figures in 2014 US$ unless specified",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[null,null,null,null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,"Benefits?",0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Affected Population",null,null,{"$f":"Beneficiaries!L13","v":249492.42453862631},{"$f":"Beneficiaries!M13","v":257768.12788471687},{"$f":"Beneficiaries!N13","v":266318.33762513642},{"$f":"Beneficiaries!O13","v":275152.15918058169},{"$f":"Beneficiaries!P13","v":284279},{"$f":"Beneficiaries!Q13","v":293708.57957891445},{"$f":"Beneficiaries!R13","v":303450.9398100581},{"$f":"Beneficiaries!S13","v":313516.45567734097},{"$f":"Beneficiaries!T13","v":323915.84630453709},{"$f":"Beneficiaries!U13","v":334660.1863704584},{"$f":"Beneficiaries!V13","v":345760.91790277197},{"$f":"Beneficiaries!W13","v":357229.86246301979},{"$f":"Beneficiaries!X13","v":369079.23373581766},{"$f":"Beneficiaries!Y13","v":381321.65053563984},{"$f":"Beneficiaries!Z13","v":393970.15024504083},{"$f":"Beneficiaries!AA13","v":407038.2026986251},{"$f":"Beneficiaries!AB13","v":420539.72452755016},{"$f":"Beneficiaries!AC13","v":434489.09397983924},{"$f":"Beneficiaries!AD13","v":448901.16623228602},{"$f":"Beneficiaries!AE13","v":463791.28921025776},{"$f":"Beneficiaries!AF13","v":479175.31993224367}]
[null,null,"Affected Households",null,null,{"$f":"Beneficiaries!L22","v":58021.494078750307},{"$f":"Beneficiaries!M22","v":59946.076252259743},{"$f":"Beneficiaries!N22","v":61934.497122124754},{"$f":"Beneficiaries!O22","v":63988.874228042252},{"$f":"Beneficiaries!P22","v":66111.395348837206},{"$f":"Beneficiaries!Q22","v":68304.32083230569},{"$f":"Beneficiaries!R22","v":70569.986002339094},{"$f":"Beneficiaries!S22","v":72910.803645893247},{"$f":"Beneficiaries!T22","v":75329.266582450495},{"$f":"Beneficiaries!U22","v":77827.950318711257},{"$f":"Beneficiaries!V22","v":80409.515791342317},{"$f":"Beneficiaries!W22","v":83076.712200702284},{"$f":"Beneficiaries!X22","v":85832.379938562255},{"$f":"Beneficiaries!Y22","v":88679.453612939498},{"$f":"Beneficiaries!Z22","v":91620.965173265315},{"$f":"Beneficiaries!AA22","v":94660.047139215138},{"$f":"Beneficiaries!AB22","v":97799.93593663958},{"$f":"Beneficiaries!AC22","v":101043.97534414867},{"$f":"Beneficiaries!AD22","v":104395.62005402001},{"$f":"Beneficiaries!AE22","v":107858.43935122274},{"$f":"Beneficiaries!AF22","v":111436.12091447528}]
[]
[null,null,"Without Project"]
[]
[null,null,"Water produced by MORUWASA (m3)",null,null,null,{"$f":"Commercial!F9","v":5361120},{"$f":"Commercial!G9","v":5361120},{"$f":"Commercial!H9","v":5361120},{"$f":"Commercial!I9","v":5361120},{"$f":"Commercial!J9","v":5361120},{"$f":"Commercial!K9","v":5361120},{"$f":"Commercial!L9","v":5361120},{"$f":"Commercial!M9","v":5361120},{"$f":"Commercial!N9","v":5361120},{"$f":"Commercial!O9","v":5361120},{"$f":"Commercial!P9","v":5361120},{"$f":"Commercial!Q9","v":5361120},{"$f":"Commercial!R9","v":5361120},{"$f":"Commercial!S9","v":5361120},{"$f":"Commercial!T9","v":5361120},{"$f":"Commercial!U9","v":5361120},{"$f":"Commercial!V9","v":5361120},{"$f":"Commercial!W9","v":5361120},{"$f":"Commercial!X9","v":5361120},{"$f":"Commercial!Y9","v":5361120}]
[null,null,null,"Capacity?",null,null,{"$f":"IF(G20>G13,\"Yes\",\"No\")","v":"No"},"Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
[]
[null,null,"Households using MORUWASA sources",null,null,"% of households",{"$f":"SUM(G17:G18)","v":54550.929389556368},{"$f":"SUM(H17:H18)","v":56360.392381133526},58229.875547518452,60161.369767441865,62156.931957398177,64218.68726212858,66348.831317762859,68549.632590029956,70823.434790027241,73172.659370121517,75599.808102639072,78107.465744091664,80698.302787774941,83375.078307671443,86140.642896685778,88997.94170234201,91950.017563175294,95000.014249158208,98151.179809612688,101406.8700321725]
[null,null,null,"Own tap",null,{"$f":"Assumptions!C9","v":0.52},{"$f":"$F17*G$9","v":31171.959651175068},{"$f":"$F17*H$9","v":32205.938503504873},33274.214598581973,34377.92558139535,35518.246832798963,36696.392721216333,37913.617895864489,39171.218622874258,40470.534165729856,41812.948211498006,43199.890344365187,44632.837568052375,46113.315878728543,47642.901890097964,49223.224512391876,50855.966687052583,52542.867178957313,54285.722428090405,56086.388462635827,57946.782875527148]
[null,null,null,"Other piped",null,{"$f":"Assumptions!C10","v":0.39},{"$f":"$F18*G$9","v":23378.9697383813},24154.453877628654,24955.660948936478,25783.444186046512,26638.685124599218,27522.294540912248,28435.213421898367,29378.413967155695,30352.900624297392,31359.711158623504,32399.917758273892,33474.628176039281,34584.986909046405,35732.176417573472,36917.418384293902,38141.975015289434,39407.150384217981,40714.291821067804,42064.791346976868,43460.087156645357]
[]
[null,null,"Volume of household water demanded, MORUWASA (m3)",null,null,"Liters/capita/day",{"$f":"SUM(G21:G22)","v":5265487.5461298861},{"$f":"SUM(H21:H22)","v":5440144.6042946279},5620595.064817558,5807031.0957749998,5999651.2394888904,6198660.6239615148,6404271.1813235721,6616701.8735281983,6836178.9255312867,7062936.0662064515,7297214.7772511588,7539264.5503491377,7789343.152862886,8047716.9023392554,8314660.9501204221,8590459.5743622873,8875406.4827723205,9169805.1253893077,9473969.017738007,9788222.074702926]
[null,null,null,"Own tap",null,{"$f":"Assumptions!D40","v":103.5},{"$f":"$F21*$F17*G$8*365/1000","v":5063674.4346057437},5231637.3198094675,5405171.5605911007,5584461.9596999995,5769699.4498220691,5961081.2969107246,6158811.3102623895,6363100.0595602188,6574165.0991171952,6792231.1995574236,7017530.5871822992,7250303.1912765224,7490796.8996172696,7739267.8224586565,7995980.5652726013,8261208.5105365543,8535234.1088681556,8818349.1798168961,9110855.2226330657,9413063.7373449747]
[null,null,null,"Other piped",null,{"$f":"Assumptions!D41","v":5.5},{"$f":"$F22*$F18*G$8*365/1000","v":201813.11152414198},208507.28448515994,215423.50422645695,222569.13607499999,229951.7896668216,237579.32705078975,245459.8710611822,253601.81396797969,262013.82641409113,270704.86664902774,279684.19006885978,288961.35907261504,298546.25324561587,308449.07988059858,318680.38484782109,329251.06382573216,340172.37390416564,351455.94557241257,363113.79510494106,375158.33735795185]
[]
[null,null,"Volume of household water consumed MORUWASA (m3)",null,null,"% of consumption",{"$f":"IF(G$14=\"No\",G20,G13)","v":5265487.5461298861},5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120]
[null,null,null,"Own tap",null,{"$f":"F21/SUM(F21:F22)","v":0.94954128440366969},{"$f":"IF(G$14=\"No\",G21,G$13*$F25)","v":5063674.4346057437},5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014,5090604.7706422014]
[null,null,null,"Other piped",null,{"$f":"F22/SUM(F21:F22)","v":5.0458715596330278E-2},{"$f":"IF(G$14=\"No\",G22,G$13*$F26)","v":201813.11152414198},270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818,270515.22935779818]
[]
[null,null,"Total household expenditures on water, MORUWASA sources (US$)",null,null,"Cost/m3",{"$f":"SUM(G29:G30)","v":4439914.3416530034},4587187.0055085132,4739344.7270138115,4896549.5443069804,5058968.8703568829,5226775.6712471386,5400148.650373836,5579272.4387530964,5764337.7916411599,5955541.7916764226,6153088.0587596875,6357186.9668962099,6568055.8682304118,6785919.3245118624,7011009.3462390313,7243565.6397354687,7483835.8624215471,7732075.886553606,7988550.0717113642,8253531.5463237874]
[null,null,null,"Own tap",null,{"$f":"Assumptions!H9*1000/Tsh_USD","v":0.75096768141292491},{"$f":"G21*$F29","v":3802655.849585779},3928790.5480506448,4059109.1544961799,4193750.4498145874,4332857.8182823081,4476579.4002549984,4625068.2499274444,4778482.4983263817,4936985.5217098119,5100746.1155521683,5269938.6743005728,5444743.3770936606,5625346.3796407077,5811940.0124654332,6004722.9857255742,6203900.6008263594,6409684.9690532312,6622295.2374566626,6841957.8222295912,7068906.6498260377]
[null,null,null,"Other piped",null,{"$f":"Assumptions!H10*1000/Tsh_USD","v":3.157666453158035},{"$f":"G22*$F30","v":637258.49206722435},658396.45745786838,680235.57251763123,702799.09449239331,726111.05207457498,750196.27099214005,775080.40044639178,800789.94042671425,827352.26993134816,854795.67612425424,883149.38445911417,912443.58980254969,942709.48858970439,973979.31204642914,1006286.3605134567,1039665.0389091094,1074150.8933683157,1109780.6490969434,1146592.2494817728,1184624.8964977493]
[]
[null,null,"With Project"]
[null,null,"Water produced by MORUWASA (m3)",null,null,{"$f":"IF(F7=1,cap_wp*365,F13)","v":0},{"$f":"IF(G7=1,cap_wp*365*(1-(nrw*techloss)),G13)","v":5361120},5361120,5361120,5361120,5361120,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720]
[null,null,null,"Capacity?",null,null,{"$f":"IF(G40>G33,\"Yes\",\"No\")","v":"No"},{"$f":"IF(H40>H33,\"Yes\",\"No\")","v":"Yes"},"Yes","Yes","Yes","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[null,null,"Households using MORUWASA sources",null,null,"% of households",{"$f":"SUM(G37:G38)","v":54550.929389556368},56360.392381133526,58229.875547518452,60161.369767441865,62156.931957398177,64218.68726212858,66348.831317762859,68549.632590029956,70823.434790027241,73172.659370121517,75599.808102639072,78107.465744091664,80698.302787774941,83375.078307671443,86140.642896685778,88997.94170234201,91950.017563175294,95000.014249158208,98151.179809612688,101406.8700321725]
[null,null,null,"Own tap",null,{"$f":"Assumptions!C40","v":0.52},{"$f":"IF(G$7=0,G17,$F37*G$9)","v":31171.959651175068},32205.938503504873,33274.214598581973,34377.92558139535,35518.246832798963,36696.392721216333,37913.617895864489,39171.218622874258,40470.534165729856,41812.948211498006,43199.890344365187,44632.837568052375,46113.315878728543,47642.901890097964,49223.224512391876,50855.966687052583,52542.867178957313,54285.722428090405,56086.388462635827,57946.782875527148]
[null,null,null,"Other piped",null,{"$f":"Assumptions!C41","v":0.39},{"$f":"IF(G$7=0,G18,$F38*G$9)","v":23378.9697383813},24154.453877628654,24955.660948936478,25783.444186046512,26638.685124599218,27522.294540912248,28435.213421898367,29378.413967155695,30352.900624297392,31359.711158623504,32399.917758273892,33474.628176039281,34584.986909046405,35732.176417573472,36917.418384293902,38141.975015289434,39407.150384217981,40714.291821067804,42064.791346976868,43460.087156645357]
[]
[null,null,"Volume of household water demanded, MORUWASA (m3)",null,null,"Liters/capita/day",{"$f":"SUM(G41:G42)","v":5265487.5461298861},{"$f":"SUM(H41:H42)","v":5440144.6042946279},5620595.064817558,5807031.0957749998,5999651.2394888904,6198660.6239615148,6404271.1813235721,6616701.8735281983,6836178.9255312867,7062936.0662064515,7297214.7772511588,7539264.5503491377,7789343.152862886,8047716.9023392554,8314660.9501204221,8590459.5743622873,8875406.4827723205,9169805.1253893077,9473969.017738007,9788222.074702926]
[null,null,null,"Own tap",null,{"$f":"Assumptions!D40","v":103.5},{"$f":"$F41*$F37*G$8*365/1000","v":5063674.4346057437},{"$f":"$F41*$F37*H$8*365/1000","v":5231637.3198094675},5405171.5605911007,5584461.9596999995,5769699.4498220691,5961081.2969107246,6158811.3102623895,6363100.0595602188,6574165.0991171952,6792231.1995574236,7017530.5871822992,7250303.1912765224,7490796.8996172696,7739267.8224586565,7995980.5652726013,8261208.5105365543,8535234.1088681556,8818349.1798168961,9110855.2226330657,9413063.7373449747]
[null,null,null,"Other piped",null,{"$f":"Assumptions!D41","v":5.5},{"$f":"$F42*$F38*G$8*365/1000","v":201813.11152414198},{"$f":"$F42*$F38*H$8*365/1000","v":208507.28448515994},215423.50422645695,222569.13607499999,229951.7896668216,237579.32705078975,245459.8710611822,253601.81396797969,262013.82641409113,270704.86664902774,279684.19006885978,288961.35907261504,298546.25324561587,308449.07988059858,318680.38484782109,329251.06382573216,340172.37390416564,351455.94557241257,363113.79510494106,375158.33735795185]
[]
[null,null,"Volume of household water consumed, MORUWASA (m3)",null,null,"% of consumption",{"$f":"IF(G$34=\"No\",G40,G33)","v":5265487.5461298861},{"$f":"IF(H$34=\"No\",H40,H33)","v":5361120},5361120,5361120,5361120,6198660.6239615148,6404271.1813235721,6616701.8735281983,6836178.9255312867,7062936.0662064515,7297214.7772511588,7539264.5503491377,7789343.152862886,8047716.9023392554,8314660.9501204221,8590459.5743622873,8875406.4827723205,9169805.1253893077,9473969.017738007,9788222.074702926]
[null,null,null,"Own tap",null,{"$f":"F41/SUM(F41:F42)","v":0.94954128440366969},{"$f":"IF(G$34=\"No\",G41,G$33*$F45)","v":5063674.4346057437},{"$f":"IF(H$34=\"No\",H41,H$33*$F45)","v":5090604.7706422014},5090604.7706422014,5090604.7706422014,5090604.7706422014,5961081.2969107246,6158811.3102623895,6363100.0595602188,6574165.0991171952,6792231.1995574236,7017530.5871822992,7250303.1912765224,7490796.8996172696,7739267.8224586565,7995980.5652726013,8261208.5105365543,8535234.1088681556,8818349.1798168961,9110855.2226330657,9413063.7373449747]
[null,null,null,"Other piped",null,{"$f":"F42/SUM(F41:F42)","v":5.0458715596330278E-2},{"$f":"IF(G$34=\"No\",G42,G$33*$F46)","v":201813.11152414198},{"$f":"IF(H$34=\"No\",H42,H$33*$F46)","v":270515.22935779818},270515.22935779818,270515.22935779818,270515.22935779818,237579.32705078975,245459.8710611822,253601.81396797969,262013.82641409113,270704.86664902774,279684.19006885978,288961.35907261504,298546.25324561587,308449.07988059858,318680.38484782109,329251.06382573216,340172.37390416564,351455.94557241257,363113.79510494106,375158.33735795185]
[]
[null,null,"Total household expenditures on water, MORUWASA sources (US$)",null,null,"Cost/m3",{"$f":"SUM(G49:G50)","v":4439914.3416530034},{"$f":"SUM(H49:H50)","v":4587187.0055085132},4739344.7270138115,4896549.5443069804,5058968.8703568829,2878634.9646880096,2974119.7436487172,3072771.7678923523,3174696.0954479654,3280001.2691361229,3388799.4321599808,3501206.4475305588,3617342.0214533522,3737329.8308077031,3861297.6548546851,3989377.5113137551,4121705.7969530905,4258423.4328433322,4399676.0144294146,4545613.9665803062]
[null,null,null,"Own tap",null,{"$f":"Assumptions!H40*1000/Tsh_USD","v":0.46439628482972134},{"$f":"IF(G$7=0,G29,(G$7*G45*$F49)+((1-G$7)*G29))","v":3802655.849585779},3928790.5480506448,4059109.1544961799,4193750.4498145874,4332857.8182823081,2768304.0078532775,2860129.091453122,2955000.0276595443,3053017.8478872422,3154286.9347789893,3258915.1333663925,3367013.8659178894,3478698.2505962551,3594087.2240520073,3713303.668083251,3836474.5404968518,3963731.010310289,4095208.5974381869,4231047.3170122597,4371391.8284883779]
[null,null,null,"Other piped",null,{"$f":"Assumptions!H41*1000/Tsh_USD","v":0.46439628482972134},{"$f":"IF(G$7=0,G30,(G$7*G46*$F50)+((1-G$7)*G30))","v":637258.49206722435},658396.45745786838,680235.57251763123,702799.09449239331,726111.05207457498,110330.95683473207,113990.65219559544,117771.7402328079,121678.24756072344,125714.33435713362,129884.29879358812,134192.58161266951,138643.77085709714,143242.60675569592,147993.98677143393,152902.97081690346,157974.78664280137,163214.83540514516,168628.69741715529,174222.13809192809]
[]
[null,null,"Total change in water expenditures (US$)",null,null,null,{"$f":"G48-G28","v":0},{"$f":"H48-H28","v":0},{"$f":"I48-I28","v":0},{"$f":"J48-J28","v":0},{"$f":"K48-K28","v":0},{"$f":"L28-L48","v":2348140.7065591291},2426028.9067251189,2506500.6708607441,2589641.6961931945,2675540.5225402997,2764288.6265997067,2855980.5193656511,2950713.8467770596,3048589.4937041593,3149711.6913843462,3254188.1284217136,3362130.0654684566,3473652.4537102738,3588874.0572819496,3707917.5797434812]

{"sheet":"Health","index":7,"n_rows":118,"n_cols":26,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Health Benefits"]
[null,null,null,null,{"$f":"IF('ERR & Sensitivity Analysis'!$I$10=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",IF('ERR & Sensitivity Analysis'!$I$13=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",\"\"))","v":""}]
[]
[null,null,null,null,"All figures in 2014 US$ unless specified",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[null,null,null,null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,"Benefits?",0,0,0,0,0,0,{"$f":"IF(1/Assumptions!$N$53+K7<=1, 1/Assumptions!$N$53+K7, 1)","v":0.33333333333333331},{"$f":"IF(1/Assumptions!$N$53+L7<=1, 1/Assumptions!$N$53+L7, 1)","v":0.66666666666666663},{"$f":"IF(1/Assumptions!$N$53+M7<=1, 1/Assumptions!$N$53+M7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+N7<=1, 1/Assumptions!$N$53+N7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+O7<=1, 1/Assumptions!$N$53+O7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+P7<=1, 1/Assumptions!$N$53+P7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+Q7<=1, 1/Assumptions!$N$53+Q7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+R7<=1, 1/Assumptions!$N$53+R7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+S7<=1, 1/Assumptions!$N$53+S7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+T7<=1, 1/Assumptions!$N$53+T7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+U7<=1, 1/Assumptions!$N$53+U7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+V7<=1, 1/Assumptions!$N$53+V7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+W7<=1, 1/Assumptions!$N$53+W7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+X7<=1, 1/Assumptions!$N$53+X7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+Y7<=1, 1/Assumptions!$N$53+Y7, 1)","v":1}]
[null,null,"Affected Population",null,null,{"$f":"Beneficiaries!L13","v":249492.42453862631},{"$f":"Beneficiaries!M13","v":257768.12788471687},{"$f":"Beneficiaries!N13","v":266318.33762513642},{"$f":"Beneficiaries!O13","v":275152.15918058169},{"$f":"Beneficiaries!P13","v":284279},{"$f":"Beneficiaries!Q13","v":293708.57957891445},{"$f":"Beneficiaries!R13","v":303450.9398100581},{"$f":"Beneficiaries!S13","v":313516.45567734097},{"$f":"Beneficiaries!T13","v":323915.84630453709},{"$f":"Beneficiaries!U13","v":334660.1863704584},{"$f":"Beneficiaries!V13","v":345760.91790277197},{"$f":"Beneficiaries!W13","v":357229.86246301979},{"$f":"Beneficiaries!X13","v":369079.23373581766},{"$f":"Beneficiaries!Y13","v":381321.65053563984},{"$f":"Beneficiaries!Z13","v":393970.15024504083},{"$f":"Beneficiaries!AA13","v":407038.2026986251},{"$f":"Beneficiaries!AB13","v":420539.72452755016},{"$f":"Beneficiaries!AC13","v":434489.09397983924},{"$f":"Beneficiaries!AD13","v":448901.16623228602},{"$f":"Beneficiaries!AE13","v":463791.28921025776},{"$f":"Beneficiaries!AF13","v":479175.31993224367}]
[null,null,null,"Age < 5",null,{"$f":"Beneficiaries!L14","v":36425.893982639442},{"$f":"Beneficiaries!M14","v":37634.146671168659},{"$f":"Beneficiaries!N14","v":38882.477293269912},{"$f":"Beneficiaries!O14","v":40172.215240364923},{"$f":"Beneficiaries!P14","v":41504.733999999997},{"$f":"Beneficiaries!Q14","v":42881.452618521507},{"$f":"Beneficiaries!R14","v":44303.837212268481},{"$f":"Beneficiaries!S14","v":45773.402528891776},{"$f":"Beneficiaries!T14","v":47291.713560462413},{"$f":"Beneficiaries!U14","v":48860.387210086919},{"$f":"Beneficiaries!V14","v":50481.094013804701},{"$f":"Beneficiaries!W14","v":52155.559919600884},{"$f":"Beneficiaries!X14","v":53885.568125429374},{"$f":"Beneficiaries!Y14","v":55672.960978203417},{"$f":"Beneficiaries!Z14","v":57519.641935775959},{"$f":"Beneficiaries!AA14","v":59427.57759399926},{"$f":"Beneficiaries!AB14","v":61398.799781022317},{"$f":"Beneficiaries!AC14","v":63435.407721056523},{"$f":"Beneficiaries!AD14","v":65539.570269913762},{"$f":"Beneficiaries!AE14","v":67713.528224697628},{"$f":"Beneficiaries!AF14","v":69959.596710107566}]
[null,null,null,"Age 5-18",null,{"$f":"Beneficiaries!L15","v":66614.477351813228},{"$f":"Beneficiaries!M15","v":68824.090145219408},{"$f":"Beneficiaries!N15","v":71106.996145911427},{"$f":"Beneficiaries!O15","v":73465.626501215316},{"$f":"Beneficiaries!P15","v":75902.493000000002},{"$f":"Beneficiaries!Q15","v":78420.190747570159},{"$f":"Beneficiaries!R15","v":81021.400929285519},{"$f":"Beneficiaries!S15","v":83708.893665850046},{"$f":"Beneficiaries!T15","v":86485.530963311408},{"$f":"Beneficiaries!U15","v":89354.269760912401},{"$f":"Beneficiaries!V15","v":92318.165080040126},{"$f":"Beneficiaries!W15","v":95380.373277626291},{"$f":"Beneficiaries!X15","v":98544.155407463317},{"$f":"Beneficiaries!Y15","v":101812.88069301585},{"$f":"Beneficiaries!Z15","v":105190.03011542591},{"$f":"Beneficiaries!AA15","v":108679.20012053291},{"$f":"Beneficiaries!AB15","v":112284.10644885591},{"$f":"Beneficiaries!AC15","v":116008.58809261708},{"$f":"Beneficiaries!AD15","v":119856.61138402038},{"$f":"Beneficiaries!AE15","v":123832.27421913882},{"$f":"Beneficiaries!AF15","v":127939.81042190906}]
[null,null,null,"Age > 18",null,{"$f":"Beneficiaries!L16","v":146452.05320417363},{"$f":"Beneficiaries!M16","v":151309.89106832878},{"$f":"Beneficiaries!N16","v":156328.86418595508},{"$f":"Beneficiaries!O16","v":161514.31743900143},{"$f":"Beneficiaries!P16","v":166871.77299999999},{"$f":"Beneficiaries!Q16","v":172406.93621282277},{"$f":"Beneficiaries!R16","v":178125.7016685041},{"$f":"Beneficiaries!S16","v":184034.15948259915},{"$f":"Beneficiaries!T16","v":190138.60178076327},{"$f":"Beneficiaries!U16","v":196445.52939945908},{"$f":"Beneficiaries!V16","v":202961.65880892714},{"$f":"Beneficiaries!W16","v":209693.9292657926},{"$f":"Beneficiaries!X16","v":216649.51020292495},{"$f":"Beneficiaries!Y16","v":223835.80886442057},{"$f":"Beneficiaries!Z16","v":231260.47819383896},{"$f":"Beneficiaries!AA16","v":238931.42498409291},{"$f":"Beneficiaries!AB16","v":246856.81829767194},{"$f":"Beneficiaries!AC16","v":255045.09816616561},{"$f":"Beneficiaries!AD16","v":263504.9845783519},{"$f":"Beneficiaries!AE16","v":272245.48676642129},{"$f":"Beneficiaries!AF16","v":281275.912800227}]
[null,null,"Affected Households",null,null,{"$f":"Beneficiaries!L22","v":58021.494078750307},{"$f":"Beneficiaries!M22","v":59946.076252259743},{"$f":"Beneficiaries!N22","v":61934.497122124754},{"$f":"Beneficiaries!O22","v":63988.874228042252},{"$f":"Beneficiaries!P22","v":66111.395348837206},{"$f":"Beneficiaries!Q22","v":68304.32083230569},{"$f":"Beneficiaries!R22","v":70569.986002339094},{"$f":"Beneficiaries!S22","v":72910.803645893247},{"$f":"Beneficiaries!T22","v":75329.266582450495},{"$f":"Beneficiaries!U22","v":77827.950318711257},{"$f":"Beneficiaries!V22","v":80409.515791342317},{"$f":"Beneficiaries!W22","v":83076.712200702284},{"$f":"Beneficiaries!X22","v":85832.379938562255},{"$f":"Beneficiaries!Y22","v":88679.453612939498},{"$f":"Beneficiaries!Z22","v":91620.965173265315},{"$f":"Beneficiaries!AA22","v":94660.047139215138},{"$f":"Beneficiaries!AB22","v":97799.93593663958},{"$f":"Beneficiaries!AC22","v":101043.97534414867},{"$f":"Beneficiaries!AD22","v":104395.62005402001},{"$f":"Beneficiaries!AE22","v":107858.43935122274},{"$f":"Beneficiaries!AF22","v":111436.12091447528}]
[]
[null,null,"Without Project"]
[]
[null,null,"Cases of diarrheal disease",null,null,{"$f":"SUM(F17:F19)","v":15388.692745542472},{"$f":"SUM(G17:G19)","v":15899.138127929336},16426.515064718416,16971.385178258279,17534.328719999998,18115.945188427442,18716.853967484385,19337.694986178394,19979.129400063848,20641.840295329872,21326.533416242975,22033.93791671906,22764.807136825235,23519.919405038265,24300.07886711412,25106.116342451198,25938.890208859295,26799.287316676484,27688.223933207402,28606.646718488701,29555.533733420787]
[null,null,null,"Age < 5",null,{"$f":"F9*diarU5","v":4735.3662177431279},{"$f":"G9*diarU5","v":4892.4390672519257},5054.7220481250888,5222.3879812474406,5395.6154200000001,5574.5888404077959,5759.4988375949024,5950.5423287559315,6147.9227628601138,6351.8503373112999,6562.5422217946116,6780.2227895481155,7005.1238563058187,7237.4849271664443,7477.5534516508751,7725.5850872199044,7981.8439715329014,8246.6030037373475,8520.144135088789,8802.7586692106925,9094.7475723139833]
[null,null,null,"Age 5-18",null,{"$f":"F10*diar518","v":3330.7238675906615},3441.2045072609708,3555.3498072955717,3673.281325060766,3795.1246500000002,3921.009537378508,4051.0700464642759,4185.4446832925023,4324.2765481655706,4467.7134880456206,4615.9082540020063,4769.0186638813148,4927.2077703731666,5090.6440346507925,5259.5015057712953,5433.9600060266457,5614.2053224427955,5800.4294046308542,5992.830569201019,6191.6137109569418,6396.990521095453]
[null,null,null,"Age > 18",null,{"$f":"F11*diar18","v":7322.6026602086822},7565.4945534164399,7816.4432092977549,8075.7158719500721,8343.5886499999997,8620.3468106411383,8906.2850834252058,9201.7079741299585,9506.9300890381637,9822.2764699729541,10148.082940446358,10484.696463289631,10832.475510146249,11191.790443221029,11563.023909691949,11946.571249204646,12342.840914883598,12752.254908308281,13175.249228917595,13612.274338321065,14063.795640011351]
[]
[null,null,"Treatment costs",null,null,{"$f":"F16*cost_treat/Tsh_USD","v":7127.3945347775662},{"$f":"G16*cost_treat/Tsh_USD","v":7363.8113434620091},7608.0701352380029,7860.4310299301505,8121.1627755789459,8390.5430346400772,8668.8586796769778,8956.4060988615729,9253.4915116085194,9560.4312946790978,9877.5523191020093,10205.192298269882,10543.700147582214,10893.436356017723,11254.773370031802,11628.095990187923,12013.801780945358,12412.301494039635,12824.019505906586,13249.394269615819,13688.878781794891]
[]
[null,null,"Days spent treating for self or others",null,null,{"$f":"F16*sickdays","v":5201.3781479933559},5373.9086872401158,5552.1620918748249,5736.328190251299,5926.6031073599997,6123.189473688476,6326.2966410097224,6536.1409053282978,6752.9457372215811,6976.9420198214975,7208.3682946901263,7447.4710158510425,7694.5048122469298,7949.7327589029337,8213.4266570845739,8485.8673237485054,8767.3448905944424,9058.1591130366523,9358.619689424102,9669.0465908491806,9989.7704018962268]
[null,null,"Opportunity cost of treatment",null,null,{"$f":"F23*wage/Tsh_USD*employ","v":42514.806926450379},43925.02982436103,45382.030039765639,46887.359183714565,48442.620334443163,50049.469744546521,51709.618604781259,53424.834866373218,55196.945123771147,57027.836559851792,58919.458955647642,60873.826766737664,62893.021268512355,64979.192772597402,67134.562916796684,69361.427030992854,71662.156581525298,74039.201696648553,76495.093775760397,79032.448185178786,81653.967043337761]
[]
[null,null,"Children stunted as a result of diarrhea",null,null,{"$f":"F17*stunt","v":2976.2296388648319},{"$f":"G17*stunt","v":3074.9516486678758},3176.9482832150211,3282.3281623291014,3391.2035087697254,3503.6902677432618,3619.9082303769878,3739.9811612888984,3864.0369303890238,3992.207649052616,4124.6298108102292,4261.4444367045016,4402.7972254684528,4548.8387086852172,4699.7244110944475,4855.6150162161121,5016.6765374680572,5183.0804949595631,5355.0040981491784,5532.6304345613307,5716.1486647627162]
[]
[]
[null,null,"With Project"]
[]
[null,null,"Cases of diarrheal disease",null,null,{"$f":"SUM(F32:F34)","v":15388.692745542472},{"$f":"SUM(G32:G34)","v":15899.138127929336},16426.515064718416,16971.385178258279,17534.328719999998,18115.945188427442,17656.23224266027,17146.089554411508,16582.677402052992,17132.727445123797,17701.022735481667,18288.168470876819,18894.789923564946,19521.533106181763,20169.065459704718,20838.076564234492,21529.278873353214,22243.408472841482,22981.22586456214,23743.516776345619,24531.092998739252]
[null,null,null,"Age < 5",null,{"$f":"F9*diarU5*(1-diarred*F$7)","v":4735.3662177431279},4892.4390672519257,5054.7220481250888,5222.3879812474406,5395.6154200000001,5574.5888404077959,5433.1272367978581,5276.1475314969266,5102.7758931738945,5272.0357799683788,5446.9100440895272,5627.5849153249355,5814.2528007338296,6007.1124895481489,6206.3693648702265,6412.2356223925208,6624.930496372308,6844.6804931019979,7071.7196321236943,7306.2896954448743,7548.6404850206054]
[null,null,null,"Age 5-18",null,{"$f":"F10*diar518*(1-diarred*F$7)","v":3330.7238675906615},3441.2045072609708,3555.3498072955717,3673.281325060766,3795.1246500000002,3921.009537378508,3821.5094104979671,3711.0942858526855,3589.1495349774236,3708.2021950778649,3831.2038508216651,3958.285491021491,4089.5824494097283,4225.2345487601578,4365.3862497901746,4510.1868050021158,4659.7904176275197,4814.3564058436086,4974.0493724368453,5139.0393800942611,5309.5021325092257]
[null,null,null,"Age > 18",null,{"$f":"F11*diar18*(1-diarred*F$7)","v":7322.6026602086822},7565.4945534164399,7816.4432092977549,8075.7158719500721,8343.5886499999997,8620.3468106411383,8401.5955953644443,8158.8477370618966,7890.7519739016752,8152.4894700775512,8422.908840570477,8702.2980645303924,8990.9546734213855,9289.1860678734538,9597.3098450443176,9915.6541368398557,10244.557959353386,10584.371573895873,10935.456860001603,11298.187700806484,11672.950381209421]
[]
[null,null,"Cases of diarrheal disease averted",null,null,{"$f":"SUM(F37:F39)","v":0},0,0,0,0,0,1060.6217248241146,2191.6054317668836,3396.4519980108548,3509.1128502060797,3625.510680761307,3745.769445842242,3870.0172132602906,3998.3862988565052,4131.0134074094003,4268.0397782167038,4409.6113355060816,4555.8788438350039,4706.9980686452609,4863.1299421430804,5024.4407346815351]
[null,null,null,"Age < 5",null,{"$f":"F17-F32","v":0},0,0,0,0,0,326.37160079704427,674.39479725900492,1045.1468696862194,1079.814557342921,1115.6321777050844,1152.63787422318,1190.871055571989,1230.3724376182954,1271.1840867806486,1313.3494648273836,1356.9134751605934,1401.9225106353497,1448.4245029650947,1496.4689737658182,1546.1070872933778]
[null,null,null,"Age 5-18",null,{"$f":"F18-F33","v":0},0,0,0,0,0,229.56063596630884,474.35039743981679,735.12701318814698,759.51129296775571,784.70440318034116,810.73317285982375,837.6253209634383,865.40948589063464,894.11525598112075,923.77320102452995,954.4149048152758,986.07299878724552,1018.7811967641737,1052.5743308626807,1087.4883885862273]
[null,null,null,"Age > 18",null,{"$f":"F19-F34","v":0},0,0,0,0,0,504.68948806076151,1042.8602370680619,1616.1781151364885,1669.7869998954029,1725.1740998758814,1782.3983987592383,1841.5208367248633,1902.6043753475751,1965.7140646476309,2030.9171123647902,2098.2829555302123,2167.8833344124087,2239.7923689159925,2314.0866375145815,2390.84525880193]
[]
[null,null,"Treatment costs",null,null,{"$f":"F31*cost_treat/Tsh_USD","v":7127.3945347775662},7363.8113434620091,7608.0701352380029,7860.4310299301505,8121.1627755789459,8390.5430346400772,8177.6233544952829,7941.3467409905934,7680.3979546350693,7935.1579745836534,8198.368424854667,8470.3096075640005,8751.2711224932391,9041.5521754947113,9341.4618971263953,9651.3196718559757,9971.4554781846473,10302.210240052897,10643.936189902466,10996.99724378113,11361.769388889759]
[]
[null,null,"Total treatment cost savings",null,null,{"$f":"F21-F41","v":0},0,0,0,0,0,491.23532518169486,1015.0593578709795,1573.0935569734502,1625.2733200954444,1679.1838942473423,1734.882690705881,1792.4290250889753,1851.8841805230113,1913.3114729054068,1976.7763183319476,2042.3463027607104,2110.0912539867386,2180.0833160041202,2252.397025834689,2327.1093929051312]
[]
[null,null,"Days spent treating for self or others",null,null,{"$f":"F31*sickdays","v":5201.3781479933559},5373.9086872401158,5552.1620918748249,5736.328190251299,5926.6031073599997,6123.189473688476,5967.8064980191712,5795.3782693910898,5604.9449618939116,5790.8618764518442,5982.9456845928034,6181.4009431563654,6386.4389941649524,6598.2781898894364,6817.144125380195,7043.2698787112586,7276.8962591933869,7518.272063820421,7767.6543422220038,8025.3086704048201,8291.5094335738686]
[null,null,"Opportunity cost of treatment",null,null,{"$f":"F45*wage/Tsh_USD*employ","v":42514.806926450379},43925.02982436103,45382.030039765639,46887.359183714565,48442.620334443163,50049.469744546521,48779.406883843643,47370.020248184243,45813.464452730041,47333.104344676998,48903.150933187542,50525.276216392267,52201.207652865269,53932.730001255863,55721.687220941247,57569.984435724065,59479.589962665996,61452.537408218283,63490.92783388112,65596.93199369841,67772.792645970359]
[]
[null,null,"Opportunity cost savings",null,null,{"$f":"F24-F46","v":0},0,0,0,0,0,2930.2117209376156,6054.8146181889751,9383.4806710411067,9694.732215174794,10016.3080224601,10348.550550345397,10691.813615647086,11046.462771341539,11412.875695855437,11791.442595268789,12182.566618859302,12586.664288430271,13004.165941879277,13435.516191480376,13881.174397367402]
[]
[null,null,"Children stunted as a result of diarrhea",null,null,{"$f":"F32*stunt","v":2976.2296388648319},3074.9516486678758,3176.9482832150211,3282.3281623291014,3391.2035087697254,3503.6902677432618,3414.780097322292,3316.1166296761571,3207.1506522228897,3313.5323487136716,3423.4427429724901,3536.9988824647367,3654.321697138816,3775.5361282087306,3900.7712612083915,4030.1604634593732,4163.8415260984875,4301.9568108164367,4444.6534014638173,4592.0832606859049,4744.4033917530542]
[null,null,null,"Stunting cases averted",null,{"$f":"F26-F50","v":0},0,0,0,0,0,205.12813305469581,423.8645316127413,656.88627816613416,678.67530033894445,701.18706783773905,724.44555423976499,748.47552832963675,773.30258047648658,798.95314988605605,825.45455275673885,852.83501136956966,881.12368414312641,910.35069668536107,940.54717387542587,971.74527300966201]
[]
[null,null,"Present value of lifetime income gains due to decreased stunting",null,null,{"$f":"F51*$H58","v":0},0,0,0,0,0,265761.08106776385,549152.83666939603,851052.48521646066,879282.0313144183,908447.95593983552,938581.31891718064,969714.21033023624,1001879.7846959584,1035112.2962718973,1069447.1355347643,1104920.8668690072,1141571.2675055109,1179437.367751908,1218559.4925573333,1258979.3044558945]
[]
[]
[]
[null,null,null,{"$f":"J58","v":1},"Present value of lifetime earnings per child, age < 5 ","Annual wages, stunted child","Annual wages, non-stunted child","Increased wages",null,null,"Notes"]
[null,null,null,null,"Present value/child (US$)",{"$f":"NPV(0.1,F59:F118)","v":7886.4534341844701},{"$f":"NPV(0.1,G59:G118)","v":9182.0391596046957},1295.5857254202219,null,1,"Assumes average working age of 15-64, which matches the standard definition in dependency ratio statistics."]
[null,null,null,null,"Age 5",0,0,{"$f":"G59-F59","v":0},null,2,"Annual wages assume 250 working days."]
[null,null,null,null,"Age 6",0,0,{"$f":"G60-F60","v":0}]
[null,null,null,null,"Age 7",0,0,0]
[null,null,null,null,"Age 8",0,0,0]
[null,null,null,null,"Age 9",0,0,0]
[null,null,null,null,"Age 10",0,0,0]
[null,null,null,null,"Age 11",0,0,0]
[null,null,null,null,"Age 12",0,0,0]
[null,null,null,null,"Age 13",0,0,0]
[null,null,null,null,"Age 14",0,0,0]
[null,null,null,{"$f":"J59","v":2},"Age 15",{"$f":"(wage-(wage*rtnedu*stntyrs))*250/Tsh_USD","v":2063.117686996904},{"$f":"wage*250/Tsh_USD","v":2402.0464396284829},338.92875263157885]
[null,null,null,null,"Age 16",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 17",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 18",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 19",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 20",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 21",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 22",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 23",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 24",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 25",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 26",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 27",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 28",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 29",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 30",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 31",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 32",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 33",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 34",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 35",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 36",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 37",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 38",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 39",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 40",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 41",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 42",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 43",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 44",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 45",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 46",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 47",{"$f":"(wage-(wage*rtnedu*stntyrs))*250/Tsh_USD","v":2063.117686996904},{"$f":"wage*250/Tsh_USD","v":2402.0464396284829},338.92875263157885]
[null,null,null,null,"Age 48",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 49",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 50",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 51",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 52",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 53",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 54",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 55",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 56",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 57",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 58",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 59",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 60",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 61",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 62",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 63",2063.117686996904,2402.0464396284829,338.92875263157885]
[null,null,null,null,"Age 64",2063.117686996904,2402.0464396284829,338.92875263157885]

{"sheet":"Commercial","index":8,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Water Flow & Commercial Consumption"]
[]
[null,null,null,null,{"$f":"IF('ERR & Sensitivity Analysis'!$I$10=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",IF('ERR & Sensitivity Analysis'!$I$13=\"N\",\"Note: Current calculations are based on user input and are not the original MCC estimates.\",\"\"))","v":""}]
[null,null,null,null,"All figures in 2014 US$ unless specified",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[null,null,null,null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,"Without Project"]
[]
[null,null,"Water produced by MORUWASA (m3)",null,null,{"$f":"cap_wop*365*(1-(nrw*techloss))","v":5361120},5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120]
[]
[null,null,"Volume of water consumed from MORUWASA sources (m3)",null,null,null,{"$f":"G9","v":5361120},{"$f":"H9","v":5361120},5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120,5361120]
[null,null,null,"Domestic",null,null,{"$f":"Savings!G24","v":5265487.5461298861},{"$f":"Savings!H24","v":5361120},{"$f":"Savings!I24","v":5361120},{"$f":"Savings!J24","v":5361120},{"$f":"Savings!K24","v":5361120},{"$f":"Savings!L24","v":5361120},{"$f":"Savings!M24","v":5361120},{"$f":"Savings!N24","v":5361120},{"$f":"Savings!O24","v":5361120},{"$f":"Savings!P24","v":5361120},{"$f":"Savings!Q24","v":5361120},{"$f":"Savings!R24","v":5361120},{"$f":"Savings!S24","v":5361120},{"$f":"Savings!T24","v":5361120},{"$f":"Savings!U24","v":5361120},{"$f":"Savings!V24","v":5361120},{"$f":"Savings!W24","v":5361120},{"$f":"Savings!X24","v":5361120},{"$f":"Savings!Y24","v":5361120},{"$f":"Savings!Z24","v":5361120}]
[null,null,null,"Commercial and institutional",null,null,{"$f":"G11-G12","v":95632.453870113939},{"$f":"H11-H12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Cost of water production and delivery (US$)",null,null,null,{"$f":"G9*cost_water","v":4342507.2},4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2,4342507.2]
[]
[null,null,"With Project"]
[null,null,"Benefits?",null,null,0,0,0,0,0,0,1,1,{"$f":"IF(1/Assumptions!$N$53+M18<=1, 1/Assumptions!$N$53+M18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+N18<=1, 1/Assumptions!$N$53+N18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+O18<=1, 1/Assumptions!$N$53+O18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+P18<=1, 1/Assumptions!$N$53+P18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+Q18<=1, 1/Assumptions!$N$53+Q18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+R18<=1, 1/Assumptions!$N$53+R18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+S18<=1, 1/Assumptions!$N$53+S18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+T18<=1, 1/Assumptions!$N$53+T18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+U18<=1, 1/Assumptions!$N$53+U18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+V18<=1, 1/Assumptions!$N$53+V18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+W18<=1, 1/Assumptions!$N$53+W18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+X18<=1, 1/Assumptions!$N$53+X18, 1)","v":1},{"$f":"IF(1/Assumptions!$N$53+Y18<=1, 1/Assumptions!$N$53+Y18, 1)","v":1}]
[]
[null,null,"Water produced by MORUWASA (m3)",null,null,{"$f":"IF(F18=0,F9,(cap_wp*365*(1-(nrw*techloss))*F18))","v":5361120},5361120,5361120,5361120,5361120,5361120,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720]
[]
[null,null,"Volume of water consumed from MORUWASA sources (m3)",null,null,null,{"$f":"SUM(G23:G24)","v":5361120},5361120,5361120,5361120,5361120,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720,9828720]
[null,null,null,"Domestic",null,null,{"$f":"Savings!G44","v":5265487.5461298861},{"$f":"Savings!H44","v":5361120},{"$f":"Savings!I44","v":5361120},{"$f":"Savings!J44","v":5361120},{"$f":"Savings!K44","v":5361120},{"$f":"Savings!L44","v":6198660.6239615148},{"$f":"Savings!M44","v":6404271.1813235721},{"$f":"Savings!N44","v":6616701.8735281983},{"$f":"Savings!O44","v":6836178.9255312867},{"$f":"Savings!P44","v":7062936.0662064515},{"$f":"Savings!Q44","v":7297214.7772511588},{"$f":"Savings!R44","v":7539264.5503491377},{"$f":"Savings!S44","v":7789343.152862886},{"$f":"Savings!T44","v":8047716.9023392554},{"$f":"Savings!U44","v":8314660.9501204221},{"$f":"Savings!V44","v":8590459.5743622873},{"$f":"Savings!W44","v":8875406.4827723205},{"$f":"Savings!X44","v":9169805.1253893077},{"$f":"Savings!Y44","v":9473969.017738007},{"$f":"Savings!Z44","v":9788222.074702926}]
[null,null,null,"Commercial and institutional",null,null,{"$f":"G20-G23","v":95632.453870113939},{"$f":"H20-H23","v":0},0,0,0,3630059.3760384852,3424448.8186764279,3212018.1264718017,2992541.0744687133,2765783.9337935485,2531505.2227488412,2289455.4496508623,2039376.847137114,1781003.0976607446,1514059.0498795779,1238260.4256377127,953313.51722767949,658914.87461069226,354750.98226199299,40497.92529707402]
[]
[null,null,"Additional volume of water available to enterprises (m3)",null,null,null,{"$f":"G24-G13","v":0},0,0,0,0,3630059.3760384852,3424448.8186764279,3212018.1264718017,2992541.0744687133,2765783.9337935485,2531505.2227488412,2289455.4496508623,2039376.847137114,1781003.0976607446,1514059.0498795779,1238260.4256377127,953313.51722767949,658914.87461069226,354750.98226199299,40497.92529707402]
[]
[null,null,"Value of additionalwater available to enterprises (US$)",null,null,null,{"$f":"commtariff*G26/Tsh_USD","v":0},0,0,0,0,{"$f":"commtariff*L26/Tsh_USD","v":2360100.5231209965},2226421.8325760057,2088308.9986349174,1945614.9400570581,1798187.6968936382,1645870.2686602373,1488500.4471414273,1325910.6436495169,1157927.7105534251,984372.75688765128,805060.95784495259,619801.35794988449,428396.667703546,230643.05348302948,26329.920471781872]
[]
[null,null,"Cost of water production and delivery (US$)",null,null,null,{"$f":"G20*cost_water","v":4342507.2},4342507.2,4342507.2,4342507.2,4342507.2,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002,7961263.2000000002]
[]
[null,null,"Increased water production and delivery costs",null,null,null,{"$f":"G30-G15","v":0},0,0,0,0,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756,3618756]

{"sheet":"Beneficiaries","index":9,"n_rows":34,"n_cols":32,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania: Morogoro Water Supply Activity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Beneficiary Estimates"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[null,null,null,null,"Year",null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,"Tanzania Population",null,null,null,null,null,null,null,null,null,null,null,null,"2012 Census"]
[null,null,"Region",null,"Growth rate","2002 Census",2003,2004,2005,2006,2007]
[null,{"$f":"C31","v":1},"Tanzania Total",null,2.7E-2,34443603,{"$f":"F9*(1+$E9)","v":35373580.280999996},36328666.948586993,37309540.956198841,38316898.562016204,{"$f":"J9*(1+$E9)","v":39351454.823190637},40413944.103416778,41505120.59420903,42625758.850252673,43776654.33920949,44928923,{"$f":"P9*(1+$E9)","v":46142003.920999996},{"$f":"Q9*(1+$E9)","v":47387838.026866995},48667309.6535924,49981327.014239393,51330822.843623854,52716755.060401693,54140107.447032534,55601890.348102406,57103141.387501165,58644926.204963692,60228339.212497704,61854504.37123514,63524575.989258483,65239739.540968455,67001212.508574598,68810245.246306106]
[null,{"$f":"C31","v":1},"Morogoro Region",null,2.4E-2,1753362,1795442.6880000001,1838533.3125120001,1882658.1120122881,1927841.9067005829,1974110.112461397,2021488.7551604705,2070004.4852843219,2119684.5929311458,2170557.0231614932,2218492,2271735.8080000002,2326257.4673920004,2382087.6466094083,2439257.750128034,2497799.9361311067,2557747.1345982533,2619133.0658286116,2681992.2594084982,2746360.0736343022,2812272.7154015256,2879767.2605711622,2948881.6748248702,3019654.8350206669,3092126.5510611632,3166337.5882866313,3242329.6904055104]
[null,{"$f":"C32","v":2},null,"Morogoro Municipal",{"$f":"RATE(10,,-F11,P11)","v":3.3170158819027955E-2},227921,{"$f":"F11*(1+$E11)","v":235481.17576819164},243292.12376731395,251362.16215209433,259699.88499177352,268314.17142223392,{"$f":"K11*(1+$E11)","v":277214.19510170526},286409.43398011778,295909.68039250618,{"$f":"N11*(1+$E11)","v":305725.05148721341},315866,{"$f":"P11*(1+$E11)","v":326343.32538553106},337168.18531809881,348352.10757382354,359907.00230699033,371845.17473359342,384179.3382355959,396922.62789985962,410088.61450616387,423691.31897920842,437745.22731999215,452265.30603246775,467267.01806190092,482766.33926190773,498779.77540770592,515324.37977369857,532417.77129410917]
[]
[null,{"$f":"C33","v":3},"Population of area served by MORUWASA",null,null,null,null,null,null,null,null,{"$f":"M13/(1+$E11)","v":249492.42453862631},257768.12788471687,266318.33762513642,{"$f":"P13/(1+$E11)","v":275152.15918058169},284279,{"$f":"P13*(1+$E11)","v":293708.57957891445},{"$f":"Q13*(1+$E11)","v":303450.9398100581},313516.45567734097,323915.84630453709,334660.1863704584,345760.91790277197,357229.86246301979,369079.23373581766,381321.65053563984,393970.15024504083,407038.2026986251,420539.72452755016,434489.09397983924,448901.16623228602,463791.28921025776,479175.31993224367]
[null,null,null,"Age < 5",0.14599999999999999,null,null,null,null,null,null,{"$f":"L$13*$E14","v":36425.893982639442},{"$f":"M$13*$E14","v":37634.146671168659},38882.477293269912,40172.215240364923,41504.733999999997,42881.452618521507,44303.837212268481,45773.402528891776,47291.713560462413,48860.387210086919,50481.094013804701,52155.559919600884,53885.568125429374,55672.960978203417,57519.641935775959,59427.57759399926,61398.799781022317,63435.407721056523,65539.570269913762,67713.528224697628,69959.596710107566]
[null,null,null,"Age 5-18",{"$f":"0.413-E14","v":0.26700000000000002},null,null,null,null,null,null,{"$f":"L$13*$E15","v":66614.477351813228},68824.090145219408,71106.996145911427,73465.626501215316,75902.493000000002,78420.190747570159,81021.400929285519,83708.893665850046,86485.530963311408,89354.269760912401,92318.165080040126,95380.373277626291,98544.155407463317,101812.88069301585,105190.03011542591,108679.20012053291,112284.10644885591,116008.58809261708,119856.61138402038,123832.27421913882,127939.81042190906]
[null,null,null,"Age > 18",{"$f":"1-SUM(E14:E15)","v":0.58699999999999997},null,null,null,null,null,null,146452.05320417363,151309.89106832878,156328.86418595508,161514.31743900143,166871.77299999999,172406.93621282277,178125.7016685041,184034.15948259915,190138.60178076327,196445.52939945908,202961.65880892714,209693.9292657926,216649.51020292495,223835.80886442057,231260.47819383896,238931.42498409291,246856.81829767194,255045.09816616561,263504.9845783519,272245.48676642129,281275.912800227]
[]
[null,{"$f":"C34","v":4},"Households"]
[null,null,"Morogoro Region",null,4.3,null,null,null,null,null,null,{"$f":"L10/$E19","v":470113.66399080714},{"$f":"M10/$E19","v":481396.39192658651},492949.90533282462,504780.70306081238,515928.37209302327,528310.65302325587,540990.10869581404,553973.87130451354,567269.24421582185,580883.70607700152,594824.91502284957,609100.71298339812,623719.13009499956,638688.38921727962,654016.91055849439,669713.31641189824,685786.43600578385,702245.31046992261,719099.19792120077,736357.57867130963,754030.16055942106]
[null,null,null,"Morogoro Municipal",{"$f":"hhsize","v":4.3},null,null,null,null,null,null,{"$f":"L11/$E20","v":64468.417465512852},{"$f":"M11/$E20","v":66606.845111655304},68816.204742443297,71098.849183072889,73457.209302325587,75893.796601286303,78411.205887929958,81012.118040424088,83699.302862090772,86475.62203106824,89344.032147813006,92307.587883688291,95369.445233991602,98532.864878885681,101801.21565581214,105177.97814708552,108666.74838648859,112271.24168881576,115995.29660644324,119842.8790171392,123818.08634746725]
[]
[null,null,"Households in area served by MORUWASA",null,{"$f":"hhsize","v":4.3},null,null,null,null,null,null,{"$f":"L13/$E22","v":58021.494078750307},{"$f":"M13/$E22","v":59946.076252259743},61934.497122124754,63988.874228042252,66111.395348837206,68304.32083230569,70569.986002339094,72910.803645893247,75329.266582450495,77827.950318711257,80409.515791342317,83076.712200702284,85832.379938562255,88679.453612939498,91620.965173265315,94660.047139215138,97799.93593663958,101043.97534414867,104395.62005402001,107858.43935122274,111436.12091447528]
[]
[null,null,"Beneficiaries"]
[null,null,"Households using MORUWASA sources",null,null,null,null,null,null,null,null,null,{"$f":"Savings!G36","v":54550.929389556368},{"$f":"Savings!H36","v":56360.392381133526},{"$f":"Savings!I36","v":58229.875547518452},{"$f":"Savings!J36","v":60161.369767441865},{"$f":"Savings!K36","v":62156.931957398177},{"$f":"Savings!L36","v":64218.68726212858},{"$f":"Savings!M36","v":66348.831317762859},{"$f":"Savings!N36","v":68549.632590029956},{"$f":"Savings!O36","v":70823.434790027241},{"$f":"Savings!P36","v":73172.659370121517},{"$f":"Savings!Q36","v":75599.808102639072},{"$f":"Savings!R36","v":78107.465744091664},{"$f":"Savings!S36","v":80698.302787774941},{"$f":"Savings!T36","v":83375.078307671443},{"$f":"Savings!U36","v":86140.642896685778},{"$f":"Savings!V36","v":88997.94170234201},{"$f":"Savings!W36","v":91950.017563175294},{"$f":"Savings!X36","v":95000.014249158208},{"$f":"Savings!Y36","v":98151.179809612688},{"$f":"Savings!Z36","v":101406.8700321725}]
[null,null,"People using MORUWASA sources",null,{"$f":"hhsize","v":4.3},null,null,null,null,null,null,null,{"$f":"M25*$E26","v":234568.99637509236},{"$f":"N25*$E26","v":242349.68723887415},250388.46485432933,258693.89,267274.80741681217,276140.35522715288,285299.97466638027,294763.42013712879,304540.76959711715,314642.43529152253,325079.17484134802,335862.10269959416,347002.70198743226,358512.83672298718,370404.76445574884,382691.14932007063,395385.07552165375,408500.06127138028,422050.07318133453,436049.54113834177]
[]
[]
[]
[null,null,null,"Notes"]
[null,null,1,"2012 Tanzania Population and Housing Census General Report (2013). Table 1.  Population projections based on 2012 population and average annual intercensal growth rate."]
[null,null,2,"2012 Tanzania Population and Housing Census General Report (2013). Table 5.0.  Average annual growth rate calculated using populations in 2002 and 2012 censuses, and population growth projected at same rate over 20 years."]
[null,null,3,"Percentage of population in each age category based on National Bureau of Statistics (2013).  Population Distribution by Age and Sex. Table 1.2, p. vii."]
[null,null,4,"Average household size from Impact Evaluation Baseline Report (2014), Table 24."]

{"sheet":"Poverty Scorecard","index":10,"n_rows":50,"n_cols":19,"rows_kept":50,"cut":false,"hidden":false,"merged":[[34,18,38,18],[3,1,3,8],[4,2,4,7],[6,1,6,7],[7,1,7,7],[13,4,13,7],[25,18,29,18]]}
[null,0,null,null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[]
[]
[null,"Poverty Scorecard"]
[]
[]
[null,"Tanzania: Morogoro Water Supply Activity"]
[null,null,null,null,null,null,null,null,null,null,"Bar Chart Data"]
[null,null,"2013 US$",null,"2005 PPP $",null,null,null,null,null,"Activity/Sub-activity","Morogoro Water Activity","National Income Distribution"]
[null,"MCC Cost (Millions US$)",{"$f":"Costs!C13/10^6","v":14.34693748210794},null,{"$f":"C10*(99.991/106.442)","v":13.477430203993302},null,null,null,null,null,"Consump. <$1.25/day",{"$f":"E33","v":1.104604489586058E-2},{"$f":"R18","v":0.12758791923351906}]
[null,"20-Year ERR",{"$f":"ERR!F45","v":3.1687743201184615E-2},null,null,null,null,null,null,null,"Consump. >=$1.25/day and <$2/day",{"$f":"F33-E33","v":5.5680983354060361E-2},{"$f":"R19","v":0.19636263737915438}]
[null,"Present Value (PV) of Investment Costs (Millions US$)",{"$f":"ERR!F42","v":12.742732108258206},null,{"$f":"C12*(99.991/106.442)","v":11.970448941553583},null,null,null,null,null,"Consump. >=$2/day and <$4/day",{"$f":"G33","v":0.17758648540836963},0.29940627353677313]
[null,"Present Value (PV) of Benefit Stream (Millions US$)",{"$f":"ERR!F40","v":7.6910852802834331},null,7.2249610892394056,null,null,null,null,null,"Consump. >$4/day",{"$f":"H33","v":0.2914814816349266},0.37664316985055335]
[null,null,null,null,"Consumption per day (2005 PPP $)"]
[null,"Beneficiaries","Total",null,"< $1.25","< $2 1 ","$2-$4","> $4"]
[null,null,null,null,null,null,null,null,null,null,"National Poverty Statistics"]
[null,"Beneficiary Households in Year 20 (#)",{"$f":"Beneficiaries!AF25","v":101406.8700321725},null,null,null,null,null,null,null,"Poverty Category","% of National HH","Avg. HH Size","% of Population","2028 Est. Pop","Mean Annual Income/Capita","Total Income/Group","Income Share/Group"]
[null,"Beneficiary Individuals in Year 20 (#)",{"$f":"Beneficiaries!AF26","v":436049.54113834177},null,null,null,null,null,null,null,"<$1.25 / day",0.28010000000000002,6.1493580000000003,{"$f":"(L18*M18)/SUMPRODUCT(L$18:L$21,M$18:M$21)","v":0.33828526082352695},{"$f":"N18*Beneficiaries!$AF$9","v":23277491.760477517},0.88483239999999996,{"$f":"O18*P18","v":20596678.900403544},{"$f":"Q18/SUM(Q$18:Q$21)","v":0.12758791923351906}]
[null,"National Population in Year 20 2 (#)",{"$f":"Beneficiaries!AF9","v":68810245.246306106},null,null,null,null,null,null,null,"$1.25 - $1.99 / day",0.2661,5.5401879999999997,{"$f":"(L19*M19)/SUMPRODUCT(L$18:L$21,M$18:M$21)","v":0.28954066436313458},{"$f":"N19*Beneficiaries!$AF$9","v":19923364.123605695},1.5910500000000001,{"$f":"O19*P19","v":31699068.488862842},{"$f":"Q19/SUM(Q$18:Q$21)","v":0.19636263737915438}]
[null,null,null,null,null,null,null,null,null,null,"$2 - $4 / day",0.27439999999999998,4.7308219999999999,{"$f":"(L20*M20)/SUMPRODUCT(L$18:L$21,M$18:M$21)","v":0.25495345668549824},{"$f":"N20*Beneficiaries!$AF$9","v":17543409.880922616},2.7550819999999998,48333532.781552039,{"$f":"Q20/SUM(Q$18:Q$21)","v":0.29940627353677313}]
[null,"Beneficiary Population by Poverty Level 3 (%)",null,null,{"$f":"L44","v":7.7757406240973395E-2},{"$f":"L48","v":0.30587507397357516},{"$f":"L46","v":0.4285626699379787},{"$f":"L47","v":0.26070960413831995},null,null,">$4 / day",0.17929999999999999,3.3287680000000002,{"$f":"(L21*M21)/SUMPRODUCT(L$18:L$21,M$18:M$21)","v":0.11722061812784018},{"$f":"N21*Beneficiaries!$AF$9","v":8065979.4813002786},7.5380779999999996,60801982.476441041,{"$f":"Q21/SUM(Q$18:Q$21)","v":0.37664316985055335}]
[null,"National Population by Poverty Level 3 (%)",null,null,{"$f":"M10","v":0.12758791923351906},{"$f":"M10+M11","v":0.32395055661267347},{"$f":"M12","v":0.29940627353677313},{"$f":"M13","v":0.37664316985055335},null,null,"< $2.00 / day",{"$f":"L18+L19","v":0.54620000000000002},5.8525939999999999,{"$f":"N18+N19","v":0.62782592518666158},{"$f":"N22*Beneficiaries!$AF$9","v":43200855.884083211},1.228874,{"$f":"O22*P22","v":53088408.573696874},{"$f":"R18+R19","v":0.32395055661267347}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L18:L21)","v":0.99990000000000001},null,{"$f":"SUM(N18:N21)","v":1},null,null,null,{"$f":"SUM(R18:R21)","v":0.99999999999999989}]
[null,"The Magnitude of the Benefits5",null,null,null,null,null,null,null,null,"Beneficiaries using own tap",{"$f":"Assumptions!C9/SUM(Assumptions!C9:C10)","v":0.5714285714285714},"of total beneficiaries",null,null,{"$f":"Savings!F45","v":0.94954128440366969},"of total benefits"]
[null,"PV of Benefit Stream Per Beneficiary (2013 US$) ",{"$f":"(C13*10^6)/C18","v":17.638099698959085},null,{"$f":"C25*P44","v":0.36343786793526422},{"$f":"C25*P45","v":1.8413494132163066},{"$f":"C25*P46","v":5.8429649923948128},{"$f":"C25*P47","v":9.5903474254127001},null,null,"Poverty Category","% of Beneficiary HH","Avg. HH Size","% of Ben. Pop.","2028 Est. Ben.","Mean Annual Income/Capita","Total Income/Group","Income Share/Group","% female"]
[null,"PV of Benefit Stream Per Beneficiary (2005 PPP $) ",{"$f":"C25*(99.991/106.442)","v":16.569128981028335},null,{"$f":"E25*(99.991/106.442)","v":0.34141143395196455},{"$f":"F25*(99.991/106.442)","v":1.7297530032967412},5.4888475653834936,9.0091169783961345,null,null,"<$1.25 / day",4.3E-3,9,{"$f":"(L26*M26)/SUMPRODUCT(L$26:L$29,M$26:M$29)","v":8.492140912720627E-3},{"$f":"N26*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$24","v":2325.271050721487},0.89811660000000004,{"$f":"O26*P26","v":2088.3645301524093},{"$f":"Q26/SUM(Q$28:Q$30)","v":1.8257310093300473E-3},0.51769385978527105]
[null,"PV of Benefit Stream as Share of Annual Consumption (%)",{"$f":"C25/(N49*365)","v":1.3083213991742148E-2},null,{"$f":"E26/(N44*365)","v":9.5566151216888544E-4},{"$f":"F26/(N45*365)","v":2.8632741080443381E-3},{"$f":"G26/(N46*365)","v":5.2671619207927001E-3},{"$f":"H26/(N47*365)","v":3.2041981152978768E-3},null,null,"$1.25 - $1.99 / day",0.1895,5.4467530000000002,{"$f":"(L27*M27)/SUMPRODUCT(L$26:L$29,M$26:M$29)","v":0.22649213337551768},{"$f":"N27*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$24","v":62016.823127057192},1.653939,{"$f":"O27*P27","v":102572.04242594185},{"$f":"Q27/SUM(Q$26:Q$29)","v":8.9672543199961513E-2}]
[null,null,null,null,null,null,null,null,null,null,"$2 - $4 / day",0.38619999999999999,5.4747950000000003,0.46396621604416971,{"$f":"N28*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$24","v":127040.66286326715},2.896048,367915.85760383907,0.32164661885085988]
[null,"Cost Effectiveness",null,null,null,null,null,null,null,null,">$4 / day",0.4199,3.2672759999999998,0.30104950966759197,{"$f":"N29*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$24","v":82431.711491664828},8.1434060000000006,671274.89395149238,0.58685510693984844]
[null,null,null,null,null,null,null,null,null,null,"< $2.00 / day",{"$f":"L26+L27","v":0.1938},5.5263850000000003,{"$f":"N27","v":0.22649213337551768},{"$f":"N30*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$24","v":62016.823127057192},1.6370009999999999,{"$f":"Q26+Q27","v":104660.40695609426},9.1498274209291547E-2]
[]
[null,"PV of Benefit Stream/PV of All Costs",{"$f":"C13/C12","v":0.60356642633168578},null,{"$f":"C32*$P$44","v":1.2436651276908255E-2},{"$f":"C32*$P$48","v":7.5127413378489563E-2},{"$f":"C32*$P$46","v":0.19994316620452068},{"$f":"C32*$P$47","v":0.32817660755014505},null,null,null,{"$f":"SUM(L26:L29)","v":0.99990000000000001},{"$f":"SUM(L28:L30)","v":0.99990000000000001},{"$f":"SUM(N26:N29)","v":1},null,null,null,{"$f":"SUM(R26:R29)","v":0.99999999999999989}]
[null,"PV of Benefit Stream/MCC Costs",{"$f":"C13/C10","v":0.53607853870381628},null,{"$f":"C33*$P$44","v":1.104604489586058E-2},{"$f":"C33*$P$48","v":6.6727028249920939E-2},{"$f":"C33*$P$46","v":0.17758648540836963},{"$f":"C33*$P$47","v":0.2914814816349266},null,null,"Beneficiaries using other piped",{"$f":"Assumptions!C10/SUM(Assumptions!C9:C10)","v":0.42857142857142855},"of total beneficiaries",{"$f":"SUM(N28:N30)","v":0.99150785908727934},null,{"$f":"Savings!F46","v":5.0458715596330278E-2},"of total benefits",{"$f":"SUM(R28:R30)","v":0.99999999999999989}]
[null,null,null,null,null,null,null,null,null,null,"Poverty Category","% of Beneficiary HH","Avg. HH Size","% of Ben. Pop.","2028 Est. Ben.","Mean Annual Income/Capita","Total Income/Group","Income Share/Group","% female"]
[null,null,null,null,null,null,null,null,null,null,"<$1.25 / day",0.12670000000000001,5.4197839999999999,{"$f":"(L35*M35)/SUMPRODUCT(L$35:L$38,M$35:M$38)","v":0.17011109334531047},{"$f":"N35*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$33","v":34934.158961898385},0.98413949999999994,{"$f":"O35*P35","v":34380.08573368319},{"$f":"Q35/SUM(Q$35:Q$38)","v":5.4919485053884609E-2},0.51769385978527105]
[null,"Percent of Project Participants Who Are Female6",{"$f":"(L24*S26)+(L33*S35)","v":0.51769385978527105},null,null,null,null,null,null,null,"$1.25 - $1.99 / day",0.2117,4.6069789999999999,{"$f":"(L36*M36)/SUMPRODUCT(L$35:L$38,M$35:M$38)","v":0.24160790142567479},{"$f":"N36*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$33","v":49616.80434163101},1.6565859999999999,{"$f":"O36*P36","v":82194.50343708515},{"$f":"Q36/SUM(Q$35:Q$38)","v":0.1312992596351174}]
[null,null,null,null,null,null,null,null,null,null,"$2 - $4 / day",0.3921,3.9261050000000002,0.38135794179639076,{"$f":"N37*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$33","v":78315.991615280363},2.7885089999999999,218384.84746313383,0.34885263111766995]
[null,"Average Annual Consumption of Beneficiaries (2005 PPP $)",{"$f":"N49*365","v":1348.1473061658921},null,null,null,null,null,null,null,">$4 / day",0.26950000000000002,3.0993889999999999,0.20692306343262409,{"$f":"N38*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$33","v":42493.896480723255},6.8492059999999997,291049.4507391486,0.4649286241933282]
[null,"National Average Income per capita 4 (2005 PPP $)",{"$f":"2.778978 *365","v":1014.32697},null,null,null,null,null,null,null,"< $2.00 / day",{"$f":"L35+L36","v":0.33840000000000003},4.9113189999999998,{"$f":"N35+N36","v":0.41171899477098528},{"$f":"N39*Beneficiaries!$AF$13*'Poverty Scorecard'!$L$33","v":84550.96330352941},1.404801,{"$f":"Q35+Q36","v":116574.58917076833},0.18621874468900201]
[]
[null,"National Population (2013)",46142003.920999996,null,null,null,null,null,null,null,null,{"$f":"SUM(L37:L39)","v":1},null,{"$f":"SUM(N37:N39)","v":1},null,null,null,{"$f":"SUM(R37:R39)","v":1.0000000000000002}]
[null,null,null,null,null,null,null,null,null,null,"Total Beneficiary Statistics",{"$f":"SUM(L35:L38)","v":1},null,{"$f":"SUM(N35:N38)","v":1},null,null,null,{"$f":"SUM(R35:R38)","v":1.0000000000000002}]
[null,"NB: PV of benefits based on 10% discount rate, exclude MCC costs, and include local costs",null,null,null,null,null,null,null,null,"Poverty Category","% of Ben. Population","2028 Est. Ben.","Mean Annual Income/Capita","Total Income/Group","PV of Benefit Stream / Beneficiary "]
[null,"NB: Beneficiaries for this project are defined as households connected or expected to be connected to the national electricity grid",null,null,null,null,null,null,null,null,"<$1.25 / day",{"$f":"M44/SUM(M$44:M$47)","v":7.7757406240973395E-2},{"$f":"O26+O35","v":37259.430012619872},{"$f":"((O26*P26)+(O35*P35))/M44","v":0.97877101854439619},{"$f":"M44*N44","v":36468.450263835599},{"$f":"O44/SUM(O$44:O$47)","v":2.0605273478339198E-2}]
[null,"1    The beneficiaries and population living on less than $2 per day include those under $1.25 per day",null,null,null,null,null,null,null,null,"$1.25 - $1.99 / day",{"$f":"M45/SUM(M$44:M$47)","v":0.23297031968272783},{"$f":"O27+O36","v":111633.62746868821},{"$f":"((O27*P27)+(O36*P36))/M45","v":1.6551154885193677},{"$f":"M45*N45","v":184766.54586302699},{"$f":"O45/SUM(O$44:O$47)","v":0.10439613363365749}]
[null,"2    Based on 2012 Tanzania Census counts, using the intercensal growth rate (2002-2012) to project to 2028.",null,null,null,null,null,null,null,null,"$2 - $4 / day",{"$f":"M46/SUM(M$44:M$47)","v":0.4285626699379787},{"$f":"O28+O37","v":205356.65447854751},{"$f":"((O28*P28)+(O37*P37))/M46","v":2.8550363101489875},586300.70506697288,0.3312695297180816]
[null,"3    Based on MCC calculations using the 2010-11 Tanzania Panel Survey.",null,null,null,null,null,null,null,null,">$4 / day",{"$f":"M47/SUM(M$44:M$47)","v":0.26070960413831995},{"$f":"O29+O38","v":124925.60797238808},{"$f":"((O29*P29)+(O38*P38))/M47","v":7.703179198482192},962324.34469064092,0.54372906316992164]
[null,"4  Based on MCC calculations using the 2010-11 Tanzania Panel Survey.",null,null,null,null,null,null,null,null,"< $2.00 / day",{"$f":"M48/SUM(M$44:M$47)","v":0.30587507397357516},{"$f":"O30+O39","v":146567.7864305866},{"$f":"((O30*P30)+(O39*P39))/M48","v":1.5030511454159747},220298.87927557714,0.12447248571311985]
[null,"5   The distribution of benefits is based on current distribution of income and average water consumption.",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L44:L47)","v":0.99999999999999978},null,{"$f":"SUMPRODUCT(L44:L47,N44:N47)","v":3.6935542634681977},0,{"$f":"SUM(P46:P48)","v":0.99947107860112316}]
[null,"6   Based on MCC calculations using the 2010-11 Tanzania Panel Survey.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P44:P47)","v":1}]

{"sheet":"Sensitivity","index":11,"n_rows":362,"n_cols":11,"rows_kept":362,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Morogoro Water Supply Activity",null,null,null,null,null,null,null,"Last updated: 2/8/2016"]
[null,"Sensitivity Analysis"]
[]
[null,null,"Basic sensitivity analysis using summary parameters"]
[]
[null,null,"Economic Rate of Return (ERR)",null,null,null,null,"Net Present Value (NPV), millions US$"]
[null,null,"Column1","80% Benefits","100% Benefits","120% Benefits",null,"Column1","80% Benefits","100% Benefits","120% Benefits"]
[null,null,"80% Costs",-5.8999999999999997E-2,0.06,0.13400000000000001,null,"80% Costs",-7.5,-2.5,2.5]
[null,null,"100% Costs",-0.08,3.2000000000000001E-2,9.9000000000000005E-2,null,"100% Costs",-10,-5.0999999999999996,-0.1]
[null,null,"120% Costs",-9.7000000000000003E-2,0.01,7.2999999999999995E-2,null,"120% Costs",-12.6,-7.6,-2.6]
[]
[null,null,"Sensitivity analysis using Monte Carlo simulation"]
[null,null,null,null,null,"Crystal Ball Report - Full"]
[null,null,null,null,null,"Simulation started on 2/8/2016 at 3:06 PM"]
[null,null,null,null,null,"Simulation stopped on 2/8/2016 at 3:07 PM"]
[]
[null,"Run preferences:"]
[null,null,"Number of trials run",null,10000]
[null,null,"Monte Carlo"]
[null,null,"Random seed"]
[null,null,"Precision control on"]
[null,null,"   Confidence level",null,0.95]
[]
[null,"Run statistics:"]
[null,null,"Total running time (sec)",null,42.074338818023357]
[null,null,"Trials/second (average)",null,237.67456081131112]
[null,null,"Random numbers per sec",null,1663.7219256791777]
[]
[null,"Crystal Ball data:"]
[null,null,"Assumptions",null,7]
[null,null,"   Correlations",null,3]
[null,null,"   Correlated groups",null,1]
[null,null,"Decision variables",null,0]
[null,null,"Forecasts",null,4]
[]
[null,null,null,null,null,"Forecasts"]
[]
[]
["Worksheet: [TZA-Moro-ERR-020816.xlsm]ERR"]
[]
["Forecast: Economic Rate of Return (ERR)",null,null,null,null,null,null,null,null,"Cell: F45"]
[]
[null,"Summary:"]
[null,null,"Certainty level is 20.77%"]
[null,null,"Certainty range is from 10.0% to Infinity"]
[null,null,"Entire range is from -28.5% to 26.9%"]
[null,null,"Base case is 3.2%"]
[null,null,"After 9,224 trials, the std. error of the mean is 0.1%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statistics:",null,null,"Forecast values"]
[null,null,"Trials",null,9224]
[null,null,"Base Case",null,3.1687743201184615E-2]
[null,null,"Mean",null,4.1880497978161922E-2]
[null,null,"Median",null,4.8233836642885941E-2]
[null,null,"Mode",null,"---"]
[null,null,"Standard Deviation",null,7.1247074939238847E-2]
[null,null,"Variance",null,5.0761456873975154E-3]
[null,null,"Skewness",null,-0.50215954240776772]
[null,null,"Kurtosis",null,3.4201551517761306]
[null,null,"Coeff. of Variability",null,1.7011993261491247]
[null,null,"Minimum",null,-0.28535224598909636]
[null,null,"Maximum",null,0.26905130957274781]
[null,null,"Range Width",null,0.55440355556184417]
[null,null,"Mean Std. Error",null,7.4183512341016126E-4]
[null,null,"Cell Errors",null,776]
[]
["Forecast: Economic Rate of Return (ERR) (cont'd)",null,null,null,null,null,null,null,null,"Cell: F45"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,-0.28535224598909636]
[null,null,"90%",null,-5.2198796144351745E-2]
[null,null,"80%",null,-1.3800865091553604E-2]
[null,null,"70%",null,1.0478792007194E-2]
[null,null,"60%",null,2.9889084793961001E-2]
[null,null,"50%",null,4.8167908107817001E-2]
[null,null,"40%",null,6.5407517510091995E-2]
[null,null,"30%",null,8.2554787066707006E-2]
[null,null,"20%",null,0.101697337142446]
[null,null,"10%",null,0.12704740925782201]
[null,null,"0%",null,0.26905130957274798]
[]
["Forecast: Net Present Value (NPV)",null,null,null,null,null,null,null,null,"Cell: F43"]
[]
[null,"Summary:"]
[null,null,"Certainty level is 19.16%"]
[null,null,"Certainty range is from $0.0 to Infinity"]
[null,null,"Entire range is from  $(18.5) to $20.3"]
[null,null,"Base case is  $(5.1)"]
[null,null,"After 10,000 trials, the std. error of the mean is $0.0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statistics:",null,null,"Forecast values"]
[null,null,"Trials",null,10000]
[null,null,"Base Case",null,-5.0516468279747739]
[null,null,"Mean",null,-4.0849605701652063]
[null,null,"Median",null,-4.4399935935730763]
[null,null,"Mode",null,"---"]
[null,null,"Standard Deviation",null,4.8290375924527353]
[null,null,"Variance",null,23.319604069321709]
[null,null,"Skewness",null,0.44123594158211193]
[null,null,"Kurtosis",null,3.4109029637777555]
[null,null,"Coeff. of Variability",null,-1.1821503560455264]
[null,null,"Minimum",null,-18.504736233831846]
[null,null,"Maximum",null,20.304176604085725]
[null,null,"Range Width",null,38.808912837917575]
[null,null,"Mean Std. Error",null,4.8290375924527354E-2]
[]
["Forecast: Net Present Value (NPV) (cont'd)",null,null,null,null,null,null,null,null,"Cell: F43"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,-18.504736233831846]
[null,null,"90%",null,-10.079932299724264]
[null,null,"80%",null,-8.1508678744896201]
[null,null,"70%",null,-6.8081588760716922]
[null,null,"60%",null,-5.624420123357825]
[null,null,"50%",null,-4.4409287381637688]
[null,null,"40%",null,-3.1667782553930777]
[null,null,"30%",null,-1.7838891205650431]
[null,null,"20%",null,-0.14221592923318355]
[null,null,"10%",null,2.2358461875801021]
[null,null,"0%",null,20.304176604085725]
[]
["Forecast: Present Value of Benefits",null,null,null,null,null,null,null,null,"Cell: F40"]
[]
[null,"Summary:"]
[null,null,"Entire range is from  $(5.8) to $33.0"]
[null,null,"Base case is $7.7"]
[null,null,"After 10,000 trials, the std. error of the mean is $0.0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statistics:",null,null,"Forecast values"]
[null,null,"Trials",null,10000]
[null,null,"Base Case",null,7.6910852802834331]
[null,null,"Mean",null,8.6577715380930016]
[null,null,"Median",null,8.3027385146851316]
[null,null,"Mode",null,"---"]
[null,null,"Standard Deviation",null,4.8290375924527353]
[null,null,"Variance",null,23.319604069321713]
[null,null,"Skewness",null,0.44123594158211082]
[null,null,"Kurtosis",null,3.4109029637777546]
[null,null,"Coeff. of Variability",null,0.55776911774648197]
[null,null,"Minimum",null,-5.7620041255736458]
[null,null,"Maximum",null,33.046908712343935]
[null,null,"Range Width",null,38.808912837917582]
[null,null,"Mean Std. Error",null,4.8290375924527354E-2]
[]
["Forecast: Present Value of Benefits (cont'd)",null,null,null,null,null,null,null,null,"Cell: F40"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,-5.7620041255736458]
[null,null,"90%",null,2.6627998085339408]
[null,null,"80%",null,4.5918642337685833]
[null,null,"70%",null,5.9345732321865139]
[null,null,"60%",null,7.118311984900382]
[null,null,"50%",null,8.3018033700944383]
[null,null,"40%",null,9.5759538528651316]
[null,null,"30%",null,10.958842987693162]
[null,null,"20%",null,12.600516179025021]
[null,null,"10%",null,14.978578295838307]
[null,null,"0%",null,33.046908712343935]
[]
["Forecast: Present Value of Costs",null,null,null,null,null,null,null,null,"Cell: F42"]
[]
[null,"Summary:"]
[null,null,"Entire range is from $12.7 to $12.7"]
[null,null,"Base case is $12.7"]
[null,null,"After 10,000 trials, the std. error of the mean is $0.0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statistics:",null,null,"Forecast values"]
[null,null,"Trials",null,10000]
[null,null,"Base Case",null,12.742732108258206]
[null,null,"Mean",null,12.742732108261318]
[null,null,"Median",null,12.742732108258206]
[null,null,"Mode",null,12.742732108258206]
[null,null,"Standard Deviation",null,0]
[null,null,"Variance",null,0]
[null,null,"Skewness",null,"---"]
[null,null,"Kurtosis",null,"---"]
[null,null,"Coeff. of Variability",null,0]
[null,null,"Minimum",null,12.742732108258206]
[null,null,"Maximum",null,12.742732108258206]
[null,null,"Range Width",null,0]
[null,null,"Mean Std. Error",null,0]
[]
["Forecast: Present Value of Costs (cont'd)",null,null,null,null,null,null,null,null,"Cell: F42"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,12.742732108258206]
[null,null,"90%",null,12.742732108258206]
[null,null,"80%",null,12.742732108258206]
[null,null,"70%",null,12.742732108258206]
[null,null,"60%",null,12.742732108258206]
[null,null,"50%",null,12.742732108258206]
[null,null,"40%",null,12.742732108258206]
[null,null,"30%",null,12.742732108258206]
[null,null,"20%",null,12.742732108258206]
[null,null,"10%",null,12.742732108258206]
[null,null,"0%",null,12.742732108258206]
[]
["End of Forecasts"]
[null,null,null,null,null,"Assumptions"]
[]
[]
["Worksheet: [TZA-Moro-ERR-020816.xlsm]ERR & Sensitivity Analysis"]
[]
["Assumption: Anticipated reduction in cases of disease (% of counterfactual)",null,null,null,null,null,null,null,null,"Cell: D17"]
[]
[null,"Triangular distribution with parameters:"]
[null,null,"Minimum",null,0]
[null,null,"Likeliest",null,0.17]
[null,null,"Maximum",null,0.35]
[]
[]
[]
[]
["Assumption: Cost of energy used to boil water (USD/kWh)",null,null,null,null,null,null,null,null,"Cell: D14"]
[]
[null,"Triangular distribution with parameters:"]
[null,null,"Minimum",null,0.16]
[null,null,"Likeliest",null,0.2155]
[null,null,"Maximum",null,0.24]
[]
[]
[]
[]
[null,"Correlated with:",null,null,null,null,null,"Coefficient"]
[null,null,"Volume of water treated by households (liters/person/day) (D13)",null,null,null,null,-0.5]
[null,null,"Total cost per unit of water delivered (US$/m3) (D19)",null,null,null,null,0.25]
[]
["Assumption: Phase-in period of health benefits (years)",null,null,null,null,null,null,null,null,"Cell: D18"]
[]
[null,"Discrete Uniform distribution with parameters:"]
[null,null,"Minimum",null,1]
[null,null,"Maximum",null,5]
[]
[]
[]
[]
[]
["Assumption: Proportion of NRW that is technical loss (%)",null,null,null,null,null,null,null,null,"Cell: D16"]
[]
[null,"Triangular distribution with parameters:"]
[null,null,"Minimum",null,0.6]
[null,null,"Likeliest",null,0.8]
[null,null,"Maximum",null,0.9]
[]
[]
[]
[]
["Assumption: Total cost per unit of water delivered (US$/m3)",null,null,null,null,null,null,null,null,"Cell: D19"]
[]
[null,"Triangular distribution with parameters:"]
[null,null,"Minimum",null,0.4]
[null,null,"Likeliest",null,0.81]
[null,null,"Maximum",null,1]
[]
[]
[]
[]
[null,"Correlated with:",null,null,null,null,null,"Coefficient"]
[null,null,"Value of commercial water (Tsh/m3) (D15)",null,null,null,null,0.5]
[null,null,"Cost of energy used to boil water (USD/kWh) (D14)",null,null,null,null,0.25]
[]
["Assumption: Value of commercial water (Tsh/m3)",null,null,null,null,null,null,null,null,"Cell: D15"]
[]
[null,"Normal distribution with parameters:"]
[null,null,"Mean",null,1050]
[null,null,"Std. Dev.",null,150]
[]
[]
[]
[]
[]
[null,"Correlated with:",null,null,null,null,null,"Coefficient"]
[null,null,"Total cost per unit of water delivered (US$/m3) (D19)",null,null,null,null,0.5]
[]
["Assumption: Volume of water treated by households (liters/person/day)",null,null,null,null,null,null,null,null,"Cell: D13"]
[]
[null,"Lognormal distribution with parameters:"]
[null,null,"Location",null,0]
[null,null,"Mean",null,3]
[null,null,"Std. Dev.",null,1]
[]
[]
[]
[]
["Assumption: Volume of water treated by households (liters/person/day) (cont'd)",null,null,null,null,null,null,null,null,"Cell: D13"]
[]
[null,"Correlated with:",null,null,null,null,null,"Coefficient"]
[null,null,"Cost of energy used to boil water (USD/kWh) (D14)",null,null,null,null,-0.5]
[]
["End of Assumptions"]