The excel sheet 'WRTC scores hour by hour' contains three separate pages:
Page Callsigns contains general information of the teams.
Page Hourly scores contains the results by hour.
Page Graphs contains the results in two different charts.
The file 'all sms messages' contains all of the messages that were sent before and during the contest.
The data is in field separated by semicolons ';'
The first field contains the phone number of the referee. To transfer this into callsign, use the table on page 'Callsigns' of the hourly excel.
The second field contains the message center phone number, not needed.
The third field contains the date and time in Finnish time (=UTC+3).
The fourth field contain the message itself 'WRTC SCORE xxxx', of which xxxx is the score.
WRTC - World Radiosport Team Championship in Finland - July 9-16, 2002
© WRTC2002 Org. design: OH1NOA