Learn about power engineering and HV/MV/LV substations. Study specialized technical articles, papers, and electrical engineering video courses.

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

1. Hussein Abbas
Jan 05, 2021

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.

thank you so much

2. stephanson
Jan 05, 2021

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

3. SAIFEE KEZARBHAI KANJETAWALA
Oct 16, 2020

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

4. veerayut pojui
Oct 15, 2020

Thank you very much

5. RAJ
Oct 08, 2020

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

6. kailash singh
Sep 22, 2020

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

7. Armen Zar
Sep 15, 2020

I like this Portal since long time ago…..
Thanks for the good Job

8. muthukumar
Aug 06, 2020

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

Jul 17, 2020

HT motor cable calculations

10. Aimy
Jul 16, 2020

Dear sir,
Can you please help in my one project ..I have some doubts on distribution system i.e. hvds and lvds
I think lvds is better than hvds in suburban areas because of large no’s of consumers
Plz help me on this

11. ANIS-UR-REHMAN
Jun 29, 2020

DEAR SIR,
I HAVE ONE TECHNICAL QUERY PLAESE I WANT SOLUTION
” AT WELL PAD I WANT TO PROVIDE EARTHING TO METALIC FENCE FENCE L&W IS 180X150 M2.
FAULT CURRENT IS 10 KA. VOLTAGE IS 660V AC, LENGTH FROM STATION TO WELL PAD IS 5KM, CABLE SIZE TO SUPPLUYING 660V AC 24V DC CONVERTER PANEL IS 2CX35 SQ MM CABLE.

I WANT TO KNOW CAN I USE 25SQMM ALUMINIUM CABLE FOR FENCE, POST, MAIN GATE EATRHING.

• Mahantesh
Sep 03, 2020

DEAR SIR,
I HAVE ONE TECHNICAL QUERY PLAESE I WANT SOLUTION,WE HAVE OLD DG THATS CONSUMING MORE DIESEL, AROUND 10 YERS OLD, ACCORDINGLY WE HAVE TO REPLACE NEW DG, PLEASE ENERGY COST WORK WITH EXCEL SHEET.

OUR DG DETAILS FOR YOUR REFERENCE.

1) 180KVA,125KVA
2) Current SEGR 33RUPES PER UNIT.

12. Ellezer Gallon. Casiño
May 29, 2020

ELECTRICAL ENGINEERING PORTAL especially to the Author.

Thank you so much for sharing all these tools and documents. These are very important for me especially that I’m teaching college students and doing research also.

Once again, thank you and more power.

Truly yours,

Ellezer Gallon Casiño

13. Gonzalo Vázquez
May 28, 2020

Dear all: thanks a lot for all your useful info; that is what we need to work for! The devil is in the details!

14. Ahmed Motelb
May 08, 2020

Thanks, very usefull

15. Steven Smith
Apr 24, 2020

I just love your web site and for a old guy who does estimates and take offs its a great tool. I do have a request. I am being asked by the local AHJ to provide him with a Calc. sheet for a commercial office building where were are replacing (Like as Like) the old FPE panels w/ new updated Sq D. No cables or breakers or circuits are being changed. Just a replacement panel for the old Fed Pacific. He now wants me to do a “load” calc sheet for each office unit, each Panel. Do you have a excel sheet for this Commercial Application? Something simple and easy. The resi one wont work here. Thanks

• Carol
May 06, 2020

Steven,

As an AHJ myself, I wonder why he needs a load calc. Are you sure that he didn’t ask for a fault current analysis instead since the older FPE panels didn’t have an AIC rating, so they default to 5kA per the NEC. The new Square D panels would need to be either fully rated for the calculate fault currents at the panel replacement locations or series rated, assuming your local AHJ allows series ratings.

• Carol
May 06, 2020

Sorry about the typos above. My cat jumped on my keyboard.

BTW – Replacing a panel with another panel isn’t a like for like replacement, especially for older panels because of the lack of a fault current rating.

16. Fureek
Apr 07, 2020

Hi,

Thanks.

17. k.sriramkumar
Mar 02, 2020

transformer size-2000kva(11kv/433v)
cable length-150 feets
hv/lv amps-104/2666
we required cable size from transformer to pmcc panel

18. kaushal kishor
Feb 18, 2020

11kV HT incomer feeder setting: I>>>=INF., I>>=2.5, TI>>=0.65s, IP=0.8, TP=0.25s, IE>>=0.25, TIE>>=0.65s, TEP=0.4s, IEP=0.1
11kV HT outgoing feeder setting: I>>>=INF., I>>=3.0, TI>>=0.3s, IP= 1.0, TP=0.3s, IE>>=0.31, TIE>>=0.15s, TEP=0.1s, IEP=0.1

