Abykus.com
features page

Spreadsheet features for Abykus 3.0

Abykus 3.0 is a compact spreadsheet with a simple interface that allows up to 32 separate worksheets to be loaded at one time. It requires less than 3 megabytes to install, yet offers over 190 builtin functions, a builtin script language, and a full statistics package.

Standard Features 
Description 
NEW for
Version 3.0

 Quick Reference Guide
 Save all worksheets to a single AB3 workbook File
 Passwordprotection for Worksheets and Files
 Faster Recalculation Engine

OS 
 Microsoft Windows: 95/98/ME/NT/2000/XP/Vista ^{[1]}
 Linux (using Wine)

Grid 
 65534 rows
 255 columns
 32 worksheets

Cell Addresses 
Unlike other spreadsheets that use a confusing combination of letters and numbers to identify the position of cells on the worksheet (i.e. "AB27"), Abykus uses a "bracketed" cell address to reference other cells. The basic form of this new convention is nothing more than the target cell's row and column number enclosed within a set a square brackets (i.e. "[#, #]" ). The cell address has many useful extentions beyond this basic form..

Editing 
 Cut / Copy / Paste cells
 Insert / Delete rows and columns
 Merge cells
 Shift ranges of cells (up, down, left, right) with the click of a buuton

Formating 
 Font (name, size, color)
 Style (regular, bold, italic)
 Justify (left, center, right)
 Align (top, center, bottom)
 Numeric formats
 decimal
 comma
 currency
 percent
 scientific
 hex
 octal
 binary
 bearing
 station
 DateTime
 Date / Time: January 2, 1991 12:30 PM
 Date: January 1, 1993
 Date (yy/mm/dd): 1993/12/01
 Date (mm/dd/yy): 12/01/93
 Time: 12:30:15 PM
 Military time: 23:30:15
 Month: January, March,...
 Day of Week: Sunday,Monday,...

Security 
 Passwordprotection (for worksheets and files)
 Hide / Unhide a cell
 Protect / Unprotect a cell
 Recalculate a cell (nornal, force, prevent)

Tools 
 Sort and search operations
 Sum a range of cells
 Formula editor
 Formula debugger
 Datetime math
 Absolute and relative cell copies
 Create cell comments
 Autosave

Operators 
 Arithmetic: +  * / % **
 Unary: +  !
 Relational: == != <= >= < >
 Logical: && 
 Assignment: = += = *= /= %= &= =
 Ternay (conditional): ?:
 Bitwise: & 

Functions 
 Nine String functions
 Eleven Math functions
 Twelvel Trig functions
 Six Financial functions
 Eight Date functions
 Seven Time functions

Files 
 AB2 (*.ab2)  native worksheet
 AB3 (*.ab3)  native workbook
 TXT (*.txt)  text files
 CSV (*.csv)  comma separated values
 DIF (*.dif)  data interchange format
 TAB (*.tab)  tab delimited table
 DAT (*.dat)  blank delimited table
 MTP (*.mtp)  MiniTab table format

Despite it's compact size, Abykus has the horsepower to tackle even the most challenging tasks. Its ability to store "objects" in any cell, for example, gives the program a unique set of capabilities that simply can not be duplicated by other spreadsheets.

Advanced Features 
Description 
Statistics Wizard 
The Stat Wizard loads a table from a file, region of the worksheet, or from a table object. The table can then be displayed, statistically analyzed or saved to an empty cell in the form of a table object.

Script Language 
The Script Programming Language (SPL) used to write scripts is similar to the C programming language. It provides a predefined set of data types, operators, and control statements that allow you to write your own routines that look and behave like builtin functions.

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 simplifies maintenance.

Dynamic Cell addresses 
The numbers used to define the row and column fields of any cell address can be repalced by another cell address or an expression, which can change each time the cell is recalculated.

Range Operations 
Range Operations are an extension to the standard cell address. They defines a set of actions that are performed on each cell within a range.

Cell "arrays" 
An array area of up to 8191 values can be assigned to any formula cell, saving valuable worksheet space and reducing the overhead needed to manage the data.

Cell "objects" 
Cell objects are similar to cell arrays. They represent multivalue data types (such as matrixes, tables, coordinates, profiles, etc.) that are loaded in a single cell and treated as a single entity by the spreadsheet.

Draw cell objects 
Any cell that contains a graphics object (a chart, points, line, polygon) can be drawn by pressing a single button.

Capture & Place 
The "Capture" command is used to load the capture buffer with values associated with an existing cell object or 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 an empty cell or a region of the worksheet.

Statistics Functions 
 Twentysix Summary Statistics functions.
 Six Distribution functions including: chisquare (and inverse), standard normal probability distribution (and inverse), and Student tdistribution (and inverse).
 Twelve Simple Linear Regression routines including: coefficient of linear correlation, covariance, yintercept, coefficient of simple determination ('rsquared'), slope of a simple regression, standard error of the estimate, pvalue of the intercept, pvalue of the slope, standard error of the intercept, standard error of the slope, ttest statistic for the intercept, tstatistic for the slope.
 Seven Analysis of Variance (ANOVA) functions including: 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.

Design Functions 
 Twelve Matrix Algebra functions.
 Twentyone Coordinate Geometry functions.
 Six Road Design functions.
 Seven Graphics functions.

Script Functions 
 Five File Management functions.
 Twentythree Worksheet Interface functions.
 Three Error Handling functions.

