Skip to Main Content
U.S. Forest Service
Caring for the land and serving people

United States Department of Agriculture

Home > Search > Publication Information

  1. Share via EmailShare on FacebookShare on LinkedInShare on Twitter
    Dislike this pubLike this pub
    Author(s): Jingjing Liang; Joseph Buongiorno; Robert A. Monserud
    Date: 2006
    Source: Gen. Tech. Rep. PNW-GTR-674. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Research Station. 42 p
    Publication Series: General Technical Report (GTR)
    Station: Pacific Northwest Research Station
    PDF: Download Publication  (2.87 MB)


    WestProPlus is an add-in program developed to work with Microsoft Excel to simulate the growth and management of all-aged Douglas-fir–western hemlock (Pseudotsuga menziesii (Mirb.) Franco–Tsuga heterophylla (Raf.) Sarg.) stands in Oregon and Washington. Its built-in growth model was calibrated from 2,706 permanent plots in the Douglas-fir–western hemlock forest type in Oregon and Washington. Stands are described by the number of trees per acre in each of nineteen 2-in diameter classes in four species groups: Douglas-fir, other shade intolerant species, western hemlock, and other shade-tolerant species.

    WestProPlus allows managers to predict stand development by year and for many decades from a specific initial state. The simulations can be stochastic or deterministic. The stochastic simulations are based on bootstrapping of the observed errors in models of stand growth, timber prices, and interest rate. When used in stochastic simulations, this bootstrap technique simulates random variables by sampling randomly (with replacement) from actual observations of the variable, rather than from an assumed distribution. 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 by log grade, 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 West-ProPlus's models. 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.

    Publication Notes

    • You may send email to to request a hard copy of this publication.
    • (Please specify exactly which publication you are requesting and your mailing address.)
    • 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.


    Liang, Jingjing; Buongiorno, Joseph; Monserud, Robert A. 2006. WestProPlus: a stochastic spreadsheet program for the management of all-aged Douglas-fir–hemlock forests in the Pacific Northwest. Gen. Tech. Rep. PNW-GTR-674. Portland, OR: U.S. Department of Agriculture, Forest Service, Pacific Northwest Research Station. 42 p


    Google Scholar


    WestProPlus, simulation, growth model, Douglas-fir, western hemlock, management, economics, ecology, diversity, wood quality, risk, stochastic, deterministic

    Related Search

    XML: View XML
Show More
Show Fewer
Jump to Top of Page