) 11 , 1- :
=(11:G11) ( OpenOffice.org Calc =SUM(C11:G11).
12, 13 , :
=(12:G12), (=SUM (12:G12))
=(13:G13), (=SUM (13:G13)).
5.
) 15 ,
=(11:13) (=SUM(11:13)).
D15:G15 , 2-, 3-, 4-, 5- .
D15 = (D11:D13) (=SUM(D11:D13)).
E15 = (E11:E13) (= SU (E11:E13)).
F15 = (F11:F13) (=SU (F11:F13)).
G15 = (G11:G13) (=SU (G11:G13)).
1-
Z 1 = X11 C11 + X12 C12 + X13 C13
16 :
=(5:7;11:13).
( OpenOffice.org Calc =SUMPRODUCT(C5:C7;C11:C13)).
D16
Z 2 = X12 C12+ X22 C22+ X32 C32, .. .
=(D5:D7;D11:D13) (=SUMPRODUCT(D5:D7;D11:D13)).
16:G16
16 =(5:7;11:13),
(=SUMPRODUCT(5:7;11:13)).
F16 =(F5:F7;F11:F13),
(=SUMPRODUCT(F5:F7;F11:F13)).
G16 =(G5:G7;G11:G13),
=SUMPRODUCT(G5:G7;G11:G13)).
5. ( )
Z = Z1 + Z2 + Z3 + Z4 + Z5
17
=(16:G16),
(=SUM(C16:G16)).
44 .
29
A | B | C | D | E | F | G | |
1- | 2- | 3- | 4- | 5- | |||
|
|
| |||||||||
|
()
I. Excel Microsoft office.
1) , (. 4).
( Microsoft Office 2007 ).
2) :
17
:
C11:G13
3) .
4) (. 5) .
C11:G13 >= 0
11: G13 =
11:13 £ B5:D7
15:G15 ³ C9:G9
( , , . , .)
. 4
5) (. . 4). . 29 . 4 . 5 , , . , (. 32).
. 5
II. OpenOffice.org Calc
1) , (. 6).
2) :
17
:
C11:G13
3) .
4) (. 7). :
C11:G13 >= 0,
11:13 £ B5:D7,
15:G15 ³ C9:G9.
.
. 6
. 7
5) . 6, R (. 8), Ok.
. 8
, 121 (. 32).
32