Formulas - Revision history

Roland at 12:51, 20 March 2015

2015-03-20T12:51:30Z

← Older revision		Revision as of 12:51, 20 March 2015
Line 72:		Line 72:
	To remove a Formula, select Remove Formula		To remove a Formula, select Remove Formula
	and to clear all formulas, select Clear.<br />		and to clear all formulas, select Clear.<br />
	All analog values should be scaled before making calculations; therefore, it is very important to fill the Inp. Min, Inp. Max, Outp. Min, Outp. Max fields ~~with Normalized~~ values ~~that~~ are used in calculations.<br />		All analog values should be scaled before making calculations; therefore, it is very important to fill the '''Inp. Min, Inp. Max, Outp. Min, Outp. Max''' fields when normalized values are used in calculations.<br />
	AI values can be comma separated values, while CN have only full scale values. (AI=1,7 while CN=2)<br />		AI values can be comma separated values, while CN have only full scale values. (AI=1,7 while CN=2)<br />
	After editing the formula, the program automatically validates this formula and shows the result in the status area. If the formula is incorrect, the background of the edited formula is changed to pink and an error message is displayed in the status area. This formula will not be written to the device nor will it be saved.<br />		After editing the formula, the program automatically validates this formula and shows the result in the status area. If the formula is incorrect, the background of the edited formula is changed to pink and an error message is displayed in the status area. This formula will not be written to the device nor will it be saved.<br />
Line 80:		Line 80:

	'''Editing formulas'''<br />		'''Editing formulas'''<br />
	Formulas can be edited form the formula string directly. In the formulas tab card, but it is more convenient to ~~double~~ click on the string and choose edit formula, then more information about the formula is visible.<br />		Formulas can be edited form the formula string directly. In the formulas tab card, but it is more convenient to right click on the string and choose edit formula, then more information about the formula is visible.<br />

	Telem GW has the possibility to create formulas using PLC functionality. For enabling the PLC functionality, two folders: ActivePLC and plcEditor (provided by Martem AS) have to be copied to the same location as configuration tool GWS.<br />		Telem GW has the possibility to create formulas using PLC functionality. For enabling the PLC functionality, two folders: ActivePLC and plcEditor (provided by Martem AS) have to be copied to the same location as configuration tool GWS.<br />

	'''Using PLC or editing formulas'''<br />		'''Using PLC or editing formulas'''<br />
	Open configuration window and click on PLC button. PLC configuration window opens.<br />		Open configuration window and click on PLC button. PLC configuration window opens.<br />

Roland at 12:47, 20 March 2015

2015-03-20T12:47:04Z

← Older revision		Revision as of 12:47, 20 March 2015
Line 8:		Line 8:
	'''Execution count:''' The number of control operations executed. <br />		'''Execution count:''' The number of control operations executed. <br />
	'''Delay:''' Delay in seconds, delay applies to on and off state<br />		'''Delay:''' Delay in seconds, delay applies to on and off state<br />
	Forb. DO – The number of DO, which control is forbidden with the result of this formula <br />		'''Forb. DO:''' The number of DO, which control is forbidden with the result of this formula <br />
	Enable First Control: If set to Yes, then control described in DO/AO will take place right after Telem device restart, otherwise change in the formula is necessary for control command.<br />		'''Enable First Control:''' If set to Yes, then control described in DO/AO will take place right after Telem device restart, otherwise change in the formula is necessary for control command.<br />

	Formulas can be created between the values of analog and/or digital objects.		Formulas can be created between the values of analog and/or digital objects.

Roland at 12:46, 20 March 2015

2015-03-20T12:46:30Z

