.. , .. , ..
̲
7.091711/8.091711
(̲ )
2011
.. , .. , ..
̲
7.091711/8.091711
(̲ )
5 18.11. 2010 . |
- _ ____20__ . |
2011
65.431. 14 73
19
640.43/.45(076.5)
:
-. . , . ..,
. . , . . .
..
19 []: . . . . . . 7.091711/8.091711 . . : (. ) / .. , .. , . . ; ̳- , , . - . . -, . . . . - : [], 2011. - 60 .
; . , ( Microsoft Office Excel).
7.091711/8.091711 .
65.431. 14 73
ã , 2011
ã
, 2011
. | |
........................................................................................................... | |
1. .. | |
2. ........... | |
3. . | |
4. ................................. | |
5. -.................................. | |
6. -............ | |
腅 | |
腅... |
|
|
, , - . - , :
¾ ;
¾ ;
¾ ;
¾ .
( ) , . г , , , , (), ..
( ), : , , . , . , , .
, . , ( , , ), , , , .
. , .
, . () ᒺ , , -.
1.
. Microsoft Excel.
, Excel . , , , (. . 1.1 .1.2).
|
|
. 1.1.
. 1.2.
.
1.1. ( ):
- ;
- (- , , , , , );
- ( ).
1.2. , ( ).
1.3. , (. 1.1).
1.1.
, | (, , . .) | , , | (, , ) | , | |
45%, 50%, 70% | |||||
: - , | |||||
, , , , | |||||
1.4. . г :
300 ;
250 ;
, 200 ;
365 .
1.5. ( ):
1 25,2 ;
2 21,1 .
1.6. (. 1.2).
1. 2.
, | 0,5 0,6 |
0,6 0,7 | |
, , | 0,8 0,7 |
(, , ) | 0,9 1,0 |
1.7. ( 1.1 1.2).
, | (1.1) |
;
Q 1 ;
.
, | (1.2) |
;
Q 1 ( );
Y .
1.8. ( 1.3 1.4).
, | (1.3) |
;
, %.
, | (1.4) |
;
, %.
1.9. () ( 1.5 1.6, 1.7 1.8).
, | (1.5) |
.
= å 1 ´ ´ /1000, | (1.6) |
, . .;
|
|
();
( ).
, | (1.7) |
= å 1 ´ ´ /1000, | (1.8) |
1.10. ( 1.9).
= å ´ ´ /1000, | (1.9) |
, . .;
å , .
1.11. (1.10 1.11).
, | (1.10) |
( );
( );
( ).
, | (1.11) |
;
в .
1.12. (1.12):
в = , | (1.12) |
1.13. (1.13):
= (å +å ) ´ ´ , | (1.13) |
.
1.14. 1.3, 1.4, 1.5.
1. 3. (.).
ʳ | .5 + .7 | ||||||
% | .5 × .6 / 100 | ||||||
9,17 | 16,0 | 146,72 | 293,4 | 440,2 | |||
7,18 | 20,0 | 143,60 | 287,2 | 430,8 | |||
1,08 | 21,0 | 22,68 | 45,4 | 68,0 | |||
10,90 | 9,0 | 98,10 | 196,2 | 294,3 | |||
63,85 | 6,0 | 383,10 | 766,2 | 1149,3 | |||
25,50 | 7,0 | 178,50 | 357,0 | 535,5 | |||
5,20 | 4,0 | 20,80 | 41,60 | 62,40 | |||
22,35 | 4,0 | 89,40 | 178,8 | 268,2 | |||
0,40 | 400,0 | 160,0 | 80,00 | 240,0 | |||
0,162 | 280,0 | 45,36 | 90,7 | 136,1 | |||
10,00 | 16,0 | 160,00 | 320,0 | 480,0 | |||
................................. | ... | ......... | ......... | .......... | ........... | ............ | .............. |
................................. | ... | ......... | ......... | .......... | ........... | ............ | .............. |
: | å ____ | å ____ |
1.4. (.).
ʳ | .5 + .7 | ||||||
% | .5×.6 / 100 | ||||||
57,0 | 3,0 | 171,0 | 85,5 | 256,5 | |||
5,0 | 60,0 | 300,0 | 150,0 | 450,0 | |||
24,0 | 60,0 | 1440,0 | 720,0 | 2160,0 | |||
16,0 | 6,0 | 96,0 | 96,0 | 192,0 | |||
29,0 | 55,0 | 1595,0 | 1595,0 | 3190,0 | |||
32,0 | 80,0 | 2560,0 | 2560,0 | 5120,0 | |||
8,0 | 70,0 | 560,0 | 560,0 | 1120,0 | |||
ѳ | 43,0 | 7,0 | 301,0 | 150,5 | 451,5 | ||
ҳ | . | 50,0 | 2,0 | 100,0 | 50,0 | 150,0 | |
............................... | ... | .... | ...... | ....... | ...... | ...... | ...... |
: | å ____ | å 1 __ |
1.5.
|
|
, . . | , % | ||
100,0 | |||
2.
Excel.
.
2.1. (. 2.1.) ( ) ().
2.1. - [5]
() |
(, ) |
- |
- |
() 5 . |
(, ) 4 . |
3 . |
2 . |
- |
, |
- |
2.1.
ij |
( ) |
(, , ) |
2.2. - :
- ,
- .
, , .
2.3. , , , .
:
2.3.1. (2.1):
, | (2.1) |
, . ;
0,95 , ;
;
, (10 );
, .
2.3.2. (2.2):
, | (2.2) |
;
12% .
2.3.3. (2200 600) 40% , (2.3):
, | (2.3) |
t , ;
t ;
, ;
.
2.3.4. 쳿 . .
2.4. г , % (2.4):
|
|
, | (2.4) |
, %;
å , . .;
, . .
2.5. , . (2.5):
, | (2.5) |
, ..;
;
, (12 ).
. 2.2, 2.3, 2.4. .
2.2.
, | ( ) | , . . 3×. 4 | , ..5× 12 . | , .6 ×0,95 | , .7+.(8,9,10, 11) | 쳿 (30%) /. .7 | .12+ .13 | ||||||
- | - | - | - | 7952,4 | 34460,4 | ||||||||
- | - | - | - | ||||||||||
- | - | - | - | ||||||||||
- | - | - | - | - | |||||||||
.............. | ...... | ......... | ........ | .... | ... | .... | ... | ... | ...... | ..... | ...... | .... | .... |
: | å1 | å1 |
2.3.
, | ( ) | , . . 3×. 4 | , ..5× 12 . | , .6 ×0,95 | , .7+.(8,9,10, 11) | 쳿 (30 %) /. .7 | .12+ .13 | ||||||
. | - | 754,0 | 1368,0 | - | - | 24922,0 | 6840,0 | 31762,0 | |||||
- | 716,3 | 1299,6 | 23675,9 | 6498,0 | 30173,9 | ||||||||
1507,9 | 5472,0 | - | - | 98179,9 | 27360,0 | 125539,9 | |||||||
1696,4 | 6156,0 | - | - | 110452,4 | 30780,0 | 141232,4 | |||||||
1319,4 | - | - | - | 81119,4 | 23940,0 | 105059,4 | |||||||
- | 735,1 | - | - | - | 45195,1 | 13338,0 | 58533,1 | ||||||
.............. | ...... | ......... | ........ | .... | ... | .... | ... | ... | ...... | ..... | ...... | .... | .... |
: | å2 | å2 |
2.4. , ,
, | ( ) | , . . 3×. 4 | , ..5×12 . | , .6 ×0,95 | , .7+.(8,9,10, 11) | 쳿 (30 % /. .7 | .12+ .13 | ||||||
- | 640,9 | - | - | - | 39400,9 | 11628,0 | 51028,9 | ||||||
- | 4222,2 | - | - | - | 259582,2 | 76608,0 | 336190,2 | ||||||
- | 1131,0 | - | - | - | 35331,0 | 10260,0 | 45591,0 | ||||||
- | 980,2 | - | - | 61333,4 | 17784,0 | 79117,4 | |||||||
- | 207,3 | 12747,3 | 3762,0 | 16509,3 | |||||||||
- | - | 15960,0 | 4788,0 | 20748,0 | |||||||||
- | - | 20520,0 | 6156,0 | 26676,0 | |||||||||
- | 829,4 | 25909,4 | 7524,0 | 33433,4 | |||||||||
.............. | ...... | ......... | ........ | .... | ... | .... | ... | ... | ...... | ..... | ...... | .... | .... |
: | å3 | å3 |
3.
³ . 145 . 3.1. , .
3.1. [2]
̳ , | |
1 | |
2 , | |
3 , , | |
4 : , , , ( , , / , ) , ( ), , 1000 | |
5 | |
6 , , () | |
7 | |
8 | |
9 | |
10 | |
11 | |
12 () | |
13 | |
14 | |
15 | |
16 |
- , , .
, , , , .
() ᒺ, ᒺ ( ), , , , .
() :
─ ᒺ ;
─ , ;
─ ᒺ .
() ᒺ , .
ᒺ .
:
1) , , , ᒺ ;
2) , ᒺ . г ( ) ᒺ ᒺ ;
3) , ᒺ , ᒺ .
4) ᒺ , 4 ( ) 5 ( );
5) , , , . , ᒺ , ;
6) , (, ) . , , (, ), () ᒺ .
3.1. (3.1):
()= (-1)+(-1)-(-1)-(-1), | (3.1) |
() ;
(-1) , ;
(-1) , , , , ;
(-1) , ;
(-1) , , .
3.2. 4 . ³ ( ), ( . 7 3.1, 3.2, 3.3, 3.4).
1. | 5 % |
2. , | 25 % |
3. , , , , | 20 % |
4. , - | 50 % |
3.3. ( ) , -, .
3.4. 3-10 . /2 .
3.5. , , , 20 %. ( . 5 3.1, 3.2, 3.3, 3.4).
3.6. г (3.2):
, | (3.2) |
, %;
å , . .;
, . .
3.1. 1. ().
, 2 | /, . . | .2 ´.3 | г , % | , . . | |
352,8 | |||||
: | - | - | å1 | å1 |
3.2. 2. ( , )
³ | .2 ´1,2 | ʳ | .3 ´.4 | г , % | ||
. | . | . | . | |||
: | å2 | å2 |
3.3. 3. (, , , , )
³ | .2 ´1,2 | ʳ | .3 ´.4 | г , % | ||
RN -20A | ||||||
³ | ||||||
ϳ | ||||||
542,4 | ||||||
.. | .. | .. | .. | . | ||
: | å3 | å3 |
3.4. 4. ( , )
³ | .2 ´1,2 | ʳ | .3 ´.4 | г , % | ||
. | . | . | .. | |||
: | å4 | å4 | ||||
å | å |
4.
4- :
1) ;
2) ;
;
.
1) (4.1):
, | (4.1) |
( );
;
N , .
______ . .
2) :
2.1.) ;
2.2.) ( );
2.3.) (. 3.2 3.4);
2.4.) . 3.2 3.4) 10 % ;
2.5.) ;
2.6.) ;
2.7.) ;
2.8.) ;
2.9.) ;
2.10.) ;
2.11.) ;
2.12.) .
______ . .
3) :
3.1.) - ;
3.2.) ;
3.3.) ( );
3.4.) , ;
3.5.) , ( );
3.6.) , , , , (. 3.1 3.3);
3.7.) (, , , , - . 3.1 3.3) 10 % ;
3.8.) ;
3.9.) (4.2):
㳿´ 1 /´, | (4.2) |
3.10.) (4.3):
㳿´ 1 /´, | (4.3) |
3.11.) (4.4):
´6 ´S´h´p, | (4.4) |
, /3 ;
6 ( 5 );
S , ;
h ,
.
3.12.) ( 4.5 4.6, 4.7):
+, | (4.5) |
= (++)´´, | (4.6) |
13 , .
= 80%´(++) ´´, | (4.7) |
13 , .
80% .
, , , 3 :
) (4.8):
´6 ´1,5, | (4.8) |
( , );
6 1 ;
1,5 .
) (4.9):
´500 ´1, | (4.9) |
,
500 1 ;
1,0 .
) (4.10):
´110 ´1,5, | (4.10) |
;
110 1 ;
1,5 .
3.13.) ;
3.14.) ;
3.15.) ;
3.16.) ;
3.17.) ;
3.18.) .
______ . .
4) :
______ . .
=1+2+3+4.
-
5.1.
5.1.Գ
, . . | % | ||
(.1 .2) | |||
, | |||
4.1 | |||
4.2 | |||
4.3 | |||
4.4 | |||
Գ (.3 .4) | |||
(.5 .6) | |||
³ | |||
5.1. . (5.1):
, | (5.1) |
, . .;
, . .;
(%), .
5.2. (5.2):
= , | (5.2) |
, . .
5.3. Գ (5.3):
Գ = , | (5.3) |
5.4. (5.4):
, | (5.4) |
;
N (%), .
:
;
;
;
.