[SJDXA] 13 Colonies Event - Excel Sheet

[jeff griffin]

For a real challenge remember there also on Satellites. This year I was 
drafted  to come out of retirement as a 13 colonies operator to activate 
K2I and K2E, NJ and DE. We once again, have the 13 colonies on sats. 
Last time I gave out a sweep was 2014. That year I operated from 3 
states to keep it going NJ DE, and PA. I'm heading over to DE this 
morning to put K2E OTA. I think we're going to give out maybe 10 or so 
sweeps on the sats this year, it's quite a challenge. I operate from the 
Jersey side of the Delaware river in Delaware. Map file attached....


73 Jeff kb2m

On 7/5/2021 9:50 PM, Ross Lambert wrote:
> 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 
> <mailto: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>
>     [mailto: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/ <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
>
>
> ______________________________________________________________
> SJDXA mailing list
> Home: http://mailman.qth.net/mailman/listinfo/sjdxa
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:SJDXA at mailman.qth.net
>
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.qth.net/pipermail/sjdxa/attachments/20210706/84131f6a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Finns Point DE.kmz
Type: application/vnd.google-earth.kmz
Size: 705 bytes
Desc: not available
URL: <http://mailman.qth.net/pipermail/sjdxa/attachments/20210706/84131f6a/attachment.kmz>