Spreadsheet: 49211d1248450178-sumif-text-and-values-exampleexcel2
Sheet: Sprint Cards

 | User | Last User | Card | Card Information | GL Account | Contract End Date | Notes | Pricing Information | Account:  533598817 Password:  skittles Pin:  13282117
A | Bair, [NAME] | [NAME] 3 | Sierra Wireless (Aircard 595) | MDN [PHONE]                       esn-dec [PHONE]             esn hex 603a5bc | F310093 1750 50 | 2009-07-17 00:00:00 | 7/16/07 - ordered 7/18/07 - rec'd 9/14/07 - transferred to [NAME]
A | Bingaman, [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE]               esn-dec: [PHONE]        esn-hex: 60372844 | FMO1CU7 1750 10 | 2009-02-05 00:00:00 |  | $59 unlimited usage
A | Birkelo, [NAME] | [NAME], [NAME] | Novatel Wireless (Merlin S620) | MDN [PHONE]               ESN HEX: 5B0D4DDF               ESN DEC [PHONE] | F310117 1750 36 | 2008-08-21 00:00:00 | 8/31/06 - rec'd  7/11/08  - transferred card from [NAME] to [NAME]
A | [NAME], [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE] MSID [PHONE] ESN-HEX:  603716C6        ESN-DEC: [PHONE] | OMF1500 1750 50 | 2009-01-05 00:00:00
A | Butler, [NAME] | [NAME] | Sierra Wireless (Aircard 595) | MDN [PHONE]                     esn-dec  [PHONE]        esn-hex 603a5ea0 | F310080 1750 31 | 2009-07-17 00:00:00 | 7/16/07 - ordered 7/18/07 - rec'd
A | [NAME], [NAME] |  | Sierra Wireless (Aircard® 595) | MDN [PHONE] MSID  [PHONE] ESN DEC  [PHONE] ESN HEX 604B7C38 | F310063 1750 32 | 2010-05-15 00:00:00 |  | $127 for card, $60 per month
A | [NAME], [NAME] |  | Sierra Wireless (Aircard 597E) | MDN [PHONE] MSID  [PHONE] ESN DEC   [PHONE] ESN HEX  605FB0A3 | OPM3900 1750 35 | 2010-04-16 00:00:00 | 4/16/09  ab - ordered a new card/order #DM14-0-17591141 | $99.99 w/1 yr contract $59.99/mo or current contract $106.24 with all taxes and fees
A | Hall, David |  | Sierra Wireless (Aircard® 595) | MDN [PHONE] CODE: [PHONE] CODE: 60486e88 FSN: [NAME] | F310163 1750 31 | 2010-04-21 00:00:00 | initial 119.95 +59.95 per month | initial $119.95, $59.95 per month unlimited usage
A | [NAME] | Yoder, [NAME] | Sierra Wireless (Aircard 595) | MDN:  [PHONE] ESN HEX 604BFBBB ESN DEC  [PHONE] | OIS5050 1750 50 | 2010-06-09 00:00:00 | 6/9/08 - ordered, order TMTSRH19376361 6/19/08  - rec'd, shipped to [NAME] | Retail price $269, 27% discount, initial $117.99, $59.95 per month unlimited usage
A | [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE]                        ESN-DEC [PHONE]        ESN-HEX 603b1888 | OIS5050 1750 50 | 2009-05-29 00:00:00 | 6/26/07 - ordered new to replace the one lost by UPS 6/28/07 - rec'd 12/11/07 - switched to loaner 2
A | [NAME] 3 |  | Sierra Wireless (Aircard 595) | MDN [PHONE]                     esn-dec   [PHONE]           esn hex 604949F6 | OIS5050 1750 50 | 2009-09-15 00:00:00 | 9/12/07 - ordered
A | [NAME] |  | Sierra Wireless (Aircard 597E) |  | OIS5050 1750 50 |  | 7/29/08  - ordered, they do not carry Sprint Wireless 595 anymore I declined any extra services or insurance | Retail price - $129.99 Unlimited plan $59.99 $144.09 total for order [NAME]-ENRH-2213575
A | Hill, Dale |  | Sierra Wireless (Aircard® 595) | MDN [PHONE]                      ECN-DEC [PHONE]           ESN-HEX 60366630c | OPM3900 1750 50 | 2010-04-01 00:00:00 |  | $119 for card, $59.99 unlimited monthly service, 2 year contract
A | Igo, Erwin |  | Sierra Wireless (Aircard 595) | MDN [PHONE]                                ESN-HEX: 60366c13                        ESN-DEC: [PHONE] | F310015 1750 35 | 2008-12-05 00:00:00
A | Jones, [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE] ESN-HEX: 603696EB               ESN-DEC: [PHONE] | OMF1500 1750 50 | 2008-11-20 00:00:00
A | Linger, [NAME] | [NAME], [NAME]-lost | Novatel Wireless (Merlin S620) | MDN [PHONE] ESN HEX: 5BOD4428            ESN DEC : [PHONE] | OCP5200  1750 50 | 2008-08-21 00:00:00 | 8/31/06 - Rec'd 12/1/07 - [NAME] says this card is lost ([NAME]) 12/10/07  - transferred remaining contract to [NAME] expires in August.  [NAME] is fine with his card and will continue on month by month basis
A | Manning, [NAME] |  | Novatel Wireless (Merlin S620) | MDN [PHONE] ESN HEX 5BOD4DE7               ESN DEC [PHONE] | F300002 1750 33 | 2008-08-23 00:00:00 | 8/31/06 - rec'd 6/18/08  - contract is expiring.  He will continue using his current card on a monthly basis
A | Myers, [NAME] |  | Novatel Wireless (Merlin S620) | MDN [PHONE] ESN-Hex: 5b0cbdff  ESN_DEC:  [PHONE]          MDIS [PHONE] | OCP5100 1750 50 | 2008-07-07 00:00:00 | 6/18/08  - contract is expiring.  He is fine with his current card and will continue on a monthly basis for now
A | Norsworthy, Pam | [NAME] | Sierra Wireless (Aircard® 595) | MDN [PHONE] ESN-DEC [PHONE] ESN-HEX 603A6DD4 | OPM3900 1750 50 | 2009-08-15 00:00:00
A | Sifri, Mamduh |  | Novatel Wireless (Merlin S620) | MDN [PHONE] ESN HEX 5B0D45DA            ESN DEC [PHONE] | OPM3900 1750 35 | 2008-08-21 00:00:00 | 9/1/06 - in service 6/18/08  - contract expires in August.  We will continue on a monthly basis
A | [NAME], [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE] esn-dec [PHONE]         esn-hex 6039e810 | F300002 1750 32 | 2009-06-15 00:00:00 | 6/15/07 - ordered
A | [NAME], [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE]                esn_dec [PHONE]                esn-hex 6049FB95 | OCP5200 1750 50 | 2009-12-18 00:00:00 | 12/18/07 - ordered | $99 for card, $59.99 for unlimited service, 2 year contract
A | VanCleve, [NAME] |  | Sierra Wireless (Aircard 595) | MDN:  [PHONE] ESN HEX 604BFD53 ESN DEC [PHONE] | OCP5200 1750 50 | 2010-06-09 00:00:00 | 6/9/08 - ordered, order TMTSRH19376361  6/19/08  - rec'd, shipped to [NAME] | Retail price $269, 27% discount, initial $117.99, $59.95 per month unlimited usage
A | [NAME], [NAME] |  | Sierra Wireless (Aircard 595) | MDN [PHONE]              ESN-DEC-[PHONE]  ESN_HEX  603AB321 | OCP5100 1750 50 | 2009-04-02 00:00:00 | 3/28/07 - ordered per [NAME]
L | [NAME], [NAME] | Hill, Dale | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] ESN DEC [PHONE] ESN HEX 5B078C88 | OMF1500 1750 10 | 2007-01-11 00:00:00 | 1/5/07 WANTS FASTER CARD, ORDERED FROM SPRINT SIERA595
L | [NAME], [NAME] | [NAME], [NAME] | Novatel Wireless (Merlin C201) | MDN [PHONE] ESN DEC [PHONE] ESN HEX 580622CC |  | 2005-10-20 00:00:00 | cancelled 6/16/06
L | [NAME], [NAME] | Dalke, Brad Nemec, [NAME] | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] Lock Code 090147 | F300003 1750 33 | 2006-11-16 00:00:00 | ORDER FASTER CARD 8/21/06
L | [NAME], [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] ESN HEX 5B0622C9  MSID [PHONE] Lock Code 3758 | F300003 1750 33 | 2006-06-29 00:00:00 | cancelled 6/16/06
L | [NAME] |  | Novatel Wireless (Merlin S620) | MDN [PHONE]  ESN-Hex: 5boca398                   MDIS [PHONE] | OPM3900 1750 35 | 2008-07-21 00:00:00 | 6/18/08  his contract is expiring.  He wants to keep the current card and continue on a month by month basis 4/16/09  ab - this card will not work with new laptop, ordering a new one 4/16/09  ab - transferred contract to new card
L | [NAME] (return for redeploy) |  | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] Lock Code 499863 ESN DEC [PHONE] ESN HEX 5B067677 | OPM3900 1750 35 | 2006-09-14 00:00:00 | CANCELLED 8/21/06
L | [NAME] |  | Sierra Wireless (Aircard® 580) | MDN [PHONE] MSID [PHONE] MSL 347637 | OIS5050 1750 50 | 2007-08-16 00:00:00 | call to cancel 8/15/07
L | [NAME] | [NAME], [NAME] | Sierra Wireless (Aircard 580) | MDN [PHONE] esn-dec [PHONE]          esn hex 60314610 | OIS5050 1750 50 | 2009-02-14 00:00:00 | installed 2/14/07 | 1/15/08 cancel
L | [NAME] | [NAME], [NAME] | Sierra Wireless (Aircard® 580) | MDN [PHONE] MSID - [PHONE]     MSL -759432 | OIS5050 1750 50 | 2007-08-11 00:00:00 | FAILED, DIDN'T REPLACE 12/06
L | [NAME] 3 | Myers, [NAME] | Sierra Wireless (Aircard® 580) | MDN [PHONE] ESN HEX 6032334E ESN DEC [PHONE] | OIS5050 1750 50 | 2007-07-15 00:00:00 | replaced 6/15/07
L | [NAME] 3 |  | Sierra Wireless (usb 595) | mdn [PHONE]                 esn dec-[PHONE]         esn-hex 603D00A7 | OIS5050 1750 50 | 2009-06-15 00:00:00 | ordered 6/15/07-never got this, acct got terminated, so had to order new card 7/16/07
L | [NAME] | [NAME] | Sierra Wireless (Aircard® 580) | MDN [PHONE]  MSID - [PHONE]  MSL - 214489 pn#1200718 | OIS5050 1750 50 | 2007-09-14 00:00:00 | CANCELLED AS OF 9/14/07
L | Igo, Erwin |  | Novatel Wireless (Merlin S720) | MDN [PHONE]             ESN Hex 5B416D13           ESN Dec [PHONE] | F310015 1750 50 | 2008-10-02 00:00:00 | rec 10/4/06--required an adapter, returned it--he's returning directly to sprint
L | Igo, Erwin |  | Sierra Wireless (Aircard 595) | MDN [PHONE]            ESN # 60368E73 | F310015 1750 50 | 2006-10-18 00:00:00 | rec 10/18/06
L | Igo, Erwin |  | Sierra Wireless (Aircard® 580) | MDN [PHONE] ESN HEX 6021E552 ESN DEC [PHONE] | F310015 1750 50 | 2007-07-15 00:00:00 | this card failed, out of warranty so I upgraded to S720 card--$99.99, monthly line $59.99
L | Jones, [NAME] |  | Novatel Wireless (Merlin S620) | MDN [PHONE] ESN-HEX:580D4DE1                ESN-DEC: [PHONE] | OMF1500 1750 10 | 2008-08-21 00:00:00 | REC 8/31/06- FAILED 10/26/06
L | Jones, [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] ESN HEX 5B07078F ESN DEC [PHONE] Lock Code 040091 | OMF1500 1750 10 | 2006-11-16 00:00:00 | this card terminates once his replacement card is activated jw
L | Linger, [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] ESN HEX 5B06D18F ESN DEC [PHONE] Lock Code 009444 | OMF1500 1750 10 | 2006-12-07 00:00:00 | reordered card 2/6/07 since we never got October card ORDERED 10/26/06 | $250 FOR CARD, LESS $150 CREDIT, $59.99 PER MONTH FOR SERVICE FOR 2 YEARS
L | Manning, [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE]                          ESN DEC [PHONE]         ESN HEX 5B03C2B7             Lock Code 5979 | F300002 1750 33 | 2006-09-17 00:00:00 | HE WANTS THE FASTER CARD JW 8/23/06
L | Moore, [NAME] |  | Sierra Wireless (Aircard 595) | mdn [PHONE]              esn-dec [PHONE]         esn-hex 603a 1cae | F310082 | 2009-05-29 00:00:00 | ordered 5/29/07 UPS lost this one
L | Norsworthy, Pam |  | Novatel Wireless (Merlin C201) | MDN [PHONE] ESN DEC [PHONE] ESN HEX 5B03D488 MSID [PHONE] Lock Code 119296 | OPM3900 1750 35 | 2006-08-12 00:00:00 | cancelled 7/19/06
L | Reynolds, [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] Lock Code 385118 MSID [PHONE] | OPM3740 1750 35 | 2006-11-19 00:00:00 | LET IT LAPSE 8/22/06- cancelled 10/20/06
L | Sifri, Mamduh |  | Novatel Wireless (Merlin C201) | MDN [PHONE] ESN DEC [PHONE] ESN HEX 5B06C9F7 | OPM3900 1750 35 | 2006-11-04 00:00:00 | SWAPPED FOR A FASTER CARD 9/1/06
L | [NAME], [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] Lock Code 438239 MSID [PHONE] | F310066 1750 32 | 2006-11-18 00:00:00 | ORDER FASTER CARD 8/21/06
L | [NAME], [NAME] | [NAME], [NAME] | Novatel Wireless (Merlin S620) | MDN [PHONE] MSID - [PHONE] MSL - 943995 | F310066 1750 32 | 2008-01-16 00:00:00 | [NAME] returning this in 2/07 transferred to stephens since his contract was longer 12/10/07 jw
L | [NAME], [NAME] |  | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] Lock Code 709460 | OPM3710 1750 35 | 2006-08-03 00:00:00 | cancelled 7/19/06
L | Stuever, [NAME] | Hooper, [NAME] | Novatel Wireless (Merlin C201) | MDN [PHONE] MSID [PHONE] ESN HEX 5B070783 ESN DEC [PHONE] Lock Code 153726 | [NAME] 1750 35 | 2006-11-16 00:00:00 | HE DOESN'T WANT CARD ANY LONGER WHEN CONTRACT RUNS OUT 8/21/06- cancelled 10/20/06 jw
L | [NAME], [NAME] |  | Sierra Wireless (Aircard 860) | [PHONE] 89014104201069768467 SIMM 357806002534278 IMEI | OCP5200  1750 50 | New 11/8/06
L | [NAME], [NAME] |  | Novatel Wireless (Merlin S620) | MDN [PHONE]            ESN 5BOCE1E6 | OCP5200  1750 50 | 2008-07-13 00:00:00 | card is broken, called 6/9/08  ab - not eligible to upgrade to July 11th, 2008, renewed contract 6/9/08 and ordered 595 card
 | Cingular Card
 | Sprint PCS Vision Connection Card $72 Plan with Discount        70MB |  | merged with ani acct 6/16/06 | AH&N  Account [PHONE] 0 | pswd 8117