Current grouping, list of functions - reasonable start?

["David A. Wheeler" <dwheeler@dwheeler.com>]

Here is the current grouping and list of functions.
Any changes/proposals?  For example, would it help
to move all the rounding functions (ROUND, INT, ROUNDUP, etc.)
to a separate group?  Would it be helpful to pull out the trig functions?

I intentionally did my own grouping, rather than just copying any
implementation's, because that way I avoid any copyright issues.
Some groups are so standard (text, financial, database) that I'm
not worried about anyone trying to make a federal case out of it :-).
The "number conversion" routines seem to be slipping into many
different applications, and to me it made more sense to identify
them as a separate group.

--- David A. Wheeler

============================================

6 Standard Operators and Functions
6.1 Common Template for Functions and Operators

6.2 Implicit Conversion Operators
6.2.1 Conversion to Scalar
6.2.2 Implied intersection
6.2.3 Conversion to Number
6.2.4 Conversion to NumberSequence
6.2.5 Conversion to Complex Number
6.2.6 Conversion to Logical
6.2.7 Conversion to Text

6.3 Standard Operators
6.3.1 Infix Operator "+"
6.3.2 Infix Operator "-"
6.3.3 Infix Operator "*"
6.3.4 Infix Operator "/"
6.3.5 Infix Operator "^"
6.3.6 Infix Operator "="
6.3.7 Infix Operator "<>"
6.3.8 Infix Operator Ordered Comparison ("<", "<=", ">", ">=")
6.3.9 Infix Operator Range (":")
6.3.10 Infix Operator "&"
6.3.11 Infix Operator Intersection ("!")
6.3.12 Infix Operator Union ("~")
6.3.13 Postfix Operator "%"
6.3.14 Prefix Operator "+"
6.3.15 Prefix Operator "-"

6.4 Array/matrix Functions
6.4.1 MDETERM
6.4.2 MINVERSE
6.4.3 MMULT
6.4.4 MUNIT
6.4.5 SUMPRODUCT
6.4.6 SUMX2MY2
6.4.7 SUMX2PY2
6.4.8 SUMXMY2
6.4.9 TRANSPOSE

6.5 Byte-position text functions
6.5.1 FINDB
6.5.2 LEFTB
6.5.3 LENB
6.5.4 MIDB
6.5.5 REPLACEB
6.5.6 RIGHTB
6.5.7 SEARCHB

6.6 Complex Number Functions
6.6.1 COMPLEX
6.6.2 IMABS
6.6.3 IMAGINARY
6.6.4 IMARGUMENT
6.6.5 IMCONJUGATE
6.6.6 IMCOS
6.6.7 IMDIV
6.6.8 IMEXP
6.6.9 IMLN
6.6.10 IMLOG10
6.6.11 IMLOG2
6.6.12 IMPOWER
6.6.13 IMREAL
6.6.14 IMSIN
6.6.15 IMSQRT
6.6.16 IMSUB

6.7 Database Functions
6.7.1 DAVERAGE
6.7.2 DCOUNT
6.7.3 DCOUNTA
6.7.4 DGET
6.7.5 DMAX
6.7.6 DMIN
6.7.7 DPRODUCT
6.7.8 DSTDEV
6.7.9 DSTDEVP
6.7.10 DSUM
6.7.11 DVAR
6.7.12 DVARP

6.8 Date and Time Functions
6.8.1 DATE
6.8.2 DATEDIF
6.8.3 DATESTRING
6.8.4 DATEVALUE
6.8.5 DAY
6.8.6 DAYS360
6.8.7 EDATE
6.8.8 EOMONTH
6.8.9 HOUR
6.8.10 MINUTE
6.8.11 MONTH
6.8.12 NETWORKDAYS
6.8.13 NOW
6.8.14 SECOND
6.8.15 TIME
6.8.16 TIMEVALUE
6.8.17 TODAY
6.8.18 WEEKDAY
6.8.19 WEEKNUM
6.8.20 WORKDAY
6.8.21 YEAR
6.8.22 YEARFRAC

6.9 External Access Functions
6.9.1 HYPERLINK
6.9.2 RTD

