#	SID	@(#)oa.txt	3.2 - 95/11/10

SmartWare Plus - Module Descriptions

     The Database is a full-featured relational database
     management program that can be used in virtually any
     business, educational, or private environment where there is
     a need to record, manipulate, store, and retrieve data
     quickly and easily.

     The Spreadsheet is an electronic "accounting" worksheet
     designed to handle numbers, text, and formulas. Its formula
     calculation capabilities provide you with trigonometric,
     statistical, business, date and time functions, as well as
     matrix analysis capabilities. Once you have created a
     worksheet, you can use SmartWare's Graphics to present
     results in a variety of graphs.

     The Word Processor is a sophisticated word processing
     program that includes a spellchecker and a thesaurus.

     The Communications module is a complete communications
     program that performs two primary functions: terminal
     emulation and file transfer. The module can perform
     sophisticated, automatic, unattended communications jobs.
     This module is primarily aimed at DOS users.

          Each SmartWare module uses its own data structure. This
          allows the module to optimize the operations it
          performs. In order to integrate the different data
          structures, each module has the ability to translate
          data into one or more formats that can be used by any
          other module. Additionally, each module has interface
          capabilities with one or more outside programs through
          a number of common file formats.

Additional Packages

     The Application Shell provides run-time support for RAD
     Applications created by the ANGOSS Developer. If you are not
     using this type of application, the Application Shell does
     not need to be installed.

     The ANGOSS Developer System is used to create and modify RAD
     Apps. This menu driven development tool is accessible from
     within the application menu structure itself, via a single
     key-press. RAD Apps are operational from the moment they are
     first created and alterations or additions become active
     when they are defined -- allowing developers to make changes
     quickly and to see results immediately. Applications can be
     created in any combination of the four SmartWare modules.

     NOTE: In order to use the Developer System, the Application
     Shell must be installed and a RAD App created. This is
     because, the Developer System operates from within a RAD
     application.


