Radio List

Status
Not open for further replies.

SCPD

QRT
Joined
Feb 24, 2001
Messages
0
Reaction score
112
Location
Virginia
Hi All,

What do we all do to keep track of our channels?
I have an excel spreadsheet with all my vhf / uhf channels in it but am looking for something I can add notes to and get reports from based on things like:
All marine channels
All channels for TFS

ETC

Anybody got any ideas?

Paul
 

ampulman

Member
Joined
Aug 18, 2006
Messages
915
Reaction score
2
Location
South Jersey
tanger32au said:
Hi All,

What do we all do to keep track of our channels?
I have an excel spreadsheet with all my vhf / uhf channels in it but am looking for something I can add notes to and get reports from based on things like:
All marine channels
All channels for TFS

ETC

Anybody got any ideas?

Paul

Paul:

You could use a database program. It would allow you to enter data (as many different fields as you would care to define) and search on any combination of fields. Depending on the power of the program (high-level vs. freeware), you could also enter comments in free form limited only by your available memory.

I was thinking about putting together a spreadsheet listing all of my systems/groups/[talk groups/frequencies], but as an Access user, you've gotten me thinking. A database offers unlimited possibilities and is much easier to maintain. I always seem to be jotting down notes about found frequencies and other bits of data which seem to get lost. Problem solved.

I had put together a more-detailed response to your question, but unfortunately, it became lost.

If you're thinking of going this route and have any questions, feel free to PM me.

AM
 

gmclam

Member
Premium Subscriber
Joined
Sep 15, 2006
Messages
6,500
Reaction score
677
Location
Fair Oaks, CA
I've been doing this since long before PCs, DOS, etc. Once PCs came along I entered my information into an ASCII file. That's what I still use to this day. For someone just starting out, Excel seems like a good place to store stuff. The other place would be the software you use to program your scanner. I keep a single ASCII file for "everything" and then separate files for what is programmed into each scanner (per area profile).
 

SCPD

QRT
Joined
Feb 24, 2001
Messages
0
Reaction score
112
Location
Virginia
Thanks for all the feedback, I have just made a start on a Access Database and am just working out what I actully want stored in it.
 

kingpin

Trailer Park Supervisor
Joined
Mar 2, 2004
Messages
430
Reaction score
35
Location
Seattle, WA
I use excel for my stuff. I have one Master work book with "pages" inside for various agencies to keep the information overload on one page to a minimum. Easy to transport just the one file instead of many sheets. I keep it with me on a thumbdrive.
 

maddogdecker

Member
Premium Subscriber
Joined
Apr 12, 2005
Messages
317
Reaction score
1
Location
Dekalb County, IN
I'm the same way. I have a workbook then 9 sheets in that workbook. The reason for 9 sheets is so I have one sheet for each bank. It works really well for me.
 

captmfa7112

Member
Premium Subscriber
Joined
Jun 19, 2005
Messages
107
Reaction score
1
Location
Staten Island, NYC
maddogdecker said:
I'm the same way. I have a workbook then 9 sheets in that workbook. The reason for 9 sheets is so I have one sheet for each bank. It works really well for me.

I do the same thing, works great for me.
 

gcgrotz

Member
Joined
Feb 21, 2006
Messages
2,092
Reaction score
1
Location
Savannah, GA
I've used excel for years, before that I used Lotus. I have a master list with tabs for different services/localities. If I take a trip somewhere and make a new bank for the scanner I put it in the spreadsheet so I'll have it if I go back.
 
Joined
Apr 1, 2005
Messages
249
Reaction score
2
Location
NE Missouri
I use a spreadsheet (open office). I keep several different files. I have one master file for everything. I then have files that are separated by interest, public safety, business, marine, rail etc. My military air stuff is also kept in a master list but I also have separate lists for SATCOM, different modes and the different bands and such.

I have lists done for each of my radios too detailing their memories and search bank contents. This is especially helpful as many of my radios do not have computer control. I print out all the channel and search bank data, place it in plastic sheet protectors and assemble them in 3 ring view binders. I customize these for each radio. The “view” binders have clear pockets on the outside and spine which allow you to create a custom spine and covers for them. It is nice to be able to look over and see a freq on the radio and quickly grab a binder on a shelf, flip to a page and ID a freq. It is faster than booting up the computer and typing it into the search box. Even if it's already up it's even faster than doing the series of mouse clicks and opening up the file and searching for the freq in the file. Sometimes the old ways work.

By the way, the view binder thing works good for manuals too. Most manuals come on PDF now. Many scanners and receivers are getting to be awfully complex and you're constantly having to refer to the manual and they can get pretty dog eared. Some of those manuals can get kind of expensive to replace. I print out the PDF, place the sheets in plastic sheet protectors and assemble the whole works in a view binder. The cover usually prints off and the whole thing looks pretty sharp when you're done and it can be identified on your shelf pretty easily. It protects your expensive paper version and is nicer to work with as you can mark the chapters with tabs, make the print larger, highlight sections and customize it as you like.
 

brian

DB Administrator
Database Admin
Joined
Dec 10, 2000
Messages
2,168
Reaction score
498
Location
South Carolina
If you want to be serious about it, learn to use a database package like Access or FileMaker Pro.

I used excel sheets for a year or so, tried to keep separate lists for each county and state, then a list for multiple configurations for multiple radios. It just got too cumbersome.

I've been working with an access database for more than 3 years now. The learning curve was steep but worth it. I have a table for frequencies, a table for talkgroup, a table for trunked systems, and some others all linked together. Once you get handy with writing queries, your options are limitless. It's still not elegant by any means, but functional for me. Maybe one day I'll take the time to learn VB.

I now build radio configurations from "modular" bank sets, both frequencies and talkgroups. It makes creating multiple configurations for multiple radios a snap. I can then cut and paste (not directly) into scanner programming software (a la Starrsoft) and program in a flash.

PM me if you want more details.

Brian
 

SCPD

QRT
Joined
Feb 24, 2001
Messages
0
Reaction score
112
Location
Virginia
Thanks for all the advice.
I had the day off work today and have put together a quick and dirty Access database for my own personal use.
I have put a copy on my website and will update it as I get more ideas for it.

Please check it out and send me an email with any feedback, my email address is on my website.

http://www.mywebsfree.com/tanger32au/PaulsRD.mdb
 

hotdjdave

K9DJW - Senior Member
Database Admin
Joined
May 10, 2005
Messages
1,725
Reaction score
14
Location
The Valley (SFV), Los Angeles, CA
Last edited:
Status
Not open for further replies.
Top