MYRLIN Stand tables - Tree data


Tree data layout in worksheet of MYRLIN#1 stand tables module

The tree data worksheet contains measurements from sample plots, a stock survey, or a mixture of both (ie. a stock survey with a sub-sample of plots). Four columns are required for the data. Other data may be present but are not used by MYRLIN. These items are:

The order of the columns is set on the Options sheet, and is not important. The data should however be sorted by Stratum and Plot ID. If this is not done, the data may not be processed correctly. For sample plot data, the Plot ID field must contain the plot number. For stock surveys, this field should be left blank. If stock survey data is mixed with sample plot data (a stock survey with sub-sampling), then the Plot ID should be completed for tree records from the sample plots, and left blank for those outside the plots. For stock surveys, 100% coverage of the entire block is assumed; the area of each block (stratum) must be given correctly in the Areas table..

The stratum or block ID must match an entry in the Areas table. It can be numeric or text. The Plot ID may also be numeric or text, but should in either case be formatted as text.

The species code column contains entries that must match entries in the first column of the species list. The codes can be numeric or text, but again, should be forced to a standard format to avoid ambiguity if numeric codes are used.

Tree diameter must be in cm and in numeric form. Any text data in this column will cause an error.

It may be noted that the column headings are not important, but must not occupy more than one row at the top of the sheet. The sheet name can also be changed. The sheet name has to be indicated on the Options sheet.