Feature List

     PROGRAMMING LANGUAGE

     More than a simple macro language, the SmartWare Programming
     Language (SPL) is a complete programming environment. In its
     simplest form, it provides the same functionality commonly
     found in macro languages. The REMEMBER mode, for example,
     allows novice users to record and replay keystrokes,
     commands, or a combination of both, while expert developers
     can use it to develop sophisticated applications.

     This robust programming language contains all classic
     programming tools expected, including:

          Structured programming constructs, such as FOR, WHILE,
          CASE and IF-THEN-ELSE

          More than 200 unique programming commands

          More than 300 formula-related functions

          Interrupts and libraries

          User-defined public, local and global variables

          Multi-dimensional arrays

          Variable and Array Pointers


     THE DATABASE

     The Database has the flexibility to manage all types of
     information with up to two hundred million records. Powerful
     tools such as Query By Example, automatic query
     optimization, cross tabulation for performing mathematics or
     tabulating figures and the ability to perform transactions
     on up to 250 files provide the features needed for
     successful database management.

     Key Fields

          The use of B+Tree field structure makes the location of
          data fast. ANGOSS dynamic key structure ensures keys
          and records are instantaneously updated as they are
          added or edited.

     Custom Screens and Menus

          The Database allows creation of customized data
          screens. Multiple files can be combined with specified
          colors, jumps and rules.Tables can be used to create a
          many-to-one relationship. Custom menus can be designed
          to simplify data entry.

     Report Generator

          The built-in report generator can incorporate 127 data
          files into a report. The database supports detailed
          summary and "total only" reporting.

     Database Features

          Total number of records per file limited only by disk
          space.

          31K characters per record.

          1,000 fields per file.

          Fixed or variable length fields.

          Lantastic certified

          Novell compatibility: Supports Novell TTS (Transaction
          Tracking) Networks.

          Statistical functions are for summation, sum of
          squares, standard deviation, average, count, popular
          deviation, variance minimum, maximum and calculations
          based on file order.

          File order maintained when file not in window.

          1,023 users in a multi-user environment may access the
          same data file simultaneously with access nodes.

          B+ Tree file structure.

          Unlimited custom-designed data entry screens.

          Custom application development.

          8 types of calculation: Math; time; date;
          trigonometric; statistical; financial; matrix and
          regression analysis.

          Numbers stored in 1EEE floating point form with maximum
          15 significant digits.

          Dates and times stored as numbers.

          LAN locking schemes for complete files and individual
          records.

          Password protection at file and view levels.

          Designated 'read only' and 'must enter' data entry
          fields.

          Relational file data transfers, look-ups and file
          creation based on contents of other files.

          Up to 2,000 data entry rules per field.

          Complex file sorts, queries and searches.

          Report generating to screen, printer or disk.

          50 on-screen windows at once with linked window
          scrolling.

          Automatic restructure following file modification.

          Unlimited number of views per field.

          Up to 127 files per view.

          255 columns by 32,000 lines per view.

          Table areas may be created which are linked to a key
          field in a subordinate data field.

          Input mask allows only certain characters.

          Views may contain fields from multiple data files.

          Display mask may be defined to display fields in a
          specified manner.

          Error-condition checking, jump and colors may be
          attached to a field.

          Instantaneous updating of the key field after a record
          is entered or edited.

          Records may be entered and updated in same session and
          records may be edited in standard screen browse mode.

          Automatic next page display.

          Cross tabs allow summarization in table format.

          Match definitions may be any valid calculation.

          Calculation on unique field entries is automatic.

          Query By Example.

          Automatic ordering after complete entry.

          Automatic use of keys increases speed.

          Summary statistics may be specified in query
          definition.

          Query summaries displayed on screen following
          execution.

          Manual index updating/creating.

          Reports can combine up to 127 data files and 1,000 x
          1,000 column definition.

          Up to 16 report breaks a page can be edited; totals may
          be specified; 99 lines of statistical calculations may
          be defined in each field.

          Start and end page printing.

          Use of fonts within reports.

          Unlimited wrapped text field in tables.

          Report headers/footers/break labels may contain
          calculations/variables.

          Report definitions are no longer associated with a
          specific data file.

          99 Grand Total lines.

          Transactions may have any number of driven views.

          Transactions may be linked from a driver view's table
          area(s).

          Any number of links may be defined for a given view
          with any number of defined calculations.

          Calculation results may be placed in either the driven
          or driver view.

          Audit trails include match information, field previous
          and new values.


     THE SPREADSHEET

     ANGOSS SmartWare combines minimal and background
     recalculation, linking and auditing capabilities with over
     300 built-in functions, making it a powerful analytical
     tool.

     Efficiency

          The use of sparse matrix memory management allocates
          memory only for those specific cells in the spreadsheet
          containing data.

     Relational Capabilities

          The   spreadsheet can have 50 different worksheets in
          memory or displayed simultaneously on screen.
          Worksheets can be consolidated or linked.

     Capacity

          Each Worksheet has almost one million addressable
          cells.

     Spreadsheet Features

          Preformatting of numeric cells.

          Page Preview.

          Supports math co-processors for even greater speed.

          Minimal recalculation speeds calculation by reducing
          number of cells calculated.

          No RAM limit on worksheet size. Uses Virtual Memory.

          Up to 240 characters per cell for values and text.

          Up to 1,000 characters for formulae.

          Up to 50 worksheets in on-screen windows at once.

          Links models for effortless worksheet consolidation.

          Eight types of calculation: Math; trigonometric;
          statistical; financial; date; time; matrix and
          regression analysis.

          Seven types of decision-making: Select; look-up; case;
          if-then-else; and/or; Boolean and choose.

          Goal-seeking capability allows you to solve for any one
          unknown variable in an equation.

          Custom application development.

          Formula-locking: Allows user to protect formulae from
          being viewed or edited.

          Sorts and organizes data.

          Full-screen formula editor.

          Built-in format report generator.

          Iteration function automatically recalculates a
          worksheet.

          Sparse matrix storage stores only those cells
          containing data for greater speed.

          Zero suppression.

          Credit or debit/credit representation of negative
          numbers.

          General formatting option.

          Time format (12/24 hours).

          Cell formatting reflecting current worksheet default
          format.

          Auditing option to highlight cells containing specified
          information.

          Single cells, blocks or range of cells may be hidden.

          Ability to load part of a worksheet, add or subtract
          values to current worksheet.

          Up to 64 combinations of typestyle, size, color and
          style.

          Row and column order calculations.

          Built-in sideways printing.

          Enhanced printing includes multiple-sized fonts, colors
          and variable row height.

          Printing of row and column numbers.

          User-determined margins, page size and single-sheet
          feeding for normal, enhanced and sideways printing.

          Search can be confined to specified cells.

          Writes comma delimited ASCII format.

          Dif.ASCII, Text, SULK, Lotus 1A and 2.0 file formats
          may be imported.

          Exporting of Dif.ASCII, Text, Lotus 1A and 2.0 file
          formats.

          Multi-level password protection.

     Presentation Graphics

          Creates text charts.

          Composite graphs allow multiple images to be positioned
          or overlaid on page.

          Expanded scaling: Log-log; log-semilog; multi-axis.

          Landscape and portrait painting.

          Plotter fills in optimal direction for improved speed.

          Contents of cells as labels/legends, including any data
          format.

          Labels for all pie slices.

          Screen graphics match hard copy output including
          footnotes which appear on the screen and fonts in the
          selected size.

          Color printer support with full range of colors.

          Vastly improved printer support, including dot matrix,
          laser, ink jet, PostScript - virtually any printer with
          graphics capabilities.

          Increased plotter support.

          Quick Graphic Define option allows users to generate
          professional graphics using only a few simple
          keystrokes.

          Create virtually limitless combinations including 3-D
          bar charts (horizontal and vertical); 2-D and 3-D pie
          charts; line, area and step charts; high-low charts; xy
          and polar graphs; contour surface and wireframe graphs;
          text charts and combination charts - all on one screen
          or printed page.

          Up to 16 colors, 14 fill patterns, over 20 fonts,
          extensive gray scaling options.

          Fits multiple graphs per page with composite feature.

          Supports industry-standard Computer Graphics Metcalfe
          (CGM) format allows metafile graphics to be imported
          and exported. Built-in are conversion routines for CGM,
          TIF, PCX, GIF and BMP.

          Automatic or user-defined scaling.

          Sends graphs to ANGOSS SmartWare wordprocessor.


     THE WORDPROCESSOR

     The wordprocessor unites features like cut-and-paste
     editing, automatic reformatting, search-and-replace,
     mailmerge, over 30 available typestyles and more in order to
     create professional-looking documents.

     Reference Tools

          A 140,000-word spellchecker and a 600,000-synonym
          thesaurus are included. Automatic footnote numbering,
          placement and paragraph numbering are also available.

     TOC and indexing

          Using built-in Table of Contents and Index facilities,
          words, phrases or entire blocks of text can be marked
          for automatic generation.

     Formatting

          Variable or equal column width areas may be included in
          wordprocessor documents. ANGOSS supports on-screen
          rulers for quick reformatting.

     Wordprocessor Features

          No RAM limit on document size.

          Linked columns available to maintain vertical
          alignment.

          Multiple Column Areas (MCA).

          Sorting of column entries.

          Variable or equal width columns may be defined.

          Rulers may be embedded throughout a document to
          customize format.

          Text may be hidden.

          Table of Contents with five heading levels.

          Index containing reference items at multiple locations.

          Outline, legal and standard paragraph numbering.

          Automatic footnoting at end of page, end of document
          and end of section.

          Footnotes may contain fonts, bold, underscore, up to 10
          lines of text and 255 characters per line.

          Automatic hyphenation.

          Section breaks divide documents.

          140,000 word Spellchecker allows you to create custom
          dictionaries.

          Thesaurus contains 61,000 key word references and
          600,000 synonyms.

          American, English, French, German, Dutch, Italian,
          Portuguese, Norwegian, Swedish and Spanish versions of
          both the Spellchecker and Thesaurus.

          Optional add-in Medical, Legal and Computer
          spellcheckers.

          Number of words in custom spellchecker limited only by
          disk space.

          Block of text can be kept on same page during
          pagination.

          Multiple page layout and section breaks allow specified
          document divisions.

          Half line spacing support.

          Quick key block marking.

          Widow and orphan support to control the minimum number
          of lines at the top or bottom of a page in a broken
          paragraph.

          Horizontal proportional spacing.

          Number of active background documents limited only by
          memory.

          Document may be locked to prevent unauthorized change.

          Built-in mailmerge with up to 100 variables.

          Custom application development with Smart Programming
          Language.

          On-screen cut-and-paste, moving, copying, deleting and
          other editing within and between documents.

          Graphic character sets for incorporating
          custom-designed forms.

          Over 20 fonts, 6 line types and 6 symbol types,
          depending on printer.

          Read and write other system formats, including WordStar
          2000, WordPerfect, Microsoft Word and IBM Document
          Content Architecture.

          Background pagination lets you keep working as your
          document changes.

          Page Preview.


     COMMUNICATIONS

     ANGOSS includes asynchronous communications which allows
     data to be transmitted across telephone lines. A wide
     variety of modems are supported, including several 9600 baud
     modems and transmission speeds of up to 38.4K baud.

     Supported Printers

     ANGOSS print drivers are designed for great efficiency. Most
     popular printers and cartridges are supported, including
     PostScript. In the event that your printer is not supported,
     ANGOSS gives the option of creating custom printer
     definitions.

     Communications Features

          Asynchronous Communications.

          Automatic dial, answer and log-on can be created via
          ANGOSS SmartWare Programming Language.

          Automatically wraps overflow characters to left margin
          of next line.

          Unattended sending and receiving.

          Creation of custom modem definition files.

          Stores commonly used set-ups.

          Line delay setting.

          Support for up to 38.4K baud transmission speeds.

          Supports COMs 1,2,3 and 4

          File locking for profiles.

          Display of modem commands/results to determine if
          definition is correct.

          Terminal Emulation for ANSI. VT-100 and VT-50.


     General Features.

          Intuitive menu system organizes commands by their
          functions.

          Each module has direct access to global system
          commands.

          Text manipulation capabilities include repeat, left,
          right midstring, find-and-replace and concatenate.

          Fully "network-ready" with features like automatic
          file-locking.

          Programming language records English commands for easy
          writing and editing.

          Macro facility allows full key definition.

          On-line, context-sensitive HELP throughout the program,
          plus on-line documentation, interactive tutorials,
          training, reference manuals and more.

          Direct access to the operating system within ANGOSS
          SmartWare.

          Full-screen formula editor.

          Optional data encryption for database, spreadsheet, and
          wordprocessor modules: Up to 16-character passwords.

          Prompter menu for all file operations.

          Multiple printer installation.

          Condensed print support.

          Includes ANGOSS SmartWare fonts, scalable up to 99
          points.

          Horizontal proportional spacing and micro justification
          support.

          Underscore, double underscore and strike-out available.


