Predict the F1 2011 season! And the winner is...

Jonny · PostPosted: Fri Feb 24, 2012 5:28 pm

I thought I would at least be in the top ten to live up to my god complex status.

Gabriel · PostPosted: Fri Feb 24, 2012 5:35 pm

so close!

pimmy · PostPosted: Fri Feb 24, 2012 8:26 pm

From 1st... all the way down to 40th :lol:

.

aerogi · PostPosted: Mon Feb 27, 2012 8:09 am

phil1993 wrote:

Is there not a way you can have some sort of automatic programme for this? It looks so complex to work out.

I have it all covered in an excel sheet, it is pretty much all automatically updated.

Excel is my virtual world...

aerogi · PostPosted: Mon Feb 27, 2012 8:11 am

Bleu wrote:

Below mid-point...

Anyway, one rule change proposal.

For the questions regarding wins, poles and FLs, some minus points awarded if driver you picked anything. The current rule encourages too much to put lot of drivers there. Alternatively something like 10 points for having correct amount of drivers.

So if you pick like
Vettel 6
Hamilton 4
Button 3
Alonso 2
Massa 1
Webber 1
Rosberg 1
Schumacher 1
di Resta 1

It goes:
Vettel 8
Button 3
Webber 3
Hamilton 2
Alonso 2
Rosberg 1
Hülkenberg 1

5 for Vettel, 10 for Button, 5 for Webber, 5 for Hamilton, 10 for Alonso, 10 for Rosberg, 0 for Hülkenberg makes 45. However, there's Massa, Schumacher and di Resta on the predictions who fail to achieve anything.

I have been thinking about that one, but first I have to find out how I can include that in my excel sheet so it is calculated all automatically. I'll come back to that.

Artur Craft · PostPosted: Mon Feb 27, 2012 3:47 pm

Shit! Almost last :yuk:

This prediction games are all crap.
[/bad loser]

As a curiosity, Clayman, a previous winner, was last one this time.

ryan86 · PostPosted: Tue Feb 28, 2012 1:33 pm

Didn't expect to do that well!

And Kart, Scotland for the teams championship I think!

Omega · PostPosted: Tue Feb 28, 2012 6:03 pm

I always suck in predicting races

Bleu · PostPosted: Sat Mar 03, 2012 3:03 pm

aerogi wrote:

I have been thinking about that one, but first I have to find out how I can include that in my excel sheet so it is calculated all automatically. I'll come back to that.

=IF(C2>0;5;0)+IF(C2=B2;5;0)+IF(C2=0;-5;0)

A2 = Driver name (not included in that function)
B2 = number of wins picked
C2 = actual number of wins
D2 = the field where you have that function above

If B2 and C2 are both 0, 2nd will give 5 points and 3rd will give -5 points so that equals it back to 0.

kart99 · PostPosted: Sun Mar 04, 2012 1:25 am

ryan86 wrote:

And Kart, Scotland for the teams championship I think!

I agree. Whoop!

Must say I was really pleased to finish joint 2nd. Looking forward to this years picks.

aerogi · PostPosted: Tue Mar 06, 2012 1:17 pm

Bleu wrote:

aerogi wrote:

I have been thinking about that one, but first I have to find out how I can include that in my excel sheet so it is calculated all automatically. I'll come back to that.

=IF(C2>0;5;0)+IF(C2=B2;5;0)+IF(C2=0;-5;0)

A2 = Driver name (not included in that function)
B2 = number of wins picked
C2 = actual number of wins
D2 = the field where you have that function above

If B2 and C2 are both 0, 2nd will give 5 points and 3rd will give -5 points so that equals it back to 0.

Thanks for the hint, I'll try that and let you know if it works.

aerogi · PostPosted: Tue Mar 06, 2012 3:09 pm

aerogi wrote:

Bleu wrote:

aerogi wrote:

I have been thinking about that one, but first I have to find out how I can include that in my excel sheet so it is calculated all automatically. I'll come back to that.

=IF(C2>0;5;0)+IF(C2=B2;5;0)+IF(C2=0;-5;0)

A2 = Driver name (not included in that function)
B2 = number of wins picked
C2 = actual number of wins
D2 = the field where you have that function above

If B2 and C2 are both 0, 2nd will give 5 points and 3rd will give -5 points so that equals it back to 0.

Thanks for the hint, I'll try that and let you know if it works.

it almost worked, but when a driver has 3 wins, but a member picked 0 wins, he gets 5 points... I have to find a sollution for that.

aerogi · PostPosted: Tue Mar 06, 2012 4:33 pm

I have found a (simple) sollution, I simply added the following:

=IF(B2=0;0;IF(C2>0;5;0)+IF(C2=B2;5;0)+IF(C2=0;-5;0))

So as soon you have picked nothing, it will turn 0 as a result!

So for next year, when you pic a win for Schumacher for example, but he does not manage to do so, you will get -5

I will include that for the questions for number of wins, poles and fastest laps.

I will also 'double' the reward for the top 5 of the constructor's trophy, because we all know that McLaren, Red Bull and Ferrari will make it to the top 5... but if you get them on the correct spot, you will get 20 points instead.

TBK-Light.com

Predict the F1 2011 season! And the winner is...

Who is online