Welcome Guest
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

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

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.

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!

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

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!

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

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!

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.

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!

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

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.

Sheela

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

 Page 1 of 1