If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Number grids
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. |
#2
|
|||
|
|||
Number grids
"BOB43" wrote in message ... 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: --- |
Thread Tools | |
Display Modes | |
|
|