{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Instructions","Installation Audits"],"not_rendered":{"charts":0,"images":2,"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":"Instructions","index":0,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,0,1,15],[2,0,2,15],[3,0,3,15],[5,0,5,15],[56,1,60,13],[55,1,55,13],[6,0,6,15],[40,1,40,5],[41,1,41,5],[42,1,42,5],[14,18,15,18],[34,0,34,15],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[36,6,36,15],[37,6,37,15],[38,6,38,15],[39,6,39,15],[43,1,43,5],[44,1,44,5],[45,1,45,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[52,1,52,5],[48,6,48,15],[49,6,49,15],[50,6,50,15],[51,6,51,15],[52,6,52,15],[49,1,49,5],[50,1,50,5],[10,1,32,15],[42,6,42,15],[43,6,43,15],[44,6,44,15],[45,6,45,15],[51,1,51,5],[40,6,40,15],[41,6,41,15],[46,6,46,15],[47,6,47,15]],"flags":["formulas_cached_only"]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Air and Radiation, Office of Transportation and Air Quality"]
[]
["Installation Audit Report for Locomotives (§1033.335)"]
["Last Revision: August 2018  Version Number: 1.1.1"]
[]
["Installation Audit Submissions -- INSTRUCTIONS "]
[]
[null,"An important component of the Locomotive Part 1033 requirements is the Installation Audit Program (40 CFR §1033.335).  Manufacturers must audit the remanufacture of locomotives covered by their certificates of conformity for proper components, component settings and component installations on randomly selected locomotives in an engine family.  EPA has created an Excel-based template to help standardize the process by which manufacturers submit the results of these audits.\n\nThe 16 fields included in the Installation Audits worksheet are described below.   Manufacturers must document that all emission related components on a remanufactured locomotive are properly installed and are set to the proper specifications.  Audits performed by the owners/operators of the locomotives are acceptable provided they are performed in accordance with the provisions of 1033.335 (affidavits for these audits may be requested by EPA staff).  \n\nThe first five fields at the top of the worksheet pertain to general information including:  Model Year, Manufacturer, Total Annual Production, Audit Sample Size, and Location and Description of Audit Facilities.  The 11 columns in the main table require additional data entry or input from the manufacturer for each engine family being audited.  The “Field Descriptions” worksheet contains detailed notes on each of the 16 fields in the Installation Audits worksheet, including a description of the required data or information, how the data should be entered, the existence of any drop-down menus, and any other information that would be relevant to that field (including whether the field is dependent on preceding entries in the spreadsheet).\n\nIn accordance with 40 CFR 1033.335(b), manufacturers must audit at least five percent of the annual production per model year per installer, or ten per engine family per installer, whichever is less.  Also, in accordance with 40 CFR 1033.335(e) if a remanufactured locomotive fails an audit, then two additional locomotives must be audited from the next ten remanufactured in that engine family by that installer.\n"]
{"$rows_empty":23}
["Field Descriptions "]
[]
[null,"Field",{"$nulls":4},"Description"]
[null,"Model Year",{"$nulls":4},"Enter the 4-digit model year."]
[null,"Manufacturer",{"$nulls":4},"Enter the Manufacturer."]
[null,"Total Annual Production",{"$nulls":4},"Enter the total annual production for all engine families."]
[null,"Audit Sample Size",{"$nulls":4},"Enter the audit sample size.  In accordance with 40 CFR 1033.335(b), manufacturers must audit at least five percent of the annual production per model year per installer, or ten per engine family per installer, whichever is less. "]
[null,"Location and Description of Audit Facilities",{"$nulls":4},"The location and description of your audit facilities which were utilized to conduct auditing."]
[null,"Engine Family",{"$nulls":4},"Enter the 12-character engine family name or test group name.  "]
[null,"Tier",{"$nulls":4},"Use the drop-down to select Tier 1, Tier 2, Tier 3, or Tier 4."]
[null,"Configuration",{"$nulls":4},"Describe the configuration of the audited locomotive."]
[null,"Model/Make",{"$nulls":4},"Enter the model and/or make of the audited locomotive."]
[null,"Build Date",{"$nulls":4},"Enter the build date of the audited locomotive."]
[null,"Remanufacture Date",{"$nulls":4},"Enter the remanufacture date of the audited locomotive."]
[null,"Locomotive ID#",{"$nulls":4},"Enter the locomotive identification number."]
[null,"Engine ID#",{"$nulls":4},"Enter the engine identification number."]
[null,"Audit #",{"$nulls":4},"Enter the audit number.  Assign a unique number for each individual audit (sequentially)."]
[null,"Pass/Fail",{"$nulls":4},"Use the drop-down to select Pass or Fail."]
[null,"Comments",{"$nulls":4},"This field may be used to enter in any additional information regarding special circumstances or characteristics associated with the installation audit.  "]
[]
[]
[null,"Paperwork Reduction Act Notice"]
[null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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 to this address."]

{"sheet":"Installation Audits","index":1,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,11],[2,1,2,11],[3,1,3,11],[5,1,5,11],[10,2,10,3],[11,2,11,3],[9,1,9,11],[6,1,6,11],[67,4,71,4],[67,6,67,10],[68,6,68,10],[10,5,10,10],[11,5,13,10],[14,1,14,11],[12,2,12,3],[13,2,13,3]],"flags":["formulas_cached_only"]}
[]
[null,"United States"]
[null,"Environmental Protection Agency",{"$nulls":12},"Tier 1"]
[null,"Office of Air and Radiation, Office of Transportation and Air Quality",{"$nulls":12},"Tier 2","Pass "]
[{"$nulls":14},"Tier 3","Fail"]
[null,"Installation Audit Report for Locomotives (§1033.335)",{"$nulls":12},"Tier 4"]
[null,"Last Revision: August 2018  Version Number: 1.1.1"]
[]
[null,"Installation Audit Summary "]
[null,"This template may be used to document that all emission related components on a remanufactured locomotive are properly installed on the locomotive and are set to the proper specification.  Audits performed by the owners/operators of the locomotives are acceptable provided they are performed in accordance with the provisions of 1033.335 (affidavits for these audits may be requested by EPA staff)."]
[null,"MODEL YEAR:",null,null,null,"Location & Description of Audit Facilities"]
[null,"Manufacturer:"]
[null,"Total Annual Production:"]
[null,"Audit Sample Size*:"]
[null,"*NOTE:  In accordance with 40 CFR 1033.335(b), audit at least five percent of your annual production per model year per installer, or ten per engine family per installer, whichever is less.   \n              Also, in accordance with 40 CFR 1033.335(e) if a remanufactured locomotive fails an audit, then you must audit two additional locomotives from the next ten remanufactured in that engine family by that installer."]
[null,"Engine Family","Tier","Configuration","Model/Make","Build Date","Remanufacture Date","Locomotive ID#","Engine ID#","Audit #","Pass/Fail","Comments"]
{"$rows_empty":51}
[{"$nulls":4},"OMB No. 2060-0287\nApproval Expires on\n3/31/2023\nEPA Form 5900-273\n",null,"Paperwork Reduction Act Notice"]
[{"$nulls":6},"The public reporting and recordkeeping burden for this collection of information is estimated to average 30 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 to this address."]