This is one of 4537 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.


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.


Project period01.12.2006 - 30.04.2007

Have we sparked your interest?

Joachim Schütter

Key Account Manager

Jetzt Kontakt aufnehmen

Contact now

Download file