Amateur Radio Control
My Excel Radio Memory Management spreadsheets are available here. These are Excel Workbooks that manage radio memories and do real-time control.
Videos of my tape measure beam are 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.
No DLLs to load, just the Workbook.
Requires a PC and Excel 97 through 2007.
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.
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.
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.
The TH-F6A Version can read and write Kenwood MCP format data files (.fx).
The 706 version has a slick way to quickly enter CTCSS frequencies into the Memories.
Minor color fixes were updated Mar 24 2009 Click the respective links to download files.
For 706MkIIG Split and Duplex instructions, Click Here
For the TM-D700 F902 Fuse failure cause and my fix, Click Here
A complete Computer Control Protocol Reference for the TH-F6A Click Here. It includes a schematic for a computer interface level converter.
Last updated 7/8/09