Winter 1991
CWE Analysis Automated
Steve Young develops a macro to facilitate complex ERA calculations
Steve Young, hydrologist for the Lassen National Forest has developed a
computer program that makes doing complex CWE analysis using the R-5 method
(with modifications) faster and simpler.
The program runs on a Macintosh inside the Excel spreadsheet application,
and is written in the Excel macro language. With minor modifications, Steve
believes it will also run on a PC running Excel for Windows.
The macro is based on the Lassen NF analytical approach to CWE analysis
but is very flexible and can accommodate most conceivable modifications
and expansions of the R-5 method.
The features of the program include:
Choice of linear or exponential recovery curves, using any healing period.
Analyzes any (defined) number of subbasins in a parent watershed.
Analyzes any number of alternatives.
Automatically generates detailed, permanent worksheets, for existing
(steady and healing), proposed (steady and healing), and total disturbance
for any prediction period.
Analyzes and totals past and proposed activities, even those with different
starting years.
Considers followup disturbance occurring after initial watershed impacts.
Includes possible wildfire impacts.
Generates concise line and area graphs to compare the impacts of alternatives
or to show the source of near-threshold disturbance.
Automatically calculates disturbance coefficients and displays the results
for user review and adjustment.
Allows the user to deliberately magnify the effects of selected activities
on sensitive watershed lands.
You may contact Steve for more information or to arrange to get a copy of
the macro and documentation (free if you supply a disk).
Steve Young, Lassen National Forest, 55 South Sacramento St., Susanville,
CA 96130. DG: S.Young:R05F06A; (916) 257-2151
