Next: Contents
Contents
Index
SpreadScript User's Guide
and Reference Manual
Version 1.2
GreyTrout Software
Copyright © 2003, GreyTrout Software, Inc., and others.
All rights reserved.
The information contained within this document is subject to change
without notice.
GREYTROUT SOFTWARE, INC., MAKES NO WARRANTY OF ANY KIND WITH REGARD
TO THIS MATERIAL, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
GreyTrout Software, Inc., shall not be liable for errors contained
herein or for incidental consequential damages in connection with
the furnishing, performance, or use of this material.
All rights are reserved. No part of this publication may be
photocopied, reproduced, or translated into another language
without the prior written consent of GreyTrout Software, Inc.
Permission is hereby granted to download a copy of this document from
http://www.greytrout.com
for your own personal use.
We gratefully acknowledge the use of LaTeX2HTML,
by Nikos Drakos and a host of others,
in the generation of this document.
- Contents
- 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: Contents
Contents
Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003