[PPRAANet] [MHDXA] W1AW/p spreadsheet

[Walt Stinson]

I've enjoyed chasing W1AW around the bands and Mike's email got me thinking
about how to more easily check my progress so I know where I still need to
work 'em. After fussing around for a few hours, I stumbled on a way to do
it.  I you are using DxLab, it's quite easy.

On the "log qso" page under "filter" type "w1aw/?" .
Click on the "my QTH's" tab and check the WAS box (if you have multiple
QTH's, you'll need to do this for each one)
Click on the "Check Progress" tab and check off the band and mode boxes
under WAS
Close this window to get back to the "Check Progress" tab, then go to WAS,
and click the "progress" tab.
This will generate a report that shows your progress by state, band, and
mode

I also have a SQL button custom programmed on the SpotCollector program in
DxLab that returns spots related to the ARRL Centennial. To program a SQL
button, just cntl click an empty button, name it arrl, and then copy and
paste the following SQL statement:
(callsign LIKE 'w1aw*') or (notes LIKE "*arrl*") OR(notes = 'centennial')
OR (callsign="w100aw")

Thanks for the inspiration, Mike.

73, Walt W0CP


_____________________________________
Walton Stinson | president

ListenUp | Colorado * New Mexico * Oregon
direct: 303.501.1262
www.listenup.com <http://listenup.com> | Blog <http://blog.listenup.com> |
Facebook <http://facebook.com/listenup> | Twitter<http://twitter.com/listenup>
 | YouTube <http://youtube.com/listenupav>



On Wed, Apr 23, 2014 at 11:48 AM, W0MU Mike Fatchett <w0mu at w0mu.com> wrote:

> I started chasing these station recently.  My logging software does not do
> a decent job at tracking the W1AW/portable stations by band and mode so I
> created a simple spreadsheet.
>
> You can download them at:
>
> http://www.w0mu.com/w1aw.xls    for the XLS MS Office Excel spread sheet
>  or
> http://www.w0mu.com/w1aw.ods for the Open Office spreadsheet.
> http://www.w0mu.com/w1aw.zip for both spreadsheets.
>
> It is pretty basic.  It lists the states on the left and the bands and
> modes across the top.
>
> Mike W0MU
>
> --
> Mike W0MU
>
>
> _______________________________________________
> MHDXA mailing list
> MHDXA at mhdxa.com
> http://mail.mhdxa.com/mailman/listinfo/mhdxa_mhdxa.com
> Message delivered to walt at w0cp.com
>