Basler Electric

Spreadsheet for Performing Complex Number, Sequence Component, and Other Basic Electric System Calculations
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.

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.

Purpose of this Spreadsheet

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.

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]"

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, see the instructions above.

Revision Notes:
Rev. 1.0; 10/14/02; Initial version, consisting of the following sheets: ComplexCalc, ABC012, Basic Faults, Other Calcs, Graphs, Intermediate Calcs.
Rev. 1.1; 09/03; ABC012 sheet: gave explanation of xfmr theory, added mag * & / 1.732 calc, revised a few default field views.
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.
Basler Electric Company, P.O. Box 269, Highland, Illinois USA 62249
Phone: 618/654-2341 - Fax: 618/654-2351 - Website: http://www.basler.com

1 03/05/2023 648811814.xls
 Basic Complex Number Calculator
Real Imaginary Rect<=>Polar Magnitude Degrees +/-, Conjugate, Clear Move/Copy Data:
Quantity 1 ◄◄ ►► +/- Conj. Clear Q2 M1 M2 M3 M4

R<P R>P Q1<=>Q2

Quantity 2 ◄◄ ►► +/- Conj. Clear Q1 M1 M2 M3 M4

Memory 1 Clear Q1 Q2

Memory 2 Clear Q1 Q2

Memory 3 Clear Q1 Q2

Memory 4 Clear Q1 Q2

Calculate: Q1+Q2 Q1-Q2 Q1/Q2 Q1xQ2 Q1xQ2* Q1 || Q2 Q1^2 Sqrt Q1 1/Q1

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.
Calc Results: Real Imaginary Magnitude Degrees Copy results to:
Clear Q1 Q2 M1 M2 M3 M4

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
100+100i
message, or you see "#VALUE!" messages on this sheet, see the Instructions Sheet for details on enabling Excel's Analysis ToolPak.

User Notes:

2 03/05/2023 648811814.xls
Basic Sequence Components Calculator and Converter
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 0
Vl-n B-N 1 M1 M2 +/- Clear
C-N 2
Convert Convert Convert Convert

A-B 0 0.0000 0.0000 0.0000 0.000

Vl-l B-C 1 M1 M2 +/- Clear
C-A 0.0000 0.0000 0.000 0.000 2
Convert Convert Convert Convert

A 0
I B 1 M1 M2 +/- Clear
C 2
Convert Convert Convert Convert

A 0 Vl-n Vl-l I Clear

Mem 1 B 1 Mem1 = Vln x I* (using ABC-Rect.
C 2 data)
A 0
Vl-n Vl-l I Clear
Mem 2 B 1 Mem2 = I + Mem1 (using ABC-
C 2 Rect. data)
Voltage Xfmr Effects on V and I Current Xfmr Effects on I
Wye Sec. Delta A-B Sec. Delta A-C Sec.
Pri./Sec. ph./ph. voltage ratio: 1 Wye-Gnd / All Other Xfmr Config. CT ratio (N:1): 1
no phase I1,I2@+/-30deg I1,I2@-/+30deg
Pos.Seq. Phase shift; Pri.=>Sec. 30 Wye-Gnd (Vo & Io blocked) for N:5 ratio, N= 5
shift Io blocked Io blocked
(Transformer Effects Use ABC-Rect. Data)

Secondary A-B-C Phase Quantities 0-1-2 Sequence Quantites Clear Secondary Data
Quantities Real Imaginary Magnitude Degrees Real Imaginary Magnitude Degrees Copy to:
A-N 0
Vl-n B-N 1 M1 M2 Vl-n
C-N 2
A-B 0
Vl-l B-C 1 M1 M2 Vl-l
C-A 2
A 0
I B 1 M1 M2 I
C 2

Notes / Instructions:
=> 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.

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
100+100i
the Instructions Sheet for details on enabling Excel's Analysis ToolPak.
User Notes:

3 03/05/2023 648811814.xls
Zabc to Z012 Conversion
The calculations on page are intended for use in conjunction with reading the paper found on the Basler Electric web site, "A
Theory and Symmatrical Component Networks." This page performs the Z012 to Zabc and Zabc to Z012 conversions discu
uncommon for this calculation to be done in the hand-calculations that this spreadsheet is mainly supporting, so is more of a

