5900-460 Snowmobile PLT

Certification and Compliance Requirements for Nonroad Spark-ignition Engines (Renewal)

5900-460 Snowmobile PLT_5900-460.xlsx

Certification and Compliance Requirements for Nonroad Spark-ignition Engines (Renewal)

OMB: 2060-0338

Document [xlsx]

Download: xlsx | pdf

Overview

Submission Template
Calculations
Notes
Instructions

Sheet 1: Submission Template


United States																																													Populated=0, Missing=1
Environmental Protection Agency																																													Check for Required Values to Calculate
Office of Transportation and Air Quality																														if proj annual prod (P12)		Production Period					proj annual prod	prod period	# Test periods	# Test periods CALC					EF	1
																														below 1600	and	any					1	1	1	1					PLT Contact	1
Manufacturer Production Line Testing Report for Snowmobiles																														at or above 1600		at or below 120					0	1	1	0					Prod Volume	1
Last Revision: September 2018 Version Number: 5.2																														at or above 1600		above 120, at or below 210					0	0	2	0					Carry-over	1
																									at or above 1600		above 210, at or below 300					0	0	3	0
Basic Information																									at or above 1600		above 300					0	0	4	0					Wintertime	1
					0	0		*You must fill in all yellow highlighted boxes in the header section below*																											1					Atl CO CARB3	1				Cert Fuel	0
Please enter a date between 01/01/2010 and 12/31/2029 in the format mm/dd/yyyy.			Manufacturer:							Engine Family:	Please enter an Engine Family Name						Number of Test Periods:		1			Paperwork Reduction Act Notice																		Marine Gen	1				Marine Generator?
			PLT Test Contact:							Projected Annual Production Volume:							Current Test Period:					The public reporting and recordkeeping burden for this collection of information is estimated to average 12 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 Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed Form 5900-133 to this address.			Cert Fuel	0														Emissions Test	1				Alt CO?	0		Scenario			CO Standard
			Email Address:							Is this a Carry-Over Engine Family?:															CO Standard Logic								Extra CO Standard Logic For Blank							Prod Period From	1				Class I or II		0	Class I or II, MG yes, Alt CO yes, CARB3 Fuel			4.5
			Phone #:							*If pre-approved for reduced sample size, enter sample number:**															Engine Class	0							Fuel	Class I or II, MG no, Alt CO Yes	Class I or II, MG no, Alt CO no	III, IV or V, Alt CO yes				Prod Period TO	1				Class III or IV		0	Class I or II, MG yes, Alt CO no			5.0
			ANNUAL Production Period (mm/dd/yyyy):			From:		To:		Is this a Wintertime-Only Engine per §1054.101(c)?:															Marine Generator?	0							Gas	0	0	0				Cert Fuel	1				Class V		0	Class I or II, MG no, Alt CO yes, CARB3 Fuel			549
			Certified Fuel for Engine Family:							Are you meeting Alt CO standards in §1054.145(n)? (CARB Phase 3 Fuel only):															Alt CO?	0							CARB 2	0	0	0				Engine Class	1						0	Class III or IV or V, MG no, Alt CO yes, CARB3 Fuel			536
			Engine Class:							Is this a Marine Generator Engine Family?:																							CARB 3	0	0	0				MY	1						0	Class I or II, MG no, Alt CO no			610
			Model Year:							What Emission Test Procedure did you use?:			Any family that is not carry-over, must be Part 1065						0						0	Class I or II, MG yes, CARB3 yes							CNG	0	0	0				Current Test Period	1						0	Class III or IV, MG no, Alt CO no			805
													Any family that is not carry-over, must be Part 1065										OMB No. 2060-0338		0	Class I or II, MG yes, CARB3 no							LPG	0	0	0				Any missing?	14	If any missing, don't calculate on Calculations tab					0	Class V, MG no, Alt CO no			603
				Comments:											*If "Pre-approved reduced sample size is left blank, the minimum required sample size is the lesser of one plus the number of test periods and 1% of the projected production. For carry-over families, it is the lesser of the number of test periods and 1% of the projected production.									Approval Expires on		0	MG no, CARB3 yes							Duel Fuel	0	0	0				Calculate?	#N/A						0	CO Standard
																								10/31/2019		0	MG no, CARB3 no								Class I or II	Class I or II	III, IV or V											USE THIS ONE
																								EPA Form 5900-133		0	CO Standard								MG no	MG no						Valid Date Range
																														old logic									Alt CO yes	Alt CO no	Alt CO yes				not	1/1/2010
																																	1st Char EF							ok	12/31/2029
																									Production Period Days		Number of Test Periods						1st Char EF	MY EF	MY input	Match?																			Maybe change
