Category Archives: Calculation engine

Calculation engines and frameworks

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

Empowering Excel with Table Valued Functions

We are currently working on an Excel add-in named Finaquant in Excel that will make all the Matrix, Vector and most importantly, Table Valued Functions of finaquant libraries available for Excel users and programmers (macro, VBA). Table Valued Functions will … Continue reading

Posted in Calculation engine | Tagged , | 5 Comments