Build an ongoing spreadsheet that automatically updates itself with data from Groupon's API (deals, locations, revenue, etc). It will automatically update each day with new data and be available via email. Deals will reconcile using the following rules. This is a follow on project to:
[url removed, login to view]
Day 1 - 2 Deals were Pulled. Deal A and Deal B. File will contain both these deals.
Day 2 - Only One Deal was Pulled. i.e. Deal B. This means that Deal A was closed. File will still contain both deals A and B and Deal A will be reported as closed along with the last quantity that was sold upto the time when it got closed.
Day 3 - Only 2 Deals were Pulled. Deal B and Deal C. File will contain 3 Deals now. Deal A record untouched. Deal B Record Updated with the last quantity at the time of data extraction. and Deal C record added.
6 freelancers are bidding on average $307 for this job