In the Crystal Ball Examples folder, select Magazine Sales.xls to experiment with the Batch Fit tool. This spreadsheet model (Figure 57, Magazine Sales Workbook) shows the estimated gross profit resulting from newsstand sales of four of the company’s most popular magazines.
In this model, cells C5 through F5 are formulas that refer to the first row of data on the Sales Data worksheet. However, the model would be more accurate if you replaced these formulas with assumptions based on historical data. To do this, you can use the Batch Fit tool to generate an assumption for each data column of the Sales Data worksheet. Then, you can use Crystal Ball commands to copy and paste those assumptions from the Batch Fit data to the first data row of the Magazine Sales model. Because Crystal Ball cannot define assumptions in formula cells, you need to convert the formulas in C5 to F5 to values before pasting the assumption cells.
Example topics include: