Extension of an Excel template to capture complex price formulas
Project duration: 5 months
Brief description
To also capture above-standard complex price formulas with a given Excel template the file is extended with the appropriate fields which make use of complex VBA logic to calculate the resulting price formula. The XML files used to output the generated data are also adapted to the new requirements.
Supplement
An existing Excel template which is used to capture special transfer products during the order reception process is to be extended to also allow for acquisition of above-standard price formulas. Those price formulas are calculated from user inputs employing a complex VBA logic. The whole template serves to generate a request XML which also requires thorough VBA adaptions to accommodate the new fields and functions.