Parse raw Data into logical format

We need to Parse Raw Text Data from Microsoft Excel files into logical data. We will put the data into whatever format or software you desire to make the process less complicated. The process of parsing the data will be somewhat easy once you have an understanding. However please consider 1-2 days learning and discussion time. ## Deliverables Attached is a zip file with raw data and the same data organized. What needs to be done is that the raw Data has to be put into a format that we can use to calculate the Summary. So to reconfirm, we will be taking every line of data and breaking it into pieces to be used for calculations. If you want to see how many fields there are for the calculations, Please review the Summary file. For every field you see we will have the exact number in your parsing. * * *This broadcast message was sent to all bidders on Tuesday Oct 5, 2010 4:05:44 PM: Posted a zip file of the raw data example, and also a file with the data after it has been compiled. We will need a step in between that will be what this job is. Your step will be to take the raw data and put it into the fields so that we can use it to calculate the final Summary