With above settings, can anybody suggest why incomer feeder tripped during outgoing feeder cable fault ?

19. Srinivasa rao
Feb 14, 2020

good work gives good appreciation…….. i like this…….. done a good job thank u

20. Héctor Orobio Valencia
Feb 09, 2020

Although I am not an electrical engineer but an electronics on I appriciate your contribution. Some subjects are very similar between the two careers.

Thanks a lot.

21. Mentus Ugwu
Jan 31, 2020

great assistance.I have downloaded a few of the spreadsheet. hopefully they serve the intended purpose. great work nevertheless

Jan 13, 2020

hi

23. Khruschev
Dec 26, 2019

They are so helpful. Can you please make one for vector group calculations. It must be able to draw the grouping as you put the figures on the spreadsheet.

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

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

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

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

28. koustav paul
Oct 14, 2019

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

29. Leonardo Quintero
Oct 03, 2019

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

30. shyam
Sep 11, 2019

Thank You EEP
Its very useful

Sep 10, 2019

its very good

32. Ayman
Aug 24, 2019

33. Ayman
Aug 24, 2019

thanks

34. Si Thu Aung
Aug 24, 2019

Thankyou very much, so great.

35. Cyril
Aug 18, 2019

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

36. George
Aug 10, 2019

Good program

37. GJ Mol
Jul 18, 2019

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

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

39. Vinayak
Jun 12, 2019

Great work please tell us passwords of the sheets so we also can work for improvisation

40. Naveed
Jun 10, 2019

Dear Team,
Have a nice day.

I have found a lot of valuable spreadsheets on your portal. It’s really a blessing that peoples like you doing a great job.

Would you please confirm me that upto which extent these spread sheets are correct so that I may apply these spread sheets directly to my practical field work with 100 percent of mind satisfaction.

Best Regards,
Naveed Bashir.
I & C Engineer.

41. Walkan
Apr 25, 2019

This is simply amazing! Thank you so much.

42. Vinay Haldikar
Apr 17, 2019

Sea of info. Great work !!!

43. JOKOTOYE OYEWOLA
Apr 12, 2019

Good initiative, keep it up

44. joniel tangapa
Mar 25, 2019

excellent reference it helps a lot.

45. Rajesh
Mar 03, 2019

what is direction of fault current on radial MV feeder (11kV) how earth fault or overcurent relay works.
what are the reason for catching of fire during fault?

46. Anil
Jan 16, 2019

Jan 01, 2019

48. Bala
Dec 24, 2018

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

49. NIKUNJ PARMAR
Nov 19, 2018

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

50. subhash
Oct 13, 2018

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

Oct 06, 2018

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

52. LE VUONG
Oct 04, 2018

Thank you a lot for sharing.

53. Vincent
Sep 25, 2018

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
Oct 05, 2018

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

54. Qaiser Iqbal
Sep 12, 2018

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

55. Emmanuel
Aug 28, 2018

Very nice of you sir.

56. Nguyễn Hoàng
Aug 01, 2018

Jul 28, 2018

thank you, very useful.

58. samer
Jun 24, 2018

59. samuel.ayalew
Apr 27, 2018

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.

60. SUBRAMANIAN NAMBISAN
Apr 20, 2018

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

Mar 10, 2018

Thank you so very much.

62. Mounir
Feb 17, 2018

Thanks a lot.

63. Prawin
Feb 11, 2018

Thanks a lot. Very Very Helpful

64. Khaled Ellithy
Jan 25, 2018

Excellent

65. Tawa Great
Dec 19, 2017

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
Jan 14, 2018

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.

66. ISLAM LIKA
Dec 16, 2017

Hi,

67. ANKUR SENGUPTA
Dec 14, 2017

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

THANKS

68. choi85
Dec 12, 2017

Thanks, very much..

Nov 10, 2017

Thank you.

70. jayaraj.k
Nov 09, 2017

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.

BR
Jayaraj.k

71. Pisit
Oct 21, 2017

Nice solution

72. Atiq
Oct 10, 2017

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

73. Reda Mostafa
Aug 30, 2017

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

74. Carlos Espinoza
Aug 15, 2017

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?

75. Michael
Aug 14, 2017

Thanks… Thumbs Up

76. Mirwais
Aug 05, 2017

Thanks a lot, Very usefull

Jul 17, 2017

Hi. Thanks, very usefull

78. Prosper Kalu
Jul 12, 2017

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.

79. asrizal basir
Jun 21, 2017

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

80. QVN
Jun 17, 2017

Thanks a lot. very useful

81. nabi
Jun 15, 2017

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

82. TOLBA
Jun 10, 2017

thank you very much sir

83. CASIMIRO
May 31, 2017

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.

