37283584 35949705 Electrical Calculations

(1)

Purpose of this Spreadsheet

Disclaimer

This spreadsheet presents basic calculations associated with electrical power. In developing this software Basler Electric has attempted to develop accurate calculation methods, but Basler Electric

does not warrant that the software is free from bugs, errors, or other program limitations. Users are encouraged to consult with a Basler Electric representative to determine the accuracy of the data and

results for the specific use or purpose of the user.

Basler Electric

Rev. 1.0; 10/14/02; Initial version, consisting of the following sheets: ComplexCalc, ABC012, Basic Faults, Other Calcs, Graphs, Intermediate Calcs.

Spreadsheet for Performing Complex Number, Sequence Component, and Other Basic Electric System Calculations

By use of this program, the user agrees that Basler Electric disclaims all warranties of noninfringement of third party rights, quality, performance, merchantability, or fitness for a particular purpose. The

user assumes the entire risk as to the quality and performance of the software. In no event will Basler Electric be liable for any indirect, special, or consequential damages. In the event of any litigation

regarding this software, the user agrees that the venue shall be the State of Illinois.

Revision Notes:

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other message, see the instructions above.

100+100i

This spreadsheet is intended to assist in the performance of various calculations associated with electric power flow. It is essentially a complex number and sequence components calculator and a

shortcut to do a few other basic calculations.

Phone: 618/654-2341 - Fax: 618/654-2351 - Website: http://www.basler.com

Instructions, Notes

=> See each sheet for instructions specific to that sheet.

=> This spreadsheet is best viewed at 1024x768 or higher resolution. To fit everything on one screen some sheets use <100% zoom. If one has a higher resolution monitor, one might raise the zoom

control to 100% for clearer viewing.

=> This sheet uses complex number functions from the Excel Analysis ToolPak. Enable the Analysis ToolPak feature from the Excel menu "Tools/Add-Ins." If the Analysis ToolPak is not

listed as an available Add-In, then likely only a partial installation of Excel has been done on your machine. The Analysis ToolPak is distributed with Excel, but it is an optional component

that might not be installed in a partial installation of Excel. See test below to verify the complex number functions are working correctly.

=> Though locking and protection is used in much of the the spreadsheet, there is no password protection. If one has obtained this spreadsheet from third party source, be aware of possible changes to

calculations that may have been done, and keep a backup copy of the original spreadsheet in case one inadvertently changes a calculation for the worse.

=> All macros re-enable protection; editing the macros is the only way to stop this.

=> Most calculations are done on the Intermediate Calcs sheet and macros are used to copy data to the various other sheets.

=> Send comments on this spreadsheet to "[email protected]"

Basler Electric Company, P.O. Box 269, Highland, Illinois USA 62249

Rev. 2.0: 10/18/04; Added more per unit calcs on "Other Calcs" sheet. Added the blank "User's Calcs" sheet. Added "Z,ABC<>012" sheet. Renamed some sheets.

Rev. 3.0: 03/06; Added "Z=OHL" sheet using simplified Carson's equation from Wagner and Evans.

Rev. 1.1; 09/03; ABC012 sheet: gave explanation of xfmr theory, added mag * & / 1.732 calc, revised a few default field views.

(2)

Real

Imaginary

Rect<=>Polar

Magnitude

Degrees

+/-, Conjugate, Clear

Copy Data to:

Quantity 1

3.00000

4.00000

5.00000

53.130 Quantity 2

3.00000

4.00000

5.00000

53.130 Memory 1

3.00000

4.00000

5.00000

53.130 Memory 2

Memory 3

Memory 4

Calculate:

Calc Results:

Real

Imaginary

Magnitude

Degrees

Copy results to:

Q1 / Q2

1.00000

0.00000

1.00000

0.000 User Notes:

Basic Complex Number Calculator

100+100i

Instructions/Notes:

=> Click on red arrows to convert between rectangular and polar formats, and click on M1/2/3/4 and Q1/2 to copy data from field to field as indicated. Click on Q1<=>Q2 to

exchange Q1 and Q2 data.

=> After entering rectangular Q1 and Q2 data, click on the indicated function boxes to see the appropriate information in the "Calc Results" field.

=> Almost all calculations are done on the "Intermediate Calcs" sheet and macros involving calculations are simply copying data from the Intermediate Calcs page.

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other

message, or you see "#VALUE!" messages on this sheet, see the Instructions Sheet for details on enabling Excel's Analysis ToolPak.

Calculations use data in RECTANGULAR FORMAT. If Polar data is entered, click on the Polar to Rect. Conv. button before clicking on a Calculate button.

R<P

R>P

Q1+Q

M

Q

M

Q

M

Q

Q1xQ2

Q1-Q2

Q1<=>Q

Q1/Q2

Q1^2

Sqrt

1/Q1

Cle

+/-

Co

+/-

Co

Q1xQ2

Cle

Q1 ||

Q

Cle

Q

Cle

M

► ◄

2 12/21/2012

121410345.xls.ms_office

(3)

A-B-C Phase Quantities

0-1-2 Sequence Quantities

Real

Imaginary

Magnitude

Degrees

Real

Imaginary

Magnitude

Degrees

Copy data to; Misc. functions:

A-N

415.0000

425.0000

0 Vl-n

B-N

415.0000

425.0000

1 C-N

415.0000

425.0000

2 A-B

0 0.0000

0.0000

0.000 Vl-l

B-C

1 C-A

0.0000

0.000

2 A

0 I

B

1 C

2 A

0 Mem 1

B

1 C

2 A

0 Mem 2

B

1 C

2 Voltage Xfmr Effects on V and I

Current Xfmr Effects on I

1 CT ratio (N:1):

1

30 for N:5 ratio, N=

5 (NOTE: VT Calcs Use ABC-Rect. Data)

(CT Calcs Use ABC-Rect. Data)

Secondary

Quantities

Real

Imaginary

Magnitude

Degrees

Real

Imaginary

Magnitude

Degrees

Copy to:

A-N

0 Vl-n

B-N

1 C-N

2 A-B

0 Vl-l

B-C

1 C-A

2 A

0 I

B

1 C

2 User Notes:

Basic Sequence Components Calculator and Converter

Pos.Seq. Phase shift; Pri.=>Sec.

Pri./Sec. ph./ph. voltage ratio:

Instructions/Notes:

=> The spreadsheet implements the classical phase to sequence and sequence to phase calculations (see cell H4 and O4 comments), along with polar/rectangular conversion.

