Versions Compared

Old Version 1

changes.mady.by.user iarmstrong

Saved on

compared with

New Version Current

changes.mady.by.user Todd Eggerman

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Chrono reports are the static reports with the date in columns and the data in rows. These reports are used to create static report tables to match business standard templates. 

...

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

...

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

Choose a field from the data source or enter a calculation

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

Find and Replace

Image Modified

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

Convert to Static Report

Image Modified

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

Image Modified

Opens Custom Lists dialog where you may configure custom lists grouping different items into custom categories. Custom lists allow selection of different fields and you can also access them in the calculated fields.

Image Removed
Image Added

Formatting

Image Modified

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

Image Modified

Applicable hotkeys you may use when working with a report.

Image Removed
Image Added

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

Image Removed
Image Added

Right click on any field row to copy its full name

Image Removed
Image Added

Charts Setup tab

Before setting up tables:

  1. Select the Charts Setup tab.

  2. Add a new chart.

  3. Rename the chart to "Stockpiles".

  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 three series.

    2. Name the series ROM HG, ROM MG, LG.

    3. Set the fields to "inv.hg", "inv.mh" and "inv.lg".

    4. Select from the Series Type column "FullStackedBar". 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.

...

The following wildcards can be used to filter the data:

Available filters

hg

Returns "hg"

hg?

Returns "hg" plus exactly one trailing character, ie. hg1, hg2, hg3

*note "hg" would be excluded in this filter, because it only has two characters

hg*

Returns "hg" plus any number of trailing characters, ie. hg, hg1, hga, hg171101

hg|bg

Returns "hg" and "bg" 

!hg|!bg

Returns all parcels excepting "hg" and "bg"

Calculated Fields

Calculated fields use a formula to reference the Name field of other rows. In addition to the formulas below, Excel-style addition and multiplication may be used. 

Available formulas

V("prod.wt.ore")

Returns the value of "prod.wt.ore" in the current period

CV("prod.wt.waste")

Returns the cumulative values of "prod.wt.waste" up to and including the current period

S("prod.wt.*")

Sums all child fields of "prod.wt" in the current period (using asterisk as a wildcard for all children)

SD(V("value1"),V("value2"))

Safe Divide value1 by value2. If value 2 is zero, the result is zero

Math.Round(SD(V("value1"),V("value2")))

Safe Divide result is rounded to the nearest even integer

Math.Ceiling(SD(V("value1"),V("value2")))

Safe Divide result is rounded up to the ceiling

Math.Floor(SD(V("value1"),V("value2")))

Safe Divide result is rounded down to the floor

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

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

Info

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.