Jaanbi
Sunday, April 04, 2010
MultiDimensional Scaling (MDS) with Solver
›
This file creates the Solver model for multidimensional scaling (see a previous post on MDS in Excel/VBA). The application calculates MDS ...
50 comments:
PROXIMUS with Solver
›
This file creates an approximation of a matrix (using PROXIMUS – see a previous post on Koyutürk’s PROXIMUS) using Solver.
McCormick’s Bond Energy Algorithm (BEA) in Excel/VBA
›
This file contains an implementation of a classic seriation algorithm by McCormick, Schweitzer and White ( Problem Decomposition and Data ...
1 comment:
Approximating matrices with PROXIMUS in Java
›
This file is an application of Mehmet Koyutürk’s algorithm PROXIMUS – an efficient framework for error-bounded compression of high-dimens...
Sometimes, it would just be better to switch to VBA :)
›
This file contains vehicle routing paths (a solution to the two truck problem a few posts back), as a Trendline’s Microsoft Excel Solve...
1 comment:
A Solver model for a transportation problem that finds a location for an additional factory – using 625 changing cells :(
›
In this file a location for an additional factory has to be determined. It cannot be built on an existing location, goods can only ...
A transportation model with two trucks in Solver
›
This model uses flow balance constraints as well as Boolean variables.
1 comment:
Tuesday, March 30, 2010
Estonian peasants forming Bucket Brigades
›
Java applet demo This Scratch file demonstrates the use of bucket brigades – ...
Spacefilling curves approximating TSP in Java
›
This file contains an algorithm that calculates a spacefilling curve – a means for mapping a high-dimensional space in a low-dimensiona...
A heuristic solution for a knapsack problem: using Excel’s VBA to optimize a sequence of Solver problems
›
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 ...
69 comments:
Multinational Corporations practice transfer pricing: lets try to fit that into a Solver/Excel network optimization model
›
The foundation of this Solver model is a classical operations research problem on network optimization. There is a certain capacity in th...
1 comment:
For business students: Monte Carlo method demystified with Excel/VBA
›
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...
Another tentative candidate for the Excel Gurus Gone Wild: Do the Impossible with Microsoft Excel book: Convert a two-dimensional table/matrix into a column or row vector and vice versa :)
›
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...
59 comments:
Demos of Excel/VBA graphical capabilities based on NetLogo – a programmable modeling environment for simulating natural and social phenomena –: the world of rock-paper-scissors and the dynamics of bird flocks
›
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 in Excel/VBA, applied for reducing dimensions of colors and of financial ratios from Google Finance
›
Kohonen’s Self Organizing Maps ( SOM ) is a type of artificial neural network that is trained using unsupervised learning. The number...
5 comments:
Principal Component Analysis of a U.S. city distance matrix in Excel
›
Principal Component Analysis ( PCA ) transforms a number of correlated variables into a smaller number of uncorrelated variables –...
1 comment:
A primitive try at testing graph isomorphism in Excel/VBA
›
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...
1 comment:
A set of pictures that I use for explaining Singular Value Decomposition (SVD)
›
According to finite-dimensional spectral theorem , a symmetric matrix has orthonormal eigenvectors, thus Q*Q T =I and Q T =Q -...
Using Singular Value Decomposition (SVD): Excel/VBA application that reads a BMP file and compresses it in a lossy way
›
(See the post on SVD for keywords.) This application begins by reading a BMP file – BMP format is chosen as pictures therein are stored...
1 comment:
Correspondence Analysis in Excel: the semantic differential of words according to Enron email dataset.
›
(See the post on Singular Value Decomposition for keywords.) After the bankruptcy of Enron , a $100 billion sales, 22 000 employee compa...
MultiDimensional Scaling (MDS) in Excel/VBA
›
Information visualization technique multidimensional scaling ( MDS ) has its roots in the field of psychometrics and is used for explor...
Using Singular Value Decomposition (SVD) to factorize data on car properties
›
This file has data on five cars: Chevrolet Matiz, Chevrolet Evanda, Chevrolet Tacuma, Chevrolet Nubira, Chevrolet Kalos. The proper...
Haar wavelet transform in VBA and in Excel
›
This file does Haar transform in VBA and in Excel.
19 comments:
Inverse of a matrix in Excel/VBA
›
This file finds the inverse matrix in VBA, using Gauss-Jordan elimination.
PA=LU factorization of a matrix in Excel/VBA
›
This file performs the PA=LU factorization ( LU decomposition with partial pivoting ).
1 comment:
Ulam spiral and the prime numbers in Excel/VBA
›
This file draws the Ulam spiral in Excel and colors the prime numbers.
Stephen Wolfram’s A New Kind of Science: a set of cellular automatas in Excel/VBA
›
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...
Wednesday, January 10, 2007
Normal distribution of stock's rate of return resulting in a log-normal distribution of stock prices
›
When we aggregate the returns of the stocks of a market, we can compute its mean return and the corresp7onding standard deviation. Our g...
Saturday, October 28, 2006
C Add-Ins in Excel: Performance Comparison with VBA
›
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...
1 comment:
S.M. Johnson: production schedules - in VBA
›
Amongst mathematical algorithms taught to business students one was devised by S.M. Johnson back in 1954. The issue is having two differe...
6 comments:
ANN solving XOR in VBA
›
Here is a feedforward, multiconnectivity, Sigmoid transfer function, backpropagation, multi layer perceptron Artificial Neural Netwo...
5 comments:
Traveling Salesman Problem (TSP) in Excel/VBA. The use of graphics in Informatics II class
›
The most advanced topic that has been addressed in our Informatics II for non-IT students: VBA, class is the Traveling Salesman Prob...
51 comments:
Gauss-Jordan elimination in Excel/VBA. The use of matrix problems in Informatics II class
›
In our undergraduate Informatics II: VBA for non-IT students, class we do many computations on matrices – in order to let students reason...
2 comments:
Friday, October 27, 2006
NPV and IRR in Execl/VBA
›
In our undergraduate Informatics II: VBA for non-IT students, class the financial indicator Net-Present-Value is programmed. This program ...
1 comment:
Home
View web version