Euro 2008 Excel Sheet ... Don't Miss it

[mohammediab]

np man you are welcome

[soccerfan99]

Hii

great job on this file mate
just one question am having hard time knowing how to use the prediction sheet, i wish you were litle more specific with examples on it, i know you have some note on it but i cant figure it out

your help would be great.
thanx

soccerfan99

[mohammediab]

Originally Posted by soccerfan99

Hii

great job on this file mate
just one question am having hard time knowing how to use the prediction sheet, i wish you were litle more specific with examples on it, i know you have some note on it but i cant figure it out

your help would be great.
thanx

soccerfan99

look man ... above you'll enter yr point system .... 100 point of exact result ... 10 for difference, 20 for PK .. and so on ... and predict your results down ... and the rakning of group at middle ....

when you enter the true result in the main sheet .. automatic will calculate your points in the other sheet .... that's all

[tojesigura]

Hello mohammediab,

great sheet, the scoring system is great.

There is one error on it though, it does not calculate points for a correctly predicted team win.
Enter value of exact match case 5

this part is not working, can you fix it?

[tojesigura]

No help??

[mohammediab]

Originally Posted by tojesigura

No help??

sorry man but i was in beirut and there was some troubles ...

I didn't get what the error is exactly ... is it in score for team predict or at excat case ??

[tojesigura]

Hi,

there are always troubles there, sorry.
I see you are ok, that's most important.

The error is on the Prediction sheet.
"Enter value of exact match case", this part considers home win, away win or draw? I suppose i got that right?

It that's so than the sheet does not calculate these points correctly.

I.E. I put 5 points as value for exact match case, and all the other cases 0, just for testing purpose and put the result for first game (switzerland - czech) 0:0, and prediction also 0:0 and score remains 0, but it should be 5.

[Tomas]

Great Work Man!