Case study 

Lab Data Tracking System
for
Manufacturing Company

bg consulting pagexcf.jpg
The Challenge
  • Automating manual tasks

  • Create data export templates

  • Standardisation of data entry

The Solution
  • Development of a master template to create customised tracking files

  • Automated error-proofing features

  • Extensive documentation of system use and management

  • Hyperlinks to files

  • archiving completed trackers in structured folder directories

The Impact
  • Centralisation of template creation function

  • Better control over the fields and scope of templates

  • Error-proof input systems

  • Structured and recorded repository of files

Read full Case Study
Challenge.png

The Challenge

 

Our customer is a leader in the composites industry with one of the largest full-service networks of custom moulding and assembly facilities in North America. Senacea Ltd. provided a solution for the improvement of the Laboratory Information Management System (LIMS) data export templates.

 

The evaluation led to a project of development and implementation of the master template which allowed the automated creation of customised testing trackers to gather various data and including computations as well as custom formatting of units of measurement.

The Solution

Solution.png

Senacea began by evaluating existing tracking templates for opportunities to automate, error-proof and standardise their use and created a bespoke solution that will be managed in-house.

 

We configured an automated master track template to meet the requirements of the client with the following features:​​

Development of the master template allowing to manage and create customised tracking file templates

Ability to define and modify file locations, fields, data formats and validation and computational fields

The functionality of saving, loading and modifying template settings

Hyperlinks to all created templates

Automated error-proofing features in created templates (incomplete input reminders, accidental close prevention)

The functionality of archiving completed trackers in structured folder directories

Automated row adding to the table once single sample data was added

Extensive documentation of system use and administration

Support in implementation and with testing

 
Benefits.png

The Project Impact

The new ​Data Tracking System created by Senacea has received very positive initial feedback from the team using it. After the implementation, the team now benefits from:

Centralisation of template creation function

Better control over the fields and scope of templates

Error-proof input systems

Structured and recorded repository of files

 
Increase your efficiency & profitability with our industry-leading VBA Consulting Services.

Empower your team by removing repetitive work, standardising document production and leveraging VBA macros to intelligently automate work

Automation.png