Welcome Guest
Log In | Register )
You last visited December 3, 2016, 10:44 am
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 2 of 5
PrintE-mailLink
Sandy K's avatar - graphic pub.jpg
Clarkston, Michigan
United States
Member #76
January 6, 2002
8528 Posts
Offline
Posted: June 27, 2005, 7:53 pm - IP Logged

now this is just a making sure question....

on the sort.....

EQ
30
14
73
83
93
22
42
62
51
01


That is for Michigan tonight...........that is the holding the shift key thru the whole process.......a to z.....................

Now your example for Georgia was the opposite...it ran from coldest to hottest.....I think I know what I did wrong...just so anyone else has trouble with it.....if you want to run coldest to hottest...you need to let go of the shift key after highlighting.........

Sir Metro.....it supposed to run the coldest on the top to the hottest on the bottom right? 

Just making sure is all..............

Sandy

    Bluegrass's avatar - nw archer.jpg
    Killer's Cove
    United States
    Member #57
    December 17, 2001
    5625 Posts
    Offline
    Posted: June 28, 2005, 12:30 am - IP Logged

    This is sad...I can create usefull tools for everybody else to obtain winners and I don't get diddly. I should surrender before I get any further behind, just that I enjoy toying with numbers to well.

    Sir Metro

    (GA hit 145, I played 045 & 345, oh well)

    I do understand that feeling ! Thank you for your help !  Bob  Guitarbg

      SirMetro's avatar - center
      East of Atlanta
      United States
      Member #6191
      August 11, 2004
      1389 Posts
      Offline
      Posted: June 28, 2005, 7:16 am - IP Logged

      Sandy, when you make the selection, start with the Letter Q (top Right) and then, while holding the shift key, select the lower left cell. This should highlight the cells to sort. Release the shift key and then click the A/Z sort icon (one with the A on top). What you posted shows the most hit near the top and it appears you started with the 0 & 3 first. Problem with the quick sort is that it needs a header at the top to function correctly (kinda like a name holder spot).


      .....it supposed to run the coldest on the top to the hottest on the bottom right?

      Yes, but don't discount the other way either. Test both methods. Sometimes, one method may actually work better then the other.

      Sir Metro

        Sandy K's avatar - graphic pub.jpg
        Clarkston, Michigan
        United States
        Member #76
        January 6, 2002
        8528 Posts
        Offline
        Posted: June 28, 2005, 12:46 pm - IP Logged

        thank you, dear....

        One more question to be answered:

                   
        1011291381471561
        102111139148157166
                   
                   
        1051141231691781
                   
                   
                   
                   


        This for Michigan Midday..........question is:  why is there just a "1" the 2 cells on the right side.....this happens frequently......what does the "1" mean..??

        Sandy

          SirMetro's avatar - center
          East of Atlanta
          United States
          Member #6191
          August 11, 2004
          1389 Posts
          Offline
          Posted: June 28, 2005, 1:14 pm - IP Logged

          ah...looks like I might have let one slip by.

          If you recall, Destiny's chart has a few blank cells. My intended remedy for this was to simply to delete the formula I had in those corresponding cells. Apparently I didn't get them all. Just ignore it or delete the formula from it, your choice.

          Sir Metro

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

            FYI...GA Midday had the correct pair set, but instead of the cold number hitting, the hot number hit instead. This is why I say, do not discount the Hot number.

            Sir Metro

              Sandy K's avatar - graphic pub.jpg
              Clarkston, Michigan
              United States
              Member #76
              January 6, 2002
              8528 Posts
              Offline
              Posted: June 28, 2005, 2:02 pm - IP Logged

              Thank you, SirMetro........

              Sandy

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Online
                Posted: June 28, 2005, 2:42 pm - IP Logged

                Thought I would add a suggestion to this system.

                I am looking at PA draws and my suggestion is this:

                Destiny's System is based on the coldest digit from all 3 combined positions for the past 7 draws.  Others suggest using the "Hottest" digit.

                The "KEY" first of all is to get the first digit correctly.

                My suggestion is to wait for a digit that has not hit 0 (zero) times in the last 7 draws.

                Then play that digit the next drawing and stop when it hits or up to a maximum of 3 more drawings. 

                Stop playing after 3 drawings.  This digit might be a real stinker and continue on loosing.

                Concentrate only 0 (zero) nothing else.  If you don't have any digits that are at 0 (zero) don't play.

                If you have more than 1 digit that is at 0 (zero), play both if you can afford it and use the same principle.  Stop when the digit hits or when you reach 3 more drawings.

                wsls

                 

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5387 Posts
                  Online
                  Posted: June 28, 2005, 2:51 pm - IP Logged

                  Another idea is to alternate where to put your "Key" digit.

                  Destiny's System has the "Key" digit in the 1st position.

                  Possible suggestion is using his system and alternate Positions.

                  For example:

                  The "Key" digit occured in Position #3 and before that it occured in Position #1.  Possible next play would be Position #2.  The thing is to track where the "Key" digit is falling or looking for some type of pattern based on the past history.

                  wsls

                   

                    SirMetro's avatar - center
                    East of Atlanta
                    United States
                    Member #6191
                    August 11, 2004
                    1389 Posts
                    Offline
                    Posted: June 28, 2005, 5:38 pm - IP Logged

                    Great ideas :-)

                      msmusic's avatar - music note-t10469-2jvmir1.jpg
                      Hating is for the weak, loving is for the strong.
                      LA/TX
                      United States
                      Member #5957
                      July 29, 2004
                      9102 Posts
                      Offline
                      Posted: July 21, 2005, 4:09 pm - IP Logged

                      ......what do you mean by "manually sort".........? 

                      The NO HIT LIST has to be resorted each time you input new numbers into the schedule. Keep in mind you can only resort one group at a time (ex: Eve, Mid, ALL).

                      To QuickSort the list, select the Q at the top of each group and while holding the SHIFT KEY DOWN, click the BOTTOM LEFT Cell of the group. Then, on your screen, across the top, there will be an ICON with the Letters A&Z on top of each other, select the one with the A on top of the Z (the Z on the A will put the most hit at the top), this will quickly resort each section.

                      Good Luck to all

                      Sir Metro

                      I don't see any icon on my screen.

                        Joliesj's avatar - green fey.png
                        Houston
                        United States
                        Member #16932
                        June 7, 2005
                        49 Posts
                        Offline
                        Posted: July 21, 2005, 5:26 pm - IP Logged

                        I don't understand how to sort the NO HIT list.

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

                          In excel, you have the option to place tool bars on the screen for easy access to commonly used tools. The standard toolbar has the sort options built in, for those who do not know where the standard tool bar is, you can also select

                          First, select the cells that require sorting, then click Data>Sort

                          then fill in the required info in the window that pops up.

                          The cool thing is, excel will remember what your settings are (also reason all the headers are the same).

                          Sir Metro

                            retxx's avatar - mrthumbs
                            BOSTON
                            United States
                            Member #48
                            September 9, 2001
                            3583 Posts
                            Offline
                            Posted: July 22, 2005, 12:02 pm - IP Logged

                            thanks for the chart. I entered the last 7 draws and manually sorted least to high but it did not change the red numbers at all. why? I did not change the dates. would this be the problem? thanks

                              retxx's avatar - mrthumbs
                              BOSTON
                              United States
                              Member #48
                              September 9, 2001
                              3583 Posts
                              Offline
                              Posted: July 22, 2005, 12:14 pm - IP Logged

                              another question; when I clicked on cell Q and held the shift key down but no A/Z icon came up anywhere. Something wrong?