Notes on the MRD 2007 Excel log template The log for the Maritime radio day 2007 is in the form of an Excel spread sheet. There are two pages. The first gives general information on the radio-station. The second page is the operating log. This is where you will record daily on-the-air activity. The purpose of the log is not only to meet international IARU logging requirements but to provide informations on MRD 2007 operation. By keeping the logs in spread sheet format it will be much easier to extract information and patterns from our operations. Every country are receiving and collecting and keeping all of REPORT-FORMS coming from the country and after all will send all REPORT-FORMS to the MRD2007-INTERNATIONAL-LOG MANAGER Page 1 We have filled in typical entries for a radio station to provide informations. The left block starts with the station call sign which will be the base call with a /# for your particular station. The rest of the block is devoted to identifying the operator and contact information. The right block is just general information on the station. Some of this will change as the MRD2007 goes along but probably not greatly. In any case this is just a free form entry that gives the basic information on the station. Expand the description as you see fit. Page 2 Page 2 is the operating record for your station. There are three possible operating modes: 1) Two-way communication between two or more stations. 2) Transmit only, i.e. beacon mode. 3) Receive only. This is for stations that may not be currently transmitting but are listening for other stations. As shown below, the transmit and receive are coded with 0 or 1, so the three modes become 01, 10 or 11. The log attempts to accommodate all three modes on the same sheet. We could of course split these modes into three separate log pages if that proves useful. Most of the entries are obvious and need little explanation but others deserve some description. For example, most entries are simply data numbers, signal strength, time, date, etc. Others

1

however, are for data sorting purposes. For example, in the receive and transmit columns the entry will be a 0 or a 1.

Entries: 1) Date, dd/mm/yyyy 2) Start and end times in UTC. 3) Station heard or worked 4) Frequency in kHz 5) Transmit. a "1" entry means you are transmitting, a "0" no transmission. 6) receive, 0 or 1 7) mode, CW 8) Power to the antenna in W 9) ERP, effective radiated power = power to the antenna times the efficiency of the antenna 10) R, readability as in standard RST system 11) S, signal strength as in standard RST system 12) Received signal in uV/m 13) Rx noise, noise amplitude on the antenna in the absence of a signal. Usually you would simply tune away a few kHz from the received signal to a clear spot to make this measurement. 14) TX ant, transmitting antenna in use for this data line. Use a number correlated to the numbers in the description on page 1, right hand block. 15) RX ant, receiving antenna in use for this data line. Use a number correlated to the numbers in the right hand block on page 1. 16) WX, current weather. If we determine that weather has some effect we would like to track, we will need to create a weather code and enter the appropriate number in this column.

2