Completed

program to compare information on two spread sheets

This project was successfully completed by sheikDev for $30 USD in a day.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
32
Project Description

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

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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