Re: [office-formula] List of functions in OpenFormula, dealingwith LEGACY.*

[Andreas J Guelzow <aguelzow@math.concordia.ab.ca>]

On Sun, 2008-06-08 at 22:10 -0400, David A. Wheeler wrote:
> Below is a list of the functions in OpenFormula, derived by pasting the
> table of contents into a file and running:
>  perl -n -e 'print "$1\n" if /^[0-9]+\.[0-9]+\.[0-9]+ (.*)\t/;' function-toc.txt | sort
> This doesn't include the operators (+, -, etc.).
> 
> There are 7 functions that start with "LEGACY.":
> LEGACY.CHIDIST
> LEGACY.CHIINV
> LEGACY.CHITEST
> LEGACY.FDIST
> LEGACY.FINV
> LEGACY.NORMSDIST
> LEGACY.NORMSINV
> 
> However, though we have definitions for FDIST and FINV,
> we do NOT have corresponding definitions for
> CHIDIST, CHIINV, CHITEST, NORMSDIST, and NORMSINV.
> It seems very odd to have "legacy" definitions without
> "non-legacy" definitions.  Any suggestions on how to deal with
> this in a better way?

Excel's NORMSDIST is essentially NORMDIST with the second and third
argument of NORMDIST set to 0 and 1. It would make much more sense to
have them optional. (There is the problem wit the fourth argument that
picks cumulative vs density.)

Similarly for NORMSINV and NORMINV.

CHITEST really doesn't make any mathematical sense.

the non-legacy version of CHIDIST is CHISQDIST. CHIDIST uses the
Chi-Square distribution plus gives the right tail probability, this
conflicts with the otehr DIST functions that give cumulative (left-tail)
or density values.

Andreas

