Back to Boards

Google Sheet for Your Leagues


Google Sheet for Your Leagues

I wanted to share a spreadsheet I made in case anyone would like to use it.

It's all automated. One sheet will show you your current overall record for baseball, basketball, and football all in one place (scraped from your user profile), You can save the current state of the last time you saw it, so the next time you open the sheet you can compare how much your wins and losses went up since you last saved, then you can sync it again, rinse and repeat.

Another sheet has a list of all your teams from each league. has a link to the teams homepage, has win loss record, games back from first, win/loss streak, last 10, games remaining in season, and my favorite part is the hours/minutes left until next simulation.

the third sheet has a dropdown box of all your teams/leagues and whichever one you choose will show either your batting lineup, starting rotation, or bullpen based on what you choose for second dropdown. it has all the compiled stats. bonus, it also shows your batter and pitcher who are slump busted AND the eligible players that you can slump bust.

Re: Google Sheet for Your Leagues

Hopefully the notes on the first sheet are helpful, but let me know if something doesn't make sense and i'll try to explain.

Here is the link to view:
https://docs.google.com/spreadsheet..

If you want to make a copy, then use this link:
https://docs.google.com/spreadsheet..

Re: Re: Google Sheet for Your Leagues

one more thing, in case i don't have an opportunity to respond to your questions right away, just know that chatgpt and google gemini helped me build it. you can copy and paste screenshots, or formulas into google gemini and tell them what you want and they give a solution which is a great way to get an immediate answer
Follow us on social media
Pennant Chase offers free online baseball, basketball and football simulation leagues, where users draft players from the history of sports, manage their team, and results are simmed based on historical stats.
           
Site sponsors
Slo-Pitch Central
2001 - © Bacci Media LLC   |   Terms of Use   |   Privacy Policy