Re: Wanted list for grids ?
toggle quoted messageShow quoted text
.WOW ! Great job !!! This would have taken me days/weeks to process.
As suspected most of East coast grids (FM/FN) are somewhat easy to work.
Looking through the list, it seems I have 7 out of all on list worked: DN04/DM74/DM87/DM90/DN43/EN38DM53; However, I know I've missed a 1/2 dozen or so over the years which are probably on the list.
This morning I got all excited over an Eqsl from 2007... checked logs and couldn't find that station which was in EM39 (last one to finish MO) ... turns out it was a SSB QSO - BAH !
From: "Stephen Melachrinos melachri@... " <070@...>
Sent: Sunday, August 13, 2017 2:26 PM
Subject: Re:  Wanted list for grids ?
I'm not an expert on "big data manipulation", but I know my way around Excel pretty well. So I took on Jerry and David's challenge, and here are the results.
There are just over 2.2 million QSOs in the database, but that includes non-US stations/grids, and QSOs that don't include grids. Filtering to just QSOs with US stations with grids included and grids within the 436 that count for the 070 award takes the total down to about 598 thousand. I then tallied (not manually!) how many QSOs were with each of those 436 grids. Note that this counts QSOs, not unique callsigns (so there are many duplicates in the count). I also did not do any real quality checking other than that they were valid 4-character grids that matched one of the 436. So if someone had logged me at my home QTH (which is FN20), but put EN20 or DN20 as the grid, it was counted as that errant grid.
- There are eleven grids that have no QSOs at all:
- There are thirty other grids with less than ten QSOs each:
- There are four grids with over 10,000 QSOs each.
I'll be posting the results spreadsheet to the Yahoo page if anyone wants to check on other grids.