{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Introduction","Product","Sheet3","Sheet4","Sheet5"],"not_rendered":{"macros":1,"defined_names":87,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":10,"n_cols":140,"rows_kept":10}
["Product Name","Brand","Subbrand","Manufacturer","TP Number","Package Type","Package Type, if Other","Product Quantity Numeric Value","Units (Product Quantity)","Units, if Other (Product Quantity)","Product Quantity Mass Numeric Value","Units (Product Quantity Mass)","Units, if Other (Product Quantity Mass)","Characterizing Flavor","Characterizing Flavor, If Flavored","Tobacco Cut/Particle Size Description  ","Tobacco Cut Style","Tobacco Cut/Particle Size Numeric Value","Units (Tobacco Cut/Particle Size)","Portion Count Numeric Value","Units (Portion Count)","Units, if Other (Portion Count)","Portion Mass Numeric Value","Units (Portion Mass)","Length Description","Length Description, if Other","Length Numeric Value","Units (Length)","Width Numeric Value","Units (Width)","Diameter Description","Diameter Format","Diameter Numeric Value","Units (Diameter)","Portion Thickness Numeric Value","Units (Portion Thickness)","Filter Ventilation","E-liquid Volume","E-liquid Volume Units","Nicotine Concentration","Nicotine Concentration Units","If mg/unit specify Unit (Nicotine Concentration)","Nicotine Source","PG Numeric Value","VG Numeric Value","Wattage Numeric Value","Units (Wattage)","Battery Capacity Numeric Value","Units (Battery Capacity)","Tip Type","Tip Type, if Other","Wrapper Material","Wrapper Material, if Other","Number of Hoses ","Source of Energy ","Source of Energy, if Other","Height Numeric Value","Units (Height)","Additional Properties (if Applicable)","Dates When Commercially Marketed in US\nHas this ever been marketed in the US? ","Dates When Commercially Marketed in US\n1st commercial market date (mm/dd/yyyy)","Dates When Commercially Marketed in US\nIs product currently marketed in the US?",{"$nulls":14},"Predicate","Original/Predicate STN PD Number","Product Name","Brand","Subbrand","Manufacturer","TP Number","Package Type","Package Type, if Other","Product Quantity Numeric Value","Units (Product Quantity)","Units, if Other (Product Quantity)","Product Quantity Mass Numeric Value","Units (Product Quantity Mass)","Units, if Other (Product Quantity Mass)","Characterizing Flavor","Characterizing Flavor, If Flavored","Tobacco Cut/Particle Size Description  ","Tobacco Cut Style","Tobacco Cut/Particle Size Numeric Value","Units (Tobacco Cut/Particle Size)","Portion Count Numeric Value","Units (Portion Count)","Units, if Other (Portion Count)","Portion Mass Numeric Value","Units (Portion Mass)","Length Description","Length Description, if Other","Length Numeric Value","Units (Length)","Width Numeric Value","Units (Width)","Diameter Description","Diameter Format","Diameter Numeric Value","Units (Diameter)","Portion Thickness Numeric Value","Units (Portion Thickness)","Filter Ventilation","E-liquid Volume","E-liquid Volume Units","Nicotine Concentration","Nicotine Concentration Units","If mg/unit specify Unit (Nicotine Concentration)","Nicotine Source","PG Numeric Value","VG Numeric Value","Wattage Numeric Value","Units (Wattage)","Battery Capacity Numeric Value","Units (Battery Capacity)","Tip Type","Tip Type, if Other","Wrapper Material","Wrapper Material, if Other","Number of Hoses ","Source of Energy ","Source of Energy, if Other","Height Numeric Value","Units (Height)","Additional Properties (if Applicable)","Dates When Commercially Marketed in US\nHas this ever been marketed in the US? ","Dates When Commercially Marketed in US\n1st commercial market date (mm/dd/yyyy)","Dates When Commercially Marketed in US\nIs product currently marketed in the US?"]
["Enter Product Name, (or other commercial name(s) used in commercial distribution). The name listed here will be the name of the new products that will be listed in FDA correspondence. ","Enter Brand Name - Brand means a variety of tobacco product distinguished by the tobacco used, tar content, nicotine content, flavoring used, size, filtration, packaging, logo, registered trademark, brand name(s), identifiable pattern of colors, or any combination of such attributes. (this is from 1107.12 Definitions).","Enter Subbrand Name - Subbrand is a variety of tobacco product that is part of a larger, parent brand but has its own distinct identity, distinguished by the tobacco used, tar content, nicotine content, flavoring used, size, filtration, packaging, logo, registered trademark, brand name(s), identifiable pattern of colors, or any combination of such attributes. It may operate under the umbrella of the parent brand but may also have its own unique name, logo, and marketing strategy. ","Enter Manufacturer Name - means any person, including any repacker or relabeler, who (1) Manufactures, fabricates, assembles, processes, or labels a tobacco product; or (2) Imports a finished tobacco product for sale or distribution in the United States. (this is from 1100.202 definitions).","This is the Tobacco Product Number issued from TRLM-NG when registration and listing is completed.","Select from drop-down list the packaging of the product (e.g., Soft Pack, Cartridge).","Only use if \"Other\" was selected for Package Type.","Provide the product quantity as a number, maximum of 7 digits.","Select product units from drop-down list for amount or number of products contained in the package (e.g., Bottles, Leaves).","Only use if “Other” was selected for Product Quantity Units.","Provide product quantity mass as a number, maximun of 7 digits.","Select product units from drop-down list for amount or number of products contained in the package (e.g., Milligrams, Grams).",null,"Select product flavor from the drop-down list (Menthol, Tobacco, Flavored, Unflavored).","Only use if “Flavored” was selected for Characterizing Flavor.",null,"Select the tobacco cut style (e.g., Standard Cut, Pressed Cut) from drop-down list.",null,null,"Provide portion count as a number, maximum of 7 digits.","Select from the drop-down list the unit of portions in the product (e.g., count, E-Cigarette, Tablet).","Only use if “Other” was selected for Portion Count Units.  ","Provide portion mass as a number, maximum of 7 digits.","Select product units from drop-down list for amount or number of products contained in the package (e.g., Milligrams, Grams).","Select from the drop-down list length description of the product (e.g., King, Long).  ","Only use if “Other” was selected for Length Description.  ","Provide length of the product as a number, maximum of 7 digits.","Select unit of length from drop-down list of the product (e.g., Millimeters, Centimeters).","Provide width of the product as a number, maximum of 7 digits.","Select from the drop-down list unit of the width of the product (e.g., Millimeters, Centimeters).","Select from the drop-down list description of the diameter of the product (e.g. Regular, Wide).","Select from the drop-down list format of the diameter (e.g., Circumference).","Provide diameter of the product as a number, maximum of 7 digits.","Select from the drop-down list unit of the diameter of the product (e.g., Millimeters, Centimeters).","Provide the portion thickness of the product as a number, maximum of 7 digits.","Select from the drop-down list unit of the portion thickness of the product (e.g., Millimeters, Centimeters).","Enter the filter ventilation (e.g., 0%, 25%).","Enter the E-liquid volume as a number, maximum of 7 digits.","Select from the drop-down list e-liquid volume units (e.g., Milliliters, Fluid Ounces).","Provide the nicotine concentration of the product as a number, maximum of 7 digits.","Select from the drop-down list nicotine concentration units (e.g., %W/W, mg/unit).","Only use if “mg/unit” was selected for Nicotine Concentration Units.","Select from the drop-down list nicotine source (e.g., Tobacco, Non-Tobacco, Both or None).","Enter as a number the percentage of propylene glycol in the PG/VG ratio, maximum of 7 digits.","Enter as a number the percentage of vegetable glycerin in the PG/VG ratio, maximum of 7 digits.","Provide the wattage as a number, maximum of 7 digits.","Select from drop-down list units of wattage (e.g., Milliwatts, Volts).","Provide battery capacity as a number, maximum of 7 digits.","Select from drop-down list units of battery capacity (e.g., Watt, mAh).","Select from drop-down list tip type material (e.g., Wood, Paper).","Only use if “Other” was selected for Tip Type. Enter the tip material type.","Select from drop-down list Wrapper Material (e.g., Tobacco Leaf, Paper).","Only use if “other” was selected for Wrapper Material.","Provide the number of hoses as a number, maximum of 2 digits.","Select from the drop-down list the product source of energy (e.g., Charcoal, Battery).","Only use if “Other” was selected for Source of Energy. Enter product source of energy.","Provide the height of the product as a number, maximum of 7 digits.","Select from the drop-down list units for the height of the product (e.g., Millimeters, Centimeters).","Enter any additional relevant product property information.","This question is asking if your new tobacco product has ever been marketed in the United States. Answer \"yes\" if this new tobacco product has been marketed in the United States in the past or today.","If your new tobacco product has been marketed in the United States, provide the date it was first commercially marketed in the US.","If your new tobacco product is currently marketed in the United States (i.e., as of the date you are submitting this form and application), answer \"yes\". ",{"$nulls":15},"Enter Predicate, including brand and sub-brand (or other commercial name(s) used in commercial distribution).","Enter Product Name, (or other commercial name(s) used in commercial distribution). The name listed here will be the name of the new products that will be listed in FDA correspondence. ","Enter Brand Name - Brand means a variety of tobacco product distinguished by the tobacco used, tar content, nicotine content, flavoring used, size, filtration, packaging, logo, registered trademark, brand name(s), identifiable pattern of colors, or any combination of such attributes. (this is from 1107.12 Definitions).","Enter Subbrand Name - Subbrand is a variety of tobacco product that is part of a larger, parent brand but has its own distinct identity, distinguished by the tobacco used, tar content, nicotine content, flavoring used, size, filtration, packaging, logo, registered trademark, brand name(s), identifiable pattern of colors, or any combination of such attributes. It may operate under the umbrella of the parent brand but may also have its own unique name, logo, and marketing strategy. ","Enter Manufacturer Name - means any person, including any repacker or relabeler, who (1) Manufactures, fabricates, assembles, processes, or labels a tobacco product; or (2) Imports a finished tobacco product for sale or distribution in the United States. (this is from 1100.202 definitions).","This is the Tobacco Product Number issued from TRLM-NG when registration and listing is completed.","Select from drop-down list the packaging of the product (e.g., Soft Pack, Cartridge).","Only use if \"Other\" was selected for Package Type.","Provide the product quantity as a number, maximum of 7 digits.","Select product units from drop-down list for amount or number of products contained in the package (e.g., Bottles, Leaves).","Only use if “Other” was selected for Product Quantity Units.","Provide product quantity mass as a number, maximun of 7 digits.","Select product units from drop-down list for amount or number of products contained in the package (e.g., Milligrams, Grams).",null,"Select product flavor from the drop-down list (Menthol, Tobacco, Flavored, Unflavored).","Only use if “Flavored” was selected for Characterizing Flavor.",null,"Select the tobacco cut style (e.g., Standard Cut, Pressed Cut) from drop-down list.",null,null,"Provide portion count as a number, maximum of 7 digits.","Select from the drop-down list the unit of portions in the product (e.g., count, E-Cigarette, Tablet).","Only use if “Other” was selected for Portion Count Units.  ","Provide portion mass as a number, maximum of 7 digits.","Select product units from drop-down list for amount or number of products contained in the package (e.g., Milligrams, Grams).","Select from the drop-down list length description of the product (e.g., King, Long).  ","Only use if “Other” was selected for Length Description.  ","Provide length of the product as a number, maximum of 7 digits.","Select unit of length from drop-down list of the product (e.g., Millimeters, Centimeters).","Provide width of the product as a number, maximum of 7 digits.","Select from the drop-down list unit of the width of the product (e.g., Millimeters, Centimeters).","Select from the drop-down list description of the diameter of the product (e.g. Regular, Wide).","Select from the drop-down list format of the diameter (e.g., Circumference).","Provide diameter of the product as a number, maximum of 7 digits.","Select from the drop-down list unit of the diameter of the product (e.g., Millimeters, Centimeters).","Provide the portion thickness of the product as a number, maximum of 7 digits.","Select from the drop-down list unit of the portion thickness of the product (e.g., Millimeters, Centimeters).","Enter the filter ventilation (e.g., 0%, 25%).","Enter the E-liquid volume as a number, maximum of 7 digits.","Select from the drop-down list e-liquid volume units (e.g., Milliliters, Fluid Ounces).","Provide the nicotine concentration of the product as a number, maximum of 7 digits.","Select from the drop-down list nicotine concentration units (e.g., %W/W, mg/unit).","Only use if “mg/unit” was selected for Nicotine Concentration Units.","Select from the drop-down list nicotine source (e.g., Tobacco, Non-Tobacco, Both or None).","Enter as a number the percentage of propylene glycol in the PG/VG ratio, maximum of 7 digits.","Enter as a number the percentage of vegetable glycerin in the PG/VG ratio, maximum of 7 digits.","Provide the wattage as a number, maximum of 7 digits.","Select from drop-down list units of wattage (e.g., Milliwatts, Volts).","Provide battery capacity as a number, maximum of 7 digits.","Select from drop-down list units of battery capacity (e.g., Watt, mAh).","Select from drop-down list tip type material (e.g., Wood, Paper).","Only use if “Other” was selected for Tip Type. Enter the tip material type.","Select from drop-down list Wrapper Material (e.g., Tobacco Leaf, Paper).","Only use if “other” was selected for Wrapper Material.","Provide the number of hoses as a number, maximum of 2 digits.","Select from the drop-down list the product source of energy (e.g., Charcoal, Battery).","Only use if “Other” was selected for Source of Energy. Enter product source of energy.","Provide the height of the product as a number, maximum of 7 digits.","Select from the drop-down list units for the height of the product (e.g., Millimeters, Centimeters).","Enter any additional relevant product property information.","This question is asking if your predicate tobacco product has ever been marketed in the United States. Answer \"yes\" if this predicate tobacco product has been marketed in the United States in the past or today.","If your predicate tobacco product has been marketed in the United States, provide the date it was first commercially marketed in the US.","If your predicate tobacco product is currently marketed in the United States (i.e., as of the date you are submitting this form and application), answer \"yes\". "]
["Limit to 500 characters including spaces.","Limit to 500 characters including spaces.","Limit to 500 characters including spaces.","Limit to 500 characters including spaces.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If possible, avoid using \"Other\".","Enter a description of the package type for the product.","Provide a single value, cannot be a range.","If possible, avoid using “Other”.","Enter a description of the units for the product quantity.","Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value.",null,"If \"Flavored\" selected, enter the concise flavor description in the next column.","Enter the Flavor that is identified on the package and labelling.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,null,"Provide a single value, cannot be a range.","If possible, avoid using “Other”.","Enter description of the units for the Portion count.","Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value.","If possible, avoid using “Other”.","Enter a description of the length of the product.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value. ","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Only enter a number up to 100.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value. ","Enter only unit for the nicotine concentration units.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","Provide a single value, cannot be a range.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","If possible, avoid using “Other”.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If possible, avoid using “other”.","Enter wrapper material type.","Provide a single value, cannot be a range.\n","If possible, avoid using “Other”.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Maximum of 5,000.","Answer \"yes\" if this new tobacco product was previously marketed in the United States but is no longer marketed in the United States. ","If your new tobacco product has never been marketed in the United States, leave this field blank.","If your new tobacco product was previously marketed in the United States but you stopped marketed (i.e., it is no longer marketed in the US), answer \"no\". ",{"$nulls":15},"Limit to 500 characters including spaces.","For predicate products that are pre-existing tobacco product (PTP) determined or Claimed PTP provide the name as of February 15, 2007. For predicate products that are Previously Found SE provide the name as it appears in the marketing order.","Limit to 500 characters including spaces.","Limit to 500 characters including spaces.","Limit to 500 characters including spaces.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If possible, avoid using \"Other\".","Enter a description of the package type for the product.","Provide a single value, cannot be a range.","If possible, avoid using “Other”.","Enter a description of the units for the product quantity.","Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value.",null,"If \"Flavored\" selected, enter the concise flavor description in the next column.","Enter the Flavor that is identified on the package and labelling.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,null,"Provide a single value, cannot be a range.","If possible, avoid using “Other”.","Enter description of the units for the Portion count.","Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value.","If possible, avoid using “Other”.","Enter a description of the length of the product.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value. ","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Only enter a number up to 100.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value. ","Enter only unit for the nicotine concentration units.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","Provide a single value, cannot be a range.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","If possible, avoid using “Other”.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If possible, avoid using “other”.","Enter wrapper material type.","Provide a single value, cannot be a range.\n","If possible, avoid using “Other”.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","If you are populating a column with units, you must provide the corresponding numeric value.","Maximum of 5,000.","Answer \"yes\" if this predicate tobacco product was previously marketed in the United States but is no longer marketed in the United States. ","If your predicate tobacco product has never been marketed in the United States, leave this field blank.","If your predicate tobacco product was previously marketed in the United States but you stopped marketed (i.e., it is no longer marketed in the US), answer \"no\". "]
["No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).","No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).","No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).","No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).",null,null,"If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value.","Entry should be concise and specific.","Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Limit to 500 characters including spaces.",{"$nulls":4},"Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value. ","If you are populating a column with units, you must provide the corresponding numeric value. ","Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you are populating the Diameter Format column, you must provide the corresponding diameter numeric value and unit.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating a column with units, you must provide the corresponding numeric value.",null,"Only enter positive numbers.","Only enter positive numbers.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"Answer \"yes\" if this new tobacco product is currently being marketed in the United States. ",null,"If you have never marketed your new tobacco product in the United States, leave this field blank.",{"$nulls":15},"No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©).","Limit to 500 characters including spaces.","No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).","No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).","No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).",null,null,"If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value.","Entry should be concise and specific.","Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Limit to 500 characters including spaces.",{"$nulls":4},"Only enter positive numbers.","If you are populating a column with units, you must provide the corresponding numeric value. ","If you are populating a column with units, you must provide the corresponding numeric value. ","Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you are populating the Diameter Format column, you must provide the corresponding diameter numeric value and unit.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Provide a single value, cannot be a range.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating a column with units, you must provide the corresponding numeric value.",null,"Only enter positive numbers.","Only enter positive numbers.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"Only enter positive numbers.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"Answer \"yes\" if this predicate tobacco product is currently being marketed in the United States. ",null,"If you have never marketed your predicate tobacco product in the United States, leave this field blank."]
[{"$nulls":7},"Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating a column with units, you must provide the corresponding numeric value.","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).",{"$nulls":4},"Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"Entry cannot contain any letters.",null,"Entry cannot contain any letters.",{"$nulls":3},"Entry cannot contain any letters.",null,"Entry cannot contain any letters.",null,"Only enter positive numbers.","Entry cannot contain any letters.",null,"Entry cannot contain any letters.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"Entry cannot contain any letters.","Entry cannot contain any letters.","Entry cannot contain any letters.",null,"Entry cannot contain any letters.",{"$nulls":5},"Entry cannot contain any letters.",null,null,"Entry cannot contain any letters",null,null,"Answer \"yes\" if this new tobacco product has been marketed in the United States in the past, removed from the market, and reintroduced.",{"$nulls":18},"No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).",{"$nulls":6},"Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating a column with units, you must provide the corresponding numeric value.","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©), parenthesis [()], Trademark (™), Registered Trademark (®).",{"$nulls":4},"Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"Entry cannot contain any letters.",null,"Entry cannot contain any letters.",{"$nulls":3},"Entry cannot contain any letters.",null,"Entry cannot contain any letters.",null,"Only enter positive numbers.","Entry cannot contain any letters.",null,"Entry cannot contain any letters.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"Entry cannot contain any letters.","Entry cannot contain any letters.","Entry cannot contain any letters.",null,"Entry cannot contain any letters.",{"$nulls":5},"Entry cannot contain any letters.",null,null,"Entry cannot contain any letters",null,null,"Answer \"yes\" if this predicate tobacco product has been marketed in the United States in the past, removed from the market, and reintroduced."]
[{"$nulls":7},"Entry cannot contain any special characters (refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":4},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"For non-circular, rod-like, or rectangular products, diameter can be provided by calculating the maximum distance between two points of the product’s borders; For rectangular products, Diameter= v(width)2 + (height)2.",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any letters.","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":5},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,null,"Answer \"no\" if this new tobacco product has never been marketed in the United States.",{"$nulls":25},"Entry cannot contain any special characters (refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"If you did not select \"other\" then you must leave this cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":4},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"For non-circular, rod-like, or rectangular products, diameter can be provided by calculating the maximum distance between two points of the product’s borders; For rectangular products, Diameter= v(width)2 + (height)2.",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any letters.","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":3},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).","Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",{"$nulls":5},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,null,"Answer \"no\" if this predicate tobacco product has never been marketed in the United States."]
[{"$nulls":7},"If you are populating the numeric value, you must provide the corresponding unit.",null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":8},"If you are populating the numeric value, you must provide the corresponding unit.",null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":3},"If you are populating the numeric value, you must provide the corresponding unit.",null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"If you are populating the numeric value, you must provide the corresponding unit.",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).","If you are populating the numeric value, you must provide the corresponding unit.",null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating the numeric value, you must provide the corresponding unit.",null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":5},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":28},"If you are populating the numeric value, you must provide the corresponding unit.",null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":8},"If you are populating the numeric value, you must provide the corresponding unit.",null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":3},"If you are populating the numeric value, you must provide the corresponding unit.",null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).",null,"If you are populating the numeric value, you must provide the corresponding unit.",null,"Entry cannot contain any special characters\n(refer to the Electronic Submission File Formats and Specifications which can be found on the FDA website).","If you are populating the numeric value, you must provide the corresponding unit.",null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":3},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you are populating the numeric value, you must provide the corresponding unit.",null,"If you are populating the numeric value, you must provide the corresponding unit.",{"$nulls":5},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,null,"If you are populating the numeric value, you must provide the corresponding unit."]
[{"$nulls":7},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":11},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":6},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":3},"If you are populating the numeric value, you must provide the corresponding unit.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":5},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":8},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":28},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":11},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":6},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":3},"If you are populating the numeric value, you must provide the corresponding unit.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.","If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":5},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",null,"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":8},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory."]
[{"$nulls":32},"For a rectangular product, a numerical value for diameter (e.g., 8mm) can be determined from the width and height of the product by reporting the measurement of the rectangle’s diagonal where the reported diameter (i.e., the diagonal) equals the square root of the sum of the width squared and the height squared.  \nFor a product that is neither rod-like nor rectangular, a numerical value for diameter (e.g., 8mm) can be provided as the maximum distance between two points of the product’s borders.",{"$nulls":77},"For a rectangular product, a numerical value for diameter (e.g., 8mm) can be determined from the width and height of the product by reporting the measurement of the rectangle’s diagonal where the reported diameter (i.e., the diagonal) equals the square root of the sum of the width squared and the height squared.  \nFor a product that is neither rod-like nor rectangular, a numerical value for diameter (e.g., 8mm) can be provided as the maximum distance between two points of the product’s borders."]
[{"$nulls":32},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory.",{"$nulls":77},"If you do not have values for a field, you must leave the cell blank. Please refer to 21 CRF 1107.8 for the required properties based on product category and subcategory."]

{"sheet":"Introduction","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,0,0,1],[1,0,1,1],[1,2,1,3],[2,0,2,1],[2,2,16,3],[23,0,26,3]]}
["Unique Identifying Information for New Tobacco Products",null,null,"FDA Form 3965b"]
["Instructions:\n1.  Applicant name must be entered as required by 21 CFR § 1114.7(c)(3).     \n2.  Product Category must be entered as required by 21 CFR § 1114.7(c)(3).  To ensure ingestion use the drop-down menu.\n3.  Product Subcategory must be entered as required by 21 CFR § 1114.7(c)(3).  To ensure ingestion use the drop-down menu. \n4. To populate your unique identification of your products, once you have completed entry of applicant name, product category, product subcategory, and application type, click on the “Enter Unique Product Properties” button to enter each tobacco product. This will allow for a new tab called “Product” to generate.\n5. Complete product tab for all tobacco products you are submitting. Refer to the “Instructions Tab” for information to correctly populate each product property for ingestion. Enter applicable product information as specified in Table 1 to 21 CFR § 1114.7(c)(3)(iii) under the Product Tab. \n6. If you click on the \"reset\" button you will lose your product tab and all product data entered.\n7. Once you have completed data entry for both your introduction and product tabs, SAVE AS .XLS or .XLSX and name appropriately.  For file naming convention, reference the Electronic Submission File Formats and Specifications which can be found on the FDA website.\n8. Your spreadsheet must be XLS or XLSX to attach to eSubmitter file for submission, otherwise it will not be processed. \n9. Create a separate spreadsheet for each product Category/Subcategory. Do not exceed 5000 rows of products as the spreadsheet will not validate. If total number of products for each product Category/Subcategory exceeds 5000 products, then create a new spreadsheet for the additional products.\n10. Only use this spreadsheet for PMTA submissions.",null,"Please note:",null,null,"OMB Control No. 0910-0673\nExpiration Date: XX/XX/20XX\nSee PRA Statement on bottom of page"]
["Product Information",null,"\n\nSaving as an .xls or .xlsx will cause all drop down menus to disappear, so be certain you are completely finished.  Your data will be saved, but you will not have drop down functions if you must re-open.  \n\nFor file naming convention, reference the Electronic Submission File Formats and Specifications which can be found on the FDA website.\n\n                                                                  "]
["Applicant Name"]
["Product Category"]
["Product Subcategory"]
["Product Category, If other"]
["Product Subcategory, if Other"]
["Application Type","SE"]
{"$rows_empty":10}
["Version: 1.0"]
["Release Date: TBD"]
[]
[]
["This section applies only to requirements of the Paperwork Reduction Act of 1995.\n*DO NOT SEND YOUR COMPLETED FORM TO THE PRA STAFF ADDRESS BELOW.*\nThe burden time for this collection of information is estimated to average 60 minutes per response, including the time to review instructions, search existing data sources, gather and maintain the data needed and complete and review the collection of information. Send comments regarding this burden estimate or any other aspect of this information collection, including suggestions for reducing this burden, to the following email address:\nFor PRA questions:\nPRAStaff@fda.hhs.gov\nOMB Statement: “An agency may not conduct or sponsor and a person is not required to respond to, a collection of information unless it displays a currently valid OMB number.”"]

{"sheet":"Product","index":2,"n_rows":2,"n_cols":140,"rows_kept":2,"hidden":true}
[{"$nulls":67},"Heated Tobacco Product","Open HTP","Test","Other","Other",null,null,"SE",null,"SE",{"$nulls":5},"SE"]
["Product Name","Brand","Subbrand","Manufacturer","TP Number","Package Type","Package Type, if Other","Product Quantity Numeric Value","Units (Product Quantity)","Units, if Other (Product Quantity)","Product Quantity Mass Numeric Value","Units (Product Quantity Mass)","Units, if Other (Product Quantity Mass)","Characterizing Flavor","Characterizing Flavor, If Flavored","Tobacco Cut/Particle Size Description  ","Tobacco Cut Style","Tobacco Cut/Particle Size Numeric Value","Units (Tobacco Cut/Particle Size)","Portion Count Numeric Value","Units (Portion Count)","Units, if Other (Portion Count)","Portion Mass Numeric Value","Units (Portion Mass)","Length Description","Length Description, if Other","Length Numeric Value","Units (Length)","Width Numeric Value","Units (Width)","Diameter Description","Diameter Format","Diameter Numeric Value","Units (Diameter)","Portion Thickness Numeric Value","Units (Portion Thickness)","Filter Ventilation","E-liquid Volume","E-liquid Volume Units","Nicotine Concentration","Nicotine Concentration Units","If mg/unit specify Unit (Nicotine Concentration)","Nicotine Source","PG Numeric Value","VG Numeric Value","Wattage Numeric Value","Units (Wattage)","Battery Capacity Numeric Value","Units (Battery Capacity)","Tip Type","Tip Type, if Other","Wrapper Material","Wrapper Material, if Other","Number of Hoses ","Source of Energy ","Source of Energy, if Other","Height Numeric Value","Units (Height)","Additional Properties (if Applicable)","Dates When Commercially Marketed in US\nHas this ever been marketed in the US? ","Dates When Commercially Marketed in US\n1st commercial market date (mm/dd/yyyy)","Dates When Commercially Marketed in US\nIs product currently marketed in the US?",{"$nulls":13},"Predicate","Original Product","Original/Predicate STN PD Number","Product Name","Brand","Subbrand","Manufacturer","TP Number","Package Type","Package Type, if Other","Product Quantity Numeric Value","Units (Product Quantity)","Units, if Other (Product Quantity)","Product Quantity Mass Numeric Value","Units (Product Quantity Mass)","Units, if Other (Product Quantity Mass)","Characterizing Flavor","Characterizing Flavor, If Flavored","Tobacco Cut/Particle Size Description  ","Tobacco Cut Style","Tobacco Cut/Particle Size Numeric Value","Units (Tobacco Cut/Particle Size)","Portion Count Numeric Value","Units (Portion Count)","Units, if Other (Portion Count)","Portion Mass Numeric Value","Units (Portion Mass)","Length Description","Length Description, if Other","Length Numeric Value","Units (Length)","Width Numeric Value","Units (Width)","Diameter Description","Diameter Format","Diameter Numeric Value","Units (Diameter)","Portion Thickness Numeric Value","Units (Portion Thickness)","Filter Ventilation","E-liquid Volume","E-liquid Volume Units","Nicotine Concentration","Nicotine Concentration Units","If mg/unit specify Unit (Nicotine Concentration)","Nicotine Source","PG Numeric Value","VG Numeric Value","Wattage Numeric Value","Units (Wattage)","Battery Capacity Numeric Value","Units (Battery Capacity)","Tip Type","Tip Type, if Other","Wrapper Material","Wrapper Material, if Other","Number of Hoses ","Source of Energy ","Source of Energy, if Other","Height Numeric Value","Units (Height)","Additional Properties (if Applicable)","Dates When Commercially Marketed in US\nHas this ever been marketed in the US? ","Dates When Commercially Marketed in US\n1st commercial market date (mm/dd/yyyy)","Dates When Commercially Marketed in US\nIs product currently marketed in the US?"]

{"sheet":"Sheet3","index":3,"n_rows":123,"n_cols":11,"rows_kept":123,"hidden":true}
["Category","CategoryLookup","ComponentLookUp","Look up values: category",{"$f":"INDEX(Sheet3!B2:B10, MATCH(Introduction!B5, Sheet3!A2:A10,0 ))","v":{"$error":"#N/A"}}]
["Cigarettes","Cigarette","CCigarette","flavor",{"$f":"INDEX(Sheet5!D2:D64, MATCH(Introduction!B5 & Introduction!B6,Sheet5!A2:A64,0 ))","v":{"$error":"#N/A"}}]
["Cigars","Cigars","CCigars","Package Type",{"$f":"INDEX(Sheet5!B2:B64, MATCH(Introduction!B5 & Introduction!B6,Sheet5!A2:A64,0 ))","v":{"$error":"#N/A"}}]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)","ENDS","CENDS","Package Quantity Unit",{"$f":"INDEX(Sheet5!C2:C64, MATCH(Introduction!B5 & Introduction!B6,Sheet5!A2:A64,0 ))","v":{"$error":"#N/A"}}]
["Heated Tobacco Products (HTP)","HTP","CHTP","DiameterFormat",{"$f":"INDEX(Sheet4!B2:B10, MATCH(Introduction!B5, Sheet4!A2:A10,0 ))","v":{"$error":"#N/A"}}]
["Pipe Tobacco Products","PipeTobaccoProduct","CPipeTobaccoProduct","PortionCount",{"$f":"INDEX(Sheet4!C2:C10, MATCH(Introduction!B5, Sheet4!A2:A10,0 ))","v":{"$error":"#N/A"}}]
["Roll-Your-Own Tobacco Products","RollYourOwn","CRollYourOwn","Component",{"$f":"INDEX(Sheet3!C2:C10, MATCH(Introduction!B5, Sheet3!A2:A10,0 ))","v":{"$error":"#N/A"}}]
["Smokeless Tobacco Products","Smokeless","CSmokeless"]
["Waterpipe Tobacco Products","WaterpipeTobaccoProduct","CWaterpipeTobaccoProduct"]
["Other","Other","COther"]
[]
["Subcategory"]
["Cigarette","Cigars","ENDS","PipeTobaccoProduct","RollYourOwn","Smokeless","WaterpipeTobaccoProduct","Other","HTP"]
["Filtered","Cigar Component","Closed E-Cigarette","Pipe","Filter","Dissolvable","Waterpipe","Other","Closed HTP"]
["Non-Filtered","Cigar Tobacco Filler","Closed E-Liquid","Pipe Component","Filtered Cigarette Tube","Loose Chewing Tobacco","Waterpipe Component",null,"Open HTP"]
["Other","Filtered, Sheet-Wrapped","ENDS Component","Pipe Tobacco Filler","Non-Filtered Cigarette Tube","Loose Dry Snuff","Waterpipe Heat Source",null,"HTP Consumable"]
[null,"Unfiltered, Leaf-Wrapped","Open E-Cigarette","Other","Paper Tip","Loose Moist Snuff","Waterpipe Tobacco Filler",null,"HTP Component"]
[null,"Unfiltered, Sheet-Wrapped","Open E-Liquid",null,"Roll-Your-Own Tobacco Filler","Loose Snus","Other",null,"Other"]
[null,"Other","Other",null,"Rolling Paper","Portioned Chewing Tobacco"]
[{"$nulls":4},"Other","Portioned Moist Snuff"]
[{"$nulls":5},"Portioned Snus"]
[{"$nulls":5},"Other"]
[]
[]
[]
[]
["AllFlavor","LimitedFlavor",null,"AllPackageType","ENDSCECigPT","ENDSCEliqPT","ENDSOECigPT","ENDSOEliqPT","WPPT","WPHSPT"]
["Menthol ","Menthol ",null,"Bag/Pouch","Box","Cartridge","Box","Bottle","Box","Bag/Pouch"]
["Tobacco ","None ",null,"Blister Pack","Clamshell","Other","Clamshell","Box","None","Box"]
["Flavored","Tobacco ",null,"Booklet","None",null,"None","Other","Other","Film Sleeve"]
["Unflavored","Other",null,"Bottle","Other",null,"Other",null,null,"None"]
[{"$nulls":3},"Box",{"$nulls":5},"Other"]
[{"$nulls":3},"Cardboard Sleeve"]
[{"$nulls":3},"Carton"]
[{"$nulls":3},"Cartridge","CigarLimitedPT","CigarFillerPT","CigarettePT","RYOPT","RPPT","SMKPT","RYOOPT"]
[{"$nulls":3},"Cellophane","Box","Bag/Pouch","Box","Bag/Pouch","Booklet","Bag/Pouch","Bag/Pouch"]
[{"$nulls":3},"Clamshell","Cellophane","Metal Can with Lid","Clamshell","Box","Box","Blister Pack","Booklet"]
[{"$nulls":3},"Film Sleeve","Clamshell","Metal Can with Plastic Lid","Hard Box","Other","Other","Carton","Box"]
[{"$nulls":3},"Foil","Foil","None","Hard Pack",null,null,"Matchbook","Metal Can with Lid"]
[{"$nulls":3},"Hard Box","None","Plastic Can with Lid","Soft Pack",null,null,"Metal Can with Lid","Metal Can with Plastic Lid"]
[{"$nulls":3},"Hard Pack","Soft Pack","Plastic Can with Metal Lid","Other",null,null,"Metal Can with Plastic Lid","Plastic Can with Lid"]
["AllPackageQuantityUnit",null,null,"Matchbook","Other","Other",{"$nulls":3},"Plastic Can with Lid","Plastic Can with Metal Lid"]
["Bottles",null,null,"Metal Can with Lid",{"$nulls":5},"Plastic Can with Metal Lid","Other"]
["Boxes",null,null,"Metal Can with Plastic Lid",{"$nulls":5},"Puck"]
["Cartridges",null,null,"None","PipePT","PipeFillerPT",{"$nulls":3},"Other"]
["Count",null,null,"Plastic Can with Lid","Box","Bag/Pouch"]
["E-Cigarette",null,null,"Plastic Can with Metal Lid","None","Metal Can with Lid"]
["Other",null,null,"Pod","Other","Metal Can with Plastic Lid"]
[{"$nulls":3},"Puck",null,"Plastic Can with Lid"]
[{"$nulls":3},"Soft Pack",null,"Plastic Can with Metal Lid"]
[{"$nulls":3},"Tube",null,"Other"]
["LengthUnit",null,null,"Wrapper"]
["Millimeters",null,null,"Other"]
["Centimeters",{"$nulls":4},"PipePQU"]
["Meters",{"$nulls":4},"Pipe","PQU","RYOOtherPQU","HTPPQU","HTPCSPQU","HTPCPQU"]
["Inches",{"$nulls":3},"CigPQU","Other","Base","Count","Device","Cartridges","Mouthpiece"]
[null,"ENDSCECigPQU","ENDSCEliqPQU","ENDSOEliqPQU","Count",null,"Battery","Filters","HTP","Sticks","Spacer"]
[null,"Count","Cartridges","Bottles","Other","PQUOther","Bits","Leaves","Other","Other","Other"]
[null,"E-Cigarette","Other","Boxes","RYOPaperPQU","Other","Bottles","Paper"]
[null,"Other",null,"Other","Count",null,"Bowl","Pieces"]
[null,"RYOFilterPQU","RYOTubePQU","RYOTipPQU","Paper",null,"Boxes","Sheet"]
[null,"Count","Count","Count","Pieces",null,"Capsules","Tips"]
[null,"Filters","Tubes","Pieces","Sheet",null,"Cartridges","Tubes"]
[null,"Pieces","Other","Tips","Other","BCUnit","Cigar","Other"]
[null,"Other",null,"Other",null,"Watt","Cigarette"]
[{"$nulls":4},"WattUnit","Milliamps","Coil"]
["EnergyTP","DiameterFormat","VolumeUnit","NCUnit","Watt","mAh","Count"]
["Charcoal","Circumference","Milliliters","mg/ml","Milliwatts",null,"Device"]
["Battery","Diameter","Liters","%W/W","Volts",null,"E-Cigarette"]
["Electrical","Radius","Fluid Ounces","mg/unit",null,null,"Filters"]
["Other",null,"Kiloliters",{"$nulls":3},"Grams"]
[null,"CigarsDiameterFormat",{"$nulls":4},"Hose"]
[null,"Circumference",{"$nulls":4},"HTP"]
["SMKPC","Diameter",{"$nulls":4},"Leaves"]
["Bits","Radius",{"$nulls":4},"Loose Leaf Pieces"]
["Count","Ring Gauge",{"$nulls":4},"Mouthpiece"]
["Loose Leaf Pieces","ENDSDiameterFormat",{"$nulls":4},"Ounces"]
["Pieces","Circumference",{"$nulls":3},"TOBCutSizeDSC","Paper"]
["Plug","Diameter",{"$nulls":3},"Extra Long","Pieces"]
["Pouches",{"$nulls":4},"Fine","Pipe"]
["Stick",null,null,"TipTP","DiameterDSC","Long","Plug"]
["Strip","LengthDSC","MaterialTP","Wood","Regular","Straight","Pouches"]
["Tablet","King","Tobacco Leaf","Plastic","Slim","Wide","Sheet"]
["Twist","Long","Sheet Tobacco","Paper","Super Slim",null,"Spacer"]
["Other","XL","Paper","None","Wide",null,"Stem"]
[null,"Queen","Other","Other",null,null,"Stick"]
[null,"Other",{"$nulls":4},"Strip"]
[{"$nulls":4},"TobaccoCutSize",null,"Tablet"]
[null,null,"PortionMass","PortionThickness","Millimeters",null,"Tips"]
[null,"PortionCount","Milligrams","Millimeters","Centimeters",null,"Tubes"]
[null,"Bits","Grams","Centimeters","Inches",null,"Twist"]
[null,"Boxes","Kilograms","Meters","Cuts Per Inch (CPI)",null,"Waterpipe"]
[null,"Cartridges","Ounces","Inches",null,null,"Other"]
[null,"Count","Pounds"]
[null,"E-Cigarette","Tons",{"$nulls":3},"Copackage"]
[null,"Filters","Other",{"$nulls":3},"Product"]
[null,"Leaves",{"$nulls":4},"Component"]
["PipeFillerCutStyle","Loose Leaf Pieces"]
["Standard Cut","Orb"]
["Pressed Cut","Paper"]
["Mixture","Pieces"]
[null,"Pipe",{"$nulls":4},"PGVGNA"]
[null,"Plug",{"$nulls":4},true]
[null,"Pouches",{"$nulls":4},false]
[null,"Sheet"]
[null,"Stick"]
[null,"Strip"]
[null,"Tablet"]
[null,"Tips"]
[null,"Tubes"]
[null,"Twist"]
[null,"Other"]
[]
["NicotineSource"]
["Tobacco"]
["Non-Tobacco"]
["Both"]
["None"]
[]
[]
["YesNo"]
["Yes"]
["No"]

{"sheet":"Sheet4","index":4,"n_rows":40,"n_cols":8,"rows_kept":40,"hidden":true}
["Cat","DiameterFormatLookUp","PortionCountLookUp",null,"CCigarette"]
["Cigarettes","DiameterFormat","PortionCount",null,"CCigars"]
["Cigars","CigarDiameterFormat","PortionCount",null,"CENDS"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)","DiameterFormat","PortionCount",null,"CPipeTobaccoProduct"]
["Heated Tobacco Products (HTP)","DiameterFormat","PortionCount",null,"CRollYourOwn"]
["Pipe Tobacco Products","DiameterFormat","PortionCount",null,"CSmokeless"]
["Roll-Your-Own Tobacco Products","DiameterFormat","SMKPC",null,"CWaterpipeTobaccoProduct"]
["Smokeless Tobacco Products","DiameterFormat","PQUOther",null,"COther"]
["Waterpipe Tobacco Products","CigarDiameterFormat","PortionCount"]
["Other","DiameterFormat","PortionCount"]
[]
[]
["IngredientType","YN"]
["SCS","Yes"]
["CI","No"]
[]
["CCigarette","CCigars","CENDS","CPipeTobaccoProduct","CRollYourOwn","CSmokeless","CWaterpipeTobaccoProduct","COther"]
["Tobacco Filler Additive","Tobacco Filler","E-Liquid","Tobacco Filler","Tobacco Filler Additive","Tobacco Filler","Tobacco Filler","Filter "]
["Adhesive","Tobacco Filler Additive","Atomizer","Tobacco Filler Additive","Adhesive","Tobacco Filler Additive","Tobacco Filler Additive","Ink (Rod Print) "]
["Filter","Adhesive","Coil/Coil Heads","Bowl","Filter","Pouch","Heat Source","Pack Inner Foil "]
["Ink (Rod Print)","Filter","Mouthpiece","Mouthpiece","Ink (Rod Print)","Other","Base","Cigarette Paper "]
["Pack Inner Foil","Tip","Tank/Cartridge","Shank (without bowl)","Cigarette Paper",null,"Bowl","Tipping Paper "]
["Cigarette Paper","Tipping Paper","Wick","Other","Tipping Paper",null,"Diffuser","Plug Wrap "]
["Tipping Paper","Plug Wrap","Other",null,"Plug Wrap",null,"Foil/Screen","Other (Specify)"]
["Plug Wrap","Wrapper/Binder",null,null,"Other",null,"Hose"]
["Other","Other",{"$nulls":4},"Mouthpiece"]
[{"$nulls":6},"Seal"]
[{"$nulls":6},"Stem"]
[{"$nulls":6},"Valve"]
[{"$nulls":6},"Other"]
[]
["Application Type"]
["PMTA"]
["MRTP"]
["SE"]
["EX"]
[]
[]
["TP Number"]
["TP"]

{"sheet":"Sheet5","index":5,"n_rows":64,"n_cols":4,"rows_kept":64,"hidden":true}
["CatSubCat","PackageTypeLookUp","PackageQuantityUnitsLookUp","FlavorLookup"]
["CigarettesCigarette Co-Package","CigarettePT","CigPQU","LimitedFlavor"]
["CigarettesFiltered","CigarettePT","CigPQU","LimitedFlavor"]
["CigarettesNon-Filtered","CigarettePT","CigPQU","LimitedFlavor"]
["CigarettesCombusted, Other","CigarettePT","CigPQU","LimitedFlavor"]
["CigarettesNon-Combusted","CigarettePT","CigPQU","LimitedFlavor"]
["CigarettesNot Provided","CigarettePT","CigPQU","LimitedFlavor"]
["CigarettesOther","CigarettePT","CigPQU","LimitedFlavor"]
["CigarsCigar Co-Package","AllPackageType","PQUOther","AllFlavor"]
["CigarsCigar Component","CigarLimitedPT","PQUOther","AllFlavor"]
["CigarsCigar Tobacco Filler","CigarFillerPT","PQUOther","LimitedFlavor"]
["CigarsFiltered, Sheet-Wrapped","CigarLimitedPT","PQUOther","AllFlavor"]
["CigarsUnfiltered, Leaf-Wrapped","CigarLimitedPT","PQUOther","AllFlavor"]
["CigarsUnfiltered, sheet-Wrapped","CigarLimitedPT","PQUOther","AllFlavor"]
["CigarsNot Provided","AllPackageType","PQUOther","AllFlavor"]
["CigarsOther","AllPackageType","PQUOther","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)Closed E-Cigarette","ENDSCECigPT","ENDSCECigPQU","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)Closed E-Liquid","ENDSCEliqPT","ENDSCEliqPQU","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)ENDS Co-Package","ENDSCECigPT","ENDSCECigPQU","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)ENDS Component","ENDSCECigPT","ENDSCECigPQU","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)Open E-Cigarette","ENDSOECigPT","ENDSCECigPQU","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)Open E-Liquid","ENDSOEliqPT","ENDSOEliqPQU","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)Not Provided","AllPackageType","AllPackageQuantityUnit","AllFlavor"]
["Electronic Nicotine Delivery Systems (ENDS) (Vapes)Other","AllPackageType","AllPackageQuantityUnit","AllFlavor"]
["Pipe Tobacco ProductsPipe","PipePT","PipePQU","LimitedFlavor"]
["Pipe Tobacco ProductsPipe Co-Package","AllPackageType","PipePQU","AllFlavor"]
["Pipe Tobacco ProductsPipe Component","PipePT","PQUOther","AllFlavor"]
["Pipe Tobacco ProductsPipe Tobacco Filler","PipeFillerPT","PipePQU","AllFlavor"]
["Pipe Tobacco ProductsNot Provided","AllPackageType","PipePQU","AllFlavor"]
["Pipe Tobacco ProductsOther","AllPackageType","PipePQU","AllFlavor"]
["Roll-Your-Own Tobacco ProductsFilter","RYOPT","RYOFilterPQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsFiltered Cigarette Tube","RYOPT","RYOTubePQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsNon-Filtered Cigarette Tube","RYOPT","RYOTubePQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsPaper Tip","RYOPT","RYOTipPQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsRoll-Your-Own Co-Package","RYOOPT","RYOOtherPQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsRoll-Your-Own Tobacco Filler","PipeFillerPT","RYOOtherPQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsRolling Paper","RPPT","RYOPaperPQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsNot Provided","RYOOPT","RYOOtherPQU","LimitedFlavor"]
["Roll-Your-Own Tobacco ProductsOther","RYOOPT","RYOOtherPQU","LimitedFlavor"]
["Smokeless Tobacco ProductsDissolvable","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsLoose Chewing Tobacco","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsLoose Dry Snuff","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsLoose Moist Snuff","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsLoose Snus","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsPortioned Chewing Tobacco","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsPortioned Moist Snuff","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsPortioned Snus","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsSmokeless Co-Package","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsNot Provided","SMKPT","SMKPC","AllFlavor"]
["Smokeless Tobacco ProductsOther","SMKPT","SMKPC","AllFlavor"]
["Waterpipe Tobacco ProductsWaterpipe","WPPT","PQUOther","AllFlavor"]
["Waterpipe Tobacco ProductsWaterpipe Co-Package","AllPackageType","PQUOther","AllFlavor"]
["Waterpipe Tobacco ProductsWaterpipe Component","PQUOther","PQUOther","AllFlavor"]
["Waterpipe Tobacco ProductsWaterpipe Heat Source","WPHSPT","PQUOther","AllFlavor"]
["Waterpipe Tobacco ProductsWaterpipe Tobacco Filler","SMKPT","PortionCount","AllFlavor"]
["Waterpipe Tobacco ProductsNot Provided","AllPackageType","PQUOther","AllFlavor"]
["Waterpipe Tobacco ProductsOther","AllPackageType","PQUOther","AllFlavor"]
["OtherNot Provided","AllPackageType","PQU","AllFlavor"]
["OtherOther","AllPackageType","PQU","AllFlavor"]
["Heated Tobacco Products (HTP)Closed HTP","ENDSCECigPT","HTPPQU","AllFlavor"]
["Heated Tobacco Products (HTP)Open HTP","ENDSCECigPT","HTPPQU","AllFlavor"]
["Heated Tobacco Products (HTP)HTP Consumable","ENDSCECigPT","HTPCSPQU","AllFlavor"]
["Heated Tobacco Products (HTP)HTP Component","ENDSCECigPT","HTPCPQU","AllFlavor"]
["Heated Tobacco Products (HTP)Other","AllPackageType","PQU","AllFlavor"]