WIXLIB

“Billable” Meter Data is Calculated–Uses submitted Meter Data–Passed to Alstom for calculation–Residual within a Settlement Area is calculated–Calibration of the Residual for Load SettlementLocations is calculated–Calibration is added to “Adjusted” meter data45

ReportsThe following reports are produced and are available via API or Portal–Meter Agent Report CardPoint-in-time view for a Meter Agent into the data available for a given operating day for all meter datasubmittal locations for which the Meter Agent is responsible for submitting data. The report detailsmissing resource, load, and interchange values for a Meter Agent and an Operating Day, ordered bySettlement Area.–Interchange ReportPoint-in-time view for a Meter Agent into the data available for a given operating day for theinterchange, positive or negative, in each settlement area. The report details interchange metering, withreciprocals, and net actual interchange values by Settlement Area and Meter Agent for an Operating Day.–Calibration ReportPoint-in-time view for Meter Agents for the generation, load, and interchange data available for a givenOperating Day for all meter data submittal locations (interchange locations) for which the Meter Agentcan submit data.NOTE: while the reports are more quickly available, they will be more useful as more data is submittedand may not be final until meter window closes for the Operating Day being reported.46

Meter Data Recap–Can be submitted in Hourly AND 5-Minute Intervals–Both 5-Minute and Hourly data may be submitted in the same file for anOD for different MDSLs–Submissions can contain only one OD–Submissions can contain both Resource and Load–Interchange can only be submitted in Hourly Intervals–Extraneous tags in XML have been removed–State Estimator Data comes from upstream systems, based on SCADA dataand is used to profile “Actual” Meter Data submitted in Hourly intervals–New Meter GUI on the Portal features: Manual submission of files which include progress status and can be used as aback-up to the API process Near real time reports – Meter Agent Report Card, Interchange and CalibrationReports47

Reports EIS Market– Meter Agent Report Cardemailed to distribution listgenerally on OD 4– Calibration Report is posted tothe Portal on OD 7 along withStatements and Summaries.– Interchange Report is posted tothe Portal on or after OD 7.– History of pending andprocessed meter filesubmissions viewable on thePortal . Integrated Marketplace– Meter Agent Report Card,Calibration Report andInterchange Report will beavailable near real time on thePortal.– Meter Agent Report Card willprovide detail for submittedmeter files processed for theOperating Date selected.– In order to secure the meterdata available on the Portal, anyMarket Participant that requiresanyone other than the MeterAgent to see the meter reportswill need to register one MeterAgent per Market Participant.

METER DATA – PORTAL DEMOLet’s see it in action!!49

Questions?50

Day in the Life-From the Market Participants Perspective51

Section 6 – Linda FelloneBILATERAL SETTLEMENTSCHEDULES52

Common AcronymsBSS - Bilateral Settlement Schedule (aka. BiSched/BiSchettles /FinancialSchedule/FinSched)AO - Asset OwnerCH - Contract HeaderCP - Contract ProfileDA Market - Day Ahead MarketRTBM - Real Time Balancing MarketEDR - External Dynamic ResourceMP - Market ParticipantSL - Settlement LocationMPRR - Marketplace Protocol Revision Requests53

Contentare Bilateral Settlement Schedules?can submit them?can they be submitted?can they be submitted?are they submitted?54

are Bilateral Settlement Schedules?A financial arrangement between two MarketParticipants trading settlement quantities related tothe settlement of: DA Market and RTBM Asset and Non-AssetEnergy at a Settlement Location Cost Allocation of DA Market Operating Reserves(Reg Up, Reg Down, Spin, and Supplemental)within a Reserve ZoneNote: Definitions according to the Integrated Marketplace55

can Submit Bilaterals?MP submitsheader for thelife of the contractContract headers and profiles always requireapproval by the counter partyMP or AO submitsprofiles dailyagainst the header56

can Submit Bilaterals?Market Participants Contract HeaderContract Header- Only the original creator can makeupdates Contract Header- Both parties must approve theheader before profiles can besubmitted against it Market Participants / Asset Owners ProfileProfile- Both parties must approve Contract Header- MPs can see contracts for all AOsthat roll-up under them- AOs can only see contracts specificto themContract Header- Sets the end date to the end ofthe current calendar day or;- End of the last day w/ profile datain APPROVED or PROCESSED status57

