Search

Premium Membership

Save 15% on Pro Premium Plan with discount code: UX226 (expires on July 31, 2021). Study specialized LV/MV/HV technical articles and papers.

Home / Download Center / Electrical MS Excel Spreadsheets (Calculations of cables, voltage drop etc.)

Electrical tools (MS Excel Spreadsheets)

This section is dedicated to tools every electrical engineer can use in daily work. These spreadsheets below will make your job much easier, allowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size, and so on.

Electrical Tools - MS Excel Spreadsheets
Electrical Tools – MS Excel Spreadsheets

Spreadsheets are mostly developed by experienced electrical engineers and programmers (thank you Mr. Jignesh Parmar!) and by well-known manufacturers of electrical equipment. They all really did an awesome job, we must admit!

Just to mention that all calculation spreadsheets are free for download! ;)

Electrical calculations (MS Excel Spreadsheets) New Download 
Motor Starting Calculation Spreadsheet (by Hemant Kashikar) star.
Cable Designing Program Updated.
Calculate Home Electrical Load & Electrical Bill Updated.
Calculate Bus Bar Size and Voltage Drop Updated.
Calculate Electrical Load and Energy Consumption of Panel Updated.
Calculate Electrical Load of Panel Updated.
Calculate Insulation Resistance Value Updated.
Calculate Number of Lighting Fittings and Lumen Output Updated.
Calculate Size of Battery Bank and Inverter Updated.
Calculate Size of Solar Panel, Battery Bank and Inverter Updated.
Circuit Breaker Tripping Settings Updated.
Conduit Size Selection Program Updated.
Design of Earthing Mat for Sub-Station Updated.
Selection of MCCB, ELCB For Main-Branch Circuit Updated.
Selection of fuse and setting of instant short circuit tripping of CB Updated.
Short Circuit Current Calculation at Various Point of Electrical Circuits (Isc) Updated.
Size of Capacitor For Power Factor Improvements Updated.
Fault Current Calculation star.
Electrical Safety Program Arc Flash Calculator.
E-Feeder and Cable Calculator.
SquareD – Selecting capacitor size.
Voltage Drop Calculator – Albany Technical College.
Cable size calculations based on motor horse power (HP) and specified current.
Voltage Regulation Percentage of Small Distribution Line.
Calculate size of air conditioning for room.
Residential Load Calculations.
Pump Efficiency Calculation Tool.
Transformer Fault Current Calculation.
Powerline Voltage Drop Calculation star.
Electrical Safety Program Arc Flash Calculator.
Transformer And Short Circuit Calculator.
Electrical calculations (MS Excel Spreadsheets)  Download 
Power Factor Correction Calculation star.
Calculation of Touch Voltage and Ground Current star.
IDMT (Inverse Definite Minimum Time) Relay Calculation star.
Calculate Size of Diesel Generator star.
Electrical Pole’s Trasverse Load Calculation New star.
Electrical Engineering General Formulas New.
CO2 Savings Calculator New.
Available Fault Current Selective Coordination.
Power Factor Table Calculator New.
NEMA Motor Data Calculator star.
Estimated Voltage Drop Calculator star.
IEC Motor Data Calculator star.
Calculation of Size of Transformer, Fuse and Circuit Breaker star.
Calculate Size Of DOL and Star-Delta Starter Components New star.
Calculate size of transformer and voltage due to starting of large size motor New.
Power Quality Solution Selection Spreadsheet New.
Spreadsheet For Calculating Size Of Motor Pump star.
Spreadsheet For Calculation The Required Number Of fixtures And Illuminance Level star.
Lightning Protection Risk Assessment Calculator/Spreadsheet.
Load Listing, Calculations and Generator Sizing Spreadsheet.
Spreadsheet for Transformer Losses Calculation.
Motor Voltage Drop Calculator (Spreadsheet) star.
Spreadsheet to calculate the size of neutral earthing transformer star.
Spreadsheet to Calculate Short Circuit Capacity of Diesel Generator Synchronizing Panel New.
Power factor correction calculations for power system New star.
Distribution Transformer Calculations New star.
Calculation of electro magnetic field (EMF) around T&D overhead lines.
Earthing system design tool for low voltage installations New.

Premium Membership

Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
More Information

