N 4. , ( ), , , () ( 05 " , " )

N 4

30 2015. N 52
( 16 2016 ., 17 2017 .)

:

0504031 29 2017 . - 17 2017. N194

.

:

. MS-Excel

.

                                                                                                    /-------\
                   N _____                               |   |
                                                                                                    |-------|
                                                                                         |0504031|
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
          _____________________________________________________________       |       |
                                                                                                    |-------|
   ____________________________________________________________             |       |
                                                                                                    |-------|
   ()_________________________________________________________       |       |
                                                                                                    |-------|
        ______________________________________________________________             |       |
                                                                                                    |-------|
 - ()_________________________________________________        |       |
                                                                                                    |-------|
                                                                             |       |
             _________________________________________________________________________              |-------|
                      (,   ,  )                      |       |
                                                                                                    |-------|
   ()______________________________________________________        *|       |
                                                                                                    |-------|
  (-)  (-)  ______________________________________________________              |       |
                                                                                                    |-------|
  :                                                                        |  383  |
                                                                                                    \-------/

                 /-----------------\              /------------------\                          /-----------\
 |                 |    |                  |          |           |
                 |                 |              |                  |   ( )|           |
                 \-----------------/              \------------------/                          \-----------/

1.    

, , , , , , ..

() ()

,

()

, ()

()

1

2

3

4

5

6

7

8

9

10

2.  ,   ,  

()

,

,

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

                                                                         /----------\        /--------------\
     ____________________          |          |   |              |
                                       ( )        |          |        |              |
                                                                         \----------/        \--------------/

______________________________

*    ,     ().

. 0504031

3.

4.

(-) (-)

()

1

2

3

4

5

6

7

8

9

10

11

5.

, *

,

(, ..)

(, , , ),

()

()

1

2

3

4

5

6

7

8

9

10

11

______________________________

*   ( ,  ) -  (), , , 
(   (),   (),    ).

.      (, , , , ,  
.)  ___ .  ____ .

  ______________ ____________ ______________________
                   ()    ()   ( )

:

0504032 29 2017 . - 17 2017. N194

.

:

. MS-Excel

.

                                                                                                    /-------\
                 N _____                       |   |
                                                                                                    |-------|
                                                                                         |0504032|
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
 () _____________________________________________________________   |       |
                                                                                                    |-------|
      _____________________________________________________________         |       |
                                                                                                    |-------|
   ()_____________________________________________________________   |       |
                                                                                                    |-------|
             _____________________________________________________________         |       |
                                                                                                    |-------|
 -     _____________________________________________________________   |       |
                                                                                                    |-------|
                    _____________________________________________________________         |       |
                                                                                                    |-------|
   ()___________________________________________________________   *|       |
                                                                                                    |-------|
  (-)  (-)  ___________________________________________________________         |       |
                                                                                                    |-------|
  :  (0,00)                                                                |  383  |
                                                                                                    \-------/

                           /-----------------------------\                              /-------------------\
                 |                             |      |                   |
                           |                             |               ( )|                   |
                           \-----------------------------/                              \-------------------/

1.   

,

***

**

()

1

2

3

4

5

6

7

8

9

2.  ,   ,  

()

,

()

,

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

______________________________

 *         ,    
   ().
 **     (  (),    ,
  ).
 ***  ,  ,     ,  
    ,  ,  .

. 0504032

3.

()

1

2

3

4

5

6

7

8

9

4.

.      (, , , , ,  
.)  ___ .  ____ .

  ______________ ____________  ______________________
                   ()    ()     ( )

:

. MS-Excel

.

             /--------\
                                                               |    |
                                                               |--------|
                                                    |0504033 |
                                                               |--------|
              ____________ 20__ .                |        |
                                                               |--------|
                _____________ 20__ .                    |        |
                                                               |--------|
  _______________________________________      |        |
                                                               |--------|
   ________________________            |        |
                                                               \--------/

1

2

3

4

5

 _____________ ___________ _______________________
             ()   ()   ( )

"____"___________________ 20__ .

:

0504034 29 2017 . - 17 2017. N194

.

:

. MS-Excel

