Excel Data Import and Report Generation

Seeking a freelancer with experience in manipulating and analyzing data in Excel. The main task involves importing data from a comma delimited file. There seems to be data fields such as Date, Customer Name, and Product Name, however the client has not specified the exact fields to be pulled. Once the data is imported, certain mathematical computations will have to be made, although the specific computations are not specified by the client at this stage. There will also be requirements to format the data into a report. The exact requirements such as bold headers, color-coded cells or custom fonts and sizes have not yet been provided by the client. It will be helpful if you have previous experience dealing with ambiguous tasks and garnering requirements from clients. Your ability to improvise, adapt and overcome will be put to good use. There are multiple data files supplied daily. I have attached two different ones however the file structure is the same for every file. I also supplied a word doc with the instructions the columns needed and the formulas