can Bilaterals be Submitted?Bilateral Settlement Schedules can be submitted via: SPP Portal (traditional web application) API service (application programming interface)Market Participants are responsible for granting individualaccess to their end users via the LSA (Local Security Admin)certificate for the SPP PortalPrerequisites- X.509 digital certificate public key must be acquired from arecognized, trusted Certificate Authority (CA)- Must be fully registered within the SPP market58

can Bilaterals be Submitted?59

can Bilaterals be Submitted?60

are Bilaterals Submitted?Bilateral User Interface (SPP Portal) Welcome Help / List Create Header Header Approval Profile Approval Reporting61

are Bilaterals Submitted?Date Range: 1/1/12 – 4/30/14Buyer: AO TSeller: AO VSettlement Location: L1Product: DAENERGYMax MW: 50 MPs can submit contracts betweentheir AOs If the MP represents both the BUYERand SELLER, approval will occurduring the same transaction MP can elect to auto-confirm profilesrelated to a contract header If the MP needs to update a headerthat already has profiles against it,they must end their current headerand create a new oneHourMWHourMW1 Hour0 MW102 1Hour 0 0MW203 2 1 25 0 03254 3 2 30 25 04305 4 3 0 3025506 5 4 0 0 30607 6 5 45 0 07458 7 6 50 45 085075045. 8. 850. . . . .24 .24.24240 MP/AO profiles must containvalues for all 24 hours(23 short day; 25 long day) If MP has elected to autoconfirm profiles for a givenheader, manual approval isstill required in the eventthat a profile is updated Profile MWs for a given hourcannot exceed the ‘Max MW’established in the contractheader00062

are Bilaterals Submitted?Profile entered,but not yetapproved byboth partiesBoth AOs have approvedthe profile,but it has not been pickedup for processing yetBoth AOs have approvedthe profile,and it has been loaded inthe Settlements System Profile data which has already been submitted, but not yet PROCESSED, can beoverwritten if the MP/AO submits a new profile. For a given contract header and operating day, only one version of PENDING orCONFIRMED profiles will exist on the Portal. When the window opens for Bilaterals for a given operating day, the SettlementSystem will load the most recent CONFIRMED profile for that day. For a given contract header and operating day, more than one PROCESSEDprofile can exist. The PROCESSED profile with the most recent timestamp prior to the Initial orFinal Settlement is the one used in the Settlements System.63

Questions?64

Day in the Life-From the Market Participants PerspectiveWhat is SPP doing with the data I submit?65

Section 7 – Dana BoyerETSE DEMO66

Contents Part 1: Settlements Timeline Part 2: ETSE Demo Part 3: Post-Validation Process67

Part 1SETTLEMENTSTIMELINE68

Timeline: Initial Settlement- Market Participantssubmit Meter Data &Bilateral Schedules- Both are due at noonon OD 4 for inclusionin the Initial runOD 1Meter Data /Bilateral SchedulesDue: NoonOD 4- SPP performsdata validationsand preparesthe InitialSettlementOD 5OD 6- SPPpublishesInitialSettlementStatementOD 7The days following the operating day (OD)69

Timeline: Final Settlement- Market Participantssubmit Meter Data &Bilateral Schedules- Both are due at noonon OD 44 for inclusionin the Final runOD 5Meter Data /Bilateral SchedulesDue: NoonOD 44- SPP performsdata validationsand preparesthe FinalSettlementOD 45OD 46- SPPpublishesFinalSettlementStatementOD 47The days following the operating day (OD)70

Timeline: ResettlementsResettlements R1 (OD 77) and R3 (OD 137) areutilized if the approved dispute results in at least a25% financial change in a MP’s Settlement Statement- SPPpublishesInitialSettlementStatement- SPPpublishesFinalSettlementStatement- SPPpublishesR2SettlementStatement- SPPpublishesR4SettlementStatementOD 7OD 47OD 107OD 167- Resettlements R5 to R9limited to incrementalchanges (after 90 daywindow)- Resettlements R10 toR12 reserved for ad hocR5 (R4 30); R6 (R5 30) 90 Day Dispute Submission Window- SPP performsdispute resolutionThe days following the operating day (OD)71

Settlement Date ActivitiesOD 4 until OD 7Initial Settlement Activities (3 day window)OD 44 until OD 47Final Settlement Activities (3 day window)OD 48 until OD 137Resettlement Activities (window varies)72

Part 2ETSE DEMO73

ETSE DemoLet’s see it in action!!74

Part 3POST-VALIDATIONPROCESS75

Post-Validation Data Flow76

