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

111 pick 3 rundown (stack version) generator

Topic closed. 11 replies. Last post 11 months ago by FLATRANSPLANT.

Page 1 of 1
PrintE-mailLink
amber123's avatar - OpIFNim

United States
Member #164727
March 12, 2015
2524 Posts
Offline
Posted: November 30, 2015, 2:46 pm - IP Logged

Can anyone here create a program that makes a vertical stack for a 111 rundown in the pick-3 game? I found one online but it's a horizontal version. I want to do an extensive back-test making it quicker to do.

Thanks !

So If I input 123 it will generate this:

123 

234

345

456

567

678

789

890

901

    Todd's avatar - Cylon 2.gif
    Chief Bottle Washer
    New Jersey
    United States
    Member #1
    May 31, 2000
    23267 Posts
    Offline
    Posted: November 30, 2015, 4:52 pm - IP Logged

    <Moved to Pick 3 forum>

    Please post in the appropriate forum ... thank you.

      realtorjim's avatar - images q=tbn:ANd9GcT7U3t20NgScoPlxOqLT6TR0vQeJNBV3_tTswe1XeFDTsdw3NLZ

      United States
      Member #106923
      February 27, 2011
      478 Posts
      Offline
      Posted: November 30, 2015, 4:53 pm - IP Logged

      Can anyone here create a program that makes a vertical stack for a 111 rundown in the pick-3 game? I found one online but it's a horizontal version. I want to do an extensive back-test making it quicker to do.

      Thanks !

      So If I input 123 it will generate this:

      123 

      234

      345

      456

      567

      678

      789

      890

      901

      Using Excel, try this:

      Put the number 123 into cell A1.

      In cell A2 put the formula:   =MID($A$1,ROW(),2)&(RIGHT($A$1)+1)

      This will return the number 234.

      Then just copy this formula down as far as you want.

      If you put 234 into cell A1 then A2 will return 345.

      Note the locking of cells with the $ sign, so you will need to drop the lock if you want to carry them or just copy, paste, and change the cell number being referenced (A1).

        I'm feeling a jackpot win coming my way!

        amber123's avatar - OpIFNim

        United States
        Member #164727
        March 12, 2015
        2524 Posts
        Offline
        Posted: November 30, 2015, 4:58 pm - IP Logged

        Using Excel, try this:

        Put the number 123 into cell A1.

        In cell A2 put the formula:   =MID($A$1,ROW(),2)&(RIGHT($A$1)+1)

        This will return the number 234.

        Then just copy this formula down as far as you want.

        If you put 234 into cell A1 then A2 will return 345.

        Note the locking of cells with the $ sign, so you will need to drop the lock if you want to carry them or just copy, paste, and change the cell number being referenced (A1).

        I know absolutely nothing about excel except using apache after a program has been created

          realtorjim's avatar - images q=tbn:ANd9GcT7U3t20NgScoPlxOqLT6TR0vQeJNBV3_tTswe1XeFDTsdw3NLZ

          United States
          Member #106923
          February 27, 2011
          478 Posts
          Offline
          Posted: November 30, 2015, 5:02 pm - IP Logged

          I know absolutely nothing about excel except using apache after a program has been created

          Do you have excel amber?

            I'm feeling a jackpot win coming my way!

            amber123's avatar - OpIFNim

            United States
            Member #164727
            March 12, 2015
            2524 Posts
            Offline
            Posted: November 30, 2015, 5:08 pm - IP Logged

            Do you have excel amber?

            only open office

              realtorjim's avatar - images q=tbn:ANd9GcT7U3t20NgScoPlxOqLT6TR0vQeJNBV3_tTswe1XeFDTsdw3NLZ

              United States
              Member #106923
              February 27, 2011
              478 Posts
              Offline
              Posted: November 30, 2015, 5:34 pm - IP Logged

              only open office

              Though the two are somewhat compatible the OO filters are not 100%, especially with functions not widely used.  You might see if someone you know could build it utilizing the formula provided.

                I'm feeling a jackpot win coming my way!

                amber123's avatar - OpIFNim

                United States
                Member #164727
                March 12, 2015
                2524 Posts
                Offline
                Posted: November 30, 2015, 5:40 pm - IP Logged

                Though the two are somewhat compatible the OO filters are not 100%, especially with functions not widely used.  You might see if someone you know could build it utilizing the formula provided.

                Thanks for trying to help anyways.

                  realtorjim's avatar - images q=tbn:ANd9GcT7U3t20NgScoPlxOqLT6TR0vQeJNBV3_tTswe1XeFDTsdw3NLZ

                  United States
                  Member #106923
                  February 27, 2011
                  478 Posts
                  Offline
                  Posted: November 30, 2015, 5:50 pm - IP Logged

                  Using Excel, try this:

                  Put the number 123 into cell A1.

                  In cell A2 put the formula:   =MID($A$1,ROW(),2)&(RIGHT($A$1)+1)

                  This will return the number 234.

                  Then just copy this formula down as far as you want.

                  If you put 234 into cell A1 then A2 will return 345.

                  Note the locking of cells with the $ sign, so you will need to drop the lock if you want to carry them or just copy, paste, and change the cell number being referenced (A1).

                  Another formula for multiple stacking could be:  =RIGHT(A1,2)&(RIGHT(A1)+1)

                  However, an if statement will need to be included with either to stop a fourth digit in the final figure.  i.e. 567, 678, 789, 8910.

                    I'm feeling a jackpot win coming my way!

                    sunsine's avatar - praying hands.jpg
                    Florida
                    United States
                    Member #144291
                    June 30, 2013
                    713 Posts
                    Offline
                    Posted: December 28, 2015, 5:49 pm - IP Logged

                    Another formula for multiple stacking could be:  =RIGHT(A1,2)&(RIGHT(A1)+1)

                    However, an if statement will need to be included with either to stop a fourth digit in the final figure.  i.e. 567, 678, 789, 8910.

                    Nice post, thank you realtorjim

                      Avatar
                      Michigan
                      United States
                      Member #53679
                      July 16, 2007
                      71 Posts
                      Offline
                      Posted: December 28, 2015, 7:51 pm - IP Logged

                      Not sure if this is what you are looking for but, put this in row2, column A.  =MOD(LEFT(A1)+1;10)&MOD(MID(A1;2;1)+1;10)&MOD(RIGHT(A1;1)+1;10)

                       

                      Then drag down or copy the formula down to fill the rows you want to stop at.  So if you put 123 in Row1, Column A, you will get the +111 you are looking for. 

                      NOTE:  Open Office uses the semi-colon instead of the comma that Excel uses. 

                       

                      I hope this will help you.  Good Luck!!

                       

                      Sheela

                        FLATRANSPLANT's avatar - yocco
                        South Florida
                        United States
                        Member #71280
                        February 22, 2009
                        15318 Posts
                        Offline
                        Posted: December 29, 2015, 8:07 am - IP Logged

                        Can anyone here create a program that makes a vertical stack for a 111 rundown in the pick-3 game? I found one online but it's a horizontal version. I want to do an extensive back-test making it quicker to do.

                        Thanks !

                        So If I input 123 it will generate this:

                        123 

                        234

                        345

                        456

                        567

                        678

                        789

                        890

                        901

                        http://www.lottomonthly.com/info.php?R=MAGLPM&P=GuestView&S=ITM:WORKOUTS,TOP:Pick%203,SBJ:111%20Rundown