SpotCollector add-in SpotSpy supports this objective

For more information about SpotSpy visit http://www.dl9ho.de/SpotSpy/SpotSpy.htm

Full release is available at http://www.dl9ho.de/adidl.html

73, Volker DL9HO

+ AA6YQ comments below

I'm sure this is provided for somewhere in the help or the wiki, but I can't find it, after a half-hour of trying. A simple link to the right place would be great.

What I'm trying to do is finish my 160M DXCC - I have more than enough worked, and with the ARRL 160-meter contest coming up this evening I would love to know in real time when someone in an entity that I still need to confirm is spotted. Does this require a specialized SQL expression, or does DXLab provide a way of doing this?

+ The simplest approach:

1. In the "DXCC Bands & Modes" panel on the General tab of DXKeeper's Configuration window, make sure the 160m box is checked

2. If the 160m box wasn't previously checked, then on the "Spot Database" tab of SpotCollector's Configuration window, check the Recompute button along the right side of the tab

3. In the Filter panel at the bottom of SpotCollector's Main window, click the "Need" button

+ SpotCollector will display ALL active stations with whom a confirmed QSO would advance your progress towards the awards you are pursuing -- including 160m DXCC.


+ If you only want to see stations active on 160m with whom a confirmed QSO would advance your progress towards all of the awards you are pursuing, filter the Spot Database Display with this SQL expression:

<NeedFilter> and (Band = '160m')

+ If you only want to see stations active on 160m with whom a confirmed QSO would advance you progress towards 160m DXCC, filter the Spot Database Display with this SQL expression:

(Band = '160m') and (BandProgress <> 'F') and (BandProgress <> 'V')

+ If you're going to filter the Spot Database Display exactly once at the beginning of the next two evenings, simply paste the desired SQL expression in the Filter panel's textbox and then strike CTRL-S

+ If you'd like a permanent 160m filter button, note that SpotCollector's Filter panel provides 4 groups of 8 user-defined filter buttons; the currently-accessible group is selected by clicking one of the 4 buttons surrounding the letter S (just beneath the Need button). Choose the button your wish to trigger your new 160m filter, and depress the CTRL key while clicking it, The "SpotCollector SQL Filter" window will appear, with the filter you CTRL-clicked highlighted with a red filter number at the left; change this filter's Caption to

160m

+ and paste the desired SQL expression in the large textbox to the right of the Caption textbox. Test your new 160m SQL filter by clicking its button in the filter panel.


+ If you want an audio announcement of active stations that "match" whichever filter expression you chose, then on the "Audio Alarm" tab of SpotCollector's Configuration window,

4. Click the Enable box in the upper-left of the tab

5. Check the desired boxes in the "Alarm Announcements" tab

6. In the "Audio Alarm trigger" panel,

6a. if you chose the "simplest approach" specified by steps 1, 2, and 3 above, then click the Needed button

6b. if you chose to use an SQL expression as described above, then click the "SQL expression" button, and paste the SQL expression you chose into the large textbox to its right


+ All of the above is described in both SpotCollector's reference documentation and its step-by-step "task-based" documentation (aka the "Getting Started Wiki"). If you'd like help with a specific item, just ask.

73,

Dave, AA6YQ

I'm sure this is provided for somewhere in the help or the wiki, but I can't find it, after a half-hour of trying.  A simple link to the right place would be great.

What I'm trying to do is finish my 160M DXCC - I have more than enough worked, and with the ARRL 160-meter contest coming up this evening I would love to know in real time when someone in an entity that I still need to confirm is spotted.  Does this require a specialized SQL expression, or does DXLab provide a way of doing this?

Thanks in advance

-- 
73, Pete N4ZR
Check out the new Reverse Beacon Network
web server at <https://reversebeacon.net>.
For spots, please use your favorite 
"retail" DX cluster.