Author Archives: tuncalik

Travel and Assignment Planning Software in Python

From 8/2015 to 5/2018 I worked for a Swiss company named ETC Transport Consultants as senior data analyst and developer on a part-time basis (60%). Within this time period, in less than three years, I developed a complete solution for … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Top-Down Distribution of Quality Measurement Requirements using Table Functions in Python

Introduction Since August of 2015 I have been working for ETC Transport Consultants1 in Switzerland as Senior Data Analyst and Developer on a part-time basis. My job is developing a complete software solution for Travel Planning & Resource Optimization in … Continue reading

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

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