[NLRS] 10 GHz logging spreadsheet

[John P. Toscano]

Some of you may have used my Excel spreadsheet to prepare your 10 GHz 
and Up Cumulative Contest logs.  Thanks to additional testing by Gary 
(WØGHZ), I found and fixed a few bugs, and made a few minor improvements.

The full version can be found here:
  C:\www.qsl.net\w0jt\10GHz\index.htm  then click on the link, or else 
go straight to:
    C:\www.qsl.net\w0jt\10GHz\10GHz_Logger.zip

Unfortunately, to make everything happen automagically, there are a LOT 
of formulas in the spreadsheet, so it is huge (about 3 Megabytes).  On 
my system (P4 3.0 GHz with 800 MHz FSB and 1 Mb cache, 1Gb Dual-Channel 
DDR-DRAM, SATA150 hard drive), recalculation is faster than you can 
enter the data (i.e., no perceptible delay), but some folks have 
complained that on their systems, the computer takes 15 seconds to 
recalculate after each cell's datum is entered.  Ugh!

My plan is to create a medium and a small version, which get 
progressively simpler in structure, and leave progressively more of the 
work to you.  These are not done yet, but if/when they are, you should 
be able to find them at the first link above (and follow a link to the 
actual files).

Oh, yeah -- the new feature is that times are entered as 0815 instead of 
08:15 to save keystrokes.  The bugs fixed involved calculation of 
uniques in the 10 GHz & Up category (I previously would not add a unique 
if you worked someone on both 10 and 24 GHz, for example), and 
occasional failure to correctly compute the distance points as 1 for a 
QSO where both operators are in the same grid.  Several other bugs were 
introduced while squishing those, but I think I have them all 
exterminated now.

As always, if you find any problems or have ideas for improvement, 
please let me know.  (Someday, I would like to re-program it in Visual 
Basic and/or PHP, but the end of my vacation time is rapidly 
approaching, and so I don't think it will happen very soon.)

73 de W0JT