"Our League" Season 4--Who Wants To Play Our Way?

[Quinta]

So the Lemp Ave Perfectos have maintained their lead and some of the other challengers have fallen back. The Perfectos have only 3 OL games left and 2 games should be enough for a title (the Nowhere Men would have a chance with a 5-0 finish and I think the Brooklyn Dynasty would tie with a 6-0 finish). Anyway, if the Perfectos only win one that gives any hot team behind them a shot.



The PT league has 6 OL teams in the playoffs right now and those teams would produce 1-3 promoted teams. Currently there are three teams likely to be relegated.



I will not be able to post or calculate anything tomorrow so thank you to Tinkerman for finishing this off and thanks again to Revmcgator for the great spreadsheet. I may post later today if someone clinches.

[Tinkerman]

Originally Posted by revmcgator

In what qualifies as a good evening, not only are the ATLANTA BRAVES THE WORLD CHAMPIONS, but I finally figured out how to compile the standings in (basically) one step.

Copy, paste, print standings.

Opening your 2 files in Open Office Calc, the first gives me the W-L records of the OL teams, which is great and plenty time saving enough. But the second is not producing the table, either just opening your file, or pasting in my own league data (with Record added under the last entry). I'm curious if you would know why that may be, but it's really not essential, so don't go to ANY trouble .

[revmcgator]

Originally Posted by Tinkerman

Opening your 2 files in Open Office Calc, the first gives me the W-L records of the OL teams, which is great and plenty time saving enough. But the second is not producing the table, either just opening your file, or pasting in my own league data (with Record added under the last entry). I'm curious if you would know why that may be, but it's really not essential, so don't go to ANY trouble .

The second uses Excel's SORT function. I'm not sure which version of Excel introduced that or whether Open Office has something similar which could substitute.

The alternative -- which is what I started to do before I discovered the SORT function -- is to simply map those cells to the hidden cells in the adjacent columns with absolute values, and then sort it manually. Hope that makes sense to you.

[revmcgator]

Sunday has seven OL games remaining. HelthWyzer has completed their OL schedule.

[Tinkerman]

Originally Posted by revmcgator

The second uses Excel's SORT function.

That would explain it. I'll be delighted just to use the first to quickly get the totals and add the numbers to my own tables, so thanks again for that .

[Tinkerman]

Congratulations to the Lemp Ave. Perfectos!

They needed those 2 wins in the end, as Brooklyn (5-1) and Nowhere (4-1) both gave it their best.

A win for Annandale, and we've got 2 guaranteed promotions from the AL, but it's a much trickier picture for the NL teams.

And, after sharing a brilliant spreadsheet for compiling the results, look at how Rev's been rewarded this week! It's not cricket...

Good luck to everyone in the playoffs!

[Stanley Kuppchaser]

Congratulations!

[Stanley Kuppchaser]

With seven teams, it'll be a bit sad if we can't crown an OL winner.

[Tinkerman]

Here's a look at the final PT standings for this week's Diamond.

In another OL down season in Diamond, Paxville finished 11-8 against Cary, Knockemstiff didn't play.

Cary and Knockemstiff will both drop to Gold next week.

It's a bit sOuL less without a crown to play for!

[revmcgator]

Sunday hangs on for the title.

Two teams relegated. 2 or 3 teams to be promoted.

[Stanley Kuppchaser]

Congratulations!

[Stanley Kuppchaser]

I guess we're not getting any bronze standings, so I may as well post the McCarthy and Wooden Sp0oons. At least Cleveland should be getting promoted. Be back later with some hardware, I hope. Good luck to the playoff teams.

[Stanley Kuppchaser]

Congratulations!

[Stanley Kuppchaser]

Congratulations!

[revmcgator]

Originally Posted by Stanley Kuppchaser

Congratulations!

Quite an ownership streak for me, as each of my teams have won the Wooden Spoons in the last three seasons. I should be able to stop the streak next week. I hope.

[revmcgator]

Originally Posted by Tinkerman

That would explain it. I'll be delighted just to use the first to quickly get the totals and add the numbers to my own tables, so thanks again for that .

Adding numbers to your own tables??? Are we animals!!?

The attached sheet should work for you. You'll just have to sort the resulting table on your own. (Yes, like an animal. )

[Tinkerman]

Originally Posted by revmcgator

Adding numbers to your own tables??? Are we animals!!?

The attached sheet should work for you. You'll just have to sort the resulting table on your own. (Yes, like an animal. )

Lovely jubbly, and much appreciated. I'm sure you'd HATE how much manual sorting I do .


Here's the final playoff picture for Gold. Just Annandale and (the soon to be shell-shocked) Seattle made promotion. Nowhere and Silly had a tough draw.

[Stanley Kuppchaser]

I guess we have our first week in a very long time without any post season honors for OL, as silver. gold, and diamond teams all came up empty. Wait 'til next year, I guess..

[stl jason]

General FYI…. Moving weekend here…. Left my laptop at the condo in fl , so won’t be able to update the sheet with final standings or the new tier settings until Tuesday at the earliest…


Sent from my iPad using Tapatalk

[Tinkerman]

For what it's worth, here's Diamond.

Paxville somehow have 4 teams that haven't got deep with FH3 yet.

Whereas, Annandale and Seattle are probably gonna get munched (or kind of slurped) by a couple of very large sea mammals!