Amendment 0015 Block and Index Calculator Spreadsheet - Block (Shaped Hedge) Index - Sample Calculations 8.5.2025.xls

XLS spreadsheet 164 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 an Amendment 0015 Block and Index Calculator Spreadsheet for a GSA Retail Electric Solicitation (Solicitation Number 47PA0825R002) covering electricity supply contracts for multiple utility service territories in New England (CT, ME, MA, NH, RI) and California. The solicitation involves a Block and Index pricing model where suppliers submit two pricing parameters: a fixed price for a shaped hedge load and an index adder price, with auctions scheduled for August 13, 2025, across six pricing groups representing different utilities and states.

The contract offers full requirements electricity supply for 60-month terms starting September 2025, with total contract annual usage of approximately 1.65 billion kWh across 154 accounts. The pricing groups include Connecticut Light & Power/United Illuminating, Central Maine Power, National Grid/NSTAR/Unitil in Massachusetts, Public Service of New Hampshire, Rhode Island National Grid, and California utilities like PG&E, SCE, and SDG&E. The solicitation allows multiple awards, with suppliers required to be licensed in applicable states to provide retail electric supply, and bids will be evaluated using a complex calculation method that factors fixed quantities, index quantities, line loss adjustments, and wholesale price estimates.

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 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 0012_Solicitation 47PA0825R0002 Block and Index Calculator Spreadsheet - Block (Shaped Hedge) Index - Sample Calculations.xls XLS 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.

8.5.25 Version Changes

8/5/2015 Changes
1) Updated volumes in Auction Schedule (for MA & CA), and updated auction date
2) Updated volumes shown in Group 3
3) Updated formulas in E17 and wording in G17

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
988758/13/25ISONE11:05 AM1CL&P / UICT30.0%Block and IndexDual From Supplier Only60Sep-25Sep-303542,109,077210,545,385
988768/13/25ISONE11:10 AM2CMPME20.0%Block and IndexDual From Supplier Only60Sep-25Sep-30516,830,13884,150,689
988778/13/25ISONE11:15 AM3NGRID MA / NSTAR / Unitil MA / WMECOMA90.0%Block and IndexDual From Supplier Only12, 46 or 60Sep-25Sept 26, July 29 or Sept 3080176,981,663881,281,255
988788/13/25ISONE11:20 AM4PSNH / Unitil NHNH40.0%Block and IndexDual From Supplier Only60Sep-25Sep-30821,164,756105,823,780
988798/13/25ISONE11:25 AM5NGRID RIRI20.0%Block and IndexDual From Supplier Only60Sep-25Sep-30718,122,69690,613,480
988808/13/25CAISO11:30 AM6PGE / SCE / SDG&ECA10.0%Firm Fixed PriceDual From Supplier Only60Dec-25Dec-301955,215,248275,189,042
TOTALS154330,423,5781,647,603,631
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.0463$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Contract Annual kWh Usage (Contract Volumes)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.01000.00100$/kWhSupplier Bid input for the Supply Service Fee Bid (See GSA Solicitation Section D.1, Calculation Input item #7
CalcBid Amount ($/kWh)0.085520.03004$/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 * 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 7/25/25
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 03,559,812$ 41.462%$ 42.29$ 150,531.92
102025- 03,290,515$ 38.692%$ 39.46$ 129,854.78
112025- 02,983,039$ 54.262%$ 55.35$ 165,111.79
1220252,667,024470,651$ 94.332%$ 96.22$ 45,285.91
120262,735,783482,785$ 128.372%$ 130.94$ 63,215.43
220262,690,478474,790$ 106.462%$ 108.59$ 51,556.40
32026- 02,984,470$ 61.572%$ 62.80$ 187,418.94
42026- 03,082,816$ 46.862%$ 47.80$ 147,351.37
52026- 03,403,691$ 40.742%$ 41.56$ 141,456.50
62026- 04,357,252$ 47.302%$ 48.25$ 210,230.84
720263,918,718691,539$ 66.452%$ 67.77$ 46,868.76
820263,668,357647,357$ 54.662%$ 55.76$ 36,093.72
92026- 03,559,812$ 42.042%$ 42.88$ 152,630.64
102026- 03,290,515$ 40.392%$ 41.20$ 135,573.53
112026- 02,983,039$ 57.192%$ 58.34$ 174,025.80
1220262,667,024470,651$ 84.532%$ 86.23$ 40,581.95
120272,735,783482,785$ 133.842%$ 136.51$ 65,907.02
220272,690,478474,790$ 112.652%$ 114.90$ 54,553.43
32027- 02,984,470$ 58.062%$ 59.22$ 176,752.99
42027- 03,082,816$ 41.652%$ 42.48$ 130,955.39
52027- 03,403,691$ 35.462%$ 36.17$ 123,113.63
62027- 04,357,252$ 41.132%$ 41.95$ 182,805.95
720273,918,718691,539$ 59.352%$ 60.53$ 41,860.26
820273,668,357647,357$ 53.532%$ 54.60$ 35,344.95
92027- 03,559,812$ 38.982%$ 39.76$ 141,536.70
102027- 03,290,515$ 35.872%$ 36.58$ 120,378.40
112027- 02,983,039$ 50.092%$ 51.09$ 152,402.63
1220272,667,024470,651$ 75.102%$ 76.60$ 36,050.66
120282,735,783482,785$ 126.292%$ 128.81$ 62,187.98
220282,690,478474,790$ 122.102%$ 124.54$ 59,132.16
32028- 02,984,470$ 43.472%$ 44.34$ 132,335.71
42028- 03,082,816$ 36.372%$ 37.10$ 114,360.96
52028- 03,403,691$ 34.032%$ 34.71$ 118,145.65
62028- 04,357,252$ 37.942%$ 38.70$ 168,630.30
720283,918,718691,539$ 54.722%$ 55.82$ 38,600.16
820283,668,357647,357$ 51.622%$ 52.65$ 34,086.11
92028- 03,559,812$ 36.042%$ 36.76$ 130,857.50
102028- 03,290,515$ 35.422%$ 36.13$ 118,870.94
112028- 02,983,039$ 46.322%$ 47.25$ 140,941.10
1220282,667,024470,651$ 64.502%$ 65.79$ 30,965.02
120292,735,783482,785$ 123.842%$ 126.31$ 60,981.71
220292,690,478474,790$ 120.822%$ 123.24$ 58,512.36
32029- 02,984,470$ 47.682%$ 48.64$ 145,156.79
42029- 03,082,816$ 35.292%$ 36.00$ 110,983.10
52029- 03,403,691$ 33.142%$ 33.81$ 115,062.50
62029- 04,357,252$ 35.342%$ 36.05$ 157,073.88
720293,918,718691,539$ 50.672%$ 51.69$ 35,743.11
820293,668,357647,357$ 46.692%$ 47.62$ 30,829.11
92029- 03,559,812$ 33.682%$ 34.35$ 122,277.83
102029- 03,290,515$ 33.112%$ 33.77$ 111,126.85
112029- 02,983,039$ 43.602%$ 44.47$ 132,654.62
1220292,667,024470,651$ 62.202%$ 63.44$ 29,859.17
120302,735,783482,785$ 128.582%$ 131.15$ 63,319.38
220302,690,478474,790$ 123.122%$ 125.59$ 59,627.37
32030- 02,984,470$ 48.862%$ 49.84$ 148,750.94
42030- 03,082,816$ 35.132%$ 35.83$ 110,466.01
52030- 03,403,691$ 32.732%$ 33.38$ 113,629.37
62030- 04,357,252$ 34.572%$ 35.26$ 153,623.05
720303,918,718691,539$ 50.582%$ 51.59$ 35,674.70
820303,668,357647,357$ 45.322%$ 46.22$ 29,923.07
Total Index6,113,838.81
Total78,401,799132,143,586$/kWh$ 0.04627
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.0450$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Contract Annual kWh Usage (Contract Volumes)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.02830$/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 * 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 7/25/25
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 01,689,919$ 41.352%$ 42.17$ 71,271.12
102025- 01,261,528$ 38.832%$ 39.61$ 49,968.03
112025- 01,287,828$ 54.252%$ 55.34$ 71,263.75
122025956,435168,783$ 95.052%$ 96.95$ 16,363.44
120261,006,454177,610$ 127.952%$ 130.51$ 23,179.64
220261,073,069189,365$ 105.942%$ 108.06$ 20,461.92
32026- 01,172,931$ 61.892%$ 63.13$ 74,048.16
42026- 0956,784$ 46.902%$ 47.83$ 45,766.73
52026- 01,379,268$ 40.802%$ 41.62$ 57,402.93
62026- 01,742,742$ 46.982%$ 47.92$ 83,504.79
720261,674,900295,571$ 66.472%$ 67.80$ 20,040.93
820261,527,409269,543$ 54.732%$ 55.82$ 15,046.59
92026- 01,689,919$ 41.962%$ 42.80$ 72,324.88
102026- 01,261,528$ 40.382%$ 41.19$ 51,963.48
112026- 01,287,828$ 57.362%$ 58.50$ 75,342.04
122026956,435168,783$ 84.792%$ 86.49$ 14,597.75
120271,006,454177,610$ 128.812%$ 131.39$ 23,336.28
220271,073,069189,365$ 107.922%$ 110.08$ 20,845.19
32027- 01,172,931$ 55.972%$ 57.09$ 66,963.64
42027- 0956,784$ 39.812%$ 40.60$ 38,846.59
52027- 01,379,268$ 33.932%$ 34.61$ 47,735.28
62027- 01,742,742$ 39.442%$ 40.23$ 70,102.90
720271,674,900295,571$ 57.992%$ 59.15$ 17,482.65
820271,527,409269,543$ 52.252%$ 53.29$ 14,364.31
92027- 01,689,919$ 37.472%$ 38.22$ 64,593.43
102027- 01,261,528$ 34.422%$ 35.11$ 44,296.06
112027- 01,287,828$ 48.522%$ 49.49$ 63,730.04
122027956,435168,783$ 72.972%$ 74.43$ 12,562.58
120281,006,454177,610$ 120.982%$ 123.40$ 21,916.30
220281,073,069189,365$ 118.702%$ 121.08$ 22,927.99
32028- 01,172,931$ 40.712%$ 41.52$ 48,702.52
42028- 0956,784$ 35.022%$ 35.72$ 34,177.79
52028- 01,379,268$ 33.072%$ 33.73$ 46,522.96
62028- 01,742,742$ 36.752%$ 37.49$ 65,329.85
720281,674,900295,571$ 54.012%$ 55.09$ 16,284.27
820281,527,409269,543$ 51.062%$ 52.08$ 14,037.37
92028- 01,689,919$ 35.002%$ 35.70$ 60,328.19
102028- 01,261,528$ 34.292%$ 34.98$ 44,122.69
112028- 01,287,828$ 44.952%$ 45.85$ 59,045.39
122028956,435168,783$ 62.182%$ 63.42$ 10,705.03
120291,006,454177,610$ 119.182%$ 121.56$ 21,590.41
220291,073,069189,365$ 113.922%$ 116.20$ 22,004.29
32029- 01,172,931$ 44.862%$ 45.76$ 53,674.59
42029- 0956,784$ 33.892%$ 34.57$ 33,077.82
52029- 01,379,268$ 32.132%$ 32.78$ 45,206.42
62029- 01,742,742$ 34.082%$ 34.76$ 60,581.69
720291,674,900295,571$ 49.932%$ 50.93$ 15,052.51
820291,527,409269,543$ 46.002%$ 46.92$ 12,647.54
92029- 01,689,919$ 32.622%$ 33.27$ 56,230.34
102029- 01,261,528$ 31.922%$ 32.56$ 41,076.67
112029- 01,287,828$ 42.172%$ 43.02$ 55,398.98
122029956,435168,783$ 59.822%$ 61.02$ 10,298.99
120301,006,454177,610$ 121.382%$ 123.81$ 21,989.80
220301,073,069189,365$ 116.122%$ 118.45$ 22,429.78
32030- 01,172,931$ 45.952%$ 46.87$ 54,979.62
42030- 0956,784$ 33.722%$ 34.40$ 32,911.70
52030- 01,379,268$ 31.742%$ 32.38$ 44,655.33
62030- 01,742,742$ 33.332%$ 33.99$ 59,243.36
720301,674,900295,571$ 49.872%$ 50.87$ 15,035.59
820301,527,409269,543$ 44.652%$ 45.54$ 12,275.08
Total Index2,381,865.97
Total31,191,33452,959,355$/kWh$ 0.04498
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,307881,281,255kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,255325,130,174kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,052556,151,081kWhThe 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.0473$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Mass Total - Sum of Annual kWh UsageMonth
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,596556,151,081kWh=Indexed Quantity at Meter * (1 + Line Loss Adjustment)3ISONE6/1/24N/A13,500,33212,644,79612,855,98214,125,32113,834,89117,512,08320,350,44017,033,51314,197,82814,128,97013,478,27513,319,233176,981,663884,908,315<-- Two accounts end early, thus the difference
CalcFixed Quantity at Delivery Point5,906,222325,130,174kWh=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,818881,281,255kWh=Indexed Quantity at Delivery Point + Fixed Quantity at Delivery PointHedge Vol11,475,28210,748,077- 0- 0- 0- 017,297,87414,478,486- 0- 0- 011,321,34865,321,066326,605,332
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,025,0501,896,71912,855,98214,125,32113,834,89117,512,0833,052,5662,555,02714,197,82814,128,97013,478,2751,997,885111,660,597558,302,983
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.02982$/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 * Adder Bid Amount))/Total Quantity at Meter (Term)
Enel X InputShaped Hedge Descriptione.g. "Percent Hedge: a 7x24 85% hedge
NEMA - Sum of Contract Annual kWh Usage (Contract Volumes)Month
See "Explanation" tab for further details.Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
3ISONE6/1/24N/A11,483,39310,779,71610,922,59812,128,36311,749,61914,933,15016,926,69314,246,58511,774,22511,953,48111,455,96011,194,544149,548,327Acct 74010823537_91778797 ends July 2029Acct 74003462509_90806930 ends Sep 2026
Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%MA
Hedge Vol9,760,8849,162,759- 0- 0- 0- 014,387,68912,109,597- 0- 0- 09,515,36254,936,291MonthYearBlockIndexFwd PriceBufferTotal IndexIndex CostMonthYearNEMASEMAWCMATotal
Index Vol1,722,5091,616,95710,922,59812,128,36311,749,61914,933,1502,539,0042,136,98811,774,22511,953,48111,455,9601,679,18294,612,03692025- 014,197,828$ 41.022%$ 41.84$ 594,100.719202511,774,2251,251,0981,172,50514,197,828
102025- 014,128,970$ 38.862%$ 39.63$ 559,977.0210202511,953,4811,209,177966,31214,128,970
SEMA - Sum of Contract Annual kWh Usage (Contract Volumes)Month112025- 013,478,275$ 54.222%$ 55.31$ 745,429.4611202511,455,9601,094,826927,48913,478,275
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total12202511,321,3481,997,885$ 95.042%$ 96.94$ 193,678.9812202511,194,5441,166,806957,88313,319,233
3ISONE6/1/24N/A1,039,939985,610993,5921,171,4941,178,7061,404,1431,961,9371,458,3991,251,0981,209,1771,094,8261,166,80614,915,7271202611,475,2822,025,050$ 128.432%$ 130.99$ 265,270.691202611,483,3931,039,939977,00013,500,332
Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%2202610,748,0771,896,719$ 105.482%$ 107.59$ 204,074.652202610,779,716985,610879,47012,644,796
Hedge Vol883,948837,769- 0- 0- 0- 01,667,6461,239,639- 0- 0- 0991,7855,620,78732026- 012,855,982$ 63.722%$ 64.99$ 835,562.253202610,922,598993,592939,79212,855,982
Index Vol155,991147,842993,5921,171,4941,178,7061,404,143294,291218,7601,251,0981,209,1771,094,826175,0219,294,94042026- 014,125,321$ 47.782%$ 48.73$ 688,396.394202612,128,3631,171,494825,46414,125,321
52026- 013,834,891$ 41.792%$ 42.63$ 589,768.825202611,749,6191,178,706906,56613,834,891
WCMA - Sum of Contract Annual kWh Usage (Contract Volumes)Month62026- 017,512,083$ 48.222%$ 49.18$ 861,233.976202614,933,1501,404,1431,174,79017,512,083
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total7202617,297,8743,052,566$ 67.862%$ 69.22$ 211,287.737202616,926,6931,961,9371,461,81020,350,440
3ISONE6/1/24N/A977,000879,470939,792825,464906,5661,174,7901,461,8101,328,5291,172,505966,312927,489957,88312,517,6098202614,478,4862,555,027$ 55.462%$ 56.56$ 144,524.068202614,246,5851,458,3991,328,52917,033,513
Hedge %85%85%- 0- 0- 0- 085%85%- 0- 0- 085%92026- 014,197,828$ 42.672%$ 43.52$ 617,918.429202611,774,2251,251,0981,172,50514,169,388
Hedge Vol830,450747,550- 0- 0- 0- 01,242,5391,129,249- 0- 0- 0814,2014,763,988102026- 014,128,970$ 41.352%$ 42.17$ 595,869.5310202611,953,4811,209,177966,31214,102,810
Index Vol146,550131,921939,792825,464906,5661,174,790219,272199,2791,172,505966,312927,489143,6827,753,621112026- 013,478,275$ 58.652%$ 59.83$ 806,340.5911202611,455,9601,094,826927,48913,455,835
12202611,321,3481,997,885$ 85.902%$ 87.62$ 175,056.3812202611,194,5441,166,806957,88313,295,593
1202711,475,2822,025,050$ 121.952%$ 124.39$ 251,890.371202711,483,3931,039,939977,00013,472,612
2202710,748,0771,896,719$ 99.512%$ 101.50$ 192,522.002202710,779,716985,610879,47012,624,756
32027- 012,855,982$ 61.192%$ 62.41$ 802,327.863202710,922,598993,592939,79212,833,422
42027- 014,125,321$ 44.152%$ 45.03$ 636,067.164202712,128,3631,171,494825,46414,095,201
52027- 013,834,891$ 37.712%$ 38.46$ 532,094.915202711,749,6191,178,706906,56613,802,491
62027- 017,512,083$ 43.042%$ 43.90$ 768,846.066202714,933,1501,404,1431,174,79017,478,483
7202717,297,8743,052,566$ 61.802%$ 63.04$ 192,433.607202716,926,6931,961,9371,461,81020,308,800
8202714,478,4862,555,027$ 55.022%$ 56.12$ 143,379.048202714,246,5851,458,3991,328,52916,996,313
92027- 014,197,828$ 40.952%$ 41.77$ 593,029.069202711,774,2251,251,0981,172,50514,169,388
102027- 014,128,970$ 38.512%$ 39.28$ 554,984.1210202711,953,4811,209,177966,31214,102,810
112027- 013,478,275$ 52.692%$ 53.74$ 724,364.3711202711,455,9601,094,826927,48913,455,835
12202711,321,3481,997,885$ 77.472%$ 79.02$ 157,878.2412202711,194,5441,166,806957,88313,295,593
1202811,475,2822,025,050$ 113.432%$ 115.70$ 234,298.761202811,483,3931,039,939977,00013,472,612
2202810,748,0771,896,719$ 106.052%$ 108.17$ 205,168.702202810,779,716985,610879,47012,624,756
32028- 012,855,982$ 45.472%$ 46.38$ 596,248.853202810,922,598993,592939,79212,833,422
42028- 014,095,201$ 37.642%$ 38.39$ 541,138.264202812,128,3631,141,374825,46414,095,201
52028- 013,802,491$ 35.182%$ 35.88$ 495,228.575202811,749,6191,146,306906,56613,802,491
62028- 017,363,203$ 38.422%$ 39.19$ 680,408.596202814,817,8701,370,5431,174,79017,478,483
7202817,131,1383,023,142$ 53.962%$ 55.03$ 166,376.067202816,772,1731,920,2971,461,81020,308,800
8202814,347,4842,531,909$ 50.182%$ 51.18$ 129,589.438202814,129,6651,421,1991,328,52916,996,313
92028- 014,064,308$ 36.562%$ 37.29$ 524,443.029202811,669,1451,222,6581,172,50514,169,388
102028- 014,015,490$ 36.392%$ 37.12$ 520,276.4210202811,866,1611,183,017966,31214,102,810
112028- 013,364,315$ 46.912%$ 47.85$ 639,450.4811202811,364,4401,072,386927,48913,455,835
12202811,231,7581,982,075$ 68.312%$ 69.67$ 138,095.8412202811,112,7841,143,166957,88313,295,593
1202911,370,8682,006,624$ 109.872%$ 112.07$ 224,875.571202911,388,2731,012,219977,00013,472,612
2202910,651,1091,879,607$ 102.902%$ 104.96$ 197,287.142202910,685,676965,570879,47012,624,756
32029- 012,726,142$ 52.152%$ 53.19$ 676,929.273202910,815,318971,032939,79212,833,422
42029- 013,991,081$ 36.772%$ 37.50$ 524,712.554202912,024,2431,141,374825,46414,095,201
52029- 013,715,011$ 34.442%$ 35.13$ 481,781.355202911,662,1391,146,306906,56613,802,491
62029- 017,478,483$ 36.312%$ 37.04$ 647,407.906202914,933,1501,370,5431,174,79017,478,483
7202917,131,1383,023,142$ 49.042%$ 50.02$ 151,221.977202916,772,1731,920,2971,461,81020,154,280
8202914,347,4842,531,909$ 44.462%$ 45.35$ 114,811.168202914,129,6651,421,1991,328,52916,879,393
92029- 014,064,308$ 34.582%$ 35.27$ 496,089.769202911,669,1451,222,6581,172,50514,064,308
102029- 014,015,490$ 34.902%$ 35.60$ 498,955.6910202911,866,1611,183,017966,31214,015,490
112029- 013,364,315$ 44.932%$ 45.83$ 612,432.1111202911,364,4401,072,386927,48913,364,315
12202911,231,7581,982,075$ 69.462%$ 70.85$ 140,425.3812202911,112,7841,143,166957,88313,213,833
1203011,370,8682,006,624$ 110.252%$ 112.45$ 225,650.701203011,388,2731,012,219977,00013,377,492
2203010,651,1091,879,607$ 103.252%$ 105.32$ 197,959.982203010,685,676965,570879,47012,530,716
32030- 012,726,142$ 51.502%$ 52.53$ 668,446.943203010,815,318971,032939,79212,726,142
42030- 013,991,081$ 36.972%$ 37.71$ 527,642.844203012,024,2431,141,374825,46413,991,081
52030- 013,715,011$ 34.492%$ 35.18$ 482,455.245203011,662,1391,146,306906,56613,715,011
62030- 017,363,203$ 35.892%$ 36.61$ 635,628.666203014,817,8701,370,5431,174,79017,363,203
7203017,131,1383,023,142$ 48.632%$ 49.60$ 149,942.447203016,772,1731,920,2971,461,81020,154,280
8203014,347,4842,531,909$ 44.742%$ 45.64$ 115,548.998203014,129,6651,421,1991,328,52916,879,393
Total Index26,279,235.05
Total325,130,174556,158,941$/kWh$ 0.04725
881,289,115

