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
Graphs and Charts
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
Copyright © 1995 Applied Information Systems, Inc.
Last Revised: 30 April 1995