Hello to All, Especially to the: "Masters of Excel Slash VBA Programmer Guru’s"
I’ve started this thread to get feedback from you folks who know your stuff!
My intent is mainly to receive guidance in my endeavor to create my own set of tools, for the lotto I play. i.e. 6/49, 7/49 style lotto.
Now, I’m not asking for the folks who know their stuff to build it for me… that would be just wrong, not to mention, no fun at all
for me, and anyone else that wish’s to expand their skill set with Excel.
As for my skill with Excel? Well, let’s just say I know enough to get into trouble!
Back in the late 90’s I piddled around with BASIC and then VB.
Wrote a few macro’s within early versions of Excel. My current version of Excel is 2007.
I've a number of questions.
First off.
The Data Base (D.B.)of past winning numbers, that I wish to create (but not set in stone yet) will be a row from 1 to 49 with winning numbers marked as the winning integers,
followed by the, combinations CSN(Lex), win combo Sum, Odd, Even, then Number of Winning Prime Numbers.
My ultimate goal here is to create a Macro/Module, that I can make and it will search for past winning combinations of patterns. (Nothing New Here everyone is trying to do it!)
What it gets down to though, is how the workbook is setup.
I wish to link worksheets, use a naming convention for different parts of the D.B. I also feel that this way is best for add future analytical module’s.
What do you all think? What ways would you folks set up a similar D.B.? Is it feasible?
I see it, in my mind’s eye, maybe I need to elaborate more on my concept of theory?
As everyone knows, this topic alone could open up a HUGE can of UGLY!
Serf ice it to say before anyone else does!
All numbers have an equal chance, Mathematics Rules the Universe, Time is infinite & We are not!, and Opinions are like ___holes everyone has one.
;-)
I'm trying to avoid future errors, that is why I’m asking the people who have seen the mistakes already.
Looking forward! THX All
Alex.
I’ve started this thread to get feedback from you folks who know your stuff!
My intent is mainly to receive guidance in my endeavor to create my own set of tools, for the lotto I play. i.e. 6/49, 7/49 style lotto.
Now, I’m not asking for the folks who know their stuff to build it for me… that would be just wrong, not to mention, no fun at all
for me, and anyone else that wish’s to expand their skill set with Excel.
As for my skill with Excel? Well, let’s just say I know enough to get into trouble!
Back in the late 90’s I piddled around with BASIC and then VB.
Wrote a few macro’s within early versions of Excel. My current version of Excel is 2007.
I've a number of questions.
First off.
The Data Base (D.B.)of past winning numbers, that I wish to create (but not set in stone yet) will be a row from 1 to 49 with winning numbers marked as the winning integers,
followed by the, combinations CSN(Lex), win combo Sum, Odd, Even, then Number of Winning Prime Numbers.
My ultimate goal here is to create a Macro/Module, that I can make and it will search for past winning combinations of patterns. (Nothing New Here everyone is trying to do it!)
What it gets down to though, is how the workbook is setup.
I wish to link worksheets, use a naming convention for different parts of the D.B. I also feel that this way is best for add future analytical module’s.
What do you all think? What ways would you folks set up a similar D.B.? Is it feasible?
I see it, in my mind’s eye, maybe I need to elaborate more on my concept of theory?
As everyone knows, this topic alone could open up a HUGE can of UGLY!
Serf ice it to say before anyone else does!
All numbers have an equal chance, Mathematics Rules the Universe, Time is infinite & We are not!, and Opinions are like ___holes everyone has one.
;-)
I'm trying to avoid future errors, that is why I’m asking the people who have seen the mistakes already.
Looking forward! THX All
Alex.