A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Number grids



 
 
Thread Tools Display Modes
  #1  
Old December 26th, 2009, 11:42 AM posted to microsoft.public.excel.misc
BOB43
external usenet poster
 
Posts: 1
Default 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  
Old December 26th, 2009, 04:21 PM posted to microsoft.public.excel.misc
Lars-Ã…ke Aspelin
external usenet poster
 
Posts: 7
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.