Simplified Planning Tool - English version

The CLARA Simplified Planning Tool (SPT) aims to support local planners to find the best solution for water supply and sanitation in their planning objective. Simplified means that the software tool is based on a number of assumptions, which allow the planner to use the SPT with the limited amount of data available at the pre-planning phase of a project.


The SPT compares full costs (investment, operation and maintenance, and re-investment costs) of various alternatives of water supply and sanitation systems. Environmental, social and health aspects are not considered explicitly since it is assumed that these aspects are already considered in the framework conditions, i.e. it is assumed that all systems fulfilling the legal requirements benefit environment and health and are socially appropriate. With this assumption the comparison of alternatives can justifiably be reduced to comparing the costs. Net present values of all costs are calculated and used for comparison.
The user of the CLARA simplified planning tool - the planner - is responsible for developing appropriate alternative solutions. Technologies are grouped in functional groups as defined in the Sustainable Sanitation and Water Management Toolbox (SSWM Toolbox; http://www.sswm.info). These functional groups include: Water sources, Water purification, Water distribution, Water use, Waste collection and transport, Waste treatment, and Reuse.


Technologies in the functional groups have to be compiled to systems. Examples of combinations of technologies to meet specific requirements in the functional groups Waste collection and Waste treatment are shown in the user manual (Casielles Restoy et al., 2014).


Cost functions that relate costs to input parameters have been developed for each technology implemented in the CLARA SPT. Therefore for each technology standard designs have been defined, designs have been made for several sizes, and the costs have been calculated from Bills of Quantities developed for these design sizes.
"Technology description" provided with the CLARA SPT include the main assumptions made for developing the costs functions and include: a short description of the technology, design assumptions, input data (in the SPT, the validity range of the cost function, the assumed lifespan of the technology and its components, and the assumptions for calculating O&M costs).


The CLARA SPT has been adapted to the different requirements of the African CLARA partner countries, i.e. Burkina Faso, Ethiopia, Kenya, Morocco and South Africa. Specific design requirements and unit prices have been considered for these countries before country-specific cost functions were developed. The country specific versions of the CLARA SPT have been prepared and tested during the planning process that is carried out in the pilot communities in the 5 African CLARA countries.


Applicability:


The CLARA SPT shall be used to compare the real costs of various alternatives of water supply and sanitation systems (e.g. comparing water-borne and dry sanitation systems) in the pre-planning phase.
The tool cannot be used to compare
• alternative solutions that do not provide the same service (e.g. comparing a solution that fulfils the legal requirements with e.g. the solution "no sanitation facilities"),
• costs of single technologies during detailed planning
• environmental, social and health impacts (as they are considered to be fulfilled when the framework conditions are met), and
• a solution that fulfils legal requirements with e.g. the solution "no sanitation facilities" as these 2 alternatives do not have the same impact. However, the tool can be used to compare.


Advantages:


• Full costs (investment, operation and maintenance, and reinvestment costs) of different alternative system solutions can be compared
• Resource oriented WATSAN- systems are included
• Only limited amount of input data are required and thus applicable for the early pre-planning phase
• Assumptions made to develop costs functions are clearly described
• Costs based on real cost data from 5 African countries (Burkina Faso, Ethiopia, Kenya, Morocco and South Africa)
• Cost functions can be changed if more (detailed) information is available
• Adaptation to other (African) countries is possible


Disadvantages:


• Software implemented in MS Excel® and thus requires MS Excel® (version higher than 2010) to be used
• Limited amount of technologies implemented (those that have been classified by the CLARA project partners as relevant for their countries)
• Comparison of systems with different performance is possible (mass flow balance not yet implemented)
• Simplifying assumptions resulting in uncertainties of costs
• Cost functions based on BoQs and not real cost, due to lack of information/applied technologies
• Adaptation to other (African) countries requires some efforts (evaluation of specific design requirements and collection of unit prices)


Download:

Version 1.6 of the CLARA SPT was released in February 2015. In v1.6 we corrected some minor errors in the previous version of the tool and made some modifications that are based on the work of Ketema and Langergraber (2015a,b).

 

The country-specific CLARA SPT versions can be downloaded as single zip-files including the SPT file itself (version 1.6 of the CLARA SPT is implemented in Microsoft Excel*, MS Excel* 2010 is required), the user manual and the "Technology descriptions":

User Manual

SPT-Burkina Faso

SPT-Ethiopia

SPT-Kenya

SPT-Morocco

SPT-South Africa

 

References:

 

Ketema, A.A., Langergraber, G. (2015a): Sensitivity of results from the CLARA Simplified Planning Tool for different input parameters. Water Science and Technology 71(2), 234-244, doi: 10.2166/wst.014.497.

 

Ketema, A.A., Langergraber, G. (2015b): Three supplementary methods for sensitivity analysis of water supply system's life cycle cost using the CLARA Simplified Planning Tool. Journal of Water Supply: Research and Technology - AQUA, in press, doi: 10.2166/aqua.2015.126.

 

 

 

Version 1.6 of the CLARA SPT is only available in English, users are advised to only use v1.6. (also see French Version).

 

Documents

CLARA Poster <Document>

CLARA Overview Presentation <Document>

Contribution on CLARA in International Innovation 2012 <Document>

Contribution on CLARA in PEN Science & Technology 6, March 2013 <Document>

Contribution on CLARA in PEN Science & Technology 7, June 2013 <Document>

Contribution on CLARA in PEN Science & Technology 8, Septmeber 2013 <Document>

Contribution on CLARA in PEN Science & Technology 9, December 2013 <Document>

Objectives

• to strengthen local capacities to adopt, implement and operate integrated water supply and sanitation for small communities in rural areas and peri-urban areas, and

• to contribute to the achievement of the MDGs and to climate change adaptation in the African water sector.

Specific objectives:

• to assess and adapt existing low cost technologies for integrated decentralized water supply and sanitation systems for African conditions with the focus on reducing risks in water use and reuse of sanitation products.

• to improve the capability of water supply and sanitation systems to provide demand oriented water quality for reuse as well as products from sanitation,

• to develop a simplified planning tool for integrated water supply and sanitation systems for small communities and peri-urban areas that incorporates the key factors for success, i.e. operation and maintenance issues as well as reuse potential, and can be tailored to available local capacities, and

• to test and evaluate the simplified planning tool in different geographical regions in Africa to incorporate different economic, cultural and social boundary conditions.

Partners

bo kreislogo s

University of Natural Resources and Life Sciences Vienna (BOKU University), Institute of Sanitary Engineering and Water Pollution Control, Austria (Co-ordinator)

ttz-logo-header

TTZ Bremerhaven, Germany

ESCA logo

EcoSan Club KG, Austria

     
BIOAZUL Logo s

Bioazul S.L., Spain

   
CBS Logo s

Centre of Biotechnology of Sfax, Tunisia

   
egerton logo

Egerton University, Department of Water and Environmental Engineering, Kenya

   
BannerWRC

Water Research Commission, South Africa

wsa logo

Water and Sanitation for Africa, Burkina Faso

   
onee

Office National de l'Eau Potable, Morocco

   
amu embl s

Arba Minch University, Ethiopia

 

Arba Minch Water Supply and Sewerage Enterprise, Ethiopia

  Arba Minch Town Municipality, Ethiopia
 

'Engan New Mayet' Compost Production Youth Association, Ethiopia

 

'Wubet le Arba Minch' Solid Waste Collectors Association, Ethiopia

 

Arba Minch Health Center, Ethiopia

Summary

There are a large number of small communities and towns in Africa that suffer from severe problems with water supply and sanitation. Small communities in rural areas and peri-urban areas of small towns have comparable settlement structures in which reuse of water and use of sanitation products can be utilized. However, there is only limited local capacity to adopt, implement and operate integrated water supply and sanitation.

CLARA's overall objective is to strengthen the local capacity in the water supply and sanitation sector. From a technological point of view, existing low cost technologies for decentralized water supply and sanitation systems shall be assessed and adapted for African conditions with the focus on reducing risks in use and reuse of water and sanitation products, and providing demand oriented water quality.

Based on these technological improvements and the experiences from the FP6 projects ROSA and NETSSAF, a simplified planning tool for integrated water supply and sanitation systems for small communities and peri-urban areas shall be developed that incorporates the key factors for success, i.e. operation and maintenance issues and reuse potential, form the beginning of the planning process, and that can be tailored to available local capacities. This simplified integrated CLARA planning tool shall then be tested and evaluated in different geographical African regions to incorporate different economic, cultural and social boundary conditions. For the communities participating in the planning process, application documents will be prepared as a final output that serve as basis to ask for funding of their implementation plans for integrated water supply and sanitation.