How To Use Case Generation

The Case Generator lives under the Toolbox menu button on the Petroleum Office ribbon. Its dialog has 4 range inputs.

Case Generator Dialog

  1. Select File Template — choose the cell with the name of the file template. Important: this file must be in the same directory as your current Excel file. Click "Open File Folder" to open the current file's directory in Windows Explorer.
  2. Select Tokens — select the horizontal cell range with token placeholders. These tokens will be replaced during file generation with specific values. Tokens must be unique.
  3. Select Cases — select the vertical cell range with file names for each case. All names must be unique.
  4. Select Token-Value Table — select the cell range with values for tokens.

Click Generate Files. All generated files will land in the same folder as the template.

Below: example content of a simple file template alongside the content of a generated file.

Case Generation Example