PO.ESP.Cable.Vdrop.Full
Description
Complete voltage drop calculation, [V].
Syntax
=PO.ESP.Cable.Vdrop.Full(HP, V_motor, efficiency, PF, AWG, length, T)Parameters
| Parameter | Description |
|---|---|
| HP | Motor horsepower, [HP]. |
| V_motor | Motor voltage, [V]. |
| efficiency | Motor efficiency, [fraction]. |
| PF | Power factor, [fraction]. |
| AWG | Cable gauge. |
| length | Cable length, [ft]. |
| T | Average cable temperature, [degF]. |
SI Unit Version
Lambda Name
PO.ESP.Cable.Vdrop.Full.SIFormula
=LAMBDA(HP, V_motor, efficiency, PF, AWG, length, T, LET(
HP_hp, PO.UnitConverter(HP, "kW", "hp"),
length_ft, PO.UnitConverter(length, "m", "ft"),
T_degF, PO.UnitConverter(T, "degC", "degF"),
PO.ESP.Cable.Vdrop.Full(HP_hp, V_motor, efficiency, PF, AWG, length_ft, T_degF)))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
HP |
kW | Motor horsepower, [kW] |
V_motor |
- | Motor voltage, [V] |
efficiency |
- | Motor efficiency, [fraction] |
PF |
- | Power factor, [fraction] |
AWG |
- | Cable gauge |
length |
m | Cable length, [m] |
T |
degC | Average cable temperature, [degC] |
How to save as a reusable Excel function
LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formula above works as-is when pasted into a cell.
To save a LAMBDA as a reusable named function:
- Go to Formulas → Name Manager → New
- Enter a name, e.g.
PO.ESP.Cable.Vdrop.Full.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.ESP.Cable.Vdrop.Full.SI(...) anywhere in your workbook.