ryanbuckner

I want to share a little project I've been working on. This is for the Masters Tournament but can be used for any Golf Tournament on ESPN. : Please leave me feedback and questions here

Features:

• Live scoring (every 1 minute refresh) from ESPNs API

• Clicking the tournament image on the Picks sheet will manually refresh the data

• Allows for up to 5 people to draft up to 12 golfers

• Automated scoring of relative rankings. For example, 60th best drafted golfer gets $1, best golfer gets $60. The game assumes each player buys in and earns their $$ back.

• Only drafted golfers count. So the rest of the field isn't considered in the rankings which are displayed on the Picks sheet

• Automated Cuts and Withdraws. Cut and WD golfers get $0 allocated. Their amounts go into a pot shared by winners of Ranks 1-3. Cut pot amounts can be configured on the All Players sheet

• The Players sheet allows you to Reset the sheet, which removes all the drafted golfers, removes your players, and asks for a Tournament ID for a new tourney. You can get tournament ids from the URL of an ESPN tourney webpage. Example:

• The players sheet has a Draft Order button to use the wheel of names to help randomly select your draft order

• Images of the top 15 in relative ranking - remember, anyone not drafted doesn't count

• Cells C3:K14 allow the golfers from that tournament to be selected. Conditional formatting will alert you if 2 people try to draft the same golfer. Note that ESPN typically loads the golfers for a tournament by 1PM EST on the Tuesday before the tournament. If ESPN hasn't loaded the golfers, you cannot draft yet. The sheet will attempt to load the field every minute until they are loaded by ESPN

• Triggers are created when a new tournament is reset. The trigger will be deleted when the tournament ends

• The Chart Data sheet tracks players' progress throughout the tournament

Missing Features:

• The biggest missing feature is handling playoffs in the event of a tie. The ESPN API doesn't make it easy to do this so I haven't created a solution. I usually manually change the score of the #1 golfer temporarily when this happens. This is done on the Live Scores sheet.

• The snake draft numbers are entered manually. So if you have only 4 players, you'll have to manually change columns B,D,F,H,J in the Picks

• Tournament images are not automatic. When you change to a new tournament simply edit the image on the Picks sheet and replace it with your own

This is somewhat of a re-post so forgive me. The last post was initially about something else.

I have created a Google Sheet that pulls real time NFL scores from the reliable ESPN API. I've made this editable by all, so please feel free to add new features.

Here's the sheet:

UPDATE: New sheet for 2023-24 season

UPDATE: New sheet for 2024-25 season

UPDATE: SAME sheet for 2026-27 season

The same sheet can now be used for multiple seasons. Go to the Admin Console and archive the last season. Then change the season and rerun the data load.

Features:

• Pulls all NFL game data from ESPN into the Live Scoring sheet by Week

• Archives previous years

• Trigger can be set to refresh the data at chosen increments

• Week Filter sheet allows for data set to be filtered by week

• Week Filter sheet allows for completed games to be hidden

• Week Filter sheet will highlight the team with possession of the ball (during game)

• Week Filter sheet shows the timestamp when Live Scoring was last refreshed

• Now includes pre-season

UPDATE:

To auto refresh a copy you'll create a trigger that runs the function "main".

Here are some instructions:

1. go to Extensions AppsScript

2. On the left side choose Triggers

3. On the bottom right , Choose + Add Trigger

4. Choose which function to run - main

5. Select event source - Time driven Select type of time based trigger - minutes timer

6. Select minute interval - Every 5 minutes