Post-Validation Data FlowDaily Validation Reports – Compares counts/sums from input tables(staging) to determinant reports (data store) toensure all data that went into ETSE came out Provides the analyst with a summary of totalcharges for the operating day by charge type forRNU verification and trend analysisDaily Exception Reports – Produced if data from the inputtables in Staging does not matchdata that is output from ETSE77

Post-Validation Data FlowAsset Owner Validation – Loads data from the AO determinant reports(XML) for a sample of AOs for each OD Shadows the charges that appear on the AO’sdeterminant report by using the pass throughdeterminants that appear on the XML Provides a validation of the AO charges as wellas the XML formation process78

Post-Validation Data FlowMarket-Wide Validation – Validation done to verify the market-widedeterminants used as input into many othercalculations Asset Owner Validation does not verify thesesince they are sums across all AOs Pulls in results for all Asset Owners from thedata store in order to shadow the values thatsum across all AOs79

Post-Validation Data FlowSettlement Statement Validation – Loads Settlement Statements (XML) for allMPs for the Settlement Date being validated Shadows the daily roll-ups for each MP back tothe AO determinant reports that are modeledunder the MP for each OD / Settlement Type forthe Settlement Date being validated Provides validation of the SettlementStatement results for each MP as well as theXML formation process80

Post-Validation Data Flow81

Post-Validation Data FlowWeekly Invoice Validation – Validates the Weekly Invoice Results producedby ETSE back to the Settlement StatementResults in the data store for the days included inthe invoicing period82

Post-Validation Data Flow83

Questions?84

Day in the Life-From the Market Participants Perspective85

Section 8 – Josh DavisSTATEMENTS AND OUTPUTS86

The What, When, Who, Where, and HowOUTPUT REPORTS87

Output Reports- What are they? Determinant Reports (5-min vs. Hourly/Daily) Statements EQR Data88

Determinant Reports - What are they? Contains sufficient detail to allow verification of billingamounts Includes raw input determinants, intermediatecalculations, and Charge Types by Asset Owner At the 5-Minute or Hourly/Daily level Are for a given Operating Date and Settlement Type Accessible by Market Participants and/or AssetOwners89

Statements - What are they? Daily summary of the total daily charges and credits Includes Current and Net amounts Aggregated at the Asset Owner level Aggregated by Operating Day and Settlement Type Accessible to only Market Participants90

EQR Data Reports - What are they? FERC Electric Quarterly Report Data Contains the required bill determinants under eachapplicable Charge Type If multiple settlement runs have been processed (I, F,R2), the most recent data is returned (R2) SPP is not responsible for formatting the actual reportsor filing the reports with FERC Accessible by Market Participants and/or AssetOwners91

Output Reports – When can I get them? Issued weekly on Thursday by no later than 8:00 a.m.CPT Will follow the SPP Invoice Calendar–Posted monthly on the SPP Portal–Includes updates for Holidays92

Output Reports – The Process Market Settlement System will calculate the dayscharges/credits Settlement Analyst will validate and approve/rejectthe results Once approved and posting date has been reached,external notification will be sent* Participants can then pull their respective reports viathe API or UI93

Output Reports – Who can get them? Bill Determinant Reports–Market Participant–Asset OwnerStatements– Market ParticipantFERC EQR Data–Market Participant–Asset Owner94

Output Reports – Where and How can I get them? Output reports will be accessed through the Portal**INSERT PORTAL SCREENSHOT**95

Accessing Statements and OutputsLet’s see it in action!!96

Questions?97

Day In The Life .A Day In The Life of theSettlement AnalystMeter DataSubmittalETSE DemoPortal(Statements/Outputs)ChargeTypes uleSubmittalWhat?When?Where?How?98

Section 9 – Part 1--Steve ArnoldCHARGE TYPES BY TRANSACTION-OVERVIEW99

Contents – Part 1 Energy Charge Types Over-Collected Losses (OCL) Charge Types Operating Reserves Charge Types Make Whole Payment Charge Types Demand Response Charge Types Other Charge Types ARR / TCR Charge Types Revenue Neutrality Uplift100

ENERGYCHARGE TYPES101

Energy Charge TypesDay-Ahead Charge TypesEnergy Charge Types Day-Ahead Asset Energy Day-Ahead Non-Asset Energy Day-Ahead Virtual Energy Real-Time Asset Energy Real-Time Non-Asset Energy Real-Time Virtual EnergyEnergy calculations are performed on anhourly basis for each operating day and arebased upon the results of the DA Marketclearing for that Operating Day.Real-Time Charge TypesEnergy calculations are performed on adispatch interval basis for each operatingday and are based upon the differencebetween the results of the RTBM processand the DA Market clearing for thatOperating Day.102

