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

Cash3 Database Programmers

Topic closed. 10 replies. Last post 13 years ago by Kp2o3.

Page 1 of 1
PrintE-mailLink
Avatar
New Member
Stuart, Florida
United States
Member #2533
October 16, 2003
34 Posts
Offline
Posted: October 16, 2003, 6:57 am - IP Logged

I have the entire Florida Cash-3 History from Day-1. Over 15 YEARS. (5644 Games)

I need to cross check my data with someone who has the same file in order to make sure my data is acurate.

You can send me yours, or I can send you mine. I can supply the data in almost any format.

If no one has this file, maybe someone can tell me where I can get it.

Thanks,

Peter C.

Stuart, Florida

    Cash3's avatar - nw baldy2.jpg
    Florida
    United States
    Member #2157
    August 24, 2003
    47 Posts
    Offline
    Posted: October 16, 2003, 7:02 am - IP Logged

    Hey Peter,

    Do you have excel...if so what version?

      Avatar
      New Member
      Stuart, Florida
      United States
      Member #2533
      October 16, 2003
      34 Posts
      Offline
      Posted: October 16, 2003, 7:09 am - IP Logged

      Yes, I have Excel, but i use MS Access which will import any Excel XLS file.

       

      Peter C.

      Stuart, FL

        Cash3's avatar - nw baldy2.jpg
        Florida
        United States
        Member #2157
        August 24, 2003
        47 Posts
        Offline
        Posted: October 16, 2003, 7:52 am - IP Logged

         

        I use a database of 3206 numbers or a little over 8 years. If you would like I can send it, if your intent on going all the way back try this site...

        http://www.flottery.com/index.htm

        Either way I would be very interested to see what you found and try to play devils advocate for you.

          Avatar
          New Member
          Stuart, Florida
          United States
          Member #2533
          October 16, 2003
          34 Posts
          Offline
          Posted: October 16, 2003, 8:13 am - IP Logged

          Thanks !

          I've already checked what i can from the FlaLotto site. They only go back so far, and not all the way to day 1.

           

          I've found some very interesting stats which i will post in a new topic. I think I have a winning group of numbers.

          Look for my next post in the cash3 forum and see if you agree.

            Cash3's avatar - nw baldy2.jpg
            Florida
            United States
            Member #2157
            August 24, 2003
            47 Posts
            Offline
            Posted: October 16, 2003, 8:15 am - IP Logged

             

            I posted a link to flottery not flalottery...she has the entire history there.

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: October 16, 2003, 8:27 am - IP Logged

              Where did you obtain your file from??

              I have a Florida file from 4/29/1988.

              I can send it as Excel or Text contains Sums Roots Evens Odds??

              Send me a PM if you are interested??

              Thanks

              WSLS

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Offline
                Posted: October 16, 2003, 8:39 am - IP Logged

                I only have 5642 Drawings.

                Here's a suggestion once you start to compare files.

                1.  Paste both files side by side in the same worksheet ib Excel.

                2.  On an open cell on line 1 / drawing 1 use formula function "ABS"

                (absolute value).  If you have each position in a separate cell you would want to compare each position. 

                Compare Position 1 of your history to Position 1 of the new history of drawings. The Poition 2 and Position 3.

                Once you have copied all your formulas in all drawings go back to drawing one to see if there are any values other than 0 (zero).

                If you need help send me your file and I will compare them.

                Hope this made sense??

                Good Luck!!

                WSLS

                  Cash3's avatar - nw baldy2.jpg
                  Florida
                  United States
                  Member #2157
                  August 24, 2003
                  47 Posts
                  Offline
                  Posted: October 16, 2003, 9:03 am - IP Logged

                  If you are using Excel and want to seperate the numbers into individual cells...

                  Put your entire history into one column and select "Tools" then "Macros" then Visual Basic editor

                  Copy and past the following

                  Sub NumRipper()

                  Dim someString
                  Dim numArray

                    Do While Not IsEmpty(ActiveCell)

                    someString = ActiveCell

                  one = Mid(someString, 1, 1)
                    ActiveCell.Offset(0, 2).Select
                    ActiveCell = one
                    ActiveCell.Offset(0, -2).Select
                   
                    two = Mid(someString, 2, 1)
                    ActiveCell.Offset(0, 4).Select
                    ActiveCell = two
                    ActiveCell.Offset(0, -4).Select
                   
                    three = Mid(someString, 3, 1)
                    ActiveCell.Offset(0, 6).Select
                    ActiveCell = three
                    ActiveCell.Offset(0, -6).Select
                   
                  ActiveCell.Offset(1, 0).Select
                  Loop

                  Close the editor and select the first number of the column and again select "Tools" then Macros then Macros again. Select the "Numripper" macro and click "Run"

                  You can change the offset numbers to place the digits in any cell you like.

                  Ummm. hope that made sence...

                    Avatar
                    New Member
                    Stuart, Florida
                    United States
                    Member #2533
                    October 16, 2003
                    34 Posts
                    Offline
                    Posted: October 16, 2003, 10:04 am - IP Logged
                    Quote: Originally posted by Cash3 on October 16, 2003



                     

                    I posted a link to flottery not flalottery...she has the entire history there.





                    Thanks, but they want $ money to join. Although I DO need 3 files, mine and 2 others. 2 files are no good because if you only have 2 files, you don't know which is correct. what are the odds of all 3 being wrong on the same day... hahahah

                     

                    Thanks anyway Cash3.

                      Avatar
                      New Member
                      Stuart, Florida
                      United States
                      Member #2533
                      October 16, 2003
                      34 Posts
                      Offline
                      Posted: October 16, 2003, 10:11 am - IP Logged

                       


                      Chezzz,, wow i didn't mean for you to do all of that, i am really sorry. I guess this is were you and I seperate. I use a "database" and you use the spreadsheet.

                      Can you send me a quick email, and I'll attach my file to the reply.

                       

                      Kp@gate.net

                       

                      Many thanks again.

                      Peter C.

                      Stuart, FL



                      Quote: Originally posted by Cash3 on October 16, 2003







                      If you are using Excel and want to seperate the numbers into individual cells...

                      Put your entire history into one column and select "Tools" then "Macros" then Visual Basic editor

                      Copy and past the following

                      Sub NumRipper()