...
Be careful to use the text T(“material”) syntax so that the parcel is read as text, not as a number.
Block Model Formulas and Logical Operators
There are a number of expressions available to use in the Reserve Model Generator.
| Expand |
|---|
| title | Block Model formulas |
|---|
|
A+B
| Add A and B |
|---|
A-B
| Subtract B from A |
|---|
A*B
| Multiply A and B |
|---|
A/B
| Divide A by B |
|---|
A.ToLower()
| Convert all upper case text (HG, Hg, hg) into lower case (hg) |
|---|
Math.Min(A,B)
| Return the minimum of A and B |
|---|
Math.Max(A,B)
| Return the maximum of A and B |
|---|
N("density") <= 0 ? 0 : N("volume")
| If density is less than or equal to zero, return zero volume, else return the volume field |
|---|
A.Substring(0,Math.Min(3,A.Length))
| Return the first three letters of A |
|---|
( RowT("material")=="waste1" || RowT("material")=="waste2" ) ? "waste" : RowT("material")
| If material is waste1 or waste2, then return "waste", else return the "material" |
|---|
|
...
Use the Min/Max toggle to inspect the data for missing or rubbish values.
Check the material types, tonnes and grades for ballpark accuracy.
...
Export
You can export the entire Reserves model to a CSV file. To do this, click the Export button on the top line and specify the path to the destination folder.
...