Remote Network Device Models Spreadsheet

<< Click to Display Table of Contents >>

 

Remote Network Device Models Spreadsheet

For each model of device on a distribution network, that is, Switch, Switch Breaker, and Recloser instantiated in a Feeder, users must define a spreadsheet with a list of points and specific configuration for the Self-Healing Module. Notice that most information was already defined on the INFOS spreadsheet and it is only replicated on this spreadsheet by using Excel's PROCV function.

This feature allows more security and productivity during system's configuration and maintenance, because once the model is commissioned, it can be replicated to other devices with the same type, with no need of a new commissioning. The name of the spreadsheet, and therefore the name of the CSV file, of each model must be equal to the name defined on the Remote Model column of the Device_List spreadsheet.

This spreadsheet contains the following columns:

Tag: Abbreviation of a communication point. It must be the same abbreviation declared on the INFOS spreadsheet

DNP3 Address: Address of a DNP3 point

Conversion: Indicates the type of Conversion used on the Measurement or Command. It must be the same name of an existing Conversion on the type of Measurement defined in the Power Configuration object. Valid only for Discrete Measurements and Commands

EnableScaling: This column is used to indicate whether an analog point must apply a scale to the value read from a field device. It must be filled with the text "false" if there is no need for a scale and "true" when a scale is needed

DeviceHigh: If the EnableScaling column is equal to true, this column must be filled with the highest value the point can reach on the field device

DeviceLow: If the EnableScaling column is equal to true, this column informs the lowest value the point can reach on the field device

EUHigh: If the EnableScaling column is equal to true, this column must be filled with the value the Measurement assumes when the value from the field is equal to to the value informed on the DeviceHigh column

EULow: If the EnableScaling column is equal to true, this column must be filled with the value the Measurement assumes when the value from the field is equal to the value informed on the DeviceLow column

Unit Prefix: Informs a prefix that a Measurement must assume. Points other than analog must have this column filled with the value 0 (zero). Possible values are 0: No prefix, 3: Kilo, or 6: Mega

Was this page useful?