## 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!

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

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 | . |

Really EEP is a great Electrical portal, thanks all associates with it for it’s enrichment, updating, upgrading and implicit contribution to the society of electrical professionals.

Awaiting eagerly to submit some articles for publication on EEP very near future!!!!!!

A great professional platform that allows us to solve problems .

Thank you ver much.

I am a new member of the Premium Pro and I’m pretty sure that I’ll learn a lot and enjoy it at the same time

Thanks a lot

I am interested in the EEP.

I have read several good articles.

I am planning to enter into a membership plan but the question that I have is are the courses that are offed and completed successfully qualified for PDH credits for the state requirements for annual PE continuing education courses.

Thank you for offering such courses.

Andrew Herbert, P.E.

It is too much supporting to expand know-how of knowledge of the respective field.

Good to expand knowledge in respective field.

Kindly, do you have an excel spreadsheet regarding siemens distance protection relays(siprotec4) used to calculate protective zones impedances?. If the answer yes can you post it in this your website.

I hope to receive your reply very soon

thank you so much

Thank you so much for sharing all these tools and documents. These are very important for our business

Do yo have power system security, Load Flow Analysis and contingency analysis excel sheet?

Thank you very much

Hi , Do you have SOLAR Farm design calculations for selection of fuse, 1500V DC wire harness selection, tracking calculations etc.

spreadsheet for star delta starters calculations is protected. how to use it

I like this Portal since long time ago…..

Thanks for the good Job

i need refererence to start learning electrical systems from scratch, which is the best books to start with