16. Creating, Editing and Referencing Tables

TreeAge Pro can store indexed tables of numeric values that represent parameters in your model. Here are some basic facts about tables:

• Tables store a 2-dimensional grid of data which can be referenced within a model.

• Every table has an index column and one or more value columns.

  • A table can up to 512 value columns and up to tens of thousands of rows.

• Each row’s index value must be unique, but indexes are not required to be consecutive integers.

• Tables are referenced by providing an index value in a table lookup, and a value is returned.

  • You should also provide a value column in table lookups if there are multiple value columns.

• Tables can linearly interpolate between rows and columns when there is no direct match in the table.

• Only numeric values (no variables or formulas) can be entered in a table.

• A table can represent a parameter’s empirical probability distribution to sample from during Monte Carlo simulation.

• Table Values can be loaded into a table in a variety of ways, including: paste tab-delimited text; edit via the Excel add-in; manually enter index-value combinations. These will be described in the sections which follow.

Tables are typically created and stored with models in *.trex files. It is also possible to store tables in a global table file, but this is not recommended.