Appendix D. Transaction- and Project-Level Report.xlsx

GGRF Accomplishment Reporting (NEW)

Appendix D. Transaction- and Project-Level Report.xlsx

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

0-AWARD
1-TRANSACTION
2-PROJECT
3-PROJECT SITE
4-BENEFITS


Sheet 1: 0-AWARD

Column Header GGRF Program (DE001) Recipient Name (DE002) Unique Entity Identifier (UEI) (DE004) Reporting Period End Date (DE011) US EPA Grant Number (DE003) Date Created (DE069) Date Modified (DE363) Grant Title (DE257)
Data Type Picklist String String Date String Date Date String
Picklist Options CCIA;NCIF;SFA Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable

Sheet 2: 1-TRANSACTION

Column Header US EPA Grant Number (DE003) Date Created (DE069) Date Modified (DE363) Transaction Identifier - Originator (DE006) Counterparty Name (DE007) Counterparty TIN or EIN (DE008) Transaction Identifier - EPA (DE009) Date Originated (DE010) Transaction Purpose (DE012) Finance Type (DE013) Financial Assistance Type (DE014) Financial Assistance Type Description (DE015) Transaction Amount (DE016) GGRF Recycled Funds Amount (DE020) Financial Product Status (DE021) Technical or Financial Assistance Provider Name (DE022) Counterparty Type (DE023) Technical or Financial Assistance Provider TIN or EIN (DE024) Unpaid Principal (DE026) Interest Rate (DE027) Interest Type (DE028) Maximum Interest Rate (DE029) Points (DE030) Origination Fees (DE031) Amortization Type (DE032) Equity-Like Features (DE033) Debt-Equity Conversion (DE034) Term in Months (DE035) Guarantee by Third Party (DE036) Forgivable Loan (DE037) Amount of Forgivable Loan (DE038) Client ID (reported to CDFI Fund) (DE057) NAICS (DE064) Low-Income Owned or Controlled? (DE065) Project Financing Source (Public) - Name (DE211 ) Project Financing Source (Public) - Amount (DE212 ) Project Financing Source (Private) - Name (DE213 ) Project Financing Source (Private) - Amount (DE214 ) Loan-to-Value Ratio (DE215 ) Loan Loss Reserve Requirement (DE217 ) Principal Amount (DE241 ) Transaction Date (DE252) Transaction Identifier - Counterparty (DE253 ) Investment Tax Credit (ITC) Amount (DE260 ) Principal Subsidy Amount at Time of Origination (DE261 ) Security Interest (DE262) Investment Tax Credit (ITC) Direct Pay Amount (DE266) Subsidy Type (DE268) Delinquency - 30 Days or Less (DE270) Delinquency - 31 to 60 Days (DE271) Delinquency - 61 to 90 Days (DE272) Delinquency - 91 or More Days (DE273) Project Sponsor Name (DE279) Project Sponsor Address Line 1 (DE280) Project Sponsor Address Line 2 (DE281) Project Sponsor City (DE282) Project Sponsor State or Territory (DE283) Project Sponsor ZIP Code (DE284) Project Sponsor TIN or EIN (DE285) Project Financing (All Private Sources) - Subtotal (DE294) Project Financing Stage (DE295) Project Financing (All Public Sources) - Subtotal (DE309) Contract Identifier for Financial Assistance (DE310) Apex Transaction Identifier (DE327) Parent Transaction Identifier (DE328) Buying or Selling Financial Instrument (DE448) Transaction Identifier - Grantee (DE005) Project Title (DE074) Does Project Qualify as LIDAC? (DE096) Total Project or Development Cost (DE103 ) Technical Assistance Type (DE083)
Data Type String Date Date String String String String Date Picklist Picklist Picklist String Currency Currency Picklist String Picklist String Currency Percent Picklist Percent Number Currency Picklist Picklist Currency Number Picklist Picklist Currency String String Picklist Picklist Currency Picklist Currency Percent Currency Currency Date String Currency Currency Picklist Currency Picklist Boolean Boolean Boolean Boolean String String String String Picklist Number String Currency Picklist Currency String String String Picklist String String Picklist Currency Picklist
Picklist Options Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable TECHNICAL;
FINANCIAL;
SUBAWARD-TECHNICAL;
SUBAWARD-FINANCIAL;
ASSET; PROJECT; CORPORATE; OTHER TERM; LOC; SUBSIDY; OTHER-CONSUMER-DEBT; LNGUARANTEE; LNLSRESERVE; OTHER-CREDIT-ENHANCEMENT; CAPRESERVE; LNPURCHASE; LNSECURITIZATION; OTHER-INSTITUTIONAL-DEBT; EQTYINV; DEBTEQTY; N/A Not applicable Not applicable Not applicable ACTIVE; PAIDOFF; SOLD; CHARGEDOFF; REFIN; RESTRUCT; N/A Not applicable BEN-INDIVIDUAL-HOUSEHOLD;
BEN-BUSINESS;
BEN-NONPROFIT;
BEN-OTHER;
SUB-BANK;
SUB-BUSINESS;
SUB-CDE;
SUB-CDFI;
SUB-CDFI COMMUNITY DEVELOPMENT BANK;
SUB-CDFI COMMUNITY DEVELOPMENT VENTURE CAPITAL FUND;
SUB-CDFI CREDIT UNION;
SUB-GOV-COUNTY;
SUB-GOV-MUNICIPALITY;
SUB-GOV-STATE;
SUB-GOV-TRIBAL;
SUB-GREEN BANK;
SUB-NONPROFIT;
SUB-OTHER;
Not applicable Not applicable Not applicable FIXED; ADJ; OTHER Not applicable Not applicable Not applicable FULLAMORT; PARTAMORT; NONAMORT; OTHER CONVDEBT; PERFINT; ROYALTIES; WARRANTS; OTHER Not applicable Not applicable SBA; USDA; OTHERGOV; PERSONAL; OTHER; NONE YES; YESTM; NO; DO NOT KNOW Not applicable Not applicable Not applicable YES; NO; DO NOT KNOW FEDERAL; STATE; LOCAL; OTHER-GOVERNMENT Not applicable TBD Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable ASSET; FIRSTMORTGAGE; JUNIOR MORTGAGE; COLLATERAL; N/A Not applicable UPFRONT;REBATE;SUBSCRIPTION SUBSIDY YES; NO YES; NO YES; NO YES; NO Not applicable Not applicable Not applicable Not applicable
Not applicable Not applicable Not applicable PREDEVELOPEMENT; ACQUISITION; CONSTRUCTION; PERMANENT Not applicable Not applicable Not applicable Not applicable BUY; SELL; NA Not applicable Not applicable CEJST; EJSCREENSI; LIHOUSE; AFFHOUSE; TRIBAL; N/A Not applicable COMMUNITY-OUTREACH;
COMMUNITY-CAPACITY-BUILDING;
CONTRACTORS-OUTREACH;
CONTRACTORS-CAPACITY-BUILDING;
LENDERS-OUTREACH;
LENDERS-CAPACITY-BUILDING;
WORKFORCE-OUTREACH;
WORKFORCE-CAPACITY-BUILDING;
NEWPRODUCT;

