Field References

A unique identifier for the period, created by concatenating the start date in YYYYMMDD format with the period name.

Example format:

YYYYMMDD_PeriodName

The name of the period (e.g., P1).

The exact date and time when the task’s associated period starts or finishes.

Calendar day (1–31) on which the period starts or finishes, based on the finish timestamp.

Returns the ordinal day number (1-365 or 1-366 in leap years) of the year on which the associated period starts or finishes, based on the finish timestamp.

Returns the hour of the day (0–23) at which the associated period starts or finishes.

Returns the minute within the hour (0–59) at which the associated period starts or finishes.

Returns the month of the year (1–12) in which the associated period starts or finishes.

Returns the full name of the weekday (e.g., Monday, Tuesday) on which the associated period starts or finishes.

Returns the second within the minute at which the period starts or finishes, expressed as a decimal value (e.g., ss.xx), where:

• ss = whole seconds (0–59)

• xx = fractional part of a second (hundredths or milliseconds, depending on system precision)

Returns the calendar year in which the associated period starts or finishes.

The total distance covered during a complete cycle of equipment for a scheduled task.

This distance includes both the forward and reverse haulage distances. In other words, it’s the sum of the forward route distance and the return route distance

Represents the equivalent distance a haul would cover if it were on a flat surface, effectively normalising the haulage distance by accounting for elevation changes and other factors that might affect the actual distance travelled.

This metric provides a standardised measure of haulage distance, which can be useful for comparing different haul routes or for reporting purposes.

The time, in decimal minutes, that equipment uses to travel a complete cycle (including forward and backward distances) for a scheduled task.

The cycle time accounts for:

• Spot time at loader

• Load time

• Travel time (full load)

• Spot time at dump

• Travel time (empty load)

You specify these haulage times for a resource in Site Management > Update haulage.

The time, in decimal minutes, that equipment uses to unload material at a dump.

You set a resource’s dump time in Site Management > Update haulage.

A dump location can have a dump penalty time. If so, this penalty time is added to the resource’s initial dump time.

You set a location’s dump time penalty on the Material flow diagram.

A resource’s final dump time is the sum of its user specified dump time and the location’s dump time penalty.

A dump location can have a dump time penalty, which is additional time—to the resource’s initial dumping time—for unloading material at that dump.

This field reports the dump time penalty, if the task involves a dump location with a penalty.

You set a location’s dump time penalty on the Material flow diagram.

The nett electrical energy consumed (kWh) by the equipment during a scheduled task.

An alternative method for determining the Cycle Equivalent Flat Haul (described above).

For a given task, the software calculates the alternative CEFH based on the horizontal distance associated with the optimal one-way haulage route from the source to the destination (with a full load). The software applies adjustments to the calculation to account for uphill and downhill components of the one-way haul route.

The one-way haul distance of the forward haulage route, from the source (i.e., pit) to the destination (i.e., dump), reported in the site- configured units.

The maximum z-coordinate value of the forward haul profile.

The lowest z-coordinate value of the forward haul profile.

The sum of the negative elevation changes of the forward haul profile.

The sum of the positive elevation changes of the forward haul profile.

Within a cycle, the forward travel time is the one-way haul time taken for the loaded equipment – from the source to the destination.

This value, alongside the Reverse Travel Time value, makes up the Travel Time value.

The fuel consumed by the equipment during the task.

Fuel consumption accounts for fuel used during load time, the travel time, and the dump time.

Indicates the method used to calculate the task’s haulage information:

• Modelled Haulage: The software uses the site’s underlying haulage network (refer to Update haulage) to calculate the task’s haulage. The calculation is based on a simulation using roads and a valid path between the locations mapped to the task’s source and destination.

• Fallback Travel Time: This method is used when the task tried to simulate haulage calculations with Modelled Haulage, but there was no valid route found between the mapped source and destination. In this case, the software uses the Travel Time If No Route Found value for the task, which is defined for movements in Material flow diagram.

• Fixed Haulage: The task’s travel time is determined by an expression of the associated Material flow diagram movement.

• No Haulage: No haulage data is calculated for this task.

You select a task’s haulage method in the associated movement of the Material flow diagram – with the Calculation Method property.

Specifies the name of the haulage model whose roads were used to simulate haulage for the given task.

