Stockpiles

Source file: stockpiles.htm

The Stockpiles page allows users to view, manage, and analyse all stockpiles in the system. Stockpiles are listed in a customisable, searchable table with configurable columns and filtering by zone category or individual zones. Selecting a stockpile displays further details and options for editing, adjusting, or clearing. Data can be exported as a Microsoft Excel file (.xlsx) for reporting and analysis.

Filtering and searching stockpiles

All stockpiles are listed by default. The table is customisable, allowing users to reposition columns and change their sort order. Additional filtering is available through the search bar and the column-selection drop-down list, making it easy to organise information for reporting and analysis.

  • Enter a keywords in the Search field to find matches in all active columns, except for Last Activity.

  • Open the Categories drop-down, using the checkboxes to select those to include or exclude.

  • Open the Zones drop-down, using the checkboxes to select those to include or exclude.

  • Open the Displaying x/y columns drop-down list, using the checkboxes to select which to view or hide. Hidden columns are excluded from search queries.

  • Reorder item in the Displaying x/y columns drop-down list by dragging them up or down.

Stockpile details and tools

The details panel displays information for the selected stockpile. Click a stockpile in the list to populate its details. The information is organised into two sections, as follows:

The details panel also includes tools that allow you to do the following:

Export Surface

Create a surface of a stockpile and save it as either an AutoCad (.dxf), Vulcan triangulation (.00t), or Wavefront (.obj) format.

To use the Export Surface tool, follow these steps:

  1. Click Export Surface to open the Export to Surface File panel.

  2. Select the File Type from the drop-down list.

  3. Click Export to save the file to your computer. The file naming follows this convention:

    <Stockpile Name><format> (.dfx , .00t, or .obj)

Export the selected stockpile and its associated properties to a comma-separated values (.csv) file compatible with a Vulcan sub-blocked model.

To use the Export as ASCII tool, click Export as ASCII. A ZIP file containing a comma-separated values (.csv) file is created. Each are named as follows:

<Stockpile Name>Activity Date and time .zip and <Stockpile Name>.csv

Example:  SP_W2 Ascii Model.zip and SP_W2.CSV

Adjust Volume

Click the button to open the Adjust stockpile volume panel, then enter the adjusted value. The adjusted volume proportionately scales underlying properties, including mass and cuboid heights, without altering the base area.

Export as ASCII Click the button to remove all material from the selected stockpile. When the Clear stockpile panel opens, click Clear to confirm.
Calculate Properties This button is displayed if an unallocated stockpile is selected (its properties are not automatically displayed). Click the button to display its properties.
Note
  • Adjust volume and Clear stockpile buttons only appear if the users have roles with AdjustStockpileVolume and ClearStockpile permissions, respectively.

  • To undo transactions such as changing the volume or clearing a stockpile, use the event manager. To learn more, see System Preferences > Event Manager.

Exporting a Stockpiles table

The stockpiles table can be downloaded as a Microsoft Excel file. The contents are displayed as arranged by your filter and sort settings.

To export a stockpiles table to a Microsoft Excel (.xlxs ) file, follow these steps:

  1. Filter and arrange the required data in stockpile tables as needed. See Filtering and searching stockpiles.

  2. Click Export to Excel to export the report. The file is saved to the browser's downloads folder and named as:

    Stockpiles_<Date>T<Time>.xlsx

    where:

    • Stockpiles_ Is the prefix defining a Stockpiles page export file.

    • <Date> is the date of creation (matching the system clock), expressed as year-month-day).

    • T<Time> is the time of creation (matching the system clock), expressed as (hours_minutes).

    Example:  Stockpiles_2017-10-24T07_02.xlsx