{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Web","Instructions","In-Use Test Results","Notes"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Web","index":0,"n_rows":20,"n_cols":80,"rows_kept":20,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":78},"EFName",{"$error":"#REF!"}]
[{"$nulls":78},"Status",{"$error":"#REF!"}]
[{"$nulls":78},"HC res",{"$error":"#REF!"}]
[{"$nulls":78},"HC Stan",{"$error":"#REF!"}]
[{"$nulls":78},"CO res",{"$error":"#REF!"}]
[{"$nulls":78},"CO Stan",{"$error":"#REF!"}]
[{"$nulls":78},"HC+NOx res"]
[{"$nulls":78},"HC+NOx stan"]
[{"$nulls":78},"NOx res",{"$error":"#REF!"}]
[{"$nulls":78},"NOx stan",{"$error":"#REF!"}]
[{"$nulls":78},"PM res",{"$error":"#REF!"}]
[{"$nulls":78},"PM stan",{"$error":"#REF!"}]
[{"$nulls":78},"Tests Required",{"$error":"#REF!"}]
[{"$nulls":78},"Valid Tests",{"$error":"#REF!"}]
[{"$nulls":78},"Invalid Tests",{"$error":"#REF!"}]
[{"$nulls":78},"Date Start",{"$error":"#REF!"}]
[{"$nulls":78},"Date End",{"$error":"#REF!"}]
[{"$nulls":78},"comment",{"$error":"#REF!"}]
[{"$nulls":78},"Line Haul/Switch",""]

{"sheet":"Instructions","index":1,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[51,1,58,14],[50,1,50,17],[48,2,48,17],[53,15,53,17],[54,15,54,17],[36,2,36,17],[37,2,37,17],[1,1,1,17],[2,1,2,17],[3,1,3,17],[5,1,5,17],[51,15,51,17],[10,1,23,17],[25,2,25,17],[26,2,26,17],[6,1,6,17],[27,2,29,17],[24,1,24,17],[30,2,30,17],[31,2,31,17],[52,15,52,17],[32,2,32,17],[33,2,33,17],[34,2,34,17],[35,2,35,17],[49,1,49,17],[38,2,47,17]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"US Environmental Protection Agency"]
[null,"Office of Transportation and Air Quality"]
[]
[null,"Manufacturer In-Use Testing Report for Locomotive Engines"]
[null,"Last Revision: August 2018    Version Number: 1.1"]
[]
[null,"Manufacturer Data Submission Template -- INSTRUCTIONS "]
[]
[null,"This template allows locomotive engine manufacturers to submit In-Use test data in a simple, consistent format.  It is intended that a copy of this template be created for each engine family for which the reporting of In-Use test results is required.  The test results should be entered into the \"In-Use Test Results\" worksheet, which provides sections for five separate Engine Families.  If you need a reporting template with additional Engine Families, please contact your EPA Certification Representative for a revised version.  In accordance with §1033.425, test results are to be submitted within 90 days following completion of testing. \n\nBefore 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, 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 or Excel 2010 can get to the appropriate screen by clicking on the Microsoft Office Button, clicking on \"Excel Options\", and then going to the \"Advanced\" tab.  \n\nField Descriptions for In-Use Test Results: \n"]
{"$rows_empty":13}
[null,"Enter relevant information into the \"General Information\" section.  Subsequently, enter the engine family name at the top of the test results table, then fill out the following fields for each locomotive tested."]
[null,"Test Date","Enter the date the test was completed (mm/dd/yyyy)"]
[null,"Test Time","Enter the time the test was completed "]
[null,"Model#","Enter the model number, serial number and any relevant information on configuration for the locomotive tested."]
[null,"Serial#"]
[null,"Engine Configuration"]
[null,"Tier","Select the relevant Tier (1 through 4)"]
[null,"Cycle","Select the relevant cycle (Line Haul or Switch)"]
[null,"Build Date","Enter the original build date for the locomotive (mm/dd/yyyy)"]
[null,"Remanufacture Date (if applicable)","If the engine family is classified as \"remanufactured\", enter te date on which the locomotive was remanufactured."]
[null,"Usage (as of test date)","Enter the usage (in miles or MW-hrs) of the locomotive as of the test date.  "]
[null,"Useful Life (UL) ","Enter the useful life (in miles or MW-hrs) to which the locomotive was originally certified.  Note that the units associated with this value should be the same as the units for the usage data in the preceding field."]
[null,"Units for Usage & UL (MW-hrs or miles)","Select either MW-hrs or miles to indicate the relevant units for \"Usage\" and \"Useful Life\""]
[null,"Test Valid?","Select \"Yes\" if the test was valid or \"No\" if the test was excluded because the locomotive did not met the maintenance requirements of §1033.420 (see §1033.425(b)(1))."]
[null,"NOx Std/FEL","Enter the relevant standard (or FEL, if applicable) as well as the corresponding test results for any pollutants for which test results were required and conducted.  All standards, FELs, and test results should be expressed in g/bhp-hr.  "]
[null,"NOx Test Result"]
[null,"PM Std/FEL"]
[null,"PM Test Result"]
[null,"CO Std"]
[null,"CO Test Result"]
[null,"HC Std"]
[null,"HC Test Result"]
[null,"HC+NOx Std/FEL"]
[null,"HC+NOx Test Result"]
[null,"Comments","Enter any additional comments that are relevant to the in-use test result(s) being reported."]
[null,"Note:  Manufacturers must sign and submit the following statement along with their test results in accordance with §1033.425(a)(12):  \n\"We submit this report under sections 208 and 213 of the Clean Air Act.  Our in-use testing conformed completely with the requirements of 40 CFR part 1033.  All the information in this report is true and accurate to the best of my knowledge.  I know of the penalties for violating the Clean Air Act and the regulations.\" "]
[null,"Paperwork Reduction Act Notice"]
[null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 hours per response for manufacturers and 8 hours per response for remanufacturers.  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-435 to this address.\n",{"$nulls":13},"OMB No. 2060-0392"]
[{"$nulls":15},"Approval Expires on "]
[{"$nulls":15},"2018-08-31"]
[{"$nulls":15},"EPA Form  5900-435"]

{"sheet":"In-Use Test Results","index":2,"n_rows":102,"n_cols":25,"rows_kept":102,"cut":false,"hidden":false,"merged":[[18,18,18,19],[19,18,19,19],[31,24,31,25],[32,24,32,25],[33,24,33,25],[34,24,34,25],[35,24,35,25],[14,21,19,25],[25,24,25,25],[26,24,26,25],[27,24,27,25],[28,24,28,25],[29,24,29,25],[30,24,30,25],[16,18,16,19],[17,18,17,19],[1,0,1,26],[2,0,2,26],[3,0,3,26],[4,0,4,26],[5,0,5,26],[6,0,6,26],[37,0,37,26],[58,24,58,25],[10,3,10,5],[22,0,22,26],[14,3,15,5],[17,3,20,14],[11,3,11,5],[12,3,12,5],[13,3,13,5],[13,21,13,25],[52,0,52,26],[50,24,50,25],[55,24,55,25],[56,24,56,25],[57,24,57,25],[48,24,48,25],[49,24,49,25],[76,24,76,25],[77,24,77,25],[67,0,67,26],[73,24,73,25],[59,24,59,25],[60,24,60,25],[61,24,61,25],[62,24,62,25],[46,24,46,25],[47,24,47,25],[89,24,89,25],[90,24,90,25],[91,24,91,25],[92,24,92,25],[82,0,82,26],[88,24,88,25],[74,24,74,25],[75,24,75,25],[40,24,40,25],[41,24,41,25],[42,24,42,25],[43,24,43,25],[44,24,44,25],[45,24,45,25],[80,24,80,25],[85,24,85,25],[86,24,86,25],[87,24,87,25],[63,24,63,25],[64,24,64,25],[65,24,65,25],[70,24,70,25],[71,24,71,25],[72,24,72,25],[93,24,93,25],[94,24,94,25],[95,24,95,25],[24,2,24,3],[39,2,39,3],[54,2,54,3],[69,2,69,3],[84,2,84,3],[78,24,78,25],[79,24,79,25]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Manufacturer In-Use Testing Report for Locomotive Engines"]
["Last Revision: August 2018    Version Number: 1.1"]
[]
["General Information"]
[]
[null,"Manufacturer:"]
[null,"In-Use Test Contact:",{"$nulls":5},"Quarter:",null,"(optional)"]
[null,"Email Address:"]
[null,"Phone #:",{"$nulls":5},"Required Number of Test Results:",{"$nulls":13},"Paperwork Reduction Act Notice"]
[null,"Test Location & description:",{"$nulls":5},"Note: ","Per §1033.415(a)(1), test a minimum of 2 locomotives per engine family (test 2 additional locomotives for each failed test).  ",{"$nulls":12},"The public reporting and recordkeeping burden for this collection of information is estimated to average 17 hours per response for manufacturers and 8 hours per response for remanufacturers.  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 to this address."]
[{"$nulls":8},"Regardless of the number of passed or failed test results, do not exceed 10 tests per engine family."]
[{"$nulls":18},"OMB No. 2060-0392"]
[null,"Comments:",{"$nulls":16},"Approval Expires on "]
[{"$nulls":18},"2018-08-31"]
[{"$nulls":18},"EPA Form  5900-435"]
[]
[]
["In-Use Test Results - Engine Family #1"]
[]
[null,"Engine Family #1:"]
[null,"Test Date","Test Time","Model#","Serial#","Engine Configuration","Tier","Cycle","Build Date","Remanufacture Date \n(if applicable)","Usage\n(as of test date)","Useful Life (UL)","Units for Usage & UL\n(MW-hrs or miles)","Test Valid?","NOx Std/FEL","NOx Test Result","PM Std/FEL","PM Test Result","CO Std","CO Test Result","HC Std","HC Test Result","HC+NOx Std/FEL","HC+NOx Test Result","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["In-Use Test Results - Engine Family #2"]
[]
[null,"Engine Family #2:"]
[null,"Test Date","Test Time","Model#","Serial#","Engine Configuration","Tier","Cycle","Build Date","Remanufacture Date \n(if applicable)","Usage\n(as of test date)","Useful Life (UL)","Units for Usage & UL\n(MW-hrs or miles)","Test Valid?","NOx Std/FEL","NOx Test Result","PM Std/FEL","PM Test Result","CO Std","CO Test Result","HC Std","HC Test Result","HC+NOx Std/FEL","HC+NOx Test Result","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["In-Use Test Results - Engine Family #3"]
[]
[null,"Engine Family #3:"]
[null,"Test Date","Test Time","Model#","Serial#","Engine Configuration","Tier","Cycle","Build Date","Remanufacture Date \n(if applicable)","Usage\n(as of test date)","Useful Life (UL)","Units for Usage & UL\n(MW-hrs or miles)","Test Valid?","NOx Std/FEL","NOx Test Result","PM Std/FEL","PM Test Result","CO Std","CO Test Result","HC Std","HC Test Result","HC+NOx Std/FEL","HC+NOx Test Result","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["In-Use Test Results - Engine Family #4"]
[]
[null,"Engine Family #4:"]
[null,"Test Date","Test Time","Model#","Serial#","Engine Configuration","Tier","Cycle","Build Date","Remanufacture Date \n(if applicable)","Usage\n(as of test date)","Useful Life (UL)","Units for Usage & UL\n(MW-hrs or miles)","Test Valid?","NOx Std/FEL","NOx Test Result","PM Std/FEL","PM Test Result","CO Std","CO Test Result","HC Std","HC Test Result","HC+NOx Std/FEL","HC+NOx Test Result","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["In-Use Test Results - Engine Family #5"]
[]
[null,"Engine Family #5:"]
[null,"Test Date","Test Time","Model#","Serial#","Engine Configuration","Tier","Cycle","Build Date","Remanufacture Date \n(if applicable)","Usage\n(as of test date)","Useful Life (UL)","Units for Usage & UL\n(MW-hrs or miles)","Test Valid?","NOx Std/FEL","NOx Test Result","PM Std/FEL","PM Test Result","CO Std","CO Test Result","HC Std","HC Test Result","HC+NOx Std/FEL","HC+NOx Test Result","Comments"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
[{"$nulls":6},"Tier options",null,null,null,"Cycle","valid"]
[{"$nulls":6},1,null,null,null,"Line-Haul","Yes","MW-hrs"]
[{"$nulls":6},2,null,null,null,"Switch","No","miles"]
[{"$nulls":6},3]
[{"$nulls":6},4]

{"sheet":"Notes","index":3,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,1,1,14],[2,1,2,14],[3,1,3,14],[5,1,5,14],[65,12,65,13],[66,12,66,13],[63,12,63,13],[64,12,64,13],[6,1,6,14]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"US Environmental Protection Agency"]
[null,"Office of Transportation and Air Quality"]
[]
[null,"Manufacturer In-Use Testing Report for Locomotive Engines"]
[null,"Last Revision: August 2018    Version Number: 1.1"]
[]
[null,"Manufacturer Notes"]
{"$rows_empty":54}
[{"$nulls":12},"OMB No. 2060-0392"]
[{"$nulls":12},"Approval Expires on "]
[{"$nulls":12},"2018-08-31"]
[{"$nulls":12},"EPA Form  5900-435"]