Page 22 January February 2018 TCA

Figure 1: CG3EXP WSPR Spot Counts by Date as of November, 14, 2017

We can further refine our query on a band Figure 2: Top 10 Reporters Band By Band November 14, 2017
by band basis thus,
40 metres 30 metres 20 metres
SELECT BAND, COUNT(*) FROM WSPR_
DATABASE GROUP BY BAND ; Reporter Count Reporter Count Reporter Count
Which would provide a count of spots on K9AN 7855 K9AN 7348 K9AN 3264
each band from beginning to end. As of VE6JY 7296 VE6JY 4517 VE6JY 1485
November 14, 2017 there are 47,726
WSPR spots on 20m, 110,469 on 30m, N4TVC 4866 WJ1I 3600 KU4QI 1386
and 267,195 on 40m. GM4SFW 4575 KN8DMK 3302 W2CXM 1305
If you add up the counts on each KD6RF 4562 K6SJC 2737 K7GXB 1131
individual band and compare that to the WB3DZC 4353 VE3OWV 2551 W4MO 1129
total count from before you will notice
that there is a discrepancy of 55. This VE3GTC 3663 KK1D 2284 W4HOD 1075
discrepancy is a result of errors W0AY 3531 VE3XZT 2253 CG3KI 1017
introduced by WSPR receiving sites which
for one reason or another reported NN6RF 3451 VE3YX 2138 VE3YX 917
CG3EXP on a band other than 20m, 30m N5CEY 3149 SWLNXZ 2042 KK1D 848
or 40m. There may even be some spots
which were reported on a correct band There have been 425,445 WSPR spots Barrie Crampton, VE3BSB, was licensed
but at the wrong time; this simple query reported by 2305 reporters worldwide in 1954 and was issued the call VE2WQ.
will not indicate these but such a query from all continents except Antarctica as of He held the call VE8PF while working in
could be created to do so. November 14, 2017. the Arctic with Spartan Air Services.
Because the transmission sequence for The top 10 reporters on a band by band Barrie currently lives in Perth, Ontario and
CG3EXP is very regimented, it is easy to basis are shown in Figure 2. is the Emergency Coordinator with the
use queries such as these to identify and Lanark North Leeds ARES Group.
then correct spots that were reported on The bulk of the WSPR data collected John Gilbert, VE3CXL, was licensed in
the wrong band removing some of the from CG3EXP, particularly when the 1954 as VE3BOH. He operated as
more easily identifiable errors within the Polar Prince was transiting the Northwest VE8OW from 1956-58. He held the call
dataset. Passage has been provided to the
scientists at the Natural Resources FP0GNS (St. Pierre and Miquelon) and
We have already seen some of the more Canada Geomagnetics Laboratory for has operated from Amateur stations of
basic statistics for CG3EXP, such as the detailed analysis. From their data they the International Telecommunication
number of spots and on which bands, but will be able to explain the reasons for Union in Geneva, Switzerland and Kyoto,
the CG3EXP journey has not yet ended. the dips and peaks in the above chart. Japan. He is a member of Chapter 70 of
The Polar Prince reached Victoria, British We anxiously await their report. the Quarter Century Wireless Association
Columbia toward the end of October right (QCWA).
on schedule. Now the CG3EXP EPT The following websites may be of interest
journey, albeit with the new call sign to readers: Graham Collins, VE3GTC, describes
VE0EXP, is expected to continue to https://www.qrz.com/db/CG3EXP himself as “a late 1960s teenage
transmit when the Polar Prince makes its techno geek first licensed in the
journey south, through the Panama Canal http://qrp‑labs.com/ultimate3/u3s mid-70’s as VO1QC who has lived,
and back to its home port of Halifax. worked, flown and has operated
http://www.qrp‑labs.com/c3.html Amateur Radio from the four corners of
The data provided in Figures 1 and 2 https://aprs.fi/#!call=a%2FCG3EXP Canada and everywhere in between.”
include all CG3EXP WSPR data up to
November 14, 2017.
20