Humboldt State
University Department of Geology
Geology 531 Excel Macros & Templates for
Hydrology
These hydrologic macros and spreadsheet templates require Excel
5.0 or later. Documentation is in Adobe Acrobat PDF format.
You will need the Adobe Acrobat reader or browser plug-in to view
them. You can obtain it for free from this link: Acrobat
Reader.
Note: if these do not automatically start downloading when
you click on the link, it is due to a misconfiguration of your
browser (i.e., it's not set to save Excel files to disk). If you run
into this problem, click on the link, hold the mouse button down
(right button on a PC), and choose "Save this link as..." in Netscape
or "Save target as.." in MS Explorer. Some of the files have names
longer than eight characters. If you are running Windows 95 or
earlier, you will need to download these using the "save as"
procedure above and rename the file to something 8 characters or
shorter, not including the three-letter extension (e.g. .xls or
.xlm)
- Relative
humidity from sling psychrometer measurements
(template)
- Computes relative humidity from wet-bulb depression.
-
- Saturation
vapor pressure (template)
- Calculates saturation vapor pressure from air
temperature in °F
-
- Thornthwaite
estimate of potential evapotranspiration (template)
- Calculates potential evapotranspiration (PET) using
Thornthwaite heat-index method. Required input data are monthly
mean temperatures and latitude. Template has built-in table for
daylight-hours adjustment based on month and latitude.
-
- Blaney-Criddle
estimate of potential evapotranspiration (template)
- Calculates potential evapotranspiration (PET) using
Blaney-Criddle method. Required input data are monthly mean
temperatures and annual crop factor. Template has built-in table
for daylight-hours adjustment based on month and latitude.
-
- Discharge
- Macro to compute water discharge from current-meter data using
velocity-area method.
-
- Instructions
for Discharge
- Adobe Acrobat pdf file with instructions for using
Discharge.
-
- Stream
survey template, English units
- Template for reducing level survey data where tape is
stretched approximately horizontal.
-
- Stream
survey example
- Worksheet showing use of the stream survey template.
-
- PebbleSort
- Macro to sort pebble count data and bin it into size classes.
Prepares data for size analysis with particle size macro
Ptxsz.
-
- Instructions
for PebbleSort (pdf format)
-
- Particle
Size (Ptxsize)
- Macro to analyze pebble count or sieve particle size data and
compute particle size distribution and distribution
parameters.
-
- Instructions
for Ptxsize (pdf format)
-
- Lintrp (linear
interpolation) self-extracting
archive for Mac self-extracting
archive for PC
- Macro to linearly interpolate between survey points or points
in a time series. Especially useful for comparing repeated
cross-section surveys. Includes instructions in pdf format and
example test files.
-
-
-
Andre Lehre
Last updated: 4 October 2002
-