LottoMatic
New Member
 Joined
 Jan 4, 2020
 Messages
 5
 Platform

 Web
I am looking for the advice of experienced Excel users regarding the "translation" of a webbased application into an Excel spreadsheet and really hope to get some useful input regarding this matter.
Since year 2014 I've been working on a rather complex lottery prediction system. It is a webbased system (PHP/MySQL) and lately I was wondering if similar results could be achieved with Excel. That would make the application portable and internet independent.
What my system does, in a nutshell...
It wheels trough all possible combinations of a certain lottery system (e.g. 6/49) and it eliminates any combination that doesn't meet certain criteria. To establish the criteria, a relatively large number of filters (hundreds) are being applied to each and every combination individually. This means quite a lot of computing power, considering the fact that there are  for example  almost 14 million possible combinations in a a 6/49 system. For a 7/50 lottery system (such as the Canadian Lotto Max for instance) there are almost 100 million possible combinations.
A detailed description of the system can be found by googling "lottomatic number generator". I did read the MrExcel board rules and I believe I am not braking any of them.
So, my question is:
Would it be possible to achieve something similar to that (or better?) using Excel?
I just thought it would be wise to ask the experts before actually rolling my sleeves up and starting to work on this.
Your feedback would be greatly appreciated.
Since year 2014 I've been working on a rather complex lottery prediction system. It is a webbased system (PHP/MySQL) and lately I was wondering if similar results could be achieved with Excel. That would make the application portable and internet independent.
What my system does, in a nutshell...
It wheels trough all possible combinations of a certain lottery system (e.g. 6/49) and it eliminates any combination that doesn't meet certain criteria. To establish the criteria, a relatively large number of filters (hundreds) are being applied to each and every combination individually. This means quite a lot of computing power, considering the fact that there are  for example  almost 14 million possible combinations in a a 6/49 system. For a 7/50 lottery system (such as the Canadian Lotto Max for instance) there are almost 100 million possible combinations.
A detailed description of the system can be found by googling "lottomatic number generator". I did read the MrExcel board rules and I believe I am not braking any of them.
So, my question is:
Would it be possible to achieve something similar to that (or better?) using Excel?
I just thought it would be wise to ask the experts before actually rolling my sleeves up and starting to work on this.
Your feedback would be greatly appreciated.