Skip to content
MAX4METS

Capture data from every source

Import assays, plant readings, survey results and downtime from spreadsheets, laboratory files and plant system exports, with import rules that catch problems on the way in.

A metallurgical accounting system is only as good as the data that reaches it. Plant data can come from many places: laboratory result files, plant system exports, survey spreadsheets, shift logs and the handwritten sheet on the control room desk. MAX is built to take all of these in without retyping them, and to tell you when something does not look right.

Import definitions that remember your formats

An import definition describes one kind of file once: which worksheet, which rows and columns, whether data runs down or across, where the dates and times are, which columns hold comments, and which rows to skip. MAX supports Excel workbooks (xlsx, xls, xlsm) and CSV files, and several layouts, from a simple one-value-per-cell sheet to normalised row-based exports and free-form workbooks. Users can download a template for a definition, preview a file before importing it, and retry an import once a problem is fixed.

Each definition maps the file onto MAX measure points, the streams, tanks, stockpiles and pieces of equipment in your plant model, so a value lands in the right place every time. Aliases let a laboratory’s or another system’s names for a sample point map to yours without renaming anything.

MAX client sites build up a library of these definitions, using between about a dozen and fifty, including a bulk workbook import that brings in a whole day or month of plant data at once.

Files collected automatically

Remote file imports collect files from where other systems already put them: an FTP server (including SFTP and FTP over SSL), a network share or a SharePoint document library. Each one can filter by file name and modified date, limit how many files it takes at a time, and move or delete files once they have been imported, so the same results are not read twice. One site, for example, collects its laboratory result files over FTP over SSL as the laboratory publishes them.

Large imports can run in the background, so users are not left waiting on a screen while a month of data loads.

Rules that catch problems on the way in

Each import decides what to do when a file names a measure point or field MAX does not know, or leaves out one it expects: ignore it, warn, or stop the import. Laboratory conventions such as below-detection values (“<0.01”), dashes and zeros are handled by explicit rules rather than by hand. Where a value must stay within physical limits, an import can clamp it to a minimum and maximum. Warnings are recorded against the import session, so they can be reviewed later rather than lost.

Worksheets for data entered by hand

Not everything arrives as a file. Worksheets give operators and metallurgists a form for shift readings, tank levels, reagent additions and stock takes, laid out by field group and time of day. Fields can be numerical, categorical (a choice from a list), text or an attached file, and a worksheet can show live calculated values so the person entering data sees the result straight away. MAX runs in a web browser, so a worksheet can be filled in from any computer or tablet on the site network.

More than plant readings

The same import approach is used for budgets and forecasts, downtime logs from other systems, and bullion and product parcels, so all of the data the month-end depends on arrives the same way and with the same history. Every import is recorded as a session with its log and, if you choose, the original file, which is what makes the rest of MAX auditable.

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.