Home
Reporting
Create state of the art project reports without limits.
WinCC OA Excel Report
WinCC OA Excel Report, is a program extension of MS Excel for integrated data evaluation and protocol generation with WinCC OA archive data. Reports can be created with the WinCC OA Excel Report. Templates are used for the reports. If a report is to be generated over a defined period of time, the system accesses the template and automatically fills it with data from the process database. Reports can also be created, printed and saved on a scheduled basis without requiring user access.
Configuration
Report design - Charts
Trend examples in WinCC OA Excel Report

Version Information
Release Notes, Update information, Certifications and Frequently Asked Questions.
Concepts
Your first step into modern and powerful process visualization.
Deployment
Topics, you need to know, before using WinCC OA.
Security
Go beyond the norm in cybersecurity.
Engineering
Powerful tools for easy or complex engineering tasks.
Data Management
Classify, structure and archive your data.
Business Logic / Control
Endless possibilities in data processing for your projects.
Data Visualization
User interfaces, Trends and Reports for every purpose and device.
Southbound Interfaces
The process connection to the actual machines/sensors.
Northbound Interfaces
Your portal to the cloud or supervising systems.
Web Connectivity / Network Interfaces
Data exchange, APIs and web technologies
User Management
All about authorization, authentication and login-customization.
Availability
How to get your system uptime to the maximum.
Reporting
Create state of the art project reports without limits.
- XML Reporting
  The Reporting feature allows you to create reports in XML format. Therefore, add the WinCC OA Reporting Manager to your project. Historical data can be queried via the Reporting manager by using the SOAP (Simple Object Access Protocol) interface. SOAP is a network protocol which allows sending data in XML format between systems.
- WinCC OA Excel Report
  WinCC OA Excel Report, is a program extension of MS Excel for integrated data evaluation and protocol generation with WinCC OA archive data. Reports can be created with the WinCC OA Excel Report. Templates are used for the reports. If a report is to be generated over a defined period of time, the system accesses the template and automatically fills it with data from the process database. Reports can also be created, printed and saved on a scheduled basis without requiring user access.
- REST Reporting API
  The REST Reporting API is integrated into the Standard web server and can be activated via the config entry enabled in the [restReporting] section.
- Insights Hub Connector
  The Insights Hub connector allows you to upload data from WinCC OA to Siemens Industrial Cloud Insights Hub and to process data. WinCC OA supports the integration of SCADA data from WinCC OA to Insights Hub.
Addons
Useful tools and enhancements for special demands.
Reference Tables
Detailed and extensive content for special project adaptation.
Videos & Tutorials
Explore the capabilities of WinCC OA with our carefully selected collection of video tutorials and guides.
WinCC OA Documentation
Basic information about terms and functions within the documentation.
Disclaimer
A brief clarification of liability exclusions or legal notices.

Trend examples in WinCC OA Excel Report

Examples of line charts

The following set of illustrations are examples for possible chart designs.

The screenshot Water supply report - trend line shows a template file "water_supply.xlt" containing a trend line and its mathematical approximation as a fourth order polynomial (best fit). This type of "trend line" can be calculated in Excel. You do not have to display the automatically calculated formula - it is optional!

The consumption history for the water supply system is displayed in the Trendline-Frequency diagram.

Figure 1. Water supply - worksheet containing a set of values with trend lines.

Figure 2. Set of values with frequency distribution