QUESTION $1$

$[25$ MARKS$]$

Write a program to calculate the forces and moments in a wall of a circular reservoir. Using the theory for beams on elastic foundations and using an Excel spreadsheet. Write a program that can be used for any reservoir that is required to be semi finite by design. The reservoir parameters are as follows:

Height of wall $=22\mathrm{.}5m,$ thickness of wall $=0\mathrm{.}8m,$ diameter of reservoir $=100m,$ Poisson's ratio $=0$

Should the conditions of semi finite be not obtained from given parameters, make as little as possible, some changes on the design height of the wall.

Your program will not only be marked on correctness, but also the useability of it $($how userfriendly it is$).$