This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4822 IT projects that we have successfully completed with our customers.How can we support you?
Personnel planning
Project duration: 5 months
Brief description
Revision of existing Excel planning tools for standardizing and simplifying the creation of personnel planning documents. One aim is to minimize time-consuming manual work by introducing suitable tools and procedures. Another aim is to standardize data entry and formatting, which should also increase the quality of the documents. The result is a comparison of manpower requirements figures from SAP BW and corresponding personnel plans from production, in a consolidated form.
Supplement
The system consists of multiple, interdependent Excel files that extract personnel requirement figures from SAP BW export files, on the one hand, and aggregate actual personnel values from production and consolidate it to time periods, on the other. It is possible to evaluate shortfalls or excesses in the form of tables or graphs. The components of the system are implemented on the basis of Excel 2000/2003 with the help of Excel VBA.
IT project data
- Industries automotive industry
- Specialist tasks manpower requirements planning, personnel planning
- DP tasks customised software new development
- System environments Client/Server
- Procedure model iterative procedure
- Programming languages VBA
- Development and test tool Visual Basic Editor
- Operating systems Windows 2000, Windows XP
Project period01.12.2006 - 30.04.2007
Customers who trust us
