From the ARRL Website:

Throughout 2016, Amateur Radio will be helping the National Park Service celebrate their 100th anniversary. Hams from across the country will activate NPS units, promote the National Park Service and showcase Amateur Radio to the public.

DX4WIN users can track the NPOTA stations they have worked using the “ARRL National Parks on the Air” custom award. This allows you to print lists of stations worked or needed. You will need the most recent DX4WIN Custom Awards database to track this award. You can read more about custom awards in the DX4WIN Help file.

The "NPOTA" program shown here re-formats the DX4WIN ARRL NPOTA Custom Award listing into a one-page spreadsheet that you can print out and keep next to your radio for reference. Click on this link to view a sample of the output in PDF format. Experience has shown that it takes a non-trivial amount of work in DX4WIN using F8 (search) to determine whether you have worked a given National Park unit already. This program creates a one-page spreadsheet that makes it much easier to see the information quickly.

Version 2.0 of the NPOTA program was released on 9 March 2016. If you are a new user, go to the Version History to download the installation program.

Single-page NPOTA Listing for DX4WIN

Disclaimer

The DX4WIN Data Updater is supplied "AS IS" without any warranties. Support is through the DX4WIN Reflector.

The author assumes no responsibility or liability for the use of the software, conveys no license or title under any patent, copyright, or mask work right to the product.

The author reserves the right to make changes to the software without notification. The author also make no representation or warranty that such application will be suitable for the specified use without further testing or modification.


Installation and Updates

Once the program is installed, it's easy to update from within the program itself. You will not have to install it again. You'll find more information below.

IMPORTANT: If you try to run the program and you see either of these two error messages pop up:

MSVCP140.dll is missing

or

VCRUNTIME140.dll is missing

then you must install the Microsoft Visual C++ Redistributable for Visual Studio 2015. When prompted, download and install vc_redist.x86.exe (not vc_redist.x64.exe).


Configure Custom Award Confirmations

Without confirmation information, the one-page spreadsheet would only highlight NPOTA "units" that you have worked. Having confirmation information also makes the output much more useful.

The ARRL tracks your NPOTA credits worked though Logbook of the World (LoTW). It matches your uploaded QSOs with the QSOs of NPOTA activators who have also uploaded their logs. You should periodically download your LoTW report and import it into DX4WIN using LoTW | Import from LoTW in the QSO window. More information on using ARRL LoTW with DX4WIN can be found in this application note.

You must first configure Custom Awards so that they recognize LoTW confirmations. This only has to be done once. To do this, click on File | Awards from the main DX4WIN window (not the QSO window). This will bring up the Award Setup window.

Award setup for Custom

Using the right-arrow near the top-right of the window, click it enough times until you see the Custom tab appear, then click on this tab. Make sure there is a check box next to "LoTW" in the Confirmation section as shown above, then click on OK.

NOTE: Changing this setting will affect all custom awards!


Create the DX4WIN Award Listing

The program requires a copy of your DX4WIN Custom Award listing for the ARRL NPOTA award. From the QSO window, click on Reports in the menu to bring up the Report generator window. Then click on the drop-down arrow in the Award box that says DXCC, and using the mouse, click on Custom:

Report generator

As soon as you click on the word Custom, the Get award window will pop-up on top of the Report generator window. Click on the drop-down arrow in the Custom award box, and scroll down until ARRL National Parks on the Air is highlighted. Then click on it with your mouse to select it.

HINT: You can also select the award by typing the 'A' key several times, until "ARRL National Parks on the Air" appears as the only entry in the Get award window.

Get award
Get award

After you have selected ARRL NPOTA, click on OK to close the Get award window, and the Report generator window should now look like this:

Report Generator

Make sure that only the Mixed box is checked in the Award section, and that Modes is set to "All modes" and Bands set to "All bands". These should be the defaults.

Finally, click on the OK button in the Report generator to bring up the ARRL NPOTA Listing window:

ARRL National Parks on the Air Listing

Now right-click on this window and choose "Write to File". Give it a name like NPOTA. Do not change the "Save as type:" field. It can be in whichever directory you choose, but it's easiest if you save the file in the same directory into which you installed the NPOTA program. After you have written the file, you can close the ARRL NPOTA Listing window. The Report generator window will close automatically.


Using the Program

After starting the program from the desktop icon, click on the Input button and navigate to the location of the ARRL NPOTA Listing you saved earlier. By default, the output file will be created in the same directory as the input file, but with "-sheet" appended to the filename. If you want to change the output file name, you can click on the Output button. You may also edit either file name by typing directly into the text box next to the Input and/or Output buttons.

IMPORTANT: The input and output file names must be different. The program will warn you if they are not.

There are two output formats. Select the one you prefer. Only one can be selected at a time:

Now click on the Covert button and the program will report on how many NPOTA "units" were in the listing, as well as the number of NPOTA units confirmed and worked. In this report, worked units are those that are not also confirmed.

Even though the output is in color, it should still print out OK on a black-and-white printer, using gray scale instead of color.

After running the conversion, click on the Open button to view the spreadsheet you created. It will open with your computer's default spreadsheet program.

NOTE: At this point, you can close the conversion program by clicking on the Exit button. The spreadsheet will remain open.

You must still select the correct orientation (portrait or landscape), and resize the spreadsheet to print on a single page. Depending on the spreadsheet program you use, this can be done through something like Page Properties, or using the Print dialog itself. Here is an example showing how it is done for Microsoft Excel 2013 using the Print dialog.

Microsoft Excel 2013 Print Setup

You may need to change up to three page properties (settings). The actual names may be different from what is shown above:

If you want to print a title in the heading of the printout, locate the Header/Footer settings in your Page Setup and choose the "ARRL NPOTA..." header:

Title

Finally, choose your printer and print it!

After printing, you may close it the spreadsheet. Your spreadsheet program may ask you if you want to save any changes you made to the page properties. You can choose No and simply exit the program without saving.

Here are the functions of the remaining buttons in the NPOTA program window:

About
Brings up an informational window showing the program version and date
Help
Takes you to this web page
NPOTA
Takes you to the ARRL National Parks on the Air website
Update
Updates the NPOTA conversion program to the newest version that is available
Exit
Exits the program

Future Features

Some QSOs will count for more than one NPOTA "unit", but DX4WIN only lets you record one unit. There will be a way to create a list of confirmed units that DX4WIN doesn't know about. This will give a more accurate confirmed total when you run the conversion program.


Version History

To download the installation program, click on the hyperlink containing the version number and date.

Ver 2.0 - 9 March 2016
Output XLS file with color highlighting
Added STATE next to NPOTA unit ID

Ver 1.0 - 27 February 2016
Initial release.