&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.0425$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Contract Annual kWh Usage (Contract Volumes)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.02728$/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 * 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.
NH 7/25/25
MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
92025- 01,849,921$ 41.202%$ 42.02$ 77,739.82
102025- 01,599,797$ 39.122%$ 39.91$ 63,840.13
112025- 01,591,831$ 53.922%$ 55.00$ 87,551.60
1220251,450,967256,053$ 94.742%$ 96.63$ 24,743.15
120261,474,181260,150$ 126.482%$ 129.00$ 33,560.60
220261,270,990224,292$ 104.332%$ 106.42$ 23,868.75
32026- 01,875,753$ 60.752%$ 61.97$ 116,239.02
42026- 01,652,711$ 46.062%$ 46.98$ 77,640.35
52026- 01,613,397$ 40.342%$ 41.15$ 66,383.47
62026- 02,070,663$ 46.772%$ 47.70$ 98,778.52
720261,597,346281,885$ 66.362%$ 67.69$ 19,079.69
820261,780,597314,223$ 54.202%$ 55.28$ 17,371.19
92026- 01,849,921$ 41.412%$ 42.24$ 78,134.82
102026- 01,599,797$ 39.882%$ 40.68$ 65,080.29
112026- 01,591,831$ 56.232%$ 57.35$ 91,296.17
1220261,450,967256,053$ 83.422%$ 85.09$ 21,788.15
120271,474,181260,150$ 122.102%$ 124.55$ 32,400.53
220271,270,990224,292$ 101.382%$ 103.41$ 23,193.09
32027- 01,875,753$ 52.302%$ 53.35$ 100,066.03
42027- 01,652,711$ 37.142%$ 37.88$ 62,605.57
52027- 01,613,397$ 31.942%$ 32.58$ 52,564.84
62027- 02,070,663$ 37.392%$ 38.14$ 78,971.94
720271,597,346281,885$ 55.272%$ 56.37$ 15,890.52
820271,780,597314,223$ 49.452%$ 50.43$ 15,847.61
92027- 01,849,921$ 35.102%$ 35.81$ 66,237.16
102027- 01,599,797$ 32.152%$ 32.79$ 52,463.72
112027- 01,591,831$ 45.092%$ 45.99$ 73,205.66
1220271,450,967256,053$ 68.282%$ 69.64$ 17,832.07
120281,474,181260,150$ 113.852%$ 116.12$ 30,209.11
220281,270,990224,292$ 109.472%$ 111.66$ 25,044.82
32028- 01,875,753$ 36.172%$ 36.89$ 69,204.94
42028- 01,652,711$ 31.042%$ 31.66$ 52,328.03
52028- 01,613,397$ 29.882%$ 30.48$ 49,171.58
62028- 02,070,663$ 33.402%$ 34.07$ 70,543.82
720281,597,346281,885$ 49.712%$ 50.70$ 14,292.67
820281,780,597314,223$ 46.542%$ 47.47$ 14,916.07
92028- 01,849,921$ 31.332%$ 31.96$ 59,117.19
102028- 01,599,797$ 30.772%$ 31.39$ 50,216.94
112028- 01,591,831$ 40.172%$ 40.98$ 65,228.09
1220281,450,967256,053$ 55.212%$ 56.31$ 14,419.36
120291,474,181260,150$ 112.962%$ 115.22$ 29,974.49
220291,270,990224,292$ 107.972%$ 110.13$ 24,701.18
32029- 01,875,753$ 40.302%$ 41.10$ 77,101.77
42029- 01,652,711$ 29.902%$ 30.49$ 50,398.76
52029- 01,613,397$ 28.962%$ 29.54$ 47,651.91
62029- 02,070,663$ 30.792%$ 31.41$ 65,032.24
720291,597,346281,885$ 45.572%$ 46.48$ 13,101.37
820291,780,597314,223$ 41.552%$ 42.38$ 13,315.64
92029- 01,849,921$ 28.942%$ 29.52$ 54,602.42
102029- 01,599,797$ 28.382%$ 28.95$ 46,312.21
112029- 01,591,831$ 37.422%$ 38.17$ 60,752.91
1220291,450,967256,053$ 52.852%$ 53.90$ 13,801.81
120301,474,181260,150$ 115.052%$ 117.35$ 30,529.51
220301,270,990224,292$ 110.032%$ 112.24$ 25,173.55
32030- 01,875,753$ 41.282%$ 42.11$ 78,978.93
42030- 01,652,711$ 29.752%$ 30.34$ 50,148.14
52030- 01,613,397$ 28.602%$ 29.17$ 47,061.06
62030- 02,070,663$ 30.122%$ 30.72$ 63,615.74
720301,597,346281,885$ 45.542%$ 46.45$ 13,093.27
820301,780,597314,223$ 40.312%$ 41.11$ 12,918.97
Total Index2,887,332.95
Total37,870,40367,953,377$/kWh$ 0.04249
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,30790,613,480kWh=Indexed Quantity at Meter + Fixed Quantity at Meter
Enel X InputFixed Quantity at Meter5,463,25533,199,993kWhThe volume of load to be hedged in units at the Meter
Enel X InputIndexed Quantity at Meter33,319,05257,413,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.0411$/kWhEstimate of average wholesale price of energy not including the fixed (hedged) load. (weighted average price for load following energy)Sum of Contract Annual kWh Usage (Contract Volumes)Month
Pricing GroupISO/RTOCapacity Tag Effective DateTransmission123456789101112Grand Total
CalcIndexed Quantity at Delivery Point36,020,59657,413,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,6931,278,28318,122,696
CalcFixed Quantity at Delivery Point5,906,22233,199,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,81890,613,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- 01,086,5416,639,99933,199,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,693191,74211,482,69757,413,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.02603$/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 * 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.9- 01,718,960
10- 01,459,080
11- 01,357,693RI
121,086,541191,742MonthYearBlockIndexFwd PriceBufferTotal IndexIndex Cost
11,222,742215,77892025- 01,718,960$ 41.182%$ 42.00$ 72,194.33
21,103,300194,700102025- 01,459,080$ 38.682%$ 39.46$ 57,569.64
3- 01,360,600112025- 01,357,693$ 54.152%$ 55.23$ 74,986.67
4- 01,320,9201220251,086,541191,742$ 94.442%$ 96.32$ 18,469.56
5- 01,402,360120261,222,742215,778$ 126.412%$ 128.94$ 27,822.03
6- 01,691,320220261,103,300194,700$ 103.912%$ 105.99$ 20,636.85
71,741,548307,33232026- 01,360,600$ 60.042%$ 61.24$ 83,325.60
81,485,868262,21242026- 01,320,920$ 45.662%$ 46.58$ 61,522.17
52026- 01,402,360$ 40.052%$ 40.85$ 57,290.42
62026- 01,691,320$ 46.232%$ 47.15$ 79,748.92
720261,741,548307,332$ 65.362%$ 66.67$ 20,489.84
820261,485,868262,212$ 53.392%$ 54.46$ 14,280.35
92026- 01,718,960$ 40.962%$ 41.78$ 71,820.28
102026- 01,459,080$ 39.342%$ 40.13$ 58,553.33
112026- 01,357,693$ 55.982%$ 57.10$ 77,522.61
1220261,086,541191,742$ 82.442%$ 84.09$ 16,122.87
120271,222,742215,778$ 121.392%$ 123.82$ 26,717.42
220271,103,300194,700$ 98.582%$ 100.55$ 19,577.49
32027- 01,360,600$ 51.362%$ 52.39$ 71,284.32
42027- 01,320,920$ 36.632%$ 37.36$ 49,350.01
52027- 01,402,360$ 31.522%$ 32.15$ 45,091.20
62027- 01,691,320$ 36.662%$ 37.40$ 63,251.53

This is the start of the file's text. The full file is on GovTribe.

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