Hi,
I am a building energy consultant and am trying to create an hourly weather file from annual data (in other words, taking 365 days of data and spreading it over 8760 hours in the year).
I have the lowest temperature (recorded at around 6 am) and the highest temperature (recorded at 3 pm) and need to fill the in-between cells with a linear growth series.
QUESTION: How can I auto-fill the empty cells with a series between two populated cells. Especially when two cells are 8 rows apart and the next two cells are 14 rows apart.
I am attaching the Excel file herewith for your perusal and response.
Thank you for providing a platform such as this. I shall be grateful for any possible help in this regard.
Kindly
Gaurav
THE_Weather_File.xlsm
Bookmarks