rainfall runoff

[engrsalah]

i have daily data of rainfall of 30 years. i want to find runoff in excel using scs curve number method.if i put scs formula in every cell , there will be a lot of data and confusion because (31(days)*12(month)*30(years). now my question what is the simplest method and also how to utilised the condition of AMCI,II snd III?

 

[gbam]

I would typically use HECHMS or HEC-1 for this evaluation. We would even break it up into segments due to the amount of data. Not saying that Excel cannot be used but I not sure if it can handle that amount of data; never tried that. In regard to the AMCI, II, III, I recommend reviewing the SCS method hydrology and your local/County/State requirements. There may be guidance provided in policy.