Development of a labor management system for streamlining employee attendance and departure management tasks.

Although the system usage frequency is high, the data volume does not exceed one million records, so development using Excel macro language was adopted. The input load during data registration has been significantly reduced.

■Trigger Due to the increase in both clients and internal staff, there were aspects that could not be handled by the current labor management software. Since the data registration process was very cumbersome, there arose a necessity to simplify operations and consolidate the various operational reports that were previously viewed into a single type, leading to the consideration of developing a custom system. ■Background of Implementation As a premise, since we are not dealing with an enormous amount of data, we considered whether we could address this with a low-cost system development based on Access or Excel. In the case of building with an Access application, it would require time (duration) for data migration preparation, such as table design. However, in the development using Excel macros, there was a significant advantage in terms of delivery time and cost, so we chose to build the system using VBA programming.

Labor Management System