how can i create a filter on the SCollector that does 

Band and Mode and Callsign LIKE 'K2?'  and Unworked

when selected, i only want to see the 'K2?' stations that on cw or ssb are unworked ??? 

putzed a bit, reading help file... seems to work until i add "unworked"... also would like only spots from the last 30min only...  also how to work in GB13COL WM3PEN TM13COL stations in addition to K2?

+ AA6YQ comments below

how can i create a filter on the SCollector that does 

Band and Mode and Callsign LIKE 'K2?'  and Unworked

when selected, i only want to see the 'K2?' stations that on cw or ssb are unworked ??? 

putzed a bit, reading help file... seems to work until i add "unworked"... also would like only spots from the last 30min only...  also how to work in GB13COL WM3PEN TM13COL stations in addition to K2?

+ Reviewing

http://www.13colonies.us/

+ the objective is to work 15 specific callsigns, on any band in any mode. If that's correct, then

 

1. add each of those 15 callsigns to SpotCollector's Special Callsigns list with the tag 13colonies

https://www.dxlabsuite.com/dxlabwiki/IdentifyLogClubMembers

2. define a filter to find the stations you haven't worked on bands and modes on which you are QRV,:

(TAGS LIKE ('*13colonies*')) and (Bands in (list of bands I can work)) and (Modes in (list of modes I can work))

for example

(TAGS LIKE ('*13colonies*')) and (BAND in ('80m','40m','30m','20m','15m','10m','6m')) and (MODE in ('CW','SSB'))

3. When you work one of these 15 stations, remove it from SpotCollector's Special Callsign List

+ Good hunting!

      73,

              Dave, AA6YQ

 

 

In the for what it's worth category, here is the SpotCollector filter I use, without using Special Callsigns or Tags. I'm trying to "triple-play" it, so work each one on digital, phone and CW. I remove the callsign from the appropriate line after I've worked it.

(CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'CW' and <AGEFILTER> and SpotCount > 1) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'SSB' and <AGEFILTER>) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE LIKE 'FT*' and <AGEFILTER> and SpotCount > 1)

And to keep track of it, I built a Google Sheet a few years back, which is available for others to use if you like:

https://km8v.com/u/13colsblank

Here's mine so far this year: https://km8v.com/u/13cols2022

I'll also mention my annual request for SpotCollector leaderboard functionality with an "ignore before date" capability :)

73 de KM8V Jon

tnx all...

ya, ive been doing it with a simple spreadsheet for years... CW/SSB only as i despise FTx and what its done to 'twitterize' things... 

another is to simply use dxsummit URL, check 'em off one at a time as worked... 

On Sat, Jul 2, 2022 at 04:17 AM, Jon KM8V wrote:

In the for what it's worth category, here is the SpotCollector filter I use, without using Special Callsigns or Tags. I'm trying to "triple-play" it, so work each one on digital, phone and CW. I remove the callsign from the appropriate line after I've worked it.

(CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'CW' and <AGEFILTER> and SpotCount > 1) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'SSB' and <AGEFILTER>) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE LIKE 'FT*' and <AGEFILTER> and SpotCount > 1)

And to keep track of it, I built a Google Sheet a few years back, which is available for others to use if you like:

https://km8v.com/u/13colsblank

+ Using the <REPORT> and <APPENDREPORT> commands, you can define a DXKeeper script that generates a progress report by filtering the Log Page Display for QSOs with those 15 stations in each of the "modes of interest", sorted by callsign.

       73,

             Dave, AA6YQ

 

+ AA6YQ comments below

but i thought i'd be able to readily just have it work like DXCC country does.

+ Implementing Realtime Award Tracking for a 1-week activity held once per year that involves working ~15 stations is not justified, given SpotCollector's filtering capabilities.

      73,

           Dave, AA6YQ

# More AA6YQ comments below

In the for what it's worth category, here is the SpotCollector filter I use, without using Special Callsigns or Tags. I'm trying to "triple-play" it, so work each one on digital, phone and CW. I remove the callsign from the appropriate line after I've worked it.

(CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'CW' and <AGEFILTER> and SpotCount > 1) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'SSB' and <AGEFILTER>) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE LIKE 'FT*' and <AGEFILTER> and SpotCount > 1)

+ That expression can be simplified to

 

(CALLSIGN IN ('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL')) and <ORIGINFILTER> and <AGEFILTER> and ((MODE = 'SSB') or (((MODE = 'CW') or (MODE LIKE 'FT*')) and (SpotCount > 1)))

# The suggested simplification is appropriate if your goal is to work those 15 stations once in any mode. If the goal is to work them in each of CW, SSB, and FT*, then your original expression is appropriate.

         73,

              Dave, AA6YQ

On Sat, Jul 2, 2022 at 12:51 PM, Dave AA6YQ wrote:

# The suggested simplification is appropriate if your goal is to work those 15 stations once in any mode. If the goal is to work them in each of CW, SSB, and FT*, then your original expression is appropriate.

I was bored earlier, waiting for some needed 13 colonies spots to arrive, and I updated my tracking google sheet to generate the SpotCollector filter based on what remains needed - the goal for this is to "triple play" each station.

