Find Jobs
Hire Freelancers

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

$30-250 USD

Completato
Pubblicato più di 8 anni fa

$30-250 USD

Pagato al completamento
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.
Rif. progetto: 9323141

Info sul progetto

31 proposte
Progetto a distanza
Attivo 8 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 2 giorni
4,9 (5 valutazioni)
3,6
3,6
31 freelance hanno fatto un'offerta media di $100 USD
Avatar dell'utente
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 in 1 giorno
4,9 (738 valutazioni)
9,0
9,0
Avatar dell'utente
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 in 1 giorno
4,9 (622 valutazioni)
8,0
8,0
Avatar dell'utente
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 in 3 giorni
4,9 (433 valutazioni)
7,6
7,6
Avatar dell'utente
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 in 3 giorni
4,9 (205 valutazioni)
7,3
7,3
Avatar dell'utente
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 in 3 giorni
5,0 (79 valutazioni)
7,1
7,1
Avatar dell'utente
Hi! I am professional C/C++/C#/Java programmer. I can dom this project with highest quality! Best Regards, Szymszteinsl
$200 USD in 2 giorni
5,0 (94 valutazioni)
7,1
7,1
Avatar dell'utente
A proposal has not yet been provided
$147 USD in 3 giorni
4,7 (60 valutazioni)
7,2
7,2
Avatar dell'utente
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 in 3 giorni
5,0 (94 valutazioni)
6,1
6,1
Avatar dell'utente
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 in 5 giorni
4,8 (87 valutazioni)
6,0
6,0
Avatar dell'utente
A proposal has not yet been provided
$155 USD in 3 giorni
4,8 (67 valutazioni)
6,0
6,0
Avatar dell'utente
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 in 3 giorni
5,0 (30 valutazioni)
5,4
5,4
Avatar dell'utente
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 in 1 giorno
5,0 (29 valutazioni)
4,8
4,8
Avatar dell'utente
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 in 0 giorno
4,8 (26 valutazioni)
4,9
4,9
Avatar dell'utente
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 in 3 giorni
4,3 (22 valutazioni)
4,9
4,9
Avatar dell'utente
Предложение еще не подано
$200 USD in 5 giorni
5,0 (7 valutazioni)
4,3
4,3
Avatar dell'utente
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 in 3 giorni
5,0 (14 valutazioni)
4,3
4,3
Avatar dell'utente
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 in 3 giorni
4,7 (13 valutazioni)
4,4
4,4
Avatar dell'utente
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 in 3 giorni
5,0 (4 valutazioni)
4,0
4,0
Avatar dell'utente
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 in 4 giorni
5,0 (6 valutazioni)
3,1
3,1
Avatar dell'utente
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 in 3 giorni
5,0 (1 valutazione)
0,5
0,5

Info sul cliente

Bandiera: UNITED STATES
Palo Alto, United States
5,0
33
Metodo di pagamento verificato
Membro dal gen 27, 2015

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.