<< Click to Display Table of Contents >> Navigation: User interface > Tools > Import |
With this function object data can be adjusted to values from an Excel file, by importing the Excel file in Vision.
Importing takes place from an Excel file, whose worksheets have a fixed name. Below the types of objects which can be imported. The name of the worksheet is the same or the single variant:
•nodes
•cables
•connections
•reactance coils
•transformers
•special transformers
•plural name of an element sort (all element sorts are available)
•circuit breakers
•load switches
•measure fields
•fuses
•profiles
•frames
•variants
•scenarios
Each worksheet consists of a header row and data rows. The first row is always the header row, which defines the search parameters and the parameters to be changed. The data rows follow from the second row. Empty rows are allowed but the import function stops after five empty rows.
Search items have been defined for all objects, so the objects can be identified. These search items are preceded by a $-sign. One, two, three or four identifying values must match in order to identify the object to be changed. If an object is not found or if an object is found more than once, a warning message is generated.
In addition to the search items, change items are defined for all changeable parameters.
Specifics for existing objects can be imported.
A specific attribute can be removed by including: <characteristic>=.
Nodes
Header |
Parameter |
Description |
Search-items |
|
|
$Name |
Name |
Name of the node |
$Short name |
Short name |
Short name of the node |
$ID |
ID |
Identification |
$GUID |
GUID |
GUID of the node |
Change-items |
|
|
Name |
Name |
Name |
Short Name |
Short name |
Short name |
ID |
ID |
Identification |
Simultaneousness |
Simultaneousness |
Simultaneousness factor |
Railtype |
Rail type |
Name of the rail type |
GX |
X |
Geographical X-coordinate |
GY |
Y |
Geographical Y-coordinate |
Failure frequency |
Failure frequency |
Failure frequency |
Specific |
Specific |
Characteristic and value of the specific formatted as: <characteristic>=<value> |
Specific+ |
Specific |
Add a specification |
^<characteristic> |
Specific |
Value of the specific to be modified |
^<characteristic>+ |
Specific |
Value of the specific to be added |
Revisiondate |
Revisiondate |
Revision date |
Note |
Note |
Note |
Function |
Function |
Function |
Icon.Text |
Icon.Text |
Text of the icon |
Icon.Textcolor |
Icon.Textcolor |
Color of icon text (BGR) |
Icon.Color |
Icon.Color |
Icon background color (BGR) |
Icon.Shape |
Icon.Shape |
Icon shape (0=circle, 1=ellipse, 2=square, 3=rectangle) |
Icon.Size |
Icon.Size |
Size of the icon |
Cables
Bij het importeren van kabeldelen worden de reeds bestaande kabeldelen eerst verwijderd.
Header |
Parameter |
Omschrijving |
Zoek-items |
|
|
$Naam |
Naam |
Naam van de kabel |
$ID |
ID |
ID van de kabel |
$GUID |
GUID |
GUID van de kabel |
$Knooppunt1.Naam |
Knooppunt1.Naam |
Naam van het 'van'-knooppunt |
$Knooppunt1.ID |
Knooppunt1.ID |
ID van het 'van'-knooppunt |
$Knooppunt2.Naam |
Knooppunt2.Naam |
Naam van het 'naar'-knooppunt |
$Knooppunt2.ID |
Knooppunt2.ID |
ID van het 'naar'-knooppunt |
$KnooppuntX.Naam |
KnooppuntX.Naam |
Naam van een van de aangesloten knooppunten |
$KnooppuntX.ID |
KnooppuntX.ID |
ID van een van de aangesloten knooppunten |
$KnooppuntY.Naam |
KnooppuntY.Naam |
Naam van een van de aangesloten knooppunten |
$KnooppuntY.ID |
KnooppuntY.ID |
ID van een van de aangesloten knooppunten |
Verander-items |
|
|
Naam |
Naam |
Naam |
ID |
ID |
ID |
Schakelstand1 |
Schakelaarstand1 |
Schakelaarstand nabij het van-knoopunt; 1 (in) of 0 (uit) |
Schakelstand2 |
Schakelaarstand2 |
Schakelaarstand nabij het naar-knoopunt; 1 (in) of 0 (uit) |
Type |
Type |
Type van het kabeldeel (uitsluitend samen met lengte) |
Lengte |
Lengte |
Lengte van het kabeldeel (uitsluitend samen met type) |
Faalfrequentie |
Faalfrequentie |
|
Reparatieduur |
Reparatieduur |
|
Onderhoudsfrequentie |
Onderhoudsfrequentie |
|
Onderhoudsduur |
Onderhoudsduur |
|
Onderhoudsafbreekduur |
Onderhoudsafbreekduur |
|
Moffaalfrequentie |
Moffaalfrequentie |
Standaardmoffaalfrequentie |
Mof.GX |
X |
Geografische X-coordinaat van een mof |
Mof.GY |
Y |
Geografische Y-coordinaat van een mof |
Mof.Type |
Type |
Type van een mof |
Mof.Jaar |
Jaar |
Jaar van aanleg van een mof |
GX |
GX |
Geografische X-coordinaat van een hoekpunt in een kabel |
GY |
GY |
Geografische Y-coordinaat van een hoekpunt in een kabel |
Bijzonderheid |
Bijzonderheid |
Kenmerk en waarde van de bijzonderheid in het formaat: <kenmerk>=<waarde> |
Bijzonderheid+ |
Bijzonderheid |
Toevoegen van een bijzonderheid |
Revisie |
Revisie |
Revisiedatum |
Notitie |
Notitie |
|
Lines
Header |
Parameter |
Description |
Search-items |
|
|
$Name |
Name |
Name of the connection |
$Node1.Name |
Node1.Name |
Name of the 'from'-node |
$Node1.ID |
Node1.ID |
ID of the 'to'-node |
$Node2.Name |
Node2.Name |
Name of the 'to'-node |
$Node2.ID |
Node2.ID |
ID of the 'to'-node |
$NodeX.Name |
NodeX.Name |
Name of one of the connected nodes |
$NodeX.ID |
NodeX.ID |
ID of one of the connected nodes |
$NodeY.Name |
NodeY.Name |
Name of one of the connected nodes |
$NodeY.ID |
NodeY.ID |
ID of one of the connected nodes |
Change-items |
|
|
Name |
Name |
Name |
Revisiondate |
Revision |
Revision date |
Joint.GX |
|
|
Joint.GY |
|
|
Joint.Type |
|
|
GX |
GX |
Geographical X-coordinate of a point of the connection |
GY |
GY |
Geographical Y-coordinate of a point of the connection |
Specific |
Specific |
Characteristic and value of the specific formatted as: <characteristic>=<value> |
Specific+ |
Specific |
Add a specification |
Change-items, in case the connection consist of a single part |
||
Description |
Description |
Description |
R |
R |
Total resistance |
X |
X |
Total reactance |
C |
C |
Total capacity |
R0 |
R0 |
Total zero-sequence resistance |
X0 |
X0 |
Total zero-sequence reactance |
C0 |
C0 |
Total zero-sequence capacity |
Inom1 |
Inom1 |
Nominal current |
Inom2 |
Inom2 |
Nominal current |
Inom3 |
Inom3 |
Nominal current |
Ik (1s) |
Ik,1s |
Maximum short circuit current during 1sec |
Length |
Length |
Length |
Reactance coils and (special) transformers
Header |
Parameter |
Description |
Search-items |
|
|
$Name |
Name |
Name |
$Node1.Name |
Node1.Name |
Name of the 'from'-node |
$Node1.ID |
Node1.ID |
ID of the 'from'-node |
$Node2.Name |
Node2.Name |
Name of the 'to'-node |
$Node2.ID |
Node2.ID |
ID of the 'to'-node |
$NodeX.Name |
NodeX.Name |
Name of one of the connected nodes |
$NodeX.ID |
NodeX.ID |
ID of one of the connected nodes |
$NodeY.Name |
NodeY.Name |
Name of one of the connected nodes |
$NodeY.ID |
NodeY.ID |
ID of one of the connected nodes |
Change-items |
|
|
Name |
Name |
Name |
Type |
Type |
Type name |
Snom |
Snom |
Snom (only transformers) |
Usoort |
Sort |
Sort voltage control (0=compounding; 1=load dependent) |
Uset |
Uset |
Uset |
Uband |
Uband |
Uband |
Rc |
Rc |
Rc |
Xc |
Xc |
Xc |
Terugc |
Ook bij teruglevering |
|
P<< |
P<< |
|
U<< |
U<< |
|
P< |
P< |
|
U< |
U< |
|
P> |
P> |
|
U> |
U> |
|
P>> |
P>> |
|
U>> |
U>> |
|
Revisiondate |
Revision date |
Revision date |
Specific |
Specific |
Characteristic and value of the specific formatted as: <characteristic>=<value> |
Specific+ |
Specific |
Add a specification |
Elements (general)
Header |
Parameter |
Description |
Search-items |
|
|
$Name |
Name |
Name |
$ID |
ID |
ID |
$GUID |
GUID |
GUID |
$Node.Name |
Nodename |
Name of the node |
$Node.ID |
NodeID |
Identification of the node |
$Node.GUID |
NodeGUID |
GUID of the node |
Search-or-new-items |
|
|
$Name+ |
Name |
Name of the element; the element is added if it does not exist |
Change-items |
|
|
Name |
Name |
Name |
Name+ |
Name |
Name; the element will be added |
Switchstate |
Switchstate |
1 (on) or 0 (off) |
Profile |
Profile |
Name of the profile |
Specific |
Specific |
Characteristic and value of the specific formatted as: <characteristic>=<value> |
Specific+ |
Specific |
Add a specification |
^<Characteristic> |
Specific |
Value of the specific to be modified |
^<Characteristic>+ |
Specific |
Value of the specific to be added |
Revisiondate |
Revision date |
Revision date |
Sources (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
Uref |
Uref |
Reference voltage |
Sk"nom |
Sk"nom |
nominaal kortsluitvermogen (MVA) |
Sk"min |
Sk"min |
minimaal kortsluitvermogen (MVA) |
Sk"max |
Sk"max |
maximaal kortsluitvermogen (MVA) |
Ik"nom |
Ik"nom |
nominal short circuit current (kA) |
Ik"min |
Ik"min |
minimal short circuit current (kA) |
Ik"max |
Ik"max |
maximum short circuit current (kA) |
Angle |
Angle |
Angle of the reference voltage |
R/X |
R/X |
Relationship between R and X |
Z0/Z1 |
Z0/Z1 |
Relationship between the homopolar and normal impedance |
Loads en transformer loads (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
P |
P |
Active power (of the load) |
Q |
Q |
Reactive power (of the load) |
S |
S |
Apparent power (of the load) |
I |
I |
Current (of the load) |
Cos |
Cos phi |
Cos phi (of the load); must be combined with S or I |
Profile |
Profile |
Name of the profile (of the load) |
Pgen |
Generation.P |
Real power of the generation; Q becomes 0 |
Qgen |
Generation.Q |
|
Generationprofile |
Generation.Profile |
Name of the profile of the generation |
Ppv |
PV.Pnom |
Power of the PV |
PVprofile |
PV.Profile |
Name of the PV profile |
Type |
Type |
Type name of the transformer |
Tapsetting |
Tapsetting |
Tap setting of the transformer |
#Bigcustomers |
Number of big customers |
Number of big customers |
#Generouscustomers |
Number of generous customers |
Number of generous customers |
#Smallverbruikers |
Number of small customers |
Number of small customers |
The ratings are in MW, Mvar and MVA. The current is in A. The values for the transformer loads are related to the primary side of the transformers.
In some cases, more than one load object is changed per row. When specifying only the node name, all loads connected to that node are changed. When specifying only the Name, all loads in the network with that name are changed. If not exactly one load object is changed per row, a warning message is shown.
When setting a name or a note, the value can be cleared by means of a dash in the cell.
Synchronous generators (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
Type |
Type |
Type name |
Ppu |
Nominal power |
Nominal active power (power factor * Snom) |
Pref |
Reference power |
Actual active power |
Snom |
Nominal power |
Nominal power of the generator |
Synchronous motors (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
Type |
Type |
Type name |
Ppu |
Nominal power |
Nominal active power (power factor * Snom) |
Pref |
Reference power |
Actual Active power |
Snom |
Nominal power |
Nominal power of the motor |
Induction generators (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
Type |
Type |
Type name |
Ppu |
Nominal power |
Nominal active power (power factor * Snom) |
Pref |
Reference power |
Actual Active power |
Pnom |
Nominal power |
Nominal active power of the generator |
Induction motors (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
Type |
Type |
Type name |
Ppu |
Nominal power |
Nominal active power (power factor * Snom) |
Pref |
Reference power |
Actual active power |
Pnom |
Nominal power |
Nominal active power of the motor |
PV's (complementary to elements)
Header |
Parameter |
Description |
Change-items |
|
|
Pnom+ |
Pnom |
Power of the next panel |
Pnom1 |
Pnom |
Power of the first panel |
Pnom2 |
Pnom |
Power of the second panel |
Pnom3 |
Pnom |
Power of the third panel |
Circuit breakers with protection
Header |
Parameter |
Description |
---|---|---|
Search-items |
|
|
$Name |
Name |
Name of the circuit breaker |
$ID |
|
|
$In.Name |
In name |
Name of the branch or element to which the circuit breaker is connected |
$Node.Name |
Nodename |
Name of the connected node |
$Node.ID |
NodeID |
ID of the connected node |
Search-or-new-items |
|
|
$Name+ |
Name |
Name of the circuit breaker; the circuit breaker is added if it does not exist |
Change-items |
|
|
Name |
Name |
Name |
Name+ |
Name |
Name; the circuit breaker will be added |
Specific |
Specific |
Characteristic and value of the specific formatted as: <characteristic>=<value> |
Specific+ |
Specific |
Add a specification |
Remote control |
Remote control |
|
Remote indication |
Remote indication |
|
Note |
Note |
|
Type |
Type |
Type of the circuit breaker |
Shorttype |
Short |
Short type name |
Inom |
Inom |
Nominal current circuit breaker type |
Unom |
Unom |
Nominal voltage circuit breaker type |
Ik_break |
|
Tripping current circuit breaker type |
Ik_thermal |
|
Maximum thermal short circuit current |
t_thermal |
|
Maximum thermal short circuit current duration |
Switchtime |
|
Breaker opening time |
Ip1.Present |
First current protection |
Present |
Ip1.Active |
|
Active |
Ip1.Direction |
|
Direction sensitivity (-1, 0, 1) |
Ip1.RCA |
|
RCA |
Ip1.Type |
|
Type |
Ip1.Short |
|
Short type name |
Ip1.Inom |
|
Nominal current |
Ip1.Setting |
|
Characteristic 1: fixed time 11-15: inverse (normal/very/extremely/long time/RI-inverse) 31-32: specific |
Ip1.I> |
|
I > |
Ip1.t> |
|
t > |
Ip1.I>> |
|
I >> |
Ip1.t>> |
|
t >> |
Ip1.I>>> |
|
I >>> |
Ip1.t>>> |
|
t >>> |
Ip1.m |
|
m-factor |
Ip2.Present |
Second current protection |
Present |
Ip2.Active |
|
Active |
Ip2.Direction |
|
Direction sensitivity (-1, 0, 1) |
Ip2.RCA |
|
RCA |
Ip2.Type |
|
Type |
Ip2.Short |
|
Short type name |
Ip2.Inom |
|
Nominal current |
Ip2.Setting |
|
Characteristic 1: fixed time 11-15: inverse (normal/very/extremely/long time/RI-inverse) 31-32: specific |
Ip2.I> |
|
I > |
Ip2.t> |
|
t > |
Ip2.I>> |
|
I >> |
Ip2.t>> |
|
t >> |
Ip2.I>>> |
|
I >>> |
Ip2.t>>> |
|
t >>> |
Ip2.m |
|
m-factor |
Ep1.Present |
First earth fault protection |
Present |
Ep1.Active |
|
Active |
Ep1.Direction |
|
Direction sensitivity (-1, 0, 1) |
Ep1.RCA |
|
RCA |
Ep1.Type |
|
Type |
Ep1.Setting |
|
Characteristic |
Ep1.I> |
|
I > |
Ep1.t> |
|
t > |
Ep1.I>> |
|
I >> |
Ep1.t>> |
|
t >> |
Ep1.I>>> |
|
I >>> |
Ep1.t>>> |
|
t >>> |
Ep2.Present |
Second earth fault protection |
Present |
Ep2.Active |
|
Active |
Ep2.Direction |
|
Direction sensitivity (-1, 0, 1) |
Ep2.RCA |
|
RCA |
Ep2.Type |
|
Type |
Ep2.Setting |
|
Characteristic |
Ep2.I> |
|
I > |
Ep2.t> |
|
t > |
Ep2.I>> |
|
I >> |
Ep2.t>> |
|
t >> |
Ep2.I>>> |
|
I >>> |
Ep2.t>>> |
|
t >>> |
Up.Present |
Voltage protection |
Present |
Up.Active |
|
Active |
Up.Type |
|
Type |
Up.U< |
|
U < |
Up.t< |
|
t < |
Up.U<< |
|
U << |
Up.t<< |
|
t << |
Up.U> |
|
U > |
Up.t> |
|
t > |
Up.U>> |
|
U >> |
Up.t>> |
|
t >> |
Difp.Present |
Differential protection |
Present |
Difp.Active |
|
Active |
Difp.Type |
|
Type |
Difp.dI> |
|
dI > |
Difp.t> |
|
t > |
Difp.dI>> |
|
dI >> |
Difp.t>> |
|
t >> |
Difp.k1 |
|
k1 |
Difp.k2 |
|
k2 |
Dp.Present |
Distance protection |
Present |
Dp.Active |
|
Active |
Dp.Type |
|
Type |
Dp.Ie> |
|
Ie > |
Dp.I> |
|
I > |
Dp.U< |
|
U < |
Dp.Z< |
|
Z < |
Dp.Kn |
|
Kn-factor |
Dp.Knangle |
|
Kn-factor-angle |
Dp.T0 |
|
Undirected end time |
Dp.T4 |
|
Directed end time |
Dp.T1 |
|
t zone 1 |
Dp.R1 |
|
R zone 1, in a polygon characteristic |
Dp.X1 |
|
X zone 1, in a polygon characteristic |
Dp.Z1 |
|
Z zone 1, in a circle characteristic |
Dp.R1E |
|
R during a earth fault zone 1, in a polygon characteristic |
Dp.X1E |
|
X during a earth fault zone 1, in a polygon characteristic |
Dp.Z1E |
|
Z during a earth fault zone 1, in a circle characteristic |
Dp.T2 |
|
t zone 2 |
Dp.R2 |
|
R zone 2, in a polygon characteristic |
Dp.X2 |
|
X zone 2, in a polygon characteristic |
Dp.Z2 |
|
Z zone 2, in a circle characteristic |
Dp.R2E |
|
R during a earth fault zone 2, in a polygon characteristic |
Dp.X2E |
|
X during a earth fault zone 2, in a polygon characteristic |
Dp.Z2E |
|
Z during a earth fault zone 2, in a circle characteristic |
Dp.T3 |
|
t zone 3 |
Dp.R3 |
|
R zone 3, in a polygon characteristic |
Dp.X3 |
|
X zone 3, in a polygon characteristic |
Dp.Z3 |
|
Z zone 3, in a circle characteristic |
Dp.R3E |
|
R during a earth fault zone 3, in a polygon characteristic |
Dp.X3E |
|
X during a earth fault zone 3, in a polygon characteristic |
Dp.Z3E |
|
Z during a earth fault zone 3, in a circle characteristic |
Dp.T-1 |
|
t zone backwards |
Dp.R-1 |
|
R zone backwards, in a polygon characteristic |
Dp.X-1 |
|
X zone backwards, in a polygon characteristic |
Dp.Z-1 |
|
Z zone backwards, in a circle characteristic |
Dp.R-1E |
|
R during a earth fault zone backwards, in a polygon characteristic |
Dp.X-1E |
|
X during a earth fault zone backwards, in a polygon characteristic |
Dp.Z-1E |
|
Z during a earth fault zone backwards, in a circle characteristic |
Importing the distance protection zones via R and X yields a polygon in the form of a right triangle, where R and X form the right angle and the slanted side with an angle of -45 degree passes through the origin of the graph.
Importing the distance protection zones via Z produces a circle with the specified radius.
Load switches
Header |
Parameter |
Description |
---|---|---|
Search-items |
|
|
$Name |
Name |
Name van lastschakelaar |
$ID |
ID |
|
$In.Name |
In name |
Name van tak of element waar lastschakelaar in zit |
$Node.Name |
Nodename |
Name van aangesloten node |
$Node.ID |
NodeID |
ID van aangesloten node |
Change-items |
|
|
Name |
Name |
Name |
Afstandbediening |
Afstandbediening |
|
Notitie |
Notitie |
|
Type |
Type |
Type lastschakelaar |
Korttype |
Kort |
Korte typename |
Inom |
Inom |
Nominale current |
Unom |
Unom |
Nominale spanning |
Ik_maak |
Ik,maak |
Maakcurrent |
Ik_dynamisch |
Ik,dynamisch |
Maximale dynamische short circuitcurrent |
Ik_thermisch |
Ik,thermisch |
Maximale thermische short circuitcurrent |
t_thermisch |
t,thernisch |
Bijbehorende tijd |
Measure fields
Header |
Parameter |
Description |
---|---|---|
Search-items |
|
|
$Name |
Name |
Name of the measurement unit |
$ID |
|
|
$In.Name |
In name |
Name of the branch or element to which the measurement unit is connected |
$Node.Name |
Nodename |
Name of the connected node |
$Node.ID |
NodeID |
ID of the connected node |
$VS.Name |
Circuit breaker name |
Name van de circuit breaker in the same field |
$VS.ID |
Circuit breaker ID |
|
Change-items |
|
|
Name |
Name |
Name |
Specific |
Specific |
Characteristic and value of the specific formatted as: <characteristic>=<value> |
Specific+ |
Specific |
Add a specification |
It1.Function |
|
|
It1.Type |
|
|
It1.Class |
|
|
It1.Transformerratio |
|
|
It1.Power |
|
|
It1.Inom |
|
|
It1.Ik_dynamic |
|
|
It1.Ik_thermal |
|
|
It1.t_thermal |
|
|
It2.Function |
|
|
It2.Type |
|
|
It2.Class |
|
|
It2.Transformerratio |
|
|
It2.Power |
|
|
It2.Inom |
|
|
It2.Ik_dynamic |
|
|
It2.Ik_thermal |
|
|
It2.t_thermal |
|
|
Ut.Function |
|
|
Ut.Type |
|
|
Ut.Class |
|
|
Ut.Transformerratio |
|
|
Ut.Power |
|
|
Mb.Naam |
Bestandsnaam |
Bestandsnaam van een metingenbestand |
Mb.Kolom |
Kolom(men) |
Bijbehorende kolommen |
...2010... |
Measurement from 2010 |
Measurement value |
...2011... |
Measurement from 2011 |
Measurement value |
...2012... |
Measurement from 2012 |
Measurement value |
...2013... |
Measurement from 2013 |
Measurement value |
...2014... |
Measurement from 2014 |
Measurement value |
...2015... |
Measurement from 2015 |
Measurement value |
...2016... |
Measurement from 2016 |
Measurement value |
...2017... |
Measurement from 2017 |
Measurement value |
...2018... |
Measurement from 2018 |
Measurement value |
...2019... |
Measurement from 2019 |
Measurement value |
...2020... |
Measurement from 2020 |
Measurement value |
...2021... |
Measurement from 2021 |
Measurement value |
...2022... |
Measurement from 2022 |
Measurement value |
...2023... |
Measurement from 2023 |
Measurement value |
...2024... |
Measurement from 2024 |
Measurement value |
...2025... |
Measurement from 2025 |
Measurement value |
...2021...+ |
Measurement from 2021 |
Measurement value (is always added) |
...2022...+ |
Measurement from 2022 |
Measurement value (is always added) |
...2023...+ |
Measurement from 2023 |
Measurement value (is always added) |
...2024...+ |
Measurement from 2024 |
Measurement value (is always added) |
...2025...+ |
Measurement from 2025 |
Measurement value (is always added) |
Fuses
Header |
Parameter |
Omschrijving |
---|---|---|
Zoek-items |
|
|
$Name |
Name |
Name of fuse |
$ID |
ID |
ID of the fuse (particularity with characteristic "ID") |
$In.Name |
In name |
Name of branch or element that contains the fuse |
$Node.Name |
Node name |
Name of connected node |
$Node.ID |
Node ID |
ID of connected node |
$Field |
Field |
Fuse field |
Verander-items |
|
|
Name |
Name |
Name |
Note |
Note |
|
Type |
Type |
Type fuse |
Shorttype |
Short type |
Short type name |
Profiles
Profiles can be added trough the use of the types files.
The whole types file can be used for the importing of the profiles. The other worksheets in the types file will not be imported as the names of these worksheets will not match.
Frames
Header |
Parameter |
Description |
Search-items |
|
|
$Name |
Name |
Name |
Change-items |
|
|
Name |
Name |
Name |
GX |
X |
Geographical X-coordinate |
GY |
Y |
Geographical Y-coordinate |
Scenario's
Header |
Parameter |
Description |
---|---|---|
Search-items |
|
|
$Name |
Scenarioname |
Name of scenario |
Search-or-new-items |
|
|
$Name+ |
Scenarioname |
Name of scenario; the scenario is added if it does not exist |
Change-items or scenario-items to be added |
|
|
Objecttype |
Objecttypename |
Name of the objectype (node, branch, etc.) |
Objectname |
Objectname |
Name of the object |
Date |
Date |
Date of entry |
Parameter |
Parameter |
Node: 11: Simultaneity factor Branch: 1: from-switch state Branch: 2: to-switch state Transformer: 11: tapsetting Transformator: 12: fasedraaiing Element: 1: switch state Element: 11: absolute active power Element: 12: absolute reactive power Windturbine: 13: absolute wind speed PV: 13: absolute scaling Element: 14: factor of the nominal power Windturbine: 14: factor of nominal wind speed Transformerload: 15: tap Element: 16: factor of the current power, wind speed or scaling Load and transformer load: 17: absolute apparent power Transformer load: 18: factor of current apparent power of the generation Transformer load: 19: absolute apparent power of the generation Wind turbine: 20: cosine phi Synchronous generator: 21: control type Synchronous generator: 22: isochronous control |
Value |
Value |
Switch state: 1 (on) or 0 (off) Otherwise: the real value |
Remark |
Remark |
|
Or
Header |
Parameter |
Description |
---|---|---|
Change-items or scenario-items to be added |
|
|
Objecttype |
Objecttypename |
Name of the objectype (node, branch, etc.) |
Objectname |
Objectname |
Name of the object |
Date |
Date |
Date of entry |
Parameter |
Parameter |
See above |
^<scenarioname> |
Value |
Switch state: 1 (on) or 0 (off) Otherwise: the real value |
Example
Example of records
Importing the examples below changes some parameters of the components in the demo.vnf file.
Modification of geographical coordinates and addition of a specific for node "Station 4":
$Name |
GX |
GY |
Specific |
Station 4 |
53406 |
408235 |
type=Closed installation |
Modification of cable type and length of cable "Stat4 - Stat3" and addition of a specific:
$Name |
Type |
Length |
Specific |
Stat4 - Stat3 |
3*150 CU GPLK 8/10 |
7000 |
Revision=Cable rerouted |
Change of load on nodes "Station 1" and "Station3, rail A":
$Name |
$Node.Name |
P |
cos |
Last |
Station 1 |
2.5 |
0.85 |
Last |
Station 3, rail A |
3.5 |
0.9 |
Change all transformer loads on "Station 4":
$Node.Name |
I |
cos |
Station 4 |
18 |
0.88 |
Variants
Header |
Parameter |
Description |
---|---|---|
Search-items |
|
|
$Name |
Variantname |
Name of variant |
Search-or-new-items |
|
|
$Name+ |
Variantname |
Name of variant; the variant is added if it does not exist |
Change-items or scenario-items to be added |
|
|
Objecttype |
Objecttypename |
Name of the objectype (node, branch, etc.) |
Objectname |
Objectname |
Name of the object |
Date |
Date |
Date of entry |
Present |
Presence |
Presence: 'true' or 'false' |
Remark |
Remark |
|
Variant object |
Variant object of the object |
Whether the object is a variant object: "true" or "false |