It is recommended that you keep the Help file open and alternate between the Help file and Excel to duplicate the various phases of the design and test of the crop plan. In the following instructions, the buttons shown in parentheses are for illustration only. You must use the MGM Toolbar in the MGM workbook when initiating an action with one of the buttons. Click the MGM Toolbar Open button () to start a new crop plan. Click on the Untitled entry and press OK. When prompted, click OK to delete the existing Crop Plan. It should look something like:
Crop Plans | Untitled | Saved: 8/11/00 12:31:24 PM | |||
Stand Age | Year | Event | Settings | ||
Crop Plans | CropPlansID := Untitled | ||||
Crop Plan | CropPlanID := Untitled | ||||
Options | |||||
Establish | |||||
Grow | |||||
End |
- Right-click on the Crop Plans event to make it the active event (highlighted in yellow).
- Press the Edit button () to activate the Edit Crop Plans dialog.
- To specify a new crop plans identifier, replace Untitled with MGM Example 3.
- Press OK.
- Right-click on the Crop Plan event to make it the active event (highlighted in yellow). You can also click the Move Down to Next Crop Plan Event button () to activate the Crop Plan event.
- Press the Edit button () to activate the Edit Crop Plan dialog.
- To specify a crop plan identifier, replace Untitled with Help Ex. 3 - MSS Herb
- Press OK.
- Click the Move Down to Next Crop Plan Event button () to activate the Options event.
- Click the Edit button ().
- If necessary click on the Alberta tab to identify the appropriate region.
- If necessary, click on the EcoRegion option button to identify the Sub-Region.
- Select the Central Mixedwood sub-region from the alternatives presented in the drop-down box.
- Select the Merchantability tab, set the (Min Dbh (cm) to 13.51 (15cm stump) Top Dib (cm) to 10, Stump height (m) to 0.3, Volume Loss (%) to 0)
- Select the Species tab, all species should be selected.
- Select the Other Setting tab, browse for the Stands Workbook by clicking the button, choose the MGM Stands.xls workbook. Note: this file take precedence over the file name set in the "Set workbook names" in the MGM tools dialogue.
- Select the Other Setting tab, MAFLAG (invoke stand breakup) should be checked.
- Click OK.
- Click the Move Down to Next Event button () to activate the Establish event.
- Click the Edit event button ().
- Click on the Trees (Stand age<= 25) tab to establish the trees.
- Set - Stand Settings
Stand ID - AwSw
Stand Wt - .4
Stand Age - 14
Year - 2000
Random Seed - sets a starting random number if you choose, for our example it should read - 0.2905
Gap Area Loss % - 20 - AW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)
Stand Origin - PerfSurveyAllTrees
Site Index - 16Create a tree list entry for aspen:
Species - Aw
Av Density/ha - 3400
Av Tree Age - 14
Av Ht - 4.4
stDev Ht - .9
Max Ht - 5.9
Av DBH - 3.3stDev DBH - 0.495
Press the Add button in the Tree List Parameters box.
-
SW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)
Stand Origin - PerfSurveyAllTrees
Site Index - 16Create a tree list entry for aspen:
Species - Sw
Av Density/ha - 1800
Av Tree Age - 14
Av Ht - 1.5
stDev Ht - .6
Max Ht - 2.4
Av DBH - 1.7
stDev DBH - .255
Press the Add button in the Tree List Parameters box.Press OK.
- Click the MGM Toolbar Save button() to save the Crop Plans worksheet into the MGM Crop Plans workbook. The Crop Plans worksheet is saved in the Crop Plans workbook using the CropPlansID setting as the worksheet name. If a worksheet with the same name exists, you are queried for permission to replace the existing worksheet.
-
Click the Move Down to Next Crop Plan Event button () to activate the Grow event.
- Click your right mouse button and choose Insert event .
- Insert an new Establish Event
- Click on the Trees (Stand age<= 25) tab to establish the trees.
- Set - Stand Settings
Stand ID - Sw - Herb
Stand Wt - .6
Stand Age - 14
Year - 2000
Random Seed - sets a starting random number if you choose, for our example it should read - 0.2905
Gap Area Loss % - 20 - AW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)
Stand Origin - PerfSurveyAllTrees
Site Index - 16Create a tree list entry for aspen:
Species - Aw
Av Density/ha - 3400
Av Tree Age - 14
Av Ht - 4.4
stDev Ht - .9
Max Ht - 5.9
Av DBH - 3.3stDev DBH - 0.495
Press the Add button in the Tree List Parameters box.
-
SW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)
Stand Origin - PerfSurveyAllTrees
Site Index - 16Create a tree list entry for aspen:
Species - Sw
Av Density/ha - 1800
Av Tree Age - 14
Av Ht - 1.5
stDev Ht - .6
Max Ht - 2.4
Av DBH - 1.7
stDev DBH - .255
Press the Add button in the Tree List Parameters box.Press OK.
- The first few columns of the resulting crop plan should look similar to:
Crop Plans | MGM Example 3 | Saved: 0725 May 16 2009 | ||||||
Stand Age | Year | Event | Settings | |||||
Crop Plans | CropPlansID := MGM Example 3 | |||||||
Crop Plan | CropPlanID := Help Ex. 3 - MSS Herb | |||||||
Options | Region := 1 | SubRegion := 1 | StandsWbkName := MGM Stands 1993 WS09.xls | _MinDbh := 13.51 | _topdib := 10 | |||
14 | 2000 | Establish | StandID := AWSW | StandWT := .4 | SourceIndex := 2 | Seed := 0.1976 | GapArea% := 20 | |
14 | 2000 | Establish | StandID := Sw - Herb | StandWT := .6 | SourceIndex := 2 | Seed := 0.2905 | GapArea% := 20 | |
14 | 2000 | Grow | Schedule := | |||||
14 | 2000 | End |