Catenary Cable Tension in Excel - Solve an Implicit Equation with Goal Seek

Get more Excel Training for Engineers at: www.engineerex...
In this video, we solve an implicit equation in Excel to calculate the tension in a catenary cable.

[@israelboyd6883]

Thank you! I have been pouring over a physics thesis and study for the last 12 months and I just could not find a way to use goal seek effectively. I have also never used the function for assigning 'names' to formula values, that is an incredible method for simplifying equations. This will allow me to finally start moving forward.
From the bottom of my heat, thank you.

[@LordErmac2000]

Concise and precise, appreciate the video.

[@ciddhant13]

Will this analysis dynamically update the output if we change one or more of the inputs like w or y_0?

[@luwhite1958]

Muito grato, simples e objetivo, nem imaginava como poderia ser fácil assim...

[@alvorada3804]

Finalmente práctico como un ingeniero 🤟🤟

[@user-rm5md2do6d]

Why all equations of catenaries do not include Y0-T/W as you do??

[@bwnarrow33]

I believe it has to do with Y0 being equivalent to "c" which is the same as "T/W". So it's basically adding a "c-c" at the end which is 0

[@bwnarrow33]

Oh wait I think it's because technially y0 is your reference point so really, that should be 0 in most circumstances. The rest of the equation is the same except for y0