Find Jobs
Hire Freelancers

Create a consolidate data table from six large excel files

$30-250 USD

Abgeschlossen
Veröffentlicht vor fast 7 Jahren

$30-250 USD

Bezahlt bei Lieferung
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.
Projekt-ID: 14489931

Über das Projekt

27 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 in 1 Tag
4,8 (34 Bewertungen)
5,6
5,6
27 Freelancer bieten im Durchschnitt $153 USD für diesen Auftrag
Avatar des Nutzers
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 in 4 Tagen
5,0 (244 Bewertungen)
8,0
8,0
Avatar des Nutzers
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 in 1 Tag
4,9 (354 Bewertungen)
8,0
8,0
Avatar des Nutzers
Let me know if you would like start now Stay tuned, I'm is still working on this proposal.
$200 USD in 2 Tagen
4,9 (256 Bewertungen)
7,6
7,6
Avatar des Nutzers
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 in 1 Tag
4,9 (180 Bewertungen)
7,2
7,2
Avatar des Nutzers
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 in 3 Tagen
5,0 (206 Bewertungen)
7,1
7,1
Avatar des Nutzers
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 in 5 Tagen
4,9 (174 Bewertungen)
7,1
7,1
Avatar des Nutzers
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 in 5 Tagen
5,0 (13 Bewertungen)
6,2
6,2
Avatar des Nutzers
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 in 1 Tag
4,9 (165 Bewertungen)
6,5
6,5
Avatar des Nutzers
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 in 0 Tag
4,9 (63 Bewertungen)
5,7
5,7
Avatar des Nutzers
Hi, i am interested in your project. Relevant Skills and Experience Excel Proposed Milestones $100 USD - initial
$100 USD in 3 Tagen
5,0 (64 Bewertungen)
5,6
5,6
Avatar des Nutzers
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 in 1 Tag
4,8 (26 Bewertungen)
4,6
4,6
Avatar des Nutzers
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 in 3 Tagen
5,0 (4 Bewertungen)
4,0
4,0
Avatar des Nutzers
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 in 3 Tagen
5,0 (7 Bewertungen)
3,8
3,8
Avatar des Nutzers
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 in 1 Tag
4,8 (4 Bewertungen)
4,0
4,0
Avatar des Nutzers
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 in 1 Tag
4,9 (8 Bewertungen)
1,7
1,7
Avatar des Nutzers
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 in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
quick and accurate excel skills
$188 USD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$88 USD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von CANADA
Montreal, Canada
4,8
55
Zahlungsmethode verifiziert
Mitglied seit Okt. 2, 2006

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.