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

Automatic feed data feature to Deflate?

Topic closed. 35 replies. Last post 11 years ago by gilla.

Page 3 of 3
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: October 30, 2005, 3:04 pm - IP Logged

Gilla,

You stated, "I have copy and pasted from the results page and from the daily numbers page. When I paste it into excel, the Pick 3 numbers, all but a handful, are in a date form.(03/05/06) Try and replace the /, and it changes into a 5 digit number resembling nothing that was in the cell". 

Try it again & go to format cells--number--then change to general format. 

It should work then.

Don't know why others are having problems--works fine for me every time.

    gilla's avatar - radar

    United States
    Member #566
    August 13, 2002
    2453 Posts
    Offline
    Posted: October 30, 2005, 3:30 pm - IP Logged
    Here is what it did lottaloot, same thing as trying to Replace / with nothing. All the cash 4 numbers are 3-1-4-8, like before. You can see the cash 3 numbers that come thru ok, but all 5 digit numbers are from the dated form of cash 3 number. ex. 02/04/02. This is how it reads in the cell, but in the formula bar window, it reads 02/04/2002.



    Arizona  37378
    British Columbia38047
    California3996938020
    Connecticut40002
    Delaware4005737837
    Florida39570
    Georgia3762539300
    Idaho0-1-2
    Illinois / Iowa3707340003
    Indiana8-0-439942
    Kansas8-0-9
    Kentucky4002738602
    Louisiana37015
    Maryland3917537106
    Massachusetts
    Michigan3820739881
    Minnesota38777
    Missouri3984938571
    Nebraska39605
    New Jersey0-4-339142
    New Mexico39483
    New York3659439968
    Ohio8-0-037681
    Ontario38604
    Oregon (1pm & 7pm)
    Oregon (4pm & 10pm)
    Pennsylvania3802137716
    Quebec36712
    Rhode Island
    South Carolina396314-0-7
    Tennessee38844
    Texas3930038416
    Tri-State3920438535
    Virginia4006538113
    Washington39668
    Washington, D.C.3741039540
    West Virginia36623
    Western Canada38937
    Wisconsin  0-3-8
       

        gilla

      gilla's avatar - radar

      United States
      Member #566
      August 13, 2002
      2453 Posts
      Offline
      Posted: October 30, 2005, 3:41 pm - IP Logged

      when I hit replace / with nothing it makes the majority of them like this #######. Sorry , I did try the format to general and it gave the 5 digit number.

         

          gilla

        Todd's avatar - Cylon 2.gif
        Chief Bottle Washer
        New Jersey
        United States
        Member #1
        May 31, 2000
        23267 Posts
        Online
        Posted: October 30, 2005, 4:22 pm - IP Logged

        Don't worry about copy and paste from that page anymore.

        I just added a direct load feature:

        http://www.lotterypost.com/thread/122048

         

        Check the State Lottery Report Card
        What grade did your lottery earn?

         

        Sign the Petition for True Lottery Drawings
        Help eliminate computerized drawings!

          Todd's avatar - Cylon 2.gif
          Chief Bottle Washer
          New Jersey
          United States
          Member #1
          May 31, 2000
          23267 Posts
          Online
          Posted: October 30, 2005, 4:22 pm - IP Logged

          The Inspector 3 and Inspector 4 systems provides a means to inspect a list of Pick 3 or Pick 4 lottery numbers and to tabulate the numbers according to a variety of classifications.  This allows you to see if the numbers are biased in any way.  Like the Deflate systems, Inspector 3 and Inspector 4 can be automatically activated and fed data from the Results and Predictions pages.

             Taking the Results of all states on one Page and feed data to Inspector 3  ?

            How?

          Solved.

          http://www.lotterypost.com/thread/122048

           

          Check the State Lottery Report Card
          What grade did your lottery earn?

           

          Sign the Petition for True Lottery Drawings
          Help eliminate computerized drawings!

            gilla's avatar - radar

            United States
            Member #566
            August 13, 2002
            2453 Posts
            Offline
            Posted: October 30, 2005, 5:24 pm - IP Logged

            Thank you Todd, You just keep making it better here.

               

                gilla