taxonomy().concept(ferc:ScheduleAmountsIncludedInIsoOrRtoSettlementAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FScheduleTitle").text
XXV 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.
|
Line No. |
/** THIS CODE EXCLUDES ELEMENT NAMES AS THERE ARE NO ELEMENT SPECIFIC COLUMNS **/
$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 == "F1F - 025 - 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]
Title of Account
$row
(a)
|
1 |
Energy
|
|
|
|
|
2 |
Net Purchases (Account 555)
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchases @period = $currentQ1Duration]))
$11,859,030
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchases @period = $currentCumQ2]))
$54,224,053
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchases @period = $currentCumQ3]))
$83,226,981
|
first(list([covered
@concept=ferc:IsoOrRtoSettlementsEnergyNetPurchases @period = $currentDuration]))
$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,11)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:AmountsIncludedInIsoOrRtoSettlementStatementsAxis=*})) > 0
list({covered @ferc:AmountsIncludedInIsoOrRtoSettlementStatementsAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
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
|
12 |
TOTAL
|
max(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentQ1Duration]))
$6,883,519
|
max(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentCumQ2]))
$42,784,274
|
max(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentCumQ3]))
$56,613,303
|
max(list([covered
@concept=ferc:IsoOrRtoSettlements @period =
$currentCumQ4]))
$56,927,662
|