Clean up data and format in Excel

Κλειστό Αναρτήθηκε Feb 4, 2012 Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

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).

Εισαγωγή Δεδομένων Excel

Ταυτότητα Εργασίας: #1427587

Σχετικά με την εργασία

31 προτάσεις Απομακρυσμένη εργασία Ενεργό Apr 14, 2012

31 freelancers κάνουν προσφορές κατά μέσο όρο $99 για αυτή τη δουλειά

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$225 USD σε 5 μέρες
(25 Αξιολογήσεις)
5.8
wikkipk

Ready to do it.

$199 USD σε 5 μέρες
(26 Αξιολογήσεις)
4.4
kulhanekd

I can do this project for you. Thanks Donna

$150 USD σε 5 μέρες
(12 Αξιολογήσεις)
4.5
habayabah

Please read my PM for details of my bid.

$30 USD σε 1 μέρα
(3 Αξιολογήσεις)
3.1
khanshabb

Hi can do it and ready to start

$100 USD σε 5 μέρες
(2 Αξιολογήσεις)
3.0
thiyagus25

Greetings! Thank you very much for giving us an opportunity to bid for your project. Will finish till this bid ends, Please see PMB

$30 USD σε 10 μέρες
(6 Αξιολογήσεις)
2.2
kieron90

Hi there, I am new to the site, I am very efficient at the microsoft office package, including access, excel and word. I have prior data entry and spreadsheet experience, would love to get some projects under my belt a Περισσότερα

$40 USD σε 5 μέρες
(1 Κριτική)
1.0
Pimpuppy

Hello! I`m marius an i'm ready to start on your data transfer project. i can do a small test if required so you can see my "skills". thanks for the opportunity and Best regards!

$100 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
jayIyer

I can complete this project of 1 entire set of SS to DS movement in less than 2 days time. I used to work for an IT company for 4 years during which a majority of my work was to update MS Excel spreadsheets with dat Περισσότερα

$60 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
Myalina

Ready to work, and deliver it on time

$100 USD σε 10 μέρες
(0 Αξιολογήσεις)
0.0
nnnnnnmmmmmmm

Ready to work accurately and efficienlty

$40 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
divyeshdesigner

hi sir, i am ready to your work.

$40 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
LucianDan

I'm ready to begin this work, I would like to participate at these and other similar projects.

$60 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
Susanm24

Consider my bid, I am an experience data entry staff with high level of accuracy, can get your project done well in very short period of time.

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
sokhal777

lets do it

$200 USD σε 10 μέρες
(0 Αξιολογήσεις)
0.0
herliyanti

i'll try to do best

$200 USD σε 15 μέρες
(0 Αξιολογήσεις)
0.0
HOSSS

I m interested about it,please tell me about it.

$30 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
gearner

Ready to work.

$200 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
Hetal7

Hi, I am interested for this type of project work. I will deliver complited project as per your time. pl. send me detail. Thank you.

$150 USD σε 15 μέρες
(0 Αξιολογήσεις)
0.0
ssahilkureshi

experience and expert and can submit this project on right time...

$100 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0