Lotto / Fantasy 5 And Excel

Reply #3

sixinfourtynine — Tue, 24 May 2005 17:52:10 GMT

mangoten, could you send excel file to my e-mail also? I want to have a look. regards,

Reply #2

mangoten — Mon, 23 May 2005 22:30:05 GMT

Maryland,I can attach my worksheet macro to an email send it to you privately since I do not know how to upload a worksheet on this page.In picking 7 numbers, out of 36, for a Fantasy 5 draw, you generally can use a number of ways to figure out your numbers. Generally, the two ways I know of are to get the percentages of each time a number comes up as a win; second, keep track of a 7 day cycle of numbers play the numbers which have not come up in the previous 7 days. Even though some numbe... [ More ]

Reply #1

Maryland — Mon, 23 May 2005 06:57:18 GMT

mangoten, you have an example of your spreadsheet? And how do you get down to picking only 7 numbers, that's what really has my interest. Best I can do is 20 numbers.

Lotto / Fantasy 5 And Excel

mangoten — Mon, 23 May 2005 06:42:07 GMT

Howdy! Just joined this board wanted to share a recent story about a small recent win. You know, I just won $60 the other night using =COMBIN(7,5) to use 21 combinations of 7 numbers, with 5 numbers in each combination; the total pool of numbers to pick from is 1 through 36. I matched 3 out of 5 numbers, winning 6 out of 21 combinations. Each combination won 10 dollars I spent 1 dollar on each combination (21 dollars total.) If I had matched 4 numbers out of 5, I would have won 3 sets of 4 n... [ More ]