---
cid: po.bp.pvt.correlation.match
hub: pvt
tags: [PVT, black-oil, correlation-matching, AARE, bubble-point, Rs, Bo, viscosity, lab-data, Standing, Al-Marhoun, Glaso, Chew-Connally]
facets: { discipline: reservoir, phase: oil, property: bubble-point, method-type: empirical }
title: PVT Correlation Match Against the Lab
summary: "Scores bubble-point, GOR, Bo and viscosity correlations against lab data by average error and recommends the best for each property."
slug: po.pvt.correlation.match
type: worksheet
---

# PVT Correlation Match Against the Lab

## Description

Which black-oil correlations describe this oil? You enter the oil's measured gravities, temperature, Rsb, Bob and bubble point, the lab's depletion points and its CCE above the bubble point. The sheet scores every bubble-point, solution-GOR, oil-FVF and oil-viscosity correlation against the lab by its average absolute relative error (AARE). You read off each correlation's AARE and rank, and the one recommended for each property: the least AARE, unless you type a number to use another.

**Parameters:**
- **The oil** (measured): separator gas gravity `PCM_SGg`, stock-tank gravity `PCM_API`, reservoir temperature `PCM_T`, Rsb `PCM_Rsb`, Bob `PCM_LabBob` and the bubble point `PCM_LabPb`
- **Correlations used**: `PCM_PbUse` (1 to 7), `PCM_RsUse`, `PCM_BoUse` and `PCM_UoUse` (1 to 6), each 0 for the least AARE; and the largest AARE accepted `PCM_AareMax`
- **Lab points**: the depletion table on the separator basis (`PCM_LabP`, `PCM_LabRs`, `PCM_LabBo`, `PCM_LabUo`, ten rows) and the CCE above Pb (`PCM_CceP`, `PCM_CceV`, six rows)

**How to use it:** Paste the report's depletion steps on the separator basis (convert a DL's Bod and Rsd first; the PVT Lab Report QC sheet does) and its CCE points above Pb over the blue cells, Pb first and down, and leave μo blank where it wasn't measured. Use the separator test's gas gravity and Rsb and the CCE's bubble point. A chart shows every correlation's error, the ones used set apart. The sheet is the Complete PVT Study workbook's Correlation Match sheet on one sheet; the Black-Oil Simulator Tables sheet takes its picks.

**Method:**

- **Correlations**, in the order the numbers pick them: bubble point by Standing, Vasquez-Beggs, Glasø, Al-Marhoun, Petrosky-Farshad, Dokla-Osman and Dindoruk-Christman; Rs by the same less Dokla-Osman; Bo by Standing, Vasquez-Beggs, Glasø, Al-Marhoun, Petrosky and Dindoruk-Christman; and μo by six pairs of a dead-oil correlation (Beal, Egbogah, Glasø) and a live-oil one (Beggs-Robinson, Chew-Connally), Beggs-Robinson's three first.
- **AARE.** 100 × (1/n) Σ |xcorr − xlab| / xlab over the n lab points that have a value; blanks are skipped.
- **Grids.** The bubble point is scored at the lab's Rsb against the measured Pb, one point per correlation. Each Rs correlation is scored at each depletion pressure against the measured Rs. Each Bo correlation and each μo pair is scored at each depletion point's measured Rs against the measured Bo and μo, so neither carries the Rs correlation's error.
- **Pick.** The least AARE of each property, or the correlation typed by number; its name, AARE and, for Pb, the bubble point it gives at Rsb.
- **CCE.** Vasquez-Beggs' undersaturated compressibility Co at Rsb integrated from the lab Pb, as the relative volume Bo/Bob, against each CCE point above Pb.
- **Checks.**
  - Lab match: a FAIL for a correlation number outside its list, a WARN when a correlation used misses the lab by more than the largest AARE accepted.
  - Lab points: every depletion point at or below Pb and every CCE point above it (a FAIL otherwise), and no Rs or Bo above its bubble-point value.