Sheet 3: 2-PROJECT

Column Header Date Created (DE069) Date Modified (DE363) Transaction Identifier - Grantee (DE005) Project Title (DE074) Does Project Qualify as LIDAC? (DE096) Total Project or Development Cost (DE103 ) Technical Assistance Type (DE083) Project Identifier - Grantee (DE070) Project Identifier - EPA (DE072) Project Description and Purpose (DE075) Project Type (DE076) Project Type Detail (DE077) Technical Assistance Description (DE084) Project Status (DE085) Project Status Description (DE086) Project Equipment Useful Life (DE087) Is the asset owner not-for-profit? (DE101 ) Is the asset owner a community? (DE102 ) Community Benefits Delivered (DE108 ) Number of Households Served by Project (DE109 ) Estimated Annual Household Savings Provided by Project (DE110 ) Description of Household Savings (DE111 ) Permanent Jobs Created or Retained [Non-Construction] (DE113) Full-Time Equivalent Jobs Created [Construction] (DE114) Source of Jobs Estimates (DE115 ) Source of Jobs Estimates Description (if projected) (DE116 ) Tools to Promote Good Jobs and Community (DE117 ) Does Project Set Goal for Labor Hours Completed Under a Registered Apprenticeship Program? (DE126 ) Average Estimated Annual Household Energy Savings (DE130 ) Clean Energy Type (DE151 ) Nameplate Capacity (DE152 ) Capacity Factor (DE153 ) Storage Technology Type (DE155 ) Storage Power Capacity [in kW] (DE156 ) Storage Energy Capacity [in kWh] (DE157 ) Cycle Efficiency (DE158 ) Response Time (seconds) (DE159 ) Duration of Discharge (DE160 ) Is the power source only renewable? (DE161 ) Transmission Project Type (DE162 ) Miles of Power Lines (DE163 ) Estimated Annual Reduced Energy Loss from Change in Technical Loss Rate (DE164 ) Estimated change in electricity consumption annually (DE165 ) Estimated change in natural gas consumption (DE166 ) Estimated change in fuel oil consumption (DE167 ) Estimated diesel equivalent fuel consumption (DE168 ) Energy efficiency measures adopted (DE169 ) Number of air source heat pumps installed (DE170 ) Number of geothermal heat pumps installed (DE171 ) Number of induction stoves installed (DE172 ) Number of electric stoves installed (DE173 ) Average Estimated Change in Insulation Value Change (R-Value) (DE174 ) Building Type (DE175 ) Number of Net-Zero Buildings (DE176 ) Type of Construction (DE177 ) Net-Zero Calculation Method (DE178 ) Square Footage (DE179 ) Number of Vehicles Deployed (DE180 ) What is the Type of Existing On-Road Vehicle Being Replaced? (DE181 ) Baseline On-Road Vehicle Fuel Type (DE182 ) New On-Road Vehicle Fuel Type (DE183 ) Average On-Road Baseline Model Year (DE184) Will the Old On-Road Vehicles be Destroyed? (DE185 ) Type of non-road equipment (DE186 ) Baseline Non-Road Equipment Fuel Type (DE187 ) Baseline non-road equipment horsepower (DE188 ) New Non-Road Equipment Fuel Type (DE189 ) New non-road equipment horsepower (DE190 ) Average Non-Road Baseline Model Year (DE191) Will the old off-road vehicles be destroyed? (DE192 ) Number of charging ports deployed (DE193 ) Number of Level 1 Ports (DE194 ) Number of Level 2 Ports (DE195 ) Number of DC Fast Ports (DE196 ) Estimated Load Factor (DE197 ) Is the charger publicly accessible? (DE198 ) Baseline Fuel Type (DE199 ) Baseline Annual Fuel Consumption (DE200 ) Baseline annual CO2e (DE201 ) Alternative fuel type (DE202 ) Alternative fuel consumption annually (DE203 ) New annual CO2e (DE204 ) Fuel consumption unit (DE205 ) Renewable Natural Gas (RNG) production per year (DE206 ) Renewable Natural Gas (RNG) Source (DE207 ) Renewable Natural Gas (RNG) Use (DE208 ) Acres of Forest (DE209 ) New or Conserved? (DE210 ) Is Project Subject to BABA Requirements? (DE242 ) Is Project Covered by an EPA-Approved BABA Waiver? (DE243 ) BABA Waiver Type (DE244) BABA Program-wide Waiver (DE245 ) BABA Project-specific Waiver (DE246 ) Date EPA Project Officer Provided BABA Waiver Approval (DE247 ) Name of EPA Project Officer Providing BABA Waiver Approval (DE248 ) Is Project Subject to DBRA Requirements? (DE249 ) DBRA Construction Category (DE250 ) Asset owner is (DE251 ) Solar PV Project Type Usage (DE256 ) Enabling Upgrades (DE258 ) Is household electrified for the first time? (DE259 ) Date of Project Completion (Actual) (DE264) Project Interconnection Date (DE265) Project Resiliency Measures (DE269) Micromobility Vehicle Project (DE274) Micromobility Number of Vehicles Deployed (DE275) Solar Lease Monthly Amount (DE270) Solar Lease Term (DE277) Solar Lease - Fixed or Variable Monthly Lease Amount (DE278) Project Placed in Service Date (DE286) Number of newly built units (DE288) Number of rehabilitated or adaptively reused units (DE289) Number of rental units (DE290) Number of units for ownership (DE291) Number of housing units available to households at 80 percent of AMI or less (DE292) Number of housing units available to households at 81 percent of AMI or above (DE293) Total Photovoltaic System Cost (DE296) Photovoltaic Panels Cost (Materials) (DE297) Inverter Cost (Materials) (DE298) Remainder of System Cost (DE299) Interconnection Cost (DE300) Permitting Fees Cost (DE301) Solar Panel Type (DE302) Baseline On-Road Vehicle Annual Idling Hours (DE303) Baseline On-Road Vehicle Annual Hoteling Hours (DE304) New On-Road Vehicle Model Year (DE305) New Non-Road Vehicle Model Year (DE306) For Baseline Diesel Vehicles, Does the Vehicle Use Diesel Exhaust Fluid? (DE307) Enabling Upgrades Cost (DE311) Soft Cost Subtotal for Total Project or Development Cost (DE312) Hard Cost Subtotal for Total Project or Development Cost (DE313) Number of Vehicles Replaced (DE332) Will a managed charging strategy be utilized for the new onroad vehicles? (DE333) Are the replaced onroad vehicles a result of shared mobility (e.g., carsharing, ridesourcing, carpooling, bikesharing)? (DE334) Is the battery storage dispatchable as a electrical grid resource? (DE335) Does the project have battery storage? (DE338) Meter Type (DE360) Region as defined by Avoided Emissions Generation Tool (AVERT) (DE382) Expected Energy Efficiency Improvement (DE383) Average Annual Energy Consumption (DE384) Efficiency Unit for New HVAC System (DE385) Efficiency of New HVAC System (DE386) Efficiency Unit for HVAC System being replaced (DE387) Do you have efficiency of old HVAC System available? (DE388) Efficiency of Old HVAC system? (DE389) Average Annual usage of air conditioning (DE390) Electricity usage of old air conditioning unit (DE391) Average annual energy consumption of old HVAC system (DE392) Old HVAC Efficiency Rating (DE393) What is the fuel used for the old HVAC system? (DE394) Efficiency of New Water Heater System (DE395) Efficiency Unit for Water Heater System being Replaced (DE396) Efficiency Improvement of New Water Use Fixture (DE397) Do you have efficiency of old Water Heater System available? (DE398) Efficiency of Old Water Heater System (DE399) Average annual energy consumption of old water heater system (DE400) Old Water Heater System Model (DE401) What fuel is used in old water heater? (DE402) EER of the geothermal system (DE403) Number of fridge units installed (DE404) Electricity usuage of each fridge unit (DE405) Do you have expected efficiency improvement from grid interactive system? (DE406) What is the expected efficiency improvement from grid interactive system? (DE407) Is the system heating, cooling, or both? (DE408) Will the building wall insulation R value be higher than 10 after retrofit? (DE409) Does the building have an ENERGY STAR Target Score of 85 or higher? (DE410) What is the combined city/highway fuel efficiency of the onroad vehicle being replaced? (DE411) Do you know the annual miles driven per existing onroad vehicle being replaced? (DE412) Annual miles driven per vehicle (DE413) Will the existing onroad vehicles be destroyed or permanently removed from operation (by any owner); OR will the vehicles be resold for continued operational use? (DE414) What is the new onroad vehicle model year (DE415) Will a managed charging strategy be utilized for the new onroad vehicles? (DE416) Are the replaced onroad vehicles a result of shared mobility (e.g., carsharing, ridesourcing, carpooling, bikesharing)? (DE417) Will a dispatchable battery system be utilized (battery swapping) for the new onroad vehicles? (DE418) What is the existing nonroad vehicle/equipment model year? (DE419) How many nonroad vehicles/equipment of this type are being replaced? (DE420) What is the new nonroad vehicle/equipment rated horsepower? (DE421) What is the new nonroad vehicle/equipment model year? (DE422) IF BEV, what is the primary location (ZIP Code) for charging? (DE423) Will the existing nonroad vehicles/equipment be destroyed or permanently removed from operation (by any owner); OR will the vehicles be resold for continued operational use? (DE424) Does the project include vehicle charging infrastructure, walkability/bikability infrastructure, or both? (DE425) Level 1 EVSE - Low Utilization (DE426) Level 1 EVSE - Moderate Utilization (DE427) Level 1 EVSE - High Utilization (DE428) Level 2 EVSE - Low Utilization (DE429) Level 2 EVSE - Moderate Utilization (DE430) Level 2 EVSE - High Utilization (DE431) DCFC EVSE - Low Utilization (DE432) DCFC EVSE - Moderate Utilization (DE433) DCFC EVSE - High Utilization (DE434) Do you know the total annual emissions from all vehicles that are being replaced by walking and/or biking? (DE435) What are the total annual emissions from all vehicles that are being replaced by walking and/or biking? (DE436) How many people are expected to shift from vehicle usage to walking and/or biking? (DE437) Do you know the average distance (miles/week/person) that would be covered by walking and/or biking instead of driving? (DE438) What is the average distance (miles/week/person) that would be covered by walking and/or biking instead of driving? (DE439) Old Building Type (DE447)
Data Type Date Date String String Picklist Currency Picklist String String String Picklist Picklist String Picklist String Number Boolean Boolean Picklist Number Currency Picklist Number Number Picklist String Picklist Boolean Currency Picklist Number Percent Picklist Number Number Percent Number Number Boolean Picklist Number Percent Number Number Number Number Picklist Number Number Number Number Number Picklist Number Picklist Picklist Number Number Picklist Picklist Picklist Date Boolean Picklist Picklist Picklist Picklist Picklist Date Boolean Number Number Number Number Percent Boolean Picklist Number Number Picklist Number Number Picklist Number Picklist Picklist Number Picklist Boolean Boolean Picklist Picklist String Date String Boolean Picklist Picklist Picklist Picklist Boolean Date Date Picklist Boolean Number Currency Number Picklist Date Number Number Number Number Number Number Currency Currency Currency Currency Currency Currency Picklist Number Number Date Date Boolean Currency Currency Currency Number Boolean Boolean Boolean Boolean Picklist Picklist Percent Number Picklist Number Picklist Boolean Number Number Number Number Picklist Picklist Number Picklist Percent Boolean Number Number Picklist Picklist Number Number Number Boolean Percent Picklist Boolean Boolean Number Boolean Number Picklist Number Boolean Boolean Boolean Number Number Number Number Number Picklist Picklist Number Number Number Number Number Number Number Number Number Boolean Number Number Boolean Number Picklist
Picklist Options Not applicable Not applicable Not applicable Not applicable CEJST; EJSCREENSI; LIHOUSE; AFFHOUSE; TRIBAL; N/A Not applicable COMMUNITY-OUTREACH;
COMMUNITY-CAPACITY-BUILDING;
CONTRACTORS-OUTREACH;
CONTRACTORS-CAPACITY-BUILDING;
LENDERS-OUTREACH;
LENDERS-CAPACITY-BUILDING;
WORKFORCE-OUTREACH;
WORKFORCE-CAPACITY-BUILDING;
NEWPRODUCT;
Not applicable Not applicable Not applicable CLEANENERGY; BUILDINGS; TRANSPORTATION; INDUSTRY; AGRICULTURE; OTHER GENERATION; STORAGE; MICROGRID; TRANSMISSION; WEATHERIZATION; ELECTRIFICATION; ZERO-EMISSIONS NEW CONSTRUCTION; ZERO-EMISSIONS RETROFITS; ENERGY EFFICIENCY; METHANE RECOVERY; FUEL SWITCHING; VEHICLECHARGING-REFUELING; OTHER Not applicable STARTED; COMPLETE; CANCELLED Not applicable Not applicable YES; NO YES; NO CEEE; TRANSP; ZERO-E; HOUSING; CCMIT; CCRES; REMED; WORKDEV; FINMARKDEV; REMED; NEWJOBS; PROJECT DEPLOYED LIDAC; MEANINGFULCOMENGAGE Not applicable Not applicable UTILITYBILLSAVINGS; CAPITALCOSTREDUCTION; ORIGINATIONCOSTSAVINGS Not applicable Not applicable NEWFINANCING; WAGEDATA; ECONOMICIMPACT; RULE OF THUMB; OTHER Not applicable PROJECT IS COVERED BY A PROJECT LABOR AGREEMENT OR COMMUNITY WORKFORCE AGREEMENT;
PROJECT IS COVERED BY A COMMUNITY BENEFITS AGREEMENT;
WORKERS ON PROJECT ARE REPRESENTED BY A COLLECTIVE BARGAINING AGREEMENT (I.E., UNIONIZED);
PROJECT INCLUDES SPECIFIC GOALS AND EFFORTS TO RECRUIT WORKERS FROM LOW-INCOME AND DISADVANTAGED COMMUNITY(S);
PROJECT EMPLOYER PROVIDES SUPPORTIVE SERVICES FOR WORKERS WITH BARRIERS TO EMPLOYMENT;
YES; NO Not applicable SOLAR; WIND; HYDROPOWER Not applicable Not applicable BATTERIES; FLYWHEEL; COMPRESSED AIR; PUMPED HYDRO; HYDROGEN; THERMAL ENERGY STORAGE; MECHANICAL ENERGY STORAGE Not applicable Not applicable Not applicable Not applicable Not applicable YES; NO RECONDUCTOR-ACSR-ACCC Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable INSULATION; NEW WINDOWS; ENERGY-EFFICIENT EQUIPMENT; EQUIPMENT OPERATIONS IMPROVEMENT Not applicable Not applicable Not applicable Not applicable Not applicable COMMERCIAL;
MIXEDUSE;
RESIDENTIALSINGLEFAMILY;
RESIDENTIALMULTIFAMILY;
Not applicable ZERO-EMISSIONS NEW CONSTRUCTION;
ZERO-EMISSIONS RETROFITS;
ELECTRIFICATION [BUILDING SYSTEMS];
EEWEATHERIZATION;
Picklist TBD Not applicable Not applicable GASOLINE PASSENGER CAR;
GASOLINE LIGHT-DUTY TRUCK (VANS, PICKUP TRUCKS, SUVS);
GASOLINE MEDIUM- AND HEAVY-DUTY TRUCK OR BUS;
DIESEL PASSENGER CAR;
DIESEL LIGHT-DUTY TRUCK (VANS, PICKUP TRUCKS, SUVS);
DIESEL MEDIUM- AND HEAVY-DUTY TRUCK OR BUS;
GASOLINE MOTORCYCLE;
BEV;PHEV;FCEV BEV; PHEV; FCEV Not applicable YES; NO AERIAL LIFTS; AGRICULTURAL EQUIPMENT (OTHER); AGRICULTURAL TRACTORS; AIR COMPRESSORS; AIRPORT EQUIPMENT; BALERS; CHIPPERS/GRINDERS; COMBINES; CONTAINER HANDLERS; CRANES; CRAWLER TRACTORS/DOZERS; EXCAVATORS; FOREST EQUIPMENT; GAS COMPRESSORS; GRADERS; IRRIGATION SETS; LAWN & GARDEN EQUIPMENT; LEAF BLOWERS; MATERIAL HANDLING EQUIPMENT (OTHER); MOBILE GENERATORS; NON-ROAD TERMINAL TRACTORS/YARD TRUCKS; PUMPS; ROLLERS; ROUGH TERRAIN FORKLIFTS; RUBBER TIRE LOADERS; SKID STEER LOADERS; SPRAYERS; SWATHERS; SWEEPERS/SCRUBBERS; TRACTOR/BACKHOE/LOADERS; WELDERS; CONSTRUCTION EQUIPMENT (OTHER); COMMERCIAL MOWERS DIESEL; GASOLINE; NATURAL GAS (CNG, LPG, LNG) <11 hp; 11-25 hp; 26-50 hp; 51-75 hp; 76-100 hp; 101-174 hp; 175-300 hp; 301-602 hp; 603-750 hp; 751-1206 hp; 1206+ hp BEV; PHEV; FCEV <11 hp; 11-25 hp; 26-50 hp; 51-75 hp; 76-100 hp; 101-174 hp; 175-300 hp; 301-602 hp; 603-750 hp; 751-1206 hp; 1206+ hp Not applicable YES; NO Not applicable Not applicable Not applicable Not applicable Not applicable YES; NO GASOLINE; DIESEL; Not applicable Not applicable BIODIESEL;ELECTRICITY;ETHANOL;HYDROGEN;NATURAL GAS;PROPANE;REWENEWABLE DIESEL Not applicable Not applicable TBD
Not applicable Picklist TBD BOILER-FURNACE FUEL; CNG; COGENERATION; ELECTRICITY; FLARED FULL-TIME; PIPELINE GAS; PIPELINE TO ELECTRICITY Not applicable NEW; CONSERVED YES; NO YES; NO PROGRAM-WIDE WAIVER; PROJECT-SPECIFIC WAIVER
EPA DE-MINIMIS GENERAL APPLICABILITY WAIVER; EPA ELECTRIC VEHICLE CHARGERS PRODUCT WAIVER; MINOR (FERROUS) COMPONENTS OF IRON AND STEEL PRODUCTS GENERAL APPLICABILITY WAIVER; PACIFIC ISLAND TERRITORIES PUBLIC INTEREST GENERAL APPLICABILITY WAIVER; SMALL PROJECT GENERAL APPLICABILITY WAIVER Not applicable Not applicable Not applicable YES; NO BUILDING CONSTRUCTION; RESIDENTIAL CONSTRUCTION UTILITY-OWNED; THIRD-PARTY-OWNED; COMMUNITY-OWNED; HOUSEHOLD-OWNED SINGLEFAMILY; MULTIFAMILY; COMMUNITY SOLAR; PANELUPGRADES; ROOFUPGRADES; GRIDUPGRADES; OTHER; N/A YES; NO Not applicable Not applicable STORAGEABOVEFLOODZONE; YES; NO Not applicable Not applicable Not applicable FIXED MONTHLY LEASE AMOUNT;
VARIABLE MONTHLY LEASE AMOUNT
Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable PERC; Monocrystalline; Polycrystalline; Thin-film; CIGS; CdTe;
Not applicable Not applicable Not applicable Not applicable YES; NO Not applicable Not applicable Not applicable Not applicable YES; NO YES; NO YES; NO YES;NO MASTERMETER; SUBMETER CALIFORNIA REGION; CENTRAL; FLORIDA; MID-ATLANTIC; MIDWEST; CAROLINAS; NEW ENGLAND; NEW YORK; NORTHWEST; ROCKY MOUNTAINS; SOUTHEAST; SOUTHWEST; TENNESSEE; TEXAS; AK; HI; PR Not applicable Not applicable SEER; HSPF; EER; EF - ELECTRIC; AFUE - ELECTRIC RESISTANCE HEATING Not applicable SEER; HSPF; EER; EF – ELECTRIC; AFUE - ELECTRIC RESISTANCE HEATING; EF – OIL; EF – GAS; AFUE - OIL FURNACE; AFUE - GAS/PROPANE BOILER; AFUE - OIL BOILER; AFUE - GAS/PROPANE FURNACE YES; NO Not applicable Not applicable Not applicable Not applicable SEER - ENERGY STAR Sept 2015 to present;
SEER - ENERGY STAR 2006 thru Aug 2015;
SEER - 2015 or newer (South);
SEER - 2015 or newer (North);
SEER - 2006 to 2014;
SEER - 1992 through 2005;
SEER - Prior to 1992;
SEER - Mini-split / Ductless (All years);
HSPF - ENERGY STAR Sept 2015 to present;
HSPF - ENERGY STAR 2006 thru Aug 2015;
HSPF - 2015 or newer;
HSPF - 2006 to 2014;
HSPF - 1992 through 2005;
HSPF - Prior to 1992;
HSPF - Mini-split / Ductless (All years);
EER - Window A/C;
AFUE - Gas/Propane Furnace - Condensing Prior to 2015;
AFUE - Gas/Propane Furnace - Natural Draft (All Years);
AFUE - Gas/Propane Furnace - Induced Draft (All Years);
AFUE - Gas/Propane Furnace - North;
AFUE - Gas/Propane Furnace - South;
AFUE - Gas/Propane Boiler - ENERGY STAR after Oct 2014;
AFUE - Gas/Propane Boiler - ENERGY STAR after Oct 2004;
AFUE - Gas/Propane Boiler - Condensing;
AFUE - Gas/Propane Boiler - Induced Draft;
AFUE - Gas/Propane Boiler - Natural Draft;
AFUE - Oil Furnace - Condensing;
AFUE - Oil Furnace - ENERGY STAR after Feb 2003;
AFUE - Oil Furnace - Retention Head Burner;
AFUE - Oil Furnace - Conventional Burner;
AFUE - Oil Boiler - ENERGY STAR after Oct 2014;
AFUE - Oil Boiler - ENERGY STAR after April 2002;
AFUE - Oil Boiler - After Sept. 2012 (All except ES);
AFUE - Oil Boiler - Induced Draft;
AFUE - Oil Boiler - Natural Draft;
AFUE - Electric Resistance Heating - Electric Furnace;
AFUE - Electric Resistance Heating - Baseboard Furnace;
AFUE - Electric Resistance Heating - Electric Boiler;
EF - Gas - Standard Storage;
EF - Gas - ENERGY STAR Storage;
EF - Gas - Tankless/On-Demand;
EF - Oil - Standard Storage;
EF - Electric - Standard Storage;
EF - Electric - ENERGY STAR Storage (rare);
EF - Electric - Tankless/On-Demand;
EF - Electric - Heat Pump;
GAS; PROPANE; OIL; FURNACE OIL Not applicable EF – ELECTRIC; EF – GAS; EF – OIL Not applicable YES; NO Not applicable Not applicable SEER - ENERGY STAR Sept 2015 to present;
SEER - ENERGY STAR 2006 thru Aug 2015;
SEER - 2015 or newer (South);
SEER - 2015 or newer (North);
SEER - 2006 to 2014;
SEER - 1992 through 2005;
SEER - Prior to 1992;
SEER - Mini-split / Ductless (All years);
HSPF - ENERGY STAR Sept 2015 to present;
HSPF - ENERGY STAR 2006 thru Aug 2015;
HSPF - 2015 or newer;
HSPF - 2006 to 2014;
HSPF - 1992 through 2005;
HSPF - Prior to 1992;
HSPF - Mini-split / Ductless (All years);
EER - Window A/C;
AFUE - Gas/Propane Furnace - Condensing Prior to 2015;
AFUE - Gas/Propane Furnace - Natural Draft (All Years);
AFUE - Gas/Propane Furnace - Induced Draft (All Years);
AFUE - Gas/Propane Furnace - North;
AFUE - Gas/Propane Furnace - South;
AFUE - Gas/Propane Boiler - ENERGY STAR after Oct 2014;
AFUE - Gas/Propane Boiler - ENERGY STAR after Oct 2004;
AFUE - Gas/Propane Boiler - Condensing;
AFUE - Gas/Propane Boiler - Induced Draft;
AFUE - Gas/Propane Boiler - Natural Draft;
AFUE - Oil Furnace - Condensing;
AFUE - Oil Furnace - ENERGY STAR after Feb 2003;
AFUE - Oil Furnace - Retention Head Burner;
AFUE - Oil Furnace - Conventional Burner;
AFUE - Oil Boiler - ENERGY STAR after Oct 2014;
AFUE - Oil Boiler - ENERGY STAR after April 2002;
AFUE - Oil Boiler - After Sept. 2012 (All except ES);
AFUE - Oil Boiler - Induced Draft;
AFUE - Oil Boiler - Natural Draft;
AFUE - Electric Resistance Heating - Electric Furnace;
AFUE - Electric Resistance Heating - Baseboard Furnace;
AFUE - Electric Resistance Heating - Electric Boiler;
EF - Gas - Standard Storage;
EF - Gas - ENERGY STAR Storage;
EF - Gas - Tankless/On-Demand;
EF - Oil - Standard Storage;
EF - Electric - Standard Storage;
EF - Electric - ENERGY STAR Storage (rare);
EF - Electric - Tankless/On-Demand;
EF - Electric - Heat Pump;
GAS; PROPANE; OIL Not applicable Not applicable Not applicable YES; NO Not applicable HEATING; COOLING; BOTH YES; NO YES; NO Not applicable YES; NO Not applicable RESOLD FOR CONTINUED OPERATION USE; DESTROYED OR PERMANENTLY REMOVED FROM OPERATION Not applicable YES; NO YES; NO YES; NO Not applicable Not applicable Not applicable Not applicable Not applicable RESOLD FOR CONTINUED OPERATION USE; DESTROYED OR PERMANENTLY REMOVED FROM OPERATION CHARGING ONLY; WALKABILITY-BIKABILITY INFRASTRUCTURE; BOTH Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable YES; NO Not applicable Not applicable YES; NO Not applicable COMMERCIAL;
MIXEDUSE;
RESIDENTIALSINGLEFAMILY;
RESIDENTIALMULTIFAMILY;

