Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Applications

2006 ◽  
Vol 21 (12) ◽  
pp. 1695-1710 ◽  
Author(s):  
K.M. Hyde ◽  
H.R. Maier
Keyword(s):  
Decision Analysis ◽  
Uncertainty Analysis ◽  
Visual Basic ◽  
Stochastic Uncertainty ◽  
Multi Criteria Decision Analysis ◽  
Visual Basic For Applications

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

scholarly journals Multi-Criteria Framework for Selection of City-Wide Sanitation Solutions in Coastal Towns in Northern Angola

2021 ◽  
Vol 13 (10) ◽  
pp. 5627
Author(s):  
Rita Ventura Matos ◽  
Filipa Ferreira ◽  
Liliana Alves ◽  
Elsa Ramos ◽  
Lucrécio Costa ◽  
...  
Keyword(s):  
Decision Analysis ◽  
Analysis Tool ◽  
Planning Stage ◽  
Multi Criteria Decision Analysis ◽  
Sanitation Services ◽  
Decision Aiding ◽  
Coastal Cities ◽  
Sub Saharan ◽  
Multi Stakeholder ◽  
Treatment Alternatives

In this paper, an expedited multi-criteria decision analysis framework, capable of tackling several dimensions for the choice of sanitation services, at an early planning stage is presented. The approach combines geographic information systems aided analysis for onsite solutions, with a multi-criteria decision analysis tool capable of suggesting and ranking several viable offsite treatment alternatives, according to the desired criteria. The framework was applied to four coastal cities in Northern Angola, one of the sub-Saharan countries of the west coast of Africa, thus obtaining an indication for city-wide solutions, as an aid to achieve the goal of ensuring full sanitation coverage in those four locations. It included possible onsite collection and storage interfaces, namely Ventilated Improved Pit latrines, fossa alterna, septic tanks or conventional sewer systems. The study also contributed to an informed decision regarding optimal offsite treatment facility type, namely based on dedicated or combined wastewater and faecal sludge treatment (co-treatment), as well as different options for locations and sanitation technologies. Alternatives were compared and ranked according to ten main criteria concerning social, economic, technological and environmental aspects. This work helped demonstrate the usefulness of decision-aiding tools in the multi-stakeholder and complex context of sanitation in a developing country.

scholarly journals An Innovative Grey Approach for Group Multi-Criteria Decision Analysis Based on the Median of Ratings by Using Python

Axioms ◽  
2021 ◽  
Vol 10 (2) ◽  
pp. 124
Author(s):  
Dragiša Stanujkić ◽  
Darjan Karabašević ◽  
Gabrijela Popović ◽  
Predrag S. Stanimirović ◽  
Florentin Smarandache ◽  
...  
Keyword(s):  
Decision Making ◽  
Decision Analysis ◽  
Likert Scale ◽  
Decision Makers ◽  
Interval Numbers ◽  
Multi Criteria Decision Analysis

Some decision-making problems, i.e., multi-criteria decision analysis (MCDA) problems, require taking into account the attitudes of a large number of decision-makers and/or respondents. Therefore, an approach to the transformation of crisp ratings, collected from respondents, in grey interval numbers form based on the median of collected scores, i.e., ratings, is considered in this article. In this way, the simplicity of collecting respondents’ attitudes using crisp values, i.e., by applying some form of Likert scale, is combined with the advantages that can be achieved by using grey interval numbers. In this way, a grey extension of MCDA methods is obtained. The application of the proposed approach was considered in the example of evaluating the websites of tourism organizations by using several MCDA methods. Additionally, an analysis of the application of the proposed approach in the case of a large number of respondents, done in Python, is presented. The advantages of the proposed method, as well as its possible limitations, are summarized.

Multi-criteria decision analysis of agri-food waste as a feedstock for biopolymer production

2021 ◽  
Vol 172 ◽  
pp. 105671
Author(s):  
I. Bolaji ◽  
B. Nejad ◽  
M. Billham ◽  
N. Mehta ◽  
B. Smyth ◽  
...  
Keyword(s):  
Decision Analysis ◽  
Food Waste ◽  
Multi Criteria Decision Analysis
Sign in / Sign up

Export Citation Format

Share Document