Completado

program to compare information on two spread sheets

Este proyecto fue completado exitosamente por sheikDev por $30 USD en un día.

Obtén cotizaciones gratis para un proyecto como este
Empleador trabajando
Presupuesto de Proyecto
$30 - $250 USD
Completado En
1 día
Ofertas Totales
32
Descripción del Proyecto

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

Completado por:

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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