Thales, Microsoft Excel, VBA Developer / Consultant - Microsoft Excel, VBA
Company: Thales, Deutschland
Technology: MS Excel, VBA.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Jan 1990 – Dec 1991
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.
- Development of a dynamic project budgeting.
- Integration of various sources.
- Calculation of various key figures.
- Integration and comparison of previous month.