MapWindow:Desktop:TableEditorFunctions

This is a back-up of the WIKI.
Not all links might work
We're working on a new wiki.

Main Page | Recent changes | View source | Page history | Log in / create account |

Printable version | Disclaimers | Privacy policy

The following functions may be used in the MapWindow Table Editor's Field Calculator window:


FUNCTION -- DESCRIPTION
+ -- addition
- -- subtraction
* -- multiplication
/ -- division
% -- percentage
\ -- integer division
^ -- raise to power
! -- factorial
abs(x) -- absolute value
"atn(x), atan(x)" -- inverse tangent
cos(x) -- cosine
sin(x) -- sin
exp(x) -- exponential
fix(x) -- integer part
int(x) -- integer part
dec(x) -- decimal part
"ln(x), log(x)" -- logarithm natural
"logN(x,n)" -- N-base logarithm
rnd(x) -- random
sgn(x) -- sign
sqr(x) -- square root
cbr(x) -- cube root
tan(x) -- tangent
acos(x) -- inverse cosine
asin(x) -- Inverse sine
cosh(x) -- hyperbolic cosine
sinh(x) -- hyperbolic sine
tanh(x) -- hyperbolic tangent
acosh(x) -- Inverse hyperbolic cosine
asinh(x) -- Inverse hyperbolic sine
atanh(x) -- Inverse hyperbolic tangent
"root(x,n)" -- n-th root (the same as x^(1/n)
"mod(a,b)" -- Division remainder
fact(x) -- factorial
"comb(n,k)" -- combinations
"perm(n,k)" -- permutations
"min(a,b,...)" -- minimum
"max(a,b,...)" -- maximum
"mcd(a,b,...)" -- maximum common divisor 
"mcm(a,b,...)" -- minimum common multiple 
"gcd(a,b,...)" -- greatest common divisor 
"lcm(a,b,...)" -- lowest common multiple 
csc(x) -- cosecant
sec(x) -- secant
cot(x) -- cotangent
acsc(x) -- inverse cosecant
asec(x) -- inverse secant
acot(x) -- inverse cotangent
csch(x) -- hyperbolic cosecant
sech(x) -- hyperbolic secant
coth(x) -- hyperbolic cotangent
acsch(x) -- inverse hyperbolic cosecant
asech(x) -- inverse hyperbolic secant
acoth(x) -- inverse hyperbolic cotangent
rad(x) -- radiant conversion
deg(x) -- degree sess. conversion
grad(x) -- degree cent. conversion
"round(x,d)" -- round a number with d decimal
>  -- greater than
>= -- equal or greater than
<  -- less than
<= -- equal or less than
= -- equal
<>  -- not equal
and -- logic and
or -- logic or
not -- logic not
xor -- logic exclusive-or
nand -- logic nand
nor -- logic nor
nxor -- logic exclusive-nor
Psi(x)  -- Function psi 
"DNorm(x,?,?)" -- Normal density function
"CNorm(x,m,d)" -- Normal cumulative function
"DPoisson(x,k)" -- Poisson density function
"CPoisson(x,k)" -- "Poisson cumulative function k = 1, 2,3 ..."
"DBinom(k,n,x)" -- Binomial density for k successes for n trials 
"CBinom(k,n,x)" -- Binomial cumulative for k successes for n trials 
Si(x) -- Sine integral
Ci(x) -- Cosine integral
FresnelS(x) -- Fresnel's sine integral
FresnelC(x) -- Fresnel's cosine integral
J0(x) -- Bessel's function of 1st kind
Y0(x) -- Bessel's function of 2st kind
I0(x) -- "Bessel's function of 1st kind, modified"
K0(x) -- "Bessel's function of 2st kind, modified"
"BesselJ(x,n)" -- "Bessel's function of 1st kind, nth order"
"BesselY(x,n)" -- "Bessel's function of 2st kind, nth order"
"BesselI(x,n)" -- "Bessel's function of 1st kind, nth order, modified"
"BesselK(x,n)" -- "Bessel's function of 2st kind, nth order, modified"
"HypGeom(x,a,b,c)" -- Hypergeometric function
"PolyCh(x,n)" -- Chebycev's polynomials
"PolyLe(x,n)" -- Legendre's polynomials
"PolyLa(x,n)" -- Laguerre's polynomials
"PolyHe(x,n)" -- Hermite's polynomials
AiryA(x)    -- Airy function Ai(x)
AiryB(x)   -- Airy function Bi(x)
Elli1(x) -- Elliptic integral of 1st kind
Elli2(x)   -- Elliptic integral of 2st kind
Erf(x) -- Error Gauss's function
gamma(x) -- Gamma function
gammaln(x) -- Logarithm Gamma function
"gammai(a,x)" -- Gamma Incomplete function
digamma(x) psi(x) -- Digamma function
"beta(a,b)" -- Beta function
"betaI(x,a,b)" -- Beta Incomplete function
Ei(x) -- Exponential integral
"Ein(x,n)" -- Exponential integral of n order
zeta(x) -- zeta Riemman's function
"Clip(x,a,b)   " -- Clipping function
"WTRI(t,p)" -- Triangular wave  
"WSQR(t,p)" -- Square wave  
"WRECT(t,p,d)" -- Rectangular wave  
"WTRAPEZ(t,p,d)" -- Trapez. wave  
"WSAW(t,p)" -- Saw wave  
"WRAISE(t,p)" -- Rampa wave  
"WLIN(t,p,d)" -- Linear wave  
"WPULSE(t,p,d)" -- Rectangular pulse wave  
"WSTEPS(t,p,n)" -- Steps wave  
"WEXP(t,p,a)" -- Exponential pulse wave  
"WEXPB(t,p,a)" -- Exponential bipolar pulse wave  
"WPULSEF(t,p,a)" -- Filtered pulse wave  
"WRING(t,p,a,fm)" -- Ringing wave  
"WPARAB(t,p)" -- Parabolic pulse wave  
"WRIPPLE(t,p,a)" -- Ripple wave  
"WAM(t,fo,fm,m)" -- Amplitude modulation  
"WFM(t,fo,fm,m)" -- Frequecy modulation  
Year(d) -- year
Month(d) -- month
Day(d) -- day
Hour(d) -- hour
Minute(d) -- minute
Second(d) -- second
"DateSerial(a,m,d)" -- Dateserial from date
"TimeSerial(h,m,s)" -- Timeserial from time
time# -- system time
date# -- system date
now# -- system timestamp 
"Sum(a,b,...)" -- Sum
"Mean(a,b,...)" -- Arithmetic mean
"Meanq(a,b,...)" -- Quadratic mean
"Meang(a,b,...)" -- Arithmetic mean
"Var(a,b,...)" -- Variance
"Varp(a,b,...)" -- Variance pop.
"Stdev(a,b,...)" -- Standard deviation
"Stdevp(a,b,...)" -- Standard deviation pop.
"Step(x,a)" -- Haveside's step function

Return to Menu

Retrieved from "http://mapwindow.org/wiki/index.php/MapWindow:Desktop:TableEditorFunctions"

This page has been accessed 6,501 times. This page was last modified on 23 February 2008, at 11:14.