PDA

View Full Version : Formula 1 Sweepstake Game - HUNGARY - 01/08/10



TheGoodGuy
28th July 2010, 13:53
On the WEDNESDAY before each race I will post up an excel spreadsheet from which your randomly chosen driver(s) will be revealed.
There are 24 drivers competing in the 2010 F1 season, however, the spreadsheet contains 25 slots.
24 of the slots quite obviously contain the 24 drivers’ names. The other slot contains the SAFETY CAR.

Anyone is welcome to join the game at any time.
There is no limit to the number of players, only the number of F1 drivers !

Points will be awarded to players as follows:
At the end of each race, players holding the names of the points scoring driver(s), (the first ten finishers), will score the SAME amount of points that are awarded to their named driver(s)…..

1st = 25pts
2nd = 18pts
3rd = 15pts
4th = 12pts
5th = 10pts
6th = 8pts
7th = 6pts
8th = 4pts
9th = 2pts
10th = 1pt
The player holding the SAFETY CAR will have 20pts ADDED to their total if the SAFETY CAR IS deployed during the race.
However they will LOSE 20pts from their total if the SAFETY CAR is NOT deployed during the race.

WHAT YOU HAVE TO DO
Each day between Wednesday and Friday before each race, players may pick and post ONE number between 1 and 25 here on the game thread (first come first served).
Players may continue to pick/post ONE number each day (first come first served) until ALL the numbers have been allocated.
Players may NOT post retrospectively, ie if a player fails to pick/post a number on, say, Wednesday, they CANNOT pick/post two numbers on Thursday.
Only ONE number can be picked each day.

I will then PM (or Email) you 2 PASSWORDS.....the first (SHEET PASSWORD) will give you access to the Excel spreadsheet, and the second (NUMBER PASSWORD) will correspond to the number you have chosen.
Open the spreadsheet (attached below) and copy and paste the NUMBER PASSWORD into the appropriate cell and your driver's name will be revealed.

If you want to keep your selection(s) to yourself, that's fine.....but if you want to disclose/share/discuss your selection(s) with other players, please feel free to do so here on the game thread.

PLEASE NOTE: At the end of each race, if your driver(s) finish in the points you must reveal yourself as the 'owner' of the driver(s) concerned in order to get the points awarded added to your score.

If you fail to identify yourself as the 'owner' of a point scoring driver then the points will go 'unclaimed' and no points will be awarded.

However, if you have revealed the identity of your drivers before/during the race in thread posts/discussions, then there is no need to identify yourself again at the end of the race.....points will automatically be awarded as appropriate.

At the end of each race I will post an updated Results and Leaders Table.
The player who has amassed the most points at the end of the season will win an Amazon Voucher.


PLEASE EITHER CHECK OTHER PLAYERS' POSTS TO ENSURE THAT YOU ARE NOT GOING TO CHOOSE A NUMBER THAT HAS ALREADY BEEN PICKED BY SOMEONE ELSE......OR REFER TO THE LIST BELOW TO SEE WHICH NUMBERS ARE STILL AVAILABLE FOR SELECTION

Numbers Still Available For Selection - RACE 12 - HUNGARY:



Good luck to you all.

:thumbs

I have added a second spreadsheet "Hungary F1 2010B" below which is in the same format as the one that was used for last weekend's German Grand Prix for those players who cannot or don't want to have to "Enable Macros" each time they open the main sheet.
This secondary sheet has just the 1 password needed to open it.
The password will be posted here and in the game thread once ALL the driver numbers have been picked.

The password needed to open the 'Hungary F1 2010B' attachment below is: D9F156K4ah

mathare
28th July 2010, 14:18
I'll start at the top with number 1 again please Ada

vegyjones
28th July 2010, 14:44
I'll start at the botom (Why change the habit of a lifetime :biggrin: ). 25 please Ada.

scoobydoo
28th July 2010, 15:04
23 please Ada

johnwilly
28th July 2010, 15:51
3 please Ada

neilb7
28th July 2010, 16:15
7 Please

TooTall
28th July 2010, 17:34
17 please

John
28th July 2010, 18:23
Number 6 please Ada.

Just a quick one Ada – I won't have much internet access this weekend, so may not be able to quickly confirm/reveal my drivers once the spreadsheet password is made available. Please let me know if this is going to be an issue... Thanks.

