E1-16 |
E1-3 |
E1-7 |
E1-12 |
E1-10 |
E1-4 |
=F2*(G2)^3*((1-H2)^2+H2*(1-H2)+(H2)^2)/(F2*(G2)^3*((1-H2)^2+H2*(1-H2)+(H2)^2)+(1-F2)*(1-H2)^2*((1-G2)^3+G2*(1-G2)^2+(G2)^3)) |
|||||
=F3*(G3)^3*((1-H3)^2+H3*(1-H3)+(H3)^2)/(F3*(G3)^3*((1-H3)^2+H3*(1-H3)+(H3)^2)+(1-F3)*(1-H3)^2*((1-G3)^3+G3*(1-G3)^2+(G3)^3)) |
=I3/(G3)^3 |
=I3/G3^2 |
=I3/G3 |
=I3*(1-F3)*H3/(G3^3*F3) |
=I3*(1-F3)*(1-H3)*H3/(G3^3*F3) |
=F4*(G4)^3*((1-H4)^2+H4*(1-H4)+(H4)^2)/(F4*(G4)^3*((1-H4)^2+H4*(1-H4)+(H4)^2)+(1-F4)*(1-H4)^2*((1-G4)^3+G4*(1-G4)^2+(G4)^3)) |
=I4/(G4)^3 |
=I4/G4^2 |
=I4/G4 |
=I4*(1-F4)*H4/(G4^3*F4) |
=I4*(1-F4)*(1-H4)*H4/(G4^3*F4) |
=F5*(G5)^3*((1-H5)^2+H5*(1-H5)+(H5)^2)/(F5*(G5)^3*((1-H5)^2+H5*(1-H5)+(H5)^2)+(1-F5)*(1-H5)^2*((1-G5)^3+G5*(1-G5)^2+(G5)^3)) |
=I5/(G5)^3 |
=I5/G5^2 |
=I5/G5 |
=I5*(1-F5)*H5/(G5^3*F5) |
=I5*(1-F5)*(1-H5)*H5/(G5^3*F5) |
=F6*(G6)^3*((1-H6)^2+H6*(1-H6)+(H6)^2)/(F6*(G6)^3*((1-H6)^2+H6*(1-H6)+(H6)^2)+(1-F6)*(1-H6)^2*((1-G6)^3+G6*(1-G6)^2+(G6)^3)) |
=I6/(G6)^3 |
=I6/G6^2 |
=I6/G6 |
=I6*(1-F6)*H6/(G6^3*F6) |
=I6*(1-F6)*(1-H6)*H6/(G6^3*F6) |
=F7*(G7)^3*((1-H7)^2+H7*(1-H7)+(H7)^2)/(F7*(G7)^3*((1-H7)^2+H7*(1-H7)+(H7)^2)+(1-F7)*(1-H7)^2*((1-G7)^3+G7*(1-G7)^2+(G7)^3)) |
=I7/(G7)^3 |
=I7/G7^2 |
=I7/G7 |
=I7*(1-F7)*H7/(G7^3*F7) |
=I7*(1-F7)*(1-H7)*H7/(G7^3*F7) |
=F8*(G8)^3*((1-H8)^2+H8*(1-H8)+(H8)^2)/(F8*(G8)^3*((1-H8)^2+H8*(1-H8)+(H8)^2)+(1-F8)*(1-H8)^2*((1-G8)^3+G8*(1-G8)^2+(G8)^3)) |
=I8/(G8)^3 |
=I8/G8^2 |
=I8/G8 |
=I8*(1-F8)*H8/(G8^3*F8) |
=I8*(1-F8)*(1-H8)*H8/(G8^3*F8) |
=F9*(G9)^3*((1-H9)^2+H9*(1-H9)+(H9)^2)/(F9*(G9)^3*((1-H9)^2+H9*(1-H9)+(H9)^2)+(1-F9)*(1-H9)^2*((1-G9)^3+G9*(1-G9)^2+(G9)^3)) |
=I9/(G9)^3 |
=I9/G9^2 |
=I9/G9 |
=I9*(1-F9)*H9/(G9^3*F9) |
=I9*(1-F9)*(1-H9)*H9/(G9^3*F9) |
Таблица 2
Формулы для расчета технологических показателей флотационной схемы
Вых16 |
Вых3 |
Вых7 |
Сод16 |
Сод3 |
Сод7 |
Вых12 |
Вых10 |
=(I2*D2*C2) |
=J2*D2*C2 |
=K2*D2*C2 |
=I2*D2*E2*C2 |
=J2*D2*E2*C2 |
=K2*D2*E2*C2 |
=L2*D2*C2 |
0,86 |
=(I3*D3*C3) |
=J3*D3*C3 |
=K3*D3*C3 |
=I3*D3*E3*C3 |
=J3*D3*E3*C3 |
=K3*D3*E3*C3 |
=L3*D3*C3 |
=M3*D3*C3 |
=(I4*D4*C4) |
=J4*D4*C4 |
=K4*D4*C4 |
=I4*D4*E4*C4 |
=J4*D4*E4*C4 |
=K4*D4*E4*C4 |
=L4*D4*C4 |
=M4*D4*C4 |
=(I5*D5*C5) |
=J5*D5*C5 |
=K5*D5*C5 |
=I5*D5*E5*C5 |
=J5*D5*E5*C5 |
=K5*D5*E5*C5 |
=L5*D5*C5 |
=M5*D5*C5 |
=(I6*D6*C6) |
=J6*D6*C6 |
=K6*D6*C6 |
=I6*D6*E6*C6 |
=J6*D6*E6*C6 |
=K6*D6*E6*C6 |
=L6*D6*C6 |
=M6*D6*C6 |
=(I7*D7*C7) |
=J7*D7*C7 |
=K7*D7*C7 |
=I7*D7*E7*C7 |
=J7*D7*E7*C7 |
=K7*D7*E7*C7 |
=L7*D7*C7 |
=M7*D7*C7 |
=(I8*D8*C8) |
=J8*D8*C8 |
=K8*D8*C8 |
=I8*D8*E8*C8 |
=J8*D8*E8*C8 |
=K8*D8*E8*C8 |
=L8*D8*C8 |
=M8*D8*C8 |
=(I9*D9*C9) |
=J9*D9*C9 |
=K9*D9*C9 |
=I9*D9*E9*C9 |
=J9*D9*E9*C9 |
=K9*D9*E9*C9 |
=L9*D9*C9 |
=M9*D9*C9 |
=СУММ(A12:A19) |
=СУММ(B12:B19) |
=СУММ(C12:C19) |
=СУММ(D12:D19) |
=СУММ(E12:E19) |
=СУММ(F12:F19) |
=СУММ(G12:G19) |
=СУММ(H12:H19) |
=A20*100 |
=B20*100 |
=C20*100 |
=D20/A20 |
=E20/B20 |
=F20/C20 |
=G20*100 |
=H20*100 |
Продолжение таблицы 2
Уважаемый посетитель!
Чтобы распечатать файл, скачайте его (в формате Word).
Ссылка на скачивание - внизу страницы.