Destiny's Chart in Excel

Reply #72

SirMetro — Sun, 31 Jul 2005 15:22:18 GMT

Congrats to you Retxx...I hope you do well considering all the headache you went thru for it.Sir Metro

Reply #71

retxx — Sun, 31 Jul 2005 14:38:14 GMT

just wanted to let everyone know I finally got destiny's chart to work. hooray. now I will see how well it does in Mass.

Reply #70

SirMetro — Fri, 29 Jul 2005 16:16:57 GMT

For those who haven't read the complete thread...The chart is aptly named Destiny's Chart because it is a creation she (I assume) created. All I have done was to simply take the chart and semiautomated it.In it's simpliest terms, one could simply keep up with the last number drawn only, then come up with their own 3rd digit anyway they feel is the best way.All that this spreadsheet does is HIDES the numbers that are believed NOT going to hit and reveal only the numbers that may possibly hit. I... [ More ]

Reply #69

retxx — Fri, 29 Jul 2005 01:51:33 GMT

search and replace is what i get as a popup so how would I use it replace the control l or h when it does not work. Also can I download a free macros from the internet? thanks

Reply #68

txpolo — Fri, 29 Jul 2005 01:39:56 GMT

Thanks Sir Metro for Destiny's Chart.

Reply #67

retxx — Thu, 28 Jul 2005 20:25:52 GMT

how do I find if Macros is enabled? Thanks

Reply #66

winsumloosesum — Thu, 28 Jul 2005 20:24:44 GMT

Sirmetro deserves all the credit txpolo.Send him the thank you!!wsls

Reply #65

txpolo — Thu, 28 Jul 2005 14:53:22 GMT

Thanks WSLS, I received your revised Excel Destiny chartand it works great.

Reply #64

winsumloosesum — Thu, 28 Jul 2005 14:19:52 GMT

Nanook,This is Sirmetro's creation.Works fine when I use it to sort High Low or Low Highwsls

Reply #63

Nanook — Thu, 28 Jul 2005 13:39:57 GMT

wsls, The Ctrl+H key combination is a windows system keyboard shortcut for 'search and replace'Using it for a macro may confuse windows.

Reply #62

winsumloosesum — Thu, 28 Jul 2005 02:56:28 GMT

Retxx,You only need to enter the the drawings in cell range C4 through E10. Most current goes in cell C4, D4, E4 (Position 1, Position 2, Position 3)Once you have all the current drawings entered all you do is locate the control key on your keyboad Ctrl . Press and hold down the Ctrl Key and at the same time press the L key if you want the Cell Range N4 through O14 sorted Low to High.If you want to sort High to Low hold down the Ctrl (Control Key) and press the H Key. This will sort Ce... [ More ]

Reply #61

retxx — Thu, 28 Jul 2005 02:21:15 GMT

hi got the eve chart,put in the last 7 daws here,went to no hit list manually entered tonights draw as 5-7-8-4-2-9-0-3-1-6as low to high. I even entered the q list manually as 0-0-1-1-1-2-3-3-4-6 low to high. why didn't the destinys evening match change to show new numbers to play? where it said eve draws did not update to 7-5-8. need help.

Reply #60

winsumloosesum — Wed, 27 Jul 2005 15:59:14 GMT

If anyone would like a copy of just the Excel Evening Only version send me a PM with an email addy and I will forward.The only thing you need to do is replace the 7 drawings to reflect your states past 7 draws. Most recent drawing at the top.wsls

Reply #59

winsumloosesum — Wed, 27 Jul 2005 15:47:30 GMT

Retxx,I'm emailing you 2 Excel Files.1. Mass Pick 4 - using the Front 3 Digits2. Mass Pick 4 - using the Back 3 DigitsI 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 m... [ More ]

Reply #58

winsumloosesum — Wed, 27 Jul 2005 15:21:27 GMT

Retxx,What Excel version are you using?wsls

Reply #57

retxx — Wed, 27 Jul 2005 15:06:43 GMT

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

Reply #56

retxx — Wed, 27 Jul 2005 15:02:10 GMT

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.

Reply #55

SirMetro — Wed, 27 Jul 2005 03:30:31 GMT

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 someth... [ More ]

Reply #54

SirMetro — Wed, 27 Jul 2005 03:12:53 GMT

Not intending to insult you Retxx...but Destiny's chart was DEAD ONPrevious results were: (this is how the table should look)946186160062313306953the above chart produces the following outputif sorted High to Low (press CNTRL H)EQ65341303924181512170E=Number (only one chart used because only 1 game played)Q=Quantity each number occurred.The resulting chart reveals the following:600619628637646655 603612649658667 605614623669678

Reply #53

SirMetro — Wed, 27 Jul 2005 02:50:10 GMT

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

Reply #52

retxx — Wed, 27 Jul 2005 02:19:34 GMT

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

Reply #51

retxx — Wed, 27 Jul 2005 02:16:12 GMT

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.

Reply #50

winsumloosesum — Tue, 26 Jul 2005 18:27:44 GMT

Sirmetro,Thanks for the tip.Interesting.wsls

Reply #49

SirMetro — Tue, 26 Jul 2005 18:23:28 GMT

Destiny's table HIT in GA Midday todayActual 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

Reply #48

winsumloosesum — Tue, 26 Jul 2005 16:17:58 GMT

Sirmetro,What I think is happening is the following code is only applicable to the new versions of Excel (windows xp)DataOption1:=xlSortNormalIf you remove this code and run in windows 2000 it seems to work fine.wsls

Reply #47

SirMetro — Tue, 26 Jul 2005 13:48:32 GMT

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 varia... [ More ]

Reply #46

retxx — Tue, 26 Jul 2005 02:24:05 GMT

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

