Difference between revisions of "Category:Results"
Category:Results
Jump to navigation
Jump to search
(Created page with '{{Languages}} ==Result Variables== After solving a planning problem (PlanWise), or generating a scenario (RegWise), you can study each variable that was included in the simulati�?�') |
|||
| Line 6: | Line 6: | ||
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. | 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== | ||
| + | You can display stand-level results in the | ||
| + | ====PlanWise==== | ||
| + | #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". | ||
| − | == | + | ====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. | 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. | ||
| Line 18: | Line 37: | ||
# 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. | # 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 | + | ==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: | 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: | ||
| Line 44: | Line 63: | ||
# 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" | # 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" | ||
| − | == | + | == Advanced users: Running SQL Queries in SQL Server Management Studio, example == |
| − | Below is one example of a query. | + | If you are interested in results that you cannot manage to obtain with the tools available in the applications, you can run queries in SQL Server Management Studio. Below is one example of a query to a list over stand-level treatment for a selected optimization. To run this example 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> | <pre> | ||
| Line 67: | Line 86: | ||
RESULT_TREATMENTDATA ON RESULT_VALUEDATA.ResultGuid = RESULT_TREATMENTDATA.ResultGuid AND | RESULT_TREATMENTDATA ON RESULT_VALUEDATA.ResultGuid = RESULT_TREATMENTDATA.ResultGuid AND | ||
RESULT_VALUEDATA.RowNo = RESULT_TREATMENTDATA.RowNo ON TREATMENTTYPE.Code = RESULT_TREATMENTDATA.Treatment ON | RESULT_VALUEDATA.RowNo = RESULT_TREATMENTDATA.RowNo ON TREATMENTTYPE.Code = RESULT_TREATMENTDATA.Treatment ON | ||
| − | RESULT.ResultGuid = RESULT_TREATMENTDATA.ResultGuid | + | RESULT.ResultGuid = RESULT_TREATMENTDATA.ResultGuid-- |
| − | WHERE (OPTIMIZATIONRESULT.Proportion > 0) | + | WHERE (OPTIMIZATIONRESULT.Proportion > 0) and (OPTIMIZATION.OptimizationNo = 0) AND (SIMULATION.SimNo = 1) AND |
(RESULT_TREATMENTDATA.Treatment > 0) | (RESULT_TREATMENTDATA.Treatment > 0) | ||
ORDER BY TREATMENTUNIT.Description, RESULT.AlternativeNo, RESULT.Period | ORDER BY TREATMENTUNIT.Description, RESULT.AlternativeNo, RESULT.Period | ||
</pre> | </pre> | ||
Revision as of 12:07, 17 May 2010
This category currently contains no pages or media.