F1 2012 2012 Championship Spreadsheet

[Chris]

Hey guys,

A lot of people have been saying that they only play this game for the Grand Prix mode, but since that got taken out, keeping track of the championship points is a little tougher since you cant make a full season, but rather one race at a time.

So, i made this Excel spread sheet http://www.mediafire.com/?43fkthqdum9obbo

This just makes it a little easier for you all to keep track of the Drivers and Constructors points, unfortunately you'll have to enter the results manually yourselves, but all of the tracks, drivers and teams have been entered already, so that you dont have to make your own.

Happy Racing

 

[Chris]

**Updated V1.1**

http://www.mediafire.com/?ylqn3oharc3mm4r

- Moved "Total" column in between the Driver and Australia columns so it's easier to see the total points for Drivers and Teams.

- Updated to 2013 calendar changes.
Japan now R16
Korea now R15
Silverstone now R8
Hockenheim now R9
Valencia now R10

 

[Chris]

**UPDATED V1.5**

http://www.mediafire.com/?c52qif9klt7pd7w

Changelog:- Added cumulative totaling function for both Driver and Constructors, so all you have to do is enter in the results from your race and it will calculate the running total of each Team and driver's championship.

Screenshot: http://www.mediafire.com/view/?myfiles#

 

[Chris]

***Note***

Fernando and Felipe are coloured Red and Green respectively because Fernando is the driver i am using and Felipe is my Team mate. I just did this to make it easier to see my results.

However, feel free to change the colours to what ever you want for which ever driver you choose to be.

Enjoy.

 

[Deleted member 137812]

I made one too, http://www.mediafire.com/view/?9t199v9z9aeci11

download it and in left bottom click 2012

 

[Chris]

**FINAL Update V2.0**

New features:
- Colour coded results based scheme
- 10pts or more will give you a green cell (Good result)
- 1-8pts will give you an amber cell (Medium result)
- 0pts will give you a red cell (Bad result)

- Coloured the teams and drivers, just for added effect. Makes it slightly easier to navigate results.

Screenshot: http://www.mediafire.com/view/?o7q858zk8ohyaop
File: http://www.mediafire.com/?ayfqcja4l3et60u


EDIT: Apologies for the constant updating, it's just that i'm learning more and more each day about how to use Excel better. But I'm done now with this spreadsheet, so V2.0 is the final release.


Happy Racing

 

[pitti59]

**FINAL Update V2.0**

New features:
- Colour coded results based scheme
- 10pts or more will give you a green cell (Good result)
- 1-8pts will give you an amber cell (Medium result)
- 0pts will give you a red cell (Bad result)

- Coloured the teams and drivers, just for added effect. Makes it slightly easier to navigate results.

Screenshot: http://www.mediafire.com/view/?o7q858zk8ohyaop
File: http://www.mediafire.com/?ayfqcja4l3et60u


EDIT: Apologies for the constant updating, it's just that i'm learning more and more each day about how to use Excel better. But I'm done now with this spreadsheet, so V2.0 is the final release.


Happy Racing

fantastic, great work !

 

[Chris]

V2.1

Changelog:

• Which ever driver/team takes the most points in that round, that driver/constructors cell will get a purple fill which denotes maximum points scored for that round.
• The overall points leader (teams and drivers) will also get a purple box in the "Total" column.
• Plus other minor improvements that just make it easier to see results clearly.

Download: http://www.mediafire.com/?8ste3z784pqkk1i
Screenshot: http://www.mediafire.com/view/?hi4l3oxuil8awo7

Lol, now that really is the last update. The good news is that you can just copy and paste your previous rounds results into the table. Nice and easy

Enjoy!