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 4813 IT projects that we have successfully completed with our customers.How can we support you?
Transferring the previous year's values
Project duration: 24 days
Brief description
Creation of a tool with MS Excel/VBA that, applying specific rules, transfers previous year's values from one file for each group company to one new file for each, aggregating individual values in the process, if necessary.
Supplement
The tool "searches" for the necessary source files and opens each source file together with the template for the target files. In the next step, a control table maintained by the user is used as the basis for identifying the necessary data, calculating the previous year's values, entering this in the correct place in the template target file, and saving.
Subject description
Due to the conversion of reporting, data for the previous year from the reporting files has to be transferred from the "old" structure to a "new" template. The application created here automates this process for the customer.
IT project data
- Industries automotive industry
- Specialist tasks Controlling, Reporting
- DP tasks customised software new development
- System environments Client/Server
- Procedure model PTA project manual
- Programming languages VBA
- Development and test tool Visual Basic Editor
Project period06.05.2008 - 30.05.2008
Customers who trust us