← Older revision		Revision as of 12:46, 20 March 2015
Line 2:		Line 2:

	'''Columns:'''<br />		'''Columns:'''<br />
	Type, Sub Type , Invert, Object Adr ^, DB %Fs, Inp. Min, Inp. Max, Outp. Min, Outp. Max, Forb.Ports - as in Objects Tab Card<br />		'''Type, Sub Type , Invert, Object Adr ^, DB %Fs, Inp. Min, Inp. Max, Outp. Min, Outp. Max, Forb.'''-Ports same as described in Objects Tab Card<br />
	Formula: Formula string<br />		'''Formula:''' Formula string<br />
	Comment: Comment of the formula<br />		'''Comment:''' Comment of the formula<br />
	DO/AO addr.: Address of the object controlled by formula.<br />		'''DO/AO addr.:''' Address of the object controlled by formula.<br />
	Execution count: The number of control operations executed. <br />		'''Execution count:''' The number of control operations executed. <br />
	Delay – Delay in seconds, delay applies to on and off state<br />		'''Delay:''' Delay in seconds, delay applies to on and off state<br />
	Forb. DO – The number of DO, which control is forbidden with the result of this formula <br />		Forb. DO – The number of DO, which control is forbidden with the result of this formula <br />
	Enable First Control: If set to Yes, then control described in DO/AO will take place right after Telem device restart, otherwise change in the formula is necessary for control command.<br />		Enable First Control: If set to Yes, then control described in DO/AO will take place right after Telem device restart, otherwise change in the formula is necessary for control command.<br />

Roland at 09:34, 9 March 2015

2015-03-09T09:34:47Z

← Older revision		Revision as of 09:34, 9 March 2015
Line 92:		Line 92:
	Saved .csv file has to be opened with Formula Maker.<br />		Saved .csv file has to be opened with Formula Maker.<br />

	Note: PLC function changes only formula line, other parameters in the formula tab card such as Type, subtype etc. have to be changed in the GWS.		'''Note:'''<br />
			PLC function changes only formula line, other parameters in the formula tab card such as Type, subtype etc. have to be changed in the GWS.

Roland at 09:33, 9 March 2015

2015-03-09T09:33:58Z

← Older revision		Revision as of 09:33, 9 March 2015
Line 88:		Line 88:
	To use formula maker or editing formulas configuration has to be exported to .csv file format.<br />		To use formula maker or editing formulas configuration has to be exported to .csv file format.<br />
	For opening or saving .csv file in formula maker choose:<br />		For opening or saving .csv file in formula maker choose:<br />
	system>GWs<br />		:system>GWs<br />
	file>open<br />		:file>open<br />
	Saved .csv file has to be opened with Formula Maker.<br />		Saved .csv file has to be opened with Formula Maker.<br />

	Note: PLC function changes only formula line, other parameters in the formula tab card such as Type, subtype etc. have to be changed in the GWS.		Note: PLC function changes only formula line, other parameters in the formula tab card such as Type, subtype etc. have to be changed in the GWS.

Alfred at 11:02, 26 February 2015

2015-02-26T11:02:52Z

← Older revision		Revision as of 11:02, 26 February 2015
Line 37:		Line 37:
	\|"-"\|\|AI/CN\|\|Subtraction\|\|@101-0,49\|\|3		\|"-"\|\|AI/CN\|\|Subtraction\|\|@101-0,49\|\|3
	\|-		\|-
	\|""\|\|AI/CN\|\|Multiplication\|\|@1012\|\|2		\|""\|\|AI/CN\|\|Multiplication\|\|@1012,0\|\|2
	\|-		\|-
	\|"/"\|\|AI/CN\|\|Division\|\|@101/2,0\|\|2		\|"/"\|\|AI/CN\|\|Division\|\|@101/2,0\|\|2

Alfred at 11:02, 26 February 2015

2015-02-26T11:02:34Z

