Formula Specification in Templates - Revision history

PetrDlask: /* Informative */

2024-12-20T14:30:57Z

Informative

← Older revision		Revision as of 16:30, 20 December 2024
Line 226:		Line 226:
	\|		\|
	\|Returns the sum of all the values that meet a given criteria		\|Returns the sum of all the values that meet a given criteria
	\|		\|''SUMIF('''{X_Coor⇕}''';">2";'''{Y_Coor⇕}''')''
	\|-		\|-
	\|SUMIFS		\|SUMIFS
Line 1,025:		Line 1,025:
	\|-		\|-
	\|ISNUMBER		\|ISNUMBER
	\|		\|''ISNUMBER()''
	\|Returns TRUE if argument is number		\|Returns TRUE if argument is number
	\|		\|ISNUMBER(15) ''⇒ TRUE; ⇒ 1''
			ISNUMBER(15e2) ''⇒ TRUE; ⇒ 1''

			ISNUMBER(1/4) ''⇒ TRUE; ⇒ 1''

			ISNUMBER(aaa) ''⇒ FALSE; ⇒ 0''
	\|		\|
	\|-		\|-
	\|ISTEXT		\|ISTEXT
	\|		\|''ISTEXT()''
	\|Returns TRUE if argument is text		\|Returns TRUE if argument is text
	\|		\|ISTEXT(123)
			ISTEXT("123")

			ISTEXT(abc)

			ISTEXT("abc")
	\|		\|
	\|-		\|-

PetrDlask: /* Date and Time */

2024-12-20T13:03:51Z

Date and Time

← Older revision		Revision as of 15:03, 20 December 2024
Line 1,190:		Line 1,190:
	\|-		\|-
	\|NOW		\|NOW
	\|		\|''NOW()''
	\|Returns the serial number of the current date and time		\|Returns the serial number of the current date and time
	\|		\|''For date and time 20.12.2024 13:48:04 is''
			''NOW() ⇒ 45646.5750510648''

			''For date and time 01.01.1900 00:00:00 is''

			''NOW() ⇒ 1.00''
	\|-		\|-
	\|TIME		\|TIME
Line 1,207:		Line 1,212:
	\|-		\|-
	\|TODAY		\|TODAY
	\|		\|''TODAY()''
	\|Returns the serial number of the current date		\|Returns the serial number of the current date
	\|		\|''For date 20:12:2024''
			''TODAY() ⇒ 45646''

			''For date 1.1.1900''

			''TODAY() ⇒ 1''
	\|}		\|}

PetrDlask: /* Mathematical */

2024-12-20T10:52:18Z

Mathematical

Show changes

PetrDlask: /* Mathematical */

2024-12-20T10:43:04Z

Mathematical

← Older revision		Revision as of 12:43, 20 December 2024
Line 219:		Line 219:
	\|Returns the sum of a series of numbers		\|Returns the sum of a series of numbers
	\|''Inputs linked to data '''X[0;1;2;3;4;5;6]'''):''		\|''Inputs linked to data '''X[0;1;2;3;4;5;6]'''):''
	''SUM('''[X⇓2:⇓5]''') ... SUM('''⟨1; 2; 3; 4⟩''') ⇒ 10''		''SUM('''{X⇓2:⇓5}''') ... SUM('''1; 2; 3; 4''') ⇒ 10''

	''SUM('''[X⇕]''') ⇒ 21''		''SUM('''{X⇕}''') ⇒ 21''
	\|-		\|-
	\|SUMIF		\|SUMIF

PetrDlask at 10:41, 20 December 2024

2024-12-20T10:41:41Z

← Older revision		Revision as of 12:41, 20 December 2024
Line 37:		Line 37:
	''IF(220>200;220-200;200-220) ⇒ 20''		''IF(220>200;220-200;200-220) ⇒ 20''

	''IF(120>MAX('''[X⇕]''');120;-1) ⇒ 120''		''IF(120>MAX('''{X⇕}''');120;-1) ⇒ 120''

	''IF(MAX('''[X⇓2:⇓3]''')>'''[X⇓7]''';MAX('''[X⇓2:⇓3]''');'''[X⇓7]''')) ⇒ 6''		''IF(MAX('''{X⇓2:⇓3}''')>'''{X⇓7}''';MAX('''{X⇓2:⇓3}''');'''{X⇓7}''')) ⇒ 6''

	''IF(MAX('''⟨1;2⟩''')>'''6''';MAX('''⟨1;2⟩''');'''6''') ⇒ 6''		''IF(MAX('''1;2''')>'''6''';MAX('''1;2''');'''6''') ⇒ 6''

	Result is text:		Result is text:

	''Input'' '''''[Coordinate Z]''''' ''= 210''';[GWT]''' = 180''		''Input'' '''''{Coordinate Z}''''' ''= 210''';{GWT}''' = 180''

	''IF('''[Coordinate Z]'''>0;"Above terrain";"Under terrain") ⇒ "Top above terrain"''		''IF('''{Coordinate Z}'''>0;"Above terrain";"Under terrain") ⇒ "Top above terrain"''

	''IF('''[GWT]'''<'''[Coordinate Z]''';"GWT under top of the test.";"Measure error.") ⇒ "GWT under top of the test."''		''IF('''{GWT}'''<'''{Coordinate Z}''';"GWT under top of the test.";"Measure error.") ⇒ "GWT under top of the test."''
	\|-		\|-
	\|IFS		\|IFS
	\|''IFS(Test1;Then1;Test2;Then2; ... ;Else)''		\|''IFS(Test1;Then1;Test2;Then2; ... ;Else)''
	\|Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition		\|Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
	\|''Input'' '''''[GWT]''''' ''= 15''		\|''Input'' '''''{GWT}''''' ''= 15''
	''IFS('''[GWT]'''>8;10;'''[GWT]'''>6;9;'''[GWT]'''>3;8;-1) ⇒ 10''		''IFS('''{GWT}'''>8;10;'''{GWT}'''>6;9;'''{GWT}'''>3;8;-1) ⇒ 10''
	\|-		\|-
	\|NOT		\|NOT

