WDC and CWC self filling points table for 2013 season

[stefa]

This is something that I've made years ago, and now I am using it to fill points after each race, so I can have a better view on how the points were taken during season.
It is not super sophisticated thing, but it servers the purpose.
If any one of you fellow tifosi have some ideas and know how to make it better, feel free to contribute.
I hope you like it.
Enjoy and hopefully at the end one of Ferrari drivers, and Ferrari itself, will finish with the most points won!

[wacc]

Thanks for sharing.
I am using this tables instead:

http://en.espnf1.com/f1/motorsport/s...late=standings

[Greig]

Nice, thanks

[NickEice]

Oh man the things we could do! Some nice =vlookup() formulas and get it auto pulling from a table where all you have to do is put in the finishing order of each race. Excel dork here. I live in excel for my job.

[NickEice]

Hmm I noticed your constructors table doesn't flow. You'd need more formulas rather than A+B.

It would take a "sum" and two "if" statements most likely.

If I get time this weekend maybe I will play with it.

[NickEice]

OK, see my attachment. All you have to do each race is go to the Race by Race Input tab and insert the drivers in their finishing order. It is imperative that the names are spelled correctly. I usually just hit "=" then click the name from a previous race that way it always is correct. When I am done then I copy and paste special as values.

Then after you have inputted the names you have to sort each standings schedule.

For the drivers table highlight C5 through Z26 then go to sort & filter -> custom sort. Sort column Z Largest to smallest.

For the constructors table highlight C32 through Z42 then go to sort & filter -> custom sort. Sort column Z Largest to smallest.

Let me know if you have any questions!

Attachment 5242

[stefa]

Oh man the things we could do! Some nice =vlookup() formulas and get it auto pulling from a table where all you have to do is put in the finishing order of each race. Excel dork here. I live in excel for my job.

Nice! I am not such a excel jedi! Feel free to upgrade it, I appreciate it.

[stefa]

OK, see my attachment. All you have to do each race is go to the Race by Race Input tab and insert the drivers in their finishing order. It is imperative that the names are spelled correctly. I usually just hit "=" then click the name from a previous race that way it always is correct. When I am done then I copy and paste special as values.

Then after you have inputted the names you have to sort each standings schedule.

For the drivers table highlight C5 through Z26 then go to sort & filter -> custom sort. Sort column Z Largest to smallest.

For the constructors table highlight C32 through Z42 then go to sort & filter -> custom sort. Sort column Z Largest to smallest.

Let me know if you have any questions!

Attachment 5242

That is great! Thank you! Obviously it is better now!

[NickEice]

Haha no problem. I couldn't stay away from it. Lol. I like your formatting though with the flags and cars. Real slick.

[stefa]

Haha no problem. I couldn't stay away from it. Lol. I like your formatting though with the flags and cars. Real slick.

Thank you.
After your intervention it is better now.
If you thing of something else that could be upgraded, feel free to do.

[F1NAC]

This is something that I've made years ago, and now I am using it to fill points after each race, so I can have a better view on how the points were taken during season.
It is not super sophisticated thing, but it servers the purpose.
If any one of you fellow tifosi have some ideas and know how to make it better, feel free to contribute.
I hope you like it.
Enjoy and hopefully at the end one of Ferrari drivers, and Ferrari itself, will finish with the most points won!

hehe sheet name poeni , balkan ftw :D odlično ! :D

[stefa]

hehe sheet name poeni , balkan ftw :D odlično ! :D

As you can see from my signature, ALAN FORD was huge part of my comics book literature

[F1NAC]

As you can see from my signature, ALAN FORD was huge part of my comics book literature

nice job mate :D i didn't knew that i'll find here someone from Balkan area :D

[stefa]

nice job mate :D i didn't knew that i'll find here someone from Balkan area :D

I have seen couple of us, Balkans, here.

[stefa]

nice job mate :D i didn't knew that i'll find here someone from Balkan area :D

THANK YOU!