Free To Air World Cup Coverage

Artist 2004

Anatolia correspondent
Joined
Jan 17, 2004
Messages
252
Reaction score
0
Points
0
Age
71
My Satellite Setup
GoldMaster 7400 CIM 2MB with Kaon board 12.03.a5. Technomate 1000, Technomate 5200 USB.
Two 80cm offset dishes.
My Location
West coast, Turkey
Artist 2004 said:
Amongst the many match tables the attached is my favourite. You enter the scores on screen and it updates the points tables.

It's an Excel file and attractively designed with all the official logos and background pics.


With thanks to http://www.expatinturkey.com

Anyone using this will note that it has started entering the wrong team names in the quarter finals! Here's how to fix it:

In Tools / Options turn on row and column headings.
Note that columns J and K are hidden.
Unhide them: highlight columns either side and do Format / Column / Unhide
There are simple errors in cells J60 to J86

Click in J60, it contains a formula:
=IF(E60<>"",IF(E60>F60,D64,IF(F60>E60,G60,"Draw")),"Second Rd 1")
All the numeric parts in cell J60 should be 60
All the numeric parts in cell J61 should be 61
All the numeric parts in cell J62 should be 62
and so on.

So in J60 change D64 to D60
and so on.
 

BGonaSTICK

Retired Moderator
Joined
Dec 22, 2003
Messages
5,145
Reaction score
0
Points
36
Age
50
My Satellite Setup
Dreambox 7000, Skystar2
My Location
Brighton
Un-stickied for obvious reasons :)
 
Top