---
cid: po.bp.pvt.lab.qc
hub: pvt
tags: [PVT, lab-QC, Y-function, CCE, differential-liberation, material-balance, Bod, Rsd, separator, Hoffman, Buckley, K-value, black-oil]
facets: { discipline: reservoir, phase: oil, property: relative-volume, method-type: analytical }
title: PVT Lab Report QC
summary: "Runs four standard consistency checks on a PVT lab report and flags the points that fall off their lines before a black-oil table is built."
slug: po.pvt.lab.qc
type: worksheet
---

# PVT Lab Report QC

## Description

Is the PVT report fit to build a black-oil table from? You enter the sample's gravity, bubble point and separator test, and paste the report's CCE, differential liberation (DL) and separator K-values. The sheet runs the four standard consistency tests on the one sample: Standing's Y-function, the DL material balance, the Hoffman-Crump-Hocott plot and Buckley's plot. You read off each test's line and fit, every point that falls off its line, and the DL converted to the separator basis.

**Parameters:**
- **The sample**: the stock-tank gravity `LQC_API` (the residual oil's here too), the CCE bubble point `LQC_Pb`, the separator test's GOR `LQC_Rsfb` and FVF `LQC_Bofb` at Pb, and the separator's pressure `LQC_SepP` (psia) and temperature `LQC_SepT`
- **Acceptance limits** (this sheet's choices): the least R² of the Y line `LQC_R2Min`, the largest departure of a point from it `LQC_YTol`, the largest DL density misfit `LQC_RhoTol` (g/cm³), and the largest Hoffman deviation `LQC_DevMax` in log10(K·p)
- **Tables**: the CCE above Pb (`LQC_AboveP`, `LQC_AboveV`) and below it (`LQC_CceP`, `LQC_CceV`); the DL stages (`LQC_DlP`, `LQC_DlRsd`, `LQC_DlBod`, the gravity of the gas released to reach each `LQC_DlGg`, and the reported density `LQC_DlRho`); the separator components (`LQC_Comp`, `LQC_K`, `LQC_Tb`, `LQC_Tc`, `LQC_Pc`)

**How to use it:** Paste the report's CCE below Pb, its DL stages from Pb to the atmospheric one, and K = y/x from the separator gas and liquid analyses over the blue cells, and set Pb, Rsfb, Bofb and the separator to the report's. Use the residual oil's own gravity for the material balance when the report gives it. Leave N2, CO2, H2S and the plus fraction out of the K-value plots. Three charts show the Y-function with its line, the DL density by material balance against the reported one, and the Hoffman plot.

**Method:**

- **Y-function.** For each CCE point below Pb, Y = (Pb − p)/(p·(V − 1)). It is near a straight line in pressure for a black oil, so the least-squares line Y = a + b·p and its R² test the whole set, and each point's Y over the line's, less 1, tests the point. The smoothed volume is 1 + (Pb − p)/(p·(a + b·p)).
- **CCE points.** Above Pb the oil only shrinks (V ≤ 1); below it it swells (V > 1). A point on the wrong side of the typed Pb is a FAIL: Pb or the table is wrong.
- **DL material balance.** The DL is checked by mass: each stage's oil density is rebuilt from the residual oil and the gas released below it and set against the reported one. The residual oil weighs ρr × 350.51 lb a barrel, ρr its specific gravity from the API. Going up from the last stage, each stage's oil holds the stage below plus the gas released between them, 0.0764·ΔRsd·γg lb; its density is that mass over Bod × 350.51. The misfit is that density less the reported one, at each stage.
- **Separator basis.** The DL's Bod and Rsd are per barrel of residual oil; the separator test converts them. With Bf = Bofb/Bodb, Bo = Bod·Bf and Rs = Rsfb − (Rsdb − Rsd)·Bf (Amyx, Bass and Whiting; McCain). The DL has to lie above the separator test (Bodb > Bofb, Rsdb > Rsfb); the converted Rs at the atmospheric stage should come out near 0.
- **Hoffman.** For each component b = log10(Pc/14.696)/(1/Tb − 1/Tc) and F = b·(1/Tb − 1/T); log10(K·p) on F is a straight line with a slope near 1 for a separator at equilibrium, and a component off it has a bad analysis.
- **Buckley.** log10 K on Tc², a rougher line read beside Hoffman's.
- **Checks.** Y-function: R² at least the least R² set and no point off by more than the largest departure set. CCE points: each on its side of Pb. DL material balance: every misfit within the largest density misfit set. Conversion: DL above the separator test, converted Rs not below 0. K-values: every Hoffman deviation within the largest deviation set.

**Example:** The sample is the PVT family's reference black oil, Ahmed's oil 2: 40.7 °API, a 0.855 gravity separator gas at 100 psig (114.7 psia) and 75 °F, 220 °F, Rsb 768 scf/STB, a measured bubble point of 2,620 psi and Bob of 1.474 bbl/STB. Those are measured. The reference oil's data carry no CCE below Pb, no DL on the residual-oil basis and no K-values, so the sheet uses illustrative data and says so on each table:
- above Pb, the Complete PVT Study workbook's four CCE points (3,000 to 4,500 psi, 0.99432 to 0.97219);
- below Pb, the Y-function lambda's worked example: five volumes from 1.0302 at 2,400 psi to 2.0938 at 800 psi, off the exact line Y = 1.6 + 0.0006·p and read to four places;
- a DL per barrel of residual oil with Bodb 1.532 and Rsdb 798 scf/bbl, made so that, converted with the separator test, it gives the workbook's depletion table back (rounded to whole scf and four places), plus an atmospheric stage at 220 °F (Bod 1.06). The liberated-gas gravities rise from 0.80 to 1.30, as in the material-balance lambda's example, and the reported densities run from 0.6353 to 0.7750 g/cm³;
- Wilson's K-values for methane to n-hexane at the reference oil's own separator (40.77 to 0.0269), the Hoffman lambda's example, with the GPA boiling points and critical constants.

The five CCE points below 2,620 psi give Y from 3.035 at 2,400 psi to 2.080 at 800 psi on the line a = 1.6026, b = 5.978 × 10⁻⁴ 1/psi, R² 0.99998, the farthest point (2,000 psi) only 0.075 % off: a consistent CCE and a right bubble point. Typing 2,500 psi for Pb instead bends the line (R² 0.18, the 2,400 psi point 23 % off). The residual oil's 0.82172 g/cm³ and the DL give densities from 0.6371 g/cm³ at Pb to 0.7752 at the atmospheric stage; the largest misfit against the report is 0.0025 g/cm³ (2.46 kg/m³) at 1,000 psi, within 5 kg/m³. Bofb/Bodb is 0.96214, and the converted DL is the workbook's depletion table to within half a unit (627.53 scf/STB for its 628 at 2,200 psi, 1.40136 bbl/STB for 1.4014), ending at 0.21 scf/STB at the atmospheric stage. The Hoffman line has a slope of 0.99919, an intercept of 1.17220 and R² 0.999996, every component within 0.004 of it (ethane the farthest, its K·p 0.83 % low); Buckley's falls at −4.414 × 10⁻⁶ per °R² with R² 0.99890.

## Validity

The tests check the report's internal consistency, not whether the sample represents the reservoir: a consistent report can still be of a contaminated or unrepresentative sample. A straight Y-function is the rule for black oils with little non-hydrocarbon gas; volatile oils and fluids rich in N2 or CO2 can curve, and points within a few percent of Pb scatter (V − 1 is a small difference of two readings), so drop or down-weight them rather than reject the test. The material balance needs the residual oil's density at 60 °F and Bod on the same residual basis; the sheet takes the stock-tank gravity for the residual oil, which a real DL residual differs from by a degree or two API. The conversion to the separator basis assumes the DL and the separator test shrink the oil alike at every pressure; it can give a small negative Rs near atmospheric pressure, which is taken as 0. The Hoffman line is straight for paraffins at separator pressures up to about 1,000 psia and curves above; Buckley's is a screening plot, judged against its neighbours rather than a fixed limit. The example's K-values are Wilson's, which is itself a vapour-pressure line through each component's critical point, the form Hoffman's factor straightens. They fall on the Hoffman line almost by construction (R² 0.999996) and so pass the K-value check; the check tests a real separator's gas and liquid analyses. The acceptance limits are this sheet's choices, not published thresholds.

The data below Pb, the DL and the K-values are illustrative; the reference oil's measured values are its bubble point, Rsb, Bob, gravities and separator conditions.

Named alternatives: an equation-of-state model tuned to the CCE, DL and separator tests, which tests consistency through the fit; the full compositional material balance of the liberated gases (Whitson and Brulé); and Standing's (1979) K-value line for low-pressure separators.

## References

- Standing, M.B. (1977). *Volumetric and Phase Behavior of Oil Field Hydrocarbon Systems*, 8th printing, SPE (the Y-function).
- Hoffman, A.E., Crump, J.S. and Hocott, C.R. (1953). "Equilibrium Constants for a Gas-Condensate System." *Trans. AIME* 198.
- Buckley, S.E. (1938). "Calculation of Equilibria in Hydrocarbon Mixtures." *Trans. AIME* 127.
- Whitson, C.H. and Brulé, M.R. (2000). *Phase Behavior*, SPE Monograph 20 (lab-data QC: Y-function, DL material balance, K-value plots).
- McCain, W.D. Jr. (1990). *The Properties of Petroleum Fluids*, 2nd ed., PennWell (the CCE, DL and separator tests, and the DL-to-separator conversion).
- Amyx, J.W., Bass, D.M. and Whiting, R.L. (1960). *Petroleum Reservoir Engineering*, McGraw-Hill (combining differential and flash data).
- Ahmed, T. (2006). *Reservoir Engineering Handbook*, 3rd ed., ch. 2 (the reference oil).

## Functions used

`PO.FL.QC.YFunction`, `PO.FL.QC.MaterialBalance`, `PO.FL.QC.Hoffman`, `PO.FL.QC.Buckley`, `PO.PVT.SG.Oil.FromAPI`

## Spreadsheet: PvtLabQc

|    | A                                                                                                                                                          | B                                                                                                                                                              | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | D                                                                             | E                                                                              | F                                                                                                           | G                                                                                                 | H                                                           | I                                                                                               | J                                                                 | K                                                             | L                                                                | M                                                               |
|----|------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------|--------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------|-------------------------------------------------------------|-------------------------------------------------------------------------------------------------|-------------------------------------------------------------------|---------------------------------------------------------------|------------------------------------------------------------------|-----------------------------------------------------------------|
| 1  | PVT Lab Report QC                                                                                                                                          |                                                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 2  | Blue cells on yellow are the lab's. Paste the report's CCE, DL and separator analysis; each test fits its line and flags the points that fall off it.      |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 3  | The Sample and Its Separator Test (measured)                                                                                                               |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 4  | Stock-tank oil gravity (the residual oil's here too)                                                                                                       | 40.7                                                                                                                                                           | °API                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 5  | Bubble point from the CCE, Pb                                                                                                                              | 2620                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 6  | Separator-test GOR at Pb, Rsfb                                                                                                                             | 768                                                                                                                                                            | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 7  | Separator-test oil FVF at Pb, Bofb                                                                                                                         | 1.474                                                                                                                                                          | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 8  | Separator pressure, absolute (100 psig)                                                                                                                    | 114.7                                                                                                                                                          | psia                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 9  | Separator temperature                                                                                                                                      | 75                                                                                                                                                             | °F                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 10 | Acceptance Limits (this sheet's choices)                                                                                                                   |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 11 | Least R² of the Y-function line                                                                                                                            | 0.99                                                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 12 | Largest departure of a point from the Y line                                                                                                               | 0.05                                                                                                                                                           | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 13 | Largest DL density misfit                                                                                                                                  | 0.005                                                                                                                                                          | g/cm³                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 14 | Largest Hoffman deviation, in log10(K·p)                                                                                                                   | 0.05                                                                                                                                                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 16 | Y-Function of the CCE Below Pb                                                                                                                             |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 17 | CCE points below Pb in the fit                                                                                                                             | =SUMPRODUCT((LQC_CceP<LQC_Pb)*(LQC_CceV>1))                                                                                                                    | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 18 | Intercept of the line Y = a + b·p, a                                                                                                                       | =IFERROR(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"a"),"")                                                                                                  | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 19 | Slope of the line, b                                                                                                                                       | =IFERROR(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"b"),"")                                                                                                  | 1/psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 20 | R² of the line                                                                                                                                             | =IFERROR(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"R2"),"")                                                                                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 21 | Point farthest off the Y line                                                                                                                              | =IFERROR(IF(MAX($F$59:$F$63)>=-MIN($F$59:$F$63),MAX($F$59:$F$63),MIN($F$59:$F$63)),"")                                                                         | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 22 | Y-function check                                                                                                                                           | =IF(LQC_YN<2,"WARN",IF(LQC_YR2<LQC_R2Min,"WARN",IF(ABS(LQC_YWorst)>LQC_YTol,"WARN","PASS")))                                                                   | =IF(LQC_YN<2,"fewer than two CCE points below Pb; the Y-function needs at least two",IF(LQC_YR2<LQC_R2Min,"the Y-function bends (R² "&FIXED(LQC_YR2*100,2)&"%): the bubble point is off, or a volume is misread",IF(ABS(LQC_YWorst)>LQC_YTol,"a CCE point is "&FIXED(ABS(LQC_YWorst)*100,2)&"% off the Y line; check its volume",""&LQC_YN&" points on a straight Y line, R² "&IF(LQC_YR2>1-1/100/100,"over 99.99%",FIXED(LQC_YR2*100,2)&"%")&", none off it by more than "&FIXED(LQC_YTol*100,2)&"%"))) |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 23 | CCE points check                                                                                                                                           | =IF(SUMPRODUCT((LQC_AboveP<=LQC_Pb)*1)+SUMPRODUCT((LQC_AboveV>1)*1)>0,"FAIL",IF(SUMPRODUCT((LQC_CceP>=LQC_Pb)*1)+SUMPRODUCT((LQC_CceV<=1)*1)>0,"FAIL","PASS")) | =IF(SUMPRODUCT((LQC_AboveP<=LQC_Pb)*1)+SUMPRODUCT((LQC_AboveV>1)*1)>0,"a CCE point listed above Pb is at or below it, or has a volume above 1",IF(SUMPRODUCT((LQC_CceP>=LQC_Pb)*1)+SUMPRODUCT((LQC_CceV<=1)*1)>0,"a CCE point listed below Pb is at or above it, or has a volume of 1 or less","the oil shrinks above Pb and swells below it, each point on its side of the bubble point"))                                                                                                              |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 24 | Differential Liberation Material Balance                                                                                                                   |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 25 | Residual oil density at 60 °F, its specific gravity                                                                                                        | =PO.PVT.SG.Oil.FromAPI(LQC_API)                                                                                                                                | g/cm³                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 26 | Largest misfit, material balance less reported                                                                                                             | =IFERROR(IF(MAX($G$69:$G$76)>=-MIN($G$69:$G$76),MAX($G$69:$G$76),MIN($G$69:$G$76)),"")                                                                         | g/cm³                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 27 | At the stage of                                                                                                                                            | =IFERROR(INDEX(LQC_DlP,MATCH(LQC_RhoMax,$G$69:$G$76,0)),"")                                                                                                    | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 28 | DL material balance check                                                                                                                                  | =IF(ABS(LQC_RhoMax)>LQC_RhoTol,"WARN","PASS")                                                                                                                  | =IF(ABS(LQC_RhoMax)>LQC_RhoTol,"the density at "&FIXED(LQC_RhoAt,0)&" psi misses the material balance by "&FIXED(ABS(LQC_RhoMax)*1000,2)&" kg/m³; check that stage's gas volume, gravity and Bod","every stage's density within "&FIXED(LQC_RhoTol*1000,2)&" kg/m³ of the material balance, the largest misfit "&FIXED(ABS(LQC_RhoMax)*1000,2)&" kg/m³ at "&FIXED(LQC_RhoAt,0)&" psi")                                                                                                                   |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 29 | Differential Liberation to the Separator Basis                                                                                                             |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 30 | DL relative oil volume at Pb, Bodb                                                                                                                         | =INDEX(LQC_DlBod,1)                                                                                                                                            | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 31 | DL solution GOR at Pb, Rsdb                                                                                                                                | =INDEX(LQC_DlRsd,1)                                                                                                                                            | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 32 | Shrinkage factor Bofb/Bodb                                                                                                                                 | =LQC_Bofb/LQC_Bodb                                                                                                                                             | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 33 | Rs on the separator basis at the last stage                                                                                                                | =INDEX(LQC_SepRs,ROWS(LQC_SepRs))                                                                                                                              | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 34 | Conversion check                                                                                                                                           | =IF(OR(LQC_Bodb<=LQC_Bofb,LQC_Rsdb<=LQC_Rsfb),"WARN",IF(MIN(LQC_SepRs)<0,"WARN","PASS"))                                                                       | =IF(OR(LQC_Bodb<=LQC_Bofb,LQC_Rsdb<=LQC_Rsfb),"the DL's Bodb or Rsdb is not above the separator test's; check both are at Pb and on their own basis",IF(MIN(LQC_SepRs)<0,"the converted Rs goes below 0 at low pressure, a known limit of the conversion; take it as 0 there","the DL lies above the separator test (Bofb/Bodb "&FIXED(LQC_Bf*100,2)&"%) and the converted Rs ends at "&FIXED(LQC_RsLast,2)&" scf/STB"))                                                                                 |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 35 | Separator K-Values on the Hoffman and Buckley Plots                                                                                                        |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 36 | Hoffman slope of log10(K·p) on F                                                                                                                           | =IFERROR(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Slope"),"")                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 37 | Hoffman intercept                                                                                                                                          | =IFERROR(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Intercept"),"")                                                                        | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 38 | Hoffman R²                                                                                                                                                 | =IFERROR(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"R2"),"")                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 39 | Largest Hoffman deviation, in log10(K·p)                                                                                                                   | =IFERROR(IF(MAX($I$83:$I$88)>=-MIN($I$83:$I$88),MAX($I$83:$I$88),MIN($I$83:$I$88)),"")                                                                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 40 | The component farthest off the line                                                                                                                        | =""&IFERROR(INDEX(LQC_Comp,MATCH(LQC_HofWorst,$I$83:$I$88,0)),"")                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 41 | Buckley slope of log10 K on Tc²                                                                                                                            | =IFERROR(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Slope"),"")                                                                                                            | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 42 | Buckley R²                                                                                                                                                 | =IFERROR(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"R2"),"")                                                                                                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 43 | K-value check                                                                                                                                              | =IF(ABS(LQC_HofWorst)>LQC_DevMax,"WARN","PASS")                                                                                                                | =IF(ABS(LQC_HofWorst)>LQC_DevMax,""&LOWER(LQC_HofComp)&"'s K·p is "&FIXED((10^ABS(LQC_HofWorst)-1)*100,2)&"% off the Hoffman line; check its gas and liquid analyses","every component within "&FIXED(LQC_DevMax,2)&" in log10(K·p) of the Hoffman line (R² "&IF(LQC_HofR2>1-1/100/100,"over 99.99%",FIXED(LQC_HofR2*100,2)&"%")&"), the separator at equilibrium")                                                                                                                                      |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 47 | CCE Above the Bubble Point (EXAMPLE: the complete-PVT workbook's points)                                                                                   |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 48 | Measured above Pb the oil only shrinks: every relative volume at most 1.                                                                                   |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 49 | Pressure (psi)                                                                                                                                             | Relative volume (V/Vsat)                                                                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 50 | 3000                                                                                                                                                       | 0.99432                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 51 | 3500                                                                                                                                                       | 0.98689                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 52 | 4000                                                                                                                                                       | 0.97951                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 53 | 4500                                                                                                                                                       | 0.97219                                                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 55 | CCE Below the Bubble Point and Its Y-Function (EXAMPLE: illustrative)                                                                                      |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 56 | The reference oil has no CCE below Pb: these five volumes are the Y-function LAMBDA's example, off the line Y = 1.6 + 0.0006·p, to four places.            |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 57 | How to use it: paste the report's CCE below Pb over the blue cells, one row a point; insert rows inside the table for more.                                |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 58 | Pressure (psi)                                                                                                                                             | Relative volume (V/Vsat)                                                                                                                                       | Y (—)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Y line (—)                                                                    | Smoothed (V/Vsat)                                                              | Off the line (%)                                                                                            | Flag                                                                                              |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 59 | 2400                                                                                                                                                       | 1.0302                                                                                                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Y"),1),"")                                                                                                                                                                                                                                                                                                                                                                                                                              | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Fit"),1),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Vrel"),1),"") | =IF(AND(ISNUMBER(C59),ISNUMBER(D59)),C59/D59-1,"")                                                          | =IF(ISNUMBER(F59),IF(ABS(F59)>LQC_YTol,"◀ off the line",""),"")                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 60 | 2000                                                                                                                                                       | 1.1107                                                                                                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Y"),2),"")                                                                                                                                                                                                                                                                                                                                                                                                                              | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Fit"),2),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Vrel"),2),"") | =IF(AND(ISNUMBER(C60),ISNUMBER(D60)),C60/D60-1,"")                                                          | =IF(ISNUMBER(F60),IF(ABS(F60)>LQC_YTol,"◀ off the line",""),"")                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 61 | 1600                                                                                                                                                       | 1.249                                                                                                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Y"),3),"")                                                                                                                                                                                                                                                                                                                                                                                                                              | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Fit"),3),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Vrel"),3),"") | =IF(AND(ISNUMBER(C61),ISNUMBER(D61)),C61/D61-1,"")                                                          | =IF(ISNUMBER(F61),IF(ABS(F61)>LQC_YTol,"◀ off the line",""),"")                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 62 | 1200                                                                                                                                                       | 1.5101                                                                                                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Y"),4),"")                                                                                                                                                                                                                                                                                                                                                                                                                              | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Fit"),4),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Vrel"),4),"") | =IF(AND(ISNUMBER(C62),ISNUMBER(D62)),C62/D62-1,"")                                                          | =IF(ISNUMBER(F62),IF(ABS(F62)>LQC_YTol,"◀ off the line",""),"")                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 63 | 800                                                                                                                                                        | 2.0938                                                                                                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Y"),5),"")                                                                                                                                                                                                                                                                                                                                                                                                                              | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Fit"),5),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.YFunction(LQC_CceP,LQC_CceV,LQC_Pb,"Vrel"),5),"") | =IF(AND(ISNUMBER(C63),ISNUMBER(D63)),C63/D63-1,"")                                                          | =IF(ISNUMBER(F63),IF(ABS(F63)>LQC_YTol,"◀ off the line",""),"")                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 65 | Differential Liberation per Barrel of Residual Oil (EXAMPLE: illustrative)                                                                                 |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 66 | Rsd and Bod are the workbook's depletion points taken off the separator basis (Bodb 1.532, Rsdb 798); the gas gravities and densities are illustrative.    |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 67 | How to use it: the report's DL stages from Pb down to the atmospheric one, each with the gravity of the gas released to reach it and the reported density. |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 68 | Pressure (psi)                                                                                                                                             | Rsd (scf/bbl)                                                                                                                                                  | Bod (bbl/bbl)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Gas gravity (air = 1)                                                         | Density (g/cm³)                                                                | Balance (g/cm³)                                                                                             | Misfit (g/cm³)                                                                                    | Flag                                                        | Bo, separator (bbl/STB)                                                                         | Rs, separator (scf/STB)                                           |                                                               |                                                                  |                                                                 |
| 69 | 2620                                                                                                                                                       | 798                                                                                                                                                            | 1.532                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.8                                                                           | 0.6353                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),1),"") | =IF(ISNUMBER(F69),F69-E69,"")                                                                     | =IF(ISNUMBER(G69),IF(ABS(G69)>LQC_RhoTol,"◀ misfit",""),"") | =C69*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B69)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 70 | 2200                                                                                                                                                       | 652                                                                                                                                                            | 1.4565                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 0.8                                                                           | 0.6527                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),2),"") | =IF(ISNUMBER(F70),F70-E70,"")                                                                     | =IF(ISNUMBER(G70),IF(ABS(G70)>LQC_RhoTol,"◀ misfit",""),"") | =C70*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B70)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 71 | 1800                                                                                                                                                       | 518                                                                                                                                                            | 1.3866                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 0.81                                                                          | 0.6703                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),3),"") | =IF(ISNUMBER(F71),F71-E71,"")                                                                     | =IF(ISNUMBER(G71),IF(ABS(G71)>LQC_RhoTol,"◀ misfit",""),"") | =C71*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B71)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 72 | 1400                                                                                                                                                       | 388                                                                                                                                                            | 1.319                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 0.83                                                                          | 0.6844                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),4),"") | =IF(ISNUMBER(F72),F72-E72,"")                                                                     | =IF(ISNUMBER(G72),IF(ABS(G72)>LQC_RhoTol,"◀ misfit",""),"") | =C72*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B72)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 73 | 1000                                                                                                                                                       | 264                                                                                                                                                            | 1.2543                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 0.86                                                                          | 0.6992                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),5),"") | =IF(ISNUMBER(F73),F73-E73,"")                                                                     | =IF(ISNUMBER(G73),IF(ABS(G73)>LQC_RhoTol,"◀ misfit",""),"") | =C73*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B73)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 74 | 600                                                                                                                                                        | 146                                                                                                                                                            | 1.1934                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 0.91                                                                          | 0.7178                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),6),"") | =IF(ISNUMBER(F74),F74-E74,"")                                                                     | =IF(ISNUMBER(G74),IF(ABS(G74)>LQC_RhoTol,"◀ misfit",""),"") | =C74*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B74)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 75 | 200                                                                                                                                                        | 41                                                                                                                                                             | 1.1388                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | 1.02                                                                          | 0.7315                                                                         | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),7),"") | =IF(ISNUMBER(F75),F75-E75,"")                                                                     | =IF(ISNUMBER(G75),IF(ABS(G75)>LQC_RhoTol,"◀ misfit",""),"") | =C75*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B75)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 76 | 14.7                                                                                                                                                       | 0                                                                                                                                                              | 1.06                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | 1.3                                                                           | 0.775                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.MaterialBalance(LQC_DlRsd,LQC_DlBod,LQC_DlGg,LQC_RhoR,LQC_DlRho,"Calc"),8),"") | =IF(ISNUMBER(F76),F76-E76,"")                                                                     | =IF(ISNUMBER(G76),IF(ABS(G76)>LQC_RhoTol,"◀ misfit",""),"") | =C76*LQC_Bf                                                                                     | =LQC_Rsfb-(LQC_Rsdb-B76)*LQC_Bf                                   |                                                               |                                                                  |                                                                 |
| 79 | Separator K-Values, Hoffman and Buckley (EXAMPLE: illustrative)                                                                                            |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 80 | The reference oil has no K-values: these are Wilson's at its separator, 100 psig and 75 °F, the Hoffman LAMBDA's example; Tb, Tc and Pc from GPA tables.   |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 81 | How to use it: K = y/x from the separator gas and liquid analyses, one row a component; leave N2, CO2, H2S and the plus fraction out.                      |                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                               |                                                                                |                                                                                                             |                                                                                                   |                                                             |                                                                                                 |                                                                   |                                                               |                                                                  |                                                                 |
| 82 | Component                                                                                                                                                  | K (—)                                                                                                                                                          | Tb (°R)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Tc (°R)                                                                       | Pc (psia)                                                                      | F (—)                                                                                                       | log10(K·p) (—)                                                                                    | Line (—)                                                    | Deviation (—)                                                                                   | Flag                                                              | Tc² (°R²)                                                     | log10 K (—)                                                      | Buckley dev. (—)                                                |
| 83 | Methane                                                                                                                                                    | 40.76601                                                                                                                                                       | 201                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | 343                                                                           | 666.4                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"F"),1),"")               | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"LogKp"),1),"") | =IF(ISNUMBER(F83),LQC_HofInt+LQC_HofSlope*F83,"")           | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Dev"),1),"") | =IF(ISNUMBER(I83),IF(ABS(I83)>LQC_DevMax,"◀ off the line",""),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"X"),1),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"LogK"),1),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Dev"),1),"") |
| 84 | Ethane                                                                                                                                                     | 5.22284                                                                                                                                                        | 332.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 549.6                                                                         | 706.5                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"F"),2),"")               | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"LogKp"),2),"") | =IF(ISNUMBER(F84),LQC_HofInt+LQC_HofSlope*F84,"")           | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Dev"),2),"") | =IF(ISNUMBER(I84),IF(ABS(I84)>LQC_DevMax,"◀ off the line",""),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"X"),2),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"LogK"),2),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Dev"),2),"") |
| 85 | Propane                                                                                                                                                    | 1.17779                                                                                                                                                        | 415.9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 665.7                                                                         | 616                                                                            | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"F"),3),"")               | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"LogKp"),3),"") | =IF(ISNUMBER(F85),LQC_HofInt+LQC_HofSlope*F85,"")           | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Dev"),3),"") | =IF(ISNUMBER(I85),IF(ABS(I85)>LQC_DevMax,"◀ off the line",""),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"X"),3),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"LogK"),3),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Dev"),3),"") |
| 86 | n-Butane                                                                                                                                                   | 0.29732                                                                                                                                                        | 490.8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 765.3                                                                         | 550.6                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"F"),4),"")               | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"LogKp"),4),"") | =IF(ISNUMBER(F86),LQC_HofInt+LQC_HofSlope*F86,"")           | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Dev"),4),"") | =IF(ISNUMBER(I86),IF(ABS(I86)>LQC_DevMax,"◀ off the line",""),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"X"),4),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"LogK"),4),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Dev"),4),"") |
| 87 | n-Pentane                                                                                                                                                  | 0.08555                                                                                                                                                        | 556.6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 845.4                                                                         | 488.6                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"F"),5),"")               | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"LogKp"),5),"") | =IF(ISNUMBER(F87),LQC_HofInt+LQC_HofSlope*F87,"")           | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Dev"),5),"") | =IF(ISNUMBER(I87),IF(ABS(I87)>LQC_DevMax,"◀ off the line",""),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"X"),5),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"LogK"),5),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Dev"),5),"") |
| 88 | n-Hexane                                                                                                                                                   | 0.02694                                                                                                                                                        | 615.4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 913.3                                                                         | 436.9                                                                          | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"F"),6),"")               | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"LogKp"),6),"") | =IF(ISNUMBER(F88),LQC_HofInt+LQC_HofSlope*F88,"")           | =IFERROR(CHOOSEROWS(PO.FL.QC.Hoffman(LQC_K,LQC_SepP,LQC_SepT,LQC_Tb,LQC_Tc,LQC_Pc,"Dev"),6),"") | =IF(ISNUMBER(I88),IF(ABS(I88)>LQC_DevMax,"◀ off the line",""),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"X"),6),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"LogK"),6),"") | =IFERROR(CHOOSEROWS(PO.FL.QC.Buckley(LQC_K,LQC_Tc,"Dev"),6),"") |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.FL.QC.YFunction | =LAMBDA(p, vrel, pb, output, LET(msk, (p<pb)*(vrel>1), den, p*(vrel-1)*msk+1-msk, y, (pb-p)*msk/den, nn, SUM(msk), idx, (output="Y")*1+(output="Fit")*2+(output="Vrel")*3+(output="a")*4+(output="b")*5+(output="R2")*6, IF(OR(pb<=0, ROWS(p)<>ROWS(vrel), nn<2, idx=0), NA(), LET(xa, SUM(msk*p)/nn, ya, SUM(y)/nn, sxx, SUM(msk*(p-xa)^2), sxy, SUM(msk*(p-xa)*(y-ya)), syy, SUM(msk*(y-ya)^2), sl, sxy/sxx, ic, ya-sl*xa, fit, ic+sl*p, CHOOSE(idx, MAP(msk, y, LAMBDA(mk, yv, IF(mk=1, yv, NA()))), fit, msk*(1+(pb-p)/(p*fit))+(1-msk)*vrel, ic, sl, 1-(syy-sxy^2/sxx)/(syy+(syy=0))))))) | CCE Y-function, Y = (pb − p)/(p·(Vrel − 1)) below pb: output "Y" or "Fit" (columns), "Vrel" (smoothed relative volume, measured at or above pb), "a" and "b" of the line Y = a + b·p, or "R2". p and pb in psia. |
| PO.FL.QC.MaterialBalance | =LAMBDA(rs, bod, gg, rho_r, rho, output, LET(idx, (output="Calc")*1+(output="Diff")*2+(output="Mass")*3, nn, ROWS(rs), IF(OR(idx=0, nn<2, rho_r<=0, MIN(bod)<=0, MIN(gg)<=0, MIN(rs)<0), NA(), LET(ix, SEQUENCE(nn), shf, (TRANSPOSE(ix)=ix-1)*1, rsp, MMULT(shf, rs)+(ix=1)*rs, rel, (rsp-rs)*gg, cum, MMULT((TRANSPOSE(ix)>ix)*1, rel), mass, rho_r*350.51+0.0764*cum, calc, mass/(bod*350.51), CHOOSE(idx, calc, calc-rho, mass))))) | DL material balance: oil density (g/cm³) at each stage from rs (scf/bbl residual), bod, the released gas gravity gg and the residual oil density rho_r; output "Calc", "Diff" (Calc − reported rho) or "Mass" (lb/bbl residual oil). |
| PO.FL.QC.Hoffman | =LAMBDA(k, p, t, tb, tc, pc, output, LET(idx, (output="F")*1+(output="LogKp")*2+(output="Slope")*3+(output="Intercept")*4+(output="R2")*5+(output="Dev")*6, IF(OR(p<=0, t<=-459.67, idx=0, ROWS(k)<2, MIN(k)<=0, MIN(tb)<=0, MIN(tc-tb)<=0, MIN(pc)<=0), NA(), LET(ff, LOG10(pc/14.696)/(1/tb-1/tc)*(1/tb-1/(t+459.67)), yy, LOG10(k*p), nn, ROWS(k), xa, SUM(ff)/nn, ya, SUM(yy)/nn, sxx, SUM((ff-xa)^2), sxy, SUM((ff-xa)*(yy-ya)), syy, SUM((yy-ya)^2), sl, sxy/sxx, ic, ya-sl*xa, CHOOSE(idx, ff, yy, sl, ic, 1-(syy-sxy^2/sxx)/(syy+(syy=0)), yy-ic-sl*ff))))) | Hoffman-Crump-Hocott plot of K-values at p (psia) and t (°F) with each component's Tb, Tc (°R) and pc (psia): output "F", "LogKp", "Dev" (columns), "Slope", "Intercept" or "R2" of log(K·p) against F. |
| PO.FL.QC.Buckley | =LAMBDA(k, tc, output, LET(idx, (output="X")*1+(output="LogK")*2+(output="Slope")*3+(output="Intercept")*4+(output="R2")*5+(output="Dev")*6, IF(OR(idx=0, ROWS(k)<2, MIN(k)<=0, MIN(tc)<=0), NA(), LET(xx, tc^2, yy, LOG10(k), nn, ROWS(k), xa, SUM(xx)/nn, ya, SUM(yy)/nn, sxx, SUM((xx-xa)^2), sxy, SUM((xx-xa)*(yy-ya)), syy, SUM((yy-ya)^2), sl, sxy/sxx, ic, ya-sl*xa, CHOOSE(idx, xx, yy, sl, ic, 1-(syy-sxy^2/sxx)/(syy+(syy=0)), yy-ic-sl*xx))))) | Buckley plot of K-values against critical temperature tc (°R): output "X" (Tc²), "LogK", "Dev" (columns), "Slope", "Intercept" or "R2" of log K against Tc². |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| LQC_API | $B$4 | Stock-tank oil gravity (the residual oil's here too), °API |
| LQC_Pb | $B$5 | Bubble point from the CCE, Pb, psi |
| LQC_Rsfb | $B$6 | Separator-test GOR at Pb, Rsfb, scf/STB |
| LQC_Bofb | $B$7 | Separator-test oil FVF at Pb, Bofb, bbl/STB |
| LQC_SepP | $B$8 | Separator pressure, absolute (100 psig), psia |
| LQC_SepT | $B$9 | Separator temperature, °F |
| LQC_R2Min | $B$11 | Least R² of the Y-function line |
| LQC_YTol | $B$12 | Largest departure of a point from the Y line, % |
| LQC_RhoTol | $B$13 | Largest DL density misfit, g/cm³ |
| LQC_DevMax | $B$14 | Largest Hoffman deviation, in log10(K·p) |
| LQC_Inputs | $B$4:$B$14 | The oil's gravity, the CCE bubble point, the separator test's GOR, FVF, pressure and temperature, and the four acceptance limits |
| LQC_YN | $B$17 | CCE points below Pb in the fit |
| LQC_Ya | $B$18 | Intercept of the line Y = a + b·p, a |
| LQC_Yb | $B$19 | Slope of the line, b, 1/psi |
| LQC_YR2 | $B$20 | R² of the line |
| LQC_YWorst | $B$21 | Point farthest off the Y line, % |
| LQC_YCheck | $B$22 | Y-function check verdict |
| LQC_YCheckNote | $C$22 | Y-function check comment |
| LQC_CceCheck | $B$23 | CCE points check verdict |
| LQC_CceCheckNote | $C$23 | CCE points check comment |
| LQC_RhoR | $B$25 | Residual oil density at 60 °F, its specific gravity, g/cm³ |
| LQC_RhoMax | $B$26 | Largest misfit, material balance less reported, g/cm³ |
| LQC_RhoAt | $B$27 | At the stage of, psi |
| LQC_MbCheck | $B$28 | DL material balance check verdict |
| LQC_MbCheckNote | $C$28 | DL material balance check comment |
| LQC_Bodb | $B$30 | DL relative oil volume at Pb, Bodb, bbl/STB |
| LQC_Rsdb | $B$31 | DL solution GOR at Pb, Rsdb, scf/STB |
| LQC_Bf | $B$32 | Shrinkage factor Bofb/Bodb |
| LQC_RsLast | $B$33 | Rs on the separator basis at the last stage, scf/STB |
| LQC_ConvCheck | $B$34 | Conversion check verdict |
| LQC_ConvCheckNote | $C$34 | Conversion check comment |
| LQC_HofSlope | $B$36 | Hoffman slope of log10(K·p) on F |
| LQC_HofInt | $B$37 | Hoffman intercept |
| LQC_HofR2 | $B$38 | Hoffman R² |
| LQC_HofWorst | $B$39 | Largest Hoffman deviation, in log10(K·p) |
| LQC_HofComp | $B$40 | The component farthest off the line |
| LQC_BucSlope | $B$41 | Buckley slope of log10 K on Tc² |
| LQC_BucR2 | $B$42 | Buckley R² |
| LQC_KCheck | $B$43 | K-value check verdict |
| LQC_KCheckNote | $C$43 | K-value check comment |
| LQC_Results | $B$17:$B$43 | Y-function points, line, R², farthest point off it, Y and CCE checks; residual oil density, the worst DL density misfit, its stage and check; Bodb, Rsdb, shrinkage, the last converted Rs and check; Hoffman and Buckley lines, worst component, K-value check |
| LQC_AboveP | $A$50:$A$53 | CCE pressures above Pb, psi |
| LQC_AboveV | $B$50:$B$53 | CCE relative volumes above Pb, V/Vsat |
| LQC_Curve | $C$59:$G$63 | Each CCE point below Pb: its Y, the fitted line, the smoothed relative volume, how far off the line it is, and its flag |
| LQC_CceP | $A$59:$A$63 | CCE pressures below Pb, psi |
| LQC_CceV | $B$59:$B$63 | CCE relative volumes below Pb, V/Vsat |
| LQC_Dl | $F$69:$J$76 | Each DL stage's density by the material balance, its misfit against the reported one and its flag, and its Bo and Rs on the separator basis |
| LQC_DlP | $A$69:$A$76 | DL stage pressures, psi |
| LQC_DlRsd | $B$69:$B$76 | DL solution GOR per barrel of residual oil, scf/bbl |
| LQC_DlBod | $C$69:$C$76 | DL relative oil volume, bbl per barrel of residual oil |
| LQC_DlGg | $D$69:$D$76 | Gravity of the gas released in reaching each stage, air = 1 |
| LQC_DlRho | $E$69:$E$76 | Reported oil density at each stage, g/cm³ |
| LQC_SepRs | $J$69:$J$76 | Rs on the separator basis at each stage, scf/STB |
| LQC_Kvalues | $F$83:$M$88 | Each component's Hoffman F, log10(K·p), the line, its deviation and flag, and Buckley's Tc², log10 K and deviation |
| LQC_Comp | $A$83:$A$88 | Separator components, methane to n-hexane |
| LQC_K | $B$83:$B$88 | Equilibrium ratio y/x of each component |
| LQC_Tb | $C$83:$C$88 | Normal boiling point of each component, °R |
| LQC_Tc | $D$83:$D$88 | Critical temperature of each component, °R |
| LQC_Pc | $E$83:$E$88 | Critical pressure of each component, psia |

---

## Related Blueprints
- [PVT Sensitivity to Oil Gravity](/blueprint/po.pvt.sensitivity.api.md)
- [Black-Oil Simulator Tables](/blueprint/po.pvt.blackoil.tables.md)
- [PVT Correlation Match Against the Lab](/blueprint/po.pvt.correlation.match.md)
- [Black-Oil PVT Table Above and Below the Bubble Point](/blueprint/po.pvt.oil.fullpvt.md)
- [PVT Fluid Report Through Depletion](/blueprint/po.pvt.fluid.report.md)
- [Bubble Point by Regional Correlation](/blueprint/po.pvt.bubblepoint.regional.md)

