Рассчитать схему обогащения по заданным: конфигурации схемы фракционному составу сырья и сепарационным характеристикам оборудования. Расчет простой технологической схемы, страница 6

Вых10

Вых4

Сод12

Сод10

Сод4

Сод 1

0,86

0,86

=L2*E2*D2*C2

=M2*D2*E2*C2

=N2*E2*D2*C2

=C2*D2*E2

=M3*D3*C3

=N3*D3*C3

=L3*E3*D3*C3

=M3*D3*E3*C3

=N3*E3*D3*C3

=C3*D3*E3

=M4*D4*C4

=N4*D4*C4

=L4*E4*D4*C4

=M4*D4*E4*C4

=N4*E4*D4*C4

=C4*D4*E4

=M5*D5*C5

=N5*D5*C5

=L5*E5*D5*C5

=M5*D5*E5*C5

=N5*E5*D5*C5

=C5*D5*E5

=M6*D6*C6

=N6*D6*C6

=L6*E6*D6*C6

=M6*D6*E6*C6

=N6*E6*D6*C6

=C6*D6*E6

=M7*D7*C7

=N7*D7*C7

=L7*E7*D7*C7

=M7*D7*E7*C7

=N7*E7*D7*C7

=C7*D7*E7

=M8*D8*C8

=N8*D8*C8

=L8*E8*D8*C8

=M8*D8*E8*C8

=N8*E8*D8*C8

=C8*D8*E8

=M9*D9*C9

=N9*D9*C9

=L9*E9*D9*C9

=M9*D9*E9*C9

=N9*E9*D9*C9

=C9*D9*E9

=СУММ(H12:H19)

=СУММ(I12:I19)

=СУММ(J12:J19)

=СУММ(K12:K19)

=СУММ(L12:L19)

=СУММ(M12:M19)

=H20*100

=I20*100

=J20/G20

=K20/H20

=L20/I20

№ продукта

Выход,%

Содер.,%

Извл.,%

1

100

=M20

=B25*C25/$M$20

2

=B27+B28

=(E21*B21+I21*L21)/B26

=B26*C26/$M$20

3

=B21

=E21

=B27*C27/$M$20

4

=I21

=L21

=B28*C28/$M$20

5

=B27+B37

=(B27*C27+B37*C37)/B29

=B29*C29/$M$20

6

=B28+B38

=(B28*C28+B38*C38)/B30

=B30*C30/$M$20

7

=C21

=F21

=B31*C31/$M$20

8

=B29-B31

=(B29*C29-B31*C31)/B32

=B32*C32/$M$20

9

=B30-B34

=(B30*C30-B34*C34)/B33

=B33*C33/$M$20

10

=H21

=K21

=B34*C34/$M$20

11

=B31+B41

=(B31*C31+B41*C41)/B35

=B35*C35/$M$20

12

=G21

=J21

=B36*C36/$M$20

13

=B35-B36

=(B35*C35-B36*C36)/B37

=B37*C37/$M$20

14

=B34-B39

=(B34*C34-B39*C39)/B38

=B38*C38/$M$20

15

=100-A21

=(C25*B25-B40*C40)/B39

=B39*C39/$M$20

16

=A21

=D21

=B40*C40/$M$20

17

=G21-A21

=(G21*J21-A21*D21)/B41

=B41*C41/$M$20