Search

Premium Membership ♕

Limited Time Offer: Save 15% on PRO Plan with discount code: LRN15 and study specialized LV/MV/HV technical articles and studies.

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

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

Spreadsheets are mostly developed by experienced electrical engineers and programmers and by well-known manufacturers of electrical equipment. They all really did an awesome job, we must admit!

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.
Electrical Safety Program Arc Flash Calculator.
Transformer And Short Circuit Calculator.
Electrical calculations (MS Excel Spreadsheets)  Download 
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.
Calculation of electro magnetic field (EMF) around T&D overhead lines.
Earthing system design tool for low voltage installations New.

Premium Membership

Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

More Information

278 Comments


  1. Emmanuel
    Aug 27, 2023

    Sure they are still downloadable…


  2. israel
    Jun 13, 2023

    very useful


  3. ramsevakmukhiya
    Jun 04, 2023

    so great tools i found here my pleasure to reach your portal many many thanks for such time saving tools
    if possible looking forward to hyadaulic pump motor sizing spread sheet

    thanks


  4. Harshid
    May 19, 2023

    Can you help me download this spreadsheets?


    • Emmanuel
      Aug 27, 2023

      I think its so easy just click the link with “RIGHT HERE” next to the download


  5. Tamiruabate
    May 12, 2023

    Yes it is for grid modernization of Ethiopian electric power program


  6. Rahal El RHAZI
    Apr 20, 2023

    I want download thé excel data


    • Tamiruabate
      May 12, 2023

      Is there a possible way to get standard technical specification for preparation of international bid for laboratory equipment of electric power company


  7. Adeboye Lateef Idowu
    Feb 09, 2023

    Hi, a good day to you at EPP.
    I am an entrepreneur looking into setting up a cassava starch manufacturing factory. The power requirement of the processing line is about 180 – 200kwh.
    Firstly, I will like to ask – is your organization based in Nigeria?
    Secondly, I want to ask that for this kind of project, how much will it cost If your team or organization were to install this project? Let us assume the plant site is 15km away from a 33KVA power source.


  8. Wilson Law
    Jan 13, 2023

    Have not visited the site for a long time. The Excel calculation Spreadsheets can not be downloaded anymore.


  9. Isma'eeel Suleiman
    Nov 21, 2022

    Hello,i am Ismaila from Nigeria,i have installed a 1mva transformer and a 500kv one,i keep having an over voltage reading of above 250v when read on face to neutral and over 450v face to face reading.i am sure that my neutral grounding is adequate and efficient.i have also factored my incoming voltage and arrived at most appropriate TAP,i have also altered all TAPS and all produces till yet high voltages.pls advice on any other options i may have..Thank u 4 your anticipated support.


    • Adey
      Nov 27, 2022

      What is the % of load you are ruining the Tr-r. at?


  10. EDUARDO
    Oct 05, 2022

    which is the password of calculation books


    • Boaz Mwakasaka Duncan
      Oct 07, 2022

      Veryinterested


  11. Mominur Nur Hossain
    Jul 16, 2022

    I am a graduate engineer in electrical engineering, I have more than 10 year of working experience in Power Generations of verious Ltd company in relocated all over India and with open to all rules and responsibilities.


  12. AREGAWI
    Jul 08, 2022

    Thankyou!, but i need autocad app


  13. Fermin Nunez
    Jun 21, 2022

    I have a question , all these spreadsheets will work well on a Mac ? Is there a fee or a price ?
    Thanks


  14. B. Gancarz
    Feb 18, 2022

    Hello.
    How can I download Residential Load Calculator? Do I have to sign in?


  15. Prasanth R
    Feb 01, 2022

    Do these sheets work in Google Sheets? If yes, has anyone figured out a way to make the calculations work right? I’ve tried to open the .xlsx files in Google sheets but the formulas won’t work.


    • Edvard
      Feb 01, 2022

      Most of these sheets have macros working behind and that’s why they don’t work. Maybe there’s some way to activate macros in G Sheets.


  16. Georgios MARIOLIS
    Dec 17, 2021

    I was wondering if an installation of capacitors in some motors of a cargo ship is meaningfull and efficient.
    I was thinking to add capacitors to 5 motors of 55kw each, which are operating 24/7/365 and reduce their reactive power.
    Read so many articles, that i am now confused.
    Of course it will be of a profit but at the same time i am very interested in the vessel’s power grid safety and stability too.


  17. Ali
    Dec 13, 2021

    hello sir,
    i want to learn how can i read a electrical drawing in simple way.

    thank you


  18. SUNNY
    Nov 27, 2021

    Hello sir,

    I want voltage drop calculation formula for selection actual cable size.


  19. Roberto de Vries
    Nov 17, 2021

    Good day.

    I hope you could assist me with some advice please, as getting any reaction from solar companies, seems impossible!

    I reside in Augrabies and do irrigation from an irrigation canal on the lower side by means of flood irrigation. On the higher side I use electric water pumps. The bigger one for irrigation and the smaller one for drinking water to a tank.

    I currently use power from Escom, but want to change it to solar power.

    The big pump takes water directly from the canal and it is mainly used during daytime.

    The small pump is on a borehole which is 14m deep and the watertable stands at 8m. It is usually used during daytime as well.

    I would be so grateful if you could assist me with the correct different solar equipment needed, please. The battery, solar panels, inverter and controller.

    Thank you so much.

    Friendly regards.

    Roberto de Vries
    Cell: 0722095373


  20. Alet
    Nov 10, 2021

    I need a excel spreadsheet that calculate earthmoving machine’s working hrs per day worked exmple machine start hrs is 525 next day beginning hrs is 550. Hrs worked is 25 hrs and per month and also in the calculation it must redflag you on when its due for maintenance service. Maintenance services is normaly after 250hrs, 750hrs, 1000hrs or 2000 hrs. as soon as the machine reach his next due maintenance service hrs, the spreadsheet warn you by redflagging the hrs.
    Feel free to contact me if you need any other information.


    • Er. Salman Malik
      Jan 25, 2022

      Hi Alet,

      it would be interesting to work on it & prepare a master data sheet for you.
      @Alet kindly drop an email with details on my email : [email protected]

      thanks.


  21. AYODEJI IDRIS. O
    Sep 09, 2021

    I need more app on Electrical design


  22. Joshua Kojo Blankson
    Aug 30, 2021

    Please how do I open an account to login to the site.


  23. Barthélemy Nijimbere
    Aug 09, 2021

    Great website with huge bunch of knowledge.


  24. ADEGBOLA
    Aug 05, 2021

    Hello sir
    I want to simulate electric and magnetic field under power line
    Could I have thé EF and MF CALC software?
    Thanks


  25. Lema Doudou Masamba
    Jun 28, 2021

    Good to expand knowledge in respective field.


  26. Swajan Kanti Barua
    Jun 09, 2021

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


  27. Jack Su
    May 06, 2021

    A great professional platform that allows us to solve problems .
    Thank you ver much.


  28. Khalid
    Mar 20, 2021

    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


  29. Andrew Herbert
    Feb 19, 2021

    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.


  30. Manoj Patel
    Feb 08, 2021

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


  31. Manoj Patel
    Feb 08, 2021

    Good to expand knowledge in respective field.


  32. 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.
    I hope to receive your reply very soon

    thank you so much


  33. stephanson
    Jan 05, 2021

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


  34. SAIFEE KEZARBHAI KANJETAWALA
    Oct 16, 2020

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


  35. veerayut pojui
    Oct 15, 2020

    Thank you very much


  36. RAJ
    Oct 08, 2020

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


  37. kailash singh
    Sep 22, 2020

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


  38. Armen Zar
    Sep 15, 2020

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


  39. muthukumar
    Aug 06, 2020

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


  40. Radhika Kamdi
    Jul 17, 2020

    HT motor cable calculations


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


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


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


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


  45. Ahmed Motelb
    May 08, 2020

    Thanks, very usefull


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


  47. Fureek
    Apr 07, 2020

    Hi,

    How to download this template?, I need it.., please.

    Thanks.


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


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


  50. Srinivasa rao
    Feb 14, 2020

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


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


  52. Mentus Ugwu
    Jan 31, 2020

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


  53. hadi
    Jan 13, 2020

    hi
    please send me the password


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


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


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


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


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


  59. koustav paul
    Oct 14, 2019

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


  60. Leonardo Quintero
    Oct 03, 2019

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


  61. shyam
    Sep 11, 2019

    Thank You EEP
    Its very useful


  62. mohamed nady
    Sep 10, 2019

    its very good


  63. Ayman
    Aug 24, 2019

    where is download link


  64. Ayman
    Aug 24, 2019

    thanks


  65. Si Thu Aung
    Aug 24, 2019

    Thankyou very much, so great.


  66. Cyril
    Aug 18, 2019

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


  67. George
    Aug 10, 2019

    Good program


  68. GJ Mol
    Jul 18, 2019

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


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


  70. Vinayak
    Jun 12, 2019

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


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


  72. Walkan
    Apr 25, 2019

    This is simply amazing! Thank you so much.


  73. Vinay Haldikar
    Apr 17, 2019

    Sea of info. Great work !!!


  74. JOKOTOYE OYEWOLA
    Apr 12, 2019

    Good initiative, keep it up


  75. joniel tangapa
    Mar 25, 2019

    excellent reference it helps a lot.


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


  77. Anil
    Jan 16, 2019

    I am not able to download the excel sheet


  78. Ali Ahmad
    Jan 01, 2019

    i am not able to download the excel sheets


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


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


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


  82. Adil Agha
    Oct 06, 2018

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


  83. LE VUONG
    Oct 04, 2018

    Thank you a lot for sharing.


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


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


  86. Emmanuel
    Aug 28, 2018

    Very nice of you sir.


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

    Thank for your support…


  88. Ahmad Wahid
    Jul 28, 2018

    thank you, very useful.


  89. samer
    Jun 24, 2018

    that’s very helpful… great


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


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


  92. Shaddai
    Mar 10, 2018

    Thank you so very much.


  93. Mounir
    Feb 17, 2018

    Thanks a lot.


  94. Prawin
    Feb 11, 2018

    Thanks a lot. Very Very Helpful


  95. Khaled Ellithy
    Jan 25, 2018

    Excellent


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


  97. ISLAM LIKA
    Dec 16, 2017

    Hi,
    i want to buy a lap top for scada system


  98. ANKUR SENGUPTA
    Dec 14, 2017

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

    THANKS


  99. choi85
    Dec 12, 2017

    Thanks, very much..


  100. Raphael Sangrador
    Nov 10, 2017

    Thank you.


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

    Thanks in advance

    BR
    Jayaraj.k


  102. Pisit
    Oct 21, 2017

    Nice solution


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


  104. Reda Mostafa
    Aug 30, 2017

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


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


  106. Michael
    Aug 14, 2017

    Thanks… Thumbs Up


  107. Mirwais
    Aug 05, 2017

    Thanks a lot, Very usefull


  108. Mohammad reza Amirahmadi
    Jul 17, 2017

    Hi. Thanks, very usefull


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


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


  111. QVN
    Jun 17, 2017

    Thanks a lot. very useful


  112. nabi
    Jun 15, 2017

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


  113. TOLBA
    Jun 10, 2017

    thank you very much sir


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


  115. Mohammed AbuRayya
    May 10, 2017

    Thanks a lot.


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


  117. peter malus
    Apr 03, 2017

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


  118. Mohmmad Thapet
    Mar 23, 2017

    Thank you you helpful best regard


  119. Zorica Popovic
    Mar 14, 2017

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


    • Faizan
      Mar 20, 2017

      you are welcome.


  120. Tarqiullah
    Mar 01, 2017

    Thank you of your work in Electric Engineering.


  121. hoss
    Feb 27, 2017

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


  122. ashenafi
    Feb 23, 2017

    THANK YOU!!!!


  123. Hassan
    Feb 04, 2017

    Thanks a lot


  124. kiran Kumar Avadhanula
    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.


  125. Sridhar
    Feb 01, 2017

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


  126. Thabiso Boase
    Jan 19, 2017

    the best site,


  127. Ashraf Zaher
    Nov 30, 2016

    Thank you very much


  128. E MARTINEZ
    Oct 17, 2016

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


  129. mohamed
    Sep 26, 2016

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


  130. saman
    Aug 17, 2016

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


  131. Ismaeil
    Aug 01, 2016

    Thanks


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


  133. ABDUL QAYYUM
    May 12, 2016

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


  134. Pal
    May 09, 2016

    Sincere thanks and my appreciation to this wonderful forum.


  135. mouaz mohamed
    Apr 28, 2016

    thanks allot , appreciation to this wonderful forum


  136. Aditya Vyas
    Apr 25, 2016

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


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

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


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


  138. Bojan Petreski
    Mar 26, 2016

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


  139. Ricardo
    Mar 17, 2016

    what is X´mer?


    • K P Kesavan Nair
      Feb 17, 2017

      X’mer is short for Transformer.


  140. anwer
    Mar 16, 2016

    thank u this is very helpful


  141. SERGIO sds
    Mar 10, 2016

    Thanks, very usefull


  142. Nasser .M
    Mar 03, 2016

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


  143. hazir
    Jan 11, 2016

    It’s amazing thank you so much sir…


  144. G UPENDER
    Nov 10, 2015

    with regards to all of u members


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


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


  147. khaled
    Aug 15, 2015

    coool,,

    thanks a lot they have been useful to me


  148. Pankaj Desai
    Aug 13, 2015

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


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


  150. Bryant
    Jul 14, 2015

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

    http://wiresizecalculator.net/


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


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


  153. MD.Mohitul Haque
    Jun 25, 2015

    This was very helpful,thanks.


  154. Rami
    Jun 23, 2015

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


  155. nikhil
    Jun 19, 2015

    please send me the spreadsheets


  156. 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,
    R.Ravikumar


  157. mohamed
    Apr 15, 2015

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


  158. pradeep
    Apr 12, 2015

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


  159. sathishchowdary
    Mar 27, 2015

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


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


  161. saravanan
    Mar 25, 2015

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


    • Farhad Kohestani
      Oct 11, 2018

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


  162. omar
    Mar 04, 2015

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

    thanking you


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


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


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


  166. SM
    Jan 17, 2015

    It’s Cool!!!


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


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


  169. tommy
    Dec 21, 2014

    please sent for me password unprotect file excel if can


  170. Kazem
    Dec 10, 2014

    Hi
    Calculated filter harmonic and filter D teuned
    Thank you


  171. Md Mosharaf Hossan
    Dec 05, 2014

    How i wll be able download excell sheeet


  172. Dimitrios Chouliaras
    Dec 02, 2014

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


  173. kazem
    Oct 09, 2014

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


  174. mohd azharuddin
    Oct 02, 2014

    Dear Sir,

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

    thanks


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


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


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


  178. haradongan pasaribu
    Aug 16, 2014

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


  179. Shine
    Aug 14, 2014

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


  180. Mohammed Yousuf A
    Aug 14, 2014

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


  181. SOLANKI RAJESH
    Aug 11, 2014

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


  182. Lars
    Jul 30, 2014

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


  183. HARISH
    Jul 29, 2014

    Thank you very much sir…..
    really really thanks


  184. surasitw
    Jul 15, 2014

    I want Program Calculation .


  185. jafari
    Jul 12, 2014

    you are the best
    thank you veryveryveryvery veryveryveryvery much


  186. rijvan
    Jul 12, 2014

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

    I m feel lucky to visit this site


  187. sina.ma
    Jul 03, 2014

    Thank you very very much .


  188. dehghani
    Jun 29, 2014

    Thanks a lot………..


  189. shayesteh
    Jun 29, 2014

    Thank you verryyyyyy mach


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


  191. John Lovel
    Jun 12, 2014

    Really g8t Efforts and Thanks alot.


  192. Do Duc Thai
    Jun 11, 2014

    Please give us the password to use these tools.

    Thank you very much.


    • hadi
      Jan 13, 2020

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


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


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


  195. NOEL MENDOZA
    Jun 04, 2014

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


  196. sudhir
    Jun 03, 2014

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


  197. thank from your information
    May 20, 2014

    good information


  198. ZISHAN
    May 17, 2014

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


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


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


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


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


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


  204. aruel
    Jan 26, 2014

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


  205. A.shiraj Ahamed
    Jan 10, 2014

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


  206. umut
    Jan 08, 2014

    İ cant download it


    • Edvard
      Jan 08, 2014

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


  207. Yadagiri.Y
    Jan 03, 2014

    Pls, share…..!


  208. Ronald
    Jan 03, 2014

    Dear Sir,

    how to down load this?? thanks

    Regards
    R.I


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


  210. B.MANJUNATH
    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 ;)


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


  212. S S A
    Dec 11, 2013

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


  213. Pankaj Rane
    Dec 05, 2013

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


  214. Arulanandan S
    Dec 04, 2013

    not available for down loading


  215. pd1986
    Nov 29, 2013

    files are not downloading from mobile please help


  216. oynotna
    Oct 25, 2013

    Salute!


  217. keshrimohit38
    Oct 09, 2013

    Awesome… Hats off to all of them … :)


  218. shergill
    Oct 06, 2013

    what is the password sir


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


  220. IMI
    Sep 17, 2013

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


  221. Rukhsar Ali
    Sep 08, 2013

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


  222. quochuy
    Sep 04, 2013

    Thank you very much for your help…


  223. sivapacr
    Aug 22, 2013

    Thanx a lot sir for the great work.


  224. Adem1
    Aug 14, 2013

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


  225. trinhminhnhat
    Aug 10, 2013

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


  226. aakifnouman
    Jul 23, 2013

    You made the life easy thankyou


  227. afk
    Jul 20, 2013

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


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


  229. sat07babu
    Jul 09, 2013

    nice work congrats ….


  230. THIAGO
    Jul 04, 2013

    Awesome!

    Thanks and congratulations for the excelent work!


  231. rahul chauhan
    Jun 29, 2013

    thanks


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


  233. Mandy
    Jun 27, 2013

    this is wonderful!


  234. mycandy
    Jun 15, 2013

    Many thank to you!


  235. pnp
    Jun 03, 2013

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


  236. 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. =)


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


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


  239. Kevin Felix
    Apr 18, 2013

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


  240. aleskndr
    Apr 05, 2013

    please how can i download


  241. Tadikamallasairam
    Mar 12, 2013

    could you please tell me how to download these spreadsheets


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


  243. roel
    Dec 08, 2012

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


  244. ali1980
    Nov 27, 2012

    Thanks, very usefull


  245. psrpskumar
    Nov 26, 2012

    thankyou very usefull for me


  246. cmurugan-design
    Nov 15, 2012

    Pls post current transformer design xlx


  247. m0Handaznelson
    Nov 01, 2012

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


  248. mohamed Iqbal
    Oct 31, 2012

    THANS VERY HELP FULL


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

Leave a Reply to trevor chandass

Tell us what you're thinking. We care about your opinion! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

  ⁄  one  =  five

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge