Assessment report

Training and Manual for use of Website

tải về 2.61 Mb.
Chuyển đổi dữ liệu18.08.2016
Kích2.61 Mb.
1   ...   17   18   19   20   21   22   23   24   25

8.3. Training and Manual for use of Website.

The document of “User Manual for the Vietnam Urban Water Supply and Sewerage Sector Database Website – Version 2.0” has been prepared for training and guidance on the use of Database Website, including 54 pages in both Vietnamese and English. The PDF version of this document can be downloaded by all users when accessing to the Website’s homepage.


9.1. Development of IBNet Toolkit for Vietnam Database

9.1.1. IBNET Toolkit

In the website www.IBNET.ORG, there exist a toolkit that helped in filling and checking data (true/false) in easily and accurately manner.

The Toolkit has been applied in some countries with IBNET using file temples including code of questions, code of indicator and unit ….

9.1.2. Application of IBNet Toolkit for Vietnam

Vietnam sector database included the following characteristic:

  • The databases included both indicators that used for benchmarking and sector management;

  • In many countries. a utility provides both water supply and wastewater treatment services while in Vietnam these services can be provided by various utilities (may be 3. 2 or 1 utility)

Therefore. WB specialist in coordination with MABUTIP and Consultant developed IBnet Toolkit for Vietnam. The Toolkit is:

  • Developed based on Vietnam’s questionnaire and indicators set;

  • Separated into 02 eexcel files for water supply and wastewater services;

  • Structure of the files as including:

  • To facilitate in filling and comparison data between indicators calculation that developed by Mabutip (automatic calculation in Excel File) may insert questionnaire and indicators set into Toolkit without impact to the functions: checking and detection of data input errors of the Toolkit.

  • Adding Vietnamese language, users required to have skills in excel software and understand the nature of the data inputs as filling numbers or letters, data unit, conventional units ... so they can completely use this Toolkit.

9.2. Application of IBNet Toolkit for Vietnam Sector Database

9.2.1. Application of IBNet Toolkit for Sector Database

Mabutip, Consultant and WB specialist aapplied the Toolkit as testing for water service data in 2013, 2014 and wastewater 2014. The results calculation of the Toolkit have basically matched with the database. Some errors has been detected and to be finalized.

The IBnet Toolkit has been integrated with the sector database at the website: and

Users (Utilities) may download:

  • Toolkit sample from the website at the icon ''Download Vietnamese Toolkit '' and select “Water Toolkit” or Wastewater Toolkit”.

  • All the data related to water services in 2013. 2014 provided by 88 utilities and wastewater treatment service in 2014 by 13 utilities have filled in each respective Toolkit. Users can download the data in the folder ''Data Toolkit'' in the field of water and wastewater treatment services in the Toolbar.


10.1. Conclusions

10.1.1. Completed Tasks

In the contract “ MoC-01-Consulting service for Development of Water and Sewerage Sector Performance Database”. Consultant completed their assignment compliance with the signed contract to maintain, update and improve the sector database as including:

Updated Water Sector Database

  1. Review and revise the performance indicators and questionnaire for water services;

  2. Update the data for water utilities for years of 2013 and 2014;

Development of Sewerage Database

  1. Prepare performance indicators and questionnaire for wastewater treatment services;

  2. Develop sewerage database for year 2014;

Update and improve the developed website

  1. Develop the IBNet Toolkit (World Bank) for Vietnam Water and Sewerage Sector Database and put into operation;

  2. Update and develop a comprehensive website based on for publication of water and sewerage sector database which provides an overview of sector performance and investment in water and drainage sector.

10.1.2. Overall assessment

  1. The questionnaire and indicators set for water and wastewater treatment services focused on the data provided by the utilities. Therefore, the updating data for year 2013 and 2014 did not meet many difficulties of which the quality of data has been improved with higher accuracy and reliability.

  2. With participation of 88 key utilities out of 104 water utilities and 13/15 wastewater treatment utilities, the water sector database for years of 2013 and 2014 and sewerage database for year 2014 seem to be considered as national sector database. It noted that this is first (benchmarking) database on wastewater treatment services.

