Formula 1 2011 Schedule and Championship Tracker

Posted on March 25, 2011
Filed Under Formula 1 | 41 Comments

Finally I finished this Formula 1 schedule and scoresheet tracker template for season 2011 which has been redesigned to accommodate more features comparing with the previous 2010 version. I created this template to work well on excel 2007/2010 version. You can download and convert to excel 97-2003 version but I haven’t test it whether it work well or not.

I redesigned it because I am bored with the outlook of the old one and there are many enhancement can be made with excel 2010. Yes… I used excel 2010 to create this template.

This template is still created without any macros, so you don’t have to enable macro when you open and use this template.

You can explore this template to see which parts that has been changed. Basically, there are five big parts in this template :
- Team and Driver Setup
- Dashboard
- Driver’s Championship
- Constructor’s Championship
- Circuit Information and Race Result

And there is no sheet tab in this template, so you will move from one sheet to another using the hyperlink at the left side of each sheets.

Team and Driver Setup Worksheet
This is the worksheet where you have to verify whether all information are correct and this is the place where you can add any replacement drivers. Except the layout, all information remain the same with the previous version.

Dashboard Worksheet
Dashboard worksheet is the new worksheet where you can see the progress of 5 top teams and 10 top drivers after each races. Of course this chart will be changed after you fill the race results. You will see also the latest podium results of previous three races, the next race and current month calendar. All races information will be based on today’s date. In this worksheet, you don’t have to do anything since all information will be automatically updated based on dates and race results.

Driver’s Championship Worksheet
Driver’s Championship worksheet contains driver standing table that will show all driver’s point achievement after each races. I remove the picture of nationality flag which dynamically follow the position of each drivers since it make the excel running slow. I can make it quicker using macro program, but I don’t think this is an important feature that has to be available.

I split the driver’s championship and team championship standing, so you can access and see it easily without scrolling down your bar like in the previous version.

Constructor’s Championship Worksheet
Constructor’s championship worksheet contains constructor’s point information from each races. Format of this worksheet is the same with the driver’s standing table and also the same with the table in the previous version. The different only on its layout.

Circuit Information and Race Result Worksheets
In the previous version, you saw one worksheet that contains race schedule and one worksheet that contains race results where you have to fill it within one column. I feel uncomfortable with this although the reason I made it because I want to simplify the excel formula and skip the possibility of using macros.

Now, all those boring layout is gone. I totally redesigned these worksheets. From a long column where you have to scroll down to enter the result, now you can move between each races easily. Just select the race from country information at the left side and you will be brought to corresponding race where you can enter the race result. And you can add more circuit information in these worksheets. I put some important circuit information in these worksheets, for example circuit length, number of laps, lap record, race distance, race past winners etc, except the picture since I didn’t have enough time to make one and I learn that most of circuit pictures are not free where you can use only for personal purpose. There are many circuit pictures available in internet. You can copy and paste in my template, but make sure that you only use those pictures for your personal purpose.

OK guys…. Let’s start your engine. The race will start in Albert Park within three days. Sebastian Vettel, Fernando Alonso, Lewis Hamilton, Jenson Button and Michael Schumacher are on its way for their next crowns, aren’t they? Five world champions racing together? It should be a fantastic Formula 1 season. What a pity that Kimi Raikkonen and Jacques Villeneuve are not participating in this season. But, it will be a tough season for Mark Webber and Felipe Massa to fulfill their dreams to become F1 Champion…

Feel free to modify the layout or add new contents in this template as long as you don’t remove the copyright. And you can give me ideas about other important things that should be available in this template.

You can download the Formula 1 2011 Schedule and Championship Tracker below and basically you just fill the result of each races at corresponding circuit worksheet to track your favorite driver and team progress. Please let me know if you found some bugs.

Formula 1 Calendar Season 2011 (435.4 KiB, 5,840 hits)

Comments

41 Responses to “Formula 1 2011 Schedule and Championship Tracker”

aissa on March 25th, 2011 8:14 pm

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Mark on March 26th, 2011 4:23 pm

Can I ask you where you got the example circuit diagram for the Race Result page on here?
Mark on March 26th, 2011 4:51 pm

Nevermind, I found it
mickey on March 27th, 2011 2:34 pm

Thank you, much more better than F1 2010.

I found one small error in this excel…
~ Adrian Sutil is from Germany not Brazil….
~ Paul di Resta actually is from Great Britain.
angelo on March 27th, 2011 9:05 pm

azz, sembra un ottimo lavoro,
ma io uso ancora office 2003, e con quello questa versione non funziona dice “solo lettura” e non
autoaggiorna.

e’ possibile avere anche la vers. per office 2003?
cosi ti puoi rendere conto di quale sara’ la piu scaricata…
grazie
ciao
Neil on March 28th, 2011 8:12 am

I’m using Excel 2008 and found that once I’d clicked on any of the F1 races on the left I couldn’t go back to the dashboard, drivers championship or constructors championship the link is not working.
sirihkuning on March 29th, 2011 1:31 am

I found there’s no #13 car in the Team Setup. Is it intentional?
Mark on March 29th, 2011 3:12 pm

There is no Car 13 because there isn’t one
mickey on March 29th, 2011 5:32 pm

I found one more error
~ Team number 10, Lotus is using Renault engine not Cosworth…

In Formula 1, that is no car 13, because 13 is not a good number…
mickey on March 29th, 2011 5:48 pm

