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.
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) | 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 | . |
Electrical calculations (MS Excel Spreadsheets) | Download |
Power Factor Correction Calculation | . |
Calculation of Touch Voltage and Ground Current | . |
IDMT (Inverse Definite Minimum Time) Relay Calculation | . |
Calculate Size of Diesel Generator | . |
Electrical Pole’s Trasverse Load Calculation | . |
Electrical Engineering General Formulas | . |
CO2 Savings Calculator | . |
Available Fault Current Selective Coordination | . |
Power Factor Table Calculator | . |
NEMA Motor Data Calculator | . |
Estimated Voltage Drop Calculator | . |
IEC Motor Data Calculator | . |
Calculation of Size of Transformer, Fuse and Circuit Breaker | . |
Calculate Size Of DOL and Star-Delta Starter Components | . |
Calculate size of transformer and voltage due to starting of large size motor | . |
Power Quality Solution Selection Spreadsheet | . |
Spreadsheet For Calculating Size Of Motor Pump | . |
Spreadsheet For Calculation The Required Number Of fixtures And Illuminance Level | . |
Lightning Protection Risk Assessment Calculator/Spreadsheet | . |
Load Listing, Calculations and Generator Sizing Spreadsheet | . |
Spreadsheet for Transformer Losses Calculation | . |
Motor Voltage Drop Calculator (Spreadsheet) | . |
Spreadsheet to calculate the size of neutral earthing transformer | . |
Spreadsheet to Calculate Short Circuit Capacity of Diesel Generator Synchronizing Panel | . |
Power factor correction calculations for power system | . |
Distribution Transformer Calculations | . |
Calculation of electro magnetic field (EMF) around T&D overhead lines | . |
Earthing system design tool for low voltage installations | . |
Sure they are still downloadable…
very useful
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
Can you help me download this spreadsheets?
I think its so easy just click the link with “RIGHT HERE” next to the download
Yes it is for grid modernization of Ethiopian electric power program
I want download thé excel data
Is there a possible way to get standard technical specification for preparation of international bid for laboratory equipment of electric power company
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.
Have not visited the site for a long time. The Excel calculation Spreadsheets can not be downloaded anymore.
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.
What is the % of load you are ruining the Tr-r. at?
which is the password of calculation books
Veryinterested
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.
Thankyou!, but i need autocad app
I have a question , all these spreadsheets will work well on a Mac ? Is there a fee or a price ?
Thanks
Hello.
How can I download Residential Load Calculator? Do I have to sign in?
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.
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.
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.
hello sir,
i want to learn how can i read a electrical drawing in simple way.
thank you
Hello sir,
I want voltage drop calculation formula for selection actual cable size.
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
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.
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.
I need more app on Electrical design
Please how do I open an account to login to the site.
Great website with huge bunch of knowledge.
Hello sir
I want to simulate electric and magnetic field under power line
Could I have thé EF and MF CALC software?
Thanks
Good to expand knowledge in respective field.
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!!!!!!
A great professional platform that allows us to solve problems .
Thank you ver much.
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
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.
It is too much supporting to expand know-how of knowledge of the respective field.
Good to expand knowledge in respective field.
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
Thank you so much for sharing all these tools and documents. These are very important for our business
Do yo have power system security, Load Flow Analysis and contingency analysis excel sheet?
Thank you very much
Hi , Do you have SOLAR Farm design calculations for selection of fuse, 1500V DC wire harness selection, tracking calculations etc.
spreadsheet for star delta starters calculations is protected. how to use it
I like this Portal since long time ago…..
Thanks for the good Job
i need refererence to start learning electrical systems from scratch, which is the best books to start with
HT motor cable calculations
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
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.
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.
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
Dear all: thanks a lot for all your useful info; that is what we need to work for! The devil is in the details!
Thanks, very usefull
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
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.
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.
Hi,
How to download this template?, I need it.., please.
Thanks.
transformer size-2000kva(11kv/433v)
cable length-150 feets
hv/lv amps-104/2666
we required cable size from transformer to pmcc panel
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 ?
good work gives good appreciation…….. i like this…….. done a good job thank u
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.
great assistance.I have downloaded a few of the spreadsheet. hopefully they serve the intended purpose. great work nevertheless
hi
please send me the password
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.
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
Dear Sir,
we need a Dc cable Calculator for find out the size of cable for varies DC motor or invertor.
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
Thank You very much. Your article is of great help to me as an electrical engineer. It will surely boost my electrical strength.
can you plz upload a sheet that contains calculation of energy savings by correcting the harmonics in the system
Thank you for sharing these tools for calculations, they are very helpful.
Thank You EEP
Its very useful
its very good
where is download link
thanks
Thankyou very much, so great.
Very useful. Thank you very much EEP. :) More powers!
Good program
Thank you for all these incredible calculation sheets. Really welcome!
Great job. Thank you a lot for sharing.
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 !!!
Great work please tell us passwords of the sheets so we also can work for improvisation
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.
This is simply amazing! Thank you so much.
Sea of info. Great work !!!
Good initiative, keep it up
excellent reference it helps a lot.
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?
I am not able to download the excel sheet
i am not able to download the excel sheets
Hi team,
if there is any shortcuts or easy methods in testing commissioning,and how can reduce the commissioning time for particular tests..
Thank you so much for such a great files. these are one of the best tool for electrical systems. keep it up
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
Great effort to organize EE info at one place, future target should be to evolve projects group.
regards
Adil
EE
Thank you a lot for sharing.
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??
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
These excel worksheets are very useful for design engineers. Thank you for sharing free of cost on purpose knowledge for everyone.
Very nice of you sir.
Thank for your support…
thank you, very useful.
that’s very helpful… great
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.
Dear EEP Team,
you are doing a wonderful job by making available such calculations for every day use by practicing engineering professionals, cs nambisan
Thank you so very much.
Thanks a lot.
Thanks a lot. Very Very Helpful
Excellent
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
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.
Hi,
i want to buy a lap top for scada system
Hello sir,
I want to know that, is there any calculation table for transformer firewall protection?
THANKS
Thanks, very much..
Thank you.
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
Nice solution
anyone have Siemens software (Starter v 4.3 for Siemens Drive(VFD) G120).please upload anywhere and send me link.
thanks.
Atiq
Have you checked on Siemens’s website?
http://w3.siemens.com/mcms/mc-solutions/en/engineering-software/starter-commissioning-tool/pages/starter-commissioning-tool.aspx
Dear i have already checked on Siemens’s website but cannot register and download.
Please I like to calculate the required number of earth rods for substation mat specially in the preimeter
Thanks in advance
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?
Thanks… Thumbs Up
Thanks a lot, Very usefull
Hi. Thanks, very usefull
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.
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
Thanks a lot. very useful
I need Electrical AutoCAD or same software for design of electrical schema please send me link of
thank you very much sir
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.
Thanks a lot.
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)
thank you very much. such information is very useful to me as a young electrician.
Thank you you helpful best regard
The best site ever!! Thank You very much for Your effort!!!
you are welcome.
Thank you of your work in Electric Engineering.
Hello.
Thanks a lot for your large Heart to share this useful knowledges.
THANK YOU!!!!
Thanks a lot
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.
One of the best knowledge sharing website. Great job by Edvard and his supporting team.
the best site,
Thank you very much
Good day, do you have a spreadsheet to estimate cooling/heating for control panels?
Thanks.
Could you please send to me all sheets because register now not allowed
Thank YOU very much, All of calculation is so Perfect . . .
Thanks
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
DEAR ALL
THANK YOU SO MUCH FOR THIS GREAT WEBSITE AND THESE LINKS
BEST REGARDS
YOURS
ABDUL QAYYUM
Sincere thanks and my appreciation to this wonderful forum.
thanks allot , appreciation to this wonderful forum
Thank you so much for the organised sheets. it really is helpful.
DEAR ALL
THANK YOU SO MUCH FOR THIS GREAT WEBSITE AND THESE LINKS
BEST REGARDS
YOURS
EMAD
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].
WOW…. I just love you… there, I said it :-)
thanks!
what is X´mer?
X’mer is short for Transformer.
thank u this is very helpful
Thanks, very usefull
Thank you very match this was really very useful in the engineering design job . ,
It’s amazing thank you so much sir…
with regards to all of u members
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,
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.
coool,,
thanks a lot they have been useful to me
Thanking you Mr. Jignesh Parmar and others for sharing wonderful, useful and data sheet and spreadsheet.
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
A quick reference website for wire size and circuit protection calculations:
http://wiresizecalculator.net/
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.
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?
This was very helpful,thanks.
Is there a link to download all the spreadsheets, instead of one by one? Thanks
please send me the spreadsheets
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
thanks a lot for this support to my new challenge work :)
I want to CODES/RELEVANT STANDARDS IE, IEC,IEEE & CBIP MANUALS.
Dear Sir, I want how to select relay for a electrical usages.
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?
Dear sir , can you provide me a spreadsheet to calculate harmonic . thank you.
You can find one in ABB site. Just Google harmonic estimator ABB group.
Dears if there Excel spreadsheet to calculate reactors size kindly provide me
thanking you
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.
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
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
It’s Cool!!!
can you provide me spreadsheet to calculate the sag and span and tension for transmission line please…thank you so much!
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?
please sent for me password unprotect file excel if can
Hi
Calculated filter harmonic and filter D teuned
Thank you
How i wll be able download excell sheeet
hello guys, im interested in calculate proper diesel generators for industrial projects
Hi, thanks for the very good Excel files to calculate file requests Series Inductors which are industrial drives
Dear Sir,
i am working on calculating Rct of current transformer please help me how to calculate this
thanks
Hi guys,
i like the discussions in this wonderful forum.
I AM STILL A STUDENT AND I HOPE TO BENEFIT FROM YOU
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.
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…
I am interested in electrical software/ CD file designing for MV/LV circuits. can you guide me on that?
I want Program Calculation for ups sizing…and ups spread sheet…
Great job Mr Parmar, very helpful information in the site. nice….
I NEED MONTHLY,DAILY Grid Availability – Seet plz help me
Very nice spreadsheets. Anyone got one for calculating generator incomer CT?
Thank you very much sir…..
really really thanks
I want Program Calculation .
you are the best
thank you veryveryveryvery veryveryveryvery much
I ll recomend this site for all engineer who never stop learning..
I m feel lucky to visit this site
Thank you very very much .
Thanks a lot………..
Thank you verryyyyyy mach
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.
Great Vivek! You can send your spreadsheets to office/AT/electrical-engineering-portal.com.
Really g8t Efforts and Thanks alot.
Please give us the password to use these tools.
Thank you very much.
hi Do Duc Thai
can you send me password of excel files?
required 132 KV transmission losses calculations
Let us know if you are still looking for the same.
This is a wonderful and very helpful thing that you have done. Do you have plans to do a medium voltage motor calculation sheet?
Im very glad tha you post this helpful and very usefull computation
great content for electrical engineers, please remove the protection for the files, we want to utilize it
good information
All the excel sheets are password protected. How to remove the password
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.
I am Electrical engineer in Ethiopia. My interest is to be the member of number one 1 Electrical engineer in the world.
YOU GUY(S) ARE GOD-SENT,YOU ARE A BLESSING TO THE UNIVERSE.MAY THE ALMIGHTY GOD GRAND U FAVOUR IN UR ENDEVOURS TOO.
You guys have really done a good job. Having these spreadsheet handy for a rough estimate saves time a lot.
thanks
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.
Thanks EEP for your generosity! I got all the spreadsheets almost 45 for free. a very helpful docs.
God bless!
I can’t download this software. But this is very important and very useful for all technical persons
İ cant download it
Please elaborate… cannot help according to ‘I cant download it’ ;)
Pls, share…..!
Dear Sir,
how to down load this?? thanks
Regards
R.I
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!
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.
but sir i cannot edit the “total electrical load” cell…
plz help
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
Dear sir,
Please help me sir i am not able to download the Excel sheet details like voltage drop calculation, elrctrical formulad etc.,
Everything is available for free download, I don’t see any problem ;)
Its awesome. Thank you very much for the references ..Pls. dont be sate to share your knowledge. Go will bless you.
Please include the checklist for installation of electrical items (DBs/ Panels / Transformers / DG/ ACB etc)
It’s really very helpful , thanks a ton!!!!
not available for down loading
files are not downloading from mobile please help
Salute!
Awesome… Hats off to all of them … :)
what is the password sir
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
Very important information that to free. May ALLAH (There is no god but allah) bless you.
Its my pleasure to be here & i am thankful to you for sharing such information.
Its too much helpful
Thank you very much for your help…
Thanx a lot sir for the great work.
Thank you very much for your efforts, it’s really nice job,
thanks so much for ur non-profit work!im grateful for that and dont know how to give a thanks!:(
You made the life easy thankyou
Suggest any method to design and sizing of control/switch gear panels.
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.
nice work congrats ….
Awesome!
Thanks and congratulations for the excelent work!
thanks
Very nice spreadsheets! Is it possible to make one about 3-phase transformer inrush and aprox. voltage drop caused by inrush?
this is wonderful!
Many thank to you!
nothing more to say…….. a big hug for this help. u r doing a great help to students like me….
HI GUYS, SOMEBODY HELP ME HOW TO COMPUTE MAIN DISTRIBUTION PANEL LOAD SCHEDULE. I WISH SOMEBODY HAVE A SPREADSHEET / XLS TEMPLATE. =)
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?
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
Can someone tell me how to download Electrical MS Excel Spreadsheet.
You must register and download links will be visible. Go ahead and register here:
https://electrical-engineering-portal.com/wp-login.php?action=register
and then login here:
https://electrical-engineering-portal.com/wp-login.php
Hope this helps a little bit ;)
Edvard
can you brief about relay coordination study and send me example calculation
please how can i download
could you please tell me how to download these spreadsheets
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
Thanks to all the contributor and developer of this site/forum…very helpful
Thanks, very usefull
thankyou very usefull for me
Pls post current transformer design xlx
Superb! very useful, i learned a lot…thanks…
THANS VERY HELP FULL
Sincere thanks and appreciation to this wonderful forum
do you have a Medium voltage voltage drop calculator excel for over head power line cable?