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

Anil

I am not able to download the excel sheet

Ali Ahmad

i am not able to download the excel sheets

Bala

Hi team,

if there is any shortcuts or easy methods in testing commissioning,and how can reduce the commissioning time for particular tests..

NIKUNJ PARMAR

Thank you so much for such a great files. these are one of the best tool for electrical systems. keep it up

subhash

Best and nice work

keep it up

but a small correction require in cable size calculation ( excel ) sheet in 3.5 X 50 sqmm where the result is wrong

thanks

by subhash from totalsolution.website

Adil Agha

Great effort to organize EE info at one place, future target should be to evolve projects group.

regards

Adil

EE

LE VUONG

Thank you a lot for sharing.

Vincent

Firstly, I highly appreciate your contributions. Thank you so much!

Secondly, I have checked all the Excel sheets, I saw that most of them were protected, so I could not see the formulas, which I want to recheck. Can you help me to unlock them??

khan

sir I want to unlock the spreed sheet as most of them were locked and I cant change it according to my use can u give me pas or how to unlock it

Qaiser Iqbal

These excel worksheets are very useful for design engineers. Thank you for sharing free of cost on purpose knowledge for everyone.

Emmanuel

Very nice of you sir.

Nguyễn Hoàng

Thank for your support…

Ahmad Wahid

thank you, very useful.

samer

that’s very helpful… great

samuel.ayalew

Thanks a lot this is a great help for professionals and trainers. A real quality work with lots of consideration for fellow professionals in the stream. you are setting a higher example. Once again Thank you very much.

SUBRAMANIAN NAMBISAN

Dear EEP Team,

you are doing a wonderful job by making available such calculations for every day use by practicing engineering professionals, cs nambisan

Shaddai

Thank you so very much.

Mounir

Thanks a lot.

Prawin

Thanks a lot. Very Very Helpful

Khaled Ellithy

Excellent

Tawa Great

Hello team EEP

As a junior power systems engineer, which coding language would advise me to learn among:

PHP

Front-End Web Development

Website Design

Android Development

iOS Development

Python

C#

WordPress

Thank you

Emin

Do you know anything about those languages? They are all completely different. Front-End Web development is not even a language; it’s an area, just like distribution systems engineering.

I suggest you research a little bit before asking a question like this.

ISLAM LIKA

Hi,

i want to buy a lap top for scada system

ANKUR SENGUPTA

Hello sir,

I want to know that, is there any calculation table for transformer firewall protection?

THANKS

choi85

Thanks, very much..

Raphael Sangrador

Thank you.

jayaraj.k

Dear All,

I need to give the justification for selected cable 2 Runs of 185 Sq.mm.

this cable selected for transformer solid ground conductor.

Transformer details.

13.8kV/480V

4687 KVA

Z=5.75%

Dyn1 vector group

Whether this cable is sufficient or not. please clarify with calculation.

Thanks in advance

BR

Jayaraj.k

Pisit

Nice solution

Atiq

anyone have Siemens software (Starter v 4.3 for Siemens Drive(VFD) G120).please upload anywhere and send me link.

thanks.

Atiq

Edvard

Have you checked on Siemens’s website?

http://w3.siemens.com/mcms/mc-solutions/en/engineering-software/starter-commissioning-tool/pages/starter-commissioning-tool.aspx

Atiq

Dear i have already checked on Siemens’s website but cannot register and download.

Reda Mostafa

Please I like to calculate the required number of earth rods for substation mat specially in the preimeter

Thanks in advance

Carlos Espinoza

Thanks to Mr. Michal Liszka for the Excel EMF calculation.Do you know if this spreadsheet gives the electrical gradient of the conductors? or with some minor modification of the macro?

Michael

Thanks… Thumbs Up

Mirwais

Thanks a lot, Very usefull

Mohammad reza Amirahmadi

Hi. Thanks, very usefull

Prosper Kalu

God is going to bless and keep all the people doing this great work to make this world a more comfortable place. God is also going to help us in Africa to also take part in this great improvements. kudos to you guys.

asrizal basir

Hi senior,

I am looking for software for mp920 yaskawa plc,and cable data for programing

We have problem with my machine and we must solve that problem.

Where i am to get the software and cable data to connect to my pc

Tq all

QVN

Thanks a lot. very useful

nabi

I need Electrical AutoCAD or same software for design of electrical schema please send me link of

TOLBA

thank you very much sir

CASIMIRO

Thank you very much.. It helps a lot

Do we also computation, for Transformer single phase dry type (consumption with out load).

Some say is negligible but waste of energy.

Mohammed AbuRayya

Thanks a lot.

anand

Please provide EXCEL sheet for following CT calculations

One minute Power Freq. 70 kV & 28 kV withstand voltage (rms),

Lighting Impulse withstand Voltage

System fault level Rated dynamic withstand 62.5 Current (KA rms)

peter malus

thank you very much. such information is very useful to me as a young electrician.

Mohmmad Thapet

Thank you you helpful best regard

Zorica Popovic

The best site ever!! Thank You very much for Your effort!!!

Faizan

you are welcome.

Tarqiullah

Thank you of your work in Electric Engineering.

hoss

Hello.

Thanks a lot for your large Heart to share this useful knowledges.

ashenafi

THANK YOU!!!!

Hassan

Thanks a lot

kiran Kumar Avadhanula

I have a doubt that we have a metal chimney of 63.5 mtrs height does we have to install air terminals and horizontal terminals to connect to ground for lightning protection or we can simply connect the chimney base to earth grid.

Sridhar

One of the best knowledge sharing website. Great job by Edvard and his supporting team.

Thabiso Boase

the best site,

Ashraf Zaher

Thank you very much

E MARTINEZ

Good day, do you have a spreadsheet to estimate cooling/heating for control panels?

Thanks.

mohamed

Could you please send to me all sheets because register now not allowed

saman

Thank YOU very much, All of calculation is so Perfect . . .

Ismaeil

Thanks

Vigneswaran

Dear Palmer,

I downloaded some of your excel sheets, but its not opening as I am using MS office 2013, is that a problem or your excel sheets only work with previous version of office. kindly reply.

Thank you ,

Vigneswaran

ABDUL QAYYUM

DEAR ALL

THANK YOU SO MUCH FOR THIS GREAT WEBSITE AND THESE LINKS

BEST REGARDS

YOURS

ABDUL QAYYUM

Pal

Sincere thanks and my appreciation to this wonderful forum.

mouaz mohamed

thanks allot , appreciation to this wonderful forum

Aditya Vyas

Thank you so much for the organised sheets. it really is helpful.

Asst. Prof. Dr. Emad Kamil

DEAR ALL

THANK YOU SO MUCH FOR THIS GREAT WEBSITE AND THESE LINKS

BEST REGARDS

YOURS

EMAD

Pablito Ortega

Sir,

I’am Mr. Lito Ortega, i’m here in New York working to Delco Electric Co. as Electrical Designer. Where are you working now sir Emad. Please reply to my email at litortega@gmail.com.

Bojan Petreski

WOW…. I just love you… there, I said it :-)

thanks!

Ricardo

what is X´mer?

K P Kesavan Nair

X’mer is short for Transformer.

anwer

thank u this is very helpful

SERGIO sds

Thanks, very usefull

Nasser .M

Thank you very match this was really very useful in the engineering design job . ,

hazir

It’s amazing thank you so much sir…

G UPENDER

with regards to all of u members

Ramzi

Thank you for his wonderful work, they have been useful to me. Is it possible to provide me the password to modify the excel file. Regards,

Essraa

Dear Gents,

I have a project which I need to size a Power Control Center & Transformer for motors load driven through Variable Frequency Drives.

Could you advise how to size the feeders of the PCC for each motor+VFD knowing that each VFD has an overload capability 1.5 times rated current for 60secs.

Thanks in advance.

khaled

coool,,

thanks a lot they have been useful to me

Pankaj Desai

Thanking you Mr. Jignesh Parmar and others for sharing wonderful, useful and data sheet and spreadsheet.

Vikas Khengre

Hi,

I need ups sizing Calculator. please mail me if you could provide me.

Your help regarding on this will be very much appreciated.

Regards

Vikas

Bryant

A quick reference website for wire size and circuit protection calculations:

http://wiresizecalculator.net/

Harish

Sir,

This is very HELP FULL for us , I am very Thanks to You sir, I Learned many thing from this site, Thank you so much.

@st175

