New Band Countries - how to log?

[admin]

Many competitions, ladders, ask you to collect "New Band Countries". Some fine logging apps fall short.

To qualify, the contact must be a new DXCC entity on a new band, ie this entitity has never contacted on this band ever before. Only the current competition time period counts; this is the harder part.

Many logging apps will filter out contacts in a given time period, and even catalog them by band. However many to not search back from the beginning of the log, maybe many years, to exclude those heard before the competition period.

Fortunately there's an easy fix, with a spreadsheet. Any? Pretty much, as long as it can use a sheet for each year; the logic is the same. I'll give the M$ Excel code as well as the popular and free LibreOffice Calc.

Step 1.
Open a new Workbook. (Please look up what a "workbook" is before continuing.)
Open the first sheet and name it the starting year of the log. If the log is many years old, this first sheet maybe a composite for all the fir…login to view the rest of this post