Re: Uploading to the Award Checker

Jim K5SP


Would you please share with me?  It would help me a lot with the LONP issues.

Jim K5SP

On 1/26/2022 3:13 PM, JoAnn Donaldson via wrote:
Harry, K9HW

I have a Spreadsheet that uses sheet 2 as a database. All of the members that have an 070 number are listed on the sheet 2. One sheet one. I have a column that when you enter a call in the sheet, does an lookup using the database on sheet 2. If there is an match, it shows the 070 number on sheet one. Also if you happen to enter a call that you already have worked it it cause the background color of the call to turn Green. If you like a copy of my spreadsheet email me direct and I will send you a copy.


On Wednesday, January 26, 2022, 02:46:10 PM CST, Harry Wilkins <k9hw@...> wrote:


I recently built an Excel file to parse my log and find contacts with all LONP members, it compares their start date to the QSO contact date and checks to see if it was the first contact.  It still takes a little manipulation, reducing the log file to just the columns needed and converting the date and time to separate columns and go through a few sorts.  If you're well-versed with Excel, I would be happy to share it with you, or if you would like to send me your log, I can parse it and provide you with a list of LONP contacts you can forward to Milt.

Harry, K9HW


From: [] On Behalf Of Jim K5SP
Sent: Wednesday, January 26, 2022 12:44 PM
Subject: Re: [070Club] Uploading to the Award Checker


David, the checker will work fine for numbers >2787, except for the LONP awards. 

The checker doing the LONP requires access to a Google Spreadsheet that contains all member information.  For every submission, it would go and check the sheet to see if any changes had been made, and if so, built a new file to compare the logs against.  The link to the spreadsheet no longer works due to Google deprecating the API, and us not having access to the source code to fix it.  Therefore, it cannot build a new file, and retains the one that it had previously built and uses it to compare logs.  We quickly learned that the API quit working at #2786, and that is why anyone with a >2786 member number does not get recognized for LONP purposes.   It also means that those of us that have contacts with members >2786 have to submit to N6MG for confirmation and credit. 

There is a new endorsement checker in progress, but, it is a tremendously huge program, (to allow for checking for ALL endorsements), and is being done by a volunteer in his spare time, while juggling, work, family, and pursuit of a masters degree.

It is a very slow process.

Jim K5SP

On 1/26/2022 12:20 PM, David Godden wrote:



Thank you for your note


I have a question:

For those that have numbers greater than 2787 can we just submit our logs and have the endorsements counted??


Frankly the alternative method is extremely arduous difficult time consuming and very frustrating. Please advise


David “Roy” Godden

PODXS 070-2883


On Wed, Jan 26, 2022 at 10:14 John - KC3FL via <> wrote:

While reviewing the logs uploaded to the Award Checker, I've noticed a number of members that appear to have not uploaded their log since their initial 50 contacts.  It's not a requirement to upload the log periodically however to receive endorsements it is necessary.  If you're not chasing endorsements, you might want to give it a try, chasing endorsements is a lot of fun.  Remember when uploading your logs make sure you upload the entire log, even the ones you have already uploaded. 

Award Submission and Validation Director


“Too much of a good thing is bad, but too much of good Whisky is barely enough!” Mark Twain

73 de KK6M
David "ROY" Godden
CWop #2177

Jim,  K5SP #483
Executive Director/Member Services Director

Jim,  K5SP #483
Executive Director/Member Services Director

Join to automatically receive all group messages.