To extract several types of OptQuest data to worksheet cells for further analysis:
Run an optimization and choose Analyze, Extract Data.
The Extract Data Preferences dialog opens. By default, the OptQuest Data tab is selected.
Choose whether to extract OptQuest solutions, OptQuest statistics, or both, and then indicate whether to extract them for all decision variables or only the ones you choose.
Optionally, click the Simulation Data tab to extract simulation data for the best solution only, similar to that described in the Oracle Crystal Ball User's Guide.
Optionally, click the Options tab to indicate whether to extract data to a new workbook or worksheet and can specify the name to use for that data sheet.
When all settings are complete, click OK to extract the data.
Figure 9, Extracted data from Hotel Design.xls shows what happens when you check OptQuest Solutions and OptQuest Statistics. Some OptQuest solutions data rows have been omitted to show the OptQuest statistics data.
The output is virtually identical to the information shown in the Solution Analysis view of the OptQuest Results window, including the filtering options and the column sort order. To see a different set of solutions, display the Solution Analysis view and change the options before you choose Analyze, Extract Data.
For more information about extracting data, see the online Oracle Crystal Ball User's Guide.