How do you calculate reactive power in Excel?

How do you calculate reactive power in Excel?

How do you calculate reactive power in Excel?

Power factor correction calculations for power system – MS Excel Spreadsheet

  1. Q1 = I losses + Cu. losses
  2. Q2 = PkW · (Tanφ1 – Tanφ2)
  3. I losses = 2% · S. tr
  4. Cu losses = USC% · S. tr
  5. Q = Q1 + Q.

What is the formula to calculate the reactive power?

Reactive power: Q = V x Ir (kvar)

What is the formula to calculate KVAR?

For the KVAR formula, it is as follows: Q = X*I*I. In reactive power formula, X refers to the reactance of the circuit and I is the current that runs through the circuit.

How do you calculate reactive power demand?

Required Reactive Power

  1. Calculate the cos inverse of current and required power factor. In our case, current power factor is 0.7 & required power factor is 0.95.
  2. Multiply the resultant values by tan, and then subtract. = tan (45.57) – tan (18.19)
  3. Multiply the final value by power.

How do you calculate 3 phase reactive power?

And in terms of line quantities, the reactive power formula is: Q = √3 × Vline × Iline × sin φ

What is the formula for 3 phase reactive power?

So, in terms of phase quantities, reactive power is: Q = 3 × VPh × IPh × sin φ

How do you calculate real and reactive power?

Reactive Power Formulas:

  1. Q = V I Sinθ
  2. Reactive Power = √ (Apparent Power2– True power2)
  3. VAR = √ (VA2 – P2)
  4. kVAR = √ (kVA2 – kW2)

What are Kvars?

1000 Volt Amps Reactive (VAR) = 1 kiloVolt Amps Reactive (kVAR). Usually used to express power in all forms, but is reserved to express real power. 1000 Watts (W) = 1 kiloWatt (kW). Used to express the total load in a circuit. 1000 VA = 1 kVA (kilovolt Amps).

How do you compensate reactive power?

 An ideal shunt compensator provides the reactive power to the system.  Shunt-connected reactors are used to reduce the line over-voltages by consuming the reactive power, while shunt-connected capacitors are used to maintain the voltage levels by compensating the reactive power to transmission line.

How do you calculate true power and apparent power?

PF is the ratio of real power to apparent power.

  1. PF = Real Power / Apparent.
  2. Power.
  3. P = 120 V x 6 A x 0.8 = 576.
  4. Watts.
  5. P = V x A x PF = Watts.
  6. Definition of a VAR (volt-amp-reactive).