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.

Share on Facebook

Combined Performance Index – Slides

Slides of my video presentation Combined Performance Index as pdf document:

Download Slides (pdf) download

Share on Facebook

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.

Share on Facebook

New AHP Excel template with multiple inputs

The AHP template works under Windows OS 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). Information about the latest version 2016.05.04.

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).
  • Two consistency indices (the consistency ratio CR and the geometric consistency index GCI) 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 12 iterations.
  • Different judgment scales are implemented.
  • 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 is given in the pdf document here: AHPcalc-v2017-03-29.pdf

Reference

Please always make a reference to the author and website.

Download

Download AHP Excel Template Version 2016.05.04 (zip) download

For terms of use please see our user agreement and privacy policy.

Please consider a donation, it will help me to maintain the website and program:

Your Donation (1 Singapore Dollar is approx. 0.7 USD):



An explanation of AHP (Analytic Hierarchy Process) is given in my video here.

Your comments are always welcome!

Incoming search terms:

  • ahp model excel
  • ahp calculator excel
  • ahp questionnaire example
  • ahp questionnaire template
  • ahp questionnaire format
  • ahp questionnaire sample
Share on Facebook

Combined Performance Index – Example in Excel

Here you find a simple example, how to realize the calculation of a combined performance index in an Excel sheet.

Download the excel sheet:  Comb_Index.xlsx

Incoming search terms:

  • how to calculate composite index in excel
Share on Facebook

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_”
Share on Facebook