10.2. Recommendations

10.2.1. Overall recommendations on sector database

Based on the analysis and evaluation of water and sewerage sector database, some recommendations were presented in the Chapter 4 (Water Utility’s Assessment and Recommendations) and Chapter 7 (Wastewater Utility’s Assessment and Recommendations). Additional recommendations are as shown in the below:

  1. Recommendation A1: Measures taken to maintain the sector database in sustainable

The development and maintenance of sector database are essential to ensure the interests of the parties (the community. services providers and local authorities). However it is clear that the update and maintenance of database in regular basic will require a certain resources from the utilities as well as the management agency. On the other hand, the disclosure of transparent information can make anxious for some utilities.

To maintain sustainable of the sector database, it required to take the action plans as following:

  1. For Utilities in charge of water and wastewater treatment services

The utilities should be:

  • Improve awareness of the necessity and benefits of maintaining their own database: indicators in the database will provide a good framework to evaluate the performance of utility (similar to the financial statements report) that used in daily execution and production and will help to create economic and technical benefits as well as investment promotion;

  • Develop a data management system for the assigned functions of the department/units in the utility in data collection, processing, consolidation and reporting;

  • Prepare and issue specific procedures for the data collection, processing, consolidation and reporting;

  • Provide training on these procedures and paid much attention to the new staffs to be in charge;

  • Implement and evaluate the result of performance in regular basis and improve the procedures as needed;

  1. For state management agencies:

The local authorities should ensure the legal basis in data reporting as mandatory requirement for the service providers.

  • The water and drainage activities considered as essential and exclusive services for the whole of the local community. So acted as Client in the Agreement/Service Contracts. the local authorities should include the terms related to providing performance data in the signed contracts;

  • At central level, the Government should issue the provisions on reporting of database in the legal documents on water sector (Amendment Decree or Law);

  • Acting as sector management and oversight functions, MoC should issue guidance on providing and updating sector database including data standardization. Having good experiences in development of safety water supply plans under WHO program, after testing period, the MoC issued Decision No.16/2008/QĐ-BXD and then replaced with Circular No. 08/2012/TT-BXD and up to now almost (56) utilities (by end of year 2015) in the 45 provinces/cities have developed safety water supply plans;

  1. Ensure the human resources to update annually database and maintain the developed website

  • Acting as management agency and oversight functions in the sector, the Ministry of Construction should arrange the assigned staff, equipment and budget to maintain the sector database and the developed website.

  • In addition to the improvements of collecting and processing procedures, the combination and reporting data should also be required to pay much attention.

  1. Recommendation A2: Improve reliability of sector database

In the report of water sector database (2011 and 2012), it indicated that the reliability of the data was not high. It is common not only in our country but also happening in many other countries. The data cannot be accurate in the early years of database development and that will be improved over the years. The reliability of the data for years 2013 and 2014 has been improved significantly. During annual updated, it may correct prompt the unreasonable data provided in the last years. In fact, it found that Urban Water Supply Benchmarking Program carried out by VWSA with the support of WSP/WB conducted from 2002 to 2010, including four benchmarking courses and of which 4th course (2010) for 2009 benchmarking but also included the review and data correction for year 2007 that carried out in 2008 (3th course).

Therefore, the comparison of indicator values in years seems to be relative meanings as they replied on reliable data. Along with improvement of the input data, the reliability of indicators will be improved gradually during years. The input data after the correction will be higher reliability (less deviation or less ridiculous) but did not sure to be corrected. In some cases, there is inconsistency between values of an indicator for same year in various reports (Report of Department of Construction and report of VWSA) although they are based on data provided by the utility, even occurred in the reports of that utility. Therefore, it recommended as following:

  • Utilities should paid much attention to improve the filling, verification and data provision;

  • MoC should pay much attention to review, correction of data inputs provided by the utilities.

  1. Recommendation A3: Distinguish National Statistical Indicator and set of performance indicators of Sector Database

  • In the national statistical index system (issued at Decision No. 43/2010/QD-TTg dated 2/6/2010 by the Prime Minister): collect and publish socio-economic indicators of the city/province and nationwide that served for developing and monitoring of socio-economic programs. These data submitted to the DoCs for consolidation and reporting to the relevant ministries and the General Statistics Office.

  • In sector database: collected and published performance indicators of the utilities that served for Benchmarking aimed at improving the utility’s performance in term of technical and economic. The data provided by the utilities directly to the MoC and used to calculate the (automatic) indicators including indicators of each utility and the composite indicators of the database in that year.

