pb with the solver
- From: Serge Sauton <serge sauton libertysurf fr>
- To: gnumeric-list gnome org
- Subject: pb with the solver
- Date: Mon, 2 Oct 2000 22:57:27 +0000
Hi,
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 ?
Thanks a lot.
--
Serge Sauton
[Date Prev][
Date Next] [Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]