There is an Excelfile with nearly thousand different products with our prices and they should be compared to the prices from an website "wein dot cc". The cheapest price from the website should be added to this excel file so that you can compare between our offer and theirs, direct hyperlink embedded would be perfect. Its very important that the input is really the exact hit in the website database, the products are wines and a little difference can be very bad.
The excelfile should be sortable and an all over statistic would be nice to have (how often is our pricer cheaper, eg.)
this is what we have:
nr. type of wine our price
1 type 1 5.00 Euro
2 type 2 3.00 Euro
and so on
this is what we need:
nr. type of wine our price delta to cheapest competitor Comp1
1 type 1 5.00 - 1 4
2 type 2 3.00 - 0,5 2,5
and so on
I need to run/create this files on my own so i need something "run and forget" and get my results.
The type list should be changeable if our offers - types of wines - or just the input order changes.
Any other ideas are welcome.
I edited it a little bit and added an example excel file.
example file added.
for real production data i have to ask first
13 freelancers are bidding on average $128 for this job
Hello, I'll create and provide you a windows desktop app for xp/vista/7 to do that. Perhaps it will be fine? And please reupload the example file - it's not attached. :) Thanks in advance.