Working with yield tables
Scaling individual columns in a table-format yield set

Applies to: Spatial Woodstock, all versions
Date:  12/15/2007

Spatial Woodstock includes a keyword that allows you to proportionally scale yield table values on a yield-set-by-yield-set basis. The software applies scaling to all yield table entries that follow the scale factor declaration. But, what if you only need to scale some and not all yield tables in a yield set? Using a row format, it is easy to apply scale factors to individual tables within a set; however, using a column format, it is not readily apparent how this is done. The purpose of this tech tip is to describe how to scale individual yield tables in a column formatted yield set.

Column formatted yield sets are structured very much like a table of numbers, with yield table names listed in the first row (the header row), and the yield table values listed below (see example below).

*Y ? ? ?
_AGE    yPulp yLogs yVeneer  ySPH  yBA   yQMD   yDomHt
  10    50.2    1.5     0.0   600  13.0   16.6   15.0
  15   129.0   66.2     0.9   598  29.0   24.8   23.0
  20   141.0  226.0    16.3   597  42.0   29.9   30.0
  25   145.0  368.0    71.4   596  53.0   33.6   36.0

Suppose that you wish to scale the volume tables (reduce them by five percent to account for new merchantability specs), but not the structure tables.

To accomplish this, you must declare the scale factor keyword on the line below the table header row (the row containing the table names), and then declare individual scale factors for each column in the table (as shown in the table below).

*Y ? ? ?
_AGE    yPulp yLogs yVeneer  ySPH  yBA   yQMD   yDomHt
*P       95     95    95      100  100    100    100
  10    50.2    1.5     0.0   600  13.0   16.6   15.0
  15   129.0   66.2     0.9   598  29.0   24.8   23.0
  20   141.0  226.0    16.3   597  42.0   29.9   30.0
  25   145.0  368.0    71.4   596  53.0   33.6   36.0

If you do not declare a scale factor for a table column, Spatial Woodstock will use the last declared scale factor. The table below is funtionally equivalent to the table above. In the table below, I did not declare scale factors for the yBA, YQMD and yDOmHt columns, and so Woodstock applies the last declared scale factor to these columns, which is 100 percent.

*Y ? ? ?
_AGE    yPulp yLogs yVeneer  ySPH  yBA   yQMD   yDomHt
*P       95     95    95      100 
  10    50.2    1.5     0.0   600  13.0   16.6   15.0
  15   129.0   66.2     0.9   598  29.0   24.8   23.0
  20   141.0  226.0    16.3   597  42.0   29.9   30.0
  25   145.0  368.0    71.4   596  53.0   33.6   36.0