XessLite is a full-featured subset of the Xess spreadsheet. The differences between XessLite and the `full' version of Xess are as follows:
+-----------+------------+-------------+
| | XessLite | Xess |
+-----------+------------+-------------+
| Rows | 16,383 | 9,999,999 |
+-----------+------------+-------------+
| Columns | 1,024 | 4,096 |
+-----------+------------+-------------+
| Sheets | 3 | 4,095 |
+-----------+------------+-------------+
@ACCRINT - accrued interest for a security with periodic interest
@ACCRINTM - accrued interest for a security with interest at maturity
@COUPDAYBS - days between beginning of coupon period and settlement date
@COUPDAYS - days in coupon period that settlement date is in
@COUPDAYSNC - days between settlement date and next coupon date
@COUPNCD - next coupon date after settlement date
@COUPNUM - num of coupon payments between settlement date and maturity
@COUPPCD - most recent coupon date before settlement date
@CUMIPMT - cumulative interest paid between start and end of a loan
@CUMPRINC - cumulative principal paid between start and end of a loan
@DB - fixed-declining real depreciation of an asset
@DISC - discount rate of a security
@DOLLARDE - convert a dollar fraction to dollar decimal
@DOLLARFR - convert a dollar decimal to dollar fraction
@DURATION - Macauley duration for an assumed par value of $100
@EFFECT - effective annual interest rate
@FVSCHEDULE - future value of initial principal
@INTRATE - interest rate for a fully invested investment
@IPMT - interest payment for a specified period
@MDURATION - modified Macauley duration for an assumed face value of $100
@MIRR - modified internal return rate for periodic cash flows
@NOMINAL - nominal annual interest rate
@ODDFPRICE - price of a security with odd first period
@ODDFYIELD - yield of a security with odd first period
@ODDLPRICE - price of a security with odd last period
@ODDLYIELD - yield of a security with odd last period
@PPMT - principal payment for a specified period
@PRICE - price of a security with periodic interest
@PRICEDISC - price of a discounted security
@PRICEMAT - price of a security that pays interest at maturity
@RECEIVED - value at maturity of a fully invested security
@TBILLEQ - bond-yield equivalent for a treasury bill equivalent to a bond
@TBILLPRICE - price for a treasury bill
@TBILLYIELD - yield on a treasury bill
@VDB - depreciation of an asset using fixed-declining balance
@XIRR - internal rate of return for a series of cash flows
@XNPV - net present value for a series of cash flows
@YIELD - yield at maturity of a security with periodic interest
@YIELDDISC - annual yield for a discounted security
@YIELDMAT - annual yield for a security that pays interest at maturity
For more information about the Xess spreadsheet please consult AIS's website