AnsweredAssumed Answered

Find values and Interpolate recurrence Interval

Question asked by jacobrodel on Feb 24, 2016
Latest reply on Feb 26, 2016 by jacobrodel

In the table on the Image below, ippt_allsi represents precipitation amounts for a given storm.  The rest of the fields represent the precipitation amounts for that number of years recurrence intervals.  2, 5,10, 25, 50 and so on.  I need a script that will take the precipitation amount for the storm, (appt_allsi) then find the bounding larger and smaller values and interpolate the recurrence year by where the precipitation amount falls between those years values.  For instance, for the first record, 3.84 inches of rain fell.  The 100 year amount is 3.615 and the 200 year amount is 4.059.  How would I return the interpolated recurrence year for the 3.84 inches?  I am fairly new to python and am struggling.  Could somebody please get me started in the right direction? 

Capture.JPG

Outcomes