User Tools

Site Tools


yaesu_adms_11

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
yaesu_adms_11 [2022/12/03 17:08]
kd6kpc [Example Procedure with Editing]
yaesu_adms_11 [2022/12/03 17:21]
kd6kpc [Procedure with File Editing]
Line 138: Line 138:
  
   * Complete a search on RepeaterBook and export the data. If Microsoft Excel is installed on your computer, the file may automatically open with Excel   * Complete a search on RepeaterBook and export the data. If Microsoft Excel is installed on your computer, the file may automatically open with Excel
 +  * Unordered List ItemChange the extension to .txt. 
 +  * Using Excel, open the program.
 +  * Using the Text Import Wizard, select Comma as the delimiter and the column with "+RPT" and "-RPT" as a Text data format.
 +  * You can renumber Column A as desired but rows 1 - 900 MUST be present.
 +  * Make sure there is a "0" in column BB of any newly added rows.
 +  * Save the file as a .CSV.  
 +
 +There is an alternative method for editing in Excel. After the file downloads:
 +
   * It is possible to edit the file with Excel. Column F is the potential issue. This is the repeater Offset Direction field with "-RPT", "+RPT", "-/+", and "OFF" as possible values. Any field with a leading operator such as "-" and "+" will be interpreted by Excel as a faulty equation and will display "#NAME?". If the file is saved while "#NAME?" is displayed, the original offset value will be overwritten with "#NAME?" and cause the file to error when imported into the programming software. ALL of column F must be manually adjusted before saving the file.   * It is possible to edit the file with Excel. Column F is the potential issue. This is the repeater Offset Direction field with "-RPT", "+RPT", "-/+", and "OFF" as possible values. Any field with a leading operator such as "-" and "+" will be interpreted by Excel as a faulty equation and will display "#NAME?". If the file is saved while "#NAME?" is displayed, the original offset value will be overwritten with "#NAME?" and cause the file to error when imported into the programming software. ALL of column F must be manually adjusted before saving the file.
   * You can renumber Column A as desired but rows 1 - 900 MUST be present.   * You can renumber Column A as desired but rows 1 - 900 MUST be present.
   * Make sure there is a "0" in column BB of any newly added rows.   * Make sure there is a "0" in column BB of any newly added rows.
   * Save the file as a .CSV.   * Save the file as a .CSV.
 +  
 +  
 ===== Firmware ===== ===== Firmware =====
  
yaesu_adms_11.txt · Last modified: 2023/04/26 10:41 by kd6kpc