84. Mohammed AbuRayya
May 10, 2017

Thanks a lot.

85. anand
Apr 12, 2017

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)

86. peter malus
Apr 03, 2017

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

Mar 23, 2017

Thank you you helpful best regard

88. Zorica Popovic
Mar 14, 2017

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

• Faizan
Mar 20, 2017

you are welcome.

89. Tarqiullah
Mar 01, 2017

Thank you of your work in Electric Engineering.

90. hoss
Feb 27, 2017

Hello.

91. ashenafi
Feb 23, 2017

THANK YOU!!!!

92. Hassan
Feb 04, 2017

Thanks a lot

Feb 02, 2017

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.

94. Sridhar
Feb 01, 2017

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

95. Thabiso Boase
Jan 19, 2017

the best site,

96. Ashraf Zaher
Nov 30, 2016

Thank you very much

97. E MARTINEZ
Oct 17, 2016

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

98. mohamed
Sep 26, 2016

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

99. saman
Aug 17, 2016

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

100. Ismaeil
Aug 01, 2016

Thanks

101. Vigneswaran
Jun 24, 2016

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

102. ABDUL QAYYUM
May 12, 2016

DEAR ALL
THANK YOU SO MUCH FOR THIS GREAT WEBSITE AND THESE LINKS
BEST REGARDS
YOURS
ABDUL QAYYUM

103. Pal
May 09, 2016

Sincere thanks and my appreciation to this wonderful forum.

104. mouaz mohamed
Apr 28, 2016

thanks allot , appreciation to this wonderful forum

Apr 25, 2016

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

106. Asst. Prof. Dr. Emad Kamil
Apr 20, 2016

DEAR ALL
THANK YOU SO MUCH FOR THIS GREAT WEBSITE AND THESE LINKS
BEST REGARDS
YOURS

• Pablito Ortega
Sep 14, 2016

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 [email protected].

107. Bojan Petreski
Mar 26, 2016

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

108. Ricardo
Mar 17, 2016

what is X´mer?

• K P Kesavan Nair
Feb 17, 2017

X’mer is short for Transformer.

109. anwer
Mar 16, 2016

thank u this is very helpful

110. SERGIO sds
Mar 10, 2016

Thanks, very usefull

111. Nasser .M
Mar 03, 2016

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

112. hazir
Jan 11, 2016

It’s amazing thank you so much sir…

113. G UPENDER
Nov 10, 2015

with regards to all of u members

114. Ramzi
Oct 24, 2015

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,

115. Essraa
Aug 30, 2015

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.

116. khaled
Aug 15, 2015

coool,,

thanks a lot they have been useful to me

117. Pankaj Desai
Aug 13, 2015

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

118. Vikas Khengre
Jul 17, 2015

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

119. Bryant
Jul 14, 2015

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

http://wiresizecalculator.net/

120. Harish
Jul 06, 2015

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.

121. @st175
Jun 25, 2015

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?

122. MD.Mohitul Haque
Jun 25, 2015

123. Rami
Jun 23, 2015

124. nikhil
Jun 19, 2015

125. Ravikumar
May 23, 2015

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 .

With Regards,
R.Ravikumar

126. mohamed
Apr 15, 2015

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

Apr 12, 2015

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

128. sathishchowdary
Mar 27, 2015

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

129. Tesfay Gebre
Mar 25, 2015

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?

130. saravanan
Mar 25, 2015

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

Oct 11, 2018

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

131. omar
Mar 04, 2015

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

thanking you

132. Pravin Sawant
Feb 13, 2015

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.

133. Sumit
Feb 13, 2015

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

134. Agustin Laez
Jan 24, 2015

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

135. SM
Jan 17, 2015

It’s Cool!!!

136. Kristoffe Russel Carlos
Jan 09, 2015

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

137. trevor chandass
Dec 26, 2014

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?

138. tommy
Dec 21, 2014

139. Kazem
Dec 10, 2014

Hi
Calculated filter harmonic and filter D teuned
Thank you

140. Md Mosharaf Hossan
Dec 05, 2014

141. Dimitrios Chouliaras
Dec 02, 2014

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

142. kazem
Oct 09, 2014

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

143. mohd azharuddin
Oct 02, 2014

Dear Sir,

thanks

144. VICTOR RAUTA
Aug 26, 2014

Hi guys,
i like the discussions in this wonderful forum.
I AM STILL A STUDENT AND I HOPE TO BENEFIT FROM YOU

145. Nagendra
Aug 18, 2014

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.

146. Mubeen
Aug 18, 2014

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…

Aug 16, 2014

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

148. Shine
Aug 14, 2014

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

149. Mohammed Yousuf A
Aug 14, 2014

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

