Research ArticleOpen AccessGoogle Scholar indexed
MissRF: A Visual Basic Application in MS Excel to Find out Missing Rainfall Data and Related Analysis
Department of Water Resources, Government of Odisha, Bhubaneswar, India
Central Agricultural University, Gangtok, India
Siksha ‘O’ Anusandhan University, Bhubaneswar, India
- 1 Department of Water Resources, Government of Odisha, Bhubaneswar, India
- 2 Central Agricultural University, Gangtok, India
- 3 Siksha ‘O’ Anusandhan University, Bhubaneswar, India
Intelligent Information Management·Volume 06 (2014)·Pages 38–44·Published 17 March 2014·DOI10.4236/iim.2014.62006
Copy link · social · email
Abstract
Hydrological analyses are often encountered with many missing periods of rainfall while designing developmental action plans for inaccessible and disadvantageous area. Visual basic based application software (to run in MS Excel) was developed to calculate and autofilled the missing rainfall data using widely followed Normal Ratio Method. The operational details of the software are described in the paper.
KeywordsMissRFNormal Ratio MethodVisual BasicMS Excel
- Wahab, K.A. (2009) Application of Fuzzy Logic to Simulation of Rainfall in Kerayong River Catchment. M.Sc. (Civil Engineering) Thesis, Universiti Teknologi, Mara. http://eprints.uitm.edu.my/6136/
- Roman, U.C., Patela, P.L. and Poreya, P.D. (2012) Prediction of Missing Rainfall Data Using Conventional and Artificial Neural Network Techniques. ISH Journal of Hydraulic Engineering, 18, 224-231. http://dx.doi.org/10.1080/09715010.2012.721660
- Yozgatligil, C., Aslan, S., Iyigun, C. and Batmaz, I. (2012) Comparison of Missing Value Imputation Methods in Time Series: The Case of Turkish Meteorological Data. Theoretical and Applied Climatology, 112, 143-167.
- Kajornrit, J., Wong, K.W. and Fung, C.C. (2012) A Comparative Analysis of Soft Computing Techniques Used to Estimate Missing Precipitation Records. International Telecommunications Society 19th Biennial Conference, ITS 2012, Bangkok, 18-21 November 2012, 9 Pages. http://researchrepository.murdoch.edu.au/11393/
- Gadgay, B., Kulkarni, S. and Chandrasekhar, B. (2012) Novel Ensemble Neural Network Models for better Prediction using Variable Input Approach. International Journal of Computer Applications, 39, 37-45. http://dx.doi.org/10.5120/5082-7268
- Tang, W.Y., Kassim, A.H.M. and Abubakar, S.H. (1996) Comparative Studies of Various Missing Data Treatment Methods. Atmospheric Research, 42, 247-262
- Hagos, B. (2011) Hydraulic Modeling and Flood Mapping of Fogera Flood Plain: A Case Study of Gumera River. M.Sc. (Civil Engineering) Thesis, Addis Ababa University, Addis Ababa.
- Räsänen, T.A., Koponen, J., Lauri, H. and Kummu, M. (2012) Downstream Hydrological Impacts of Hydropower Development in the Upper Mekong Basin. Water Resources Management, 26, 3495-3513. http://dx.doi.org/10.1007/s11269-012-0087-0