Introduction

The AHORNsimple (An Application of Excel-Based AHP methOd to solve multiple criteRia raNking problems - simple version) is an application designed on principles of Analytic Hierarchy Process - AHP (Saaty, T.L., 1980. The Analytic Hierarchy Process. Planning, Priority setting, Resource allocation. McGraw-Hill, New York) to support decision process while multiple criteria ranking problem is considered. AHORNsimple is a registered trademark (Registration: EUTM 018143131).

AHORNsimple(TM) can support solution of a complex decision problems limited to 9 criteria and 9 alterna-tives. Simple version means that subcriteria are not aplicable there. The possibility of considering up to 9 criteria and 9 alternatives is intentional. Based on Miller’s research in a psychology domain Saaty has proved that a human qualitative distinction is practically meaningful if the number of simultaneously compared items is limited to 7 ± 2. 

The AHORNsimple(TM) is an application designed in Microsoft Excel environment, which makes it operatio-nally useful regardless of the operating system the user is working on. It also does not require any installation procedures; it is ready for use. For more practical information regarding  please refer to section Manual, see below.

A methodological background

Analytic Hierarchy Process (AHP) is a complex methodology proposed by Thomas L. Saaty in 80. of the last century (Saaty, T.L., 1980. The Analytic Hierarchy Process. Planning, Priority setting, Resource allocation. McGraw-Hill, New York). The principles of AHP are based on utility theory and this method is applied to solve multiple criteria ranking problems.

The authors

The AHORNsimple(TM) is a professional application designed by Piotr Sawicki and Hanna Sawicka. They are researchers of Poznań University of Technology, Poznań, Poland. Both authors are also co-founders of Virtual DECISION Lab, see more details in the section Contact. 

The concept of AHORNsimple(TM) and its first release was designed in early 2003, which was called AHP Excel.

Terms of use

The AHORNsimple(TM) is free of charge for all non-commercial purposes. This is an open access application under the CC BY-NC-ND license, for more details please visit: http://creativecommons.org/licenses/by-nc-nd/4.0/

Download

Here you can download AHORNsimple (TM) free of charge, under CC BY-NY-ND license (see section Terms of use). Please let us know your opinion and result of professional application of AHORNsimple(TM). We will be happy if you share your experience with us and tell us the effects of your work using the AHORNsimple(TM).

AHORNsimple
version: 1.0 | published: 2020/05/07 | type: xlsx

Manual

A detailed description of the procedure how to use the AHORNsimple(TM) is included in the Manual. Please read it carefully before start using this application.

Manual - How to use AHORNsimple to support multiple criteria decision process?
published: 2020/05/07 | type: pdf

References

Please find below a list of references to the practical application of the AHORNsimple(TM) application.

_research papers

Piotr Sawicki, Hanna Sawicka. Combined Optimisation and MCDA Based Solution of the Tram Depot Location Problem. Archives of Transport, 2021, 60(4), 87-103. doi: https://doi.org/10.5604/01.3001.0015.5970 (see the paper).

_MSc and BSc theses

Julia Andryszak. Assesing the Feasibility of Introducing the Transport of Medicines by Unmanned Aerial Vehicles. MSc Thesis. Poznan University of Technology, Faculty of Civil and Transport Engineering, Poznan, 2023 (in Polish). The thesis supervised by Wojciech Karpiuk.

Patrycja Stanek. Multicriteria Evaluation of Transport Services Provided on the Germany-Poland Route on the Example of Logistics Company. MSc Thesis. Poznan University of Technology, Faculty of Civil and Transport Engineering, Poznan, 2023 (in Polish). The work supervised by Hanna Sawicka.

Filip Markiewicz. Evaluation and Selection of a Park & Ride Car Park Location in the Western Part of Poznań. BSc Thesis. Poznan University of Technology, Faculty of Civil and Transport Engineering, Poznan, 2022 (in Polish). The thesis supervised by Hanna Sawicka.

Karolina Zapadka. Improvement of a Public Transport in a Selected Area of Gdańsk. BSc Thesis. Poznan University of Technology, Faculty of Civil and Transport Engineering, Poznan, 2021 (in Polish). The thesis supervised by Hanna Sawicka.

Mateusz Szczygiecki. Multicriteria Evaluation of Transport Tasks Carried Out in the Transport Company. BSc Thesis. Poznan University of Technology, Faculty of Civil and Transport Engineering, Poznan, 2021 (in Polish). The thesis supervised by Hanna Sawicka.

Vatsal Barot. Evaluation of the Services Offered by Selected Public Transportation Companies. MSc Thesis. Poznan University of Technology, Faculty of Civil and Transport Engineering, Poznan, 2020. The thesis supervised by Hanna Sawicka.