Hi,
If you are trying to do it in excel that's should be pretty easy as excel has build in equation solver.
I am not a mathematician and would also have to go threw internet to look for polynomial solution.
If solution with a defined precision is enough for you and you do not chase analytical solution it is even more simple.
And you can do that in inventor directly using iLogic and simple VB loop.
You have to specify:
- what parameters you have in the begging. is it always Di, P and L
- what precision for L1 would you accept (after calculating N with some precision resulting spring will have some length that will come out L1)
I do not have time now to play with it.
Maybe I will try in few days.
In the mean time try excel non linear equation solver or use graph to find a solution.
Cris.
Cris,
https://simply.engineering