• 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.

Search results

  1. A

    How to add a simple line to a graphic

    Hui saves the day again, thanks =D
  2. A

    How to add a simple line to a graphic

    Oh I think I get it, you are using daily values, but I'm using hourly values, is there a way to convert your formula to hourly values?
  3. A

    How to add a simple line to a graphic

    Hi there hui! Yes I copied my data into your excel file, but I get completely different graphics from the values I entered (see pictures and attached file) Why does this happen?
  4. A

    How to add a simple line to a graphic

    Hey guys, I had help from a forum member a couple of months ago on a similar topic, but I can't seem to apply it to my file (see atached) I basically need to add some lines to my original graphic, identifying the wetting season and the drying season, but I have no idea how to do it. Here is...
  5. A

    Creating a "countif" formula

    That's some amazing skills, thanks a bunch =D
  6. A

    Creating a "countif" formula

    It only requires 2 consecutive readings (actually only one hour) to be on the same side of zero =)
  7. A

    Creating a "countif" formula

    Greetings, I had previously had help from some members around here creating a similar formula, but this one is a little more complex. I have a file with 3 columns and over 40000 rows, with the hourly data of temperature and water content on a wall, over one year (See atached file) I need to...
  8. A

    Need help with an average formula

    That's it vletm, thanks alot =D
  9. A

    Need help with an average formula

    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...
  10. A

    Need help with a simple radar chart

    Yes thanks again Hui! =D You too Nebu
  11. A

    Need help with a simple radar chart

    Greetings, I'm currently working on my dissertation, I need to create a simple radar chard, just like the one in the picture bellow. I need to create a wind rose, with a certain amount of annual rain coming from each direction. These are the values: W 30,56 NW 21,30 N...
  12. A

    How to repeat a formula every X rows

    That's it! Thanks a bunch !
  13. A

    How to repeat a formula every X rows

    Greetings everyone, I have an Excel file with 3 columns and 8738 rows. These are the hourly values of the temperature and relative humidity on a wall's surface. I need to convert the time format from hour to day, and calculate the daily average values of the temperature and relative humidity, so...
  14. A

    How to add info to a graphic

    That's it!! Thanks Hui =D
  15. A

    How to add info to a graphic

    Greetings guys, I need to add some lines to my original graphic, identifying the wetting season and the drying season, but I have no idea how to do it. Here is my original graphic: https://ibb.co/fbBj8F Here is what I'm looking for: https://ibb.co/h1K48F I added the lines trough paint...
  16. A

    Excel Question

    Much obliged Hui !!
  17. A

    Excel Question

    Hi Hui, thank you for your response Here is a more detailed example on how a freeze/thaw occurs (A) (B) 1 -10 (Freezing hour 1) 2 -15 (Freezing hour 2, hence, freeze cycle occurs) 3 10 (Thawing hour 1) 4 -6 (Freezing hour 1, remember, thawing has to occur...
  18. A

    Excel Question

    Greetings, I’m currently writing a dissertation about how building envelopes behave in cold climates, specifically, I’m having trouble interpreting a wall’s resistance to freeze/thaw cycles. I have the following data: I have two columns with 40 000 rows of data. Colum A is the Time (Number...
Back
Top