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.
Highlights
Continuous meteorological data of contiguous stations are extremely important for forecasting and planning developmental activities in agriculture
An attempt was made to develop a software code using Microsoft-Excel Visual Basic Application for gap filling of the missing rainfall data based on the “Normal Ratio” method
The rainfall of the 12 community development blocks (CDBs) of Kandhamal district in Odisha state of India were used as an example for this
Summary
Continuous meteorological data of contiguous stations are extremely important for forecasting and planning developmental activities in agriculture. Rainfalls being one of the most important meteorological parameters, numbers of statistical methods are in use for filling of the missing rainfall data with varied logical and technical considerations. Temporal as well as spatial correlation is required for near accurate calculation of missing values of rainfall in a particular station. Normal ratio method (Equation (1)) is one of the existing conventional methods, suitable for gap filling of the rainfall records when the normal annual precipitation at any index station differs from that of the interpolation station by more than 10% [6] [7]. The method is one of the simpler ways of predicting missing values [3], but repeating calculations makes it hectic if the number of records is very large.
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
