OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 257)

100

101

Figure 253: Example setup for Solver

4) Choose Tools > Solver. The Solver dialog opens.

Figure 254: The Solver dialog

5) Click in the Target cell field. In the sheet, click in the cell that contains the

target value. In this example it is cell B4 containing total interest value.

6) Select Value of and enter 1000 in the field next to it. In this example, the target

cell value is 1000 because your target is a total interest earned of $1000.

Select Maximum or Minimum if the target cell value needs to be one of those

extremes.

7) Click in the By changing cells field and click on cell C2 in the sheet. In this

example, you need to find the amount invested in Fund X (cell C2).

8) Enter limiting conditions for the variables by selecting the Cell reference,

Operator and Value fields. In this example, the amount invested in Fund X (cell

C2) should not be greater than the total amount available (cell C4) and should

not be less than 0.

Chapter 9 Data Analysis 257

1 2 ... 252 253 254 255 256 257 258 259 260 261 262 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 257

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3