Euro 2004 Prediction Contest !

Rhye said:
OK, done.

Marla, can you tell me how did you create such a beautiful Excel sheet?
How did you hide the formules? How did you set a limit to the rows and columns?
Click to expand...
My guess would be illegal mind-enhancing drugs, kind of like Alice from Alice in Wonderland, except with more talking rabbits.
 
Rhye said:
Marla, can you tell me how did you create such a beautiful Excel sheet?
How did you hide the formules? How did you set a limit to the rows and columns?
Click to expand...
Well, actually, I'm not that good with Excel and I'm not sure I've done it in the most efficient way. I was so proud of my sheet I've shown it to my sister who use Excel all the day and she considered it as a usual sheet (:sad:).

To limit the number of columns and lines, I haven't found any other way than to select all the columns and lines I didn't want, right click, and ask to hide them :D. I know it's a bit "artisanal" but everyone isn't like my sister.

About the formules, they are actually on a hidden sheet. It's easy to make appear that sheet... You just need to right click on one of the spreadsheet thumbs and then pick "view code". Visual basic will open and you will see all the sheets of the file appearing on the top left. There's a sheet called "insider" there. If you want to view it, well, you just need to select it, click on "visible" in the properties window and pick... "visible". :)


Hitro said:
Hmm, when I try to open it with Office it tells me it would be password protected or something like that?
Click to expand...
Yeah, I've protected the sheet so where the places where we can write the scores are the only ones where we can write. If you really want to drop the protection, the password is "marla" in lower case though. :)
 
hmm... lol... :D

Well, actually Rhye, I couldn't open your sheet for the same reason Hitro couldn't open mine ! Excel tells me the sheet needs a password and there's an incompatibility between languages.

Rhye ? Could you release the protection from your files and post it again ?

To do so, open your file on Excel, go on tool, pick "release protection". Then, they will ask you for a password, type "marla" in lower case. Beware ! You have to release the protection 3 times !! (one for each sheet)



To Everyone​

I've changed the Excel sheet. Now it doesn't request passwords anymore to release the protection. Hitro, maybe you could try to download it again. Tell me if it still doesn't work then. :)
 
Ah, releasing the protection makes the formules appear.

I tried to hide the useless columns but as they're infinite, deleting some of them only causes a shift left...is there a way to select for example columns from AA to +inf?



I've uploaded the fixed version
 
Rhye said:
Ah, releasing the protection makes the formules appear.

I tried to hide the useless columns but as they're infinite, deleting some of them only causes a shift left...is there a way to select for example columns from AA to +inf?
Click to expand...
Well, here's how I do :
1- I select the first line that I want to disappear.
2- I hold shift.
3- I press on "End" and then on the arrow down.
4- I release shift.
5- Usually all lines are then selected. I right click on the selected zone and pick "hide".

For the columns, it's exactly the same except you press on the arrow right.
I've uploaded the fixed version
Click to expand...
:mad:
It still doesn't work! Stupid protection! Stupid me to have put it!

Well, you know what you will do which will be way easier. Simply copy the results of the first sheet (Facts sheet) and paste it on another document. Actually, I simply need the results to copy and paste on my document where I calculate the score. :)
 
Your sheet also still doesn't work for me.

Can I maybe just post my predictions here, meaning those first 24 games?
 
@Hitro :

Yeah that would be fine. :)
Give me the scores of the first 24 games (with the countries names so that I'm sure I don't mix up games), and afterwards, tell me who do you see in quarters, in semis, in final and as winner.
Feel free to post those informations here.


@Rhye :

Thank you. Your predictions are now taken into account. :)
 
Group A:

Portugal 3 - 1 Greece
Spain 2 - 0 Russia
Greece 2 - 2 Spain
Russia 1 - 3 Portugal
Russia 2 - 2 Greece
Spain 2 - 2 Portugal

Qualified: Portugal & Spain

Group B:

Switzerland 1 - 3 Croatia
France 2 - 1 England
England 2 - 0 Switzerland
Croatia 1 - 1 France
Croatia 2 - 1 England
Switzerland 1 - 3 France

Qualified: France & England (unless it has to fit with the game results, then it would be France & Croatia)

Group C:

Denmark 2 - 2 Italy
Sweden 2 - 1 Bulgaria
Bulgaria 1 - 2 Denmark
Italy 2 - 1 Sweden
Italy 2 - 0 Bulgaria
Denmark 2 - 3 Sweden

Qualified: Italy & Sweden

Group D:

Czech Republic 1 - 1 Latvia
Germany 1 - 4 The Netherlands
Latvia 2 - 2 Germany
The Netherlands 2 - 2 Czech Republic
The Netherlands 2 - 2 Lativa
Germany 2 - 1 Czech Republic

Qualified: The Netherlands & Czech Republic (or if it has to fit The Netherlands & Germany)
 
Precisely, I got the impression that this was possible. If that should be wrong Marla can take the obvious results, obviously.
 
I don't think it is possible although I'm not sure whether it actually matters as we make new predictions for the next round anyway so we could change the teams then.
 
I thought this game seperately awards point for the results and (additionally) for picking teams to reach the quarter finals.
 
You must log in or register to reply here.

Similar threads

Marla_Singer
World Cup 2006 Predictions Contest !
38 39 40
Replies
782
Views
41K
willemvanoranje
willemvanoranje
Back
Top Bottom