

XESS
Selected Features
The XESS Environment
- Standard Motif Graphical User Interface
- Main menu bar with pulldown sub-menus
- Industry-standard spreadsheet orientation
- Mouse or keyboard actions
- Maximum 4,096 columns and 32,767 rows
- Multiple spreadsheets can be active simultaneously
- Copy and paste between active spreadsheets and with other applications
- Cells/ranges referenced by address or name
- Undo previous operation
- Spreadsheets stored as text for easy mailing
Formatting the Display
- Full WYSIWYG user interface
- User-selectable colors for foreground/background, highlight, titles, etc.
- User-selectable cell formats (hex, dollars, etc.)
- User-selectable type fonts, sizes, and styles
- International character support
- Cells aligned left, right or center
- Multi-line text with word wrap
- Best-fit column and row sizes
- Simplified date entry
Data Manipulation
- Copy/move formulas or values to other spreadsheets maintaining formulas
and formats
- Search by textual, numeric, or Boolean expressions
- Sort in ascending or descending order maintaining all cell dependencies
- Goal-seeking
XESS Calculations
- Unique high-performance calculation engine
- Arithmetic, conditional, Boolean operations
- C language or standard spreadsheet operators
- Double-precision calculation
- Iterative calculations
- Cell linking between sheets
- Formula constraint checking
Mathematical Functions
- Sum, product, absolute value
- Logarithm with base 10, base 2, base e
- Square root, square root of a sum of squares
- Uniform and Gaussian random numbers
- Nth degree polynomial
- Sigmoid function
- Gamma and log gamma functions
- Visual sum
- Interpolation
- Matrix determinant and dot product
- Exponential function
- Trig and Hyperbolic trig functions
Financial Functions
- Extensive financial functions
- Depreciations
- Present and future values
- Investment, annuity, and security functions
- Treasury bills and various coupons
- Interest rates and internal rates of return
- Yield calculations
- Specialized date calculations
Statistical Functions
- Maximum, minimum, median, sum
- Standard deviation of population or sample
- Variance of a population or sample
- T and F distributions
- Paired and unpaired t tests
- Sum and mean of squares
- Geometric and harmonic means
- Correlations and multiple regressions
- Conditional statistical functions
Embedded Tools
- Matrix multiply and inverse
- Eigenvalues
- Fourier transforms and inverses
- Linear equation solving
- Correlation matrices
- Curve fitting
String Functions
- Complete suite of functions for string
manipulation and conversions including regular expressions
Other Functions
- Date and time functions
- Indirect cell reference functions
- Table look-ups
- External alarms and controls
- Logic and digital logic functions
- Plus many more
- Surface, scatter, line, pie, X-Y, high-low,
contour, polar, histogram, and bar graphs
- Multiple graphs in independent windows or on sheet with data
- Automatic updating when data changes
- Multiple data ranges
- Dynamic graph annotation
- 3D graph rotation
- Graph shading and coloring
- PostScript (EPS) output with color
Back to AIS Home Page
Copyright © 1995 Applied Information Systems, Inc.
Last Revised: 30 April 1995