Reports

This reports group hosts the following reporting tools:

Stockpile Ons and Offs:The report itemises incoming and outgoing changes in stockpile tonnage over a given period of time. To learn more, see Running stockpile ons and offs reports.

Tonnage Reconciliation: This report uses FMS data to show the amount of material (based on a text property) moved from pit to other zones and from zones to outflow over a given period of time. Actual versus Mine Plan quantities determine the Variance and their totals are summarised for each zone category. Tonnage reconciliation can be exported to a Microsoft.xlsx file. To learn more, see Running tonnage reconciliation reports.

Stockpile Inventory: This report shows the inventory of properties by mass in each stockpile and export it as a Microsoft.xlsx file. To learn more, see Running stockpile inventory reports.

Trips: This report displays which primary text properties and associated numeric and secondary text properties were present in the period of time that the trips occurred. To learn more, see Running trips reports.

Running stockpile ons and offs reports

Reports - On and Offs reports changes in the mass of a stockpile as material is added to (ons) and removed from (offs) the stockpile. A total and running total is tabulated for each stockpile. To generate an On and Offs report, follow these steps:

  1. To start the report, hover over Reports button on the page selection bar, then select Stockpile Ons and Offs Button.
  2. Select the Time range by doing either of the following:
    • Click on the Time drop-down and select a set period
    • Use the calendar picker () and select a start date and time and an end date and time. Click on to close the calendar picker.
    • Use the and buttons to jump to a previous or next time period. To see these controls, you must select an non-shift period from the drop-down.
  3. Open the Stockpiles drop-down and select which stockpiles to include.
  4. Open the Filter drop-down and select one of the following:
    • Ons only: Only material added to the stockpile is accounted for in the report.
    • Offs only: Only material removed from the stockpile is accounted for in the report.
    • Ons and Offs: Material added and removed are accounted for in the report.
  5. Click Generate button to create the report. In the example below, tonnages for each shift inside the date range are listed for all queried stockpiles in their own columns.

Viewing additional information

After generating your report, you can examine information in more detail, as follows:

  • Hover over any column to show a small pop-up histogram
  • Click on the column header of any stockpile to see and expanded view. A panel opens containing statistics from the stockpile , Stockpile modifications, and histogram of the selected stockpile.

Interpreting on and offs report data

Each stockpile has its own column which is sub divided into two columns: Change and Running total. See the example below.

Example

The stockpile ROM_W2 has changes recorded for the swing shift on September 21 and the night shift on September 22. No changes occurred on September 22 day shift.

In the Change column, the stockpile ons are 5093.16 and 45.6 tonnes and the stockpile offs are -3160.20 and -194.10 tonnes

TOTAL change is the difference of the tabulated on and off values. In this example, this is: (5093.16 + 45.60) - (3160.20 + 194.10) = 1784.46. The total change is recorded at the bottom of the Change column.

The Running total column is the sum of the Carried Forward amount (if present) and net Change in each shift. Subsequent changes are added to the running total from the previous shift, as demonstrated in the following example:

5214.12 + 1932.96 = 7147.08 (Sep 21 Swing shift)

7147.08 + (-148.5) = 6998.58 (Sep 22 Night shift)

0 (no change) + 6998.58 + 6998.58 (Sep 22 Day shift)

Exporting your on and offs report

Reports are exported to a Microsoft .xlsx file. To prepare your export, follow these steps:

  1. Configure your filtering parameters, then click Generate inventory report button to run the report.

  2. Click on the export to Excel button (Export to Excel button) at the top-right of the page.

    The report is saved as ExcelSheet.xlsx to your default download directory. For typical Window installations, this is Downloads.

Running tonnage reconciliation reports

Tonnage reconciliation uses FMS data to tabulate and quantify the following text properties:

To generate a report, follow these steps:

  1. Hover over Reports button on the page selection bar, then select and click Tonnage reconciliation button. The Tonnage Reconciliation panel opens.

  2. Select the time period or shift using any of these methods:

    • Click in the Time drop-down to select a preset period or shift.
    • Use the and buttons to jump to a previous or next time period. To see these controls, you must select an non-shift period from the drop-down.
    • Click to open the calendar picker. Select a start and end date, and a start and end time. Click to save and close the calendar picker.

  3. Select a Text Property from its drop-down list.

  1. Select at least one component from the Value drop-down list using the checkboxes for individual selection, or use Select All to include all items.

  1. Click Generate button to create the report.

Interpreting tonnage reconciliation data

  • Each shift contains three rows, they are: Actual (tonnage), Mine Plan (design) and Variance (The difference between Actual and Mine Plan values) For each shift, the following applies:

  • Positive variance indicates meeting or exceeding Mine Plan values) .

  • Negative variance indicates a shortfall of the expected mine plan values.

  • Accumulated actual, mine plan and variance values are located in the bottom row, TOTAL.

  • The combined amount of material for shift From Pit and To Outflow are recorded in each column, Total.

Example
 

Exporting your tonnage reconciliation report

Reports are exported to a Microsoft .xlsx file. To prepare your export, follow these steps:

  1. Configure your filtering parameters, then click Generate inventory report button to run the report.

  2. Click on the export to Excel button (Export to Excel button) at the top-right of the page.

    The report is saved as ExcelSheet.xlsx to your default download directory. For typical Window installations, this is Downloads.