PLT Engine Test Results																														0									#N/A	0	#N/A				Missing HC+Nox Emission Limit/FEL and/or DF?				0											F,G,H,I
								Det. Factor Type		HC Emission Limit/FEL		HC Det. Factor	HC Det. Factor Type		CO Standard		CO Det. Factor	CO Det. Factor Type																										Modified to say NO if header fields missing				Change formula from C to BU				Added extra check if C blank to suppress yellow error	old formula only looked at result values		Doesn't look for Final or Fuel	Check for C missing with data row	Check for E missing with data row	Based on C, E		had to add logic for blank P15		ok=0
																																																No mismatch if blank							NOT USED							skip=1

		Final or	Test	Fuel Type			Build	Service		HC	HC	HC	HC		CO	CO	CO	CO				Invalid Reason/Remedy if Failed Test/Test Comments			*HIDDEN FIELDS*															HC+NOX										CO	CO	HC+Nox	CO	HC+NOX	Other	Final/Initial	Fuel Type	Blank Row	Not Blank final row	HC data	CO Data	Row skipped	The row that		Supressing future	Test date	Suppress future	If final, HC and CO missing
	Test	Initial or	Date		Test	Engine	Date	Hours	Test	Initial	Initial	Final	Final	Include in	Initial	Initial	Final	Final	Include in	Test	Test																			Missing	HC+Nox Cum Sum			HC+Nox	CO Cum Sum		CO	Fuel Type Match		Missing	Missing	Values in both	Values in both	Missing initial	Data	Missing	Missing		Test Period Missing	present	present	Before Data row	is skipped		calcs if skipped row	in sequence?	calcs if test date wrong	but other data
	Number	Invalid?	(mm/dd/yyyy)		Period	ID	(mm/dd/yyyy)	Accumulation	Cycle	Result	Rounded Result	Result	Det. Result	CumSum?	Result	Rounded Result	Result	Det. Result	CumSum?	Location	Contact				year	month	day	tp1	tp2	tp3	tp4									final but no value	Invalid	final/wintertime	initial	Include	Invalid	Initial	Include	0	Sum	Final but no value	Initial but no value	final/initial	final/initial	Initial but no value	Missing?	with other data	with other data

