Back to index

wims  3.65+svn20090927
Classes | Namespaces
Function.java File Reference

Go to the source code of this file.

Classes

class  SharpTools.Function
 Function classes used only by Formula to evaluate functions. More...
class  SharpTools.FunctionSum
 SUM
usage: =SUM(parameter list)
returns the arithmetic sum of the specified parameters
example: =SUM(-1,2,57) returns 58.0 More...
class  SharpTools.FunctionCount
 COUNT
usage: =COUNT(parameter list)
returns the number of parameters specified
example: =COUNT(A1:A7) returns 7.0 More...
class  SharpTools.FunctionAverage
 AVERAGE
usage: =AVERAGE(parameter list)
returns the arithmetic mean of the specified parameters
example: =AVERAGE(1,2,3) returns 2.0 More...
class  SharpTools.FunctionMedian
 MEDIAN
usage: =MEDIAN(parameter list)
returns the median (the value in the middle) of the specified parameters
example: =MEDIAN(1,2,5) returns 2.0 More...
class  SharpTools.FunctionMin
 MIN
usage: =MIN(parameter list)
returns the minimum value of the specified parameters
example: =MIN(5,6,-1) returns -1.0 More...
class  SharpTools.FunctionMax
 MAX
usage: =MAX(parameter list)
returns the maximum value of the specified parameters
example: =MAX(5,6,-1) returns 6.0 More...
class  SharpTools.FunctionRange
 Range More...
class  SharpTools.FunctionAbs
 ABS
usage: =ABS(parameter)
accepts only one literal or address
returns the absolute value of the specified parameter
example: =ABS(-92) returns 92.0 More...
class  SharpTools.FunctionSin
 SIN
usage: =SIN(parameter)
accepts only one literal or address
returns the sine of the specified parameter (in radians)
example: =SIN(45) returns 0.8509035 More...
class  SharpTools.FunctionCos
 COS
usage: =COS(parameter)
accepts only one literal or address
returns the cosine of the specified parameter (in radians)
example: =COS(30) returns 0.15425146 More...
class  SharpTools.FunctionTan
 TAN
usage: =TAN(parameter)
accepts only one literal or address
returns the tangent of the specified parameter (in radians)
example: =TAN(60) returns 0.32004037 More...
class  SharpTools.FunctionAsin
 ASIN
usage: =ASIN(parameter)
accepts only one literal or address
returns the arcsine of the specified parameter (in radians)
example: =ASIN(60) returns 0.5235988 More...
class  SharpTools.FunctionAcos
 ACOS
usage: =ACOS(parameter)
accepts only one literal or address
returns the arccosine of the specified parameter (in radians)
example: =ACOS(.5) returns 1.0471976 More...
class  SharpTools.FunctionAtan
 ATAN
usage: =ATAN(parameter)
accepts only one literal or address
returns the arctangent of the specified parameter (in radians)
example: =ATAN(60) returns 1.5541312 More...
class  SharpTools.FunctionInt
 INT returns the integer part of a number More...
class  SharpTools.FunctionRound
 ROUND
usage: =ROUND(parameter, num_digits)
Rounds a number to a specified number of digits
example: =ROUND(1.534, 2) returns 1.53 More...
class  SharpTools.FunctionSqrt
 SQRT
usage: =STDDEV(parameter)
returns the standard deviation of the specified parameter
example: =SQRT(19044) returns 138.0 More...
class  SharpTools.FunctionLog
 LOG
usage: =LOG(parameter)
returns the logarithm base E of the specified parameter
example: =LOG(1) returns 0.0 More...
class  SharpTools.FunctionMeandev
 MEANDEV
usage: =MEANDEV(parameter list)
returns the mean deviation of the specified parameters
example: =STDDEV(100,60,60,80,80) returns 12.8 More...
class  SharpTools.FunctionStddev
 STDDEV
usage: =STDDEV(parameter list)
returns the standard deviation of the specified parameters
example: =STDDEV(100,60,60,80,80) returns 16.7332 More...
class  SharpTools.FunctionPI
 This gives us contant PI. More...
class  SharpTools.FunctionE
 This gives us contant E. More...

Namespaces

package  SharpTools
 This is an object the represents the coordinates of a cell in the table.