taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Name of Respondent:

[@ferc:RespondentLegalName @period=$currentDuration] Duke Energy Kentucky, Inc.
taxonomy().concept(ferc:SubmissionType).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text This report is:

(1) if missing({covered @concept=ferc:SubmissionType}) ☐ An Original']]> else if [@concept=ferc:SubmissionType @period=$currentDuration] == "O" ☑ An Original']]> else ☐ An Original']]> An Original

(2) if missing([covered @concept=ferc:SubmissionType @period=$currentDuration]) ☐ A Resubmission']]> else if [@concept=ferc:SubmissionType @period=$currentDuration] == "R" ☑ A Resubmission']]> else ☐ A Resubmission']]> A Resubmission
taxonomy().concept(ferc:ReportDate).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Date of Report:

[@ferc:ReportDate @period=$currentDuration] 04/26/2019
taxonomy().concept(ferc:ReportYearPeriod).label("http://ferc.gov/form/2020-01-01/roles/label/F2Header").text Year/Period of Report:

End of: [@ferc:ReportYear @period=$currentDuration] 2018 / [@ferc:ReportPeriod @period=$currentDuration] Q4
$dataHead = navigate parent-child descendants from ferc:SalesOfGasForfeitedDiscountsAndMiscellaneousServiceRevenuesAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order); $months = list($currentQM1, $currentQM2, $currentQM3); $schedule = list(list(for $month in $months for $x in $dataHead if list([covered @concept = $x[1] @period = $month]).length > 0 first(list([covered @concept = $x[1] @period = $month])) else none )); for $rowl in $schedule // adding a comment $data2 = list(for $i in range(60) list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none) ); $data = if count(list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleAxis=*})) > 0 list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleAxis=* {list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:DescriptionOfAccountAndRateSchedule @unit@period=$currentDuration}) first(list({@ferc:DescriptionOfAccountAndRateSchedule @unit @period=$currentDuration})) else none, if exists({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM1}) first(list({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM1})) else none, if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM1}) first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM1})) else none, if exists({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM1}) first(list({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM1})) else none, if exists({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM1}) first(list({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM1})) else none, if exists({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM1}) first(list({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM1})) else none, if exists({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM2}) first(list({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM2})) else none, if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM2}) first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM2})) else none, if exists({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM2}) first(list({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM2})) else none, if exists({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM2}) first(list({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM2})) else none, if exists({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM2}) first(list({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM2})) else none, if exists({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM3}) first(list({@ferc:QuantityOfGasTransportationOfGasForOthers @unit @period=$currentQM3})) else none, if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM3}) first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayTransportationOfGasForOthers @unit @period=$currentQM3})) else none, if exists({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM3}) first(list({@ferc:RevenuesForGriAndAcaTransportationOfGasForOthers @unit @period=$currentQM3})) else none, if exists({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM3}) first(list({@ferc:OtherRevenuesTransportationOfGasForOthers @unit @period=$currentQM3})) else none, if exists({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM3}) first(list({@ferc:OperatingRevenuesTransportationOfGasForOthers @unit @period=$currentQM3})) else none )}}) else $data2; $uniqueData = list(for $x in $data if $x == list(0,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none) skip else $x ); for $row in $uniqueData.sort $dataHead = navigate parent-child descendants from ferc:RevenueFromTransportationOfGasForOthersAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order); $months = list($currentQM1, $currentQM2, $currentQM3); $schedule = list(list(for $month in $months for $x in $dataHead if list([covered @concept = $x[1] @period = $month]).length > 0 first(list([covered @concept = $x[1] @period = $month])) else none )); for $rowl in $schedule // adding a comment $data2 = list(for $i in range(25) list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none) ); $data = if count(list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleStorageAxis=*})) > 0 list({covered @ferc:MonthlyQuantityAndRevenueByRateScheduleStorageAxis=* {list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:DescriptionOfAccountAndRateSchedule @unit@period=$currentDuration}) first(list({@ferc:DescriptionOfAccountAndRateSchedule @unit @period=$currentDuration})) else none, if exists({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM1}) first(list({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM1})) else none, if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM1}) first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM1})) else none, if exists({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM1}) first(list({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM1})) else none, if exists({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM1}) first(list({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM1})) else none, if exists({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM1}) first(list({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM1})) else none, if exists({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM2}) first(list({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM2})) else none, if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM2}) first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM2})) else none, if exists({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM2}) first(list({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM2})) else none, if exists({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM2}) first(list({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM2})) else none, if exists({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM2}) first(list({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM2})) else none, if exists({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM3}) first(list({@ferc:QuantityOfGasStoringGasOfOthers @unit @period=$currentQM3})) else none, if exists({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM3}) first(list({@ferc:RevenuesFromTransitionCostsAndTakeOrPayRevenuesFromStoringGasOfOthers @unit @period=$currentQM3})) else none, if exists({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM3}) first(list({@ferc:RevenuesForGriAndAcaRevenuesFromStoringGasOfOthers @unit @period=$currentQM3})) else none, if exists({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM3}) first(list({@ferc:OtherRevenuesRevenuesFromStoringGasOfOthers @unit @period=$currentQM3})) else none, if exists({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM3}) first(list({@ferc:RevenuesFromStoringGasOfOthers @unit @period=$currentQM3})) else none )}}) else $data2; $uniqueData = list(for $x in $data if $x == list(0,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none,none) skip else $x ); for $row in $uniqueData.sort $dataHead = navigate parent-child descendants from ferc:RevenuesFromStoringGasOfOthersAbstract role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order); $months = list($currentQM1, $currentQM2, $currentQM3); $schedule = list(list(for $month in $months for $x in $dataHead if list([covered @concept = $x[1] @period = $month]).length > 0 first(list([covered @concept = $x[1] @period = $month])) else none )); for $rowl in $schedule $dataHead = navigate parent-child descendants from ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilitiesAbstract stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order); $rollforwardSection = list(for $x in $dataHead $abstractConcept = taxonomy().concept($x[1]); $is-heading = if ($x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader") true else false; $abstractLabel = list($is-heading, $abstractConcept.label($x[2].role.uri).text); $data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list(target, preferred-label, order); $months = list($currentQM1, $currentQM2, $currentQM3); $dataRow1 = list(for $month in $months for $y in $data if list([covered @concept = $y[1] @period = $month]).length > 0 first(list([covered @concept = $y[1] @period = $month])) else none ); $abstractLabel + $dataRow1 ) for $rowl in $rollforwardSection $dataHead = navigate parent-child descendants from ferc:AdditionalOperatingRevenueAbstract stop when $relationship.preferred-label == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader" role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list (target-name, preferred-label, order); $rollforwardSection = list(for $x in $dataHead $abstractConcept = taxonomy().concept($x[1]); $is-heading = if ($x[2].role.uri == "http://ferc.gov/form/2020-01-01/roles/label/F2RollforwardHeader") true else false; $abstractLabel = list($is-heading, $abstractConcept.label($x[2].role.uri).text); $data = navigate parent-child children from $x[1] role "http://ferc.gov/form/2020-01-01/roles/Schedule/F2/MonthlyQuantityRevenueDataByRateSchedule" returns list(target, preferred-label, order); $months = list($currentQM1, $currentQM2, $currentQM3); $dataRow1 = list(for $month in $months for $y in $data if list([covered @concept = $y[1] @period = $month]).length > 0 first(list([covered @concept = $y[1] @period = $month])) else none ); $abstractLabel + $dataRow1 ) for $rowl in $rollforwardSection
taxonomy().concept(ferc:ScheduleMonthlyQuantityRevenueDataByRateScheduleAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2ScheduleTitle").text Monthly Quantity & Revenue Data by Rate Schedule
taxonomy().concept(ferc:ScheduleMonthlyQuantityRevenueDataByRateScheduleAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Instructions").text
  1. Reference to account numbers in the USofA is provided in parentheses beside applicable data. Quantities must not be adjusted for discounts.
  2. Total Quantities and Revenues in whole numbers.
  3. Report revenues and quantities of gas by rate schedule. Where transportation services are bundled with storage services, reflect only transportation Dth. When reporting storage, report Dth of gas withdrawn from storage and revenues by rate schedule.
  4. Revenues in Column (c) include transition costs from upstream pipelines. Revenue (Other) in Column (e) includes reservation charges received by the pipeline plus usage charges, less revenues reflected in Columns (c) and (d). Include in Column (e), revenue for Accounts 490-495.
  5. Enter footnotes as appropriate.
Line No. $headings = filter (taxonomy().concept(ferc:ScheduleMonthlyQuantityRevenueDataByRateScheduleAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "299 - Schedule - Monthly Quantity & Revenue Data by Rate Schedule") $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]= Item
$row (a)
1 taxonomy().concept(ferc:SalesOfGasForfeitedDiscountsAndMiscellaneousServiceRevenuesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total Sales (480-488)
$rowl[1] 400,000 dth $rowl[2] $400,000 $rowl[3] $400,000 $rowl[4] $400,000 $rowl[5] $400,000 $rowl[6] 400,000 dth $rowl[7] $400,000 $rowl[8] $400,000 $rowl[9] $400,000 $rowl[10] $400,000 $rowl[11] 400,000 dth $rowl[12] $400,000 $rowl[13] $400,000 $rowl[14] $400,000 $rowl[15] $400,000
2 taxonomy().concept(ferc:RevenueFromTransportationOfGasForOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Transportation of Gas for Others (489.2 and 489..3)
3 1 $row[2] if $row[2].is-fact "true" else "false" Human Resources Co $row[3] 100 $row[4] $100 $row[5] $100 $row[6] $100 $row[7] $100 $row[8] $100 $row[9] $100 $row[10] $100 $row[11] $100 $row[12] $100 $row[13] $100 $row[14] $100 $row[15] $100 $row[16] $100 $row[17] $100
63 taxonomy().concept(ferc:OperatingRevenuesTransportationOfGasForOthers).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total Transportation (Other than Gathering)
$rowl[1] 400,000 dth $rowl[2] $400,000 $rowl[3] $400,000 $rowl[4] $400,000 $rowl[5] $400,000 $rowl[6] 400,000 dth $rowl[7] $400,000 $rowl[8] $400,000 $rowl[9] $400,000 $rowl[10] $400,000 $rowl[11] 400,000 dth $rowl[12] $400,000 $rowl[13] $400,000 $rowl[14] $400,000 $rowl[15] $400,000
64 64 taxonomy().concept(ferc:RevenuesFromStoringGasOfOthersAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Storage (489.4)
65 65 $row[2] if $row[2].is-fact "true" else "false" Human Resources Co $row[3] 100 $row[4] $100 $row[5] $100 $row[6] $100 $row[7] $100 $row[8] $100 $row[9] $100 $row[10] $100 $row[11] $100 $row[12] $100 $row[13] 100 $row[14] $100 $row[15] $100 $row[16] $100 $row[17] $100
90 taxonomy().concept(ferc:RevenuesFromStoringGasOfOthers).label("http://ferc.gov/form/2020-01-01/roles/label/F2Total").text
Total Storage
$rowl[1] 400,000 dth $rowl[2] $400,000 $rowl[3] $400,000 $rowl[4] $400,000 $rowl[5] $400,000 $rowl[6] 400,000 dth $rowl[7] $400,000 $rowl[8] $400,000 $rowl[9] $400,000 $rowl[10] $400,000 $rowl[11] 400,000 dth $rowl[12] $400,000 $rowl[13] $400,000 $rowl[14] $400,000 $rowl[15] $400,000
91 taxonomy().concept(ferc:RevenuesFromTransportationOfGasOfOthersThroughGatheringFacilitiesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Gathering (489.1)
92 92 $rowl[2] $rowl[3] 400,000 dth $rowl[4] $400,000 $rowl[5] $400,000 $rowl[6] $400,000 $rowl[7] $400,000 $rowl[8] 400,000 dth $rowl[9] $400,000 $rowl[10] $400,000 $rowl[11] $400,000 $rowl[12] $400,000 $rowl[13] 400,000 dth $rowl[14] $400,000 $rowl[15] $400,000 $rowl[16] $400,000 $rowl[17] $400,000
95 taxonomy().concept(ferc:AdditionalOperatingRevenueAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F2RateSchedule").text
Additional Revenues
96 96 $rowl[2] $rowl[3] 400,000 dth $rowl[4] $400,000 $rowl[5] $400,000 $rowl[6] $400,000 $rowl[7] $400,000 $rowl[8] 400,000 dth $rowl[9] $400,000 $rowl[10] $400,000 $rowl[11] $400,000 $rowl[12] $400,000 $rowl[13] 400,000 dth $rowl[14] $400,000 $rowl[15] $400,000 $rowl[16] $400,000 $rowl[17] $400,000