...
Within Alastri’s resmodel we can take multiple block models and convert them to a common structure, common framework, with same number of fields and same fields in terms of their names. Within a single resmodel we can have multiple block models, what makes it a lot easier to store the information.
...
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" |
|---|
|
| Expand |
|---|
|
And | && | If A is "true" and B is "true" and C is "true", then return "true", else return "false" |
|---|
Or | || | If A is "true" or B is "true" or C is "true", then return "true", else return "false" |
|---|
Equal to | == | If A is equal to B, return "true", else return "false" |
|---|
Not equal to | != | If A is not equal to B, return "true", else return "false" |
|---|
Greater than | > | If A is greater than B, return "true", else return "false" |
|---|
Greater than or equal to | >= | If A is greater than or equal to B, return "true", else return "false" |
|---|
Less than | < | If A is less than B, return "true", else return "false" |
|---|
Less than or equal to | <= | If A is less than or equal to B, return "true", else return "false" |
|---|
|
Fields
New reserve model fields can be created by clicking the sum, weighted, and class icons located in the top button ribbon. These add new rows into the field list.
...
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.
...