Skip to content

ProjectEngine v1.0.0 – Stable Planning Engine, Simulation Workflows & Documented Architecture

Choose a tag to compare

View all tags
@TMailletFR TMailletFR released this 16 Jul 15:32
v1.0.0
6458657

ProjectEngine v1.0.0

ProjectEngine reaches its first stable release.

This milestone consolidates the scheduling engine, simulation workflows, diagnostics, Gantt rendering, reporting tools, and workbook safety mechanisms into a documented and maintainable architecture.

The workbook remains fully Excel-native and powered entirely by VBA.

Highlights

Stable Planning Engine

  • Single-source dependency-driven scheduling engine.
  • FS / SS / FF relationships with positive and negative lag.
  • Multi-predecessor scheduling.
  • 5-day and 6-day working calendars.
  • Baseline, Actual, Forecast, and Calculated planning.
  • Level of Effort and Milestone support.
  • Parent and summary rollups.
  • Cycle, missing-predecessor, constraint, and blocking-error detection.
  • Signature-based incremental recalculation.
  • Forced full recalculation when required.

Complete Simulation Workflows

  • TEST mode for focused, non-destructive planning changes.
  • SCENARIO mode for complete schedule alternatives.
  • LOCK workflow for applying validated simulation results back to WBS.
  • Interactive Gantt Drag and Resize simulation.
  • Day / Week / Month snapping.
  • Predictive rendering of simulated changes.
  • Transactional execution with controlled rollback and finalization.
  • TEST, SCENARIO, and LOCK all reuse the existing Core calculation engine.

Gantt Rendering and Interaction

  • Day, Week, and Month timeline scales.
  • Task, Summary, Milestone, LOE, Dependency, Constraint, and Today Line rendering.
  • Critical Path and Longest Path overlays.
  • Progress and deadline visualization.
  • Predictive Shape Registry.
  • Fast-path rendering with deterministic fallback.
  • Lazy geometry repair.
  • Stable public callbacks and unchanged Shape actions.

Planning Analytics

  • Critical Path analysis.
  • Longest Path analysis.
  • Total Float and Free Float.
  • Deadline Float and deadline monitoring.
  • Baseline and forecast variance analysis.
  • Driving Logic tracking.
  • Parent-date and Task Type warnings.
  • Schedule delay and momentum analysis.
  • Multi-project criticality mode.

Dashboard and S-Curve

  • Executive project summary.
  • Forecast finish and project delay indicators.
  • Critical activities and schedule momentum.
  • Hot Spots analysis.
  • Upcoming milestones and critical activities.
  • Planning overview.
  • Baseline, Actual, Forecast, and Calculated S-Curves.
  • Daily workload distribution.
  • Dashboard snapshots and comparisons.

Diagnostics and Traceability

  • Structured INFO / WARNING / STOP diagnostics.
  • Bilingual planning messages.
  • Planning Console with message navigation.
  • Event History and Alarm History.
  • Stable event signatures.
  • Warning acknowledgement workflow.
  • Grouped dependency, constraint, cascade, and upstream diagnostics.
  • Noninteractive console policy for automated validation.

Workbook Safety

  • Tokenized, caller-owned WBS write scopes.
  • Protected calculated columns.
  • Safe Empty State for Gantt and S-Curve.
  • Planning Reset and Full Reset workflows.
  • Owner-controlled data reset contracts.
  • Controlled full and partial output writers.
  • Isolated validation on temporary workbook copies.
  • No global termination of user Excel instances.

Architecture Stabilization

The VBA codebase has been reorganized around explicit domains and ownership boundaries:

  • Runtime Workflow and MacroGuard
  • WBS / DataSync / CALC
  • Core Calculation
  • Core Bridge and Output Writers
  • Analytics and Diagnostic Producers
  • Gantt Rendering and Interaction
  • TEST / SCENARIO / LOCK services
  • Dashboard and S-Curve
  • MessageEngine, EventHistory, and ACK
  • Canonical Identity and Parsed Planning Network contracts

The scheduling engine remains the single source of truth.

Rendering, simulation, diagnostics, and reporting consume Core outputs without implementing competing calculation logic.

Canonical Contracts

This release introduces and stabilizes shared structural contracts for:

  • Canonical Identity Index
  • Parsed Planning Network
  • Incremental Calculation Signature
  • Dashboard Read Context
  • Owner-controlled stores and reset APIs

Only genuinely identical representations were centralized. Business policies that intentionally differ remain separate.

Regression Protection

Permanent validation tools now cover:

  • Gantt visual signatures
  • Predictive Registry fast path and fallback
  • TEST Day predictive rendering
  • Week / Month fallback
  • SCENARIO execution
  • LOCK success path on isolated copies
  • RuntimeWorkflow and MacroGuard
  • RunButtons noninteractive execution
  • MessageEngine and EventHistory
  • Diagnostic producers
  • WBS Write Guard lifecycle
  • Incremental signature compatibility

These harnesses are now the reference safeguards for future refactoring.

Developer Documentation

The project now includes dedicated French and English documentation:

  • Architecture Reading Guide
  • Maintenance Guide
  • Project Glossary
  • Module and procedure documentation

All VBA modules and procedures include concise FR/EN documentation describing their responsibility and contract.

  • 108 documented VBA components
  • 1,478 documented procedures and properties
  • 521 documented Public APIs
  • All external callbacks explicitly identified

Compatibility

  • Existing planning workflows remain compatible.
  • No project migration is required.
  • Public workbook callbacks and OnAction contracts remain stable.
  • No calculation rule was changed as part of the architecture and documentation work.

What v1.0.0 Means

Version 1.0.0 marks the transition from an evolving Beta architecture to a stable product baseline.

ProjectEngine will continue to evolve, but future work can now build on:

  • stable user workflows;
  • explicit component boundaries;
  • protected public contracts;
  • deterministic regression harnesses;
  • complete developer documentation.

Documentation

Assets 3
Loading