|
|
| (11 intermediate revisions by one other user not shown) |
| Line 1: |
Line 1: |
| | + | {{Languages|User%27s_guide_to_PlanWise}} |
| | [[Category:User's Guides|PlanVis|PlanVis]] | | [[Category:User's Guides|PlanVis|PlanVis]] |
| | + | |
| | + | ==New help documentation== |
| | + | A newer help documentation is available at http://heurekaslu.org/help (currently only in Swedish). |
| | + | |
| | | | |
| | == Introduction == | | == Introduction == |
| Line 8: |
Line 13: |
| | | | |
| | The application includes two main components, a growth-and-yield simulator and an optimizer. The simulator is called the Treatment Program Generator (TPG). The TPG computes alternative treatment programs for each treatment unit (stand) in a given forest area. The optimizer is called Heureka Optimization Programming System (HOPS). It is used to formulate and solve linear programming and mixed-integer programming problems for choosing between optional treatment programs. Another component is a map viewer for visualization of forest development and management under different plans, or scenarios. | | The application includes two main components, a growth-and-yield simulator and an optimizer. The simulator is called the Treatment Program Generator (TPG). The TPG computes alternative treatment programs for each treatment unit (stand) in a given forest area. The optimizer is called Heureka Optimization Programming System (HOPS). It is used to formulate and solve linear programming and mixed-integer programming problems for choosing between optional treatment programs. Another component is a map viewer for visualization of forest development and management under different plans, or scenarios. |
| | + | |
| | + | ==Get Started== |
| | + | The best way to get started is probably to read the [[Get Started]] section and follow the instruction for installing the software. After that you can through the tutorial suggested there or check up another one in [[Tutorials | tutorials]]. This one (only in Swedish though) is probably the current best: [[SG0060_2010 | introductury exercise used in MSc course]]. |
| | | | |
| | == Working with Projects == | | == Working with Projects == |
| Line 26: |
Line 34: |
| | | | |
| | == Optimizing == | | == Optimizing == |
| − | [[:Category:Optimization|About the built-in optimization model]] | + | [[Optimization | User's Guide to Optimization]] |
| − | | |
| − | [[Optimization Settings]]
| |
| | | | |
| | == Analyzing Results == | | == Analyzing Results == |
| − | Results can be viewed in maps, tables and graphs. In addition, database queries can be run directly in SQL Server Management Studio. | + | Results can be viewed in maps, tables and graphs. See [[:Category:Results | Results]]. |
| − | | |
| − | === Maps ===
| |
| − | You can step through time periods to study how different variables change over time, for a given plan or scenario.
| |
| − | # Click on the tab "Map (Results)". If it is not available, activate it in the "View"-menu.
| |
| − | # In the "Result"-listbox, select a result (a plan) 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 "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", 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"
| |
| − | | |
| − | === Running SQL Queries in SQL Server Management Studio, example ===
| |
| − | Below is one example of a query. 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".
| |
| − | | |
| − | <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 (RESULT.Period <= 10) AND (OPTIMIZATION.OptimizationNo = 0) AND (SIMULATION.SimNo = 3) AND
| |
| − | (RESULT_TREATMENTDATA.Treatment > 0)
| |
| − | ORDER BY TREATMENTUNIT.Description, RESULT.AlternativeNo, RESULT.Period
| |
| − | | |
| − | </pre>
| |
| − | | |
| − | ''NB: Before running the script, you must set the "OptimizationNo" and "SimNo" (following "WHERE") to current values, seen in corresponding tables (by open the tables "dbo.OPTIMIZATION" and "dbo.SIMULATION", respectively). You can also limit the number of periods of interest (the first ten periods/50 years are regarded in the script above, actually, the first 55 years..?).''
| |
| | | | |
| | == How Do I? == | | == How Do I? == |
New help documentation
A newer help documentation is available at http://heurekaslu.org/help (currently only in Swedish).
Introduction
PlanWise is an application for long term forestry planning, including both strategic and tactical planning. It can be considered a problem solver that helps you find solutions to problems of the type "What to do and when?".
The application can can handle full cover geographical analysis which gives the basic conditions for spatial forestry planning, enabling the consideration of landscape patterns and concentration of treatments. It also gives a better connection to short term operational planning.
The application includes two main components, a growth-and-yield simulator and an optimizer. The simulator is called the Treatment Program Generator (TPG). The TPG computes alternative treatment programs for each treatment unit (stand) in a given forest area. The optimizer is called Heureka Optimization Programming System (HOPS). It is used to formulate and solve linear programming and mixed-integer programming problems for choosing between optional treatment programs. Another component is a map viewer for visualization of forest development and management under different plans, or scenarios.
Get Started
The best way to get started is probably to read the Get Started section and follow the instruction for installing the software. After that you can through the tutorial suggested there or check up another one in tutorials. This one (only in Swedish though) is probably the current best: introductury exercise used in MSc course.
Working with Projects
Introduction to Projects
Create a new Project
Open an existing Project
Making a copy of a Project (incl. Name of Objects)
Delete a Project
Generating treatment programs
About Control Categories, Control Tables, and Forest Domains
Optimizing
User's Guide to Optimization
Analyzing Results
Results can be viewed in maps, tables and graphs. See Results.
How Do I?
It is possible to look at the tutorial and you are free to do the exercises (all of them or those you find relevant). However, be aware of the fact that they were written for MSc-students that worked with earlier releases of PlanWise (e.g., screenshots and programming syntax will not be applicable).
Create a New Result Database
Improve Performance
Organize Windows
Reference
Control Tables
Common Dialogs
Error Messages
