Reports

Source file: reports.htm

Reports delivers specific tables that you can filter and export as a Microsoft Excel spreadsheet (XLSX) file. The following reports are available:

• Stockpile Ons and Offs: This 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. 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 Excel (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 on the page selection bar, then select .
2. Select the Time range by doing any 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 the button 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 a 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 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 waterfall chart.
• Click on the column header of any stockpile to see and expanded view. A panel opens containing statistics from the 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.

Exporting your on and offs report

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

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

2. Click (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:

• From Pit: In this section of the table, material moved from the pit is tabled for each destination zone category. Each shift, has a row for Actual The tonnage recorded by MaterialMRT., Mine Plan The scheduled or expected tonnage., and Variance The difference between the Actual and Mine Plan tonnage..
• To Outflow: This section of the table is material moved from a zone category that goes to the Outflow. The same rows, Actual, Mine Plan, and Variance are used.

To generate a report, follow these steps:

1. Hover over on the page selection bar, then select . The Tonnage Reconciliation page 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 first select a non-shift period from the Time drop-down.
   • Click to open the calendar picker. Select a start and end date, and a start and end time. Click to save your settings and close the calendar picker.

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

4. 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.

5. Click to create the report.

Interpreting tonnage reconciliation data

Each shift contains three rows, as follows: Actual (tonnage), Mine Plan (designed tonnage), and Variance (the difference between Actual and Mine Plan values). For each shift, the following applies:

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

• Negative variance (red text) 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.

Exporting your tonnage reconciliation report

Reports are exported to a Microsoft Excel spreadsheet (XLSX) file. To prepare your export, follow these steps:

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

2. Click on the 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 then click top open its page.
2. In the Stockpiles field, click to expand its drop-down.
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 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 Average: 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 Excel spreadsheet (xlsx) file. To prepare your export, follow these steps:

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

2. Click on the 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: Use 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 to run the report.

Expanding your filtering options

You can refine the report by clicking on . 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 in the header to expand and collapse the secondary properties column. Optionally, you can expand or collapse individual rows using the and 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 that 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: Use 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 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: Use the checkbox to select all numerical properties. Clearing the checkbox clears all currently selected items.
  • Select individually: Use the checkboxes to select specific properties.

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

• Ignore re-handled trips: Select this checkbox to prevent material being double counted. Simply put, material that hasn’t been moved before is counted and included in your report. However, if subsequent (re-handled Re-handled material are movements between a source and destination in the run-of-mine that does not terminate at the sink. For example, this could be a trip that starts at the pit and ends at a stockpile. Subsequent trips involving that material are considered re-handled.) trips occur, they are excluded in this report.

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 Excel spreadsheet (xlsx) file. To prepare your export, follow these steps:

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

2. Click on the 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.