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

Mohanty, Pradeep Kumar; Panigrahi, D.; Acharya, Milu

doi:10.4236/iim.2014.62006

Cited by 3 publications

(2 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In the RN process, rainfall P, at station A is estimated from the normal of the monthly or annual precipitation of the station in question and those of the riparian stations for the period of missing data at the station in question according to The following equation [9]: …”

Section: Methods Used For the Homogenization Of Datamentioning

confidence: 99%

Rainfall Variability and Water Supplies in the Diarha Watershed (Tributary of Gambia River)

Thiaw¹

2017

HYD

View full text Add to dashboard Cite

Abstract:The present study consisted of analyzing the spatial and temporal variability of the rainfall series in the Diarha watershed between 1921 and 2014, using the Nicholson indices, the stationarity tests and the Thiessen polygons method for spatial analysis, to quantify surface water supplies and to determine the impact of this rainfall variability on the hydrology of the basin. The results show that the rainfall series are not stationary. They show breaks between 1965 and 1979 (with 1967 as the year of rupture for 6 of the 10 stations in the basin). From this break-up period (1967) to the present day, average annual rainfall decreased by 10.5%. On a monthly basis, it appears that precipitation decreased significantly for almost every month between the two periods. On a daily basis, the analysis of the daily rainfall fractions reveals a tendency to decrease the average annual rainfall over 40 mm (which are considered to be the heavy rains) from years of rupture. At the spatial scale, the variability of annual precipitation is marked by a translation of isohyets towards the South from the decades 1971-1980 and 1981-1990. During this period, the decline in rainfall resulted in a shift of the isohyets towards the south in the less rainy zone in the north (in the South Sudanian domain); while the latter are tightening in the "strong" precipitation zones which are located in the South (in the Guinean climate domain) and in the Center-east of the basin. On the other hand, a slight trend of rainfall recovery is noted during the decades 1991-2000 and 2001-2010. At the same time, the flows of the Diarha vary from one year to another according to the precipitated water slides on the basin and the ETP. To this must be added the influence of pedology and geology (the river flowing over the Proterozoic and Paleozoic formations of the Birrimian basement), but also of the high topography of the basin, in this case the relief and its slope system. All these factors combine in space and time to allow for high values of basin runoff.

show abstract

Section: Methods Used For the Homogenization Of Datamentioning

confidence: 99%

Rainfall Variability and Water Supplies in the Diarha Watershed (Tributary of Gambia River)

Thiaw¹

2017

HYD

View full text Add to dashboard Cite

show abstract

“…The missing data for some of the stations were filled using the Normal Ratio Method (NRM). The NRM has been widely used to fill in missing rainfall data [41,42]. In NRM, the missing values are calculated based on the available rainfall data of nearby rain gauge stations (at least three stations).…”

Section: Data Collectionmentioning

confidence: 99%

Integrated Approach to Addressing Flood Risk in Sri Lanka’s Deduru Oya Basin: Implications for Water-Food-Land-Energy Nexus

Wanninayake,

Ünver,

Nianthi

et al. 2024

Preprint

View full text Add to dashboard Cite

Sri Lanka's vulnerability to climate change-induced natural disasters, particularly floods, under-scores the urgent need for an integrated approach to disaster risk management (DRM) that ad-dresses the interconnected challenges within the water-food-land-energy nexus. The Deduru Oya basin, located in the north-western region, exemplifies this vulnerability, with its predominantly intermediate climatic zone susceptible to flooding. While the focus has traditionally been on flood risk reduction, it is imperative to recognize the broader implications of floods on water, food, land, and energy systems. This study aims to strengthen data acquisition and management efforts to better understand rainfall trends and their impact on the water-food-land-energy nexus in the Deduru Oya basin. By compiling 60 years of rainfall data and conducting time series analysis, we observed a decreasing trend in monthly rainfall, particularly during the South-West Monsoon, Second Inter Monsoon, and North-East Monsoon seasons. These findings have significant implica-tions for water availability, agricultural productivity, land use patterns, and energy generation in the basin. Moreover, the malfunction of stakeholders' responsibilities for local-level flood risk management exacerbates the challenges faced by communities living in flood-prone areas. By in-tegrating insights from this study into flood risk management strategies, stakeholders can develop holistic approaches that not only mitigate flood risk but also enhance resilience across the water-food-land-energy nexus. This interdisciplinary approach will inform policymakers, flood manag-ers, practitioners, and the community in formulating effective strategies to address the multifacet-ed challenges posed by floods in the Deduru Oya basin and beyond.

show abstract

Excel Templates: A Helpful Tool for Teaching Statistics

Quintela-del-Rı́o

Francisco‐Fernández

2017

The American Statistician

View full text Add to dashboard Cite

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

Cited by 3 publications

References 5 publications

Rainfall Variability and Water Supplies in the Diarha Watershed (Tributary of Gambia River)

Rainfall Variability and Water Supplies in the Diarha Watershed (Tributary of Gambia River)

Integrated Approach to Addressing Flood Risk in Sri Lanka’s Deduru Oya Basin: Implications for Water-Food-Land-Energy Nexus

Excel Templates: A Helpful Tool for Teaching Statistics

Contact Info

Product

Resources

About