• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with an average formula

ad.dias

New Member
Greetings,
I have two columns with hourly data from a masonry wall over a year, with it's relative humidity and surface temperature.
You guys where kind enough to help me do a 24 hour average, however ASHRAE standard demands that I also do a 7 day and a 30 day running average (see picture below).
I can't seem to be able to do an average for these values =s
Can anyone help me out?
Thanks a lot guys
 

Attachments

  • ASHRAE.png
    ASHRAE.png
    153 KB · Views: 3
  • Running average.xlsx
    632.7 KB · Views: 3
Back
Top