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:
| Name | Description | Usage | Result |
| Pow | Results in a specified number raised to the specified power. | Pow(3, 2) | 9d |
| Sqrt | Results in the square root of a specified number. | Sqrt(4) | 2d |
| Ceiling | Results in the smallest integer greater than or equal to the specified number. | Ceiling(1.5) | 2d |
| Max | Results in the larger of two specified numbers. | Max(1, 2) | 2 |
| Floor | Results in the largest integer less than or equal to the specified number. | Floor(1.5) | 1d |
| Min | Results in the smaller of two numbers. | Min(1, 2) | 1 |
| Round | Rounds 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 |
| Truncate | Calculates the integral part of a number. | Truncate(1.7) | 1 |
| Abs | Results in the absolute value of a specified number. | Abs(-1) | 1M |
| IEEERemainder | Results in the remainder resulting from the division of a specified number by another specified number. | IEEERemainder(3, 2) | -1d |
| Log | Results in the logarithm of a specified number. | Log(1, 10) | 0d |
| Log10 | Results in the base 10 logarithm of a specified number. | Log10(1) | 0d |
| Sign | Results in a value indicating the sign of a number. | Sign(-10) | -1 |
| Cos | Results in the cosine of the specified angle. | Cos(0) | 1d |
| Sin | Results in the sine of the specified angle. | Sin(0) | 0d |
| Tan | Results in the tangent of the specified angle. | Tan(0) | 0d |
| Acos | Results in the angle whose cosine is the specified number. | Acos(1) | 0d |
| Asin | Results in the angle whose sine is the specified number. | Asin(0) | 0d |
| Atan | Results in the angle whose tangent is the specified number. | Atan(0) | 0d |
| Exp | Results 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.
