5900-147 Second-Party Transformation Annual Report Electronic

Recordkeeping and Periodic Reporting of the Production, Import, Export, Recycling, Destruction, Transhipment, and Feedstock Use of Ozone-Depleting Substances (Renewal)

Second Party Transformation_v1.0.xlsm

Recordkeeping and Reporting of the Production, Import, Export, Destruction, Transhipment, and Exempted Uses of Ozone-Depleting Substances (Renewal)

OMB: 2060-0170

Document [xlsx]
Download: xlsx | pdf

Overview

Instructions
Section 1
Section 2
Reference List


Sheet 1: Instructions





U.S. Environmental Protection Agency

Stratospheric Ozone Protection Program




Second Party Transformation Annual Report (Sec 82.13 and 82.24)

Version 1.0

Last Updated: April 2018




Instructions

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 in Section 2 to generate your CSV file.

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

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.

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:

https://www.epa.gov/ods-phaseout/ods-recordkeeping-and-reporting




All information submitted to EPA will be treated as confidential in accordance with 40 CFR Part 2, Subpart B, and will only be disclosed by the means set forth in the subpart.

The public reporting and recordkeeping burden for this collection of information is estimated to average 2 hours per response. Send comments on the Agency's need for this information, 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, Collection Strategies Division, U.S. Environmental Protection Agency (2822T), 1200 Pennsylvania Avenue NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address.




EPA Form #5900-147

OMB Control Number: 2060-0170

Expiration Date: 10/31/2018





Sheet 2: Section 1










U.S. Environmental Protection Agency






Second Party Transformation Annual Report












Date Prepared: 1/20/2021













Section 1: Report Identification Information






Complete all fields below. No fields may be left blank.





The company name must match the organization name under which this report is submitted to EPA through CDX. Company Name:

1



Submission Type:

1



Reporting Year:

1












Original Submission






Re-Submittal






Sheet 3: Section 2










U.S. Environmental Protection Agency





Second Party Transformation Annual Report










Company Name:




Reporting Period:












Section 2: Transformation Data





In the table below, enter the quantity of each controlled substance that was transformed during the reporting period.




If copying and pasting data into the table, please refer to the Reference List and the accompanying instructions.




Select the chemical name from the dropdown list if the controlled substance was transformed during the reporting period. Each chemical should only appear once in the table. If copying and pasting data into the table, please refer to the Reference List for the valid list of chemical names. Chemical Name Enter the quantity (kg) of the chemical transformed during the reporting period. Quantity Transformed




Selection kg




HCFC-22 1,500.00
















































































































































x





CFC-11





CFC-12





CFC-13





CFC-111





CFC-112





CFC-113





CFC-114





CFC-115





CFC-211





CFC-212





CFC-213





CFC-214





CFC-215





CFC-216





CFC-217





Halon 1202





Halon 1211





Halon 1301





Halon 2402





CBM





CCL4





CH3CCL3





HBFCs





CH3Br





HCFC-21





HCFC-22





HCFC-31





HCFC-121





HCFC-122





HCFC-123





HCFC-123a





HCFC-123b





HCFC-124





HCFC-124a





HCFC-131





HCFC-132b





HCFC-133a





HCFC-141b





HCFC-142b





HCFC-151





HCFC-221





HCFC-222





HCFC-223





HCFC-224





HCFC-225ca





HCFC-225cb





HCFC-226





HCFC-231





HCFC-232





HCFC-233





HCFC-234





HCFC-235





HCFC-241





HCFC-242





HCFC-243





HCFC-244





HCFC-251





HCFC-252





HCFC-253





HCFC-261





HCFC-262





HCFC-271





Sheet 4: Reference List









U.S. Environmental Protection Agency



Second Party Transformation Annual Report


Reference List









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 accepted into EPA’s ODS tracking system. When copying and pasting data into the form, please ensure consistency with the formatting of the list below.

Chemical Name List: The table below lists the valid chemical names that may be used when entering data into Section 2 of this form.








Chemical Name

CFC-11 CFC-217 HCFC-122 HCFC-142b HCFC-241

CFC-12 Halon 1202 HCFC-123 HCFC-151 HCFC-242

CFC-13 Halon 1211 HCFC-123a HCFC-221 HCFC-243

CFC-111 Halon 1301 HCFC-123b HCFC-222 HCFC-244

CFC-112 Halon 2402 HCFC-124 HCFC-223 HCFC-251

CFC-113 CBM HCFC-124a HCFC-224 HCFC-252

CFC-114 CCL4 HCFC-131 HCFC-225ca HCFC-253

CFC-115 CH3CCL3 HCFC-132b HCFC-225cb HCFC-261

CFC-211 HBFCs HCFC-133a HCFC-226 HCFC-262

CFC-212 CH3Br HCFC-141 HCFC-231 HCFC-271

CFC-213 HCFC-21 HCFC-141a HCFC-232


CFC-214 HCFC-22 HCFC-141b HCFC-233


CFC-215 HCFC-31 HCFC-142 HCFC-234


CFC-216 HCFC-121 HCFC-142a HCFC-235








File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy