# pb with the solver...continuation

• From: Serge Sauton <serge sauton libertysurf fr>
• To: gnumeric-list gnome org
• Subject: pb with the solver...continuation
• Date: Sun, 15 Oct 2000 21:46:18 +0000

```                -------------------------------------

I'm trying to use the solver with gnumeric 0.56 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 !!?

--------------------------

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

F2 : 24
F3 : 30
F4 : 46

-------------

A:
4,0000   1,0000   3,0000   1,0000   0,0000
3,0000   2,0000   5,0000   0,0000   1,0000
1,0000   1,0000   1,0000   0,0000   0,0000

b:
238,0000 302,0000 100,0000

c:
1,0000   1,0000   1,0000   0,0000   0,0000

Bad luck :-( . The same result !
F2 : 1
F3 : 1
F4 : 1

and i always ask for the max !

whatever the initial values, the solver gives the min :-(

Excuse me for my insistence...

Thanks.

--
serge sauton

```