The time, in decimal minutes, that equipment uses to load material at a source.

You set a resource’s load time in Site Management > Update haulage.

A measure of tyre workload generated over the forward (loaded) and reverse (unloaded) distance for the scheduling step. TKPH includes the dump and load times which will have the effect of reducing tyre workloads (that is, tyre cools while stationary).

Calculates the number of truck required to achieve the task.

This is achieved with this formula:

Number of Trucks = Total Truck Hours * Period Duration (Hrs)

• Total Truck Hours = Number of Cycles * Cycle Time (Hrs)

  • Number of Cycles = Mass / Payload

You can validate this calculation by setting up a Schedule Reportpivot table, using the fields referenced above as Data fields.

The weight of the material that a truck can carry.

• For tasks with modelled haulage, the payload used is based on the payload weight settings applied in the imported HAULSIM model.

• For tasks with fixed haulage, the payload used is the Default Truck Payload defined in Site Management > Update haulage.

Within a cycle, the reverse distance is the one-way haul odometer distance for the emptied truck – from the destination to the source.

The highest z-coordinate value of the reverse haul profile.

The lowest z-coordinate value of the reverse haul profile.

The sum of the negative elevation changes of the reverse haul profile.

The sum of the positive elevation changes of the reverse haul profile.

The haulage travel time in the reverse direction (with an empty load from the destination (i.e., dump) to the source (i.e., pit)).

This value, alongside the Forward Haulage Travel Time value, adds up to the Travel Time value.

The time it takes for the equipment to spot (position accurately for unloading) at the dump, in minutes.

You set a resource’s dump spot time in Site Management > Update haulage.

The time it takes for the equipment to spot (position accurately for loading) at a loader, in minutes.

You set a resource’s dump loader time in Site Management > Update haulage.

The travel time, in minutes, taken during the task – along the quickest path method between the locations.

The time is calculated with a simulation of the underlying HAULSIM model – and may be adjusted the expression set in Site Management > Update haulage.

The name of the activity performed in the task.

The name of the activity area performed in the task.

The note on the activity area performed in the task (entered on the Activity Areas tab).

The name of the spatial domain associated with the activity area performed in the task.

The name of the material flow diagram destination—which receives moved material—associated with the task.

The type of material flow diagram destination (dump, stockpile…) associated with the task.

The name of the dump block that receives the mined waste associated with the task.

The name of the dump lift that receives the mined waste associated with the task.

A flag (Yes/No) that indicates whether a resource is assigned to the task.

The name of the material moved in the task.

A flag (Yes/No) that indicates whether material was moved in the task.

The name of the mining level, where the material was extracted, if material was mined from an activity area in the task.

The name of the material flow diagram pit, where the material was extracted, if the material was mined from an activity area in the task.

The name of the rehandle group that associates with the rehandle operation performed.

The name of the resource definition, associated with the resource that performed the task.

The index number of the activity area slice mined in the task.

The name of the material flow diagram source node, where material was moved from, associated with the task.

The name of the build being constructed on the staged stockpile. It is populated when the destination is a staged stockpile.

Indicates the parcels at the destination of a material flow. When the destination is a staged stockpile, this field will include the name of the pile on the staged stockpile where the material is being directed.

The name of the pile on the staged stockpile where the material is being moved to.

This field contains the name of the build being depleted from the staged stockpile. It is filled when the source is a staged stockpile.

Indicates the parcel at the source of a material flow. When the source is a staged stockpile, this field will include the name of the pile on the staged stockpile from which the material is being sourced .

The name of the dump block where material is moved to or from.

The name of the dump lift where material is moved to or from.

The name of the location where material is moved to or from.

The type of location (dump, stockpile…) where material is moved to or from.

The build name of the current location (staged stockpile node).

The pile name of the current location (staged stockpile node).

The building and depleting phase of the pile for a period.

Activity Area floor polygon in WKT format

POLYGON Z ((x1 y1 z1,x2 y2 z2,...xn yn zn)).

Activity Area floor (silhouette) polygon in WKT format.

Activity Area floor surface in WKT format (TIN)

TIN (((x1 y1 z1,x2 y2 z2,x3 y3 z3,x1 y1 z1)),...).