Enter the Symmetrical Component Domain Impedances Enter the ABC Domain Impedances
Magnitude Degrees Magnitude Degrees Magnitude Degrees Magnitude
10.000 50.00 0.000 0.00 0.000 0.00 5.197
Z012 = 0.000 0.00 4.000 75.00 0.000 0.00 ZABC = 2.821
0.000 0.00 0.000 0.00 2.000 80.00 2.243

Resultant ABC Domain Impedances Resultant Symmetrical Component Do

Magnitude Degrees Magnitude Degrees Magnitude Degrees Magnitude
5.197 59.94 2.243 52.51 2.821 29.35 10.000
ZABC = 2.821 29.35 5.197 59.94 2.243 52.51 Z012 = 0.000
2.243 52.51 2.821 29.35 5.197 59.94 0.000
e Basler Electric web site, "A Derivation of Symmetrical Component
to Z012 conversions discussed in the paper. It would be rather
y supporting, so is more of an informative page.

ABC Domain Impedances

Degrees Magnitude Degrees Magnitude Degrees
59.94 2.243 52.51 2.821 29.35
29.35 5.197 59.94 2.243 52.51
52.51 2.821 29.35 5.197 59.94

Symmetrical Component Domain Impedances

Degrees Magnitude Degrees Magnitude Degrees
350.00 0.000 0.00 0.000 0.00
0.00 4.000 75.00 0.000 0.00
0.00 0.000 0.00 2.000 80.00
Blank unprotected sheet for user's work
 Basic Fault Calculator 30o Lead
System Data: Zn
Magnitude Degrees
E prefault 0
Magnitude Degrees Calculate
E-prefault
Z0 I-fault
Z1
Z2 Clear All
Zf
Z-system
Zn

Fault Calculations
Three Phase A phase to ground Phase B to Phase C Z-fault

In Fault In Fault In Fault

Mag Degrees Mag Degrees Mag Degrees
I-a 0.0000 0.000 I-a 0.0000 0.000 I-a 0.0000 0.000
I-b 0.0000 0.000 I-b 0.0000 0.000 I-b 0.0000 0.000
I-c 0.0000 0.000 I-c 0.0000 0.000 I-c 0.0000 0.000
I-0 0.0000 0.000 I-0 0.0000 0.000 I-0 0.0000 0.000
I-1 0.0000 0.000 I-1 0.0000 0.000 I-1 0.0000 0.000
I-2 0.0000 0.000 I-2 0.0000 0.000 I-2 0.0000 0.000
Other side of Xfmr Other side of Xfmr Other side of Xfmr
Mag Degrees Mag Degrees Mag Degrees
I-a 0.0000 0.000 I-a 0.0000 0.000 I-a 0.0000 0.000
I-b 0.0000 0.000 I-b 0.0000 0.000 I-b 0.0000 0.000
I-c 0.0000 0.000 I-c 0.0000 0.000 I-c 0.0000 0.000
I-0 0.0000 0.000 I-0 0.0000 0.000 I-0 0.0000 0.000
I-1 0.0000 0.000 I-1 0.0000 0.000 I-1 0.0000 0.000
I-2 0.0000 0.000 I-2 0.0000 0.000 I-2 0.0000 0.000

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-3ph: I-B to C: I-A to Gnd:
I1 = E/(Z1+Zf) I1 = -I2 = E/(Z1+Z2+Zf) I1 = I2 = I0 = E/(Z1+Z2+Z0+3Zf+3Zn)
and then converting to ABC quantities.
If the Excel Analysis ToolPak is installed and working properly, the cell to the left should contain
100+100i "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.
User Notes:

7 03/05/2023 648811814.xls
 Basic Load Flow Calculator Miscellaneous Other Calcs:
Es Er
Given Es, Er: Calculate X/R to Angle
Magnitude Degrees Magnitude Degrees Z-line Converter:
Es 0.0000 Z-line 0.0500 77.0000
Er I, Ss I, Sr VA/PF to
Watt/VAR
Calculate
Converter
Given Es, I: Solution is for: Clear Load Flow
Magnitude Degrees Given Es, I
Es 480.0000 0.0000 Watts VAR VA Power Fact.
I 700.0000 -80.0000 Ss 58,345.8 58,345.8 336,000.0 0.1736 Per Unit / Base Calculations
Sr 52,834.5 307,023.3 311,536.2 0.1696 Three Phase
Given Er, I: Calculate Sline 23,872.1 5,511.3 24,500.0 0.2250 MVA base, 3ph
Magnitude Degrees Real Imaginary Mag. Degrees kV Base, L-L
Er 0.0000 Es 480.0000 0.0000 480.0000 0.0000 Given Ohmic Value
I Er 445.0480 1.8318 445.0517 0.2358 Given Current Value
Es-Er 34.9520 -1.8318 35.0000 -3.0000 Given MVA Value
Given Es, Ss: Calculate I 121.5537 -689.3654 700.0000 -80.0000 KV, Line to Gnd
Magnitude Degrees I-base
Es 0.0000 Add the Window's Scientific Calculator to your Excel Toolbar: Z-base
Watts VARs 1) Click through the Excel menu tree: Tools/Customize.
2) Select the "Commands" tab, then in the "Categories" list click on "Tools."
Coverted Values
Ss 3) In the scroll-down list of "Commands," there will be a few items that are simply named "Custom." Ohms PU
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. Current PU
Given Er, Sr: Calculate 4) Click on Close. MVA PU
5) If you want to remove the icon later, repeat step 1, left click on the icon and drag it off the toolbar.
Magnitude Degrees
Er 0.0000
Watts VARs
Sr

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 t
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
100+100i "#VALUE!" messages on this sheet, see the Instructions Sheet for details on enabling Excel's Analysis ToolPak.
User Notes:

8 03/05/2023 648811814.xls
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.

Graph of Q1, Q2, Calc Results from Complex Calc Sheet Graph of Vln, Vll, I in ABC Format Graph of Vln, Vll, I in 012 format

20 5 5

4 4
15

3 3
10
2 2
5
1 1
Imaginary

Imaginary
Imaginary
0 0 0
-20 -15 -10 -5 0 5 10 15 20 -5 -4 -3 -2 -1 0 1 2 3 4 5 -5 -4 -3 -2 -1 0 1 2 3 4 5
-1 -1
-5

-2 -2
-10
-3 -3
-15
-4 -4

-20 -5 -5

Real Real
Real

Q1 Q2 Calc V0,ln V1,ln V2,ln V1,ll

Van Vbn Vcn Vab Vbc
Vca Ia Ib Ic V2,ll I0 I1 I2

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) 0.000 0.000 Phasor End Point 0.000 0.000 Phasor End Point
0 0 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) 0.000 0.000 Phasor End Point 0.000 0.000 Phasor End Point
0 0 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) 0.000 0.000 Phasor End Point 0.000 0.000 Phasor End Point
0 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

9 03/05/2023 648811814.xls
This sheet contains intermediate calculations for display on other pages. 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 0.000000 0.000000 0.000000 0.000000 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 0.000000 0.000000 0.000000 0.000000 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 0.000000 0.000000 0.000000 0.000000 +/- Q1 0.000000 0.000000 0.000000 0.000000 abc_mem1.12 ='V&I,ABC<>012'!$K$22:$O$23
Q1 - Q2 0.000000 0.000000 0.000000 0.000000 Q1 Conjugate 0.000000 0.000000 0.000000 0.000000 abc_mem1.ab ='V&I,ABC<>012'!$D$21:$H$22
Q1 x Q2 0.000000 0.000000 0.000000 0.000000 +/- Q2 0.000000 0.000000 0.000000 0.000000 abc_mem1.abc ='V&I,ABC<>012'!$D$21:$H$23
Q1 / Q2 0.000000 0.000000 0.000000 0.000000 Q2 Conjugate 0.000000 0.000000 0.000000 0.000000 abc_mem2.012 ='V&I,ABC<>012'!$K$24:$O$26
Q1^2 0.000000 0.000000 0.000000 0.000000 New Q1 0.000000 0.000000 0.000000 0.000000 abc_mem2.12 ='V&I,ABC<>012'!$K$25:$O$26
Sqrt(Q1) 0.000000 0.000000 0.000000 0.000000 Q1<=>Q2 abc_mem2.ab ='V&I,ABC<>012'!$D$24:$H$25
1/Q1 0.000000 0.000000 0.000000 0.000000 New Q2 0.000000 0.000000 0.000000 0.000000 abc_mem2.abc ='V&I,ABC<>012'!$D$24:$H$26
Q1 x Q2* 0.000000 0.000000 0.000000 0.000000 abc_results.012 ='V&I,ABC<>012'!$K$35:$O$43
Q1 || Q2 0.000000 0.000000 0.000000 0.000000 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 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000 abc_vll.012 ='V&I,ABC<>012'!$K$11:$O$13
Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000 abc_vll.12 ='V&I,ABC<>012'!$K$12:$O$13
C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 abc_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.000000 cc_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.000000 cc_m3 =ComplexCalc!$D$11:$H$11
C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000 cc_m4 =ComplexCalc!$D$12:$H$12
A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000 cc_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.000000 cc_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.000000 cc_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.000000 cc_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.000000 cc_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.000000 cc_results =ComplexCalc!$B$17:$H$17
A-B 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000 cc_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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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

