F1 League Management Tool - Excel Sheet
F1 League Management is an Excel template designed to help F1 22 league owners keep track of championship points, league administered penalty points, and tons of statistics. All you do is enter the results of each race, including each driver's qualifying result, their finishing time from the leader, and their fastest lap, and F1LM does the rest.
Download at: https://github.com/masterplane8/F1-League-Management
Page Overviews:
League Management
Customize aspects of the sheet such as
- Team names and tracks
- Points earned per position
- League penalty points needed to earn a session ban
- Points for pole and fastest laps
- Other options that personalize your league.
Set the league's track list, all participating drivers, and team assignments.
View the Race Director, which shows the next race in the league’s calendar and penalty information for each driver. You can refer to this page before each race to check for bans.
Championships
- Standard championship standings for drivers and constructors. Includes an indication for magnitude of position changes as a season progresses.
Final Classifications
- Enter all post-race information that the game offers into these tables. There are four categories that must be filled out for each participating driver.
- Qualifying Result
- Time From Leader
- Fastest Lap
- Reserve Team (only for reserve drivers)
- Any league administered penalties including time penalties, penalty points, and bans are entered into each race's corresponding penalties table, located next to each race’s final classifications table.
Race/Qualifying Results
- Separate pages that show each driver's final result in each session.
- Race Results indicates drivers who earned fastest lap and color-codes results by position.
Race Reports
- Automatically filled out each for each race. Consider this the equivalent to the in-game post race results.
- Below each race report are incident reports. In these tables, you can present league administered penalties and give explanations as to why they were administered.
League Statistics
- Various league related statistics for all drivers and teams including:
- 16 unique statistics for each driver
- 12 unique statistics for each team
- Graphs that show the progression of driver and team points over a season.
Teammate Comparisons
- Side-by-side comparisons of drivers and their teammates. Compares 11 statistics and indicates which driver leads in each statistic.
