The Stand worksheet shows the current stand including the tree list and summary stand characteristics.
Following projection of an an MSS CP there will multiple copies of the stands worksheet, one for each sub-stand.
Immediately following establishment several fields in the tree list may not be available (e.g. increments); "not available" is denoted by "-1".
An empty tree list may appear to contain many Excel errors. These errors disappear once the tree list is populated.
In the following example, only a partial listing of the trees are shown.
The Stand worksheet shows the current stand including the tree list and summary stand characteristics.
Following projection of an an MSS CP there will multiple copies of the stands worksheet, one for each sub-stand.
Immediately following establishment several fields in the tree list may not be available (e.g. increments); "not available" is denoted by "-1".
An empty tree list may appear to contain many Excel errors. These errors disappear once the tree list is populated.
In the following example, only a partial listing of the trees are shown.
The following table defines the tree and stand characteristics. Note that settings from the Options and Establish events may affect the values observed in the Stand worksheet. Among others this includes species utilization, merchantability and volume loss.
| Name | Description |
| trSpp | Local region species code (alphanumeric) |
| trDbh | Tree DBH (cm) |
| trHt | Tree height (m) |
| trAge | Total tree age (years) |
| trBHAge | Age of tree above 1.3 m height |
| trDbhIncr | Current year tree DBH increment (cm) |
| trHtIncr | Current year tree height increment (m) |
| trNum | Local tree number (use-specified for real stands, automatic for simulated stands) |
| Cratio | Tree crown ratio (not currently used) |
| X,Y | Local x-y coordinates for tree location (not currently used) |
| HIDIratio | Ratio: current height increment / current DBH increment (m/cm) |
| HDratio | Ratio: trHt/trDbh |
| trBaHa | Basal area (m2/ha) for the tree (trBa*trpha) |
| stBagt | stand basal area/ha in trees with DBH > trDbh |
| stCbagt | Conifer stand basal area/ha for trees with DBH > trDbh |
| stDbagt | Deciduous stand basal area/ha for trees with DBH > trDbh |
| trSppGrp | Internal species group code (Dec = deciduous, Con = coniferous) |
| trMGMspp | Internal MGM species code |
| PctRank | Quantile (%/100) rank for the tree |
| trPsurv | Currrent year survival probablility |
| trVol | Tree volume from stump height to top diameter inside bark (ib) for trees of all species with height> 1.3 m (DBH > 0). This definition is used to be consistent with the stand summary characteristics that typically include trees of all species with DBH > 0. |
| trUtil | TRUE if species is utilized and tree DBH > 0 otherwise FALSE |
| trVRF | tree Volume Reduction Factor from Options event setting (decay, waste, breakage) |
| trSppIdx | Internal tree species index number (1-origin on worksheet) |
| trMGMSppIdx | Internal MGM species index number (1-origin on worksheet) |
| trJuv | TRUE for trees with DBH < 4.0 cm otherwise FALSE |
| trSWGGR | Total SW basal area for trees with DBH > trDBH |
| trPLGGR | Total PL basal area for trees with DBH > trDBH |
| trDECDBHGR | sum of DBH for DEC trees with DBH > trDBH |
| trSWDBHGR | sum of DBH for SW trees with DBH > trDBH |
| trPLDBHGR | sum of DBH for PL trees with DBH> trDBH |
| trVolSurvGrth | Current annual volume growth of survivor trees (alive at both beginning and end of the growth year) between stump height and top dib for all trees with height > 1.3 m (DBH > 0) |
| tmpKey | Internal sequence number for trees |
Stand worksheet summary statistics (Range: B10-AH17; sums and averages are based on trees of all species with DBH > 0). Note: internally there is also a “red” state for the Stand worksheet that only applies when writing stand characteristics to the Yields worksheet. Under normal circumstances the user will never see the “red” state. In the “red” state, the trUtil definition changes to include only trees of utilized species with DBH > minDBH.
| Column ID | Description |
| Stand Summary | Stand component ID: ALL, Con, Dec, Sw, Pl, Aw, Sb representing species aggregation groups; all species will be placed into these groups |
| Site index | Average height of dominant/co-dominant (or top height) trees using the regional site index curves. All are currently reference age 50 years. |
| stAvD | Average DBH (cm) of all trees with DBH > 0 |
| stQMD | Quadratic mean diameter of all trees with DBH > 0 |
| stmaxD | Maximum DBH |
| stAvDincr | Average Diameter increment (cm) of all trees with DBH > 0 |
| stAvH | Average height of all trees with DBH > 0 |
| stTopH | Average height of 100 largest DBH trees |
| stTopHIncr | Average current annual height increment for top trees (100 largest DBH/ha) |
| stmaxH | Maximum height |
| stAvAge | Average age of all trees |
| stAvBHAge | Average BH age (age at height 1.3 m) |
| stBa | Total basal area (m2 / ha) |
| stDen | Density of trees / ha |
| stNuDen | Density/ha for all trees with HT < 1.3 m |
| stTotDen | Density/ha for ALL trees |
| strelBa | Component basal area as proportion of stBa (ALL) |
| strelDen | Component density as proportion of stDen (ALL) |
| strelTotDen | Component density as proportion of stTotDen (ALL) |
| stSF | Average square Spacing for stDen as proportion of stAvH |
| stVol | Sum (trVol * trVRF) for trees with DBH > 0 |
| stGrVol | Sum of tree volumes for trees with DBH > 0 |
| stMatDen | Total density/ha of trees with DBH > 4.0 cm |
| stJuvDen | Total density/ha of trees with DBH <= 4.0 cm |
| stAvJvHt | Average height (m) for trees with DBH <= 4.0 cm |
| stTopD | Average DBH for 100 largest DBH trees/ha |
| stDenDead | Current year density/ha of dead trees (all trees of all species) |
| stBaDead | Current year basal area/ha of dead trees |
| stVolDead | Current year gross volume/ha of dead trees |
| stBaSurvGrowth | Current year basal area/ha growth of survivor trees |
| stVolSurvGrowth | Current year gross volume/ha growth of survivor trees |
| stMAI | Gross volume/ha MAI (stGrVol/standAge) |
| stMaxMAI | Maximum stMAI encountered up to the last yield report |
The Stand Table worksheet is a PivotTable and Pivot Chart linked to the trees found in the Stand worksheet. An example follows:
