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

Simple Rundown Excel Files

Topic closed. 11 replies. Last post 7 months ago by PlanB.

Page 1 of 1
52
PrintE-mailLink
SWMcCaig's avatar - 9b740053d1be538a3bed55bad1c5746d
Broken Arrow, OK
United States
Member #155206
May 11, 2014
1875 Posts
Offline
Posted: April 27, 2016, 2:37 pm - IP Logged

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.

"What lies behind us and what lies before us are tiny matters compared to what lies within us"

Ralph Waldo Emerson

    amber123's avatar - OpIFNim

    United States
    Member #164727
    March 12, 2015
    2536 Posts
    Offline
    Posted: April 27, 2016, 2:47 pm - IP Logged

    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

      SWMcCaig's avatar - 9b740053d1be538a3bed55bad1c5746d
      Broken Arrow, OK
      United States
      Member #155206
      May 11, 2014
      1875 Posts
      Offline
      Posted: April 27, 2016, 2:54 pm - IP Logged

      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

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

      "What lies behind us and what lies before us are tiny matters compared to what lies within us"

      Ralph Waldo Emerson

        Tialuvslotto's avatar - Jailin
        Texas
        United States
        Member #150797
        December 31, 2013
        815 Posts
        Offline
        Posted: April 28, 2016, 6:45 am - IP Logged

        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!

        "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

        ~Robert A. Heinlein

          SWMcCaig's avatar - 9b740053d1be538a3bed55bad1c5746d
          Broken Arrow, OK
          United States
          Member #155206
          May 11, 2014
          1875 Posts
          Offline
          Posted: April 28, 2016, 8:13 am - IP Logged

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

          "What lies behind us and what lies before us are tiny matters compared to what lies within us"

          Ralph Waldo Emerson

            Harve$t Moon's avatar - 5str

            United States
            Member #76986
            July 10, 2009
            8038 Posts
            Offline
            Posted: April 28, 2016, 11:27 am - IP Logged

            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!

            This is very helpful, Tialuvslotto!Sun Smiley  Thank you!

                     

              ranman17's avatar - jzy6nr
              New York
              United States
              Member #83026
              November 27, 2009
              2132 Posts
              Offline
              Posted: April 28, 2016, 3:03 pm - IP Logged

              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.

              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

              Be kind, because everyone you meet is fighting a great battle.

              An Unruly Evil

                SWMcCaig's avatar - 9b740053d1be538a3bed55bad1c5746d
                Broken Arrow, OK
                United States
                Member #155206
                May 11, 2014
                1875 Posts
                Offline
                Posted: April 28, 2016, 7:43 pm - IP Logged

                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

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

                "What lies behind us and what lies before us are tiny matters compared to what lies within us"

                Ralph Waldo Emerson

                  ranman17's avatar - jzy6nr
                  New York
                  United States
                  Member #83026
                  November 27, 2009
                  2132 Posts
                  Offline
                  Posted: April 28, 2016, 10:16 pm - IP Logged

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

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

                   

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

                  Be kind, because everyone you meet is fighting a great battle.

                  An Unruly Evil

                    SWMcCaig's avatar - 9b740053d1be538a3bed55bad1c5746d
                    Broken Arrow, OK
                    United States
                    Member #155206
                    May 11, 2014
                    1875 Posts
                    Offline
                    Posted: April 28, 2016, 10:39 pm - IP Logged

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

                     

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

                    Thank you, works great!

                    "What lies behind us and what lies before us are tiny matters compared to what lies within us"

                    Ralph Waldo Emerson

                      Tialuvslotto's avatar - Jailin
                      Texas
                      United States
                      Member #150797
                      December 31, 2013
                      815 Posts
                      Offline
                      Posted: April 29, 2016, 6:11 am - IP Logged

                      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!

                      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!

                      "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

                      ~Robert A. Heinlein

                        PlanB's avatar - Lottery-002.jpg
                        Somewhere in TX
                        United States
                        Member #105994
                        February 10, 2011
                        125 Posts
                        Offline
                        Posted: April 29, 2016, 10:44 am - IP Logged

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