Skip to main content

Table

Introduction

The Table Node outputs values from connected Nodes to a spreadsheet format.

This Node is typically used for the following:

  • Outputting network values (e.g. line loading) from a PSS®E Static Node to include in a static study report.
  • Outputting calculated values (e.g. settling time) from a Plot Node.
info

Currently, the Table Node only supports comma-separated values (csv) output files.

User inputs

Define table

Output file name

Defines the output directory and file name of the table, including the .csv file extension.

Example:

s5255_q_settling_time_results.csv
danger

Each Table Node represents a single output file. Output file names within a simulation must be unique.

As a result, Loop Variables and Internode Variables are not supported in the Output file name field.

Data

Defines the data to be exported into the output file.

Each line represents a new column in the output file and is entered as a=b format, where a is the column title and b is the corresponding value for this column. If the Table Node is located inside a loop, each loop represents a new row in the output file.

Example: Create an output file with the following table.

ACTIVE_POWERVOLTAGE_AT_BUS1VOLTAGE_AT_BUS2LOAD_TRANSFORMER1
P=501.031.0464%
P=1001.051.0682%
............
ACTIVE_POWER = $l_pcmd
VOLTAGE_AT_SUB1 = {{i_volt_at_sub1}}
VOLTAGE_AT_SUB2 = {{i_volt_at_sub2}}
TRANSFORMER_LOAD = {{i_txloading}}
note

The example above assumes that $l_pcmd is a Loop Variable and {{i_volt_at_sub1}}, {{i_volt_at_sub2}} and {{i_txloading}} are Internode Variables from a connected Node.

Advanced

Advanced Parameters

Advanced Parameters allow users to configure test details which are not commonly used. Advanced Parameters are often specific to each Node type.

Each line represents a new Advanced Parameter and is entered as a=b format, where a is the name of the Parameter and b is the corresponding value. All Advanced Parameters are set to their default values if they are not included in the Advanced Parameters field.

Example: Set Advanced Parameter, sample.parameter to a value of 5.

sample.parameter=5

API Reference

This section details the Commands and Advanced Parameters specific to the Node.

Advanced Parameters

col.sort.index

  • Description: Specifies how the table should be sorted. If equal to -1 (default), the Node sorts automatically based on the order defined in the connected Start loop Node(s). If set to a value n, sorts in ascending order by the nth column in the table (zero indexed, e.g. if n=2, this means sort by the 3rd column from the left).
  • Type: int
  • Units: N/A
  • Default: -1
  • Range: -1 or 0 - N (where N = number of columns in table)
col.sort.index=value

col.sort.ascending

  • Description: If Yes, sort by the column defined in col.sort.index from smallest value to largest value. If No, sort by the column defined in col.sort.index from largest value to smallest value.
  • Type: bool
  • Units: N/A
  • Default: Yes
  • Range: Yes/No
col.sort.ascending=value