=> Green and yellow are user input fields. Yellow indicates a field used in the Transformer Effects calculations.

=> Vca and Vll-Vo are not user inputs because: a) two Vl-l quantities define the third. Vca was selected as defined by equation. b) Vl-l has no ground reference and hence no Vo.

=> Transformer effect calculations use ABC-Rectangular data in yellow fields.

=> See notes in cell D28 for an explanation of the Voltage Xfmr Effects calculations.

=> The spreadsheet accepts any voltage transformer phase shift, even one that is physically impossible. Use your good judgment when entering phase shifts.

=> The calculations Mem1 = V x I* (= S) and Mem2 = I + Mem1 (= Isum, for differential applications) use ABC-Rectangular format data.

=> CT secondary calculations for delta connections are for lines outside of the delta.

100+100i

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other message, or you see "#VALUE!" messages on this sheet, see the

Instructions Sheet for details on enabling Excel's Analysis ToolPak.

A-B-C Phase Quantities

0-1-2 Sequence Quantites

M2

M1

M2

M1

Vl-l

Vl-n

+/-

Clear

All Other Xfmr

Config.

Wye-Gnd /

Wye-Gnd

Wye Sec.

no phase

shift

Delta A-C Sec.

I1,I2@-/+30deg

Io blocked

M2

M1

Clear Secondary Data

M2

M1

M2

M1

I

Vl-l

Vl-n

I

Clear

M2

M1

+/-

Delta A-B Sec.

I1,I2@+/-30deg

Io blocked

Vl-n

Vl-l

I

Convert