Activity Area floor surface with a specified buffer (radius) applied, in WKT format (TIN).

Activity Area roof polygon in WKT format.

Activity Area roof surface in WKT format (TIN).

Activity Area solid in WKT format (TIN).

Period portion of area floor polygon in WKT format.

Period portion of area floor surface in WKT format (TIN).

Period portion of area roof polygon in WKT format.

The average elevation (of each point) of the floor of the activity area.

The average thickness of the activity area (Volume / Plan Area).

The density of the activity area.

The percentage of the activity area solid that intersects with grade control blocks (if imported).

The mass of the activity area (Volume * Density).

The surface area of the activity area.

The volume of the activity area.

The production rate factor applied to a given activity area. This factor modifies the production rate of any resource operating within that area by the specified amount. Defined on the Activity Areas tab.

The aggregated quantity of the activity quantity field.

The units of the activity quantity field.

Available roster time for the reported period.

The maintenance order number.

Resource productive time.

Flag to indicate whether the resource is in maintenance.

Flag to indicate whether the resource is operating (productive activity or travelling).

Flag to indicate whether the resource is productive (productive activity).

Sum of work category periods excluding 'Available' roster time for a Resource for a reporting period.

The amount of time a resource can operate. It’s determined by this formula:

Rostered Hours × Resourse Effective Utilisation

The actual production rate used by a resource on an activity area.

It’s determined by this formula:

Entered Production Rate * Resource Effective Utilisation

Refer to Site Config > Resources.

The resource's production rate, after considering the site-specific production rate, the periodic rate factor, and the activity area rate factor (if defined).

This rate is used to determine the actual production rate achieved by the resource.

Refer to Site Config > Resources.

The base/global rate of the resource, unaffected by any modifiers or site-specific production rates.

Refer to Site Config > Resources.

The activity area resource productive rate unit.

The aggregated quantity for productive tasks.

The unit of the activity quantity field for productive tasks.

Sum of productive time for a resource.

The percentage of rostered time the resource is available for use (Client > Resources tab).

This percentage is weight averaged by the task duration.

This percentage is weight averaged by the task duration.

The total percentage of rostered time that the resource is being utilised for the given task.

This is a multiplication of the resource’s Availability, Utilisation, and Efficiency values (Client > Resources tab).

The percentage of time that reflects how effectively the resource performs when in use (Client > Resources tab).

This percentage is weight averaged by the task duration, multiplied by the resource Availability and Utilisation.

The resource’s value of ResourcePeriodValue for the given period. Defined in Site Config > Resources, this represents a value that helps set the resource’s production rate for the given period.

A factor that represents a percentage of the resource’s nominal production rate – that will actually be used by the resource in the given period.

Refer to Site Config > Resources.

The mass (t) of the washed coal product.

The specific gravity at which the coal feed sinks within the washing unit.

The yield of the wash plant at the specified ash content.

[Activity Quantity] + 40

[Production Rate (Nominal)] - [Production Rate (Actual)]

[Activity Quantity] * [Production Rate (Actual)]

[Activity Quantity] / 2

[Activity Quantity] % 3

[Number] | [Number]

[Number] & 10

[Number] ^ [Number]

[Task Start Hour] == 10

[Task Start Hour] != 10

[Activity Quantity] < 200

[Activity Quantity] <= 200

[Activity Quantity] >= 300

[Activity Quantity] > 300

[Pit Name] In ('West', 'East', 'North')

[Production Rate (Actual)] Between (10, 20)

