Excel Templates | Excel Spreadsheets | Formula 1 Schedule and Scoresheet 2013



Formula 1 Schedule and Scoresheet 2013

Posted on February 19, 2013
Filed Under Sports | 13 Comments


This is a Formula 1 Schedule and Scoresheet template for season 2013. New season will commence on 17th March 2013 in Albert Park, Melbourne, Australia. There is no major changes in this template, except the schedule. Based on schedule released by FIA, the first 7 races for season 2013 will be the same with last year races. Last year, those 7 races brought out 7 different winners. So, it will be interesting to see how the outcome from those 7 circuits this year. There will be no Michael Schumacher this year, and Lewis Hamilton takes Schumi’s seat to become Nico Rosberg teammates in Mercedes. We will see how far Mercedes will go with this line-up. Redbull, Ferrari, McLaren and Lotus are maintaining the same line-up with last year.  So, let’s see how fast and how strong those cars to race for 2013 champion.

F1 Dashboard Season 2013 V1.61 1024x404 Formula 1 Schedule and Scoresheet 2013

If you were using my Formula 1 2012 schedule template, I believe that you won’t have any difficulties on using this 2013 template because I made no major changes. But, if you are new to use this template, you can read quick descriptions of the spreadsheet below :

Dashboard
This is a tracker worksheet where you can
- Monitor the progress of top 10 drivers
- Monitor the progress of top 5 constructors
- Remind you the date for the next race
- See the podium finishers of the last three races

Driver’s Championship
- This is a worksheet where you can see the standing position of all drivers as well as their earning points in each race

Constructor’s Championship
- In this is a worksheet, you can see the position of all constructors and their points in each race

Team Setup
All drivers except one driver from Force India have been placed in Drivers table. It should be 22 drivers to complete the table. And there are 11 constructors that have been placed in Constructor’s table after HRT was pulled out from this season participation because of financial issues.

Race Scoresheet
This is an area where you have to update everytime the race is finished. You can click the country name at the left side of race worksheets to type the results and move between races.

To type the results, just select the driver’s name based on their position in the race. The nationality and team’s name will shown automatically. There is a point at the right side which correspond with FIA F1 rule that you can adjust if there is some changes or penalty applied to the drivers. Beside typing all 10 drivers who earn points, you can type a driver who become a pole sitter in pole position cell.

I add information regarding the last five races winner which should help you seeing the facts or make some prediction. And also there is a short circuit information without a picture of circuit layout where you can put your own circuit images. I haven’t had time to find free images, but you might be have time to find it icon smile Formula 1 Schedule and Scoresheet 2013 .

By the time I write this post, that one race, race no 10, is still tagged TBA. Also, Force India hasn’t announced the second driver who will race for them. You can visit this site and re-download it again when the remaining one race and one driver become available. Or, you can update it by yourself since all shown worksheets are not password protected. Also, you can update flags, name, add more circuit information, change color etc. So, if you found any errors in writing or information , you can fix it by yourself, but I would be pleased if you could send me those incorrect information so I can fix it in the later version.

zip Formula 1 Schedule and Scoresheet 2013  Formula 1 Schedule and Scoresheet 2013 V1.62 - 19 races (335.2 KiB, 3,118 hits)

There are two dummy worksheets with main formula which is password-protected. But, if you are kind enough to send me 5 bucks, I will send you the unlocked one where you can learn the formula which built this spreadsheet icon smile Formula 1 Schedule and Scoresheet 2013 .

Get Unlocked Formula 1 Schedule and Scoresheet 2013
 Formula 1 Schedule and Scoresheet 2013

Finally, I have finished creating the 2013 Pool version to be used by maximum 25 players. You can download it here. If you want to extend the players or just want to see the excel formula behind this spreadsheet, you can paypal me through the paypal button in “about” page inside this spreadsheet.

zip Formula 1 Schedule and Scoresheet 2013  F1 Pool Season 2013 V1.85 - 25 Players (693.1 KiB, 782 hits)



Comments

13 Responses to “Formula 1 Schedule and Scoresheet 2013”

  1. Drew Adamson on February 23rd, 2013 12:16 am

    On the graphs, you have the image of a car and the bar behind it, how did you do that ?

  2. Joe Beard on March 3rd, 2013 10:08 pm

    I’m trying to make a one for this year but I’m having trouble with ranking the drivers and constructors. Is there any way you can help or not?

  3. Mark on March 9th, 2013 3:26 pm

    The full calendar is now on the website which is 19 races

  4. Jan on March 10th, 2013 5:51 pm

    There are only 19 races. How can i delete race number 10.

  5. Frankie on March 15th, 2013 12:18 pm

    No icon for Force India so it does not show in the progress chart.

    Otherwise top spreadsheet.

  6. Musadya on March 15th, 2013 3:04 pm

    Dear all,

    The spreadsheet has been updated to accommodate 19 races only and chart error also has been fixed.

    Regards

  7. XlaKra on March 17th, 2013 11:21 am

    There is an error with Marussia pilots: Max Chilton is number 23 and Luis Razia was replaced by french Jules Bianchi (with number 22).

  8. russ on March 18th, 2013 1:52 pm

    Thanks for the update!
    Great spreadsheet.

    I would like to expand the dashboard to display all drivers (instead of top 10), and also add our local fantasy racing group’s scoring formula to the spreadsheet.
    If I send you $5 for the password, does that open up the entire spreadsheet so that I can do this?

    Thanks again!

  9. Mark on March 18th, 2013 7:21 pm

    Hi,

    With the Maurussia driver errors you can change that manually rather than waiting for a new verion to be uploaded.

    Thanks

  10. Rob on March 25th, 2013 4:24 pm

    Hi,

    Is the 2013 pool version available, I cannot seem to find a version.

    Thanks

  11. Nathan Houston on April 29th, 2013 11:00 am

    Is there ANYBODY who can simply tell me how to make the championship formula. I don’t want teams or drivers, I just want position 1 to mean 25 in the points column, and all the other ones. PLEASE AND THANK YOU

  12. Darren O on June 16th, 2013 1:09 am

    Dear Mr Musadya,

    Our Online Race League is trying to use the F1 table we use for our Championships, which is ok but only limited to 10 Places, what can we do to extend the points from 10 to 20 ?

    Also our other championship has 2 races per round with points from 1st to 20th, is there any way we can add 2 races to each Round. Are you able to assist if we Pay $.

    There is nothing on the Internet that is even close to what you have.

  13. Mark Solts on February 17th, 2014 1:53 pm

    Are you working on a new version for 2014, have enjoyed using this for the past few years and look forward to using it again if you do.

Leave a Reply