Blog

Wednesday, October 17, 2012

WordCalc

Description

WordCalc is a Word 2013 app that can solve mathematical expressions within a Word document. It supports following functions and operators:

Operators: +, -, *, /, and ^
Functions: sin, cos, tan, asin, acos, atan, sqrt, abs, floor, ceil, log, min, max, and avg

The functions min, max and avg takes 2 arguments. The input to trigonometric functions is assumed to be in radians. All functions are case insensitive.

How to use


To perform mathematical calculations:
1.      Type a mathematical expression in the Word document or the textbox provided.
2.      Select the expression from the Word or press enter while entering in textbox.
3.      Find the expected answer in the results window at the top of the app.
 
Refer to snapshots below indicating usage:


Result box highlighted in red

Select the expression in word:
Selected expression in Word 2013
 

Note: In case of a scroll, computed results will be displayed at the top of the list.

Example Usage


Refer to the table below for a reference to the possible operators and functions:

Operator or Function
Description
Expression
Output
+
The plus symbol is a binary operator that is used to calculate the sum of the two numbers.
5 + 5
5 + 5 = 10
-
The minus symbol can act as binary and unary operator. This operator is used to calculate difference between 2 numbers
4-2,
10+-2
4-2=2,
10+-2=8
*
The star operator is binary operator that is used to multiply 2 numbers.
2*3
2*3=6
/
The forward slash symbol is division operator. An attempt to divide by zero will result in “Divide by zero error”.
3/2
3/2=1.5
^
The carat symbol is power operator. a^b calculates b times a.
3^2
9
Sin
The function calculates sine of the input. The input is assumed to be in radians.
Sin(1.57)
Sin(1.57) = 0.9999996829318346
Cos
The function calculates cosine of the input. The input is assumed to be in radians.
Cos(1.57)
Cos(1.57) = 0.0007963267107332633
Tan
The function calculates the tangent of the input. The input is assumed to be in radians.
tan(3.14/4)
 
tan(3.14/4) = 0.9992039901050427
Asin
The function calculates arc sine or inverse sine of the input.
Asin(0.99)
aSin(0.99) = 1.4292568534704692
Acos
The function calculates arc cosine or inverse cosine of the input.
Acos(0.9920)
acos(0.9920) = 0.12657558596272397
Atan
The function calculates arc tangent or inverse tangent of the input.
Atan(0.9920)
atan(0.9920) = 0.7813821207316063
Sqrt
The function calculates square root of positive numbers. For negative numbers it returns “NaN” which means it is not a number.
Sqrt(2)
sqrt(2) = 1.4142135623730951
Abs
The function calculates absolute value of the input.
Abs(-2.33)
abs(-2.33) = 2.33
Floor
The function calculates largest integer less than the input.
Floor(2.33)
Floor(2.33) = 2
Ceil
The function calculates smallest integer larger than the input
Ceil(2.34)
 
Ceil(2.34) = 3
Log
The function calculates natural log of the input.
Log(10)
Log(10) = 2.302585092994046
Min
The function calculates minimum of 2 numbers.
Min(1,2)
Min(1,2) = 1
Max
The function calculates maximum of 2 numbers.
Max(9,10)
Max(9,10) = 10
Avg
The function calculates average of 2 numbers.
Avg(3,2)
Avg(3,2) = 2.5

Note: All functions are case insensitive. 

Error Messages


In the case of malformed expressions or errors in calculations, app will show an error message. Refer to the table below for possible error messages:

Error Message
Explanation
Divide by zero error.
This error is shown when there is an attempt to divide by zero in the equation.
Selected expression has missing parenthesis.
This error is shown when the round parenthesis are not balanced.
Insufficient Parameters.
This error is shown when the operator does not have enough parameters to compute the results. For example, 1+ would result in this error.
Selected token X is not valid.
This error is shown when the App is not able to parse the character X.
NaN
This error is shown when the result is not a number. For e.g. sqrt(-1) is imaginary and will result in NaN.
Infinity
This error is shown when the result is too large.


For any feedback please mail support@maqsoftware.com
Powered by Blogger.

Twitter