Search

Premium Membership

Save 50% on all courses at the EEP Academy with the Enterprise Plan and study specialized technical articles, papers & video courses.

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

264 Comments


  1. Mominur Nur Hossain
    Jul 16, 2022

    I am a graduate engineer in electrical engineering, I have more than 10 year of working experience in Power Generations of verious Ltd company in relocated all over India and with open to all rules and responsibilities.


  2. AREGAWI
    Jul 08, 2022

    Thankyou!, but i need autocad app


  3. Fermin Nunez
    Jun 21, 2022

    I have a question , all these spreadsheets will work well on a Mac ? Is there a fee or a price ?
    Thanks


  4. B. Gancarz
    Feb 18, 2022

    Hello.
    How can I download Residential Load Calculator? Do I have to sign in?


  5. Prasanth R
    Feb 01, 2022

    Do these sheets work in Google Sheets? If yes, has anyone figured out a way to make the calculations work right? I’ve tried to open the .xlsx files in Google sheets but the formulas won’t work.


    • Edvard
      Feb 01, 2022

      Most of these sheets have macros working behind and that’s why they don’t work. Maybe there’s some way to activate macros in G Sheets.


  6. Georgios MARIOLIS
    Dec 17, 2021

    I was wondering if an installation of capacitors in some motors of a cargo ship is meaningfull and efficient.
    I was thinking to add capacitors to 5 motors of 55kw each, which are operating 24/7/365 and reduce their reactive power.
    Read so many articles, that i am now confused.
    Of course it will be of a profit but at the same time i am very interested in the vessel’s power grid safety and stability too.


  7. Ali
    Dec 13, 2021

    hello sir,
    i want to learn how can i read a electrical drawing in simple way.

    thank you


  8. SUNNY
    Nov 27, 2021

    Hello sir,

    I want voltage drop calculation formula for selection actual cable size.


  9. Roberto de Vries
    Nov 17, 2021

    Good day.

    I hope you could assist me with some advice please, as getting any reaction from solar companies, seems impossible!

    I reside in Augrabies and do irrigation from an irrigation canal on the lower side by means of flood irrigation. On the higher side I use electric water pumps. The bigger one for irrigation and the smaller one for drinking water to a tank.

    I currently use power from Escom, but want to change it to solar power.

    The big pump takes water directly from the canal and it is mainly used during daytime.

    The small pump is on a borehole which is 14m deep and the watertable stands at 8m. It is usually used during daytime as well.

    I would be so grateful if you could assist me with the correct different solar equipment needed, please. The battery, solar panels, inverter and controller.

    Thank you so much.

    Friendly regards.

    Roberto de Vries
    Cell: 0722095373


  10. Alet
    Nov 10, 2021

    I need a excel spreadsheet that calculate earthmoving machine’s working hrs per day worked exmple machine start hrs is 525 next day beginning hrs is 550. Hrs worked is 25 hrs and per month and also in the calculation it must redflag you on when its due for maintenance service. Maintenance services is normaly after 250hrs, 750hrs, 1000hrs or 2000 hrs. as soon as the machine reach his next due maintenance service hrs, the spreadsheet warn you by redflagging the hrs.
    Feel free to contact me if you need any other information.


    • Er. Salman Malik
      Jan 25, 2022

      Hi Alet,

      it would be interesting to work on it & prepare a master data sheet for you.
      @Alet kindly drop an email with details on my email : [email protected]

      thanks.


  11. AYODEJI IDRIS. O
    Sep 09, 2021

    I need more app on Electrical design


  12. Joshua Kojo Blankson
    Aug 30, 2021

    Please how do I open an account to login to the site.


  13. Barthélemy Nijimbere
    Aug 09, 2021

    Great website with huge bunch of knowledge.


  14. ADEGBOLA
    Aug 05, 2021

    Hello sir
    I want to simulate electric and magnetic field under power line
    Could I have thé EF and MF CALC software?
    Thanks

Leave a Reply to Georgios MARIOLIS

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!

sixteen  −  six  =  

Learn How to Design Power Systems

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

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).