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.
Inquire About This Product
basic information
【Summary of Other Cases】 ■Background - The developer of the system managing the outbound shipments from warehouses nationwide has resigned. - Subsequently, the core system was replaced, changing the file format that serves as the basis for processing. ■Effects - It became possible to produce correct results from the new data. - Other existing functions continued to operate without being affected, as before. - Documentation was created in preparation for similar needs in the future. *Details of the case can be viewed through the related links. For more information, please feel free to contact us.
Price range
Delivery Time
Applications/Examples of results
*The details of the case can be viewed through the related link. For more information, please feel free to contact us.*
catalog（1）
Download All Catalogs
Company information
Our company is working on improving operational efficiency by utilizing an information system that combines Excel and macros (VBA). First, we re-express the business in a simple manner, keeping in mind that work can be done using familiar Excel, and we realize the development of an information system that incorporates macros (VBA). Since our founding, we have handled over 1,800 cases, and we are a group of specialists skilled at understanding unique needs that "the in-house IT department does not address" across various industries and business types.