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

Destiny's Chart in Excel

Topic closed. 72 replies. Last post 11 years ago by SirMetro.

Page 5 of 5
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: July 27, 2005, 11:59 am - IP Logged

If anyone would like a copy of just the Excel Evening Only version send me a PM with an email addy and I will forward.

The only thing you need to do is replace the 7 drawings to reflect your states past 7 draws.  Most recent drawing at the top.

wsls

    retxx's avatar - mrthumbs
    BOSTON
    United States
    Member #48
    September 9, 2001
    3594 Posts
    Offline
    Posted: July 27, 2005, 10:21 pm - IP Logged

    hi got the eve chart,put in the last 7 daws here,went to no hit list manually entered tonights draw as 5-7-8-4-2-9-0-3-1-6as low to high. I even entered the q list manually as 0-0-1-1-1-2-3-3-4-6 low to high. why didn't the destinys evening match change to show new numbers to play? where it said eve draws did not update to 7-5-8. need help.

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: July 27, 2005, 10:56 pm - IP Logged

      Retxx,

      You only need to enter the the drawings in cell range C4 through E10.  Most current goes in cell C4, D4, E4 (Position 1, Position 2, Position 3)

      Once you have all the current drawings entered all you do is locate the control key on your keyboad "Ctrl".  Press and hold down the "Ctrl" Key and at the same time press the "L" key if you want the Cell Range N4 through O14 sorted Low to High.

      If you want to sort High to Low hold down the Ctrl (Control Key) and press the "H" Key.  This will sort Cell Range N4 through O14, sorted High to Low.

      You don'ta toucha the cell range N4 through O14.  That's the reason for the Macro.  All you have to do is use the control Ctrl Key and either the H or L  (H = High to Low)  (L=Low to High).

      When you press Ctrl > L, look at cell range G20 through L29.  These are your combinations based on Low to High.

      When you press Ctrl > H, look at cell range G20 through L29, Thes are your combinations based on High to Low.


      1. Look at cell range N4 through N14.  This column represents digits.

      2. Look at cell range O4 through O14.  This column represents the number of times the corresponding digit in cell N has hit in the last 7 drawings.

      Hope this helps!!

      wsls 

       

       

       

       

        Avatar
        New Member
        Chicago
        United States
        Member #17364
        June 17, 2005
        24 Posts
        Offline
        Posted: July 28, 2005, 9:39 am - IP Logged

        wsls,

         

        The Ctrl+H key combination is a windows system keyboard shortcut for 'search and replace'

        Using it for a macro may confuse windows.

        Seek first to understand

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: July 28, 2005, 10:19 am - IP Logged

          Nanook,

          This is Sirmetro's creation.

          Works fine when I use it to sort High Low or Low High

          wsls

            txpolo's avatar - animaniacs16

            United States
            Member #173
            April 8, 2002
            6110 Posts
            Offline
            Posted: July 28, 2005, 10:53 am - IP Logged

            Thanks WSLS, I received your revised Excel Destiny chart

            and it works great.

             BananaWTG all Winner$. Hyper

             

             

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: July 28, 2005, 4:24 pm - IP Logged

              Sirmetro deserves all the credit txpolo.

              Send him the thank you!!

              wsls

                retxx's avatar - mrthumbs
                BOSTON
                United States
                Member #48
                September 9, 2001
                3594 Posts
                Offline
                Posted: July 28, 2005, 4:25 pm - IP Logged

                how do I find if Macros is enabled? Thanks

                  txpolo's avatar - animaniacs16

                  United States
                  Member #173
                  April 8, 2002
                  6110 Posts
                  Offline
                  Posted: July 28, 2005, 9:39 pm - IP Logged

                  Thanks Sir Metro for Destiny's Chart.

                   BananaWTG all Winner$. Hyper

                   

                   

                    retxx's avatar - mrthumbs
                    BOSTON
                    United States
                    Member #48
                    September 9, 2001
                    3594 Posts
                    Offline
                    Posted: July 28, 2005, 9:51 pm - IP Logged

                    search and replace is what i get as a popup so how would I use it replace the control l or h when it does not work. Also can I download a free macros from the internet? thanks

                      SirMetro's avatar - center
                      East of Atlanta
                      United States
                      Member #6191
                      August 11, 2004
                      1389 Posts
                      Offline
                      Posted: July 29, 2005, 12:16 pm - IP Logged

                      For those who haven't read the complete thread...The chart is aptly named "Destiny's Chart" because it is a creation she (I assume) created. All I have done was to simply take the chart and semiautomated it.

                      In it's simpliest terms, one could simply keep up with the last number drawn only, then come up with their own 3rd digit anyway they feel is the best way.

                      All that this spreadsheet does is HIDES the numbers that are believed NOT going to hit and reveal only the numbers that may possibly hit. I done this after seeing so many requests for how to read the chart. To make the chart easy to read, I simply HIDE the numbers you don't need to see.

                      As for the 3rd digit, honestly, it's a wild @$$ guess at a possible system that could actually be beneficial thanks to commentary offered by other readers online.

                      Again, I did NOT create the methods used. Nor did I create any sort of a new system. I merely applied the concepts found here at LotteryPost within an Excel spreadsheet that would simplify the reading process.

                      Good Luck to all those who are able to take advantage of it. My apologies for those who can not.

                      Sir Metro

                        retxx's avatar - mrthumbs
                        BOSTON
                        United States
                        Member #48
                        September 9, 2001
                        3594 Posts
                        Offline
                        Posted: July 31, 2005, 10:38 am - IP Logged

                        just wanted to let everyone know I finally got destiny's chart to work. hooray. now I will see how well it does in Mass.

                          SirMetro's avatar - center
                          East of Atlanta
                          United States
                          Member #6191
                          August 11, 2004
                          1389 Posts
                          Offline
                          Posted: July 31, 2005, 11:22 am - IP Logged

                          Congrats to you Retxx...I hope you do well considering all the headache you went thru for it.

                          Sir Metro