Report Builder

Creating tables and graphs with the report builder

With the Report Builder in PlanWise and RegWise you can create templates that will be stored in C:\My documents\Heureka\Common\Reports. At startup, the program will check for files with the file extension "heurd" in that folder. Each such file holds information of a graph and a table. You can share templates with other users by copying files to that folder. Follow these steps to create a new template (see also examples):

1. Select the tab "Optimization Results > Tables and Graphs" (PlanWise) or "Simulation Results > Tables and Graphs" (RegWise).
2. In the list "Tables and Graphs" to the left, right-click and select "Create New", and "Period Graph"
3. In the Report Builder, click "Add" to add a variable. You can choose different kind of aggregate functions:
   1. Sum = sum of a variable, for example volume
   2. Mean = average value of a variable
   3. Sum of Area = areal sum, for example area of final felling
4. Area should normally be set as is, that is "Representative area".
5. Select the variable you are interested in.
6. You can add conditions to obtain sub sums, or sub averages. For example, to get teh total volume for stands with site index larger than 20, do the following:
   1. Click on "Add Condition".
   2. Select a conditioning variable, in this case example SiteData > Site Index.
   3. Set operator ">=", and type the value 20.
   4. Click OK.
7. Click OK.
8. Back in the "Report Builder" window, you can select more variables, for example if you want to create stacked bars, consisting of Volume Harvested and Volume After Harvest in the same graph, or different tree species in the same graph. For example, to make a graph that shows species-wise volumes do the following:
   1. Click "Add".
   2. Click "Select Variable" in "Variable"
   3. Select variable "Data per Species" > "Before" > "Volume" > "Pine", and then "OK".
   4. Repeat step 3 for all the other species. This may seem tedious, but remember that you only have to create the template once.
9. Edit the Y-axis label (you should remove "/ha")
10. Name the template and the header.
11. Set the default type, for example "StackedBar" if you ran steps 3-4 above.
12. Click OK
13. The new template will be added to the template list. To view a report, mark a result in the small window above the template list (for example "Max NPV - Strategic", then one or more template, and finally click "View Checked diagrams/reports". If the resulting table or graph is empty, you have problem not included the result variable when you ran the Treatment Program Generator.
14. You can find more examples of reports here.

Examples

Here is a number of examples on how to create report templates in report builder. See for instructions on how to use the report builder.

Total final felling area per period

1. Select "Create New" > "Period Graph".
2. Click the "Add"-button.
3. In "Aggregate:", select "AreaSum".
4. Let "Area" = "RepresentativeArea".
5. Klick "Add Condition".
6. Click in "Conditions" and choose "Select Variable..."
7. Select "Treatments" > "Treatment" and OK.
8. Select "In" as operator.
9. Select "Multiple Values".
10. Check "Final Felling", and "Final Felling with Seed Trees" and OK.
11. In "Report Header:", type "Area Final Felling".
12. Click OK.

Total final felling area and thinning per period

1. Follow steps 1-10 for "Total final felling..." above.
2. Klick "Add Condition".
3. Click in "Conditions" and choose "Select Variable..."
4. Select "Treatments" > "Treatment" and OK.
5. Select "=" as operator.
6. From the list, select "Thinning".
7. In "Report Header:", type "Area final felling and thinning".
8. Select "Stacked bar" as "Default Chart Type".
9. You can change the order in which variables are displayed in the graph by using the arrow-buttons. The settings should look like something like this:
10. Click OK.

Mean diameter of harvested trees in thinnings

1. Select "Create New" > "Period Graph".
2. Click the "Add"-button.
3. In "Aggregate:", select "Avg".
4. Let "Area" = "RepresentativeArea".
5. In "Variable: ", select for example "Treatments" > "Dg Harvest" (diameter of mean basal area tree of harvested trees).
6. Check "Use weight variable".
7. As weighting variable, select "Treatments" > "Volume Harvested".
   
   
   
8. Select Add Condition, and define "Treatment" = "Thinning".
9. Repeat steps 2-8, but with the condition that the treatment should be "Final Felling", or "Final Felling With Seed Trees".
10. In "Report Header", type "Mean Harvest Diameter". It should look like this: