Find Jobs
Hire Freelancers

Create a consolidate data table from six large excel files

$30-250 USD

Terminado
Publicado hace casi 7 años

$30-250 USD

Pagado a la entrega
Project to merge the data from six excel files based on the specifications provided to create a single result file. The result file can be excel (.xlsx) or CSV. Each data excel file has column titles that the “Leg Files Consolidation project” file describes how the data in the columns are to merged into the columns in the result file. One excel file is the primary table that contains columns to look up values in the other files. Thus the result file will contain the same number rows as the primary table. Not all lookups will find a value in the other tables, leave a blank value. A program outside of excel maybe needed. A review of the result file will be done, any errors will result in a fix in your algorithm and a rerun of the merge. The primary data file contain about 64,000 rows. Attached are the “Leg Files Consolidation [login to view URL]” file and “[login to view URL]” which contains the layout of the results file. The data file will be available from download from Dropbox or Google drive.
ID del proyecto: 14489931

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Quick Delivery I can provide.. i have 7 years of experience. No Agency, No middle man. I am direct developer. You can see my profile for client reviews. Relevant Skills and Experience Excel, VBA, MIS Management. Proposed Milestones $98USD - Full Coverage Looking for your urgent response.
$98 USD en 1 día
4,8 (34 comentarios)
5,6
5,6
27 freelancers están ofertando un promedio de $153 USD por este trabajo
Avatar del usuario
Hello, I am ready to merge the data from six excel files to a single result file and the result file can be excel (.xlsx) or CSV. LETS DISCUSS BEFORE STARTING THE TASK. We assure you for Highest standards of quality and accuracy within deadline. In closing, I would like to reiterate my desire to be work on this project. With that in mind, I look forward to hearing back. Thank you for considering my application. Regards
$200 USD en 4 días
5,0 (244 comentarios)
8,0
8,0
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$150 USD en 1 día
4,9 (354 comentarios)
8,0
8,0
Avatar del usuario
Let me know if you would like start now Stay tuned, I'm is still working on this proposal.
$200 USD en 2 días
4,9 (256 comentarios)
7,6
7,6
Avatar del usuario
Hello, Thanks for the opportunity to bid on this project. Task is 100% clear and i will get this done for you. We promise you 100% quality within the time limits. Relevant Skills and Experience Data Processing, Excel Proposed Milestones $55 USD - Please ping me lets discuss before starting the task.
$55 USD en 1 día
4,9 (180 comentarios)
7,2
7,2
Avatar del usuario
I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$200 USD en 3 días
5,0 (206 comentarios)
7,1
7,1
Avatar del usuario
Hi: I understand that you want to merge 6 files based on a primary file. I have reviewed the documents, it would be great if you could share the sample of 6 files. I can develop the program in Python. Relevant Skills and Experience I have developed several data manipulation scripts. More than 80% of my completed projects are related to Excel. Proposed Milestones $150 USD - Completed project with satisfaction Please share the sample of each file
$150 USD en 5 días
4,9 (174 comentarios)
7,1
7,1
Avatar del usuario
Hi, We are extremely dedicated and professional freelancing team. We will complete all our project works within budget and time duration. We are expert in all types of Manual Data Entry and Data Processing Work, Product Entry and Editing Work, PDF to Excel data conversion work and Virtual Assistant. We always produce EXTRA-ORDINARY WORK for our clients. we have 15+ years of experience in Administrative Work, Sales & Marketing Support, Data Mining, and Web Research. Research and Analysis: Online Data Searches (Linkedin / Yellow Pages / White Pages) Data Entry from Directories (Online / Offline) ECommerce Product Entry Online Coping and Pasting Updating Records in an Online and Offline System Image Editing and re-sizing Technical Skills MS Word Advanced MS Excel Outlook Access Typing skills - 65wpm Excellent spelling and grammar skills Database management Conversion Services: html conversion | xml conversion | epub conversion | kindle conversion | ocr data | offline and online data entry | print pdf | image to html | xml to epub | xml to xml | word formatting | form fillup Let me know... Thank You Kiran
$147 USD en 5 días
5,0 (13 comentarios)
6,2
6,2
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$120 USD en 1 día
4,9 (165 comentarios)
6,5
6,5
Avatar del usuario
My approach offers a macro with the usual Open file dialog to identify the current input and output files and and other controls if necessary. Relevant Skills and Experience I have a university degree in economics and IT and several decades experience in system design and programming in Excel and VBA. Proposed Milestones $166 USD - Whole project. Additional Services Offered $0.01 USD - Consult details, test pilot solutions. Use of macros, fixing of bugs and minor changes are free. $0.01 USD - Further use of macros, fixing of bugs and minor changes are included without any additional fees. $0.01 USD - I can start working on the project immediately and complete the job within some hours.
$166 USD en 0 día
4,9 (63 comentarios)
5,7
5,7
Avatar del usuario
Hi, i am interested in your project. Relevant Skills and Experience Excel Proposed Milestones $100 USD - initial
$100 USD en 3 días
5,0 (64 comentarios)
5,6
5,6
Avatar del usuario
Greetings Hope you are doing well. I am a CPA (CA/ACCA) Finalist and I provide a range of services, majorly focusing on excel, accounting, financial management, cost accounting and other allied subjects. I have been working in the above fields for 3 years now and have an extensive experience in the same. Looking at the project description, I am quite certain that I can execute it with utmost responsibility. Being proficient with Microsoft Excel and having created several complex excel templates for a series of clients will be an added advantage. I am well versed with advanced lookup function such as index, match, pivot tables, v lookups etc which will be critical in the delivery of this project. Looking forward for your reply in order to discuss the same in details. Regards Jitin Goyal
$55 USD en 1 día
4,8 (26 comentarios)
4,6
4,6
Avatar del usuario
Good day! I would be glad to help you with this work and I can make sure its done with 100% accuracy within 3 days time maximum. (Much sooner hoepfully) Relevant Skills and Experience * Over 7 years of experience on Excel/Data processing projects on freelancer.com * 5 star ratings for previous work * 100% on time, on budget completion/delivery. * US English level 3 certification Proposed Milestones $250 USD - Project completion Please let me know if you are interested, I am ready to start working on this right away. Thanks.
$250 USD en 3 días
5,0 (4 comentarios)
4,0
4,0
Avatar del usuario
merging the data in the excel Relevant Skills and Experience My core expertise is in excel, data processing projects. Follows instruction and do pay close attention to details. Proposed Milestones $100 USD - excel $100 USD - excel
$200 USD en 3 días
5,0 (7 comentarios)
3,8
3,8
Avatar del usuario
Hi, I have read your project description and I understood all your point. I have master degree academic qualification and currently pursuing my PhD. I am well versed with all parameters of your project. I want to assure you of top quality delivery.
$77 USD en 1 día
4,8 (4 comentarios)
4,0
4,0
Avatar del usuario
MD. SHERAZUL ISLAM Hellow, Dear Honorable Project Manager, I am Md. Sherazul Islam. I have been working as a Data Entry professional as well as SMM provider. But, now I am working as a Team membaer. They are professional. we have 3+ years work experience in online market place and 100% Client satisfaction Our intention and so on. My service details:- Graphic Design Service:- -------------------------------------------- Logo design. Flyer design. Illustator design. Background remove. Image editing. Banner design. Web-template design. Business Card design. Social Media Marketing Service:- ----------------------------------------------------- FB page like, post like, photo like, video view. Twitter followers, Retweet, Favorite, like. Instagram followers, photo like, video view. YouTube subscribe, video like,view, comment. Pinterest followers, likes, pin. G+ followers, shere. Soundcloud follower, like, play. Linkedin followers, like, shere Data Entry & Others Service:- ------------------------- Data Entry, Copy Paste, Excel, Research, Mailing List Development, Spreadsheet, Email Handling, Email Marketing, Word, Google Docs, CRM, Forum Posting, Content writing, Article writing, Rewriting. Regard Md. Sherazul Islam June 28/
$30 USD en 1 día
4,9 (8 comentarios)
1,7
1,7
Avatar del usuario
I am very skilled in Microsoft Excel & I can work with advanced formulaes & comments. I have handled large scale excel data for past 10 years. Relevant Skills and Experience Excel with advanced formulas Proposed Milestones $25 USD - Understanding the requirement & Project Kick-off $252 USD - On completion of work
$277 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Though this is high value project I am offering for less so that I can build upon reviews. Let me know if you want professional service for a lesser price. Thanks,
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
quick and accurate excel skills
$188 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$88 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I can complete this task of merging the file for you with 100% error free deliverable and on time delivery. Please connect to discuss further. Relevant Skills and Experience Excel, Data Base Proposed Milestones $166 USD - as described in the project Hi, Please connect to discuss further. Thanks, Neha
$166 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Montreal, Canada
4,8
55
Forma de pago verificada
Miembro desde oct 2, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.