RTTY
[Top] [All Lists]

[RTTY] Contest band planner - BARTG

To: <rtty@contesting.com>
Subject: [RTTY] Contest band planner - BARTG
From: "Robert Chudek" <k0rc@citlink.net>
Reply-to: Robert Chudek <k0rc@pclink.com>
Date: Fri, 17 Mar 2006 01:36:58 -0600
List-post: <mailto:rtty@contesting.com>
I created an Excel spreadsheet for the BARTG SPRING contest. I used it to help 
pre-plan my operating times. Although this .xls file is for the BARTG RTTY 
contest, it can be easily adapted for any HF contest.

If you have basic Excel skills and think this tool might be useful, you can 
download a copy from either of these URL: 

http://tinyurl.com/ncmbk

http://chudek.aberon.net/index.cgi?mode=album&album=./Minnesota%20Wireless%20Assn

Download the file named "2006 BARTG RTTY TIME SHEET"



Here's a brief overview about the spread sheet and how I used it:

The spreadsheet visually shows all 24 hours of Friday, Saturday, and Sunday 
while also showing all contesting bands (160 to 10). In addition, another 
section displays the contest period. This quickly shows you the 0200Z Saturday 
start time is actually 8:00 PM Friday in the Central Time zone. (You will need 
to adjust the "Local" time zone to your situation.)

I color coded the time I expect propagation for each band. Basically the low 
bands at night and the high bands during daylight. Some bands will be open 
simultaneously, so they "overlap" and are evident looking at the page.

My next step was to determine my operating times. First I reviewed the rules 
and found BARTG is a 48 hour event with a maximum operating time of 30 hours 
for a single op. Time off periods are a minimum of 3 hours.

I then began typing "on" into the various time slots and bands I expect to 
operate. (Each cell represents one hour on one band.) On my first pass, I 
populated more than 30 hours of operating time. My next step was to decide 
which hours to sacrifice. I quickly discovered this forces you to determine a 
strategy!

My final step was to number both the operating hours and off hours to make sure 
my schedule adhered to the BARTG rules of a minimum 3 hour off time and maximum 
of 30 hours total op time.

I created this spreadsheet quickly so there isn't much automation.

Does anyone know if any other tool already exists along this line?

73 de Bob - K0RC
_______________________________________________
RTTY mailing list
RTTY@contesting.com
http://lists.contesting.com/mailman/listinfo/rtty

<Prev in Thread] Current Thread [Next in Thread>