PO.ESP.Cable.MinSize
Description
Determines minimum cable size for voltage drop limit, [AWG].
Syntax
=PO.ESP.Cable.MinSize(I, length, V_drop_max, T)Parameters
| Parameter | Description |
|---|---|
| I | Motor current, [A]. |
| length | Cable length, [ft]. |
| V_drop_max | Maximum allowable voltage drop, [V]. |
| T | Cable temperature, [degF]. |
SI Unit Version
Lambda Name
PO.ESP.Cable.MinSize.SIFormula
=LAMBDA(I, length, V_drop_max, T, LET(
length_ft, PO.UnitConverter(length, "m", "ft"),
T_degF, PO.UnitConverter(T, "degC", "degF"),
PO.ESP.Cable.MinSize(I, length_ft, V_drop_max, T_degF)))SI Parameters
| Parameter | Unit | Description |
|---|---|---|
I |
- | Motor current, [A] |
length |
m | Cable length, [m] |
V_drop_max |
- | Maximum allowable voltage drop, [V] |
T |
degC | 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.MinSize.SI - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =PO.ESP.Cable.MinSize.SI(...) anywhere in your workbook.