The Royals have the longest drought in the majors for both Cycles (1990) and Triple Plays (2006) and are third in No Hitters (1991).

Longest active no-hitter droughts:
Cleveland 1981
Toronto 1990
\*Kansas City\* 1991

Longest active cycle droughts:
\*Kansas City\* 1990
Detroit 2006
Oakland 2007

Longest active triple-play droughts:
\*Kansas City\* 2006
San Francisco 2008
Arizona 2009

As a Royals fan, this is extremely annoying. Noah Cameron took a no hitter into the 7th today, but of course, that's as far as it went. And in fact, opponents have a hard time doing any of these things against the Royals either. Since 2009, there have only been two opponent triple plays turned against the Royals, and no No Hitters or Cycles. The next-lowest number of such events in a team's games since 2009 is 6 (Cardinals) and the highest number is 19 (Astros).

Every MLB team has done at least one of the above since 2016 (Pittsburgh's most recent cycle was in 2016) except for the Royals, who haven't done one since 2006. I'm kind of rooting for Cleveland and Toronto to throw no hitters soon, just to see the Royals at the top of all three droughts.

reddit.com
u/BlitzAce71 — 3 days ago
▲ 36 r/mlb

The Royals have the longest drought in the majors for both Cycles (1990) and Triple Plays (2006) and are third in No Hitters (1991).

Longest active no-hitter droughts:
Cleveland 1981
Toronto 1990
*Kansas City* 1991

Longest active cycle droughts:
*Kansas City* 1990
Detroit 2006
Oakland 2007

Longest active triple-play droughts:
*Kansas City* 2006
San Francisco 2008
Arizona 2009

As a Royals fan, this is extremely annoying. Noah Cameron took a no hitter into the 7th today, but of course, that's as far as it went. And in fact, opponents have a hard time doing any of these things against the Royals either. Since 2009, there have only been two opponent triple plays turned against the Royals, and no No Hitters or Cycles. The next-lowest number of such events in a team's games since 2009 is 6 (Cardinals) and the highest number is 19 (Astros).

Every MLB team has done at least one of the above since 2016 (Pittsburgh's most recent cycle was in 2016) except for the Royals, who haven't done one since 2006. I'm kind of rooting for Cleveland and Toronto to throw no hitters soon, just to see the Royals at the top of all three droughts.

reddit.com
u/BlitzAce71 — 3 days ago

Here's a Google Sheets doc I made to export all of your Sleeper fantasy football data (version 8 update)

Hi all,

If you're a fantasy player or commissioner like me, you might want your Sleeper data to be a little more accessible. Maybe your league has special rules that Sleeper doesn't support, or maybe you have payouts for weekly high scores, or you like to keep detailed record books of matchup history and player ownership and all of the other little details and stats that us sports people obsess over.

If that sounds interesting to you, I've developed a Google Sheets doc that lets you see all of your Sleeper league info in one place. This sheet will let you see weekly and yearly results for each team and player (every player's weekly info for Owner, League, Year, Week, Position, NFL team, Fantasy position that week, Points, Fantasy Opponent, Projected Points, Age, and relevant stats like yards, touchdowns, etc.). It will also pull in your league's schedule, draft results, transaction history, owned draft picks, free agents, and standings. New in v8, a Rosters tab shows the most recent Rosters for every team for a given league and year. For a snapshot of the rosters by week, check the Player Results tab. But for leagues in the offseason, the Rosters tab will show you today's rosters.

When you click the link, it will take you to Google Sheets. First go to File - Make A Copy and make your own copy of my document. From there, the instructions are on the first Info tab, but first you will need to authorize it through Google. On the Google warning screen, if you click Advanced you can then go to Go to Sleeper API and it will bring up a window for what permissions to allow. I've published versions of this sheet on Reddit for many years, and I promise that the authorization is not doing anything other than letting the script insert rows into the document. You could even open up Apps Script (Extensions - Apps Script) and run the whole code by an LLM and ask if it's doing anything weird before you authorize. Once you authorize, plug your Sleeper name and the season into the first page and then it will take a few minutes to gather all of the data.

One caveat is that the player info (such as which team they play for) is stored in one live source by Sleeper, not as historical data. Which means if you look up a league from 2018 and find, let's say, DeAndre Hopkins, it will show him as WR for BAL even though obviously he was on Houston at the time and has moved around several times since then. My point is, my sheet reads from Sleeper, so if you have any complaints about that data then they're the ones in charge of that.

If anyone has any questions, you are welcome to post here or I've put my contact info in the sheet. The goal is just to share this tool with you all because I've found the need to pull data out of Sleeper to be vital to a lot of the various rules and bookkeeping and responsibilities of being a fantasy commissioner and I hope it saves you some time or gives you new ideas or fun projects to work on for your leagues.

Link: https://docs.google.com/spreadsheets/d/1SraZo8r6YAR3Utd_x6QCman_lT3qHH3tU6K2RWvabEo/

Dear Mods: I see the message that says "All Apps/Tools/Websites/Platforms/Etc are to be posted in our bi-weekly megathread on Fridays. No individual posts accepted." but I don't see the bi-weekly megathread anywhere. Sorry if this is the wrong place for this.

reddit.com
u/BlitzAce71 — 2 months ago

Here's a Google Sheets doc I made to export all of your Sleeper fantasy football data (version 8 update)

Hi all,

If you're a fantasy player or commissioner like me, you might want your Sleeper data to be a little more accessible. Maybe your league has special rules that Sleeper doesn't support, or maybe you have payouts for weekly high scores, or you like to keep detailed record books of matchup history and player ownership and all of the other little details and stats that us sports people obsess over.

If that sounds interesting to you, I've developed a Google Sheets doc that lets you see all of your Sleeper league info in one place. This sheet will let you see weekly and yearly results for each team and player (every player's weekly info for Owner, League, Year, Week, Position, NFL team, Fantasy position that week, Points, Fantasy Opponent, Projected Points, Age, and relevant stats like yards, touchdowns, etc.). It will also pull in your league's schedule, draft results, transaction history, owned draft picks, free agents, and standings. New in v8, a Rosters tab shows the most recent Rosters for every team for a given league and year. For a snapshot of the rosters by week, check the Player Results tab. But for leagues in the offseason, the Rosters tab will show you today's rosters.

