One more spreadsheet: how we calculated raw material requirements using 1C data

The article describes the experience of automating raw material procurement planning for a manufacturing company producing adhesives and sealants. Previously, employees spent significant time manually processing data, exporting reports from 1C into numerous Excel files for consolidation and analysis. The development team implemented an analytical solution that replaced manual labor with an automated calculation of raw material requirements. During the project, the team faced the challenge of choosing between using recipes and alternative data sources, and conducted extensive verification of the results with experts who previously performed the calculations manually. The article highlights the importance of moving from fragmented spreadsheets to centralized analytical systems to improve business process efficiency and production planning accuracy.