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

Pick 3 Strings - All States

Topic closed. 83 replies. Last post 1 year ago by Claret.

Page 6 of 6
57
PrintE-mailLink
mmx1's avatar - 8ball

Canada
Member #90040
April 20, 2010
473 Posts
Offline
Posted: November 28, 2015, 1:24 pm - IP Logged

In the nm2 results are these combined for both draws?

Thanks.

No, xx2 is morning only.

NM5 is combined.

 

Look at the blue top left corner or glossary in the thread:

xx1 - morning (8:00 -12:00 EST)

xx2 - midday (12:00 -16:00 EST)

xx3 - evening (16:00 - 20:00 EST)

xx4 - night (20:00 - 24:00 EST)

xx5 - combined

    Avatar

    United States
    Member #163635
    February 6, 2015
    103 Posts
    Offline
    Posted: November 28, 2015, 10:05 pm - IP Logged

    Hello Winsum can you please help me i'm having  problem updating the state draw 

    when i copy and paste all i get is (###) can you tell me what im doing wrong 

    excel 2016, windows 10, google chrome

    thanks

      Avatar

      United States
      Member #163635
      February 6, 2015
      103 Posts
      Offline
      Posted: November 28, 2015, 10:18 pm - IP Logged

      windows 7 excel 2007 google chrome still having the same problem

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

        Hello Winsum can you please help me i'm having  problem updating the state draw 

        when i copy and paste all i get is (###) can you tell me what im doing wrong 

        excel 2016, windows 10, google chrome

        thanks

        https://copy.com/aBc7GiphDOiAQFXE

        Download link to P3StateDraws.xlsm file

        Draws updated through November 28, 2015

        Possible solutions:

        May not have macros enabled or security set too high

        Check Data > Text to Columns > Delimited 'check to see if that Tab is the only box checked

        Semicolon Comma, Space, Other should NOT be checked..

        Let me know if this worked!!

        Or use the link above each morning when I update the file

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

          Pick 4 Strings - One State Excel files

          Use the videos for the Pick 3 but change the names of the Excel files to P4 instead of P3

          Video 1 (Part 1)

          https://copy.com/RMPsBrfuJn2cIxEu

          Video 2 - Single State Games (Part 2)

          https://copy.com/nNKQRmkg4lwwMPFN

           

          Zip file to the Pick 4 Excel files:

          https://copy.com/bEsyO9gqgdXz8HUU

           

          Create a new folder and name the new folder whatever you like. Example, "P4StringsOneState"

          Unzip the Excel files into the new folder

          Watch the videos....

            Avatar
            Galloway, Ohio
            United States
            Member #163255
            January 24, 2015
            309 Posts
            Offline
            Posted: December 3, 2015, 12:30 pm - IP Logged

            Thanks for all this awesome work!  Is there another thread that is posting about Pick 4 or post questions here?  Is this the only thread that is posting about strings?  Have a couple questions about instructions on the videos.

              Avatar
              Galloway, Ohio
              United States
              Member #163255
              January 24, 2015
              309 Posts
              Offline
              Posted: December 4, 2015, 10:13 pm - IP Logged

              Pick 4 Strings - One State Excel files

              Use the videos for the Pick 3 but change the names of the Excel files to P4 instead of P3

              Video 1 (Part 1)

              https://copy.com/RMPsBrfuJn2cIxEu

              Video 2 - Single State Games (Part 2)

              https://copy.com/nNKQRmkg4lwwMPFN

               

              Zip file to the Pick 4 Excel files:

              https://copy.com/bEsyO9gqgdXz8HUU

               

              Create a new folder and name the new folder whatever you like. Example, "P4StringsOneState"

              Unzip the Excel files into the new folder

              Watch the videos....

              Got all the files but do not know where to see the sets to play liker in the P3 files.  Also did not know what to click to see what you displayed when clicking under columns I and J.  Also you have strings 13 and 14 selected for strings 5 and 6.  Do you suggest these to calculate for P4?  Thanks  Anyone can jump in here since I know Winsum in very busy.

                Avatar

                United States
                Member #163635
                February 6, 2015
                103 Posts
                Offline
                Posted: December 5, 2015, 9:27 am - IP Logged

                Hello Winsum sorry for the late reply I tried what you suggested but still no working.

                  Avatar
                  Galloway, Ohio
                  United States
                  Member #163255
                  January 24, 2015
                  309 Posts
                  Offline
                  Posted: December 7, 2015, 7:11 pm - IP Logged

                  I get those #'s when I do not have the correslonding worksheet up.  Like I have to have States and Step 1 up together.  Do not know if that helps you but that happens to me.