Sheet 4: 3-PROJECT SITE

Column Header Date Created (DE069) Date Modified (DE363) Technical Assistance Type (DE083) Project Site City (DE088) Project Site State or Territory (DE089) Project Site ZIP Code (DE090) Project Site Census Tract Code (DE091) Project Site Census Tract and Block Group Year (DE092) Project Site Longitude (X-Coordinate) (DE093) Project Site Latitude (Y-Coordinate) (DE094) Project Site Geocoordinates Description (DE095) Project Site Address Line 1 (DE254 ) Project Site Address Line 2 (DE255 ) Does Project Site Qualify as LIDAC in CEJST? (DE263) Project Site County (DE267) Project Site Census Block Group (DE314) Project Site Census Block (DE315) Project Site Identifier - Grantee (DE316) Project Site Identifier - EPA (DE317) Unique Building Identifier (UBID) (DE330) Factor 10 for Priority Project #3 (Transportation) (DE468) Factor 9 for Priority Project #3 (Transportation) (DE467) Factor 8 for Priority Project #3 (Transportation) (DE466) Factor 7 for Priority Project #3 (Transportation) (DE465) Factor 6 for Priority Project #3 (Transportation) (DE464) Factor 5 for Priority Project #3 (Transportation) (DE463) Factor 4 for Priority Project #3 (Transportation) (DE462) Factor 3 for Priority Project #3 (Transportation) (DE461) Factor 2 for Priority Project #3 (Transportation) (DE460) Factor 1 for Priority Project #3 (Transportation) (DE459) Factor 10 for Priority Project #2 (Buildings) (DE458) Factor 9 for Priority Project #2 (Buildings) (DE457) Factor 8 for Priority Project #2 (Buildings) (DE456) Factor 7 for Priority Project #2 (Buildings) (DE455) Factor 6 for Priority Project #2 (Buildings) (DE454) Factor 5 for Priority Project #2 (Buildings) (DE453) Factor 4 for Priority Project #2 (Buildings) (DE452) Factor 3 for Priority Project #2 (Buildings) (DE451) Factor 2 for Priority Project #2 (Buildings) (DE450) Factor 1 for Priority Project #2 (Buildings) (DE449)
Data Type Date Date Picklist String Picklist Number String Picklist Number Number Picklist String String Boolean Picklist Number Number String String String Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist Picklist
Picklist Options
Not applicable