Mem2 = I + Mem1 (using ABC-Rect.

Mem1 = Vln x I* (using ABC-Rect. data)

Clear

(4)

Series Impedance of Medium Length Overhead Lines

Presently Selected Unit System:

Units

Frequency for impedance calculations:

Hz

60 Total Line Length:

mile(s)

1 Ground Resistivity:

Ohm-meters

100 Phase A

ohms/mile

0.11720

feet

0.03730

feet

0.00 feet

29.00 Phase B

ohms/mile

0.11720

feet

0.03730

feet

-5.00

feet

25.00 Phase C

ohms/mile

0.11720

feet

0.03730

feet

0.00 feet

21.00 Neutral 1

ohms/mile

0.30000

feet

0.02000

feet

-2.50

feet

35.00 Neutral 2

ohms/mile

0.30000

feet

0.02000

feet

-2.00

feet

15.00 100+100i

User Notes:

Horizontal Distance from Ph A (X)

Height above Ground (Y)

Resistance per unit length (Ra)

Conductor Radius (Ds or GMR)

Horizontal Distance from Ph A (X)

=>This sheet calculates the series impedance of overhead lines using the processes described in the paper, "Zero Sequence Impedance of Overhead Transmission Lines" (see www.basler.com).

=> The spreadsheet uses a simplifed equation for the ground loop reported by many texts. See the referenced paper for the equation.

=> If any wire (phase or ground) does not exist, either enter a very high resistance or 0 resistance for that wire. The spreadsheet checks if R<0.00001 per unit length, and if so, it uses R =1E+6 per unit length instead.

=> The X position of A phase relative to the ground plane is the X reference, so XA is fixed at 0. The X position of B, C, and N1 and N2 can be positive or negative. The calculations and X and Y input accept any conductor

orientation. There is no requirement on the order of conductors; e.g., phase A could be the lowest, highest, the farthest to the right or the left, or anywhere in between. The only limitation is that phase A is expected to be at X = 0

and is the reference against which the XB, XC, XN1, and XN2 coordinates are measured, and that Y is positive for all conductors.

=> This sheet does not calculate the effective diameter of bundled conductors. This is an easy calculation (see referenced paper) and is left to the user to apply and then enter the appropriate value in the cells.

=> The spreadsheet will not support more than 2 ground wires, nor does it calculate the mutual impedance with a parallel line, nor does it calculate the impedance of 2+ parallel lines.

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other message, or you see "#VALUE!" messages on this sheet, see the

Conductor Radius (Ds or GMR)

Horizontal Distance from Ph A (X)

Height above Ground (Y)

Instructions/Notes:

Note 1: The equations use a simplified equation for the ground loop impedance that is a partial implementation of what is referred to as Carson's Equations. See referenced paper for discussion. If one expects results that mimic

Carson's Equations then one should obtain a professionally written package that fully implements those equations.

Note 2: This sheet was first provided in Rev 3 of this spreadsheet. The results have not been deeply checked against a professionally written software package. Use the results with caution.

Conductor Radius (Ds or GMR)

Horizontal Distance from Ph A (X)

Height above Ground (Y)

Resistance per unit length (Ra)

Conductor Radius (Ds or GMR)

Height above Ground (Y)

Resistance per unit length (Ra)

Do you wish to enter data in miles and feet

(English); or kilometers and meters (SI-MKS)?

English

Resistance per unit length (Ra)

Conductor Radius (Ds or GMR)

X Dimension; = 0 for A phase

Height above Ground (Y)

Resistance per unit length (Ra)

0

5

10

15

20

25

30

35

40 Hei

gh

t

A

bo

v

e

G

roun

d

English

SI-MKS

(5)

(6)

The impedance of the total line length in ohms:

Magnitude

Degrees

Magnitude

Degrees

0.9187

77.68 0.2946

74.96 ZABC =

0.2940

74.90 0.9350

78.08 0.2659

73.52 0.2940

74.92 The impedances in the above matrix refer to the ABC domain impedances below:

Resultant Symmetrical Component Domain Impedances in ohms

Magnitude

Degrees

Magnitude

Degrees

1.4920

76.53 0.0161

-24.23

Z012 =

0.0155

-150.77

0.6396

79.28 0.0153

-24.91

0.0132

23.31 Z1, Z2 using K*ln(GMD/GMR) and phase A wire R, GMR

The impedances in the above matrix refer to the 012 domain impedances below.

Z00, Z11, and Z22 are the values commonly referred to as Z0, Z1, and Z2.

=>This sheet calculates the series impedance of overhead lines using the processes described in the paper, "Zero Sequence Impedance of Overhead Transmission Lines" (see www.basler.com).

=> The spreadsheet uses a simplifed equation for the ground loop reported by many texts. See the referenced paper for the equation.

=> If any wire (phase or ground) does not exist, either enter a very high resistance or 0 resistance for that wire. The spreadsheet checks if R<0.00001 per unit length, and if so, it uses R =1E+6 per unit length instead.

=> The X position of A phase relative to the ground plane is the X reference, so XA is fixed at 0. The X position of B, C, and N1 and N2 can be positive or negative. The calculations and X and Y input accept any conductor

orientation. There is no requirement on the order of conductors; e.g., phase A could be the lowest, highest, the farthest to the right or the left, or anywhere in between. The only limitation is that phase A is expected to be at X = 0

and is the reference against which the XB, XC, XN1, and XN2 coordinates are measured, and that Y is positive for all conductors.

=> This sheet does not calculate the effective diameter of bundled conductors. This is an easy calculation (see referenced paper) and is left to the user to apply and then enter the appropriate value in the cells.

=> The spreadsheet will not support more than 2 ground wires, nor does it calculate the mutual impedance with a parallel line, nor does it calculate the impedance of 2+ parallel lines.

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other message, or you see "#VALUE!" messages on this sheet, see the

Instructions/Notes:

Note 1: The equations use a simplified equation for the ground loop impedance that is a partial implementation of what is referred to as Carson's Equations. See referenced paper for discussion. If one expects results that mimic

Carson's Equations then one should obtain a professionally written package that fully implements those equations.

Note 2: This sheet was first provided in Rev 3 of this spreadsheet. The results have not been deeply checked against a professionally written software package. Use the results with caution.

A

B

C

N1

N2

0

5

10

15

20

25

30

35

40 -6

-4

-2

0 X Distance from Ph A

Conductor Locations

(7)

(8)

Conductor X, Y coordinates

Magnitude

Degrees

X

Y

0.2658

73.51 A

0

29 0.2933

74.85 B

-5

25 0.9167

77.63 C

0

21 The impedances in the above matrix refer to the ABC domain impedances below:

N1

-2.5

35 N2

-2

15 Separation between conductors (feet).

dX

dY

Total

A-B

5.00

4.00

6.40 A-C

0.00

8.00

8.00 A-N1

2.50 -6.00

6.50 Resultant Symmetrical Component Domain Impedances in ohms

A-N2

2.00

14.00

14.14 Magnitude

Degrees

B-C

-5.00

4.00

6.40 0.0162

-150.40

B-N1

-2.50

-10.00

10.31 0.0134

141.55 B-N2

-3.00

10.00

10.44 0.6396

79.28 C-N1

2.50

14.00

14.22 0.6441

79.52 C-N2

2.00

6.00

6.32 The impedances in the above matrix refer to the 012 domain impedances below.

N1-N2

-0.50

20.00

20.01 Z00, Z11, and Z22 are the values commonly referred to as Z0, Z1, and Z2.

GMD, Phase Conductors, (feet).

6.90 =>This sheet calculates the series impedance of overhead lines using the processes described in the paper, "Zero Sequence Impedance of Overhead Transmission Lines" (see www.basler.com).

=> The spreadsheet uses a simplifed equation for the ground loop reported by many texts. See the referenced paper for the equation.

=> If any wire (phase or ground) does not exist, either enter a very high resistance or 0 resistance for that wire. The spreadsheet checks if R<0.00001 per unit length, and if so, it uses R =1E+6 per unit length instead.

=> The X position of A phase relative to the ground plane is the X reference, so XA is fixed at 0. The X position of B, C, and N1 and N2 can be positive or negative. The calculations and X and Y input accept any conductor

orientation. There is no requirement on the order of conductors; e.g., phase A could be the lowest, highest, the farthest to the right or the left, or anywhere in between. The only limitation is that phase A is expected to be at X = 0

and is the reference against which the XB, XC, XN1, and XN2 coordinates are measured, and that Y is positive for all conductors.

=> This sheet does not calculate the effective diameter of bundled conductors. This is an easy calculation (see referenced paper) and is left to the user to apply and then enter the appropriate value in the cells.

=> The spreadsheet will not support more than 2 ground wires, nor does it calculate the mutual impedance with a parallel line, nor does it calculate the impedance of 2+ parallel lines.

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other message, or you see "#VALUE!" messages on this sheet, see the

Instructions/Notes:

Note 1: The equations use a simplified equation for the ground loop impedance that is a partial implementation of what is referred to as Carson's Equations. See referenced paper for discussion. If one expects results that mimic

Carson's Equations then one should obtain a professionally written package that fully implements those equations.

(9)

(10)

(11)

System Data:

Magnitude

Degrees

E prefault

0 Magnitude

Degrees

Z0

Z1

Z2

Zf

Zn

Fault Calculations

Three Phase

A phase to ground

Phase B to Phase C

In Fault

Mag

Degrees

Mag

Degrees

Mag

Degrees

I-a

I-b

I-c

I-0

I-1

I-2

Other side of Xfmr

Mag

Degrees

Mag

Degrees

Mag

Degrees

I-a

I-b

I-c

I-0

I-1

I-2

User Notes:

and then converting to ABC quantities.

Basic Fault Calculator

100+100i

I-3ph:

I1 = E/(Z1+Zf)

I-B to C:

I1 = -I2 = E/(Z1+Z2+Zf)

Instructions:

=> Enter in the appropriate info in the System Data fields, an then press the "Calculate" button.

=> The spreadsheet is simply performing the classical fault calculations given below:

I-A to Gnd:

I1 = I2 = I0 = E/(Z1+Z2+Z0+3Zf+3Zn)

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain

"100+100i." If it says "#NAME?" or any other message, or you see "#VALUE!" messages on this

sheet, see the Instructions Sheet for details on enabling Excel's Analysis ToolPak.

Z-fault

E-prefault

Z-system

30 o

_Lead

I-fault

Zn

Calculate

Clear All

11 12/21/2012

121410345.xls.ms_office

(12)

Given Es, Er:

Magnitude

Degrees

Magnitude

Degrees

Es

0.0000

Z-line

Er

Given Es, I:

Solution is for:

Magnitude

Degrees

Es

0.0000

Watts

VAR

VA

Power Fact.

I

Ss

Sr

Given Er, I:

Sline

Magnitude

Degrees

Real

Imaginary

Mag.

Degrees

Er

0.0000

Es

I

Er

Es-Er

Given Es, Ss:

I

Magnitude

Degrees

Es

0.0000

Watts

VARs

Coverted Values

Ss

Given Er, Sr:

Magnitude

Degrees

Er

0.0000

Watts

VARs

Sr

User Notes:

Instructions:

=> Enter in the basic data in the appropriate fields, and then press the appropriate "Calculate" button.

=> The load flow calculations are simple manipulations of S = E x I* and E = I x Z in complex number format. Macros just copy data from the Intermediate Calcs sheet to this sheet.

=> Calculations are for balanced systems (i.e., single phase represents all three phases).

=> Calculations use per unit voltages and currents, so that S = E x I* (e.g., the equation S = Sqrt(3) x El-l x I* is NOT used).

=> Generally Es or Er is the reference angle against which other angles are measured and 0 is degrees would normally be used for Es (or Er), so the angle for Es and Er defaults to 0

degrees. However, the angle for Es and Er can be set to other than 0 and the entered angle will be used in the calculations.

If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain "100+100i." If it says "#NAME?" or any other message, or you see

"#VALUE!" messages on this sheet, see the Instructions Sheet for details on enabling Excel's Analysis ToolPak.

Z-base

Ohms PU

Current PU

MVA PU

Add the Window's Scientific Calculator to your Excel Toolbar:

1) Click through the Excel menu tree: Tools/Customize.