1																												0	0	0	0		0					canbeinvalid	yes	0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0	<=this formula is different	0	0	0	0
2																												0	0	0	0				HC?	CO?		canbeinvalid	no	0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
3																												0	0	0	0				1	1		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
4																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
5																												0	0	0	0		Small SI					canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
6																												0	0	0	0		Large SI	1	yes	12/30/1899	12/30/1899	canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
7																												0	0	0	0		Marine SI	2	no	12/30/1899	12/30/1899	canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
8																												0	0	0	0			3	Additive	12/30/1899	12/30/1899	canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
9																												0	0	0	0			4	Multiplicative	12/30/1899	12/30/1899	canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
10																												0	0	0	0				Part 90			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
11																												0	0	0	0		Additive		Part 1065			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
12																												0	0	0	0		Multiplicative	g/bhp-hr	I			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
13																												0	0	0	0			g/kW-hr	II			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
14																												0	0	0	0				III			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
15																												0	0	0	0				IV			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
16																												0	0	0	0				V			canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
17																												0	0	0	0	initial	N/A	yes				canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
18																												0	0	0	0	final		no				canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
19																												0	0	0	0	invalid			First Char EF	Year		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
20																												0	0	0	0				9	2009		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
21																												0	0	0	0				a	2010		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
22																												0	0	0	0		Gasoline		b	2011		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
23																												0	0	0	0		CARB Phase 2		c	2012		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
24																												0	0	0	0		CARB Phase 3		d	2013		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
25																												0	0	0	0		CNG		e	2014		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
26																												0	0	0	0		LPG		f	2015		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
27																												0	0	0	0		Dual fuel engine		g	2016		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
28																												0	0	0	0				h	2017		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
29																												0	0	0	0				j	2018		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
30																												0	0	0	0		Cycle A		k	2019		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
31																												0	0	0	0		Cycle B		l	2020		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
32																												0	0	0	0		Cycle C		m	2021		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
33																												0	0	0	0		Special		n	2022		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
34																												0	0	0	0				p	2023		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
35																												0	0	0	0				r	2024		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
36																												0	0	0	0				s	2025		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
37																												0	0	0	0				t	2026		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
38																												0	0	0	0				v	2027		canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
39																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
40																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
41																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
42																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
43																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
44																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
45																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
46																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
47																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
48																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
49																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
50																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
51																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
52																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
53																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
54																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
55																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
56																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
57																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
58																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
59																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
60																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
61																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
62																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
63																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
64																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
65																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
66																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
67																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
68																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
69																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
70																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
71																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
72																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
73																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
74																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
75																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
76																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
77																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
78																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
79																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
80																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
81																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
82																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
83																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
84																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
85																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
86																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
87																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
88																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
89																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
90																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
91																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
92																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
93																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
94																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
95																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
96																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
97																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
98																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
99																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
100																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
101																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
102																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
103																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
104																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
105																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
106																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
107																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
108																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
109																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
110																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
111																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
112																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
113																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
114																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
115																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
116																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
117																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
118																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
119																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
120																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
121																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
122																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
123																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
124																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
125																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
126																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
127																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
128																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
129																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
130																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
131																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
132																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
133																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
134																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
135																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
136																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
137																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
138																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
139																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
140																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
141																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
142																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
143																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
144																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
145																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
146																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
147																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
148																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
149																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
150																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
151																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
152																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
153																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
154																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
155																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
156																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
157																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
158																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
159																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
160																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
161																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
162																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
163																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
164																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
165																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
166																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
167																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
168																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
169																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
170																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
171																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
172																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
173																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
174																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
175																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
176																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
177																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
178																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
179																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
180																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
181																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
182																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
183																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
184																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
185																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
186																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
187																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
188																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
189																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
190																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
191																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
192																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
193																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
194																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
195																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
196																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
197																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
198																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
199																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
200																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
201																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
202																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
203																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
204																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
205																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
206																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
207																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
208																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
209																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
210																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
211																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
212																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
213																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
214																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
215																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
216																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
217																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
218																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
219																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
220																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
221																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
222																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
223																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
224																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
225																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
226																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
227																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
228																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
229																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
230																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
231																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
232																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
233																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
234																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
235																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
236																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
237																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
238																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
239																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
240																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
241																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
242																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
243																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
244																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
245																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
246																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
247																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
248																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
249																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
250																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
251																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
252																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
253																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
254																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
255																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
256																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
257																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
258																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
259																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
260																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
261																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
262																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
263																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
264																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
265																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
266																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
267																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
268																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
269																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
270																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
271																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
272																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
273																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
274																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
275																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
276																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
277																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
278																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
279																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
280																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
281																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
282																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
283																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
284																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
285																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
286																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
287																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
288																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
289																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
290																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
291																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
292																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
293																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
294																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
295																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
296																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
297																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
298																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
299																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0		0	0	0	0
300																												0	0	0	0							canbeinvalid		0	0	0	0		0	0		0		0	0	0	0	0	0	0	0	blank	0	No HC Data	No CO Data	0	0	<=last row different	0	0	0	0
																																								0										0	0	0	0	0	0	0			0			0				0		0
																																								0														0								Any skipped/blank rows				Any test entries		HC and CO and Column C
																																								extra fail-safe for Wintertime														extra fail-safe for Wintertime					Any test periods missing			with a data row after				out of sequence		Missing but "data" row
																																																											for final non-blank row							(date)


																											SUM
																											0
																											This is to determine if there are ANY values in HC+NOx
																											HC+NOx should be blank if Wintertime-only

Sheet 2: Calculations


United States
Environmental Protection Agency
Office of Transportation and Air Quality
																																																										Removed reference to AB34:123 in formulas in CF, CG, CH, CI, CJ (and AG)
Manufacturer Production Line Testing Report for Snowmobiles																																																										Test Invalid cells Submission Template AB34 removed- now autopopulated if C34="invalid"
Last Revision: September 2018 Version Number: 5.2																																																										Don't forget there are values in rows below that are not visible because the row height is small
																																																											final and include
