Conversions

Description

This article describes methods for converting:

• Quantity or fraction retained to cumulative quantity or fraction passing particle size distributions
• Cumulative quantity passing to quantity retained particle size distributions
• Particle size distributions between different mesh series
• Particle size distribution mesh interval sizes to geometric mean sizes
• Volumetric flow rates of slurry to mass flow rates of solids and liquids

Model theory

Retained to cumulative passing

A distribution of quantity retained on a mesh series is converted to a cumulative quantity passing the same series by the following relation:

$P_{i}=\sum _{j=1}^{n}p_{j}-\sum _{k=1}^{i}p_{k}\;\;\;\;{\text{ for }}i=1,\dots ,n$

where:

• $n$ is the number of size intervals
• $i$ is the index of the size interval, $i=\{1,2,\dots ,n\}$
• $P_{i}$ is the cumulative quantity passing size interval $i$
• $p_{i}$ is the quantity retained on size interval $i$

Similarly, a cumulative distribution of fraction passing a mesh series may be obtained from quantity retained data by:

$(P_{\rm {n}})_{i}=1.0-{\dfrac {\sum _{k=1}^{i}p_{k}}{\sum _{j=1}^{n}p_{j}}}\;\;\;\;{\text{ for }}i=1,\dots ,n$

where $(P_{\rm {n}})_{i}$ is the normalised cumulative quantity passing size interval $i$.

Cumulative passing to retained

A cumulative quantity passing distribution is converted to a quantity retained distribution by the following relation:

$p_{i}={\begin{cases}\sum \limits _{j=1}^{n}p_{j}-P_{i}&i=1\\P_{i-1}-P_{i}&1<i\leq n\end{cases}}$

where:

• $n$ is the number of size intervals
• $i$ is the index of the size interval, $i=\{1,2,\dots ,n\}$
• $P_{i}$ is the cumulative quantity passing size interval $i$
• $p_{i}$ is the quantity retained on size interval $i$

Similarly, a fraction retained distribution may be obtained from cumulative quantity passing data by:

$(p_{\rm {n}})_{i}={\begin{cases}1.0-{\dfrac {P_{i}}{\sum \limits _{j=1}^{n}p_{j}}}&i=1\\{\dfrac {P_{i-1}-P_{i}}{\sum \limits _{j=1}^{n}p_{j}}}&1<i\leq n\end{cases}}$

where $(p_{\rm {n}})_{i}$ is the normalised quantity (i.e. fraction) retained on size interval $i$.

Convert between meshes

Given a discrete quantity retained distribution $(p_{1})_{i}$ on size interval series $(d_{1})_{i}$, where $i=1,\dots ,n$ and $n$ is the number of size intervals of distribution 1, the quantity retained distribution $(p_{2})_{j}$ on size interval series $(d_{2})_{j}$, where $j=1,\dots ,m$ and $m$ is the number of size intervals of distribution 2, can be obtained from the following procedure:

1. Convert quantity retained distribution $(p_{1})_{i}$ to cumulative quantity passing distribution $(P_{1})_{i}$
2. Compute the cumulative quantity passing distribution $(P_{2})_{j}$ on size interval series $(d_{2})_{j}$ using an interpolation method with $(P_{1})_{i}$ and $(d_{1})_{i}$
3. Convert cumulative quantity passing distribution $(P_{2})_{j}$ back to the quantity retained distribution $(p_{2})_{j}$

Either linear interpolation or cubic spline interpolation methods may be applied to the above procedure.

Furthermore, both the size intervals ($d_{1}$, $d_{2}$) and cumulative quantity passing ($P_{1}$, $P_{2}$) distributions may be converted to logarithmic scales prior to interpolation, should this provide a better quality mesh conversion for a given application.

Geometric mean size

The geometric mean size of a particle, ${\bar {d}}_{i}$ (mm), is defined as:

${\bar {d}}_{i}={\begin{cases}{\sqrt {2}}d_{1}&i=1\\\\{\sqrt {d_{i}d_{i-1}}}&1<i<n\\\\0.5d_{n-1}&i=n\\\end{cases}}$

where:

• $i$ is the index of the size interval, $i=\{1,2,\dots ,n\}$
• $n$ is the number of size intervals
• $d_{i}$ is the diameter of particles retained in a mesh at size interval $i$ (mm)
• the value of $d_{i}$ decreases as $i$ increases, i.e. $d_{i}>d_{i+1}$, $d_{1}$ = top size, $d_{n}=0$

