Spreadsheet: 96256d1295650569-index-match-vlookup-or-offset-testcircuit
Sheet: Database

 | [NAME] | NU% | Wes% | DS1-NU | DS1-WES | DS3-NU | DS3-WES | 56K-NU | [NAME] | 64K-NU | 64K-WES | VG-NU | VG-WES |  | Service Type | RB - 9                Channel Termination   (CT) | RB - 9       Ch. Mileage       Termination              (CMT) | RB - 9        Ch. Mileage Facility      (CMF) | RB - 7                Channel Termination   (CT) | RB - 7       Ch. Mileage       Termination              (CMT) | RB - 7        Ch. Mileage Facility      (CMF) | DS1               Channel Term         RB-7                Per cust designated premise | DS1         Channel Mileage Termination  RB-7 | DS1    Channel Mileage Facilty                    RB-7                            Per Mile | Date of Rates as of July 1 | Service Type | NC-NCI Code | Service Type                               on MACC form | [NAME] | [NAME] to |  | [NAME]
Muxed (NU) T3 Transport System | 0 | 0 | 0 | 342.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New Ulm to Belview | 48 | 0.06 | 0.18 | 532.2024 | 137.9808 | 4500.904 | 1202.256 | 216.0836 | 39.48480000000001 | 216.0836 | 39.48480000000001 | 176.59 | 29.376 |  | DS1-NU | 342.75 | 121.83 | 23.48 | 233.16 | 82.88 | 15.97 | 233.16 | 82.88 | 15.97 | 2010 | RB9 - DS1 | HCE-04DU9-1SN | Hi-Cap 1.544 [NAME] (DS1) | DS1 with B8ZS / ESF line format | AT&T Mobility | AWL | Billed
New Ulm to Comfrey | 26 | 0.11 | 0.33 | 531.7328 | 137.0226 | 4496.813 | 1193.907 | 215.9492 | 39.2106 | 215.9492 | 39.2106 | 176.49 | 29.172 |  | DS3 | 3129.45 | 782.35 | 204.55 | 2128.88 | 532.21 | 139.15 |  |  |  | 2010 | RB9 - DS3 | HCE-04DS6.44 | Hi-Cap 1.544 [NAME] (DS1) | Hi-Cap 1.544 [NAME] (DS1) | Crystal Com/Hickory Tech | CFZ | NA
New Ulm to Cottonwood | 64 | 0.08 | 0.25 | 584.7976 | 255.52 | 4959.096 | 2226.4 | 231.1364 | 73.12 | 231.1364 | 73.12 | 187.79 | 54.4 |  | 56K-NU | 129.24 | 67.49 | 6.72 | 87.92 | 45.91 | 4.57 |  |  |  | 2010 | RB9 - 56K | [NAME] |  |  | Direct Billed | - | Removed
New Ulm to Echo | 52 | 0.06 | 0.18 | 537.8376 | 149.4792 | 4549.996 | 1302.444 | 217.6964 | 42.7752 | 217.6964 | 42.7752 | 177.79 | 31.824 |  | 64K-NU | 129.24 | 67.49 | 6.72 | 87.92 | 45.91 | 4.57 |  |  |  | 2010 | RB9 - 64K | HCE-04QB9.11 |  |  | Enventis/Hickory | MPJ | Sleepy Eye
New Ulm to Fairbault | 59 | 0.06 | 0.17 | 547.6992 | 160.1791 | 4635.906999999999 | 1395.6745 | 220.5188 | 45.83710000000001 | 220.5188 | 45.83710000000001 | 179.89 | 34.102 |  | VG-NU | 112.06 | 50.13 | 5 | 76.23 | 34.1 | 3.4 |  |  |  | 2010 | RB9 - VG | HCE-04OB6.33 |  |  | Level 3 Communications | LVC
New Ulm to Fairfax | 20 | 0.08 | 0.26 | 502.148 | 83.04400000000001 | 4239.08 | 723.58 | 207.482 | 23.764 | 207.482 | 23.764 | 170.19 | 17.68 |  |  |  |  |  |  |  |  |  |  |  | 2010 | RB7 - DS1 |  |  |  | Sleepy Eye Billed | -
New Ulm to Hanska | 12 | 0.3 | 0 | 549.108 | 0 | 4648.18 | 0 | 220.922 | 0 | 220.922 | 0 | 180.19 | 0 |  |  |  |  |  |  |  |  |  |  |  | 2010 | RB7 - DS3 |  |  |  | T-Moblie | ABW
New Ulm to Lafayette | 10 | 0.09 | 0.27 | 485.712 | 43.11900000000001 | 4095.895 | 375.705 | 202.778 | 12.339 | 202.778 | 12.339 | 166.69 | 9.18 |  |  |  |  |  |  |  |  |  |  |  | 2010 | RB7 - 56K |  |  |  | Verizon/Alltel | CUU
New Ulm to Madelia | 19 | 0.05 | 0.16 | 486.886 | 48.5488 | 4106.122499999999 | 423.016 | 203.114 | 13.8928 | 203.114 | 13.8928 | 166.94 | 10.336 |  |  |  |  |  |  |  |  |  |  |  | 2010 | RB7 - 64K |  |  |  | [NAME] | -
New Ulm to Mankato | 25 | 0.06 | 0.18 | 499.8 | 71.86500000000001 | 4218.625 | 626.175 | 206.81 | 20.565 | 206.81 | 20.565 | 169.69 | 15.3 |  |  |  |  |  |  |  |  |  |  |  | 2010 | RB7 - VG |  |  |  | 0001 WTL Worldcom | MAL
New Ulm to [NAME] | 67 | 0.12 | 0.35 | 653.3592 | 374.4965 | 5556.382 | 3263.0675 | 250.7588 | 107.1665 | 250.7588 | 107.1665 | 202.39 | 79.72999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0222 MCI / Worldcom | MCI
New Ulm to Medford | 64 | 0.06 | 0.19 | 554.7432 | 194.1952 | 4697.272 | 1692.064 | 222.5348 | 55.5712 | 222.5348 | 55.5712 | 181.39 | 41.344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0223 [NAME] | PST
New Ulm to Morgan | 25 | 0.06 | 0.17 | 499.8 | 67.8725 | 4218.625 | 591.3875 | 206.81 | 19.4225 | 206.81 | 19.4225 | 169.69 | 14.45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0236 Qwest LD Corp | QWD
New Ulm to Nicollet | 14 | 0.05 | 0.15 | 481.016 | 33.53700000000001 | 4054.985 | 292.215 | 201.434 | 9.597000000000001 | 201.434 | 9.597000000000001 | 165.69 | 7.14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0244 [NAME] | BUN
New Ulm to Owatonna | 64 | 0.06 | 0.19 | 554.7432 | 194.1952 | 4697.272 | 1692.064 | 222.5348 | 55.5712 | 222.5348 | 55.5712 | 181.39 | 41.344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0247 Rogers Cable | -
New Ulm to [NAME] | 37 | 0.09 | 0.27 | 542.7683999999999 | 159.5403 | 4592.9515 | 1390.1085 | 219.1076 | 45.65430000000001 | 219.1076 | 45.65430000000001 | 178.84 | 33.966 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0264 Onvoy | MEN
New Ulm to Rochester | 101 | 0.05 | 0.15 | 583.154 | 241.9455 | 4944.7775 | 2108.1225 | 230.666 | 69.2355 | 230.666 | 69.2355 | 187.44 | 51.50999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0288 AT&T | ATX
New Ulm to Rushmore | 82 | 0.11 | 0.32 | 676.3696 | 419.0528 | 5756.841 | 3651.296 | 257.3444 | 119.9168 | 257.3444 | 119.9168 | 207.29 | 89.21600000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0297 Vartec | VRT
New Ulm to Sanborn | 35 | 0.27 | 0.73 | 686.466 | 408.0335 | 5844.797500000001 | 3555.2825 | 260.234 | 116.7635 | 260.234 | 116.7635 | 209.44 | 86.87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0322 Global Crossing | ASI
New Ulm to SE Contract | 14 | 0.66 | 0 | 690.71 | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0333 Sprint | UTC
New Ulm to Sleepy Eye | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0355 US Link / TDS Metrocom | USL
New Ulm to Springfield | 26 | 0.34 | 0.66 | 672.1432 | 274.0452 | 5720.022 | 2387.814 | 256.1348 | 78.4212 | 256.1348 | 78.4212 | 206.39 | 58.344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0366 Logix | AMN
New Ulm to [NAME] | 25 | 0.05 | 0.14 | 493.93 | 55.89500000000001 | 4167.487499999999 | 487.025 | 205.13 | 15.995 | 205.13 | 15.995 | 168.44 | 11.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0432 Qwest | LGT
New Ulm to [NAME] | 25 | 0.09 | 0.26 | 517.41 | 103.805 | 4372.0375 | 904.475 | 211.85 | 29.705 | 211.85 | 29.705 | 173.44 | 22.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0444 [NAME] | ALN
New Ulm to Wabasso | 40 | 0.05 | 0.16 | 511.54 | 102.208 | 4320.9 | 890.5600000000001 | 210.17 | 29.248 | 210.17 | 29.248 | 172.19 | 21.76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0457 Telco Comm / Dial & Save | TDG
New Ulm to Windom | 45 | 0.16 | 0.49 | 633.636 | 352.1385 | 5384.559999999999 | 3068.2575 | 245.114 | 100.7685 | 245.114 | 100.7685 | 198.19 | 74.97 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0500 [NAME] | SCH
New Ulm to Windom T3/24273 | 0 | 0 | 0 | 2020 | 1794 | 3911.8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0555 MCI Worldcom | WTL
New Ulm to Winona | 45 | 0.16 | 0.49 | 633.636 | 352.1385 | 5384.559999999999 | 3068.2575 | 245.114 | 100.7685 | 245.114 | 100.7685 | 198.19 | 74.97 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0725 Mcleod USA | IOR
New Ulm to Winthrop | 17 | 0.06 | 0.17 | 488.5296 | 46.1533 | 4120.441 | 402.1435000000001 | 203.5844 | 13.2073 | 203.5844 | 13.2073 | 167.29 | 9.826 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0752 Excel Tel | EXL
New Ulm to Worthington | 74 | 0.11 | 0.35 | 655.7072 | 413.623 | 5576.837 | 3603.985 | 251.4308 | 118.363 | 251.4308 | 118.363 | 202.89 | 88.05999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0912 Norlight | NLG
Sanborn to Windom | 24 | 0.2 | 0.59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0948 Broadwing | SSM
Sleepy Eye Bills | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5061 [NAME] | IOC
Springfield to [NAME] | 43 | 0.17 | 0.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5102 Wiltel | WCA
Springfield to Medford | 88 | 0.11 | 0.26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5119 XO Communications | TQW
Springfield to Morgan | 13 | 0.1 | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5141 NULD | NUL
Springfield to Windom | 27 | 0.22 | 0.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5158 Wiltel | WCA
Windom to Windom | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5314 Interstate 35 | IEP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5483 Verizon Select Service | GOP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5792 Southwestern Bell | SBZ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6769 Rural Cellular Corp | RGO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6792 Distance Direct (HLD) | HTT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8008 Neutral Tandem | OWS