Reply #45

winsumloosesum — Tue, 26 Jul 2005 02:08:24 GMT

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:=x... [ More ]

Reply #44

winsumloosesum — Tue, 26 Jul 2005 02:04:10 GMT

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,wslsFor the time being. You can still use the old method of sorting using the A Z sort. (see previous posts

Reply #43

txpolo — Mon, 25 Jul 2005 19:32:00 GMT

Sir Metro, I have Excel rev. 8.0 e. I guess it'scompatible with Excel XP.Thanks

Reply #42

SirMetro — Mon, 25 Jul 2005 17:04:40 GMT

Which version excel?These spreadsheets were setup using Excel XP.It should work, I do not really know why it doesn't.

Reply #41

undress — Mon, 25 Jul 2005 16:48:46 GMT

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.

Reply #40

SirMetro — Mon, 25 Jul 2005 16:46:46 GMT

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

Reply #39

undress — Mon, 25 Jul 2005 16:45:27 GMT

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

Reply #38

txpolo — Mon, 25 Jul 2005 16:42:33 GMT

Sir metro, thanks for your latest rev.I updated the day and evening numbers andthe sort does not automate. The cntrl +H and+L does not work. Any suggestions?Thanks again

Reply #37

SirMetro — Mon, 25 Jul 2005 14:01:32 GMT

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.... [ More ]

Reply #36

winsumloosesum — Sun, 24 Jul 2005 21:14:57 GMT

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

Reply #35

winsumloosesum — Sun, 24 Jul 2005 14:02:25 GMT

ExcelClick View (Main Menu ) Click Toolbars You should now see a drop-down list of available ToolbarsClick Standard (if no check mark is next to it)wsls

Reply #34

retxx — Sun, 24 Jul 2005 02:51:18 GMT

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

Reply #33

retxx — Sun, 24 Jul 2005 02:08:26 GMT

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

Reply #32

winsumloosesum — Sat, 23 Jul 2005 13:00:03 GMT

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>Vie... [ More ]

Reply #31

retxx — Fri, 22 Jul 2005 20:32:54 GMT

thanks winsum but what about the red numbers not converting

Reply #30

winsumloosesum — Fri, 22 Jul 2005 19:15:58 GMT

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

Reply #29

retxx — Fri, 22 Jul 2005 16:14:34 GMT

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

Reply #28

retxx — Fri, 22 Jul 2005 16:02:36 GMT

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

Reply #27

SirMetro — Fri, 22 Jul 2005 12:56:38 GMT

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 selectFirst, select the cells that require sorting, then click Data>Sortthen 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

Reply #26

Joliesj — Thu, 21 Jul 2005 21:26:07 GMT

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

Reply #25

msmusic — Thu, 21 Jul 2005 20:09:56 GMT

I don't see any icon on my screen.

Reply #24

SirMetro — Tue, 28 Jun 2005 21:38:18 GMT

Great ideas

Reply #23

winsumloosesum — Tue, 28 Jun 2005 18:51:26 GMT

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

Reply #22

winsumloosesum — Tue, 28 Jun 2005 18:42:16 GMT

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... [ More ]

Reply #21

Sandy K — Tue, 28 Jun 2005 18:02:20 GMT

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

Reply #20

SirMetro — Tue, 28 Jun 2005 17:16:39 GMT

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

Reply #19

SirMetro — Tue, 28 Jun 2005 17:14:16 GMT

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

Reply #18

Sandy K — Tue, 28 Jun 2005 16:46:52 GMT

thank you, dear....One more question to be answered: 1011291381471561102111139148157166 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..

Reply #17

SirMetro — Tue, 28 Jun 2005 11:16:45 GMT

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

Reply #16

Bluegrass — Tue, 28 Jun 2005 04:30:55 GMT

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

Reply #15

Sandy K — Mon, 27 Jun 2005 23:53:45 GMT

now this is just a making sure question....on the sort.....EQ30147383932242625101That 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

Reply #14

SirMetro — Mon, 27 Jun 2005 17:02:11 GMT

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 stat... [ More ]

Reply #13

SirMetro — Mon, 27 Jun 2005 16:54:15 GMT

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

Reply #12

SirMetro — Mon, 27 Jun 2005 16:51:54 GMT

First Question, yes, that sounds correct.Second Question, Click View>Normal ViewSorry, I always set-up things like that, just one of my habits is all.Sir Metro

Reply #11

Sandy K — Mon, 27 Jun 2005 16:43:25 GMT

okay, one more question....I did the sort like you said.......A on top to Zmy 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

Reply #10

SirMetro — Mon, 27 Jun 2005 14:55:22 GMT

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

Reply #9

Sandy K — Mon, 27 Jun 2005 14:27:04 GMT

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

Reply #8

SirMetro — Mon, 27 Jun 2005 12:39:48 GMT

......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... [ More ]

Reply #7

Sandy K — Mon, 27 Jun 2005 12:04:49 GMT

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

Reply #6

maine23 — Mon, 27 Jun 2005 02:20:12 GMT

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

Reply #5

SirMetro — Mon, 27 Jun 2005 02:14:26 GMT

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

Reply #4

txpolo — Sun, 26 Jun 2005 23:16:54 GMT

SirMetro, you made my Sunday. Thanks

Reply #3

Sandy K — Sun, 26 Jun 2005 23:10:43 GMT

yuppers....sirmetro is the best

Reply #2

emilyg — Sun, 26 Jun 2005 22:57:51 GMT

sir metro - you're a nice guy.

Reply #1

tgirl137 — Sun, 26 Jun 2005 22:54:29 GMT

Thank you SirMetro.

Destiny's Chart in Excel

SirMetro — Sun, 26 Jun 2005 22:10:28 GMT

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