taxonomy().concept(ferc:ScheduleSalesOfElectricityByRateSchedulesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1ScheduleTitle").text
SALES OF ELECTRICITY BY RATE SCHEDULES
|
taxonomy().concept(ferc:ScheduleSalesOfElectricityByRateSchedulesAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F1Instructions").text
- Report below for each rate schedule in effect during the year the MWH of electricity sold, revenue, average number of customer, average Kwh per customer, and average revenue per Kwh, excluding date for Sales for Resale which is reported on Pages 310-311.
- Provide a subheading and total for each prescribed operating revenue account in the sequence followed in "Electric Operating Revenues," Page 300-301. If the sales under any rate schedule are classified in more than one revenue account, List the rate schedule and sales data under each applicable revenue account subheading.
- Where the same customers are served under more than one rate schedule in the same revenue account classification (such as a general residential schedule and an off peak water heating schedule), the entries in column (d) for the special schedule should denote the duplication in number of reported customers.
- The average number of customers should be the number of bills rendered during the year divided by the number of billing periods during the year (12 if all billings are made monthly).
- For any rate schedule having a fuel adjustment clause state in a footnote the estimated additional revenue billed pursuant thereto.
- Report amount of unbilled revenue as of end of year for each applicable revenue account subheading.
|
Line No. |
$headings = filter (taxonomy().concept(ferc:ScheduleSalesOfElectricityByRateSchedulesAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "304 - Schedule - Sales of Electricity by Rate Schedules")
$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]
Number and Title of Rate Schedule
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(40)
list($i,none,none,none,none,none,none)
);
$data = if count(list({covered @ferc:IndustrialSalesAxis=*})) > 0
list({covered @ferc:IndustrialSalesAxis=* {list(
if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:DescriptionOfNumberAndTitleOfRateSchedule @unit @period=$currentDuration})
first(list({@ferc:DescriptionOfNumberAndTitleOfRateSchedule @unit @period=$currentDuration}))
else
none,
if exists({@ferc:MegawattHoursSoldLargeOrIndustrialBilled @unit @period=$currentDuration})
first(list({@ferc:MegawattHoursSoldLargeOrIndustrialBilled @unit @period=$currentDuration}))
else
none,
if exists({@ferc:LargeOrIndustrialSalesElectricOperatingRevenueBilled @unit @period=$currentDuration})
first(list({@ferc:LargeOrIndustrialSalesElectricOperatingRevenueBilled @unit @period=$currentDuration}))
else
none,
if exists({@ferc:AverageNumberOfCustomersPerMonthLargeOrIndustrialBilled @unit @period=$currentDuration})
first(list({@ferc:AverageNumberOfCustomersPerMonthLargeOrIndustrialBilled @unit @period=$currentDuration}))
else
none,
if exists({@ferc:KilowattHoursOfSalesPerCustomerLargeOrIndustrialSalesBilled @unit @period=$currentDuration})
first(list({@ferc:KilowattHoursOfSalesPerCustomerLargeOrIndustrialSalesBilled @unit @period=$currentDuration}))
else
none,
if exists({@ferc:RevenuePerKilowattHourSoldLargeOrIndustrialSalesBilled @unit @period=$currentDuration})
first(list({@ferc:RevenuePerKilowattHourSoldLargeOrIndustrialSalesBilled @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
1
|
$row[2]
RB
|
$row[3]
3,456
|
$row[4]
$55,036,001
|
$row[5]
12,476,888
|
$row[6]
3,281,566
|
$row[7]
$91
|
41 |
TOTAL Billed Large (or Ind.) Sales
|
first(list([covered
@concept=ferc:MegawattHoursSoldLargeOrIndustrialBilled @period = $currentDuration]))
765,989
|
first(list([covered
@concept=ferc:LargeOrIndustrialSalesElectricOperatingRevenueBilled @period = $currentDuration]))
$55,036,326
|
first(list([covered
@concept=ferc:AverageNumberOfCustomersPerMonthLargeOrIndustrialBilled @period = $currentDuration]))
3,281
|
first(list([covered
@concept=ferc:KilowattHoursOfSalesPerCustomerLargeOrIndustrialSalesBilled @period = $currentDuration]))
9,162,981
|
first(list([covered
@concept=ferc:RevenuePerKilowattHourSoldLargeOrIndustrialSalesBilled @period = $currentDuration]))
$967
|
42 |
TOTAL Unbilled Rev. Large (or Ind.) (See Instr. 6)
|
first(list([covered
@concept=ferc:MegawattHoursSoldLargeOrIndustrialUnbilled @period = $currentDuration]))
765,989
|
first(list([covered
@concept=ferc:LargeOrIndustrialSalesElectricOperatingRevenueUnbilled @period = $currentDuration]))
$55,036,326
|
|
|
first(list([covered
@concept=ferc:RevenuePerKilowattHourSoldLargeOrIndustrialSalesUnbilled @period = $currentDuration]))
$297
|
43 |
TOTAL Large (or Ind.)
|
first(list([covered
@concept=ferc:MegawattHoursSoldLargeOrIndustrial @period = $currentDuration]))
165,381
|
first(list([covered
@concept=ferc:LargeOrIndustrialSalesElectricOperatingRevenue @period = $currentDuration]))
$88,236,226
|
first(list([covered
@concept=ferc:AverageNumberOfCustomersPerMonthLargeOrIndustrial @period = $currentDuration]))
1,766
|
first(list([covered
@concept=ferc:KilowattHoursOfSalesPerCustomerLargeOrIndustrialSales @period = $currentDuration]))
10,245,988
|
first(list([covered
@concept=ferc:RevenuePerKilowattHourSoldLargeOrIndustrialSales @period = $currentDuration]))
$9,837
|