Four Fast Transformer Calculations
Distribution transformer calculations spreadsheet provides fast calculations for the following: Determining the MV/LV transformer rating, calculating overcurrent protection device rating on the low voltage side of the transformer, calculating the prospective short circuit current and Calculating natural ventilation openings sizes required for the transformer room.
1. Determining the MV/LV transformer rating
Input parameters:
- Primary rated voltage (kV.)
- Secondary rated voltage (kV.)
- Max. demand load (kW)
- Power factor after correction
- Transformer type
- Permissible loading percentage (%)
- The nearest standard transformer rating (KVA)
2. Calculating overcurrent protection device rating on the low voltage side of the transformer
3. Calculating the prospective short circuit current across the low voltage side of the transformer
4. Calculating natural ventilation openings sizes required for the transformer room.
| Software: | Distribution Transformer Calculations – MS Excel Spreadsheet |
| Version: | – |
| Developer: | Mahmoud Salama |
| Size: | 278 KB |
| Price: | FREE |
| Download: | Right here | Video Courses | Membership | Download Updates |
Thanks for the useful file
Please include the effect of the height above sea level in the file so that the final number is completely correct
Thank you, Mahyar!
EEP is the geat technical teachers for me. Sometimes during using the temperature correction, why you used 225 only without identifying copper or aluminium? unless the rest was very good for me.
will appreciate to receive tranfomer calculations file
How can the parameter database be updated? I got a 1600kVA dry type transformer with lower losses than what is used as example.
Thanks
Try downloading it, but have restrictions
Could anyone share the password of this Distribution Transformer Calculation sheet? It’s in protected mode. Need to unprotect it to understand calculations…
Thanks
Have you received the password, if yes, let me know also.
Useful. However some basic mistakes are there like the unit of Impedance has been given in Ohm.mile which could not be correct. It should be just Ohm. Further the bottommost table(left side) is presented in a way which can not be called user friendly and technically not correct also.
I want detail calculations related to the electrical LT HT panels
CT/ VT calculations
Breaker sizing
Cable rating calculation
If any one have please email me
I em beginner level
I desire that you will help me improve based on the how technology has advanced.
it is simply great
EEP is the best way I have to update my knowledge in electrical engineering. This article is a sample of the great value of EEP in the world.
This is so helpful. Thank you for this.
But is would be better if you can define the terms use next time because of beginners. Thank you once again.
Please anyone send me in Email
it’s very good.
I do recommend fellow technicians to make use of the portal. it has been of great value
How can i down load the templates
I would like to have a low power transformer spread sheet work sheet
Hi..what could be the cause of mccb heating up and giving out a smell then one pole changes colour to darkish… your response will be highly appreciated
sir, do you have single phase distribution transformer design excel file 6350/240 V, 50 Hz, it will very helpful for me. Thanks in advance .
Good day!
How i can test the xls file? i’m not able to download….
thanks for your attention
Romano
Please send lighting excell spread sheet
EEP is very, very useful and it help me a lot.
Thank you very much for being part of my success.
Thank you.
Dear Sir,
Please tell me how to calculate tapping of distribution transformer. Please send the formulas for calculating tapp.
Thank You!!
please let me know how to design the foil of the distribution transformer , does any one have a design book?? if i have the power data what else i need to do? thank you all!!
this is great portal , i need your help please.
i need to design distribution power transformer , and i need to know how!
do you have any books? sources of design?
Great website to all electrical engineering students and for my work.
EEE is very very useful web site electrical engineers.I learnt more from this.
It is very useful
The link isn’t working for me :/
If you want more proffesionally distribution transformer test report xls file please contackt with by e-mail transformersdesign hotmail.com
I would like to get xls. Calculate sheet template
good very useful thanks
Very Useful
Thanks