Find Jobs
Hire Freelancers

Script an Excel workflow; outputs two files using data from two input files

$30-250 USD

Slutfört
Publicerad över åtta år sedan

$30-250 USD

Betalning vid leverans
I have a process in Excel in which I produce two csv files using the data in two input csv files. This must be done regularly, so I would like to script the entire process. In the beginning, you will have the two input csv\'s. The script should end with the two complete output csv\'s. The Excel processes include matching values between columns in two files, inserting values based on matching values in other columns, and concatenating values in two columns. The guide to the entire process is attached, as well as example input and output files. The input and output files have up to hundreds of thousands of rows, so I prefer to use Python or C++, and then I can run the program through the terminal rather than open Excel directly.
Project ID: 9323141

Om projektet

31 anbud
Distansprojekt
Senaste aktivitet åtta år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
Hello, I got some questions regarding to the example zip file. 1. The Catalog# in [login to view URL] has duplication. The Cat in [login to view URL] has duplication. I suppose those are unique key fields 2. The data between input csv and output csv do not match 3. The number of records between input csv and output csv are different I guess the example zip does not contain real data and real result? It shows the csv sample layout only. Please try my work in http://freelance.8pnet.com. To start the test, please: 1. zip your [login to view URL] 2. zip your [login to view URL] in another zip file 3. upload the 2 zip files to my website 4. wait for half hour to one hour for program execution if there are around 200,000 records in each file. (My program is running in a very old and low end NAS only. Normal machine should run much faster) 5. go to my website again to download the result The job is written in PERL. PERL is bundled in most UNIX/LINUX system. Windows terminal can also execute PERL program after installed strawberry PERL. It is free. --------------------------- I can finish the program in 2 days and provide you a webpage to submit 2 input excel files. You can then download the 2 output csv and check correctness. In the final delivery, I will only provide you the backend processing script. Is it ok if I use perl to do? Please pm me for discussion
$70 USD Om 2 dagar
4,9 (5 omdömen)
3,6
3,6
31 frilansar lägger i genomsnitt anbud på $100 USD för detta uppdrag
Använd avatar
Hello I'm interesting your project very well I'm a Good C++, Java, Excel, VBA, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks
$150 USD Om 1 dag
4,9 (738 omdömen)
9,0
9,0
Använd avatar
I'm expert in data processing with HUNDREDS of completed projects that's why I'm sure you'll be impressed with my work. I can create standalone program (for Windows or Mac or even Linux) where you'll select to input CSV files and the program will generate output you want after you click big Start button. The program will work without Excel installed. You have pretty good project description so all I need to start is milestone payment from you. You'll release it after you check everything on your side. Thanks. Roman
$74 USD Om 1 dag
4,9 (622 omdömen)
8,0
8,0
Använd avatar
Hello Sir Im excel VBA macro and formula Expert :) i can make macro from csv input and matching it. please give a chance for doing your job and im able to start doing your job right now THank You Sincerely Prameswara
$30 USD Om 3 dagar
4,9 (433 omdömen)
7,6
7,6
Använd avatar
I am very proficient in c, c++. I have 16 years c++ developing experience now, and I have worked for 6 years. My work is online game developing, and mainly focus on server side, the language is c++ under linux. I used c++ to make many great projects, for example, I made the tools which can convert java files to c++ scripts which has the same effect, of course garbage collection included. I also made our own mobile game using c++, I even can show you the demo of client. Trust me, please let expert help you.
$120 USD Om 3 dagar
4,9 (205 omdömen)
7,3
7,3
Använd avatar
Hi Sir, I can develop a C#.Net desktop based application which shall read the 2 Excel files as input and produce the 2 corresponding Output files. Please discuss before awarding the work. Thank you. Usman
$160 USD Om 3 dagar
5,0 (79 omdömen)
7,1
7,1
Använd avatar
Hi! I am professional C/C++/C#/Java programmer. I can dom this project with highest quality! Best Regards, Szymszteinsl
$200 USD Om 2 dagar
5,0 (94 omdömen)
7,1
7,1
Använd avatar
A proposal has not yet been provided
$147 USD Om 3 dagar
4,7 (60 omdömen)
7,2
7,2
Använd avatar
Hello, I am Excel and VBA expert. I can complete this project but in VBA (not in Python or C++). Please note that I have 100% completion rate and 5-star feedback on projects.
$88 USD Om 3 dagar
5,0 (94 omdömen)
6,1
6,1
Använd avatar
I have excellent command on MS Excel. I have recently built a reservation system in Excel that involved formulas and Macros to consolidate data from various sheets and pricing calculation. I have also completed projects on populating data depending on the value of the dropdown from multiple sheets
$80 USD Om 5 dagar
4,8 (87 omdömen)
6,0
6,0
Använd avatar
A proposal has not yet been provided
$155 USD Om 3 dagar
4,8 (67 omdömen)
6,0
6,0
Använd avatar
hello sir , c/c++/python/autohotkey expert worked for samsung & huawei a sample can be provided before hired hope to get message from u thank you very much
$80 USD Om 3 dagar
5,0 (30 omdömen)
5,4
5,4
Använd avatar
Is it necessary to use c++ or python? I can try with python but C# would be much better for me. Let me know.
$50 USD Om 1 dag
5,0 (29 omdömen)
4,8
4,8
Använd avatar
Hi, I, based on my 5 years of experience as a software engineer knowledgeable with tools automation, can handle this task pretty well. Let me know the best of your time so we can discuss further based on your requirements and we can move forward to the next step. Thanks, Joseph C Ocero
$149 USD Om 0 dag
4,8 (26 omdömen)
4,9
4,9
Använd avatar
Hello More 20 years programming experience. I would like suggest small gui .net application for your task. C#, VB on your choice. VC++ is also available, but it need more resources, of course it will be most forceful. I think we need discuss details to set real price and time. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$100 USD Om 3 dagar
4,3 (22 omdömen)
4,9
4,9
Använd avatar
Предложение еще не подано
$200 USD Om 5 dagar
5,0 (7 omdömen)
4,3
4,3
Använd avatar
Hi i have good experience on writing shells and python script , please have a look on my previous similar project. please let me know your interest . Regards Mukesh
$30 USD Om 3 dagar
5,0 (14 omdömen)
4,3
4,3
Använd avatar
Hello. I am an independent developer who can write you a script to automate the process of conversion of the csvs to the final output. I can do that in python according to your requirements. Please contact me for further discussion,
$250 USD Om 3 dagar
4,7 (13 omdömen)
4,4
4,4
Använd avatar
For this task I will use my own C#.Net Rapid Application Development libraries that contain methods for input / output file handling, delimited data parsing, and a basic GUI amongst many others. File paths will be defined in an XML config file (as could any "variable" data substitution rukes. The input csv files can either be selected in a standard directory browser tree or could be config file parameters.
$133 USD Om 3 dagar
5,0 (4 omdömen)
4,0
4,0
Använd avatar
Hello. I am a senior level software engineer and I can deliver an application that performs the functions outlined in the attached PDF. I would develop this in C++. Please award me the project and I will get to work. You do not need to pay me anything until the project is complete, no milestone necessary. Feel free to send me a private message to discuss any details. Thanks and I look forward to working with you.
$55 USD Om 4 dagar
5,0 (6 omdömen)
3,1
3,1
Använd avatar
Hello. I would write the application in C#. You can have totally automatic job or if you prefer I could create UI with table of proposed result for user to make corrections by hand if needed. I created lots of projects like this in my 10 years+ developer career. Also of you choose me, you have 1 year of free technical support in case of need for correcrions or little tweaks in the application. Best regards, Rafal
$50 USD Om 3 dagar
5,0 (1 omdöme)
0,5
0,5

Om kunden

Flagga för UNITED STATES
Palo Alto, United States
5,0
33
Verifierad betalningsmetod
Medlem sedan jan. 27, 2015

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.