Skip to content

Liemberger-Partners/easycalc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

WB-EasyCalc

WB-EasyCalc was designed in 2006 to help water utilities and consultants to properly apply the IWA Water Loss Specialist Group Methodology. During the last 10 years it has become the preferred NRW analysis tool for water utilities around the world. To celebrate its 10th anniversary, version 5 has been launched in August 2016.

The current version is 6.17.

Languages and World Bank Terminology

The pre-set Language is English using the IWA terminology. If you would like to use the World Bank favored terms "Physical Losses" and "Commercial Losses" instead of the IWA terms "Real Losses" and "Apparent Losses" click on the button "change language" and select code 2.

In the World Bank Terminology, the IWA terms "UARL - Unavoidable Annual Volume of Real Losses" and "CARL - Current Annual Volume of Real Losses" were replaced with the World Bank favored terms "MAPL - Minimum Achievable Annual Volume of Physical Losses" and "CAPL - Current Annual Volume of Physical Losses". However, the underlying formula remained of course unchanged.

Currently, the following languages are implemented:

  • "IWA Teminology (English)"
  • World Bank reccomended Terminology (US English)
  • French
  • Deutsch
  • Russian
  • Vietnamese
  • Bahasa Indonesia
  • Español
  • Italian
  • Portuguese (Brazil)
  • Hungarian
  • Arabic
  • Thai
  • Serbian
  • Chinese (1)
  • Chinese (2)
  • Chinese (3)
  • Romanian
  • Bosnian
  • Albanian
  • Georgian
  • Bulgarian
  • Czech
  • Greek

Details

Requirements

WB-EasyCalc is an MS Excel based software, optimized for a screen resolution of 1024 x 768 Pixel

Color Coding

white cells are for data entry dark blue cells are calculated values

General Disclaimer

While every effort has been made by the developers to ensure that WB-EasyCalc is free from error, those using the model do so at their own risk. Liemberger & Partners accept no liability of any nature for losses (direct or indirect) incurred through the use of this model.

The program is protected with passwords which will not be revealed.

GIGO - Garbage in Garbage out!

The user has to be aware that results calculated with this program can be extremely wrong if base data is wrong or incomplete.

General Notes

It is ALWAYS recommended to carry out a thorough leakage analysis based on measurements in the distribution network to support and verify the physical loss figure calculated with this program.

When using this program for the first time, it is recommended to first familiarize with the methodology. A complete set of background reading materials can be downloaded from www.liemberger.cc.

Feedback

Liemberger & Partners would appreciate feedback! Please send your comments to office@liemberger.cc

WB-EasyCalc will be continuously improved and upgraded - revisit www.liemberger.cc from time to time to check for new versions.

Contributions

