Computerizing ICBF method for schedule delay analysis

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.