Construction cost and schedule analysis

Twenty analysis problems across cost, schedule and material data, built into one linked workbook with dashboards and a written report.

ExcelPythonData analysisReporting
Construction cost and schedule analysis

The problem

On most sites the analysis lives in one person's head. When that person is busy, nobody can answer a simple question about cost or delay.

What I built

A multi-sheet workbook where every figure traces back to source data through formulas, with dashboards on top and a written report explaining what each number means. Anyone on the team can open it and get the answer.

Stack

Excel, structured formula modelling, Python for the data preparation.

Client
Commercial construction