Create PHP script to import and combine/sort data from csv/excel files
$30-50 USD
Paid on delivery
You will have to create a php app that will import two excel/csv files. It will then take the data from both of them to generate reports.
## Deliverables
For example, one will have multiple entries for the same order. The script will have to combine the totals from all of that order, look up the cost of that item in the other csv/excel file, and then display a report breaking down the cost/profit for each item in the order. The user will have to have the ability to filter and show totals only for a particular product and or date range. After the data is imported it should be stored in databases for easy reference of past orders. The user should also have the ability to export the results as an excel file. This will have to be login protected. The whole site will have a one week deadline, however, you will have to provide with in TWO days of being granted the bid a basic version. The basic version should be able to combine multiple entries in the csv file that share the same item number AND order number. It should total up the amounts, it should then query the other excel file for the name of the product based on the item number . It should then display total sale price for item, cost of item and profit. This data should be able to be exported as excel file. There is no need to have everything stored to database or login protected. Basically a fancy calculator. Samples of the files are available on request In order for us to filter out those who automatically bid without reading the requirements, in your bid please mention the word "gamma". Without that word, your bid will be ignored. Failure to meet any of the two deadline will mean forfeiture of the entire bid. Thank You
Project ID: #3260521
About the project
Awarded to:
19 freelancers are bidding on average $35 for this job
