Report Builder - Revision history

Peder: Replaced content with "Category:Reference_Manual Online help: http://heurekaslu.org/help/index.html?skapa_rapportmallar.htm"

2016-03-07T18:12:02Z

Replaced content with "Category:Reference_Manual Online help: http://heurekaslu.org/help/index.html?skapa_rapportmallar.htm"

Peder at 11:40, 17 November 2014

2014-11-17T11:40:55Z

Peder at 13:44, 21 June 2010

2010-06-21T13:44:09Z

Peder: /* Mean diameter of harvested trees */

2010-06-18T11:35:45Z

Mean diameter of harvested trees

Peder: /* Mean diameter of harvested trees in thinnings */

2010-06-18T10:44:47Z

Mean diameter of harvested trees in thinnings

Peder: /* Mean diameter of harvested trees in thinnings */

2010-06-18T10:44:24Z

Mean diameter of harvested trees in thinnings

Peder: /* Mean diameter of harvested trees in thinnings */

2010-06-18T10:44:02Z

Mean diameter of harvested trees in thinnings

Peder at 10:35, 18 June 2010

2010-06-18T10:35:37Z

Peder: /* Examples */

2010-06-18T10:32:27Z

Examples

Peder at 09:02, 18 June 2010

2010-06-18T09:02:26Z

← Older revision		Revision as of 18:12, 7 March 2016
Line 1:		Line 1:
−	~~[[Category:Results]]~~
	[[Category:Reference_Manual]]		[[Category:Reference_Manual]]
−

	Online help: http://heurekaslu.org/help/index.html?skapa_rapportmallar.htm		Online help: http://heurekaslu.org/help/index.html?skapa_rapportmallar.htm
−
−	~~(Obsolete)~~
−
−	~~==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):
−
−	~~# Select the tab "Optimization Results > Tables and Graphs" (PlanWise) or "Simulation Results > Tables and Graphs" (RegWise).~~
−	~~# In the list "Tables and Graphs" to the left, right-click and select "Create New", and "Period Graph"~~
−	~~# In the Report Builder, click "Add" to add a variable. You can choose different kind of aggregate functions:~~
−	~~## Sum = sum of a variable, for example volume~~
−	~~## Mean = average value of a variable~~
−	~~## Sum of Area = areal sum, for example area of final felling~~
−	~~<!--## Conditional Sum = conditional sum, for example sum of volume in stand with the condition the site index should be at least a certain value.-->~~
−	~~<!--## Conditional Mean = (under implementation) conditional mean, cf. Conditional Sum-->~~
−	~~# Area should normally be set as is, that is "Representative area".~~
−	~~# Select the variable you are interested in.~~
−	~~# 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:~~
−	~~## Click on "Add Condition".~~
−	~~## Select a conditioning variable, in this case example SiteData > Site Index.~~
−	~~## Set operator ">=", and type the value 20.~~
−	~~## Click OK.~~
−	~~# Click OK.~~
−	# 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:
−	~~## Click "Add".~~
−	~~## Click "Select Variable" in "Variable"~~
−	~~## Select variable "Data per Species" > "Before" > "Volume" > "Pine", and then "OK".~~
−	~~## Repeat step 3 for all the other species. This may seem tedious, but remember that you only have to create the template once.~~
−	~~# Edit the Y-axis label (you should remove "/ha")~~
−	~~# Name the template and the header.~~
−	~~# Set the default type, for example "StackedBar" if you ran steps 3-4 above.~~
−	~~# Click OK~~
−	# 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.
−	~~# You can find more examples of reports [[Report_Examples\|here]].~~
−
−	~~==Examples==~~
−	~~Here is a number of examples on how to create report templates in report builder. See [[Category:Results#Tables_and_graphs]] for instructions on how to use the report builder.~~
−
−	~~=== Total final felling area per period===~~
−	~~# Select "Create New" > "Period Graph".~~
−	~~# Click the "Add"-button.~~
−	~~# In "Aggregate:", select "AreaSum".~~
−	~~# Let "Area" = "RepresentativeArea".~~
−	~~# Klick "Add Condition".~~
−	~~# Click in "Conditions" and choose "Select Variable..."~~
−	~~# Select "Treatments" > "Treatment" and OK.~~
−	~~# Select "In" as operator.~~
−	~~# Select "Multiple Values".~~
−	~~# Check "Final Felling", and "Final Felling with Seed Trees" and OK.~~
−	~~# In "Report Header:", type "Area Final Felling".~~
−	~~# Click OK.~~
−
−	~~=== Total final felling area and thinning per period===~~
−	~~# Follow steps 1-10 for "Total final felling..." above.~~
−	~~# Klick "Add Condition".~~
−	~~# Click in "Conditions" and choose "Select Variable..."~~
−	~~# Select "Treatments" > "Treatment" and OK.~~
−	~~# Select "=" as operator.~~
−	~~# From the list, select "Thinning".~~
−	~~# In "Report Header:", type "Area final felling and thinning".~~
−	~~# Select "Stacked bar" as "Default Chart Type".~~
−	~~# 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:~~
−	~~# Click OK.~~
−
−	~~=== Mean diameter of harvested trees ===~~
−	~~When computing the average of mean harvest diameters, it is important to compute it as a volume-weighed average.~~
−
−	~~# Select "Create New" > "Period Graph".~~
−	~~# Click the "Add"-button.~~
−	~~# In "Aggregate:", select "Avg".~~
−	~~# Let "Area" = "RepresentativeArea".~~
−	~~# In "Variable: ", select for example "Treatments" > "Dg Harvest" (diameter of mean basal area tree of harvested trees).~~
−	~~# Check "Use weight variable".~~
−	~~# As weighting variable, select "Treatments" > "Volume Harvested".<br><br>[[Image:DialogSelectWeightVariable.png\|200px]]<br>~~
−	~~# Select Add Condition, and define "Treatment" = "Thinning".~~
−	~~# Repeat steps 2-8, but with the condition that the treatment should be "Final Felling", or "Final Felling With Seed Trees".~~
−	# In "Report Header", type "Mean Harvest Diameter". It should look like this:<br><br>[[Image:ReportBuilder_VariableDg2.png\|500px\|Example showing the report builder when creating a report for mean diameter in thinnings and mean diameter in final fellings]]<br>
−	~~<br>~~
−	~~Formulae of what we compute above:~~
−	~~<br><math>D_{p} = \frac{\sum_{i=1}^n{a_ih_{ip}d_i}}{\sum_{i=1}^n{a_ih_{ip}}}}</math>~~
−	~~<br>where~~
−	~~<br>~~
−	~~<br>''D<sub>p</sub>'' = mean diameter over all thinned stands in period ''p'',~~
−	~~<br>''n'' = number of stands (treatment units),~~
−	~~<br>''a<sub>i</sub>'' = area of stand ''i'',~~
−	~~<br>''h<sub>ip</sub>'' = volume harvested in stand ''i'' in period ''p'',~~
−	~~<br>''d<sub>ip</sub>'' = mean diameter of thinned trees in stand ''i'' in period ''p'',~~

@@ Line 1: / Line 1: @@
 [[Category:Results]]
 [[Category:Reference_Manual]]
 ==Creating tables and graphs with the report builder==

@@ Line 1: / Line 1: @@
 [[Category:Results]]
 ==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):

