RUS IRA GHG Calculator v4.2c - template5 ~ pwd.xlsx

XLSX spreadsheet 43 KB Posted

Attached to
Empowering Rural America (New ERA) Program Federal grant opportunity
Opportunity number
RUS-NEWERA-2023
Issued by
Department of Agriculture Rural Housing Service Washington Office Rural Utilities Services

About this file

This document contains a template and instructions for a greenhouse gas calculator to be used in applications for funding from the Department of Agriculture Rural Utilities Service New Empowering Rural America program. The template collects data on applicants' current energy generation portfolios and proposed projects, and calculates metrics such as annual and lifetime greenhouse gas reductions. It is designed to allow RUS to compare applications consistently. The template requests information on applicants' baseline year energy supply, proposed project details including capital costs and loan amounts requested, additions of new zero-emission generation and purchases, phase-down of non-zero emission assets, carbon capture and storage details, and system grid loss reductions. It then calculates greenhouse gas emissions for the current and proposed new supply mixes, and metrics including annual and lifetime reductions in carbon dioxide equivalent emissions, reduction percentages, and cost-effectiveness of projects in dollars per ton of carbon dioxide equivalent reduced or avoided. Notes sections allow additional comments. Emission factors used in calculations are from the EPA eGRID database and other sources.

Achievable Reduction Tool

View the file

Other files for this federal grant opportunity

Other files attached to Empowering Rural America (New ERA) Program, newest first.
File Type Posted
Final RUS IRA New ERA program guide LOI stage 7.27.23.pdf PDF
Final Sample Letter of Interest New ERA 7.24.2023.pdf PDF
NewERA FR Notice 7.27.23.pdf PDF
New ERA NOFO.pdf PDF

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Welcome

Welcome!
USDA Rural Utilities Service (RUS) Greenhouse Gas (GHG) Calculator for Utility-Scale Renewable Energy Projects Generating Electricity
This calculator is to be used by applicants to the Inflation Reduction Act (IRA)
New Empowering Rural America (New ERA) - SEC. 22004. USDA ASSISTANCE FOR RURAL ELECTRIC COOPERATIVES
Priority -- To achieve the greatest reduction in carbon dioxide, methane, and nitrous oxide emissions associated with rural electric systems
Instructions

The purpose of this workbook is to provide a simple GHG calculator that will allow RUS to estimate emission reductions generally in a standard manner that allows for a direct comparison of Section 22004 applications on an equal or "apples-to-apples" basis. It is also meant to reduce the burden on applicants from having to learn or develop a new tool or program in order to apply for this program.

There are many valid methods to calculate achievable GHG emission reductions. This workbook may not capture all emission reductions under all conditions an applicant is proposing, such as emission reductions from transmission and distribution loading changes, energy efficiency reductions, or other dynamic system reductions. If there are other "zero emission systems" or other emission reductions an applicant does not believe will be adequately captured in the spreadsheet, applicants are welcome to note that and provide that information in Tab B. All “zero emission systems” must generate electricity and be completed and operating by 2031.

Again, the purpose of this spreadsheet is to allow for a simplified manner for applicants to outline their plans and for RUS to compare applications on a standard basis using common assumptions. Section 22004 includes the following as eligible activities: the purchase of renewable energy, renewable energy systems, zero-emission systems, carbon capture and storage systems, to deploy such systems, or energy efficiency improvements to generation & transmission system of eligible entities. For purposes of this spreadsheet, both renewable-based energy systems and nuclear are considered to be "zero emission systems" and are delineated as separate inputs.