Running stockpile inventory reports

  1. Hover over Reports button then click Stockpile inventory button top open its page.
  2. In the Stockpiles field, click Stockpiles drop-down list to open the drop-down list.
  3. Select the stockpiles to be displayed using the check boxes. Click the Select all check box to include all stockpiles.
  4. In the Properties field, select which properties to include in the inventory report using the same method described in step 2. and 3.
  5. Click Generate inventory report button to run the report.

Interpreting stockpile inventory data

Stockpiles are listed in the first column, followed by the combined tonnage (Mass) and movements in the second and third columns respectively. The columns thereafter list the properties that were selected to be included in the inventory. The coloured dots in each cell indicates the schema colour of that material.

There are two aggregate value rows at the bottom of the table that are:

    • Weighted Mass: Weighted Mass= (w1 * x1 + w2 * x2 + ... + wn * xn) / (w1 + w2 + ... + wn)
      Where:
      w1, w2, ..., wn are the stockpile mass assigned to each data point. x1, x2, ..., xn are the values of the property.
    • Total Mass: The total mass is the sum of all the stockpile mass in the Mass column.

Exporting your stockpile inventory report

Reports are exported to a Microsoft .xlsx file. To prepare your export, follow these steps:

  1. Configure your filtering parameters, then click Generate inventory report button to run the report.

  2. Click on the export to Excel button (Export to Excel button) at the top-right of the page.

    The report is saved as ExcelSheet.xlsx to your default download directory. For typical Window installations, this is Downloads.

Running trips reports

All trips in a given time period associated with your primary and optional secondary text properties, and selected numeric properties, are shown in tabular format. Components of the selected text property are displayed in the first column, and its mass is listed in the adjacent Mass column.. The table shows which components were present, and their underlying numeric properties. What you choose to display depends on the filtering options used, as follows:

  • Time: Use the date or calendar picker to determine the period to query as follows:
    • Use and to return to or advance to the next time period.
    • Click in the time field to expand the list and select a period.
    • Click to open the calendar picker. to select a custom start and end date, as well as the start and end time. To accept the selection, click .
  • Primary Text Property: Expand the drop-down and select a text property, or type a keyword in the Search Properties field to find a specific text property.
  • Numeric Properties: Expand the drop-down and select any of the following:
    • Search Properties: Type a keyword to locate matching names.
    • Select All: Enable the checkbox to select all numerical properties. Disabling the checkbox clears all currently selected items.
    • Select individually: Use the checkboxes to select specific properties.

When the required parameters are inputted, click on Generate.

Example

The picture below demonstrates a report based on the text property seam. In this section of the report, the list of components in seam are shown, along with any numeric properties. The colour underlines correspond to the weighted-average legend set in Material Properties Schema. In this instance all the visible values for a7 fall between 5 and 10, which is indigo. For the property as25ad, the value range for grey is 15 to 20 and 25 to 30+ is red.

Expanding your filtering options

You can refine the report by clicking on More options. This reveals the following:

  • Secondary Text Property: Select a second property from this drop-down. A second column next to the primary text property is inserted. Any secondary properties within the primary property component are listed in an expandable list

Example

A secondary text property, (ws) has been assigned and added next to the primary text property, (seam). Note that the secondary property column is expandable. Use Expand and collapse column in the header to expand and collapse the secondary properties column. Optionally, you can expand or collapse individual rows using the Expand column and Collapse row button respectively.

In the instance below the primary text property, seam, contains components, pg1 , pg2, pg3u3, and so on. Each primary component may contain components of the secondary text property. In this case, pg1 has bd_art3, pge_pg_1, pg2_pag1, and bd_art3_art1 were present in the trips containing pg_1.Likewise, for every secondary text property component, there may be a numeric property associated with it.

  • Destination zones: You can select which destination zones should be included in your trips report and filter out the rest. To make a selection, expand the drop-down and do any of the following:
    • Search zones: Type a keyword to locate matching names.
    • Select All: Enable the checkbox to select all numerical properties. Disabling the checkbox clears all currently selected items.
    • Select individually: Use the checkboxes to select specific properties.

    After updating your destination zone, click on Generate to refresh your report.

  • Source zones: You can select which sources zones should be included and filter out the rest. To make a selection, expand the drop-down and do any of the following:

    • Search zones: Type a keyword to locate matching names.
    • Select All: Enable the checkbox to select all numerical properties. Disabling the checkbox clears all currently selected items.
    • Select individually: Use the checkboxes to select specific properties.

    After updating your destination zone, click on Generate to refresh your report.

  • Ignore re-handled trips: Enable this checkbox to exclude re-handled material from being added to the overall mass. Excluding re-handled material ensures that only source to sink trips are calculated.

Tip:  You can change the position of any primary text property component listed in the Reports - Trips page. Simply select and drag any row to the desired position in the list.

Exporting your trips report

Reports are exported to a Microsoft .xlsx file. To prepare your export, follow these steps:

  1. Configure your filtering parameters, then click Generate inventory report button to run the report.

  2. Click on the export to Excel button (Export to Excel button) at the top-right of the page.

    The report is saved as ExcelSheet.xlsx to your default download directory. For typical Window installations, this is Downloads.