New or updated entries indicated with or . Labels expire in 30-60 days.
And we say…
The DMR codeplug 1 is the "magic" that brings the radio alive. The codeplug contains three elements: contacts, channels and zones.
The Brandmeister servers on the internet have connections to DMR repeaters and hotspots around the world. A list of the connections—talkgroups can be loaded into a spreadsheet found in office suite 2 packages. We are going to choose the talkgroups wanted for inclusion in the codeplug.
Following are three portions of additional spreadsheet tabs. Locking rows and columns allows moving around a sheet while showing the labels.
Columns A, B and C are the Brandmeister talkgroup name, the talkgroup number and an abbreviated (I labeled it "Ch_Name") name. The shortened names 3 are so that all (or most) of the name fits on the radio display without (or minimal) scrolling.
Starting in column E, I created the various wide-area and regional, et al, zones names. Note, at the page bottom, there is a formula for each column total. Also note that I sort the talkgroups into talkgroup number order for entry into the codeplug.
This view is a section of the sheet sorting out the DMR repeaters and the talkgroups available on each repeater.
Note the short abbreviation for the screen display to identify the repeater. Column AP contains the ~15 common talkgroups.
This view is a section of the sheet for the weather frequencies, the DMR and simplex frequencies and the analog FM repeaters.
The three added "VFO" columns reminds me to enter the data into the proper VFO—the MD-UV380 is UHF/VHF—in the CPS (Customer Programming Software).
The construction of a codeplug can be daunting, but I encourage you to persist in putting yours together. Do use the resources on this website. The weekly Tuesday evening technical Colorado HD Net discusses codeplugs, hotspots and all things digital about DMR, AllStar, D-Star, and P-25. Part 2 of the net is a question-and-answer opportunity. Part 3 is a discussion about a single topic. The net prologue tells all. Additionally, knowledgable members can be found on the talkgroup throughout the day and evening throughout the week. And there is an active Telegram group; search for "Colorado Digital Multiproticol" and join it.
Is it necessary to use a spreadsheet to organize a codeplug? No. Does my choice of arranging the codeplug meet your needs? Maybe, but you no doubt will find a methodology that suits your needs. Play with your ideas and see what works for you. I find it easier to play with a spreadsheet's rows and columns than with pencil and paper. Perhaps a combination may work for you. In the reading I do, I take notes using my Evernote account, and pull them together into a hopefully cohesive document. I hope this helps.
Questions or comments? Email is at the bottom of this webpage.
1 KE0FHS explains assembly of his codeplug here.
2 I use Google Sheets on a Samsung Galaxy tablet, but any spreadsheet of your choosing will work..
3 The few characters available on a DMR radio display doesn't lend itself to scrolling long Brandmeister names. Thinking back to my early days of shortwave listening and the organization of the World Radio TV Handbook developed in the 1950s and continuing today, I chose to prepend a nominal two-letter abbreviation to the shortened talkgroup name where appropriate. Some examples:
wa—wa for wide area—waWW (for World Wide), waAsME (for Asia/Middle East), waEu, waOc (for Oceania)…
us_r—r for region—us_rMidW, us_rNoCO, usrMidAtl…
gb—for Great Britain—gbIre Chat, gbMidlands…