The present study aimed to develop a tool for assessing water service sustainability in rural areas of sub-Saharan Africa. This tool is called the ‘Water Service Assessment Tool’ (WaSAT) and is based on the Water Service Sustainability Index (WSSI) which consists of 21 indicators grouped into six dimensions (economic, environmental, social, technical, institutional, and governance). The WaSAT was developed using Microsoft Excel and PowerApps platforms. This tool provides a solid baseline on the sustainability of water services and identifies priority actions to be taken to move services toward sustainability.

  • This paper presents a tool called the ‘Water Service Assessment Tool’ (WaSAT) for assessing water service sustainability in rural areas of sub-Saharan Africa.

  • The WaSAT was developed using Microsoft Excel and PowerApps platforms.

  • The WaSAT provides a solid baseline on the sustainability of water services and identifies priority actions to be taken to move services toward sustainability.

Premature failure of water infrastructure and poor service levels experienced by end-users in rural areas in sub-Saharan Africa has resulted in an increasing emphasis on sustainability in recent years. Partly as a response to these challenges, a number of tools were developed to help understand and improve water services. These tools include the WASH Life-Cycle Assessment (McConville & Mihelcic 2007), the Sustainability Check (UNICEF 2008), the Sustainability Assessment Tool (SAT; Aguasan Group 2010), the Sustainability Snapshot (Carter et al. 2011), the Sustainable Index Tool (SIT; USAID/Rotary International 2012), the WASHCost Tool (WASHCost 2012), the Sustainability Monitoring Framework (SMF; DWA 2013), the WASH Sustainability Sector Assessment Tool (Schweitzer et al. 2014), and the Water, Sanitation and Hygiene Bottleneck Analysis Tool (WASH BAT; WASH BAT 2018).

The WASH Life-Cycle Assessment consists of a matrix, the dimensions of which are defined as the five sustainability factors and the five project life stages (McConville & Mihelcic 2007). The Sustainability Check assesses the sustainability of the WASH infrastructure using five weighted factors: institutional, social, financial, technical, and sanitation (UNICEF 2008). The SAT is used to determine the sustainability of the program interventions and is based on six components: economic, environmental, institutional, knowledge, social, and technological (Aguasan Group 2010). The Sustainability Snapshot determines the financial and technical capacity of the community-managed water system. The tool is based on three components: financial, technical, and spare parts/equipment (Carter et al. 2011). The SIT assesses the sustainability of the services provided by WASH project interventions. The index is based on five components (institutional, management, financial, technical, and environmental), but no weighting is introduced into the scoring (USAID/Rotary International 2012).

The WASHCost tool is an open-source tool designed to aid users to effectively plan, budget, manage, and evaluate the delivery of water and sanitation services using a lifecycle costs approach. The tool helps stakeholders consider what the expected capital and recurrent expenditures will be for different technologies and service levels (WASHCost 2012). The SMF assesses the presence or absence of factors with a proven impact on sustainability. The SMF is based on five components: financial, institutional, environmental, technical, and social (FIETS) (DWA 2013). The WASH Sustainability Sector Assessment Tool provides a better understanding of the program design, priorities, and decision-making within the context of the sector level as opposed to the individual project level, as well as identifying key weaknesses or bottlenecks. The WASH BAT has been designed for use by governments and development partners for WASH sector strengthening. It enables a systematic identification of factors (or ‘bottlenecks’) that prevent the achievement of sustainable service delivery within national or subnational WASH targets and helps stakeholders to define activities aimed at removing the root causes of these bottlenecks (WASH BAT 2018).

Although there are successful experiments in the implementation of these tools, they do not provide an integrative, contextualized, and prospective analysis of the sustainability of rural water services (Mvongo et al. 2021a). This difficulty, therefore, encourages the development of a new index to provide an integrative, contextual, and prospective analysis of the sustainability of rural water services. A new water sustainability index, called the Water Service Sustainability Index (WSSI), was developed using the analytical hierarchy process (AHP; Mvongo et al. 2021b). This was specifically developed with the involvement of local water stakeholders and based on natural and socioeconomic characteristics of the Mvila Division. This index is able to obtain information on rural water services, and prioritize problems related to service management with priority actions to improve water service management. Therefore, this paper aimed to develop a tool for implementing the WSSI.

WSSI framework

Sustainability assessment criterion