When you click the link, it will take you to Google Sheets. First go to File - Make A Copy and make your own copy of my document. From there, the instructions are on the first Info tab, but first you will need to authorize it through Google. On the Google warning screen, if you click Advanced you can then go to Go to Sleeper API and it will bring up a window for what permissions to allow. I've published versions of this sheet on Reddit for many years, and I promise that the authorization is not doing anything other than letting the script insert rows into the document. You could even open up Apps Script (Extensions - Apps Script) and run the whole code by an LLM and ask if it's doing anything weird before you authorize. Once you authorize, plug your Sleeper name and the season into the first page and then it will take a few minutes to gather all of the data.

One caveat is that the player info (such as which team they play for) is stored in one live source by Sleeper, not as historical data. Which means if you look up a league from 2018 and find, let's say, DeAndre Hopkins, it will show him as WR for BAL even though obviously he was on Houston at the time and has moved around several times since then. My point is, my sheet reads from Sleeper, so if you have any complaints about that data then they're the ones in charge of that.

If anyone has any questions, you are welcome to post here or I've put my contact info in the sheet. The goal is just to share this tool with you all because I've found the need to pull data out of Sleeper to be vital to a lot of the various rules and bookkeeping and responsibilities of being a fantasy commissioner and I hope it saves you some time or gives you new ideas or fun projects to work on for your leagues.

Link: https://docs.google.com/spreadsheets/d/1SraZo8r6YAR3Utd_x6QCman_lT3qHH3tU6K2RWvabEo/

reddit.com
u/BlitzAce71 — 2 months ago
▲ 9 r/fantasyfootballcoding+2 crossposts

Here's a Google Sheets doc I made to export all of your Sleeper fantasy football data (version 8 update)

Hi all,

If you're a fantasy player or commissioner like me, you might want your Sleeper data to be a little more accessible. Maybe your league has special rules that Sleeper doesn't support, or maybe you have payouts for weekly high scores, or you like to keep detailed record books of matchup history and player ownership and all of the other little details and stats that us sports people obsess over.

If that sounds interesting to you, I've developed a Google Sheets doc that lets you see all of your Sleeper league info in one place. This sheet will let you see weekly and yearly results for each team and player (every player's weekly info for Owner, League, Year, Week, Position, NFL team, Fantasy position that week, Points, Fantasy Opponent, Projected Points, Age, and relevant stats like yards, touchdowns, etc.). It will also pull in your league's schedule, draft results, transaction history, owned draft picks, free agents, and standings. New in v8, a Rosters tab shows the most recent Rosters for every team for a given league and year. For a snapshot of the rosters by week, check the Player Results tab. But for leagues in the offseason, the Rosters tab will show you today's rosters.

When you click the link, it will take you to Google Sheets. First go to File - Make A Copy and make your own copy of my document. From there, the instructions are on the first Info tab, but first you will need to authorize it through Google. On the Google warning screen, if you click Advanced you can then go to Go to Sleeper API and it will bring up a window for what permissions to allow. I've published versions of this sheet on Reddit for many years, and I promise that the authorization is not doing anything other than letting the script insert rows into the document. You could even open up Apps Script (Extensions - Apps Script) and run the whole code by an LLM and ask if it's doing anything weird before you authorize. Once you authorize, plug your Sleeper name and the season into the first page and then it will take a few minutes to gather all of the data.

One caveat is that the player info (such as which team they play for) is stored in one live source by Sleeper, not as historical data. Which means if you look up a league from 2018 and find, let's say, DeAndre Hopkins, it will show him as WR for BAL even though obviously he was on Houston at the time and has moved around several times since then. My point is, my sheet reads from Sleeper, so if you have any complaints about that data then they're the ones in charge of that.

If anyone has any questions, you are welcome to post here or I've put my contact info in the sheet. The goal is just to share this tool with you all because I've found the need to pull data out of Sleeper to be vital to a lot of the various rules and bookkeeping and responsibilities of being a fantasy commissioner and I hope it saves you some time or gives you new ideas or fun projects to work on for your leagues.

Link: https://docs.google.com/spreadsheets/d/1SraZo8r6YAR3Utd_x6QCman_lT3qHH3tU6K2RWvabEo/

reddit.com
u/BlitzAce71 — 2 months ago

Are the Lake Trio going to be globally available during Go Fest? It looks like probably not?

A little confused by how they're presenting the available mons during Go Fest, because they show all three of the Lake Trio, but then I just read where it says Azelf (Americas & Greenland), Mespirit (Europe, Middle East, AFrica, India), Uxie (Asia-Pacific) so I guess we're getting the same ones we always get? Boooooooooring. I was really looking forward to catching the other two...

reddit.com
u/BlitzAce71 — 2 months ago

I wonder if there could be some sort of logic puzzle the Faithfuls can use to solve the game...

Just as a thought experiment. What if they all go into the round table as a group and say, vote for the person to your right or we'll vote you out. Essentially breaking the round table by making it a massive tie. I assume production would step in and just say hey guys, cut it out and play the game, but maybe there is some way the Faithfuls can play that is unorthodox and either puts pressure on the Traitors or otherwise has a better chance of exposing them.

​

Maybe the group just picks a name out of a hat before the round table and all decide to banish that person? Because let's face it, player intuition about who is a faithful and who is a traitor is spotty at best, and blindingly wrong at worst. They may have more success banishing randomly.

​

Again, production might just kill all of these strats before they ever make it to the game, but it does seem like a solvable logic puzzle.

​

Or the group divides up into teams of 4, and each of them secretly tell one other person in the group who to vote for at the round table, but nobody reveals who is telling them. Shielding people from being blamed for voting for someone. I don't know. Something crazy like that would be fun to see if it helps or not.

reddit.com
u/BlitzAce71 — 2 months ago

Imagine if they made us use the stupid Boxes to store Pokemon like every other game lmao

I hate the Boxes so much dude. Howwwwww can we not sort, it's not a difficult concept at all. They know we'll have a pile of them in every game, they literally tell us we gotta catch em all. But organize them all? No sir, not for us.

​

If Go used the Box system it would be unplayable.

EDIT: what I mean is, in the mainline games, you have to sort all of your Pokemon manually, by picking them up individually and determining where to place them, and cycling between the boxes. In Go they're just all in one big Box and you can sort them by name, CP, time caught, dex number, etc. There's so much more sorting power in Go than in any other main Pokemon game. The Boxes from the main games are a terrible system.

reddit.com
u/BlitzAce71 — 2 months ago

Why are our internal websites and apps soooooooo slowwwwwwwwww, is this not supposed to be our strongest skill?

I am in awe of how poor every Oracle site performs, consistently, since I started here 4 years ago. Good grief, we're supposed to be some world leader in cloud infrastructure? We can't even get our HR apps to load without spinning for 15 seconds after every click! Do we just save all the good tech for our clients? What a joke.

reddit.com
u/BlitzAce71 — 3 months ago