Tab A is the GHG Calculator Worksheet
The Calculator Worksheet is to be used by all eligible section 22004 applicants.
The Worksheet uses the latest system data provided by the applicant (2022) as a baseline to calculate total GHG impacts (both reductions and avoided). Other related metrics are calculated.
Projects and impacts should reflect the scope of your proposal for funding and be a direct result of the requested funding.
The Calculator Worksheet provides a snap shot of the annual GHG impacts assuming all aspects of the proposed project is in place and operating. All inputs are average annual values.
This Worksheet allows the assessment of project impacts based on a comon and consistent set of assumptions.
Enter your system and project data in the gray cells. The Worksheet's calculated values and metrics are in the green cells.
If "ERROR" flags appear, please check and reenter your input values.
Instructions:
Step 1. Identification Inputs: Eligible Entity Legal Name (Applicant) ; Project Name; and Date
Step 2. Part 1 Inputs to establish baseline year energy supply mix
Select: Baseline Year
Input: Total Generated Energy and its breakdown as specified
Input: Total Energy Purchases and its breakdown as specified
Input: Total System Grid Losses
Step 3. Part 2 Proposed Project(s) Data
Input: Proposed Project(s) Total Capital Cost and Total RUS Loan and Grant Funds Being Requested in this Application
Input: Additions of New Zero Emission Generation and Purchases
Enter Sum of All New Proposed Zero Emission Generation (MWh) and Sum of All New Zero Emission Electricity Purchases (MWh)
Input: Phase Down of Non-Zero Emission Generation Assets
Enter Sum of the Non-Zero Emission Generation (MWh) Attributed to Stranded Assets and Green Fuel Switching or Cofiring
Input: Useful Life and Purchase Terms for New Non-Zero Emission Supply
Input: Carbon Capture and Sequestration and Useful Life
Input: Reduction in Annual System Grid Losses
Input: Share of New Zero Emission Generation Applied to Phased Down Non-Zero Emission Generation
Input: Share of New Zero Emission Purchases Applied to Phased Down Non-Zero Emission Purchases
Step 4. All values for the new energy supply mix are calculated
Step 5. All Greenhouse Gas Metrics are calculated
Step 6. Check Calculator Worksheet for "ERROR" flags. Check and reenter your input values as needed.
Step 7. Save Workbook and submit with application
Use Tab B to provide any additional Notes or Feedback concerning system impacts and benefits
Describe system portfolio impacts not captured by the calculator and how the proposed projects fit into your decarbonization plan. (Achieving zero carbon by 2035)
Other qualitative benefits can be presented.
See Tab C to review the base GHG Emission Factors Used in this Workbook
GHG Emission Factors are referenced from eGRID, U.S. Environmental Protection Agency (EPA) and the Energy Information Administration (EIA)
National Average Factors are used for simplicity and consistency.
Please include your completed Workbook in your loan application package. Thank you!
Applications will not be deemed complete if this worksheet or an equivalent substitute is not included in the submitted application.

A. Calculator Worksheet

UNITED STATES DEPARTMENT OF AGRICULTURE (USDA)
RURAL UTILITIES SERVICE (RUS) ELECTRIC PROGRAM
ELIGIBLE ENTITY LEGAL NAME:

PROJECT NAME:

DATE:
This worksheet is for all eligible New ERA (Section 22004) electric cooperative applicants who are proposing to use RUS IRA funding for any of the following:
Adding zero emission systems (renewable-based or nuclear energy generation) to their utility plant assets, rate-based generation fleet (owning new zero emission projects)
Projects directly facilitate the phase down of existing non-zero emission generation from the asset base
Adding zero emission based purchases and eliminating or reducing fossil-based and grid purchases
Installing carbon capture and sequestration facilities
System grid improvements
For applicants that are eligible electric cooperative subsidiaries, Part 1 inputs represent their offtaker's system.
All data inputs are either positive values or 0. Negative values are not valid entries.

PART 1. Inputs to Establish a Baseline Energy Supply Mix and Determine the Baseline System GHG Emissions

Generation System Data (2022) – Based on Generating Assets You Currently Own and Operate and Electricity Purchases. For assets you have partial ownership only include your share of the output.
Note: For Subsidiary Applicants, this section describes your offtaker's system.Baseline Year:2022
All proposed projects must be in operation after the baseline year
Annual Total System Generation Supply (MWh)Does not include proposed project(s). Includes all owned generation and purchases in the baseline year.
Assets Owned and Operated
Annual Renewables Generation (MWh)Sum of all renewable sources for electricity generation in the baseline year
Annual Coal Generation (MWh)
Annual Natural Gas Generation (MWh)
Annual Oil/Diesel Generation (MWh)
Annual Nuclear Generation (MWh)
Purchased Electricity
Total Annual Electricity Purchases (MWh)All Electricity Purchases (All supply contracts, bulk grid, and PPAs)
Annual Renewables Purchases (MWh)Renewables Share of Total Purchases (Not in Addition to Total Purchase)
Annual Coal Generation Purchases (MWh)Coal Share of Total Purchases (Not in Addition to Total Purchase)
Annual Natural Gas Generation Purchases (MWh)Natural Gas Share of Total Purchases (Not in Addition to Total Purchase)
Annual Oil/Diesel Generation Purchases (MWh)Oil/Diesel Share of Total Purchases (Not in Addition to Total Purchases)
Annual Nuclear Generation Purchases (MWh)Nuclear Share of Total Purchases (Not in Addition to Total Purchase)
Annual Bulk Grid Purchases (MWh)Grid Purchase Share of Total Purchases (Not in Addition to Total Purchases)
Check of Total Purchased Electricity:- 0MWh
Check of Total System Supply:- 0MWh
System Grid Losses
Annual System Grid Losses (MWh)Generation Supply Less Delivered Electricity Sales or Power System Simulation Modeling Results

