Excel assesment

profilejeremy0731
ExcelAssessment.xlsx

Sheet1

Customer PO Item DESCRIPTION HS CODE Available (unit) Questions:
1234567 E300000-A 1 Complete filling all information in blank Columns (use formula for all columns). Vlookup data from "Data"& "Inventory"
1234567 G3008 *If the value is not avaliable, mark N/A
1234567 G7006 2 Freeze Panes (freeze on item & keep first row fixed)
1234567 G3006 3 Hide Data & Inventory tab
1234567 GUECOM-CC 4 Bold styles the Available over 5000 units using conditional formating function. And rank all styles by sales units from high to low
1234567 G0005 5 Create Pivot table from data you have finished in Sheet1; the table should show Item and Available units.
1234567 E600007
1234567 E600007-M
1234567 E600008-A
1234567 G1002
1234567 G3001
1234567 G3005
1234567 G5006
1234567 G7002
1234567 E600000-A
1234567 E600022-1
1234567 E100000-A
1234567 E300018
1234567 E200005
1234567 E500000-1
1234567 E200004
1234568 G0005
1234568 E600007
1234568 E600007-M
1234568 E600008-A
1234568 G1002
1234568 G3001
1234568 G3005
1234568 G5006
1234568 E200000
1234568 E100000
1234568 E300001-A
1234568 E600019-2
1234568 E100008
1234568 E300012
1234569 E600007
1234569 E600007-M
1234569 E600008-A
1234569 G1002
1234569 G3001
1234569 G3005
1234569 G5006
1234569 E200000
1234569 E100000
1234569 E200011
1234569 E100010
1234569 E200001-A
1234569 GUECOM-LOVEDIT

Data

