5900-582 Part 60 Subpart MMA Compliance Report Template

NSPS for Auto and Lt Duty Truck (40 CFR 60 subpart MMa) (proposed rule)

Part 60 Subpart MMa Compliance Report Template.xlsx

OMB: 2060-0747

Document [xlsx]
Download: xlsx | pdf

Overview

Welcome
Company_Information
Certifications
Process_Unit_Source_Desc
Initial_Compliance
CMS_Identification
Monthly_VOC_Deviation
Capture_Control Deviation
Description_of_Changes
CMS__Detail
CMS_Downtime_Summary
Limit_Deviation_Detail
Emission_Limit_Detail
Limit_Deviation_Summary
Revisions


Sheet 1: Welcome

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022
§60.395a(j) Compliance Report Spreadsheet Template
60.395a(j)
v1.0
8/12/2022
OMB No.: 2060-NEW Form 5900-582 For further Paperwork Reduction Act information see:
https://www.epa.gov/electronic-reporting-air-emissions/paperwork-reduction-act-pra-cedri-and-ert
40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022
Instructions for Spreadsheet Template

Purpose:
This spreadsheet template was designed by the U.S. EPA to facilitate Compliance reporting for facilities subject under the 40 CFR part 60 subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022.
Electronic reporting:
Electronic submission of Compliance Reports through the EPA's Compliance and Emissions Data Reporting Interface (CEDRI) is required under §60.395a(j). CEDRI is accessed through the EPA's Central Data Exchange (https://cdx.epa.gov).
The CEDRI spreadsheet template upload feature allows you to submit data in a single report for a single company or multiple companies, as well as multiple sites, using this EPA provided Excel workbook. Data for each company must be entered into the worksheet labeled "Company Information" in this Excel workbook. Each row in the "Company Information" worksheet includes the data for a single company. The Company Record No. will be used to match the information on each worksheet to the appropriate company.

For each facility record found in the "Company Information" worksheet, you may reference a single file attachment that includes additional information.
IMPORTANT: The spreadsheet must be uploaded into CEDRI as a single ZIP file, which must include this Excel workbook and any related attachments that were referenced in the workbook (i.e., additional information file found in the "Company Information" worksheet).
Note: If you are uploading file attachments for your report, the uploaded files may be in any format (e.g., zip, docx, PDF). If you would like to include an Excel file(s) as an attachment, you must first zip the Excel file(s) into a separate ZIP file to the master ZIP file that will be uploaded into CEDRI.
Once all data have been entered in the worksheet, combine this Excel workbook and all attachment files (including any ZIP file containing separate Excel file(s), if applicable) into a single ZIP file for upload to CEDRI.

Please ensure your report includes all of the required data elements found in the listed citations below for this spreadsheet upload submission.
Do not submit information you claim as confidential business information (CBI) to EPA via CEDRI. EPA will make all the information submitted through this form via CEDRI available to the public without further notice to you. Anything submitted using CEDRI cannot later be claimed to be CBI. Furthermore, under CAA section 114(c) emissions data is not entitled to confidential treatment and requires EPA to make emissions data available to the public. Thus, emissions data will not be protected as CBI and will be made publicly available.
Although we do not expect persons to assert a claim of CBI, if persons wish to assert a CBI claim for some of the information in this report, you must submit a version of the report with the CBI omitted via CEDRI and submit a complete report, including any information claimed to be CBI, to EPA. The preferred method to receive CBI is for it to be transmitted electronically using email attachments, File Transfer Protocol, or other online file sharing services. Electronic submissions must be transmitted directly to the OAQPS CBI Office at the email address [email protected] to the attention of the Surface Coating of Auto and Light Duty Trucks Sector Lead. If assistance is needed with submitting large electronic files that exceed the file size limit for email attachments, and if you do not have your own file sharing service, please email [email protected] to request a file transfer link. If you cannot transmit the file electronically, you may send CBI information through the postal service to the following address:

OAQPS Document Control Officer (C404-02)
OAQPS, U.S. Environmental Protection Agency
Attn: Surface Coating of Auto and Light Duty Trucks Sector Lead
Research Triangle Park, North Carolina 27711
Template Navigation and Tabs to Complete:
Gray Tabs (Complete first): The gray tabs (Company_Information, Process_Unit_Source_Desc, Initial_Compliance, and CMS_Identification) contain general information that is likely to be mostly unchanged from report to report. The Initial_Compliance tab must only be completed for the initial compliance report. These tabs do contain dates and the operating time of the sources over the reporting period, which must be updated with each report. After completing the gray tabs, the workbook may be saved as a site specific template for use in subsequent reports to limit subsequent data entry. The Revisions tab contains information on the current and any preceding revisions to the template. The Revions tab is a locked informational tab and provides details on current and past tempalte revisions.
Blue Tab: The blue tab (Certifications) contains the certification statements for §60.7(c)(4) and must be completed for each report. The statement of truth, accuracy, and completeness required by §§60.7(d) and 60.395a(f)(2) is completed in the certifcation step within CEDRI.

Green Tabs: Green tabs (Monthly_VOC_Deviation, Capture_Control_Deviation, Description_of_Changes, CMS_Detail, CMS_Downtime_Summary, Limit_Deviation_Detail, Emission_Limit_Detail, and Limit_Deviation_Summary) are completed as necessary for the facility. The tabs are only completed if the applicable excess emissions and CMS downtime criteria are met.

Within the tabs, example rows are colored light red (rows 14 through 23), and the XML tags (row 13) are colored green. These rows are locked; no data entry is made in these rows.
The Date of Report (§60.395a(f)(3) and the statement by a responsible official (§60.395a(f)(2) are accomplished through the certification proces on submittla to CEDRI.

Sheet 2: Company_Information

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022











§60.395a(j) Compliance Report Spreadsheet Template












SITE INFORMATION
REPORTING PERIOD ADDITIONAL INFORMATION
Company Record No.
(Field value will automatically generate if a value is not entered.)
Company Name
(§§60.7(d), 60.395a(f)(1))
Address
(§§60.7(d), 60.395a(f)(1))
Address 2 City
((§§60.7(d), 60.395a(f)(1))
County State Abbreviation
(§§60.7(d), 60.395a(f)(1))
(Select from dropdown)
Zip Code
(§§60.7(d), 60.395a(f)(1))
Responsible Agency Facility ID
(State Facility Identifier)
Beginning Date of Reporting Period
(§§60.7(d), 60.395a(f)(3))
Ending Date of
Reporting Period
(§§60.7(d), 60.395a(f)(3))
Please enter any additional information. Enter associated file name reference.
RecordId CompanyName AddressLine1 AddressLine2 CityName CountyName StateName ZipCode StateFacId PeriodStartDate PeriodEndDate AddInfo AddFile
e.g.: 1 e.g.: ABC Company e.g.: 123 Main Street e.g.: Suite 100 e.g.: Brooklyn e.g.: Kings e.g.: NY e.g.: 11221 e.g.: 9145555555 e.g.: 01/01/2017 e.g.: 6/30/2017 e.g.: e.g.: addlinfo.zip



































































































































Sheet 3: Certifications

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022



§60.395a(j) Compliance Report Spreadsheet Template



Company Record No.
(Autocompleted)
Is the statement "There were no excess emissions during this reporting period" applicable?
(§60.7(c)(4))
(Select from dropdown)
Is the statement "The continuous monitoring systems were not inoperative, repaired, or adjusted during the reporting period" applicable?
(§60.7(c)(4))
(Select from Dropdown)
Is the statement "There were no deviations from emission limits, work practices, or operating limits during the reporting period" applicable? (§60.395a(g))
(Select from Dropdown)
Is the statement "There were no periods during which the CMS were out of control" applicable? (§60.395a(g))
(Select from Dropdown)
RecordId ExcessFlag CPMSPeriodFlag DevFlag CMSOOCFlag
Complete the Company_Information tab

















































Sheet 4: Process_Unit_Source_Desc

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification



or Reconstruction Commenced After May 18, 2022



§60.395a(j) Compliance Report Spreadsheet Template



Company Record No.
(Select from dropdown)
Process Unit Cross Reference ID Process Unit / Affected Source / Source Description
(§§60.7(d), 60.395a(f)(4) and (h)(13)(ii))
Identification of the Compliance Option or Options Specified in Used on Each Operation
During the Reporting Period (Optional)
(Select from dropdown)
Total Operating Time
(Hours)
(§60.7(d))
RecordId ProcessUnit_PU PUDescription_PU ComplianceOptions_PU TotalOperatingTime_PU
e.g.: 1 e.g.: Truck1 e.g.: Truck Coating Line 1 e.g.: §60.394a(a) and (f) Thermal Oxidizer with a PTE e.g.: 5421.25


































































































































































































































































































































































































Sheet 5: Initial_Compliance

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022











§60.395a(e) Initial Compliance Report Spreadsheet Template











Company Record No.
(Autocompleted from Column D)
Process Unit / Source Description
(§§60.7(d), 60.395a(f)(4))
(Autocompleted from Column D)
Company Record Number and Process Unit / Source Description
(Select from dropdown)
Is this the initial compliance report?
(§60.395a(e))
(Select from dropdown)
If initial compliance report, provide the volume weighted average mass of VOC per volume of applied coating solids for each affected facility (§60.395a(e)(1)) If initial compliance report, provide as a PDF file attachment the data collected to establish operating limits for the capture or control device and enter the name of the attachment here
(§60.395a(e)(2)(i))
If initial compliance report, provide the total mass of VOC per volume of applied coating solids before the control device as required by §60.396a (§60.395a(e)(2)(ii)) If initial compliance report, provide the total mass of VOC per volume of applied coating solids after the control device as required by §60.396a (§60.395a(e)(2)(ii)) If initial compliance report, provide the destruction efficiency of the control device used to attain compliance with the applicable emission limit specified in §60.392a(a) (§60.395a(e)(2)(iii)) If initial compliance report, the capture efficiency as required by §60.397a
(§60.395a(e)(2)(iv))
If initial compliance report, a description of the method used to establish the capture efficiency for the affected facility
(§60.395a(e)(2)(iv))
If initial compliance report, the transfer efficiency test results
(§60.395a(e)(2)(v))
If initial compliance report, a description of the method used to establish the transfer efficiency for the affected facility
(§60.395a(e)(2)(v))
RecordId ProcessUnit_Identification RecordUnit_Identification InitCompRpt AvgVOCPerAppCoat DataCollectedName VOCPerAppCoatPre VOCPerAppCoatPost CntrlDestEff CapEff CapEffMetDesc TransEff TransEffMetDesc
e.g.: 1 e.g.:Truck1 e.g.: 1 Truck1 e.g.: Yes e.g.: 4.13% e.g.: OpLimit_Data.pdf e.g.: 5.2 mg/kg e.g.: 12.2 mg/l e.g.: 98.65% e.g.: 98.65% e.g.: Method 204 e.g.: 97.30% e.g.:
e.g.: 1 e.g.:Truck1 e.g.: 1 Truck1 e.g.: No e.g.: e.g.: e.g.: e.g.: e.g.: e.g.: e.g.: e.g.: e.g.:










































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































Sheet 6: CMS_Identification

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022



§60.395a(j) Compliance Report Spreadsheet Template



Company Record No.
(Autocompleted from Column D)
Process Unit / Source Description
(§§60.7(d), 60.395a(f)(4))
(Autocompleted from Column D)
Company Record Number and Process Unit / Source Description
(Select from dropdown)
Brief Description of CMS Including Manufacturer and Model Number
(§§60.7(d), 60.395a(h)(4))
Date of Last CMS
Certification or Audit
(§§60.7(d), 60.395a(h)(5))
RecordId ProcessUnit_Identification RecordUnit_Identification CPMSEqDesc_Identification CMSCertification_Identification
e.g.: 1 e.g.: Truck1 e.g.: 1 Truck1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 2/2/2017


































































































































































































































































































































































































Sheet 7: Monthly_VOC_Deviation

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations




for which Construction, Modification or Reconstruction Commenced After May 18, 2022




§60.395a(j) Compliance Report Spreadsheet Template




Company Record No.
(Autocompleted from Column D)
Process Unit / Source Description
(§§60.7(d), 60.395a(f)(4))
(Autocompleted from Column D)
Company Record Number and Process Unit
(Select from dropdown)
Beginning Date of Each Month during which the volume-weighted average of the total mass of VOC emitted per volume of applied coating solids exceed the applicable emission limit in §60.392a (§60.395a(h)(1)) Ending Date of Each Month during which the volume-weighted average of the total mass of VOC emitted per volume of applied coating solids exceed the applicable emission limit in §60.392a
(§60.395a(h)(1))
Provide as a PDF file attachment a copy of the calculation used for the volume-weighted average of the total mass of VOC emitted per volume of applied coating solids and enter the name of the attachment
(§60.395a(h)(2))
RecordId ProcessUnit_LimitSummary RecordUnit_LimitSummary AvgMassExceedMontStart AvgMassExceedMontEnd AvgMassCalcDescpPDFname
e.g.: 1 e.g.: Truck1 e.g.: 1 Truck1 e.g.: 1/1/2022 e.g.: 2/28/2022 e.g.: Monthly_VOC_Calcs_Q12022.pdf















































































































































































































































































































































































































































































Sheet 8: Capture_Control Deviation

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022






§60.395a(j) Compliance Report Spreadsheet Template






Company Record No.
(Autocompleted from Column D)
Process Unit / Source Description
(§§60.7(d), 60.395a(f)(4))
(Autocompleted from Column D)
Company Record Number and Process Unit
(Select from dropdown)
Malfunction of Control Device or Capture System
(Select from dropdown)
Date Malfunction Started (§60.395a(h)(3)) Time Malfunction Started (§60.395a(h)(3)) Date Malfunction Ended (§60.395a(h)(3)) Time Malfunction Ended (§60.395a(h)(3))
RecordId ProcessUnit_LimitSummary RecordUnit_LimitSummary CaptureOrControl MalStartDate MalStartTime MalEndDate MalEndTime
e.g.: 1 e.g.: Truck1 e.g.: 1 Truck1 e.g.: Capture System e.g.: 3/2/2017 e.g.: 15:52 e.g.: 3/2/2017 e.g.: 15:52









































































































































































































































































































































































































































































































































































































































Sheet 9: Description_of_Changes

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification
or Reconstruction Commenced After May 18, 2022
§60.395a(j) Compliance Report Spreadsheet Template
CMS, Process, Coating Operation, Emission Capture System or Control Changes
Company Record No.
(Select from dropdown)
Description of any changes in CMS, process, coating operation, emission capture system, or controls since the last report.
(§§60.7(d), 60.395a(h)(12))
RecordId CmsChangesDesc





















Sheet 10: CMS__Detail

40 CFR Part 60, Subpart MMa Standards of Performance for Automobile and Light Duty Truck Surface Coating Operations for which Construction, Modification or Reconstruction Commenced After May 18, 2022










§60.395a(j) Compliance Report Spreadsheet Template










Company Record No.
(Autocomplete from Column E)
Process Unit / Source Description
(§§60.7(c), 60.395a(f)(4))
(Autocomplete from Column E)
Brief Description of CMS
(§§60.7(c), 60.395a(h)(4))
(Autocomplete from Column E)
Company Record Number, Process Unit, and Brief Description of CMS
(Select from dropdown)
CMS Inoperative, Malfunctioning, or Out of Control
(§60.395a(h)(6) or (7))
Starting Date CMS
Inoperative, Malfunctioning, or Out of Control
(§§60.7(c)(3),
60.395a(h)(6) or (7))
Starting Time CMS Inoperative, Malfunctioning, or Out of Control
(§§60.7(c)(3),
60.395a(h)(6) or (7))
Ending Date CMS
Inoperative, Malfunctioning, or Out of Control
(§§60.7(c)(3), 60.395a(h)(6) or (7))
Ending Time CMS Inoperative, Malfunctioning, or Out of Control
(§§60.7(c)(3), 60.395a(h)(6))
Duration CMS Inoperative, Malfunctioning, or Out of Control (hours)
(§§60.7(c)(3), 60.395a(h)(6) or (7))
Nature of Repair, Adjustment or Corrective Actions Taken
(§§60.7(c)(3), 60.395a(h)(6) or (7))
Cause (Including Unknown Cause) for CMS Inoperation
(§60.395a(h)(6) or (7))
RecordId ProcessUnit_CMSDetail CPMSEqDesc_CMSDetail RecordUnit_CMSDetail InopOrOutofControl InopStartDate_CMSDetail InopStartTime_CMSDetail InopEndDate_CMSDetail InopEndTime_CMSDetail InopDurTime Repair_InopCMSDetail CMSInoperCauseName
e.g.: 1 e.g. Truck1 e.g.: TC1792 PM Filter Bank Inlet Temperature e.g.: 1 Truck1 TC1792 PM Filter Bank Inlet Temperature e.g.: Inoperative e.g.: 3/2/2017 e.g.: 15:52 e.g.: 3/4/2017 e.g.: 16:00 e.g.: 48.13 e.g.: Replaced thermocouple e.g.: Thermocouple corroded