Adaptation and expansion of an existing Microsoft Access solution. Originally four files were imported, the data were refined and then evaluated. The evaluations concerned the distribution of NEF in Germany. The user interface was already available, implemented with Microsoft Access and VBA; this has been made a bit more modern and clearer and the new functionality has been integrated. In the new application, only two files are now imported and the data is evaluated on the basis of the two files. Here, too, the import using VBA follows, the user interfaces have been adapted to the two new files and a large number of plausibility logic has been implemented. The evaluations concern the stocks and the stock values ​​of the individual employees in distribution.

• Adaptation and expansion of an existing application.
• Import of 4 Excel files (network).
• Consolidate the data (Excel / VBA).
• Complex calculations in temporary Excel tables.
• Creation of dynamic result tables.
• Creation of dynamic tables (overviews in the respective tables).
• Integration of complex effort and time calculations.
• Integration of complex financial calculations.