Actions

Difference between revisions of "Excel Copy/Paste Special to Software"

From The RadioReference Wiki

Line 55: Line 55:
 
=== Structuring Excel file for pasting into Win9x Software ===
 
=== Structuring Excel file for pasting into Win9x Software ===
 
# Screenshot of finished Excel after using all steps in Generic copy/Paste Special section above.  This file is ready for copy/paste into open Win9x dialog.  Note: PL/DPL cells in Excel file will need to be formatted as text with leading 0's typed in.
 
# Screenshot of finished Excel after using all steps in Generic copy/Paste Special section above.  This file is ready for copy/paste into open Win9x dialog.  Note: PL/DPL cells in Excel file will need to be formatted as text with leading 0's typed in.
# '''Win92''' '''a''') Open a new template or bank and set bank mode (MOT in this sample). Copy trunk frequencies first and click to 00 Alpha Tag in frequency area and select the Paste Icon.  '''b''') Copy conventional frequencies and click in any location after trunk freqs and select paste Icon.  PL/DPL settings will need to be manually set. '''c''')Copy ID's and tags from the Excel file and paste into talkgroup section.
+
====Win92====
# '''Win95/93''' '''a''') Open a new template or bank and set bank mode (MOT in this sample). Copy trunk frequencies first and click to 00 Alpha Tag in frequency area and select the Paste Icon. '''b''') Copy conventional frequencies and click in any location after trunk freqs and select Paste Icon.  PL/DPL settings will need to be manually set. '''c''')Copy ID's and tags from the Excel file and paste into talkgroup section.
+
# Open a new template or bank and set bank mode (MOT in this sample). Copy trunk frequencies first and click to 00 Alpha Tag in frequency area and select the Paste Icon.   
# '''Win96''' '''a''') Open a new template or bank and set bank mode (MOT in this sample). Copy complete frequency section from Excel file in step 1, click in cell 00 Alpha Tag and select the Paste Icon.  PL/DPL settings will also paste into Win96. '''b''')Copy ID's and tags from the Excel file and paste into talkgroup section.
+
# Copy conventional frequencies and click in any location after trunk freqs and select paste Icon.  PL/DPL settings will need to be manually set.  
# '''Win97''' '''a''') Open a new template or bank and set bank mode (MOT in this sample). Copy complete frequency section from Excel file in step 1, click in cell 00 Alpha Tag and select the Paste Icon.  PL/DPL settings will also paste into Win97. '''b''')Copy ID's and tags from the Excel file and paste into talkgroup section in Win97
+
# Copy ID's and tags from the Excel file and paste into talkgroup section.
 +
====Win93/95====
 +
# Open a new template or bank and set bank mode (MOT in this sample). Copy trunk frequencies first and click to 00 Alpha Tag in frequency area and select the Paste Icon.
 +
# Copy conventional frequencies and click in any location after trunk freqs and select Paste Icon.  PL/DPL settings will need to be manually set.  
 +
# Copy ID's and tags from the Excel file and paste into talkgroup section.
 +
====Win96====
 +
# Open a new template or bank and set bank mode (MOT in this sample). Copy complete frequency section from Excel file in step 1, click in cell 00 Alpha Tag and select the Paste Icon.  PL/DPL settings will also paste into Win96.
 +
# Copy ID's and tags from the Excel file and paste into talkgroup section.
 +
====Win97====
 +
# Open a new template or bank and set bank mode (MOT in this sample). Copy complete frequency section from Excel file in step 1, click in cell 00 Alpha Tag and select the Paste Icon.  PL/DPL settings will also paste into Win97.
 +
# Copy ID's and tags from the Excel file and paste into talkgroup section in Win97
 
<gallery>
 
<gallery>
 
Image:Excel_file_for_copy_to_win9x.gif|Step 1 Excel complete
 
Image:Excel_file_for_copy_to_win9x.gif|Step 1 Excel complete
Line 65: Line 75:
 
Image:Win96.gif|Step 4 Win96
 
Image:Win96.gif|Step 4 Win96
 
Image:Win97.gif|Step 5 Win97
 
Image:Win97.gif|Step 5 Win97
 +
</gallery>
 +
===Excel restructured for copy/paste into ScanCat Lite software===
 +
# Copy all frequencies and associated alpha tags and click in the first Frequency cell, then press Ctrl V. 
 +
# Copy ID's and associated tags and click in first cell under Group, then press Ctrl V. 
 +
# All other settings will need to be manually set as in screen shot.
 +
<gallery>
 +
Image:Excel_file_for_copy_to_ScanCat_lite_Software.gif|Step 1 Excel complete for ScanCat Lite
 +
Image:ScanCat_Lite_for_many_Scanners.gif|Step 1 Complete bank
 
</gallery>
 
</gallery>
 
[[Category:Software Applications]]
 
[[Category:Software Applications]]
 
[[Category:FAQ]]
 
[[Category:FAQ]]

Revision as of 23:32, 13 October 2007

Using Microsoft Excel Paste Special feature for building data to paste into Windows based Scanner Software. Open Office and other spread sheets may also have this type of operation.

Generic for all Windows based scanner programming software

These 8 steps are for copying data from either trunking or conventional dabebase pages and pasting into Excel for manipulation to ready for pasting into Software.

  1. Highlight, copy select freqs from database page.
  2. Click in Excel Cell A1 and select Paste Special.
  3. Click Text and Ok.
  4. Re-structure freqs vertically and format to number with 4 decimals. Note the asterisks (which indicate control channels) are still marked. Remove the asterisks prior to copy/paste to software. If programming an EDACS or LTR system, the frequencies must be kept in Logical Channel Number order as shown in the database. This is indicated by a small 2 digit number before the frequency. These numbers should be edited out as the software will handle this numbering.
  5. Highlight and copy section/agency of talkgroups.
  6. TG's after Paste Special to Excel. Delete unneeded column B. These are hex values for the talkgroups in column A. They are only used by professional radios, such as Motorolas.
  7. Highlight and copy selected sections from conventional page similar to step 5 screenshot and Paste Special into Excel.
  8. Excel unneeded columns deleted and restructured for copy to software. Note: Input, License, Type and Mode columns deleted. Freq column formatted to number with 4 dec and Descriptions shortened, then column is cut and inserted before tones. PL/DPL removed from tones and reformatted to number with 1 dec.

Saving Excel file to CSV format for importing to ScanControl Software

Note that this function is only available in the full version, not the lite version

  1. Saved Excel trunked system in CSV format for Import to Software.
  2. In ScanControl main page click on Import Data Files button.
  3. Navigate to and select CSV file then click Map CSV on right of dialog.
  4. Map according to needs. Note: this is a trunking system so should be Mapped accordingly. Conventional freqs. tags and tones will have Field Type options also. When this step is complete, you will be back at main SC dialog.
  5. Click Edit Banks button and make settings as in screenshot in Step 5.
  6. Tagging Scan List.

Structuring Excel file for pasting into ARC250D Software

ARC250D and likely other ARC software has a feature called Automatic Data Import (ADI) which enables one to import frequencies from any format and list them in the open software main page in vertical format eliminating the need for Paste Special in the generic section above for frequencies. All other data will need to be set by the user. Excel can receive the freqs from ADI as a 'Save to Clipboard' function, thus all data on the open software page can be prepaired in Excel and copied to the page.

  1. Structuring a bank for ARC250D software using Excel.
  2. Copy Cells A1 through K1 and down through last freq line then paste into open ARC bank page.
  3. Collect and Paste Special desired Talkgroup data as in steps 5 & 6 in Generic section above. After deleting unneeded columns, copy the ID's & Alpha tags and paste into open ARC250 Trunk Id List. Hint: If talkgroups are structured in Excel in groups of 10 one can paste up to 100 ID/w/tags in the open dialog.
  4. Use steps 7 & 8 in above generic section for collecting and sorting conventional data then set tones as indicated in screenshot 4 note.

Structuring Excel file for pasting into Win9x Software

  1. Screenshot of finished Excel after using all steps in Generic copy/Paste Special section above. This file is ready for copy/paste into open Win9x dialog. Note: PL/DPL cells in Excel file will need to be formatted as text with leading 0's typed in.

Win92

  1. Open a new template or bank and set bank mode (MOT in this sample). Copy trunk frequencies first and click to 00 Alpha Tag in frequency area and select the Paste Icon.
  2. Copy conventional frequencies and click in any location after trunk freqs and select paste Icon. PL/DPL settings will need to be manually set.
  3. Copy ID's and tags from the Excel file and paste into talkgroup section.

Win93/95

  1. Open a new template or bank and set bank mode (MOT in this sample). Copy trunk frequencies first and click to 00 Alpha Tag in frequency area and select the Paste Icon.
  2. Copy conventional frequencies and click in any location after trunk freqs and select Paste Icon. PL/DPL settings will need to be manually set.
  3. Copy ID's and tags from the Excel file and paste into talkgroup section.

Win96

  1. Open a new template or bank and set bank mode (MOT in this sample). Copy complete frequency section from Excel file in step 1, click in cell 00 Alpha Tag and select the Paste Icon. PL/DPL settings will also paste into Win96.
  2. Copy ID's and tags from the Excel file and paste into talkgroup section.

Win97

  1. Open a new template or bank and set bank mode (MOT in this sample). Copy complete frequency section from Excel file in step 1, click in cell 00 Alpha Tag and select the Paste Icon. PL/DPL settings will also paste into Win97.
  2. Copy ID's and tags from the Excel file and paste into talkgroup section in Win97

Excel restructured for copy/paste into ScanCat Lite software

  1. Copy all frequencies and associated alpha tags and click in the first Frequency cell, then press Ctrl V.
  2. Copy ID's and associated tags and click in first cell under Group, then press Ctrl V.
  3. All other settings will need to be manually set as in screen shot.