TECHNOTE

How do I find the assumption values that produce certain forecast values?

To view the assumption values that produce your forecast values:

Define the assumptions you are interested in as forecasts.
Select Run > Run Preferences > Options.
Check the Retain Unsorted Trials option. This keeps a copy of the forecast trials in the original order, even after you calculate or report the forecast statistics.
Click on OK.
Run the simulation.
Select Run > Extract Data.
For Type Of Data, select Forecast Values.
Click on OK.

Crystal Ball generates the list of all the unsorted simulation forecast values. Unless you see an error about missing data due to calculation errors, the forecast values in each row will be from the same trial of the simulation.

You can sort the extracted rows of data by a particular column to more easily find the values you are interested in. For example, in the extracted data spreadsheet:

Select all the columns that have extracted data.
Select Data > Sort.
Select which column of data to sort by and either ascending or decending order.
Click on OK.

The data in each row stay with the corresponding values in the sorted column.