FirstOPNET - Production reports
✔ Manual or automatic reports
✔ Automatic report acknowledgement
✔ Manual report acknowledgement
✔ Corrections by authorized personnel
✔ Possible to return to original data
✔ Search tools to find related production
✔ Export to MS Excel for external analysis
✔ VBA scripts for special data
✔ Printout as table or graph
✔ Follows rules for environmental reports
The report generator is general purpose and can be used for all production statistics based on data stored in the SQL server. A report will display production data for a day, a month or a year.
The screen display is in a standard table format shown above. You can display real and logical data in the same report. The printout is either in the form of a table or graphs.
Report setup
+The production data in the reportScripts in VBA if necessary
+Automatic or manually generated
+Type of acknowledgement required
+Level of password protection
You save the report setup under a given name in the SQL server.
Creating production data for SQL
If you want to add a signal value to the production database, you simply enter the signal in the local FirstOp Client (“the source”). You click “logging” and specify the time period. This is done safely during running, so you do not have to stop the client.
As soon as you have done this, the storage to the SQL will start. The FirstOp Client saves data to local files. The global SQL Logger will then transfer data to the SQL server as soon as there is a connection. If the communication to the SQL fails, the files are buffered locally several months if needed.
Production data (Real valued signals)
Data are assembled in high time resolution and stored as SPC measures for a specified time unit:
Each data storage in the SQL server includes four measures of data.
Maximum value
Minimum value
Mean value
Standard deviation
The max/min values guarantee that also fast signal changes are detected.
Production data (Logical valued signals)
The logical signals are stored as time/change measures for each period:
The data stored for each period is
Time signal is true
Time signal is false
Accumulated Time signal is true
Accumulated Time signal is false
Number of changes false->true
Number of changes true->false
From the production data you can read e.g. running time for a process object or how many times it has been switched on/off for a specified time period.