Gemco Ltd. - UKAS-accrediated Calibration Certificate system
Gemco's web application 'CertDB' - as used at their UKAS-accredited Winsford laboratory - is our largest
bespoke project to date. While it completed in 2015, the project was such a success that Pillar were invited to develop the mobile
front-end for Gemco where an engineer completes an electronic Data Input Sheet whilst on site.
Before the mobile edition, however, Data Input Sheets were manually keyed from paper sheets by users at the lab. These were connected to an Engineer
Call Record generated by Gemco's call system. The Data Input Sheet gathered the basic details of the garage equipment being calibrated and then these
would be validated along with pre and post calibration readings. Gemco carry out some 90,000+ such calibrations each year.
This process includes a 360degree view of the gas/smoke analyser calibration procedure being used by the engineer as well as the ambient settings, the
emissions test machine, the engineers' variety of tools used (all independently also calibrated) and of course the results of the pre and post calibration
A successful calibration will result in the UKAS-accredited certificate, all others would be marked as under query for re-processing,
correction or verification by authorised staff.
Below is the web application view of Engineer's Instrument Sets and the Instruments within the selected set (for that Engineer), alongside other currently
available sets. The button controls in the middle of this page retain focus on the current Engineer, allowing the user to switch easily from that
Engineer's Lens Sets, to Tools, to Gas Bottles, to the Engineer record itself...
This page has multiple edit zones, conditional colour-formatting and drag-and-drop features.
This is an entirely unique project which would be unavailable as an 'off-the-shelf' solution, but Pillar are pleased to have been developers
for this solution since the start, way back in mid-late 1990's. We developed the original Windows application, switched the back-end database
to MS SQL Server, completed this switch to a web-based browser solution (while disconnecting it from its former partner solution) and, in
2016 are now working with Gemco (part of The Stenhøj Group) to deliver a tablet-based mobile edition of the Data Input Sheet.
Throughout this period of development, enhancement and change, Pillar are delighted to have also provided full support from our Helpdesk
as part of the service.