How to use Calc/Cream
[ Japanese | English ]
How Calc/Cream works
- User can declare variables/constraints on integers
by using Calc/Cream cell functions described below
- When the user press the 'Start' button, the followins will be
performed.
- The sheet is scanned, and cells containing variables and
constraints are parsed, and they are added to
constraint network of Cream
- A solver is started to find a solution
- Values of the solution are set to the corresponding cells
- When the user press the 'Next' button, next solution will be
searched
Cell Functions of Calc/Cream
Variables can be declared by the following cell functions.
-
CVAR(Domain; ProvisionalValue)
Declares a variable with Domain
(ProvisionalValue is used to show the result)
-
CINT(Inf; Sup)
Specifies an integer interval domain
Constraints can be declared by the following C
function,
or alternatively CSOLVE
function can be used to
specify the cell locations of constraints.
-
C(Constraint)
Declares a constraint constructed from the followings:
- Integer value, Cell, or Cell range
-
+
, -
, *
,
SUM(CellRange)
-
=
, <>
,
<
, <=
,
>
, >=
,
CNOTEQUALS(CellRange)
-
CSOLVE(Cell1; Cell2; ...)
Declares Cell1, Cell2, ... as constraints.
Naoyuki Tamura
(
Last modified: Fri Apr 30 06:46:59 2004 JST
)