My thanks go to many friends and colleagues who have helped to improve and complement this free software (and apologies to those that are not mentioned here):

  • Ronnie McKenzie (South Africa) has ensured that the statistical concept used follows the principles brought to the Water Industry by Allan Lambert (UK)
  • Gary McLay (Australia) has detected a few fundamental bugs in the beta version!!!
  • Malcolm Farley has convinced me that the US spelling hurts too much for most people - therefore it is now only one of the language options!
  • Pham Thach (Vietnam) has prepared the translations for the first Non-English version and NT Dan from ECO-Asia has translated additional bits and pieces.
  • Ms. Asel Abylgazieva (Kyrgyz Republic) has kindly translated everything into Russian language
  • Ms. Yulfarida Arini (Indonesia) has prepared the Bahasa Indonesia version that is now appreciated by many PDAMs (water utilities) in her country.
  • Hervé Guibentif (France) has used WB-EasyCalc to analyze the water losses of SIG, the water utility of Geneve, and was so kind to share the French language terms with us. Merci!
  • Philippe Marin (France) who contributed the slogan: ... because the best things in life are free! ...
  • Marcello Schiatti (Italy) was so kind to prepare the Italian language version (thanks also to my friend Dewi Rogers!)
  • Ms. Debora Soares (Brazil) from the water utility of São Paulo (SABESP) was so kind to prepare the Portuguese version.
  • Professor Fabio Garzon Contreras (Columbia) from the Pontificia Universidad Javeriana in Cali has contributed the Spanish translation.
  • Gyula Pálfi (Hungary) from Spiderweb Bt. took the initiative to prepare the Hungarian language version.
  • Mohammed Hossam Sallam, an old friend of mine and a seasoned water loss professional from Jordan pioneered this "first ever" Arabic language version! Shokran!
  • Sher Singh and his team from USAID's ECO-Asia program have jointly with their Thai colleagues from the Provincial Waterworks Authority, namely Khun Kittiya, have produced the Thai language version.
  • Ms. Kelly Arikawa from BBL Engenharia in Brazil was kind enough to make the necessary changes in version 2 of the WB-EasyCalc in the Portuguese language.
  • Ms. Natalia Sicora (from Chisinau, Moldova) has prepared the initial Romanian language version and Ms. Afrodita Popa (from Bucharest, Romania) has made the effort to correct mistakes and improve the terminology. Thanks ladies!
  • Mr. Nebojša Tanasković from Nis, Serbia, was so kind and has prepared the Serbian language version
  • Ms. Annie Chai, a good friend of mine and senior manager at SALCON (Malaysia), kindly provided me with the Chinese language version prepared together with her colleagues.
  • Mr. Edin Rustempasic, a water engineer from Bosnia and Herzegovina, prepared the version in Bosnian language.
  • Mr. Winstone Mulaku from Kenya has made me aware of a mistake in the error margin calculations of one of the performance indicators. Thanks a lot for this!
  • Mr. Kuo-Ding JOU, a Senior Engineer of the Taiwan Water Corporation, has kindly produced two alternative Chinese language versions. Since it is impossible for me to decide which version is the best and most appropriate, I have decided to leave the decision which version to use to the Chinese users of WB-EasyCalc.
  • Mr. Josef Bramberger from the Austrian consulting firm Hydro Ingenieure spotted a serious mistake in the Serbian language translation. Thank you!
  • Albanian language translation kindly provided by the staff of the IPA Energy+Water Economics (London) as part of their support project to the Kosovo water regulatory office – the WWRO
  • Mr. Kevin Horn and the Sachsen Wasser Team in Georgia contributed the translation into Georgian language. Thank you very much Kevin and Sachsen Wasser team!
  • The Bulgarian translation was kindly undertaken by the staff of the team of the Support to NRW Reduction in Bulgaria project co-financed by the European Regional Development Fund through the Operational Programme Environment.
  • Mr. Jörg Kölbl spotted a small bug in version 4.07 - thank you!
  • My friend Pak Budi Sutjahjo revised and completed the Bahasa Indonesia version! Terima kashi!
  • Still small hidden bugs after so many years! Mr. Clive Harrison spotted one in version 4.10 - thank you!

Version 5

  • Once more, my friend Professor Fabio Garzon Contreras (Columbia) from the Pontificia Universidad Javeriana in Cali has heleped me out with the Spanish translation and has highligted a number of small problems of version 5.
  • Mr. Jörg Kölbl spotted again several small bugs! Thank you Mr master-tester!
  • Mr. Tomas Suchacek from the Brno University of Technology surprised me with the Czech language version - much appreciated!
  • My wonderful friend Engª. Milene Aguiar from Restor (São Paulo) made the effort to complete and correct the Portuguese language version. Muito obrigado!
  • Also for version 5 Pak Budi Sutjahjo did the translation into Bahasa Indonesia! Thank you so much my friend!
  • A finance specialist from Albania, Ms Vera Muhaxhiri, was so kind to significantly improve and complete the Albanian language version! Than you so much Vera!
  • My wonderful Romanian friend Alexandru Aldea corrected, updated and complemented the Romanian language version! Thank you my friend!

Version 6

  • Version 6: the relative uncertainty calculation of the UARL has been changed to be in line with Allan Lambert's standard.
  • Mr. Giap Minh Bui from the Asian Development Bank has checked, corrected and completed the Vietnamese lanaguage version! Really appreciated!
  • Mr. Josaia Tagivetaua has spotted a translation issue in the annual water balance and brought it immediately to my attention. Thank you!
  • Ralf de Groot from Waternet spotted a mistake in the French translation and made me aware that Average Pressure was not defined - I have added now (w.s.p.). Hartelijk dank!
  • My friend Bambos Charalambous added another language, in his email to me he wrote: "At long last…. after using the EasyCalc so many times and in so many studies I made time to translate it into the Greek language 😊😊😊… I have to say it has been long overdue…." - thank you Bambos, really appreciated!

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published