The calculate library is a class library that allows extensive calculation support to be added to business objects. It includes a function library of more than 400 Excel-compatible functions, covering database, date and time, engineering, financial, information, logical, lookup and reference, math and trigonometry, statistical, text, and web functions.
Provides support to parse and compute a string as a mathematical expression and return results.
CalcQuickBase provides support to register variables and compute formulas based on them. It also provides support to autocalculate the values when the variable value changes.
Calculate provides calculation support to arbitrary business objects such as data in row and column formats like Excel, data grid, and more through an ICalcData interface. It also provides support to autocalculate the values when business object values are changed. It even provides support to register named ranges like Excel and calculate formulas based on them.
The calculation engine is preloaded with more than 400 Excel-compatible functions covering a broad range of business scenarios. The available functions range from standard mathematical functions such as cosine and sine, to statistical functions like averages and standard deviations, and even financial functions like declining balance and future value.
The calculation engine provides support to incorporate custom functions.