Abstract
Spreadsheets are in wide-spread industrial use for lightweight business applications, whereby the broad acceptance is both founded on the underlying intuitive interaction style with immediate feedback and a “programming model” comprehensible for nonprogrammers. In this paper we show how the spreadsheet development paradigm can be extended to model and solve a special class of search and optimization problems that occur in many application domains and would otherwise require the involvement of specialized knowledge engineers.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
V.E. Barker, D.E. O’Connor, J.D. Bachant, and E. Soloway. Expert systems for configuration at Digital: XCON and beyond. Communications of the ACM, 32,3:298–318, 1989.
M. Burnett, J. Atwood, R. W. Djang, J. Reichwein, H. Gottfried, and S. Yang. Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm. Journal of Functional Programming, 11(2):155–206, 2001.
A. Felfernig, G. Friedrich, D. Jannach, and M. Stumptner. Consistency-based diagnosis of configurator knowledge bases. In 14th European Conference on Artificial Intelligence (ECAI2000), Berlin, Germany, 2000. IOS Press.
G. Fleischanderl, G. Friedrich, A. Haselböck, H. Schreiner, and M. Stumptner. Configuring Large Systems Using Generative Constraint Satisfaction. In B. Faltings and E. Freuder, editors, IEEE Intelligent Systems, Special Issue on Configuration, volume 13,4, pages 59–68. IEEE, 1998.
G. Gupta and S.H. Akhter. Knowledgesheet: A graphical spreadsheet interface for interactively developing a class of constraint programs. In Practical Aspects of Declarative Languages, Lecture Notes in Computer Science 1753, pages 308–323. Springer Verlag, 2000.
T. Isakowitz, S. Schocken, and H. C. Jr. Lucas. Toward a logical/physical theory of spreadsheet modeling. ACM Transactions on Information Systems, 13(1):1–37, 1995.
U. Junker. Quickxplain: Conflict detection for arbitrary constraint propagation algorithms. In IJCAI’01 Workshop on Modelling and Solving problems with constraints, Seattle, WA, 2001.
B.J. Pine, S. Davis, and B.J. Pine II. Mass Customization: The New Frontier in Business Competition. Harvard Business School Press, 1999.
J. F. Puget. A C++ implementation of CLP. In Proceedings of the Second Singapore International Conference on Intelligent Systems, Singapore, 1994.
A. Renschler. Configuration spreadsheet for interactive constraint problem solving. In Practical Applications of Constraint Technology, PACT98, 1998.
B. Ronen, M. A. Palley, and Henry C. Luca. Spreadsheet analysis and design. Communications of the ACM, 32(1):84–93, 1989.
M. Spenke and C. Beilken. A spreadsheet interface for logic programming. In Proc. Computer-Human Interaction, CHI98, 1998.
M. Stumptner. An overview of knowledge-based configuration. AI Communications, 10(2), June, 1997.
E. Tsang. Foundations of Constraint Satisfaction. Academic Press, 1993.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Felfernig, A., Friedrich, G., Jannach, D., Russ, C., Zanker, M. (2003). Developing Constraint-Based Applications with Spreadsheets. In: Chung, P.W.H., Hinde, C., Ali, M. (eds) Developments in Applied Artificial Intelligence. IEA/AIE 2003. Lecture Notes in Computer Science(), vol 2718. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45034-3_20
Download citation
DOI: https://doi.org/10.1007/3-540-45034-3_20
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40455-2
Online ISBN: 978-3-540-45034-4
eBook Packages: Springer Book Archive