Hi Folks-
I am in the process of programing an XTS3000 and I'm wondering if there is a better way to do this. I saw in the CPS that you can import a spreadsheet. So is there a way I could create a spreadsheet and then load it into the CPS for programming?
Thanks,
Josh
Programming Method?
Moderator: Queue Moderator
-
- Posts: 177
- Joined: Tue Sep 08, 2009 6:47 pm
- What radios do you own?: /\/\ AS, APX7000
Programming Method?
Joshua
W1DPT
Raymond, NH
W1DPT
Raymond, NH
- Motoboy
- Posts: 102
- Joined: Wed Nov 11, 2009 1:58 pm
- What radios do you own?: HT1250 I saved from the dump
Re: Programming Method?
You can create a spreadsheet for use in specific windows, like the control channels or the preferred sites, but you can't create a spreadsheet with the whole codeplug in it and copy it in.
Hey, at least you can drag and drop! They are making progress!!!
Hey, at least you can drag and drop! They are making progress!!!

"I don't have a driver's license, either, and that never got me in trouble!" ~Customer
-
- New User
- Posts: 43
- Joined: Fri Jan 16, 2009 9:50 am
Re: Programming Method?
thats interesting i didnt know you could copy from a spreadsheet, ill have to look into it more. definitly progress out of the 1980's and into the 90's (sarcastic)
im guessing the SSheet would have to have a bunch of different TABS so you dont get data confused on the same sheet.
Id see that import working more for a list of conventional freqs then trunking.
im guessing the SSheet would have to have a bunch of different TABS so you dont get data confused on the same sheet.
Id see that import working more for a list of conventional freqs then trunking.
Motoboy wrote:You can create a spreadsheet for use in specific windows, like the control channels or the preferred sites, but you can't create a spreadsheet with the whole codeplug in it and copy it in.
Hey, at least you can drag and drop! They are making progress!!!
- Motoboy
- Posts: 102
- Joined: Wed Nov 11, 2009 1:58 pm
- What radios do you own?: HT1250 I saved from the dump
Re: Programming Method?
Let me reiterate that you can copy and paste data from a single spreadsheet into the programming software, and let the data "auto-fill".
I use this when adding in control channels. I have a list of control channels for a particular system saved into an Excel spreadsheet. When creating a codeplug, I have to go in and right click and select "Add at End" in the control channels tab until I have the same number of lines, in this case 128. Then I can copy and paste the data from the spreadsheet into CPS. You can't open a spreadsheet in CPS, you need Excel or OpenOffice Calc for that. You need to format CPS to accept your data. If I put in 100 lines in CPS instead of 128, then copy in the data, I will end up with only 100 of my control channels. The spreadsheet simply serves as a medium for the data to save lots and lots of typing.
I've never tried it with conventional channels.
I use this when adding in control channels. I have a list of control channels for a particular system saved into an Excel spreadsheet. When creating a codeplug, I have to go in and right click and select "Add at End" in the control channels tab until I have the same number of lines, in this case 128. Then I can copy and paste the data from the spreadsheet into CPS. You can't open a spreadsheet in CPS, you need Excel or OpenOffice Calc for that. You need to format CPS to accept your data. If I put in 100 lines in CPS instead of 128, then copy in the data, I will end up with only 100 of my control channels. The spreadsheet simply serves as a medium for the data to save lots and lots of typing.
I've never tried it with conventional channels.
"I don't have a driver's license, either, and that never got me in trouble!" ~Customer