Re: solver errors

["Andreas J. Guelzow" <aguelzow taliesin ca>]

Your example appears to be a nice and simple version of 
http://bugzilla.gnome.org/show_bug.cgi?id=64017

I have appended it to that bug report. This might help solving this problem.

Thanks

Andreas


jacksonje wrote:

> I am having problems with solver.
>
> I am using gnumeric 1.0.3
> The OS I am using os linux, specifically the sorcerer distribution.
>
> The problem is described below, but I will also attach the spreadsheet to simplify testing.
>
> Solver Settings----
> Set Target Cell: D6
> Equal To: Max
> By Changing Cells: B3:C3
> Assume Linear Model: selected but grayed out
> Assume Non-negative: selected
> Subject to the Constraints: D8:D10 <= E8:E10
>
> Spreadsheet-------------------
> D6: =sumproduct(B3:C3, B4:C4)
> B3: 0    C3:  0    
> B4:  7   C4:  4
> B8:  20  C8:  4    D8:  =sumproduct($B$3:$C$3, B8:C8)    E8:  8000
> B9:  8   C9:  5    D9:  =sumproduct($B$3:$C$3, B9:C9)    E9:  10000
> B10: 4   C10: 4    D10: =sumproduct($B$3:$C$3, B10:C10)  E10: 4000
>
> After running solver---------------
> B3:  4.38e+08  C3: 1e+282
> D6:  4e+282
> D8:  4e+282
> D9:  5e+282
> D10: 4e+282
>
> D8:D10 is definitely much greater than the 8000,10000, and 4000 defined =



--
Prof. Dr. Andreas J. Guelzow
http://www.math.concordia.ab.ca/aguelzow