5900-582 Part 60 Subpart MMA Compliance Report Template

---

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 oaqpscbi@epa.gov 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 oaqpscbi@epa.gov 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

---

Sheet 11: CMS_Downtime_Summary

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 CMS_Detail)	Process Unit / Source Description (§§60.7(d), 60.395a(f)(4)) (Autocompleted from CMS_Detail)	Brief Description of CMS (§§60.7(d), 60.395a(h)(4)) (Autocompleted from CMS_Detail)	Total Operating Time (hours) (§60.7(d)) (Autocompleted from Process_Unit_Source_Desc)	Total Duration of CMS Downtime (hours) (§§60.7(d), 60.395a(h)(11)) (Autocalculated from Columns H through L)	Total Duration of CMS Downtime as a percent of Total Operating Time (§§60.7(d), 60.395a(h)(11)) (Autocalculated from Columns E and F)	Total Duration of CMS Downtime Due to Monitor Equipment Malfunctions (hours) (§60.7(d))	Total Duration of CMS Downtime Due to Nonmonitoring Equipment Malfunctions (hours, minutes for opacity) (§60.7(d))2	Total Duration of CMS Downtime Due to Quality Assurance/Quality Control Calibrations (hours) (§60.7(d))	Total Duration of CMS Downtime Due to Other Known Causes (hours) (§60.7(d))	Total Duration of CMS Downtime Due to Unknown Causes (hours) (§60.7(d))
RecordId	ProcessUnit_CMSSummary	CPMSEqDesc_CMSSummary	TotalOperatingTime_CMSSummary	CPMSDowntimeDuration_CMSSummary	CPMSDowntimePercent_CMSSummary	MonitEquipmentCausedDeviation_CMSSummary	NonMonitEquipmentCausedDeviation_CMSSummary	QAQCCausedDeviation_CMSSummary	OtherCausedDeviation_CMSSummary	UnknownCausedDeviation_CMSSummary
e.g.: 1	e.g.: Truck1	e.g.: TC1792 PM Filter Bank Inlet Temperature	e.g.: 5421.25	e.g.: 72.50	e.g.: 1.34%	e.g.: 0.00	e.g.: 36.25	e.g.: 0	e.g.: 0	e.g.: 0

---

Sheet 12: Limit_Deviation_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. (Autocompleted from Column D)	Process Unit / Source Description (§§60.7(c)(2), 60.395a(h)(13)(ii) or (14)) (Autocompleted from Column D)	Company Record Number and Process Unit (Select from dropdown)	Operating Limit or Work Practice Deviated From or Bypass of Control Device (§§60.7(d), 60.395a(h)) (Select from Dropdown)	For a Deviation from a Work Practice, Description of Deviation (§60.395a(h)(13)(i))	Start Date of Deviation from Operating Limit or Work Practice, or Bypass of Control Device (§60.395a(h)(8) or (13)(i))	Start Time of Deviation from Operating Limit or Work Practice, or Bypass of Control Device (§60.395a(h)(8) or (13)(i))	Duration of Deviations from Operating Limit or Work Practice, or Bypass of Control Device (hours) (§60.395a(h)(8) or (13)(i))	Cause of Deviation (Including Unknown Cause) (§60.395a(h)(13)(ii) or (14))	Corrective Action Taken (§60.395a(h)(13)(ii))	For Deviation from a Work Practice, the Actions Taken to Minimize Emissions (§60.395a(h)(13)(i))
RecordId	ProcessUnit_LimitDetail	RecordUnit_LimitDetail	Std_Summary	WrkPracticeDescription	DevDate	DevStartTime	DevDuration	DeviationCause_LDD	CorrectiveAction_LDD	CorrectiveAction_LimitDetail
e.g.: 1	e.g.: Truck1	e.g.: 1 Truck1	e.g.: Thermal Oxidizer -Minimum Average Combustion Temperature	e.g.:	e.g.: 3/4/2017	e.g.: 16:00	e.g.: 6.75	e.g.: Loss of NG flow	e.g.: Halt coating until TO back online	e.g.:

---

Sheet 13: Emission_Limit_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. (Autocompleted from Column D)

Process Unit / Source Description (§§60.7(c)(2), 60.395a(h)(15)) (Autocompleted from Column D)

Company Record Number and Process Unit (Select from dropdown)

Emissions Limit (§60.7(d)) (Select from dropdown)

Starting Date of Excess Emissions (§60.7(c)(1))

Starting Time of Excess Emissions (§60.7(c)(1))

Ending Date of Excess Emissions (§60.7(c)(1))

Ending Time of Excess Emissions (§60.7(c)(1))

Magnitude of Excess Emissions (§§60.7(c)(1) and 60.395a(h)(15))

Units of Excess Emissions (§§60.7(c)(1) and 60.395a(h)(15))

Any Conversion Factors Used (§60.7(c)(1))

Description of Method Used to Estimate Emissions (§60.395a(h)(15))

Were the Excess Emissions During Startup, Shutdown, or Malfunction? (§60.7(c)(1)) (Select from dopdown)

Nature and Cause of Excess Emissions (§§60.7(c)(2) and 60.395a(h)(14))

Corrective Action Taken or Preventative Measures Taken (§60.7(c)(2))

