Spreadsheet: 134986d1325735940-requesting-formula-that-prioritizes-a-set-of-if-formulas-followed-by-a-vlookup-rate-sample
Sheet: AWCC Voice Rates Master

Change | Standard or Exceptions | My SID | AWCC Exception BIDs | Their SID | RP Exceptions BIDs | Carrier Code | Roaming Partner | Standard Daily Rate | Air Rate | [NAME] | DA |  |  | Start Date | End Date
 | Standard | ALL |  | ALL |  | 3674 | [NAME] , LLC |  | 0.1 | 0.05 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 234 | ACS WIRELESS INC |  | 0.06 | 0.05 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 819 | AERIS COMMUNICATIONS, INC. |  | 0.09999999999999999 | 0 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 909 | GCI COMM. CORP. DBA ALASKA DIGITEL |  | 0.08 | 0.05 | 1.99 + airtime | 0.35 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 873 | ALLTEL TRUST |  | 0.04 | 0.04 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 493 | APPALACHIAN WIRELESS |  | 0.04 | 0.03 | 1.99 + airtime
 | Standard | ALL |  | ALL |  | 493 | APPALACHIAN WIRELESS - DATA |  | 0.04 | 0.03 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 30 | [NAME], INC |  | 0.03 | 0.03 | 1.99 + airtime | 0.25 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 920 | BERMUDA DIGITAL COMMUNICATION LT |  | 0.05 | 0.05 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 353 | BLUEGRASS CELLULAR, INC. |  | 0.05 | 0.05 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 349 | CAROLINA WEST WIRELESS |  | 0.032 | 0.01 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 362 | CELLCOM |  | 0.03 | 0.02 | 1.99 + airtime | 0.15 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 221 | CELLULAR SOUTH, INC |  | 0.03 |  | 1.99 + airtime | 0.06 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | 1212 |  | 989 | [NAME] (RSA1) |  | 0.08 | 0.05 | 1.99 + airtime | 0.51 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | 1214 |  | 285 | [NAME] (RSA2) |  | 0.05 | 0.05 | 1.99 + airtime | 0.51 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 5005 | CHINA TELECOM | 3 | 0.9900000000000001 | 0.4 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 101 | COPPER VALLEY |  | 0.1 | 0.1 | 1.99 + airtime | 0.25 |  | 2011-11-29 00:00:00
 | Standard | ALL |  | ALL |  | 4575 | ETEX COMMUNICATIONS |  | 0.04 | 0.03 | 1.99 + airtime | 0.3 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 2464 | FIVE STAR WIRELESS |  | 0.08 | 0.06 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 408 | GOLDEN STATE CELLULAR | 3 | 0.05 | 0.05 | 1.99 + airtime | 0.25 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 179 | ILLINOIS VALLEY CELLULAR |  | 0.03 | 0.02 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 355 | INLAND CELLULAR TELEPHONE CO |  | 0.04 | 0.03 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 802 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 805 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 821 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 824 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 806 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 888 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 809 | IUSACELL, SA DE CV |  | 0.35 | 0.2 | 1.99 + airtime | 2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 974 | [NAME] |  | 0.25 | 0.15 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 975 | [NAME] |  | 0.25 | 0.15 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | MOST | 30285 | MOST | 5049, 6535,6539, 6541, 6542 | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 0 | 0.2 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | 30285 |  | ALL |  | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 0 | 0.15 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 5049 |  | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 0 | 0.15 | 0.15 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 6535 |  | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 3 | 0.99 | 0.6 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 6539 |  | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 3 | 0.99 | 0.6 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 6541 |  | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 3 | 0.99 | 0.6 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 6542 |  | 3779 | LEAP WIRELESS INTNL DBA CRICKET COM | 3 | 0.99 | 0.6 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | MOST | 6544, 44265 | 3823 | METROPCS WIRELESS, INC. |  | 0.09999999999999999 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 6544 |  | 3823 | METROPCS WIRELESS, INC. | 3 | 0.99 | 0.5 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | ALL |  | 44265 |  | 3823 | METROPCS WIRELESS, INC. | 3 | 0.99 | 0.6 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | MOST | 1192 | ALL |  | 560 | MID RIVER CELLULAR  (C & C) |  | 0.15 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Exception | 1192 |  | ALL |  | 560 | MID RIVER CELLULAR  (C & C) | 3 | 0.99 | 0.5 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 356 | MTA COMMUNICATIONS, LLC |  | 0.05 | 0.05 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 428 | MTS COMMUNICATIONS INC. |  | 0.05 | 0.05 | 1.99 + airtime |  |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 3807 | NEX-TECH WIRELESS, LLC |  | 0.04 | 0.02 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 9 | NORTHWEST MISSOURI CELLULAR |  | 0.05 | 0.05 | 1.99 + airtime | 0.2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 60 | NTELOS WIRELESS, INC. |  | 0.06 | 0.05 | 1.99 + airtime |  |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 475 | OPERADORA UNEFON S.A. DE C.V. |  | 0.1 | 0.75 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 402 | PEOPLES WIRELESS |  | 0.08 | 0.12 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 324 | PIONEER CELLULAR |  | 0.05 | 0.05 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 403 | PUERTO RICO TELEPHONE |  | 0.25 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 3704 | REVOL |  | 0.13 | 0.08 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 410 | SASKTEL [NAME] |  | 0.03 | 0.03 | 1.99 + airtime | 0.25 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 814 | SK TELECOM |  | 0.3 | 0.5 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 3624 | SOUTH CANAAN CELLULAR CO. |  | 0.05 | 0.05 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 26 | SPRINT PCS |  | 0.014 | 0.009 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 820 | SRT WIRELESS |  | 0.2 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 375 | STRATA NETWORKS/RINA LLC. |  | 0.03 | 0.03 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 459 | TBAYTEL |  | 0.1 | 0.1 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 384 | TELUS COMMUNICATIONS CO. |  | 0.1 | 0.05 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 935 | THUMB CELLULAR LIMITED PTNRSHP |  | 0.03 | 0.03 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Exception | ALL |  | ALL |  | 15 | UNITED STATES CELLULAR |  | 0.02 | 0.02 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 6736 | UNITED WIRELESS COMMUNICATIONS, INC |  | 0.04 | 0.02 | 1.99 + airtime | 0.1 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 910 | VERIZON/WIN4 NET |  | 0.15 | 0 | 1.99 + airtime |  |  | 2011-08-16 00:00:00
 | Standard | ALL |  | ALL |  | 5 | VZW - VERIZON WIRELESS |  | 0.03 | 0.02 | 1.99 + airtime | 0.2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 3996 | YOUGHIOGHENY COMM. NE LLC | 3 | 0.99 | 0.5 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 5877 | ELEMENT MOBILE - WISCONSIN RSA#7 |  | 0.02 | 0.01 | 1.99 + airtime |  |  | 2011-06-16 00:00:00
 | Standard | ALL |  | ALL |  | 13 | VZW/Alltel |  | 0.03 | 0.02 | 1.99 + airtime | 0.2 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 4194 | SI Wireless LLC |  | 0.03 | 0 | 1.99 + airtime |  |  | 2011-04-16 00:00:00
 | Standard | ALL |  | ALL |  | 800 | CIA DOMINICANA DE TELEFONOS, S.A |  | 0.18 | Pass Thru | 1.99 + airtime |  |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 398 | CITIZENS MOHAVE CELLULAR CO |  | 0.13 | 0.05 | 1.99 + airtime |  |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 520 | MID-TEX CELLULAR |  | 0.1 | 0.05 | 1.99 + airtime |  |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 510 | WEST CENTRAL CELLULAR |  | 0.15 | 0.1 | 1.99 + airtime |  |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 982 | [NAME] |  | 0.02 | 0.02 | 1.99 + airtime | 0.05 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 460 | [NAME] COM |  | 0.02 | 0.02 | 1.99 + airtime | 0.05 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 18 | AT&T Mobility Cruise Ships |  | 1.49 | 0.5 | 1.99 + airtime | 11.26 |  | 2011-11-16 00:00:00
 | Standard | ALL |  | ALL |  | 2501 | [NAME] |  | 0.04 | 0.04 | 1.99 + airtime | 0.35 |  | 2011-11-16 00:00:00