User Pass
Home Sign Up Contact Log In
Forum > Southeast Asia AAA Leagues > Southeast Asia AAA #1 > Spreadsheet Week 14 Power Rankings
ShotPutNC
offline
Link
 
Southeast Asia AAA#1 Top Ten

1. Pennsylvannia Silver Knights
--Record: 13-1
---Last Week: 1
----Spreadsheet Score: 2056.54

2. Bali Waves
--Record: 13-1
---Last Week: 2
----Spreadsheet Score: 2053.54

3. South Austin Bats
--Record: 12-2
---Last Week: 4
----Spreadsheet Score: 1900.03

4. P-Funk Allstars
--Record: 13-1
---Last Week: 3
----Spreadsheet Score: 1898.52

5. Montana Mercenaries
--Record: 12-2
---Last Week: 6
----Spreadsheet Score: 1873.51

6. Samed Accomplishers
--Record:12-2
---Last Week: 7
----Spreadsheet Score: 1799.61

7. Three Kingdom Warriors
--Record: 11-3
---Last Week: 8
----Spreadsheet Score: 1738.38

8. Portland Dirty Penguins
--Record: 12-2
---Last Week: 9
----Spreadsheet Score: 1732.51

9. Manila Warlords
--Record: 11-3
---Last Week: 5
----Spreadsheet Score: 1722.37

10. Awendaw Toadfish
--Record: 10-4
---Last Week: 10
----Spreadsheet Score: 1700.00


Knocking on the Door

11. Tongduchon Cowboys
--Record: 10-4
---Spreadsheet Score: 1462.04

12. Kyoto Kamikazees
--Record:8-6
---Spreadsheet Score: 1153.04
 
Link
 
??? How are we ahead of the Funk?
 
Link
 
Originally posted by Punk Rock Jocks
??? How are we ahead of the Funk?



Cuz Bats can fly over and through the "Funk"? Or we just stuggled against the Panthers!
You did beat the Warlords, well played and deserved.
Last edited Aug 28, 2008 17:09:35
 
Chadstroma
offline
Link
 
Was there ever an explanation given of what the points are from, meaning the spreadsheet formula? Just curious.
 
ShotPutNC
offline
Link
 
Originally posted by Chadstroma
Was there ever an explanation given of what the points are from, meaning the spreadsheet formula? Just curious.


Yeah I explained it earlier but here it is again:

100*Wins + 5*Win Streak + 10*Games Played + 800*Point Differential + 1000*Winning Strength + 50*Power Wins Percentage

______________________________________
Point Differential is determined by taking the total points scored in games a team has played in, both for and against, and making those into a percentage that comes from Points for and Points against. You Subtract the Points against Percentage from the Points for percentage then multiply by 800.

Winning Strength is actually a bit complicated. First, you average the winning percentages for each team your team has beaten (that is your Average Opponent Record in Wins). You take these numbers for each team in your conference and average it again to create a Conference Average Opponent Record in Wins. To determine your multiplier, you subtract the League Average from your teams average and that is the Winning Strength.

Power Wins percentage is the percent of your wins that have come against teams that currently have a winning percentage over .700.

____________________________________________
A Demonstration using Awendaw

100*Wins + 5*Win Streak + 10*Games Played + 800*Point Differential + 1000*Winning Strength + 50*Power Wins Percentage

100*(10 Wins) + 5*(2 Consecutive Wins) + 10*(14 Games Played) + 800*(80.05% Points For - 19.45% Points Against) + 1000*(.0512 Winning Strength) + 50*(.200 Power Wins Percentage)

1000 + 10 + 140 + 488.78 + 51.20 + 10

1010 + 140 + 488.78 + 51.2 + 10

1150 + 488.78 + 61.2

1638.78 + 61.2

1699.98

_____________________________________

I dont know if that helped. It was the best I could explain it. It was made by Joe87 not myself. I can send the spreadsheet to anyone who wants to look at it to try and make more sense of it. I will probably tweak it next year to make it a bit easier to comprehend.
Last edited Aug 28, 2008 18:25:23
 
CROC
offline
Link
 
Thanks for the figures and the explanation. MAkes it easier to understand.
 
spydersic
offline
Link
 
Originally posted by ShotPutNC


I dont know if that helped. It was the best I could explain it. It was made by Joe87 not myself. I can send the spreadsheet to anyone who wants to look at it to try and make more sense of it. I will probably tweak it next year to make it a bit easier to comprehend.


It uses Excel Right? If so I may be interested in the spreadsheet.
Last edited Aug 28, 2008 21:27:05
 
Link
 
There's way too much emphasis on point differential.
 
ShotPutNC
offline
Link
 
It does go on excel If you want to see the sheet just let me know. And as far as emphasis I didnt change anything Joe87 had in the sheet. Going into next season I can tweak it.
 


You are not logged in. Please log in if you want to post a reply.