. 70 ( Excel), . 71 ( Calc) . 72 ( ).
11 . 11
=(10>=1;C10>=1;D10>=1).
10:D10. ( ), 11 . ܻ;
11
=(11=; ; ).
11 , , .
70
A | B | C | D | |
- - | =4/$4 | =4/$5 | =D4/$6 | |
=5/$4 | =5/$5 | =D5/$6 | ||
=6/$4 | =6/$5 | =D6/$6 | ||
=(7:9) | =(C7:C9) | =(D7:D9) | ||
=(10>=1;10>=1;D10>=1) | =(11=;" "; " ") | |||
- | =12-6 | =C12-C6 | =D12-D6 | |
=13-7 | =C13-C7 | =D13-D7 | ||
=14-8 | =C14-C8 | =D14-D8 | ||
=(15:D17) | =(15:D17) | =(15:D17) | ||
=(15:D17) | =(15:D17) | =(15:D17) | ||
=(15:D17) | =(15:D17) | =(15:D17) | ||
=(18:D20;21:23) | ||||
=(18:D20;21:23) | ||||
=(18:D20;21:23) |
71
A | B | C | D | ||
- | |||||
- - | =3/$3 | =3/$4 | =D3/$5 | ||
= 4/$3 | =4/$4 | =D4/$5 | |||
= 5/$3 | =5/$4 | =D5/$5 | |||
=SUM(B6:B8) | = SUM (C6:C8) | = SUM (D6:D8) | |||
=OR(B10>=1;C10>=1;D10>=1) | =IF(A11=;" ";" ") | ||||
- | =B12-B6 | =C12-C6 | =D12-D6 | ||
=B13-B7 | =C13-C7 | =D13-D7 | |||
=B14-B8 | =C14-C8 | =D14-D8 | |||
=MINVERSE(B15:D17) | = MINVERSE (B15:D17) | = MINVERSE (B15:D17) | |||
= MINVERSE (B15:D17) | = MINVERSE (B15:D17) | = MINVERSE (B15:D17) | |||
= MINVERSE (B15:D17) | = MINVERSE (B15:D17) | = MINVERSE (B15:D17) | |||
=MMULT(B18:D20;B21:B23) | |||||
= MMULT (B18:D20;B21:B23) | |||||
= MMULT (B18:D20;B21:B23) | |||||
72
|
|
A | B | C | D | |
0,417 | 0,1 | 0,2 | ||
0,25 | 0,5 | |||
0,3 | 0,5 | |||
0,667 | 0,900 | 0,700 | ||
- | 0,583 | -0,1 | -0,2 | |
-0,25 | 0,5 | |||
-0,3 | 0,5 | |||
2,113 | 0,930 | 0,845 | ||
1,056 | 2,465 | 0,423 | ||
0,634 | 1,479 | 2,254 | ||
8619,72 | ||||
8309,86 | ||||
10985,92 |
. . 4. .
.
50 , . .
n. , ( )
S = P + I. (34)
I "".
I = P r n, (35)
r . ./. " 0,06 /" : " 6 % ".
, , I.
S 1 = P + I.
S 2 = S 1 + I = P + I +I = P + 2 I.
S 3 = S 2 + I = P + 2 I + I = P + 3 I.
, n: Sn = P + n I.
(35),
S = P + P×r n = P (1 + r n). (36)
1
, , 700 000 ., 1 20 % .
|
|
= 700 000 ., r = 20 %, n = 4.
S = P (1 +0,2∙ n) = 700000∙ (1 + 0,2∙1) = 840 000 .