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 built-in functions, a built-in 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
- Password-protection 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
- Date-Time
- 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 |
- Password-protection (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
- Date-time math
- Absolute and relative cell copies
- Create cell comments
- Auto-save
|
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 built-in 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 multi-value 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 |
- Twenty-six Summary Statistics functions.
- Six Distribution functions including: chi-square (and inverse), standard normal probability distribution (and inverse), and Student t-distribution (and inverse).
- Twelve Simple Linear Regression routines including: 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.
- 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.
- Twenty-one Coordinate Geometry functions.
- Six Road Design functions.
- Seven Graphics functions.
|
Script
Functions |
- Five File Management functions.
- Twenty-three Worksheet Interface functions.
- Three Error Handling functions.
|
|