Slurry volume flow to mass flow

The mass flow rates of solids, $(Q_{\rm {M}})_{\rm {S}}$ (t/h), and liquids, $(Q_{\rm {M}})_{\rm {L}}$ (t/h), in a stream may be computed from:

• The volumetric flow rate of slurry, $Q_{\rm {V}}$ (m³/h),
• The specific gravity of solids, $\rho _{\rm {S}}$ (t/m³),
• The specific gravity of liquids, $\rho _{\rm {L}}$ (t/m³), and
• The mass fraction of solids, $C_{\rm {W}}$ (w/w)

with:

$(Q_{\rm {M}})_{\rm {S}}={\dfrac {Q_{\rm {V}}}{\left({\dfrac {1}{\rho _{\rm {S}}}}+{\dfrac {1-C_{\rm {W}}}{C_{\rm {W}}\rho _{\rm {L}}}}\right)}}$

$(Q_{\rm {M}})_{\rm {L}}=Q_{\rm {M,S}}\left({\dfrac {1-C_{\rm {W}}}{C_{\rm {W}}}}\right)$

Excel

Retained to cumulative passing

The retained to cumulative passing method may be invoked from the Excel formula bar with the following function calls:

=mdConvert_RetToCumPass(Retained as Range, Optional returnAsFraction Bool = 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 an example image showing the selection of the same cells and arrays in the Excel interface:

${\begin{aligned}{\mathit {Retained}}={\begin{bmatrix}p_{1}\\\vdots \\p_{n}\\\end{bmatrix}},\;\;\;\;\end{aligned}}$ ${\begin{aligned}{\mathit {mdConvert\_RetToCumPass}}&={\begin{bmatrix}P_{1}\\\vdots \\P_{n}\\\end{bmatrix}}\\\end{aligned}}$ where: $n$ is the number of data points $p$ is the quantity retained on size interval $i$ ($1\leq i\leq n$) $P$ is the cumulative quantity passing size interval $i$ ${\mathit {returnAsFraction}}$ is an optional flag that indicates whether to return the fraction passing instead of the quantity, (True/False)

Figure 1. Example showing the selection of the Retained (blue frame) and Results (light blue frame) arrays in Excel.

Cumulative passing to retained

The cumulative passing to retained method may be invoked from the Excel formula bar with the following function calls:

=mdConvert_CumPassToRet(CumPassing 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:

${\begin{aligned}{\mathit {CumPassing}}={\begin{bmatrix}P_{1}\\\vdots \\P_{n}\\\end{bmatrix}},\;\;\;\;\end{aligned}}$ ${\begin{aligned}{\mathit {mdConvert\_CumPassToRet}}&={\begin{bmatrix}p_{1}\\\vdots \\p_{n}\\\end{bmatrix}}\\\end{aligned}}$ where: $n$ is the number of data points $p$ is the quantity retained on size interval $i$ ($1\leq i\leq n$) $P$ is the cumulative quantity passing size interval $i$

Figure 2. Example showing the selection of the CumPassing (blue frame) and Results (light blue frame) arrays in Excel.

Convert between meshes

The convert between meshes method may be invoked from the Excel formula bar with the following function calls:

=mdConvert_ToMesh(Size1 as Range, Dist1 as Range, Size2 as Range, Optional axesScale as Integer = 0, Optional interpMethod as Integer = 0)

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:

${\begin{aligned}{\mathit {Size1}}&={\begin{bmatrix}(d_{1})_{1}{\text{ (mm)}}\\\vdots \\(d_{1})_{n}{\text{ (mm)}}\\\end{bmatrix}}\\\\{\mathit {Dist1}}&={\begin{bmatrix}(p_{1})_{1}\\\vdots \\(p_{1})_{n}\\\end{bmatrix}}\\\\{\mathit {Size2}}&={\begin{bmatrix}(d_{2})_{1}{\text{ (mm)}}\\\vdots \\(d_{2})_{m}{\text{ (mm)}}\\\end{bmatrix}}\\\\{\mathit {axesScale}}&={\big [}{\text{(0, 1 or 2)}}{\big ]}\\\\{\mathit {interpMethod}}&={\big [}{\text{(0 or 1)}}{\big ]}\\\end{aligned}}$ ${\begin{aligned}{\mathit {mdConvert\_ToMesh}}&={\begin{bmatrix}(p_{2})_{1}\\\vdots \\(p_{2})_{m}\\\end{bmatrix}}\\\end{aligned}}$ where: $n$ is the number of data points in the first size distribution $m$ is the number of data points in the second size distribution $d_{i}$ is the size of the square mesh interval that feed mass is retained on (mm) $d_{i+1}<d_{i}<d_{i-1}$, i.e. descending size order from top size ($d_{1}$) to sub mesh ($d_{n}=0$ mm) $p$ is the quantity retained on a size interval ${\mathit {axesScale}}$ selects which scaling method to apply to the axes during interpolation: 0 = linear (x) and linear (y) (default if omitted) 1 = log (x) and linear (y) 2 = log (x) and log (y) ${\mathit {interpMethod}}$ selects which interpolation method to apply to the distribution during conversion: 0 = linear interpolation (default if omitted) 1 = cubic spline interpolation

Figure 3. Example showing the selection of the Size1 (blue frame), Dist1 (red frame), Size2 (purple frame) and Results (light blue frame) arrays in Excel.

Geometric mean size

The geometric mean size method may be invoked from the Excel formula bar with the following function calls:

=mdConvert_ToGeoMeanSize(Size 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:

${\begin{aligned}{\mathit {Size}}={\begin{bmatrix}d_{1}{\text{ (mm)}}\\\vdots \\d_{n}{\text{ (mm)}}\\\end{bmatrix}}\end{aligned}}$ ${\begin{aligned}{\mathit {mdConvert\_ToGeoMeanSize}}&={\begin{bmatrix}{\bar {d}}_{1}\\\vdots \\{\bar {d}}_{n}\\\end{bmatrix}}\end{aligned}}$ $n$ is the number of data points in the first size distribution $d_{i}$ is the size of the square mesh interval that feed mass is retained on (mm) $d_{i+1}<d_{i}<d_{i-1}$, i.e. descending size order from top size ($d_{1}$) to sub mesh ($d_{n}=0$ mm) ${\bar {d}}_{i}$ is the geometric mean size of the internal mesh series interval that mass is retained on (mm)

Figure 4. Example showing the selection of the Size (blue frame) and Results (light blue frame) arrays in Excel.

Slurry volume flow to mass flow

The slurry volume flow to mass flow method may be invoked from the Excel formula bar with the following function calls:

=mdConvert_QvToQm(Qv as Double, wtFracSolids as Double, solidsSG as Double, Optional liquidsSG as Double = 1)

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:

${\begin{aligned}{\mathit {Qv}}&={\big [}Q_{\rm {V}}{\text{ (m}}^{3}{\text{/h)}}{\big ]}\\\\{\mathit {wtFracSolids}}&={\big [}C_{\rm {W}}{\text{ (w/w)}}{\big ]}\\\\{\mathit {solidsSG}}&={\big [}\rho _{\rm {S}}{\text{ (t/m}}^{3}{\text{)}}{\big ]}\\\\{\mathit {liquidsSG}}&={\big [}\rho _{\rm {L}}{\text{ (t/m}}^{3}{\text{)}}{\big ]}\\\end{aligned}}$ ${\begin{aligned}{\mathit {mdConvert\_QvToQm}}&={\begin{bmatrix}(Q_{\rm {M}})_{\rm {S}}\\(Q_{\rm {M}})_{\rm {L}}\\\end{bmatrix}}\\\end{aligned}}$ where: $Q_{\rm {V}}$ is the volumetric flow rate of slurry (m3/h) $C_{\rm {W}}$ is the mass fraction of solids in the slurry (w/w) $\rho _{\rm {S}}$ is the density of solids (t/m3) $\rho _{\rm {L}}$ is the density of liquids (t/m3), default is 1.0 t/m3 if omitted $(Q_{\rm {M}})_{\rm {S}}$ is the mass flow rate of solids in the slurry (t/h) $(Q_{\rm {M}})_{\rm {L}}$ is the mass flow rate of liquids in the slurry (t/h)

Figure 5. Example showing the selection of the Qv (shaded blue frame), wtFracSolids (shaded red frame), solidsSG (shaded purple frame), liquidsSG (shaded green frame), and Results (light blue frame) arrays in Excel.