DeathMaillet

u/DeathMaillet


r/Excel247•

I’ve been building ProjectEngine, a free and open-source scheduling engine that runs entirely inside Excel.

It supports:

  • FS / SS / FF dependencies and lags;
  • Critical Path;
  • Longest Path;
  • Total / Free Float;
  • Baseline / Actual / Forecast;
  • interactive Gantt simulation;
  • S-Curves;
  • scheduling diagnostics.

The latest release also improves compatibility with:

  • 32-bit Excel;
  • English installations;
  • Excel LTSC / perpetual;
  • non-English environments.

It is distributed as an .xlsm workbook, and the full VBA source is public so you can inspect everything before enabling macros.

Website:

https://tmailletfr.github.io/ProjectEngine/

It is completely free and open source.

If an

00

r/excel•

*This repost has been approved by the r/excel moderation team. The previous version was removed while the link to my original post was being clarified, and the mods kindly allowed me to repost it once with the requested changes.*

Hi again,

About two months ago I posted here about ProjectEngine, an open-source scheduling engine I built entirely in Excel/VBA.

Here is the original r/excel post:

https://www.reddit.com/r/excel/comments/1uy7b39/i_spent_the_last_months_building_an_opensource/

I no longer have access to the Reddit account that made that original post, which is why I am po

22722

r/excel•

Hi again,

About two months ago I posted here about ProjectEngine, an open-source scheduling engine I had built entirely in Excel/VBA.

A few people actually tried it, asked questions and pointed out things that were unclear or broken. That had a much bigger impact on the project than I expected. The first feedback here was mostly about onboarding and the WBS structure.

Some columns looked mandatory even though they weren't, some terminology was too specific to engineering/construction, and it wasn't obvious what data was actually required to build a schedule.

Now there is a cleaner UX with:

- clearer Required / Optional / Calculated indicators;

- an integrated Quick Start;

- better

42

I have inherited several project schedules that looked extremely professional. Hundreds of activities, clean Gantt charts, progress percentages, color coding, dashboards, weekly updates.

Then one activity moved by five days and the whole thing fell apart.

Successor dates had to be adjusted manually. The project finish did not move consistently. The critical path could not really be explained. Baseline, actual and forecast dates had gradually been mixed together. That is when I started making a distinction between a schedule and a date tracker.

A date tracker records what people currently believe will happen.

A real scheduling model explains why it should happen and what the consequences

13


r/vba•

I maintain a fairly large Excel/VBA project, and a user recently reported this error while opening a workbook with only a few rows:

Error in RestoreWBSFormulaColumns: Out of memory

The obvious suspects were Excel 32-bit, workbook corruption, a memory leak, or some unexpectedly large table.

None of them made much sense. The workbook was almost empty.

The real problem was localization.

Some calculated-column formulas were being written in French through .FormulaLocal, using function names such as SI and OU, with semicolon separators.

That worked perfectly on my French installation of Excel.

On an English installation, those same strings were invalid because .FormulaLocal expects formu

87

r/MSProject•

I have been developing ProjectEngine, an open-source scheduling and project-controls application built entirely in Excel/VBA.

The original need was straightforward: many teams have Excel, but do not always have access to Microsoft Project or Primavera P6. Most Excel Gantt templates, however, remain static visual trackers rather than true scheduling tools.

ProjectEngine was built to close part of that gap.

It currently supports:

  • dependency-driven scheduling;
  • FS, SS and FF relationships with positive or negative lag;
  • Critical Path, Longest Path, Total Float and Free Float;
  • baseline, actual and forecast dates;
  • milestones, summary tasks and Level of Effort activities;
  • interac
108

r/SideProject•

I started ProjectEngine because Excel is often the only tool everyone has access to, while proper scheduling software such as MS Project or Primavera P6 is not always available.

Most Excel Gantt charts are essentially visual tables, so I wanted to see whether Excel could support an actual scheduling engine instead.

ProjectEngine is now an open-source Excel/VBA application with:

  • dependency-driven scheduling;
  • FS, SS and FF relationships with lag;
  • Critical Path, Longest Path and float analytics;
  • baseline, actual and forecast tracking;
  • milestones, summaries and Level of Effort tasks;
  • non-destructive TEST and SCENARIO workflows;
  • an interactive Gantt with drag and resize;
  • dashbo
11

r/vba•

I’ve been doing a fairly deep performance pass on an Excel/VBA scheduling engine, and I think I’ve reached an interesting architectural limit.

The current stress test is around 1,200 tasks, ~2,000 business shapes and ~1,180 dependency links.

A lot has already been optimized:

  • scheduling core and analytics run from compiled/indexed structures
  • the watcher is almost free
  • rendering is local/incremental
  • ~3,100 dependency Shapes were replaced with a single SVG layer

Despite that, a very small local change can still take ~10–13s, while a heavily propagated change can take 35–90s.

The surprising part is that COM writes are no longer the main problem.

On one propagated case, 661 shap

1215

r/vba•

When I started this project, I saw VBA as a slightly obscure way to automate repetitive Excel work and push formulas a bit further.

Then every time I thought I had reached its limit, I found another door.

What began as a few scheduling calculations gradually turned into dependency graphs, critical-path analysis, incremental recalculation, automated tests and an interactive Gantt built with Excel shapes.

The real turning point was when I stopped treating Excel as the application and started treating it as the interface. The workbook handles inputs and outputs, while most of the actual logic runs in memory through arrays, dictionaries and separate modules.

VBA is still old, awkward and occ

10487

r/projectmanagers•

Hi everyone,

Over the past months I've been building an open-source scheduling engine for Excel.

The motivation came from projects where teams were already managing schedules in Excel but either didn't have Microsoft Project licenses, didn't need a full enterprise planning tool, or simply preferred to stay in an environment everyone already knew.

The goal wasn't to replace Primavera or Microsoft Project for large PMOs. It was to see how far an Excel-based scheduling engine could realistically go while remaining easy to share and use.

Today the project includes:

  • Dependency-based scheduling (FS / SS / FF + lags)
  • Interactive Gantt chart
  • Critical Path analysis
  • Total and Free Float
87