search

masterplane8 / F1-League-Management

F1 League Management is an Excel template designed to help F1 2021 league owners track points, penalties, and other league statistics.
26 stars 3 forks source link

Customisation #9

Closed AidanDev closed 2 years ago

AidanDev commented 2 years ago

Is it possible to change tracks that are available to a track that isn’t there like Nurburgring. And is it possible to change the team colours as well?

I want to use this spreadsheet for a league in GT Sport

masterplane8 commented 2 years ago

Hey @AidanDev,

Changing the track list is something that I could Integrate. I would probably create another column on the League Management page that would ask you to enter a tracks three letter abbreviation for the Race and Qualifying Results tables, or I could just make a database of all the tracks in the most popular racing games and abbreviations for each one. I'll put some more thought into it.

For the team colors, it's a little tricky, and I'm not sure it'll be possible. All of the dynamic color changes are operated by Excels Conditional Formatting, which does not support user input changes very well. In other words, I can't make it automatically change to colors that a user asks it to change to. I'll look into it a little more and see what I can do