Sorry for the delayed response. Here are my spreadsheet assumptions:
Voltages: (on an ABC phase rotation)
Vab =390 @ an angle 30 degrees
Vbc =390 @ an angle -90 degrees
Vca =390 @ an angle 150 degrees
My initial spreadsheet use was solving line-to-neutral loads that were unbalanced, my reference voltage was Van (line-to-neutral) hence the 30-degree shift. I just modified the spreadsheet to cater to line-to-line loading.
With the cells intended for input of phase-to-phase loads empty (Lab, Lbc, and Lca), I forced iteration of values unto those cells using the Solver Add-in of Excel with the following constraints;
Ia = 72; Ib = 51, and Ic = 66
Note that:
Ia = Iab - Ica;
Ib = Ibc - Iab; and
Ic = Ica - Ibc (there are no line to neutral currents) and
Iab =Lab/Vab;
Ibc =Lbc/Vbc; and
Ica =Lca/Vca.
Just be careful in the formula you use to correctly compute the respective vector angles as this will get your results wrong if not well formulated.
Hope this is clear to you.
Yes I understand your method now. So baically you plug in the equations plug in the line currents that were given and let excell calculate and spit out the L-L loads? Is this all done by the solver function, I'm not familiar with it?
Isn't it possible however that there is more than 1 L-L loading combination that can result in these line currents?