Find Jobs
Hire Freelancers

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

$30-250 USD

Concluído
Publicado há mais de 8 anos

$30-250 USD

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

Sobre o projeto

31 propostas
Projeto remoto
Ativo há 8 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
Concedido a:
Avatar do Usuário
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 em 2 dias
4,9 (5 avaliações)
3,6
3,6
31 freelancers estão ofertando em média $100 USD for esse trabalho
Avatar do Usuário
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 em 1 dia
4,9 (738 avaliações)
9,0
9,0
Avatar do Usuário
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 em 1 dia
4,9 (622 avaliações)
8,0
8,0
Avatar do Usuário
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 em 3 dias
4,9 (433 avaliações)
7,6
7,6
Avatar do Usuário
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 em 3 dias
4,9 (205 avaliações)
7,3
7,3
Avatar do Usuário
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 em 3 dias
5,0 (79 avaliações)
7,1
7,1
Avatar do Usuário
Hi! I am professional C/C++/C#/Java programmer. I can dom this project with highest quality! Best Regards, Szymszteinsl
$200 USD em 2 dias
5,0 (94 avaliações)
7,1
7,1
Avatar do Usuário
A proposal has not yet been provided
$147 USD em 3 dias
4,7 (60 avaliações)
7,2
7,2
Avatar do Usuário
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 em 3 dias
5,0 (94 avaliações)
6,1
6,1
Avatar do Usuário
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 em 5 dias
4,8 (87 avaliações)
6,0
6,0
Avatar do Usuário
A proposal has not yet been provided
$155 USD em 3 dias
4,8 (67 avaliações)
6,0
6,0
Avatar do Usuário
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 em 3 dias
5,0 (30 avaliações)
5,4
5,4
Avatar do Usuário
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 em 1 dia
5,0 (29 avaliações)
4,8
4,8
Avatar do Usuário
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 em 0 dia
4,8 (26 avaliações)
4,9
4,9
Avatar do Usuário
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 em 3 dias
4,3 (22 avaliações)
4,9
4,9
Avatar do Usuário
Предложение еще не подано
$200 USD em 5 dias
5,0 (7 avaliações)
4,3
4,3
Avatar do Usuário
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 em 3 dias
5,0 (14 avaliações)
4,3
4,3
Avatar do Usuário
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 em 3 dias
4,7 (13 avaliações)
4,4
4,4
Avatar do Usuário
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 em 3 dias
5,0 (4 avaliações)
4,0
4,0
Avatar do Usuário
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 em 4 dias
5,0 (6 avaliações)
3,1
3,1
Avatar do Usuário
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 em 3 dias
5,0 (1 avaliação)
0,5
0,5

Sobre o cliente

Bandeira do(a) UNITED STATES
Palo Alto, United States
5,0
33
Método de pagamento verificado
Membro desde jan. 27, 2015

Verificação do Cliente

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.