SCADA reporting and automation
Reporting via Excel for an international fire safety firm
Our client wished to provide more detailed and immediate feedback to trainees based on SCADA outputs.
The brief
The client’s fire training simulators deliver intense live-fire training allowing firefighters to battle realistic situations. During the training, the firm captures real-time sensor data at millisecond level, recorded in a SCADA SQL database.
This sensor data is then used to monitor trainee performance and deliver feedback. Their previous SCADA reporting software was costly and was not tailored to their needs.
The result
After the successful demonstration of a working prototype to demonstrate, we developed a system in Microsoft Excel, using custom VBA algorithms to automatically process the data produced by the client’s SCADA system
-
Dynamic and interactive charts and reports
-
Graphical representations of training sessions
-
Improved speed of feedback in the field
-
More engaging and effective training
-
Avoided generic SCADA software