correction:

SINGTEL SINGAPORE GRAND PRIX
Ty on March 29th, 2011 10:52 pm

Is there any way to get an unlocked version. I am trying to add my pool’s data to it?
Pål on March 30th, 2011 1:25 pm

Will you please make a template for some of the american sports? NFL, NBA and NHL.
If you have copyright problems with them, can you just please make a template where we can fill in information, like the generic football season template. Please Please, make this happen.

Best regards, your doing a great job.
Jim on March 30th, 2011 3:29 pm

Dude, Incredible! Better than last year! Thank you!
SASHA1988 on March 31st, 2011 8:42 am

and a password to see what formulas on a sheet of dummy table standings
popasmurf on April 1st, 2011 7:42 pm

Unable to open spreadsheet, it is in ‘ xlsx ‘format (is this from Excel 2010) I only have 2003 version. Can you help please?.
Carlos Barito on April 5th, 2011 6:43 pm

R. Musadya, what is your email? btw, you’re a genius!
James on April 10th, 2011 10:46 am

How can points be changed for a single race, for example if there’s a race which only grants half-points like Malaysia 2009?
Endor on April 10th, 2011 1:00 pm

I use Excel 2003 this Version of your template
are never compatible to Excel 2003. I am only able to open it with write protection. Please made it
Excel 2003 compatible. Actually it is useless.
Thanks for your hard work.
Mark on April 10th, 2011 1:49 pm

Does anybodys next race date show Shanghai or Melbourne, because I can’t get mine to show the date for the next race (which will be Shanghai)?
popasmurf on April 10th, 2011 10:04 pm

Hi I am still unable to use the 2011 F1.Any ideas how to save it as a 2003 sheet?.
popasmurf on April 10th, 2011 10:06 pm

Hi Mark the Shangai race is 17th April 2011.
Miga on April 11th, 2011 2:52 pm

excellent revamp of the schedule
RogW on April 14th, 2011 5:15 am

Good work, this inspired me to create something similar.

The only hurdles I have come across are how to differentiate people on the same points…. I have done this via a method of adding small values to each racer, but this doesnt take into account if one has more wins/2nd places etc over the other one.

Also I have added a countdown timer for the practice and race. Trying to make it a realtime countdown but it stuffs up and only refreshes when I make changes to a cell.

Also how do you add the small cars to the bar charts, I can see that you have minused 12 from each bar chart ( obviously the size of the car graphic ). Did you make the car graphics yourself ??

Any ideas on the first 2 would be awesome.

Cheers.
RogW on April 14th, 2011 10:11 pm

fixed up racers who are tied on points, is a bit of a hack way of doing it but it works

now just need to work out the VBA part for my timers !
lauri on April 17th, 2011 3:56 pm

You rock! Thank you for your hard work and kindness of sharing!
Kimika on April 19th, 2011 5:44 pm

Where can I register? I can’t download the file because it says:”You need to be a registered user to download this file.” Thanks for the help.
Mark on June 3rd, 2011 2:07 pm

Now that the Bahrain GP will be held on 30 October and the Indian GP the last race of the season could there be an update please
David on June 3rd, 2011 5:17 pm

Are you going to update the spreadsheet and add the Bahrain race back to the calander?
Biju on June 4th, 2011 1:58 pm

Could you please update the file to include Bahrain and put the Indian GP as the last race on the calender? Thanks for the great job done!
Mark on June 4th, 2011 3:03 pm

You can readd the Bahrain GP yourself, just change the Indian GP to Bahrain. Not sure how to do the Indian GP as the last race
Mark on June 10th, 2011 8:46 am

Another update:

Bahrain GP has been cancelled for 2011 (will return in 2012) which means that Indian GP will move back to its original 30 October date.

We are still waiting for the latest calendar update from the FIA.
ginge22 on July 18th, 2011 11:58 pm

If you download the “Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats” you can open 2010/2007 docs in 2003
Carl on September 7th, 2011 6:28 pm

Can the creator send me an unprotected version? As I only run Microsoft 2010 starter edition and do not have the power to unprotect the documents
F1Fanatic on September 21st, 2011 9:52 pm

Hi:

We deownload your Template.

¿Can we add a new circuit?

We are an online Driving Championship and we need to add new circuits.

Greetings , F1Fanatic
F1Fanatic on September 21st, 2011 10:04 pm

Sorry for disturbs.

If we need more office knowledges , we try to learn it.

But we only need to know how to add another GP to the list.

Thanks a lot.
Justin on September 26th, 2011 11:27 am

I do not think this spreadsheet works on excel 2003.
Can you help?
darmawan on October 26th, 2011 2:40 am

Great template. Thx
Endor on February 6th, 2012 3:31 pm

Will there be an new Version for 2012
available?
Cheers
Endor
vintly on February 11th, 2012 10:29 am

Hi, echoing Endor’s comment – is there a 2012 version in the pipeline? It’s a brilliant brilliant thing, I hope there is!
Double cheers, vintly.
Biju on February 13th, 2012 3:20 am

Hi, waiting for the 2012 version, as the F1 season testing starts…waiting in anticipation!Thanks for the great work!
Matthew Gooch on March 2nd, 2013 5:40 am

Hello can someone please update the drivers so that I can have Kimi Raikkonen on this log and also remove Micheal Schumacher please many thanks Matthew Gooch