Welcome Guest
Log In | Register )
The time is now 7:11 pm
You last visited October 24, 2014, 7:07 pm
All times shown are
Eastern Time (GMT-5:00)

Help Help Help Pick 3 Rundown

Topic closed. 20 replies. Last post 8 years ago by 4mybrdz.

Page 1 of 2
PrintE-mailLink
Avatar
bethesda,maryland
United States
Member #36946
April 9, 2006
41 Posts
Offline
Posted: May 27, 2006, 12:50 pm - IP Logged

Is there anyone out there that can tell me how to get my excel spreadsheet to do lottery math, no carrying.

Ex: 9,8,7,6,5,4,3,2,1,0 

Just like the DSUM. I want the numbers to reduce without carrying.

249

138

027

916

805

794

etc.......

All have been reading the many posts of DSUM, but can someone tell me how to get this to work in microsoft excel.

 The manual rundown is brutal and time consuming.

 

Thanks, look forward to your replies.

    Tenaj's avatar - michellea
    Charlotte NC
    United States
    Member #17406
    June 18, 2005
    4036 Posts
    Offline
    Posted: May 27, 2006, 1:25 pm - IP Logged

    Smash

    =IF(A1=0,9,A1-1)

    PM me your email address and I will send it to you already done.

    takeemtothebank

      Raven62's avatar - binary
      New Jersey
      United States
      Member #17843
      June 28, 2005
      17937 Posts
      Offline
      Posted: May 27, 2006, 6:23 pm - IP Logged

      Is there anyone out there that can tell me how to get my excel spreadsheet to do lottery math, no carrying.

      Ex: 9,8,7,6,5,4,3,2,1,0 

      Just like the DSUM. I want the numbers to reduce without carrying.

      249

      138

      027

      916

      805

      794

      etc.......

      All have been reading the many posts of DSUM, but can someone tell me how to get this to work in microsoft excel.

       The manual rundown is brutal and time consuming.

       

      Thanks, look forward to your replies.

      The orginal design of DSUM calls for +111, but it looks like you are doing -111.

      Excel Lottery Math:
      MOD(SUM(A9+1),10)
      MOD(SUM(A9-1),10)

        Tenaj's avatar - michellea
        Charlotte NC
        United States
        Member #17406
        June 18, 2005
        4036 Posts
        Offline
        Posted: May 27, 2006, 9:04 pm - IP Logged

        SmashMy bad I meant to do plus one. 

         

        This will do the same that you have above.

        =MOD(A1+1,10)

         

        The orginal rundown would look like this for 111

        111

        111

        000

        234

        999

        357

        888

        470

        777

        593

        666

        616

        555

        739

        444

        852

        333

        975

        222

        098

        111

        111

         

        This is Kola's

        1

        1

        1

        2

        2

        2

        3

        3

        3

        4

        4

        4

        5

        5

        5

        6

        6

        6

        7

        7

        7

        8

        8

        8

        9

        9

        9

        0

        0

        0

        1

        1

        1

        And it doesn't matter whether you go minus or plus it wraps around to the same numbers forever.

        takeemtothebank

          Tenaj's avatar - michellea
          Charlotte NC
          United States
          Member #17406
          June 18, 2005
          4036 Posts
          Offline
          Posted: May 27, 2006, 9:21 pm - IP Logged

          SmashAnd if you think my way is crap, I hit 823 straight in NY midday today.

          700

          700

          699

          823

          588

          946

          477

          069

          366

          182

          255

          205

          144

          328

          033

          441

          922

          564

          811

          687

          700

          700

          The original shows you all the numbers that are associated with the number that is rundown.  Not saying that Kola's system is not good because it is good if you are a seasoned player.

          These are the hits that have hit since yesterday just from this 700 rundown.

           

          Sat, May 27, 2006DelawarePlay 35-6-4
          Sat, May 27, 2006GeorgiaMidday 34-1-4
          Sat, May 27, 2006IllinoisMidday 38-5-8
          Sat, May 27, 2006New YorkMidday Numbers8-2-3
          Fri, May 26, 2006IdahoPick 32-0-5
          Fri, May 26, 2006MarylandMidday Pick 35-8-8
          Fri, May 26, 2006MissouriMidday Pick 36-4-5
          Fri, May 26, 2006TennesseeCash 35-4-6
          Fri, May 26, 2006Washington, D.C.Lucky Numbers9-4-6

           

           

          What I do is find the rundowns that are driving the states (leading) and play the number that I come up with straight across the board.

          takeemtothebank

            Tenaj's avatar - michellea
            Charlotte NC
            United States
            Member #17406
            June 18, 2005
            4036 Posts
            Offline
            Posted: May 28, 2006, 1:46 pm - IP Logged

            700 RUNDOWN HITS THIS MIDDAY TODAY

            700

            700

            699

            823

            588

            946

            477

            069

            366

            182

            255

            205

            144

            328

            033

            441

            922

            564

            811

            687

            700

            700

            Sun, May 28, 2006

            Multi-StateTri-State Pick 3 Midday6-8-7
            Sun, May 28, 2006New JerseyMidday Pick 35-2-5
            Sun, May 28, 2006New YorkMidday Numbers1-4-4
            Sun, May 28, 2006MichiganMidday 35-2-0

            takeemtothebank

              Avatar
              bethesda,maryland
              United States
              Member #36946
              April 9, 2006
              41 Posts
              Offline
              Posted: May 28, 2006, 2:02 pm - IP Logged

              Thanks all for you help on the excel issues, I really appreciate it.

                Tenaj's avatar - michellea
                Charlotte NC
                United States
                Member #17406
                June 18, 2005
                4036 Posts
                Offline
                Posted: May 28, 2006, 2:04 pm - IP Logged

                Thanks all for you help on the excel issues, I really appreciate it.

                U R Welcome. 

                takeemtothebank

                  Avatar
                  bethesda,maryland
                  United States
                  Member #36946
                  April 9, 2006
                  41 Posts
                  Offline
                  Posted: May 28, 2006, 2:04 pm - IP Logged

                  700 RUNDOWN HITS THIS MIDDAY TODAY

                  700

                  700

                  699

                  823

                  588

                  946

                  477

                  069

                  366

                  182

                  255

                  205

                  144

                  328

                  033

                  441

                  922

                  564

                  811

                  687

                  700

                  700

                  Sun, May 28, 2006

                  Multi-StateTri-State Pick 3 Midday6-8-7
                  Sun, May 28, 2006New JerseyMidday Pick 35-2-5
                  Sun, May 28, 2006New YorkMidday Numbers1-4-4
                  Sun, May 28, 2006MichiganMidday 35-2-0

                  Tenaj,

                   

                  Looks good, but where did the source number of 700 come from?  Did you pull this number out of the hat?  Also it appears you only are using the 1st row or string of 10 picks going down, down, down.

                  Awaiting reply.

                    misssally's avatar - Trek COMUNCTR.gif
                    Decatur, Georgia
                    United States
                    Member #4705
                    May 18, 2004
                    330 Posts
                    Offline
                    Posted: May 28, 2006, 2:21 pm - IP Logged

                    SmashAnd if you think my way is crap, I hit 823 straight in NY midday today.

                    700

                    700

                    699

                    823

                    588

                    946

                    477

                    069

                    366

                    182

                    255

                    205

                    144

                    328

                    033

                    441

                    922

                    564

                    811

                    687

                    700

                    700

                    The original shows you all the numbers that are associated with the number that is rundown.  Not saying that Kola's system is not good because it is good if you are a seasoned player.

                    These are the hits that have hit since yesterday just from this 700 rundown.

                     

                    Sat, May 27, 2006DelawarePlay 35-6-4
                    Sat, May 27, 2006GeorgiaMidday 34-1-4
                    Sat, May 27, 2006IllinoisMidday 38-5-8
                    Sat, May 27, 2006New YorkMidday Numbers8-2-3
                    Fri, May 26, 2006IdahoPick 32-0-5
                    Fri, May 26, 2006MarylandMidday Pick 35-8-8
                    Fri, May 26, 2006MissouriMidday Pick 36-4-5
                    Fri, May 26, 2006TennesseeCash 35-4-6
                    Fri, May 26, 2006Washington, D.C.Lucky Numbers9-4-6

                     

                     

                    What I do is find the rundowns that are driving the states (leading) and play the number that I come up with straight across the board.

                    So, how do you find the rundowns that are leading for the states?

                      Tenaj's avatar - michellea
                      Charlotte NC
                      United States
                      Member #17406
                      June 18, 2005
                      4036 Posts
                      Offline
                      Posted: May 28, 2006, 2:54 pm - IP Logged

                      Yes NodA good start is to recognize the traveling numbers.  They dominate.  821 combo seemed to me to fall every other day this month.  And then 823 took on the same vibration.  They travel together with 228 and 882.  I ran down 823 and that's where I got the 700 and when 182 appeared in the rundown I knew it was right. 

                      Michigan get 712 the other day.  And 590 have been traveling as well.  Those numbers that you see like 095 are the pointers.  When numbers hit statewide they are connected to the same rundowns.  Some of the states that have been getting this "cluster of numbers" will get the numbers associated in these wraps.  And when it hit the board what pushed it out before will return. 

                      Compare the 700 rundown and the 823 rundown and see the same numbers and NEW numbers and when I say new numbers that's the movement or "shift" if I may.lol  Notice 045 combo that fell today.  That's how the wrap works.  That's why I said buy the book.  It's ready made with the rundowns already done.  The rundown works way deeper than this but I am just trying the answer the question where did you get the 700. 

                       

                      Tue, May 23, 2006OhioPick 38-2-1
                      Fri, May 19, 2006TexasMidday Pick 31-8-2
                      Sat, May 13, 2006DelawarePlay 31-8-2
                      Fri, May 12, 2006Western CanadaPick 31-2-8
                      Thu, May 11, 2006MissouriPick 31-8-2
                      Tue, May 9, 2006South CarolinaMidday 31-8-2
                      Mon, May 8, 2006OntarioPick 32-8-1
                      Fri, May 5, 2006MissouriMidday Pick 32-8-1
                      Fri, May 5, 2006OhioPick 31-8-2
                      Fri, May 5, 2006West VirginiaDaily 38-1-2
                      Wed, May 3, 2006MinnesotaDaily 38-2-1
                      Tue, May 2, 2006VirginiaPick 38-2-1

                       

                      8

                      2

                      3

                       

                      8

                      2

                      3

                      7

                      1

                      2

                       

                      9

                      4

                      6

                      6

                      0

                      1

                       

                      0

                      6

                      9

                      5

                      9

                      0

                       

                      1

                      8

                      2

                      4

                      8

                      9

                       

                      2

                      0

                      5

                      3

                      7

                      8

                       

                      3

                      2

                      8

                      2

                      6

                      7

                       

                      4

                      4

                      1

                      1

                      5

                      6

                       

                      5

                      6

                      4

                      0

                      4

                      5

                       

                      6

                      8

                      7

                      9

                      3

                      4

                       

                      7

                      0

                      0

                      8

                      2

                      3

                       

                      8

                      2

                      3

                       

                       

                      Sat, May 27, 2006New YorkMidday Numbers8-2-3
                      Thu, May 25, 2006West VirginiaDaily 33-2-8
                      Wed, May 24, 2006Multi-StateTri-State Pick 38-2-3
                      Wed, May 24, 2006South CarolinaMidday 32-3-8
                      Tue, May 23, 2006MissouriPick 32-8-3
                      Fri, May 19, 2006Western CanadaPick 32-3-8
                      Wed, May 10, 2006DelawareMidday 32-3-8
                      Mon, May 8, 2006MinnesotaDaily 33-2-8
                      Sun, May 7, 2006FloridaCash 33-8-2
                      Sat, May 6, 2006Multi-StateTri-State Pick 38-2-3
                      Wed, May 3, 2006KansasPick 38-2-3
                      Mon, May 1, 2006CaliforniaMidday 33-8-2
                      Mon, May 1, 2006Multi-StateTri-State Pick 3 Midday8-2-3

                      takeemtothebank

                        Tenaj's avatar - michellea
                        Charlotte NC
                        United States
                        Member #17406
                        June 18, 2005
                        4036 Posts
                        Offline
                        Posted: May 28, 2006, 3:14 pm - IP Logged

                        SMB1988

                        Yes, the wrap "Rundown" that I use is quite different from Kola's however Kola does use the plus side.  When you are moving it doesn't mattter whether you go up or down.  So the minus down that I use gives the same results and going plus.

                        However this is what the orginal rundown is and I've posted this I don't know how many times on LP and it went ignored while trying to explain Lottery Math. 

                        There are two sides (columns) the Minus Side and the Plus Side.  And the number MIRRORS on the fifth down.  V-trac does a good job tracking this mirrors.  I wish we can search V-trac strings but that beside the point.

                        The left column you go minus 1 going down on all three digits until it wraps.

                        The right column you go plus one going down (like Kola) on the first digit until it wraps

                        you go plus 2 on the second digit until it wraps

                        you go plus 3 on the third digit until it wraps

                        What you are getting are all the numbers that are associated with the original number.  But hold on that's not the only place that number is because you got 000-999 but that's a different post.

                        takeemtothebank

                          Avatar
                          Richland/Pennsylvania
                          United States
                          Member #8180
                          October 26, 2004
                          176 Posts
                          Offline
                          Posted: May 28, 2006, 3:55 pm - IP Logged

                          looking at your numbers and knowing what just fell yesterday gave me 687 for today...Thanks Tenaj!!Like you say..Take it to the Bank!!

                            Tenaj's avatar - michellea
                            Charlotte NC
                            United States
                            Member #17406
                            June 18, 2005
                            4036 Posts
                            Offline
                            Posted: May 28, 2006, 10:19 pm - IP Logged

                            looking at your numbers and knowing what just fell yesterday gave me 687 for today...Thanks Tenaj!!Like you say..Take it to the Bank!!

                            SmashU R Welcome.

                            takeemtothebank

                              tianca's avatar - Lottery-027.jpg
                              toronto
                              Canada
                              Member #11169
                              February 6, 2005
                              170 Posts
                              Offline
                              Posted: May 28, 2006, 11:41 pm - IP Logged

                              hi tenaj.....what is the name of the book?.......thank u