One of the first projects I got in the company, that I worked at that time, was to observe and automate a process done for a VIP client (automotive industry giant). This process in essence was done by one technician and two key accountants in a period of 2-3 weeks, dependent on the amount of updates and corrections needed. Still it's a big data company, so huge amount of data is in game. First the technician creates an input file for the legacy app and feeds the process with it. Of course he gets the instructions from the key accountant (better to say from the client). After that the app do the calculation for a day and spit out some 35 xls files with 5-8 sheets per file, full of data. That is the point where the fun begins and I jump in. The end result was to be organised in 5 xlsx files wit 4 sheets per file. They should contain sums, groupings and sample data presentation all extracted, recalculated and organised by dynamic rules set by the client. And when I say dynamic I mean
"I know one thing: that I know nothing." - Socrates