[Is Available] == 'Yes' And ([Production Rate (Actual)] > 1000

[Is Available] == 'Yes' And ([Production Rate (Actual)] > 1000)

Avg([Density])

[][[Density] < 2.1].Count()

[][[Density] < 2.1].Exists()

Max([Density])

Min([Density])

TODO

AddDays([Period Finish], 30)

AddHours([Period Start], 2)

AddMilliSeconds(([Period Start], 5000))

AddMinutes([Period Start], 30)

AddMonths([Period Finish], 1)

AddSeconds([Period Start], 60)

AddTicks([Period Start], 5000)

AddTimeSpan([Period Start], [Duration])

AddYears([Period Finish], -1)

DateDiffDay([Period Start], Now())

DateDiffHour([Period Start], Now())

DateDiffMilliSecond([Period Start], Now())

DateDiffMinute([Period Start], Now())

DateDiffMonth([Period Start], Now())

DateDiffSecond([Period Start], Now())

DateDiffTick([Task Start], Now())

DateDiffYear([Period Start], Now())

GetDate([Period Finish])

GetDay([Period Finish])

GetDayOfWeek([Period Finish])

GetDayOfYear([Period Finish])

GetHour([Period Start])

GetMilliSecond([Period Start])

GetMinute([Period Start])

GetMonth([Period Start])

GetSecond([Period Start])

GetTimeOfDay([Period Start])

GetYear([Period Start])

IsApril([Period Finish])

IsAugust([Period Finish])

IsDecember([Period Finish])

IsFebruary([Period Finish])

IsJanuary([Period Finish])

IsJuly([Period Finish])

IsJune([Period Finish])

IsLastMonth([Period Finish])

IsLastYear([Period Finish])

IsMarch([Period Finish])

IsMay([Period Finish])

IsNextMonth([Period Finish])

IsNextYear([Period Finish])

IsNovember([Period Finish])

IsOctober([Period Finish])

IsSameDay([Period Finish])

IsSeptember([Period Finish])

IsThisMonth([Period Finish])

IsThisWeek([Period Finish])

IsYearToDate([Period Finish])

IsThisYear([Period Finish])

AddDays(LocalDateTimeDayAfterTomorrow(), 5)

AddMonths(LocalDateTimeLastMonth(), 5)

AddDays(LocalDateTimeLastWeek(), 5)

AddYears(LocalDateTimeLastYear(), 5)

AddMonths(LocalDateTimeNextMonth(), 5)

AddDays(LocalDateTimeNextWeek(), 5)

AddYears(LocalDateTimeNextYear(), 5)

AddDays(LocalDateTimeNow(), 5)

AddMonths(LocalDateTimeThisMonth(), 5)

AddDays(LocalDateTimeThisWeek(), 5)

AddYears(LocalDateTimeThisYear(), 5)

AddDays(LocalDateTimeToday(), 5)

AddDays(LocalDateTimeTomorrow(), 5)

AddMonths(LocalDateTimeTwoMonthAway(), 5)

AddDays(LocalDateTimeTwoWeeksAway(), 5)

AddYears(LocalDateTimeTwoYearsAway(), 5)

AddYears(LocalDateTimeYearBeforeToday(), 5)

AddDays(LocalDateTimeYesterday(), 5)

AddDays(Now(), 5)

AddMonths(Today(), 1)

IsNull([Density])

IsNull([Density],2.2)

IsNullOrEmpty

Abs(1 - [Value])

Acos([Value])

Asin([Value])

Atn([Value])

Atn2([Value1], [Value2])

BigMul([Valuse1], [Value2])

Ceiling([Value])

Cos([Value])

Cosh([Value])

Exp([Value])

Floor([Value])

Log([Value])

Log([Value], 2)

Log10([Value])

Max([Value1], [Value2])

Min([Value1], [Value2])

Power([Value], 3)

Rnd()*100

Round([Value])

Round([Value], 2)

Sign([Value])

Sin([Value])

Sinh([Value])

Sqr([Value])

Tan([Value])

Tanh([Value])

ToDecimal([Value])

ToDouble([Value])

ToFloat([Value])

ToInt([Value])

Ascii('a')

Char(65) + Char(51)

CharIndex('West', 'PitWest')

Concat('Pit_', ')', [Pit Name])

Contains([Pit Name], 'West')

EndsWith([Pit Name], 'West')

Insert([Pit Name], 0, 'Pit_')

Len([Activity Area ])

Lower([Pit Name])

PadLeft([Pit Name], 30)

PadLeft([Pit Name], 30, '<')

PadRight([Pit Name], 30)

PadRight([Pit Name], 30, '>')

Remove([Pit Name], 3)

Remove([Pit Name], 0, 3)

Replace([Pit Name], 'Pit', '')

Reverse('etucex')

StartsWith([Pit Name], 'West')

Substring([Activity Area ], 3, 6)

Substring([Activity Area ], 3)

ToStr([Mat Code])

Trim(' a string with space at start')