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

revmcgator · 10-31-2021, 09:32 AM

Shinbone are the Stars of Silver, overcoming Sugar Hill.

Six OL teams head to the playoffs, but only 1-3 will advance to Gold.

Four OL teams head to Bronze.

revmcgator · 10-31-2021, 09:41 AM

Here's an Excel file to help those who calculate larger leagues.

Instructions
1. Use Team vs. Team report.
2. Open Report in Browser. (I use Safari. Hopefully this works with your browser of choice)
3. Copy from Name of first team to the last record of the last team.
4. Paste into Excel sheet at A3, using Paste Special, As Text
5. Add "Record" in Column B below the last row.

At this point, you should be able to see the totals for OL teams easily. Copy those results into your own reporting sheet.

If you have some other way that is simpler or more elegant, please share

stl jason · 10-31-2021, 09:55 AM

Quote:

Originally Posted by revmcgator

Here's an Excel file to help those who calculate larger leagues.

Instructions
1. Use Team vs. Team report.
2. Open Report in Browser. (I use Safari. Hopefully this works with your browser of choice)
3. Copy from Name of first team to the last record of the last team.
4. Paste into Excel sheet at A3, using Paste Special, As Text
5. Add "Record" in Column B below the last row.

At this point, you should be able to see the totals for OL teams easily. Copy those results into your own reporting sheet.

If you have some other way that is simpler or more elegant, please share

here's the one I use.... update the team names in row 1 (they will automatically update in column A once changed in the top row). Name should be updated above the 'wins' column, leaving the slot above 'losses' blank. Then just fill in the wins/losses vs each team in the appropriate cross sections.

Totals rack up in row 26, which also transfers to columns B and C.

For sorting of records, scroll down and use columns A-D, Rows 29-51 (as needed depending on number of teams). Those wins/losses also update automatically and are fixed to a specific cell, so the sort/movement doesn't matter/won't link them to the wrong team. Highlight that section and sort by column D.

For posting, I just open Paint, then copy/paste the standings section there, crop it down and save as a 2d image.

Stanley Kuppchaser · 10-31-2021, 12:08 PM

Congratulations!

Stanley Kuppchaser · 10-31-2021, 12:09 PM

Congratulations!

Stanley Kuppchaser · 10-31-2021, 12:13 PM

I believe there were enough teams to have a crown, if someone can step up and post standings. If nothing's up in a couple of hours, the McCarthy Plaque and Wooden Spoons will be posted.

revmcgator · 10-31-2021, 12:39 PM

Quote:

Originally Posted by stl jason

here's the one I use.... update the team names in row 1 (they will automatically update in column A once changed in the top row). Name should be updated above the 'wins' column, leaving the slot above 'losses' blank. Then just fill in the wins/losses vs each team in the appropriate cross sections.

Totals rack up in row 26, which also transfers to columns B and C.

For sorting of records, scroll down and use columns A-D, Rows 29-51 (as needed depending on number of teams). Those wins/losses also update automatically and are fixed to a specific cell, so the sort/movement doesn't matter/won't link them to the wrong team. Highlight that section and sort by column D.

For posting, I just open Paint, then copy/paste the standings section there, crop it down and save as a 2d image.

This is where I miss the "Thanks" button. So, thanks! Elegant and very nicely formatted.

Quinta · 10-31-2021, 02:27 PM

Quote:

Originally Posted by revmcgator

This is where I miss the "Thanks" button. So, thanks! Elegant and very nicely formatted.

Yes. That spreadsheet is really helpful Jason. I did it a very different way as I did not know where the team vs. team report was hidden. This is great and much easier. Thank you.

Stanley Kuppchaser · 10-31-2021, 02:32 PM

Up to the minute Gold and silver are attached.n The only other OL team still playing is Las Vegas in B256. All movement is set, so you can check your lists. The ones that could sneak by are San Francisco and Las Vegas heading to silver. Hopefully bronze won't be a mess again. Diamond, sadly, will only have three teams. Guessing there'll be no standings from B256.

Stanley Kuppchaser · 10-31-2021, 02:33 PM

Congratulations!

Stanley Kuppchaser · 10-31-2021, 02:36 PM

Congratulations!

Stanley Kuppchaser · 10-31-2021, 02:46 PM

Will be back in a few hours with , hopefully, so PT hardware. Oops, while I was making up the Wooden Spoons, Paxville fell behind, 2-0.

