SE Performance

These formulas are presented when the formula editor is being accessed through SE Performance:

In addition to the Logic functions already described in the All components section, in SE Performance, the following functions are available:

▪ISNUM: Verifies the specified value and returns TRUE or FALSE, depending on the result. Returns the true logical value if the value argument is a reference to a numeric. Otherwise, it will return FALSE.

Syntax:

ISNUM()

Asset

In this option, the following functions are available:

▪Downtime: Returns the sum of assets downtime.

Syntax:

DOWNTIME()

▪MTBF: Returns MTBF calculation related to assets.

Syntax:

MTBF()

▪MTTR: Returns MTTR calculation related to assets.

Syntax:

MTTR()

▪Availability: Returns calculation of asset availability.

Syntax:

AVAILABILITY()

▪Activities total cost: Returns the sum of total costs of activities related to assets.

Syntax:

TOTALCOSTOFACTIVITIES()

Calibration

In this option, the following functions are available:

▪Calibration cost: Returns the total sum of calibration costs.

Syntax:

CALIBRATIONSCOST()

▪% calibrations executed on time: Returns the number of calibrations executed on time.

Syntax:

CALIBRATIONSEXECUTEDONTIME()

▪Total of calibrations: Returns the number of calibrations.

Syntax:

TOTALCALIBRATIONS()

▪Total of approved calibrations: Returns the number of approved calibrations.

Syntax:

TOTALAPPROVEDCALIBRATIONS()

▪Total of conditionally approved calibrations: Returns the number of conditionally approved calibrations.

Syntax:

TOTALCONDITIONALLYAPPROVEDCALIBRATIONS()

▪Total of rejected calibrations: Returns the number of rejected calibrations.

Syntax:

TOTALREJECTEDCALIBRATIONS()

Performance

In this option, the following functions are available:

▪Dynamic accumulation: Returns accumulated value of an indicator based on accumulation parameters (Vertical or Horizontal), fields (Target or Actual), operation (Sum or Average) and selected periods.

Syntax:

DYNAMICACCUMULATION(<Field>;<Indicator>;<Accumulation>;<Operation>;<Periods>)

▪Sub-indicators average: Returns the average of sub-indicators associated with the indicator in current period.

Syntax:

SUBINDICATORSAVG()

▪PERIOD START DATE: Returns the start date of the period being calculated, based on the indicator frequency.

Syntax:

PERIODSTARTDATE()

▪PERIOD END DATE: Returns the end date of the period being calculated, based on the indicator frequency.

Syntax:

PERIODENDDATE()

Inspection

In this option, the following functions are available:

▪Total of receivings: Returns the number of inspection receivings.

Syntax:

TOTALRECEIVINGS()

▪Total of approved receivings: Returns the number of inspection approved receivings.

Syntax:

TOTALAPPROVEDRECEIVINGS()

▪Total of conditionally approved receivings: Returns the number of conditionally approved receivings of inspection.

Syntax:

TOTALCONDITIONALLYAPPROVEDRECEIVINGS()

▪Total of rejected receivings: Returns the number of rejected receivings of inspection.

Syntax:

TOTALREJECTEDRECEIVINGS()

Maintenance

In this option, the following functions are available:

▪Cost of preventive maintenance: Returns cost sum of preventive maintenance.

Syntax:

PREVENTIVEMAINTENANCECOST()

▪Cost of programmed activities: Returns the sum of programmed maintenance cost.

Syntax:

SCHEDULEDMAINTENANCECOST()

▪Corrective activities cost: Returns the sum of corrective activities cost.

Syntax:

CORRECTIVEMAINTENANCECOST()

▪Verifications cost: Returns the sum of verifications cost.

Syntax:

VERIFICATIONSCOST()

▪% preventive maintenance executed on time: Returns the number of preventive maintenance events executed on time.

Syntax:

PREVENTIVEMAINTENANCEEXECUTEDONTIME()

▪% preventive maintenance programmed on time: Returns the number of maintenance events programmed on time.

Syntax:

MAINTENANCEPROGRAMMEDONTIME()

▪% verifications executed on time: Returns the number of verifications executed on time.

Syntax:

VERIFICATIONSEXECUTEDONTIME()

Analytics

In this option, the following functions are available:

▪Number: Returns the value of a view of the number type of SE Analysis component analysis panel. The value will be distributed by the periods of the indicator according to its frequency and the reference field.

Syntax:

ANALYTICS('<Analysis>';'<View_Number>';'<Reference date>')

Process

In this option, the following functions are available:

▪Started instances: Returns the quantity of started instances.

Syntax:

STARTEDINSTANCES(<Process>;<User>)

▪Finished instances: Returns the quantity of finished instances.

Syntax:

FINISHEDINSTANCES(<Process>;<User>;<Status>;<Priority>;<Value>)

▪Cancelled instances: Returns the quantity of cancelled instances.

Syntax:

CANCELLEDINSTANCES(<Process>;<User>;<Status>;<Priority>;<Value>)

▪Average elapsed time of instances: Returns the average elapsed time in minutes between the start and end of the instances.

Syntax:

AVERAGEELAPSEDTIMEINSTANCES(<Process>;<User>;<Status>;<Priority>;<Value>)

▪Average time of instances in working hours: Returns the average time elapsed in minutes based on working hours between the start and end of the instances

Syntax:

AVERAGETIMEINSTANCESWORKINGHOURS(<Process>;<User>;<Status>;<Priority>;<Value>)

▪Executed activities: Returns the quantity of executed activities.

Syntax:

ACTIVITIESPERFORMED(<Process>;<Activity>;<User>;<Status>)

▪Average elapsed time of activities: Returns the average elapsed time in minutes of an activity execution.

Syntax:

AVERAGEELAPSEDTIMEOFACTIVITIES(<Process>;<Activity>;<User>;<Status>)

▪Average working time of activities: Returns the average elapsed time in minutes of an activity execution.

Syntax:

AVERAGEWORKINGTIMEOFACTIVITIES(<Process>;<Activity>;<User>;<Status>)