5900-689 CHDV 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)

K_5900-689_CHDV Supplemental Application Template.xlsx

OMB: 2060-0754

Document [xlsx]
Download: xlsx | pdf

Overview

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


Sheet 1: 1. Instructions_App

U. S. Environmental Protection Agency
Clean Heavy-Duty Vehicles (CHDV) Grant Program
Supplemental Application Template
Burden Statement for EPA Form Number: 5900-690
This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-NEW). 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 7.2 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
This supplemental application template should be completed and submitted as part of the application materials for the Clean Heavy-Duty Vehicles Grant Program. Please work with relevant parties (i.e., transportation contractor, bus dealer, etc.) to ensure information submitted is as accurate as feasible at the time of application. The applicant must fill out shaded cells highlighted blue with a diagonal pattern (///) to the best of their ability. Cells highlighted yellow are automatically populated based on previous responses in this spreadsheet. Fields shaded in white are encouraged, but may not be known at the time of application. Additionally, some fields will hash out with a bold diagonal pattern (///) if those fields are not applicable based on the information provided in previous cells. Please complete tabs in this workbook according to the instructions below.
Excel Workbook Tab Definition
1. Instructions Basic instructions for all worksheets in this reporting workbook.
2. Fleet Description The Fleet Description tab should detail all vehicles impacted under the project. The Fleet Description should be completed at the time of application; if selected, awardees will update this table quarterly with all vehicle upgrades completed. The applicant must fill out shaded cells highlighted blue with a diagonal pattern (///) to the best of their ability. Fields in yellow will be automatically populated based on previous responses. Fields shaded in white are encouraged, but may not be known at the time of application. Additionally, some fields will hash out with a bold diagonal pattern (///) if those fields are not applicable based on the information provided in previous cells This Fleet Description is broken into two sections: 1) Current Vehicle Information and 2) New Vehicle Upgrade Information. The sheet has capacity for 100 vehicles. Please refer to the Fleet Description data definitions on tab 4 (Data Dictionary) for additional guidance on each field.
3. Infrastructure The Infrastructure tab should detail all electric vehicle supply equipment (EVSE) and other eligible supporting infrastructure planned as part of the project; if selected, awardees will update these tables be updated quarterly as EVSEs and other infrastructure are procured and installed. The applicant must fill out shaded cells highlighted blue with a diagonal pattern (///) to the best of their ability. Fields in yellow will be automatically populated based on previous responses. Fields shaded in white are encouraged, but may not be known at the time of application. Additionally, some fields will hash out with a bold diagonal pattern (///) if those fields are not applicable based on the information provided in previous cells. Additional rows may be add as needed to capture all units of supporting infrastructure. 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, and all infrastructure must comply with Build America, Buy America (BABA) requirements.
4. Data Dictionary Please refer to the dictionary on this tab for support in completing the Fleet Description and Infrastructure Tabs.














































































































































































































































Sheet 2: 2. Fleet Description

U. S. Environmental Protection Agency





















































Clean Heavy-Duty Vehicles (CHDV) Grant Program





















































Fleet Description























































































































Applicant Name






























































SAM.gov Unique Entity ID






























































Project Title
































































































































Instructions





















































The Fleet Description should detail all vehicles anticipated to be replaced under the project and, to the extent details are known at this time, all replacement vehicles that will be purchased using Clean Heavy-Duty Grants funding. Please fill out shaded cells highlighted blue with a diagonal pattern (///) to the best of your ability. Fields in yellow will be automatically populated based on previous responses. Finally, fields shaded in white are highly encouraged, but optional, as these data may not be known at the time of application. This Fleet Description is broken into two sections: 1) Current Vehicle Information and 2) New Vehicle Upgrade Information. The sheet has capacity for 100 vehicles. Please refer to the Fleet Description data definitions on tab 4 (Data Dictionary) for additional guidance on each field.
























































































































Table 1. CURRENT VEHICLE INFORMATION





































Table 2. NEW REPLACEMENT VEHICLE INFORMATION


























1a. Basic Fleet Information

1b. Current Vehicle Information









1c. Current Vehicle Activity Information



1d. Vehicle Disposition Process

1e. Current Vehicle Place(s) of Performance














2a. Upgrade Vehicle Information







2b. Upgrade Cost
[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: @Harrison, Sarah (she/her/hers) Should census track info from CEJST be added to the template? Reply: No, based on ongoing discussions with NOFO development and with OAR & OEJECR, we are sticking to a county-scale place of performance given the large geographic area over which projects are implemented and over which emissions avoided might accrue (e.g., counties) Reply: Perfect! One last question. Do you need to capture data related to the categories of burden at all? 2c. New Vehicle Place(s) of Performance





































Primary Place of Performance





Secondary Place of Performance (if applicable)




Additional Location Details (if applicable)











Primary Place of Performance





Secondary Place of Performance (if applicable)





Additional Location Details (if applicable)











































optional, but highly encouraged if known*

















Vehicle Group Name Current Fleet Owner Publicly or Privately Owned
(select from dropdown)
Vehicle Type
(select from dropdown)
Vehicle Class
(select from dropdown)
Vehicle Vocation
(select from dropdown)
Vehicle Group Sector
(select from dropdown)
Vehicle Identification Number Vehicle Manufacturer Vehicle Model Baseline Vehicle Model Year Baseline Engine Fuel Type
(select from dropdown)
Engine Family Name
(if unregulated, then enter N/A)
GVWR Annual Miles Traveled (miles per vehicle) Annual Idling Hours (hours per engine) [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Do we care about this? What will we do with this data? Reply: It's captured in DERA and percolated through to CHDV. If it's not needed, we can strike Current Odometer
(in miles)
Annual Amount of Fuel Used (gallons/year per engine) Remaining Life of Baseline Engine/Vehicle [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: I think this field could be kept optional Reply: Does CHDV require scrappage? If not required, are there bonus points for doing so? Reply: We will likely be requiring scrappage as it is worded in the statute as a vehicle replacement program. I might have missed the word "anticipated" earlier when I reviewed this, I was thinking that if it is model year 2010 or older and they have the option to donate or sell, they might not know which one they are planning to do yet. But I think we could actually still keep this as required, understanding that with the "anticipated" language the disposition method may change as they get further into their project Reply: Removed "Waiver" option, and replaced with state and county where sold or donated vehicle will operate (if known) Anticipated Vehicle Disposition Method If sold or donated, provide the state in which the vehicle is expected to primarily operate (if known) If sold or donated, provide the county in which the vehicle is expected to primarily operate (if known) School District Name
(if applicable)
NCES ID
(if applicable)
State
(select from dropdown)
County
(select from dropdown)
Percentage of Time operated in County Place of Performance: City [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: would it be useful to specify a specific way to separate multiple zip codes? (comma, semicolon?) and same thing for other columns where they can include multiple zip codes Reply: May be good to ask Stacie if there's a specific format that is best for GDIT Zip Code(s) School District Name
(if applicable)_2
NCES ID
(if applicable)_2
State_2 County_3 Percentage of Time operated in County_2 Place of Performance: City_3 Zip Code(s)_2 Additional Counties where Vehicle Operates % of time operated in each Additional County Year of Upgrade Action New Vehicle Fleet Owner [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Maybe make this optional as well? I'm thinking of cases where a vehicle type might be on the cusp of vehicle class sizes and variations between model types may keep it as class 6 or push it into class 7? If they don't know exactly what vehicle they are purchasing, they might not know this Reply: I think we can still ask them to provide this, knowing that it's not binding. Would be good to get a sense of if they're scaling up, down, or trying to keep it the same New Vehicle Class
(select from dropdown)
New Vehicle Fuel Type New Vehicle Manufacturer
(if known)
New Vehicle Model
(if known)
New Vehicle GVWR
(if known)
Capable of Bidirectional Charging? (Yes/No/NA) Estimated Range in Miles [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Can make this optional as they might not have concrete vehicle prices at the time of application Reply: They should have an estimate, as listed in their proposed budget, even if this number will likely change once actually purchased Upgrade Cost per Vehicle Total Federal Funds Expended Per Vehicle ($ of Total Cost per Unit) School District Name
(if applicable)_3
NCES ID
(if applicable)_3
State
(select from dropdown)_3
County
(select from dropdown)_3
Percentage of Time operated in County_2
(Enter value between 0-1, where 1 = 100%)

City
Zip Code(s)2 School District Name
(if applicable)2
NCES ID
(if applicable)2
State
(select from dropdown)2
[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Some weird formatting thing is happening where I can't remove the 2? Reply: This is because the entire page is an Excel Table, which can't have duplicate names. To get around this, I can either redo the entire table to not be an Excel Table or I can work some font size/color magic to hide the 2? County
(select from dropdown)2
Percentage of Time operated in County_3
(enter value 0-1, where 1 = 100%)
City_4 Zip Code(s)_4 Additional Counties where Vehicle Operates_2 % of time operated in each Additional County_2
Example Vehicle ESBs for District A Sarah Smith Publicly Owned Short Haul - Single Unit Class 6 Drayage Port 12345678910ABCDEFG Manufacturer Name Model Name or # 1995 Diesel N/A 10150 140000 12000 1500000 6000 3 Scrapped CA Alameda County Warren 01 123456 SC Warren 100% Springhill 123456 Warren 01 123456 SC Warren 100% Springhill 123456

2025 Walton School District Class 6 Battery Electric Manufacturer Name Model Name or # 12000 Yes 200 $375,000.00 $325,000.00 Warren 01 123456 SC Warren 100% Springhill 123456 Warren 01 123456 SC Warren 100% Springhill 123456 Pima County, AZ; La Paz County, AZ 5% in Pima; 5% in La Paz
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

















Clean Heavy-Duty Vehicles (CHDV) Grant Program

















EV Infrastructure Description














































Instructions

















Below are three tables (Table 3, Table 4, and Table 5), and an additional text field. Please complete all 4. The EVSE Equipment Information (Table 3) should detail all electric vehicle supply equipment (EVSE) and supporting infrastructure purchased under the project. Table 4 focuses on on-site power generation systems and Table 5 on battery storage systems. For school district applicants the infrastructure needs to be listed by school district and/or city. That is, if School District A and School District B are procuring the same EVSE, the EVSE will appear as two separate EVSE Groups. Similarly, for large school districts, if EVSE are being installed in two different locations, the EVSE needs to appear as two separate EVSE Groups. The EV Infrastructure worksheet should be updated quarterly as EVSEs and supporting infrastructure are procured and installed. Please fill out shaded cells highlighted blue with a diagonal pattern (///) to the best of your ability. Note, additional rows may be added as needed to capture all equipment. Fields in yellow will be automatically populated based on previous responses. Finally, fields shaded in white are highly encouraged, but optional, as these data may not be known at the time of application. Please refer to the EV Infrastructure data definitions on Tab 4 (Data Dictionary) for data field definitions. Reminder: All Level 2 EVSEs must be ENERGY STAR certified. All EVSE, on-site power generation systems, and battery energy storage systems (BESS) must comply with Build America, Buy America (BABA) requirements. See below for more information on BABA.














































Build America, Buy America (BABA) requirements

















On November 15, 2021, the Infrastructure Investment and Jobs Act ("IIJA"), Pub. L. No. 117-58, which includes the Build America, Buy America Act (BABA), Public Law 117-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.

















Do you attest that you have read the BABA requirements described above?






















































Table 3. Electric Vehicle Service Equipment



























  Table 3a. EVSE Equipment Information Overview











Table 3b. Location of EV Infrastructure



Table 3c. Owners & Anticipated Users of EVSE Table 3d. Infrastructure Installation Information

Table 3e. EVSE Cost Summary


optional, but highly encouraged if known*















optional, but highly encouraged if known*

  [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: I think columns B-G should be optional, if they don't already know their vehicle model, they would not know this information Reply: Agree that C-G can move to optional; I'd like to keep Type of Charger to help us at least count how many chargers/if they are asking for chargers at all. Would you be opposed to including another dropdown option that says "Not known at this time"? Type of Charger If Level 2, is it ENERGY STAR certified EVSE Manufacturer EVSE Model EVSE Manufacture Year EVSE Maximum Output Power (kW) Number of Plugs on EVSE Will the EVSE Be Capable of Bidirectional Charging? Will the Vehicle and EVSE be Used for Vehicle to Grid (V2G)? Number of EVSE Units [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: similar to bus costs, they might not know this, so this could be optional. or at least if we want them to provide something, make it clear that it can be their best estimate given the info they currently have if they don't have exact prices in front of them Reply: Opting to leave here, based on Kayla's comments on vehicle costs. It's not binding, but it will help us gauge the reasonableness of budget EVSE Equipment Cost only Per Unit Total EPA Funds Expended Per EVSE Unit Total EPA Funds Expended for EVSE State
(Select from dropdown)
County
(Select from dropdown)
City Zip Code Street Adress Who will own the charger? Anticipated User(s) of the charger [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: could add N/A as an option to the dropdown here Reply: Done! And updated the conditional formatting to align with the input of this field (if NA, then columns Z and AA for that row will hatch out) If serving school districts, will the EVSE serve multiple school districts within this project? Name of the School District(s) the EVSE will serve
(if applicable; use a semicolon between school districts)
NCES ID of School District that the EVSE will serve
(if applicable; use a semicolon between school districts)
[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: they also may not know this or at least have an exact number at the time of application, so I think this could possibly also be optional Reply: Opting to leave here, based on Kayla's comments on vehicle costs. It's not binding, but it will help us gauge the reasonableness of budget Total Funds Expended Installation Cost Total EPA Funds Expended Installation Cost [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: if they don't have their chargers solidified, they may not know this so this could be optional Does the Infrastructure Equipment Cost Include Installation? Total EPA Funds Expended on EVSE Equipment and Installation Total Funds Expended on EVSE Equipment and Installation
Example EV Infrastructure Level 2 Yes Manufacturer Name Model Name 2023 24 2 No No 2 $16,000.00 $12,000.00 $24,000.00 VA Arlington County Alexandria 22305 400 1st Street Walton School District Electric school buses serving Walton School District Yes Walton School District; Franklin School District 1234567; 7654321 $12,000 $7,000 No $31,000.00 $44,000.00
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                  


$-      
   
     

 

EVSE Group 11                  


$-      
   
     

 

EVSE Group 12                  


$-      
   
     

 

EVSE Group 13                  


$-      
   
     

 

EVSE Group 14                  


$-      
   
     

 

EVSE Group 15                  


$-      
   
     

 

EVSE Group 16                  


$-      
   
     

 

EVSE Group 17                  


$-      
   
     

 

EVSE Group 18                  


$-      
   
     

 

EVSE Group 19                  


$-      
   
     

 

EVSE Group 20                  


$-      
   
     

 

EVSE Group 21                  


$-      
   
     

 

EVSE Group 22                  


$-      
   
     

 

EVSE Group 23                  


$-      
   
     

 

EVSE Group 24                  


$-      
   
     

 

EVSE Group 25                  


$-      
   
     

 

EVSE Group 26                  


$-      
   
     

 

EVSE Group 27                  


$-      
   
     

 

EVSE Group 28                  


$-      
   
     

 

EVSE Group 29                  


$-      
   
     

 

EVSE Group 30                  


$-      
   
     

 



























































Note: If the on-site power generation includes an energy storage system, information for such system needs to be documented in the table below this one. 



























Table 4. On-Site Power Generation Equipment




























Table 4a. On-Site Power Generation Equipment Information Overview









4b. Location of On-site Power Generation Infrastructure



4c. Ownership and Use of On-Site Power Generation Infrastructure


4d. BABA Compliance








optional, but highly encouraged if known*














optional, but highly encouraged if known*







Type of energy generation Manufacturer of On-site Power Generation Model of On-site Power Generation Manufacture Year of On-site Power Generation Generation Capacity of the system (please indicate kW or MW) Equipment Cost only Per Power Generation System Total EPA Funds Expended Per Power Generation System Total Funds Expended Installation Cost Total EPA Funds Expended Installation Cost Total Funds Expended Equipment and Installation Total EPA Funds Expended Equipment and Installation State County City Zip Code Street Adress Who owns the equipment? Anticipated Users of On-Site Power Generation Infrastructure If serving school districts, Name of the School District(s) the On-site Power Generation will serve If serving school districts, NCES ID of School District that the On-site Power Generation will serve Is a waiver being used to fulfill BABA compliance for the On-site Power Generation?






Example On-site Power Generation Solar Manufacturer Name Model Name 2023 15 kW $45,000.00 $45,000.00 $7,000.00 $5,000.00 $52,000.00 $50,000.00 VA Arlington County Alexandria 22305 400 1st Street Walton School District Walton School District & NoVA Community College Walton School District 1234567 No - Infrastructure meets all BABA requirements






On-site Power Generation 1








$- $-








 






On-site Power Generation 2








$- $-








 






On-site Power Generation 3








$- $-








 






On-site Power Generation 4








$- $-








 






On-site Power Generation 5








$- $-








 






On-site Power Generation 6








$- $-








 






On-site Power Generation 7








$- $-








 






On-site Power Generation 8








$- $-








 






On-site Power Generation 9








$- $-








 






On-site Power Generation 10








$- $-








 
































































Table 5. Battery Energy Storage System (BESS) Equipment Information




























5a. BESS Overview









5b. Location of BESS Infrastructure



5c. Ownership and Use of BESS Infrastructure


5d. BABA Compliance








optional, but highly encouraged if known*














optional, but highly encouraged if known*







Type of Battery Manufacturer of BESS Model of BESS Manufacture Year of BESS Energy Capacity (please indicate kWh or MWh) Equipment Cost only Per Unit: Total Federal Funds Expended Per Unit Total Funds Expended Installation Cost Total Federal Funds Expended Installation Cost: Total Funds Expended Equipment and Installation Total EPA Funds Expended Equipment and Installation State County City Zip Code Street Adress Who owns the equipment? Anticipated Users of BESS If serving school districts, Name of the School District the BESS will serve If serving school districts, NCES ID of School District that the BESS will serve Is a waiver being used to fulfill BABA compliance for the BESS?






BESS Example Lithium-Ion Manufacturer Name Model Name 2023 36kWh $48,000.00 $20,000.00 $12,000.00 $10,000.00 $60,000.00 $30,000.00 VA Arlington County Alexandria 22305 400 1st Street Walton School District Walton School District & NoVA Community College Walton School District 1234567 No - Infrastructure meets all BABA requirements






BESS Group 1








$- $-
















BESS Group 2








$- $-
















BESS Group 3








$- $-
















BESS Group 4








$- $-
















BESS Group 5








$- $-
















BESS Group 6








$- $-
















BESS Group 7








$- $-
















BESS Group 8








$- $-
















BESS Group 9








$- $-
















BESS Group 10








$- $-













































Are there any other infrastructure projects associated with this grant that are not listed above? (Y or N or N/A)


















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 tabs 2 & 3
Tab 2. Fleet Description
Table 1. CURRENT VEHICLE INFORMATION
1a. Basic Fleet Information
Group Name
Current Fleet Owner
Publicly or Privately Owned (select from dropdown)
1b. Current Vehicle Information
Vehicle Type (Select from dropdown) Select the vehicle type from the dropdown menu; options include: Long Haul - Single Unit, Long Haul - Combination, Short Haul - Single Unit, Short Haul - Combination, Refuse Hauler, School Bus, and Transit Bus
Vehicle Class (Select from dropdown) Select Vehicle Class from dropdown menu: Class 6, Class 7
Vehicle Vocation (select from dropdown) Select Vehicle Vocation from dropdown menu: Delivery, Drayage, Emergency, Long Haul, Other, Refuse Hauler, School Bus, Shuttle Bus, Transit Bus, Utility
Vehicle Group Sector (select from dropdown) Select Vehicle Group Sector from dropdown menu: Agriculture, Airport, Construction, Freight, Industrial, Mining, Municipal, Port, Railyard, School Bus
Vehicle Identification Number Enter the VIN number for each vehicle.
Vehicle Manufacturer 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.
Baseline Engine Fuel Type (select from dropdown) Select the type of fuel that is currently being used (prior to upgrade); options include: USLD (diesel), Biodiesel 5, Biodiesel 20, CNG (ft3), CNG (lbs), LNG, LPG/Propane, Gasoline
Engine Family Name Enter the Engine Family name of the existing Engine. NOTE: unregulated engines will not have an Engine Family Name. If unregulated, then NA
1c. Current Vehicle Activity Information
GVWR Enter the gross vehicle weight rating (GVWR) of the existing vehicle.
Annual Miles Traveled Enter the average number of vehicle miles traveled per year per vehicle.
Annual Idling Hours Enter the average number of hours the vehicle idles per year.
Odometer Enter the existing vehicle's current odometer reading, in miles.
Annual Amount of Fuel Used Enter the amount of fuel used in gallons/year.
Remaining Life of Baseline Vehicle Enter the remaining life of baseline engine/vehicle in years at the time of the upgrade action.
1d. Vehicle Disposition Process
Anticipated Vehicle Disposition Method Select a vehicle disposition option from dropdown menu; options include: Scrapped, Sold, Donated
If sold or donated, provide the state in which the vehicle is expected to primarily operate (if known) Select the state from the dropdown menu. Note: the state field is required to enter the specific county field.
If sold or donated, provide the county in which the vehicle is expected to primarily operate (if known) Select the county from the dropdown menu. Note: the list of counties will not populate until the state is selected.
1e. Current Vehicle Place of Performance
Primary Place of Performance
School District Name (if applicable) Enter the name of the school district in which the vehicle to be scrapped, sold, or donated has operated in.
NCES ID (if applicable) Enter the name of the National Center for Education Statistics (NCES) ID associated with the school district in which the vehicle to be scrapped, sold, or donated has operated in. If you are unsure of the district's NCES ID, you can search for the district at https://nces.ed.gov/ccd/districtsearch/.
State (select from dropdown) Select the two letter postal code for the state from the dropdown menu in which the vehicle to be scrapped, sold, or donated has operated in. Note: the state field is required to enter the specific county field.
County (select from dropdown) Enter the county in which the vehicle to be scrapped, sold, or donated has operated. Note: the list of counties will not populate until the state is selected.
Percentage of Time operated in County Enter a value from 0 to 1, where 1 = 100%, to reflect the estimated percentage of time this vehicle operated in the listed county.
Place of Performance: City Enter the city in which the vehicle to be scrapped, sold, or donated has operated in.
Zip Code(s) Enter the zip codes where the vehicle operates; if there is more than one, separate using a semicolon (ex: 12345; 98765)
Secondary Place of Performance (if applicable)
School District Name (if applicable) Enter the name of the school district in which the vehicle to be scrapped, sold, or donated has operated in.
NCES ID (if applicable) Enter the name of the National Center for Education Statistics (NCES) ID associated with the school district in which the vehicle to be scrapped, sold, or donated has operated in. If you are unsure of the district's NCES ID, you can search for the district at https://nces.ed.gov/ccd/districtsearch/.
State (select from dropdown) Select the two letter postal code for the state from the dropdown menu in which the vehicle to be scrapped, sold, or donated has operated in. Note: the state field is required to enter the specific county field.
County (select from dropdown) Enter the county in which the vehicle to be scrapped, sold, or donated has operated. Note: the list of counties will not populate until the state is selected.
Percentage of Time operated in County Enter a value from 0 to 1, where 1 = 100%, to reflect the estimated percentage of time this vehicle operated in the listed county.
Place of Performance: City Enter the city in which the vehicle to be scrapped, sold, or donated has operated in.
Zip Code(s) Enter the zip codes where the vehicle operates; if there is more than one, separate using a semicolon (ex: 12345; 98765)
Additional Location Details (if applicable)
Additional Counties where Vehicle Operates List the county name and state for additional counties where the vehicle operates; if there are more than one, separate using a semicolon (e.g., St. Lucie County, FL; Martin County, FL)
% of time operated in each Additional County List the estimated percent of time operated in each additional county; if there are more than one, separate using parenthesis and semicolons (e.g., St. Lucie County (10%); Martin County (5%))
Table 2. New Replacement Vehicle Information
2a. Upgrade Vehicle Information
Year of Upgrade Action: Enter the year the upgrade is anticipated to happen.
New Vehicle Fleet Owner Enter the name of the new vehicle fleet owner
New Vehicle Class (select from dropdown) Select Vehicle Class from dropdown menu: Class 6, Class 7
New Vehicle Fuel Type: Select the fuel type of the new vehicle.
New Vehicle Manufacturer: Enter the manufacturer of the new vehicle.
New Vehicle Model: Enter the model of the new vehicle.
New Vehicle GVWR: Enter the gross vehicle weight rating (GVWR) of the new vehicle.
Capable of Bidirectional Charging? (Yes/No/NA)
Estimate Range in Miles Enter the estimated range in miles for the zero-emission vehicle.
2b. Upgrade Vehicle Information
Upgrade Cost per Bus Enter the cost of vehicle in dollars per unit.
Total EPA Funds Expended Per Vehicle Enter the EPA funds expended per vehicle in dollars per unit.
2c. New Vehicle Place(s) of Performance
Primary Place of Performance
School District Name (if applicable) Enter the name of the school district in which the new vehicle is expected to operate in.
NCES ID (if applicable) Enter the name of the National Center for Education Statistics (NCES) ID associated with the school district in which the new vehicle is expected to operate in. If you are unsure of the district's NCES ID, you can search for the district at https://nces.ed.gov/ccd/districtsearch/.
State (select from dropdown) Select the two letter postal code for the state from the dropdown menu in which the new vehicle is expected to operate in. Note: the state field is required to enter the specific county field.
County (select from dropdown) Enter the county in which the new vehicle is expected to operate in. Note: the list of counties will not populate until the state is selected.
Percentage of Time operated in County Enter a value from 0 to 1, where 1 = 100%, to reflect the estimated percentage of time this vehicle is expected to operate in the listed county.
Place of Performance: City Enter the city in which the new vehicle is expected to operate in
Zip Code(s) Enter the zip codes where the vehicle operates; if there is more than one, separate using a semicolon (ex: 12345; 98765)
Secondary Place of Performance (if applicable)
School District Name (if applicable) Enter the name of the school district in which the new vehicle is expected to operate in.
NCES ID (if applicable) Enter the name of the National Center for Education Statistics (NCES) ID associated with the school district in which the new vehicle is expected to operate in. If you are unsure of the district's NCES ID, you can search for the district at https://nces.ed.gov/ccd/districtsearch/.
State (select from dropdown) Select the two letter postal code for the state from the dropdown menu in which the new vehicle is expected to operate in. Note: the state field is required to enter the specific county field.
County (select from dropdown) Enter the county in which the new vehicle is expected to operate in. Note: the list of counties will not populate until the state is selected.
Percentage of Time operated in County Enter a value from 0 to 1, where 1 = 100%, to reflect the estimated percentage of time this vehicle is expected to operate in the listed county.
Place of Performance: City Enter the city in which the new vehicle is expected to operate in
Zip Code(s) Enter the zip codes where the vehicle operates; if there is more than one, separate using a semicolon (ex: 12345; 98765)
Additional Location Details (if applicable)
Additional Counties where Vehicle Operates List the county name and state for additional counties where the vehicle operates; if there are more than one, separate using a semicolon (e.g., St. Lucie County, FL; Martin County, FL)
% of time operated in each Additional County List the estimated percent of time operated in each additional county; if there are more than one, separate using parenthesis and semicolons (e.g., St. Lucie County (10%); Martin County (5%)
Tab 3. INFRASTRUCTURE
Table 3. Electric Vehicle Service Equipment
3a. EVSE Equipment Information Overview
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.
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 vehicles and charging equipment will be used for vehicle-to-grid (V2G) services.
Number of EVSE Units Enter the quantity of charging equipment unit acquisition.
EVSE Equipment Cost only Per Unit: Enter the cost of the charging equipment per unit acquisition.
Total EPA Funds Expended Per EVSE Unit Enter the total EPA funds expended for charging equipment per unit acquisition.
Total EPA Funds Expended for EVSE Autopopulated field: This field multiplies the number of EVSE units by the Total EPA Funds Expended per EVSE Unit to calculate the total of EPA funds expended for EVSE acquisition
3b. Location of EV Infrastructure
State (select from dropdown) Select the two letter postal code for the state from the dropdown menu in which the new vehicle is expected to operate in. Note: the state field is required to enter the specific county field.
County (select from dropdown) Enter the county in which the new vehicle is expected to operate in. Note: the list of counties will not populate until the state is selected.
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 Address Enter the street address in which the charging equipment will be located.
3c. Owners & Anticipated Users of EVSE
Who will own the charger? Enter the name of the school district or organization that will own the charging equipment.
Anticipated User(s) of the charger Enter the name(s) of the organization(s) that are anticipated to regularly use the charging equipment.
If serving school districts, will the EVSE serve multiple school districts within this project? Select from dropdown: Yes, No, or NA- School Districts not served by this equipment
Name of the School District(s) the EVSE will serve
(if applicable; use a semicolon between school districts)
Enter the name(s) of school district(s) the EVSE is expected to serve. Use a semicolon to separate entries when entering multiple districts.
NCES ID of School District that the EVSE will serve
(if applicable; use a semicolon between school districts)
Enter the NCES ID(s) of school district(s) the EVSE is expected to serve. Use a semicolon to separate entries when entering multiple districts.
3d. Infrastructure Installation Information
Total Funds Expended Installation Cost Enter the total installation costs for the charging equipment for the EV infrastructure group column.
Total EPA Funds Expended Installation Cost Enter the total EPA 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.
3e. EVSE Cost Summary
Total EPA Funds Expended on EVSE Equipment and Installation Automated cell that will calculate the total EPA Funds expended for the charging equipment and installation for an EV Infrastructure Group.
Total Funds Expended on EVSE Equipment and Installation Automated cell that will calculate the total Funds expended for the charging equipment and installation for an EV Infrastructure Group.
On-Site Power Generation Equipment Information
Type of energy generation Select a type of energy generation, solar or wind.
Generation Capacity of the system Enter the generation capacity of the system as either kW or MW. Please indicate unit of measurement.
Battery Energy Storage System (BESS) Equipment Information
Type of Battery Select a type of battery
Energy Capacity Enter the generation capacity of the system as either kWh or MWh. Please indicate unit of measurement.
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy