Welcome Guest
Log In | Register )
You last visited December 3, 2016, 4:44 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 3 of 5
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: July 22, 2005, 3:15 pm - IP Logged

Sort A Z is on the Excel Standard Toolbar.  You should see a button that has an A Z with an arrow pointing down next to it.  There is a Z A next to it with an arrow pointing down.

If you don't see it you need to go to:

View>Toolbars>Standard (Click the "Standard") After you click it it should have an arrow next to it.

You should now see the A Z Sorting buttons.

wsls

     

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

    thanks winsum but what about the red numbers not converting?

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

      Retxx,

      To "Sort" the No Hit List in Cell ranges S4 through X13 you need to Sort each drawing separately. For example: Look at cell S2 you see Eve. Look at cell S3 you see "E" for evening. Look at cell range S4 through S13, this is a list of digits 0 through 9. Look at cell T3 you see "Q" and look at cell range T4 through T13, these numbers represent how many times the digits hit in the last 7 drawings (see cell range C4 through E10). Now you need to Sort.

      Step 1: Go to your Main Menu and Click>View>Toolbars>Standard (Make sure Standard Tool Bar is checked)

      Step 2: Click cell T3

      Step 3: Hold down your Shift Key, while holding down your Shift Key left-click Cell S13.

      Step 4: Release the Shift Key. You should now notice cell range S3 through T13 are now "Highlighted"

      Step 5: Look at your Standard Toolbar and look for th A Z with the arrow pointing down next to it button (Sort Ascending). (Should be next to the little paintbrush)

      Step 6: Click the A Z Button. This will sort Cell range S4 through T13 in ascending order. Meaning all the digits will be sorted by least number of times hit to the most number of times hit in the past 7 drawings. (see cell range C4 through E10).

      Step 7: Now look at cell range L21 through Q30. These are your combinations to play for the next drawing.

      Step 8: For states that have Midday Drawings Repeat Step 2 but click Cell V3. Step 3: Hold down your Shift Key and Click cell V13. Click the A Z Button. Look at cell range W21 through AB30 for your Midday combinations to play.

      The RED numbers are the Pairs from the last drawing(s). You don't touch these numbers in cells T14, V14, X14 (evening Draws) and T16, V16, X16 (midday draws). If you accidentally sorted these you need to use your original downloaded Excel File and start over.

      If your state only has Evening Picks disregard the Midday Chart. You only need to enter previous drawings in cell ranges B4 through E10.
      The combinations to play are listed in Cell Ranges L21 through Q30.

      If your state has both Midday and Evening your combinations will be in Cell Ranges L21 through Q30 (evening) and W21 through AB30 (midday).

      What you want to look for is at Cell T4, T5. Sometimes you may have multiple digits that have hit either 0 or 1. Also for the Midday Cell V4, V5. You might have the same hits for 1 to 2 digits. The question is what number do I play. For example: My Pennsylvania Pick 3 evening chart shows both digit 5 and digit 6 hitting only 1 time in the last 7 drawings. Do I play the 5 or the 6. The digit 5 gives me these combinations to play for my evening drawing for Saturday 7/23/05. 503, 512, 549, 558, 567, 504, 513, 522, 559, 568, 577, 509, 518, 527, 536, 545. Or do I play the digit 6 which gives me these combinations: 603, 612, 649, 658, 667, 604, 613, 622, 659, 668, 677, 609, 618, 627, 636, 645. So the question is do I play the 5, 6 or both. 16 combinations or 32 combinations.

      The same thing holds true with Pennsylvania Midday drawing. Both digit 8 and digit 3 have not hit at all (0) in the last 7 drawings.

      As I said in another thread, you don't want to chase digits for more than 2 drawings. Look for digits that have not hit (0 hits) in the last 7 drawings and only play those for 2 more draws.

      Retxx, I don't know how you want to play using Mass Pick 4. Maybe use the front 3 as the Midday and Back 3 as the Evening??

      I hope this explanation helps!!

      wsls

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

        there is the problem. when I go to view and click toolbar there is no such word :"standard". Now what?

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

          hi I deleted destiny's excel so can you e-mail it to me again please. It appeared to show errors. my e-mail is salesmn419@aol.com

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

            Excel

            Click "View" (Main Menu ) 

            Click "Toolbars"  You should now see a drop-down list of available Toolbars

            Click "Standard" (if no check mark is next to it)

            wsls 

             

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

              Or do I play the digit 6 which gives me these combinations: 603, 612, 649, 658, 667, 604, 613, 622, 659, 668, 677, 609, 618, 627, 636, 645. So the question is do I play the 5, 6 or both. 16 combinations or 32 combinations.

              Bummer!!

              667 Hit Saturday Night.

              wsls 

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

                Notes regarding revised version.

                1) The revised version still functions like the old. The only change is I have automated the sorting process simply to eliminate questions. Press the CONTROL key + the H key to sort high to low or the L key to sort low to high. Which ever method you feel will work best for you.

                2) If you don't understand basic Excel, please spend a few $$ on a decent book or consider a 1 day class at your local college. They do offer excel in the continuing adult education program.

                3) The order the numbers is input is not relevant. The system simply COUNTS whats there. It does NOT care what order anything is in. That is why I eliminated the date from the list because it simply does not matter.

                4) If you have a better way of selecting the 3rd digit, please, by all means, incorporate it. The method I have included, I do not offer as the best or the worst method to use.

                5) This little program is not intended to replace personal judgement. It is intended to be an additional tool to add to one's arsenal in selecting possible winning numbers.

                Good Luck to all and may you all have profitable wins.

                Sir Metro

                  txpolo's avatar - animaniacs16

                  United States
                  Member #173
                  April 8, 2002
                  6110 Posts
                  Offline
                  Posted: July 25, 2005, 12:42 pm - IP Logged

                  Sir metro, thanks for your latest rev.

                  I updated the day and evening numbers and

                  the sort does not automate. The cntrl +H and

                  +L does not work. Any suggestions?

                  Thanks again

                   BananaWTG all Winner$. Hyper

                   

                   

                    undress's avatar - Lottery-061.jpg
                    roseville, MI
                    United States
                    Member #5980
                    July 30, 2004
                    18205 Posts
                    Offline
                    Posted: July 25, 2005, 12:45 pm - IP Logged

                    Same Problem Metro....Getting an error Message....

                    Mad ALL IN!Mad

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

                      Check your Macro security. Most of the time, Excel is predesigned with high security, not allowing macros to run. Until you reset it, it will not work.

                      Sir Metro

                        undress's avatar - Lottery-061.jpg
                        roseville, MI
                        United States
                        Member #5980
                        July 30, 2004
                        18205 Posts
                        Offline
                        Posted: July 25, 2005, 12:48 pm - IP Logged

                        I had to enable the marco's....It's once I hit the ctl functions those me into an error. Then it want's to debug the program.

                        Mad ALL IN!Mad

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

                          Which version excel?

                          These spreadsheets were setup using Excel XP.

                          It should work, I do not really know why it doesn't.

                            txpolo's avatar - animaniacs16

                            United States
                            Member #173
                            April 8, 2002
                            6110 Posts
                            Offline
                            Posted: July 25, 2005, 3:32 pm - IP Logged

                            Sir Metro, I have Excel rev. 8.0 e. I guess it's

                            compatible with Excel XP.

                            Thanks

                             BananaWTG all Winner$. Hyper

                             

                             

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

                              Sirmetro,

                              Thank you for the Excel Spreadsheet.

                              Works great with Windows XP Excel Professional.

                              I tried it on another computer with Windows 2000 but the program stops and requests to debug the program.

                              Do you want me to send you the location program of the Macro where it stops?

                              Thanks,

                              wsls

                              For the time being.  You can still use the old method of sorting using the A Z sort.  (see previous posts)