RecordId

ProcessUnit_LimitDetail

RecordUnit_LimitDetail

Pollutant_LimitDetail

DeviationStartDate_LimitDetail

DeviationStartTime_LimitDetail

DeviationEndDate_LimitDetail

DeviationEndTime_LimitDetail

Magnitude_LimitDetail

Units_LimitDetail

Conversion_LimitDetail

EstimateMethod

SSM_LimitDetail

DeviationCause_LimitDetail

CorrectiveAction_LimitDetail

e.g.: 1

e.g.: Truck1

e.g.: 1 Truck1

e.g.: §60.392a(a)(4) Topcoat - 0.42 kg VOC/L

e.g.: 2/12/2017

e.g.: 13:05

e.g.: 2/12/2017

e.g.: 13:05

e.g.: 12.2

e.g.: mg/dscm

e.g.: None

e.g.: AP-42 Emission Factors

e.g.: None of These

e.g.: Control Equipment Problems

e.g.:Ceased coating until TO back online

---

Sheet 14: Limit_Deviation_Summary

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 E)

Process Unit / Source Description (§§60.7(d), 60.395a(f)(4)) (Autocompleted from Column E)

Total Operating Time (hours) (§60.7(d)) (Autocompleted from Process_Unit_Source_Desc)

Company Record Number and Process Unit (Select from dropdown)

Identify if Deviation is from Emission Limit, Operating Limit, or Work Practice or Bypass of a Control Device (§§60.7(d), 60.395a(h)) (Select from Dropdown)

If Work Practice Deviations, Provide the Number of Deviations (§60.395a(h)(13))

Total Duration of Deviations from Emission Limitation, Operating Limit, or Work Practice (hours) (§§60.7(d), 60.395a(h)(9), 60.395a(h)(13)(i)) (Autocalculated from Columns J through N)

Total Duration of Deviations from Emission Limitation, Operating Limit, or Work Practice as a percent of Total Operating Time (§§60.7(d), 60.395a(h)(9)) (Autocalculated from Columns D and H)

Total Duration of Deviations from Emission Limitation or Work Practice Due to Startup/Shutdown (hours) (§60.7(d))

Total Duration of Deviations from Emission Limitation, Operating Limit or Work Practice Due to Control Equipment Problems (hours) (§§60.7(d), 60.395a(h)(10))

Total Duration of Deviations from Emission Limitation, Operating Limit, or Work Practice Due to Process Problems (hours) (§§60.7(d), 60.395a(h)(10))

Total Duration of Deviations from Emission Limitation, Operating Limit, or Work Practice Due to Other Known Causes (hours) (§§60.7(d),60.395a(h)(10))

Total Duration of Deviations from Emission Limitation, Operating Limit, or Work Practice Due to Unknown Causes (hours) (§§60.7(d), 60.395a(h)(10))

RecordId

ProcessUnit_LimitSummary

TotalOperatingTime_LimitSummary

RecordUnit_LimitSummary

Std_Summary

NumWPDev

TotalDeviationDuration_LimitSummary

TotalDeviationPercent_LimitSummary

StartupCausedDeviation_LimitSummary

EquipmentCausedDeviation_LimitSummary

ProcessCausedDeviation_LimitSummary

OtherCausedDeviation_LimitSummary

UnknownCausedDeviation_LimitSummary

e.g.: 1

e.g.: Truck1

e.g.: 5421.25

e.g.: 1 Truck1

e.g.: Work Practice

e.g.: 3

e.g.: 72.50

e.g.: 1.34%

e.g.: 36.25

e.g.: 36.25

e.g.: 0

e.g.: 0

e.g.: 0

---

Sheet 15: Revisions

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
Revision Number	Date	Revisions
Draft	5/17/2022	Draft vesion sent to docket
OMB Draft	8/12/2022	Welcome - Updated information regarding Revisons tab, corrected a reference to the wrong sector, added a clarifying statement of date of report and statement of responsible official; Certifications - Updated dropdown for columns D and F; Process_Unit_Source_Desc - Updated Header of Column D to add reference to 60.395(a)(h)(ii) and add "Affected Source", added optional column for listing compliance option with associated dropdown list; Monthly_VOC_Deviation - formatting of columns C and D has been corrected to Date, added 2 columns to identify the affected source; CMS_Detail - Corrected spelling in Column F header, amended dropdown in Column F, deleted date entry in cell G24, updated header for columns G through K; CMS_Downtime_Summary - removed all references to opacity, added column for Monitor Equipment Malfunction, changed column F to autocalculate; Limit_Deviation_Detail - Remove incorrect reference from column K; Emission_Limit_Detail - corrected formatting of column H, revised Column E to Emission Limitation (60.7(d)), to dropdown from Autocompleted, and added dropdown list to provide emission limitation, Column added for any conversion factors used (60.7(c)(1)); Limit_Deviation_Sumary - corrected typo in dropdown menu of column F; All data entry tabs - added "e.g.:" to all blank example cells; where applicable added reference location for autocompleted and autocalculated columns, updated data entry cells to top align; Corrected data validation for Monthly_VOC_Deviation tab and Limit_Deviation_Detail tabs; Updated report name field on Welcome tab; Corrected rule name to include the date of proposal