Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Compute and plot problems about water resources in Excel file
Problem Statement: See attachments
Additional requirement: Use the precipitation, effective rainfall hyetograph(ERH), and phi-index portions of your spreadsheet model developed for HW11 to determine the effective rainfall duration tER and phi-index value for the given observed flood and precipitation data. Also, determine the W-index and runoff coefficient, k, for comparison.