Abykus - Features page

(1) Runs of Vista an Linux (using Wine)
The Windows Help program is not implemented on either Vista or Linux. As a result, the .hlp files cannot be accessed. If you are running Vista, you can get around this problem by downloading the WinHlp32.exe installer from the Microsoft Download Center. There is no work around for Linux, except to print out the User's Guide.
[back to features]

(2) Dynamic cell addressing
Because the row, column, array element and worksheet level fields can be replaced with any type of expression, their values may vary as changes are made to the worksheet (changing the actual cell being addressed). This is called indirect cell addressing and can be quite useful at times.
[back to features]

(3) Cell arrays
Arrays are one of Abykus’ most powerful features. They allow large amounts of data (upto 8191 values) to be stored and accessed from a single cell. This not only saves valuable worksheet space, but it also significantly reduces the overhead needed to manage the data. An array area can be assigned to any formula cell. Individual array elements are accessed by including the optional array element field in the cell address. (If not used in the cell address, this field defaults to zero).
[back to features]

(4) Cell objects
Abykus is an object-oriented spreadsheet. Rather than limiting what can be stored in a cell to a single value or formula, Abykus allows cell objects to be stored in any cell on a worksheet. Cell objects represent multi-value data types (such as matrixes, tables, coordinates, profiles, etc.) that are treated as a single entity by the spreadsheet.
[back to features]

(5) Capture and Place cell object commands
The Capture command is used to load the capture buffer with: 1) the values associated with an existing cell object; or 2) the values associated with a group of cells selected on the worksheet. Once loaded, the Place command is used to copy the contents of the capture buffer to: 1) an empty cell; or 2) to a region of the worksheet.
[back to features]

(6) Stat Wizard
The Stat Wizard is designed to load a master table from a variety of sources (i.e. files, regions of the worksheet, or existing table objects). Once loaded, the columns of the master table form a pool of variables that can be used in any combination to define a working table. Once the working table has been defined, it can be displayed, statistically analyzed or saved to an empty cell in the form of a table object.
[back to features]

(7) Table manipulation options
The Table manipulation options can be used to quickly sort, invert, swap, or remove the rows and columns of a Table object.
[back to features]

(8) Imports DAT, MTP files
The Stat Wizard can capture table data from files using the following formats: 1) Comma delimited table (*.csv); 2) Blank delimited table (*.dat); 3) Tab delimited table (*.tab); and 4) MiniTab data format (*.mtp).
[back to features]

(9) 26 Summary Statistics functions
Summary functions include: kurtosis, t-interval, minimum, maximum, mean, harmonic mean, trimmed mean, median, first quartile, third quartile, standard error of the means, skew, standard deviation, sum, number of items, sum of the products, sum the products of the deviations, sum of the squares, sum of the squared deviations, variance, confidence interval for the mean, confidence interval for the median, confidence interval for the standard deviation.
[back to features]

(10) 6 Distribution functions
Distribution functions include: chi-square (and inverse), standard normal probability distribution (and inverse), and Student t-distribution (and inverse).
[back to features]

(11) 12 Regression Analysis functions
Simple Linear Regression routines include: coefficient of linear correlation, covariance, y-intercept, coefficient of simple determination (‘r-squared’), slope of a simple regression, standard error of the estimate, p-value of the intercept, p-value of the slope, standard error of the intercept, standard error of the slope, t-test statistic for the intercept, t-statistic for the slope,
[back to features]

(12) 7 Analysis of Variance (ANOVA) functions
Analysis of Variance (ANOVA) functions include: sum of the squares due to regression, sum of squared errors, total sum of squares for Y, mean square due to regression, mean square due to error, mean square for Y, and F test statistic.
[back to features]

(13) External script libraries
Scripts are not stored in the worksheets that access them, as is the case with macros. Instead, scripts reside in external library files, which must be attached to the spreadsheet before they can be used. This provides two advantages. First, it provides a single point of access. That is, once a script library has been attached to the spreadsheet, any worksheet can access the scripts it contains. Secondly, it simplifies maintenance by limiting changes to the script library, which (when re-attached) affects all worksheets that access it.
[back to features]

(14) Over 30 Toolkit (script) functions
Scripts can access any of the built-in functions used to create a formula cell. In addition to built-in functions, scripts can also access a special set of toolkit functions. Toolkit functions provide a low level interface to the spreadsheet and are grouped into the following four categories: 1) windows functions; 2) file handling functions; 3) spreadsheet functions; and 4) error handling functions.
[back to features]