{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Read me","Import Certificate","Request form","VBAHelper"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":5,"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":"Read me","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Instructions on how to fill in this request form",null,null,null,null,null,null,null,null,"year","month","days","<= ne pas supprimer"]
[null,null,null,null,null,null,null,null,null,2024,1,1]
[null,"These instructions are designed to help you complete the National Organic Program (NOP) Import Certificate request form (2nd tab):",null,null,null,null,null,null,null,2025,2,2]
[null,"mandatory fields to be completed",null,null,null,null,null,null,null,2026,3,3]
[null,"Please complete 1 Request form per importer",null,null,null,null,null,null,null,2027,4,4]
[1,"certification standard","Select from Organic Standards List - Dropdown Menu - for NOP certified products: select USDA-NOP (U.S.A.)",null,null,null,null,null,null,2028,5,5]
[2,"Products Exported from (country)","Country from where the products are leaving, after final handling.",null,null,null,null,null,null,2029,6,6]
[3,"Export date ","Declare the date of export (the earliest possible departure);\nNote: the effective 'start date' that will appear on the generated NOPIC (box 3) can never be earlier than the date of publication of the NOPIC generated in the Organic INTEGRITY Database.   ",null,null,null,null,null,null,2030,7,7]
[4,"End date","The end date defines the validity period during which the product(s) may be exported from the country of export. It will not be a problem if the shipment arrives in the US after the 'end date' has past. \nE.g.: if Ecocert has allowed to issue a NOPIC for your products for 3 months, this date should be: start date + 3 months.\nFor NOPIC issued for 1 single shipment, this validity period must cover the export time frame of this shipment.",null,null,null,null,null,null,2031,8,8]
[5,"Single Shipment?","Select 'yes' if 1 NOPIC is to be issued for 1 single shipment --> to be mentioned in the Remarks box of generated NOPIC\nSelect 'No' if 1 NOPIC is to be issued for multiple shipments during a time frame granted by Ecocert",null,null,null,null,null,null,null,9,9]
[6,"Exporter name"," The exporter to be mentioned on the NOPIC is the operation selling abroad and organizing the export and associated export documentation (export declaration, booking the transport, responsible for transport document, incoterms...). The exporter may eventually be located in a different country than the product. Pure traders/financial intermediaries who are not organizing the shipment are not considered as exporters to be mentioned on NOP IC, and will not appear on the NOPIC. If the final producer or preparer of the product is not the exporter, this will be reflected in Box 18 of this request form.",null,null,null,null,null,null,null,10,10]
[7,"NOP ID exporter (OID) ","NOP's 10-digit unique ID for exporter.  - https://organic.ams.usda.gov/integrity/Home/1 ",null,null,null,null,null,null,null,11,11]
[8,"exporter address","Enter the certified exporter address.",null,null,null,null,null,null,null,12,12]
[9,"Importer  name ","The 'RECIPIENT' name on the NOPIC should be the US IMPORTER, being the operator responsible for declaring the imported goods (even if done through a custom broker most of the time), and for receiving them for release on the US market (financially or physically). The importer may be located in the US or out of the US (foreign importer of record). \nNote: the city and state of the mentioned importer will be automatically reported in box 2 of the NOPIC pdf template.",null,null,null,null,null,null,null,null,13]
[10,"NOP ID importer (OID) - ","NOP's 10-digit unique ID for importer -  https://organic.ams.usda.gov/integrity/Home/1",null,null,null,null,null,null,null,null,14]
[11,"Importer address","Enter the certified importer address.",null,null,null,null,null,null,null,null,15]
[12,"Product name ","Name of concerned product or commodity type.\nNote: One NOP Import Certificate can be issued per commodity (e.g., green tea) with one same Harmonized Tariff Schedule (HTS)code. As long as the commodity is the same, the size of the packaging can vary. ",null,null,null,null,null,null,null,null,17]
[13,"HTS code ","10-digit product Harmonized Tariff Code that will be used to clear the product as organic in the US; HTS codes can be found on https://hts.usitc.gov (do not include any punctuation)",null,null,null,null,null,null,null,null,18]
[14,"Estimated Total net weight (kg)","indicate the estimated net weight in Kilograms (KG) to be shipped to this same Importer ",null,null,null,null,null,null,null,null,19]
[15,"in bulk or packaged?","bulk= unpackaged products that are not in sealed, tamper-evident packaging or containers.  Tamper-evident packaging means that the contents are sealed in a manner where an attempt to break the seal, access the contents, or reclose the package would be obvious.",null,null,null,null,null,null,null,null,20]
[16,"total number of containers","If applicable, enter the total number of containers carrying this product, covered by the NOPIC - to be completed mandatorily if 1 NOPIC covers 1 shipment only. ",null,null,null,null,null,null,null,null,21]
[17,"Shipping identification: lot number(s)","Enter the lot number(s) of the product covered by the NOPIC - to be completed for the 1st shipment  ",null,null,null,null,null,null,null,null,22]
[18,"final handler name (when different from exporter)","Enter the name of the producer or preparer of the product when different from the exporter. Operation performing only Storage activity are not concerned – operation performing packaging and / or labelling are concerned. The Final Handler must be certified and validated on the organic INTEGRITY database by their Certifier.",null,null,null,null,null,null,null,null,23]
[19,"NOP ID final handler OID - ","NOP's 10-digit unique ID for Final handler  - https://organic.ams.usda.gov/integrity/Home/1",null,null,null,null,null,null,null,null,24]
[20,"Final handler address","Enter the Final handler address",null,null,null,null,null,null,null,null,25]
[21,"Additional declaration ","Add any additional declaration about the product that could be useful, if necessary.",null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,31]

