Hoja De Calculo Excel Para Instalaciones Electricas Xls -

=INDEX(ConductorDB[Section], MATCH(TRUE, ConductorDB[Ampacity] >= F2, 0)) Then check VD; if too high, increase section manually or with solver. 4.3 ShortCircuit Sheet Transformer data: (S_t) = 250 kVA, (V_sc)% = 4.5%. Transformer impedance: =(Vsc%/100)*(V_n^2 / S_t) in ohms.

Cable impedance: =Z_cable_per_km * L / 1000 Total short‑circuit current: =V_n / (SQRT(3) * (Z_transformer + Z_cable)) Circuit breaker rating (I_n) must satisfy: (I_b \le I_n \le I_z) (I_z = cable ampacity) And (I_sc \ge I_instantaneous) for magnetic trip. hoja de calculo excel para instalaciones electricas xls

The complete .xls file with all sheets, dropdowns, and conditional formatting can be generated upon request. End of paper 0)) Then check VD

[ \Delta V = \frac2 \cdot L \cdot I \cdot (R \cos\phi + X \sin\phi)V_n ] if too high

Conditional formatting highlights when ΔV > 3%.