Tuesday, January 29, 2019

Touch Voltage & Ground Current Calculation Excel Sheet


File Size: 99 Kb




Touch Potential is the potential that can be established between the point at which a person is standing on the ground and the point at which some contact is made with hardware, such as by placing the hand on a substation fence.




Engineering standards use a one-meter reach distance for calculating Touch Potentials. A two-meter reach distance is used when two or more objects are inside the event area. For example, a person could be outstretching both arms and touching two objects at once such as a tower leg and a metal cabinet.

Mitigating Step and Touch Potential hazards is usually accomplished through one or more of the following three main techniques:
  • Reduction in the Resistance to Ground of the grounding system
  • Proper placement of ground conductors
  • The addition of resistive surface layers
Understanding the proper application of these techniques is the key to reducing and eliminating any Ground Potential Rise hazards. Only through the use of highly sophisticated 3-dimensional electrical simulation software that can model soil structures with multiple layers and finite volumes of different materials, can the engineer accurately model and design a grounding system that will safely handle high-voltage electrical faults.

According to the inputs for three-phase system:-
 Line-to-Neutral Volts (Vn), Line 1 Calculated Load (A1), Line 2 Calculated Load (A2), Line 3 Calculated Load (A3), Service Neutral Impedance Z1, and Ground Resistance (3-point method) R, spreadsheet will calculate the following parameters:

  1. Resistance of Each Phase
  2. Resistance of neutral/Ground
  3. Neutral Current and Load
  4. Touch Voltage for Metal part to Earth
  5. Body Resistance and Body Current




With the using of this excel sheet we perform the Calculation of touch voltage and ground current on single phase or three-phase systems.

Inputs Value For Three-Phase system :-


  • Line-to-Neutral Volts (Vn)
  • Line 1 Calculated Load (A1)
  • Line 2 Calculated Load (A2)
  • Line 3 Calculated Load (A3)
  • Service Neutral Impedance Z1
  • Ground Resistance (3-point method) R
Results can be obtained By According to Above Given Input Values :-

  • Neutral/Ground Parallel Resistance
  • Line 1 Resistance
  • Line 2 Resistance
  • Line 3 Resistance
  • Line 1 - Actual Load
  • Line 1 Watts
  • Line 1 - Loads Operates at Volts
  • Line 2 - Actual Load
  • Line 2 Watts
  • Line 2 - Loads Operates at Volts
  • Line 3 - Actual Load
  • Line 3 Watts
  • Line 3 - Loads Operates at Volts
  • Parallel Neutral/Ground Path
  • Neutral Watts
  • Neutral Current
  • Ground Current
  • Touch Voltage from Metal Parts to Earth.
Inputs Value For Single-Phase system :-

  • Circuit Voltage
  • Circuit Ampere
  • Load Resistance
  • Ground Resistance
  • Electrode Resistance
  • Body Resistance
Results can be obtained By According toAbove Given Input Values :-
  • Body Current
  • Circuit Current










Download Drive-1

























You May Also Like These E-Books:-

No comments:

Post a Comment