40 likes | 140 Views
ARulesXL Rule Set. Investor resell decision criteria. Loan Attributes. Resell Decision. ResaleRules =RXLDependency(Ace) =RXLDependency(Acme) =RTable(“.loans”, C5:G19) .Resell[?investor, ?id] = ?investor : .Resell[?id]. Rule Set name and Excel range name.
E N D
ARulesXL Rule Set Investor resell decision criteria Loan Attributes Resell Decision
ResaleRules =RXLDependency(Ace) =RXLDependency(Acme) =RTable(“.loans”, C5:G19) .Resell[?investor, ?id] = ?investor : .Resell[?id] Rule Set name and Excel range name. Establish Excel dependency, so changes in Ace or Acme mark ResaleRules as changed. RQuery()s to ResaleRules are then reexecuted. Read loan data into ResaleRules property array .loans. Dispatch queries to appropriate rule set. Rule Set name and Excel range name. Ace Inherit from ResaleRules .Resell[?id] = yes WHEN .loans[?id, FICO] > 720 AND ... Establish rule set relationship, allowing Ace to use .loans defined in ResaleRules. .Resell rules for investor Ace. Acme Inherit from ResaleRules .Resell[?id] = yes WHEN .loans[?id, FICO] > 680 AND ... .Resell rules for investor Acme.
.price (formula) .rate (table) .duration (input) .daytime (table) .baserate (fact) .weekend (table, rules) .day (input) .weekdays (fact) .time (input)
ARulesXL ARulesXL / Excel Application Environment Java, .NET, Delphi, other, Windows, Unix ARulesXL API query rules export assert data get results Binary Rules ARulesXL Runtime