2) Select the "Commands" tab, then in the "Categories" list click on "Tools."

3) In the scroll-down list of "Commands," there will be a few items that are simply named "Custom."

Select the "Custom" command that has an icon that looks like a little calculator. Left click on it and

drag it to somewhere in your toolbars.

4) Click on Close.

5) If you want to remove the icon later, repeat step 1, left click on the icon and drag it off the toolbar.

KV, Line to Gnd

Miscellaneous Other Calcs:

X/R to Angle

Converter:

VA/PF to

Watt/VAR

Per Unit / Base Calculations

Given Current Value

Given Ohmic Value

Given MVA Value

Basic Voltage Drop & Load Flow Calculator

100+100i

I-base

kV Base, L-L

Three Phase

MVA base, 3ph

Z-line

Es

I, Ss

Er

I, Sr

Calculate

Clear Load Flow

(13)

Graph Data

Real

Imaginary

Graph Data

Real

Imaginary

Graph Data

Real

Imaginary

Van

0.000

0.000 Phasor Origin (0)

V0,ln

0.000

0.000 Phasor Origin (0)

Q1

0

0 Phasor Origin (0)

415.000

425.000 Phasor End Point

0.000

0.000 Phasor End Point

3

4 Phasor End Point

Vbn

0.000

0.000 Phasor Origin (0)

V1,ln

0.000

0.000 Phasor Origin (0)

Q2

0

0 Phasor Origin (0)

415.000

425.000 Phasor End Point

0.000

0.000 Phasor End Point

3

4 Phasor End Point

Vcn

0.000

0.000 Phasor Origin (0)

V2,ln

0.000

0.000 Phasor Origin (0)

Calc

0

0 Phasor Origin (0)

415.000

425.000 Phasor End Point

0.000

0.000 Phasor End Point

1

0 Phasor End Point

Vab

0.000

0.000 Phasor Origin (0)

V1,ll

0.000

0.000 Phasor Origin (0)

0.000

0.000 Phasor End Point

0.000

0.000 Phasor End Point

Vbc

0.000

0.000 Phasor Origin (0)

V2,ll

0.000

0.000 Phasor Origin (0)

0.000

0.000 Phasor End Point

0.000

0.000 Phasor End Point

Vca

0.000

0.000 Phasor Origin (0)

I0

0.000

0.000 Phasor Origin (0)

0.000

0.000 Phasor End Point

0.000

0.000 Phasor End Point

Ia

0.000

0.000 Phasor Origin (0)

I1

0.000

0.000 Phasor Origin (0)

0.000

0.000 Phasor End Point

0.000

0.000 Phasor End Point

Ib

0.000

0.000 Phasor Origin (0)

I2

0.000

0.000 Phasor Origin (0)

0.000

0.000 Phasor End Point

0.000

0.000 Phasor End Point

Ic

0.000

0.000 Phasor Origin (0)

0.000

0.000 Phasor End Point

Graphs

Instructions; Setting graph plot ranges:

Between limitations in the Excel plotting/graphing functions and the varieties of plots that might be desired, only a few starting point graphs are provided below. To use these graphs one task that will likely be needed is to

adjust the min and max of the X and Y scales to be the same so the graphs will look "correct" for a polar type view. To set Xmax/min and Ymax/min, double left click on each axis (real and imaginary), and select the 'scale'

tab on the screen that pops up, then set the min and max values.

-20

-15

-10

-5

0

5

10

15

20 -20

-10

0

10

20 Im

ag

ina

ry

Real

Graph of Q1, Q2, Calc Results from Complex Calc Sheet

Q1

Q2

Calc

-5

-4

-3

-2

-1

0

1

2

3

4

5 -5

-3

-1

1

3

5 Im

ag

ina

ry

Real

Graph of Vln, Vll, I in ABC Format

Van

Vbn

Vcn

Vab

Vbc

Vca

Ia

Ib

Ic

-5

-4

-3

-2

-1

0

1

2

3

4

5 -5

-3

-1

1

3

5 Im

ag

in

ary

Real

Graph of Vln, Vll, I in 012 format

V0,ln

V1,ln

V2,ln

V1,ll

V2,ll

I0

I1

I2

13 12/21/2012

121410345.xls.ms_office

(14)

Named Ranges List

a_1 =IMCalcs!$H$276

Complex Calc Sheet. Data to be copied when the appropriate macro is run. a_2 =IMCalcs!$H$277

Rect. Conversion from polar data Polar Conversion from rect. Data abc_i.012 ='V&I,ABC<>012'!$K$16:$O$18

Real Imaginary Magnitude Degrees abc_i.012.p ='V&I,ABC<>012'!$N$16:$O$18

Quantity 1 3.000000 4.000000 5.000000 53.130102 abc_i.012.r ='V&I,ABC<>012'!$K$16:$L$18

abc_i.abc ='V&I,ABC<>012'!$D$16:$H$18

Quantity 2 3.000000 4.000000 5.000000 53.130102 abc_i.abc.p ='V&I,ABC<>012'!$G$16:$H$18

abc_i.abc.r ='V&I,ABC<>012'!$D$16:$E$18

Real Imaginary Magnitude Angle abc_mem1.012 ='V&I,ABC<>012'!$K$21:$O$23

Q1 + Q2 6.000000 8.000000 10.000000 53.130102 +/- Q1 -3.000000 -4.000000 5.000000 -126.869898abc_mem1.12 ='V&I,ABC<>012'!$K$22:$O$23

Q1 - Q2 0.000000 0.000000 0.000000 0.000000 Q1 Conjugate 3.000000 -4.000000 5.000000 -53.130102abc_mem1.ab ='V&I,ABC<>012'!$D$21:$H$22

