Beside soccer, I also like to watch Kimi Raikkonen, Lewis Hamilton, or Felipe Massa racing each other in Formula 1 Grand Prix. By the time I finished this excel spreadsheet, all Formula 1 team and driver are on preparation for racing in Monaco.
At the beginning, I would like to add the picture of each team and driver in my excel sheet, but I am worried about the copyright issues, so I made just a simple calender schedules and automatic standings calculation without any pictures accessories inside, except the small circuit pictures.
The sheet consist of four worksheets. The first worksheet is a standings result of each team and driver which will change automatically based on race results, as shown in picture 1.
The second worksheet is an all season schedule where you can see the podium results of each races and a shortcut to detailed race if you click the name of the grandprix, as seen in picture 2.
The third worksheet is the race worksheet. You can do experiment, guessing the winner or finally entry the right driver position for each races to see the correct standings in the worksheet 1, as seen in the picture 3.
Just in case if one or some driver needs to be replaced because of accidents or other reasons, you can put a new driver in the worksheet 4. Just put the driver name, nationality and team, and all the formula will follow to include the new driver in the main standings, as seen in picture 4.
Basically, I still think I can add other automatic feature, but I think this worksheet is enough already to be used for the beginning. I will improve and add other automatic functional in next version.
You can download the worksheet here.