• To anyone looking to acquire commercial radio programming software:

    Please do not make requests for copies of radio programming software which is sold (or was sold) by the manufacturer for any monetary value. All requests will be deleted and a forum infraction issued. Making a request such as this is attempting to engage in software piracy and this forum cannot be involved or associated with this activity. The same goes for any private transaction via Private Message. Even if you attempt to engage in this activity in PM's we will still enforce the forum rules. Your PM's are not private and the administration has the right to read them if there's a hint to criminal activity.

    If you are having trouble legally obtaining software please state so. We do not want any hurt feelings when your vague post is mistaken for a free request. It is YOUR responsibility to properly word your request.

    To obtain Motorola software see the Sticky in the Motorola forum.

    The various other vendors often permit their dealers to sell the software online (i.e., Kenwood). Please use Google or some other search engine to find a dealer that sells the software. Typically each series or individual radio requires its own software package. Often the Kenwood software is less than $100 so don't be a cheapskate; just purchase it.

    For M/A Com/Harris/GE, etc: there are two software packages that program all current and past radios. One package is for conventional programming and the other for trunked programming. The trunked package is in upwards of $2,500. The conventional package is more reasonable though is still several hundred dollars. The benefit is you do not need multiple versions for each radio (unlike Motorola).

    This is a large and very visible forum. We cannot jeopardize the ability to provide the RadioReference services by allowing this activity to occur. Please respect this.

CSV import, how to convert spreadsheet A column?

Status
Not open for further replies.

Anderegg

Enter text in this field
Premium Subscriber
Joined
Mar 7, 2010
Messages
2,678
Location
San Diego
I am trying to import RRdb for a system that is 3600 baud, into my talkgroup list for my counties new 9600 system. I can work the import, but I would have to manually convert a thousand talkgroups with a calculator and Windows Notepad. Anyone know how to apply a divide by 16 to every talkgroup decimal in the A column of a Google Spreadsheets? Would like to have my G5's programmed prior to talkgroups being moved onto the new system next month...RRdb always lags a month behind real world changes.

Paul
 

GTR8000

NY/NJ Database Guy
Database Admin
Joined
Oct 4, 2007
Messages
15,949
Location
BEE00
Put =A1/16 into the first cell of an empty column, then drag the formula down the entire column. You can then CTRL+C copy that new column of TGID's and use CTRL+SHIFT+V to paste the values back into column A. Don't use CTRL+V as you'll paste the formulas back into column A, which you don't want to do.
 

Anderegg

Enter text in this field
Premium Subscriber
Joined
Mar 7, 2010
Messages
2,678
Location
San Diego
Thank you, it seems to have worked! :-D

I've never used Excel or a spreadsheet before.

Paul
 

Attachments

  • Screen Shot 2019-08-14 at 3.41.07 PM.png
    Screen Shot 2019-08-14 at 3.41.07 PM.png
    295.7 KB · Views: 39

kruser

Well Known Member
Premium Subscriber
Joined
Nov 25, 2007
Messages
5,056
Location
W St Louis Cnty, MO
Thank you, it seems to have worked! :-D

I've never used Excel or a spreadsheet before.

Paul

Yep, spreadsheets can be intimidating! They sure are nice when they work the way you want though.
Glad you got it working and also glad you asked this as I was having the same problem.
 

bob550

Member
Premium Subscriber
Joined
Apr 5, 2005
Messages
2,075
Location
Albany County, NY
I've never used Excel or a spreadsheet before.
You're missing a big slice of life! :) I've used Excel for many years, extensively at work but also at home. It can be an incredible workhorse if you know how to make the best use of it, and is very useful for the manipulation of frequency data in our hobby.
 

Anderegg

Enter text in this field
Premium Subscriber
Joined
Mar 7, 2010
Messages
2,678
Location
San Diego
Yes, I am now using it to convert my Uniden XT Freescan talkgroups to 9600 as well. :-D


Paul

You're missing a big slice of life! :) I've used Excel for many years, extensively at work but also at home. It can be an incredible workhorse if you know how to make the best use of it, and is very useful for the manipulation of frequency data in our hobby.
 
Status
Not open for further replies.
Top