User Pass
Home Sign Up Contact Log In
Forum > Oceania A Leagues > Oceania A #6 > If anyone wants to do power rankings and write ups
Otega
12th MIManITW
offline
Link
 
I have a system that has been handed down to me in the EE AAA/AA leagues.

It's a pretty decent system and is easy to figure out.

If anyone wants the spreadsheet, just shoot me a PM with your email and I will pass it along to you.

Between gm'ing for 3 teams, and owning 1, not sure I will have the time to do the write up every other day.

 
Kranok
offline
Link
 
I believe I have the same spreadsheet as you Otega. I've already set it up, and will begin posting week 6 once it becomes a little more reliable
 
Otega
12th MIManITW
offline
Link
 
Originally posted by Kranok
I believe I have the same spreadsheet as you Otega. I've already set it up, and will begin posting week 6 once it becomes a little more reliable


Ya, i saw your post after I made this. Totally forgot about it.

The system I have starts at week 4 (last 4 games). If you want, PM me your email and you can compare what you have with what i got here, and then go from there.
 
RIVERS
offline
Link
 
Thanks 'Kranok' (See you and your players GAME 7...GRRRRRRR) and 'Otega', I'd like to see the spreadsheets when you have time to put them together.

Regards.
 
Otega
12th MIManITW
offline
Link
 
Originally posted by RIVERS
Thanks 'Kranok' (See you and your players GAME 7...GRRRRRRR) and 'Otega', I'd like to see the spreadsheets when you have time to put them together.

Regards.


I already have it. Just PM me your email addy and i'll shoot it off to you.

Out of curiosity, why did you say 'Otega' as opposed to just Otega? dunno why, had to ask.
Last edited Aug 4, 2008 00:49:30
 
Kranok
offline
Link
 
Otega I've got the spread sheet you sent me filled in with the info so far, but I'm not quite sure about matching up the formulas could you give me a basic run down, so I can start posting them after everyones next game.
 
Otega
12th MIManITW
offline
Link
 
Np Kranok

@ Rivers, did u ever send me your email, btw?

Ok Kranok, it took me a little time to figure it out myself.

I'm using open office.org, but should be about the same.

1st - W/L/W4/L4/MoV1-4
All these are cells you have to manually fill in.

2nd - Rating
If you go to the first team and click on their actual rating, you'll see the forumla. The last 4 (X*X) are the last 4 teams played. So, for example, one might read as (I2*E16). For me and the EEAA ratings, that would equate to MOV1 (margin of victory) multiplied by the winning % of the team played in that game. The following formula would be MOV2 the third MOV3 an the 4th MOV4. The MOV's represent the last 4 teams played, with MOV4 being the most recent game.

2rd - SoS4
Strength of schedule for your last 4 games. It's the sum total winning % of your last 4 opponents, divided by 4. You have to change around the cell to reflect the previous 4 opponents.
You can see in the rating forumla, it takes that into account.

Hope this helps. If not, just ask away and i'll answer as best I can.
 
Todo88
offline
Link
 
Originally posted by Otega

2rd


 
Otega
12th MIManITW
offline
Link
 
Kranok, shoot me a PM if you didn't get the formulas figured out.

Thanks

OT
 


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