2
080100.62 ; 080101.62
:
̻ , .
MS Excel (, , OpenOffice Calc).
;
( 10 );
;
() .
, , . , , , , .
, , .
- 1.
1
, , (25). . (.. 0), (25).
1. 12-- 32, 25, mod(32,25) = 7.
2. 12-- 16, 25, mod(16,25) = 16.
3. 12-- 50, 25, mod(50,25) = 0 25.
, MS Excel ( OpenOffice Calc) . :
1) .
2) , , , . MS Excel ( OpenOffice Calc).
|
|
3) ( 10 ), .
4) MS Excel ( OpenOffice Calc) , , .
1. - ( 0 2 1). ( ), . , . . , .
2. , ( ), . , . , . . . , .
3. ( ). , : 500 ., 50% - 67% ; 750 ., 49% . ( , ). , (.. 2 ).
4. , , , .. . . : 1 000 . - 8 . ; 1 000 2 000 . - 6 . ; 2 000 . - 5 . . , 10% . ( ). , (.. 2 ).
5. ( - 5, 4, 3 2). : - 200 ., "" "" - 25% "" - 50% ( ). , . , .
6. - , , (6 12 ) ( 18% 25%). , , 3/4 , 30%. 25%. , .
|
|
7. , . . ( ). , .
8. , , - . ( , ). , : 1 - 300 ., 2- - 250 . , 3- - 225 . . , .
9. , , ( ). , " ", 10% , " ", 1% . , .
10. , , (3, 6 12 ) ("" ""). . : ( ). , : .
11. ( ), 1- , ( ). 1- ( ), ( ) ( 1- ). ( ). ( ), 1- .
12. . ( 1% 4%). 1- , . . , ().
13. . , , . , 15 , 10% . , 0,5% . . , .
|
|
14. - , . . , - 3%, 2%, - 4%, - 5%. . , .
15. . 8- . . . . , .
16. , , , , . 1% . . , .
17. , , ( ). . : 30 - 20 ./; 30 60 - 15 ./ 60 - 12 ./. , 10% . , .
18. , , ( ). ( !). . , , . . , .
19. , , . , , . , ( ). , .
20. , (3, 6 12 ) , : 17% , 10 000 . 19% 10 000 . . . , .
21. . - 25 000 . . ( ). . , .
|
|
22. . , , . , , 10%, , 50%. , (.. 2 ).
23. () , . , 20%, - 30%, ( . . , .
24. , (3, 6 12 ) , : 18% 3 , 19% 6 22% 12 . . , .
25. - , (20%) (5%). . , , 25%. , .
1. : , , , /. , 100. 1.
2. , , , , .
3. . , .
4. , MS Excel, :
(X1 : XN) N X ( ;
(X1: XN) N X;
(X1: XN) N X;
(X1: XN) N X;
(L1; L2;...) , L1, L2,... , , ;
(L1; L2;...) , L1, L2,... , , ;
(L; V1; V2) V1, L V2, .
:
C = (A1: AN)
Ri = (Ti =; S i*(1+P); Si)
Ci = (Zi<U; Zi +500; (Z i> Q; Zi -250; Zi))
Di = ((Ei>=4; Vi>=4); B+X; B+Y)
.
OpenOffice Calc : SUM, AVERAGE, MIN, MAX, OR, AND, IF, .
5. , (. ).
|
|
6. , .
7. .
8. , , , .
9. , , , .
10. , ( ), .
11. / / .
. , . ( ). ( ) . . , . , .
( , ). , :
N ( - );
Vi , i = 1,..., N ( - );
S ( - );
P ( - );
C ( - );
Di , i = 1,..., N ( );
Zi , i = 1,..., N ( );
Ri ( );
VN , N - , ( );
DN , ( );
ZN , ( );
RN ( ).
, . , , :
VN = (V1: VN),
C = S / VN
Di = Vi / VN, i = 1,..., N
Zi = Vi * C, i = 1,..., N
Ri = Zi * (1 - P), i = 1,..., N
DN = (D1: DN),
ZN = (Z1: ZN),
RN = (R1: RN),
( ).
, , . , , . .
, . S P.
, 2, .
2
- | |||||
: | 32 000 . | : | 13% | ||
, . | |||||
23,3% | 7 467 . | 6 496 . | |||
12,7% | 4 053 . | 3 526 . | |||
17,3% | 5 547 . | 4 826 . | |||
13,3% | 4 267 . | 3 712 . | |||
33,3% | 10 667 . | 9 280 . | |||
100,0% | 32 000 . | 27 840 . | |||
1 : | 106,67 . |
(N=5). N ≥ 10.
.
. .
. . , - $ .
( S ). ( fx ), , .
, . , 3. Ctrl+~ (Ctrl+).
3 MS Excel
A | B | C | D | E | F | |
- | ||||||
: | : | 0,13 | ||||
, . | ||||||
=C4/$C$9 | =C4*$E$10 | =E4*(1-$F$2) | ||||
=C5/$C$9 | =C5*$E$10 | =E5*(1-$F$2) | ||||
=C6/$C$9 | =C6*$E$10 | =E6*(1-$F$2) | ||||
=C7/$C$9 | =C7*$E$10 | =E7*(1-$F$2) | ||||
=C8/$C$9 | =C8*$E$10 | =E8*(1-$F$2) | ||||
=(C4:C8) | =(D4:D8) | =(E4:E8) | =(F4:F8) | |||
1 : | =C2/C9 |
/ . .
: 1) B3:C8; 2) / ; 3) ( ), ( !); 4) , , , , , , . ( 1).
1 :
: 1) B3:B8, , Ctrl, F3:F8; 2) / ; 3) ( ), ; 4) ( ); 5) (, Delete). ( 2).
2 :
1. .. . .: , 2007. 765 .
2. .. . : .: , 2007. 640 .
3. Microsoft Office Online [ ]. : http://office.microsoft.com/ru-ru/training.