150. SOLANKI RAJESH
Aug 11, 2014

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

151. Lars
Jul 30, 2014

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

152. HARISH
Jul 29, 2014

Thank you very much sir…..
really really thanks

153. surasitw
Jul 15, 2014

I want Program Calculation .

154. jafari
Jul 12, 2014

you are the best
thank you veryveryveryvery veryveryveryvery much

155. rijvan
Jul 12, 2014

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

I m feel lucky to visit this site

156. sina.ma
Jul 03, 2014

Thank you very very much .

157. dehghani
Jun 29, 2014

Thanks a lot………..

158. shayesteh
Jun 29, 2014

Thank you verryyyyyy mach

159. vivek sharma
Jun 18, 2014

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
Jun 18, 2014

160. John Lovel
Jun 12, 2014

Really g8t Efforts and Thanks alot.

161. Do Duc Thai
Jun 11, 2014

Thank you very much.

Jan 13, 2020

hi Do Duc Thai
can you send me password of excel files?

162. sun
Jun 08, 2014

required 132 KV transmission losses calculations

• vaibhav jain
Mar 24, 2020

Let us know if you are still looking for the same.

163. Jermaine
Jun 07, 2014

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

164. NOEL MENDOZA
Jun 04, 2014

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

165. sudhir
Jun 03, 2014

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

May 20, 2014

good information

167. ZISHAN
May 17, 2014

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

168. Harrison U. S
May 04, 2014

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.

169. DESSIE MELESE
Apr 07, 2014

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

170. chris weche
Apr 03, 2014

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

171. Ayo
Mar 25, 2014

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

thanks

172. Prashant Baldawa
Feb 05, 2014

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.

173. aruel
Jan 26, 2014

God bless!

174. A.shiraj Ahamed
Jan 10, 2014

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

175. umut
Jan 08, 2014

• Edvard
Jan 08, 2014

Jan 03, 2014

Pls, share…..!

177. Ronald
Jan 03, 2014

Dear Sir,

how to down load this?? thanks

Regards
R.I

178. Ramnik
Dec 15, 2013

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

• Edvard
Dec 15, 2013

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
Dec 15, 2013

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

• satish korgaonakar
Jan 01, 2014

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

179. B.MANJUNATH
Dec 12, 2013

Dear sir,

• Edvard
Dec 12, 2013

180. Romel Bacay
Dec 11, 2013

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

181. S S A
Dec 11, 2013

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

182. Pankaj Rane
Dec 05, 2013

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

183. Arulanandan S
Dec 04, 2013

184. pd1986
Nov 29, 2013

185. oynotna
Oct 25, 2013

Salute!

186. keshrimohit38
Oct 09, 2013

Awesome… Hats off to all of them … :)

187. shergill
Oct 06, 2013

188. mk_sanaye
Sep 27, 2013

189. IMI
Sep 17, 2013

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

190. Rukhsar Ali
Sep 08, 2013

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

191. quochuy
Sep 04, 2013

Thank you very much for your help…

192. sivapacr
Aug 22, 2013

Thanx a lot sir for the great work.

Aug 14, 2013

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

194. trinhminhnhat
Aug 10, 2013

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

195. aakifnouman
Jul 23, 2013

You made the life easy thankyou

196. afk
Jul 20, 2013

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

197. Abdelrazek
Jul 12, 2013

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.

198. sat07babu
Jul 09, 2013

nice work congrats ….

199. THIAGO
Jul 04, 2013

Awesome!

Thanks and congratulations for the excelent work!

200. rahul chauhan
Jun 29, 2013

thanks

201. lahti
Jun 27, 2013

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

202. Mandy
Jun 27, 2013

this is wonderful!

203. mycandy
Jun 15, 2013

Many thank to you!

204. pnp
Jun 03, 2013

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

205. BAMBAA
May 31, 2013

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

206. Franklyne Dhayalan
May 31, 2013

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?

207. lasser56
May 09, 2013

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?

208. Kevin Felix
Apr 18, 2013

209. aleskndr
Apr 05, 2013

Mar 12, 2013

211. tarekdia
Dec 23, 2012

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

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

212. roel
Dec 08, 2012

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

213. ali1980
Nov 27, 2012

Thanks, very usefull

214. psrpskumar
Nov 26, 2012

thankyou very usefull for me

215. cmurugan-design
Nov 15, 2012

Pls post current transformer design xlx

216. m0Handaznelson
Nov 01, 2012

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

217. mohamed Iqbal
Oct 31, 2012

THANS VERY HELP FULL

218. akira
Sep 19, 2012

Sincere thanks and appreciation to this wonderful forum

• joniel tangapa
Jul 05, 2019

do you have a Medium voltage voltage drop calculator excel for over head power line cable?