Please use excel and create a module for the equation$($s$)$

LAB ASSIGNMENT $(3)$

The deflection $($elastic$)$ curve of a uniform beam subject to a linearly increasing distributed load is

$(x)=\frac{w_0}{120\text{E}\text{I}\text{L}}(-x^5+2L^2{x}^3-L^{4}x)$

Use Microsoft Excel to prepare spreadsheets $($with the use of VB$)$ for Falseposition, Newton$-$Raphson and the secant methods. After checking the validity of these spreadsheets, use them to determine the maximum deflection of the beam. Use the following parameter values: $L=600cm$;$E=50,000k\frac{N}{c}{m}^2$;$I=30,000c{m}^4$; and $w_0=2\mathrm{.}5k\frac{N}{c}m$