This is a data cleansing project in Excel.
The task is to transfer data from one Excel spreadsheet to another. The first spreadsheet contains tables from an old MS Access database, one worksheet is one table in MS Access. The second spreadsheet contains templates for the new SQL Server database, one worksheet is one table in the SQL Server.
You need to transfer data from the Source Spreadsheet (SS) to the Destination Spreadsheet (DS), column by column. This process cannot be fully automated, because the data in the SS must be cleaned before being transferred to the DS. Therefore, the data should be transfer column by column, with clean up and check up.
The SS workbook has about 30 worksheets, the DS workbook has about 8 worksheets.
The SS workbook contains worksheets of Customers, Stock Items, Purchases etc. There are about 300 customers, 500 Items and 500 Purchase Invoices. The total size of SS in Excel is about 1 MB.
It took me about 20 work hours to do the first such transfer myself.
This project is for one transfer from SS to DS, but we have about 40 identical projects. If your performance on the first project is good, then you may be invited to continue this work over the next two months.
If you are short-listed on this project, you will receive the SS and DS without data but with a count of records in each, to get a better idea of the amount of work and to adjust your bid accordingly.
This is a basic level work, which requires no special Excel skills, but it requires from you to be persistent and very, very tidy. The criterion of your achievement is how easily and quickly your DS can be imported into SQL Server. If SQL Server rejects your DS and I have to do many corrections, then you have not done your job well.
Please supply any references for similar work done before (person name and email/phone).
Hello
I can do this for you. I have worked on many similar projects.
Please let me know what cleanup you want to do with data and I'll try to automate the process. I have SQL Server available, and will provide you tested and verified file.
I'll only charge you if you are satisfied with the result.
Please see my profile and feedbacks.
Regards
Faisal
Hi there!
Kindly consider my candidature for the above task. I am willing to start on immidiate term. I have a very good experience on Excel platform. The last one was as senior KPI exeutive where i have been doing 90% of reporting and analysis on Excel..
BR
Abdi
Hello! I am very much interested in your project. I have a 12-year experience in data handling and conversion in Windows platform. Hoping to work with you… Thanks.
Hi there, I am willing to work with you.. . I am an excel expert, i've been doing this for more than 4 years.
Please count me in..
what ever you want me to do, whatever time.
Thanks
Hi. I have worked with Excel to a very high level for 10 years, and data cleansing and manipulation has formed a large part of my experience.
After reading your very clear instructions, your task appears straightforward and I am happy to submit my bid to you.
Hello, I understand the project. I think I can make a good job in cleaning the excel sheet. I've done similar work at current job.
Best regards and hope to collaborate.