With the excessive heat in the northern hemisphere this summer, I had set up an additional spreadsheet to gather data from my weather station.
The WMO standard for daily average temperatures is 4 measurements at 01:00, 07:00, 13:00 and 19:00 plus the daily max and min temps divided by 6 to give you an average. (In 2021 we are three to 6 degrees above the rolling average from previous years) To this I added the high and low relative humidity, the average and the difference between the two. All is on the attached spreadsheet, short version.
Calculations are being done in columns H, I, J, M and N. This is all in an Excel 2007 spreadsheet.
What I noticed was that I didn't have to copy the calculations down to the next blank cell in the column.
Looking at Row 27, the first temperature is in cell B27. As soon as I populate C, D, E, F and G27, then the spreadsheet calculated H27, I27 and J27 with no input from me?
I have looked at the cell formatting but I can't see what it is that I have enabled to get this to happen. It's a useful feature that I have somehow got working.
Please can someone tell me what I did because I would like to use it on other spreadsheets.
Thank for reading