Category Archives: Calculation engine

Calculation engines and frameworks

A Simple Notation for Data Tables

We use the simple notation introduced here for data tables in order to formulate: Information and reporting requirements Analytical operations on data tables This table notation can generally be used for requirement engineering. I will use the same notation in … Continue reading

Posted in Calculation engine | Tagged , , | Leave a comment

Calculating Sales Commissions in Excel

In a previous article I explained how sales commissions with tiered rates and product groups can be calculated using the table-valued functions of our .net library Finaquant Calcs. In this article, I will explain how sales commissions can be calculated … Continue reading

Posted in Calculation engine | Tagged , , , , | Leave a comment

How to Add a User-Defined Table Function to Excel

Finaquant’s Excel add-in (Finaquant in Excel) comes with a list of table-valued functions like Table Arithmetics, Combine Tables, Filter Table, Aggregate Table, Distribute Table, and so on. You can however extend this list with your own user-defined table functions. Following … Continue reading

Posted in Calculation engine | Tagged , , | Leave a comment

How to Apply a User-Defined Function on Rows of a Table in Excel

Though simple in use, Transform Rows with UDF (User-Defined Function) is one of the most powerful and versatile table functions. With this function you can manipulate every field of a table row as function of all other fields. A user-defined … Continue reading

Posted in Calculation engine | Tagged , | Leave a comment