Previous in Forum: Grounding of Isolated Gen. Sets   Next in Forum: Shaded Pole Motor Speed
Close
Close
Close
6 comments
Rate Comments: Nested
Member

Join Date: Jul 2014
Posts: 9

Transformer Sizing Calculation

01/22/2015 4:12 AM

Dear all,

I have a doubt in the attached transformer sizing calculation sheet.In the sheet, we have calculated the total KW , KVAR & KVA loads are.

Then we have assumed to take a 2500 KVA tfr for loading these loads.

The power factor correction is also done afterwards.

However, in Row 20, some calculations are very confusing. Maybe my consultant had copied the formula from somewhere.

can somebody explain how the internal reactance(or that is what I guess) of this 2500 KVA is taken , as shown in cell H20?

Does that mean, the formula; reactive KVAR trafo= %Impedance * KVA, is not enough?

A small brief of the formula used in the cell 'H20' would be extremely helpful, since i cannot in anyway find a link between this formula and the one I wrote in the previous sentence,.

Regards

Jithin James

Attachment: http://1drv.ms/1JkdhHD

Register to Reply
Pathfinder Tags: calculation size Sizing transformer
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Guru

Join Date: Mar 2012
Location: Out of your mind! Not in sight!
Posts: 4424
Good Answers: 108
#1

Re: Transformer Sizing Calculation

01/22/2015 8:06 PM

Trouble-shouting Excel spread sheets is a pain. If in doubt follow your instincts and use the formula that is rfrom the books and not the one that is embedded in Excel.

So chances are your consultant has it wrong, but why not talk to him???

__________________
Common Sense Dictates
Register to Reply Score 1 for Good Answer
Member

Join Date: Jul 2014
Posts: 9
#2
In reply to #1

Re: Transformer Sizing Calculation

01/26/2015 11:57 PM

The consultant resigned! moreover, its just one cell, that you need to look into !

Register to Reply
Guru

Join Date: Mar 2012
Location: Out of your mind! Not in sight!
Posts: 4424
Good Answers: 108
#4
In reply to #2

Re: Transformer Sizing Calculation

01/27/2015 8:44 PM

I beg to disagree. You will have to check the whole sheet, the whole file unless you trust that consultant in her/his work.

What does you theory book tell you then? Is the formula correct?

__________________
Common Sense Dictates
Register to Reply
Guru

Join Date: Oct 2012
Location: 100 miles North from the World Center
Posts: 879
Good Answers: 42
#3

Re: Transformer Sizing Calculation

01/27/2015 9:36 AM

If the reactive power of the transformer itself is Q=3*X*I^2 then if I=Sload/sqrt(3)/V and X=[approx.]=uk%/100*V^2/Srat

Q=3* uk%/100*V^2/Srat *( Sload/sqrt(3)/V ) ^2=uk%/100*Sload^2/Srat=uk%*Sload^2/(Srat*100) Q.E.D.

__________________
Julius
Register to Reply
Guru

Join Date: Oct 2012
Location: 100 miles North from the World Center
Posts: 879
Good Answers: 42
#5

Re: Transformer Sizing Calculation

01/28/2015 1:13 AM

You are right. By definition: uk%/100=sqrt(3)*Zk*Irat/Vrat.Then:

uk%/100=SQRT(3)*Zk*Irat^2/(Vrat*Irat)=SQRT(3)*Zk*Irat^2/(Srat/SQRT(3))

Or: uk%/100*Srat=3*Zk*Irat^2=Qrat.

If Xk=[approx.]=Zk then indeed Qrat=uk%/100*Srat but only for rated load.

For any other load Q=3*Xk*Iload^2.

__________________
Julius
Register to Reply
Guru

Join Date: Oct 2012
Location: 100 miles North from the World Center
Posts: 879
Good Answers: 42
#6
In reply to #5

Re: Transformer Sizing Calculation

01/28/2015 8:04 AM

I am sorry! It is clear that Qload=uk%*Sload-NOT ONLY FOR RATED LOAD , as you said in O.P.- but it is the same with Qload=3*Xk*Iload^2.

__________________
Julius
Register to Reply
Register to Reply 6 comments

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

7anoter4 (3); IdeaSmith (2); jamesjithin (1)

Previous in Forum: Grounding of Isolated Gen. Sets   Next in Forum: Shaded Pole Motor Speed

Advertisement