Добавил:
Upload Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз: Предмет: Файл:
Var_1_2-5.doc
Скачиваний:
10
Добавлен:
17.09.2019
Размер:
632.32 Кб
Скачать

В формульном виде

-90

-4

1

6

11

40,8

4

3

11

1

-9

-29,7

-9

-4

7

8

3

-1,2

-5

-1

12

7

2

11,1

-14

-5

190

15

5

9,9

-90

-4

1

6

11

40,8

=A2:F2-$A$1:$F$1*(A2/$A$1)

=A2:F2-$A$1:$F$1*(A2/$A$1)

=A2:F2-$A$1:$F$1*(A2/$A$1)

=A2:F2-$A$1:$F$1*(A2/$A$1)

=A2:F2-$A$1:$F$1*(A2/$A$1)

=A2:F2-$A$1:$F$1*(A2/$A$1)

=A3:F3-$A$1:$F$1*(A3/$A$1)

=A3:F3-$A$1:$F$1*(A3/$A$1)

=A3:F3-$A$1:$F$1*(A3/$A$1)

=A3:F3-$A$1:$F$1*(A3/$A$1)

=A3:F3-$A$1:$F$1*(A3/$A$1)

=A3:F3-$A$1:$F$1*(A3/$A$1)

=A4:F4-$A$1:$F$1*(A4/$A$1)

=A4:F4-$A$1:$F$1*(A4/$A$1)

=A4:F4-$A$1:$F$1*(A4/$A$1)

=A4:F4-$A$1:$F$1*(A4/$A$1)

=A4:F4-$A$1:$F$1*(A4/$A$1)

=A4:F4-$A$1:$F$1*(A4/$A$1)

=A5:F5-$A$1:$F$1*(A5/$A$1)

=A5:F5-$A$1:$F$1*(A5/$A$1)

=A5:F5-$A$1:$F$1*(A5/$A$1)

=A5:F5-$A$1:$F$1*(A5/$A$1)

=A5:F5-$A$1:$F$1*(A5/$A$1)

=A5:F5-$A$1:$F$1*(A5/$A$1)

-90

-4

1

6

11

40,8

=A8:F8-$A$1:$F$1*(A8/$A$1)

=A8:F8-$A$1:$F$1*(A8/$A$1)

=A8:F8-$A$1:$F$1*(A8/$A$1)

=A8:F8-$A$1:$F$1*(A8/$A$1)

=A8:F8-$A$1:$F$1*(A8/$A$1)

=A8:F8-$A$1:$F$1*(A8/$A$1)

=A9:F9-$A$8:$F$8*(B9/$B$8)

=A9:F9-$A$8:$F$8*(B9/$B$8)

=A9:F9-$A$8:$F$8*(B9/$B$8)

=A9:F9-$A$8:$F$8*(B9/$B$8)

=A9:F9-$A$8:$F$8*(B9/$B$8)

=A9:F9-$A$8:$F$8*(B9/$B$8)

=A10:F10-$A$8:$F$8*(B10/$B$8)

=A10:F10-$A$8:$F$8*(B10/$B$8)

=A10:F10-$A$8:$F$8*(B10/$B$8)

=A10:F10-$A$8:$F$8*(B10/$B$8)

=A10:F10-$A$8:$F$8*(B10/$B$8)

=A10:F10-$A$8:$F$8*(B10/$B$8)

=A11:F11-$A$8:$F$8*(B11/$B$8)

=A11:F11-$A$8:$F$8*(B11/$B$8)

=A11:F11-$A$8:$F$8*(B11/$B$8)

=A11:F11-$A$8:$F$8*(B11/$B$8)

=A11:F11-$A$8:$F$8*(B11/$B$8)

=A11:F11-$A$8:$F$8*(B11/$B$8)

-90

-4

1

6

11

40,8

=A14:F14-$A$1:$F$1*(A14/$A$1)

=A14:F14-$A$1:$F$1*(A14/$A$1)

=A14:F14-$A$1:$F$1*(A14/$A$1)

=A14:F14-$A$1:$F$1*(A14/$A$1)

=A14:F14-$A$1:$F$1*(A14/$A$1)

=A14:F14-$A$1:$F$1*(A14/$A$1)

=A15:F15-$A$8:$F$8*(B15/$B$8)

=A15:F15-$A$8:$F$8*(B15/$B$8)

=A15:F15-$A$8:$F$8*(B15/$B$8)

=A15:F15-$A$8:$F$8*(B15/$B$8)

=A15:F15-$A$8:$F$8*(B15/$B$8)

=A15:F15-$A$8:$F$8*(B15/$B$8)

=A16:F16-$A$15:$F$15*(C16/$C$15)

=A16:F16-$A$15:$F$15*(C16/$C$15)

=A16:F16-$A$15:$F$15*(C16/$C$15)

=A16:F16-$A$15:$F$15*(C16/$C$15)

=A16:F16-$A$15:$F$15*(C16/$C$15)

=A16:F16-$A$15:$F$15*(C16/$C$15)

=A17:F17-$A$15:$F$15*(C17/$C$15)

=A17:F17-$A$15:$F$15*(C17/$C$15)

=A17:F17-$A$15:$F$15*(C17/$C$15)

=A17:F17-$A$15:$F$15*(C17/$C$15)

=A17:F17-$A$15:$F$15*(C17/$C$15)

=A17:F17-$A$15:$F$15*(C17/$C$15)

-90

-4

1

6

11

40,8

=A20:F20-$A$1:$F$1*(A20/$A$1)

=A20:F20-$A$1:$F$1*(A20/$A$1)

=A20:F20-$A$1:$F$1*(A20/$A$1)

=A20:F20-$A$1:$F$1*(A20/$A$1)

=A20:F20-$A$1:$F$1*(A20/$A$1)

=A20:F20-$A$1:$F$1*(A20/$A$1)

=A21:F21-$A$8:$F$8*(B21/$B$8)

=A21:F21-$A$8:$F$8*(B21/$B$8)

=A21:F21-$A$8:$F$8*(B21/$B$8)

=A21:F21-$A$8:$F$8*(B21/$B$8)

=A21:F21-$A$8:$F$8*(B21/$B$8)

=A21:F21-$A$8:$F$8*(B21/$B$8)

=A22:F22-$A$15:$F$15*(C22/$C$15)

=A22:F22-$A$15:$F$15*(C22/$C$15)

=A22:F22-$A$15:$F$15*(C22/$C$15)

=A22:F22-$A$15:$F$15*(C22/$C$15)

=A22:F22-$A$15:$F$15*(C22/$C$15)

=A22:F22-$A$15:$F$15*(C22/$C$15)

=A23:F23-$A$22:$F$22*(D23/$D$22)

=A23:F23-$A$22:$F$22*(D23/$D$22)

=A23:F23-$A$22:$F$22*(D23/$D$22)

=A23:F23-$A$22:$F$22*(D23/$D$22)

=A23:F23-$A$22:$F$22*(D23/$D$22)

=A23:F23-$A$22:$F$22*(D23/$D$22)

=(A25:F25-H5:M5*E25-H4:M4*D25-H3:M3*C25-H2:M2*B25)/A25

=(A25:F25-H5:M5*E25-H4:M4*D25-H3:M3*C25-H2:M2*B25)/A25

=(A25:F25-H5:M5*E25-H4:M4*D25-H3:M3*C25-H2:M2*B25)/A25

=(A25:F25-H5:M5*E25-H4:M4*D25-H3:M3*C25-H2:M2*B25)/A25

=(A25:F25-H5:M5*E25-H4:M4*D25-H3:M3*C25-H2:M2*B25)/A25

=(A25:F25-H5:M5*E25-H4:M4*D25-H3:M3*C25-H2:M2*B25)/A25

=(A26:F26-H5:M5*E26-H4:M4*D26-H3:M3*C26)/B26

=(A26:F26-H5:M5*E26-H4:M4*D26-H3:M3*C26)/B26

=(A26:F26-H5:M5*E26-H4:M4*D26-H3:M3*C26)/B26

=(A26:F26-H5:M5*E26-H4:M4*D26-H3:M3*C26)/B26

=(A26:F26-H5:M5*E26-H4:M4*D26-H3:M3*C26)/B26

=(A26:F26-H5:M5*E26-H4:M4*D26-H3:M3*C26)/B26

=(A27:F27-H5:M5*E27-H4:M4*D27)/C27

=(A27:F27-H5:M5*E27-H4:M4*D27)/C27

=(A27:F27-H5:M5*E27-H4:M4*D27)/C27

=(A27:F27-H5:M5*E27-H4:M4*D27)/C27

=(A27:F27-H5:M5*E27-H4:M4*D27)/C27

=(A27:F27-H5:M5*E27-H4:M4*D27)/C27

=(A28:F28-H5:M5*E28)/D28

=(A28:F28-H5:M5*E28)/D28

=(A28:F28-H5:M5*E28)/D28

=(A28:F28-H5:M5*E28)/D28

=(A28:F28-H5:M5*E28)/D28

=(A28:F28-H5:M5*E28)/D28

=A29:F29/E29

=A29:F29/E29

=A29:F29/E29

=A29:F29/E29

=A29:F29/E29

=A29:F29/E29

Соседние файлы в предмете [НЕСОРТИРОВАННОЕ]