The scenario

Philips' Lighting division needed a Field Service Report developed in Excel, including a feature for their Field Engineers to capture clients' signatures within the Field Report. They had previously used Topaz hardware and software for this but needed hundreds of these for a new intake of Field Engineers, so they requested some creative thinking to come up with a less expensive way to achieve this.

Our cost-effective and elegant solution perfectly fitted the bill.

Philips Lighting is a global market leader with recognized expertise in the development, manufacturing & application of innovative (LED) lighting solutions.

Their clients include Chelsea Football Club, Sunderland Keel Square, Allianz Arena, Munich, Bullring Shopping Centre, Birmingham, Debenhams Oxford Street, London, Imperial College, London, Spire Hospital Leicester and many more.

“I’m glad we’ve found this work around, thanks again for your hard work”

“I used it this morning on a site visit and it went smoothly“

Tony Holden, Technical Field Services, Philips Lighting

The Solution

In discussion with Philips Lighting staff we designed and created an interactive Field Report form in Excel with drop-down selections, automatic generation of new sheets where required and macros to save the report in PDF format for the client and an option to automatically send the Field Report to the Field Engineer’s email system.

The method of capturing the customer’s signatures using the laptop’s touchpad or a tablet’s screen was initiated by Philips Lighting and we came up with some programming code which integrated Microsoft Paint as the method for the signature to be input.

All-in-all a smooth, cost-effective solution.

PC Tamers outlook training sussex,word training sussex,outlook course sussex,word course sussex,excel course sussex,help with powerpoint sussex,powerpoint course
PCTamers Pricing Case Studies Videos Contact Us LGHHCE Store

Microsoft Office Productivity Specialists

Support, Training & Automation that . . .

Inspires         Saves time, money & effort        Entertains