PART 2. Proposed Project(s) Data: Provide Project Cost and Impacts to the System Energy Supply Mix and GHG Emissions

Total Project Capital Cost ($)
Requested RUS Amount ($)Include total requested RUS loan and grant amounts in this application

Actions Directly Funded By this Project - Average Annual Values - All Projects Must Be Complete and Operational By 2031

Additions of Zero Emission Generation and Purchases
Proposed New Renewable Project(s) Average Annual Generation (MWh)Useful Life (years)Do not exceed 30 years
Include the sum of all new renewables-based electricity generation (direct to grid and renewable electricity stored and dispatched). Do not double count delivered generation.
Proposed New Nuclear Project Annual Generation (MWh)- 0Useful Life (years)Do not exceed 30 years
Proposed New Renewables Power Purchases (MWh)Purchase Term (yr)Do not exceed 30 years
Proposed New Nuclear Generation Power Purchases (MWh)Purchase Term (yr)Do not exceed 30 years
Phase Down of Non-Zero Emission (Fossil) Generation Assets (Stranded Assets and Green Fuel Switching or Cofiring)
Proposed Phase Down of Coal Asset Generation (MWh)
Proposed Phase Down of Natural Gas Asset Generation (MWh)Weighted Avg Life- 0years
Proposed Phase Down of Oil/Diesel Generation (MWh)Incl. all new zero emission supply and carbon capture
Carbon Capture and Sequestration
Anticipated Annual Tons of CO2e Captured/Sequestered- 0Useful Life (years)Do not exceed 30 years
Reduction of System Grid Losses
Anticipated Annual Reduction of System Grid Losses (MWh)Net MWh Line and Delivery SavingsEstimated or Results of Power System Simulation Modeling
Cannot be Greater Than Baseline System Losses
In Tab B, please specify the names of the fossil units being permanently closed, fuel type, and MW nameplate capacities.
In Tab B, please specify if System Grid actions increase the power transfer capacity of the system grid and enables interconnections or delivery of additional renewables and zero emissions capacity.
Operational Impacts on the Baseline System - Uses of the Proposed New Zero Emission Project(s) Generation and Purchases
Additions and Replacements: What share of the zero emissions projects' output is additional generation (system growth) and what shares replace the phased out non-zero emission gen and purchases?
Replacement is defined as the portion of new zero emission project(s) that maintains the output provided by the baseline system after phase down of non-zero emission supplies.

Total New Zero Emission Supply (MWh) - 0

Table 1. Proposed Project(s)Total New Zero Emission Supply (MWh)
Breakdown of New Zero Emission Supply (MWh)RenewablesNuclearTotalCheck
Generation- 0- 0- 0- 0
Purchases- 0- 0- 0- 0
Total- 0- 0- 0- 0

Uses of Zero Emission Supply (MWh): Allocation New Zero Emission Supply (Table 1) to Replace Supply from Phasing Down Non-Zero Emission Supply Sources

