-

N 2. ( ), , , , () ( 05 " , " )

N 2

( ), , , , () ( 05 " , " )

:

. 0504143 " ", 30 2015. N52

. MS-Excel

.

                                                               
                                                                ___________ _____________________
                                                                   ()  ( )

                                                               "__" _____________________ 20 ___ .

N _______

0504143

"______ " ___________________ 20 ___ .

_______________________________________________________________

_________________________________________________

___________________________________________

    _________________________________________________________________________________________
                                             (, , )
 ____________________________________________________________________________________________________________
 ____________________________________________________________________________________________________________
   ( )  "__" __________________ 20__ . N ____   
         ________________________________________________
                                                                (  )
 ____________________________________________________________________________________________________________

  ,             
   ,      :

N /

, .

, .

1

2

3

4

5

6

7

8

0504143 . 2

      ____________________________________________________________________________
                                                        ( )
    ____________________________________________________________________________________
                                                             ()
  : ________________________________________________________________________________________
 ____________________________________________________________________________________________________________
 ____________________________________________________________________________________________________________

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

      ,         
 ()   :

N /

, .

, .

1

2

3

4

5

6

7

8

 ____________________________________________________________________________________________________________
                                           ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

          N ____  "___" ________________________ 20__ .

                                                                                  /----------------\
                                                                           |              | 
                                                                                  \----------------/

 "__" ______________________ 20 ___ .

:

. 0504144 " ", 30 2015. N52

. MS-Excel

.

                                                               
                                                                ___________ _____________________
                                                                   ()  ( )

                                                               "__" _____________________ 20 ___ .

N __________

0504144

"_______" _____________________ 20 ___ .

____________________________________________________________________

______________________________________________________

__________________________________________________________

              /----------------------------\                                   /----------------------------\
    |                           |                        |                            |
              \----------------------------/                                   \----------------------------/

    _________________________________________________________________________________________
                                          (, , )
 ____________________________________________________________________________________________________________
 ____________________________________________________________________________________________________________
   ( )  "____"_____________________ 20 __ . N _________  
   _______________________________________________________________________________________
                                                 (  )
                                                                                   /-----------------\
  ,               |             |.
                                                                                   \-----------------/
   () ________________________________________________________________________________________
                                                                                   /-----------------\
 _________________________________________________________________   (0,00)|             |.
                                                                                   \-----------------/
      .

     :      .

               .

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

1

2

3

4

1. ( )

2.

3. , ,

4.

5.

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

0504144 . 2

N _________ "_______" ____________________ 20 ___ .

___________________________________________

N /

, .

, .

1

2

3

4

5

6

7

8

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

0504144 . 3

N _________ "_______" ____________________ 20 ___ .

___________________________________________

N /

, .

, .

1

2

3

4

5

6

7

8

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

 "__" ______________________ 20 ___ .

:

. 0504202 "- ", 30 2015. N52

. MS-Excel

.

 ___________ _____________________
    ()  ( )

"__" _____________________ 20 ___ .

- N _______

()

,

.

.

,
.

,

.

۠

0504202

"___" __________________ 20___ .

1

2

3

4

5

6

7

______________________________________________

___________________________

_________________________

,

()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

-

(, )

(, , , )

,

0504202 . 2

,

()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

, ,

,

-

()

  ______________ ______________________                                                                  ______________ _____________________
             ()     ( )                                                                          ()   ( )

  () ______________ ____________________                                                            ______________ _____________________
                      ()   ( )                                                                       ()   ( )

:

. 0504203 " ", 30 2015. N52

. MS-Excel

.

                                                                         
                                                                          ___________ _____________________
                                                                             ()  ( )

                                                                         "__" _____________________ 20 ___ .

N ______

___________________________ 20__ .

0504203

________________________________________________________________________________________

_________________________________________________________________________

____________________________________________________________________

()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

0504203 . 2

()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

  ____________________ _____________ ______________________      ____________________ _____________ ______________________
           ()        ()    ( )                   ()        ()  ( )

 "_______" _________________ 20 ___ .

:

. 0504210 " ", 30 2015. N52

. MS-Excel

.

                                                                         
                                                                          ___________ _____________________
                                                                                       ()  ( )

                                                                         "__" _____________________ 20 ___ .

0504210

"___" ______________________ 20__ .

_____________________________________________________________

______________________________________________

_________________________________________

:

  _________________ _______________________   ___________ ________ _____________________
    ()         (                        () ()     (
                                  )                                                      )

 "___" ______________________ 20 ___ .

0504210 . 2

,

1

2

3

4

5

6

7

8

9

10

11

12

13

:

. 0504230 " ", 30 2015. N52

. MS-Excel

