Solving Configuration Problems in Excel
نویسندگان
چکیده
This work shows how Excel can be leveraged to tackle configuration problems. We demonstrate this by presenting the full development cycle of a PC-configurator prototype. We articulate our demonstration by exemplifying several important points. First, Excel can be used to import raw products and services data. Second, these data can be used by a constraint modelling to correctly instantiate a set of configuration rules. Third, any update to the data like addition of new components can be performed without altering the modelling. Fourth, dedicated Excel GUIs can be used for interactive product and service configuration.
منابع مشابه
Solving Configuration Problems in Excel : How to successively address Professional Markets through the Office world MSR-TR-2006-106
This work shows how Excel can be leveraged to tackle configuration problems. We demonstrate this by presenting the full development cycle of a PC-configurator prototype. We articulate our demonstration by exemplifying several important points. First, that Excel can be used to import raw products and services data. Second, that these data can be used by a Constraints configuration modelling to c...
متن کاملExSched: Solving Constraint Satisfaction Problems with the Spreadsheet Paradigm
We report on the development of a general tool called ExSched, implemented as a plug-in for Microsoft Excel, for solving a class of constraint satisfaction problems. The traditional spreadsheet paradigm is based on attaching arithmetic expressions to individual cells and then evaluating them. The ExSched interface generalizes the spreadsheet paradigm to allow finite domain constraints to be att...
متن کاملNExSched: Solving Constraint Satisfaction Problems with the Spreadsheet Paradigm
We report on the development of a general tool called NExSched, implemented as a plug-in for Microsoft Excel, for interactively solving a class of constraint satisfaction problems. The traditional spreadsheet paradigm is based on attaching arithmetic expressions to individual cells and then evaluating them. The NExSched system generalizes the spreadsheet paradigm to allow finite domain constrai...
متن کاملProgramming Excel with VBA and .NET - solve real-world problems with Excel
by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...
متن کاملAn Algorithmic Approach for Solving ETSP Using Premium Solver Platform
Spreadsheet software, notably Microsoft Excel©, can be used very effectively for analyzing logistics and supply chain issues. Spreadsheet allow analysis from many different perspectives and can be modified and enhanced to reflect new situations and options. Our purpose in this article is to demonstrate the efficiency of a problemsolving algorithm that uses Microsoft Excel add-in tools Premium S...
متن کامل