> 
> The LEGACY.* functions are one of the few remaining items
> on the to-do list, now that we have a way of handling
> the 'basis' values.
> 
> --- David A. Wheeler
> 
> *** List of Functions ***
> 
> ABS
> ACCRINT
> ACCRINTM
> ACOS
> ACOSH
> ACOT
> ACOTH
> ADDRESS
> AMORDEGRC
> AMORLINC
> AND
> ARABIC
> AREAS
> ASC
> ASIN
> ASINH
> ATAN
> ATAN2
> ATANH
> AVEDEV
> AVERAGE
> AVERAGEA
> B
> BASE
> BESSELI
> BESSELJ
> BESSELK
> BESSELY
> BETADIST
> BETAINV
> BIN2DEC
> BIN2HEX
> BIN2OCT
> BINOMDIST
> BITAND
> BITLSHIFT
> BITOR
> BITRSHIFT
> BITXOR
> CEILING
> CELL
> CHAR
> CHISQDIST
> CHISQINV
> CHOOSE
> CLEAN
> CODE
> COLUMN
> COLUMNS
> COMBIN
> COMBINA
> COMPLEX
> CONCATENATE
> CONFIDENCE
> CONVERT
> CORREL
> COS
> COSH
> COT
> COTH
> COUNT
> COUNTA
> COUNTBLANK
> COUNTIF
> COUPDAYBS
> COUPDAYS
> COUPDAYSNC
> COUPNCD
> COUPNUM
> COUPPCD
> COVAR
> CRITBINOM
> CUMIPMT
> CUMPRINC
> DATE
> DATEDIF
> DATEVALUE
> DAVERAGE
> DAY
> DAYS
> DAYS360
> DB
> DCOUNT
> DCOUNTA
> DDB
> DDE
> DEC2BIN
> DEC2HEX
> DEC2OCT
> DECIMAL
> DEGREES
> DELTA
> DEVSQ
> DGET
> DISC
> DMAX
> DMIN
> DOLLAR
> DOLLARDE
> DOLLARFR
> DPRODUCT
> DSTDEV
> DSTDEVP
> DSUM
> DURATION
> DVAR
> DVARP
> EDATE
> EFFECT
> EOMONTH
> ERF
> ERFC
> ERROR.TYPE
> EUROCONVERT
> EVEN
> EXACT
> EXP
> EXPONDIST
> FACT
> FACTDOUBLE
> FALSE
> FDIST
> FIND
> FINDB
> FINV
> FISHER
> FISHERINV
> FIXED
> FLOOR
> FORECAST
> FORMULA
> FREQUENCY
> FTEST
> FV
> FVSCHEDULE
> GAMMA
> GAMMADIST
> GAMMAINV
> GAMMALN
> GAUSS
> GCD
> GEOMEAN
> GESTEP
> GETPIVOTDATA
> GROWTH
> HARMEAN
> HEX2BIN
> HEX2DEC
> HEX2OCT
> HLOOKUP
> HOUR
> HYPERLINK
> HYPGEOMDIST
> IF
> IFERROR
> IFNA
> IMABS
> IMAGINARY
> IMARGUMENT
> IMCONJUGATE
> IMCOS
> IMDIV
> IMEXP
> IMLN
> IMLOG10
> IMLOG2
> IMPOWER
> IMPRODUCT
> IMREAL
> IMSIN
> IMSQRT
> IMSUB
> IMSUM
> INDEX
> INDIRECT
> INFO
> INT
> INTERCEPT
> INTRATE
> IPMT
> IRR
> ISBLANK
> ISERR
> ISERROR
> ISEVEN
> ISFORMULA
> ISLOGICAL
> ISNA
> ISNONTEXT
> ISNUMBER
> ISODD
> ISOWEEKNUM
> ISPMT
> ISREF
> ISTEXT
> JIS
> KURT
> LARGE
> LCM
> LEFT
> LEFTB
> LEGACY.CHIDIST
> LEGACY.CHIINV
> LEGACY.CHITEST
> LEGACY.FDIST
> LEGACY.FINV
> LEGACY.NORMSDIST
> LEGACY.NORMSINV
> LEN
> LENB
> LINEST
> LN
> LOG
> LOG10
> LOGEST
> LOGINV
> LOGNORMDIST
> LOOKUP
> LOWER
> MATCH
> MAX
> MAXA
> MDETERM
> MDURATION
> MEDIAN
> MID
> MIDB
> MIN
> MINA
> MINUTE
> MINVERSE
> MIRR
> MMULT
> MOD
> MODE
> MONTH
> MROUND
> MULTINOMIAL
> MULTIPLE.OPERATIONS
> MUNIT
> N
> NA
> NEGBINOMDIST
> NETWORKDAYS
> NOMINAL
> NORMDIST
> NORMINV
> NOT
> NOW
> NPER
> NPV
> NUMBERVALUE
> OCT2BIN
> OCT2DEC
> OCT2HEX
> ODD
> ODDFPRICE
> ODDFYIELD
> ODDLPRICE
> ODDLYIELD
> OFFSET
> OR
> PDURATION
> PEARSON
> PERCENTILE
> PERCENTRANK
> PERMUT
> PERMUTATIONA
> PHI
> PI
> PMT
> POISSON
> POWER
> PPMT
> PRICE
> PRICEDISC
> PRICEMAT
> PROB
> PRODUCT
> PROPER
> PV
> QUARTILE
> QUOTIENT
> RADIANS
> RAND
> RANDBETWEEN
> RANK
> RATE
> RECEIVED
> REPLACE
> REPLACEB
> REPT
> RIGHT
> RIGHTB
> ROMAN
> ROUND
> ROUNDDOWN
> ROUNDUP
> ROW
> ROWS
> RRI
> RSQ
> SEARCH
> SEARCHB
> SECOND
> SERIESSUM
> SHEET
> SHEETS
> SIGN
> SIN
> SINH
> SKEW
> SKEWP
> SLN
> SLOPE
> SMALL
> SQRT
> SQRTPI
> STANDARDIZE
> STDEV
> STDEVA
> STDEVP
> STDEVPA
> STEYX
> SUBSTITUTE
> SUBTOTAL
> SUM
> SUMIF
> SUMPRODUCT
> SUMSQ
> SUMX2MY2
> SUMX2PY2
> SUMXMY2
> SYD
> T
> TAN
> TANH
> TBILLEQ
> TBILLPRICE
> TBILLYIELD
> TDIST
> TEXT
> TIME
> TIMEVALUE
> TINV
> TODAY
> TRANSPOSE
> TREND
> TRIM
> TRIMMEAN
> TRUE
> TRUNC
> TTEST
> TYPE
> UNICHAR
> UNICODE
> UPPER
> VALUE
> VAR
> VARA
> VARP
> VARPA
> VDB
> VLOOKUP
> WEEKDAY
> WEEKNUM
> WEIBULL
> WORKDAY
> XIRR
> XNPV
> XOR
> YEAR
> YEARFRAC
> YIELD
> YIELDDISC
> YIELDMAT
> ZTEST
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe from this mail list, you must leave the OASIS TC that
> generates this mail.  You may a link to this group and all your TCs in OASIS
> at:
> https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php 
> 
-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau

Andreas J. Guelzow
Pyrenean Shepherds
-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau


Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta