Welcome Guest
Log In | Register )
You last visited December 9, 2016, 10:18 am
All times shown are
Eastern Time (GMT-5:00)

Pick 3 and Pick 4 Excel Files - Updated April 22 2014

Topic closed. 6 replies. Last post 3 years ago by retxx.

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: April 23, 2014, 6:08 am - IP Logged

I updated the Excel files and added the Iowa worksheets for both the Pick 3 and Pick 4 games.

Still need to test this coming Sunday's results to make sure the update works.

Changed the "Dashboard" tab to "Updater" tab.  Added new toolbars for updating just the Midday and Evening draws.

Changed the tab for any state with a Midday draw form "M" to "D".  The "M" such as Tennessee (TN3M) represent the "Morning" draws whereas the "D" represents the "Day or Midday" drawing such as TN3D for Tennessee Midday.

I will need to fix the other Excel files that feed off of these Draw files. 

Note:

Uncheck the box "Combine Illinois and Iowa Results"

Download link to the folder containing the updated Excel files:

https://app.box.com/s/fivovwcekmvmpot7sj9r

Let me know if any errors.  Thanks

    Avatar
    Horwood NL
    Canada
    Member #70613
    February 6, 2009
    296 Posts
    Offline
    Posted: April 26, 2014, 7:55 pm - IP Logged

    I updated the Excel files and added the Iowa worksheets for both the Pick 3 and Pick 4 games.

    Still need to test this coming Sunday's results to make sure the update works.

    Changed the "Dashboard" tab to "Updater" tab.  Added new toolbars for updating just the Midday and Evening draws.

    Changed the tab for any state with a Midday draw form "M" to "D".  The "M" such as Tennessee (TN3M) represent the "Morning" draws whereas the "D" represents the "Day or Midday" drawing such as TN3D for Tennessee Midday.

    I will need to fix the other Excel files that feed off of these Draw files. 

    Note:

    Uncheck the box "Combine Illinois and Iowa Results"

    Download link to the folder containing the updated Excel files:

    https://app.box.com/s/fivovwcekmvmpot7sj9r

    Let me know if any errors.  Thanks

    I find the only thing that updates is the date on the Ont. games. Have to add the draw numbers manualy. The games I use eg. Dojo2 etc. do not like the change to D from M. I beleave that's what the problem is.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: April 27, 2014, 2:55 pm - IP Logged

      I find the only thing that updates is the date on the Ont. games. Have to add the draw numbers manualy. The games I use eg. Dojo2 etc. do not like the change to D from M. I beleave that's what the problem is.

      Sorry about having to change the D to a M but if additional states add morning draws I'm planning for the change OK.

      Here are the updates to the 2 Excel files the fix:

      https://app.box.com/s/rapk2g6lcqxnp19smul5

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: April 29, 2014, 1:11 am - IP Logged

        I updated the Excel files and added the Iowa worksheets for both the Pick 3 and Pick 4 games.

        Still need to test this coming Sunday's results to make sure the update works.

        Changed the "Dashboard" tab to "Updater" tab.  Added new toolbars for updating just the Midday and Evening draws.

        Changed the tab for any state with a Midday draw form "M" to "D".  The "M" such as Tennessee (TN3M) represent the "Morning" draws whereas the "D" represents the "Day or Midday" drawing such as TN3D for Tennessee Midday.

        I will need to fix the other Excel files that feed off of these Draw files. 

        Note:

        Uncheck the box "Combine Illinois and Iowa Results"

        Download link to the folder containing the updated Excel files:

        https://app.box.com/s/fivovwcekmvmpot7sj9r

        Let me know if any errors.  Thanks

        I found a couple errors in the Sunday update and are now fixed.

        Use the same download link to the folder containing all the Excel files.

        Draws updated through Sunday 4/28/14

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: May 2, 2014, 11:46 am - IP Logged

          Pick 3 and Pick 4 Excel Files - Updated May 1 2014

          Download Folder:

          https://app.box.com/s/t18blo9pt65uy3jj7k7u

            Avatar
            Horwood NL
            Canada
            Member #70613
            February 6, 2009
            296 Posts
            Offline
            Posted: May 2, 2014, 1:25 pm - IP Logged

            Thanks

            GW

              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3594 Posts
              Offline
              Posted: May 2, 2014, 8:59 pm - IP Logged

              when I tried to download the pic 4 it saysapp not found. why