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.