Re: Using Solver with Linear Constraint(s)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

How about give the J's a relationship
J4 =a
J5=J4+b
J6 =J5+b

Now vary a and b to get solution
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"stef" <notvalid@xxxxxxxxxx> wrote in message
news:O2avlUNzIHA.5108@xxxxxxxxxxxxxxxxxxxxxxx
Excel 2002 SP3
Win XP Pro SP2

*Follow-up to: microsoft.public.excel*

Hi,

Sorry but I have "writer's block" right now as regards to a spreadsheet
solution I need.

It's a simple problem but I am just drawing a blank at the moment....

Let me try to describe it:

I have a cell chosen as the target for solver e.g. M25 = 1% (total market
share)

And a range as the cells to change by solver e.g. J4:J23 (market share as
% at each period e.g. month or quarter, etc.)

Each cell needs to progressively grow until reaching 1%. And the rate of
growth of the cells in J4:23 needs to stay constant or linear.

The 1st value affected by J4 is a $ amount like $100,000. The ending
value is very high in comparison: 100,000 % that the original $ value.

I cannot project the 1% divided by the number of period as the 1st period
growth would be much too high.

I need the values in the range J4:J23 to change to solve the equation
but in a linear fashion, each cell value being progressively higher than
the last.

I have played around with the Linear, Automatic Scaling, etc.; options
but have not been able to get the result I want.

Actually, I do not really see a linear solution in this case but again, I
am in a "blank" right now....

Any help or suggestion?





.

Relevant Pages

  • Re: Using Solver with Linear Constraint(s)
    ... Each cell needs to progressively grow until reaching 1%. ... growth of the cells in J4:23 needs to stay constant or linear. ... each cell value being progressively higher than ...
    (microsoft.public.excel)
  • Re: strength of chess computer programs vs. time
    ... computer chess "technology curve" ... whatever) mean a straight increase in play strength. ... obvious it was a curve and not linear. ... There was a 'deminishing returns' to the growth of the machine power / ...
    (rec.games.chess.computer)
  • Re: Using Solver with Linear Constraint(s)
    ... Each cell needs to progressively grow until reaching 1%. ... of growth of the cells in J4:23 needs to stay constant or linear. ... to the constraint block. ... includes the 1% target has a lower bound for optimality. ...
    (microsoft.public.excel)
  • RE: Trendlines to ignore empty cells
    ... If the data covers only five points, the linear trend will return ... > chart is to be placed “Test”. ... > Assume the letter “a” starts in cell A2. ...
    (microsoft.public.excel.charting)
  • Re: Areal density really so high?
    ... between linear and track density I was hoping to find out more ... I don't know anything about the manufacture of hard disks, ... a hypothetical cell which is only a little over one magnetic grain ... Possible reasons could include space ...
    (comp.arch)