if set('1-F').contains([covered @concept.local-name ='FormType']) if first(list([covered @ferc:PurchasedPowerMajorNonmajor])) == "Major" true else false else true
taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F1Header").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/F1Header").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/F1Header").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/F1Header").text Year/Period of Report:
End of: [@ferc:ReportYear @period=$currentDuration] 2018 / [@ferc:ReportPeriod @period=$currentDuration] Q4
// adding a comment $data2 = list(for $i in range(14) list($i,none,none,none,none,none,none,none,none,none,none,none,none,none,none) ); $data = if count(list({covered @ferc:PurchasedPowerAxis=*})) > 0 $PurchasedPowers = set({covered @ferc:PurchasedPowerAxis=*}.dimension(ferc:PurchasedPowerAxis)); list(for $x in $PurchasedPowers list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:PurchasedPowerAxis = $x}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else 0, if exists({@ferc:NameOfCompanyOrPublicAuthorityProvidingPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:NameOfCompanyOrPublicAuthorityProvidingPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:StatisticalClassificationCode @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:StatisticalClassificationCode @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:AverageMonthlyBillingDemand @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:AverageMonthlyBillingDemand @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:AverageMonthlyNonCoincidentPeakDemand @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:AverageMonthlyNonCoincidentPeakDemand @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:AverageMonthlyCoincidentPeakDemand @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:AverageMonthlyCoincidentPeakDemand @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:MegawattHoursPurchasedOtherThanStorage @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:MegawattHoursPurchasedOtherThanStorage @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:MegawattHoursPurchasedForEnergyStorage @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:MegawattHoursPurchasedForEnergyStorage @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:EnergyReceivedThroughPowerExchanges @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:EnergyReceivedThroughPowerExchanges @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:EnergyDeliveredThroughPowerExchanges @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:EnergyDeliveredThroughPowerExchanges @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:DemandChargesOfPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:DemandChargesOfPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:EnergyChargesOfPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:EnergyChargesOfPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:OtherChargesOfPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:OtherChargesOfPurchasedPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) else none, if exists({@ferc:SettlementOfPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x}) first(list({@ferc:SettlementOfPower @unit @period=$currentDuration @ferc:PurchasedPowerAxis = $x})) 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) skip else $x ); for $row in $uniqueData.sort
taxonomy().concept(ferc:SchedulePurchasedPowerAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text PURCHASED POWER (Account 555)
taxonomy().concept(ferc:SchedulePurchasedPowerAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
  1. Report all power purchases made during the year. Also report exchanges of electricity (i.e., transactions involving a balancing of debits and credits for energy, capacity, etc.) and any settlements for imbalanced exchanges.
  2. Enter the name of the seller or other party in an exchange transaction in column (a). Do not abbreviate or truncate the name or use acronyms. Explain in a footnote any ownership interest or affiliation the respondent has with the seller.
  3. In column (b), enter a Statistical Classification Code based on the original contractual terms and conditions of the service as follows:
    RQ - for requirements service. Requirements service is service which the supplier plans to provide on an ongoing basis (i.e., the supplier includes projects load for this service in its system resource planning). In addition, the reliability of requirement service must be the same as, or second only to, the supplier’s service to its own ultimate consumers.

    LF - for long-term firm service. "Long-term" means five years or longer and "firm" means that service cannot be interrupted for economic reasons and is intended to remain reliable even under adverse conditions (e.g., the supplier must attempt to buy emergency energy from third parties to maintain deliveries of LF service). This category should not be used for long-term firm service firm service which meets the definition of RQ service. For all transaction identified as LF, provide in a footnote the termination date of the contract defined as the earliest date that either buyer or seller can unilaterally get out of the contract.

    IF - for intermediate-term firm service. The same as LF service expect that "intermediate-term" means longer than one year but less than five years.

    SF - for short-term service. Use this category for all firm services, where the duration of each period of commitment for service is one year or less.

    LU - for long-term service from a designated generating unit. "Long-term" means five years or longer. The availability and reliability of service, aside from transmission constraints, must match the availability and reliability of the designated unit.

    IU - for intermediate-term service from a designated generating unit. The same as LU service expect that "intermediate-term" means longer than one year but less than five years.

    EX - For exchanges of electricity. Use this category for transactions involving a balancing of debits and credits for energy, capacity, etc. and any settlements for imbalanced exchanges.

    OS - for other service. Use this category only for those services which cannot be placed in the above-defined categories, such as all non-firm service regardless of the Length of the contract and service from designated units of Less than one year. Describe the nature of the service in a footnote for each adjustment.

    AD - for out-of-period adjustment. Use this code for any accounting adjustments or "true-ups" for service provided in prior reporting years. Provide an explanation in a footnote for each adjustment.
  4. In column (c), identify the FERC Rate Schedule Number or Tariff, or, for non-FERC jurisdictional sellers, include an appropriate designation for the contract. On separate lines, list all FERC rate schedules, tariffs or contract designations under which service, as identified in column (b), is provided.
  5. For requirements RQ purchases and any type of service involving demand charges imposed on a monnthly (or longer) basis, enter the monthly average billing demand in column (d), the average monthly non-coincident peak (NCP) demand in column (e), and the average monthly coincident peak (CP) demand in column (f). For all other types of service, enter NA in columns (d), (e) and (f). Monthly NCP demand is the maximum metered hourly (60-minute integration) demand in a month. Monthly CP demand is the metered demand during the hour (60-minute integration) in which the supplier's system reaches its monthly peak. Demand reported in columns (e) and (f) must be in megawatts. Footnote any demand not stated on a megawatt basis and explain.
  6. Report in column (g) the megawatthours shown on bills rendered to the respondent. Report in columns (i) and (j) the megawatthours of power exchanges received and delivered, used as the basis for settlement. Do not report net exchange.
  7. Report demand charges in column (k), energy charges in column (l), and the total of any other types of charges, including out-of-period adjustments, in column (m). Explain in a footnote all components of the amount shown in column (m). Report in column (n) the total charge shown on bills received as settlement by the respondent. For power exchanges, report in column (n) the settlement amount for the net receipt of energy. If more energy was delivered than received, enter a negative amount. If the settlement amount (m) include credits or charges other than incremental generation expenses, or (2) excludes certain credits or charges covered by the agreement, provide an explanatory footnote.
  8. The data in column (g) through (n) must be totalled on the last line of the schedule. The total amount in column (g) must be reported as Purchases on Page 401, line 10. The total amount in column (i) must be reported as Exchange Received on Page 401, line 12. The total amount in column (j) must be reported as Exchange Delivered on Page 401, line 13.
  9. Footnote entries as required and provide explanations following all required data.
Actual Demand (MW) POWER EXCHANGES COST/SETTLEMENT OF POWER
Line No. $headings = filter (taxonomy().concept(ferc:SchedulePurchasedPowerAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "326 - Schedule - Purchased Power") $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
$heading_dict[$row][2].name.local-name
$heading_dict[$row][1] Name of Company or Public Authority (Footnote Affiliations)
$row (a)
1 $row[2] Board of Pub Util, City of McPherson $row[5] 1 $row[6] 2 $row[7] 3 $row[8] 29,882 $row[9] 4 $row[10] 5 $row[11] 2,817,544 $row[12] $2,519,814 $row[13] $10 $row[14] $5,337,368 $row[15] $5,337,368
15 TOTAL max(list([covered @concept=ferc:MegawattHoursPurchasedOtherThanStorage @period = $currentDuration])) 90 max(list([covered @concept=ferc:MegawattHoursPurchasedForEnergyStorage @period = $currentDuration])) 90 max(list([covered @concept=ferc:EnergyReceivedThroughPowerExchanges @period = $currentDuration])) 90.15 max(list([covered @concept=ferc:EnergyDeliveredThroughPowerExchanges @period = $currentDuration])) 28 max(list([covered @concept=ferc:DemandChargesOfPurchasedPower @period = $currentDuration])) 21,431,404 max(list([covered @concept=ferc:EnergyChargesOfPurchasedPower @period = $currentDuration])) $169,458,063 max(list([covered @concept=ferc:OtherChargesOfPurchasedPower @period = $currentDuration])) -$24,000,000 max(list([covered @concept=ferc:SettlementOfPower @period = $currentDuration])) $166,852,492