[LCC] Post-contest Data Mining

[Roland Guidry]

That is so cool Mark! When I click on Drop Marker I thought it would never
end. Wow! 

Interesting what can be done with tech today!

Roland NA5Q

-----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 rguidry at na5q.us