Q1 x Q2 -7.000000 24.000000 25.000000 106.260205 +/- Q2 -3.000000 -4.000000 5.000000 -126.869898abc_mem1.abc ='V&I,ABC<>012'!$D$21:$H$23

Q1 / Q2 1.000000 0.000000 1.000000 0.000000 Q2 Conjugate 3.000000 -4.000000 5.000000 -53.130102abc_mem2.012 ='V&I,ABC<>012'!$K$24:$O$26

Q1^2 -7.000000 24.000000 25.000000 106.260205 New Q1 3.000000 4.000000 5.000000 53.130102abc_mem2.12 ='V&I,ABC<>012'!$K$25:$O$26

Sqrt(Q1) 2.000000 1.000000 2.236068 26.565051 Q1<=>Q2 abc_mem2.ab ='V&I,ABC<>012'!$D$24:$H$25

1/Q1 0.120000 -0.160000 0.200000 -53.130102 New Q2 3.000000 4.000000 5.000000 53.130102abc_mem2.abc ='V&I,ABC<>012'!$D$24:$H$26

Q1 x Q2* 25.000000 0.000000 25.000000 0.000000 abc_results.012 ='V&I,ABC<>012'!$K$35:$O$43 Q1 || Q2 1.500000 2.000000 2.500000 53.130102 abc_results.abc ='V&I,ABC<>012'!$D$35:$H$43 abc_results.ix.012 ='V&I,ABC<>012'!$K$41:$O$43 abc_results.ix.abc ='V&I,ABC<>012'!$D$41:$H$43 abc_results.vx.vll.012 ='V&I,ABC<>012'!$K$38:$O$40 abc_results.vx.vll.12 ='V&I,ABC<>012'!$K$39:$O$40 abc_results.vx.vll.ab ='V&I,ABC<>012'!$D$38:$H$39

V&I,ABC<>012 Sheet. Data to be copied when the appropriate macro is run. abc_results.vx.vll.abc ='V&I,ABC<>012'!$D$38:$H$40

Vl-n ABC rectangular conversions A-B-C Quantities 0-1-2 Sequence Quantities abc_results.vx.vln.012 ='V&I,ABC<>012'!$K$35:$O$37

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees abc_results.vx.vln.abc ='V&I,ABC<>012'!$D$35:$H$37

A-N 415.000000 425.000000 594.011784 45.682060 0 415.000000 425.000000 594.011784 45.682060abc_vll.012 ='V&I,ABC<>012'!$K$11:$O$13

Vl-n B-N 415.000000 425.000000 594.011784 45.682060 1 0.000000 0.000000 0.000000 0.000000abc_vll.12 ='V&I,ABC<>012'!$K$12:$O$13

C-N 415.000000 425.000000 594.011784 45.682060 2 0.000000 0.000000 0.000000 0.000000abc_vll.12.p ='V&I,ABC<>012'!$N$12:$O$13

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000abc_vll.12.r ='V&I,ABC<>012'!$K$12:$L$13

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000abc_vll.ab ='V&I,ABC<>012'!$D$11:$H$12

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000abc_vll.ab.p ='V&I,ABC<>012'!$G$11:$H$12

Vl-n ABC polar conversions A-B-C Quantities 0-1-2 Sequence Quantities abc_vll.ab.r ='V&I,ABC<>012'!$D$11:$E$12

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees abc_vll.abc ='V&I,ABC<>012'!$D$11:$H$13

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000abc_vln.012 ='V&I,ABC<>012'!$K$6:$O$8

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000abc_vln.012.p ='V&I,ABC<>012'!$N$6:$O$8

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000abc_vln.012.r ='V&I,ABC<>012'!$K$6:$L$8

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000abc_vln.abc ='V&I,ABC<>012'!$D$6:$H$8

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000abc_vln.abc.p ='V&I,ABC<>012'!$G$6:$H$8

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000abc_vln.abc.r ='V&I,ABC<>012'!$D$6:$E$8

Vl-n 012 rectangular conversions A-B-C Quantities 0-1-2 Sequence Quantities bf_all.results ='Basic Faults'!$B$16:$L$34

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees cc_m1 =ComplexCalc!$D$9:$H$9

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000cc_m2 =ComplexCalc!$D$10:$H$10

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000cc_m3 =ComplexCalc!$D$11:$H$11

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000cc_m4 =ComplexCalc!$D$12:$H$12

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000cc_q1 =ComplexCalc!$D$5:$H$5

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000cc_q1.polar =ComplexCalc!$G$5:$H$5

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000cc_q1.rect =ComplexCalc!$D$5:$E$5

Vl-n 012 polar conversions A-B-C Quantities 0-1-2 Sequence Quantities cc_q1q2 =ComplexCalc!$D$5:$H$7

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees cc_q2 =ComplexCalc!$D$7:$H$7

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000cc_q2.polar =ComplexCalc!$G$7:$H$7

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000cc_q2.rect =ComplexCalc!$D$7:$E$7

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000cc_results =ComplexCalc!$B$17:$H$17

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000cc_results.data.only =ComplexCalc!$D$17:$H$17

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.cc_1.over.q1 =IMCalcs!$B$18:$H$18

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.cc_plusminus.q1 =IMCalcs!$K$12:$O$12

Vl-l ABC rectangular conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.cc_plusminus.q2 =IMCalcs!$K$14:$O$14

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.cc_q1.conjugate =IMCalcs!$K$13:$O$13

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.cc_q1.divide.q2 =IMCalcs!$B$15:$H$15

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.cc_q1.minus.q2 =IMCalcs!$B$13:$H$13

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.cc_q1.over.q2 =IMCalcs!$B$18:$H$18

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.cc_q1.parallel.q2 =IMCalcs!$B$20:$H$20

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.cc_q1.plus.q2 =IMCalcs!$B$12:$H$12

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.cc_q1.polar.conv.from.rect =IMCalcs!$G$7:$H$7

Vl-l ABC polar conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.cc_q1.q2.exchange =IMCalcs!$K$16:$O$18

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.cc_q1.rect.conv.from.polar =IMCalcs!$D$7:$E$7

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.cc_q1.squared =IMCalcs!$B$16:$H$16

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.cc_q1.x.q2 =IMCalcs!$B$14:$H$14

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.cc_q1.x.q2conjugate =IMCalcs!$B$19:$H$19

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.cc_q2.conjugate =IMCalcs!$K$15:$O$15

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.cc_q2.polar.conv.from.rect =IMCalcs!$G$9:$H$9

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.cc_q2.rect.conv.from.polar =IMCalcs!$D$9:$E$9

