Averaging formula

This topic contains 5 replies, has 2 voices, and was last updated by Mikhail Mikhail 4 months, 1 week ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #4926
    Horacio
    Horacio
    Participant

    Hello!

    Could you please show the formula you used for channel 115 (Average temperature) of your “Server Room” demo?

    Could you show another example of an input channel averaging formula, after ticking the “averaging” case?
    Please include Input channel type.

    #4930
    Mikhail
    Mikhail
    Moderator

    Hi,

    Something like
    (Val(1) + Val(2) + Val(3)) / 3
    where 1, 2 and 3 are input channel numbers.
    You need to add an extra input channel of calculated real type that uses the above formula.

    #4931
    Horacio
    Horacio
    Participant

    Thank you very much Mikhail.
    That’s fine to average different variables.

    How to do to average same variable along a certain time (n previous
    readings)?

    What does “averaging” column in Input Channels work if marked?

    I saw other postings referring this subject but the matter remains unclear to me.

    Thank you.

    #4935
    Mikhail
    Mikhail
    Moderator

    How to do to average same variable along a certain time (n previous
    readings)?

    Create new formulas in the Formulas table depending on your needs. There are many different ways to calculate averages.

    What does “averaging” column in Input Channels work if marked?

    Summarizes all values received from controller and then divide by their count. This is performed separately when write minute and hourly data in the archive.

    #4937
    Mikhail
    Mikhail
    Moderator

    I implemented several averaging formulas in different projects. I can help you with averaging based on your requirements. But this is out of free support.

    #4969
    Mikhail
    Mikhail
    Moderator

    The new formulas for moving (rolling) averaging are shared here. Thanks a lot to Horacio for sponsorship.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.