Assignment $4$

$4\mathrm{.}1$ Truss Analysis

Create a worksheet to determine the forces in the members of the simple truss shown. User

inputs are Geometry $($except the angle theta, which is calculated$),$ Loads, and Member

Strength as shown. All other values are calculated. Your spreadsheet should indicate tensile

or compressive forces in the members, and indicate if the force in the member exceeds its

strength.

Two$-$Storey Truss Analysis of Member Forces

give me the formula and process in excel to define overloading

pleasae provide me excel formula just to define overloading