Stabilizing Resistor

[Chicago100]

I's trying to calculate the stabilizing resistor value for the earth fault protection relay. Following are the parameters used:

500KVA, 11kV/415V, 4.75% Z,
CT used: 800/1A, Class PX, lead resistance=7.46 ohm/km, lead length = 30m.

Can anyone forward an excel spreadsheet to calculate the stabilizing resistor for the earth fault relay?

Thanks

 

[7anoter4]

I don't think you need an excel spreadsheet for this calculation.
What you need now is CT impedance.
First of all see: thread238-201225
As slavag here said:
"For secondary resistance you can use 0.6-1 Ohm for 5A
and about 5-7Ohm for 1A."
If you have CT resistance and lead resistance
see Relay Manf. Instructions.For instance ABB IRXm:[The IRXm relay]

http://www.google.co.il/url?sa=t&rc...lay&source=web&cd=4&ved=0CFkQFjAD&url=http://

http://www05.abb.com/global/scot/sc...8O3DBA&usg=AFQjCNGAJPtM82WwkaRch7eo2qmHOIwHpQ