Stockpile Setup

At the time of writing this guide, the Stockpile feature is only available in the Spry(Beta) version.

This guide will outline the basic steps in setting up a Stockpile and include a short FAQ for troubleshooting.

Stockpiles require Source and Destination tables be set up.

Step 1 – Setup

Stockpiles create a link between records in your Source and Destination tables. Links can only be made between nodes with the same address.

  1. In your Source table create Volume and Initial Percentage fields for the Rehandle
  2. Export Destination table records that are to be stockpiled

Step 2 – Convert your data in Excel to import into your Source Table

To import data into your Source table it must have a position for each node level, such as Pit/Strip/Block. In Excel, convert the level structure of your exported data to match that of your Source table.

  1. Create columns for extra levels and remove levels that are not part of your Source table
  2. Levels that are functionally the same, such as “Pit” and “Dump”, can be renamed
  3. Use an empty position such as “Nothing” for the newly created, placeholder levels

Step 3 – Import the data into your Source Table

  1. Ensure that each level has a column mapped to it
  2. Map the volume to your Rehandle Volume field
  3. Map the Solid to your Waste Solid field

At this point you should have successfully created some new fields in your Source table and imported the desired range of Destination table nodes.

Step 4 – Create a Rehandle Process

In either a new scenario, or existing scenario:

  1. Set the a new process called “Rehandle”
  2. Map the Rehandle Volume Field to the Source and Destination Quantity Fields
  3. Map the Rehandle Initial Percentage and Waste Solid fields

Step 5 – Assign the Rehandle Process

For solids to populate in the animation window, they require an associated process and a piece of equipment assigned that process.

  1. At least one piece of Equipment must have the Rehandle process ticked as ‘Active’ and have a non-zero Hourly Rate

Step 6 – Pre-schedule your new Source table records

At the moment your newly imported records are treated as solids and will appear at the start of your schedule. The solution is pre-schedule them out using the Initial State tool.

  1. In the Initial State section, check that your Rehandle Initial Percentage field has mapped correctly
  2. In the Initial State pathing section include the records imported to your Source table and assign “(100%)” completion
  3. Click “Apply Now” and check your animation

Step 7 – Stockpile Settings

As of writing this guide, the stockpile feature is only available on the Beta version of Spry. Please ensure you are running this version.

To access the feature, open a scenario, go to Settings and then select the Stockpiles tab.

Click “Enabled” and create a new Stockpile.

Step 7.1 – Source Range

This range selects those nodes from your Source table that you wish to link to your Destination table. Your Source table will be filtered to these nodes when creating Destination Node expressions.

Step 7.2 Processes

Provides another layer of filtering. Select which processes can work the stockpiled material.

Step 7.3 Destination Node Expression

The stockpile works by linking records between the Source and Destination tables. This link is formed by the Destination Node expression which creates an address for each node included in the Source Range set up in Step 7.1. If a matching node address is found in the Destination table a link is formed.

For example, you may have added a Seam level during the export/import process that is not part of your Destination table structure:

Source Table: AlphaInPit/Strip1/Block1/NoSeam/Bench100

Destination Table: AlphaInPit/Strip/Block1/Bench100

To match the two addresses use the following node expression:

Text(SourcePit) + “\\” + Text(SourceStrip) + “\\” + Text(SourceBlock) + “\\” Text(SourceBench)

Step 7.4 – Blending Mode

Blending mode refers to how material of various quality is removed from the stockpile.

    1. First In First Out (FIFO)(Default)
      • Material deposited to the stockpile before some other material will be removed before that material
    2. First In Last Out
      • Material deposited to the stockpile before some other material will be removed after that material
    3. Blend
      • Simulates stockpiles in which material of various qualities are blended
      • Material is removed from the stockpile based on a weighted average of the constituent materials of the stockpile

Step 7.5 – Completion Behaviour

Completion behaviour refers to how Spry treats stockpile tasks once they have been completed. This includes Source and Destination tasks.

  1. Leave In Paths (default)
    • Completing a stockpile task does not remove it from the equipment’s Source or Destination Path if the task has been ‘Over-pathed’
    • ‘Over-pathing’ a task refers to telling Spry to work more than 100% of the Source Quantity of a task.
    • For example if you wanted to work a stockpile node twice you would include the node address in the Source Path and then add a Quantity Modifier:AlphaInPit/Strip1/Block1/Bench100 (200%)
    • The task will remain in the equipment’s Source Path until it has worked the full 200% at which point it will be removed
    • This affects both Source Path tasks and Destination Path tasks. If you want to refill your stockpile you will need to over-path in your Destination Paths.
  2. Remove From Paths
    • This option affects Source and Destination Path tasks
    • Once a task has been completed, it is removed from the Path of the associated equipment.
    • Over-pathing does not affect this behaviour.


Q: Why are my stockpile solids not appearing?

A: Check the following:

  • Check you have set up your Rehandle process correctly
  • Ensure you have a piece of Equipment set to work the Rehandle process
  • Go to your animation tab and hit Reload Solids
  • Check your Prefilter Ranges in your Settings
  • Reimport your data into your Source table and ensure there are associated volumes

Q: Why isn’t my stockpile filling up?

A: Check the Destination paths for your equipment, particularly the processes option

Q: Why isn’t my stockpile being dug?

A: Check the following:

  • Make sure you have successfully prescheduled your stockpile material
  • Check that you have correctly included your stockpile material in your Source Path

Q: How do can I continue to dump into/dig my stockpile?

A: Ensure that you have “Leave In Paths” selected in your stockpile settings. You must also ‘over-path’ the material you want to dump/dig by adding quantity modifier to your Path. See Step 7.5 for more information.

Q: Why am I getting an error about Stockpile Destination nodes when I run my schedule?

A: The error occurs when the Destination Node Expression creates an address which cannot be found in your Destination table. For more information, see Step 7.3.