5900-681 I_DERA Supplemental Application Template

Transportation and Climate Division (TCD) Grant Program Reporting Templates: Supplemental Project Application Template and Project Reporting Templates for DERA, CSB, CHD, and CP (New)

I_5900-681_DERA Supplemental Application Template_2025.03.28.xlsx

Private Sector

OMB: 2060-0754

Document [xlsx]
Download: xlsx | pdf

Overview

1. Instructions
2. Fleet Description
3. Infrastructure
4. Data Dictionary


Sheet 1: 1. Instructions

U. S. Environmental Protection Agency
Diesel Emissions Reduction Act (DERA) Grant Program
Supplemental Application Template
Burden Statement for EPA Form: 5900-681
This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-0754). Responses to this collection of information are voluntary (2 CFR 200 at 2 CFR 1500). 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 5.2-7.6 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.
Instructions
Per grant agreement terms and conditions, this reporting template should be submitted 1) quarterly (or biannually, depending on the grant's Terms and Conditions) throughout the project period of performance and 2) a Final Report (120-days after) the completion of the grant period. Information that is submitted on quarterly (or biannually, depending on the grant's Terms and Conditions) reports should NOT be changed in future quarterly (or biannually, depending on the grant's Terms and Conditions) report submissions unless approved by EPA. Please only update information for the specific quarter (or biannual, depending on the grant's Terms and Conditions) in which this report is being submitted. The grant recipient only needs to fill out shaded cells highlighted blue with a diagonal pattern (///). Cells highlighted orange are simply for informative purposes and/or automated from other tabs in this spreadsheet. Please complete tabs in this workbook according to the instructions below.
Note: This workbook uses a variety of conditional formatting, data validations, and cell protections. The protections are not locked with a password.
Excel Workbook Tab Definition
1. Instructions Basic instructions for all worksheets in this reporting workbook.
2. Fleet Description The tab should be completed based upon the proposed workplan fleet sheet submitted as part of the DERA application. Please refer to additional information on field definitions in tab 4 (Data Dictionary).
3. Infrastructure The tab should be completed based upon the proposed workplan submitted as part of the DERA application. Please refer to additional information on field definitions in tab 4 (Data Dictionary).
4. Data Dictionary Please refer to the dictionary on this tab for support in completing the Fleet Description (tab 2) and Infrastructure Description (tab 3).














































































































































































































































Sheet 2: 2. Fleet Description

U. S. Environmental Protection Agency























































































Diesel Emissions Reduction Act (DERA) Grant Program























































































Fleet Description


























































































































































































INSTRUCTIONS: This Fleet Description should detail all vehicles and engines impacted under the project. The fields below align with EPA's Diesel Emission Quantifier (DEQ), a requirement for the application, workplan, and final reports as part of program grant requirements. The Fleet Description should be updated quarterly with all vehicle and engine upgrades completed. This Fleet Description is broken into two sections: 1) Current Vehicle and Engine Information and 2) New Vehicle and Engine Upgrade Information. All rows of data are required, unless specified as not being applicable to the Equipment Type or Target Fleet. These exceptions are highlighted in parentheses in the table below. Please refer to the Fleet Description data definitions on tab 4 (Data Dictionary) for additional guidance on each field.
Each vehicle/engine group column below can represent one or more similar pieces of equipment operating in the same fleet. You can copy and paste additional columns as needed to capture all vehicle/engine groups. Please indicate in the Financial Information row the fiscal year of funds used for the activity described within the table.
Note: Individual marine vessels must be listed in separate vehicle/engine group columns. If both auxiliary and propulsion engines on an individual vessel are part of a project, these different engine types must be listed in separate vehicle/engine group columns.
*Fields that contain the symbol (*) will not populate dropdown options until preceding field is selected.



















































































































































































Table 1. CURRENT VEHICLE AND ENGINE INFORMATION
Table 2. NEW VEHICLE AND ENGINE UPGRADE INFORMATION




Table 1a. Basic Fleet Information


Table 1b. Current Vehicle Information








Table 1c. Current Engine Information













Table 1d. Current Annual Vehicle Activity Data Table 1e. Place of Performance











Table 2a. Upgrade Information Table 2b. Vehicle Replacement and/or Upgrade Information










Table 2c. New Engine Information (if replaced) Table 2d. New Annual Vehicle Activity Data



Table 2e. New Vehicle Battery Information (Hybrid & Battery Electric Only)






Table 2f. Battery Warranty Information


Table 2g. Powertrain Warranty Information

Table 2h. Optional Participation in Future of Transportation Research





































Primary Place of Performance Secondary Place of Performance (if applicable) Additional Location Details (if applicable)


















































Vehicle Group Name Fleet Owner Publicly or Privately Owned
(select from dropdown)
Equipment Type
(select from dropdown)
*Target Fleet
(select from dropdown)
Vehicle Class
(onroad vehicles, as defined in data dictionary)
Vehicle or Engine Group Sector Vocation Vehicle Identification Number (VIN)
(Use Capital Letters)
Vehicle Make Vehicle Model Baseline Vehicle Model Year Baseline Vehicle GVWR
(if original vehicle replaced)
Engine Serial Number(s) Engine Make Engine Model Engine Model Year Engine Tier
(nonroad, locomotive, and marine only)
Tier 4 Standards
(Tier 4 only)
Engine After-Treatment Technology
(Tier 4 nonroad only)
Engine Horsepower Engine Cylinder Displacement (liters/cylinder;
marine only)
Engine Number of Cylinders
(# of cylinders per engine; marine only)
Engine Total Displacement
(liters per engine; marine only)
Engine Family Name (if unregulated, then N/A) Baseline Engine Fuel Type
(select from dropdown)
Total # of Propulsion Engines
(per vessel;
marine only)
Total # of Auxiliary Engines
(per vessel;
marine only)
Annual Amount of Fuel Used (gallons/year per engine for nonroad and marine; gallons/year per vehicle for onroad and locomotives) Annual Usage Hours
(hours per year per engine; includes idling hours; nonroad, locomotive, and marine only)
Current Odometer
(in miles)
Annual Miles Traveled
(miles per vehicle; on-highway only)
Annual Idling Hours (hours per engine; on-highway only) Annual Hoteling Hours (hours per year per engine; class 8 long-haul combination only) Remaining Life of Baseline Engine/Vehicle
(years per engine; total # of years of engine life remaining at time of upgrade action)
State
(select from dropdown)
*County
(select from dropdown)
City(s) Percent of Time Operated in County
(enter value 0-1)
Zip Code(s) State
(select from dropdown)
*County
(select from dropdown)
City(s) Percent of Time Operated in County
(enter value 0-1)
Zip Code(s) Additional Counties where Vehicle Operates % of time operated in each Additional County
Year of Upgrade Action Upgrade Type
(select from dropdown)
*Upgrade Specific
(select from dropdown after selecting Upgrade Type)
Class
(onroad vehicles, as defined in data dictionary; select from dropdown)
Vehicle Identification Number (VIN) for New Vehicle
(if original vehicle replaced)
(Use Capital Letters)
New Vehicle Fuel Type
(if original vehicle replaced; select from dropdown)
New Vehicle Manufacturer
(if original vehicle replaced)
New Vehicle Model
(if original vehicle replaced)
New Vehicle Model Year
(if original vehicle replaced)
New Vehicle GVWR
(if original vehicle replaced)
Upgrade or Replacement Vehicle/Equipment Cost only Per Unit Upgrade Labor Cost only Per Unit Total Cost Per Unit
(equipment plus labor)
Total Federal Funds Expended Per Unit
($ of Total Cost per Unit)
Federal Cost Share Expended Per Unit
(% of Total Cost per Unit)
New Engine Model Year New Engine Serial Number New Engine Tier
(nonroad, locomotive, and marine only)
Tier 4 Standards
(Tier 4 only)
New Engine After-Treatment Technology
(Tier 4 nonroad only)
New Engine Horsepower New Engine Duty Cycle
(line-haul locomotive only)
New Engine Cylinder Displacement
(liters per cylinder per engine; marine only)
New Engine Total Displacement
(liters per engine; marine only)
New Engine Number of Cylinders
(per engine; marine only)
New Engine Family Name New Engine Fuel Type
(select from dropdown)
New Annual Idling Hours
(hours per vehicle; on-highway only)
New Annual Hoteling Hours
(hours per vehicle; class 8 long-haul combination only)
New Annual Fuel Volume (estimated gallons of fuel/year per engine for new gas, diesel, hybrid, LPG or CNG) New Vehicle Equipped with Auxiliary Heater? (Yes/No) Auxiliary Heater Type
(if applicable)
Capable of Bidirectional Charging? (if Battery Electric or Hybrid) Manufacturer of Battery Pack Number of Battery Packs Battery Capacity per Battery Pack (kWh) Vehicle or Equipment Total Battery Capacity, (kWh) Rated Charging Power (kW) Estimated Range in Miles
(for Onroad Battery Electric only)
Estimated Range in Hours (for Nonroad Battery Electric only) Is the Battery Warranty Included?
(for Battery Electric only)
Battery Warranty: Indicate Number of Years Covered
(for Battery Electric only)
Battery Warranty: Number of Miles Covered by Warranty
(for Battery Electric only)
Battery Warranty: Total kWh of battery discharge Covered by Warranty
(for Battery Electric only)
Powertrain Warranty Included? (Yes/No) Powertrain Warranty: Number of Years
(if included)
Powertrain Warranty: Number of Miles
(if included)
Is the vehicle/equipment equipped with Telematics? (Yes/No/Not Sure) EPA or its partners may contact me about participating in research opportunities to provide vehicle/equipment data that could inform future transportation work. (Yes/No) If Yes, Telematics Primary Point of contact (Name and email)
Example Vehicle Sample Company A Publicly Owned Onroad Transit Bus Class 6 Municipal Other 1234567891011 Ford Taurus 1994 16,001 4548154 ABC ABC 1995 Tier 2 N/A No DPF, Yes SCR 660 5.0 <= size <15.0 N/A N/A N/A ULSD (diesel) N/A N/A 6000 3000 150000 12000 1500 N/A 3 AZ Maricopa County Phoenix 85% 85364 AZ Yuma County Yuma 15% 85364 Pima County, AZ; La Paz County, AZ 5% in Pima; 5% in La Paz
2018 Emission_Control_Devices Diesel Oxidation Catalyst + Diesel Particulate Filter Class 6 1234567890ABCDE Hybrid New Vehicle Manufacturer Co. Model Name or # 2023 16001 $150,000.00 $25,000.00 $175,000.00 $50,000.00 28.57% 2018 4548155 Tier 2 N/A No DPF, Yes SCR 750 N/A 5.0 <= size <15.0 N/A N/A ABC ULSD (diesel) N/A N/A 6000 Yes Spheros Thermo 300 Yes Battery & Co. 6 90 540 360 200 16 Yes 8 150000 200000 Yes 5 100000 Yes Yes Sarah Smith; Smith.Sarah@HSD.edu
Vehicle 1
































































































Vehicle 2
































































































Vehicle 3
































































































Vehicle 4
































































































Vehicle 5
































































































Vehicle 6
































































































Vehicle 7
































































































Vehicle 8
































































































Vehicle 9
































































































Vehicle 10
































































































Vehicle 11
































































































Vehicle 12
































































































Vehicle 13













































































`

















Vehicle 14
































































































Vehicle 15
































































































Vehicle 16
































































































Vehicle 17
































































































Vehicle 18
































































































Vehicle 19
































































































Vehicle 20
































































































Vehicle 21
































































































Vehicle 22
































































































Vehicle 23
































































































Vehicle 24
































































































Vehicle 25
































































































Vehicle 26
































































































Vehicle 27
































































































Vehicle 28
































































































Vehicle 29
































































































Vehicle 30
































































































Vehicle 31
































































































Vehicle 32
































































































Vehicle 33
































































































Vehicle 34
































































































Vehicle 35
































































































Vehicle 36
































































































Vehicle 37
































































































Vehicle 38
































































































Vehicle 39
































































































Vehicle 40
































































































Vehicle 41
































































































Vehicle 42
































































































Vehicle 43
































































































Vehicle 44
































































































Vehicle 45
































































































Vehicle 46
































































































Vehicle 47
































































































Vehicle 48
































































































Vehicle 49
































































































Vehicle 50
































































































Vehicle 51
































































































Vehicle 52
































































































Vehicle 53
































































































Vehicle 54
































































































Vehicle 55
































































































Vehicle 56
































































































Vehicle 57
































































































Vehicle 58
































































































Vehicle 59
































































































Vehicle 60
































































































Vehicle 61
































































































Vehicle 62
































































































Vehicle 63
































































































Vehicle 64
































































































Vehicle 65
































































































Vehicle 66
































































































Vehicle 67
































































































Vehicle 68
































































































Vehicle 69
































































































Vehicle 70
































































































Vehicle 71
































































































Vehicle 72
































































































Vehicle 73
































































































Vehicle 74
































































































Vehicle 75
































































































Vehicle 76
































































































Vehicle 77
































































































Vehicle 78
































































































Vehicle 79
































































































Vehicle 80
































































































Vehicle 81
































































































Vehicle 82
































































































Vehicle 83
































































































Vehicle 84
































































































Vehicle 85
































































































Vehicle 86
































































































Vehicle 87
































































































Vehicle 88
































































































Vehicle 89
































































































Vehicle 90
































































































Vehicle 91
































































































Vehicle 92
































































































Vehicle 93
































































































Vehicle 94
































































































Vehicle 95
































































































Vehicle 96
































































































Vehicle 97
































































































Vehicle 98
































































































Vehicle 99
































































































Vehicle 100

































































































Sheet 3: 3. Infrastructure

U. S. Environmental Protection Agency


























































Diesel Emissions Reduction Act (DERA) Grant Program


























































Infrastructure Description
































































































































Instructions


























































The EVSE Equipment Information (Table 3) should detail all electric vehicle supply equipment (EVSE) and/or supporting infrastructure (Table 4) purchased under the project. Please only fill out shaded cells highlighted blue with a diagonal pattern (///); however, additional rows may be add as needed to capture all equipment. Please refer to the infrastructure data definitions on Tab 4 (Data Dictionary) for data field definitions. Reminder: All Level 2 EVSEs must be ENERGY STAR certified. All EVSE and other infrastructure projects must comply with Build America, Buy America (BABA) requirements. See below for more information on BABA.
































































































































Build America, Buy America (BABA) requirements


























































On November 16, 2021, the Infrastructure Investment and Jobs Act ("IIJA"), Pub. L. No. 116-58, which includes the Build America, Buy America Act (BABA), Public Law 116-58, §§ 70901-52, was signed into law. BABA requires that on or after May 14, 2022, all of the iron, steel, manufactured products, and construction materials used in infrastructure project are produced in the United States. If award recipient will be installing, upgrading, or replacing “infrastructure,” then BABA requirements apply to the infrastructure project, regardless of whether or not the infrastructure project was the primary basis for the award. Additionally, BABA requirements apply even if the award recipient will be using another source of funding, whether in part or wholly, for the infrastructure project. For more information, please visit https://www.epa.gov/cwsrf/build-america-buy-america-baba.
































































































































Table 3: Electric Vehicle Supply Equipment Information




































































  Table 3a. EVSE Equipment Information Overview















Table 3b. Location of EV Infrastructure





Table 3c. Charging Management Service Providers

Table 3d. Infrastructure Installation Information





Table 3e. EVSE Cost Summary

Table 3f. Optional Participation in Future of Transportation Research
Table 3g. EVSE Serial Number




























  Type of Charger If Level 2, is it ENERGY STAR certified EVSE Manufacturer EVSE Model EVSE Manufacture Year Is the EVSE BABA Compliant? EVSE Maximum Output Power (kW) Number of Plugs on EVSE Is the EVSE Capable of Bidirectional Charging? Will the Vehicle/Equipment and EVSE be Used for Vehicle to Grid (V2G)? Number of EVSE Units EVSE Equipment Cost only Per Unit: Total Federal Funds Expended Per EVSE Unit Total Federal Funds Expended for EVSE Date of EVSE was Manufactured (mm/dd/yyyy) Date of EVSE Installation (mm/dd/yyyy) Date EVSE Operational
(mm/dd/yyyy)
State
(select from dropdown)
County
(select from dropdown)
City Zip Code Street Adress of Charger(s) Who owns the charger? Anticipated User(s) of the charger Name of Charging Management Service Provider (NA if not applicable) Does the Infrastructure Equipment Cost Include Charging Management Service?
(Yes/No)
If Charging Management Service not included in cost, but is acquired, what is the cost and frequency of charges? Total Funds Expended on Installation Cost Total EPA Funds Expended on Installation Cost Does the Infrastructure Equipment Cost Include Installation? Description of Installation Work Installation Work Performed By Installation was conducted by an individual who meets the infrastructure electrician requirements as outlined in the program guidance? Is waiver being used to fulfill BABA compliance for this infrastructure? Total EPA Funds Expended on EVSE Equipment and Installation Total Funds Expended on EVSE Equipment and Installation Federal Cost Share Expended Per Unit
(% of Total Cost per EVSE)
EPA or its partners may contact me about participating in research opportunities to provide EVSE data that could inform future transportation work. (Yes/No) If Yes, Telematics Primary Point of contact (Name and email) Serial Number: Unit 1 Serial Number: Unit 2 Serial Number: Unit 3 Serial Number: Unit 4 Serial Number: Unit 5 Serial Number: Unit 6 Serial Number: Unit 7 Serial Number: Unit 8 Serial Number: Unit 9 Serial Number: Unit 10 Serial Number: Unit 11 Serial Number: Unit 12 Serial Number: Unit 13 Serial Number: Unit 14 Serial Number: Unit 15 Serial Number: Unit 16 Serial Number: Unit 17 Serial Number: Unit 18 Serial Number: Unit 19 Serial Number: Unit 20 Serial Number: Unit 21 Serial Number: Unit 22 Serial Number: Unit 23 Serial Number: Unit 24 Serial Number: Unit 25 Serial Number: Unit 26 Serial Number: Unit 27 Serial Number: Unit 28 Serial Number: Unit 29 Serial Number: Unit 30
Example EV Infrastructure Level 2 Yes Manufacturer Name Model Name 2023 Yes - This Infrastructure is BABA Compliant 24 2 No No 2 $18,000.00 $12,000.00 $24,000.00 3/28/2024 6/28/2024 8/28/2024 VA Arlington County Alexandria 22305 400 1st Street Walton School District Electric school buses serving Walton School District Charge Manage & Co. Yes $250 per charger per month $12,000.00 $7,000.00 No Upgrades to the electrical panel, wiring, and installation for two DCFC XYZ Electric Co. Yes - Certification from EVITP No - Infrastructure meets all BABA requirements $31,000.00 $48,000.00 65% Yes  Sarah Smith, Smith.Sarah@hsd.edu L1-0357-ISO-3240-049390 VX-1263-11C1-2-2310-05642 170182509830170 9124-1GT05-09830170 VX-1265-11C1-2-2635-07842 VX-1264-11C1-2-2502-05872 VX-1266-11C1-2-2502-05642 VX-1267-11C1-2-2502-15426 VX-1268-11C1-2-2503-96834 9125-1GT27-0983253 VX-1269-11C1-2-2502-05872 VX-1270-11C1-2-2502-05872 VX-1271-11C1-2-2502-05872 VX-1272-11C1-2-2502-05872 VX-1273-11C1-2-2502-05872 VX-1274-11C1-2-2502-05872 VX-1275-11C1-2-2502-05872 VX-1276-11C1-2-2502-05872 VX-1277-11C1-2-2502-05872 VX-1278-11C1-2-2502-05872 VX-1279-11C1-2-2502-05872 VX-1280-11C1-2-2502-05872 VX-1281-11C1-2-2502-05872 VX-1282-11C1-2-2502-05872 VX-1283-11C1-2-2502-05872 VX-1284-11C1-2-2502-05872 VX-1285-11C1-2-2502-05872 VX-1286-11C1-2-2502-05872 VX-1287-11C1-2-2502-05872 VX-1288-11C1-2-2502-05872
EVSE Group 1
   
 


   






   
   

 


   
   



 





























EVSE Group 2          


   





     
   

 


   
   


   





























EVSE Group 3            

   





     
   





   
   


   





























EVSE Group 4            

   





     
   





   
   


   





























EVSE Group 5            

   





     
   





   
 



   





























EVSE Group 6            

   





     
   





   
   


   





























EVSE Group 7            

   





     
   





   
   


   





























EVSE Group 8            

   





     
   





   
   


   





























EVSE Group 9            

   





     
   





   
   


   





























EVSE Group 10            

   





     
   





   
   


   



































































































Table 4: Shore Power Information





























  Table 4a. Shore Power Equipment Information & Demand Overview Table 4b. Location of Shore Power Infrastructure Table 4c. Installation Details Table 4d. Shore Power BABA Details Table 4e. Shore Power Cost Summary Table 4f. Optional Participation in Future of Transportation Research Table 4g. Shore Power Serial Number




























  Type of Shore Power Connection Total Voltage Service Provided
(select from dropdown)
Total Voltage Service Provided, if not listed Manufacturer Model Manufacture Year Typical Engine Tier of Vessels Using Shore Power Fuel Type of Vessels Using Shore Power Number of Annual Vessel Calls to Berth where Shore Power Installed Average Hotel Hours per Vessel Call per Berth where Shore Power Installed Number of Vessel Berths that can be served by Shore Power Pedestal Maximum Output Power (kW) Estimated Annual Total Energy Provided in MW-h Number of Plugs per Shore Power Pedestal Number of Shore Power Pedestals State
(select from dropdown)
County
(select from dropdown)
City Zip Code Port Facility where Shore Power Installed Who owns the Shore Power Infrastructure? Total Funds Expended Installation Cost for Shore Power Group Total Federal Funds Expended Installation Cost for Shore Power Group Does the Infrastructure Equipment Cost Include Installation? Description of Installation Work, including all equipment installed Installation Work Performed By Date(s) Shore Power Equipment was Manufactured (mm/dd/yyyy) Date Equipment Installed Date Equipment Fully Operational Is waiver being used to fulfill BABA compliance for this infrastructure? Are the Shore Power Equipment, Housing, and all Accessories BABA Compliant? If No, Partly Compliant, or Unsure, explain Equipment Cost only Per Shore Power Pedestal: Total Federal Funds Expended Per Shore Power Pedestal Total Federal Funds Expended for All Shore Power Equipment
(total # of pedestals x Federal Funds Expended/pedestal)
Federal Cost Share Expended For Shore Power Equipment Federal Cost Share for Shore Power Installation EPA or its partners may contact me about participating in research opportunities to provide EVSE data that could inform future transportation work. (Yes/No) If Yes, Telematics Primary Point of contact (Name and email) Serial Number: Unit 1 Serial Number: Unit 2 Serial Number: Unit 3 Serial Number: Unit 4 Serial Number: Unit 5 Serial Number: Unit 6 Serial Number: Unit 7 Serial Number: Unit 8 Serial Number: Unit 9 Serial Number: Unit 10 Serial Number: Unit 11 Serial Number: Unit 12 Serial Number: Unit 13 Serial Number: Unit 14 Serial Number: Unit 15 Serial Number: Unit 16 Serial Number: Unit 17 Serial Number: Unit 18 Serial Number: Unit 19 Serial Number: Unit 20 Serial Number: Unit 21 Serial Number: Unit 22 Serial Number: Unit 23 Serial Number: Unit 24 Serial Number: Unit 25 Serial Number: Unit 26 Serial Number: Unit 27 Serial Number: Unit 28 Serial Number: Unit 29 Serial Number: Unit 30
Example Shore Power Infrastructure High voltage shore power connection (HVSC) 6.6 kV 10 kV Manufacturer Name Model Name 2023 Tier 1 Marine Gas Oil (MGO, 0.10% S) 500 72 1 24 1 MW-h 2 2 VA Arlington County Alexandria 22305 Port of Guam Port of Guam $120,000.00 $70,000.00 No Upgrades to the electrical panel, wiring, and installation for two DCFC XYZ Electric Co. 5/25/2023 6/24/2024 8/24/2024 No - Infrastructure meets all BABA requirements Yes - Housing, Wiring, Cables, and All Accessories are BABA Compliant
$18,000.00 $12,000.00 $24,000.00 67% 58% Yes  Sarah Smith, Smith.Sarah@hsd.edu L1-0357-ISO-3240-049390 VX-1263-11C1-2-2310-05642 170182509830170 9124-1GT05-09830170 VX-1265-11C1-2-2635-07842 VX-1264-11C1-2-2502-05872 VX-1266-11C1-2-2502-05642 VX-1267-11C1-2-2502-15426 VX-1268-11C1-2-2503-96834 9125-1GT27-0983253 VX-1269-11C1-2-2502-05872 VX-1270-11C1-2-2502-05872 VX-1271-11C1-2-2502-05872 VX-1272-11C1-2-2502-05872 VX-1273-11C1-2-2502-05872 VX-1274-11C1-2-2502-05872 VX-1275-11C1-2-2502-05872 VX-1276-11C1-2-2502-05872 VX-1277-11C1-2-2502-05872 VX-1278-11C1-2-2502-05872 VX-1279-11C1-2-2502-05872 VX-1280-11C1-2-2502-05872 VX-1281-11C1-2-2502-05872 VX-1282-11C1-2-2502-05872 VX-1283-11C1-2-2502-05872 VX-1284-11C1-2-2502-05872 VX-1285-11C1-2-2502-05872 VX-1286-11C1-2-2502-05872 VX-1287-11C1-2-2502-05872 VX-1288-11C1-2-2502-05872
Shore Power Group 1


     









   
   

   



 



$-


 





























Shore Power Group 2


     








     
   

   



 



$-


 





























Shore Power Group 3


     








     
   

   



 



$-

   





























Shore Power Group 4


     








     
   

   



 



$-

   





























Shore Power Group 5


     








     
   

   



 



$-

   





























Shore Power Group 6


     








     
   

   



 



$-

   





























Shore Power Group 7


     








     
   

   



 



$-

   





























Shore Power Group 8


     








     
   

   



 



$-

   





























Shore Power Group 9


     









   
   

   



 



$-

   





























Shore Power Group 10


     








     
   

   



 



$-

   









































































































































































Are there any other infrastructure projects associated with this grant that are not listed above (e.g. electrified parking space, stationary generator or other stationary equipment)? (Y or N)



























































If no, please leave this section blank. If yes, please provide details in the box below on the infrastructure project and describe how BABA compliance was determined.









































































































































































































































































































































































Sheet 4: 4. Data Dictionary

Fleet Description Data Fields: Please refer to the following data field dictionary for support in completing tab 2 (Fleet Description).
CURRENT VEHICLE AND ENGINE UPGRADE INFORMATION
Basic Fleet Information
Group Name Enter the group name of the fleet.
Fleet Owner Enter the first and last name of the individual or organization that owns the fleet.
Publicly or Privately Owned? If the vehicles are part of a public fleet or benefit the public (i.e. a private school bus company contracted by a public school; drayage vehicles that serve a port; private construction equipment contracted to a public works project, etc.) enter "Publicly", otherwise enter "Privately".
Place of Performance Enter the next four fields for each vehicle's place(s) of performance.
- State(s): Enter the two letter postal code for the state in which the vehicle(s) will operate.
- County(s): Enter the county in which the vehicle(s) will operate.
- City(s): Enter the city in which the vehicle(s) will operate.
- Zip Code(s): Enter the zip code which the vehicle(s) will operate.
- % of Time operated in each Zip Code (Total to Equal 100%) Enter the percent of time the vehicle group operates in each zip code, if there is more than one. For example, 80% of time in 85310 and 20% of time in 85308.
Equipment Type Enter the vehicle type from the dropdown, OnRoad Vehicle, NonRoad Equipment, Locomotive, or Marine.
Target Fleet Select the target fleet from the dropdown menu.
Class Select from the dropdown menu the Vehicle/Equipment Class for onroad vehicles, as appropriate.
Vehicle or Engine Group Sector: Using the drop down, enter the sector associated with the vehicle or engine group.
Vocation Select the vocation type from the dropdown menu.
Current Vehicle Information
Vehicle Identification Number(s): Enter the Serial number or VIN number for each engine or vehicle
Vehicle Make Enter the manufacturer of the existing vehicle
Vehicle Model Enter the model of the existing vehicle
Baseline Vehicle Model Year: Enter the model year of the existing vehicle.
Current Engine Information
Engine Serial Number(s) : Enter the engine Serial # for each vehicle or engine to be scrapped/replaced.
Engine Make: Enter the manufacturer of the existing Engine.
Engine Model: Enter the model of the existing Engine.
Engine Model Year: Enter the model year of this engine set.
Engine Tier (nonroad, locomotive, and marine only): For REPOWERS AND UPGRADES ONLY, Select from the dropdown menu the Current Tier Level.
Tier 4 Standards (Tier 4 only): For tier 4 only engines, please use the drop down to indicate interim for final.
Engine After-Treatment Technology Enter the appropriate drop down for collection on emission control technologies for the current engine.
Engine Horsepower: Enter the average horsepower of the engine/equipment.
Engine Cylinder Displacement (liters/cylinder; marine only): Enter the engine displacement per cylinder in liters.
Engine Number of Cylinders (# of cylinders per engine): Enter the number of cylinders per engine.
Engine Total Displacement (liters per engine; marine only) Enter the engine displacement per cylinder in liters.
Engine Family Name (if unregulated, then NA): Enter the Engine Family name of the existing Engine. NOTE: unregulated engines will not have an Engine Family Name. Engine Optional for Idle Reduction, Aerodynamic Technology, Low Rolling Resistance Tires, and Fuels projects.
Baseline Engine Fuel Type: Select the type of fuel that is currently being used (prior to any clean diesel activity change).
Total # of Propulsion Engines (per vessel; marine only): Enter the total number of propulsion engines on the vessel.
Total # of Auxiliary Engines (per vessel; marine only): Enter the total number of auxiliary engines on the vessel.
Current Annual Vehicle Data
Annual Amount of Fuel Used (gallons/year per engine): Enter the amount of fuel used in gallons/year.
Annual Usage Hours (hours per year per engine; includes idling hours; nonroad, locomotive, and marine only) Enter the average number of hours the equipment is used per year.
Annual Miles Traveled (miles per vehicle; on-highway only): Enter the average number of vehicle miles traveled per year per vehicle.
Annual Idling Hours (hours per engine; on-highway only): Enter the average number of hours the vehicle idles per year.
Annual Hoteling Hours (hours per year per engine; class 8 long-haul combination only): Enter the average number of hoteling hours per year, per engine.
Remaining Life of Baseline Engine/Vehicle (years per engine; total # of years of engine life remaining at time of upgrade action): Enter the remaining life of baseline engine/vehicle in years at the time of the upgrade action
NEW VEHICLE AND ENGINE UPGRADE INFORMATION
Upgrade Information
Year of Upgrade Action: Enter the year in which the upgrade will take place (i.e., if in 2010, you're replacing a 1995 bus with a 2007 bus, the upgrade year is 2010.)
Upgrade Type: Enter the type of upgrade that will take place from the dropdown menu.
Upgrade Specific: Using the drop down, enter the specific type of upgrade that will take place during the project.
Class (onroad vehicles): Using the drop down list provided, select the appropriate vehicle class (for onroad vehicles only).
VIN for New Vehicle(s): Please enter the vehicle identification numbers for the new vehicle(s) being replaced.
Total Cost per Unit (equipment cost plus labor): Automated cell that will sum the upgrade equipment cost (row 55) and labor cost (row 56).
Upgrade Equipment Cost only per unit: Enter the cost of the technology or equipment cost per unit.
Upgrade Labor Cost only per unit: Enter the cost of installing or labor cost of the technology per unit.
Total Federal Funds Expended per Unit ($ Total Cost per Unit): Enter the federal funds expended in dollars per unit.
Federal Cost Share Expended per Unit (% Total Cost per Unit): Automated cell that will calculate the federal cost share based upon the federal funds expended entered in row 57.
New Engine Information
New Engine Model Year: For REPLACEMENTS AND REPOWERS ONLY, Enter the model year of the new vehicle/engine.
New Engine Tier (nonroad, locomotive, and marine only): For REPLACEMENTS, REPOWERS AND UPGRADES ONLY, Select from the dropdown menu the new Tier Level.
Tier 4 Standards (Tier 4 only): For tier 4 only engines, please use the drop down to indicate interim for final.
New Engine After-Treatment Technology (Tier 4 nonroad only): Enter the appropriate drop down for collection on emission control technologies for the new engine.
New Engine Horsepower: Enter the new horsepower of the engine or equipment.
New Engine Duty Cycle (line-haul locomotive only): Please enter the new engine duty cycle - for line-haul locomotive ONLY.
New Engine Cylinder Displacement (liters per cylinder per engine; marine only): Enter the new engine displacement per cylinder in liters.
New Engine Total Displacement (liters per engine; marine only) Select from the dropdown menu the displacement per cylinder in liters.
New Engine Number of Cylinders (per engine; marine only): Enter the number of cylinders in the new engine.
New Engine Family Name: For REPLACEMENTS AND REPOWERS ONLY, Enter the Engine Family Name of the new engine.
New Engine Fuel Type: Select the type of fuel that is for the new engine or vehicle.
New Annual Vehicle Data
Annual Idling Hours Reduced (hours per vehicle; on-highway only): For IDLE REDUCTION STRATEGIES ONLY, Enter the average number of idling hours reduced for the engine.
Annual Hoteling Hours Reduced (hours per vehicle; class 8 long-haul combination only): Enter the average number of hoteling hours per year, per engine.
New Annual Fuel Volume (estimated gallons/year per engine): Please enter the new annual fuel volume, in gallons. New Annual Fuel Volume should be from new engine efficiency, not changes in use.
Zero Emission Vehicle Data
Capable of Bidirectional Charging? (if Battery Electric or Hybrid) Select yes or no into the cell to specify whether the vehicle is capable of bidirectional charging.
Estimated Range in Miles (for Onroad Battery Electric only) Enter the estimated range in miles for the zero-emission vehicle.
Battery Capacity per Battery Packs (kWh) (for ZEV only) Enter the battery capacity in kilowatt-hours for the zero-emission vehicle.
Is the Battery Warranty Included? (for Battery Electric only) Select yes or no into the cell to specify whether the vehicle battery warranty is included.
Battery Warranty: Indicate Number of Years Covered (for Battery Electric only) If the battery includes a warranty, indicate the number of years the coverage is valid for.
Battery Warranty: Indicate Number of Years Covered (for Battery Electric only) If the battery includes a warranty, indicate the number of miles the coverage is valid for.
Battery Warranty: Total kWh of battery discharge Covered by Warranty (for Battery Electric only) If the battery includes a warranty, indicate the total kWh of battery discharge the coverage is valid for.
Powertrain Warranty Included? Select yes or no into the cell to specify whether a powertrain battery warranty is included.
Powertrain Warranty: Number of Years If the powertrain includes a warranty, indicate the number of years the coverage is valid for.
Powertrain Warranty: Number of Miles If the powertrain includes a warranty, indicate the number of miles the coverage is valid for.
Is the vehicle/equipment equipped with Telematics? Select yes or no into the cells it specify whether the vehicle is equipped with telematics.
EPA or its partners may contact me about participating in research opportunities to provide vehicle/equipment data that could inform future transportation work. Select yes or no.
If Yes, Telematics Primary Point of contact (Name and email) Enter First and Last name and email address.
10. INFRASTRUCTURE
EVSE Equipment Information
Type of Charger Enter the type of charger, either Level 2 (AC charging up to 19.2 kW) or DC Fast Charging.
If Level 2, is it ENERGY STAR certified Confirm and select yes if applicable. Please see https://www.energystar.gov/
EVSE Manufacturer Enter the manufacturer of the charging equipment
EVSE Model Enter the model name of the charging equipment.
EVSE Manufacture Year Enter the year the charging equipment was manufactured.
Is the EVSE BABA Compliant? Select an option. EVSE manufactured on or after July 1, 2024 must be meet BABA requirements.
EVSE Maximum Output Power (kW) Enter the maximum power output of the charging equipment, measured in kilowatts.
Number of Plugs on EVSE Enter the number of plugs installed on each unit of the charging equipment.
Is the EVSE Capable of Bidirectional Charging? Select yes or no into the cell to specify whether the charging equipment is capable of bidirectional charging.
Will the Bus and EVSE be Used for V2G? Select yes or no into the cell to specify whether the buses and charging equipment will be used for vehicle-to-grid (V2G) services.
EVSE Number of Units Enter the quantity of charging equipment unit
EVSE Equipment Cost only Per Unit: Enter the cost of the charging equipment per unit.
Total Federal Funds Expended Per EVSE Unit Enter the total Federal funds expend for charging equipment per unit.
Total Federal Funds Expended for EVSE No action - autopopulated
Date of EVSE Installation (mm/dd/yyyy) Enter the date on which the EVSE is permanently affixed.
Location of EV Infrastructure
State Select the two letter postal code for the state in which the charging equipment will be located.
County Enter the county in which the charging equipment will be located.
City Enter the city in which the charging equipment will be located.
Zip Code Enter the zip code in which the charging equipment will be located.
Street Adress Enter the street address in which the charging equipment will be located.
Who owns the charger? Enter the name of the school district or organization that owns the charging equipment.
Does the EVSE serve multiple school districts within this application? Select yes or no
Name of the School District(s) the EVSE will serve (use a colon between school districts) Enter the name of the school district in which the EVSE will serve. If it will serve multiple school districts, list all and separate with a colon (e.g., Hampton School District: Edgewood School District).
NCES ID of School District that the EVSE will serve (use a colon between school districts) Enter the name of the National Center for Education Statistics (NCES) ID associated with the school district in which the EVSE will serve. If it will serve multiple school districts, list all NCES IDs and separate with a colon (e.g., 1234567: 7654321).
Infrastructure Installation Information
Total Funds Expended Installation Cost Enter the total installation costs for the charging equipment for the EV infrastructure group column.
Total Federal Funds Expended Installation Cost Enter the total Federal funds expended for installation costs for the charging equipment for the EV infrastructure group column.
Does the Infrastructure Equipment Cost Include Installation? Please enter yes or no into the cell to specify whether the indicated cost of the charging equipment above includes any installation expenses.
Description of Installation Work Enter a description of the work performed to install the charging equipment, such as design and engineering, trenching, wiring and electrical upgrades, labor, and permitting.
Installation Work Performed By Enter the name(s) of the organization(s) that performed the installation work described above.
Installation was conducted by an individual who meets the infrastructure electrician requirements as outlined in the program guidance? Select electrician category
Is waiver being used to fulfill BABA compliance for the Infrastructure Project If a waiver is being used to meet BABA compliance requirements, select the waiver type
Total Federal Funds Expended Equipment and Installation Automated cell that will calculate the total Federal Funds expended for the charging equipment and installation for an EV Infrastructure Group.
Shore Power Equipment Information and Demand Overview
Type of Shore Power Connection Select the type of shore power connection, either high-voltage (HVSC) or low-voltage (LVSC).
Total Voltage Service Provided Select the total voltage provided from the dropdown menu, if listed.
Total Voltage Service Provided, if Not Listed Enter the total voltage service provided if the amount is not listed in the dropdown menu.
Manufacturer Enter the manufacturer of the shore power system.
Model Enter the model name of the shore power system.
Manufacture Year Enter the year the shore power system was manufactured.
Typical Engine Tier of Vessels Using Shore Power Select the typical engine tier of vessels using the shore power system.
Fuel Type of Vessels Using Shore Power Select the fuel type of vessels using the shore power system.
Number of Annual Vessel Calls to Berth where Shore Power Installed Enter the number of annual vessel calls per berth where the shore power system is installed.
Number of Vessel Berths that can be served by Shore Power Pedestal Enter the number of vessel berths that can be served by the shore power system.
Maximum Output Power (kW) Enter the maximum power output of the shore power system, measured in kilowatts.
Estimated Annual Total Energy Provided in MW-h Enter the estimated total annual energy output of the shore power system in megawatt-hours.
Number of Plugs per Shore Power Pedestal Enter the number of available plugs per shore power pedestal installed.
Number of Shore Power Pedestals Enter the total number of shore power pedestals installed.
Location of Shore Power Infrastructure
State (select from dropdown) Select the state where the shore power system is installed.
County (select from dropdown) Select the county where the shore power system is installed.
City Enter the name of the city where the shore power system is installed.
Zip Code Enter the zip code of the location where the shore power system is installed.
Port Facility where Shore Power Installed Enter the name of the port facility where the shore power system is installed.
Who owns the Shore Power Infrastructure? Enter the name of the organization that owns the shore power system.
Installation Details
Total Funds Expended Installation Cost for Shore Power Group Enter the total cost for installation of the shore power system.
Total Federal Funds Expended Installation Cost for Shore Power Group Enter the total amount of federal funds expended for installation of the shore power system.
Does the Infrastructure Equipment Cost Include Installation? Select whether or not the equipment cost includes installation of the shore power system.
Description of Installation Work, including all equipment installed Describe the work done during installation, including all equipment that became part of the installed shore power system.
Installation Work Performed By List the name of the company (or companies) performing the installation of the shore power system.
Date Equipment Installed Enter the date (or date range) the shore power system was installed.
Date Equipment Fully Operational Enter the date by which the shore power system became fully operational.
Is waiver being used to fulfill BABA compliance for this infrastructure? Select from the dropdown menu how BABA requirements are being met for the shore power project.
Are the Shore Power Equipment, Housing, and all Accessories BABA Compliant? Select from the dropdown menu which parts of the shore power project are BABA compliant.
If No, Partly Compliant, or Unsure, explain For the previous column, explain which parts are not compliant or enter N/A.
Shore Power Cost Summary
Equipment Cost only Per Shore Power Pedestal: Enter the equipment cost for each shore power pedestal.
Total Federal Funds Expended Per Shore Power Pedestal Enter the federal funds expended for the equipment in each shore power pedestal.
Total Federal Funds Expended for All Shore Power Equipment
(total # of pedestals x Federal Funds Expended/pedestal)
No action - autopopulated
Federal Cost Share Expended For Shore Power Equipment No action - autopopulated
Federal Cost Share for Shore Power Installation No action - autopopulated
Optional Participation in Future Transportation Research
EPA or its partners may contact me about participating in research opportunities to provide shore power data that could inform future transportation work. (Yes/No) Select from the dropdown menu if EPA or its partners may contact you regarding shore power research.
If Yes, Primary Point of contact (Name and email) If you selected "Yes" for the previous column, please enter your name and e-mail.
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy