Generating a CQ DX Marathon Submission

If you have Microsoft Excel installed on your computer, DXKeeper can directly generate a Marathon Score Sheet that you can submit to CQ. If you don't have Excel installed, DXKeeper can generate a CQ DX Marathon Submission file in CSV (comma-separated values) format in a way that allows its data to be copy-and-pasted into the CQ DX Marathon Official Score Sheet. Step-by-step instructions for both scenarios are provided here.

Using Microsoft Excel

  1. In the Marathon Bands & Modes panel on the Configuration window's Awards tab,

    1. confirm that the band, mode, Include QSOs with no propagation mode, and Max TX power options are configured as desired

    2. click the Year, Category, Score Sheet Info button to display the Marathon Year, Category, and Score Sheet Information window

  2. In the Marathon Year, Category, and Score Sheet Information window,

    1. set the Current year to the year for which you wish the Marathon submission to be generated

    2. select the Category for which you wish the Marathon submission to be generated: Mixed, a particular single-band, or a particular single-mode; QSOs whose band and mode are not consistent with the selected Category will not be considered for includsion in the generated submission

    3. click the Select button, and use the Select empty Excel Score Sheet window to select the appropriate Marathon Score Sheet (available here); for CQ DX Marathon 2016, the correct Score Sheet version is 2016.1}

    4. specify the Callsign, Name, Street address, City, State/Province, Country, Postal Code, CQ Zone, Email Address, Club Name, and Comments that should be included in your Score Sheet.

    5. the Class specified in your Score Sheet (Unlimited, Formula <= 100 watts, or Formula <= 10 watts) is determined by the Max TX power option in the Marathon Bands & Modes panel; if you've specified a Max TX power of 100 or less, specify your antenna type, height above ground, and length in the Antenna Description

  3. In the CQ DX Marathon panel on the Check Progress tab of DXKeeper's Main window, click the Submission button; DXKeeper will generate a completed Score Sheet in Excel format (.xls), place this Score Sheet in DXKeeper's Reports folder, and direct Excel to display it.

  4. Carefully review the generated Score Sheet before you submit it.

Note that the above procedure

Using Open Office

  1. Open the CSV submission file using OpenOffice Calc (if not opened automatically).

    1. In the Text Import window that appears:

      1. Under Separator options, select Separated by and check (only) Comma. Uncheck all others.

      2. Click OK

    2. Click on cell C1 (Day column, first row)

    3. Scroll down to the last populated row (Zone 40), and shift-click in the H (callsign) column of that row. You should now have selected all of the data, but excluding the prefix and entity name columns.

    4. From the Edit menu, select Copy

  2. Download the latest OpenOffice format score sheet for the appropriate year from http://www.dxmarathon.com/ and open it using OpenOffice Calc

    1. Click in the cell for the Day column of the first entity in the table (in the 2015 score sheet, this is cell D17)

    2. From the Edit menu, select Paste Special...

    3. In the Paste Special window:

      1. Under Selection, check (only) Text and Numbers. Uncheck all others.

      2. Under Options, uncheck all boxes

      3. Under Operations, select None

      4. Under Shift cells, select Don't shift

      5. Click OK

  3. The YOUR SCORE section at the top should now be correctly populated.

  4. Fill in the other yellow areas of the form as appropriate (including SUBMISSION INFORMATION at the top, and the area for comments at the bottom)

  5. From the File menu, select Save As...

    1. Navigate to an appropriate location to save the file (e.g. Desktop)

    2. Under File name, type the callsign being used in the submission

    3. Save as type should be ODF Spreadsheet (.ods)

    4. Check Automatic file name extension

    5. Click Save

You should now find the <callsign>.ods file at the location you selected. Submit as instructed at http://www.dxmarathon.com/

Using a Spreadsheet Application Other than Microsoft Excel or Open Office

  1. In the Marathon Bands & Modes panel on the Configuration window's Awards tab,

    1. confirm that the band, mode, Include QSOs with no propagation mode, and Max TX power options are configured as desired

    2. click the Year, Category, Score Sheet Info button to display the Marathon Year, Category, and Score Sheet Information window

  2. In the Marathon Year, Category, and Score Sheet Information window,

    1. set the Current year to the year for which you wish a Marathon submission to be generated

    2. select the Category for which you wish the Marathon submission to be generated: Mixed, a particular single-band, or a particular single-mode; QSOs whose band and mode are not consistent with the selected Category will not be considered for includsion in the generated submission

  3. In the CQ DX Marathon panel on the Check Progress tab of DXKeeper's Main window, click the Submission button; DXKeeper will generate a Marathon Submission file in comma-delimited format (.csv) in DXKeeper's Reports sub-folder

  4. Direct your spreadsheet application to open the CQ DX Marathon Official Score Sheet, which is available here; in this spreadsheet,

    1. Specify your Callsign, Name, and Street in cells B5, C5, and D5 respectively
    2. Specify your City, State/Province, Country, and Postal Code in cells B7, C7, D7, and G7 respectively
    3. Specify your CQ Zone, Email Address, and Club Name in cells B9, C9, and C9 respectively
    4. Place an X in cell G10, G11, or G12 to specify the class in which you're competing
    5. If you're competing in a Formula Class, specify your antenna type, height above ground, and length in cell B14
  5. Direct your spreadsheet application to open the Marathon Submission file in comman-delimited format (.csv) that DXKeeper generated in step 3 above
  6. Direct your spreadsheet application to
    1. copy the region C1:H387 from the generated Marathon Submission file to the Windows clipboard
    2. paste the values in the Windows clipboard into the region D17:I403 of the CQ DX Marathon Official Score Sheet
  7. verify that the correct score appears in cells I4 through I6 of the CQ DX Marathon Official Score Sheet
  8. Save the now-populated CQ DX Marathon Official Score Sheet
  9. Carefully review the Score Sheet before you submit it.


Award Tracking

QSLing

Logging

Getting Started with DXLab

GenerateMarathonSubmission (last edited 2017-01-09 23:53:00 by AA6YQ)