eHam Logo

 Home Home
 Articles & Stories
 My Profile

 This Week's Contests
 Classified Ads
 Contest Links
 Product Reviews

Site Information
 About This Site Team

[Articles Home]  [Add Article]  

2014 Contest Dashboard Tool--VE1ZA

Anthony Ratajczak (VE1ZA) on November 10, 2013
View comments about this article!

2014 Contest Dashboard Tool

To all contesters,

This MS Excel spreadsheet will help you plan and keep track of your 2014 contests.Its origin is based on the WA7BNM contest list and the Maritime Contest Club, Acadia New Scotland (ANS) Contest Tracker by VE1ZA.

The purpose of the tool is to; plan your yearly the contest campaign, track performance and measure improvements in your contesting skills with respect to whatever type of contesting you wish to do. You can also model expected performance to see if you will achieve your goals.

It is intended for the serious contester who wants to win a particular group of contests, or mode; or achieve the next level in operating skill. It is also a useful tool for the novice contester who just wants to track skill improvement over time.

The sheet has several filtering options that enables you to sort by the type of contesting you like to do, for example, if you like QRP contests, the filtering will sort all the QRP contests for the year.Similarly if you want to do all the DARC or CQ contests, you can filter for those as well.Same goes for QSO parties, RTTY, DIGI, or 160m contests.

I kept the spreadsheet as simple as possible (even used older MS Excel!!) due to a wide variety of MS Excel versions and skills, obviously many more functions and programming can be incorporated.If you do modify it, please acknowledge the original source for the idea.

The monthly contest performance graphs are particularly interesting to view over 6 months, with respect to contesting skill or station improvements.

The spreadsheet is located here, and I hope it adds to your contest planning and enjoyment!

VE1ZA 2014 Contest Dashboard

PS there is sample data within the sheet used to check formulas that must be removed.


Tony VE1ZA

Member Comments: Add A Comment
2014 Contest Dashboard Tool--VE1ZA Reply
by AF4RK on February 17, 2014 Mail this to a friend!
Very nice! I saved it on my desktop
Email Subscription
You are not subscribed to discussions on this article.

My Subscriptions
Subscriptions Help

Other Misc Articles
DXLog Contest Software