View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default Solver not working for me

I set up a sample problem similar to your description, and it seems to work
fine (I use Excel 2000).

B1: value
B2: =-1*((B1-5)^2)+10

This is a parabola, with the maximum at 5 and cupped downward, like you
mentioned.

Solver Parameters:
---------------------
Set Target Cell: $B$2
By Changing Cells: $B$1
Subject to the Constraints:
$B$1 <= 10
$B$1 = integer
$B$1 = 0

Options: (I left everything at the defaults)
--------------------------------------------
Max Time: 100 seconds
Iterations: 100
Precision: 0.000001
Tolerance: 5%
Convergence: 0.0001

All checkboxes OFF (Assume Linear Model, Assume Non-Negative, Use Automatic
Scaling, Show Iteration Results).

Estimates: Tangent
Derivatives: Forward
Search: Newton

I could start with cell $B$1 at 0 or 10, and it would converge to
4.9999999824217 in about 1 second.

--
Regards,
Bill Renaud