K9DCI TH-F6A CAT Excel spreadsheet.
The Excel workbook and macros accompanying this document are (c) 2008 Steve Noskowicz All
rights Reserved. They may be freely distributed and used as long as this note remains attached.
Features, notes and advanced capabilities. Version 6.0 Beta (called 5.E internally)
All Excel editing features plus:
Open and Save Kenwood .fx format files.
Change Menu items individually or all at once (Scan Resume, Group Link, Contrast, Bar Ant, etc.).
Change Functions individually or all at once (Lamp, Dual Listen, Power, Rx A/B, Balance, etc.).
Select which Memory group or groups to transfer to/from radio
Auto-Sort of Numbered Memories (0-399) by Number, Name, Frequency, or CTCSS frequency.
Up/Download VFOs Use sorting with caution.
Instruction summary "on-line".
Selectable Com port.(1-30)
All parameters for each Memory on a single line.
All Memories viewable in a spreadsheet list format.
Upload (read) and Download (write) all radio Memories including DTMF and VFOs.
Upload all / Download all/individual Radio Menus. Menu #9 not PC programmable.
Upload / Download part of numbered Memories (e.g. 10 through 35).
Upload / Download any single Memory type (INFO, Scan Limits, Call, DTMF, VFO, etc.).
Read and control radio Functions (Lamp, Dual, Power, Squelch, BAL, Rx A/B, etc.).
Tune radio in VFO mode with a click (Click cells, Page Up/Down, Up/Down arrows).
Capture the Radio Frequency and Mode into sheet with a click.
Tune to any Memory with a click.
Add a comment for each Memory.
When entering a frequency, remaining parameters fill with defaults that you may then change.
Auto Mode, Offset and Shift per Ham-band plans.
Many entries are checked for proper values and some auto-correct.
Modes can be abbreviated (F = FM, W = WFM, U = USB, Etc.) with auto-correct.
CTCSS frequencies can be entered without the decimal part (e.g. 107 Auto-Corrects to 107.2).
Buttons and Checkboxes can be actuated by holding the ALT key and typing the Underlined Letter.
Schematic of a home brew level converter included.
Requires a level converter for the TH-F6A. Schematic included.
Requires a PC and Excel 97 or later. Not Macintosh compatible. Sorry.
Serial port [or a USB to serial converter. Though it has not been tested on a USB yet]
Will run on Vista, though not specifically tested (a similar IC706 sheet ran with Excel 2003). The calls
to the system port routines are the only thing in question.
Pasting a series of receive frequencies (in kHz.) will have the defaults entered for you.
Not many auto-corrected entries are undoable. Most multi-cell changes are.
Some things to be aware of.
Notice the added "TH-F6A" menu at the top.
Unless you either Upload from the radio or Download to the radio, the sheet will not reflect the current
state of the Memories or other functions in the radio. This is not done automatically for you.
Use any Excel capability to manage frequencies (Copy/Paste/Formulas/Auto-Increment)
Auto Increment is nice for entering equally spaced frequencies.
If you Save the workbook under a new name (Save As...) a number of Menu and Function macros will run.
This is a issue with Excel itself. It is inconvenient, but not harmful. You can avoid this by changing the
name at the system level (in a desktop window). I recommend saving the original file and renaming a
All the parameters shown for a Memory are stored in the Radio - even though they may not be needed.
They auto-fill with defaults so you don't have to enter anything but frequency unless you want other values.
Use Enter to fill one row. You may use the arrow keys to move around when entering data except for one
case. There is a small problem I am working to resolve, caused by Excel, when entering a Shift direction
(+ - =) in the Memory sheet. Excel will think you are entering a formula if you use an arrow key to move
out of the cell (formulas start with +, -, or = ). Use the Enter key when entering a Shift and the selection
will then move to Offset.
Advanced user notes
Copy, Paste, Clear:
I wanted to be able to do a normal Copt/Paste from the Control sheet to the Memory sheet, but it must be
done with a reference formula. Type an Equal sign in a Memory Sheet Frequency cell, then click on the
Control sheet frequency. Copy this formula as desired – defaulst will fill-in.
When Copying and Pasting, it is recommended that you Paste ONLY Values in order to preserve the
formatting. Especially if you copy between the Control and Memory sheets. For Paste Values from the
keyboard, type and release ALT, then type E, S, V, Enter.
When Clearing data, Clear ONLY Contents. From the keyboard, type and release ALT, then type E, A, C.
If you change some formatting, you will notice that I re-format the Memory sheet each time it is opened.
This is to keep it in the same size window.
To aid Pasting many frequencies from other sources, I added some features I thought would help. When a
series of Rx Frequencies is cleared, the UnDo will replace the default values for Mode, Step, Offset, etc.,
requiring you to re-enter any special values. If you had special values in these cells, you must replace them
You can directly paste a list of frequencies from another document as long as they are in kHz.
You can indirectly Paste frequencies in MHz using formulas, like this:
1 – FIRST, Paste All the frequencies (in MHz.) into column Q
2 – Put this formula in ONE row of the Frequency column C: =Qx * 1000
= click on the Col Q freq * 1000 Defaults will fill out the row.
3 – Re-Enter the formula (the formula gets removed by the default routines)
4 – Copy this formula for all the frequencies. Defaults will fill out the rows.
5 – If desired, Select the formula cells, then do a Copy and immediately do a Paste Values.
Note: There is a difference between the two ways to copy the formula behave.
By pulling up or down on the lower right of the cell, only the first two entries will be changed from
formula into number.
By using Copy and Paste, all the formulas will be gone.
In future versions, I may add a feature to allow entering either in kHz. or MHz.
Use of Excel's UnDo may seem erratic. The self-correcting auto-entries are generally not UnDoable. This
is because Excel won't UnDo the effect of the macros. A significant amount of additional code would be
required to allow it.
Copying, Pasting, Clearing a block of cells (multi-column & multi-row) is usually UnDoable.
The TH-F6A has an unusual behavior in the Aircraft band when using 8.33 kHz spacing (Step).
Not all frequencies programmable from the keypad are programmable via computer. When
uploaded into the sheet, the Fine Step is enabled when downloaded again. As a consequence, I
am not sure I have programmed the Fine Step to automatically enable correctly. The Kenwood
MCP is no different.
Steps of 6.25 and 12.5 also operate oddly from the keyboard, but program as expected from the
Full detail is in the appendix of my Computer Protocol document (version 2.0 or later) located
where you found this and the spreadsheet file. Kenwood TH-F6A Computer Control Reference
It should not, but if the sheet should happen to stop "working", that is, Auto-Correcting, Tuning, etc.,
FIRST, PLEASE note what you were doing so you can tell me. Then, simply save the Excel Workbook,
completely Exit Excel, and then re-launch Excel. I should be able to fix this, if I can reproduce it.
While I did considerable testing and included code to handle errors, I am not able to test this code on all
versions of Excel, on all versions of operating system.
If Excel should happen to completely crash, there is no remedy. This has rarely happened, but it has
happened on two test systems. Unfortunately, there is no way for me to determine what caused it. It is well
beyond my ability. The Excel macros can indirectly cause an illegal Memory access. It appears due to
invisible junk, which creeps into the macro code because of editing while writing code. I took steps to
"cleanse the code" which has stopped this in the past, but different versions of Excel may act up. Saving
often when making important changes is a fact-of-life in this complex, modern computing.
Super Advanced Users:
The sort functions are provided to allow things such as the following:
Easier entry, using Excel's Auto-Fill, Auto-Increment or Copying capabilities, of things like
CTCSS Frequencies, which may be the same for a group of repeaters.
Arranging Memories in the sheet, or in the radio, by Name, Frequency or CTCSS Freq.
Exercise caution if you sort Memories then make changes, particularly if you Renumber them,
make additions or deletions, then UnDo the sort. The location of specific Memories may not be
what you wanted. To allow finding a specific Memory after a sort, special code was included
which keeps the same cell selected before and after a sort.
Excel's Auto Increment:
This allows easily entering many frequencies that are evenly spaced. When the names have a
trailing number, the Name/number is also incremented. Example: By entering only the first two
Names and Frequencies, using Excel's Auto-Increment Copy, all TV aural carriers from Channel
15 up can be entered in the sheet by selection the first two and dragging the selection down the
Ultra Advanced Memory feature:
The Memory number in column 1 is the number that determines the radio Memory that is accessed
for read or write. You can manually change these numbers to move Memories around or copy
Memories between radios yet easily change the Memory numbers between radios. While this can
be done with Excel Copy and Paste, the following can also be done as follows:
1 – Read the desired Memories into the sheet.
2 – Change the numbers in Column 1 to the locations in the Radio TO WHICH you want to Write
3 – In the Transfer Dialog Box, select the ORIGINAL Memory numbers. These numbers
determine which spreadsheet rows are transferred.
4 – Write to the Radio.
Copy Memories 10-20 from Radio A to Memories 150-160 in Radio B.
1 – Upload Memories 10-20 from Radio A.
2 – Change the Column 1 numbers from 10-20 to 150-160 (Use Excel's Auto-Increment).
3 – Click the Transfer button and select Memories 10-20 (the original rows).
4 – Download to the Radio B.
Remember to either reset the column 1 numbers or click the Re-number button
Super-Duper Advanced concepts
The Com port is not hogged by the workbook. The port is free except when sending commands and
receiving the radio's response. The port is free when the response is received. This produces idle time on
the port which can be used by other programs, as long as the other program does not hog the port.
The only apparent exception to this is when "Following" the radio on the Control sheet. During
following, the sheet is continually taking data from the radio; thus, the port is occupied.
With two (or more) workbooks open and two (or more) radios each connected to its own COM port, each
workbook can control a different radio.
With formulas linking values on the two sheets you may have two radios tune to the same frequency.
This is done with a simple equals formula.
Another is to have them a constant difference frequency.
A third is a Doppler correction for a transmit radio based on the receive radio. I am unable to test this since
I have only one com port.
If you do not know how to create workbook-linking formulas, contact me.