.

                                                              
                                                               ___________ _____________________
                                                                  ()  ( )

                                                              "__" _____________________ 20 ___ .

0504230

"________" _______________________ 20 ___ .

___________________________________________________________________

____________________________________________________

_______________________________________________

    ________________________________________________________________________________________
                                               (, , )
 ___________________________________________________________________________________________________________
 ___________________________________________________________________________________________________________
   ()  "______" _________________ 20 ____  .  N  _____________  
                 
  :

, .

, .

1

2

3

4

5

6

7

8

9

10

0504230 . 2

, .

, .

1

2

3

4

5

6

7

8

9

10

                                                      /--------\
         |        |
                                                 |       |______________________________ .
                                                      \--------/         ( )

  : ______________________________________________________________________________________
 ___________________________________________________________________________________________________________
 ___________________________________________________________________________________________________________

  :
                              __________________        __________________       _______________________
                                 ()                ()            ( )

  
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )
                              __________________        __________________       _______________________
                                 ()                ()            ( )

 "__" ______________________ 20 ___ .

:

. 0504401 "- ", 30 2015. N52

. MS-Excel

.

- N _____

"__" __________________ 20__ . "__" __________________ 20__ .

0504401

__________________________

_______________________ 20 ____ .

____________________________________________________________________

_________________

__________________________

()

( )

_____________________________________________________

__________________

________________________________

, .

383

()

( )

N

N /

, ,

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

0504401 . 2

N /

, ,

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

                                 /---------------------\               /-----------------------------\                /-------------------------\
   :   |                  |,      |                          |,   |                      |
                                 \---------------------/               \-----------------------------/                \-------------------------/

  ____________ __________ ____________________                       _____________ ____________ _____________________
          ()  ()  ( )                                ()    ()  ( )
  ____________ __________ ____________________                       ________________ ________________________
          ()  ()  ( )                                 ()    ( )

 "______" ______________________ 20 ____ .                                 "______" ______________________ 20 ____ .

:

. 0504403 " ", 30 2015. N52

. MS-Excel

.

"_____" ____________ 20 ___ . "_____" ___________ 20 ___ .

________________________________________________

_________________ _________________________

() ( )

__________________ _________________________

() ( )

N ____

_______________________________________

0504403

_____________________ 20 ____ .

____________________________________________________________________

_____________________________________________________

:

383

N

N /

, ,

1

2

3

4

5

0504403 . 2

N /

, ,

1

2

3

4

5

0504403 ( )

N /

, ,

1

2

3

4

5

   :

            /--------------\              /--------------------\                 /--------------------------\
      |             |,     |                   |,    |                         |
            \--------------/              \--------------------/                 \--------------------------/

  ____________ _____________________
          ()  ( )

 "__" __________________ 20__ .

  ___________________ __________________ ________________________
               ()          ()      ( )

 "__" __________________ 20__ .

  __________________ ____________________ _________________________
               ()          ()       ( )

  __________________ ____________________ ____________________________
               ()          ()        ( )

 "__" __________________ 20__ .

:

. 0504417 "-", 30 2015. N52

. MS-Excel

.

-

0504417

________________________________________________________________________________________________

_________________________________________________________________________________

, , ____________________________________________________________________________________

,

()

, , ..

1

2

3

4

5

6

7

8

9

10

11

12

13

()

,

( )

1

2

3

4

5

6

7

8

9

10

11

12

13

0504417 . 2

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

01

02

:

03

04

05

06

07

08

09

10

11

12

13

14

15

:

16

17

18

19

20

21

22

23

24

0504417 . 3

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

25

26

:

27

28

29

30

31

32

33

34

35

36

37

38

39

:

40

41

42

43

44

45

46

47

48

  _____________ ____________ _____________________                  " _______" ___________________ 20 ____ .
              ()    ()  ( )

0504417 . 4

:

. 0504421 " ", 30 2015. N52

. MS-Excel

.

 ___________ _____________________
    ()  ( )

"__" _____________________ 20 ___ .

0504421

__________________________ 20 ___ .

______________________________________________________________________________________________________________

_____________________________________________________________________________________________

*:

1 - 3

,

4 - 11

____________________

* , .

, , , - .

0504421 . 2

N /

,

()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

0504421 . 3

()

1- ()

()

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

. 0504421

()

1- ()

()

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

. 0504421

N /

,

()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

  ________________ _______________ _________________________      "__"______________________ 20__ .
              ()        ()      ( )

:

. 0504425 "- , ", 30 2015. N52

. MS-Excel

.

- N ___________

,

0504425

"___" ____________________ 20__ .

____________________________________________________________________

_____________________________________________________

,

_______________________________________________________

, , ________________________________________________________

( . ) ________________________________________

_____________________________________________________________________

:

383