taxonomy().concept(ferc:ScheduleStatisticsOfOperationsOwnedByRespondentButOperatedByOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text
Statistics of Operations
|
taxonomy().concept(ferc:ScheduleStatisticsOfOperationsOwnedByRespondentButOperatedByOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
- Give particulars (details) by States of origin for crude oil and for each kind of product received year to date and totals only (i.e., no State detail) for number of barrels of crude oil and of each kind of product delivered out of the pipeline year to date. Classify and list in column (b) by States of origin the refined products transported in the following order: 29111, Gasoline, jet fuels, and other high volatile petroleum fuels, except natural gasoline; 29112, Kerosene; 29113, Distillate fuel oil; 29114, Lubricating and similar oils and derivatives; 29117, Residual fuel oil and other low volatile petroleum fuels; 29112, Products of petroleum refining, n.e.c. - Specify.
- In column (c) show all oils received by the respondent from connecting carriers reporting to the Federal Energy Regulatory Commission. In column (d) show all oils originated on respondent’s gathering lines and in column (e) all oils received into respondent’s trunk line, except receipts shown in columns (c) and (d). Any barrels received into a pipeline owned by the respondent, but operated by others, should be reported separately on additional pages (For example 600a- 601a, 600b- 601b, etc.).
- Entries in column (f) should be the sum of columns (c), (d), and (e). In column (g) show all oils delivered to connecting carriers reporting to the Federal Energy Regulatory Commission. In column (h) show all oils terminated on the respondent’s gathering lines, and in column (i) all oils delivered out of respondent’s pipeline, except deliveries shown under columns (g) and (h).
Entries in column (j) should be the sum of columns (g), (h), and (i). Any barrels delivered out of a pipeline owned by the respondent, but operated by others, should be reported separately on additional pages (For example 600a- 601a, 600b- 601b, etc.).
- Enter actual amount for lines 33a and 33b on an annual basis only. Do not report on a quarterly basis. Estimate if actual figures are not available. Barrel miles as reported on this schedule are the summation, for all segments, of the number of miles associated with each pipeline segment (trunk line only) multiplied by the number of barrels delivered through the segment. For example, 1,000 barrels moved through a 57-mile pipeline segment would be recorded as 57,000 barrel-miles. For a crude pipeline with several segments:
Segments |
Barrels |
Miles |
Barrel-Miles |
A |
1,000 |
57 |
57,000 |
B |
5,000 |
10 |
50,000 |
C |
1,000 |
25 |
25,000 |
|
|
|
|
Number of Barrels Received (Year to Date) |
Number of Barrels Delivered Out (Year to Date) |
|
|
|
|
ORIGINATED On |
|
|
TERMINATED On |
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleStatisticsOfOperationsOwnedByRespondentButOperatedByOthersAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "600a - Schedule - Statistics of Operations - Operator")
$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],taxonomy().concept(to-qname($row[3]))))
);
for $row in $heading_dict.keys.sort
$row
(a)
|
// adding a comment
/** FLAG TYPE IS USED TO RENDER CORRECTLY
** A = Listing of details
** B = Sub Total
** C = Grand Total
** D = Header
** E = Total Number of Barrel-Miles (End Disclosure)
**/
$CrudeHeader = list(list("","CRUDE OIL",none,none,none,none,none,none,none,none,none,"D"));
$ProductHeader = list(list("","PRODUCT",none,none,none,none,none,none,none,none,none,"D"));
$data1 = list(for $i in range(15)
list($i,none,none,none,none,none,none,none,none,none,none,"A")
);
$TotalNumberOfBarrelMilesBlank = list(list("33","33a Total Number of Barrel-Miles (Trunk Lines Only):",none,none,none,none,none,none, none, none,none,"E"),
list(0,"(1) Crude Oil", none, none,none,none,none,none,none,none,none,"E"),
list(0,"(2) Products", none,none,none, none,none,none,none,none,none,"E"));
$TotalNumberOfBarrelOfOilBlank = list(list("33","33b Total Number of Barrels of Oil Having Trunk-Line Movement:",none,none,none,none,none,none, none, none,none,"E"),
list(0,"(1) Crude Oil", none, none,none,none,none,none,none,none,none,"E"),
list(0,"(2) Products", none,none,none, none,none,none,none,none,none,"E"));
$data3 = list($CrudeHeader + $data1 + $ProductHeader + $data1 + $TotalNumberOfBarrelMilesBlank + $TotalNumberOfBarrelOfOilBlank);
$all-data = if list({covered @ferc:NameOfOperatorAxis=*}).length == 0
$data3
else
$data = if count(list({covered @ferc:StateOfOriginAndProductTypeAxis=*})) > 0
$operators = set({covered @ferc:NameOfOperatorAxis=*}.dimension(ferc:NameOfOperatorAxis));
list(for $x in $operators
$crudeOilDetail = list({covered @ferc:StateOfOriginAndProductTypeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:StateOfOriginOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit@period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:StateOfOriginOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:RefinedProductTypeOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit@period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:RefinedProductTypeOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none ,
"A"
)}});
$crudeOilDetailUnique = list(for $y in $crudeOilDetail
if $y == list($y[1],none,none,none,none,none,none,none,none,none, none, "A")
skip
else
$y
)
$crudeOilDetailSorted = $crudeOilDetailUnique.sort
$crudeOilTotal = list(list(15,
"Total",
none,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none
,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
"B"
));
$OilProductsDetail = list({covered @ferc:StateOfOriginAndProductTypeAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:StateOfOriginOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit@period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:StateOfOriginOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:RefinedProductTypeOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit@period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:RefinedProductTypeOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
if exists({@ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x})
first(list({@ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration @ferc:NameOfOperatorAxis = $x}))
else
none,
"A"
)}});
$OilProductsDetailUnique = list(for $y in $OilProductsDetail
if $y == list($y[1],none,none,none,none,none,none,none,none,none,none,"A")
skip
else
$y
)
$OilProductsDetailSorted = $OilProductsDetailUnique.sort
$OilProductsTotal = list(list(31,
"Total",
none,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none
,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
"B"
));
$GrandTotal = list(list(32,
"Grand Total",
none,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriersOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none
,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsReceivedOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriersOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none ,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLinesOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
if exists([covered @concept=ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
"C"
));
$TotalNumberOfBarrelMiles = list(list("33",
"33a Total Number of Barrel-Miles (Trunk Lines Only):",
none,
none,
none,
none,
none,
none,
none,
none,
none,
"E"
),
list(0,
"(1) Crude Oil",
if exists([covered @concept=ferc:NumberOfBarrelMilesOnTrunkLinesOfCrudeOilOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelMilesOnTrunkLinesOfCrudeOilOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
none,
none,
none,
none,
none,
none,
none,
none,
"E"
),
list(0,
"(2) Products",
if exists([covered @concept=ferc:NumberOfBarrelMilesOnTrunkLinesOfOilProductsOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelMilesOnTrunkLinesOfOilProductsOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
none,
none,
none,
none,
none,
none,
none,
none,
"E"
)
);
$TotalNumberOfBarrelOfOil = list(list("33",
"33b Total Number of Barrels of Oil Having Trunk-Line Movement:",
none,
none,
none,
none,
none,
none,
none,
none,
none,
"E"
),
list(0,
"(1) Crude Oil",
if exists([covered @concept=ferc:NumberOfBarrelsOfOilHavingTrunkLineMovementForCrudeOilOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsOfOilHavingTrunkLineMovementForCrudeOilOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
none,
none,
none,
none,
none,
none,
none,
none,
"E"
),
list(0,
"(2) Products",
if exists([covered @concept=ferc:NumberOfBarrelsOfOilHavingTrunkLineMovementForOilProductsOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x])
first(list([covered @concept=ferc:NumberOfBarrelsOfOilHavingTrunkLineMovementForOilProductsOwnedByRespondentButOperatedByOthers @period = $currentDuration @ferc:NameOfOperatorAxis = $x]))
else
none,
none,
none,
none,
none,
none,
none,
none,
none,
"E"
)
);
list(list("","Name of Operator: " + $x.string,none,none,none,none,none,none,none,none,none,"D")) +
$CrudeHeader +
$crudeOilDetailSorted +
$crudeOilTotal +
$ProductHeader +
$OilProductsDetailSorted +
$OilProductsTotal +
$GrandTotal +
$TotalNumberOfBarrelMiles +
$TotalNumberOfBarrelOfOil
)
else
$data3
$data
;
for $rows in $all-data
for $row in $rows
1
|
$row[2]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
if $row[12] == "D" "col-heading" else "description_items"
if $row[12] == "A" true else false
if $row[1] == "33" "overflow" else ""
Alaska
|
$row[3]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
if $row[12] == "E" "numeric_items" else "description_items"
21000
|
$row[4]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
100,000
|
$row[5]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
120,000
|
$row[6]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
140,000
|
$row[7]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
920,000
|
$row[8]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
820,000
|
$row[9]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
420,000
|
$row[10]
if $row[12] == "E" "xbrl-no-box" else "xbrl"
220,000
|
$row[11]
if $row[12] == "E" "xbrl-right-side-only" else "xbrl"
760,000
|