**Example:** The example is the PVT family's reference black oil, Ahmed's oil 2: 40.7 °API, a 0.855 gravity separator gas (100 psig, 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 other six depletion points, the viscosities and the four CCE points are the Complete PVT Study workbook's illustrative example, made around them and not a lab report: Rs on a power law through the bubble point, Rsb (p/Pb)^1.15; Bo linear in Rs from 1.075 at Rs = 0 to Bob; μo with its fluidity linear in Rs from 0.80 cp dead to 0.29 cp at Pb; and the relative volume at a constant 15 × 10⁻⁶ 1/psi.

Al-Marhoun's bubble point is the closest, 2,578 psi against the lab's 2,620 (AARE 1.60 %), ahead of Standing (4.47 %) and Vasquez-Beggs (4.58 %), with Dokla-Osman the farthest (9.93 %). Standing is the best Rs (3.56 %, Petrosky-Farshad the worst at 49.8 %) and the best Bo (0.57 %, Dindoruk-Christman next at 0.63 %). Glasø's dead oil with Chew-Connally is the best viscosity pair (6.87 %), Beal with Beggs-Robinson 20.6 %. Vasquez-Beggs misses the CCE by 0.20 %. Every correlation used is within 10 %. Typing 2,500 psi for the lab bubble point moves the pick to Standing (2,502.9 psi, 0.12 %), and the lab points check fails, since the 2,620 psi depletion point is now above Pb. Typing 1 for Pb and 1 for μo uses Standing (4.47 %) and Beal with Beggs-Robinson (20.6 %), and the match check warns.

## Validity

A correlation study, not an equation-of-state model: the correlations are used as published, and picking the closest is not tuning one; a lab point the best still misses by more than the tolerance (10 % by default) is flagged, not fitted. Each property is picked on its own, so the recommended Rs, Bo and μo can come from different authors. The scores are only as good as the lab points: a DL must be converted to the separator basis before it is scored, and here the points around the measured bubble point are illustrative. AARE weights every point alike; a report with many points near Pb favours the correlation that is right there. Each correlation has its own fitted range of gravity, temperature and GOR, which the Bubble Point by Regional Correlation sheet lists; a correlation outside it can still score well on one oil.

Named alternatives: an EoS characterisation tuned to the lab (the EoS Tuning to PVT Data sheet), a correlation shifted through the lab points (a multiplier on Pb or Rs), and the Bubble Point by Regional Correlation sheet for picking by region and range when there is no lab report.

## References

- Ahmed, T. (2006). *Reservoir Engineering Handbook*, 3rd ed., ch. 2: the six crude-oil systems (oil 2 is this example) and the black-oil correlations.
- Standing, M.B. (1947); Vasquez, M. and Beggs, H.D. (1980), JPT 32(6); Glasø, Ø. (1980), JPT 32(5); Al-Marhoun, M.A. (1988), JPT 40(5); Petrosky, G.E. and Farshad, F.F. (1993), SPE-26644; Dokla, M.E. and Osman, M.E. (1992), SPE Formation Evaluation 7(1); Dindoruk, B. and Christman, P.G. (2004), SPE Reservoir Evaluation & Engineering 7(6): the Pb, Rs and Bo correlations.
- Beal, C. (1946); Egbogah, E.O. (1983); Beggs, H.D. and Robinson, J.R. (1975), JPT 27(9); Chew, J. and Connally, C.A. (1959), Trans. AIME 216: the oil viscosity correlations.
- McCain, W.D. Jr. (1990). *The Properties of Petroleum Fluids*, 2nd ed. PennWell: the differential liberation, CCE and separator tests.
- Al-Shammasi, A.A. (2001). "A Review of Bubblepoint Pressure and Oil Formation Volume Factor Correlations." *SPE Reservoir Evaluation & Engineering* 4(2): correlations ranked by their average absolute relative error.

## Functions used

`PO.PVT.Pb.ByStanding`, `PO.PVT.Pb.ByVasquezBeggs`, `PO.PVT.Pb.ByGlaso`, `PO.PVT.Pb.ByAlMarhoun`, `PO.PVT.Pb.ByPetroskyFarshad`, `PO.PVT.Pb.ByDoklaOsman`, `PO.PVT.Pb.ByDindorukChristman`, `PO.PVT.Rs.ByStanding`, `PO.PVT.Rs.ByVasquezBeggs`, `PO.PVT.Rs.ByGlaso`, `PO.PVT.Rs.ByAlMarhoun`, `PO.PVT.Rs.ByPetroskyFarshad`, `PO.PVT.Rs.ByDindorukChristman`, `PO.PVT.Bo.Sat.ByStanding`, `PO.PVT.Bo.Sat.ByVasquezBeggs`, `PO.PVT.Bo.Sat.ByGlaso`, `PO.PVT.Bo.Sat.ByAlMarhoun`, `PO.PVT.Bo.Sat.ByPetrosky`, `PO.PVT.Bo.Sat.ByDindorukChristman`, `PO.PVT.Uo.Dead.ByBeal`, `PO.PVT.Uo.Dead.ByEgbogah`, `PO.PVT.Uo.Dead.ByGlaso`, `PO.PVT.Uo.Sat.ByBeggsRobinson`, `PO.PVT.Uo.Sat.ByChewConnally`, `PO.PVT.Co.UnSat.ByVasquezBeggs`, `PO.PVT.Bo.UnSat.ByDefinition`, `PO.Stats.AARE`

## Spreadsheet: PvtCorrelationMatch

|     | A                                                                                                                                                                | B                                                                                                                                                                                                                                                                                                                                                                                                                              | C                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | D                                                                                                  | E                                                                                                | F                                                                                                   | G                                                                                                 |
|-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------|
| 1   | PVT Correlation Match Against the Lab                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 2   | Blue cells on yellow are inputs. Type the oil and the lab's points; every Pb, Rs, Bo and μo correlation is scored by its AARE and the least of each recommended. |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 3   | Reference Black Oil (measured)                                                                                                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 4   | Separator gas specific gravity                                                                                                                                   | 0.855                                                                                                                                                                                                                                                                                                                                                                                                                          | air = 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 5   | Stock-tank oil gravity                                                                                                                                           | 40.7                                                                                                                                                                                                                                                                                                                                                                                                                           | °API                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 6   | Reservoir temperature                                                                                                                                            | 220                                                                                                                                                                                                                                                                                                                                                                                                                            | °F                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 7   | Solution GOR at the bubble point, Rsb                                                                                                                            | 768                                                                                                                                                                                                                                                                                                                                                                                                                            | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 8   | Oil FVF at the bubble point, Bob                                                                                                                                 | 1.474                                                                                                                                                                                                                                                                                                                                                                                                                          | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 9   | Bubble point, Pb                                                                                                                                                 | 2620                                                                                                                                                                                                                                                                                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 10  | Correlations Used and the Error Accepted                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 11  | Pb correlation (0 = least AARE, else 1 to 7)                                                                                                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 12  | Rs correlation (0 = least AARE, else 1 to 6)                                                                                                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 13  | Bo correlation (0 = least AARE, else 1 to 6)                                                                                                                     | 0                                                                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 14  | μo correlation pair (0 = least AARE, else 1 to 6)                                                                                                                | 0                                                                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 15  | Largest AARE accepted                                                                                                                                            | 10                                                                                                                                                                                                                                                                                                                                                                                                                             | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 17  | The Recommended Set                                                                                                                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 18  | Bubble point: correlation number used                                                                                                                            | =IF(PCM_PbUse=0,IFERROR(MATCH(MIN(PCM_PbAare),PCM_PbAare,0),1),PCM_PbUse)                                                                                                                                                                                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 19  | Bubble point: correlation used                                                                                                                                   | =""&IFERROR(MID(INDEX(PCM_PbNames,PCM_PbSet),LEN("Pb: ")+1,100),"")                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 20  | Bubble point: its AARE against the lab                                                                                                                           | =IFERROR(INDEX(PCM_PbAare,PCM_PbSet),"")                                                                                                                                                                                                                                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 21  | Bubble point at Rsb by that correlation                                                                                                                          | =IFERROR(CHOOSE(PCM_PbSet,PO.PVT.Pb.ByStanding(PCM_SGg,PCM_API,PCM_Rsb,PCM_T),PO.PVT.Pb.ByVasquezBeggs(PCM_SGg,PCM_API,PCM_Rsb,PCM_T),PO.PVT.Pb.ByGlaso(PCM_SGg,PCM_API,PCM_Rsb,PCM_T),PO.PVT.Pb.ByAlMarhoun(PCM_SGg,PCM_API,PCM_Rsb,PCM_T),PO.PVT.Pb.ByPetroskyFarshad(PCM_SGg,PCM_API,PCM_Rsb,PCM_T),PO.PVT.Pb.ByDoklaOsman(PCM_SGg,PCM_API,PCM_Rsb,PCM_T),PO.PVT.Pb.ByDindorukChristman(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"") | psi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 22  | Solution GOR: correlation number used                                                                                                                            | =IF(PCM_RsUse=0,IFERROR(MATCH(MIN(PCM_RsAare),PCM_RsAare,0),1),PCM_RsUse)                                                                                                                                                                                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 23  | Solution GOR: correlation used                                                                                                                                   | =""&IFERROR(MID(INDEX(PCM_RsNames,PCM_RsSet),LEN("Rs: ")+1,100),"")                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 24  | Solution GOR: its AARE against the lab                                                                                                                           | =IFERROR(INDEX(PCM_RsAare,PCM_RsSet),"")                                                                                                                                                                                                                                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 25  | Oil FVF: correlation number used                                                                                                                                 | =IF(PCM_BoUse=0,IFERROR(MATCH(MIN(PCM_BoAare),PCM_BoAare,0),1),PCM_BoUse)                                                                                                                                                                                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 26  | Oil FVF: correlation used                                                                                                                                        | =""&IFERROR(MID(INDEX(PCM_BoNames,PCM_BoSet),LEN("Bo: ")+1,100),"")                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 27  | Oil FVF: its AARE against the lab                                                                                                                                | =IFERROR(INDEX(PCM_BoAare,PCM_BoSet),"")                                                                                                                                                                                                                                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 28  | Oil viscosity: correlation number used                                                                                                                           | =IF(PCM_UoUse=0,IFERROR(MATCH(MIN(PCM_UoAare),PCM_UoAare,0),1),PCM_UoUse)                                                                                                                                                                                                                                                                                                                                                      | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 29  | Oil viscosity: correlation used                                                                                                                                  | =""&IFERROR(MID(INDEX(PCM_UoNames,PCM_UoSet),LEN("Uo: ")+1,100),"")                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 30  | Oil viscosity: its AARE against the lab                                                                                                                          | =IFERROR(INDEX(PCM_UoAare,PCM_UoSet),"")                                                                                                                                                                                                                                                                                                                                                                                       | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 31  | CCE: Vasquez-Beggs relative volume AARE                                                                                                                          | =IFERROR(PO.Stats.AARE(PCM_CceV,PCM_CceCalc),"")                                                                                                                                                                                                                                                                                                                                                                               | %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 32  | Lab match check                                                                                                                                                  | =IF(OR(PCM_PbUse>ROWS(PCM_PbAare),PCM_PbUse<0,PCM_RsUse>ROWS(PCM_RsAare),PCM_RsUse<0,PCM_BoUse>ROWS(PCM_BoAare),PCM_BoUse<0,PCM_UoUse>ROWS(PCM_UoAare),PCM_UoUse<0),"FAIL",IF(MAX(N(PCM_PbErr),N(PCM_RsErr),N(PCM_BoErr),N(PCM_UoErr))>PCM_AareMax,"WARN","PASS"))                                                                                                                                                             | =IF(OR(PCM_PbUse>ROWS(PCM_PbAare),PCM_PbUse<0,PCM_RsUse>ROWS(PCM_RsAare),PCM_RsUse<0,PCM_BoUse>ROWS(PCM_BoAare),PCM_BoUse<0,PCM_UoUse>ROWS(PCM_UoAare),PCM_UoUse<0),"a correlation number is outside its list; 0 picks the least AARE",IF(MAX(N(PCM_PbErr),N(PCM_RsErr),N(PCM_BoErr),N(PCM_UoErr))>PCM_AareMax,"a correlation used misses the lab by more than "&FIXED(PCM_AareMax,0)&" %; check the lab points, or tune the correlation","every correlation used is within "&FIXED(PCM_AareMax,0)&" % of the lab"))                                                          |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 33  | Lab points check                                                                                                                                                 | =IF(COUNT(PCM_LabP)<2,"FAIL",IF(SUMPRODUCT(ISNUMBER(PCM_LabP)*(PCM_LabP>PCM_LabPb))>0,"FAIL",IF(SUMPRODUCT(ISNUMBER(PCM_CceP)*(PCM_CceP<=PCM_LabPb))>0,"FAIL",IF(SUMPRODUCT(ISNUMBER(PCM_LabRs)*(PCM_LabRs>PCM_Rsb))+SUMPRODUCT(ISNUMBER(PCM_LabBo)*(PCM_LabBo>PCM_LabBob))>0,"WARN","PASS"))))                                                                                                                                | =IF(COUNT(PCM_LabP)<2,"enter at least two depletion points",IF(SUMPRODUCT(ISNUMBER(PCM_LabP)*(PCM_LabP>PCM_LabPb))>0,"a depletion point is above the bubble point; it belongs in the CCE table",IF(SUMPRODUCT(ISNUMBER(PCM_CceP)*(PCM_CceP<=PCM_LabPb))>0,"a CCE point is at or below the bubble point",IF(SUMPRODUCT(ISNUMBER(PCM_LabRs)*(PCM_LabRs>PCM_Rsb))+SUMPRODUCT(ISNUMBER(PCM_LabBo)*(PCM_LabBo>PCM_LabBob))>0,"an Rs above Rsb or a Bo above Bob; check the units and the bubble-point row","every depletion point at or below Pb and every CCE point above it")))) |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 36  | Lab Points: Depletion on the Separator Basis (EXAMPLE)                                                                                                           |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 37  | How to use it: paste the report's steps over the blue cells, Pb first and down, on the separator basis; leave μo blank where unmeasured.                         |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 38  | The first row is measured; the other six are the complete-PVT workbook's illustrative points, made around it, not a lab report.                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 39  | Pressure (psi)                                                                                                                                                   | Rs (scf/STB)                                                                                                                                                                                                                                                                                                                                                                                                                   | Bo (bbl/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | μo (cp)                                                                                            |                                                                                                  |                                                                                                     |                                                                                                   |
| 40  | 2620                                                                                                                                                             | 768                                                                                                                                                                                                                                                                                                                                                                                                                            | 1.474                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 0.29                                                                                               |                                                                                                  |                                                                                                     |                                                                                                   |
| 41  | 2200                                                                                                                                                             | 628                                                                                                                                                                                                                                                                                                                                                                                                                            | 1.4014                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 0.328                                                                                              |                                                                                                  |                                                                                                     |                                                                                                   |
| 42  | 1800                                                                                                                                                             | 499                                                                                                                                                                                                                                                                                                                                                                                                                            | 1.3341                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 0.373                                                                                              |                                                                                                  |                                                                                                     |                                                                                                   |
| 43  | 1400                                                                                                                                                             | 374                                                                                                                                                                                                                                                                                                                                                                                                                            | 1.2691                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 0.431                                                                                              |                                                                                                  |                                                                                                     |                                                                                                   |
| 44  | 1000                                                                                                                                                             | 254                                                                                                                                                                                                                                                                                                                                                                                                                            | 1.2068                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 0.506                                                                                              |                                                                                                  |                                                                                                     |                                                                                                   |
| 45  | 600                                                                                                                                                              | 141                                                                                                                                                                                                                                                                                                                                                                                                                            | 1.1482                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 0.605                                                                                              |                                                                                                  |                                                                                                     |                                                                                                   |
| 46  | 200                                                                                                                                                              | 40                                                                                                                                                                                                                                                                                                                                                                                                                             | 1.0957                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | 0.733                                                                                              |                                                                                                  |                                                                                                     |                                                                                                   |
| 51  | Constant Composition Expansion Above Pb (EXAMPLE: illustrative)                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 52  | Pressure (psi)                                                                                                                                                   | Relative volume (V/Vsat)                                                                                                                                                                                                                                                                                                                                                                                                       | Vasquez-Beggs (V/Vsat)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 53  | 3000                                                                                                                                                             | 0.99432                                                                                                                                                                                                                                                                                                                                                                                                                        | =IF(AND(ISNUMBER(A53),PCM_LabPb>0,PCM_LabBob>0),PO.PVT.Bo.UnSat.ByDefinition(PCM_LabBob,PO.PVT.Co.UnSat.ByVasquezBeggs(PCM_Rsb,PCM_SGg,PCM_API,PCM_T,A53),PCM_LabPb,A53)/PCM_LabBob,"")                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 54  | 3500                                                                                                                                                             | 0.98689                                                                                                                                                                                                                                                                                                                                                                                                                        | =IF(AND(ISNUMBER(A54),PCM_LabPb>0,PCM_LabBob>0),PO.PVT.Bo.UnSat.ByDefinition(PCM_LabBob,PO.PVT.Co.UnSat.ByVasquezBeggs(PCM_Rsb,PCM_SGg,PCM_API,PCM_T,A54),PCM_LabPb,A54)/PCM_LabBob,"")                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 55  | 4000                                                                                                                                                             | 0.97951                                                                                                                                                                                                                                                                                                                                                                                                                        | =IF(AND(ISNUMBER(A55),PCM_LabPb>0,PCM_LabBob>0),PO.PVT.Bo.UnSat.ByDefinition(PCM_LabBob,PO.PVT.Co.UnSat.ByVasquezBeggs(PCM_Rsb,PCM_SGg,PCM_API,PCM_T,A55),PCM_LabPb,A55)/PCM_LabBob,"")                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 56  | 4500                                                                                                                                                             | 0.97219                                                                                                                                                                                                                                                                                                                                                                                                                        | =IF(AND(ISNUMBER(A56),PCM_LabPb>0,PCM_LabBob>0),PO.PVT.Bo.UnSat.ByDefinition(PCM_LabBob,PO.PVT.Co.UnSat.ByVasquezBeggs(PCM_Rsb,PCM_SGg,PCM_API,PCM_T,A56),PCM_LabPb,A56)/PCM_LabBob,"")                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 57  |                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                | =IF(AND(ISNUMBER(A57),PCM_LabPb>0,PCM_LabBob>0),PO.PVT.Bo.UnSat.ByDefinition(PCM_LabBob,PO.PVT.Co.UnSat.ByVasquezBeggs(PCM_Rsb,PCM_SGg,PCM_API,PCM_T,A57),PCM_LabPb,A57)/PCM_LabBob,"")                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 58  |                                                                                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                | =IF(AND(ISNUMBER(A58),PCM_LabPb>0,PCM_LabBob>0),PO.PVT.Bo.UnSat.ByDefinition(PCM_LabBob,PO.PVT.Co.UnSat.ByVasquezBeggs(PCM_Rsb,PCM_SGg,PCM_API,PCM_T,A58),PCM_LabPb,A58)/PCM_LabBob,"")                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 60  | Error by Correlation Against the Lab                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 61  | AARE = 100 × the mean of abs(correlation − lab) / lab over the lab points; rank 1 is the least within the property.                                              |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 62  | Correlation                                                                                                                                                      | AARE (%)                                                                                                                                                                                                                                                                                                                                                                                                                       | Rank                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Used                                                                                               | Used (%)                                                                                         | Others (%)                                                                                          |                                                                                                   |
| 63  | Pb: Standing                                                                                                                                                     | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByStanding(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                      | =IF(ISNUMBER(B63),RANK(B63,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=1,"◀ used","")                                                                       | =IF(D63="",0,N(B63))                                                                             | =IF(D63="",N(B63),0)                                                                                |                                                                                                   |
| 64  | Pb: Vasquez-Beggs                                                                                                                                                | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByVasquezBeggs(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER(B64),RANK(B64,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=2,"◀ used","")                                                                       | =IF(D64="",0,N(B64))                                                                             | =IF(D64="",N(B64),0)                                                                                |                                                                                                   |
| 65  | Pb: Glasø                                                                                                                                                        | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByGlaso(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                         | =IF(ISNUMBER(B65),RANK(B65,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=3,"◀ used","")                                                                       | =IF(D65="",0,N(B65))                                                                             | =IF(D65="",N(B65),0)                                                                                |                                                                                                   |
| 66  | Pb: Al-Marhoun                                                                                                                                                   | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByAlMarhoun(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                     | =IF(ISNUMBER(B66),RANK(B66,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=4,"◀ used","")                                                                       | =IF(D66="",0,N(B66))                                                                             | =IF(D66="",N(B66),0)                                                                                |                                                                                                   |
| 67  | Pb: Petrosky-Farshad                                                                                                                                             | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByPetroskyFarshad(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                               | =IF(ISNUMBER(B67),RANK(B67,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=5,"◀ used","")                                                                       | =IF(D67="",0,N(B67))                                                                             | =IF(D67="",N(B67),0)                                                                                |                                                                                                   |
| 68  | Pb: Dokla-Osman                                                                                                                                                  | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByDoklaOsman(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                    | =IF(ISNUMBER(B68),RANK(B68,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=6,"◀ used","")                                                                       | =IF(D68="",0,N(B68))                                                                             | =IF(D68="",N(B68),0)                                                                                |                                                                                                   |
| 69  | Pb: Dindoruk-Christman                                                                                                                                           | =IFERROR(PO.Stats.AARE(PCM_LabPb,PO.PVT.Pb.ByDindorukChristman(PCM_SGg,PCM_API,PCM_Rsb,PCM_T)),"")                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B69),RANK(B69,$B$63:$B$69,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_PbSet=7,"◀ used","")                                                                       | =IF(D69="",0,N(B69))                                                                             | =IF(D69="",N(B69),0)                                                                                |                                                                                                   |
| 70  | Rs: Standing                                                                                                                                                     | =IFERROR(PO.Stats.AARE(PCM_LabRs,$B$92:$B$101),"")                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B70),RANK(B70,$B$70:$B$75,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_RsSet=1,"◀ used","")                                                                       | =IF(D70="",0,N(B70))                                                                             | =IF(D70="",N(B70),0)                                                                                |                                                                                                   |
| 71  | Rs: Vasquez-Beggs                                                                                                                                                | =IFERROR(PO.Stats.AARE(PCM_LabRs,$C$92:$C$101),"")                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B71),RANK(B71,$B$70:$B$75,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_RsSet=2,"◀ used","")                                                                       | =IF(D71="",0,N(B71))                                                                             | =IF(D71="",N(B71),0)                                                                                |                                                                                                   |
| 72  | Rs: Glasø                                                                                                                                                        | =IFERROR(PO.Stats.AARE(PCM_LabRs,$D$92:$D$101),"")                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B72),RANK(B72,$B$70:$B$75,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_RsSet=3,"◀ used","")                                                                       | =IF(D72="",0,N(B72))                                                                             | =IF(D72="",N(B72),0)                                                                                |                                                                                                   |
| 73  | Rs: Al-Marhoun                                                                                                                                                   | =IFERROR(PO.Stats.AARE(PCM_LabRs,$E$92:$E$101),"")                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B73),RANK(B73,$B$70:$B$75,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_RsSet=4,"◀ used","")                                                                       | =IF(D73="",0,N(B73))                                                                             | =IF(D73="",N(B73),0)                                                                                |                                                                                                   |
| 74  | Rs: Petrosky-Farshad                                                                                                                                             | =IFERROR(PO.Stats.AARE(PCM_LabRs,$F$92:$F$101),"")                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B74),RANK(B74,$B$70:$B$75,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_RsSet=5,"◀ used","")                                                                       | =IF(D74="",0,N(B74))                                                                             | =IF(D74="",N(B74),0)                                                                                |                                                                                                   |
| 75  | Rs: Dindoruk-Christman                                                                                                                                           | =IFERROR(PO.Stats.AARE(PCM_LabRs,$G$92:$G$101),"")                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER(B75),RANK(B75,$B$70:$B$75,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_RsSet=6,"◀ used","")                                                                       | =IF(D75="",0,N(B75))                                                                             | =IF(D75="",N(B75),0)                                                                                |                                                                                                   |
| 76  | Bo: Standing                                                                                                                                                     | =IFERROR(PO.Stats.AARE(PCM_LabBo,$B$105:$B$114),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B76),RANK(B76,$B$76:$B$81,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_BoSet=1,"◀ used","")                                                                       | =IF(D76="",0,N(B76))                                                                             | =IF(D76="",N(B76),0)                                                                                |                                                                                                   |
| 77  | Bo: Vasquez-Beggs                                                                                                                                                | =IFERROR(PO.Stats.AARE(PCM_LabBo,$C$105:$C$114),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B77),RANK(B77,$B$76:$B$81,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_BoSet=2,"◀ used","")                                                                       | =IF(D77="",0,N(B77))                                                                             | =IF(D77="",N(B77),0)                                                                                |                                                                                                   |
| 78  | Bo: Glasø                                                                                                                                                        | =IFERROR(PO.Stats.AARE(PCM_LabBo,$D$105:$D$114),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B78),RANK(B78,$B$76:$B$81,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_BoSet=3,"◀ used","")                                                                       | =IF(D78="",0,N(B78))                                                                             | =IF(D78="",N(B78),0)                                                                                |                                                                                                   |
| 79  | Bo: Al-Marhoun                                                                                                                                                   | =IFERROR(PO.Stats.AARE(PCM_LabBo,$E$105:$E$114),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B79),RANK(B79,$B$76:$B$81,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_BoSet=4,"◀ used","")                                                                       | =IF(D79="",0,N(B79))                                                                             | =IF(D79="",N(B79),0)                                                                                |                                                                                                   |
| 80  | Bo: Petrosky                                                                                                                                                     | =IFERROR(PO.Stats.AARE(PCM_LabBo,$F$105:$F$114),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B80),RANK(B80,$B$76:$B$81,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_BoSet=5,"◀ used","")                                                                       | =IF(D80="",0,N(B80))                                                                             | =IF(D80="",N(B80),0)                                                                                |                                                                                                   |
| 81  | Bo: Dindoruk-Christman                                                                                                                                           | =IFERROR(PO.Stats.AARE(PCM_LabBo,$G$105:$G$114),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B81),RANK(B81,$B$76:$B$81,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_BoSet=6,"◀ used","")                                                                       | =IF(D81="",0,N(B81))                                                                             | =IF(D81="",N(B81),0)                                                                                |                                                                                                   |
| 82  | Uo: Beal + Beggs-Robinson                                                                                                                                        | =IFERROR(PO.Stats.AARE(PCM_LabUo,$B$118:$B$127),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B82),RANK(B82,$B$82:$B$87,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_UoSet=1,"◀ used","")                                                                       | =IF(D82="",0,N(B82))                                                                             | =IF(D82="",N(B82),0)                                                                                |                                                                                                   |
| 83  | Uo: Egbogah + Beggs-Robinson                                                                                                                                     | =IFERROR(PO.Stats.AARE(PCM_LabUo,$C$118:$C$127),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B83),RANK(B83,$B$82:$B$87,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_UoSet=2,"◀ used","")                                                                       | =IF(D83="",0,N(B83))                                                                             | =IF(D83="",N(B83),0)                                                                                |                                                                                                   |
| 84  | Uo: Glasø + Beggs-Robinson                                                                                                                                       | =IFERROR(PO.Stats.AARE(PCM_LabUo,$D$118:$D$127),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B84),RANK(B84,$B$82:$B$87,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_UoSet=3,"◀ used","")                                                                       | =IF(D84="",0,N(B84))                                                                             | =IF(D84="",N(B84),0)                                                                                |                                                                                                   |
| 85  | Uo: Beal + Chew-Connally                                                                                                                                         | =IFERROR(PO.Stats.AARE(PCM_LabUo,$E$118:$E$127),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B85),RANK(B85,$B$82:$B$87,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_UoSet=4,"◀ used","")                                                                       | =IF(D85="",0,N(B85))                                                                             | =IF(D85="",N(B85),0)                                                                                |                                                                                                   |
| 86  | Uo: Egbogah + Chew-Connally                                                                                                                                      | =IFERROR(PO.Stats.AARE(PCM_LabUo,$F$118:$F$127),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B86),RANK(B86,$B$82:$B$87,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_UoSet=5,"◀ used","")                                                                       | =IF(D86="",0,N(B86))                                                                             | =IF(D86="",N(B86),0)                                                                                |                                                                                                   |
| 87  | Uo: Glasø + Chew-Connally                                                                                                                                        | =IFERROR(PO.Stats.AARE(PCM_LabUo,$G$118:$G$127),"")                                                                                                                                                                                                                                                                                                                                                                            | =IF(ISNUMBER(B87),RANK(B87,$B$82:$B$87,1),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(PCM_UoSet=6,"◀ used","")                                                                       | =IF(D87="",0,N(B87))                                                                             | =IF(D87="",N(B87),0)                                                                                |                                                                                                   |
| 90  | Rs by Each Correlation at the Lab Pressures                                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 91  | Lab pressure (psi)                                                                                                                                               | Standing (scf/STB)                                                                                                                                                                                                                                                                                                                                                                                                             | Vasquez-Beggs (scf/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Glasø (scf/STB)                                                                                    | Al-Marhoun (scf/STB)                                                                             | Petrosky-Farshad (scf/STB)                                                                          | Dindoruk-Christman (scf/STB)                                                                      |
| 92  | =IF(ISNUMBER(INDEX(PCM_LabP,1)),INDEX(PCM_LabP,1),"")                                                                                                            | =IF(ISNUMBER($A92),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A92,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A92),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A92,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A92),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A92,PCM_T),"")                               | =IF(ISNUMBER($A92),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A92,PCM_T),"")                         | =IF(ISNUMBER($A92),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A92,PCM_T),"")                      | =IF(ISNUMBER($A92),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A92,PCM_T),"")                  |
| 93  | =IF(ISNUMBER(INDEX(PCM_LabP,2)),INDEX(PCM_LabP,2),"")                                                                                                            | =IF(ISNUMBER($A93),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A93,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A93),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A93,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A93),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A93,PCM_T),"")                               | =IF(ISNUMBER($A93),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A93,PCM_T),"")                         | =IF(ISNUMBER($A93),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A93,PCM_T),"")                      | =IF(ISNUMBER($A93),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A93,PCM_T),"")                  |
| 94  | =IF(ISNUMBER(INDEX(PCM_LabP,3)),INDEX(PCM_LabP,3),"")                                                                                                            | =IF(ISNUMBER($A94),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A94,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A94),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A94,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A94),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A94,PCM_T),"")                               | =IF(ISNUMBER($A94),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A94,PCM_T),"")                         | =IF(ISNUMBER($A94),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A94,PCM_T),"")                      | =IF(ISNUMBER($A94),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A94,PCM_T),"")                  |
| 95  | =IF(ISNUMBER(INDEX(PCM_LabP,4)),INDEX(PCM_LabP,4),"")                                                                                                            | =IF(ISNUMBER($A95),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A95,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A95),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A95,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A95),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A95,PCM_T),"")                               | =IF(ISNUMBER($A95),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A95,PCM_T),"")                         | =IF(ISNUMBER($A95),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A95,PCM_T),"")                      | =IF(ISNUMBER($A95),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A95,PCM_T),"")                  |
| 96  | =IF(ISNUMBER(INDEX(PCM_LabP,5)),INDEX(PCM_LabP,5),"")                                                                                                            | =IF(ISNUMBER($A96),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A96,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A96),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A96,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A96),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A96,PCM_T),"")                               | =IF(ISNUMBER($A96),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A96,PCM_T),"")                         | =IF(ISNUMBER($A96),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A96,PCM_T),"")                      | =IF(ISNUMBER($A96),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A96,PCM_T),"")                  |
| 97  | =IF(ISNUMBER(INDEX(PCM_LabP,6)),INDEX(PCM_LabP,6),"")                                                                                                            | =IF(ISNUMBER($A97),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A97,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A97),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A97,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A97),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A97,PCM_T),"")                               | =IF(ISNUMBER($A97),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A97,PCM_T),"")                         | =IF(ISNUMBER($A97),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A97,PCM_T),"")                      | =IF(ISNUMBER($A97),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A97,PCM_T),"")                  |
| 98  | =IF(ISNUMBER(INDEX(PCM_LabP,7)),INDEX(PCM_LabP,7),"")                                                                                                            | =IF(ISNUMBER($A98),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A98,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A98),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A98,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A98),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A98,PCM_T),"")                               | =IF(ISNUMBER($A98),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A98,PCM_T),"")                         | =IF(ISNUMBER($A98),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A98,PCM_T),"")                      | =IF(ISNUMBER($A98),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A98,PCM_T),"")                  |
| 99  | =IF(ISNUMBER(INDEX(PCM_LabP,8)),INDEX(PCM_LabP,8),"")                                                                                                            | =IF(ISNUMBER($A99),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A99,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                        | =IF(ISNUMBER($A99),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A99,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | =IF(ISNUMBER($A99),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A99,PCM_T),"")                               | =IF(ISNUMBER($A99),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A99,PCM_T),"")                         | =IF(ISNUMBER($A99),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A99,PCM_T),"")                      | =IF(ISNUMBER($A99),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A99,PCM_T),"")                  |
| 100 | =IF(ISNUMBER(INDEX(PCM_LabP,9)),INDEX(PCM_LabP,9),"")                                                                                                            | =IF(ISNUMBER($A100),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A100,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                      | =IF(ISNUMBER($A100),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A100,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(ISNUMBER($A100),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A100,PCM_T),"")                             | =IF(ISNUMBER($A100),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A100,PCM_T),"")                       | =IF(ISNUMBER($A100),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A100,PCM_T),"")                    | =IF(ISNUMBER($A100),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A100,PCM_T),"")                |
| 101 | =IF(ISNUMBER(INDEX(PCM_LabP,10)),INDEX(PCM_LabP,10),"")                                                                                                          | =IF(ISNUMBER($A101),PO.PVT.Rs.ByStanding(PCM_SGg,PCM_API,$A101,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                      | =IF(ISNUMBER($A101),PO.PVT.Rs.ByVasquezBeggs(PCM_SGg,PCM_API,$A101,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | =IF(ISNUMBER($A101),PO.PVT.Rs.ByGlaso(PCM_SGg,PCM_API,$A101,PCM_T),"")                             | =IF(ISNUMBER($A101),PO.PVT.Rs.ByAlMarhoun(PCM_SGg,PCM_API,$A101,PCM_T),"")                       | =IF(ISNUMBER($A101),PO.PVT.Rs.ByPetroskyFarshad(PCM_SGg,PCM_API,$A101,PCM_T),"")                    | =IF(ISNUMBER($A101),PO.PVT.Rs.ByDindorukChristman(PCM_SGg,PCM_API,$A101,PCM_T),"")                |
| 103 | Bo by Each Correlation at the Lab Rs                                                                                                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 104 | Lab Rs (scf/STB)                                                                                                                                                 | Standing (bbl/STB)                                                                                                                                                                                                                                                                                                                                                                                                             | Vasquez-Beggs (bbl/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Glasø (bbl/STB)                                                                                    | Al-Marhoun (bbl/STB)                                                                             | Petrosky (bbl/STB)                                                                                  | Dindoruk-Christman (bbl/STB)                                                                      |
| 105 | =IF(ISNUMBER(INDEX(PCM_LabRs,1)),INDEX(PCM_LabRs,1),"")                                                                                                          | =IF(ISNUMBER($A105),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A105,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A105),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A105,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A105),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A105,PCM_T),"")                         | =IF(ISNUMBER($A105),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A105,PCM_T),"")                   | =IF(ISNUMBER($A105),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A105,PCM_T),"")                       | =IF(ISNUMBER($A105),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A105,PCM_T),"")            |
| 106 | =IF(ISNUMBER(INDEX(PCM_LabRs,2)),INDEX(PCM_LabRs,2),"")                                                                                                          | =IF(ISNUMBER($A106),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A106,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A106),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A106,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A106),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A106,PCM_T),"")                         | =IF(ISNUMBER($A106),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A106,PCM_T),"")                   | =IF(ISNUMBER($A106),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A106,PCM_T),"")                       | =IF(ISNUMBER($A106),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A106,PCM_T),"")            |
| 107 | =IF(ISNUMBER(INDEX(PCM_LabRs,3)),INDEX(PCM_LabRs,3),"")                                                                                                          | =IF(ISNUMBER($A107),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A107,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A107),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A107,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A107),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A107,PCM_T),"")                         | =IF(ISNUMBER($A107),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A107,PCM_T),"")                   | =IF(ISNUMBER($A107),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A107,PCM_T),"")                       | =IF(ISNUMBER($A107),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A107,PCM_T),"")            |
| 108 | =IF(ISNUMBER(INDEX(PCM_LabRs,4)),INDEX(PCM_LabRs,4),"")                                                                                                          | =IF(ISNUMBER($A108),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A108,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A108),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A108,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A108),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A108,PCM_T),"")                         | =IF(ISNUMBER($A108),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A108,PCM_T),"")                   | =IF(ISNUMBER($A108),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A108,PCM_T),"")                       | =IF(ISNUMBER($A108),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A108,PCM_T),"")            |
| 109 | =IF(ISNUMBER(INDEX(PCM_LabRs,5)),INDEX(PCM_LabRs,5),"")                                                                                                          | =IF(ISNUMBER($A109),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A109,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A109),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A109,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A109),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A109,PCM_T),"")                         | =IF(ISNUMBER($A109),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A109,PCM_T),"")                   | =IF(ISNUMBER($A109),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A109,PCM_T),"")                       | =IF(ISNUMBER($A109),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A109,PCM_T),"")            |
| 110 | =IF(ISNUMBER(INDEX(PCM_LabRs,6)),INDEX(PCM_LabRs,6),"")                                                                                                          | =IF(ISNUMBER($A110),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A110,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A110),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A110,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A110),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A110,PCM_T),"")                         | =IF(ISNUMBER($A110),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A110,PCM_T),"")                   | =IF(ISNUMBER($A110),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A110,PCM_T),"")                       | =IF(ISNUMBER($A110),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A110,PCM_T),"")            |
| 111 | =IF(ISNUMBER(INDEX(PCM_LabRs,7)),INDEX(PCM_LabRs,7),"")                                                                                                          | =IF(ISNUMBER($A111),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A111,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A111),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A111,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A111),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A111,PCM_T),"")                         | =IF(ISNUMBER($A111),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A111,PCM_T),"")                   | =IF(ISNUMBER($A111),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A111,PCM_T),"")                       | =IF(ISNUMBER($A111),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A111,PCM_T),"")            |
| 112 | =IF(ISNUMBER(INDEX(PCM_LabRs,8)),INDEX(PCM_LabRs,8),"")                                                                                                          | =IF(ISNUMBER($A112),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A112,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A112),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A112,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A112),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A112,PCM_T),"")                         | =IF(ISNUMBER($A112),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A112,PCM_T),"")                   | =IF(ISNUMBER($A112),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A112,PCM_T),"")                       | =IF(ISNUMBER($A112),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A112,PCM_T),"")            |
| 113 | =IF(ISNUMBER(INDEX(PCM_LabRs,9)),INDEX(PCM_LabRs,9),"")                                                                                                          | =IF(ISNUMBER($A113),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A113,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A113),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A113,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A113),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A113,PCM_T),"")                         | =IF(ISNUMBER($A113),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A113,PCM_T),"")                   | =IF(ISNUMBER($A113),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A113,PCM_T),"")                       | =IF(ISNUMBER($A113),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A113,PCM_T),"")            |
| 114 | =IF(ISNUMBER(INDEX(PCM_LabRs,10)),INDEX(PCM_LabRs,10),"")                                                                                                        | =IF(ISNUMBER($A114),PO.PVT.Bo.Sat.ByStanding(PCM_SGg,PCM_API,$A114,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                  | =IF(ISNUMBER($A114),PO.PVT.Bo.Sat.ByVasquezBeggs(PCM_SGg,PCM_API,$A114,PCM_T),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | =IF(ISNUMBER($A114),PO.PVT.Bo.Sat.ByGlaso(PCM_SGg,PCM_API,$A114,PCM_T),"")                         | =IF(ISNUMBER($A114),PO.PVT.Bo.Sat.ByAlMarhoun(PCM_SGg,PCM_API,$A114,PCM_T),"")                   | =IF(ISNUMBER($A114),PO.PVT.Bo.Sat.ByPetrosky(PCM_SGg,PCM_API,$A114,PCM_T),"")                       | =IF(ISNUMBER($A114),PO.PVT.Bo.Sat.ByDindorukChristman(PCM_SGg,PCM_API,$A114,PCM_T),"")            |
| 116 | μo by Each Correlation Pair at the Lab Rs                                                                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                    |                                                                                                  |                                                                                                     |                                                                                                   |
| 117 | Lab Rs (scf/STB)                                                                                                                                                 | Beal + Beggs-Robinson (cp)                                                                                                                                                                                                                                                                                                                                                                                                     | Egbogah + Beggs-Robinson (cp)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Glasø + Beggs-Robinson (cp)                                                                        | Beal + Chew-Connally (cp)                                                                        | Egbogah + Chew-Connally (cp)                                                                        | Glasø + Chew-Connally (cp)                                                                        |
| 118 | =IF(ISNUMBER(INDEX(PCM_LabRs,1)),INDEX(PCM_LabRs,1),"")                                                                                                          | =IF(ISNUMBER($A118),PO.PVT.Uo.Sat.ByBeggsRobinson($A118,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A118),PO.PVT.Uo.Sat.ByBeggsRobinson($A118,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A118),PO.PVT.Uo.Sat.ByBeggsRobinson($A118,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A118),PO.PVT.Uo.Sat.ByChewConnally($A118,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A118),PO.PVT.Uo.Sat.ByChewConnally($A118,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A118),PO.PVT.Uo.Sat.ByChewConnally($A118,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 119 | =IF(ISNUMBER(INDEX(PCM_LabRs,2)),INDEX(PCM_LabRs,2),"")                                                                                                          | =IF(ISNUMBER($A119),PO.PVT.Uo.Sat.ByBeggsRobinson($A119,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A119),PO.PVT.Uo.Sat.ByBeggsRobinson($A119,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A119),PO.PVT.Uo.Sat.ByBeggsRobinson($A119,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A119),PO.PVT.Uo.Sat.ByChewConnally($A119,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A119),PO.PVT.Uo.Sat.ByChewConnally($A119,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A119),PO.PVT.Uo.Sat.ByChewConnally($A119,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 120 | =IF(ISNUMBER(INDEX(PCM_LabRs,3)),INDEX(PCM_LabRs,3),"")                                                                                                          | =IF(ISNUMBER($A120),PO.PVT.Uo.Sat.ByBeggsRobinson($A120,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A120),PO.PVT.Uo.Sat.ByBeggsRobinson($A120,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A120),PO.PVT.Uo.Sat.ByBeggsRobinson($A120,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A120),PO.PVT.Uo.Sat.ByChewConnally($A120,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A120),PO.PVT.Uo.Sat.ByChewConnally($A120,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A120),PO.PVT.Uo.Sat.ByChewConnally($A120,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 121 | =IF(ISNUMBER(INDEX(PCM_LabRs,4)),INDEX(PCM_LabRs,4),"")                                                                                                          | =IF(ISNUMBER($A121),PO.PVT.Uo.Sat.ByBeggsRobinson($A121,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A121),PO.PVT.Uo.Sat.ByBeggsRobinson($A121,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A121),PO.PVT.Uo.Sat.ByBeggsRobinson($A121,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A121),PO.PVT.Uo.Sat.ByChewConnally($A121,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A121),PO.PVT.Uo.Sat.ByChewConnally($A121,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A121),PO.PVT.Uo.Sat.ByChewConnally($A121,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 122 | =IF(ISNUMBER(INDEX(PCM_LabRs,5)),INDEX(PCM_LabRs,5),"")                                                                                                          | =IF(ISNUMBER($A122),PO.PVT.Uo.Sat.ByBeggsRobinson($A122,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A122),PO.PVT.Uo.Sat.ByBeggsRobinson($A122,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A122),PO.PVT.Uo.Sat.ByBeggsRobinson($A122,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A122),PO.PVT.Uo.Sat.ByChewConnally($A122,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A122),PO.PVT.Uo.Sat.ByChewConnally($A122,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A122),PO.PVT.Uo.Sat.ByChewConnally($A122,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 123 | =IF(ISNUMBER(INDEX(PCM_LabRs,6)),INDEX(PCM_LabRs,6),"")                                                                                                          | =IF(ISNUMBER($A123),PO.PVT.Uo.Sat.ByBeggsRobinson($A123,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A123),PO.PVT.Uo.Sat.ByBeggsRobinson($A123,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A123),PO.PVT.Uo.Sat.ByBeggsRobinson($A123,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A123),PO.PVT.Uo.Sat.ByChewConnally($A123,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A123),PO.PVT.Uo.Sat.ByChewConnally($A123,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A123),PO.PVT.Uo.Sat.ByChewConnally($A123,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 124 | =IF(ISNUMBER(INDEX(PCM_LabRs,7)),INDEX(PCM_LabRs,7),"")                                                                                                          | =IF(ISNUMBER($A124),PO.PVT.Uo.Sat.ByBeggsRobinson($A124,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A124),PO.PVT.Uo.Sat.ByBeggsRobinson($A124,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A124),PO.PVT.Uo.Sat.ByBeggsRobinson($A124,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A124),PO.PVT.Uo.Sat.ByChewConnally($A124,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A124),PO.PVT.Uo.Sat.ByChewConnally($A124,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A124),PO.PVT.Uo.Sat.ByChewConnally($A124,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 125 | =IF(ISNUMBER(INDEX(PCM_LabRs,8)),INDEX(PCM_LabRs,8),"")                                                                                                          | =IF(ISNUMBER($A125),PO.PVT.Uo.Sat.ByBeggsRobinson($A125,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A125),PO.PVT.Uo.Sat.ByBeggsRobinson($A125,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A125),PO.PVT.Uo.Sat.ByBeggsRobinson($A125,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A125),PO.PVT.Uo.Sat.ByChewConnally($A125,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A125),PO.PVT.Uo.Sat.ByChewConnally($A125,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A125),PO.PVT.Uo.Sat.ByChewConnally($A125,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 126 | =IF(ISNUMBER(INDEX(PCM_LabRs,9)),INDEX(PCM_LabRs,9),"")                                                                                                          | =IF(ISNUMBER($A126),PO.PVT.Uo.Sat.ByBeggsRobinson($A126,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A126),PO.PVT.Uo.Sat.ByBeggsRobinson($A126,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A126),PO.PVT.Uo.Sat.ByBeggsRobinson($A126,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A126),PO.PVT.Uo.Sat.ByChewConnally($A126,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A126),PO.PVT.Uo.Sat.ByChewConnally($A126,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A126),PO.PVT.Uo.Sat.ByChewConnally($A126,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |
| 127 | =IF(ISNUMBER(INDEX(PCM_LabRs,10)),INDEX(PCM_LabRs,10),"")                                                                                                        | =IF(ISNUMBER($A127),PO.PVT.Uo.Sat.ByBeggsRobinson($A127,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                              | =IF(ISNUMBER($A127),PO.PVT.Uo.Sat.ByBeggsRobinson($A127,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"")                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | =IF(ISNUMBER($A127),PO.PVT.Uo.Sat.ByBeggsRobinson($A127,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A127),PO.PVT.Uo.Sat.ByChewConnally($A127,PO.PVT.Uo.Dead.ByBeal(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A127),PO.PVT.Uo.Sat.ByChewConnally($A127,PO.PVT.Uo.Dead.ByEgbogah(PCM_API,PCM_T)),"") | =IF(ISNUMBER($A127),PO.PVT.Uo.Sat.ByChewConnally($A127,PO.PVT.Uo.Dead.ByGlaso(PCM_API,PCM_T)),"") |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.Stats.AARE | =LAMBDA(observed, computed, LET(use, ISNUMBER(observed) * ISNUMBER(computed) * (IFERROR(observed, 0) <> 0), k, SUM(use), IF(k = 0, NA(), 100 * SUM(use * IFERROR(ABS((computed - observed) / observed), 0)) / k))) | Average absolute relative error, in percent, of computed values against observed ones: 100 x mean of abs(computed - observed) / abs(observed) over the pairs where both are numbers and observed is not 0. |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| PCM_SGg | $B$4 | Separator gas specific gravity, air = 1 |
| PCM_API | $B$5 | Stock-tank oil gravity, °API |
| PCM_T | $B$6 | Reservoir temperature, °F |
| PCM_Rsb | $B$7 | Solution GOR at the bubble point, Rsb, scf/STB |
| PCM_LabBob | $B$8 | Oil FVF at the bubble point, Bob, bbl/STB |
| PCM_LabPb | $B$9 | Bubble point, Pb, psi |
| PCM_PbUse | $B$11 | Pb correlation (0 = least AARE, else 1 to 7) |
| PCM_RsUse | $B$12 | Rs correlation (0 = least AARE, else 1 to 6) |
| PCM_BoUse | $B$13 | Bo correlation (0 = least AARE, else 1 to 6) |
| PCM_UoUse | $B$14 | μo correlation pair (0 = least AARE, else 1 to 6) |
| PCM_AareMax | $B$15 | Largest AARE accepted, % |
| PCM_Inputs | $B$4:$B$15 | The oil's gas and stock-tank gravities, temperature, Rsb, Bob and bubble point, the correlation used for Pb, Rs, Bo and μo (0 for the least AARE), and the largest AARE accepted |
| PCM_LabP | $A$40:$A$49 | Lab depletion pressures, psi |
| PCM_LabRs | $B$40:$B$49 | Lab Rs, scf/STB |
| PCM_LabBo | $C$40:$C$49 | Lab Bo, bbl/STB |
| PCM_LabUo | $D$40:$D$49 | Lab μo, cp |
| PCM_CceP | $A$53:$A$58 | CCE pressures, psi |
| PCM_CceV | $B$53:$B$58 | CCE relative volume, V/Vsat |
| PCM_CceCalc | $C$53:$C$58 | Vasquez-Beggs relative volume, V/Vsat |
| PCM_PbSet | $B$18 | Bubble point: correlation number used |
| PCM_PbName | $B$19 | Bubble point: correlation used |
| PCM_PbErr | $B$20 | Bubble point: its AARE against the lab, % |
| PCM_PbCalc | $B$21 | Bubble point at Rsb by that correlation, psi |
| PCM_RsSet | $B$22 | Solution GOR: correlation number used |
| PCM_RsName | $B$23 | Solution GOR: correlation used |
| PCM_RsErr | $B$24 | Solution GOR: its AARE against the lab, % |
| PCM_BoSet | $B$25 | Oil FVF: correlation number used |
| PCM_BoName | $B$26 | Oil FVF: correlation used |
| PCM_BoErr | $B$27 | Oil FVF: its AARE against the lab, % |
| PCM_UoSet | $B$28 | Oil viscosity: correlation number used |
| PCM_UoName | $B$29 | Oil viscosity: correlation used |
| PCM_UoErr | $B$30 | Oil viscosity: its AARE against the lab, % |
| PCM_CceErr | $B$31 | CCE: Vasquez-Beggs relative volume AARE, % |
| PCM_MatchCheck | $B$32 | Lab match check verdict |
| PCM_MatchCheckNote | $C$32 | Lab match check comment |
| PCM_LabCheck | $B$33 | Lab points check verdict |
| PCM_LabCheckNote | $C$33 | Lab points check comment |
| PCM_Results | $B$18:$B$33 | For Pb, Rs, Bo and μo: the correlation number used, its name and its AARE, and the bubble point it gives at Rsb; the Vasquez-Beggs CCE error; the lab match and lab points checks |
| PCM_Curve | $A$63:$F$87 | Each correlation's AARE against the lab, its rank within the property, and whether it is used, split for the chart |
| PCM_PbAare | $B$63:$B$69 | Pb correlations' AARE, % |
| PCM_PbNames | $A$63:$A$69 | Pb correlations, in table order |
| PCM_RsAare | $B$70:$B$75 | Rs correlations' AARE, % |
| PCM_RsNames | $A$70:$A$75 | Rs correlations, in table order |
| PCM_BoAare | $B$76:$B$81 | Bo correlations' AARE, % |
| PCM_BoNames | $A$76:$A$81 | Bo correlations, in table order |
| PCM_UoAare | $B$82:$B$87 | Uo correlations' AARE, % |
| PCM_UoNames | $A$82:$A$87 | Uo correlations, in table order |

---

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

