I need to create a spreadsheet that will allow me to calculate what my average daily temperature would be in a greenhouse environment. Basically, there would be four columns: Night Temperature, DIF temperature(a reduced temperature temperature to stop plant stretching), Day Temperature and ADT (Average Daily Temperature). Each cell would be a given percentage of a 24 hour day. Say, for instance, that my day time temperature would last for 8 hours, then that temperature would be approximately 33% of my average daily temperature.
I would like to be able to fill in the cells for my Day, Night and DIF temperatures and have an ADT automatically calculated. Also be able to change the duration of the day, night or dif temperature periods....or maybe have multiple tables for different scenarios, e.g.:
Day - 10 hours
Night - 10 hours
DIF - 4 hours
or
Day - 11 Hours
Night - 10 Hours
DIF - 3 hours
There could be many different scenarios of how long each temperature could last. My question is what type of formulas would allow me to accomplish this?
Thank You
Bookmarks