Calculated Results Data																																																										Invalid?	Mean Result HC+Nox	Req N HC+NOX	Mean result CO	Req N CO	THERE IS DATA IN THE YELLOW ROWS

																																																							EFName	0		0
																																																							Status			0
																																																							HC res			0
	Current PLT Test Status:																Paperwork Reduction Act Notice					OMB No. 2060-0338								# of test periods	1		Current Test Period																						HC stan			0
	Current PLT Test Status:																This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-0338). Responses to this collection of information are mandatory (40 CFR 1051). 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 12 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 to the Regulatory Support Division Director, 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.					Approval Expires on											0																						CO res		0	0
																						10/31/2019								Test Period Requirements Check																									CO stan			0
			Engine Family:				0															EPA Form 5900-133																																	HC+NOx res		0	0
			HC (passing status?)				No test results entered			HC (N-met?):			No																	# TP1	# TP2	# TP3	# TP4																						HC+NOx stan	0.0		0
			CO (passing status?)				No test results entered			CO (N-met?):			No																	0	0	0	0	How many tests in each period																					NOx res			0
	Note: A 'PASS' is only possible when # of Test Periods = Current Test Period																													2	1	1	1																						NOx stan			0
			PASSING STATUS:							Maximum Tests:			30														# of test periods	1		1																									PM res			0
				Please correct any incorrect entries on the Submission Template																							carryover or +1	2		-1	-1	-1	-1	Actual Prod																					PM stan			0
			Notes:	*You must fill in all yellow highlighted boxes in the header section of the Submission Template.																							1% proj volume	5		<=reduced N																									Tests Required	0.0		0
																											sample size	MIN	2		Proj Volume				0	Carry-over?																			Valid Tests	0		0
			* Number of included HC tests (n) is less than the required number (N).																									100		no	no	no	no																						Invalid Tests	0		0
			* Number of included CO tests (n) is less than the required number (N).											Statistics this reporting period:			OMB No. 2060-0338													only TP1	TP1 and TP2	TP1, 2 and 3	TP 1, 2, 3, 4																						Date Start	12/30/1899		0
														Total Engine Families tested:			Approval Expires on							Carry over?	0		check if prod >0 in the test period			0	0	0	0		0	new logic - just checking for Actual production in all test periods up to current. If "not" - PASS status blanK																			Date End	12/30/1899		0
														Total Number of tests:			1/31/2022							Carry-over first non-blank HC+Nox			if checking that period, are there tests			0	0	0	0		not	If this is "not", makes PASS status be blank => forces OPEN (if not FAIL)																			comment			0
														Total tests that passed:			EPA Form 5900-460							#N/A																																		0
																								Carry-over first non-blank CO																				#VALUE!														0
					HC - Calculations										CO - Calculations									#N/A					HC	CO														#VALUE!														0
																																																										0
	Actual	Required						Sample			Actual	Required						Sample											Calculation	Calculation							Included	Included	HC+NOx	CO																		0
	Sample	Sample	Mean	Standard	Prior		Action	Requirement	HC	HC	Sample	Sample	Mean	Standard	Prior		Action	Requirement	CO	CO			1st Carry over HC	1st Carry over CO	HC CarryOver	Sample size for t-value lookup		CO CarryOver	Data	Data					CumSum	CumSum	CumSum	CumSum	Included	Included				HC+NOx	CO	EPA	HC+Nox	HC+Noc			CO	CO	1st Carry over HC	1st Carry over CO				0
	Size (n)	Size (N)	Result	Deviation	CumSum	CumSum	Limit	Met?	Fail?	Pass?	Size (n)	Size (N)	Result	Deviation	CumSum	CumSum	Limit	Met?	Fail?	Pass?	Warnings		HC Mean result	CO Mean result	Data	Including carryover issue		Data	Exists	Exists		t-value HC+NOx	t-value CO		HC+NOx Test #	CO Test #	HC+NOx Binary	CO Binary	Results	Results	Carryover?			CALC N	CALC N	APPROVED	Denominator?	Req sample size		1% projected production	Denominator	req sample size	HC STDEV	CO STDEV				0
																																			0	0																						0
																									notCO			notCO	0	0											0	n	t-value			2			30	0								0
																									notCO			notCO	0	0												1				2												0
																									notCO			notCO	0	0												2	6.31			2												0
																									notCO			notCO	0	0												3	2.92			2												0
																									notCO			notCO	0	0												4	2.35			2												0
																									notCO			notCO	0	0												5	2.13			2												0
																									notCO			notCO	0	0												6	2.02			2												0
																									notCO			notCO	0	0												7	1.94			2												0
																									notCO			notCO	0	0												8	1.90			2												0
																									notCO			notCO	0	0												9	1.86			2												0
																									notCO			notCO	0	0												10	1.83			2												0
																									notCO			notCO	0	0												11	1.81			2												0
																									notCO			notCO	0	0												12	1.80			2												0
																									notCO			notCO	0	0												13	1.78			2												0
																									notCO			notCO	0	0												14	1.77			2												0
																									notCO			notCO	0	0												15	1.76			2												0
																									notCO			notCO	0	0												16	1.75			2												0
																									notCO			notCO	0	0												17	1.75			2												0
																									notCO			notCO	0	0												18	1.74			2												0
																									notCO			notCO	0	0												19	1.73			2												0
																									notCO			notCO	0	0												20	1.73			2												0
																									notCO			notCO	0	0												21	1.72			2												0
																									notCO			notCO	0	0												22	1.72			2												0
																									notCO			notCO	0	0												23	1.72			2												0
																									notCO			notCO	0	0												24	1.71			2												0
																									notCO			notCO	0	0												25	1.71			2												0
																									notCO			notCO	0	0												26	1.71			2												0
																									notCO			notCO	0	0												27	1.71			2												0
																									notCO			notCO	0	0												28	1.70			2												0
																									notCO			notCO	0	0												29	1.70			2												0
																									notCO			notCO	0	0												30	1.70			2												0
																									notCO			notCO	0	0												31	1.65			2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																									notCO			notCO	0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2												0
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2
																													0	0																2

