I just saw my pic of my map looks terrible...Each square on the map shows the grid number and the call sign that LoTW has as confirmation for that grid...Page 1 populates from info entered on pages 2-4...The only thing you enter on page 1 is the Call Sign.

Dennis

On Monday, June 12, 2023 at 11:05:57 AM CDT, Dennis Tune <[email protected]> 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:[email protected]

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html