Using Decision Tables to model and solve Scheduling and Resource Allocation Problems

A new release of OpenRules Rule Solver allows business analysts to model their scheduling and resource problems directly in Excel without any programming. The Rule Solver automatically generates (on-the-fly) a CSP in terms of the JSR-331 and then executes it using any JSR-331 compliant CP solver (without expecting it to support scheduling and resource allocation concepts). You may look at all details in several simple job construction examples – see

What is interesting in this implementation that it does not hardcode anything. Instead, it provides Excel-based templates for regular decision tables with special conditions and actions that use snippets of Java. These snippets utilize a simple CP Scheduling API developed by OpenRules on top of the JSR-331. It is still a quite basic API and we expect to extend it with much more solid and efficient implementations of major resource allocation constraints. If you want to try JSR-331 Scheduler yourself and/or to contribute to its development, please send an email to You will receive all sources and binaries.


About jacobfeldman

CTO at
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s