Home

PSS SINCAL Database Interface and Automation

Contents

1. O 2 3 External 8 er Charts Tabular View Meta Model Applications A Graphics Editor based on Quinn Curtis based on Stingray with Screen Forms biecheee stal _ pp E with extensions extensions ry _ using COM 5 2 5 5 Tool Library Network Planning Tools UI Controls Database API Meta Model Manager lt Files e Servers COM Type DB Network Model Electro Flow Standard Variant Manager UNDO Manager Message Manager Chart Manager Types Network Database Simulation External Applications using COM Automation Interfaces COM Electricity Calculation Methods Flow Calculation Methods Import amp Export Function NETOMAC amp NEVA Interfaces ZUBER Interfaces Electricity Network Model Flow Network Model Import amp Export Tools Database API Meta Model Manager As can be seen in the illustration above there are two important components e Graphic User Interface This is the real PSS SINCAL user interface This interface is used to process networks modify data evaluate the results etc e Simulation This component contains all the PSS SINCAL calculation methods The calculation component can also be used stand alone without the user interface Between these the Servers COM component for internal data exchange is available The entire database can be accessed with this component
2. PSSE_SEQ_FILENAME String Complete path and file name of the sequence file PSSE_ MODE Integer Import mode 0 standard mode 1 enhanced import BASE_FREQUENCY Double Basic frequency LENGTH_FACTOR Double Scaling factor for lengths ZERO_IMPEDANCE Integer Import lines without impedance 0 no 1 yes ZERO_IMPEDANCE_MIN_VALUE Double Minimum impedance from which lines are considered to be connections without impedance PSSE_REFVOLTAGE Double Reference rated voltage for nodes and elements with 0 0 kV GRAPHIC_FILENAME_CNT Integer Number of the graphics files GRAPHIC_FILENAME GRAPHIC_FILENAME_ String UCTE Export Parameter Data type Complete path and file name for the first graphics file as well as for all subsequent files specifies the file number ranging from 2 up to at the very most the number indicated under GRAPHIC_FILENAME_CNT Description EXPORT_NAME Integer Export name or short name 0 name 1 short name EXPORT_NAME_KEY Integer DVG Export Parameter Data type Use nodes short names as BUS Number 0 yes 1 no Description EXPORT_NAME Integer 0 name Export name or short name 1 short name DVG Import Parameter Data type Description FILENAME String Complete path and file name of the data file DVG_IMPORT_MODE Integer Import
3. st Gr Ia in Ne BEAU SERArW yr Ee Oe Zum Verschieben klicken oder ziehen vlt Ht f Ei X 2689273 948 m Y 5514010 211 m eth Variante 1 Generally speaking this coupling solution is more difficult to implement since a network diagram has to be generated in addition to the technical data of the equipment Even determining the appropriate amount of detail is difficult Detailing is normally much greater in GIS than in a network planning system A large amount of data might even interfere with the planning Coupling requires the appropriate amount of detail for processing and planning in PSS SINCAL to be productive The advantages of this solution are however in particular in its universality Here as mentioned above the full PSS SINCAL range of functions for the planning and evaluation of the networks can be used April 2015 3 128 SIEMENS PSS SINCAL Database Interface and Automation 2 Structure of PSS SINCAL Database This chapter describes the structure of the PSS SINCAL database and explains the data model in detail with the help of a small example network 2 1 PSS SINCAL Networks A PSS SINCAL network is made up of a folder pair containing a SIN file and an additional directory e networkname sin e networkname files The file with extension sin is a PSS SINCAL User Interface help file to simplify network management Most network specific settings of the user interface and the sup
4. Flag_Type Integer Pump Type 1 Centrifugal pump 2 Reciprocating pump QOutput Double Output Flow uPump Double Characteristic Pump Speed FlowStep Double Maximum Flow Sliding Valve Non Return Valve FlowValve Attribute name Data type Description Flag_Type Integer Valve Type 1 Sliding valve 2 Non return valve Opening Double Degree of Opening Diameter Double Valve Diameter Pos Integer Valve Position 0 Close 1 Open Leakage FlowLeakage Attribute name Data type Description OutputSurface Double Output Surface fFlow Double Flow Number FlowStep Double Maximum Step for Flow ConLineLength Double Connection Line Length ConLineDiameter Double Connection Line Diameter ConLineRoughness Double Connection Line Sand Roughness ConLineZeta Double Connection Line Sand Zeta Value dsh Double Delta Elevation QFireWater Double Fire Water Flow pFireWater Double Fire Water Pressure tFireWater Double Fire Water Time Pressure Buffer FlowPressureBuffer Attribute name Data type Unit Description PMax Double bar Maximum Pressure April 2015 113 128 SIEMENS PSS SINCAL Database Interface and Automation Pump FlowPump Attribute name Data type Description Flag_Type Integer Pump Type 1 Centrifugal pump 2 Reciprocating pump QOutput Double Output Flow uPump Double Characteristic Pump Speed FlowStep
5. ADMIN is required for Oracle and SQL Server database systems This is needed for the main user managing the PSS SINCAL networks This parameter is defined in the format User Password If this parameter has not been entered the settings are loaded from the PSS SINCAL registry USER is required when the SQL Server is used as a database system This provides information on who is using the SQL Server and is defined in the format User Password SRV is used to explicitly enter the database server If this parameter has not been entered the server name is loaded from the PSS SINCAL registry April 2015 38 128 SIEMENS PSS SINCAL Database Interface and Automation The TYPE parameter indicates the network type You can select E electricity W water G gas and H district heating district cooling networks All other parameters are optional and control the generation procedure To define the type of database to be created use the parameter for DB The default is network database NET Additional values for these parameters are STD for standard type database and PROT for protection device database The DATA parameter fills the standard database or protection device database with standard types or standard devices LANG lets you select the language English German of the network database SIN lets you enter the PSS SINCAL network file This parameter is only for creating network databases Example of Creating a Network
6. Slip Double Slip Flag_SC Integer Short Circuit Behavior 1 Ik ip 1c lint 2 ip lic 3 Ignore Zero and Negative Phase Sequence Flag_ZO Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 Z0_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO_XO Double Ratio R X Zero Phase Sequence RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence la2in Double Current Ratio At Start Up R2_X2 Double Ratio R X Negative Phase Sequence Characteristics April 2015 97 128 SIEMENS PSS SINCAL Database Interface and TA Double Starting Time Power Unit Data Automation GD2 Double Momentum Power Unit Data Motor Start Up Flag_StartUpCtrl Integer Start Up Control 0 None 1 Current 2 Auto transformer 3 Current and auto transformer 4 Capacitor 5 Current and capacitor ConStart Integer Start Up Circuitry 1 Star 2 Delta 3 Star delta Integer Characteristic Data Circuitry 1 Star 2 Delta Reliability Data CustCnt Load Load Attribute name Long Integer Data type Number of Supplied Customers Description Flag_LoadTyp Intege
7. Umin Double Voltage Lower Limit Umax Double Voltage Upper Limit cosphi_lim Double Limit Power Factor Dynamic Data xd2 Double Subtransient Reactance Reliability Data Flag_LP Integer Load Priority 1 High 2 Medium 3 Normal 4 Small 5 Low CustCnt Long Integer Number of Supplied Customers April 2015 93 128 SIEMENS PSS SINCAL Database Interface and Automation Power Unit PowerUnit Attribute name Data type Description Flag_Machine Integer Type of Machine Turbo generator Hydro gen amort Hydro generator Condenser Non interconnected equivalent Power station equivalent Transmission system equivalent Distribution system equivalent ONDAN Sn Double Rated Apparent Power Un Double Rated Voltage R_X Double Ratio R X Positive Phase Sequence xd2 Double Subtransient Reactance xi Double Internal Reactance Ugmax Double Maximum Generator Voltage Ug Double Rated Voltage Generator cosphin Double Rated Power Factor Ikp Double Sustained Short Circuit Current of Compound Machines xd1sat Double Saturated Transient Reactance xd2sat Double Saturated Subtransient Reactance Un2 Double Rated Voltage Transformer Network Side Un1 Double Rated Voltage Transformer Generator Side Snt Double Rated Apparent Power Transformer Smax Double Full Load Power ur Double Short Circuit Volta
8. Power Flag_Limits Integer Limit Type 0 None 1 Flow Qmin Double Minimum Supply Qmax Double Maximum Supply Pressure Buffer FlowPressureBuffer Attribute name Data type Unit Description PMax Double bar Maximum Pressure Line FlowLine Attribute name Data type Description LineLength Double Length Diameter Double Diameter SandRoughness Double Sand Roughness fLength Double Length Allowance Factor fCurve Double Curve Factor fDiameterAn Double Annual Diameter Reduction fRoughnessAn Double Annual Roughness Increase Zeta Double Zeta Value Node FlowNode Attribute name Data type Description Sh Double Elevation Pres Double Pressure Reservation Heating Cooling Networks Calculation Settings FlowCalcParameter Attribute name Data type Description ITmax Integer Maximum Number of Iterations non linear ITmax2 Integer Maximum Number of Iterations linear MeshAccuracy Double Mesh Accuracy NodeAccuracy Double Node Accuracy FlowStep Double Maximum Step for Flow Flag_Operate Integer Check Operating Conditions 0 Warning 1 Error qSpec Double Specific Thermal Capacity April 2015 118 128 SIEMENS PSS SINCAL Database Interface and Automation Flag_MalFunc Integer Circuit for Malfunction 1 Supply line 2 Return line 3 Supply and return line Flag_Result Integer Store Result
9. ResTime Double Time April 2015 27 128 SIEMENS PSS SINCAL Database Interface and Automation Flag_State Integer State 1 Ok 2 Limit reached Loading Double Factor due to Extended Calculation Uph Double Phase Node Voltage Uph_Unph Double Node Phase Voltage Rated Node Phase Voltage phi_ph Double Angle Slack Phase Voltage U_Uref Double Voltage Reference Voltage Uph_Urefph Double Phase Voltage Reference Voltage LFBranchResult Load Flow Branch Results This table contains branch results from load flow calculations The results are provided for individual terminals Results for network elements are assigned by the secondary key Terminal1_ID Attribute name Data type Description Result_ID Long Integer Primary Key Result Terminal1_ID Long Integer Secondary Key Connection Terminal2_ID Long Integer Secondary Key Neighbor Terminal Variant_ID Long Integer Secondary Key Variant Double Active Power Double Reactive Power Double Apparent Power Double Power Factor Double Current Double Basic Rating Double Active Power Losses Double Reactive Power Losses Double Apparent Power Losses Double Series Voltage Drop deltaphi Double Phase Rotation Sn Double Basic Apparent Power S_Sn Double Apparent Power Basic Apparent Power Inp Double Basic Current Side 1 primary _Inp Double Cu
10. not supplied loads CA_PRE_ANALYSE_COUNT Integer Number of malfunctions to be calculated Restoration of Supply Parameter Data type Description LF_RESUP_MODE Integer Specifies the mode 0 standard 1 feeder based LF_RESUP_RESUPPLYCNT_ACT Integer Activation of the maximum number of restorations of supply 0 not activated 1 activated LF_RESUP_RESUPPLYCNT Integer Maximum number of resupplies LF_RESUP_SWITCHCNT_ACT Integer Activation of the maximum number of switching actions 0 not activated 1 activated LF_RESUP_SWITCHCNT Integer Maximum number of switching actions LF_RESUP_LOADSHEDDING_ACT Integer Activation of load shedding 0 not activated 1 activated LF_RESUP_VIOLATION_ACT Integer Activation of limit violations 0 not activated 1 activated LF_RESUP_SWITCHCNT_FACTOR Double Weighting for switching actions LF_RESUP_LOADSHEDDING_FACTOR Double Weighting for load shedding LF_RESUP_VIOLATION_FACTOR Double Weighting for violations VoltVar Parameter Data type Description OPT_VOLTVAR_CAP_SN Double Rated apparent power for the capacitor OPT_VOLTVAR_TRAFO Integer Activation of the transformer 0 not activated April 2015 59 128 SIEMENS PSS SINCAL Database Interface and Automation 1 activated OPT_VOLTVAR_TRAFO_SN Double Rated apparent power for the transformer OPT_VOLTVAR_TRAFO_U
11. rohu Double Maximum Tap Position alpha Double Additional Voltage Angle ukr Double Additional Voltage per Tap Position phi Double Voltage Phase Shift per Tap Position ukl Double Short Circuit Voltage at Minimum Tap Position uku Double Short Circuit Voltage at Maximum Tap Position ull Double Voltage Lower Limit uul Double Voltage Upper Limit Plp Double Active Power Lower Limit for Controller Pup Double Active Power Upper Limit for Controller Qlp Double Reactive Power Lower Limit for Controller Qup Double Reactive Power Upper Limit for Controller Dynamic Data ResFlux1 Double Residual Flux Phase L1 ResFlux2 Double Residual Flux Phase L2 ResFlux3 Double Residual Flux Phase L3 Three Winding Transformer ThreeWinding Transformer Attribute name Data type Description Un1 Double Rated Voltage Side 1 Un2 Double Rated Voltage Side 2 Un3 Double Rated Voltage Side 3 Sni2 Double Rated Apparent Through Power Side 1 2 Sn23 Double Rated Apparent Through Power Side 2 3 Sn31 Double Rated Apparent Through Power Side 3 1 Smax1 Double Full Load Power Side 1 Smax2 Double Full Load Power Side 2 Smax3 Double Full Load Power Side 3 Smax1_1 Double First Additional Full Load Power Side 1 Smax1_2 Double Second Additional Full Load Power Side 1 Smax1_3 Double Third Additional Full Load Power Side 1 Smax2_1 Double First Additional Full Load Power Side 2 Smax2_2
12. 0x00004000 Arc Flash Pipe networks 0x00080000 Steady State Calculations 0x00100000 Dynamic Calculations 0x00200000 Example const CalcMethod_LF const CalcMethod_SC Geo Stationary Calculations amp H00000001 amp H00000002 Set input data mask SimulateObj SetInputState CalcMethod LF Or CalcMethod_SC LoadDB Load the Input Data from Database Automation Loads the database to the main memory and creates the network model for the calculations SimulateObj LoadDB strMethod April 2015 56 128 SIEMENS PSS SINCAL Database Interface and Automation Parameters strMethod String Predefined sign for the calculation method For a complete list of permissible values see the function Start Start Calculation Comments When you select a specific calculation method PSS SINCAL loads only the data required by this calculation method from the database Example Load input data for load flow calculations from database SimulateObj LoadDB LF_NR SaveDB Save the Results to Database Stores the virtual results in the physical database so these are available for additional evaluations in the database after the automation solution SimulateObj SaveDB strMethod Parameters strMethod String Predefined sign for the calculation method For a complete list of permissible values see the function Start Start Calculation Example Save results to database Simu
13. Description Small sample for simulation automation A load at a node is constatly increased until a specified voltage drop occurs Author SS GM Modified 14 03 2008 Option Explicit const siSimulationok 1101 Dim strDatabase Database of sincal network strDatabase D Network Test Example Ele mdb Dim strProtDatabase Database with protection devices strProtDatabase D Server Setup Database ProtectionDB mdb Dim strLoad Name of Load to be changed str Load LOE Dim strLF Load flow procedure Seer SMITE ENRE Set locale to US gt necessary because is required for SQL commands SetLocale en gb If Not UCase Right WScript Fullname 11 CSCRIPT EXE Then Call Usage WS Craik tee Ouiets End it 1 Create an simulation object as in process server Dim SimulateObj Set SimulateObj WScript CreateObject Sincal Simulation If SimulateObj is Nothing Then WScript Echo Error CreateObject Sincal Simulation failed WS Craah aan OUE End If Setting databases and language SimulateObj DataSourceEx DEFAULT JET strDatabase Admin SimulateOb DataSourceEx PROT JET strProtDatabase Admin SimulateObj Language US Enable simulation batch mode load from phys database store to virtual database SimulateObj BatchMode 1 Load from database and generating calculation objects SimulateObj LoadDB CStr strLF Getting calculation object load for modifying Dim Load
14. Double Factor Constant Reactive Power Double Factor Current Dependent Reactive Power Double Factor Voltage Dependent Reactive Power April 2015 101 128 SIEMENS PSS SINCAL Database Interface and Automation Double Factor 1 Active Power Double Factor 1 Reactive Power Double Exponent 1 Active Power Double Exponent 1 Reactive Power Double Factor 2 Active Power Double Factor 2 Reactive Power Double Exponent 2 Active Power Double Exponent 2 Reactive Power Double Factor 3 Active Power f_q_3 Double Factor 3 Reactive Power ep3 Double Exponent 3 Active Power eq3 Double Exponent 3 Reactive Power Rsc Double Resistance Circuit Input XSC Double Reactance Circuit Input Zero and Negative Phase Sequence Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO_X0 Double Ratio R X Zero Phase Sequence RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence Double Active Power Negative Phase Sequence Double Reactive Power Negative Phase Sequence Shunt Harmonics Resonance Network HarResNet Attribute name Data type Description Un Double Rated Voltage R Double Resistance at Network Frequency X Double Reactance at Network Frequency Factor Double Initial Value Factor I
15. Usage cscript exe VoltageDropBatch vbs _ amp vbCrL amp vbCrLf _ amp A Woad at a node 1s constatly increased untill a specitied 7 amp voltage drop occurs gt amp vbCrLf WScript Echo strUsage End Sub Start the sample program at the prompt as follows gt cscript exe VoltageDrop vbs After the program starts PSS SINCAL normally displays an error message The reason for this is simple The sample program statically stores the PSS SINCAL network database to be used in the calculations These global preliminary settings need to be adapted for individual experiments Dim strDatabase Database of sincal network strDatabase D Network Test Example Ele mdb Dim strProtDatabase Database with protection devices strProtDatabase D Server Setup Database ProtectionDB mdb Dim strLoad Name of Load to be changed strLoad LO8 First modify the contents of the strDatabase variable Enter the network to be calculated Then change the strProtDatabase variable This defines the database for global protection devices and can be found in the PSS SINCAL Installation database directory The strLoad variable specifies the load to be increased In our example this is the load with the name L08 April 2015 46 128 SIEMENS PSS SINCAL Database Interface and Automation When you restart the sample program after you have modified the database paths PSS SINCAL displays the following text gt cscript exe
16. 2 Grounded w impedances Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 RO_X0 Double Ratio R X Zero Phase Sequence ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence Controller Data Flag_Roh Integer Controller State 1 Fix 2 Variable node 3 Variable terminal roh Integer Present Tap Position rohl Integer Minimum Tap Position rohu Integer Maximum Tap Position deltaS Double Additional Reactive Power uul Double Voltage Upper Limit ull Double Voltage Lower Limit Qmin Double Minimum Total Reactive Power Qmax Double Maximum Total Reactive Power CosPhiMin Double Cosinus Phi Minimum CosPhiMax Double Cosinus Phi Maximum Dynamic Data ResFlux1 Double Residual Flux Phase L1 ResFlux2 Double Residual Flux Phase L2 ResFlux3 Double Residual Flux Phase L3 Shunt Capacitor ShuntCondensator Attribute name Data type Description Sn Double Rated Apparent Power Un Double Rated Voltage Vdi Double Dielectric Losses Zero Phase Sequence April 2015 100 128 SIEMENS PSS SINCAL Database Interface and Automation Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z
17. All elements 2 All lines 3 All restricted elements 4 All restricted lines Speed_BaseLimit Double Base Speed Limit Flag_CausedMalfunc Integer Caused Malfunction 0 None 1 Marked areas 2 Own area Flag_CausedElem Integer Caused Elements 1 Restricted elements 2 Restricted lines Speed_CausedLimit Double Caused Speed Limit Flag_Report Integer Reporting None Elements and nodes Lines and nodes Elements Lines Nodes Compressor FlowCompressor Attribute name Data type Description plinlet Double Max Pressure Deviation pOutlet Double Pressure at Outlet Node pDevation Double Pressure at Inlet Node Const Pressure Decrease Const Flow FlowConstLine Attribute name Data type Description Flag_Typ Integer Line Type 1 Constant pressure drop 2 Constant flow PressureDecr Double Pressure Drop FlowGas Double Flow Consumer FlowConsumer Attribute name Data type Description Flag_Q Integer Consumption Type 1 Standard 2 Operating Conditions 3 Power Double Constant Consumption Standard April 2015 116 128 SIEMENS PSS SINCAL Database Interface and Automation Q2 Double Constant Consumption Operating Cond Q3 Double Constant Consumption Power pDiffMin Double Minimum Pressure Difference pRelMin Double Minimum Relative Pressure DesignTemp
18. Branch Elements TwoWindingTransformer Two winding transformer ThreeWindingTransformer Three winding transformer Line Line VarSerialElement Variable shunt element SerialReactor Serial reactor SerialCondensator Serial capacitor HarBranchResNet Serial Harmonics Resonance Network Additional Elements ProtOCFault Fault observation ProtLocation Protection location Water Networks Object type Description General Data FlowCalcParameter Calculation settings FlowNetworkLevel Network level FlowNetworkGroup Network area Nodes Busbars FlowNode Node Elements FlowWaterTower Water tower FlowPump Pump FlowConsumer Consumer FlowPressureBuffer Pressure buffer FlowLeakage Leakage Branch Elements FlowLine Line FlowValve Sliding valve non return valve April 2015 86 128 SIEMENS PSS SINCAL Database Interface and Automation FlowPumpLine Pressure increase pump FlowConstLine Const pressure decrease const flow FlowPressureReg Pressure regulator Gas Networks Object type Description General Data FlowCalcParameter Calculation settings FlowNetworkLevel Network level FlowNetworkGroup Network area Nodes Busbars FlowNode Node Elements FlowlnfeederG Infeeder gas FlowConsumer Consumer FlowPressureBuffer Pressure buffer FlowLeakage Leakage Branch Elements FlowLine Line FlowValve Sliding valve non return valve Flo
19. Initial Value React Power Qst 0 0 MVAr Voltage Angle delta 0 0 Voltage u 100 0 Zero Phase Sequence Minimum K The infeeder is a network element with one single terminal This network element is therefore designated as a node element In the database the infeeder is described with the following tables e Element This is the basic record for the network element e Infeeder This table contains the specific attributes for the infeeder e Terminal This table creates the connection between the network element and the nodes busbars Element Element_ID VoltLevel_ID Group ID Name Type Flag_Input Flag_Variant Variant_ID 1 2 17 Infeeder 3 1 1 The basic data for the network element are stored in the Element table The record contains the primary key for the network element in the Element_ID field This assures the network element is uniquely identifiable The VoltLevel_ID field creates a connection to the network level In this case this is the 10 kV network level HV VoltLevel_ID 2 The Type field stores the type of network element This is an ASCII field and contains exactly the name of the data table for the network element types Infeeder April 2015 12 128 SIEMENS PSS SINCAL Database Interface and Automation The Flag_Input field has the code for the network element s input status The binary value 3 is for the Bit 0 Bit 1 gt short circuit data load flow data In
20. Read Write Shutdown Time Network Elements TOPO ID Read Internal ID Network Element TOPO DBID Read Database ID Network Element Element_ID TOPO Name Read Name Network Element TOPO ShortName Read Short Name Network Element TOPO State Read Write Operational Status Network Element 0 Out of service 1 In service TOPO TI Read Write Establishment Time TOPO TS Read Write Shutdown Time TOPO Node1 ID Read Internal ID 1 Node up to 3 nodes are possible TOPO Node1 DBID Read Database ID 1 Node TOPO Terminal1 ID Read Internal ID 1 Terminal up to 3 terminals are possible TOPO Terminal1 DBID Read Database ID 1 Terminal TOPO Terminal1 State Read Write Switching Status 1 Terminal 0 Switches opened 1 Switches closed TOPO Terminal1 Phase Connection Phase 1 11 2 L2 April 2015 88 128 SIEMENS PSS SINCAL Database Interface and Automation Additional Elements TOPO ID Internal ID Additional Element TOPO DBID Database ID Additional Element Element_ID TOPO Name Name Additional Element The ID attribute has a unique key for the unique identification of every object in the calculation methods DBID has the Database ID of the specific node network element or terminal The State attribute is a special feature for network elements and
21. Short Name N2 M N2 Network Level LV 1 0kV Network Area Base Area Station None Bay None Node Type Node Main Busbar None Establishment Time None Shutdown Time None Diagram No zi Include Network Name Once both busbars have been created the Node table contains the following values Node Node_ID Group_ID VoltLevel ID Name Un Flag_Variant Variant_ID 1 1 2 N1 10 0 1 1 2 1 1 N2 1 0 1 1 Here you can already see the nodes busbars Node are assigned to the network levels VoltageLevel with the secondary key The busbar N1 has been assigned to the 10 kV network level HV and given the ID 2 The busbar N2 has been assigned to the 1 kV network level LV and given the ID 1 Step 4 Create the Infeeder The next step is to create an infeeder PSS SINCAL has various network elements to simulate infeeders The following example creates a network infeeder Click Insert Node Element Infeeder in the menu to start this process April 2015 11 128 SIEMENS PSS SINCAL Database Interface and Automation Infeeder Basic Data Element Data Controller Node N1 Lal Phasing L123 Element Name 1 Equivalent Supply Network Level HV 10 0 kV T Out of service N1 Minimum Short Circuit Power sk 1000 0 MVA 1 00 0 MVA 1 0000 Resistance Reactance R X 0 1 Voltage Sk 10 intemal Reactance xi Operate State Load Flow Type fusrclanddeta x Initial Value Active Power Pst 0 0 MW
22. SymbolFrgndColor Long Integer Symbol Line Color SymbolPenStyle Integer Symbol Pen Style SymbolPenWidth Integer Symbol Pen Width TextAlign Integer Adjust Text Flag Long Integer Flag Variant_ID Long Integer Secondary Key Variant Flag_ Variant Integer Element of Current Variant 0 No 1 Yes GraphicArea_ID Long Integer Secondary Key Graphic Area Tile The fields Pos_X and Pos_Y define the connection point between the terminal and the node or the busbar With a node this is always the center With a busbar this can be anywhere on the busbar The secondary key GraphicText_ID assigns a graphic text object This means an individual text object will be displayed in the Graphics Editor with its own position and graphics attributes If you wish you can initialize the field with NULL Then PSS SINCAL will display the text with default attributes in the Graphics Editor but the text cannot be edited manually 2 5 2 Additional Tables GraphicText Text Objects This table specifies individual text objects for nodes busbars and network elements Attribute name Data type Description GraphicText_ID Long Integer Primary Key Graphic Text GraphicLayer_ID Long Integer Secondary Key Layer Font Text 20 Font FontStyle Integer Style 16 Standard 17 Fat 18 Cursive FontSize Integer Text Height TextAlign Integer Text Alignment 0 Left 1 Middle 2 Right TextOrie
23. Zero Phase Sequence XO Double Reactance Zero Phase Sequence Pneg Double Active Power Negative Phase Sequence Qneg Double Reactive Power Negative Phase Sequence Dynamic Data ResFlux1 Double Residual Flux Phase L1 ResFlux2 Double Residual Flux Phase L2 ResFlux3 Double Residual Flux Phase L3 Shunt Impedance Shuntlmpedance Attribute name Data type Description Double Rated Voltage Double Resistance Double Reactance Zero Phase Sequence Flag_ZO0 Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 RO_X0 Double Ratio R X Zero Phase Sequence ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence Dynamic Data ResFlux1 Double Residual Flux Phase L1 ResFlux2 Double Residual Flux Phase L2 ResFlux3 Double Residual Flux Phase L3 April 2015 99 128 SIEMENS PSS SINCAL Database Interface and Automation Shunt Reactor ShuntReactor Attribute name Data type Description Sn Double Rated Apparent Power Un Double Rated Voltage Vfe Double Iron Losses Vcu Double Copper Losses Zero Phase Sequence Flag_ZO0 Integer Grounding 0 Not grounded 1 Fixed grounded
24. calculation object even has functions to simplify accessing the results of the network elements For a list of attributes addressed by the calculation object see the chapter on Attributes of Calculation Objects Simulation objects with the GetObj function create an instance for a calculation object Example Get simulation object of type Load with name LO8 Dim LoadObj Set LoadObj SimulateObj GetObj LOAD LO8 Tf LoadOb Is Nothing Then WSeript Echo Error load not found WSeript Quit End If Release the simulation object Set LoadObj Nothing Count Number of Possible Attributes Returns the number of the possible attributes for the respective object 1Cnt LoadObj Count April 2015 mee SIEMENS PSS SINCAL Database Interface and Automation Return Value ICnt Long Integer Number of possible attributes Example Get the number of available attributes Dim Cnt Cnt LoadObj Count Name Determine Attribute Names Returns the name of an attribute strName SimObj Name iAttribute Properties Name String Name of the attribute Parameters iAttribute Long Integer Number of the attribute Example Display the names of all available attributes for the object Dim alee CME 1Cnt SimObj Count POr IAHE le lone Crit Dim strName strName SimObj0Obj Name iAttr WScrilp te hchomiAttir seul ecu Er Name Next Item Access Attributes
25. 1 Phase Ground Fault PROT_ROUTE SC2 Route 2 Phase Ground Fault PROT_ROUTE GC2 Route 2 Phase Short Circuit PROT_ROUTE SC3 Route 3 Phase Short Circuit PROT_ROUTE Protection Routes Individual Short Circuit Number of IC x R E Phases Return Line Fault Ground Fault ARCFL Arc Flash ZUBER Reliability ZUBER_EVAL Reliability Evaluations Water networks FLOW_H20 Steady State FLOW_H20_TM Time Series FLOW_H2O0_OP Operating Series FLOW_H20_COND Contingency Analysis FLOW_H20_MALF Contingency Analysis Selected Elements FLOW_H20_FWP Fire Water Pressure FLOW_H20_FWQ Fire Water Amount FLOW_H20_LEAKP Fire Water Pressure Selected Elements FLOW_H20_LEAKQ Fire Water Amount Selected Elements Gas networks FLOW_GAS Steady State FLOW_GAS_TM Time Series FLOW_GAS_OP Operating Series FLOW_GAS_COND Contingency Analysis FLOW_GAS_MALF Contingency Analysis Selected Elements Heating cooling networks FLOW_HEAT Steady State FLOW_HEAT _TM Time Series FLOW_HEAT _OP Operating Series FLOW_HEAT_COND Contingency Analysis FLOW_HEAT_MALF Contingency Analysis Selected Elements April 2015 67 128 SIEMENS PSS SINCAL Database Interface and Automation The following table lists the parameters that can be used to specify the import and export functions Import export Description Electrical networks CIM_IMP CIM Import CIM_EXP CIM Export PSSE_IMP PSS E Import PSSE_EXP PSS E Export UCTE_IMP UCTE Import UCTE_EXP UCTE Export DVG_IMP DVG I
26. 2 o B text modify marker In our example a branch element a two winding transformer is selected As can be seen in this example components of the network elements are easy to recognize the displayed branch element consists of a symbol both terminals linking the symbol to the node and texts Node elements consist of one terminal a symbol and text Branch elements consist of two terminals a symbol and text A special form of branch elements is the three winding transformer Unlike all other branch elements it connects to three rather than two nodes or busbars April 2015 19 128 SIEMENS PSS SINCAL Database Interface and Automation GraphicNode Graphics for Nodes Busbars This table describes the graphics attributes for nodes busbars Attribute name Data type Description GraphicNode_ID Long Integer Primary Key Graphic Node GraphicLayer_ID Long Integer Secondary Key Layer GraphicType_ID Long Integer Secondary Key Object Type GraphicText_ID1 Long Integer Secondary Key Text 1 GraphicText_ID2 Long Integer Secondary Key Text 2 Node_ ID Long Integer Secondary Key Node FrgndColor Long Integer Line Color BkgndColor Long Integer Background Color PenStyle Integer Pen Style 0 Straight line 1 Small dotted 2 Dotted 3 Straight line point straight line 4 Straight line point point straight line PenWidth Integer Pen Width N
27. 211 16 ZN11 Zero Phase Sequence FlagZOInput Integer Input 1 Z0 Z1 and R0 X0 2 RO and X0 3 RO R1 and X0 X1 ZO_Z1_12 Double Ratio Zero Phase to Positive Phase Sequence Impedance Z0_Z1_23 Double Ratio Zero Phase to Positive Phase Sequence Impedance Z0_Z1_31 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO_R1_12 Double Ratio Zero Phase to Positive Phase Resistance RO_R1_23 Double Ratio Zero Phase to Positive Phase Resistance RO_R1_31 Double Ratio Zero Phase to Positive Phase Resistance RO_12 Double Resistance Zero Phase Sequence RO_23 Double Resistance Zero Phase Sequence RO_31 Double Resistance Zero Phase Sequence X0_12 Double Reactance Zero Phase Sequence X0_23 Double Reactance Zero Phase Sequence X0_31 Double Reactance Zero Phase Sequence X0_X1_12 Double Ratio Zero Phase to Positive Phase Reactance X0_X1_23 Double Ratio Zero Phase to Positive Phase Reactance X0_X1_ 31 Double Ratio Zero Phase to Positive Phase Reactance RO_X0_12 Double Ratio R X Zero Phase Sequence RO_X0_23 Double Ratio R X Zero Phase Sequence RO_X0_31 Double Ratio R X Zero Phase Sequence Controller Data Flag_Roh1 Integer State Tap Position Side 1 0 None 1 Fixed 2 Node 3 Impedance 4 Active power 5 Reactive power Flag_Roh2 Integer State Tap Position Side 2 0 None 1 Fixed 2 Node 3 Impe
28. Automation GraphicText_ID1 Long Integer Secondary Key Graphic Text 1 GraphicText_ID2 Long Integer Secondary Key Graphic Text 2 Element_ID Long Integer Secondary Key Element SymbolDef Long Integer Set Symbol Properties as Default FrgndColor Long Integer Line Color BkgndColor Long Integer Background Color PenStyle Integer Pen Style 0 Straight line 1 Small dotted 2 Dotted 3 Straight line point straight line 4 Straight line point point straight line PenWidth Integer Pen Width SymbolSize Integer Symbol Size Factor SymCenterX Double Symbol Center X Coordinate SymCenterY Double Symbol Center Y Coordinate SymbolType Long Integer Symbol Type Electrical Networks 9 Synchronous machine Power unit Infeeder Asynchronous machine Load Shunt impedance Shunt reactor Shunt capacitor Static compensator Line Two winding transformer Three winding transformer Serial reactor Serial capacitor Shunt ripple control transmitter Serial ripple control transmitter Shunt RLC circuit Serial RLC circuit Harmonic resonance network 193 DC Infeeder 194 DC Serial element 123 Variable Shunt Element 124 Variable Serial Element Symbol Type Pipe Networks 9 Water Tower Infeeder Pump Infeeder Gas Infeeder Heating Cooling Consumer Pressure Buffer Leakage Temperature Regulator Line Pressure Increase Pump Const Pr
29. COM Interfaces All PSS SINCAL components have COM interfaces A differentiation is made between internal and external COM interfaces The internal interfaces are only used within PSS SINCAL They are not documented and as such not designed for external use The external interfaces are documented and can also be used in your own applications This lets you for example automize work sequences or integrate calculation methods into your own applications Ready Made Solutions In the area of GIS coupling our partners offer ready made solutions that can be tailored to meet your April 2015 126 128 SIEMENS PSS SINCAL Database Interface and Automation specific needs Varied PSS SINCAL clients have successfully implemented these solutions L amp Mark Informatika Kft L amp MARK Informatika Kft is your partner in the implementation of PSS SINCAL GIS integration worldwide The company is partner of AED SICAD and has existing solutions on several GIS platform ESRI ArcFM ArcFM UT Sicad open SICAD UTE Intergraph GNET etc L amp MARK Informatika Kft Mrs Andrea Lisziewicz Margit krt 43 45 4 5 1024 Budapest Hungaria Fon 36 1 201 7725 Fax 36 1 201 2817 e mail andrea lisziewicz Imark hu http www mark hu Mettenmeier GmbH Mettenmeier GmbH is a software consultant service and solution provider with corporate headquarters in Paderborn Germany supporting clients in the gas water and electric industries We
30. Centrifugal pump 2 Reciprocating pump QOutput Double Output Flow uPump Double Characteristic Pump Speed tSupply Double Supply Temperature FlowStep Double Maximum Flow Flag_Limits Integer Limit Type 0 None 1 Flow QOutputmin Double Minimum Output Flow QOutputmax Qmax Maximum Output Flow Line FlowLine Attribute name Data type Description LineLength Double Length Diameter Double Diameter SandRoughness Double Sand Roughness fLength Double Length Allowance Factor fCurve Double Curve Factor Zeta Double Zeta Value LeakageRate Double Leakage Rate HeatingCond Double Thermal Conductivity April 2015 123 128 SIEMENS PSS SINCAL Database Interface and Node FlowNode Attribute name Data type Automation Description Sh Double Elevation PDiffMin Double Minimum Pressure Difference April 2015 124 128 SIEMENS PSS SINCAL Database Interface and 5 1 Automation Reference Documentation The complete PSS SINCAL documentation is available as online help You can also find these documents in the Doc English Sincal directory on the installation DVD as PDF files User Interface For a comprehensive description of all the functions of the PSS SINCAL user interface see the System Manual New users should refer to the chapter on Using an Example to Work on a Network This outlines step
31. Database C gt SinDBCreate exe DBSYS ACCESS FILE C Temp dbnet mdb TYPE E The above example creates the Access database dbnet mdb for an electrical network in the C Temp directory in English Example of Creating a Standard Database C gt SinDBCreate exe DBSYS ORACLE FILE OraSTDFL pwd123 ORA10 TYPE W ADMIN SINCAL SINCAL DB STD DATA In the above example an Oracle standard database has been created for pipe networks in English This database has OraSTDFL for the Oracle user and the password pwd123 Additionally the database is filled with standard types Example of Creating a Protection Devices Database C gt SinDBCreate exe DBSYS ACCESS FILE C Temp stdprot mdb TYPE E DB PROT The above example creates an Access protection device database for electrical networks in English The stdprot mdb database is created in the directory C Temp An empty database is created List PSS SINCAL Databases In addition to creating PSS SINCAL databases the SinDBCreate help program can be used to list all the databases at a database server Switch ON this function with the LIST parameter SinDBCreate LIST DBSYS xxx ADMIN User Password SRV xxx List all Databases on a server April 2015 39 128 SIEMENS PSS SINCAL Database Interface and Automation Required Parameters DBSYS ORACLE SQLSERVER Database System ADMIN User Password Administrator Login for Database Servers SRV Instance Database Servic
32. Determine attribute names e tem Access attributes Database Object e GetRowObj Determine instance for a tabular object Tabular Object e Open Open the tabular object e Close Close a tabular object e CountRows Determine the number of records e MoveFirst MoveLast MoveNext MovePrev Position in the data e Count Number of possible attributes e Name Determine attribute names e tem Access attributes Message Object e Count Number of possible messages e Item Access message data object Message Data Object e Text Message text e Type Message type e CountObjectids Number of network elements e ObjectidAt ObjectTypeAt Network element data April 2015 49 128 SIEMENS PSS SINCAL Database Interface and 4 1 1 Automation Attributes of Calculation Objects e Attributes for electrical networks e Attributes for pipe networks Simulation Object This object creates the basis for all further automation functions It is a duplicate of the PSS SINCAL calculation module and as such is the main object of any automation Simulation objects can be instantiated as either Local Servers or In Process Servers Local Server Local servers are executable programs that implement COM components When a COM component is instantiated this program starts as its own background process For communication between the processes PSS SINCAL uses a special RPC log Remote Procedure Call to slow down th
33. Double Second Additional Full Load Power Side 2 Smax2_3 Double Third Additional Full Load Power Side 2 Smax3_1 Double First Additional Full Load Power Side 3 Smax3_2 Double Second Additional Full Load Power Side 3 Smax3_3 Double Third Additional Full Load Power Side 3 uk1 Double Reference Short Circuit Voltage Side 1 2 uk2 Double Reference Short Circuit Voltage Side 2 3 uk3 Double Reference Short Circuit Voltage Side 3 1 ur Double Ohmic Short Circuit Voltage Side 1 2 ur2 Double Ohmic Short Circuit Voltage Side 2 3 Double Ohmic Short Circuit Voltage Side 3 1 Double No Load Current Double Iron Losses Double Additional Phase Rotation Side 1 Double Additional Phase Rotation Side 2 Double Additional Phase Rotation Side 3 April 2015 104 128 SIEMENS PSS SINCAL Database Interface and Automation VecGrp1 Integer Vector Group Side 1 1 YO 2 YNO 3 Y6 4 YN6 5 D1 6 D5 7 D7 8 D11 9 Z1 10 ZN1 11 Z5 12 ZN5 13 Z7 14 ZN7 15 211 16 ZN11 17 ATN 18 AT VecGrp2 Integer Vector Group Side 2 1 YO 2 YNO 3 Y6 4 YN6 5 D1 6 D5 7 D7 8 D11 9 Z1 10 ZN1 11 Z5 12 ZN5 13 Z7 14 ZN7 15 Z11 16 ZN11 17 ATN 18 AT VecGrp3 Integer Vector Group Side 3 1 YO 2 YNO 3 Y6 4 YN6 5 D1 6 D5 7 D7 8 D11 9 Z1 10 ZN1 11 Z5 12 ZN5 13 Z7 14 ZN7 15
34. Island Operation 0 No 1 Yes StartTime Double Start Time Load Profile Duration Double Duration Load Profile TimeStep Double Time Step Load Profile IncrStartDate Double Start Date Load Increase IncrEndDate Double End Date Load Increase PeakCurrentCalc Integer Peak Short Circuit Current Calculation Type 1 Meshed network 2 Non meshed network 3 Equivalent frequency procedure TrippCurrentCalc Integer Tripping Current Calculation Type 1 IANEU VDE0102 1 90 IEC 909 2 IAALT VDE0102 10 71 Ecolnflation Double Cost increase Network Level VoltageLevel Attribute name Data type Description Flag_Volt Integer Kind of Voltage 1 Line Line Voltage 2 Line Earth Voltage Un Double Nominal Voltage Uop Double Network Operating Voltage f Double Frequency fRD Double Ripple Control Frequency Temp_Line Double Overhead Line Conductor Temperature Temp_Cabel Double Cable Conductor Temperature AmbTemp_Cable Double Ambient Temperature of Cable AmbTemp_Line Double Ambient Temperature of Overhead Line TempSun_Line Double Temperature Increase due to Sun at Overhead Line CalcSC Integer Calculate Short Circuit 0 No 1 Yes CalcNpt Integer Calculate Current through Neutral Points 0 No 1 Yes FlagUsc Integer Voltage Data due to VDE IEC 1 c value 2 Source voltage Double Source Voltage Double c Value Do
35. Lets you access the different input and output data for a calculation object Value Value SimObj Item 1Attribute SimObj Item strAttribute SimObj Item JAttribute Value SimObj Item strAttribute Value April 2015 fence SIEMENS PSS SINCAL Database Interface and Automation Properties Item Variant Value of the attribute Parameters iAttribute Long Integer Numerical index of the attribute strAttribute Long Integer Name of the attribute Comments What attributes are actually available depends on the object All objects have identical topology attributes These topology attributes uniquely identify nodes and network elements and are used to switch them ON and OFF For a detailed presentation of all the objects and their available attributes see the chapter Calculation Objects and their Attributes Example Get P from the object and set a new value for this attribute Dim Val Val SimObj Item P SimObj Item P P 2 Get the value with the index 3 and assign a new value Dim Val Val SimObj Item 3 SimObj Item 3 Val 2 Result Access Calculation Results Object Lets you access the results object of a calculations object Set ResultObj SimObj Result strResult iTerminalNo Parameters strResult String SQL name of the desired results table iTerminalNo Integer Connection number for the desired results April 2015 73 128 SIEMENS PSS
36. Loop over all objects of the current message If Msg CountObjzectids gt 0 Then Dim i Dim strObjects hor i 1 or Msg 7countObjectilds If strObjects lt gt Then strObjects strObjects amp End be Determine database and object type Dim sDBType Dim sRowType sDBType Msg ObjectTypeAt i amp H1000 sRowType Msg ObjectTypeAt i And amp HOFFF strObjects strObjects amp Msg ObjectIdAt i amp amp sRowType amp Next WScript Echo strObjects End If Calculation Objects and their Attributes Available Calculation Objects The following tables show the calculation objects that are available for the different network types Electrical Networks Object type Description General Data CalcParameter Calculation settings VoltageLevel Network level NetworkGroup Network area April 2015 85 128 SIEMENS PSS SINCAL Database Interface and Automation Nodes Busbars Node Node Elements SynchronousMachine Synchronous machine PowerUnit Power unit Infeeder Infeeder DCInfeeder DC Infeeder AsynchronousMachine Asynchronous machine Load Load ShuntImpedance Shunt impedance ShuntReactor Shunt reactor ShuntCondensator Shunt capacitor VarShuntElement Variable serial element HarResNet Shunt Harmonics Resonance Network
37. PenWidth SwtType SwtAlign SwtNodePos SwtFactor SwtFrgndColor SwtPenStyle SwtPenWidth SymbolType SymbolAlign SymbolNodePos SymbolFactor SymbolFrgndColor SymbolPenStyle SymbolPenWidth TextAlign Flag Variant ID Flag Variant Mewes 27 Uy 2s 2 0g 22 0G 0G 0 r0 yy a a a O ASA a A insert into GraphicText GraphicText_ID GraphicLayer ID Font FontStyle FontSize TextAlign TextOrient TextColor Visible AdjustAngle Angle Posl Pos2 Flag RowTextNo AngleTermNo Variant _ID Flag Variant valvas 28 1 Arial oy bly 3707 0 0 25 Ue 2 0 0 insert into GraphicText GraphicText_ID GraphicLayer ID Font FontStyle FontSize TextAlign TextOrient TextColor Visible AdjustAngle Angle Posl Pos2 Flag RowTextNo AngleTermNo Variant_ID Flag Variant welues 29 1 Ariel 2 tls Uy by 0 07 0625702 oe Uy UU lyk fb insert into GraphicText GraphicText_ID GraphicLayer ID Font FontStyle FontSize TextAlign TextOrient TextColor Visible AdjustAngle Angle Posl Pos2 Flag RowTextNo AngleTermNo Variant_ID Flag Variant velves SW il VArte o Lyp iil 70 0 ly Op 0 0 255 05257070 Wg Aly Al Save Read out Data WriteSINCAL WriteSINCAL writes data already read out and converted to SQL insert commands to the PSS SINCAL network database Sub WriteSINCAL WSeript fcne Welting Data Call OpenDatabase strSINCALdb April 2015 36 128 SIEMENS PSS SINCAL Database In
38. Pressure Regulator FlowPressureReg Attribute name Double Data type Design Temperature of Consumer Description plnlet Double Max Pressure Deviation pOutlet Double Pressure at Outlet Node pDevation Double Pressure at Inlet Node Flag_Pessinc Integer Function 1 Pressure increase 2 Pressure drop 3 Pressure increase and drop QReturn Double Maximum Return Flow Sliding Valve Non Return Valve FlowValve Attribute name Data type Description Flag_Type Integer Valve Type 1 Sliding valve 2 Non return valve Pos Integer Leakage FlowLeakage Attribute name Data type Valve Position 0 Close 1 Open Description OutputSurface Double Output Surface fFlow Double Flow Number FlowStpG Infeeder Gas FlowInfeederG Attribute name Double Data type Maximum Step for Flow Description Flag_Typ Integer Infeeder Type 1 Pressure supply 2 Flow supply QReturn Double Maximum Return Flow pConst Double Constant Excess Pressure FlagQ Integer Flow Supply Type 1 Flow supply 2 Operating Conditions 3 Power Constant Supply Standard April 2015 117 128 SIEMENS PSS SINCAL Database Interface and Automation Q2 Double Constant Supply Operating Condition Q3 Double Constant Supply
39. SIEMENS PSS SINCAL Database Interface and Automation Select Case Msg Type case 1 STATUS WSErFipt fcho Staetus case 4 INFO WSCript Beno Info case 3 WARNING WScript Echo Warning case 4 ERROR WSeriCt 2cno Error End Select CountObjectids Number of Network Elements Specifies how many network elements the message refers to 1CntElements Msg CountObjectIds Properties CountObjectlds Long Integer Number of network elements Comments This property is read only Example Loop over all objects of the current message Tf Msg CountObjectids gt 0 Then Dim i For i 1 To Msg CountObjectIds Next Ene ie ObjectidAt ObjectTypeAt Network Element Data Provides the Object ID and the object type for a network element TO mp Msg ObjectIdAt lIndex iObjType Msg ObjectTypeAt lIndex Parameters lindex Long Integer Numerical index starting with 1 April 2015 84 128 SIEMENS PSS SINCAL Database Interface and 4 2 4 2 1 Automation Properties ObjectldAt Long Integer Network element ID ObjectTypeAt Integer Database and type of the network element in a screen form Comments The object type is stored in the first 12 bits and the database type in the highest 4 bits To determine the object type the bit mask has to be combined with OFFF You get the database type by moving the bits 12 spaces to the right These properties are read only Example
40. SINCAL Database Interface and 4 1 3 Automation Return Value ResultObj Object Automation object for the results Comments PSS SINCAL provides network element results for each terminal Node elements such as generators asynchronous machines and loads have one terminal and branch elements Such as lines transformers and serial reactors have two terminals Example Get load flow results on the first terminal of object Dim ResultObj Set ResultObj SimObj Result LFBRANCHRESULT 1 If ResultObj Is Nothing Then WScript Echo Error No result available End If Calculation Results Object Calculation results objects are virtual objects that simplify accessing results for individual network elements Calculation objects with the Result function produce an instance of a calculation results object Example Get the load flow result object for a load Dim LFBranchResultLoad Set LFBranchResultLoad LoadObj Result LFBRANCHRESULT 1 If LFBranchResultLoad Is Nothing Then WScript Echo Error Cant get result object ENG TE If the instance of the automation object is not used any longer it must be released with the following instruction Relase the result object Set LFBranchResultLoad Nothing Count Number of Possible Attributes Returns the number of the possible attributes for the respective results object 1Cnt ResultObj Count April 2015 74 128 SIEMENS PSS SINCAL Database In
41. Structure COND Contingency Analysis SC1 1 Phase Ground Fault SC2 2 Phase Short Circuit SC3 3 Phase Short Circuit SC1 NodelD 1 Phase Ground Fault at Node SC2 NodelD 2 Phase Short Circuit at Node SC3 NodelD 3 Phase Short Circuit at Node IC x R E NodelD Individual Short Circuit Number of Phases Return Line Fault Ground Fault at Node GC2 2 Phase Ground Fault MF Multiple Faults DIM Low Voltage Dimensioning HAR Harmonics RC Ripple Control ECO_SUM Economic Efficiency April 2015 66 128 SIEMENS PSS SINCAL Database Interface and Automation MOT Motor Start Up MOT_SIMPLE Simple Motor Start Up NETO_STAB Stability NETO_TSTAB Transient Stability NETO_EW Eigenvalues REL Reliability REL_EVAL Reliability Evaluations PROT SC1 FaultID Protection Coordination 1 Phase Ground Fault PROT SC2 FaultID Protection Coordination 2 Phase Short Circuit PROT GC2 FaultID Protection Coordination 2 Phase Ground Fault PROT SC3 FaultID Protection Coordination 3 Phase Short Circuit PROT IC x R E Protection Coordination Individual Short Circuit Number of FaultID Phases Return Line Fault Ground Fault PROT MF Fault Summary for Multiple Faults PROT_DET Determining Fault Locations PROT_SET DI Device Settings PROT_SET_CHART DI Device Charts PROT_ROUTE SC1 Route
42. are dedicated to enabling the owners and operators of utility assets to plan and manage their networks more successfully Mettenmeier GmbH provides a SIEMENS certified interface between the Smallworld standard Network Resource Managers and PSS SINCAL Mettenmeier GmbH Utility Solutions Mr Benjamin Pehle Klingenderstr 10 14 33100 Paderborn Germany Fon 49 5251 150 375 Fax 49 5251 150 366 e mail benjamin pehle mettenmeier de http mettenmeier de Khatib amp Alami C E C Khatib amp Alami Consolidated Engineering Company K amp A is a multi disciplinary company specialized in consulting engineering studies design and construction supervision of architectural structural civil electrical mechanical industrial environmental transportation telecommunication information technology and geographic information systems GIS projects April 2015 127 128 SIEMENS PSS SINCAL Database Interface and Automation K amp A provides an interface between ArcGIS and PSS SINCAL This interface is for electricity transmission and distribution networks Khatib amp Alami C E C GIS Services Division Mr Bilal A Hassan P O Box 2732 Abu Dhabi UAE Fon 971 2 6767300 X202 Fax 971 2 6767070 e mail bahassan gisadwea ae http www khatibalami com April 2015 128 128
43. are not needed for the network calculations This means that if you are only using PSS SINCAL calculation methods e g for an engines solution you do not need to fill in the graphics tables The following list shows the most important PSS SINCAL graphics tables e Basic tables for graphics elements o GraphicNode Graphics for nodes busbars o GraphicElement Graphics for network element symbols o GraphicTerminal Graphics for terminals of network elements e Additional tables o GraphicBucklePoint Buckle points o GraphicText Texts e Basic structures o GraphicAreaTile Area and tile o GraphicLayer Layers o GraphicObjectType Object types April 2015 18 128 SIEMENS PSS SINCAL Database Interface and Automation 2 5 1 Basic Tables for Graphic Elements A network s structure is described by its nodes and branches The branches connect two nodes to each other A branch or branch element goes from the starting node to the end node Node elements are connected to the nodes is branch element aa node element gt oS Mw 0 1 MVAr E14 scco onva PSe 0 1 pu AL21 05 MN 0 0 MVAr 273 ZO MVA 50 node or busbar The simple network elements are nodes and busbars They have only one symbol and text All node elements and branch elements are connected to these Network elements are more complex graphics elements They are composed of symbols terminals and text symbol terminal 1 terminal
44. by step how to create process calculate and display the results for an electrical network Simulation Procedure The technical manuals for electrical networks contain detailed descriptions of the various calculation methods for electrical networks and their input data These manuals have two parts e Input data Description of the input data for all simulation procedures e Technical manual for the respective simulation procedure Comprehensive descriptions of the simulation procedure The manuals are titled according to the specific procedure Load Flow Short Circuit etc The technical manuals for pipe networks contain detailed descriptions of the various calculation methods for pipe networks and their input data The following manuals are available Water Gas and Heating Cooling Network Database For detailed information about the network database structure see the Database Description Manual This manual presents the PSS SINCAL data model in detail It explains both the structure and the semantics of the data model and has detailed tables relations with their attributes April 2015 125 128 SIEMENS PSS SINCAL Database Interface and 5 2 PSS SINCAL Architecture 5 3 The following illustration shows the basic PSS SINCAL architecture PSS SINCAL Automation Graphic User Interface Config
45. delta S and cosphi Usrc and delta P and u P and U uterm and delta Uterm and delta OONONIBRWNDY Double Basic Current Source delta Double Voltage Angle S Double Apparent Power cosphi Double Power Factor Zero and Negative Phase Sequence Flag_Z0 Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances April 2015 92 128 SIEMENS PSS SINCAL Database Interface and Automation Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 RO_X0 Double Ratio R X Zero Phase Sequence ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence X22 Double Reactance Negative Phase Sequence R2_X2 Double Ratio R X Negative Phase Sequence Short Circuit Data Flag_Tau Double Current Decay 0 No 1 Yes Decay_Tau Double Decay Time Constant Protection Data Flag_Decay Double State Decay Current 0 No Data 1 la 2 lasym Decay_Uwrk Double Decay Working Voltage Controller Data Unode Controlled Voltage at Controller Node Control Range Data Pmin Double Active Power Lower Limit Pmax Double Active Power Upper Limit Qmin Double Reactive Power Lower Limit Qmax Double Reactive Power Upper Limit
46. different components that use COM functions to communicate see Reference PSS SINCAL Architecture This chapter explains how the calculation methods can be integrated into own applications with the help of COM functions Excerpts of codes and examples are explained with the help of the Windows Scripting Host WSH since this has the simplest syntax and is normally available directly in the current operating systems Any programming language that supports COM functions e g VisualBasic VBA C etc can be used for the automation functions The calculation methods open design can help you solve a variety of different problems Basically however you need to differentiate between integration into external applications and the use in own solutions Integrating the Calculation Methods into External Applications This type of automation is primarily used for integrated solutions in GIS NIS or SCADA systems You start the PSS SINCAL calculations directly from the respective source system All the data maintenance and processing and the visualization of the results is done directly in the source system This automation solution integrates the calculation methods directly into the source system They are connected by COM interface where the calculation methods can be used either as an External Server with separate processes or as an In Process Server within the same process In Process Server External Server Client Application Pr
47. injections with the Extended Ward procedure 0 Do not generate Extended Wards 1 Generate Extended Wards STATNETRED_SC1 Integer Activates the determination of the zero phase sequence data in the reduced network for asymmetrical short circuit calculations 0 Do not determine any zero phase sequence data 1 Determine zero phase sequence data STATNETRED_SC3 Dynamic Network Reduction Parameter Integer Data type Activates the determination of short circuit data in the reduced network 0 Do not determine any short circuit data 1 Determine short circuit data Description DYNNETRED_USESOURCEDB Integer Defines whether the original database is to be changed or the reduced network written to a second database 0 Fill second database with reduced network 1 Carry out change of the original database DYNNETRED_SINFILE Complete file name of the SIN file of the second database e g D Network Red RS sin DYNNETRED_DATABASE Database definition for the second database e g TYP NET MODE JET FILE D Network Red RS_files database mdb USR Admin SINFILE D Network Red RS sin DYNNETRED_CREATEGRAPHIC Integer Activates the graphic generation of the boundary nodes when April 2015 60 128 SIEMENS PSS SINCAL Database Interface and Automation using two separate databases 0 Do not generate a graphic 1 Generate graphic D
48. input data and results of the simulation Set SimulateDatabase SimulateObj DB_EL Set SimulateDatabase SimulateObj DB_ FLOW Properties DB_EL Object Database object for electrical networks DB_FLOW Object Database object for pipe networks Comments This property is read only Example Get the database object Dim SimulateDatabase Set SimulateDatabase SimulateObj DB_ EL If SimulateDatabase Is Nothing Then WScript Echo Error Getting database object failed WS crip Ouait End If Set SimulateDatabase Nothing Messages Access Message Objects Lets you access messages generated by the calculations Set objMessages SimulateObj Messages April 2015 70 128 SIEMENS PSS SINCAL Database Interface and 4 1 2 Automation Properties Messages Object Automation object for the calculation messages Comments This property is read only Example Get message object Dim objMessages Set objMessages SimulateObj Messages Release message object Set objMessages Nothing Calculation Object This object directly accesses internal objects in the calculations that describe the network model This object represents the network element display in the main memory of the calculations The calculation object lets you directly manipulate input data in the calculations For example you can modify values for a load s active and reactive power without loading data from the database The
49. km r 0 1 Ohmvkm x 0 4 Ohm km c 0 0 nF km oir O Li ap V N3 Node Element Name Network Level Load Type Operate State Load Flow Type Load Input Active Power Reactive Power Voltage Factor P Factor Q Manipulation Factor N3 L123 v Phasing LO4 LV 1 0kV Load I Equivalent Load I Out of service Load Profile P and Q constant Load Increase None X X Daily Series Weekly Seres Yearty Seres P Q and u None MW None MVAr None Zero Phase Sequence 2 The consumer is a node element In our example this is attached to the node N3 This node element is described in the database with the following tables nodes busbars Element This is the basic record for the network element Load This table contains the specific attributes of the consumer Terminal This table creates the connection between the network element and the The structure and semantics of the tables are the same as above April 2015 16 128 SIEMENS PSS SINCAL Database Interface and Automation 2 4 1 Complete Example Network The example network presented step by step is now complete N1 N2 1 Sk 1000 0 MVA 272 H idim Lo4 BOP eee r 0 1 Ohm km EA uk 8 0 x 0 4 Ohm km N3 c 0 0 nF km Below the contents of the important tables are displayed briefly to help illustrate the references of the data records once aga
50. mode behavior during problems and errors 0 strict mode abort if there are errors 1 error tolerant import problems and errors are documented April 2015 64 128 SIEMENS PSS SINCAL Database Interface and Automation GRAPHIC_FILENAME_CNT Integer Number of the graphics files GRAPHIC_FILENAME String Complete path and file name for the first graphics file as well as GRAPHIC FILENAME for all subsequent files specifies the file number ranging from a a 2 up to at the very most the number indicated under GRAPHIC_FILENAME_CNT Example Set ShortName as default for object access SimulateObj Parameter Sim Identification ShortName Set Name as default for object access SimulateObj Parameter Sim Identification Name DoCommand Execute Commands Performs a predefined command in the calculations SimulateObj DoCommand strCommand vtParameterl vtParameter2 Parameters strCommand String Predefined sign of the command to be executed Command Description CHANGEVARIANT Change variant DELETERESULTS Deleting all the results in the database vtParameter1 vtParameter2 Variant Additional parameter depending on the command CHANGEVARIANT Change Variant Parameter Data type Description vtParameter1 String or Long Integer Name of the variant or DB ID of the variant vtParameter2 Boolean Change variant of the Include netw
51. not been entered as parameters When you the start the program without parameters PSS SINCAL displays the following information C gt SinDBCreate exe Usage SinDBCreate DBSYS xxx FILE xxx TYPE xxx Create a new SINCAL Database Options SinDBCreate LIST DBSYS xxx ADMIN User Password SRV xxx List all Databases on a server SinDBCreate DELETE DBSYS xxx FILE xxx ADMIN User Password SRV xxx Delete a SINCAL Database on a database server DBSYS ACCESS ORACLE SQLSERVER SQLEXPRESS Database System FILE Database MS Access SQL Server Express ORACLE SQL Server ADMIN User Password USER User Password SRV Instance TYPE E W G H DB NET STD PROT DATA Path and FileName of the MDB File Path and Filename of the MDF Datafile User Password Instance Database Instance Administrator Login for Database Servers Login Information for Database Servers Database Service Name Server Name Network Type E lectro W ater G as H eating Database Type Network Database is default Fills STD DB and Prot DB with default data April 2015 37 128 SIEMENS PSS SINCAL Database Interface and Automation LANG ENG GER Language for database default is ENG SIN Filename Path and filename of the SIN file Create a PSS SINCAL Database The main function of SinDBCreate is to create PSS SINCAL databases All the settings needed for this must be indicated as parameters
52. the connection between the network element and the nodes busbars Use the Element_ID and Node_ID fields for this The two winding transformer is a branch element and thus has two terminals These attach the transformer 2T2 to the busbars N1 and N2 e Terminal 1 Terminal_ID 2 Element_ID 2 Node_ID 1 TerminalNo 1 e Terminal 2 Terminal_ID 3 Element_ID 2 Node_ID 2 TerminalNo 2 Step 6 Create the Line In the next step a line is attached to the 1 0 kV busbar Click Insert Branch Element Line in the menu to create the element in the Graphics Editor April 2015 14 128 SIEMENS PSS SINCAL Database Interface and Basic Data Element Data Start Node End Node Element Name Network Level N2 Standard Type Line Type Wave Resistance Equation Cross Section Length No of Parallel Systems Reduction Factor Resistance Reactance Capacitance Losses to Ground Rated Frequency Rated Voltage Cable Location q p f x c va fn i F X X 0 1 Ohm km 0 4 Ohm km 0 0 nF m 0 0 kWkm 50 0 Hz 10 kV Ground Conductor Material Conductor Type Thermal Limit Curent First Add Limit Current Second Add Limit Current Third Add Limit Current Ref SC Current 1s Temperature at End of SC Zero Phase Sequence Automation Phasing L123 v bunched kA kA kA kA kA a X The line is a branch element just like the two windin
53. 0 Z1 and RO XO 2 RO and X0 RO_X0O Double Ratio R X Zero Phase Sequence ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence Controller Data Flag_Roh Integer Controller State 1 Fix 2 Variable node 3 Variable terminal roh Integer Present Tap Position rohl Integer Minimum Tap Position rohu Integer Maximum Tap Position deltaS Double Additional Reactive Power uul Double Voltage Upper Limit ull Double Voltage Lower Limit Qmin Double Minimum Total Reactive Power Qmax Double Maximum Total Reactive Power CosPhiMin Double Cosinus Phi Minimum CosPhiMax Double Cosinus Phi Maximum Variable Shunt Element VarShuntElement Attribute name Data type Description Flag_LF Integer Load Flow Input 1 Power 2 Impedance 3 Model 4 Mixed power 5 Function Flag_LoadType Integer Load Flow Type 1 Z constant 2 P and Q constant 3 constant Flag_Macro_LF Integer Model Type Load Flow 0 None 1 Controller 2 Equivalent circuit Double Active Power Load Flow Double Reactive Power Load Flow Double Voltage Load Flow Double Resistance Load Flow Double Reactance Load Flow Double Factor Constant Active Power Double Factor Current Dependent Active Power Double Factor Voltage Dependent Active Power
54. D iElementID ReadMaxID strTableElement Element _ID fas at iTerminalID 1 ReadMaxID strTableTerminal Terminal ID iGraphicTextID 1 ReadMaxID strTableGraphicText GraphicText_ID iGraphicNodeID 1 ReadMaxID strTableGraphicNode GraphicNode ID iGraphicElementID 1 ReadMaxID strTableGraphicElement GraphicElement_ID iGraphicTerminalID 1 ReadMaxID strTableGraphicTerminal GraphicTerminal ID Call CloseDatabase End Sub Read out Node Data from the Database ReadNodes amp AddNode ReadNodes reads the node data from the sources database and converts this to PSS SINCAL format When the data are converted they generate the proper SQL command at the same time Sub ReadNodes iMode iMode 1 Normal Mode 0 Only init Dim rsNode If iMode 0 And iCntNode gt 0 then Exit Sub WScript Echo Reading Nodes Call OpenDatabase strIMPORTdb Call OpenRecordset SELECT Name AS ID Name ShortName NodeType NetworkLevel amp FROM Node rsNode If Not rsNode EOF And Not rsNode BOF Then Dim iRet rsNode MoveFirst Dim pt Set pt New Point Do While Not rsNode EOF Names Dim strName strShortName strName CStr rsNode Name strShortName Left rsNode ShortName 8 VoltageLevel NetworkLevel amp NetworkGroup Dim iLevelID iGroupID iLevelID GetVoltageLevel CDb1 rsNode Un iGroupID 1 Type of Node Dim iType iType GetNodeType
55. DE E Import data for Electricity MODE W Import data for Water This program reads data from ImportDB and writes the data into the SincalDB To import data you need a prepared database with import data ImportDB mdb and the appropriate PSS SINCAL network database SincalDB mdb The MODE parameter differentiates between electrical networks and pipe networks Start ImportDB vbs with the correct parameters gt cscript exe ImportDB vbs EleData mdb EleTest mdb E Jigal AIDES ox Reading Nodes Reading Lines Reading Loads Reading Transformers Wenting Datani Node 27 27 Element 48 48 Terminal 82 82 Mines ES 2 92 TwoWindingTransformer 2 2 Load 14 14 GraphicNode 27 27 GraphicTerminal 82 82 GraphicElement 48 48 Successfully finished import to D Network _Import GIS EleTest mdb Inserted 362 records in 0 01 seconds April 2015 29 128 SIEMENS PSS SINCAL Database Interface and Automation 3 1 1 How the Example Program Works The basic sequence of functions in the example program is relatively simple e First common initializations are performed e Then data from the sources database are read out and converted to appropriate data structures e Finally data are written to the PSS SINCAL network database using SQL instructions In the source text this looks as follows Execute the selected option Select Case strParam Case E bElectro True Call InitIDs Call ReadNodes C
56. Double Maximum Flow Flag_Limits Integer Limit Type 0 None 1 Flow QOutputmin Double Minimum Output Flow QOutputmax Double Maximum Output Flow Water Tower FlowWaterTower Attribute name Data type Description hWaterLevel Double Water Level hFillStart1 Double Filling Level 1 Start hFillStop1 Double Filling Level 1 Stop uPump1 Double Pump Characteristics 1 hFillStart2 Double Filling Level 1 Start hFillStop2 Double Filling Level 1 Stop uPump2 Double Pump Characteristics 1 hFillStart3 Double Filling Level 1 Start hFillStop3 Double Filling Level 1 Stop uPump3 Double Pump Characteristics 1 Flag_Level Integer Level Data 0 No 1 Yes Flag_Limits Integer Limit Type 0 None 1 Flow Qmin Double Minimum Flow Qmax Double Maximum Flow Line FlowLine Attribute name Data type Description LineLength Double Length Diameter Double Diameter SandRoughness Double Sand Roughness fLength Double Length Allowance Factor fCurve Double Curve Factor fDiameterAn Double Annual Diameter Reduction fRoughnessAn Double Annual Roughness Increase Zeta Double Zeta Value LeakageRate Double Leakage Rate April 2015 114 128 SIEMENS PSS SINCAL Database Interface and Automation Node FlowNode Attribute name Data type Description Sh Double Elevation Gas Networks Calculation Settings FlowCalc
57. FNodeResult Set LFNodeResult NodeObj Result LFNodeResult 0 If LFNodeResult Is Nothing Then Else Dim u_un ukun LENodeResult Leen Ul Un 5 WScript Echo Node voltage at node U Un amp u un amp 3 Set LFNodeResult Nothing Enea in Database Object This object lets you access the individual database tables Example Database object Dim SimulateDatabase Set SimulateDatabase SimulateObj DB_ EL If SimulateDatabase Is Nothing Then WScript Echo Error Getting database object failed Wis Calo te OIE End If If the instance of the automation object is not used any longer it must be released with the following instruction Release the tabular object Set SimulateDataBase Nothing GetRowObj Determine Instance for a Tabular Object Provides an instance for a tabular object Set TableObj SimulateDatabase GetRowObj strTable April 2015 76 128 SIEMENS PSS SINCAL Database Interface and 4 1 5 Open Automation Parameters strTable String Name of the database table Return Value TableObj Object Automation object of the database table Example Get the load flow node result tabular object Dim LFNodeResult Set LFNodeResult SimulateDatabase GetRowObj LFNodeResult If LFNodeResult Is Nothing Then WScript Echo Error Getting LFNodeResult object failed WSeEripE Omit End If Tabular Object This object contains all the data from a database table The da
58. K Double Reference short circuit voltage for the transformer OPT_VOLTVAR_LIMIT_LOWER Double Voltage lower limit in OPT_VOLTVAR_LIMIT_UPPER Double Voltage upper limit in OPT_VOLTVAR_MINMAX_MODE Integer Specifies the calculation mode 0 factor 1 operating point OPT_VOLTVAR_MIN_FACTOR Double Factor for minimum OPT_VOLTVAR_MAX_FACTOR Double Factor for maximum OPT_VOLTVAR_MIN_OPID Integer Operating point for minimum OPT_VOLTVAR_MAX_OPID Static Network Reduction Parameter Integer Data type Operating point for maximum Description STATNETRED_USESOURCEDB Integer Defines whether the original database is to be changed or the reduced network written to a second database 0 Fill second database with reduced network 1 Carry out change of the original database STATNETRED_SINFILE Complete file name of the SIN file of the second database e g D Network Red RS sin STATNETRED_DATABASE Database definition for the second database e g TYP NET MODE JET FILE D Network Red RS_files database mdb USR Admin SINFILE D Network Red RS sin STATNETRED_CREATEGRAPHIC Integer Activates the graphic generation of the boundary nodes when using two separate databases 0 Do not generate a graphic 1 Generate graphic STATNETRED_EXTWARD Integer Activates the determination of boundary
59. LFAccurResult WS Creda Quit End If Mevye curser te irst row Dim bRead_ next data bRead_next_ data LFAccurResult MoveFirst If bRead_next_data 0 Then Get attribut Iteration Number Dim IterCnt IterCnt LFAccurResult Item IT Get attribute Power Node Balance Dim PNB PNB LFAccurResult Item PNB Get attribute Power Node Balance Dim PNBre PNBre LFAccurResult Item PNBre Get attribute Voltage Mesh Balance Dim VLB VLB LFAccurResult Item VLB Get attribut Voltage Mesh Balance Dim VLBre VLBre LFAccurResult Item VLBre Output to console WScript Echo IT amp IterCnt amp Power Accuracy PNBre amp FormatNumber MOONS y E Us End If Release datbase object LFAccurResult Set LFAccurResult nothing End Sub Write simulation messages Automation PNBre April 2015 45 128 SIEMENS PSS SINCAL Database Interface and Automation Sub WriteMessages ByRef SimulateObj WScript Echo vbCrLf amp Simulation Messages amp vbCrLf Dim objMessages Set objMessages SimulateObj Messages Dim strType Dim intMsgIdx For intMsgIdx 1 To objMessages Count Dim Msg Set Msg objMessages Item intMsgIdx Select Case Msg Type ease 1 STATUS ease 2 INFO case 3 WARNING WScript Echo Msg Text case 4 ERROR WScript Echo Msg Text End Select Set Msg Nothing Next Set objMessages Nothing End Sub Sub Usage Dim strUsage strUsage
60. Mode iMode Parameters iMode Integer Database mode for the calculations The mode is a numerical value from 0 to 2 Description Load from a real database save in a real database Load from a real database save in a virtual database Load from a virtual database save in a virtual database Load from a real in a virtual database save in a virtual database Comments In normal simulation the output data are stored directly in the database The Batchmode function however sends the output data to a virtual database This greatly increases the speed since you do not lose time making entries in the database The results are kept only in the virtual database of the main memory for the calculations Example Enable virtual database SimulateObj BatchMode 1 DataSourceEx Set the Databases Defines the databases used in the calculations SimulateObj DataSourceEx strDBType strDBSystem strDatabase strUser strPassword Parameters strDBType String Predefined sign for the database type Database type Description DEFAULT Network database PROT Global protection device database PROT_USR Local protection device database April 2015 51 128 SIEMENS PSS SINCAL Database Interface and Automation strDBSystem String Predefined sign for the database system Database system Description JET Microsoft Access ORACLE Oracle strDatabase String Co
61. O 72 YNO 73 DO 74 ZNY1 75 ZNY7 76 DDNO 77 DNDO 78 DNYN1 79 DNYN11 80 YNDN1 81 YNDN11 uk_ct Double Ref Short Circuit Voltage Half Winding ur_ct Double SC Voltage Ohmic Part Half Winding Zero Phase Sequence FlagZOInput Integer Zero Data Input 1 Z0 Z1 and RO XO 2 RO and X0 3 RO R1 and X0 X1 4 ZABNL ZBANL and ZABSC Double Ratio Zero Phase to Positive Phase Sequence Impedance Double Ratio Zero Phase to Positive Phase Resistance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence X0_X1 Double Ratio Zero Phase to Positive Phase Reactance RO_X0 Double Ratio R X Zero Phase Sequence ZABNL Double Impedance between A and B in No Load ZBANL Double Impedance between B and A in No Load ZABSC Double Impedance between B and A in Short Circuit Controller Data FlagConNode Integer Controller Node 1 Side 1 2 Side Flag_Roh Integer State Tap Position 1 Fixed 2 Node 3 Impedance 4 Active power 5 Reactive power 6 Control Charact Integer Individual Tap Positions 0 No 1 Yes Double Present Tap Position Double Present Tap Position Winding 1 Double Present Tap Position Winding 2 Double Present Tap Position Winding 3 Double Minimum Tap Position Double Main Tap Position April 2015 103 128 SIEMENS PSS SINCAL Database Interface and Automation
62. Ob j April 2015 43 128 SIEMENS PSS SINCAL Database Interface and Automation Set LoadObj SimulateObj GetObj LOAD CStr strLoad If LoadObj is Nothing Then Wseript keho Errors Load atrloed amp not found WScript Quit Endi TE Getting calculation object node of load Dim NodeID NodeID LoadObj Item TOPO NODE1 DBID Dim LoadNode Set LoadNode SimulateObj GetObj NODE NodeID Getting virtual database object Dim SimulateNetworkDataSource Set SimulateNetworkDataSource SimulateOb DB_ EL If SimulateNetworkDataSource Is Nothing Then WScript Echo Error getting virtual database object failed Wis Citak oie Oat End LE a hae cae el E Ca GM A AE cs yc AE cay aS Sy BEM cist Ay Ty ts FG AS CS cs oR es als SA Ss A cs as a A Perform special voltage drop analysis ee eS eS ee ee ee ee Se ee eS ee eS ee Se ee Se Dim iLoop iLoopErr iLoop 0 iLoopErr 0 WSeript echo VOCrLE amp Start dead lov calculation amp Strir Do While iLoop lt 1000 WNSi realjonesielovey WlolCieline WSS Wis Sine aliiveyojey iW ee Mi We modify the load by adding 0 1 MW in each loop Call Modifyload LoadOb 0 1 Start loadflow simulation SimulateObj Start strLF If SimulateObj StatusID lt gt siSimulationOK Then WScript Echo Load flow failed Exit Do End If Getting load flow result for node If LoadNode Is Nothing Then Else Dim LFNodeResultLoad Set LFNodeResultLoad LoadNod
63. Objects are instantiated from the higher level object to the lower level objects The objects themselves have different methods and functions Simulation Object Calculation Object Message Object Calculation Results Object Message Data Object Database Object Tabular Object Overview of the Available Automation Functions Simulation Object BatchMode Activate virtual database DataSourceEx Set the databases Database Set the databases SQLUser Set the SQL user DataFile Set the data file MacroPath Paths for models Language Set the language Currency Set the currency SetInputState Set the input state LoadDB Load the input data from database SaveDB Save the results to database AddObjID Add Objects Parameter Set and query global parameters DoCommand Execute commands Start Start calculation StatusID Status code of calculation procedure GetObj Access calculation objects GetObjByld GetObjByGUID Access calculation objects using the ID DB_EL DB_FLOW Access database objects Messages Access message objects April 2015 48 128 SIEMENS PSS SINCAL Database Interface and Automation Calculation Object e Count Number of possible attributes e Name Determine attribute names e tem Access attributes e Result Access calculation results object Calculation Results Object e Count Number of possible attributes e Name
64. PK Terminal ID PK Variant_ID Element_ID Node_ID Flag_Variant TerminalNo Flag_State Flag_Terminal Node PK Node ID PK Variant_ID Group_ID BusbarType_ID SwitchBay1_ID SwitchBay2_ID VoltLevel_ID Flag_Variant Flag_Type Name ShortName Un Ik2 Ip Uul UII Uref IncIName y Element Load Line PK Element ID PK Element ID PK Element ID Variant ID PK Variant ID PK Variant ID VoltLevel_ID Flag_Variant Flag_Variant EcoStation_ID Typ_ID Flag_LineTyp EcoField_ID Flag_Load LineTyp Flag_Variant Flag_LoadType Typ_ID Group_ID Flag_Lf Flag_Typ_ID Name P q ShortName Q Type u r Flag_Input Ul x Flag_State S c ci Un Cs cosphi ParSys cm Flag_Vart coo Flag_Mat Ti Flag_Cond Tl va Ts Ith fn lis Flag_Z0O_Input XO_X1 RO_R1 ro x0 co q0 The Node table describes the basic network topology Terminal tables attach node and branch elements to a node and are used to construct the entire network topology At the center of the data model you have the Element table This describes the actual network elements This table is assigned an additional table for the detailed description of the particular network element e Line Element Line e Consumer Element Load e etc April 2015 7 128 SIEMENS PSS SINCAL Database Interface and Automation Input Data Status The data tables for the elements summar
65. Parameter Attribute name Data type Description ITmax Integer Maximum Number of Iterations non linear ITmax2 Integer Maximum Number of Iterations linear MeshAccuracy Double Mesh Accuracy NodeAccuracyG Double Node Accuracy FlowStepG Double Maximum Step for Flow Flag_Operate Integer Check Operating Conditions 0 Warning 1 Error SpecDensity Double Specific Density HeatingAmount Double Heating Amount pAir Double Air Pressure SutherlandConst Double Sutherland Constant AdiabaticExp Double Adiabatic Exponent fConst Double Constant Factor fLinear Double Linear Factor Flag_Result Integer Store Results in Database 0 None 1 All 2 Restricted elements only 3 All elements in case of restrictions StartTime Double Starting Time Duration Double Duration TimeStepGeo Double Time Step Geo stationary Attribute name Data type Description pRated Double Rated Pressure TGas Double Gas Temperature TAir Double Air Temperature vMax Double Maximum Flow Velocity pMin Double Minimum Operating Pressure pMax Double Maximum Operating Pressure April 2015 115 128 SIEMENS PSS SINCAL Database Interface and Automation Network Area FlowNetworkGroup Attribute name Data type Description Flag_MarkedForCaused Integer Marked for Caused Malfunction 0 No 1 Yes Flag_Malfunc Integer Malfunction 0 None 1
66. S SINCAL Database Interface and Automation Const Pressure Decrease Const Flow FlowConstLine Attribute name Data type Description Flag_Typ Integer Line Type 1 Constant pressure drop 2 Constant flow PressureDecr Double Pressure Drop FlowHeating Double Flow Consumer FlowConsumer Attribute name Data type Description Q Double Const Consumption Flag_ConTyp Integer Consumption Type 1 Constant consumption 2 Constant power consumption 3 Sum of consumption and power Q3 Double Constant Consumption Power Q4 Double Constant Consumption Power Double Constant Consumption Power Flag_ConControl Integer Pressure Dependent Consumption Decrease 0 No 1 Yes pDiffMin Double Minimum Pressure Difference Flag_Temp Integer Temperature Type 1 Return temperature 2 Difference of temperature T Double Temperature DesignTemp Double Design Temperature of Consumer Heat Exchanger FlowHeatExchanger Attribute name Data type Description Flag_Typ Integer Heat Exchanger Type 1 Hydraulic uncoupling 2 Power apply Flag_ConControl Integer Primary Pressure Dependent Consumption Decrease 0 No 1 Yes Flag_Temp Integer Temperature Type 1 Return temperature 2 Difference of temperature sup ret 3 Difference of temperature sec prim Flag_Maint Integer Pressure Maintenance Type 1 Medium pressure difference and parts 2 Su
67. SIEMENS PSS SINCAL Database Interface and Automation PSS SINCAL Database Interface and Automation This document describes the organization and the structure of the PSS SINCAL database shows you how to fill the database with external programs and explains the automation functions of the calculation methods 1 General Remarks 2 2 Structure of PSS SINCAL Database 4 2 1 PSS SINCAL Networks 4 2 2 Data Model Design Guidelines 5 2 3 Structure of the Database 7 2 4 Database Analysis with the Help of an Example Network 9 2 5 Tables of Network Graphics 18 2 6 Results in the Database 26 3 Filling in the PSS SINCAL Database 29 3 1 Example Program for Filling the Database 29 3 2 Help Program for Creating PSS SINCAL Database 37 4 Automation of the Calculation Methods 42 4 1 Available Automation Functions 48 4 2 Calculation Objects and their Attributes 85 5 Reference 125 5 1 Documentation 125 5 2 PSS SINCAL Architecture 126 5 3 Ready Made Solutions 126 April 2015 1 128 SIEMENS PSS SINCAL Database Interface and Automation 1 General Remarks One of the most important characteristics of PSS SINCAL is the complete transparency of the data With standard methods you can access input data and calculation results at any time even if you are not using PSS SINCAL This transparency is reached by saving all data in a relational database necessary for the network planning Unlike other network planning systems that you only fill when you
68. Separation results o InstallCompResult Compensation power results e Harmonics and ripple control HarBranchResult Harmonics branch results HarNodeResult Harmonics node results RCBranchResult Branch results ripple control RCNodeResult Node results ripple control O 0O 0 0 RCTransmitterResult Transmitter results ripple control e Reliability o RelResult Reliability node results o RelNetResult Reliability network results o RelGroupResult Reliability group results The basic structure of the result tables is displayed according to load flow results For a detailed description of all available result tables with their attributes see the Database Description Manual LFNodeResult Load Flow Node Results This table contains node results from load flow calculations Node results are assigned by the secondary key Node_ID Attribute name Data type Description Result_ID Long Integer Primary Key Result Node_ ID Long Integer Secondary Key Node Variant_ID Long Integer Secondary Key Variant U Double Node Voltage U_Un Double Node Voltage Rated Node Voltage Double Angle Slack Voltage Double Active Power Double Reactive Power Double Apparent Power Integer Key for Time tdiag Double Time Direct Diagram Connection 22 00 22 3600 Flag_Result Integer Result Type 0 Load flow 1 Load profile 2 Load development ResDate Date
69. SinDBCreate DBSYS xxx FILE xxx TYPE xxx Options Create a new SINCAL Database Required Parameters DBSYS ACCESS ORACLE SQLSERVER SQLEXPRESS Database System FILE Database MS Access Path and FileName of the MDB File SQL Server Express Path and Filename of the MDF Datafile ORACLE User Password Instance SQL Server Database Instance ADMIN User Password Administrator Login for Database Servers USER User Password Login Information for Database Servers SRV Instance Database Service Name Server Name TYPE E W G H Network Type E lectro W ater G as H eating Optional Parameters DB NET STD PROT Database Type Network Database is default E DATAY Fills STD DB and Prot DB with default data LANG ENG GER Language for database default is ENG SIN Filename Path and filename of the SIN file The DBSYS parameter determines which database system is used You can select between ACCESS Microsoft Access ORACLE SQLSERVER SQL Server and SQLEXPRESS SQL Server Express The FILE parameter designates the PSS SINCAL database name Depending on which database system is used this parameter must be entered in different ways In Microsoft Access and SQL Server Express you need the complete path and file name In Oracle you need the user name password and server name in the format User Password Server When you use the SQL Server you need the database name and server name in the format DBName Server
70. VoltageDrop vbs Set load LO8 to P 0 5MW Q 0 4Mvar Node voltage at modified load U Un 92 37 IT 9 Power Accuracy PNBre 0 00kW Set load LO8 to P 0 6MW Q 0 5Mvar Node voltage at modified load U Un 91 75 IT 9 Power Accuracy PNBre 0 00kW Set load LO8 to P 0 7MW Q 0 6Mvar Node voltage at modified load U Un 91 13 IT 10 Power Accuracy PNBre 0 00kW ay ao ay ly 33 Tene es ay a ee Set load LO8 to P 3 8MW Q 3 7Mvar Node voltage at modified load U Un 55 96 IT 10 Power Accuracy PNBre 0 00kW Seat mat ah eats oh 34 feat mat Sah thea Set load LO8 to P 3 9MW Q 3 8Mvar Load flow failed Simulation Messages W 2714 Element data not physically meaningful E 3101 Load flow no convergence break after 200 iterations E 1070 Please have a look at System Manual Technical Reference Messages from Calculations Errors for further error information Now the program executes without errors 34 load flow calculations are performed Before every calculation the load value of L08 increases by 0 1 MW The 33 time around a convergence with a node voltage of 55 96 was still possible The 34 time no convergence is possible This means the maximum load value permitted is P 3 8 MW and Q 3 7 Mvar April 2015 47128 SIEMENS PSS SINCAL Database Interface and 4 1 Available Automation Functions Automation Automation objects in the calculation methods are structured hierarchically
71. YNNETRED_TIMESTART Double Start time in seconds for the correlation functions DYNNETRED_TIMEEND Double End time in seconds for the correlation functions DYNNETRED_LOWERLIMIT Double Lower limit value for the correlation factor DYNNETRED_MACHINES Integer Number of coherent machines to be generated in the reduced network If O is entered the number is determined automatically DYNNETRED_FUNCTION Integer Determines which signal is used for the correlation functions 1 slip 2 load angle 3 active power 4 reactive power 5 voltage It is a good idea to always select Slip as this provides the best results DYNNETRED_REFNODE Integer NodelD of the reference node in the subnetwork to be reduced DYNNETRED_REFVOLTAGE Double Ref voltage for net equivalent in kV DYNNETRED_MAXPOWER Double Max power of equivalent line in MW DYNNETRED_POWERIGNORE Double Power of machines to be ignored in MW DYNNETRED_PREFIX String Any name prefix for reduced elements DYNNETRED_NODEMODELNET Integer Internal display of the nodes in the network reduction 1 PQ Type 2 Type 5 PQ Type neg machines 6 Type neg machines DYNNETRED_NODEMODELMACHINES Integer Internal display of the machines in the network reduction 1 PQ Type 2 Type 3 PV Type DYNNETRED_NODEMODELCOUPLING Integer Internal di
72. all ReadLines Call ReadLoads 1 Call ReadTransformers 1 Case W bElectro False Call ieisakie ics 1 Lo Call ReadFlowNodes 1 Call ReadFlowLines 1 Case Else Call Usage End Select If ErrorCheck Error while reading input data Then WScript Quit Write data from arrays to SINCAL database Call WriteSINCAL If ErrorCheck Error while writing data Then WScript Quit Perform Initializations InitIDs InitIDs determines the initial values for the primary keys The corresponding PSS SINCAL network database tables are opened and the maximum value for the primary key is determined These values are then stored as global variables Sub eine IDS WSerict Feno Init pe e Call OpenDatabase strSINCALdb If bElectro True Then strTableNode Node strTableElement Element strTableTerminal Terminal strTableGraphicText GraphicText strTableGraphicNode GraphicNode strTableGraphicEKlement GraphicKlement strTableGraphicTerminal GraphicTerminal Else strTableNode FlowNode strTableElement FlowElement strTableTerminal FlowTerminal strTableGraphicText FlowGraphicText strTableGraphicNode FlowGraphicNode strTableGraphicElement FlowGraphicElement strTableGraphicTerminal FlowGraphicTerminal End 2f April 2015 30 128 SIEMENS PSS SINCAL Database Interface and Automation iNodeID 1 ReadMaxID strTableNode Node I
73. ame AS ID Name _ fe Wi ING OO r ENa me M0 es Whe IE INS IniloveNiSiovefell ie Hey Ielz Win Seth MONY AS taal MONY AS OWT VON AS rs wiktc ina S amp FROM Line rsLine Records selected in this way are processed in a program loop For each line record it creates the appropriate SQL insert commands Basically the following commands are used iEleID AddElement Line strName strShortName iLevelID iGroupID 3 iState iTermID1 AddTerminal iEleID iInternalID1l 1 7 iTermStatel iTermID2 AddTerminal iEleID iInternalID2 2 7 iTermState2 iRet InsertIntoArray arrLine iCntLine _ Tsbevstouawe abioer mne jaikewneioe IID Ryp IND Isdlevey UENae IND IL ie Se i VY amp Vidi Edad valves 4 DED amp RM amp iStandardType amp _ amp iFlagStandardType amp _ i relis Siinses e H O amp eebilog Pew E WaW amp eee a eee amp rsLine c wou amp ees fone cee amp ee amp it y The network diagram for the line is generated with the following commands iGraEleID AddGraphicElement iE leID 19 Nodel ptPos Node2 ptPos iGraTermID1 AddGraphicTerminal iTermID1 iEleID iGraEleID Nodel ptPos iGraTermID2 AddGraphicTerminal iTermID2 iEleID iGraEleID Node2 ptPos The SQL commands that are generated to create line data look as follows insert into Element Element_ID VoltLevel_ID Group_ID Name ShortName Type Flag Input Flag State Varia
74. ase TY P NET MODE SQLSERVER NAME SQLSRV_ELE1 INSTANCE SQLSRV USR username PWD password SINFILE C Temp Example Ele sin SYSUSR sincal SYSPWD sincal SimulateObj Database NET SQLSERVER SOLSRV SOLSRV_ELE1 username password C Temp Example Ele sinjsincel sincel 7s SQLUser Set the SQL User Defines the user name and the password for the SQL Server SimulateObj SQLUser strUser strPassword Parameters strUser String SQL user name strPassword String SQL password Example Set the SOL user SimulateObj SQLUser User Password DataFile Set the Data File Defines the data file needed by import or export SimulateObj DataFile strDataFile Parameters strDataFile String Complete path and file name of the data file Example Set the datafile for imports or exports SimulateObj DataFile C Test CIM CIMExample xml MacroPath Paths for Models Defines the local and global path from which models are used SimulateObj MacoPath strGlobalPath strLocalPath April 2015 54 128 SIEMENS PSS SINCAL Database Interface and Automation Parameters strGlobalPath String Complete path of the directory where global models are stored strLocalPath String Complete path of the directory where local models are stored Example Set global and local path for models SimulateObj MacroPath C GlobalMacros C LocalMacros Language Set the Language Determines the
75. base system Description JET Microsoft Access ORACLE Oracle SQLSERVER SQL Server SQLEXPRESS SQL Server Express Comments Database connections can either be entered as pairs with field value and or as short forms in the complete sequence Pairs TYP NET MODE JET Short form TYP MODE FILE INSTANCE NAME USR PWD SINFILE SYSUSR SYSPWD Example Depending on the database system different connection codes are used Set database connection string depending on database system ACCESS SimulateObj Database TYP NET MODE JET FILE C Temp Example Ele files database mdb USR Admin PWD SINFILE C Temp Example Ele sin SimulateObj Database NET JET C Temp Example Ele files database mdb Admin C Temp Example ile Sabana ORACLE SimulateObj Database TYP NET MODE ORACLE USR ORA_ELE1 PWD ORA_ELE1 INSTANCE ORA11 SINFILE C Temp Example Ele sin SYSUSR sincal SYSPWD sincal SimulateObj Database NET ORACLE ORA11 ORA_ELE1 ORA_ELE1 C Temp Example Ele sin sincal sincal SOLEXPRES S SimulateObj Database TYP NET MODE SQLEXPRESS FILE C Temp Example Ele files database mdf NAME Example Ele SINFILE C Temp Example Ele sin SimulateObj Database NET SQLEXPRESS C Temp Example Ele files database mdf Example Ele C Temp Example Ele sin April 2015 53 128 SIEMENS PSS SINCAL Database Interface and Automation SQLSERVER SimulateObj Datab
76. crease 0 No 1 Yes Flag_T Integer Temperature Type 1 Supply temperature 2 Difference of temperature Flag_Maint Integer Pressure Maintenance Type 1 Medium pressure difference and parts 2 Supply pressure and difference 3 Return pressure and difference 4 Pump data and parts 5 Supply pressure and pump data 6 Return pressure and pump data Flag_Master Integer Leading Supply 0 No 1 Yes T Double Temperature pDiffMin Double Minimum Pressure Difference uPump Double Characteristic Pump Speed FlowStep Double Maximum Step for Flow pSupply Double Pressure Supply Q Double Constant Supply Volume Power Double Constant Power Supply pMedium Double Medium Pressure pSupRet Double Difference Pressure QOutput Double Output Flow pSupplyMain Double Supply Pressure pReturnMain Double Return Pressure April 2015 122 128 SIEMENS PSS SINCAL Database Interface and Automation SupplyPart Double Part Supply Pressure ReturnPart Double Part Return Pressure Flag_Limits Integer Limit Type 0 None 1 Flow 2 Power Double Minimum Flow Double Maximum Flow Double Minimum Power Double Maximum Power Pressure Buffer FlowPressureBuffer Attribute name Data type Unit Description PMax Double bar Maximum Pressure Pump FlowPump Attribute name Data type Description Flag_Type Integer Pump Type 1
77. dObject AliasName 3 cim IdentifiedObject Description IMPORT_GRAPHIC Integer Import graphics 0 no 1 yes GRAPHIC_MODE Integer Graphics mode 0 schematic 1 geographical GRAPHIC_INDIVIDUAL_TEXT Integer Individual text for network elements and node 1 individual text 0 no individual text GRAPHIC_SCALE_FACTOR Double Scaling factor of the graphics GRAPHIC_SYMBOLSIZE Integer Size of the symbol of the network elements GRAPHIC_OFFSETX Double X offset of the graphics GRAPHIC_OFFSETY PSS E Export Parameter Data type Double Y offset of the graphics Description EXPORT_NAME Integer Export name or short name 0 name 1 short name EXPORT_NAME_KEY Integer Use nodes short names as BUS Number 0 yes 1 no PSSE_VERSION Integer Version number Permissible are 32 and 33 April 2015 63 128 SIEMENS PSS SINCAL Database Interface and PSS E Import Parameter Data type Description Automation FILENAME_CNT Integer Number of the data files FILENAME FILENAME_ String Complete path and file name for the first data file as well as for all subsequent files specifies the file number ranging from 2 up to at the very most the number indicated under FILENAME_CNT PSSE_VERSION Integer Version number Permissible are 29 30 31 32 33 and 0 Auto
78. dance 4 Active power 5 Reactive power Flag_Roh3 Integer State Tap Position Side 3 0 None 1 Fixed 2 Node 3 Impedance 4 Active power 5 Reactive power Double Present Tap Position Side 1 April 2015 105 128 SIEMENS PSS SINCAL Database Interface and Automation roh2 Double Present Tap Position Side 2 roh3 Double Present Tap Position Side 3 rohu1 Double Maximum Tap Position Side 1 rohu2 Double Maximum Tap Position Side 2 rohu3 Double Maximum Tap Position Side 3 rohm1 Double Main Tap Position Side 1 rohm2 Double Main Tap Position Side 2 rohm3 Double Main Tap Position Side 3 rohli Double Minimum Tap Position Side 1 rohl2 Double Minimum Tap Position Side 2 rohl3 Double Minimum Tap Position Side 3 Dynamic Data ResFlux1 Double Residual Flux Phase L1 ResFlux2 Double Residual Flux Phase L2 ResFlux3 Double Residual Flux Phase L3 Line Line Attribute name Data type Description Flag_LineTyp Integer we ne Cable 2 Overhead line 3 Connector FlagMat Integer Line Material 1 Al 2 Cu Len Double km Length Double 1 Number of Parallel Systems Double Ohm km Resistance Double Ohm km Reactance Double nF km Capacitance Double kW km Leakage Losses Ground Fault Double kA Thermal Limit Current Ith1 Double kA First Additional Limit Current Ith2 Double kA Second Addi
79. e April 2015 33 128 SIEMENS PSS SINCAL Database Interface and Automation End If If bIsVaid Then VoltageLevel NetworkLevel amp NetworkGroup Dim iLevelID iGroupID iLevelID Nodel iLevel iGroupID 1 Check if there are multiple line segments in this case we must add new nodes Dim strName strShortName strFullName iNr iCntNr strName CStr rsLine Name strShortName Left rsLine ShortName 8 St rh wilNane CS tr ersitine Node ri sca eceersiia nie NOCe IED A seca i If dctLineSegments Exists strFullName Then iCntNr dctLineSegments Item If Not IsNull rsline Nr Then INE CLAG rshLine Nr Else iNr 0 Dim iInternalID1 iInternalID2 iInternalID1l Nodel iID iInternalID2 Node2 iID Ise al ChonciNie S gt al Ween If iNr 1 Then TempNodeID iNodeID iInternalID2 iTempNodeID ElseIf iNr iCntNr Then iInternalID1l iTempNodeID Ea iTempNodeID 0 Else iInternalID1 iTempNodeID iTempNodeID iNodeID iInternalID2 iTempNodeID End If Else iTempNodeID 0 End LE If iTempNodeID gt 0 Then Dim strTempName strTempName K amp iNodeID iRet AddNode strTempName strTempName iLevelID iGroupID 1 0 0 End If Process standard type mapping Dim iStandardType iFlagStandardType iStandardType 0 iFlagStandardType 0 Map the input status of the element Dim iState iState GetElementState rsLine Status Get Switches Dim iT
80. e iRet InsertIntoArray arrNode iCntNode _ insert into amp strTableNode amp Node ID NetworkLevel ID Group_ID Name S HINOGEED es 7 a amp iVolrievslri amp pw E ee e a WM e gtrNemse WU W i WIN fee flicreiSinvonceiNetaes te WN fe abayjores fy WE amp amp amp amp dir amp dH dsh_ LLS pil wow wow h_ h Sean RA RA N End If AddNode iNodeID iNodeID iNodeID 1 End Function AddNode is actually very simple At each call the parameters generate a SQL string that is entered in the arrNode array The SQL commands that are generated look as follows insert into Node Nod ID 7 Name ShortName Flag Type mer Talay Sii g valves lp2p lp Silo kA TTO AL l l April 2015 32 128 SIEMENS PSS SINCAL Database Interface and Automation insert into GraphicNode 7 7 GraphicType_ ID A NodeStartX NodeStartY NodeEndx NodeEndY SymType FrgndColor BkgndColor PenStyle PenWidth NodeSize Flag r velves tetetete il PSO ALSO 7 50 S e Opole a i insert into GraphictText SEEN E ront rontstyle FontSize TextAlign TextOrient TextColor Visible AdjustAngle Angle Posl Pos2 Flag RowTextNo AngleTermNo te vedios iil wwe yall 3 OO 1 0 0 0 25 0 25 0 0 0 1 l This command show that you do not need to fill in all the table attributes It is sufficient to fill the key attributes highlighted above Basically these are the
81. e Name Server Name The DBSYS parameter determines which database system is used You can select between ORACLE and SQLEXPRESS SQL Server ADMIN is required for Oracle and SQL Server database systems This is needed for the main user managing the PSS SINCAL networks This parameter is defined in the format User Password If this parameter has not been entered the settings are loaded from the PSS SINCAL registry SRV is used to explicitly enter the database server If this parameter has not been entered the server name is loaded from the PSS SINCAL registry Example C gt SinDBCreate LIST DBSYS ORACLE ADMIN SINCAL SINCAL SRV ORA10 The above example lists all available PSS SINCAL databases First of all a connection to the ORACLE instance with the name ORA10 and the user SINCAL is established If the connection is successful the available databases are displayed line by line Delete a PSS SINCAL Database In addition to creating PSS SINCAL databases the SinDBCreate help program can be used to delete a PSS SINCAL database at a database server Switch this function ON with the DELETE parameter SinDBCreate DELETE DBSYS xxx FILE xxx ADMIN User Password SRV xxx Delete a SINCAL Database on a database server Required Parameters DBSYS ORACLE SQLSERVER Database System FILE Database ORACLE Usier SQL Server Database ADMIN User Password Administrator Login for Database Servers SRV Instance Database Serv
82. e Result LFNODERESULT 0 If LFNodeResultLoad Is Nothing Then Else Dim u_un u_un LFNodeResultLoad Item U_Un WScript Echo Node voltage at modified load U Un amp FormatNumber u_un amp ugu Set LFNodeResultLoad Nothing Ena EE End If Display some golbal result information Call OutputLFAccurResult SimulateNetworkDataSource Loop Toop 1 Loop Write calculation messages Call WriteMessages SimulateObj Release used objects Set SimulateNetworkDataSource Nothing Set LoadObj Nothing Set LoadNode Nothing Set SimulateObj Nothing Set SimulateObj Nothing Se ee ee ee ee ee ee ee E Modify load April 2015 44 128 SIEMENS PSS SINCAL Database Interface and Sub ModifyLoad ByRef LoadObj_ ValAdd Modify load by increasing P and 0 DIMER E LeeCo TEn HA y a Wallace loadObj_ Ttem P P Dim Q Q LoadObj_ Item Q ValAdd LoadObj_ Item Q Q WScmilptshchosser load cms tclhoadacas tomer ic PE IMV Ol mes O tt Maret End Sub Sub OutputLFAccurResult ByRef SimulateNetworkDataSource Get datbase object LFAccurResult from virtual database Dim LFAccurResult Set LFAccurResult SimulateNetworkDataSource GetRowObj CStr LFAccurResult If LFAccurResult Is Nothing Then WScript Echo Error cant get objects in LFAccurResult WScript Quit End If Open table LFAccurResult Daim hie hr LFAccurResult Open If hr lt gt 0 Then WScript Echo Error cant open
83. e and display the message type and text Dim Msg Set Msg objMessages Item 1 Select Case Msg Type case 1 STATUS WScript Echo Status amp Msq Text case 2 INFO WSeript Bene Infos Msg Text case 3 WARNING WScript Echo Warning amp Msg Text April 2015 82 128 SIEMENS PSS SINCAL Database Interface and Automation case 4 ERROR WSeript bono Error amp Mag Text End Select Text Message Text Lets you access the text of a calculation message Sierahesces Msg Text Properties Text String Message text Comments This property is read only Example Get the first message and display the message text Dim Msg Set Msg objMessages Item 1 WScript Echo Msg Text Type Message Type Specifies the type of the message iType Msg Type Properties Type Integer Predefined code for the type of message Message type Description Status The calculation methods display status messages while they perform different functions Info Information messages contain general information number of isolated nodes etc Warning Warnings show tolerable errors in the calculations Error Error messages show serious errors in the calculations and indicate that the calculations could not be completed properly Example Get the first message and display the message type Dim Msg Set Msg objMessages Item 1 April 2015 83 128
84. e network element s symbol point to the connection point at the node busbar 2 5 3 Basic Structures GraphicAreaTile Worksheet Settings This table describes the worksheet Basically both the page size and the scale are defined Attribute name Data type Description GraphicArea_ID Long Integer Primary Key Area Tile AreaWiadth Double Page Width AreaHeight Double Page Height VectorX Double Zero Coordinate Placement X VectorY Double Zero Coordinate Placement Y GridWidth Integer Grid Spacing Width GridHeight Integer Grid Spacing Height April 2015 24 128 SIEMENS PSS SINCAL Database Interface and Automation Scale Integer redefined Scale 1 100000000 1 10000000 1000000 100000 10000 1000 100 10 1 Display Unit mm cm 2 m 3 km Inch Feet Yards 7 Miles Flag Long Integer Network Working Mode 1 Geographical 2 Schematic Variant_ID Long Integer Secondary Key Variant ScalePaper Double Scale Paper ScaleReal Double Scale Real Name Text 50 Name of View Tilelndex Text 8 Index of Tile 1 2 1 3 1 si 1 1 1 1 Scale2 Integer P 0 4 5 6 7 8 0 1 4 5 6 In a PSS SINCAL network more than one worksheet can be created Simply create multiple records in this table In all graphics tables the GraphicArea_ID is available as a secondary key This specifies which worksheet the respective graph
85. e number ranging from 2 up to at the very most the number indicated under FILENAME_CNT DATA CIM input file BOUNDARY CIM boundary file CONFIG CIM configuration file CIM_NAME Integer Determines what CIM attribute is used as the name Valid indicators are 0 none 1 cim IdentifiedObject Name 2 cim IdentifiedObject AliasName 3 cim IdentifiedObject Description CIM_SHORTNAME Integer Determines what CIM attribute is used as the short name Valid indicators are 0 none 1 cim IdentifiedObject Name 2 cim IdentifiedObject AliasName 3 cim IdentifiedObject Description CIM_SPLITFILES Integer Export to multiple XML files 0 export to multiple files 1 export to a single file CIM_CREATEZIP Integer Create ZIP archive 0 no 1 yes CIM_MRID String Type of ID used SINCALID ID generated by PSS SINCAL UUID Universal Unique ID GUID Global Unique ID CIM_LFRESULTS Integer Export load flow results 0 do not export any results 1 export load flow results EXPORT_GRAPHIC Integer String Export graphics 0 NONE no graphic export 1 AUTOMATIC automatic graphic export 2 SINCAL simple graphic export 3 EXTENDED extended graphic export CIM_GENERATEDNAMES CIM Import Parameter Integer Data type Export generated names 0 no export 1 also export generated names Descr
86. e speed in the data exchange The advantage is that completely separate processes and storage models are used This means that even serious program errors do not influence any other processes The following starts the calculations as a new process Set SincalSimSrv WScript CreateObject Sincal SimulationSrv If SincalSimSrv Is Nothing Then WSeript Echo Error CreateObject Sincal SincalSimSrv failed Wo Cieil ote umet End If The simulation object is accessed with the COM interface Set SincalSim SincalSimSrv GetSimulation If SincalSim Is Nothing Then WSeript Echo Error GetSimulation failed WS Cellet OUE End If In Process Server In the case of an in process server PSS SINCAL provides the interfaces in a DLL If you instantiate a COM component of an in process server PSS SINCAL loads the appropriate server into the current process In process servers are particularly fast since the functions of the interfaces are accessed within the limits of the process The following instantiates the calculations in the current process as an additional COM component Set SincalSim WScript CreateObject Sincal Simulation Tf SincalSim Is Nothing Then WScript Echo Error CreateObject Sincal Simulation failed WScript Quit Ene TE April 2015 50 128 SIEMENS PSS SINCAL Database Interface and Automation BatchMode Activate Virtual Database Changes the database mode of the calculations SimulateObj Batch
87. ease Pump FlowPumpLine Attribute name Data type Description Flag_Type Integer Pump Type 1 Centrifugal pump 2 Reciprocating pump QOutput Double Output Flow uPump Double Characteristic Pump Speed FlowStep Double Maximum Flow Sliding Valve Non Return Valve FlowValve Attribute name Data type Description Flag_Type Integer Valve Type 1 Sliding valve 2 Non return valve Opening Double Degree of Opening Diameter Double Valve Diameter Pos Integer Valve Position 0 Close 1 Open April 2015 121 128 SIEMENS PSS SINCAL Database Interface and Automation Leakage FlowLeakage Attribute name Data type Description OutputSurface Double Output Surface fFlow Double Flow Number FlowStep Double Maximum Step for Flow Temperature Regulator FlowThermoReg Attribute name Data type Description tMin Double Minimum Temperature tMax Double Maximum Temperature TempAccuracy Double Temperature Accuracy FlowStep Double Maximum Step for Flow Infeeder Heating Cooling FlowlnfeederH Attribute name Data type Description Flag_Typ Integer Infeeder Type 1 Pressure supply 2 Power Supply 3 Pressure maintenance Flag_SupTyp Integer Power Supply Type 1 Constant supply 2 Constant supply power Flag_ConControl Integer Pressure Dependent Supply De
88. er Limit Pmax Double Active Power Upper Limit Qmin Double Reactive Power Lower Limit Qmax Double Reactive Power Upper Limit Umin Double Voltage Lower Limit Umax Double Voltage Upper Limit cosphi_lim Double Limit Power Factor Infeeder Infeeder Attribute name Data type Description Flag_Typ Integer y aes Values an 2 R X and Sk2 Double Resistance Reactance Double Internal Reactance Integer Load Flow Type I and phi PandQ usrc and delta S and cosphi P and u Usrc and delta P and U uterm and delta Uterm and delta OONONIRWNDN Double Basic Current Source Double Active Power Double Reactive Power Double Voltage Double Apparent Power Double Power Factor Ug Double Generator Voltage Zero and Negative Phase Sequence Flag_ZO0 Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances April 2015 95 128 SIEMENS PSS SINCAL Database Interface and Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 Automation Z0_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO_XO Double Ratio R X Zero Phase Sequence RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence Controller Data Unode D
89. er Ripple Control Impedance 0 No 1 Yes Double Resistance at Ripple Control Frequency Double Reactance at Ripple Control Frequency Integer Input Data Zero Phase Sequence System 1 Blocking 2 Z0 identical Z1 3 RO R1 and X0 X1 4 RO and X0 Double Resistance Zero Phase Sequence System Double Reactance Zero Phase Sequence System Double Ratio Zero Phase to Positive Phase Resistance Double Ratio Zero Phase to Positive Phase Reactance Fault Observation ProtOCFault Attribute name Data type Description Node_ ID Long Integer Sets the node Element_ID Long Integer Sets the branch Flag_State Integer Operating State 0 Off 1 On Flag_FaultPhase Integer Faulty Phases L123 None Flag_InterruptPhase Integer nterrupted Phases L123 None N L123N 9 00 OCR OUR OV ONS Oa SOUR ON TT len Double Distance Flag_FaultReturn Integer Fault to Return Conductor 1 Short Circuit 2 Return Circuit 3 Ground Circuit 4 Return and Ground Circuit Flag_FaultGround Integer Fault to Ground 1 Short Circuit 2 Return Circuit 3 Ground Circuit 4 Return and Ground Circuit April 2015 109 128 SIEMENS PSS SINCAL Database Interface and Flag_RefPhase Integer Reference Phase 0 None 1 L1 2 L2 3 L3 Automation Flag_CondFaultOn Integer Conditions Fault On 0 None 1 Default 2 Time 3 Voltage 4 Volta
90. er of available attributes Dam Lent 1Cnt TableObj Count April 2015 79 128 SIEMENS PSS SINCAL Database Interface and Automation Name Determine Attribute Names Returns the name of an attribute strName TableObj Name iAttribute Properties Name String Name of the attribute Parameters iAttribute Long Integer Number of the attribute Example Display the names of all available attributes for the object Diy seer Icons 1Cnt TableObj Count Por At Gr 1p wo akent Dim strName strName TableObj Name iAttr WScript Echo iAttr amp amp strName Next Item Access Attributes Provides access to the individual attributes fields for the current line of data Value TableObj Item lAttribute Value TableObj Item strAttribute Properties Item Variant Value of the attribute Parameters iAttribute Long Integer Numerical index of the attribute strAttribute Long Integer Name of the attribute April 2015 eee SIEMENS PSS SINCAL Database Interface and Automation Example cect Uni teonmehe tables Dim Val yal meleto Treni WU wm 4 1 6 Message Object The message object accesses the messages generated during the calculations Use the simulation object to access the message object The following example shows how to display all the calculation messages with a program loop Example Get messages from simulation Dim objMessages Set objM
91. ermStatel iTermState2 iTermStatel GetSwitchState CStr rsLine Switch1 iTermState2 GetSwitchState CStr rsLine Switch2 Dim iE leID iTermID1 iTermID2 iEleID AddElement Line strName strShortName iLevelID iGroupID iTermID1 AddTerminal iEleID iInternalID1l 1 7 iTermStatel iTermID2 AddTerminal iEleID iInternalID2 2 7 iTermState2 Reti nseri MtEOAr ray arrine enelhine iy Hinger ato oios migwest LD Mys De kles myo TD lg Ee kp Cp Y i Hap Tta valuss W e ainlei amp Wp amp iStandardType amp _ amp iFlagStandardType e aru _ Soeesinine H Linebengtinth G Hp sea E aeina eA fy A i calbiDe Re e HW TSTS SeH te Hg amp rsLine Un amp April 2015 34 128 SIEMENS PSS SINCAL Database Interface and Automation amp rsLine Ith ejaj If Not Nodel IsPosEmpty And Not Node2 IsPosEmpty Then Dim iGraEleID iGraTermID1 iGraTermID2 iGraEleID AddGraphicElement iEleID 19 Nodel ptPos Node2 ptPos iGraTermID1 AddGraphicTerminal iTermID1 iEleID iGraEleID Nodel ptPos iGraTermID2 AddGraphicTerminal iTermID2 iEleID iGraEleID Node2 ptPos End If End Df rsLine MoveNext Loop Set Nodel Nothing Set Node2 Nothing End If Call CloseRecordset rsLine Call CloseDatabase End Sub The following SQL command reads out the line data from the import database Call OpenRecordset SELECT Nodel AS Node ID1 Node2 AS Node ID2 N
92. essages SimulateObj Messages Dim strType Dim intMsgIdx For intMsgIdx 1 To objMessages Count Dim Msg Set Msg objMessages Item intMsgIdx Select Case Msg Type case 1 STATUS case 2 INFO case 3 WARNING WScript Echo Msg Text case 4 ERROR WScript Echo Msg Text End Select Set Msg Nothing Next Release message object if not longer needed Set objMessages Nothing Count Number of Possible Messages Returns the number of the messages Cnt objMessages Count Properties Count Long Integer Number of available messages Comments This property is read only April 2015 81 128 SIEMENS PSS SINCAL Database Interface and Example Get the number of available messages Dim Cnt Cnt objMessages Count WScript Echo Number of Messages amp intMsgCnt Item Access Message Data Object 4 1 7 Provides access to a message data object Set Msg objMessages Item iMsgIndex Properties Item Object Automation object of a message Parameters iMsgIndex Long Integer Automation Numerical index of the message Permitted indices start with 1 and end with the number of messages Comments This property is read only Example Get a message Dim Msg Set Msg objMessages Item 1 Message Data Object This object represents a message used to call up the message text the message type and other data for the message Example Get the first messag
93. essure Decrease Const Flow Pressure Regulator Compressor Heat Exchanger Sliding Valve Non Return Valve SymbolNo Integer Symbol Number Flag Long Integer Flag Variant_ID Long Integer Secondary Key Variant Flag_Variant Integer Element of Current Variant 0 No 1 Yes GraphicArea_ID Long Integer Secondary Key Graphic Area Tile April 2015 21 128 SIEMENS PSS SINCAL Database Interface and Automation The SymbolType field is particularly important here It needs to be properly initialized or the graphic data will not be assigned or they will be assigned incorrectly to network element data in the PSS SINCAL user interface The SymbolDef field is used to enhance the control of the network element symbols For coupling solutions this should be initialized with 1 The secondary key GraphicText_ID1 assigns a graphic text object This means an individual text object will be displayed in the Graphics Editor with its own position and graphics attributes If you wish you can initialize the field with NULL Then PSS SINCAL will display the text with default attributes in the Graphics Editor but the text cannot be edited manually The secondary key GraphicText_ID2 is not implemented at this time and should therefore always be initialized with NULL GraphicTerminal Graphics for Terminals of Network Elements This table describes the graphics attributes for network element terminal
94. export PSS SINCAL uses the database as the central storage medium for all your data Calculation methods are relatively easily to use for individual solutions because of their open architecture Normally you use an existing PSS SINCAL network that you analyze with a tool you have created The tool can take advantage of all the functions of the PSS SINCAL calculation methods You can use any programming or script language you want for your individual solution The only prerequisite is that you must be able to access COM functions If you use a relational database you can even couple to a Geographic Information System GIS a Network Information System NIS or a network management system Basically you distinguish between a pure calculation solution and one that exports all the data to PSS SINCAL Which solution you choose depends on what you want to achieve Pure Calculation Solution The pure calculation solution is also known as the engine solution Coupling frequently needed for basic calculation methods such as for example load flow and short circuit are implemented Most of the calculations can be started and used from the source system In this case maintaining data presenting and displaying results and coloring are all done in the source system In this solution only the technical data from the source system are exported to the PSS SINCAL Finally automation is used to start the desired PSS SINCAL calculation method The calcu
95. feeder Element_ID Typ_ID Flag Typ_ID Flag_Typ Sk2 cact R Xx 1 0 0 2 1000 0 1 0 0 0 0 0 The specific data for network supply are stored in the Infeeder table The secondary key Element_ID creates the connection to the table Element Element_ID 1 Terminal Terminal_ID Element_ID Node_ID TerminalNo Flag State Flag_Variant Variant_ID 1 1 1 1 1 1 1 The Terminal table connects the network element to the nodes busbars Use the Element_ID and Node _ID fields for this In our example the infeeder l1 is attached to the busbar N1 Element_ID 1 Node_ID 1 The TerminalNo field is a counter for the connection number In network supply node element this is always 1 since this element only has one terminal Step 5 Attach the Two Winding Transformer Now a two winding transformer is created between both busbars Click Insert Branch Element Two Winding Transformer in the menu to create the element in the Graphics Editor Two Winding Transformer Basic Data Element Data Controller Start Node lal Winding W123 x End Node gt tal Element Name Network Level a Generator Unit T Out of service Standard Type zi x Zero Phase Sequence Rated Voltage Side 1 Un1 Rated Voltage Side 2 Un2 Rated Apparent Power Sn Full Load Power Smax First Add Load Power Smax1 Second Add Load Power Smax2 Third Add Load Power Smax3 Ref Short Circuit Voltage uk SC Voltage Ohmic Part ur Iron Losses Vie N
96. g transformer This means this is attached to two nodes busbars In our example these are the busbar N2 and the node N3 This branch element is described in the database with the following tables e Element This is the basic record for the network element e Line This table contains the specific attributes for the line e Terminal This table creates the connection between the network element and the nodes busbars The structure and semantics of the tables are the same as above For this reason the tables are only displayed briefly here So these are easier to recognize the new records are colored Element Element_ID VoltLevel_ID Group_ID Name Type Flag_Input Flag_Variant Variant_ID 1 2 1 gii Infeeder 3 1 1 2 2 1 22 TwoWinding 3 1 1 Transformer 3 1 1 pies Line 3 1 1 Line Element_ID Typ_ID Flag Typ ID q l ParSys Flag_Vart 3 0 0 0 0 1 0 1 1 Terminal Terminal_ID Element_ID Node_ID TerminalNo Flag_State Flag_Variant Variant_ID 1 1 1 1 1 1 2 2 1 1 1 1 April 2015 15 128 SIEMENS PSS SINCAL Database Interface and 2 2 2 1 2 Node Node_ID Group_ID VoltLevelID Name 1 1 2 Ni 2 1 1 N2 3 1 1 N3 Step 7 Attach the Consumer Automation 1 1 1 1 1 1 1 1 1 Un Flag Variant Variant_ID 10 0 1 1 1 0 1 1 1 0 1 1 With attaching a consumer creating the example network is finished Click Insert Node Element Load in the menu to create the element in the Graphics Editor Basic Data Element Data L3 l 1 0
97. ge Ohmic Part Flag_LF Integer oad Flow Type I and phi PandQ usrc and delta S and cosphi P and u Usrc and delta P and U uterm and delta Uterm and delta ODNOnNRWN ALT Double Phase Angle Double Basic Current Source Double Active Power Double Reactive Power Double Apparent Power cosphi Double Power Factor u Double Generator Voltage Percentage Zero and Negative Phase Sequence Flag_Z0 Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 RO_X0 Double Ratio R X Zero Phase Sequence ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO Double Resistance Zero Phase Sequence April 2015 94 128 SIEMENS PSS SINCAL Database Interface and Automation XO Double Reactance Zero Phase Sequence X22 Double Saturated Reactance Negative Phase Sequence R2_X2 Double Ratio R X Negative Phase Sequence Controller Data Flag_Roh Integer State Tap Position 1 Fixed 2 Variable roh Double Present Tap Position rohl Double Minimum Tap Position rohu Double Maximum Tap Position alpha Double Surplus Voltage Angle Unode Double Controlled Voltage at Controller Node Control Range Data Pmin Double Active Power Low
98. ge and time delay ton Double Time On On_NodelD Long Integer On Node Flag_PhaseOn Integer On Phase 1 L1 2 L2 3 L3 Flag_Val Integer On Value 1 Minimum 2 Maximum 3 User defined Uon Double On Voltage dT1 Double On Time Delay Next Phase dT2 Double On Time Delay Previous Phase Flag_CondFaultOff Integer Conditions Fault Off 0 None 1 Default 2 Time 3 Current 4 Current and time delay toff Double Time Off Protection Location ProtLocation Current Attribute name Double Data type Off Current Description Flag_State Integer Active 0 Off 1 On April 2015 110 128 SIEMENS PSS SINCAL Database Interface and 4 2 4 Attributes of Calculation Objects for Pipe Networks Water Networks Calculation Settings FlowCalcParameter Attribute name Data type Description Automation ITmax Integer Maximum Number of Iterations non linear ITmax2 Integer Maximum Number of Iterations linear MeshAccuracy Double Mesh Accuracy NodeAccuracy Double Node Accuracy FlowStep Double Maximum Step for Flow Flag_Operate Integer Check Operating Conditions 0 Warning 1 Error fCharCurve Double Characteristic Curve Factor SpecDensity Double Specific Density KinematicVis Double Kinemat
99. graphical Page Size A3 297mm x 420mm X C Portrait Landscape lt i sees For the example network the Schematic type of drawing has been selected and the page format set to A3 Landscape Step 2 Create Network Levels In PSS SINCAL the network elements need to be assigned to a network level The network level is used to specify globally valid data for network elements e g rated voltage in electrical networks As a default when you generate a new network PSS SINCAL automatically creates a network level This is filled with standard values and can be customized Select Insert Network Level in the menu Network Level Short Name Un kv Short Circuit Insert LV 1 0kV 1 000 Yes i mr Edit Select For the example network the following network levels are created LV 1kV HV 10kV Once the network levels have been created the VoltageLevel table contains the following values VoltageLevel VoltLevel_ID Name ShortName Un Uop c cmax Flag_Variant Variant_ID 1 LV 1 0 kV 1 0 EOD mr 1 1 1 1 2 HV 10 0 kV 10 0 10 0 1 1 1 1 1 1 Step 3 Create Busbars Now the nodes or busbars can be created To do so click Insert Node Busbar Busbar in the menu Finally both the busbars N1 and N2 are created in the Graphics Editor April 2015 10 128 SIEMENS PSS SINCAL Database Interface and Automation Basic Data Additional Data Name N2
100. hase Sequence Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and RO XO 2 RO and X0 RO_X0 Double Ratio R X Zero Phase Sequence ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence Dynamic Data Flag_Macro_SC Integer Impedances for Dynamics 1 Load flow 2 Short circuit Harmonics Flag_Har Integer State Harmonics 0 No frequency dependency 1 Quality R constant 2 Quality X R constant 3 Impedance characteristic Double Quality R Constant Double Quality X R Constant Serial Reactor SerialReactor Attribute name Data type Description Flag_Colnput Integer Input Data 1 Reference coil voltage 2 Inductance uD Double Reference Coil Voltage L Double Inductance Un Double Rated Voltage Double Rated Current April 2015 107 128 SIEMENS PSS SINCAL Database Interface and Automation Ith1 Double First Additional Limit Current Ith2 Double Second Additional Limit Current Ith3 Double Third Additional Limit Current Zero Phase Sequence R_X Double Ratio R X Positive Phase Sequence Flag_ZOInput Integer Zero Phase Sequence Input Data 1 RO R1 and X0 X1 2 RO and X0 3 RO and LO Double Ratio Zero Phase to Positive Phase Reactance Double Ratio Zero Phase to Positi
101. hing CountRows Determine the Number of Records Provides the number of the records in a tabular object 1Cnt TableObj CountRows Properties CountRows Long Integer Number of the records in a tabular object Example Open a database table and determine the count of records in it Dim hr hr TableObj Open TE hr lt gt 10 Then WScript Echo RecordCount amp TableObj CountRows End If April 2015 78 128 SIEMENS PSS SINCAL Database Interface and Automation MoveFirst MoveLast MoveNext MovePrev Position in the Data Positions the data cursor inside the data hr TableObj MoveFirst hr TableObj MoveNext hr TableObj MoveLast hr TableObj MovePrev Return Value hr HRESULT Status code of the command Comments MoveFirst positions the data cursor at the beginning of the table MoveLast positions it at the last record in a table MoveNext and MovePrev move the data cursor to the next or previous record Example Move to the first record and start reading Dim hr hr LFNodeResult MoveFirst Do While hr 0 Your own code is here Move to next records hr LFNodeResult MoveNext Loop Count Number of Possible Attributes Returns the number of the attributes for the tabular object 1Cnt TableObj Count Return Value ICnt Long Integer Number of possible attributes Comments This property is read only Example Get the numb
102. ic Viscosity Flag_Pump Integer Parallel Pumps 0 No 1 Yes Flag_Result Integer Store Results in Database 0 None 1 All 2 Restricted elements only 3 All elements in case of restrictions StartTime Double Starting Time Duration Double Duration Network Level FlowVoltageLevel TimeStepGeo Attribute name Double Data type Time Step Geo stationary Description pRated Double Rated Pressure vMax Double Maximum Flow Velocity pMin Double Minimum Operating Pressure Network Area FlowNetworkGroup pMax Attribute name Double Data type Maximum Operating Pressure Description Flag_MarkedForCaused Integer Marked for Caused Malfunction 0 No 1 Yes Flag_Malfunc Integer Malfunction 0 None 1 All elements 2 All lines 3 All restricted elements 4 All restricted lines Speed_BaseLimit Double Base Speed Limit April 2015 111 128 SIEMENS PSS SINCAL Database Interface and Automation Flag_CausedMalfunc Integer Caused Malfunction 0 None 1 Marked areas 2 Own area Flag_CausedElem Integer Caused Elements 1 Restricted elements 2 Restricted lines Speed_CausedLimit Double Caused Speed Limit Flag_Report Integer Reporting 0 None 1 Elements and nodes 2 Lines and nodes 3 Elements 4 Lines 5 Nodes Flag_FireWater Integer Join Fi
103. ic is assigned to GraphicLayer Graphic Layer This table specifies a graphic layer All screen elements are assigned to a graphic layer The graphic layer lets you control which network elements are displayed on the screen Attribute name Data type Description GraphicLayer_ID Long Integer Primary Key Layer Name Text 50 Layer Name Visible Integer Visible 0 Not visible 1 Visible on screen 2 Visible on print 3 Visible on screen and print Locked Integer Locked for Working 0 No 1 Yes Type Integer Plot Header 0 No 1 Yes Flag Long Integer Order Flag Variant_ID Long Integer Secondary Key Variant Flag_Variant Integer Element of Current Variant 0 No 1 Yes VisibleZF Integer Visible at Zoom Factor GraphicArea_ID Long Integer Secondary Key Graphic Area Tile April 2015 25 128 SIEMENS PSS SINCAL Database Interface and Automation GraphicObjectType Object Type An object type is assigned to all graphic network elements This object type can help control the legend scope in the network diagram Attribute name Data type Description GraphicType_ID Long Integer Primary Key Object Type ParentType_ID Long Integer Secondary Key Higher Level Object Type Name Text 50 Object Type Name Visible Integer Visible Object Type 0 No 1 Yes Locked Integer Locked Object Type Type Integer Object Type Flag Long Integer Flag not in use Varia
104. ice Name Server Name The DBSYS parameter determines which database system is used You can select between ACCESS Microsoft Access ORACLE SQLSERVER SQL Server and SQLEXPRESS SQL Server Express The FILE parameter designates the PSS SINCAL database name Depending on which database system is used this parameter must be entered in different ways When using Oracle enter the user name When using the SQL Server enter the database name April 2015 40 128 SIEMENS PSS SINCAL Database Interface and Automation ADMIN is required for Oracle and SQL Server database systems This is needed for the main user managing the PSS SINCAL networks This parameter is defined in the format User Password If this parameter has not been entered the settings are loaded from the PSS SINCAL registry SRV is used to explicitly enter the database server If this parameter has not been entered the server name is loaded from the PSS SINCAL registry Example C gt SinDBCreate DELETE DBSYS ORACLE FILE SINCAL TEST ADMIN SINCAL SINCAL SRV ORA10 The above example deletes the PSS SINCAL SINCAL_TEST database First of all a connection to the ORACLE instance with the name ORA10 and the user SINCAL is established Deleting the PSS SINCAL database cannot be undone April 2015 41 128 SIEMENS PSS SINCAL Database Interface and Automation 4 Automation of the Calculation Methods The PSS SINCAL architecture is based on a system of
105. in To make them easier to recognize network element records are colored according to their allocation e Infeeder l1 e Two Winding Transformer 2T2 e Line L3 e Consumer LO4 VoltageLevel VoltLevelID Name ShortName Un Uop c cmax Flag_Variant Variant_ID 1 LV 1 0 kV TOE A fale 1 1 1 1 2 HV 10 0 kV 10 0 10 0 1 1 1 1 1 1 Node Node_ID Group_ID VoltLevelID Name Un Flag_Variant Variant_ID 1 1 2 Ni 10 0 1 1 1 1 N2 1 0 1 1 1 1 N3 1 0 1 1 Element Element_ID VoltLevel_ID Group_ID Name Type Flag_Input Flag_Variant Variant_ID 1 2 le ail Infeeder 3 1 1 2 2 1 22 TwoWinding 3 1 1 Transformer 1 fle es Line 3 1 1 1 1 LO4 Load 1 1 Terminal Terminal_ID Element_ID Node_ID TerminalNo Flag State Flag_Variant Variant_ID 1 1 1 1 1 1 1 April 2015 LAS SIEMENS PSS SINCAL Database Interface and Automation 2 2 1 1 1 1 1 3 2 2 2 1 1 1 4 3 2 1 1 1 1 5 3 3 2 1 1 1 6 4 3 1 1 1 1 Infeeder Element_ID Typ ID Flag_Typ_ID Flag_Typ Sk2 cact R X 1 0 0 2 1000 0 1 0 0 0 0 0 TwoWindingTransformer Element_ID Typ_ID Flag_Typ_ID Uni Un2 Sn uk 2 0 On R1005 FOF E0633 ES 0 Line Element_ID Typ_ID Flag Typ ID q l ParSys Flag_Vart 3 0 OF 00l EO 1 1 Load Element_ID Flag_Load Flag _LoadType P Q u UI 4 0 OU 10 07 0037 100059 FOO 2 5 Tables of Network Graphics The graphics tables describe the network graphic display This information is however only needed for visualization and processing in the user interface The graphics tables
106. iption FILENAME_CNT Integer Number of file names to be imported FILENAME FILENAME_ H String Complete path and file name for the first file as well as the subsequent files specifies the file number ranging from 2 up to at the very most the number indicated under April 2015 62 128 SIEMENS PSS SINCAL Database Interface and Automation FILENAME_CNT FILENAME_FLAG FILENAME_FLAG_ File type for the first data file as well as the subsequent files specifies the file number ranging from 2 up to at the very most the number indicated under FILENAME_CNT DATA CIM input file BOUNDARY CIM boundary file CONFIG CIM configuration file CIM_FORMAT CIM version CIM_V10 CIM_V11 CIM_V12 CIM_V14 CIM_V15 CIM_PROFILE CIM profile CIM_STANDARD CIM Standard CIM_PLANNING CIM for Planning CIM_ENTSOE CIM for ENTSO E BASE_FREQUENCY Double Basic frequency LENGTH_FACTOR Double Conversion factor for entries for length CIM_NAME Integer Determines what CIM attribute is used as the name Valid indicators are 0 none 1 cim IdentifiedObject Name 2 cim IdentifiedObject AliasName 3 cim IdentifiedObject Description CIM_SHORTNAME Integer Determines what CIM attribute is used as the short name Valid indicators are 0 none 1 cim IdentifiedObject Name 2 cim Identifie
107. ize the data for different calculation methods to keep the data model from becoming too complex The data table for the Line for example contains the data for the load flow calculations short circuit calculations harmonic calculations etc All network element attributes are separated into categories This means that although data supply summary information in a shared table data can be selected for a specific calculation method or the present status of the data can be seen The table Element tables have a Flag_Input attribute that stores the current status of the data input for each category Flags show what data have or have not been entered Flags for different categories can be created with the help of the bit wise OR operator Electrical Networks e Bit 0 Short circuit data e Bit 1 Load flow data e Bit 2 Zero phase sequence data e Bit 3 Negative phase sequence data e Bit 4 Harmonics data e Bit 5 Dynamics data e Bit 6 Protection data e Bit 7 Regulator data e Bit 8 Reliability data e Bit 9 Supplementary data e Bit 10 Measurement data e Bit 11 Motor start up data e Bit 12 Transformer regulator data e Bit 13 Distance protection data e Bit 14 Generator unit data e Bit 15 Transformer unit data e Bit 16 Direct feeder data for generator e Bit 17 Equivalent element data e Bit 39 Dynamic data Pipe Networks e Bit 24 Flow data e Bit 25 Water data e Bit 26 Gas data e Bit 27 Heating C
108. language for the calculations and calculation messages SimulateObj Language strLlanguage Parameters strLanguage String Predefined code for the language to be set Description Output language German Output language English Example Select language for messages SimulateObj Language DE Currency Set the Currency Determines the currency sign for the calculations and the calculation results SimulateObj Currency strCurrency Parameters strCurrency String Currency sign to be set Example Set currency SimulateObj Currency EUR April 2015 29 128 SIEMENS PSS SINCAL Database Interface and Simula teb Currency er SetinputState Set the Input State Sets the input status for the data considered in the calculations SimulateObj SetInputState lInputMask Parameters lInoutMask Long Integer Bitwise form with predefined codes for input states Code Description Electrical networks 0x00000001 Load Flow 0x00000002 Short Circuit 0x00000004 Harmonics 0x00000008 Motor Start Up 0x00000010 Low Voltage Dimensioning 0x00000020 Multiple Faults 0x00000040 Protection 0x00000080 Distance Protection 0x00000100 Optimization 0x00000200 Dynamics 0x00000400 Unbalanced Load Flow 0x00000800 Reliability 0x00001000 Economic Efficiency 0x00002000 Load Assignment
109. lateOb SaveDB LF_NR AddObjID Add Objects Defines objects for the calculation method for further special editing The kind of editing depends on the respective calculation method as well as the control setting SimulateObj AddObjID lRowType 1DBID eMode Parameters IRowType Long Integer Database type of the object IDBID Long Integer Database ID of the object April 2015 aries SIEMENS PSS SINCAL Database Interface and eMode Enum Automation Predefined code for using objects in the calculations Enumeration 9 a Description ADDOBJ_LF_NONE ADDOBJ_LF_MALF Contingency Analysis ADDOBJ_OBJ_SC Short Circuit at Object ADDOBJ_OBJ_EXP Netomac Export Determining Machines ADDOBJ_OBJ_MOT_SIMPLE Simple Motor Start Up ADDOBJ_LF_ALLOC Load Allocation ADDOBJ_LF_RESUP Restoration of Supply ADDOBJ_FLOW_H20_ MALF Contingency Analysis Water ADDOBJ_FLOW_GAS_ MALF ONO a R wO mM o Contingency Analysis Gas ADDOBJ_FLOW_HEAT_MALF Contingency Analysis Heating Cooling ADDOBJ_OPT_CAP Capacitor Placement ADDOBJ_GEN_PV PV Curves ADDOBJ_FLOW_H20_ LEAK Fire Water ADDOBJ_LF_MALF_RECON Contingency Analysis Reconnection ADDOBJ_OPT_NET Optimal Network Structure ADDOBJ_ECO Economic Efficiency ADDOBJ_NETRED_INCLUDE Not currently used ADDOBJ_NETRED_EXCLUDE Elements not t
110. lation results are displayed in the source system Data Export to PSS SINCAL The data from the source system are exported to the PSS SINCAL database Normally both the technical data for the equipment and the graphic location data are exported This solution uses PSS SINCAL to plan and evaluate networks The complete range of functions of the product can be used The following illustration shows Mettenmeier GmbH s coupling solution see Reference Ready Made Solutions This is a connection to Smallworld GIS The illustration shows the same network area in the GIS and in PSS SINCAL April 2015 2 128 SIEMENS PSS SINCAL Database Interface and Automation Z Demo SWAF Applikation und Zusatzprodukte Datei Bearbeiten Ansicht Hilfslinienzug Werkzeuge Fenster Hilfe Tete e I MRE IAAP AA A O faerie OE h 3 QL Bf _ Gccamnucbocicht BB Dokan 1 sie S x Ow TPA a cmp SI Projektsteuerung TETEA Obiektklassen Ector F4 Le a Geramtuebericht v M 6 za amp 2 th Oh Ge tS PSS SINCAL V5 2 20050ct test Elektro ix x 29 J Datei Bearbeiten Ansicht Einf gen Berechnen Tools Format Extras Objekte Fenster 2 3 S OSM MRS 9 MHD GOS fe a a A l E seas zl gt Sang Ri O MOlI97 FOF OCs eve R H 0l eO HD gt eS OF by NS j z BasisNetzbereich Jal RA ARMM en Haa aH AA es 090707 fi
111. mpedance Integer Determine Impedance 1 Vmax 2 Imax FlagZO Integer Zero Sequence Data 0 Not grounded 1 Fixed grounded Two Winding Transformer TwoWindingTransformer Attribute name Data type Description Un1 Double Rated Voltage Side 1 Un2 Double Rated Voltage Side 2 Sn Double Rated Apparent Power Smax Double Full Load Power Smax1 Double First Additional Full Load Power Smax2 Double Second Additional Full Load Power April 2015 102 128 SIEMENS PSS SINCAL Database Interface and Automation Double Third Additional Full Load Power Double Reference Short Circuit Voltage Double Short Circuit Voltage Ohmic Part Double Iron Losses Double No Load Current Integer Vector Group 1 DDO 2 DZO 3 DZNO 4 YNYO 5 YNYNO 6 YYO 7 YYNO 8 ZDO 9 ZNDO 10 DYN1 11 DZ1 12 DZN1 13 YD1 14 YND1 15 YNZN1 16 YZ1 17 YZN1 18 ZD1 19 ZND1 20 ZNYN1 21 ZY1 22 ZYN1 23 DY5 24 DYN5 25 YD5 26 YND5 27 YNZ5 28 YNZN5 29 YZ5 30 YZN5 31 ZNY5 32 ZNYN5 33 ZY5 34 ZYN5 35 DD6 36 DZ6 37 DZN6 38 YNY6 39 YNYN6 40 YY6 41 YYN6 42 ZD6 43 ZND6 44 DY7 45 DYN7 46 DZ7 47 DZN7 48 YD7 49 YND7 50 YNZN7 51 YZ7 52 YZN7 53 ZD7 54 ZND7 55 ZNYN7 56 ZY7 57 ZYN7 58 DY11 59 DYN11 60 YD11 61 YND11 62 YNZ11 63 YNZN11 64 YZ11 65 YZN11 66 ZNY11 67 ZNYN11 68 ZY11 69 ZYN11 70 DY1 71 Y
112. mplete path and file name of the database strUser String User name for the database strPassword String Password for the database Comments This function is obsolete and no longer recommended for use It is only included for reasons of compatibility and should be replaced by the Database Set the Databases function Example Set database filename and path SimulateObj DataSourceEx DEFAULT JET strDatabase Admin SimulateOb DataSourceEx PROT JET strProtDatabase Admin Database Set the Databases Defines the databases used in the calculations SimulateObj Database strConnection Parameters strConnection String Database connection Code Description TYP Database type MODE Database system INSTANCE Database server NAME Database name USR User name PWD Password SYSUSR PSS SINCAL administration user SYSPWD Password of the PSS SINCAL administration user FILE File name of database SINFILE File name of PSS SINCAL file April 2015 924128 SIEMENS PSS SINCAL Database Interface and Automation The TYP code can have the following values Database type Description NET Network database PROT Global protection device database PROT_USR Local protection device database STD Global standard database STD_USR Local standard database The MODE code can have the following values Data
113. mport DVG_EXP DVG Export Example Stert Load flow simulation SimulateObj Start LF _NR If SimulateObj StatusID 1101 Then WScript Echo Simulation finished without errors Else WSceript Echo Error load flow failed Exit Do End If StatusID Status Code of Calculation Procedure Queries the status of the calculation procedure 1Status SimulateObj StatusID Properties StatusID Long Integer Status code for the calculation procedure 1101 indicates that the calculations were error free Example Check if the simulation was finished without any errors If Not SimulateObj StatusID 1101 Then WSeript Bcho Error Simulation tailed End If GetObj Access Calculation Objects Returns an instance for a calculation object that lets you directly access internal objects created in the calculations Set LoadObj Set LoadObj SimulateObj GetObj strObjectType strName SimulateObj GetObj strObjectType 1DBID April 2015 68 128 SIEMENS PSS SINCAL Database Interface and Automation Parameters strObjectType String Object type of the network element This is the name of the database table where the element data are stored IDBID String Database ID of the network element strName String Name of the network element A global parameter can be assigned to use the name or the short name for identification Return Value Object Object Automatio
114. n object of a network element created in the calculations Example Get SimulationObject of type LOAD with name LO8 Dim LoadObj Set LoadObj SimulateObj GetObj LOAD CStr LO8 If LoadObj is Nothing Then WSerict 2cho Berory losd not Found WScript Quit End If GetObjByld GetObjByGUID Access Calculation Objects Using the ID Returns an instance for a calculation object that lets you directly access internal objects created in the calculations Set SimObj SimulateObj GetObjByID 1ID Set SimObj SimulateObj GetObjByGUID strGUID Parameters IID Long Integer Internal number of the calculation object See the topology data of the calculation objects for this Internal ID strGUID String Master Resource of the calculation object Return Value SimObj Object Automation object of a network element created in the calculations April 2015 69 128 SIEMENS PSS SINCAL Database Interface and Automation Example Get SimulationObject with internal ID 8 Dim SimObj Set SimObj SimulateObj GetObjByID 8 If SimObj Is Nothing Then WSGriet 2eno Beror Object not Eound WScript Quit Ene LE Get SimulationObject with Master Resource ID Dim SimObj Set SimObj SimulateObj GetObjByGUID 289DAFC1 8541 4abb AE9F 1C47E6A2D32B If SimObj Is Nothing Then WScript Echo Error Object not found WScript Quit End LE DB_EL DB_FLOW Access Database Objects Lets you access the
115. nt Integer Text Orientation TextColor Long Integer Text Color Visible Integer Visible 0 No 1 Yes AdjustAngle Integer Adjust Text Angle 0 None 1 Horizontal or vertical 2 Direction of element Text Angle April 2015 23 128 SIEMENS PSS SINCAL Database Interface and Automation Pos1 Double Distance X Direction Pos2 Double Distance Y Direction Flag Long Integer Flag RowTextNo Integer Number of Rows AngleTermNo Integer Partial Terminal Align Number Variant_ID Long Integer Secondary Key Variant Flag_Variant Integer Element of Current Variant 0 No 1 Yes Caution A text object may only be used once You cannot use the same text object for different elements GraphicBucklePoint Bends for Terminals This table specifies bends for network element terminals Attribute name Data type Description GraphicPoint_ID Long Integer Primary Key Buckle Point GraphicTerminal_ID Long Integer Secondary Key Graphic Terminal NoPoint Integer Buckle Point Number PosX Double Buckle Point X Coordinate PosY Double Buckle Point Y Coordinate Variant_ID Long Integer Secondary Key Variant Flag_Variant Integer Element of Current Variant 0 No 1 Yes The fields PosX and Posy define the graphic position of the bend The NoPoint field determines the sequence of the bends The bends are numbered sequentially from th
116. nt _ID Flag Variant velues 171 07 60 bine 2 0 1 9 April 2015 35 128 SIEMENS PSS SINCAL Database Interface and Automation dineieyee dme kaost Biewemt D Wyo LD bileg Wye D Il p xa Cy Uia Mtii valvss 1 0 0 22 924124593 0 05 0 21 0 10 0 3 gt insert into Terminal Terminal_ID Element_ID Node_ID TerminalNo Flag Terminal Flag State Weuriewit Dy Miles Weilewmii vallues lpilpApils To ik ik il insert into Terminal Terminal_ID Element_ID Node_ID TerminalNo Flag Terminal Flag State Variant _ID Flag Variant values App ee a pil pales insert into GraphicElement GraphicElement_ID GraphicLayer ID GraphicType ID GraphicText_ID1 Element_ID SymbolDef FrgndColor BkgndColor PenStyle PenWidth SymbolSize SymCenterX SymCenterY SymbolType SymbolNo Flag Variant _ID Flag Variant weltos ip 23 l l 0 1 0 i lOO 12250 22125 19 0 i aa insert into GraphicTerminal GraphicTerminal ID GraphicElement_ID Graphiletext IDA Terminal hp ys Pos xy Posy FrgndColor PenStyle PenWidth SwtType SwtAlign SwtNodePos SwtFactor SwtFrgndColor SwtPenStyle SwtPenWidth SymbolType SymbolAlign SymbolNodePos SymbolFactor SymbolFrgndColor SymbolPenStyle SymbolPenWidth TextAlign Flag Variant_ID Flag Variant valves ly lye Lhe SU 2 S00 Ue Uy Oey Oy a ee insert into GraphicTerminal GraphicTerminal ID GraphicElement_ID Creaphitehe cil ie rmitnc TEOS k ROSY FrgndColor PenStyle
117. nt_ID Long Integer Secondary Key Variant Flag_Variant Integer Element of Current Variant 0 No 1 Yes VisibleZF Integer Visible at Zoom Factor 2 6 Results in the Database PSS SINCAL stores calculation results in the database in the same way as input data This is done automatically once a calculation has been performed successfully The results in the database can be accessed at any time by your own applications 100 00 99 58 0 00 0 52 0 07 MW 0 03 MVAr 0 07 MW 0 03 MVAr 0 07 MW 0 07 MW LO4 0 03 MVAr 0 03 MVAr 0 07 MW 0 03 MVAr 0 07 MW 0 03 MVAr The most important tables showing the results for electrical networks are e Load flow LFNodeResult Load flow node results LFBranchResult Load flow branch results ULFNodeResult Unbalanced load flow node results ULFBranchResult Unbalanced load flow branch results LFGroupResult Load flow area results SRE O E e O e LFParNetLossesResult Load flow subnetwork losses results April 2015 26 128 SIEMENS PSS SINCAL Database Interface and Automation o LFAccurResult Load flow accuracy results e Short circuit o SC3NodeResult Node results 3 phase short circuit o SC3BranchResult Branch results 3 phase short circuit o SC1NodeResult Node results 1 phase short circuit o S C1BranchResult Branch results 1 phase ground fault e Optimizations o SeparationResult
118. o Load Current id Vector Group The two winding transformer is a branch element This means it has two terminals connecting it to two nodes busbars In our example these are the busbars N1 and N2 April 2015 13 128 SIEMENS PSS SINCAL Database Interface and Automation This branch element is described in the database with the following tables e Element This is the basic record for the network element e TwoWindingTransformer This table contains the specific attributes of the two winding transformer e Terminal This table creates the connection between the network element and the nodes busbars Element Element_ID VoltLevel_ID Group_ID Name Type Flag _ Input Flag_Variant Variant_ID 1 2 1 gi Infeeder 3 1 1 2 2 1 272 TwoWinding 3 1 1 Transformer The data in the element table for the two winding transformer are the same as those previously described for the infeeder As with the infeeder the Type field stores the network element Type TwoWindingTransformer TwoWindingTransformer Element_ID Typ_ID Flag_Typ_ID Uni Un2 Sn uk 2 0 O 100 1 0 0 63 8 0 The input data for the two winding transformer are stored in the TwoWindingTransformer table The secondary key Element_ID creates the connection to the table element Element_ID 2 Terminal Terminal_ID Element_ID Node_ID TerminalNo Flag State Flag_Variant Variant_ID 1 1 1 1 1 1 1 2 1 1 1 1 1 2 2 2 1 1 1 The table Terminal is used to create
119. o be reduced ADDOBJ_NETRED_ BOUNDARY Example Boundary lines for network reduction Set object for further usage const ADDOBJ_OBJ_SC 2 Simulation AddObjID 4 1 ADDOBJ_OBJ_SC Parameter Set and Query Global Parameters Sets a global parameter for the calculation method SimulateObj Parameter strParameter Value Value SimulateObj Parameter strParameter Properties Parameter Variant Value of the parameter Parameters strParameter String Predefined name of the parameter Different calculation methods have different parameters April 2015 58 128 SIEMENS PSS SINCAL Database Interface and Automation Global Parameters Parameter Data type Description Sim Identification String Name identifying the objects Name identification by a name ShortName identification by a short name Determines whether the name Name or short name ShortName is used to identify an object GRAPHIC_VIEWID Integer The graphic view using for the calculations GraphicAreaTile_ID Contingency Analysis Parameter Data type Description CA_MODE String Specifies the calculation mode NORMAL normal calculation REDUCED reduced calculation PRE_ANALYSE preanalysis CA_PRE_ANALYSE_MODE Specifies the calculation method for the pre analysis VOLT voltage change ISOL_POWER not delivered power ISOL_ELEMENTS not supplied elements ISOL_CONSUMERS
120. ocess Client Application Process SimulateSrv exe COM Interface COM Interface PSS SINCAL Simulation Simulate dll gt a PSS SINCAL Simulation Simulate dll For high performance solutions you can administer all the network data and of course the results in virtual tables directly in the PSS SINCAL calculations The structure of these virtual tables is exactly like the PSS SINCAL data model COM interfaces write network data get results and control the calculation methods For a C sample program that shows how calculation methods are integrated into external applications and how virtual tables are used see the PSS SINCAL installation structure Batch SimAuto zip April 2015 42 128 SIEMENS PSS SINCAL Database Interface and Automation Integrating the Calculation Methods in own Solutions The idea is to use PSS SINCAL calculation methods load flow short circuit etc as a basis for individual solutions and analyses Normally you use an existing PSS SINCAL network and then analyze this with own solutions A simple example In a network you need to examine the effect of a load increase You increase a load value step by step and check the voltage level at the node at the same time For this problem the small sample program VoltageDrop vbs in the PSS SINCAL installation structure is available File VoltageDropBatch vbs
121. odeSize Integer Symbol Size Factor NodeStartX Double Node Start X Coordinate NodeStartY Double Node Start Y Coordinate NodeEndX Double Node End X Coordinate NodeEndY Double Node End Y Coordinate SymType Integer Node Symbol Type 0 No symbol 1 Circle 2 Rectangle 3 Busbar Flag Long Integer Flag Variant_ID Long Integer Secondary Key Variant Flag_Variant Integer Element of Current Variant 0 No 1 Yes GraphicArea_ID Long Integer Secondary Key Graphic Area Tile The secondary key GraphicText_ID1 assigns a graphic text object This means an individual text object will be displayed in the Graphics Editor with its own position and graphics attributes If you wish you can initialize the field with NULL Then PSS SINCAL will display the text with default attributes in the Graphics Editor but the text cannot be edited manually The secondary key GraphicText_ID2 is not implemented at this time and should therefore always be initialized with NULL GraphicElement Graphics for Network Element Symbols This table describes the graphics attributes for network element symbols Attribute name Data type Description GraphicElement_ID Long Integer Primary Key Graphic Element GraphicLayer_ID Long Integer Secondary Key Layer GraphicType_ID Long Integer Secondary Key Object Type April 2015 20 128 SIEMENS PSS SINCAL Database Interface and
122. ooling data e Bit 28 Static data April 2015 8 128 SIEMENS PSS SINCAL Database Interface and Automation e Bit 30 Equivalent element data Example for coding short circuit and load flow data for electrical networks BitO Bit1 1 2 83 2 4 Database Analysis with the Help of an Example Network The following is an explanation of the data model with the help of a small example network The PSS SINCAL user interface is used to create a network and analyze the database N1 N2 11 Sk 1000 0 MVA 272 3 LO4 R X 0 1 pu Sn 0 6 MVA 1 1 0 km P 0 1 MW uk 8 0 r 0 1 Ohm km Q 0 0 MVAr d x 0 4 Ohm km N3 ANA c 0 0 nF km The network displayed here is created step by step To see how the data model works the contents of the database are analyzed after each processing step The following steps are needed to create the example network e Step 1 Create a new network e Step 2 Create network levels e Step 3 Create busbars e Step 4 Create the infeeder e Step 5 Attach the two winding transformer e Step 6 Create the line e Step 7 Attach the consumer Step 1 Create a New Network A new schematic electrical network is created in the PSS SINCAL user interface First File New is clicked in the menu April 2015 9 128 SIEMENS PSS SINCAL Database Interface and Automation Select workspace settings and choose drawing mode Select Working Mode Type of drawing oer tici C Geo
123. orks DELETERESULTS Deleting all the Results in the Database Parameter Data type Description vtParameter1 String or Long Integer Name of the variant or DB ID of the variant vtParameter2 Boolean Change variant of the Include networks Example Change variant to Base SimulateObj DoCommand CHANGEVARIANT Base False April 2015 65 128 SIEMENS PSS SINCAL Database Interface and Automation Start Start Calculation Starts the calculations SimulateObj Start strMethod Parameters strMethod String Predefined sign for the calculation method The following table lists the parameters that can be used to specify the calculation method Calc method Description Electrical networks LF Load Flow according to Settings for Calculation Parameters LF_NR Load Flow Newton Raphson LF_YMAT Load Flow Admittance Matrix LF_Cl Load Flow Current Iteration LF_USYM Unbalanced Load Flow LF_NETO Load Flow Netomac LF_PSSE Load Flow PSS E LF_MALF Malfunction of Selected Network Elements LF_TRIM Load Assignment LF_ALLOC Load Allocation LF_BAL Load Balancing LF_RESUP Restoration of Supply LF_TAP Tap Zone Detection LF_INC Load Development LC Load Profile GEN_PV PV Curves OPT_LF Load Flow Optimization OPT_BR Optimal Branching OPT_COMP Compensation Power OPT_CAP Capacitor Placement OPT_NET Optimal Network
124. ouble Controlled Voltage at Controller Node Control Range Data Pmin Double Active Power Lower Limit Pmax Double Active Power Upper Limit Qmin Double Reactive Power Lower Limit Qmax Double Reactive Power Upper Limit Umin Double Voltage Lower Limit Umax Double Voltage Upper Limit cosphi_lim Double DC Infeeder DCInfeeder Attribute name Data type Limit Power Factor Description Flag_Input_Type Integer DC Input 1 PandQ 2 P and cosphi 3 Inverter P Double Active Power Q Double Reactive Power cosphi Double Power Factor DC_power Double Installed DC Power fDC_power Double Factor Installed DC Power Double Multiplication Factor Active Power Double Multiplication Factor Reactive Power DC_losses Double Losses until Inverter Eta_Inverter Double Efficiency Inverter Q_Inverter Double Reactive Power Demand Inverter Ctrl_power Double Controller Power Tr_UrNet Double Rated Voltage Netside Transformer Tr_Sr Double Rated Apparent Power Transformer Tr_uk Double Reference Short Circuit Voltage Transformer Tr_rx Double Ratio R X Transformer Umin_Inverter Double Minimum Voltage Inverter Umax_lInverter Double Maximum Vol
125. plementary graphics objects of the network are stored in this file When a network is opened with the Open dialog box this file is selected The directory with the suffix files has all the additional network data This directory stores the actual network database the diagram files various log files and files with the results Example Elel sin Example Elel files database ini database mdb database dia NETO network bat network ctl The file with the ending ini is a configuration file that lets you configure how PSS SINCAL will use the database The file with the extension mdb is the network database in Microsoft Access format All data that describe the network are stored in this file If you use a server database system such as ORACLE or SQL Server for example there is no MDB file In this case the program stores network data directly in the central server database Supported Database Systems Currently following database management systems are supported e Microsoft Access 2003 2007 and 2010 e Oracle 9i 10g and 11g e SQL Server Express 2008 and 2008 R2 e SQL Server 2008 and 2008 R2 April 2015 4 128 SIEMENS PSS SINCAL Database Interface and Automation 2 2 Data Model Design Guidelines The PSS SINCAL Data Model was developed using the following criteria e The PSS SINCAL Data Model is object oriented e All objects are unique and respond to the primary key e The standardized layo
126. pply pressure and difference 3 Return pressure and difference 4 Pump data and parts 5 Supply pressure and pump data 6 Return pressure and pump data Flag_Master Integer Leading Supply 0 No 1 Yes Efficiency Double Efficiency pDiffMin Double Primary Minimum Pressure Difference April 2015 120 128 SIEMENS PSS SINCAL Database Interface and tPrim Double Primary Temperature Automation tFeed Double Secondary Supply Temperature uPump Double Characteristic Pump Speed FlowStep Double Maximum Step for Flow Power Double Power pMedium Double Medium Pressure pSupRet Double Difference Pressure pSupplyMaint Double Supply Pressure pReturnMaint Double Return Pressure SupplyPart Double Part Supply Pressure ReturnPart Double Part Return Pressure QOutput Pressure Regulator FlowPressureReg Attribute name Double Data type Output Flow Description plnlet Double Max Pressure Deviation pOutlet Double Pressure at Outlet Node pDevation Double Pressure at Inlet Node QReturn Flag_Pessinc Integer Function 1 Pressure increase 2 Pressure drop 3 Pressure increase and drop Flag_PressDif Integer Difference Pressure Regulator 0 No 1 Yes pSupRet Double Difference Pressure Pressure Incr
127. primary key secondary key and the variant code PSS SINCAL automatically fills in all the other attributes with the default values if they have not already been filled in Read out Line Data from the Database ReadLines ReadLines reads out the line data from the sources database and converts this to PSS SINCAL format As with ReadNodes it generates the appropriate SQL commands when it converts the data Reading out and processing the network element data is however more complicated since more tables need to be filled as with lines Sub ReadLines iMode iMode 1 Normal Mode 0 Only init Dim rsLine Call ReadNodes 0 WScript Echo Reading Lines Call OpenDatabase strIMPORTdb Call OpenRecordset SELECT Nodel AS Node _ID1 Node2 AS Node _ID2 Name AS ID Name _ WU IN ohor EName U0 reve Whe IE gS ibe te Sp ep Whi So Leh VON AS Status VON AS Switch YON AS Switch amp FROM Line rsLine If Not rsLine EOF and Not rsLine BOF Then Dim iRet rsLine MoveFirst Dim iTempNodeID iTempNodeID 0 Dim Nodel Node2 Set Nodel New Node Set Node2 New Node Do While Not rsLine EOF Dim bIsVaid bIsVaid True Set Nodel dctNodes Item CStr rsLine Node_ID1 Set Node2 dctNodes Item CStr rsLine Node_ID2 Skip bad objects If IsEmpty Nodel Or IsEmpty Node Or Nodel iID Node2 iID Then bIsVaid False End If If IsNull rsLine LineLength Then bIsVaid Fals
128. r Load Type 1 Load 2 Customer load Flag_LF Integer Load Input P Q and u P Q and U S cosphi and u S cosphi and U cosphi and u cosphi and U Pand E cosphi and t Eap and Eaq Pi and Qi P cosphi and u P cosphi and U Pi Qi and u star Pij Qij and u delta P Q and u delta Double Active Power Double Reactive Power Double Voltage Double Voltage Double Apparent Power Double Power Factor Double Current Double Active Power Phase 1 Double Reactive Power Phase 1 Double Active Power Phase 2 Double Reactive Power Phase 2 Double Active Power Phase 3 Double Reactive Power Phase 3 Double Active Power Phase 12 April 2015 98 128 SIEMENS PSS SINCAL Database Interface and Automation Q12 Double Reactive Power Phase 12 P23 Double Active Power Phase 23 Q23 Double Reactive Power Phase 23 P31 Double Active Power Phase 31 Q31 Double Reactive Power Phase 31 Zero and Negative Phase Sequence Flag_Z0 Integer Grounding 0 Not grounded 1 Fixed grounded 2 Grounded w impedances Flag_ZOInput Integer Zero Phase Sequence Input Data 1 Z0 Z1 and R0 X0 2 RO and X0 ZO_Z1 Double Ratio Zero Phase to Positive Phase Sequence Impedance RO_X0 Double Ratio R X Zero Phase Sequence RO Double Resistance
129. re Water Simulation 0 No 1 Yes ConLineLength Double Length ConLineDiameter Double Diameter ConLineRoughness Double Sand Roughness ConLineZeta Double Loss Factor Zeta Value dsh Double Delta Elevation QFireWater Double Fire Water Flow pFireWater Double Fire Water Pressure tFireWater Double Fire Water Time pRelMinLimit Double Minimum Pressure Relative Const Pressure Decrease Const Flow FlowConstLine Attribute name Data type Description Flag_Typ Integer Line Type 1 Constant pressure drop 2 Constant flow PressureDecr Double Pressure Drop Consumer FlowConsumer Attribute name Data type Description Q Double Const Consumption Flag_ConControl Integer Pressure Dependent Consumption Decrease 0 No 1 Yes pDiffMin Double Minimum Pressure Difference pRelMin Double Minimum Relative Pressure DesignTemp Double Design Temperature of Consumer Pressure Regulator FlowPressureReg Attribute name Data type Description plnlet Double Max Pressure Deviation pOutlet Double Pressure at Outlet Node April 2015 112 128 SIEMENS PSS SINCAL Database Interface and Automation pDevation Double Pressure at Inlet Node Flag_Pessinc Integer Function 1 Pressure increase 2 Pressure drop 3 Pressure increase and drop Pressure Increase Pump FlowPumpLine Attribute name Data type Description
130. rrent Basic Current Side 1 primary Ins Double Basic Current Side 2 secondary _Ins Double Current Basic Current Side 2 secondary t Integer Key for Time tdiag Double Time Direct Diagram Connection 22 00 22 3600 Flag_Result Integer Result Type 0 Load flow 1 Load profile 2 Load development ResDate Date ResTime Double Time Flag_State Integer State 1 Ok 2 Limit reached Inb1 Double First Additional Rating Inb2 Double Second Additional Rating Inb3 Double Third Additional Rating April 2015 28 128 SIEMENS PSS SINCAL Database Interface and Automation 3 Filling in the PSS SINCAL Database This chapter explains how to fill the PSS SINCAL database manually with your own applications 3 1 Example Program for Filling the Database When you install PSS SINCAL there is an example program that teaches you how to fill the database The example program has been written in VBS Visual Basic Script This can be executed with the standard Windows Scripting Host and without any additional software on all current Windows platforms The ImportDB vbs example program is in the PSS SINCAL Batch directory Simply enter the example program at the prompt to start If you do not add any additional parameters PSS SINCAL will display hints on how to use this gt cscript exe ImportDB vbs Usage cscript exe ImportDB vbs ImportDB mdb SincalDB mdb MODE MO
131. rsNode NodeType Position amp Height Dim dSh dSh 1 0 pt SetXY CDb1 rsNode hr CDbl rsNode hh Add data of node to internal arrays iRet InsertIntoNodeArray CStr rsNode ID iNodeID pt iLevellID if iMode 1 Then Dim iNID iNID AddNode strName strShortName iLevelID iGroupID iType pt x If Not pt IsEmptyPoint Then iRet AddGraphicNode iNID 1 pt pt End If April 2015 31 128 SIEMENS PSS SINCAL Database Interface and Automation Else iNodeID iNodeID 1 End Lf rsNode MoveNext Loop Set pt Nothing End If Call CloseRecordset rsNode Call CloseDatabase End Sub Records are selected from the ImportDatabase with following SQL command Call OpenRecordset SELECT Name AS ID Name ShortName NodeType NetworkLevel Un hr hh amp FROM Node rsNode These records are processed in a loop and stored to an internal list using AddNode Function AddNode strName_ strShortName_ iVoltLevelID_ iGroupID_ iType _ dHr_ dHh_ dSh Dim iRet If bElectro Then iRet InsertIntoArray arrNode iCntNode _ insert into amp strTableNode amp Node ID VoltLevel_ ID Group_ID Name E aliNfeyeleirpy fe Hp Ione ve MMe MM IGroOUp IDEAR me amp SCENENE E NAN PU ts Swisivonc ems fe WY amp amp amp amp amp iType fe amp amp amp amp dHr amp dHh amp dash Ws il r wow BS oI ri ary Els
132. ry and secondary keys e Table Element Primary key Element_ID Secondary key VoltLevel_ID Variant_ID e Table Terminal Primary key Terminal_ID Secondary key Element_ID Node_ID Note PSS SINCAL uses special algorithms for the management of the key fields Therefore it is important to ensure that the IDs are generated ascending starting with the smallest possible ID 1 Gaps in the IDs are easily possible but it should be avoided to store very large numbers because otherwise problems with PSS SINCAL GUI functions and variant management have to be expected Also the direct storage of unique GIS IDs in the primary key fields is not allowed For this purpose the special MasterResource mapping table is available Attribute Names e Whenever possible attribute names are the same as the corresponding formula sign e Attribute names are kept as language neutral as possible or English terms are used e Attribute names are both unique and case sensitive e Numbers replace superscripts and commas e g gt 1 gt 2 e Underscoring _ is used as a placement marker for slashes and to connect expressions e External and primary keys end with _ID e g Element_ID Variant_ID April 2015 6 128 SIEMENS PSS SINCAL Database Interface and 2 3 Structure of the Database Automation The following illustration shows the basic structure of the PSS SINCAL Data Model on the basis of some selected tables Terminal
133. s Attribute name Data type Description GraphicTerminal_ID Long Integer Primary Key Graphic Terminal GraphicElement_ID Long Integer Secondary Key Graphic Element GraphicText_ID Long Integer Secondary Key Graphic Text Terminal_ID Long Integer Secondary Key Terminal PosX Double X Coordinate PosY Double Y Coordinate FrgndColor Long Integer Line Color PenStyle Integer Pen Style 0 Straight line 1 Small dotted 2 Dotted 3 Straight line point straight line 4 Straight line point point straight line PenWidth Integer Pen Width SwtType Integer Switch Type No Type Type 1 Type 2 Type 3 Type 4 Type 5 Type 6 SwtAlign Integer Switch Direction 0 Automatic 1 Position 1 2 Position 2 3 Position 3 4 Position 4 SwtNodePos Double Switch Distance to Node SwtFactor Integer Switch Size Factor SwtFrgndColor Long Integer Switch Line Color SwtPenStyle Integer Switch Pen Style 0 Straight line 1 Small dotted 2 Dotted 3 Straight line point straight line 4 Straight line point point straight line April 2015 22 128 SIEMENS PSS SINCAL Database Interface and Automation SwtPenWidth Integer Switch Pen Width SymbolType Integer Symbol Type SymbolAlign Integer Symbol Direction SymbolNodePos Double Symbol Distance to Node SymbolFactor Integer Symbol Size Factor
134. s in Database 0 None 1 All 2 Restricted elements only 3 All elements in case of restrictions StartTime Double Starting Time Duration Double Duration TimeStepGeo Double Time Step Geo stationary Attribute name Data type Description pRated Double Rated Pressure TRated Double Rated Temperature TAir Double Air Temperature vMax Double Maximum Flow Velocity pMin Double Minimum Operating Pressure Supply Line pMax Double Maximum Operating Pressure Supply Line TSupplyLine Double Temperature Supply Line pMinR Double Minimum Operating Pressure Return Line pMaxR Double Maximum Operating Pressure Return Line TReturnLine Double Temperature Return Line Network Area FlowNetworkGroup Attribute name Data type Description Flag_MarkedForCaused Integer Marked for Caused Malfunction 0 No 1 Yes Flag_Malfunc Integer Malfunction 0 None 1 All elements 2 All lines 3 All restricted elements 4 All restricted lines Speed_BaseLimit Double Base Speed Limit Flag_CausedMalfunc Integer Caused Malfunction 0 None 1 Marked areas 2 Own area Flag_CausedElem Integer Caused Elements 1 Restricted elements 2 Restricted lines Speed_CausedLimit Double Caused Speed Limit Flag_Report Integer Reporting None Elements and nodes Lines and nodes Elements Lines Nodes April 2015 119 128 SIEMENS PS
135. splay of coupling nodes in the network reduction 1 PQ Type 2 Type 3 PV Type 4 S Type DYNNETRED_KEEPNAMES Integer Name of individual machines retained 0 no 1 yes DYNNETRED_REDCONTROLLER Integer Machines in the network to be reduced without controller 0 no 1 yes DYNNETRED_NOTREDCONTROLLER Integer Machines in the network not to be reduced without controller 0 no 1 yes DYNNETRED_KEEPCONTROLLER Integer Controller of individual machines retained 0 no 1 yes DYNNETRED_PSSCONTROLLER Sting Name of the PSS controller DYNNETRED_EXCITER String Name of the voltage controller DYNNETRED_GOVERNOR String Name of the turbine governor CIM Export Parameter Data type Description CIM_FORMAT String CIM version April 2015 61 128 SIEMENS PSS SINCAL Database Interface and Automation CIM_V10 CIM_V11 CIM_V12 CIM_V14 CIM_V15 CIM_PROFILE CIM profile CIM_STANDARD CIM Standard CIM_PLANNING CIM for Planning CIM_ENTSOE CIM for ENTSO E FILENAME FILENAME_ Complete path and file name for the first file as well as the subsequent files specifies the file number ranging from 2 up to at the very most the number indicated under FILENAME_CNT FILENAME_FLAG FILENAME_FLAG_ File type for the first data file as well as the subsequent files specifies the fil
136. ta in the tabular object are organized in lines and columns similar to a calculation table Each line represents a unique record and each column a field or attribute within the record The database object creates an instance of a tabular object Example Get the load flow node result tabular object Dim LFNodeResult Set LFNodeResult SimulateDataBase GetRowObj LFNodeResult If LFNodeResult Is Nothing Then WScript Echo Error Getting LFNodeResult object failed WSiCtel ete nO udets End ite If the instance of the automation object is not used any longer it must be released with the following instruction Release the tabular object Set LFNodeResult Nothing Open a Tabular Object Opens the database table for a tabular object so you can access the records hr TableObj Open April 2015 ee SIEMENS PSS SINCAL Database Interface and Automation Return Value hr HRESULT Status code of the command Example Open a database table DEMANT hr TableObj Open If hr lt gt 0 Then WSeript Echo Error Open failed WIS radia tee Quit Ene it Close Close a Tabular Object Closes a database table of a tabular object TableObj Close Comments Once you close the database table you must not access the tabular object any longer The instance of the tabular object also needs to be released Example Close a database table and release it TableObj Close Set LFNodeResult Not
137. tage Inverter t_off Double Switch Off Time Flag_Connect Integer Type of Connecting 1 Directly 2 Transformer Flag_l Flag_ Control Current State 0 Not active at load flow 1 Active at load flow lreg lreg Control Current pk pk Reference Compensation Power April 2015 96 128 SIEMENS PSS SINCAL Database Interface and Flag_PhiSC Integer Automation Additional Short Circuit Data 0 No 1 Yes PhiSC Double Angle Short Circuit Current fSc Double Factor Short Circuit Asynchronous Machine AsynchronousMachine Attribute name Data type Description Flag_Typ Integer Input Type of Asynchronous Machine 1 Pn 2 In 3 NEMA Pn Double Rated Active Power Un Double Rated Voltage Speedn Double Rated Speed pol Double Pole Pair Number cosphin Double Rated Power Factor etan Double Rated Efficiency laln Double Current Ratio At Start Up RX Double Ratio R X Positive Phase Sequence Inm Double Rated Current Flag_LF Integer Load Flow Type 1 PandQ 2 P and cosphi 3 P Pn and cosphi 4 U und cosphi 5 DFIG P Q and Slip P Double Active Power Q Double Reactive Power cosphi Double Power Factor ppn Double Utilization Double Basic Current Source
138. terface and 3 2 Automation Nodes Call InsertRecords iCntNode arrNode Node Element amp Terminal Call InsertRecords iCntElement arrElement Element Call InsertRecords iCntTerminal arrTerminal Terminal Lines Call InsertRecords iCntLine arrLine Line Transfomer Call InsertRecords iCntTransformer arrTransformer TwoWindingTransformer 1 Load amp Customer data Call InsertRecords iCntLoad arrLoad Egad ME Graphics Call InsertRecords iCntGraphicNode arrGraphicNode GraphicNode Call InsertRecords iCntGraphicText arrGraphicText Ycraphiectexte un Call InsertRecords iCntGraphicTerminal arrGraphicTerminal GraphicTerminal Call InsertRecords iCntGraphicElement arrGraphicElement GraphicElement Call CloseDatabase End Sub Help Program for Creating PSS SINCAL Database For your own coupling solutions you need to fill a blank PSS SINCAL network database with your own data For this purpose PSS SINCAL installation has the SinDBCreate exe help program SinDBCreate lets you create PSS SINCAL network databases as well a standard and protection device databases without the PSS SINCAL user interface The program must be started in a command prompt There is no graphic user interface i e start parameters control the program Different settings from the PSS SINCAL Registry are also used e g Oracle database configuration if these have
139. terface and Automation Return Value ICnt Long Integer Number of possible attributes Example Get the number of available attributes Dim Crit Cnt ResultObj Count Name Determine Attribute Names Returns the name of an attribute strName ResultObj Name lAttribute Properties Name String Name of the attribute Parameters Attribute Long Integer Number of the attribute Example Display the names of all available attributes for the object Dim TAGE CME 1Cnt ResultObj Count joie sie ik Yee icine Dim strName strName ResultObj Name iAttr WScriptehchomtAttr scl ace sitzeName Next Item Access Attributes Lets you access the output data for a results object Value ResultObj Item lAttribute Value ResultObj Item strAttribute Properties Item Variant Value of the attribute April 2015 arlag SIEMENS PSS SINCAL Database Interface and 4 1 4 Automation Parameters iAttribute Long Integer Numerical index of the attribute strAttribute Long Integer Name of the attribute Comments This property is read only The calculation results object is exactly the same as the results tables in the PSS SINCAL database This means the attribute names are the same as the field names in the results table For detailed documentation of all results tables see the PSS SINCAL Database Description Example Getting load flow result for node Dim L
140. their terminals This attribute shows the operating status of the network element or the tripping status of the respective terminal Simply changing this attribute can switch network elements ON or OFF 4 2 3 Attributes of Calculation Objects for Electrical Networks Calculation Settings CalcParameter Attribute name Data type Description ViewDate Double View Date LoadDataDate Double Load Data Date Sref Double Reference Power FrqNet Double Frequency Uref Double Reference Voltage ExportForm Integer Export Format for Names 0 Name 1 Short name IncreaseLoads Integer Use Increased Loads 0 No 1 Yes ContrAdjustment Integer Controller Adjustment 1 Discrete 2 Continuous FlatStart Integer Flat Start 0 No 1 Yes ChangeLFMethode Integer Change Load Flow Method at Convergence Problems 0 Off 1 On LFPreCalc Integer Pre Calculate 0 No 1 Yes LFMethod Integer Load Flow Procedure 1 Current iteration 2 Newton Raphson 3 Admittance matrix 5 Unbalanced April 2015 89 128 SIEMENS PSS SINCAL Database Interface and Automation StoreRes Integer Include Load Profile Result in Database 0 Due to method 1 All 2 Restricted elements only 3 All elements in case of restrictions ImpLoad Integer Impedance Load Conversion 0 No 1 Normal 2 Extended LFControl Integer Enable Automatic Controller Change 0 No 1 Normal 2 Extended Island Integer
141. tional Limit Current Ith3 Double kA Third Additional Limit Current FrqNenn Double Hz Rated Frequency alpha Double Temperature Coefficient for Temperature Dependent Resistance Change Zero Phase Sequence Flag_ZOInput Integer Zero Phase Sequence Input Data 1 X0 X1 and RO R1 2 r0 and x0 RO_R1 Double pu Ratio Zero Phase to Positive Phase Resistance X0_X1 Double pu Ratio Zero Phase to Positive Phase Reactance RO Double Ohm km Resistance Zero Phase Sequence X0 Double Ohm km Reactance Zero Phase Sequence Co Double nF km Capacitance in Zero Phase Sequence rR Double Ohm km Resistance Return Conductor xR Double Ohm km Reactance Return Conductor April 2015 106 128 SIEMENS PSS SINCAL Database Interface and Automation Variable Serial Element VarSerialElement Attribute name Data type Description Flag_LF Integer Load Flow Input 1 Impedance 2 Model Flag_Macro_LF Integer Model Type Load Flow 0 None 1 Controller 2 Equivalent circuit Uri Double Rated Voltage Side 1 Ur2 Double Rated Voltage Side 2 R12lf Double Resistance Load Flow X12lf Double Reactance Load Flow R211f Double Resistance Load Flow X211f Double Reactance Load Flow R12sc Double Resistance Short Circuit X12sc Double Reactance Short Circuit R21sc Double Resistance Short Circuit X21sc Double Reactance Short Circuit Zero P
142. type Description Uref Double Voltage Target Value uul Double Voltage Upper Limit ull Double Voltage Lower Limit StartU Double Initial Voltage StartPhi Double Angle Initial Voltage April 2015 91 128 SIEMENS PSS SINCAL Database Interface and Automation Double Maximum Admissible Short Circuit Current Double Maximum Admissible Peak Short Circuit Current uul Double Additional Voltage Upper Limit ull1 Double Additional Voltage Lower Limit FlagPhase Integer Preferred Fault Phase Synchronous Machine SynchronousMachine Attribute name Data type Description Flag_Machine Integer Type of Machine Turbo generator Hydro gen amort Hydro generator Condenser Non interconnected equivalent Power station equivalent Transmission system equivalent Distribution system equivalent ONDAN Double Rated Apparent Power Double Active Power Double Reactive Power Double Generator Voltage Percentage Double Rated Voltage Double Generator Voltage Absolute R_X Double Ratio R X Positive Phase Sequence xd2sat Double Saturated Subtransient Reactance xd1sat Double Saturated Transient Reactance xi Double Internal Reactance Ugmax Double Maximum Generator Voltage Ikp Double Sustained Short Circuit Current of Compound Machines Flag_LF Integer Load Flow Type I and phi PandQ usrc and
143. uble Switch Delay April 2015 90 128 SIEMENS PSS SINCAL Database Interface and Automation Ipmax Double Maximum Admissible Surge Current lbrkmax Double Maximum Admissible Tripping Current Upre Double Pre Fault Voltage due to ANSI IEEE Flag_Toleranz Integer Voltage Tolerance Low Voltage Networks 1 6 2 10 Network Area NetworkGroup Attribute name Data type Description Flag_IC Integer Transfer Active 0 No 1 Yes Pdes Double Interchange Leaving the Area Ptol Double Interchange Tolerance Bandwidth Flag_Malfunc Integer Malfunction None All elements Loaded elements All lines Loaded lines All lines and transformers Loaded lines and transformers Flag_Connectors Integer Consider Connectors in Malfunction and Caused Malfunction 0 No 1 Yes Util_BaseLimit Double Base Utilization Limit Flag_CausedMalfunc Integer Caused Malfunction 0 None 1 Marked areas 2 Own area Flag_CausedElem Integer Caused Elements 1 Loaded elements 2 Loaded lines 3 Loaded lines and transformers Util_CausedLimit Double Caused Utilization Limit Flag_CausedForeign Integer Marked for Caused Malfunction 0 No 1 Yes Flag_Util Integer Show Elements outside Limits None Elements and nodes Elements Lines transformers and nodes Lines and transformers Lines and nodes Lines Node Node Attribute name Data
144. ut used through most of the program reduces redundancies and simplifies the search for and control of consistency e The PSS SINCAL Data Model is separated into categories to simplify evaluations and management e There are no limitations as to how the selected data model is implemented in all the PSS SINCAL Relational Database Management systems Table Names Appropriate English terms have been selected as table names PSS SINCAL uses upper and lower case letters to improve legibility Essentially the names of tables differentiate among input data graphic data and results All tables for input data have appropriate simple names e Line e nfeeder e TwoWindingTransformer e etc All tables with graphic data begin with Graphic e GraphicElement e GraphicLayer e etc The tables for result data begin with an abbreviation for the calculation method and end with Result e LFNodeResult e LFBranchResult e SC1NodeResult e C1BranchResult e etc April 2015 5 128 SIEMENS PSS SINCAL Database Interface and Automation Keys Most of the tables in the PSS SINCAL Data Model have primary keys to uniquely identify data The primary key in a table contains the name of the table and has the ending _ID References in the PSS SINCAL Data Model have a secondary key It includes the name of the reference table and has the ending _ID The data type of keys is always Longlnteger Examples of prima
145. ve Phase Resistance RO Double Resistance Zero Phase Sequence XO Double Reactance Zero Phase Sequence LO Double Inductance in Zero Phase Sequence Dynamic Data ResFlux1 Double Residual Flux Phase L1 ResFlux2 Double Residual Flux Phase L2 ResFlux3 Double Residual Flux Phase L3 Serial Capacitor SerialCondensator Attribute name Data type Description C Double Capacitance XC Double Capacitive Reactance Un Double Rated Voltage R_X Double Ratio R X Positive Phase Sequence Smax Double Full Load Power Smax1 Double First Additional Full Load Power Smax2 Double Second Additional Full Load Power Smax3 Double Third Additional Full Load Power Zero Phase Sequence Flag_ZOInput Integer Zero Phase Sequence Input Data 1 RO R1 and X0 X1 2 RO and X0 3 RO and CO Double Ratio Zero Phase to Positive Phase Reactance Double Ratio Zero Phase to Positive Phase Resistance Double Resistance Zero Phase Sequence Double Reactance Zero Phase Sequence Serial Harmonics Resonance Network HarBranchResNet Attribute name Data type Description Un Double Rated Voltage R1 Double Resistance at Network Frequency X1 Double Reactance at Network Frequency April 2015 108 128 SIEMENS PSS SINCAL Database Interface and Automation Impedance Integer Determine Impedance 1 Vmax 2 Imax RCData Integ
146. wConstLine Const pressure decrease const flow FlowPressureReg Pressure regulator FlowCompressor Compressor Heating Cooling Networks Object type Description General Data FlowCalcParameter Calculation settings FlowNetworkLevel Network level FlowNetworkGroup Network area Nodes Busbars FlowNode Node Elements FlowlnfeederH Infeeder heating cooling FlowPump Pump FlowConsumer Consumer FlowPressureBuffer Pressure buffer FlowLeakage Leakage April 2015 87 128 SIEMENS PSS SINCAL Database Interface and Branch Elements Automation FlowLine Line FlowValve Sliding valve non return valve FlowPumpLine Pressure increase pump FlowConstLine Const pressure decrease const flow FlowPressureReg Pressure regulator FlowThermoReg Temperature regulator FlowHeatExchanger Heat Exchanger 4 2 2 General Topology Attributes General topology attributes are available for both nodes and network elements They let you query important basic information such as names and connection phases as well as establishment and shutdown times Attribute Description Node TOPO ID Internal ID Node TOPO DBID Database ID Node Node_ID TOPO Name Name Node TOPO ShortName Short Name Node TOPO Phase Connection Phase is determined dynamically by the attached elements 1 L123 TOPO TI Read Write Establishment Time TOPO TS

Download Pdf Manuals

Related Search

Related Contents

Guide du propriétaire - Minus Forty Technologies  MENBLOC 71576596 02-13 Italian  BAM 50-51  Appareils de mesure - Mercado    バイオライン BIOLINE サルモネラ ELISA キット  Samsung L210 Kullanıcı Klavuzu  Braun bodycruZer 5785 User's Manual  

Copyright © All rights reserved. Failed to retrieve file