Bob -- you have not been around for a long time
Glad to see you're back. Hope you stick around more often
Bob -- you have not been around for a long time
Glad to see you're back. Hope you stick around more often
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
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
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
@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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
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?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
All good thanks Georgiboy. Again I'd like to extend my thanks to all who have contributed to this issue.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link