Re: Software Topsis Excel
Bernd Manison
First, you will build your matrix in the input excel file and you will enter your criterion weights. Then, you can execute the test.m file. Your result will be displayed in the results named sheet in the input excel file. You can delete your previous results before the new calculations.
The high cost of completing education is one of the problems that exist in Indonesia. In order to solve this issue, one of the things that can be done is to provide scholarship assistance to students who excel or are less able. In every educational institution, especially in high school (SMA), there are many scholarships offered to students who excel and less fortunate students. With so many students who want to get these scholarships, a decision support system is needed to receive scholarships as expected. The current manual system can be inaccurate, considering that several criteria must be carefully considered. The average value of report cards, behavior, attendance, the amount of parental income, and the number of dependents of parents are all criteria that must be considered when evaluating prospective scholarship recipients. This study uses the Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) method to select scholarship recipients. The objectives of this study are how to develop a Decision Support System model with the TOPSIS methods for determining exemplary student for scholarship.
In this online Certificate Course, you can learn the complete process (A-Z) fromscratch to production. How to select parameters and why, download raster and vector data,processing data, images in ArcGIS environment, justification of variables, step by stepguide of TOPSIS, VIKOR and EDAS in excel, produced prediction map applying AHP method ingroundwater potentiality and stress zonation using ArcGIS. Moreover, you will also learnvalidation of the susceptibility map in SPSS software.
Attaching a simple example knime workflow and supporting excel sheet for background. I have attached an excel showing my desired output but having trouble achieving the iterative calculation on KNIME.
aa06259810