[ct-user] Cabrillo and Excel

[Robert A. Wilson]

On 11/28/06, SERGIO HENAO <hk4kdo at 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