Spreadsheet: kevin_presto__19995__SERC Seasonal Assessments-EIA 411 reporting responsibilities
Sheet: Duke Example Responsibilities

Data submitted by: | Duke Control Area
Report | Duke LSE | NCEMC | NCMPA | NHEC | PMPA | Grnwd | SEPA
SERC Seasonal Assessment
Inputs
Historical Seasonal Peaks (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Total Internal Demand (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Interruptible Load/Load Management (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Total Capacity (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Committed Resources (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Uncommitted Resources (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Inoperable Capability (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Total Capacity Purchases (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Full Responsibility Purchases (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Total Capacity Sales (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Full Responsibility Sales (Montly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Adjustment to Purchases and Sales (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | SEPA
Calculated Values
Net Internal Demand (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Net Operable Capacity (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Net Capacity Resources (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Capacity Margin (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
EIA 411
Actual Demand & Energy Previous Year (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Projected Demand & Energy Report Year (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Projected Demand & Energy Next Year (Monthly) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Projected Summer & Winter Peak Demand Next Ten Years | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Projected Summer and Winter Capacity Resources Next Ten Years | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Projected Summer and Winter Sales Next Ten Years | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Projected Summer and Winter Purchases Next Ten Years | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Proposed Bulk Power Transmission Line Additions (230 KV and above) | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Existing & Planned Transmission Line Circuit Miles Next Ten Years | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Existing and Planned Generating Plant and Unit Capacity Data | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
Jointly Owned Generator Data | [NAME] | NCEMC | NCMPA | [NAME] | [NAME] | [NAME] | ~
FERC 714 (Annual Electric Control & Planning Report)
Part 2, Sch 1: Generation by Plant @ Yearly Peak Hour | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2 , Sch 2: Capability @ Monthly Peak Hour (Monthly) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 3: Net Energy for Monthly Load and Peak Demand (Monthly) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 4: Control Area Interconnections | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 5: Yearly Scheduled and Actual Control Area Interchange | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 2, Sch 6: Yearly Control Area Lambda by Hour | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 3, Sch 1: Utilities that Compose the Planning Area | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
Part 3, Sch 2: (see below) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
a) Control Area load by Hour | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
b) Projected 10 Year Control Area Seasonal Peaks and Yearly Net Energy Demand | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
FERC 715 (Annual Transmission Planning & Evaluation Report) | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | ~
FERC Form 1 | [NAME] | ~ | ~ | ~ | ~ | ~ | ~