If anyone else might find that useful, the updated sheet is here: https://km8v.com/u/13colsblank

If you scroll down, you'll see a generated SQL filter for SpotCollector based on what is represented in the sheet above.

And if anyone would like to see my current sheet for 2022, it is here: https://km8v.com/u/13cols2022 

73 de KM8V Jon

On Sat, Jul 2, 2022 at 12:49 PM, Dave AA6YQ wrote:

+ Implementing Realtime Award Tracking for a 1-week activity held once per year that involves working ~15 stations is not justified, given SpotCollector's filtering capabilities.

I don't care about realtime award tracking, but the ability to define an arbitrary leaderboard in spotcollector with an "ignore qsos before date" option would be pretty cool. :)

73 de KM8V Jon

+ AA6YQ comments below

I don't care about realtime award tracking, but the ability to define an arbitrary leaderboard in spotcollector with an "ignore qsos before date" option would be pretty cool. :)

+ What is an "arbitrary leaderboard"?

       73,

              Dave, AA6YQ

On Sat, Jul 2, 2022 at 06:21 PM, Dave AA6YQ wrote:

+ What is an "arbitrary leaderboard"?

Perhaps I should have said, "arbitrarily named leaderboard". A way to tag something as a leaderboard with a specific scope, and the aforementioned ignore-before-date.

The obvious example being 13 colonies, being able to flag the special event callsigns as a "leaderboard", separate from the normal <Leaderboard> tag, and specifying to ignore QSOs prior to Jan 1 2022 (or June 30 2022, whatever) in the log.

73 de KM8V Jon

# more AA6YQ comments below

On Sat, Jul 2, 2022 at 06:21 PM, Dave AA6YQ wrote:

+ What is an "arbitrary leaderboard"?

Perhaps I should have said, "arbitrarily named leaderboard". A way to tag something as a leaderboard with a specific scope, and the aforementioned ignore-before-date.

# What do you mean by "leaderboard"?

# What's an example of a "specific scope"?

The obvious example being 13 colonies, being able to flag the special event callsigns as a "leaderboard", separate from the normal <Leaderboard> tag, and specifying to ignore QSOs prior to Jan 1 2022 (or June 30 2022, whatever) in the log

.# Assigning the Leaderboard tag to a callsign on the Special Callsign List means that Spot Database Entries for that callsign will be considered needed if the callsign hasn't been worked on the entry's band (160m, 80m, 40m, 30m, 20m, 17m, 15m, 12m, 10m, 6m, 2m) and in the entry's mode (phone, CW, digital). The word "leaderboard" refers to a display provided by Club Log or by a DXPedition - not something that SpotCollector provides. The Leaderboard tag would only be useful to "13 colonies" if your goals is to work all 15 of those stations on 160m, 80m, 40m, 30m, 20m, 17m, 15m, 12m, 10m, 6m, 2m and in phone, CW, and digital.

    73,

          Dave, AA6YQ

On Sun, Jul 3, 2022 at 01:28 AM, Dave AA6YQ wrote:

The obvious example being 13 colonies, being able to flag the special event callsigns as a "leaderboard", separate from the normal <Leaderboard> tag, and specifying to ignore QSOs prior to Jan 1 2022 (or June 30 2022, whatever) in the log

.# Assigning the Leaderboard tag to a callsign on the Special Callsign List means that Spot Database Entries for that callsign will be considered needed if the callsign hasn't been worked on the entry's band (160m, 80m, 40m, 30m, 20m, 17m, 15m, 12m, 10m, 6m, 2m) and in the entry's mode (phone, CW, digital). The word "leaderboard" refers to a display provided by Club Log or by a DXPedition - not something that SpotCollector provides. The Leaderboard tag would only be useful to "13 colonies" if your goals is to work all 15 of those stations on 160m, 80m, 40m, 30m, 20m, 17m, 15m, 12m, 10m, 6m, 2m and in phone, CW, and digital.

Yes. Exactly. Although this year I decided just to try to triple-play 13 Colonies, not work them all everywhere.

I had another example of where I thought this would be useful, but it has escaped me at the moment.

jon KM8V -   were you thinking of the RT66 On The Air radiosport event in Sept?    its a similar thing with a list of specific callsigns like 13Colonies?  like you, i was bored with tracking it manually... 

Jim N7US - ya i did the N1MM thing as well, it does provide a subtractive "need" list, but no help in selectively filtering spots so only the ones i yet still need are displayed to be able to simply "click to tune" to them.   as you have noticed hundreds of spots for the 13Colonies  occur, mostly i suspect because folks likely have their loggers to "auto-spot" what they work.

its easy to track/do manually of course...  after all, there are only 16 stations.... 

but thought as long as i have this Atomic Powered Swiss Army Knife id try to use it.   its almost the epitome of lazy  :-)) 

+ AA6YQ comments below

When I use either filter all I get is the SSB spots, even though I see several for CW if I don't use any filter.

What have I done wrong??

+ Please post the filter you are using.

     73,

         Dave, AA6YQ