Mass Balancing (Two-Product Formula): Difference between revisions

From Met Dynamics
Jump to navigation Jump to search
imported>Scott.Munro
mNo edit summary
 
imported>Scott.Munro
 
Line 5: Line 5:
== Model theory ==
== Model theory ==


{{Restricted content}}
<hide>
The two-product formula estimates the mass flow split of solids and the recovery of a single assayed component from a process step with one feed and two product streams.{{Wills and Napier-Munn (2005)}}
The two-product formula estimates the mass flow split of solids and the recovery of a single assayed component from a process step with one feed and two product streams.{{Wills and Napier-Munn (2005)}}


Line 39: Line 42:


Mineral compositions, particle size distributions and water fractions can be substituted in place of metal assays in the formula.
Mineral compositions, particle size distributions and water fractions can be substituted in place of metal assays in the formula.
</hide>


== Excel ==
== Excel ==

Latest revision as of 11:38, 4 December 2024

Description

This article describes the classical two-product formula for estimating the separation efficiency of a process.

Model theory

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

Excel

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

=mdMassBal_TwoProductFormula(Assay as Range, Optional AbsSD 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:

where is an optional input and the standard deviation error estimates (, ) are not returned if omitted.

Figure 1. Example showing the selection of the Assay (blue frame), AbsSD (red frame), and Results (light blue frame) arrays in Excel.

See also

References