Measuring efficiency and productivity is one of the main purposes of a reporting solution.  Typically, these key performance indicators are calculated from measured values.  The values required may not be readily available in your system’s data server.

XLReporter provides a number of specialized aggregate functions to generate productivity and utilization indicators directly from a real-time Server such as OPC:

• Profiles : Based on the state changes of digital values, i.e., ON or OFF.  From the state change, the total number of ON states, OFF states, ON duration, OFF duration and more is calculated.  This information is ideal for equipment utilization and downtime reports.
  

• Difference : Based on the difference of consecutive samples.  For example, to calculate the daily pumpage from a totalizer that represents the total gallons pumped, the difference in values from the start to the end of the day is calculated.
  

• Statistics : Based on the monitoring of real-time values over time.  A multitude of calculations, such as minimum, time of minimum, total, average and more is provided.

The Aggregate Designer provides a complete environment for configuring aggregate functions.  This configuration includes, amongst other settings, the real-time source of data for the aggregate calculation.

Configuring Profiles for a Utilization report

The aggregate scheduler determines when and how often the aggregate is calculated.  This calculation can be performed on time, event or as a combination of both.

Scheduling aggregates for calculation

Once the aggregates have been defined, they can be inserted into your reports to provide vital key performance indicators on your process.  In the following example, the utilization of pumps over each hour in the day is reported, the information displayed includes on/off counts and on/off durations.

Hour Pump Utilization over a day

© 2006 SyTech, Inc. All Rights Reserved.