Three rigid bodies $(2,3,4)$ are connected by $6$ springs as shown in the figure below. The spring system is laterally supported by walls $1$ and $5.$ A lateral force of C applied on body $3$ in the direction shown. Determine the displacements of the three bodies.

Determine the forces in the springs.

Determine the wall reactions. For the purposes of this problem, assume that the bodies can only undergo displacement in the horizontal direction. Instead of using AE$/$L$,$ the spring stiffness values in kN$/$m

Solve this problem using Excel for matrix structural analysis. Please show the steps and, most importantly, display the equations or commands you used in Excel. the spring stiffness values in kN$/$m where C $=20$ kN$.$