{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Section 1","Section 2","Section 3","Section 4"],"not_rendered":{"macros":1,"defined_names":43},"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 Domestic Transfers Report (Sec 84.19 and 84.21)"]
[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-506"]

{"sheet":"Section 1","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[2,2,2,3],[7,2,7,3]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"HFC Domestic Transfers Report "]
[]
[null,null,"   Date Prepared:"]
[]
[null,null,"Section 1: Transferor 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":""}]
[{"$nulls":3},""]

{"sheet":"Section 2","index":2,"n_rows":13,"n_cols":10,"rows_kept":13}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,{"$f":"IFERROR(VLOOKUP(#REF!,'Section 2'!#REF!,COLUMNS('Section 2'!#REF!),0),\"\")","v":""},"HFC Domestic Transfers Report "]
[]
[null,null,"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[null,null,"Reporting Period:",{"$f":"IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":""}]
[]
[null,null,"Section 2: Transferee Information"]
[null,null,"In the table below, enter the contact information for the recipient of the transfer or sale (§84.19(a)(2)(i) and §84.19(a)(2)(ii)).  "]
[null,null,"Transferee Company Name","Transferee Contact Name ","Transferee Contact Phone Number","Transferee Contact Email","Transferee Street Address","Transferee City","Transferee State","Transferee Zip Code"]
[null,null,"Text","Text","Text","Text","Text","Text","Selection","Text"]
[]
[{"$nulls":3},"x","x","x","x"]

{"sheet":"Section 3","index":3,"n_rows":225,"n_cols":10,"rows_kept":225,"merged":[[8,2,8,9],[9,2,10,2],[9,3,9,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,9,9]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,{"$f":"IFERROR(VLOOKUP(#REF!,'Section 3'!D$13:$J$22,COLUMNS('Section 3'!$C$10:C$11),0),\"\")","v":""},"HFC Domestic Transfers Report "]
[]
[null,null,"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[null,null,"Reporting Period:",{"$f":"IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":""}]
[]
[null,null,"Section 3: Transaction Data"]
[null,null,"In the table below, enter data for each transfer request. For all regulated substances that are transferred, all fields are required unless otherwise indicated. For transfers of application-specific allowances, additionally provide a signed document from the transferee certifying that the transferee will use the application-specific allowances only for the same application for which the application-specific allowance was allocated (§84.19(a)(2)(viii))."]
[null,null,"Transaction Number","Allowance Type",null,"Quantity of Allowances Being Transferred (§84.19(a)(2)(iv))","Total Cost of Allowance Transfer (§84.19(a)(2)(v))","Quantity of Unexpended Allowances Held by Transferor (§84.19(a)(2)(vi))","Calculated Values"]
[{"$nulls":3},"Production,  Consumption, or Application-Specific (§84.19(a)(2)(iii))","Application, if applicable (§84.19(a)(2)(iii))",{"$nulls":3},"Amount of Offset (§84.19(a)(2)(vii))","Number of Allowances Subtracted from Transferor's Allowance Balance"]
[null,null,"Autopopulated","Selection","Selection","MTEVs","(US$)","MTEVs","MTEVs","MTEVs"]
[{"$nulls":8},{"$f":"IF(F13=\"\",\"\",0.001*F13)","v":""},{"$f":"IFERROR(ROUND(I13+F13,0), \"\")","v":""}]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$nulls":8},"",""]
[{"$f":"IF(COUNTA(J22:J22)>0,0,1)","v":0},{"$nulls":7},"",""]
[{"$nulls":3},"x","x","x","x",null,null,"x"]
{"$rows_empty":81}
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Section 4","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[8,2,8,3],[9,2,9,3]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,{"$f":"IFERROR(VLOOKUP(#REF!,'Section 4'!#REF!,COLUMNS('Section 4'!$C$10:C$10),0),\"\")","v":""},"HFC Domestic Transfers Report "]
[]
[null,null,"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[null,null,"Reporting Period:",{"$f":"IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":""}]
[]
[null,null,"Section 4: Application-Specific Allowance Transfers or Sales"]
[null,null,"If transfering application-specific allowances, describe below or in supporting documentation the specific products that the transferee plans to produce with the HFCs (§84.21(b)(2)(v))."]
[]
[{"$nulls":3},"x"]