I am looking to add a universal site ranking to my website which can be updated either weekly or daily depending upon need.
The web site urls will be from a list cataloged in my site, which is similar to [url removed, login to view]
I am wanting to automatically collect the following data
Alexa Traffic Rank
Alexa Home Country Traffic Rank
Google Page Rank
Links to the url
Technorati Home Country Rank
I will then use a formula in Excel to calculate my own total ranking overall and then by Home Country.
I have attached a spreadsheet which might help explain what I am after.
I would then like to be able to use these rankings in my site for various tables and also as a note on each url listing.