<< Why DECIDE ? | index | Licence >>
The DECIDE wizard
The DECIDE demonstration workbook features a Visual Basic for Applications (VBA) set of routines that you can use to automatically generate a complete worksheet where you can input your data. All Promethee calculations will be made for you, including the calculations related to the visual presentation of SpatialGaia, as well as a correlation matrix showing the correlation between your criteria.
See an Excel sheet generated by the Promethee wizard.
To launch the Decide wizard, just load the DECIDE Excel demonstration workbook, and click on the "Decidewizard" button on the cover sheet. Just answer the questions needed to generated the worksheet (mainly the number of actions and criteria you need to consider), and watch the DECIDE wizard working for you...
Once the worksheet is generated, you need to input your data in the worksheet.
- replace the 'criterion 1', 'criterion 2' columns headers by names that represent your criteria (like \"price\", \"age\", etc.)
- fill in the weights for the criteria (must be >= 0). If you set the same value for all criteria, they all will be considered as having the same importance to you.
- fill the min/max cells : 0 (minimize criterion) if the action is better when its score for this criterion is lower (like the price for a car), or 1 (maximize criterion) if the action is better when its score is higher (like the number of years of experience for a candidate).
- choose a 'criterion type' in the list below
| ||usual criterion (critère usuel)||there is 'indifference' only if there is no difference between the actions scores|
| ||U-shape criterion (quasi-critère)||there is 'indifference' as long as the scores difference is less than q|
| ||V-shape criterion (critère à préférence linéaire)||the preference varies linearly with the difference between the scores between 0 and p. If the difference is more than p, the action is strictly preferred.|
| ||level criterion (critère à paliers)||there is 'indifference' as long as the score difference is less than q, low preference if the scores difference is between q and p, and strict preference if the scores difference is higher than p.|
| ||linear criterion with indifference area (critère à préférence linéaire avec zone d'indifférence)||there is 'indifference' as long as the score difference is less than q. The preference varies linearly with the difference between the scores between q and p, and becomes strict if the scores difference is higher than p.|
| ||gaussian criterion (critère gaussien)||the preference increases with the difference between the scores as expressed in|
- according to the 'criterion type' you choose, fill in the q, p and s value. Check that the 'Promethee data OK' cell contains TRUE for each criterion. If it is not, you made a mistake in the parameters. Caution : the fields that are not required must be BLANK (= NO character, not even a space)
- replace the 'action 1', 'action 2' rows headers by names that represent your actions (like 'Paul', 'Mary', etc.)
- fill in the score for the actions
That's all, you made it !
DECIDE shows you now several results :
- a comparability matrix, that contains 1 for actions that can be compared together properly, and 0 for actions that cannot. For such actions you should check why this is the case (typical example : two candidates, one with high education but no experience and the other will little education but a lot of experience).
- a correlation matrix, that contains values between -1 and 1. A value of 0 means that there is no correlation. 1 means that there is a positive correlation (when one criteria increases, the others increases too - like quality and price, usually), and - 1 means there is a negative correlation (when one criteria increases, the other decreases - like availability and price, usually)
Caution : in order to calculate the correlations, the variance of the scores for each criterion may not be 0. If this is not the case, DECIDE will return an error, translated by Excel as "#value".
- the Promethee III ranking is given in columns S and T.
Alpha, Lamda an Mu are parameters for Promethee III.
<< Why DECIDE ? | index | Licence >>