Dimensions and indicators are the main constituents of the WSSI. They were selected through a literature review on existing evaluation frameworks (Mvongo et al. 2021b). The WSSI final framework has 21 indicators grouped into six dimensions (Table 1).

Table 1

Dimensions and indicators selected

DimensionsIndicatorsWeight (%)
Economic (34.04%) Self-financing capacity 17.84 
Financial autonomy 11.35 
Total coast recovery 4.85 
Environmental (14.64%) Water quality 7.18 
Water availability 4.57 
Climate risk 2.89 
Social (12.65%) Affordability 6.20 
Accessibility 3.95 
Non-discrimination and equity 2.50 
Technical (19.95%) Quality of construction 2.96 
Frequency of maintenance operations 6.16 
Access to spare parts 6.54 
Reliability of water system 4.29 
Institutional (5.63%) Post-construction support to council 1.63 
Post-construction support to service managers 1.63 
Regulation 0.85 
Formalization of contract 0.72 
Organization of the service 0.80 
Governance (13.10%) Skills of water service managers 2.59 
Financial flow management 4.09 
Participation 6.42 
DimensionsIndicatorsWeight (%)
Economic (34.04%) Self-financing capacity 17.84 
Financial autonomy 11.35 
Total coast recovery 4.85 
Environmental (14.64%) Water quality 7.18 
Water availability 4.57 
Climate risk 2.89 
Social (12.65%) Affordability 6.20 
Accessibility 3.95 
Non-discrimination and equity 2.50 
Technical (19.95%) Quality of construction 2.96 
Frequency of maintenance operations 6.16 
Access to spare parts 6.54 
Reliability of water system 4.29 
Institutional (5.63%) Post-construction support to council 1.63 
Post-construction support to service managers 1.63 
Regulation 0.85 
Formalization of contract 0.72 
Organization of the service 0.80 
Governance (13.10%) Skills of water service managers 2.59 
Financial flow management 4.09 
Participation 6.42 

Normalization of indicators

The normalization of indicators is done using the Min–Max method and the categorical scale method. The Min–Max method is used for the quantitative indicators. Algebraically, the Min–Max method results in the following equation:
formula
(1)
where is the value of indicator i, is the current value of indicator i, is the minimum value of indicator i, and is the maximum value of indicator i. The categorical scale method is used for qualitative indicators. Algebraically, the categorical scale method results in the following equation:
formula
(2)
where is the value of indicator i; is the current value of indicator i; is the category for Xi which meets the criterion j; and n is the number of the category.

Weighting dimensions and indicators

The AHP was used to weighting dimensions and indicators because of its simplicity. It facilitates the decomposition of the problem into a hierarchical structure and ensures that the qualitative and quantitative aspects of the problem are taken into account simultaneously in the evaluation process in which expert judgments are taken into account through an even comparison matrix (Saaty 1980; Siekelova et al. 2021). The weights of the various indicators were established by following the steps and procedures recommended by Saaty (1990).

Aggregation and interpretation

The WSSI is the weighted sum of sub-index scores, as shown in the following equation:
formula
(3)
where WSSI is the Water Services Sustainability Index; N is the number of indicators to be aggregated; Si is the value of indicator i or the indicator i sub-index; and Wi is the weight of indicator i. The interpretation of the WSSI is made on the basis of the quartile scale, as shown in Table 2.
Table 2

WSSI interpretation

WSSI valuePerformancePriority of action
 Poor High 
 Poor–Medium High 
 Medium–Good Medium 
 Good Low 
WSSI valuePerformancePriority of action
 Poor High 
 Poor–Medium High 
 Medium–Good Medium 
 Good Low 

Development of the WaSAT

The development of the WaSAT was done using Microsoft Excel and Open as App. Microsoft Excel was used for programming the WSSI calculations, whereas Open as App was used to convert the Excel File into an application. Figure 1 shows the different stages of creating the WaSAT application.

Figure 1

Steps for creating an app on the Open as App platform.

Figure 1

Steps for creating an app on the Open as App platform.

Close modal

The WaSAT is a systematic questioning tool according to six dimensions (economic, environmental, social, technical, institutional, and governance) which makes it possible to assess to what extent the water service management policy implemented in a locality or a municipality promotes the achievement of the sustainability objectives of the service and universal access to drinking water. The tool can be used as an Excel spreadsheet or as an application. The tool is intended for municipal authorities, officials of ministry in charge of rural water supply, water engineers, and researchers.

Results

Scoring grid used by the WaSAT

