[ADXA] Cool Spreadsheet for Grids
WB5JJJ
wb5jjj at gmail.com
Mon Jun 12 12:34:42 EDT 2023
Well, the FFMA is kinda like the DXCC only in a more limited scope.
I forgot where I "stole" the idea from, but you reminded me. I've been
using it for several years. I've heavily modified the spreadsheet to
include about 10 tabs to pretty much automate the process. (But only I
have limited understanding of what I created years ago). I've also created
one tab that keeps track of what's needed. See both attached.
As for the VHF Contest this weekend, I was able to snag 7 more grids (4
confirmed), but 2 others fall into the "Deadbeat" group as they don't LoTW
and one does not even do QSL Cards, so they are still shown as needed (in
Red). And these are "rare grids", so I'm still on the lookout for them.
There were about 12 in that list a couple years ago, but others followed
and uploaded to LoTW.
73's
George - WB5JJJ
HoIP - 100105
On Mon, Jun 12, 2023 at 11:05 AM Dennis Tune <dennis at tuneconcrete.com>
wrote:
> I know this is not DX related but I've attached is a neat spreadsheet for
> tracking grids in US (I use for 6m)...This came from a guy up in
> Harrison...David Swanson KG5CCI deserves the credit (not me)....Anyway,
> it's an excel spreadsheet...Once you open the spreadsheet go to page 2
> "Confirmed in LOTW" and cut and paste as shown on the instruction
> window...Page 3 is where you manually input paper QSL's...Page 4 is where
> you manually input worked but not confirmed stations...It's a good way to
> track 6m FFMA progress...I've shown a screenshot of mine so you can see
> what it looks like...Since I'm at the office and not at home where all my
> "worked but not confirmed" info is mine only shows LOTW confirmed...The QSL
> by card grids will show in Blue when you enter them...Worked but not
> confirmed will be in yellow...The Hero page lists all the call signs in
> your confirmed list...I guess "Hero's" would be people who you've worked
> from multiple grids...
>
> Dennis Tune W9DCT
> ______________________________________________________________
> ADXA mailing list
> Home: http://mailman.qth.net/mailman/listinfo/adxa
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:ADXA at mailman.qth.net
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qth.net/pipermail/adxa/attachments/20230612/fafc5f22/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 230612 - Gridmaster.JPG
Type: image/jpeg
Size: 335762 bytes
Desc: not available
URL: <http://mailman.qth.net/pipermail/adxa/attachments/20230612/fafc5f22/attachment-0002.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 230612 - Needed GS.JPG
Type: image/jpeg
Size: 112214 bytes
Desc: not available
URL: <http://mailman.qth.net/pipermail/adxa/attachments/20230612/fafc5f22/attachment-0003.jpe>
More information about the ADXA
mailing list