Number grids

[BOB43]

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.

 

[Lars-Ã…ke Aspelin]

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.

With three variables you get 5151 rows of data.
With four variables you get 176851 rows of data which is too much to fit
into a single worksheet in Excel 2003. You would need Excel 2007 for this.
Maybe you should try a smaller increase than 1% for your grids.
With an increase of 10% you only get 286 rows for the four variable case,
1001 rows for the five variable case, and 3003 rows for the six variable
case.

Hope this helps / Lars-Ã…ke


--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---