taxonomy().concept(ferc:ScheduleTransmissionServiceAndGenerationInterconnectionStudyCostsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FScheduleTitle").text
XXIV Transmission Service and Generation Interconnection Study Costs
|
taxonomy().concept(ferc:ScheduleTransmissionServiceAndGenerationInterconnectionStudyCostsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report the particulars (details) called for concerning the costs incurred and the reimbursements received for performing transmission service and generator interconnection studies.
- List each study separately.
- In column (a) provide the name of the study.
- In column (b) report the cost incurred to perform the study at the end of period.
- In column (c) report the account charged with the cost of the study.
- In column (d) report the amounts received for reimbursement of the study costs at end of period.
- In column (e) report the account credited with the reimbursement received for performing the study.
|
Line No. |
/** THIS CODE EXCLUDES ELEMENT NAMES AS THERE ARE NO ELEMENT SPECIFIC COLUMNS **/
$headings = filter (taxonomy().concept(ferc:ScheduleTransmissionServiceAndGenerationInterconnectionStudyCostsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "F1F - 024 - Schedule - Transmission Service and Generation Interconnection Study Costs")
$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)
|
|
taxonomy().concept(ferc:TransmissionStudiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FTransmissionAndGenerationStudyCosts").text
Transmission Studies
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(1,9)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=*})) > 0
list({covered @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfStudyPerformed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfStudyPerformed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsAccountCharged @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsAccountCharged @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsAccountReimbursed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsAccountReimbursed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration}))
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
1
|
$row[2]
Study 1
|
$row[3]
$1,111,111
|
$row[4]
999
|
$row[5]
$2,222,222
|
$row[6]
888
|
10 |
taxonomy().concept(ferc:StudyCostsIncurred).label("http://ferc.gov/form/2020-01-01/roles/label/F1Total").text
Total
|
max(list([covered @concept=ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @period = $currentDuration]))
$4,600,000
|
|
max(list([covered @concept=ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @period = $currentDuration]))
$2,600,000
|
|
|
taxonomy().concept(ferc:GenerationStudiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1FTransmissionAndGenerationStudyCosts").text
Generation Studies
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(18)
list($i,none,none,none,none,none)
);
$data = if count(list({covered @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=*})) > 0
list({covered @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=* {list(
if count(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration }))
else
0,
if exists({@ferc:DescriptionOfStudyPerformed @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfStudyPerformed @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsAccountCharged @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsAccountCharged @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration}))
else
none,
if exists({@ferc:StudyCostsAccountReimbursed @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration})
first(list({@ferc:StudyCostsAccountReimbursed @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @unit @period=$currentDuration}))
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
11
|
$row[2]
Study 2
|
$row[3]
$4,444,444
|
$row[4]
777
|
$row[5]
$1,729,061
|
$row[6]
666
|
19 |
taxonomy().concept(ferc:StudyCostsIncurred).label("http://ferc.gov/form/2020-01-01/roles/label/F1Total").text
Total
|
max(list([covered @concept=ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @period = $currentDuration]))
$6,800,000
|
|
max(list([covered @concept=ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:GenerationStudiesMember @period = $currentDuration]))
$8,600,000
|
|
20 |
Grand Total
|
max(list([covered @concept=ferc:StudyCostsIncurred @period = $currentDuration]))
$12,800,000
|
|
max(list([covered @concept=ferc:StudyCostsReimbursements @period = $currentDuration]))
$18,600,000
|
|