I require multiple excel spreadsheets, underlining different scenarios, in which the design of vertically loaded piles in sand via Eurocode 7 can be solved.
1) Given a simple hypothetical scenario whereby there's no gwt, using spt, 1 single layer of sand, develop spreadsheet, detailing and fulfilling all criteria of Eurocode 7 (partial factors, DA1 (C1, C2), DA2, DA3, etc)
2) Develop a second spreadsheet to handle various scenarios, eg. presence of gwt, multiple sand layers, etc
3) Develop a third spreadsheet if necessary with reference to any given case studies, cross-checking
4) Compare Eurocode 7 to BS Code
5) Explanation of how the spreadsheet is developed
Attached is a sample of the presentation of the required spreadsheet.