Thankyou GilesD Prof'l ? help is helpful
GillesD said:
mirage
Your quote: "I had a meeting with a professional macro designer very skilled in Excel who also teaches at the local University Business School if she could design a macro which would produce a list of combos that would equal a particular specific sum of skips".
I doubt she meets your decription. A very simple macro can do whatever you want. Just cycle through all possible combinations with 6 FOR ... NEXT loops. For each combination, from 1-2-3-4-5-6 to 44-45-46-47-48-49, you verify if it meets the condition you want and if so, an output is made to the sheet indicating the combination. And you keep going until the end. It might not be the most elegant code but it sure does the job.
To me, you do not need to be professional macro designer or be very skilled in Excel to think of that but some common sense might be something quite useful. But you know university teachers ...
As Beaker said, I already posted a macro that can be adapted to find combinations that meets any number of conditions and write them to an Excel sheet.
What do you define exactly as "a particular specific sum of skips" and can you give me a pratical example.
-------------------------------------------------------
Thank you people for not kicking me off the board for being an idiot. Thank you GilesD in particular - I knew you would rise to the request and be open to more discussion. Thank you Beaker for being patient... I've been busy trying to get a new computer and lan system, etc up and running plus running a life, and too busy to bring myself up to speed with Excel and macros (from scratch)... I became impatient and resorted to seeking help from professional progammers, et al. (They are supposedly in business to make money as well as being Professor types). You wouldn't believe the run around....
Also, I was being redundant when I said '"particular specific" sum of skips.' Sorry about that. It made my comment very vague.
I think you understood before in a previous thread where I was trying to go.
As I understand it, skips means "how many draws ago a number last hit"?
Lets take the 6 numbers that won this past Sat. in 6/49:
8, 21,24,26,34,34 (I am not using the bonus number).
8 last hit 25 draws ago, 21 last hit 12 draws ago, 24 last hit 3 draws ago, 26 last hit 11 draws ago, 34 last hit 5 draws ago, and 38 last hit 5 draws ago. This, summed up, equals "69" - the sum of the skips for last 6/49 draw.
My manual reseach shows that this is pretty high number for sum of skips, relative to other draws, for the last 13 months anyway.
I've added up and manually plotted a graph for all of the sums of skips for each draw for the last 13 months of 6/49.
I found a few interesting things. It turns out to be an irregular or raggedy bell curve. Here is one fact: for 4 draws of the 6/49 lotto in the last 13 months, the number 47 was the sum of skips. (This is approximately in the middle of the raggedy bell curve.) I think this approach could be useful predictively. I would wager that in the next 12 months, or someday, 47 as the number of the sum of skips will hit again. (This approach makes me a "trapper"). Therefore, before each lottery draw, run the program or macro to find all combos that equal 47 as the sum of the skips. (I don't know how practical this would be or if it is just a curiousity). Then apply filters to the combos to select combos to actually play. Can your macro previously posted be adapted to do this? I am wanting to have an associative number with each number from 1 to 49 and then have the macro sum the associative numbers, and then give me a list of the combos of 6 of 1 to 49 that equal a (pre-specified) sum of the associative numbers.
Thanks!