I had packs to open earlier today and ended up being able to complete the Willie Mays for only a couple of thousand PP. I had a few more closer to completion than I thought and also added a few other players I wasn't expecting, so the Mundys will have a fairly new look. Still a bit disappointed with how little satisfaction I got from finally getting Willie, but I guess that's how it goes. Good luck to those still playing.

stl jason · 10-31-2021, 02:58 PM

Quote:

Originally Posted by Stanley Kuppchaser

Will be back in a few hours with , hopefully, so PT hardware. Oops, while I was making up the Wooden Spoons, Paxville fell behind, 2-0.

I had packs to open earlier today and ended up being able to complete the Willie Mays for only a couple of thousand PP. I had a few more closer to completion than I thought and also added a few other players I wasn't expecting, so the Mundys will have a fairly new look. Still a bit disappointed with how little satisfaction I got from finally getting Willie, but I guess that's how it goes. Good luck to those still playing.

Yeah, something a bit underwhelming at the end trying to nab any fh3 cards and seeing so many teams rife with them already…. Need 2 to nab Mantle, but those are going for 50-60k per…. And one mission away from Lajoie but need some funds to finish all the cards in that one…. Slow n steady will get there someday.

Going to be a bit chaotic here for the next couple weeks…. Trying to sell our house in stl and moving to fl, so next Friday we’ll be driving my car to fl…. Fly back to stl on Saturday…. Movers show up on Monday…. Drive back to fl once movers are gone with wife’s car (and the cat) on Monday…. Meet movers at storage place on wed to offload everything…. Then it’s easy… just waiting for house to finish next feb or mar to move in….

Sent from my iPad using Tapatalk

revmcgator · 10-31-2021, 07:38 PM

Quote:

Originally Posted by stl jason

Going to be a bit chaotic here for the next couple weeks…. Trying to sell our house in stl and moving to fl, so next Friday we’ll be driving my car to fl…. Fly back to stl on Saturday…. Movers show up on Monday…. Drive back to fl once movers are gone with wife’s car (and the cat) on Monday…. Meet movers at storage place on wed to offload everything…. Then it’s easy… just waiting for house to finish next feb or mar to move in….

Sent from my iPad using Tapatalk

Welcome to Florida. (eventually)

revmcgator · 10-31-2021, 07:59 PM

Shinbone swept the Silver Series and will advance to Gold with South Holland and Gear Terrace. (The Warriors and El Caminos are immediate contenders to succeed brother-team West Burlington as Wooden Spoons award winners.)

Stanley Kuppchaser · 10-31-2021, 08:47 PM

Congratulations!

Tinkerman · 10-31-2021, 09:07 PM

For all their FH3 additions, Nowhere and Paxville both crashed out of the playoffs

. Quinta's BFF team lost 4-2 in the finals.

The Selects missions have put a bit of a downer on things. The L10's doubled overnight. Urgh. And I'm 0-4 from my perfect packs now. Boo.

Good luck with all your moving stuff, Jason.

stl jason · 10-31-2021, 09:12 PM

Quote:

Originally Posted by revmcgator

Welcome to Florida. (eventually)

Quote:

Originally Posted by Tinkerman

For all their FH3 additions, Nowhere and Paxville both crashed out of the playoffs

. Quinta's BFF team lost 4-2 in the finals.

The Selects missions have put a bit of a downer on things. The L10's doubled overnight. Urgh. And I'm 0-4 from my perfect packs now. Boo.

Good luck with all your moving stuff, Jason.

Thanks!

hope I don't jinx us here, but just accepted an offer 20K over our asking on the stl house, so in about 30 days that should be all wrapped up.... huzzah!

stl jason · 11-01-2021, 07:31 AM

2052 tier breakdown:

couple of missed teams (usual suspects), but overall one of the better turnouts across the board.... got some long-time Diamond clubs coming back to Gold to beat up on the rest of us this round

Iron= 2 teams
Bronze= 8 teams (7 in one league, 1 in another)
Silver= 16 teams (15 in one league, 1 in another)
Gold= 14 teams
Diamond= 3 teams

Gold league:

heavy OL presence in the NC (3 OL teams in the NC East and Central; 4 in the West); AC a bit lighter with 2 OL in the AC East, and 1 each in the Central and West.

anyone available to cover Gold all week? If not, I'll be around most of the week, so could cover Tue-Thu and Sun; but will be unavailable Fri-Sat.

