Using Batch Fit Results in a Model

Now that assumptions have been generated from historic sales data, the next steps are to convert Sales Volume formulas to values and replace them with the new assumptions. Then, you can run a simulation with more accurate results.

To use Batch Fit results in a model:

Select the formulas in cells C5 through F5 of the Model worksheet.
Use Microsoft Excel’s Copy and Paste Special commands to copy the formula cells and paste them back into the same locations. When the Paste Special dialog opens, choose Values as the Paste setting. Leave the other default settings and click OK.
Copy assumption data into the worksheet.
1. Select cells B2 through E2 on the Batch Fit Output worksheet.
2. Select Define, then Copy Data.
  Notice this is Crystal Ball’s Copy Data command, not Microsoft Excel’s Copy command.
  This function copies Crystal Ball data only, not the cell value.
3. Select cells C5 through F5 on the Model worksheet.
4. Select Define, then Paste Data.
  The assumptions copy to the first row of the table, leaving the current values.
5. Select cells C14 through F14.
6. Select Define, then Clear Data.
  This deletes the original assumptions generated by Batch Fit to eliminate redundant assumptions and speed up the simulation, as shown in Figure 60, Crystal Ball Assumptions in Cells C5 through F5.
  Figure 60. Crystal Ball Assumptions in Cells C5 through F5
In the Run, then Run Preferences, then Sampling dialog:
- Set Random Number Generation to use the Same Sequence Of Random Numbers and a seed value of 999.
- Select Monte Carlo simulation.
  When using this tool, use these options to make the resulting simulations comparable.
In the Run, then Run Preferences, then Trials dialog, set the Number Of Trials To Run to 500.
Click OK.
Select Run, then Start Simulation.
The simulation runs until it stops.