Advancing time-based forms, users can now create custom forms. A wide range of forms is now supported such as maintenance,
operator logbooks, laboratory, operator rounds and diagnostics.
Custom forms are created by the user or from events in the process such as the exceedance of a runtime or the occurrence of a critical alarm.
Workbook to XML
Save all or part of a report to XML and provide report data in a consistent format to third party products. This feature is especially relevant in Water and
Wastewater treatment since the electronic submission of the eDMR (electronic Discharge Monitoring Report) in XML format is acceptable in most States.
To ensure the structure of the XML complies with the requirement, an XML designer is provided for the development of the XML structure. In the context
of Water treatment, this designer is applied to submission form so that the resulting XML conforms to the requirement of the State.
A new category of Management called Functions provide powerful industrial functions.
Result from Workbook
Avoid needing to overload a report with “background” sheets that contain calculations, lookup tables and so on, by providing them in separate “background” workbook.
This function passes parameters from the report to the background workbook and receives the result for the report. For example, store the Giardia lookup tables in
the background workbook and use it to populate the report.
Number to Bits
Expand a number in a cell to a set of cells containing the binary equivalent (1/0). For example, a number may represent an alarm mask where each bit represents an alarm.
Timestamp conversion methods such as converting a timestamp from UTC to local time, considering daylight savings.
Zero pad the cell content to a specified number of characters.
ISA 18.2 Alarm
The alarm KPIs can be filtered by Operator Position, Module, Attribute and Alarm Duration. The alarm duration is used to show the condition of the alarm system without
the chattering/fleeting alarms included so that users can understand the outcome of the improvement if these alarms were removed.
The alarm application provides the export of the KPIs to a database so that improvements to the alarm system can be tracked over time.
Text File Drivers
Advanced features to support text files that do not conform to the common file structure of the first row containing the row headings and the remaining rows representing the data.
Provision to support user friendly column names is included.
A Database Consolidator to take data from various sources and log that data to a relational database for reporting purposes. This feature could be used to periodically filter records
from one database and save the result in another.
Web Portal Features
Web client download on-demand reports in both Excel and PDF format providing a mechanism for users to share their reports. In addition, the layout of the template list is user selectable.