Question $1$

$[40]$

$1\mathrm{.}1$ Make use of an excel spread sheet to produce an excel based program that will ultimately be able to produce the shear force and bending moment diagrams as well as determining the maximum deflection for the figure shown in Figure $1$ below. The diagrams should be able to adjust automatically when the variables and $y.$

$(20)$

$1\mathrm{.}2$ Make use of Prokon to check your analysis and compare your answers.

$(20)$

rigure $1$: Bearn

Table $1\mathrm{.}1$: Selection table for Loads

$\backslash$table$[[$Loads$,$Last digit of your student no$.$:$],[0$ to $2,3$ to $5,6$ to $7,8$ to $9$