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.

 

 

 

HSU Home Page

Geology Home Page

Geology 531 Home Page