Process Data Reports

Report on process data (PLC) without a Historian or Relational Database

In a matter of minutes you will be creating professional reports from PLCs and controllers by Allen Bradley, GE Digital, Mitsubishi, Modicon, Omron, Siemens and more.

Features

For users who need a low-cost, straightforward solution without a historian or relational database, this is a perfect choice. XLReporter's "Report As You Run" technology retrieves data from the PLC and adds it to the report on time e.g., every 15 minutes, or when signaled by an event e.g., weigh cycle complete.
  • Create reports as workbooks, worksheets, pdf and web pages automatically on time or on process events
  • Provide custom report names using fixed text, dates, times and values from PLC registers like the product or machine ID
  • Add data over time to the same report. Handle large blocks of data with ease (100,000 rows)
  • Add supplementary information such as comments and signatures, even to reports actively updating
  • Provide a "handshake" to the PLC when the report is updated
Report directly from process data without a historian or database

solution-xlreporter-process-snapshot-report.png

Snapshot Report

Snapshot reports are the simplest type of Real-time report, containing raw values and summaries from the PLC at a moment in time. When used as a dashboard, the reports can be viewed as they are being updated.

  • Display values in free format, columns or rows
  • Use arrays to retrieve blocks of PLC data
  • View the data on a mobile device
solution-xlreporter-process-summary-report.png

Summary Report

Summary reports are produced over a period of time. In this solution, a library template is used to report values every hour of a day. When a report is completed, a new report is created automatically.

  • Add values in columns and rows periodically e.g., every minute, 15 minute, hour, day
  • Position values in the report by placement e.g., place the values using the hour of the day
  • Provide intermediate calculations that use the PLC values
solution-xlreporter-annual-flow-summary-report.png

Annual Production Report

The annual production report contains the production for an entire year, organized in monthly reports. In this solution, a library template is used to monitor the annual production of a water treatment facility.

  • Position values in the report by placement ensures values are placed on the correct row of the report
  • Provide summary calculations
  • Share information between reports
solution-xlreporter-monthly-operating-report.png

Monthly Operating Report (MOR)

The monthly operating report is an example of a regulatory report. In this solution, the Monthly Operating Report from the State of Oklahoma is shown as the Excel file "as is" from the State's website. No redrawing, no touchup.

  • Import State forms to produce regulatory and compliance reports
  • Automate the update of reports that are currently updated manually
  • Circulate reports automatically every day and keep personnel informed
solution-xlreporter-batch-summary-report.png

Batch Summary Report

The batch summary report is an example of a report that is updated during a cycle e.g., while a machine is runnning or during a pumping stage. In this solution the PLC is monitored for the start of a batch at which point a new report is produced and updated periodically until the batch ends.

  • Update the reports periodically during a cycle
  • Name the reports using fixed text, dates and values from the process such as a Product Code or Machine ID
  • Organize multiple reports in a single workbook (using the batch name as the worksheet name)
solution-xlreporter-weigh-cycle-report.png

Weigh Cycle Report

The weigh cycle report is an example of a report that is updated each time an event occurs. In this solution the PLC signals a weighment is complete that causes the report to update. Comments are added to the report at any time to explain out-of-tolerance, indicated by background color of a value.

  • Update the report by adding a new row or column of values on event
  • Highlight exception by color coding
  • Add operator comments to the ‘live’ report without affecting the report update
solution-xlreporter-shipping-summary-report.png

Shipping Summary Report

The shipping summary report is an example of a report that is updated each time an event occurs. In this solution, the PLC signals a weighment is complete that causes a shipping label to be produced.

  • Update the report by adding a new row or column of values on event
  • Use hyperlinks to other report pages
solution-xlreporter-shift-production-report.png

Shift Production Report

The shift production report is an example of a report that is updated periodically in multiple columns. In this solution a daily report shows side-by-side shift performance for easy comparison.

  • Update the report by adding a new row values at specific columns
  • Use summary calculation across columns and rows of values
  • Display key performance indicators to determine good, average or underperforming
solution-xlreporter-mobile-snapshot-report.png

Mobile Snapshot Report

The mobile snapshot report is an example web report that is viewed in a browser. In this solution, report is updated periodically, overwriting the existing.

  • Produce web pages with absolutely no scripting
  • Automate the update of the web reports and view them on mobile devices and tablets
  • Use the FTP client to publish to a remote web server