12.2  PowerCalc FUNCTIONS LIST

 

=====================================================================

APC1LObj(INDEX)

 

Purpose: Link cell to OneLiner object.

Note: Function is designed for use in PowerCalc button +1L

 

=====================================================================

APCFault(OBJHND,PCODE,FCODE[,FLAG,R [,X [,OUTAGEGND,OUTAGEn...]]])

Purpose: Simulate fault

Parameters:

   OBJHND= Link to OneLiner Bus, relay group or Branch object

   FCODE=      FC_BUS1 - Bus or close-in

               FC_BUS2 - Remote bus

               PERCENT - Intermediate percent 0.1-99.9

               FC_ENDL - Line end

               FC_EOPN - End open

   PCODE=      PC_3LG

               PC_ABG,PC_BCG,PC_CAG

               PC_AG,PC_BG,PC_CG

               PC_AB,PC_BC,PC_CA

   FLAG=       Simulation flag (not being used in this version)

   R=          Fault resistance. Default 0

   X=          Fault reactance. Default 0

   OUTAGEGND=  Grounding chain resistance. Default 0

   OUTAGEn=    Link to OneLiner line, transformer or phase shifter

               object(s) to be outaged. Default: none

Note: PowerCalc button +Flt automatically insert this function

 

=====================================================================

APCGetBranch( BUSHND, PREVBRANCH )

Purpose: Return link to bus branch

Parameters:

   BUSHND= Link to 1-line bus

   PREVBRANCH= Link to previous branch at the bus. Assign 0 to

               get the first branch.

Note: Link returned in this function can be used in APCFault() and

       other functions.

 

=====================================================================

APCGETDATA(OBJHND,PCODE[,ARRAYIDX])

Purpose: Retrieve 1-line object data

Parameters:

   OBJHND= Link to 1-line object

   PCODE= PowerScript data access code that corresponds to the field.

   ARRAYIDX= [Optional] Index of data when the data field is an array

 

=====================================================================

APCGETI(OBJHND,PCODE,[NPLR[,NTERM[,FIDX]]])

APCGETV(OBJHND,PCODE,[NPLR[,NTERM[,FIDX]]])

APCGETISC(OBJHND,PCODE,[NPLR[,NTERM[,FIDX]]])

APCGETVSC(OBJHND,PCODE,[NPLR[,NTERM[,FIDX]]])

Purpose: Retrieve fault simulation current and voltage

Parameters:

   OBJHND= Link to an 1-line object or HND_SC

   PCODE= Phase code. Enter PC_A,PC_B,PC_C,PC_Z,PC_P,PC_N,PC_X for

          phase A,B,C sequence Zero, Positive, Negative

          and tertiary current respectively.

   NPLR= [Optional] Polar format display. 1=TRUE. Default = 0

   NTERM= [Optional] index of the terminal of multi-terminal equipment,

          where result is desired. Default 1.

   FIDX= [Optional] Index number of the fault simulation case.

         Default: current case

 

=====================================================================

APCGETIPF(OBJHND[,NTERM])

APCGETVPF(OBJHND[,NTERM[,PU]])

APCGETPQ(OBJHND [,NTERM])

Purpose: Retrieve load flow simulation current, voltage and power

Parameters:

   OBJHND= Link to 1-line object or HND_PF

   NTERM= [Optional] index of the terminal of multi-terminal equipment,

          where result is desired. Default 1.

   PU= [Optional] Per-unit out voltage flag. Default: 1

 

=====================================================================

APCGetRly(RLYGROUP[, RLYHND])

Purpose: Return link to relay object

Parameters:

   RLYGROUP= Link to relay group

   RLYHND= Link to previous relay in the group. Assign 0 to

               get the first relay.

 

=====================================================================

APCPickedObjHnd()

Purpose: Return link to highlighted object on the 1-line

 

=====================================================================

APCPickFault([SFCODE[,FIDX]])

Purpose: Select fault case for solution display

Parameters:

   SFCODE= Fault selection code: SF_FIRST,SF_LAST,SF_NEXT,SF_PREV

   FIDX= [Optional] Case index to use with SF_NEXT and SF_PREV

 

=====================================================================

APCRlyOp( RLYHND[, FLTIDX[,CASEIDX]] )

APCRlyTime( RLYHND[, FLTIDX[,CASEIDX]] )

Purpose: Display relay element operation and time

Parameters:

   RLYHND= Link to relay object

   FLTIDX= [Optional] Fault case index number

   CASEIDX= [Optional] SetData case index number.

 

=====================================================================

APCSETDATA(OBJHND,PCODE,VAL[,CASEID])

Purpose: Modify 1-line object data

Parameters:

   OBJHND= Link to 1-line object

   PCODE= PowerScript data access code that corresponds to the field.

   VAL= New value.

   CASEID= [Optional] Index number of data case

 

=====================================================================

COMPLEX( COMPLEXNO[|REAL, IMAGINARY[, POLAR]] )

Purpose: Returns string representation of a complex number

Parameters:

   COMPLEXNO= complex number string

   IMREAL=    [Optional] Real part

   IMAGINARY= [Optional] Imaginary part

   POLAR=     [Optional] Print in polar format. Default: 0

 

=====================================================================

COMPLEXP( COMPLEXNO[|MAG, ANGLE[, POLAR]] )

Purpose: Returns string representation of a complex number

Parameters:

   COMPLEXNO= complex number string

   MAG=       [Optional] Magnitude

   ANGLE=     [Optional] Angle in degree

   POLAR=     [Optional] Print in polar format. Default: 1

 

=====================================================================

STR(VAL)

Purpose: Returns string representation of a number

Parameters:

   VAL= numeric value or reference to a numeric cell

 

=====================================================================

VAL(STR)

Purpose: Returns numerical value of a string representation of a number

Parameters:

   STR= string value or reference to a string cell

 

=====================================================================

Excel equivalent complex number manipulation functions:

IMANGLE, IMSUM, IMDIV, IMPRODUCT, COMPLEX, IMCONJUGATE, IMSUB,

IMAGINARY, IMABS, IMREAL, IMARGUMENT

 

=====================================================================

 

NOTE: Additional supported standard Excel functions are listed in pdf file SP6ExcelFunc.pdf