Sheet 3: Notes

United States

Environmental Protection Agency

Office of Transportation and Air Quality

Manufacturer Production Line Testing Report for Snowmobiles

Last Revision: September 2018 Version Number: 5.2

Manufacturer Notes

Please provide any additional notes here.

Paperwork Reduction Act Notice

The public reporting and recordkeeping burden for this collection of information is estimated to average 12 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 Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed Form 5900-133 to this address.

OMB No. 2060-0338

Approval Expires on

10/31/2019

EPA Form 5900-133

Sheet 4: Instructions

United States

Environmental Protection Agency

Office of Transportation and Air Quality

Manufacturer Production Line Testing Report for Snowmobiles

Last Revision: September 2018 Version Number: 5.2

Manufacturer Data Submission Template -- INSTRUCTIONS

I. About

The instructions in this document are specific to the Small SI template. This template is intended for use by manufacturers who are submitting PLT data in accordance with the specifications in 40 CFR 1054, Subpart D. This template allows engine manufacturers to submit production line testing (PLT) data in a simple, consistent format. Based on the information entered, the template performs the required CumSum and sample size calculations for each parameter (HC and CO) and displays the current status of the test.

It is intended that a copy of this template be created for each engine family for which the reporting of PLT results is required. The engine family name should be included in the submission file name. Note that §1054.345(a) indicates that these data must be submitted for each ‘test period’ as defined under §1054.310(a). One copy of a template should be maintained per engine family, per year. For instance, the file submitted for the second quarter or test period will contain all test results previously submitted. A field in the ‘Submission Template’ worksheet can be used to indicate the associated quarter or test period at the engine test level.

Manufacturers who have received approval for using an alternate program should contact EPA for further instructions. The general structure of this reporting template is as follows:

● The primary worksheet for entering PLT data is the worksheet labeled "Submission Template". Only values in cells that are white or yellow may be modified. The green shaded cells contain either labels or calculated values. Cells that are shaded gray or black should not have data entered. Cells that are highlighted in yellow with red bold font have incorrect data and should either be corrected, entered, or deleted. Cells that are shaded pink have missing test results and should be populated.

● The resulting calculations, including an indication of whether the test results yield a status of Pass, Fail, or Open, are displayed in the "Calculations" worksheet.

● The "Notes" worksheet provides space for a manufacturer to provide any additional notes or relevant information for the engine family's PLT information.

Before entering data in this template, international users should ensure that the settings for number handling are consistent with the template. Number handling settings that currently specify the use of a comma for the decimal separator and a period for the thousands separator must be temporarily modified to avoid errors within the automatic calculations. To modify the number handling settings, the users with Excel 2003 should go to the "Tools" menu and select "Options." In the window that appears, the "International" tab should be selected. At the top of this tab there will be a section at the top entitled "Number handling"; the check mark in the "Use system separators" box found within this section should be removed. At this point, a period should be inserted for the decimal separator and a comma should be inserted for the thousands separator. Users with Excel 2007 can get to the appropriate screen by clicking on the Microsoft Office Button, clicking on "Excel Options", and then going to the "Advanced" tab. Users with Excel 2010 should select the "File" tab and select "Options" and "Advanced." There is an option to deselect "Systems Separators", enter a period for the decimal separator and a comma for the thousands separator, and reselect "Systems Separator".

