MissRF: A Visual Basic Application in MS Excel to Find out Missing Rainfall Data and Related Analysis

Pradeep Kumar Mohanty, Dwitikrishna Panigrahi, Milu Acharya

Central Agricultural University, Gangtok, India.
Department of Water Resources, Government of Odisha, Bhubaneswar, India.
Siksha ‘O’ Anusandhan University, Bhubaneswar, India.

DOI: 10.4236/iim.2014.62006                

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.

Keywords

MissRF; Normal Ratio Method; Visual Basic; MS Excel

Conflicts of Interest

The authors declare no conflicts of interest.

References

[1]	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/
[2]	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
[3]	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.
[4]	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/
[5]	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
[6]	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
[7]	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.
[8]	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