The official CFC Euro 2004 warm-up thread!

[Inter4]

@Portuguese:

Pot 1: Portugal, France, Sweden Czech Republic
Pot 2: Italy, Spain, England, Germany
Pot 3: Netherlands, Croatia, Russia, Denmark
Pot 4: Bulgaria, Switzerland, Greece, Latvia

 

[Portuguese]

English? Right! (Oops...)

Try this one:
http://www.civfanatics.net/uploads6/UEFA-EURO-2004-Eng.zip
Sorry if there are spell errors. I have done this in a hurry...

 

[Portuguese]

Thx Inter32
I've very very very appreciated that tip!!!
Now I can start doing the last worksheet

@all: Waiting for comments...
(please note this last change have not yet be made. I'll upload a later version with that and all the english errors that were pointed out later, to avoid having so many files here as I have in my hard drive )

 

[Dell19]

Some of the probabilities seem to act little strange as 3-3 results occured several times but no one scored over 3 goals unless it was penalties. Actually I may be wron here as I am no longer sure waht a red background means.

 

[Portuguese]

3-3 is uncommon but happens.

4 goals is more common than a 3 in both countries (a 3-3)...
It is possible till 7, although it almost never happens...

If you understood the working of it, you can just pull up the maximum Poisson (or low the minimum...), reflect that change in the formulas and put different coefitients...

But I think it is fair this way...

Have you noticed "Cup Surprise". It is a quite cool way of saying that teams has a chance, although it is a minimal one...

 

[raen]

Originally posted by Portuguese
BTW, what do you think of this:

http://www.civfanatics.net/uploads6/UEFA_EURO-2004.zip

PS1: Click F9 on your keyboard to see what it does...

PS2: Last worksheet is still being completed. If you want the complete one, just tell me and I'll post it soon...
But what matters appears in the 2nd and 3rd ones...

It´s cool, but I hate and dont understand probabilities

 

[Portuguese]

Results

Country Champ Vice Final Final Win
França 505 351 856 42,7% 59,0%
Itália 302 275 577 28,8% 52,3%
Portugal 259 262 521 26,0% 49,7%
Espanha 225 229 454 22,7% 49,6%
Inglaterra 198 236 434 21,7% 45,6%
Holanda 191 165 356 17,8% 53,7%
Checa 155 214 369 18,4% 42,0%
Alem. 100 132 232 11,6% 43,1%
Suécia 47 76 123 6,1% 38,2%
Dinam. 9 34 43 2,1% 20,9%
Grécia 1 6 7 0,3% 14,3%
Croácia 1 2 3 0,1% 33,3%
Suiça 0 7 7 0,3% -
Bulgária 4 8 12 0,6% 33,3%
Rússia 6 4 10 0,5% 60,0%
Letónia 1 3 4 0,2% 25,0%

Results after 2004 observations.
(of being Champ, Vice, be at Final, % of be at Final, % of winning final after being there)

So, what do they seem?

EDIT: here it seems right. Why does it crop TABs when posting?

Country...Champ......Vice.........Final....Final........Win
França......505.........351..........856.....42,7%.....59,0%
Itália........302..........275..........577.....28,8%.....52,3%
Portugal...259..........262..........521.....26,0%.....49,7%
Espanha...225..........229..........454....22,7%......49,6%
Inglaterra .198.........236..........434.....21,7%......45,6%
Holanda....191.........165..........356.....17,8%......53,7%
Checa.......155..........214.........369.....18,4%.......42,0%
Alem.........100..........132..........232.....11,6%......43,1%
Suécia.......47...........76............123......6,1%.......38,2%
Dinam.......9..............34............43.......2,1%........20,9%
Grécia.......1..............6..............7.........0,3%........14,3%
Croácia.....1..............2..............3.........0,1%........33,3%
Suiça.........0.............7..............7..........0,3%............-
Bulgária....4..............8.............12........0,6%........33,3%
Rússia.......6.............4.............10........0,5%........60,0%
Letónia......1.............3.............4..........0,2%........25,0%

Better now...

 

[willemvanoranje]

Originally posted by Dell19
no one scored over 3 goals unless it was penalties. Actually I may be wron here as I am no longer sure waht a red background means.

in real life?

Euro '96 ---> England - Holland 4-1
Euro 2000 ---> Holland - Yugoslavia 6-1

btw, I get only half the numbers on the statistical results page :s

 

[Portuguese]

Well, in Portuguese is ready...

Here it is:
http://www.civfanatics.net/uploads6/UEFA_EURO-2004_Oficial.zip

With 2004 observations and the results post above. Full operating now!
(I hope )

EDIT: William what is the problem?
Is the countries names that you don't get it?

 

[Dell19]

Originally posted by willemvanoranje


in real life?

Euro '96 ---> England - Holland 4-1
Euro 2000 ---> Holland - Yugoslavia 6-1

btw, I get only half the numbers on the statistical results page :s

I meant on the spreadsheet, and I'm still not sure what a red background means...

 

[willemvanoranje]

Originally posted by Portuguese
EDIT: William what is the problem?
Is the countries names that you don't get it?

in the new version all the numbers do work where at first they didn't, so that's solved now.

However, I still don't see how it works....unless this is not a spreadsheet for this euro '04 but a spreadsheet for euro '04 before the groups were drawn....and then I wonder why someone would want to make that.

I'm glad we're gonna win 2-0 against Spain in the final though.

 

[willemvanoranje]

thought you might like this

 

[Inter4]

The dutch and their dreams...

 

[MCdread]

Originally posted by willemvanoranje

However, I still don't see how it works....unless this is not a spreadsheet for this euro '04 but a spreadsheet for euro '04 before the groups were drawn....and then I wonder why someone would want to make that.

That's cause he made this before the draw a few months ago. There was a thread about it in the Sports Forum.

 

[willemvanoranje]

ah ok, silly me....

 

[Portuguese]

Originally posted by Inter32
The dutch and their dreams...

Yeah

PS: This was made a few months ago and the intention is to achieve a 19 in a subject in the University (Operational Research).

 

[willemvanoranje]

well, what did it get you?

 

[Stapel]

What is this all about?
In case you didn't know: Germany has a 62.5% chance to reach the final and a 37.5% chance to win the championship.

Have a good day !

 

[MCdread]

Ok, time to revive the thread as the first warm-up friendlies of 2004 will be played this week. So, what do you expect at this point of the season?

I just hope we finally don't play like crap tomorrow againts England.

 

[Stapel]

I just opened up another thread, dedicated to the inevitable humiliation of the USA tomorrow...