Samples

Top     Installation     Introduction     Samples     Tutorial     Reference     Release Notes

All the sample spreadsheets can be opened by selecting ARulesXL | Samples from the main menu in Excel. They are also on the ARulesXL menu on the Windows Start Menu.

Techniques

A variety of samples are included in ARulesXL. These introduce the techniques of using ARulesXL:

• Techniques Basic.xls — Introduces and demonstrates all the basic concepts for writing rules in Excel from writing your first rule to debugging to using objects, arrays and lists.
• Decision Tables.xls — Demonstrates how to use decision tables instead of and alongside rules, from a simple table to a powerful mixture of tables and rules.
• Techniques Advanced.xls — Introduces and demonstrates advanced topics including array queries, multiple rule sets, pattern matching variables and variable rule sets.

Applications

These spreadsheets demonstrate how to use rules for solving common problems:

• EZTax.xls — Automaes the filling in of the US 1040EZ income tax form handling the complexity of deductions and earned income credits.
• Loan Approval.xls — Determines from a set of criteria whether or not an applicant is approved for a particular loan, and, if not, explains why.
• Payscale Rules.xls — Calculates the salary for an individual based on their hire date, education, experience and other factors. It uses a table as part of the calculation.
• Product Advice.xls — Recommends a golf shaft based on the player's characteristics. Used as a demo for the ARulesXL API Samples and in the Designing Rules Tutorial.
• Product Pricing.xls — Uses rules to calculate the price of phone calls based on a variety of rules that are difficult to code in tables.
• Table Lookup Meals .xls — Uses tables to select the contents of a meal based on general criteria, and uses pattern matching variables to find a value in a table.
• Table Lookup Pricing .xls — Demonstrates how to implement lookup tables to do product pricing.

Advanced Topics

The following spreadsheets demonstrate advanced concepts of ARulesXL. We recommend you go through the tutorial and examine Techniques Advanced.xls to understand them more fully.

• Budget Analysis.xls — Uses a four dimensional profit and loss statement organized by line item (income, expenses, etc.), quarter, year and region. Uses VBA to add a menu item that analyzes the statements and highlights problem cell ranges in the tables using pattern matching variables and advanced functions like Findall, Sort and Range.
• Order Configuration.xls — Configures the necessary parts when ordering a door. Uses pattern matching variables and logical variables to build the configuration and an array query to return the result.
• Ruleset Inheritance.xls — A simple example of a complex concept, that is having multiple rule sets inherit rules from other rule sets. Uses pattern matching variables to invoke the inherited rules.

Copyright ©2005-7 Amzi! inc. All Rights Reserved. ARulesXL and Amzi! are trademarks or registered trademarks of Amzi! Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation.