For DC or resistive AC (simplified, cosφ=1):
=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. 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 For DC or resistive AC (simplified
[ \Delta V = \frac2 \cdot L \cdot I \cdot \rhoS ] 0)) Then check VD