Company: Thales, Germany
Technology: MS Excel, VBA.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Jun 2019 – Sep 2019
Cost: no details
Development of a complex project control using Excel and VBA. Project data is read into a template, dynamic tables are created based on the selected period, imported data is refined or serves as a basis for calculation and is then entered into the dynamic tables, which finally represent the report regarding the individual projects. The reports are complex, multi-level tables, which are all dynamically created based on the selected time period. Not only were the tables created dynamically, but the calculations are dynamically based on the selected time periods and are then entered into the reports. After the reports have been created, the TARGET data of the previous month are compared with the ACTUAL data of the previous month and replaced by the ACTUAL data. Thus, a comparison between TARGET and ACTUAL is possible. Realisation by means of Excel and VBA.
- Develop dynamic project budgeting.
- Integration of various sources.
- Calculation of various key figures.
- Integration and comparison of previous month.