Conversions: Difference between revisions
Jump to navigation
Jump to search
Scott Munro (talk | contribs) m (1 revision imported) |
md>Scott.Munro m (→References) |
||
Line 1: | Line 1: | ||
== Description == | == Description == | ||
This article describes methods for converting: | |||
* Weight fraction retained to cumulative fraction passing particle size distributions | |||
* Cumulative fraction passing to weight fraction 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 == | == Model theory == | ||
Line 42: | Line 47: | ||
{{Under construction|section}} | {{Under construction|section}} | ||
The interpolation methods may be invoked from the Excel formula bar with the following function calls: | |||
=== | <syntaxhighlight lang="vb">=mdConvert_RetToCumPass(Retained as Range)</syntaxhighlight> | ||
<syntaxhighlight lang="vb">=mdConvert_CumPassToRet(CumPassing as Range)</syntaxhighlight> | |||
<syntaxhighlight lang="vb">=mdConvert_ToMesh(Size1 as Range, Dist1 as Range, Size2 as Range, Optional axesScale as Integer = 0, Optional interpMethod as Integer = 0)</syntaxhighlight> | |||
<syntaxhighlight lang="vb">=mdConvert_ToGeoMeanSize(Size as Range)</syntaxhighlight> | |||
<syntaxhighlight lang="vb">=mdConvert_QvToQm(Qv as Double, wtFracSolids as Double, solidsSG as Double, Optional liquidsSG as Double = 1)</syntaxhighlight> | |||
{{Excel (Text, Help, No Arguments)}} | |||
== References == | == References == | ||
[[Category:Excel]] | [[Category:Excel]] | ||
Revision as of 03:38, 17 March 2023
Description
This article describes methods for converting:
- Weight fraction retained to cumulative fraction passing particle size distributions
- Cumulative fraction passing to weight fraction 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
This section is currently under construction. Please check back later for updates and revisions. |
Geometric mean size
The geometric mean size of a particle, (mm), is defined as:
where:
- is the index of the size interval,
- is the number of size intervals
- is the diameter of particles retained in a mesh at size interval (mm)
- the value of decreases as increases, i.e. , = top size,
Excel
This section is currently under construction. Please check back later for updates and revisions. |
The interpolation methods may be invoked from the Excel formula bar with the following function calls:
=mdConvert_RetToCumPass(Retained as Range)
=mdConvert_CumPassToRet(CumPassing as Range)
=mdConvert_ToMesh(Size1 as Range, Dist1 as Range, Size2 as Range, Optional axesScale as Integer = 0, Optional interpMethod as Integer = 0)
=mdConvert_ToGeoMeanSize(Size as Range)
=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.