College Football Power Ratings and Stats

Click on this link and see the team match ups: [login to view URL] In an excel spreadsheet I want 2 columns for each team. Using a simple addition and subtraction formula, you are to come up with a score for each team. You will add all the power rankings from each link below for each team and game. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] You will also add all the statistical categories provided in the link below. (For example is a team is ranked #1 in a specific statistical category you will add 127. If the team is #2 you will add 126…you get the drift right?) [login to view URL] After you have added all the numbers for each team and have come up with two sums, you will then subtract the 2 and that will give you an answer. In the spreadsheet you will put the final sum after the subtraction under the team who has a hire overall power and statistical rating.