Log Checking Procedure:

1. If necessary, each QSO line in a log is converted to the following in a plain text file:

K3WWP 20 0036 WA8REI MI 0557 1 2

Which is:
CALL(Your own call) BAND QSO_TIME STN_WKD STATE/PROV NAQCC_NUM NEW_MULT_INDICATOR POINTS

Depending on your log format, this may require one or more of the following steps:

A. Inserting your call at the beginning of each line
B. Changing 20M, 40M, 80M to just 20, 40, 80
C. Removing RST reports
D. Removing your NAQCC number
E. Removing the date
F. Re-ordering the info, generally the last 3 items in a QSO

Therefore if your log is as close as possible to the format shown above, you are my hero
because that means less fooling around with your log to get it in the right shape. GenLog
v 6.37 and higher creates that exact format when you do the following:
A. Click the 'Log' menu
B. Choose and click 'Write ASCII log [K3WWP.log]' in my case, or for you '[(your call).log]'

2. When all logs are received and converted, the text file is imported into an Excel
spreadsheet and a column for QSO Number is added. (Column C)

Columns are as follows:
A - YourCall
B - Band
C - QSO Number
D - QTIM
E - WKD
F - ST
G - INFO
H - SNR
I - PT
J - Field(s) containing errors
K - Erroneous info
L - L here means WKD submitted a log
M - x here means QSO in both logs

------------------------------------------------------
3.

SORT: G

CHECK: CALLSIGNS THAT DON'T MATCH MEMBER NUMBER

U2: =IF(G2=G1,1,"")
V2: =IF(AND(U2=1,E2=E1),1,"")
W2: =IF(U2=V2,"",1)

A 1 IN COLUMN W INDICATES A POSSIBLE CALLSIGN ERROR

------------------------------------------------------
4.

SORT: A B E

CHECK: DUPLICATE QSO'S

N2: =IF(AND(A2=A1,B2=B1,E2=E1),1,"")

A 1 IN COLUMN N INDICATES A DUPLICATE QSO.

------------------------------------------------------
5.

SORT: E F G

CHECK: ST INFO MATCHES WKD

O2: =IF(AND(E2=E1,F2=F1,G2=G1),"",1)
P2: =IF(AND(O2=1,E2=E1),1,"")

A 1 IN COLUMN P MEANS AN ERROR IN ST OR INFO.

------------------------------------------------------
6.

SORT: I G

CHECK: POINT VALUE IS CORRECT

Q2: =T(G2)

A BLANK CELL SHOULD SHOW FOR 2 POINT QSO'S AND THE POWER SHOULD SHOW FOR 1 POINT QSO'S.
ANYTHING ELSE IS A POSSIBLE ERROR IN POINTS.

------------------------------------------------------
7.

SORT: A F C

CHECK: MULTIPLIER COUNT

R2: =IF(F2=F1,1,"")
S2: =IF(ISNUMBER(H2),1,"")
T2: =IF(R2=S2,1,"")

A 1 IN COLUMN T MEANS AN ERROF IN MULTIPLIER COUNT

------------------------------------------------------
8.

SORT: D

BE SURE ALL TIMES ARE IN THE CORRECT TIME FRAME.

------------------------------------------------------
9.

SORT E
MARK AN L IN COLUMN L FOR THOSE STATIONS IN WKD WHO HAVE SUBMITTED A LOG

8A.

SORT L B D
IF A QSO IS IN BOTH LOGS, PUT AN x IN COLUMN M

8B.
SORT L D
IF A QSO IS IN BOTH LOGS BUT ON DIFFERENT BANDS, PUT AN xx IN COLUMN M

IF A QSO DOES NOT MATCH, PUT 'not in log' IN COLUMN M

------------------------------------------------------
10.

SORT A C
RECOMPUTE ALL SCORES TO ACCOUNT FOR CHANGES MADE IN ABOVE PROCEDURES

------------------------------------------------------
PART TWO: Logging results on the web site:

1. Your score line is cut and pasted from your report to the web page. This usually means
simply adjusting the column spacing if your score line is in the format we request. If it
is in some other non-standard format, it must be (figured and) entered manually. Now with
our autologger, I create the line myself from the number of QSO's, member QSO's, mults, and
key bonus in the form.

2. The words 'Special Award' are searched for in your report to see if you are eligible
and have so indicated. If those words are not found, you are not listed as being eligible.
In the autologger, the Special Award field must have a Yes entry for you to be eligible.

3. The word 'Soapbox:' is searched for and if found, the material following is transferred
to the web page. If no word soapbox is found, all comments in your report are assumed to
be private even if they sound like soapbox material. Of course in the autologger, your
soapbox info is in the Soapbox field.

Thanks many times over to all those who strive to report their results as close as possible
to the format we suggest, or use our autologger. It certainly makes my job much easier and
quicker.