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
– 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 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, 7,060 hits)