Lake Taal -Philippines

Taal Lake is a freshwater lake in the province of Batangas, on the island of Luzon in the Philippines. The lake fills a large volcanic caldera formed by eruptions between 500,000 and 100,000 years ago. That crater lake is the world’s largest lake on an island in a lake on an island, and it in turn contains its own small island, Vulcan Point.

Enjoy Watching! If you like the video, leave a comment below.

Share on Facebook

Exploring Bohol, Philippines

ChocolateHillsBohol is a smaller island in the island grouping of the Visayas, Philippines, a nice place to spend your holidays. Beside the famous chocolate hills and the trasier conservation area, the video shows Bolo knife forging, the Loboc river cruise with a local rondalla music group, dancing the traditional Tinikling dance, dolphin watching with a visit to Balicasag and Virgin island, as well as the Baclayon church, Tagbilaran market and the Hinigdanan cave in Dauis. Enjoy watching!

if you like the video, leave a comment below.

Share on Facebook

AHP template – numerical accuracy

Thanks to feedback from Mihail, here a few words about the numerical accuracy when using the AHP excel template.

AHP requires the calculation of the principal Eigenvalue, the weights are derived from the Eigenvector.  In my calculations I use the power method.  It is an iterative method, and  only one of several techniques that can be used to approximate the eigenvalues of a matrix.

Update 11.12.12

The whole calculation is shown in work sheet ’10×10′. I use 12 iterations; at the end of the sheet I do a check (the reverse calculation), using the Eigenvalue equation: (Aλ IX = 0,  with A the AHP matrix; λ the principal Eigenvalue, and X the estimated Eigenvector. The resulting check value in cell B33 shows the sum of all matrix element of the Eigenvalue equation using the iterated Eigenvector and Eigenvalue. Ideally it should be zero.

Update 9.5.14

From version 2014-05-09 onward the template shows the convergence of the power method, when calculating the eigenvalue. In the summary sheet a threshold (squared Euclidean distance d2) can be set, to show how many iterations it takes, until the change of the approximated eigenvector is below the given threshold. By default the value is set to Thresh: 1E-07. As the number of iterations in the template is fixed to 12, care should be taken if the value reaches 12.

Examples

Here a practical example comparing the results from the power method, as now implemented in my template, with  an example (7 criteria) given by Saaty in Int. J. Services Sciences, Vol. 1, No. 1, 2008 (p 86, table 2). The AHP matrix is:

1 9 5 2 1 1  1/2
 1/9 1  1/3  1/9  1/9  1/9  1/9
 1/5 3 1  1/3  1/4  1/3  1/9
 1/2 9 3 1  1/2 1  1/3
1 9 4 2 1 2  1/2
1 9 3 1  1/2 1  1/3
2 9 9 3 2 3 1

The result according Saaty is
(0.177,  0.019, 0.042, 0.116, 0.190, 0.129, 0.327) with consistency ratio of 0,022

The result from my AHP Excel template is
(0.1775, 0.0191, 0.0418, 0.1164, 0.1896, 0.1288, 0.3268) with CR 0f 0.022
exactly the same. The check value in sheet ‘8×8 is 4E-12.

You can find more examples here.

Please download the latest version with the improved accuracy from here.

 

 

 

Share on Facebook