Ex. 3 : (Phase 1). Design of a Multi-Strata Stand

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
  1. Right-click on the Crop Plans event to make it the active event (highlighted in yellow).
  2. Press the Edit button () to activate the Edit Crop Plans dialog.
    1. To specify a new crop plans identifier, replace Untitled with MGM Example 3.
    2. Press OK.
  3. 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.
  4. Press the Edit button () to activate the Edit Crop Plan dialog.
    1. To specify a crop plan identifier, replace Untitled with Help Ex. 3 - MSS Herb
    2. Press OK.
  5. Click the Move Down to Next Crop Plan Event button () to activate the Options event.
  6. Click the Edit button ().
    1. If necessary click on the Alberta tab to identify the appropriate region.
    2. If necessary, click on the EcoRegion option button to identify the Sub-Region.
    3. Select the Central Mixedwood sub-region from the alternatives presented in the drop-down box.
    4. 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)
    5. Select the Species tab, all species should be selected.
    6. 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.
    7. Select the Other Setting tab, MAFLAG (invoke stand breakup) should be checked.
    8. Click OK.
  7. Click the Move Down to Next Event button () to activate the Establish event.
  8. Click the Edit event button ().
    1. Click on the Trees (Stand age<= 25) tab to establish the trees.
    2. 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
    3. AW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)
      Stand Origin - PerfSurveyAllTrees
      Site Index - 16

      Create 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.3

      stDev DBH - 0.495

    Press the Add button in the Tree List Parameters box.

    1. SW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)

      Stand Origin - PerfSurveyAllTrees
      Site Index - 16

      Create 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.

  9. 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.
  10. Click the Move Down to Next Crop Plan Event button () to activate the Grow event.

  11. Click your right mouse button and choose Insert event .
    1. Insert an new Establish Event
    2. Click on the Trees (Stand age<= 25) tab to establish the trees.
    3. 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
    4. AW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)
      Stand Origin - PerfSurveyAllTrees
      Site Index - 16

      Create 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.3

      stDev DBH - 0.495

    Press the Add button in the Tree List Parameters box.

    1. SW Cohort - Set - Stand Origin and Site Index (This is done for each cohort being established)

      Stand Origin - PerfSurveyAllTrees
      Site Index - 16

      Create 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.

  12. 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