This is one of 4681 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.
Overview
- Industries automotive industry
- Specialist tasks Controlling, Reporting
- DV tasks customised software new development
- System environment Client/Server
- Procedure model PTA project manual
- Development/ test tools Visual Basic Editor
Project period06.05.2008 - 30.05.2008
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
Service
Industries
© Copyright 2025 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
