Mass Balancing (Three-Product Formula): Difference between revisions
Jump to navigation
Jump to search
(Migrate protected Model Theory content) |
imported>Scott.Munro m (→Excel) |
||
| Line 1: | Line 1: | ||
== Description == | == Description == | ||
This article describes the | 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 == | == Model theory == | ||
| Line 13: | Line 13: | ||
The three-product formula may be invoked from the Excel formula bar with the following function call: | The three-product formula may be invoked from the Excel formula bar with the following function call: | ||
<syntaxhighlight lang="vb">= | <syntaxhighlight lang="vb">=mdMassBal_ThreeProductFormula(Assay as Range)</syntaxhighlight> | ||
{{Excel (Text, Help, No Arguments)}} | {{Excel (Text, Help, No Arguments)}} | ||
| Line 27: | Line 27: | ||
:<math> | :<math> | ||
\begin{align} | \begin{align} | ||
\mathit{ | \mathit{Assays} & = | ||
\begin{bmatrix} | \begin{bmatrix} | ||
f_A & f_B\\ | |||
c_A & c_B\\ | |||
m_A & m_B\\ | |||
t_A & t_B\\ | |||
\end{bmatrix}\\ | \end{bmatrix}\\ | ||
\\ | \\ | ||
| Line 42: | Line 42: | ||
\begin{bmatrix} | \begin{bmatrix} | ||
S_C\text{ (frac)} & (R_A)_C\text{ (frac)} & (R_B)_C\text{ (frac)}\\ | S_C\text{ (frac)} & (R_A)_C\text{ (frac)} & (R_B)_C\text{ (frac)}\\ | ||
S_M\text{ (frac)} & ( | S_M\text{ (frac)} & (R_A)_M\text{ (frac)} & (R_B)_M\text{ (frac)}\\ | ||
\end{bmatrix} | \end{bmatrix} | ||
\end{align} | \end{align} | ||
Latest revision as of 06:53, 22 October 2026
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
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:
|
| ||||
