LottoMatic

New Member
Joined
Jan 4, 2020
Messages
5
Platform
  1. Web
I am looking for the advice of experienced Excel users regarding the "translation" of a web-based 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 web-based 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.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,298
Office Version
  1. 365
Platform
  1. Windows
Hi LottoMatic,
something in that direction sounds doable with Excel, but:
  • you'd probably want a lot of VBA for that, as millions of normal excel calculations would probably crash/freeze excel. Maybe combine Excel with an Access database for faster queries and base data (also portable) would do the trick.
  • my feeling: it feels a bit like the question: "can I build a house with only logs and a swiss army knife". Yes, you could and probably can create a great Youtube video out of it, but it's faster/easier with some powertools ;).
Cheers,
Koen
 

LottoMatic

New Member
Joined
Jan 4, 2020
Messages
5
Platform
  1. Web
Hi Koen and thank you for your input.

That is my main concern actually, the fact that excel, by itself, may not be able to compute the millions of calculations needed, especially for a lottery with a relatively large number of possible combinations.
As for the Access DB, I understand how that would make things a lot easier. However, my goal (advice request...) would be to achieve all this with Excel alone.

Building a house "with only logs and a swiss army knife" is something I did already. And although it turned out well, I am not sure I'll be taking on such task again though :) I tend to put that experience in the once-in-a-lifetime category.

Let's see if someone else will come up with some idea.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,988
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top