Skip to content
MAX4METS

Transparent formula management

Metal balance calculations are defined as named formulas that every user can inspect, so there is no hidden logic behind a reported number.

In a spreadsheet, the calculation behind a recovery or a contained-metal figure can sit in a cell that few people open, and when the person who built the workbook leaves, the knowledge of how it works can leave with them. MAX moves those calculations into the system as formulas: named, described, grouped and visible to every user with access, so the logic behind a reported number is never hidden.

Formulas you can read

Each formula has a code, a name, a description and a unit of measure, and belongs to a category that you define, for example by circuit or purpose: crushing, milling, leach, elution, electrowinning, doré, reagents, plant time, variance allocation and so on. MAX client sites hold between about twenty and a hundred and twenty formulas each, covering everything from head grade and recovery to contained metal and reagent consumption rates.

Formulas are written in a readable expression language with the usual arithmetic, rounding and logical functions, plus functions written for metallurgical accounting: handling missing values, looking up budget and accumulated budget values, and reading inventory balances, additions and removals by wet mass, dry mass, volume, moisture or assay. Formulas can use other formulas, so a complex calculation is built from small, checkable steps.

Rolling up from shift to month, explicitly

Aggregation is easy to get wrong in month-end spreadsheets. Is the monthly recovery the average of the daily recoveries, or the recovery calculated from the monthly totals? The answers differ, and only one is right. In MAX every formula states its evaluation behaviour:

  • Aggregate then evaluate: sum or average the inputs over the period first, then apply the formula. This is right for ratios such as recovery or grade.
  • Evaluate then sum: apply the formula to each shift or day, then add up the results. This is right for quantities such as contained metal.

Each formula also states how its result aggregates: a sum, an average, or an average weighted by another value such as dry tonnes. The same rules apply on a daily report, a monthly report and a dashboard, so the numbers agree everywhere.

One plant, different circuits

Plants change, and the same calculation is not always done the same way on every circuit. A formula can be overridden for a particular plant configuration or measure point, and an override can carry a start and end date, so a change in method takes effect from a given date without rewriting the formula used before it.

An editor that helps you get it right

The formula editor highlights syntax and suggests field and function names as you type. A dependency tree shows which measure points and other formulas a formula draws on, and lets you test it with sample values. MAX checks for circular references and validates expressions before they are saved, so a broken formula cannot quietly feed a report. Formulas record who created and last changed them, and changes are written to the user activity log.

Units of measure

Every result carries a unit, from tonnes and grams per tonne to percentages and kilograms per tonne. MAX includes a configurable library of units, unit categories and conversions, so figures are labelled consistently on every screen and report.

Transparent formulas are central to the AMIRA P754 code, which asks that calculation procedures are documented, consistent and not dependent on one person.

More MAX4METS features

Ready to elevate your metallurgical accounting?

Book a demonstration and see how MAX fits your plant, your data sources and your reporting cycle.