Concluído

program to compare information on two spread sheets

Este projeto foi finalizado com sucesso por sheikDev para $30 USD em um dia.

Obtenha orçamentos gratuitos para um projeto como este
Empregado trabalhando
Orçamento do projeto
$30 - $250 USD
Completo em
1 dia
Total de Ofertas
32
Descrição do projeto

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

Completo por:

Querendo fazer dinheiro?

  • Defina seu orçamento e o prazo de entrega
  • Descreva sua proposta
  • Receba pelo seu trabalho

Contratar freelancers que também ofereça neste projeto

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