# solver errors

• From: "jacksonje" <jacksonje health missouri edu>
• To: "Gnumeric List (E-mail)" <gnumeric-list gnome org>
• Subject: solver errors
• Date: Wed, 30 Jan 2002 09:01:06 -0600

```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

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 in the constraints.

When I tried reversing the constraint to D8:D10 >= E8:E10 then D8:D10 solves to small numbers around 1

Any help would be much appreciated.

Jason Jackson
JacksonJE health missouri edu
```

Attachment: hw1.gnumeric
Description: hw1.gnumeric