How to use Calc/Cream

[ Japanese | English ]

How Calc/Cream works


Cell Functions of Calc/Cream

Variables can be declared by the following cell functions. Constraints can be declared by the following CONSTRAINTS function, which can be used to specify the cell locations of constraints.
Cell Function Detail

CVARIABLE

CVARIABLE(Infimum; Supremum; ProvisionalValue)
Declares a variable.Infimum, Supremum constructed from the followings : ProvisionalValue is integer value.

CVARIABLES

CVARIABLES(Infimum; Supremum; CellRange1; CellRange2; ...)
Declares CellRange1, CellRange2, ... as variables with Infimum, Supremum. Infimum, Supremum constructed from the followings :

CONSTRAINTS

CONSTRAINTS(CellRange1; CellRange2; ...)
Declares CellRange1, CellRange2, ... as constrains. The Expression in CellRange1, CellRange2, ... is added to constraint network.

CEQUALS

CEQUALS(arg1; arg2; ...)
Declares a constraint means that arg1, arg2, ... are all equal. arg1, arg2, ... constructed from the followings :

CNOTEQUALS

CNOTEQUALS(arg1; arg2; ...)
Declares a constraint means that arg1, arg2, ... are all different. arg1, arg2, ... constructed from the followings :

CSEQUENTIAL

CSEQUENTIAL(arg1; arg2; ...)
Declares a constraint means that arg1, arg2, ... are SEQUENTIAL. arg1, arg2, ... constructed from the followings :

CSERIALIZED

CSERIALIZED(arg1; arg2; ...)
Declares a constraint means that arg1, arg2, ... are SERIALIZED. arg1, arg2, ... constructed from the followings :

COBJECTIVE

COBJECTIVE(Cell)
Declares objective.

CTIMEOUT

CTIMEOUT(Timeout)
Sets time out.

COPTIONS

COPTIONS(Option1; Option2; ...)
Sets options.
Option1, Option2, ...constructed from the followings :
Term and Expression

Term

Term = Integer value || 
       Cell || 
       - Term ||
       Term + Term || 
       Term - Term || 
       Term * Term ||  
       SUM(arg1; arg2; ...) ||
       ABS(Term)

Expression

Expression = Term = Term ||
             Term <> Term ||
             Term > Term ||
             Term >= Term ||
             Term < Term ||
             Term <= Term ||
             CEQUALS(arg1; arg2; ...) ||
             CNOTEQUALS(arg1; arg2; ...) ||
             CSEQUENTIAL(arg1; arg2; ...) ||
             CSERIALIZED(arg1; arg2; ...) ||

Naoyuki Tamura
( Last modified: Tue Mar 15 00:09:54 JST 2005 )