I will create an excel construction tracker with gantt and vba
About this Gig
Stop tracking your construction site with messy spreadsheets.
I build a complete Excel + VBA project tracker for civil engineering and building projects. You enter quantities done on site, and the file does the rest automatically.
Whats included:
Task planning with quantities, unit prices and dates
Automatic Gantt chart (planned vs actual, delays in red)
S-curve: planned vs actual progress over time
Dashboard with KPIs: progress %, SPI (schedule) and CPI (cost)
Daily site log, expense tracking by work package and category
Material stock control with reorder alerts
One-click VBA buttons: add progress, add expense, new task, generate alerts, export PDF report, dated backup
Why choose me?
Civil engineering background: I understand work packages, quantities and site reality
Clean formulas, no hidden tricks, easy to edit
Delivered in English or French
Send me your task list (or BOQ) and Ill adapt the tracker to your project.
Platform:
Excel
Development technology:
VBA
Expertise:
Macros