← Older revision		Revision as of 11:02, 26 February 2015
Line 39:		Line 39:
	\|""\|\|AI/CN\|\|Multiplication\|\|@1012\|\|2		\|""\|\|AI/CN\|\|Multiplication\|\|@1012\|\|2
	\|-		\|-
	\|"/"\|\|AI/CN\|\|Division\|\|@101/2\|\|2		\|"/"\|\|AI/CN\|\|Division\|\|@101/2,0\|\|2
	\|-		\|-
	\|"^"\|\|AI/CN\|\|Exponentiation\|\|@101^2\|\|1		\|"^"\|\|AI/CN\|\|Exponentiation\|\|@101^2,0\|\|1
	\|-		\|-
	\|"<"\|\|AI/CN\|\|Greater than\|\|@101<0,499\|\|4		\|"<"\|\|AI/CN\|\|Greater than\|\|@101<0,499\|\|4

Roland at 09:43, 26 February 2015

2015-02-26T09:43:50Z

Roland at 09:33, 26 February 2015

2015-02-26T09:33:52Z

@@ Line 31: / Line 31: @@
 | Näide || Näide || Näide || Näide || Näide
 |-
-| Näide || Näide || Näide || Näide || Näide
+| not || DI || Logical negation|| not@201||0
 |-
-| Näide || Näide || Näide || Näide || Näide
+|"*"||AI/CN||Multiplication||@101*2||2
 |-
-| Näide || Näide || Näide || Näide || Näide
+|"/"||AI/CN||Division||@101/2||2
 |-
-| Näide || Näide || Näide || Näide || Näide
+|"^"||AI/CN||Exponentiation||@101^2||1
 |-
-| Näide || Näide || Näide || Näide || Näide
+|"<"||AI/CN||Greater than||@101<0,499||4
 |-
-| Näide || Näide || Näide || Näide || Näide
+|>||AI/CN||Less than||@101>0,5||4
 |-
-| not || DI || Logical negation|| not@201||0
+|sqr||AI/CN||Square||sqr(@101*10)||0
 |-
-| dbl|| DI|| Converts 2 single digital inputs into a double signal||
+|arctan||AI/CN||||arctan@301||0
 |}
 *Priority determines the order of operations in the formula (highest priority is 0) <br />

Roland at 09:11, 26 February 2015

2015-02-26T09:11:32Z

@@ Line 24: / Line 24: @@
 |-
 | and || DI || Logical conjunction || @201and@202 || 5
 |-
 | Näide || Näide || Näide || Näide || Näide
@@ Line 39: / Line 43: @@
 | Näide || Näide || Näide || Näide || Näide
 |-
-| Näide || Näide || Näide || Näide || Näide
+| not || DI || Logical negation|| not@201||0
 |-
-| Näide || Näide || Näide || Näide || Näide
+| dbl|| DI|| Converts 2 single digital inputs into a double signal||
 @202dbl@201,where
 @202 – ON state signal
@@ Line 142: / Line 125: @@
 arctan@301
 *Priority determines the order of operations in the formula (highest priority is 0) <br />
 '''Notes'''<br />

← Older revision		Revision as of 09:43, 26 February 2015
Line 28:		Line 28:
	\|-		\|-
	\| xor \|\| DI \|\| Exclusive disjunction \|\| @201xor@202 \|\| 6		\| xor \|\| DI \|\| Exclusive disjunction \|\| @201xor@202 \|\| 6
	\|-
	~~\| Näide \|\| Näide \|\| Näide \|\| Näide \|\| Näide~~
	\|-		\|-
	\| not \|\| DI \|\| Logical negation\|\| not@201\|\|0		\| not \|\| DI \|\| Logical negation\|\| not@201\|\|0
