We are company that processes CDR reports from stores. We receive reports from various stores. Each of these contains a series of records detailing the amount of sales that store has made within a period. Each of the online stores sends us their reports in a different format, we call these “Raw” files as they are unprocessed.
The purpose of the project to read the inbound reports in various formats and convert them into our standard format. We call this format the RSI format. The program must be able to open spreadsheets in 3 separate defined formats and then convert them into spreadsheets in RSI format. The logic for the conversions is attached. Also we attach some sample code and index tables.
We use Excel version 2003, an old version. So no page can get longer than 64k lines.
I anticipate the VBA coding will be 140-250 lines long.
This is the first phase of a more complicated project. If you do well, LOTS more work. Programmers must have a very good level of english and have Skype. Must must be VERY experienced in VBA and Excel. Pls highlight your skills in a PM or response.
Also pls detail time required to complete assignment