Welcome Guest
Log In | Register )
You last visited December 8, 2016, 6:54 pm
All times shown are
Eastern Time (GMT-5:00)

T-Lex / NotMyDay Excel Files

Topic closed. 6 replies. Last post 1 year ago by winsumloosesum.

Page 1 of 1
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: September 21, 2015, 12:16 pm - IP Logged

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

5. Unzip the Master zip file.  Unzipping this file should create a sub-folder Master

 

6. Go to your T-Lex program folder, normally C:\T-Lex and double click the folder to open it.

You should see a folder called Master. 

7. Copy and paste the Master folder from the C:\Master folder to the C:\T-Lex folder.  Click Replace when prompted.

Now you should have all the lottery drawing results for most of the games.  The most recent drawings up to Sunday, September 20, 2015

More instructions/videos later....

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: September 21, 2015, 12:29 pm - IP Logged

    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".  This is the hard drive where you have T-Lex installed.  Normally C:\T-Lex

    NMD 1

      lakerben's avatar - spherewall
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11119 Posts
      Offline
      Posted: September 21, 2015, 12:36 pm - IP Logged

      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

      5. Unzip the Master zip file.  Unzipping this file should create a sub-folder Master

       

      6. Go to your T-Lex program folder, normally C:\T-Lex and double click the folder to open it.

      You should see a folder called Master. 

      7. Copy and paste the Master folder from the C:\Master folder to the C:\T-Lex folder.  Click Replace when prompted.

      Now you should have all the lottery drawing results for most of the games.  The most recent drawings up to Sunday, September 20, 2015

      More instructions/videos later....

      Thanks steve!

      How about them cowboys!

       

       

      US Flag

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: September 21, 2015, 12:39 pm - IP Logged

        Folder my version of T-Lex is installed:

        Image 2

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: September 21, 2015, 12:42 pm - IP Logged

          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.

          Image 3

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5387 Posts
            Offline
            Posted: September 21, 2015, 12:53 pm - IP Logged

            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 game the current game.

             

            Now let's test to see if we can import the Florida 5/36 game history from the C:\Master folder.

            Click the Toolbar labeled "Clear Drawings" in cell range O3:P5

            This should clear the results in cell range B through J

            Next, click the Toolbar labeled "Click to Import Draw Text File" in cell range O8:P8

            If you have everything correct from the instructions from the 1st post you should see the drawings appear in cell range B through J

            If the drawings appear then congratulations!! LOL  If you receive an error you may need to re-read post 1.

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: September 21, 2015, 1:02 pm - IP Logged

              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 calculations are finished click the tab at the bottom in Excel file Step2.xlsm labeled "DrawHistory1"

              In cell range C6:C10 you should see a Toolbar labeled "Import Drawings to DrawHistory1 Tab"

              This will copy and paste the draw histories from Step1.xlsm to the tab DrawHistory1 in Step2.xlsm Excel file.

              This may take about 30 second to calculate all the formulas etc.

               

              More later....