.

                            /-------\
                                                                |   |
                                                                |-------|
                                                     |0504034|
                                                                |-------|
  ___________________________________________   |       |
                                                                |-------|
   ____________________________         |       |
                                                                |-------|
  (-)  (-) ________________________         |       |
                                                                \-------/

()

1

2

3

4

5

6

7

8

 _____________ ___________ _______________________
             ()   ()   ( )

"____"___________________ 20__ .

:

0504035 29 2017 . - 17 2017. N194

.

:

. MS-Excel

.

                             
                            
                                                                                                /-----------\
                                                                                                |       |
                                                                                                |-----------|
                                                                                     |  0504035  |
                                                                                                |-----------|
                          ______________ 20__ .                                          |           |
                                                                                                |-----------|
   _______________________________________________________________________      |           |
                                                                                                |-----------|
    ________________________________________________________            |           |
                                                                                                |-----------|
  (-)  (-)  ____________________________________________________            |           |
                                                                                                |-----------|
                                                                                      |           |
                                                                                                \-----------/

         _____________     ___________     ________________________
                     ()       ()       ( )

"____"___________________ 20__ .

0504035 .2

N /

1 20___ .

_________________

0504035 .3

N /

____________

_______________

____________

_______________

0504035 .4

N /

____________

_____________

1 20__ .

:

. MS-Excel

.

                                              /-------\
                                                                |   |
                                                                |-------|
                                                     |0504036|
                                                                |-------|
              _______________ 20__ .                     |       |
                                                                |-------|
    ____________________________    |       |
                                                                |-------|
   ___________________________          |       |
                                                                |-------|
                                                      |       |
                                                                |-------|
  :                                    |  383  |
                                                                \-------/

 _____________  _____________ _______________________
             ()     ()    ( )

"_____"_________________ 20__ .

0504036 .2

_____________

____________

_____________

____________

01

02

03

04

05

06

07

08

09

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

0504036 .3

______________

______________

______________

_____________

______________

01

02

03

04

05

06

07

08

09

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

:

. MS-Excel

.

                                                                                                   /--------\
                             N ____                                          |    |
                                                                                                   |--------|
                                                               | 0504037|
                                                                                                   |--------|
                            ___________________ 20__ .                                      |        |
                                                                                                   |--------|
  __________________________________________________________________________       |        |
                                                                                                   |--------|
   ________________________________________________________________        |        |
                                                                                                   |--------|
    ___________________________________________________________        |        |
                                                                                                   \--------/

,

,

,

,

,

,

,

,

,

,

,

,

,

  _____________ ___________ _______________________    _____________ ___________ _______________________
           ()   ()   ( )              ()   ()   ( )

:

. MS-Excel

.

                                                                                                   /--------\
                             N ____                                          |    |
                                                                                                   |--------|
                                                               | 0504038|
                                                                                                   |--------|
                            ___________________ 20__ .                                      |        |
                                                                                                   |--------|
  __________________________________________________________________________       |        |
                                                                                                   |--------|
   ________________________________________________________________        |        |
                                                                                                   |--------|
    ___________________________________________________________        |        |
                                                                                                   \--------/

,

,

 ____  -    ___________ _________ _____________________   ___________ _________ _____________________
                                                 () () ( )           () () ( )

:

. MS-Excel

.

                                                                /-------\
                                              |   |
                                                                |-------|
                                                     |0504039|
                                                                |-------|
                                                    |       |
                                                                |-------|
                                                    |       |
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                |-------|
    _____________________________   |       |
                                                                |-------|
                                                      |       |
                                                                \-------/
                                                                /-------\
   _____________________________________________     |       |
                                                                \-------/
                                                                /-------\
   ________________________________________     |       |
                                                                \-------/

()

( , )

,

,

,

,

1

2

3

4

5

6

7

8

9

10

11

:

0504041 29 2017 . - 17 2017. N194

.

:

. MS-Excel

.

                                                                                                    /-------\
                        -                                        |   |
                                                                                                    |-------|
                                                                    |0504041|
                                                                                                    |-------|
  ___________________________________________________________________________       |       |
                                                                                                    |-------|
   _______________________________________________________________________  |       |
                                                                                                    |-------|
  (-)  (-)  __________________________________________________________________  |       |
                                                                                                    |-------|
   __________________________________________________________________    |       |
                                                                                                    |-------|
  ,  ,                                                         |       |
 ,  _______________________________________________________________________________  |       |
                                                                                                    \-------/

