Making Frequency Lists and Charts

Making Frequency Lists and Charts
Here is the method we use to make RadioMaster Reports frequency lists and charts. The process is not simple, but it does provide quality results in various formats. Radio frequencies start as handwritten notes, gathered over many years from various sources, correspondence, communicating on the air, monitoring, and other methods. Periodically, these notes are added to lists in text files with…
©2014 RadioMaster Reports

The original source of this article is the RadioMaster Reports website.

Periodically, these are added to lists in text files with notes. Text files (*.txt) are then edited in Notepad++, and imported/copy/pasted into Excel and manually formatted (labels, columns, rows) for Chirp import compatibility. Chirp CSV files have a certain number of data fields on each line. The first line has the labels that define the data fields that follow in all the lines of the file. A CSV (Comma Separated Value) file is basically just a text file where each field or entry of the text or data has commas, line feeds, spaces, tabs, or other characters as delimiters. CSV files can be opened/read by spreadsheet or database programs and radio programming software. From Excel, CSV files (*.csv) are exported.

The test CSV files are imported into Chirp. Chirp is connected to various test radios, and these radios are programmed and checked manually (either on the air or into dummy loads). Any bugs found with the programming are fixed, and then updated in Chirp and the radios are re-programmed again with the de-bugged file, and this repeats again as many times as necessary until the programming works perfectly. The de-bugged CSV files are exported from Chirp. These CSV files are uploaded to the RadioMaster site and made available to the public for download.

A completed CSV file is then imported into Excel. The columns, rows, and data are edited, re-sorted, and titles are renamed for concise readability. Any columns that are not needed are deleted. The output is copy/pasted into a web html program and a content manager for web listing as a table on the site. The images are made by screen-capture of tables in a browser and using an image drawing program, which is manipulated and output to a file in *.PNG format. All these are uploaded to the site via a web content management program (wordpress) and either Dropbox or FTP.

We hope this description was helpful.

The original source of this article is RadioMaster Reports.

Disclaimer: Content provided in RadioMaster Reports is included for the sole purpose of educational information on a passive basis. This information may be useful to the public in the event of emergencies or disaster recovery, especially when normal techniques are not an available option. Users of this educational information are solely responsible for their actions.

©2014 RadioMaster Reports. All rights reserved.

4 responses to “Making Frequency Lists and Charts

  1. Have you folks ever heard of SECURE Phones. These are Spread Spectrum units that operate in the 902-928Mhz ISM Band which is shared with the Ham Radio Service. These units are unDFable, and unScannable, with up to .7 Watts of RF Output. The are available, used on eBay for $25US/Per… … Btpost/AL7AQ

    • Bruce, could you please give a little more info on the SECURE Phones? I haven’t had any luck searching Google or ebay using the info you provided. Thanks

  2. One thing never mentioned here is the reality of an EMP… you have a radio put away for that? I will bet not.

    • you will loose that bet because i know of many patriots and militia and preppers who use faraday boxes to store their backup electronics in.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s