Generating Decision Table Results

  To run the Decision Table tool:

1. In Microsoft Excel with Crystal Ball loaded, open the workbook Oil Field Development.xls.

2. In the Run, then Run Preferences, then Sampling dialog:

   • Set Random Number Generation to use the Same Sequence Of Random Numbers and an Initial Seed Value of 999.

   • Select Monte Carlo simulation.

     When using this tool, use these options to make the resulting simulations comparable.

3. In the Run Preferences dialog, click OK.

4. Select Run, then More Tools, then Decision Table. (In Microsoft Excel 2007 or later, select More Tools in the Tools group.)

   If this is the first time you have opened the Decision Table tool, the Welcome panel opens.

5. If the Welcome panel opens, click Next.

   The Target Forecast panel opens.

6. Be sure the NPV forecast is selected and click Next.

   The Decision Variables panel opens.

7. Move Facility Size and Wells To Drill to the Chosen Decision Variables list.

   1. Press the Ctrl key and select Facility Size and Wells To Drill in the Available Decision Variables list.

   2. Click .

8. Click Next.

   The Options panel opens, similar to Figure 75, Options panel, Decision Table Tool.

   Figure 75. Options panel, Decision Table Tool

   

9. Set the following options as shown in Figure 75, Options panel, Decision Table Tool:

   • Number of values to test for Facility Size = 7.

   • Number of values to test for Wells To Drill = 6.

   • Maximum trials per simulation = 500.

   • Show Only Target Forecast is selected.

10. Click Run.

    The tool runs a simulation for each combination of decision variable values. It compiles the results in a table of forecast cells indexed by the decision variables.