Reporting

Excel Reports
With the help of Excel Reports, it is possible to evaluate process data not only via the control system’s workstations but also via the office workplaces connected to the network. The complete scope of functions provided by a modern spreadsheet is available for the evaluation of process data. The functions additionally provided by IDS can be selected via integrated icons in MS Excel, ensuring quick and comfortable operation.
Reports can be interactively created and individually adapted without much effort by means of predefined tools (wizards) and a dialogue-controlled  formula editor. Frequently required evaluations for the different application areas, e.g. wastewater reports for sewage plants in accordance with ATV and ÖWWV standards, the visualisation of load curves and regression trends in gas applications, ROB reports in accordance with the specifications of ATV-DVWK-M 260 etc., can be handled with the aid of special industry-specific dialogues.
After editing these data, they can be stored either locally on the MMI or centrally on the server(s), thereby ensuring efficient off-line parameterisation and back-up documentation.
IDS Excel Reports are “active reports“, i.e. the process parameters used in the reports can be updated at any time via simply clicking on the menu bar. The “on-line updating” of process data can also trigger off automatic cyclical updating based on the archiving pattern.
The Excel Reports are completely integrated into Microsoft Office 2007.

On-Call Duty Planning
Companies whose control rooms are not continuously staffed require long-term computer-controlled planning of on-call duty schedules. In this context it should be possible to directly assign the available means for alarm output (voice message, SMS etc.) to the staff on duty.
The on-call duty planning function in MS Excel as part of HIGH-LEIT fulfils all these requirements. Similar to the IDS Excel Reports, the on-call duty planning function enables operators to view the schedules or to enter planning data via workstations that are not part of the control system. On-call duty schedules can be created via pre-configured Excel sheets supported by dialogues (cf. IDS Excel Reports). For this purpose, it is possible to select different views (person- or data-specific).
The data are kept exclusively in the control system database. Data exchange takes place online via ODBC to enable the alarm system to have immediate access to the data. MS Excel merely serves as a user interface for a better and clearer visualisation of the information.
The on-call duty planning function is completely integrated into Microsoft Office 2007.