TY - CONF Y1 - 2020/// PB - Institute of Physics Publishing SN - 17578981 A1 - Lim, J.R. A1 - Kutty, S.R.M. A1 - Ghaleb, A.A.S. A1 - Almahbashi, N.M.Y. A1 - Al-Sabaeei, A.M. UR - https://www.scopus.com/inward/record.uri?eid=2-s2.0-85086717020&doi=10.1088%2f1757-899X%2f849%2f1%2f012094&partnerID=40&md5=0afcc2ee790ff31a275e33bad9434cd5 VL - 849 AV - none N1 - cited By 1; Conference of 4th International Conference on Construction and Building Engineering and 12th Regional Conference in Civil Engineering, ICONBUILD and RCCE 2019 ; Conference Date: 20 August 2019 Through 22 August 2019; Conference Code:160702 N2 - This paper presents computation of Dead-End System for Water Reticulation using Excel Spreadsheet. An on-going project entitled Regional Operations Center (ROC) located in Melaka, Malaysia was taken as a case study for this research in which all the information needed such as water demand, tapping pressure and location were referred. In a Civil and Structural consulting firm, a great amount of time (approximately 5 hours) had been taken in performing Dead- End analysis. Furthermore, the computation of design by the engineers is a tedious process as the previous spreadsheet contains wrong and insufficient information. With that, this research is aimed to design a Dead-End System Calculation which can compute the necessary information needed in Water Reticulation. As well, the study aims to verify the accuracy of the above said calculation spreadsheet by using EPANET which is a modelling tool for drinking water distribution. This research was done first by designing the calculation spreadsheet using preliminary information from ROC. Then, the exact same design was computed by using EPANET. Next, comparison of results taken from both methods was carried out. Lastly, the comparison on time taken to compute water reticulation design between the previous available spreadsheet and the calculation spreadsheet designed through this research was done. The verified calculation spreadsheet will allow users to get hydraulic information such as velocity, optimum pipe size, residual pressure and total head loss. © Published under licence by IOP Publishing Ltd. TI - Development of dead-end system calculation model for water reticulation design using Microsoft Excel with optimized algorithm: A case study at regional operations center (ROC) Melaka, Malaysia ID - scholars13146 ER -