I built a dependency-driven scheduling engine entirely in Excel/VBA

说明与用途

团队开发了 ProjectEngine，一个基于 Excel/VBA 的开源调度引擎，自动计算日期、关键路径等，实现 Excel 中的依赖驱动调度，无需手动更新图表。

问题

Teams needed credible project schedules but lacked access to Microsoft Project or Primavera P6; manual Excel Gantt charts required constant manual updates when tasks changed.

结果

Teams can maintain accurate, dependency‑driven schedules entirely within Excel, eliminating manual updates and reducing errors.

工作流

• 1. Define tasks, durations, and dependencies in Excel sheets.
• 2. Run ProjectEngine VBA modules to read data into memory arrays and dictionaries.
• 3. Detect cycles and calculate tasks in topological order.
• 4. Compute finish‑to‑start, start‑to‑start, finish‑to‑finish, lag, milestones, and summary tasks.
• 5. Generate baseline, actual, and forecast dates and calculate critical path, longest path, total and free float.
• 6. Incrementally recalculate only affected tasks when changes occur.
• 7. Write updated dates back to Excel in batches and rebuild Gantt shapes efficiently.
• 8. Visualize results with interactive Gantt bars, dashboards, and S‑curves.

证据

ProjectEngine is an open‑source scheduling and project‑controls engine written entirely in Excel/VBA.

来源

Everything runs locally inside Excel. There is no installer, server, external account or cloud dependency.

来源