[FINAL] 2009 Clan League - THOTA are Champions!

Incandenza · Post by **Incandenza** » Sat Apr 11, 2009 10:55 pm

A small request for the results table: it would be cool to see what everyone's home and away records are, along with their divisional records.

reptile · Post by **reptile** » Sat Apr 11, 2009 11:07 pm

Incandenza wrote:A small request for the results table: it would be cool to see what everyone's home and away records are, along with their divisional records.

that would be cool.

jp you are doing a GREAT job!

jpcloet · Post by **jpcloet** » Sun Apr 12, 2009 7:19 am

Incandenza wrote:A small request for the results table: it would be cool to see what everyone's home and away records are, along with their divisional records.

Home and away will be easy to do, will try to post that next time. Division might be tough as my model currently stands.

TheBro · Post by **TheBro** » Sun Apr 12, 2009 7:58 am

For now, you can see the games for every week in the other threads, they are not tallied though. JP when you're done slacking a strength of schedule and AP rankings would be nice. Thanks.

jpcloet · Post by **jpcloet** » Sun Apr 12, 2009 9:00 am

As everyone plays everyone to some degree, Strength of Schedule will be of limited use. Even with the Group of Death, 4 of that group still makes up the top 7 with the 5th clan still representing. I wonder if that will hurt the overall race. Will be interesting now that THOTA has made their move.

jpcloet · Post by **jpcloet** » Sun Apr 12, 2009 9:52 am

Divisional Records, and Home and Away overall are now posted. It's nice when formulas work the first time.

=(GETPIVOTDATA("Winner",'Divisions-Home'!$A$3,"Home",D27,"Winner",D27)+GETPIVOTDATA("Winner",'Divisions-Away'!$A$3,"Away",D27,"Winner",D27))&"-"&(GETPIVOTDATA("Winner",'Divisions-Home'!$A$3,"Home",D27)+GETPIVOTDATA("Winner",'Divisions-Away'!$A$3,"Away",D27)-(GETPIVOTDATA("Winner",'Divisions-Home'!$A$3,"Home",D27,"Winner",D27)+GETPIVOTDATA("Winner",'Divisions-Away'!$A$3,"Away",D27,"Winner",D27)))

e_i_pi · Post by **e_i_pi** » Mon Apr 13, 2009 10:42 am

jpcloet wrote:Divisional Records, and Home and Away overall are now posted. It's nice when formulas work the first time.

=(GETPIVOTDATA("Winner",'Divisions-Home'!$A$3,"Home",D27,"Winner",D27)+GETPIVOTDATA("Winner",'Divisions-Away'!$A$3,"Away",D27,"Winner",D27))&"-"&(GETPIVOTDATA("Winner",'Divisions-Home'!$A$3,"Home",D27)+GETPIVOTDATA("Winner",'Divisions-Away'!$A$3,"Away",D27)-(GETPIVOTDATA("Winner",'Divisions-Home'!$A$3,"Home",D27,"Winner",D27)+GETPIVOTDATA("Winner",'Divisions-Away'!$A$3,"Away",D27,"Winner",D27)))

Pivot tables... eww

TheBro · Post by **TheBro** » Mon Apr 13, 2009 2:42 pm

Now it makes sense, we had so many damn away games!

David_Wain · Post by **David_Wain** » Fri Apr 17, 2009 6:39 am

lolit seems we suck home compared to away :S,& pwn our division.

jpcloet · Post by **jpcloet** » Sat Apr 18, 2009 10:57 am

Updated.

LOW has taken sole position of 1st, although cellar dwellers DVL are giving them a good go at it this week. TSM loses their second road divisional series to LOD 6-4, and this is certainly turning out to be an intense division. THOTA continues their strong push towards the #1 spot.

The remaining opponents win % for the Top 3:
LOW 56%
TSM 53%
THOTA 50%

With LOW having played an extra 12 games and a tough schedule ahead, will they be able to maintain the #1 spot? Watch and find out. These teams still have series against each other soon enough.

We are now 48% complete on games. 644 games of 1350.