10 03/05/2023 648811814.xls
 A 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000 ic.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.000000 ic.ix.yy_abc =IMCalcs!$D$150:$H$152
C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000 ic.vll.012.p_vll.12.r =IMCalcs!$K$89:$L$90
Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000 ic.vll.012.p_vll.ab.p =IMCalcs!$G$88:$H$89
C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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 0.000000 0.000000 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000 ic.vll.abc.p_vll.12.p =IMCalcs!$N$73:$O$74
Vl-n B-N 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000 ic.vll.abc.p_vll.12.r =IMCalcs!$K$73:$L$74
C-N 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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 0.000000 0 0.000000 0.000000 0.000000 0.000000 ic.vln.abc.p_vll.ab.r =IMCalcs!$D$40:$E$41
S B 0.000000 0.000000 0.000000 0.000000 1 0.000000 0.000000 0.000000 0.000000 ic.vln.abc.p_vln.012.p =IMCalcs!$N$37:$O$39
C 0.000000 0.000000 0.000000 0.000000 2 0.000000 0.000000 0.000000 0.000000 ic.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.000000 ic.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.000000 ic.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.000000 ic.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

11 03/05/2023 648811814.xls
Given Es, I
Watts VAR VA Power Fact.
Ss 58345.7876960885 58345.7876960885 336000 0.17364817766693
Sr 52834.4868646638 307023.338424864 311536.215133652 0.16959340294353
Sline 23872.0665872383 5511.30083142472 24500 0.224951054343866
Real Imaginary Mag. Degrees
Es 480 0 480 0
Er 445.04796628359 1.83175846850308 445.051735905216 0.235820506209618
Es-Er 34.9520337164101 -1.83175846850308 35 -3.00000000000004
I 121.553724366851 -689.365427108546 700 -80

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 0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
Q2 0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000

Math calculations
Restating Data: Real Imaginary Complex Mag Degrees Radians
Q1 0.000000 0.000000 0 0.000000 0.000000 0.000000
Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000
Q2 Conjugate 0.000000 0.000000 0 0.000000 0.000000 0.000000
Performing Calcs: Radians, basic calc Simplified Radians
Q1+Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000
Q1-Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000
Q1xQ2 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
Q1/Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
Q1^2 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
Sqrt(Q1) 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
1/Q1 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
Q1xQ2conjugate 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
1/Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
1/Q1 + 1/ Q2 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000
Q1||Q2 = 1/[1/Q1 + 1/Q2] 0.000000 0.000000 0 0.000000 0.000000 0.000000 0.000000

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.73205080756888
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

V conversions, starting with Vln ABC rectangular

Given: Real Imaginary Complex Format Magnitude Degrees Radians
AN 0.000000 0.000000 0 0.000000 0.000000 0.000000
Vl-n BN 0.000000 0.000000 0 0.000000 0.000000 0.000000
CN 0.000000 0.000000 0 0.000000 0.000000 0.000000
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 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
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

V conversions, starting with Vln ABC polar

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

12 03/05/2023 648811814.xls
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
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

V conversions, starting with Vln 012 rectangular

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

V conversions, starting with Vln 012 polar

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
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

V conversions, starting with Vll ABC rectangular

Given: Real Imaginary Complex Format Magnitude Degrees Radians
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 Cmfplx 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
Calculated Line-Line, 012 format Magnitude Degrees 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
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

V conversions, starting with Vll ABC polar Comment: V0 was included in calculations in the next 4 conversions below as a check. It should always be zero.
Given: Magnitude Angle Radians Real Imaginary Complex Format
AB 0.000000 0.000000 0 0 0 0
Vl-l BC 0.000000 0.000000 0 0 0 0
CA 0.000000 0.000000 0 0 0 0
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
Calculated Line-LIne, 012 format Magnitude Degrees 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
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

V conversions, starting with Vll 012 rectangular

