Directions to use this spreadsheet
For this workbook to function properly it needs to be opened in Excel 2010 or newer.
Do not change any data in the red colored tab worksheets. These are all auto filled.
First change your DISPLAY, RX FREQ, RX CTCSS, TX FREQ, TX CTCSS, and NOTES
in the "All Data" tab labeled in green
Then go to your Mobile groups 1-3 and Portable groups 1-26 and simply use the drop down
menu in the display column to select the appropriate channel.  You may also type the name in
here as long as you type it exactly as listed on the All Data sheet. All the data to the right will
be pulled from the "All Data" tab and automatically fill in. The red tabs will then auto adjust as well.
You may still use this workbook to satisfy your specific frequencies even if you do not use the
same frequencies I do. Simply paste your channel information over mine in the "All Data" work
sheet or INSERT your channel information. If you decide to insert new information just make
sure to insert it prior to row 339.  Inserting them prior to this row will cause the formulas to
continue to work.