248 Comments


  1. Radhika Kamdi
    Jul 17, 2020

    HT motor cable calculations


  2. Aimy
    Jul 16, 2020

    Dear sir,
    Can you please help in my one project ..I have some doubts on distribution system i.e. hvds and lvds
    I think lvds is better than hvds in suburban areas because of large no’s of consumers
    Plz help me on this


  3. ANIS-UR-REHMAN
    Jun 29, 2020

    DEAR SIR,
    I HAVE ONE TECHNICAL QUERY PLAESE I WANT SOLUTION
    ” AT WELL PAD I WANT TO PROVIDE EARTHING TO METALIC FENCE FENCE L&W IS 180X150 M2.
    FAULT CURRENT IS 10 KA. VOLTAGE IS 660V AC, LENGTH FROM STATION TO WELL PAD IS 5KM, CABLE SIZE TO SUPPLUYING 660V AC 24V DC CONVERTER PANEL IS 2CX35 SQ MM CABLE.

    I WANT TO KNOW CAN I USE 25SQMM ALUMINIUM CABLE FOR FENCE, POST, MAIN GATE EATRHING.


    • Mahantesh
      Sep 03, 2020

      DEAR SIR,
      I HAVE ONE TECHNICAL QUERY PLAESE I WANT SOLUTION,WE HAVE OLD DG THATS CONSUMING MORE DIESEL, AROUND 10 YERS OLD, ACCORDINGLY WE HAVE TO REPLACE NEW DG, PLEASE ENERGY COST WORK WITH EXCEL SHEET.

      OUR DG DETAILS FOR YOUR REFERENCE.

      1) 180KVA,125KVA
      2) Current SEGR 33RUPES PER UNIT.


  4. Ellezer Gallon. Casiño
    May 29, 2020

    ELECTRICAL ENGINEERING PORTAL especially to the Author.

    Thank you so much for sharing all these tools and documents. These are very important for me especially that I’m teaching college students and doing research also.

    Once again, thank you and more power.

    Truly yours,

    Ellezer Gallon Casiño


  5. Gonzalo Vázquez
    May 28, 2020

    Dear all: thanks a lot for all your useful info; that is what we need to work for! The devil is in the details!


  6. Ahmed Motelb
    May 08, 2020

    Thanks, very usefull


  7. Steven Smith
    Apr 24, 2020

    I just love your web site and for a old guy who does estimates and take offs its a great tool. I do have a request. I am being asked by the local AHJ to provide him with a Calc. sheet for a commercial office building where were are replacing (Like as Like) the old FPE panels w/ new updated Sq D. No cables or breakers or circuits are being changed. Just a replacement panel for the old Fed Pacific. He now wants me to do a “load” calc sheet for each office unit, each Panel. Do you have a excel sheet for this Commercial Application? Something simple and easy. The resi one wont work here. Thanks


    • Carol
      May 06, 2020

      Steven,

      As an AHJ myself, I wonder why he needs a load calc. Are you sure that he didn’t ask for a fault current analysis instead since the older FPE panels didn’t have an AIC rating, so they default to 5kA per the NEC. The new Square D panels would need to be either fully rated for the calculate fault currents at the panel replacement locations or series rated, assuming your local AHJ allows series ratings.


      • Carol
        May 06, 2020

        Sorry about the typos above. My cat jumped on my keyboard.

        BTW – Replacing a panel with another panel isn’t a like for like replacement, especially for older panels because of the lack of a fault current rating.


  8. Fureek
    Apr 07, 2020

    Hi,

    How to download this template?, I need it.., please.

    Thanks.


  9. k.sriramkumar
    Mar 02, 2020

    transformer size-2000kva(11kv/433v)
    cable length-150 feets
    hv/lv amps-104/2666
    we required cable size from transformer to pmcc panel


  10. kaushal kishor
    Feb 18, 2020

    11kV HT incomer feeder setting: I>>>=INF., I>>=2.5, TI>>=0.65s, IP=0.8, TP=0.25s, IE>>=0.25, TIE>>=0.65s, TEP=0.4s, IEP=0.1
    11kV HT outgoing feeder setting: I>>>=INF., I>>=3.0, TI>>=0.3s, IP= 1.0, TP=0.3s, IE>>=0.31, TIE>>=0.15s, TEP=0.1s, IEP=0.1

    With above settings, can anybody suggest why incomer feeder tripped during outgoing feeder cable fault ?


  11. Srinivasa rao
    Feb 14, 2020

    good work gives good appreciation…….. i like this…….. done a good job thank u


  12. Héctor Orobio Valencia
    Feb 09, 2020

    Although I am not an electrical engineer but an electronics on I appriciate your contribution. Some subjects are very similar between the two careers.

    Thanks a lot.


  13. Mentus Ugwu
    Jan 31, 2020

    great assistance.I have downloaded a few of the spreadsheet. hopefully they serve the intended purpose. great work nevertheless


  14. hadi
    Jan 13, 2020

    hi
    please send me the password


  15. Khruschev
    Dec 26, 2019

    They are so helpful. Can you please make one for vector group calculations. It must be able to draw the grouping as you put the figures on the spreadsheet.

Leave a Comment

Tell us what you're thinking... we care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

  ×  six  =  thirty six

EEP Academy Video Courses

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning.