taxonomy().concept(ferc:ScheduleTransmissionServiceAndGenerationInterconnectionStudyCostsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
Gas Property And Capacity Leased From Others
|
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. |
$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 == "231 - Schedule - Transmission Service and Generation Interconnection Study Costs")
$heading = list(for $ref in $headings
list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value))
$heading_dict = dict(for $row in $heading
list("("+$row[1]+")",list($row[2],
if $row[3] == none
""
else
taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
1 |
taxonomy().concept(ferc:TransmissionStudiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1TransmissionAndGenerationStudyCosts").text
Transmission Studies
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(2,19)
list($i," ",none,none,none,none,none, none)
);
$data = if count(list({covered @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=*})) > 0
$studyCosts = set({covered @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=*}.dimension(ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis));
list(for $x in $studyCosts
list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}))
else
0,
$x,
if exists({@ferc:DescriptionOfStudyPerformed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x})
first(list({@ferc:DescriptionOfStudyPerformed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}))
else
none,
if exists({@ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x})
first(list({@ferc:StudyCostsIncurred @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}))
else
none,
if exists({@ferc:StudyCostsAccountCharged @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x})
first(list({@ferc:StudyCostsAccountCharged @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}))
else
none,
if exists({@ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x})
first(list({@ferc:StudyCostsReimbursements @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}))
else
none,
if exists({@ferc:StudyCostsAccountReimbursed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x})
first(list({@ferc:StudyCostsAccountReimbursed @ferc:StudyTypeAxis=ferc:TransmissionStudiesMember @unit @period=$currentDuration @ferc:TransmissionServiceAndGenerationInterconnectionStudyCostsAxis=$x}))
else
none
))
else $data2;
$uniqueData = list(for $x in $data
if $x == list($x[1],$x[2],none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
2
|
$row[3]
Study 1
|
$row[4]
$1,111,111
|
$row[5]
999
|
$row[6]
$2,222,222
|
$row[7]
888
|
20 |
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
|
|
21 |
taxonomy().concept(ferc:GenerationStudiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1TransmissionAndGenerationStudyCosts").text
Generation Studies
|
|
|
|
|
// adding a comment
$data2 = list(for $i in range(22,38)
list($i,none,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: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($x[1],none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
22
|
$row[2]
Study 2
|
$row[3]
$4,444,444
|
$row[4]
777
|
$row[5]
$1,729,061
|
$row[6]
666
|
39 |
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
|
|
40 |
Grand Total
|
max(list([covered @concept=ferc:StudyCostsIncurred @period = $currentDuration]))
$12,800,000
|
|
max(list([covered @concept=ferc:StudyCostsReimbursements @period = $currentDuration]))
$18,600,000
|
|