Technip's Supplier Template Saves Time and Money

By: Access Analytic  05-Oct-2011
Keywords: Training, Excel, Spreadsheet

Technip, a transnational construction, engineering and project management firm, needed a standardised and fool-proof Microsoft Excel template to gather vital information from its large network of suppliers.

After being contracted to build a LNG processing platform, Technip was in a position of needing to secure detailed information on the inventory of parts that each of its suppliers has access to.
The challenge of this project was to build a customised Microsoft Excel template that could be used to collect the required information. The template had to be:

Highly secure – the structure and functionality of the template had to remain unaltered despite being used by over 200 different suppliers.

Highly comprehensive – the template had to be capable of containing and reconciling millions of pieces of data.

User friendly – the template had to be simple and clear enough for suppliers to use without having to contact Technip for help.

How Access Analytic Helped

We used Microsoft Excel functionality and Visual Basic programming to build a customised and robust data collection template. The template contained the following features:

A step-by-step guide – individual suppliers were only required to complete certain sections of the template so functionality was created to direct each user only to the relevant sections. 

Warning notices – were created to alert users if there were sections of missing or incorrect data.

High security – the only sections of the template that users can alter are those where data has to be entered.

Business Benefits

The template will save Technip significant time and money because information that is entered into the template will be correct and properly structured. The risk of error is greatly reduced due to the structure and security of the template.

The project required us to build part of the template and then to provide training to Technip staff so that they could complete the project. This up-skilling of Technip staff represents a very significant business benefit that will exist over the long term.

Keywords: Excel, Provider of Services, Spreadsheet, Training

Other examples of best work from Access Analytic


A New Business Tool for Rostering Staff

Access Analytic delivers a tool that enables Leighton staff to keep track of personnel capabilities and availabilities so that they can design rosters to meet the contractor requirements of the Gorgon project.