Expansion and optimization of Excel macros to simplify the operation of external interfaces. Different Excel files can be converted using macros.
Supplement
The application has user-friendly menu prompting for semi-automated identification of file versions that have "grown" over time.
Subject description
The plant constructor enables its external suppliers, who are linked into the supply chain, to conveniently edit lists using MS Excel. The macros serve to automatically convert Excel data into a defined interface format that can be used to import the data to the application itself.