Find Jobs
Hire Freelancers

Clean up data and format in Excel

₹12500-37500 INR

Cancelado
Publicado há aproximadamente 12 anos

₹12500-37500 INR

Pago na entrega
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).
ID do Projeto: 1497832

Sobre o projeto

48 propostas
Projeto remoto
Ativo há 12 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
48 freelancers estão ofertando em média ₹21.872 INR for esse trabalho
Avatar do Usuário
Ready to deliver the project
₹20.000 INR em 5 dias
5,0 (10 avaliações)
4,7
4,7
Avatar do Usuário
As I'm working in a market research organization's data processing support area, I've quite a long experience in handling such data tidying using a number of tools such as excel, vb, foxpro, etc. Best is if you can provide me some sample of your data to test my performance. If there's any confidentiality issue in your data, that will be maintained on good faith.
₹27.000 INR em 3 dias
5,0 (4 avaliações)
3,4
3,4
Avatar do Usuário
We have both passion & expertise to do the job well, within specified time & budget. Thank you.
₹12.500 INR em 2 dias
5,0 (4 avaliações)
3,1
3,1
Avatar do Usuário
Hello, I have done similar projects in previous employments. Kind regards Linda
₹25.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
The mentioned project of 30 sheets can be completed in 2 days time. I am good Data entry typist with good speed. More than 11 years of experience in the fields as adminstrator,data entry,order processing,operations etc
₹12.500 INR em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi! I can help you out with this.
₹20.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
hello dear,i am do this job easily,give me chance to show my ability,hope to see you soon,i am free in these days after my study,i can do this as soon as possible,
₹15.000 INR em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
hi, I believe it fits you
₹12.500 INR em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have good experience of playing with excel worksheets....
₹17.000 INR em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Easy job, send it over.
₹12.500 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
hi, i can help u with this job. accuracy assured!
₹13.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am very good in Excel and would be able to finish this project for you accuratley.
₹150.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Dear Hiring Manager, I am a CA Finalist registered on panel of Ortaq Consultants for providing such services I have sound expertise on MS Excel regarding such conversion keeping the destination format intact and simultaneously cleaning the source data. I have done similar assignments throughout my articles (associated with PWC) Would be completing your task within 3 days of being allocated to me. Regards - Abidi
₹20.000 INR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I am a web designer with extensive computer skills. I can complete this job in 2 days and I would be happy to discuss any other tasks you may require. Thank you for your consideration.
₹12.500 INR em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I'm very interested in your project. I can finish the job on time. Thank you !
₹12.500 INR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have lot experience with excel.
₹37.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello. I've been working in the global supply chain area of a main american transnational for the las 5 years. My experience consolidating data bases and the expertize gained over the years with spreadcheet conciliations convert me in a very good candidate, please let me know all of the details fo the work and the lead times for completion. Thanks in advance for your consideration.
₹27.361 INR em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello I am well experienced with similar works and interested in your project. Please see PMB. Thanks Hussain
₹35.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
hello sirs, this is divyanshu shrivastava and i do believe that i can complete this work in a short time so please try me. regards divyanshu exe plant engineer opil amlai
₹20.000 INR em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
i wil complete ur projec within 7days
₹12.500 INR em 7 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) INDIA
India
0,0
0
Membro desde mar. 11, 2012

Verificação do Cliente

Outros trabalhos deste cliente

data entry for real estate
$30-250 USD
Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.