Site Index Models
with Office on Line
Software for the
interior spruce, lodgepole pine, and trembling aspen site index models from
Hu, Z. and García, O. A height-growth and
site-index model for interior spruce in the Sub-Boreal Spruce
biogeoclimatic zone of British Columbia. Canadian
Journal of Forest
Research 40(6), 1175–1183. 2010. doi:10.1139/X10-075
Batho, A. A site index model for lodgepole pine in
the Sub-Boreal Spruce biogeoclimatic zone of British Columbia.
University of Northern British Columbia. M.Sc. Thesis.
Batho, A., and García, O. A site
index model for lodgepole pine in British Columbia. Forest Science 60(5), 982-987. 2014. doi:
García, O. Building a dynamic growth model for
trembling aspen in Western Canada without age data. Canadian
Research 43(3), 256-265. 2013. doi:
The spreadsheets mimic the functionality of the BC Ministry of Forests SiteTools
package. There are two versions:
Instructions are included in the first spreadsheet page.
- With macros. Contains user
defined functions, requiring a medium security setting and accepting to
enable macros. Recommended if you have administrator permissions
for this. The user defined functions are available for use
in other applications.
- No macros. No security
requirements. Use this if you are not allowed to run unsigned
macros. Because of tricky iteration programming this version may
be somewhat less robust, it fails to compute some extreme entries, and
there are minor cosmetic issues.
The software runs with Microsoft Excel 2000 or higher, and
with recent versions of LibreOffice or OpenOffice. The user defined
functions appear under the category "SiteSheets" in Excel 2010, under
Defined" in older Excel versions, and are not listed but available in
Tip: To estimate the site index
for a particular stand, go to the table of Site Index by Age and
Height, and type the stand values in the first (green) entries for age
Google Docs on-line
version (experimental). Link.
For any questions or comments please contact Oscar Garcia at email@example.com
or (250) 960-5004.
Back to: G&Y
Chair home page... Personal