SCADA reporting and automation 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.
Automated SCADA analysis
We wrote custom algorithms to automatically process the data produced by the client’s SCADA system and turn the results into useful feedback reports.
Enhanced language usability
To allow the company to use the system in multiple countries, we incorporated a translation model that allowed end users to understand reports in their native language.
Speedy delivery
Due to the nature of the client's business—fire safety—this project required a fast turn-around of just two weeks. The client was particularly thankful for our quick response.
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 and deliver:
- Dynamic charts and reports
- Graphical representations of training sessions
- Improved speed of feedback in the field
The firm can now provide immediate and usable analysis to its trainees, making sessions more engaging and effective whilst saving on the cost of generic SCADA reporting software.
Featured case studies
We saved time and improved efficiencyfor AIM Group – a busy steel and pipefabrication company in Falkirk, Scotland.
Excel modelling helped us to create ahighly effective web app, enabling ourclient to grow from startup to £5m+.