Hello,

I use EXCEL 2003.

I'm trying to apportion some costs to optimise returns. I have managed to
work out how to do it for 2 or 3 variables and use a grid form which I can
see how returns are effected depending on what % of resource are allocated.
For 2 variables
e.g. Column A 100, 0, 99, 1, 98, 2 etc.
Column B 0, 100, 1, 99, 2, 98 etc.
and
For 3 variables
Column A 100, 0, 0, 99, 99, 0, 1, 0, 1, 98, 98, 98, 0, 2 etc.
Column B 0, 100, 0, 1, 0, 99, 99, 1, 0, 2, 0, 1, 98, 98,
etc.
Column C 0, 0, 100, 0, 1, 1, 0, 99, 99, 0, 2, 1, 2, 0 etc.

The three variable sheet took ages to input....

Is there a resource (or a quick way) to generate the grids for 4 or more
variables? Do these grids have a name I can search for? Any help gratefully
received. If not then I'll just tell my boss it's not on. I'm also not sure
whether the 4 grid would fit in the spreadsheet! Ideally I would like to work
with 6 variables.