purebta.blogg.se

Topsis excel
Topsis excel




topsis excel

Position = input('Please enter the column of the indicator that needs to be forwarded. TOPSIS method (distance method of superior and inferior solutions)\code and sample dataĭisp() % For example, my code and data are in: D: Lecture 2. % You can use the cd function to modify the current folder of Matlab % Then the reason is because this file does not exist in the current folder of your Matlab

topsis excel

%% Note: If you are prompted: Load is used incorrectly and the file'data_water_quality.mat' cannot be read. % (4) Note that the code and data should be placed in the same directory, and the current folder of Matlab should also be this directory. % (3) Close this window, click the X variable, right-click and save as, and save as a mat file (you don’t need to copy and paste next time, just use the load command to load the data) % (2) Copy the data in Excel, then right-click in Excel and click to paste the Excel data (Ctrl+Shift+V) % (1) Right-click in the work area, click New (Ctrl+N), and enter the variable name as X %% Step 1: Copy the data to the workspace and name this matrix X Calculate the score and normalize: x-min/(max-x)+(x-min) Very small index conversion formula: max-x The unified indicator type is transformed into a very large indicator positive Construct the formula for calculating the score: (x-min)/(max-min) TOPSIS method (Pros and cons solution distance method)






Topsis excel