| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 68078 | 2006-04-16 10:43:00 | FIFA World Cup Wallchart for Excel | Parry (5696) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 446731 | 2006-04-16 10:43:00 | Hi all, I'm a keen football fan and have created a World Cup Wallchart in Excel. It's free and can be downloaded from here (www.parry.co.nz). I've just created it so let me know of any bugs by sending me a PM. I'd be keen to know what you think. Features: Each country has their flag displayed for the matches and the group tables. A map of Germany is displayed by the matches. When you select the row for the match the row will be highlighted and the city where the match is being played will be coloured red in the map. The Match Schedule sheet will automatically scroll if your selected row is matchday 33+ and the map will move down After the scores for a match have been entered the group tables will be updated and sorted by Points, Goal Difference then Goals For. After each group is complete (i.e. the 6 matches for the group have been played) the round of 16 team names will begin to appear in the match day list. If there is a tie after extra time in the knockout stages (match day 49 onwards) a box will appear asking you to enter the results of the penalty shootout. Installation: Download the World Cup zip file. Unzip the contents of the zip file to a folder. Note that the Excel file and the image files must be retained in the same folder. Open the Excel file and select the Enable Macros button. If the Enable Macros button doesn't appear select Tools|Macro Security and amend the security level to Medium then close Excel and re-open the file regards, Graham |
Parry (5696) | ||
| 446732 | 2006-04-17 23:46:00 | I havn't downloaded your Wallchart yet, but meanwhile I thought I'd at least acknowledge the time and effort you've put in and thank you for sharing it with F1 users. No one else has commented so far I guess most FI members must be rugby fans!!! |
bonzo29 (2348) | ||
| 446733 | 2006-04-18 00:51:00 | Downloaded yesterday and had a bit of a play. Looks pretty damn good! Any idea on what the TV schedule is for the World Cup or where to find it? |
CYaBro (73) | ||
| 446734 | 2006-04-18 01:15:00 | Oooohhhhh yes!!!! The world cup! Not long now, thanks for this mate. I'll download it now. 52 days to go! |
Buff_K (691) | ||
| 446735 | 2006-04-18 05:31:00 | Sounds amazing, but I tried to download it and it says 'not a valid archive' when I try and unzip it. Tried it at home and at work with no success. Can you email it directly or post it somewhere else? Who are you supporting? Whoops, just tried downloading again and it worked this time. Sorry... |
Wheels (7227) | ||
| 446736 | 2006-04-18 06:55:00 | I'll listen out for the results - nil all, nil all, nil all. It'll help get me to sleep. | wotz (335) | ||
| 446737 | 2006-04-18 11:06:00 | Sounds amazing, but I tried to download it and it says 'not a valid archive' when I try and unzip it. Tried it at home and at work with no success. Can you email it directly or post it somewhere else? Who are you supporting? Whoops, just tried downloading again and it worked this time. Sorry... Cool looks like you got it. My pick is Holland but in house squabbles seem to let them down at times but I think they will be on fire. Nobody seems to be picking the Germans except Germany ... they have a knack of coming right for big tournaments even though they have been pants in their lead up games. Will be interesting :-) |
Parry (5696) | ||
| 446738 | 2006-04-18 11:15:00 | Downloaded yesterday and had a bit of a play. Looks pretty damn good! Any idea on what the TV schedule is for the World Cup or where to find it? Dunno what the TV schedule is - I dont think Sky have released it yet but should be on their site. The kick off times can be found at fifaworldcup.yahoo.com We are 10 hours ahead so the first game @ 18:00 on 9/6 is 4AM on 10/6 for us which is a Saturday. I see theres a few kick off times at 21:00 which is 7AM so I might be late to work on those days or perhaps a few champagne breakfasts will be in order :-) I could build the kick off dates/times into my spreadsheet based on the local country of the PC but Im not sure its worth the effort. |
Parry (5696) | ||
| 446739 | 2006-04-20 18:22:00 | Hi all, theres a couple of bugs I will need to fix plus I will add a few extra features after feedback from people. Hope to do it this weekend so will post again when the new version is available for download. regards, Graham |
Parry (5696) | ||
| 446740 | 2006-05-01 09:36:00 | Hi peoples, Ive made quite a few changes to the World Cup spreadsheet which hopefully you will all like . The major change is that you dont need to keep a folder of all the images - everythings just in the workbook now . CYaBro you will be happy Ive included a TV schedule sheet with all the matches in date/time order plus you can choose your country so the local time amends automatically . Default is NZ of course :thumbs: Download while its hot from here ( . parry . co . nz/downloads . html" target="_blank">www . parry . co . nz) . This is version 1 . 01 . If I find any bugs or make enhancements I will post again . Let me know of any issues by sending me a PM . regards, Graham |
Parry (5696) | ||
| 1 2 3 4 | |||||