How to list dates defined by a data validation process

[Paul_Hossler]

Bob -- you have not been around for a long time

Glad to see you're back. Hope you stick around more often

[Bob Phillips]

Thanks Paul, it's always nice to be back, and good to see many of the forum stalwarts like yourself are still here.

I do have good intentions to visit more often, but I have a fair amount of work, plus my better half likes her holidays, and these things absorb our time

[Aussiebear]

@Georgiboy. Thank you for your assistance however, it doesn't quite meet my needs, and thats not your fault by any stretch of the imagination. My initial thinking was I needed to be able to show 3 consecutive days where the temp was + or - 1 of the selected temp value. On reflection this is not the best way to approach this issue.

Here's what I am currently thinking. The chemical has a "safe" maximum range of 25°c and minimum range of 10°c. From the data shown on the graph, we can determine that there were 15 individual days where the Max temp was 26.0 or below, but only two occasions where at least 2 days running where it met the preferred conditions. Why am I being cautious here? Simply because the manufacturer suggests that at higher temps than 25°c the vaporisation of the chemical is increased and can cause distress to the bees. The first three days is critical where it needs to be 25°c or below. My thinking was that even if a temp got to 26°c for one day and the others were 25°c or below then it still has its best chance to work, hence the + or - 1 degree thought. During the Summer and to date you can see that our temps were erratic at best, and therefore we should not be applying the chemical. Others who for their own reasons may decide to accept a higher max temp and run the risk of damaging the colony. Similarly when it gets too cold (under 10°c) the chemical's vaporisation will slow or not work at all. It is expected that during the winter period our max temps will range in the 10 to 18°c, but our Minimums will be anything from -2 to 10°c.

I'd like to develop this for use as a risk management tool.

[georgiboy]

I see, so would that be more like the attached with the -1 & +1 part?

I have added in an option for you to select the amount of consecutive days for it to find.

[Aussiebear]

Thank you for your quick turn around. Is the reason for the calc error when selecting temps 20, 21, 24 & 25 simply because it couldn't calculate any periods?

[georgiboy]

Yes you are correct, to be fair, I made a mistake on one or two of the formulae on that last attachment. See attached with fixed formulae along with the formula that you pointed out will now return "None Found" if no opportunities are found.

[Aussiebear]

All good thanks Georgiboy. Again I'd like to extend my thanks to all who have contributed to this issue.