Optimizing Data Transfer Process Across Different Applications
BKOAI automated data transfer and calculations across multiple furnaces, reducing manual effort and improving adaptability to data changes
Goals
- Automate calculation and transfer of data across multiple industrial furnaces.
- Eliminate manual entry for thousands of unique operational tags.
- Establish a secure and organized asset structure for calculation results.
- Accelerate the project timeline from several months to a shorter execution period.
Challenges
- Managing calculations across nearly twenty active industrial furnaces.
- Handling thousands of tags with unique calculation formulas for each furnace.
- Relying on manual calculation methods estimated to take several months of effort.
- Adapting to frequent changes in tag names or data source prefixes.
Solutions
- Developed integration with an Excel mapping sheet to automate data extraction.
- Built tailored, code-based formulas adapted to each furnace's specific operations.
- Implemented an organized asset tree to structure and store calculation results.
Results
- Reduced data processing timeline from several months of labor to one month.
- Automated data extraction to eliminate manual input across thousands of tags.
- Enabled seamless updates when changes were made to over two thousand tags.
- Secured operational data through structured access control and asset mapping.
.svg){kind=small}
.svg){kind=small}
.svg){kind=small}