Energy Charge Types: Asset EnergyCredit or charge for net physical Energy activity associated withLoad and Resources, adjusted for Bilateral Settlement Schedulesfor EnergyDay-Ahead Asset Energy: DaEnergyHrlyAmt a,s,hDA LMPDA Cleared QtyDA BilateralsReal-Time Asset Energy: RtEnergy5minAmt a,s,iRT LMPRT Meter QtyDA Cleared QtyRT Bilaterals103

Energy Charge Types: Non-Asset EnergyCredit or charge for net physical Energy activity associated withInterchange Transactions, adjusted for Bilateral SettlementSchedules for EnergyDay-Ahead Non-Asset Energy: DaNEnergyHrlyAmt a,s,hDA LMPDA Imp/Exp QtyDA BilateralsReal-Time Non-Asset Energy: RtNEnergy5minAmt a,s,iRT LMPRT Imp/Exp QtyDA Imp/Exp QtyRT Bilaterals104

Energy Charge Types: Virtual EnergyCredit or charge for net virtual Energy activity associated withcleared virtual transactionsDay-Ahead Virtual Energy: DaVEnergyHrlyAmt a,s,hDA LMPDA Cleared Virtual QtyReal-Time Virtual Energy: RtVEnergy5minAmt a,s,iRT LMPDA Cleared Virtual Qty105

OVER-COLLECTED LOSSES (OCL)CHARGE TYPES106

Over-Collected Losses (OCL) Charge TypesEnergy Charge Types Day-Ahead Asset Energy Day-Ahead Non-Asset Energy Day-Ahead Virtual Energy Real-Time Asset Energy Real-Time Non-Asset Energy Real-Time Virtual EnergyOCL Distribution Charge Types Day-Ahead Over-CollectedLosses Distribution Real-Time Over-CollectedLosses DistributionDay-Ahead and Real-Time Charge TypesThe Marginal Losses Component (MLC) of the DA and RT LMP paidfor Energy results from the economic market solution whichconsiders the cost of marginal losses, congestion costs andincremental Energy costs. This creates an over collection related topayment for losses that must be refunded via the OCL DistributionCharge Types.107

OCL Distribution Charge TypesCredit (or charge) at Settlement Locations where an Asset Ownerhas a DA Market Energy or Net RTBM Energy withdrawal thatcontributed positively to the over collectionDay-Ahead OCL Distribution: DaOclDistHrlyAmt a,s,lp,hDA NormalizedLoss Rebate FactorDA Over-CollectedLosses Amount-1Real-Time OCL Distribution: RtOclDistHrlyAmt a,s,lp,hRT NormalizedLoss Rebate FactorRT IncrementalOver-CollectedLosses Amount-1108

OPERATING RESERVECHARGE TYPES109

Operating Reserves Charge TypesOperating Reserves Charge Types Day-Ahead Regulation-UpDay-Ahead Regulation-DownDay-Ahead Spinning ReservesDay-Ahead Supplemental Reserves Day-Ahead Regulation-Up DistributionDay-Ahead Regulation-Down DistributionDay-Ahead Spinning Reserves DistributionDay-Ahead Supplemental Reserves Distribution Real-Time Regulation-UpReal-Time Regulation-DownReal-Time Spinning ReservesReal-Time Supplemental Reserves Real-Time Regulation-Up DistributionReal-Time Regulation-Down DistributionReal-Time Spinning Reserves DistributionReal-Time Supplemental Reserves DistributionOperating Reserves help to ensure reliability within the market. Regulation-Up/Down maintain the balance between load and generation Spinning/Supplemental must be available in the event of an outageThe Operating Reserve Charge Types include the payments forprocurement of Operating Reserves as well as the distribution of thosecosts.110

Operating Reserves: ProcurementCredit (or charge) for cleared operating reserve products (RegUp,RegDn, Spin, Supp) in the DA Market or RTBMDay-Ahead Operating Reserves: DaProductHrlyAmt a,s,hSDA MCPDA ProductCleared Qty-1RZNReal-Time Operating Reser

- Technology: SharePoint, SPP.org, IssueTrak - Data collection and analysis: Needs analyses - Measurement: Expectations, Outcomes, Evidence-based - Tracking and reporting: IssueTrak, Communications - Communications: Set rolling 90-day plan for messaging and channels Develop project plan with schedule, resources, deliverables 30