FarPoint Technologies, Inc.

Spread includes a powerful calculation engine that allows you to quickly add formulas to your web applications by using any of over 300 pre-defined functions or you can add your own custom functions. Spread also supports cross-sheet formula referencing.

In the below sample, formulas are in the 'Total Due' column and the last totals row. Enter or change a formula in a cell - "=SUM(A1:A3)" - then press the Update image link (the checkbox at the bottom left of Spread) to view your changes.

	Customer	Invoice	Total Due	Aged Receivables
	Customer	Invoice	Total Due	0-30	31-60	61+
1	Around the Horn	10365	$503.20	$503.20	$0.00	$0.00
2		10507	$1,648.50	$0.00	$0.00	$1,648.50
3		10535	$395.20	$0.00	$395.20	$0.00
4		10573	$542.50	$542.50	$0.00	$0.00
5			$3,089.40	$1,045.70	$395.20	$1,648.50

Following are the supported functions:

Date and Time Functions
DATE	DATEDIF	DATEVALUE	DAY
DAYS360	EDATE	EOMONTH	HOUR
MINUTE	MONTH	NETWORKDAYS	NOW
SECOND	TIME	TIMEVALUE	TODAY
WEEKDAY	WEEKNUM	WORKDAY	YEAR
YEARFRAC
Engineering Functions
BESSELI	BESSELJ	BESSELK	BESSELY
BIN2DEC	BIN2HEX	BIN2OCT	COMPLEX
CONVERT	DEC2BIN	DEC2HEX	DEC2OCT
DELTA	ERF	ERFC	GESTEP
HEX2BIN	HEX2DEC	HEX2OCT	IMABS
IMAGINARY	IMARGUMENT	IMCONJUGATE	IMCOS
IMDIV	IMEXP	IMLN	IMLOG10
IMLOG2	IMPOWER	IMPRODUCT	IMREAL
IMSIN	IMSQRT	IMSUB	IMSUM
OCT2BIN	OCT2DEC	OCT2HEX
Financial Functions
ACCRINT	ACCRINTM	AMORDEGRC	AMORLINC
COUPDAYS	COUPDAYBS	COUPDAYSNC	COUPNCD
COUPNUM	COUPPCD	CUMIPMT	CUMPRINC
DB	DDB	DISC	DOLLAR
DOLLARDE	DOLLARFR	DURATION	EFFECT
EURO	EUROCONVERT	FV	FVSCHEDULE
INTRATE	IPMT	IRR	ISPMT
MDURATION	MIRR	NOMINAL	NPER
NPV	ODDFPRICE	ODDFYIELD	ODDLPRICE
ODDLYIELD	PMT	PPMT	PRICE
PRICEDISC	PRICEMAT	PV	RATE
RECEIVED	SLN	SYD	TBILLEQ
TBILLPRICE	TBILLYIELD	VDB	XIRR
XNPV	YIELD	YIELDDISC	YIELDMAT
Information Functions
COUNTBLANK	ERRORTYPE	ISBLANK	ISERR
ISERROR	ISEVEN	ISLOGICAL	ISNA
ISNONTEXT	ISNUMBER	ISODD	ISREF
ISTEXT	N	NA	TYPE
Logical Functions
AND	FALSE	IF	NOT
OR	TRUE
Look Up Functions
ADDRESS	CHOOSE	COLUMNS	HLOOKUP
INDEX	LOOKUP	ROWS	TRANSPOSE
VLOOKUP
Math and Trigonometry Functions
ABS	ACOS	ACOSH	ASIN
ASINH	ATAN	ATAN2	ATANH
CEILING	COMBIN	COS	COSH
COUNTIF	DEGREES	EVEN	EXP
FACT	FACTDOUBLE	FLOOR	GCD
INT	LCM	LN	LOG
LOG10	MDETERM	MINVERSE	MMULT
MOD	MROUND	MULTINOMIAL	ODD
PI	POWER	PRODUCT	QUOTIENT
RADIANS	RAND	RANDBETWEEN	ROMAN
ROUND	ROUNDDOWN	ROUNDUP	SERIESSUM
SIGN	SIN	SINH	SQRT
SQRTPI	SUBTOTAL	SUM	SUMIF
SUMPRODUCT	SUMSQ	SUMX2MY2	SUMX2PY2
SUMXMY2	TAN	TANH	TRUNC
Statistical Functions
AVEDEV	AVERAGE	AVERAGEA	BETADIST
BETAINV	BINOMDIST	CHIDIST	CHIINV
CHITEST	CONFIDENCE	CORREL	COUNT
COUNTA	COVAR	CRITBINOM	DEVSQ
EXPONDIST	FDIST	FINV	FISHER
FISHERINV	FORECAST	FREQUENCY	FTEST
GAMMADIST	GAMMAINV	GAMMALN	GEOMEAN
GROWTH	HARMEAN	HYPGEOMDIST	INTERCEPT
KURT	LARGE	LINEST	LOGEST
LOGINV	LOGNORMDIST	MAX	MAXA
MEDIAN	MIN	MINA	MODE
NEGBINOMDIST	NORMDIST	NORMINV	NORMSDIST
NORMSINV	PEARSON	PERCENTILE	PERCENTRANK
PERMUT	POISSON	PROB	QUARTILE
RANK	RSQ	SKEW	SLOPE
SMALL	STANDARDIZE	STDEV	STDEVA
STDEVP	STDEVPA	STEYX	TDIST
TINV	TREND	TRIMMEAN	TTEST
VAR	VARA	VARP	VARPA
WEIBULL	ZTEST
Text Functions
CHAR	CLEAN	CODE	CONCATENATE
DOLLAR	EXACT	FIND	FIXED
LEFT	LEN	LOWER	MID
PROPER	REPLACE	REPT	RIGHT
SUBSTITUTE	T	TRIM	UPPER