Next: List of Figures
Up: SpreadScript 1.2 User's Guide
Previous: SpreadScript 1.2 User's Guide
Index
- List of Figures
- List of Tables
- 1. Introducing SpreadScript
- 2. Getting Started with SpreadScript
- 3. Calculations
- 4. Built-in Functions
- A. Function Reference
- @
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ALARM
- AND, XLAND
- ANNOTATE
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVG, AVERAGE
- CAVG
- CCOUNT
- CEIL, CEILING, XLCEILING
- CELLREF
- CHAR
- CHOOSE, XLCHOOSE
- CLEAN
- CMAX
- CMIN
- CODE
- COL, COLUMN
- COLS, COLUMNS
- CONCATENATE, STRCAT
- CONFIDENCE
- CORR, CORREL
- COS
- COSH
- COUNT
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CSTD
- CSTDS
- CSUM
- CTERM
- CUMIPMT
- CUMPRINC
- CVAR
- CVARS
- DATE
- DATEVALUE
- DAY
- DAYS360
- DB
- DDB
- DEGREES
- DET
- DFT
- DISC
- DOLLARDE
- DOLLARFR
- DOT
- DURATION
- EDATE
- EFFECT
- EIGEN
- EOMONTH
- ERF
- ERFC
- EXACT
- EXP
- F
- FACT
- FALSE
- FFT
- FILEEXISTS
- FIND
- FLOOR, XLFLOOR
- FORECAST
- FORMAT
- FRAC
- FREQUENCY
- FTEST
- FV
- FVSCHEDULE
- GAMMA
- GMEAN, GEOMEAN
- GRAND
- HEXTONUM
- HLOOKUP, XLHLOOKUP
- HMEAN, HARMEAN
- HOUR
- IF
- INIT
- INT, XLINT
- INTERP2D
- INTERP3D
- INTRATE
- INVDFT
- INVERT
- INVFFT
- IPMT, XLIPMT
- IRR
- ISERR, ISERROR
- ISNUMBER
- ISSTRING, ISTEXT
- LARGE
- LEFT
- LENGTH, LEN
- LINCOEF
- LINFIT
- LLS
- LN
- LNGAMMA
- LOG
- LOG10
- LOG2
- LOWER
- MATCH
- MAX
- MDURATION
- MEDIAN
- MESSAGE
- MID, XLMID
- MIN
- MINUTE
- MIRR
- MMUL
- MOD
- MODE
- MODULUS, XLMOD
- MONTH
- MSQ
- N
- NA
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NAND
- NETWORKDAYS
- NOMINAL
- NOR
- NOT, XLNOT
- NOW
- NPV
- NUMTOHEX
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OR, XLOR
- PERCENTILE
- PERCENTRANK
- PERMUT
- PI
- PLS
- PMT
- POLY
- POLYCOEF
- POLYFIT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PRODUCT
- PROPER
- PTTEST
- PV
- QUARTILE
- RADIANS
- RAND
- RANGEREF
- RANK
- RATE
- RECEIVED
- REGEX
- REPEAT, REPT
- REPLACE, XLREPLACE
- RIGHT
- RMS
- ROUND
- ROW
- ROWS
- S
- SALARM
- SECOND
- SIGMOID
- SIN
- SINH
- SLN
- SMALL
- SQRT
- SSE
- SSQ
- STANDARDIZE
- STD, STDEVP
- STDS, STDEV
- STRING
- STRLEN
- SUM
- SUMPRODUCT
- SYD
- T
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TERM
- TIME
- TIMEVALUE
- TODAY
- TRANSPOSE
- TREND
- TRIM
- TRUE
- TRUNC
- TTEST
- TTEST2EV
- TTEST2UV
- UPPER
- VALUE
- VAR, VARP
- VARS, XLVAR
- VDB
- VECLEN
- VLOOKUP, XLVLOOKUP
- VSUM
- WEEKDAY
- WORKDAY
- XIRR
- XNPV
- XOR
- XVALUE
- YEAR
- YEARFRAC
- YIELD
- YIELDDISC
- YIELDMAT
- ZTEST
- B. Perl API
- C. Python API
- D. Tcl API
- Index
- About this document ...
Next: List of Figures
Up: SpreadScript 1.2 User's Guide
Previous: SpreadScript 1.2 User's Guide
Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003