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: