ARulesXL

Contents Index

Installation
  Requirements
  Installing ARulesXL
  Licensing
   Activating Your License
   Transferring Your License
   Re-Installing Windows
  Updating & Software Maintenance
  Uninstalling ARulesXL

Introduction
  Rule Technology
  Integrated Dependencies
   Common Spreadsheet Interface
   Linked Dependencies
  Pricing Example
  Loan Approval Example
  More Applications for Rules

Samples
  Techniques
  Applications
  Advanced Topics

Tutorial
  A Quick Tour of the ARulesXL Excel Environment
  Learning ARulesXL
  Designing Rules and Rule Sets
  Tables, Collections, Variables and Loops
  Techniques Spreadsheets

Tutorial-Creating a Simple Rule Set & amp; Querying It
   Rules
   Rule Sets
   Implementing the Example
   Order of Rules
   Syntax Checking
   Resizing, Renaming and Removing Rule Sets

Tutorial-Using Cell Values in Queries and Rules
   Using Cell Values as Inputs to Queries
   Using Cell Values in Rules
    Best Practices

Tutorial-Using Formulas in Rules
   Asking the User
   Document Assembly

Tutorial-Using Tables, Arrays, Lists, Facts & amp; Variables
  Using Tables, Arrays and Lists
  Multiple Fact Rules
  Pattern Matching Variables
   How it Works

tutorial/tutor_runtime.htm
  Running Rule Sets Outside of Excel

Tutorial-Designing Rules
   1. Identify the Outputs
   2. Determine the Inputs
   3. Write the Rules Naturally
   4. Determine the How You will Use the Outputs
   5. Determine How You will Get the Inputs
   6. Write the First Rules
   7. Test the First Rules
   8. Write More Rules
   9. Test More Rules

ARulesXL
   loans_01_rules.xls loans_02_decision_tables.xls
  Facts
  Rules
  Rule Sets
  Inputs/Outputs ( RQuery() )
  Rule Engine
  Decision Tables
   loans_03_column_queries.xls
   loans_04_property_arrays.xls

tutorial/collections/collections_05_data_tables.htm
   loans_05_data_tables.xls

tutorial/collections/collections_06_lists.htm
   loans_06_lists.xls

tutorial/collections/collections_07_vba.htm
   loans_07_vba.xls

tutorial/collections/collections_08_modules.htm
   loans_08_modules.xls

Array Queries
   loans_09_array_queries.xls
   Modelling Cumulative Rate Adjustment Rules
   Creating the Output Array of Data
   Formatting an Excel Array

Reference
  ARulesXL Reference Topics

Reference-Architecture
  Product Architecture

Reference-The ARulesXL Reasoning Engine and Excel Calculation
  The ARulesXL Reasoning Engine and Excel Calculation
   Spreadsheet Calculation
   Rule Base Reasoning
   Example
   Integration
  Reasoning Algorithm Step-by-Step

Reference-Rule Set Syntax and Components
  Rule Set Syntax and Components
   Resizing, Renaming, Removing and Moving Rule Sets
    Resizing Rule Sets
    Renaming Rule Sets
    Removing Rule Sets
    Moving Rule Sets
   Comments

Reference-Rule Syntax
  Rule Syntax
   Rules
   Facts
   Fact Values
   Formulas
   Conditions
   Pattern Matching Variables
   Linking Facts and Cells

Reference-Rule Functions
  Rule Functions
   General
   Arrays & Lists
   Sets
   Date/Time
   Arithmetic

Reference-Decision Tables
  Decision Tables
   Format
   Mixing Rules and Decision Tables
   Copying and Pasting Table Data

Reference-Spreadsheet Functions
  Spreadsheet Functions
   RCell( FactName, Cell )
   RQuery( RuleSet, QueryText, Cell_1,..., Cell_N )
   RArray( FactName, Range, [hasRowHeaders], [hasColumnHeaders], [isVector])
   RXLDependency( RuleSet_1,..., RuleSet_N )

Reference-Debugging Rule Sets
  Debugging Rule Sets
   Trace
   Formatting the Trace Spreadsheet
   Trace Log File
   Diagnostic Messages
  Common Errors

Reference-Using Dates and Times in Rules
  Using Dates & Times in Rules

Reference-Using Logic Relations for Advanced Pattern Matching
  Using Logic Relations for Advanced Pattern Matching
   Recursion
   Lists
   Not Using Logic Relations

Reference-Multiple Rule Sets and Inheritance
  Multiple Rule Sets and Inheritance
   Logical Relationships
   Excel Dependency
   Inheritance

Reference-International Language Support
  International Language Support

Reference-Excel Menu Commands
  Excel Menu Commands
  Cell Mouse Menu Commands

Release Notes
 Release Notes