Skip to main content
SpringerLink
Log in

Calc/Cream: OpenOffice Spreadsheet Front-End for Constraint Programming

  • Conference paper
Declarative Programming for Knowledge Management (INAP 2005)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 4369))

Abstract

Calc/Cream is a constraint programming system with a spreadsheet front-end implemented on OpenOffice.org Calc and Java language. Constraint problems are described by users as cell expressions on a spreadsheet, and solutions are searched by the constraint solver and shown as cell values by the system. It is also possible to use Basic macros to customize the system.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Puget, J.F.: A C++ Implementation of CLP. (ILOG), http://www.ilog.com/

  2. ILOG: (ILOG JSolver), http://www.ilog.com/

  3. Chun, A.H.W.: Constraint programming in Java with JSolver. In: Proceedings of the First International Conference on the Practical Application of Constraint Technologies and Logic Programming (PACLP 1999) (1999)

    Google Scholar 

  4. Koalog: (An Overview of Koalog Constraint Solver), http://www.koalog.com/

  5. Abddennadher, S., Krämer, E., Saft, M., Schumauss, M.: JACK: A Java constraint kit. In: Proceedings of the International Workshop on Functional and (Constraint) Logic Programming (WFLP 2001) (2001)

    Google Scholar 

  6. Artificial Intelligence Laboratory of EPFL Switzerland: (JCL: Java Constraint Library), http://liawww.epfl.ch/JCL/

  7. Tamura, N.: (Cream Programmers Guide), http://bach.istc.kobe-u.ac.jp/cream/

  8. Ohnishi, S., Tasaka, H., Tamura, N.: Efficient representation of discrete sets for constraint programming. In: Rossi, F. (ed.) CP 2003. LNCS, vol. 2833, pp. 920–924. Springer, Heidelberg (2003)

    Chapter  Google Scholar 

  9. OpenOffice.org: (OpenOffice.org), http://www.openoffice.org/

  10. Banbara, M., Tamura, N., Inoue, K., Kawamura, T.: Java implementation of a heterogeneous constraint solving system. (final report of IPA Exploratory Software Project 2002) (2003)

    Google Scholar 

  11. Banbara, M., Tamura, N., Inoue, K., Kawamura, T., Hamaki, H.: Java implementation of a distributed constraint solving system. (final report of IPA Exploratory Software Project 2003) (2004)

    Google Scholar 

  12. Chew, T., David, J.M.: A constraint-based spreadsheet for cooperative production planning. In: Proceedings of the AAAI Sigman Workshop in Knowledge-Based Production Planning, Scheduling and Control (1992)

    Google Scholar 

  13. Hyvönen, E., Pascale, S.D.: A new basis for spreadsheet computing: Interval solver for Microsoft Excel. In: Proceedings of the Sixteenth National Conference on Artificial Intelligence and Eleventh Conference on Innovative Applications of Artificial Intelligence (AAAI/IAAI 1999), pp. 799–806 (1999)

    Google Scholar 

  14. Adachi, Y.: Intellisheet: A spreadsheet system expanded by including constraint solvers. In: Proceedings of the IEEE Symposia on Human-Centric Computing Languages and Environments (HCC 2001), pp. 173–179 (2001)

    Google Scholar 

  15. Gupta, G., Akhter, S.F.: Knowledgesheet: A graphical spreadsheet interface for interactively developing a class of constraint programs. In: Pontelli, E., Santos Costa, V. (eds.) PADL 2000. LNCS, vol. 1753, pp. 308–323. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Information Science and Technology Center, Kobe University, 1-1 Rokkodai, Nada, Kobe, 657-8501, Japan

    Naoyuki Tamura

Authors
  1. Naoyuki Tamura
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Graduate School of Computer Science and Systems Engineering, Kyushu Institute of Technology, Iizuka, Fukuoka, Japan

    Masanobu Umeda

  2. Fraunhofer FIRST, Kekuléstr. 7, D-12489, Berlin, Germany

    Armin Wolf

  3. IF Computer Japan, 5-28-2 Sendagi, Bunkyo-ku, 113-0022, Tokyo, Japan

    Oskar Bartenstein

  4. Fraunhofer FIRST, Berlin,  

    Ulrich Geske

  5. Universität Würzburg, Am Hubland, 97074, Würzburg, Germany

    Dietmar Seipel

  6. Graduate School of Computer Science and Systems Engineering,, Kyushu Institute of Technology, Iizuka, Fukuoka, Japan

    Osamu Takata

Rights and permissions

Reprints and permissions

Copyright information

© 2006 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Tamura, N. (2006). Calc/Cream: OpenOffice Spreadsheet Front-End for Constraint Programming. In: Umeda, M., Wolf, A., Bartenstein, O., Geske, U., Seipel, D., Takata, O. (eds) Declarative Programming for Knowledge Management. INAP 2005. Lecture Notes in Computer Science(), vol 4369. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11963578_7

Download citation

  • DOI: https://doi.org/10.1007/11963578_7

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-69233-1

  • Online ISBN: 978-3-540-69234-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation