/F1-League-Management

F1 League Management is an Excel template designed to help F1 2021 league owners track points, penalties, and other league statistics.

F1-League-Management

F1 League Management is an Excel template designed to help F1 24 league owners track points, penalties, and other league statistics.

  • For help with transferring data to new versions of the spreadsheet as they come out, reference https://github.com/masterplane8/F1-League-Management/wiki/Tranfering-Data-to-a-New-Version

  • If you are experiencing problems or running into errors in the workbook, please look at #3 for possible solutions.

  • F1LM is free, but donations are welcome and appreciated. Paypal: @olewis380 Venmo: @Owen_Lewis

  • Contact me on Discord: owenlewis

  • I also costumize this worksheet for non-traditional leagues at a cost. Charges are based on the scale of the customization.

League Management

  • Customize aspects of the sheet such as

    • enabling custom team names and tracks,
    • how many points each position will earn drivers
    • how many points it takes to earn a qualifying and race 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.

F1LM is free, but donations are welcome and appreciated. Paypal: @olewis380 Venmo: @Owen_Lewis

image

image

image

image

image

image

image

image