TheGoodGuy
28th July 2010, 19:20
ANNOUNCEMENT

You will probably have noticed that when you open the spreadsheet you now get a "Disable Macros/Enable Macros" security warning window appear.
For the spreadsheet to 'work' properly you need to click on the "Enable Macros" button.
I can promise you that there is nothing sinister embedded in the code used in creating the spreadsheet, but if you are not happy with enabling Macros, please shout, and I will post up the simplified sheet ie the same format as used in the German race.

:thumbs

yerotsluap
28th July 2010, 20:22
2 please Ada

Iron Chris
28th July 2010, 20:33
4 Please Ada.

yerotsluap
28th July 2010, 21:00
2=Vitantonio Liuzzi

scoobydoo
28th July 2010, 23:26
23 is Buemi

mathare
28th July 2010, 23:43
1 was the other Toro Rosso - Alguersuari

TheGoodGuy
28th July 2010, 23:52
ANNOUNCEMENT

According to the BBC Sakon Yamamoto will replace Karun Chandok for the second race in a row as Hispania continue rotating drivers.
Yamamoto replaced Chandhok in Germany and will replace the Indian driver again in Sunday's Hungarian Grand Prix.

TheGoodGuy
29th July 2010, 00:01
WHAT YOU HAVE TO DO
Each day between Wednesday and Friday before each race, players may pick and post ONE number between 1 and 25 here on the game thread (first come first served).
Players may continue to pick/post ONE number each day (first come first served) until ALL the numbers have been allocated.
Players may NOT post retrospectively, ie if a player fails to pick/post a number on, say, Wednesday, they CANNOT pick/post two numbers on Thursday.
Only ONE number can be picked each day.
New players may join the game at any time.

OK guys.....

It's now Thursday and at the time of writing the numbers yet to be picked are:

5
8-16 inclusive
18-22 inclusive
24

So, ANYONE who wants to pick ONE number for Thursday from the list above.....please feel free.
This includes:
a) anyone picking a number for the first time
AND
b) anyone who picked a number yesterday (Wednesday) & wants to increase their chances of scoring some/more points with a second selection.

Make sure you confirm that numbers you would like to choose from the list above have NOT been picked in posts made after this one.........alternatively refer to the first post of this thread for a more up-to-date list.

:thumbs

vegyjones
29th July 2010, 00:02
ANNOUNCEMENT

You will probably have noticed that when you open the spreadsheet you now get a "Disable Macros/Enable Macros" security warning window appear.
For the spreadsheet to 'work' properly you need to click on the "Enable Macros" button.
I can promise you that there is nothing sinister embedded in the code used in creating the spreadsheet, but if you are not happy with enabling Macros, please shout, and I will post up the simplified sheet ie the same format as used in the German race.

:thumbs

Sorry for being a door knob Ada, but I'm on open office and even though I worked out how to enable macros (eventually :biggrin: ) it still doesn't seem to be working.

This probably isn't anything to do with the spreadsheet or open office, probably just my incompetence! :lame:

vegyjones
29th July 2010, 00:03
number 18 please

vegyjones
29th July 2010, 00:29
25 - Mark Webber :thumbs
18 - Chandok or now Yamamoto :ass2

scoobydoo
29th July 2010, 00:31
8 please Ada

TheGoodGuy
29th July 2010, 00:41
ANNOUNCEMENT

I have added a second spreadsheet "Hungary F1 2010B" to Post #1 which is in the same format as the one that was used for last weekend's German Grand Prix for those players who cannot or don't want to have to "Enable Macros" each time they open the main sheet.
This secondary sheet has just the 1 password needed to open it.
The password will be posted in the game thread and in Post #1 once ALL the driver numbers have been picked.

I will continue to PM players with their individual driver/number passwords for those of you who are OK using the main spreadsheet : "Hungary F1 2010"

:thumbs

John
29th July 2010, 00:54
Hi Ada,

Thanks for the explanations you sent me, I'm fine with whichever format is easiest and thank you also for letting me know about posting my drivers...

I'll plump for number 12 next please...

Thanks :smile:

John
29th July 2010, 01:04
Hi Ada,

I'm getting "Compiler Error in Module: Module 1" when I try to paste my password into the cell... not sure if it's because I'm using a Mac – could be? Is anybody else having difficulties?

No worries if it's a small glitch you're working on – I can look at this post-weekend.

Good luck to all for race day!

johnwilly
29th July 2010, 06:47
13 please Ada

yerotsluap
29th July 2010, 07:25
5 please Ada

Iron Chris
29th July 2010, 08:02
10 Please Ada.

mathare
29th July 2010, 09:16
24 for me please Ada

bigcumba
29th July 2010, 09:42
9 please Ada

scoobydoo
29th July 2010, 10:05
8 is Hulkenberg

johnwilly
29th July 2010, 11:57
3 is Glock
13 is Senna

bigcumba
29th July 2010, 13:00
Tony is without internet access for the next couple of weeks, so he asked me to choose numbers for him for now.. so can I have 19 on his behalf please Ada?

mathare
29th July 2010, 13:27
24 is Rubens 'Faster than The Stig' Barrichello

yerotsluap
29th July 2010, 16:33
5= Kobayashi

TooTall
29th July 2010, 18:27
11 please

neilb7
29th July 2010, 18:55
14 please Ada

John
29th July 2010, 20:29
6 is Lucas di Grassi
12 is Vitaly Petrov

scoobydoo
29th July 2010, 21:07
6 is Lucas di Grassi
12 is Vitaly Petrov

Good football surnames but not so good F1 names eh Johnny! :laugh I can't talk with my picks, think I have upset Hungary sometime in my life! :ermmm

John
29th July 2010, 21:30
Too right mate! Can't see myself doing brilliantly this week at all... Petrov might scrape a couple of points but Di Grassi won't have a chance. I think F1 is a bit more predictable than football, certainly in terms of who's really not going to turn up! :rolleyes:

TheGoodGuy
29th July 2010, 23:57
WHAT YOU HAVE TO DO
Each day between Wednesday and Friday before each race, players may pick and post ONE number between 1 and 25 here on the game thread (first come first served).
Players may continue to pick/post ONE number each day (first come first served) until ALL the numbers have been allocated.
Players may NOT post retrospectively, ie if a player fails to pick/post a number on, say, Wednesday, they CANNOT pick/post two numbers on Thursday.
Only ONE number can be picked each day.
New players may join the game at any time.

OK guys.....

It's now Friday and at the time of writing the numbers yet to be picked are:

15
16
20
21
22

So, ANYONE who wants to pick ONE number for Friday from the list above (first come first served).....please feel free.
This includes:
a) anyone picking a number for the first time
AND
b) anyone who picked a number on Wednesday and/or Thursday & wants to increase their chances of scoring some/more points with another selection.

:thumbs

scoobydoo
29th July 2010, 23:59
15 please Ada

vegyjones
30th July 2010, 00:00
21 please Ada

John
30th July 2010, 00:04
20 please Ada.

bigcumba
30th July 2010, 00:07
Can I have 16 for myself, and 22 for Lowe1 please Ada..

TheGoodGuy
30th July 2010, 00:18
OK....that's it....all the numbers have now been picked.

Sat 31 July: Qualifying 1300 BST

Sun 01 August: Race 1300 BST

The password needed to open the 'Hungary F1 2010B' attachment in post 1 is: D9F156K4ah

scoobydoo
30th July 2010, 00:21
15 is Schumacher along with Buemi and Hulkenberg.

John
30th July 2010, 00:21
Di Grassi, Petrov and Sutil (20)... oh dear!

TooTall
30th July 2010, 19:08
11 is Button
17 is Vettel

vegyjones
30th July 2010, 20:46
Kubica Chandok and Webber - could have been worse.

bigcumba
31st July 2010, 12:15
My own drivers are - 9 - Kovalainen and 16 - Rosberg

Lowe1 has 19 - Trulli and 22 - Massa.

TheGoodGuy
31st July 2010, 14:05
Hungary Grand Prix Provisional Starting Grid Positions
01/08/10 13:00

1. Sebastian Vettel
2. Mark Webber
3. Fernando Alonso
4. Felipe Massa
5. Lewis Hamilton
6. Nico Rosberg
7. Vitaly Petrov
8. Robert Kubica
9. Pedro de la Rosa
10. Nico Hulkenberg
11. Jenson Button
12. Rubens Barrichello
13. Adrian Sutil
14. Michael Schumacher
15. Sebastien Buemi
16. Vitantonio Liuzzi
17. Jaime Alguersuari
18. Kamui Kobayashi
19. Timo Glock
20. Heikki Kovalainen
21. Jarno Trulli
22. Lucas di Grassi
23. Bruno Senna
24. Sakon Yamamoto

scoobydoo
31st July 2010, 20:09
10th, 14th & 15th. :anerikke:

Iron Chris
31st July 2010, 20:11
Probably me, but I can't get the sheets to work properly to confirm my drivers...:confused:

mathare
31st July 2010, 20:56
Probably me, but I can't get the sheets to work properly to confirm my drivers...:confused:

4 is Alonso and 10 is Pedro de la Rosa - was that it for you Chris or did I miss one?

TheGoodGuy
1st August 2010, 00:30
Probably me, but I can't get the sheets to work properly to confirm my drivers...:confused:

The main sheet is the only one that is likely to cause anybody any problems due to OS and application conflicts......I had to try it just to find out how successful (NOT) it would be...

The second sheet "Hungary F1 2010B" is in exactly the same format as last weekend's German Grand Prix sheet....so if you could open that sheet, then there is no reason why you shouldn't be able to open this one with the password supplied.

If people continue to have difficulty opening the simplified sheet (Hungary F1 2010B), then the game will have to be terminated.

Many thanks Mat for informing Iron Chris of his picks :smile:

:thumbs

neilb7
1st August 2010, 11:53
7 = Lewis Hamilton :thumbs
14= Safety Car :yikes::censored::thumbsdown:

Iron Chris
1st August 2010, 12:18
Cheers Mat, I have been having problems with the laptop even though it is less than a year old. It has this morning been reset back to new and am starting all over again before it has to go away...:yikes:

yerotsluap
1st August 2010, 13:41
Crazy goings on so far with the crash in the pits then the wheel coming off Rosbergs car and bouncing down the pit lane

TheGoodGuy
1st August 2010, 15:07
Post 1 attachments updated with RACE 12 (Hungary) results & players' positions.

Next race: Belgium - 29/08/10.

I will post a new game thread and spreadsheet on WEDNESDAY 25th AUGUST.

scoobydoo
1st August 2010, 15:19
Thanks Ada. I see I am not on the podium still! :smile:

scoobydoo
1st August 2010, 15:47
From somebody who knows very little about F1, how out of order was Schumacher on that move late on with Barrichello?

mathare
1st August 2010, 16:36
From somebody who knows very little about F1, how out of order was Schumacher on that move late on with Barrichello?Very! It was a dangerous move by Schumacher. As Martin Brundle said in commentary at the time, if Schumacher decided he wanted to be close to the wall he should have taken that line earlier but to shove over as he did when Barrichello was alongside him was wrong. I think the rules state that if a driver wants to make a defensive move he has to do it in one continuous motion (which Schumi did) but by the time Schumacher made his move Barrichello was right upsides him and pretty much past but at the best part of 200mph almost forcing a driver into the wall is madness.

At his peak Schumacher was incredibly talented, had the best car as was streets ahead of everyone else. His team-mates were number two drivers and they knew it. That gave Schumacher the license to basically do what he wanted and he would think nothing of ramming a rival off the road if he had to. An incident with Damon Hill springs immediately to mind. It was win at all costs for Schumacher, basically.

F1 is different now and he can't employ the same tactics as he used to as he's not the best driver in the best car. He's not even close in terms of talent to the best drivers given the specs of these current F1 cars. It's probably incredibly frustrating for him, a seven-time world champion, to see better drivers than him and many better cars. He's not used to being second best (and he's not even that good on his showings so far this year) and his frustration is sometimes getting the better of him.

He was out of order and Barrichello called for him to be black flagged (disqualified) which may be a bit harsh but isn't that far off the mark. It was completely Schumacher's mistake and Barrichello was lucky to get by without hitting that wall but it must have been rather nervy for him.

scoobydoo
1st August 2010, 16:47
Thanks for that Mat.I was watching the on-line forum afterwards and I think it was Brundle who said it could've been like an air crash.:ooo I remember years ago when he took out Hill to win a championship didn't he although that was at a much slower speed? I really do wonder why he came back into the sport, he really had everything to lose, maybe it is like a boxer who can't give up the adulation I don't know? To be in a position like this where even the commentator makes a comment about maybe being penalised for how slow he is going must be an embarrassment to a 7 times world champion?