Amendment 0012_Solicitation 47PA0825R0002 Block and Index Calculator Spreadsheet - Block (Shaped Hedge) Index - Sample Calculations.xls

XLS spreadsheet 154 KB Posted

Attached to
FY25 GSA Streamlined Retail Electric Solicitation
Solicitation number
47PA0825R0002
Issued by
Not on record

About this file

Written by GovTribe AI ·

This file is a Block and Index Calculator Spreadsheet for the GSA's FY25 Streamlined Retail Electric Solicitation (Solicitation Number 47PA0825R0002), detailing a complex electricity procurement auction across five different pricing groups in the ISONE and CAISO regions. The solicitation covers electricity supply for utilities in Connecticut, Maine, Massachusetts, New Hampshire, and Rhode Island, with a total contract volume of 1,656,181,689 kWh across 155 accounts, and contract terms ranging from 12 to 60 months starting between September 2025 and December 2025.

The procurement uses a sophisticated "Shaped Hedge" bidding model where suppliers submit two parameters: a fixed price for the shaped hedge load and an index adder price. The calculation involves complex factors including fixed and indexed quantities, line loss adjustments, and wholesale price estimates. Bidders will participate in auctions on 7/30/25 for different pricing groups, with bid deadlines ranging from 11:05 AM to 11:30 AM EDT. The solicitation is a full requirements contract, allowing multiple awards, and requires suppliers to be licensed to provide electric supply to retail customers in the applicable states. Technical proposals are due by 3:00 PM EST on March 7, 2025.

View the file

Other files

File Type Posted
Amendment 0015_Solicitation 47PA0825R002 Exhibit 1 ISONE and CAISO Accounts.xlsx XLSX spreadsheet
Amendment 0015 Solicitation 47PA0825R0002.pdf PDF
Amendment 0015 Block and Index Calculator Spreadsheet - Block (Shaped Hedge) Index - Sample Calculations 8.5.2025.xls XLS spreadsheet
Amendment 0014_Solicitation 47PA0825R002 Exhibit 1 ISONE and CAISO Accounts.xlsx XLSX spreadsheet
Amendment 0014 Block and Index Calculator Spreadsheet - Block (Shaped Hedge) Index - Sample Calculations 7.29.2025.xls XLS spreadsheet
Amendment 0014 Solicitation 47PA0825R0002.pdf PDF
Amendment 0013_Solicitation 47PA0825R002 Exhibit 1 ISONE and CAISO Accounts (1).xlsx XLSX spreadsheet
Amendment 0013 Solicitation 47PA0825R0002.pdf PDF
Amendment 0012 Solicitation 47PA0825R0002.pdf PDF
Amendment 0012_Solicitation 47PA0825R002 Exhibit 1 ISONE and CAISO Accounts.xlsx XLSX spreadsheet
Amendment 0011 ATTACHMENT 3_ Price Component Confirmation Table.xlsx XLSX spreadsheet
Amendment 0011_ Solicitation 47PA0825R0002.pdf PDF
Amendment 0011_Solicitation 47PA0825R0002 Exhibit 1 ISONE and CAISO Accounts.xlsx XLSX spreadsheet
Amendment 0010 ATTACHMENT 3_ Price Component Confirmation Table.xlsx XLSX spreadsheet
Amendment 0010_Solicitation 47PA0825R002 Exhibit 1 ISONE and CAISO Accounts.xlsx XLSX spreadsheet
Amendment 0010_Solicitation 47PA0825R0002.pdf PDF
Amendment 0009_Solicitation 47PA0825R0002.pdf PDF
Amendment 0009_Solicitation 47PA0825R0002 Exhibit 1 PJM and ERCOT Accounts.xlsx XLSX spreadsheet
Amendment 0008_Solicitation 47PA0825R0002.pdf PDF
Amendment 0007_Solicitation 47PA0825R002 FInal Exhibit 1 PJM and ERCOT Accounts.xlsx XLSX spreadsheet
Amendment 0007_Solicitation 47PA0825R0002.pdf PDF
Amendment 0006 Solicitation 47PA0825R0002 FY25 Streamlined Electric Buy.pdf PDF
Amendment 0006_Solicitation 47PA0825R002 FInal Exhibit 1 PJM and ERCOT Accounts.xlsx XLSX spreadsheet
Amendment 0005_Solicitation 47PA0825R002 FInal Exhibit 1 PJM and ERCOT Accounts.xlsx XLSX spreadsheet
Amendment 0005 Solicitation 47PA0825R0002 FY25 Streamlined Electric Buy.pdf PDF
Amendment 0004 Solicitation 47PA0825R0002 FInal Exhibit 1 PJM and ERCOT Accounts.xlsx XLSX spreadsheet
Amendment 0004 Solicitation 47PA0825R002 FInal Exhibit 1 PJM and ERCOT Accounts.xlsx XLSX spreadsheet
Amendment 0004_Solicitation 47PA0825R0002 FY25 Streamlined Electric Buy.pdf PDF
9. Amendment 0003_Solicitation 47PA0825R002 FInal Exhibit 1 PJM & ERCOT Accounts.xlsx XLSX spreadsheet
3. Q & A 47PA0825R0002 FY25 Solicitation.pdf PDF
2. Amendment 0003_ Summary of Changes.pdf PDF
5. Amendment 0003_ Solicitation FY25 Streamlined Electric Buy.pdf PDF
9. Amendment 0003_ Solicitation 47PA0825R002 FInal Exhibit 1 PJM & ERCOT Accounts.xlsx XLSX spreadsheet
1. Amendment 0003_Standard Form 30.pdf PDF
5. Amendment 0003_Solicitation FY25 Streamlined Electric Buy.pdf PDF
4. Amendment 0003_1449 Form.pdf PDF
7. Amendment 0003_ATTACHMENT 12 Pre-Proposal Call Schedule.pdf PDF
8. Amendment 0003_ATTACHMENT 13 Preliminary Exhibit 1 .xlsx XLSX spreadsheet
3. Amendment 0003_Q & A.pdf PDF
2. Amendment 0003_Summary of Changes.pdf PDF
6. Amendment 0003_ ATTACHMENT 3_ PRICE COMPONENT CONFIRMATION TABLE.xlsx XLSX spreadsheet
Solicitation Amendment 47PA0825R0002_0002.pdf PDF
Amendment 0001_Solicitation 47PA0825R0002.pdf PDF
Attachment 3 PRICE COMPONENT CONFIRMATION TABLE.xlsx XLSX spreadsheet
Attachment 13 Preliminary Exhibit 1.xlsx XLSX spreadsheet
FY25 GSA Streamlined Retail Electric Solicitation.pdf PDF
Show all 46

