PS. Chrono Reports

Owned by iarmstrong
Last updated: Jun 02, 2022
9 min read

Chrono reports are the static reports with the data, organized in columns and in rows. These reports are used to create static report tables to match business standard templates. Chrono reports allow the user to create tables with a mix of data (digger tonnes, crusher grades, truck hours, drill meters), and to visualize the data in charts.

The Chrono Reports workspace consist of four main tabs with different functionality, the toolbar, and Errors List. Detailed description of these reporting components see below.

Sample Chrono Summary report

Add New Chrono

To create this type of report select "Chrono" from Add Report button dropdown.

Schedule > Reporting > Add Report button>“Chrono” option

A New Chrono report will appear in the list of reports. Left click on it and rename as desired.

By default, an empty report will be displayed with the Table Setup and Charts Setup tabs available. Populating data into them correctly will unlock the Table and Charts tabs.

Table Setup tab

The Table Setup tab is used to create the table structure and data rows. Open it to edit the newly created report.

Report rows can be added, removed, indented, moved up/down, copied, cut, pasted using the top toolbar. 

  • When creating repetitive reports (i.e. Pit1, Pit2, Pit3, ...), start by creating a table template. Once complete, highlight the rows and select the Copy icon. Paste the copied rows and use the Find and Replace function to update the references. 

  • Use Change Time Settings button to set reporting intervals and start/end periods. You may choose to report by "Scheduling Periods", "Number and Name", "Calendar Years", "Financial Years", "Calendar Quarters" etc. For the Start and End periods you may select certain periods dates or schedule start/end to display in your report.

Set the values in each column to match your data set. Description of the columns see in the table below.

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

An alphanumeric identifier used to create a unique lookup for the row, which can later be referenced in graph series and calculated fields. It is also used as a lookup code for formulas and charts.

Caption

The display name of the row in the output table.

Indent

Creates nested table fields. 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 from a list or create a calculated field.

Item

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.

Filter 1 Field

Filter field for filtering results.

Filter 1 Value

Filter value to apply to the filter field.

  • Red circle on the left of the Type column indicates that you have made some mistakes filling up a table or there are some unresolved issues. Check the Error List below to get a description and fix all the errors listed.

Other toolbar buttons:

Button

Icon

Description

Button

Icon

Description

Find and Replace

<CTRL>+ H. Use this icon to quickly update a range of selected cells when editing or updating reports

Convert to Static Report

Convert your report to static. Note that if your report currently has errors, they must be resolved before the report can be converted to a static one. See the Errors list below.

Manage Custom Lists

Opens Custom Lists dialog where you may add, remove, move up/down, save and import custom lists, as well as add, remove, move up/down, sort, copy, paste and clear custom items.

 

Formatting

 

Use this button to:

  • configure Pivot Grid Appearance (font, size, style, color, background color for captions and samples),

  • clear formats,

  • paste or copy formats,

  • perform period formatting (font, size, style, color, background color for period captions and period names),

Usage Hints

 

Applicable hotkeys you may use when working with a report.

Table tab

Once you resolve all the issues listed in the Error List the Table tab becomes available. Open it to see the final report. 

Right click on any field header to set or reset a color

Right click on any field row to copy its full name

Charts Setup tab

Before setting up chrono report tables:

  1. Select the Charts Setup tab.

  2. Add a new chart.

  3. Rename the chart to "Sources".

  4. In the Primary Axis panel,

    1. change the caption to "Tonnes",

    2. change the Format to "0.0%".

  5. In the Series panel,

    1. Add four series.

    2. Name the series “P101“, “P102“, “P201“ and “P301“,

    3. Set the fields to "mov.expit.pits.P101", "mov.expit.pits.P102", “mov.expit.pits.P201“ and "mov.expit.pits.P301".

    4. Select from the Series Type column "StackedBar". You may select different types for each series to display in the Charts tab.

    5. Select colours for each bar.

Charts tab

Review all data you populated in the previous tab by opening the Charts tab.

Note, that this tab is only available if no errors remaining in the Chart Setup tab.

You may always come back to the Charts Setup tab to change Series Type to display in charts.

Setup tips

Relationship between Item and Data Source fields

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

Calculated fields

Calculated fields use a formula to create the 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.

If the formula has been incorrect previously, and you make a change to correct it, it won't turn black straight away. Switching to the Chart Setup tab and then switching back will resolve this.

Creating a chrono table example (Digger Tracker)

This section details how to make a simple digger utilization 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.

 

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

Row

Type

Name

Caption

Indent

Data Source

Item

Filter 1 Field

Filter 1 Value

Filter 2 Field

Filter 2 Value

Row

Type

Name

Caption

Indent

Data Source

Item

Filter 1 Field

Filter 1 Value

Filter 2 Field

Filter 2 Value

1

Title

Diggers

Diggers

0

 

 

 

 

 

 

2

Iterator

Diggers.<Diggers>

<Diggers>

1

CustomLists

Diggers

 

 

 

 

3

Row

Diggers.<Diggers>.hrs

Active Hrs

2

Agents

Time.AgentWorkingCalendarHours

Agent.Name

<Diggers>

 

 

4

Row

Diggers.<Diggers>.idle

Idle Hrs

2

Agents

Time.EngineOnHours

Agent.Name

<Diggers>

Agent.Delay

Do Nothing

5

Row

Diggers.<Diggers>.delay

Delay Hrs

2

Agents

Time.AgentWorkingCalendarHours

Agent.Name

<Diggers>

Agent.Delay

!Do Nothing

6

Title

Diggers.<Diggers>.delays

Inactive Hrs

2

Calculated

 

 

 

 

 

7

Iterator

Diggers.<Diggers>.delays.<Agent.Delay>

<Agent.Delay>

3

Agents

Agent.Delay

 

 

 

 

8

Row

Diggers.<Diggers>.delays.<Agent.Delay>.delay

Delay Hrs

4

Agents

Time.UnavailableHours

Agent.Name

<Diggers>

 

 

Table

If all the fields are filled out correctly and there are no errors in the Errors List panel, the Table tab will be active and the table in it will look like shown below:

Chart Setup

  1. Open the Chart Setup tab.

  2. Add a new chart.

  3. Rename the chart to “EX001”.

  4. In the Primary Axis panel, change the caption to “Hours” and the format to “0.0%”.

  5. In the Series panel, add three series and name them “Active”, “Delayed”, “Idle”.

  6. Set the fields to “Diggers.EX001.ProdHrs”, “Diggers.EX001.Delay” and “Diggers.EX001.Idle”.

  7. Set the Series Types to “FullStackedBar”.

  8. Select colours for each bar.

  9. Repeat for each digger.

 

Chart

If no mistakes were made during the charts setup, you can open the Charts tab and view the results.

You can change the charts view in the Charts tab by simply dragging the headers to the desired positions.