TY  - JOUR
AB  - Purpose Successful performance and execution of construction projects depend highly on a good project control system capable of tracking and reporting project status on a desired time interval. The purpose of this paper is to propose such a control system by integrating spreadsheet and Visual Basic for Application to produce a customized tracking system for Pipeline Relocation Programs under Engineering, Procurement and Construction Management (EPCM) contracts.Design/methodology/approach The project status reporting system (PSRS) proposed here was developed to produce a single page summary report that would include scope information, financial status, descriptive status updates and top-level task schedules. This information is retrieved from various sources and transformed further utilizing specific formulas and algorithm needed to compute the budget and schedule status of the pipe relocation project. A practical case study is used to demonstrate its unique application.Findings The system has successfully integrated project finance and schedule information into a central control hub. Financial and schedule performance of a project is tracked and monitored by the PSRS automatically.Originality/value The proposed system utilizes the powerful computing capability of MS Excel and the user-friendly VBA programming tool to customize the reporting needs of a project and program environment. The proposed system, whose functionality has been validated by the intended users, tries to achieve a balance between simplicity, accuracy and effectiveness for the flow of information at a much lower cost compared to the other readily available project control software.
VL  - 10
IS  - 5
SN  - 2044-124X
DO  - 10.1108/BEPAM-09-2019-0075
UR  - https://doi.org/10.1108/BEPAM-09-2019-0075
AU  - Hu Wei
AU  - Panthi Kamalesh
PY  - 2020
Y1  - 2020/01/01
TI  - Project status reporting system (PSRS) for pipeline relocation programs
T2  - Built Environment Project and Asset Management
PB  - Emerald Publishing Limited
SP  - 693
EP  - 708
Y2  - 2024/04/25
ER  -