---
cid: po.bp.pvt.blackoil.tables
hub: pvt
tags: [PVT, black-oil, simulator-tables, PVTO, PVDG, PVTW, Eclipse, OPM, Rs, Bo, viscosity, Vasquez-Beggs, McCain]
facets: { discipline: reservoir, phase: oil, property: fvf, method-type: empirical }
title: Black-Oil Simulator Tables
summary: "Generates PVTO, PVDG and PVTW tables from oil correlations on a chosen pressure grid, ready to paste into an Eclipse or OPM Flow deck."
slug: po.pvt.blackoil.tables
type: worksheet
---

# Black-Oil Simulator Tables

## Description

What PVTO, PVDG and PVTW tables does a simulator deck need for this oil? You enter the separator gas and stock-tank gravities, the temperature, Rsb and the lab bubble point, pick the Rs, Bo and oil-viscosity correlations by number, and set the pressure grid and the water's salinity. You read off ten saturated PVTO records up to the bubble point, each with an undersaturated branch, PVDG on twelve pressures and PVTW at a reference pressure, each as a keyword column to paste into an Eclipse or OPM Flow deck's PROPS section.

**Parameters:**
- **The oil**: separator gas gravity `BOT_SGg`, stock-tank gravity `BOT_API`, reservoir temperature `BOT_T`, Rsb `BOT_Rsb` and the bubble point `BOT_Pb` (the lab's)
- **Correlations**: `BOT_RsCorr` and `BOT_BoCorr` (1 Standing, 2 Vasquez-Beggs, 3 Glasø, 4 Al-Marhoun, 5 Petrosky-Farshad or Petrosky, 6 Dindoruk-Christman) and the μo pair `BOT_UoCorr` (1 Beal, 2 Egbogah or 3 Glasø dead oil with Beggs-Robinson; 4 to 6 the same with Chew-Connally)
- **Grid and water**: the lowest pressure `BOT_Pmin` (the first record) and the highest `BOT_Pmax` (the end of every branch), the PVTW reference pressure `BOT_Pref`, and the water's NaCl salinity `BOT_Sal` and brine density `BOT_BrineDen`

**How to use it:** Type the oil from the separator test and the CCE's bubble point, the correlations the PVT Correlation Match Against the Lab sheet picks against the report, the deck's pressure range and the initial reservoir pressure for PVTW. Copy a keyword column from its keyword line to its closing slash. To use the lab's own table instead, paste its Rs, Bo and μo over the record columns. A check confirms that the records' Rs and bubble point rise down the table, Bo with them, and that every branch's Bo falls with pressure; a chart draws the saturated Bo and Rs against pressure. The sheet is the Complete PVT Study workbook's Simulator Tables sheet on one sheet, with the correlations typed by number rather than picked against the lab.

**Method:**

- **Records.** Ten pressures from the lowest pressure to Pb in equal steps; at each, Rs by the chosen correlation, held at most Rsb (the bubble-point record takes Rsb itself), and the saturated Bo and μo by the chosen correlations at that Rs.
- **Branches.** Each record's branch runs halfway from its bubble point to the highest pressure, then to it. Along it Bo = Bob·exp(−Co·(p − Pb)), the undersaturated Bo by definition, with Vasquez-Beggs' Co at the record's Rs, and μo by Vasquez-Beggs' undersaturated viscosity from the record's own.
- **PVTO.** The PVTO table function lays the records and their branches out as the keyword wants them: each record's Rs (in Mscf/STB), bubble point, Bo and μo, then its branch lines with the Rs field empty, a slash closing each record. One INDEX a cell, and the keyword column joins each line's fields.
- **PVDG.** Sutton's pseudo-criticals of the separator gas, DAK's Z, Bg by definition in rb/Mscf, and Lee-Gonzalez-Eakin's μg, on twelve pressures from the lowest pressure to the highest.
- **PVTW.** McCain's Bw and μw (through μw at 1 atm) and Osif's Cw at the reference pressure; the viscosibility (dμw/dp)/μw is a central difference of McCain's μw over ±100 psi.
- **Checks.** Grid: a FAIL for a correlation number outside 1 to 6, a lowest pressure not below Pb or a highest not above it. PVTO: the records' Rs and bubble point rise, the saturated Bo rises with them, and every branch's Bo falls as the pressure rises.

**Example:** The defaults are 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 and a measured bubble point of 2,620 psi, with the correlation-match sheet's recommended set (Standing's Rs and Bo, Glasø's dead oil with Chew-Connally), on the Complete PVT Study workbook's grid: 200 to 5,000 psi, PVTW at 4,000 psi, 3 wt % brine of 1.02 g/cm³.

The saturated Bob by Standing is 1.49836 bbl/STB and μob 0.3111 cp (Glasø's dead oil 0.7750 cp). PVTO runs from 0.04175 Mscf/STB at 200.0 psi (Bo 1.09994, μo 0.7331 cp) to 0.76800 at 2,620.0 psi (1.49836, 0.3111), the last branch at 3,810.0 psi (1.47194, 0.3518) and 5,000.0 psi (1.45828, 0.4049); line for line the workbook's PVTO. PVDG runs from Bg 16.72934 rb/Mscf and μg 0.01287 cp at 200.0 psi to 0.68132 and 0.03287 at 5,000.0 psi. PVTW at 4,000 psi reads Bw 1.03829 rb/STB, Cw 3.032 × 10⁻⁶ 1/psi, μw 0.3673 cp and Cv 5.383 × 10⁻⁵ 1/psi. Typing 2 for Bo uses Vasquez-Beggs, with Bob 1.45026.

## Validity

A correlation-based table, as good as the correlations' match to the oil: pick them against the lab first (the PVT Correlation Match Against the Lab sheet). Each property's correlation is used on its own, so Rs can step at the bubble-point record where the Rs correlation and the lab Pb disagree; the table stays monotonic, which the PVTO check confirms. Vasquez-Beggs' undersaturated viscosity rises steeply from a low bubble point, so the branches of the lowest records are long and steep; Eclipse interpolates between records and extrapolates a record without a branch from its neighbours'. The gas is dry: the separator gas gravity stands for the liberated gas, and there is no vaporised oil. The sheet writes no PVTG, because the add-in has no function for the vaporised-oil ratio Rv. The water is NaCl brine. Field units throughout, as the deck's FIELD keyword reads them.

Named alternatives: an EoS characterisation exported as black-oil tables, the lab's own tables converted to the separator basis (the PVT Lab Report QC sheet), and PVTG with Rv for a wet gas or volatile oil.

## References

- Schlumberger, *ECLIPSE Reference Manual*: the PVTO, PVDG and PVTW keywords and their FIELD units.
- OPM, *Flow Reference Manual*: the same keywords in OPM Flow.
- Ahmed, T. (2006). *Reservoir Engineering Handbook*, 3rd ed., ch. 2: the reference oil and the black-oil correlations.
- Vasquez, M. and Beggs, H.D. (1980). "Correlations for Fluid Physical Property Prediction." *JPT* 32(6): the undersaturated compressibility and viscosity.
- Standing, M.B. (1947); Glasø, Ø. (1980), JPT 32(5); Chew, J. and Connally, C.A. (1959), Trans. AIME 216: the saturated correlations of the default set.
- McCain, W.D. Jr. (1990). *The Properties of Petroleum Fluids*, 2nd ed. PennWell: the water correlations; Osif, T.L. (1988), SPE Reservoir Engineering 3(1): water compressibility.
- Sutton, R.P. (1985), SPE-14265; Dranchuk, P.M. and Abou-Kassem, J.H. (1975), JCPT 14(3); Lee, A.L., Gonzalez, M.H. and Eakin, B.E. (1966), JPT 18(8): the gas.

## Functions used

`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.PVT.Uo.UnSat.ByVasquezBeggs`, `PO.PVT.Table.PVTO`, `PO.PVT.Ppc.BySutton`, `PO.PVT.Tpc.BySutton`, `PO.PVT.Z.ByDAK`, `PO.PVT.Bg.ByDefinition`, `PO.PVT.Ug.ByLGE`, `PO.PVT.Salinity.Gl.FromPct`, `PO.PVT.Uw.1Atm.ByMcCain`, `PO.PVT.Bw.ByMcCain`, `PO.PVT.Cw.UnSat.ByOsif`, `PO.PVT.Uw.ByMcCain`

## Spreadsheet: PvtBlackoilTables

|     | A                                                                                                                                                   | B                                                                                                                                                                                                                                                                                                                                                                              | C                                                                                                                                                                                                                                                                                                                                                                                                                                              | D                                                                                                                                                                                                                                                                                  | E                                                                                                                                | F                                                                                                                                                                                                                                                                                                            | G                                                                                                        | H                                                                                                        | I                                            | J                                            |
|-----|-----------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------|----------------------------------------------|----------------------------------------------|
| 1   | Black-Oil Simulator Tables                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                | Petroleum Office                                                                                                                                                                                                                                                                                                                                                                                                                               |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 2   | Blue cells on yellow are inputs. Type the oil, the correlations and the pressure grid; copy a keyword column from its keyword to its closing slash. |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 3   | Reference Black Oil                                                                                                                                 |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 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   | Bubble point, Pb (the lab's)                                                                                                                        | 2620                                                                                                                                                                                                                                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 9   | Correlations (the Correlation Match Sheet's Picks)                                                                                                  |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 10  | Rs correlation, 1 to 6 (1 = Standing)                                                                                                               | 1                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 11  | Bo correlation, 1 to 6 (1 = Standing)                                                                                                               | 1                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 12  | μo pair, 1 to 6 (6 = Glasø + Chew-Connally)                                                                                                         | 6                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 13  | Pressure Grid and the Water                                                                                                                         |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 14  | Lowest pressure, the first PVTO record                                                                                                              | 200                                                                                                                                                                                                                                                                                                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 15  | Highest pressure, the end of every branch                                                                                                           | 5000                                                                                                                                                                                                                                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 16  | PVTW reference pressure (the initial pressure)                                                                                                      | 4000                                                                                                                                                                                                                                                                                                                                                                           | psi                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 17  | Formation water salinity, NaCl by weight                                                                                                            | 3                                                                                                                                                                                                                                                                                                                                                                              | wt %                                                                                                                                                                                                                                                                                                                                                                                                                                           |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 18  | Brine density at standard conditions                                                                                                                | 1.02                                                                                                                                                                                                                                                                                                                                                                           | g/cm³                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 20  | At the Bubble Point, of the Gas and at the Reference Pressure                                                                                       |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 21  | Oil FVF at the bubble point, Bob                                                                                                                    | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,BOT_Rsb,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,BOT_Rsb,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,BOT_Rsb,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,BOT_Rsb,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,BOT_Rsb,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,BOT_Rsb,BOT_T)) | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 22  | Dead oil viscosity at T                                                                                                                             | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Dead.ByBeal(BOT_API,BOT_T),PO.PVT.Uo.Dead.ByEgbogah(BOT_API,BOT_T),PO.PVT.Uo.Dead.ByGlaso(BOT_API,BOT_T),PO.PVT.Uo.Dead.ByBeal(BOT_API,BOT_T),PO.PVT.Uo.Dead.ByEgbogah(BOT_API,BOT_T),PO.PVT.Uo.Dead.ByGlaso(BOT_API,BOT_T))                                                                                                                      | cp                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 23  | Oil viscosity at the bubble point, μob                                                                                                              | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(BOT_Rsb,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(BOT_Rsb,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(BOT_Rsb,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(BOT_Rsb,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(BOT_Rsb,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(BOT_Rsb,BOT_Uod))                                                                     | cp                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 24  | Temperature, absolute                                                                                                                               | =BOT_T+BOT_R0                                                                                                                                                                                                                                                                                                                                                                  | °R                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 25  | Gas pseudo-critical pressure (Sutton)                                                                                                               | =PO.PVT.Ppc.BySutton(BOT_SGg)                                                                                                                                                                                                                                                                                                                                                  | psi                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 26  | Gas pseudo-critical temperature (Sutton)                                                                                                            | =PO.PVT.Tpc.BySutton(BOT_SGg)                                                                                                                                                                                                                                                                                                                                                  | °R                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 27  | Salinity, NaCl per litre                                                                                                                            | =PO.PVT.Salinity.Gl.FromPct(BOT_Sal,BOT_BrineDen)                                                                                                                                                                                                                                                                                                                              | g/L                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 28  | Water viscosity at 1 atm and T (McCain)                                                                                                             | =PO.PVT.Uw.1Atm.ByMcCain(BOT_T,BOT_Sal)                                                                                                                                                                                                                                                                                                                                        | cp                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 29  | Water FVF at Pref, Bw (McCain)                                                                                                                      | =PO.PVT.Bw.ByMcCain(BOT_Pref,BOT_T)                                                                                                                                                                                                                                                                                                                                            | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 30  | Water compressibility at Pref, Cw (Osif)                                                                                                            | =PO.PVT.Cw.UnSat.ByOsif(BOT_Pref,BOT_T,BOT_SalGL)                                                                                                                                                                                                                                                                                                                              | 1/psi                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 31  | Water viscosity at Pref, μw (McCain)                                                                                                                | =PO.PVT.Uw.ByMcCain(BOT_Pref,BOT_Uw1)                                                                                                                                                                                                                                                                                                                                          | cp                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 32  | Water viscosibility at Pref, (dμw/dp)/μw                                                                                                            | =(PO.PVT.Uw.ByMcCain(BOT_Pref+BOT_dPv,BOT_Uw1)-PO.PVT.Uw.ByMcCain(BOT_Pref-BOT_dPv,BOT_Uw1))/(2*BOT_dPv*BOT_UwRef)                                                                                                                                                                                                                                                             | 1/psi                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 33  | Rs of the first PVTO record                                                                                                                         | =INDEX(BOT_SatRs,1)                                                                                                                                                                                                                                                                                                                                                            | scf/STB                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 34  | Bo at the highest pressure, bubble-point record                                                                                                     | =INDEX(BOT_BrBo,ROWS(BOT_BrBo),COLUMNS(BOT_BrBo))                                                                                                                                                                                                                                                                                                                              | bbl/STB                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 35  | Grid check                                                                                                                                          | =IF(OR(BOT_RsCorr<1,BOT_RsCorr>BOT_Corrs,BOT_BoCorr<1,BOT_BoCorr>BOT_Corrs,BOT_UoCorr<1,BOT_UoCorr>BOT_Corrs),"FAIL",IF(BOT_Pmin>=BOT_Pb,"FAIL",IF(BOT_Pmax<=BOT_Pb,"FAIL","PASS")))                                                                                                                                                                                           | =IF(OR(BOT_RsCorr<1,BOT_RsCorr>BOT_Corrs,BOT_BoCorr<1,BOT_BoCorr>BOT_Corrs,BOT_UoCorr<1,BOT_UoCorr>BOT_Corrs),"a correlation number is outside 1 to 6",IF(BOT_Pmin>=BOT_Pb,"the lowest pressure must be below the bubble point",IF(BOT_Pmax<=BOT_Pb,"the highest pressure must be above the bubble point","ten records from the lowest pressure to the bubble point, every branch to the highest")))                                           |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 36  | PVTO check                                                                                                                                          | =IF(OR(SUMPRODUCT((A49:A57<=A48:A56)*1)>0,SUMPRODUCT((B49:B57<=B48:B56)*1)>0),"FAIL",IF(SUMPRODUCT((C49:C57<=C48:C56)*1)>0,"FAIL",IF(SUMPRODUCT((G48:G57>=C48:C57)*1)+SUMPRODUCT((H48:H57>=G48:G57)*1)>0,"FAIL","PASS")))                                                                                                                                                      | =IF(OR(SUMPRODUCT((A49:A57<=A48:A56)*1)>0,SUMPRODUCT((B49:B57<=B48:B56)*1)>0),"the records' Rs and bubble point must both rise down the table",IF(SUMPRODUCT((C49:C57<=C48:C56)*1)>0,"the saturated Bo must rise with Rs",IF(SUMPRODUCT((G48:G57>=C48:C57)*1)+SUMPRODUCT((H48:H57>=G48:G57)*1)>0,"a branch's Bo must fall as the pressure rises","Rs and Pb rise record by record, Bo with them, and every branch's Bo falls with pressure"))) |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 39  | Calculation Constants                                                                                                                               |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 40  | Rankine at 0 °F                                                                                                                                     | 459.67                                                                                                                                                                                                                                                                                                                                                                         | °R                                                                                                                                                                                                                                                                                                                                                                                                                                             |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 41  | Cubic feet in a barrel                                                                                                                              | 5.614583                                                                                                                                                                                                                                                                                                                                                                       | ft³/bbl                                                                                                                                                                                                                                                                                                                                                                                                                                        |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 42  | scf in an Mscf                                                                                                                                      | 1000                                                                                                                                                                                                                                                                                                                                                                           | scf/Mscf                                                                                                                                                                                                                                                                                                                                                                                                                                       |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 43  | Pressure step for the water's viscosibility                                                                                                         | 100                                                                                                                                                                                                                                                                                                                                                                            | psi                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 44  | Correlations listed for each of Rs, Bo and μo                                                                                                       | 6                                                                                                                                                                                                                                                                                                                                                                              | —                                                                                                                                                                                                                                                                                                                                                                                                                                              |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 45  | PVTO Records and Their Undersaturated Branches                                                                                                      |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 46  | Ten saturated pressures from the lowest to Pb, each a record; its branch runs halfway to the highest pressure, then to it, by Vasquez-Beggs.        |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 47  | Bubble point (psi)                                                                                                                                  | Rs (scf/STB)                                                                                                                                                                                                                                                                                                                                                                   | Bo (bbl/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                   | μo (cp)                                                                                                                                                                                                                                                                            | Branch P1 (psi)                                                                                                                  | Branch P2 (psi)                                                                                                                                                                                                                                                                                              | Bo at P1 (bbl/STB)                                                                                       | Bo at P2 (bbl/STB)                                                                                       | μo at P1 (cp)                                | μo at P2 (cp)                                |
| 48  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*0/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A48,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A48,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A48,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A48,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A48,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A48,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B48,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B48,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B48,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B48,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B48,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B48,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B48,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B48,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B48,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B48,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B48,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B48,BOT_Uod)) | =A48+(BOT_Pmax-A48)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C48,PO.PVT.Co.UnSat.ByVasquezBeggs(B48,BOT_SGg,BOT_API,BOT_T,E48),A48,E48) | =PO.PVT.Bo.UnSat.ByDefinition(C48,PO.PVT.Co.UnSat.ByVasquezBeggs(B48,BOT_SGg,BOT_API,BOT_T,F48),A48,F48) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E48,A48,D48) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F48,A48,D48) |
| 49  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*1/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A49,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A49,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A49,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A49,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A49,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A49,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B49,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B49,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B49,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B49,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B49,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B49,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B49,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B49,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B49,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B49,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B49,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B49,BOT_Uod)) | =A49+(BOT_Pmax-A49)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C49,PO.PVT.Co.UnSat.ByVasquezBeggs(B49,BOT_SGg,BOT_API,BOT_T,E49),A49,E49) | =PO.PVT.Bo.UnSat.ByDefinition(C49,PO.PVT.Co.UnSat.ByVasquezBeggs(B49,BOT_SGg,BOT_API,BOT_T,F49),A49,F49) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E49,A49,D49) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F49,A49,D49) |
| 50  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*2/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A50,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A50,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A50,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A50,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A50,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A50,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B50,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B50,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B50,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B50,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B50,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B50,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B50,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B50,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B50,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B50,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B50,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B50,BOT_Uod)) | =A50+(BOT_Pmax-A50)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C50,PO.PVT.Co.UnSat.ByVasquezBeggs(B50,BOT_SGg,BOT_API,BOT_T,E50),A50,E50) | =PO.PVT.Bo.UnSat.ByDefinition(C50,PO.PVT.Co.UnSat.ByVasquezBeggs(B50,BOT_SGg,BOT_API,BOT_T,F50),A50,F50) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E50,A50,D50) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F50,A50,D50) |
| 51  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*3/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A51,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A51,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A51,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A51,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A51,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A51,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B51,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B51,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B51,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B51,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B51,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B51,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B51,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B51,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B51,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B51,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B51,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B51,BOT_Uod)) | =A51+(BOT_Pmax-A51)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C51,PO.PVT.Co.UnSat.ByVasquezBeggs(B51,BOT_SGg,BOT_API,BOT_T,E51),A51,E51) | =PO.PVT.Bo.UnSat.ByDefinition(C51,PO.PVT.Co.UnSat.ByVasquezBeggs(B51,BOT_SGg,BOT_API,BOT_T,F51),A51,F51) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E51,A51,D51) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F51,A51,D51) |
| 52  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*4/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A52,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A52,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A52,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A52,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A52,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A52,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B52,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B52,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B52,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B52,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B52,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B52,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B52,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B52,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B52,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B52,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B52,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B52,BOT_Uod)) | =A52+(BOT_Pmax-A52)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C52,PO.PVT.Co.UnSat.ByVasquezBeggs(B52,BOT_SGg,BOT_API,BOT_T,E52),A52,E52) | =PO.PVT.Bo.UnSat.ByDefinition(C52,PO.PVT.Co.UnSat.ByVasquezBeggs(B52,BOT_SGg,BOT_API,BOT_T,F52),A52,F52) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E52,A52,D52) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F52,A52,D52) |
| 53  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*5/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A53,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A53,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A53,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A53,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A53,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A53,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B53,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B53,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B53,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B53,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B53,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B53,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B53,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B53,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B53,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B53,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B53,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B53,BOT_Uod)) | =A53+(BOT_Pmax-A53)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C53,PO.PVT.Co.UnSat.ByVasquezBeggs(B53,BOT_SGg,BOT_API,BOT_T,E53),A53,E53) | =PO.PVT.Bo.UnSat.ByDefinition(C53,PO.PVT.Co.UnSat.ByVasquezBeggs(B53,BOT_SGg,BOT_API,BOT_T,F53),A53,F53) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E53,A53,D53) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F53,A53,D53) |
| 54  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*6/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A54,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A54,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A54,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A54,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A54,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A54,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B54,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B54,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B54,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B54,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B54,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B54,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B54,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B54,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B54,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B54,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B54,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B54,BOT_Uod)) | =A54+(BOT_Pmax-A54)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C54,PO.PVT.Co.UnSat.ByVasquezBeggs(B54,BOT_SGg,BOT_API,BOT_T,E54),A54,E54) | =PO.PVT.Bo.UnSat.ByDefinition(C54,PO.PVT.Co.UnSat.ByVasquezBeggs(B54,BOT_SGg,BOT_API,BOT_T,F54),A54,F54) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E54,A54,D54) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F54,A54,D54) |
| 55  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*7/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A55,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A55,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A55,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A55,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A55,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A55,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B55,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B55,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B55,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B55,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B55,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B55,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B55,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B55,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B55,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B55,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B55,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B55,BOT_Uod)) | =A55+(BOT_Pmax-A55)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C55,PO.PVT.Co.UnSat.ByVasquezBeggs(B55,BOT_SGg,BOT_API,BOT_T,E55),A55,E55) | =PO.PVT.Bo.UnSat.ByDefinition(C55,PO.PVT.Co.UnSat.ByVasquezBeggs(B55,BOT_SGg,BOT_API,BOT_T,F55),A55,F55) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E55,A55,D55) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F55,A55,D55) |
| 56  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*8/9                                                                                                                     | =MIN(BOT_Rsb,CHOOSE(BOT_RsCorr,PO.PVT.Rs.ByStanding(BOT_SGg,BOT_API,A56,BOT_T),PO.PVT.Rs.ByVasquezBeggs(BOT_SGg,BOT_API,A56,BOT_T),PO.PVT.Rs.ByGlaso(BOT_SGg,BOT_API,A56,BOT_T),PO.PVT.Rs.ByAlMarhoun(BOT_SGg,BOT_API,A56,BOT_T),PO.PVT.Rs.ByPetroskyFarshad(BOT_SGg,BOT_API,A56,BOT_T),PO.PVT.Rs.ByDindorukChristman(BOT_SGg,BOT_API,A56,BOT_T)))                             | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B56,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B56,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B56,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B56,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B56,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B56,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B56,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B56,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B56,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B56,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B56,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B56,BOT_Uod)) | =A56+(BOT_Pmax-A56)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C56,PO.PVT.Co.UnSat.ByVasquezBeggs(B56,BOT_SGg,BOT_API,BOT_T,E56),A56,E56) | =PO.PVT.Bo.UnSat.ByDefinition(C56,PO.PVT.Co.UnSat.ByVasquezBeggs(B56,BOT_SGg,BOT_API,BOT_T,F56),A56,F56) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E56,A56,D56) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F56,A56,D56) |
| 57  | =BOT_Pmin+(BOT_Pb-BOT_Pmin)*9/9                                                                                                                     | =BOT_Rsb                                                                                                                                                                                                                                                                                                                                                                       | =CHOOSE(BOT_BoCorr,PO.PVT.Bo.Sat.ByStanding(BOT_SGg,BOT_API,B57,BOT_T),PO.PVT.Bo.Sat.ByVasquezBeggs(BOT_SGg,BOT_API,B57,BOT_T),PO.PVT.Bo.Sat.ByGlaso(BOT_SGg,BOT_API,B57,BOT_T),PO.PVT.Bo.Sat.ByAlMarhoun(BOT_SGg,BOT_API,B57,BOT_T),PO.PVT.Bo.Sat.ByPetrosky(BOT_SGg,BOT_API,B57,BOT_T),PO.PVT.Bo.Sat.ByDindorukChristman(BOT_SGg,BOT_API,B57,BOT_T))                                                                                         | =CHOOSE(BOT_UoCorr,PO.PVT.Uo.Sat.ByBeggsRobinson(B57,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B57,BOT_Uod),PO.PVT.Uo.Sat.ByBeggsRobinson(B57,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B57,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B57,BOT_Uod),PO.PVT.Uo.Sat.ByChewConnally(B57,BOT_Uod)) | =A57+(BOT_Pmax-A57)/2                                                                                                            | =BOT_Pmax                                                                                                                                                                                                                                                                                                    | =PO.PVT.Bo.UnSat.ByDefinition(C57,PO.PVT.Co.UnSat.ByVasquezBeggs(B57,BOT_SGg,BOT_API,BOT_T,E57),A57,E57) | =PO.PVT.Bo.UnSat.ByDefinition(C57,PO.PVT.Co.UnSat.ByVasquezBeggs(B57,BOT_SGg,BOT_API,BOT_T,F57),A57,F57) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(E57,A57,D57) | =PO.PVT.Uo.UnSat.ByVasquezBeggs(F57,A57,D57) |
| 59  | PVTO, Copy-Ready                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 60  | Copy the keyword column from PVTO to the closing slash. Each record ends in a slash. FIELD units: Rs in Mscf/STB.                                   |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 61  | Rs (Mscf/STB)                                                                                                                                       | Pressure (psia)                                                                                                                                                                                                                                                                                                                                                                | Bo (rb/STB)                                                                                                                                                                                                                                                                                                                                                                                                                                    | μo (cp)                                                                                                                                                                                                                                                                            | End                                                                                                                              | Keyword text                                                                                                                                                                                                                                                                                                 |                                                                                                          |                                                                                                          |                                              |                                              |
| 62  |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  | PVTO                                                                                                                                                                                                                                                                                                         |                                                                                                          |                                                                                                          |                                              |                                              |
| 63  |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  | -- Rs Mscf/STB, Pbub psia, Bo rb/STB, Vo cp                                                                                                                                                                                                                                                                  |                                                                                                          |                                                                                                          |                                              |                                              |
| 64  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A64),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A64),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A64),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A64),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A64),COLUMNS($A$64:E$64)) | =IF(B64="","",IF(A64="","         ",FIXED(A64,5,TRUE))&"  "&FIXED(B64,1,TRUE)&"  "&FIXED(C64,5,TRUE)&"  "&FIXED(D64,4,TRUE)&IF(E64="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 65  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A65),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A65),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A65),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A65),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A65),COLUMNS($A$64:E$64)) | =IF(B65="","",IF(A65="","         ",FIXED(A65,5,TRUE))&"  "&FIXED(B65,1,TRUE)&"  "&FIXED(C65,5,TRUE)&"  "&FIXED(D65,4,TRUE)&IF(E65="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 66  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A66),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A66),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A66),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A66),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A66),COLUMNS($A$64:E$64)) | =IF(B66="","",IF(A66="","         ",FIXED(A66,5,TRUE))&"  "&FIXED(B66,1,TRUE)&"  "&FIXED(C66,5,TRUE)&"  "&FIXED(D66,4,TRUE)&IF(E66="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 67  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A67),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A67),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A67),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A67),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A67),COLUMNS($A$64:E$64)) | =IF(B67="","",IF(A67="","         ",FIXED(A67,5,TRUE))&"  "&FIXED(B67,1,TRUE)&"  "&FIXED(C67,5,TRUE)&"  "&FIXED(D67,4,TRUE)&IF(E67="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 68  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A68),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A68),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A68),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A68),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A68),COLUMNS($A$64:E$64)) | =IF(B68="","",IF(A68="","         ",FIXED(A68,5,TRUE))&"  "&FIXED(B68,1,TRUE)&"  "&FIXED(C68,5,TRUE)&"  "&FIXED(D68,4,TRUE)&IF(E68="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 69  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A69),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A69),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A69),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A69),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A69),COLUMNS($A$64:E$64)) | =IF(B69="","",IF(A69="","         ",FIXED(A69,5,TRUE))&"  "&FIXED(B69,1,TRUE)&"  "&FIXED(C69,5,TRUE)&"  "&FIXED(D69,4,TRUE)&IF(E69="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 70  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A70),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A70),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A70),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A70),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A70),COLUMNS($A$64:E$64)) | =IF(B70="","",IF(A70="","         ",FIXED(A70,5,TRUE))&"  "&FIXED(B70,1,TRUE)&"  "&FIXED(C70,5,TRUE)&"  "&FIXED(D70,4,TRUE)&IF(E70="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 71  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A71),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A71),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A71),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A71),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A71),COLUMNS($A$64:E$64)) | =IF(B71="","",IF(A71="","         ",FIXED(A71,5,TRUE))&"  "&FIXED(B71,1,TRUE)&"  "&FIXED(C71,5,TRUE)&"  "&FIXED(D71,4,TRUE)&IF(E71="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 72  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A72),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A72),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A72),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A72),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A72),COLUMNS($A$64:E$64)) | =IF(B72="","",IF(A72="","         ",FIXED(A72,5,TRUE))&"  "&FIXED(B72,1,TRUE)&"  "&FIXED(C72,5,TRUE)&"  "&FIXED(D72,4,TRUE)&IF(E72="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 73  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A73),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A73),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A73),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A73),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A73),COLUMNS($A$64:E$64)) | =IF(B73="","",IF(A73="","         ",FIXED(A73,5,TRUE))&"  "&FIXED(B73,1,TRUE)&"  "&FIXED(C73,5,TRUE)&"  "&FIXED(D73,4,TRUE)&IF(E73="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 74  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A74),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A74),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A74),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A74),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A74),COLUMNS($A$64:E$64)) | =IF(B74="","",IF(A74="","         ",FIXED(A74,5,TRUE))&"  "&FIXED(B74,1,TRUE)&"  "&FIXED(C74,5,TRUE)&"  "&FIXED(D74,4,TRUE)&IF(E74="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 75  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A75),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A75),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A75),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A75),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A75),COLUMNS($A$64:E$64)) | =IF(B75="","",IF(A75="","         ",FIXED(A75,5,TRUE))&"  "&FIXED(B75,1,TRUE)&"  "&FIXED(C75,5,TRUE)&"  "&FIXED(D75,4,TRUE)&IF(E75="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 76  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A76),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A76),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A76),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A76),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A76),COLUMNS($A$64:E$64)) | =IF(B76="","",IF(A76="","         ",FIXED(A76,5,TRUE))&"  "&FIXED(B76,1,TRUE)&"  "&FIXED(C76,5,TRUE)&"  "&FIXED(D76,4,TRUE)&IF(E76="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 77  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A77),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A77),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A77),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A77),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A77),COLUMNS($A$64:E$64)) | =IF(B77="","",IF(A77="","         ",FIXED(A77,5,TRUE))&"  "&FIXED(B77,1,TRUE)&"  "&FIXED(C77,5,TRUE)&"  "&FIXED(D77,4,TRUE)&IF(E77="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 78  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A78),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A78),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A78),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A78),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A78),COLUMNS($A$64:E$64)) | =IF(B78="","",IF(A78="","         ",FIXED(A78,5,TRUE))&"  "&FIXED(B78,1,TRUE)&"  "&FIXED(C78,5,TRUE)&"  "&FIXED(D78,4,TRUE)&IF(E78="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 79  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A79),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A79),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A79),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A79),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A79),COLUMNS($A$64:E$64)) | =IF(B79="","",IF(A79="","         ",FIXED(A79,5,TRUE))&"  "&FIXED(B79,1,TRUE)&"  "&FIXED(C79,5,TRUE)&"  "&FIXED(D79,4,TRUE)&IF(E79="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 80  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A80),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A80),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A80),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A80),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A80),COLUMNS($A$64:E$64)) | =IF(B80="","",IF(A80="","         ",FIXED(A80,5,TRUE))&"  "&FIXED(B80,1,TRUE)&"  "&FIXED(C80,5,TRUE)&"  "&FIXED(D80,4,TRUE)&IF(E80="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 81  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A81),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A81),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A81),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A81),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A81),COLUMNS($A$64:E$64)) | =IF(B81="","",IF(A81="","         ",FIXED(A81,5,TRUE))&"  "&FIXED(B81,1,TRUE)&"  "&FIXED(C81,5,TRUE)&"  "&FIXED(D81,4,TRUE)&IF(E81="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 82  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A82),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A82),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A82),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A82),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A82),COLUMNS($A$64:E$64)) | =IF(B82="","",IF(A82="","         ",FIXED(A82,5,TRUE))&"  "&FIXED(B82,1,TRUE)&"  "&FIXED(C82,5,TRUE)&"  "&FIXED(D82,4,TRUE)&IF(E82="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 83  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A83),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A83),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A83),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A83),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A83),COLUMNS($A$64:E$64)) | =IF(B83="","",IF(A83="","         ",FIXED(A83,5,TRUE))&"  "&FIXED(B83,1,TRUE)&"  "&FIXED(C83,5,TRUE)&"  "&FIXED(D83,4,TRUE)&IF(E83="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 84  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A84),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A84),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A84),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A84),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A84),COLUMNS($A$64:E$64)) | =IF(B84="","",IF(A84="","         ",FIXED(A84,5,TRUE))&"  "&FIXED(B84,1,TRUE)&"  "&FIXED(C84,5,TRUE)&"  "&FIXED(D84,4,TRUE)&IF(E84="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 85  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A85),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A85),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A85),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A85),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A85),COLUMNS($A$64:E$64)) | =IF(B85="","",IF(A85="","         ",FIXED(A85,5,TRUE))&"  "&FIXED(B85,1,TRUE)&"  "&FIXED(C85,5,TRUE)&"  "&FIXED(D85,4,TRUE)&IF(E85="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 86  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A86),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A86),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A86),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A86),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A86),COLUMNS($A$64:E$64)) | =IF(B86="","",IF(A86="","         ",FIXED(A86,5,TRUE))&"  "&FIXED(B86,1,TRUE)&"  "&FIXED(C86,5,TRUE)&"  "&FIXED(D86,4,TRUE)&IF(E86="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 87  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A87),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A87),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A87),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A87),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A87),COLUMNS($A$64:E$64)) | =IF(B87="","",IF(A87="","         ",FIXED(A87,5,TRUE))&"  "&FIXED(B87,1,TRUE)&"  "&FIXED(C87,5,TRUE)&"  "&FIXED(D87,4,TRUE)&IF(E87="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 88  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A88),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A88),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A88),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A88),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A88),COLUMNS($A$64:E$64)) | =IF(B88="","",IF(A88="","         ",FIXED(A88,5,TRUE))&"  "&FIXED(B88,1,TRUE)&"  "&FIXED(C88,5,TRUE)&"  "&FIXED(D88,4,TRUE)&IF(E88="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 89  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A89),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A89),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A89),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A89),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A89),COLUMNS($A$64:E$64)) | =IF(B89="","",IF(A89="","         ",FIXED(A89,5,TRUE))&"  "&FIXED(B89,1,TRUE)&"  "&FIXED(C89,5,TRUE)&"  "&FIXED(D89,4,TRUE)&IF(E89="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 90  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A90),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A90),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A90),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A90),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A90),COLUMNS($A$64:E$64)) | =IF(B90="","",IF(A90="","         ",FIXED(A90,5,TRUE))&"  "&FIXED(B90,1,TRUE)&"  "&FIXED(C90,5,TRUE)&"  "&FIXED(D90,4,TRUE)&IF(E90="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 91  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A91),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A91),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A91),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A91),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A91),COLUMNS($A$64:E$64)) | =IF(B91="","",IF(A91="","         ",FIXED(A91,5,TRUE))&"  "&FIXED(B91,1,TRUE)&"  "&FIXED(C91,5,TRUE)&"  "&FIXED(D91,4,TRUE)&IF(E91="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 92  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A92),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A92),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A92),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A92),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A92),COLUMNS($A$64:E$64)) | =IF(B92="","",IF(A92="","         ",FIXED(A92,5,TRUE))&"  "&FIXED(B92,1,TRUE)&"  "&FIXED(C92,5,TRUE)&"  "&FIXED(D92,4,TRUE)&IF(E92="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 93  | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A93),COLUMNS($A$64:A$64))                    | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A93),COLUMNS($A$64:B$64))                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A93),COLUMNS($A$64:C$64))                                                                                                                                                                                                                                                                                                               | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A93),COLUMNS($A$64:D$64))                                                                                                                                                   | =INDEX(PO.PVT.Table.PVTO(BOT_SatRs,BOT_SatP,BOT_SatBo,BOT_SatUo,BOT_BrP,BOT_BrBo,BOT_BrUo),ROWS($A$64:$A93),COLUMNS($A$64:E$64)) | =IF(B93="","",IF(A93="","         ",FIXED(A93,5,TRUE))&"  "&FIXED(B93,1,TRUE)&"  "&FIXED(C93,5,TRUE)&"  "&FIXED(D93,4,TRUE)&IF(E93="/"," /",""))                                                                                                                                                             |                                                                                                          |                                                                                                          |                                              |                                              |
| 94  |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  | /                                                                                                                                                                                                                                                                                                            |                                                                                                          |                                                                                                          |                                              |                                              |
| 95  | PVDG, Copy-Ready (Dry Gas)                                                                                                                          |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 96  | The separator gas by Sutton's pseudo-criticals, DAK's Z, Bg by definition and Lee-Gonzalez-Eakin's μg, on twelve pressures of the grid.             |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 97  | Pressure (psia)                                                                                                                                     | Z (—)                                                                                                                                                                                                                                                                                                                                                                          | Bg (rb/Mscf)                                                                                                                                                                                                                                                                                                                                                                                                                                   | μg (cp)                                                                                                                                                                                                                                                                            | Keyword text                                                                                                                     |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 98  |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    | PVDG                                                                                                                             |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 99  |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    | -- P psia, Bg rb/Mscf, Vg cp                                                                                                     |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 100 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*0/11                                                                                                                  | =PO.PVT.Z.ByDAK(A100/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A100,BOT_TR,B100)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B100,BOT_SGg,A100,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A100,1,TRUE)&"  "&FIXED(C100,5,TRUE)&"  "&FIXED(D100,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 101 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*1/11                                                                                                                  | =PO.PVT.Z.ByDAK(A101/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A101,BOT_TR,B101)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B101,BOT_SGg,A101,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A101,1,TRUE)&"  "&FIXED(C101,5,TRUE)&"  "&FIXED(D101,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 102 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*2/11                                                                                                                  | =PO.PVT.Z.ByDAK(A102/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A102,BOT_TR,B102)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B102,BOT_SGg,A102,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A102,1,TRUE)&"  "&FIXED(C102,5,TRUE)&"  "&FIXED(D102,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 103 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*3/11                                                                                                                  | =PO.PVT.Z.ByDAK(A103/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A103,BOT_TR,B103)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B103,BOT_SGg,A103,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A103,1,TRUE)&"  "&FIXED(C103,5,TRUE)&"  "&FIXED(D103,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 104 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*4/11                                                                                                                  | =PO.PVT.Z.ByDAK(A104/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A104,BOT_TR,B104)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B104,BOT_SGg,A104,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A104,1,TRUE)&"  "&FIXED(C104,5,TRUE)&"  "&FIXED(D104,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 105 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*5/11                                                                                                                  | =PO.PVT.Z.ByDAK(A105/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A105,BOT_TR,B105)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B105,BOT_SGg,A105,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A105,1,TRUE)&"  "&FIXED(C105,5,TRUE)&"  "&FIXED(D105,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 106 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*6/11                                                                                                                  | =PO.PVT.Z.ByDAK(A106/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A106,BOT_TR,B106)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B106,BOT_SGg,A106,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A106,1,TRUE)&"  "&FIXED(C106,5,TRUE)&"  "&FIXED(D106,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 107 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*7/11                                                                                                                  | =PO.PVT.Z.ByDAK(A107/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A107,BOT_TR,B107)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B107,BOT_SGg,A107,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A107,1,TRUE)&"  "&FIXED(C107,5,TRUE)&"  "&FIXED(D107,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 108 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*8/11                                                                                                                  | =PO.PVT.Z.ByDAK(A108/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A108,BOT_TR,B108)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B108,BOT_SGg,A108,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A108,1,TRUE)&"  "&FIXED(C108,5,TRUE)&"  "&FIXED(D108,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 109 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*9/11                                                                                                                  | =PO.PVT.Z.ByDAK(A109/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A109,BOT_TR,B109)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B109,BOT_SGg,A109,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A109,1,TRUE)&"  "&FIXED(C109,5,TRUE)&"  "&FIXED(D109,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 110 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*10/11                                                                                                                 | =PO.PVT.Z.ByDAK(A110/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A110,BOT_TR,B110)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B110,BOT_SGg,A110,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A110,1,TRUE)&"  "&FIXED(C110,5,TRUE)&"  "&FIXED(D110,5,TRUE)                                                              |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 111 | =BOT_Pmin+(BOT_Pmax-BOT_Pmin)*11/11                                                                                                                 | =PO.PVT.Z.ByDAK(A111/BOT_Ppc,BOT_TR/BOT_Tpc)                                                                                                                                                                                                                                                                                                                                   | =PO.PVT.Bg.ByDefinition(A111,BOT_TR,B111)*BOT_Mscf/BOT_Ft3Bbl                                                                                                                                                                                                                                                                                                                                                                                  | =PO.PVT.Ug.ByLGE(B111,BOT_SGg,A111,BOT_TR)                                                                                                                                                                                                                                         | =FIXED(A111,1,TRUE)&"  "&FIXED(C111,5,TRUE)&"  "&FIXED(D111,5,TRUE)&" /"                                                         |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 113 | PVTW, Copy-Ready                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 114 | McCain's Bw and μw and Osif's Cw at Pref; the viscosibility is a central difference of μw over ±100 psi.                                            |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  |                                                                                                                                                                                                                                                                                                              |                                                                                                          |                                                                                                          |                                              |                                              |
| 115 | Pref (psia)                                                                                                                                         | Bw (rb/STB)                                                                                                                                                                                                                                                                                                                                                                    | Cw (1/psi)                                                                                                                                                                                                                                                                                                                                                                                                                                     | μw (cp)                                                                                                                                                                                                                                                                            | Cv (1/psi)                                                                                                                       | Keyword text                                                                                                                                                                                                                                                                                                 |                                                                                                          |                                                                                                          |                                              |                                              |
| 116 |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  | PVTW                                                                                                                                                                                                                                                                                                         |                                                                                                          |                                                                                                          |                                              |                                              |
| 117 |                                                                                                                                                     |                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                |                                                                                                                                                                                                                                                                                    |                                                                                                                                  | -- Pref psia, Bw rb/STB, Cw 1/psi, Vw cp, Cv 1/psi                                                                                                                                                                                                                                                           |                                                                                                          |                                                                                                          |                                              |                                              |
| 118 | =BOT_Pref                                                                                                                                           | =BOT_BwRef                                                                                                                                                                                                                                                                                                                                                                     | =BOT_CwRef                                                                                                                                                                                                                                                                                                                                                                                                                                     | =BOT_UwRef                                                                                                                                                                                                                                                                         | =BOT_CvRef                                                                                                                       | =FIXED(A118,1,TRUE)&"  "&FIXED(B118,5,TRUE)&"  "&FIXED(C118/10^INT(LOG10(C118)),3,TRUE)&"E"&IF(INT(LOG10(C118))<0,"-","+")&RIGHT("0"&ABS(INT(LOG10(C118))),2)&"  "&FIXED(D118,4,TRUE)&"  "&FIXED(E118/10^INT(LOG10(E118)),3,TRUE)&"E"&IF(INT(LOG10(E118))<0,"-","+")&RIGHT("0"&ABS(INT(LOG10(E118))),2)&" /" |                                                                                                          |                                                                                                          |                                              |                                              |

## Lambdas

| Name | RefersTo | Comment |
|------|----------|---------|
| PO.PVT.Table.PVTO | =LAMBDA(Rs, Pb, Bo, Uo, Pu, Bou, Uou, LET(n, ROWS(Rs), m, COLUMNS(Pu), w, m + 1, MAKEARRAY(n * w, 5, LAMBDA(line, col, LET(i, INT((line - 1) / w) + 1, j, MOD(line - 1, w), more, IF(j = m, FALSE, ISNUMBER(INDEX(Pu, i, j + 1))), IF(j = 0, CHOOSE(col, INDEX(Rs, i) / 1000, INDEX(Pb, i), INDEX(Bo, i), INDEX(Uo, i), IF(more, "", "/")), IF(ISNUMBER(INDEX(Pu, i, j)), CHOOSE(col, "", INDEX(Pu, i, j), INDEX(Bou, i, j), INDEX(Uou, i, j), IF(more, "", "/")), ""))))))) | Eclipse PVTO records in field units from saturated rows (Rs scf/STB, Pb psia, Bo rb/STB, uo cp) and undersaturated branches (P, Bo, uo, a row per record): Rs in Mscf/STB, P, Bo, uo and "/" at each record's end, padded with "". |

## Names

| Name | RefersTo | Comment |
|------|----------|---------|
| BOT_SGg | $B$4 | Separator gas specific gravity, air = 1 |
| BOT_API | $B$5 | Stock-tank oil gravity, °API |
| BOT_T | $B$6 | Reservoir temperature, °F |
| BOT_Rsb | $B$7 | Solution GOR at the bubble point, Rsb, scf/STB |
| BOT_Pb | $B$8 | Bubble point, Pb (the lab's), psi |
| BOT_RsCorr | $B$10 | Rs correlation, 1 to 6 (1 = Standing) |
| BOT_BoCorr | $B$11 | Bo correlation, 1 to 6 (1 = Standing) |
| BOT_UoCorr | $B$12 | μo pair, 1 to 6 (6 = Glasø + Chew-Connally) |
| BOT_Pmin | $B$14 | Lowest pressure, the first PVTO record, psi |
| BOT_Pmax | $B$15 | Highest pressure, the end of every branch, psi |
| BOT_Pref | $B$16 | PVTW reference pressure (the initial pressure), psi |
| BOT_Sal | $B$17 | Formation water salinity, NaCl by weight, wt % |
| BOT_BrineDen | $B$18 | Brine density at standard conditions, g/cm³ |
| BOT_Inputs | $B$4:$B$18 | The oil's gas and stock-tank gravities, temperature, Rsb and bubble point; the Rs, Bo and μo correlations; the lowest and highest pressure, the PVTW reference pressure, and the water's salinity and density |
| BOT_R0 | $B$40 | Rankine at 0 °F, °R |
| BOT_Ft3Bbl | $B$41 | Cubic feet in a barrel, ft³/bbl |
| BOT_Mscf | $B$42 | scf in an Mscf, scf/Mscf |
| BOT_dPv | $B$43 | Pressure step for the water's viscosibility, psi |
| BOT_Corrs | $B$44 | Correlations listed for each of Rs, Bo and μo |
| BOT_Bob | $B$21 | Oil FVF at the bubble point, Bob, bbl/STB |
| BOT_Uod | $B$22 | Dead oil viscosity at T, cp |
| BOT_Uob | $B$23 | Oil viscosity at the bubble point, μob, cp |
| BOT_TR | $B$24 | Temperature, absolute, °R |
| BOT_Ppc | $B$25 | Gas pseudo-critical pressure (Sutton), psi |
| BOT_Tpc | $B$26 | Gas pseudo-critical temperature (Sutton), °R |
| BOT_SalGL | $B$27 | Salinity, NaCl per litre, g/L |
| BOT_Uw1 | $B$28 | Water viscosity at 1 atm and T (McCain), cp |
| BOT_BwRef | $B$29 | Water FVF at Pref, Bw (McCain), bbl/STB |
| BOT_CwRef | $B$30 | Water compressibility at Pref, Cw (Osif), 1/psi |
| BOT_UwRef | $B$31 | Water viscosity at Pref, μw (McCain), cp |
| BOT_CvRef | $B$32 | Water viscosibility at Pref, (dμw/dp)/μw, 1/psi |
| BOT_RsFirst | $B$33 | Rs of the first PVTO record, scf/STB |
| BOT_BoLast | $B$34 | Bo at the highest pressure, bubble-point record, bbl/STB |
| BOT_GridCheck | $B$35 | Grid check verdict |
| BOT_GridCheckNote | $C$35 | Grid check comment |
| BOT_PvtoCheck | $B$36 | PVTO check verdict |
| BOT_PvtoCheckNote | $C$36 | PVTO check comment |
| BOT_Results | $B$21:$B$36 | Bob, μod and μob by the chosen correlations; the absolute temperature and the gas's pseudo-criticals; the water's salinity, μw at 1 atm, and Bw, Cw, μw and viscosibility at Pref; the first record's Rs and the last branch's Bo; the grid and PVTO checks |
| BOT_Curve | $A$48:$J$57 | Each PVTO record's bubble point, Rs, Bo and μo, and its branch's two pressures with Bo and μo at each |
| BOT_SatP | $A$48:$A$57 | The records' bubble points, psi |
| BOT_SatRs | $B$48:$B$57 | The records' Rs, scf/STB |
| BOT_SatBo | $C$48:$C$57 | The records' saturated Bo, bbl/STB |
| BOT_SatUo | $D$48:$D$57 | The records' saturated μo, cp |
| BOT_BrP | $E$48:$F$57 | Branch pressures, psi |
| BOT_BrBo | $G$48:$H$57 | Branch Bo, bbl/STB |
| BOT_BrUo | $I$48:$J$57 | Branch μo, cp |
| BOT_PvtoText | $F$62:$F$94 | PVTO keyword text, copy-ready |
| BOT_PvdgText | $E$98:$E$111 | PVDG keyword text, copy-ready |
| BOT_PvtwText | $F$116:$F$118 | PVTW keyword text, copy-ready |

---

## Related Blueprints
- [PVT Correlation Match Against the Lab](/blueprint/po.pvt.correlation.match.md)
- [PVT Fluid Report Through Depletion](/blueprint/po.pvt.fluid.report.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)
- [Bubble Point by Regional Correlation](/blueprint/po.pvt.bubblepoint.regional.md)

