FIFA World Cup Wallchart for Excel

[parry]

In the rush to get it out I forgot to do that bit. Doesnt warrant a new release so have just amended last versions 1.06 & 1.06b. Download from http://www.parry.co.nz/downloads.html as usual.

regards,
Graham

 

[countryfan_nt]

Hello friends,

And thanks Parry!
You can also download the below excel sheet for the world cup.

http://www.excely.com/worldcup2006.zip

All the best,
Nawaf

 

[gearcutter]

Hi, Everyone,
I might as well throw my cap in the ring as well, If anyone wants another wallchart for the World cup send me a pm with your e-mail address and I will send you mine , maro free and a little bit different to the ones I have seen Cheers Howard.

 

[parry]

I uploaded a new version to my web site about a week ago but forgot to post here. The latest version 1.07 is available from http://www.parry.co.nz/downloads.html

regards,
Graham

 

[NBVC]

Graham,

The last version 1.07 now allows national anthems to be heard with Firefox being my browser....Cool



I noticed that after entering my scores to date (Austalia 3 - Japan 1)...congrats to the Aussies by the way the wallchart displays Brasil as the Runner up for group F even though they didn't play yet ...is that a prediction.

 

[njimack]

Graham,

How did you get the map on the Match Schedule sheet to reposition itself based on the visible screen?

Mighty impressive!

 

[SydneyGeek]

Hi NVBC,

One proud Aussie replying to your sorting comment. Aust -- Brazil -- Croatia -- Japan is because of the sorting routine. Teams on the same points are sorted by results betweeen each other, goals scored and goal difference. Japan has a negative GD and sorts to the bottom of the group, with Brazil and Croatia appearing in their same relative position from the original draw.

I think the group tables only make sense when all teams in a group have played the same number of matches.

Still, this workbook is great. I'm updating it every day -- haven't tried the anthems yet...

Denis

 

[parry]

Thanks Denis for answering that for me - spot on.

njimack, the map moving is done by looking at a certain row. If the activecell is greater than row x and the map is at the top I move it down or visa versa. This is done through a 3 step process.

First I group all the images so they are effectively one image now. This ensures that when I move the map then the images will still be in the right place because each city name is in fact a text label.

Next once Ive grouped into one object I position the map based on the Top and Left properties of the cell I want to align with. This moves the map either up or down.

Lastly I ungroup the images. This is so the cities can be clicked on etc because if I left as one image you couldnt interact with the map.

Hope that explains it.

regards,
Graham

 

[Smitty]

FYI - Kind of related (I thought it was a bit interesting anyway):

http://www.educationworld.com/a_tech/images/excelineducationticimage2.xls

Smitty