|
|
ADIF to CQ DX MarathonThe CQ DX Marathon is an annual recognition issued by CQ Magazine. It is the sum total of the number of different entities, plus the number of CQ zones, worked in a given year. This conversion program reads an ADIF log and writes a comma-delimited spreadsheet
that can be copied/pasted into the official CQ The current version of the conversion program is 2.1 and was last modified on 22 December 2008. Click on this link to download the program. To install the program, you need to run the SETUP.EXE program inside the .ZIP file. The installation program uses the Microsoft MSI format. This requires your system have the Microsoft installer components already on your machine. If you have installation problems, get the latest version of the Microsoft installer here. Installation will add a "ADIF to CQ DX Marathon" shortcut to your Start menu. The brief instructions are as follows (more detailed instructions can be found below):
In addition to callsign, date, time, band and/or frequency, and mode, the ADIF file must also contain these fields:
If the CQZ and/or DXCC fields are not present, the program will not be able to determine the CQ zone and/or DXCC entity for the DX station worked. Most contest logging software will not write these fields to the ADIF file. General-purpose logging software like DX4WIN, DXKeeper, Logger32, etc. usually generates the desired fields in the ADIF file. From the CQ DX Marathon website, "[The] list of separate countries (entities) for the CQ World Wide DX Contest and the CQ DX Marathon is based on a combination of the ARRL DXCC list, additional entities on the WAE (Worked All Europe) list and the Italian island of Pantelleria (IG9/IH9), in CQ Zone 33 off the coast of North Africa. This provides a total of 345 entities, based on 338 DXCC entities, six additional WAE entities (GM/Shetland, IT/Sicily, TA1/European Turkey, 4U1VIC, YU8 Kosovo, JW/Bear Is.) and African Italy." The conversion program attempts to determine the additional entities above based on callsign, prefix or IOTA reference number:
The above list is complete at the time this page was last updated. However, there could be legitimate calls of which the program is unaware. Make sure to check them when you finish up. Running the Conversion ProgramAfter installing the program, double-click on the "ADIF to CQ DX Marathon" program in the Start menu. Once the program window appears, click the ADIF button to specify the name of the input ADIF file. Click the Marathon button to specify the name of the output .CSV file. To change the year, just type it into the box provided (default is last year if before March 1, or this year if March 1 or later). Click OK to perform the conversion. Click on the Done button to exit the program. Any errors will be listed in the window. The Help button takes you to this web page. There is a link to the CQ DX Marathon website in the lower-left hand corner of the program window. You can click on the window icon and select "About..." to see the program version. Filling in the ScoresheetThere are two parts to filling in the Scoresheet:
First, open the .CSV file you just created, using a spreadsheet program like Excel. With your mouse, select the cell in the Day column next to 1A0/Sov. Military Order of Malta: Next, using the scroll bar, find the cell in the Callsign column next to ZS8/Pr. Edward & Marion Islands. Hold down the SHIFT key and click in this cell with the mouse. This should select all the country records in the spreadsheet: Type Control-C (or right-click and select Copy) to copy the cells into the Windows clipboard (do not close this window yet). Now open the CQ DX Marathon Scoresheet in your spreadsheet program. Make sure you have downloaded the latest version from this link, as they are continually making changes. Version 2.x of the conversion program is only compatible with 2008 DX Marathon Score sheet, V3 and later. NOTE that the screen shots below refer to the 2007 Score sheet, but the principles are still the same for 2008. In the Scoresheet, use your mouse to select the cell in the Day ("DY") column next to 1A0/Sov. Mil. Order of Malta: Now type Control-V (or right-click inside the cell and select Paste) to copy the country data into the Scoresheet. Now go back to the spreadsheet containing the output of the conversion program. With your mouse, select the cell in the Day column next to CQ Zone 1: Next, using the scroll bar, find the cell in the Callsign column next to CQ Zone 40. Hold down the SHIFT key and click in this cell with the mouse. This should select all the CQ Zone records in the spreadsheet: Type Control-C (or right-click and select Copy) to copy the cells into the Windows clipboard. Back in the Scoresheet, use your mouse to select the cell next to KL7/Zone 1: Now type Control-V (or right-click inside the cell and select Paste) to copy the CQ Zone data into the Scoresheet. Check that you lined up the data correctly. There will be blank lines for entities you did not work. Both the Entity and CQ Zone information will be filled into the Scoresheet if you've done this correctly. Finishing UpThere are seven entities on the CQ list that are NOT on the ARRL DXCC list:
The program will attempt to identify QSOs with these entities if the ADIF logbook contains enough information (callsign or IOTA). Otherwise, you will have to find the information in your logbook yourself and fill in those entities in the scoresheet by hand. If you do enter a QSO by hand, make sure that QSO wasn't already used as credit for another entity. For example, you can not count a Bear Island (JW) QSO as credit for both Svalbard and Bear Island, so you may need to find another Svalbard QSO in your log to receive credit for that entity. Fill in the rest of the fields in the form, and send it in! |
