Выполнено

program to compare information on two spread sheets

Этот проект был успешно выполнен sheikDev за $30 USD за день.

Получить бесплатно ценовые предложения для подобного проекта
Работодатель работает
Бюджет проекта
$30 - $250 USD
Выполнено за
1 день
Всего заявок
32
Описание проекта

I want a program where i can upload two csv files the files will be analysed and a third csv will be created as output.

The input file 1 will contain lists like this

inquiries

[url removed, login to view],2016-10-07,2016-10-08,23,18,5,[url removed, login to view],[url removed, login to view],[url removed, login to view],0

[url removed, login to view],2016-10-07,2016-10-08,87,3,0,[url removed, login to view],[url removed, login to view],[url removed, login to view],0

[url removed, login to view],2016-10-07,2016-10-08,34,13,5,[url removed, login to view],[url removed, login to view],[url removed, login to view],0

input file 2 will contain a list like this

[url removed, login to view],155,692,4,[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],y,shift,time

[url removed, login to view],155,692,4,[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],y,ponsor,dis

[url removed, login to view],155,692,4,[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],y,port,Bod

[url removed, login to view],1486,894,31,[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],y,group,backtime

The program will find matches of the names in row one and then compare the the last row from file one with the 10 row from file two. Once the operation is complete the results will be available to export in the following format

[url removed, login to view],whichever file was highest, highest amount, lowest amount, %difference

so for the examples the output would be

[url removed, login to view], file1, [url removed, login to view], [url removed, login to view], 441%

[url removed, login to view], file2, [url removed, login to view], [url removed, login to view], 10000% (use 10000% when lowest is 0)

[url removed, login to view], file2, [url removed, login to view], [url removed, login to view], 1089%

[url removed, login to view], no comparison

Hopefully that is enough information for a quote. If not ask.

Thanks

Выполнено:

Хотите заработать немного денег?

  • Укажите свой бюджет и срок
  • Опишите свое предложение
  • Получите оплату за свою работу

Нанять фрилансеров, которые также подали заявку в этот проект

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online