Project Management in Excel (Dashboard, Gantt, Critical Path, Earned Value Analysis)

Managing your project's process and measuring its key performance indicators is what the Project Process Spreadsheet is all about.

Dashboard:
- Gantt Chart (up-to-date picture - linked to the original Gantt Chart)

- Critical Path Analysis Chart

- Work Breakdown Structure Process: Planned and Actual Performance Chart, Performance Indices Chart included Schedule Performance Index (SPI), Cost Performance Index (CPI) and Cost-Schedule Index (CSI) - by Activities.

- Performance Indices: Summary Chart throughout the project lifecycle (included Schedule Performance Index (SPI), Cost Performance Index (CPI) and Cost-Schedule Index (CSI)), Summary Performance Indices separated by Activities, EV (BCWP) Analysis (up-to-date picture - linked to the original tab).

Gantt Chart:
Shows both the planned and actual work even both of them together.

EV- Analysis: daily analysis for each Activity and analysis that belongs to the dashboard.

Setup sheet: Setting up the Activities name, starting date, predecessors, minimum-, most likely and maximum durations, Actual start and actual duration, budgeted cost and Holidays.

For 10 Activities, up to 6 predecessors per activity and up to 180 days (workdays) project lifecycle.

Without macros.