Formula Specification in Templates - Revision history

PetrDlask: /* Geodetic */

2026-07-20T13:56:28Z

Geodetic

← Older revision		Revision as of 15:56, 20 July 2026
Line 1,272:		Line 1,272:
	\|''CSCONVERTTOGPSLAT(CSDef;X;Y)''		\|''CSCONVERTTOGPSLAT(CSDef;X;Y)''
	\|Returns GPS latitude of XY coordinates		\|Returns GPS latitude of XY coordinates
	\|CSCONVERTTOGPSLAT(''''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒'' '''50,076'''		\|CSCONVERTTOGPSLAT(''''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒'' '''50,076''' = ''Lat Prague city''
	\|-		\|-
	\|CSCONVERTTOGPSLON		\|CSCONVERTTOGPSLON
	\|''CSCONVERTTOGPSLON(CSDef;X;Y)''		\|''CSCONVERTTOGPSLON(CSDef;X;Y)''
	\|Returns GPS longitude of XY coordinates		\|Returns GPS longitude of XY coordinates
	\|CSCONVERTTOGPSLAT('~~<nowiki/>~~'''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒ '''14,438'''''		\|CSCONVERTTOGPSLAT(''''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒ '''14,438''' = Lon Prague city''
	\|-		\|-
	\|CSCONVERTX		\|CSCONVERTX
	\|''CSCONVERTX(SourceCSDef;TargetCSDef;SourceX;SourceY)''		\|''CSCONVERTX(SourceCSDef;TargetCSDef;SourceX;SourceY)''
	\|Returns X coordinate of coordinate systems conversion		\|Returns X coordinate of coordinate systems conversion
	\|CSCONVERTX('[DB]EPSG:5514';'[DB]EPSG:5514';-741817,772;-1044492,557) ''⇒ -741817,772''		\|CSCONVERTX('<nowiki/>'''[DB]EPSG:5514'''<nowiki/>';''''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒ '''-741817,772''' ='' SourceX
	\|-		\|-
	\|CSCONVERTY		\|CSCONVERTY
	\|''CSCONVERTY(SourceCSDef;TargetCSDef;SourceX;SourceY)''		\|''CSCONVERTY(SourceCSDef;TargetCSDef;SourceX;SourceY)''
	\|Returns X coordinate of coordinate systems conversion		\|Returns X coordinate of coordinate systems conversion
	\|CSCONVERTY('[DB]EPSG:5514';'[DB]EPSG:5514';-741817,772;-1044492,557) ''⇒ '''-1044492,557'''''		\|CSCONVERTY('<nowiki/>'''[DB]EPSG:5514'''<nowiki/>';''''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒ '''-1044492,557''' = SourceY''
	\|-		\|-
	\|CSCURRENTDEFINITION		\|CSCURRENTDEFINITION

PetrDlask: /* Geodetic */

2026-07-20T13:00:58Z

Geodetic

← Older revision		Revision as of 15:00, 20 July 2026
Line 1,259:		Line 1,259:
	CSCONVERTFROMGPSX(CSCURRENTDEFINITION();'''50,0755''';'''14,4378''')		CSCONVERTFROMGPSX(CSCURRENTDEFINITION();'''50,0755''';'''14,4378''')

	CSCONVERTFROMGPSX('~~<nowiki/>~~'''[DB]EPSG:5514'''';'''50,0755''';'''14,4378''') ''⇒ -741817,772''		CSCONVERTFROMGPSX(''''[DB]EPSG:5514'''';'''50,0755''';'''14,4378''') ''⇒ -741817,772''
	\|-		\|-
	\|CSCONVERTFROMGPSY		\|CSCONVERTFROMGPSY
Line 1,272:		Line 1,272:
	\|''CSCONVERTTOGPSLAT(CSDef;X;Y)''		\|''CSCONVERTTOGPSLAT(CSDef;X;Y)''
	\|Returns GPS latitude of XY coordinates		\|Returns GPS latitude of XY coordinates
	\|		\|CSCONVERTTOGPSLAT(''''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒'' '''50,076'''
	\|-		\|-
	\|CSCONVERTTOGPSLON		\|CSCONVERTTOGPSLON
	\|''CSCONVERTTOGPSLON(CSDef;X;Y)''		\|''CSCONVERTTOGPSLON(CSDef;X;Y)''
	\|Returns GPS longitude of XY coordinates		\|Returns GPS longitude of XY coordinates
	\|		\|CSCONVERTTOGPSLAT('<nowiki/>'''[DB]EPSG:5514'''<nowiki/>';'''-741817,772''';'''-1044492,557''') ''⇒ '''14,438'''''
	\|-		\|-
	\|CSCONVERTX		\|CSCONVERTX
	\|''CSCONVERTX(SourceCSDef;TargetCSDef;SourceX;SourceY)''		\|''CSCONVERTX(SourceCSDef;TargetCSDef;SourceX;SourceY)''
	\|Returns X coordinate of coordinate systems conversion		\|Returns X coordinate of coordinate systems conversion
	\|		\|CSCONVERTX('[DB]EPSG:5514';'[DB]EPSG:5514';-741817,772;-1044492,557) ''⇒ -741817,772''
	\|-		\|-
	\|CSCONVERTY		\|CSCONVERTY
	\|''CSCONVERTY(SourceCSDef;TargetCSDef;SourceX;SourceY)''		\|''CSCONVERTY(SourceCSDef;TargetCSDef;SourceX;SourceY)''
	\|Returns X coordinate of coordinate systems conversion		\|Returns X coordinate of coordinate systems conversion
	\|		\|CSCONVERTY('[DB]EPSG:5514';'[DB]EPSG:5514';-741817,772;-1044492,557) ''⇒ '''-1044492,557'''''
	\|-		\|-
	\|CSCURRENTDEFINITION		\|CSCURRENTDEFINITION

PetrDlask: /* Geodetic */

2026-07-20T12:55:51Z

Geodetic

← Older revision		Revision as of 14:55, 20 July 2026
Line 1,256:		Line 1,256:
	\|''CSCONVERTFROMGPSX(CSDef;Latitude;Longitude)''		\|''CSCONVERTFROMGPSX(CSDef;Latitude;Longitude)''
	\|Returns X coordinate converted from GPS coordinates		\|Returns X coordinate converted from GPS coordinates
	\|		\|Prague city: Lat = '''50.0755367''', Long = '''14.4378'''
			CSCONVERTFROMGPSX(CSCURRENTDEFINITION();'''50,0755''';'''14,4378''')

			CSCONVERTFROMGPSX('<nowiki/>'''[DB]EPSG:5514'''';'''50,0755''';'''14,4378''') ''⇒ -741817,772''
	\|-		\|-
	\|CSCONVERTFROMGPSY		\|CSCONVERTFROMGPSY
	\|''CSCONVERTFROMGPSY(CSDef;Latitude;Longitude)''		\|''CSCONVERTFROMGPSY(CSDef;Latitude;Longitude)''
	\|Returns Y coordinate converted from GPS coordinates		\|Returns Y coordinate converted from GPS coordinates
	\|		\|Prague city: Lat = '''50.0755367''', Long = '''14.4378'''
			CSCONVERTFROMGPSY(CSCURRENTDEFINITION();'''50,0755''';'''14,4378''')

			CSCONVERTFROMGPSY(''''[DB]EPSG:5514'''<nowiki/>';'''50,0755''';'''14,4378''') ''⇒ -1044492,557''
	\|-		\|-
	\|CSCONVERTTOGPSLAT		\|CSCONVERTTOGPSLAT

PetrDlask: /* Text */

2026-07-20T12:42:58Z

Text

@@ Line 301: / Line 301: @@
 ''CONCAT('''{GWT<sub>b</sub>}''';" m") ⇒ "15 m"''
 |-
 |LEFT

PetrDlask: /* Geodetic */

2026-07-20T12:33:08Z

Geodetic

@@ Line 1,239: / Line 1,239: @@
 !''Example''
 |-
-|CurrentDefinition
+|CSCONVERTFROMGPSX
-|''DATE(Year;Month;Day)''
+|''CSCONVERTFROMGPSX(CSDef;Latitude;Longitude)''
-|Returns the serial number of a particular date
+|Returns X coordinate converted from GPS coordinates
 |''DATE(1899;12;30) ⇒ 0''
 ''DATE(2024;10;31) ⇒ 45596''

PetrDlask at 12:25, 20 July 2026

2026-07-20T12:25:26Z

← Older revision		Revision as of 14:25, 20 July 2026
Line 1,230:		Line 1,230:

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

			=== Geodetic ===
			{\| class="wikitable sortable mw-collapsible"
			!Name
			!Syntax, parameters
			!Description
			!''Example''
			\|-
			\|CurrentDefinition
			\|''DATE(Year;Month;Day)''
			\|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''
	\|}		\|}

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