if ([covered @concept.local-name = "FormType"]) == '1-F' if first(list([covered @ferc:SalesForResaleMajorNonmajor])) == "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) ); $data = if count(list({covered @ferc:SalesForResaleAxis=*})) > 0 list({covered @ferc:SalesForResaleAxis=* {list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:NameOfCompanyOrPublicAuthorityReceivingElectricityPurchasedForResale @unit @period=$currentDuration}) first(list({@ferc:NameOfCompanyOrPublicAuthorityReceivingElectricityPurchasedForResale @unit @period=$currentDuration})) else none, if exists({@ferc:StatisticalClassificationCode @unit @period=$currentDuration}) first(list({@ferc:StatisticalClassificationCode @unit @period=$currentDuration})) else none, if exists({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration}) first(list({@ferc:RateScheduleTariffNumber @unit @period=$currentDuration})) else none, if exists({@ferc:AverageMonthlyBillingDemand @unit @period=$currentDuration}) first(list({@ferc:AverageMonthlyBillingDemand @unit @period=$currentDuration})) else none, if exists({@ferc:AverageMonthlyNonCoincidentPeakDemand @unit @period=$currentDuration}) first(list({@ferc:AverageMonthlyNonCoincidentPeakDemand @unit @period=$currentDuration})) else none, if exists({@ferc:AverageMonthlyCoincidentPeakDemand @unit @period=$currentDuration}) first(list({@ferc:AverageMonthlyCoincidentPeakDemand @unit @period=$currentDuration})) else none, if exists({@ferc:MegawattHoursSoldSalesForResale @unit @period=$currentDuration}) first(list({@ferc:MegawattHoursSoldSalesForResale @unit @period=$currentDuration})) else none, if exists({@ferc:DemandChargesRevenueSalesForResale @unit @period=$currentDuration}) first(list({@ferc:DemandChargesRevenueSalesForResale @unit @period=$currentDuration})) else none, if exists({@ferc:EnergyChargesRevenueSalesForResale @unit @period=$currentDuration}) first(list({@ferc:EnergyChargesRevenueSalesForResale @unit @period=$currentDuration})) else none, if exists({@ferc:OtherChargesRevenueSalesForResale @unit @period=$currentDuration}) first(list({@ferc:OtherChargesRevenueSalesForResale @unit @period=$currentDuration})) else none, if exists({@ferc:RevenueFromSalesOfElectricityForResale @unit @period=$currentDuration}) first(list({@ferc:RevenueFromSalesOfElectricityForResale @unit @period=$currentDuration})) 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) skip else $x ); for $row in $uniqueData.sort
taxonomy().concept(ferc:ScheduleSalesForResaleAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text SALES FOR RESALE (Account 447)
taxonomy().concept(ferc:ScheduleSalesForResaleAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
  1. Report all sales for resale (i.e., sales to purchasers other than ultimate consumers) transacted on a settlement basis other than power exchanges during the year. Do not report exchanges of electricity ( i.e., transactions involving a balancing of debits and credits for energy, capacity, etc.) and any settlements for imbalanced exchanges on this schedule. Power exchanges must be reported on the Purchased Power schedule (Page 326-327).
  2. Enter the name of the purchaser in column (a). Do note abbreviate or truncate the name or use acronyms. Explain in a footnote any ownership interest or affiliation the respondent has with the purchaser.
  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 projected load for this service in its system resource planning). In addition, the reliability of requirements service must be the same as, or second only to, the supplier's service to its own ultimate consumers.

    LF - for tong-term 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 which meets the definition of RQ service. For all transactions identified as LF, provide in a footnote the termination date of the contract defined as the earliest date that either buyer or setter can unilaterally get out of the contract.

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

    SF - for short-term firm 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 designated unit.

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

    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.

    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. Group requirements RQ sales together and report them starting at line number one. After listing all RQ sales, enter "Subtotal - RQ" in column (a). The remaining sales may then be listed in any order. Enter "Subtotal-Non-RQ" in column (a) after this Listing. Enter "Total'' in column (a) as the Last Line of the schedule. Report subtotals and total for columns (g) through (k).
  5. In Column (c), identify the FERC Rate Schedule or Tariff Number. On separate Lines, List all FERC rate schedules or tariffs under which service, as identified in column (b), is provided.
  6. For requirements RQ sales and any type of-service involving demand charges imposed on a monthly (or Longer) basis, enter the average monthly 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.
  7. Report in column (g) the megawatt hours shown on bills rendered to the purchaser.
  8. Report demand charges in column (h), energy charges in column (i), and the total of any other types of charges, including out-of-period adjustments, in column (j). Explain in a footnote all components of the amount shown in column (j). Report in column (k) the total charge shown on bills rendered to the purchaser.
  9. The data in column (g) through (k) must be subtotaled based on the RQ/Non-RQ grouping (see instruction 4), and then totaled on the Last -line of the schedule. The "Subtotal - RQ" amount in column (g) must be reported as Requirements Sales For Resale on Page 401, line 23. The "Subtotal - Non-RQ" amount in column (g) must be reported as Non-Requirements Sales For Resale on Page 401,line 24.
  10. Footnote entries as required and provide explanations following all required data.
ACTUAL DEMAND (MW) REVENUE
Line No. $headings = filter (taxonomy().concept(ferc:ScheduleSalesForResaleAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "310 - Schedule - Sales for Resale (Account 447)") $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] Name of Public Company or Authority (Footnote Affiliation)
$row (a)
1 $row[2] ABC Company $row[5] 1,028 $row[6] 514,247 $row[7] 666,666 $row[8] 777,777 $row[9] $888 $row[10] $999 $row[11] $111 $row[12] $222
15 taxonomy().concept(ferc:MegawattHoursSoldRequirementsSales).label("http://ferc.gov/form/2020-01-01/roles/label/F1SalesForResale").text
Subtotal - RQ
max(list([covered @concept=ferc:MegawattHoursSoldRequirementsSales @period = $currentDuration])) 1,464 max(list([covered @concept=ferc:DemandChargesRevenueRequirementsSales @period = $currentDuration])) $1,464 max(list([covered @ferc:EnergyChargesRevenueRequirementsSales @period = $currentDuration])) $1,234,567 max(list([covered @ferc:OtherChargesRevenueRequirementsSales @period = $currentDuration])) $2,907,175 max(list([covered @ferc:RevenueFromSalesOfElectricityForResaleRequirementsSales @period = $currentDuration])) $2,911,545
16 taxonomy().concept(ferc:MegawattHoursSoldNonRequirementsSales).label("http://ferc.gov/form/2020-01-01/roles/label/F1SalesForResale").text
Subtotal - Non-RQ
max(list([covered @ferc:MegawattHoursSoldNonRequirementsSales @period = $currentDuration])) 1,987,444 max(list([covered @ferc:DemandChargesRevenueNonRequirementsSales @period = $currentDuration])) $1,459,742 max(list([covered @ferc:EnergyChargesRevenueNonRequirementsSales @period = $currentDuration])) $1,459,742 max(list([covered @ferc:OtherChargesRevenueNonRequirementsSales @period = $currentDuration])) $1,459,742 max(list([covered @ferc:RevenueFromSalesOfElectricityForResaleNonRequirementsSales @period = $currentDuration])) $1,459,742
17 Total max(list([covered @ferc:MegawattHoursSoldSalesForResale @period = $currentDuration])) 2,559,267 max(list([covered @ferc:DemandChargesRevenueSalesForResale @period = $currentDuration])) $1,459,742 max(list([covered @ferc:EnergyChargesRevenueSalesForResale @period = $currentDuration])) $1,459,742 max(list([covered @ferc:OtherChargesRevenueSalesForResale @period = $currentDuration])) $1,459,742 max(list([covered @ferc:SalesForResale @period = $currentDuration])) $1,459,742