Table 3 presents the scoring grid used by the WaSAT. This grid allows the evaluation of sustainability levels on the basis of scoring. These scores are based on a five-point scale (fully met (score of 100%); met to a high degree (score of 75%); met acceptably (score of 50%); met to a low degree (score of 25%); and not met (score of 0%)) depending on the criteria met by the service and described in Table 3.

Table 3

Scoring grid

DimensionsIndicatorsWeight (%)Score (%)
Not met (0)Met to a low degree (25)Met acceptably (50)Met to a high degree (75)Fully met (100)
Economic Self-financing capacity 17.84 Bad Good 
Financial autonomy 11.35 Bad Good 
Total coast recovery 4.85  Between 0 and 25 Between 25 and 50 Between 50 and 75 Between 75 and 100 
Environmental Water quality 7.18 Bad Doubtful Good 
Water availability 4.57 Less than 5 l/d/capita 5–20 l/d/capita Over 20 l/d/capita 
Climate risk 2.89 Category C Category B Category A 
Social Affordability 6.20 Too expensive Fair 
Accessibility 3.95 More than 60 mn 10–30 mn Less than 10 mn 
Non-discrimination and equity 2.50 Lack of fair access rules for water services Fair access rules for water services 
Technical Quality of construction 2.96 Bad Average Good 
Frequency of maintenance operations 6.16 Never done Annually Semi-annually Quarterly Monthly 
Access to spare parts 6.54 Lack of spare parts in the Council Spare parts available in the council Spare parts available in the village 
Reliability of water system 4.29 Uncertain Reliable Very reliable 
Institutional Post-construction support to council 1.63 Lack of support to council Existence of support to council 
Post-construction support to service managers 1.63 Not existent Limited Average Good 
Regulation 0.85 Bad Good 
Formalization of contract 0.72 Lack of contract between WPC and Council Existence of contract between WPC and Council 
Organization of the service 0.80 Bad Good 
Governance Skills of water service managers 2.59 Bad Average Good 
Financial flow management 4.09 Bad Average Good 
Participation 6.42 Never Annually Quarterly Monthly Weekly 
DimensionsIndicatorsWeight (%)Score (%)
Not met (0)Met to a low degree (25)Met acceptably (50)Met to a high degree (75)Fully met (100)
Economic Self-financing capacity 17.84 Bad Good 
Financial autonomy 11.35 Bad Good 
Total coast recovery 4.85  Between 0 and 25 Between 25 and 50 Between 50 and 75 Between 75 and 100 
Environmental Water quality 7.18 Bad Doubtful Good 
Water availability 4.57 Less than 5 l/d/capita 5–20 l/d/capita Over 20 l/d/capita 
Climate risk 2.89 Category C Category B Category A 
Social Affordability 6.20 Too expensive Fair 
Accessibility 3.95 More than 60 mn 10–30 mn Less than 10 mn 
Non-discrimination and equity 2.50 Lack of fair access rules for water services Fair access rules for water services 
Technical Quality of construction 2.96 Bad Average Good 
Frequency of maintenance operations 6.16 Never done Annually Semi-annually Quarterly Monthly 
Access to spare parts 6.54 Lack of spare parts in the Council Spare parts available in the council Spare parts available in the village 
Reliability of water system 4.29 Uncertain Reliable Very reliable 
Institutional Post-construction support to council 1.63 Lack of support to council Existence of support to council 
Post-construction support to service managers 1.63 Not existent Limited Average Good 
Regulation 0.85 Bad Good 
Formalization of contract 0.72 Lack of contract between WPC and Council Existence of contract between WPC and Council 
Organization of the service 0.80 Bad Good 
Governance Skills of water service managers 2.59 Bad Average Good 
Financial flow management 4.09 Bad Average Good 
Participation 6.42 Never Annually Quarterly Monthly Weekly 

WaSAT as an Excel file

The WaSAT as an Excel spreadsheet (Supplementary Material 1) is composed of seven sheets or pages (Menu, Welcome, Description of indicators, Normalization of indicators, Evaluation, Summary, Interpretation, and Contact). Some pages (Welcome, Description of indicators, Normalization of indicators, and Interpretation) present the modalities of use, while others (Evaluation and Summary) allow to calculate the WSSI and to present the calculations in the form of a graph. Figure 2 shows the WaSAT menu page.

Figure 2

WaSAT menu page on an Excel spreadsheet.

Figure 2

