This program reads your ADIF logbook, and
extracts the W1AW/# QSOs into a spreadsheet format by state, mode and band. It
shows the date of the last QSO on a given band/mode, so that
you can tell if you need to work a station the second time around (this can be
changed using the -f option on the command line). Optionally, it will show which
band/mode slots have been confirmed via
Logbook of the World.
Version 2.6 of the program was released on 21 October 2014. Go to the
Version History to download the installation program.
[ Installation | ADIF Requirements |
Operation | Printing |
Other | Version History ]
After downloading the installation program, simply run it and install the program into a directory of your choosing.
The ADIF QSOs in your log must meet the following criteria:
- Callsign must be logged as W1AW/# (where # is 0-9), or /KG4, /KH0, /KH2,
/KH6, /KH8, /KL7, /KP2 or /KP4. All others are ignored
- STATE field in your logbook must be filled in, and exported to the ADIF file
(also checks COMMENT field for ADIF files from ADIFMaster)
- The program will automatically filter out QSOs that were not
made in 2014 (it will just take longer to run)
- The program will use the LOTW_QSL_RCVD=Y ADIF field (if available) to
indicate that a QSO is confirmed
The program does not know which W1AW station was active on any given date, so
it's up to your logbook to provide the correct information. The program does
not check that the state is valid, i.e. logging W1AW/7 but in
Vermont (should be W1AW/1). Again, the program only uses data from your logbook,
it does not interpret or extrapolate (or guess).
To run the program, just double-click on the program icon. You will see a window like the following:
First, click on the "ADIF File" button and navigate to the location of the
ADIF (input) file containing your W1AW QSOs. After the file is selected, click
on the "Open" button. Your ADIF file should end in ".ADI" or ".ADIF" so
the program can find it.
Selecting an ADIF file will automatically populate the CSV (output) file
name with the same name as the ADIF file, except with a .CSV extension. If
you want to change the output file name, click on the "CSV File" button,
and make any changes necessary. Then click on the "Save" button when you are
done. The program will warn you if you are about to over-write an existing file.
There are three radio buttons, only one of which can be selected at a time:
||output the date of the first QSO on a given
||output the date of the last QSO on a given
band/mode. This is the default.
||output "LOTW" in place of the QSO date when the QSO is confirmed by LoTW.
Otherwise, the date of the last QSO on a given
After you have made your selection, if necessary, click on the "Convert" button.
This will convert your ADIF file to CSV format. When the conversion is complete,
you should see a pop-up window like the following:
After dismissing the pop-up window by clicking on OK, the main window will look something like this:
In the example above, there are a couple of error messages about incorrect
state abbreviations. Then the program reports the number of states worked on each mode, as well
as on each band. You can use the scrollbar to view all of the output.
The function of the other buttons is as follows:
- opens the converted spreadsheet using your default
program in Windows. You can click on this link to see
an example of the output.
- presents this web page in your default web browser
- shows the program title, revision number and date, and copyright information
- exits the program
To print the spreadsheet, try the following tips:
- On the Home tab, select all column headings (A through N)
by swiping them from left to right using the mouse
- Click on Format and choose Auto Fit Colum Width
(you may want to manually narrow the empty column C)
- On the Page Layout tab, click on Print Titles
- Put a checkmark in the Gridlines box in the
- Click the mouse inside Rows to repeat at top and select row 1 ($1:$1)
- Click OK to exit the Page Setup window
- In the Scale to Fit section of the Page Layout tab,
click on the drop-down arrow to the right of Width and select 1 Page
- Select all column headings (A through N) by swiping them from left to right using the mouse
- From the menu, select Format | Column |
Optimal Width, then click OK. Column C (blank) may end up a little wide,
you can re-size it if you want.
- From the menu, select Format | Page to
open the Page Style window, then click on the Sheet tab
- Put a checkmark in the Grid box in the Print section
- Under Scale, Scaling mode, click on
the drop-down arrow and choose "Fit print range(s) to width/height"
- To the right of this, leave "Width in pages" equal to 1, and change
"Height in pages" to a large value like 10.
- Click on the Header tab. Uncheck "Header on"
- Click on the Footer tab. Uncheck "Footer on"
- Click OK to close the Page Style window.
- From the menu, select Format | Print Ranges | Edit
- Under "Rows to repeat", type "$1:$1" in the wide box to the right
(without the quotes). The narrower box to the left should change to "- user
defined -". Click OK
- From the file menu, select File | Print Preview, and
verify that the page looks like you want. When satisfied, click on the Printer icon.
Now you can print the spreadsheet.
None of these settings are saved unless you save the document in Microsoft Excel (XLS) format (or equivalent).
If there is an option that you would
prefer to be enabled by default when you start the program, you can do so by modifying the Windows
shortcut that starts the program. Right-click on the program icon and select
Properties. You should see a window like the following:
In the "Target:" box, add "-L" (no quotes, and with a space separating it
from the filename) to enable LoTW mode by default. Add "-F" to enable First mode
by default. Only add one or the other, not both. Then click on the "OK" button to save the changes.
- Print conversion date to spreadsheet (where?)
To download the installation program, click on the hyperlink containing
the version number and date.
- Ver. 2.6 - 21 October 2014
- Bug fix: W1AW/KH0 (and W1AW/KH8) were reported as "Not a valid callsign."
- Feature: Added "Update" button for updating the program with current version from the web
- Ver. 2.5 - 3 October 2014
- Bug fix: The number of states confirmed on each mode could be under-counted in certain circumstances
- Bug fix: Removed "DC is not likely for this call area" warning for W1AW/3
- Feature: ignore leading/trailing blank spaces when looking for state in N1MM "NAME" ADIF field
- Ver. 2.4 - 10 Jul;y 2014
- Bug fix: when reporting the number of states worked on
each band/mode, do not count territories (i.e. Puerto Rico, Guam)
or Washington D.C.
- Bug fix: obey First/Last QSO setting even if QSOs in ADIF file are not in chronological order
- Bug fix: when evaluating LOTW_QSL_RCVD field, 'V' (Verified) status is same as confirmed
- Bug fix: in summary report, fixed alignment of band column for long band names (160m) and short band names (6m, 2m)
- Feature: in summary, report number of states worked on MIXed (any) mode
- Ver. 2.3 - 22 June 2014
- Bug fix: an earlier QSO that was confirmed via LoTW could be replaced by
a newer QSO that is not confirmed. This can occur when you work a state
the second time around, but it had already been confirmed via LoTW the first time
around. Or you duped a state on the same band/mode, and the second QSO is
not confirmed via LoTW. Thanks to Pete, W1RM for noticing this.
- Bug fix: if the ADIF filename contained multiple
periods (i.e. kb3phl.20457.20140619063921.adi), the output filename would be
truncated at the first one, instead of the last one
- Handle ADIF QSO records up to 2048 characters long. Report error if ADIF record is too long, instead of crashing
- Adjust horizontal scroll bar width based on length of longest message
- Added horizontal scrolling for long filenames
- Ver. 2.2 - 4 June 2014
- Handle ADIF QSO records up to 1024 characters long (previously was 512 characters)
- Handle ADIF QSO field values that span multiple lines (like addresses)
- Show error messages from the ADIF parser in the output listing window
- Look for state abbreviation in ADIF NAME field (if not found in STATE field)
- Check that the state "makes sense" for the given W1AW/# call area
- Fixed bug counting the number of W1AW QSOs processed
- Fixed typo which prevented SSTV from being recognized as a PHONE mode
- Ver. 2.1 - 31 May 2014
- Replaced check boxes for first date / LoTW with mutually-exclusive radio buttons
- Selecting ADIF file name automatically populates CSV file name
- Exit button now exits the program immediately
- Added support for W1AW/3 in Washington D.C. during October 1-7
- Output window at the bottom has a horizontal scroll bar
- Look for state in COMMENT field only for certain logging programs (for now, just ADIFMaster)
- Ver. 2.0 - 30 May 2014
- Graphical Windows program
- Real Windows installation program
- Ver. 1.3 - 23 May 2014
- Added -l option to show QSOs that are confirmed via LoTW
- Added -f option to output date of first QSO on a given band/mode
- Added support for W1AW/KH0 and W1AW/KH8
- Changed format of date written to CSV file to enhance int'l compatibility
- Ver 1.2 - 23 May 2014
- Fixed bug where specifying output filename dumped output to console
- Ver. 1.1
- Ver. 1.0 - 22 May 2014
- States are sorted alphabetically by name instead of abbreviation
- Only print month, day to spreadsheet (not year)
- Printed date could be off-by-1 in some cases
- Summary statistics printed at end
- Added support for KG4, KH2, KP2 and KP4
- Get state abbreviation from COMMENT ADIF field in N1MM
- If output filename not specified, same as input file name but with CSV extension (suffix)
- Ver. 0.9 - 21 May 2014
- Initial Release