On GovTribe

Work with this file

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

Text version

The file's text, extracted by GovTribe without its formatting.

Shaped Hedge Explanation

Bids will be submitted as two parameters: 1) a fixed price for the shaped hedge load and 2) an index adder price for the entire load.
The two input parameters will be used to calculate a resulting Bid Amount. This Bid Amount will be the price that bidders see as the "Low Bid" designated on the platform. Therefore, it is important that bidders fully understand the below calculation and the associated inputs:
Calculation
(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)
Inputs
1. Fixed Quantity at Meter = the volume of energy from the shaped hedge, delivered to the customer meter. Note, the shaped hedge amount purchased and delivered to the delivery point will be this amount grossed up for line losses to the customer meter.
2. Index Quantity at Meter = the volume of energy purchased for remaining load delivered to the customer meter.
3. Line Loss Adjustment = the loss factor between the delivery point and the customer meter used in the calculation.
4. Total Quantity = Fixed Quantity at Meter + Index Quantity at Meter.
5. Index Price Estimate = a forward looking estimate of the price per unit for the exposed (index) load over the term of the contract.
6. Fixed Price Bid Amount = submitted bid.
7. Adder Bid Amount = submitted bid.
Items 1-5 will be provided to you prior to the auction and displayed on the RFP View page for the event. Items 6-7 are the supplier bids submitted through the platform.
An excel spreadsheet is available upon request that can assist you with the evaluation calculation.

&C&"Arial"&8&K000000INTERNAL&1#

Block & Index & Shaped Hedg 25

Block Product ModelPLATFORM INPUTS IN BOLD BOX
SUPPLIER INPUTS SHADEDPLEASE NOTE - the Spreadsheet will be updated for each Pricing Group with Group-specific information prior to the auction date.
SAMPLELOW BID DISPLAYED
Field TypeField LabelOld ValueSample ValueUnitsNotes
CalcTotal Quantity (Term)38,782,3070kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,255kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,052kWhThe volume of load to float on a market index in units at the Meter
Enel X InputLine Loss Adjustment7.50%0.000%percent (e.g. 0.05=5%)Line losses from the utility, relative to the metered load. Note: Must convert loss factor if the utility handles the calculation differently.
Enel X InputIndex Price Estimate0.0690$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)
CalcIndexed Quantity at Delivery Point36,020,5960kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)
CalcFixed Quantity at Delivery Point5,906,2220kWh=Fixed Quantity at Meter * (1 + Line Loss Adjustment)
CalcTotal Usage at Delivery Point41,926,8180kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery Point
Supplier InputFixed Price Bid Amount ($/kWh)0.0751$/kWhSupplier Bid input for the Shaped Hedge (See GSA Solicitation Section D.1, Calculation Input item # 6
Supplier InputSupply Service Fee - Adder Bid Amount ($/kWh)0.0100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.00000$/kWh(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge
See "Explanation" tab for further details.

&C&"Arial"&8&K000000INTERNAL&1#

Auction Schedule

EXHIBIT 1 SOLICIATATION NUMBER 47PA0825R002 - ISONE & CAISO
Enel X RFP #Auction DateISO/RTOAuction Bid Deadline (EDT)Pricing GroupUtilitiesStatesAgenciesRequired Renewable Load Following Percentage (Per Section A12 of the Solicitation)Pricing Product (See Attachment 3 of the Solicitation)Billing (Per Section A.7 of the Solicitation)Term in MonthsContract Start MonthContract End MonthNo of Accounts* Contract Annual kWh Usage (Contract Volumes)Term Auction Volumes / Contract Volumes kWh Usage
988757/30/25ISONE11:05 AM1CL&P / UICT30.0%Block and IndexDual From Supplier Only60Sep-25Sep-303542,109,077210,545,385
988767/30/25ISONE11:10 AM2CMPME20.0%Block and IndexDual From Supplier Only60Sep-25Sep-30516,830,13884,150,689
988777/30/25ISONE11:15 AM3NGRID MA / NSTAR / Unitil MA / WMECOMA90.0%Block and IndexDual From Supplier Only12, 46 or 60Sep-25Sept 26, July 29 or Sept 3081177,224,627883,292,115
988787/30/25ISONE11:20 AM4PSNH / Unitil NHNH40.0%Block and IndexDual From Supplier Only60Sep-25Sep-30821,164,756105,823,780
988797/30/25ISONE11:25 AM5NGRID RIRI20.0%Block and IndexDual From Supplier Only60Sep-25Sep-30719,258,69696,293,480
988807/30/25CAISO11:30 AM6PGE / SCE / SDG&ECA10.0%Firm Fixed PriceDual From Supplier Only60Dec-25Dec-301955,215,248276,076,240
TOTALS155331,802,5421,656,181,689
1)The most recent twelve month's worth of monthly data available from the utility is included in this Exhibit 1. Interval data, for the accounts that have interval data, has been posted to the Enel X announcement site
for this procurement at:https://www.exchange.enelx.com/WebPortal/AnnouncementView.aspx?id=17150
2)Per Section D.2 (4) of the Solicitation, "The Offeror agrees to hold the prices in its price proposal firm from the time prices are submitted on auction day until 1:30 p.m. EST on each auction day."
3)* Note: This is a full requirements contract, the " Contract Annual kWh Usage (Contract Volumes)" must be used for contracting purposes in relation to Section A.13 Load Changes.

