This article demonstrates how changes in commission amounts can be simulated by varying selected table-valued inputs. In example presented here, the math software Matlab is connnected with the Calculation Engine implemented with finaquant® calcs in order to:
Control the variation of selected inputs; Sales and Commission Scales.
Reporting: Visualize the resultant total commissions with plot diagrams.
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).
Parallel to field types of tables (text attribute, numeric attribute, key figure) there are three types of matrices and vectors:
Here are some examples for creating matrices, and making operations with them: Continue reading →
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.
You can now use the Table Functions of finaquant libraries in your code file: Continue reading →
Important update on 16. February 2019: Some links, and especially downloads links on this personal website may not be uptodate, as I recently transferred the whole site from www.finaquant.com to software.tuncalik.com.
Give me some time; I will check and correct them one by one.
I decided to offer all the software introduced on this website open-source and free.
Check my shared folder for most uptodate downloads. Open-Source downloads of the C#/.NET libraries Finaquant Calcs and Finaquant Protos are also included in this shared download folder as zipped Visual Studio 2012 files.
You may contact me if you need any help or consulting for my analytical software.