Actions

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

From The RadioReference Wiki

m
Line 4: Line 4:
  
  
−
These steps are copying from trunking pages.
+
These steps are copying from trunking first then conventional pages.
−
# Highlight, copy select freqs from database page
+
# Highlight, copy select freqs from database page.
 
# Click in Excel Cell A1 and select Paste Special.
 
# Click in Excel Cell A1 and select Paste Special.
 
# Click Text and Ok.   
 
# Click Text and Ok.   
−
# Re structure freqs vertically and format to number with 4 decimals. Note the controls are still marked.  These will need to be unmarked prior to copy/paste to software.  EDACS or LTR freqs will need to be spaced in cells as listed in the DB LCN order.
+
# Re structure freqs vertically and format to number with 4 decimals. Note the controls are still marked.  Unmark these prior to copy/paste to software.  EDACS or LTR freqs will need to be spaced in cells as listed in the DB LCN order.
 +
# Highlight and copy section/agency of talkgroups.
 +
# TG's after Paste Special to Excel.
 +
# Highlight, copy selected sections from conventional page as in Screenshot 5 and Paste Special into Excel.
 +
# Excel 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 and inserted before tones. PL removed from tones and reformatted to number with 1 dec. 
 
<gallery>
 
<gallery>
−
Image:1_generic_trunk_freq.gif|Select and copy freqs from web page Screenshot
+
Image:1_generic_trunk_freq.gif|Step 1
−
Image:2_select_Paste_Special.gif|Using '''Paste Special''' in Excel Screenshot
+
Image:2_select_Paste_Special.gif|Step 2
−
Image:3_paste_special_dialog.gif|Paste Special dialog Screenshot
+
Image:3_paste_special_dialog.gif|Step 3
−
Image:4_after_relisting_freqs_vert_and_format_to_number.gif|After resorting and setting format Screenshot
+
Image:4_after_relisting_freqs_vert_and_format_to_number.gif|Step 4  
−
</gallery>
+
Image:5_Generic_trunk_TG's.gif|Step 5
−
These following 4 steps are for talkgroup ID's and tags. Use Excel for editing prior to copy/paste into software
+
Image:6_TG_paste_special_in_Excel.gif|Step 6
−
# Select and highlight a section of Talkgroups from same data page with frequency listings, right click and select Copy.
+
Image:7_Paste_special_of_conventional_data.gif|Step 7
−
# In Excel, right click in cell A1 and select Paste Special.  In new popup dialog, select Text then click OK. Delete unneeded columns in the spreadsheet
+
Image:8_Restructured_for_copy_paste_to_software.gif|Step 8
−
# Highlight both columns of data then right click and select copy.
 
−
# In open Trunk ID list in software, right click in the scan list location you wish to store this group and select paste.
 
−
<gallery> 
 
−
Image:ARC250D6.gif|Highlight and copy talkgroup Screenshot
 
−
Image:ARC250D7.gif|Use Paste Special and Text in new spreadsheet Screenshot
 
−
Image:ARC250D8.gif|Delete unneeded columns Screenshot
 
−
Image:ARC250D9.gif|Copy finished excel columns to ARC Trunk ID's Screenshot
 
−
</gallery>
 
−
This completes this bank for trunking.  The bank tags and scanlist tags will need to be set within the software sections for that purpose.
 
−
 
 
−
These steps are for copy/paste of conventional frequencies and tags from database page.
 
−
# Highlight right click and copy group of listings from database page.
 
−
# Right click in cell A1 of Excel then select Paste Special then Text in popup dialog and click ok.
 
−
# Delete unneeded columns, format numbered columns and restructure Alpha tag column. 
 
−
# Copy columns A and B and paste into software.  Copy Column C and paste into PL column in software.   
 
−
<gallery>
 
−
Image:Conventional freq copy.gif|copy from web page Screenshot
 
−
Image:After Paste Special.gif|unreformated Excel Screenshot
 
−
Image:Ready to copy and paste.gif|reformatted for copy to software Screenshot
 
 
</gallery>
 
</gallery>
  
−
[[Category:Software Applications]]
+
=== Pasting collected data into Win9x Software ===
−
[[Category:FAQ]]
 

Revision as of 20:14, 12 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 steps are copying from trunking first then conventional pages.

  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 controls are still marked. Unmark these prior to copy/paste to software. EDACS or LTR freqs will need to be spaced in cells as listed in the DB LCN order.
  5. Highlight and copy section/agency of talkgroups.
  6. TG's after Paste Special to Excel.
  7. Highlight, copy selected sections from conventional page as in Screenshot 5 and Paste Special into Excel.
  8. Excel 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 and inserted before tones. PL removed from tones and reformatted to number with 1 dec.

  • Step 1

  • Step 2

  • Step 3

  • Step 4

  • Step 5

  • Step 6

  • Step 7

  • Step 8

Pasting collected data into Win9x Software

Retrieved from "https://wiki.radioreference.com/index.php?title=Excel_Copy/Paste_Special_to_Software&oldid=18010"