Title: An excel template for reporting progress for linear construction work

Purpose:

This paper and attached excel file describes and explains the construction and use of an automated reporting template that can be adapted to give a pictorial view of progress against plan for linear construction works.

The template can be adapted and used by others.

Approach:

This a format that I have used several times to develop a meaningful report for Project Managers and once the plan is populated can be used by site engineers to feed progress centrally.

Attached is an excel spread sheet with 3 tabs, the first two are the working template the third contains a description of how to use the template and how the formulas within the cells work.

Findings and Value:

I have had very positive feedback from management and engineers and once the planed dates are entered the template makes for a very effective way of capturing as built data to be used for progress reporting.

Research limitations/Practical use/Originality:

I have only used this for railway installation projects but the template could be adapted for vertically repetitive tasks in a similar manner. There are many excel templates used for depicting programmes this is one I developed at THSRC and have used several time since.

Conclusions:

This an effective and proven process for reporting progress against plan on linear construction works.