II. General Information

At the top of the "Submission Template" worksheet, there are spaces to enter general information about the PLT test. These fields include:

● Manufacturer contact information (manufacturer name, PLT test contact**, e-mail address, and phone number);

● Annual Production period** (From and To);

● Certified Fuel for engine family**;

● Engine class (I, II, III, IV, or V)**;

● Model Year**;

● Engine family identifier**;

● Projected annual production volume**;

● Indication of whether the engine family is a carry-over family**;

● Sample number, if pre-approved for reduced sample size;

● Indication of whether a Wintertime-Only Engine per §1054.101(c)?**;

● Indication of whether meeting Alt CO standards in §1054.145(n)? (CARB Phase 3 Fuel)**:

● Indication of whether the engine family is a marine generator engine family**;

● Emission Test Procedure (Part 1065 or Part 90)**;

● Number of Test Periods (NOTE: This field is auto-calculated and cannot be edited);

● Current Test Period**;

● Actual Production, Test Period # (NOTE: Depending on the Test Periods, 1, 2, 3 or 4 may be displayed);

● Comments;

Fields indicated with a ** are required. If any of these fields are missing, Passing Status will not be displayed on the Calculations tab, and a message stating, "*You must fill in all yellow highlighted boxes in the header section of the Submission Template" will be displayed.

If an engine family is certified with carry-over emissions data, the field labeled "Is this a carry-over engine family?" should be set to "yes." If EPA has approved a reduced sample size, the user can enter the reduced size in the field labeled "If pre-approved for reduced sample size, enter sample number". The first row of data entered for a carry-over engine family should be the last test results from the previous year, and a test period is not required for this row. If the engine family has been specified as a carry-over engine family, the first row in the Calculations worksheet will appear in pink.

The template also provides fields for users to enter the actual production volume for the current test period as well as the previous test periods for the year. These fields appear once the user has specified the test period for which the report is being submitted. A field for the number of test periods to be used in the year is auto-calculated and cannot be edited. Users should also provide the start and end date for each test period in the "Notes" tab.

*If "Pre-approved reduced sample size is left blank, the minimum required sample size is the lesser of one plus the number of test periods and 1% of the projected production. For carry-over families, it is the lesser of the number of test periods and 1% of the projected production.

The Comments field should be used to describe the reason for invalidating a test, justifying an initial test, describing any nonroutine adjustment, modification, repair, preparation, maintenance, or test for the engine if it was not reported to EPA separately (§1054.350(a)(7)).
Information on the facility description, how engines are randomly selected, the model number, time and duration of testing should not be entered in the comments field, but should be maintained in your records and be available if EPA should ask for it.

III. Test Results

PLT test results are composed of test results from individual engines within the engine family being tested. The user should round the initial results to the number of decimal places in the emission standard expressed to one additional significant figure (see §1054.315(a)). The user should then calculate a final result by averaging these results for the engine and rounding this average, again to the number of decimal places in the emission standard expressed to one additional significant figure (see §1054.315(a)). The initial and final results should then be entered into the template. Each initial result corresponding to an individual engine should be entered in its own row, in the "Initial Result" column for each relevant pollutant. Under the column labeled "Final or Initial or Invalid?" (column C), "initial" should be selected; this will gray out the "Final Result" cells and the corresponding "Include in CumSum?" cells in that row will be auto-populated with "no" for each pollutant. After all the initial results for an individual engine have been entered, the final result should be entered on the next row, in the "Final Result" column for each relevant pollutant. Under the column labeled "Final or Initial?", "final" should be selected; this will gray out the "Initial Result" cells for each pollutant. The corresponding "Include in CumSum?" cells for each relevant pollutant will be auto-populated with "yes", assuming that required and valid data has been entered. The date entered in this row should be the date entered for the last initial test (which should be in the previous row).

In the case that there is only a single test corresponding to an individual engine, there is no need for results to be entered separately as initial and final; the test result can be entered once, on a single row, with an entry of "final" in the "Final or Initial or Invalid?" column. When carry-over data is included, only the final result from the last engine tested the previous model year should be filled in - if multiple initial tests were performed on this engine, the initial test results should not be entered.

If "invalid" is selected for a test in the "Final or Initial or Invalid?" cell, the corresponding "Include in CumSum?" cells will be auto-populated with "no" and not used in the calculations.

