Add Business Rules to Your Excel Spreadsheets

Share Article

ARulesXL™ is a new add-in for Microsoft™ Excel® that integrates decision support with computational analysis. This makes it possible to use business rules in spreadsheets for budget analysis, product configuration, workflow, advice, planning, pricing and more. ARulesXL rules are easy to read, write, maintain and audit.

Amzi! announces ARulesXL™, a new add-in for Microsoft™ Excel® that integrates decision support with computational analysis. This makes it possible to solve a wider variety of problems with spreadsheets including budget analysis, product configuration, workflow, advice, planning and pricing.

Rules in ARulesXL are easier to write, less costly to maintain, more reliable, and, most importantly readily audited. Instead of difficult to read IF functions, rules are entered directly on the spreadsheet in a natural and easy to understand syntax. The rules are queried, much like a database. User inputs can be gathered from cells or forms and the results can be displayed in reports or tables.

The ARulesXL syntax is designed to model business rules for pricing, configuration, underwriting, approvals, benefits, workflow, advice and similar applications. The rule syntax is compatible with Excel and VBA, providing seamless integration between non-procedural, pattern matching rules and procedural spreadsheet calculations. Data is easily shared between rules and cells. ARulesXL supports multiple rule sets with objects, properties and inheritance to facilitate decomposition of complex applications. It also provides facilities for dynamic document assembly which is ideal for legal and government regulations applications.

ARulesXL makes it easy to write and maintain rules and provides its own menu of operations including a full rule debugger that illustrates the dynamic pattern matching that underlies rule execution. The next release will include the ability to export rules for use in web-based applications.

A major accounting firm is one of the first commercial users of ARulesXL and is using the product for developing equity compensation analysis tools. Visual Data LLC, vendor of Office Practicum™ pediatric office software, is using ARulesXL for the development and testing of rules used in vaccination planning. ARulesXL is ideal for Sarbanes Oxley compliant spreadsheets with easy to read and audit business rules that generate or verify results.

Additional information and a free 30-day evaluation is available from ARulesXL has an introductory price of $99 per copy, and includes product maintenance and support for one year. Quantity discounts are available for large sites.


Share article on social media or email:

View article via:

Pdf Print

Contact Author

Mary Kroening
Visit website