{"sheet":"Import Certificate","index":1,"n_rows":24,"n_cols":95,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["ic_certNum","ic_certStatus","ic_certifier","ic_isuCbWebSite","ic_isuCbHasAltContact","ic_isuCbContAddLine1","ic_isuCbContAddLine2","ic_isuCbContCity","ic_isuCbContState","ic_isuCbContCountry","ic_isuCbContZip","ic_isuCbContFName","ic_isuCbContLName","ic_isuCbContPhone","ic_isuCbContEmail","ic_program","ic_SingleShipment","ic_startDate","ic_endDate","ic_expCountry","ic_expNOPId","ic_altExpContact","ic_altExpFirstName","ic_altExpLastName","ic_altExpPhNum","ic_altExpEmail","ic_unCertExp","ic_unCertExpOpName","ic_unCertExpAddLine1","ic_unCertExpAddLine2","ic_unCertExpCity","ic_unCertExpState","ic_unCertExpCountry","ic_unCertExpZipPostal","ic_ucExpFirstName","ic_ucExpLastName","ic_ucExpPhNum","ic_ucExpEmail","ic_fhSameExp","ic_fhNopId","ic_fhAltContact","ic_fhAltFirstName","ic_fhAltLastName","ic_fhAltPhNum","ic_fhAltEmail","ic_fhOpName","ic_fhAddLine1","ic_fhAddLine2","ic_fhCity","ic_fhState","ic_fhCountry","ic_fhZip","ic_fhContactFName","ic_fhContactLName","ic_fhContactPhone","ic_fhContactEmail","ic_fhCertBody","ic_fhCBAddLine1","ic_fhCBAddLine2","ic_fhCBCity","ic_fhCBState","ic_fhCBCountry","ic_fhCBZip","ic_fhCBFName","ic_fhCBLName","ic_fhCBPhone","ic_fhCBEmail","ic_recNopId","ic_altRecContact","ic_altRecFirstName","ic_altRecLastName","ic_altRecPhNum","ic_altRecEmail","ic_unCertRec","ic_unCertRecOpName","ic_unCertRecAddLine1","ic_unCertRecAddLine2","ic_unCertRecCity","ic_unCertRecState","ic_unCertRecCountry","ic_unCertRecZipPostal","ic_ucRecFirstName","ic_ucRecLastName","ic_ucRecPhNum","ic_ucRecEmail","ic_product","ic_htsCode","ic_totalWeight","ic_totalContainers","ic_lotNum","ic_productCityState","ic_remarks","ic_attestations","ic_certIssuerFullName","ic_dateSigned"]
["Import Certificate Number (Box 4)","Import Certificate Status","Certifying Body (CB) Issuing Certificate (Box 8)","Issuing CB Website","Issuing CB Alternate Contact Information (Box 8)","Issuing CB Contact Address Line 1 (Box 8)","Issuing CB Contact Address Line 2 (Box 8)","Issuing CB Contact City (Box 8)","Issuing CB Contact State/ Province (Box 8)","Issuing CB Contact Country (Box 8)","Issuing CB Contact ZIP/Postal Code (Box 8)","Issuing CB Contact First Name (Box 8)","Issuing CB Contact Last Name (Box 8)","Issuing CB Contact Phone Number (Box 8)"," Issuing CB Contact Email (Box 8)","Organic Standard Product Certified To (Box 1)","Single Shipment","Certificate Start Date (Box 3)","Certificate End Date (Box 3)","Product Exported From (Box 6)","Certified Exporter NOP ID (Box 5)","Alternate Certified Exporter Contact Information","Alternate Certified Exporter Contact First Name (Box 5)","Alternate Certified Exporter Contact Last Name (Box 5)","Alternate Certified Exporter Contact Phone Number (Box 5)","Alternate Certified Exporter Contact Email (Box 5)","Uncertified Exporter","Exporter Operation Name (Box 5)","Exporter Address Line 1 (Box 5)","Exporter Address Line 2 (Box 5)","Exporter City (Box 5)","Exporter State/ Province (Box 5)","Exporter Country (Box 5)","Exporter ZIP/Postal Code (Box 5)","Exporter Contact First Name (Box 5)","Exporter Contact Last Name (Box 5)","Exporter Contact Phone Number (Box 5)","Exporter Contact Email (Box 5)","Final Handler is the same as Exporter","Certified Final Handler NOP ID (Box 14)","Alternate Final Handler Contact Information","Alternate Final Handler Contact First Name (Box 14)","Alternate Final Handler Contact Last Name (Box 14)","Alternate Final Handler Contact Phone Number (Box 14)","Alternate Final Handler Contact Email (Box 14)","Final Handler Operation Name (Box 14)","Final Handler Address Line 1 (Box 14)","Final Handler Address Line 2 (Box 14)","Final Handler City (Box 14)","Final Handler State/ Province (Box 14)","Final Handler Country (Box14)","Final Handler ZIP/Postal Code (Box 14)","Final Handler Contact First Name (Box 14)","Final Handler Contact Last Name (Box 14)","Final Handler Contact Phone Number (Box 14)","Final Handler Contact Email (Box 14)","Certifying Body (CB) of Final Handler (Box 15)","Final Handler CB Address Line 1 (Box 15)","Final Handler CB Address Line 2 (Box 15)","Final Handler CB City (Box 15)","Final Handler CB State/Province (Box 15)","Final Handler CB Country (Box 15)","Final Handler CB ZIP/Postal Code (Box 15)","Final Handler CB Contact First Name (Box 15)","Final Handler CB Contact Last Name (Box 15)","Final Handler CB Contact Phone Number (Box 15)","Final Handler CB Contact Email (Box 15)","NOP ID for Certified Recipient in the U.S. (Box 7)","Alternate Certified Recipient Contact Information","Alternate Certified Recipient Contact First Name (Box 7)","Alternate Certified Recipient Contact Last Name (Box 7)","Alternate Certified Recipient Contact Phone Number (Box 7)","Alternate Certified Recipient Contact Email (Box 7)","Uncertified Recipient (Box 7)","Recipient Operation Name (Box 7)","Recipient Address Line 1 (Box 7)","Recipient Address Line 2 (Box 7)","Recipient City (Box 7)","Recipient State (box 7)","Recipient Country (Box 7)","Recipient ZIP/Postal Code (Box 7)","Recipient Contact First Name (Box 7)","Recipient Contact Last Name (Box 7)","Recipient Phone Number (Box 7)","Recipient Email (Box 7)","Product As Labeled (Box 11)","HTS Code (Box 12)","Total Net Weight (Box 9)","Total Containers (Box 10) ","Shipping Identification - Flight #, Vessel #, Container #, Lot #, etc.  (Box 13) ","City and State of Product Destination (Box 2)","Remarks (Box 16)","Attestations (Box 16)","Certificate Issuer Full Name (Box 17)","Date Signed  (Box 18)"]
["Optional","Autofilled - Do Not Edit","Autofilled from User Profile - Do Not Edit","Autofilled from User Profile - Do Not Edit","Yes as applicable","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Optional for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact (US)","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Autofilled or Required for Issuing Certifier Satellite Office/ Alternate Contact","Required","Yes as applicable","Required","Required - Published ICs can be edited to up to 18 months from Start Date.","Required","Required for Certified Exporters. If Certified, do not complete columns AA-AL.","Yes as applicable","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Optional. If any data is entered into columns W-Z, all columns must be complete in order to generate certificate.","Yes as applicable","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Optional; Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified.","Required if Uncertified (US). Autofilled if Certified.","Required if Uncertified, Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified.","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Yes as applicable","Required if Final Handler is not same as Certified Exporter (Column AM = No)","Yes as applicable","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns AP-AS, all columns must be complete in order to generate certificate.","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled from Final Handler Operation Profile","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Autofilled","Required for Certified Recipients. If Certified, do not complete columns BV-CG.","Yes as applicable","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Optional. If any data entered into columns BR-BU, all columns must be complete in order to generate certificate.","Yes as applicable","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Optional, Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified (US). Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required if Uncertified, Autofilled if Certified","Required","Required","Required - Published ICs can be edited.","Optional - Published ICs can be edited.","Optional - Published ICs can be edited.","Autofilled from Recipient in U.S. - Do Not Edit","Optional - Published ICs can be edited.","Required","Autofilled from User Profile - Do Not Edit.","Autofilled from Publication Date - Do Not Edit."]
["Leave blank for new certificates, enter existing certificate number to edit. Columns S, CJ, CK, CL, CN can be edited.","Valid/Invalid. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Certifier Name (ISO 3 Letter Country Code for Program). Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile.  Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Yes/No. Leave columns F-O blank if no Issuing Certifier Satellite Office/Alternate Contact Information is needed.","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office Alternate Information.","From Certifier Profile or Satellite Office Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","From Certifier Profile or Satellite Office/User Alternate Information","Select from Organic Standards List","Yes/No","Date the selected Import Certificate became effective. MM/DD/YYYY","Date the selected Import Certificate  effective date ended. For single shipment, enter same date as Start Date. MM/DD/YYYY","Select from Country List","NOP's 10-digit unique ID for operation. If entered, columns AA-AL  will be ignored.","Yes/No. Leave columns W-Z blank if no Alternate Exporter Contact Information is needed.",null,null,null,null,"Yes/No. Leave columns AB-AL blank if Certified Exporter NOP Operation ID is entered in Column U. ","Operation's business name. Do not edit if Certified- database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Select from Country List.  Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Do not edit if Certified - database does not process this column for Certified Exporters.","Yes/No. If Yes, do not complete columns AN-BD, and column U must be completed with NOP 10-digit unique ID for Certified Exporter","NOP's 10-digit unique ID for operation. Final Handler must be certified.","Yes/No. Leave columns AP-AS blank if no Alternate Certified Final Handler Contact Information is needed.",null,null,null,null,"Operation's business name. Available in exports from Published ICs/IC Search. Do not edit  - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Certifier Name (ISO 3 Letter Country Code for Program). Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","From Certifier Profile. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","NOP's 10-digit unique ID for operation. ","Yes/No. Leave columns BR-BU blank if no Alternate Certified Recipient Contact Information is needed. ",null,null,null,null,"Yes/No. Leave columns BW-CG blank if Certified Recipient NOP Operation ID is entered in Column BP.","Operation's business name. Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Select from Country List.  Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","Do not edit if Certified - database does not process this column for Certified Recipients.","For raw products, enter the common name of the products(s). For packaged products, enter the name shown on the principal display panel (front of the package).","10-digit HTS Code from https://hts.usitc.gov (do not include punctuation)","Kilograms (KG) for all shipments.","Integer whole number","Max 4,000 Characters","Recipient City and State. Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Max 256 Characters.","Select from Attestation List","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column.","Available in exports from Published ICs/IC Search. Do not edit - database does not process this column."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH5<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH5<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH5<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH5<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH5<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH5<>\"\",'Request form'!$D$11,\"\")","v":""},{"$f":"IF($CH5<>\"\",\"No\",\"\")","v":""},null,null,null,null,{"$f":"IF($CH5<>\"\",\"No\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH5<>\"\",IF('Request form'!D25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH5<>\"\",IF(AM5=\"No\",'Request form'!D25,\"\"),\"\")","v":""},{"$f":"IF($CH5<>\"\",\"No\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH5<>\"\",'Request form'!$D$14,\"\")","v":""},{"$f":"IF($CH5<>\"\",\"No\",\"\")","v":""},null,null,null,null,{"$f":"IF($CH5<>\"\",\"No\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!D18<>\"\",'Request form'!D18,\"\")","v":""},{"$f":"IF(CH5<>\"\",'Request form'!D19,\"\")","v":""},{"$f":"IF(CH5<>\"\",'Request form'!D20,\"\")","v":""},{"$f":"IF(AND(CH5<>\"\",'Request form'!D22<>\"\"),'Request form'!D22,\"\")","v":""},{"$f":"IF(AND(CH5<>\"\",'Request form'!D23<>\"\"),'Request form'!D23,\"\")","v":""},{"$f":"IF(CI5<>\"\",'Request form'!E23,\"\")","v":""},{"$f":"IF(AND(CH5<>\"\",'Request form'!D27<>\"\"),'Request form'!D27,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P5,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH6<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH6<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH6<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH6<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH6<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH6<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH6<>\"\",IF('Request form'!G25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH6<>\"\",IF(AM6=\"No\",'Request form'!G25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH6<>\"\",'Request form'!$D$14,\"\")","v":""},{"$f":"IF($CH6<>\"\",\"No\",\"\")","v":""},null,null,null,null,{"$f":"IF($CH6<>\"\",\"No\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!G18<>\"\",'Request form'!G18,\"\")","v":""},{"$f":"IF(CH6<>\"\",'Request form'!G19,\"\")","v":""},{"$f":"IF(CH6<>\"\",'Request form'!G20,\"\")","v":""},{"$f":"IF(AND(CH6<>\"\",'Request form'!D23<>\"\"),'Request form'!D23,\"\")","v":""},{"$f":"IF(AND(CH6<>\"\",'Request form'!D24<>\"\"),'Request form'!D24,\"\")","v":""},{"$f":"IF(CI6<>\"\",'Request form'!E24,\"\")","v":""},{"$f":"IF(AND(CH6<>\"\",'Request form'!D28<>\"\"),'Request form'!D28,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P6,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH7<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH7<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH7<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH7<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH7<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH7<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH7<>\"\",IF('Request form'!H25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH7<>\"\",IF(AM7=\"No\",'Request form'!H25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH7<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!H18<>\"\",'Request form'!H18,\"\")","v":""},{"$f":"IF(CH7<>\"\",'Request form'!H19,\"\")","v":""},{"$f":"IF(CH7<>\"\",'Request form'!H20,\"\")","v":""},{"$f":"IF(AND(CH7<>\"\",'Request form'!D24<>\"\"),'Request form'!D24,\"\")","v":""},{"$f":"IF(AND(CH7<>\"\",'Request form'!D25<>\"\"),'Request form'!D25,\"\")","v":""},{"$f":"IF(CI7<>\"\",'Request form'!E25,\"\")","v":""},{"$f":"IF(AND(CH7<>\"\",'Request form'!D29<>\"\"),'Request form'!D29,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P7,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH8<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH8<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH8<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH8<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH8<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH8<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH8<>\"\",IF('Request form'!I25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH8<>\"\",IF(AM8=\"No\",'Request form'!I25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH8<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!I18<>\"\",'Request form'!I18,\"\")","v":""},{"$f":"IF(CH8<>\"\",'Request form'!I19,\"\")","v":""},{"$f":"IF(CH8<>\"\",'Request form'!I20,\"\")","v":""},{"$f":"IF(AND(CH8<>\"\",'Request form'!D25<>\"\"),'Request form'!D25,\"\")","v":""},{"$f":"IF(AND(CH8<>\"\",'Request form'!D26<>\"\"),'Request form'!D26,\"\")","v":""},{"$f":"IF(CI8<>\"\",'Request form'!E26,\"\")","v":""},{"$f":"IF(AND(CH8<>\"\",'Request form'!D30<>\"\"),'Request form'!D30,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P8,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH9<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH9<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH9<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH9<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH9<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH9<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH9<>\"\",IF('Request form'!J25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH9<>\"\",IF(AM9=\"No\",'Request form'!J25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH9<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!J18<>\"\",'Request form'!J18,\"\")","v":""},{"$f":"IF(CH9<>\"\",'Request form'!J19,\"\")","v":""},{"$f":"IF(CH9<>\"\",'Request form'!J20,\"\")","v":""},{"$f":"IF(AND(CH9<>\"\",'Request form'!D26<>\"\"),'Request form'!D26,\"\")","v":""},{"$f":"IF(AND(CH9<>\"\",'Request form'!D27<>\"\"),'Request form'!D27,\"\")","v":""},{"$f":"IF(CI9<>\"\",'Request form'!E27,\"\")","v":""},{"$f":"IF(AND(CH9<>\"\",'Request form'!D31<>\"\"),'Request form'!D31,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P9,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH10<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH10<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH10<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH10<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH10<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH10<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH10<>\"\",IF('Request form'!K25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH10<>\"\",IF(AM10=\"No\",'Request form'!K25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH10<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!K18<>\"\",'Request form'!K18,\"\")","v":""},{"$f":"IF(CH10<>\"\",'Request form'!K19,\"\")","v":""},{"$f":"IF(CH10<>\"\",'Request form'!K20,\"\")","v":""},{"$f":"IF(AND(CH10<>\"\",'Request form'!D27<>\"\"),'Request form'!D27,\"\")","v":""},{"$f":"IF(AND(CH10<>\"\",'Request form'!D28<>\"\"),'Request form'!D28,\"\")","v":""},{"$f":"IF(CI10<>\"\",'Request form'!E28,\"\")","v":""},{"$f":"IF(AND(CH10<>\"\",'Request form'!D32<>\"\"),'Request form'!D32,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P10,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH11<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH11<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH11<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH11<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH11<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH11<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH11<>\"\",IF('Request form'!L25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH11<>\"\",IF(AM11=\"No\",'Request form'!L25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH11<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!L18<>\"\",'Request form'!L18,\"\")","v":""},{"$f":"IF(CH11<>\"\",'Request form'!L19,\"\")","v":""},{"$f":"IF(CH11<>\"\",'Request form'!L20,\"\")","v":""},{"$f":"IF(AND(CH11<>\"\",'Request form'!D28<>\"\"),'Request form'!D28,\"\")","v":""},{"$f":"IF(AND(CH11<>\"\",'Request form'!D29<>\"\"),'Request form'!D29,\"\")","v":""},{"$f":"IF(CI11<>\"\",'Request form'!E29,\"\")","v":""},{"$f":"IF(AND(CH11<>\"\",'Request form'!D33<>\"\"),'Request form'!D33,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P11,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH12<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH12<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH12<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH12<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH12<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH12<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH12<>\"\",IF('Request form'!M25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH12<>\"\",IF(AM12=\"No\",'Request form'!M25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH12<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!M18<>\"\",'Request form'!M18,\"\")","v":""},{"$f":"IF(CH12<>\"\",'Request form'!M19,\"\")","v":""},{"$f":"IF(CH12<>\"\",'Request form'!M20,\"\")","v":""},{"$f":"IF(AND(CH12<>\"\",'Request form'!D29<>\"\"),'Request form'!D29,\"\")","v":""},{"$f":"IF(AND(CH12<>\"\",'Request form'!D30<>\"\"),'Request form'!D30,\"\")","v":""},{"$f":"IF(CI12<>\"\",'Request form'!E30,\"\")","v":""},{"$f":"IF(AND(CH12<>\"\",'Request form'!D34<>\"\"),'Request form'!D34,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P12,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH13<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH13<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH13<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH13<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH13<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH13<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH13<>\"\",IF('Request form'!N25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH13<>\"\",IF(AM13=\"No\",'Request form'!N25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH13<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!N18<>\"\",'Request form'!N18,\"\")","v":""},{"$f":"IF(CH13<>\"\",'Request form'!N19,\"\")","v":""},{"$f":"IF(CH13<>\"\",'Request form'!N20,\"\")","v":""},{"$f":"IF(AND(CH13<>\"\",'Request form'!D30<>\"\"),'Request form'!D30,\"\")","v":""},{"$f":"IF(AND(CH13<>\"\",'Request form'!D31<>\"\"),'Request form'!D31,\"\")","v":""},{"$f":"IF(CI13<>\"\",'Request form'!E31,\"\")","v":""},{"$f":"IF(AND(CH13<>\"\",'Request form'!D35<>\"\"),'Request form'!D35,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P13,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH14<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH14<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH14<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH14<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH14<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH14<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH14<>\"\",IF('Request form'!O25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH14<>\"\",IF(AM14=\"No\",'Request form'!O25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH14<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!O18<>\"\",'Request form'!O18,\"\")","v":""},{"$f":"IF(CH14<>\"\",'Request form'!O19,\"\")","v":""},{"$f":"IF(CH14<>\"\",'Request form'!O20,\"\")","v":""},{"$f":"IF(AND(CH14<>\"\",'Request form'!D31<>\"\"),'Request form'!D31,\"\")","v":""},{"$f":"IF(AND(CH14<>\"\",'Request form'!D32<>\"\"),'Request form'!D32,\"\")","v":""},{"$f":"IF(CI14<>\"\",'Request form'!E32,\"\")","v":""},{"$f":"IF(AND(CH14<>\"\",'Request form'!D36<>\"\"),'Request form'!D36,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P14,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH15<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH15<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH15<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH15<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH15<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH15<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH15<>\"\",IF('Request form'!P25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH15<>\"\",IF(AM15=\"No\",'Request form'!P25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH15<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!P18<>\"\",'Request form'!P18,\"\")","v":""},{"$f":"IF(CH15<>\"\",'Request form'!P19,\"\")","v":""},{"$f":"IF(CH15<>\"\",'Request form'!P20,\"\")","v":""},{"$f":"IF(AND(CH15<>\"\",'Request form'!D32<>\"\"),'Request form'!D32,\"\")","v":""},{"$f":"IF(AND(CH15<>\"\",'Request form'!D33<>\"\"),'Request form'!D33,\"\")","v":""},{"$f":"IF(CI15<>\"\",'Request form'!E33,\"\")","v":""},{"$f":"IF(AND(CH15<>\"\",'Request form'!D37<>\"\"),'Request form'!D37,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P15,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH16<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH16<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH16<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH16<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH16<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH16<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH16<>\"\",IF('Request form'!Q25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH16<>\"\",IF(AM16=\"No\",'Request form'!Q25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH16<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!Q18<>\"\",'Request form'!Q18,\"\")","v":""},{"$f":"IF(CH16<>\"\",'Request form'!Q19,\"\")","v":""},{"$f":"IF(CH16<>\"\",'Request form'!Q20,\"\")","v":""},{"$f":"IF(AND(CH16<>\"\",'Request form'!D33<>\"\"),'Request form'!D33,\"\")","v":""},{"$f":"IF(AND(CH16<>\"\",'Request form'!D34<>\"\"),'Request form'!D34,\"\")","v":""},{"$f":"IF(CI16<>\"\",'Request form'!E34,\"\")","v":""},{"$f":"IF(AND(CH16<>\"\",'Request form'!D38<>\"\"),'Request form'!D38,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P16,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH17<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH17<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH17<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH17<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH17<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH17<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH17<>\"\",IF('Request form'!R25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH17<>\"\",IF(AM17=\"No\",'Request form'!R25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH17<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!R18<>\"\",'Request form'!R18,\"\")","v":""},{"$f":"IF(CH17<>\"\",'Request form'!R19,\"\")","v":""},{"$f":"IF(CH17<>\"\",'Request form'!R20,\"\")","v":""},{"$f":"IF(AND(CH17<>\"\",'Request form'!D34<>\"\"),'Request form'!D34,\"\")","v":""},{"$f":"IF(AND(CH17<>\"\",'Request form'!D35<>\"\"),'Request form'!D35,\"\")","v":""},{"$f":"IF(CI17<>\"\",'Request form'!E35,\"\")","v":""},{"$f":"IF(AND(CH17<>\"\",'Request form'!D39<>\"\"),'Request form'!D39,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P17,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH18<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH18<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH18<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH18<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH18<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH18<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH18<>\"\",IF('Request form'!S25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH18<>\"\",IF(AM18=\"No\",'Request form'!S25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH18<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!S18<>\"\",'Request form'!S18,\"\")","v":""},{"$f":"IF(CH18<>\"\",'Request form'!S19,\"\")","v":""},{"$f":"IF(CH18<>\"\",'Request form'!S20,\"\")","v":""},{"$f":"IF(AND(CH18<>\"\",'Request form'!D35<>\"\"),'Request form'!D35,\"\")","v":""},{"$f":"IF(AND(CH18<>\"\",'Request form'!D36<>\"\"),'Request form'!D36,\"\")","v":""},{"$f":"IF(CI18<>\"\",'Request form'!E36,\"\")","v":""},{"$f":"IF(AND(CH18<>\"\",'Request form'!D40<>\"\"),'Request form'!D40,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P18,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH19<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH19<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH19<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH19<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH19<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH19<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH19<>\"\",IF('Request form'!T25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH19<>\"\",IF(AM19=\"No\",'Request form'!T25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH19<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!T18<>\"\",'Request form'!T18,\"\")","v":""},{"$f":"IF(CH19<>\"\",'Request form'!T19,\"\")","v":""},{"$f":"IF(CH19<>\"\",'Request form'!T20,\"\")","v":""},{"$f":"IF(AND(CH19<>\"\",'Request form'!D36<>\"\"),'Request form'!D36,\"\")","v":""},{"$f":"IF(AND(CH19<>\"\",'Request form'!D37<>\"\"),'Request form'!D37,\"\")","v":""},{"$f":"IF(CI19<>\"\",'Request form'!E37,\"\")","v":""},{"$f":"IF(AND(CH19<>\"\",'Request form'!D41<>\"\"),'Request form'!D41,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P19,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH20<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH20<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH20<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH20<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH20<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH20<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH20<>\"\",IF('Request form'!U25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH20<>\"\",IF(AM20=\"No\",'Request form'!U25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH20<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!U18<>\"\",'Request form'!U18,\"\")","v":""},{"$f":"IF(CH20<>\"\",'Request form'!U19,\"\")","v":""},{"$f":"IF(CH20<>\"\",'Request form'!U20,\"\")","v":""},{"$f":"IF(AND(CH20<>\"\",'Request form'!D37<>\"\"),'Request form'!D37,\"\")","v":""},{"$f":"IF(AND(CH20<>\"\",'Request form'!D38<>\"\"),'Request form'!D38,\"\")","v":""},{"$f":"IF(CI20<>\"\",'Request form'!E38,\"\")","v":""},{"$f":"IF(AND(CH20<>\"\",'Request form'!D42<>\"\"),'Request form'!D42,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P20,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH21<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH21<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH21<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH21<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH21<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH21<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH21<>\"\",IF('Request form'!V25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH21<>\"\",IF(AM21=\"No\",'Request form'!V25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH21<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!V18<>\"\",'Request form'!V18,\"\")","v":""},{"$f":"IF(CH21<>\"\",'Request form'!V19,\"\")","v":""},{"$f":"IF(CH21<>\"\",'Request form'!V20,\"\")","v":""},{"$f":"IF(AND(CH21<>\"\",'Request form'!D38<>\"\"),'Request form'!D38,\"\")","v":""},{"$f":"IF(AND(CH21<>\"\",'Request form'!D39<>\"\"),'Request form'!D39,\"\")","v":""},{"$f":"IF(CI21<>\"\",'Request form'!E39,\"\")","v":""},{"$f":"IF(AND(CH21<>\"\",'Request form'!D43<>\"\"),'Request form'!D43,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P21,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH22<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH22<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH22<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH22<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH22<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH22<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH22<>\"\",IF('Request form'!W25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH22<>\"\",IF(AM22=\"No\",'Request form'!W25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH22<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!W18<>\"\",'Request form'!W18,\"\")","v":""},{"$f":"IF(CH22<>\"\",'Request form'!W19,\"\")","v":""},{"$f":"IF(CH22<>\"\",'Request form'!W20,\"\")","v":""},{"$f":"IF(AND(CH22<>\"\",'Request form'!D39<>\"\"),'Request form'!D39,\"\")","v":""},{"$f":"IF(AND(CH22<>\"\",'Request form'!D40<>\"\"),'Request form'!D40,\"\")","v":""},{"$f":"IF(CI22<>\"\",'Request form'!E40,\"\")","v":""},{"$f":"IF(AND(CH22<>\"\",'Request form'!D44<>\"\"),'Request form'!D44,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P22,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH23<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH23<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH23<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH23<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH23<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH23<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH23<>\"\",IF('Request form'!X25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH23<>\"\",IF(AM23=\"No\",'Request form'!X25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH23<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!X18<>\"\",'Request form'!X18,\"\")","v":""},{"$f":"IF(CH23<>\"\",'Request form'!X19,\"\")","v":""},{"$f":"IF(CH23<>\"\",'Request form'!X20,\"\")","v":""},{"$f":"IF(AND(CH23<>\"\",'Request form'!D40<>\"\"),'Request form'!D40,\"\")","v":""},{"$f":"IF(AND(CH23<>\"\",'Request form'!D41<>\"\"),'Request form'!D41,\"\")","v":""},{"$f":"IF(CI23<>\"\",'Request form'!E41,\"\")","v":""},{"$f":"IF(AND(CH23<>\"\",'Request form'!D45<>\"\"),'Request form'!D45,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P23,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH24<>\"\",'Request form'!$D$4,\"\")","v":""},{"$f":"IF(CH24<>\"\",'Request form'!$D$9,\"\")","v":""},{"$f":"IF(CH24<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$7:$F$7)=0,'Request form'!$D$7&\"/\"&'Request form'!$E$7&\"/\"&'Request form'!$F$7,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH24<>\"\",IFERROR(IF(COUNTBLANK('Request form'!$D$8:$F$8)=0,'Request form'!$D$8&\"/\"&'Request form'!$E$8&\"/\"&'Request form'!$F$8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(CH24<>\"\",'Request form'!$D$5,\"\")","v":""},{"$f":"IF(CH24<>\"\",'Request form'!$D$11,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH24<>\"\",IF('Request form'!Y25=\"\",\"yes\",\"no\"),\"\")","v":""},{"$f":"IF(CH24<>\"\",IF(AM24=\"No\",'Request form'!Y25,\"\"),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CH24<>\"\",'Request form'!$D$14,\"\")","v":""},"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Request form'!Y18<>\"\",'Request form'!Y18,\"\")","v":""},{"$f":"IF(CH24<>\"\",'Request form'!Y19,\"\")","v":""},{"$f":"IF(CH24<>\"\",'Request form'!Y20,\"\")","v":""},{"$f":"IF(AND(CH24<>\"\",'Request form'!D41<>\"\"),'Request form'!D41,\"\")","v":""},{"$f":"IF(AND(CH24<>\"\",'Request form'!D42<>\"\"),'Request form'!D42,\"\")","v":""},{"$f":"IF(CI24<>\"\",'Request form'!E42,\"\")","v":""},{"$f":"IF(AND(CH24<>\"\",'Request form'!D46<>\"\"),'Request form'!D46,\"\")","v":""},{"$f":"IFERROR(VLOOKUP($P24,VBAHelper!$D:$F,3,FALSE),\"\")","v":""}]

