ATS Pivot Tables

Listed in this section are a number of common pivot tables for error-checking your project setup. 

Destination Check

Create a pivot table to validate the destination logic setup: 

1. Go to Schedule tab > Reporting tab >  Add Pivot Report. 
2. Click in the name field and rename to "Destination Check".
3. Drag Activity Type into the Filter Area and set the filter to show Mining only. 
4. Drag Mining_wetTonnes into the Data Area.
5. Drag Destination.Top into the Columns Area.
6. Drag Source Parcel into the Row Area.
7. Drag Destination Logic Rule into the Row Area.

Use this table to identify if any Destination Rules are sending material to the wrong location.

For added detail, try dragging Source.Mine/Pit/Stage into the Row Area.

Step Logic Check

Create a pivot table to validate the step logic setup:

1. Go to Schedule tab > Reporting tab >  Add Pivot Report. 
2. Click in the name field and rename to "Step Logic Check".
3. Drag Activity Type into the Filter Area and set the filter to show Mining only. 
4. Drag Mining_wetTonnes into the Data Area.
5. Drag Fleet into the Column Area.
6. Drag into the Row Area:
   1. Source.OpenPit
   2. Destination.Top
   3. Step Logic Rule

For added detail, try adding Source Type and Destination Type to see the individual step logic components.

Use this table to identify if any Step Rules are using fleets in the wrong areas.

Bench Progression

Create a pivot table to visualise the bench progression by pit and stage:

1. Go to Schedule tab > Reporting tab >  Add Pivot Report. 
2. Click in the name field and rename to "Bench Progression".
3. Drag Source.OpenPit into the Filter Area and set the filter to show OpenPit only. 
4. Drag Mining_wetTonnes into the Data Area.
5. Drag Period into the Column Area.
6. Drag into the Row Area: Source.Mine / Pit / Stage / Bench

Bench progression pivot table

Use this table to confirm that bench turnover is within practical limits per period.

Loader Rate Check

Create a pivot table to validate the production rates being used by the excavation equipment:

1. Go to Schedule tab > Reporting tab >  Add Pivot Report. 
2. Click in the name field and rename to "Loader Rate Check".
3. Drag Activity Type into the Filter Area and set the filter to show Mining only. 
4. Drag Loader into the Row Area.
5. Drag MutexParcel.Haulage into the Row Area.
6. Drag HaulageResult.LoaderProductionRate.WTPH into the Data Area.

For projects using Loaders as Agents, drag Agent Rate field into the Data Area for direct comparison.

Use this table to confirm the loader rates match with planning parameters.

Cycle Time Check

Create a pivot table to validate the average cycle times being used by trucks.

1. Go to Schedule tab > Reporting tab >  Add Pivot Report. 
2. Click in the name field and rename to "Cycle Time Check".
3. Drag Activity Type into the Filter Area and set the filter to show Mining only. 
4. Drag Truck into the Row Area.
5. Drag Source.Mine/Pit/Stage into the Row Area.
6. Drag Destination.Name into the Column Area.
7. Drag HaulageResult.Times.Total into the Data Area.

Average cycle time pivot table

Use this table to confirm the average cycle times match with historical numbers.