Schedule delay is a common construction dispute. For analyzing schedule delays, a previous study had proposed an academic analysis method, the "isolated collapsed but-for" (ICBF) method. However, because many construction projects involve numerous complex activities, the procedure of using the ICBF method for schedule delay analysis is time-consuming. Therefore, this study used Microsoft Visual Basic for Applications (VBA) language and spreadsheet techniques to develop an Excel-based program for rapid delay analysis rather than manual calculation. A case study confirmed that the program automatically produces analytical results with only common delay documents (as-planned and as-built schedules and identified delay events). Compared with previous studies, schedule analysts can obtain analysis results quickly and correctly. Research results provide not only a convenient tool for schedule delay analysis but also a guide to computerize various academic delay analysis methods in the future. DOI: 10.1061/(ASCE)CO.1943-7862.0000338. (C) 2011 American Society of Civil Engineers.
JOURNAL OF CONSTRUCTION ENGINEERING AND MANAGEMENT-ASCE