Mass Balancing using Excel Solver

Excel Solver is applied to a fundamental nonlinear optimisation problem (mass balancing in mineral processing).

Created by: Stephen Rayward
Principal, Midas Tech International

What Will I Learn?

• To learn how to use Excel Solver.
• Learn how to mass balance mineral processing data using Microsoft Excel.
• Understand the mass balance problem in mineral processing.
• Use a conventional approach e.g. Least Squares Minimisation to solve a mass balance problem.
• Understand the advantages and disadvantages of using Excel Solver.
• Apply Excel Solver to mass balance problems.
• Apply mass balance extensions in the context of using Excel Solver.

Requirements

• Be familiar with Microsoft Excel. No formal prerequisites necessary.
• Have strong enough mathematical understanding to be aware of what is meant by an optimisation problem.
• The mass balance problem is a straightforward problem – and should be understandable regardless of whether one has familiarity with mineral processing or chemical engineering.

Target audience

• The main target audience is mineral processors.
• Chemical Engineers are also encouraged to enrol in course.
• Anyone involved in optimisation wishing to learn Excel Solver is encouraged to enrol.