A Simple Way to Visualise Material Movements at any Mine

At the end of each month, many mining operations generate a spreadsheet of materials moved around their operation. Unfortunately, up until now, this table of data can be difficult to interpret and display in a visual / meaningful way.

Introducing the Sankey Diagram. The Sankey Diagram has been used for many years to display the flow of energy through different systems. However, creating them has been a challenge and often it requires special software to create it.

sankey-material-movement-mine-finished

We at Acquire Procurement Services, took some open-source Sankey code and modified it for our own work to display the flow of money within contracts and the total cost of supply of services for our clients. We then made it publicly available.

However, through our work with mining clients, we found that plotting the movement of material between stockpiles in a mine is very easy to achieve with the Sankey Diagram Generator.  It can be done in four simple steps.

Step 1: Get your data in a spreadsheet

Here is some sample data if you need it. Download Sample Data.

material-movement-sample-data

 

Step 2: Create a pivot table of your data

If you have created a pivot table before, follow this simple pivot table tutorial from Easy Excel.

Setup your pivot table so it looks like this.

pivot-table-builder

pivot-table-1

 

Step 3: Copy and Paste the Data into the Sankey Diagram Generator

a) Open up the Sankey Diagram Generator

b) Copy the data.

pivot-table-select

Note: Make sure to:

  • Don’t include the Grant Total columns or rows
  • Don’t include “,” comma separators in such as 1,000,000

 

c) Click on Load -> Your Own Data

load-data-sankey-generator

d) Paste the Data into the Box

load-data-pivot

e) Click on the “Excel Pivot Table” Radio Button above the “Build Sankey” button

f) Click “Build Sankey”

You should get something similar to below:

sankey-material-movement-mine-1

g) Adjust the items (move / change colour)

You can then end up with something like:

sankey-material-movement-mine-finished

 

Step 4: Share it with your colleagues.

This can be done either by:

  • Take a screen shot and put it into your reports, or
  • Share it with using the “share” button in the menu
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *