MS Excel input tool for investment database

The structure of the csv file and the relevant testing logics and validity lists are specified by the customer. These logics are implemented by PTA and a suitable entry screen and a control screen are created. The necessary functionalities are implemented using VBA code or standard Excel functions (table functions, validity checks). The tool is configurable to the greatest possible degree, so that, for example, compulsory fields, disabled fields, selection lists, and the allocation of testing logics in tables can be configured. In the already distributed tools, these tables can be updated using an update function from a template stored on the company network.