SCADA Reporting in ExcelAutomation of SCADA Reporting in Excel for International Firm
An international fire training company wish to provide more detailed and immediate feedback to trainees based on SCADA outputs. With locations in 40 countries they also needed to provide outputs in different languages.
The client’s fire training simulators deliver intense live-fire training, replicating the heat and flames of a real fire emergency and allowing firefighters to battle situations they would find in real-world emergency situations. They capture real-time sensor data at millisecond level which is output to a SCADA SQL database.
This sensor data is then used to monitor how trainees are performing and to deliver feedback. Available SCADA reporting software was costly and not specific to their needs.
Following an initial discussion period by phone, e-mail and remote screen sharing, we began with a prototype to demonstrate what could be done and to ensure that it had got to the heart of the client’s brief.
Next we developed a system in Microsoft Excel, using custom algorithms written in VBA, to automatically process the data produced by the client’s SCADA system and deliver:
- dynamic charts and reports;
- graphical representations of what was happening during a training session;
- improved speed of feedback in the field.
As a result, the client could give much more immediate and usable feedback and analysis to its trainees – making training sessions much more engaging – whilst also saving on the cost of other SCADA reporting software.