...
Right click on a field in a report to see access formatting options to edit format or or hide/display subtotals (Show Totals option).
...
Press the Copy Image button to make a screenshot of your table, which will be copied to the clipboard and can be pasted directly to your reports or presentation.
...
Create a pivot table to validate the destination logic setup:
Go to Schedule tab > Reporting tab > Add Report button > "Add Pivot Report".
Click in the name field and rename to "Destination Check".
Drag "Activity Type" into the Filter Area and set the filter to show "Mining only".
Drag "Mining_wetTonnes" into the Data Area.
Drag "Destination.Top" into the Columns Area.
Drag "Source Parcel" into the Row Area.
Drag "Destination Logic Rule" into the Row Area.
Use this table to identify if any Destination Rules are sending material to the wrong location.
...
Create a pivot table to validate the step logic setup:
Go to Schedule tab > Reporting tab > Add Report button > "Add Pivot Report".
Click in the name field and rename to "Step Logic Check".
Drag "Activity Type" into the Filter Area and set the filter to show "Mining only".
Drag "Mining_wetTonnes" into the Data Area.
Drag "Fleet" into the Column Area.
Drag into the Row Area:
"Source.OpenPit",
"Destination.Top",
"Step Logic Rule".
...
Use this table to identify if any Step Rules are using fleets in the wrong areas.
...
Create a pivot table to visualise the bench progression by pit and stage:
Go to Schedule tab > Reporting tab > Add Report button > "Add Pivot Report".
Click in the name field and rename to "Bench Progression".
Drag "Source.OpenPit" into the Filter Area and set the filter to show "OpenPit only".
Drag "Mining_wetTonnes" into the Data Area.
Drag "Period" into the Column Area.
Drag into the Row Area: Source.Mine/Pit/Stage/Bench.
...
Use this table to confirm that bench turnover is within practical limits per period.
...
Create a pivot table to validate the average cycle times being used by trucks.
Go to Schedule tab > Reporting tab > Add Report button > "Add Pivot Report".
Click in the name field and rename to "Cycle Time Check".
Drag "Activity Type" into the Filter Area and set the filter to show "Mining only".
Drag "Truck" into the Row Area.
Drag "Source.Mine/Pit/Stage" into the Row Area.
Drag "Destination.Name" into the Column Area.
Drag "HaulageResult.Times.Total" into the Data Area.
...
Use this table to confirm the average cycle times match with historical numbers.
...
Create a pivot table to validate the production rates being used by the excavation equipment:
Go to Schedule tab > Reporting tab > Add Report button > "Pivot Report".
Click in the name field and rename to "Loader Rate Check".
Drag "Activity Type" into the Filter Area and set the filter to show "Mining only".
Drag "Loader" into the Row Area.
Drag "MutexParcel.Haulage" into the Row Area.
Drag "HaulageResult.LoaderProductionRate.WTPH" into the Data Area.
...
Use this table to confirm the loader rates match with planning parameters.
...