It is important that data be entered starting in the first row (beginning in cell B34) of the "Submission Template" worksheet. Furthermore, to ensure the accuracy of the CumSum results, the specific engine tests should be entered in the order in which they occurred and in consecutive rows. Skipping rows will preclude accurate CumSum calculations.

The following fields apply to all of the engine tests and are only filled in once:

● HC Emission Limit or FEL (required);

● HC Deterioration Factor (required);

● CO Deterioration Factor (required).

The following fields apply to all of the engine tests and are auto-populated/calculated:

● Deterioration Factor type (multiplicative, applies to all parameters);

● CO Standard (auto-calculated, dependent on Engine Class, if a Marine Generator and if Alt CO Standards (CARB Phase 3 Fuel) are used).

The following data fields are available for each engine test. Fields that are required for valid CumSum calculations are indicated. The official reporting requirements can be found in §1054.345.

● Test Number; this should be numeric and sequential;

● Final or Initial or Invalid? (required);

● Test Date;

● Fuel Type (required; select Gasoline, CARB Phase 2, CARB Phase 3, CNG, or LPG; must match "Certified Fuel for Engine Family" in header - unless Dual Fuel was entered as the certified fuel);

● Test Period (required for final tests);

● Engine ID;

● Build Date;

● Service Hours Accumulation;

● Test Cycle (Cycle A, Cycle B, Cycle C, or Special);

● HC Initial Result (should only be filled in if "Final or Initial or Invalid" is equal to "initial" or "invalid");

● HC Initial Rounded Result (automatically filled in based on HC Initial Result);

● HC Final Result (based on one or more Initial Result; should only be filled in if "Final or Initial or Invalid" is equal to "final");

● HC Final Deteriorated Result (automatically filled in based on HC Final Result and the HC Deterioration Factor);

● Include (HC Result) in CumSum? (auto-populated based on if "final" and other required data is present and valid);

● CO Initial Result (should only be filled in if "Final or Initial or Invalid" is equal to "initial" or "invalid");

● CO Initial Rounded Result (automatically filled in based on HC Initial Result);

● CO Final Result (based on one or more Initial Result; should only be filled in if "Final or Initial or Invalid" is equal to "final");

● CO Final Deteriorated Result (automatically filled in based on CO Final Result and the CO Deterioration Factor);

