Electrical Tools - MS Excel Spreadsheets
Electrical Tools - MS Excel Spreadsheets

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

Weekly Download Updates //

Once per week, we are releasing download update in following sections: MS Excel calculation spreadsheets, electrical software and guides and various engineering books.

Be first to get this download update!

Subscribe Now!

Page edited by E.C. (Google).


    Nov 10, 2015

    with regards to all of u members

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

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

    Thanks in advance.

  4. khaled
    Aug 15, 2015


    thanks a lot they have been useful to me

  5. Pankaj Desai
    Aug 13, 2015

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

  6. Vikas Khengre
    Jul 17, 2015


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

    Your help regarding on this will be very much appreciated.


  7. Bryant
    Jul 14, 2015

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


  8. Harish
    Jul 06, 2015

    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.

  9. @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?

  10. MD.Mohitul Haque
    Jun 25, 2015

    This was very helpful,thanks.

  11. Rami
    Jun 23, 2015

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

  12. nikhil
    Jun 19, 2015

    please send me the spreadsheets

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

    Can you pls help me to download .

    With Regards,

  14. mohamed
    Apr 15, 2015

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

  15. pradeep
    Apr 12, 2015


  16. sathishchowdary
    Mar 27, 2015

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

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

  18. saravanan
    Mar 25, 2015

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

  19. omar
    Mar 04, 2015

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

    thanking you

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

  21. Sumit
    Feb 13, 2015


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

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


  23. SM
    Jan 17, 2015

    It’s Cool!!!

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

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

  26. tommy
    Dec 21, 2014

    please sent for me password unprotect file excel if can

  27. Kazem
    Dec 10, 2014

    Calculated filter harmonic and filter D teuned
    Thank you

  28. Md Mosharaf Hossan
    Dec 05, 2014

    How i wll be able download excell sheeet

  29. Dimitrios Chouliaras
    Dec 02, 2014

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

  30. kazem
    Oct 09, 2014

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

  31. mohd azharuddin
    Oct 02, 2014

    Dear Sir,

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


    Aug 26, 2014

    Hi guys,
    i like the discussions in this wonderful forum.

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

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

  35. haradongan pasaribu
    Aug 16, 2014

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

  36. Shine
    Aug 14, 2014

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

  37. Mohammed Yousuf A
    Aug 14, 2014

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

    Aug 11, 2014

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

  39. Lars
    Jul 30, 2014

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

  40. HARISH
    Jul 29, 2014

    Thank you very much sir…..
    really really thanks

  41. surasitw
    Jul 15, 2014

    I want Program Calculation .

  42. jafari
    Jul 12, 2014

    you are the best
    thank you veryveryveryvery veryveryveryvery much

  43. rijvan
    Jul 12, 2014

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

    I m feel lucky to visit this site

  44. sina.ma
    Jul 03, 2014

    Thank you very very much .

  45. dehghani
    Jun 29, 2014

    Thanks a lot………..

  46. shayesteh
    Jun 29, 2014

    Thank you verryyyyyy mach

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

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

  48. John Lovel
    Jun 12, 2014

    Really g8t Efforts and Thanks alot.

  49. Do Duc Thai
    Jun 11, 2014

    Please give us the password to use these tools.

    Thank you very much.

  50. sun
    Jun 08, 2014

    required 132 KV transmission losses calculations

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

    Jun 04, 2014

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

  53. sudhir
    Jun 03, 2014

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

  54. thank from your information
    May 20, 2014

    good information

  55. ZISHAN
    May 17, 2014

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

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

    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.

  58. chris weche
    Apr 03, 2014


  59. Ayo
    Mar 25, 2014

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


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

    Thanks in advance.

  61. aruel
    Jan 26, 2014

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

  62. A.shiraj Ahamed
    Jan 10, 2014

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

  63. umut
    Jan 08, 2014

    İ cant download it

    • Edvard
      Jan 08, 2014

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

  64. Yadagiri.Y
    Jan 03, 2014

    Pls, share…..!

  65. Ronald
    Jan 03, 2014

    Dear Sir,

    how to down load this?? thanks


  66. Ramnik
    Dec 15, 2013

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

    Dec 12, 2013

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

    • Edvard
      Dec 12, 2013

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

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

  69. S S A
    Dec 11, 2013

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

  70. Pankaj Rane
    Dec 05, 2013

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

  71. Arulanandan S
    Dec 04, 2013

    not available for down loading

  72. pd1986
    Nov 29, 2013

    files are not downloading from mobile please help

  73. oynotna
    Oct 25, 2013


  74. keshrimohit38
    Oct 09, 2013

    Awesome… Hats off to all of them … :)

  75. shergill
    Oct 06, 2013

    what is the password sir

  76. mk_sanaye
    Sep 27, 2013

    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

  77. IMI
    Sep 17, 2013

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

  78. Rukhsar Ali
    Sep 08, 2013

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

  79. quochuy
    Sep 04, 2013

    Thank you very much for your help…

  80. sivapacr
    Aug 22, 2013

    Thanx a lot sir for the great work.

  81. Adem1
    Aug 14, 2013

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

  82. trinhminhnhat
    Aug 10, 2013

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

  83. aakifnouman
    Jul 23, 2013

    You made the life easy thankyou

  84. afk
    Jul 20, 2013

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

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

  86. sat07babu
    Jul 09, 2013

    nice work congrats ….

  87. THIAGO
    Jul 04, 2013


    Thanks and congratulations for the excelent work!

  88. rahul chauhan
    Jun 29, 2013


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

  90. Mandy
    Jun 27, 2013

    this is wonderful!

  91. mycandy
    Jun 15, 2013

    Many thank to you!

  92. pnp
    Jun 03, 2013

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

  93. BAMBAA
    May 31, 2013


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

  95. 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?
    thank you and i’ll appreciate any help you give

  96. Kevin Felix
    Apr 18, 2013

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

  97. aleskndr
    Apr 05, 2013

    please how can i download

  98. Tadikamallasairam
    Mar 12, 2013

    could you please tell me how to download these spreadsheets

  99. tarekdia
    Dec 23, 2012

    this is a test format for 13.8 kv switchgear


    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


    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.1 Function Test.

    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:


    1 MIN

    1 MIN

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

    3.3 Contact Resistance Test: Current injected 100A



    Test Kit : Megger & CPC 100

    3.4 Breaker Timing Set

    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

  100. roel
    Dec 08, 2012

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

  101. ali1980
    Nov 27, 2012

    Thanks, very usefull

  102. psrpskumar
    Nov 26, 2012

    thankyou very usefull for me

  103. cmurugan-design
    Nov 15, 2012

    Pls post current transformer design xlx

  104. m0Handaznelson
    Nov 01, 2012

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

  105. mohamed Iqbal
    Oct 31, 2012


  106. akira
    Sep 19, 2012

    Sincere thanks and appreciation to this wonderful forum

Leave a Comment

Tell us what you're thinking... we care about your opinion!
and oh, not to forget - if you want a picture to show with your comment, go get a free Gravatar!