¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io

13 Colonies Dashboard


 

I was not feeling productive during a work call and decided to make a 13 Colonies dashboard tracker to be more productive.? It's in the files section under my callsign.

/g/nodered-hamradio/files/AA0Z%20-%20Contesting%20Flows/13colonies.json

Database name : 13colonies
Database schema
CREATE TABLE IF NOT EXISTS qsos(
? "timestamp" TEXT,
? "band" TEXT,
? "mode" TEXT,
? "call" TEXT
);

My Contest Dashboard has some instructions on how to create a database and load the schema.? I think the only non-standard node is sqlite3.??



13 Colonies starts on Thursday.? I don't usually log 1x1's and my printer broke, so I figured it was easier to make a database/dashboard than by a new printer.

NUKE DATABASE deletes all the entries from the database, so use with caution.??

73
Kyle
AA0Z


 

You need a life!? LOL

Nice work!

Mike va3mw


On Tue, Jun 28, 2022 at 4:06 PM Kyle K <kylekrieg@...> wrote:
I was not feeling productive during a work call and decided to make a 13 Colonies dashboard tracker to be more productive.? It's in the files section under my callsign.

/g/nodered-hamradio/files/AA0Z%20-%20Contesting%20Flows/13colonies.json

Database name : 13colonies
Database schema
CREATE TABLE IF NOT EXISTS qsos(
? "timestamp" TEXT,
? "band" TEXT,
? "mode" TEXT,
? "call" TEXT
);

My Contest Dashboard has some instructions on how to create a database and load the schema.? I think the only non-standard node is sqlite3.??



13 Colonies starts on Thursday.? I don't usually log 1x1's and my printer broke, so I figured it was easier to make a database/dashboard than by a new printer.

NUKE DATABASE deletes all the entries from the database, so use with caution.??

73
Kyle
AA0Z


Marty Bluhm
 

¿ªÔÆÌåÓý

Wild, this is the one special event I never miss. I¡¯ll be checking out the good stuff.
I normally used pencil and paper.
73

Marty Bluhm
W8AKS



On Jun 28, 2022, at 4:06 PM, Kyle K <kylekrieg@...> wrote:

?I was not feeling productive during a work call and decided to make a 13 Colonies dashboard tracker to be more productive.? It's in the files section under my callsign.

/g/nodered-hamradio/files/AA0Z%20-%20Contesting%20Flows/13colonies.json

Database name : 13colonies
Database schema
CREATE TABLE IF NOT EXISTS qsos(
? "timestamp" TEXT,
? "band" TEXT,
? "mode" TEXT,
? "call" TEXT
);

My Contest Dashboard has some instructions on how to create a database and load the schema.? I think the only non-standard node is sqlite3.??



13 Colonies starts on Thursday.? I don't usually log 1x1's and my printer broke, so I figured it was easier to make a database/dashboard than by a new printer.

NUKE DATABASE deletes all the entries from the database, so use with caution.??

73
Kyle
AA0Z


 

Next step, a full blown contest logger with Contest Dashboard integration...

...hold my beer...


 

Updated with integrated cluster to filter for the 13 Colonies stations.


 

Updated 13 colonies dashboard with the TM13COL bonus station.??


 

¿ªÔÆÌåÓý

There were three bonus stations last year, took me just under 9 hours to bag all 16. New personal record.

In addition to TM13COL you have WM3PEN and GB13COL as bonus.

Now that Xenia and my conference in Atlantic City are behind me I need to get back to Node Red.

Was working on station redesign for high power SO2R on contest bands while maintaining WARC functionality on my 5 band Yagi.?

Triplexer, diplexer and high power band pass filters ordered.?

Thinking of locating everything except radio in my garage. Monitoring ambient temp in garage.

73
Dave wo2x


On Jun 29, 2022, at 4:40 PM, Kyle K <kylekrieg@...> wrote:

?Updated 13 colonies dashboard with the TM13COL bonus station.??


 

Updated the 13 Colonies JSON file in the files section under my callsign.? The last update.?

Changes before the event starts tomorrow at 9am Eastern
Added some CSS formatting.
Added IRC (search for irc for the install node) node to connect to the DX Summit cluster (no telnet connection for that cluster).? Here is IRC info if it doesn't carry over.? server : irc.radiochat.org channel : #CQDX
Added state abbreviation after the 1by1 callsign.?

Once connected to the IRC server and telnet cluster, will monitor all the spots and only filter the 13 colonies/bonus stations and display them in the table on the left hand side.? Feel free to add voice announcement or email notifications.?