WaSAT menu page on an Excel spreadsheet.

Close modal

The ‘Welcome’ page briefly presents the WaSAT and the context in which this tool was developed. The ‘Description of indicators’ page presents the dimensions and indicators used in the calculation of the WSSI, while the ‘Normalization of indicators’ page presents the criteria for evaluating qualitative indicators. The ‘Evaluation’ page is used to calculate the WSSI, and the ‘Summary’ page presents the summary of the results and the associated graphs. The ‘Interpretation’ page is devoted to WSSI interpretation methods, while the ‘Contact’ page presents information on the authors of the WaSAT.

WaSAT as an application

The WaSAT as an application is made up of eight pages. The first page entitled ‘Summary’ presents the graphic summary of the results, while page 2 entitled ‘WSSI’ presents the summary of the calculation of the WSSI. Pages 3, 4, 5, 6, 7, and 8, respectively, present the summaries of the calculations of the sub-indexes of the economic, environmental, social, technical, institutional, and governance dimensions. Figure 3 shows the WaSAT as a web application.

Figure 3

Screenshot of the WaSAT as a Web app.

Figure 3

Screenshot of the WaSAT as a Web app.

Close modal

The summary page is the page that opens when you start the application. It presents a graphic summary of the results of the evaluation. The graphs presented are radar types and are seven in number. The ‘WSSI’ page gives the numeric values of the performance of the index dimensions and the value of the index. The ‘Economic’ page presents two columns of results: a column that presents the performance values of the indicators of the economic dimension (dark gray color) and a column that presents the evaluation of each indicator on the basis of the scoring grid (gray color). Only the indicator evaluation data can be changed, while the performance values are calculated automatically by multiplying the evaluation results by the weight of the indicator. This page works much like a calculator. The other pages (environmental, social, technical, institutional, and governance) have the same configuration as the ‘Economic’ page.

Discussion

The WaSAT provides a solid baseline on the sustainability of water services at the village level in rural areas and identifies priority actions to be taken to move services toward sustainability. The tool focuses on rural water services in sub-Saharan Africa in a tropical climate context. The data used by this tool are collected at the level at which services are provided (household or community level). The proposed tool enriches the range of tools developed in the literature to improve access to drinking water and sanitation.

The innovative aspect of the work is the presentation of a new indicator as an adaptation of an existing one because of the need to adapt it to the specificities of rural areas in sub-Saharan Africa. Specifically, the first innovative aspect is to take climate change into account through the climate risk indicator. Climate change is having an impact on the availability of water resources, specific per capita consumption, quality of service, the state of water infrastructure, and the costs of investment and operation of the service (pS-Eau, Acqua-OING, AFD, GRET & AESN 2013). In addition, the risks associated with climate change can comprehensively challenge the sustainability of water services. The second is the introduction of forecasting that is not only retrospective but also forward-looking. For example, climate risk takes into account not only past and present climate variations, but also future climate variations. The same is true of the service's self-financing capacity, which, while analyzing the service's pricing policy, takes into account the price revision due to current and future inflation.

The tool differs, however, from most of the similar tools presented in the literature which focus on the evaluation of projects or programs in the rural water and sanitation sector [WASH Life-Cycle Assessment by McConville & Mihelcic (2007); SAT of Aguasan Group (2010); USAID/Rotary International Sustainability Index Tool (SIT) 2012; WASHCost Tool from WASHCost (2012); SMF by DWA (2013)] or which focus on a sector analysis [Sustainability Snapshot by Carter et al. (2010); WASH Sustainability Sector Assessment Tool from IRC/Aguaconsult (2013); Rural Water and Sanitation Information System (SIASAR) de SIASAR (2016)].

However, the tool has two main limitations. The first is a major drawback to using the WaSAT as an Excel file. These include the number of Excel files to use. Indeed, if a municipality has several water services, each service will have to correspond to an Excel file for an evaluation. This could lead to errors and loss of data due to handling. This difficulty is taken into account in using the WaSAT as an application that allows assessment data to be centralized in a single database. However, using it comes at a cost and requires an internet connection. This makes it difficult to access and use by rural communities in Africa given the precariousness of living conditions in rural areas.

Second, given that the WaSAT is still in the early stages of its development, there is a need to systematically validate its future results. This is necessary to ensure that the tool is linked to the actual durability of the service. However, such an analysis is beyond the scope of this study and would require the collection of data on the water services actually provided in rural areas. Although this is an expensive process, it would increase confidence in the use of the WaSAT. In addition, the tool should be more flexible and appropriate for use in urban and peri-urban areas – not limited to rural interventions – and incorporate data from different levels, for example, going beyond the single level of direct intervention to include higher level enabling environment considerations.

