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

Most of spreadsheets are developed by two electrical engineers and programmers mr. Jignesh Parmar and mr. Hemant Kashikar. They all really did an awsome job, you must admit.

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


Electrical calculations (MS Excel Spreadsheets)



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

2 comments:

  1. good job. but can i print out my work?

    ReplyDelete
  2. Nice blog… Thanks for sharing very useful information about electrical circuits.
    Designing Electrical Circuits

    ReplyDelete