SHOW STEPS ON HOW TO SOLVE USING EXCEL SOLVER ADD-IN (SCREENSHOTS)

Solution:

An object weighing 1000 Newton is suspended by three cables attached to the ceiling as shown in the figure. Let Ti, T3, and Ts be the tensions in the three cables. The first step in designing the cables is to determine the tension (force) in each cable caused by the 1000 N force. The equilibrium condition states that the sum of the tension components in the x, y, and z directions must be zero. This requirement gives the following three equations: 1 m .179 Tl-,514T,+,154 T, = 0 507 Tl-,617T,=0 958 T1 +.857 T2+ .771 T; 1000- 0 3 m 4 m 5 m Use the Excel's Solver to solve this system of simultaneous equations to find Ti, T2, and T 1 m 1000 N