Automatically testing values...

[Cheshire]

Because my first post was essentially illegible, I will rephrase the question as I've also had a bit more insight to the matter.

I am trying to calculate and store all combinations possible of four markers in four 1x17 grids. (a total of 83521 combinations)
The easiest / logical way to do this is to increment.

If the four markers all begin in row 1, and the top most marker increments it self from 1-17 (using mod(stepnumber,17)+1), when it hits 17, to increment the next row.
Each row would act essentially the same way. Incrementing it's self after the row above it reaches 17, and being restricted by modulus to never exceed 17.

The tricky part is as the markers are moving accross their grid, functions are referring to the markers position, making calculations, and spitting out a percentile.

What I need to do is have the program walk through all 83521 posibilities as outlined in the above grid system, save the marker position (a1-17, b1-17, c1-17, d1-17, logical like) as well as the percentile output.

And if all that hasn't crashed my computer, I hope to make the data into a graph, so I can see which combinations offered the highest / lowest output.

I hope this is a lot more reasonable and understandable a request.
I'm thinking this may be beyond my original thinking on the matter and may be more appropriate to be moved to the macro forum if there is a moderator about that would be so kind.

Thank you for your time and attention,


-Aaron

[shg]

That's as close to inscrutable as I've read.

[Cheshire]

I have updated my first message,
I think the point I was trying to make is a lot clearer now,
As well as more of a structure as to how it could be achieved.

[shg]

Iterating through combinations is easy enough, but COMBIN(4*17, 4)=814,385, not 83,521. Or COMBIN(17,4)^4 = 32,085,427,360,000

Post a workbook with a couple of examples.

[Cheshire]

I'm not familiar with the combine you're referencing, but if it has something to do with allowing more than one marker on a line, then yes, there will be more permutations / posibilities.

At work now, will paste an exampe once I'm home.

Capturing all the results for me at least is the tricky part? Somewhere / how I can then reference these 5 critical cells?

[Cheshire]

Here is a small example sheet of what I work with.
The values from Y19:ao21 on the real sheet stretch down to ~ 500, so the data is a little more interesting. This example sheet shows the functionality.

On the example sheet AU2 is the cell to increment, cells X13,X14,X15,X16,AV14 are the ones I need to record their respective values at each iteration in a manner I can then reference as a graph.

I hope this makes it a bit clearer.

Thank you for the help!

-Aaron

[shg]

Try this:

Please Login or Register  to view this content.

The values in X13:16 are implicit in the row number on Sheet2. In B1 and copy to E1 and down,

=MOD(INT( (ROW()-1) / 17 ^ (COLUMNS($B1:B1) -1) ), 17) + 1

Once computed, you can replace those with their values.