ARulesXL
Contents Index
Installation
Requirements
Installing ARulesXL
Licensing
Activating Your License
Transferring Your License
Re-Installing Windows
Updating & Software Maintenance
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
Learning ARulesXL
Designing Rules and Rule Sets
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, Properties & amp; Variables
Using Tables, Arrays and Lists
Multiple Property Rules
Pattern Matching Variables
How it Works
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
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
Properties
Property Values
Formulas
Conditions
Pattern Matching Variables
Linking Properties 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( PropertyName, Cell )
RQuery( RuleSet, QueryText, Cell_1,..., Cell_N )
RTable( PropertyName, Range, [hasRowHeaders], [hasColumnHeaders], [isVector])
RXLDependency( RuleSet_1,..., RuleSet_N )
Deprecated Spreadsheet Functions
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