Mass Balancing (n-Product Formula)

Description

This article describes a methodology for estimating the solids mass split and recovery of multiple assayed components from a process step with any number of product streams.

Model theory

This content is available to registered users. Please log in to view.

Excel

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

=mdMassBal_nProductFormula(Assays as Range, Optional AbsSD as Range, Optional Transposed as Boolean = False)

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 example images showing the selection of the same cells and arrays in the Excel interface.

Default

The following default arrangement of inputs and results ranges apply when the formula argument Transposed is false or omitted:

${\begin{aligned}{\mathit {Assay}}&={\begin{bmatrix}f_{1}&\cdots &f_{m}\\p_{11}&\cdots &p_{m1}\\\vdots &\ddots &\vdots \\p_{1n}&\cdots &p_{mn}\\\end{bmatrix}}\\\\{\mathit {AbsSD}}&={\begin{bmatrix}\sigma _{\rm {f1}}&\cdots &\sigma _{{\rm {f}}m}\\\sigma _{11}&\cdots &\sigma _{m1}\\\vdots &\ddots &\vdots \\\sigma _{1n}&\cdots &\sigma _{mn}\\\end{bmatrix}}\\\end{aligned}}$ ${\begin{aligned}{\mathit {mdMassBal\_nProductFormula}}&={\begin{bmatrix}\beta _{\rm {f}}{\text{ (frac)}}&{\hat {f}}_{1}{\text{ (frac)}}&\cdots &{\hat {f}}_{m}{\text{ (frac)}}\\\beta _{1}{\text{ (frac)}}&R_{11}{\text{ (frac)}}&\cdots &R_{m1}{\text{ (frac)}}\\\vdots &\vdots &\ddots &\vdots \\\beta _{n}{\text{ (frac)}}&R_{1n}{\text{ (frac)}}&\cdots &R_{mn}{\text{ (frac)}}\\\end{bmatrix}}\end{aligned}}$ where: $\beta _{\rm {f}}$ is total mass fraction of solids in the feed (frac), i.e. $\beta _{\rm {f}}=\sum \nolimits _{i}^{n}{\beta _{i}}=1$ the unweighted sum of squares approach is used if $AbsSD$ is omitted.

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

Transposed

The following arrangement of inputs and results ranges apply when the formula argument Transposed is true:

${\begin{aligned}{\mathit {Assay}}&={\begin{bmatrix}f_{1}&p_{11}&\cdots &p_{1n}\\\vdots &\vdots &\ddots \\f_{m}&p_{1m}&\cdots &p_{mn}\\\end{bmatrix}}\\\\{\mathit {AbsSD}}&={\begin{bmatrix}\sigma _{{\rm {f}}1}&\sigma _{11}&\cdots &\sigma _{1n}\\\vdots &\vdots &\ddots \\\sigma _{{\rm {f}}m}&\sigma _{1m}&\cdots &\sigma _{mn}\\\end{bmatrix}}\\\end{aligned}}$ ${\begin{aligned}{\mathit {mdMassBal\_nProductFormula}}&={\begin{bmatrix}\beta _{\rm {f}}{\text{ (frac)}}&\beta _{1}{\text{ (frac)}}&\cdots &\beta _{n}{\text{ (frac)}}\\{\hat {f}}_{1}{\text{ (frac)}}&R_{11}{\text{ (frac)}}&\cdots &R_{1n}{\text{ (frac)}}\\\vdots &\vdots &\ddots &\vdots \\{\hat {f}}_{m}{\text{ (frac)}}&R_{m1}{\text{ (frac)}}&\cdots &R_{mn}{\text{ (frac)}}\\\end{bmatrix}}\end{aligned}}$

Figure 2. Example showing the selection of the Assay (blue frame), AbsSD (red frame), and Results (light blue frame) arrays in Excel when ${\mathit {Transposed}}=\mathrm {True}$.

See also

• Mass Balancing (Two-Product Formula)
• Mass Balancing (Three-Product Formula)