Welcome Guest
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
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

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?

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

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?

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

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: July 24, 2005, 10:02 am - IP Logged

Excel

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

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

wsls

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

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

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

WTG all Winner\$.

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....

ALL IN!

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

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.

ALL IN!

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.

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

WTG all Winner\$.

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)

 Page 3 of 5