Difference between revisions of "User's guide to PlanWise"
Jump to navigation
Jump to search
(→Maps) |
|||
| Line 46: | Line 46: | ||
=== Tables and Graphs === | === Tables and Graphs === | ||
| + | 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: | ||
| + | # Select the tab "Tables and Graphs" | ||
| + | # 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. | ||
| + | # When due, define a condtion. | ||
| + | # 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" | ||
| + | ## Clck | ||
=== Example of SQL Query === | === Example of SQL Query === | ||