enfor consultants ltd. - WOODLOT for Windows 2.1

WOODLOT for Windows 2.1 - Reference Manual

9.1 File Menu
The File Menu is used for:

saving LOT files
importing and exporting data
saving the default polygon, and
exiting the polygon screen.

9.1.1 Save

Saves the current file with the current file name. If there is not a current file name the save as dialog box will appear asking for the new file name.

9.1.2 SaveAs

Saves the current file with a new filename and/or a new location. The file will be saved in the current version's format.

9.1.3 Import WoodStock (INV)

This function imports an INV file from WoodStock. WoodStock was written in 1993-1994 by Sterling Wood Group (not be confused with WoodStock developed in New Brunswick), and is a previous simple model used by some people to compile harvest rates.

WoodStock INV files only contain some information for VDYP but no TIPSY information, harvest parameters or calculation data. Information such as PSYU (used to calculate Waste & Breakage) will need to be added for each polygon. This data will have to be added in one of two ways:

Setting up a default polygon prior to importing, or
Manual editing this data for each polygon.

9.1.4 Import Comma (CSV)

You may import a data file directly into WOODLOT rather than load polygon data manually on the Polygon Data screen using the Import Comma (CSV) feature. Most spreadsheet programs can be saved to a CSV (Comma Delimited Text) file. The sample used in this manual is derived using Excel 97, although earlier versions of Excel, Lotus 123 or Quattro Pro will work just as well. However, you cannot import a file directly in from Excel or other spreadsheets without converting them to a .csv format as described below.

Columns do not have to be in any specific order, but must have a WOODLOT variable name specified to be read into WOODLOT. All other information used will be ignored by WOODLOT. Note: The first row (line) in the CSV file must contain the EXACT WOODLOT variable name as listed in "Appendix 9 - Variables Used in WOODLOT"

Hint on how to create CSV files:
To generate a CSV file for use in WOODLOT from Excel, while in Excel, choose Save As from the File menu. A window will appear asking for the file name, location and type to save as. Make sure that the save as type is set to CSV (Comma delimited) (*.CSV) as shown below. It is recommended to also save the file as a XLS file, otherwise any formulas and formatting will be lost.

When a CSV file is imported into WOODLOT:

WOODLOT adds a new polygon with the mapsheet and polygon name specified in the CSV file.
The new polygon is then updated from the rest of the columns in the CSV file. Any blank information will result in using the default polygon data (refer to section 9.1.7)
You MUST specify a Mapsheet and Polygon number to have a polygon entered.

Values that need to be set to default can be entered as [ ] brackets. During import, any values that are expected to be numbers and are not are set to zero, unless the current value can be set to default. The following describes variables that can be set to defaults, and how the default value is determined.

Variable Name	Description	Default set from
HAR1	First Harvest Age	Calculated minimum cut age (Polygon based)
HAR2	Subsequent Harvest Age	Calculated minimum cut age (Polygon based)
PCNEXT	Partial Cut re-entry age	Settings screen
PCPERC	Partial Cut % removal	Settings screen
REGENDELAY	Regen Delay	Settings screen
OAF1	TIPSY OAF1	Settings screen
OAF2	TIPSY OAF2	Settings screen
VMINCUTAGE	Min. DBH for VDYP	Harvest parameters from the Summary screen
VMINCUTDBH	Min. Age for VDYP	Harvest parameters from the Summary screen
VMINCUTVOL	Min. Volume for VDYP	Harvest parameters from the Summary screen
TMINCUTAGE	Min. DBH for TIPSY	Harvest parameters from the Summary screen
TMINCUTDBH	Min. Age for TIPSY	Harvest parameters from the Summary screen
TMINCUTVOL	Min. Volume for TIPSY	Harvest parameters from the Summary screen

WOODLOT version 2.1 has been updated to allow polygons that already exist to be updated by importing a CSV file. The following window will appear if a duplicate mapsheet, polygon combination already exists in the file.

If you choose NO at this point, only duplicate polygons will be skipped, non-duplicates will be imported.

Note: any columns with header names not listed in "Appendix 9 - Variables Used in WOODLOT" will be ignored by WOODLOT. When an important variable is not found, the following screen will appear. If a keyword shows up in the window that was not meant to be skipped, check it's spelling.

See "Appendix 9 - Variables Used in WOODLOT" for a complete list of all variables names (keywords).

9.1.5 Import Fixed

The fixed format import has not been updated since version 1.0; this function is useful for importing data exported from some software. The CSV import function is up to date and allows simpler editing that the fixed format. A fixed format file can be converted to a comma-delimited format using Excel. Importing fixed file formats in not recommended, as it is more complex than the CSV format.

Sample format.dat file that must be located in the WOODLOT root directory.

TABLE           1	-	4	*Index of Polygon in WOODLOT
AGE             6	-	8	*AgeIn Used only if no SiteIndex
FIZ             19	-	19	*If Species Is FD Then Fiz A-C = Coastal D-Z Interior
UTIL            21	-	25	*Utilization Level
DENSITY         27	-	31	*Initial Density / Stems Per Hectare
TRT             33	-	37	*Treatment Thinned To Stems Per Hectare
PN              50	-	50	*Regeneration P)Planted / N)Natural
OAF1            52	-	56	*Operational Adjustment 1
OAF2            58	-	62	*Operational Adjustment 2
SPECIES1        64	-	66	*Currently Available Species - FD SW HW SS CW LP
SPECIES2        68	-	70	
SPECIES3        72	-	74	
SPECIES4        76	-	78	
SPECIES5        80	-	82	
SPECCOMP1       84	-	86	*Percentage Composition of Stand
SPECCOMP2       88	-	90	
SPECCOMP3       92	-	94	
SPECCOMP4       96	-	98	
SPECCOMP5      100	-	102	
SITE_INDEX1    104	-	105	*Explicit Site Indexes
SITE_INDEX2    107	-	108	
SITE_INDEX3    110	-	111	
SITE_INDEX4    113	-	114	
SITE_INDEX5    116	-	117	
HEIGHT1        119	-	121	*Total Height Of Tree
HEIGHT2        123	-	125	
HEIGHT3        127	-	129	
HEIGHT4        131	-	133	
HEIGHT5        135	-	137

9.1.6 Export Comma (CSV)

Creates a CSV file that can be read by most spreadsheet programs. This file can be modified and then re-imported into WOODLOT. Default values will be show as the current value inside square brackets.

This is a useful feature to check your data.

9.1.7 Save Default Polygon

Data from a "Default polygon" is used:

to insert missing data from polygons in a file that is being imported, or
for the default settings when a new polygon is added to minimize repetitive entries.

It is recommend that, after installing WOODLOT, you create a default polygon for your location. (WOODLOT comes with a default polygon, though this is relevant only to certain coastal sites.)

To create a new default polygon, go to File, and select Save Default Polygon. This will save the data from the current polygon data screen displayed as the data that WOODLOT will use in future applications for the default polygon. You may change this at any point using the same routine as above.

9.1.8 Ok

This item will close the polygon window and open the main menu. This will retain the information from the Polygon Data screen in the computer's active memory (active only while WOODLOT is operating).

You will lose this information if you exit WOODLOT, unless you save the information to a file for subsequent uses, using the Save or SaveAs features.

by Enfor Consultants Ltd.

Last Updated March 1999