NCAA Fantasy Track and Field Game

https://docs.google.com/spreadsheets/d/1Bww9TMSVCv3ozLYB26-zwEmaqKknn_Yp51lFr48QB7Y/copy

Fantasy NCAA Track & Field Game

This is a fantasy game for the NCAA Track & Field Championships, designed to let you and your friends draft athletes and compete for the most points!

How the Game Works:

Draft Your Team:

Each player drafts a team consisting of:

2 runners each in the 800m, 1500m, 5000m, and 10000m.

1 relay team in the 4x400m.

You can only draft a specific athlete once across all teams.

There’s a Draft Board where you and your friends can track picks.

Scoring System:

Scoring combines NCAA placement points (10 for 1st, 8 for 2nd, etc.) and time-based points using an exponential formula.

The faster the time, the more points, with a maximum of 20 points for breaking the NCAA meet record.

Slower, tactical races still earn points but fewer compared to record-breaking times.

Input Results:

Once the official NCAA entries are announced, update the team sheets with athlete names.

After each race, enter the finishing time and placement in the designated cells.

Points will automatically update on each team’s sheet.

Team Rankings:

A Ranking Sheet displays each team’s total points and updates automatically as results are entered.

The ranking list is sorted in real time based on the total points.

You can refresh team names from the "Fantasy Track" menu after renaming a sheet.

Additional Notes:

The game isn’t professional, and the scoring system is fine-tuned based on my own ideas and testing.

The coding and sheet setup might not be perfect, but it’s functional for the game!

The setup will be fully ready once the official NCAA meet entries are added.

Feel free to customize the scoring or draft rules to fit your group’s preferences!