MI statewide - control channel freq list

Status
Not open for further replies.

joescat

Member
Joined
Dec 27, 2003
Messages
44
Reaction score
0
Location
Oakland Cty, Michigan
I'm looking for a way to extract just the primary and alternate control channel freqs from the list, to dump into ARC250. Any tips / suggestions how to do that?
 

coc

Member
Joined
Dec 19, 2002
Messages
6
Reaction score
0
Location
Michigan
Mich Control Channel List

You can export the list to excel sort it and make a list of only control chanels.
 

joescat

Member
Joined
Dec 27, 2003
Messages
44
Reaction score
0
Location
Oakland Cty, Michigan
Copied / pasted / edited, it works pretty much

That's pretty much what I ended up doing. I do quite a bit of work like that actually, I was hoping there was a more automated (less time consuming) way.

I just selected and copied / pasted all the freqs from the webpage, and dumped them into a text file (I like UltraEdit for stuff like this, as opposed to Excel).
I found that due to the number of duplicate frequencies (there would have been 286 control channels, won't fit into a single bank on a '296D, but sorting and filtering out dupes (one step in UltraEdit!), 77 remain. I just edited out the "*" characters after the city names, then recorded a quick macro to find the next "*", delete, select back 9 characters, cut, go to bottom of file, paste, go to home. Ran the macro 285 times (one was done already while recording the macro), and all control channel freqs are nicely moved together at the bottom of the file. Save that portion to a new file, sort/filter dupes, and dump it directly to the scanner via ARC250.
ARC250's EasyFill touches up the rest of the options, and it's done.

I haven't been watching very close (and don't usually scan the State's stuff anyway), how often do they change control channels? I notice in my other bank, optimized for my local area, many control channels had changed on me. Maybe that's a question for another thread.
 
Status
Not open for further replies.
Top