Forum Home › Forums › Understanding the Software › Using Formulas › Calc value from multiple device
- This topic has 11 replies, 4 voices, and was last updated 7 months, 2 weeks ago by
Mikhail.
-
AuthorPosts
-
March 26, 2021 at 6:36 am #8574
ns.fariz
ParticipantHi Mik,
How can I calculate value from another device? Let say I have 3 device and want to sum Total KW from each machine.
Thank you,
March 26, 2021 at 10:12 am #8576manjey73
ParticipantNew Channel, use formula
Val(Channel_machine_1)+Val(Channel_machine_2)+Val(Channel_machine_3)April 8, 2021 at 7:37 am #8668ns.fariz
ParticipantHi Manjey,
I tried like this. create new channel in Input channel machine 1. I put on the last table row no 163, channel type = real, object = Enterprise, Formula used = checked, Formula = Val(131)+Val(231)+Val(331). and I add on my table input channel 163. But when I open rapidscada view. the value just show —-. Is there any step that I missed?
April 8, 2021 at 2:35 pm #8676Mikhail
ModeratorHi,
Screenshots of the existing settings would help.April 9, 2021 at 8:22 am #8686ns.fariz
ParticipantApril 9, 2021 at 1:23 pm #8701Mikhail
ModeratorHi,
Set the type of channel 163 to “Calculated real”, and set Signal to blank.
October 19, 2022 at 8:10 am #11319gabeirinhas
ParticipantHello,
I want to sum two channels,
the values keep increasing,
Both are channels without signal,
Both are real calculated type, one of them is based on a value with signal.
Basically I want that when the value of one of them changes, the result will be added,
Could you help me, thank you
I attach pictures
https://drive.google.com/drive/folders/1pwEn-hpt_Kkn6qjn3vjl8ZaZu2CSoL5T?usp=sharing
October 20, 2022 at 8:42 am #11323Mikhail
ModeratorHello,
Formula of the channel 532 refers itself.October 21, 2022 at 4:33 pm #11334gabeirinhas
ParticipantHello,
I have the following query,
If a channel receives an actual value of 100.0 continuously and after some time the same channel receives a value of 200.0
Is there a way to sum these specific values?
i.e. 100.0 + 200.0?
Thank u
October 24, 2022 at 9:56 am #11357Mikhail
ModeratorHello,
It’s possible, but more tricky. Check the averaging formulas.October 24, 2022 at 3:18 pm #11374gabeirinhas
ParticipantHello,
I have incorporated the table of formulas,
They work correctly,
I get the average using these 2 formulas,
MovAvg(5); AvgStat()
TimeAvg(10, 5); AvgStat()
>
I have been playing with them in order to get the sum of 2 values at the change of an input channel,
What I am trying to do is for example that, during 1 hour I get on one input channel 100.0 and after another hour I get 200.0, on the same input channel,
I try that another input channel picks up the sum of these 100.0 + 200.0
>
In the first input channel (904) where I receive the values to be added,
I put the formulaMovAvg(2); AvgStat()
In the second input channel (905) in order to obtain the sum, I put the formula,
Val(904) *2
I do not obtain the expected result,
I hope you can help me with this, thank you
-
This reply was modified 7 months, 2 weeks ago by
gabeirinhas.
October 25, 2022 at 7:53 am #11408Mikhail
ModeratorI can help you by answering questions how formulas work.
Take into account that Communicator periodically sends the existing data again to input channels.
It’s possible to write to a text file from formulas. It may help to find an error.If you can use C#, you can also implement a simple module to perform calculations. Modules allow debugging, which can be useful.
-
This reply was modified 7 months, 2 weeks ago by
-
AuthorPosts
- You must be logged in to reply to this topic.