What i need is a formula/s (VBA &/or macros on separate sheets) to display how many times a combination set of numbers has occurred from a data set.
Starting from 1 to 8,145,060 (6 from 45) combination's and then to check each line to the drawn numbers (data set) to find out hot/cold atm sets.
I know how to use the filters so im ok there (to sort out what i want) , and yes i know keno is an 80 number game, but I just ignore the last 35 numbers to give me better odds.
What i have so far :
I'm currently using Excel 2007
Each Sheet ( 1 to 9 ) has 1,000,000 combinations (please see pic below) ** ignore Column H for the moment its not what i need **
[IMG][login to view URL][/IMG]
And Sheet 10 has the Draw History ( data set ) please see pic below ** Currently it has 16,000 draws (2 months worth) i will MAX it out at 20,000.
[IMG][login to view URL][/IMG]
So This is what i require :
1. I need column H on each of the nine sheets to display how many times (Total) , 4 of the numbers in that lines combination have occurred from the data set in sheet 10.
2. I need column I on each of the nine sheets to display how many times (Total) , 5 of the numbers in that lines combination have occurred from the data set in sheet 10.
3. I need column J on each of the nine sheets to display how many times (Total) , 6 of the numbers in that lines combination have occurred from the data set in sheet 10.
4. I need column K on each of the nine sheets to display the draws where 6 of the numbers in that lines combination have occurred from the data set in sheet 10.
5. I need column L on each of the nine sheets to display the draws average distance where 6 of the numbers in that lines combination have occurred from the data set in sheet 10. ( calculated from column K )
6. I need column M on each of the nine sheets to display the last draw where 6 of the numbers in that lines combination have occurred from the data set in sheet 10.
7. I will need to be able to change the data set on sheet 10 whenever i want (max 20,000 draws)
8. Draw Number on sheet 10 will be sequential 1 to max 20,000
9. I will need to be able to use filters to sort data on columns H to M.
10 . I would like to keep the workbook layout as is, from provided book, extra sheets with additional VBA scripts etc is no problem , as im not worried about the MB size of the final workbook.
11. Needs to work in Excel 2007.
Please find my .xlsx uploaded here as a starting point (151mb .rar) :
[login to view URL]
Example of what the sheets should look like:
[IMG][login to view URL][/IMG]
Budget:
Project with exactly what i need $30
Project with exactly what i need + some nice professional visual basic presentation sheets of data that i can print $50
Additional services may be required later as a separate project in the future.
Time Frame: 1 to 2 Weeks or ASAP
Thank you for viewing.
I have already written all of these scripts for a keno scraper application I run for my own personal entertainment (it currently parses and evaluates the last 2 years worth of data for the lottery I track). I can retool them for your spreadsheet in just a few days.