The WaSAT provides a solid baseline on the sustainability of water services at the village level in rural areas and identifies priority actions to be taken to move services toward sustainability. There is a major drawback to using the WaSAT as an Excel file, however. These include the number of Excel files to use. Indeed, if a municipality has several water services, each service will have to correspond to an Excel file for an evaluation. This could lead to errors and loss of data due to handling. This difficulty is taken into account in using the WaSAT as an application that allows assessment data to be centralized in a single database. However, using it comes at a cost and requires an internet connection. This makes it difficult to access and use by rural communities in Africa given the precariousness of living conditions in rural areas. The application of the WSSI will shed light on the state of play of the sustainability of water services and measures aimed at improving water management. The tool is being implemented in eight municipalities in the Mvila Division (Southern region of Cameroon) with quite promising results.

The tool will be implemented in the Mvila Division (Southern region of Cameroon) in collaboration with the eight municipalities of the Division.

All relevant data are included in the paper or its Supplementary Information.

Aguasan Group
2010
Sustainability Assessment Tool (SAT)
.
Available from: http://www.aguasan.ch (accessed 2 February 2020)
.
Carter
R.
,
Casey
V.
&
Harvey
E.
2011
Sustainability Framework
.
WaterAid
,
London
,
UK
.
Carter
R. C.
,
Harvey
E.
&
Casey
V.
2010
User financing of rural hand pump water services. In: IRC symposium: Pumps, Pipes and Promises. Available from: https://www.ircwash.org/sites/default/files/Carter-2010-User.pdf.
DWA
2013
FIETS Sustainability Approach
.
Dutch WASH Alliance
,
Haarlem
,
the Netherlands
.
IRC & Aguaconsult 2013 Wash Sustainability Sector Assessment Tool. Available from: http://www.waterservicesthatlast.org/media/files/wash_sustainability_assessment_tool_beta (accessed 2 February 2020).
Mvongo
D. V.
,
Defo
C.
&
Tchoffo
M.
2021a
Indicator-based rural water service sustainability assessment: a review
.
Water Supply
.
https://doi.org/10.2166/ws.2021.096
.
Mvongo
D. V.
,
Defo
C.
&
Tchoffo
M.
2021b
Sustainability of rural water services in rural sub-Saharan Africa environments: developing a Water Service Sustainability Index
.
Sustainable Water Resource Management Journal
.
https://doi.org/10.1007/s40899-021-00526-8
.
pS-Eau, Acqua-OING, AFD, GRET & AESN
2013
Services d'eau par réseau dans les bourgs et petites villes des pays en développement – Suivi technique et financier et régulation, guide
.
pS-Eau
,
France
, p.
45
.
Saaty
T. L.
1980
The analytic hierarchy process: planning, priority setting, resources allocation
.
Decision Support Software Inc.
,
McLearn, VA
Schweitzer
R.
,
Grayson
C.
&
Lockwood
H.
2014
Mapping of Water, Sanitation and Hygiene Sustainability Tools. IRC Working Paper No. 10, p. 43
.
SIASAR
2016
Conceptual Model SIASAR 2.0
.
Siekelova
A.
,
Podhorska
I.
&
Imppola
J. J.
2021
Analytical hierarchy process in multiple-criteria decision making: a model example
. In:
SHS Web of Conferences
90
,
010195
.
UNICEF
2008
Sustainability Checks
.
Available from: http://www.unicef.org (accessed 2 February 2020)
.
United States Agency for International Development (USAID) & Rotary International
2012
The Sustainable Index Tool (SIT)
.
Available from: http://www.washplus.org/rotary-usaid (accessed 2 February 2020)
.
WASH BAT
2018
Water, Sanitation and Hygiene Bottleneck Analysis Tool: User Guide Version 2, April 2018
. p.
87
.
WASHCost
2012
WASHCost Tool
.
Available from: http://www.ircwash.org/washcost (accessed 2 February 2020)
.
This is an Open Access article distributed under the terms of the Creative Commons Attribution Licence (CC BY 4.0), which permits copying, adaptation and redistribution, provided the original work is properly cited (http://creativecommons.org/licenses/by/4.0/).

Supplementary data