Find Jobs
Hire Freelancers

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

$30-250 USD

Завершено
Опублікований over 8 years ago

$30-250 USD

Оплачується при отриманні
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 проекту: 9323141

Про проект

31 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 за 2 дні(-в)
4,9 (5 відгуки(-ів))
3,6
3,6
31 фрілансерів(-и) готові виконати цю роботу у середньому за $100 USD
Аватарка користувача
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 за 1 день
4,9 (738 відгуки(-ів))
9,0
9,0
Аватарка користувача
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 за 1 день
4,9 (622 відгуки(-ів))
8,0
8,0
Аватарка користувача
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 за 3 дні(-в)
4,9 (433 відгуки(-ів))
7,6
7,6
Аватарка користувача
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 за 3 дні(-в)
4,9 (205 відгуки(-ів))
7,3
7,3
Аватарка користувача
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 за 3 дні(-в)
5,0 (79 відгуки(-ів))
7,1
7,1
Аватарка користувача
Hi! I am professional C/C++/C#/Java programmer. I can dom this project with highest quality! Best Regards, Szymszteinsl
$200 USD за 2 дні(-в)
5,0 (94 відгуки(-ів))
7,1
7,1
Аватарка користувача
A proposal has not yet been provided
$147 USD за 3 дні(-в)
4,7 (60 відгуки(-ів))
7,2
7,2
Аватарка користувача
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 за 3 дні(-в)
5,0 (94 відгуки(-ів))
6,1
6,1
Аватарка користувача
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 за 5 дні(-в)
4,8 (87 відгуки(-ів))
6,0
6,0
Аватарка користувача
A proposal has not yet been provided
$155 USD за 3 дні(-в)
4,8 (67 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 за 3 дні(-в)
5,0 (30 відгуки(-ів))
5,4
5,4
Аватарка користувача
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 за 1 день
5,0 (29 відгуки(-ів))
4,8
4,8
Аватарка користувача
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 за 0 день
4,8 (26 відгуки(-ів))
4,9
4,9
Аватарка користувача
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 за 3 дні(-в)
4,3 (22 відгуки(-ів))
4,9
4,9
Аватарка користувача
Предложение еще не подано
$200 USD за 5 дні(-в)
5,0 (7 відгуки(-ів))
4,3
4,3
Аватарка користувача
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 за 3 дні(-в)
5,0 (14 відгуки(-ів))
4,3
4,3
Аватарка користувача
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 за 3 дні(-в)
4,7 (13 відгуки(-ів))
4,4
4,4
Аватарка користувача
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 за 3 дні(-в)
5,0 (4 відгуки(-ів))
4,0
4,0
Аватарка користувача
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 за 4 дні(-в)
5,0 (6 відгуки(-ів))
3,1
3,1
Аватарка користувача
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 за 3 дні(-в)
5,0 (1 відгук)
0,5
0,5

Про клієнта

Прапор UNITED STATES
Palo Alto, United States
5,0
33
Спосіб оплати верифіковано
На сайті з січ. 27, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.