Hi, can you please help me with writing the code for calculating switching losses in an IGBT with unity power factor.I m suppose to use time slicing technique and estimate losses or switch state at 1000 time instants.

Can you help?

MD.Mohitul Haque

This was very helpful,thanks.

Rami

Is there a link to download all the spreadsheets, instead of one by one? Thanks

nikhil

please send me the spreadsheets

Ravikumar

Dear Team ,

I am unable to download the cable designing program MS EXCEL Spreadsheet . When I am clicking the above link ,the file is not coming .

Can you pls help me to download .

With Regards,

R.Ravikumar

mohamed

thanks a lot for this support to my new challenge work :)

pradeep

I want to CODES/RELEVANT STANDARDS IE, IEC,IEEE & CBIP MANUALS.

sathishchowdary

Dear Sir, I want how to select relay for a electrical usages.

Tesfay Gebre

I really appreciation for your sharing a knowledge us. But I have question how can I access the resource because the MS excel spread sheet is read only?

saravanan

Dear sir , can you provide me a spreadsheet to calculate harmonic . thank you.

Farhad Kohestani

You can find one in ABB site. Just Google harmonic estimator ABB group.

omar

Dears if there Excel spreadsheet to calculate reactors size kindly provide me

thanking you

Pravin Sawant

thanks for sharing … kindly provide the password or keep it open sourced if you really want to share you knowledge.. because it is difficult to get the the formulae behind the calculation.

Sumit

Hi

I would be very happy if you can work upon and include excel tools for railway electrification engineering and estimation including QS.

Regards

Sumit

Agustin Laez

Please check the Excel Spreadsheets, Calculate size of transformer and voltage due to starting of large size motor,the cell E33 not working, excuse me english, no is very good.

I speak spanish

Thank

SM

It’s Cool!!!

Kristoffe Russel Carlos

can you provide me spreadsheet to calculate the sag and span and tension for transmission line please…thank you so much!

trevor chandass

can you please provide a calculator to size transformers where three single phase transformers are used to create a full three phase or open delta bank with the measured phase load current as the inputs?

tommy

please sent for me password unprotect file excel if can

Kazem

Hi

Calculated filter harmonic and filter D teuned

Thank you

Md Mosharaf Hossan

How i wll be able download excell sheeet

Dimitrios Chouliaras

hello guys, im interested in calculate proper diesel generators for industrial projects

kazem

Hi, thanks for the very good Excel files to calculate file requests Series Inductors which are industrial drives

mohd azharuddin

Dear Sir,

i am working on calculating Rct of current transformer please help me how to calculate this

thanks

VICTOR RAUTA

Hi guys,

i like the discussions in this wonderful forum.

I AM STILL A STUDENT AND I HOPE TO BENEFIT FROM YOU

Nagendra

I need the methods to calculate and select the proper size of XLPE cable for high voltage system. Can anybody help me providing the spreadsheet to select the proper size of XLPE cable for High voltage like (11-33-66-132kV) system.

Mubeen

Hi.. I m trying to download MSCEXCEL spreadsheets on my android phone but it struck on box page and nothing happens when I press download button .. I also have installed box app but not working…

haradongan pasaribu

I am interested in electrical software/ CD file designing for MV/LV circuits. can you guide me on that?

Shine

I want Program Calculation for ups sizing…and ups spread sheet…

Mohammed Yousuf A

Great job Mr Parmar, very helpful information in the site. nice….

SOLANKI RAJESH

I NEED MONTHLY,DAILY Grid Availability – Seet plz help me

Lars

Very nice spreadsheets. Anyone got one for calculating generator incomer CT?

HARISH

Thank you very much sir…..

really really thanks

surasitw

I want Program Calculation .

jafari

you are the best

thank you veryveryveryvery veryveryveryvery much

rijvan

I ll recomend this site for all engineer who never stop learning..

I m feel lucky to visit this site

sina.ma

Thank you very very much .

dehghani

Thanks a lot………..

shayesteh

Thank you verryyyyyy mach

vivek sharma

I want to add some excel tools which can be useful in numerical relay testing. such as Delta connection counting, unbalance (NPS, PPS, ZPS) counting, all type power & energy calculations etc.

Edvard

Great Vivek! You can send your spreadsheets to office/AT/electrical-engineering-portal.com.

