Available fault current spreadsheet
Available fault current spreadsheet

Introduction

This MS Excel Spreadsheet is created by mr. John Sokolik and it represents easy way to calculate fault current by entering few values in indicated fields.

You will find sheet with very nice example already fulfilled. Before starting fault current calculation, you will have to choose between Step 1a and Step 1b which are explained below.

Step 1a

Insert available fault current ampere rating from your local Utility.


Step 1b

Insert the the kVA rating power factor (PF) and impedance  (Z) of the transformer is not required to continue. Note: When you insert the kVA rating  power factor and impedance you must select the voltage from the dropdown box Select Voltage & Phase before the value will be calculated.

Spreadsheet information

Software:Fault Current Calculation (MS Excel Spreadsheet)
Version:7.1
Developer:John Sokolik
Size:207 KB
Price:Free
Download:Right here | Get Download Updates | Get Technical articles

Fault Current Calculation Spreadsheet

Weekly Download Updates //

Once per week, we are releasing download update in following sections: MS Excel calculation spreadsheets, electrical software and guides and various engineering books.

Be first to get this download update!

Subscribe Now!

Page edited by E.C. (Google).

16 Comments


  1. David A Engelhart
    Feb 16, 2015

    I found an error in this calculator prior to this version when I learned how to calculate longhand. I also got John to add the Utility Fault Current cell that is present in this version. This file is also available at MikeHolt.com in his free stuff where I got my copy to critique. The Electrical Plan Review PDF file is what taught me to calculate fault current by longhand. http://www.mikeholt.com/technical-calculations-formulas.php


    • Mahendra Mistry
      Mar 19, 2015

      David
      Can you provide information with examples on how to calculate fault levels the long hand method. Thanks.

  2. […] voltages and currents) from the system/apparatus and issues a trip decision if a fault within the protection relay‘s jurisdiction is […]


  3. walter graham
    Jan 26, 2015

    this is a very good website!

  4. .
    I work with Electricity Authority of Cyprus and i am the section head of High voltage cables.
    I really enjoy reading your articles. They are very good and very helpful.
    I am using your spread sheets for various calculations.
    Thank you

  5. […] and the EGC, the grounding clamp mechanically anchors the EGC to the cable tray so that under fault current conditions the magnetic forces do not throw the EGC out of the cable […]


  6. gaitan
    Nov 23, 2013

    Great work!!


  7. S.M.Nazraton Nayeem
    Nov 22, 2013

    It’s a great work….


  8. Padlock01
    Jul 15, 2013

    Just a comment on available software please remember that especially on the african continent
    we use mm2 conductors as apposed to AWG so it would be nice to select either.

  9. […] and hence the process concerned, requires consideration.Figure 2 – Multiple voltage dip Other network-related fault causes are weather–related (such as snow, ice, wind, salt spray, dust) causing insulator […]


  10. mosesma
    Nov 29, 2012

    Thank you for the great work you have done.


  11. matbon
    Nov 07, 2012

    Hi,
    Very good work.
    Yet could you make an option which allows you to input the cable data in mmsq and not in AWG (European Standards)?
    Thanks in advance.


  12. neel151
    Sep 07, 2012

    Thank you very much. It is great to have such kind of facility to able to speed up your calculations.


  13. arun banerjee
    Jun 26, 2012

    Thanks a lot!
    Such kind of excel sheets are definitely useful to crosscheck the calculations.

  14. […] It should be noted that time has a greater effect on the incident energy than the available bolted fault current.Figure 1 – Human Tissue – Tolerance to 2nd Degree Burn Both the NFPA-70E and IEEE Standard 1584 […]


  15. kalayil78
    Mar 24, 2012

    Hi ,
    Excellent work,
    But , can you pls update this with LV Earthing system (IT,TT,TN etc..) & Transformer windg method (Y,DYN,yn etccc). with out these the pgm is good enogh only for 3 phase fault which is not allways the design criteria of LV system.

    Thanks in advance

Leave a Comment

Tell us what you're thinking... we care about your opinion!
and oh, not to forget - if you want a picture to show with your comment, go get a free Gravatar!

two × = sixteen

CONNECT //