Title :
The Application of Excel VBA in the Prequalification of EPC BID
Author :
Liang, Jun ; Niu, Tianyong
Author_Institution :
Sch. of Econ. & Manage., North China Univ. of Technol., Beijing, China
Abstract :
The model of EPC has been used in our construction industry for 20 years. In the bidding of the practical EPC, the prequalification is usually realized by the traditional procedure and method, which need complicated calculation and implementation process. On the basic process of EPC prequalification tender, this article develops the system of prequalification tender by means of Excel VBA, determines the preliminary indicator system according to the characteristics of EPC, constructs the design of expert index weight, consistency test and index score module in excel through using the principle of AHP, realizes the data linkage, and improves the efficiency and reliability of prequalification tender.
Keywords :
construction industry; expert systems; knowledge management; tendering; AHP; EPC BID; Excel VBA; consistency test; construction industry; data linkage; expert index weight; index score module; prequalification; prequalification tender; EPC; Excel VBA; bid; prequalification;
Conference_Titel :
Information Management, Innovation Management and Industrial Engineering (ICIII), 2010 International Conference on
Conference_Location :
Kunming
Print_ISBN :
978-1-4244-8829-2
DOI :
10.1109/ICIII.2010.560