Table 2. Proposed Project(s)Share of New Zero Emission Generation and Purchases Applied to Phased Down Non-Zero Emission Generation (MWh)
Breakdown of New Zero Emission Supply (MWh)Renewables GenNuclear GenRE PurchasesNuclear PurchasesTotalCannot Exceed
Coal Generation- 0- 0
Nat Gas Generation- 0- 0- 0
Oil/Diesel Gen0- 0- 0
Total- 0- 0- 0- 0- 0- 0
Cannot Exceed- 0- 0- 0- 0
Remaining ZE Gen- 0- 0- 0- 0
Table 3. Proposed Project(s)Share of New Zero Emission Generation and Purchases Applied to Phased Down Non-Zero Emission Purchases (MWh)
Breakdown of New Zero Emission Supply (MWh)Renewables GenNuclear GenRE PurchasesNuclear PurchasesTotalCannot Exceed
Coal Gen Purchases- 0- 0- 0
Nat Gas Purchases- 0- 0- 0
Oil/Diesel Purchase- 0- 0- 0
Bulk Grid Purchases- 0- 0- 0
Total- 0- 0- 0- 0- 0- 0
Cannot Exceed- 0- 0- 0- 0
Remaining ZE Purchases- 0- 0- 0- 0
Additional Bulk Grid Purchases/Natural Gas Necessary to Replace Any Phased Down Non-Zero Emission Supply that Was Not Covered by the New Zero Emission Supply (MWh)
- 0
Table 4. Proposed Project(s)Remaining New Zero Emission Supply to be Used for System Growth (MWh)
Breakdown of New Zero Emission Supply (MWh)RenewablesNuclearTotal
Generation- 0- 0- 0
Purchases- 0- 0- 0
Total- 0- 0- 0
Table 5. Summary
Total Zero Emission Supply (MWh)- 0
Amount Applied to Non-Zero Emission Phase Downs (MWh)- 0
Amount Applied to System Growth (MWh)- 0

New System Supply Mix

Summary of Proposed Project(s) Output and Uses:New System Supply Mix
Zero Emission Gen- 0MWh
Zero Emission System Gen and Purchases to Meet GrowthProject(s) OutputMWhRenewables Gen- 0
Additional Renewables Supply- 0Nuclear Gen- 0
Additional Nuclear Supply- 0Fossil Based Gen- 0MWh
Zero Emission Gen and Purchases Applied to Phased Down Non Zero Emission SupplyMWhCoal Gen- 0
Replacement of Coal Generation- 0Natural Gas Gen- 0
Replacement of Natural Gas Generation- 0Oil/Diesel Gen- 0
Replacement of Oil/Diesel Generation- 0Purchased Supply- 0MWh
Zero Emissions Gen and Purchases Applied to Non Zero Emission Purchased PowerMWhBulk Grid Purchases- 0
Replacement of Purchased Bulk Grid Electricity- 0Coal Gen Purchases- 0
Replacement of Purchased Coal Electricity- 0Nat Gas Purchases- 0
Replacement of Purchased NG Electricity- 0RE Purchases- 0
Replacement of Purchased Oil/Diesel Electricity- 0Nuclear Purchases- 0
Oil/Diesel Purchase- 0
- 0MWhTotal- 0MWh
Generation output reduced by fossil phase down that is not replaced with zero emission supply additions are assumed to be replaced by grid electricity purchases to meet minimum baseline service demands.
PART 3. Calculated GHG Emissions (Based on EPA eGrid Emission Factors Presented in Tab C)
System Supply MixCurrentNew (Base System+Zero Emission New Gen-Fossil Closures-Legacy Op Reductions+Purchases)
Zero Emission Systems
Renewables Generation/Total Generation Supply (%)0.0%0.0%
Nuclear Generation/Total Generation Supply (%)0.0%0.0%
Legacy Fossil Generation Assets
Coal Generation/Total Generation Supply (%)0.0%0.0%
Natural Gas Generation/Total Generation Supply (%)0.0%0.0%
Oil/Diesel Generation/Total Generation Supply (%)0.0%0.0%
Energy Supply Purchases
Bulk Grid Purchases/Total Generation Supply (%)0.0%0.0%
Coal Generation Purchases/Total Generation Supply (%)0.0%0.0%
Natural Gas Generation Purchases/Total Generation Supply (%)0.0%0.0%
Renewable Generation Purchases/Total Generation Supply (%)0.0%0.0%
Nuclear Generation Purchases/Total Generation Supply (%)0.0%0.0%
Oil/Diesel Generation Purchases/Total Generation Supply (%)0.0%0.0%
Total must add to 100%0.0%0.0%
GHG Avoided (Tons):
Current Annual GHG (Tons)New Annual GHG (Tons)Savings from ZE Additions Based on Non-Baseload Emission Rates
CO2- 0CO2- 0- 0
N2O- 0N2O- 0- 0
CH4- 0CH4- 0- 0
CurrentNew
Annual CO2 Equivalent (CO2e) (Tons)- 0AnnualCO2e (Tons)- 0- 0
Lifetime Cumulative CO2e (Tons)- 0LifetimeCO2e (Tons)- 0- 0
System Carbon Intensity (pounds CO2e/MWh)

