PS Chrono Reports

Owned by Daniel Narayan (Unlicensed)
May 18, 2021
5 min read

Chrono reports allow the user to create tables with a mix of data (digger tonnes, crusher grades, truck hours, drill meters), and to visualise the data in charts.

Sample chrono summary report.

Contents

Introduction

Chrono reports are a static report with the date in columns and the data in rows.

Add New Chrono

New chrono reports can be added in Schedule tab > Reporting tab > green plus button > add new Chrono.

Add new chrono report.

Default empty chrono report.

Table Setup

The Setup Tab is used to create the table structure and data links.

Lookup of ‘mining.dryTonnes’ field in the Mining data source, filtered to Source.Top equals ‘Reserves’.

Column

Function

Column

Function

Type

Set row type to Title, Row, or Iter.

  • Title fields act like folders. Their only function is to contain child rows.

  • Row fields look up a value from some data source.

  • Iter(ative) fields can be used to loop over a list of items, and return the value for each item.

Name

The lookup code for formulas and charts.

Caption

The display name of the row in the output table.

Indent

Indentation of child rows under title rows.

Hide

Optionally hide a field from the output table.

Units

Optionally specify units (meters, bcm, tonnes).

Format

Excel-style number formatting.

Initial

Optionally set the opening value for cumulative sums of this field.

Data Source

Choose a data source.

Item

Choose a field from the data source.

Filter 1 Field

Filter field for filtering results.

Filter 1 Value

Filter value to apply to the filter field.

The Item column requires a Data Source to be specified.

  • Use the Mining data source for mining movements.

  • Use the Closing.Stockpiles data source for ROM stocks.

  • Use the Calendar data source for trucking calculations.

  • Use the Agent data source for reporting delays.

Data Source

Item

Data Source

Item

Duration

Minutes, Hours, Days, and Weeks duration of each report column.

Calendar

Calendar fields.

NonSpatialGuidance

Non-Spatial Guidance fields.

Calculated

Custom calculation.

CustomLists

Custom list of items.

Agents

Agent time and rate fields.

StockpileStates

Stockpile States.

ProductionDrilling

Drilling fields.

ProductionCharging

Charging fields.

Mining

Mining fields.

Opening.Stockpiles / Closing.Stockpiles

Opening and closing stockpile inventory.

Opening.Pits.<Activity> / Closing.Pits.<Activity>

Opening and closing <Activity> inventory (such as tonnes remaining in bench).

Stocks.Opening.<Activity> / Stocks.Closing.<Activity>

Opening and closing <Activity> inventory.

Digger Tracker

This section details how to make a simple digger utilisation table.

Table Setup

  1. Add a new Chrono report.

  2. Rename the report to ‘Digger Tracker.'

  3. Select the Table Setup tab.

  4. Press the ‘Manage Custom Lists’ icon to create a new list.

    1. In the Custom Lists dialog, create a new list called ‘Diggers’.

    2. Add each digger name to the list.

  5. Populate the setup as shown in the table below.

Row

Type

Name

Caption

Indent

Hide

Data Source

Item

Filter 1 Field

Filter 1 Value

Filter 2 Field

Filter 2 Value

Row

Type

Name

Caption

Indent

Hide

Data Source

Item

Filter 1 Field

Filter 1 Value

Filter 2 Field

Filter 2 Value

1

Title

Diggers

Diggers

0

 

 

 

 

 

 

 

2

Iterator

 

<Diggers>

1

 

CustomLists

Diggers

 

 

 

 

3

Row

ProdHrs

Active Hrs

2

 

Agents

Time.ProductiveHours

Agent.Name

<Diggers>

 

 

4

Row

AgentWorking

Working Duration

2

X

Agents

Time.AgentWorkingCalendarHours

Agent.Name

<Diggers>

 

 

5

Row

NotDoNothing

Not Do Nothing

2

X

Agents

Time.Duration

Agent.Name

<Diggers>

Agent.Delay

!Do Nothing

6

Row

TUL

Time Usage Loss

2

 

Calculated

Calculated

V("Diggers.<NE_Diggers>.AgentWorking")-V("Diggers.<Diggers>.ProdHrs")

 

 

 

7

Row

Delay

Discrete Delays

2

 

Calculated

Calculated

V("Diggers.<NE_Diggers>.NotDoNothing")-V("Diggers.<Diggers>.AgentWorking")

 

 

 

8

Row

Idle

Idle Hours

2

 

Agents

Agents

Time.Duration

Agent.Name

<Diggers>

Agent.Delay

9

Title

Delays

Inactive Hrs

2

 

 

 

 

 

 

 

10

Iterator

 

<Agent.Delay>

3

 

Agents

Agent.Delay

 

 

 

 

11

Row

Delay

Delay Hrs

4

 

Agents

Time.NotWorkingDuration

 

 

 

 

Digger tracker setup.

Digger tracker table.

Chart Setup

Complete the previous step before setting up tables.

  1. Select the Charts Setup tab.

  2. Add a new chart.

  3. Rename the chart to ‘EX001’.

  4. In the Primary Axis panel,

    1. change the caption to Hours,

    2. change the Format to 0.0%.

  5. In the Series panel,

    1. Add three series.

    2. Name the series Active, Delayed, Idle.

    3. Set the fields to Diggers.EX001.ProdHrs, Diggers.EX001.TUL, Diggers.EX001.Delay, Diggers.EX001.Idle.

    4. Set the SeriesTypes to FullStackedBar.

    5. Select colours for each bar.

  6. Repeat steps 2-5 for each digger.

Select the Charts tab too see the finished chart.

Add series to each chart.

Drag the chart titles to organise them in the panel.

Calculated Fields

Use calculated fields to create calculated values.

Chrono report formulas

Chrono report formulas

V(“field”)

Looks up the row with the name “field” and returns the value.

V(“field”) * 10 / 3

Looks up the row with the name “field”, multiples the value by 10, and divides by 3.

S(“title.*”)

Looks up all children of the row named “title”, and returns the sum.

CV(“field”)

Returns the cumulative value of the row named “field”. The initial value is set in the “Initial” column of the “field” row.

SD(1, V(“field”))

Returns 1 divided by the value in the row named “field”. If the denominator is zero, it returns zero.

Math.Round(V(“field”))

Return the row named “field”, rounded to the nearest integer.

Math.Ceiling(V(“field”))

Return the row named “field”, rounded up.

Math.Floor(V(“field”))

Return the row named “field”, rounded down.

Math.Log(V(“field”))

Returns the natural logarithm of the row named “field”.

V("myValue") > 0 ? 1 : 0

If "myValue" is greater than zero, return one, otherwise return zero.

 

Chrono Table Setup > Formula inputs

Chrono Table > Formula outputs