Welcome Guest
Log In | Register )
You last visited January 21, 2017, 10:35 pm
All times shown are
Eastern Time (GMT-5:00)

Florida: 11/1 - 11/30/2008

Topic closed. 499 replies. Last post 8 years ago by Raven62.

Page 8 of 34
PrintE-mailLink
chippie's avatar - Lottery-064.jpg

Bahamas
Member #31284
January 27, 2006
8962 Posts
Offline
Posted: November 6, 2008, 8:09 pm - IP Logged

680 I know this get hit hard!

    Blackie's avatar - Norfolk 20Sunrise%20Nov%2016.jpg
    Norfolk , Va
    United States
    Member #4541
    May 2, 2004
    25176 Posts
    Offline
    Posted: November 6, 2008, 8:12 pm - IP Logged

    Testing

    815 583 846 648 528 018 826 821 805 816

    Alot of close ones on this test.

     

     Good Luck,

    Blackie.                           

      Avatar
      Florida
      United States
      Member #63353
      July 26, 2008
      546 Posts
      Offline
      Posted: November 6, 2008, 9:06 pm - IP Logged

      missing pairs 00 gone ,06 gone

       

      00,1
      06,8
      36
      45
      49
      55
      56
      58
      66
      78new pair
      88
      99
        Mark J's avatar - 66296264041c9609293964
        florida
        United States
        Member #66642
        November 1, 2008
        679 Posts
        Offline
        Posted: November 6, 2008, 9:08 pm - IP Logged

        For friday evening box

         

         

        1    5    6
        1    5    8
        3    6    4
        3    6    5
        4    5    6
        4    5    8
        4    6    9
        4    6    5
        4    9    8
        5    8    7
        5    8    9
        2    0    2
        0    2    0
        1    5    1
        3    6    3
        4    6    4
        4    5    4
        4    9    4
        5    6    5
        5    8    5
        8    9    8
        9    8    9

         

        Good luck! Type Working on my fatasy 5.

          Mark J's avatar - 66296264041c9609293964
          florida
          United States
          Member #66642
          November 1, 2008
          679 Posts
          Offline
          Posted: November 6, 2008, 9:21 pm - IP Logged

          For friday evening box

          D0-over

          1    5    6
          1    5    8
          3    6    4
          3    6    5
          4    5    6
          4    5    8
          4    6    9
          4    9    8
          5    8    7
          5    8    9

           

          TOT=10

          2    0    2
          0    2    0
          1    5    1
          3    6    3
          4    6    4
          4    5    4
          4    9    4
          5    6    5
          5    8    5
          8    9    8
          9    8    9
          6    4    6
          6    5    6
          6    3    6

           

          Good luck! Type Working on my fatasy 5.

            Mark J's avatar - 66296264041c9609293964
            florida
            United States
            Member #66642
            November 1, 2008
            679 Posts
            Offline
            Posted: November 6, 2008, 9:45 pm - IP Logged

            missing pairs 00 gone ,06 gone

             

            00,1
            06,8
            36
            45
            49
            55
            56
            58
            66
            78new pair
            88
            99

            jgdr,

            if you had use the 10 most overdrew pairs with out the doubles,

            and combine all with pair tha has a matching number you would have gotten 680 tonight

            look: 06 - 08 - 02 - 36 - 45 - 49 - 56 - 58 - 78 - 89

                  =068

            Check it out and let me knowType

              Avatar
              Florida
              United States
              Member #63353
              July 26, 2008
              546 Posts
              Offline
              Posted: November 6, 2008, 10:32 pm - IP Logged

              Good observation mark

              I still dont have a database of most overdrawn pairs I will have to look into creating one to mix with missing pairs

              thats one of the problem im having what to combine the missing pairs with so now you gave me something to work on thanks

               

              also todays date 11-06-08

                Mark J's avatar - 66296264041c9609293964
                florida
                United States
                Member #66642
                November 1, 2008
                679 Posts
                Offline
                Posted: November 6, 2008, 10:52 pm - IP Logged

                jgdr,

                   You would not believe what I,m about to do to the fantasy 5

                 find the 5 most overdrew pairs remove the matching numbers playing the rest

                 are combine the matching pairs and then remove the same numbers

                also doing a combo pair sum of each draw that gives 5 numbers that may hardly ever repeats

                may also play the five numbers or add them to the overdew numbers, alot to do Type

                  Mark J's avatar - 66296264041c9609293964
                  florida
                  United States
                  Member #66642
                  November 1, 2008
                  679 Posts
                  Offline
                  Posted: November 6, 2008, 11:36 pm - IP Logged

                  Good observation mark

                  I still dont have a database of most overdrawn pairs I will have to look into creating one to mix with missing pairs

                  thats one of the problem im having what to combine the missing pairs with so now you gave me something to work on thanks

                   

                  also todays date 11-06-08

                  jgdr, you dont need "database of most overdrawn pairs" it is easy to find any result in excel

                  history

                   

                      A          B    C    D
                  6-Nov-08    6    8    0
                  5-Nov-08    0    1    0
                  4-Nov-08    2    6    9
                  3-Nov-08    3    9    7
                  2-Nov-08    3    2    3
                  1-Nov-08     2    2    5
                  31-Oct-08     6    1    8
                  30-Oct-08     3    7    4
                  29-Oct-08    1    7    6

                   

                   

                   

                   

                     E  FGHIJKLMNOPQRSTUVWXYZ

                   10000000000111111111 pairs down row 1to2

                   20123456789123456789

                   3:  =COUNTIF(A4:A100,2)    =      RESULT for pair 00   repeat accross only

                   4:   =COUNTIF($B1:$D1,F1)+COUNTIF($B1:$D1,G1)   

                   5:   repeat down and across

                  NEED A CELL TO TOT UP ROW USE CELL E3  Type

                   

                   

                   

                   

                    Mark J's avatar - 66296264041c9609293964
                    florida
                    United States
                    Member #66642
                    November 1, 2008
                    679 Posts
                    Offline
                    Posted: November 6, 2008, 11:41 pm - IP Logged

                    jgdr, you dont need "database of most overdrawn pairs" it is easy to find any result in excel

                    history

                     

                        A          B    C    D
                    6-Nov-08    6    8    0
                    5-Nov-08    0    1    0
                    4-Nov-08    2    6    9
                    3-Nov-08    3    9    7
                    2-Nov-08    3    2    3
                    1-Nov-08     2    2    5
                    31-Oct-08     6    1    8
                    30-Oct-08     3    7    4
                    29-Oct-08    1    7    6

                     

                     

                     

                     

                       E  FGHIJKLMNOPQRSTUVWXYZ

                     10000000000111111111 pairs down row 1to2

                     20123456789123456789

                     3:  =COUNTIF(A4:A100,2)    =      RESULT for pair 00   repeat accross only

                     4:   =COUNTIF($B1:$D1,F1)+COUNTIF($B1:$D1,G1)   

                     5:   repeat down and across

                    NEED A CELL TO TOT UP ROW USE CELL E3  Type

                     

                     

                     

                     

                    jgdr, you dont need "database of most overdrawn pairs" it is easy to find any result in excel

                    history  CORRECTION TO ROW 3 IS F4

                     

                     

                     

                     

                      A          B    C    D

                    6-Nov-08    6    8    0
                    5-Nov-08    0    1    0
                    4-Nov-08    2    6    9
                    3-Nov-08    3    9    7
                    2-Nov-08    3    2    3
                    1-Nov-08     2    2    5
                    31-Oct-08     6    1    8
                    30-Oct-08     3    7    4
                    29-Oct-08    1    7    6

                     

                     

                     

                     

                       E  FGHIJKLMNOPQRSTUVWXYZ

                     10000000000111111111 pairs down row 1to2

                     20123456789123456789

                     3:  =COUNTIF(F4:F100,2)    =      RESULT for pair 00   repeat accross only

                     4:   =COUNTIF($B1:$D1,F1)+COUNTIF($B1:$D1,G1)   

                     5:   repeat down and across

                    NEED A CELL TO TOT UP ROW USE CELL E3  Type

                     

                      Avatar
                      Florida
                      United States
                      Member #63353
                      July 26, 2008
                      546 Posts
                      Offline
                      Posted: November 7, 2008, 2:25 am - IP Logged

                      Hey mark which formula I put in which cell

                        Mark J's avatar - 66296264041c9609293964
                        florida
                        United States
                        Member #66642
                        November 1, 2008
                        679 Posts
                        Offline
                        Posted: November 7, 2008, 3:44 am - IP Logged

                        Hey mark which formula I put in which cell

                        Ther is a little mor to it because of the doubles they well equal to 3,4 & 6 so they would have to be done in a defernt way but in the same location

                        but let' get started on geting it started

                        1: sheet1 data history so you can insert data without causing the fomula to move with the cell and not celeting the new data .

                        2: copy and past on sheet2 cell A1 all the colunms of the data frome sheet1

                        so now u have A1=THE DATE, B2 = THE FIRST NUM, B3=2ND C3=3RD

                        NOW in CELL "F1" DO THIS: =B1 then G1=C1, H1=D1  NOW THE DATA HISTORY IS MOVE TO CELL E,F & G COPY PAST DOWN OR FILL

                        NOW in CELL J1 enter =IF(H2=F2,"",F2) , CELL K1 =IF(G2=F2,"",G2), CELL LI =IF(H2=G2,"",H2) COPY PAST DOWN OR FILL

                        NEXT SHEET3 IS WERE WE DO THE FORMULA WITH ALL THE PAIR AT THE TOP THE REASON WE DID ALL THIS IS TO CREAT 2 DIFERENT DATA FOR WHEN

                        WE HAVE DOUBLES HAS U NOTICE THE LAST 3 CELL WE CREATED REMOVE THE DOUBLES,

                        WHE THE FIRST 3 CELL THIS IS WRE WE DICIED HOW MUCH DRAWING YOU WANT TO SELECT FROME THE DATA WITH OUT DELETING

                        SHEET 3 COMING SOON

                          Mark J's avatar - 66296264041c9609293964
                          florida
                          United States
                          Member #66642
                          November 1, 2008
                          679 Posts
                          Offline
                          Posted: November 7, 2008, 4:38 am - IP Logged

                            CELL B1:    0    1    2    3    4    5    6    7    8    9    0    0    0    0    0    0    0    0    0    1    1    1    1    1    1    1    1    2    2    2    2    2    2    2    3    3    3    3    3    3    4    4    4    4    4    5    5    5    5    6    6    6    7    7    8
                            CELL B2:    0    1    2    3    4    5    6    7    8    9    1    2    3    4    5    6    7    8    9    2    3    4    5    6    7    8    9    3    4    5    6    7    8    9    4    5    6    7    8    9    5    6    7    8    9    6    7    8    9    7    8    9    8    9    9
                                                                                                                                                                                                                                                     
                               

                          SHEET3

                          COPY THIS DATA OF ALL THE PAIRS TO EXCEL

                          BOLD AN LARGE  THE PAIRS GO FROME ROW 1 TO ROW 2 , I fill in red and make the numbers white

                          Next: IN CELL B3 COPY AND PAST THIS:   =COUNTIF(B$6:B$2924,">=4")   THEN COPY THIS AND ACCROSS TO THE RIGHT FILL B3-K2 THIS TAKES CARE OF THE DOUBLES

                          NEXT: CELL L1 COPY AND PAST THIS:      =COUNTIF(L$6:L$2924,2)  THEN COPY THIS AND FILL ACCROSS TO THE RIGHT

                          NEXT: CELL B6 COPY AND PAST THIS:   =COUNTIF(Sheet2!$F1:$H1,B$1)+COUNTIF(Sheet2!$F1:$H1,B$2) THEN COPY THIS AND ACCROSS TO THE RIGHT FILL B3-K2 THIS TAKES CARE OF THE DOUBLES

                          NEXT: CELL L1 COPY AND PAST THIS:    =COUNTIF(Sheet2!$J1:$L1,L$1)+COUNTIF(Sheet2!$J1:$L1,L$2)  THEN COPY THIS AND FILL ACCROSS TO THE RIGHT

                          NOW SELECT THE SAME ROW B6 COPY THEN DOWN AND PAST 1000 ROW SHOULD DO IT , DONT FILL  JUST TO BE SAFE!

                          NEXT YOU NEED THE RESUTS OF THE 0 TO GET COUNTED THEY ARE THE NUMBERS THAT DID NOT SHOW UP BECAUSE

                          ON SHEET 2 YOU DECIDED HOW MUCH DRAWING YOU WATED TO COVER WITH THE FIRST SET OF FOMULA FOR THE DOUBLES KEEP IN MIND THAT THE SINGLE PAIR ONLY WORKS IF THERE IS DATA IN THE FOMULA FOR THE DOUBLES

                          NEXT THE 0 COUNT OF ALL THE DOUBLES : IN CELL A2 : =COUNTIF($B4:K4,0)

                          NEXT THE 0 COUNT OF ALL SINGLE PAIR  :  =COUNTIF(L4:$IV4,0)   

                          ON SHEET2 YOU MAY WANT TO TRAKE THE RESULT FROME SHEET3 SO THAT YOUR GETING THE ONE U WANT  SO IN CELL E2 UNDER THE WORDS DOUBLES PAST THIS =Sheet3!$A$3   DOWN 500 IS MORE THAN ENOUGH

                          THEN CELL I1 UNDER THE WORDS SINGLE PAST  =Sheet3!$A$4  DOWN 500 

                          PLEASE LET ME KNOW WHEN IT"S DONE OR PROBLEMS Type NOTE DATA HISTORY NO TEXT ABOVE THE NUMBERS

                            Mark J's avatar - 66296264041c9609293964
                            florida
                            United States
                            Member #66642
                            November 1, 2008
                            679 Posts
                            Offline
                            Posted: November 7, 2008, 5:22 am - IP Logged

                            jdgr,

                             Remember after u copy the fomula to excel press return to get out and very important when copy and filling the other cell you should not copy the formula in the cell

                            but just the cell with the fomula so that the formula change fome cell to cell

                            to see the final sesult that u need you go to sheet 3 and look in row 3 under the pairs if you want to know the most over drew, pairs with the 0

                            u can also see how many times the hit,

                            to get both the overdew numbers without omiting sengels or doubles just make sure all the fomula's of both are covering the same amount of cell at the same time 

                            so just HIGHLIGHT CELL E-L AND COPY DOWN IF YOU GO TOO FAR JUST HIGHLIGHT AND PRES DELETE EVERY TIME ontil you get the amount of pairs u want.

                            DoneType

                              Avatar
                              Florida
                              United States
                              Member #63353
                              July 26, 2008
                              546 Posts
                              Offline
                              Posted: November 7, 2008, 6:06 am - IP Logged

                              Thanks mark

                              Oh now I know why your overdrawn pair didnt match with mines I was goin back 31 days and you 30

                                 
                                Page 8 of 34