Zakończony

program to compare information on two spread sheets

Ten projekt został pomyślnie zakończony przez sheikDev za $30 USD w jeden dzień.

Otrzymaj darmowe wyceny do podobnego projektu
Pracodawca pracuje
Budżet Projektu
$30 - $250 USD
Ukończony W
1 dzień
Ofert Razem
32
Opis Projektu

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

Ukończony przez:

Chcesz zarobić trochę pieniędzy?

  • Napisz kwotę, za jaką jesteś w stanie podjąć się projektu i przedział czasowy, w którym będziesz w stanie go zrealizować
  • Opisz, w jaki sposób wykonasz projekt
  • Otrzymaj wynagrodzenie za pracę

Zatrudnij Freelancerów, którzy również składają oferty do tego projektu

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