{"sheet":"Request form","index":2,"n_rows":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,3,26,5],[3,0,4,0],[3,3,3,5],[4,3,4,5],[12,3,12,5],[23,3,23,5],[17,3,17,5],[15,3,15,5],[19,3,19,5],[5,0,8,0],[9,0,11,0],[11,3,11,5],[13,3,13,5],[14,3,14,5],[23,0,25,0],[16,0,16,2],[12,0,14,0],[1,2,1,5],[15,0,15,2],[18,3,18,5],[20,3,20,5],[17,0,22,0],[6,7,7,7],[8,3,8,5],[9,3,9,5],[10,3,10,5],[25,3,25,5],[24,3,24,5],[16,3,16,5],[21,3,21,5],[22,3,22,5]]}
[null,null,"NOP Import Certificate request form"]
[null,null,"To be filled by the exporter \nFollow the instructions mentioned in the \"Read me\" tab"]
["Entity information"]
[null,1,"certification standard"]
[null,2,"Products Exported from (country)"]
["VALIDITY PERIOD",null,null,"Month","day","year"]
[null,3,"Export date ",null,null,null,{"$f":"IFERROR(IF(COUNTBLANK(D7:F7)=0,DATE(F7,D7,E7),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(_xlfn.DAYS(G8,G7)>365,\"Validity period can't exceed one year. Please modify 'End date'.\",\"\"),\"\")","v":""}]
[null,4,"End date ",null,null,null,{"$f":"IFERROR(IF(COUNTBLANK(D8:F8)=0,DATE(F8,D8,E8),\"\"),\"\")","v":""}]
[null,5,"Single shipment? "]
["EXPORTER",6,"Exporter name"]
[null,7,"NOP ID exporter (OID) - https://organic.ams.usda.gov/integrity/Home/1",null,null,null,null,{"$f":"IF(D8-D7>365,\"validity period must not exceed one year\",\"\")","v":""}]
[null,8,"exporter address"]
["RECIPIENT = IMPORTER",9,"Importer name  "]
[null,10,"NOP ID importer (OID) - https://organic.ams.usda.gov/integrity/Home/1"]
[null,11,"Importer address"]
["Product(s) information "]
["List all concerned products to be exported to this same importer\n1 same HTS Code = 1 product column to fill in = 1 NOPIC generated",null,null,"Product 1",null,null,"Product 2","Product 3","Product 4","Product 5","Product 6","Product 7","Product 8","Product 9","Product 10","Product 11","Product 12","Product 13","Product 14","Product 15","Product 16","Product 17","Product 18","Product 19","Product 20"]
["PRODUCT",12,"Product name "]
[null,13,"HTS code (10 digits please)   https://hts.usitc.gov/"]
[null,14,"Estimated Total net weight (kg)"]
[null,15,"in bulk or packaged?"]
[null,16,"total number of containers"]
[null,17,"Shipping identification: lot number(s)"]
["FINAL HANDLER",18,"final handler name (when different from exporter)"]
[null,19,"NOP ID final handler OID - https://organic.ams.usda.gov/integrity/Home/1 "]
[null,20,"Final handler address"]
[null,21,"Additional declaration / Remarks"]

