← All case studies

LanXess

Web Application

An interlock management web application replacing a maze of spreadsheets.

Visit website
Client
LanXess
Technologies
SQL Server, ASP.NET MVC Core, Microsoft IIS
Overview

Project highlights

  • One source of truthA single web application replaced a set of Excel spreadsheets.
  • Built for big data setsSorting, filtering, and presentation of the data front and center.
  • Every detail in one placeThe Device Detail screen shows each device's related records.
  • Safety rules documentedInterlocks that prevent one device from operating when another condition exists.
Before

The challenge

LanXess makes chemical products in large production facilities. Across those facilities, thousands of equipment interlocks, the rules that prevent one device from operating when another condition exists, had been tracked only in an unwieldy set of Excel spreadsheets.

LanXess asked J Street to document those interlocks, and the devices they govern, in a single tool.

After

What we built

J Street built the Interlock Management application, a modern web application that stores and documents data on thousands of chemical engineering devices and the interlocks that govern them.

The application was designed to present large, complex data sets, maximizing sorting, filtering, and presentation of the data. Each device can have child records of various types, all shown in detail on a Device Detail screen.

Inside the system

A closer look

LANXESS screenshot: Interlock Management
Interlock Management
The Interlock Management database application was designed to present large, complex data sets and maximize sorting, filtering, and presentation of the data.
LANXESS screenshot: Device Detail
Device Detail
Each device can have child records of various types, displayed in detail on the Device Detail screen.
“

The outcome

How it turned out

  • Thousands of devices and interlocks documented in one web application.
  • Interlocks are no longer tracked in Excel.
  • The application improved the company's vital safety processes.

See more of our work for chemical manufacturers.

Free 30-minute consultation

Tell us about your project and we’ll be in touch within one business day. Or call us directly at (425) 679-6206

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.