Page 684 - ExtendSim User Guide
P. 684

658 Analysis
Scenario analysis
Export the results (optional)
The form of the Scenario DB database tables may not be exactly what you want. To do addi- tional analysis using a different format, export a report on the Export tab. For example, you could export complete results, including the values from every scenario, to JMP. Then use JMP's analysis capabilities to compare the different scenarios. To export the results:
Choose the type of report.
• Complete Results exports the contents of the Scenario DB database – the factors and
responses for every run in every scenario
• Displayed Statistics exports the statistics for each scenario as shown in the Scenarios table. What gets displayed depends on what is selected in the Response tab’s Report Set column.
• CompleteStatisticsexportsalloftheavailablestatisticsforeachscenario.Thisisevery possible statistic allowed by the Report Set column of the Responses tab.
Select the destination for the report: an ExtendSim database, Excel, Minitab, or JMP.
☞ So that you don’t accidentally overwrite the data, it is suggested that you do not export to the
Scenario DB database.
Set the destination parameters for the exported data. This varies based on the selected export destination.
Click Export Report
Once you have exported the results, analyze the scenarios by sorting, plotting, or generating
comparison statistics.
Tutorial II (database variables)
This section assumes you understand how to create ExtendSim databases, including how to link to them and how to enter parent/child relationships. Databases are described in the User Guide.
So far you have controlled only dialog variables with the Scenario Manager. While most ana- lysts would use only dialog parameters as factors and responses, a select few of you will want to do more advanced analysis. With the Scenario Manager you can use entire databases or a subset of a database (database tables, fields, or records), as factors and/or responses. These database variables can be used in addition to, or instead of, dialog variables.
☞ Using database variables is more complicated than using dialog parameters. However, it is very useful when you have sets of data, rather than single variables, that you want to swap in and out for each scenario. For example, several production schedules for a manufacturing model.
To use the Scenario Manager with a database variable, you must create an ExtendSim database and any necessary tables, fields, and records (this tutorial assumes you already know how to do that). You also need to specify targets and sources, as discussed below.
Targets and sources
The concept of targets and sources is specific to the Scenario Manager and allows more sophis- ticated analysis.
How To

   682   683   684   685   686