Not applicable


Not applicable


Not applicable

Not applicable


Not applicable

Not applicable


Not applicable

Not applicable



Not applicable

Not applicable

Not applicable

Not applicable

Not applicable





















Sheet 5: 4-BENEFITS

Column Header Date Created (DE069) Date Modified (DE363) Annual Carbon Dioxide Equivalent (CO2e) (DE133 ) Annual Carbon Dioxide (CO2) (DE134 ) Annual Methane (CH4) (DE135 ) Annual Hydrofluorocarbons (HFCs) (DE136 ) Annual Nitrous Oxide (N2O) (DE137 ) Annual Perfluorocarbons (PFCs) (DE138 ) Annual Sulfur Hexafluoride (SF6) (DE139 ) Annual Nitrogen Trifluoride (NF3) (DE140 ) Annual Primary Fine Particulate Matter (PM2.5) (DE141 ) Annual Total Fine Particulate Matter (PM2.5) (DE142 ) Annual Particulate Matter (PM10) (DE143 ) Annual Nitrogen Dioxide (NO2) (DE144 ) Annual Sulfur Dioxide (SO2) (DE145 ) Annual Ground-Level Ozone (O3) (DE146 ) Annual Carbon Monoxide (CO) (DE147 ) Annual Lead (Pb) (DE148 ) Annual Ammonia (NH3) (DE149 ) Annual Volatile Organic Compounds (VOCs) (DE150 ) Benefit Identifier - Grantee (DE325) Benefit Identifier - EPA (DE326) Annual Nitrogen Oxides (NOx) (DE336) Annual Sulfur Oxides (SOx) (DE337) Lifetime Carbon Dioxide Equivalent (CO2e) (DE339) Lifetime Carbon Dioxide (CO2) (DE340) Lifetime Methane (CH4) (DE341) Lifetime Nitrous Oxide (N2O) (DE342) Lifetime Total Fine Particulate Matter (PM2.5) (DE343) Lifetime Particulate Matter (PM10) (DE344) Lifetime Nitrogen Dioxide (NO2) (DE345) Lifetime Sulfur Dioxide (SO2) (DE346) Lifetime Carbon Monoxide (CO) (DE347) Lifetime Ammonia (NH3) (DE349) Lifetime Volatile Organic Compounds (VOCs) (DE350) Lifetime Nitrogen Oxides (NOx) (DE351) Lifetime Sulfur Oxides (SOx) (DE352) Lifetime Hydrofluorocarbons (HFCs) (DE353) Lifetime Perfluorocarbons (PFCs) (DE354) Lifetime Sulfur Hexafluoride (SF6) (DE355) Lifetime Nitrogen Trifluoride (NF3) (DE356) Lifetime Annual Primary Fine Particulate Matter (PM2.5) (DE357) Lifetime Ground-Level Ozone (O3) (DE358) Lifetime Lead (Pb) (DE359) End Beneficiary 12-month Historical Utility Costs (DE364) End Beneficiary 12-month Historical Utility Energy Consumption (DE365) End Beneficiary Net Cost of Solar (DE366) End Beneficiary Allocated Solar Generation (DE367) End Beneficiary Solar Generation Compensation Rate (DE368) Utility Provider Name (DE369) Baseline Utility Rate (DE370) Baseline Energy Consumption (DE371) Customer Net Cost of Solar (DE372) Customers Allocated Generation (DE373) Solar Generation Compensation Rate (DE374) Utility bill escalation rate (DE375) Solar degradation rate per year (DE376) End Beneficiary Year 1 Expected Allocated Solar Generation (DE377) Upfront End Beneficiary Solar Cost (DE378) Annual Solar Incentive(s) Received by End Beneficiary (DE379) End Beneficiary Solar Generation Absolute Compensation (DE380) Household Savings Calculation Methdology (DE381) Transfer of existing unit annual emissions to new owner, CO2e (DE440) Transfer of existing unit annual emissions to new owner, CO (DE441) Transfer of existing unit annual emissions to new owner, NOx (DE442) Transfer of existing unit annual emissions to new owner, PM10 (DE443) Transfer of existing unit annual emissions to new owner, PM2.5 (DE444) Transfer of existing unit annual emissions to new owner, VOC (DE445) Transfer of existing unit annual emissions to new owner, SOx (DE446)
Data Type Date Date Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number String String Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Currency Number Currency Number Currency Picklist Currency Number Currency Number Currency Percent Percent Number Currency Currency Currency Picklist Number Number Number Number Number Number Number
Picklist Options Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable TBD Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Average Year Savings Model (amortized) - Representative
Average Year Savings Model (amortized) - Empirical
Single Year Savings Model - Representative
Single Year Savings Model - Empirical
Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable Not applicable
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy