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.
|