- Corso Systems
- Production Data Management System for a Diatomaceous Earth Processing Company
Production Data Management System for a Diatomaceous Earth Processing Company
A leading diatomaceous earth processing facility was storing some of its production data in Excel spreadsheets.
After using this method for a while the amount of spreadsheets on their server made it difficult to find specific information in a timely manner.
The best remedy for this problem was to move to a web-based solution. This approach provided a centralized database to store the data and an interface for authorized users to enter, edit, and view the data.
Our staff worked with a large diatomaceous earth processing facility to implement a web-based system to store and analyze its production data.
We used the client's existing paper and Excel based tools to develop a database schema for the data.
With the database in place we developed the web-based front end to enter new data and access existing records. In addition to data entry forms the interface included automated reporting functionality allowing users to select a date-range and/or specific process areas to view production data.
The system generates nightly reports and sends them to key personnel automatically.
In addition to tabular views of the data, the system includes pareto charts to track downtime and product loss reasons for a range of dates as well as process OEE.
The system also includes the ability to automatically gather and store data from the process historian.
- ASP.NET MVC
- FactoryTalk Historian
- SQL Server
Centralized database of production data
Advanced analysis tools for production losses, downtime and OEE data.
Automated reports sent out to key personnel on a regular basis.