Shipping Management System Product List and Ranking from 17 Manufacturers, Suppliers and Companies | IPROS GMS

[Case Study] Handover of Existing Excel Macro <Quick Response>

An Excel system left by the developer! Introducing a case where we analyzed the internals and extracted the target logic.

We would like to introduce a case of support for the handover of existing Excel macros that we conducted for the service industry. The issue was that the developer of a system managing outbound shipments from warehouses nationwide had resigned, and subsequently, the core system was replaced, resulting in a change in the file format that serves as the basis for processing. We implemented documentation by replacing only the relevant parts and adding comments. After that, we confirmed that using the previous month's data produced results identical to manual processing, allowing it to operate smoothly in production just as before. [Case Overview (Partial)] ■ Industry: Service ■ Scale of Use: 10 to less than 50 people ■ Problem Solved: Personalization *Details of the case can be viewed through the related links. For more information, please feel free to contact us.