{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TOC","Products Requested for Cert","Ingredients & Processing Aids","(Blank OPP)","Bottled Green Ginger Tea","Sleepy Tea"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":0,"comments":0,"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":"TOC","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["How to use QCS's Organic Product Profile (OPP) Excel Workbook: Enable macros for full functionality. If the workbook isn't working with your version of excel, open without enabling macros -- everything except this Table of Contents (TOC) page will work as designed, and QCS will update the TOC upon receipt of your edited workbook.\n\nUse this TOC sheet and the tabs at the bottom of excel to navigate between different sheets. The TOC will update each time the workbook is opened and also when prompted to by navigating to \"Table of Contents\" on the ribbon and selecting \"Update/Return to TOC.\" It is set to automatically sorts sheets in alphabetical order.\n\nProducts requested for certification go on the next sheet, Ingredients and Processing Aids go on the sheet following that, and your multi-ingredient product OPPs go on their own individual sheets after those. Make copies of blank OPP sheets as needed."]
[]
["Table of Contents (click to navigate to page):"]
["Products Requested for Cert"]
["Ingredients & Processing Aids"]
["(Blank OPP)"]
["Bottled Green Ginger Tea"]
["Sleepy Tea"]

{"sheet":"Products Requested for Cert","index":1,"n_rows":200,"n_cols":24,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Instructions: List all organic products requesting certification with QCS in column A, note the Brand Name/SKU/ID Mark the product will be marketed/sold under in column B,  select from the drop down list the certification/labeling category you're applying for in column C (for details on the disctinctions between 100% Organic, Organic, Made with Organic, and <70% organic products, see §205.301), select equivalences/export arrangments requested in column D (multiple options can be selected from the drop down list), use column E to include additional product info as needed, and select the final packaging type in which the product will be sold/distributed in column F. For single-ingredient products, in column G use drop down list to select the ingredient from amongst those you've listed on the Ingredients & Processing Aids sheet."]
["Product Name","Brand Name(s) or other ID Mark","Labeling Category Requested (100% Organic, Organic, Made with Organic, <70% Organic)","Equivalences/Export Arrangements requested (multi-select drop down list)","Additional product info/notes (column header editable)","Package Type (Retail, Non-Retail/Wholesale, WIP/Product not Sold","If this is a single-ingredient product, use drop down list to select source from Ingredients sheet"]
["[Select Product Name From List]",null," ","[This auto-populates from data on the Products Requested for Certification sheet]",null,null,null,null,"100% Organic","Organic","Made with Organic","<70% Organic"," ","Retail","Non-Retail/Wholesale","WIP/Product not Sold"," ","NOP-CAN","NOP-EU","NOP-Japanese","NOP-Korean","NOP-Swiss","NOP-Taiwan","NOP-UK"]
["Bottled Green Ginger Tea","Organic Tea Mongers","Organic","NOP-CAN, NOP-EU",null,"Retail"," "]
["Roasted Yaupon Holly, Loose","Organic Tea Mongers","100% Organic"," ",null,"Non-Retail/Wholesale","Yaupon Holly"]
["Sleepy Tea, Loose","Organic Tea Mongers","100% Organic"," ",null,"Non-Retail/Wholesale"," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]
[null,null,null," ",null,null," "]

{"sheet":"Ingredients & Processing Aids","index":2,"n_rows":15,"n_cols":31,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Instructions: List all ingredients and processing aids used across all products requested for certification here. Note that organic-certified ingredients may be \"100% Organic\", \"Organic\", or \"Made with Organic\"; check the producer's certificate to determine the ingredient's status (default to \"Organic\" if unsure). \"Organic\" ingredients accompanied by a COA may use the % Organic value that most closely matches the value on the COA (rounding down), while qualifying ingredients can be labeled \"Organic\" Raw Agricultural Product\" for a 99.99% assumed value. For each ingredient, provide the name of the supplier/vendor you're directly purchasing from, as well as the supplier's certification status (certified or uncertified). If alternate suppliers are in use for the same ingredient, note them as well. Only ingredients you list here will be fillable on your OPPs."]
["Ingredients & Processing Aids\n(including salt if in use)","Ingredient Status: 100% Organic, Organic (>95% org), Organic Raw Agricultural Product, Made with Organic (70-95% org), NonOrganic, etc","Equivalences/Export Arrangements (multi-select drop down list)","Additional product info/notes (column header editable)","Primary Supplier","Supplier certified? y/n","If no, last certified entity in supply chain","Alternate Supplier","Supplier certified?","If no, last certified entity in supply chain ","Alternate Supplier ","Supplier certified? ","If no, last certified entity in supply chain  "]
[" "," ",null,null,null,null,null,null,null,null,null,null,null,null,"100% Organic","Organic","Organic Raw Agricultural Product","Made with Organic","NonOrganic","99% Organic (w/ COA)","98% Organic (w/ COA)","97% Organic (w/ COA)","96% Organic (w/ COA)",null,"NOP-CAN","NOP-EU","NOP-Japanese","NOP-Korean","NOP-Swiss","NOP-Taiwan","NOP-UK"]
["Ascorbic Acid","NonOrganic",null,null,"Cargil","n","NA"]
["Buckwheat, roasted","Organic","NOP-CAN, NOP-EU",null,"Starwest","y"]
["Cat Nip","100% Organic",null,null,"Mountain Rose","y"]
["Chamomile","100% Organic",null,null,"Mountain Rose","y"]
["Ginger Concentrate","97% Organic (w/ COA)","NOP-CAN, NOP-EU",null,"Ag Imports Inc","n","Carribean Roots"]
["Green Tea Concentrate","99% Organic (w/ COA)","NOP-CAN, NOP-EU",null,"Ag Imports Inc","n","Japanese Tea Co"]
["Honey Granules","Organic","NOP-CAN, NOP-EU",null,"Starwest","y"]
["Licorice ","100% Organic",null,null,"Mountain Rose","y"]
["Peppermint, dry","100% Organic",null,null,"Mountain Rose","y"]
["Salt","NonOrganic",null,null,"Cargil","n","NA"]
["Spearamint, dry","100% Organic","NOP-CAN, NOP-EU",null,"Starwest","y"]
["Yaupon Holly","100% Organic",null,null,"Starwest","y"]

{"sheet":"(Blank OPP)","index":3,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,8,8,11],[8,12,8,13],[0,0,0,7],[1,1,1,2],[1,5,1,6],[1,8,1,13],[2,5,3,6],[2,8,2,9],[2,10,2,13],[3,8,3,9],[3,10,3,13],[4,8,6,13],[5,5,6,5],[5,6,6,6],[7,8,7,11],[7,12,7,13],[9,8,9,11],[9,12,9,13],[10,8,10,11],[10,12,10,13],[11,8,11,11],[11,12,11,13],[16,5,26,13],[12,5,14,6],[12,8,12,11],[12,12,12,13],[13,8,13,11],[13,12,13,13],[14,8,14,11],[14,12,14,13]]}
["Instructions: Create a copy of a blank OPP for each multi-ingredient product requesting certification (see instructions on how to make a copy at bottom of this sheet). Rename OPP sheet to the name of the certified product. Select product name from drop-down list in cell B2 (only products noted in \"Products Requested for Cert\" sheet will be available to  select). In column A, select product ingredients and processing aids (including water and salt) from the drop down list (only ingredients noted in \"Ingredients & Processing Aids\" sheet will be available to select). Organic status of ingredient will auto-populate in column B. Input product formula (by weight) in column C. Ensure that the sum of all ingredients = 100 in cell G14. If you need more rows, unlock sheet (no password), right click table, select \"Insert\", and select \"Table Rows Above\".",null,null,null,null,null,null,null,null,null,null,null,null,null,"yes","no"]
["Name of product requested for certification:","[Select Product Name From List]",null,{"$f":"VLOOKUP(B2,'Products Requested for Cert'!$A$3:$C$200,3,0)","v":" "},null,"Equivalences/Export Arrangements requested:",null,null,"QCS Office Use Only"]
["Ingredient (select from drop down list)","Ingredient status","% by weight in product","Notes",null,{"$f":"VLOOKUP(B2,'Products Requested for Cert'!$A$3:$D$200,4,0)","v":"[This auto-populates from data on the Products Requested for Certification sheet]"},null,null,"Approved by:"]
[" ",{"$f":"VLOOKUP(A4,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"Date approved:"]
[" ",{"$f":"VLOOKUP(A5,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"For \"Organic\" or \"Made with Organic\" ingredients with known % organic amounts >95% or 70% respectively, list here and recalculate % organic in final product as needed:"]
[" ",{"$f":"VLOOKUP(A6,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Does this product contain sulfites, nitrates, or nitrites added during the production or handling process?"]
[" ",{"$f":"VLOOKUP(A7,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A8,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"Ingredient:",null,null,null,"Actual % Organic"]
[" ",{"$f":"VLOOKUP(A9,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Sum of all ingredients",{"$f":"SUM($C$4:$C$27)","v":0},null," "]
[" ",{"$f":"VLOOKUP(A10,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Sum of organic ingredients",{"$f":"(SUMIF($B$4:$B$27,\"100% Organic\",$C$4:$C$27))+(0.95*SUMIF($B$4:$B$27,\"Organic\",$C$4:$C$27))+(0.9999*SUMIF($B$4:$B$27,\"Organic Raw Agricultural Product\",$C$4:$C$27))+(0.7*SUMIF($B$4:$B$27,\"Made with Organic\",$C$4:$C$27))+(0.99*SUMIF($B$4:$B$27,\"99% Organic (w/ COA)\",$C$4:$C$27))+(0.98*SUMIF($B$4:$B$27,\"98% Organic (w/ COA)\",$C$4:$C$27))+(0.97*SUMIF($B$4:$B$27,\"97% Organic (w/ COA)\",$C$4:$C$27))+(0.96*SUMIF($B$4:$B$27,\"96% Organic (w/ COA)\",$C$4:$C$27))","v":0},null," "]
[" ",{"$f":"VLOOKUP(A11,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"% organic ingredients (excluding water & salt)*",{"$f":"100*(G10/(G9-SUMIF($A$4:$A$27,\"Salt\",$C$4:$C$27)-SUMIF($A$4:$A$27,\"Water\",$C$4:$C$27)))","v":{"$error":"#DIV/0!"}},null," "]
[" ",{"$f":"VLOOKUP(A12,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null," "]
[" ",{"$f":"VLOOKUP(A13,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Additional comments:",null,null," "]
[" ",{"$f":"VLOOKUP(A14,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null," "]
[" ",{"$f":"VLOOKUP(A15,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"Manual % organic ingredients calculation:"]
[" ",{"$f":"VLOOKUP(A16,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A17,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"*Note that the \"% organic ingredients\" formula uses, by default, a value of 95% organic for \"Organic\" labeled ingredients, and 70% organic for \"Made with Organic\" labeled ingredients, per the minimum allowances set forth in §205.301 for each organic category. Since these are set at the lowest acceptable range for their respective categories, the formula's output may be artificially low. \n\nTo address this, a subset of values between 95% organic and 100% organic are available for you to select on the ingredients sheet, provided you have a COA verifying the ingredient's composition, or provided that the \"Organic\" product is a raw agricultural product. If extra precision outside these few values is required, indicate as such on the notes column, and the % organic ingredients formula can be manually calculated.\n\nThe only reason this additional level of precision might matter is if the \"% organic ingredients\" formula produces a result below 95% when you are seeking \"Organic\" status for your final product and/or below 70% when seeking \"Made with Organic\" status, or if you require a more precise calculation for whatever reason. "]
[" ",{"$f":"VLOOKUP(A18,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A19,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A20,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
["Water","NonOrganic"]
["Processing Aids:","Ingredient status","% by weight in product","Notes"]
[" ",{"$f":"VLOOKUP(A23,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A24,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A25,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A26,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A27,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[]
[]
[]
[]
["To create new blank OPPs, right click on the sheet you want to copy and do the following:"]

{"sheet":"Bottled Green Ginger Tea","index":4,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,8,11,11],[11,12,11,13],[12,8,12,11],[12,12,12,13],[2,5,3,6],[5,5,6,5],[5,6,6,6],[12,5,14,6],[13,8,13,11],[13,12,13,13],[4,8,6,13],[7,8,7,11],[7,12,7,13],[8,8,8,11],[16,5,26,13],[0,0,0,7],[1,5,1,6],[1,8,1,13],[2,8,2,9],[2,10,2,13],[3,8,3,9],[3,10,3,13],[8,12,8,13],[9,8,9,11],[9,12,9,13],[10,8,10,11],[14,8,14,11],[14,12,14,13],[1,1,1,2],[10,12,10,13]]}
["Instructions: Create a copy of a blank OPP for each multi-ingredient product requesting certification (see instructions on how to make a copy at bottom of this sheet). Rename OPP sheet to the name of the certified product. Select product name from drop-down list in cell B2 (only products noted in \"Products Requested for Cert\" sheet will be available to  select). In column A, select product ingredients and processing aids (including water and salt) from the drop down list (only ingredients noted in \"Ingredients & Processing Aids\" sheet will be available to select). Organic status of ingredient will auto-populate in column B. Input product formula (by weight) in column C. Ensure that the sum of all ingredients = 100 in cell G14. If you need more rows, unlock sheet (no password), right click table, select \"Insert\", and select \"Table Rows Above\".",null,null,null,null,null,null,null,null,null,null,null,null,null,"yes","no"]
["Name of product requested for certification:","Bottled Green Ginger Tea",null,{"$f":"VLOOKUP(B2,'Products Requested for Cert'!$A$3:$C$200,3,0)","v":"Organic"},null,"Equivalences/Export Arrangements requested:",null,null,"QCS Office Use Only"]
["Ingredient (select from drop down list)","Ingredient status","% by weight in product","Notes",null,{"$f":"VLOOKUP(B2,'Products Requested for Cert'!$A$3:$D$200,4,0)","v":"NOP-CAN, NOP-EU"},null,null,"Approved by:"]
["Green Tea Concentrate",{"$f":"VLOOKUP(A4,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"99% Organic (w/ COA)"},7,null,null,null,null,null,"Date approved:"]
["Honey Granules",{"$f":"VLOOKUP(A5,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"Organic"},4,null,null,null,null,null,"For \"Organic\" or \"Made with Organic\" ingredients with known % organic amounts >95% or 70% respectively, list here and recalculate % organic in final product as needed:"]
["Ginger Concentrate",{"$f":"VLOOKUP(A6,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"97% Organic (w/ COA)"},1.5,null,null,"Does this product contain sulfites, nitrates, or nitrites added during the production or handling process?"]
["Buckwheat, roasted",{"$f":"VLOOKUP(A7,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"Organic"},1]
["Spearamint, dry",{"$f":"VLOOKUP(A8,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"100% Organic"},1,null,null,null,null,null,"Ingredient:",null,null,null,"Actual % Organic"]
["Salt",{"$f":"VLOOKUP(A9,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"NonOrganic"},0.25,null,null,"Sum of all ingredients",{"$f":"SUM($C$4:$C$27)","v":100},null," "]
[" ",{"$f":"VLOOKUP(A10,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Sum of organic ingredients",{"$f":"(SUMIF($B$4:$B$27,\"100% Organic\",$C$4:$C$27))+(0.95*SUMIF($B$4:$B$27,\"Organic\",$C$4:$C$27))+(0.9999*SUMIF($B$4:$B$27,\"Organic Raw Agricultural Product\",$C$4:$C$27))+(0.7*SUMIF($B$4:$B$27,\"Made with Organic\",$C$4:$C$27))+(0.99*SUMIF($B$4:$B$27,\"99% Organic (w/ COA)\",$C$4:$C$27))+(0.98*SUMIF($B$4:$B$27,\"98% Organic (w/ COA)\",$C$4:$C$27))+(0.97*SUMIF($B$4:$B$27,\"97% Organic (w/ COA)\",$C$4:$C$27))+(0.96*SUMIF($B$4:$B$27,\"96% Organic (w/ COA)\",$C$4:$C$27))","v":14.135},null," "]
[" ",{"$f":"VLOOKUP(A11,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"% organic ingredients (excluding water & salt)*",{"$f":"100*(G10/(G9-SUMIF($A$4:$A$27,\"Salt\",$C$4:$C$27)-SUMIF($A$4:$A$27,\"Water\",$C$4:$C$27)))","v":95.830508474576277},null," "]
[" ",{"$f":"VLOOKUP(A12,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null," "]
[" ",{"$f":"VLOOKUP(A13,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Additional comments:",null,null," "]
[" ",{"$f":"VLOOKUP(A14,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null," "]
[" ",{"$f":"VLOOKUP(A15,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"Manual % organic ingredients calculation:"]
[" ",{"$f":"VLOOKUP(A16,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A17,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"*Note that the \"% organic ingredients\" formula uses, by default, a value of 95% organic for \"Organic\" labeled ingredients, and 70% organic for \"Made with Organic\" labeled ingredients, per the minimum allowances set forth in §205.301 for each organic category. Since these are set at the lowest acceptable range for their respective categories, the formula's output may be artificially low. \n\nTo address this, a subset of values between 95% organic and 100% organic are available for you to select on the ingredients sheet, provided you have a COA verifying the ingredient's composition, or provided that the \"Organic\" product is a raw agricultural product. If extra precision outside these few values is required, indicate as such on the notes column, and the % organic ingredients formula can be manually calculated.\n\nThe only reason this additional level of precision might matter is if the \"% organic ingredients\" formula produces a result below 95% when you are seeking \"Organic\" status for your final product and/or below 70% when seeking \"Made with Organic\" status, or if you require a more precise calculation for whatever reason. "]
[" ",{"$f":"VLOOKUP(A18,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A19,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A20,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
["Water","NonOrganic",85]
["Processing Aids:","Ingredient status","% by weight in product","Notes"]
["Ascorbic Acid",{"$f":"VLOOKUP(A23,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"NonOrganic"},0.25]
[" ",{"$f":"VLOOKUP(A24,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A25,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A26,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A27,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[]
[]
[]
[]
["To create new blank OPPs, right click on the sheet you want to copy and do the following:"]

{"sheet":"Sleepy Tea","index":5,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,8,8,11],[8,12,8,13],[0,0,0,7],[1,1,1,2],[1,5,1,6],[1,8,1,13],[2,5,3,6],[2,8,2,9],[2,10,2,13],[3,8,3,9],[3,10,3,13],[4,8,6,13],[5,5,6,5],[5,6,6,6],[7,8,7,11],[7,12,7,13],[9,8,9,11],[9,12,9,13],[10,8,10,11],[10,12,10,13],[11,8,11,11],[11,12,11,13],[16,5,26,13],[12,5,14,6],[12,8,12,11],[12,12,12,13],[13,8,13,11],[13,12,13,13],[14,8,14,11],[14,12,14,13]]}
["Instructions: Create a copy of a blank OPP for each multi-ingredient product requesting certification (see instructions on how to make a copy at bottom of this sheet). Rename OPP sheet to the name of the certified product. Select product name from drop-down list in cell B2 (only products noted in \"Products Requested for Cert\" sheet will be available to  select). In column A, select product ingredients and processing aids (including water and salt) from the drop down list (only ingredients noted in \"Ingredients & Processing Aids\" sheet will be available to select). Organic status of ingredient will auto-populate in column B. Input product formula (by weight) in column C. Ensure that the sum of all ingredients = 100 in cell G14. If you need more rows, unlock sheet (no password), right click table, select \"Insert\", and select \"Table Rows Above\".",null,null,null,null,null,null,null,null,null,null,null,null,null,"yes","no"]
["Name of product requested for certification:","Sleepy Tea, Loose",null,{"$f":"VLOOKUP(B2,'Products Requested for Cert'!$A$3:$C$200,3,0)","v":"100% Organic"},null,"Equivalences/Export Arrangements requested:",null,null,"QCS Office Use Only"]
["Ingredient (select from drop down list)","Ingredient status","% by weight in product","Notes",null,{"$f":"VLOOKUP(B2,'Products Requested for Cert'!$A$3:$D$200,4,0)","v":" "},null,null,"Approved by:"]
["Chamomile",{"$f":"VLOOKUP(A4,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"100% Organic"},50,null,null,null,null,null,"Date approved:"]
["Cat Nip",{"$f":"VLOOKUP(A5,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"100% Organic"},25,null,null,null,null,null,"For \"Organic\" or \"Made with Organic\" ingredients with known % organic amounts >95% or 70% respectively, list here and recalculate % organic in final product as needed:"]
["Peppermint, dry",{"$f":"VLOOKUP(A6,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"100% Organic"},15,null,null,"Does this product contain sulfites, nitrates, or nitrites added during the production or handling process?"]
["Licorice ",{"$f":"VLOOKUP(A7,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":"100% Organic"},10]
[" ",{"$f":"VLOOKUP(A8,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"Ingredient:",null,null,null,"Actual % Organic"]
[" ",{"$f":"VLOOKUP(A9,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Sum of all ingredients",{"$f":"SUM($C$4:$C$27)","v":100},null," "]
[" ",{"$f":"VLOOKUP(A10,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Sum of organic ingredients",{"$f":"(SUMIF($B$4:$B$27,\"100% Organic\",$C$4:$C$27))+(0.95*SUMIF($B$4:$B$27,\"Organic\",$C$4:$C$27))+(0.9999*SUMIF($B$4:$B$27,\"Organic Raw Agricultural Product\",$C$4:$C$27))+(0.7*SUMIF($B$4:$B$27,\"Made with Organic\",$C$4:$C$27))+(0.99*SUMIF($B$4:$B$27,\"99% Organic (w/ COA)\",$C$4:$C$27))+(0.98*SUMIF($B$4:$B$27,\"98% Organic (w/ COA)\",$C$4:$C$27))+(0.97*SUMIF($B$4:$B$27,\"97% Organic (w/ COA)\",$C$4:$C$27))+(0.96*SUMIF($B$4:$B$27,\"96% Organic (w/ COA)\",$C$4:$C$27))","v":100},null," "]
[" ",{"$f":"VLOOKUP(A11,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"% organic ingredients (excluding water & salt)*",{"$f":"100*(G10/(G9-SUMIF($A$4:$A$27,\"Salt\",$C$4:$C$27)-SUMIF($A$4:$A$27,\"Water\",$C$4:$C$27)))","v":100},null," "]
[" ",{"$f":"VLOOKUP(A12,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null," "]
[" ",{"$f":"VLOOKUP(A13,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"Additional comments:",null,null," "]
[" ",{"$f":"VLOOKUP(A14,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null," "]
[" ",{"$f":"VLOOKUP(A15,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,null,null,null,"Manual % organic ingredients calculation:"]
[" ",{"$f":"VLOOKUP(A16,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A17,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "},null,null,null,"*Note that the \"% organic ingredients\" formula uses, by default, a value of 95% organic for \"Organic\" labeled ingredients, and 70% organic for \"Made with Organic\" labeled ingredients, per the minimum allowances set forth in §205.301 for each organic category. Since these are set at the lowest acceptable range for their respective categories, the formula's output may be artificially low. \n\nTo address this, a subset of values between 95% organic and 100% organic are available for you to select on the ingredients sheet, provided you have a COA verifying the ingredient's composition, or provided that the \"Organic\" product is a raw agricultural product. If extra precision outside these few values is required, indicate as such on the notes column, and the % organic ingredients formula can be manually calculated.\n\nThe only reason this additional level of precision might matter is if the \"% organic ingredients\" formula produces a result below 95% when you are seeking \"Organic\" status for your final product and/or below 70% when seeking \"Made with Organic\" status, or if you require a more precise calculation for whatever reason. "]
[" ",{"$f":"VLOOKUP(A18,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A19,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A20,'[1]Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
["Water","NonOrganic"]
["Processing Aids:","Ingredient status","% by weight in product","Notes"]
[" ",{"$f":"VLOOKUP(A23,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A24,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A25,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A26,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[" ",{"$f":"VLOOKUP(A27,'Ingredients & Processing Aids'!$A$3:$B$200,2,0)","v":" "}]
[]
[]
[]
[]
["To create new blank OPPs, right click on the sheet you want to copy and do the following:"]