Project status reporting system (PSRS) for pipeline relocation programs

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.