Docstoc

3.5.6 Sanitation service level analysis.xlsx - WASHCost

Document Sample
3.5.6 Sanitation service level analysis.xlsx - WASHCost Powered By Docstoc
					Coversheet

Name file                        3.5.6 Sanitation service level analysis
Objective                        Excel file can be used to store, clean and analyse sanitation service levels


Ownership
Contact person                   Jeske Verhoeven
E-mail:                          training@irc.nl




Date start                       10/31/2012
Date last edited


Main language                    English


        Table of content                                   Explanation
WASHCost sanitation service
                                 Sanitation service ladder utilised in WASHCost
ladder
                                 Example data input sheet, completed with example from
Example service level data       Mozambique.

                                 Example analysis of sanitation service levels per technology in
Example service level analysis   Mozambique

                                 Blank service level data input sheet to be used and/or adapted for
Blank sanitation service data    your use
tation service levels



                        This Excel file can be used together with:
                                             Name file
                        Handout 1.5 Sanitation service levels

                        Handout 3.5.3 Sanitation service levels data


                        Handout 3.5.4 Analysing sanitation service levels
                    Content
Explains water service levels and service
criteria
Describes the variables needed to determine
the level of water service

Step-by-step guide on how to analyse water
service levels
1) WASHCost sanitation service ladder
                                      The table (b elow ) shows the sanitation service levels and criteria used by WASH

                                      For more information on sanitation service levels and service criteria see handout


      Service levels                           Accessibility                     Use

                                Each family dwelling has one or more
                                                                     Facilities used by all
Improved service                toilets in the compound with
                                                                     members of HH
                                impermeable slab

                                Latrine with impermeable slab (hh or
                                shared) at national norm distance    Facilities used by
Basic service
                                from hh (in the household compound some members of HH
                                in this example)


                                Access to a latrine without an
Limited service                 (impermeable) slab separating faeces
                                from users                           No or insufficient/
                                                                     occasional use
                                No separation between user and
No service
                                faeces, e.g. open defecation



Definition of latrines sampled
          Latrine                                Definition

Traditional Pit Latrine (TPL)   A pit latrine without an impermeable slab

Traditional Improved Pit        A pit latrine with an impermeable slab made
Latrine (TIPL)                  from local materials

                                A pit latrine with a concrete impermeable
Slab Latrine
                                slab

                                A single or double pit with a safe (often
                                concrete) super structure sitting below an
Ventilated Improved
                                impermeable slab. A ventilation pipe and
Latrine (VIP)
                                screen are standard to reduce odours and
                                flies.

                                A pour or fully flushable latrine connected to
Latrine with Septic Tank        an underground septic tank, with liquid
                                outlet to a soakaway.
on service levels and criteria used by WASHCost .

rvice levels and service criteria see handout 1.5 Sanitationservice levels

                                        Environmental protection
               Reliability (O&M)
                                         (pollution and density)
           Regular or routine O&M
                                      Non problematic
           (inc. pit emptying)
                                      environmental impact disposal
           requiring minimal user
                                      and re-use of safe-by products
           effort

           Unreliable O&M (inc. pit   Non problematic
           emptying) and requiring    environmental impact and safe
           high user effort           disposal




           No O&M (pit emptying)      Significant environmental
           taking place and any       pollution, increasing with
           extremely dirty toilet     increased population density
 This is fictional household survey data on sanitation service levels . Each row contains service level indicators for a
 single household. The data contained is sufficient to generate a sanitation service level for each household. Other
 socio-economic indicators can be added (as poverty status, educational level etc) which may be useful to compare
 with sanitation service level indicators.                                                                                 Other options maybe shared
 Exercise: Review the service level headings and service level calculations (in the orange columns). With this             latrine, school latrine or school              Open defecation Toilet in the compound
 exercise you can use handout 3.5.3 Sanitation service levels data.                                                        latrine.                                       (typical family
                                                                                                                                                                          practices)

                                                                                                                                                                                               (available/not
                                                                                                                                                     Accepted responses         (yes/no)
                                                                                                                                                                                                 available)
  Country coding     Region             District           Commun Househol Area Type                Latrine ownership       Latrine type used             Latrine Code    SA1              SA2
