{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["WERCS Questionnaire","New Item Form","CPSIA Supplier Letter","CPSIA Exclusions","New Item Selection Form","NIS SOP"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":31,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WERCS Questionnaire","index":0,"n_rows":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[[18,0,18,4],[1,1,1,7],[12,0,12,4],[14,0,14,13],[7,0,10,13],[3,0,4,13],[36,2,36,11],[56,0,58,13],[60,0,61,13],[63,0,67,13],[22,0,23,13],[25,0,29,13],[30,0,30,3],[34,2,34,11],[69,0,71,13],[39,0,39,13],[41,6,41,8],[43,0,43,13],[45,0,45,5],[45,6,45,13],[49,0,49,10],[51,0,51,13],[53,0,54,13],[94,0,94,13],[73,0,74,13],[76,0,76,13],[78,0,79,13],[81,0,85,13],[87,0,88,13],[90,0,90,13],[92,0,92,13]]}
[]
[null,"WERCSmart ASSESSMENT FOR NEW ITEM FORM"]
[]
["By filling out this assessment you certify that all information is truthful, accurate, and that no material information has been omitted."]
[]
[]
["Is this item chemical containing (including aerosols or bag-on-valve)?   ",null,null,null,null,null,null,null,"YES",null,null,"NO"]
["(including, but not limited to over-the-counter pharmaceutical products, nutritional supplements, personal care products, household products (pesticides, cleaners, air fresheners, etc.), or select food items (vitamin water, energy bars, liquid water enhancers, cooking oil, aerosols/bag-on-valve items, etc.) Please see below for extended list.)"]
[]
[]
[]
[]
["Does this item contain or is it a battery?   ",null,null,null,null,null,null,null,"YES",null,null,"NO"]
[]
["Does this item contain or is it a light bulb/lamp (fluorescent/incandescent/neon/LED/halogen)? "]
[]
[null,null,null,null,null,null,null,null,"YES",null,null,"NO"]
[]
["Is this item an electronic with a circuit board?   ",null,null,null,null,null,null,null,"YES",null,null,"NO"]
[]
[]
[]
["It is mandatory that one of the three bolded areas below must be filled out before item can be entered:"]
[]
[]
["If you answered “yes” to one or more questions your item needs to be entered into WERCSmart. Please do that now through the regulatory compliance link on cvssuppliers.com, or click the link below to be redirected to the WERCSmart home page. Once you have completed entry a WERCS WPS identification number will be issued."]
[]
[]
[]
[]
["https://secure.supplierwercs.com/"]
[]
[" Provide that number here:"]
[]
[null,"WPS ID"]
[]
[null,"CVS ID"]
[]
[]
["If all answers are “no” then this product is not being entered into WERCSmart at this time."]
[]
[null,null,null,null,null,null,"Check box:  "]
[]
["Please see below for further details on product types that require entry into WERCSmart."]
[]
["Contact the CVS WERCSmart team with any questions.",null,null,null,null,null,"wercsinfo@cvscaremark.com"]
[]
[]
[]
["The Following product types require entry into WERCSmart."]
[]
["Arts & Crafts – Clay, Fabric Dye, Glue, Paint, Plaster "]
[]
["Automotive – Antifreeze, Brake Fluid, Car or Boat Wash, Car or Boat Wax, Degreaser, Fuel, Fuel Additive, Gasoline, Hydraulic Fluid, Polish, Refrigerant, Tire and Wheel Cleaner, Transmission Fluid, Windshield Washer Fluid "]
[]
[]
["Cleaning Supplies – Air Freshener, Bathroom and Tile Cleaner, Bleach, Carpet Cleaner, Degreaser, Deodorizer, Dishwasher Detergent, Disinfectant, Fabric Softener, Floor Polish and Wax, Glass Cleaner, Laundry Detergent, Polish, Oven Cleaner, Sanitizer, Stain Remover, Water Softener, Wood Cleaner"]
[]
[]
[]
["Grocery – Cooking Oil, Food Coloring, Energy Bars, Food Item Dispensed by Compressed Gas, Vitamin Drinks, Water or Food Flavor Enhancers"]
[]
[]
["Health & Beauty – Adhesives, Antiperspirant, Astringent, Cleansing Wipes, Blush, Body Lotion or Cream, Body Oil, Body Wash, Bronzer, Bubble Bath, Conditioner, Cosmetics, Dental Whitening Products, Deodorant, Eye Drops, Eyeliner, Floss, Foundation, Fragrance, Hair Colorant, Hair Styling Products, Hand Sanitizer, Lip Balm, Lip Gloss, Make-up Remover, Nail Polish, Nail Polish Remover, Shampoo, Shaving Cream or Gel, Soap, Sun Care, Sunscreen, Temporary Tattoos, Toothpaste"]
[]
[]
[]
[]
[]
["Home Improvement – Adhesives, Anti-Stain, Asphalt, Bonding Agent, Butane, Caulking, Cement, Deck Cleaner, Etching Chemical, Faux Finishing Coating, Fire Extinguishing Agent, Glue, Lubricant, Paint, Paint Strippers, Paint Thinners, Primers, Sealants, Shellacs, Stains, Tape, Varnish"]
[]
[]
[]
["Lawn & Garden – Algicide, Animal Deterrent, Charcoal, Fertilizer, Fungicide, Herbicide, Insecticide, Mulch, Pest Control, Pesticide, Plant Food, Pool Chemicals, Pest Repellant, Trap or Bate Station, Weed Killer"]
[]
[]
["Nutritional Supplements – Energy or Nutrition Bars, Beverages, or Powders, Nutritional Supplement, Vitamin"]
[]
["Pet Care – Aquarium Maintenance, Flea or Tick Repellant, Litter for Pets, Pet Shampoo, Pet Shampoo with Pest Control, Taste Deterrent, Training Aid Repellant"]
[]
[]
["Pharmacy – All Over-the-Counter Pharmaceutical Products, Analgesic, Antacid, Antibiotic, Antifungal, Condom, Contraception, First Aid Kits or Supplies, Glucose Test Strips, Herbal or Dietary Supplement, In-Vitro Diagnostic, Latex Gloves, Laxative, Medicinal Liquids (cough medicine, eye drop, ear drop, nasal spray, inhaler), Medicinal Lozenges, Pills, or Capsules, Nicotine Replacement, Patches (heated and/or medicated), Stool-Softener, Suppository, Thermometer"]
[]
[]
[]
[]
[]
["Sporting Goods – Ammunition, Animal Attractant, Freezer Pack, Gun Lubricant, Heating Packs, Lantern, Lighter Fluid, Paint Balls, Pepper Spray, Signal Flare, Water Sanitizer Kits"]
[]
[]
["Stationery – Chalk, Correction Fluid, Crayon, Glue, Inks, Marker, Pen, Writing Instrument"]
[]
["Toys – Bubble Solution, Caps, Engines for Model Rockets, Silly String, Water-filled Toy"]
[]
["Other – Anti-Static Product, Candle, Firelog, Fireworks, Glow Sticks, Photographic Chemical"]

{"sheet":"New Item Form","index":1,"n_rows":32,"n_cols":73,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,39,2,40],[3,25,4,29],[2,30,2,38],[1,50,1,61],[2,50,2,61],[5,50,8,61],[5,25,5,29],[6,25,8,29],[6,30,8,45],[1,46,1,49],[1,30,1,45],[2,46,2,49],[3,46,4,49],[3,30,4,45],[10,46,10,59],[3,50,4,61],[2,41,2,45],[10,61,11,61],[10,60,11,60],[11,33,11,40],[10,42,11,42],[10,20,11,21],[10,29,11,30],[10,31,10,40],[10,4,10,15],[5,30,5,45],[12,0,13,0],[10,2,11,2],[10,41,11,41],[10,43,11,43],[10,45,11,45],[10,44,11,44],[10,1,11,1],[10,16,10,18],[10,22,10,27],[3,18,4,24],[5,1,8,15],[3,16,4,17],[5,16,5,17],[6,16,8,17],[1,16,2,17],[6,18,8,24],[1,18,2,24],[11,13,11,15],[11,4,11,12],[0,15,0,17],[10,28,11,28],[1,25,1,29],[2,25,2,29],[10,19,11,19],[9,1,9,15],[1,1,3,15],[5,18,5,24]]}
[]
[null,"Supplier Instructions:  Fill in blue columns (ONLY).  Read the instructions at the head of each column and follow them carefully.  Enter your information accordingly and return your forms as soon as possible.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCM Name &\nApproval Date",null,null,null,null,null,null,null,null,"DSD Vendor Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Competitive Retails"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DSD Vendor #",null,null,null,null,null,null,null,null,null,null,null,null,null,"Parent Corp ",null,null,null,null,null,null,"Guaranteed Sale (Y/N)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Submitted By & Date",null,null,null,null,null,null,null,null,"DSD Vendor Contact Name and Phone Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Item MSDS",null,null,null,"Creator to obtain MSDS from supplier / Required for all new items"]
[]
[null,"Consumer Product Safety Improvement Act (CPSIA) Requirments for ALL new item submissions: Beginning May 1st, 2011 all new items being submitted to CVS/Caremark must be identified as either being subject to CPSIA or not. Please note the first 2 fields on the NI form highlighted in green and labled \"CPSIA Required\" and \"IF CPSIA Required\". Next to each new item submission the supplier must fill out the first field and both fields if CPSIA is required. If the product is subject to CPSIA regulations and you are the US manufacturer or importer of record a Certificate of Conformity must be submitted for all items falling subject to the act. If you are NOT the US manufacturer of importer of record you must be able to physically provide a certificate of conformity or provide a link to the certificate of conformity within 24 hours of CVS request. Failure to fill out these fields and provide proper documentation will result in the rejection of the new items submitted.Additional information about CPSIA can be found at the following link:  http://www.cpsc.gov/about/cpsia/cpsia.html, and on the CPSIA Facts tab included in this form. If you have additional questions about the requirements, please contact Celeste Lester at clester@cvs.com or (401) 770-4109",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Submitted by Email",null,null,null,null,null,null,null,null,"Effective Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Consignment vendor must be signed off by Jeff Puddington (Y/N)",null,null,null,null,null,null,null,null,"Rejected Reason"]
[]
[]
[null,"WERCSmart Assessment for ALL new items is required. Please note that the second field is required to be filled out with either a WPS ID, a CVS ID, or a NO based on the answers to the questions on the WERCS Questionnaire tab of this form. "]
[null,"CPSIA-\nRequired Field","WERCSmart-\nRequired Field",null,"UPC INFORMATION",null,null,null,null,null,null,null,null,null,null,null,"BONUS ITEMS ONLY",null,null,null,"Please select from drop down box",null,"BEVERAGE ITEMS ONLY",null,null,null,null,null,"How many units per pack?  Example-4pk","For items such as Baby Formula that can be converted to a different form than how they are sold.  This is the amount of fluid ounces the item makes once it is mixed.",null,"PRICING INFORMATION",null,null,null,null,null,null,null,null,null,null,"View Comment for items that do not require an MSDS","Select type of Expiration Date or Date Code on product.  If item is not perishable, please select, \"DOES NOT EXPIRE\"","Enter # of Weeks","Example: MM/DD/YYYY","DIMENSIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,"For items that have an electronic screen greater than 4\"","Select type of Facts Box on Product.  If there is no Facts Box on product, please select NONE"]
[null,null,null,null,"Universal Product Code-UPC",null,null,null,null,null,null,null,null,"Item Description-Abbreviate when possible\nwhile maintaining a clear & accurate description.  ",null,null,"Define the type of Bonus that this item is ","After the promo, can the bonus be broken apart and sold individually?","The base UPC that the bonus should be linked to",null,null,null,"Select code from drop down list. Place cursor in cell below to view codes.","Select code from drop down list. Place cursor in cell below to view codes.","Item weight: total ounces, total gallons, total liters, etc.","Select code from drop down list. Place cursor in cell below to view codes.",null,null,null,null,null,"Cost of the item per Retail Unit","Cost of the Case Unit","Retails should be determined by PCM",null,null,null,null,null,null,null,null,null,null,null,null,"Example: Month/Day/Year","Height of Retail Unit","Width of Retail Unit","Length (Depth) of Retail Unit","Select Unit of Measure from Drop Down Box","Weight of Retail Unit","Select Unit of Measure from Drop Down Box","Enter Amount of Shelf Pack and Case Pack","Height of Case","Width of Case ","Length (Depth) of Case","Select Unit of Measure from Drop Down Box","Weight of Case","Select Unit of Measure from Drop Down Box"]
[null,"CPSIA \n\nPlease select from drop box","WERCSmart Assessment for ALL new items is required. Please note that this field is required to be filled out with either a WPS ID, a CVS ID, or a NO based on the answers to the questions on the WERCS Questionnaire tab of this form. ","Item Number","MHE","UPC Format","UPC Type","UPC Code\n\nMust include lead and check digit","Item Unique or Link UPCs","Flavor Code ","Flavor Code or Link to UPC/SKU#","Ethnic Item (Y / N)","Brand Name","Item Description\n(Character Length including spaces-60)","Shelf Label Description\n(Character Length including spaces-18)","Register Description\n(Character Length including spaces-14)","Bonus Type","Break Apart For Ind. Sale (Y / N)","Supplier Regular Item UPC","Consumer Size Quantity","Consumer Size UOM","Glass Container (Y / N)","Beverage Type\n(Milk, Juice, Wine, etc)","Container Type\n(Cardboard, Metal, Plastic, etc)","Content Amount\n(12, 750 etc)","Content Unit of Measure\n(GL, QT, PT, OZ, ML, LT)","% of Fruit Juice","Consumable Alcohol Content (Not Proof) %","Multi Pack Qty","Reconstituted Quantity","Reconstituted UOM","Base Unit Cost \n(Up to 3 Digits after the               Decimal Point)","Case Cost","CVS Retail\nOahu","GP%","CVS Retail\nKauai","GP%","CVS Retail\nBig Island (BI)","GP%","CVS Retail\nMaui","GP%"," Pre priced Item (Y/N)","MSDS Required (Y/N)","Date Code Type","Shelf Life Weeks","Date Code Format","Date Code Format Description","Item Height","Item Width","Item Length (depth)","Item Dimension UOM","Item Weight","Item Weight UOM","Shelf Pack/Case Pack","Case Height","Case Width","Case Length (depth)","Case Dimension UOM","Case Weight","Case Weight UOM","E-Waste (Y / N)","Facts Box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$f":"1-(AF14/AH14)","v":{"$error":"#DIV/0!"}},null,{"$f":"1-(AF14/AJ14)","v":{"$error":"#DIV/0!"}},null,{"$f":"1-(AF14/AL14)","v":{"$error":"#DIV/0!"}},null,{"$f":"1-(AF14/AN14)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA - Each",null,null,"A = Wine - Fruit Varietals",null,null,"C = Cardboard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$f":"1-(AF15/AH15)","v":{"$error":"#DIV/0!"}},null,{"$f":"1-(AF15/AJ15)","v":{"$error":"#DIV/0!"}},null,{"$f":"1-(AF15/AL15)","v":{"$error":"#DIV/0!"}},null,{"$f":"1-(AF15/AN15)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAL - Gallon",null,null,"B = Ale/Beer/Malt",null,null,"G = Glass"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HC - 100 Count",null,null,"C = Wine Cooler",null,null,"H = High Density Plastic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QT - Quart",null,null,"D = Wine Non Fortified",null,null,"M = Metal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YD - Yard",null,null,"E = Veg Juice",null,null,"P = Plastic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z52 - Usage",null,null,"F = 100% Fruit Juice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OZ - Ounce",null,null,"H = Healthy Milkshakes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K = Fortified Wine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L = Spirits - Unmixed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M = Milk Unflavored"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N = Milk Flavored",null,null,null,"No, not subject to CPSIA regulations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R = Spirits Ready to Drink",null,null,null,"Yes, I am the manufacturer or importer of record and I have attached the Certificate of Conformity."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S = Soft Drinks - Carbon",null,null,null,"Yes, I am not the manufacturer or importer of record but I will still be able to provide CVS a Certificate of Conformity within 24 hours of request. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T = Soft Drinks Non-Carbon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U = Water Flavored, Not Sweetened"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V = Water Carbonated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W = Water Plain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y = Water Flavored, Sweetened"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Z = Garnishes/Mixers"]

{"sheet":"CPSIA Supplier Letter","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CPSIA Exclusions","index":3,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["CPSIA Excluded Categories"]
["Categories that are excluded from CPSIA are as follows:"]
["- Cosmetics"]
["- Foods"]
["- Drugs"]
["- Dietary Supplement/Vitamins"]
["- Medical Devices"]
[]
["*** NOTE - There are some instances where an item in one of these categories is still subject to CPSIA regulations. For instance, if a candy item comes"]
["with a toy, the toy would still require testing."]

{"sheet":"New Item Selection Form","index":4,"n_rows":29,"n_cols":20,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,8,6,10],[4,14,5,15],[6,14,7,14],[6,16,7,16],[6,17,7,17],[27,0,27,19],[28,0,28,19],[4,16,5,17],[4,18,7,18],[4,19,7,19],[5,2,5,4],[5,5,5,7],[5,8,5,10],[6,15,7,15],[1,1,1,4],[1,8,1,13],[2,1,2,4],[2,8,2,13],[4,0,6,1],[6,11,6,13],[5,11,5,13],[6,2,6,4],[6,5,6,7]]}
[]
["Company:",null,null,null,null,null,null,"E-mail:"]
["Contact Person:",null,null,null,null,null,null,"Phone #:"]
[]
["Item Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast (avg/monthly reg. sales)*",null,"Item to be Replaced**",null,"First Available Date","Available on NI (Y/N)"]
[null,null,"Oahu Vendor #/Name",null,null,"BI Vendor #/Name",null,null,"Maui Vendor #/Name",null,null,"Kauai Vendor #/Name"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units","Dollars ($)","UPC#","Item Description"]
["UPC#","Item Description","Cost/unit","Retail/unit","GP%","Cost/unit","Retail/unit","GP%","Cost/unit","Retail/unit","GP%","Cost/unit","Retail/unit","GP%"]
[null,null,null,null,{"$f":"IF(C9,1-(C9/D9),\"\")","v":""},null,null,{"$f":"IF(F9,1-(F9/G9),\"\")","v":""},null,null,{"$f":"IF(I9,1-(I9/J9),\"\")","v":""},null,null,{"$f":"IF(L9,1-(L9/M9),\"\")","v":""},null,{"$f":"D9*O9","v":0}]
[null,null,null,null,{"$f":"IF(C10,1-(C10/D10),\"\")","v":""},null,null,{"$f":"IF(F10,1-(F10/G10),\"\")","v":""},null,null,{"$f":"IF(I10,1-(I10/J10),\"\")","v":""},null,null,{"$f":"IF(L10,1-(L10/M10),\"\")","v":""},null,{"$f":"D10*O10","v":0}]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
[null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,0]
["          * If presenting for promo items, please provide Promotional forecast"]
["          **Item to be Replaced must belong to same Category and Subcategory i.e. Stomach Remedies/Antacid can not replace a Stomach Remedies/Laxative item"]

{"sheet":"NIS SOP","index":5,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,0,25,1],[0,0,0,1],[2,0,2,1],[3,0,3,1],[10,0,10,1],[19,0,19,1],[22,0,22,1]]}
["Fill in only the uncolored (white) fields.  All yellow fill fields are for Longs Internal Use Only."]
[]
["If you are a Manufacturer, Manufacturer/Distributor or Broker, you are required to supply the vendor #'s and cost of each of the Distributors servicing each island."]
["If you are a Distributor, you will only fill in your cost for your island."]
[]
["Field","Explanation"]
["Company","Company who is submitting these items for new item consideration. "]
["Contact Person","Person who we (Longs) would contact, within the company submitting these items for new item consideration, should we need additional information."]
["Email","Email of the \"Contact Person\"."]
["Phone #","Phone number of the \"Contact Person\"."]
["Item Information"]
["     Oahu Vendor #","Vendor # of the Oahu Vendor."]
["     BI Vendor #","Vendor # of the Big Island Vendor."]
["     Maui Vendor #","Vendor # of the Maui Vendor."]
["     Kauai Vendor #","Vendor # of the Kauai Vendor."]
["     UPC #","UPC # of the new item."]
["     Item Description","Item Description of the new item."]
["     Cost/Unit","Each cost per unit."]
["     Retail/Unit","Retail price per unit (to be filled in by the Category Manager)"]
["     Forecast (avg/monthly reg. sales)*"]
["     Units","Estimated monthly unit sales based upon projected store count (agreed to by the supplier and the CM)."]
["     Dollars ($)","Estimated monthly dollars ($) based upon projected units (agreed to by the supplier and the CM)."]
["Item to be Replaced**"]
["     UPC #","UPC # of the suggested item being replaced by the agreed upon new item."]
["     Item Description","Item Description of the suggested item being replaced by the agreed upon new item."]
[]
["First Available Date","The date the item is available to be purchased by Longs."]
["Available on NI (Y/N)","Is this item available on all islands?  \"Yes\" or \"No\"."]