Formula 1 Calendar 2009

Posted on December 30, 2008
Filed Under Formula 1, Sports | 29 Comments

This spreadsheet is basically the same with the previous spreadsheet that I made for F1 Calendar 2008, except all driver and team information are still not completed because F1 regulator haven’t release their official press release regarding the team and driver for 2009 calendar. But, the race schedule is already fixed and there will be 17 races available for year 2009.

You can fill the driver and the team manually in this spreadsheet after all information are officially announced. And I remove all password protected worksheet, so you can easily unprotect the sheet if you want to learn about the formula I used.

If you want to get update about F1 information, there 2 sites that I usually visit and also been used as my reference on creating this sheet, those are www.formula1.com and www.f1-live.com

You can download the file here.

You can read and download my other templates below :

Tags: F1 2009, F1 Excel Spreadsheet, Formula 1 Calendar 2009, Formula 1 Excel Spreadsheet, Formula 1 Kalender 2009, Formula 1 Race Calendar, Formula One Calendar

Comments

29 Responses to “Formula 1 Calendar 2009”

Peter on January 25th, 2009 6:27 pm

I could use this for my simrace lueque.

Visit my site.
Admin on January 31st, 2009 5:14 am

You can use and modify it, just don’t forget to link back to my site. Tks.
trbk on March 8th, 2009 8:25 pm

je tjr cherche ca merci pour le document
Bob on March 23rd, 2009 4:38 pm

Hi, I’m not able to shuffle the driver’s around so their car number matches. For example Adrian Sutil (Force India) is down as No. 16 and when try to swap his position so he is showing No. 20, on the Team and Driver Standing tab it shows # N/A. This also applies to all other drivers who’s number doesn’t correspond.
Please advise, Thanks.
Neil on March 27th, 2009 11:42 am

Excellent, better than the wall chart I received with F1 magazine. It’s almost time for the season to start!
Roy on March 29th, 2009 3:49 pm

This is really nice. Thanks.
Daniel, Napoli on March 30th, 2009 10:05 am

Button?
He wins but there is not.
I add.

Thank you for your work.
nothing on March 30th, 2009 10:11 am

http://i44.tinypic.com/33or1uq.png
I am using OpenOffice, I see strange.

I see before, Daniel, you will make an updated xls file?

Thank you for your work.
Max on March 31st, 2009 7:39 am

Great Template!
Is ‘t possible to have the PW voor Table “Dummy Table Standings”?
I’m still learning and want to see the formulas
Thanks in advance.
Kind regards
admin on April 1st, 2009 4:02 pm

Hi Max,

I have uploaded the new one without password protection and filled with the Australian F1 race result.

Regards
admin on April 1st, 2009 4:04 pm

For people expecting this spreadsheet working properly in Openoffice, I am working it.

Regards
Jason Rebello on April 2nd, 2009 2:18 pm

thnx man! really nice;-)
anonymous on April 5th, 2009 3:14 pm

ahem … another problem.
Sepang! half points to drivers and teams.
John on April 6th, 2009 12:52 pm

TYesterday we had a race, Malaysia, that gave half points. Is there anyway to adjust for this?
Lynda on April 6th, 2009 1:43 pm

Hi, how do I amend to put in half points (Malaysia). Great chart, thanks.

Lynda
admin on April 6th, 2009 4:13 pm

To Lynda and John and other people that needs to put Sepang points to the table, you can do this step :

- In “Race Result” worksheet, go to Menu > Tools > Protection > Unprotect Sheet
- Go to cell E23 – E30 which is the points for Sepang race and change the points which is half of usual points
- You can go protect the worksheet again or leave it unprotected
- Go to “Team and Driver Standings” worksheet, unprotect the worksheet, and adjust column “I” by extend it using your mouse so it can display the points correctly. If you are not adjusting the column, the sum of the points is still correct, but it doesn’t display you the correct display.

Regards
Daniel, Napoli on April 6th, 2009 4:28 pm

thank you, “admin”.
John on April 6th, 2009 7:14 pm

Thank you admin. for the Sepang adjustment, works a charm!

John
Jose on April 6th, 2009 7:22 pm

Hi, nice template! Is possible complete the race result to 20 drivers?. It’s important know all the positions to calculate de final standings and resolve the position of the “0 point drivers”.

Thank you
Nick on May 10th, 2009 1:30 pm

Hi again, could you please explain how the dummy table standings sheet works? On my copy it is blank! I’m trying to adapt the sheet to work in another series and so have changed all of the drivers and am trying to adapt the sheet to work with 3 classes in each race…Very confusing!

Nick
Nick on May 10th, 2009 1:51 pm

Ok ignore that! Figured it out!
Nick Simpson on May 10th, 2009 5:04 pm

Hi, do you think you could drop me an email? I would really like some advice on adding the 3 class breakdown to your template if at all possible?

Thanks

Nick
Gordon Tatler on June 19th, 2009 8:54 pm

Just seen this spreadsheet. Great. Saw comments about changing to half points for Sepang race, which worked OK, but would point out that the number of wins for Button (who came first in Sepang and gained 5 points) is incorrect as the formulae only count up the 10 point cells.

To solve this FOR THIS PARTICULAR RACE go to the standings page and go to G6. Change =COUNTIF(H7:X7,10) to =COUNTIF(H7:X7,10)+COUNTIF(I7,5).

Hope this helps.

By the way, why not change the driver’s full names to their surnames and then sort the complete table on the team and driver sheet into driver name order. Re-enter any race results. This makes it MUCH easier to enter results.
Gordon Tatler on June 19th, 2009 8:56 pm

Ops ! I missed out an important instruction. After changing G6 above, copy the cell and paste it into g7 to G25.

Sorry about that.
neil on August 8th, 2009 9:21 am

This is an excellent sheet,well done.I am only learning and can’t find your dummy table,anyway its amazing what you can do with excel when you know how.
Mark on November 11th, 2009 1:36 pm

Hi, I have added on Kamui Kobayashi on the Team and Driver page, but when I put him in the Race Results page the formula for Team and Driver Standings doesn’t work. Please help.
Stian on December 14th, 2009 11:17 am

Will you make a new one with the 2010 points sytem now? Excelent sheet, I use it for points scoring at our RC racing club! Thanks
Zsozsotex on February 21st, 2010 4:33 pm

Hy,

I want to upgrade the 2009 calendar into the 2010 calendar.I have difficulties to enter new teams.I had introdused 11 team, but the last 2 teams I could not enter, it gives me trouble (# N/A ).It also are 19 circuits and it will be another points system.Please help me, because I want to be ready for the first race.Thanks
Ryan Margerison on December 29th, 2010 9:24 am

This is great i could use it for my game F1 2009 on my psp thanks and if you have any coments or want talk to me about updates or any soccer templates.

Reply to my ukryan243@hotmail.co.uk email

Yours Sincerely
Ryan.M