- #1
bobpiet
- 4
- 0
I need to find a means to calculate the load on three or four ropes that are supporting a weight between them. These ropes radiate from the load at various angles, typically non-planer. The attached illustration shows a three rope example with the individual ropes, yellow, green, blue, projecting out at various angles, imagine they are attached to the inside of a large sphere for instance.
I would like to build a spreadsheet that would allow me to plug in the load weight, the angles of the 4 ropes and have the formulae calculate the load on each rope.
I am not a mathametician (often wish I were) but am comfortable building spreadsheets with complex formulas.
I'm not sure how to represent these angles in X, Y, Z space around the load either.
Anyone have a suggestion?
I would like to build a spreadsheet that would allow me to plug in the load weight, the angles of the 4 ropes and have the formulae calculate the load on each rope.
I am not a mathametician (often wish I were) but am comfortable building spreadsheets with complex formulas.
I'm not sure how to represent these angles in X, Y, Z space around the load either.
Anyone have a suggestion?