Welcome Guest
Log In | Register )
You last visited December 7, 2016, 5:07 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 1 of 5
PrintE-mailLink
SirMetro's avatar - center
East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
Posted: June 26, 2005, 6:10 pm - IP Logged

First, credit goes to Destiny for providing her Chart.

For those who would like a copy of her Chart that I have semi-automated in Excel, send an EMail to sirmetro@yahoo.com

Be sure to update the numbers with that of your state and resort the list of no hit numbers. The spreadsheet will then display only the numbers that correlate with her chart similiar to how I was explaining the use in the Cash 3 forum.

Good Luck to anyone who uses it.

Sir Metro

    tgirl137's avatar - animal butterfly.jpg
    Grand Rapids
    United States
    Member #123
    February 23, 2002
    3884 Posts
    Offline
    Posted: June 26, 2005, 6:54 pm - IP Logged

    Thank you SirMetro.

      emilyg's avatar - cat anm.gif

      United States
      Member #14
      November 9, 2001
      31351 Posts
      Offline
      Posted: June 26, 2005, 6:57 pm - IP Logged

      sir metro - you're a nice guy.  Lovies

      love to nibble those micey feet.

       

                                   

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

        yuppers....sirmetro is the best!!! 

        Sandy

          txpolo's avatar - animaniacs16

          United States
          Member #173
          April 8, 2002
          6110 Posts
          Offline
          Posted: June 26, 2005, 7:16 pm - IP Logged

          SirMetro, you made my Sunday. Thanks

           BananaWTG all Winner$. Hyper

           

           

            SirMetro's avatar - center
            East of Atlanta
            United States
            Member #6191
            August 11, 2004
            1389 Posts
            Offline
            Posted: June 26, 2005, 10:14 pm - 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)

              maine23's avatar - cigar
              dallas texas
              United States
              Member #13860
              April 16, 2005
              204 Posts
              Offline
              Posted: June 26, 2005, 10:20 pm - IP Logged

              thanks Sir Metro for the spreadsheet...You made my sunday too...Many hits for us...you doing something right Ga bounced around your number youll get em next time..

                Sandy K's avatar - graphic pub.jpg
                Clarkston, Michigan
                United States
                Member #76
                January 6, 2002
                8528 Posts
                Offline
                Posted: June 27, 2005, 8:04 am - IP Logged

                remember something, Sir Metro......."the giver receiveth"....I believe that statement...............you will get your return......sometimes it is just a matter of "seeing numbers".........

                Keep plugging, dear one............it is coming for you........I feel it....the big win!!!

                Thank you for the spreadsheet.......one question......what do you mean by "manually sort".........?  I think I know..just making sure.....

                Sandy

                  SirMetro's avatar - center
                  East of Atlanta
                  United States
                  Member #6191
                  August 11, 2004
                  1389 Posts
                  Offline
                  Posted: June 27, 2005, 8:39 am - 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

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

                    One suggestion Sir Metro...it is an awesome spreadsheet.....

                    but maybe I don't want the cold number in consideration for the combo......my suggestion is to highlight in red the destiny pair......and leave the cold number black.  Therefore, the pairs stand out.......they are obvious......easy to change for me...I have done it....just go to the back pairs of the combos and do a font color change.......

                    Just a suggestion.....................

                    Sandy

                      SirMetro's avatar - center
                      East of Atlanta
                      United States
                      Member #6191
                      August 11, 2004
                      1389 Posts
                      Offline
                      Posted: June 27, 2005, 10:55 am - IP Logged
                      First, it would be good to post all questions to LotteryPost Forum. This way, other people with similiar questions can see the response and perhaps some of the other folks can help with the answer (my answers are not always the right ones or the easiest to understand).
                      Second, I believe the only stupid question is the one not asked (hair color not important, considering we all have an occasional blonde day).

                      Now, to answer the main question, you can get the LAST 10 games from LotteryPost for your state.
                      Click (or run your mouse over) on (in the menu bar) RESULTS>UnitedStates>Louisiana
                      The results for all the games of that state will appear.
                      Then Click on the Game of interest and select PAST DRAWING RESULTS
                      This will give you the last 10 draws for that game.
                      Now, Just update the numbers in the spreadsheet.
                      The sheet is intended to have the most current number at the top and the oldest at the bottom of the list. If your state has a single game, ignore the second list. Delete it and the combination if you like so it doesn't confuse you. Or, you could use it to track different days, as a reminder of how it played the day earlier after it was updated. Your choice.

                      Oh, and Sandy, main reason is that I simply didn't think of it.
                      Another issue is, I did not want to create the impression I am offering numbers in any form other then BOX. I would be concerned that color coding would suggest a straight, misleading some into playing only straight and losing because its in the wrong order. If I have learned anything, it's that one does not presume anyone else can read my mind. I want everybody to feel free to make adjustments. Heck, check it for errors, fix it, pass it along. Most of all, I hope it helps all to find more winners or least find another way to reduce their list of numbers to play.
                      Good Luck.
                      Sir Metro
                        Sandy K's avatar - graphic pub.jpg
                        Clarkston, Michigan
                        United States
                        Member #76
                        January 6, 2002
                        8528 Posts
                        Offline
                        Posted: June 27, 2005, 12:43 pm - IP Logged

                        okay, one more question....I did the sort like you said.......A on top to Z

                        my sort showed the cold number on top.......then came the most hit numbers right under that.........right or wrong???

                        And how do I remove the Page 1 across the cells.....can't read the numbers below it at all....or very hard to read..?

                        I love this spreadsheet...thank you

                        Sandy

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

                          First Question, yes, that sounds correct.

                          Second Question, Click View>Normal View

                          Sorry, I always set-up things like that, just one of my habits is all.

                          Sir Metro

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

                            @(*)&$@!#_&$@....l don't take my own advice very well. Destiny's sheet gave me today's midday number and I overlooked it Bang Head

                             

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

                              the only thing i don't get is the no hit list.....Could you explain real quick....Just not sure what to do there. And the abbreviations.

                               


                              The No Hit List (for lack of something simplier to name it) is intended to track how often each number hit for the past 7 games. The general concept then is to use the "missing" number as the one that is comeing up in the next game. You may prefer to use the most frequent number instead. Feel free to adjust and back track it to see how it performs for your state.

                               

                               


                              Some days, I don't get the abbreviations I use (had to peek to remind myself what they were).

                               

                              E = Evening Game

                              M = Midday Game

                              A = All or Combined Games

                              Q = Quantity

                              The primary reason for this is that it makes manual sorting easier and faster when you have a title at the top of each column.

                               


                              Hope this helps.

                               

                              Sir Metro