Fantasy Football Standings Macro Question

I am the commissioner of a fantasy football league that has a unique scoring mechanism and therefore requires tracking of standings in Excel. Each team (10 in total) "plays against" every other team each week. The highest scoring team has a 9-0 record, the next highest 8-1, etc. I am trying to set up two things in Excel:

1) A set of formulas/macros that will automatically assign the appropriate record once the weeks scores are entered.
2) A set of formulas/macros that will pull from the formulated standings, rank them by winning percentage, and report in another section of the worksheet.

I have attached the spreadsheet with the league data for reference.