John Lovel

Really g8t Efforts and Thanks alot.

Do Duc Thai

Please give us the password to use these tools.

Thank you very much.

sun

required 132 KV transmission losses calculations

Jermaine

This is a wonderful and very helpful thing that you have done. Do you have plans to do a medium voltage motor calculation sheet?

NOEL MENDOZA

Im very glad tha you post this helpful and very usefull computation

sudhir

great content for electrical engineers, please remove the protection for the files, we want to utilize it

thank from your information

good information

ZISHAN

All the excel sheets are password protected. How to remove the password

Harrison U. S

I really wanna appreciate your support and help to electrical engineers all over the globe, your really a great source of help cos much time have been saved with the help of your spreadsheets. I wanna say thanks and heaven blesses you guys real good.

DESSIE MELESE

I am Electrical engineer in Ethiopia. My interest is to be the member of number one 1 Electrical engineer in the world.

chris weche

YOU GUY(S) ARE GOD-SENT,YOU ARE A BLESSING TO THE UNIVERSE.MAY THE ALMIGHTY GOD GRAND U FAVOUR IN UR ENDEVOURS TOO.

Ayo

You guys have really done a good job. Having these spreadsheet handy for a rough estimate saves time a lot.

thanks

Prashant Baldawa

Thanks EEP. Your articles are worth reading. Simple yet an insite to a many technical facts which we deal with on conitnual basis.

Do you have any article on the autosnchronization scheme and its advantages/disadvantages.

Thanks in advance.

aruel

Thanks EEP for your generosity! I got all the spreadsheets almost 45 for free. a very helpful docs.

God bless!

A.shiraj Ahamed

I can’t download this software. But this is very important and very useful for all technical persons

umut

İ cant download it

Edvard

Please elaborate… cannot help according to ‘I cant download it’ ;)

Yadagiri.Y

Pls, share…..!

Ronald

Dear Sir,

how to down load this?? thanks

Regards

R.I

Ramnik

could not use the Home Electrical Bill / Energy Consumption / Load Calculator

it requires password the cells are protected. Can you send me the password PLEASE!

Edvard

You can use this spreadsheet without any problem, but if you want to edit formulas and unlock the cells, you will have to purchase this spreadsheet.

Ramnik

but sir i cannot edit the “total electrical load” cell…

plz help

satish korgaonakar

Any spead sheet which we downloads from this website ask for password , You replied we need to purchase the same , so tell me wats the price n wats is the procedure to do the same

B.MANJUNATH

Dear sir,

Please help me sir i am not able to download the Excel sheet details like voltage drop calculation, elrctrical formulad etc.,

Edvard

Everything is available for free download, I don’t see any problem ;)

Romel Bacay

Its awesome. Thank you very much for the references ..Pls. dont be sate to share your knowledge. Go will bless you.

S S A

Please include the checklist for installation of electrical items (DBs/ Panels / Transformers / DG/ ACB etc)

Pankaj Rane

It’s really very helpful , thanks a ton!!!!

Arulanandan S

not available for down loading

pd1986

files are not downloading from mobile please help

oynotna

Salute!

keshrimohit38

Awesome… Hats off to all of them … :)

shergill

what is the password sir

mk_sanaye

the information and softwares are really usefull but download links in http://www.box.com doesn’t work correctly and server doesn’t respond, please correct them

thanks for your efforts

IMI

Very important information that to free. May ALLAH (There is no god but allah) bless you.

Rukhsar Ali

Its my pleasure to be here & i am thankful to you for sharing such information.

Its too much helpful

quochuy

Thank you very much for your help…

sivapacr

Thanx a lot sir for the great work.

Adem1

Thank you very much for your efforts, it’s really nice job,

trinhminhnhat