https://www.exchange.enelx.com/WebPortal/AnnouncementView.aspx?id=17150

Group 1 - RFP 98875

Block Product ModelPLATFORM INPUTS IN BOLD BOX
SUPPLIER INPUTS SHADEDPLEASE NOTE - the Spreadsheet will be updated for each Pricing Group with Group-specific information prior to the auction date.
LOW BID DISPLAYED
Field TypeField LabelOld ValueSample ValueUnitsNotes
CalcTotal Quantity (Term)38,782,307210,545,385kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,25578,401,799kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,052132,143,587kWhThe volume of load to float on a market index in units at the Meter
Enel X InputLine Loss Adjustment7.50%0.000%percent (e.g. 0.05=5%)Line losses from the utility, relative to the metered load. Note: Must convert loss factor if the utility handles the calculation differently.
Enel X InputIndex Price Estimate0.06900.0471$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Historical Annual kWh Usage (for reference only)Month
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,596132,143,587kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)1ISONE6/1/24N/A3,218,5683,165,2682,984,4703,082,8163,403,6914,357,2524,610,2574,315,7143,559,8123,290,5152,983,0393,137,67542,109,077
CalcFixed Quantity at Delivery Point5,906,22278,401,799kWh=Fixed Quantity at Meter * (1 + Line Loss Adjustment)Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%
CalcTotal Usage at Delivery Point41,926,818210,545,385kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery PointHedge Vol2,735,7832,690,478- 0- 0- 0- 03,918,7183,668,357- 0- 0- 02,667,02415,680,36078,401,799
Supplier InputFixed Price Bid Amount ($/kWh)0.0751$/kWhSupplier Bid input for the Shaped Hedge (See GSA Solicitation Section D.1, Calculation Input item # 6Index Vol482,785474,7902,984,4703,082,8163,403,6914,357,252691,539647,3573,559,8123,290,5152,983,039470,65126,428,717132,143,587
Supplier InputSupply Service Fee - Adder Bid Amount ($/kWh)0.0100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.02954$/kWh(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge
See "Explanation" tab for further details.
CT
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
9202503,559,812$ 42.322%$ 43.17$ 153,671.53
10202503,290,515$ 41.332%$ 42.16$ 138,712.59
11202502,983,039$ 59.572%$ 60.76$ 181,240.46
1220252667023.75470,651$ 100.572%$ 102.58$ 48,280.37
120262735782.8482785.2$ 137.192%$ 139.93$ 67,558.44
220262690477.8474790.2$ 116.042%$ 118.36$ 56,197.93
3202602984470$ 64.602%$ 65.89$ 196,650.32
4202603082816$ 47.732%$ 48.69$ 150,093.35
5202603403691$ 41.652%$ 42.48$ 144,589.67
6202604357252$ 46.802%$ 47.73$ 207,978.03
720263918718.45691538.55$ 65.012%$ 66.31$ 45,853.18
820263668356.9647357.1$ 53.272%$ 54.33$ 35,172.70
9202603559812$ 43.902%$ 44.78$ 159,398.84
10202603290515$ 42.202%$ 43.04$ 141,631.51
11202602983039$ 57.892%$ 59.05$ 176,144.93
1220262667023.75470651.25$ 84.402%$ 86.09$ 40,516.50
120272735782.8482785.2$ 138.372%$ 141.14$ 68,139.63
220272690477.8474790.2$ 116.462%$ 118.79$ 56,399.26
3202702984470$ 56.242%$ 57.37$ 171,209.63
4202703082816$ 41.192%$ 42.01$ 129,515.22
5202703403691$ 34.782%$ 35.48$ 120,748.35
6202704357252$ 39.592%$ 40.38$ 175,934.91
720273918718.45691538.55$ 58.272%$ 59.43$ 41,101.42
820273668356.9647357.1$ 52.682%$ 53.73$ 34,784.54
9202703559812$ 38.572%$ 39.34$ 140,057.67
10202703290515$ 37.672%$ 38.42$ 126,420.86
11202702983039$ 50.082%$ 51.09$ 152,391.99
1220272667023.75470651.25$ 75.512%$ 77.02$ 36,250.01
120282735782.8482785.2$ 132.692%$ 135.34$ 65,340.55
220282690477.8474790.2$ 126.772%$ 129.31$ 61,392.77
3202802984470$ 43.492%$ 44.36$ 132,378.49
4202803082816$ 36.712%$ 37.44$ 115,419.60
5202803403691$ 34.632%$ 35.32$ 120,228.71
6202804357252$ 38.332%$ 39.10$ 170,363.61
720283918718.45691538.55$ 54.542%$ 55.63$ 38,471.83
820283668356.9647357.1$ 51.452%$ 52.48$ 33,971.23
9202803559812$ 36.442%$ 37.16$ 132,297.80
10202803290515$ 35.982%$ 36.70$ 120,757.34
11202802983039$ 47.032%$ 47.97$ 143,090.19
1220282667023.75470651.25$ 65.402%$ 66.71$ 31,396.87
120292735782.8482785.2$ 126.032%$ 128.55$ 62,061.96
220292690477.8474790.2$ 122.712%$ 125.16$ 59,425.12
3202902984470$ 48.452%$ 49.41$ 147,476.82
4202903082816$ 36.282%$ 37.01$ 114,085.65
5202903403691$ 34.052%$ 34.73$ 118,226.28
6202904357252$ 36.262%$ 36.99$ 161,165.69
720293918718.45691538.55$ 51.992%$ 53.03$ 36,671.24
820293668356.9647357.1$ 47.842%$ 48.80$ 31,588.39
9202903559812$ 34.452%$ 35.13$ 125,073.71
10202903290515$ 33.952%$ 34.63$ 113,954.82
11202902983039$ 44.722%$ 45.61$ 136,068.06
1220292667023.75470651.25$ 63.682%$ 64.96$ 30,571.68
120302735782.8482785.2$ 133.732%$ 136.41$ 65,856.45
220302690477.8474790.2$ 126.502%$ 129.03$ 61,262.18
3203002984470$ 49.342%$ 50.33$ 150,208.66
4203003082816$ 35.292%$ 35.99$ 110,954.45
5203003403691$ 32.582%$ 33.23$ 113,097.78
6203004357252$ 34.562%$ 35.25$ 153,608.24
720303918718.45691538.55$ 50.632%$ 51.65$ 35,714.52
820303668356.9647357.1$ 45.682%$ 46.59$ 30,160.07
Total Index6,218,984.65
Total78,401,799132,143,586$/kWh$ 0.04706
210,545,385

&C&"Arial"&8&K000000INTERNAL&1#

Group 2 - RFP 98876

Block Product ModelPLATFORM INPUTS IN BOLD BOX
SUPPLIER INPUTS SHADEDPLEASE NOTE - the Spreadsheet will be updated for each Pricing Group with Group-specific information prior to the auction date.
LOW BID DISPLAYED
Field TypeField LabelOld ValueSample ValueUnitsNotes
CalcTotal Quantity (Term)38,782,30784,150,689kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,25531,191,334kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,05252,959,355kWhThe volume of load to float on a market index in units at the Meter
Enel X InputLine Loss Adjustment7.50%0.000%percent (e.g. 0.05=5%)Line losses from the utility, relative to the metered load. Note: Must convert loss factor if the utility handles the calculation differently.
Enel X InputIndex Price Estimate0.06900.0457$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Historical Annual kWh Usage (for reference only)Month
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,59652,959,355kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)2ISONE6/1/24N/A1,184,0641,262,4341,172,931956,7841,379,2681,742,7421,970,4701,796,9521,689,9191,261,5281,287,8281,125,21816,830,138
CalcFixed Quantity at Delivery Point5,906,22231,191,334kWh=Fixed Quantity at Meter * (1 + Line Loss Adjustment)Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%
CalcTotal Usage at Delivery Point41,926,81884,150,689kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery PointHedge Vol1,006,4541,073,069- 0- 0- 0- 01,674,9001,527,409- 0- 0- 0956,4356,238,26731,191,334
Supplier InputFixed Price Bid Amount ($/kWh)0.0751$/kWhSupplier Bid input for the Shaped Hedge (See GSA Solicitation Section D.1, Calculation Input item # 6Index Vol177,610189,3651,172,931956,7841,379,2681,742,742295,571269,5431,689,9191,261,5281,287,828168,78310,591,87152,959,355
Supplier InputSupply Service Fee - Adder Bid Amount ($/kWh)0.0100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.02879$/kWh(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge
See "Explanation" tab for further details.
ME
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 01,689,919$ 42.222%$ 43.06$ 72,770.75
102025- 01,261,528$ 41.482%$ 42.31$ 53,376.84
112025- 01,287,828$ 59.562%$ 60.75$ 78,232.31
122025956,435168,783$ 101.302%$ 103.32$ 17,439.03
120261,006,454177,610$ 136.772%$ 139.50$ 24,777.20
220261,073,069189,365$ 115.532%$ 117.84$ 22,314.99
32026- 01,172,931$ 64.932%$ 66.23$ 77,682.50
42026- 0956,784$ 47.772%$ 48.73$ 46,622.50
52026- 01,379,268$ 41.702%$ 42.54$ 58,672.57
62026- 01,742,742$ 46.472%$ 47.40$ 82,612.84
720261,674,900295,571$ 65.032%$ 66.33$ 19,605.34
820261,527,409269,543$ 53.342%$ 54.41$ 14,665.85
92026- 01,689,919$ 43.822%$ 44.69$ 75,528.70
102026- 01,261,528$ 42.182%$ 43.03$ 54,279.23
112026- 01,287,828$ 58.052%$ 59.21$ 76,249.60
122026956,435168,783$ 84.672%$ 86.36$ 14,576.00
120271,006,454177,610$ 133.342%$ 136.00$ 24,155.31
220271,073,069189,365$ 111.732%$ 113.96$ 21,580.37
32027- 01,172,931$ 54.162%$ 55.24$ 64,791.07
42027- 0956,784$ 39.352%$ 40.14$ 38,404.61
52027- 01,379,268$ 33.252%$ 33.91$ 46,776.80
62027- 01,742,742$ 37.892%$ 38.65$ 67,354.73
720271,674,900295,571$ 56.922%$ 58.06$ 17,161.33
820271,527,409269,543$ 51.412%$ 52.44$ 14,133.72
92027- 01,689,919$ 37.072%$ 37.81$ 63,891.31
102027- 01,261,528$ 36.232%$ 36.95$ 46,619.69
112027- 01,287,828$ 48.522%$ 49.49$ 63,738.59
122027956,435168,783$ 73.402%$ 74.87$ 12,636.66
120281,006,454177,610$ 125.652%$ 128.16$ 22,762.97
220281,073,069189,365$ 120.012%$ 122.41$ 23,180.29
32028- 01,172,931$ 40.712%$ 41.53$ 48,707.25
42028- 0956,784$ 35.352%$ 36.06$ 34,497.68
52028- 01,379,268$ 33.672%$ 34.34$ 47,367.07
62028- 01,742,742$ 37.142%$ 37.88$ 66,014.03
720281,674,900295,571$ 53.832%$ 54.91$ 16,229.88
820281,527,409269,543$ 50.882%$ 51.90$ 13,989.51
92028- 01,689,919$ 35.392%$ 36.10$ 61,002.36
102028- 01,261,528$ 34.852%$ 35.54$ 44,839.82
112028- 01,287,828$ 45.642%$ 46.55$ 59,953.04
122028956,435168,783$ 63.072%$ 64.33$ 10,857.43
120291,006,454177,610$ 121.052%$ 123.47$ 21,930.17
220291,073,069189,365$ 115.742%$ 118.06$ 22,355.64
32029- 01,172,931$ 45.592%$ 46.50$ 54,543.57
42029- 0956,784$ 34.842%$ 35.54$ 34,002.34
52029- 01,379,268$ 33.022%$ 33.68$ 46,452.17
62029- 01,742,742$ 34.972%$ 35.67$ 62,163.75
720291,674,900295,571$ 51.242%$ 52.26$ 15,447.25
820291,527,409269,543$ 47.162%$ 48.10$ 12,965.04
92029- 01,689,919$ 33.382%$ 34.04$ 57,533.09
102029- 01,261,528$ 32.742%$ 33.40$ 42,128.77
112029- 01,287,828$ 43.272%$ 44.14$ 56,841.12
122029956,435168,783$ 61.262%$ 62.48$ 10,546.14
120301,006,454177,610$ 126.282%$ 128.80$ 22,876.23
220301,073,069189,365$ 119.332%$ 121.72$ 23,049.34
32030- 01,172,931$ 46.412%$ 47.33$ 55,519.75
42030- 0956,784$ 33.872%$ 34.55$ 33,058.30
52030- 01,379,268$ 31.592%$ 32.22$ 44,446.57
62030- 01,742,742$ 33.312%$ 33.98$ 59,217.68
720301,674,900295,571$ 49.932%$ 50.93$ 15,053.87
820301,527,409269,543$ 45.012%$ 45.91$ 12,373.61
Total Index2,422,556.13
Total31,191,33452,959,355$/kWh$ 0.04574
84,150,689

&C&"Arial"&8&K000000INTERNAL&1#

Group 3 - RFP 98877

Block Product ModelPLATFORM INPUTS IN BOLD BOX
SUPPLIER INPUTS SHADEDPLEASE NOTE - the Spreadsheet will be updated for each Pricing Group with Group-specific information prior to the auction date.
LOW BID DISPLAYED
Field TypeField LabelOld ValueSample ValueUnitsNotes
CalcTotal Quantity (Term)38,782,307883,292,115kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,255326,072,908kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,052557,219,207kWhThe volume of load to float on a market index in units at the Meter
Enel X InputLine Loss Adjustment7.50%0.000%percent (e.g. 0.05=5%)Line losses from the utility, relative to the metered load. Note: Must convert loss factor if the utility handles the calculation differently.
Enel X InputIndex Price Estimate0.06900.0481$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Historical Annual kWh Usage (for reference only)Month
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,596557,219,207kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)3ISONE6/1/24N/A13,492,90612,624,58012,835,09214,115,59913,804,86517,471,32620,296,75716,994,34414,164,45914,096,12113,447,92313,314,449176,658,423
CalcFixed Quantity at Delivery Point5,906,222326,072,908kWh=Fixed Quantity at Meter * (1 + Line Loss Adjustment)Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%
CalcTotal Usage at Delivery Point41,926,818883,292,115kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery PointHedge Vol11,468,97010,730,893- 0- 0- 0- 017,252,24414,445,193- 0- 0- 011,317,28265,214,582326,072,908
Supplier InputFixed Price Bid Amount ($/kWh)0.0751$/kWhSupplier Bid input for the Shaped Hedge (See GSA Solicitation Section D.1, Calculation Input item # 6Index Vol2,023,9361,893,68712,835,09214,115,59913,804,86517,471,3263,044,5142,549,15214,164,45914,096,12113,447,9231,997,167111,443,841557,219,207
Supplier InputSupply Service Fee - Adder Bid Amount ($/kWh)0.0100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.03033$/kWh(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge
See "Explanation" tab for further details.
MA
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 014,164,459$ 41.882%$ 42.72$ 605,119.87
102025- 014,096,121$ 41.502%$ 42.33$ 596,691.89
112025- 013,447,923$ 59.522%$ 60.71$ 816,417.96
12202511,317,2821,997,167$ 101.282%$ 103.30$ 206,315.07
1202611,468,9702,023,936$ 137.222%$ 139.97$ 283,288.30
2202610,730,8931,893,687$ 115.062%$ 117.36$ 222,250.90
32026- 012,835,092$ 66.742%$ 68.07$ 873,698.54
42026- 014,115,599$ 48.652%$ 49.62$ 700,404.00
52026- 013,804,865$ 42.692%$ 43.54$ 601,116.30
62026- 017,471,326$ 47.712%$ 48.66$ 850,196.42
7202617,252,2443,044,514$ 66.432%$ 67.76$ 206,305.34
8202614,445,1932,549,152$ 54.072%$ 55.15$ 140,590.96
92026- 014,164,459$ 44.542%$ 45.43$ 643,464.19
102026- 014,096,121$ 43.152%$ 44.01$ 620,360.00
112026- 013,447,923$ 59.352%$ 60.53$ 814,062.69
12202611,317,2821,997,167$ 85.772%$ 87.48$ 174,714.66
1202711,468,9702,023,936$ 126.312%$ 128.83$ 260,751.77
2202710,730,8931,893,687$ 103.172%$ 105.24$ 199,284.64
32027- 012,835,092$ 59.382%$ 60.57$ 777,379.94
42027- 014,115,599$ 43.712%$ 44.58$ 629,323.11
52027- 013,804,865$ 37.042%$ 37.78$ 521,528.57
62027- 017,471,326$ 41.512%$ 42.34$ 739,771.12
7202717,252,2443,044,514$ 60.742%$ 61.96$ 188,633.25
8202714,445,1932,549,152$ 54.182%$ 55.26$ 140,868.59
92027- 014,164,459$ 40.552%$ 41.36$ 585,894.73
102027- 014,096,121$ 40.322%$ 41.13$ 579,787.64
112027- 013,447,923$ 52.702%$ 53.75$ 722,886.33
12202711,317,2821,997,167$ 77.902%$ 79.46$ 158,687.86
1202811,468,9702,023,936$ 114.402%$ 116.69$ 236,179.02
2202810,730,8931,893,687$ 107.262%$ 109.40$ 207,169.88
32028- 012,835,092$ 45.522%$ 46.43$ 595,988.83
42028- 014,115,599$ 38.022%$ 38.78$ 547,344.60
52028- 013,804,865$ 35.822%$ 36.53$ 504,310.43
62028- 017,471,326$ 38.832%$ 39.61$ 692,039.22
7202817,252,2443,044,514$ 53.782%$ 54.85$ 166,995.93
8202814,445,1932,549,152$ 49.992%$ 50.99$ 129,981.29
92028- 014,164,459$ 36.972%$ 37.71$ 534,181.42
102028- 014,096,121$ 36.992%$ 37.72$ 531,774.25
112028- 013,447,923$ 47.652%$ 48.60$ 653,586.78
12202811,317,2821,997,167$ 69.312%$ 70.69$ 141,183.82
1202911,468,9702,023,936$ 111.572%$ 113.80$ 230,327.85
2202910,730,8931,893,687$ 104.522%$ 106.61$ 201,895.01
32029- 012,835,092$ 53.022%$ 54.08$ 694,073.32
42029- 014,115,599$ 37.812%$ 38.57$ 544,452.22
52029- 013,804,865$ 35.412%$ 36.12$ 498,612.94
62029- 017,471,326$ 37.282%$ 38.02$ 664,286.37
7202917,252,2443,044,514$ 50.312%$ 51.32$ 156,236.88
8202914,445,1932,549,152$ 45.552%$ 46.46$ 118,427.75
92029- 014,164,459$ 35.392%$ 36.10$ 511,312.24
102029- 014,096,121$ 35.812%$ 36.53$ 514,934.93
112029- 013,447,923$ 46.112%$ 47.03$ 632,464.11
12202911,317,2821,997,167$ 71.162%$ 72.59$ 144,969.34
1203011,468,9702,023,936$ 112.592%$ 114.84$ 232,423.57
2203010,730,8931,893,687$ 105.132%$ 107.23$ 203,067.74
32030- 012,835,092$ 52.372%$ 53.42$ 685,634.49
42030- 014,115,599$ 37.582%$ 38.33$ 541,108.70
52030- 013,804,865$ 35.022%$ 35.72$ 493,145.59
62030- 017,471,326$ 36.442%$ 37.17$ 649,328.82
7203017,252,2443,044,514$ 49.312%$ 50.30$ 153,133.81
8203014,445,1932,549,152$ 45.232%$ 46.14$ 117,608.56
Total Index26,787,974.38
Total326,072,908557,219,207$/kWh$ 0.04807

&C&"Arial"&8&K000000INTERNAL&1#

Group 4 - RFP 98878

Block Product ModelPLATFORM INPUTS IN BOLD BOX
SUPPLIER INPUTS SHADEDPLEASE NOTE - the Spreadsheet will be updated for each Pricing Group with Group-specific information prior to the auction date.
LOW BID DISPLAYED
Field TypeField LabelOld ValueSample ValueUnitsNotes
CalcTotal Quantity (Term)38,782,307105,823,780kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,25537,870,403kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,05267,953,377kWhThe volume of load to float on a market index in units at the Meter
Enel X InputLine Loss Adjustment7.50%0.000%percent (e.g. 0.05=5%)Line losses from the utility, relative to the metered load. Note: Must convert loss factor if the utility handles the calculation differently.
Enel X InputIndex Price Estimate0.06900.0433$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Historical Annual kWh Usage (for reference only)Month
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,59667,953,377kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)4ISONE6/1/24N/A1,734,3311,495,2821,875,7531,652,7111,613,3972,070,6631,879,2302,094,8201,849,9211,599,7971,591,8311,707,02021,164,756
CalcFixed Quantity at Delivery Point5,906,22237,870,403kWh=Fixed Quantity at Meter * (1 + Line Loss Adjustment)Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%
CalcTotal Usage at Delivery Point41,926,818105,823,780kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery PointHedge Vol1,474,1811,270,990- 0- 0- 0- 01,597,3461,780,597- 0- 0- 01,450,9677,574,08137,870,403
Supplier InputFixed Price Bid Amount ($/kWh)0.0751$/kWhSupplier Bid input for the Shaped Hedge (See GSA Solicitation Section D.1, Calculation Input item # 6Index Vol260,150224,2921,875,7531,652,7111,613,3972,070,663281,885314,2231,849,9211,599,7971,591,831256,05313,590,67567,953,377
Supplier InputSupply Service Fee - Adder Bid Amount ($/kWh)0.0100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.02778$/kWh(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)4+J12:N1
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge257149.65221472.31856553163511115905972049463277864.5310503182912115833971575831253473
See "Explanation" tab for further details.
NH
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 01,849,921$ 42.062%$ 42.91$ 79,371.38
102025- 01,599,797$ 41.772%$ 42.60$ 68,154.90
112025- 01,591,831$ 59.222%$ 60.41$ 96,155.76
1220251,450,967256,053$ 100.982%$ 103.00$ 26,373.50
120261,474,181260,150$ 135.332%$ 138.04$ 35,910.26
220261,270,990224,292$ 113.962%$ 116.23$ 26,070.58
32026- 01,875,753$ 63.812%$ 65.09$ 122,089.32
42026- 01,652,711$ 46.942%$ 47.88$ 79,135.81
52026- 01,613,397$ 41.252%$ 42.07$ 67,875.72
62026- 02,070,663$ 46.272%$ 47.20$ 97,729.05
720261,597,346281,885$ 64.932%$ 66.23$ 18,668.54
820261,780,597314,223$ 52.822%$ 53.88$ 16,928.79
92026- 01,849,921$ 43.272%$ 44.14$ 81,650.78
102026- 01,599,797$ 41.692%$ 42.52$ 68,024.71
112026- 01,591,831$ 56.932%$ 58.07$ 92,441.41
1220261,450,967256,053$ 83.302%$ 84.97$ 21,756.39
120271,474,181260,150$ 126.622%$ 129.15$ 33,597.92
220271,270,990224,292$ 105.182%$ 107.29$ 24,063.76
32027- 01,875,753$ 50.502%$ 51.50$ 96,610.61
42027- 01,652,711$ 36.682%$ 37.41$ 61,833.49
52027- 01,613,397$ 31.262%$ 31.88$ 51,441.36
62027- 02,070,663$ 35.852%$ 36.57$ 75,717.00
720271,597,346281,885$ 54.212%$ 55.29$ 15,586.39
820271,780,597314,223$ 48.622%$ 49.59$ 15,581.83
92027- 01,849,921$ 34.702%$ 35.39$ 65,467.30
102027- 01,599,797$ 33.952%$ 34.63$ 55,401.48
112027- 01,591,831$ 45.092%$ 45.99$ 73,215.11
1220271,450,967256,053$ 68.722%$ 70.09$ 17,947.04
120281,474,181260,150$ 119.402%$ 121.79$ 31,682.42
220281,270,990224,292$ 113.902%$ 116.18$ 26,058.94
32028- 01,875,753$ 36.172%$ 36.89$ 69,193.56
42028- 01,652,711$ 31.332%$ 31.96$ 52,813.15
52028- 01,613,397$ 30.452%$ 31.06$ 50,118.28
62028- 02,070,663$ 33.772%$ 34.45$ 71,325.28
720281,597,346281,885$ 49.502%$ 50.49$ 14,232.16
820281,780,597314,223$ 46.332%$ 47.26$ 14,849.08
92028- 01,849,921$ 31.692%$ 32.32$ 59,798.57
102028- 01,599,797$ 31.302%$ 31.93$ 51,077.40
112028- 01,591,831$ 40.812%$ 41.63$ 66,268.81
1220281,450,967256,053$ 56.012%$ 57.13$ 14,628.95
120291,474,181260,150$ 114.862%$ 117.15$ 30,477.18
220291,270,990224,292$ 109.802%$ 112.00$ 25,119.62
32029- 01,875,753$ 40.972%$ 41.79$ 78,395.79
42029- 01,652,711$ 30.732%$ 31.35$ 51,810.31
52029- 01,613,397$ 29.762%$ 30.36$ 48,979.24
62029- 02,070,663$ 31.602%$ 32.23$ 66,734.57
720291,597,346281,885$ 46.782%$ 47.71$ 13,449.36
820291,780,597314,223$ 42.592%$ 43.44$ 13,650.55
92029- 01,849,921$ 29.602%$ 30.20$ 55,861.62
102029- 01,599,797$ 29.112%$ 29.69$ 47,499.74
112029- 01,591,831$ 38.402%$ 39.17$ 62,349.31
1220291,450,967256,053$ 54.132%$ 55.22$ 14,137.97
120301,474,181260,150$ 119.792%$ 122.19$ 31,787.51
220301,270,990224,292$ 113.182%$ 115.45$ 25,893.44
32030- 01,875,753$ 41.712%$ 42.54$ 79,798.96
42030- 01,652,711$ 29.882%$ 30.48$ 50,375.16
52030- 01,613,397$ 28.472%$ 29.04$ 46,848.01
62030- 02,070,663$ 30.112%$ 30.72$ 63,601.66
720301,597,346281,885$ 45.602%$ 46.51$ 13,111.60
820301,780,597314,223$ 40.642%$ 41.45$ 13,023.87
Total Index2,939,752.24
Total37,870,40367,953,377$/kWh$ 0.04326
105,823,780

&C&"Arial"&8&K000000INTERNAL&1#

Group 5 - RFP 98879

Block Product ModelPLATFORM INPUTS IN BOLD BOX
SUPPLIER INPUTS SHADEDPLEASE NOTE - the Spreadsheet will be updated for each Pricing Group with Group-specific information prior to the auction date.
LOW BID DISPLAYED
Field TypeField LabelOld ValueSample ValueUnitsNotes
CalcTotal Quantity (Term)38,782,30796,293,480kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,25538,027,993kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,05258,265,487kWhThe volume of load to float on a market index in units at the Meter
Enel X InputLine Loss Adjustment7.50%0.000%percent (e.g. 0.05=5%)Line losses from the utility, relative to the metered load. Note: Must convert loss factor if the utility handles the calculation differently.
Enel X InputIndex Price Estimate0.06900.0423$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Historical Annual kWh Usage (for reference only)Month
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,59658,265,487kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)5ISONE6/1/24N/A1,438,5201,298,0001,360,6001,320,9201,402,3601,691,3202,048,8801,748,0801,718,9601,459,0801,357,6932,414,28319,258,696
CalcFixed Quantity at Delivery Point5,906,22238,027,993kWh=Fixed Quantity at Meter * (1 + Line Loss Adjustment)Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%
CalcTotal Usage at Delivery Point41,926,81896,293,480kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery PointHedge Vol1,222,7421,103,300- 0- 0- 0- 01,741,5481,485,868- 0- 0- 02,052,1417,605,59938,027,993
Supplier InputFixed Price Bid Amount ($/kWh)0.0751$/kWhSupplier Bid input for the Shaped Hedge (See GSA Solicitation Section D.1, Calculation Input item # 6Index Vol215,778194,7001,360,6001,320,9201,402,3601,691,320307,332262,2121,718,9601,459,0801,357,693362,14211,653,09758,265,487
Supplier InputSupply Service Fee - Adder Bid Amount ($/kWh)0.0100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.02560$/kWh(Low Bid displayed) = ((Fixed Quantity at Meter * (1 + Line Loss Adjustment) * Fixed Price Bid Amount) + (Index Quantity at Meter * (1 + Line Loss Adjustment) * Index Wholesale Price Estimate) + (Total Quantity at Meter * (1 + Line Loss Adjustment) * Adder Bid Amount))/Total Quantity at Meter (Term)
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge
See "Explanation" tab for further details.
RI
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 01,718,960$ 42.042%$ 42.88$ 73,710.38
102025- 01,459,080$ 41.332%$ 42.16$ 61,512.25
112025- 01,357,693$ 59.452%$ 60.64$ 82,333.28
1220252,052,141362,142$ 100.692%$ 102.71$ 37,194.80
120261,222,742215,778$ 135.272%$ 137.98$ 29,772.91
220261,103,300194,700$ 113.552%$ 115.82$ 22,550.06
32026- 01,360,600$ 63.102%$ 64.37$ 87,575.76
42026- 01,320,920$ 46.552%$ 47.49$ 62,723.99
52026- 01,402,360$ 40.962%$ 41.78$ 58,587.48
62026- 01,691,320$ 45.732%$ 46.64$ 78,883.28
720261,741,548307,332$ 63.932%$ 65.21$ 20,040.02
820261,485,868262,212$ 52.012%$ 53.05$ 13,909.71
92026- 01,718,960$ 42.832%$ 43.68$ 75,088.50
102026- 01,459,080$ 41.152%$ 41.97$ 61,238.76
112026- 01,357,693$ 56.692%$ 57.82$ 78,500.96
1220262,052,141362,142$ 82.322%$ 83.96$ 30,406.21
120271,222,742215,778$ 125.912%$ 128.43$ 27,712.76
220271,103,300194,700$ 103.842%$ 105.92$ 20,622.66
32027- 01,360,600$ 49.562%$ 50.55$ 68,777.89
42027- 01,320,920$ 36.172%$ 36.89$ 48,732.93
52027- 01,402,360$ 30.852%$ 31.46$ 44,122.83
62027- 01,691,320$ 35.122%$ 35.83$ 60,592.89
720271,741,548307,332$ 53.012%$ 54.07$ 16,617.70
820271,485,868262,212$ 47.482%$ 48.43$ 12,698.10
92027- 01,718,960$ 34.062%$ 34.74$ 59,710.55
102027- 01,459,080$ 33.392%$ 34.05$ 49,687.77
112027- 01,357,693$ 44.562%$ 45.46$ 61,714.42
1220272,052,141362,142$ 67.382%$ 68.73$ 24,888.63
120281,222,742215,778$ 114.292%$ 116.58$ 25,154.42
220281,103,300194,700$ 108.712%$ 110.88$ 21,588.40
32028- 01,360,600$ 33.992%$ 34.67$ 47,173.67
42028- 01,320,920$ 29.732%$ 30.33$ 40,060.86
52028- 01,402,360$ 28.922%$ 29.50$ 41,366.61
62028- 01,691,320$ 32.072%$ 32.71$ 55,326.21
720281,741,548307,332$ 46.932%$ 47.87$ 14,711.35
820281,485,868262,212$ 43.972%$ 44.85$ 11,758.96
92028- 01,718,960$ 30.092%$ 30.69$ 52,750.18
102028- 01,459,080$ 29.622%$ 30.21$ 44,084.87
112028- 01,357,693$ 39.112%$ 39.89$ 54,157.86
1220282,052,141362,142$ 53.032%$ 54.09$ 19,587.75
120291,222,742215,778$ 110.042%$ 112.24$ 24,218.76
220291,103,300194,700$ 104.722%$ 106.82$ 20,796.95
32029- 01,360,600$ 38.912%$ 39.69$ 54,002.23
42029- 01,320,920$ 29.262%$ 29.84$ 39,420.43
52029- 01,402,360$ 28.282%$ 28.85$ 40,451.92
62029- 01,691,320$ 29.982%$ 30.58$ 51,715.29
720291,741,548307,332$ 44.322%$ 45.20$ 13,892.36
820291,485,868262,212$ 40.352%$ 41.15$ 10,790.97
92029- 01,718,960$ 28.052%$ 28.61$ 49,178.05
102029- 01,459,080$ 27.532%$ 28.08$ 40,974.40
112029- 01,357,693$ 36.792%$ 37.53$ 50,953.36
1220292,052,141362,142$ 51.262%$ 52.28$ 18,932.86
120301,222,742215,778$ 114.772%$ 117.07$ 25,260.78
220301,103,300194,700$ 107.962%$ 110.12$ 21,441.15
32030- 01,360,600$ 39.572%$ 40.36$ 54,917.44
42030- 01,320,920$ 28.492%$ 29.06$ 38,380.88
52030- 01,402,360$ 27.052%$ 27.59$ 38,688.36
62030- 01,691,320$ 28.542%$ 29.11$ 49,241.43
720301,741,548307,332$ 43.272%$ 44.14$ 13,565.70
820301,485,868262,212$ 38.462%$ 39.23$ 10,287.37
Total Index2,464,739.34
Total38,027,99358,265,487$/kWh$ 0.04230
96,293,480

&C&"Arial"&8&K000000INTERNAL&1#

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