What you ask is not as simple as that, you can use web query to get the information in to excel but then you need to use formulas to extract the relevant information before you can use your formulas to allocate points.

If you had asked me a month ago i could have provided a sheet to do exactly this but the webpage that i used for this decided to make changes the screwed up my code and i have had no time to fix.

Do you know much about web queries or macros in excel?