SimSXCu Full Version 2.0

Joseph Kafumbila

Description

The metallurgists in the plant always make mass balance. These mass balances are always established on an Excel spreadsheet. In parallel, computer programs are used to verify the values obtained on the Excel spreadsheet. The existence of these computer programs is favored by the fact that metallurgists do not master programming using computer codes. Microsoft Excel Solver is an Excel add-in that allows you to create simulation programs ranging from simple mass balance to complex as a simulation program without the use of computer codes. SimSXCu Full version 2.0 is a simulation program of copper solvent extraction using the Microsoft Excel solver. Just read the text that comes with the SimSXCu Full 2.0 simulation program to learn how to use the Microsoft Excel solver.
Download the Excel format

Sujets

• Microsoft Excel
• Copper
• Liquid-liquid extraction
• Simulation modeling

Informations

• Publié par: josephkafumbila
• Publié le: 17 novembre 2016
• Nombre de lectures: 240
• Langue: English

Extrait

Joseph kafumbila
Process Designer

SimSXCu Full Version 2.0

©Copyright: 2016 joseph kafumbila
[e-mail]
https://www.linkedin.com/in/joseph-kafumbila-616a8936

SimSXCu – Full Version 2.0

Introduction

SimSXCu Full Version 2.0 is a program to simulate copper solvent extraction coniguration
as the extractant. The principle of this static simulation program is described in the public
"Simulation of Copper solvent extraction coniguration using Microsoft Excel solvers".

Click on the link
Simulation of copper solvent extraction coniguration using Microsoft Excel solver

The goal of this publication is to give a simple procedure for designing a static simulat
solvent extraction coniguration. This simple procedure will allow designers to quickly h
program for complex coniguration or new product that have not yet simulation program
It also will allow plant metallurgists to have a static simulation program for checking pla
static simulation program uses Excel solver program for optimization. Knowledge of the
not suficient. The book also gives advice that prevents static simulation programs to c
change. This textbook gives the upgrade of the equilibrium line simulation modelso
‘Design of copper solvent extraction conigurations’ and the experimental tests.

The speciicity of each option

Theoption "1"is the option which gives the optimum value of the extractant volume percen
organic phase when the values of the others parameters are known. It is used by designer

Theoption “2”is the option which gives the values of extractant volume percentage, satur
eficiencies when the values of the others parameters are known. It is used by plant metal

The concept of this simulation program is described in the publication called "LIX REAGE
coniguration. SimSXCu Full version applies this concept to all conigurations of copper so

Click on the link
LIX REAGENT

Use of simulation

SimSXCu Full version 2.0 gives the simulation program of the 18 exiting conigurations of
extraction. Each copper solvent extraction coniguration is designated by the alphabetical
coniguration, there are two options on two Excel worksheets. For each option, there is ag
the option on the following worksheet .
On each worksheet (option and option graph), there is a Excel solver program already est

The exiting conigurations of coppe solvent extraction are:

A - Series 2Ex1S
B - Series 2Ex2S
C - Series 3Ex1S
D - Series 3Ex2S
E - Series parallel 2Ex1Px1S
F - Series parallel 2Ex1Px2S
G - Optimum series parallel 1Ex1Px1Ex1S
H - Optimum series parallel 1Ex1Px1Ex2S
I - Triple parallel 1Ex1Px1Px1S
J - Triple parallel 1Ex1Px1Px2S
K - Interlaced 1Ex1Px1Ex1Px1S
L - Interlaced 1Ex1Px1Ex1Px2S
M - Double series parallel 2Ex2Px1S
N - Doubles series parallel 2Ex2Px2S
O - Optimum triple parallel 1Ex1Px1Px1Ex1S
P - Optimum triple parallel 1Ex1Px1Px1Ex2S
Q - Organic by pass 2Ex2Px1S
R - Organic by pass 2Ex2Px2S

You can design yourself for the others conigurations following the procedure described in
"simulation of copper solvent extraction coniguration using Microsoft Excel solver"

Option 1

On the option 1 Excel worksheet, the user can only changes data having red color
color are the solver variables and data having green color are the solver constrain

v/v% : extractant volume percentage in the organic phase
AML : Maximum loaded when the free acid concentration in the PLS is zero
ML : Maximum loaded - value of copper concentration in the organic phase in steady state w
SR : saturation ratio - ratio of loaded organic (LO) to Maximum loaded (ML) - this value is
PLS : Pregnant leach solution
O/A : Ratio of organic low to aqueous low
Mixer Ef : mixer eficiency

When the red color data are completed

On the ‘Data’, in the ‘Analysis group’ clicksolver (ifthe solver command is not availa
the solver add-in).Click ‘Solve’. To keep the solution values on the worksheet, in the ‘Solv
click ‘Keep solver solution’. the results of solver give the optimum value of extractant volu

The user will moves to the option 1 graph Excel worksheet.

On the ‘Data’, in the ‘Analysis group’ clicksolver (ifthe solver command is not availa
the solver add-in).Click ‘Solve’. To keep the solution values on the worksheet, in the ‘Solv
click ‘Keep solver solution’. The results of solver give the graph of the option 1

Option 2

On the option 2 Excel worksheet, the user can only changes data having red color
color are the solver variables and data having green color are the solver constrain

The value of maximum loaded (ML) comes from the plant lab and the values of othersp
the plant.
When the red color data are completed

On the ‘Data’, in the ‘Analysis group’ clicksolver (ifthe solver command is not availa
the solver add-in).Click ‘Solve’. To keep the solution values on the worksheet, in the ‘Solv
click ‘Keep solver solution’. The results of solver give plant parameters

The user will moves to the option 2 graph Excel worksheet.

On the ‘Data’, in the ‘Analysis group’ clicksolver (ifthe solver command is not availa
the solver add-in).Click ‘Solve’. To keep the solution values on the worksheet, in the ‘Solv
click ‘Keep solver solution’. the results of solver give the graph of the option 2

© Copyright: 2016 Joseph Kafumbila

PLS low
PLS Cu
PLS Ac
SR
Ratio O/A Ext
Mef1e
Mef2e
ML
C1Cuor Ext
C2Cuor Ext
SP Cu
SPAc
AD Cu
Mef1s
Ratio O/A str
C1Cuor Str
Set objective

400
2.5
1.60
92
1
92
95

4.141
2.879
30
190
50
98

1.737

0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000
0.000

Extractant
V/V%
AML
ML
Saturation ratio (LO/ML)
Extraction recovery
Stripping recovery
Net transfer

PLS
low
Cu
Acid

400
2.50
1.60

Loaded Organic
low 400.00
Cu 4.036

3
m /h
g/l
g/l

3
m /h
g/l Cu

Lix984N
8.66%
4.417 g/lCu
4.386g/l Cu
92.00%
90.09 %
55.81 %
0.26 g/lper 1%

Advance electrolyte
Cu50.00