T-Lex / NotMyDay Excel Files

Reply #6

winsumloosesum — Mon, 21 Sep 2015 17:02:31 GMT

Next, keep the Excel file Step1.xlsm open.

Next we need to open the 2nd Excel file Step2.xlsm

With the Excel file Step1.xlsm open go to the Main Menu (this may be different in Excel version 2007)

Click File Open

Browse to the folder where you have the Excel files and open or double click the 2nd Excel file Step2.xlsm

Again, you may need to enable content/macros

Depending on the speed of your computer this may take up to 30 seconds for all the calculations to finish.

Once the... [ More ]

Reply #5

winsumloosesum — Mon, 21 Sep 2015 16:53:22 GMT

With the Excel file Step1.xslm open

Click the tab at the bottom labeled DrawImpost (unless already the active worksheet)

I'm going to be using the Florida Fantasy 5/36 game as the example.

Locate cell U2 and click cell U2

You should see the Florida 5/36 Game name in cell U2.

To the right of cell U2 you should see a drop-down arrow.

If you click the drop-down arrow you should see a list of a number of Lottery Games available.

Don't select any new game. Keep the Florida 5/36 g... [ More ]

Reply #4

winsumloosesum — Mon, 21 Sep 2015 16:42:42 GMT

New folder I created called Master

This is where you download and unzip the Master zip file.

Your Master folder should look exactly like the image below. If not the Excel Step1.xlsm file will not import your lottery game draw history.

Reply #3

winsumloosesum — Mon, 21 Sep 2015 16:39:19 GMT

Folder my version of T-Lex is installed

Reply #2

lakerben — Mon, 21 Sep 2015 16:36:54 GMT

Thanks steve

Reply #1

winsumloosesum — Mon, 21 Sep 2015 16:29:31 GMT

This will get you started:

Go to the folder where you unzipped the 2 Excel files.

Locate the Excel file Step1.xlsm and open it/double click the file name.

You should be prompted to enable macros/content . Your decision.

Once Step1.xlsm opens click the tab at the bottom labeled DrawImport

Locate cell U5

Click cell U5

You should see a drop-down arrow to the right of cell U5

Click the drop-down arrow and select the letter designation of your hard drive. Mine is the letter C... [ More ]

T-Lex / NotMyDay Excel Files

winsumloosesum — Mon, 21 Sep 2015 16:16:45 GMT

Instructions:

1. Create a new folder and name it whatever you like. Example, NMDExcelFiles (C:\NMDExcelFiles)

2. Download the following zip file and unzip the 2 Excel file Step1.xlsm and Step2.xlsm into your new folder created above.

https://copy.com/cPU8kdUoyiv7gvR4

3. Create another new folder and name it Master (C:\Master)

4. Download the following Master zip file from the link below and place it in the new Master folder created above.

https://copy.com/J3RGBBCVXpk7wbeD