Warrior General Games

Come on, man....we need our fix!

then create them

I tried, but I can't find a program that creates RPI-like calculations, and I don't ahve the time or energy to do it by hand.

Originally posted by nthomas
I tried, but I can't find a program that creates RPI-like calculations, and I don't ahve the time or energy to do it by hand.

likewise, im still looking for a spreadsheet or a program

I have a formula but I dont feel like doing the rankings. if someone wants to do them then pm me and I'll share the formula

I was bored so I made a Power Ranking. I tried to stay with statistical data to keep this as objective as possible. I doubt I'll do this again so I've posted the spreadsheet at the link listed below. If anyone wants to collaborate and perhaps use the spreadsheets to make a more efficient ranking system, please do so. I'm not good at spreadsheet formulas/macros or databases that can make this easier to input.

This Power Ranking considers 3 categories and averages a team's ranking based on those statistics. Win percentage rank, scoring differential rank and strength of schedule.

Win Percentage Rank considers teams win (1pt)+ties(.5pt)/#games played to calculate win percentage.

Scoring Differential Rank is simply points scored minus points allowed for the season.

Strength of Schedule (S.O.S) considers the sum total of the win percentages of all the teams played to date divided by number of games played.

Overall Rank is based on the average of all three ranks.


To view the data used for this PR or to help improve or correct the worksheet(s), the link is here:
http://spreadsheets.google.com/pub?key=pro-505jIioyfW-VChpJuAQ

As always, this is purely for entertainment purposes and should not be considered otherwise.



TEAM WIN% SCR.DIF. S.O.S OVERALL
NAME RANK RANK RANK RANK Avg.
Moscow Mixed Martial Artist 6 5 12 7.67
Barcelona Spanish Matadors 11 13 3 9.00
Istanbul Hippos 3 3 21 9.00
Krakow Mountain Lions 4 8 15 9.00
Ljublijana Pregls 13 12 3 9.33
Hellas Hoplites 1 2 26 9.67
stewart ballers 5 7 17 9.67
Saratov Sea Wolves 13 11 7 10.33
Jersey Wildcats 1 1 32 11.33
Renosa El Chupacabra 7 6 21 11.33
Huevos Rancheros 13 14 8 11.67
Odessa Ajejes 13 15 8 12.00
Chicago Midway Monsters 7 19 15 13.67
Chekhov Bears 7 10 26 14.33
Gdansk Solidarity 11 4 30 15.00
Bucharest Legion 7 9 31 15.67
Bratislava Buzzards 19 17 17 17.67
Odesa Outlaws 19 22 12 17.67
Chernobyl "Ooops" 24 25 6 18.33
Transatlantic Devils 22 23 11 18.67
Belgrade Falcons 13 18 26 19.00
St. Petersburg Crusaders 13 15 29 19.00
Metro City Phenomenals 27 29 2 19.33
Boston Tea Baggers 19 21 19 19.67
Rio de Janeiro Bat Crazy Winos 31 27 1 19.67
Morgantown Mountaineers 27 28 5 20.00
Riga Tigers 22 20 21 21.00
Warsaw Warriors 22 24 21 22.33
Buda Pests 27 31 12 23.33
Pflugerville Panthers 31 32 8 23.67
Planet of the Apes DDA 24 26 21 23.67
Albuquerque Nighthawks 27 30 20 25.67

that's cool. i think you did good

How can Hoplites and Wildcats be so low?!

Originally posted by fentonscorn
How can Hoplites and Wildcats be so low?!

SOS

eB1, great job. I think the formula seems appropriate. I'll take a closer look when I have more time.

Another way to do this is to use the RPI formula:

The Index comprises that team's winning percentage (25%), its opponents' winning percentage (50%), and the winning percentage of those opponents' opponents (25%).

I am not an "excel programming guy" but it seems as if this could easily be loaded into a spreadsheet and then the scores added after the games. I have no idea how to do that, but may spend (waste) some time on it this weekend if it rains here.

Nice job, brother.

I like it well done

The Hippo's beat the Matadors 33-0 and only have one lost.

I like being number one, but I don't know that we should be. There are two teams with better records than us in Alpha, and although their loss and tie were to MMA, I don't feel we should take the top spot.

Until we sweep the playoffs.
-wtk

does it matter? lmao that is a joke...

Good job. Love to see the rankings, even though we are at the bottom.