Spreadsheet: 770899d1646326058-pulling-data-based-on-criteria-from-one-list-to-another-second-attempt-with-a-bit-more-to-go-on-aligw
Sheet: Sheet1

Customer Equipment |  | HC Results
SN#D4866064DE10  ; TYPE:31; MODEL:AHCOD5519; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700      SN#0040366D721A  ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : UNKNOWN : D4866064DE10  EQUIP SERIAL : FAIL : 0040366D721A --DOWNSTREAM RX : (-7 to 7) : -12.3 : FAIL --DOWNSTREAM SNR : (30 to 50) : 41.4 : PASS --UPSTREAM TX : (36 to 50) : 37 : PASS --UPSTREAM SNR : (30 to 50) : 30.8 : PASS  CHECKED AT: 2/14/22 12:35 PM OVERALL RESULT: FAIL
SN#08952AFE5226  ; TYPE:30; MODEL:AHTC8717; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#EVY802H06842  ; TYPE:EB; MODEL:EBOX; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#A8705D8B4B19  ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : FAIL : 08952AFE5226 --DOWNSTREAM RX : (-7 to 7) : -7.6 : FAIL --DOWNSTREAM SNR : (30 to 50) : 38.7 : PASS --UPSTREAM TX : (36 to 50) : 49.5 : PASS --UPSTREAM SNR : (30 to 50) : 36.1 : PASS  EQUIP SERIAL : UNKNOWN : A8705D8B4B19  CHECKED AT: 2/14/22 12:57 PM OVERALL RESULT: FAIL
SN#0015CEDF959B  ; TYPE:I; MODEL:AHTM602A; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#B0C28727EFBD  ; TYPE:I; MODEL:AHTC8305; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : UNKNOWN : 0015CEDF959B_x000D_ _x000D_ EQUIP SERIAL : PASS : B0C28727EFBD_x000D_ --DOWNSTREAM RX : (-7 to 7) : 4.3 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 37.1 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 43 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 36.7 : PASS_x000D_ _x000D_ CHECKED AT: 2/14/22 05:52 PM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#001DCFDF75A4  ; TYPE:I; MODEL:AHTM604G; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#18593357173C  ; TYPE:I; MODEL:AHDPC3008; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 [NAME]  ; TYPE:30; MODEL:AHTC8717; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 |  | EQUIP SERIAL : UNKNOWN : 001DCFDF75A4_x000D_ _x000D_ EQUIP SERIAL : UNKNOWN : 18593357173C_x000D_ _x000D_ EQUIP SERIAL : PASS : 705A9EE4F35C_x000D_ --DOWNSTREAM RX : (-7 to 7) : -0.5 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 36 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 46.4 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 32.6 : PASS_x000D_ _x000D_ CHECKED AT: 2/14/22 04:00 PM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#484BD4002F73  ; TYPE:31; MODEL:AHCGA4236; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#PAEY02094554  ; TYPE:SE; MODEL:PCRNG110R; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#B05216F8B3BA  ; TYPE:31; MODEL:AHUBC1301; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : FAIL : 484BD4002F73_x000D_ --DOWNSTREAM RX : (-7 to 7) : -0.8 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 36 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 49.3 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 29.2 : FAIL_x000D_ _x000D_ EQUIP SERIAL : UNKNOWN : B05216F8B3BA_x000D_ _x000D_ CHECKED AT: 2/14/22 11:51 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#A4CFD2FF9EAF  ; TYPE:31; MODEL:AHUBC1329; OWNER CODE:R ; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : UNKNOWN : A4CFD2FF9EFC_x000D_ _x000D_ CHECKED AT: 2/14/22 10:39 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#1077B11F6E92  ; TYPE:31; MODEL:GXMC990CL; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#A86ABBD6D790  ; TYPE:31; MODEL:AHFST3896; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : UNKNOWN : 1077B11F6E92_x000D_ _x000D_ EQUIP SERIAL : PASS : A86ABBD6D790_x000D_ --DOWNSTREAM RX : (-7 to 7) : 6.6 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 36.6 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 44.5 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 31.9 : PASS_x000D_ _x000D_ CHECKED AT: 2/14/22 10:19 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#001DCE632AC2  ; TYPE:I; MODEL:AHTM604G; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#A456CC276ADC  ; TYPE:31; MODEL:AHCGA4131; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 SN#ACEC80EE011B  ; TYPE:I; MODEL:AHTM804G; OWNER CODE:R Rental/Lease; SYS-PRIN: 8384-9700 |  | EQUIP SERIAL : UNKNOWN : 001DCE632AC2_x000D_ _x000D_ EQUIP SERIAL : PASS : A456CC276ADC_x000D_ --DOWNSTREAM RX : (-7 to 7) : 1.7 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 39.8 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 45.8 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 35.1 : PASS_x000D_ _x000D_ EQUIP SERIAL : PASS : [NAME]_ --DOWNSTREAM RX : (-7 to 7) : 2.2 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 37.3 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 44.3 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 35.6 : PASS_x000D_ _x000D_ CHECKED AT: 2/14/22 04:17 PM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#84948C95B6C0  ; TYPE:I; MODEL:AHCGN; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#A4CFD2FF8F9E  ; TYPE:31; MODEL:AHUBC1329; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : UNKNOWN : A4CFD2FF8F9E_x000D_ _x000D_ CHECKED AT: 2/14/22 12:58 PM_x000D_ OVERALL RESULT: FAIL_x000D_
[NAME]  ; TYPE:I; MODEL:AHTM602A; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 SN#D48660655DC0  ; TYPE:31; MODEL:CM4642342; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9700 |  | EQUIP SERIAL : UNKNOWN : 0015CE54298A_x000D_ _x000D_ EQUIP SERIAL : FAIL : D48660655DC0_x000D_ --DOWNSTREAM RX : (-7 to 7) : 1.8 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 39.3 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 44.5 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 19.3 : FAIL_x000D_ _x000D_ CHECKED AT: 2/14/22 10:37 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#087E64CFE8C3  ; TYPE:31; MODEL:AHCGA4234; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#M91519EN6336  ; TYPE:X7; MODEL:DCX700MR; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 |  | EQUIP SERIAL : UNKNOWN : 087E64CFE8C3  CHECKED AT: 2/14/22 08:26 AM OVERALL RESULT: FAIL
[NAME]  ; TYPE:31; MODEL:AHCGA4234; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#MA1925PJ2384  ; TYPE:EB; MODEL:DCX860QI3; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400  SN#840B7C5AF75C  ; TYPE:EX; MODEL:[NAME]; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#D486602F6440  ; TYPE:31; MODEL:AHCOD4589; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#KB8V0EA3HZ72D2DM  ; TYPE:EE; MODEL:[NAME]; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#KB940NFSGQ511009  ; TYPE:EE; MODEL:[NAME]; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 |  | EQUIP SERIAL : UNKNOWN : 3CB74B383B6B_x000D_ _x000D_ EQUIP SERIAL : PASS : D486602F6440_x000D_ --DOWNSTREAM RX : (-7 to 7) : -3 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 41.2 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 44.8 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 32.4 : PASS_x000D_ _x000D_ CHECKED AT: 2/14/22 10:54 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#044E5A3685B9  ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9400 [NAME]  ; TYPE:I; MODEL:CMODEM; OWNER CODE:P Purchased; SYS-PRIN: 8383-9400 SN#EVW841H06186  ; TYPE:EB; MODEL:EBOX; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 |  | EQUIP SERIAL : PASS : 044E5A3685B9_x000D_ --DOWNSTREAM RX : (-7 to 7) : 6.6 : PASS_x000D_ --DOWNSTREAM SNR : (30 to 50) : 36.1 : PASS_x000D_ --UPSTREAM TX : (36 to 50) : 45.5 : PASS_x000D_ --UPSTREAM SNR : (30 to 50) : 31.9 : PASS_x000D_ _x000D_ EQUIP SERIAL : UNKNOWN : A47AA46E9410_x000D_ _x000D_ CHECKED AT: 2/14/22 11:48 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#30B1B52AE930  ; TYPE:31; MODEL:CM4642342; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#6C55E8713FA3  ; TYPE:31; MODEL:AHCOD4589; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 SN#EVW852H06742  ; TYPE:EB; MODEL:EBOX; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 |  | EQUIP SERIAL : UNKNOWN : 30B1B52AE930_x000D_ _x000D_ EQUIP SERIAL : UNKNOWN : 6C55E8713FA3_x000D_ _x000D_ CHECKED AT: 2/14/22 09:57 AM_x000D_ OVERALL RESULT: FAIL_x000D_
SN#PADK00137656  ; TYPE:DE; MODEL:RNG150N; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400  SN#A4CFD2FF5E0B  ; TYPE:31; MODEL:AHUBC1329; OWNER CODE:R Rental/Lease; SYS-PRIN: 8383-9400 |  | EQUIP SERIAL : UNKNOWN : A4CFD2FF5E0B_x000D_ _x000D_ CHECKED AT: 2/14/22 12:26 PM_x000D_ OVERALL RESULT: FAIL_x000D_