- F1 2018 spain setup how to#
- F1 2018 spain setup drivers#
- F1 2018 spain setup update#
- F1 2018 spain setup driver#
- F1 2018 spain setup download#
The ultimate aim for any setup on any track is to run with your downforce as low as possible, and your suspension as stiff as possible.
F1 2018 spain setup download#
If you are a MotoGP fans, you can download the MotoGP Dashboard and Championship version that is built with similar structure with this spreadsheet.Reduce your downforce as much as possibleīefore we get into a couple of example setups, here are a few basic principles that guide the process.
F1 2018 spain setup driver#
You should see team and driver standing positions are updated automatically as well as dashboard chart.You can change the points in each race circuit worksheets if points are modified because of specific conditions (race is stopped or others which affect any points given)
F1 2018 spain setup drivers#
Only top 10 drivers who earn points that can be selected. Put the drivers in correct standing positions by selecting it from driver dropdown list in column I.Go to Race Circuit scoresheet by clicking circuit link at the left side of each worksheets.To put Formula 1 result to race circuit scoresheets You can complete or corrected other information in the table if you found any any incorrect ones.
F1 2018 spain setup update#
To update it to 2018 season, all you have to do just typing the current order in Race # column (column H), or the second column after the number, as you see in picture above. The order is based on 2015 circuit order. All 2018 circuits with sufficient information already being put in circuit table.You can modify it to lower/higher number if one or more circuits are removed/added in the middle of the season. Set number of used circuits in cell K3.Set Year of Formula 1 season in cell K2.You should see a table as shown in picture above. Go to Race Circuit Worksheet (the link is at the right corner of team setup worksheet).Use insert function to add new flag image. You can add new drivers (replacement or wild card drivers) below the 22nd driver by adding their names, number, nationality and selecting their teams. You can modify current names to suit your language spelling. 22 rows have been used for current drivers. There 30 driver rows to put driver's names. There are 12 rows you can use to put team's names. If you are new, you can follow brief steps below :
F1 2018 spain setup how to#
If you are already familiar with this previous Formula 1 Dashboard and Tracker spreadsheets, you can start using this template and learn how to modify circuit orders from Modify Circuit link in Team and Driver setup worksheet. With a promising testing result for Ferrari and other Team, it should be interesting to see whether their results can be mapped in racing season to dethrone Mercedes, the reigning champion. And for year 20, winners of this circuit has been crowned as a Formula 1 Champion by the end of the season. This race circuit has always become the opening race for the past five years. The first race of 2018 Formula 1 season will start at 25th March 2018, in Albert Park, Melbourne, Australia. Anyway, I you can have both spreadsheets if purchased the editable version so you can test it before selecting the suitable one. You will see that if you change the circuit orders or add/remove one circuit, the flag will remain unchanged. You still need to change the flag manually, because the automatic flag adjustment function requires higher computer speed which it could annoy you while updating the score. You still need to purchase the fully editable version if you want to modify its layout or learn its chart/standing codes. You can modify teams, drivers and circuits without worrying about meshing up with the excel formulas inside. With this spreadsheet, you don't have to wait for me uploading the new or modified one because you can edit it by yourself. I already thought about adding automatic capability since 4 years ago but I haven't had a time to modify it. And it made me to modify and republished it again.Īlso, each year there is always been a changing of circuit order where I have to edit each circuit worksheets because points calculation in driver standing is referred to worksheet orders. It is changed in the middle of the season though. It happened in year 20 where I have to wait one week prior to the first race before published it just to make sure that the planned race circuit didn't change. This automatic circuit adjustment capability will allow you to modify it easily where you don't have to wait for new spreadsheet is coming up or or if there is any policy changes in the middle of the season because of unexpected conditions. You can use the previous versions since it has similar layout and you can change circuit names in particular worksheet. This is my 8th year Formula 1 spreadsheet. If you have ever used this spreadsheet, you will see the same dashboard and race circuit layouts with previous published spreadsheets. This is a 2018 Formula 1 Dashboard and Championship Tracker spreadsheet.