Welcome Guest
Log In | Register )
You last visited January 23, 2017, 3:52 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 4 of 5
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
Posted: July 25, 2005, 10:08 pm - IP Logged

Sub HighSort()
'
' HighSort Macro
' Macro recorded 7/24/2005 by SirMetro
'

'
    Range("S3:T13").Select
    Range("T3").Activate
    Selection.Sort Key1:=Range("T3"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
    Range("U3:V13").Select
    Range("V3").Activate
   Selection.Sort Key1:=Range("V3"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal

    Range("W3:X13").Select
    Range("X3").Activate
    Selection.Sort Key1:=Range("X3"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
End Sub

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

    what about windows me? That might be a problem. sir metro I sent you my destiny copy. let me know how you make out? thanks

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

      Winsum....I presume you understand how to RECORD a Macro.

      If you could go thru the act of sorting the file and record a macro that sorts High and one that sorts Low and send it to me, I will be able to see whats going on. Appearantly, the variances are just enough between the different versions of Excel to cause a problem.


      Retxx...sending me a copy of what works on my machine and doesn't on yours does not help. All I can tell you is, the file works fine on my system. All I can presume is the variations between Excel is part of the problem. I know this isn't the answer you wanted, but its the best I can offer. I sincerely suggest that you truly consider a class in Excel at your local community college. I have seen your picks, you ability to select numbers is incredible.

      Sir Metro

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Offline
        Posted: July 26, 2005, 12:17 pm - IP Logged

        Sirmetro,

        What I think is happening is the following code is only applicable to the new versions of Excel (windows xp)

        DataOption1:=xlSortNormal

        If you remove this code and run in windows 2000 it seems to work fine.

        wsls
           

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

          Destiny's table HIT in GA Midday today

          Actual number was 169,

          Table showed pair 69 with a cold number of 2 and a hot number of 1.

          A hot play of 169 would have generated a hit today.

          This is why I say, watch both ways.

          Sir Metro

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

            Sirmetro,

            Thanks for the tip.

            Interesting.

            wsls

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

              sir metro how to remove that code and cannot find how to enable macros. need help thanks could be the reasonwhen you sent it to me it said formula too long.

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

                by the way the number in Mass. was 691. coincidence huh. If the chart worked I should of had it too.

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

                  Retxx...I am sorry...I can only assume that last version I sent to you does not function with your version of Excel. Beyond that, I simply can not do anymore. My apologies that you could not make this tool usefull for yourself.

                  Sir Metro

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

                    by the way the number in Mass. was 691. coincidence huh. If the chart worked I should of had it too.

                    Not intending to insult you Retxx...but Destiny's chart was DEAD ON

                    Previous results were: (this is how the table should look)

                    9

                    4

                    6

                    1

                    8

                    6

                    1

                    6

                    0

                    0

                    6

                    2

                    3

                    1

                    3

                    3

                    0

                    6

                    9

                    5

                    3

                    the above chart produces the following output

                    if sorted High to Low (press CNTRL H)

                    E

                    Q

                    6

                    5

                    3

                    4

                    1

                    3

                    0

                    3

                    9

                    2

                    4

                    1

                    8

                    1

                    5

                    1

                    2

                    1

                    7

                    0

                    E=Number (only one chart used because only 1 game played)

                    Q=Quantity each number occurred.

                    The resulting chart reveals the following:

                    600619628637646655
                               
                               
                    603612649658667 
                               
                    605614623669678 
                               
                               
                               
                               


                    and Retxx...yes, if sorted High to low, you would have had the correct number for tonites game. If sorted low to high, you would NOT have had tonites number.


                    Now, please understand this, I do NOT understand Mass's game. I see 4 digits. If you can apply this, good for you, but your own your own for that 4th digit. I can not and will not offer help for it.

                    Also, please note, all the examples posted here came directly from the spreadsheet, after updateing with the latest numbers (which came from the Results listing above here at Lottery Post).

                    Sir Metro

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

                      Clarification note:

                      The method I have incorporated into the spreadsheet for finding the 3rd digit to go with Destiny's Pairs is intended to be an example only. Please explore and consider other avenues of sourcing out the 3rd digit. The system will NOT work everytime and if you rely upon it, you only risk handicapping yourself.

                      Like so many posts by so many others, this program is NOT intended to be a silver bullet. Instead, it was developed to help reduce the list of possible pairs down to something more managable and was more relating to the design of the pairs chart. In short, another tool in your arsenal to chase down that elusive winning combination.

                      And please folks, don't ask me for the number for your state. The only state I follow is GA and I seldom win (6 hits over a year is NOTHING to brag about, believe me). I can make excel spin and do back flips. I can almost tell you ever major stat there is about GA Cash 3 & 4, but to save my own life, I still can not guess the next winning number. And yes, I dare say that my charts produce the winning number for 90% of every game, if only you can figure out how to find it amongst over 2500 numbers that it is hidden in.

                      I do hope that all that have receive this file is able to make great use of it. And I hope that they have better success then I have with it. Good luck to all

                      Sir Metro

                        retxx's avatar - mrthumbs
                        BOSTON
                        United States
                        Member #48
                        September 9, 2001
                        3614 Posts
                        Offline
                        Posted: July 27, 2005, 11:02 am - IP Logged

                        sir metro. thanks. Is it possible for you to just use part of destiny's chart that you posted and eliminate the midday part because we payoff on the first 3 in Mass.so that is all I would need. I guess it would mean to rewrite excel if you can. frustrated person.

                          retxx's avatar - mrthumbs
                          BOSTON
                          United States
                          Member #48
                          September 9, 2001
                          3614 Posts
                          Offline
                          Posted: July 27, 2005, 11:06 am - IP Logged

                          P.S. you know something is not right when it does not show the AZ ZA on the top bar.

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5396 Posts
                            Offline
                            Posted: July 27, 2005, 11:21 am - IP Logged

                            Retxx,

                            What Excel version are you using?

                            wsls

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5396 Posts
                              Offline
                              Posted: July 27, 2005, 11:47 am - IP Logged

                              Retxx,

                              I'm emailing you 2 Excel Files.

                              1.  Mass Pick 4 - using the Front 3 Digits

                              2.  Mass Pick 4 - using the Back 3 Digits

                              I entered the past 7 draws for the Mass Pick4 already.  You just need to verify if they are correct and update the drawings after each draw.

                              I'm not sure if you use the Front 3 or Back 3 to play so I'm sending you both.

                              I changed the code so all you need to do is Press Control L (Ctrl + H) or Control H (Ctrl + L) to sort your drawings.  You do not need the A Z sort anymore.

                              Just make sure you press Ctrl + L and Ctrl + H after you update your drawings.

                              wsls