111 pick 3 rundown (stack version) generatorPrev TopicNext Topic

• amber123

  United States
  Member #164,719
  March 12, 2015
  3,506 Posts
  Offline
  Nov 30, 2015, 2:46 pm

  ▲▼

  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

  

  50

  Chief Bottle Washer

  New Jersey
  United States
  Member #1
  May 31, 2000
  27,938 Posts
  Offline
  Nov 30, 2015, 4:52 pm

  ▲▼

  <Moved to Pick 3 forum>

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

  

  United States
  Member #106,918
  February 27, 2011
  556 Posts
  Offline
  Nov 30, 2015, 4:53 pm

  ▲▼
  In response to amber123

  Quote: Originally posted by amber123 on Nov 30, 2015

  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 $312,000,000.00 jackpot win coming my way!
• amber123

  United States
  Member #164,719
  March 12, 2015
  3,506 Posts
  Offline
  Nov 30, 2015, 4:58 pm

  ▲▼
  In response to realtorjim

  Quote: Originally posted by realtorjim on Nov 30, 2015

  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

  

  United States
  Member #106,918
  February 27, 2011
  556 Posts
  Offline
  Nov 30, 2015, 5:02 pm

  ▲▼
  In response to amber123

  Quote: Originally posted by amber123 on Nov 30, 2015

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

  Do you have excel amber?

    I'm feeling a $312,000,000.00 jackpot win coming my way!
• amber123

  United States
  Member #164,719
  March 12, 2015
  3,506 Posts
  Offline
  Nov 30, 2015, 5:08 pm

  ▲▼
  In response to realtorjim

  Quote: Originally posted by realtorjim on Nov 30, 2015

  Do you have excel amber?

  only open office
• realtorjim

  

  United States
  Member #106,918
  February 27, 2011
  556 Posts
  Offline
  Nov 30, 2015, 5:34 pm

  ▲▼
  In response to amber123

  Quote: Originally posted by amber123 on Nov 30, 2015

  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 $312,000,000.00 jackpot win coming my way!
• amber123

  United States
  Member #164,719
  March 12, 2015
  3,506 Posts
  Offline
  Nov 30, 2015, 5:40 pm

  ▲▼
  In response to realtorjim

  Quote: Originally posted by realtorjim on Nov 30, 2015

  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

  

  United States
  Member #106,918
  February 27, 2011
  556 Posts
  Offline
  Nov 30, 2015, 5:50 pm

  ▲▼
  In response to realtorjim

  Quote: Originally posted by realtorjim on Nov 30, 2015

  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 $312,000,000.00 jackpot win coming my way!
• sunsine

  

  Florida
  United States
  Member #144,285
  June 30, 2013
  716 Posts
  Offline
  Dec 28, 2015, 5:49 pm

  ▲▼
  In response to realtorjim

  Quote: Originally posted by realtorjim on Nov 30, 2015

  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
• Sheela

  

  Michigan
  United States
  Member #53,677
  July 16, 2007
  74 Posts
  Offline
  Dec 28, 2015, 7:51 pm

  ▲▼

  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

  

  25

  South Florida
  United States
  Member #71,278
  February 22, 2009
  37,542 Posts
  Offline
  Dec 29, 2015, 8:07 am

  ▲▼
  In response to amber123

  Quote: Originally posted by amber123 on Nov 30, 2015

  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