10.2.1. Recommendations for Water Service

The recommendations for water service are presented in the Chapter 4.

10.2.1. Recommendations for Wastewater Treatment Services

The recommendations for wastewater treatment services are shown in the Chapter 7.


  1. Annexes of Chapter 2 – Indicators Set and Questionnaires for Water Services (2015)

    Annex 2.1

    Questionnaires/Data Sheets for Water Services (version 2015)

    Annex 2.2

    Performance Indicators Set for Water Services (version 2015)

  2. Annexes of Chapter 3 – Water Sector Performance Database for Years 2013, 2014

Data Inputs

Annex 3.1

Added Values or Data Inputs Correction

Annex 3.2

Comparison of English and Vietnamese name of Utilities

(The Annex not included in Vietnamese version)

Annex 3.3

Total design capacity of WWTPs (m3/day)

Annex 3.4

Population in service areas

Annex 3.5a

Household Connections

Annex 3.5b

Population served

Annex 3.6a

Amount of Water Abstracted: Surface and Ground Water (000m3/year)

Annex 3.6b

Amount of Water Abstracted: Total surface water and Ground Water (000m3/year)

Surface Water Ratio/Total amount of water abstracted

Annex 3.7

Volume of Water Supplied into Distribution Network

Annex 3.8

Water Billed

Performance Indicators

Annex 3.9

Population Served

Annex 3.10

Capacity Utilization Ration

Annex 3.11

Residential Water Consumption (L/person/day)

Annex 3.12

Non – Revenue Water

Annex 3.13

Percentage of Water Used at WWTPs

Annex 3.14

Meter (not applicable for years 2013, 2014)

Annex 3.15a

Networks – Pipe Breaks

Annex 3.15b

Pipe Development and Renovation or Rehabilitation

Annex 3.16

Quality of Supplied Water

Annex 3.17a

Operation Costs and Revenue

Annex 3.17b


Annex 3.18a

Electricity Consumption

Annex 3.18b

Operational Unit Cost

Annex 3.19


Annex 3.20a

Financial - Revenue, operation costs and debt service ratio

Annex 3.20a

Financial – Increase in HH connections, Investment in HH connections development and Ratio of Fixed Assets.

  1. Annexes of Chapter 5 – Performance Indicators and Questionnaires for Wastewater Treatment Services (2015)

    Annex 5.1

    Questionnaires/Data Sheet for Wastewater Treatment Services (version 2015)

    Annex 5.2

    Performance Indicators for Wastewater Treatment Services (version 2015)

  2. Annexes of Chapter 6 –Sewerage Performance Sector Database for Year 2014

Data Inputs

Annex 6.1

Added Values or Data Inputs Correction

Annex 6.2

Comparison of English and Vietnamese name of Utilities (The Annex not included in Vietnamese version)

Annex 6.3

Cities, Population and WW service coverage

Annex 6.4a

Design parameters - WWTP: Design capacity, Treatment Process

Annex 6.4b

Design parameters - WWTP: Design capacity, Treatment Process

Performance Indicators

Annex 6.5

Performance of WWTPs

Annex 6.6

Electricity Consumption and Staffing

Annex 6.7

Operation Costs

Annex 6.8

Service Fees and Revenue

Annex 6.9

Economic and Financial Matters

  1. Annex of Chapter 8 – Upgrade and expansion of the database website

Annex 8.1

Database structure of the Website

1   ...   17   18   19   20   21   22   23   24   25

Cơ sở dữ liệu được bảo vệ bởi bản quyền © 2019
được sử dụng cho việc quản lý

    Quê hương