Release Notes
Jump to navigation
Jump to search
Description
This article describes the tools, functions and models available in the current release of mdModels2 v2.0.0 Beta (21 December 2022).
For incremental changes, additions and improvements since the initial release of v2.0.0, please see Revision History.
Functionality
The table below outlines the functionality available in the Met Dynamics Microsoft Excel XLL Add-In and Met Dynamics SysCAD Integrated Library interfaces.
For more information about SysCAD, please visit the SysCAD website.
| Excel Formula Name | SysCAD Unit | Description | Help |
|---|---|---|---|
| mdProps_MW | Returns molecular weight of Formula (e.g. "H2O") | ||
| mdProps_BulkDensity_Evertsson | Returns the bulk density or packing fraction (v/v) of a polydisperse particulate stream using the Evertsson method | ||
| mdMineralogy_EMC | Element-to-Mineral Conversion. Returns the modal mineral composition of a sample with a given assay, least squares method | ||
| mdConvert_RetToCumPass | Converts quantity retained per interval to cumulative quantity passing | ||
| mdConvert_CumPassToRet | Converts to cumulative quantity passing to quantity retained per interval | ||
| mdConvert_ToMesh | Converts quantity retained distribution Dist1 from mesh (sieve) series Size1 to mesh series Size2, using linear (default) or cubic spline interpolation in linear-linear (default), log-linear or log-log scales | ||
| mdConvert_ToGeoMeanSize | Converts mesh (sieve) series Size to its geometric mean size equivalent | ||
| mdConvert_QvToQm | Converts a slurry stream volumetric flow rate to mass flowrate of solids and liquids | ||
| mdInterp_Linear | Linear interpolation | ||
| mdInterp_CubicSpline | Cubic spline interpolation, with linear extrapolation at extents | ||
| mdDist_GaudinSchuhmann | Returns Gaudin-Schuhmann cumulative fraction passing size distribution | ||
| mdDist_RosinRammler | Returns Rosin-Rammler cumulative fraction passing size distribution | ||
| mdDist_Swebrec | Returns Swebrec (3 or 5 parameter) cumulative fraction passing size distribution | ||
| mdPartition_WhitenBeta | Returns partition to overflow calculated by Whiten-Beta equation | Partitions | |
| mdPartition_WhitenWhite | Returns partition to oversize calculated by Whiten & White equation, with additions by Dehghani (2002) and Firth (2008) | Partitions | |
| mdPartition_Pivot | Returns partition to sinks calculated by Pivot model equation | ||
| mdPartition_StochasticRao | Returns partition to sinks calculated by Stochastic model equation (Rao, 2021) | ||
| mdSolLiq_Thickener_WilhelmNaide_UA | Returns Thickener Unit Area (L^2/(M/T)) for given underflow solids concentration (M/L^3), Wilhelm & Naide equation (1981) | ||
| mdSolLiq_Thickener_WilhelmNaide_Cs | Returns Thickener underflow solids concentration (M/L^3) for a given Unit Area (L^2/(M/T)), Wilhelm & Naide equation (1981) | ||
| mdMillSpeed_RPM | Returns tumbling mill rotational speed (rpm) | Tumbling Mill (Speed) | |
| mdMillSpeed_FracCS | Returns tumbling mill fraction critical speed (frac) | Tumbling Mill (Speed) | |
| mdMillPower_BondWI | Returns rod or ball mill power, Bond Work Index method | ||
| mdMillPower_HoggFuerstenau | Met Dynamics: Mill | Returns tumbling mill power, Hogg & Fuerstenau method | Tumbling Mill (Power, Hogg and Fuerstenau) |
| mdMillPower_MorrellE | Met Dynamics: Mill | Returns tumbling mill power, Morrell Empirical method | Tumbling Mill (Power, Morrell Empirical) |
| mdMillPower_MorrellC | Met Dynamics: Mill | Returns tumbling mill power, Morrell Continuum method | Tumbling Mill (Power, Morrell Continuum) |
| mdMillPower_MorrellD | Met Dynamics: Mill | Returns tumbling mill power, Morrell Discrete Shell method | Tumbling Mill (Power, Morrell Discrete Shell) |
| mdMillPower_HildenPowell | Met Dynamics: Mill | Returns tumbling mill power, Hilden & Powell (2018) method | Tumbling Mill (Power, Hilden and Powell) |
| mdMillPower_Nitta | Met Dynamics: Mill | Returns vertical stirred mill power, Nitta method | Stirred Mill (Power, Nitta) |
| mdMillPower_Heath | Returns High Intensity Grinding (HIG) mill power, Heath (2017) method | ||
| mdMillSlurryFlow_MorrellStephenson | Returns discharge flow rate of slurry (<xm + water) from a tumbling mill grate | Tumbling Mill (Slurry Flow) | |
| mdMillMediaTrajectory | Met Dynamics: Mill | Computes the trajectory of a media element in a tumbling mill, Powell method | Tumbling Mill (Media Trajectory) |
| mdMillOverfilling_Arbiter | Met Dynamics: Mill | Returns flow limits for an overflow discharge tumbling mill, Arbiter (1990) method | Ball Mill (Overfilling) |
| mdMillOverfilling_Shi | Met Dynamics: Mill | Returns slurry residence time and flow limit for an overflow discharge tumbling mill, Shi (2016) method | Ball Mill (Overfilling) |
| mdMediaStrings | Met Dynamics: Mill | Returns distribution and properties of mixed media sizes at recharge equilibrium | Tumbling Mill (Media Strings) |
| mdSMC_AbToSMC | Returns SMC ore properties from JK Drop Weight Test and Bond parameters | ||
| mdSMC_P80 | Returns P80 for a given Specific Energy calculated using rearranged SMC equation | ||
| mdSMC_W | Returns SMC Specific Energy for given input (generic equation) | ||
| mdSMC_Wa | Returns SMC Coarse Particle Tumbling Mill Specific Energy (>750 um) | ||
| mdSMC_Wb | Returns SMC Fine Particle Tumbling Mill Specific Energy (<750 um) | ||
| mdSMC_Wc | Returns SMC Conventional Crushing Specific Energy | ||
| mdSMC_Wh | Returns SMC HPGR Specific Energy | ||
| mdSMC_Ws | Returns SMC Specific Energy Correction for Size Distribution | ||
| mdTimeSeries_SMA | Returns Simple Moving Average with window width k | ||
| mdTimeSeries_EMA | Returns Exponential Moving Average with smoothing parameter alpha | ||
| mdTimeSeries_LRMA | Returns Linear Regression Moving Average with window width k | ||
| mdTimeSeries_CUSUM | Returns CUSUM control chart data with optional tabular V-Mask out-of-control detection | ||
| mdNeuralNet_Train | (Experimental) Trains a multi-layer neural network | ||
| mdNeuralNet_Process | (Experimental) Returns the predicted outputs for the given inputs, X, of the defined (trained) neural network | ||
| mdUnit_Blasting_KCO | Blasting fragmentation prediction, Kuznetsov–Cunningham–Ouchterlony (Swebrec) formulation (2005) | ||
| mdUnit_Crusher_Whiten | Met Dynamics: Crusher | Crusher unit model, Whiten formulation | Crusher (Whiten) |
| mdUnit_HPGR_Daniel | High Pressure Grinding Rolls unit model, Daniel formulation | ||
| mdUnit_HPGR_Torres | High Pressure Grinding Rolls unit model, Torres and Casali formulation | ||
| mdUnit_HPGR_Campos | High Pressure Grinding Rolls unit model, Campos (2021) modificatons to Torres formulation | ||
| mdUnit_AGSAG_Mutambo | Autogenous and Semi-Autogenous mill unit model, Mutambo variable rates formulation | ||
| mdUnit_BallMill_PerfectMixing | Met Dynamics: Mill | Ball mill unit model, Perfect Mixing formulation | Ball Mill (Perfect Mixing) |
| mdUnit_BallMill_PerfectMixingRiDi | Met Dynamics: Mill* | Ball mill unit model, Perfect Mixing formulation with separate Ri and Di functions | Ball Mill (Perfect Mixing, Dynamic) |
| mdUnit_StirredMill_PerfectMixing | Met Dynamics: Mill | Vertical stirred mill unit model, Perfect Mixing formulation | Stirred Mill (Perfect Mixing) |
| mdUnit_StirredMill_PerfectMixingRiDi | Met Dynamics: Mill* | Stirred mill unit model, Perfect Mixing formulation with separate Ri and Di functions | Stirred Mill (Perfect Mixing, Dynamic) |
| mdUnit_Mill_HerbstFuerstenau | Met Dynamics: Mill | Generic batch/rod/ball/stirred mill unit model, Herbst & Fuerstenau formulation | Mill (Herbst-Fuerstenau) |
| mdUnit_AirClassifier_Altun | Air classifier unit model, Altun (2014) formulation | ||
| mdUnit_Screen_Whiten | Multi-row vibrating screen unit model, Whiten & White, Dehghani and Firth formulation | ||
| mdUnit_Screen_Metso | Multi-row vibrating screen unit model, Metso formulation | ||
| mdUnit_Screen_Karra | Vibrating screen unit model, Karra formulation | ||
| mdUnit_Screen_Mwale | Fine wet screen unit model, Mwale formulation | ||
| mdUnit_Hydrocyclone_Nageswararao | Met Dynamics: Hydrocyclone | Hydrocyclone unit model, Nageswararao formulation | Hydrocyclone (Nageswararao) |
| mdUnit_Hydrocyclone_NarasimhaMainza | Met Dynamics: Hydrocyclone | Hydrocyclone unit model, Narasimha-Mainza formulation | Hydrocyclone (Narasimha-Mainza) |
| mdUnit_Hydrocyclone_Plitt | Met Dynamics: Hydrocyclone | Hydrocyclone unit model, Plitt formulation | Hydrocyclone (Plitt) |
*Native SysCAD Dynamic model version available.