Re: pb with the solver

[Jody Goldberg <jgoldberg home com>]

On Mon, Oct 02, 2000 at 10:57:27PM +0000, Serge Sauton wrote:
> I'm trying to use the solver with gnumeric but without success:-(
>
> Here is the value of cells :
>  B2=B3=B4=1
>  C2=4 C3=1 C4=3
>  D2=3 D3=2 D4=5
>  E2=6 E3=3 E4=8
>
>  F2=F3=F4=5 for example (initial value for these changing cells)
>
>  B5=B2*F2+B3*F3+B4*F4
>  C5=C2*F2+C3*F3+C4*F4
>  D5=D2*F2+D3*F3+D4*F4
>  E5=E2*F2+E3*F3+E4*F4
>
>  B6=100
>  C6=238
>  D6=302
>
> Contraints :
>  B5=B6
>  C5<=C6
>  D5<=D6
>  F2:F4 Int
>
> Target Cell to max : F5
>
> The solver solution :
>  F2=F3=F4=1 !! The min !!?
>
> Is there anyone who has tested it ?

I just ran the example you gave with version 0.57 and got reasonable
looking results.

F2 : 24
F3 : 30
F4 : 46