thanks so much for ur non-profit work!im grateful for that and dont know how to give a thanks!:(

aakifnouman

You made the life easy thankyou

afk

Suggest any method to design and sizing of control/switch gear panels.

Abdelrazek

Dear Sir;;

thank you very much for your efforts, it’s really nice job,

but I want to ask you to put the standards you have used, and pls put the full meanings of the abbreviations you have used.

sat07babu

nice work congrats ….

THIAGO

Awesome!

Thanks and congratulations for the excelent work!

rahul chauhan

thanks

lahti

Very nice spreadsheets! Is it possible to make one about 3-phase transformer inrush and aprox. voltage drop caused by inrush?

Mandy

this is wonderful!

mycandy

Many thank to you!

pnp

nothing more to say…….. a big hug for this help. u r doing a great help to students like me….

BAMBAA

HI GUYS, SOMEBODY HELP ME HOW TO COMPUTE MAIN DISTRIBUTION PANEL LOAD SCHEDULE. I WISH SOMEBODY HAVE A SPREADSHEET / XLS TEMPLATE. =)

Franklyne Dhayalan

Thanks for doing a lot of work. It is very good inded.

Could you please clarify if we use chemical earthing ) meaning moisture obsorbing material is filled in around the electrode) will you calculation still be good enough?

lasser56

hi thanks for all the good tools you guys have come up with. Actually i’m trying to study electrical services design on my own,i got your eplus menuCAD software which i think is a helpful tool. however i still need some step by step guide notes on some basic things i should know. Can you help with any straight to the point books,articles or any literature on electrical services design?

thank you and i’ll appreciate any help you give

Kevin Felix

Can someone tell me how to download Electrical MS Excel Spreadsheet.

Edvard

You must register and download links will be visible. Go ahead and register here:

https://electrical-engineering-portal.com/wp-login.php?action=register

and then login here:

https://electrical-engineering-portal.com/wp-login.php

Hope this helps a little bit ;)

Edvard

ravijayananth

can you brief about relay coordination study and send me example calculation

aleskndr

please how can i download

Tadikamallasairam

could you please tell me how to download these spreadsheets

tarekdia

this is a test format for 13.8 kv switchgear

1. GENERAL DATA AND INFORMATION

Panel No : Designation No. : A.Q1

Manufacturer : ABB Rated Voltage : 24 KV

Type No. : VD4/P 24.25.25 Rated Aux. Voltage : 125 VDC

Serial No. : 1VC1AL000 Rated Current : 2300 A

2. MECHANICAL CHECK AND VISUAL INSPECTION

ITEM DESCRIPTION CHECKED

1 Inspect for physical damage / defects.

2 Check nameplate information for correctness

3 Check tightness of all bolt connections

(Torque Wrench)

4 Check racking mechanism for alignment and

Smoothness of operation

5 Check quality of paint work

6 Check proper operation of all mechanical interlocks

7 Check for correct breaker position indications

8 Check for correct spring status indication

9 Check all wiring correctness as per approved drawings

10 Check that all grounding are securely connected

3. ELECTRICAL TESTS

3.1 Function Test.

ITEM DESCRIPTION CHECKED

1 Local control, alarm and indications

2 Remote control, alarm and indications

3 Check correct operation of all auxiliary “a” and “b” switch contacts.

4 Check breaker operation counter

5 Check trip free and anti-pumping circuit

6 Check electrical operation of breaker racking tracks. (interlocks and limit switches).

3.2 Insulation Resistance Measurement:

TEST

VOLTAGE

CONDITION

DURATION

READING (TΩ)

5KV

CB CLOSE: R-Y+B+GROUND

1 MIN

CB CLOSE: Y-R+B+GROUND

1 MIN

CB CLOSE: B-R+Y+GROUND

1 MIN

CB OPEN: R1+Y1+B1-R2+Y2+B2+GROUND

1 MIN

3.3 Contact Resistance Test: Current injected 100A

CONDITION

R-PHASE

(µΩ)

Y-PHASE

(µΩ)

Y-PHASE

(µΩ)

CB CLOSED

Test Kit : Megger & CPC 100

3.4 Breaker Timing Set

TEST

RΦ (in mSec)

YΦ (in mSec)

BΦ (in mSec)

Closing Operation

Closing Coil

Open Operation

Tripping Coil 1

Open Operation

Tripping Coil 2

Test Kit: EGIL

roel

Thanks to all the contributor and developer of this site/forum…very helpful

ali1980

Thanks, very usefull

psrpskumar

thankyou very usefull for me

cmurugan-design

Pls post current transformer design xlx

m0Handaznelson

Superb! very useful, i learned a lot…thanks…

mohamed Iqbal

THANS VERY HELP FULL

akira

Sincere thanks and appreciation to this wonderful forum