6.10 Financial Functions
6.10.1 ACCRINT
6.10.2 ACCRINTM
6.10.3 AMORDEGRC
6.10.4 AMORLINC
6.10.5 COUPDAYBS
6.10.6 COUPDAYS
6.10.7 COUPDAYSNC
6.10.8 COUPNCD
6.10.9 COUPNUM
6.10.10 COUPPCD
6.10.11 CUMIPMT
6.10.12 CUMPRINC
6.10.13 DB
6.10.14 DDB
6.10.15 DISC
6.10.16 DOLLARDE
6.10.17 DOLLARFR
6.10.18 DURATION
6.10.19 EFFECT
6.10.20 EFFECTIVE
6.10.21 FV
6.10.22 FVSCHEDULE
6.10.23 INTRATE
6.10.24 IPMT
6.10.25 IRR
6.10.26 ISPMT
6.10.27 MDURATION
6.10.28 MIRR
6.10.29 NOMINAL
6.10.30 NPER
6.10.31 NPV
6.10.32 ODDFPRICE
6.10.33 ODDFYIELD
6.10.34 ODDLPRICE
6.10.35 ODDLYIELD
6.10.36 PMT
6.10.37 PPMT
6.10.38 PRICE
6.10.39 PRICEDISC
6.10.40 PRICEMAT
6.10.41 PV
6.10.42 RATE
6.10.43 RECEIVED
6.10.44 RRI
6.10.45 SLN
6.10.46 SYD
6.10.47 TBILLEQ
6.10.48 TBILLPRICE
6.10.49 TBILLYIELD
6.10.50 VDB
6.10.51 XIRR
6.10.52 XNPV
6.10.53 YIELD
6.10.54 YIELDDISC
6.10.55 YIELDMAT

6.11 Information Functions
6.11.1 AREAS
6.11.2 CELL
6.11.3 COLUMN
6.11.4 COLUMNS
6.11.5 COUNT
6.11.6 COUNTA
6.11.7 COUNTBLANK
6.11.8 COUNTIF
6.11.9 CURRENT
6.11.10 ERROR.TYPE
6.11.11 FORMULA
6.11.12 INFO
6.11.13 ISBLANK
6.11.14 ISERR
6.11.15 ISERROR
6.11.16 ISEVEN
6.11.17 ISFORMULA
6.11.18 ISLOGICAL
6.11.19 ISNONTEXT
6.11.20 ISNA
6.11.21 ISLOGICAL
6.11.22 ISNUMBER
6.11.23 ISODD
6.11.24 ISTEXT
6.11.25 NA
6.11.26 ISREF
6.11.27 N
6.11.28 NA
6.11.29 ROW
6.11.30 ROWS
6.11.31 SHEET
6.11.32 TYPE
6.11.33 VALUE
6.11.34 VALUEL

6.12 Lookup Functions
6.12.1 ADDRESS
6.12.2 CHOOSE
6.12.3 GETPIVOTDATA
6.12.4 HLOOKUP
6.12.5 INDEX
6.12.6 INDIRECT
6.12.7 LOOKUP
6.12.8 MATCH
6.12.9 OFFSET
6.12.10 VLOOKUP

6.13 Logical Functions
6.13.1 AND
6.13.2 FALSE
6.13.3 IF
6.13.4 NOT
6.13.5 OR
6.13.6 TRUE

6.14 Mathematical Functions
6.14.1 ABS
6.14.2 ACOS
6.14.3 ACOSH
6.14.4 ACOT
6.14.5 ACOTH
6.14.6 ASIN
6.14.7 ASINH
6.14.8 ATAN
6.14.9 ATAN2
6.14.10 ATANH
6.14.11 AVERAGE
6.14.12 BESSELI
6.14.13 BESSELJ
6.14.14 BESSELK
6.14.15 BESSELY
6.14.16 COMBINA
6.14.17 CONVERT
6.14.18 CEILING
6.14.19 COMBIN
6.14.20 COS
6.14.21 COSH
6.14.22 COT
6.14.23 COTH
6.14.24 DEGREES
6.14.25 DELTA
6.14.26 ERF
6.14.27 ERFC
6.14.28 EVEN
6.14.29 EXP
6.14.30 FACT
6.14.31 FACTDOUBLE
6.14.32 FLOOR
6.14.33 GAMMA
6.14.34 GCD
6.14.35 GESTEP
6.14.36 INT
6.14.37 LCM
6.14.38 LN
6.14.39 LOG
6.14.40 LOG10
6.14.41 MAX
6.14.42 MAXA
6.14.43 MIN
6.14.44 MINA
6.14.45 MOD
6.14.46 MROUND
6.14.47 MULTINOMIAL
6.14.48 ODD
6.14.49 PI
6.14.50 POWER
6.14.51 PRODUCT
6.14.52 QUOTIENT
6.14.53 RADIANS
6.14.54 RAND
6.14.55 RANDBETWEEN
6.14.56 ROUND
6.14.57 ROUNDDOWN
6.14.58 ROUNDUP
6.14.59 SERIESSUM
6.14.60 SIGN
6.14.61 SIN
6.14.62 SINH
6.14.63 SQRT
6.14.64 SQRTPI
6.14.65 SUBTOTAL
6.14.66 SUM
6.14.67 SUMIF
6.14.68 SUMSQ
6.14.69 TAN
6.14.70 TANH
6.14.71 TRUNC