Vl-l 012 rectangular conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.cc_sqrt.q1 =IMCalcs!$B$17:$H$17

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.complexcheck.i =IMCalcs!$D$730

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.complexcheck.r =IMCalcs!$C$730

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.fault_all.results =IMCalcs!$B$221:$L$239

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.i.012.p_012.p =IMCalcs!$N$108:$O$110

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.i.012.p_012.r =IMCalcs!$K$108:$L$110

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.i.012.p_abc.p =IMCalcs!$G$108:$H$110

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.i.012.p_abc.r =IMCalcs!$D$108:$E$110

Vl-l 012 polar conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.i.012.r_012.p =IMCalcs!$N$103:$O$105

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.i.012.r_012.r =IMCalcs!$K$103:$L$105

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.i.012.r_abc.p =IMCalcs!$G$103:$H$105

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.i.012.r_abc.r =IMCalcs!$D$103:$E$105

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.i.abc.p_012.p =IMCalcs!$N$98:$O$100

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.i.abc.p_012.r =IMCalcs!$K$98:$L$100

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.i.abc.p_abc.p =IMCalcs!$G$98:$H$100

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.i.abc.p_abc.r =IMCalcs!$D$98:$E$100

I ABC rectangular conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.i.abc.r_012.p =IMCalcs!$N$93:$O$95

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.i.abc.r_012.r =IMCalcs!$K$93:$L$95

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.i.abc.r_abc.p =IMCalcs!$G$93:$H$95

Vl-n B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.i.abc.r_abc.r =IMCalcs!$D$93:$E$95

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.i_plusminus.012 =IMCalcs!$K$123:$O$125

I ABC polar conversions A-B-C Quantities ic.i_plusminus.abc =IMCalcs!$D$123:$H$125

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.isum3_012 =IMCalcs!$K$170:$O$172

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.isum3_abc =IMCalcs!$D$170:$H$172

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.ix.dab_012 =IMCalcs!$K$155:$O$157

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.ix.dab_abc =IMCalcs!$D$155:$H$157

I 012 rectangular conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.ix.dac_012 =IMCalcs!$K$160:$O$162

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.ix.dac_abc =IMCalcs!$D$160:$H$162

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.ix.yy_012 =IMCalcs!$K$150:$O$152

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.ix.yy_abc =IMCalcs!$D$150:$H$152

This sheet contains intermediate calculations for display on other pages.

(15)

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.lf_er.i =IMCalcs!$H$194:$L$203

I 012 polar conversions A-B-C Quantities 0-1-2 Sequence Quantities ic.lf_er.sr =IMCalcs!$H$182:$L$191

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.lf_es.er =IMCalcs!$B$182:$F$191

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.lf_es.i =IMCalcs!$B$206:$F$215

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.lf_es.ss =IMCalcs!$B$194:$F$203

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.s3_012 =IMCalcs!$K$165:$O$167

+/- Vl-n A-B-C Quantities 0-1-2 Sequence Quantities ic.s3_abc =IMCalcs!$D$165:$H$167

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vll.012.p_vll.12.p =IMCalcs!$N$89:$O$90

A-N -415.000000 -425.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.012.p_vll.12.r =IMCalcs!$K$89:$L$90

Vl-n B-N -415.000000 -425.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.012.p_vll.ab.p =IMCalcs!$G$88:$H$89

C-N -415.000000 -425.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll.012.p_vll.ab.r =IMCalcs!$D$88:$E$89

+/- Vl-l A-B-C Quantities 0-1-2 Sequence Quantities ic.vll.012.p_vln.012.p =IMCalcs!$N$85:$O$87

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vll.012.p_vln.012.r =IMCalcs!$K$85:$L$87

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.012.p_vln.abc.p =IMCalcs!$G$85:$H$87

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.012.p_vln.abc.r =IMCalcs!$D$85:$E$87

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll.012.r_vll.12.p =IMCalcs!$N$81:$O$82

+/- I A-B-C Quantities 0-1-2 Sequence Quantities ic.vll.012.r_vll.12.r =IMCalcs!$K$81:$L$82

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vll.012.r_vll.ab.p =IMCalcs!$G$80:$H$81

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.012.r_vll.ab.r =IMCalcs!$D$80:$E$81

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.012.r_vln.012.p =IMCalcs!$N$77:$O$79

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll.012.r_vln.012.r =IMCalcs!$K$77:$L$79

Voltage Xfmr ic.vll.012.r_vln.abc.p =IMCalcs!$G$77:$H$79

Wye-Wye Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vll.012.r_vln.abc.r =IMCalcs!$D$77:$E$79

A-N 415.000000 425.000000 594.011784 45.682060 0 415.000000 425.000000 594.011784 45.682060ic.vll.abc.p_vll.12.p =IMCalcs!$N$73:$O$74

Vl-n B-N 415.000000 425.000000 594.011784 45.682060 1 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vll.12.r =IMCalcs!$K$73:$L$74

C-N 415.000000 425.000000 594.011784 45.682060 2 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vll.ab.p =IMCalcs!$G$72:$H$73

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vll.ab.r =IMCalcs!$D$72:$E$73

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vln.012.p =IMCalcs!$N$69:$O$71

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vln.012.r =IMCalcs!$K$69:$L$71

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vln.abc.p =IMCalcs!$G$69:$H$71

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.abc.p_vln.abc.r =IMCalcs!$D$69:$E$71

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll.abc.r_vll.12.p =IMCalcs!$N$65:$O$66

Voltage Xfmr ic.vll.abc.r_vll.12.r =IMCalcs!$K$65:$L$66

Other Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vll.abc.r_vll.ab.p =IMCalcs!$G$64:$H$65

A-N 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.abc.r_vll.ab.r =IMCalcs!$D$64:$E$65

Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.abc.r_vln.012.p =IMCalcs!$N$61:$O$63

C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll.abc.r_vln.012.r =IMCalcs!$K$61:$L$63

A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll.abc.r_vln.abc.p =IMCalcs!$G$61:$H$63

Vl-l B-C 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vll.abc.r_vln.abc.r =IMCalcs!$D$61:$E$63

C-A 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vll_plusminus.12 =IMCalcs!$K$119:$O$120

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vll_plusminus.ab =IMCalcs!$D$118:$H$119

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vln.012.p_vll.12.p =IMCalcs!$N$57:$O$58

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vln.012.p_vll.12.r =IMCalcs!$K$57:$L$58