Given: Real Imaginary Complex Format Magnitude Degrees Radians
0 0.000000 0.000000 0 0.000000 0.000000 0.000000
Vl-l 1 0.000000 0.000000 0 0.000000 0.000000 0.000000
2 0.000000 0.000000 0 0.000000 0.000000 0.000000
Calculated Line to Neutral, 012 format Magnitude Degrees 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
012 to ABC conversion Complex 012 data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians
0 0 AB 0 0.000000 0.000000 0.000000 0.000000 0.000000
Vl-l 1 0 -0 0 BC 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 CA 0 0.000000 0.000000 0.000000 0.000000 0.000000
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

V conversions, starting with Vll 012 polar

Given: Magnitude Degrees Radians Real Imaginary Complex Format
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
Vl-l 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
Calculated Line to Neutral, 012 format Magnitude Degrees Radians Real Imaginary Complex Format

13 03/05/2023 648811814.xls
 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
012 to ABC conversion Complex 012 data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians
0 0 AB 0 0.000000 0.000000 0.000000 0.000000 0.000000
Vl-l 1 0 -0 0 BC 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 CA 0 0.000000 0.000000 0.000000 0.000000 0.000000
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

I conversions, starting with ABC rectangular

Given: Real Imaginary Complex Format Magnitude Degrees Radians
A 0.000000 0.000000 0 0.000000 0.000000 0.000000
I B 0.000000 0.000000 0 0.000000 0.000000 0.000000
C 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
A 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000
I B 0 -0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000
C 0 -0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

I conversions, starting with ABC polar

Given: Magnitude Angle Radians Real Imaginary Complex Format
A 0.000000 0.000000 0.000000 0.000000 0.000000 0
I B 0.000000 0.000000 0.000000 0.000000 0.000000 0
C 0.000000 0.000000 0.000000 0.000000 0.000000 0
ABC to 012 conversion Cmplx ABC Data / 3 *a_1 *a_2 Complex Format 012 Data Real Imaginary Magnitude Degrees Radians
A 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000
I B 0 -0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000
C 0 -0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

I conversions, starting with 012 rectangular

Given: Real Imaginary Complex Format Magnitude Degrees Radians
0 0.000000 0.000000 0 0.000000 0.000000 0.000000
I 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 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Vl-n conversions, starting with 012 polar

Given: Magnitude Angle Radians Real Imaginary Complex Format
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
012 to ABC conversion Complex 012 Data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians
0 0 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Transformer calculations. First copy in base ABC data, then convert to 012 formats again. Then do the Xfmr conversion math.

Restating Primary Data: Real Imaginary Complex format mag degrees radians
AN 0.000000 0.000000 0 0.000000 0.000000 0.000000
Vl-n BN 0.000000 0.000000 0 0.000000 0.000000 0.000000
CN 0.000000 0.000000 0 0.000000 0.000000 0.000000
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
A 0.000000 0.000000 0 0.000000 0.000000 0.000000
I B 0.000000 0.000000 0 0.000000 0.000000 0.000000
C 0.000000 0.000000 0 0.000000 0.000000 0.000000

ABC to 012 conversion, rectangular format, then convert to polar

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
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
A 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000
I B 0 -0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000
C 0 -0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

Voltage Transformer, Wye-Wye

Transformer Effect on: Magnitude Phase shift, degrees
Zero Sequence 1 0
Positve sequence 1 30
Negative sequence 1 -30
Secondary Sequence Quantities Seq. Mag. / VT ratio Degrees 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
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
Vl-l 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
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
0 0 AB 0 0.000000 0.000000 0.000000 0.000000 0.000000
Vl-l 1 0 -0 0 BC 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 CA 0 0.000000 0.000000 0.000000 0.000000 0.000000
0 0 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Voltage Transformer, Other than wye-wye

14 03/05/2023 648811814.xls
Transformer Effect on: Magnitude Phase shift, degrees
Zero Sequence 0 0
Positve sequence 1 30
Negative sequence 1 -30
Secondary Sequence Quantities Mag. / VT Ratio Degrees 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
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
Vl-l 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
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
0 0 AB 0 0.000000 0.000000 0.000000 0.000000 0.000000
Vl-l 1 0 -0 0 BC 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 CA 0 0.000000 0.000000 0.000000 0.000000 0.000000
0 0 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Current Transformer, Wye secondary

Transformer Effect on: Magnitude Phase shift, degrees
Zero Sequence 1 0
Positve sequence 1 0
Negative sequence 1 0
Secondary Sequence Quantities Seq. Mag / CT Ratio Degrees Radians Real Imaginary Complex Format
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
012 to ABC conversion Complex Format 012 data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians
0 0 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Current Transformer, DAB Secondary

Transformer Effect on: Magnitude Phase Angle, degrees
Zero Sequence 0 0
Positve sequence 1 30
Negative sequence 1 -30
Secondary Sequence Quantities Seq. Mag. / CT Ratio Degrees Radians Real Imaginary Complex Format
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
012 to ABC conversion Complex 012 data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians
0 0 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Current Transformer, DAC Secondary

Transformer Effect on: Magnitude Phase Angle, degrees
Zero Sequence 0 0
Positve sequence 1 -30
Negative sequence 1 30
Secondary Sequence Quantities Seq. Mag. / CT Ratio Degrees Radians Real Imaginary Complex Format
0 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 1 0.000000 0.000000 0.000000 0.000000 0.000000 0
2 0.000000 0.000000 0.000000 0.000000 0.000000 0
012 to ABC conversion Complex 012 data *a_1 *a_2 Complex ABC Data Real Imaginary Magnitude Degrees Radians
0 0 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I 1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Mem 1 = S = V x I* Real Imaginary Complex Format Magnitude Degrees Radians

AN 0 0 0 0.000000 0.000000 0.000000
V BN 0 0 0 0.000000 0.000000 0.000000
CN 0 0 0 0.000000 0.000000 0.000000
A 0 0 0 0.000000 0.000000 0.000000
I* B 0 0 0 0.000000 0.000000 0.000000
C 0 0 0 0.000000 0.000000 0.000000
A 0 0 0 0.000000 0.000000 0.000000
S = V x I* B 0 0 0 0.000000 0.000000 0.000000
C 0 0 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 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000
S = V x I* 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

Mem 2 = Isum = I + Mem1 Real Imaginary Complex Format Magnitude Degrees Radians
A 0 0 0 0.000000 0.000000 0.000000
I sum B 0 0 0 0.000000 0.000000 0.000000
C 0 0 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
A 0 0 0 0.000000 0.000000 0.000000 0.000000 0.000000
I sum B 0 -0 0 1 0 0.000000 0.000000 0.000000 0.000000 0.000000
C 0 -0 0 2 0 0.000000 0.000000 0.000000 0.000000 0.000000

Load Flow Calculations

Given Es, Er * = conjugate in stated equations

Magnitude Degrees Radians Real Imaginary Complex
Es 0.000000 0.000000 0.000000 0.000000 0.000000 0
Er 0.000000 0.000000 0.000000 0.000000 0.000000 0
Z-line 0.050000 77.000000 1.343904 0.011248 0.048719 0.0112475527171933+0.0487185032392618i
Esr = Es-Er 0.000000 0.000000 0.000000 0.000000 0.000000 0
I = Esr/Z 0.000000 0.000000 0.000000 0.000000 0.000000 0
I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Ss = Es x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0

15 03/05/2023 648811814.xls
Sline = dE x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sr = Er x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0

Given Es, Ss
Magnitude Degrees Radians Real Imaginary Complex
Es 0.000000 0.000000 0.000000 0.000000 0.000000 0
Ss 0.000000 0.000000 0.000000 0.000000 0.000000 0
Z-line 0.050000 77.000000 1.343904 0.011248 0.048719 0.0112475527171933+0.0487185032392618i
I* = Ss/Es 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I = (Ss/Es)* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Esr = I x Zline 0.000000 0.000000 0.000000 0.000000 0.000000 0
Er = Es-Esr 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sline = Esr x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sr = Er x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0

Given Es, I
Magnitude Degrees Radians Real Imaginary Complex
Es 480.000000 0.000000 0.000000 480.000000 0.000000 480
I 700.000000 -80.000000 -1.396263 121.553724 -689.365427 121.553724366851-689.365427108546i
Zline 0.050000 77.000000 1.343904 0.011248 0.048719 0.0112475527171933+0.0487185032392618i
I* 700.000000 80.000000 1.396263 121.553724 689.365427 121.553724366851+689.365427108546i
Ss=Es x I* 336000.000000 80.000000 1.396263 58345.787696 330895.405012 58345.7876960885+330895.405012102i
Esr = I x Zline 35.000000 -3.000000 -0.052360 34.952034 -1.831758 34.9520337164101-1.83175846850308i
Er = Es-Esr 445.051736 0.235821 0.004116 445.047966 1.831758 445.04796628359+1.83175846850308i
Sline = Esr x I* 24500.000000 77.000000 1.343904 5511.300831 23872.066587 5511.30083142472+23872.0665872383i
Sr = Er x I* 311536.215134 80.235821 1.400379 52834.486865 307023.338425 52834.4868646638+307023.338424864i

