On 11/28/06, SERGIO HENAO <hk4kdo@gmail.com> wrote:
What can I do if I have an Excel file with a lot of contacts, and I wanted
to become it to cabrillo format, how can I do?, if it can
One can write an Excel formula to create Cabrillo QSO records as long as one
is careful to get all the column numbers exactly correct. For example, if
you have a spreadsheet like this:
A B C D E F G H I J
------ ----- ------------ ------ ------- --- ---- ---- ---- ----
Freq Mode Date UTC My Call RST Zone Call RST Zone
7.033 CW 11/25/2006 0:00 HK4KDO 599 10 W1AW 599 5
14.033 CW 11/25/2006 23:59 HK4KDO 599 10 WB5WBW 599 4
Copy the following Excel formula into column K:
="QSO:" & REPT(" ", 6 - LEN(A4*1000)) & TEXT(A4*1000,"#0000 ") & B4 & " " &
TEXT(C4,"yyyy-mm-dd ") & TEXT(D4,"hhmm ") & E4 & REPT(" ", 14 - LEN(E4)) &
F4 & TEXT(G4," 00 ") & H4 & REPT(" ", 14 - LEN(H4)) & I4 & TEXT(J4,"
00 ") & "0"
And this will create Cabrillo QSO records in column K, like this:
QSO: freq mo date time call rst exch call rst
exch t
QSO: ***** ** yyyy-mm-dd nnnn ************* nnn ****** ************* nnn
****** n
QSO: 7033 CW 2006-11-25 0000 HK4KDO 599 10 W1AW 599
05 0
QSO: 14033 CW 2006-11-25 2359 HK4KDO 599 10 WB5WBW 599
04 0
Then copy/paste column K into a text editor like Wordpad, and add the header
information at the top and "END-OF-LOG" at the bottom, like this:
START-OF-LOG: 2.0
CREATED-BY: ExcelToCabrillo.xls
CALLSIGN: HK4KDO
NAME: Sergio Henao
ADDRESS:
ADDRESS:
ADDRESS:
ADDRESS:
ADDRESS:
CLUB:
CLAIMED-SCORE: 125028
CONTEST: CQ-WW-CW
OPERATORS: HK4KDO
CATEGORY: SINGLE-OP ALL HIGH CW
QSO: 7033 CW 2006-11-25 0000 HK4KDO 599 10 W1AW 599
05 0
QSO: 14033 CW 2006-11-25 2359 HK4KDO 599 10 WB5WBW 599
04 0
END-OF-LOG:
See http://www.kkn.net/~trey/Cabrillo_v2 for a complete description of the
Cabrillo format for other contests.
I'm attaching a sample spreadsheet, but I don't know if this reflector will
remove it, so I'm copying you directly too.
73,
Bob, N6TV
_______________________________________________
CT-User mailing list
CT-User@contesting.com
http://lists.contesting.com/mailman/listinfo/ct-user
CT on the web: http://www.k1ea.com/
|