taxonomy().concept(ferc:ScheduleAmountsIncludedInIsoOrRtoSettlementAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
AMOUNTS INCLUDED IN ISO/RTO SETTLEMENT STATEMENTS
|
taxonomy().concept(ferc:ScheduleAmountsIncludedInIsoOrRtoSettlementAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- The respondent shall report below the details called for concerning amounts it recorded in Account 555, Purchase Power, and Account 447, Sales for Resale, for items shown on ISO/RTO Settlement Statements. Transactions should be separately netted for each ISO/RTO administered energy market for purposes of determining whether an entity is a net seller or purchaser in a given hour. Net megawatt hours are to be used as the basis for determining whether a net purchase or sale has occurred. In each monthly reporting period, the hourly sale and purchase net amounts are to be aggregated and separately reported in Account 447, Sales for Resale, or Account 555, Purchased Power, respectively.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleAmountsIncludedInIsoOrRtoSettlementAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "397 - Schedule - Amounts Included in ISO/RTO Settlement Statements")
$headings = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value))
$heading_dict = dict(for $row in $headings
list("("+$row[1]+")",$row[2])
);
for $row in $heading_dict.keys.sort
$heading_dict[$row]
Description of Item(s)
$row
(a)
|
1 |
Energy
|
|
|
|
|
2 |
Net Purchases (Account 555)
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPurchasedPower @period = $currentQ1Duration]))
$11,859,030
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPurchasedPower @period = $currentCumQ2]))
$54,224,053
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPurchasedPower @period = $currentCumQ3]))
$83,226,981
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPurchasedPower @period = $currentCumQ4]))
$96,317,355
|
2.1 |
Net Purchases (Account 555.1)
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPowerPurchasedForStorageOperations @period = $currentQ1Duration]))
$11,859,030
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPowerPurchasedForStorageOperations @period = $currentCumQ2]))
$54,224,053
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPowerPurchasedForStorageOperations @period = $currentCumQ3]))
$83,226,981
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchasesPowerPurchasedForStorageOperations @period = $currentCumQ4]))
$96,317,355
|
3 |
Net Sales (Account 447)
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetSales @period = $currentQ1Duration]))
$1,759,665
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetSales @period = $currentCumQ2]))
$3,927,607
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetSales @period = $currentCumQ3]))
$7,643,676
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetSales @period = $currentCumQ4]))
$14,694,716
|
4 |
Transmission Rights
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsTransmissionRights @period = $currentQ1Duration]))
$2,768,275
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsTransmissionRights @period = $currentCumQ2]))
$6,649,797
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsTransmissionRights @period = $currentCumQ3]))
$17,116,032
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsTransmissionRights @period = $currentCumQ4]))
$22,405,211
|
5 |
Ancillary Services
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsAncillaryServices @period = $currentQ1Duration]))
$245,764
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsAncillaryServices @period = $currentCumQ2]))
$231,243
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsAncillaryServices @period = $currentCumQ3]))
$136,844
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsAncillaryServices @period = $currentCumQ4]))
$389,879
|
6 |
Other Items (list separately)
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(7,45)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:AmountsIncludedInIsoOrRtoSettlementStatementsAxis=*})) > 0
list({covered @ferc:AmountsIncludedInIsoOrRtoSettlementStatementsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:IsoOrRtoSettlementsDescriptionOfOtherItems @unit @period=$currentDuration})
first(list({@ferc:IsoOrRtoSettlementsDescriptionOfOtherItems @unit @period=$currentDuration}))
else
none,
if exists({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentQ1Duration})
first(list({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentQ1Duration}))
else
none,
if exists({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentCumQ2})
first(list({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentCumQ2}))
else
none,
if exists({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentCumQ3})
first(list({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentCumQ3}))
else
none,
if exists({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentCumQ4})
first(list({@ferc:IsoOrRtoSettlementsOtherItems @unit @period=$currentCumQ4}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
7
|
$row[2]
Various
|
$row[3]
$7,951
|
$row[4]
$27,416
|
$row[5]
$52,892
|
$row[6]
$69,971
|
46 |
TOTAL
|
first(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentQ1Duration]))
$6,883,519
|
first(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentCumQ2]))
$42,784,274
|
first(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentCumQ3]))
$56,613,303
|
first(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentCumQ4]))
$56,927,662
|