ITEM DESCRIPTION Bar Code HS CODE COO HAZMAT UN NO CASE QTY
E100000-6 eprouvage Gentle Volume Shampoo 8.45oz/250ml (6 pack) 815857015707 3305.10.0000 USA N 6
E100001-6 eprouvage Fortifying Shampoo 8.45oz/250ml (6 pack) 815857015721 3305.10.0000 USA N 6
E200000-6 eprouvage Gentle Volume Conditioner 8.45oz/250ml (6 pack) 815857015714 3305.90.0000 USA N 6
E200001-6 eprouvage Fortifying Conditioner 8.45oz/250ml (6 pack) 815857015738 3305.90.0000 USA N 6
E300000 eprouvage Reparative Treatment Masque 8oz/227g 815857015745 3305.90.0000 USA N 12
E300000-6 eprouvage Reparative Treatment Masque 8oz/227g (6 pack) 815857015745 3305.90.0000 USA N 6
E300001-6 eprouvage Replenishing Leave In Conditioner 8oz/236.5ml (6 pack) 815857015752 3305.90.0000 USA N 6
E300002 eprouvage Thickening and Plumping Spray 8oz/236.5ml 815857015769 3305.90.0000 USA N 12
E300002-6 eprouvage Thickening and Plumping Spray 8oz/236.5ml (6 pack) 815857015769 3305.90.0000 USA N 6
E300003 eprouvage Restorative Scalp Serum 2oz/59ml 815857015776 3305.90.0000 USA N 12
E300003-6 eprouvage Reviving Scalp Serum 2oz/59ml (6 pack) 815857015776 3305.90.0000 USA N 6
E600000 eprouvage Salon Counter Display 852558006313 N 1
E600000-1A eprouvage Salon Counter Display (AU) N 1
E600000-2A eprouvage Salon Display SubAssembly 2 (AU) N 1
E600000-3A eprouvage Salon Display SubAssembly 3 (AU) N 1
E600000-4A eprouvage Salon Display SubAssembly 4 (AU) N 1
E600000-A eprouvage Salon Display (AU) 852558006313 N 1
E600003 eprouvage Fortifying System Collection Pack 852558006344 3305.90.0000 N 6
E600007-A eprouvage Men's Display - Australia N 1
E600019 eprouvage Men's Counter Display 2017 815857017466 N 1
E600022-1 eprouvage Acrylic Display (Serum & Masque) 857386007983 3921.12.5 Taiwan N 1
E100005 eprouvage Men's Daily Shampoo 8.45oz/250ml 852558006429 3305.10.0000 USA N 12
E600008 eprouvage Mens System Kit (Ongoing) 815857016537 3305.90.0000 N 6
E600000-2 eprouvage Salon Counter Display Sub 2 N 1
E600000-3 eprouvage Salon Counter Display Sub 3 N 1
E200001 eprouvage Fortifying Conditioner 8.45oz/250ml 815857015738 3305.90.0000 USA N 12
E600005 eprouvage Gentle Volume Stylist Try Me 852558006337 N 6
E200000 eprouvage Gentle Volume Conditioner 8.45oz/250ml 815857015714 3305.90.0000 USA N 12
E300004-30 eprouvage Comprehensive Scalp Treatment 30 pack of vials (6 boxes of 5) 815857012164 3305.90.0000 USA N 4
E100001 eprouvage Fortifying Shampoo 8.45oz/250ml 815857015721 3305.10.0000 USA N 12
E600000-4 eprouvage Salon Counter Display Sub 4 N 1
E100000 eprouvage Gentle Volume Shampoo 8.45oz/250ml 815857015707 3305.10.0000 USA N 12
E600000-1 eprouvage Salon Counter Display 3921.12.5 Taiwan N 1
E300004-5 eprouvage Comprehensive Scalp Treatment - 5 pack of vials 3305.90.0000 USA N 1
E300001-A eprouvage Replenishing Leave In Conditioner 8oz/236.5ml (AU) 815857015752 3305.90.0000 USA N 12
E600006 eprouvage Fortifying Stylist Try Me 852558006320 N 6
E600002 eprouvage Gentle Volume System Collection Pack 852558006351 3305.90.0000 N 6
E600019-2 eprouvage Men's Counter Display 2017 Subassembly 2 (Product) 815857017466 N 1
E500000 eprouvage Scalp Stimulating Brush w/Box 815857012683 9603.29.8010 SINGAPORE N 50
E600001 eprouvage Restorative Client Duo 852558006375 N 1
E300004-20 eprouvage Comprehensive Scalp Treatment - 20 pack of vials 815857015783 3305.90.0000 USA N 4
E600019-1 eprouvage Men's Counter Display 2017 (Display Unit) 3921.12.5 USA N 1
E200000-A eprouvage Gentle Volume Conditioner 8.45oz/250ml (AU) 815857015714 3305.90.0000 USA N 12
E100000-A eprouvage Gentle Volume Shampoo 8.45oz/250ml (AU) 815857015707 3305.10.0000 USA N 12
E100001-A eprouvage Fortifying Shampoo 8.45oz/250ml (AU) 815857015721 3305.10.0000 USA N 12
E300018 Eprouvage Reparative Treatment Masque 2oz/60g 815857017183 3305.90.0000 USA N 12
E300009 eprouvage Men's Natural Hold Styling Gel 852558006672 3305.90.0000 USA N 12
E200005 eprouvage Men's Daily Conditioner 8.45oz/250ml 852558006436 3305.90.0000 USA N 12
E300007 eprouvage Men's Molding Paste 2oz/60g 852558006450 3305.90.0000 USA N 12
E100011 eprouvage Men's Daily Shampoo 25 fl oz / 750 ml 815857012829 3305.10.0000 USA N 6
E200010 eprouvage Smoothing Conditioner 25 fl oz/750 ml 815857012812 3305.90.0000 USA N 6
E200011 eprouvage Men's Daily Conditioner 25 fl oz / 750 ml 815857012836 3305.90.0000 USA N 6
E500000-1 eprouvage Scalp Stimulating Brush only TAIWAN N 100
E100010 eprouvage Smoothing Shampoo 25 floz/750 ml 815857012805 3305.10.0000 USA N 6
E300017 eprouvage Instant Root Lifter 4oz/125ml 815857012751 3305.90.0000 USA N 12
E300000-A eprouvage Reparative Treatment Masque 8oz 815857015745 3305.90.0000 USA N 12
E300002-A eprouvage Thickening and Plumping Spray 8oz/236ml 815857015769 3305.90.0000 USA N 12
E200001-A eprouvage Fortifying Conditioner 8.45oz/250ml (AU) 815857015738 3305.90.0000 USA N 12
E100009 eprouvage Fortifying Shampoo 25oz/750ml 815857012782 3305.10.0000 USA N 6
E200004 eprouvage Smoothing Conditioner 8.45oz/250ml 852558006412 3305.90.0000 USA N 12
E200009 eprouvage Fortifying Conditioner 25oz/750ml 815857012799 3305.90.0000 USA N 6
E100008 eprouvage Gentle Volume Shampoo, 25oz/750ml 815857012768 3305.10.0000 USA N 6
E100004 eprouvage Smoothing Shampoo 8.45oz/250ml 852558006405 3305.10.0000 USA N 12
E300014 eprouvage Men's Styling Duo Packette 815857017039 3305.90.0000 USA N 100
E300013 eprouvage Men's Spoo/Cond Duo Packette 815857017022 3305.10.0000 USA N 100
E300012 Reparative Treatment Masque packette (eprouvage) 815857016070 3305.90.0000 USA N 100
E200008 eprouvage Gentle Volume Conditioner 25oz/750ml 815857012775 3305.90.0000 USA N 6
E300010 Gentle Volume Spoo/Cond - Duo Pack (eprouvage) 815857016056 3305.10.0000 USA N 100
E300011 Fortifying Spoo/Cond - Duo Packettes (eprouvage) 815857016063 3305.10.0000 USA N 100
E300015 eprouvage Replenishing Leave In Conditioner 1oz/30ml 815857017107 3305.90.0000 USA N 24
E300005 eprouvage - Thickening & Plumping Spray 30 ml /m 1 fl oz 852558006252 3305.90.0000 USA N 24
E300003-A eprouvage Reviving Scalp Serum 2oz/59ml 815857015776 3305.90.0000 USA N 12
G0001-EU Flawless Moisturizing Shampoo 8.45 fl. oz/250ml 857386007051 3305.10.0000 USA N 12
G0002-EU Flawless Smoothing Shampoo 8.45 fl. oz/250ml 857686007068 3305.10.0000 USA N 12
G0008 Flawless *Cleasing Milk* size tbd 857386007570 3305.10.0000 USA N 12
G1008 Flawless *Tangle Melting Conditioner* 857386007587 3305.10.0000 USA N 12
G3005 Flawless Oil Treatment 1oz/30ml 815857017275 USA N 12
G3007 Flawless Shine Spray 1oz/30ml 815857017749 USA N 12
G3008 Flawless *Honey Masque* 857386007594 3305.90.0000 USA N 12
G5003-EU Flawless Blow Dry Cream 6.7 fl oz./198ml 857386007075 3305.90.0000 USA N 12
G5005 Maximum Volume Styling Spray 4.2oz/125ml 815857016117 USA N 12
G5007 Flawless Next Day Curl Spray 8oz/237ml 815857012737 USA N 4
G5008 Flawless Styling Curl Cream 8 fl oz./237ml 815857012744 USA N 12
G5009 Flawless Apple Cider Vinegar Rinse, 8oz 857386007129 USA N 4
G5010 Flawless Setting Foam, 8oz 857386007136 USA N 4
G5011 Flawless Edges Gel w/carton 2oz/60g 857386007358 3305.90.0000 USA N 12
G5012 Flawless *Hair Perfume* 857386007365 3305.90.0000 USA N 12
G5013 Flawless *Oil Solid* 857386007600 3305.90.0000 USA N 12
G5014 Flawless *Leave In Conditioner* 857386007617 3305.90.0000 USA N 12
G5015 Flawless *Split End Sealer* 857386007648 3305.90.0000 USA N 12
G7001 Flawless Moisturizing Bundle USA N 1
G7002 Flawless Smoothing Bundle USA N 1
G7004 Flawless JCP Stylist Kit 857386007259 USA N 1
G7005 Flawless Moisturizing Spoo/Cond 25oz Bundle USA N 1
G7006 Flawless Smoothing Spoo/Cond 25oz Bundle USA N 1
G7008 Flawless Sampling Mail Out Promo (w/Masque packette) USA N 1
G7009 Flawless Sampling Mail Out Promo w/Smoothing packette & HAIRFAV card USA N 1
G7011-1 Flawless Acrylic Display (Masque & Edges) 857386007976 3921.12.5 Taiwan N 1
G8000 Flawless *Body Butter* 6oz 857386007334 3305.90.0000 USA N 12
G8001 Flawless *Body Scrub* 8oz 857386007341 3305.90.0000 USA N 12
G8002 Flawless Vitamins for Beauty 857386007815 3305.90.0000 USA N 12
GUECOM-NEW4U GU ECOM - FLAWLESS NEW4U PROMO CARD N 1
G3006 Flawless Edge Control Gel packette .34 fl oz/10ml 815857017459 3305.90.0000 USA N 100
GUECOM-HAIRFAVS GU ECOM - FLAWLESS HAIRFAVS PROMO CARD N 1
G7010 Flawless Online Sampling Kit USA N 1
GUECOM-ENV GU ECOM - ENVELOPE FOR FLAWLESS SAMPLING PROGRAM N 250
GUECOM-LOVEDIT GU ECOM - FLAWLESS LOVED IT PROMO CARD N 1
GUECOM-CSC GU ECOM - CUSTOMER SERVICE CARD N 1
G5003 Flawless Blow Dry Cream 6.7 fl oz./198ml 815857016001 3305.90.0000 USA N 12
G0004 Moisturizing Shampoo 25oz/750ml - Flawless 815857017480 USA N 6
GUECOM-CC GU ECOM COCKTAIL CARD N 1
G1004 Moisturizing Conditioner 25oz/750ml - Flawless 815857017497 USA N 6
G0005 Smoothing Shampoo 25oz/750ml - Flawless 815857017503 USA N 6
G1005 Smoothing Conditioner 25oz/750ml - Flawless 815857017510 USA N 6
G5006 Flawless Oil Treatment 3.3 fl. oz/100ml 815857017190 3305.90.0000 USA N 12
G5001 Flawless Shine Spray 3.3 fl. oz/100ml 815857015981 3305.90.0000 USA N 12
G5002 Flawless Heat Protection Spray 4.2 fl. oz/125ml 815857015998 3305.90.0000 USA N 12
G5004 Flawless Edge Control Gel 4 fl.oz/118ml 815857016018 3305.90.0000 USA N 12
G0002 Flawless Smoothing Shampoo 8.45 fl. oz/250ml 815857014946 3305.10.0000 USA N 12
G1002 Flawless Smoothing Conditioner 8.45 fl. oz/250ml 815857014953 3305.90.0000 USA N 12
G3001 Flawless Hair Repair Masque 8 fl.oz/237ml 815857014960 3305.90.0000 USA N 12
GUECOM-S GU ECOM SHIPPER CHINA N 200
GUECOM-TC GU ECOM THANK YOU CARD N 1
G3003 Flawless Moisturizing Shampoo/Conditioner Duo Packette .34oz/10ml each 815857017206 3305.10.0000 USA N 100
G3004 Flawless Smoothing Shampoo/Conditioner Duo Packette .34oz/10ml each 815857017213 3305.10.0000 USA N 100
G0001 Flawless Moisturizing Shampoo 8.45 fl. oz/250ml 815857014922 3305.10.0000 USA N 12
G1001 Flawless Moisturizing Conditioner 8.45 fl. oz/250ml 815857014939 3305.90.0000 USA N 12
G3002 Flawless Hair Repair Masque Packette 1oz/30ml 815857017220 3305.90.0000 USA N 100
GUECOM-I GU ECOM INSERT N 1
GH600 Mac Pro Product Glorifier Header & Screws N 1
GB600 Mac Pro Product Glorifier Base N 1
E600003 eprouvage Fortifying System Collection Pack 852558006344 N 6
E600003-A eprouvage Fortifying System Collection Pack (AU) 852558006344 N 6
E600004 eprouvage Replenishing Holiday Duo 852558006382 N 6
E600005 eprouvage Gentle Volume Stylist Try Me 852558006337 N 6
E600006 eprouvage Fortifying Stylist Try Me 852558006320 N 6
E600007 eprouvage Men's Display*DO NOT USE*Correct Code E600007-M** 815857016520 N 1
E600007-1 eprouvage Men's Display (Display Unit) USA N 1
E600007-1A eprouvage Men's Counter Display (Display Unit) Australia USA N 1
E600007-2 eprouvage Men's Counter Display Subassembly 2 (Product) N 1
E600007-2A eprouvage Men's Display Subassembly 2 (Product) AUS N 1
E600007-A eprouvage Men's Display - Australia N 1
E600007-M eprouvage Men's Counter Display 815857016520 N 1
E600008 eprouvage Mens System Kit (Ongoing) 815857016537 N 6
E600008-A eprouvage Mens System Kit (Ongoing) - Australia N 6
E600009 Smoothing System Consumer Kit - cancelled Dec 2016 815857016544 N 6
E600010 Eprouvage Thermal Blow Dry Cream Salon Deal 815857016551 N 1
E600011 eprouvage Salon Display "Add On" 815857016568 N 1
E600012 Men's Thickening Pomade Launch Offer 815857016575 N 1
E600013 July/Aug 2016 Gentle Volume Bonus Duo (eprouvage) 815857016377 N 6
E600014 July/Aug 2016 Fortifying Bonus Duo (eprouvage) 815857016384 N 6
E600015 Gentle Volume Bonus Shampoo w/ Hangtag 815857016827 N 4
E600016 Gentle Volume Bonus Conditioner w/ Hangtag 815857016834 N 4
E600017 Fortifying Bonus Shampoo w/ Hangtag 815857016803 N 4
E600018 Fortifying Bonus Conditioner w/ Hangtag 815857016810 N 4
E600019 eprouvage Men's Counter Display 2017 815857017466 N 1
E600019-1 eprouvage Men's Counter Display 2017 (Display Unit) 3921.12.5 USA N 1
E600019-2 eprouvage Men's Counter Display 2017 Subassembly 2 (Product) 815857017466 N 1
E600020 eprouvage Serum and Brush Duo (Salon) 815857017756 N 6
EBV0002 eprouvage Presentation Folder N 1
EBV0003 eprouvage Pen N 1
G0001 Flawless Moisturizing Shampoo 8.45 fl. oz/250ml 815857014922 3305.10.0000 USA N 12
G0001-EU Flawless Moisturizing Shampoo 8.45 fl. oz/250ml 857386007051 3305.10.0000 USA N 12
G0002 Flawless Smoothing Shampoo 8.45 fl. oz/250ml 815857014946 3305.10.0000 USA N 12
G0002-EU Flawless Smoothing Shampoo 8.45 fl. oz/250ml 857686007068 3305.10.0000 USA N 12
G0003 Flawless Smoothing Shampoo 2oz./60ml 815857017251 USA N 12
G0004 Moisturizing Shampoo 25oz/750ml - Flawless 815857017480 USA N 6
G0005 Smoothing Shampoo 25oz/750ml - Flawless 815857017503 USA N 6
G0006 For future use 815857016162 N 12
G0007 Flawless Moisturizing Shampoo 2oz/60ml 815857017237 USA N 12
G1001 Flawless Moisturizing Conditioner 8.45 fl. oz/250ml 815857014939 3305.90.0000 USA N 12
G1002 Flawless Smoothing Conditioner 8.45 fl. oz/250ml 815857014953 3305.90.0000 USA N 12
G1003 Flawless Smoothing Conditioner 2oz/60ml 815857017268 USA N 12
G1004 Moisturizing Conditioner 25oz/750ml - Flawless 815857017497 USA N 6
G1005 Smoothing Conditioner 25oz/750ml - Flawless 815857017510 USA N 6
G1007 Flawless Moisturizing Conditioner 2oz/60ml 815857017244 USA N 12
G3001 Flawless Hair Repair Masque 8 fl.oz/237ml 815857014960 3305.90.0000 USA N 12
G3002 Flawless Hair Repair Masque Packette 1oz/30ml 815857017220 3305.90.0000 USA N 100
G3003 Flawless Moisturizing Shampoo/Conditioner Duo Packette .34oz/10ml each 815857017206 3305.10.0000 USA N 100
G3004 Flawless Smoothing Shampoo/Conditioner Duo Packette .34oz/10ml each 815857017213 3305.10.0000 USA N 100
G3005 Flawless Oil Treatment 1oz/30ml 815857017275 USA N 12
G3006 Flawless Edge Control Gel packette .34 fl oz/10ml 815857017459 3305.90.0000 USA N 100
G3007 Flawless Shine Spray 1oz/30ml 815857017749 USA N 12
G5001 Flawless Shine Spray 3.3 fl. oz/100ml 815857015981 3305.90.0000 USA N 12
G5002 Flawless Heat Protection Spray 4.2 fl. oz/125ml 815857015998 3305.90.0000 USA N 12
G5003 Flawless Blow Dry Cream 6.7 fl oz./198ml 815857016001 3305.90.0000 USA N 12
G5003-EU Flawless Blow Dry Cream 6.7 fl oz./198ml 857386007075 3305.90.0000 USA N 12
G5004 Flawless Edge Control Gel 4 fl.oz/118ml 815857016018 3305.90.0000 USA N 12
G5005 Maximum Volume Styling Spray 4.2oz/125ml 815857016117 USA N 12
G5006 Flawless Oil Treatment 3.3 fl. oz/100ml 815857017190 3305.90.0000 USA N 12
G5007 Flawless Next Day Curl Spray 815857012737 USA N 4
G5008 Flawless Styling Curl Cream 8 fl oz. 237ml 815857012744 USA N 4
G6001 Cleansing Conditioner 250ml 815857017183 USA N 12
G7001 Flawless Moisturizing Bundle USA N 1
G7002 Flawless Smoothing Bundle USA N 1
G7003 FUTURE USE USA N 100
G7004 Flawless JCP Stylist Kit USA N 1
GBOOKLET Flawless Brochure Booklet CHINA N 200

