Title: CalPro: a spreadsheet program for the management of California mixed-conifer stands.
Author: Liang, Jingjing; Buongiorno, Joseph; Monserud, Robert A.;
Source: Gen. Tech. Rep. PNW-GTR-619. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Research Station. 32 p
Publication Series: General Technical Report (GTR)
CalPro is an add-in program developed to work with Microsoft Excel to simulate the growth and management of uneven-aged mixed-conifer stands in California. Its built-in growth model was calibrated from 177 uneven-aged plots on industry and other private lands. Stands are described by the number of trees per acre in each of nineteen 2-inch diameter classes in two species groups, hardwoods and softwoods.
CalPro allows managers to predict stand development by year and for many decades from a specific initial state. Users can choose cutting regimes by specifying the interval between harvests (cutting cycle) and a target distribution of trees remaining after harvest. A target distribution can be a reverse-J-shaped distribution or any other desired distribution. Diameter-limit cuts can also be simulated. Tabulated and graphic results show diameter distributions, basal area, volumes, income, net present value, and indices of stand diversity by species and size.
This manual documents the program installation and activation, provides suggestions for working with Excel, and gives background information on CalPro’s growth model. It offers a comprehensive tutorial in the form of two practical examples that explain how to start the program, enter simulation data, execute a simulation, compare simulations, and plot summary statistics.
Keywords: Mixed conifers, uneven-aged management, economics, ecology, CalPro, simulation, software, growth model, diversity
- We recommend that you also print this page and attach it to the printout of the article, to retain the full citation information.
- This article was written and prepared by U.S. Government employees on official time, and is therefore in the public domain.
- You may send email to email@example.com to request a hard copy of this publication. (Please specify exactly
which publication you are requesting and your mailing address.)
XML: View XML
Liang, Jingjing; Buongiorno, Joseph; Monserud, Robert A. 2004. CalPro: a spreadsheet program for the management of California mixed-conifer stands. Gen. Tech. Rep. PNW-GTR-619. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Research Station. 32 p
Get the latest version of the Adobe Acrobat reader or Acrobat Reader for Windows with Search and Accessibility