Contract automation and calculating a value automatically

Contract automation and calculating a value automatically

Weagree’s contract automation wizard permits automatically calculating a value and inserting the result into the contract text. Such calculation operates with the calc-tag (calculation options and examples are below). The calc-tag must contain all variables as are necessary to calculate and produce the required result.

The variables may be Q&A-answers. Therefore, a calculation tag may contain global questions and local questions (which local questions may be used to reflect a value in the same contract clause).

By exception, inserting such calculation is not achieved by a dedicated button, but (given the indefinite number of possible calculations) requires that you add

Remarks:

  • Like in mathematical formulae, any round brackets ( ) used within the calculation tag determine the order of the calculation.
  • An edit question or choice question can be used without that answer being inserted in the contract. In such case, the answer will only be used in the calculation.
  • Using brackets to open and close the calculation part of the tag permits using decimals with a full stop.
  • It is possible to format the calculated value (see below)

Calculation tag structure:

[calc.<tag name>.(<calculation>)]

If formatting requirements apply to the calculation result (see also here):

[calc.<tag name>.(<calculation>).<formatting parameter>]

 

Examples of simple calculations:

Sum ( + ):

[calc.Example of a sum.(200+[edit.Amount 1]+[edit.Amount 2]+[gq.Value entered elsewhere])]

Example – Deduct ( – ):

[calc.Example of a deduction.(200-[edit.Amount 1]-[edit.Amount 2]-[gq.Value entered elsewhere])]

Example – Divide ( / ):

[calc.Example of a divide.(200/[edit.Amount X])]

Example – Multiply ( * ):

[calc.Example of a multiply.(200*[edit.sum1])]

Example – Combine: sum and divide ( + and / ):

[calc.Example of both sum and divide.((200+[edit.sum1]+[edit.sum2]+[gq.sumglobal])/2)]

Example – Combine a nested calculation and sum (calculation within a calculation and + ):

[calc.Calculate with existing value.(200+[calc.Example A divide])]

 

Possible other parameters in a calc-tag are:

NameDescriptionUsageResult
PowResults in a specified number raised to the specified power.Pow(3, 2)9d
SqrtResults in the square root of a specified number.Sqrt(4)2d
CeilingResults in the smallest integer greater than or equal to the specified number.Ceiling(1.5)2d
MaxResults in the larger of two specified numbers.Max(1, 2)2
FloorResults in the largest integer less than or equal to the specified number.Floor(1.5)1d
MinResults in the smaller of two numbers.Min(1, 2)1
RoundRounds a value to the nearest integer or specified number of decimal places. The mid number behaviour can be changed by using EvaluateOption.RoundAwayFromZero during construction of the Expression object.Round(3.222, 2)3.22d
TruncateCalculates the integral part of a number.Truncate(1.7)1
AbsResults in the absolute value of a specified number.Abs(-1)1M
IEEERemainderResults in the remainder resulting from the division of a specified number by another specified number.IEEERemainder(3, 2)-1d
LogResults in the logarithm of a specified number.Log(1, 10)0d
Log10Results in the base 10 logarithm of a specified number.Log10(1)0d
SignResults in a value indicating the sign of a number.Sign(-10)-1
CosResults in the cosine of the specified angle.Cos(0)1d
SinResults in the sine of the specified angle.Sin(0)0d
TanResults in the tangent of the specified angle.Tan(0)0d
AcosResults in the angle whose cosine is the specified number.Acos(1)0d
AsinResults in the angle whose sine is the specified number.Asin(0)0d
AtanResults in the angle whose tangent is the specified number.Atan(0)0d
ExpResults in e raised to the specified power.Exp(0)1d

Example:

[calc.Example A.(([edit.value1] +([edit.value2] * 3)/2))]

[calc.const.(5000)]

Reusing an existing calculation:

[calc.Example B.([calc.Example A]+2)]

[calc.Example C.([calc.const]+[calc.Example B])]

When inserting the tag (in the template creation tool), regardless of the applicable template language or culture, any decimals must be separated with a full stop ( . ):

[calc.Example D.([calc.Example A]+2.5)]

To force the user to enter a number whether as an integer or a numeral with decimals (and not a text string with thousand-separators or spaces), the edit-question dialogue screen permits enforcing certain data formatting.

The dropdown in the edit-question dialogues screen can be set to require an integer (natural number, containing no decimals) or a numeral with decimals. In such case, the value to be entered may not contain thousand separators (or decimal, if applicable), prompting an error message during the questionnaire.