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

History of Cash 3 Florida

Topic closed. 6 replies. Last post 10 years ago by SirMetro.

Page 1 of 1
PrintE-mailLink
floridian's avatar - DiscoBallGlowing

United States
Member #45802
August 28, 2006
335 Posts
Offline
Posted: September 22, 2006, 2:25 pm - IP Logged

I would appreciate it if someone could tell me how I might get all the past draws from the Florida Cash 3.  I am trying to get all the draws from inception which was I believe was 1988. 

The Florida Lottery site provides this info but it is so convoluted that you cannot extract the real data without going through a mess of cut and pastes.  All Lotto is the same way except you can get a month at a time to cut and paste but it will take forever.

I need the data in a form that each number is going from newest to oldest in one column with each digit separated by a space.  I think I have a little utility that will put in the spaces but the number extraction is the big thing.  I guess I will have to do one number at a time if no one has anything.  I am not wanting anyone to do the work for me I just need some direction.

I am new at this and have very little money but want a chance to do myself so good.

Floridian

    Avatar
    New Member
    pensacola,florida
    United States
    Member #25030
    October 30, 2005
    21 Posts
    Offline
    Posted: September 22, 2006, 2:37 pm - IP Logged

    Have you tried ?

      Avatar
      New Member
      pensacola,florida
      United States
      Member #25030
      October 30, 2005
      21 Posts
      Offline
      Posted: September 22, 2006, 2:38 pm - IP Logged

      Don't know what happened.

        1977's avatar - flower2
        st. pete
        United States
        Member #6680
        September 3, 2004
        1226 Posts
        Offline
        Posted: September 22, 2006, 2:57 pm - IP Logged

        There is a book at 7-11 that has the run down of all the florida numbers  in it  from begin to  date .I think it a $1.25. It has used cars etc in it. Can't think of the  name right now .

          SirMetro's avatar - center
          East of Atlanta
          United States
          Member #6191
          August 11, 2004
          1389 Posts
          Offline
          Posted: September 22, 2006, 3:53 pm - IP Logged

          I took a quick look at Florida's Lottery, downloaded the 33 page HTML and did a simple cut and paste. All data ported in and sorted in less then 5 minutes.

          Due to the huge amount of data, it is really slow, but it's not very difficult to port the numbers into Excel all at once.

          Here is what you will want to do

          1) Open the Florida's Lottery Web Page and select HTML as how you want the numbers to be displayed.

          2) Once ALL the numbers have been displayed, right mouse click on the screen and click on "SELECT ALL"

          3) Open a new Excel spreadsheet, make sure you are in Cell A1 and PASTE it (pressing CNTRL + V works as well).

          Here is the tricky part 

          4) Now, to get just the part you want, once it's all pasted in place, do this

          5) When you look at the screen, it will look really goofy, ignore that.

          6) Select the Column the Data first starts in and while holding down the SHIFT KEY, select the Column the Data ends in. You can do one group at a time or all at one time. I suggest 1 at a time.

          7) Press CNTRL + C (or COPY), then

          8) on a NEW Sheet, PASTE the copied Columns in place,

          repeat 6 thru 8 until all the data is transferred.

          Also, some of the dates are in 2 columns, make sure to get both.

          9) Once ALL of the data is copied to the new sheet, click in the top Left corner of the spreadsheet to SELECT ALL

          10) Right mouse click and select FORMAT CELLS

          11) pick the 2nd Tab (ALIGNMENT) and

          12) click on the box beside where it is noted as WRAP TEXT & MERGE CELLS, you want these 2 boxes to be clear (not checked or highlighted)

          13) Now, simple delete the unwanted columns

          14) Select the first set of columns (date column thru the last data column) 

          15) using the QuickSort Icon (has the letters Z/A on top of each other with an arrow pointing down)

          Repeat 13 thru 14 until all the data is sorted.

          16) Now, simply copy each group of the data and paste it UNDER the first set. Keep doing this until you have all four sets into the same column group

          17) Do one last quick sort and you are all done and the data is ready to be manipulated any way your heart desires

          And yes, I am making an assumption you know how to operate Excel.

          Good Luck,

          Sir Metro

            floridian's avatar - DiscoBallGlowing

            United States
            Member #45802
            August 28, 2006
            335 Posts
            Offline
            Posted: September 22, 2006, 4:13 pm - IP Logged

            Sir Metro:

            As usual, I am beholding to you.  Thanks I will try it and appreciate you spending this much time trying to help me.

            Salute

             

            Floridian

              SirMetro's avatar - center
              East of Atlanta
              United States
              Member #6191
              August 11, 2004
              1389 Posts
              Offline
              Posted: September 22, 2006, 4:24 pm - IP Logged

              Was not a problem and if you email me, I will send you the data in an excel sheet, already sorted and processed and ready to dig into.

              BTW...my picks for FL for tonite is

              873 & 893

              Also, look out for

              200, 219, 228, 237, 246, 255, 208, 217, 226, 235, 244, 299

              This table shows you how long it's been since each number hit

               

              Evening
              AOBOCO
              221314416
              913112814
              01199613
              577829
              355718
              744656
              636494
              422373
              118131
              800000

               

              Hope you have fun