{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["User's Guide","Activity Description","CB_DATA_","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":63,"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":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,3],[24,1,24,3],[27,1,27,3],[12,1,16,1],[1,2,4,3],[5,2,6,3],[17,1,18,1]]}
[]
[null,null,"Tanzania: Water Sector Project"]
[]
[]
[]
[null,null,"Lower Ruvu Plant Expansion Activity"]
[]
[]
[null,"ERR Version","Original ERR","Closeout ERR"]
[null,"Date of ERR","2007-08-24","2016-02-08"]
[null,"Amount of MCC funds","$25.2 million","$45.7 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 Lower Ruvu Plant Expansion Activity expanded the capacity of the Lower Ruvu water treatment plant, which helped expand the capacity of the Dar es Salaam water system, and provided technical support to DAWASA  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 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,null,null,"Expanded tranmission main connecting the Lower Ruvu Plant with the DAWASA network"]
[null,"ERR estimations and time horizon","28.2% over 20 years","15.0% 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 DAWASCO 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."]

{"sheet":"Activity Description","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tanzania:  Lower Ruvu Plant Expansion Activity"]
[]
[null,"Lower Ruvu Plant Expansion 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 Lower Ruvu Plant Expansion Activity includes investments in bulk water supply for the Dar es Salaam urban 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 Lower Ruvu Plant Activity increased substantially from 2007 to 2014, the overall scope of the project did not change significantly."]
[]
[null,"Activity Components"]
[]
[null,"     1.   Lower Ruvu Plant Expansion Activity.  MCC Funding will be used to expand the capacity of the Lower Ruvu water \n             treatment plant serving the Dar es Salaam area, from about 180 million liters per day to approximately 270 million liters per day. Specifically, MCC Funding will support:"]
[null,"             a.   Feasibility studies, final design and an environmental and social assessment, together with any resulting \n                     resettlement action plans and environmental management plans, and occupational health and safety standards."]
[null,"             b.   Raw water system (e.g., grit chamber and pumps), treatment system (e.g., flow diversion chamber, crossflow \n                     clarifier, declining rate filters, and chemical feed facilities), treated water system (e.g., high service pump station  and clearwell), power and controls system, and solid handling facility (e.g., sludge lagoon system)."]
[null,"             c.   Capacity building and technical support for Dar es Salaam Water and Sewerage Authority (DAWASA)."]
[null,"             d.   Project coordination and construction supervision of all improvements and upgrades under the Lower Ruvu Plant Expansion Activity."]
[]
[null,"Economic Rationale"]
[]
[null,"Original Project ERR"]
[]
[null,"In modeling the impact of MCC’s water sector 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 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 Lower Ruvu Plant Expansion 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 Dar es Salaam 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 DAWASCO'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 DAWASCO's current tariff levels."]
[]
[null,"Last updated: 2/8/2016"]

{"sheet":"CB_DATA_","index":2,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Crystal Ball Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xll.CB.RecalcCounterFN()","v":{"$error":"#NAME?"}}]
["Workbook Variables","Last Var Column",0]
["    Name:"]
["    Value:"]
[]
["Worksheet Data","Last Data Column Used"]
[null,3]
[]
["Sheet Ref"]
[{"$f":"CB_DATA_!#REF!","v":{"$error":"#REF!"}},{"$f":"'ERR & Sensitivity Analysis'!#REF!","v":{"$error":"#REF!"}},{"$f":"ERR!#REF!","v":{"$error":"#REF!"}}]
[]
["Sheet Guid"]
["d6978d45-27bb-4443-a0ef-c02f45af2fc0","a04d90d5-a9aa-41da-82e0-2202fce3dedf","9885d39f-b898-4126-aeea-c3ef839a3c66"]
[]
["Deleted sheet count"]
[]
[]
["Last row used"]
[28,26,26]
[]
[]
[]
[]
["Data blocks"]
["CB_Block_0"]
["㜸〱敤㕣㕢㙣ㅣ㔷ㄹ摥㌳摥㔹敦慣敤搸㡤搳㑢㑡㘹つ愵㉤搴挱㡤搳㠴戶㐰〸扥㌴㤷攲挴㙥散愴㈰㐰㥢昱敥㤹㜸㥡㥤ㄹ㜷㘶搶㠹㑢愵㔶搰㜲㉢〵㠹㥢㈸㤴㡢㉡〴攲㠵换㑢戹扥㈰㈱㠱㔰㤱㐰㠲〷〴て〵㈱㤰〰愱㐸㍣挰〳ㄲ㝣摦㤹㤹摤搹㕤敦搸摤戶攰㈲ㅦ挷扦捦㥣摢㥣㜳晥敢昹晦㌳挹㠹㕣㉥昷㙦㈴晥㘵捡㌳㜳摤攲㝡㄰㑡㘷㘲挶慢搵㘴㈵戴㍤㌷㤸㤸昲㝤㜳㝤捥づ挲㍥㌴㈸㤴㙤搴〷㝡㌹戰ㅦ㤴挵昲㥡昴〳㌴搲㜳戹㘲搱搰㔰捦㐱昸㍢㤲㍣ㄸ散㌵㤸〷㔸㥡㤹㥥㕦扥ㅦ愳㉥㠶㥥㉦昷㡤㥤㡤晡ㅥ㥥㥣㥣挰捦挱㠳㜷㑥散摦㌷㌶㔳慦㠵㜵㕦ㅥ㜶㘵㍤昴捤摡扥戱㠵晡㜲捤慥扣㑤慥㉦㜹ㄷ愴㝢㔸㉥敦扦㝤搹㍣㜸攷攴挱㐳㠷慣扢敥扡㜳㄰慦捥㥤㥡㤹㕥昰愵ㄵ扣㐸㘳敡㥣昲挱㔹㔹戱戹㌶㈹㝤摢㍤㍦㌱㌳㡤㝦愹昹攳改㡥㠹挵ㄵ㈹㐳扥㕡晡搲慤挸挰㐰挷〱㘷㉡〸敡捥㉡㌷捦㜰㡥㘲愹ㄵ㌳〸㜵㘷㐶搶㙡㠶㤳㡣㕡㜴收戱㜷㌵㜳㝤搰㔹㤴㙥㘰㠷昶㥡ㅤ慥ㄷ㥣㈵っ㔴ㅤ㜲捥〴昲戴改㥥㤷愷㑣㐷敡捥戱扡㕤捤㐷㈹搷㜷㑢㌲㐴㝡㘲㙡昹ㄳ㔳㠱㌳戳㘲晡㙡㐶〱㌷㈶愳敤㔱扦搲摡昶挶敥攳㜲敡敡つㅣ昳愶敥敤㔰㜳搶昴ㅢ㉤挷扢户㡣ㄷ摦㍡㠳摢扡户㑦敤㔱㙢㥦搷㜵敦愳戶戲戵戵ㄸ㠸改㕢敤㈸ㄶ㘳ㄴ〸晡〹㡡〴㐴愰㔱㈲ㄸ㈰ㄸ〴㄰昹扦㠳㑢搲ㅤ㔹愵㤵㑤慤扣慣㤵㉢㕡戹慡㤵愵㔶戶戴昲㜹慤扣愲㤵㙤慤㝣扦㔶扥㠰㌶㐹㉡昶昷㙢㜱晡昰晢晦昱挳㍦晦攵慢㌳㕦㜸晣ㄷて㍦㍡㝤昶㌷㠳扢搰攸摥㜸㔲戳扥㜹ㄱ愴搶愴攲〳ㄳ晢昹戳㌹㔷㠰㈹慣㐳搶ㅤ搶攴㘴昵搰㝥昳㜶㔳攷戲㌲㤰摦㐲㈸㈳㘸㍢㘸摤㘷扢㔵敦愲挲摤㜵搳㘶㈰㥢ㅢ㌷ㅥ搷㑤㝢㜵户ㅡ扣㘲攳捡挵搰っ攵戵敤㜵捤㐱㍡扡㉤㠲慤㘴愰摥㜷㝤㝢户戳㘶慤㉥愷㉥搹㔱昵㉢摢慡㥤〵摦㕢敥㕥㝢搴㤷て㌴㙡㍢㘶㌴〵愱戶愶挶敥㔸㘵㔴ㄵ捤㙢㙣㘶挵ぢ愴慢愶㌷敥㉣搸㤵ぢ搲㕦㤴ㄴ㠹戲慡㤶㝡㈵慢㘲慥ㅦ㥦㜷戱㔰㜰㙢昵搵改㔲敢敥㑢㈱㤸㔹㔶㌱摦㔵改㠷敢㑢收㜲㑤㕥搵搲㈴㝡㈷㉡昶戶ㄴㅦ昵㉡昵㘰挶㜳㐳摦慢戵搶㑣㔵搷㑣㐸㥡敡㐹慦㉡昳昹㥣ㄲち㄰戸㝤㝤㐲攴㙥敤捥ぢちㄱ㈹ㄴ㤳㤱慦㘹㈵扢㠹搳㔸ㅤ㔶㔱㤳愴㐹敤㌵㥢っ挶昹㉡ㄹ㤳挱㠱愹㌵㔱㝦昰愵慦摤㘴搸〶收㕥摡挶㥡㌶ㅡ慦晥敥㌵改㠶挷㑤户㕡㤳㝥愶昶ㄳ㥣㤱㌱っ愰㕦㠶㐰攸扡㝢㔴㜵攲㤲㔸搷㉦摡搵㜰愵戰㈲敤昳㉢㈱捡愰㈱㡢㐵㙥㙤㐷㌲慥㐰㤱戱㥢㘰ㄴ愰㔴捡ㄵ昶戰㔱愱㠴㤴搳㈹㥤㌲㜸戹㐵㤰戳㕦ぢ㉦て㕡㐷敤㕡㈸㈳愱㍣㙣〱㈳㤱㔶㔳攸ㅢ㈲㠹晡㘶㈵㔲ㄸ㝢慣ㄹ㔰愹㘹扢攱㝡㤳㙦㍢戸㈴㈲愲ㅤ㔹戰敤㘴〱㐵㐱慢㍣挸攰㌵㄰㑤㥢㌴挸㙥㥣㈲㈲戲㐱㠶㘶挷挸慤㐴挶昶ㄹ㌲〲敤搳㐴挸搶晢扢换〸ㄲ㝢㈷㤱戲㔳㔷㝥摣㤱㘶ㅢ搹昲㤱㌴扢ㄲㅢ㘷㕣㐵㜰㌵挱㌵〴㝢〱挴ㅦ㈱攱㈸攵㤰㙦㑤挶㉢昰㙣㕣㐷昰㑡〰挸㈷㠳㌲㈷ㄶ㔵戴愱戶㘲㐷戲摤㄰散㘴㘵ㄴ㐷愲㠸㤶㜱挳捥ㅣ㜲ㄴ愲㘳慢㜳㝢攸摡扣搲戱㌷㜷愷捤昴㜲㐸㤱ㄹ㑤搳㙢摤愴㘹㝡㈳搸戴㐷扤㜵〳扡ㅡ㘳〴慦〲㈸ㄹ慦㈶㠴㜲愱挱扢㌵㡢㥥㈶攵换挲㉣㡡㡣愱ㅥㄵ㝣㑣挸㍣〲㘴〸戹㡥攳换㡥つ㑤㜳㜰摣㝡搹摢搰晢扡昳㜷㡣昴㌶扤戹愳㜷攸㉦㝡㥥㔶昴㡤㘰㉦昱摢慥㍡收㈶㔴ㅢ㌷ㄳ摣〲搰愶㘳㜸晡㝥扥㥥〲㘵ㄶ㍢㈹捣敤愶搷㐵㔹戹㑢敢慢㔲㘹愰㐱㙢挹昴捦换㄰ㅥ㡣ㄳ戳戰㠵㍤摦㤷㌵ㅣ㙡慢慡㠰攷㤷慢㕢ぢ㠳愳扥攷戰㝣挷㐶づ㕥ㄶ㡡㈱㥦搷晡㜲㙤㌶㜲㠶慤㤹昲㌹愵㈸㠷㍡昸昶敥㐲㈲搵愹㤵扣搸㉦晢㝣戹㈳㐹㝡㤰㈴慦挳戶ㅡ户〲㐰㑡㠸㕦㜵㤵㈸晢搸散昵慡㔹慢挵㑡て㕦挶改愴捤㠷搸㈱㐷〶㈲㠷敤㌴晣〷挱㤰戳㘸㍢つ㘱㌱攰㉣㐸扦〲摦㠲㕤㤳愵挸㉤㑢㔱戳㈳㉢㕥㈶戲愲慦慦攳㍣㥤攱㕦㔳㜴搲㈶㈵㌲戹㍤戳㌲攳㉣摥㈴㉡扡㈱㈹㔴㌲㕣㐳つ〹㐴捡㘳摢ㅤㄱ搳㠳㠸戹つㅢ㘷散㈷㤸㈴㌸〰愰晦っ㤲㘶慢ㅢ捦㜰㔸晦ㅡ㕤摡攵㜲慥㐸㌴㈸ㄷ攱戳㕤㠵搵㈱扥收つ〴㜷〰戴㤹㍦㜴㐰㘶㄰愲㐲㜹㡡㄰㔵ㄸ挳㍡㙢换㡢愴㠱㕤ㄶ〲㑢㌳昵㈰昴ㅣ㐶㤶㠶慣㔹敦㤴ㄷ捥摡挱㉡㈲㔱愳㔶㥣戹㙦㐵扡愰㉥ㅦ戶㑦㕢㤹户扡㉡慢㠶戵攸搵㈱摡㑥捣㙥㠷㠳㌹戶〳戶愴㍡㥢㙢〲愹户昳㌱㠶㄰搸㘹攵㙦愵㌷㜶㑢摥㙦ㅥ晡㠶㥢㍢扡㘴㠷㌵㌹㘰㐵㑣挷㝣搱挲㉥㈲㜲㔰敤户㤶㔶㝣㈹㘷㠷慣㘳扥㕤慤搹慥㈴㌲㘰㘳㌲㔸㌷㈷捦㈳㑡戰攰㌱〶攸戹㐳搶㤲㙦扡挱慡挹㠰攲晡敥㤶㈷ㄵㄶ搱慤㘹摢つ昰ㅡ㠵㐵收㠷慤挵ㄵ敦㈲㈲戶㜵挷㍤㘶慥〶摢〲㉢㈴晡㈸㈹搴〸㑤㘸㥡㈸㙡挵㕥昱挳〳㜹㉥㐷摥换ㄳ㈸㕣攵㜴晡捣㌳戴㌷敤晡㌸㐶㐳㍢㥤㜳ㅡ㐴昴愸㔱搸㤷㈹㠵挹愹挶㕤散昳㐶㠰㝢㡥㥤㌹搱㡣捣扤愰㤸戵㑥㉦㝦㠶㡣㔷㘴搱〸㠴搰㐷户㉢㈲ㄵ㤶㤱㜲挰㠱挰㌸㥦摡挹慦㘴愹㌶愴扥㕤捤散㔱㐴㤲〶慤㌹㜳㔹搶㄰㡦㜶捣㜰㔷昴㐰㌳搶㌱㙢㐱㕣㌷攳㌹㡥㐹搲㈲㔹㉥㔶㑣㔲昰㔴㍤昴㑥摡慥㘱〱㈸晡㡢㡢捣㑢㈸㌲㉦愹愲㐱敢㌴㐳㠳㉡捦戱扣昳愶㙦㠷㉢㡥㕤㈹昲㠱攱扢㙤㐱㤳㘰㜲㑡摥㈴㈵㌲㘳慣捤㥡㍦〳㤳㉤㤸〰扡㈷㈰㐷戹㜵㐴㍦㈸㔷ㄳ〵晣㠸ㅥㅤ㑢㄰㌰捡㔳㙡扣ㄹ愳改敡㜶〴㐴㡥㑡㤷㤳㍢ㄸ㤷ㅦ㐶㐹㈴㠴㠸昵っㄲ㠱㔷㌰㈵攴改攲㉥㔸㘷㕣㍢〴昶㠸戱愳㜶㌸ㅢ〰攵〰挸慡攳敤戵ち慢愹㑥攳つ慤㜰㐳㘷㔵㡢㥡戸扥戳㍥慤㌷㕥戳㐱㜵愴㔱㔲㡡㘴戳㐶㑡戳㙣㌰挷敤愴㙡㠴㔲摣㠹戶ㄱ㔹㙥搳收扥㔳㡡扣〰挵愴㘸㈶㘷扣㐵ㄱち〲扤戱㡥愲捦㍥㥢㍣㔲ㄱㅢ摡〰㈵敡愹愸㙣㈸づ〹㥥挰戵㤳慡㉣挵㑦攰敦㕤㜱㜶扥ㅥ戶搴㤸㤷㐶攳㥡愹㕡㙤摥㠵㤵㔰㌱晤敡㌶㘱㘹慣㉤搲㌰㡡㍢㝢搵晥搱昶愶ㄸ㌱㘶㐳㠶㐵㌲晣挰㘰㐳㌰㔷㉡愲㑡敢㙣㠸㕢摤㈸㉥昲改愴㌴㕤㠵㠱挵戰㍡㉢搷㤴ㄹ搶戴攴㐷㔵㠷挶㘹㔱挹㔱挳㥡㕡づ愰搲㐳捡昱㌸愷ㄸ摣戰㑥搳㉤㠵㑢っ㄰扢㜱㙥愱ㄲ㈲戴摢ㄸ㠰㈷㠳敤㠳ㅤ散㐸ㄴ㍡愱㜵㐶〹㕡挸㈰摣搶㐵㤰㜷㝡挴㈸〴愹愵搲摦㡥㠸捦㍥挹昴戵㈳戹㈴ㄳ㌳ㄱ挳㕤ㄹ搶〳㤰㥢㡥㑣㤲㡢㐶㤳㠰㜹㈴搹㤴搰ㅡ㑣捡㘸㘲っ搱攴昳㐳摣攲㘱㉣㙢㤸㙣㔳挳㍤户搰㠶㌶慤慤敦戲㑥戸㤵㕡扤㉡㤵㉡㑥㘴戵搲挸摢〲㕦敡ち㘰挴㑤ㄹ晢ㄲ㙦捡〹ㅣ愵戸㘴㈲愹㜷扢摢㌸㠲敥㑡挸㘱㡣㐸昵㌱〰㤹攱㤶㔳〱戱㡥㝢ち戴て㜷㌷㉦㌰愸换㜳㄰㘹ㅤ㐵㤴㘵㜳戸㡦搷㠸㈲㉢㙥㑢㌵㥢昳收㍣摡散愹愲攳㜶㔴戴㉤㜰㠴㜵㐶〲慦㔰㠰㌱搲㈳㜷㜰㤰摣攵㌸扡㝢昹㘱昵㤸扢っ㔴㈸っ〸挶㜸㜹ち捡㘱㔷挱㐸㌴戸戵愶搵㉤ㄸ晤愵攵㙤㑣〱〸㠶㠱㘹搰愲㘵㘴攰捣㈰扦戹㠱㜳〳㕡㘵㐴㐸搳挱㔴挶㈸㐷攱戰〷搲挰㑤㍣㐸㉦㜹㔰㐲攱ㅥ㜵㌱㉣戹㥢㌸敥攰〸攴昹㔷戵ㄵ㉥㤸㈱慥扦戸㝢摢㡡愷慡㔵㥡扢昰捦㙤ぢ慣攲敡㐶㘴㡥敥㘹扢㤴愵搶㐴晢敥挶戶㡡昸戲攰㠱搹㠹攳㘶㔸㔹㔹っ搷愳㡢㕢扤㤲㠴晥〳昸㈳㌶㝣㍢㙤收扣换㡢愸㙢摣晢搲〵搷扢攸慡㜹改〱㙦晤㠱㐲㜰㠵戲㥦㤳㉣攵晥㡤ㅦ㤵戴㥣晥㝤㡣戸㤵㘹㜳㠰愶㠳㠴攳愸ㄴ㐹㠳㌱攴㌳攸〴戶㝢攳搶〰改㘴㑦ㅢ㥤㈸㐱戰㐳㈸敥昹ㄷ㡤㔰挴昷㠰㔶ㄲ㑢㜴㈴挷㥥㝦〵慣㉦扥㡢ㄲ㈲ㅣ捦戱ㄸ搱㕦㠵㕣〶敡㤴㈰㡦慦㜸昰㐲挸晦て㤶ㄲ㙥摥㤰㥤晥ぢ捣㉣扥搳㡥愲敢㠹愲㙦㜷愰㐸昰ㅡ㠸攲摦㝢㤰㐹㤲捥昰散昳ち㠴㜳㑤㍢〷搰㤷晣挲敦晦昰〰㍡ㄷㄳ㠷戲搱㄰㙡扢〹捦つㄳ愱慦挳㐴㘰昰㕥㤹〸㈷㤱ㄱ㡣攲㐷㈶㐲散〳㤹㐷挱收㈶〲㘳㝢ㄹ㠶㘰㉡搴㥡㜲㙢昰〴㜶㤵㐳晦搸㜱㕣扣㤵〱攲昹㔰㕡挱っ㍣㔲㔷㜷ㄶ㉦㤸扥改散㔵攵挷㝣〹㘵收㉦攱㈶户敡挲ㅥ搷㙥㔸愳㍡㙤攰慢㐸扣散㍢晥㤴慤摤㕦〷愶愲ㄴ戹敦㐵㔱ㄴ㕥㠰愷㐴昰摣㤰㝢捦㥥慦ㅦ晢摤㠳㡦ㅥ攱㙤戵㤸㔶昵㕢㤱敦㈵㘴㑦㝢〲㐱摤搴㐵㤱㉢昹㘱捥㐹㝣愲㘴慦搶攴戴改㉢㉢㈸㌰㥣㈴ㅢㄱ㕥㡡㌰㈳攲摢づ㈶㈶敥㍤㐴㈶收㐴㥢扢㔳㝤搸愴㕣㠴ㄳ愹㠹㉢㥦㕥ㄲ㌶ㄴ㕤ㄵ㔹㡦搶愶晥㑤愸愲攷㌹㤱㔶㉢㤱愷㑥㈶㈱扥搱慥敢づ㔱搷㐵〷ㄹ㠶晤ㄳ㈹㠵昸〳㈹㈴㝤㤰攱㠵〰㈵愵㑥㈳愳摦〶㤰ㄱ㔹㙢て昱搲ㅦ戰㈳〴㘴攳搲㕦㡦ㅦ戱㘰ㄷ㠱挵挴ㄷ摦敢㠹㤶戶㘸愲㥡ㄸ慡㔵㌶捤㈲㌲敡昰挲㠲挹愴㜴〹㤹㈴改〷㤰摢戲㍢㡡㉦ㄹ㜲愲挰㕢挴搸扡㐳㕦㕢挹戹摢慤攳收〷昴㑣㐱㈹っ㜷㌷㡢㜱㈰㔵㌱扡愸㘹㈹㉡㈲ㅣ㡥戲㡤㑥〳㜱ㄵ㜴㤶扢ㄷ愷㔲〴晦昸愵㄰敢挷㥢㐳㕦搹㕥㐳ㅤ攷昶㘳㠱晣㠵晤㜵㝤〶㘳攳慤攴ㄸ㐸搸㉤戵㉡㐶搷挳捦愰ぢㄷ㥤ㄳ㐶㌳慢㥥挵㈱晣㐹㌸慢㑦敢搰晦㡣㕥㉢捥㍡换摥っ㘳户攸晦户愳㘰㔳晤㉦ㄸ㝢㔳㠸㝣㐷㥣攱㠳捥昸挹愶㈱ㅢ敥〸㍣摢〸摥愸㠳戱愱戲っ㜹㐷戹㐵㝣扣ㅡ㔵㉢〹づ扦㔷扥晤㙡㐴愳㉦㙤摢㠱慥〲㤰戱㈱晤㉢㄰㐱㕤晢户捡慤攴㜴㕢㜸㈷㍡敥㌹㘹㔷㝣㉦昰慣㜰㙣ㄱ㐱摦㌱㝥㝢㘶挱收㤹ㄲ㕦㙥ㄷ㙡㌷㘲㈷〶摦㡤㍥愷收㈱戰㑦挹昰挵㡡㐵㌲戲戰戵㐸〶扦㐳ㅡ㐹㠵㤷愸ㅤ㠲㉢慣㝢敢㘶つ㥦慥捥挳搷ㄹ戲㘸㕢㈸扢挸攳摣㝥㐳㠳㕢㠷㍢㕡㙦㠳㍦㐸搶㈶㄰ㅣ㔳㑢㜸攷扢戹慦敤㝢搰摡㌶㕥㕢挰㤶扤昹摣㑡晡搳挰改搶摥搲㑡㌲㝣㈷扦㐸㉥ㄹ㘵㐲㕣摡㍦㠲扦㕢㜷搰㜲戴㔱搰㜹晣㐱㌷ㅤ㘱攳㌵戸捦戶㄰晤㍥㠷慥㘲㡡〰扦㠶ㄹ㘷昸㈰攸攵㈳㉢㡡㉦㘰㔹㘴〰攴㜳㠵ち㐰㜷慡㝥㙡㈳慡ㅥ戹㠷㍤㤱〴捦ㄸ㈴挷㤲昸ㅣㅡ㜲扢愲㘵㠳㈵戸㙣愱捥ㄲ挸ㅢ㐹て攴㜳㠲㘷〹㌵㤱捦愰㐳㘳㈲㌶㑡扢㑦攴搳ㅢ㑤㐴搰ち㔰ぢ㑤㡦㍦㤲㘸ㄱ愳㠶㙡挳㈱㜰〹㍣㠰㤱㐴㤹っ㔳㍥㔲攸ㄴ愲ㄸ挳㜷㠹㈲愴㥦挷㝦㥦㍢昲戳㘷㤹晥㝡㐴㈸㠹㠸慡搶㔵㔰㈲慡㔵㝣㉣扤ちㅦ愵摤㔷昱挴㐶慢ㄸ愱戰攴㑣㡣㄰㘰愸㑦㤴昱㐷慤慡㡥っ㌷㤴扦攲ㅣ〱㝥㕢㘶㌱㘲愲㐴昵扤㠸っ晡㜲攷㔵慢㑢挸㈴㝤㜵㙥㐴挶㔷㍥捡㔰攲㡤㐸㍡㜵ち㤱㔷戶㄰愹挷愲ㄳ扢㘳户㠵㤰挰㤲昸搹㙣㔷搹㕥攸㌱搴㉦㍥㤰㈰收昸昱攴ㄳ㉡㉤づ㍥㠱㌰㈲搳㤴㠴挴㡤ㄴ敦㑦ㅡ㝦敢㤹愶敦ㄴㄵ㐸愰㥥愸㌱〹㑥㌵㝥㉣㘹㝣〰㥦㘷愹㌶㌹㕥㈵㘰㝡㉥㘹㑣挲㔴㡤ㅦ㑤ㅡ晦攵挰摥㐶攳㠴づ愳㤱㜵ㄲ㐹㠶搱慢㡥〱愹㑦戵㠷搱㕣户愸㐸〷慣愸㤸㈲㔴挵㤰㙢㑡㤵づ攲㔶㠸㡦㡦愵攷㜰挹〹㜷㐱㈰㙤愳晦㌳攱〴㉥㍦捤㥡愱㠹㙦愱搷㄰㜵昶つ昵挴捥〵㙢摥㐷㐱扦㜵㈲挰攱慡扡慤㐸〴㜶㐱㍥摡摦㑤扣昳ㄹ㌶㘴㜳㍦㤲㘸㤹挶换㈴扤㘹ㄱㄵ㘱挹㡢昷㈶㤸捤㍤搲愴ㄹ攳㘱㈰〷㘲ㄲ㤰ㄹ攳ㄱ挰㈸㈲戳㠷〵㈳攴㝦挵摣敦㘵挵晢〸ㅥ〵㈸〹㌲㍢改愰昰ㄸ挰㜰昲㍦㔶㡣慤㈹挷㠹㈶ㅥ㑣㕥㤶㈶㈳攳〳散昰㐱㠰㍥昸㜱㐵㑣㠴㈵攳㐳㈸㐹扦㤴㠲㐳扤昴㜱㔶㝣㠴攰〹㠰㤲捥挹㙥㜹搷戸愶ㅥ㔵搸㐷搱㔵㍣㐲㠰㕦攳㘳㜱㠶て㍡昷攱㑤摤㡤㘶㥥㠹㤳㉦晣ㄱ昳㙣昹㤴晦㙥㝣㥡扦捥㐵昷攱㝦㈶搱㤵㠵㥦搷摥搸摢㔸㘴〲ㅡ攷敡㜷ㄵ㥢晤〲挶攱扡㥡愱ㄴ㡥㐸愵㔲搴ち㠲昸收㠲㠵㠷㌷昰㉤㠷㔵㠵㄰愴〱㔵攱挶ㄵ㐷㔰㘰㝣㠲㑤㠹㘳攲挹昸㈴㥦㠸㕡戵㠹㥦㡡㌳㝣㄰挴慢敡㝥㝦摣㍤㜹㈱㜱慤㉡散戶ㄷㄲ晦慡㘲㈵晤挲㈷㌹㤸㐲ㄶ㌲慤㕡㠹㐸㔳㌴昴㌹㘴㠶晡㠶㌹户晢昰慢㕤ㄲ㤵㜳搵㜳攷晥㌹㥣ㅦ扢㌶晦昶户づ㍥昹摣㑦㝦晦昱㕦扥敢昰㥦晥昵搴㔳扦晣挳挷㥦晤搷て㤶て晦昸改愷㝦㜴捦ㄷ㥦晤晤㙥敢㑢摡㌳晦㥣晢搲㐳㤳ㄷㅥ㝡挰㍡㜳敢戱㠷摥㜱晦扤㤳ぢ㔷㡣昷昵昵昷摦㌲晡㤳㙢㕥㍢昲挸〳摦ㄱ㍦晣昵搵慥㔰换挵ぢ㕡愷挱㘵慢㘹㝣ㅥㄹ㑣㠳㌳㝥㐹愷挱攵慡㡤㕡㡥㌷㙡ㅡ〵㐵㌸㌷㌸〱㔵㘱戶㔶っ晣〷㘵ㅢ戵慣"]
["Decisioneering:7.0.0.0"]

{"sheet":"ERR & Sensitivity Analysis","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,1,20,6],[57,2,57,6],[5,1,5,6],[7,1,8,1],[7,2,8,2],[7,3,7,6]]}
[]
[null,"Tanzania:  Lower Ruvu Plant Expansion 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)",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)",1077,1077,"500 - 1,500",{"$f":"D15","v":1077},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.9,0.9,"0.40 - 1.00",{"$f":"IF($I$10=\"Y\",D19,E19)","v":0.9}]
[]
[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!F48","v":0.14914692980684396}]
[]
[null,null,"MCC Estimated ERRs:",null,"Original","Closeout*"]
[null,null,null,"ERR",0.28199999999999997,{"$f":"Sensitivity!E71","v":0.1501710168681212}]
[null,null,null,"Date","2007-08-24","2016-02-08"]
[]
[null,null,"User Generated Economic rate of return (ERR):",{"$f":"ERR!F42*10^6","v":171907907.68776548},"2014 US$, 10% discount rate"]
[null,null,"Present Value (PV) of Benefits*:",{"$f":"Sensitivity!E185*10^6","v":115187686.72777587},"2014 US$, 10% discount rate"]
[]
[]
[null,null,"Present Value (PV) of MCC Costs:",{"$f":"ERR!F45*10^6","v":82080289.748011455},"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":4,"n_rows":56,"n_cols":30,"rows_kept":56,"cut":false,"hidden":false,"merged":[[52,2,52,10]]}
[null,"Tanzania:  Lower Ruvu Plant Expansion 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":56.846600237568786},0,4.4746517900000002,20.425059894551822,16.759023503222007,15.187865049794949,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"NPV(0.1,G11:Z11)","v":39.92081695129918},{"$f":"AC11/AC$24","v":0.2811331235857063}]
[null,null,null,"Capital costs",null,{"$f":"'ERR & Sensitivity Analysis'!G10*capex/10^6","v":44.703269178595157},{"$f":"$F12*G$9","v":0},0,17.434274979652113,14.30504613715045,12.963948061792598,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30.918759609090987,0.21773821605162416]
[null,null,null,"Supervision",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_spvs/10^6","v":4.2276652400000003},0,0,1.6487894436000001,1.3528528768000001,1.2260229196000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9240404038695811,2.059187849871677E-2]
[null,null,null,"Feasibility studies",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_feas/10^6","v":4.4746517900000002},0,{"$f":"F14","v":4.4746517900000002},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6980593305785123,2.6042727834931473E-2]
[null,null,null,"Technical assistance",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_TA/10^6","v":0.32351770000000002},{"$f":"$F15*G$9","v":0},0,0.126171903,0.103525664,9.3820133000000014E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22375916078136734,1.5757721561190361E-3]
[null,null,null,"Administrative costs",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_admin/10^6","v":1.7555846962394044},0,0,0.6846780315333677,0.56178710279660937,0.50911956190942731,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2142400811799192,8.55100503633263E-3]
[null,null,null,"M&E costs",null,{"$f":"'ERR & Sensitivity Analysis'!G10*cost_ME/10^6","v":1.3619116327342193},0,0,0.53114553676634557,0.4358117224749502,0.39495437349292367,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94195836579881309,6.6335240079822451E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Increased water production and delivery costs",null,null,null,{"$f":"Commercial!G36/10^6","v":0},{"$f":"Commercial!H36/10^6","v":0},{"$f":"Commercial!I36/10^6","v":0},{"$f":"Commercial!J36/10^6","v":0},{"$f":"Commercial!K36/10^6","v":0},{"$f":"Commercial!L36/10^6","v":0},{"$f":"Commercial!M36/10^6","v":0},{"$f":"Commercial!N36/10^6","v":16.438140000000001},{"$f":"Commercial!O36/10^6","v":16.438140000000001},{"$f":"Commercial!P36/10^6","v":16.438140000000001},{"$f":"Commercial!Q36/10^6","v":16.438140000000001},{"$f":"Commercial!R36/10^6","v":16.438140000000001},{"$f":"Commercial!S36/10^6","v":16.438140000000001},{"$f":"Commercial!T36/10^6","v":16.438140000000001},{"$f":"Commercial!U36/10^6","v":16.438140000000001},{"$f":"Commercial!V36/10^6","v":16.438140000000001},{"$f":"Commercial!W36/10^6","v":16.438140000000001},{"$f":"Commercial!X36/10^6","v":16.438140000000001},{"$f":"Commercial!Y36/10^6","v":16.438140000000001},{"$f":"Commercial!Z36/10^6","v":16.438140000000001},null,null,{"$f":"NPV(0.1,G19:Z19)","v":59.919402220441064},0.42196853662015776]
[]
[null,null,"New transmission main (not financed by MCC)",null,null,{"$f":"'ERR & Sensitivity Analysis'!G10*Assumptions!N34*10^3/Tsh_USD","v":74.462434047678016},0,0,0,0,{"$f":"F21/3","v":24.820811349226005},{"$f":"F21/3","v":24.820811349226005},{"$f":"F21/3","v":24.820811349226005},0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"NPV(0.1,G21:Z21)","v":42.159472796712272},{"$f":"AC21/AC$24","v":0.29689833979413616}]
[null,null,null,"Total investment costs",null,{"$f":"F11+F21","v":131.30903428524681},{"$f":"G11+G21","v":0},4.4746517900000002,20.425059894551822,16.759023503222007,40.008676399020956,24.820811349226005,24.820811349226005,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Total costs",null,null,null,{"$f":"SUM(G11,G19,G21)","v":0},4.4746517900000002,20.425059894551822,16.759023503222007,40.008676399020956,24.820811349226005,24.820811349226005,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,16.438140000000001,null,null,{"$f":"NPV(0.1,G24:Z24)","v":141.99969196845248},{"$f":"AC24/AC$24","v":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!G61/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!H61/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!I61/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!J61/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!K61/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!L61/10^6","v":16.056292945000344},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!M61/10^6","v":16.955445349920367},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!N61/10^6","v":17.904950289515899},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!O61/10^6","v":18.907627505728797},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!P61/10^6","v":19.966454646049609},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!Q61/10^6","v":21.084576106228386},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!R61/10^6","v":22.265312368177185},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!S61/10^6","v":23.512169860795098},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!T61/10^6","v":24.82885137299963},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!U61/10^6","v":26.219267049887613},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!V61/10^6","v":27.687546004681323},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!W61/10^6","v":29.238048580943481},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!X61/10^6","v":31.647365184510289},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!Y61/10^6","v":34.783796650570409},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Savings!Z61/10^6","v":38.095868278729917},null,null,{"$f":"NPV(0.1,G28:Z28)","v":104.79595412342478},{"$f":"AC28/$AC$37","v":0.60960519811435643}]
[]
[null,null,"Improved health outcomes",null,null,null,{"$f":"SUM(G31:G33)","v":0},{"$f":"SUM(H31:H33)","v":0},0,0,0,1.3408578696645201,2.8318918207314638,4.4857166440386438,4.7369167761048052,5.0021841155666724,5.2823064260384056,5.5781155858965628,5.8904900587067628,6.2203575019943429,6.5686975221060324,6.9365445833439727,7.3249910800112303,7.7351905804918673,8.1683612529993983,8.6257894831673738,null,null,{"$f":"NPV(0.1,G30:Z30)","v":23.753538148022109},{"$f":"AC30/$AC$37","v":0.13817594820108806}]
[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":9.3573509953661228E-4},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!M43/10^6","v":1.9762725302213294E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!N43/10^6","v":3.1304156878705853E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!O43/10^6","v":3.3057189663913359E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!P43/10^6","v":3.4908392285092557E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Q43/10^6","v":3.686326225305769E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!R43/10^6","v":3.8927604939228951E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!S43/10^6","v":4.1107550815825747E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!T43/10^6","v":4.3409573661512008E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!U43/10^6","v":4.5840509786556757E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!V43/10^6","v":4.840757833460386E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!W43/10^6","v":5.1118402721341662E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!X43/10^6","v":5.3981033273736902E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Y43/10^6","v":5.7003971137066078E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Z43/10^6","v":6.0196193520741723E-3},null,null,1.6576715464143407E-2,9.6427882155668599E-5]
[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":4.9395047228974727E-3},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!M48/10^6","v":1.0432233974759496E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!N48/10^6","v":1.6524658616019035E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!O48/10^6","v":1.7450039498516097E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!P48/10^6","v":1.8427241710432994E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Q48/10^6","v":1.9459167246217244E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!R48/10^6","v":2.0548880612005421E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!S48/10^6","v":2.1699617926277701E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!T48/10^6","v":2.2914796530149266E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!U48/10^6","v":2.4198025135837655E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!V48/10^6","v":2.5553114543444579E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!W48/10^6","v":2.6984088957877423E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!X48/10^6","v":2.8495197939518636E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Y48/10^6","v":3.0090929024131591E-2},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Z48/10^6","v":3.1776021049483009E-2},null,null,8.7504213923163085E-2,5.0901796840024406E-4]
[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":1.3349826298420862},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!M53/10^6","v":2.819483314226483},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!N53/10^6","v":4.4660615697347543},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!O53/10^6","v":4.716161017639898},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!P53/10^6","v":4.9802660346277303},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Q53/10^6","v":5.2591609325668829},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!R53/10^6","v":5.553673944790634},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!S53/10^6","v":5.8646796856989027},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!T53/10^6","v":6.1931017480980426},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!U53/10^6","v":6.5399154459915394},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!V53/10^6","v":6.9061507109670677},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!W53/10^6","v":7.2928951507812192},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!X53/10^6","v":7.701297279224975},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Y53/10^6","v":8.1325699268615601},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Health!Z53/10^6","v":8.5879938427658171},null,null,23.649457218634808,0.13757050235053217]
[]
[null,null,"Increased water available to enterprises",null,null,null,{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!G32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!H32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!I32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!J32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!K32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!L32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!M32/10^6","v":0},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!N32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!O32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!P32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!Q32/10^6","v":12.180169783281736},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!R32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!S32/10^6","v":12.180169783281736},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!T32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!U32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!V32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!W32/10^6","v":12.180169783281734},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!X32/10^6","v":11.408183900247769},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!Y32/10^6","v":10.000773675070313},{"$f":"'ERR & Sensitivity Analysis'!$G$11*Commercial!Z32/10^6","v":8.5145484772829185},null,null,43.358415416318586,0.25221885368455543]
[]
[null,null,"Total benefits",null,null,null,{"$f":"SUM(G28,G30,G35)","v":0},{"$f":"SUM(H28,H30,H35)","v":0},0,0,0,17.397150814664865,19.787337170651831,34.570836716836276,35.824714065115337,37.148808544898017,38.547052315548527,40.02359773735548,41.582829702783599,43.229378658275706,44.968134355275382,46.804260371307031,48.743209444236449,50.790739665249923,52.952931578640118,55.236206239180206,null,null,171.90790768776549,1]
[null,null,null,"Net local benefits",null,null,{"$f":"G37-G19","v":0},0,0,0,0,17.397150814664865,19.787337170651831,18.132696716836275,19.386574065115337,20.710668544898017,22.108912315548526,23.58545773735548,25.144689702783598,26.791238658275706,28.529994355275381,30.36612037130703,32.305069444236452,34.352599665249926,36.514791578640114,38.798066239180201,null,null,111.98850546732442]
[]
[null,null,"Net benefits",null,null,null,{"$f":"G37-G24","v":0},-4.4746517900000002,-20.425059894551822,-16.759023503222007,-40.008676399020956,-7.4236605345611402,-5.0334741785741741,18.132696716836275,19.386574065115337,20.710668544898017,22.108912315548526,23.58545773735548,25.144689702783598,26.791238658275706,28.529994355275381,30.36612037130703,32.305069444236452,34.352599665249926,36.514791578640114,38.798066239180201]
[]
[null,null,"Present value of benefits",null,null,{"$f":"NPV(0.1,G37:Z37)","v":171.90790768776549}]
[null,null,null,"Present value of local benefits",null,{"$f":"NPV(0.1,G38:Z38)","v":111.98850546732442}]
[null,null,"Present value of costs",null,null,{"$f":"NPV(0.1,G24:Z24)","v":141.99969196845248}]
[null,null,null,"Present value of investment costs",null,{"$f":"NPV(0.1,G22:Z22)","v":82.080289748011452}]
[null,null,"Total Net Present Value",null,null,{"$f":"NPV(0.1,G40:Z40)","v":29.908215719312963}]
[]
[null,null,null,null,"ERR (20 years):",{"$f":"IRR(G40:Z40)","v":0.14914692980684396}]
[]
[]
[]
[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":5,"n_rows":108,"n_cols":14,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Lower Ruvu Plant Expansion 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":"A75","v":8},"Volume treated (liters/capita/day)",{"$f":"'ERR & Sensitivity Analysis'!G13","v":3}]
[{"$f":"A68","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.13,114.5,{"$f":"M27/1000","v":1.077},{"$f":"M7/Table4[[#This Row],[Liters / capita / day (lpcpd)]]","v":2.6200873362445413E-2},{"$f":"SUMPRODUCT(C16:G16,C$21:G$21)","v":22.788570939949462},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":1.6740804613087195},null,null,{"$f":"A77","v":9},"Average annual temperature in Dar es Salaam (Co)",26.1]
[null,"Other piped",0.39,5,{"$f":"M27/1000","v":1.077},{"$f":"M7/Table4[[#This Row],[Liters / capita / day (lpcpd)]]","v":0.6},{"$f":"SUMPRODUCT(C17:G17,C$21:G$21)","v":11.441865201999642},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":7.9421191211997852},null,null,{"$f":"A79","v":10},"Energy required to boil 1 liter water in Dar es Salaam (kcal)",{"$f":"100-M9","v":73.900000000000006}]
[null,"Vendors",{"$f":"0.19+0.05","v":0.24},{"$f":"(10*19/24)+(50.5*5/24)","v":18.4375},{"$f":"1200/1000","v":1.2},0.11,{"$f":"SUMPRODUCT(C18:G18,C$21:G$21)","v":14.114120857726963},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":2.752553294349966},null,null,{"$f":"A81","v":11},"Energy required to boil 1 liter water in Dar es Salaam (kWh)",{"$f":"M10*0.001163","v":8.59457E-2}]
[{"$f":"A69","v":2},"Non‐Tap",0.24,4,0,{"$f":"IF(D12>M$7,$M$7/D12,1)","v":0.75},{"$f":"SUMPRODUCT(C19:G19,C$21:G$21)","v":8.9735690505749997},{"$f":"Table4[[#This Row],[Cost of water (Tsh/liter)]]+(Table4[[#This Row],[% of water treated]]*Table4[[#This Row],[Treatment cost (Tsh/liter)]])","v":6.7301767879312493},null,null,{"$f":"A83","v":12},"Cost of energy (Tsh/kWh)",{"$f":"'ERR & Sensitivity Analysis'!G14*Tsh_USD","v":348.03249999999997}]
[{"$f":"A70","v":3},"Total",{"$f":"SUM(C9:C12)","v":1},{"$f":"SUMPRODUCT(C9:C12,D9:D12)","v":22.220000000000002},null,null,null,null,null,null,null,"Treatment cost (Tsh/liter)",{"$f":"M11*M12","v":29.911896835249998}]
[]
[{"$f":"A71","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.76,0.01,0.01,0.02,0.2,{"$f":"SUM(Table5[[#This Row],[Boil]:[None]])","v":1},{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.8},null,{"$f":"A84","v":13},"Price of bleach (Tsh/liter)",10000]
[null,"Other piped",0.38,0.02,0.01,7.0000000000000007E-2,0.52,{"$f":"SUM(Table5[[#This Row],[Boil]:[None]])","v":1},{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.48000000000000004},null,{"$f":"A85","v":14},"Dose (mL/liter)",{"$f":"0.75/3.785","v":0.19815059445178335}]
[null,"Vendors",0.47,0.01,0.01,0.05,0.46,{"$f":"SUM(Table5[[#This Row],[Boil]:[None]])","v":1},{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.54},null,null,"Treatment cost (Tsh/liter)",{"$f":"M16/1000*M17","v":1.9815059445178336}]
[null,"Non‐Tap",0.3,0,0,0.03,0.67,{"$f":"SUM(Table5[[#This Row],[Boil]:[None]])","v":1},{"$f":"SUM(Table5[[#This Row],[Boil]:[Let settle]])","v":0.32999999999999996}]
[null,"Total",0.39,0.04,0.06,0.16,0.35,{"$f":"SUM(Table5[[#This Row],[Boil]:[None]])","v":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":29.911896835249998},{"$f":"M18","v":1.9815059445178336},{"$f":"M23","v":3.5714285714285716},0,0,null,null,null,{"$f":"A87","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.77},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C16:G16)","v":0.23},null,null,"DAWASCO Service"]
[null,"Other piped","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C17:G17)","v":0.4},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C17:G17)","v":0.6},null,null,"Column1","w/o Project","w/Project"]
[null,"Vendors","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C18:G18)","v":0.48},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C18:G18)","v":0.52},null,{"$f":"A89","v":16},"DAWASCO domestic tariff (Tsh/m3)",1077,"-"]
[null,"Non‐Tap","yes","yes","no","no","no",{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"yes\",C19:G19)","v":0.3},{"$f":"SUMIF(Table6[[#This Row],[Boil]:[None]],\"no\",C19:G19)","v":0.70000000000000007},null,{"$f":"K27","v":16},"DAWASCO commercial tariff (Tsh/m3)",{"$f":"'ERR & Sensitivity Analysis'!G15","v":1077},"-"]
[null,"Total",null,null,null,null,null,{"$f":"SUMPRODUCT(C9:C12,Table6[Clean %])","v":0.44330000000000008},{"$f":"SUMPRODUCT(C9:C12,Table6[Unclean %])","v":0.55669999999999997},null,{"$f":"A91","v":17},"Production capacity (m3/day)",180000,270000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A91","v":17},"Non-revenue water (% of production)",0,0.55500000000000005]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A92","v":18},"Proportion of NRW that is technical loss (%)",0,{"$f":"'ERR & Sensitivity Analysis'!G16","v":0.8}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A93","v":19},"Total cost per unit delivered (US$/m3)",0,{"$f":"'ERR & Sensitivity Analysis'!G19","v":0.9}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A94","v":20},"Year in which increased capacity is achieved",0,2015]
[null,"Column1","DAWASCO","Other","Total",null,null,null,null,null,{"$f":"A95","v":21},"Total cost of new Lower Ruvu transmission main (Billions Tsh)","-",120.256830987]
[null,"Avg cost (Tsh/liter) of clean water, without project",{"$f":"(C9/SUM(C9:C10)*H9)+(C10/SUM(C9:C10)*H10)","v":6.375109456227019},{"$f":"(C11/SUM(C11:C12)*H11)+(C12/SUM(C11:C12)*H12)","v":4.7413650411406074},{"$f":"SUMPRODUCT(C9:C12,H9:H12)","v":5.5909121369855415}]
[null,"Avg volume of water, without project",{"$f":"(C9/SUM(C9:C10)*D9)+(C10/SUM(C9:C10)*D10)","v":32.375},{"$f":"(C12/SUM(C12:C13)*H12)+(C13/SUM(C12:C13)*H13)","v":1.3026148621802418},{"$f":"lpcpd_wop","v":22.220000000000002},null,null,null,null,null,null,"Health","w/o Project","w/Project"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A96","v":22},"Prevalence of diarrheal disease, age < 5",7.0000000000000007E-2,{"$f":"M37*(1-$N$40)","v":5.8100000000000006E-2}]
[null,"With Project",null,null,null,null,null,null,null,null,{"$f":"K37","v":22},"Prevalence of diarrheal disease, age 5-18",0.02,{"$f":"M38*(1-$N$40)","v":1.66E-2}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A97","v":23},"Prevalence of diarrheal disease, age> 18",0.02,{"$f":"M39*(1-$N$40)","v":1.66E-2}]
[{"$f":"A73","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,24,"Anticipated % reduction in cases of disease","-",{"$f":"'ERR & Sensitivity Analysis'!G17","v":0.17}]
["%","Own tap",0.13,{"$f":"D9","v":114.5},{"$f":"E9","v":1.077},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":1.077},null,null,25,"Diarrheal treatment costs (Tsh)",589,"-"]
[null,"Other piped",0.39,5,{"$f":"E10","v":1.077},0,{"$f":"SUMPRODUCT(C50:G50,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":1.077},null,null,26,"Average work days missed per case of disease",0.13800000000000001,"-"]
[null,"Vendors",{"$f":"0.19+0.05","v":0.24},{"$f":"D11","v":18.4375},{"$f":"E11","v":1.2},0.11,{"$f":"SUMPRODUCT(C51:G51,C$21:G$21)","v":14.114120857726963},{"$f":"Table7[[#This Row],[Cost of water (Tsh/liter)]]+(Table7[[#This Row],[% of water treated]]*Table7[[#This Row],[Treatment cost (Tsh/liter)]])","v":2.752553294349966},null,null,27,"Average daily wage, Dar es Salaam Region (Tsh)",26485.74,"-"]
[null,"Non‐Tap",0.26,{"$f":"D12","v":4},{"$f":"E12","v":0},0.11,{"$f":"SUMPRODUCT(C52:G52,C$21:G$21)","v":8.9735690505749997},{"$f":"Table7[[#This Row],[Cost of water (Tsh/liter)]]+(Table7[[#This Row],[% of water treated]]*Table7[[#This Row],[Treatment cost (Tsh/liter)]])","v":0.98709259556325002},null,null,28,"Probability of employment",0.85065719901795678,"-"]
[null,"Total",{"$f":"SUM(C41:C44)","v":1.02},{"$f":"SUMPRODUCT(C41:C44,D41:D44)","v":22.3}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A103","v":29},"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":"M46/(1-M46)","v":0.73913043478260876},"-"]
[{"$f":"A74","v":7},"Primary drinking water source","Boil","Disinfect","Filter","Let settle","None","Total",null,null,{"$f":"A104","v":30},"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":"M47*M48","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":"M49/(1+M49)","v":0.62851097507793197},"-"]
[null,"Vendors",{"$f":"C18","v":0.47},{"$f":"D18","v":0.01},0.01,0.05,{"$f":"G18","v":0.46},1,null,null,{"$f":"A105","v":31},"Return to an additional year of schooling, Tanzania",0.16600000000000001,"-"]
[null,"Non‐Tap",{"$f":"C19","v":0.3},{"$f":"D19","v":0},0,0.03,{"$f":"G19","v":0.67},1,null,null,{"$f":"A106","v":32},"Fewer years of schooling due to stunting",0.85,"-"]
[null,"Total",{"$f":"C20","v":0.39},0.04,0.06,0.16,{"$f":"G20","v":0.35},1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A107","v":33},"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!A108","v":34},"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\",C49:G49)","v":1},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C49:G49)","v":0}]
[null,"Other piped","yes","yes","yes","yes","yes",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C50:G50)","v":1},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C50:G50)","v":0}]
[null,"Vendors","yes","yes","no","no","no",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C51:G51)","v":0.48},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C51:G51)","v":0.52}]
[null,"Non‐Tap","yes","yes","no","no","no",{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"yes\",C52:G52)","v":0.3},{"$f":"SUMIF(Table9[[#This Row],[Boil]:[None]],\"no\",C52:G52)","v":0.70000000000000007}]
[null,"Total",null,null,null,null,null,{"$f":"SUMPRODUCT(C41:C44,Table9[Clean %])","v":0.71319999999999995},{"$f":"SUMPRODUCT(C41:C44,Table9[Unclean %])","v":0.30680000000000002}]
[]
[null,"Column1","DAWASCO","Other","Total"]
[null,"Avg cost (Tsh/liter) of clean water, with project",{"$f":"(C41/SUM(C41:C42)*H41)+(C42/SUM(C41:C42)*H42)","v":1.077},{"$f":"(C43/SUM(C43:C44)*H43)+(C44/SUM(C43:C44)*H44)","v":1.8345137309808737},{"$f":"SUMPRODUCT(C41:C44,H41:H44)","v":1.477296865490437}]
[]
[]
[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, DAWASCO also charges domestic customers a flat 1500/month service charge and commercial customers a 2000/month service charge.  DAWASCO Tariff Rates found at:"]
[null,"http://DAWASCO.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. 105."]
[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,"World Bank (2014). Tanzania - Water Sector Support Project : P087154 - Implementation Status Results Report : Sequence 15 (English).  http://www.wds.worldbank.org/external/default/WDSContentServer/WDSP/AFR/2014/08/02/090224b0825dbc80/1_0/Rendered/PDF/Tanzania000Wat0Report000Sequence015.pdf.  Date based on estimated completion date listed in document."]
[21,"dgMarket (2012). ICB Contract Award Notice: Cosntruction of the Lower Ruvu Transmission Main. Bid/Contract Reference No. ICB NO. CW - W116. Contract signed 9/13/2012.  http://www.dgmarket.com/tenders/np-notice.do?noticeId=8353127.  The Lower Ruvu tranmission main is not funded by MCC, but its construction is essential for the benefits of MCC's project to be realized. Without additional transmission capacity, the additional volume of clean water produced from the MCC-financed Lower Ruvu Treatment Plant will not reach customers."]
[22,"Impact Evaluation Baseline Report (2014), Table 87."]
[23,"The baseline report did not report data on adult diarrhea prevalence, so it is assumed to be equal to that of older children."]
[24,"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."]
[25,"Impact Evaluation Baseline Report (2014), Table 89."]
[26,"Impact Evaluation Baseline Report (2014), Table 68."]
[27,"Author's estimates using 2011 National Panel Survey data and updated to 2014 prices."]
[28,"Impact Evaluation Baseline Report (2014), Table 28.  Weighted average of males and females employed in paid or home labor."]
[29,"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)."]
[30,"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."]
[31,"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."]
[32,"Alderman et al (2006).  Long term consequences of early childhood malnutrition. Oxf. Econ. Pap. (2006) 58 (3): 450-474. doi: 10.1093/oep/gpl008."]
[33,"Assumption"]
[34,"Calculated using data from IMF World Economic Outlook Database, April 2014."]

{"sheet":"Costs","index":6,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Lower Ruvu Plant Expansion 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",37831487.422999993,6871781.7555951597,{"$f":"SUM(C6:D6)","v":44703269.178595155}]
[null,"Supervision",3081510,1146155.24,4227665.24]
[null,"Feasibility studies",4474651.79,0,4474651.79]
[null,"Technical assistance",323517.7,0,323517.7]
[null,"Administrative costs",1755584.6962394044,0,1755584.6962394044]
[null,"Monitoring and evaluation (M&E) costs",1361911.6327342193,0,1361911.6327342193]
[null,"Total w/o Administrative, M&E",{"$f":"SUM(C6:C9)","v":45711166.912999995},{"$f":"SUM(D6:D9)","v":8017936.9955951599},{"$f":"SUM(E6:E9)","v":53729103.90859516}]
[null,"Total",{"$f":"SUM(C6:C11)","v":48828663.241973616},{"$f":"SUM(D6:D11)","v":8017936.9955951599},{"$f":"SUM(E6:E11)","v":56846600.237568781}]
[]
[]
[null,"DAWASCO operation and maintenance costs","2012-13"]
[{"$f":"A28","v":2},"Water production (m3)",{"$f":"257845*365*(1-(nrw*techloss))","v":52327064.299999997}]
[{"$f":"A29","v":3},"Total O&M costs (Tsh)",55261703945]
[null,"O&M costs/m3",{"$f":"C18/C17","v":1056.082634947285}]
[]
[{"$f":"A29","v":3},"Total costs, including depreciation & amortization",55725735945]
[]
[{"$f":"A30","v":4},"Total cost per unit delivered (US$/m3)",{"$f":"Assumptions!N32","v":0.9}]
[]
[]
[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":7,"n_rows":61,"n_cols":26,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Lower Ruvu Plant Expansion 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,"Population of area served by DAWASCO",null,null,{"$f":"Beneficiaries!L15","v":2300027.2719641686},{"$f":"Beneficiaries!M15","v":2428828.7991941622},{"$f":"Beneficiaries!N15","v":2564843.2119490355},{"$f":"Beneficiaries!O15","v":2708474.4318181816},{"$f":"Beneficiaries!P15","v":2860149},{"$f":"Beneficiaries!Q15","v":3020317.344},{"$f":"Beneficiaries!R15","v":3189455.1152640004},{"$f":"Beneficiaries!S15","v":3368064.6017187848},{"$f":"Beneficiaries!T15","v":3556676.219415037},{"$f":"Beneficiaries!U15","v":3755850.087702279},{"$f":"Beneficiaries!V15","v":3966177.6926136068},{"$f":"Beneficiaries!W15","v":4188283.6433999692},{"$f":"Beneficiaries!X15","v":4422827.5274303677},{"$f":"Beneficiaries!Y15","v":4670505.8689664686},{"$f":"Beneficiaries!Z15","v":4932054.1976285912},{"$f":"Beneficiaries!AA15","v":5208249.2326957928},{"$f":"Beneficiaries!AB15","v":5499911.1897267578},{"$f":"Beneficiaries!AC15","v":5807906.2163514569},{"$f":"Beneficiaries!AD15","v":6133148.964467139},{"$f":"Beneficiaries!AE15","v":6476605.306477299},{"$f":"Beneficiaries!AF15","v":6839295.2036400279}]
[null,null,"Households in area served by DAWASCO",null,null,{"$f":"Beneficiaries!L31","v":577093.52836680901},{"$f":"Beneficiaries!M31","v":609410.76595535036},{"$f":"Beneficiaries!N31","v":643537.76884885004},{"$f":"Beneficiaries!O31","v":679575.88390438573},{"$f":"Beneficiaries!P31","v":717632.13340303139},{"$f":"Beneficiaries!Q31","v":757819.53287360107},{"$f":"Beneficiaries!R31","v":800257.42671452288},{"$f":"Beneficiaries!S31","v":845071.84261053626},{"$f":"Beneficiaries!T31","v":892395.86579672631},{"$f":"Beneficiaries!U31","v":942370.03428134299},{"$f":"Beneficiaries!V31","v":995142.75620109821},{"$f":"Beneficiaries!W31","v":1050870.7505483599},{"$f":"Beneficiaries!X31","v":1109719.5125790681},{"$f":"Beneficiaries!Y31","v":1171863.8052834959},{"$f":"Beneficiaries!Z31","v":1237488.1783793718},{"$f":"Beneficiaries!AA31","v":1306787.5163686168},{"$f":"Beneficiaries!AB31","v":1379967.6172852595},{"$f":"Beneficiaries!AC31","v":1457245.803853234},{"$f":"Beneficiaries!AD31","v":1538851.5688690154},{"$f":"Beneficiaries!AE31","v":1625027.2567256803},{"$f":"Beneficiaries!AF31","v":1716028.7831023184}]
[]
[null,null,"Without Project"]
[]
[null,null,"Water produced by DAWASCO (m3)",null,null,null,{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997},{"$f":"Costs!$C17","v":52327064.299999997}]
[null,null,null,"Lower Ruvu",null,null,{"$f":"cap_wop*365*(1-(nrw*techloss))","v":36529199.999999993},36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993]
[null,null,null,"Other sources",null,null,{"$f":"G13-G14","v":15797864.300000004},{"$f":"H13-H14","v":15797864.300000004},15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004]
[null,null,null,"Capacity?",null,null,{"$f":"IF(G22>G14,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","Yes","Yes","Yes"]
[]
[null,null,"Households using DAWASCO sources",null,null,"% of households",{"$f":"SUM(G19:G20)","v":316893.59829678218},{"$f":"SUM(H19:H20)","v":334639.63980140205},353379.45963028062,373168.7093695763,394066.15709427255,416133.86189155187,439437.35815747885,464045.85021429771,490032.41782629839,517474.2332245711,546452.79028514714,577054.14654111536,609369.17874741787,643493.85275727336,679529.50851168076,717583.16098833503,757767.81800368172,800202.81581188808,845014.1734973538,892334.96721320553]
[null,null,null,"Own tap",null,{"$f":"Assumptions!C9","v":0.13},{"$f":"$F19*G$9","v":79223.399574195544},{"$f":"$F19*H$9","v":83659.909950350513},88344.864907570154,93292.17734239409,98516.539273568138,104033.46547288798,109859.33953936971,116011.46255357443,122508.1044565746,129368.55830614278,136613.19757128679,144263.53663527884,152342.29468685447,160873.46318931834,169882.37712792019,179395.79024708376,189441.95450092043,200050.70395297202,211253.54337433845,223083.74180330141]
[null,null,null,"Other piped",null,{"$f":"Assumptions!C10","v":0.39},{"$f":"$F20*G$9","v":237670.19872258665},250979.72985105152,265034.59472271043,279876.53202718223,295549.61782070441,312100.39641866391,329578.01861810917,348034.3876607233,367524.31336972379,388105.6749184283,409839.59271386039,432790.60990583658,457026.8840605634,482620.38956795499,509647.1313837606,538187.37074125127,568325.86350276135,600152.111858916,633760.63012301538,669251.22540990415]
[]
[null,null,"Volume of household water demanded, DAWASCO (m3)",null,null,"Liters/capita/day",{"$f":"SUM(G23:G24)","v":14924606.484568307},{"$f":"SUM(H23:H24)","v":15760384.447704135},16642965.976775568,17574972.071474999,18559170.5074776,19598484.055896349,20695999.163026549,21854975.116156034,23078853.722660773,24371269.531129777,25736060.624873046,27177280.019865938,28699207.700978432,30306363.332233228,32003519.67883829,33795716.780853242,35688276.920581028,37686820.428133562,39797282.372109041,42025930.184947148]
[null,null,null,"Own tap",null,{"$f":"tap_lpcpd_wop","v":114.5},{"$f":"$F23*$F19*G$8*365/1000","v":13195887.586741863},{"$f":"$F23*$F19*H$8*365/1000","v":13934857.291599408},14715209.299928976,15539261.020725001,16409459.6378856,17328389.377607197,18298779.182753202,19323510.81698738,20405627.422738675,21548342.558412042,22755049.741683118,24029332.527217373,25374975.148741547,26795973.757071078,28296548.287467059,29881154.99156522,31554499.671092875,33321551.652674079,35187558.545223825,37158061.82375636]
[null,null,null,"Other piped",null,{"$f":"pipe_lpcpd_wop","v":5},{"$f":"$F24*$F20*G$8*365/1000","v":1728718.8978264451},1825527.1561047263,1927756.6768465911,2035711.0507500002,2149710.8695920003,2270094.6782891527,2397219.9802733455,2531464.2991686524,2673226.299922097,2822926.972717735,2981010.8831899283,3147947.4926485643,3324232.5522368839,3510389.57516215,3706971.3913712311,3914561.7892880202,4133777.2494881502,4365268.7754594861,4609723.8268852178,4867868.3611907903]
[]
[null,null,"Volume of household water consumed DAWASCO (m3)",null,null,"% of consumption",{"$f":"IF(G$16=\"No\",G22,G14)","v":14924606.484568307},15760384.447704135,16642965.976775568,17574972.071474999,18559170.5074776,19598484.055896349,20695999.163026549,21854975.116156034,23078853.722660773,24371269.531129777,25736060.624873046,27177280.019865938,28699207.700978432,30306363.332233228,32003519.67883829,33795716.780853242,35688276.920581028,36529199.999999993,36529199.999999993,36529199.999999993]
[null,null,null,"Own tap",null,{"$f":"F23/SUM(F23:F24)","v":0.95815899581589958},{"$f":"IF(G$16=\"No\",G23,G$14*$F27)","v":13195887.586741863},13934857.291599408,14715209.299928976,15539261.020725001,16409459.6378856,17328389.377607197,18298779.182753202,19323510.81698738,20405627.422738675,21548342.558412042,22755049.741683118,24029332.527217373,25374975.148741547,26795973.757071078,28296548.287467059,29881154.99156522,31554499.671092875,35000781.589958154,35000781.589958154,35000781.589958154]
[null,null,null,"Other piped",null,{"$f":"F24/SUM(F23:F24)","v":4.1841004184100417E-2},{"$f":"IF(G$16=\"No\",G24,G$14*$F28)","v":1728718.8978264451},1825527.1561047263,1927756.6768465911,2035711.0507500002,2149710.8695920003,2270094.6782891527,2397219.9802733455,2531464.2991686524,2673226.299922097,2822926.972717735,2981010.8831899283,3147947.4926485643,3324232.5522368839,3510389.57516215,3706971.3913712311,3914561.7892880202,4133777.2494881502,1528418.4100418405,1528418.4100418405,1528418.4100418405]
[]
[null,null,"Total household expenditures on water, DAWASCO sources (US$)",null,null,"Cost/m3",{"$f":"SUM(G31:G32)","v":22179980.80012238},23422059.724929236,24733695.069525275,26118781.993418694,27581433.785050139,29125994.077012956,30757049.745325685,32479444.531063914,34298293.424803503,36218997.856592499,38247261.736561678,40389108.39380914,42650898.463862449,45039348.777838752,47561552.309397727,50224999.238724008,53037599.196092561,56007704.751073748,59144136.217133865,62456207.845293373]
[null,null,null,"Own tap",null,{"$f":"Assumptions!H9*1000/Tsh_USD","v":1.036582328983727},{"$f":"G23*$F31","v":13678623.887672333},{"$f":"H23*$F31","v":14444626.825381985},15253525.927603377,16107723.379549168,17009755.888803922,17962302.218576945,18968191.142817255,20030409.84681502,21152112.798236664,22336631.114937916,23587482.457374442,24908381.474987414,26303250.837586708,27776232.884491567,29331701.926023096,30974277.233880397,32708836.7589777,34540531.617480457,36474801.388059355,38517390.265790686]
[null,null,null,"Other piped",null,{"$f":"Assumptions!H10*1000/Tsh_USD","v":4.9177208180803627},{"$f":"G24*$F32","v":8501356.9124500491},8977432.8995472528,9480169.1419218984,10011058.613869525,10571677.896246219,11163691.858436009,11788858.602508428,12449034.684248896,13146180.626566837,13882366.74165458,14659779.279187238,15480726.918821724,16347647.626275741,17263115.893347185,18229850.383374631,19250722.004843611,20328762.437114857,21467173.133593287,22669334.829074513,23938817.579502687]
[]
[null,null,"With Project"]
[]
[null,null,"Water produced by DAWASCO (m3)",null,null,null,{"$f":"SUM(G37:G38)","v":52327064.299999997},{"$f":"SUM(H37:H38)","v":52327064.299999997},52327064.299999997,52327064.299999997,52327064.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997]
[null,null,null,"Lower Ruvu",null,null,{"$f":"IF(G7=1,cap_wp*365*(1-(nrw*techloss)),G14)","v":36529199.999999993},36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993]
[null,null,null,"Other sources",null,null,{"$f":"G15","v":15797864.300000004},{"$f":"H15","v":15797864.300000004},15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004]
[null,null,null,"Capacity?",null,null,{"$f":"IF(G45>G37,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[null,null,"Households using DAWASCO sources",null,null,"% of households",{"$f":"SUM(G42:G43)","v":316893.59829678218},334639.63980140205,353379.45963028062,373168.7093695763,394066.15709427255,416133.86189155187,439437.35815747885,464045.85021429771,490032.41782629839,517474.2332245711,546452.79028514714,577054.14654111536,609369.17874741787,643493.85275727336,679529.50851168076,717583.16098833503,757767.81800368172,800202.81581188808,845014.1734973538,892334.96721320553]
[null,null,null,"Own tap",null,{"$f":"Assumptions!C41","v":0.13},{"$f":"IF(G$7=0,G19,$F42*G$9)","v":79223.399574195544},{"$f":"IF(H$7=0,H19,$F42*H$9)","v":83659.909950350513},88344.864907570154,93292.17734239409,98516.539273568138,104033.46547288798,109859.33953936971,116011.46255357443,122508.1044565746,129368.55830614278,136613.19757128679,144263.53663527884,152342.29468685447,160873.46318931834,169882.37712792019,179395.79024708376,189441.95450092043,200050.70395297202,211253.54337433845,223083.74180330141]
[null,null,null,"Other piped",null,{"$f":"Assumptions!C42","v":0.39},{"$f":"IF(G$7=0,G20,$F43*G$9)","v":237670.19872258665},250979.72985105152,265034.59472271043,279876.53202718223,295549.61782070441,312100.39641866391,329578.01861810917,348034.3876607233,367524.31336972379,388105.6749184283,409839.59271386039,432790.60990583658,457026.8840605634,482620.38956795499,509647.1313837606,538187.37074125127,568325.86350276135,600152.111858916,633760.63012301538,669251.22540990415]
[]
[null,null,"Volume of household water demanded, DAWASCO (m3)",null,null,"Liters/capita/day",{"$f":"SUM(G46:G47)","v":14924606.484568307},{"$f":"SUM(H46:H47)","v":15760384.447704135},16642965.976775568,17574972.071474999,18559170.5074776,19598484.055896349,20695999.163026549,21854975.116156034,23078853.722660773,24371269.531129777,25736060.624873046,27177280.019865938,28699207.700978432,30306363.332233228,32003519.67883829,33795716.780853242,35688276.920581028,37686820.428133562,39797282.372109041,42025930.184947148]
[null,null,null,"Own tap",null,{"$f":"tap_lpcpd_wp","v":114.5},{"$f":"$F46*$F42*G$8*365/1000","v":13195887.586741863},{"$f":"$F46*$F42*H$8*365/1000","v":13934857.291599408},14715209.299928976,{"$f":"$F46*$F42*J$8*365/1000","v":15539261.020725001},16409459.6378856,17328389.377607197,18298779.182753202,19323510.81698738,20405627.422738675,21548342.558412042,22755049.741683118,24029332.527217373,25374975.148741547,26795973.757071078,28296548.287467059,29881154.99156522,31554499.671092875,33321551.652674079,35187558.545223825,37158061.82375636]
[null,null,null,"Other piped",null,{"$f":"pipe_lpcpd_wp","v":5},{"$f":"$F47*$F43*G$8*365/1000","v":1728718.8978264451},{"$f":"$F47*$F43*H$8*365/1000","v":1825527.1561047263},1927756.6768465911,2035711.0507500002,2149710.8695920003,2270094.6782891527,2397219.9802733455,2531464.2991686524,2673226.299922097,2822926.972717735,2981010.8831899283,3147947.4926485643,3324232.5522368839,3510389.57516215,3706971.3913712311,3914561.7892880202,4133777.2494881502,4365268.7754594861,4609723.8268852178,4867868.3611907903]
[]
[null,null,"Volume of household water consumed DAWASCO (m3)",null,null,"% of consumption",{"$f":"IF(G$39=\"No\",G45,G37)","v":14924606.484568307},15760384.447704135,16642965.976775568,17574972.071474999,18559170.5074776,19598484.055896349,20695999.163026549,21854975.116156034,23078853.722660773,24371269.531129777,25736060.624873046,27177280.019865938,28699207.700978432,30306363.332233228,32003519.67883829,33795716.780853242,35688276.920581028,37686820.428133562,39797282.372109041,42025930.184947148]
[null,null,null,"Own tap",null,{"$f":"F46/SUM(F46:F47)","v":0.95815899581589958},{"$f":"IF(G$39=\"No\",G46,G$37*$F50)","v":13195887.586741863},13934857.291599408,14715209.299928976,15539261.020725001,16409459.6378856,17328389.377607197,18298779.182753202,19323510.81698738,20405627.422738675,21548342.558412042,22755049.741683118,24029332.527217373,25374975.148741547,26795973.757071078,28296548.287467059,29881154.99156522,31554499.671092875,33321551.652674079,35187558.545223825,37158061.82375636]
[null,null,null,"Other piped",null,{"$f":"F47/SUM(F46:F47)","v":4.1841004184100417E-2},{"$f":"IF(G$39=\"No\",G47,G$37*$F51)","v":1728718.8978264451},1825527.1561047263,1927756.6768465911,2035711.0507500002,2149710.8695920003,2270094.6782891527,2397219.9802733455,2531464.2991686524,2673226.299922097,2822926.972717735,2981010.8831899283,3147947.4926485643,3324232.5522368839,3510389.57516215,3706971.3913712311,3914561.7892880202,4133777.2494881502,4365268.7754594861,4609723.8268852178,4867868.3611907903]
[]
[null,null,"Additional volume of household water consumed DAWASCO (m3)",null,null,null,{"$f":"SUM(G54:G55)","v":0},{"$f":"SUM(H54:H55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1157620.4281335706,3268082.3721090481,5496730.1849471554]
[null,null,null,"Own tap",null,null,{"$f":"G50-G27","v":0},{"$f":"H50-H27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1679229.9372840747,186776.95526567101,2157280.2337982059]
[null,null,null,"Other piped",null,null,{"$f":"G51-G28","v":0},{"$f":"H51-H28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2836850.3654176453,3081305.4168433771,3339449.9511489496]
[]
[null,null,"Total household expenditures on same volume of water, DAWASCO sources (US$)",null,null,"Cost/m3",{"$f":"SUM(G58:G59)","v":22179980.80012238},{"$f":"SUM(H58:H59)","v":23422059.724929236},24733695.069525275,26118781.993418694,27581433.785050139,13069701.132012611,13801604.395405319,14574494.241548017,15390665.919074707,16252543.210542891,17162685.630333293,18123796.025631957,19138728.60306735,20210497.404839121,21342285.259510115,22537453.234042685,23799550.615149081,24360339.566563461,24360339.566563461,24360339.566563461]
[null,null,null,"Own tap",null,{"$f":"Assumptions!H41*1000/Tsh_USD","v":0.66687306501547983},{"$f":"IF(G$7=0,G31,(G$7*(G50-G54)*$F58)+((1-G$7)*G31))","v":13678623.887672333},{"$f":"IF(H$7=0,H31,(H$7*(H50-H54)*$F58)+((1-H$7)*H31))","v":14444626.825381985},15253525.927603377,16107723.379549168,17009755.888803922,11555836.136026595,12202962.959644085,12886328.885384154,13607963.302965667,14370009.247931745,15174729.765815923,16024514.632701615,16921887.452132907,17869513.149452351,18870205.885821685,19926937.415427703,21042845.910691656,23341078.496832773,23341078.496832773,23341078.496832773]
[null,null,null,"Other piped",null,{"$f":"Assumptions!H42*1000/Tsh_USD","v":0.66687306501547983},{"$f":"IF(G$7=0,G32,(G$7*(G51-G55)*$F59)+((1-G$7)*G32))","v":8501356.9124500491},{"$f":"IF(H$7=0,H32,(H$7*(H51-H55)*$F59)+((1-H$7)*H32))","v":8977432.8995472528},9480169.1419218984,10011058.613869525,10571677.896246219,1513864.9959860169,1598641.435761234,1688165.3561638629,1782702.6161090392,1882533.9626111458,1987955.86451737,2099281.3929303428,2216841.1509344419,2340984.2553867712,2472079.3736884305,2610515.818614983,2756704.7044574227,1019261.0697306888,1019261.0697306888,1019261.0697306888]
[]
[null,null,"Total change in water expenditures (US$)",null,null,null,{"$f":"G57-G30","v":0},{"$f":"H57-H30","v":0},{"$f":"I57-I30","v":0},{"$f":"J57-J30","v":0},{"$f":"K57-K30","v":0},{"$f":"L30-L57","v":16056292.945000345},16955445.349920366,17904950.289515898,18907627.505728796,19966454.646049608,21084576.106228385,22265312.368177183,23512169.860795099,24828851.372999631,26219267.049887612,27687546.004681323,29238048.58094348,31647365.184510287,34783796.650570408,38095868.278729916]

{"sheet":"Health","index":8,"n_rows":118,"n_cols":26,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Lower Ruvu Plant Expansion 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$54+K7<=1, 1/Assumptions!$N$54+K7, 1)","v":0.33333333333333331},{"$f":"IF(1/Assumptions!$N$54+L7<=1, 1/Assumptions!$N$54+L7, 1)","v":0.66666666666666663},{"$f":"IF(1/Assumptions!$N$54+M7<=1, 1/Assumptions!$N$54+M7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+N7<=1, 1/Assumptions!$N$54+N7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+O7<=1, 1/Assumptions!$N$54+O7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+P7<=1, 1/Assumptions!$N$54+P7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+Q7<=1, 1/Assumptions!$N$54+Q7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+R7<=1, 1/Assumptions!$N$54+R7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+S7<=1, 1/Assumptions!$N$54+S7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+T7<=1, 1/Assumptions!$N$54+T7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+U7<=1, 1/Assumptions!$N$54+U7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+V7<=1, 1/Assumptions!$N$54+V7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+W7<=1, 1/Assumptions!$N$54+W7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+X7<=1, 1/Assumptions!$N$54+X7, 1)","v":1},{"$f":"IF(1/Assumptions!$N$54+Y7<=1, 1/Assumptions!$N$54+Y7, 1)","v":1}]
[null,null,"Population using DAWASCO sources",null,null,{"$f":"Beneficiaries!L20","v":0},{"$f":"Beneficiaries!M20","v":1262990.9755809642},{"$f":"Beneficiaries!N20","v":1333718.4702134985},{"$f":"Beneficiaries!O20","v":1408406.7045454546},{"$f":"Beneficiaries!P20","v":1487277.48},{"$f":"Beneficiaries!Q20","v":1570565.0188799999},{"$f":"Beneficiaries!R20","v":1658516.6599372802},{"$f":"Beneficiaries!S20","v":1751393.5928937681},{"$f":"Beneficiaries!T20","v":1849471.6340958192},{"$f":"Beneficiaries!U20","v":1953042.0456051852},{"$f":"Beneficiaries!V20","v":2062412.4001590756},{"$f":"Beneficiaries!W20","v":2177907.4945679842},{"$f":"Beneficiaries!X20","v":2299870.3142637913},{"$f":"Beneficiaries!Y20","v":2428663.0518625635},{"$f":"Beneficiaries!Z20","v":2564668.1827668673},{"$f":"Beneficiaries!AA20","v":2708289.6010018126},{"$f":"Beneficiaries!AB20","v":2859953.8186579146},{"$f":"Beneficiaries!AC20","v":3020111.2325027576},{"$f":"Beneficiaries!AD20","v":3189237.4615229126},{"$f":"Beneficiaries!AE20","v":3367834.7593681957},{"$f":"Beneficiaries!AF20","v":3556433.5058928141}]
[null,null,null,"Age < 5",null,{"$f":"Beneficiaries!L21","v":0},{"$f":"Beneficiaries!M21","v":184396.68243482077},{"$f":"Beneficiaries!N21","v":194722.89665117077},{"$f":"Beneficiaries!O21","v":205627.37886363635},{"$f":"Beneficiaries!P21","v":217142.51207999999},{"$f":"Beneficiaries!Q21","v":229302.49275647997},{"$f":"Beneficiaries!R21","v":242143.43235084289},{"$f":"Beneficiaries!S21","v":255703.46456249012},{"$f":"Beneficiaries!T21","v":270022.85857798957},{"$f":"Beneficiaries!U21","v":285144.13865835703},{"$f":"Beneficiaries!V21","v":301112.21042322501},{"$f":"Beneficiaries!W21","v":317974.49420692568},{"$f":"Beneficiaries!X21","v":335781.06588251353},{"$f":"Beneficiaries!Y21","v":354584.80557193427},{"$f":"Beneficiaries!Z21","v":374441.5546839626},{"$f":"Beneficiaries!AA21","v":395410.28174626461},{"$f":"Beneficiaries!AB21","v":417553.25752405549},{"$f":"Beneficiaries!AC21","v":440936.2399454026},{"$f":"Beneficiaries!AD21","v":465628.66938234522},{"$f":"Beneficiaries!AE21","v":491703.87486775656},{"$f":"Beneficiaries!AF21","v":519239.29186035082}]
[null,null,null,"Age 5-18",null,{"$f":"Beneficiaries!L22","v":0},{"$f":"Beneficiaries!M22","v":337218.59048011748},{"$f":"Beneficiaries!N22","v":356102.83154700411},{"$f":"Beneficiaries!O22","v":376044.5901136364},{"$f":"Beneficiaries!P22","v":397103.08716},{"$f":"Beneficiaries!Q22","v":419340.86004096002},{"$f":"Beneficiaries!R22","v":442823.94820325385},{"$f":"Beneficiaries!S22","v":467622.0893026361},{"$f":"Beneficiaries!T22","v":493808.92630358378},{"$f":"Beneficiaries!U22","v":521462.22617658449},{"$f":"Beneficiaries!V22","v":550664.11084247322},{"$f":"Beneficiaries!W22","v":581501.30104965181},{"$f":"Beneficiaries!X22","v":614065.37390843232},{"$f":"Beneficiaries!Y22","v":648453.03484730446},{"$f":"Beneficiaries!Z22","v":684766.40479875356},{"$f":"Beneficiaries!AA22","v":723113.32346748398},{"$f":"Beneficiaries!AB22","v":763607.66958166321},{"$f":"Beneficiaries!AC22","v":806369.69907823636},{"$f":"Beneficiaries!AD22","v":851526.40222661768},{"$f":"Beneficiaries!AE22","v":899211.88075130829},{"$f":"Beneficiaries!AF22","v":949567.74607338139}]
[null,null,null,"Age > 18",null,{"$f":"Beneficiaries!L23","v":0},{"$f":"Beneficiaries!M23","v":741375.70266602596},{"$f":"Beneficiaries!N23","v":782892.7420153236},{"$f":"Beneficiaries!O23","v":826734.73556818184},{"$f":"Beneficiaries!P23","v":873031.88075999997},{"$f":"Beneficiaries!Q23","v":921921.66608255985},{"$f":"Beneficiaries!R23","v":973549.27938318346},{"$f":"Beneficiaries!S23","v":1028068.0390286418},{"$f":"Beneficiaries!T23","v":1085639.8492142458},{"$f":"Beneficiaries!U23","v":1146435.6807702438},{"$f":"Beneficiaries!V23","v":1210636.0788933772},{"$f":"Beneficiaries!W23","v":1278431.6993114066},{"$f":"Beneficiaries!X23","v":1350023.8744728453},{"$f":"Beneficiaries!Y23","v":1425625.2114433246},{"$f":"Beneficiaries!Z23","v":1505460.2232841509},{"$f":"Beneficiaries!AA23","v":1589765.9957880639},{"$f":"Beneficiaries!AB23","v":1678792.8915521959},{"$f":"Beneficiaries!AC23","v":1772805.2934791185},{"$f":"Beneficiaries!AD23","v":1872082.3899139496},{"$f":"Beneficiaries!AE23","v":1976919.0037491308},{"$f":"Beneficiaries!AF23","v":2087626.4679590818}]
[null,null,"Households using DAWASCO sources",null,null,null,{"$f":"Beneficiaries!M34","v":316893.59829678218},{"$f":"Beneficiaries!N34","v":334639.63980140205},{"$f":"Beneficiaries!O34","v":353379.45963028062},{"$f":"Beneficiaries!P34","v":373168.7093695763},{"$f":"Beneficiaries!Q34","v":394066.15709427255},{"$f":"Beneficiaries!R34","v":416133.86189155187},{"$f":"Beneficiaries!S34","v":439437.35815747885},{"$f":"Beneficiaries!T34","v":464045.85021429771},{"$f":"Beneficiaries!U34","v":490032.41782629839},{"$f":"Beneficiaries!V34","v":517474.2332245711},{"$f":"Beneficiaries!W34","v":546452.79028514714},{"$f":"Beneficiaries!X34","v":577054.14654111536},{"$f":"Beneficiaries!Y34","v":609369.17874741787},{"$f":"Beneficiaries!Z34","v":643493.85275727336},{"$f":"Beneficiaries!AA34","v":679529.50851168076},{"$f":"Beneficiaries!AB34","v":717583.16098833503},{"$f":"Beneficiaries!AC34","v":757767.81800368172},{"$f":"Beneficiaries!AD34","v":800202.81581188808},{"$f":"Beneficiaries!AE34","v":845014.1734973538},{"$f":"Beneficiaries!AF34","v":892334.96721320553}]
[]
[null,null,"Without Project"]
[]
[null,null,"Cases of diarrheal disease",null,null,{"$f":"SUM(F17:F19)","v":0},{"$f":"SUM(G17:G19)","v":34479.653633360322},36410.514236828509,38449.503034090914,40602.675203999999,42876.425015424,45277.50481628775,47813.045085999867,50490.575610815868,53318.04784502156,56303.858524342766,59456.874601705968,62786.459579401504,66302.501315847971,70015.441389535466,73936.30610734949,78076.739249361068,82449.036647325294,87066.182699575525,91941.888930751753,97090.634710873826]
[null,null,null,"Age < 5",null,{"$f":"F9*diarU5","v":0},{"$f":"G9*diarU5","v":12907.767770437455},13630.602765581954,14393.916520454546,15199.9758456,16051.1744929536,16950.040264559004,17899.242519374311,18901.600100459273,19960.089706084993,21077.854729625753,22258.214594484798,23504.67461177595,24820.9363900354,26210.908827877385,27678.719722238526,29228.728026683886,30865.536796178185,32594.006856764168,34419.271240742964,36346.750430224558]
[null,null,null,"Age 5-18",null,{"$f":"F10*diar518","v":0},6744.3718096023495,7122.056630940082,7520.8918022727285,7942.0617431999999,8386.8172008192014,8856.4789640650779,9352.4417860527228,9876.1785260716752,10429.24452353169,11013.282216849464,11630.026020993037,12281.307478168646,12969.06069694609,13695.328095975072,14462.266469349679,15272.153391633265,16127.393981564728,17030.528044532355,17984.237615026166,18991.354921467628]
[null,null,null,"Age > 18",null,{"$f":"F11*diar18","v":0},14827.514053320519,15657.854840306472,16534.694711363638,17460.637615200001,18438.433321651199,19470.985587663668,20561.360780572835,21712.796984284916,22928.713615404875,24212.721577867545,25568.633986228131,27000.477489456909,28512.504228866492,30109.204465683018,31795.319915761276,33575.857831043919,35456.105869582374,37441.647798278995,39538.380074982619,41752.529359181637]
[]
[null,null,"Treatment costs",null,null,{"$f":"F16*cost_treat/Tsh_USD","v":0},{"$f":"G16*cost_treat/Tsh_USD","v":12574.932501578469},13279.12872166687,14022.759930080218,14808.034486164706,15637.284417389928,16512.97234476377,17437.698796070541,18414.209928650493,19445.405684654921,20534.348402995598,21684.271913563352,22898.5911407229,24180.91224460338,25535.04333030117,26965.005756798051,28475.046079178741,30069.648659612754,31753.548984551075,33531.747727685928,35409.525600436333]
[]
[null,null,"Days spent treating for self or others",null,null,{"$f":"F16*sickdays","v":0},4758.1922014037245,5024.6509646823342,5306.0314187045469,5603.1691781520003,5916.9466521285121,6248.2956646477096,6598.2002218679827,6967.69943429259,7357.8906026129762,7769.9324763593022,8205.0486950354243,8664.5314219574084,9149.7451815870209,9662.1309117558958,10203.21024281423,10774.590016411828,11377.967057330892,12015.133212541423,12687.980672443742,13398.507590100589]
[null,null,"Opportunity cost of treatment",null,null,{"$f":"F23*wage/Tsh_USD*employ","v":0},66379.831762668124,70097.102341377555,74022.540072494725,78167.8023165544,82545.199246281452,87167.730404073227,92049.123306701353,97203.874211876624,102647.29116774173,108395.53947313526,114465.68968363084,120875.76830591419,127644.81133104535,134792.9207655839,142341.32432845666,150312.43849085027,158729.93504633787,167618.81140893284,177005.46484783303,186917.77087931166]
[]
[null,null,"Children stunted as a result of diarrhea",null,null,{"$f":"F17*stunt","v":0},8112.6737074771481,8566.9834350958699,9046.7345074612404,9553.3516398790689,10088.339331712297,10653.286334288188,11249.870369008328,11879.863109672795,12545.135443814472,13247.663028668083,13989.532158273496,14772.945959136814,15600.230932848473,16473.843865087991,17396.379121532922,18370.576352338769,19399.328628069739,20485.691031241648,21632.88972899118,22844.331553814682]
[]
[]
[null,null,"With Project"]
[]
[null,null,"Cases of diarrheal disease",null,null,{"$f":"SUM(F32:F34)","v":0},{"$f":"SUM(G32:G34)","v":34479.653633360322},36410.514236828509,38449.503034090914,40602.675203999999,42876.425015424,42711.779543364784,42394.233309586547,41907.177756977166,44253.979711367894,46732.202575204486,49349.205919415952,52112.761450903243,55031.076092153824,58112.81635331444,61367.134069100066,64803.693576969687,68432.700417279993,72264.931640647672,76311.767812523947,80585.22681002527]
[null,null,null,"Age < 5",null,{"$f":"F9*diarU5*(1-diarred*F$7)","v":0},12907.767770437455,13630.602765581954,14393.916520454546,15199.9758456,16051.1744929536,15989.537982900662,15870.66170051189,15688.328083381195,16566.874456050544,17494.619425589375,18474.318113422381,19508.879927774036,20601.377203729382,21755.05432713823,22973.337369457975,24259.844262147624,25618.395540827893,27053.025691114257,28567.99512981666,30167.802857086383]
[null,null,null,"Age 5-18",null,{"$f":"F10*diar518*(1-diarred*F$7)","v":0},6744.3718096023495,7122.056630940082,7520.8918022727285,7942.0617431999999,8386.8172008192014,8354.6118227680563,8292.4983836334141,8197.2281766394899,8656.2729545313032,9141.024239985054,9652.9215974242197,10193.485206879976,10764.320378465254,11367.122319659309,12003.681169560234,12675.887315055608,13385.737004698723,14135.338276961855,14926.917220471718,15762.82458481813]
[null,null,null,"Age > 18",null,{"$f":"F11*diar18*(1-diarred*F$7)","v":0},14827.514053320519,15657.854840306472,16534.694711363638,17460.637615200001,18438.433321651199,18367.629737696061,18231.073225441247,18021.621496956479,19030.832300786045,20096.558909630061,21221.966208569349,22410.396316249233,23665.378509959188,24990.639706516904,26390.115530081857,27867.961999766452,29428.56787175337,31076.567672571564,32816.855462235573,34654.599368120755]
[]
[null,null,"Cases of diarrheal disease averted",null,null,{"$f":"SUM(F37:F39)","v":0},0,0,0,0,0,2565.7252729229713,5418.8117764133185,8583.3978538387,9064.0681336536654,9571.6559491382723,10107.668682290016,10673.698128498261,11271.425223694157,11902.625036221032,12569.172038249415,13273.045672391385,14016.336230045301,14801.251058927843,15630.121118227798,16505.407900848557]
[null,null,null,"Age < 5",null,{"$f":"F17-F32","v":0},0,0,0,0,0,960.50228165834233,2028.5808188624214,3213.2720170780776,3393.2152500344491,3583.2353040363778,3783.8964810624166,3995.794684001914,4219.5591863060181,4455.8545007391549,4705.3823527805507,4968.8837645362619,5247.1412553502923,5540.9811656499114,5851.2761109263047,6178.9475731381754]
[null,null,null,"Age 5-18",null,{"$f":"F18-F33","v":0},0,0,0,0,0,501.86714129702159,1059.9434024193088,1678.9503494321852,1772.9715690003868,1872.25797686441,1977.1044235688169,2087.8222712886709,2204.7403184808354,2328.2057763157627,2458.5852997894453,2596.2660765776563,2741.6569768660047,2895.1897675705004,3057.3203945544483,3228.5303366494973]
[null,null,null,"Age > 18",null,{"$f":"F19-F34","v":0},0,0,0,0,0,1103.3558499676074,2330.2875551315883,3691.1754873284372,3897.8813146188295,4116.1626682374845,4346.6677776587821,4590.0811732076763,4847.125718907304,5118.5647591661145,5405.2043856794189,5707.8958312774666,6027.5379978290039,6365.0801257074309,6721.5246127470455,7097.9299910608825]
[]
[null,null,"Treatment costs",null,null,{"$f":"F31*cost_treat/Tsh_USD","v":0},12574.932501578469,13279.12872166687,14022.759930080218,14808.034486164706,15637.284417389928,15577.237245227157,15461.426265849212,15283.794240779907,16139.686718263585,17043.509174486342,17997.945688257583,19005.830646800005,20070.157163020805,21194.08596414997,22380.954778142375,23634.288245718355,24957.808387478588,26355.445657177384,27831.350613979321,29389.90624836216]
[]
[null,null,"Total treatment cost savings",null,null,{"$f":"F21-F41","v":0},0,0,0,0,0,935.73509953661232,1976.2725302213294,3130.4156878705853,3305.7189663913359,3490.8392285092559,3686.3262253057692,3892.760493922895,4110.7550815825743,4340.9573661512004,4584.0509786556759,4840.7578334603859,5111.8402721341663,5398.1033273736903,5700.3971137066073,6019.6193520741726]
[]
[null,null,"Days spent treating for self or others",null,null,{"$f":"F31*sickdays","v":0},4758.1922014037245,5024.6509646823342,5306.0314187045469,5603.1691781520003,5916.9466521285121,5894.2255769843405,5850.4041967229441,5783.190530462849,6107.0492001687699,6449.0439553782198,6810.1904168794017,7191.5610802246483,7594.2885007172281,8019.568656757393,8468.6645015358099,8942.909713621817,9443.7126575846396,9972.56056640938,10531.023958128306,11120.761299783488]
[null,null,"Opportunity cost of treatment",null,null,{"$f":"F45*wage/Tsh_USD*employ","v":0},66379.831762668124,70097.102341377555,74022.540072494725,78167.8023165544,82545.199246281452,82228.225681175754,81616.889331941857,80679.21559585759,85197.251669225632,89968.297762702263,95006.522437413601,100326.88769390876,105945.19340476765,111878.12423543463,118143.299192619,124759.32394740569,131745.84608846044,139123.61346941421,146914.53582370144,155141.74982982865]
[]
[null,null,"Opportunity cost savings",null,null,{"$f":"F24-F46","v":0},0,0,0,0,0,4939.5047228974727,10432.233974759496,16524.658616019035,17450.039498516097,18427.241710432994,19459.167246217243,20548.880612005421,21699.6179262777,22914.796530149266,24198.025135837655,25553.114543444579,26984.088957877422,28495.197939518635,30090.92902413159,31776.02104948301]
[]
[null,null,"Children stunted as a result of diarrhea",null,null,{"$f":"F32*stunt","v":0},8112.6737074771481,8566.9834350958699,9046.7345074612404,9553.3516398790689,10088.339331712297,10049.600108678524,9974.8850605207172,9860.286381028418,10412.462418366011,10995.560313794509,11611.311691367002,12261.545146083554,12948.191674264233,13673.290408023033,14438.994670872324,15247.578372441176,16101.442761297883,17003.123555930564,17955.298475062682,18960.795189666183]
[null,null,null,"Stunting cases averted",null,{"$f":"F26-F50","v":0},0,0,0,0,0,603.68622560966469,1274.9853084876104,2019.576728644377,2132.673025448461,2252.1027148735739,2378.220466906494,2511.4008130532602,2652.0392585842401,2800.5534570649579,2957.3844506605983,3122.9979798975928,3297.8858667718559,3482.5674753110834,3677.5912539284982,3883.5363641484983]
[]
[null,null,"Present value of lifetime income gains due to decreased stunting",null,null,{"$f":"F51*$H58","v":0},0,0,0,0,0,1334982.6298420862,2819483.314226483,4466061.569734754,4716161.0176398978,4980266.03462773,5259160.932566883,5553673.9447906343,5864679.6856989032,6193101.7480980428,6539915.4459915394,6906150.7109670676,7292895.1507812189,7701297.279224975,8132569.9268615609,8587993.8427658174]
[]
[]
[]
[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":13461.080991306248},{"$f":"NPV(0.1,G59:G118)","v":15672.465934691167},2211.3849433849232,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":3521.4554312693504},{"$f":"wage*250/Tsh_USD","v":4099.9597523219818},578.50432105263144]
[null,null,null,null,"Age 16",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 17",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 18",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 19",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 20",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 21",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 22",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 23",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 24",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 25",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 26",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 27",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 28",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 29",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 30",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 31",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 32",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 33",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 34",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 35",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 36",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 37",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 38",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 39",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 40",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 41",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 42",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 43",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 44",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 45",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 46",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 47",{"$f":"(wage-(wage*rtnedu*stntyrs))*250/Tsh_USD","v":3521.4554312693504},{"$f":"wage*250/Tsh_USD","v":4099.9597523219818},578.50432105263144]
[null,null,null,null,"Age 48",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 49",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 50",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 51",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 52",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 53",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 54",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 55",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 56",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 57",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 58",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 59",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 60",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 61",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 62",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 63",3521.4554312693504,4099.9597523219818,578.50432105263144]
[null,null,null,null,"Age 64",3521.4554312693504,4099.9597523219818,578.50432105263144]

{"sheet":"Commercial","index":9,"n_rows":36,"n_cols":26,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania:  Lower Ruvu Plant Expansion 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 DAWASCO (m3)",null,null,null,{"$f":"Savings!G13","v":52327064.299999997},{"$f":"Savings!H13","v":52327064.299999997},{"$f":"Savings!I13","v":52327064.299999997},{"$f":"Savings!J13","v":52327064.299999997},{"$f":"Savings!K13","v":52327064.299999997},{"$f":"Savings!L13","v":52327064.299999997},{"$f":"Savings!M13","v":52327064.299999997},{"$f":"Savings!N13","v":52327064.299999997},{"$f":"Savings!O13","v":52327064.299999997},{"$f":"Savings!P13","v":52327064.299999997},{"$f":"Savings!Q13","v":52327064.299999997},{"$f":"Savings!R13","v":52327064.299999997},{"$f":"Savings!S13","v":52327064.299999997},{"$f":"Savings!T13","v":52327064.299999997},{"$f":"Savings!U13","v":52327064.299999997},{"$f":"Savings!V13","v":52327064.299999997},{"$f":"Savings!W13","v":52327064.299999997},{"$f":"Savings!X13","v":52327064.299999997},{"$f":"Savings!Y13","v":52327064.299999997},{"$f":"Savings!Z13","v":52327064.299999997}]
[null,null,null,"Lower Ruvu",null,null,{"$f":"cap_wop*365*(1-(nrw*techloss))","v":36529199.999999993},36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993]
[null,null,null,"Other sources",null,null,{"$f":"G9-G10","v":15797864.300000004},{"$f":"H9-H10","v":15797864.300000004},15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004]
[]
[null,null,"Volume of water consumed from DAWASCO sources (m3)",null,null,null,{"$f":"G9","v":52327064.299999997},{"$f":"H9","v":52327064.299999997},52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997]
[null,null,null,"Domestic",null,null,{"$f":"Savings!G26","v":14924606.484568307},{"$f":"Savings!H26","v":15760384.447704135},{"$f":"Savings!I26","v":16642965.976775568},{"$f":"Savings!J26","v":17574972.071474999},{"$f":"Savings!K26","v":18559170.5074776},{"$f":"Savings!L26","v":19598484.055896349},{"$f":"Savings!M26","v":20695999.163026549},{"$f":"Savings!N26","v":21854975.116156034},{"$f":"Savings!O26","v":23078853.722660773},{"$f":"Savings!P26","v":24371269.531129777},{"$f":"Savings!Q26","v":25736060.624873046},{"$f":"Savings!R26","v":27177280.019865938},{"$f":"Savings!S26","v":28699207.700978432},{"$f":"Savings!T26","v":30306363.332233228},{"$f":"Savings!U26","v":32003519.67883829},{"$f":"Savings!V26","v":33795716.780853242},{"$f":"Savings!W26","v":35688276.920581028},{"$f":"Savings!X26","v":36529199.999999993},{"$f":"Savings!Y26","v":36529199.999999993},{"$f":"Savings!Z26","v":36529199.999999993}]
[null,null,null,"Commercial and institutional",null,null,{"$f":"G13-G14","v":37402457.815431692},{"$f":"H13-H14","v":36566679.852295861},35684098.323224425,34752092.228524998,33767893.792522401,32728580.244103648,31631065.136973448,30472089.183843963,29248210.577339225,27955794.76887022,26591003.675126951,25149784.280134059,23627856.599021565,22020700.967766769,20323544.621161707,18531347.519146755,16638787.379418969,15797864.300000004,15797864.300000004,15797864.300000004]
[]
[null,null,"Cost of water production and delivery (US$)",null,null,null,{"$f":"G10*cost_water","v":32876279.999999993},32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993]
[]
[null,null,"With Project"]
[null,null,"Benefits?",null,null,{"$f":"IF(F5>year,1,0)","v":0},0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,"Water produced by DAWASCO (m3)",null,null,null,{"$f":"SUM(G23:G24)","v":52327064.299999997},{"$f":"SUM(H23:H24)","v":52327064.299999997},52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997]
[null,null,null,"Lower Ruvu",null,null,{"$f":"IF(G20=0,G10,(cap_wp*365*(1-(nrw*techloss)*G20)+(G10*(1-G20))))","v":36529199.999999993},36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,36529199.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993,54793799.999999993]
[null,null,null,"Other sources",null,null,{"$f":"G11","v":15797864.300000004},{"$f":"H11","v":15797864.300000004},{"$f":"I11","v":15797864.300000004},15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004,15797864.300000004]
[]
[null,null,"Volume of water consumed from DAWASCO sources (m3)",null,null,null,{"$f":"G22","v":52327064.299999997},{"$f":"H22","v":52327064.299999997},52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,52327064.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997,70591664.299999997]
[null,null,null,"Domestic",null,null,{"$f":"Savings!G49","v":14924606.484568307},{"$f":"Savings!H49","v":15760384.447704135},{"$f":"Savings!I49","v":16642965.976775568},{"$f":"Savings!J49","v":17574972.071474999},{"$f":"Savings!K49","v":18559170.5074776},{"$f":"Savings!L49","v":19598484.055896349},{"$f":"Savings!M49","v":20695999.163026549},{"$f":"Savings!N49","v":21854975.116156034},{"$f":"Savings!O49","v":23078853.722660773},{"$f":"Savings!P49","v":24371269.531129777},{"$f":"Savings!Q49","v":25736060.624873046},{"$f":"Savings!R49","v":27177280.019865938},{"$f":"Savings!S49","v":28699207.700978432},{"$f":"Savings!T49","v":30306363.332233228},{"$f":"Savings!U49","v":32003519.67883829},{"$f":"Savings!V49","v":33795716.780853242},{"$f":"Savings!W49","v":35688276.920581028},{"$f":"Savings!X49","v":37686820.428133562},{"$f":"Savings!Y49","v":39797282.372109041},{"$f":"Savings!Z49","v":42025930.184947148}]
[null,null,null,"Commercial and institutional",null,null,{"$f":"G26-G27","v":37402457.815431692},{"$f":"H26-H27","v":36566679.852295861},35684098.323224425,34752092.228524998,33767893.792522401,32728580.244103648,31631065.136973448,48736689.183843963,47512810.577339225,46220394.76887022,44855603.675126955,43414384.280134059,41892456.599021569,40285300.967766769,38588144.621161707,36795947.519146755,34903387.379418969,32904843.871866435,30794381.927890956,28565734.115052849]
[]
[null,null,"Additional volume of water available to enterprises (m3)",null,null,null,{"$f":"G28-G15","v":0},{"$f":"H28-H15","v":0},0,0,0,0,0,18264600,18264600,18264600,18264600.000000004,18264600,18264600.000000004,18264600,18264600,18264600,18264600,17106979.57186643,14996517.627890952,12767869.815052845]
[]
[null,null,"Value of additionalwater available to enterprises (US$)",null,null,null,{"$f":"commtariff*G30/Tsh_USD","v":0},0,0,0,0,{"$f":"commtariff*L30/Tsh_USD","v":0},0,12180169.783281734,12180169.783281734,12180169.783281734,12180169.783281736,12180169.783281734,12180169.783281736,12180169.783281734,12180169.783281734,12180169.783281734,12180169.783281734,11408183.900247769,10000773.675070314,8514548.477282919]
[]
[null,null,"Cost of water production and delivery (US$)",null,null,null,{"$f":"G23*cost_water","v":32876279.999999993},32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,32876279.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993,49314419.999999993]
[]
[null,null,"Increased water production and delivery costs",null,null,null,{"$f":"G34-G17","v":0},0,0,0,0,0,0,16438140,16438140,16438140,16438140,16438140,16438140,16438140,16438140,16438140,16438140,16438140,16438140,16438140]

{"sheet":"Beneficiaries","index":10,"n_rows":44,"n_cols":32,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,"Tanzania: Lower Ruvu Plant Expansion 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,{"$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,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":"C40","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},{"$f":"K9*(1+$E9)","v":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":"C40","v":1},"Dar es Salaam Region",null,5.6000000000000001E-2,null,null,null,null,null,null,{"$f":"M10/(1+$E10)","v":3509804.3247417407},3706353.3669272782,3913909.1554752062,{"$f":"P10/(1+$E10)","v":4133088.0681818179},4364541,4608955.2960000001,{"$f":"Q10*(1+$E10)","v":4867056.7925760001},{"$f":"R10*(1+$E10)","v":5139611.972960256},{"$f":"S10*(1+$E10)","v":5427430.2434460307},{"$f":"T10*(1+$E10)","v":5731366.337079009},{"$f":"U10*(1+$E10)","v":6052322.8519554334},{"$f":"V10*(1+$E10)","v":6391252.9316649381},{"$f":"W10*(1+$E10)","v":6749163.0958381752},{"$f":"X10*(1+$E10)","v":7127116.2292051129},{"$f":"Y10*(1+$E10)","v":7526234.7380406},{"$f":"Z10*(1+$E10)","v":7947703.8833708735},{"$f":"AA10*(1+$E10)","v":8392775.3008396421},{"$f":"AB10*(1+$E10)","v":8862770.7176866625},{"$f":"AC10*(1+$E10)","v":9359085.8778771162},{"$f":"AD10*(1+$E10)","v":9883194.6870382354},{"$f":"AE10*(1+$E10)","v":10436653.589512376}]
[null,{"$f":"C41","v":2},null,"Kinondoni Municipal Council",5.6000000000000001E-2,null,null,null,null,null,null,{"$f":"M11/(1+$E11)","v":1427429.5182078714},1507365.5712275123,1591778.0432162532,{"$f":"P11/(1+$E11)","v":1680917.6136363635},1775049,{"$f":"P11*(1+$E11)","v":1874451.7440000002},1979421.0416640004,2090268.6199971845,2207323.6627170271,2330933.7878291807,2461466.079947615,2599308.1804246814,2744869.4385284637,2898582.1270860578,3060902.7262028772,3232313.2788702385,3413322.822486972,3604468.9005462425,3806319.1589768324,4019473.0318795354,4244563.5216647899]
[null,null,null,"Ilala Municipal Council",5.6000000000000001E-2,null,null,null,null,null,null,{"$f":"M12/(1+$E12)","v":981570.74630008987},1036538.708092895,1094584.8757460972,{"$f":"P12/(1+$E12)","v":1155881.6287878787},1220611,{"$f":"P12*(1+$E12)","v":1288965.216},1361147.2680960002,1437371.5151093763,1517864.3199555015,1602864.7218730096,1692625.1462978981,1787412.1544905805,1887507.2351420531,1993207.6403100081,2104827.2681673686,2222697.5951847415,2347168.6605150872,2478610.1055039321,2617412.2714121523,2763987.3586112331,2918770.6506934622]
[null,null,null,"Temeke Municipal Council",5.6000000000000001E-2,null,null,null,null,null,null,{"$f":"M13/(1+$E13)","v":1100804.060233779},1162449.0876068708,1227546.2365128556,{"$f":"P13/(1+$E13)","v":1296288.8257575757},1368881,1445538.3360000001,1526488.4828160002,1611971.8378536964,1702242.2607735035,1797567.8273768197,1898231.6257099216,2004532.5967496773,2116786.4221676593,2235326.4618090484,2360504.7436703551,2492693.0093158949,2632283.8178375852,2779691.7116364902,2935354.4474881338,3099734.2965474692,3273319.4171541277]
[]
[null,{"$f":"C42","v":3},"Population of area served by DAWASCO",null,null,null,null,null,null,null,null,{"$f":"M15/(1+$E11)","v":2300027.2719641686},{"$f":"N15/(1+$E11)","v":2428828.7991941622},{"$f":"O15/(1+$E11)","v":2564843.2119490355},{"$f":"P15/(1+$E11)","v":2708474.4318181816},2860149,{"$f":"P15*(1+$E11)","v":3020317.344},3189455.1152640004,3368064.6017187848,3556676.219415037,3755850.087702279,3966177.6926136068,4188283.6433999692,4422827.5274303677,4670505.8689664686,4932054.1976285912,5208249.2326957928,5499911.1897267578,5807906.2163514569,6133148.964467139,6476605.306477299,6839295.2036400279]
[null,null,null,"Age < 5",0.14599999999999999,null,null,null,null,null,null,{"$f":"L$15*$E16","v":335803.98170676862},{"$f":"M$15*$E16","v":354609.00468234764},374467.10894455918,395437.26704545447,417581.75399999996,440966.33222399995,465660.44682854402,491737.43185094255,519274.72803459538,548354.11280453275,579061.94312158658,611489.41193639545,645732.81900483358,681893.85686910432,720079.91285377427,760404.38797358575,802987.03370010655,847954.30758731265,895439.74881220225,945584.37474568561,998537.09973144403]
[null,null,null,"Age 5-18",{"$f":"0.413-E16","v":0.26700000000000002},null,null,null,null,null,null,{"$f":"L$15*$E17","v":614107.28161443304},648497.28938484134,684813.13759039249,723162.67329545459,763659.78300000005,806424.73084800004,851584.51577548811,899273.24865891563,949632.55058381497,1002811.9734165085,1058969.4439278331,1118271.7327877919,1180894.9498239083,1247025.0670140472,1316858.470766834,1390602.5451297767,1468476.2876570444,1550710.9597658392,1637550.7735127262,1729253.6168294388,1826091.8193718875]
[null,null,null,"Age > 18",{"$f":"1-SUM(E16:E17)","v":0.58699999999999997},null,null,null,null,null,null,1350116.0086429669,1425722.5051269731,1505562.9654140838,1589874.4914772725,1678907.463,1772926.2809279999,1872210.152659968,1977053.9212089265,2087768.9407966265,2204684.0014812378,2328146.305564187,2458522.4986757818,2596199.7586016254,2741586.9450833169,2895115.8140079831,3057242.2995924302,3228447.8683696068,3409240.948998305,3600158.4421422104,3801767.3149021743,4014666.284536696]
[]
[null,null,"Population of households using DAWASCO sources",null,null,null,null,null,null,null,null,{"$f":"L34*hhsize","v":0},1262990.9755809642,1333718.4702134985,1408406.7045454546,1487277.48,1570565.0188799999,1658516.6599372802,1751393.5928937681,1849471.6340958192,1953042.0456051852,2062412.4001590756,2177907.4945679842,2299870.3142637913,2428663.0518625635,2564668.1827668673,2708289.6010018126,2859953.8186579146,3020111.2325027576,3189237.4615229126,3367834.7593681957,3556433.5058928141]
[null,null,null,"Age < 5",{"$f":"E16","v":0.14599999999999999},null,null,null,null,null,null,{"$f":"L$20*$E21","v":0},{"$f":"M$20*$E21","v":184396.68243482077},194722.89665117077,205627.37886363635,217142.51207999999,229302.49275647997,242143.43235084289,255703.46456249012,270022.85857798957,285144.13865835703,301112.21042322501,317974.49420692568,335781.06588251353,354584.80557193427,374441.5546839626,395410.28174626461,417553.25752405549,440936.2399454026,465628.66938234522,491703.87486775656,519239.29186035082]
[null,null,null,"Age 5-18",{"$f":"E17","v":0.26700000000000002},null,null,null,null,null,null,{"$f":"L$20*$E22","v":0},337218.59048011748,356102.83154700411,376044.5901136364,397103.08716,419340.86004096002,442823.94820325385,467622.0893026361,493808.92630358378,521462.22617658449,550664.11084247322,581501.30104965181,614065.37390843232,648453.03484730446,684766.40479875356,723113.32346748398,763607.66958166321,806369.69907823636,851526.40222661768,899211.88075130829,949567.74607338139]
[null,null,null,"Age > 18",0.58699999999999997,null,null,null,null,null,null,0,741375.70266602596,782892.7420153236,826734.73556818184,873031.88075999997,921921.66608255985,973549.27938318346,1028068.0390286418,1085639.8492142458,1146435.6807702438,1210636.0788933772,1278431.6993114066,1350023.8744728453,1425625.2114433246,1505460.2232841509,1589765.9957880639,1678792.8915521959,1772805.2934791185,1872082.3899139496,1976919.0037491308,2087626.4679590818]
[]
[null,null,"Households"]
[null,{"$f":"C43","v":4},"Dar es Salaam Region",null,{"$f":"4364541/1095095","v":3.9855364146489576},null,null,null,null,null,null,{"$f":"L10/$E26","v":880635.367385266},929950.94795884099,982028.20104453608,1037021.7803030302,1095095,1156420.32,1221179.8579199999,1289565.92996352,1361781.6220414771,1438041.3928757999,1518571.7108768448,1603611.7266859482,1693413.9833803615,1788245.1664496616,1888386.8957708429,1994136.5619340101,2105808.2094023144,2223733.4691288443,2348262.5434000599,2479765.2458304632,2618632.0995969689]
[null,null,null,"Kinondoni Municipal Council",4,null,null,null,null,null,null,{"$f":"L11/$E27","v":356857.37955196784},376841.39280687808,397944.51080406329,420229.40340909088,443762.25,468612.93600000005,494855.26041600009,522567.15499929612,551830.91567925678,582733.44695729518,615366.51998690376,649827.04510617035,686217.35963211593,724645.53177151445,765225.68155071931,808078.31971755961,853330.70562174299,901117.22513656062,951579.7897442081,1004868.2579698839,1061140.8804161975]
[null,null,null,"Ilala Municipal Council",4,null,null,null,null,null,null,{"$f":"L12/$E28","v":245392.68657502247},259134.67702322375,273646.2189365243,288970.40719696967,305152.75,322241.304,340286.81702400005,359342.87877734407,379466.07998887537,400716.18046825239,423156.28657447454,446853.03862264514,471876.80878551328,498301.91007750202,526206.81704184215,555674.39879618539,586792.1651287718,619652.52637598303,654353.06785303808,690996.83965280827,729692.66267336556]
[null,null,null,"Temeke Municipal Council",3.9,null,null,null,null,null,null,{"$f":"L13/$E29","v":282257.45134199463},298063.86861714639,314755.44525970658,332381.7501942502,350995.12820512819,370650.85538461542,391407.30328615394,413326.11227017856,436472.37455730856,460914.8275325179,486726.05787433888,513982.71711530187,542765.74927375885,573160.63123308937,605257.62658214231,639152.05367074232,674944.56867630396,712741.464522177,752654.9865354189,794803.66578140238,839312.671065161]
[]
[null,{"$f":"C44","v":5},"Households in area served by DAWASCO",null,{"$f":"hhsize","v":3.9855364146489576},null,null,null,null,null,null,{"$f":"L15/$E31","v":577093.52836680901},{"$f":"M15/$E31","v":609410.76595535036},643537.76884885004,679575.88390438573,717632.13340303139,757819.53287360107,800257.42671452288,845071.84261053626,892395.86579672631,942370.03428134299,995142.75620109821,1050870.7505483599,1109719.5125790681,1171863.8052834959,1237488.1783793718,1306787.5163686168,1379967.6172852595,1457245.803853234,1538851.5688690154,1625027.2567256803,1716028.7831023184]
[]
[null,null,"Beneficiaries"]
[null,null,"Households using DAWASCO sources",null,null,null,null,null,null,null,null,null,{"$f":"Savings!G41","v":316893.59829678218},{"$f":"Savings!H41","v":334639.63980140205},{"$f":"Savings!I41","v":353379.45963028062},{"$f":"Savings!J41","v":373168.7093695763},{"$f":"Savings!K41","v":394066.15709427255},{"$f":"Savings!L41","v":416133.86189155187},{"$f":"Savings!M41","v":439437.35815747885},{"$f":"Savings!N41","v":464045.85021429771},{"$f":"Savings!O41","v":490032.41782629839},{"$f":"Savings!P41","v":517474.2332245711},{"$f":"Savings!Q41","v":546452.79028514714},{"$f":"Savings!R41","v":577054.14654111536},{"$f":"Savings!S41","v":609369.17874741787},{"$f":"Savings!T41","v":643493.85275727336},{"$f":"Savings!U41","v":679529.50851168076},{"$f":"Savings!V41","v":717583.16098833503},{"$f":"Savings!W41","v":757767.81800368172},{"$f":"Savings!X41","v":800202.81581188808},{"$f":"Savings!Y41","v":845014.1734973538},{"$f":"Savings!Z41","v":892334.96721320553}]
[null,null,"People using DAWASCO sources",null,null,null,null,null,null,null,null,null,{"$f":"M20","v":1262990.9755809642},{"$f":"N20","v":1333718.4702134985},1408406.7045454546,1487277.48,1570565.0188799999,1658516.6599372802,1751393.5928937681,1849471.6340958192,1953042.0456051852,2062412.4001590756,2177907.4945679842,2299870.3142637913,2428663.0518625635,2564668.1827668673,2708289.6010018126,2859953.8186579146,3020111.2325027576,3189237.4615229126,3367834.7593681957,3556433.5058928141]
[]
[]
[]
[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 assumed to be equivalent to the overall growth rate of the Dar es Salaam Region."]
[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,"2012 Tanzania Population and Housing Census General Report (2013). Table 7.0."]
[null,null,5,"EWURA (2013). Water Utilities Performance Review Report 2012/13. Table A2.15, p. 123."]

{"sheet":"Poverty Scorecard","index":11,"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: Lower Ruvu Plant Expansion Activity"]
[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,null,null,null,null,"Bar Chart Data"]
[null,null,"2013 US$",null,"2005 PPP $",null,null,null,null,null,"Activity/Sub-activity","Lower Ruvu Plant Expansion Activity","National Income Distribution"]
[null,"MCC Cost (Millions US$)",{"$f":"Costs!C13/10^6","v":48.828663241973615},null,{"$f":"C10*(99.991/106.442)","v":45.869364219276079},null,null,null,null,null,"Consump. <$1.25/day",{"$f":"E32","v":3.2749039605212598E-3},{"$f":"R18","v":0.12758791923351906}]
[null,"20-Year ERR",{"$f":"ERR!F48","v":0.14914692980684396},null,null,null,null,null,null,null,"Consump. >=$1.25/day and <$2/day",{"$f":"F32","v":1.7104034959187098E-2},{"$f":"R19","v":0.19636263737915438}]
[null,"Present Value (PV) of Investment Costs (Millions US$)",{"$f":"ERR!F45","v":82.080289748011452},null,{"$f":"C12*(99.991/106.442)","v":77.105750100462359},null,null,null,null,null,"Consump. >=$2/day and <$4/day",{"$f":"G32","v":0.22476296401758905},0.29940627353677313]
[null,"Present Value (PV) of Benefit Stream (Millions US$)",{"$f":"ERR!F43","v":111.98850546732442},null,105.20135519985755,null,null,null,null,null,"Consump. >$4/day",{"$f":"H32","v":1.1234293852096113},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!AF34","v":892334.96721320553},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!AF35","v":3556433.5058928141},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":1.5338952125734898E-2},{"$f":"L48","v":4.9851240775472337E-2},{"$f":"L46","v":0.33112456555812741},{"$f":"L47","v":0.61902419366640038},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.25},"of total beneficiaries",null,null,{"$f":"Savings!F50","v":0.95815899581589958},"of total benefits"]
[null,"PV of Benefit Stream Per Beneficiary (2013 US$) ",{"$f":"(C13*10^6)/C18","v":31.488991789602039},null,{"$f":"C25*P44","v":7.5582761643399235E-2},{"$f":"C25*P45","v":0.29796191577073849},{"$f":"C25*P46","v":5.1873904518718694},{"$f":"C25*P47","v":25.928056660316027},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":29.580577009395707},null,{"$f":"E25*(99.991/106.442)","v":7.1002009728163076E-2},{"$f":"F25*(99.991/106.442)","v":0.27990370267217751},4.8730046285594044,24.356666668435956,null,null,"<$1.25 / day",0,0,{"$f":"(L26*M26)/SUMPRODUCT(L$26:L$29,M$26:M$29)","v":0},{"$f":"N26*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$24","v":0},0,{"$f":"O26*P26","v":0},{"$f":"Q26/SUM(Q$28:Q$30)","v":0},0.51642997544892]
[null,"PV of Benefit Stream as Share of Annual Consumption (%)",{"$f":"C25/(N49*365)","v":1.4426838213808999E-2},null,{"$f":"E26/(N44*365)","v":2.0788097213043458E-4},{"$f":"F26/(N45*365)","v":4.6772739468406492E-4},{"$f":"G26/(N46*365)","v":4.4875618634342288E-3},{"$f":"H26/(N47*365)","v":8.3893182596046726E-3},null,null,"$1.25 - $1.99 / day",4.3E-3,12,{"$f":"(L27*M27)/SUMPRODUCT(L$26:L$29,M$26:M$29)","v":1.0947406791432046E-2},{"$f":"N27*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$24","v":18718.136690234365},1.4110499999999999,{"$f":"O27*P27","v":26412.2267767552},{"$f":"Q27/SUM(Q$26:Q$29)","v":1.8825549244874328E-3}]
[null,null,null,null,null,null,null,null,null,null,"$2 - $4 / day",0.13,6.4115830000000003,0.17683579352992118,{"$f":"N28*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$24","v":302358.04863026703},3.1413690000000001,949818.20086761331,6.7699135954139691E-2]
[null,"Cost Effectiveness",null,null,null,null,null,null,null,null,">$4 / day",0.86570000000000003,4.4222469999999996,0.81221679967864679,{"$f":"N29*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$24","v":1388747.6155895055},9.3996630000000003,13053759.578594899,0.93041830912137291]
[null,null,null,null,null,null,null,null,null,null,"< $2.00 / day",{"$f":"L26+L27","v":4.3E-3},12,{"$f":"N27","v":1.0947406791432046E-2},{"$f":"N30*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$24","v":18718.136690234365},1.4110499999999999,{"$f":"Q26+Q27","v":26412.2267767552},1.8825549244874328E-3]
[]
[null,"PV of Benefit Stream/PV of Investment Costs",{"$f":"C13/C12","v":1.3643775602051593},null,{"$f":"C32*P$44","v":3.2749039605212598E-3},{"$f":"C32*P$48","v":1.7104034959187098E-2},{"$f":"C32*P$46","v":0.22476296401758905},{"$f":"C32*P$47","v":1.1234293852096113},null,null,null,{"$f":"SUM(L26:L29)","v":1},{"$f":"SUM(L28:L30)","v":1},{"$f":"SUM(N26:N29)","v":1},null,null,null,{"$f":"SUM(R26:R29)","v":1}]
[null,"PV of Benefit Stream/MCC Costs",{"$f":"C13/C10","v":2.2934993102792531},null,{"$f":"C33*P$44","v":5.5050670677674355E-3},{"$f":"C33*P$48","v":2.8751639961001104E-2},{"$f":"C33*P$46","v":0.37782335182436383},{"$f":"C33*P$47","v":1.8884688485628947},null,null,"Beneficiaries using other piped",{"$f":"Assumptions!C10/SUM(Assumptions!C9:C10)","v":0.75},"of total beneficiaries",{"$f":"SUM(N28:N30)","v":1},null,{"$f":"Savings!F51","v":4.1841004184100417E-2},"of total benefits",{"$f":"SUM(R28:R30)","v":1}]
[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",1.12E-2,7.5622189999999998,{"$f":"(L35*M35)/SUMPRODUCT(L$35:L$38,M$35:M$38)","v":2.0451936167646529E-2},{"$f":"N35*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$33","v":104907.62170240268},0.9357569,{"$f":"O35*P35","v":98168.03087061306},{"$f":"Q35/SUM(Q$35:Q$38)","v":3.6536629114103996E-3},0.51642997544892]
[null,"Percent of Project Participants Who Are Female6",{"$f":"(L24*S26)+(L33*S35)","v":0.51642997544892},null,null,null,null,null,null,null,"$1.25 - $1.99 / day",4.2799999999999998E-2,4.0993909999999998,{"$f":"(L36*M36)/SUMPRODUCT(L$35:L$38,M$35:M$38)","v":4.2367249269172562E-2},{"$f":"N36*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$33","v":217321.59353855505},1.659224,{"$f":"O36*P36","v":360585.20371741545},{"$f":"Q36/SUM(Q$35:Q$38)","v":1.342042591199687E-2}]
[null,null,null,null,null,null,null,null,null,null,"$2 - $4 / day",0.27750000000000002,5.7090360000000002,0.38255415623419614,{"$f":"N37*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$33","v":1962300.6043988215},2.949417,5787642.7617241591,0.21540714951158885]
[null,"Average Annual Consumption of Beneficiaries (2005 PPP $)",{"$f":"N49*365","v":2182.6675618682398},null,null,null,null,null,null,null,">$4 / day",0.66849999999999998,3.4358339999999998,0.55462665832898483,{"$f":"N38*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$33","v":2844941.583090242},7.2486519999999999,20621991.496150248,0.76751876166500399]
[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":5.3999999999999999E-2},4.8176600000000001,{"$f":"N35+N36","v":6.2819185436819094E-2},{"$f":"N39*Beneficiaries!$AF$15*'Poverty Scorecard'!$L$33","v":322229.21524095774},1.509161,{"$f":"Q35+Q36","v":458753.23458802851},1.7074088823407271E-2]
[]
[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.0000000000000002},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}]
[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":1.5338952125734898E-2},{"$f":"O26+O35","v":104907.62170240268},{"$f":"((O26*P26)+(O35*P35))/M44","v":0.9357569},{"$f":"M44*N44","v":98168.03087061306},{"$f":"O44/SUM(O$44:O$47)","v":2.400291573271564E-3}]
[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":3.451228864973744E-2},{"$f":"O27+O36","v":236039.73022878941},{"$f":"((O27*P27)+(O36*P36))/M45","v":1.6395436061507969},{"$f":"M45*N45","v":386997.43049417064},{"$f":"O45/SUM(O$44:O$47)","v":9.462415239001978E-3}]
[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.33112456555812741},{"$f":"O28+O37","v":2264658.6530290884},{"$f":"((O28*P28)+(O37*P37))/M46","v":2.9750448057945063},6737460.962591772,0.16473663198022093]
[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.61902419366640038},{"$f":"O29+O38","v":4233689.1986797471},{"$f":"((O29*P29)+(O38*P38))/M47","v":7.9542331745199313},33675751.074745148,0.82340066120750544]
[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":4.9851240775472337E-2},{"$f":"O30+O39","v":340947.3519311921},{"$f":"((O30*P30)+(O39*P39))/M48","v":1.5037746695345673},512707.99147901422,1.2536145021774759E-2]
[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":1},null,{"$f":"SUMPRODUCT(L44:L47,N44:N47)","v":5.9799111284061359},0,{"$f":"SUM(P46:P48)","v":1.0006734382095011}]
[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":0.99999999999999989}]

{"sheet":"Sensitivity","index":12,"n_rows":361,"n_cols":11,"rows_kept":361,"cut":false,"hidden":false,"merged":[]}
[0,"Tanzania:  Lower Ruvu Plant Expansion 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",0.126,0.189,0.24299999999999999,null,"80% Costs",11.9,46.3,80.7]
[null,null,"100% Costs",9.1999999999999998E-2,0.14899999999999999,0.19700000000000001,null,"100% Costs",-4.5,29.9,64.3]
[null,null,"120% Costs",6.6000000000000003E-2,0.11899999999999999,0.16400000000000001,null,"120% Costs",-20.9,13.5,47.9]
[]
[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:53 PM"]
[null,null,null,null,null,"Simulation stopped on 2/8/2016 at 3:54 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,33.794642719685527]
[null,null,"Trials/second (average)",null,295.90488891823543]
[null,null,"Random numbers per sec",null,2071.334222427648]
[]
[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-Ruvu-ERR-020816.xlsm]ERR"]
[]
["Forecast: Economic Rate of Return (ERR)",null,null,null,null,null,null,null,null,"Cell: F48"]
[]
[null,"Summary:"]
[null,null,"Certainty level is 85.53%"]
[null,null,"Certainty range is from 10.0% to Infinity"]
[null,null,"Entire range is from -0.9% to 40.6%"]
[null,null,"Base case is 14.9%"]
[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,0.14914692980684396]
[null,null,"Mean",null,0.1501710168681212]
[null,null,"Median",null,0.14859443191520816]
[null,null,"Mode",null,"---"]
[null,null,"Standard Deviation",null,4.8239800140688287E-2]
[null,null,"Variance",null,2.3270783176135498E-3]
[null,null,"Skewness",null,0.27602463321583331]
[null,null,"Kurtosis",null,3.3751071944699311]
[null,null,"Coeff. of Variability",null,0.32123242651444539]
[null,null,"Minimum",null,-9.0019950402797644E-3]
[null,null,"Maximum",null,0.40561288262903128]
[null,null,"Range Width",null,0.41461487766931104]
[null,null,"Mean Std. Error",null,4.823980014068829E-4]
[]
["Forecast: Economic Rate of Return (ERR) (cont'd)",null,null,null,null,null,null,null,null,"Cell: F48"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,-9.0019950402797644E-3]
[null,null,"90%",null,9.0135745722879995E-2]
[null,null,"80%",null,0.10972997285828399]
[null,null,"70%",null,0.12424778732649699]
[null,null,"60%",null,0.136227165830106]
[null,null,"50%",null,0.14858887172781901]
[null,null,"40%",null,0.160343057596286]
[null,null,"30%",null,0.17338416405937701]
[null,null,"20%",null,0.18882770545233701]
[null,null,"10%",null,0.212129676477159]
[null,null,"0%",null,0.405612882629031]
[]
["Forecast: Net Present Value (NPV)",null,null,null,null,null,null,null,null,"Cell: F46"]
[]
[null,"Summary:"]
[null,null,"Certainty level is 85.53%"]
[null,null,"Certainty range is from $0.0 to Infinity"]
[null,null,"Entire range is from  $(47.5) to $250.5"]
[null,null,"Base case is $29.9"]
[null,null,"After 10,000 trials, the std. error of the mean is $0.3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statistics:",null,null,"Forecast values"]
[null,null,"Trials",null,10000]
[null,null,"Base Case",null,29.908215719312963]
[null,null,"Mean",null,33.107396979764481]
[null,null,"Median",null,29.722613120746814]
[null,null,"Mode",null,"---"]
[null,null,"Standard Deviation",null,32.673890228037365]
[null,null,"Variance",null,1067.5831026338358]
[null,null,"Skewness",null,0.75732733524516216]
[null,null,"Kurtosis",null,4.2649543425022927]
[null,null,"Coeff. of Variability",null,0.98690604543775884]
[null,null,"Minimum",null,-47.506496668296158]
[null,null,"Maximum",null,250.47767863718411]
[null,null,"Range Width",null,297.98417530548028]
[null,null,"Mean Std. Error",null,0.32673890228037367]
[]
["Forecast: Net Present Value (NPV) (cont'd)",null,null,null,null,null,null,null,null,"Cell: F46"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,-47.506496668296158]
[null,null,"90%",null,-5.4308547212978837]
[null,null,"80%",null,5.5357906004200776]
[null,null,"70%",null,14.268743342975347]
[null,null,"60%",null,21.780228783745912]
[null,null,"50%",null,29.718907587981505]
[null,null,"40%",null,37.842000458352551]
[null,null,"30%",null,46.809968457581171]
[null,null,"20%",null,58.04198406401796]
[null,null,"10%",null,75.752702672192399]
[null,null,"0%",null,250.47767863718414]
[]
["Forecast: Present Value of Benefits",null,null,null,null,null,null,null,null,"Cell: F43"]
[]
[null,"Summary:"]
[null,null,"Entire range is from $34.6 to $332.6"]
[null,null,"Base case is $112.0"]
[null,null,"After 10,000 trials, the std. error of the mean is $0.3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statistics:",null,null,"Forecast values"]
[null,null,"Trials",null,10000]
[null,null,"Base Case",null,111.98850546732442]
[null,null,"Mean",null,115.18768672777587]
[null,null,"Median",null,111.80290286875825]
[null,null,"Mode",null,"---"]
[null,null,"Standard Deviation",null,32.673890228037372]
[null,null,"Variance",null,1067.5831026338362]
[null,null,"Skewness",null,0.75732733524516693]
[null,null,"Kurtosis",null,4.2649543425022927]
[null,null,"Coeff. of Variability",null,0.28365783840468889]
[null,null,"Minimum",null,34.57379307971533]
[null,null,"Maximum",null,332.55796838519558]
[null,null,"Range Width",null,297.98417530548022]
[null,null,"Mean Std. Error",null,0.32673890228037372]
[]
["Forecast: Present Value of Benefits (cont'd)",null,null,null,null,null,null,null,null,"Cell: F43"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,34.57379307971533]
[null,null,"90%",null,76.649435026713604]
[null,null,"80%",null,87.616080348431538]
[null,null,"70%",null,96.349033090986822]
[null,null,"60%",null,103.86051853175738]
[null,null,"50%",null,111.79919733599296]
[null,null,"40%",null,119.92229020636401]
[null,null,"30%",null,128.89025820559266]
[null,null,"20%",null,140.12227381202942]
[null,null,"10%",null,157.83299242020388]
[null,null,"0%",null,332.55796838519558]
[]
["Forecast: Present Value of Costs",null,null,null,null,null,null,null,null,"Cell: F45"]
[]
[null,"Summary:"]
[null,null,"Entire range is from $82.1 to $82.1"]
[null,null,"Base case is $82.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,82.080289748011452]
[null,null,"Mean",null,82.080289748024128]
[null,null,"Median",null,82.080289748011452]
[null,null,"Mode",null,82.080289748011452]
[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,82.080289748011452]
[null,null,"Maximum",null,82.080289748011452]
[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: F45"]
[]
[null,"Percentiles:",null,null,"Forecast values"]
[null,null,"100%",null,82.080289748011452]
[null,null,"90%",null,82.080289748011452]
[null,null,"80%",null,82.080289748011452]
[null,null,"70%",null,82.080289748011452]
[null,null,"60%",null,82.080289748011452]
[null,null,"50%",null,82.080289748011452]
[null,null,"40%",null,82.080289748011452]
[null,null,"30%",null,82.080289748011452]
[null,null,"20%",null,82.080289748011452]
[null,null,"10%",null,82.080289748011452]
[null,null,"0%",null,82.080289748011452]
[]
["End of Forecasts"]
[null,null,null,null,null,"Assumptions"]
[]
[]
["Worksheet: [TZA-Ruvu-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) (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.9]
[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,1077]
[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)",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) (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"]