NCAA Algorithm

Hello there, my team has decided that VBA would be the best method for evaluating this data (multiple years set up in the same format.)

The data is set up for each team, and has all the necessary data in their own cells. It needs to take the current team's winning percentage (to 3 decimals) and multiply it by 100. Then it is to go through each week of play and do the same for each opponent. If the team in question won that week, then they gain (.??? X 100) points, if they lose, then they are deducted ((1-.???)X100) points. It will calculate the data throughout the regular season, and will rank the teams based upon these points and will ultimately determine which 2 teams are going to the Championship Game.

Now, it's been some time since I've looked at visual basic (6-7 years) and I'm more rusty that I assumed. I can manage to calculate each team one at a time, but there are 120 teams for each of the 10 years so it would be very efficient to be able to have the code figure up each team for a set year.

I've attached the spreadsheet with no macros included. I realize that I'm requesting a lot of information, so any help or constructive comments are VERY appreciated.

Thank you all in advance,

-Mikael

Basically, is there a good, efficient way to use an array here, or would just looping the code to have it go down to the next team work fine as well? Then, perhaps after the loop, it finds the top 2 maximum point values given to teams and reports them in Cell X and Y.

That's basically where I'm at.