For this project, I will provide one input file in excel format which has 37000 rows (see attached input sample document). I will need a program to convert the input file using the logic defined (see attached logic document). The program will generate an output file which includes 2 tabs (see attached output sample document).
Because the input file contains 37k records, the program will need to be optimized in order to minimize the processing time.
the logic document is my best attempt to describe the logic, if you see a better way and achieve the same result, it is ok with me.
Additional Project Description:
05/03/2010 at 13:28 EDT
I forgot to mention that I will need to run the program several times, on other files with the same format.