ACE4J Review

I. Software Description The Adaptive Calculation Engine for Java ACE4J provides a reliable platform for converting Excel-based applications into web applications at a low cost, efficiently, and with guaranteed easy maintenance and support in the future. At the same time ACE4J is a modern formula language based on a robust and efficient calculation engine, that is capable of evaluating complex Excel formulas. This engine is completely independent from the Microsoft Excel spreadsheet paradigm and does not require I/O operations. Thus it is also a great tool for new Java based Web applications that require heavy calculations. II. What is ACE4J ACE4J is a Java library providing a comprehensive API to evaluate complex Excel-like formulas. III. Product Features 1) Implementation of 60+ Excel operators and functions including all latest functions such as XLOOKUP, XMATCH, SWITCH etc. 2) Full implementation of the groundbreaking Excel LAMBDA functions, “the ultimate Excel worksheet functions.” This includes recursive Lambda functions without Excel limitations. 3) Iterative Calculations One of the major missing pieces in Excel formulas is the ability to loop, to repeat over a set of logic at a dynamically defined interval. Recursive LAMBDA functions address this to a point but the proprietary ACE4J FormulaIterator technology turns iterative calculations into a straightforward task. 4) User Defined Functions Users can write customary functions in Java and seamlessly integrate them into the ACE4J using the proprietary ACE4J UDFLocator technology such that they will work in the exact same way as the ACE4J built-in functions. 5) Calculation Context The ACE4J CalculationContext class is built with the Jackson library annotations so it can be represented by a JSON data structure. This is convenient for building calculation services.