loader

Loading...

loader
+91 6205464268 info@peassociations.com
  • About Us
  • Contact Us
  • Membership
logo
Log in Membership
  • Our expertise
  • Upcoming Public Courses
  • Upcoming events
    • Upcoming events
    • Workshops
    • Webinars
  • Company
    • Company
    • About us
    • Membership
    • Meet Our Team
    • Gallery
    • Blogs & Articles
    • Testimonials
    • Download
    • Certificate
  • e-Learning
  • Contact Us
  • Quiz
Press Enter To See All Search Results
Search results for:
    LOG IN
    Subscribe To Our Newsletter

    PEA Excel Suite

    image
    Premium  icon
    Download

    Well Path Design and Surveys

    Well path design in Excel: J-type, S-type and horizontal plans from closed-form geometry, every station checked by minimum curvature, survey calculation by five methods, plan vs actual with hold-and-miss and steering, and an anti-collision separation-factor check.
    image
    Premium  icon
    Download

    Skin to WPIMULT Conversion

    Convert a well-test skin into a simulator WPIMULT and back in Excel: Peaceman equivalent radius for anisotropic cells, connection factors layer by layer, skin from measured PI, grid-size effect and COMPDAT/WPIMULT lines ready to paste.
    image
    Premium  icon
    Download

    Field Profile Builder (Type Curve x Drilling Schedule)

    Build a field forecast in Excel from one type curve and a drilling plan: modified hyperbolic type curve, rig-based schedule with manual override, facility limit with backlog, layer cake by well vintage, cash flow and the best rig count.
    image
    Premium  icon
    Download

    Gas Field Plateau and Fall-Off

    Gas field plateau planning in Excel: tank material balance, back-pressure well deliverability, how long each plateau rate can be held, recovery at fall-off, quarterly profiles for five plateau rates and the NPV of each.
    image
    Premium  icon
    Download

    Value of Information (Bayesian Decision)

    Value of information in Excel: prior odds, a seismic reliability table, Bayes theorem, posterior odds and EMV after each signal, a rolled-back decision tree, VOI against EVPI, and when a survey is worth its cost.
    image
    Premium  icon
    Download

    Gas Flowing Material Balance (Dynamic Material Balance)

    Gas flowing material balance in Excel: gas PVT and pseudo-pressure, average reservoir pressure from flowing data, a 25-point search for the boundary-dominated constant b, gas in place without a shut-in, a check against shut-in surveys and recovery to abandonment.
    image
    Premium  icon
    Download

    Coalbed Methane Volumetrics (Langmuir Isotherm)

    Coalbed methane volumetrics in Excel: Langmuir isotherm fitted to laboratory data, coal tonnage and gas in place for five seams, saturation, critical desorption pressure, depletion and recovery against abandonment pressure.
    image
    Premium  icon
    Download

    Wellbore Stability (Stress Polygon)

    Wellbore stability in Excel: the stress polygon, faulting regime, SHmax from breakout width, and the mud weight window for collapse, losses and breakdown down the hole.
    image
    Premium  icon
    Download

    Well Test Tubing Leak Load Case

    Well test tubing leak load case in Excel: annulus and tubing pressure against depth for a surface leak, casing burst, tubing burst and collapse, packer differential and wellhead checks, and the casing, annulus and tubing pressure tests that prove them.
    image
    Premium  icon
    Download

    Water Production Diagnostics (Chan Plots)

    Water production diagnostics in Excel: Chan plots of WOR and its derivative for four wells, automatic diagnosis of coning, channeling, mechanical leaks and normal displacement, WOR against cumulative oil and the action for each well.
    image
    Premium  icon
    Download

    Reservoir Economics - Excel Workbook

    Reservoir economics in Excel: Arps production forecast by drilling vintage, cash flow, concession and PSC side by side, NPV, IRR, payback and breakeven, tornado and spider sensitivity, and a 500-trial Monte Carlo.
    image
    Premium  icon
    Download

    Rate Transient Analysis (Oil Well)

    Rate transient analysis in Excel: normalised rate and material-balance time, log-log diagnostics, Blasingame type-curve match, flowing material balance, permeability, skin, drainage area, oil in place and a history match.
    image
    Premium  icon
    Download

    Pressure Transient Analysis

    Pressure transient analysis in Excel: log-log diagnostic plot with Bourdet derivative, live type curves for five reservoir models, Horner, MDH and superposition plots, semilog drawdown, reservoir limit test and the Ei function.
    image
    Premium  icon
    Download

    Petroleum Fiscal Systems

    Petroleum fiscal systems in Excel: one oil field under a concession, a fixed-split PSC, an R-factor PSC and a risk service contract, with cash flows, NPV, IRR, government take and progressivity across prices and field sizes.
    image
    Premium  icon
    Download

    Oil Material Balance (Havlena-Odeh)

    Oil material balance in Excel: Havlena-Odeh straight line for oil in place and gas-cap size, F against Et and Campbell cross-checks, expansion terms and drive indices from pressure surveys and PVT.
    image
    Premium  icon
    Download

    Multiphase Flow (Beggs-Brill Traverse)

    Multiphase flow in Excel: a 50-segment Beggs-Brill pressure traverse with every value visible, the flow pattern map, liquid holdup, fluid properties, outflow curves and tubing selection.
    image
    Premium  icon
    Download

    Hydraulic Fracturing Design

    Hydraulic fracturing design in Excel: PKN and KGD fracture geometry, fluid efficiency, Nolte pad and proppant schedule, conductivity, CfD, folds of increase and a minifrac G-function analysis.
    image
    Premium  icon
    Download

    Gas Pipeline Hydraulics

    Gas pipeline hydraulics in Excel: General, Weymouth, Panhandle A, Panhandle B and AGA equations side by side, a 20-segment pressure and velocity profile, erosional velocity, line pack, MAOP and pipe sizing.
    image
    Premium  icon
    Download

    Gas Material Balance (p/Z with Water Influx)

    Gas material balance in Excel: p/Z against cumulative gas, the Cole plot, a Fetkovich aquifer matched by a 25-point search, Havlena-Odeh with water influx, and drive indices.
    image
    Premium  icon
    Download

    Gas Lift Design - Valve Spacing

    Gas lift valve spacing in Excel: unloading valve depths on the kill-fluid gradient, casing and tubing pressures, temperatures, dome and test-rack opening pressures, and the gas lift performance curve.
    image
    Premium  icon
    Download

    ESP Design - Excel Workbook

    Electrical submersible pump design in Excel: inflow and intake pressure, free gas, total dynamic head, pump selection from a catalogue, stages and horsepower, motor, cable, transformer and variable speed drive.
    image
    Premium  icon
    Download

    Decline Curve Analysis

    Decline curve analysis in Excel: Arps fit by least squares over 31 values of b, loss-ratio diagnostics, a 30-year forecast with terminal decline, EUR, remaining reserves and well life.
    image
    Premium  icon
    Download

    Casing Design (Burst, Collapse, Tension)

    Casing design in Excel: burst, collapse and tension load lines every 250 ft, API 5C3 ratings, biaxial collapse correction, safety factors against design factors and nine pipe options compared.
    image
    Premium  icon
    Download

    Capillary Pressure and Saturation-Height - Excel Workbook

    Capillary pressure and saturation-height modelling in Excel: laboratory Pc from four core plugs, the Leverett J-function, Brooks-Corey fit, contacts by rock type and water saturation against depth checked against a logged well.
    image
    Premium  icon
    Download

    Buckley-Leverett Waterflood

    Buckley-Leverett waterflood in Excel: Corey relative permeability, fractional flow, the Welge tangent, front saturation, breakthrough, saturation profile and recovery against pore volumes injected.
    image
    Premium  icon
    Download

    Excel in Cementing Design

    Twelve cementing design methods on one casing job in one Excel file: well geometry, slurry design, slurry volumes, spacer design, displacement, pressure window, rheology, thickening time, gas migration, centralization, compressive strength and job cost.
    image
    Premium  icon
    Download

    Excel in Hydrogen Storage

    Twelve underground hydrogen storage methods on one project in one Excel file: hydrogen properties, salt cavern capacity, cavern leaching, depleted field storage, cushion gas strategy, well deliverability, thermodynamics of cycling, losses and purity, compression, seasonal cycling, round-trip energy and storage economics.
    image
    Premium  icon
    Download

    Excel in Geothermal

    Twelve geothermal methods on one hydrothermal field in one Excel file: temperature and heat flow, resource assessment, steam properties, well deliverability, single flash plant, binary plant, reservoir pressure, thermal breakthrough, silica scaling, direct use, field development and geothermal economics.
    image
    Premium  icon
    Download

    Excel in Pipelines

    Twelve pipeline methods on one crude export line and one gas line in one Excel file: wall thickness, liquid hydraulics, pump stations, gas flow, compression and line pack, thermal profile, surge, hydrotest, corrosion defect assessment, pigging, leak detection and pipeline economics.
    image
    Premium  icon
    Download

    Excel in Process Safety

    Twelve process safety methods on one HP separator in one Excel file: flammability, release rates, relief valve sizing, fire case relief, depressuring, flare radiation, gas dispersion, fires, explosions, consequence to harm, LOPA and SIL, and risk assessment.
    image
    Premium  icon
    Download

    Excel in Decommissioning

    Twelve decommissioning methods on one late-life offshore platform in one Excel file: cessation of production, well P&A inventory, plug design and cement, P&A learning and rigless work, topsides removal, jacket removal, pipeline decommissioning, waste and materials, comparative assessment, cost estimate, decommissioning liability, and schedule and cash flow.
    image
    Premium  icon
    Download

    Excel in Production Chemistry

    Twelve production chemistry methods on one oil field in one Excel file: water analysis, scale prediction, water compatibility, scale squeeze, corrosion inhibition, injection water treatment, emulsion breaking, produced water treatment, H2S scavenging, chemical injection design, dose optimisation and chemical program cost.
    image
    Premium  icon
    Download

    Excel in Well Integrity

    Twelve well integrity methods on one gas well in one Excel file: casing loads, tubing movement, MAASP, annular pressure build-up, sustained casing pressure, cement evaluation, corrosion and wall loss, barrier leak testing, barrier reliability, well risk ranking, plug and abandonment and integrity economics.
    image
    Premium  icon
    Download

    Excel in Waterflooding

    Twelve waterflooding methods on one five-spot pattern in one Excel file: relative permeability, fractional flow, Buckley-Leverett, layered sweep, areal sweep, injectivity, the pattern forecast, Hall plot, surveillance plots, voidage and pressure, injector connectivity and waterflood economics.
    image
    Premium  icon
    Download

    Excel in Artificial Lift

    Twelve artificial lift methods on one oil well in one Excel file: well and PVT, inflow and lift need, gas lift design and performance, ESP design and speed control, rod pump design, rod loads and torque, PCP, jet pump, lift selection and lift economics.
    image
    Premium  icon
    Download

    Excel in Unconventional Reservoirs

    Twelve unconventional-reservoir methods on one shale gas well in one Excel file: gas PVT and pseudo-pressure, shale petrophysics, gas in place with adsorption, frac design, completion design, rate-transient analysis, SRV and drainage, Arps decline, Duong and SEPD, type curves, well economics and well spacing.
    image
    Premium  icon
    Download

    Excel in Geomechanics

    Twelve geomechanics methods on one offshore well in one Excel file: overburden, pore pressure, rock strength, in-situ stresses, leak-off and fracture gradient, wellbore stability, deviated wells, casing seats, sand production, compaction and subsidence, fault reactivation and fracture containment.
    image
    Premium  icon
    Download

    Excel in EOR

    Twelve enhanced oil recovery methods on one field in one Excel file: EOR screening, fractional flow, Buckley-Leverett, polymer flooding, CO2 MMP, CO2 flooding, surfactant flooding, steamflooding, cyclic steam, sweep efficiency, EOR economics and pilot monitoring.
    image
    Premium  icon
    Download

    Excel in CCUS

    Twelve CCUS methods on one capture-to-storage chain in one Excel file: CO2 properties, amine capture, compression, pipeline sizing, storage capacity, injectivity, plume migration, trapping, caprock and fault stability, 4D monitoring, CCUS economics and carbon accounting.
    image
    Premium  icon
    Download

    Excel in Flow Assurance

    Twelve flow assurance methods on one subsea oil tieback in one Excel file: fluids and production profile, thermal design, hydrate formation, hydrate inhibition, wax deposition, asphaltenes, scale, multiphase flow, slugging, CO2 corrosion, erosion and sand, and cooldown and restart.
    image
    Premium  icon
    Download

    Excel in Geology and Geoscience

    Twelve geoscience methods on one field in one Excel file: well correlation, depth conversion, structure maps, gross rock volume, net-to-gross, fluid contacts, saturation height, STOIIP and GIIP, Monte Carlo, uncertainty, kriging and prospect risking.
    image
    Premium  icon
    Download

    Excel in Petroleum Economics

    Twelve petroleum economics methods on one field evaluation in one Excel file: time value of money, production forecast, cash flow, concession, PSC, fiscal comparison, reserves, decision trees, Monte Carlo, sensitivity, portfolio and unit costs.
    image
    Premium  icon
    Download

    Excel in Well Testing and Pressure Transient Analysis

    Twelve well test methods on one field test programme in one Excel file: test design, drawdown, build-up, derivative and type curves, faults, reservoir limit test, fractured wells, dual porosity, multi-rate, interference, injection falloff, and productivity and skin.
    image
    Premium  icon
    Download

    Excel in Gas Engineering

    Twelve gas engineering methods on one linked gas field in one Excel file: gas properties, pseudo-pressure, deliverability, gas well testing, wellbore flow, liquid loading, material balance, gas condensate, production forecast, gas quality and sales, field economics and gas storage.
    image
    Premium  icon
    Download

    Excel in Surface Facilities

    Twelve surface facilities methods on one linked facility in one Excel file: stage separation, separator sizing, oil treating, produced water, gas compression, sweetening, dehydration, pipelines, pumps, heat exchangers, relief and flare, energy and emissions.
    image
    Premium  icon
    Download

    Excel in Petrophysics and Formation Evaluation

    Twelve petrophysics methods on one well in one Excel file: log QC, shale volume, porosity, lithology, formation water, water saturation, Archie parameters, permeability, saturation height, pressures and contacts, net pay and volumetrics.
    image
    Premium  icon
    Download

    Excel in Well Completion and Intervention

    Twelve completion and intervention methods on one well in one Excel file: tubing movement and stress, perforating, gravel packing, brines, annulus pressure, coiled tubing, wireline, well kill, plug and abandonment, corrosion and intervention economics.
    image
    Premium  icon
    Download

    Excel in Production Engineering

    Twelve production engineering methods on one well in one Excel file: inflow and skin, tubing flow, nodal analysis, chokes, stimulation, surveillance, gas lift, ESP, rod pumping, lift selection and flow assurance.
    image
    Premium  icon
    Download

    Excel in Drilling Engineering - Master Workbook

    One well, designed and drilled from start to finish in Excel. The workbook follows the order an engineer works in: pressures and casing first, then the well path and string, then hydraulics, well control and cementing, and finally drilling performance and cost.
    image
    Premium  icon
    Download

    Gas Lift Design - Excel Workbook

    A complete continuous gas lift design in one Excel file. Enter the well, fluids, reservoir test and lift gas pressures, and the workbook works out where to inject, how much gas you need, how to space and set the unloading valves, which orifice to run, and the gas rate that makes the most money.
    image
    Premium  icon
    Download

    Pressure Build-Up Analysis

    A complete pressure build-up interpretation in one Excel file. Enter the flow periods before shut-in, paste the gauge data, and the workbook takes you from the log-log diagnostic to permeability, skin, fault distance, average reservoir pressure and how much oil the skin is costing you.
    image
    Premium  icon
    Download

    Excel in Reservoir Engineering

    One Excel workbook that covers the core reservoir engineering methods, from pressure gradients and decline curves to well testing, waterflood, PVT checks and project economics. All results are live formulas, and all 41 charts update when you change an input. No macros, no add-ins, no Solver.
    image
    Premium  icon
    Download

    Oil and Gas Industry Data Book

    The benchmark numbers engineers look up every day, in one Excel workbook. It covers rock and log values, fluid types and pressure gradients, recovery factors, casing programmes, indicative well costs, energy equivalents, heating values, CO₂ factors, component properties and standard conditions, with 13 colourful charts. No macros, no add-ins.
    image
    Premium  icon
    Download

    Petroleum Engineering Exam Practice

    182 self-marking petroleum engineering questions in one Excel workbook, covering drilling, well control, reservoir, petrophysics, PVT, well testing, production, completion, facilities, economics and HSE, basic to advanced. Type your answer and see the result and explanation at once, sit five mock exams, and find your weak topics. No macros, no add-ins.
    image
    Premium  icon
    Download

    Production Data Toolkit

    Turn daily well readings into a monthly production report, in one Excel workbook. It covers field and well totals, uptime, water cut, GOR, decline by well, allocation from the fiscal meter, downtime and deferred oil by cause, and daily well trends, with 13 colourful charts. Live formulas only, no macros, no add-ins, no pivot tables to refresh.
    image
    Premium  icon
    Download

    Oil and Gas Economics Starter

    Oil and gas project economics for engineers, students and non-economists, in one Excel workbook. It covers discounting, a 20-year field cash flow, NPV, IRR, payback, exposure and breakeven price, a sensitivity spider plot, real against nominal price decks, and project ranking, with 11 colourful charts. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Tank and Vessel Calculator

    Volume at any level for seven tank and vessel shapes, in one Excel workbook. It builds strapping tables, finds the level for any volume, sizes pressure vessel walls to ASME VIII, and turns tank gauges into net standard barrels and tonnes for a whole tank farm, with 8 colourful charts. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Steel Pipe and Casing Tables

    Casing, tubing, drill pipe and line pipe tables in one Excel workbook: 110 sizes with ID, drift, capacity, displacement, burst, collapse and body yield for any of 18 API grades, calculated live with API 5C3 formulas. It includes a design check with safety factors and 9 colourful charts. No macros, no add-ins.
    image
    Premium  icon
    Download

    Oil and Gas Calculator Toolbox

    58 quick calculators for everyday oil and gas field work, in one Excel workbook. It covers the rig site, mud mixing, cement and pipe, production operations, energy and cost, and quick conversions, each with live inputs and an instant answer, plus 9 colourful charts. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Oilfield Glossary and Abbreviations

    509 oil and gas abbreviations and terms in plain English, in one searchable Excel workbook. Type any word to find it, browse A to Z by discipline, and test yourself with flashcards. Built for students, new graduates, non-engineers and anyone new to the industry. No macros, no add-ins.
    image
    Premium  icon
    Download

    Fluid Properties Calculator (PVT for All)

    Oil, gas and water properties from five inputs, in one Excel workbook. It covers bubble point, solution GOR, Bo, oil viscosity and density, Z-factor, Bg, gas viscosity and density, water FVF, viscosity and compressibility, with full pressure tables, a one-pressure calculator, fluid gradients and 10 colourful charts. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Oil and Gas Formula Handbook

    Essential oil and gas formulas in one Excel workbook, each a live calculator with a worked example. It covers drilling, well control, cementing, reservoir, decline, PVT, well testing, production, facilities and economics, from basic to advanced, with an index and 9 colourful charts. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Oil and Gas Unit Conversion Master Workbook

    Every oil and gas unit in one Excel workbook: 54 quantities and 355 units, oilfield and SI, from basic to drilling, reservoir, production and economics. Pick a quantity, type a value and choose the units from drop-down lists, and the answer updates instantly. It includes printable conversion tables, oilfield calculators, 15 colourful charts and 28 self-marking exercises. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Hydrogen and Gas Storage Master Workbook

    Underground hydrogen storage compared with natural gas, in a single Excel workbook. It covers hydrogen and methane properties, salt cavern pressure limits and working gas, depleted-field storage and well deliverability, the seasonal cycle, and levelised cost of storage. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Geomechanics Master Workbook

    A one-dimensional mechanical earth model and the decisions it drives, in a single Excel workbook. It covers the stress and pore pressure profile, safe mud-weight window, collapse against inclination, sand production with depletion, fault reactivation and slip tendency, and reservoir compaction and surface subsidence. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Geothermal Energy Master Workbook

    Oil and gas skills applied to geothermal, in a single Excel workbook. It covers heat in place and capacity, doublet flow and pumping, binary power against direct heat, thermal breakthrough and well spacing, and levelised cost of electricity and heat with CO2 avoided. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Process Safety Master Workbook

    From a leak to the risk number, in a single Excel workbook. It covers release rates and blowdown, jet and pool fire radiation, flammable and toxic gas dispersion, vapour cloud explosion overpressure, LOPA with SIL selection, and worker individual risk against the UK HSE criteria. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Pipeline and Flow Assurance Master Workbook

    A subsea tieback from the manifold to the slug catcher, in a single Excel workbook. It covers multiphase pressure profile, thermal design and cool-down, hydrate risk and inhibitor dosing, wax and pigging, slug sizing, and erosion and CO2 corrosion. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Decommissioning and Well Abandonment Master Workbook

    Late-life planning for an offshore field in a single Excel workbook. It covers permanent barrier depth, cement plug design, well P&A duration and cost by vessel, campaign learning curve, facilities removal by work-breakdown element, and the decommissioning liability with tax relief and deferral. Built around the OEUK guidelines and NORSOK D-010. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Petroleum Economics and Reserves Master Workbook

    From reserves to the investment decision, in a single Excel workbook. It covers PRMS reserves categories and portfolio aggregation, decline-based proved reserves, field cash flow, concession against production sharing contract, NPV sensitivity and exploration decision analysis. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    CCS Master Workbook

    A CO2 storage project from the molecule to the money, in a single Excel workbook. It covers CO2 density and phase behaviour, storage capacity, injectivity, plume and pressure build-up, dense-phase pipeline sizing and cost per tonne against the carbon price. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Completion and Stimulation Master Workbook

    The five decisions that set a well's productivity, in a single Excel workbook: tubing stress, perforation design, hydraulic fracture design, matrix acidizing and sand control. Each uses its standard published method, with charts and a check on every result. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Gas Engineering Master Workbook

    A gas field from composition to value in a single Excel workbook. It covers gas properties and Z-factor, p/Z material balance, gas well deliverability, liquid loading and a 20-year field forecast with economics. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Petrophysics Master Workbook

    A full well-log interpretation in a single Excel workbook, from raw curves to net pay and oil in place. It covers shale volume, porosity, Archie and Simandoux water saturation, Pickett and density-neutron crossplots, pay flags, zone summaries and parameter sensitivity, with every pick checked on a crossplot. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Well Test Analysis Master Workbook

    Pressure transient analysis from the diagnostic plot to the answer, in a single Excel workbook with type curves computed inside it. It covers wellbore storage and skin type curves, drawdown and buildup analysis, boundary detection, gas well deliverability and test design. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Unconventional Wells Master Workbook

    One horizontal shale oil well worked from hydraulic fracture design to section development in a single Excel workbook, the way US operators evaluate wells. It covers PKN fracture geometry, the modified-Arps type curve and EUR, rate transient analysis, monthly well economics, well spacing and completion size. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Chemical Engineering Master Workbook

    Seven core chemical engineering unit operations worked from first principles in a single Excel workbook: vapour-liquid equilibrium, distillation, reactor design, gas absorption, heat transfer, combustion and process control. Each uses its classic textbook method on a real system, with charts and a check on every result. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Process Engineering Master Workbook

    FEED-level sizing of an oil and gas processing facility in a single Excel workbook, from the design basis to the equipment list. It covers separator sizing, line sizing, pipe wall thickness, pump and compressor selection, heat exchanger rating, relief valve sizing and control valve sizing. Each method follows its code or standard (API, ASME, TEMA, NORSOK, IEC), and every design check is stated against its criterion. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Drilling Engineering Master Workbook

    One directional well planned from the pressure window to the cost estimate in a single Excel workbook. It covers pore and fracture pressure, casing seats, trajectory, casing design, torque and drag, hydraulics, well control, cementing, drilling performance, and time and cost. Every result is checked against a limit, and every input sits on one sheet. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Production Engineering Master Workbook

    One producing oil well worked from fluid properties to the choice of artificial lift in a single Excel workbook. It covers inflow performance, tubing pressure traverses, nodal analysis, choke sizing, erosional velocity, hydrates, gas lift, ESP design, decline analysis, lift screening and lift economics. Every result is checked against a limit, and every input sits on one sheet. Live formulas only, no macros, no add-ins.
    image
    Premium  icon
    Download

    Reservoir Engineering Master Workbook

    One oil reservoir worked from fluid properties to waterflood economics in a single Excel workbook. It covers PVT, oil in place with a Monte Carlo range, well test analysis, material balance with water influx, inflow performance, decline analysis, waterflood recovery, economics and advanced checks. Each method is checked against another, and every input sits on one sheet. Live formulas only, no macros, no add-ins.
    image
    Download

    PEA Excel Library Master Index: 1,000+ Petroleum Engineering Workbooks

    The full list of every workbook in the PEA Petroleum Engineering Excel Library, in one Excel file.1,000+ workbooks, sorted into 22 categories: drilling, reservoir, production, petrophysics, well testing, PVT, artificial lift, surface facilities, petroleum economics and more.For each workbook you can see the file name, the topic, the category, the type (calculator, studio, dashboard or compendium) and which bundle it sits in. Filter by category or press Ctrl+F and type any keyword, such as Horner, ESP or PSC, to find what you need in seconds.Download it free and check exactly what is inside the library
    image
    Download

    Petroleum Engineering Master Workbook

    Takes one oil field from logs to cash in a single workbook. It works out net pay, porosity and water saturation from the logs, groups the rock into types, builds the PVT, and puts oil in place at P90/P50/P10 with a Monte Carlo. From there it forecasts production, sets the mud-weight window and kill mud, finds the well's operating rate where inflow meets outflow, and ends with NPV, IRR and a one-page dashboard.Every result comes with a plain-English flag that states the value and the limit it is checked against.Built in Microsoft Excel. Live formulas only. No macros, no add-ins, no coding.
    image
    Premium  icon
    Download

    Well Completion — PEA Working Calculator

    Runs productivity ratio up with shot density and finds where more perforations stop paying off, instead of just specifying a shot density and hoping. On the built-in example total skin comes to 3.21, productivity ratio reaches 0.703 of ideal, at a 4.00 shots-per-foot design density. Every shot density a live formula, no macros. Swap in your own completion design in a minute.
    image
    Premium  icon
    Download

    Surface Facilities — PEA Working Calculator

    Sizes a relief valve orifice against gas relief rate and checks it against the separator's own gas velocity margin, not two disconnected calculations. On the built-in example that's a 7.63 gas velocity margin, 5.00-minute liquid retention, and a 0.424 in² required PSV orifice area. Every rate a live formula, no macros. Swap in your own facility design in a minute.
    image
    Premium  icon
    Download

    Separator and KOD Sizing — PEA Working Calculator

    Sizes a knockout drum against droplet settling velocity and finds the length that a given diameter actually needs, instead of quoting one number in isolation. On the built-in example that's 4.85 ft/s flare dropout velocity, 134 ft³ flare liquid holdup, and a 245 psig SAGD KOD design pressure. Every diameter a live formula, no macros. Swap in your own relief case in a minute.
    image
    Premium  icon
    Download

    Reserves and PRMS — PEA Working Calculator

    Runs oil in place through to a PRMS-consistent reserves number, using volumetric, probabilistic and performance methods together instead of picking one and hoping. On the built-in example that's 104 MMSTB in place, 36.5 MMSTB ultimate recovery, a 0.350 recovery factor — every number a live formula you can trace back to the assumption behind it. No macros. Swap in your own field data in a minute.
    image
    Premium  icon
    Download

    Process Safety Engineering — PEA Working Calculator

    Runs radiation intensity out from a flare and ties it back to a HAZOP/LOPA risk picture, instead of treating safety studies and flare sizing as separate exercises. On the built-in example the highest HAZOP score after action is 10.0, with 1 finding still rated HIGH or above and a scenario frequency of 0.0003 per year — below the ALARP line, shown, not assumed. Every distance a live formula, no macros. Swap in your own scenario and layout in a minute.
    image
    Premium  icon
    Download

    Pipeline Engineering — PEA Working Calculator

    Runs a pipeline's hydraulic gradient end to end and sizes the pump station off it, instead of guessing at discharge pressure. On the built-in example oil velocity comes out at 4.86 ft/s, requiring 840 psig pump discharge pressure and 306 BHP pump power. Every mile a live formula, no macros. Swap in your own line and fluid in a minute.
    image
    Premium  icon
    Download

    Oil & Gas PVT Properties — PEA Working Calculator

    Builds a full PVT table from field-standard correlations and shows exactly where the fluid changes behavior — the bubble point. On the built-in example that's 2,463 psia bubble point Pb, 600 scf/STB solution GOR, and 1.34 RB/STB oil formation volume factor Bob at that point. Every pressure step a live formula, no macros. Swap in your own fluid properties in a minute.
    image
    Premium  icon
    Download

    LNG Economics — PEA Working Calculator

    Prices a full LNG chain from feed gas to delivered cargo and shows how the investment case actually moves with discount rate, not just at one number. On the built-in example that's 1.50 Bscf/d feed gas, 9.50 MTPA of LNG production, and 121 cargoes a year. Every stage a live formula, no macros. Swap in your own project numbers in a minute.
    image
    Premium  icon
    Download

    Hydraulic Fracturing — PEA Working Calculator

    Runs surface treating pressure up with pump rate using PKN fracture geometry, then ties it through to the productivity payoff, not just a job design in isolation. On the built-in example that's 6,300 psi closure pressure, 6,800 psi BHTP, and 3,975 psi STP at the pump rate shown. Every stage a live formula, no macros. Swap in your own formation and treatment design in a minute.
    image
    Premium  icon
    Download

    Geomechanics — PEA Working Calculator

    Builds the full stress state with depth — vertical, minimum and maximum horizontal — and checks wellbore stability against it instead of one assumed gradient. On the built-in example that's 8,500 psi vertical stress against 5,943 psi Shmin and 8,023 psi Shmax at the depth shown. Every layer a live formula, no macros. Swap in your own well and stress data in a minute.
    image
    Premium  icon
    Download

    Gas Processing — PEA Working Calculator

    Runs gas properties through dehydration and NGL recovery in one sheet, so a spec change upstream shows up in liquids yield downstream. On the built-in example that's 0.750 specific gravity gas, 1,216 Btu/scf heating value, and 2.87 gal/Mscf NGL recovery. Every stream a live formula, no macros. Swap in your own gas composition in a minute.
    image
    Premium  icon
    Download

    Flow Assurance — PEA Working Calculator

    Runs the temperature profile down a flowline and checks it against the hydrate curve at every point, not just at the outlet. On the built-in example outlet temperature lands at 80.4°F against a 66.2°F hydrate temperature, leaving a 14.2°F flowing margin. Every foot a live formula, no macros. Swap in your own line and fluid in a minute.
    image
    Premium  icon
    Download

    Enhanced Oil Recovery — PEA Working Calculator

    Screens a reservoir against every EOR method on one ladder, then runs the CO2 miscible case through to a real MMP and recovery number. On the built-in example the reservoir passes 6 of 6 CO2 screening criteria, MMP comes out at 2,245 psia, and 25.1 MMSTB of target oil is swept. Every step a live formula, no macros. Swap in your own reservoir data in a minute.
    image
    Premium  icon
    Download

    Drilling Fluids — PEA Working Calculator

    Builds the flow curve from rheometer readings and checks where the mud weight actually sits in the operating window, not just what's written on the ticket. On the built-in example that's 12.0 ppg mud weight sitting at 0.459 of the way through the window, with ECD at 12.5 ppg once cuttings are loaded. Every point a live formula, no macros. Swap in your own mud program in a minute.
    image
    Premium  icon
    Download

    Decommissioning — PEA Working Calculator

    Tracks unit cost down a P&A campaign as wells get abandoned, showing the learning curve real programs see instead of one flat per-well estimate. On the built-in example 18.0 wells cost $13.1M total, working out to $730,271 per well by the end of the campaign. Every well a live formula, no macros. Swap in your own well count and cost basis in a minute.
    image
    Premium  icon
    Download

    Corrosion and Materials — PEA Working Calculator

    Runs the de Waard corrosion model against temperature and finds where the rate actually peaks, instead of assuming worst-case is at the highest temperature. On the built-in example that peak Kt is 10 at the CO2 partial pressure and in-situ pH shown, giving a 1.25 mm/yr bare corrosion rate. Every point a live formula, no macros. Swap in your own fluid and pipe data in a minute.
    image
    Premium  icon
    Download

    Cementing Design Engineering — PEA Working Calculator

    Runs full slurry design and sack counts against actual hydrostatic pressure down the well, not a rule-of-thumb yield number. On the built-in example that's 1,411 total sacks, split 371 tail and 1,040 lead, every quantity a live formula you can trace back to the hole and casing geometry. No macros. Swap in your own well design in a minute.
    image
    Premium  icon
    Download

    Carbon Capture, Use and Storage — PEA Working Calculator

    Tracks a CCS project's net cash flow through capture, compression and storage, credit included, not treated as an afterthought. On the built-in example that's 0.250 Mt/yr CO2 stored, 5.00 Mt over the project life, at 405 kg/m³ density in the reservoir. Every stage a live formula, no macros. Swap in your own project numbers in a minute.
    image
    Premium  icon
    Download

    Artificial Lift — PEA Working Calculator

    Compares lift methods on one well instead of picking one blind — rod pump, gas lift, ESP, side by side. On the built-in example the pump delivers 165 bpd at 12,340 ft-lb polished rod load and 20,532 psi rod stress, every number a live formula you can trace back to well and fluid data. No macros. Swap in your own well in a minute.
    image
    Premium  icon
    Download

    Well Control — PEA Working Calculator

    Identifies the kick from its own influx gradient, then runs the full kill sheet off it — shut-in pressures to kill mud weight to the drillpipe pressure step-down driller works to. On the built-in example that's a 0.127 psi/ft influx gradient, 4,768 psi formation pressure, and 11.5 ppg kill mud weight, every number a live formula you can trace back to the shut-in data behind it. No macros, no add-ins. Swap in your own kick data in a minute.
    image
    Premium  icon
    Download

    Well Integrity — PEA Working Calculator

    Tracks barrier envelope status against annulus pressure and computes MAASP directly from fluid weight, instead of treating well integrity as a checklist. On the built-in example the primary barrier envelope carries 1 overdue item while the secondary shows none, with MAASP reading 1,468 psi at the given annulus fluid weight — every number a live formula you can trace back to the barrier and pressure data behind it. No macros, no add-ins. Swap in your own well and barrier status in a minute.
    image
    Premium  icon
    Download

    Well Test Analysis — PEA Working Calculator

    Runs a buildup two independent ways at once — Horner semilog and the Bourdet derivative — and checks that they agree instead of trusting one method alone. On the built-in example both read 150 md permeability, a 1.00 agreement ratio, every number a live formula you can trace back to the pressure and time data behind it. No macros, no add-ins. Swap in your own buildup data in a minute.
    image
    Premium  icon
    Download

    Drilling Engineering — PEA Working Calculator

    Runs the mud weight window from surface to TD and checks it at the shoe, not just at bottom — where a design can pass at TD and still fail on the way down. On the built-in example that's a 1.45 ppg overbalance at TD, ECD reading 10.5 ppg, and 4.00 ppg of headroom still left at the shoe. Every number a live formula, no macros, no add-ins. Swap in your own well plan in a minute.
    image
    Download

    Petroleum Economics & Fiscal Systems — PEA Working Calculator

    Runs full-field cash flow under a concession fiscal regime and tracks it month by month, past the deep negative capex years to breakeven and payback. On the built-in example that's a $447M NPV10, a 26.0% IRR, and 4.95 years to payback — every number a live formula you can trace back to the price deck and fiscal terms behind it. No macros, no add-ins. Swap in your own field and fiscal regime in a minute.
    image
    Premium  icon
    Download

    Petrophysics & Log Interpretation — PEA Working Calculator

    Runs a real gamma ray log through the full net pay workflow — Vshale, porosity, saturation, then cutoffs applied to find what's actually productive. On the built-in example a 102 ft gross interval nets down to 30.0 ft of pay, a 0.294 net-to-gross ratio, every step a live formula you can trace back to the log curve behind it. No macros, no add-ins. Swap in your own log data in a minute.
    image
    Premium  icon
    Download

    Production Engineering — PEA Working Calculator

    Runs a full production system in one sheet — IPR, VLP, nodal crossing, multiphase flow, gas lift and ESP sizing, all connected. On the built-in example the ESP is pulling 3,000 bopd against a 2,793 psia flowing BHP, with a 507 psi drawdown, every number a live formula you can trace back to the well data behind it. No macros, no add-ins. Swap in your own well in a minute.
    image
    Premium  icon
    Download

    Reservoir Engineering — PEA Working Calculator

    Runs OOIP two independent ways — volumetric and material balance — and checks them against each other instead of trusting one number in isolation. On the built-in example both methods land within 0.4% of each other, 104 MMSTB volumetric against 104 MMSTB material balance, a 0.996 ratio that tells you the reservoir model actually holds together. Covers decline analysis and recovery on top of that, all live formulas, no macros, no add-ins. Swap in your own field data in a minute.
    image
    Premium  icon
    Download

    Collapse Is Not What Sizes It — PEA Working Calculator

    Runs a casing string's actual load line against what each pipe grade allows, instead of stopping at a single "collapse rating" number. On the built-in example the margin comes out at 4.8x the requirement — 1.125 times what's actually needed — showing how much of a standard string is safety margin nobody checks. Every depth a live formula, no macros. Swap in your own well and casing program in a minute.
    image
    Premium  icon
    Download

    Water Influx (Fetkovich Aquifer)

    Fits the Havlena-Odeh straight line to find aquifer size and confirm the Fetkovich model actually applies, instead of assuming a water drive fits without checking. On the built-in example the aquifer carries 117.4 MMstb in place, and it's supplying 87% of the field's pressure support — a field that would misread as depleting fast without this check. Every point a live formula, no macros. Swap in your own field's pressure and production history in a minute.
    image
    Premium  icon
    Download

    Gas Lift Design

    Spaces gas lift valves down the string and finds the optimum injection rate, instead of stopping at valve placement and leaving rate to guesswork. On the built-in example that's 10 valves placed and a 1,200 Mscf/d optimum — past that point more gas actually costs oil, and the sheet shows exactly where the curve turns over. Every valve a live formula, no macros. Swap in your own well and injection gas in a minute.
    image
    Premium  icon
    Download

    ESP Sizing

    Sizes an electrical submersible pump against the well's actual duty point — free gas handling, total dynamic head and the pump curve intersecting at the target rate, not a catalog guess. On the built-in example that's 320 stages and 163 brake horsepower at 3,000 stb/d, both a direct read off the head curve. Every stage a live formula, no macros. Swap in your own well and pump curve in a minute.
    image
    Premium  icon
    Download

    Torque & Drag

    Marches hook load and torque interval by interval down the trajectory using the soft-string model, instead of one lumped friction estimate for the whole well. On the built-in example hook load tripping out runs 2.21x higher than tripping in, and surface torque reads 11.8 k ft-lb at the working friction factor — both direct reads off the chart as friction factor shifts. Every interval a live formula, no macros. Swap in your own trajectory and mud program in a minute.
    image
    Premium  icon
    Download

    Well Economics

    Prices a single well against oil price, live — NPV, IRR, payout and breakeven all recalculating as the price dial moves. On the built-in example the well breaks even at $46/bbl and returns 58% IRR at today's price, both a direct read off the chart, not a separate model to rebuild. Every term a live formula, no macros. Swap in your own well cost and production profile in a minute.
    image
    Premium  icon
    Download

    Waterflood Pattern Sweep

    Predicts waterflood performance from displacement, areal and vertical sweep together, instead of the single-number recovery factor most sheets stop at. On the built-in example only 10.7% of oil is recovered by breakthrough, and switching to polymer flooding lifts that by 1.70x, both a direct read of mobility ratio's grip on sweep. Every term a live formula, no macros. Swap in your own reservoir and fluid data in a minute.
    image
    Premium  icon
    Download

    Pore Pressure & Frac Gradient

    Predicts pore pressure from the Eaton d-exponent method and fracture gradient in one sheet, then checks whether the casing shoe is actually placed where it needs to be. On the built-in example the shoe sits 1.7 ppg short of margin, leaving only 3,000 ft of hole before the next casing point is forced — a well plan that looks fine on paper until this check runs. Every step a live formula, no macros. Swap in your own drilling data in a minute.
    image
    Premium  icon
    Download

    Choke & Erosional Velocity

    Sizes a choke for critical flow, then checks it against API RP 14E erosional velocity — two separate constraints most sheets treat as one. Runs four different C factors side by side, and on the built-in example they spread 22% apart on required diameter, with the tightest choke setting running 21% over the erosional limit. Every case a live formula, no macros. Swap in your own rate and pressure conditions in a minute.
    image
    Premium  icon
    Download

    Cement Job Design

    Tracks surface pressure through a full cement job, U-tube effect and all — the pressure that actually swings negative as heavier cement falls and lighter mud rises on the other side. On the built-in example the well runs on vacuum for 82% of the pumping schedule, and 759 ft of shoe sits bare of cement, both numbers most job sheets never show. Every stage a live formula, no macros. Swap in your own hole and slurry design in a minute.
    image
    Premium  icon
    Download

    Sucker Rod Pumping

    Sizes a sucker rod pump properly by getting the plunger stroke right — rod stretch and overtravel eat 28% of the surface stroke on the built-in example, and an unanchored tubing loses another 22 bbl/d nobody accounts for. Runs the Goodman diagram against the rod loads so you know the string is actually rated for the duty, not just pumping. Every step a live formula, no macros. Swap in your own well and rod string in a minute.
    image
    Premium  icon
    Download

    Perforating & Completion Skin

    Breaks total skin apart into its five separate causes — perforations, crushed zone, partial penetration, deviation, and formation damage — instead of treating skin as one number with one fix. On the built-in example total skin is 4.3, and none of it is damage, which means acid won't help; the fix is a perforating or deviation change, and the sheet tells you which. Every term a live formula you can trace, no macros. Swap in your own well and completion design in a minute.
    image
    Premium  icon
    Download

    Separator Sizing

    Sizes a three-phase separator by finding which of two competing jobs actually governs — gas needs area, liquid needs retention volume, and the file finds the crossover instead of assuming it. Both key design constants are derived from first principles, not quoted: Stokes settling comes out at 1.786×10⁻⁶ against the published 1.78×10⁻⁶, and the Souders-Brown K works out to 0.16, not the 0.35 everyone uses — the difference between a real settling calculation and a mist-extractor spec, and it's a 54% swing in vessel size. On the built-in Falcon Field stream (8,000 stb/d oil, 4,000 bwpd, 7.2 MMscf/d) the answer is a 54"×17.7 ft vessel, with the liquid side governing by a factor of 22. Every number a live formula, no macros. Swap in your own stream in a minute.
    image
    Premium  icon
    Download

    Gas Well Deliverability (Four-Point Test)

    Runs the classic four-point deliverability test properly — pr²−pwf² plotted on log-log, slope and intercept solved by regression, extended to absolute open flow. On the built-in example it reads 15,669 Mscf/d AOF, with a 10.7% spread flagged between the Rawlins-Schellhardt and LIT methods so you know how much to trust the number. Every point a live formula, no macros. Swap in your own four-rate test data in a minute.
    image
    Premium  icon
    Download

    Casing Design (Burst, Collapse, Tension, Triaxial)

    Runs a casing string against all three loads at once — burst, collapse and tension — plus a triaxial check, not just the single-load pass most sheets stop at. On the built-in example it picks 53.5 lb/ft as the lightest string that passes, and shows the design factor drops to 0.95 one size down, right at the edge of failing. Every load line and pressure profile is a live formula you can trace, no macros. Swap in your own well and mud program in a minute.
    image
    Premium  icon
    Download

    Well Trajectory (Minimum Curvature)

    Builds a directional well path properly — minimum curvature, not the tangential shortcuts that quietly misplace the bit. On the built-in example the well lands at 6,757 ft TVD with a worst dogleg of 2.50°/100ft, every step a live formula you can trace. No macros. Swap in your own survey stations and it recalculates the whole path in a minute.
    image
    Premium  icon
    Download

    Pressure Buildup (Horner + Bourdet Derivative)

    Runs a buildup the way it's actually interpreted — Horner semilog plot alongside the Bourdet derivative, so the radial flow stem is confirmed, not assumed. On the built-in example it reads 49.1 md permeability and a skin of 2.81, both live formulas you can click and trace. No macros, no black box. Swap in your own shut-in pressure and time data in a minute.
    image
    Premium  icon
    Download

    Drilling Hydraulics

    Optimizes bit hydraulics and tracks ECD in one live sheet — pressure losses split across the whole circulating system, then swept against flow rate to find the nozzle sizing that puts the most horsepower at the bit, not wasted in the string. On the built-in example that's 45% of pump pressure landing at the bit, with ECD holding at 12.45 ppg. No macros, every number a formula you can click and trace. Swap in your own hole geometry and mud program in a minute.
    image
    Premium  icon
    Download

    Well Kill Sheet

    Shut-in pressures and a pit gain go in; kill mud weight, both circulating pressures, stroke counts and the full drillpipe pressure schedule come out — the sheet a driller actually works to. Identifies the kick type from its own pressure signature — gas, oil or salt water — before anything reaches surface. Solves the part most kill sheets skip: gas rising and expanding, casing pressure computed in closed form at thirteen depths so you see the peak coming before it arrives. Checks the shoe properly too — on the built-in example, peak surface pressure exceeds MAASP and the shoe still holds, with 641 psi to spare, for a reason the sheet explains. Pre-loaded with PEA-9, a 20-bbl gas kick at 10,000 ft — swap in your own well data in a minute. For training, planning and checking, not a replacement for approved operator kill procedures.
    image
    Premium  icon
    Download

    Rate Transient Analysis

    Solves decline analysis's real limit — real wells don't run at constant flowing pressure — by changing the clock (material balance time), so variable-rate data behaves like constant-rate data. The boundary-dominated stem is exactly harmonic, so the match is done by arithmetic, not by dragging a type-curve overlay and hoping two people get the same answer. Returns what decline analysis can't: drainage volume, drainage area, productivity index and permeability — recovers a planted 1.00 md to within a tenth of a percent on the built-in example. Separates transient from boundary-dominated flow automatically, since fitting one as the other is the most expensive mistake in production analysis. Pre-loaded with PEA-8, two years of daily Falcon Field data through two rate changes — swap in your own well in a minute.
    image
    Premium  icon
    Download

    Flowing Material Balance

    Gets oil-in-place without shutting the well in — just the rate and flowing pressure the well already reports. One straight line does it all: y-intercept is productivity index, x-intercept gives OOIP times compressibility. Survives what kills decline analysis — the built-in example has the choke opened up halfway through, and both halves still agree to within a fifth of a percent. Turns the volume into a drainage area and radius you can put on a map, so you can see if wells are competing for the same oil. Pre-loaded with PEA-2, Falcon Field (two years of monthly rate and pressure) — swap in your own well in a minute.
    image
    Premium  icon
    Download

    Relative Permeability

    Set the endpoints and exponents and it builds the curves, the fractional flow they imply, and the recovery they predict — Corey and LET side by side, so you can bend a curve to lab data without losing a defensible form. The Welge tangent is built in, finding flood-front saturation and breakthrough water cut with no calculus and no solver. Ends with a SWOF table that's actually deck-ready — correctly ordered, endpoints exact, capillary pressure capped — copy straight into a simulator. Pre-loaded with Falcon Field sandstone (connate water 0.20, residual oil 0.25) — swap in your own core data in a minute.
    image
    Premium  icon
    Download

    Critical Lift Rate

    Computes the gas rate below which a well stops carrying its own water to surface — and how much margin your well has left today. Runs both published methods side by side, Turner and Coleman, which disagree by 20% on the same well, and shows which one applies at your pressure. Answers the real question — at what wellhead pressure will this well load up — and prices the fix, six standard tubing strings sized against your expected rate. Pre-loaded with PEA-6, a Falcon Field gas well at 400 psia making 1.2 MMscf/d with water — swap in your own well in a minute.
    image
    Premium  icon
    Download

    RFT/MDT Pressure Analysis

    Paste your formation-tester depths and pressures and it fits a gradient line to each fluid, turns the slope into a density, and reports the gas-oil and oil-water contacts to the foot — by least squares, not dragged by eye. Checks itself three ways: gradients against published fluid bands, each station against its own line, and oil density against your PVT (accurate to a quarter degree API on the built-in example). Also prices the uncertainty — how far a contact moves if a gradient is off by a hundredth of a psi per foot. Pre-loaded with PEA-4, a 24-station Falcon Field appraisal run through gas cap, oil column and aquifer — swap in your own run in a minute.
    image
    Premium  icon
    Download

    PVT Correlations

    Give it oil gravity, gas gravity, solution GOR and temperature — four numbers — and it builds the whole fluid table: bubble point, Rs, Bo, Bt, oil and gas viscosity, z-factor and Bg at every pressure you need. All explicit correlations, no solver, so it recomputes instantly when you change a number. Shows bubble point two ways, Standing and Vazquez-Beggs, because they disagree by 13% on the built-in fluid and most engineers never check that. Charts the signature shapes — Bo peaking and viscosity bottoming out right at the bubble point — so you can see if your table is behaving. Pre-loaded with Falcon Field oil (32° API, 500 scf/stb, 180°F) — swap in your own fluid in a minute.
    image
    Premium  icon
    Download

    Nodal Analysis (IPR + VLP)

    Finds where a well actually flows — the crossing of what the reservoir delivers and what the tubing can carry. Runs a real 8-segment outflow march down the tubing, with gas breaking out of solution and friction handled properly, not one lazy average gradient. Compares three tubing sizes side by side plus a wellhead-pressure trade, each a full re-run of the whole well. Ends where it matters: how much rate a tubing change actually buys, and how much of the well's potential you're currently using. Pre-loaded with PEA-2, Falcon Field (7,000 ft oil well, 2-7/8" tubing) — swap in your own well in a minute.
    image
    Premium  icon
    Download

    Volumetrics & Reserves

    Give each input a low, best and high estimate and it returns the full range — P90, P50, P10, the mean, and the S-curve behind them — no Monte Carlo, no macro, just log-space arithmetic done properly. Tells you which input is actually costing you certainty, with a variance ranking and swing chart showing where an appraisal well or better seismic would pay for itself. Recoverable volume carries the recovery factor's own uncertainty too, so the P90 you quote is a real P90. Pre-loaded with a Falcon Field appraisal example (640-acre Gulf Coast sandstone) — swap in your own prospect in a minute.
    image
    Premium  icon
    Download

    Gas Material Balance (p/z)

    Type in your field's production and pressure history and it draws the classic p/z line, extends it to zero, and reads off the gas in place — the oldest and most trusted measurement in gas reservoir engineering. Z-factor computed automatically by Papay's correlation, but the yellow cell is open for your own lab values. Runs the water-drive check most spreadsheets skip, catching a pressure-supported pool before it lies to you on the plot. Pre-loaded with a real worked example (Falcon Field dry-gas pool, ten pressure surveys, 31.9 Bscf produced) — swap in your own field in a minute.
    image
    Premium  icon
    Download

    Decline Curve Analysis & Reserves

    Paste your own monthly production rates into the yellow column and it fits an Arps decline for you — 30 trial b-values solved by least squares, the best one picked in the open, returning EUR, remaining reserves and years left. Built-in terminal-decline switch stops hyperbolic forecasts from promising oil forever, and the economic limit is computed from your price and cost inputs, not assumed. Shows the uncertainty most tools hide: if your data can't tell b = 0.55 from b = 0.65, this sheet says so and prices both. Comes pre-loaded with a 36-month worked example (PEA-2, Falcon Field) — replace it with your own well in under a minute.
    image
    Premium  icon
    Download

    Petrophysics — Expert-Edition Master Workbook

    A real 22-level log suite runs the whole book — gamma ray, density, neutron and resistivity in proper depth tracks — as you build shale volume, porosity from logs, Archie's saturation from first principles, the Pickett plot, shaly-sand Simandoux, and full rock typing (RQI, FZI, Winland R35) with permeability predicted and audited against core. Ends in cutoffs and net pay for a real 96-ft interval with an oil leg, a shaly streak, a tight zone and a water contact. Honest throughout — Archie's shaly-sand bias is computed level by level, not hidden. Built for training rooms, company induction, and petrophysicists' and geologists' daily CPI work.
    image
    Premium  icon
    Download

    Reservoir Engineering Fundamentals — Expert-Edition Master Workbook (Flagship Sample Volume)

    One well, one field, every reservoir engineering fundamental connected in live formulas — porosity, permeability, capillary pressure, PVT, volumetrics, radial flow, well testing, pressure buildup, material balance and decline curves. The Horner engine centrepiece recovers permeability, skin and p* straight from raw shut-in gauge data. Every big number is cross-checked two ways — core permeability vs. well-test permeability, volumetric OOIP vs. material-balance OOIP — and they agree, live. Built for training rooms, company induction, and working engineers' daily sanity checks on real field decisions.
    image
    Premium  icon
    Download

    Petroleum Production Engineering — Expert-Edition Master Workbook

    The complete production system built live from IPR to the Xmas tree — a Vogel inflow curve, a 176-cell segmented pressure-traverse engine marching every rate down 7,000 ft of tubing for two tubing sizes, and the classic IPR-VLP nodal crossing that decides the well's real rate (1,715 vs 1,959 stb/d, not a guess). Covers choke sizing, wellhead and Xmas tree rating, flow assurance, and an artificial lift preview, all fed by 14 live charts. Honestly convicts the common shortcuts too — the single-average-pressure method is shown losing 477 psi of accuracy, right next to the method that doesn't. Built for training rooms, company induction, and production engineers' daily surveillance and completion decisions.
    image
    Premium  icon
    Download

    Reservoir Simulation in a Spreadsheet — Expert-Edition Master Workbook

    A live 15x15 pressure map of the Falcon Field block, built cell by cell from real transient physics — two producers pulling down pressure, an injector raising a mound, all redrawn as you turn the time dial from 1 day to 1 year. Includes a real finite-difference engine (20 blocks, 36 timesteps) that you can deliberately push past its stability limit to see a simulation go unstable — one of the most memorable lessons in numerical modeling. A balance audit shows exactly how much pressure leaks through the edges of any finite model, and the book ends by scoring three drilling locations straight off the live map. Built for training rooms, company induction, and reservoir engineers meeting their first simulator.
    image
    Premium  icon
    Download

    Drilling Engineering — Expert-Edition Master Workbook

    A complete well plan built from the mud window to the kill sheet — pressure windows, casing seat selection, mud design, hydraulics, well control, drillstring loads, bit economics and cementing, all in live formulas across 15 publication-grade charts. The centrepiece is a real kick worked start to finish: shut-in pressures become kill mud weight, pump schedule and the classic declining drillpipe-pressure line, exactly as it's used on a rig floor. Drilled through a depleted reservoir zone that squeezes the mud window and dictates casing depth — every dollar and every psi computed, not assumed. Built for training rooms, company induction, and drilling and wellsite engineers' daily work.
    image
    Premium  icon
    Download

    Petroleum Economics & Field Development — Expert-Edition Master Workbook

    A live cash flow engine that prices a full 6-well, $126M Falcon Field development from first barrel to final verdict — NPV, IRR, payout, all computed cell by cell across sixteen years. Turn the oil price dial between $50, $70 and $90 and watch the whole book, including a tornado sensitivity ranking and a resilience console, repaint instantly. Two real capital decisions — a workover vs. an infill well — are priced incrementally, the way brownfield dollars actually get approved. Includes CAPEX planning, OPEX modeling, fiscal terms, and a full worked example with live dashboard. Built for engineers facing their first AFE, training rooms, and anyone who signs, defends or challenges a development budget.
    image
    Premium  icon
    Download

    Well Test Type-Curve Atlas — Expert-Edition Master Workbook

    A hands-on Excel workbook that teaches pressure transient analysis from first principles — no pasted curves, no black boxes. Build the Bourdet derivative, run a live Stehfest-inversion Laplace engine (Gringarten & Bourdet type curves computed in cells you can click), match a real 150-hour PEA-5 buildup, cross-check with semilog analysis, and locate a sealing fault at 718 ft. Includes the signature gallery of seven classic derivative shapes, a dual-porosity primer, common interpretation failures explained, and a full worked example with live dashboard. Built for training rooms, company induction, and real well test interpretation work.
    logo
    GET IN TOUCH

    PETROLEUM ENGINEERS ASSOCIATION
    JHARKHAND, INDIA

    Contact : +91 6205464268
    Email: info@peassociations.com

    Tax Registration Number:
    20DIGPA7260B1Z1

    COMPANY
    About Us Contact Us Articles Download Certificate
    Become an instructor One on one mentorship Gallery Testimonials Feedback
    logo
    Payment Terms Privacy Policy Terms of Use Sitemap Cookie Preferences Security
    © 2026 Petroleum Engineers Association. All Right Reserved.
    Design & Developed By Bitstreaks Company Logo
    WhatsApp Whatsapp icon
    Let us know how we can assist you? logo
    Let us know how we can assist you? ✖

    PEA uses cookies and other tracking technologies to improve your browsing experience for the following purposes: to enable basic functionality of the website, to provide a better experience on the website, to measure your interest in our products and services and to personalize marketing interactions, to deliver ads that are more relevant to you.

    Change my preferences