Thanks for the formula, chicopee. I've already forgotten everything I learnt in school.
israelkk,
I have a very simple cylinder with a pile of disc springs inside. Number of springs and stacking order are known and always the same. The spring pile has to be pre-loaded to force F meaning that cylinder rod has to start moving when it's pulled with force F (making spring pile shorter).
Since the F is known at th beginning, I thougt I could directly calculate the cylinder length (pre-loaded spring pile length which is needed) in Excel.
In other words, now I have F (pulling force) as a result in one cell in my calc sheet. After getting that F, I have to "manually" change/guess the s value, to get a matching F for the pre-loaded spring pile. Then I can say "if you have this force pulling the cylinder rod, you need this much space for the pre-loaded spring pile"
(Sorry about my poor english)
Easily done with Excel macro or solver function, so not a big problem at all.