Given Er, Sr
Magnitude Degrees Radians Real Imaginary Complex
Er 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sr 0.000000 0.000000 0.000000 0.000000 0.000000 0
Z-line 0.050000 77.000000 1.343904 0.011248 0.048719 0.0112475527171933+0.0487185032392618i
I* = Sr/Er 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I = (Ss/Es)* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Esr = I x Zline 0.000000 0.000000 0.000000 0.000000 0.000000 0
Es = Er+Esr 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sline = Esr x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Ss = Es x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0

Given Er, I
Magnitude Degrees Radians Real Imaginary Complex
Er 0.000000 0.000000 0.000000 0.000000 0.000000 0
I 0.000000 0.000000 0.000000 0.000000 0.000000 0
Zline 0.050000 77.000000 1.343904 0.011248 0.048719 0.0112475527171933+0.0487185032392618i
I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sr=Er x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Esr = I x Zline 0.000000 0.000000 0.000000 0.000000 0.000000 0
Es = Er+Esr 0.000000 0.000000 0.000000 0.000000 0.000000 0
Sline = Esr x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0
Ss = Es x I* 0.000000 0.000000 0.000000 0.000000 0.000000 0

Fault Calculations

Magnitude Degrees Radians Real Imaginary Complex

Z0 0.000000 0.000000 0.000000 0.000000 0.000000 0 Add/subtract 30 degrees for Xfmr effect
Z1 0.000000 0.000000 0.000000 0.000000 0.000000 0 p_30 0.866025403784439+0.5i
Z2 0.000000 0.000000 0.000000 0.000000 0.000000 0 m_30 0.866025403784439-0.5i
Zf 0.000000 0.000000 0.000000 0.000000 0.000000 0
3Zf 0.000000 0.000000 0.000000 0.000000 0.000000 0
3Zn 0.000000 0.000000 0.000000 0.000000 0.000000 0
E prefault 0.000000 0.000000 0.000000 0.000000 0.000000 0

Three Phase Fault

Magnitude Degrees Radians Real Imaginary Complex
Ztotal 0.000000 0.000000 0.000000 0.000000 0.000000 0
Io 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
In Fault I-012, repeated *a_1 *a_2 Complex Real Imaginary Magnitude Degrees Radians
Io 0.000000 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0.000000 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0.000000 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000
Across Xfmr I-012, w/xfmr effects *a1 *a2 Complex Real Imaginary Magnitude Degrees Radians
Io 0.000000 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0.000000 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

A Phase to Ground
Magnitude Degrees Radians Real Imaginary Complex
Ztotal 0.000000 0.000000 0.000000 0.000000 0.000000 0
Io 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
In Fault I-012, repeated *a_1 *a_2 Complex Real Imaginary Magnitude Degrees Radians
Io 0.000000 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0.000000 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0.000000 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000
Across Xfmr I-012, w/xfmr effects *a1 *a2 Complex Real Imaginary Magnitude Degrees Radians
Io 0.000000 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

B Phase to C Phase
Magnitude Degrees Radians Real Imaginary Complex
Ztotal 0.000000 0.000000 0.000000 0.000000 0.000000 0
Io 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0.000000 0.000000 0.000000 0.000000 0.000000 -0
In Fault I-012, repeated *a_1 *a_2 Complex Real Imaginary Magnitude Degrees Radians
Io 0.000 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0.000 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000

16 03/05/2023 648811814.xls
 I2 -0 0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000
Across Xfmr I-012, w/xfmr effects *a1 *a2 Complex Real Imaginary Magnitude Degrees Radians
Io 0.000000 A 0 0.000000 0.000000 0.000000 0.000000 0.000000
I1 0 -0 0 B 0 0.000000 0.000000 0.000000 0.000000 0.000000
I2 0 -0 0 C 0 0.000000 0.000000 0.000000 0.000000 0.000000

Cell Used to check for Analysis ToolPak Installation

100+100i 100 100

17 03/05/2023 648811814.xls