Finaquant’s Matrix and Vector Functions

Both of our .NET libraries finaquant® protos (non-commercial) and finaquant® calcs (commercial) contain Matrix and Vector functions in addition to Table Functions. In fact, table functions are higher level constructs that are based on matrix and vector functions of the library.

You may find examples for Matrix and Vector functions in the Visual Studio file FinaquantCalcsStarter (or FinaquantProtosStarter) that you can download at the corresponding product page (see related downloads).

Visual Studio file FinaquantCalcsStarter

Parallel to field types of tables (text attribute, numeric attribute, key figure) there are three types of matrices and vectors:

  1. KeyMatrix/KeyVector (double)
  2. NumMatrix/NumVector (integer)
  3. TextMatrix/TextVector (string)

Here are some examples for creating matrices, and making operations with them: Continue reading

Posted in Calculation engine | Tagged , | Leave a comment

Table Function Demo with Microsoft Excel

As mentioned earlier in a related article Table Functions of the .NET libraries finaquant® calcs (commercial) or finaquant® protos (non-commercial) can be called from an excel sheet.

Following example demonstrates:

  • How Table Functions can be called from excel macros (VBA)
  • Generally, excel-.NET integration: How C#/.NET methods can be called from within excel macros (VBA)
  • How data tables in excel worksheets can be read and written by C#/.NET methods
  • How simple parameters (string, integer, double) can be passed from excel macros to C#/.NET

Calling Table Functions from Excel

In order to run the demo with excel:

  1. Download and install finaquant® calcs, Calculation Engine based on Table Functions.
  2. Download and open the Visual Studio file CalcsExcelIntegration as Administrator (Right-mouse MS Visual Studio, Run as Administrator).
  3. Build (or rebuild if you have already built) the VS project (ensure “Register for COM interop” is checked as build option under Project Properties).
  4. Open the excel file names CalcsExcelDemo (double click) under the folder named Resources in CalcsExcelIntegration.

Continue reading

Copyright secured by Digiprove © 2013 Tunc Ali Kütükcüoglu
Posted in Calculation engine | Tagged , , | 1 Comment

Table Functions in Visual Basic (VB.net)

Table Functions of our .NET (dot net) libraries finaquant® protos (non-commercial) or finaquant® calcs (commercial) can be called in other .NET languages including Visual Basic.

The ability to call Table Functions in Visual Basic can make the transition from VBA (Visual Basic for Applications) macros to .net easier for excel user, as the syntax of VBA is similar to syntax of VB.net.

In order to use Table Functions in Visual Basic, first add a new project of type Visual Basic Console Application in Visual Studio.
Add a new console application project  in Visual Studio

You can now use the Table Functions of finaquant libraries in your code file: Continue reading

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

Commission Calculation with finaquant® calcs

Dealer, sales or any other kind of commissions can be calculated quite easily with the table functions of the .net library finaquant® calcs, as the following example will demonstrate.

In this article we explain:

  1. Basic transaction-based (sales data) commission scenario
  2. How commissions can be calculated with the table functions
  3. How input data can be fetched from external databases
  4. How periodic commission calculations can be automated

Commission Scenario

  • Dealers receive sales commissions proportional to their sales totals for each product group in a quarter.
  • Product groups (or pools) can be defined by category or individual products for each dealer.
  • The commission scale with tiered rates (class or level scale logic) for each product group (or pool) determines the amount of commissions to be paid.

Data Flow & Calculation

Data Flow & Commission Calculation

All input tables are fetched from an external database using the event functions of Calculation Nodes that are triggered before any input table is read from the Generic Database. Continue reading

Copyright secured by Digiprove © 2013 Tunc Ali Kütükcüoglu
Posted in Fee and commission calculations | Tagged , | Leave a comment