Inventory

Item No. In Stock Committed Ordered Available
E0001 3,211 3,211
E0002 1,281 1,281
E0007 340 120 220
E0009 2,409 2,409
E0010 265 265
E0012 775 775
E100000 109 48 61
E100000-A 1,046 458 588
E100001 465 36 429
E100001-A 3,374 458 2,916
E100004 8,480 204 8,276
E100005 4,517 348 4,169
E100008 6,606 978 5,628
E100009 4,640 978 3,662
E100010 1,487 324 1,163
E100011 3,004 714 2,290
E200000 61 24 37
E200000-A 4,858 542 4,316
E200001 1,264 48 1,216
E200001-A 3,906 410 3,496
E200004 7,722 228 7,494
E200005 4,201 264 3,937
E200008 8,086 696 7,390
E200009 6,142 1,170 4,972
E200010 1,195 324 871
E200011 3,277 450 2,827
E300000-A 2,990 134 2,856
E300001 40 60 -20
E300001-A 5,422 398 5,024
E300002 6 6
E300002-A 1,047 506 541
E300003 4,416 4,416
E300003-A 11,629 1,334 10,295
E300004 53,955 53,955
E300004-20 1,380 1,380
E300004-30 386 386
E300004-5 96 96
E300005 17,667 17,667
E300006 1,372 97 1,275
E300007 4,891 36 4,855
E300009 3,457 36 3,421
E300010 9,847 600 9,247
E300011 13,245 600 12,645
E300012 10,202 10,202
E300013 10,547 600 9,947
E300014 10,067 600 9,467
E300015 16,888 16,888
E300017 2,908 133 2,775
E500000 934 1 933
E500000-1 3,371 3,371
E600000-1 191 191
E600000-2 45 45
E600000-3 72 72
E600000-4 86 86
E600001 497 497
E600002 528 528
E6000021 15 15
E600003 990 990
E600005 195 195
E600006 209 209
E600007-1 613 613
E600007-2 97 97
E600008 3 3
E600015 385 385
E600016 240 240
E600017 384 384
E600018 223 223
E600019-1 923 923
E600019-2 174 174
E600022-1 18 18
G0001 11,205 24 11,181
G0002 6,300 12 6,288
G0004 5,222 25 5,197
G0005 5,816 6 5,810
G1001 12,031 24 12,007
G1002 6,478 12 6,466
G1004 5,548 24 5,524
G1005 6,081 6 6,075
G3001 3,920 48 3,872
G3002 31,172 25 31,147
G3003 9,316 9,316
G3004 9,738 9,738
G3006 637 25 612
G5001 3,664 3,664
G5002 6,044 24 6,020
G5003 6,319 24 6,295
G5004 6,632 12 6,620
G5006 4,974 24 4,950
G5008 316 1,272 -956
G5011 14 2,076 -2,062
G7005 130 130
G7006 138 138
G7010 806 1 805
G9000 2,719 2,719
G9007 596 596
GB600 200 200
GBOOKLET 1,426 1,426
GBROCHURE-18 175 175
GH600 168 168
GUECOM-CC 5,147 25 5,122
GUECOM-CSC 2,541 2,541
GUECOM-ENV 2,200 2,200
GUECOM-HAIRFAVS 1,158 1,158
GUECOM-I 25,334 60 25,274
GUECOM-LOVEDIT 2,500 2,500
GUECOM-S 7,882 20 7,862
GUECOM-TC 7,222 7,222