Current Xfmr ic.vln.012.p_vll.ab.p =IMCalcs!$G$56:$H$57

Wye Sec. Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vln.012.p_vll.ab.r =IMCalcs!$D$56:$E$57

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vln.012.p_vln.012.p =IMCalcs!$N$53:$O$55

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vln.012.p_vln.012.r =IMCalcs!$K$53:$L$55

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vln.012.p_vln.abc.p =IMCalcs!$G$53:$H$55

Current Xfmr ic.vln.012.p_vln.abc.r =IMCalcs!$D$53:$E$55

DAB Sec. Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vln.012.r_vll.12.p =IMCalcs!$N$49:$O$50

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vln.012.r_vll.12.r =IMCalcs!$K$49:$L$50

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vln.012.r_vll.ab.p =IMCalcs!$G$48:$H$49

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vln.012.r_vll.ab.r =IMCalcs!$D$48:$E$49

Currrent Xfmr ic.vln.012.r_vln.012.p =IMCalcs!$N$45:$O$47

DAC Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vln.012.r_vln.012.r =IMCalcs!$K$45:$L$47

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vln.012.r_vln.abc.p =IMCalcs!$G$45:$H$47

I B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vln.012.r_vln.abc.r =IMCalcs!$D$45:$E$47

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vln.abc.p_vll.12.p =IMCalcs!$N$41:$O$42

Mem1 = S = V x I* ic.vln.abc.p_vll.12.r =IMCalcs!$K$41:$L$42

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vln.abc.p_vll.ab.p =IMCalcs!$G$40:$H$41

A 0.000000 0.000000 0.000000 45.682060 0 0.000000 0.000000 0.000000 0.000000ic.vln.abc.p_vll.ab.r =IMCalcs!$D$40:$E$41

S B 0.000000 0.000000 0.000000 45.682060 1 0.000000 0.000000 0.000000 0.000000ic.vln.abc.p_vln.012.p =IMCalcs!$N$37:$O$39

C 0.000000 0.000000 0.000000 45.682060 2 0.000000 0.000000 0.000000 0.000000ic.vln.abc.p_vln.012.r =IMCalcs!$K$37:$L$39

Mem2 = Isum = I + Mem1 ic.vln.abc.p_vln.abc.p =IMCalcs!$G$37:$H$39

Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees ic.vln.abc.p_vln.abc.r =IMCalcs!$D$37:$E$39

A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000ic.vln.abc.r_vll.12.p =IMCalcs!$N$33:$O$34

Isum B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000ic.vln.abc.r_vll.12.r =IMCalcs!$K$33:$L$34

C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000ic.vln.abc.r_vll.ab.p =IMCalcs!$G$32:$H$33 ic.vln.abc.r_vll.ab.r =IMCalcs!$D$32:$E$33 ic.vln.abc.r_vln.012.p =IMCalcs!$N$29:$O$31 ic.vln.abc.r_vln.012.r =IMCalcs!$K$29:$L$31 ic.vln.abc.r_vln.abc.p =IMCalcs!$G$29:$H$31 ic.vln.abc.r_vln.abc.r =IMCalcs!$D$29:$E$31 ic.vln_plusminus.012 =IMCalcs!$K$113:$O$115 ic.vln_plusminus.abc =IMCalcs!$D$113:$H$115

Load Flow. Data to be copied when the appropriate macro is run ic.vx.other_012 =IMCalcs!$K$139:$O$147

ic.vx.other_abc =IMCalcs!$D$139:$H$147

Given Es, Er Given Er, Sr ic.vx.yy_012 =IMCalcs!$K$128:$O$136

Watts VAR VA Power Fact. Watts VAR VA Power Fact. ic.vx.yy_abc =IMCalcs!$D$128:$H$136

Ss 0 0 0 0 Ss 0 0 0 0 JJH =IMCalcs!$C$990

Sr 0 0 0 0 Sr 0 0 0 0 lf_results ='Other Calcs'!$F$11:$J$20

Sline 0 0 0 0 Sline 0 0 0 0 m_30 =IMCalcs!$K$676

Real Imaginary Mag. Degrees Real Imaginary Mag. Degrees p_30 =IMCalcs!$K$675

Es 0 0 0 0 Es 0 0 0 0 Print_Area =IMCalcs!$A$1:$R$731

Er 0 0 0 0 Er 0 0 0 0 sqrt3 =IMCalcs!$K$276

Es-Er 0 0 0 0 Es-Er 0 0 0 0

I 0 0 0 0 I 0 0 0 0

Given Es, Ss Given Er, I

Watts VAR VA Power Fact. Watts VAR VA Power Fact.

Ss 0 0 0 0 Ss 0 0 0 0

Sr 0 0 0 0 Sr 0 0 0 0

Sline 0 0 0 0 Sline 0 0 0 0

Real Imaginary Mag. Degrees Real Imaginary Mag. Degrees

Es 0 0 0 0 Es 0 0 0 0

Er 0 0 0 0 Er 0 0 0 0

Es-Er 0 0 0 0 Es-Er 0 0 0 0

I 0 0 0 0 I 0 0 0 0

Given Es, I

Watts VAR VA Power Fact.

Ss 0 0 0 0

(16)

Sr 0 0 0 0

Sline 0 0 0 0

Real Imaginary Mag. Degrees

Es 0 0 0 0

Er 0 0 0 0

Es-Er 0 0 0 0

I 0 0 0 0

Fault Calc. Data to be copies when the appropriate macro is run.

Three Phase A phase to ground Phase B to Phase C

In Fault In Fault In Fault

Mag Degrees Mag Degrees Mag Degrees

I-a 0 0 I-a 0 0 I-a 0.000000 0.000000

I-b 0 0 I-b 0 0 I-b 0.000000 0.000000

I-c 0 0 I-c 0 0 I-c 0.000000 0.000000

I-0 0 0 I-0 0 0 I-0 0 0

I-1 0 0 I-1 0 0 I-1 0 0

I-2 0 0 I-2 0 0 I-2 0 0

Other side of Xfmr Other side of Xfmr Other side of Xfmr

Mag Degrees Mag Degrees Mag Degrees

I-a 0 0 I-a 0 0 I-a 0.000000 0.000000

I-b 0 0 I-b 0 0 I-b 0.000000 0.000000

I-c 0 0 I-c 0 0 I-c 0.000000 0.000000

I-0 0 0 I-0 0 0 I-0 0 0

I-1 0 0 I-1 0 0 I-1 0 0

I-2 0 0 I-2 0 0 I-2 0 0

