- Location
- Placerville, CA, USA
- Occupation
- Retired PV System Designer
Going back for a moment to the simple resistive load delta case, you can either call it using vectors with very simple vectors or just using a formula, but if the current from A to B is x, and the current from B to C is y, then the line current in B is exactly (x+y)(sqrt3)/2.
I leave it as an exercise for the readers to extend this to other two line currents.
The more adept readers can then extend the formula to the case of equal displacement power factor loads and discover that the exact same formula applies when using the magnitude of the current, and amazingly the power factor of the line current is the same as the power factor of the line-to-line current.
Once you introduce unequal power factors for each load, you are finally in a situation where it is easier to just give up on formulas and start using vectors directly.
Regarding the spreadsheet, I suspect that the problem involves correctly entering the sign of the line-to-line currents. A proper formula in the spreadsheet should have taken care of that for you.
I leave it as an exercise for the readers to extend this to other two line currents.
The more adept readers can then extend the formula to the case of equal displacement power factor loads and discover that the exact same formula applies when using the magnitude of the current, and amazingly the power factor of the line current is the same as the power factor of the line-to-line current.
Once you introduce unequal power factors for each load, you are finally in a situation where it is easier to just give up on formulas and start using vectors directly.
Regarding the spreadsheet, I suspect that the problem involves correctly entering the sign of the line-to-line currents. A proper formula in the spreadsheet should have taken care of that for you.