Using Excel Spread Sheet you are required to develop a template that can be used to determine the member forces $($Axial forces, Shear forces and Moments$)$ for the ONE$-$BAY PORTAL. FRAME shown below.

Minimun Tasks to be Accomplished in Developing Your Template

Task $1$: On the first page provide space to enter data. All the variable shown above should be able to be changed by the user of your template. The support at node $1$ and $4$ should be permied to be changed by the user either to a fixed support or a pin indipendently $(1$ or $4$ or both$).$ NOTE: Determine the member forces for the load types individual $($using unfactored loads$)$ and later combine appropriately. Bring the results of your analysis to the first page. SLOPE DEFLECTION METHOD is suBgested in finding the member forces.