Spreadsheet: 130314d1322179984-vlookup-help-example-workbook
Sheet: CMTS Service Group ID Lookup

 |  |  |  |  |  |  |  |  | Instructions: In the CMTS Selection field click the drop down and choose the CMTS you wish to search for information on. In the Service Group # [NAME] field enter in the service group number identified on the cable line card description in the CMTS in order to pull the specific information for that CMTS/Service Group.
 |  |  |  |  | CMTS Selection
 |  |  |  |  | NESTCMTK01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cornerstone Data Last Updated: 11/24/2011
 |  |  |  |  | Service Group # [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] Last Updated: 11/24/2011
 | Las Vegas Node Combining Plan Information |  |  |  | 66 |  |  |  |  |  |  |  |  |  |  | [NAME] Last Updated: 11/24/2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 2.0
 | Node # |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | DHCP Server IP
 | [NAME] |  |  |  | 1234 Any Street |  |  |  |  |  | Not a Split Node |  |  |  |  |  | 172.28.1.200
 | Primary Locator (Slice ID) |  |  |  | MTC / STC |  |  |  | Headend |  |  |  | Service Group ID |  |  |  | Modulation Scheme
 | 19 |  |  |  | Northeast |  |  |  | 91 |  |  |  | 66 |  |  |  | 64 QAM
 | GEO & Sec Loc |  |  |  | CMTS |  |  |  | CMTS Card Information |  |  |  | CMTS IP Address |  |  |  | Channel Width
 | NE - NK01 |  |  |  | NESTCMTK01 |  |  |  | C6/0/9 Upstream0 |  |  |  | 172.28.2.45 |  |  |  | 3.2 MHz
 |  |  |  |  |  |  |  |  | C6/0/9 Upstream1
 |  |  |  |  |  |  |  |  | C6/0/9 Upstream2
 |  |  |  |  |  |  |  |  | C6/0/9 Upstream3
 | RF Gateway Information
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | NESTRFGC01
 | Slot |  |  |  | RF Gateway IP Address |  |  |  | [NAME] |  |  |  | Service Type |  |  |  | Network Element
 | 6/0 |  |  |  | 172.28.20.13 |  |  |  | NESTRFGC01 |  |  |  | DOCSIS |  |  |  | No Network Element
 | Modulation Scheme |  |  |  | Spa Interface ID #1 |  |  |  | Spa Interface ID #2 |  |  |  | Spa Interface ID #3 |  |  |  | Spa Interface ID #4
 | 256 QAM |  |  |  | Modular-Cable6/1/1:10 |  |  |  | Modular-Cable6/1/1:11 |  |  |  | Modular-Cable6/1/1:12 |  |  |  | Modular-Cable6/1/1:13
 | Channel Width |  |  |  | QAM Frequency #1 |  |  |  | QAM Frequency #2 |  |  |  | QAM Frequency #3 |  |  |  | QAM Frequency #4
 | 6 MHz |  |  |  | 855 MHz |  |  |  | 843 MHz |  |  |  | 849 MHz |  |  |  | 861 MHz
 | North DNCS |  | HE |  | Non DNCS/DAC Fed |  |  |  | HE
 | Bell |  | P2 |  | Wickenburg |  |  |  | C2
 | Fowler / Verrado / Tartesso |  | P4 |  | Gila Bend |  |  |  | [NAME]
 | McDowell |  | P5
 | [NAME] |  | P6 |  | South DNCS |  |  |  | HE
 | Peoria / Festival Ranch |  | P7 |  | Tempe / Chandler |  |  |  | A1 / P1
 |  |  |  |  | E. Mesa |  |  |  | P3
 | Moto/Cisco SA |  | HE |  | Queen Creek / Pinal |  |  |  | C1
 | Las Vegas |  | 91 |  | S. Scottsdale |  |  |  | P8
 |  |  |  |  | Casa Grande |  |  |  | S1
 |  |  |  |  | Tucson / Green Valley / Vail / Corona De Tucson |  |  |  | T1
 |  |  | Cochise |  | Sierra Vista / Benson /  Ft Huachuca |  |  |  | 12
 |  |  |  |  | Motorola DAC |  |  |  | HE
 |  |  |  |  | Douglas / Pirtlesville |  |  |  | T2
 |  |  |  |  | Tombstone / Whetstone |  |  |  | T3
 |  |  |  |  | Patagonia |  |  |  | T4
 |  |  |  |  | [NAME] Sites |  |  |  | 12