User Pass
Home Sign Up Contact Log In
Forum > South America AA Leagues > South America AA #1 > Season 4 Week 13 Power Rankings Zeta Confernce
Cougah
offline
Link
 
<< Revised to use the entire seasons record >>

C-LW NAME

1-1) Cochabamba Samurai 76

2-3) Salt Lake City Mighty Mormons 64

3-2) Brooklyn Dreadnaughts 59

4-4) Goiana Rattlers 47

5-5) Atlantic Great Whites 41

6-6) chrisrex.com Chihuahuas 28

7-7) Paraguay West Torrents 11

8-8) Detroit Dynamite -2

9-9) Seattle Hard Hitters -11

10-10) Denver Rough Riders -22

11-12) Aconcagua Bears -24

12-11) Patagonia Porphyry -29

13-13) NRMD Swamp Donkeys -37

14-14) Columbus Quackers -46

15-15) Ipanema Tatuis -62

16-16) Portsmouth Virginians -80


C-L (Current - Last Week)

This method takes a considerable amount of time to calculate so it may not come out right after games anymore.
Last edited Aug 27, 2008 05:27:45
 
Al Jack
offline
Link
 
When I did this I made a 16 X 16 grid. I would mark all loses with a - in pen. I would write the record for each team across the top in pencil so I could change it week to week and would just move the correct number down into where the opponent was each week. Then I would add them across.

When I did this, it would look similar to this


Chrisrex....+5....-4...+3...+7...-0....+8....+2

Doing it this way you only have to update the Wins accumulated and losses accumalated and is less time consuming than starting over every week.

At this point in the season, this system is less relevant. The W/L records are just as telling at this point as the strength of schedule has evened out.

Thank you for the effort on this.

 
jdbstealth
offline
Link
 
I don't know how experienced you are with Excel, but I use it to keep track and it works fairly well. Just have the teams' records in one place, then use an equation adding wins and subtracting losses for each team to get their ranking. Then after each week, update the records and add one term to the equation for each team depending on whether they won or lost. This way you're only adding in one term and the rest of the info automatically updates because you are just referencing the records cells.
 
Al Jack
offline
Link
 
Originally posted by jdbstealth
I don't know how experienced you are with Excel, but I use it to keep track and it works fairly well. Just have the teams' records in one place, then use an equation adding wins and subtracting losses for each team to get their ranking. Then after each week, update the records and add one term to the equation for each team depending on whether they won or lost. This way you're only adding in one term and the rest of the info automatically updates because you are just referencing the records cells.


I am not that smart. I use paper and pencil. Excel has always pissed me off. I am going to be getting some training in Excel before the end of the year though.
 
Cougah
offline
Link
 
Originally posted by jdbstealth
I don't know how experienced you are with Excel, but I use it to keep track and it works fairly well. Just have the teams' records in one place, then use an equation adding wins and subtracting losses for each team to get their ranking. Then after each week, update the records and add one term to the equation for each team depending on whether they won or lost. This way you're only adding in one term and the rest of the info automatically updates because you are just referencing the records cells.


I tried coming up with an spreadsheet, but I couldn't figure out the correct equation to make it work. If you have an example that would help big time. Thanks.
 
jdbstealth
offline
Link
 
ok, so put the team names in column A, rows 1-16. In column B, put the number of wins each team has. Column C will be the number of losses each team has. Leave a space and then make column E the power rankin column. So assuming after 2 weeks, team 1 beat team 2 and lost to team 3. The equation for the power ranking would be "= B2 - C3" . Now in week 3, team 1 goes out and beats team 4. Now their equation would become "=B2 - C3 + B4". Also, you have to just change the numbers for wins and losses to be up to date based on the current standings. Those changes will automatically carry over into the power ranking.
 
Cougah
offline
Link
 
ahhaaaaa... thanks... I straight was doing way to much... I was trying to work "If,Then,Else" statements in the functions... I was about to break down and figure out how to create a VB script.... lol

Thanks Jdb.
 
cptafw163
offline
Link
 
Originally posted by Cougah
ahhaaaaa... thanks... I straight was doing way to much... I was trying to work "If,Then,Else" statements in the functions... I was about to break down and figure out how to create a VB script.... lol

Thanks Jdb.


I studied CS as well. i took a semester of VB and three three more porgramming semester classes...and I was a spanish major. Thats what you get for going to the military academy. Damn engineering tracks.

I suck at programming BTW. But kudos for trying. If you could get it to work, then it would be much easier though.

--dan
 


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