Question

C1.3 The truss ABC has an overhang b, and its two members are inclined at angles a and y to the horizontal, both angles being positive. A downward vertical force P acts at A. The working stresses for the members are st in tension and sc in com- pression. Given b, P, a, st, and sc, construct an algorithm to plot the required vol- ume of material in the truss against y from y 1⁄4 0 to 75 . Assume that each member of the truss is stressed to its working stress. What is the value of y that results in the smallest material volume? Use the following data: b 1⁄4 1:8 m, P 1⁄4 530 kN, a 1⁄4 30 , st 1⁄4125MPa,andsc 1⁄485MPa.

I need an EXCEL program for this question. Thank you!

C1.3 The truss ABC has an overhang b, and its two members are inclined at angles α and θ to the horizontal, both angles being positive. A downward vertical force P acts at A. The working stresses for the members are σι In tension and ơçln com pression. Given b. P, x, , and ơc, construct an algorithm to plot the required vol- ume of material in the truss against θ from θ-0° to 75°. Assume that each member of the truss is stressed to its working stress. What is the value of 0 that results in the smallest material volume? Use the following data: b- 1.8 m, P-530 kN, o -30°, σ,-125 MPa, and ac-85 MPa.

Answer 1

E2SMa

thom he area -9 - 8.48 X to -9 :10.gx1s®, x L8一十 8.Y8x10> x 1.8一

de -3 -8

In EXCEL- Type the formula for volume in Formula bar as stated below

V= ((19.44*10e-3)+((17.625*10e-3)*sin(x)))/((cos(x))^2+ (0,866*sin(2*x)))