Excel files used in the previous example in addition to RL's Ultra-34 program
Download link below is a zip file that contains the Excel file: "Ultra34Step2"
https://my.pcloud.com/publink/show?code=XZ7YTekZtfaUYBJOJOFKC9XleVgs3JvhRQqX
Instructions:
1>Excel file created using Excel version 2010. Should work with newer versions of Excel and Excel 2007.
2>Excel file contains macros so you will need to adjust your security settings to allow macros to run (Google Excel security settings for your version of Excel)
3>Open the Excel file "Ultra34Step2"
4>Locate the 1st worksheet labeled "StatesListing3" (very 1st worksheet left hand lower corner)
5>Locate and click cell D2 which currently has the "Missouri_Combined" Pick 3 game selected.
6>You should see a drop-down arrow to the right of cell D2. Click the drop-down arrow and select the Pick 3 game you play.
7>Once you've selected your Pick 3 game select the worksheet labeled "P3UltraSC" at the bottom. Should be the 3rd worksheet from the left.
8>Close RL's Ultra-34 program if currently open.
9>Click the toolbar located in cell R9 through 14. The pick 3 game database will be created in the Ultra-34 Pick-3 folder. Normally located at C:\Ultra-34/Pick-3\. Note: If your hard drive designation is other than the letter "C" you will need to go to cell B2 and change the file location or drive letter designation.
10>The file name of the text file that will be located in the C:\Ultra-34\Pick-3\ folder will be from cell B12.
11>Open RL's Ultra-34 program
12>Click the "Load" button (bottom left hand side)
13>Select the game file (text file) created in Step 9 above.
14>Verify the game is current and correct.
15>Click the "Reset Selections" button (See image below)
15>Click the "Erase" button (See image below)
16>The game (MO3C.txt) below is the Missouri Pick 3 combined draws. Current drawing is from Friday evening March 6, 2019 which was 3-2-4. Rogue is 1-1-0-1-0
17>Use the Excel file to select the Rogue Values. Rogue value will be located in cell range Y10 through AC10 below.
Rogue Positions:
P1>023
P2>023
P3>123
P4>023
P5>123
18>Enter the Rogue values in RL's Ultra-34 program: (See example below)
Click the R-A button. Use the "input keys" to enter the 3 Rogue Values. For example, 023.
Continue selecting the remaining 4 Rogue positions R-B through R-E and enter the 3 Rogue values for each position.
Click the "Run" button. (see below)
The "sets" generated will located in the far right hand lower corner.
19> Next select from the Odd/Even and or High/Low cell columns from the Excel file which Rogue Values that you want to eliminate.
20> Eliminate the Rogue Value(s) using the Odd/Even and or High Low history.
Rogue Positions:
R-P1>023
R-P2>023
R-P3>123
R-P4>023
R-P5>123
21> Click the "Reset Selections" button and also click the "Erase" (Erase Sets) button. Enter your new selections for each of the 5 Rogue Positions. Then click the "Run" button. See below.
22>Click the "View" button that opens a text file with the sets generated.
23>Eliminate additional Rogue values to reduce the number of sets.
Good luck!!