2-1-1-61-1         Cabo Delgado Pemba Cidade               ity
                                                           61 code 1d code Urban                    Household               Traditional latrine           TL-61-1                 No       Available in compound
Platform with      Sanitation service    Which members of HH Sanitation service          Operation and         Is the toilet     Sanitation service level Disposal of faeces and urine         Reuse of faeces Sanitation service
impermeable slab   level Accessibility   use sanitation facilities - level - use level   maintenance, emptying extremely         - reliability (O&M                                            and/or urine    level -
                   Total                 observation                 observed            service available at  dirty?            support)                                                                      environmental
                                                                                         community level                                                                                                       protection
                                                                                                                                                           (Not polluting groundwater & not
                                                                                          (routine, irregular, no
      (yes/no)                              (all/some/no use)                                                         (yes/no)                               untreated in river/High risk of      (yes/no)
                                                                                                  O&M)
                                                                                                                                                               environmental pollution)
SAccessibility 1   SAccessibilityTot     SU1                       SUseTot               SR1                        SR2          SReliability            SEP1                                  SEP2            Senvironment
        No         Limited               Some                      Basic                 No o&m                     No           No service                                                           No
                                                                                                                                                         Not polluting groundwater & not untreated in river    Basic
3) Example service level analysis
                          This worksheet shows an example analysis of the sanitation services levels per tec
                          includes the household sanitation service level, as well as analysis for each indicat

                         Any changes made to the original "sanitation service level data" worksheet will be
                         the data. I n Excel 2003 this can be done by pressing "f9". In Excel 2007 and 201
                         and select "refresh all". With this exercise you can use handout 3.5.4 Analysing s
nitation services levels per technology for the example data. This
ell as analysis for each indicator.

 level data" worksheet will be reflected in these graphs by refreshing
g "f9". In Excel 2007 and 2010 - select the "data "tab on the top ribbon
se handout 3.5.4 Analysing sanitation service levels.
                       This blank workbook can be used to compile your own sanitation service level data for analysis. The formulas in
                       this sheet are set up to generate results according the service level definitionsdefined in the "Example service level
                       data".

                       To construct service level based on different criteria or household responses, you will need to amend the worksheet                           Open defecation Toilet in the compound Platform with
                       to your own needs.                                                                                                                            (typical family                        impermeable slab
                                                                                                                                                                     practices)

                                                                                                                                                                                            (available/not
                                                                                                                                                Accepted responses         (yes/no)                                (yes/no)
                                                                                                                                                                                              available)
 Country coding     Region             District         Commun Househol Area Type               Latrine ownership          Latrine type used        Latrine Code     SA1              SA2                    Accessibility 1
Unique code 1     Region 1    etc...                    ity code d code
Sanitation service    Which members of HH Sanitation service          Operation and            Is the toilet   Sanitation service level Disposal of faeces and urine                    Reuse of faeces Sanitation service
level Accessibility   use sanitation facilities - level - use level   maintenance, emptying extremely          - reliability (O&M                                                       and/or urine    level -
Total                 observation                 observed            service available at     dirty?          support)                                                                                 environmental
                                                                      community level                                                                                                                   protection
                                                                       (routine, irregular, no                                          (Not polluting groundwater & not untreated in
                         (all/some/no use)                                                         (yes/no)                                                                                (yes/no)
                                                                               O&M)                                                       river/High risk of environmental pollution)
SAccessibilityTot     SU1                       SUseTot               SR1                      SR2             SReliability            SEP1                                             SEP2            Senvironment
Fill in data                                    Fill in data                                                   Fill in data                                                                             Fill in data

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:12/28/2013
language:English
pages:14