{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Section 1","Section 2","Section 3"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":20,"n_cols":3,"rows_kept":20}
[]
[null,null,"OMB Control Number: 2060-XXXX"]
[null,null,"Expiration Date: X/XX/202X"]
[null,null,"U.S. Environmental Protection Agency "]
[null,null,"Allowance Allocation and Trading Program under the AIM Act"]
[]
[null,null,"HFC International Transfers Report (Sec 84.19)"]
[null,null,"Version 1.0"]
[null,null,"Last Updated: "]
[]
[null,null,"Instructions"]
[null,null,"Complete this form by filling in the data fields that are highlighted in blue. Guidance on how to complete individual data fields are provided in comment bubbles. Use the arrows to navigate between the tabs. Once completed, use the 'prepare submission' button on the Summary tab to generate your CSV file.  "]
[null,null,"Copying and Pasting Data: If data are pasted into this reporting form from another spreadsheet, the formatting of specific cells must be consistent with the requirements of the form in order to be "]
[null,null,"accepted into EPA’s ODS Tracking System. Refer to the Reference List to identify the valid naming scheme for specific data fields. Additionally, select \"Paste As Values\" when pasting data into the form."]
[null,null,"Report Submission: This Excel file, the generated CSV file, and all supporting attachments should be submitted to EPA through the Central Data Exchange (CDX). Refer to EPA's website for additional information on form submission:"]
[null,null,"https://www.epa.gov/climate-hfcs-reduction/collection-data-support-establishment-hfc-allowance-allocation-and-trading "]
[]
[null,null,"This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-XXXX). Responses to this collection of information are mandatory (40 CFR 84.31). An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to be X hours per response. Send comments on the Agency’s need this formation, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden including through the use of automated collection techniques to the Director, Regulatory Support Division, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address."]
[]
[null,null,"EPA Form # 5900-509"]

{"sheet":"Section 1","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[2,2,2,3],[7,2,7,3],[11,2,11,3]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"HFC International Transfers Report "]
[]
[null,null,"   Date Prepared:"]
[]
[null,null,"Section 1: Identification Information "]
[null,null,"Complete all fields below.  No fields may be left blank."]
[null,null,"Company Name: "]
[null,null,"Submission Type:"]
[null,null,"Reporting Year:",{"$nulls":5},{"$f":"IF(D11>YEAR(TODAY()),\"PLEASE CHOOSE A CURRENT OR PAST YEAR\",\"\")","v":""}]
[null,null,"Transfer Type:"]
[]
[{"$nulls":3},""]

{"sheet":"Section 2","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[8,3,8,7],[9,3,9,7],[10,3,10,7]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[null,null,{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!#REF!,COLUMNS('Section 2'!#REF!),0),\"\")","v":""},"HFC International Transfers Report "]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":""}]
[]
[{"$nulls":3},"Section 2: Contact Information"]
[{"$nulls":3},"In the table below, identify the foreign country authorizing the transfer and enter the contact information for the person in the foreign country that is authorizing the transfer.  "]
[{"$nulls":3},"For a transfer from a person in a foreign country, additionally provide a signed document from an official representative in that country’s embassy in the United States stating that the appropriate authority within that country has revised the domestic production limits for that country equal to the lowest of the following three production quantities: (A) The maximum production level permitted in § 84.7(b) in the year of the international transfer minus the quantity of production allowances (in exchange value-weighted kilograms) to be transferred; (B) The maximum production level for the applicable regulated substances that are allowed under applicable law (including the foreign country's applicable domestic law) minus the quantity of production allowances (in exchange value-weighted kilograms) to be transferred; or (C) The average of the foreign country's actual national production level of the applicable regulated substances for the three calendar years prior to the year of the transfer minus the quantity of production allowances (in exchange value-weighted kilograms) to be transferred."]
[{"$nulls":3},"For a transfer to a person in a foreign country, additionally provide a signed statement from a responsible official requesting that the relevant Agency official revise the number of production allowances the transferor holds such that the aggregate national production in the United States is equal the lowest of the following three production quantities: (A) The maximum production level permitted in § 84.7(b) in the year of the international transfer minus the quantity of production allowances (in exchange value-weighted kilograms) to be transferred; (B) The maximum production for the applicable regulated substances that are allowed under applicable law minus the quantity of production allowances (in exchange value-weighted kilograms) to be transferred; or (C) The average of the United States’ actual national production level of the applicable regulated substances for the three calendar years prior to the year of the transfer minus the quantity of production allowances (in exchange value-weighted kilograms) to be transferred. "]
[{"$nulls":3},"Foreign Country Authorizing Transfer\n(§84.19(b)(2)(ii)(B) or (§84.19(b)(3)(ii))","Contact Name \n(§84.19(b)(2)(ii)(C) or (§84.19(b)(3)(iii))","Contact Phone Number \n(§84.19(b)(2)(ii)(C) or (§84.19(b)(3)(iii))","Contact Email\n(§84.19(b)(2)(ii)(C) or (§84.19(b)(3)(iii))","x"]
[{"$nulls":3},"Selection","Text","Text","Text","x"]
[{"$f":"IF(#REF!=\"\",\"\",1)","v":{"$error":"#REF!"}},{"$nulls":6},"x"]
[{"$nulls":4},"x",null,"x","x"]

{"sheet":"Section 3","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[8,3,8,5],[9,3,9,5]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[null,null,{"$f":"IFERROR(VLOOKUP($A3,'Section 3'!F$13:$F$22,COLUMNS('Section 3'!$D$11:D$11),0),\"\")","v":""},"HFC International Transfers Report "]
[]
[{"$nulls":3},"Company Name:"]
[{"$nulls":3},"Reporting Period:"]
[]
[{"$nulls":3},"Section 3: Transaction Data"]
[{"$nulls":3},"In the table below, enter data for each transfer request. "]
[{"$nulls":3},"For transfers from a person in a foreign country, additionally provide documentation that the foreign country possesses the necessary quantity of unexpended production rights (§84.19(b)(2)(ii)(E)) and a signed statement from a responsible official describing whether the increased production is intended for export or the market in the United States (§84.19(b)(2)(ii)(G)). "]
[{"$nulls":3},"Transaction Number","Chemical Name","Quantity of Production Allowances Being Transferred ((§84.19(b)(2)(ii)(D) or §84.19(b)(3)(iv))"]
[{"$nulls":3},"Autopopulated","Selection","kg"]
[{"$f":"IF(#REF!=0, \"\", 1)","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A13)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A14)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A15)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A16)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A17)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A18)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A19)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A20)+1))","v":{"$error":"#REF!"}}]
[{"$f":"IF(#REF!=0, \"\", IF( COUNTIF(#REF!,#REF!)>0, \"\", MAX($A$13:A21)+1))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTA(#REF!)>0,0,1)","v":0}]
[{"$nulls":5},"x"]