Exporting Mass Haul Information to a Spreadsheet

The information displayed in the Mass Haul window can be exported to a spreadsheet. This document explains the contents of the export.

See also the online help for the Mass Haul options (right click on the Mass Haul window and select Mass Haul options, then type <F1> after the dialog box pops up).

A simple Mass Haul example

The following diagram shows the Mass Haul for a short section of road.

If you right click on the Mass Haul window and select Copy Mass haul balance items to Clipboard, then paste the clipboard contents into a spreadsheet application, you will see something similar to the figure below (shading added and decimals removed for clarity):


Column Descriptions


First Row (2)

The first four columns (A-E) in the first row describe the first shaded area (yellow): 7817 m3 were cut between stations 0 and 67; the centroid (start of arrow) is at station 118.

The next four columns (E-H) describe the balancing fill (also shaded yellow): 7817 m3 were filled between stations 217 and 258; the centroid (end of arrow) is at station 231.

The average distance moved (for calculation purposes) is the centroid-to-centroid distance (113 m). Because all of this material was moved more than the Free Haul Distance (FHD = 50m in this case) it is considered Over Haul (column I). Because it was moved in the increasing station direction, it is considered a Push (column L).

The overhaul values in columns J and K are a measure of cost calculated by multiplying distance and volume. The first number (J) uses centroid-to-centroid distance (note that some engineers use distance in km so the value is 1000 times smaller):

886957 m4 = 113.47 m * 7817.81 m3.

The second number (K) is calculated using a distance that is reduced by the Free Haul Distance:

496117 m4 = (113.47 m 50m) * 7817.81 m3.

Second Row (3)

The second row describes the green shaded Free Haul volume (1158 m3) between the cut and fill areas from the first row. Because the material is moved a small distance (less than FHD) the cut and fill are considered to occur at the same time; the start, end and centroid stations are the same for both cut and fill (167, 217, 192 respectively). Although this material is clearly Pushed (more cut on the left, more fill on the right) the distance is considered to be zero.

Third Row (4)

The third row describes another overhaul volume ((2463 m3). In this case the material is being Pulled from right to left. The cut stations (B,C, D) define the right hand yellow shaded area while the fill stations (F, G, H) are the left side.

Fourth Row (5)

The fourth row describes another green shaded Free Haul volume (1532 m3) between the cut and fill areas of the row above. Pull in this case.

Fifth Row (6)

The fifth row describes the red shaded unbalanced Borrow/Waste volume (4561 m3). This material is all cut, columns A-D, and therefore represents excess or waste. A borrow volume would be shaded a different color and the values would be reported in columns E-H.