● Include (CO result) in CumSum? (auto-populated based on if "final" and other required data is present and valid");

● Test Location;

● Test Contact;

● Invalid Reason/Remedy if Failed Test/Test Comments

IV. Submission Template/Calculations Errors

The following list includes corrections that must be made in order for the Calculations to occur correctly and the Passing Status to be displayed. NOTE: A "PASS" status will not appear regardless of the number of final tests entered or test results until the FINAL Test Period (i.e., Current Test Period must equal Number of Test Periods for a status of PASS to appear).

● Required fields in Basic Information header missing. The missing field will be highlighted in yellow. Additionally, a message is displayed in the Calculations worksheet stating "*You must fill in all yellow highlighted boxes in the header section of the Submission Template." Calculation and Passing Status will not be displayed until the missing fields are entered.

● Certified Fuel Type for Engine Family does not match one or more Fuel Type(s) in the Submission Template PLT Engine Test Results. Yellow error messages stating "Certifed Fuel Type must = 'Fuel Type' below" and "Please correct all incorrect fuel types below (yellow cells)" will be displayed. The mismatched Fuel Type cells will be highlighted in yellow with bold red font so that you can easily correct the incorrect fuels. On the Calculations worksheet, a message is displayed stating "*Please resolve all fuel type discrepancies on the Submission Template." Passing Status will not be displayed until the missing fields are entered, with the exception of a FAIL status. Note: If Dual Fuel Engine is selected for Certified Fuel Type for Engine Family, different Fuel Type may be entered in the test result rows.

● Test result values entered in incorrect final/initial cell. If a row is indicated as final, but there is a value in initial result (or vice versa), a message will appear above the column header stating "Delete values from cells below highighted in yellow." Additionally, the incorrect cells will be highlighted in yellow. Please delete the incorrect value, and ensure that the correct cell is filled in. This will also occur if values are entered on the same row for both Initial and Final. Additionally, a message is displayed in the Calculations worksheet stating "*Please correct all duplicate test entries on the Submission Template." Passing Status will not be displayed until the incorrect fields are deleted.

● Test result values entered in HC cells (final or initial) when Wintertime-only is "Yes". If "Yes" is selected for "Is this a Wintertime-Only Engine per §1054.101(c)?" the HC cells are all blacked out. A message will appear stating "Wintertime engines are not required to test HC. See §1054.101(c)." If there are any data in the HC cells that were blacked out, there will be a message above the column header stating "Delete values from cells below highighted in yellow." The cells containing the data will be highlighted in yellow, and should be deleted. A message is displayed in the Calculations worksheet stating "*Please remove all incorrect test entries on the Submission Template." Passing Status will not be displayed until the incorrect fields are deleted.

● Test result values missing in final or initial cell. If a row is indicated as final, but there is not a value in the final result cell, or if a row is indicated as initial, but there is not a value in the initial result cell, a message will appear stating "* There is a missing a test result value for a test in the PLT Engine Test Results table (see pink colored cells below)." Additionally, there will appear another message above the column header stating "Enter the missing test result values in the cells below highlighted in pink." The missing cells will be highlighted in pink, and you should ensure that the correct cell is filled in. A message is displayed in the Calculations worksheet stating "*Please enter missing test result value(s) in the Submission Template worksheet." Passing Status will not be displayed until the missing fields are entered.

● OPEN status due to missing test period test results or actual production values. "*You are missing test result(s) and/or actual production for one or more test periods" with an OPEN status. If you do not have final tests for each Test Period up to and including the Current Test Period indicated on the Submission Template, the status will remain OPEN until you enter or correct the final test results for the appropriate Test Period. Another reason for this error is missing Actual Production for one of the periods. Passing Status will not be displayed until the missing fields are entered.

V. Calculations Worksheet - Current PLT Test Status

The "Calculations" worksheet checks the data that is entered and attempts to determine the current status of the PLT test. The test will appear to be in exactly one of three possible statuses -- FAIL, PASS, or OPEN. There will be informative ("Notes") and error messages below the status cells to help indicate issues with the data.

● FAIL: The PLT Test will be in a failing status if, for one or more parameter, there are consecutive engine tests in which the calculated CumSum statistic exceeds the calculated Action Limit value. Once a test has reached a fail status, subsequent tests will not change it.

● PASS: The PLT Test will be a passing status (in the FINAL test period only) if, for all required parameters, the actual number of included engine tests (n) is greater than or equal to the required test sample size (N), and for all required parameters, the mean result is less than or equal to the provided emission limit or FEL. Please note that even if a passing status is achieved, there may be additional requirements for the number of tests required each test period. Please refer to 40 CFR 1054.310 for additional details.

● OPEN: The PLT Test will remain in an open status if it has not yet reached a fail or pass status. If you have an OPEN status but you believe your results should have passed, check that there are test results entered for each test period up to and including the current test period, and that Actual Production for each period is greater than zero.

● NO PASSING STATUS (All Blank): The Passing Status will not be displayed until errors are corrected. Refer to error message(s) and go to the Submission Template worksheet to correct errors/missing data.

VI. Troubleshooting

If there are odd or unexpected results in the "Calculations" worksheet, the following should be checked:

● For HC, has an Emission Limit or FEL been entered?

● For each required parameter, has a deterioration factor been entered?

● Have all engine tests been entered sequentially without skipping rows?

● If this has been indicated as a carry-over engine family, has the final result from the last engine tested the previous model year been entered as the first entry in the worksheet?

● If this has been indicated as a carry-over engine family, has a reduced sample size been entered?

● For each row where the "Final or Initial or Invalid?" column equals "final", has the final result been entered for each relevant parameter?

● If there are any rows where the "Final or Initial or Invalid?" column equals "initial", has data mistakenly been entered in the "Final Result" columns for these rows?

● Has an included test inadvertently been marked as Invalid?

● All parameters must continue to be tested until all have met their sample size requirement (N). If you elect to test more engines, the test results will be included in the sample size and CumSum calculations (See §1054.310(i) and §1054.315(e)).

● Has a low Projected Annual Production mistakenly been entered?

● Have all required fields been entered in the header "Basic Information" section of the Submission Template?

● If you have an OPEN status but you believe your results should have passed, check that there are test results entered for each test period up to and including the current test period, and that Actual Production for each valid period is greater than zero. A status of PASS will not appear in any case until the FINAL test period (when Current Test Period = Number of Test Periods).

Paperwork Reduction Act Notice

OMB No. 2060-0338

Approval Expires on

10/31/2019

EPA Form 5900-133

File Type	application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified	0000-00-00
File Created	0000-00-00