MapWindow:Desktop:TableEditorFunctions
From MapWindow GIS
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
