MCDA freeware (original) (raw)

  1. Tam CM, Tong TKL and Chiu GWC, (2006), Comparing non-structural fuzzy decision support system and analytical hierarchy process in decision-making for construction problems, European Journal of Operational Research, Volume 174, Issue 2, 16 October, Pages 1317-1324

Abstract: Analytical Hierarchy Process (AHP) is a commonly used decision-aiding tool for resolving multi-criteria decision problems. However, users sometimes find it difficult to ensure a consistent pairwise comparison between voluminous decisions. The cause of which is that the Consistency Ratio (CR) is produced after the evaluation process and its global acceptance criteria is limited. When the derived ratio reports some inconsistency, it requires a long process to locate and rectify the problem. The major aim of this study is to look for an alternative decision-aiding tool to AHP, helping to avoid the above problem. The alternative approach proposed in this study is the Non-Structural Fuzzy Decision Support System (NSFDSS). The application of the system is illustrated with a worked example. The results generated by NSFDSS are compared against those generated by the conventional AHP that shows the effectiveness and some unique advantages of the proposed tool over AHP.

  1. Chan WK and Tong TKL, (2007), Multi-criteria material selections and end-of-life product strategy: Grey relational analysis approach, Materials & Design, Volume 28, Issue 5, Pages 1539-1546

Abstract: The choice of materials for a manufacturing enterprise is important. An improper selection can negatively affect productivity, profitability and undermine the reputation of an enterprise because of the growing demands for extended producer responsibility. This paper presents an integrated methodology of performing an order pair of materials and end-of-life product strategy for the purpose of material selection. The requirements of the methodology do not only include both the technical and economic factors, but also the environmental factors. However, this integration poses challenging problem of decisions subject to non-linear constraints and uncertainties. Furthermore, there are multiple and contradictory objectives to be considered. Using Grey relational analysis, the multi-criteria weighted average is proposed in decision-making process to rank the materials with respect to several criteria. It will guide the selection process and help a decision maker solve the selection problem. The method is demonstrated with an example. Various material options are evaluated using the developed multi-criteria methodology.

  1. Tam CM, Tong TKL, Wong YW, (2004), Selection of Concrete Pump Using the Superiority and Inferiority Ranking Method, Journal of Construction Engineering and Management, Volume 130, Issue 6, pp. 827-834 (November/December)

Abstract: The Superiority and Inferiority Ranking (SIR) method, a multicriteria decision-making technique, is proposed for facilitating the process of construction plant selection. The SIR method draws together the strengths of most multicriteria decision-making models in handling nonquantifiable, cardinal, and/or ordinal data and allows imprecise information by introducing concepts like indifference and preference thresholds for each criterion. In addition, the technique is capable of dealing with data in different units. The application of the SIR method is illustrated with a case study in the evaluation of 10 alternative concrete pumps based upon nine decision criteria. From the case study, the benefits and strengths of the SIR method in the selection process are unveiled.

5. Book: Here is my published book:

Decisions Making Operations Research Techniques in Construction Management

Readme file before using the excel freeware:

It is noted that my work are built on the freeware addin of "Morefunc" which can be download from the attachment 1.

Installation the excel addin of “morefunc”

  1. Extract the morefunc.zip file to C:\

  2. Start the Excel

  3. Press Button “Tools” --> addin --> Browse

  4. Select the folder of C:\morefunc

  5. Click the file of “morefunc.xll”

  6. Click the checkbox of “Morefunc (add-in functions)”

  7. Click “OK” button

Reset the Macro security level in Excel to medium

  1. Press Button “Tools” --> Options --> Security menu

  2. Click the button of “Macro security”

  3. Set the security level to “Medium”

  4. Click “OK” button

For those users using Excel 2007, please download the file of setup.rar which is the morefunc version 5.6. This new version of "morefunc" addin can be used on Excel 2007.

For any questions, please send to my email: thomas.uniga@gmail.com.