Module CIVE286 FIAT LUX UNIVERSITY OF LIVERPOOL CIVE286 - Programming for Civil Engineers Coursework 1 Dr Anna Charly AY 2023 2024 - Consider the soil profile as shown in Figure 1. The saturated unit weight for sand is 21.8kN/m³, and the unsaturated unit weight for sand is 19.5kN/m³. For the clay layer, saturated and unsaturated unit weights are 18.5kN/m³ and 15.5kN/m³ respectively. The unit weight for water is 9.8kN/m³. The settlement describes how much the layer shrinks under the action of external loads. The formulae describing this phenomenon are: Effective stress without surcharge: σ0 = Hsoil × Yb - Hwater × Yw. H Primary consolidation settlement: Sc = Де 1+eo στο + Ασ For normally consolidated clay: Ae= = Cc log10 σο For overconsolidated clay (σ'( ≥ 0 +Aσ') : Ae = Cs log10 For overconsolidated clay (σ' <% +10σ'): Ae = C, log 10 (^+$") +Cc log10 Το + Ασ σε where b and w are unit weight of soil and water respectively, eo is initial void ratio, H is the clay layer thickness, C, and C are the swell and compression indices respectively, σ = OCR × σ is pre-consolidation stress, and Ao' is the increase in effective stress by surcharge. Page 1 of 4 Module CIVE286 ☑ Surcharge Aσ Dr Anna Charly AY 2023 2024 - Ground surface Sand 10m Clay 15m Water table Figure 1: Soil Profile Impermeable layer The task for this assignment is to program an appropriate set of VBA code, with data provided in Table 1 to: 1. Determine σ at the centre of the clay layer for water table varying from 5m to 15m below the ground surface (use 10+10 × i intervals to cover the variation, where i is the last digit of your student ID); 2. Determine the primary consolidation settlement for the clay layer for water table varying from 5m to 15m (10+10x i intervals to cover the variation, where i is the last digit of your student ID); 3. Plot σ calculated in question 1 against the water table depth using VBA code; 4. Plot clay settlement calculated in question 2 against the water table depth using VBA code. Table 1 Compression index Cc 0.25 Swell index Cs 0.09 OCR 1.0+i×0.1 (i is the last digit of your student ID) Surcharge Aσ (kPa) 80 Initial void ratio eo 0.95 Page 2 of 4 Module CIVE286 Your code should contain • Correct input and output data [25%] • Two figures plotting effective stress and settlement against water table depth [15%] • At least one user-defined function (or subroutine) used in the code [10%] • Appropriate style and structure (indents, comments, variable declarations) [25%] Dr Anna Charly AY 2023 2024 - Your report should Note: outline your coding strategy, describe the code including variables that were used to solve the problem, and how those variables were used to obtain the results. Be no more than two pages in length excluding the code. • To submit your work, upload a zipped folder, with your ID number as the folder name, containing your VBA code in a .xlsm spreadsheet and your project report. • IF YOUR CODE DOES NOT RUN YOU WILL NOT RECEIVE ANY MARKS FOR THE CODE PART OF THE MARK SCHEME. • You should not collaborate with other people. If you submit a solution you are deemed to have agreed that you have not copied from or collaborated with another person. The software checker Moss (Measure Of Software Similarity) may be used to detect plagiarism. Page 3 of 4 Module CIVE286 Outstanding Code, 50% All Style, 25% Report, 25% Marking Criteria Comprehensive/ Deficient/ Competent Weak functions Dr Anna Charly AY 2023 2024 - functions present and prop- erly named. Code runs perfectly with no errors. Exceeds minimum project requirements. The best code that could be reason- ably expected. Fully documented and demonstrates a clear under- standing of VBA programming Clearly and con- cisely explains the VBA code and how each part runs and contributes to the overall pro- gram. Well written, without spelling grammatical or mistakes. Code Functions missing or improperly named. Code runs but has many All present. runs but some small errors may be present. Meets minimum project project requirements Code is not fully documented. Some weaknesses or lack of understanding evident. VBA code is ex- plained but with some omissions. Report is some- what unclear or contains some grammatical / ty- pographical errors. errors. ments Missing require- Code is very dif- ficult to read or is otherwise con- fusing. Poorly doc- umented. VBA code is not well explained or is difficult to read. The report does not demonstrate a clear understand- ing on behalf of the author. Major spelling or gram- matical Code does not run or is missing. Code is not docu- mented at all. Report impossible to read or missing Page 4 of 4 errors. Report exceeds limit.