Conquer Club

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.

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!

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.

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.

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.

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)))

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

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

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

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.

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

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

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.

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

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

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

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.

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

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.

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.

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

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...

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

will be an interesting match, good luck guys!

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.

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