{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Introduction","Product","Sheet3","Sheet4","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":86,"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":"Instructions","index":0,"n_rows":9,"n_cols":54,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Product Name","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)","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)"]
["Enter Product Name, including brand and sub-brand (or other commercial name(s) used in commercial distribution).","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.  ","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 product quantity 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."]
["Limit to 500 characters including spaces.","If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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.","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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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."]
["No special characters except percent sign (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©).",null,null,"If you did not select \"other\" then you must leave this cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.","Limit to 500 characters including spaces.",null,null,null,null,"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. ","If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory."]
[null,null,null,null,"Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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).",null,null,null,"No special characters except percent sigh (%), slash (/), period (.), ampersand (&), quotation marks (“ “), apostrophe (‘), colon (:), copyright symbol (©).",null,null,null,null,"Entry cannot contain any letters.","If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,"Entry cannot contain any letters.",null,"Entry cannot contain any letters.",null,null,null,"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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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.",null,null,null,null,null,"Entry cannot contain any letters.",null,null,"Entry cannot contain any letters"]
[null,null,null,null,"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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.","If you are populating the numeric value, you must provide the corresponding unit.",null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,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,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,"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,null,"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).",null,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).","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).",null,null,null,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,"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,null,null,"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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,null,null,null,null,null,null,"If you are populating the numeric value, you must provide the corresponding unit.",null,null,null,null,"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.",null,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,"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.",null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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.",null,null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Recordkeeping Requirements rule 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."]
[null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,null,null,null,null,null,null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,null,"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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule 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 the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory.",null,null,null,null,null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you do not have values for a field, you must leave the cell blank. Please refer to the Premarket Tobacco Product Applications and Record keeping Requirements rule for the required properties based on product category and subcategory."]

{"sheet":"Introduction","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,26,3],[1,2,1,3],[0,0,0,1],[1,0,1,1],[2,0,2,1],[2,2,16,3]]}
["Unique Identifying Information for New Tobacco Products",null,null,"FDA Form 4057b"]
["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-0879\nExpiration Date: 12/31/2025\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","PMTA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Version: 3.0"]
["Release Date: September 2023"]
[]
[]
["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 35 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":127,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heated Tobacco Product","Open HTP",null,"Test",null,"Other","Other",null,null,"PMTA"]
["Product Name","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)","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)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicate","Original Product","Original/Predicate STN PD Number","Product Name","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)","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)"]

{"sheet":"Sheet3","index":3,"n_rows":118,"n_cols":11,"rows_kept":118,"cut":false,"hidden":true,"merged":[]}
["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"]
[null,null,null,null,"Other","Portioned Moist Snuff"]
[null,null,null,null,null,"Portioned Snus"]
[null,null,null,null,null,"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"]
[null,null,null,"Box",null,null,null,null,null,"Other"]
[null,null,null,"Cardboard Sleeve"]
[null,null,null,"Carton"]
[null,null,null,"Cartridge","CigarLimitedPT","CigarFillerPT","CigarettePT","RYOPT","RPPT","SMKPT","RYOOPT"]
[null,null,null,"Cellophane","Box","Bag/Pouch","Box","Bag/Pouch","Booklet","Bag/Pouch","Bag/Pouch"]
[null,null,null,"Clamshell","Cellophane","Metal Can with Lid","Clamshell","Box","Box","Blister Pack","Booklet"]
[null,null,null,"Film Sleeve","Clamshell","Metal Can with Plastic Lid","Hard Box","Other","Other","Carton","Box"]
[null,null,null,"Foil","Foil","None","Hard Pack",null,null,"Matchbook","Metal Can with Lid"]
[null,null,null,"Hard Box","None","Plastic Can with Lid","Soft Pack",null,null,"Metal Can with Lid","Metal Can with Plastic Lid"]
[null,null,null,"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",null,null,null,"Plastic Can with Lid","Plastic Can with Metal Lid"]
["Bottles",null,null,"Metal Can with Lid",null,null,null,null,null,"Plastic Can with Metal Lid","Other"]
["Boxes",null,null,"Metal Can with Plastic Lid",null,null,null,null,null,"Puck"]
["Cartridges",null,null,"None","PipePT","PipeFillerPT",null,null,null,"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"]
[null,null,null,"Puck",null,"Plastic Can with Lid"]
[null,null,null,"Soft Pack",null,"Plastic Can with Metal Lid"]
[null,null,null,"Tube",null,"Other"]
["LengthUnit",null,null,"Wrapper"]
["Millimeters",null,null,"Other"]
["Centimeters",null,null,null,null,"PipePQU"]
["Meters",null,null,null,null,"Pipe","PQU","RYOOtherPQU","HTPPQU","HTPCSPQU","HTPCPQU"]
["Inches",null,null,null,"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"]
[null,null,null,null,"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",null,null,null,"Grams"]
[null,"CigarsDiameterFormat",null,null,null,null,"Hose"]
[null,"Circumference",null,null,null,null,"HTP"]
["SMKPC","Diameter",null,null,null,null,"Leaves"]
["Bits","Radius",null,null,null,null,"Loose Leaf Pieces"]
["Count","Ring Gauge",null,null,null,null,"Mouthpiece"]
["Loose Leaf Pieces","ENDSDiameterFormat",null,null,null,null,"Ounces"]
["Pieces","Circumference",null,null,null,"TOBCutSizeDSC","Paper"]
["Plug","Diameter",null,null,null,"Extra Long","Pieces"]
["Pouches",null,null,null,null,"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",null,null,null,null,"Strip"]
[null,null,null,null,"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,"Bound","Kilograms","Meters","Cuts Per Inch (CPI)",null,"Waterpipe"]
[null,"Boxes","Ounces","Inches",null,null,"Other"]
[null,"Brick","Pounds"]
[null,"Cartridges","Tons",null,null,null,"Copackage"]
[null,"Count","Other",null,null,null,"Product"]
[null,"E-Cigarette",null,null,null,null,"Component"]
["PipeFillerCutStyle","Filters"]
["Standard Cut","Leaves"]
["Pressed Cut","Loose Leaf Pieces"]
["Mixture","Orb"]
[null,"Paper",null,null,null,null,"PGVGNA"]
[null,"Pellets",null,null,null,null,true]
[null,"Pieces",null,null,null,null,false]
[null,"Pipe"]
[null,"Plug"]
[null,"Pouches"]
[null,"Sheet"]
[null,"Stick"]
[null,"Strip"]
[null,"Tablet"]
[null,"Tips"]
[null,"Tubes"]
["NicotineSource","Twist"]
["Tobacco","Other"]
["Non-Tobacco"]
["Both"]
["None"]

{"sheet":"Sheet4","index":4,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["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",null,null,null,null,"Mouthpiece"]
[null,null,null,null,null,null,"Seal"]
[null,null,null,null,null,null,"Stem"]
[null,null,null,null,null,null,"Valve"]
[null,null,null,null,null,null,"Other"]
[]
["Application Type"]
["PMTA"]
["MRTP"]
["SE"]
["EX"]
[]
[]
["TP Number"]
["TP"]

{"sheet":"Sheet5","index":5,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["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"]