Technology

A controlled, database-driven workflow

EPCplanner is a native desktop application built around a single relational database. Every module operates on the same data, the same WBS, and the same period structure, so a single progress update cycle keeps planning, commercial and reporting outputs consistent with each other.

System Workflow

Two phases. One controlled cycle.

EPCplanner's workflow divides into a one-time Project Setup Phase and a recurring Operational Reporting Cycle that repeats for every Cut-Off Date.

Phase 1: Project Setup (One-Time)

Completed once before any reporting begins. Establishes the schedule baseline, commercial structure, Weight Factors, and register framework.

1 Import master schedule via XER or live database connection
2 Import, validate and promote CBS (commercial baseline)
3 Generate and validate Weight Factors from CBS distribution
4 Import ENG, PROC and SUBC registers with stage templates
5 Configure S-curves, reports and measurement framework
6 Baseline validation, sign-off and switch to In-Progress mode
Phase 2: Operational Reporting Cycle (Recurring)

Repeats for every Cut-Off Date. Captures actual progress, recalculates register and activity status, generates reports, synchronises with the master schedule, and closes with a locked Historical Snapshot.

1 Open Cut-Off Date and lock the update window
2 Enter register stage actuals and linear activity actuals
3 Run Register Rollup, calculate weighted progress
4 Run Update and generate S-curve for the period
5 Generate forecasts, lookahead and behind-schedule reports
6 Push progress back to master schedule (two-way sync)
7 Close Cut-Off Date, period locked, Historical Snapshot created
Register Progress Logic

Progress from actual deliverables, not estimates

The Register Framework is the core progress measurement engine. Engineering, Procurement, and Subcontract deliverables are managed through registers using configurable stage templates. Each stage represents a measurable milestone in the deliverable lifecycle and carries a proportional Weight Factor contribution.

Because all calculations originate from controlled register data, progress reporting remains traceable, auditable, and consistent across all project functions. The same progress dataset is used for S-curves, histograms, tabular reports, forecasting, lookahead analysis, behind-schedule analysis, and schedule synchronisation.

  • Stage completion drives automatic rollup to linked schedule activities
  • Weight Factors distribute measurable planning weight from the CBS distribution
  • Quality check confirms every item has a valid template and required setup
  • Validation highlights alignment gaps between register dates and schedule dates
  • Multiple templates with different stage counts coexist in the same project
  • Register items can replace fragile Excel networks; Excel is used for import and export only
Progress Calculation Sequence
Register Stage Actuals (ENG / PROC / SUBC)
Stage Weight Factor Contribution
Register Item % Complete
Register Rollup to Activity (WF-based)
Activity % Complete
WBS / Project-Level Rollup
S-Curves, Reports, Forecasting, Schedule Sync
Single Source of Truth

Why the database design matters

Every module: CBS, registers, forecasting, reporting, operates on the same database, the same WBS, and the same period structure. A single progress update keeps all outputs consistent.

Data point Spreadsheet-based environment EPCplanner
Data location Scattered across multiple Excel files held by different teams, manually consolidated at period end One project database covering schedule, commercial and all register data
Progress calculation Different methodologies per discipline; estimated percentages entered manually Consistent WF-based calculation from register stage actuals, applied uniformly
Schedule alignment Manual cross-checking of register dates against schedule activity dates each period Each register item linked to an activity; validation reports day-delta gaps automatically
Period-end data Closed-period figures can be silently edited; tracing changes is difficult Freeze Guard blocks retroactive entry once a Cut-Off Date is closed
Commercial linkage Physical progress and invoicing tracked in separate, loosely reconciled files CBS, Activity WF, and Cost/Invoice WF are linked; one progress update drives both
Audit trail Reconstructed manually from file versions and email history, if at all Immutable Audit Log records every controlled action with user, timestamp and detail
Governance Framework

Historical Snapshots, Freeze Guard and Audit Log

Three capabilities work together as a single governance system. Together they give Clients, PMC organisations and auditors confidence that reported progress figures are accurate, traceable and cannot be altered after the fact.

Historical Snapshots

Every time a Cut-Off Date is closed, EPCplanner automatically preserves the complete state of that period: register actuals, activity progress, S-curve data points, CBS earned values and the update timestamp. The resulting snapshot cannot be edited. It supports trend analysis, audit requests, claims support and retrospective performance review.

Freeze Guard

Once a Cut-Off Date is closed, Freeze Guard prevents actual dates, quantities and stage completions from being entered or modified for that period, from any module, by any user, including Administrators. The S-curve, register status and CBS earned value reported to the Client for any period will read identically six months later.

Immutable Audit Log

The Audit Log records every import, validation run, rollup, update, and report generation with the responsible user and timestamp, so any reported figure can be traced back to the action that created it. Entries cannot be edited or deleted by any user including Admin. Provides traceability, governance, claims support and audit compliance.

Schedule Integration

EPCplanner complements your scheduling platform; it does not replace it

EPCplanner is not a scheduling replacement. The master schedule remains in the scheduling platform, holding the Level 3 CPM logic, typically 5,000 to 10,000 activities for a major EPC project.

The detail that would otherwise bloat that schedule to 30,000 to 50,000 activities; individual engineering documents, individual purchase requisitions, individual subcontract deliverables are instead tracked at Level 4/5 inside EPCplanner's Register module, linked back to the relevant Level 3 activity. The master schedule stays clean and manageable for the planning team, while EPCplanner carries the operational detail and feeds summarised progress back through two-way synchronisation.

  • XER file import, compatible with all scheduling platforms that produce a standard XER export
  • Direct Oracle database connection (EPPM) for live two-way synchronisation
  • SQL Server database connection for enterprise scheduling deployments
  • SQLite standalone connection for simpler environments
  • Progress push writes actual dates, physical percent and remaining duration back to the master schedule
Two-Way Architecture
Master Schedule Level 3 CPM logic: 5,000 to 10,000 activities
XER / Live DB Progress push-back
EPCplanner Level 4/5 detail: ENG / PROC / SUBC registers + CBS
S-curves, reports, invoices, forecasts, audit trail
Plan Versioning

Controlled schedule revisions with a full approval lifecycle

Every schedule import is recorded as a named, typed Plan Version with its own immutable snapshot, approval workflow and audit trail. The active plan never loses history, and any earlier plan remains available for comparison, recovery or audit.

  • Baseline: original approved schedule, created automatically on first import
  • Revision: formally numbered schedule revision reflecting approved changes
  • Recovery Plan: issued to address schedule slippage, with a Revised Cut-Off Date
  • Rebaseline: full schedule reset formally approved by Client or PMC
  • Forecast: analytical what-if scenario for comparison only (cannot become Active)
  • Revised Cut-Off Date locks actual progress as of that date before new plan dates take effect
Plan Version Lifecycle
ImportedDraft
Submitted for reviewPending Approval
Reviewed and approvedApproved
Current controlling planActive
Replaced by newer planSuperseded
Deployment

Offline-first. Designed for remote sites.

EPCplanner is a native desktop application that operates from a local or LAN-hosted database, with no dependency on cloud connectivity for daily operations.

Standalone

Single machine with local SQLite database. No server required. Full capability with no network dependency.

LAN Server

Multi-user access over a local network with a shared SQL Server backend. No internet required. Role-based access controls which user can see and modify.

Enterprise

Direct connection to existing Oracle EPPM or SQL Server scheduling platform database for live two-way synchronisation and progress push-back.

Windows Desktop Android iOS macOS (Mac Catalyst) LAN / Offline first
Learn More

Want a deeper technical conversation?

Contact us to discuss deployment options, database architecture and integration with your existing scheduling environment.