e_i_pi · Post by **e_i_pi** » Mon Apr 27, 2009 5:18 pm

jpcloet wrote:With LOW having played an extra 12 games and a tough schedule ahead, ...

We dealt with our "tough schedule" 10-0 jp

David_Wain · Post by **David_Wain** » Mon Apr 27, 2009 9:46 pm

Nice, guess if we want a shot we will have to have a good week vs u guys and keep up our streak so the gap doesn't become impossible.

e_i_pi · Post by **e_i_pi** » Mon Apr 27, 2009 10:03 pm

David_Wain wrote:Nice, guess if we want a shot we will have to have a good week vs u guys and keep up our streak so the gap doesn't become impossible.

We still have a personal bye to take, and THOTA - TSM - LoW all play games against each other before league is over. Should be an exciting end to the league

khazalid · Post by **khazalid** » Thu Apr 30, 2009 4:13 pm

i've got gently swelling chubs just thinking about it!

khazalid · Post by **khazalid** » Thu Apr 30, 2009 4:14 pm

p.s - nice woody reference on both our parts. see what i did there? yeah.

Scott-Land · Post by **Scott-Land** » Fri May 01, 2009 12:34 am

jpcloet wrote:Updated.

LOW has taken sole position of 1st, although cellar dwellers DVL are giving them a good go at it this week. TSM loses their second road divisional series to LOD 6-4, and this is certainly turning out to be an intense division. THOTA continues their strong push towards the #1 spot.

The remaining opponents win % for the Top 3:
LOW 56%
TSM 53%
THOTA 50%

With LOW having played an extra 12 games and a tough schedule ahead, will they be able to maintain the #1 spot? Watch and find out. These teams still have series against each other soon enough.

We are now 48% complete on games. 644 games of 1350.

We beat em the first go around [6-4 Jp]-- dont see why we can't do it again. For awhie there I thought we'd go 8-2 but they rallied winning the last 2 to make it a fight. Hate to mss 3 weeks especially this one tho I may be cheeruing from the sidelines.

reptile · Post by **reptile** » Fri May 01, 2009 3:41 pm

hey, how did you guys come up with the name the spanking monkeys?

TheBro · Post by **TheBro** » Fri May 01, 2009 3:49 pm

You beat us 7-3, not 6-4.

As for you doing it again, we get to pick the maps this time. So we'll see.

firstholliday · Post by **firstholliday** » Fri May 01, 2009 4:04 pm

reptile wrote:hey, how did you guys come up with the name the spanking monkeys?

i think it was frop who came up with it.

laddida · Post by **laddida** » Fri May 01, 2009 4:46 pm

not to mention we will be missing some key players. This could be tight...

Scott-Land · Post by **Scott-Land** » Mon May 04, 2009 12:30 am

TheBro wrote:You beat us 7-3, not 6-4.

As for you doing it again, we get to pick the maps this time. So we'll see.

Can't wait...

TheBro · Post by **TheBro** » Mon May 04, 2009 3:49 pm

Yeah neither can we! For once we have the advantage, maybe we can not screw it up!

Seulessliathan · Post by **Seulessliathan** » Mon May 04, 2009 3:52 pm

will be an interesting match, good luck guys!

jpcloet · Post by **jpcloet** » Mon May 04, 2009 7:51 pm

Updated almost 100 games and very little change in the standings. Still a close battle as the top.

DVL beat SF 8-2 for their first win of the season, and are looking to pull themselves out of the cellar.
Some big matchups in the next few weeks.

Also, some of the second halves of the divisional games are starting so more 20 game sets will be added to the ladder.

Incandenza · Post by **Incandenza** » Mon May 04, 2009 10:30 pm

All right, an update! Thanks, jp, you're doin' yeoman's work.

[FINAL] 2009 Clan League - THOTA are Champions!

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 11-09 (TIE for First)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table Apr 18-09 (LOW Leads)

Re: 2009 Clan League - Table May 4th-09 (LOW Leads)

Re: 2009 Clan League - Table May 4th-09 (LOW Leads)