6.15 Statistical Functions
6.15.1 AVEDEV
6.15.2 AVERAGEA
6.15.3 B
6.15.4 BETADIST
6.15.5 BETAINV
6.15.6 BINOMDIST
6.15.7 CHIDIST
6.15.8 CHIINV
6.15.9 CHITEST
6.15.10 CONFIDENCE
6.15.11 CORREL
6.15.12 COVAR
6.15.13 CRITBINOMIAL
6.15.14 DEVSQ
6.15.15 EXPONDIST
6.15.16 FDIST
6.15.17 FINV
6.15.18 FISHER
6.15.19 FISHERINV
6.15.20 FORECAST
6.15.21 FREQUENCY
6.15.22 FTEST
6.15.23 GAMMADIST
6.15.24 GAMMAINV
6.15.25 GAMMALN
6.15.26 GAUSS
6.15.27 GEOMEAN
6.15.28 GROWTH
6.15.29 HARMEAN
6.15.30 HYPGEOMDIST
6.15.31 HYPGEOMVERT
6.15.32 INTERCEPT
6.15.33 KURT
6.15.34 LARGE
6.15.35 LINEST
6.15.36 LOGEST
6.15.37 LOGINV
6.15.38 LOGNORMDIST
6.15.39 MEDIAN
6.15.40 MNORMSINV
6.15.41 MODE
6.15.42 NEGBINOMDIST
6.15.43 NORMDIST
6.15.44 NORMINV
6.15.45 NORMSDIST
6.15.46 NORMSINV
6.15.47 PEARSON
6.15.48 PERCENTILE
6.15.49 PERCENTRANK
6.15.50 PERMUT
6.15.51 PERMUTATIONA
6.15.52 PHI
6.15.53 POISSON
6.15.54 PROB
6.15.55 QUARTILE
6.15.56 RANK
6.15.57 RSQ
6.15.58 SKEW
6.15.59 SLOPE
6.15.60 SMALL
6.15.61 STANDARDIZE
6.15.62 STDEV
6.15.63 STDEVA
6.15.64 STDEVP
6.15.65 STDEVPA
6.15.66 STEYX
6.15.67 TDIST
6.15.68 TINV
6.15.69 TREND
6.15.70 TRIMMEAN
6.15.71 TTEST
6.15.72 VAR
6.15.73 VARA
6.15.74 VARP
6.15.75 VARPA
6.15.76 WEIBULL
6.15.77 ZTEST

6.16 Number Representation Conversion Functions
6.16.1 ARABIC
6.16.2 BAHTTEXT
6.16.3 BASE
6.16.4 BIN2DEC
6.16.5 BIN2HEX
6.16.6 BIN2OCT
6.16.7 DEC2BIN
6.16.8 DEC2HEX
6.16.9 DEC2OCT
6.16.10 DECIMAL
6.16.11 HEX2BIN
6.16.12 HEX2DEC
6.16.13 HEX2OCT
6.16.14 OCT2BIN
6.16.15 OCT2DEC
6.16.16 OCT2HEX
6.16.17 ROMAN

6.17 Text Functions
6.17.1 ASC
6.17.2 CHAR
6.17.3 CLEAN
6.17.4 CODE
6.17.5 CONCATENATE
6.17.6 DOLLAR
6.17.7 EXACT
6.17.8 FIND
6.17.9 FIXED
6.17.10 LEFT
6.17.11 LEN
6.17.12 LOWER
6.17.13 MID
6.17.14 NUMBERSTRING
6.17.15 PROPER
6.17.16 REPLACE
6.17.17 REPT
6.17.18 RIGHT
6.17.19 SEARCH
6.17.20 SUBSTITUTE
6.17.21 T
6.17.22 TEXT
6.17.23 TRIM
6.17.24 UPPER


--- David A. Wheeler