Euro 2008 Prediction Competition

[snoopy369]

Originally posted by Locutus


I deliberately avoided that because I considered it ugly -- if it wasn't for that little oversight this is a far more elegant solution IMO. Now I have to revise that of course.

If I'd start from scratch (not gonna fix it now) I guess I could still maintain it by having separate hidden columns that store the number of digits of the result and that default to 1, but the elegance is rapidly fading there...

Or just do

=IF(NOT(ISBLANK(F2)),
IF(LEFT(F2,SEARCH("-",F2)-1) < MID(F2,SEARCH("-",F2)+1,LEN(F2)-SEARCH("-",F2)),"loss",
IF(LEFT(F2,SEARCH("-",F2)-1) > MID(F2,SEARCH("-",F2)+1,LEN(F2)-SEARCH("-",F2)),"win","tie")),"")

(broken up to not break the thread)
Works fine with the current sheet as-is.

[Victor Galis]

Originally posted by Locutus
It will change for one of us, that much is certain

Or not If only I had mixed nationalism with realism, I'd be doing really well now lol.

[Solver]

What's wrong with me, I keep getting the outcomes right but predict too many goals at it!

[Victor Galis]

Well, I'm feeling sorry for anyone who predicted Italy will win group C right about now.

[Solver]

They'll qualify anyway. France sucks, I expect them to go out with 2 points at most...

[germanos]

Group C, round 2:

Italy - Rumania 1-0
Holland - France 3-1

[Solver]

Group D for tomorrow:

Spain - Russia 4-1
Greece - Sweden 0-2

[Cort Haus]

Czech Republic vs Portugal 1-2
Switzerland vs Turkey 0-1
Croatia vs Germany 0-2
Austria vs Poland 0-1
Italy vs Romania 1-0
Netherlands vs France 2-0

[Hueij]

What's up with all these wins of Holland over France all of a sudden? We won one game and France played one bad game. Big deal...

[germanos]

azijnpisser

[Cort Haus]

Originally posted by Hueij
What's up with all these wins of Holland over France all of a sudden? We won one game and France played one bad game. Big deal...

Possibly because Holland played the best football of the tournament so far and France were feckin dreadful.

Also Domenech's a prize tosser who picks his team based on their star signs.

[Hueij]

Originally posted by germanos
azijnpisser

C'est moi

Seriously, for the first time since '88 ('74? ) we all don't think we are going to get anyway far in a major tournament. Een zwaluw maakt nog geen zomer, of zoiets...

[Serb]

Russia- Spain 0:2 after the first half.
So, I want to change my previous prediction to *:2 for Russia win.
Does anyone believe it is still possible? I guess not.

Rossiya - vpered, eb tvoyu mat'!

[LordShiva]

Teh score should stay like this to make up for my bad predictions yesterday

[Victor Galis]

I suspect most people's predictions were bad yesterday .