Return to Home page        features page

 Home   Screenshots   Downloads   Contact 

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.

Version 3.0

  1. Quick Reference Guide
  2. Save all worksheets to a single AB3 workbook File
  3. Password-protection for Worksheets and Files
  4. Faster Recalculation Engine

  1. Microsoft Windows: 95/98/ME/NT/2000/XP/Vista [1]
  2. Linux (using Wine)

  1. 65534 rows
  2. 255 columns
  3. 32 worksheets

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

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

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

  1. Password-protection (for worksheets and files)
  2. Hide / Unhide a cell
  3. Protect / Unprotect a cell
  4. Recalculate a cell (nornal, force, prevent)

  1. Sort and search operations
  2. Sum a range of cells
  3. Formula editor
  4. Formula debugger
  5. Date-time math
  6. Absolute and relative cell copies
  7. Create cell comments
  8. Auto-save

  1. Arithmetic: + - * / % **
  2. Unary: + - !
  3. Relational: == != <= >= < >
  4. Logical: && ||
  5. Assignment: = += -= *= /= %= &= |=
  6. Ternay (conditional): ?:
  7. Bitwise: & |

  1. Nine String functions
  2. Eleven Math functions
  3. Twelvel Trig functions
  4. Six Financial functions
  5. Eight Date functions
  6. Seven Time functions

  1. AB2 (*.ab2) - native worksheet
  2. AB3 (*.ab3) - native workbook
  3. TXT (*.txt) - text files
  4. CSV (*.csv) - comma separated values
  5. DIF (*.dif) - data interchange format
  6. TAB (*.tab) - tab delimited table
  7. DAT (*.dat) - blank delimited table
  8. 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.
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.

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.

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.

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

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.

  1. Twenty-six Summary Statistics functions.
  2. Six Distribution functions including: chi-square (and inverse), standard normal probability distribution (and inverse), and Student t-distribution (and inverse).
  3. 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.
  4. 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.
  1. Twelve Matrix Algebra functions.
  2. Twenty-one Coordinate Geometry functions.
  3. Six Road Design functions.
  4. Seven Graphics functions.
  1. Five File Management functions.
  2. Twenty-three Worksheet Interface functions.
  3. Three Error Handling functions.

Note:  Microsoft did not include the WinHlp32 help program with the most recent release of Vista. The WinHlp32 program is used to display the (.hlp) Help files used by thousands of programs that continue to be backward compatible to Window 95. Abykus is one of these programs. As a result, if you're running Vista, you will have to download the WinHlp32.exe installer from the Microsoft Download Center before you can view the help file included with Abykus.  

[back to features]

Home | Screenshots | Download | Contact

Copyright © 2015 - Bradford L. Smith - All rights reserved.