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 best 5 prices from the website should be added to this excel file so that you can
compare offers, 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 [url removed, login to view] Euro
2 type 2 [url removed, login to view] Euro
and so on
this is what we need:
nr. type of wine our price delta to cheapest competitor Comp1 Comp2 Comp3 Comp4 Comp5
1 type 1 [url removed, login to view] - 1 4 4,5 4,6 4,8 4,9
2 type 2 [url removed, login to view] - 0,5 2,5 2,6 2,7 2,8 2,9
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.