if (taxonomy().concept(ferc:SchedulePlanningAreaHourlyDemandAndForecastSummerAndWinterPeakDemandAndAnnualNetEnergyForLoadBAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F714PlanningAreaHourlyDemandandForecastSummerandWinterPeakDemandandAnnualNetEnergyforLoad").text) != none taxonomy().concept(ferc:SchedulePlanningAreaHourlyDemandAndForecastSummerAndWinterPeakDemandAndAnnualNetEnergyForLoadBAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F714PlanningAreaHourlyDemandandForecastSummerandWinterPeakDemandandAnnualNetEnergyforLoad").text else "Part III - Schedule 2. Planning Area Hourly Demand and Forecast Summer and Winter Peak Demand and Annual Net Energy for Load"
Part III - Schedule 2. Planning Area Hourly Demand and Forecast Summer and Winter Peak Demand and Annual Net Energy for Load
|
taxonomy().concept(ferc:SchedulePlanningAreaHourlyDemandAndForecastSummerAndWinterPeakDemandAndAnnualNetEnergyForLoadBAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F714Instructions").text
Provide the planning area's forecast summer and winter peak demand, in megawatts, and annual net energy for load, in megawatthours, for the next ten years.
|
Line No. (a) |
$headings = filter (taxonomy().concept(ferc:SchedulePlanningAreaHourlyDemandAndForecastSummerAndWinterPeakDemandAndAnnualNetEnergyForLoadBAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "03.2 - Schedule - Planning Area Hourly Demand and Forecast Summer and Winter Peak Demand and Annual Net Energy for Load, Table")
$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
$row
(a)
|
// adding a comment
$data2 = list(for $i in range(10)
list($i,none,none,none, none)
);
$data = if count(list({covered @ferc:PlanningAreaHourlyDemandAndForecastSummerAndWinterPeakDemandAndAnnualNetEnergyForLoadAxis=*})) > 0
list({covered @ferc:PlanningAreaHourlyDemandAndForecastSummerAndWinterPeakDemandAndAnnualNetEnergyForLoadAxis=* {list(
if exists({@ferc:OrderNumber @unit=* @period=$currentDuration})
first(list({@ferc:OrderNumber @unit=* @period=$currentDuration}))
else
0,
if exists({@ferc:PlanningAreaHourlyDemandAndForecastYear @unit @period=$currentDuration})
first(list({@ferc:PlanningAreaHourlyDemandAndForecastYear @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PlanningAreaHourlyDemandAndForecastSummerForecast @unit @period=$currentDuration})
first(list({@ferc:PlanningAreaHourlyDemandAndForecastSummerForecast @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PlanningAreaHourlyDemandAndForecastWinterForecast @unit @period=$currentDuration})
first(list({@ferc:PlanningAreaHourlyDemandAndForecastWinterForecast @unit @period=$currentDuration}))
else
none,
if exists({@ferc:PlanningAreaHourlyDemandAndForecastForecastOfAnnualNetEnergyForLoad @unit @period=$currentDuration})
first(list({@ferc:PlanningAreaHourlyDemandAndForecastForecastOfAnnualNetEnergyForLoad @unit @period=$currentDuration}))
else
none
)}})
else $data2;
$uniqueData = list(for $x in $data
if $x == list(0,none,none,none,none)
skip
else
$x
);
for $row in $uniqueData.sort
1
|
$row[2]
2018
|
$row[3]
M
|
$row[4]
NY
|
$row[5]
NY
|