CREATION OF EXCEL SPREADSHEET WITH MACRO/VBA CODE TO AUTOMATE -USING CSV FILE AS INPUT

_Background to the project_ This project is sought on behalf a manufacturer of automotive products. We are looking to seek proposals/bids for the creation of a Microsoft Excel macro which will automate a data and manipulation task which is currently carried out manually. For more information please read the attached RFP for technical details. Also a sample CSV file is attached which should be used as sample input file. The vendor should be able to demonstrate that he can successfully extract through the spread sheet macro in any order, combination etc. and have produced the desired result as outlined in this RFP. The vendor should ensure that he/she has conducted enough testing to ensure that any file which confirms to the conventions within this RFP can be extracted with the same degree of success. _TIMING REQUIREMENT_ We would like to have all proposals by no later than 21ST AUGUST 2012 17:00PM GMT so we can make a decision to go with a specific vendor by 24TH AUGUST 2012 17:00PM GMT. The initial delivery date for excel file to us is : 29th AUGUST 2012 17:00PM GMT. The customer will test the file upon receipt for a period of 24 hrs. If the file is found to meet the requirements as documented in this RFP, then this will be placed into use as of 1st SEPTEMBER 2012. We look forward to work with you on this project. Thank You and Best Regards, Customer