---
id: po.wb.numerics.spline-interpolation
title: Spline Interpolation — PVT Table Application
category: Numerics
tags:
  - interpolation
  - spline
  - cubic
  - pvt
  - formation-volume-factor
---

# Spline Interpolation — PVT Table Application

## Purpose

Demonstrates cubic and linear spline interpolation on a real petroleum engineering problem:
interpolating Bo (oil formation volume factor) between lab measurement pressures. Shows where
cubic interpolation matters most — at high-curvature regions of the PVT curve.

## Plan

- [x] Lab data sheet with realistic Bo vs P measurements
- [x] Single-point query with named input cell
- [x] Derivative comparison (dBo/dP)
- [x] Full interpolation table at 26 pressure points
- [x] Cubic vs Linear comparison chart
- [x] Engineering narrative explaining the use case