[SJDXA] 13 Colonies Event - Excel Sheet

[Ross Lambert]

Thanks Bob,

I am now trying to work them all on CW. The spreadsheet may help!   N3FJP
keeps good track as well.

Best regards,

Ross

W2TT

FN31to
Amston, CT



On Mon, Jul 5, 2021 at 9:38 PM Bob Beyer <bob_beyer at verizon.net> wrote:

> Nice work Ross and congrats on the sweep!
>
>
>
> Chasing the 13 Colonies stations is something I look forward to every year.
>
> I play a version of 13 Colonies bingo to see how many different bands and
> modes I can work them on.
>
> I have an Excel spreadsheet that I use to keep track of which stations
> I’ve worked and on which bands and modes.
>
> I don’t duplicate any QSOs so that I don’t tie up any of the stations
> (once in a while I’ll say hello if someone is calling CQ and getting no
> replies).
>
>
>
> I’ve attached the spreadsheet if anyone else wants to use it.
>
> All you have to do is put a  1  in the cell for the station on the
> band/mode you work them on.
>
> The sheet uses conditional formatting and will turn that cell green
> automatically.  Do not use values other than 1.  If don’t work them, leave
> it blank.
>
> The sheet also tallies up totals for each call, each band, and each mode.
>
> This year there are 3 bonus stations:  WM3PEN, GB13COL, and for the first
> time TM13COL.
>
> I left 3 additional rows for any bonus stations that might be added in
> future years.  I seem to recall there was a one-time only station last
> year.  Was it K2Z?
>
> Take a look at the tab called SAMPLE DATA to see my total for this year so
> far and to get an idea of how it works.  Play around on this tab before you
> enter your own info if you want.
>
>
>
> 73 & GL,
>
>
>
> Bob – KE2D
>
>
>
> *From:* sjdxa-bounces at mailman.qth.net [mailto:
> sjdxa-bounces at mailman.qth.net] *On Behalf Of *Ross Lambert
> *Sent:* Sunday, July 04, 2021 10:22 PM
> *To:* OBARC Membership; South Jersey DX Association
> *Subject:* [SJDXA] 13 Colonies Event
>
>
>
> http://www.13colonies.us/
>
>
>
> Wow!  I just finished working my last 13 colonies station for a clean
> sweep!
>
> Including WM3PEN in Pa
>
> GB13COL in Great Britain
>
> and TM13COL in France
>
>
>
> I worked em all on digital FT8 but they are on all modes all bands.
>
>
>
> Do it!
>
>
>
> Handsome certificate too!
>
>
>
> 73 and Happy 4th of July to all!
>
>
>
> Ross
>
> W2TT/1
>
> Amston, CT
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qth.net/pipermail/sjdxa/attachments/20210705/807542bb/attachment.html>