Complex Calc sheet - calculations

Rectangular to Polar conversions Polar to Rectangular conversions

Complex format Mag Degrees Radians Radians Real Imaginary Q1 3+4i 5.000000 53.130102 0.927295 0.927295 3.000000 4.000000 Q2 3+4i 5.000000 53.130102 0.927295 0.927295 3.000000 4.000000

Math calculations

Restating Data: Real Imaginary Complex Mag Degrees Radians Q1 3.000000 4.000000 3+4i 5.000000 53.130102 0.927295 Q2 3.000000 4.000000 3+4i 5.000000 53.130102 0.927295 Q2 Conjugate 3.000000 -4.000000 3-4i 5.000000 -53.130102 -0.927295

Performing Calcs: Radians, basic calc Simplified Radians

Q1+Q2 6.000000 8.000000 6+8i 10.000000 53.130102 0.927295 Q1-Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000 Q1xQ2 -7.000000 24.000000 -7+24i 25.000000 106.260205 1.854590 1.854590 Q1/Q2 1.000000 0.000000 1 1.000000 0.000000 0.000000 0.000000 Q1^2 -7.000000 24.000000 -7+24i 25.000000 106.260205 1.854590 1.854590 Sqrt(Q1) 2.000000 1.000000 2+i 2.236068 26.565051 0.463648 0.463648 1/Q1 0.120000 -0.160000 0.12-0.16i 0.200000 -53.130102 -0.927295 -0.927295 Q1xQ2conjugate 25.000000 0.000000 25 25.000000 0.000000 0.000000 0.000000 1/Q2 0.120000 -0.160000 0.12-0.16i 0.200000 -53.130102 -0.927295 -0.927295 1/Q1 + 1/ Q2 0.240000 -0.320000 0.24-0.32i 0.400000 -53.130102 -0.927295 -0.927295 Q1||Q2 = 1/[1/Q1 + 1/Q2] 1.500000 2.000000 1.5+2i 2.500000 53.130102 0.927295 0.927295

V&I,ABC<>012 sheet - calculations

Vll Vca Real Imaginary a1, a2 constants: Square Root 3

Vab 0.000000 0.000000 a_1 -0.5+0.866025403784439i sqrt3 1.732050808 Vca, rect. Vbc 0.000000 0.000000 a_2 -0.5-0.866025403784438i

Vca = -sum 0.000000 0.000000 Vab rectangular 0.000000 0.000000

Vca, polar Vac rectangular 0.000000 0.000000 Complex Format Magnitude Degrees Radians Vca = -sum 0.000000 0.000000 0 0.000000 0.000000 0.000000

Given: Real Imaginary Complex Format Magnitude Degrees Radians AN 415.000000 425.000000 415+425i 594.011784 45.682060 0.797302 Vl-n BN 415.000000 425.000000 415+425i 594.011784 45.682060 0.797302 CN 415.000000 425.000000 415+425i 594.011784 45.682060 0.797302 Calculated Line to Line, ABC format

AB 0.000000 0.000000 0 0.000000 0.000000 0.000000 Vl-l BC 0.000000 0.000000 0 0.000000 0.000000 0.000000 CA 0.000000 0.000000 0 0.000000 0.000000 0.000000

ABC to 012 conversion Cmplx ABC Data/3 *a_1 *a_2 Complex 012 Data Real Imaginary Magnitude Degrees Radians AN 138.333333333333+141.666666666667i 0 414.999999999999+425.000000000001i415.000000 425.000000 594.011784 45.682060 0.797302 Vl-n BN 138.333333333333+141.666666666667i-191.853598869462+48.9668475235136i53.5202655361292-190.63351419018i1 2.1316282072803E-13+5.96855898038484E-13i0.000000 0.000000 0.000000 0.000000 0.000000 CN 138.333333333333+141.666666666667i-191.853598869462+48.9668475235136i53.5202655361292-190.63351419018i2 1.98951966012828E-13+6.03961325396085E-13i0.000000 0.000000 0.000000 0.000000 0.000000

AB 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000

Vl-l BC 0 0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000

CA 0 0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

Given: Magnitude Angle Radians Real Imaginary Complex Format

AN 0.000000 0.000000 0 0 0 0

Vl-n BN 0.000000 0.000000 0.000000 0.000000 0.000000 0 CN 0.000000 0.000000 0.000000 0.000000 0.000000 0 Calculated Line to Line, ABC format

AB 0.000000 0.000000 0.000000 0.000000 0.000000 0 Vl-l BC 0.000000 0.000000 0.000000 0.000000 0.000000 0 CA 0.000000 0.000000 0.000000 0.000000 0.000000 0

ABC to 012 conversion Cmplx ABC Data/3 *a_1 *a_2 Complex 012 Data Real Imaginary Magnitude Degrees Radians

AN 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000

Vl-n BN 0 0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000

CN 0 0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

V conversions, starting with Vln ABC polar V conversions, starting with Vln ABC rectangular

(17)

AB 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000

Vl-l BC 0 0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000

CA 0 0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

Given: Real Imaginary Complex Format Magnitude Degrees Radians 0 0.000000 0.000000 0 0.000000 0.000000 0.000000 Vl-n 1 0.000000 0.000000 0 0.000000 0.000000 0.000000 2 0.000000 0.000000 0 0.000000 0.000000 0.000000

012 to ABC conversion Complex 012 data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians

0 0 AN 0 0.000000 0.000000 0.000000 0.000000 0.000000

Vl-n 1 0 0 0 BN 0 0.000000 0.000000 0.000000 0.000000 0.000000

2 0 0 0 CN 0 0.000000 0.000000 0.000000 0.000000 0.000000

Calculated Line to Line, ABC format Magnitude Angle Radians Real Imaginary Complex Format AB 0.000000 0.000000 0.000000 0.000000 0.000000 0 Vl-l BC 0.000000 0.000000 0.000000 0.000000 0.000000 0 CA 0.000000 0.000000 0.000000 0.000000 0.000000 0

V Line to Line, ABC to 012 Conversion Cmplx ABC Data/3 *a_1 *a_2 Complex 012 Data Real Imaginary Magnitude Degrees Radians

AB 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000

Vl-l BC 0 0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000

CA 0 0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

Given: Magnitude Angle Radians Real Imaginary Complex Format 0 0.000000 0.000000 0.000000 0.000000 0.000000 0 Vl-n 1 0.000000 0.000000 0.000000 0.000000 0.000000 0 2 0.000000 0.000000 0.000000 0.000000 0.000000 0