K9DCI

Amateur Radio Control

My Excel Radio Memory Management spreadsheets are available below.

These are Excel Workbooks that manage radio memories and do real-time control through serial or USB ports (with converter).

Videos of my tape measure beam are also below. 

The links below will download the files to your computer.

These Workbooks will work only on a PC. You can open the workbooks on the Macintosh, but buttons will not work.

CAUTION: I heard that the Macros would not work on 64 bit systems and Marcelo, PU2MGT, confirmed it.  I had heard this when purchasing my latest computer and got a 32 bit machine for that reason.    Thanks to Laurie, G6ISY, there is a fix being tested.

Typical Features.
No DLLs to load, just the Workbook.
Requires a PC and Excel 97 through 2010 - FLASH ! A fix for use on 64 bit systems in process.  

You must enable Macros upon opening.

Read/Write all radio Memories.
      Plain English and abbreviated entries.    F = FM       107 = 107.2
      All Memories on ONE sheet; includes scan limits & Call.
      DTMF Memories.
      User selectable memory groups and sections.
      Everything for one Memory on one line (row).
      A really nice progress bar.
      Click to change the active Memory in the Radio.

Read/Write Menu items.
      Pop-up menus and in-cell help choosing values.
      VFO settings.
      Click to change the active PM in the D700.
      Some items are best left for manual operation.

Real time Control of Radio
      Enter frequency and Mode in sheet.
      Click on a frequency to tune Radio.
      Click button to grab Radio Frequency.
      Use all Excel features i.e. Cut, Copy Paste, etc.

Click the respective links to download files.

>  For the Icom 706MkIIG
    Click Here for the 706 Features document.
    Click Here for the 706 Spreadsheet. 1.2 MB

 For 706MkIIG Split and Duplex instructions,  Click Here

>  For the Kenwood TM-D700
    Click Here for the TM-D700 Features document.
    Click Here for the TM-D700 Spreadsheet. 2.3 MB

 For the TM-D700 F902 Fuse failure cause and my fix,  Click Here

>  For the Kenwood TH-F6A
    Click Here for the TH-F6A Features document.
    Click Here for the TH-F6A Spreadsheet. 1.02 MB Minor fixes 2/24/2011

A complete Computer Control Protocol Reference for the TH-F6A   Click Here.  Includes a schematic for a serial interface level converter.                 Minor fixes 2/24/2011

>  For the Kenwood TS-2000
    Click Here for the TS-2000 Features document.
    Click Here for the TS-2000 Spreadsheet. 1.02 MB

> Tape Measure Beam Videos with sound
Tape measure beam Deploy Video.
Tape measure beam Stow Video.
There are stills of the construction technique on the Photos page.