@@ Line 61: / Line 61: @@
 === Mean diameter of harvested trees ===
 # Select "Create New" > "Period Graph".
 # Click the "Add"-button.
@@ Line 71: / Line 73: @@
 # Repeat steps 2-8, but with the condition that the treatment should be "Final Felling", or "Final Felling With Seed Trees".
 # In "Report Header", type "Mean Harvest Diameter". It should look like this:<br><br>[[Image:ReportBuilder_VariableDg2.png|500px|Example showing the report builder when creating a report for mean diameter in thinnings and mean diameter in final fellings]]<br>

@@ Line 60: / Line 60: @@
 # Click OK.
-=== Mean diameter of harvested trees in thinnings ===
+=== Mean diameter of harvested trees ===
 # Select "Create New" > "Period Graph".
 # Click the "Add"-button.

@@ Line 70: / Line 70: @@
 # Select Add Condition, and define "Treatment" = "Thinning".
 # Repeat steps 2-8, but with the condition that the treatment should be "Final Felling", or "Final Felling With Seed Trees".
-# In "Report Header", type "Mean Harvest Diameter". It should look like this:<br><br>[[Image:ReportBuilder_VariableDg2.png|400px|Example showing the report builder when creating a report for mean diameter in thinnings and mean diameter in final fellings]]<br>
+# In "Report Header", type "Mean Harvest Diameter". It should look like this:<br><br>[[Image:ReportBuilder_VariableDg2.png|500px|Example showing the report builder when creating a report for mean diameter in thinnings and mean diameter in final fellings]]<br>

@@ Line 60: / Line 60: @@
 # Click OK.
-=== Mean diameter of harvested trees in thinnings and final fellings===
+=== Mean diameter of harvested trees in thinnings ===
 # Select "Create New" > "Period Graph".
 # Click the "Add"-button.
@@ Line 67: / Line 67: @@
 # In "Variable: ", select for example "Treatments" > "Dg Harvest" (diameter of mean basal area tree of harvested trees).
 # Check "Use weight variable".
-# As weighting variable, select "Treatments" > "Volume Harvested".<br>[[Image:DialogSelectWeightVariable.png|200px]]
+# As weighting variable, select "Treatments" > "Volume Harvested".<br><br>[[Image:DialogSelectWeightVariable.png|200px]]<br>
 # Select Add Condition, and define "Treatment" = "Thinning".
-# Repeat steps 2-8, but with the condition that "Treatment In FinalFelling or Final Felling With Seed Trees"
+# In "Report Header", type "Mean Harvest Diameter in Thinnings". It should look like this:<br><br>[[Image:ReportBuilder_VariableDg.png|400px|Example showing the report builder when creating a report for mean diameter in thinnings and mean diameter in final fellings]]<br>
 # In "Report Header", type "Mean Harvest Diameter". It should look like this:<br>[[Image:ReportBuilder_VariableDg.png|400px|Example showing the report builder when creating a report for mean diameter in thinnings and mean diameter in final fellings]]

@@ Line 57: / Line 57: @@
 # In "Report Header:", type "Area final felling and thinning".
 # Select "Stacked bar" as "Default Chart Type".
-# You can change the order in which variables are displayed in the graph by using the arrow-buttons. The settings should like something like this:
+# 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:
-# Click OK.
+=== Mean diameter of harvested trees in thinnings and final fellings===

@@ Line 1: / Line 1: @@
 [[Category:Results]]
-With the Report Builder you can create templates that will be stored in C:\My documents\Heureka\Common\Reports. At startup, PlanWise checks all 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. To create a new template do the following:
+==Creating tables and graphs with the report builder==
 # Select the tab "Optimization Results > Tables and Graphs" (PlanWise) or "Simulation Results > Tables and Graphs" (RegWise).
@@ Line 29: / Line 30: @@
 # 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.
 # You can find more examples of reports [[Report_Examples|here]].