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
yaesu_adms_11 [2022/12/03 17:20]
kd6kpc [Procedure with File Editing]
yaesu_adms_11 [2022/12/03 17:21] (current)
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
-  * It is possible to edit the file with Excel. Column F is the potential issueThis 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.+  * 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.   * 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.  
  
-There is an alternative method for editing in Excel. After the file downloads:  +There is an alternative method for editing in Excel. After the file downloads: 
-  * Change the extension to .txt.  + 
-  * Using Excel, open the program. +  * It is possible to edit the file with Excel. Column F is the potential issueThis 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.
-  * 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.   * 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: 2022/12/03 17:21 by kd6kpc