Jaanbi

This file creates the Solver model for multidimensional scaling (see a previous post on MDS in Excel/VBA). The application calculates MDS ...

This file creates an approximation of a matrix (using PROXIMUS – see a previous post on Koyutürk’s PROXIMUS) using Solver.

This file contains an implementation of a classic seriation algorithm by McCormick, Schweitzer and White ( Problem Decomposition and Data ...

This file is an application of Mehmet Koyutürk’s algorithm PROXIMUS – an efficient framework for error-bounded compression of high-dimens...

This file contains vehicle routing paths (a solution to the two truck problem a few posts back), as a Trendline’s Microsoft Excel Solve...

In this file a location for an additional factory has to be determined. It cannot be built on an existing location, goods can only ...

This model uses flow balance constraints as well as Boolean variables.

Java applet demo This Scratch file demonstrates the use of bucket brigades – ...

This file contains an algorithm that calculates a spacefilling curve – a means for mapping a high-dimensional space in a low-dimensiona...

Suppose we have to bill our business partner in the total amount of $500 000, but it’s our policy, that one invoice contains no more than ...

The foundation of this Solver model is a classical operations research problem on network optimization. There is a certain capacity in th...

As I did my bachelor’s degree in the faculty of Economics and Business Administration of the University of Tartu , the topic of Monte Carl...

In spreadsheet modeling one often has to convert a two-dimensional table into a row or column vector and vice versa. This Excel file does...

This program is a demo of graphical capabilities that Excel has. A famous game of rock-paper-scissors forms the basis of our simulated...

Kohonen’s Self Organizing Maps ( SOM ) is a type of artificial neural network that is trained using unsupervised learning. The number...

Principal Component Analysis ( PCA ) transforms a number of correlated variables into a smaller number of uncorrelated variables –...

When we consider an adjacency matrix of a graph, each entry shows the presence of an arc between the nodes. Taking the matrix to the powe...

According to finite-dimensional spectral theorem , a symmetric matrix has orthonormal eigenvectors, thus Q*Q T =I and Q T =Q -...

(See the post on SVD for keywords.) This application begins by reading a BMP file – BMP format is chosen as pictures therein are stored...

(See the post on Singular Value Decomposition for keywords.) After the bankruptcy of Enron , a $100 billion sales, 22 000 employee compa...

Information visualization technique multidimensional scaling ( MDS ) has its roots in the field of psychometrics and is used for explor...

This file has data on five cars: Chevrolet Matiz, Chevrolet Evanda, Chevrolet Tacuma, Chevrolet Nubira, Chevrolet Kalos. The proper...

This file does Haar transform in VBA and in Excel.

This file finds the inverse matrix in VBA, using Gauss-Jordan elimination.

This file performs the PA=LU factorization ( LU decomposition with partial pivoting ).

This file draws the Ulam spiral in Excel and colors the prime numbers.

This file(and this ) uses VBA or Excel’s formulas to operate Stephen Wolfram’s cellular automatas from his book A New Kind of Science...

When we aggregate the returns of the stocks of a market, we can compute its mean return and the corresp7onding standard deviation. Our g...

As Excel is also applied in order to solve industry level business problems, and as therein the speed will be of the essence, the choice o...

Amongst mathematical algorithms taught to business students one was devised by S.M. Johnson back in 1954. The issue is having two differe...

Here is a feedforward, multiconnectivity, Sigmoid transfer function, backpropagation, multi layer perceptron Artificial Neural Netwo...

The most advanced topic that has been addressed in our Informatics II for non-IT students: VBA, class is the Traveling Salesman Prob...

In our undergraduate Informatics II: VBA for non-IT students, class we do many computations on matrices – in order to let students reason...

In our undergraduate Informatics II: VBA for non-IT students, class the financial indicator Net-Present-Value is programmed. This program ...