Edster007 · 11-01-2021, 08:13 AM

Quote:

Originally Posted by stl jason

Thanks!

hope I don't jinx us here, but just accepted an offer 20K over our asking on the stl house, so in about 30 days that should be all wrapped up.... huzzah!

Congrats and good luck with the move. I'm in Florida now for the first time since Jan of 2020.

10-31-2021, 09:32 AM	#3261
revmcgator All Star Starter Join Date: Feb 2019 Location: SW Florida Posts: 1,242	Silver Shinbone are the Stars of Silver, overcoming Sugar Hill. Six OL teams head to the playoffs, but only 1-3 will advance to Gold. Four OL teams head to Bronze. Attached Images

10-31-2021, 12:08 PM	#3264
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Nowhwere Glides To Gold Crown Congratulations! Attached Images

10-31-2021, 12:09 PM	#3265
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Shinbone Shines in Silver Congratulations! Attached Images

10-31-2021, 12:13 PM	#3266
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Is anybody doing B256? I believe there were enough teams to have a crown, if someone can step up and post standings. If nothing's up in a couple of hours, the McCarthy Plaque and Wooden Spoons will be posted.

10-31-2021, 02:32 PM	#3269
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Playoffs so far Up to the minute Gold and silver are attached.n The only other OL team still playing is Las Vegas in B256. All movement is set, so you can check your lists. The ones that could sneak by are San Francisco and Las Vegas heading to silver. Hopefully bronze won't be a mess again. Diamond, sadly, will only have three teams. Guessing there'll be no standings from B256. Attached Images

10-31-2021, 02:33 PM	#3270
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Nowhere Men Claim McCarthy Plaque Congratulations! Attached Images

10-31-2021, 02:36 PM	#3271
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	West Burlington Wins Wooden Spoons Congratulations! Attached Images

10-31-2021, 02:46 PM	#3272
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Until later Will be back in a few hours with , hopefully, so PT hardware. Oops, while I was making up the Wooden Spoons, Paxville fell behind, 2-0. I had packs to open earlier today and ended up being able to complete the Willie Mays for only a couple of thousand PP. I had a few more closer to completion than I thought and also added a few other players I wasn't expecting, so the Mundys will have a fairly new look. Still a bit disappointed with how little satisfaction I got from finally getting Willie, but I guess that's how it goes. Good luck to those still playing.

10-31-2021, 07:59 PM	#3275
revmcgator All Star Starter Join Date: Feb 2019 Location: SW Florida Posts: 1,242	Shinbone Silver Champs Shinbone swept the Silver Series and will advance to Gold with South Holland and Gear Terrace. (The Warriors and El Caminos are immediate contenders to succeed brother-team West Burlington as Wooden Spoons award winners.) __________________

10-31-2021, 08:47 PM	#3276
Stanley Kuppchaser Hall Of Famer Join Date: Aug 2017 Posts: 4,239	Stars Sweep to PT Silver Series Win Congratulations! Attached Images Last edited by Stanley Kuppchaser; 10-31-2021 at 09:10 PM.

10-31-2021, 09:07 PM	#3277
Tinkerman All Star Starter Join Date: Nov 2019 Posts: 1,941	For all their FH3 additions, Nowhere and Paxville both crashed out of the playoffs . Quinta's BFF team lost 4-2 in the finals. The Selects missions have put a bit of a downer on things. The L10's doubled overnight. Urgh. And I'm 0-4 from my perfect packs now. Boo. Good luck with all your moving stuff, Jason.

11-01-2021, 07:31 AM	#3279
stl jason Hall Of Famer Join Date: Apr 2006 Posts: 10,112	2052 tier breakdown: couple of missed teams (usual suspects), but overall one of the better turnouts across the board.... got some long-time Diamond clubs coming back to Gold to beat up on the rest of us this round Iron= 2 teams Bronze= 8 teams (7 in one league, 1 in another) Silver= 16 teams (15 in one league, 1 in another) Gold= 14 teams Diamond= 3 teams Gold league: heavy OL presence in the NC (3 OL teams in the NC East and Central; 4 in the West); AC a bit lighter with 2 OL in the AC East, and 1 each in the Central and West. anyone available to cover Gold all week? If not, I'll be around most of the week, so could cover Tue-Thu and Sun; but will be unavailable Fri-Sat. Attached Images __________________ Beer League dynasty thread - knock 'em back!