Civil Engineering Question

I have attached the instructions (screenshots) and data (excel file) required for this assignment. Please complete this by paying attention to the instructions thoroughly. Thank you