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

Anatomy of Table Addition

With the following examples we want to demonstrate the practicality and versatility of table functions related with various addition operations.

These examples may also provide our readers with a general idea about the logic of table functions included in our .net libraries finaquant® protos (non-commercial) and finaquant® calcs (commercial).

Let’s begin with the simplest case.

How to add a scalar number to all key figures of a table

using FinaquantCalcs;
...
ResultTable = CostTable + 500;
MatrixTable.View_MatrixTable(ResultTable, "CostTable + 500");

Adding a scalar number to all key figures of a table

What if you want to add a scalar not to all key figures, but only to a selected one? Continue reading

Copyright secured by Digiprove © 2013 Tunc Ali Kütükcüoglu
Posted in Calculation engine | Tagged | Leave a comment