CE$306$ Foundaion Engineering. Please provide the solution on excel. You can attach screenshot of the solution and provide reference as well.

Your results should be clearly presented on a PDF file.

Submission shall be a single A$4$ report in PDF format.

Excell shall be used in calculations

For a site in Lefke Cyprus, site survey was conducted and a tall rise building is to be designed. Water table is on surface

$\backslash$table$[[$Layer$,$Soil,$\backslash$table$[[$Layer$],[$Thickness$]],\backslash$table$[[$SPT$],[$blow$]],\backslash$table$[[$Liquid$],[$Limit$]],\backslash$table$[[$Plastic$],[$Limit$]],\backslash$table$[[$Moisture$],[$Content $\%]],\backslash$table$[[$Fines$],[\%]],\backslash$table$[[$Unit$],[$weigth$],[$kN$/$m$^(3)]]],[1,$Sand,$3,3,-,-,,3,20],[2,\backslash$table$[[$Sandy$],[$Silt$]],3,5,40,29,35,52,18],[3,$Clay,$4,11,55,30,47,92,18],[4,$Silty sand,$4,15,30,20,27,35,20],[5,\backslash$table$[[$Clayey$],[$Sand$]],5,9,23,15,20,15,21]]$

Design pile group solution as load bearing solution in order to resist $A10000kN$ total building weigth on $10m20m$ foundation on the soil specified $(A=6)$