Case Generation

Case Gen returns all possible combinations to the given input ranges of data. It produces the cross-product of rows. The number of columns in the result is the sum of the number of columns in each range. The number of rows in the result is the product of the number of rows in each argument.
Each row in the result is produced by taking one row from each of the arguments and placing these rows from left to right.

Sample Data

We will consider a sample sheet containing some days, months and years. Our aim is to find all the dates derived from its combination.

Sample Data

Step 1

Click on the More command under SheetKraft tab.

More

Step 2

Click on the Case Gen on the drop-down list of More.

Case Gen

Step 3

A window will appear (Generate Cases), click on the marked tab to select data for Range 1.

Range 1

Step 4

Select the data range manually. If the selected data contain headers then click [ ] My data has headers otherwise no need.

Selection 1

Step 5

In interpret selection, you will have two options. After interpret selection, click on OK.

Interpret

Step 6

A window will appear (Generate Cases), click on the marked tab to select data for Range 2.

Range 2

Step 7

Select the data range manually. If the selected data contain headers then click [ ] My data has headers otherwise no need.

Selection 2

Step 8

After interpret selection, click on OK.

Interpret

Step 9

For Range 3, we need to add one more range by clicking on + marked tab.

Add Range

Step 10

A window will appear (Generate Cases), click on the marked tab to select data for Range 2.

Range 3

Step 11

Select the data range manually. If the selected data contain headers then click [ ] My data has headers otherwise no need.

Selection 3

Step 12

After interpret selection, click on OK.

Interpret

Step 13

A window will appear (Generate Cases), in the window you can see the total number of cases generated. Click on Next.

Next

Step 14

Select a blank range for the final reult display. You can either show the result in any of the existing worksheets (and select any blank range) or choose a new worksheet. In this illustraion, we have chosen the Existing worksheet [Sheet1!$F$2:$H$21].
Final result range

Final Result Display

Now we have the complete data in range [Sheet1!$F$2:$H$21].

Result

Final Data

Final data containing total 20 combinations (2[Days]x5[Months]x2[Years]).

Final Data