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

Excel formula Even/Odd, Low/High Pattern, for Pick 5

Topic closed. 12 replies. Last post 3 years ago by helpmewin.

Page 1 of 1
3.34
PrintE-mailLink

United States
Member #150473
December 23, 2013
14 Posts
Offline
Posted: March 25, 2014, 10:51 pm - IP Logged

Hi,

By any chance someone have a the Excel Pattern formula for Odd/Even and Low/High  for

Pick 5 or pick 6 ??

LLLLL 
LLLHL 
LLLHH 
LLHLL 
LLHLH 
etc,etc....

EEOOO 
EOEOO 
EOOEO 

etc,etc....

I'm not an excel expert (that's why i'm looking for help) But i know a lil bit..

My problem is that my excel database and some others (many) formulas are 

done for Pick 5 located 
-."in Single cell"
-."Use dash between numbers" and
-. "low number (1 tru 9 ) use Lead zeroes".

example :

__Column G___ l __Column H__

01-02-03-04-05 l____________

_____________l____________



Please if any of you have such formula let me know, i'll appreciated a lot !!

P.S

The other day i posted a link to share my excel worksheet, but the lotterypost system 

recognize me that i'm new to this forum and i can't post anything.. regarding of .. i don't remember

exactly the reason.. Mr todd mention it..   

Sorry guy's

But keep on mind that if need formulas for same Single cell (Pick 3 to 6) and if i have

i'll share it with you. 

 

Best regards from Miami

David

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Online
    Posted: March 25, 2014, 11:25 pm - IP Logged

    Are you using the 2nd digits to calculate Low/High and Odd/Even?

    For what lottery game

      basilio's avatar - tools

      United States
      Member #145207
      July 31, 2013
      94 Posts
      Offline
      Posted: March 26, 2014, 1:32 am - IP Logged

        United States
        Member #150473
        December 23, 2013
        14 Posts
        Offline
        Posted: March 26, 2014, 10:37 am - IP Logged

        Hi WSLS,

        This is for florida fantasy 5, and to be honest i didn't think it yet to calculate the whole number

        for Low/High and Odd/Even, or 2nd Digit.. very interesting..


        Best Regards

         

        David


          United States
          Member #150473
          December 23, 2013
          14 Posts
          Offline
          Posted: March 26, 2014, 11:06 am - IP Logged

          Hi Basilio,

          Thanks, and i'm sorry to bother with dumb questionUnhappy  .. but

          my problem is That each Combination are in single Cell with "-' between digits

          (not number on separte cell)

          How do Change/replace for a single cell??, i know that it must have a "-" somewhere..
          i'm still learning excel..

           

          Best Regards

           

          David

           

            basilio's avatar - tools

            United States
            Member #145207
            July 31, 2013
            94 Posts
            Offline
            Posted: March 26, 2014, 1:04 pm - IP Logged

            the easiest way would be by using excel test to columns

            google "Split names by using the Convert Text to Columns Wizard",


              United States
              Member #150473
              December 23, 2013
              14 Posts
              Offline
              Posted: March 26, 2014, 1:33 pm - IP Logged

              Hi Basilio,

              Yes, i know how to do the Test to column wizard, (and good suggestion)
              but i can't apply the Wizard, because the other's Formulas, some groups of Macros and UDF's

              are already Appplied for Single Cell, so,


              if I do the Import wizard, these formulas, macros and vba become useless or have to be 

              re do it the whole worksheet. Confused

               

              Thank you so much, i appreciated a lot!!


              Best Regards from Miami

               

              David

                Avatar

                United States
                Member #123200
                February 15, 2012
                52 Posts
                Offline
                Posted: March 26, 2014, 1:43 pm - IP Logged

                Assuming your numbers are like this :  "01-04-12-33-50" in a single cell, the easiest way is to use Excel's "Text to Column" to split these out to seperate columns as was already suggested.  Or use:

                OriginalB1B2B3B4B5OELH
                01-04-12-33-50=INT(LEFT(A2,2))=INT(MID(A2,4,2))=INT(MID(A2,7,2))=INT(MID(A2,10,2))=INT(RIGHT(A2,2))=SUM((ODD(B2:F2)=B2:F2)*1)=SUM((EVEN(B2:F2)=B2:F2)*1)=COUNTIF(B2:F2,"<28")=COUNTIF(B2:F2,">27")

                Which would produce this:

                OriginalB1B2B3B4B5OELH
                01-04-12-33-50141233502332

                Note: I assumed that the highest # whiteball was 55, divided by 2 and assumed anything less than 28 was low and greater than 27 was high.

                Also note that the formulas for "O" (odd) and "E" (Even) are array formulas and must be entered by pressing Shft-Ctrl-Enter after typing in the formula.


                  United States
                  Member #150473
                  December 23, 2013
                  14 Posts
                  Offline
                  Posted: March 26, 2014, 2:47 pm - IP Logged

                  HI   ithastobesaid

                  The formula to count the O/E, L/H, i already have it.

                  What i'm looikng is to apply the pattern, for pick5 in a single cell each number splitted by dash "-"
                   

                  LLLLL 
                  LLLHL 
                  LLLHH 
                  LLHLL 
                  LLHLH 
                  etc,etc....

                  EEOOO 
                  EOEOO 
                  EOOEO 

                  etc,etc.... 

                  any way i have the starting point of the formula supplied by Basilio and i'm working on it..

                  Your Formula is another starting point as well, (appreciated !!!)

                  Thank you so much, every suggestions is welcome !!!Smile



                  Best Regards

                   

                  David

                    basilio's avatar - tools

                    United States
                    Member #145207
                    July 31, 2013
                    94 Posts
                    Offline
                    Posted: March 26, 2014, 3:08 pm - IP Logged

                    Hi Basilio,

                    Thanks, and i'm sorry to bother with dumb questionUnhappy  .. but

                    my problem is That each Combination are in single Cell with "-' between digits

                    (not number on separte cell)

                    How do Change/replace for a single cell??, i know that it must have a "-" somewhere..
                    i'm still learning excel..

                     

                    Best Regards

                     

                    David

                     

                    i made the changes for you, use the same original link to download the updates !

                    good luck


                      United States
                      Member #150473
                      December 23, 2013
                      14 Posts
                      Offline
                      Posted: March 26, 2014, 3:19 pm - IP Logged

                      Hi Basilio,

                       

                      Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!Yes Nod

                      I'll share soon worksheet with all the filters that i'm using.(back testing)

                      I haven't finish.. 

                      Thanks !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

                       

                       

                      Best Regards from Miami

                       

                      David

                        Avatar
                        bgonçalves
                        Brasil
                        Member #92564
                        June 9, 2010
                        2125 Posts
                        Offline
                        Posted: March 26, 2014, 6:58 pm - IP Logged

                        Hello, davidg, good job, ok you're only using the endings (last digit) of each number? Example 17 only using 7 ta? Yes because the initial digit of each number, from 49/6 going 0-4 since the endings 0-9. Those that are filtered (0-9), ie the digit in front of the number does not enter the study? You could see this pattern all along (six digits) xxxxxxou two (xx pairs). This study is good because they predict patterns, the digit that is in default or not?
                        It is a very good way of reduction, along with other filters digits

                          helpmewin's avatar - dandy
                          u$a
                          United States
                          Member #106665
                          February 22, 2011
                          19884 Posts
                          Online
                          Posted: March 28, 2014, 1:57 am - IP Logged

                          wow where you go

                          Let it Snow Snowman