{"sheet":"VBAHelper","index":3,"n_rows":250,"n_cols":10,"rows_kept":250,"cut":false,"hidden":true,"merged":[]}
["Countries","US States",null,"Program Name on Certifier and Operation Profile --> Organic Standard",null,"Attestation Statement for Import Certificate",null,"Bulk or packaged",null,"Single shipment"]
["UNITED STATES OF AMERICA (THE)","Alabama",null,"USDA-NOP (U.S.A.)",null,"N/A"]
["ÅLAND ISLANDS","Alaska",null,"Canada Organic Regime (COR)",null,"Certified in compliance with the terms of the U.S.-Canada Organic Equivalency Arrangement",null,"Bulk",null,"Yes"]
["AFGHANISTAN","American Samoa",null,"European Organic Regulations",null,"Certified in compliance with the terms of the U.S.-European Union Organic Equivalence Arrangement",null,"Packaged",null,"No"]
["ALBANIA","Arizona",null,"Japanese Agricultural Standards (JAS)",null,"Certified in compliance with the terms of the U.S.-Japan Organic Equivalence Arrangement"]
["ALGERIA","Arkansas",null,"Korean Food Act",null,"Certified in compliance with the terms of the U.S.-Korea Organic Equivalency Arrangement"]
["AMERICAN SAMOA","California",null,"Swiss Organic Ordinance",null,"Certified in compliance with the terms of the U.S.-Switzerland Organic Equivalence Arrangement"]
["ANDORRA","Colorado",null,"Taiwan Organic Regulations",null,"Certified in compliance with the terms of the AIT/TECRO-NOP/AFA Organic Equivalence Arrangement"]
["ANGOLA","Connecticut",null,"UK Organic Standards",null,"Certified in compliance with the terms of the U.S.-U.K. Organic Equivalence Arrangement"]
["ANGUILLA","Delaware",null,"USDA-NOP (Israel Recognition)",null,"N/A"]
["ANTARCTICA","District of Columbia",null,"USDA-NOP (New Zealand Recognition)",null,"N/A"]
["ANTIGUA AND BARBUDA","Federated States of Micronesia"]
["ARGENTINA","Florida"]
["ARMENIA","Georgia"]
["ARUBA","Guam"]
["AUSTRALIA","Hawaii"]
["AUSTRIA","Idaho"]
["AZERBAIJAN","Illinois"]
["BAHAMAS (THE)","Indiana"]
["BAHRAIN","Iowa"]
["BANGLADESH","Kansas"]
["BARBADOS","Kentucky"]
["BELARUS","Louisiana"]
["BELGIUM","Maine"]
["BELIZE","Maryland"]
["BENIN","Massachusetts"]
["BERMUDA","Michigan"]
["BHUTAN","Midway Islands"]
["BOLIVIA (PLURINATIONAL STATE OF)","Minnesota"]
["BONAIRE, SINT EUSTATIUS AND SABA","Mississippi"]
["BOSNIA AND HERZEGOVINA","Missouri"]
["BOTSWANA","Montana"]
["BOUVET ISLAND","Nebraska"]
["BRAZIL","Nevada"]
["BRITISH INDIAN OCEAN TERRITORY (THE)","New Hampshire"]
["BRUNEI DARUSSALAM","New Jersey"]
["BULGARIA","New Mexico"]
["BURKINA FASO","New York"]
["BURUNDI","North Carolina"]
["CABO VERDE","North Dakota"]
["CAMBODIA","Northern Mariana Islands"]
["CAMEROON","Ohio"]
["CANADA","Oklahoma"]
["CAYMAN ISLANDS (THE)","Oregon"]
["CENTRAL AFRICAN REPUBLIC (THE)","Pennsylvania"]
["CHAD","Puerto Rico"]
["CHILE","Rhode Island"]
["CHINA","South Carolina"]
["CHRISTMAS ISLAND","South Dakota"]
["COCOS (KEELING) ISLANDS (THE)","Tennessee"]
["COLOMBIA","Texas"]
["COMOROS (THE)","Utah"]
["CONGO (THE DEMOCRATIC REPUBLIC OF THE)","Vermont"]
["CONGO (THE)","Virgin Islands"]
["COOK ISLANDS (THE)","Virginia"]
["COSTA RICA","Washington"]
["CÔTE D'IVOIRE","West Virginia"]
["CROATIA","Wisconsin"]
["CUBA","Wyoming"]
["CURAÇAO"]
["CYPRUS"]
["CZECH REPUBLIC (THE)"]
["DENMARK"]
["DJIBOUTI"]
["DOMINICA"]
["DOMINICAN REPUBLIC (THE)"]
["ECUADOR"]
["EGYPT"]
["EL SALVADOR"]
["EQUATORIAL GUINEA"]
["ERITREA"]
["ESTONIA"]
["ETHIOPIA"]
["FALKLAND ISLANDS (THE) [MALVINAS]"]
["FAROE ISLANDS (THE)"]
["FIJI"]
["FINLAND"]
["FRANCE"]
["FRENCH GUIANA"]
["FRENCH POLYNESIA"]
["FRENCH SOUTHERN TERRITORIES (THE)"]
["GABON"]
["GAMBIA (THE)"]
["GEORGIA"]
["GERMANY"]
["GHANA"]
["GIBRALTAR"]
["GREECE"]
["GREENLAND"]
["GRENADA"]
["GUADELOUPE"]
["GUAM"]
["GUATEMALA"]
["GUERNSEY"]
["GUINEA"]
["GUINEA-BISSAU"]
["GUYANA"]
["HAITI"]
["HEARD ISLAND AND MCDONALD ISLANDS"]
["HOLY SEE (THE)"]
["HONDURAS"]
["HONG KONG"]
["HUNGARY"]
["ICELAND"]
["INDIA"]
["INDONESIA"]
["IRAN (ISLAMIC REPUBLIC OF)"]
["IRAQ"]
["IRELAND"]
["ISLE OF MAN"]
["ISRAEL"]
["ITALY"]
["JAMAICA"]
["JAPAN"]
["JERSEY"]
["JORDAN"]
["KAZAKHSTAN"]
["KENYA"]
["KIRIBATI"]
["KOREA (THE DEMOCRATIC PEOPLE'S REPUBLIC OF)"]
["KOREA (THE REPUBLIC OF)"]
["KUWAIT"]
["KYRGYZSTAN"]
["LAO PEOPLE'S DEMOCRATIC REPUBLIC (THE)"]
["LATVIA"]
["LEBANON"]
["LESOTHO"]
["LIBERIA"]
["LIBYA"]
["LIECHTENSTEIN"]
["LITHUANIA"]
["LUXEMBOURG"]
["MACAO"]
["MADAGASCAR"]
["MALAWI"]
["MALAYSIA"]
["MALDIVES"]
["MALI"]
["MALTA"]
["MARSHALL ISLANDS (THE)"]
["MARTINIQUE"]
["MAURITANIA"]
["MAURITIUS"]
["MAYOTTE"]
["MEXICO"]
["MICRONESIA (FEDERATED STATES OF)"]
["MOLDOVA (THE REPUBLIC OF)"]
["MONACO"]
["MONGOLIA"]
["MONTENEGRO"]
["MONTSERRAT"]
["MOROCCO"]
["MOZAMBIQUE"]
["MYANMAR"]
["NAMIBIA"]
["NAURU"]
["NEPAL"]
["NETHERLANDS (THE)"]
["NEW CALEDONIA"]
["NEW ZEALAND"]
["NICARAGUA"]
["NIGER (THE)"]
["NIGERIA"]
["NIUE"]
["NORFOLK ISLAND"]
["NORTH MACEDONIA"]
["NORTHERN MARIANA ISLANDS (THE)"]
["NORWAY"]
["OMAN"]
["PAKISTAN"]
["PALAU"]
["PALESTINE, STATE OF"]
["PANAMA"]
["PAPUA NEW GUINEA"]
["PARAGUAY"]
["PERU"]
["PHILIPPINES (THE)"]
["PITCAIRN"]
["POLAND"]
["PORTUGAL"]
["PUERTO RICO"]
["QATAR"]
["RÉUNION"]
["ROMANIA"]
["RUSSIAN FEDERATION (THE)"]
["RWANDA"]
["SAINT BARTHÉLEMY"]
["SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA"]
["SAINT KITTS AND NEVIS"]
["SAINT LUCIA"]
["SAINT MARTIN (FRENCH PART)"]
["SAINT PIERRE AND MIQUELON"]
["SAINT VINCENT AND THE GRENADINES"]
["SAMOA"]
["SAN MARINO"]
["SAO TOME AND PRINCIPE"]
["SAUDI ARABIA"]
["SENEGAL"]
["SERBIA"]
["SEYCHELLES"]
["SIERRA LEONE"]
["SINGAPORE"]
["SINT MAARTEN (DUTCH PART)"]
["SLOVAKIA"]
["SLOVENIA"]
["SOLOMON ISLANDS"]
["SOMALIA"]
["SOUTH AFRICA"]
["SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS"]
["SOUTH SUDAN"]
["SPAIN"]
["SRI LANKA"]
["SUDAN (THE)"]
["SURINAME"]
["SVALBARD AND JAN MAYEN"]
["SWAZILAND"]
["SWEDEN"]
["SWITZERLAND"]
["SYRIAN ARAB REPUBLIC"]
["TAIWAN "]
["TAJIKISTAN"]
["TANZANIA, UNITED REPUBLIC OF"]
["THAILAND"]
["TIMOR-LESTE"]
["TOGO"]
["TOKELAU"]
["TONGA"]
["TRINIDAD AND TOBAGO"]
["TUNISIA"]
["TURKEY"]
["TURKMENISTAN"]
["TURKS AND CAICOS ISLANDS (THE)"]
["TUVALU"]
["UGANDA"]
["UKRAINE"]
["UNITED ARAB EMIRATES (THE)"]
["UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN IRELAND (THE)"]
["UNITED STATES MINOR OUTLYING ISLANDS (THE)"]
["URUGUAY"]
["UZBEKISTAN"]
["VANUATU"]
["VENEZUELA (BOLIVARIAN REPUBLIC OF)"]
["VIET NAM"]
["VIRGIN ISLANDS (BRITISH)"]
["VIRGIN ISLANDS (U.S.)"]
["WALLIS AND FUTUNA"]
["WESTERN SAHARA*"]
["YEMEN"]
["ZAMBIA"]
["ZIMBABWE"]