ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
13 ColoniesSTATEFT4/8PHONECWOTHER
2
K2ANYBand Breakdown
3
K2BVA401600Filter Builder
4
K2CRI801K2AK2AK2A
'K2A','K2C','K2D','K2E','K2F','K2H','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL'
5
K2DCT600K2CK2BK2B
'K2A','K2B','K2C','K2D','K2E','K2G','K2H','K2I','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL'
6
K2EDE40404K2DK2CK2C
'K2A','K2B','K2C','K2D','K2F','K2G','K2H','K2I','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL'
7
K2FMD40300K2EK2DK2D
8
K2GGA20202K2FK2EK2F(CALLSIGN IN(
9
K2HMA170K2HK2GK2G
'K2A','K2B','K2C','K2D','K2F','K2G','K2H','K2I','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL'
10
K2INJ40150K2JK2HK2H
) and <ORIGINFILTER> and MODE = 'CW' and <AGEFILTER> and SpotCount > 1)
11
K2JNC8020120K2KK2IK2I or (CALLSIGN IN(
12
K2KNH100K2LK2KK2K
'K2A','K2B','K2C','K2D','K2E','K2G','K2H','K2I','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL'
13
K2LSC60K2MK2LK2L
) and <ORIGINFILTER> and MODE = 'SSB' and <AGEFILTER>)
14
K2MPA
Mode Breakdown
WM3PENK2MK2M or (CALLSIGN IN(
15
WM3PENBonusFT3GB13COLWM3PENWM3PEN
'K2A','K2C','K2D','K2E','K2F','K2H','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL'
16
GB13COLBonus UKPhone2TM13COLGB13COLGB13COL
) and <ORIGINFILTER> and MODE LIKE 'FT*' and <AGEFILTER> and SpotCount > 1)
17
TM13COLBonus FRCW2TM13COLTM13COL
18
wkd/remain/total74148
19
Instructions / Notes - Goal of the sheet is to Triple Play the 13 colonies
20
Make your own copy of the sheet.
21
Clear example data before using.
22
Enter band in the mode column as you work stations.
23
Get your own version of this here: http://km8v.com/u/13colsblank
24
Drop KM8V a note if you find this useful.
25
2020: No K2Z this year.
26
2021: Added TM13COL
27
2022: Added band / mode breakdowns and generated spotcollector filter (below)
28
29
Spotcollector Filter (generated):
30
(CALLSIGN IN('K2A','K2B','K2C','K2D','K2F','K2G','K2H','K2I','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'CW' and <AGEFILTER> and SpotCount > 1) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2G','K2H','K2I','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'SSB' and <AGEFILTER>) or (CALLSIGN IN('K2A','K2C','K2D','K2E','K2F','K2H','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE LIKE 'FT*' and <AGEFILTER> and SpotCount > 1)
31
32
SpotCollector Filter (all):
33
(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)
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100