Simple Rundown Excel Files

Reply #11

PlanB — Fri, 29 Apr 2016 14:44:48 GMT

Always learning something new all the time on LP. Thanks Tialluvslotto Ranman.

Reply #10

Tialuvslotto — Fri, 29 Apr 2016 10:11:14 GMT

Small edit:

Put your starting number in A1,B1,C1.

Put your rundown number in A2,B2,C2 (eg. 111 or anything else)

In cell A3 enter the formula =MOD((A1+A2),10) Drag and copy the formula to cells B3 and C3

In cell A4 enter the formula =MOD((A3+$A$2),10) Drag and copy to B4, C4

Go into cells B4 C4 and edit the formula to =MOD((B3+$B$2),10) and =MOD((C3+$C$2),10)

Then copy A4-C4 down 8 rows to the bottom of the rundown. You can pretty it up how you like with color, etc. Done

Reply #9

SWMcCaig — Fri, 29 Apr 2016 02:39:12 GMT

Thank you, works great

Reply #8

ranman17 — Fri, 29 Apr 2016 02:16:51 GMT

The second rundown was locked...I fixed it.

Here you go: https://www.dropbox.com/s/mqnz11xr2cesv1e/123workout.xlsx?dl=0

Reply #7

SWMcCaig — Thu, 28 Apr 2016 23:43:13 GMT

Perfect RanMan! Couldn't ask for better. Thank you

Reply #6

ranman17 — Thu, 28 Apr 2016 19:03:28 GMT

Try this: https://www.dropbox.com/s/mqnz11xr2cesv1e/123workout.xlsx?dl=0

I gave you two (2) rundown columns. You can enter any three digit number(s) you like.

Best,

ranman

Reply #5

Harve$t Moon — Thu, 28 Apr 2016 15:27:03 GMT

This is very helpful, Tialuvslotto! Thank you

Reply #4

SWMcCaig — Thu, 28 Apr 2016 12:13:03 GMT

OMG Tia, thank you so much! This is exactly what I needed. Thank you

Reply #3

Tialuvslotto — Thu, 28 Apr 2016 10:45:44 GMT

It is super simple to build your own spreadsheet to do this.

Put your starting number in A1,B1,C1.

Put your rundown number in A2,B2,C2 (eg. 111 or anything else)

In cell A3 enter the formula =MOD((A1+A2),10) Drag and copy the formula to cells B3 and C3

In cell A4 enter the formula =MOD((A3+$A$2),10) Drag and copy to B4, C4

Then copy A4-C4 down 8 rows to the bottom of the rundown. You can pretty it up how you like with color, etc. Done

Reply #2

SWMcCaig — Wed, 27 Apr 2016 18:54:26 GMT

That's close, but not quite. It would be better if the rundown went straight down in a straight line, it's kind of important to be that way for me to test a couple of methods I'm working with. Even better would be each individual digit in it's own cell so it can be copy/pasted from one spreadsheet to another, and so that individual digits could be highlighted......Hope I didn't confuse everyone with all that. I'm working on very little sleep....

Reply #1

amber123 — Wed, 27 Apr 2016 18:47:32 GMT

Go to this link and then find page 8. It's the 5th file from the bottom of that page. It's called spooky 317 .

You can change the rundown with this.

https://www.lotterypost.com/thread/277930

Simple Rundown Excel Files

SWMcCaig — Wed, 27 Apr 2016 18:37:20 GMT

Sorry to ask, I would do this myself, but I am Excel ignorant. I am looking for a simple Excel file that will do a simple +317 rundown on a given number. What would be even better would be a file that will allow you to give the working number, and then specify what you want to use on your rundown. i.e: 317, 123, 111, etc. Any help anyone could offer would be appreciated.