,

,

,

,

,

,

,

1

2

3

4

5

6

7

8

9

10

11

12

13

  _________________ _____________ _______________________
                     ()      ()    ( )

"____"___________________ 20__ .

:

. MS-Excel

.

                                                           /-------\
                                      |   |
                                                                |-------|
                                                     |0504042|
                                                                |-------|
                                                    |       |
                                                                |-------|
                                                    |       |
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                |-------|
    _____________________________   |       |
                                                                \-------/

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

( )

( )

0504042 ( )

:

. MS-Excel

.

                                                        /-------\
                                      |   |
                                                                |-------|
                                                     |0504043|
                                                                |-------|
                                                    |       |
                                                                |-------|
                                                    |       |
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                |-------|
    _____________________________   |       |
                                                                \-------/

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

( )

( )

  ___________  _________  ______________________
                  ()  ()  ( )

0504043 ( )

:

. MS-Excel

.

                                                                /-------\
                                       |   |
                                                                |-------|
                                                     |0504044|
                                                                |-------|
                                                    |       |
                                                                |-------|
                                                    |       |
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                |-------|
    _____________________________   |       |
                                                                \-------/

()

1

2

3

4

5

6

:

. MS-Excel

.

                                                                                                    /-------\
                                                                                               |   |
                                                                                                    |-------|
                                                            |0504045|
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
  ________________________________________________________________________          |       |
                                                                                                    |-------|
   ______________________________________________________________________   |       |
                                                                                                    \-------/
                                                                /-----\                             /-------\
                                     ,  |1,00 |                   |       |
                                                                \-----/                             \-------/
                                                                                                    /-------\
     _______________________________________________      |       |
                                                                                                    \-------/

( )

( , )

()

()

()

,

()

1

2

3

4

5

6

7

8

9

10

11

12

:

. MS-Excel

.

                             
       ,
                  
                                                                /-------\
                                                                |   |
                                                                |-------|
                                                     |0504046|
                                                                |-------|
                                                    |       |
                                                                |-------|
                                                    |       |
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                |-------|
  :                                    |  383  |
                                                                \-------/

0504046 . 2, 4, 6 ..

,

,

1

2

3

4

5

6

0504046 . 3, 5, 7 ..

7

8

9

10

11

12

13

0504046 ( )

,

N

/

, ,

1

2

3

4

5

:

. MS-Excel

.

                                                                /-------\
                                        |   |
                                                                |-------|
                                                     |0504047|
                                                                |-------|
            "____"___________ 20___ .                    |       |
                                                                |-------|
  ___________________________________           |       |
                                                                |-------|
   _____________________                |       |
                                                                |-------|
  :                                    |  383  |
                                                                \-------/

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

, ,

1

2

3

4

5

   _________ _____________________
 () ( )    "____"______________ 20__ .

    ___________  ______________________
           ()   ( )

:

. MS-Excel

.

                                        
                                                                                 /-------\
           ,                             |   |
                                                                                                    |-------|
                                                                                         |0504048|
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
                                                                                        |       |
                                                                                                    |-------|
  __________________________________________________________________________        |       |
                                                                                                    |-------|
   ___________________________________________________________              |       |
                                                                                                    |-------|
  :                                                                        |  383  |
                                                                                                    \-------/

, ,

()

()

,

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

:

. MS-Excel

.

                                                                /-------\
                    N ______                            |   |
                                           |-------|
                                                     |0504051|
                                                                |-------|
                 ____________ 20__ .                     |       |
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                |-------|
   ()________________        |       |
                                                                |-------|
  :                                    |  383  |
                                                                \-------/

1

2

3

4

5

6

7

 _____________ ___________ _______________________
             ()   ()   ( )

"____"___________________ 20__ .

:

. MS-Excel

.

                                                                /-------\
                                                  |   |
                                                                |-------|
                                                     |0504052|
                                                                |-------|
  ______________________________________        |       |
                                                                |-------|
   _______________________              |       |
                                                                \-------/

1

2

3

4