Mass Balancing (Three-Product Formula)

From Met Dynamics
Revision as of 06:53, 22 October 2026 by imported>Scott.Munro (→‎Excel)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Description

This article describes the three-product mass balance used to estimate the mass yields and component recoveries of two products and a tailings stream from feed and product assays of two components.

Model theory

Nuvola apps important blue.svg.png This content is available to registered users. Please log in to view.

Excel

The three-product formula may be invoked from the Excel formula bar with the following function call:

=mdMassBal_ThreeProductFormula(Assay as Range)

Invoking the function with no arguments will print Help text associated with the model, including a link to this page.

The input parameters and calculation results are defined below in matrix notation, along with an example image showing the selection of the same cells and arrays in the Excel interface:

[math]\displaystyle{ \begin{align} \mathit{Assays} & = \begin{bmatrix} f_A & f_B\\ c_A & c_B\\ m_A & m_B\\ t_A & t_B\\ \end{bmatrix}\\ \\ \end{align} }[/math]
[math]\displaystyle{ \begin{align} \mathit{mdMassBal\_ThreeProductFormula} & = \begin{bmatrix} S_C\text{ (frac)} & (R_A)_C\text{ (frac)} & (R_B)_C\text{ (frac)}\\ S_M\text{ (frac)} & (R_A)_M\text{ (frac)} & (R_B)_M\text{ (frac)}\\ \end{bmatrix} \end{align} }[/math]
Figure 1. Example showing the selection of the Assay (blue frame) and Results (light blue frame) arrays in Excel.

See also

References