How to calculate number of days since end of last wet spell?
Where a wet spell (a useful amount of rainfall; breaking a drought) is arbitrarily defined as a period of time not longer than 6 days having a total of 30mm or more rainfall. The data is mm rainfall and the date of the event. Please see attached.C:\fakepath\dates with rainfall.ods
Which data do you have? How it is formated?
Click edit below your question and use the paper clip to upload a sample file (remove all sensible data before).
Probably by using a helper column with a "running precipitation" record.
How is your data laid out, to base that calculation on? Preferably, edit your question posting and attach a spreadsheet file with your data.
@carob, Given 7 consecutive days, each with 5 mm, what day is the end of the wet spell? How many days make a dry spell?
Given 7 consecutive days, each with 5 mm, what day is the end of the wet spell? The 7th day would be the last day of the wet spell. How many days make a dry spell? That wasn't separately defined so would be the period between wet spells. Thanks for your continued interest. All these ideas enable different ways to visualise the data as "growth periods" which is just for personal interest