Line 70:		Line 68:
	By clicking on the button „-“ , the selected formula row is removed.<br />		By clicking on the button „-“ , the selected formula row is removed.<br />

	Formula rows can also be added, removed or cleared by using the extended control menu like in the Object Tab Card. It appears with a right mouse click on the Formula Tab Card.		Formula rows can also be added, removed or cleared by using the extended control menu like in the Object Tab Card. It appears with a right mouse click on the Formula Tab Card.<br />
	To add a Formula, select Add Formulas,		To add a Formula, select Add Formulas,
	To remove a Formula, select Remove Formula		To remove a Formula, select Remove Formula
	and to clear all formulas, select Clear.		and to clear all formulas, select Clear.<br />
	All analog values should be scaled before making calculations; therefore, it is very important to fill the Inp. Min, Inp. Max, Outp. Min, Outp. Max fields with Normalized values that are used in calculations.		All analog values should be scaled before making calculations; therefore, it is very important to fill the Inp. Min, Inp. Max, Outp. Min, Outp. Max fields with Normalized values that are used in calculations.<br />
	AI values can be comma separated values, while CN have only full scale values. (AI=1,7 while CN=2)		AI values can be comma separated values, while CN have only full scale values. (AI=1,7 while CN=2)<br />
	After editing the formula, the program automatically validates this formula and shows the result in the status area. If the formula is incorrect, the background of the edited formula is changed to pink and an error message is displayed in the status area. This formula will not be written to the device nor will it be saved.		After editing the formula, the program automatically validates this formula and shows the result in the status area. If the formula is incorrect, the background of the edited formula is changed to pink and an error message is displayed in the status area. This formula will not be written to the device nor will it be saved.<br />
	The formulas of DI type of objects can contain AI values and floating point constants. If the result of the formula is greater than 0, the value of the DI object is “1”; if the result of the formula is less than or equal to 0, the value of the DI object is “0”.		The formulas of DI type of objects can contain AI values and floating point constants. If the result of the formula is greater than 0, the value of the DI object is “1”; if the result of the formula is less than or equal to 0, the value of the DI object is “0”.<br />
	< or > statement: if the statement is true, the value of the DI object is 1; if the statement is false, the value of the DI object is 0.		< or > statement: if the statement is true, the value of the DI object is 1; if the statement is false, the value of the DI object is 0.
			<br />

	Editing formulas		'''Editing formulas'''<br />
	Formulas can be edited form the formula string directly. In the formulas tab card, but it is more convenient to double click on the string and choose edit formula, then more information about the formula is visible.		Formulas can be edited form the formula string directly. In the formulas tab card, but it is more convenient to double click on the string and choose edit formula, then more information about the formula is visible.<br />
	Telem GW has the possibility to create formulas using PLC functionality. For enabling the PLC functionality, two folders: ActivePLC and plcEditor (provided by Martem AS) have to be copied to the same location as configuration tool GWS.		Telem GW has the possibility to create formulas using PLC functionality. For enabling the PLC functionality, two folders: ActivePLC and plcEditor (provided by Martem AS) have to be copied to the same location as configuration tool GWS.<br />
	Using PLC or editing formulas		'''Using PLC or editing formulas'''<br />
	Open configuration window and click on PLC button. PLC configuration window opens.		Open configuration window and click on PLC button. PLC configuration window opens.<br />
	Double click on Main button in the upper left hand corner to open PLC configuration window. When main window is opened, user can choose logical function and variables. When PLC window is closed, logic functions are exported to formulas tab.		Double click on Main button in the upper left hand corner to open PLC configuration window. When main window is opened, user can choose logical function and variables. When PLC window is closed, logic functions are exported to formulas tab.<br />
	Another method or creating and changing formulas is to use Formula Maker (provided by Martem AS).		Another method or creating and changing formulas is to use Formula Maker (provided by Martem AS).
	To use formula maker or editing formulas configuration has to be exported to .csv file format.		To use formula maker or editing formulas configuration has to be exported to .csv file format.<br />
	For opening or saving .csv file in formula maker choose:		For opening or saving .csv file in formula maker choose:<br />
	system>GWs		system>GWs<br />
	file>open		file>open<br />
	Saved .csv file has to be opened with Formula Maker.		Saved .csv file has to be opened with Formula Maker.<br />

	Note: PLC function changes only formula line, other parameters in the formula tab card such as Type, subtype etc. have to be changed in the GWS.		Note: PLC function changes only formula line, other parameters in the formula tab card such as Type, subtype etc. have to be changed in the GWS.