Current System - 0

System + Project(s) - 0

PART 4. Calculated Metrics

Annual Metrics

Note 1:Annual GHG Reduction (Tons CO2e)- 0
Annual GHG Avoided (Tons CO2e)- 0
Annual Tons Reduced and Avoided- 0
System + Project(s)
Note 1:Annual GHG % Reduction0.0%Avoided Emissions
Decrease % in Carbon Intensity0.0%
Increase % of Renewables Supply0.0%
Increase % of Zero Emission Supply0.0%
Project Lifetime Metrics (Cumulative Impacts)
Cost EffectivenessCost Effectiveness
Note 1:Total GHG Reduction (Tons CO2e)- 0- 0Proj $/Ton CO2e- 0RUS $/Ton CO2eReduction
Total GHG Avoided (Tons CO2e)- 0
Total Tons Reduced and Avoided- 0- 0Proj $/Ton CO2e- 0RUS $/Ton CO2eReduction + Avoided
System + Project(s)
Note 1:Lifetime GHG % Reduction0.0%Avoided Emissions
Note 1:If new renewable projects only provide additional generation for growth then there will be no GHG reductions but only GHG avoided. Metrics based on reduction will be zero or undefined.
In this case, use GHG avoided metrics only. Carbon Intensity values and renewable generation values are still valid.

B. Notes

UNITED STATES DEPARTMENT OF AGRICULTURE (USDA)
RURAL UTILITIES SERVICE (RUS) ELECTRIC PROGRAM
ELIGIBLE ENTITY LEGAL NAME:

PROJECT NAME:

DATE:

NOTES:

Space is provided below for any additional comments or feedback.

System portfolio impacts

Achieving Your Decarbonization Plan

Other details or comments

C. Emission Factors Used

aresur99
USDA Rural Utilities Service (RUS) Greenhouse Gas (GHG) Calculator for Utility-Scale Renewable Energy Projects Generating Electricity
This calculator is to be used by applicants to the Inflation Reduction Act (IRA)
New Empowering Rural America (New ERA) - SEC. 22004. USDA ASSISTANCE FOR RURAL ELECTRIC COOPERATIVES
Priority -- To achieve the greatest reduction in carbon dioxide, methane, and nitrous oxide emissions associated with rural electric systems
Calculation Check
For Purchased Power: U.S. Electricity Grid Averages (2021)2021MWhCO2N2OCH4
Capacity FactorsU.S. Generation4,120,000,000
GHGlbs/MWhlatest eGrid49.30%Coal 23%947,600,000213908949760036691072252251120
CO2818.3852.354.40%NG 38%1,565,600,0001407218267840265212626521264
N2O0.0090.0116.40%Oil 0.5%20,600,000373890000002991121495560
CH40.0650.071Renewables 19.5%803,400,000000
CO2e857Nuclear 19%782,800,000000
Total lbs/MWh869.830.010.07
100 year Greenhouse Gas Global Warming Potential (GWP) Multiplier874.40Total CO2e lbs/MWh869.832.871.70
To calculate CO2 equivalents (CO2e)
NRELAvoided CO2e Factor
CO211eGrid, U.S. non-baseload output CO2e marginal emission rate, 2021
N2O2982651417.3lbs CO2e/MWh
CH425281400CO2
0.016N2O
0.11CH4
For Electric Generation By Fuel Type
EIAeGrideGrideGridCalculatedCalculatedCalculated
Heat Rate (Btu/kWh)Emission Factor (kg CO2/MMBtu)Emission Factor (g N2O/MMBtu)Emission Factor (g CH4/MMBtu)Emission Factor (lbs CO2/MWh)Emission Factor (lbs N2O/MWh)Emission Factor (lbs CH4/MWh)
Coal11,00093.281.61122570.0390.266
Nat. Gas CC7,70053.060.118990.0020.017
Oil11,000750.6318150.0150.073
Nuclear10,500000000
Renewables- 0000000
2021eGrideGrideGrid
Coal21510.0350.239
Nat. Gas CC8940.0020.017
Oil16670.0170.10

eGrid and Calculated Values are in close agreement.

File details come from the government source that posted it. Updated .