Excel Modeling for LNG Production Planning
Course 1006
This course provides a structured and practical curriculum, combining Excel modeling techniques with real-world LNG operations across the full hydrocarbon value chain. Key content areas include:
Production Planning & Forecasting
Build structured templates for production inputs, train constraints, and downtime logic
Simulate LNG output under various operational scenarios
Link forecasts with tank inventory and cargo scheduling
Inventory Tracking & BOG Management
Develop models to track tank balances across production, loading, and losses
Automate Boil-Off Gas (BOG) calculations and flag threshold breaches
Integrate inventory dynamics with cargo readiness logic
Cargo Scheduling & GU/CD Logic
Model GU (Give-Up) / CD (Carry-Down) alignment rules
Develop cargo slot calendars incorporating jetty constraints, delays, and shipping readiness
Visualize schedule mismatches and stock issues with alerts
Hydrocarbon Allocation & SPA Splits
Allocate volumes and energy using equity share, tolerance bands, and SPA rules
Break down allocations across multiple lifters with audit-ready transparency
Automate reconciliation and discrepancy detection
Reporting, Dashboards & KPIs
Design daily and monthly dashboards with dynamic visuals
Use pivot tables and charts to report plant operations, loading performance, and HCA metrics
Present key KPIs clearly to operations and commercial teams
Scenario Testing & Automation
Introduce toggle-driven “what-if” scenarios (e.g. cargo delay, underproduction)
Automate common tasks with simple Excel macros (data refresh, report generation)
Improve speed, reliability, and reusability of spreadsheets
Course Highlights
Purpose-built Excel tools for LNG professionals — no generic templates
End-to-end model design from production to cargo to hydrocarbon allocation
Real-time dashboards that communicate performance and operational readiness
Audit-ready allocation logic with tolerance bands and SPA splits
Scenario flexibility to test unplanned outages, delays, and underproduction
Hands-on workshops to build working models during the course
Instructor expertise from global LNG terminals, lifters, and operators
Excel Modeling
This course bridges the gap between LNG operational knowledge and practical Excel modeling skills. By the end of the program, participants will not only understand how to design transparent, auditable, and reusable spreadsheets, but also apply them directly to production planning, cargo scheduling, inventory management, and hydrocarbon allocation challenges.
With a strong focus on real-world LNG applications, attendees will leave equipped to support operational decisions, enhance reporting accuracy, and deliver actionable insights to their teams and stakeholders.
Build the confidence to transform raw data into meaningful models and reports that drive efficiency, compliance, and value across the LNG value chain.