Get 15% OFF on Pro Premium Plan with discount code: UX21M. Study specialized electrical engineering articles and papers in Low- and High-Voltage areas.

# 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 more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on.

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

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

1. John
Dec 18, 2019

on the spreadsheet for the calculation of “Load Listing, Calculations & Generator Sizing” why is the default voltage 400 volts rather than the residential voltage of 240 volts? It would be a more useful spreadsheet if you can actually size the loads for a residential home. Thanks, John

2. Siddheshwar mauti khodwe
Nov 29, 2019

Dear Sir,
we need a Dc cable Calculator for find out the size of cable for varies DC motor or invertor.

3. Rajesh
Nov 22, 2019

dear your are doing good job for preparing such excel sheet.
I am requested to prepare excel sheet for calculating per unit value for common base particularly 100 MVA base for transformer, transmission line for all conductors. generators

4. Horatio Fayah Nyumah
Nov 15, 2019

Thank You very much. Your article is of great help to me as an electrical engineer. It will surely boost my electrical strength.

5. koustav paul
Oct 14, 2019

can you plz upload a sheet that contains calculation of energy savings by correcting the harmonics in the system

6. Leonardo Quintero
Oct 03, 2019

Thank you for sharing these tools for calculations, they are very helpful.

7. shyam
Sep 11, 2019

Thank You EEP
Its very useful

Sep 10, 2019

its very good

9. Ayman
Aug 24, 2019

10. Ayman
Aug 24, 2019

thanks

11. Si Thu Aung
Aug 24, 2019

Thankyou very much, so great.

12. Cyril
Aug 18, 2019

Very useful. Thank you very much EEP. :) More powers!

13. George
Aug 10, 2019

Good program

14. GJ Mol
Jul 18, 2019

Thank you for all these incredible calculation sheets. Really welcome!

15. HassenL
Jun 24, 2019

Great job. Thank you a lot for sharing.

• ROHAN DESHPANDE
Jun 27, 2019

These sheets are fabulous. An ample list of topics for calculations have been covered. It shall of great use to electrical engineer.

Thanks a lot for sharing these resources and that to free of cost.

Appreciate efforts of all involved !!!

### Electrical Engineering Courses

Learn to design electrical power and industrial automation systems through professional video courses.