Author: bpmsg

Strategic and Operational Business Performance

dashboardDecisions can have a short- or long-term impact; they can be strategic or operational. Measuring strategic or operational performance might require a different set of key performance indicators (KPIs). You need both: Operational KPIs help to measure the short term performance of an organization, strategic KPIs help to measure the implementation of a long term strategy.

This new podcast episode #13 explains the differences, using the picture of driving a car.

Updated AHP Excel Template Version 12.8.2013

Version 12-08-13 of the template allows for decimal input figures in the pairwise comparison sheets. It is now possible to enter a decimal value between 1 and 9 instead of integers 1 to 9. This simplifies the combination of templates, in case you need to extend to more than 20 participants.

This latest version also handles the different judgment scales for non-integer inputs.

Kindly let me know in case you find any problem with this new version. Feedback is appreciated always! You can download this latestes version from my AHP template download page.

New AHP Excel template with multiple inputs

The AHP Excel template works under Office Libre and Excel version MS Excel 2013. The workbook consists of 20 input worksheets for pair-wise comparisons, a sheet for the consolidation of all judgments, a summary sheet to display the result, a sheet with reference tables (random index, limits for geometric consistency index GCI, judgment scales) and a sheet for solving the eigenvalue problem when using the eigenvector method (EVM). Latest version: 2022-07-08.

Alternative for complex AHP projects: AHP free online software.

Excel Template

  • Within the input worksheets (questionnaires) priorities are calculated using the row geometric mean method (RGMM).
  • Three consistency indices (the consistency ratio CR, the geometric consistency index GCI and overall dissonance Psi) are calculated. The level of consistency needed (α) is implemented as a variable input field in the summary sheet, and can be set between zero and one.
  • If CR exceeds α, the top 3 inconsistent pair-wise comparisons on the input sheets are highlighted, to allow the participants an adjustment of their judgments. The judgment resulting in lower inconsistency is proposed.
  • Final priorities are shown in a summary sheet; their calculation is based on the eigen vector method (EVM). For the solution of the eigenvalue problem the power method algorithm is applied with a fixed number of 20 iterations.
  • Different judgment scales are implemented.
  • Errors of the EVM and RGMM are show beside the calculated priorities.
  • Either individual participants, or an aggregation of individual judgments (AIJ) based on the weighted geometric mean of all participants’ judgments can be selected.

Limitations

  • The template does not include the hierarchy of the decision problem and the final aggregation of weights, i.e. it is only suitable for finding the weights in each category or sub-category. For the definition of a hierarchy and evaluation of alternatives see here.
  • Sensitivity analysis of the final result is not included.

How to use the template?

A detailed description (pdf) is attached in the download file.

Reference

When you use the template for your research, please make a reference to the author’s paper.

Please cite:
Klaus D. Goepel, (2013). Implementing the Analytic Hierarchy
Process as a Standard Method for Multi-Criteria Decision Making In
Corporate Enterprises – A New AHP Excel Template with Multiple Inputs, Proceedings of the International Symposium on the Analytic Hierarchy Process, Kuala Lumpur 2013. DOI: https://doi.org/10.13033/isahp.y2013.047

Download

Download AHP Excel Template Version 2022.07.08 (zip)

Please consider a donation, it will help me to maintain the website and program. An explanation of AHP (Analytic Hierarchy Process) is given in my video here. For terms of use please see our user agreement and privacy policy.

Your comments are always welcome!

Making your wordpress blog more secure

You find the individual steps easily in a web search. Most critical is the change of SQL table prefixes. I did it manually using phpMyAdmin. When finished, no link was working any longer. Reason: permalinks were set to %postname%. After switching first to default and then back to %postname% everything was fine.

I also struggled with the password protection. Inportant: add the line ErrorDocument 401 default, otherwise you might always get the “page not found” message.

Steps to do:

  • Move config.php file one directory above wordpress installation directory
  • Remove admin user
    (create new user with full rights and delete old user)
  • Protect wp-admin and wp-includes directories
    (read for owner and group only = 751)
  • Hide wordpress version and login error messages
    Add in functions.php (in your ChildTheme directory):
    <?php remove_action(‘wp_head’, ‘wp_generator’);
    add_filter(‘login_errors’,create_function(‘$a’,”return null;”)); ?>
  • Delete readme.html file from web root directory
  • Password protect wp-admin directory (I used CPanel to create .htaccess).
    Modify .htaccess file in wp-admin – add:
    ErrorDocument 401 default
  • Modify .htaccess file in web root:
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ – [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>
  • SQL: change prefixes of database tables from
    “wp_”  to “new_prefix_”

BPMSG – One Year On-line

After being on-line with the website for 1 year, it’s time to change the entry page!

Here, on BPMSG.com you will find a couple of interesting articles related to business performance management, from a more practical than theoretical point of view.

Topics covered range from

A new topic was introduced just recently: “Value-driven leadership”. I started with a general article, and added a personality profiling tool (NEO-select). If interested, you might participate and send back the completed questionnaire to get a full report.

In the section other stuff  I post other interesting information, not fitting to the main topic of the site. For example a nice video of the olive-backed sunbird, a review of the Sennheiser Bluetooth Headset etc.

BPMSG stands for Business Performance Management Singapore. As of now, it is a non-commercial website, and information is shared for educational purposes. Please see licensing conditions and terms of use.

Please also be so kind, if you use parts in your web-site or blog, to give credit and a link to my site. I hope you will find some useful information, let me know your feedback or contact me directly for any suggestions.

Klaus Goepel, Mar 2012

about the author

NEO-select leadership value profiling

NEO-select personality profiling is a tool to get a better insight in the different strengths of individuals. The inventory is developed based on the model of the big five dimensions of personality, and is conducted as a self-reporting assessment. Using a combination of selected facets in these dimensions, a ranking of leadership values is derived. It will give you a better insight in your behavior, and the driving values behind it.

You might download the questionnaire and the quick guide, how to fill below.

Fill out the questions, and you will get an immediate quick report of your levels and rankings in the broad five personality dimensions. The questions are available in English and German language. As a result you will get a quick and very simple summary.

To receive the full report – with much more detailed information – simply submit the completed questionnaire to the author.

Important note:

  1. Unzip the downloaded file into a working directory.
  2. Open Excel and load the xls file from there.
  3. The questionnaire is realized in Excel, and requires Macros to run for the control of the answering flow: enable macros.
  4. Once all questions are answered, the file will be stored under the exact same name in the same directory. (Don’t worry, your answers are saved)
  5. Submit the Excel file to the author and receive the full report.

If you don’t use a Microsoft environment, a simple spreadsheet version is available on request.

;