effectively creating an effective system
Contact Information
Published: 11.02.2016 Last modified:11.02.2016

The program for efficiency calculation 2. Fast creation of a set of the same simple transactions


In the previous subject we have told you how to calculate the efficiency of simple economic transaction with use of the Efficiency_v2.16 program. Also we`ve learned about the cells of input of basic data.

In this topic we study the following elements on the Calculation form of efficiency of simple transactions.

There are:





Only if you have some transactions for comparison, the calculation of efficiency of simple economic transaction is interesting for you.

Therefore, when there is a need to estimate efficiency change tendencies, it is convenient to use such opportunities as a formation of massifs of simple transactions, the basic parameters of which are changing with the set step (or interval).

We can imagine, that we need to estimate efficiency of transactions, the “Expenses/Cost” of which are decreasing with the set step. But all other basic parameters are not changing. For example, we reduce expenses with a step 0,1. For this purpose we should enter figure 0,1 into a cell, that is opposite to a cell of “Expenses/Cost” (fig. 1).

Let`s enter values of the first transaction. For example, we have costs/expenses of $3, the gross profit of $4, and our transaction time is 2 days (fig. 2). We are already able to do it. And now we do a series of pressing of the “Enter” key. Thus, the automatic scanning of data input cells is carried out. If the focus of data input leaves a cell of “Expenses/Cost”, then the value of this cell will automatically reduce its value by a step 0.1. And when the focus of input leaves a cell of “Time operation”, the calculation of settlement indicators of transaction will be making in the program and the data will be transferred to the “Results table”.


Thus, you have to pay your attention, that transactions with the highest efficiency are displayed in the upper part of the Results table.

The data entry can be realized by clicking the “OK” button. But, if such data entry isn't convenient for you, you can do it by standard method.

If you clean a tick on option “Insert Record”, the table of results won't be filled in.

If you have pressed the button “Clear”, the data from the “Results table” will be removed.

Now we change a condition. The set interval will be added to value of our “Expenses/Cost”. For this purpose it is necessary to put tick in the small cell, that located above the cell of setting interval.

And then the cell “Time operation” will be focused automatically. And each time you press the “Enter” key, the data are placing in the “Results table” automatically.

Fig. 6

We have opportunity to make such operations of change of value with the given interval both with the “Profits”, and with the “Time operation” similarly.

It is also necessary to know that two or all three basic parameters you can change.

For example, we will raise the “Expenses/Cost” and the “Profits” at the same time. The result will be predictable. Our “Profits” will remain invariable, and “Expenses/Cost” will grow. So, “Efficiency” will decrease.

Fig. 7

We have sorted practically all elements of the Calculation form of efficiency of simple transactions for input and the measure calculation of simple transactions.

Next time we will know how the data of “Results table” and their processing we can unload in Excel for improving of visualization in the course of an efficiency assessment.

Contact Information