[LCC] Post-contest Data Mining

[Steve Lott]

Scott

Always impressed with what you do with Data mining !

And like Marsh said kudos for getting us NU1AW/5
by the way it appears we will remain in the Top Twenty of the results
currently 16th place in the 3830 showing !


Cheers!

Steve​


http://www.KG5VK.com
My Ham Radio Friends


On Fri, Jul 28, 2017 at 7:40 AM, <marsh at ka5m.net> wrote:

> Hi Scott,
>
> Very interesting. Thanks for sharing.
>
> And thanks again for making the NU1AW/5 operation happen. I think it was
> great to get to operate in a world-wide contest as a multiplier.
>
> Marsh, KA5M
>
>
> -----Original Message-----
> From: LCC [mailto:lcc-bounces at louisianacontestclub.org] On Behalf Of
> w5wz at w5wz.com
> Sent: Thursday, July 27, 2017 6:31 PM
> To: lcc at louisianacontestclub.org
> Subject: [LCC] Post-contest Data Mining
>
> I've always enjoyed data analysis, sorting, parsing, etc.  MS-Excel is one
> of my favorite pieces of software.  Google Maps/Google Earth is another
> favorite.
>
> The SH5 Contest Log Analysis software is really cool, too!  I like to
> document my ham radio activities on my website W5WZ.com.  The site has
> become somewhat of my station journal, with most things being made public,
> but also a few things private where I can call them up as needed.  SH5
> makes
> it easy to create extensive analytical reports of contest logs and
> painlessly upload to a website for storage/sharing/archiving.  I've run the
> past decade of my contest logs thru the SH5 software, you can find the
> results here:
>
> http://w5wz.com/sh5/w5wz/
>
>
> In the recent 2.44 version of SH5, Dmitriy added the KML functions to
> display contacts on maps.  Way cool!  Love it!  That got me to thinking,
> and
> led me to attempt something-an animation of the contest log.
>
> I used the SH5 KML file for all QSOs to create a lookup table in MS-Excel
> with CALL, LATITUDE, LONGITUDE.  Next, I imported the recent
> NU1AW/5 log into Excel, and stripped it down to just HISCALL for each QSO.
> I retained the correct QSO order of the log, and did a VLOOKUP in the table
> created.  Finally, with a lot of help searching Google, I created a HTML
> file with an API that drops a marker for every QSO in the log, in the order
> they were made.
>
> This condenses the 24-hour contest down to 252 seconds.  It's very cool to
> watch!  Enjoy!
>
> http://www.w5wz.com/pindrop.html
>
> Click the Drop Marker button near the top.  You may zoom in or out as you
> desire.
>
> --Scott
>
> _______________________________________________
> LCC mailing list
> LCC at louisianacontestclub.org
> http://mail.louisianacontestclub.org/mailman/listinfo/lcc_
> louisianacontestcl
> ub.org
> Message delivered to marsh at ka5m.net
>
>
> _______________________________________________
> LCC mailing list
> LCC at louisianacontestclub.org
> http://mail.louisianacontestclub.org/mailman/listinfo/lcc_
> louisianacontestclub.org
> Message delivered to lottsphoto at gmail.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.louisianacontestclub.org/pipermail/lcc_louisianacontestclub.org/attachments/20170728/44ec7e82/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KG5VK and KA5M IARU 2017.jpg
Type: image/jpeg
Size: 305711 bytes
Desc: not available
URL: <http://mail.louisianacontestclub.org/pipermail/lcc_louisianacontestclub.org/attachments/20170728/44ec7e82/attachment-0001.jpg>