|
|
| (14 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | {{Languages}}
| + | #REDIRECT [[Category:Result Variables]] |
| − | [[Category:Reference Manual]]
| |
| − | [[Category:User's Guides]] | |
| − | | |
| − | ==Result variables==
| |
| − | After solving a planning problem (PlanWise), or generating a scenario (RegWise), you can study each variable that was included in the simulation (in "Treatment Program Generator" in PlanWise, and "Simulate" in RegWise). You can study both stand-level results, and totals (see Report Builder below). In StandWise, you see the results in the "Table"-tab.
| |
| − | | |
| − | There is a large number of variables that you can include in a simulation. To be able to include a certain variable in an optimization model (in PlanWise), you must include when you run the "Treatment Program Generator". Click [[Result Variables | here]] to see a list of available variables.
| |
| − | | |
| − | ==Stand-level results==
| |
| − | | |
| − | ====PlanWise====
| |
| − | PlanWise generates several alternatives for each [[Definition:Treatment unit | treatment unit]]. These alterntives are then used as input in the [[Optimization | optimization model]].
| |
| − | #Select the window "TPG Results".
| |
| − | #Right-click a TPG-result in the left pane, and select "View treatment programs".
| |
| − | #A tabbed window called "Treatment Programs .." now shows an overview of alternatives for a selected treatment unit. The cells shows the [[Definition:TreatmentCode | treatment codes]] for each time period. You select the treatment unit in the combo box, right above the table.
| |
| − | #To see more details for a specific alternative, right-click and select "View details for selected alternative...".
| |
| − | | |
| − | After optimization, one or more alternatives (depending on whether the [[Optimization#Decision_variables | decision variables]] are binary) have been selected. Follow these steps to get result table:
| |
| − | #Select tab "Optimization Results".
| |
| − | #Select sub-tab "Details"
| |
| − | #In the left pane, right-click the optimization result you are interested in, and select "View optimization".
| |
| − | #You can customize the table displayed:
| |
| − | ##To change the number of time periods, edit the field "Number of periods".
| |
| − | ##To select what variables to display, click the button "Select Variables".
| |
| − | ##In Display names, you can choose whether to display short or long column names.
| |
| − | ##To copy the table data to a spreadsheet program, right-click in the table and select "Copy all".
| |
| − | #Right-click an optimziation result, main window, tab "Optimization Results", sub-tab "Details".
| |
| − | | |
| − | ====Simulation results in RegWise====
| |
| − | Same as for PlanWise, but select tab "Simulation Results", instead of "Optimization Results" in step 1.
| |
| − | | |
| − | | |
| − | ====StandWise====
| |
| − | Main window, tab "Table". Select what variables to display by clicking on the button "Select Variables".
| |
| − | | |
| − | ==Thematic maps==
| |
| − | In PlanWise and RegWise, there is an in-built map viewer that lets you step through time periods to study how different variables change over time, for a given plan or scenario. In StandWise, a stand-level map viewer shows a tree map in both 2D and 3D.
| |
| − | | |
| − | '''Instrunctions (PlanWise and RegWise)'''
| |
| − | # Click on the tab "Optimization Results > Map" (PlanWise), or "Simulation Results > Map" (RegWise). If it is not available, activate it in the "View"-menu.
| |
| − | # In the "Result"-listbox, select a result (a plan or a scenario) that you want to study. You may have to click on the "Refresh"-button to the right of the list.
| |
| − | # In "Map Properties", right-click a variable you are interested in and select "Add Items Automatically".
| |
| − | # In the dialog "Define Map Properties", you can choose the number of items in a gradient (continuous variables), the number of items, or what categories (class variables) you want to include in the map.
| |
| − | # After defining the map legend for the variable, right-click on the variable (back in "Map Properties") and select "Show in Map".
| |
| − | # At the top of the map, there is a period index showing the currently selected plan period. You can step forth and become with the arrows, or type the period number directly in the edit box.
| |
| − | | |
| − | ==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 "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.
| |
| − | # When due, define a condition.
| |
| − | # 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
| |
| − | # Note that the template has now been added to the list of templates. To view a report, mark a result in the small window above the template list (for example "Highest Net Present Value", then one or more template, and finally click "View Checked diagrams/reports"
| |
| − | | |
| − | == When you need maximum flexibility: Running SQL Queries in SQL Server Management Studio, example ==
| |
| − | If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.
| |
| − | | |
| − | <pre>
| |
| − | | |
| − | SELECT SIMULATION.SimNo, TREATMENTUNIT.Description, TREATMENTUNIT.Area AS AvdProdArea,
| |
| − |
| |
| − |
| |
| − | RESULT_FORESTDATA.MeanAgeTotal_Before AS Medelålder, RESULT_TREATMENTDATA.VolumeCutTotal AS VolAvv,
| |
| − | RESULT_VALUEDATA.Net AS Netto, OPTIMIZATIONRESULT.Proportion AS Andel, OPTIMIZATION.OptimizationNo
| |
| − | FROM RESULT INNER JOIN
| |
| − | TREATMENTUNIT ON RESULT.SimulationGuid = TREATMENTUNIT.SimulationGuid AND
| |
| − | RESULT.TreatmentUnitGUID = TREATMENTUNIT.TreatmentUnitGUID INNER JOIN
| |
| − | RESULT_FORESTDATA ON RESULT.ResultGuid = RESULT_FORESTDATA.ResultGuid INNER JOIN
| |
| − | SIMULATION ON RESULT.SimulationGuid = SIMULATION.SimulationGuid INNER JOIN
| |
| − | OPTIMIZATIONRESULT ON RESULT.TreatmentUnitGUID = OPTIMIZATIONRESULT.TreatmentUnitGuid AND
| |
| − | RESULT.AlternativeNo = OPTIMIZATIONRESULT.AlternativeNo AND RESULT.SimulationGuid = OPTIMIZATIONRESULT.SimulationGuid INNER JOIN
| |
| − | OPTIMIZATION ON OPTIMIZATIONRESULT.OptimizationGuid = OPTIMIZATION.OptimizationGuid AND
| |
| − | OPTIMIZATIONRESULT.SimulationGuid = OPTIMIZATION.SimulationGuid FULL OUTER JOIN
| |
| − | TREATMENTTYPE RIGHT OUTER JOIN
| |
| − | RESULT_VALUEDATA INNER JOIN
| |
| − | RESULT_TREATMENTDATA ON RESULT_VALUEDATA.ResultGuid = RESULT_TREATMENTDATA.ResultGuid AND
| |
| − | RESULT_VALUEDATA.RowNo = RESULT_TREATMENTDATA.RowNo ON TREATMENTTYPE.Code = RESULT_TREATMENTDATA.Treatment ON
| |
| − | RESULT.ResultGuid = RESULT_TREATMENTDATA.ResultGuid--
| |
| − | WHERE (OPTIMIZATIONRESULT.Proportion > 0) and (OPTIMIZATION.OptimizationNo = 0) AND (SIMULATION.SimNo = 1) AND
| |
| − | (RESULT_TREATMENTDATA.Treatment > 0)
| |
| − | ORDER BY TREATMENTUNIT.Description, RESULT.AlternativeNo, RESULT.Period
| |
| − | | |
| − | </pre>
| |