Releases: olewis14/F1-League-Management
F1LM.v.1.41.4
This is one of the more significant updates I've done in a while, mostly on the back-end to improve performance. As always, reach out if you encounter any errors.
- Teams are no longer limited to two full time drivers. Simply indicate which team each drivers races for on the League Management page. Unassigned drivers will remain as reserves.
- Added team logos and car images throughout the sheet. Custom teams can be given a custom logos and car images, but will continue to not have custom colors for technical reasons out of my control. When adding custom images, use "copy image address" when finding images online. Custom images must be links, you can use imgur.com to achieve this if you make your own logos.
- Custom images seem to only work the desktop version of Excel. There is no current workaround that I know of
-
Race and Qualy Results now show all drivers in one table. You can turn of the inclusion of reserve drivers in these tables in the League Management page.
-
Updated track list, team names, and team colors for F1 2024
-
General formatting improvements to accommodate for these changes. Teammate comparison has been removed for this version; all relevant data can be found in the League Statistics page.
-
Fixed issues with the 30th race not updating points correctly
-
Fixed issues with average position change
F1LM.v1.40.2
- Added option to transfer penalty points and bans from previous season
- The sheet will assume that all automatically administered bans based on Pen. Pts. totals were already served. Reference your previous season's Race Director to see if there are any outstanding bans for each driver and enter them into the "Unserved Bans" columns.
- "Transferred Pen. Pts. / Bans" is the furthest right tab on League Management
- Fixed pole position points for sprint races
- Fixed issue where drivers on 11th team were shown as reserves on the standings
F1LM.v1.40.1
- Expanded lapped drivers order options for 'Time From Leader' to up to 22 drivers
- Various other fixes
F1LM v1.40
Update for F1 22
Sprint Races
- Customizable sprint race points, including options for fastest lap
- Added a section to the Track List that allows you to signify if a race is a sprint or a normal feature race
- Stats from all races are combined in the League Statistics page.
Updated Track List options to F1 22
As always, please reach out if you find any bugs. You can contact me on Discord: MASTERPLANE8#8620
F1LM v1.39.0
Customizable spreadsheet appearance and change of design
- The headers on each page can changed to one of six available colors
- The background of each page can be switched between light mode and dark mode
- Various parts of each page have been reorganized and redesigned. By default, the sheet's headers are now red and the background is now light in color.
Option to remove reserve drivers from standings
- New option in the Settings tab allows you to include or remove reserve drivers from the driver standings on the Championships page. All drivers will remain visible in the league statistics.
New options regarding appointing fastest lap to drivers who DNF
- Options include allowing/disallowing DNF drivers to earn Fastest Lap, and allowing/disallowing DNF who do earn Fastest Lap to earn the respective points. By default, the former is allowed and the latter is disallowed.
Quality of life improvements
- In an effort to minimize user error, all parts of the sheet that should remain untouched will now be locked.
As with all significant updates, there may be bugs. This is technically a Beta release until all identifiable bugs are dealt with. That being said, please continue to report bugs as you come across them. Thank you all for the continued support and enjoy!
F1LM v1.38.8
- Fixed an issue where drivers who DNF'd were no longer considered for Fastest Lap. The Fastest Lap point is still only given to a driver if he set the fastest lap in the top 10, unless indicated otherwise.
F1LM v1.38.7
- Fixed an issue with fastest lap indications for races 2-30
F1LM v1.38.6
- Fixed a problem with team ranking
F1LM v1.38.5
- Added 10 more driver slots on the League Management page
- Fixed an issue with the optional 11th team breaking the results tables
This update involves substantial changes to the roots of the spreadsheet. If you are porting over, make sure that results stay consistent and report errors.
F1LM v1.38.4
- Fixed Fastest Lap count for teams
- In Points Per Position section of the League Settings, changed preset "None" to "Custom" and removed activation option for bottom 10 points. It now activates when preset is set to "Custom." Enter points for all positions that you want to have points; leave the other positions blank or enter 0.