Excel Templates | Excel Spreadsheets | Formula 1 – 2008 Schedules and Results


Free Excel Templates

Formula 1 – 2008 Schedules and Results

Posted on May 19, 2008
Filed Under Formula 1, Sports | 5 Comments



Share

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.
Formula 1

[picture 1 - enlarge]

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.

Formula 1

[picture 2 - enlarge] 

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.

Formula 1

[picture 3 - enlarge]

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.

Formula 1

[picture 4 - enlarge]

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.

Have fun.




You can read and download my other templates below :

Tags: , , , , , , , , , , , , , ,

Comments

5 Responses to “Formula 1 – 2008 Schedules and Results”

  1. james on June 12th, 2008 12:30 pm

    The drivers list does not show up in the race results sheet when selecting the drivers.

  2. Nick on May 9th, 2009 12:57 am

    Hi,

    I have just been looking at your Formula 1 schedule and results table and was wondering if it might be possible to get an unsecured version?

    The reason being is I’m trying to create a points table for a race series at present and am really struggling to get something similar using lookups. The problem is that the format is different with 3 classes requiring a overall podium and 3 other podiums for a b and c class. I would like to be able to use your template as a base but it won’t let me change anything. If you could help me out I would be most grateful!

    Regards,

    Nick Simpson

  3. admin on May 9th, 2009 2:49 pm

    Hi Nick,

    You can download my latest version without password protection inside spreadsheet in http://exceltemplate.net/sports/formula-1-calendar-2009/

    Regards

  4. Ivan on June 23rd, 2009 10:21 am

    I can’t change the database in the scorefield.

  5. trbk on February 28th, 2010 5:46 pm

    i need the password

Leave a Reply