ARulesXL NewsletterView this newsletter on the web
The 2.0 version of ARulesXL is now ready for downloading and purchase. Current trial users gain an additional 30 days when installing the newest 2.0.3 release.
Thanks to everyone who provided feedback and suggestions during the beta test period.
The primary innovations are in the user interface including easier ways to write and debug rules. The major features of 2.0 are:
For many applications decision tables are an easier way to represent rules. For example, here are phone call pricing rules:

Note, the * as a value in the .rate table means that property can have any value.
Because you can mix rules with decision tables, you can handle the cases where 90% of the knowledge can be expressed in a decision table, but the other 10% requires explicit rules. See the documentation and the Decision Tables.xls sample for details.
As you type rules into rule sets, they are checked. If there is a problem, the rule is highlighted in red and an error message is displayed.

This lets you quickly find and resolve problems. When the problem, is resolved, the rule text is returned to its original color.
When you are done changing and adding rules, click outside the rule set and the dependent queries will be recalculated.
The ARulesXL Trace makes use of an Excel worksheet to display the state of execution of a rule query. It is controlled by it's own menu bar for easy examination of the original rules and the trace. You can trace into rules or skip the details, allowing you to quickly get to the rule in question. The trace displays the rules as they execute and keeps a list of all the properties determined so far.
Trace is excellent for both debugging ARulesXL applications and for learning how a business rule engine works. Towards this end, the trace produces a log of each step of the reasoning process. You can view this log in Excel using ARulesXL | Open Trace Log File.
Here's a screen shot from the middle of a trace from the sample Loan Approval.xls.

(Click on image to see larger
version)
The Trace is documented in both the Tutorial and the Reference documentation.
The ARulesXL runtime lets you export rule sets to a machine-independent binary file and then query them from Web Servers, stand-alone applications and Extend models. Language interfaces are provided for VB, C#, Java and Delphi on Windows and Java and C++ for Unix. There is a complete manual on the API (Application Program Interface), and samples for many languages and environments. If you need an interface for another language, tool or environment, please contact us.
The runtime makes ARulesXL a powerful development tool for back-end knowledge bases. For example, the VacLogic application is developed and maintained using the ARulesXL Excel development environment, but is deployed as a component in a Delphi application for running pediatric offices.
The runtime is part of the new Professional Edition of ARulesXL.
In addition to exporting to other environments, rule sets can be 'exported' to run under Excel. This allows you to distribute your rule sets to users so they can run them under Excel, changing the inputs and seeing the query results. You can leave the rules visible on the spreadsheets for the users to read, or you can delete or hide them. In either case, the users cannot modify the rule sets. However, if you leave the rules in place, your users can upgrade to the Standard Edition and then change the rule sets.
This feature is part of the Professional Edition.
The Excel Add-in provides a handful of query functions that allow you to build macros that query rule sets. These query functions along with the RANGE() function in rule sets lets you display the output data in any form you like and highlight items in the input data. See the 'Budget Analysis.xls' sample and the API documentation for details.
This feature is part of the Professional Edition.
On the right-mouse cell menu in Excel, you will find the most commonly used ARulesXL functions. Also, Excel's Insert Function facility has ARulesXL as a category describing the parameters and pointing to the help files.
From the ARulesXL menu in Excel you can access the documentation, samples and support forum.
The ARulesXL manual and API Manual (available under ARulesXL on the Windows Start Menu) have been reworked for better readability and improved tutorials and examples.
The Standard Edition remains at its introductory price of $99 per user. The Professional Edition is priced at $899 per user, and includes 10 runtime licenses. Both Editions include the first year's maintenance so you can install all new releases for the next 12 months.
To subscribe or unsubscribe visit our website.
ARulesXL is a trademark of Amzi! inc. Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.