The Hydrogeology Toolbox
GeoVES XL
is a spreadsheet for modelling vertical electrical
soundings (VES) in the Schlumberger array. It can handle up to 8 layers
using Gosh linear filters, and do a quick sensitivity analysis. Latest
update:
GeoVES XL V1.3 (16.11.03)
Hand Pump XL is a spreadsheet for interpreting
short term pumping and recovery tests carried out in low yielding boreholes
destined for the installation of hand pumps. The extrapolated drawdown is
calculated at the end of the dry season, and the specific drawdown used to
recommend pump installation depths. Latest update:
Hand Pump XL V1.0 (16.11.03)
Step Test XL is a spreadsheet for interpreting variable rate (step)
discharge pumping tests, using the Bierschenk-Wilson approach. Latest
update:
Step Test XL V1.0 (16.11.03)
Cooper-Jacob XL is a spreadsheet for interpreting pumping tests using
the semi-logarithmic straight line analysis. Latest update:
Cooper-Jacob XL V1.0 (16.11.03)
Recovery XL is a spreadsheet for interpreting recovery test data
using the Theis-Jacob straight line technique. Latest update:
Recovery XL V1.0 (16.11.03)
Safe
Yield XL is a spreadsheet for estimating the sustainable yield of a
well. It calculates the maximum well yield at constant and intermittent
pumping rates using the Cooper-Jacob equation. The drawdown at the of the
dry season is estimated for various distances from the pumping well, and the
required recharge area is derived for a range of recharge rates. Latest
update:
Safe Yield XL V1.0 (16.11.03)
Water
Demand XL is a spreadsheet for calculating current and projected
water demands. It is based on the March 2003 Small Towns Sector Policy
Design Guidelines of the Community Water Supply and Sanitation Agency,
Ghana. Latest update:
Water Demand XL V1.1 (16.11.03)
Ryznar
XL is a spreadsheet for calculating the Ryznar stability index. This
is an indicator of the corrosive/encrusting nature of the groundwater. The
spreadsheet also estimates number of well volumes emptied before the water
quality sample was taken. Latest update:
Ryznar XL V1.0 (16.11.03)
GeoPiper
XL is a spreadsheet for presenting water quality data on a piper
plot. Latest update:
GeoPiper XL V1.0 (16.11.03)
