Business solutions for you portfolio


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.
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52


[email protected]

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.