111 pick 3 rundown (stack version) generator

Reply #11

FLATRANSPLANT — Tue, 29 Dec 2015 13:07:07 GMT

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

Reply #10

Sheela — Tue, 29 Dec 2015 00:51:56 GMT

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

Reply #9

sunsine — Mon, 28 Dec 2015 22:49:54 GMT

Nice post, thank you realtorjim

Reply #8

realtorjim — Mon, 30 Nov 2015 22:50:06 GMT

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.

Reply #7

amber123 — Mon, 30 Nov 2015 22:40:39 GMT

Thanks for trying to help anyways.

Reply #6

realtorjim — Mon, 30 Nov 2015 22:34:06 GMT

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.

Reply #5

amber123 — Mon, 30 Nov 2015 22:08:15 GMT

only open office

Reply #4

realtorjim — Mon, 30 Nov 2015 22:02:33 GMT

Do you have excel amber

Reply #3

amber123 — Mon, 30 Nov 2015 21:58:15 GMT

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

Reply #2

realtorjim — Mon, 30 Nov 2015 21:53:52 GMT

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).

Reply #1

Todd — Mon, 30 Nov 2015 21:52:57 GMT

111 pick 3 rundown (stack version) generator

amber123 — Mon, 30 Nov 2015 19:46:51 GMT

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