I am trying to automate the iterative process required to solve the kinematic wave equation, presumably through a circular reference or macro.
Basically, in the kinematic wave eqn (used for surface flow calculations). there are two parameters that depend on one another (time of concentration, and rainfall intensity). To solve this, one needs to assume one a time of concentration value, calculate rainfall intensity, then look up a graph of historic 'rainfall intensity VS time of concentration' and measure the graphs rainfall intensity from your assumed time of concentration. You would then compare your calculated rainfall intensity value with the value you see on the graph. The aim is to reiterate through time of concentration values until these two rainfall values become (roughly) the same.
I can put in the data for the graph into excel by way of 10 or so coordinates, so one would also need to tell excel to interpolate whereever necessary.
Any help, anyone??