PetrDlask: /* Date and Time */

2024-10-31T14:25:05Z

Date and Time

← Older revision		Revision as of 16:25, 31 October 2024
Line 1,177:		Line 1,177:
	\|-		\|-
	\|DATE		\|DATE
	\|		\|''DATE(Year;Month;Day)''
	\|Returns the serial number of a particular date		\|Returns the serial number of a particular date
	\|		\|''DATE(1899;12;30) ⇒ 0''
			''DATE(2024;10;31) ⇒ 45596''

			''Inputs linked to data''

			'''''{MyYear}'''=2024;'''{MyMonth}'''=10;'''{MyDay}'''=31''

			''DATE('''{MyYear}''';'''{MyMonth}''';'''{MyDay}''') ⇒ 45596''

	\|-		\|-
	\|NOW		\|NOW
Line 1,187:		Line 1,195:
	\|-		\|-
	\|TIME		\|TIME
	\|		\|''TIME(Hour;Minute;Second)''
	\|Returns the serial number of a particular time		\|Returns the serial number of a particular time
	\|		\|''TIME(0;0;0) ⇒ 0''
			''TIME(18;15;20) ⇒ 0.760648''

			''Inputs linked to data''

			'''''{MyHour}'''=10[hour];'''{MyMinute}'''=15[min.];'''{MySecond}'''=25[sec.]''

			''TIME('''{MyHour}''';'''{MyMinute}''';'''{MySecond}''') ⇒ 0.42737''
	\|-		\|-
	\|TODAY		\|TODAY

PetrDlask: /* Date and Time */

2024-10-22T09:01:25Z

Date and Time

← Older revision		Revision as of 11:01, 22 October 2024
Line 1,175:		Line 1,175:
	!Description		!Description
	!''Example''		!''Example''
			\|-
			\|DATE
			\|
			\|Returns the serial number of a particular date
			\|
	\|-		\|-
	\|NOW		\|NOW
	\|		\|
	\|Returns the serial number of the current date and time		\|Returns the serial number of the current date and time
			\|
			\|-
			\|TIME
			\|
			\|Returns the serial number of a particular time
	\|		\|
	\|-		\|-

PetrDlask: /* Date and Time */

2024-10-15T13:24:05Z

Date and Time

← Older revision		Revision as of 15:24, 15 October 2024
Line 1,170:		Line 1,170:
	\|}		\|}
	=== Date and Time ===		=== Date and Time ===
			{\| class="wikitable sortable mw-collapsible"
			!Name
			!Syntax, parameters
			!Description
			!''Example''
			\|-
			\|NOW
			\|
			\|Returns the serial number of the current date and time
			\|
			\|-
			\|TODAY
			\|
			\|Returns the serial number of the current date
			\|
			\|}

PetrDlask at 13:22, 15 October 2024

2024-10-15T13:22:17Z

← Older revision		Revision as of 15:22, 15 October 2024
Line 1,169:		Line 1,169:
	\|}		\|}
	\|}		\|}
			=== Date and Time ===

PetrDlask: /* Text */

2024-10-15T13:20:12Z

Text

← Older revision		Revision as of 15:20, 15 October 2024
Line 307:		Line 307:
	\|''LEFT("qwert";3) ⇒ "qwe"''		\|''LEFT("qwert";3) ⇒ "qwe"''
	''LEFT("qwert";1) ⇒ "q"''		''LEFT("qwert";1) ⇒ "q"''
			\|-
			\|LEN
			\|''LEN(Text)''
			\|Returns the number of characters in a text string
			\|''LEN("qwert") ⇒ 5''
			''LEN("") ⇒ 0''
	\|-		\|-
	\|RIGHT		\|RIGHT
Line 313:		Line 319:
	\|''RIGHT("qwert";3) ⇒ "ert"''		\|''RIGHT("qwert";3) ⇒ "ert"''
	''RIGHT("qwert";1) ⇒ "t"''		''RIGHT("qwert";1) ⇒ "t"''
	\|-
	~~\|LEN~~
	~~\|''LEN(Text)''~~
	~~\|Returns the number of characters in a text string~~
	~~\|''LEN("qwert") ⇒ 5''~~
	~~''LEN("") ⇒ 0''~~
	\|-		\|-
	\|SEARCH		\|SEARCH
Line 324:		Line 324:
	\|Finds one text value within another (not case-sensitive)		\|Finds one text value within another (not case-sensitive)
	\|''SEARCH("G";"Hello GEO!";1) ⇒ 7''		\|''SEARCH("G";"Hello GEO!";1) ⇒ 7''
			\|-
			\|TEXT
			\|
			\|Converts number to text
			\|
	\|}		\|}
	=== Statistical ===		=== Statistical ===